Found a cool photometrice spreadsheet.

gafftaper

Senior Team
Senior Team
Fight Leukemia
Joined
Jan 2, 2006
Location
Seattle, WA
Hey I found this cool photometric spreadsheet. It comes from a university of Hawaii website. Don't know if it was put together by a student or what... Google has no information other than the sheet. Anyway it would be a really useful tool but the recalculating part doesn't seem to work. Anybody who knows their Excel want to try to figure out what's wrong? I can create a simple spreadsheet but fixing this one is over my head.
 

Grog12

CBMod
CB Mods
Premium Member
Joined
Nov 2, 2006
Location
Denver, CO
For some reason its not referencing the input data page...I'm not sure it was meant to be a recalculating spreadsheat...But you know this wouldn't be too hard to put together.

When I get a spare moment..(i.e. after my wedding) I'll see if I can't put something together.
 

gafftaper

Senior Team
Senior Team
Fight Leukemia
Joined
Jan 2, 2006
Location
Seattle, WA
For some reason its not referencing the input data page...I'm not sure it was meant to be a recalculating spreadsheat...But you know this wouldn't be too hard to put together.
When I get a spare moment..(i.e. after my wedding) I'll see if I can't put something together.
The data's all there and it LOOKS like it's supposed to reference the Data page... but it doesn't. I tried erasing the formula to go to the data page and get the throw distance and replace it with the same formula it does it... but it doesn't change any of the other calculations. That's about the limit of my Excel expertise.
 

jwl868

Active Member
Joined
Aug 31, 2004
Location
Pittsburgh, PA
Go to the Data Input Sheet and change the values in the purple fields.

Then go back to the Calculator sheet and press the F9 key. (F9 recalculates and formulas that don't automatically change.)

Joe
 

Grog12

CBMod
CB Mods
Premium Member
Joined
Nov 2, 2006
Location
Denver, CO
Bah....genius!
 

icewolf08

CBMod
CB Mods
Joined
Jan 11, 2007
Location
Lititz, PA
Looks, cool, nice that it is free, but I don't think it wold replace my copy of the Photometrics Handbook.
 

Grog12

CBMod
CB Mods
Premium Member
Joined
Nov 2, 2006
Location
Denver, CO
I'm thinking of using it as a base model and adapting it to something a little more universal. Taking info out of my Photometric Handbook and my Pilsboro book and using it to put together a quick reference sheet.
 

gafftaper

Senior Team
Senior Team
Fight Leukemia
Joined
Jan 2, 2006
Location
Seattle, WA
The cool thing would be to have a spreadsheet for just your inventory. Who... besides Ship... deals with every instrument in the book? Most of us only have a half a dozen options that we deal with regularly . How cool to have them all on a quick spreadsheet that handles all your calculations.
 

Van

CBMod
CB Mods
Premium Member
Joined
Jul 27, 2006
Location
Portland, Or.
Hey, I just got a copy of "Stage Directions" in my in box today. It was addressed to the managing Director but she gave it to me. Anyway there is a neat little article about using a photo metrics table. Given the nature of another current thread I thought it might be interesting if I could contact the publishers about re-printing the article here. I let y'all know what I find out.
 

gafftaper

Senior Team
Senior Team
Fight Leukemia
Joined
Jan 2, 2006
Location
Seattle, WA
I Just read the article and it's excellent. I'm planning on keeping it for teaching purposes in the future. S.D. usually posts most of the articles on their website for free. Unfortunately their website is still showing the June issue as the "current" issue. So I have the feeling it'll be available once their webmaster gets back from vacation.
 

gafftaper

Senior Team
Senior Team
Fight Leukemia
Joined
Jan 2, 2006
Location
Seattle, WA
Stage Directions has been behind on updating their website. This is the link to the article Van mentioned called "Photometrics 101" it's a good article for those just starting out learning lighting design.

EDIT: Sadly the original photometric spreadsheet link from this thread is dead. The original spreadsheet appears to be something that ETC created a while ago so I'm not sure how legal it is for us to post it here. I'll PM our ETC friend and ask about it.
 
Last edited:

gafftaper

Senior Team
Senior Team
Fight Leukemia
Joined
Jan 2, 2006
Location
Seattle, WA
Thanks Derek it's very cool. We should see if we can get your spreadsheet permanently placed in the Wiki on the CB server.

How much work would it be to add 575X and 750x lamps? Many (if not most) of us in the educational world live on the Long Life side?
 
Last edited:

derekleffew

Resident Curmudgeon
Senior Team
Premium Member
Joined
Aug 21, 2007
Location
Las Vegas, NV, USA
Okay, Gaff, for you, anything. But no 375w, 77v, or non-US lamps, please. Or else I'll have to rewrite the sheet and make you choose the lamp from a list every time.

Let's see if I was able to zip this and attach it properly.

If not, here is the link to my site:
http://www.derekleffew.com/Conv_Photometrics_v4.xls.zip

Anyone have any helpful ideas/requests?
 
Last edited: