Excel 2007 dat file jobs

More details: What format would you prefer for the email addresses? Excel spreadsheet How many local authorities are you targeting? More than 50 What specific information do you need besides email addresses? Contact names, Phone numbers, Email addresses The project needs to be completed within 1 week. Please verify all email addresses to ensure accuracy. These email addresses will be used for outreach campaigns targeting local authorities. Please include the contact departments associated with each email address. Please categorize the email addresses by region. Please conduct manual verification to ensure the accuracy of the email addresses. Please treat all regions with equal priority. The primary purpose of this outreach campaign is to request collaboration. Please name the fi...

I'm looking for an Excel expert who can create a Google Sheet for tracking my cryptocurrency portfolio. The sheet should monitor Bitcoin (BTC) and Solana in real-time, displaying market prices, portfolio movements, and gain/loss metrics. It should also feature Line charts, Bar charts, and Pie charts to visualize the data. Key Requirements: - Proficiency in Excel and Google Sheets - Experience in creating real-time data tracking tools - Ability to create and integrate various types of charts Ideal Skills: - Strong understanding of cryptocurrency and market tracking - Excellent data visualization skills - Attention to detail to ensure accurate tracking of gains and losses

I'm in need of a professional who can develop a method to link multiple Word documents with various Excel files. The goal is to create a comprehensive mapping matrix to facilitate process automation. Key Requirements: - Mapping of diverse data types: This includes text, numbers, formulas, assessment questions and workbook content from the Word documents to the Excel files. - Establishing a Many-to-Many relationship: The project involves linking multiple Word docs to multiple Excel files, ensuring a well-structured and efficient mapping system. Ideal Skills: - Proficiency in Microsoft Word and Excel - Expertise in creating mapping matrices - Experience in process automation Your bid should reflect your ability to deliver a seamless, automated process thr...

...this project will focus on core functionalities like order creation and invoicing, with a simplified user role system (admin and non-admin) and no external integrations. 2. Project Scope 2. Implement a search function to quickly locate orders using various filters such as customer name, order ID, or date range. 3. Allow exporting orders and invoicing data in various formats like CSV, PDF, and Excel for external reporting or bookkeeping needs. 4. Set up email or SMS notifications for important events like order creation, completion, and shipping updates. 5. Maintain a detailed log of changes and actions performed on each order, such as edits, status changes, and notes. 6. Enable bulk processing features to handle multiple orders simultaneously for operations like status updates a...

I need an Excel spreadsheet template for a quality control inspection report tailored for a machine shop. Key Requirements: - The template should include an inspection checklist - There should be a section for Pass/Fail criteria - The template should be user-friendly and easy to navigate - The design should be professional and suitable for a machine shop context Ideal Skills and Experience: - Proficiency in Excel - Experience with quality control processes in machine shops - Ability to create clear, concise, and professional templates

I have a 2D data file (.dat) that ENVI can open and visualize. It is a datacube, in which every pixel has its own graph. It is in that sense a 3D data. I would like to do Principal Component Analyses on this data file to extract meaningful data, such as the variations and representative graphs / regions etc. I need someone who can write a code to do statistical analyses on a .dat file using python in jupyter notebook. Key Requirements: - Experience in Python, specifically in Jupyter Notebook - Proficient especially in using NumPy and SciPy for statistical analysis - Able to interpret and visualize data The data is structured in a gridded format with spatial dimensions. Each pixel in the datacube corresponds to a specific spatial location. I need someone...

I'm in urgent need of an Excel macros specialist who can help with data analysis and reporting on financial data. Key Requirements: - Expertise in Excel macros, specifically for data analysis and reporting. - Proficiency in handling and interpreting financial data. - Ability to create summary reports from complex datasets. Ideal candidates will have a strong background in finance and data analysis, with a track record of creating effective Excel macros. Please be prepared to showcase examples of your previous work in this area.

...scripts for efficient data extraction or those with a team capable of handling bulk processing. Requirements: • Expertise in Python or other relevant programming languages for PDF parsing • Experience with libraries such as PyPDF2, PDFMiner, or similar tools • Ability to extract structured data accurately (tables, text, etc.) • Handling of different PDF formats and layouts • Data output must be in Excel (.xlsx) format per template provided. Preferred Qualifications: • Prior experience with large-scale data extraction • Strong attention to detail and data accuracy • Ability to process PDFs with varying structures • Team availability for high-volume processing (if applicable) Selection Process: • We will conduct interviews to und...

...questionnaire with set parameters need to be uploaded on the site for the visitors to take the survey with a description of the survey and its importance. Once a survey is live we need to register the records for 45 days during that time our partner NPOs work locally in promoting and awaring people to take survey. Post 45 days we need to fetch all the information into spreadsheet (Google Sheet, Excel recommend) the using Power BI, python language another team work on analizing the records and forms a detailed illustration for the data. And a well defined resource backed research paper need to publish on the site in the form of blog and a download link for the papers. Based on working description of the company I need a mature design for the website. The work will include &quo...

I'm looking for a professional to help me fill out an Excel sheet for a financial model. The sheet will involve data from the Income Statement, Balance Sheet, Cash Flow, Operating Working Capital, debt, depreciation, amortization, equity, shares, and various financial ratios. The annual report is available for reference. Skills and experience required: - Extensive knowledge of financial modeling - Proficiency in Excel - Ability to interpret and analyze financial statements - Experience working with financial ratios - Attention to detail.

need to fix a bat file and explain to me how you fixed it here is the code i dont discuss the prize of payment i only accept what you bid if you want to talk to me about budget i will leave the chat please respect my wishes @echo off SETLOCAL ENABLEDELAYEDEXPANSION REM Define source file, destination folder, and executable SET "SOURCE_FILE=C:UsersmartiMusicver" SET "DESTINATION_FOLDER=C:Program Files (x86)PCGameBoostSmart Game Booster5.3.1" SET "EXECUTABLE_FILE=C:Program Files (x86)PCGameBoostSmart Game Booster5.3.1" REM Check if the source file exists IF NOT EXIST "%SOURCE_FILE%" ( echo ERROR: Source file not found: %SOURCE_FILE% exit /b 1 ) REM Create destination folder if it does not exist IF N...

I'm looking for a freelancer who can build a comprehensive dashboard in Excel for tracking employee performance data. Key Requirements: - The dashboard should track 16 key performance indicators (KPIs) related to equipment conditions. - Visual elements should include charts, graphs, gauges, and meters. I already make it but need to enhance and also to add more slides. Ideal Skills: - Proficient in Excel with experience in building dashboards. - Understanding of employee performance and equipment condition metrics. - Capable of creating user-friendly, visually appealing dashboards.

...appointments. Your main responsibilities will include: - Data Entry: Accurately inputting information into Microsoft Excel/Word. - Email Handling: Managing my inbox, sorting emails, and responding to necessary correspondence. - Scheduling Appointments: Coordinating my calendar and setting up meetings. - Travel Arrangements: Booking flights, hotels, and transportation for business trips. - File Management: Organizing and maintaining digital and physical files. - Document Preparation: Creating and editing reports, presentations, and other documents as needed. - Meeting Minutes: Taking detailed notes during meetings and distributing them as needed. I prefer using Microsoft Excel/Word for task management, so proficiency in these programs is essential. Communication w...

I'm looking for a freelancer who can analyze and format my sales data into a clear, tabular Excel report. Key Requirements: - Experience with Excel is a must, especially with data formatting. - Familiarity with sales metrics and how to present them in an informative manner. - Ability to meet deadlines and provide a high-quality, easy-to-understand report. The report will primarily focus on total sales, sales by product category, and sales by region.

I'm looking for an experienced Excel professional to compile a calendar for 2025 and 2026. This will include marking work tasks and deadlines, 2nd & 4th Saturdays, Sundays and all Hindu holidays. Key Requirements: - Organize data week-wise in an Excel sheet - Distinctly mark 2nd & 4th Saturdays and all Sundays - Highlight all Hindu holidays and list them in a separate column - Use Conditional Formatting and Pivot Tables to ensure easy readability and proper formatting Ideal Skills: - Proficiency in Microsoft Excel (Formulas, Conditional Formatting, Pivot Tables, etc.) - Data Entry & Processing - Attention to detail - Experience handling large datasets Deliverables: - Well-structured Excel sheet - Clearly marked week-wise data - Properly high...

