Vba calculator jobs
...Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with Microsoft Office suite. Other suggestions are welcome if they provide a better solution. Deliverables: Automated Excel Workbook: An Excel file with VBA scripts to automate data entry, courier selection, and order form generation (if chosen methodology). VBA scripts to automate sending and receiving emails via Outlook (if chosen methodology). Documentation: Detailed documentation on how the automation works, including instructions for use and troubleshooting. Testing and Support: Initial testing of the automated system and support for any issues that arise during the first month of operation. Skills Required: Proficiency in VBA for Excel and Outloo...
Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code
I require a straightforward, user-friendly spreadsheet that calculates energy savings based on specific input. My needs are very particular. Here are the key aspects: Input Specifications: - It should only take one input: an initial savings value representing the savings our product offers. Calculation Requirements: - I expect the spreadsheet to perform calculations for both percentage and dollar amount savings. Results Format: - The results should be shown as simple numbers; I don't need them displayed as percentages or any graphical representations. The freelancer fit for the task should be proficient in spreadsheet software and have experience in building similar savings calculators. A good understanding of energy savings would be advantageous.
I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. The ideal candidate needs to ...
Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integr...
...able to apply for loans through the system's interface. - Loan Request and Approval Tracking: The system should facilitate the tracking of loan requests and approvals. - Loan Repayment Management: The system should manage loan repayment schedules, ensuring accurate and timely repayments. - Prequalification Status & Loan Calculator: The Loan Management Module should also have a feature that checks the members' prequalification status for loans and includes a loan calculator. Ideal Skills and Experience: - Experience in developing Pension Fund Administrative Management Systems - Proficiency in developing Workflow Tracking Systems, Contribution Tracking Systems and Investment Tracking Systems - Previous experience in developing Loan Management Modules - Profici...
I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).
Hi Sergii B, would you like to do work with me to complete two simple page designs with copy. Page 1 - Options page Page 2 - Residual Grade Calculator Page
I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:...
I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.
I have a mathematical problem related to a video game that I cannot solve. I'm offering 100 dollars to anyone who comes up with a solution, and makes a simple calculator with the solution. The problem is described in this spreadsheet. Please read it before contacting me. https://docs.google.com/spreadsheets/d/1b7J3gmEsKXdg5S7edLrwDv4Xyf8yO0hpFWip2y11bOg/edit#gid=0
...want to use this nabe ANRO because is short same as UBER or BOLT Home About Us Contact Us Services Book Now The Book Now page should include: A fare calculator Car options (e.g., salon, executive car, estate car) A postal code finder (for example, "depart from CV2 5LA to Heathrow Airport") Google Map integrated to show the travel from A TO B The "Drive with Us" page is for driver partners and needs a registration form (I will provide an example). Critical features for this project include: An online payment gateway for convenient and secure transactions. A fare calculator to provide transparency about costs before booking. A user registration system for passengers, ensuring a seamless booking expe...
The project involves developing a WordPress website for my label manufacturing company. The key features of this project would be: - Custom Calculator with Advanced Calculations: I need an expert to create a custom calculator with advanced calculations and customization options. It should also integrate with our product database to ensure accurate pricing based on the user's selections. - Checkout Page: A smooth and user-friendly checkout page is crucial in our website. The freelancer needs to ensure that the checkout process is engaging and seamless for our customers. Design Preferences: The website needs to have a clean and minimalist design. Please ensure that the design is aesthetically pleasing, easy to navigate and compliments our branding. Content Management: O...
I need a comprehensive loan calculator that can handle different loan calculations and provide detailed outputs. The ideal calculator should incorporate: - Simple interest calculation - Compound interest calculation - Amortization schedule based on EURIBOR 6M + spread Key Features: - Input fields for: - Principal amount - Interest rate - Loan term - Calculation of: - Total interest paid - Payment schedule The final deliverable should provide clear, accurate results. The tool needs to be user-friendly, with a clean and intuitive interface. Previous experience with financial calculators or loan management systems is a plus.
I need a professional adept at advanced Excel functions to create a spreadsheet, whi...The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, and writing complex formulas, balanced with an understanding of rota scheduling needs. Experience in the healthcare/pharmacy field would be a plus as well. Your understanding of our needs would help us make this project a success. Good work on this project could lead to more opportun...
I need a professional website th...advisory services: Candidates with experience in creating informative and engaging content relating to finance or investments will have an advantage. - An investment portfolio section: The ideal freelancer should demonstrate an ability to elegantly display financial data in an accessible manner. - A contact form: Allow visitors to submit inquiries directly through the site. - An investment calculator: This needs to be user-friendly and visually appealing, requiring both frontend and backend capabilities. Ideal skills and experience: - Proficient in front-end and back-end development. - Demonstrable experience with finance or investment-related projects. - Ability to create a visually pleasing, user-friendly interface. - Exceptional attention ...
I'm looking for a Virtual Assistant with solid experience in Python, JavaScript and VBA, particularly for handling scripting tasks. Ideal Skills and Experience: - Proficient in Python and JavaScript - Previous experience with scripting tasks - Excellent communication skills - Pro-active communication style Main Responsibilities: - Writing and implementing scripts in Python and JavaScript with APIs - Ensuring the smooth execution of various scripting tasks
...write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriate method) integration in Excel that allows calling the GPT-Invoices model and returning the response in the same cell. Skills Required: Experience with OpenAI GPT models and their customization. Strong understanding of Excel, including VBA or other scripting languages for Excel. Experience with integrating APIs with Excel. Familiarity with cloud storage solutions like OneDrive and handling file structures programmatically. Additional Information: Please provide examples o...
I'm seeking a skilled developer to create a web-based GST calculator for my wordpress website. It should have be responsive and have good UI
...populate VAT information from the Job View page during invoice creation in Laravel. 24. Implement company filter and action links for quotations based on type on the Invoice listing page in Laravel. 25. Disable automatic PDF creation when viewing data; display data in HTML view instead in Laravel. 26. Develop a calculator for estimating materials, ensuring compatibility with the old CRM and website in Laravel. 26a. Update the Enquiry database to save enquiries from the website Estimate Calculator form in Laravel. 27. Work on integrating a map to visualize data in Laravel. 28. Implement CRUD functionality for Email Templates in Laravel. 29. Allow selection of email templates within the current module and associate specific module items with them in Laravel. 30. Integrate SM...
I'm in need of an experienced Google Sheets expert to create a fully functional payroll sheet for my company. This will be tied into our company expenses and have calculations to find our expenditure per service we provide. Key requirements: - Develop a payroll sheet with built-in expenses calculator integrated. - The expenses calculator should include costs for labor and equipment. - For labor and equipment, the calculator should compute total costs and cost per job, as well as provide summaries on a per-service basis. Your ideal skills: - Proficiency in Google Sheets, with experience in creating complex, automated calculation sheets. - Strong understanding of payroll and expenses management. - Ability to translate business requirements into a user-friendly, ef...
I'm seeking a...develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN and description creation already made. Can be used as refe...
...consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and implement VBA scripts or macros for data consolidation. - Performance Optimization: Experience in optimizing Excel for better speed and performance would be a big plus. - Attention to detail: The accuracy and integrity of data are crucial, so attention to detail is a must. - Communication: Regular updates and clear communication throughout the project a...
I am seeking a skilled PHP developer to create a distance calculating sript for me. This script will be responsible for calculating the distance between multiple coordinates stored in a MySQL database. No user interface required as the coordinates will be retrieved from the database directly. Key requirements for the project include: - Create a script that can fetch the coordinates from a MySQL database - Calculating the distance between these multiple coordinates accurately If you're a developer with experience in MySQL PHP and distance calculations, I would love to hear from you.
I'm seeking an expert in Excel macros with an advanced understanding of VBA to accomplish several tasks for my project: - Automate data entry processes. - Generate comprehensive reports. - Perform complex calculations. Key skills you should have: - An advanced understanding and experience of Microsoft Excel. - Proficiency in developing and implementing Excel Macros. - Advanced VBA coding skills. To be considered for this project, please include the following in your application: - Detailed project proposals, illustrating how you plan to achieve the tasks outlined above. Please note, this project is demanding and requires a high level of familiarity with Excel and VBA to be executed efficiently and effectively.
...continue work on an in-progress database or commence anew based on existing requirements. This database is intended for exclusive use within our family bakery, facilitating efficient management of formula costing involving ingredients, labor, and overheads. The final product should encompass: - Seamless migration of current data - Storage for formulas and preparation instructions - Pricing calculator adaptable to variable inputs (ingredient costs, labor) - User-friendly interface tailored for non-technical users Additionally, please note: - The database developed will serve solely my bakery's operational needs. - Ownership of the completed software will remain with me. - While there's potential interest from other bakeries, extending or distributing the sof...
I need a desktop commission calculator software designed specifically for Windows. The software will be fairly simple but will need to perform two key functions: calculating commission at different rates for distinct products and calculating commission based on individual employee sales. Key Requirements: - Design a user-friendly desktop application (i can help you in UI) - Develop a system that allows me to upload sales data through Excel file. - Implement a mechanism that accurately computes commission based on different rates for different products - Ensure the software can calculate commission payout based on individual employee sales Ideal Skills and Experience: - Proven experience in developing desktop applications, preferably in Windows - Proficiency in designing and creati...
I'm seeking a skilled developer to create a user-friendly macro calculator that's accessible on the web. This tool will help individuals in calculating their daily calorie needs based on their fitness objectives, whether it's weight loss or muscle gain. Key Features: - A simplistic yet engaging web interface that allows users to easily input their details - Capability to calculate an individual's daily caloric needs based on their goals - A results page that provides users with a clear breakdown of their macronutrient requirements The calculator will not require user accounts for tracking progress. Instead, users will have the opportunity to download their results after entering in the details for lead generation. This project is intended to generate lea...
The aim of this project is to create a unique calculator that will be integrated into my Shopify page. This calculator is intended to have two main functions: 1. Estimate weight and hand wrist circumference based on user's height and Body Mass Index (BMI) health status e.g underweight, ideal weight, overweight, obese. 2. Utilise the wrist circumference to determine the appropriate watch size. The ideal candidate able to undertake this task should have proficient skills in Shopify application development and a clear understanding of BMI calculations. Any previous experience with crafting calculators for eCommerce would be considered a plus. Key Requirements: - Develop a height and BMI health status input system - Formulate algorithm for estimating weight and hand ...
...small text that shows: standard included: basic support with answers and fix within 2 weeks. Normal will go a lot faster +-24 hours. And then below we will have 3 options next to eachother with support plans; Setup-support - included; Basic support ; vip support. With some space to add points and price in there. 8. Then we should have a page; Why should you do it? Here we will need to have a ROI calculator that gives them a view of how much they save by using our product. Make this in different sections so we can make 3 modules, with each 3 points below. Focus on time saving. 9. Then we will have the How will we implement? Here the project timeline how we will implement it will be displayed in a vertical timeline with right some options to add text. Make sure you show them that t...
...runtime error in my ChatGPT Excel VBA script, specifically during data analysis. I need an experienced VBA developer to help me identify and resolve the issue. Key aspects of the project: - Debug a runtime error: The issue is occurring during the data analysis process. You'll need to identify the root cause of the error and implement a solution to ensure the script runs smoothly. Ideal skills and experience: - Proficient in Excel VBA: You should have a strong command of Excel VBA, particularly in handling data analysis tasks. - Debugging experience: Prior experience in identifying and resolving runtime errors in VBA is essential. - Familiarity with ChatGPT integration: While not mandatory, previous experience with integrating GPT models int...
ChatGPT is generating VBA to automate Excel data manipulation and other actions. As a VBA EXPERT, you will debug the code when it doesn’t do exactly what it was asked to. The project is being built module by module. There are about 6 modules.
...various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understanding of data visualization techniques and tools will be beneficial. - Software Development: Experience in developing bespoke software within Excel would be advantageous. Please note that while the visualizations need to be created using Excel, I'm open to suggestions for automating spreadsh...
I need a proficient Excel wizard to design a property investment calculator for me. The calculator will be used to determine the total cost of purchasing and building a small investment property. Here are some of the features I need it to have Input property costs, land and build. A time frame for build variable Calculation of progressive interest being charge as the house is being constructed. This amount is combined with Council rates Builders deposit, legals and other costs Total cost - Expense Calculation: This will specifically account for property taxes. - Adjustable Mortgage Rates: The calculator must be capable of taking into account changes in mortgage rates over time. I will provide an example for reference. Excel efficiency, financial modelling ...
I am creating a disruption tracking sheet for Disaster Recovery. I am in need of an Excel VBA expert who can create an efficient macro for me. Your task will be to create a macro that will primarily deal with: - Copying Affected systems from each incident, to the tracking page. - Sort tracking page maximum allowable disruption time - Need to add a manual entry for the time of the incident, and the maximum allowable outage time should have a countdown to how long until it is breached. - Macro should run automatically every 30s or so. If you have a good understanding and experience working on Excel VBA scripting, specifically in creating macros, this job is right for you. An in-depth knowledge of disaster recovery protocols and incident tracking will be a plus point. Please ...
...need a website that allows us to provide pre-employment assessments for our clients. Nothing we need is new, and building from existing tools is acceptable. 1) Website. For the most part, pretty standard stuff. Other than this we would want: a) a test library so that people can see what tests we offer (but not the entire test, just a description or some example questions), and b) an ROI calculator - where the user can specify some details about number of jobs etc and we can show the ROI. We will provide the mathematical calculations. 2) Candidate Portal. Applicant needs to be able to: a) redirect to this from the job board or company career page, b) create an account and create and/or edit candidate profile. Profile could (optionally) be created at the same time as fi...
...populate VAT information from the Job View page during invoice creation in Laravel. 24. Implement company filter and action links for quotations based on type on the Invoice listing page in Laravel. 25. Disable automatic PDF creation when viewing data; display data in HTML view instead in Laravel. 26. Develop a calculator for estimating materials, ensuring compatibility with the old CRM and website in Laravel. 26a. Update the Enquiry database to save enquiries from the website Estimate Calculator form in Laravel. 27. Work on integrating a map to visualize data in Laravel. 28. Implement CRUD functionality for Email Templates in Laravel. 29. Allow selection of email templates within the current module and associate specific module items with them in Laravel. 30. Integrate SM...
Hello! Please read carefully before bidding. In a frontend web design to be converted to PHP/HTML. This is a shipping website with one main function: A shipping calculator. Custom built, no API. Primary objective: 1) Customer chooses from country and to country (Very similar to this website's interface: ). 2) After the customer gets a rate from two couriers only (UPS and FedEx) and multiple shipping services, the customer provides more information about three things: A) The sender. B) The receiver. C) The package. Then a customer checks out using Paypal. Secondary objective but not as important or could done possibly at a later phase: 1) Package tracking which possibly needs an API. 2) Basic signup and sign-in menu similar to this of
I recently acquired a Table Calculator website but without the source code. The current version is outdated and lacks the functionality I need. I'm looking for a skilled developer to recreate the website from scratch with some added features.
...looking for a skilled WordPress developer to build a website for , a company specializing in property and business loans overseas. The website should support multiple languages and feature a multi-currency loan calculator, secure loan application processing, and user account management. Objectives: Develop a clean, professional-looking website using WordPress. Include key functionalities such as a loan calculator, multi-language support, secure application forms, and customer login areas. Required Features: Multi-currency loan calculator Secure application processing User registration and management Responsive design for all devices SEO-friendly structure Skills Required: Proficient in WordPress, PHP, HTML, CSS, and JavaScript Experience with financial services ...
...stock alert mechanisms to notify users when inventory levels fall below a certain threshold. - Alerts can be sent via email, SMS, or displayed within the software dashboard. This software solution would require a database backend to store all relevant data and a user-friendly interface for easy interaction. You could develop it using Microsoft Access, incorporating forms, queries, reports, and VBA (Visual Basic for Applications) for automation and customization. Consider consulting with stakeholders and users throughout the development process to ensure the software meets their specific needs and requirements. Additionally, thorough testing and refinement will be crucial to ensure the software operates smoothly in real-world scenarios. Key Features and Requirements: - Strea...
Hi. I need help to setup the binding for a RichTextBox .NET Control so that data is retained. There may be use of VBA that is needed. This is within a FactoryTalk View SE version 14 application. I don't know .NET or VBA, I am a FactoryTalk guy though. Example use case: Lets say a factory has 100 valves. If a user opens popup for Valve #3, I need a text box field in that popup for the user to enter data, and then data is preserved/saved. That popup should be one common FTV display that references the Valve_# that was selected (using parameter files, or...). This example is the main objective. I need a simple and easy solution to this, and I need to understand how to do it myself afterwards. This is perhaps a 1 hour job. My name is Marc. I'm ready to s...
I need a PHP script to calculate working hours based on the start and end time. The script should: - Calculate working hours based on the start and end time - Handle only standard working hours - Automatically deduct a fixed break time Ideal skills and experience for this project include: - Strong PHP programming skills - Experience with time and date calculations - Understanding of working hour calculations and break time deductions - Ability to create a clean and efficient script
...- Model Versioning: Unlike other models that auto-update or create new versions, I require a plugin that allows me to manually select the version to work with. This ensures control and adaptability to changing needs or scenarios. The Ideal candidate has advanced knowledge not only in plugin development but also a deep understanding of financial data and its complexities. Proficiency in Excel, VBA, and data management are key, along with a keen attention to detail and a commitment to accuracy. Experience in financial modeling is a big plus. Your ability to meet these specific needs could make a significant difference in my work. - I would like to do quick interactions of the project and rapidly develop the final product. My design does not require any database connection. -...
As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling in Excel 2016 - Demonstrate flexibility a...
I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specifically any projects rel...
I'm in need of an experienced IoT device developer to create a production-level device specifically tailored to calculate current flowing through a phase in a transformer. Ideally, the skill-set of the successful freelancer will include: - Experience with ESP3266 and clamp current sensor. - Expertise in the development of IoT devices that can perform real-time monitoring. - Capable of crafting a solution that concentrates specifically on current level monitoring. - Should be more efficient and accurate current flow value - AWS iot core experience will advantage - Open for suggestions for production level. This project could potentially roll into a long-term contract depending on the success of the initial task. So, if you have the skills and experience, please place your bid on th...
...ability to extract insights from complex data sets and present them clearly is crucial. - Macro Development: You will be responsible for automating repetitive tasks in Excel, including generating reports, automating data entry, and creating efficient formula calculations. Your macros should be user-friendly and easy to maintain. Ideal Skills: - Proficiency in Excel, including advanced functions and VBA programming - Strong background in data analysis and visualization - Experience in creating macros for automation - Excellent communication skills to understand the project requirements and translate them into effective solutions This project is a great opportunity for someone looking to enhance their skills in advanced Excel-based roles and gain hands-on experience in data analy...
...Users must be able to place buy and sell orders directly from the app. - Portfolio Management: A feature for tracking and managing their investment portfolios. - Research and Analysis Tools: The app should include tools that allow users to conduct in-depth research and analysis. - Watchlist: Users should be able to create and manage watchlists of stocks or other financial instruments. - Position Calculator: A tool for calculating the position size for a given trade. Ideal Skills: - Proficiency in Android and iOS development - Experience in creating trading or finance-related applications - Strong understanding of real-time data integration - Expertise in creating intuitive, user-friendly interfaces - Knowledge of security and data protection best practices in finance application...
