How to calculate ucl and lcl in control charts in excel jobs

I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. -...

...level is tested by price touching it. I will send a video to those interested to show what I am referring to. The script should: - Automatically mark a 60-minute high/low with a labeled line. -The 60 minute high/low will show on ANY timeframe chart. For example, if I'm looking at a 60 minute chart and 5 minute chart side by side, and both have the new indicator on them, the 60 minute lines should be the same on both charts. I will be adding this indicator to many charts and the timeframes will all be different, but they should all pull their lines from the untested 60 minute high/low. - Make the label "H1" until the level is touched by the price - Remove the line and label upon price going th...

...skilled data analyst to help with daily updates of my product, customer, and regional sales data in Excel. The job involves using SUM and AVERAGE, VLOOKUP or HLOOKUP, PivotTables Excel functions and formulas for accurate and up-to-date data representation and analysis. Key Points: - Daily sales data update: The job will involve ensuring that the sales data for products, customers, and regions are updated daily. - Excel functions and formulas: The successful candidate should be well-versed in using Excel functions such as SUM and AVERAGE, VLOOKUP or HLOOKUP, and PivotTables to handle large sets of data accurately and efficiently. Ideal Skills and E...

I'm looking for a skilled freelancer to create a mantra chart in Excel. This will be a presentation-worthy document, so I'm keen on ensuring that it's well-structured and visually appealing. Key Requirements: - Incorporating text, numbers, and dates into the chart - The chart should feature less than 10 mantras - Ensuring the final output is suitable for professional presentation The task will require someone with excellent Excel skills and an eye for design. A good understanding of data representation would be a big plus. You can expect detailed instructions and guidance from me throughout the project. Feel free to ask any clarifications you might need.

We are in need of a highly skilled Laravel expert team to continue development on existing web application! The specific Task - Requirements Document will be provided. Selected team will be having opportunity to work for long term! Skills and Experience: - Extensive experience in Laravel development - Proficiency in Laravel customization and optimization - Strong understanding of Gitlab - version control !* - Excellent problem-solving skills and attention to detail - Database Design & Management: The ability to design and manage a highly organized, efficient database is crucial. Skills that would be beneficial: - Thorough Laravel expertise - Understanding of Git version control - Proven track ...

We are in need of a highly skilled Laravel expert team to continue development on existing web application! The specific Task - Requirements Document will be provided. Selected team will be having opportunity to work for long term! Skills and Experience: - Extensive experience in Laravel development - Proficiency in Laravel customization and optimization - Strong understanding of Gitlab - version control !* - Excellent problem-solving skills and attention to detail - Database Design & Management: The ability to design and manage a highly organized, efficient database is crucial. Skills that would be beneficial: - Thorough Laravel expertise - Understanding of Git version control - Proven track ...

...am seeking a talented and passionate Front-End Web Developer to join my team and contribute to the development of Bayard, an AI research assistant web application. As a Front-End Web Developer, you will be responsible for creating and maintaining a user-friendly web interface for Bayard, enhancing the accessibility and usability of the application. Responsibilities: - Collaborate with the Bayard development team to design and implement a responsive and intuitive web interface for the AI research assistant. - Develop clean, maintainable, and efficient front-end code using modern web technologies such as HTML, CSS, and JavaScript. - Integrate the front-end with the back-end API endpoints to enable seam...

...project that is in need of completion. The project already incorporates essentials like user authentication, data entry forms and graphical charts and visualizations. However, the Graphical User Interface (GUI) needs enhancement to ensure a better user experience. • Finish the incomplete JavaFX code and make the project work properly. • Enhance the GUI – it should be pretty straightforward for someone with your skills. • Ensure that the GUI makes logical sense and applies well to the rest of the code. The ideal candidate for this project should be an experienced JavaFX coder comfortable with GUI enhancement implementations. Having excellent attention to detail and problem-solving skills will be ...

...company specializing in web and mobile apps and digital solutions. We are passionate about creating innovative mobile applications that provide exceptional user experiences. Our team is dedicated to pushing the boundaries of technology to deliver top-notch solutions to our clients. Job Description: We are seeking a talented and motivated Part-Time iOS Mobile App Swift Developer to join our team. In this role, you will work closely with our development team to design, develop, and maintain iOS applications using the Swift programming language. This position offers the flexibility of working part-time, making it ideal for candidates looking to balance work with other commitments. Key Responsibilities: C...

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

I am in need of a compact PCB design for a relay bank. The primary application of this relay bank is for industrial control, so the design needs to be both efficient and reliable. Key requirements: - The relay bank should be small in size, while still accommodating 6 triggers at 230 volts. - The design must include a dry switch rated at 13 Amps. - The PCB must be designed with the intention of obtaining CE certification. Ideal skills for this project include: - Proficiency in PCB design, particularly for high voltage applications. - Experience in designing for industrial control applications. - Knowledge of CE certification requirements for PCBs. It's crucial that the design be not only functional but also compliant with CE ...

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.

...Arduino and ESP32 LVGL programmer who is able to Build arduino code for a Waveshare ESP32 s3 Touch LCD 4.3 and recognize data from I2C ADS1115 interface a display grafically Display have to rappresent data in 4 different page changeable touching icons placed in down part of display In each page are displayed more rounded bar with % value received from 3 x ads1115 i2c connected Key Responsibilities: - Program the ESP32 to recognize and interpret the data from the I2C ADS1115 sensor module - Integrate a responsive touchscreen control and an LCD display on the Waveshare ESP32 s3 Touch LCD 4.3 - Ensure the system is user-friendly and able to display the sensor readings accurately - Implement the s...

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can ...

...for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure th...

I am blending Google Sheet data with Google Ads and Analytics data but getting an error message. Need someone to help via screenshare. Thanks!

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior...

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

I need a web-based application to calculate the dues per apartment based on the expenses categorized by type. The main points are: - Expense Categorization: The app should categorize the expenses by type. For instance, maintenance, utilities, repairs, etc. - Dues Calculation: - Square Footage Basis: The apartment dues should be calculated based on the square footage of each apartment. - Platform: The application should be web-based, accessible from any browser. Ideal Freelancer: - Experience with web application development, especially in accounting or financial tracking software. - Understanding of expense categorization and calculation based on different parameters. - Familiarity with building user-friendly interfaces.

...exceptional PowerPoint designer who can use a professional theme and color scheme to turn my financial transformation metrics into an engaging, compelling presentation - one that's set to impress at an upcoming award ceremony. Key Duties: - Design a 20-slide PowerPoint presentation focusing on the financial transformation metrics of a large organization. - Use a professional color scheme that matches the tone of the event and makes the charts and graphs easy to understand. - Make the presentation engaging, logical yet impressive to the jury at an award ceremony. Ideal Skills and Experience: - Excellent PowerPoint design skills. - Experience in interpreting financial metrics and transforming them into c...

...skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you ...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel...

I'm in need of a skilled buying agent based in Thailand, focused on sourcing suppliers for tobacco. The aim is to find reliable, quality suppliers predominantly in the tobacco industry. Skills & Experience Required: - Extensive experience as a buying agent - Good knowledge of the Thailand market, particularly tobacco - Strong network of suppliers - Proven record of sourcing quality home appliance, electronic, and fashion suppliers - Excellent negotiation skills This is an ideal opportunity for anyone who: - Is familiar with Thailand and the tobacco industry - Has experience sourcing and negotiating with suppliers - Has a keen eye for quality control. Please do not apply if not based in Thailand.

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

Develop macro-enabled Excel file to handle CSV

...minimum of 10+ years of experience, I am looking to enhance an existing Real Time Dashboard within PHPMaker 2023. Key Responsibilities: - Modify existing features and incorporate new functionality - Implement user authentication system to ensure data privacy - Create real-time notification system for immediate updates - Develop advanced interactivity for data manipulation and customization Desired Skills: - Proven expertise in PHP development, ideally with PHPMaker 2023 - Comprehensive experience in building Data visualization (Charts, Heat maps, Custom Dashboards) - Strong understanding of user authentication mechanisms - Ability to develop real-time features for immediate data updates - Experience in creating advanced in...

I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience ...

...written a Python code to extract a table from an HTML file. I need an expert in Python, Pandas and BeautifulSoup4 to review and make minor adjustments as necessary. The purpose of the table extraction is for data analysis. The HTML file has multiple tables with some nested elements, not overly complex. Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , in...

I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources

I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to ...

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.

...Google Sheets. The system should automatically calculate total hours worked, allow for marking employees as present or absent, and have fields for project number and name. Key Features: - Automatic Calculation: The system should calculate the total hours worked by every employee within the specified date range. - Attendance Tracking: There should be an option to mark employees as present or absent. - Project Details: Each row should contain fields for the project number and name. - Multi-employee Handling: The system should accommodate multiple employees' data in a combined sheet. Skills and Experience: - Proficient in Google Sheets - Experienced in creating automated time tracking systems - Familiarity with em...

I'm seeking a problem solver to help me enhance my existing inventory management system. While I didn't specify the current system in use or the number of products managed, I am encountering some challenges that need to be addressed. Key responsibilities include: - Identifying and solving existing inventory management issues - Improving the overall efficiency and accuracy of the system - Implementing best practices for inventory control The ideal candidate should have: - Prior experience with inventory management systems - Strong problem-solving skills - Attention to detail and accuracy - Ability to understand and optimize complex systems Please note that specific details on the current system and num...

...put money hence our AI works on it through big data and automation. The project is about algorithmic auto-investing trading on world wide's financial market. Fixed Rate Job Paid based on success delivery per country. $10/country. Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup ...

...developer with experience in CodeIgniter for a new project in the e-commerce space. Ideal Skills and Experience: - Proficiency in PHP and CodeIgniter framework - Previous experience in e-commerce platform development - Strong understanding of front-end technologies, such as jQuery, JavaScript, HTML5, and CSS3 - Knowledge of MySQL and other relational databases - Familiarity with RESTful APIs and Web Services - Ability to work with version control systems like Git The primary goal of the project is to create a robust, scalable, and user-friendly e-commerce platform. The platform should be able to handle a large number of products, facilitate smooth transactions, provide a secure payment ga...

...hydrometer to measure the specific gravity of lead acid batteries. This will serve as a crucial tool to check the health of various batteries in real-time, ensuring they're operating effectively and do not pose a risk of failure due to overcharging or undercharging. Key Features: - The hydrometer should have a standard accuracy of ±0.01. This level of precision is essential to correctly assess the battery health and predict any potential issues. - The data collected from the hydrometer needs to be available through a web interface. This online access will allow me to monitor multiple batteries from a central location, offering more convenience and control. Ideal Skills and Experience: - Exp...

...specialist to compile an in-depth and multifaceted sales process documentation. The final product should cover: - Sales cycle flow chart - Sales training playbooks - Comp plans - Meeting agendas - Handbooks - Sales funnels Client intake forms - Any other relevant sales documentation not listed As a freelancer, your past work weighs significantly for this project. Showcase your proficiency in creating similar sales documentation that not only informs but also engages. You should be comfortable creating complex flow charts and formulating playbooks that relay sales strategies efficiently. Your capability to work with Word documents format is essential as I prefer this medium for the final deliverables. Efficiency and attention ...

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.

I need a proficient PHP developer to address an integration issue I'm experiencing with the Ccavenue payment gateway on my website. Key Tasks: - Resolve the integration issue occurring at a specific stage of the payment process. - Implement the necessary changes to ensure the payment gateway functions seamlessly. - Integrate a new control panel in the admin panel. Ideal Skills and Experience: - Strong command of PHP, particularly in relation to payment gateway integration. - Previous experience with Ccavenue payment gateway is highly preferred. - Proficiency in admin panel development. - Ability to troubleshoot and identify issues efficiently.

More details: *What specific type of claims do you expect the expert consultant to identify? Delays, Cost overruns, Scope changes *How many projects do you need the expert consultant to review? 4 *Project documents will be supplied. *Reference Contract: FIDIC Red Book *How soon do you need your project completed? ASAP

I am in dire need of a policy and procedure expert, more specifically who has experience in creating commercial cleaning policies that comply with green cleaning practices. I am very keen to ensure regulatory compliance but also enhance my company's efficiency by focusing on: - Cleaning products: Suggesting green cleaning products is a major objective. - Energy conservation: Developing strategies to reduce energy consumption during cleaning. - Quality control: Introducing high-performance cleaning standards and methods. - Cleaning equipment: Providing advice on eco-friendly cleaning equipment. -Handling and storage of cleaning chemicals -Effective Cleaning: Inside the building that consists of hardwood floors, carpet cleaning, r...

...reports and dashboards, primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Pow...

I am in need of a skilled individual who can create a robust and highly functional ERP system for me. This system should encompass: - Inventory Management - Sales and Purchase Management - Human Resources Management In addition to the above, I also require the system to handle Manufacturing Management, with a focus on: - Production planning and scheduling - Inventory control - Quality assurance The ideal candidate for this project will have extensive experience in system development and a comprehensive understanding of ERP systems. You should be familiar with all the mentioned functionalities and able to deliver high-quality results. Kindly note that im looking for some in Riyadh KSA

We are seeking an experienced skilled Raspberry Pi developer for an exciting machine workflow using Raspberry Pi and servo motors. The project involves developing software for control, and integrating the Modbus TCP/IP protocol. The successful candidate will demonstrate expertise in Python programming, servo control, and Modbus communication. Phase 1: Set up the Raspberry Pi 4b to control servo motors and configuring communication with the Panasonic Minas Driver and Panasonic Servo Motor. Install Modbus server software and develop custom Python scripts for Modbus communication and servo motor control. Phase 2: Control Iron Core Linear motors and configuring communication with the M...

...night for data analysis purposes. However, after trying to upload the '' file to GitHub, I encountered an error due to the file size being too large for GitHub. I need to get the Python file running again, but with the '' file stored on an external service to work around the file size limitations of GitHub. Key requirements include: - Identifying and resolving the issue causing the Python file not to run - Storing the '' file on an external service and adjusting the Python code to access it from there Ideal Skills and Experience: - Proficiency in Python - Experience with data analysis and handling large datasets - Familiarity with version control, specifically using...

...analyst to help me develop and formulate financial projections for my technology startup. The ideal freelancer for this job would have a background in finance, specifically in the technology sector. Key Requirements: - Provide detailed revenue projections: I need a breakdown of how much income is expected to be generated on a yearly basis. This should include a clear analysis of potential income streams and growth rates. - Develop expense projections: It's important to outline the costs associated with running the business. The freelancer should be able to provide a thorough examination of potential expenses, including operating costs, salaries, and other expenditures. - Create profit projections: Based on the r...

...expert to seamlessly integrate the Gemini API within my existing app. This integration needs to facilitate real-time updates on specific information. Key Project Details: - The primary focus of this integration is to enable real-time chatbot updates and basic reporting. - The API should provide up-to-date data when I request a report. - This isn't for automating trades or portfolio performance monitoring but specifically for keeping the chatbot informed with the latest updates. Ideal Skills and Experience: - Proficiency in with a proven track record of API integrations. - Deep understanding of the Gemini API and its capabilities for real-time data. - Prior experience in developing chatbots or similar interactive fe...

...Laravel Programmer to join our team and work on our B2B ecommerce website and app development. The ideal candidate will have a strong background in PHP and Laravel, with experience in building and maintaining ecommerce platforms. This is a remote position, offering the flexibility to work from anywhere. Key Responsibilities: Develop, test, and maintain high-quality ecommerce solutions using PHP, Laravel, MySQL, HTML, CSS, JavaScript, and related technologies. Collaborate with the design and product teams to implement new features and improvements. Optimize and enhance the performance of the website and app to ensure a seamless user experience. Troubleshoot and resolve...

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a...

...data. I need an expert to review and enhance it in terms of schema design and security. Key Aspects for MongoDB Schema Design Review: - **Naming Conventions**: Ensure the names of collections and fields align with established conventions. - **Data Types**: Verify that the data types are correctly assigned and appropriate for each field. - **Indexing**: Check if indexes are set up and utilized effectively. Security Measures and CIS Benchmark Review: - **Authentication and Access Control**: Validate that the authentication mechanisms and access controls are properly implemented. - **Encryption and Data Protection**: Review the existing encryption measures and data protection strategies. - **Auditi...