I'm seeking a meticulous Data Entry Operator to assist with inputting and structuring data into Microsoft Excel. The job will entail: - Transcribing data from a variety of sources including scanned documents, PDFs, and handwritten notes into an Excel spreadsheet. - Ensuring the accuracy of the data and catching any potential errors. - Structuring the data chronologically for easy access and retrieval. - Upholding confidentiality when dealing with sensitive information. Ideal candidates should have: - A good typing speed and a high degree of accuracy. - Proven experience with Microsoft Excel or other data entry software. - An exceptional attention to detail. - The ability to meet deadlines consistently. Project Duration: 1-2 weeks (potential for extension based...

...Ideal candidates for this project should have: - Extensive experience in payroll and tax form preparation. - Familiarity with W-2C forms and the reasons for their use. - Ability to work meticulously and maintain a high level of accuracy. - Demonstrated track record of precision and attention to detail in payroll tasks. The employee information will be provided in a digital format such as an Excel or Spreadsheet. The W-2C forms should be completed within 2 weeks. The completed W-2C forms should be provided in PDF format. You may use any software you are comfortable with for preparing the W-2C forms. The freelancer should also review the corrected wage information to ensure its accuracy. The freelancer only needs to prepare the W-2C forms. The selected freelancer will be respons...

...organizing, and optimizing ad creatives for digital marketing campaigns✅ Web Development & Email Marketing Support: Help in basic website updates, email campaign execution, and tracking performance analytics✅ Inbox & Task Organization: Assist in managing and organizing business and customer emails for better workflow efficiency ? Requirements & Qualifications: ✔️ Expert in Google Sheets / Excel (advanced formulas, pivot tables, conditional formatting, scripting)✔️ Experience with Shopify API, , and Zapier✔️ Ability to automate data imports and reports✔️ Strong understanding of demand forecasting & financial modeling✔️ Experience working with inventory tracking and supplier forecasting✔️ Proficiency in customer support data tracking and report generation✔️ Ex...

...skills for various projects. Translation: Professional translation services for documents and content. Medical Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant experience in any of the above-mentioned fields. Ability to meet deadlines. Deliverables: High-quality, error-free work. Submission within the agreed timeline. Budget: Flexible, depending on the project scope and quality. These projects are long-term, requirin...

I require an Excel expert to streamline my weekly report process. This involves merging four distinct reports - Maintenance, Operations, Supply Chain Management (SCM), and Finance - into one comprehensive Excel spreadsheet. Key tasks: - Combine the four reports into one Excel sheet on a weekly basis. - Visualize the data trends over time using a bar graph. - Ensure the graph highlights the key trends across the four departments. - Automate the import of data from each of the four reports to reduce manual input. - Develop a dashboard in Excel that displays key metrics and trends in a user-friendly format. - Generate a weekly summary report that provides insights and highlights key findings. - Set up conditional formatting or alerts to flag any significant chang...

Need to cover and update the following points 1: Prevent users from copying and pasting data to the Template file from other files 2: Link the new planning template to VLOOKUP file. Need the Dropdown data validation options on this file to match the Vlookup file that we maintain separately and use for our other templates. 3: Ensure that VLOOKUP file needs to be referenced from original location instead of creating a copy to the folder. 4: Stop workbook links message when file is opened 5: Stop VLOOKUP file closing message when file is closed

I am looking for a skilled Power BI expert to create a dashboard primarily focusing on sales analytics. Key Requirements: - The dashboard should connect to Excel/CSV files. - It should track revenue by product. Ideal Skills and Experience: - Proficiency in Power BI. - Experience in sales analytics. - Ability to work with Excel/CSV data sources.

Hello. As discussed, I’ll make the dashboard for you.

I'm seeking help with matching date ranges in my data. The data is time-sensitive and needs to be handled with precision. Ideal Skills and Experience: - Proficiency in Excel, particularly with the INDEX and MATCH functions - Strong understanding of date and time data - Experience in data analysis and sorting - Attention to detail to ensure accurate matching of date ranges

