+ Reply to Thread
Results 1 to 5 of 5

Pallet consumption calculator

  1. #1
    Registered User
    Join Date
    02-13-2022
    Location
    London
    MS-Off Ver
    2016
    Posts
    3

    Pallet consumption calculator

    Hi everyone,

    I hope youíll find the following riddle easy as Iím not a math genius Iíd be working on it until the end of the days.

    I have started a new role recently and at this place weíre making different mixtures that consist of various components with different bag sizes.
    Each mixture has a certain recipe we have to follow.

    I would like to work out a calculator in excel that make it possible to work out the consumption of each component by reducing with a constant weight, starting with a known pallet weight through numerous bags finally ending up with a number that is no more sufficient to create a new mixture without starting a new pallet.

    Iíll try to write it down by numbers:

    starting pallet size: 240 kg
    bag size: 20kg
    quantity needed for each mixture recipe: 33.2 kg

    So, for creating the first mixture Iíll have to take 20kg + 13.2kg of an additional bag. I will have 12.8 kg leftover for the next recipe but for this I will need a full 20kg bag plus 0.4 kg from the 3rd one, and that results of having 19.6 leftover and so on, and so onÖ

    My aim is to reduce the time wastage of my team spending on the calculations that takes ages in some cases as these mixtures are containing 20+ components sometimes.

    Iím pretty sure itís not something that was never done however Iím not that good at functions.

    Hope itíll make someone excited and helpful!

    Thanks!

  2. #2
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    2016
    Posts
    546

    Re: Pallet consumption calculator

    Hi mypszi, I hope this helps. Not exactly sure what you want since you didn't attach a sample sheet to play with, but hopefully this will at least give you some ideas going forward.

    So, the first row (first recipe) has different formulas to the rest. I put a starting "20" in C3, then D3 to N3 have the same formula.
    All the other cells have the same formula in every cell for every other recipe.

    Again, I hope this helps in some way.

    Edit: slightly changed formulas, so you can put the remaining part of pallet one into the start of pallet two.
    Edit 2: forgot to add column for remainder.
    Attached Files Attached Files
    Last edited by Beamernsw; 03-01-2022 at 04:18 AM.

  3. #3
    Registered User
    Join Date
    02-13-2022
    Location
    London
    MS-Off Ver
    2016
    Posts
    3
    Thank you, for an idea itíll do, I will upload a draft of how I imagined at the beginning.

  4. #4
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    2016
    Posts
    546

    Re: Pallet consumption calculator

    Hi, found an error. Occasionally can be an eigth recipe.



    Edit: BTW, I don't know if you can cahnged forums, but if you can, changing this post to "excel-formulas-and-functions" instead of this subgroup will probably get you many more answers.
    Attached Files Attached Files
    Last edited by Beamernsw; 03-01-2022 at 05:23 AM.

  5. #5
    Registered User
    Join Date
    02-13-2022
    Location
    London
    MS-Off Ver
    2016
    Posts
    3

    Re: Pallet consumption calculator

    Well, I am very impressed with the job you have done mate and I can tell this is a huge help already! Well done, will complete this with my thoughts once I get around excel, all the best until then!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pallet Calculator - Help needed
    By Rui Ramos in forum Excel General
    Replies: 8
    Last Post: 11-24-2021, 08:19 AM
  2. Pallet Calculator
    By Rui Ramos in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 11-22-2021, 10:24 AM
  3. Replies: 3
    Last Post: 01-23-2020, 07:24 PM
  4. Pallet Calculator - Complicated
    By iowitz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-24-2019, 03:45 AM
  5. [SOLVED] Pallet Calculator.
    By ExcelnoviceUK in forum Excel General
    Replies: 14
    Last Post: 06-13-2019, 09:55 AM
  6. Simple Pallet Calculator for Imperial
    By Jwatt888 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-25-2018, 07:16 AM
  7. Fuel Consumption Calculator
    By aman1561 in forum Excel General
    Replies: 3
    Last Post: 09-29-2015, 03:00 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1