Excel formulas and functions jobs

...electronic circuit and hardware engineer to help me with the design and selection of components for a project. The project involves the creation of a power supply, an analog digital converter, and a relay. Key Responsibilities: - Circuit design: I need help with creating the circuit for the mentioned components. This includes ensuring the circuit is efficient and functions as intended. - Component selection: I'll require assistance in selecting the right components for the circuit. It's crucial to choose components that are of high quality and fit the project's requirements. The ideal candidate for this job should have a solid background in electronic engineering, particularly in circuit design and component selection. E...

...JavaScript, and PHP to create a comprehensive work tracking portal. I have a very rough semi functional example site attached. This will be hosted on a private server with vpn access from each user so security is not a extreame concern. key functions basic login system allow users to enter daily work time with some notes ; I would like them to be able to edit them after allow users to see a list of all open jobs and be able to click on them to open them and edit as needed client management - need to be able to search existing clients or add new ones as well as view any jobs open or closed for the client. job photo uploads need to be optimized for mobile phones / tablets I would also like to add a map of the address for jobs and clients. ...

I'm in need of a Flutter Developer to assist with updating our existing Art Prizes app for both iOS and Android. We've made additions to the underlying .NET solution and now require integration of new pages and features. It's crucial that you have a solid understanding of Flutter as well as knowledge on integrating APIs. Previous experience in updating existing apps and implementing push notifications is highly desired. If you don't have a rating of 4.9 or higher I won't be contacting you. You will have a formal process for versioning the iterations and you will have inhouse testing available. If you deliver an initial solution that is full of bugs we won't continue working with you. First deliverable will be the IOS vers...

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forw...

...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as ...

I need a talented developer...talented developer to build me a cloud-based SaaS ERP system with specific features and integrations. - The system should include essential functions like Inventory Management, Financial Management, and Customer Relationship Management. - It should be customizable at a basic level to allow for changes such as colors and the addition of a logo. - In terms of integrations, I require the system to connect seamlessly with CRM, E-commerce platforms, and Payment Gateways. Ideal candidates should have a strong background in developing SaaS ERP systems and possess the necessary technical skills to integrate different software and platforms. A solid understanding of inventory management, financial tracking, and...

...talented freelancer to help me automate a complex process. As of now, I manually gather numerical data from a variety of unstructured sources like images, text, and PDFs. This data includes formulas and is stored both on my local computer and the web. At present, I get ChatGPT to convert this data into a table which I then paste into excel. I do calculations in excel to find out what percent each ingredient is of a total formula. Then I create a new entry into a table in Airtable and paste this data into a different table in Airtable which references the first table. I need someone to automate this data extraction process, calculations and entry into two separate Airtable tables so I can do it repeatedly myself. I work in a standar...

I have a PDF file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note th...

...me. If the functionality is working correctly, I will give you the login details, and you can then transfer it there and continue the work. and I will also award you the job at that time. 3) The product must be customizable with text and adornments that the customer chooses. The most important part is that the customization choices will show on the picture in real time. In other words, the picture will change each time a customization is added. I need ONE PAGE created for web store (wordpress/woocommerce). Must have a visual product customizer. Meaning that a customer will have the option to customize the item and see the changes they make in real time. Not just colors and sizes though, but entering texts and choosing adornments, etc. He...

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by ...

...needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for mergin...

I am looking for an ex...looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform...

...implementing specific modules in Odoo and integrating third-party apps in a bid to significantly improve the customer experience as well as streamline our business systems. You should have: - Outstanding experience and expertise in Odoo implementation and project management. - Proven track record in integrating third-party software and adapting functionalities. - Exceptional familiarity with CRM, Inventory Management, Accounting, and us of Odoo apps to manage food delivery. Key tasks include: 1. Data Migration: -Taking CSV files of my exported sales data from Shopkeep and importing it into Odoo without loss of critical information in order to enable reporting on old sales data. 2. Odoo Implementation: - Doing initial setup for Inventory...

I am looking for a professional who can build a web application that automates the creation of Google Sheets formulas. Requirements: - Build a web application that allows me to input a plain text command in a Google Sheets cell (i.e., I type "= find the mean of the data above". - Translate the plain text command into a Google Sheets formula using the ChatGPT API. - Authenticate and send the formula to Google Sheets for execution. Ideal candidate: - Proficient in web application development. - Experience with integrating APIs, particularly ChatGPT. - Familiarity with Google Sheets automation and formula creation. - Strong understanding of user interface design for a seamless user experience.

I am in search of a skilled KNX engineer to design a comprehensive hom...solution for a 4 room apartment. Key Requirements: - The scope will involve creating an AutoCAD file, a wiring plan, and a 2D structure for the products in the architecture plan. - You must also provide a list of quantities. Specific Features & Functions: - The automation project should include lighting control and temperature control. Integration: - There is no need for voice control or mobile app integration. Scalability: - The system should be designed to be scalable for future upgrades or additions. Ideal Skills: - Proficiency in KNX engineering with a portfolio demonstrating similar projects. - Strong AutoCAD skills. - Ability to design for scalability and future-proof t...

I'm looking for a skilled developer to create a robust mobile application that offers real-time translation capabilities and includes an AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Profi...

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

I'm seeking a skilled robotics engineer to simulate basic robotic movements in Gazebo. My project's scope includes: - Engineering a robotic system to perform automated maneuvers. - Implementing basic movements such as forward motion, turning, and stopping. Your expertise should ideally include: - Proficiency in robotics engineering inclusive of controller expertise and Gazebo simulation. - Familiarity with automated systems and their movements. I anticipate this project to be less complex but I demand accuracy in basic functions.

...database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and logical thinking - Abilit...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

Some functions are not working properly. All files of the site are hosted and the site is complete but due to some error while connecting to the database some code is missing and the connection is not completed. You have to find out where the problem is and fix it properly. I will help you in everything ******* I'm seeking a skilled PHP developer to assist with a project that involves fixing a PHP file and combining a Php ,MySQL database. The main tasks for this project include: - Resolving a database connection issue in the PHP file. - Combining the MySQL database in the backend of the PHP file. Your role will be crucial in ensuring that the database is correctly integrated into the PHP file and that the database connection is stable ...

I need a skilled website developer to help me upload my WordPress website templates to Hostinger. Key Responsibilities: - Assistance with uploading my existing WordPress website templates to Hostinger - Ensuring the website functions correctly post-upload Ideal Skills: - Proficiency in WordPress and Hostinger - Experience in website template upload and customization - Good communication skills Please note: I am not looking for website design or content creation; this project is solely for technical assistance with the upload process.

I'm experiencing frequent slowdowns on my Moodle quiz site when more than 200 users are taking the quiz concurrently. The site is hosted on a dedicated server. Key Points: -...quiz simultaneously. - The hosting environment is a dedicated server. Your role as a freelancer would involve: - Identifying the performance bottlenecks on the site. - Implementing optimizations to ensure the quiz functions smoothly for a large number of concurrent users. Ideal Skills and Experience: - Extensive experience with optimizing Moodle sites for high traffic situations. - Proficiency in configuring and fine-tuning server resources. - A strong understanding of Moodle's architecture and how it handles multiple simultaneous users. - Exceptional problem-solving skill...

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You wi...products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant expe...

I need an expert in Selenium to automate functionality testing of our web application. This project aims to ensure the application functions as expected with regular, automated testing. Key Responsibilities: - Developing automated functions testing for our web application - Ensuring tests are compatible with Google Chrome. Ideal Skills: - Proficient with Selenium - Familiar with functionality testing. - Reliable and consistent test development. Previous experience with Selenium-based functionality testing in Chrome is highly desirable.

I am experiencing a recurring issue with my WordPress website...activate them, they are found deactivated again the following day. I need assistance with creating a backup of the website and safely updating WordPress along with all plugins, including Elementor, to ensure the website functions correctly without any plugins deactivating unexpectedly. Your expertise in resolving this issue and restoring full functionality to my website would be greatly appreciated. The primary task is to identify and fix the issue that's causing the plugin deactivation. Ideal freelancers for this project should have: - Strong experience with WordPress plugin development. - Proficiency in troubleshooting and debugging WordPress issues. - Ability to work quickly and...

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

...experience in cTrader platform and C# programming to create a custom Renko-based cBot for me. Key Requirements: - C# Proficiency: The developer should be well-versed in C# programming language, as the cTrader platform typically uses this language for cBots. - cTrader Platform Knowledge: Experience with this platform is essential, the developer should have a strong understanding of how to work with its APIs and develop cBots. - Custom Renko Functionality: I need the developer to implement a custom brick size for Renko charts in the cBot. -Automated Trading Execution: The cTrader bot should be able to automatically execute trades based on the parameters of the strategy. - Backtesting and optimisation capabilities: The ideal developer will need to optimise and...

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please ...

For this project, I'm seeking a proficient iOS Developer to build a simple directory app. This app should contain the basic functionalities such as user search, view, and more. It should be developed with a left drawer navigation system. The main skills and experiences preferred for this task include: - Proficiency in iOS Development - Experience in designing and implementing search and navigation functions - Knowledge of directory structure and data management The completion of the project is expected within a month, therefore a commitment to meeting this deadline is necessary.

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

...Unfortunately, it's currently unknown which specific script to be used, but clarity will be provided as the project progresses. - Discern the implemented functions within the script. The functionalities mainly centered around recognizable trading indicators like Moving averages, Pivots, Fibonacci and MACD. - The code extraction should consider compatibility with variable timeframes. Whilst exact timeframes aren't specified yet, flexibility should be maintained to accommodate potentially any (e.g. 1 minute, 5 minutes, 1 hour, and more) I expect freelancers interested in bidding for this project to have proven experience in Pine Script programming and a reliable understanding of trading indicators. Kindly attach a sample of a similar project you�...

I'm looking for a website developer who can build me an online store on WordPress which I could migrate to Hostinger. The store will primarily cater to physical products, and I plan to list more than 200 items. However, there is no need to develop the product and product descriptions for all the products. Some templates and editable product box will suffice my need. Some Key Requirements: - WordPress Expertise: Must be proficient with the WordPress platform. Having prior knowledge of Hostinger is desirable but not required. - eCommerce Experience: Prior experience in developing online stores with all the functions is necessary. - Minimums 2 months of support after go-live. - Should be compatible with Mobile browsers as well. - User Login Panel, Shopping C...

I have an excel file, need add product categorie on a column - budget 100€

I am looking for a seasoned mobile...application geared towards professionals. Key Features: - User Registration and Profile Creation - Messaging System - Networking and Connection Building Features - News Feed for Professional Updates - Job Listing and Recruitment Section - In-App Search and Filter Functions - Notification System - Integration with Existing Social Media Platforms Skills and Experience: - Proficient in mobile app development - Previous experience in creating social networking applications - Strong understanding of user experience and design principles - Ability to integrate various APIs - Familiarity with data security and privacy standards This is a unique project and I am looking for ...

...to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience wit...

Hello, I need complet the Amazon categories catalogue excel in french

I'm looking for a C# developer to build an application for me. You need to make C# application (app/web/console whatever is best for you). Basically, it is POST, GET, PUT, DELETE requests against API. Problem is that there is limited documentation, so you must conclude based on swagger documentation how to implement each of functions. Swagger link will be provided. Please, apply for this job if you can do it TODAY.

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

...in automating lighting, heating/cooling and integrating specific features for each area. Key Requirements: - Lighting Automation: I need the system to include dimming capabilities, color changing lights, and motion sensor lights. It should be able to adapt to different lighting needs and situations. - Heating/Cooling Automation: I have a smart thermostat and I would like it to be integrated into the system. The system should allow for optimal temperature control and adapt to my preferences. Ideal Skills: - Home Automation: Experience with setting up and integrating smart home features is a must. - Lighting Systems: Proficiency in configuring lighting systems with various functions. - HVAC Systems: Knowledge in working with smart ther...

I am looking for a well-qualified freelancer to help me develop a motivational app using AI. The user interface required for the a...using AI. The user interface required for the app will be a mobile application. We will also need an admin panel to manage user subscriptions. Additionally, AI scripts need to be incorporated into the app as well. The purpose of the app is to motivate users and encourage them to reach their goals. The freelancer I choose to work with must possess advanced experience in both mobile application development and AI programming. They should be comfortable working with both UI/UX design and backend development to ensure that the app functions correctly. Project Brief -

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I'm looking for a skilled Visual Basic 6 programmer to adjust functionality wit...for a skilled Visual Basic 6 programmer to adjust functionality within my VB6 source code. The task primarily involves expanding reporting functions to include more tables. Ideal applicants should have: - Extensive experience in VB6 programming. - Previous work involving functionality adjustments, particularly in Reporting and Data Management. - A keen eye for detail to maintain existing code integrity while implementing changes. - Strong understanding of data management and manipulation in VB6. Your role will be solely focused on altering the existing VB6 code and ensuring the changes don't disrupt the software's operational flow. Familiarity with VB6 and p...

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing comprehensive plans that can be used for obtaining necessary permits. Your understanding of local building codes and regulations will significantly contribute to the project's success. - Ensuring these detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential constructi...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Preparation: This includes c...Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling nume...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement...