Find format document jobs

...Requirements: - Modern Design: The 3D beauty bed design should be modern, sleek, and elegant. (I have a picture of how I would like it to be) - Color Variations: The beauty bed should be available in black, white, pink, and cream. These colors need to be vibrant and suitable for a beauty bed. - Urgent Delivery: I am looking to get this done as soon as possible. The final deliverable will need to be in a format that I can easily edit on Canva. Therefore, please ensure that the files are compatible and easy to work with. Ideal Skills and Experience: - Proficiency in 3D design, specifically for beauty products - Experience with modern design aesthetics - Ability to deliver high-quality, editable files I look forward to receiving your bids and working with you. I am going to b...

...an AWS-savvy data engineer with a deep understanding of data transformation and integration. Key Requirements: - Expertise with AWS Glue: You'll be working extensively with AWS Glue, so prior experience with this service is essential. Knowledge of other AWS services like S3, EC2, and Lambda is a plus. - Data Transformation Skills: You will be responsible for transforming raw data into a usable format. Knowledge of best practices in this area is highly desirable. - CI/CD Pipeline Setup: Your assistance in setting up CI/CD pipelines using AWS CodePipeline is crucial for the project's success. Your tasks will include: 1. Utilizing AWS Glue for data transformation and integration. 2. Setting up CI/CD pipelines using AWS CodePipeline. 3. Collaborating with the team on data...

PLEASE READ THE ATTACHED DESIGN BRIEF! I'm seeking a talented logo designer to create a classic and elegant logo. I am using a competition so that I can find a talented designer to compelete the logo design. The aim is to have a logo that is not only visually appealing but also timeless and suitable for both online and print applications. I shall work with the best designers to make small changes before selecting the winning design. The winning designer will need to complete the design in web and print formats in pdf (vector), jpeg and ai. before receiving the prize money. Key Responsibilities: - Craft a classic and elegant logo that embodies our brand's essence as per the design brief attached - Ensure the logo is versatile and works well across both online and print...

I was trying to log into my Laravel application when I encountered the error 419. I need a skilled Laravel developer to help me review and fix session and token issues causing this error. When i loggin then succses then back that show 419 error Key requirements include: - Reviewing L...to identify the issue. - Fixing the session and token issues causing the error 419 specifically during the login process. Ideal candidates should: - Have extensive experience and understanding of Laravel's authentication and session management. - Be proficient in troubleshooting and resolving Laravel errors. - Be familiar with handling session and token issues in Laravel. Your goal will be to find and fix the root cause of the error and ensure that the login process works seamlessly without ...

...quotes, parts / inventory, archived jobs, and customer management. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to export completed jobs to CSV file for automated invoice generation in Quickbooks Online. We will also require the system to import the customer database from Quickbooks in CSV format. Key Functionalities: - Creation and Editing of Jobs - Ability to use system on-site / remotely through the use of iOS or Android web browsing. Some - Ability to select a simple job status from a drop-down combo box eg. In-progress, waiting for collection, waiting on parts, not started, completed. - Ability to search by customer, PO number, job status, date, part on both acti...

...Requirements Include: - Incorporating the name "Voilà" into the logo design - Conveying a sense of class and sophistication - Utilizing a color scheme of burgundy/champagne, or gold/ rose gold Skills and Experience: - Proficiency in color theory - Strong background in logo and brand design, especially for food-related businesses - Ability to capture the essence of a brand's identity in a visual format I look forward to seeing your portfolio and discussing potential designs for "Voilà". I have attached the logo I created, but I want something nicer, more catchy. I want to use my logo for Instagram profile, to add on my personal pastry photos, and also on stickers and packaging....

I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while maintaining layout integrity. - Attenti...

I need a professional translator to translate a document of 1,000 - 5,000 words from English to Spanish and French. Key Requirements: - Fluency in English, Spanish, and French - Proven experience in translation - Attention to detail and accuracy It's an advantage if you have experience in technical documentation, website content, or marketing materials, as these will help with the translation process. Please share samples of your previous work in your proposal.

I need assistance in copying text content from my smartphone and pasting it into the appropriate place. Key Requirements: - Copying text from my smartphone- The texts are not in a document but on my phone. A good understanding of how to copy and paste from a phone is essential. - Paste into the appropriate location- The text will need to be pasted into the correct place, whether it be a website, document, or elsewhere. Time Expectation: - I am looking for someone who can assist me part-time. This means the job doesn't need to be completed all at once. A longer-term arrangement is possible if the collaboration is successful. Ideal Skills: - Understanding of basic phone functions - Strong attention to detail - Ability to follow instructions accurately If you are int...

I'm seeking a skilled Python developer who can help me with a critical task: Translating PDFs. The challenge here is to make sure that the translated content in the PDFs maintains the exact same format and layout as the original documents, without any alterations. Key Requirements: - Translate both scanned and text-based PDFs/images: I need a professional who can handle both types of documents with equal proficiency. - Language Proficiency: The translation will be from English to a variety of languages. Your ability to work with any language from a dropdown menu is crucial. - High Accuracy: The translated content must retain the original meaning and context with 95+% accuracy. Ideal Skills and Experience: - Proficient in Python: You should have extensive experience using P...

I have a scanned PDF document that needs some alterations. The primary tasks include changing the company name and updating contact information. Your expertise in both text editing and formatting is crucial for this project. Key Tasks: - Change company name: The new name should be seamlessly integrated into the document, replacing the existing one. - Update contact information: The current contact details in the document need to be replaced with the new information provided. Skills and Experience Required: - Proficiency in PDF editing: Experience with editing text in scanned PDFs is necessary, as the document is not in its original format. - Attention to detail: It's essential that the changes are made accurately without affecting other parts of th...

Hello, Seeking a talented and creative music producer for my new mantra creation project, I am looking for a professional...We are looking for high-quality sound, both in the voice and instrumentation. I am looking for the complete creation of a mantra from start to finish. New/original song (copyright) + professional voice, high-quality recording (female or male) + instrumental with different instruments and good quality of sound + mixing and mastering Budget 50 $ I would be interested in receiving a copyright document to confirm that the created songs will be my property. I would also like to know the project rates and delivery times. This is a long-term project therefore we look for quality price since we must create a large amount of material. We are looking for quality pri...

I need a freelancer to convert my PDF file to a Word file using Word 2016. I'm looking for someone who can efficiently convert my PDF file into a Word document. The successful freelancer should: - Use Word 2016 (or newer) for the conversion - Ensure the document is accurately converted without any alterations to the original information - Possess strong attention to detail to ensure no information is lost or altered during the conversion Please include a detailed project proposal with your application.

I need a skilled individual to help me create a professional slide deck - the presentation is attached below and is titled Freelancer's Global Interview Standards The presentation is to be around 15 to 20 slides in length. I have highlighted in blue in the below presentation document, the titles I want you to focus on creating for the slide deck. Please feel free to use images wherever necessary. Key requirements: - Creating a visually-engaging, professional slide deck - Incorporating provided branding guidelines - Ensuring the slides are clear and concise - Good project management and communication skills, as I aim to be involved in the process to ensure it aligns with my vision

I'm looking to create a personal branding profile resume that can be used for various purposes including job applications, and online professional networking. Key Req...Requirements: - Transform my existing CV into a dynamic and well-designed profile resume. Ideal Skills and Experience: - Proficiency in and react js with tailwind CSS or bootstrap or Mui -use frame motion animations and dark and light theme - Proven track record in creating personal branding materials - Ability to translate traditional CV content into a more dynamic and engaging online format. Please note that due to the nature of this project, a solid understanding of personal branding and resume design for online profiles is crucial. check my cv at the attachment , one cv in details and other small on...

I am in search of a proficient writer to develop a book targeted at novice teachers. The central theme revolves around teacher empowerment. The selected writer should be able to present concepts in ...inspirational and motivational style. - Familiarity with the field of education, specifically teacher empowerment. - Exceptional ability to engage and inspire novice educators through writing. - Capacity to maintain reader engagement with compelling narrative style. The goal of this project is to create a comprehensive tool that will serve as a robust resource for novice teachers, helping them find their voice, build confidence, and master the art of effective teaching. This is not just a book about teacher empowerment, but a catalyst that inspires transformative change in the educati...

I have a PDF file that's a contract written in Arabic. I'm looking for someone who can convert it into a Microsoft Word document ( 12 PAGES ). Key Requirements: - Fluent in Arabic: The contract is written in Arabic so a good understanding of the language is necessary for accurate conversion. - Exact Formatting Match: It's important that the converted document looks exactly like the original PDF in terms of formatting. - Text and Layout Adjustments: The final Word document may need some text and layout adjustments to ensure it's professional and easy to read. Ideal Skills and Experience: - Proficiency in Arabic and English. - Experience in PDF to Word conversion. - Attention to detail for maintaining formatting. - Proficient in Microsoft Word. - Gr...

I am in need of a skilled professional who can design a custom Microsoft Word template for my company. This template will play a crucial role in the creation of documents aimed at our external clients. Key Requirements: - Microsoft Word Expertise: You must have a deep understanding of Microsoft Word’s functionalities and be able to create a fully custom template. - Design Skills: The template should not only be functional but also visually appealing and in line with our brand image. - Attention to Detail: It is crucial that the template is designed specifically for external client communications. - Communication: I require clear communication on the progress and any potential questions or issues that may arise. Please note that I will provide you with the specifications that the t...

Hello, I'm looking for someone who can assist me. The animation in the attached document shows boats within the iris of the eye. As I run a sports clinic, I would like to replace these boats with a sense of people winning, perhaps historical moments at championships that people recognize. The background is that I deal with both sports-specific injuries at my clinic and common ailments of regular individuals. The feeling to convey is that one can triumph over their troubles.

...in need of a Python expert, specializing in web scraping. I require someone who can proficiently extract data from various websites. The specifics of the data may vary from text content, images, links, to contact information. Your key responsibilities will include: - Writing effective and efficient Python scripts to scrape data - Ensuring the data is extracted accurately and in a structured format - Delivering the data in a timely manner The ideal candidate should have: - Proficient experience in Python and web scraping - A strong understanding of data extraction techniques - Proven experience in handling and parsing a variety of data types - Excellent communication skills and the ability to meet deadlines Please be prepared to provide examples of your previous work in web ...

We're seeking a detail-oriente...France. • Utilize various online resources, including: o Search engines (Google, Bing, etc.) o Social media platforms (Facebook, Instagram, LinkedIn) o Industry directories and publications (list specific resources if known) o Business databases (mention specific databases if known) • Gather and verify contact information (name, email, phone number) for each lead. • Compile lead data into a Excel format . Qualifications: • French reading and understanding - ONLY • Excellent research and data collection skills. • Proficiency in using online search tools and social media platforms. • Strong attention to detail and accuracy. • Ability to work independently and manage time effectively. • Familiarity with...

...of a skilled architect experienced in maximizing space utilization for a renovation project. I have two key areas in my residential property that require attention: - Living Room: I'm seeking creative solutions to better utilize the current space. - Bedroom: I need innovative designs to optimize the available space. - Bathrooms - I need ideas on how to make the bathrooms stylish I also need to find space to have a desk for home office. Finally I would need somone able to provide a light design Ideal skills for this job would include: - Proficiency in renovation architecture - Experience with residential projects - Strong understanding of space optimization techniques - Expertise in spatial planning and organization. Overall, the goal is to make these spaces more funct...

I have a significant number of handwritten documents that need to be typed. The typed content will be used for data analysis. Key Skills and Experience: - Proficiency in accurate typing - Experience in handling handwritten materials - Strong understanding of data analysis Your role will essentially involve transcribing the content from these handwritten documents into a digital format. It is crucial that the data is typed accurately and with minimal errors. The typed data will be used for analysis, so the freelancer should ensure that the content is easily readable and properly formatted for data analysis purposes. This project is ideal for someone who has experience with data entry, accuracy in typing, and understanding of the importance of clean data for analysis.

I'm looking for someone to convert a PDF document into a Word document. The main purpose of this conversion is to extract text from the PDF content which has complex formatting, including elements such as tables and footnotes. Key Requirements: - Accurate Extraction: The primary goal here is to ensure that all text is accurately extracted from the PDF file and transferred to the Word document without any loss or distortion. - Formatting Preservation: While the layout may be complex, I'm looking for the freelancer to maintain the font styles and sizes as they appear in the original document. The ideal candidate for this job would have: - Proficiency in PDF and Word processing tools - Experience with maintaining formatting during content transfer - At...

...Word Form document (tables filling 2 pages) that I'd like converted into a webpage form that users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including

...old WordPress site to a new WordPress site and a new theme. The new theme is already installed with a base configuration that includes the footer/widgets and header/navigation, so the only content that needs to be moved is the body of each page. There are a total of 5 static pages. - Copy content from and format it nicely on the above page. - Reorganize the page; the balance is off, the row and section spacing is off, and the typesetting is not standardized. - Reorganize the page; the balance is off, the row and section spacing is off, and the typesetting is not standardized.

I have a 5-10 minutes MP3 file that needs to be transcribed urgently. I need the transcription to be accurate and in a sheet format. Ideal Skills and Experience: - Proven experience in audio transcription - Ability to deliver high-quality work under tight deadlines - Proficiency with sheet formatting - Strong attention to detail This is an urgent project, so I am looking for someone who can start right away and deliver the transcription quickly. If you have the required skills and can meet this deadline, please bid on this project.

I am on the hunt for a creative and talented freelancer to design an engaging company profile in PowerPoint format. This content rich profile will contain detailed information such as our company's history, mission and vision, and the products and services we offer. Given that the target audience is our potential customers, skills in marketing and great understanding of customer demographics will be highly regarded. Proficiency in PowerPoint is a must along with the ability to convey complex information in an easy-to-understand manner. A background in corporate storytelling or alike will be a significant plus. Ideal skills include: - Expertise in PowerPoint - Brilliant storytelling abilities - Understanding of customer demographics - Background in Marketing or related fiel...

I am in need of a competent translator who can accurately transla...documents falls in the range of 600 to 1200 words. Key Requirements: - Fluent in English and Kurdish - Proven experience in professional translation - Familiarity with relevant language and terminology - Attention to detail and commitment to quality - Ability to meet deadlines Ideal Candidates: - Kurdish native speakers with a rich translation background - Professionals with experience in personal document translation - Individuals who can demonstrate their expertise in translating similar content Your role will be crucial in ensuring that the content is accurately conveyed, maintaining the original tone and meaning. If you have the necessary skills and experience, I would be delighted to discuss this opportunit...

I'm in need of an experienced translator who can convert a personal document written in Kurdish into English. The document is less than 5 pages long. Key Requirements: - Proficiency in both Kurdish and English - Experience with translating personal documents - Attention to detail Your translation must be accurate, preserving the original meaning and tone of the document. A background in a related field, such as legal or personal documents, would be a plus. Please provide samples of your previous Kurdish to English translation work.

I need a cabinet drawing created based on the attached detailed illustrations. Need to add some minor details (ventilation holes, eye bolt etc) to reflect the actual cabinet. The final deliverable should be as per attached example in PDF format. -Need done urgently by Today. -Final version to be provided in PDF format.

I have a large amount of text data that needs to be entered into a digital format. I'll provide you with the data and you'll have no specific deadline for this project.

I'm looking for a meticulous freelancer to retype my scanned documents into Microsoft Word. The documents contain both images and graphics which also need to be included in the Word file. Key requirements: - Retype scanned documents into Microsoft Word - Include all images and graphics in the Word file Formatting: - I need the final Word file to adhere to a specific template w...file. Key requirements: - Retype scanned documents into Microsoft Word - Include all images and graphics in the Word file Formatting: - I need the final Word file to adhere to a specific template which I will provide Ideal Freelancer: - Proficient in Microsoft Word - Attention to detail and accuracy - Experience with file conversion and manipulation - Ability to follow provided templates for document...

I have a large amount of text data that needs to be entered into a digital format. I'll provide you with the data and you'll have no specific deadline for this project.

Ready to take my technology startup to the next level, I am searching for an industry expert to create a purposeful business plan. The goal of this document is primed on securing funding and allows my business to achieve its desired growth. Key Components: - Solid Financial Projections: Focus on the finances, I need a clear outline of capital requirements and the utilization to be compelling to potential investors. - Comprehensive Business Model: Describe how our technology startup operates and generates revenue. Ideal Candidate: - Business plan writing experience specifically for startups in the technology industry. - Excellent financial modeling skills. - Proven record of creating successful funding business plans.

I'm seeking a professional to standardize and aesthetically enhance my existing PDF-based letters and proposals. including adding the attached flow chart in the document Key Points: - Standardization: The primary objective is to ensure all letters and proposals maintain a consistent and professional format. - Aesthetics: I aim to modernize the design of the documents while maintaining a minimalist style. - Required Elements: Each letter and proposal should contain a contact information section and a signature field. The ideal candidate for this project should have: - Expertise in PDF document creation and formatting - Strong graphic design skills, with a portfolio showcasing modern and minimalist aesthetics - Ability to enhance the current documents without dev...

I am seeking a qualified graphic designer to create a contemporary, mural/poster design utilizing my provided sketch and various images. The piece will be prominently used for information...piece will be prominently used for informational display on multiple platforms including a truck, a trailer, trade shows, and possibly our company's website. Key aspects of the project include: - Successfully incorporating my company's established colors. - Prudently arranging all the elements I provide to achieve an aesthetically pleasing layout. - The final design should be provided in JPEG format. Ideal candidates should have significant experience in graphic design particularly with a modern, minimalistic style. A strong portfolio showcasing past works of similar nature will be ...

I am currently in need of an experienced architect who specializes in commercial architectural design and construction document preparation. The perfect candidate for this project should be someone with: - Exceptional skills in architectural design, specifically for small-scale commercial projects (less than 5,000 sq.ft.) - Expertise in preparing detailed construction documents, including drawings, specifications, and contracts. - A proven track record of successful small commercial architectural projects would be a huge advantage Your input will be instrumental in generating compelling designs that make optimal use of space as well as preparing comprehensive construction documents for the build. Looking forward to your applications and architect portfolio.

...Requirement: • Fast Internet • American English Accent • Quality Microphone Ready to take your sales career to the next level? We are! How to Apply? (Do the Following to be considered, copy and paste the template below and use as your cover letter) 1. Record Your Voice: Read the following sales script with your voice: 2. Speed Test Goto: Change server to any Los Angeles, CA Server. Screenshot or link me to your test result. 3. Are you able to work in USA Time? (-8 PST) working 8am-4pm or 8am-5pm? 4. What is your Sales Experience and Website Design knowledge? 5. Are you able to make 100-200 calls per day? 6. Do

...a color palette that includes Green, Brown, and possibly Blue. These colors should be well-blended to represent the natural and professional aspect of the business. Primarily for: - Website: The logo will be predominantly used on the website, so it needs to be scalable and look great online. - Business Cards: It will also be printed on business cards, so the design should work well in a small format. - Signage: Lastly, it will be used on physical signage. The design should be impactful and visible from a distance. Ideal Skills & Experience: - Creative Logo Designer: Experience in creating nature-inspired and modern logos. - Graphic Design: Skills in using different color palettes to create a visually appealing design. - Branding: Understanding of how a logo can reflect th...

I'm looking for a graphic designer with substantial experience in PNG to vector conversions, to take a PNG logo and convert it into a high-quality vector file. Specifications: • Logo Format: The initial logo format is in PNG. • Vector Resolution: The preferred resolution for the vector conversion is 600 DPI. • Color Scheme: The logo should maintain its original color scheme after conversion. Ideal Skills: The successful candidate should have demonstrable skills in graphic design, with specific expertise in PNG to vector conversions. A keen eye for detail and creativity is highly desired. Previous work in logo conversions and a broad understanding of different color schemes will be advantageous. Applications without a portfolio will not be considered.

Hello Andre, sorry for replying this late. After reading your requirements, I can make a shorter version of your needs over here, to see if I'm understanding your request right or not: Objective: Redesign the input page for your users (manufacturers) to document their supply chain process, making it more user-friendly and easy to follow. Current Problem: The existing input page has become overly technical and difficult to navigate. Deliverables: Figma file for desktop and tablet view, that includes a high-quality design and all design components Style: Blue-ish color scheme, professional style If everything is correct, you can accept my proposal and I can start asap ?

I'm looking for a creative, talented musician who can develop an upbeat, catchy pop jingle for our NDIS provider company. The jingle should embody the services we offer and highlight the values of our company. A strong grasp on p...for our NDIS provider company. The jingle should embody the services we offer and highlight the values of our company. A strong grasp on pop music composition and prior experience in jingle composition would be ideal. Apart from music composition and lyrics writing, integration of the jingle into a radio format is important. Here's what I need: - Development of a catchy, upbeat pop jingle - Inclusion of our services and values in the lyrics - Conversion of jingle to acceptable radio format Please, only bid if you've got the ski...

I need a wizard in Microsoft Word for a particular job. The task requires fixing issues related to page numbering and the table of contents in my document. Here's what you need to do: - The documents appear to have page numbering inconsistencies which require correction. - The table of contents needs to be arranged with numerical page numbers. It is worth noting that the document does not follow any specific style guide or template. So, a general understanding of Microsoft Word formatting rules is necessary. Ideal candidates should have: - Mastery in Microsoft Word - Experience in troubleshooting and fixing Word formatting issues - Understanding of different formatting styles (although the work does not require adherence to a specific style guide) This is a quick fix...

Website Development for Education Purpose - I am looking for a developer to create a website for education purposes. - The website will primarily be used for uploading question papers in PDF format and providing a student login dashboard. - I prefer the website to be developed on WordPress. - The key functionalities I require are user registration and login. - Additionally, I would like the ability to upload and download content, as well as an interactive dashboard. _Conducting online quiz with ranking and candidate wise SWOT analysis. Ideal Skills and Experience: - Proficiency in WordPress development - Experience in creating user registration and login systems - Ability to implement content upload and download features - Knowledge of creating interactive dashboards - Fa...

Objective of the project The goal of the project is to develop an automated system that generates high-quality content related to beauty, cosmetics, skin and hair products, and makeup. This system must: Collect content from various sources (URL, RSS, XML) configurable by a Super User. Filter and process such content using artificial intelligence (AI) to impro...various social networks. Provide an intuitive administration panel for managing system sources and configurations. Technologies and Tools Used Backend: Django Frontend: React Database: MySQL or PostgreSQL Monitoring: Prometheus and Grafana Containers and Orchestration: Docker and Kubernetes This project is already validated by AI tools to correct errors in the part described in the technical document, so the development is...

I just need a very easy task. Change the style for 6 docs with some pages. Need to be done NOW And the budget for the all task is 5$ . if you read the proposal you need to write You need to write at the beginning of the text what your city is and what the color of the sky is now. Skills Required

We are seeking experienced lead generation professionals to assist in identifying companies raising equity capital for a growing company over the next 3-6 months. Ideal candidates will have a strong background in financial services and...well-researched leads in specific industries. 2. Retainer: £1000 per month. PROCESS 1. Lead Research: Identify and research potential leads. 2. Email Outreach: Send emails to prospects. 3. Response Handling: Forward prospect responses to the business developer. 4. Scheduling: The business developer will schedule and conduct the sales calls. 5. Data Management: Upload researched data to our CRM in Excel format to ensure no duplications. If you are a driven lead generation professional with the required experience and skills, we would love to...

I'm seeking skilled 3D modelers to undertake a project involving creating characters, buildings, and objects. *File format requirement*: The rendered 3D models should be delivered in OBJ format. *Texturing and Coloring*: I require both texturing and coloring for all models in full detail. Candidates with significant experience in similar projects and who can deliver professional-grade 3D models will be prioritized. Please share your portfolio of past work while bidding. I look forward to successful collaborations!

I just need a very easy task. Change the style for 6 docs with 3 pages. Need to be done NOW And the budget for the all task is 5$ . if you read the proposal you need to write You need to write at the beginning of the text what your city is and what the color of the sky is now.