Data sheet in excel jobs
...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.
I have 12 months worth of bank transactions from three different accounts that need to be consolidated into a single spreadsheet. Key Responsibilities: - Convert transaction logs from PDF to Excel format - Create a spreadsheet that includes: - Account name - Date - Description (only keywords from the full transaction description) - Address - Amount - Balance of each transaction Required Skills: - Advanced Excel - PDF Conversion Software Please note: I will categorize the transactions once all data is combined into one document. The freelancer will not need to do anything besides conversion and/or copy from one format to another.
I'm loo...can create a comprehensive inventory sheet tracker in Google Sheets. This tracker needs to display the variance week after week across 52 weeks. Key Requirements: - Track a variety of data: product quantities, inventory levels by location, items received, items sold, on-hand inventory, transfers, and purchases. - Incorporate automation features: The tracker should automate data entry and calculations to streamline the process. Ideal Skills and Experience: - Proficient in Google Sheets with a deep understanding of its functions and capabilities. - Previous experience with creating inventory trackers or similar tools. - Ability to implement automation features in Google Sheets for efficient data handling. - Strong attention t...
Project Overview I am developing a feature-rich Property Management Platform that helps landlords, property managers, and staff streamline every aspect of property oversight. This project extends beyond basic property/tenant management, incorporating advanced financial accounting, invoicing, document management, automated notifications, staff/vendor management, analytics, data import/export, and robust security measures. Initially, we’ll focus on a web-based solution using React (front-end) and Node.js + PostgreSQL (back-end). We also plan to future-proof the system for possible expansions to desktop and mobile platforms. If you have experience building complex, secure, and scalable SaaS/web apps, we’d love to see your proposal! Key Features & Modules 1. Property...
I'm looking for someone skilled in Excel to help me with a data transfer task. I need to pull information from one spreadsheet and add it to a column in another. Key Requirements: - Transfer of text data between two simple spreadsheets (comprising simple rows and columns) - Matching of data based on an exact match in a single column Ideal Skills and Experience: - Proficient in Excel - Attention to detail to ensure accurate data transfer - Experience in data handling tasks
EXCEL Manufacturing Product scheduler/run time tracker We are developing a means to schedule components in an integrated excel spreadsheet that includes various production steps: (Functions) Laser, shear, punch, bend, paint, assembly, weld, assembly 2, shipping. To be save on a network-share point so all can access same document. The idea is to have a laptop at each station (listed above) 1a,1st step: Manual enter/copy paste-from engineering Initial step-Enter data (component part number(description)) into the first sequence, list all items from the project that needs to be produced. once entered, you can filter material gauges, material types in order to consolidate production run on the LASER. When running the selected items (check box) we track ti...
I need help organizing confidential client data in an Excel spreadsheet. The data is currently in one column and needs to be split into appropriate columns for First Name, Last Name, Phone number, Email, Birthdate, Mortgage start date, mortgage term, and Client Birthday. - Required Skills: Intermediate level Excel proficiency, with experience in using formulas to manipulate data in Excel. - Platform: The session will take place on Microsoft Teams, where I will share my screen. - Data Format: The data is currently organized in an Excel Spreadsheet. Due to the confidential nature of this data, I am unable to share it via email. The ideal freelancer for this job would be able to work sw...
I'm in need of a doors and windows-based software that can generate production drawings and quotations based on my cost estimations. I've laid out the algorithm in Excel files, which will be provided for this project. As a developer, your responsibilities will include: - Creating a user-friendly interface (UI) that allows easy access to the software's functions. - Implementing the cost estimation and production drawing generation features. The ideal candidate for this project should have robust experience in: - Java with JavaFX: This is my preferred programming language and framework for this project. - Software development for Windows: The software needs to be compatible with this platform. - UI design: The software should have a simple, intui...
I have a small excel file. I need to convert in excel VBA. The project will be completed by Spanish language. The file and more details will be shared via chat box. Thanks!
...seeking a skilled Excel expert to create a reconciliation tool for comparing two payment datasets. The first dataset comes from our internal ledger (Genie Ledger), and the second from our payment provider (Payment Gateway Data). Key Tasks: - Identify important data fields for reconciliation, considering factors like Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a tool that compares the two datasets, showing all workings on a dedicated front cover sheet. - Identify any reconciliation discrepancies and highlight them on the front cover sheet. The ideal candidate should have: - Extensive experience in using Microsoft Excel, particularly with macros - Strong analytical skills - Attention to de...
I require assistance with developing a macro in Excel. The macro needs to interact with local Excel files and perform specific functionality. The details of the functionality will be provided after the initial discussion. Ideal skills and experience for the job include: - Proficiency in Excel, particularly in macro development - Experience with automating tasks in Excel - Ability to understand and implement specific instructions - Good communication skills for discussing project details
Your logo name: JURO Tagline - Shaping Strength, Delivering Precision Business nature: SHEET METAL COMPONENTS MANUFACTURING
I'm looking to develop a multiuser website for collecting school ID card data and capturing photos. Key Features: - User Access: The website will be accessed by teachers and administrators. - Photo Capture: Users should be able to upload photos from their devices and also utilize real-time camera capture. The website should NOT include editing tools such as cropping. - Data Collection: ID card data will be uploaded via CSV/Excel files. Ideal Skills: - Full-stack web development - Experience with real-time photo capture integration - Proficiency in handling CSV/Excel uploads - Knowledge in developing multiuser platforms Please provide examples of similar projects you have completed.
...securing links in exchange for links from the websites we provide. Responsibilities: Identify niche-relevant websites for link exchange. Outreach to website owners, editors, or managers to negotiate ABC link exchanges. Provide regular reports on progress, including sites contacted, agreements made, and live links secured. Ensure high-quality and niche-relevant links (no spammy or unrelated sites). We will provide: A list of websites you can use to offer links in return (, , etc.). A tracking system for reporting progress. Requirements: - Proven experience with link building and outreach strategies. - Excellent communication and negotiation skills. - Ability to use email tools and outreach platforms effectively. - Familiarity with Google Sheets or Excel for rep...
I need an expert in Excel automation and API integration to help me in calculating GHG emissions, specifically Carbon dioxide (CO2). The primary data source for the calculations will be an API, so experience with API integration is crucial. The project involves: - Automating the process in Excel for GHG emissions calculation - Using API for manual data entry - Focusing on Carbon dioxide (CO2) emissions The final output of the project should be in the form of a dashboard visualization. Therefore, experience in creating dashboard visualizations is essential.
I'm looking for help with rewriting and transferring some Excel tables for financial reporting. The tasks are straightforward and primarily involve basic data transfer without the need for specific formulas or calculations. Standard formatting is acceptable, so no specific formatting guidelines need to be followed. Ideal skills for this project: - Proficiency in Excel - Attention to detail - Basic understanding of financial data - Good data transfer skills
I need my intricate Excel sheet transformed into a PHP web application, complete with a MySQL database. The Excel file consists of 10 interconnected tabs, filled with VBA functions and classes. Key Requirements: - Replicate data calculations and transformations in PHP - Create user input forms and validations - Implement user authentication system with multiple roles - User roles should include: - Admin: Full control and oversight - Editor: Able to modify content - Viewer: Restricted to observation only Ideal Skills: - Proficiency in PHP and MySQL - Extensive experience with Excel VBA - Strong understanding of user authentication systems - Ability to replicate complex data processes in web applications Please o...
...addresses. Source of Dataset: The dataset is provided in Excel format. Size: There are 11,817 entries requiring email addresses to be added. Data Type: The emails must be entered into the same spreadsheet. Important Guidelines: All email addresses must be sourced from publicly available information in compliance with GDPR and other applicable data protection regulations. The methodology used to locate these email addresses is at your discretion, provided it adheres to legal and ethical standards. Each email entry should be accompanied by a URL or source reference to verify its public availability. Ideal Candidate: Experience with manual data entry. Proficiency in spreadsheet software (e.g., Excel...
...values aren't displayed on the graph bars. For better visualisation, I need the numerical values to appear inside the graph bars as text. Add Averages to Reports: In the report section, include an average of the survey results. This should be visible both on screen and in the exported .xlsx file. Skills Required: PHP MySQL JavaScript (for graph enhancements) Experience with data processing and performance optimization Deliverables: Improved CSV import functionality with faster processing and guaranteed file availability. Graphs with displayed values inside bars. Averages displayed in both on-screen reports and exported Excel files. Additional Notes: Please ensure the changes are thoroughly tested before delivery. Let me know if you require acc...
...follow-ups.** I am a self-employed assistant (sole proprietor) in the sports field, and much of my time is spent answering questions related to sports and nutrition programs. This is the part I would like to automate: ### The process should be as follows: 1. The user submits their question to a chatbot (Telegram): they can send a written text, a voice message, or even a photo or a document. 2. The incoming message is sorted and analyzed: - If there are documents, they are stored in a G-Drive folder, and a Google Sheet is updated with columns for "timestamp," "interpretation" (summarizing the content of the document), and "link" (the "link" column contains the link to the document stored in G-Drive). This ...
...20 30 60 80 100 10 Cork 25 35 65 85 105 10 Galway 22 32 62 82 102 10 ... (Repeat for all 26 counties but different pricing per county excel be provided) Fastway Note: If all items are Fastway-eligible, apply a flat €10 delivery rate. Product that this applies too already done (and live like this) SIte already has fastways setup done, plust there is enquiry only about products which can't be ordered on the site. We expanding the setup to have 5 weight classes with each state/county (26 of them) having their own pricing for each weight class. However the surcharges for extra items in the basket be same across the 26 counties Logic for Multiple Items in Basket Base Price: Use the highest-tier item's delivery price as the base. Additional Items S...
...publishes data from Excel, specifically bond characteristics. The pages will include: Main, Bonds Selector, Indices, About Us, and an additional Bonds page. A Figma layout is provided and the task is to replicate it accurately. Key Features: - The website does not need to be responsive or mobile-friendly - Users will only view, not interact with or upload, Excel data Design Expectations: - A minimalistic and clean aesthetic, as opposed to modern or overly sleek designs - Corporate and professional styling is not required, but a clear understanding of minimalistic design is crucial Ideal skills for this project include: - Proficiency in front-end web development - Experience with Figma to web replication - Strong understanding of minimalistic design ...
I'm looking for someone to help me with creating a data entry form . The Excel template is provided by me. This will be a simple form that I can add my projects data to a spreadsheet also I can edit the Data. The Excel rows should be added automatically once a new project has been added .
Position Summary: We are looking for a rigorous and competent data entry professional to ensure the entry, processing and management of data in our systems. The ideal candidate will be proficient in office tools such as Word, Excel, Google Sheets, and will also have skills in data security and the use of Adobe InDesign. Responsibilities: - Enter, verify and update data accurately in databases or documents. - Organize and structure files and databases for optimal accessibility. - Use tools such as Microsoft Word, Excel, and Google Sheets for data management. - Respect data security protocols to guarantee the confidentiality and integrity of information. - Create or modify graphic docume...
Looking for a detail-oriented data entry specialist for product catalog management. (~1,500 products) Key responsibilities: Manual data entry of product information into Excel/Google Sheets Accurately copying product image URLs from provided online sources Following provided guidelines for data organization Requirements: Strong attention to detail Proficiency in Excel/Google Sheets Reliable internet connection Ability to handle repetitive tasks with accuracy We provide full training and ongoing support throughout the project. Part-time/flexible hours available. Please share your relevant experience and availability to get started.
Project Brief: eCommerce Data Analysis and Visualization Objective: To leverage data analytics tools to enhance decision-making, improve sales performance, and optimize customer experience within an eCommerce platform. Key Contributions: Excel: Cleaned, organized, and processed large datasets to ensure accuracy and consistency. Conducted advanced analyses using pivot tables, VLOOKUP, HLOOKUP, and data validation techniques. Developed dynamic dashboards for real-time tracking of sales, inventory, and customer metrics. Power BI: Designed interactive dashboards to visualize KPIs like revenue growth, cart abandonment rates, and customer acquisition. Connected multiple data sources to create unified reports, providing actionable insights for stakeholders....
I'm looking for a freelancer to help me link my Excel file containing employee names and shifts to another file. The data is personal and related to roster information. Ideal skills for this job include: - Proficiency in Excel - Experience with data linking - Understanding of personal data handling and privacy - Attention to detail
I'm seeking an Excel specialist to help me create a sophisticated dashboard and tracking tool for compliance data. Key Responsibilities: - Automating processes with macros to streamline compliance tracking - Assisting in the design and development of a user-friendly dashboard - Automated email system which track the due dates and triggers the email to the respective email addresses. Ideal Skills: - Proficiency in Excel with a strong focus on automation - Experienced in complex formula creation and data analysis - Prior experience in designing dashboards and tracking tools - Familiarity with compliance tracking is a plus Please provide examples of previous Excel projects you've completed, particularly those involvi...
