Vba excel manual calculation sheet jobs

I need a comprehensive Google Sheet created for my PP Bags Manufacturing Unit. This sheet should handle: - Inventory Management: Track raw materials and finished goods. - Production Tracking: Monitor daily production and bottlenecks. - Sales Data: Record and analyze sales trends. The Google Sheet will be used by various teams including Managers, Production Staff, and the Sales Team. In terms of data analysis and reporting, the sheet should provide: - Daily performance reports: Evaluate production and sales on a day-to-day basis. - Monthly summary reports: Provide a comprehensive overview of the month’s performance. - Real-time data analysis: Allow for immediate evaluation of current data. Ideal skills for this job include advanced Google Sheets profi...

I need a query function that handles total event duration data. The function should be able to process numerical data representing event durations. The example sheet contains the data and i want a sum(v) in the query function in the cell A8 error message : Impossible d'analyser la chaîne de requête pour Le paramètre 2 de la fonction QUERY : AVG_SUM_ONLY_NUMERIC

I'm in need of a proficient Excel expert who can develop a macros solution for me. This will primarily be used for automating data formatting and report generation tasks in Excel. Key Requirements: - Expertise in Excel macros - Ability to automate data formatting tasks - Experience in creating macros for report generation - Proficient in handling Excel files The ideal freelancer for this project should have a deep understanding of Excel and experience in creating and implementing macros. The goal is to streamline my workflow and make data handling more efficient.

I'm looking for a professional with advanced Excel or macros experience and a deep understanding of Shopify, to automate the upload of various data into custom metafields on my Shopify products. The data to be uploaded includes: - Text descriptions - Numeric values This is a project requiring the successful freelancer to upload the data to the custom metafields only once. There's no need for this automation to integrate with any other systems or third-party applications; the task is solely focused on Shopify and our excel. Ideal Skills and Experience: - Extensive experience with Shopify - Advanced level Excel skills - Proficient in macros - Experience in data management and automation - Data Entry

...Dubai World Trade Center, specifically focusing on the Food and Beverage sector. Gulfood 2025 Dubai International Boat Show 2025 worldofcoffeedubai 2025 go on abaove website click EXHIBITOR LIST Key Deliverables: - An Excel spreadsheet containing the following fields: - Company names - Contact persons - Company addresses - Email and WhatsApp numbers of owners - Locations - Sector - Manual verification of the authenticity of the collected data. Ideal Skills and Experience: - Proficiency in Excel - Experience in lead generation - Strong attention to detail for manual verification tasks. To get awarded for this project, you need to extract at least 100 emails from a single website mentioned in the examples. Please note, I am interested in lea...

...looking for a skilled software developer with experience in creating HRMS software. The software should focus on three key areas: Employee Management, Payroll Management, and Attendance Tracking. Core Functions: - Employee Management: The software should include features for tracking employee information, job roles, performance, etc. - Payroll Management: This should cover all aspects of salary calculation, tax deductions, bonuses, etc. - Attendance Tracking: The system needs to have a reliable attendance tracking feature. The software should be developed as a Web-based platform. Ideal candidates for this project should have: - Proven experience in HRMS software development - Strong skills in web-based software development - Understanding of key HR processes and needs - Abil...

I have over 10 Excel files containing customer contact details that need to be consolidated into a PostgreSQL database. The good news is that all these files have a consistent format, which should make the task easier. Key Requirements: - Expertise in PostgreSQL - Proficient in Excel - Experience with data consolidation - removing duplications Please ensure to deliver a clean, organized database that accurately reflects the data from the Excel files.

...by whom, to help with efficiency and accountability. - User-friendly interface: Given that our primary users will be warehouse staff, the Tool Manager should be straightforward and easy to navigate. - Notification to the manager and to the dashboard on the display - Clean and simple process of checking in/out of tools by the user. - Easy options for camera choice among USB/embedded/IP camera or manual entry of data - User interface and administrator interface Ideal Skills & Experience: - Proficiency in UI/UX design, particularly for simple, intuitive interfaces. - Strong backend development skills, with experience in creating inventory and usage tracking systems. - Previous work with tool management systems, especially for heavy machinery, would be a significant advantage. ...

...of Work: You will receive a names of few companies + 1 link containing lists of other companies. For each company, gather the following information (where available): Company Name Key People (CEO, Founder, Marketing Head, Sales Head, or equivalent) Job Titles Contact Details (email addresses, phone numbers) LinkedIn Profile URLs (if available) Organize the data into a structured Google Sheet or Excel file. Requirements: - Experience in data scraping, web research, or lead generation. - Attention to detail and accuracy in collecting and entering data. - Ability to use professional tools like LinkedIn, email finders, or other research methods to locate information. - Familiarity with verifying email addresses to ensure they are active and bounce-free....

I'm looking for a professional with advanced Excel or macros experience and a deep understanding of Shopify, to automate the upload of various data into custom metafields on my Shopify products. The data to be uploaded includes: - Text descriptions - Numeric values This is a project requiring the successful freelancer to upload the data to the custom metafields only once. There's no need for this automation to integrate with any other systems or third-party applications; the task is solely focused on Shopify and our excel. Ideal Skills and Experience: - Extensive experience with Shopify - Advanced level Excel skills - Proficient in macros - Experience in data management and automation - Data Entry

I'm looking for someone to create several spreadsheets that display various financial metrics related to shipments of multiple grades across different countries. The sheets should track specific details for each shipment and highlight key insights. Ideal Skills: - Proficient in Excel or equivalent spreadsheet software - Strong understanding of financial data - Ability to visualize data clearly and concisely Specific Requirements: - Track shipment dates - Monitor product grades - Keep a record of destination countries - Provide an overview of which grade has moved the maximum - Include quantities and other relevant data - Need charts and graphs to represent the data as well - Pivot tables and more. These spreadsheets will be instrumental in helping me understand the financia...

I'm seeking a skilled Android app developer to create a product showcase app. The app should allow for the following features: - Listings of products complete with photos and specifications. - Product listing Dealer wise and overall - Inquiry buttons on each listed product, facilitating user interaction. - Upload options for products, inclusive of picking and specifying details...additional options. The ideal candidate for this project should have: - Proven experience in Android app development, particularly with product showcase apps. - A solid understanding of e-commerce and inventory management principles. - Skills in creating user-friendly interfaces with interactive features. Please note, the app should support product uploads primarily through file import, rather than ma...

We are using SS304 GN Pan 2/1 ( 50 L) to ferment beverages. We made a hole in the bottom of the tank and used tank fittings connected to a valve and tri clamp hose connector to pump out the liquid. problem is tank sheet thickness is only 0.8mm and the fittings need to be supported through an additional support to give it strength.

I am seeking an Excel expert with extensive experience in spreadsheet automation. The ideal candidate will help me automate the following tasks: - Data entry - Generating reports - Data cleaning The Excel spreadsheet will need to interact with a database. Therefore, experience with database interactions in Excel is crucial. Skills and experience needed: - Advanced Excel knowledge - Expertise in spreadsheet automation - Proficiency in data manipulation and cleaning - Experience with generating reports in Excel - Familiarity with database interactions in Excel Please provide examples of similar projects you've completed in your bid. Thank you.

I need an experienced sports analyst to review basketball game footage, focusing on one specific team. Your tasks will include: - Creating a Google Sheets stats sheet with intermediate stats (points, assists, rebounds, turnovers, steals, blocks). - Analyzing the game footage and cutting the tape to breakdown offensive plays, defensive plays and transition plays. Please ensure the stats sheet is comprehensive and easy to understand. Prior experience in sports analysis, particularly basketball, is highly desirable, as is proficiency with Google Sheets.

I have the script but it seems to have some bugs. I need you to fix it in 2-3 hours (first phase which I will explain , there is matching for which you can take some time). If you are experienced then only propose. I have a subscription to a website. I will provide set of data in excel (I need a python script, so that I can use whenever I have new data) and need few data to be extracted from that website based on several conditions and need all the required fields to be filled in excel. And need output in excel file. I need anyone who can complete real quick. Budget 8 usd

I am in need of a comprehensive Excel dashboard for the IPL seasons spanning from 2008 to 2024. The dashboard should effectively track and display: - Player performance - Match results - Team standings The dashboard should primarily feature: - Graphs/Charts - Tables These visual elements will assist in presenting the data in an engaging and easily digestible format. The data should be updated on a monthly basis. Ideal candidates for this project should have: - Advanced Excel skills, particularly in creating dashboards - A strong understanding of cricket, specifically the IPL - Experience in data visualization - Ability to manage and update data on a regular basis

I'm looking for an Excel expert who can help me create basic arithmetic formulas to assist with financial calculations. Ideal Skills: - Proficiency in Excel - Experience with financial calculations using Excel - Ability to create basic arithmetic formulas

Note: Bid amount more than set budget will be ignored, Else don't bid and not to ask to increase thebudget. Read the project details first then bid. I have existing android app which is based on Live train status app. In the app some of api is not showing the results and data due to expired api. I need to replace the api with new rapid api to show the results in same way. ...app. In the app some of api is not showing the results and data due to expired api. I need to replace the api with new rapid api to show the results in same way. The app is developed in java. I will provide the api from rapid api. 4 api need to replace/change only which are related to: Train schedule PNR Trains Between stations Seat availability And Autocomplete text field needs to be edit with manual en...

I have a project that requires meticulous input of numerical data into Excel. The task will involve not only data entry but also ensuring that the data is validated and formatted according to specific guidelines. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience in data entry and validation Key Requirements: - Input of numerical data - Use of Excel for data input - Ensuring data validation - Following specific formatting guidelines in Excel

I'm in need of a full stack web developer to create a stock inventory report generator. This tool is intended for manual data entry then auto calculate price and item quantity, so it needs to be user-friendly and intuitive. Key Requirements: - The tool should be able to generate both summary and detailed reports. - Experience in creating web tools with a focus on data manipulation and report generation is a plus. - The ideal candidate should have a strong understanding of full stack development and be able to deliver a robust and efficient tool. Note: only experienced developer, they already work on report generator,

I'm seeking a diligent data entry expert to assist with transferring information from an online database into MS Excel. Key Requirements: - Proficient in MS Excel; familiarity with data manipulation tools within Excel is a plus. - Attention to detail to ensure accuracy of data entry. - Ability to work independently and manage time efficiently. - Prior experience with data entry from online databases preferred. Please note, the data type is mixed (both numeric and textual), so a good command over both types is essential.

I need a solution for transferring text from Word to Excel and vice versa. The templates I work with change frequently, so I require a fully automated system to handle the conversions. Ideal Skills: - Proficient in Microsoft Word and Excel - Experienced in creating automated systems - Able to handle frequent template changes Your task will be to create a system that can seamlessly manage this process, freeing up my time for other tasks.

I'm looking for an Excel expert who can help me with applying logical functions (IF, AND, OR, etc.) primarily for data validation across multiple ranges. Key tasks: - Assisting in the use of logical functions for data validation - Implementing these across multiple ranges Ideal skills and experience: - Proficient in Excel, particularly in logical functions - Experience with data validation in Excel - Able to apply skills across multiple ranges

For this job, the client requests the transcription of a song into guitar trablatures and conventional sheet music. My job will be to deliver the harmony and melody of the song in the required formats so that you can play it in the most efficient way possible.

I'm seeking assistance with my Power Automate system. Currently, I am performing data entry from a single sheet Excel file into a web platform, specifically filling in text fields. I've encountered some hurdles while trying to automate this process. Ideal skills and experience for this job include: - Proficiency in Power Automate - Experience in automating web data entry - Familiarity with Excel, particularly with single sheet data organization Your expertise could save me a lot of time and frustration. Looking forward to your bids.

I'm seeking an expert in Excel to create a comprehensive dashboard that focuses on project management. The primary use of this dashboard is to monitor resource allocation, specifically equipment, for various tasks within a project. Ideal Skills and Experience: - Proficient in advanced Excel functions and features - Experience in project management - Understanding of resource allocation and tracking - Ability to create user-friendly and visually appealing dashboards

