Formula to find missing serial number in excel jobs

I need a multi-purpose chassis designed for a heavy-duty construction vehicle primarily intended for excavation in mountainous terrains. The vehicle will face challenging conditions, so the chassis must excel in durability and flexibility. Key Requirements: - Design a chassis that can withstand tough, mountainous terrains while being able to adapt to different conditions and tasks. - The design should not prioritize being lightweight, but rather focus on durability and flexibility. - Previous experience in designing vehicle chassis, particularly for construction or heavy-duty vehicles, is highly desirable. Ideal Skills: - Mechanical Engineering - CAD Design - Experience with heavy-duty vehicle design - Knowledge of materials for durability - Cre...

... Use Google Sheets and Excel for data entry and management. Ensure all data entries are accurate and error-free. Submit daily progress reports. Required Skills: Proven experience in data entry. Proficiency in Google Sheets and Microsoft Excel. Ability to complete tasks within deadlines and maintain accuracy. --- If your project is related to Sales & Marketing or Translation & Languages, you can modify it accordingly. Example: Project Title: Content Writing for Marketing Campaigns Project Description: Create engaging and customer-attractive content for a new product launch. Write short yet impactful copy for social media ads. Ensure content aligns with the brand's tone and audience. Required Skills: Strong writing...

Project Description: We require a robust and scalable Project Management System built on Microsoft Power Apps. The system should allow users to manage projects, tasks, risks, budgets, and reports efficiently. The application will integrate with Microsoft tools like SharePoint, Power Automate, and Teams for seamless collaboration and automation. Project Goals: Centralized management of projects, tasks, and related data. Improved collaboration among team members. Automation of workflows for task assignments, approvals, and notifications. Advanced reporting and analytics for project tracking and decision-making. Core Features: 1. Dashboard Overview of all projects. Visual status indicators (e.g., progress bars, charts). Quick filters (by priority, status, department). 2. Project Man...

I need help with my CSV file for Pinterest's Bulk Create Pins feature. I am receiving an error about missing required fields. The ideal candidate should be well-versed with Pinterest's Bulk Create Pins feature and CSV formatting. Your tasks will include: - Analyzing the current CSV file for compliance with Pinterest's requirements - Fixing any identified formatting or data-related issues - Testing the corrected file to ensure it uploads successfully - Providing guidance on creating compliant CSV files for future use Please share past examples of similar work you've done, and outline your approach for this task.

I'm in the process of elevating my event brand, Kiki Disco, and I need your creative expertise. The brand is built around the vibrant and energetic 80's disco scene and I need a series of designs that reflect this. Key elements to incorporate: - Neon lights, Disco balls, Retro patterns: I want these iconic 80's elements to be prominent in the designs. - A range of design formats: This includes posters and flyers, social media graphics, merchandise designs, and individual logo variations. Color scheme: - Bright neon colors: The designs should be bold and eye-catching, using a bright neon color palette typical of the 80's disco scene. Ideal candidates will have: - A strong portfolio in 80's retro design - Experience in cre...

I need assistance with data entry. The data is mixed (text and numbers) and is currently in Excel/CSV format. The primary purpose of this data entry task is to populate a database. Ideal candidate should be proficient with: - Excel/CSV - Data entry - Attention to detail Experience with database management and data handling is a plus.

...framework to manage application logic, APIs, and business processes. ● Frontend: ○ Mobile App: Developed using Flutter, ensuring cross-platform compatibility. ○ Web Interface: Built with Angular, providing a responsive and dynamic user experience. ● Database: PostgreSQL serves as the primary data storage system, handling all transactional data. ● Notifications: Firebase manages push notifications, keeping users informed about tender updates and other relevant activities. ● WhatsApp Integration: Twilio’s WhatsApp Business API facilitates communication and interactions via WhatsApp. ● Hosting: Deployed on DigitalOcean Cloud infrastructure, leveraging its scalability and reliability features. ---------------- Proposed Enhancement ● AI-Driven Conversational Interface: Transiti...

...Book Sales Order to generate Batch No. Step 3 Issue of Job Card with batch No. and if the Bom contains bunch / combination of harness the batch no. follwed by 1,2,3,4,5 ---999 Step 4 Track the things and asisit for further step Bart code of the assembly part Cable - Part no. ( Bar code) , Receipt Barcode (PO, Qty, date) Lug, Terminal, Connector - Part no. ( Bar code) , Receipt Barcode (PO, Qty, date) Step 5 OP 1 : Cutting - Guide - which step to go - by Bar code of assembly parts On Screen what to display the length as per BOM Scan the bar code of employee doing it to track who have done it and when. Guide the operator to send it to next operation by telling the nex operation name / station no. Step 6 Op 2 - Ferulle Printing and inser...

...looking to automate sending birthday promotion messages to a list of contacts via WhatsApp. Here’s what I need: What I Have: • An Excel sheet with nearly 2,000 contacts. o Each entry has:  Name  Contact number (with country code)  Birthday date • I’ve also got 2 promotional images and a message I’d like to send. What I Need: 1. Send WhatsApp Messages (direct from excel) two images I provide. 2. Reusable for Future Months o For upcoming months, I want to just update the Excel sheet with new names, numbers, and birthdays, and then click something to send messages to the new list. 3. Extras I’d Like: o Skip duplicate numbers so no one gets spammed. o Log which messages were sent s...

...Skills: I have extensive experience in writing articles, product descriptions, website copy, and other forms of content. SEO Copywriting: I am proficient in creating SEO-friendly content that helps improve search engine rankings. Engaging and Persuasive Writing: I excel in writing compelling content that connects with readers and enhances brand engagement. Client Communication: I understand client needs and can craft clear, persuasive copy tailored to their target audience. Portfolio Examples: I have a portfolio showcasing my work, including blog posts, website copy, and product descriptions. Full Description: I am a skilled copywriter with a passion for creating content that not only informs but also engages and motivates readers. With a strong backgr...

... We are looking for a Python developer to help automate the extraction of data from screenshots. The project involves two key tasks: Screenshot Cropping Script: Develop a script to crop screenshots and isolate the relevant data sections, focusing on the area below the column headers. The cropping areas may vary slightly between different screenshots. OCR Data Extraction and Excel Conversion: Use OCR tools (like Tesseract) to extract text from the cropped images. Convert the extracted data into a structured format, and save it into an Excel file, with each piece of data placed into corresponding columns. Requirements: Proficiency in Python (Pillow, OpenCV, pytesseract). Experience with OCR for text extraction from images. Ability to wo...

I’m looking for someone to help integrate an instant quote calculator on my website, , which is on the Shopify platform. Key Features: The calculator should give price estimates based on the pickup and delivery locations. It should calculate pricing based on the distance between the locations. Price Quote Calculation Formula: Price Quote Parameters: Base Delivery Fee: $40 (This is the starting cost for the delivery, no matter how far it is). Base Miles: 5 miles (These are the miles included in the Base Fee with no extra charge). Additional Fee per Mile: $1.95 (For any distance beyond the base miles, there’s an extra charge per mile). Price Calculation Formula: If the distance is less than or equal to the base miles (5 miles), the price st...

I'm looking for a reliable freelancer for manual data entry. The job involves transcribing information from printed documents into an Excel spreadsheet. Key Responsibilities: - Accurately transcribing data from physical documents into an Excel spreadsheet. - Maintaining the confidentiality and integrity of the data. - Reporting any discrepancies or issues with the source documents. Ideal Candidate: - Excellent attention to detail. - Proficient in Excel. - Prior experience with manual data entry is preferred. - Able to work independently and meet deadlines.

Please Sign Up or Login to see details.

I require assistance in purchasing an in-store IKEA item, the ÄSPERED headrest in Tibbleby beige/grey (item number 405.643.23), and shipping it to a specific address. Key Tasks: - Purchase the item from an IKEA store in Australia or Japan - Calculate shipping costs and suggest the best shipping options - Ship the item to my specified address Ideal Skills and Experience: - Familiarity with IKEA stores and their purchasing process - Experience in international shipping - Proficient in cost analysis and comparison - Strong communication skills for updates and confirmations Please bid only if you are located in Australia or Japan, and can easily access an IKEA store. Your prompt assistance will be greatly appreciated...

We need an experienced data researcher with the following skills: 1) Experience in Internet Research 2) Good English skills 3) Knowledge of google sheets & excel 4) Attention to detail This is a long term project.

