Jump to content


Photo

Film Inventory template


  • Please log in to reply
No replies to this topic

#1 Gian Claudio

Gian Claudio

    New

  • Basic Members
  • Pip
  • 7 posts
  • 1st Assistant Camera
  • Rome-Italy

Posted 19 October 2007 - 04:27 PM

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
- Loaded
- Exposed
- Print
,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 (giacomini@fastwebnet.it) or by skype (mazzingazzeta)


(sorry to everybody for the probably awfull English....)
Gian Claudio
  • 0


New Pro Video - New and Used Equipment

Willys Widgets

rebotnix Technologies

Wooden Camera

Media Blackout - Custom Cables and AKS

FJS International, LLC

Metropolis Post

Broadcast Solutions Inc

Paralinx LLC

Abel Cine

CineLab

The Slider

Ritter Battery

Visual Products

Gamma Ray Digital Inc

Rig Wheels Passport

Aerial Filmworks

Technodolly

Tai Audio

CineTape

Glidecam

Rig Wheels Passport

Visual Products

Wooden Camera

Aerial Filmworks

Metropolis Post

CineLab

Abel Cine

Broadcast Solutions Inc

FJS International, LLC

Tai Audio

rebotnix Technologies

Paralinx LLC

CineTape

Media Blackout - Custom Cables and AKS

Ritter Battery

The Slider

Glidecam

Gamma Ray Digital Inc

Willys Widgets

New Pro Video - New and Used Equipment

Technodolly