I'm looking for a professional to improve the user interface of an Excel-based governance document. This document is used to track initiatives and actions from a strategic plan. Key Focus Areas: - Navigation and layout: The document needs to be more intuitive and user-friendly. - Form input and validation: Streamlining the process of data entry and ensuring accuracy is crucial. - Color scheme and styling: Aesthetic improvements are needed to make the document visually appealing. No specific design guidelines are in place, so creativity and adherence to general best practices will be appreciated. Ideal candidates should have a strong background in UI design, particularly in Excel, and be able to deliver a document that balances functionality with an enhanced user experi...

I'm in need of a custom Excel worksheet for tracking business card orders. The worksheet has specific requirements and needs to be completed today. Please see the details below. - The worksheet needs to be separated by name, title, address, phone, fax, cell and email address, and quantity. - The first sheet should be named 'AIM', the second 'CC', the third 'TT', and the fourth 'ACT'. - I will provide the names, but you need to format the Excel sheet according to these specifications. - The quantities for each type of business card should be recorded in separate columns. Ideal skills for this job include: - Proficiency in Excel - Attention to detail - Ability to work under tight deadlines.

Need a high skilled PHP professional to assist with a project that syncs JSON files in real-time. The project is strictly in PHP, without any frameworks. Please share an URL to your script so it can be viewed in live time. Key Responsibilities: - ChatGPT codes will not be accepted! - No endpoints leaked on HTML DOM - .jso...share an URL to your script so it can be viewed in live time. Key Responsibilities: - ChatGPT codes will not be accepted! - No endpoints leaked on HTML DOM - .json file will hold data such as logs, statistics or other data that changes in real-time - Content automatically updates when the .json data changes, not on a set interval. - web server access logs only log entries such as URL accesses or manual site refreshes (F5), but not when the content automaticall...

I'm seeking a professional to scrape my WordPress website for 1100 entries related to our different offices. The data needs to be exported into an Excel file, without any specific filters or sorting. In addition to data scraping, I need a thorough code review of my WordPress site. This should encompass: - Documentation and review of custom code - Optimization where necessary - Plugin review for updates - Recommendations for optimization This project requires a deep understanding of PHP, as well as experience with WordPress and data scraping. The ideal freelancer will have a strong background in website code review and optimization.

I am seeking to hire an excellent Compliance and Administrative member to join my team. Skills Required: * Confident on the phone * Speaks & communicates clearly by phone * Excellent written communication skills * Proficient in Microsoft Excel, Word and Power Point * Can multi-task and complete projects on time * Must be able to learn on the go and figure out solutions to problems * Is an excellent self-learner * Finish projects in a timely manner, doesn't procrastinate * Proficient with Adobe Acrobat in creating forms and documents * Proficient with DocuSign. Understand how to send out documents for signature * Excellent with follow-up. If you promise something to a client or team member follow-through * Understand how to use DropBox and grant/deny access to users * Excel...

I am in need of a freelancer who can assist me in extracting data f...extract insights. Further specifics will be provided upon acceptance of the job. Key Requirements: - Proficiency in Google Forms and Google Sheets. - Experience with data cleaning, organization, and analysis. - Attention to detail and ability to deliver accurate results. - Familiarity with creating charts or summary dashboards in Google Sheets is a plus. Deliverables: - A clean, organized Google Sheet with extracted survey data. - Basic analysis and simple visualizations based on the data. Ideal Skills and Experience: - Previous experience with similar projects. - Strong analytical skills. - Ability to meet deadlines. Please note that the expected completion date is Thursday, January 30th, with a budget of $30...

We would like you to find emails of everyone in this sheet (2 tabs on bottom)

I'm seeking a proficient developer with extensive experience in creating MEV contracts on the Solana and Eth blockchain. The primary objective of this contract is to maximize profits from trades through a sophisticated sandwich attack algorithm. This project entails: - Crafting a hybrid execution strategy: The MEV contract should allow for both automatic and manual execution, with the latter requiring prior approval. This will necessitate an intuitive and user-friendly interface for monitoring and intervening in trade executions. - Implementing an advanced sandwich attack algorithm: The algorithm's complexity should be at an advanced level, capable of outsmarting competitors and capitalizing on profitable trading opportunities. Ideal candidates for this project should h...