Excel Data Cleaning: Removing duplicates, errors, and inconsistencies for accurate analysis. Excel Data Formatting: Organizing data into a clear and professional layout. Excel Dashboards: Creating interactive and visually appealing dashboards for data visualization. Excel VBA: Automating repetitive tasks and creating custom macros to save time. Pivot Tables and Charts: Summarizing and visualizing large datasets effectively. Data Analysis: Performing advanced calculations and trend analysis for insights. Conditional Formatting: Highlighting important data with rules and color coding. Formulas and Functions: Using advanced formulas (e.g., VLOOKUP, INDEX-MATCH) for dynamic calculations. Data Validation: Ensuring data accuracy with dropdown lists and validati...

I am in search of a talented children's book writer who can help me finish a short story about an 8-year-old girl named Therian. The story currently has 1900 words and needs to be extended to 3000 words. This is the first book in a series, so there is potential for ongoing work if we find the right collaboration. Tone: - The story should have an adventurous tone. Plot: - Therian's story will include a variety of adventures spanning across fantasy worlds, real-life challenges, and mysterious discoveries. Themes: - The narrative should emphasize the values of friendship, courage, and imagination. Ideal Skills: - Experience in writing children's literature is a must, with a portfolio that includes adventurous storylines. - Ability ...

...talented Funnelish page builder to join our team. This is an exciting opportunity for someone with a proven track record of creating high-converting sales funnels for health and wellness products, including devices, supplements, and other related items. The ideal candidate will have a portfolio showcasing their top-performing projects and a passion for delivering exceptional results. This role will be a retainer-based position, offering consistent and ongoing work for the right candidate. We are committed to recognizing and rewarding expertise, offering above-industry-standard compensation for those who consistently exceed expectations. Key Responsibilities: - Design, build, and optimize Funnelish pages tailored to health and wellness products. - Implement strategie...

...experienced Power BI developer to create a comprehensive report for our sales and marketing data. The ideal candidate should have a strong background in data visualization and analysis, with a proven track record of delivering high-quality Power BI reports. **Project Requirements:** 1. **Data Integration:** - Integrate sales and marketing data from various sources (e.g., CRM, ERP, Excel files). - Ensure data accuracy and consistency. 2. **Report Design:** - Create visually appealing and interactive dashboards. - Include key metrics such as sales performance, marketing campaign effectiveness, customer segmentation, and ROI analysis. - Design reports that are easy to navigate and understand. 3. **Data Analysis:** - Perform in-depth a...

I need a Word document transposed into an Excel file. Key Points: - The original document contains text only. - Text organization within the Excel file is not uniform. It varies and will need to be explained. Ideal Skills: - Proficient in Microsoft Excel and Word. - Good understanding of data transposition. - Detail-oriented to ensure accurate transfer of content.

...freelancer to create three official letters for me. I will supply the content for each letter. Your task will involve formatting the letters on three different formal letterheads and sending the completed Word Document back to me. Key Responsibilities: - Incorporate company information and logos sourced from their websites onto the letterheads. - Ensure all letterheads contain the company's name, address, and contact information (general enquiries email and telephone number). - Format the letters using the Times New Roman font throughout. Ideal Skills: - Proficient in Microsoft Word. - Attention to detail, particularly in sourcing and accurately representing company information and logos. - Strong understanding of formal letter formattin...

Please Sign Up or Login to see details.

I need a comprehensive Excel spreadsheet containing the top 5,000 accounts. The data should include: - Number of followers - Social handle - URL link The accounts should be ranked by the number of followers. The ideal freelancer for this project should have experience in api data collection and Excel, with a proven track record of working with social media data. Attention to detail is crucial, as is the ability to source information from reliable platforms. Please do not submit junk data, or data you have not reviewed yourself. Send an excel file or google sheet document link. Thanks

...who can help supercharge my Mighty Network dedicated to young professionals thriving in health and wealth. Here’s what I’m looking for: - Technical Assessment: Ensure the network, including the lead magnet (PDF via Kit) and 5-day challenge, is running smoothly. - Marketing Strategy: Develop and manage high-conversion ads with a focus on high ROAS, tailored to my target audience. - Outreach and Engagement: Craft and send direct text messages to my contacts, informing and engaging them about my Mighty Network. - Administrative Support: Handle ongoing admin tasks to maintain the network's efficiency. The perfect candidate will have: - Proven experience with Mighty Networks or similar platforms - Expertise in digital marketing, e...

