Vba excel manual calculation sheet jobs

I need my Excel data modified for better visual appeal and branded to match my website. Requirements: - Apply custom themes and colors to the Excel file. - Incorporate my website's color scheme and font style. - Add my contact number to the header of the Excel file. There's no need to change any of the data, as everything has already been filled.

I have an Excel sheet with text data in various columns that needs to be sorted according to a specific sequence. The task involves: - Identifying the text data in the columns - Sorting this data following a predetermined custom sequence Ideal candidates for this project should have: - Proficient Excel skills - Experience in sorting data according to custom criteria - Attention to detail to ensure all data is sorted accurately according to the specific sequence

I’m seeking freelancers for a simple lead generation task. Here are the details: • Work: Find the founder’s name, company’s name, and contact number from their LinkedIn pages and organize the information into a sheet. • Requirements: • Must have a LinkedIn Premium account. • Preferably Indian freelancers. • No prior qualifications or experience required—anyone interested is welcome to apply. If you’re interested, please DM me for more details.

I need someone to create a excel spread sheet to show and auto populate the following cost and expenses Labor Costs: Track employee hours worked in each service category using timesheets or a time tracking system. Record the hourly wage for each employee. Calculate daily labor cost: (Number of employees) x (Hourly wage) x (Hours worked). Supply Costs: Maintain a daily log of all supplies used in each service category. Record the quantity and unit cost of each supply item. Calculate daily supply cost: (Quantity used) x (Unit cost) for each item, then sum up all item costs. Vehicle Mileage: Record the starting and ending mileage for each company vehicle used daily. Calculate the total mileage driven for each vehicle. Fuel Consumption: Collect and retain all gas card receipts. R...

I need an Excel spreadsheet designed for daily expense tracking and financial calculations. The ideal freelancer for this project would be someone with strong Excel skills, particularly in creating formulas and functions for financial analysis. Key Requirements: - Create an Excel spreadsheet for daily expense tracking - Implement financial calculations within the spreadsheet - Ensure the spreadsheet is user-friendly and easy to update Skills & Experience: - Strong proficiency in Excel - Experience with financial spreadsheets - Excellent attention to detail

Will create a proper google form and sheet according to your requirements.

I'm looking for a manual data entry freelancer to fetch data from few different websites according to the specified guided steps from me. Key Responsibilities: - Follow the guided steps instruction carefully and perfectly - Make at least 15 full flow steps a week. Ideal Skills: - Strong in learning and understanding in SOP (standard operation procedure) - Excellent reporting skills - Proficiency in AI software tool like chatGPT - Ability to use canvas (or willing to learn it) Experience: - Prior experience in using AI softwares - Experience with YouTube content creation is a plus This is a great opportunity for those with a passion for finance and content creation. The job steps are very easy, it's a routine job that you need to do for long-term period. Please check o...

I'm seeking a skilled bookkeeper to assist with the preparation of my company's financial statements, specifically the balance sheet, income statement, and cash flow statement.

I'm seeking a seasoned Accounting Expert with deep expertise in revenue calculation and recognition in the cloud computing sector. The primary focus will be on handling subscription-based revenue. Key Requirements: - Extensive experience with subscription-based revenue models - Strong understanding of IFRS 15 and its application to cloud service models - Proficiency in revenue calculation, recognition, and financial reporting Skills & Experience: - Prior work in the cloud computing industry is a significant advantage - Comprehensive knowledge of financial reporting standards, particularly IFRS 15 - Proven track record of accurate revenue calculation and recognition - Experience in preparing and presenting financial reports

...include: - Stock Management: The app must effectively manage inventory on delivery trucks. - Customer Location: It should assist in pinpointing customer locations on a map. The app needs to function offline with both automatic and manual data synchronization when internet access is available. The dashboard, meant for advanced analytics, should track: - Top Customers - Best-Selling Products - Delivery Staff Performance This dashboard will have role-based access to limit sensitive information. Additionally, the app should support importing a client database from Excel. Ideal skills and experience for this job include: - Proficiency in Android app development - Experience with offline functionality and data synchronization - Knowledge of creating role-based access ...

I'm looking for someone to gather various data about food and beverage products from the internet. This includes information such as the manufacturer, marketer, country of origin, and ingredients. Key Responsibilities: - Research and collect data from official webs...various data about food and beverage products from the internet. This includes information such as the manufacturer, marketer, country of origin, and ingredients. Key Responsibilities: - Research and collect data from official websites and retailer sites. - Compile the data into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in online research. - Experienced in data collection and data entry. - Familiar with food and beverage products. - Able to compile information into a clear and organized ...

I am looking for an experienced Moodle plugin developer to create a custom plugin that allows users to view uploaded documents directly in a separate tab without providing any option to download, print, or save the document. The plugin should enable users to open documents such as PDFs, Word files, and Excel sheets seamlessly while ensuring that the document cannot be downloaded or copied in any way. Security is a top priority, and the plugin must implement robust measures to protect the documents from unauthorized access or sharing. The plugin must be compatible with the latest version of Moodle and integrate smoothly with Moodle’s existing file management system. It should have a user-friendly interface for both administrators and users, ensuring a hassle-free experience. T...

I'm looking for a manual data entry freelancer to fetch data from few different websites according to the specified guided steps from me. Key Responsibilities: - Follow the guided steps instruction carefully and perfectly - Make at least 15 full flow steps a week. Ideal Skills: - Strong in learning and understanding in SOP (standard operation procedure) - Excellent reporting skills - Proficiency in AI software tool like chatGPT - Ability to use canvas (or willing to learn it) Experience: - Prior experience in using AI softwares - Experience with YouTube content creation is a plus This is a great opportunity for those with a passion for finance and content creation. The job steps are very easy, it's a routine job that you need to do for long-term period. Please check o...

...place the transformed values into the correct boxes in the WPS Spreadsheet. 2. Macro for Creating Invoices Purpose: Automate the process of generating a printable invoice in a new tab within the WPS Spreadsheet. Filter Data: Remove any products (SKUs) that do not have a value entered next to them. Invoice Layout: Create a new tab in the WPS Spreadsheet with: The header section from the original sheet. Only the products that have values entered, along with their associated data (e.g., quantity, price). Formatting: Ensure the new tab is formatted and ready for printing....

...Creating Invoices Purpose: Automate the process of generating a printable invoice in a new tab within the WPS Spreadsheet. Filter Data: Remove any products (SKUs) that do not have a value entered next to them. Invoice Layout: Create a new tab in the WPS Spreadsheet with: The header section from the original sheet. Only the products that have values entered, along with their associated data (e.g., quantity, price). Formatting: Ensure the new tab is formatted and ready for printing. Example: A sheet containing SKUs with missing values is cleaned to only display products on order, with quantities and prices ready for invoice generation. Trigger: Create a button in the WPS Spreadsheet that, when clicked, executes the macro. Additional requirements: - Error Handling: Handle er...

I'm in need of an expert in Google Sheets to create a dynamic and real-time Sales Tracker for my team. This tracker will consist of a master sheet, individual sheets for each salesperson, and product target metrics. Key Features: - The master sheet should provide a comprehensive summary of all sales, facilitate performance comparisons among salespersons, and track sales trends over time. - Each salesperson will have their own sheet, which they will update manually with their sales data. - The tracker should include specific product target metrics, focusing primarily on revenue generated. Ideal Skills: - Proficient in creating complex Google Sheets. - Experience with sales tracking systems. - Excellent understanding of data visualization and performance compariso...

We are seeking an experienced Excel expert to assist in developing a dynamic and user-friendly Excel dashboard or summary tab for our HR team. The project will involve leveraging pivot tables and other advanced Excel functionalities to create an interactive and automated reporting tool that provides clear insights into key HR metrics. The ideal candidate will have a strong background in data visualization, formula optimization, and dashboard design to ensure efficiency, accuracy, and ease of use. Our goal is to enhance data analysis and reporting capabilities, allowing the HR team to make informed decisions effectively. Delivery flexible but ideally within 2 or 3 weeks

