Find most recent date for id with multiple records in excel sheet jobs

I'm looking for a skilled freelancer to create a mantra chart in Excel. This will be a presentation-worthy document, so I'm keen on ensuring that it's well-structured and visually appealing. Key Requirements: - Incorporating text, numbers, and dates into the chart - The chart should feature less than 10 mantras - Ensuring the final output is suitable for professional presentation The task will require someone with excellent Excel skills and an eye for design. A good understanding of data representation would be a big plus. You can expect detailed instructions and guidance from me throughout the project. Feel free to ask any clarifications you might need.

...established cyber company, I am looking for a skilled web developer to create an lead generating and informational platform for our business. This website will serve as our primary tool for selling our services and solutions online. Key Features: - The most crucial feature of this website will be the Contact Form. It is vital that potential clients can easily reach out to us with queries or service requests. Products/Services: - The primary focus of the website will be to sell our services and solutions. Therefore, the website needs to be designed in a way that effectively showcases our services and solutions and makes it easy for customers to engage with them. Ideal Skills & Experience: - Proficiency in lead gener...

... The script should be designed for personal use and should function as follows: - Verify Identity Using Facial Features: I need the script to accurately identify the face through the camera and ensure that the right person is in front of it. This is a crucial functionality for the script. - Desktop Application: The face recognition script should be developed as a desktop application. It should be user-friendly and easily accessible on Windows. I'm looking for a freelancer who has experience in creating face recognition scripts. Proper understanding of machine learning, computer vision, and security protocols will be a plus. Your proposal should include previous projects you have worked on that are similar to this one. Also, please state your ti...

We are seeking a skilled AI developer to create a custom AI script capable of generating answers based on specific datasets for multiple products. This AI model will provide accurate responses using only the data provided for each product. If the model cannot find a matching answer, it should prompt the user to contact us for further assistance.

...an AI research assistant web application. As a Front-End Web Developer, you will be responsible for creating and maintaining a user-friendly web interface for Bayard, enhancing the accessibility and usability of the application. Responsibilities: - Collaborate with the Bayard development team to design and implement a responsive and intuitive web interface for the AI research assistant. - Develop clean, maintainable, and efficient front-end code using modern web technologies such as HTML, CSS, and JavaScript. - Integrate the front-end with the back-end API endpoints to enable seamless communication and data exchange. - Optimize the web interface for performance, ensuring fast loading times and smooth user interactions. - Implement user authe...

I am in need of a skilled UI-UX designer to overhaul the design and experience of our existing cashback and coupons website. The target audience for our platform consists of tech-savvy individuals and budget-conscious shoppers. The improvements we're looking for are: - Enhanced navigation: The current website's navigation is not smooth and as intuitive as we'd like. The new design should make it easier for users to find what they need without much effort. - Modernized visual design: Our platform needs a fresh and appealing look that resonates with our audience. This includes updating the color scheme, typography, and overall visual aesthetics. - Improved user-friendliness: The user experience on our site needs to be seamless, effi...

We are seeking a skilled AI developer to create a custom AI script capable of generating answers based on specific datasets for multiple products. This AI model will provide accurate responses using only the data provided for each product. If the model cannot find a matching answer, it should prompt the user to contact us for further assistance.

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

I'm looking for skilled website developers to create a rental business website for me. The site will be specifically tailored for rental businesses. Responsive website for mobile devices Functionalities: - Booking and reservation system: This is a core feature of the website. Users should be able to easily book and reserve products/services. - Availability calendar: A must-have feature. Customers need to be able to see available slots or products. - User reviews/ratings: Essential for building trust and reliability among customers. Payment Integration: - Credit card, PayPal, Cryptocurrency: These are the primary payment methods I'd like to integrate. - Cash on site: I'd also like to incorporate a cash payment option for users wh...

I am looking for an expert in Python programming to assist me in the creation of a multi-timeframe indicator merge. The project entails the merger of the 4hr, 1hr, 15min, and 5 min timeframes while including specific indicators, namely Moving Average, Relative Strength Index (RSI), ADX, and Webslingers. To make informed bids, it's important to note the following: Ideal Skills & Experience: - Extensive knowledge in Python programming - Proven experience in financial analytics - Expertise in working with listed indicators Project Requirements: - Code the multiple timeframes using Python - Integrate the Moving Average, RSI, ADX, and Webslingers indicators - Generate the deliverable output as a CSV file Please feel free to in...

I'm in need of a minimalist styled logo and intro suitable for a YouTube gaming channel. - The logo should be designed in a minimalist style, keeping it simple yet intriguing. - Incorporate black and white color scheme into the logo design. Potential use of purple/teal is requested, tying it back to the colors of a magpie. - In addition to the logo, a brief channel intro is also required, likely featuring the aforementioned logo. Freelancers with prior experience in graphic design, video creation, and a clear understanding of the gaming culture will be most suitable. Please include samples of your work in your proposal.

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.

I'm in need of a multi-user web portal that will facilitate the connection between trainers and students. The portal will have the following features: - **Multi-Login System**: There needs to be a seamless and secure multi-login system to accommodate both trainers and students. - **Search Functionality**: Users should be able to search for trainers or classes based on the city or trainer's name. This will make it easy for students to find trainers that are close to them or whom they may have heard of. - **User Profiles**: Each trainer or class should have a detailed profile which includes: - Biography: A brief description of the trainer and their training methods. - Reviews and Ratings: Users should be able to rate and write reviews about the ...

I am looking for a PHP Prestashop developer expert. Ideal skills and experience for this job include: - Strong proficiency in PHP and Prestashop - Experience with PayPal module customization and integration - Knowledge of Prestashop Multishop feature - Familiarity with coding for extra security measures and user interface improvements TASK 1 Reset Prestashop database. Setup on new. (Google cloud server) 1. Clean the prestashop directory, CMS pages and empty links. 2. Make a backup of the current Prestashop database including clients, orders, products, pictures, CMS pages all other information needed for a full reset. 3. Upload backup. 4. Setup all modules setting as was before the reset. Movic theme, Onepagecheckout, Crypto paym...

...ad campaign to find a missing person last seen in a public space. This project calls for a strategic approach to deliver the message across all relevant audiences. Key requirements include: - Compelling Ad Copy: The ideal freelancer should have strong copywriting skills, able to craft engaging and compassionate text that effectively communicates the urgency of the situation. - Targeted Outreach: Experience in defining and reaching specific demographic groups on Facebook is key. They must optimise the campaign to maximise visibility, specifically for those located in the same area as the public space where the person was last seen. - Customer Engagement: They need abilities to handle potential leads, answer inquiries and, importantly, coordin...

I'm looking to have a new website created. The key task involved in this is harvesting photos and data from Website A, and using this to create our site. The following details outline the project requirements: - Downloading photos and data from Website A. - Upload these photos and data to the corresponding sections on our website. The new site should mirror the content placement of Website A. Ideal skills for this job include website creation, data extraction, and efficient data input methods. Experience with content migration is highly desirable. Deadline for completion is within a month from the project start date. All data need to be updated each day

I'm in need of a talented label designer who can create a modern and minimalist wine label for my brand. "Clan McCauley Gin" Slogan: "Clan McCauley Gin: Crafted with heritage, enjoyed with friends." Logo: Design a logo that reflects the clan theme. You could incorporate imagery like a tartan pattern, a crest, or a stylized image of a family gathering. Bottle Design: Choose a bottle design that reflects the premium nature of the gin. A classic, heavy glass bottle with a simple label can be very effective. Bottle design for "The McCauley Cuvée" wine: Label Design: Since "Cuvée" implies a special blend, you could design a label that highlights this. Perhaps incorpora...

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data m...

I am on the hunt for an operations manager with a major focus in blockchain. Ideally, you will be able to help in: 1. Managing our supply chain effectively, 2. Coordinating team efforts, and most importantly, 3. Optimizing our processes. An additional plus if you have experience in the finance sector, as we intend to apply blockchain technology in this field. The main task will be integrating Web3 technology into our existing website to further enhance its operational efficiency. The perfect candidate would be someone who has a solid understanding of decentralized applications, Web3 technology, and prior experience in overseeing operational processes. Your skillset and expertise will be highly valuable in guiding our team to...

...looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project...

We are looking for an experienced Sourcing and Procurement Specialist who can be part of our team. Salary: $525 - $850 (negotiable depending on experience) / month Contract: Full time - 40 hrs. / week (flexible schedule with at least 3 hrs. overlap with US Pacific business hours) Position Overview: The Sourcing and Procurement Specialist will play a pivotal role in our operations, responsible for managing client accounts and sourcing materials from various platforms and suppliers. The ideal candidate will be fluent in English and have strong Mandarin skills, as a significant portion of our supplier base is located in China. They will have a strong background in mechanical engineering, sourcing, negotiating contracts, and coordinatin...

I am blending Google Sheet data with Google Ads and Analytics data but getting an error message. Need someone to help via screenshare. Thanks!

I need a proficient data operator to help manage our customer and product data. The primary goal of this project is to improve our customer experience. Key responsibilities include: - Handling and organizing customer and product data from multiple sources - Ensuring data accuracy and integrity - Implementing strategies to improve customer experience based on data insights The ideal candidate should have: - Previous experience in managing customer and product data - Strong analytical skills and attention to detail - A good understanding of customer experience and how data management can contribute to its improvement.

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with...