I need a freelancer to help me gather real estate property addresses from public companies' websites. I will provide the list with 25 public companies with the URL to their properties. Save the list of properties for each public company in a separate Excel to avoid confusion. Please compile the data in a Microsoft Excel spreadsheet, and ensure to include the following fields for each property address: - Street Address - Address 2 (optional) - City - ZIP/Postal Code - Name (if applicable) - State - Country I will provide a sample template to help. Ideal skills and experience for this job include: - Proficiency in web research - Familiarity with Microsoft Excel - Attention to detail - Und...

...services, financial growth solutions, and expert resources for entrepreneurs and companies in Canada. The website must have the same design and layout as while integrating detailed content and functionality outlined below. This project will be built primarily in Elementor, ensuring easy updates and customization. Sitemap and Content Overview: 1. Home Page • Welcome Section: • Overview of Expanza and its mission. • Emphasis on user-friendly tools and expert services. • Highlighted Features: • Loan Finder Tool: Explore customized business loans. • Loan Calculator: Calculate repayment plans. • Knowledge Hub: Access expert guides and templates. • Call-to-Action Buttons (CTAs): • [Find a Business Loan] &bul...

Simple and quick paid part-time job opportunities to Filipino. We need individuals or teams. 1. Need a resourceful virtual assistant based in Philippines, skilled in team management and organization. Your main task will be to oversee the collection of 20,000 high-resolution (1920*1080) exterior car photos. Key Responsibilities: - You will recruit suitable individuals across Philippines to collect the photos. - You will manage these individuals, ensuring they understand the task and meet the quality standards. - You will send the collected photos to me for review. 2. Or, if you don't have a team but enjoy working outdoors and taking photos everywhere by yourself, we also want you. We pay according to the actual number of phot...

...On-demand content. This project is related to data entry for schedules from radio stations. Please read below to learn more. Only bid in our budget to get hired. Project Requirements / Scope: Manually enter or copy & paste schedules for up to 8 Radio stations into my web site. You will also find images to upload for each radio show you enter in the schedule. This should be a very easy job. I will train you. You visit each radio station web site to get the schedules. The images must be high quality. If you can not find a good one on the radio station schedules. I will be provide you a few sites you can get images for radio shows. No Coding will be needed. No Graphic Design. Skills: * Data Entry accuracy * ...

We are looking for a WooCommerce expert to customize the checkout process of a production store hosted on AWS VPS. The required changes are as follows: 1. Modify the billing form fields: • Change the field “Nombre de la empresa (opcional)” to “DNI/RUC” and make it mandatory. • Reorder the address-related fields to follow this sequence: Departamento (Department), Provincia (Province), Distrito (District), Dirección completa (Full Address, with an example as a placeholder). A detailed Excel file with the list of departments, provinces, and districts in Peru will be provided. 2. Shipping configuration: • Adjust shipping rates based on the provided list of Peruvian locations in Excel. • Fo...

...report should be in Excel format. - Total earnings is calculated as: Gross Benefit + Worker Compensation + Net Salary. Gross Benefit is the total of all benefits in the salary master file from columns R to AV, excluding Federal Income tax, California Amount, and California SDI. Option to add inclusion or exclusion without changing formula. - The bi-monthly payroll needs to be consolidated from two lines per employee to one line summary report. - Class allocation percentages should be sourced from the class columns E to VU in the class allocation sheet, and must total 100%. Ideal skills and experience for this job include: - Proficiency in Excel, especially in data analysis and manipulation. - Ex...

I have two photos that I need edited into one photo. I want to add one person missing from one “photo A”, a middle aged man on the right seen in “photo B”. Have him in the final. A dog, a husky looking at the camera in “Photo B” have him in the final product i. This position, looking at the camera. i don't care to have his entire body in the photo, like how he is in “photo A”. just him looking like he is in “photo B”, whatever works best as i know the perspective of each photo is different. Ideal skills for this job include: - Proficiency in photo editing software (e.g. Adobe Photoshop) - Skills in seamlessly adding or replacing pets and...

I'm seeking a designer to create a full vehicle wrap for our 2024 Ram ProMaster Van. The design should reflect both a modern and sleek, as well as a bold and eye-catching style. You can get a feel for our tech-oriented business by visiting our website, www.itit.com. The wrap will cover: - **Sides**: Our company logo and name (ITIT) alongside a tech-themed background. These need to be prominent, catching the attention of passersby. - **Back**: This should detail our company name, website, phone number, and our four main services: Managed IT Services, Cybersecurity, Network Infrastructure, Surveillance Systems, and Structured Cabling. Color-wise, the design should primarily use our company colors, but I am open to creative suggestions that incorporate bri...

...completed in our course along with other artifacts, photos, and resources you may want to include. E-portfolios are excellent tools for showcasing to potential employers your skills, educational and work experience, accomplishment and publications, talents, and professional credentials. While there are many open source and subscription e-portfolio resources online, APUS provides an e-portfolio to all active students and faculty. Portfolio, our digital portfolio resource is designed to assist with your review, planning, and career readiness steps. This resource can be accessed by looking for the Portfolio section, within the Course Tools area of our course. If additional resources are required for the development of your e-portfolio, please contact ...

...skilled video editor to help tidy up some video interviews for The Accommodation Show podcast. This first video will serve as a competition to find the best fit for ongoing work. You can download the test video from the following link: Learn more about The Accommodation Show at: @theaccommodationshow What I'm Looking For: A clean, engaging edit of a single episode, using the existing basic edit as a starting point. Removal of unnecessary filler words (ums, ahs, etc.) to improve flow. Potential zoom-ins on the speaker to enhance engagement. No captions required for this round. If your edit stands out, you'll have the opportunity to take on ongoing

I need some expert guidance with Excel formulas for a cap table. The focus will be on equity allocation. I have created the excel file and entered the different rounds but I need help with some of the formulas. Key Requirements: - Formulas to effectively distribute equity among stakeholders - Representative display of shareholder names, number of shares held and percentage ownership Ideal Skills and Experience: - Strong proficiency in Excel, particularly with complex formulas - Experience with cap tables and understanding of equity allocation - Ability to present data in a clear and comprehensible manner

...simplified version of what the ideal person should know how to do: 1. Brand Design: • Create logos, mascots, icons, and other visuals using tools like Adobe Illustrator or Canva. • Develop a cohesive color palette, typography, and brand guidelines. 2. Marketing and Advertising: • Design ad creatives for social media (static, animated, or video). • Manage social media profiles (cover photos, profile pics, and post templates). • Run targeted campaigns on Facebook, Instagram, LinkedIn, and Google. 3. Video Creation: • Create explainer or demo videos using tools like Vyond, Animaker, or Adobe Premiere Pro. 4. Strategy: • Research your audience and competitors to position the brand effectively. • Develop growth strategies t...

...Objective: Automate lead generation by scraping public court eviction records. Process: 1. Use a scraper to extract eviction case details (e.g., property address, landlord, case status). 2. Enrich extracted data by appending missing contact information (emails, phone numbers) via APIs. 3. Automatically upload leads to Ligna CRM using N8N. Output: Verified, enriched leads ready for follow-up. Step 2: Automated Lead Segmentation and Campaigns Objective: Segment and nurture leads with targeted campaigns. Process: 4. Automatically segment leads by type (e.g., landlords, attorneys, property managers). 5. Trigger email and SMS campaigns using N8N workflows. 6. Schedule automated follow-ups to maximize engagement. Output: Segmented and nurtured leads with a high lik...

I need a methodical and detail-oriented freelancer to assist with data entry from supplied aerial site images. Specific Tasks: - Using Google Maps to obtain GPS coordinates for 96 marked building locations on the aerial images. - Pasting these coordinates into a provided Excel spreadsheet template. - Manually verifying each entry to ensure accuracy. Automation is not an option for this task. Example provided for the Excel spreadsheet. Please note, only the GPS coordinates are required from Google Maps, with the building locations indicated by outlines on the aerial images. Ideal Skills: - Proficiency in using Google Maps - Excellent attention to detail - Ability to work methodically and systematically - Competency in Ex...

I am looking for a skilled VB.NET developer to assist in resolving issues (now and ongoing) that we are trying to send live. You need vb.net skills and experience with ms office object model though vb.net we also need an installer so we can push updates to clients. Key Requirements: - Develop a VB.NET application that can scan and read content from Excel and Word documents. - Implement functionality for the app to interpret different types of content such as text, tables, and charts. Ideal Skills: - Proficiency in VB.NET - Experience in developing applications for document scanning and reading - Familiarity with Excel and Word document structures -installer creation.

I'm seeking a dedicated freelancer to help gather data ( or share already researched data) on international students currently attending U.S. universities. The data should be comprehensive and cover a range of details about each student. Key Data Points Needed: - Student First Name - Student Last Name - Current U.S. City - Student University Email - Student Personal Email - Student Home Country - U.S. University Name - Degree Pursuing (Bachelor's, Master's) The ideal candidate will have: - Experience in data collection and research - Access to verified data - Ability to deliver in a clear and organized way Important Note: The home country of the student must not be the USA. I am open to data from any other region, and I will need...

...boutique venture capital firm specializing in acquiring and scaling online businesses, including content websites, SaaS companies, social media accounts, and mobile apps. They are committed to innovation, data-driven decision-making, and fostering entrepreneurship. I have been tasked to hire a PART TIME, motivated and analytical Venture Capital Intern to join our dynamic team. This paid internship offers hands-on experience in sourcing, analyzing, and evaluating potential business acquisitions. The role is ideal for individuals passionate about online businesses, financial and market analysis. As an intern, you will play a key role in the acquisition process by identifying opportunities, conducting in-depth research, and providing act...

create this data into a simple and engaging format to send to customers Cyberattacks are happening more frequently and causing greater damage, which is pushing organizations to improve their cybersecurity. These attacks are usually carefully planned and financially motivated. Cybercriminals specialize in different types of attacks like phishing, scams, malware, ransomware, and hacking, each using their own methods. To protect against these growing threats, companies need to strengthen their cybersecurity. In June 2017, the Australian Cyber Security Centre (ACSC) introduced the "Essential Eight" strategies to help businesses improve their security. However, companies should not rely only on these strategies and should add ...

I have a project that involves transferring data from PDF documents into an Excel spreadsheet. The documents are about 100 pages long and contain a mix of text and numbers. The successful freelancer will need to: - Accurately input this information into Excel in both alphabetical and numerical order. - Use a pre-existing template, with potential for adding or deleting columns based on predefined rules or guidelines. Ideal candidates will have strong attention to detail, experience with data entry and proficiency in Excel. Prior experience dealing with PDF to Excel data transfer will be highly regarded.

I'm in need of a talented classical vocalist to sing Schubert’s „Ave Maria“ with my piano accompaniment for a personal virtual event. The ideal candidate should have experience in singing in a virtual setting, be able to convey the nuanced emotion of classical music, and engage an online audience. Key Requirements: - Exceptional classical singing ability - Previous experience with virtual performances not necessary - Ability to engage an online audience - Best possible recording quality Please find my accompaniment abilities on @PianoNerds-4u, include samples of your previous work, specifically any virtual performances. Looking forward to your participation at this non-commercial project

I need an Excel spreadsheet that can perform specific calculations with my numeric data. - The spreadsheet should be able to multiply specific columns together: Column B with Column E to get G, Column C with Column F to get H. - It should then add these two results together to fill Column I. - Next, Column I should be multiplied by Column J to fill Column K. - This sequence should repeat with Columns L through P and a few additional columns. Ideal skills for this job include advanced knowledge of Excel, particularly in using formulas for multiplication and addition across various columns. Experience with data management and numerical data analysis would also be beneficial. Please ensure you have a strong understanding of Excel&#...

Please Sign Up or Login to see details.

Please Sign Up or Login to see details.

I'm looking for an Office Administrator/Virtual Assistant to help with a variety of tasks. Key Responsibilities: - Email Management: Overseeing incoming and outgoing emails, prioritizing messages, and drafting responses when necessary. - Scheduling Appointments: Coordinating meetings, managing calendars, and ensuring no scheduling conflicts arise. - Data Entry: Accurately inputting information into databases and maintaining records. Virtual Assistant Duties: - Customer Support: Responding to customer inquiries, resolving issues, and ensuring a positive customer experience. - Research Tasks: Conducting online research for various projects and compiling findings in a clear and concise manner. - Social Media Management: Overseeing company social media accounts, po...