{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Calc","EVs","Scenes","Shutters","BGdata"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calc","index":0,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[24,0,24,2],[0,3,28,3],[25,1,25,2],[27,1,27,2],[28,1,28,2],[26,1,26,2],[8,0,8,2],[10,0,10,2],[5,1,5,2],[9,1,9,2],[7,1,7,2],[29,0,29,3],[11,1,11,2],[22,1,22,2],[23,1,23,2],[2,0,2,2],[14,1,14,2],[21,1,21,2],[17,1,17,2],[16,0,16,2],[20,0,20,2],[15,1,15,2],[19,1,19,2],[12,0,13,2],[4,0,4,2],[6,0,6,2],[3,1,3,2]]}
["Select scene:","Scene EV:","Used/Manual EV:"]
["Las Vegas or Times Square at night. Store windows. Campfires, bonfires, burning buildings. Ice shows, football, baseball etc. at night. Interiors with bright florescent lights.",{"$f":"VLOOKUP(A2,Scenes!B1:C30,2,FALSE)","v":8},6]
[]
["Select sensitivity (ISO):",200]
[]
["Aperture or Shutter speed?","Aperture"]
[]
["Select Aperture size (A mode only):","f/2"]
[]
["Select Shutter speed (S mode only):","1/30 sec "]
[]
["Result:","1/30 sec "]
[]
[]
["Shutter Speed Selector:","Faster for faster moving objects."]
["Lowest possible speed you can shoot with out a tripod but try to avoid movement. This setting picks up the ambient light.",{"$f":"VLOOKUP(A16,Shutters!A1:B13,2,FALSE)","v":30}]
[]
["Aperture Calculator:","(Fnear+Ffar)/2"]
["What depth of field do you want? (Sharpness limits)",0.5,3]
["Required aperture size:",{"$f":"(B19+C19)/2","v":1.75}]
[]
["Tripod usage Calculator","If Focal Length < Shutter Speed then YES."]
["Focal length:",50]
["Is Tripod advised for selected Shutter-speed Scene?",{"$f":"IF(B16<B23,\"YES\",\"NO\")","v":"YES"}]
[]
["Field of View Calculator","α = (180δ)/(πf)"]
["Focal length:",50]
["Media size:",35]
["Field of View degrees:",{"$f":"(180*B28)/(PI()*B27)","v":40.107045659157627}]

{"sheet":"EVs","index":1,"n_rows":25,"n_cols":21,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,8],[0,10,0,20],[1,20,24,20],[2,0,24,0]]}
["FILM SPEED (ISO/ASA NUMBER)",null,null,null,null,null,null,null,null,null,"APERTURE OF LENS (f/STOP)"]
[null,"ISO 25","ISO 50","ISO 100","ISO 200","ISO 400","ISO 800","ISO 1600","ISO 3200",null,"f/1.4","f/2","f/2.8","f/4","f/5.6","f/8","f/11","f/16","f/22","f/32","SHUTTER SPEEDS"]
["EV NUMBERS",1,0,-1,-2,-3,-4,-5,-6,null,"4 sec ","8 sec ","15 sec ","30 sec ","1 min ","2 min ","4 min ","8 min ","16 min ","32 min "]
[null,2,1,0,-1,-2,-3,-4,-5,null,"2 sec ","4 sec ","8 sec ","15 sec ","30 sec ","1 min ","2 min ","4 min ","8 min ","16 min "]
[null,3,2,1,0,-1,-2,-3,-4,null,"1 sec ","2 sec ","4 sec ","8 sec ","15 sec ","30 sec ","1 min ","2 min ","4 min ","8 min "]
[null,4,3,2,1,0,-1,-2,-3,null,"1/2 sec ","1 sec ","2 sec ","4 sec ","8 sec ","15 sec ","30 sec ","1 min ","2 min ","4 min "]
[null,5,4,3,2,1,0,-1,-2,null,"1/4 sec ","1/2 sec ","1 sec ","2 sec ","4 sec ","8 sec ","15 sec ","30 sec ","1 min ","2 min "]
[null,6,5,4,3,2,1,0,-1,null,"1/8 sec ","1/4 sec ","1/2 sec ","1 sec ","2 sec ","4 sec ","8 sec ","15 sec ","30 sec ","1 min "]
[null,7,6,5,4,3,2,1,0,null,"1/15 sec ","1/8 sec ","1/4 sec ","1/2 sec ","1 sec ","2 sec ","4 sec ","8 sec ","15 sec ","30 sec "]
[null,8,7,6,5,4,3,2,1,null,"1/30 sec ","1/15 sec ","1/8 sec ","1/4 sec ","1/2 sec ","1 sec ","2 sec ","4 sec ","8 sec ","15 sec "]
[null,9,8,7,6,5,4,3,2,null,"1/60 sec ","1/30 sec ","1/15 sec ","1/8 sec ","1/4 sec ","1/2 sec ","1 sec ","2 sec ","4 sec ","8 sec "]
[null,10,9,8,7,6,5,4,3,null,"1/125 sec ","1/60 sec ","1/30 sec ","1/15 sec ","1/8 sec ","1/4 sec ","1/2 sec ","1 sec ","2 sec ","4 sec "]
[null,11,10,9,8,7,6,5,4,null,"1/250 sec ","1/125 sec ","1/60 sec ","1/30 sec ","1/15 sec ","1/8 sec ","1/4 sec ","1/2 sec ","1 sec ","2 sec "]
[null,12,11,10,9,8,7,6,5,null,"1/500 sec ","1/250 sec ","1/125 sec ","1/60 sec ","1/30 sec ","1/15 sec ","1/8 sec ","1/4 sec ","1/2 sec ","1 sec "]
[null,13,12,11,10,9,8,7,6,null,"1/1000 sec ","1/500 sec ","1/250 sec ","1/125 sec ","1/60 sec ","1/30 sec ","1/15 sec ","1/8 sec ","1/4 sec ","1/2 sec "]
[null,14,13,12,11,10,9,8,7,null,"1/2000 sec ","1/1000 sec ","1/500 sec ","1/250 sec ","1/125 sec ","1/60 sec ","1/30 sec ","1/15 sec ","1/8 sec ","1/4 sec "]
[null,15,14,13,12,11,10,9,8,null,"1/4000 sec ","1/2000 sec ","1/1000 sec ","1/500 sec ","1/250 sec ","1/125 sec ","1/60 sec ","1/30 sec ","1/15 sec ","1/8 sec "]
[null,16,15,14,13,12,11,10,9,null,"1/8000 sec ","1/4000 sec ","1/2000 sec ","1/1000 sec ","1/500 sec ","1/250 sec ","1/125 sec ","1/60 sec ","1/30 sec ","1/15 sec "]
[null,17,16,15,14,13,12,11,10,null,"1/15000 sec ","1/8000 sec ","1/4000 sec ","1/2000 sec ","1/1000 sec ","1/500 sec ","1/250 sec ","1/125 sec ","1/60 sec ","1/30 sec "]
[null,18,17,16,15,14,13,12,11,null,"1/30000 sec ","1/15000 sec ","1/8000 sec ","1/4000 sec ","1/2000 sec ","1/1000 sec ","1/500 sec ","1/250 sec ","1/125 sec ","1/60 sec "]
[null,19,18,17,16,15,14,13,12,null,"1/60000 sec ","1/30000 sec ","1/15000 sec ","1/8000 sec ","1/4000 sec ","1/2000 sec ","1/1000 sec ","1/500 sec ","1/250 sec ","1/125 sec "]
[null,20,19,18,17,16,15,14,13,null,"1/125000 sec ","1/60000 sec ","1/30000 sec ","1/15000 sec ","1/8000 sec ","1/4000 sec ","1/2000 sec ","1/1000 sec ","1/500 sec ","1/250 sec "]
[null,21,20,19,18,17,16,15,14,null,"1/250000 sec ","1/125000 sec ","1/60000 sec ","1/30000 sec ","1/15000 sec ","1/8000 sec ","1/4000 sec ","1/2000 sec ","1/1000 sec ","1/500 sec "]
[null,22,21,20,19,18,17,16,15,null,"1/500000 sec ","1/250000 sec ","1/125000 sec ","1/60000 sec ","1/30000 sec ","1/15000 sec ","1/8000 sec ","1/4000 sec ","1/2000 sec ","1/1000 sec "]
[null,23,22,21,20,19,18,17,16,null,"1/1000000 sec ","1/500000 sec ","1/250000 sec ","1/125000 sec ","1/60000 sec ","1/30000 sec ","1/15000sec ","1/8000 sec ","1/4000 sec ","1/2000 sec "]

