probably simple, but not for me, help please

D

darts

probably simple, but not for me, help please...

my parents have retired form the bakery, and now make product out of a
home bakey for homeless shelter at no charge. My mom wants to keep
track of everything that is made and subsequently given away. Column C
will be the stuff thats made while column D will be the give away.
What do I put in E to make it have a running balance. The dates will
vary depending on how much or how little is requested. I made a sampel
sheet to show you, and it is posted at; http://prodarts.homestead.com/bakerygiveawaysheet.html

thanks in advance for al your help
 
D

darts

You need to explain further.  Do you want a grand total running
balance regardless of the product made?  For instance you made bread,
cake, and cookies in different quantities and gave away different
quantities.  Do you want the running total in Column E to be the total
of all remaining product that is left in inventory (total of all
cakes, cookies etc. that remain in inventory) , or do you simply want
the balance remaining for each individual line item (125 pies made
less 50 given away = 75 pies left)?

Clarify and we can respond.
Click to expand...

yes I want a running total, but keep in mind that the in and the out
values will/may be on different dates or seperat lines on the sheet
 
D

darts

yes I want a running total, but keep in mind that the in and the out
values will/may be on different dates or seperat lines on the sheet- Hide quoted text -

- Show quoted text -
Click to expand...

It is actually a freezer inventory, and if they keep good records they
will then know when it is time to make more product.The freezer allows
them to stock up, and the hostiles can withdraw as need be.
 
D

darts

If you want to keep a running total of each remaining product (i.e. 50
cookies, 10 pies, etc.) then this needs to be reconfigured.  Let me
know.  The formula I just sent you simply counts total remaining
product, all product added up.- Hide quoted text -

- Show quoted text -
Click to expand...


SORRY, I AM PROBABLY NOT EXPLAINING WELL ENOUGH. HERE IS MY MOM'S
ACTUAL SHEET WHICH I PRINTED TO A PDF SO THE COLUMN NUMBERS WOULD SHOW
UP. NOW "B" REPRESENTS PRODUCT MADE AND PUT INTO THE FREEZER, WHILE
"D' REPRESENTS WITHDRAWALS FROM THE FREEZER, AND "F" IS SUPPOSED TO
SHOW WHAT THE RUNNING BALANCE IN THE FREEZER IS. THANKS AGAIN!
http://prodarts.homestead.com/FREEZER_INVERTORY.pdf
 
D

darts

If you want to keep a running total of each remaining product (i.e. 50
cookies, 10 pies, etc.) then this needs to be reconfigured.  Let me
know.  The formula I just sent you simply counts total remaining
product, all product added up.- Hide quoted text -

- Show quoted text -
Click to expand...

I BELIEVE IT'S JUST FOR ONE PRODUCT (WHOLE WHEAT LOAVES OF BREAD), AND
IF IT TURNS OUT TO BE OTHERS THEY COULD ALWAYS DO A SEPERATE SPREAD
SHEET FOR EACH PRODUCT.
 
D

darts

If I understand then, you simply start the first Balance cell (i.e.
E1) with a formula =sum(c1-d1).

Then for the next line, write something like this: =SUM(E1+C2-D2).
This will add the total above it to the difference of what was made or
given away on that line, whether or not you have a made or donated
entry on that line.  It won't matter.

You just copy this formula down the column E for every line with an
entry.

Does that meet your needs?- Hide quoted text -

- Show quoted text -
Click to expand...

C1-D1 WOULD WORK IF THEY BOTH HAPPENED ON THE SAME ROW (OR SAME DATE),
BUT THIS WILL PROBABLY BE FAIRLY RARE. THEY LOAD THE FREEZER (20' X
20' X 8'), AND THEN THE HOSTILES/SHELTERS COME GET WHAT THEY NEED
 
D

darts

It will not matter if you enter in and out on the same row.  Try my
suggestion and you should see that it will work.  Any line can have an
in or out or both.- Hide quoted text -

- Show quoted text -
Click to expand...

FANTASTIC,.. THAT'S EXACTLY WHAT WE WERE LOOKING TO DO. THANKS AGAIN!
 
Top