I need a virtual assistant for a daily one-hour task to input visitor information into a Google Sheet. Key Requirements: - Attention to Detail: It's important that all information is entered accurately and completely. - Manually need to collect data from various source Ideal Candidate: If you are a detail-oriented individual with prior data entry experience and can commit to a daily one-hour task, I'd like to hear from you.

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

...create a set of social media graphics. Key Responsibilities: - Designing social media graphics for Instagram, Facebook, and Twitter. The graphics will be used on my van's design, so experience in creating graphics that can be applied to a vehicle is a great advantage. I need these graphics as soon as possible, hence I'm looking for a responsive and efficient professional who can deliver quality work swiftly. Ideal Skills: - Proficient in graphic design tools like Adobe Photoshop or Illustrator. - Experience with creating graphics for multiple social media platforms. - Prior experience with vehicle graphics a plus. If you can deliver high-quality work promptly and have the skills necessary for this job, I'...

I'm in need of a comprehensive and user-friendly online store design that will cater to the needs of both homeowners and renters. Specifically, the shop will feature a variety of home products related to water, including water filters, faucets, and shower heads. The challenge lies in ensuring the design is appealing and intuitive for a diverse audience, as well as the seamless integration of an e-commerce platform. Key Requirements: - Aesthetically pleasing and modern design - Intuitive user interface that maintains simplicity - E-commerce platform integration - Responsive design for mobile devices Ideal Skills & Experience: - Proven experience in e-commerce website design, especially in the home product niche - UI/UX design expertise, ...

I'm in need of a professional web developer who can create a clean and professional website that is also fully responsive and mobile-friendly. Ideal Skills & Experience: - Proficient in web development - Experienced in creating professional websites - Skilled in creating responsive and mobile-friendly designs Workflow: Customer fills out the booking form on our website with their details and preferences. Customer proceeds to the payment gateway (Razor pay) to complete the booking transaction. Upon successful payment, the booking details are stored in our database, and a unique booking ID is generated. Admin reviews new bookings via the admin dashboard and assigns cars and drivers based on availability. Customers receive confirmat...

I'm in urgent need of a modern 3D beauty bed design that I can use on my website. It's crucial that the design is appealing and stands out. 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...

...media graphics for Instagram, Facebook, and Twitter. The graphics will be used on my van's design, so experience in creating graphics that can be applied to a vehicle is a great advantage. I need these graphics as soon as possible, hence I'm looking for a responsive and efficient professional who can deliver quality work swiftly. Ideal Skills: - Proficient in graphic design tools like Adobe Photoshop or Illustrator. - Experience with creating graphics for multiple social media platforms. - Prior experience with vehicle graphics a plus. If you can deliver high-quality work promptly and have the skills necessary for this job, I'd love to hear from you. See sample attached ...using the TESLA VAN here ... Th...

I'm in need of a seasoned app developer capable of creating a robust ride-sharing application similar to existing services like Rapido, Ola, or Uber, with a few unique twists. The app will cater the general public users, offering them a seamless, user-friendly, and secure platform for booking rides. Key Features: - GPS Tracking: The app must have a reliable GPS tracking feature to ensure accurate location-based services. - Ride Booking: A well-optimized booking system that allows users to easily book, cancel, and track their rides. - Payment Integration: Secure, efficient, and user-friendly payment gateways to facilitate smooth transactions. The budget is 2500-3000 INR Cross-Platform Development: The app should be available on multiple platforms includ...

I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry ou...

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 ...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a p...

I'm in need of a concert ticket bot that can operate on several platforms, including Ticketmaster, Live Nation, ThaiTicketMajor, and BookMyShow Malaysia. The ideal bot should be able to perform several functions: - IS A MUST TO KNOW WHAT IS QUEUE-IT SYSTEM - Search and display available tickets - Add tickets to cart and checkout - Send notification when tickets are available - Simultaneous requests : send multiple requests at once to increase chances of securing tickets - Queue management : handle queue-it system's virtual waiting room effectively, maintain session and user states to handle queue redirects - Human Simulation : mimic human behavior to avoid detection (randomized request intervals) - Technical requirements - use session management and different proxi...

Hello, I am Susan from FST Research group. We are organizing scientific conference on 27th May 2024 at hotel near Airport Schiphol, Amsterdam, Netherlands. For this we are looking for a conference coordinator, who can manage 20 participants. Responsibilities: 1. Providing conference kit, ID cards 2. Announcing program 3. coordinating with hotel team for services Requirements: 1. Must carry own laptop and help speakers to present their presentation 2. Prefer Amsterdam local candidates or very near to Amsterdam Benefits: 1. we will pay 100 USD for 8 hours event 2. will provide food including snacks and lunch buffets Best Regards Suhana

