Excelsheet mathematical formula jobs

I need a freelancer w...between Liouville theorems and universal estimates, and then applying scaling methods and Liouville results to identify blow-up rates in model parabolic problems. Key requirements and details include: - A deep understanding of advanced mathematical concepts, particularly in Liouville theorems and universal estimates - Proficiency in applying scaling methods and Liouville results for identifying blow-up rates in parabolic problems - Ability to work independently and efficiently on this task - Excellent communication skills to discuss and explain complex mathematical concepts in a clear and concise manner. This project is perfect for a freelancer with an advanced research level mathematics background, looking to tackle a challenging and intellectually ...

I have an existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to up...advantage. Your bid should include: - Your relevant experience with VBA and AutoCAD - Any specific features you've implemented in similar projects - How you plan to approach this update and any additional functionalities you intend to add - The estimated time to complete this project About the Projects: The existing CODE to be updated, for the formula 128 the Pline drawn CCW (counterclockwise) to be shown with a negative sign before like -0.853 The Formula 900 the existing CODE to be updated so that all Pline under the same property to be calculated / added in the sum (Pline1= 2.35 Pline2=1.25 …. Pline6=3.25 so SUM = XXX) Any Quest...

I'm looking for a skilled translator to convert a German textbook on Fourier Analysis to English. It's vital that the document is translated with an intermediate understanding of mathematical terms. The final document should be in LaTeX. Requirements: - Translation: I need the remaining 332 pages of the textbook to be translated accurately and diligently. - LaTeX Editing: The translated document must be professionally formatted using LaTeX. Ideal Freelancer: - Fluent in both German and English. - Proficient in mathematical terminology. - Familiar with engineering applications of Fourier Analysis. - Experience with LaTeX. Please provide a quote for the project and its costs. I will share further details upon contact. Thank you.

Project: Bring Member, Make Money System What do we do? : We are the Official Partner of TikTok LIVE Turkey. We provide free support to the streamers working with us. This system will allow people who bring us publishers with their own referral link...that the system is mobile compatible. Poppins will be used as font. With the member in the admin role, we will be able to add members if we want, and we will check the information of the publishers added by the members and give approval / rejection. We will also write a reason when rejected. The member will be able to see this reason from their own panel. The system will calculate with a simple formula and show the earnings of that member on that publisher. Experienced people who can make this system can contact us and give us a pr...

I'm looking for a professional who can help me design a custom formula for a car shampoo. The shampoo is intended for everyday consumer use, so it should be both effective and safe for regular application. Key specifics include: - Formulation for high foaming: The shampoo should produce a rich, dense lather that enhances cleaning efficiency and user experience. - Gentle on paint: Even with its foaming capabilities, the final product must be safe and gentle on car paint to avoid any damage and ensure a long product lifespan. - Eco-friendly: The car shampoo should be completely biodegradable to align with sustainability goals and cater to environmentally-conscious consumers. The ideal candidate for this project should have a strong background in chemical formulation, particu...

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

I need assistance with radiology digital imaging and understanding/applying the exposure equation. - Tasks: - Understanding the exposure equation - Applying the exposure equation - Improve image quality Ideal Skills: - In-depth knowledge of radiology digital imaging - Strong background in mathematical equations - Experience with image analysis and processing in radiology - Proven track record of improving image quality - Familiarity with optimizing imaging protocols to enhance image quality and reduce radiation dose Please bid if you are experienced in radiology imaging and math, especially in relation to the exposure equation.

I need create calculator like on page : and implement to my page : It must be only for product in category a-typ. Formula: Width formula: Base price (always for the dimension 90x200) / 90 = value x desired width = price with VAT. Length formula: Calculated width price / 200 = value x desired length = price with VAT. here is JS for this from page dreambed. <script> function calculateCustomPrice(element) { const customPriceInput = ('js-custom-input'); let productId = , location = String() + '?productId=' + productId + '&do=calculateCustomPrice'; for (let input of customPriceInput)

I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd love to hear from you!

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

I need a cu...customized formula in an Excel spreadsheet to calculate different rates based on the day of the week. Here are my specific requirements: - The formula should apply different rates for weekdays, Saturdays, Sundays, and Public Holidays. These rates are as follows: - Weekdays: $30.10 - Saturdays: $36.12 - Sundays: $42.14 - Public Holidays: $60.20 - This calculation must be flexible and able to automatically adjust to the specific day in the date field. We will also add another box that adds11% to the total figures. Ideal Skills and Experience: - Proficiency in Microsoft Excel and its formula creation. - Experience in creating custom Excel formulas to calculate based on specific conditions. - Attention to detail to ensure the accuracy and funct...

I'm in need of a specialist in data analysis, specifically predictive analysis. The purpose of this project is to generate a sales forecast derived from publicly available data. The resulting prediction should aid in budget planning, identifying sales trends, and setting sales targets. IN NEED OF A DATA ANALYSIS PROJECT FOR PREDICTING SALES Ideal Skills and Experience: - Expe...forecast derived from publicly available data. The resulting prediction should aid in budget planning, identifying sales trends, and setting sales targets. IN NEED OF A DATA ANALYSIS PROJECT FOR PREDICTING SALES Ideal Skills and Experience: - Expertise in predictive analysis - Proficient in analyzing publicly available data - Indepth understanding of sales forecasting - Strong statistical and mathemat...

I'm seeking a mathematician to help me write up a theory focusing on algebra and geometry for publication. Key Requiremen...theory focusing on algebra and geometry for publication. Key Requirements: - Your expertise in homomorphism, structure preservation and transition within the realms of algebra and geometry. - Ability to provide a detailed explanation of the mathematical theory, including examples to aid in understanding. - Past work with a similar focus, showcasing your capabilities in this area. In your application, please provide examples of your past work in the field of algebra and geometry, along with any relevant experience you have in publishing mathematical theories. I'm looking for a highly detailed and engaging explanation of the theory that can ...

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This s...GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient solution, as the generated GUIDs will be essential for...

...profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, instead of getting 19.88%, the result I am seeing is 1987.95%. This suggests there might be an error with the data, cell formatting, or an unnoticed issue in the spreadsheet. Specific Tasks: Review the Spreadsheet: Analyze the provided Excel file to ensure all values, formulas, and cell references are correct. Identify the Issue: Determine why the formula results in 1987.95% instead of the expected 19.88%. Correct the Calculation: Fix the formula or any underlying issues to dis...

I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Pagamento ordine" and "Rimborso". Make the sum using the formula in column J "totale ordine" of the attached “esempio output” file 2- Filter the rows of input file 2 (attached), column D "Dettagli prodotto" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "dettagli prodotto”of input file column 2 are listed. (example VAT file attached) 3- The app must check th...

...one/two sure shot (can be multi) odd everyday with 1.5 odd minimum - Analyze real-time and historical stats for Football, Basketball, and CS:GO to find out possible outcome - Draw insightful inferences - Suggest betting strategies based on the analyzed odds - Provide regular reports and updates on the competitive odds in the market The ideal candidate will have an analytical mindset, strong mathematical skills, and a comprehensive understanding of the mentioned sports. Prior experience in sports/esports betting analysis is highly desirable. Proficiency in using analytical tools and software is also a plus. This job is perfect for individuals who are passionate about sports and gaming, and are excited to use their analytical skills in the continuously evolving landscape of sport...

I'm in need of a skilled Web Application Developer to create a sales incentives system that will handle complex calculations and generate comprehensive reports. Essential Features: - ...have a simple, intuitive interface for easy usage. - Reporting: The system should generate detailed reports on the sales incentives calculations. - Security: It's crucial that the application ensures the data and calculations are secure and protected. The ideal candidate should have: - Proven experience in developing web applications, particularly in sales or finance-related fields. - Strong mathematical and analytical skills. - Proficiency in programming languages suitable for web application development. - Good understanding of data security principles and best practices. - Excellent 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 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.

I'm looking for a knowledgeable individual in the field of Mathematics, specifically Graph Theory, who can efficiently and accurately rewrite my research. The primary goal here is to create a fresh version with distinct wording while preserving the important findings and messages. The main section requiring your expertise is the Methodology. I expect a comprehension of mathematical concepts and a strong proficiency in interpreting and rewriting complex research methodologies in a clear, engaging manner. Key Skills & Experience: - Proficient in English - Mathematics, specifically Graph Theory - Exceptional writing and editing skills - Experience in research re-writing. - Solid understanding of research methodologies. Please only bid if you can demonstrate your capacity t...

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.

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is req...Well-versed with dynamic loops, data extraction from images. • Work with users and team members at all levels for performance improvement and suggestions. • Understand and prepare Ad hoc reports. • Identify the opportunities of automating reports, snapshots and dashboards using advanced formulas, Advanced Excel, Python and other techniques • Consolidate, sort, organize and summarize data using basic mathematical operations • Interpret data and metrics using charts, tables, Dashboard and other graphics in Micro...

I have a substantial Excel table and I am in need of a skilled data analyst to help with correlation analysis between Column 1 to 9 of my dataset, which contains more than 4200 rows and 9 columns. Need the source file of xls with formula too Key Responsibilities: - Perform accurate correlation analysis on specified columns - Generate line graphs to visualize the correlation Ideal Skills and Experience: - Proficiency in Excel and correlation analysis - Solid understanding and experience with line graph creation - Excellent problem-solving abilities - High attention to detail I'm looking for accurate and efficient work so I can understand the relationship between my data points and act accordingly. Your experience could be the key to enhancing my project. Looking forward to se...

...scientist to create an automaton for recognising handwritten digits specifically within mathematical problems. Responsibilities: - Develop a machine learning algorithm capable of recognising handwritten digits - The primary focus will be on mathematical problems - Ensure accuracy and adaptability to various handwriting styles - Configure the algorithm to output recognized digits as digital numbers Ideal skills & experience: - Proficiency in machine learning algorithms and principles - Extensive experience with handwriting recognition software - Demonstrate capabilities in Python, TensorFlow or similar platforms - Have a deep understanding of Optical Character Recognition (OCR) - Familiarity with mathematical problems and their structures The end goal is to ...

I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formul...analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent project and I would prefer someone who can dedicate their t...

I'm looking for a data entry specialist to assist me with entering a mix of numeric, textual and formula-based data into a spreadsheet. The data will be provided in digital format, typically in CSV or Excel files. Key Responsibilities: - Accurately transcribing a mix of text, numbers, and formulas into a spreadsheet - Ensuring that the data is organized and categorized correctly - Delivering the completed spreadsheet on time, following provided guidelines Ideal Candidate: - Proficient in data entry with experience in handling diverse types of data - Familiarity with Excel and basic formulas - Detail-oriented and capable of consistently delivering accurate work - Able to work independently with minimal oversight If you have the required skills and are committed to high-quali...

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

...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 standardised operating environment for work so ideally I need a web based solution r...

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 all...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 desi...

an experienced C++ or Python or Tenserflow or Java or AI (etc.) developer to create a software program for Windows. A skilled developer with expertise in creating a dynamically pixelating images (not simple machine or grid pixelation). The program should have the following functionalities: - dynamically pixelate any imported image into mathematical, non-mathematical or custom shapes in various styles with user adjustable settings and configurations - adding additional shapes into the created shapes in separate layers to create more complex outcomes - export of the pixelated images as 300dpi vectorized or rasterized files - intuitive interactivity with user friendly adjustments, selections and editing The ideal freelancer would have extensive experience in graphic programmi...

I'm having a tough time with my powerapp project and need an expert to step in....project and need an expert to step in. There are some crucial issues that need to be fixed quickly. These include: - Data not saving properly - Difficulty in integrating external APIs - Improving formula optimization I've attempted to save multiple screens to PDF and email it, as well as search for employees in my organization but am currently failing. This work needs completion ASAP. Therefore, I am seeking a freelancer who understands powerapp projects and their workings, down to the smallest detail. Your expertise in correcting data saving issues, integration of APIs and mastery of formula optimization will be crucial to get this project completed successfully. If this is your ...

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 valu...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 ...

I'm on a search for a skilled Unity shader developer who specializes in the development shaders. I'm aiming to create special effects, particularly in the area of ultrasound echography simulation. *Task Requirements:* - Cross section of 3D model of a heart and dis... The attached file is a example of what I want to achieve Ideal skills include extensive knowledge in Unity, proficiency in shader language and a strong background in computer graphics, particularly in replicating ultrasound echography simulation. Understanding ultrasound physics and signaling will be an advantage, as well as mathematical proficiency to handle complex calculations to simulate the textures, effects and signals of an ultrasound echography.

...adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. The ideal candidate needs to have a keen ey...

...could have a profound impact on the Riemann Hypothesis. I need an academic researcher to assist me in sharing this discovery with institutions like the Clay Institute and others. Key responsibilities will include: - Approaching the Clay Institute and other mathematical institutions to showcase my research. - Compiling a detailed written report that clearly and accurately conveys the implications of my findings. - Ensuring that my research is presented in a manner that is accessible to a wide audience, especially those in the mathematical community. The ideal candidate should have: - A strong background in mathematics, particularly in prime numbers and the Riemann Hypothesis. - Experience in engaging with academic research institutions. - Excellent written communication ...

...could have a profound impact on the Riemann Hypothesis. I need an academic researcher to assist me in sharing this discovery with institutions like the Clay Institute and others. Key responsibilities will include: - Approaching the Clay Institute and other mathematical institutions to showcase my research. - Compiling a detailed written report that clearly and accurately conveys the implications of my findings. - Ensuring that my research is presented in a manner that is accessible to a wide audience, especially those in the mathematical community. The ideal candidate should have: - A strong background in mathematics, particularly in prime numbers and the Riemann Hypothesis. - Experience in engaging with academic research institutions. - Excellent written communication ...

I have a mathematical problem related to a video game that I cannot solve. I'm offering 100 dollars to anyone who comes up with a solution, and makes a simple calculator with the solution. The problem is described in this spreadsheet. Please read it before contacting me. https://docs.google.com/spreadsheets/d/1b7J3gmEsKXdg5S7edLrwDv4Xyf8yO0hpFWip2y11bOg/edit#gid=0

I'm seeking an Airtable expert to assist me with a number of tasks, including data entry and organization, building custom workflows, and creating advanced formulas. Ideal candidates should have: - Previous experience working with Airtable, including data entry and organization, workflow creation, and complex formula design - A strong understanding of how to make the most of the tool, including its integrations and automations Please note that while my exact requirements in terms of the number of tables and views in my Airtable base, as well as specific integrations I need, have not been stated, I expect the freelancer to be able to adapt to my needs and work in an agile manner.

I'm launching a project that requires the use of pycalphad, a Python library, to calculate tip velocity and the radius of the tip using Ivantsov equations. Specifically, the task invo...innate ability to adapt and figure out where and how to source the required data, I am willing to provide assistance as needed. Ideal skills and experience for this job: - Proficient in using Python, specifically the pycalphad library. - Experience with Ivantsov equations and knowledge on tip velocity/radius calculations. - Proven experience in data gathering, particularly for scientific or mathematical computations. - Quick learner who can understand and adapt to the model system for the project. I will link two documents, in the main research paper kindly refer to the marginal stability crit...

I am on the h...Demonstrated experience in this field is necessary. 2. **Create Mathematical Model**: You must also be able to develop a precise mathematical model. Background in operation research would give you a substantial edge. 3. **Outcome of the Project**: Ultimately, the effort you invest in implementing the algorithm and creating the mathematical model needs to result in the optimization of the system. The perfect candidate for this project is well-versed in wireless communication, particularly cellular technology. Practical experience in operation research, algorithm implementation, and mathematical model creation is also crucial for the success of the project. Efficient problem-solving skills, a knack for optimization, and a strong mathematical...

We are seeking a skilled developer to create a mobile app designed for performing a mathematical magic trick. The app will involve complex calculations and data handling to reverse engineer a sequence of mathematical operations based on user input, ultimately revealing specific playing cards with pre-determined ages and birth years. Key Features: User Input: Users will input a final large number and a chosen multiplier (1-10). Reverse Calculation: The app will perform reverse calculations to derive intermediate values and ultimately the user's birth year. Data Mapping: The app will map calculated results to corresponding birth years, ages, and specific playing cards. Deck Arrangement: The app will indicate the correct position of playing cards in a deck based on calcul...

I'm seeking a professional with a strong grasp of calculus at the intermediate level to aid in the completion of my IB Internal Assessment. This task involves complex problem solving and applying mathematical principles. The ideal candidate will have: - Profound understanding and experience with Calculus - Familiarity with the IB program and its requirements - An ability to explain complex mathematical processes in an understandable manner This task requires someone meticulous in the application of calculus and adaptable enough to meet the IB standards.

...right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a formula that converts their answer (in one cell) to a score (in an adjacent, hidden, cell). The second formula involves summing (adding)...

I'm encountering issues converting Excel formulas to Google Sheets, particularly with the VLOOKUP function. The problematic formula in question is central to my data analysis processes. I need a professional who can troubleshoot and effectively convert these formulas to be compatible with Google Sheets. Key Tasks: - Identify the source of the "IFERROR" error in the VLOOKUP formula as it functions in Google Sheets. - Modify the formula for accurate results in Google Sheets, ensuring it retains its original functionality post-conversion. Ideal Skills and Experience: - Proficient in both Excel and Google Sheets formulas and functions. - Strong experience with VLOOKUP and IFERROR. - Ability to troubleshoot and adapt formulas across different spreadsheet pl...

I need a mathematician to solve a number sequence and provide a formula so I can generate the next iteration of numbers as high as I can go.

I need assistance with performing formulas, calculations and descriptive analysis in Ms Excel. I am specifically focused on analyzing data using measures of central tendency - mean, median and mode. - **Tasks** - Insert and calculate f...descriptive analysis in Ms Excel. I am specifically focused on analyzing data using measures of central tendency - mean, median and mode. - **Tasks** - Insert and calculate formulas regarding the mean, median, and mode in the data. - Conduct descriptive analysis on the dataset. Ideal freelancers for this project should have strong analytical skills and extensive experience with Excel's formula and calculation functionalities as well as knowledge of statistical analysis. An understanding of central tendency measures (mean, median, mo...

Seeking a proficient individual who is knowledgeable in Excel for data entry and calculation formula tasks. The project involves: - Manual data entry - Creating complex formulas - Maintaining a spreadsheet with 10-50 columns and rows Ideal skills and qualifications: - A high degree of precision and accuracy in data entry - Strong knowledge of, and experience with, Excel and its formulas. I would like my 24 month forecast converted to an excel spreadsheet so i can adjust inputs and project further.

I'm looking for an experienced professional to create a user form macro in MS Project Professional. The macro should have t...functionality that the macro should have is the ability to filter the project based on selected criteria in the user form, including: - Project Phase: This is a custom field, or Text1 - (And) Work Phase: This is a custom field, or Text6 - (And) Custom Look-Ahead Formula's for 15, 30, & 60 day look-aheads. See attachment but the end user will select one of the three look-ahead options. For the Look-Ahead formula, it should be defined as: IIf(([Start]<([Status Date]+15, 30, or 60) And ([% Work Complete]<100))). It's extremely critical that the candidate has strong proficiency and understanding of MS Project macros, logical formulas,...