I'm in need of a professional and detail-oriented writer who can compose structured daily reports for our company. The ideal candidate should have: - Experience in business writing - Excellent attention to detail - The ability to present information clearly and professionally Please note that the specifics of the reports, their primary purpose, and...professionally Please note that the specifics of the reports, their primary purpose, and the preferred format have not yet been determined. Therefore, flexibility and adaptability are key. Skills and experience that would be beneficial for this job include: - Prior experience in corporate communication or report writing - Strong understanding of business terminology - Proficiency in Microsoft Word and Excel - Ability to meet ...

...the best tools and technologies for the project. Responsibilities: Design and develop a fully functional e-commerce website with key features, including: Product listings, categories, and advanced search. Shopping cart and secure checkout process. User authentication and profile management. Payment gateway integration (e.g., Stripe, PayPal). Inventory and order management. Shipping and tax calculation. Optimize the platform for mobile responsiveness, SEO, and performance. Ensure secure handling of user data and transactions. Provide ongoing support for updates, fixes, and potential new features. Requirements: Proven experience developing e-commerce websites. Proficiency in CMS platforms like WordPress/WooCommerce, Shopify, Magento, or custom development using frameworks like Lar...

...- Automatic suggestions for potential savings. - Notifications for improved conditions found. 3.4 Communication - Integrated chat functionality for direct communication between customers and service providers. - Notifications (push, email) for new messages, bids, or updates. 3.5 Verification Process - Service providers must upload relevant documents (e.g., business licenses). - Automatic or manual verification. 3.6 Payment System - Integration of secure payment providers (e.g., Stripe, PayPal). - Escrow system: Payments are released upon completion of tasks. - Invoice generation for both customers and service providers. 3.7 Review System - Customers and service providers can review each other. - Average ratings are displayed in profiles. - Text-based reviews for detailed fe...

...materials shared. If you are interested and meet the requirements, please include examples of your previous work or references with your proposal. TITANS: 1- Technical Manual - ENG - FR 2- Training Dossier - ENG - FR 3- Training: 28 videos - ENG - FR 4- Consumer Catalog - ENG - FR 5- Offline Marketing - ENG - FR FHOS: 1- Training Videos: 21 videos - ENG - FR 2- WhatsApp Ads Videos: 3 videos - ENG - FR ATHOR: 1- Technical Manual - ENG - FR 2- Training Dossier - ENG - FR 3- Offline Marketing - ENG - FR NEXUS: 1- Technical Manual - ENG - FR 2- Training Dossier - ENG - FR 3- Offline Marketing - ENG - FR RADIO: 1- Technical Manual - ENG - FR 2- Training Dossier - ENG - FR 3- Offline Marketing - ENG - FR The language is specific to the professional beauty in...

I've got a Net Cost Calculator in Excel that needs to be embedded into my WordPress site, built with Elementor. This calculator is quite straightforward; it primarily employs simple arithmetic. Key Requirements: - The calculator will require users to manually input data. - It needs to be styled to match the theme of the rest of the site, rather than a simple and clean look or a completely custom design. - The calculations performed by the calculator are all simple arithmetic, not complex formulas or financial projections. Ideal Skills and Experience: - Proficiency in WordPress, particularly with Elementor. - Strong understanding of Excel, especially in terms of transferring content to a different platform. - Good eye for design to ensure the calculator matches the sit...

I have a mathematical formula: (weight*height)/velocity squared and I want to highlight in Numbers the cell of the parameter that has the biggest impact on the calculation. - Version: I'm using the latest version of Numbers. - Requirement: I need all cells that have the same impact on the formula to be highlighted. - Format: The cells should be highlighted with a change in background color. Ideal skills for this job include expertise in Numbers, data analysis, and understanding of mathematical formulas. Experience with conditional formatting in Numbers would be a plus. Please let me know if you have the necessary skills to complete this task.

We are looking for an experienced developer to create a web-based Financial Requisitions Management System. The system will manage various requisitions (e.g., services, transportation, raw materials) with role-based access for users, appro...English, translation-ready). Functional Requirements: Role-based access: Users: Create, view, and edit their requisitions. Approvers: Approve/reject requisitions with feedback. Admins: Configure workflows and override locked fields. Configurable approval workflows (e.g., CEO approval mandatory). Integration with existing SQL Server data for financial records via the backend. Additional Info: Sample Excel structure and queries will be provided. Responsive design required for both desktop and mobile. Post-deployment support expected for minor ad...

I'm seeking an Excel expert who can compile and analyze the income statement for Woolworths Group Limited over the past three years. The report should include sales, expenses, and profit, as well as charts to visualize the data. Ideal Skills: - Proficient in Excel - Financial analysis experience - Data visualization skills Please note, while I've left the specific expense categories open-ended, the comprehensive nature of your analysis will be appreciated. Your ability to deliver a clear, insightful report is key. Deadline in 28 hours

I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!

I'm seeking an Excel expert to help me compose a mailing list. The ideal freelancer should have experience with data handling and Excel's various functions. Key requirements: - Create a comprehensive mailing list in Excel, including names and addresses. - Potentially assist with data analysis and visualization using Excel's tools. - Prior experience with similar tasks will be highly beneficial.

I'm seeking a Microsoft Excel professional to create a comprehensive spreadsheet for my retail and service-based business. The goal is to meticulously track all expenses and personal payments. Key Components of the Spreadsheet: - Record and categorize various expenses: Office supplies, Travel expenses, Utilities, Gas, Rent, Professional Development, Flights, Hotels, Credit Card fees, Business registration fees. - Monitor different income sources: Product sales, Service fees, Consulting fees. Ideal Skills: - Proficient in Microsoft Excel - Experience in creating business tracking spreadsheets - Understanding of retail and service-based business expenses - Ability to categorize and track diverse income sources. Your expertise will help me maintain a clear overview of ...

Description: We are launching an exclusive premium coaching service designed to help candidates excel in the CFA (Chartered Financial Analyst) exams. Recognized as some of the most challenging professional exams in the world, CFA preparation requires tailored support and strategies that go beyond the traditional offerings. To ensure our service delivers maximum value, we’re seeking CFA candidates and charterholders to provide critical feedback and suggestions before our April 2025 launch. Your insights will play a pivotal role in shaping this transformative service for future candidates. Project Objectives: > Review: Participate in an online video call to review our planned offering. > Feedback: Provide constructive insights on all aspects of the service, identi...

...Open Portal, all within an easy-to-use Excel interface. Responsibilities: Download Listings: Create a system that can pull real estate listings data from sources such as Zillow, Redfin, StreetEasy, and other relevant platforms. Enable users to paste or upload property listing data into an Excel sheet for further processing. Data Extraction: Automate the extraction of zoning data for each property from Zola NYC and NYC Open Portal, including specific zoning codes and regulations. Extract the building structure type, size, number of stories, and the size of the lot for each property. Determine if the property is located on a wide street. Excel Integration: Ensure that all extracted data is neatly organized and formatted for easy access within Excel....

I'm seeking an experienced mobile app developer to create a dedicated Android application. The app will facilitate message exchanges from a laptop to specified mobile users, with the potential for up to 10 users. Key Features: - Manual Message Dispatch: The app will require an interface on the laptop from which messages can be manually typed or pasted and sent to the mobile app users. - Call Functionality: If a mobile user receives a message containing a phone number, they should be able to initiate a call directly from the app. - Location Tracking: The app should have a feature that allows the users' locations to be tracked from the laptop. Ideal Skills: - Proficiency in Android app development - Experience in creating interactive interfaces for message dispatch - Knowl...

I'm looking to have my existing PineScript strategy translated into NinjaTrader. The strategy is primarily for grey box automation with manual order acceptance. Key Requirements: - The strategy should integrate with custom indicators that I will provide. - You will set the ATM in NinjaTrader desktop, - The strategy should include defined trade entry and exit conditions. Ideal Skills: - Proficient in NinjaTrader and PineScript - Experience in developing automated trading strategies - Understanding of integrating custom indicators - Knowledge of setting trade entry and exit conditions.