Hi, I just realized a film inventory sheet on excel and I would like to know your opinion.
I tried to get everything the most "automatized" I could and I'm quite happy with the result.
It is saving me a lot of time after wrap!
The info you have to input for each roll are:
- Roll number
,together with the "previous days infos"
By itself it gets out the no print, the short end created, the short send used and the waste (that on my example is fixed to 100' or less, but it can be changed). It hilights by itself also the quantity of 1000' and 400' rolls used, taking them off from the "on hand" cell.
The only thing you must avoid is to create short ends equal to 400', as he considers those as new rolls.
The cells that don't need inputs (because they contain calculations) have been locked, so you can't erase the functions by mistake.
On my example there is a sheet for 5201, one for 5205 and one for 5218: you can write the date and day number on the first one and it copyes by itself on the other stock pages.
I would be happy if you try it and if you let me know what you think about it, if there can be improvements to get it better or if it has been only a waste of time!
I don't know why I can't attach it on this post, so if you want contact me (firstname.lastname@example.org) or by skype (mazzingazzeta)
(sorry to everybody for the probably awfull English....)
Film Inventory template
No replies to this topic