Excel IQR formulas

$2-8 USD / hour

Completed

Posted

almost 5 years ago

$2-8 USD / hour

Excel use only! no vba please. I want to get my Pivot Charts to show the following IQR By Site: Formula calculates correctly of % of active tons at that site shown in the pivot chart when I hide 0 current inventory sites. However. The first Row (Basin) is summing that number up but should be an average of those numbers. I then created a second by basin chart that works when all the 0's are present to get average % (current inventory as 0 scores 100%). But then this messes up Sum of IQR by site. I have everything I need on this current file except I want the Basin (first row of pivot) to show averages. IQR = Total active tons / total tons. I want to break it down by site active tons (BP#) and also by Basin(Column C)

Data Processing

Excel

Project ID: 19390500

About the project

6 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@haleem0786

i can do this. i have good command over Ms excel especially pivot able, charts, advance formulas, formatting, macro etc. Please inbox me and share detail. Thanks

$13 USD in 40 days

4.9

(17 reviews)

3.7

6 freelancers are bidding on average $6 USD/hour for this job

@akritisood94

I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main Skills: - Excel - VBA - Python - Web Scraping - MS Office Word, Outlook, Access, PPT Skill Set in Detail: - Office & Web Automation & Blogging on Office Tricks & tips. - Python Programming, Web Scraping - Data Scraping - Manual to Automatic updates in Excel - Excel Pivot Charts & Tables - Excel Auto Filter, Vlookup, Formula Assistance - Excel to Access - User Forms in Excel - Calendars in Excel - Bulk Files Processing in side a Folder - Folder Operations - Sending Email from Excel - Extract Data from Webpages Requesting to Contact before ordering. This would enable me to give a feasible custom offer. Please drop a message once you feel comfortable with my profile & lets get started with a feasible amount. Thanks for your time

$5 USD in 1 day

4.9

(47 reviews)

5.1

@xinglong717

Excel expert. I can all problem in excel. I have many experiences in Excel formula. Your project will be completed successfully. Thanks.

$5 USD in 40 days

5.0

(3 reviews)

2.5

@HumeraMohsin

I work towards providing reliable and 100% satisfactory services including PDF to excel/word, spread sheet creation and PowerPoint presentation. I am expert to attach pictures in Word document as well as PowerPoint presentation. I ensure 100% customer satisfaction I specialize in creating applications which are stable in fast changing client requirements. Excellent worker on data entry projects with high quality and on-time delivery.

$5 USD in 40 days