# Minitab formulascông việc

Hi there,
I need to clean and organise some data in excle as they are really messy and afterwords i will need to calculate 2 **formulas**. Please let me know if you can help me. Thanks

I haver an excel file with 4 columns, "Campaign, Clicks, date, spend. Their is not much data (253 rows) which is data for one month.
I need the job done by 23:00 GMT 25/09/2022.
What is required is to use **formulas** in google sheets to give insight into the data, e.g derive the day of week from each date for each row of data (this can be done using the formula =switch(WEEKDAY(C3),1,"Sunday",2,"Monday",3,"Tuesday",4,"Wednesday",5, "Thursday",6,"Friday",7,"Saturday"), where C3 is the date. I want to visualize the data using the best marking visualization techniques.
THIS IS WHERE I NEED YOUR EXPERTIESE:
I am not sure of all the ways to best understand and display the data. I want to understand how to clearly id...

I need someone to teach me business statistics, especially Skewness and Kurtosis.
I am a doctorate student doing my research on the stock market and all the research papers are giving a 10-day mean return on investment along with the Skewness and Kurtosis numbers to describe the sample.
I don't understand the **formulas** or steps to calculate them.
Your task would be to read the paper and explain to me with simple examples on how those calculations are done
Since it's for my doctoral program, I am sure I will need lot more help in future hence it can be a long term project for you

I will provide you a PDF file covering cash forecast statement for 12 months [see attached file in the FILES section]
I only have the file as a pdf and NOT as an Excel File.
All you do is copy out the exact same information - Possibly add one additional line to the table i provide.
Insert into Excel
I need you to create the **formulas** so the calculations are correct AND if we edit the sheet then it recalculates and corrects all
Ideally it has to be exportable as one sheet
Simple task.
IMMEDIATE START
Probably a 2 hour task so bid carefully - Lowest bid gets the gig

correcting **formulas** and explanations of information algorithm theory

currently working on a cashflow statement project on powerbi and need assistance on a couple of **formulas** and connections setup

We are a kids product brand making natural product inspired by Old Indian **Formulas** . Looking to implement this brand positioning through redesigning our existing Text based logo, package design, website banners and product slides

Hello.. Good Morning.!!
This project is all about Finding the Best pairs and direction To trade in Forex using Fundamental and correlation Analysis.
Need someone who's expert in **formulas** as it can be derived via **formulas** itself. Not Needed to be an expert in macro, as its huge time consuming.
I Wish To give To someone who works based on project cost. Fixed.. And not on time based..
Also a proper excel guy can complete it in less than 5 hours.
But i have many projects to be lined up with.
If you're really interested in the World of trading, my projects will excite you.. Also please do apply only if you're on a pro level and also you can Work it on today..!

We need a text editor which supports the following features:
Supports HTML view on the editor
Text Formatting such as indent, bold, italic, text-align, and so on
Copy paste feature of text and images
Supports Math-Jax, Math-ml, and latex for Maths and chemical **formulas**
On paste, image upload image to server and preview those images to the editor with updated URL.
The use case of this editor is for a question about bank creation. It supports question, answer, and multiple options as editor components.
Point 5 Explanation: Whenever the end user pastes the content/OCR and convert the data into HTML-supported text, if the content contains an image, then those images should be uploaded to azure hosted (our internal server) blob storage, and that image should replace with a newly updated...

Need to create a formula to pull max monthly value and the corresponding date and hour it occurred. I have 3 and half years of historical data. Example: I need to pull the max value in columns C and E for each individual month and identify what hour (column B) and date (column A) that it occurred.
Please place **formulas** for each year into the bordered data areas columns I through AB.

I have an excel project, where I need you to create and populate some not too difficult **formulas**. Essentially you will need to match up items and assure they fall within a certain date range and make comparisons from week to week. I would imagine an expert excel user would need about 1-2 hours for this to be completed.

We are currently using Omni Form which has **formulas** to calculate hours of time worked. We need this form converted to PDF with the embedded **formulas** that are within OMNI.

We have an existing Mac Numbers Table and we need some **formulas** adding into it.
We'd have time tracking system for the time we spend doing things in the business. It needs to be able to show us at a glance how much time we spend in each of the 4 areas we have broken it down into.
We have the system up and running ok, but what we would require is a something set up that automatically tracks data and formulates it into a pie chart and sub categories for each element.
We have set up 4 key elements for the business tasks which fall under:
1) Doing
2) Delegating
3) Deciding
4) Designing
The way we enter the data is shown by the file you can click into, any task we do gets tracked and the key numbers we would need for EACH DAY would be the total time spent on each of the 4 Ds as ...

...price increaments
The plugin you can see on this page w w w build e rius . io / c p o /
And the formbuilder is applied on our site wich is not published as main site yet
on w w w new . glas maatje . nl
So we have a dutch site but with a translator for english.
Your contact person can tell you all about the needs and you have to be able to translate the needs of the mathematical **formulas** with conditional logic to the productform of every products we have and let the dynamic price of the entries of customer show up in the perfect calculated amount.
Also the looks and design need some extra. Its still looking kind of simple (its having a accordion function wich is not active now).
This will be a longlasting project with afterwards we go live published we will have m...

Hi, can you help me with coming up with MATLAB codes with regard to heat transfer in an air conditioning system? I am looking for a simple system as of now, taking into ac...with regard to heat transfer in an air conditioning system? I am looking for a simple system as of now, taking into account conductive, convective and radiative heat losses and gains. Additionally, I am looking to use finite difference method to obtain the final values. I do have very basic codes on the finite difference method, but it is extremely simplified and it does not take into account the **formulas** for the heat losses. This is a relatively long term project(the MATLAB codes is just the first part that I wish to use your services for first), so it you're able to take up this assignment, do get back to...

I am looking for an expert in excel macros and complex **formulas**

Please read attachment carefully
What I need
A script that will
- Copy the Master template sheet onto each PROJECT SHEET (**Formulas**, values, formats – but not cell E6 – this should remain as it is
- The script should ignore certain named Special sheets
- The script should lock columns A to C and K to Q in all PROJECT SHEETS
- The script can be contained in this spreadsheet or a separate one

We have a Google Sheet (2 total) and it pulls data from our CRM, Salesforce, automatically to the Google Sheet. We then need to clean up the information and add it to new rows on a new tab in the same Google Sheets file.
So two Google Sheets in total. Each Google Sheet has two ...add it to new rows on a new tab in the same Google Sheets file.
So two Google Sheets in total. Each Google Sheet has two tabs. One tab is to pull data from the CRM. The 2nd tab is cleaned up data pulled from the tab with the CRM data.
We then take that cleaned up data and use it to automatically upload to Google Ads as offline conversions.
Let me know if you have experience in Google Sheet **formulas**. That's all you'll need to work on. We'll handle getting the data to the Sheet, and then ...

Hello, I need to modify (or make a new one) an existing file excel that used to download data from Yahoo Finance and calculate some **formulas**. The file now is not working anymore, can you please fix it? In addition, I would like the file to download multiple stocks data simultaneously and then put the results of all the selected stocks in one tab only. Please see the file to understand. The data can be from Yahoo Finance or (even better) from Excel Stocks Data. Thanks

I have the following 2 x Google Sheets in the same workbook.
First sheet is used for time specific operational cell entries. After operation is completed cells are reset to zero/blank.
Second sheet is used to capture metric data from operational data in sheet 1. Data captured automatically via **formulas**. I need to retain data in second sheet even after the original has been deleted.
Need formula that would enable me to retain the data in the sheet 2 source cells even if data sheet 1 origin cells revert back to zero/blank
Is there such a formula that exists for the last point or would it be manual entry?

Need to enter data into an excel table using photos of receipts that will be provided to the successful bidder. I also need the table template to be created in a way that the total amount is visible. I also require a separate sheet to compare quotes for some items. All data will be provided. Please use **formulas** so that we can easily update the spreadsheet with more details in the future.

Looking For an Excel Expert who's familiar with Index Match / vlookup conditioning.
One who's familiar with Excel **Formulas** is Needed.
Preferable Region ~ India

Hi there!
I am looking for someone to work on my project which is a case study report on Business Forecasting. The report includes numerical (using MS Excel and **Minitab**) and written sections, with a word count of 750 words for the written section. For this report i have to use the Time Series model which uses components such as Level, Trend, Seasonal, Cyclical and Random. For more details please message me.
Thank you!

A set of **formulas** would be provided. What has to be done is code to automate predictive and descriptive analysis basically code the present situation using the formulae I give as well as run a ai to know the future position. The tool should be acceptable to attaching all formats like pdf, excel and the final outcome should be in form of dashboard.

I currently have an Excel file (with VBA) that allows me to filter data.
Calculations are then made based on the remaining data after the filters is enacted.
Currently, I need to manually input the different combinations of filters I am evaluating.
I would like to automate this process maintaining the **formulas** and calculations.
To help understand the current process, I have included a sample worksheet that includes current calculations and filters. I have also included a series of PNG files for visuals.
Current process:
1) In the “current ” file, enter parameters in (for example, cells I49 and J49). In this example, I entered “2.00” in cell I49 and “3.00” in cell J49.
Cells that correspond to those parameters are automatically filled accordingl...

Hi,
I am looking for someone who can build out some **formulas** in a google spreadsheet to help with revenue projects that will show how much revenue we will collect from projects over the next 3 years.
We must factor in, likelihood of close, project total $, date of expected close, how much revenue we will collect in 2022, 2023+.
Please see this video for a better explanation:
I think someone w the right experience can do this quickly. I need someone to start asap.
Thanks,

...trajectories of each projectile are expected to pass within a set radius of each other. This will be displayed as a statistical risk and give options to alter start times of each projectile to reduce the risk of a collision. NDAs will be required. All IP and copyright generated during and after the project will belong solely to the commissioning party (customer) in perpetuity.
Most of the calculations, **formulas** etc that the project requires are already available. However, as a non-coder I need someone to compile it together into a functioning web app that a user can access to input data and view the results.
Budget is negotiable when the full scope of works are discussed agreed. Please do not reply with a generic message as they will be ignored. English speakers only. Strictly ...

I had the above spreadsheet made up last year however the year has changed, and none of the **formulas** is working on the copied spreadsheet. I need to have all the figures across each month and end-of-year totals and actuals and differences.

...workbook
Step 2.1- The workbook calculates a lot of data and returns data
Step 3 - copy and paste that data into a new workbook
I have many days to calculate.
I want the macro to do this.
I input how many times I want to loop through the dates. It will be plus one on all three dates.
The macro - copies and pastes the orginal 3 dates to a separate sheet.
That separate sheet is loaded with **formulas** (all date dependent)
Then it pastes the results for that day into a separate sheet (or workbook)
Repeat for as many times as I chose.
I have my own VBA code that does 50 days at a time but I'd like it to do a lot more (and my code is from a macro recording).
If you can do this then get in touch.
I won't be sharing the spreadsheet as some data is protected. I can ho...

We are a craft brewery, we want to build an spreadsheet file that we can update that shows revenue by dollars, counts units sold by dollar and volume both weekly and monthly for the year and helps to project what will be needed over a 3 month span. Ideally it is something that can be updated once a week and all the numbers and **formulas** take care of the rest. The first sheet would be a YTD summary of all the sheets.

My company works with a program called ShotGrid. It can export its data into excel. however, I need **formulas** / programming written to take that data and compile it into a different output that can be used as internal project quotations that are provided to sales reps.

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

Attached is a word document that needs to be formatted in an excel spreadsheet along with **formulas**

We are upgrading our last server park project with 2 new functionalities:
-Profit calculator implementing some **formulas** explained in an Excel file
-Create a user management system

In my Power Bi project, I have several tables. 1 table corresponds to the data of 1 counter for a site over a period. There are several counters for each site.
I need to calculate energy savings. The calculations are already don...have several tables. 1 table corresponds to the data of 1 counter for a site over a period. There are several counters for each site.
I need to calculate energy savings. The calculations are already done.
It remains to be filtered.
Indeed, there is on the first page of the report:
- a map showing all the sites,
- a multiple selection filter for sites
The goal of the project is to adapt the **formulas** of the other pages according to the site(s) selected on the first page (if you click on the map or on the filter)
I think an expert will have enough time i...

have a spreed sheet that helps me when i play craps at casinos. I want to add some simple counting functions but I am limited in my excel knowledge and have been unable to figure it out. Don't think it would be too hard for an excel person wit good knowledge of **formulas**

My CFO has left and I need some help, now on Monday September 5th, for about 2 hours. We have a complex group of 15 worksheets in a workbook. Many of the **formulas** are What If's, and complex, which I am not expert as using.

...have an access database full of results from over 6 years.
I have an excel sheet that has a lot of **formulas** to analyse the data in the access database.
I would like a way of only calculating between certain dates or after certain dates. The date range FROM will be in Cell EV1 and TO will be in Cell EW1 -
There are some quite complex **formulas** - eg. countifs/countifs/counta etc.
See below - "YEARQUERY" is the data from the Accessdatabase. "DAYQUERY" is from a day I want to analyse.
=IFERROR(COUNTIFS(YEARQUERY[horse],DAYQUERY[@horse],YEARQUERY[pos],1)/COUNTIF(YEARQUERY[pos],1)/(COUNTIF(YEARQUERY[horse],DAYQUERY[@horse])/COUNTA(YEARQUERY[horse])),0)
There are other similar **formulas** using Averageifs/averageifs/averageifs
Another form...

I have some data sheets on google sheets that I am needing to have link between pages and adding in graphs along with special **formulas** to make the graphs and sheets do what I am needing them to. I need an expert to handle this. Thanks

Need some help turning equations into Excel **formulas** and/or .Net code to process some data sets for checking accuracy of amount of fluid in a tank based on fluid height and tank dimensions, and meters on fluid dispensers connected to the tank, and calculate accuracy of those dispenser meters. I can supply further details on request. Please let me know if you could do this in Excel and .Net, or just Excel (or if I need something else).

I have an existing Kotlin Android application and would like to add some new features to the existing application. The application allows the user to log pool chemical testing results. Currently there is an entry screen, ability to view entered data in a grid and export the data to CSV. The app uses a RoomDatabase. I would like to add a few features - a few calculation **formulas** based on the numbers entered and would like to add ability to write a blog / help files into the app and lastly import an existing CSV. I have detailed documentation that was used for the initial start of the project, it lists some details of the new features. Would like to discuss over chat/video the specifics. Lastly I would like to post this to the google app store and as such would like someone ...

Hi Freelancers,
I have small bits of data I need you to give me **formulas** for that I can paste into my bigger sheet.
First formula help I need relates to cells that have multiple email addresses listed out with commas separating them.
I need to make duplicate rows underneath with all the same information from other columns, but only have one email address in each row's cell, for the email address column.
Please do not apply if this requires much more explanation. I can't do certain things with my massive list unless I know how to:
(A) identify cells containing a ","
(B) number how many times "," appears in-between email addresses
(C) -I can manually make blank rows/copy and paste data underneath each row the corresponding number of times new rows a...

Necesito actualizar **formulas** para una lista de precios

So I work in marketing for a company and am analyzing survey data from our post purchase survey. I'm trying to sumifs with multiple criteria AND ranges as these ranges will update over time.
I've been able to come up with a formula that calculates this; however, it's requiring a TON of sumifs + sumifs functions, and I'...Each of these columns will continuously update over time, which would make updating my previous formula hell.
To top it off, I will be measuring the sum of revenue within a particular month.
Here is the spreadsheet I'm working on:
I feel like there has to be a way to do this with some array **formulas**, but it's hurting my head...
Thanks for any help you can provide! Travis

We are looking for someone who:
Can immediately convert a PDF file into a workable Word document.
It is a PDF file with many mathematical **formulas** and tables.
It must become a Word document in which every word in the document can be copied, selected or deleted. Everything must become text. It should not become an image after conversion.
The layout must be preserved.

I need to make a survey order delivery form. However alot of the items ordered arrive at different times. I need the status to show when its on order and also the whole line (row) to be installed. No colour when item is ordered and the whole row the yellow colour with a strikethrough to show the whole item has been ins...order delivery form. However alot of the items ordered arrive at different times. I need the status to show when its on order and also the whole line (row) to be installed. No colour when item is ordered and the whole row the yellow colour with a strikethrough to show the whole item has been installed. If possible green column to show item has been received but not installed yet.
I cant make **formulas** work correctly? Can you help and or improve?
Thank you and Kin...

I am a financial advisor. I need a spreadsheet so that I can use to make presentations. I have a copy of what I need but I do not know how to put in the **formulas**. Can you assist me?

Macros excel into csv format file creation.
For share trading order placement need to upload csv format but **formulas** disappear after saving . So whatever the file I created it will goes to save in csv format and my original excel what formula I have it will not change. I have the sample to show u in any desk