Page 2 of 4 FirstFirst 1 2 3 4 LastLast
Results 11 to 20 of 34

Thread: Sorting through and rounding data

  1. #11


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

    Quote Originally Posted by Hercules1946 View Post
    On this amended attachment, the formula in Col J caters for grams to two decimals and Lbs to one decimal. Mine starts in J4 as previous. If you need it to start in J2, then copy up from J4 to J2:J3.
    Thx for your help

  2. #12
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Glad to be of assistance

  3. #13
    Hercules,

    If you wanted to scale components up / down based on different size of receipe .....what cell would you change?

    Would it be when it calculates final receipe?.... Making 100 kilo vs 343 kilo would change components

    thx

  4. #14
    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

    making 100 kilo vs 343 kilo would change components

    thx
    You can make any changes you wish to the recipes in CusData, and these will be carried across to Workings. You can also add new customers and recipes (down to row 50 at present).
    When you say making a batch of 100 kilos vs. 343 would change components, why not just have your 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).
    Then you would only need to change your customer database if the recipe proportions were changed.

  5. #15
    Quote Originally Posted by Hercules1946 View Post
    You can make any changes you wish to the recipes in CusData, and these will be carried across to Workings. You can also add new customers and recipes (down to row 50 at present).
    When you say making a batch of 100 kilos vs. 343 would change components, why not just have your 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).
    Then you would only need to change your customer database if the recipe proportions were changed.

    Yes, I like your idea of "You can then introduce a multiplier to calculate the total component volumes for any batch size (on the workings sheet)."


    let's leave receipe @ 1 kg, then I can enter new size and let excel calculate multiplier and scale up components accordingly

    so how and what cell For the multiplier..... Can you repost spreadsheet please with multiplier sample


  6. #16
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    You can use any spare cell in the Workings sheet to enter the total batch size that your making.
    Do you think it might be better if you did the changes and reposted the sheet? Otherwise my ideas/methods may be taking you away from the desired end result, and prolonging the process.
    Also its important that you master the techniques involved so that you can drive forward the project yourself.

    The first step would be to reconstruct the recipe proportions for each customer in Cusdata tab onto a percentage basis rather than differing batch sizes such as 343 kilos. Why dont you start with that and repost the sheet.

  7. #17
    I have been traveling but will post by this weekend

  8. #18
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    OK - Look forward to hearing from you

  9. #19
    Quote Originally Posted by Hercules1946 View Post
    OK - Look forward to hearing from you
    OK take a loo , I just did a simple multiplication :-),I am hoping you will critique it with a better alterative ;-)
    Attached Files Attached Files

  10. #20
    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 am hoping you will critique it with a better alterative ;-)
    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?


    Quote Originally Posted by Omer1234 View Post
    Notice - this should be 1 lbs and 99.79 grms
    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
    Attached Files Attached Files
    Last edited by Hercules1946; 2016-05-26 at 10:34 PM.

Page 2 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
  •