calculate peak value

$15-25 USD / hour

Cancelled

Posted

over 8 years ago

$15-25 USD / hour

Hi, excel example is attached. -every row is one ID - in C;D;E we have values from-to - in G are positive and negative values, and in red the total amount my question: is it possible to somehow calculate under which circumstances the total amount in red is the possible highest, if in C;D;E it is allowed to filter one connected section for each column. so the output for example should be like this-> the highest total amount in red is reached, when C; range is from 16,2 to 22,4 D; range is -0,1 to 0,2 E; range is from 1,2 to 9,5

Algorithm

Excel

Mathematics

Project ID: 8418687

About the project

27 proposals

Remote project

Active 9 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

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

@zExcel

A proposal has not yet been provided

$25 USD in 3 days

4.9

(251 reviews)

7.6

@cugamelover

I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/

$15 USD in 5 days

4.8

(291 reviews)

7.5

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards

$22 USD in 3 days

5.0

(276 reviews)

7.1

@someka

You dont need to recruit me to finish this. Drop me a message, give me a bit time and i can complete it. It can be solved with optimization. If you get happy happy we can progress. (as i need some good references in my profile, i provide this service) I have a 5,5 years of business analyst experience in a global company and 2,5 years data scientist experience in a game company before my freelancer career. Excel is my legs and arms. I can make any reporting, formulas, pivot tables, macros etc. I am mostly online. Just drop me a message so that we can discuss further about pricing and job details. Thanks,

$20 USD in 20 days

5.0

(142 reviews)

7.1

@VolKa

Hi. I think this is possible. I can write a script in Matlab to analize this excell file and give you the answer. Regards.

$15 USD in 5 days

4.9

(171 reviews)

6.8

@dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 250 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.

$20 USD in 3 days

4.9

(116 reviews)

6.2

@nurutrip

A proposal has not yet been provided

$15 USD in 3 days

4.9

(30 reviews)

5.4

@dviruki

Dear Sir/Madam, I have 12 years experience in data analysis using Excel and VBA/macro. I have completed a number of projects on Freelancer involving algorithmic, mathematical and statistical analysis of data. I'm immediately available and will provide quick turnaround. Please contact me to discuss project details. Thank you!

$15 USD in 3 days

5.0

(65 reviews)

5.4

@SharjeelSohail

A proposal has not yet been provided

$15 USD in 5 days

4.9

(60 reviews)

5.1

@surekash7096

I have reviewed your requirement and the sample attached and will be able to do the task with accuracy. Ready to start work immediately.

$22 USD in 5 days

4.6

(65 reviews)

5.3

@gsanggara

Hello, in interesting into your project which match with my experiences. I placed bid for your consideration. I'm excel coder, with 3year+ experienced in excel coder & formulas I am very confident that i will deliver good result as per your requirement on time. Appreciate If you would like to talk thru PM before awarding this project as I'm online now. Hope to hear from you soon. Thank & Regards, gsanggara

$15 USD in 3 days

4.9

(27 reviews)

4.2

@slenders13

Dear client, I have a lot of experience with VBA and Excel. I already have in mind how I will calculate it. Send me a message for more information. total price of 125 euro. Kind regards, Rens Slenders

$25 USD in 5 days

4.8

(15 reviews)

4.4

@lalmansari

The requirement is not clear from the description. Let's have a discussion on it. -> Excellent Programmer -> 4+ years of experience in VBA programming, PDF designing and Excel Macro Development -> Will provide high quality product. -> I have a Master degree in Computer Application and kind of a workaholic.I just love working -> Good Analytical and Problem Solving Skills Happy to Help Lal

$16 USD in 5 days

5.0

(8 reviews)

3.4

@remisanonymous

Hi, I can do your calculations with VBA or create user defined formulas, because with standard formulas can be hard to achieve it. Just need some clarification. Best regards, Remis

$15 USD in 3 days

4.9

(6 reviews)

2.9

@TulyakovN

Hello. I'm understand how to do this job. Skills in math, have excellent math education. No problem with this job and those tasks from discription. Good luck and succeed in this project.

$22 USD in 3 days

4.2

(5 reviews)

2.9

@hellenski

** I HAVE COMPLETED THE TASK YOU'RE ASKING ! ** Hi, I have completed the task you're asking, and I offer you giving you the desired output with the least possible costs! Just send me a message on chat so we can talk about it.

$15 USD in 2 days

5.0

(3 reviews)

2.0

@xudonghao0323

I have done many data analyses in excel with respect to energy performance. And I have 6+ years' experiences with scripting languages such as Matlab, Python, etc. I believe I can finish the job in a short time. But I am not fully clear about the requirement yet and I need more details.

$22 USD in 3 days