If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Help decipher this code PLEASE!!!

#1
August 9th 12, 06:05 PM
 Talon213 Junior Member First recorded activity by ExcelBanter: Aug 2012 Posts: 1

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
August 10th 12, 12:38 AM posted to microsoft.public.excel.worksheet.functions
 joeu2004[_2_] external usenet poster Posts: 637

"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.
> =(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

#3
August 10th 12, 07:33 AM posted to microsoft.public.excel.worksheet.functions
 Stan Brown external usenet poster Posts: 508

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
Shikata ga nai...

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post How can I modify my code to offset the defined range and repeat theprocedure instead of duplicating my code? [email protected] Excel Programming 4 May 29th 09 10:13 PM Copy a Module - Please Help me decipher the Pearson Code CMA Excel Programming 0 September 21st 07 02:52 PM Excel code convert to Access code - Concat & eliminate duplicates italia Excel Programming 1 September 12th 06 12:14 AM Please help me decipher the result of COUNT. Epinn New Users to Excel 14 August 17th 06 03:31 PM Decipher Formula Paula Excel Worksheet Functions 1 December 3rd 04 06:08 PM

All times are GMT +1. The time now is 01:02 PM.