calculate peak value

$15-25 USD / hour

Cancelado

Publicado

hace más de 8 años

$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

ID del proyecto: 8418687

Información sobre el proyecto

27 propuestas

Proyecto remoto

Activo hace 9 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

27 freelancers están ofertando un promedio de $18 USD /hora por este trabajo

@zExcel

A proposal has not yet been provided

$25 USD en 3 días

4,9

(251 comentarios)

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 en 5 días

4,8

(291 comentarios)

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 en 3 días

5,0

(276 comentarios)

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 en 20 días

5,0

(142 comentarios)

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 en 5 días

4,9

(171 comentarios)

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 en 3 días

4,9

(116 comentarios)

6,2

@nurutrip

A proposal has not yet been provided

$15 USD en 3 días

4,9

(30 comentarios)

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 en 3 días

5,0

(65 comentarios)

5,4

@SharjeelSohail

A proposal has not yet been provided

$15 USD en 5 días

4,9

(60 comentarios)

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 en 5 días

4,6

(65 comentarios)

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 en 3 días

4,9

(27 comentarios)

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 en 5 días

4,8

(15 comentarios)

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 en 5 días

5,0

(8 comentarios)

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 en 3 días

4,9

(6 comentarios)

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 en 3 días

4,2

(5 comentarios)

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 en 2 días

5,0

(3 comentarios)

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 en 3 días