Navigation
Recherche
|
How Do I Solve This Inventory Issue In Numbers?
dimanche 2 mai 2021, 01:58 , par MacMost
I just finished your Numbers course and it was great! Unfortunately, I don’t think what I’m looking for was included(probably wrong on that one). Also, i am still trying to understand the language and logic of the formulas, so that’s why I’m asking for a bit of assistance.
I hope its not too convoluted! I am trying to make a monthly inventory spreadsheet for my brewery. The front facing table (orders) will have separate pull down columns for client, beer and package (1/2 keg, 1/6 keg, case and 4 pack), with a column at the end for actual amount ordered of that particular beer and package. So an example would be: Client Beer Package Amount Brett Pilsner 1/2 keg 2 I have another table with the actual inventory. Our Beers in the header column and 3 columns for for each package (i.e. 1/2 keg Begin (for begin of month), 1/2 Keg Add (for any beer made that month) and 1/2 keg current (which would be the subtracted total of all orders pertaining to that beer and package size): BEER 1/2 Keg Begin 1/2 Keg Add 1/2 Keg Current Pilsner 10 10? That’s where my problem starts. From the Orders table, I would like the add all the order amounts of a particular beer and package size, to be added together then subtracted from the sum of the 1/2 keg begin and 1/2 keg Add. I realize this is a bit insane and understand if you cant make heads or tails of it. I tried to include screen shots here, but no go. —– Brett Blau
https://macmost.com/forum-how-do-i-solve-this-inventory-issue-in-numbers.html
|
59 sources (15 en français)
Date Actuelle
mer. 8 mai - 03:38 CEST
|