Job Summary The Program Manager will be instrumental in shaping our operational strategies and enriching support systems for startups within the Web3 and DeFi sectors. This role requires a proactive individual to enhance our accelerator’s offerings and ensure they are perfectly aligned with the needs of startups in this rapidly evolving industry. Key Responsibilities Design, implement, and refine accelerator program structures specifically tailored for Web3 and DeFi startups. Facilitate seamless coordination across internal teams and external partners, ensuring alignment with the DAO’s token economy and governance structures. Develop and maintain strategic partnerships critical to the blockchain ecosystem. Manage the logistical and org...

...require on site visits in Martinsburg, WV I require expert assistance for water quality testing specifically for irrigation purposes. The main concern is potential presence of bacteria and pathogens which could not only affect plant health but also seep into produce, posing health risks. We have a 5 acre wooded property in the mountains and the new neighbors blocked the water supply running into our several wet water streams going through our property. Now all the previously blocked areas have been released and the water coming through on our property is not normal. We are worried that it could kill our trees, wildlife, and vegetation. We are also worried about recent pesticides and herbicides being used in the area that are seeping into our pr...

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 th...- Reviewing Laravel's default authentication and session management 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...

I'm in need of a web-based job card system that will allow the creation and editing of digital job cards. There is also a requirement for 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 ...

Develop macro-enabled Excel file to handle CSV

I'm looking to create a PVC card that will serve as a loyalty card for my fashion brand, Auraya, in collaboration with other brands. Key Requirements: - The card should include the customer's name and contact details, the Auraya brand logo and name, as well as the logos and names of the collaborating brands. - The design should be minimalistic and modern in style. Distribution: - The PVC cards will be handed out in person Ideal Skills and Experience: - Graphic Design: A strong portfolio of minimalistic and modern designs is crucial. - Branding: Experience creating cohesive branding materials for multiple brands. - Loyalty Program Design: Knowledge of loyalty card design and customer information incorporation is important. be...

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 conten...

...position for multiple projects for my agency. I run a short-format content agency that edits videos for various coaches, businesses and podcasts. The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entertaining and highly engaging. I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth. You will be paid 7usd for every video-edit. The process is super streamlined. All videos are tailored by me -> you get the raw footage, edit it and upload the edited videos in a separate folder. I expect a simple thumbnail...

I need a freelancer who can conduct a comprehensive background check for pre-employment purposes. The task involves: - Conducting a thorough check on the candidate's criminal records - Verifying the candidate's employment history - Confirming the candidate's educational qualifications The ideal freelancer for this project should be well-versed with background checks, have access to reliable databases and be able to compile the information accurately and efficiently. Please note that the privacy and confidentiality of the candidate's information is of utmost importance.

Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required. (feel free to rewrite code if you have better idea) --- name "iXBRL" , inside folder contain multiple html file(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html file is encoded...

...agency dedicated to helping businesses thrive in the digital landscape. Our team is passionate about crafting creative strategies and delivering measurable results for our clients. *Role Overview:* As a Lead Generation Expert, you will play a crucial role in identifying and engaging potential clients interested in our social media marketing services and closing deals with them. You will utilize various research and outreach techniques to identify leads, initiate conversations, setup sales call, and nurture relationships with prospects. *Key Responsibilities:* 1. Research and identify potential clients through online platforms, industry directories, and social media channels. 2. Develop and maintain a database of leads, ensuring accurate and ...

I am currently dealing with an issue on my AlmaLinux Development system that is preventing it from booting. The system is displaying an error message upon boot-up. This issue has arisen following some recent configuration changes. The ideal candidate for this job should be well-versed in AlmaLinux system administration and should have experience with troubleshooting boot issues. It would be great if you have a good understanding of system configuration and how it can impact booting. Your task would be to solve this booting issue and ensure the system is up and running smoothly. Key Skills: - AlmaLinux system administration - Troubleshooting boot issues - System configuration expertise This is an urgent job, and I need a professional who can address t...

I need to have the design of a face mask made. It will cover the whole face (refer full face ). The design should look like a funny, cartoonish, smiling red colored car. It should have ...need to have the design of a face mask made. It will cover the whole face (refer full face ). The design should look like a funny, cartoonish, smiling red colored car. It should have at least eyes and smile. If I print it and put it on my face, the eyes should be in place of real eyes, the smile should be in place of real smile i.e. the proportions of the final image should match accordingly. The resolution should be at least 2160x3840. Also check other reference images. The mask should be a standard size that fits most people comfortably. Don't give me a random quote, give me ...