Data sheet in excel jobs
I'm in need of a professional who can assist with reformatting my bank transaction CSV file for QuickBooks import. Key Requirements: - Reorder columns of the CSV file to meet QuickBooks' requirements. - Ensure the final CSV includes Date, Description, and Amount columns. - Amounts must be appropriately sorted into separate columns for positive and negative amounts. Ideal Skills: - Proficiency in Excel is a must. - Previous experience with QuickBooks and CSV file formatting is highly preferred. - Attention to detail to ensure all data is accurately processed.
I'm in need of a professional who specializes in Excel VBA and Outlook email automation. I have made some experimental progress but I am currently stuck and would appreciate assistance in troubleshooting my existing code and learning basic coding concepts. The specific tasks required include: - Automating email generation from specified Excel worksheet cells on a schedule based on corresponding dates in other cells. - Incorporating specific types of content into the body of these emails, including text and hyperlinks. - Assisting me in understanding and learning basic coding concepts. Ideally, you would have extensive experience with Excel VBA and Outlook, and be able to explain concepts in a clear and understandable man...
I need a comprehensive spreadsheet that will help me understand what rate I need to charge in order to justify a capital investment. This investment is mainly in financial modelling. Key Requirements: - The spreadsheet should be able to calculate and display the Cost of business with added capital costs - It should consider Fixed costs, Variable costs, capital, and pay out in its calculations - Ideally, it will include the ability to calculate and display ROI (Return on Investment), NPV (Net Present Value), and IRR (Internal Rate of Return) as well. Skills and Experience: - Proficiency in Excel or similar spreadsheet software - Strong background in financial modeling and analysis - Experience with capital investment projects - Ability to create u...
I'm seeking a comprehensive list of 70 rent-a-car companies in Dubai, specifically their CEO and Managing Director contact details. The final deliverable should be an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in data collection and research - Experience in creating comprehensive, accurate spreadsheets - Understanding of corporate hierarchies, particularly in the transport and rental sectors Please ensure the information is current and accurate, as this will be crucial for my project. Thank you.
I'm looking for an expert in Make automation who can help me automate the process of extracting data from my one-page guest satisfaction surveys. These surveys are available as scanned pictures (jpg). Key Requirements: - Files will be placed in a Google Drive Folder and processed immediately, one by one - Reading and extracting data from the picture - Parsing different types of data fields which include text fields, number ratings, multiple choice options, and handwritten entries - Uploading the extracted data to a Google Sheet Experience with Make automation and data extraction is a must. The ideal freelancer for this job should have a keen eye for detail to ensure all data is accurately captured and transferred.
I'm seeking someone to review a library of online recipes with how-to videos. Your task will be to assess and update metadata, starting with the number of servings the recipe is for. You will need some basic cooking experience to understand the recipes and their context. I'll provide a Google Sheet with links to the recipes, and you'll update columns in the spreadsheet with relevant metadata and questions/comments. I'll also provide some examples and very light training.
...Stefan-Boltzmann Law, Wien’s Displacement Law). • Energy distribution and star properties. 2. Mathematics Astronomy and astrophysics problems rely heavily on mathematical skills. • Calculus • Differentiation and integration for modeling motion and energy. • Understanding rates of change in celestial mechanics. • Trigonometry • Spherical trigonometry for celestial coordinates and angles. • Applications in observational astronomy (e.g., azimuth and altitude calculations). • Linear Algebra • Useful for solving equations in orbital dynamics and angular momentum problems. • Statistics and Probability • Light curve analysis and error estimation. • Transit detection and probability calculations...
I'm seeking a dedicated individual to filter and provide me a list of 2000 Instagram influencers. The goal is to identify suitable partners for a drop shipping venture who can make a promotional video of a product. Key Requireme...shipping venture who can make a promotional video of a product. Key Requirements: - Influencers should have between 1,000 followers - The primary content category of these influencers should be related to drop-shipping. An ideal candidate for this project would be someone with a keen understanding of the drop shipping industry and experience in influencer marketing and expert in filling and filtering data in Excel. Skills in social media analysis and data filtering will be highly beneficial. Please be pre...
Proposal and Proof of Work Requirements for Dynamic Excel Sheet Development We are seeking an experienced Excel developer to create a dynamic, visually appealing, and proprietary tool for our loan officers. This tool will enable our team to present purchase and refinance scenarios to clients, offering detailed calculations, comparisons, and insights. It should reflect Cohen Mortgage branding, include precise mortgage insurance premium calculations for different loan programs, and be protected to maintain its proprietary nature. Project Scope and Features: 1. User Data Entry Inputs: - Property address - Purchase price - Down payment percentage - Loan amount (calculated automatically) - Interest rate (fixed or adjustable options) - Loan term (e.g., 15, 20, 30 y...
Dear all I have created a few months ago some financial documents for the investors, but I need to rework on them and update them, so I can share them with the investors and the banks. I want these files to clearly described or displayed the required funding and expected returns (5 years projection) Balance sheet and cash flow projections ROI Payback period Profit margins
I need an Excel Catalogue converted into a visually appealing, professional PDF Catalogue for customer showcase, print and online publication. Key Requirements: - Transforming an Excel Catalogue into a PDF - Designing a professional and formal layout - Incorporating product images, detailed descriptions, and pricing information - Image high resolution Ideal Skills: - Proficient in Excel and PDF design software - Excellent graphic design skills - Experience in creating product catalogues Please only apply if you can demonstrate a strong portfolio in similar projects. The file work on is in this google drive link: Please give me your best quote
Please Sign Up or Login to see details.
I'm in need of a sleek, contemporary cricket team sheet. The sheet should accommodate player names and positions, and should be designed in a modern and clean style. This project would be perfect for a designer with a keen eye for minimalistic aesthetics. Prior experience with sports-related designs will be a plus. Please, no clutter and unnecessary embellishments - just a clear, functional and stylish design.
I'm seeking a beginner-level assistant for my regular work. Your primary tasks will involve conducting research and creating simple PowerPoint presentations on given topics. Key Responsibilities: - Researching topics and creating simple PPTs - Managing existing team, project and content in excel or in team management app Skills and Experience: - Proficiency in Excel and PPT and notion or project management software Ideal Candidate: - A college student with a working computer - Looking for long-term work - Flexible with working hours Please note: - We will connect over a call on Saturdays or Sundays for planning and learning sessions.
data entry (copy EAN code, SKU, and size) from label /image 418 label /image to Excel spreadsheet / google sheet file. Need diligency skills. All images are doubled in the folder (840 images but we need 418 unique records)
I'm seeking a Power BI expert to create a simple model from a small dummy dataset which will be provided. Need this completed as soon as possible. The model should generate reports for trial balance, cash flow, balance sheets, and P&L from a small dummy dataset in Excel which will be provided. Key Requirements: - Create visually appealing and informative reports using charts and tables. - Highlight specific metrics and KPIs, namely revenue growth, net income, and cash flow status. Ideal Skills and Experience: - Proficiency in Power BI, with a strong portfolio of similar projects. - Excellent understanding of financial metrics and reports. - Ability to create engaging visual elements.
Update the Products weight on my website from the Provided Excel file.
Excel VBA Macro Debugging - Compiler Error Fix I'm encountering a compiler error while running a macro in Excel VBA. The macro is primarily designed for data manipulation and includes various functions. I need assistance to diagnose and fix this issue so the code can run without errors. Ideal Candidate: • Extensive experience with Excel VBA and macros. • Strong troubleshooting skills to resolve compiler errors. • Proficiency in data manipulation using macros. • Ability to maintain existing code functionality while fixing errors. Important Instructions (Read Carefully): 1. To Be Considered: You must resolve the error and provide the complete, functional code. I will test the code, and payment will only be made if ...
Objective of the task: inventory of the entire sheet of the basic map of a fragment of Ursynów, Warsaw, Poland, including all of the elements of land development. Task content: Georeference the base map based on the files in the Ursynów folder () with an accuracy of 10 cm (use a minimum of 44 geodesic crosses). Remember the frame data and coordinate system (2000-PL). Create a file geodatabase to store all object classes. Create layers (feature classes) within the geodatabase and vectorize all of them objects visible on the base map, i.e. buildings, trees, lawns, roads, slopes, stairs, elements buildings, sheds, garages, sandboxes, waste bins, etc. (minimum 15 layers). There can’t be any empty spaces so choose the layers to vectorize wisely. After v...
I need licensed engineer to stamp my MEP and Structural Engineering drawings, I have three projects where i need the licensed engineer stamp for the MEP i need stamp from California and Alabama licensed engineers and for the structural i need florida licensed engineer, I have alot of work related to the only stamping, i dont wanna go per sheet on each project but a fix price for the project will work for me. Please give your quotes Thanks
Trasfering arabic information in PDF to Excel data Manually (Example attached). This project for arabic speakers only
I need an Excel Catalogue converted into a visually appealing, professional PDF Catalogue for customer showcase, print and online publication. Key Requirements: - Transforming an Excel Catalogue into a PDF - Designing a professional and formal layout - Incorporating product images, detailed descriptions, and pricing information - Image high resolution Ideal Skills: - Proficient in Excel and PDF design software - Excellent graphic design skills - Experience in creating product catalogues Please only apply if you can demonstrate a strong portfolio in similar projects. The file work on is in this google drive link: Please give me your best quote
Freelance Opportunity: Rebar Modeler & Sheet Detailer (Tekla Software Expert) We are seeking a skilled Rebar Modeler with expertise in Tekla Structures to join our team as a freelancer. If you have a keen eye for detail and the ability to create precise rebar models and detailed sheets, we’d love to collaborate with you! Responsibilities: - Create accurate **rebar models** using Tekla software. - Develop **detailed sheets** for fabrication and construction purposes. - Collaborate with the design team to ensure compliance with project requirements and standards. - Proficiency in **Tekla Structures** for rebar modeling and sheet detailing. - Strong understanding of rebar detailing and fabrication processes. - Experience in structural...
I'm looking for a dedicated professional to assist me with various data entry tasks. Key Responsibilities: - Inputting data into spreadsheets - Managing databases - Providing transcription services Ideal Skills: - Proficient in Microsoft Excel - Experience with Spreadsheet data input, Database management, and Transcription services - Attention to detail and ability to work independently.
...construction management workbook in Excel that requires some enhancements. The enhancements include improved data analysis tools, a user-friendly interface design, advanced reporting features, and syncing with QuickBooks. I also want to integrate a construction schedule into the workbook. Specifically, the types of data analysis tools I want to improve are custom formulas, pivot tables, and data visualization techniques such as charts and graphs. Ideal Skills and Experience: - Expertise in Excel, specifically in creating and modifying workbooks - Experience with construction management tools or software - Proficiency in designing user-friendly interfaces - Knowledge of QuickBooks for potential syncing - Ability to create...
...some additional hours of work. There is a lot of flexibility. Most tasks can be completed within a 2 – 4 day time-frame. There will only occasionally be tasks that require urgent attention. The attached document: ‘Duties for Personal Assistant’ explains what is involved in more detail. The ideal person will have: Excellent / professional level written English, and Fluent spoken English. Professional, but also fun, easy-going / casual and happy, positive personality and communication style. Email Online calendar Excel Word Looking for an on-going, casual, working relationship over several years. Experience / knowledge of the Entertainment industry desirable, but not essential. Ok with being paid every month or every 2 months (to reduce transaction f...
...I need assistance in verifying the completion of 22 Python coding assignments by my students. The assignments are at a very beginner level and are located in Python/Jupyter notebooks. Your task will be to check that each student has completed their respective assignment. There is no need to grade the submissions for accuracy, simply confirm whether each assignment has been completed or not. Requirements: - Provide each student's name and their corresponding grade on a separate sheet. - The format of the student names and grades can be in any form (Excel spreadsheet, CSV file, or even handwritten/scanned). - No specific comments are required on the assignments, just a confirmation of completion. - Results can be organized in any order (alp...
...streamline our HR processes using Microsoft Forms and Excel. The main aim is to utilize Microsoft Forms for case raising, where employees can report various issues. Key Responsibilities: - Set up Microsoft Forms for case raising - Utilize Excel to track each client, employees, auto send email notification with a unique ID - Implement direct data import from Microsoft Forms to Excel and a dashboard -Excel dashboard for clients and employees Ideal Skills: - send email via outlook to each client absence data weekly -Excel invoice system - Save files auto from email to drive or excel - Proficiency in Microsoft Forms and Excel - Experience with HR processes - Ability to create and manage a unique ID system in ...
I'm looking for an expert in Excel who can help me analyze some racing data. The main tasks will be comparing performances and identifying trends. Ideal skills and experience for the job include: - Proficiency in Excel - Experience with data analysis - Knowledge of racing data is a plus.
Project Title: Scrape Google for National Facility Management Companies in the U.S. Description: We are looking for a skilled freelancer to scrape Google and compile a comprehensive list of national facility management companies operating in the United States. The goal is to identify businesses similar to the following examples: • The Centurion Group • Broadway National Deliverables: A complete list of facility management companies, including the following information for each company: 1. Company Name 2. Website URL 3. Phone Number 4. Email Address 5. Headquarters Address (if available) 6. Other Relevant Contact Information (e.g., contact person, LinkedIn profiles) Requirements: • Scrape Google, business directories, or other publicly available res...
I'm seeking a professional to assist with my eBay listings and dropship product sourcing. Your tasks will include: - Locating Amazon U.S. suppliers for specific product categories - Extracting dropship products into an Excel spreadsheet - Creating custom eBay template descriptions - Optimizing draft listings and making auction posts live The ideal candidate should have prior experience with eBay product sourcing and listings, and be proficient in Excel. Understanding of product categories and ability to create appealing product descriptions will be a plus. Your primary focus will be on specific product categories, so familiarity with these categories will be beneficial. You will need to extract the following information for each dropship product: - Product tit...
...multiple Excel files that contain customer details such as name, address, suburb, postcode, and telephone number as part of delivery manifests for a freight provider. I'm looking for an Excel expert who can help me consolidate these files into a single, clean customer database. There are approximately 75 separate excel files and about 600 customers. Key Tasks: - Extract contact details from all files - Merge all files into one without duplications - Count and record how many times each customer appears across the separate freight manifests The final merged file should be in Excel format and include the contact details along with an appearance count for each customer. Ideal Skills & Experience: - Advanced Excel skills (data ex...
I'm looking for an Excel wizard to craft a reconciliation tool for two payment datasets - our Genie Ledger and Payment Gateway Data. Key Tasks: - Identify critical data fields for reconciliation, focusing on Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a user-friendly tool that compares both datasets and displays all calculations on a dedicated front cover sheet. - Spot any discrepancies and highlight them in red on the front cover sheet. Ideal Candidate Should Have: - Extensive experience with Microsoft Excel, particularly with macros and VLOOKUP. - Strong analytical skills and attention to detail. - Ability to present data clearly and in a list format. I need a straigh...
I'm looking for a web interface to help soccer coaches and parents track player tra...various soccer and kinesiology metrics - User-friendly interface for coaches and parents Ideal Skills: - Figma Design - Web Development - Data Integration - User Interface Design Your deliverable: - Interactive, high-fidelity Figma, Sketch, or Adobe XD design prototype The data used by the web interface will come from our servers, but for now, I will provide an Excel file with all the parameters. Please include relevant examples of your work in your proposal. For this project, I will give the dataset to the selected designer. Please read the attached scope of work before sending your proposal. I will know if you have read it. Please include your lead time in your...
...scheduled for later. • For scheduled messages, the admin specifies the date and time. • Once the broadcast is sent: • The bot generates an Excel report showing: • Total number of recipients. • Names and usernames of users the message was delivered to. 2. User Management • The bot will keep a record of all users who activate it. • Admin Command: /users • Generates an Excel report listing: • Serial Number () • Name • Telegram Username of each user. 3. Prize Distribution • The bot will handle contests where users can win prizes. • Command: /prize • Users will enter a number (admin pre-selects the winning number in advance). • First user to submit th...
We have an existing Google Sheet that we want to turn into an Excel Sheet, but when we download it and open in excel the formulas to not come with it properly. Wanted to see if y'all could help us with it?
I am looking for assistance in collecting and organizing product information for a new online store. I have a spreadsheet with 2475 product lines distributed across five suppliers. Each product line includes a direct URL to the supplier's product (search) page. Your task will be to extract product images, descriptions, and any relevant details from these pages. If a product is no longer available, it should be skipped, and this should be noted in the spreadsheet. Supplier Breakdown: Casu: 136 products DCT: 327 products Kama: 294 products Max Fritid: 1169 products Movera: 545 products Deliverables: Structured Data: Use the provided Excel sheet and fill in the designated columns with extracted information, including: 1) Product Name 2) Descri...
I need an expert in Microsoft Power Automate and C# to help me automate my weekly email process. Currently, I manually prepare emails in MS-Word, pulling customer data from MS-Excel, and sending through MS-Outlook using mail merge. I utilize 25 different email accounts, sending 2000 emails from each account to my customers, with the content being a price list with images. I want a system that automates this process. The emails should be sent from the 25 accounts to the customers from the Excel file automatically, with each account sending out 2000 emails. Skills and experience required: - Proficiency in Microsoft Power Automate - Experience with C# for custom scripting - Familiarity with mail merge in MS-Word, MS-Excel, and MS-Out...
...scraping specialist to develop a program that scrapes product data from the Schneider Electric website. The program should meet the following requirements: Program Requirements Input: Accept a list of product codes (e.g., ATV212HU40N4, ATV212HU55N4) provided in a CSV or XLSX file. Accept a list of specific parameters to scrape, such as "Device short name," "Motor power kW," "EMC filter," etc. Output: Generate a CSV or XLSX file with: Column A: Product codes. Row 1: Names of the selected parameters. Rows below: Data for each product. Additional Data to Scrape: For each product, the following should also be scraped: Link to the main product image. Link to download the "Product Datasheet." Link to download the "In...
I'm seeking a meticulous freelancer for manual data entry tasks. You'll be working with provided PDF files and inputting data into an Excel spreadsheet. Key Responsibilities: - Carefully extracting and entering data from PDF files into an Excel spreadsheet - Ensuring accuracy and attention to detail throughout the process Ideal Skills: - Proficient in Excel - Excellent attention to detail - Previous experience in manual data entry - Comfortable working with PDF files.
...Deliverable - Deliver a set of drawings in Auto-cad with complete specifications and material list with price and order information. Deliverables Drawings = Page 1 Cover sheet with project information, project name, address. Page 2 Current floor plan void of furniture with dimensions named Existing Layout Page 3 Demolition Page 4 Architectural with material schedule Page 5 Millwork (cabinetry) with material schedule Page 6 Plumbing with materials scheduled Page 7 Electrical with lighting and data cabinet schedule Page 8 Furniture Page 9 3D views Page 10 Include details or installation instructions from manufacturer this may be as many pages as necessary. I need the product in Adobe with an Auto Cad file and a 3D illustration fly through photos Deliver dates ...
...athlete-specific data fields. Data Fields to Collect for Athletes: The form must capture specific details such as: Full Name Date of Birth Blood Type Allergies Passport or ID copy upload (mandatory) Export Functionality: The system must allow the export of all registered athletes into an Excel file. The exported Excel file should include all the collected personal data in separate columns (e.g., Full Name, Date of Birth, Blood Type, Allergies, etc.). Uploaded documents (e.g., Passport or ID copies) should also be exportable or downloadable. Additional Notes: The solution must integrate seamlessly with WooCommerce's existing checkout process. The form and its functionality should be user-friendly and error-free. Security is essential for h...
Please Sign Up or Login to see details.
I'm an advanced user of Microsoft Excel, seeking assistance with some issues I'm encountering. You will need: - Extensive knowledge of Microsoft Excel - Experience with troubleshooting complex spreadsheet problems - Ability to communicate solutions clearly and effectively
...attached Excel sheet. Fill out just the price, year, mileage, and link columns: 1. 2. 3. Facebook marketplace 4. https://www.ironplanet.com/Tanker+Trucks 5. 6. 7. 8. 9. https://www.truckplanet.com/Tanker+Trucks 10. 11. Then for any vehicles that meet all of the Criteria listed below, fill out all of the columns of the Excel sheet. You will
I need assistance with importing our sales leads from an Excel file into our CRM system, Recman. Key Requirements: - The Excel file is stored on Drive and needs to be accessed, processed and imported. - The specific data fields to be imported include: Contact information, Lead source, and Sales history. - No specific data transformation or mapping is required, the data can be imported as is. Ideal Skills: - Proficient in handling Excel files, particularly in a Drive environment. - Familiarity with Recman CRM is a plus. - Good attention to detail to ensure all relevant data fields are correctly imported.
I need a comprehensive movies list exported into a CSV from IMDB. list should include key details like title and release year, director and cast, as well as genre and rating. Ideal skills and experience for the job include: - Proficiency in data management and export - Extensive knowledge of movies and film industry - Skilled in using Excel or CSV formatting.
