Excell formula jobs
I'm seeking a flexible skilled coder with robust experience in Pinescript and TradingView platform who can modify my existing Pinescript indicator. Key Modifications Include: - Parameter calculation changes: This includes both adjusting current indicator inputs and modifying the calculation formula to maximize the efficiency and effectiveness of the indicator. - Adding options to the settings interface to allow for customized user experience. - Based on testing, would need to accomodate any suggested changes realtime Your skills and experience in TradingView and Pinescript will be vital for the successful completion of this innovation-focused project. Your keen attention to detail and understanding of financial markets will also be advantageous.
Overview: Pilote d’Usine requires a bespoke e-commerce website built preferably using WordPress and WooCommerce. The website should be fully responsive, ensuring optimal functionality on both mobile and desktop browsers. The design and feel should resonate with motorsport themes such as Formula 1, FIA, Karting, and WEC. Key Requirements: 1. Multilingual Support: - Initially, the website must support English and French. - Scalable to accommodate up to 5 languages. 2. Editable Content: - All images and texts should be easily editable by the admin without needing developer intervention. 3. User Account and Eligibility: - Registration page for user account creation and verification based on racing license or credentials. - Verification process for eligibility to...
...& Video Ads *excludes ad cost Testimonial: Following the Pandemic our SEO, Blogs and Website were out of date and no longer ranking in Search. No one could find us! Small Business Marketing Solutions knew exactly how to target the problem. First they did all the keyword research needed to update our blogs and content. SMB also created awesome videos for our marketing and used their special formula to give us maximum visibility with every post. Using a methodical approach and small batch testing they determined which platforms we should target with our marketing spend to find our customers. I highly recommend working with Small Business Marketing Solutions. Nicole know's her stuff and is a master at research to understand all the data. Her work is still paying dividen...
Key Elements: - The banner should prominently feature the hair products. - The design should be eye-catching and attract attention. “From Struggle to Strength: Conquer Thinning, Alopecia, and Breakage Naturally “ Our products •Stimulates hair follicles for natural growth •Nourishes and strengthen hair from root to tip •Herbal formula promotes thicker, fuller hair •Reduces hair loss and breakage •Restores shine and vitality to dull, damaged hair •Free from harsh chemicals and additives •Suitable for all hair types and textures Follow us on Instagram @Mikellerosecollection Contact us (313)5597139
I am in need of an experienced freelancer who can assist in data analysis and Excel formula troubleshooting. Key Tasks: - Perform qualitative textual analysis on both textual and numeric data - Spot inconsistencies, errors and trends in the data - Troubleshoot any issues with Excel formulas and functions Ideal Skills and Experience: - Proficient in using Excel for data analysis - Exceptional skills in data interpretation and reporting - Strong problem-solving skills, specifically for Excel formulas and functions troubleshooting - Proven expertise in qualitative textual analysis.
I'm looking for a Google Sheets expert who can create formulas, automate data calculations, and provide data analysis and reporting. The successful freelancer will need to automate data input from a website or database. Ideal Skills & Experience: - Proven expertise in Google Sheets, particularly in formula creation and automation. - Experience in data analysis and reporting. - Demonstrated ability to automate data input from websites or databases. - Strong communication skills and ability to provide detailed project proposals.
I have a simple flowchart in Excel that I need converted to DrawIO format. The purp...converted to DrawIO format. The purpose of this flowchart is for internal ISO 9001 documentation , so it needs to be clear, easy to understand, and look somewhat formal, so Font style and Color scheme should be appropriately chosen. I'm looking for a freelancer with experience in graphic design, particularly flowchart creation and DrawIO, who can give this flowchart a clean, professional look. The excell file will be provided to you, so you can copy/paste the text. I do not expect you to change the content. There might be additional flowcharts in the future, so potentially repeat business. When bidding, let me know whether or not you have experience with ISO documentation drafting, which m...
We're looking for someone to help us design new style racing seat for our racing simulator. Unlike traditional racing seat which has a seat back and a seat bottom, we are looking for any creative designed to help us design a formula style racing seat. When designing the seat, we are looking to reduce the size of the packaging, so from manufacturing stand point, the seat needs to be disassembled into smaller pieces. I have attached a few example of similar seats that we're currently looking for. As for the framing, we can use either square, round tube, metal plate, and aluminum extrusion bars.
I need a detailed Microsoft Excel spreadsheet that tracks expenses related to Hurricane Ian and deducts them from my current house appraisal. Key aspects of the project: - **Expense Tracking**: The spreadsheet should offer a detailed list of expenses. These should be categorized (e.g. repairs, replacements, labor). - **Formula Integration**: It should also include formulas that automatically calculate the sum of these expenses. Ideal Candidate: - Proficient in Microsoft Excel - Experience creating detailed expense tracking sheets - Familiarity with property appraisal processes and calculations Please submit examples of similar spreadsheets you've created in the past.
...conditions. In this case, the cells should be highlighted based on containing certain text. Skills and experience required: - Proficiency in Microsoft Excel is essential. - Familiarity with conditional formatting in Excel to highlight cells. - Experience working with text-based data in Excel. - Attention to detail to ensure the correct text is highlighted. I need a quick or instant way either with a formula or conditional formatting to find where each of the values in this column are located in the bordered areas, and then highlight those specific cells. Basically I am going to a website, downloading a long list of parts with individual numbers and then need to be able to quickly search all of those numbers in my excel spreadsheet all at once and highlight those cells instead o...
I'm looking for a software that can be designed within Excel to track daily sales and present a detailed profit calculation per liter of petrol. Key Features: - Dail...detailed profit calculation per liter of petrol. Key Features: - Daily Sales Tracking: The software should enable manual entry of daily sales figures for accuracy. - Profit Calculation: The software should generate a detailed report on profit per liter of petrol sold. - Remining fuel in tank also show - calculate auto profit in the tank Ideal Skills: - Proficiency with Excel including advanced formula writing, data organization, and report generation. - Understanding of petrol pump operations and metrics. Note: While the project is to be developed in Excel, suggestions for potential future software integrati...
I'm looking to engage with a skillful Excel whiz who excels (pun intended) in a variety of Excel formulas. In particular, I need someone who has proficiency in: - Average and standard deviation for each part - Average and standard deviation parts total by invoice - Average and standard deviation trip charge - Average and standard deviation Material markup % - Average and standard deviation Hours - Average and standard deviation Installation labor - Average and standard deviation Non-installation expenses - Average and standard deviation Other fees - Average and standard deviation Freight
I'm looking for a skilled video editor to transform my less than 2 minute Formula 1 footage into a fast-paced exciting and engaging Snapchat video that includes energetic transitions, music overlay, and special effects. Key Requirements: - Expertise in video editing, particularly in a thrill cars fast-paced style. - Previous experience in editing Formula 1, race track style sports or action-related content is a plus. - Proficiency in adding music overlays and special effects to enhance the viewing experience. The final video needs to capture the essence of a Formula 1 experience - the speed, thrill, and excitement, while maintaining an engaging narrative flow. A keen eye for detail and ability to synchronize energetic transitions with the music and special effe...
I want a formula in column D of the attached spreadsheet to convert the date in column C to DD/MM/YYY
I'm looking for a Google Sheets expert who can create formulas, automate data calculations, and provide data analysis and reporting. The successful freelancer will need to automate data input from a website or database. Ideal Skills & Experience: - Proven expertise in Google Sheets, particularly in formula creation and automation. - Experience in data analysis and reporting. - Demonstrated ability to automate data input from websites or databases. - Strong communication skills and ability to provide detailed project proposals.
...monthly rental fee for equipment. The JavaScript function you develop should be able to replace the existing Excel macro that uses Goalseek. - Data Handling: The function should be designed to receive input data manually from the user. This means that the function should be able to take in data directly from the user, process it, and return the calculated rental fee. - Complexity: The current formula used in the Excel macro for calculating the rental fee is moderately complex. It involves elements such as interest rates and amortizations. The JavaScript function you create should be able to handle these complexities and produce accurate results. Ideal Skills: - Proficient in JavaScript and algorithmic problem-solving. - Experience with Excel macros and Goalseek is a plus. - St...
I need a proficient Excel specialist to provide immediate support with data analysis, automation, and formula creation. Your expertise is essential in transforming a specific data format from '111111111111' to '' in Excel. I just need for someone to show me how to do it so I can replace it in my Excel database
I'm looking for an experienced Excel expert to assist with my data analysis and formula creation tasks. - Data Analysis: I need you to help me with both statistical and financial analysis. It's essential that you are comfortable and proficient with these kinds of data analysis within Excel. - Formula Creation: You'll also be responsible for creating various formulas, particularly related to budgeting and financial forecasting. Experience in working with such data to build accurate and efficient formulas is a must. I'm looking for someone who can quickly understand the data, provide insightful analysis, and create the necessary formulas for financial tasks.
I'm looking for a graphic designer to create a trendy and eye-catching design for my t-shirt, focusing on the latest trends in car sports. The design should incorporate elements of Formula 1 racing, soccer, cricket and sports cars in a way that is stylish and appealing. Key Requirements: - Proficiency in graphic design, particularly for apparel - Understanding of the latest trends in car,sports - Ability to creatively incorporate Formula 1 racing, soccer,cricket and sports cars into a cohesive and attractive t-shirt design It's important that the design is not only visually appealing but also resonates with fans of car sports, as well as those who appreciate the latest trends in sports. Experience in designing for apparel, particularly t-shirts, will be highly val...
We need 48 picture cards. The card game involves building stories with children during therapeutic sessions. A child chooses a card from each theme and tells a story with these cards. For example the hero is a b...wicked witch Find a treasure Free a princess Heal the sick king Catching a fiery horse “Emotion” Cards (emoticon) Sad Fear Anger Unfair Worried Disgust Joy Love “The unexpected friend” cards Knight Fairy The mysterious child The good genius The good magician The golden unicorn Princess The good witch “Power” Cards A precious stone The magic potion The magic wand The flaming sword The magic formula The magic mirror The golden key The Cape “Adventure Location” cards A castle A planet An enchanted forest A cavern A ship The...
...Format" from a third party form) 1st Extension (To be Activated & Input using script as per logic) 2nd Extension (To be Activated & Input using script as per logic) 3rd Extension (To be Activated & Input using script as per logic)w Priority (fixed data coming from a third party form) Status (pending/completed) Assigned to (fixed names coming from a third party form) RATING (auto calculated using a formula) The Due Date and extension columns are in text format ("DD-MM-YYYY"). Script Functionality: The script runs daily to check each task's status and due date, comparing it with the current date. It sends data to specific webhooks if the task meets certain conditions: If "Due Date" is on or before the current date and the Status is "...
Update the changes to calculator form according to new prototype with updated formula
Looking for an experienced web developer who can take my Google Sheets table / Excel spreadsheet with the custom formula and turn it into an engaging, dynamically updatable and nicely styled website which I can embed into multiple sections of my WordPress site. Skills and Experience: - Proficient use of WordPress - Extensive experience with website development and design - Sound knowledge of Google sheets and its functionalities - The developer should be able to make the sheet customizable and allow for data updating. Please include your experience relevant to the job as part of your application. Don't worry about showcasing your past work or drafting a detailed project proposal - your background in web development and WordPress is what's most important to me. Not...
...and there is no to fix that. - Exclude non-working hours for each stage/ elapsed time. - Exclude Weekends (Friday & Saturday). - Sum up the total of elapsed times Do you have a solution that I can use the as tool either by creating excel Macro or Power BI, etc that I can use by uploading or copy paste exercise? Note // please I’m not looking for a one-time report or fixing the uploaded files Excell File attached 3 sheets (1- the exact report exported 2- report exported with expected results explained 3-Highlights) The ideal candidate should have a proven track record of working with similar projects, possess advanced skills in Power BI and Excel Macro, and be able to deliver a streamlined solution that not only automates the duration process but also can easil...
I'm in need of a proficient Excel and Word expert who can assist me with various tasks. Unfortunately, I did not specify the exact tasks nor provide a deadline for this project. However, I'm excited to review your proposal and discuss your experience in more de...discuss your experience in more detail. Please include your past work in Excel and Word with your proposal. This could be anything from template creation to complex data analysis and automation. The more detail you can provide about your past work, the better. In terms of my needs, I'll be looking for a flexible freelancer who can help out with a range of tasks. Experience in data analysis, formula creation, and automation in Excel would be particularly desirable, as would proficiency in creating and form...
...Excel for further analysis. Graphs Per Department: - **Data Points:** The graphs should focus on data from Sales, Expenses, Profit, and Number of Employees, using a rolling average approach for accuracy. - **Rolling Average Calculation:** The rolling average for the graphs should be calculated based on Manual Entered Data, per department. Additional Requirement: - **Formula Calculations:** The website should also support formula calculations for further analysis as requested by the admin. Ideal Candidate Profile: - Proficient in web development with experience in creating data-driven websites. - Familiar with graph creation and data visualization tools. - Good understanding of user access management and data exporting. - Able to implement rolling average calculations ...
I'm having a significant issue with my Google Sheet that needs sorting quickly. The main issue I'm dealing with is a formula error - when I try to make a hyperlink auto-populate after inputting a specific exercise, it just isn't working, which is causing a lot of frustration. Key Requirements: - Understands Google Sheets - Skilled in fixing formula errors - Fast turnaround time Ideal Skills and Experience: - Strong expertise in Google Sheets and formulas - Proven troubleshooting evaluation - Ability to deliver ASAP.
I am looking for someone who can help me correct some formulas and formatting errors in my Excel spreadsheet. - The spreadsheet contains Sum and Count formulas that need to be fixed. - There are also formatting errors that need to be addressed. Ideal skills: - Proficiency in Excel - Experience with formula correction - Attention to detail for formatting errors.
Need a excell sheet with a site with the total of all "contractor" that are set to the single projects. All contractors have thei own page, that u can upload a invoice who is saved on the web/sky. The single invoice that is uploaded is set by date, amount, billing nr, and are taget and subtaget with the right tag, that are selected from dropdowns. U can also leave a comment. Hi, Im interested. How long is it for you to finish this? I also wonder, how is your thoughts about the storing of the invoices/files that are uploaded. This should be on the web/sky. Also need a "scan" function, so we can compare a invoice towards a "offer from a supplier", so we can see if the price is corrext. So it needs to be possible to upload an offer/pdf that you get fro...
I am currently experiencing some issues with a Google Sheets array formula that is pulling the wrong data from columns G, H, I, and J. I need a skilled and experienced freelancer who is adept at Google Sheets formula manipulation to help me rectify this. Here is what needs to be done: - Identify why the formula is pulling incorrect data and address the issue. - Correct the array formula such that it accurately matches and places data from the correct columns. Deep understanding of array formulas and error troubleshooting in Google Sheets is a prerequisite for this project. An ability to work quickly and accurately is also key.
As an organization focused on understanding our customers better, we are in need of an Excel tool that is designed to handle customer data. Specific functions needed are: - Advanced calculation and formula functionality. You should be adept in creating and troubleshooting complex Excel formulas. - Data Visualization: Ideally, you should be skilled in creating efficient and easily interpretable Bar Graphs. This is how we'd prefer our data to be visualized. Key skills and experience: - High-level proficiency in Excel - Demonstration of designing efficient data visualizations in Excel - Ability to work with customer data effectively. A comprehensive understanding of Excel, including experience with customer data analysis, will position the chosen freelancer for success in this...
We offer an exciting 50/50 monthly revenue partnership that allows you to refer clients to our payment processing account specialists. Our unique approach involves providing your clients with a comparison formula that highlights any overbilling in their current processing statements. By setting competitive rates, we help merchants save substantial processing fees. Additionally, most merchants who opt for the new surcharge program in the USA (and recently in Canada) receive state-of-the-art equipment replacement for free. The successful referral will be a client who signs up for a POS system and payment processing services. Please provide a quote for setting up this system and indicate your experience with similar projects.
...of how the process works, from the reporting of a crime, to the eventual match/no match on the DNA database. b. Identify any conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use mean values of each parameter to construct an “average” solution. a. Unit of interest – a DNA sample collected by a CS...
Need a excell sheet with a site with the total of all "contractor" that are set to the single projects. All contractors have thei own page, that u can upload a invoice who is saved on the web/sky. The single invoice that is uploaded is set by date, amount, billing nr, and are taget and subtaget with the right tag, that are selected from dropdowns. U can also leave a comment. Hi, Im interested. How long is it for you to finish this? I also wonder, how is your thoughts about the storing of the invoices/files that are uploaded. This should be on the web/sky. Also need a "scan" function, so we can compare a invoice towards a "offer from a supplier", so we can see if the price is corrext. So it needs to be possible to upload an offer/pdf that you get fro...
...of how the process works, from the reporting of a crime, to the eventual match/no match on the DNA database. b. Identify any conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use mean values of each parameter to construct an “average” solution. a. Unit of interest – a DNA sample collected by a C...
I'm looking to collaborate with a skilled and creative designer to bring my vision to life. I'm seeking a range of custom rugby-inspired clothing that incorporates both the Autobots and Decepticons logos. Key Details: - Clothing Type: I'm interested in producing Rugby-and Or Formula 1/Auto Bots inspired clothing, including T-shirts, Hoodies, and Sweatpants. It’s for a Greek Organization. - Design Elements: I want the design to capture elements from both Rugby and Formula 1 themes. This includes incorporating elements such as team colors, racing stripes, and player numbers. - Color Scheme: The primary color scheme that I envision for this project is crimson and cream. Ideal Skills and Experience: - Strong graphic design skills with a keen ey...
More details: What specific type of data analysis do you need? Statistical analysis What information should successful freelancers include in their application? Detailed project proposals What type of statistical analysis do you require? Predictive analysis
...tournament formula. I already have a basic spreadsheet in place but I now require it to incorporate the following specifics: 1. Tournament Type: - The formula you'll create should cater to a single elimination tournament structure. 2. Participant Count: - The tournament will involve more than 20 participants. 3. Match Statistics Feature: - Additionally, I would love for the formula to be able to display detailed match statistics including results, goals, fouls and so on. The ideal candidate should have a strong understanding of Excel formulas, presumably with prior experience in creating tournament structures within spreadsheets. Familiarity with sports tournament logistics will be an additional advantage. The aim is to have a user-friendly, func...
I need a skilled Excel expert to create a comprehensive spreadsheet and optimize its formulas and functions. The project needs to be completed within a month. Key Tasks: - **Spreadsheet Creation**: The successful freelancer will be responsible for creating a detailed spreadsheet that will serve as a part search tool. - **Formula and Function Optimization**: I need assistance in optimizing the formulas and functions within the spreadsheet. This is to ensure the tool is efficient, accurate and user-friendly. I would like to have a new parts search screen made up similar to the one attached ( Storeroom Parts Locator. ) but using the attached excel sheet (inventory Report) Nice UI on front page would be great! should be able to search for description and or part number. results s...
I have an excel SS that I need some quick formula help with. No VBA please. Table with expenses, then another table dividing up. I need the expense categories divided over months as per quantaty of time it is used. Explained in the SS attached. I need this done ASAP. Your responsibilities: - Understand the project financials and structure the Excel to match - Create a Gantt style tallies that captures my project expenses effectively Skills and Experience: - Solid expertise in advanced Excel functions - Experience in financial tracking, preferably in project management - Ability to work fast and deliver quickly Note: I didn't specify the expense categories so it should be customizable to accommodate any kind of expense. However, quick delivery is of utmost priority.
I'm looking for a proficient Amazon Virtual Assistant (VA) for my UK market operations. This role is on a 70/30 investment formula, geared towards consultation only at this stage. Key Responsibilities: - Product Sourcing: Find high-quality products that align with our brand and market demands. - Order Management: Ensure smooth process from order placement to delivery. - Customer Service: Impeccable customer service to maintain high customer satisfaction levels. Required Skills & Experience: - Previous experience as an Amazon VA, particularly in the UK Market. - Proven track record in product sourcing, order management, and superior customer service. - Understanding of Amazon's guidelines and policies for the UK market. The role requires less than 10 hours a week ...
I have an Excel file that I'd like to convert to ...Implement Conditional formatting to visually highlight important information. - Custom scripts or functions to automate certain tasks and enhance the sheet's functionality. - Preserve font styles and retain cell borders from the original Excel file. - Maintain the column widths as in the original Excel file. Skills and Experience: - Proficiency in Excel and Google Sheets, including advanced formula knowledge. - Experience in implementing Data validation rules and Conditional formatting. - Familiarity with Google Apps Script to incorporate custom scripts or functions. - Attention to detail to ensure the preservation of font styles and cell borders. - Strong communication skills for clarifying any specifics or updates thr...
...degrees), and a distance (in kilometers), and then calculates the new latitude and longitude based on a rhumb line calculation. This tool will be primarily used for navigation purposes. Key Features: - Input fields for starting latitude, starting longitude, heading, and distance (all in kilometers) - Calculation of a new latitude and longitude based on the input - Utilization of the Rhumb line formula for the calculation Ideal Skills: - Advanced Excel proficiency - Understanding of geographical coordinate systems and navigation - Experience with mathematical calculations in Excel - Prior experience in developing navigation tools would be a plus This project requires an individual with a strong background in Excel, a keen eye for detail, and the ability to translate mathematica...
...into production, then moved into finished. Each time adding or subtracting from inventory or into projections. There will probably be 5 categories along with current inventory and projected This will allow us to make volume purchases using projected upcoming projects and keep tighter control on reordering material. Door / Window cut list – since our doors and windows are always a simple formula from the outside frame size. Excel can take those formulas and populate a cut list for the guys in welding. will be several parameters that will need to be inputted for each type of system. Height, width, #STL bars, right or left handed and possible a couple more 2. We will need to put in 4 types of doors along with at least 3 types of windows along with side lights and trans...
I need your help in creating an automated script or formula that can run multiple find-&-replace functions, at the same time, on an Excel spreadsheet that could regularly include 1,000 to 5,000+ records. Specifically, I will run this routine on the physical address column of data (not on the Company Name or City or State columns). In the attached .xlsx file, I would run the routine for all of a Column B. Here are the 20 specific tasks involved: 1. If a cell contains the word "Ave" or "Ave.", it should be replaced with "Avenue". 2. If a cell contains the word "Blvd" or "Blvd.", it should be replaced with "Boulevard". 3. If a cell contains the word "Ct" or "Ct.", it should be replaced with "C...
I'm in need of a highly proficient Excel specialist who will perform a series of tasks for me. Specifically, these include: - Data Analysis: Probing and evaluating a medium-size dataset (between 100-1000 rows) to derive meaningful insights. - Spreadsheet Formatting: Improving aesthetic appeal and readability of my spreadsheets. - Formula Creation: Establishing useful formulas to automate computations and functions. The entire project needs to be undertaken in Excel 2016 or later, therefore familiarity with this version is essential. Experience in data analysis and spreadsheet management is also expected. If you're an Excel whiz, I'd be eager to hear from you.
I need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...