As you can see, this is ready and working tool. We need it to be changed design using ready theme with a custom css. Delta Calculation Tool 1. - There are two types of calculation - Corporate calculation - Student calculation 2. The parameters for the company - Number of Institutes: this number must be hidden, but if the user wants to activate it, it must be shown. - Number of branches: this number must be hidden if the user wants to activate it or the institute, it must be shown. - Number of users: This must be shown. 3. There are warnings/alerts/notes in the tool. These warnings/alerts/notes must be shown small and better way with * etc. Types of calculations in 1 need to be shown in a modern way. I don't know how to do this. We need an elegant app...

I need a self-serve solution for policy creation from CRUD operations. Currently, we manually create a CSV file and use it to run a Spinnaker pipeline for policy creation. Key Requirements: - Automate policy creation from CRUD operations. - Develop a web-based dashboard as the self-serve interface. - Use React for the dashboard framework. - Fullstack development knowledge is essential. - ...Fullstack development knowledge is essential. - Proficient in Python, Spinnaker, and Docker. Ideal candidates will have a strong background in fullstack development with proven experience in creating web-based dashboards using React. A deep understanding of Python, Spinnaker, and Docker is crucial for this project. The goal is to streamline our current process and make it more efficient and less m...

...this project, I leveraged the full potential of Microsoft Office to streamline business operations and enhance productivity. My expertise in MS Office applications, including Word, Excel, PowerPoint, and Outlook, allowed me to deliver high-quality results tailored to meet specific client needs. Key Achievements: Document Creation and Formatting: Created and formatted professional documents, reports, and proposals using Microsoft Word. Implemented advanced formatting techniques and customized templates to ensure consistency and professionalism. Data Analysis and Visualization: Developed complex spreadsheets in Excel to analyze financial data, track budgets, and visualize trends. Utilized formulas, pivot tables, and charts to provide actionable insights and support decisi...

Grow a private Instagram profile by attracting a specific, high-quality audience while maintaining manual control over followers. Strategy Overview: 1. Targeting the Right Audience: • Define audience demographics (age, location, interests). • Engage with relevant hashtags, communities, and profiles. 2. Profile Optimization: • Craft a compelling bio and use a professional profile picture. • Ensure high-quality visible content that appeals to the target audience. 3. Content and Engagement: • Develop engaging posts/stories with clear calls-to-action. • Interact with potential followers through likes, comments, and DMs. 4. Follower Approval: • Screen follow requests to ensure alignment with target audience criteria. 5. Performance Analysis...

If you you bid to consider, please send me in message .. a sample infographic/chart based on the excel file I am attaching here: _____________________ I'm in need of a freelancer skilled in database analysis and Microsoft Excel. The project involves analyzing demographic data from an Excel spreadsheet. Key Responsibilities: - Conduct descriptive analysis on provided demographic data. - Create charts and infographics to illustrate findings. Freelancer Requirements: - Proficiency in Microsoft Excel. - Experience in data analysis, particularly with demographic data. - Ability to create visual representations of data (charts, infographics).

I need a professional to conduct regression analysis, ANOVA tests, and write a brief report on their findings. Key Requirements: - Perform regression analysis (exact type to be determined) and ANOVA tests - Write a concise report detailing the findings - Deliver the report in an Excel file Ideal Skills: - Proficiency in statistical analysis and software - Experience in writing analytical reports - Strong understanding of ANOVA and regression techniques

I'm looking for an experienced graphic designer who can also help me analyze financial data to identify trends. Key Responsibilities: - Utilize Photoshop and CorelDRAW to create engaging graphic designs - Use MS Excel to analyze financial data - Present findings in an appealing way using MS Powerpoint Ideal Skills: - Proficiency in Graphic Design software (Photoshop, CorelDRAW) - Advanced skills in MS Excel and PowerPoint - Experience in analyzing financial data - Strong ability to identify trends from data - Excellent graphic design skills Your main task will be to help me visualize the data trends through compelling graphic design and presentations.

