need help on running total

[maxofmilions]

i now use a spreadsheet object that logs batches....agg1 agg2 agg3 cement.....i would like to start out with the amount of cement in the silo say 100,000 lbs. and have a running total....each time a batch is made it subtracts that amount from the total....i also need to be able to add an amount to the total when a truckload of cement is delivered so i will always have a current  total of cement in the silo...thanks...randy

[CCONROY]

Randy,

What do you have set up and how do you track the load being mixed completion? Is it the same amount of materials each time?

How do you track and by what do you use to track a new load that arrives? Is it the same amount each time?

It is easy either way but it is important!

Cory

[maxofmilions]

i use the spreadsheet object to log the batches when they have completed weighing up......what i want is a running total of the cement....as each batch is logged to the spreadsheet i would like to subtract the cement value of that batch from my total....when a truckload of cement arrives every other day or so i will need to be able to manually enter that positive value to my total.....hope that is a little clearer....thanks..randy

[CCONROY]

Randy,

If I understand you right, The best way to do it is that you set up a push button that has a value set to it for the amount of each additive per 1/2 yd. that way as you fill a truck per yd then you would tell it you used 3 yrds.

Then when you get a delivery you use the text object to add to your total. If you send me a copy of your file I will add it in for you and send a filled out copy back. You just need to let me know what material and what supplies are used for every 1/2 yd. Then let me know how you get the meaterial in.

cconroy@ommengineering.com

[maxofmilions]

ok i apologize i am still not making my situation clear.....i have a cement silo that will hold about 130,000 lbs. of cement....we use about 70 batches of cement out of that silo a day @ roughly 500 lbs. a batch.......i store the individual batches (aggregate and cement) in v-memory locations (koyo plc) and use the spreadsheet object to log those values to a spreadsheet.....ok.....every other day or so we get a load of cement put into the silo..about 50000 lbs....now...what i want to do is keep a running total of cement....a display which will automatically subtract each of the cement batch values as they occur....and a way to manually enter the cement from the trucks when they add cement back in the silo...thanks...randy

[CCONROY]

Without seeing your running program it is hard to explain. It wqould be a series of text inputs latched by pushbuttons to add or subtract the amounts. If I could access it I could easily set it up. If you feel comfortable with that I can do it remotely. Lookout tracks every keystroke anyway. Let me know. You have my emaill address above.

Cory

[maxofmilions]

you know what you're describing still doesn't sound exactly like what i'm wanting to do.......does anyone else have any ideas......on most every redimix batch system this is a common thing to have....thanks...randy

[Bob_L]

Look into the pot object. It is just a value that can be volume, weight or whatever. The pot can have connections for value, increment, decrement, reset etc.

Events, pushbutton, timers and endless other items can be used to manipulate the value. Display is also easily done.

Bob

[maxofmillions]

thanks bob.....i know the pot object can play some part in this....the increment and decrement i can't find any value for since they are logical inputs.....the reset value is usuable because i can use another pot for that value....seems like i need something that does what an accumulator does but i need to be able to manipulate the accumulated value somehow other that reset...thanks..randy

[maxofmilions]

can lookout not do this????