I have an Excel sheet containing sales data and I need help converting this information into a parts needed list. The parts list should be organized by dates of sales. Key requirements: - Identify individual components from sales data - Organize parts list by sales dates Ideal skills: - Proficiency in Excel - Experience with data analysis - Attention to detail

...These pages display the same product catalog as the main store. Customers can place orders but not pay directly. Instead, orders are recorded and linked to the seller for later group processing. 3. Order Collection & Export (for Reseller Webshops) Orders placed via reseller webshops should be saved in a separate list. Group leaders (e.g., a coach or teacher) can export the order list as a CSV or Excel file. Once all orders are collected, the leader places a bulk order via the main webshop. 4. Seller Dashboard Sellers log in to see order summaries, total sales, and commission tracking. A referral link generator so sellers can share their shop. No financial transactions on this dashboard—only order tracking. 5. Admin Dashboard & Order Management Overview of all...

I'm in need of a professional who can assist me with a data migration task. The data is currently stored in another Excel file, and I require help specifically in removing duplicates during the migration process. Ideal Skills: - Proficiency in Microsoft Excel - Experience in data migration tasks - Ability to identify and remove duplicate entries This project is straightforward but requires attention to detail and a strong understanding of Excel.

I need an Excel whizz to help me manage and analyze my inventory data. The primary focus will be on organizing data and setting up formulas to track stock levels efficiently. Key Tasks: - Organizing my inventory data - Setting up formulas for tracking stock levels - Creating visualizations like charts and graphs for easier data interpretation - Providing step-by-step instructions and useful tips I am looking for someone who can also guide me on using advanced Excel functions such as VLOOKUP, pivot tables, conditional formatting, and data validation to streamline this process. Ideally, you will provide me with templates that can save time and enhance productivity in handling large datasets. The ultimate goal is to improve accuracy and generate insightful reports. Skills a...

I'm in need of a standard, detailed Chart of Accounts specifically tailored for the service industry. Key Aspects: - Development of a standard Chart of Accounts - Focus on the service industry - Detailed level of account categorization Ideal Skills and Experience: - Understanding of service industry financials ...Aspects: - Development of a standard Chart of Accounts - Focus on the service industry - Detailed level of account categorization Ideal Skills and Experience: - Understanding of service industry financials - Experience in creating detailed Charts of Accounts - Knowledge of standard Chart of Accounts - Strong accounting and financial planning skills. The Chart of Accounts should be delivered in Excel format. Please include specific industry examples or templates...

I am a person who specializes in studying the world of diseases. There is an Excel file about the disease covid19. I want to analyze the data in the file and display it in a clear way through which I can understand the data so that I can use it in my research on covid 19 This project involves statistical analysis. Please apply descriptive statistics to the data. Please include charts to clearly visualize the data. Please include bar charts to clearly visualize the data. Please focus on knowing where the disease is spreading. Please include bar charts to clearly visualize the data. Focus on analyzing the geographical distribution of covid19 cases. The analysis should cover data from the date on which the data was collected..

I'm in need of a professional who can create a comprehensive Excel sheet for billing and invoices. It should include an expense tracking component as well. Key Requirements: - Design an Excel sheet specifically for billing and invoices - Include an expense tracking component in the sheet Expense Tracking: - The sheet should allow me to categorize expenses - It should track the amount spent on each expense - The sheet should include a column for the date of each expense. - A column for a brief description of each expense should be included. - There should be an option to attach or link expense receipts. Ideal Skills and Experience: - Extensive experience with Excel - Previous work with designing billing and invoicing Excel sheets - Capability to integrat...

Objective Develop a macro for Microsoft Word and Excel that captures comments from a Word document and exports them into a structured Excel spreadsheet. Requirements - The macro should extract the following details from each comment: - Author (name and email) - Date and time of the comment - Comment resolution status - Line number associated with the highlighted main text - Main text that the comment is based on - Section header, if the main text falls within a chapter or section of the document - Page number for the highlighted main text - Subsequent comments or replies, structured in additional columns rather than additional rows Excel Output Requirements - Each comment should be recorded as a single row in the spreadsheet. - Responses to comments should appear in...

I need an AI file of a menu updated. The task involves: - Editing specific wording changes that I have ready - Updating prices - Removing pictures from the menu Ideal skills for this project include proficiency in Adobe Illustrator and experience with menu design.

I'm in need of a freelancer who can provide me with daily updates on divorce listings in the Toronto area, delivered in an Excel spreadsheet. Requirements: - The Excel spreadsheet should contain the names of the individuals involved in the divorce and their contact numbers. - The data should be organized, accurate, and up-to-date with daily listings. Ideal Skills: - Proficient in data collection and Excel. - Able to ensure data privacy and handle sensitive information with discretion. - Familiarity with sourcing public information, particularly legal databases, is a plus. Data should be sourced from public records. Please include the property addresses in the listings. Include full addresses with street, city, and postal codes for each property.

I need assistance in entering text data from PDF files into an Excel spreadsheet. Ideal skills for this job: - Proficient in Excel - Excellent attention to detail - Speedy and accurate data entry - Able to follow instructions precisely - Ability to validate and verify data

...mobile application to provide a seamless shopping experience for smartphone users. 12. Payment Integration: Integrate multiple payment gateways to offer flexibility in payment options for customers. 13. Customer Support: Live chat and support ticket system to help customers with their queries instantly. 14. Bulk Uploads: Feature for parts providers to upload large inventories in bulk using CSV or Excel files. 15. SEO Optimization: Ensure all parts listings and sections are optimized for search engines to drive more traffic. The portal will need to handle an inventory of over 100k items and SKUs. A crucial requirement is to have a system where the inventory updates automatically. Ideal Skills & Experience: - Proficient in web development and e-commerce platform creation - E...

...document repositories, and media platforms. Implement Natural Language Processing (NLP) for document comprehension and YouTube transcription. Provide an API interface for querying and accessing the processed data. Support integration with various Large Language Models (LLMs), allowing flexibility in model selection. 3. Data Sources & Integration 3.1 Supported Data Sources Documents: PDF, Word, Excel, Google Docs Cloud Storage: Dropbox, Amazon S3, Google Drive URLs: Web pages, APIs, public datasets YouTube Videos: Speech-to-text transcription & metadata extraction Projects & Repositories: GitHub, Jira, Trello Databases: SQL, NoSQL (MongoDB, Firebase) 3.2 Data Collection Methods APIs: Dropbox API, AWS S3 SDK, YouTube API, Web Scraping OAuth Authentication:...

...involve using Excel Solver to tackle various complex problems related to inventory management and demand forecasting. Key Objectives: - Apply linear programming and integer linear programming models to optimize and simulate supply chain scenarios. - The primary goals are to minimize costs, maximize efficiency, and optimize resource allocation. Constraints: - The model must account for various budget, capacity, and time constraints. Ideal Skills: - Proficiency in Excel Solver and mathematical modelling. - Strong understanding of supply chain management, particularly in inventory management and demand forecasting. - Expertise in linear programming and integer linear programming. - Ability to work within specified constraints. Experience: - Proven track record of using ...

I need an Excel signing sheet created from a single PDF. The Excel sheet should include names and signatures autopopulated from another sheet, as well as the date and time. Please use standard rows and columns for formatting refer to pdf

I'm looking for a proficient Excel developer with a strong background in trading systems to build an Excel-based trading system interfacing with Upstox. Key Requirements: - The system should support Day trading and Scalping strategies. - The system must include features for Automated trading, Data analysis and visualization, as well as Trade logging and reports. - The system should fetch market data via API integration with Upstox. Ideal Skills & Experience: - Advanced proficiency in Excel, including VBA for automation. - Proven experience in developing trading systems. - Familiarity with Upstox and its API. - Strong understanding of Day trading and Scalping strategies. - Excellent data analysis and visualization skills. Please, include examples of similar...

This project is ideal for someone with experience in creating budget spreadsheets, preferably for couples or families. Excel or Google Sheets expert is a must. It would be beneficial if you can incorporate features that enable easy tracking and analysis of our financial habits. Include charts to visualize the data. Include a feature to track and visualize progress towards savings goals. example:

This project is ideal for someone with experience in creating budget spreadsheets, preferably for couples or families. Excel or Google Sheets expert is a must. It would be beneficial if you can incorporate features that enable easy tracking and analysis of our financial habits. Include charts to visualize the data. Include a feature to track and visualize progress towards savings goals. example:

I need a tool that will help me create offers based on an Excel price list. The tool should allow for multiple product selection and have the ability to generate a PDF of the final offer. Key Features: - Multiple Product Selection: The tool should allow me to select multiple products from the price list when creating an offer. - PDF Generation: The final output of the offer should be a neatly formatted PDF. Skills and Experience Required: - Proficiency in Excel and PDF generation - Prior experience in creating similar tools or applications - Understanding of e-commerce product selection and offer creation process is a plus. The PDF output should have a custom layout with specific design elements. The PDF should include offer terms and conditions. The PDF layout should inc...

I need a family budget spreadsheet tailored for a couple. Its primary function is to track income and expenses. The spreadsheet should be able to monitor various types of expenses including monthly bills, daily spending, and unexpected expenses. This project is ideal for someone with experience in creating budget spreadsheets, preferably for couples or families. Excel or Google Sheets expert is a must. It would be beneficial if you can incorporate features that enable easy tracking and analysis of our financial habits. Include charts to visualize the data. Include a feature to track and visualize progress towards savings goals. example:

I'm seeking a seasoned professional to help automate processes related to our 'pinkfish' website project. Key focus areas include: - Data entry: Streamlining input processes to save time and reduce errors. - Email responses: Automating customer interactions to ensure consistent and timely replies. - File management: Ensuring all files are organized and accessible, with minimal manual intervention. The ideal candidate will have experience with Excel/Google Sheets, as well as CRM systems and project management software. Skills in web development and knowledge of e-commerce platforms will be highly beneficial.

I'm looking for a freelancer who can independently manage and accurately transfer information from various sources into an Excel spreadsheet. The specific sources will include paper documents, spreadsheets, and online forms. The ideal candidate should have experience with data entry, attention to detail, and proficiency in Excel. Key Skills Required: - Data entry - Excel proficiency - Attention to detail

The task involves manually drawing and recording polygons for specific rivers and canals. Each polygon must precisely represent the full course a...water surface of each river or canal. • The focus is on 25-30 rivers and canals, (global Importance). • The polygons should be manually drawn using GIS software and then exported as WKT strings. • Ensure the data is topologically correct and corresponds precisely to the actual river boundaries. • The final output should be an Excel file with two columns: • “Name”: The name of the river or canal • “WKT”: The corresponding WKT polygon Deliverables: 1. Excel file () with two columns: • Name (river/canal name) • WKT (polygon geometry in WKT forma...

...devices and screen sizes. - Implement a comprehensive user role and permissions management system. - Integrate third-party APIs for extended functionalities such as shipment tracking. - Implement advanced security measures to protect against vulnerabilities. - UpDATE custom reporting features for detailed insights and analytics. - Update the ability to import/export/update product data via Excel, etc. A detailed task list with over 30 points to fix is available on Trello, and the project is hosted on GitHub. The estimated time to complete this task is about 4-5 weeks. Ideal Skills: - Proficient in PHP and Laravel - Experience with POS and Inventory systems - Familiarity with GitHub and Trello - Knowledge in implementing multi-language support and currency upd...

I'm seeking an Excel professional who can assist with modifying a file and selecting specific data. The task involves saving images in bulk from local files and requires some specific data formatting. Key Requirements: - Data Modifications: Save images in bulk from local files. - Data Formatting: Primarily involves cell merging and alignment. Ideal Skills: - Proficiency in Excel - Experience in data cleaning and formatting - Familiarity with bulk image saving techniques - Attention to detail

I need a professional who can convert a photo into a CNC router machine file. The project involves working on a large wooden piece. Key Details: - CNC Machine Type: The conversion is specifically for a Router machine. - Material: The project will be working with wood. - Size: The final product is large, meaning it will be over 24 inches. Ideal freelancer should have: - Proven experience in creating CNC machine files. - Expertise in working with Router machines. - Previous experience working with wood. - Ability to scale designs for large products. Please only bid if you can demonstrate relevant skills and experience.