I'm looking for a task management system specifically designed for real estate agents. This system should facilitate the management of tasks related to property closings. Key Features: - Automated reminders to...- Knowledge of real estate processes - Proficiency in Web and iOS app development Please only bid if you can deliver a system that meets these requirements. I want to keep track of real estate closings. There are approx. 6-7 tasks that are accomplished one by one in about a 60 day time frame. I have 10 to 20 closings happening at any given time. I want to see the big picture in a spread sheet that is graphically pleasing and nimble. I want it to expand to see more detail on certain tasks - then collapse to keep seeing big picture. I want colors used so it...

...Scoring Loan Approval Workflow Integration with Credit Bureaus (e.g., CIBIL, Experian) Risk and Fraud Management Key Features: User-friendly interface for applicants and internal staff. Automated underwriting rules for HL and LAP. Configurable workflow for different loan products. Real-time status tracking for applicants. Loan Management System (LMS) Modules to Include: Loan Disbursement EMI Calculation and Schedule Generation Payment and Repayment Management Delinquency and Collection Management Customer Relationship Management (CRM) Reporting and Analytics Key Features: Automated EMI reminders and notifications. Flexible repayment options (prepayments, part payments). Integration with third-party payment gateways. Dashboards for portfolio performance monitoring. Legal and c...

Need this recreated and add deals you can find for 2024 (leave the metrics to me) Need the PPT, and set up additional rows for 2024. So this turns into two pages probably. Then also need an excel backup thanks of the same data.

I'm seeking a researcher for writing a paper on "Role of ESG Criteria in inf..."Role of ESG Criteria in influencing Financial Decision-making". The paper already has introduction written and sources collected. The final wordcount should be more than 10,000 words. Key Requirements: - Mixed-methods research approach, with a focus on academic journals. - Emphasis on all aspects of ESG criteria: environmental impact, social responsibility, and governance. - Data collection and Excel calculations as necessary. Prefer someone with a background in economics or finance. The project is low-stress with a requirement of around 1500 words per week. note, strict adherence to NO AI use mandatory. Minimal use of AI for guidance is acceptable, but no AI-generated content sho...

I need assistance in recovering a deleted Excel spreadsheet file from my external hard drive. Ideal skills for this job: - Expertise in data recovery - Familiarity with external hard drive recovery processes - Proficiency with Excel and understanding of spreadsheet structures - Ability to work with urgency and confidentiality The project is time-sensitive as I need the file for an ongoing task. Please only apply if you have proven experience in file recovery.

...off on project plan and deliverables. Phase 2: Data Integration & Greeks Computation (Weeks 2–4) Goals: Gather all raw data (OHLCV, Level 2), integrate into a consistent format, compute and validate Greeks. Tasks: Set up data ingestion pipeline for GDFL data. Download and process Level 2 data (market depth). Create a unified database or folder structure (e.g., Parquet files). Implement Greeks calculation scripts. Perform spot checks to ensure accuracy of Greeks vs. market references. Phase 3: Feature Engineering & EDA (Weeks 5–7) Goals: Generate additional features (technical indicators, order book–derived metrics, Greek transformations) and conduct exploratory data analysis (EDA). Tasks: Define and implement feature transformations (e.g., MA, RSI, Bolli...

Project Title: Looking for a Ready-Made Website/Software Solution wi...Integrated monetization options such as subscriptions, ads, affiliate marketing, or e-commerce capabilities. Analytics and tracking for performance and revenue. Customization & Scalability: Easily customizable to match branding and marketing goals. Scalable for future growth and expansions. Niches of Interest: Deliverables: Complete source code or admin access to the platform. Documentation (user manual, installation instructions, etc.). Assistance with initial setup and deployment. Please share your proposals with: A demo link or screenshots of the website/software. Details about the features and functionality. Monetization methods and any proof of performance, if available. Looking forward to your ideas ...

...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont ...

I'm in need of a detail-oriented freelancer for a data entry project. The task involves manually entering data from PDF files into a database. Ideal Skills and Experience: - Proficiency in manual data entry - Experience working with PDF files - Familiarity with database systems - High attention to detail - Ability to maintain confidentiality and handle sensitive data with care.

...independent prorotype project to get the integrations and workflow set up and working correctly. Full-Stack Developer (Preferred One-Dev Solution) Responsibilities: Develop and maintain a backend pipeline to: - Scrape and preprocess data from client websites. - Chunk content into JSON packets and prepare it for tagging. - Integrate with Supabase for data storage. Build a simple web app for manual metadata tagging: - Design a clean UI for reviewing and tagging content. - Integrate pre-defined tag options for consistency. Set up a vector database for semantic search. Integrate OpenAI’s text-embedding-ada-002 and GPT models to: - Generate embeddings for tagged data. - Retrieve and pass relevant data to GPT for content generation. - Ensure scalability for multi-client sup...

I'm seeking an experienced accountant for comprehensive financial reporting. This project involves the creation of key financial documents, specifically a balance sheet, income statement, and cash flow statement. Ideal Skills: - Proficiency in SAP - Extensive experience in financial reporting - Ability to create and interpret complex financial documents Please note that the use of SAP is essential for this project, so familiarity with this software is a must. I look forward to your proposals.

...added in which operation. Necessary input data Yearly production volume Manufacturing technologies Assembly technologies Shift/Working time model Applicable methods and tools Calculation of necessary takt time Selection of suitable machines Estimation/Assumption about necessary production time per piece Assumption of a reasonable OEE Definition of Lotsizes (if necessary) Calculation of necessary machinary Assumption of assembly times and equipment Expected results Table with necessary manufacturing times per piece an the referring calcluation Table with the necessary number of machines and the referring calculation Flow chart for the assembly operations including necessary assembly times and workforce Table with the necessary workforce An exact floorplan / factor...

I'm in need of a skilled professional who can compile Data from a Website for me. Ideal Skills: - Proficiency in data collection and analysis - Familiarity with Food Delivery Platforms - Competence in using Excel proficiently The final product should be delivered as an Excel spreadsheet that I will provide. Please ensure the data is well-organised and easy to navigate. NOTE: THIS PROJECT HAS A FIX PRICE OF **INR 600**, ONLY APPLY IF YOU´RE OKAY WITH THAT. Please, start your Bid with "I Can Do It"

... This data will be used to find a historical time series from the past that had percentage fluctuations (not based on price levels) as similar as possible. Once the most similar 7-day historical series to the predicted future series is found, the date of the historical series should be displayed on the screen. The entire software must be fully "commented" and explained in every function and calculation, clarifying the practicality and utility of each element within the model and highlighting the added value it provides. The software must include a frontend to visualize the period (between two dates) that most closely resembles the one analyzed by the forecasting. It should also provide visual representation, including charts that display the forecasting period and the ...

I am in need of a professional to manage regulatory compliance in Qatar, particularly with MOPH (Ministry of Public Health). This involves handling Watheq EMS accounts and managing all aspects related to food variety, nutrition calculations, and labeling. Key Responsibilities: - Handling regulatory compliance - Setting up and configuring the Watheq EMS accou...Watheq EMS account - Ongoing monitoring and reporting of the EMS account - Closing NC reports by taking corrective actions - Providing compliance training for staff - Offering regulatory updates and advisory The ideal candidate for this project should have experience in regulatory compliance handling, particularly in Qatar. Familiarity with MOPH and Watheq EMS is crucial. Skills in nutrition calculation and labeling are also...

...experienced Freelancer QA professionals to build a long-term working relationship through a one-year contract. The ideal candidates should meet the following criteria: - Minimum of one year of relevant experience in QA/User Experience Design - Native speakers with fluency Cantonese - Ability to respond to tasks within a week - Proficiency in English for communication Responsibilities: - Perform manual testing based on provided instructions and testing plan - Identify and report bugs and issues Additional Information: - Candidates will undergo a screening process - A small testing case will be provided as part of the evaluation - Tasks will be assigned as needed throughout the contract period - Compensation will be based on an hourly rate for tasks completed If you meet these ...

I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.

I'm looking for a skilled professional who can integrate Telegram's API with Excel. The goal is to download real-time data regarding Bitcoin trades from a specific channel, focusing primarily on market analysis. Key Requirements: - Set up a system to download market analysis related to Bitcoin trades in real-time from Telegram. - Ensure the data is properly formatted and easily readable in Excel. - Implement error handling and data validation to ensure the integrity of the downloaded data. Ideal Skills and Experience: - Extensive experience with Excel, including knowledge of advanced functions and data manipulation techniques. - Proven track record of working with Telegram's API. - Strong programming skills, particularly in languages commonly...

Tagline: "Professional Logo for Tube Fittings, Valves, and Accessories" Project Description: We are seeking a talented logo designer to create a professional and eye-catching logo for our website, Excel Flow Control. Our company specializes in providing high-quality tube fittings, valves, and accessories for various industries. The logo should reflect our expertise and commitment to excellence in the flow control solutions industry. Key Requirements: Brand Name: Excel Flow Control Industry: Industrial and Engineering – Tube fittings, valves, and accessories Design Style: Modern, sleek, and professional with a hint of industrial elements to reflect our niche. Color Scheme: Preferably shades of blue, gray, or metallic tones, but we are open to creati...

I need assistance with cleaning data from several digital Excel files. Key Responsibilities: - Review and clean data in Excel spreadsheets - Ensure data integrity and accuracy Ideal Candidate: - Proficient in Excel - Has experience with data cleaning - Detail-oriented and able to spot errors in data

...expand worldwide. Each staff member should have their own login to update personal information and download their payslips. Key Features: - Personal Information Update: Employees should be able to update their own personal information. - Payslip Download: Staff should have access to download their own payslips. - Time Tracking: The software needs to track when staff log in and log out. - Tax Calculation: The software must calculate taxes according to Australian & Philippine regulations. - User Permissions: I should be able to grant staff more or less power as needed. The ideal freelancer for this project should have extensive experience in software development, specifically HR software. Knowledge of Australian and Philippine tax regulations will be a significant advantage....

Help me to create our business profile Company name - Pooja Plywood Established - 1992 We are authorised distributors of Greenlam laminates Everset plywood Greenpanel mdf We also deal in all kind of interior products like plywood Veneer Laminate Veneers Hardware decoratives Charcol Wpvc louvers Mdf carved sheet Exterior Panelling solutions Restroom cubcials We 3 generation sucessfully running this family business. Please help me to create our business profile With images.

I'm in ...The primary focus will be on pinpointing individuals and organizations that would be beneficial to the exhibition. Ideal Skills and Experience: - Market research - Making a Database of potential delegates - Ability to search social media platforms, websites, online databases and online B2B marketplaces - Delegate sourcing to build up a database of potential delegates with contact details in excel as per approved fields - Fields required, First Name, Last Name, Email, Phone Number, Company Name, Fields related to addresses - All the data should be verified Payment shall be made on the basis of each verified data of each contact person Data has to be collected from India and from the specific industry only. Please ensure to provide previous examples of similar wo...

I need assistance with manual data entry into an SQL database. The project involves working with database entries, so experience with SQL and data handling is essential. Ideal Skills: - Proficient in SQL - Manual data entry experience - Attention to detail - Data handling skills - Able to work independently and meet deadlines

I'm in need of a comprehensive Excel workbook that can assist in managing and scheduling both staff and volunteers. The workbook should be capable of: - Scheduling staff and tracking days off - Computing hours and calculating salaries Additionally, the workbook should enable viewing the schedule in Gantt charts. Ideal candidates for this project should have a strong background in Excel, particularly in creating complex workbooks with various functions. Experience in HR or volunteer management is a plus. Please note, I will be providing the data necessary for hours computation and salary calculation.

I'm seeking an Excel expert to help me manage and visualize performance grades. The project involves: - Creating tables to breakdown grades according to different units and ranks - Interlinking multiple Excel sheets for live updates - Utilizing formulas and functions for these live updates Ideal Skills: - Advanced Excel skills, particularly with formulas and functions - Experience in data visualization - Ability to interlink Excel sheets I'm looking for someone who can transform this data into a comprehensive and interactive overview of performance grades.