Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Not sure I'm doing this right and need confirmation, please. Looking to find
a target to reduce a metric by a % for 2009 using 2007 and 2008 data. Example: Production tonnage 2007=400,000, and production tonnage 2008=425,000; water tonnage consumed during production for 2007=200,000 tons, and 2008=210,000. Then percent of production tonnage vs tons of water used for 2007 was .5 and for 2008 was .494. SO is it correct that the reduction of the percentage for prod vs water consumption from 2007 vs 2008 is 1.176%.???? Thanks so much for confirming/correcting this for me! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In my view ...
Reduction in percentage of Water consumed per Production Tonnage = 0.006 Percentage reduction in Water consumed per Production Tonnage = 1.2% In other words your target for 2009 should by 0.488 Tons of water per Production Ton. Hope this makes sense. "Jani" wrote: Not sure I'm doing this right and need confirmation, please. Looking to find a target to reduce a metric by a % for 2009 using 2007 and 2008 data. Example: Production tonnage 2007=400,000, and production tonnage 2008=425,000; water tonnage consumed during production for 2007=200,000 tons, and 2008=210,000. Then percent of production tonnage vs tons of water used for 2007 was .5 and for 2008 was .494. SO is it correct that the reduction of the percentage for prod vs water consumption from 2007 vs 2008 is 1.176%.???? Thanks so much for confirming/correcting this for me! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sheelo - never mind my request for figuring the 0.488 - I got it (duh).
"Sheeloo" wrote: In my view ... Reduction in percentage of Water consumed per Production Tonnage = 0.006 Percentage reduction in Water consumed per Production Tonnage = 1.2% In other words your target for 2009 should by 0.488 Tons of water per Production Ton. Hope this makes sense. "Jani" wrote: Not sure I'm doing this right and need confirmation, please. Looking to find a target to reduce a metric by a % for 2009 using 2007 and 2008 data. Example: Production tonnage 2007=400,000, and production tonnage 2008=425,000; water tonnage consumed during production for 2007=200,000 tons, and 2008=210,000. Then percent of production tonnage vs tons of water used for 2007 was .5 and for 2008 was .494. SO is it correct that the reduction of the percentage for prod vs water consumption from 2007 vs 2008 is 1.176%.???? Thanks so much for confirming/correcting this for me! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
target.value | Excel Discussion (Misc queries) | |||
Target | Excel Worksheet Functions | |||
How do I calculate the final pmt required to meet a target IRR? | Excel Worksheet Functions | |||
Calculate running target by days in the month | Excel Worksheet Functions |