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


Aerial Filmworks

FJS International, LLC

Paralinx LLC

Broadcast Solutions Inc

Abel Cine

Technodolly

CineTape

Opal

Ritter Battery

Willys Widgets

Tai Audio

Rig Wheels Passport

rebotnix Technologies

Gamma Ray Digital Inc

Wooden Camera

Visual Products

Glidecam

Media Blackout - Custom Cables and AKS

Metropolis Post

The Slider

CineLab

rebotnix Technologies

Media Blackout - Custom Cables and AKS

Abel Cine

CineTape

Willys Widgets

Technodolly

Aerial Filmworks

Tai Audio

Glidecam

FJS International, LLC

Opal

Paralinx LLC

Visual Products

Ritter Battery

The Slider

Gamma Ray Digital Inc

Metropolis Post

Wooden Camera

Rig Wheels Passport

Broadcast Solutions Inc

CineLab