Page 3 of 4 FirstFirst 1 2 3 4 LastLast
Results 21 to 30 of 34

Thread: Sorting through and rounding data

  1. #21


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Quote Originally Posted by Hercules1946 View Post
    As I have little knowledge of your objectives in terms of functionality of the data, I do not feel comfortable criticising your efforts, or feel able to suggest alternatives.
    If there is something thats not doing what you want, I will try to resolve that if you will explain the requirement.
    By the way I did suggest the alternative of using percentages in Cusdata, and I noticed you haven't adopted that. Was it unsuitable for some reason?

    I was hoping to use you previous suggestion "customer database show the recipe mixture for (e.g.) 1 kilo (all customers)?
    You can then introduce a multiplier to calculate the total component volumes for any batch size (on the workings sheet)." So , that is what I was shooting for in my working sheet.



    In your original attachment you said that weights < = 1.5 lbs should give you grams so on that basis 553.38 grams would be correct as its only 1.22 lbs. Was this wrong, or have you changed the rules?
    If your wanting to report in mixed grams and lbs this might need a different solution along the lines in my attachment, as otherwise using text gets cumbersome as you get more complex
    ....... Ok sorry you are right, don't know why I was thinking 1 lbs. sorry

  2. #22
    [QUOTE=Hercules1946;24672]As I have little knowledge of your objectives in terms of functionality of the data, I do not feel comfortable criticising your efforts, or feel able to suggest alternatives.
    If there is something thats not doing what you want, I will try to resolve that if you will explain the requirement.
    By the way I did suggest the alternative of using percentages in Cusdata, and I noticed you haven't adopted that. Was it unsuitable for some reason?

    yes, so I was trying not to over complicate the sheet and use absolute #'s, since they are already in the custdata as crude data. It would be nice just to say what the new batch size is and leave the custdata sheet alone.

    will take a look at your attachment tonight.


    Thx for all your help

  3. #23
    Quote Originally Posted by Hercules1946 View Post
    As I have little knowledge of your objectives in terms of functionality of the data, I do not feel comfortable criticising your efforts, or feel able to suggest alternatives.
    If there is something thats not doing what you want, I will try to resolve that if you will explain the requirement.
    By the way I did suggest the alternative of using percentages in Cusdata, and I noticed you haven't adopted that. Was it unsuitable for some reason?




    In your original attachment you said that weights < = 1.5 lbs should give you grams so on that basis 553.38 grams would be correct as its only 1.22 lbs. Was this wrong, or have you changed the rules?
    If your wanting to report in mixed grams and lbs this might need a different solution along the lines in my attachment, as otherwise using text gets cumbersome as you get more complex


    I was hoping to use you previous suggestion "customer database show the recipe mixture for (e.g.) 1 kilo (all customers)?
    You can then introduce a multiplier to calculate the total component volumes for any batch size (on the workings sheet)." So , that is what I was shooting for in my working sheet.

  4. #24
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by Omer1234 View Post
    I was hoping to use you previous suggestion "customer database show the recipe mixture for (e.g.) 1 kilo (all customers)?
    You can then introduce a multiplier to calculate the total component volumes for any batch size (on the workings sheet)."
    The above is basically the "percentage" idea, which you may see as less complicated when you see it in action. It also cuts out some duplication between the two sheets.
    Have a look at this example (see attachment) and by all means discard if it doesn't work for you.
    Attached Files Attached Files

  5. #25
    Thx hercules

  6. #26
    Quote Originally Posted by Hercules1946 View Post
    The above is basically the "percentage" idea, which you may see as less complicated when you see it in action. It also cuts out some duplication between the two sheets.
    Have a look at this example (see attachment) and by all means discard if it doesn't work for you.
    Hercules,

    One question if you are still reading this thread........ When it gives me 22.5 lbs, Can we make it say 22lbs and 226.79 gms (Assuming 1lbs = 453.59 gms).. So, basically braking up the "lbs" quanity into even # of lbs and rest in grams.

    So I was thinking in our "CONV FACTOR" formula we could add another argument for further breaking up the lbs (ONLY) into LBS & GMS

    Thx

  7. #27
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by Omer1234 View Post

    We could add another argument for further breaking up the lbs (ONLY) into LBS & GMS

    Thx
    Is there some reason why you need to work with a mixture of imperial and metric in the way you're doing ? I haven't seen it before. Why can't you work with kilos and grams, or lbs and ozs?
    Also Im not sure what your own latest spreadsheet looks like, so perhaps you could incorporate your idea, and what you would do about the other affected calculations and data (eg) UOM?

  8. #28
    Quote Originally Posted by Hercules1946 View Post
    Is there some reason why you need to work with a mixture of imperial and metric in the way you're doing ? I haven't seen it before. Why can't you work with kilos and grams, or lbs and ozs?
    Also Im not sure what your own latest spreadsheet looks like, so perhaps you could incorporate your idea, and what you would do about the other affected calculations and data (eg) UOM?

    So I am looking to repeat my formulas and I thought it would be nice to have lbs in whole and then gms....... This way 22 lbs plus xx number of grams

  9. #29
    Quote Originally Posted by Hercules1946 View Post
    Is there some reason why you need to work with a mixture of imperial and metric in the way you're doing ? I haven't seen it before. Why can't you work with kilos and grams, or lbs and ozs?
    Also Im not sure what your own latest spreadsheet looks like, so perhaps you could incorporate your idea, and what you would do about the other affected calculations and data (eg) UOM?

    My current scales are in lbs and grams. So why buy a new scale :-)

  10. #30
    my latest spreadsheet is what you posted last. I am looking to repeat my formulas and I thought it would be nice to have lbs in whole & the decimal in grams from an accuracy point.

    So so I was thinking the formula where we have conv factor, maybe expand on that formula? Or are you thinking about a new formula in a new column?

    thx

Page 3 of 4 FirstFirst 1 2 3 4 LastLast

Posting Permissions

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