I'm seeking an expert in Google Sheets who can assist with the VLookup function. My project is pretty straightforward. - Work Focus: We'll work with data on a single sheet. - Desired Output: While I'd like to understand how to return the first match, it's equally important for me to have a comprehensive understanding of how to retrieve all matches. The perfect candidate should have detailed knowledge of Google Sheets and advanced experience with the VLookup function. I look forward to your bid. The issue I am having is it is not accurately matching columns. It does on some of them, but not all of them.
...costs, savings, and reinvestment into the company. Additionally, we need assistance in crafting a family budget. At the moment, our spending habits are merely conjectures, as we lack concrete knowledge on our financial capacities. Our document organization needs improvement for a more streamlined understanding of both our business and family budgets. We also require an inventory management sheet that outlines stock costs against selling price to calculate profits. In QuickBooks, every transaction must be corroborated with a receipt from Receipt-Bank or reconciled from the bank statement. We need to ensure daily recording of all income and expenses via Receipt-Bank and QuickBooks, including the reconciliation of two bank accounts. Cross check receipts emailed to our account...
We are seeking a detail-oriented and highly organized Remote Data Entry Specialist to join our team. The ideal candidate will be responsible for accurately inputting and maintaining data in our systems, ensuring data integrity and consistency. This is a remote position that requires a strong commitment to accuracy and attention to detail. Key Responsibilities: Data Entry: Accurately input data from various sources into our database or software systems. Data Verification: Verify the accuracy and completeness of data entries, cross-referencing information to ensure data integrity. Confidentiality: Handle sensitive information with discretion and maintain strict confidentiality.
As an ambitious business owner, I am looking to kick off a dynamic new product from scratch. I need an expert Swift developer to design a reminder application exclusively for iOS. a full functioning app that is required to be offline and simple and related to the designer personally , I have 3 young Boys all under the age of 4 and my idea is to create a medicine reminder for my kids, the interfaces are simple 1- a splash screen that's timed for 2 seconds than navigated to the Add Profile Page if no profiles are added yet the screen will be empty with a plus button on the bottom of the screen, when that button is pressed a sheet should pop up to add -an image -name and another button under that to add a medication reminder with the details of the medicine and an alert t...
...6 (Frankfurt, Mainz): 60311 (Frankfurt am Main), 55116 (Mainz) Region 7 (Stuttgart, Karlsruhe): 70173 (Stuttgart), 76133 (Karlsruhe) Region 8 (München, Augsburg): 80331 (München), 86150 (Augsburg) Region 9 (Nürnberg, Erfurt): 90402 (Nürnberg), 99084 (Erfurt) Your task will be to extract and compile data including First Name, Last Name, Email, and Telephone Number of the therapists into an Excel sheet. While Instagram profile links are a bonus if found, they are not mandatory....
IN the attached sheet I need a button in each cell in column "E" when the button is pressed I need it to trigger an e mail to the recipient on cell "D" . The e mail will then create a subject heading Row "F" and an e mail main body text which is in row "G". When the work is done and the script is working, I will regard this mini project as complete. My understanding is that this is a small amount of coding which for the skilled person doing it, should only take 5 or 10 minutes. This is reflected in the price offered.
I'm looking for a freelancer who can efficiently handle both data download and financial analysis tasks. My main requirement is to download my bank statement from my account for the fiscal year 2022-2023 and prepare a comprehensive balance sheet. **Key Responsibilities:** - Access the account securely to download the full bank statement for the specified period. - Analyze the bank statement to categorize all transactions accurately. - Create a detailed balance sheet in an Excel spreadsheet, incorporating both income and expenses as well as assets and liabilities. **Ideal Skills and Experience:** - Proficiency in Excel to ensure a well-organized and understandable format. - Experience with financial analysis and statement preparation. - Knowledge of accounting princi...
...websites. The intent is to highlight my design work and the key challenge will be creating a website that visually represents the caliber of my designs. company is a contract manufacturing firm established to support cost-effective manufacturing solutions for international geographies. Our services 1. CNC Machining 2. Die Casting 3. Sheet Metal Operations 4. Forging 5. Tooling 6. Engineering Change management WEBSITE SITE TO INCLUDE: About Us – ( Will also have a banner for industries we serve) What we do ( Our Set up of Various Machinery) Products/ Services Quality & Inspection Gallery Case Studies Contact us Instructions: company will reserve the domain and web hosting(hostinger) and grant you access details for managed WordPress. Throughout the ...
I have a statement sheet where there are for each machine start time and end time of the event. I created two columns (for only hour) called Start and End In PBI I created a Shift column to specify if the shift is Morning / Afternoon / Night. However, there are rows where the statement starts in the morning and ends in the afternoon (e.g. row 159 - start 1:56 pm - end 2:15:59 pm). I need to calculate the afternoon accrual minutes and the morning accrual minutes. The shifts are: morning 06.00 - 13.59 afternoon 14.00 - 21.59 night 22.00 - 05.59 The purpose is to figure out, for each type (code on type column) the minutes per shift morning, afternoon, night for each day. The ideal result is a table report with a day column, shift column, type column, minute column that should repres...
I have a statement sheet where there are for each machine start time and end time of the event. I created two columns (for only hour) called Start and End In PBI I created a Shift column to specify if the shift is Morning / Afternoon / Night. However, there are rows where the statement starts in the morning and ends in the afternoon (e.g. row 159 - start 1:56 pm - end 2:15:59 pm). I need to calculate the afternoon accrual minutes and the morning accrual minutes. The shifts are: morning 06.00 - 13.59 afternoon 14.00 - 21.59 night 22.00 - 05.59 The purpose is to figure out, for each type (code on type column) the minutes per shift morning, afternoon, night for each day. The ideal result is a table report with a day column, shift column, type column, minute column that should repres...
I'm looking for a detailed and accurate spreadsheet of all veterinary clinics within a 50km radius of Brisbane, QLD, 4000, Australia. This sheet needs to be meticulously organized and should present the information in a way that’s easy to read and understand. Here's what I specifically require: - **Clinic Information Needed:** - Name of the clinic - Address, including postcode - Phone number (with and without the country code) - Email addresses (if available) - Operating hours (if available) - Services offered (if available) - **Data Handling Instructions:** - Duplicate entries must be identified and removed to ensure the accuracy and cleanliness of the dataset. - Phone numbers should be provided in both formats (with and without the country code) f...
Simple 11 ft x 30 ft Patio Cover. Steel structure Metal side attached to house. Outside posts surface mount.
...This project will include designing one set of high waist leggings and two types of sports tops, a standard supportive sports bra/top and a high neck compression tank/midi top. Key Features & Functionality: - Moisture-wicking fabric - Four-way stretch - Breathable material - Heat transferable for logos and designs The tech pack should capture design specifications for a range of sizes and provide comprehensive details for production. No rush on the completion date, as I value quality over speed. Ideal Candidate: Relevant fashion design experience is a must. The freelancer should have a strong understanding of activewear design and materials, a keen eye for detail, and be able to translate these requirements into a commercially-viable tech pack. Exp...
...printing purposes. - Need model in layers as shown in phot with black being thicker as it will be the base for the oversized chain pendant. **Ideal Skills and Experience:** - Proficiency in 3D modeling software capable of exporting .stl files, such as Blender, AutoCAD, or Solidworks. - Experience in creating 3D models for printing, with an understanding of the limitations and capabilities of 3D printing technology. - Attention to detail to ensure the model meets the basic structural requirements without overcomplicating the design. - Ability to deliver the project in a timely manner, with an open line for communication for any clarifications or adjustments. This project is perfect for someone who enjoys the challenge of simplifying complex structures into basic, printab...
...high-quality product design using SolidWorks. Key Aspects: - Designing a Product: The primary task will be designing a unique, functional, and manufacturing-ready product. A keen eye for detail is essential as the design must be precise and suitable for manufacturing. Expertise Required: - SolidWorks Proficiency: As the entire project revolves around creating the product design using SolidWorks, the potential freelancer should have tangible experience and a solid understanding of this software. - Product Design: Past project experience and a portfolio showcasing product design skills are most welcome. - Understanding of Manufacturing: Familiarity with manufacturing processes and constraints is necessary to create a feasible...
I'm in immediate need of an expert to assist with calculating tax liabilities in Germany, specifically focusing on the First-In, First-Out (FIFO) method for Cryptocurrencies and Stocks. This project aims to ensure accurate and law-compliant tax reporting, spanning income tax, capital gains tax, and dividend tax calculations. The outcome should be an Excel sheet. We have a few thousand transactions. **Ideal Skills and Experience:** - Expertise in German tax laws and regulations - Proficiency with the FIFO accounting method - Experience with cryptocurrency and stock market transactions - Ability to calculate income tax, capital gains tax, and dividend tax accurately - Knowledge of financial software or tools for efficient tax calculation **Requirements:** - Analyze and organi...
Hello Toni, I hope this message finds you well. I am interested in sending you an offer for an Excel sheet that includes business data in Florida. thanks, ahmed aman
I am looking for a data miner to meticulously comb through Indeed to identify job listings related to lead generation across the United States. The goal is to compile a comprehensive log sheet that includes the Company name, Contact email, and Job title from these listings. Following the data collection, the task extends to sending a tailored email to these contacts, pitching our specialized lead generation services. **Key Responsibilities:** - Navigate through Indeed to find lead generation job listings in the USA. - Record detailed information of each listing, specifically the Company name, Contact email, and Job title. - Utilize the gathered information to email a customized template that introduces our company, outlines our services, and provides our contact information. **Ide...
I am looking for a freelanser with very good Google Appsheet experience as some of the function required will be directly applied to or from the Appsheet. We have an existing app based on google Appsheet that needs a few modifications and reporting. Our priorities are as follow: 1. Set up one or more weekly reports from data derived from the google sheet using Zapier. ( The volume of data is very small currently) 2. Synchronize/ Combine the appsheet calendar with Google calendars. 3. Create a dashboard for the reports and app and other functions. 4. We require some Appsheet modifications that may require coding. We would like to get items 1 and 2 done immediately and then move onto items 3 and 4. We published this job before but ran out of time to complete the project. Please ...
I am searching for a meticulous individual capable of proofreading an image-file instruction sheet for an ovulation test. You will be expected to check and correct any spelling and grammatical errors. - The document for proofreading is in English and is presented in an image file format. - Ideally, you should be proficient in reading English texts presented in non-editable formats like images. Your primary task will be: - Spelling and grammar check – meticulously identifying and correcting spelling mistakes and grammatical errors. Previous experience in proofreading medical or health-related documents will be a plus. Proficiency in use of proofreading tools and software will also be preferred.
...industrial-style locker room that embodies the essence of efficiency, practicality, and strong aesthetics. This space will serve as a changing room, storage area, and shower facility, catering to a labor-intensive environment. **Essential Features & Considerations:** - **Efficient Use of Space:** Design a layout that maximizes the available area, ensuring ample changing space, sufficient storage lockers, and well-positioned shower facilities. - **Industrial Aesthetics:** Incorporate industrial design elements such as metal lockers, exposed piping, concrete flooring, and utilitarian lighting fixtures to enhance the space's overall look and feel. - **Durability & Maintenance:** Select materials and finishes that are not only in line with the industrial ...
...to life and need a skilled mechanical engineer with a flair for innovative design. My project revolves around the early stages of product development, making it a hub for creativity and technical prowess. Here's what I'm looking for: **Core Requirements:** - Profound expertise in CAD modeling to transform conceptual ideas into tangible models - Ability to conceptualize and collaborate on design modifications for product optimization **Ideal Skills:** - Comprehensive experience with major CAD software (AutoCAD, SolidWorks, Fusion 360). Although I haven't specified a preference, familiarity with more than one platform will be beneficial for flexibility in our design process. - Strong background in mechanical design, particularly in devel...
Hi Jen, Based on your inputs, I have completed the AWB Tracker Google Form and Google sheet. Please approve. Thanks, DC
I'm looking for a skilled and detail-oriented music transcriber to convert a jazz alto saxophone solo into sheet music. The solo is featured in Emancipation Blues, running for over three minutes, captures the essence of jazz and improvisation that I wish to study and possibly perform. It is crucial that the transcription not only gets the notes and rhythms correct but also includes the articulations to truly capture the spirit of the solo. Ideal Skills & Experience: - Proficiency in music transcription with a portfolio showcasing previous work, preferably with jazz or improvisational music. - Ability to accurately transcribe complex rhythms, notes, and articulations from audio to sheet music (PDF format). - Familiarity with music notation software to ensure a clean...
...seeking a detail-oriented freelancer to accurately copy type content from PDF documents into a sheet format. The core objective is to maintain the original format faithfully, ensuring that the final sheet matches the source PDFs in terms of layout, font, and overall design. **Essential Requirements:** - **Proficiency in English:** As the documents are in English, strong language skills are necessary. - **Experience with PDFs:** Prior experience working with PDF documents, including converting their content while retaining the original format. - **Attention to Detail:** Since an exact match is needed, the freelancer must have an eye for detail, ensuring every aspect of the document is replicated in the sheet format. - **Formatting Skills:** Ability to use te...
...electronics, particularly in the healthcare sector. The model you create will play a crucial role in advancing the development and marketing of this device. **Project Requirements:** - **Design a 3D model** of the healthcare device provided in the specifications. - **Attention to Detail**: The model must include all components and be accurate to the design sketches and specifications. - **Confidentiality**: Must be willing to sign an NDA as the device is under patent pending status. **Ideal Skills and Experience:** - **Expertise in 3D Modeling Software**: Proficient in software such as AutoCAD, SolidWorks, or Blender, with a focus on creating models for consumer electronics, especially in healthcare. - **Experience in Healthcare Devices**: Previous projects invo...
...models using SolidWorks and AutoCAD DWG format. The main purpose behind this conversion is to facilitate 3D modeling that allows for both editing and modifications, as well as ensuring compatibility with our current software tools. Ideal Skills and Experience: - Proficiency in SolidWorks and AutoCAD - Experience with converting 2D drawings into 3D models - Ability to add detailed elements to basic shapes and forms - Understanding of how to incorporate textures and materials for a realistic appearance Project Scope: - Convert 1 drawings from PDF to SolidWorks and AutoCAD DWG format - Ensure intermediate detail in the 3D models, focusing on both accuracy and aesthetic aspects Responsibilities: - Review provided PDF drawings to understand the required specifications...
I'm seeking a skilled developer to implement a system that sends our customers push notifications on WhatsApp concerning their orders. Our existing database manages order updates and stat...need to do 1 more thing, we need to show the same information in UI format on our website as well. (Screenshot of a demo is attached) 2 - Let's say that a customer is placing an order for xyz product, but that product is not available with us, then a Google sheet (spreadsheet) will be updated every day from our end with a variable (est. date at which the product would be available) and we would be sending a WhatsApp to the person giving them 2 options - either to wait or to cancel their order, whatever they choose would be updated in the sheet and an SMS would be sent to them as...
I am on the lookout for an experienced bookkeeper proficient in German accounting software to handle the annual bookkeeping of my German company. The tasks include: - Maintaining account records - Producing balance sheet, income statement, and cash flow statement on annual basis. This role requires attention to detail and in-depth knowledge of accounting software and German accounting standards. Prior experience in similar roles will be an edge. Looking forward to your bids.
I am in need of a freelancer proficient in Google Sheets formula development, especially in the area of sum, division, and multiplication. The spreadsheet task has a moderate level of complexity featuring multiple data inputs. I run a roofing company and need a sheet that will mirror my material order form and calculate all accessories with formulas. Attached is the form I want done and how it is usually filled out. Each accessory has a different formula to calculate the total. This is what I need my google sheet to do automatically from adding the list of fascia and gutter lengths and dividing by a number Ideal Skills and Experience: - Advanced knowledge in Google Sheets - Proficiency in creating complex formulas including SUM, DIVIDE, MULTIPLY - Experience in handling ...
I'm in need of a skilled Google Sheets Developer to automate processes in my current system. The necessary tasks include: - Creating order sheets and saving them as PDFs. - Adding new orders and shipments into the database. - Ensuring a simple, functional, and user-friendly interface. The project timeline is tight. ...interface. The project timeline is tight. Work must be completed within a week. Though, I would classify the complexity of the project as simple - it mainly involves using scripts to automate tasks and create a user interface. The ideal candidate should have significant experience in working with Google Sheets and a working knowledge of scripts. Past experience in similar projects showcasing order sheet generation and automation of processes would be a signifi...
I have a local car dealership. I want an expert in excel to create an excel sheet for tracking, daily weekly monthly and yearly car inventory tracker
I am looking for an e...factors affect the tanks' performance and longevity. **Ideal Skills and Experience:** - Proficiency in CAE software (e.g., ANSYS, SolidWorks Simulation) - Strong background in mechanical or structural engineering - Experience with FRP materials and knowledge of their behavior under various conditions - Ability to interpret analysis results and provide actionable insights - Effective communication skills to report findings clearly This project requires someone with a keen eye for detail and a profound understanding of structural analysis and material science, particularly relating to FRP materials. Your expert analysis will guide the optimization of these tanks' design, ensuring they meet all required standards and performance criteria unde...
I'm looking for a specialist to draft building plans for a permanent ADA ramp for my home. The primary objective is to improve the accessibility for myself and family. The material should be durable and budget-friendly. Ideal Skills: - Expe...low-cost materials - Good understanding of what materials are practical and cost effective - Demonstrable understanding of building codes - Proven track record in similar projects Please be prepared to provide examples of ramps you've previously installed, and indicate what materials were used. It would be a bonus if you could provide ballpark quotes for each of the material options (wood, concrete, metal). This could better assist me in deciding the most cost-effective and durable choice. Your help will greatly improve the quality ...
...materials sourcing, schedule rollout, to the final stage of the project. - Illustrate a thorough structural design analysis. Explain in detail how the construction will comply with necessary standards and regulations. - Expose any potential risks, then provide effective safety measures to mitigate these. A proven track record in handling relevant projects is an added advantage. Your past work experiences are not required in the submission, but ensuring the above details are well articulated will increase your chances of winning the bid. Build calculation of required material and labor for below job. Construction and installation work for the construction of a foundation for a "sectional metal column" type cell tower (solid reinforced concrete foundation): Ex...
I need assistance with advanced data organization in an Excel sheet. My data consists of both numerical and textual elements that require sorting and structuring. - Textual Data Organization: I would prefer the textual data to be organized by date. Hence, the ideal freelancer should be proficient in Excel date functions. - Date Format: For consistency, I prefer all dates to be organized in the MM/DD/YYYY format. Advanced knowledge of customizing Excel date formats would be a key skill for this task. Overall, I'm seeking someone skilled in advanced Excel features, who can manage both numerical and textual data with a strong understanding of date format customization. Need money spent on a trip to be put into an excel sheet, with the final number below.
...existing Canva sell sheet. The purpose of this sheet is to effectively showcase my products/services, capturing the attention of potential customers and partners. The document needs specific adjustments: - **Layout Redesign:** The current layout doesn't quite highlight our products/services as effectively as it could. I'm looking for a more dynamic, engaging layout that organizes information clearly and attractively. - **Visual Enhancement:** Beyond just structure, I want the design elements of the sell sheet to be more compelling. It should not only align with our brand's aesthetic but also stand out in a sea of competitors. Think creative use of visuals, typography, and space that resonates with our target audience. **Requirements:** - P...
I am seeking a capable website designer to create an efficient shopping cart for my online store. Ideally, you should have abundant experience wi...between 100 and 500 products without compromising its performance or user experience. We need shipping templates Product review Additional info sections Product safety sheet download on every product where applicable Ideal candidates should have demonstrable proficiency in eCommerce website design, especially on platforms accommodating one-time payments like WooCommerce. Familiarity with online payment systems, specifically PayPal, is necessary. If you have a knack for sleek, user-friendly design to enhance product search and filtering, I'd love to hear from you. Our website needs to be an equal to screwfix web...
...standard and customized metal engineered building products. Our ongoing demand includes roofing sheets, wall panels, structural steel, roof and floor trusses, engineered wall assemblies (sheet and rockwool sandwich construction with internals), plus outdoor structures such as fabric and truss temporary buidlings (small to med size) and pergola systems. **What I Need:** - **Versatility**: Ability to supply both standard and customized items. - **Range of Products**: From basic structural elements to specialized outdoor and architectural features. - **Quality and Compliance**: High-quality materials that meet international standards. - **Supplier Sourcing**: Ongoing supplier sourcing & management. **Ideal Candidate Skills and Experience:** - Expertise in sourcing me...
this is my quote for the project to design a SolidWorks STEP file for Furniture Accessories Regards
I'm in need of a STEP file for manufacturing mechanical parts specifically oriented towards SolidWorks compatibility. Here are some details to take into account: - The output should be suitable for product manufacturing. - The design should focus on mechanical parts. - The most essential requirement is compatibility with SolidWorks. Ideal candidates are those with extensive experience in creating SolidWorks compatible STEP files for mechanical parts manufacturing. Proficiency in SolidWorks and a good understanding of the product manufacturing process will be instrumental in this project's completion.
Title: 3D model in solidworks Given data: Base Technical drawing of a Hydraulic cutter with dimensions of Length, width and breadth. The parts of the Hydraulic cutter is to be figured out and the dimensions can be assumed to create it requirements for project completion: 1. 2D sketch of the Hydraulic cutter - with Dimensions(assumed of course) and of parts 2. 3D model of the Cutter. This is purely for personal use. Please don't misuse any data More details: What level of detail do you need for the 3D model? Medium level of detail What format do you need the 3D model delivered in? IGES/STEP (for CAD) Will you require any additional features for the model? Moving parts simulation, Stress analysis, Assembly instructions
I'm in need of a skilled freelancer who can efficiently convert my Google Sheet document into a Microsoft Word file. The primary goal is to keep the visual data intact, specifically focusing on the translation of charts. - **Key Requirements:** - Solid experience in Google Sheets and Microsoft Word. - Proficient in inserting and formatting charts within Word. - Ability to apply Word's default formatting while ensuring a clean, professional look of the document. - **Project Steps:** 1. Receive Google Sheets file from me. 2. Convert the Sheets into a Word document. 3. Apply Word's default formatting to the converted document. 4. Carefully insert charts from the Google Sheets into the Word document, ensuring they are correctly formatted and visually appe...
Seeking a mechanical engineer to design a custom tricycle based on an image using Solidworks. Expertise in functional design for manufacturing is essential. Deliverables include: * Individual part drawings with BS8888 & GD&T compliance. * Complete 3D assembly model. * Assembly drawing with BOM, exploded view, and accurate component balloons. * Design evaluation and optimization with updated drawings. Contact with image reference for discussion.
I'm seeking the expertise of a 3d or facade designer to completely revamp the front view of my existing home. The anticipated outcome is to have a modern and sleek outlook. Key tasks ...outcome is to have a modern and sleek outlook. Key tasks for this project include: - Changing the existing external finishes - Installing new, visually-pleasing outdoor lighting - Replacing the old front door In terms of preferred materials, I'd love to have a mix of stone metal, wood and glass strategically incorporated in the design to achieve the desired modern appearance. Ideal freelancers for this project should have a proven track record in similar renovation projects and a good understanding of modern design concepts. I will provide references for the colour...
I'm seeking an Excel-savvy freelancer who can design a comprehensive stock management solution tailored for my metal material business, handling an assortment of steel products, including Round Bars, Sheets, Coils, and Pipes. Key Features Needed: - **Category Management**: Ability to categorize products neatly by type (e.g., Bars, Sheets) and further organize them by size for easy scanning and retrieval. - **Detail Tracking**: A meticulous tracking feature for each stock item, detailing Size, Quantity, Grade, Make (Country of Origin), and Quality (Prime/Subprime). Accuracy in this aspect is crucial for inventory precision and decision-making. - **Custom Reporting**: Capability to generate reports based on the provided attributes, aiding in stock level assessments, reor...
I'm looking for a skilled graphic designer to create a single-page corporate-style product data sheet that is engaging and informative. This sheet will need to include: - Product specifications - Usage instructions - Pricing details The final product should be delivered in PDF format. Ideally, you have past experience creating professional, corporate-style design materials and can provide samples of your previous work. Familiarity with Adobe InDesign or other professional design software will be a plus. Accuracy and attention to detail are key in this task as the information presented directly impacts our customers' decisions.