{"sheet":"Scenes","index":2,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[-6,"Night, away from city lights, subject under starlight only. ",-6]
[-5,"Night, away from city lights, subject under crescent moon. ",-5]
[-4,"Night, away from city lights, subject under half moon. Meteors (during showers, with time exposure).",-4]
[-3,"Night, away from city lights, subject under full moon. ",-3]
[-2,"Night, away from city lights, snowscape under full moon. ",-2]
[-1,"Subjects lit by dim ambient artificial light. ",-1]
[0,"Subjects lit by dim ambient artificial light. ",0]
[1,"Distant view of lighted skyline. ",1]
[2,"Lightning (with time exposure). Total eclipse of moon.",2]
[3,"Fireworks (with time exposure). ",3]
[4,"Candle lit close-ups. Christmas lights, floodlit buildings, fountains, and monuments. Subjects under bright street lamps.",4]
[5,"Night home interiors, average light. School or church auditoriums. Subjects lit by campfires or bonfires.",5]
[6,"Brightly lit home interiors at night. Fairs, amusement parks.",6]
[7,"Bottom of rainforest canopy. Brightly lighted nighttime streets. Indoor sports. Stage shows, circuses.",7]
[8,"Las Vegas or Times Square at night. Store windows. Campfires, bonfires, burning buildings. Ice shows, football, baseball etc. at night. Interiors with bright florescent lights.",8]
[9,"Landscapes, city skylines 10 minutes after sunset. Neon lights, spotlighted subjects.",9]
[10,"Landscapes and skylines immediately after sunset. Crescent moon (long lens). ",10]
[11,"Sunsets. Subjects in deep shade.",11]
[12,"Half moon (long lens). Subject in open shade or heavy overcast.",12]
[13,"Gibbous moon (long lens). Subjects in cloudy-bright light (no shadows).",13]
[14,"Full moon (long lens). Subjects in weak, hazy sun.",14]
[15,"Subjects in bright or hazy sun (Sunny f/16 rule). ",15]
[16,"Subjects in bright daylight on sand or snow. ",16]
[17,"Rarely encountered in nature. Some man made lighting. ",17]
[18,"Rarely encountered in nature. Some man made lighting. ",18]
[19,"Rarely encountered in nature. Some man made lighting. ",19]
[20,"Rarely encountered in nature. Some man made lighting. ",20]
[21,"Rarely encountered in nature. Some man made lighting. ",21]
[22,"Extremely bright. Rarely encountered in nature.",22]
[23,"Extremely bright. Rarely encountered in nature.",23]

{"sheet":"Shutters","index":3,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["For very low light situations. Any movement will cause a blur. Use for inanimate objects. Streaks on the highways are made with this setting.","Bulb"]
["For very low light situations. Any movement will cause a blur. Use for inanimate objects. Streaks on the highways are made with this setting.",1]
["For very low light situations. Any movement will cause a blur. Use for inanimate objects. Streaks on the highways are made with this setting.",2]
["For very low light situations. Any movement will cause a blur. Use for inanimate objects. Streaks on the highways are made with this setting.",4]
["For very low light situations. Any movement will cause a blur. Use for inanimate objects. Streaks on the highways are made with this setting.",8]
["Very difficult to shoot without a tripod.",15]
["Lowest possible speed you can shoot with out a tripod but try to avoid movement. This setting picks up the ambient light.",30]
["This setting is good for cloudy days and most existing light situations.",60]
["This setting is good for bright sunny days. It is good for a person walking normally. Good for short focal lenses.",125]
["This stetting can freeze a person jogging slowly.",250]
["This setting can freeze cars in traffic.",500]
["This setting can freeze racing cars, and planes.",1000]
["This setting can freeze action that can move faster objects like bullets.",2000]

{"sheet":"BGdata","index":4,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[-6,25,"f/1.4","32 min ","Night, away from city lights, subject under starlight only. "]
[-5,50,"f/2","16 min ","Night, away from city lights, subject under crescent moon. "]
[-4,100,"f/2.8","8 min ","Night, away from city lights, subject under half moon. Meteors (during showers, with time exposure)."]
[-3,200,"f/4","4 min ","Night, away from city lights, subject under full moon. "]
[-2,400,"f/5.6","2 min ","Night, away from city lights, snowscape under full moon. "]
[-1,800,"f/8","1 min ","Subjects lit by dim ambient artificial light. "]
[0,1600,"f/11","30 sec ","Distant view of lighted skyline. "]
[1,3200,"f/16","15 sec ","Lightning (with time exposure). Total eclipse of moon."]
[2,null,"f/22","8 sec ","Fireworks (with time exposure). "]
[3,null,"f/32","4 sec ","Candle lit close-ups. Christmas lights, floodlit buildings, fountains, and monuments. Subjects under bright street lamps."]
[4,null,null,"2 sec ","Night home interiors, average light. School or church auditoriums. Subjects lit by campfires or bonfires."]
[5,null,null,"1 sec ","Brightly lit home interiors at night. Fairs, amusement parks."]
[6,null,null,"1/2 sec ","Bottom of rainforest canopy. Brightly lighted nighttime streets. Indoor sports. Stage shows, circuses."]
[7,null,null,"1/4 sec ","Las Vegas or Times Square at night. Store windows. Campfires, bonfires, burning buildings. Ice shows, football, baseball etc. at night. Interiors with bright florescent lights."]
[8,null,null,"1/8 sec ","Landscapes, city skylines 10 minutes after sunset. Neon lights, spotlighted subjects."]
[9,null,null,"1/15 sec ","Landscapes and skylines immediately after sunset. Crescent moon (long lens). "]
[10,null,null,"1/30 sec ","Sunsets. Subjects in deep shade."]
[11,null,null,"1/60 sec ","Half moon (long lens). Subject in open shade or heavy overcast."]
[12,null,null,"1/125 sec ","Gibbous moon (long lens). Subjects in cloudy-bright light (no shadows)."]
[13,null,null,"1/250 sec ","Full moon (long lens). Subjects in weak, hazy sun."]
[14,null,null,"1/500 sec ","Subjects in bright or hazy sun (Sunny f/16 rule). "]
[15,null,null,"1/1000 sec ","Subjects in bright daylight on sand or snow. "]
[16,null,null,"1/2000 sec ","Rarely encountered in nature. Some man made lighting. "]
[17,null,null,"1/4000 sec ","Extremely bright. Rarely encountered in nature."]
[18,null,null,"1/8000 sec "]
[19,null,null,"1/15000 sec ","Aperture"]
[20,null,null,"1/30000 sec ","Shutter"]
[21,null,null,"1/60000 sec "]
[22,null,null,"1/125000 sec "]
[23,null,null,"1/250000 sec "]
[null,null,null,"1/500000 sec "]
[null,null,null,"1/1000000 sec "]