The above Ad will no longer appear after you Sign Up for Free!

Found a cool photometrice spreadsheet.

Discussion in 'Lighting and Electrics' started by gafftaper, Jul 24, 2007.

  1. gafftaper

    gafftaper Senior Team Senior Team Fight Leukemia

    Messages:
    12,468
    Likes Received:
    2,456
    Occupation:
    Theater Manager & T.D.
    Location:
    Seattle, Washington
    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.
     
  2. Grog12

    Grog12 CBMod CB Mods Premium Member

    Messages:
    2,615
    Likes Received:
    172
    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.
     
  3. gafftaper

    gafftaper Senior Team Senior Team Fight Leukemia

    Messages:
    12,468
    Likes Received:
    2,456
    Occupation:
    Theater Manager & T.D.
    Location:
    Seattle, Washington
    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.
     
  4. jwl868

    jwl868 Active Member

    Messages:
    697
    Likes Received:
    47
    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
     
  5. Grog12

    Grog12 CBMod CB Mods Premium Member

    Messages:
    2,615
    Likes Received:
    172
    Location:
    Denver, CO
    Bah....genius!
     
  6. icewolf08

    icewolf08 CBMod CB Mods

    Messages:
    4,061
    Likes Received:
    655
    Occupation:
    Controls Technician - TAIT Towers
    Location:
    Lititz, PA
    Looks, cool, nice that it is free, but I don't think it wold replace my copy of the Photometrics Handbook.
     
  7. Grog12

    Grog12 CBMod CB Mods Premium Member

    Messages:
    2,615
    Likes Received:
    172
    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.
     
  8. gafftaper

    gafftaper Senior Team Senior Team Fight Leukemia

    Messages:
    12,468
    Likes Received:
    2,456
    Occupation:
    Theater Manager & T.D.
    Location:
    Seattle, Washington
    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.
     
  9. Van

    Van CBMod CB Mods Premium Member

    Messages:
    5,779
    Likes Received:
    1,077
    Occupation:
    Project Manager, Stagecraft Industries, Inc.
    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.
     
  10. gafftaper

    gafftaper Senior Team Senior Team Fight Leukemia

    Messages:
    12,468
    Likes Received:
    2,456
    Occupation:
    Theater Manager & T.D.
    Location:
    Seattle, Washington
    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.
     
  11. gafftaper

    gafftaper Senior Team Senior Team Fight Leukemia

    Messages:
    12,468
    Likes Received:
    2,456
    Occupation:
    Theater Manager & T.D.
    Location:
    Seattle, Washington
    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: Sep 21, 2007
  12. derekleffew

    derekleffew Resident Curmudgeon Senior Team Premium Member

    Messages:
    4,378
    Likes Received:
    2,755
    Location:
    Las Vegas, NV, USA
  13. gafftaper

    gafftaper Senior Team Senior Team Fight Leukemia

    Messages:
    12,468
    Likes Received:
    2,456
    Occupation:
    Theater Manager & T.D.
    Location:
    Seattle, Washington
    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: Sep 21, 2007
  14. derekleffew

    derekleffew Resident Curmudgeon Senior Team Premium Member

    Messages:
    4,378
    Likes Received:
    2,755
    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: Mar 23, 2008
  15. gafftaper

    gafftaper Senior Team Senior Team Fight Leukemia

    Messages:
    12,468
    Likes Received:
    2,456
    Occupation:
    Theater Manager & T.D.
    Location:
    Seattle, Washington
    Thanks Derek That's perfect. I'm very happy now. :mrgreen:
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice