Hi all,
I need help to automate some of my files. I hope to support me on this case.
In attached file you can find template of excel. So what I need is to calculate average price with few criteria.

The new is the part of Input worksheet, from A8:J14, I would like to put the volume which client consumption and in the end to have one mixed price for client.

You can try to change the drop down menu in worksheet Input in cell C2. How works the old model I change C2, from this drop dawn menu I choose which coefficient is exactly the client. When I change in sheet Coeff come information for profile, next step is all volume is divided by 12 and start to multiply the number multiplication coefficient in each hour. then came the next step this is happens in Calc work sheet.

Thanks in advance,