[mso] Re: Excel Formula

  • From: "David Smart" <smartware@xxxxxxxxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Fri, 23 Jun 2006 21:31:20 +1000

Yes, by all means send it to me.  smartware at optusnet.com.au 
just replace the " at " with an @



Regards, Dave S

----- Original Message ----- 
From: "Chuck Hawsey" <chawsey@xxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Friday, June 23, 2006 1:43 PM
Subject: [mso] Re: Excel Formula


> Dave,
> Thank you so much for your assistance. I added a slight variation to your 
> formula and it appeared to be working just great. However, I ran into a 
> problem. It seems like, if I have a lot of downtime, it messed up the 
> number. I've put together a small spreadsheet and I was wondering if I 
> could send it to  you to look at, as that would be a heck of a lot simpler 
> than trying to explain the whole thing. I know I can't attach on this 
> list, so could I possible send it to your private email? I don't mind at 
> all if you share the results. Again, thanks for your help.
> Chuck H.
>
> This email and any attachments have been scanned by Norton AV Version 
> 11.0.16.2
>  ----- Original Message ----- 
>  From: David Smart
>  To: mso@xxxxxxxxxxxxx
>  Sent: Wednesday, June 21, 2006 11:23 PM
>  Subject: [mso] Re: Excel Formula
>
>
>  Let's work on Row 2:
>
>  In E2:
>
>    =D2*450/B2
>
>  Now that will give you a non-integer number of calls (e.g. in your case, 
> the
>  result is 14.516129).  You can round to the nearest integer:
>
>    =ROUND(D2*450/B2,0)
>
>  or truncate the fractional part off completely
>
>    =ROUNDDOWN(D2*450/B2,0)
>    =INT(D2*450/B2)
>
>  (these two truncation formulae are essentially the same in this case).
>
>  You haven't mentioned whether you want the credits included.  The fairest
>  method that I can see would be:
>
>    adjust calls by 450 / minutes worked, leave fractional part in
>    add downtime / 32, leave fractional part in
>    then round the result up or down to the nearest integer.
>
>    =ROUND(D2*450/B2+C2/32,0)
>
>
>  Regards, Dave S
>
>  ----- Original Message ----- 
>  From: "Chuck Hawsey" <chawsey@xxxxxxxxxxx>
>  To: <mso@xxxxxxxxxxxxx>
>  Sent: Thursday, June 22, 2006 10:50 AM
>  Subject: [mso] Excel Formula
>
>
>  > Well, here I am with need of a formula that - hopefully - is at least a
>  > little harder than the last one I asked!  I'm not sure how to describe
>  > what I need, so let me try this:
>  > A.               B                        C                        D
>  > E
>  > Name    minutes worked    downtime        actual calls made
>  > adjusted # of calls
>  >
>  >
>  > A is self explanatory
>  > B contains the number of minutes worked - usually 450, but it can vary
>  > greatly
>  > C contains a manually entered number of minutes a person spent on
>  > miscellaneous items. For each 32 minutes, he/she gets credit for one
>  > adjusted call.
>  > D contains a manually entered number of actual calls made by that 
> person
>  > during the minutes he/she worked
>  > E contains a formula that presently adds the number in D to C divided 
> by
>  > 32
>  >
>  > Here's my problem. If B contains a number other than 450, I want E to
>  > represent the number of adjusted calls he/she would have had if he/she 
> had
>  > actually worked 450 minutes.  In other works, I'm looking for a formula
>  > like a ratio, for example, if B contained 248 minutes worked and D
>  > contained 8 calls, then I need the number if E to be what it would have
>  > been if B had contained 450 minutes worked.
>  >
>  > Gosh, I hope this makes sense, as I find it hard to explain and even
>  > harder to come ;up with a formula. Any assistance will be greatly
>  > appreciated. If anyone needs more information or needs the actual 
> present
>  > spreadsheet, I will be happy to provide it.
>  >
>  >
>  >
>  > Chuck H.
>  >
>  > This email and any attachments have been scanned by Norton AV Version
>  > 11.0.16.2
>  > *************************************************************
>  > You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx 
> or
>  > MicrosoftOffice@xxxxxxxxxxxxxxxx
>  >
>  > To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>  >
>  > To Unsubscribe from this group, visit the group's homepage and use the
>  > dropdown menu at the top.  This will allow you to unsubscribe your 
> email
>  > address or change your email settings to digest or vacation (no mail).
>  > //www.freelists.org/webpage/mso
>  >
>  > To be able to use the files section for sharing files with the group, 
> send
>  > a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
>  > invitation with instructions.  Once you are a member of the files 
> group,
>  > you can go here to upload/download files:
>  > http://www.smartgroups.com/vault/msofiles
>  >
>  > If you are using Outlook and you see a lot of unnecessary code in your
>  > email messages, read these instructions that explain why and how to fix
>  > it:
>  > http://personal-computer-tutor.com/abc3/v28/greg28.htm
>  > *************************************************************
>
>  *************************************************************
>  You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx 
> or MicrosoftOffice@xxxxxxxxxxxxxxxx
>
>  To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
>  To Unsubscribe from this group, visit the group's homepage and use the 
> dropdown menu at the top.  This will allow you to unsubscribe your email 
> address or change your email settings to digest or vacation (no mail).
>  //www.freelists.org/webpage/mso
>
>  To be able to use the files section for sharing files with the group, 
> send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an 
> invitation with instructions.  Once you are a member of the files group, 
> you can go here to upload/download files:
>  http://www.smartgroups.com/vault/msofiles
>
>  If you are using Outlook and you see a lot of unnecessary code in your 
> email messages, read these instructions that explain why and how to fix 
> it:
>  http://personal-computer-tutor.com/abc3/v28/greg28.htm
>  *************************************************************
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the 
> dropdown menu at the top.  This will allow you to unsubscribe your email 
> address or change your email settings to digest or vacation (no mail).
> //www.freelists.org/webpage/mso
>
> To be able to use the files section for sharing files with the group, send 
> a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an 
> invitation with instructions.  Once you are a member of the files group, 
> you can go here to upload/download files:
> http://www.smartgroups.com/vault/msofiles
>
> If you are using Outlook and you see a lot of unnecessary code in your 
> email messages, read these instructions that explain why and how to fix 
> it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> ************************************************************* 

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: