Results 1 to 14 of 14
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    need a formula (win98)

    I am Trying to set up a spread sheet for a new small business. We grow Mushrooms. I need a formula to tell me how much was picked off each bag (ex.. 4lb. 4 1/2oz.) Daily totals and bag totals.
    thanks for any help!

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need a formula (win98)

    Hi

    Can you be just a little bit more specific as to how your business is set up? I'm afraid I don't fully understand, at this stage, how you wish Excel to be able to save you lots of time and trouble.
    Gre

  3. #3
    New Lounger
    Join Date
    Jan 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need a formula (win98)

    We have hanging bags of mushrooms. 15 in each room. When we pick the mushrooms we put them in separate containers to be wieghed. We need to keep track of each bag separatly. We also need to know the daily wieght picked from all the bags. I have been doing this long hand but I would like the excel program to add all this up. We keep the wieght to the eighth of an ounce. (ex. 4lb. 5 7/8 oz.)
    I Hope this helps you.

  4. #4
    New Lounger
    Join Date
    Jan 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need a formula (win98)

    Hi again I cant download the attachment. It just shows cant find attachment. amI doing something wrong. Sorry If I'm being stupid

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: need a formula (win98)

    There seems to be a problem, and it is nothing you are doing wrong. Please bear with us and we will try to have the problem rectified.

    Andrew C

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: need a formula (win98)

    Sorry Unka, not working.

    I uploaded a file myself but cannot access it. Seems like a glitch so we will have to ask for your patience until a fix is found.

    Andrew

  7. #7
    New Lounger
    Join Date
    Jan 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need a formula (win98)

    still not working.

  8. #8
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need a formula (win98)

    No sweat. Just goes to show how much of a rarity such a problem is! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Gre

  9. #9
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need a formula (win98)

    For the record, the numbers of the Bags were in Row 2 and the formulas I used (for Bag 2) were:

    Totals: CONCATENATE(INT(SUM(D326)/16))&" - "&TEXT(MOD(SUM(D326),16),"# ?/8")
    Averages: CONCATENATE(INT(SUM(D326)/COUNT(D326)/16)&" - "&TEXT(MOD(SUM(D326)/COUNT(D326),16),"# ?/8"))

    You may wish to wait and work off an actual spreadsheet. (BTW if you do want to be able to switch between 1/2s, 1/4s and 1/8s - for your totals and averages - all you need to do is change the 8 at the very end of each formula to a ?. It will result, however, in some of your averages turning out to be 1/3s!)

    HTH
    Gre

  10. #10
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need a formula (win98)

    As you may know, you can use the 1/8 format in Excel. I attach a sample workbook which you may want to use as a template. I chose the Fraction format "as eighths" (in case you're going to use averages). You may prefer to change it to: "up to one digit" (which lets you switch between 1/4s and 1/8s).

    As you say, the more interesting problem is delivering the results in pounds and ounces. It is proabably going to be simpler to manage things by entering your individual "picks" in ounces and only have the totals (and averages) in pounds and ounces. As you may know, when you enter the weights of your picks - say 15 7/8 - you will need to enter +15+7/8. You will see that the spreadsheet will show 15 7/8, but the formula bar at the top will show the decimal equivalent. The formulas at the bottom are a bit involved to explain. I believe they do give the correct results. You may wish simply to copy them over to where you next wish to use them.

    If you have any questions about expanding the figures, please post back.

    HTH
    Gre

  11. #11
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Ontario, Canada
    Posts
    382
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need a formula (win98)

    Unka:

    Your spreadsheet did not get uploaded properly to the server. I have deleted the reference (it is causing server errors). Can you edit this post and re-upload the mushroom.xls file.

    Sorry for the problems.
    <big><big><font color=blue>Ian</font color=blue></big></big>
    Admin

  12. #12
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need a formula (win98)

    It is working now! Sorry, I was fast asleep once Ian had sorted out the problem!
    Attached Files Attached Files
    Gre

  13. #13
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need a formula (win98)

    Here is again. If this works, I think I'll be able to tell Andrew what went wrong. <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>
    Gre

  14. #14
    New Lounger
    Join Date
    Jan 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need a formula (win98)

    THANK-YOU

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •