Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help decipher this code PLEASE!!!
Hi All,
So I'm new to this forum, but it looks really helpfull. I am pretty good at excel, not awesome but I get by. However i am working with a sheet that someone eles has set up and i'm having issues figuring out something. So I am hoping and crossing my fingers that someone can explain this formula to me in layman's terms, I need to adjust it, but have to know what it means first lol. HELP PLEASE!!! =(C6/(C3*9)) * 1.05 this is supposed to help calculate how many employees we need to meet our work load based on utilization and effenciency. Laborers Needed @ 90% Utilization (includes 6% PTO). |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help decipher this code PLEASE!!!
"Talon213" wrote:
I am hoping and crossing my fingers that someone can explain this formula to me in layman's terms, I need to adjust it, but have to know what it means first lol. HELP PLEASE!!! =(C6/(C3*9)) * 1.05 this is supposed to help calculate how many employees we need to meet our work load based on utilization and effenciency. Laborers Needed @ 90% Utilization (includes 6% PTO). Well, you don't make it easy by not telling us what is in C6 and C3, and what those values represent. Presumably, C6/C3 is the number of laborers at 100% utilization and no PTO. Then, C6/C3/0.9 -- which can be written C6/(C3*0.9) -- would be the number of laborers at 90% utilization. I can only assume that was written effectively C6/C3/9 (9 instead 0.9) because C6 is scaled by 10 or C3 is scaled by 1/10. That is, C6/C3 is 10 times the actual number of laborers at 100% for some reason(!). (Alternatively, either the original formula is correct, or you miswrote it here and "*9" is really "*0.9" or "*90%".0 Then, C6/C3/9 * 1.05 -- which can be written (C6/(C3*9))*1.05 -- would account for the PTO. However, I quibble with the number. I wonder if 1.05 is rounded and based on PTO at 4.31% to 5.21%. For 6%, the PTO factor would be 1/(1-6%), which is about 1.063830. (Rounding intermediate values is a bad idea. It introduces quantization errors.) In summary, this is how I would write the formula, assuming A1 is the %utilization (written 0.9 or 90%) and A2 is the %PTO (written 0.06 or 6%): =ROUND(C6/C3/10/A1/(1-A2),0) Rounding of some form is prudent. After all, you cannot hire 12.3 people ;-). It might be prudent use ROUNDUP instead of ROUND. That's a judgment call, balancing potentially increased labor costs (due to ROUNDUP) v. understaffing (due to ROUND down 50% of the time). Again, I throw "/10" into this because it appears that C6/C3 is 10 times the number of laborers. I would prefer not to need that; that is, I would prefer that C6/C3 is the actual number of laborers. Does that help? If you have any doubts, please include the data that you neglected to mention in your next posting. That is: what is in C6; what is in C3; what do those values represent; and copy-and-paste the formula into your posting instead of retyping it to avoid any misleading typos. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help decipher this code PLEASE!!!
On Thu, 9 Aug 2012 17:05:29 +0000, Talon213 wrote:
Hi All, So I'm new to this forum, but it looks really helpfull. I am pretty good at excel, not awesome but I get by. However i am working with a sheet that someone eles has set up and i'm having issues figuring out something. So I am hoping and crossing my fingers that someone can explain this formula to me in layman's terms, I need to adjust it, but have to know what it means first lol. HELP PLEASE!!! =(C6/(C3*9)) * 1.05 I don't think you quoted the actual formula, but what you write means "multiply C3 by 9, divide C6 by that result, and then multiply by 1.05". -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I modify my code to offset the defined range and repeat theprocedure instead of duplicating my code? | Excel Programming | |||
Copy a Module - Please Help me decipher the Pearson Code | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
Please help me decipher the result of COUNT. | New Users to Excel | |||
Decipher Formula | Excel Worksheet Functions |