{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Totals","Launch Box","Client Info Box","Print Sheets","Travel","Calendar","Job Report","Top Sheet","Page 1A","Page 1B","Page 2","Page 3","Page 4","Page 5","Page 6","Sales Log","Purchase Order Log","Petty Cash Log","Payroll Log","Check Log"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":492,"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":"Totals","index":0,"n_rows":359,"n_cols":28,"rows_kept":359,"cut":false,"hidden":true,"merged":[]}
[null,1.0,{"$f":"IF('Page 1A'!B7=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B7)","v":"Line Producer"},{"$f":"SUMIF(PAYROLLLINE,B1:B50,PAYROLLAMOUNT)","v":0},{"$f":"IF(D1:D50=0,0,SUMIF(PAYROLLLINE,B1:B50,PAYROLLST)/D1:D50)","v":0},{"$f":"SUMIF(PAYROLLLINE,B1:B50,PAYROLLOTHRS)","v":0},{"$f":"SUMIF(PAYROLLLINE,B1:B50,PAYROLLST)","v":0},{"$f":"SUMIF(PAYROLLLINE,B1:B50,PAYROLLOT)","v":0},{"$f":"SUMIF(PAYROLLLINE,B1:B50,PAYROLLMISCT)+SUMIF(PAYROLLLINE,B1:B50,PAYROLLMISCNT)","v":0},{"$f":"SUMIF(POLINE,B1:B50,POACTUAL)-SUMIF(REFUNDSLINE,B1:B50,REFUNDSACTUAL)+SUMIF(PCLINE,B1:B50,PCACTUAL)","v":0},{"$f":"SUMIF(POLINE,B1:B50,POACTUAL)-SUMIF(REFUNDSLINE,B1:B50,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B1:B50,PAYROLLACTUAL)+SUMIF(PCLINE,B1:B50,PCACTUAL)","v":0},null,null,null,null,null,null,null,"Record Label:"]
[null,2.0,{"$f":"IF('Page 1A'!B8=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B8)","v":"Assistant Director"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Address:"]
[null,3.0,{"$f":"IF('Page 1A'!B9=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B9)","v":"Director of Photography"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,4.0,{"$f":"IF('Page 1A'!B10=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B10)","v":"Camera Operator"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Telephone:"]
[null,5.0,{"$f":"IF('Page 1A'!B11=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B11)","v":"1st Camera Assistant"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Fax:"]
[null,6.0,{"$f":"IF('Page 1A'!B12=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B12)","v":"2nd AC"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Contacts:"]
[null,7.0,{"$f":"IF('Page 1A'!B13=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B13)","v":"Loader"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,8.0,{"$f":"IF('Page 1A'!B14=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B14)","v":"Production Manager"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Artist:"]
[null,9.0,{"$f":"IF('Page 1A'!B15=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B15)","v":"Production Coordinator"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Track(s):"]
[null,10.0,{"$f":"IF('Page 1A'!B16=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B16)","v":"2nd AD"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,11.0,{"$f":"IF('Page 1A'!B17=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B17)","v":"Gaffer"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Management:"]
[null,12.0,{"$f":"IF('Page 1A'!B18=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B18)","v":"Best Boy Electric"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Address:"]
[null,13.0,{"$f":"IF('Page 1A'!B19=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B19)","v":"Electric"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,14.0,{"$f":"IF('Page 1A'!B20=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B20)","v":"Electric Driver"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Telephone:"]
[null,15.0,{"$f":"IF('Page 1A'!B21=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B21)","v":"Rigger"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Fax:"]
[null,16.0,{"$f":"IF('Page 1A'!B22=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B22)","v":"Key Grip"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Contacts:"]
[null,17.0,{"$f":"IF('Page 1A'!B23=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B23)","v":"Best Boy Grip"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Delivery Date:"]
[null,18.0,{"$f":"IF('Page 1A'!B24=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B24)","v":"Grip"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Shoot Date(s):",null,null,null,null,null,"Delivery Format:",null,"Delivery Format:"]
[null,19.0,{"$f":"IF('Page 1A'!B25=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B25)","v":"Grip Driver"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,20.0,{"$f":"IF('Page 1A'!B26=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B26)","v":"Mixer"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Agency:"]
[null,21.0,{"$f":"IF('Page 1A'!B27=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B27)","v":"Boom Man"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Address:"]
[null,22.0,{"$f":"IF('Page 1A'!B28=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B28)","v":"Playback"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,23.0,{"$f":"IF('Page 1A'!B29=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B29)","v":"Make-up"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Telephone:"]
[null,24.0,{"$f":"IF('Page 1A'!B30=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B30)","v":"Hair Stylist"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Fax:"]
[null,25.0,{"$f":"IF('Page 1A'!B31=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B31)","v":"Make-up/Hair Assts."},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Agency Prod:"]
[null,26.0,{"$f":"IF('Page 1A'!B32=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B32)","v":"Stylist"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Agency Art Dir:"]
[null,27.0,{"$f":"IF('Page 1A'!B33=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B33)","v":"Wardrobe "},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Agency Writer:"]
[null,28.0,{"$f":"IF('Page 1A'!B34=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B34)","v":"Script Supervisor"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Agency Bus Mgr:"]
[null,29.0,{"$f":"IF('Page 1A'!B35=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B35)","v":"Home Economist"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Client:"]
[null,30.0,{"$f":"IF('Page 1A'!B36=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B36)","v":"Asst. Home Economist"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Product:"]
[null,31.0,{"$f":"IF('Page 1A'!B37=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B37)","v":"VTR Operator"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Bid Name:"]
[null,32.0,{"$f":"IF('Page 1A'!B38=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B38)","v":"Effects"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,"Commercial Title",null,null,null,null,null,"Code","Length","Code","Length"]
[null,33.0,{"$f":"IF('Page 1A'!B39=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B39)","v":"FX Assistant"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,{"$f":"\"1.\"","v":"1."}]
[null,34.0,{"$f":"IF('Page 1A'!B40=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B40)","v":"2nd 2nd AD"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,{"$f":"\"2.\"","v":"2."}]
[null,35.0,{"$f":"IF('Page 1A'!B41=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B41)","v":"Camera Car Driver"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,{"$f":"\"3.\"","v":"3."}]
[null,36.0,{"$f":"IF('Page 1A'!B42=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B42)","v":"Crane Tech"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,{"$f":"\"4.\"","v":"4."}]
[null,37.0,{"$f":"IF('Page 1A'!B43=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B43)","v":"Remote Head Tech"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,{"$f":"\"5.\"","v":"5."}]
[null,38.0,{"$f":"IF('Page 1A'!B44=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B44)","v":"Location Scout"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,null,null,null,null,null,{"$f":"\"6.\"","v":"6."}]
[null,39.0,{"$f":"IF('Page 1A'!B45=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B45)","v":"Assistant Scout"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,40.0,{"$f":"IF('Page 1A'!B46=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B46)","v":"Nurse/1st Aid"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,41.0,{"$f":"IF('Page 1A'!B47=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B47)","v":"Craft Service"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,42.0,{"$f":"IF('Page 1A'!B48=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B48)","v":"Firemen"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,43.0,{"$f":"IF('Page 1A'!B49=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B49)","v":"Policemen"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,44.0,{"$f":"IF('Page 1A'!B50=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B50)","v":"Welfare/Teacher"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,45.0,{"$f":"IF('Page 1A'!B51=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B51)","v":"Choreographer"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,46.0,{"$f":"IF('Page 1A'!B52=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B52)","v":"Gang Boss"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,47.0,{"$f":"IF('Page 1A'!B53=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B53)","v":"Teamsters/Driver"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,48.0,{"$f":"IF('Page 1A'!B54=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B54)","v":"Teamster/Caterers"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,49.0,{"$f":"IF('Page 1A'!B55=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B55)","v":"Production Assistant"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,50.0,{"$f":"IF('Page 1A'!B56=\"\",\"LINE DESCRIPTION?\",'Page 1A'!B56)","v":"Runner"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,null,"SUB-TOTAL A",null,null,null,null,null,null,null,{"$f":"SUM(K1:K50)","v":0}]
[null,null,"PT/P&W",null,null,null,null,null,null,null,{"$f":"SUMIF(PAYROLLLINE,\">=1\",PAYROLLPT_DLR)-SUMIF(PAYROLLLINE,\">=51\",PAYROLLPT_DLR)","v":0}]
[null,null,"TOTAL A",null,null,null,null,null,null,null,{"$f":"SUM(K51:K52)","v":0}]
[null,51.0,{"$f":"IF('Page 1B'!B7=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B7)","v":"Line Producer"},{"$f":"SUMIF(PAYROLLLINE,B54:B103,PAYROLLAMOUNT)","v":0},{"$f":"IF(D54:D103=0,0,SUMIF(PAYROLLLINE,B54:B103,PAYROLLST)/D54:D103)","v":0},{"$f":"SUMIF(PAYROLLLINE,B54:B103,PAYROLLOTHRS)","v":0},{"$f":"SUMIF(PAYROLLLINE,B54:B103,PAYROLLST)","v":0},{"$f":"SUMIF(PAYROLLLINE,B54:B103,PAYROLLOT)","v":0},{"$f":"SUMIF(PAYROLLLINE,B54:B103,PAYROLLMISCT)+SUMIF(PAYROLLLINE,B54:B103,PAYROLLMISCNT)","v":0},{"$f":"SUMIF(POLINE,B54:B103,POACTUAL)-SUMIF(REFUNDSLINE,B54:B103,REFUNDSACTUAL)+SUMIF(PCLINE,B54:B103,PCACTUAL)","v":0},{"$f":"SUMIF(POLINE,B54:B103,POACTUAL)-SUMIF(REFUNDSLINE,B54:B103,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B54:B103,PAYROLLACTUAL)+SUMIF(PCLINE,B54:B103,PCACTUAL)","v":0}]
[null,52.0,{"$f":"IF('Page 1B'!B8=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B8)","v":"Assistant Director"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,53.0,{"$f":"IF('Page 1B'!B9=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B9)","v":"Director of Photography"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,54.0,{"$f":"IF('Page 1B'!B10=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B10)","v":"Camera Operator"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,55.0,{"$f":"IF('Page 1B'!B11=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B11)","v":"1st Camera Assistant"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,56.0,{"$f":"IF('Page 1B'!B12=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B12)","v":"2nd AC"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,57.0,{"$f":"IF('Page 1B'!B13=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B13)","v":"Loader"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,58.0,{"$f":"IF('Page 1B'!B14=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B14)","v":"Production Manager"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,59.0,{"$f":"IF('Page 1B'!B15=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B15)","v":"Production Coordinator"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,60.0,{"$f":"IF('Page 1B'!B16=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B16)","v":"2nd AD"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,61.0,{"$f":"IF('Page 1B'!B17=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B17)","v":"Gaffer"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,62.0,{"$f":"IF('Page 1B'!B18=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B18)","v":"Best Boy Electric"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,63.0,{"$f":"IF('Page 1B'!B19=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B19)","v":"Electric"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,64.0,{"$f":"IF('Page 1B'!B20=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B20)","v":"Electric Driver"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,65.0,{"$f":"IF('Page 1B'!B21=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B21)","v":"Rigger"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,66.0,{"$f":"IF('Page 1B'!B22=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B22)","v":"Key Grip"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,67.0,{"$f":"IF('Page 1B'!B23=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B23)","v":"Best Boy Grip"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,68.0,{"$f":"IF('Page 1B'!B24=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B24)","v":"Grip"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,69.0,{"$f":"IF('Page 1B'!B25=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B25)","v":"Grip Driver"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,70.0,{"$f":"IF('Page 1B'!B26=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B26)","v":"Mixer"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,71.0,{"$f":"IF('Page 1B'!B27=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B27)","v":"Boom Man"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,72.0,{"$f":"IF('Page 1B'!B28=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B28)","v":"Playback"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,73.0,{"$f":"IF('Page 1B'!B29=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B29)","v":"Make-up"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,74.0,{"$f":"IF('Page 1B'!B30=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B30)","v":"Hair Stylist"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,75.0,{"$f":"IF('Page 1B'!B31=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B31)","v":"Make-up/Hair Assts."},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,76.0,{"$f":"IF('Page 1B'!B32=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B32)","v":"Stylist"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,77.0,{"$f":"IF('Page 1B'!B33=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B33)","v":"Wardrobe "},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,78.0,{"$f":"IF('Page 1B'!B34=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B34)","v":"Script Supervisor"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,79.0,{"$f":"IF('Page 1B'!B35=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B35)","v":"Home Economist"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,80.0,{"$f":"IF('Page 1B'!B36=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B36)","v":"Asst. Home Economist"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,81.0,{"$f":"IF('Page 1B'!B37=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B37)","v":"VTR Operator"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,82.0,{"$f":"IF('Page 1B'!B38=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B38)","v":"Effects"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,83.0,{"$f":"IF('Page 1B'!B39=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B39)","v":"FX Assistant"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,84.0,{"$f":"IF('Page 1B'!B40=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B40)","v":"2nd 2nd AD"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,85.0,{"$f":"IF('Page 1B'!B41=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B41)","v":"Camera Car Driver"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,86.0,{"$f":"IF('Page 1B'!B42=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B42)","v":"Crane Tech"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,87.0,{"$f":"IF('Page 1B'!B43=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B43)","v":"Remote Head Tech"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,88.0,{"$f":"IF('Page 1B'!B44=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B44)","v":"Location Scout"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,89.0,{"$f":"IF('Page 1B'!B45=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B45)","v":"Assistant Scout"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,90.0,{"$f":"IF('Page 1B'!B46=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B46)","v":"Nurse/1st Aid"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,91.0,{"$f":"IF('Page 1B'!B47=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B47)","v":"Craft Service"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,92.0,{"$f":"IF('Page 1B'!B48=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B48)","v":"Firemen"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,93.0,{"$f":"IF('Page 1B'!B49=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B49)","v":"Policemen"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,94.0,{"$f":"IF('Page 1B'!B50=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B50)","v":"Welfare/Teacher"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,95.0,{"$f":"IF('Page 1B'!B51=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B51)","v":"Choreographer"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,96.0,{"$f":"IF('Page 1B'!B52=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B52)","v":"Gang Boss"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,97.0,{"$f":"IF('Page 1B'!B53=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B53)","v":"Teamsters/Driver"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,98.0,{"$f":"IF('Page 1B'!B54=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B54)","v":"Teamster/Caterers"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,99.0,{"$f":"IF('Page 1B'!B55=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B55)","v":"Production Assistant"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,100.0,{"$f":"IF('Page 1B'!B56=\"\",\"LINE DESCRIPTION?\",'Page 1B'!B56)","v":"Runner"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,null,"SUB-TOTAL A",null,null,null,null,null,null,null,{"$f":"SUM(K54:K103)","v":0}]
[null,null,"PT/P&W",null,null,null,null,null,null,null,{"$f":"SUMIF(PAYROLLLINE,\">=51\",PAYROLLPT_DLR)-SUMIF(PAYROLLLINE,\">=101\",PAYROLLPT_DLR)","v":0}]
[null,null,"TOTAL B",null,null,null,null,null,null,null,{"$f":"SUM(K104:K105)","v":0}]
[null,101.0,{"$f":"IF('Page 2'!B6=\"\",\"LINE DESCRIPTION?\",'Page 2'!B6)","v":"Auto/Passenger Van Rentals"},null,null,null,null,null,null,null,{"$f":"SUMIF(POLINE,B107:B119,POACTUAL)-SUMIF(REFUNDSLINE,B107:B119,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B107:B119,PAYROLLACTUAL)+SUMIF(PCLINE,B107:B119,PCACTUAL)","v":0}]
[null,102.0,{"$f":"IF('Page 2'!B7=\"\",\"LINE DESCRIPTION?\",'Page 2'!B7)","v":"Air Fares"},null,null,null,null,null,null,null,0.0]
[null,103.0,{"$f":"IF('Page 2'!B8=\"\",\"LINE DESCRIPTION?\",'Page 2'!B8)","v":"Per Diems"},null,null,null,null,null,null,null,0.0]
[null,104.0,{"$f":"IF('Page 2'!B9=\"\",\"LINE DESCRIPTION?\",'Page 2'!B9)","v":"Still Camera & Film"},null,null,null,null,null,null,null,0.0]
[null,105.0,{"$f":"IF('Page 2'!B10=\"\",\"LINE DESCRIPTION?\",'Page 2'!B10)","v":"Messengers"},null,null,null,null,null,null,null,0.0]
[null,106.0,{"$f":"IF('Page 2'!B11=\"\",\"LINE DESCRIPTION?\",'Page 2'!B11)","v":"Trucking"},null,null,null,null,null,null,null,0.0]
[null,107.0,{"$f":"IF('Page 2'!B12=\"\",\"LINE DESCRIPTION?\",'Page 2'!B12)","v":"Deliveries & Taxis"},null,null,null,null,null,null,null,0.0]
[null,108.0,{"$f":"IF('Page 2'!B13=\"\",\"LINE DESCRIPTION?\",'Page 2'!B13)","v":"Video Conferencing"},null,null,null,null,null,null,null,0.0]
[null,109.0,{"$f":"IF('Page 2'!B14=\"\",\"LINE DESCRIPTION?\",'Page 2'!B14)","v":"Telephone & Cable"},null,null,null,null,null,null,null,0.0]
[null,110.0,{"$f":"IF('Page 2'!B15=\"\",\"LINE DESCRIPTION?\",'Page 2'!B15)","v":"Casting Director "},null,null,null,null,null,null,null,0.0]
[null,111.0,{"$f":"IF('Page 2'!B16=\"\",\"LINE DESCRIPTION?\",'Page 2'!B16)","v":"Casting Facilities"},null,null,null,null,null,null,null,0.0]
[null,112.0,{"$f":"IF('Page 2'!B17=\"\",\"LINE DESCRIPTION?\",'Page 2'!B17)","v":"Polaroids/Internet Posting"},null,null,null,null,null,null,null,0.0]
[null,113.0,{"$f":"IF('Page 2'!B18=\"\",\"LINE DESCRIPTION?\",'Page 2'!B18)","v":"Scouting Expenses"},null,null,null,null,null,null,null,0.0]
[null,null,"TOTAL C",null,null,null,null,null,null,null,{"$f":"SUM(K107:K119)","v":0}]
[null,114.0,{"$f":"IF('Page 2'!B22=\"\",\"LINE DESCRIPTION?\",'Page 2'!B22)","v":"Location Fees           "},null,null,null,null,null,null,null,{"$f":"SUMIF(POLINE,B121:B146,POACTUAL)-SUMIF(REFUNDSLINE,B121:B146,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B121:B146,PAYROLLACTUAL)+SUMIF(PCLINE,B121:B146,PCACTUAL)","v":0}]
[null,115.0,{"$f":"IF('Page 2'!B23=\"\",\"LINE DESCRIPTION?\",'Page 2'!B23)","v":"Permits"},null,null,null,null,null,null,null,0.0]
[null,116.0,{"$f":"IF('Page 2'!B24=\"\",\"LINE DESCRIPTION?\",'Page 2'!B24)","v":"Car Rentals"},null,null,null,null,null,null,null,0.0]
[null,117.0,{"$f":"IF('Page 2'!B25=\"\",\"LINE DESCRIPTION?\",'Page 2'!B25)","v":"Bus/Passenger Van Rentals"},null,null,null,null,null,null,null,0.0]
[null,118.0,{"$f":"IF('Page 2'!B26=\"\",\"LINE DESCRIPTION?\",'Page 2'!B26)","v":"Dressing Room Vehicles"},null,null,null,null,null,null,null,0.0]
[null,119.0,{"$f":"IF('Page 2'!B27=\"\",\"LINE DESCRIPTION?\",'Page 2'!B27)","v":"Parking, Tolls, and Gas"},null,null,null,null,null,null,null,0.0]
[null,120.0,{"$f":"IF('Page 2'!B28=\"\",\"LINE DESCRIPTION?\",'Page 2'!B28)","v":"Production Trucking"},null,null,null,null,null,null,null,0.0]
[null,121.0,{"$f":"IF('Page 2'!B29=\"\",\"LINE DESCRIPTION?\",'Page 2'!B29)","v":"Camera Truck"},null,null,null,null,null,null,null,0.0]
[null,122.0,{"$f":"IF('Page 2'!B30=\"\",\"LINE DESCRIPTION?\",'Page 2'!B30)","v":"Stake Bed/Pick UP/ATV/Lighting and grip"},null,null,null,null,null,null,null,0.0]
[null,123.0,{"$f":"IF('Page 2'!B31=\"\",\"LINE DESCRIPTION?\",'Page 2'!B31)","v":"Customs"},null,null,null,null,null,null,null,0.0]
[null,124.0,{"$f":"IF('Page 2'!B32=\"\",\"LINE DESCRIPTION?\",'Page 2'!B32)","v":"Excess Bags"},null,null,null,null,null,null,null,0.0]
[null,125.0,{"$f":"IF('Page 2'!B33=\"\",\"LINE DESCRIPTION?\",'Page 2'!B33)","v":"Air Fares"},null,null,null,null,null,null,null,0.0]
[null,126.0,{"$f":"IF('Page 2'!B34=\"\",\"LINE DESCRIPTION?\",'Page 2'!B34)","v":"Hotel/Per Diems"},null,null,null,null,null,null,null,0.0]
[null,127.0,{"$f":"IF('Page 2'!B35=\"\",\"LINE DESCRIPTION?\",'Page 2'!B35)","v":"Tech Scout Breakfast & Lunch"},null,null,null,null,null,null,null,0.0]
[null,128.0,{"$f":"IF('Page 2'!B36=\"\",\"LINE DESCRIPTION?\",'Page 2'!B36)","v":"Pre-Production Meeting & Fittings Meals"},null,null,null,null,null,null,null,0.0]
[null,129.0,{"$f":"IF('Page 2'!B37=\"\",\"LINE DESCRIPTION?\",'Page 2'!B37)","v":"Breakfast"},null,null,null,null,null,null,null,0.0]
[null,130.0,{"$f":"IF('Page 2'!B38=\"\",\"LINE DESCRIPTION?\",'Page 2'!B38)","v":"Lunch"},null,null,null,null,null,null,null,0.0]
[null,131.0,{"$f":"IF('Page 2'!B39=\"\",\"LINE DESCRIPTION?\",'Page 2'!B39)","v":"Dinner"},null,null,null,null,null,null,null,0.0]
[null,132.0,{"$f":"IF('Page 2'!B40=\"\",\"LINE DESCRIPTION?\",'Page 2'!B40)","v":"Set Security"},null,null,null,null,null,null,null,0.0]
[null,133.0,{"$f":"IF('Page 2'!B41=\"\",\"LINE DESCRIPTION?\",'Page 2'!B41)","v":"Limousines"},null,null,null,null,null,null,null,0.0]
[null,134.0,{"$f":"IF('Page 2'!B42=\"\",\"LINE DESCRIPTION?\",'Page 2'!B42)","v":"Cabs and Other Transportation"},null,null,null,null,null,null,null,0.0]
[null,135.0,{"$f":"IF('Page 2'!B43=\"\",\"LINE DESCRIPTION?\",'Page 2'!B43)","v":"Kit Rental"},null,null,null,null,null,null,null,0.0]
[null,136.0,{"$f":"IF('Page 2'!B44=\"\",\"LINE DESCRIPTION?\",'Page 2'!B44)","v":"Art Work"},null,null,null,null,null,null,null,0.0]
[null,137.0,{"$f":"IF('Page 2'!B45=\"\",\"LINE DESCRIPTION?\",'Page 2'!B45)","v":"Talent Meal"},null,null,null,null,null,null,null,0.0]
[null,138.0,{"$f":"IF('Page 2'!B46=\"\",\"LINE DESCRIPTION?\",'Page 2'!B46)","v":"Craft Services"},null,null,null,null,null,null,null,0.0]
[null,139.0,{"$f":"IF('Page 2'!B47=\"\",\"LINE DESCRIPTION?\",'Page 2'!B47)","v":"Cell Phones"},null,null,null,null,null,null,null,0.0]
[null,null,"TOTAL D",null,null,null,null,null,null,null,{"$f":"SUM(K121:K131)","v":0}]
[null,140.0,{"$f":"IF('Page 2'!B51=\"\",\"LINE DESCRIPTION?\",'Page 2'!B51)","v":"Prop Rentals"},null,null,null,null,null,null,null,{"$f":"SUMIF(POLINE,B148:B158,POACTUAL)-SUMIF(REFUNDSLINE,B148:B158,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B148:B158,PAYROLLACTUAL)+SUMIF(PCLINE,B148:B158,PCACTUAL)","v":0}]
[null,141.0,{"$f":"IF('Page 2'!B52=\"\",\"LINE DESCRIPTION?\",'Page 2'!B52)","v":"Prop Purchases"},null,null,null,null,null,null,null,0.0]
[null,142.0,{"$f":"IF('Page 2'!B53=\"\",\"LINE DESCRIPTION?\",'Page 2'!B53)","v":"Wardrobe Rentals"},null,null,null,null,null,null,null,0.0]
[null,143.0,{"$f":"IF('Page 2'!B54=\"\",\"LINE DESCRIPTION?\",'Page 2'!B54)","v":"Wardrobe Purchases"},null,null,null,null,null,null,null,0.0]
[null,144.0,{"$f":"IF('Page 2'!#REF!=\"\",\"LINE DESCRIPTION?\",'Page 2'!#REF!)","v":"#ERROR!"},null,null,null,null,null,null,null,0.0]
[null,145.0,{"$f":"IF('Page 2'!B55=\"\",\"LINE DESCRIPTION?\",'Page 2'!B55)","v":"Picture Vehicles"},null,null,null,null,null,null,null,0.0]
[null,146.0,{"$f":"IF('Page 2'!B57=\"\",\"LINE DESCRIPTION?\",'Page 2'!B57)","v":"Wigs & Mustaches"},null,null,null,null,null,null,null,0.0]
[null,147.0,{"$f":"IF('Page 2'!B58=\"\",\"LINE DESCRIPTION?\",'Page 2'!B58)","v":"Color Correction"},null,null,null,null,null,null,null,0.0]
[null,148.0,{"$f":"IF('Page 2'!B59=\"\",\"LINE DESCRIPTION?\",'Page 2'!B59)","v":"Atmospheric FX (Wind, Fog, Rain, Etc.)"},null,null,null,null,null,null,null,0.0]
[null,149.0,{"$f":"IF('Page 2'!B60=\"\",\"LINE DESCRIPTION?\",'Page 2'!B60)","v":"Water Truck "},null,null,null,null,null,null,null,0.0]
[null,150.0,{"$f":"IF('Page 2'!B61=\"\",\"LINE DESCRIPTION?\",'Page 2'!B61)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,null,"TOTAL E",null,null,null,null,null,null,null,{"$f":"SUM(K148:K158)","v":0}]
[null,151.0,{"$f":"IF('Page 3'!B6=\"\",\"LINE DESCRIPTION?\",'Page 3'!B6)","v":"Rental for Build"},null,null,null,null,null,null,null,{"$f":"SUMIF(POLINE,B160:B176,POACTUAL)-SUMIF(REFUNDSLINE,B160:B176,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B160:B176,PAYROLLACTUAL)+SUMIF(PCLINE,B160:B176,PCACTUAL)","v":0}]
[null,152.0,{"$f":"IF('Page 3'!B7=\"\",\"LINE DESCRIPTION?\",'Page 3'!B7)","v":"Build OT Hours"},null,null,null,null,null,null,null,0.0]
[null,153.0,{"$f":"IF('Page 3'!B8=\"\",\"LINE DESCRIPTION?\",'Page 3'!B8)","v":"Rental for Pre-Lite Days"},null,null,null,null,null,null,null,0.0]
[null,154.0,{"$f":"IF('Page 3'!B9=\"\",\"LINE DESCRIPTION?\",'Page 3'!B9)","v":"Pre-Lite OT Hours"},null,null,null,null,null,null,null,0.0]
[null,155.0,{"$f":"IF('Page 3'!B10=\"\",\"LINE DESCRIPTION?\",'Page 3'!B10)","v":"Rental for Shoot Days"},null,null,null,null,null,null,null,0.0]
[null,156.0,{"$f":"IF('Page 3'!B11=\"\",\"LINE DESCRIPTION?\",'Page 3'!B11)","v":"Shoot OT Hours"},null,null,null,null,null,null,null,0.0]
[null,157.0,{"$f":"IF('Page 3'!B12=\"\",\"LINE DESCRIPTION?\",'Page 3'!B12)","v":"Rental for Strike Days"},null,null,null,null,null,null,null,0.0]
[null,158.0,{"$f":"IF('Page 3'!B13=\"\",\"LINE DESCRIPTION?\",'Page 3'!B13)","v":"Strike OT Hours"},null,null,null,null,null,null,null,0.0]
[null,159.0,{"$f":"IF('Page 3'!B14=\"\",\"LINE DESCRIPTION?\",'Page 3'!B14)","v":"Generator and Operator"},null,null,null,null,null,null,null,0.0]
[null,160.0,{"$f":"IF('Page 3'!B15=\"\",\"LINE DESCRIPTION?\",'Page 3'!B15)","v":"Studio Security"},null,null,null,null,null,null,null,0.0]
[null,161.0,{"$f":"IF('Page 3'!B16=\"\",\"LINE DESCRIPTION?\",'Page 3'!B16)","v":"Power Charges"},null,null,null,null,null,null,null,0.0]
[null,162.0,{"$f":"IF('Page 3'!B17=\"\",\"LINE DESCRIPTION?\",'Page 3'!B17)","v":"Trash"},null,null,null,null,null,null,null,0.0]
[null,163.0,{"$f":"IF('Page 3'!B18=\"\",\"LINE DESCRIPTION?\",'Page 3'!B18)","v":"Stage Manager"},null,null,null,null,null,null,null,0.0]
[null,164.0,{"$f":"IF('Page 3'!B19=\"\",\"LINE DESCRIPTION?\",'Page 3'!B19)","v":"Parking"},null,null,null,null,null,null,null,0.0]
[null,165.0,{"$f":"IF('Page 3'!B20=\"\",\"LINE DESCRIPTION?\",'Page 3'!B20)","v":"Telephones & Fax Machines"},null,null,null,null,null,null,null,0.0]
[null,166.0,{"$f":"IF('Page 3'!B21=\"\",\"LINE DESCRIPTION?\",'Page 3'!B21)","v":"Heat/Air Conditioning"},null,null,null,null,null,null,null,0.0]
[null,167.0,{"$f":"IF('Page 3'!B22=\"\",\"LINE DESCRIPTION?\",'Page 3'!B22)","v":"Misc Studio Charges"},null,null,null,null,null,null,null,0.0]
[null,null,"TOTAL F",null,null,null,null,null,null,null,{"$f":"SUM(K160:K166)","v":0}]
[null,168.0,{"$f":"IF('Page 3'!B28=\"\",\"LINE DESCRIPTION?\",'Page 3'!B28)","v":"Production Designer"},{"$f":"SUMIF(PAYROLLLINE,B178:B190,PAYROLLAMOUNT)","v":0},{"$f":"IF(D178:D190=0,0,SUMIF(PAYROLLLINE,B178:B190,PAYROLLST)/D178:D190)","v":0},{"$f":"SUMIF(PAYROLLLINE,B178:B190,PAYROLLOTHRS)","v":0},{"$f":"SUMIF(PAYROLLLINE,B178:B190,PAYROLLST)","v":0},{"$f":"SUMIF(PAYROLLLINE,B178:B190,PAYROLLOT)","v":0},{"$f":"SUMIF(PAYROLLLINE,B178:B190,PAYROLLMISCT)+SUMIF(PAYROLLLINE,B178:B190,PAYROLLMISCNT)","v":0},{"$f":"SUMIF(POLINE,B178:B190,POACTUAL)-SUMIF(REFUNDSLINE,B178:B190,REFUNDSACTUAL)+SUMIF(PCLINE,B178:B190,PCACTUAL)","v":0},{"$f":"SUMIF(POLINE,B178:B190,POACTUAL)-SUMIF(REFUNDSLINE,B178:B190,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B178:B190,PAYROLLACTUAL)+SUMIF(PCLINE,B178:B190,PCACTUAL)","v":0}]
[null,169.0,{"$f":"IF('Page 3'!B29=\"\",\"LINE DESCRIPTION?\",'Page 3'!B29)","v":"Art Director"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,170.0,{"$f":"IF('Page 3'!B30=\"\",\"LINE DESCRIPTION?\",'Page 3'!B30)","v":"Art Department Coordinator"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,171.0,{"$f":"IF('Page 3'!B31=\"\",\"LINE DESCRIPTION?\",'Page 3'!B31)","v":"Buyer"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,172.0,{"$f":"IF('Page 3'!B32=\"\",\"LINE DESCRIPTION?\",'Page 3'!B32)","v":"Prop Master"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,173.0,{"$f":"IF('Page 3'!B33=\"\",\"LINE DESCRIPTION?\",'Page 3'!B33)","v":"Prop Assts."},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,174.0,{"$f":"IF('Page 3'!B34=\"\",\"LINE DESCRIPTION?\",'Page 3'!B34)","v":"Scenic"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,175.0,{"$f":"IF('Page 3'!B35=\"\",\"LINE DESCRIPTION?\",'Page 3'!B35)","v":"Set Dresser"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,176.0,{"$f":"IF('Page 3'!B36=\"\",\"LINE DESCRIPTION?\",'Page 3'!B36)","v":"Lead Man"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,177.0,{"$f":"IF('Page 3'!B37=\"\",\"LINE DESCRIPTION?\",'Page 3'!B37)","v":"Painter"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,178.0,{"$f":"IF('Page 3'!B38=\"\",\"LINE DESCRIPTION?\",'Page 3'!B38)","v":"Art PAs"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,179.0,{"$f":"IF('Page 3'!B39=\"\",\"LINE DESCRIPTION?\",'Page 3'!B39)","v":"Strike Crew"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,180.0,{"$f":"IF('Page 3'!B40=\"\",\"LINE DESCRIPTION?\",'Page 3'!B40)","v":"Illustrator"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,null,"SUB-TOTAL F",null,null,null,null,null,null,null,{"$f":"SUM(K178:K190)","v":0}]
[null,null,"PT/P&W",null,null,null,null,null,null,null,{"$f":"SUMIF(PAYROLLLINE,\">=148\",PAYROLLPT_DLR)-SUMIF(PAYROLLLINE,\">=181\",PAYROLLPT_DLR)","v":0}]
[null,null,"TOTAL G",null,null,null,null,null,null,null,{"$f":"SUM(K191:K192)","v":0}]
[null,181.0,{"$f":"IF('Page 3'!B47=\"\",\"LINE DESCRIPTION?\",'Page 3'!B47)","v":"Set Dressing Purchases"},null,null,null,null,null,null,null,{"$f":"SUMIF(POLINE,B194:B205,POACTUAL)-SUMIF(REFUNDSLINE,B194:B205,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B194:B205,PAYROLLACTUAL)+SUMIF(PCLINE,B194:B205,PCACTUAL)","v":0}]
[null,182.0,{"$f":"IF('Page 3'!B48=\"\",\"LINE DESCRIPTION?\",'Page 3'!B48)","v":"Set Dressing Rentals"},null,null,null,null,null,null,null,0.0]
[null,183.0,{"$f":"IF('Page 3'!B49=\"\",\"LINE DESCRIPTION?\",'Page 3'!B49)","v":"Polaroid/Film/Developing"},null,null,null,null,null,null,null,0.0]
[null,184.0,{"$f":"IF('Page 3'!B50=\"\",\"LINE DESCRIPTION?\",'Page 3'!B50)","v":"Art Supplies"},null,null,null,null,null,null,null,0.0]
[null,185.0,{"$f":"IF('Page 3'!B51=\"\",\"LINE DESCRIPTION?\",'Page 3'!B51)","v":"Paint/Hardware"},null,null,null,null,null,null,null,0.0]
[null,186.0,{"$f":"IF('Page 3'!B52=\"\",\"LINE DESCRIPTION?\",'Page 3'!B52)","v":"Special effects"},null,null,null,null,null,null,null,0.0]
[null,187.0,{"$f":"IF('Page 3'!B53=\"\",\"LINE DESCRIPTION?\",'Page 3'!B53)","v":"Set Build"},null,null,null,null,null,null,null,0.0]
[null,188.0,{"$f":"IF('Page 3'!B54=\"\",\"LINE DESCRIPTION?\",'Page 3'!B54)","v":"Art Trucking"},null,null,null,null,null,null,null,0.0]
[null,189.0,{"$f":"IF('Page 3'!B55=\"\",\"LINE DESCRIPTION?\",'Page 3'!B55)","v":"Messengers/Deliveries"},null,null,null,null,null,null,null,0.0]
[null,190.0,{"$f":"IF('Page 3'!B56=\"\",\"LINE DESCRIPTION?\",'Page 3'!B56)","v":"Parking/Gasoline/Mileage"},null,null,null,null,null,null,null,0.0]
[null,191.0,{"$f":"IF('Page 3'!B57=\"\",\"LINE DESCRIPTION?\",'Page 3'!B57)","v":"Kit Rental"},null,null,null,null,null,null,null,0.0]
[null,192.0,{"$f":"IF('Page 3'!B58=\"\",\"LINE DESCRIPTION?\",'Page 3'!B58)","v":"Expendables"},null,null,null,null,null,null,null,0.0]
[null,null,"TOTAL H",null,null,null,null,null,null,null,{"$f":"SUM(K194:K205)","v":0}]
[null,193.0,{"$f":"IF('Page 4'!B6=\"\",\"LINE DESCRIPTION?\",'Page 4'!B6)","v":"Camera Rental"},null,null,null,null,null,null,null,{"$f":"SUMIF(POLINE,B207:B224,POACTUAL)-SUMIF(REFUNDSLINE,B207:B224,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B207:B224,PAYROLLACTUAL)+SUMIF(PCLINE,B207:B224,PCACTUAL)","v":0}]
[null,194.0,{"$f":"IF('Page 4'!B7=\"\",\"LINE DESCRIPTION?\",'Page 4'!B7)","v":"Sound Rental"},null,null,null,null,null,null,null,0.0]
[null,195.0,{"$f":"IF('Page 4'!B8=\"\",\"LINE DESCRIPTION?\",'Page 4'!B8)","v":"Lighting Rental"},null,null,null,null,null,null,null,0.0]
[null,196.0,{"$f":"IF('Page 4'!B9=\"\",\"LINE DESCRIPTION?\",'Page 4'!B9)","v":"Grip Rental"},null,null,null,null,null,null,null,0.0]
[null,197.0,{"$f":"IF('Page 4'!B10=\"\",\"LINE DESCRIPTION?\",'Page 4'!B10)","v":"Generator Rental"},null,null,null,null,null,null,null,0.0]
[null,198.0,{"$f":"IF('Page 4'!B11=\"\",\"LINE DESCRIPTION?\",'Page 4'!B11)","v":"Crane Rental"},null,null,null,null,null,null,null,0.0]
[null,199.0,{"$f":"IF('Page 4'!B12=\"\",\"LINE DESCRIPTION?\",'Page 4'!B12)","v":"VTR Rental"},null,null,null,null,null,null,null,0.0]
[null,200.0,{"$f":"IF('Page 4'!B13=\"\",\"LINE DESCRIPTION?\",'Page 4'!B13)","v":"Walkie Talkie Rental"},null,null,null,null,null,null,null,0.0]
[null,201.0,{"$f":"IF('Page 4'!B14=\"\",\"LINE DESCRIPTION?\",'Page 4'!B14)","v":"Dolly Rental"},null,null,null,null,null,null,null,0.0]
[null,202.0,{"$f":"IF('Page 4'!B15=\"\",\"LINE DESCRIPTION?\",'Page 4'!B15)","v":"Camera Car Rental"},null,null,null,null,null,null,null,0.0]
[null,203.0,{"$f":"IF('Page 4'!B16=\"\",\"LINE DESCRIPTION?\",'Page 4'!B16)","v":"Helicopter"},null,null,null,null,null,null,null,0.0]
[null,204.0,{"$f":"IF('Page 4'!B17=\"\",\"LINE DESCRIPTION?\",'Page 4'!B17)","v":"Production Supplies"},null,null,null,null,null,null,null,0.0]
[null,205.0,{"$f":"IF('Page 4'!B18=\"\",\"LINE DESCRIPTION?\",'Page 4'!B18)","v":"Construction Cranes"},null,null,null,null,null,null,null,0.0]
[null,206.0,{"$f":"IF('Page 4'!B19=\"\",\"LINE DESCRIPTION?\",'Page 4'!B19)","v":"Remote Head"},null,null,null,null,null,null,null,0.0]
[null,207.0,{"$f":"IF('Page 4'!B20=\"\",\"LINE DESCRIPTION?\",'Page 4'!B20)","v":"Special Camera Equipment"},null,null,null,null,null,null,null,0.0]
[null,208.0,{"$f":"IF('Page 4'!B21=\"\",\"LINE DESCRIPTION?\",'Page 4'!B21)","v":"Blue/Green Screen"},null,null,null,null,null,null,null,0.0]
[null,209.0,{"$f":"IF('Page 4'!B22=\"\",\"LINE DESCRIPTION?\",'Page 4'!B22)","v":"Expendables"},null,null,null,null,null,null,null,0.0]
[null,210.0,{"$f":"IF('Page 4'!B23=\"\",\"LINE DESCRIPTION?\",'Page 4'!B23)","v":"Steadicam"},null,null,null,null,null,null,null,0.0]
[null,null,"TOTAL I",null,null,null,null,null,null,null,{"$f":"SUM(K207:K224)","v":0}]
[null,211.0,{"$f":"IF('Page 4'!B28=\"\",\"LINE DESCRIPTION?\",'Page 4'!B28)","v":"Purchase Filmstock"},null,null,null,null,null,null,null,{"$f":"SUMIF(POLINE,B226:B231,POACTUAL)-SUMIF(REFUNDSLINE,B226:B231,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B226:B231,PAYROLLACTUAL)+SUMIF(PCLINE,B226:B231,PCACTUAL)","v":0}]
[null,212.0,{"$f":"IF('Page 4'!B29=\"\",\"LINE DESCRIPTION?\",'Page 4'!B29)","v":"Develop Filmstock"},null,null,null,null,null,null,null,0.0]
[null,213.0,{"$f":"IF('Page 4'!B30=\"\",\"LINE DESCRIPTION?\",'Page 4'!B30)","v":"Hard Drives/Tapes"},null,null,null,null,null,null,null,0.0]
[null,214.0,{"$f":"IF('Page 4'!B31=\"\",\"LINE DESCRIPTION?\",'Page 4'!B31)","v":"HD MOS Video Dailies"},null,null,null,null,null,null,null,0.0]
[null,215.0,{"$f":"IF('Page 4'!B32=\"\",\"LINE DESCRIPTION?\",'Page 4'!B32)","v":"SD MOS Video Dallies"},null,null,null,null,null,null,null,0.0]
[null,216.0,{"$f":"IF('Page 4'!B33=\"\",\"LINE DESCRIPTION?\",'Page 4'!B33)","v":"Transcoding"},null,null,null,null,null,null,null,0.0]
[null,null,"TOTAL J",null,null,null,null,null,null,null,{"$f":"SUM(K226:K231)","v":0}]
[null,217.0,{"$f":"IF('Page 4'!B38=\"\",\"LINE DESCRIPTION?\",'Page 4'!B38)","v":"Petty Cash "},null,null,null,null,null,null,null,{"$f":"SUMIF(POLINE,B233:B242,POACTUAL)-SUMIF(REFUNDSLINE,B233:B242,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B233:B242,PAYROLLACTUAL)+SUMIF(PCLINE,B233:B242,PCACTUAL)","v":0}]
[null,218.0,{"$f":"IF('Page 4'!B39=\"\",\"LINE DESCRIPTION?\",'Page 4'!B39)","v":"Air Shipping and Carriers"},null,null,null,null,null,null,null,0.0]
[null,219.0,{"$f":"IF('Page 4'!B40=\"\",\"LINE DESCRIPTION?\",'Page 4'!B40)","v":"Phones and Cables"},null,null,null,null,null,null,null,0.0]
[null,220.0,{"$f":"IF('Page 4'!B41=\"\",\"LINE DESCRIPTION?\",'Page 4'!B41)","v":"Cash Under $15 Each"},null,null,null,null,null,null,null,0.0]
[null,221.0,{"$f":"IF('Page 4'!B42=\"\",\"LINE DESCRIPTION?\",'Page 4'!B42)","v":"Internal Billing Costs                                               "},null,null,null,null,null,null,null,0.0]
[null,222.0,{"$f":"IF('Page 4'!B43=\"\",\"LINE DESCRIPTION?\",'Page 4'!B43)","v":"Special Insurance"},null,null,null,null,null,null,null,0.0]
[null,223.0,{"$f":"IF('Page 4'!B44=\"\",\"LINE DESCRIPTION?\",'Page 4'!B44)","v":"Foreign Work Comp"},null,null,null,null,null,null,null,0.0]
[null,224.0,{"$f":"IF('Page 4'!B45=\"\",\"LINE DESCRIPTION?\",'Page 4'!B45)","v":"Negative/Dailies Shipping"},null,null,null,null,null,null,null,0.0]
[null,225.0,{"$f":"IF('Page 4'!B46=\"\",\"LINE DESCRIPTION?\",'Page 4'!B46)","v":"Glam Squad Agents fees"},null,null,null,null,null,null,null,0.0]
[null,226.0,{"$f":"IF('Page 4'!B47=\"\",\"LINE DESCRIPTION?\",'Page 4'!B47)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,null,"TOTAL K",null,null,null,null,null,null,null,{"$f":"SUM(K233:K242)","v":0}]
[null,227.0,{"$f":"IF('Page 4'!B52=\"\",\"LINE DESCRIPTION?\",'Page 4'!B52)","v":"Director Prep"},null,null,null,null,null,null,null,{"$f":"SUMIF(POLINE,B244:B250,POACTUAL)-SUMIF(REFUNDSLINE,B244:B250,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B244:B250,PAYROLLACTUAL)+SUMIF(PCLINE,B244:B250,PCACTUAL)","v":0}]
[null,228.0,{"$f":"IF('Page 4'!B53=\"\",\"LINE DESCRIPTION?\",'Page 4'!B53)","v":"Director Travel"},null,null,null,null,null,null,null,0.0]
[null,229.0,{"$f":"IF('Page 4'!B54=\"\",\"LINE DESCRIPTION?\",'Page 4'!B54)","v":"Director Shoot"},null,null,null,null,null,null,null,0.0]
[null,230.0,{"$f":"IF('Page 4'!B55=\"\",\"LINE DESCRIPTION?\",'Page 4'!B55)","v":"Director Post"},null,null,null,null,null,null,null,0.0]
[null,231.0,{"$f":"IF('Page 4'!B56=\"\",\"LINE DESCRIPTION?\",'Page 4'!B56)","v":"Fringes"},null,null,null,null,null,null,null,0.0]
[null,232.0,{"$f":"IF('Page 4'!B57=\"\",\"LINE DESCRIPTION?\",'Page 4'!B57)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,233.0,{"$f":"IF('Page 4'!B58=\"\",\"LINE DESCRIPTION?\",'Page 4'!B58)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,null,"SUB-TOTAL L",null,null,null,null,null,null,null,{"$f":"SUM(K244:K250)","v":0}]
[null,null,"PT/P&W",null,null,null,null,null,null,null,{"$f":"SUMIF(PAYROLLLINE,\">=227\",PAYROLLPT_DLR)-SUMIF(PAYROLLLINE,\">=234\",PAYROLLPT_DLR)","v":0}]
[null,null,"TOTAL L",null,null,null,null,null,null,null,{"$f":"SUM(K251:K252)","v":0}]
[null,234.0,{"$f":"IF('Page 5'!B7=\"\",\"LINE DESCRIPTION?\",'Page 5'!B7)","v":"O/C Principals"},{"$f":"SUMIF(PAYROLLLINE,B254:B285,PAYROLLAMOUNT)","v":0},{"$f":"IF(D254:D285=0,0,SUMIF(PAYROLLLINE,B254:B285,PAYROLLST)/D254:D285)","v":0},{"$f":"SUMIF(PAYROLLLINE,B254:B285,PAYROLLOTHRS)","v":0},{"$f":"SUMIF(PAYROLLLINE,B254:B285,PAYROLLST)","v":0},{"$f":"SUMIF(PAYROLLLINE,B254:B285,PAYROLLOT)","v":0},{"$f":"SUMIF(PAYROLLLINE,B254:B285,PAYROLLMISCT)+SUMIF(PAYROLLLINE,B254:B285,PAYROLLMISCNT)","v":0},{"$f":"SUMIF(POLINE,B254:B285,POACTUAL)-SUMIF(REFUNDSLINE,B254:B285,REFUNDSACTUAL)+SUMIF(PCLINE,B254:B285,PCACTUAL)","v":0},{"$f":"SUMIF(POLINE,B254:B285,POACTUAL)-SUMIF(REFUNDSLINE,B254:B285,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B254:B285,PAYROLLACTUAL)+SUMIF(PCLINE,B254:B285,PCACTUAL)","v":0}]
[null,235.0,{"$f":"IF('Page 5'!B8=\"\",\"LINE DESCRIPTION?\",'Page 5'!B8)","v":"O/C Principals"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,236.0,{"$f":"IF('Page 5'!B9=\"\",\"LINE DESCRIPTION?\",'Page 5'!B9)","v":"O/C Principals"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,237.0,{"$f":"IF('Page 5'!B10=\"\",\"LINE DESCRIPTION?\",'Page 5'!B10)","v":"O/C Principals"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,238.0,{"$f":"IF('Page 5'!B11=\"\",\"LINE DESCRIPTION?\",'Page 5'!B11)","v":"O/C Principals"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,239.0,{"$f":"IF('Page 5'!B12=\"\",\"LINE DESCRIPTION?\",'Page 5'!B12)","v":"O/C Principals"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,240.0,{"$f":"IF('Page 5'!B13=\"\",\"LINE DESCRIPTION?\",'Page 5'!B13)","v":"O/C Principals"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,241.0,{"$f":"IF('Page 5'!B14=\"\",\"LINE DESCRIPTION?\",'Page 5'!B14)","v":"O/C Principals"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,242.0,{"$f":"IF('Page 5'!B15=\"\",\"LINE DESCRIPTION?\",'Page 5'!B15)","v":"O/C Principals"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,243.0,{"$f":"IF('Page 5'!B16=\"\",\"LINE DESCRIPTION?\",'Page 5'!B16)","v":"O/C Principals"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,244.0,{"$f":"IF('Page 5'!B17=\"\",\"LINE DESCRIPTION?\",'Page 5'!B17)","v":"LINE DESCRIPTION?"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,245.0,{"$f":"IF('Page 5'!B18=\"\",\"LINE DESCRIPTION?\",'Page 5'!B18)","v":"LINE DESCRIPTION?"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,246.0,{"$f":"IF('Page 5'!B19=\"\",\"LINE DESCRIPTION?\",'Page 5'!B19)","v":"LINE DESCRIPTION?"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,247.0,{"$f":"IF('Page 5'!B20=\"\",\"LINE DESCRIPTION?\",'Page 5'!B20)","v":"General Extras"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,248.0,{"$f":"IF('Page 5'!B21=\"\",\"LINE DESCRIPTION?\",'Page 5'!B21)","v":"General Extras"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,249.0,{"$f":"IF('Page 5'!B22=\"\",\"LINE DESCRIPTION?\",'Page 5'!B22)","v":"General Extras"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,250.0,{"$f":"IF('Page 5'!B23=\"\",\"LINE DESCRIPTION?\",'Page 5'!B23)","v":"General Extras"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,251.0,{"$f":"IF('Page 5'!B24=\"\",\"LINE DESCRIPTION?\",'Page 5'!B24)","v":"General Extras"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,252.0,{"$f":"IF('Page 5'!B25=\"\",\"LINE DESCRIPTION?\",'Page 5'!B25)","v":"General Extras"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,253.0,{"$f":"IF('Page 5'!B26=\"\",\"LINE DESCRIPTION?\",'Page 5'!B26)","v":"LINE DESCRIPTION?"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,254.0,{"$f":"IF('Page 5'!B27=\"\",\"LINE DESCRIPTION?\",'Page 5'!B27)","v":"LINE DESCRIPTION?"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,255.0,{"$f":"IF('Page 5'!B28=\"\",\"LINE DESCRIPTION?\",'Page 5'!B28)","v":"LINE DESCRIPTION?"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,256.0,{"$f":"IF('Page 5'!B29=\"\",\"LINE DESCRIPTION?\",'Page 5'!B29)","v":"Hand Models"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,257.0,{"$f":"IF('Page 5'!B30=\"\",\"LINE DESCRIPTION?\",'Page 5'!B30)","v":"LINE DESCRIPTION?"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,258.0,{"$f":"IF('Page 5'!B31=\"\",\"LINE DESCRIPTION?\",'Page 5'!B31)","v":"LINE DESCRIPTION?"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,259.0,{"$f":"IF('Page 5'!B32=\"\",\"LINE DESCRIPTION?\",'Page 5'!B32)","v":"Voice Over"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,260.0,{"$f":"IF('Page 5'!B33=\"\",\"LINE DESCRIPTION?\",'Page 5'!B33)","v":"Fitting Fees"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,261.0,{"$f":"IF('Page 5'!B34=\"\",\"LINE DESCRIPTION?\",'Page 5'!B34)","v":"Fitting Fees"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,262.0,{"$f":"IF('Page 5'!B35=\"\",\"LINE DESCRIPTION?\",'Page 5'!B35)","v":"LINE DESCRIPTION?"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,263.0,{"$f":"IF('Page 5'!B36=\"\",\"LINE DESCRIPTION?\",'Page 5'!B36)","v":"Audition Fees"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,264.0,{"$f":"IF('Page 5'!B37=\"\",\"LINE DESCRIPTION?\",'Page 5'!B37)","v":"Audition Fees"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,265.0,{"$f":"IF('Page 5'!B38=\"\",\"LINE DESCRIPTION?\",'Page 5'!B38)","v":"LINE DESCRIPTION?"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,null,"SUB-TOTAL M",null,null,null,null,null,null,null,{"$f":"SUM(K254:K285)","v":0}]
[null,null,"PT/P&W",null,null,null,null,null,null,null,{"$f":"SUMIF(PAYROLLLINE,\">=234\",PAYROLLPT_DLR)-SUMIF(PAYROLLLINE,\">=266\",PAYROLLPT_DLR)","v":0}]
[null,266.0,{"$f":"IF('Page 5'!B41=\"\",\"LINE DESCRIPTION?\",'Page 5'!B41)","v":"Talent Agency Fees"},null,null,null,null,null,null,null,{"$f":"SUMIF(POLINE,B288:B291,POACTUAL)-SUMIF(REFUNDSLINE,B288:B291,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B288:B291,PAYROLLACTUAL)+SUMIF(PCLINE,B288:B291,PCACTUAL)","v":0}]
[null,267.0,{"$f":"IF('Page 5'!B42=\"\",\"LINE DESCRIPTION?\",'Page 5'!B42)","v":"Talent Payroll Service"},null,null,null,null,null,null,null,0.0]
[null,268.0,{"$f":"IF('Page 5'!B43=\"\",\"LINE DESCRIPTION?\",'Page 5'!B43)","v":"Talent Wardrobe Allowance"},null,null,null,null,null,null,null,0.0]
[null,269.0,{"$f":"IF('Page 5'!B44=\"\",\"LINE DESCRIPTION?\",'Page 5'!B44)","v":"Other "},null,null,null,null,null,null,null,0.0]
[null,270.0,"For Markup Only. Do Not Use.",null,null,null,null,null,null,null,{"$f":"'Page 5'!N45","v":0}]
[null,null,"TOTAL M",null,null,null,null,null,null,null,{"$f":"SUM(K286:K292)","v":0}]
[null,271.0,{"$f":"IF('Page 5'!B50=\"\",\"LINE DESCRIPTION?\",'Page 5'!B50)","v":"Talent Air Fares"},null,null,null,null,null,null,null,{"$f":"SUMIF(POLINE,B294:B298,POACTUAL)-SUMIF(REFUNDSLINE,B294:B298,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B294:B298,PAYROLLACTUAL)+SUMIF(PCLINE,B294:B298,PCACTUAL)","v":0}]
[null,272.0,{"$f":"IF('Page 5'!B51=\"\",\"LINE DESCRIPTION?\",'Page 5'!B51)","v":"Talent Per Diem"},null,null,null,null,null,null,null,0.0]
[null,273.0,{"$f":"IF('Page 5'!B52=\"\",\"LINE DESCRIPTION?\",'Page 5'!B52)","v":"Talent Ground Transportation"},null,null,null,null,null,null,null,0.0]
[null,274.0,{"$f":"IF('Page 5'!B53=\"\",\"LINE DESCRIPTION?\",'Page 5'!B53)","v":"Other"},null,null,null,null,null,null,null,0.0]
[null,275.0,{"$f":"IF('Page 5'!B54=\"\",\"LINE DESCRIPTION?\",'Page 5'!B54)","v":"Other"},null,null,null,null,null,null,null,0.0]
[null,276.0,"For Markup Only. Do Not Use.",null,null,null,null,null,null,null,{"$f":"'Page 5'!N55","v":0}]
[null,null,"TOTAL N",null,null,null,null,null,null,null,{"$f":"SUM(K294:K299)","v":0}]
[null,277.0,{"$f":"IF('Page 6'!B6=\"\",\"LINE DESCRIPTION?\",'Page 6'!B6)","v":"Post Supervisor"},null,null,null,null,null,null,null,{"$f":"SUMIF(POLINE,B301:B305,POACTUAL)-SUMIF(REFUNDSLINE,B301:B305,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B301:B305,PAYROLLACTUAL)+SUMIF(PCLINE,B301:B305,PCACTUAL)","v":0}]
[null,278.0,{"$f":"IF('Page 6'!B7=\"\",\"LINE DESCRIPTION?\",'Page 6'!B7)","v":"Off-line Editor"},null,null,null,null,null,null,null,0.0]
[null,279.0,{"$f":"IF('Page 6'!B8=\"\",\"LINE DESCRIPTION?\",'Page 6'!B8)","v":"Assistant Editor"},null,null,null,null,null,null,null,0.0]
[null,280.0,{"$f":"IF('Page 6'!B9=\"\",\"LINE DESCRIPTION?\",'Page 6'!B9)","v":"Avid Rental"},null,null,null,null,null,null,null,0.0]
[null,281.0,{"$f":"IF('Page 6'!B10=\"\",\"LINE DESCRIPTION?\",'Page 6'!B10)","v":"Miscellaneous"},null,null,null,null,null,null,null,0.0]
[null,null,"SUB-TOTAL O",null,null,null,null,null,null,null,{"$f":"SUM(K301:K305)","v":0}]
[null,null,"PT/P&W",null,null,null,null,null,null,null,{"$f":"SUMIF(PAYROLLLINE,\">=277\",PAYROLLPT_DLR)-SUMIF(PAYROLLLINE,\">=282\",PAYROLLPT_DLR)","v":0}]
[null,null,"TOTAL O",null,null,null,null,null,null,null,{"$f":"SUM(K306:K307)","v":0}]
[null,282.0,{"$f":"IF('Page 6'!B16=\"\",\"LINE DESCRIPTION?\",'Page 6'!B16)","v":"Airport Transfers"},null,null,null,null,null,null,null,{"$f":"SUMIF(POLINE,B309:B356,POACTUAL)-SUMIF(REFUNDSLINE,B309:B356,REFUNDSACTUAL)+SUMIF(PAYROLLLINE,B309:B356,PAYROLLACTUAL)+SUMIF(PCLINE,B309:B356,PCACTUAL)","v":0}]
[null,283.0,{"$f":"IF('Page 6'!B17=\"\",\"LINE DESCRIPTION?\",'Page 6'!B17)","v":"Local Production Office & Conference Room"},null,null,null,null,null,null,null,0.0]
[null,284.0,{"$f":"IF('Page 6'!B18=\"\",\"LINE DESCRIPTION?\",'Page 6'!B18)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,285.0,{"$f":"IF('Page 6'!B19=\"\",\"LINE DESCRIPTION?\",'Page 6'!B19)","v":"Director"},null,null,null,null,null,null,null,0.0]
[null,286.0,{"$f":"IF('Page 6'!B20=\"\",\"LINE DESCRIPTION?\",'Page 6'!B20)","v":"Airfare"},null,null,null,null,null,null,null,0.0]
[null,287.0,{"$f":"IF('Page 6'!B21=\"\",\"LINE DESCRIPTION?\",'Page 6'!B21)","v":"Hotel/Per Diem"},null,null,null,null,null,null,null,0.0]
[null,288.0,{"$f":"IF('Page 6'!B22=\"\",\"LINE DESCRIPTION?\",'Page 6'!B22)","v":"Producer"},null,null,null,null,null,null,null,0.0]
[null,289.0,{"$f":"IF('Page 6'!B23=\"\",\"LINE DESCRIPTION?\",'Page 6'!B23)","v":"Airfare"},null,null,null,null,null,null,null,0.0]
[null,290.0,{"$f":"IF('Page 6'!B24=\"\",\"LINE DESCRIPTION?\",'Page 6'!B24)","v":"Hotel/Per Diem"},null,null,null,null,null,null,null,0.0]
[null,291.0,{"$f":"IF('Page 6'!B25=\"\",\"LINE DESCRIPTION?\",'Page 6'!B25)","v":"Director of Photography"},null,null,null,null,null,null,null,0.0]
[null,292.0,{"$f":"IF('Page 6'!B26=\"\",\"LINE DESCRIPTION?\",'Page 6'!B26)","v":"Airfare"},null,null,null,null,null,null,null,0.0]
[null,293.0,{"$f":"IF('Page 6'!B27=\"\",\"LINE DESCRIPTION?\",'Page 6'!B27)","v":"Hotel/Per Diem"},null,null,null,null,null,null,null,0.0]
[null,294.0,{"$f":"IF('Page 6'!B28=\"\",\"LINE DESCRIPTION?\",'Page 6'!B28)","v":"Production Designer"},null,null,null,null,null,null,null,0.0]
[null,295.0,{"$f":"IF('Page 6'!B29=\"\",\"LINE DESCRIPTION?\",'Page 6'!B29)","v":"Airfare"},null,null,null,null,null,null,null,0.0]
[null,296.0,{"$f":"IF('Page 6'!B30=\"\",\"LINE DESCRIPTION?\",'Page 6'!B30)","v":"Hotel/Per Diem"},null,null,null,null,null,null,null,0.0]
[null,297.0,{"$f":"IF('Page 6'!B31=\"\",\"LINE DESCRIPTION?\",'Page 6'!B31)","v":"1AD"},null,null,null,null,null,null,null,0.0]
[null,298.0,{"$f":"IF('Page 6'!B32=\"\",\"LINE DESCRIPTION?\",'Page 6'!B32)","v":"Airfare"},null,null,null,null,null,null,null,0.0]
[null,299.0,{"$f":"IF('Page 6'!B33=\"\",\"LINE DESCRIPTION?\",'Page 6'!B33)","v":"Hotel/Per Diem"},null,null,null,null,null,null,null,0.0]
[null,300.0,{"$f":"IF('Page 6'!B34=\"\",\"LINE DESCRIPTION?\",'Page 6'!B34)","v":"Stylist"},null,null,null,null,null,null,null,0.0]
[null,301.0,{"$f":"IF('Page 6'!B35=\"\",\"LINE DESCRIPTION?\",'Page 6'!B35)","v":"Airfare"},null,null,null,null,null,null,null,0.0]
[null,302.0,{"$f":"IF('Page 6'!B36=\"\",\"LINE DESCRIPTION?\",'Page 6'!B36)","v":"Hotel/Per Diem"},null,null,null,null,null,null,null,0.0]
[null,303.0,{"$f":"IF('Page 6'!B37=\"\",\"LINE DESCRIPTION?\",'Page 6'!B37)","v":"PM"},null,null,null,null,null,null,null,0.0]
[null,304.0,{"$f":"IF('Page 6'!B38=\"\",\"LINE DESCRIPTION?\",'Page 6'!B38)","v":"Airfare"},null,null,null,null,null,null,null,0.0]
[null,305.0,{"$f":"IF('Page 6'!B39=\"\",\"LINE DESCRIPTION?\",'Page 6'!B39)","v":"Hotel/Per Diem"},null,null,null,null,null,null,null,0.0]
[null,306.0,{"$f":"IF('Page 6'!B40=\"\",\"LINE DESCRIPTION?\",'Page 6'!B40)","v":"AC/Gaffer/Grip"},null,null,null,null,null,null,null,0.0]
[null,307.0,{"$f":"IF('Page 6'!B41=\"\",\"LINE DESCRIPTION?\",'Page 6'!B41)","v":"Airfare"},null,null,null,null,null,null,null,0.0]
[null,308.0,{"$f":"IF('Page 6'!B42=\"\",\"LINE DESCRIPTION?\",'Page 6'!B42)","v":"Hotel/Per Diem"},null,null,null,null,null,null,null,0.0]
[null,309.0,{"$f":"IF('Page 6'!B43=\"\",\"LINE DESCRIPTION?\",'Page 6'!B43)","v":"SFX Supervisor"},null,null,null,null,null,null,null,0.0]
[null,310.0,{"$f":"IF('Page 6'!B44=\"\",\"LINE DESCRIPTION?\",'Page 6'!B44)","v":"Airfare"},null,null,null,null,null,null,null,0.0]
[null,311.0,{"$f":"IF('Page 6'!B45=\"\",\"LINE DESCRIPTION?\",'Page 6'!B45)","v":"Hotel/Per Diem"},null,null,null,null,null,null,null,0.0]
[null,312.0,{"$f":"IF('Page 6'!B46=\"\",\"LINE DESCRIPTION?\",'Page 6'!B46)","v":"Postproduction Supervisor"},null,null,null,null,null,null,null,0.0]
[null,313.0,{"$f":"IF('Page 6'!B47=\"\",\"LINE DESCRIPTION?\",'Page 6'!B47)","v":"Airfare"},null,null,null,null,null,null,null,0.0]
[null,314.0,{"$f":"IF('Page 6'!B48=\"\",\"LINE DESCRIPTION?\",'Page 6'!B48)","v":"Hotel/Per Diem"},null,null,null,null,null,null,null,0.0]
[null,315.0,{"$f":"IF('Page 6'!B49=\"\",\"LINE DESCRIPTION?\",'Page 6'!B49)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,316.0,{"$f":"IF('Page 6'!B50=\"\",\"LINE DESCRIPTION?\",'Page 6'!B50)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,317.0,{"$f":"IF('Page 6'!B51=\"\",\"LINE DESCRIPTION?\",'Page 6'!B51)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,318.0,{"$f":"IF('Page 6'!B52=\"\",\"LINE DESCRIPTION?\",'Page 6'!B52)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,319.0,{"$f":"IF('Page 6'!B53=\"\",\"LINE DESCRIPTION?\",'Page 6'!B53)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,320.0,{"$f":"IF('Page 6'!B54=\"\",\"LINE DESCRIPTION?\",'Page 6'!B54)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,321.0,{"$f":"IF('Page 6'!B55=\"\",\"LINE DESCRIPTION?\",'Page 6'!B55)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,322.0,{"$f":"IF('Page 6'!B56=\"\",\"LINE DESCRIPTION?\",'Page 6'!B56)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,323.0,{"$f":"IF('Page 6'!B57=\"\",\"LINE DESCRIPTION?\",'Page 6'!B57)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,324.0,{"$f":"IF('Page 6'!B58=\"\",\"LINE DESCRIPTION?\",'Page 6'!B58)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,325.0,{"$f":"IF('Page 6'!B59=\"\",\"LINE DESCRIPTION?\",'Page 6'!B59)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,326.0,{"$f":"IF('Page 6'!B60=\"\",\"LINE DESCRIPTION?\",'Page 6'!B60)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,327.0,{"$f":"IF('Page 6'!B61=\"\",\"LINE DESCRIPTION?\",'Page 6'!B61)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,328.0,{"$f":"IF('Page 6'!B62=\"\",\"LINE DESCRIPTION?\",'Page 6'!B62)","v":"LINE DESCRIPTION?"},null,null,null,null,null,null,null,0.0]
[null,329.0,{"$f":"IF('Page 6'!B63=\"\",\"LINE DESCRIPTION?\",'Page 6'!B63)","v":"Travel  Handling Fee (P)"},null,null,null,null,null,null,null,0.0]
[null,null,"TOTAL P",null,null,null,null,null,null,null,{"$f":"SUM(K309:K356)","v":0}]
[null,"PC","PETTY CASH LOG",null,null,null,null,null,null,null,{"$f":"SUMIF(POLINE,\"=PC\",POACTUAL)","v":0}]
[null,"PR","PAYROLL LOG",null,null,null,null,null,null,null,{"$f":"SUMIF(POLINE,\"=PR\",POACTUAL)","v":0}]

{"sheet":"Launch Box","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Client Info Box","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Print Sheets","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Travel","index":4,"n_rows":87,"n_cols":35,"rows_kept":87,"cut":false,"hidden":false,"merged":[[1,1,1,2],[5,25,5,26],[5,27,5,28],[5,29,5,30]]}
[]
[null,"TYPE OF DAY"]
[null,"T = Travel / P = Prep / TS = Tech Scout / D = Down"]
[null,"B = Build / PL = Pre-light / S = Shoot / W = Wrap"]
[]
[null,null,null,"Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","TOTAL","Car Rentals",null,"Travel Fares",null,"Hotels/Per Diem",null,"TOTAL","TOTAL","TOTAL"]
[null,"Name","Title","2000-02-01","2000-02-02","2000-02-03","2000-02-04","2000-02-05","2000-02-06","2000-02-07","2000-02-08","2000-02-09","2000-02-10","2000-02-11","2000-02-12","2000-02-13","2000-02-14","2000-02-15","2000-02-16","2000-02-17","2000-02-18","2000-02-19","2000-02-20","2000-02-21","DAYS","No.","Cost","No.","Cost","No.","Cost","Car","Fare","Hotel/PD"]
[null,null,"Director",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(D8:X8)","v":0},1.0,500.0,null,null,null,null,{"$f":"Z8*AA8","v":500},{"$f":"AB8*AC8","v":0},{"$f":"AD8*AE8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Line Producer",null,null,null,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,0,0,0]
[null,null,"Assistant Director",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Director of Photography",null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,0,0,0]
[null,null,"Camera Operator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Assistant Camera",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"2nd AC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Art Director",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Asst. Art Director",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Prop Master",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Assistant Props",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Gaffer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Best Boy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"3rd Electrician",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Add'l Electricians",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Grip/Electric Driver",null,null,null,null,null,null,null,null,null,null,null,null,null,"T","PL","S","S","S","T",null,null,6,null,null,null,null,null,null,0,0,0]
[null,null,"Key Grip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"2nd Grip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"3rd Grip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Add'l Grips",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Sound Mixer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Boom Operator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Sound Utility",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Playback",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Make-up",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Hair",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Stylist",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Wardrobe ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Script Supervisor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Home Economist",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"VTR Operator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Effects",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Scenics",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Teleprompter Op",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Generator Operator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Location Scout",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Production Manager",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"2nd AD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Nurse/1st Aid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Food PA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Firemen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Policemen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Welfare/Teacher",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Teamsters/Drivers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Caterer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Coordinator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"PA's",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Construction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Carpenters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Set Decorator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Leadperson",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Dresser",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Swing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Scenics",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Teamsters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Strike Crew",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Art Assistants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Talent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Talent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Talent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"Talent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,1.0,500.0,null,null,0,500,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,1.0,300.0,0,0,300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0]
[null,null,"TOTALS",{"$f":"COUNTA(D8:D83)","v":0},0,0,1,1,2,2,2,2,2,1,0,0,1,1,1,1,1,1,0,0,{"$f":"SUM(Y8:Y83)","v":19},1,{"$f":"IF(Z84=0,0,AF84/Z84)","v":500},{"$f":"SUM(AB8:AB83)","v":1},{"$f":"IF(AB84=0,0,AG84/AB84)","v":500},{"$f":"SUM(AD8:AD83)","v":1},{"$f":"IF(AD84=0,0,AH84/AD84)","v":300},{"$f":"SUM(AF8:AF83)","v":500},500,300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",null,"Average",null,"Average",null,"sub-total",{"$f":"AF84+AG84+AH84","v":1300}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"handling fee",{"$f":"AH85*AI86","v":195},0.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRAND TOTAL",{"$f":"AH85+AH86","v":1495}]

{"sheet":"Calendar","index":5,"n_rows":45,"n_cols":16,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,9,1,15]]}
[]
[null,"NOVEMBER",null,null,null,null,null,null,null,"DECEMBER"]
[]
[null,"SUNDAY","MONDAY","TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY",null,"SUNDAY","MONDAY","TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
[null,"2000-10-29","2000-10-30","2000-10-31","2000-11-01","2000-11-02","2000-11-03","2000-11-04",null,"2000-11-26","2000-11-27","2000-11-28","2000-11-29","2000-11-30","2000-12-01","2000-12-02"]
[]
[]
[]
[]
[]
[]
[]
[null,"2000-11-05","2000-11-06","2000-11-07","2000-11-08","2000-11-09","2000-11-10","2000-11-11",null,"2000-12-03","2000-12-04","2000-12-05","2000-12-06","2000-12-07","2000-12-08","2000-12-09"]
[]
[]
[]
[]
[]
[]
[]
[null,"2000-11-12","2000-11-13","2000-11-14","2000-11-15","2000-11-16","2000-11-17","2000-11-18",null,"2000-12-10","2000-12-11","2000-12-12","2000-12-13","2000-12-14","2000-12-15","2000-12-16"]
[]
[]
[]
[]
[]
[]
[]
[null,"2000-11-19","2000-11-20","2000-11-21","2000-11-22","2000-11-23","2000-11-24","2000-11-25",null,"2000-12-17","2000-12-18","2000-12-19","2000-12-20","2000-12-21","2000-12-22","2000-12-23"]
[]
[]
[]
[]
[]
[]
[]
[null,"2000-11-26","2000-11-27","2000-11-28","2000-11-29","2000-11-30","2000-12-01","2000-12-02",null,"2000-12-24","2000-12-25","2000-12-26","2000-12-27","2000-12-28","2000-12-29","2000-12-30"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"2000-12-31"]

{"sheet":"Job Report","index":6,"n_rows":60,"n_cols":13,"rows_kept":60,"cut":false,"hidden":false,"merged":[[43,2,43,8],[53,1,53,4],[53,6,53,10],[58,6,58,10],[59,6,59,10],[1,1,1,10],[7,1,7,10],[12,1,12,10],[17,1,17,10],[35,1,35,10],[36,1,36,10],[41,1,41,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"J O B  R E P O R T"]
[null,{"$f":"IF('Top Sheet'!C5=\"\",\"\",'Top Sheet'!C5)","v":""}]
[null,{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$15=\"\",\"\",'Top Sheet'!$L$15),IF('Top Sheet'!$L$12=\"\",\"\",'Top Sheet'!$L$12))","v":""}]
[null,{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$16=\"\",\"\",'Top Sheet'!$L$16),IF('Top Sheet'!$L$13=\"\",\"\",'Top Sheet'!$L$13))","v":""}]
[null,{"$f":"IF('Top Sheet'!$C$10=\"\",\"\",\"Job #: \"&'Top Sheet'!$C$10)","v":""}]
[]
[null,"RECONCILIATION"]
[]
[]
[null,null,null,null,null,null,null,"Difference between Logs and Actual Budget",null,{"$f":"IF(A_TOTAL_GRAND=0,\"\",ROUND(('Purchase Order Log'!F30-'Petty Cash Log'!H24-'Payroll Log'!P32-'Sales Log'!E19+'Payroll Log'!P29+'Payroll Log'!R29+'Petty Cash Log'!H19+A_TOTAL_INS+TOTAL_MARKUP)-'Top Sheet'!O47,2))","v":""}]
[]
[null,{"$f":"IF(A_TOTAL_GRAND=0,\"\",IF(J11=\"\",\"\",(IF(J11=0,\"The logs and the actual budget are reconciled.\",(IF(J11>0,\"There are more costs in the logs than in the actual budget.\",\"There are more costs in the actual budget than in the logs.\"))))))","v":""}]
[]
[]
[]
[]
[null,"MARKUP AND INSURANCE"]
[]
[null,null,null,null,"Show",null,"Show"]
[]
[null,null,null,null,"MARKUP",null,"INSURANCE",null,null,{"$f":"IF(Markup_Show=\"Hide\",EST_TOTAL_MARKUP+OVERAGE_MARKUP,'Top Sheet'!L38+'Top Sheet'!L41+E_TOTAL_TALENTMARKUP+E_TOTAL_TALENTEXPENSESMARKUP)","v":"#REF!"},"Est Markup"]
[]
[null,null,"Production  (A to K)",null,0.0,"%",0.0,"%",null,{"$f":"IF(A_TOTAL_GRAND=0, ,A_TOTAL_MARKUP+A_TOTAL_POSTMARKUP+E_TOTAL_TALENTMARKUP+E_TOTAL_TALENTEXPENSESMARKUP)","v":""},"Act Markup"]
[]
[null,null,"Director/Creative Fees  (L)",null,0.0,"%",0.0,"%",null,{"$f":"IF(A_TOTAL_GRAND=0,0,OVER_UNDER)","v":0},"Over / (Under)"]
[]
[null,null,"Talent  (M)",null,0.0,"%",0.0,"%",null,"Show this markup on Page 5 Line 270"]
[]
[null,null,"Talent Expenses  (N)",null,0.0,"%",0.0,"%","X","Show this markup on Page 5 Line 276"]
[]
[null,null,"Editorial and Finishing  (O and P)",null,0.0,"%",0.0,"%",null,"Show this markup on Top Sheet Line 16"]
[]
[null,null,0.0," Based On",0.0,"%",0.0,"%"]
[]
[null,{"$f":"IF(Markup_Show=\"Hide\",\"All markup is hidden on the Top Sheet.\",\"All markup is shown on Top Sheet Line 13 as the Production Fee unless otherwise noted above.\")","v":"All markup is shown on Top Sheet Line 13 as the Production Fee unless otherwise noted above."}]
[null,{"$f":"IF(Ins_Show=\"Hide\",\"Insurance is hidden on the Top Sheet.\",\"Insurance is on Top Sheet Line 11.\")","v":"Insurance is on Top Sheet Line 11."}]
[]
[]
[]
[]
[null,"DETAIL OF ADDITIONAL BILLINGS"]
[]
[null,"No.","Description",null,null,null,null,null,null,"Markup","TOTAL BILLED","Row"]
[null,null,null,null,null,null,null,null,null,null,null,1.0]
[null,null,null,null,null,null,null,null,null,null,null,2.0]
[null,null,null,null,null,null,null,null,null,null,null,3.0]
[null,null,null,null,null,null,null,null,null,null,null,4.0]
[null,null,null,null,null,null,null,null,null,null,null,5.0]
[]
[null,null,null,null,null,null,null,null,"TOTALS",{"$f":"SUM(J45:J49)","v":0},0]
[]
[]
[null,"COMPANY NOTES",null,null,null,null,"CURRENCY CONVERTER"]
[]
[null,null,null,null,null,null,null,null,"Exchange Rate",1.0]
[null,null,null,null,null,null,null,null,"Currency Reference","US $"]
[]
[null,null,null,null,null,null,"All RATES in the Estimated Budget will be multiplied by the"]
[null,null,null,null,null,null,"Exchange Rate when the Convert Rates button is pressed."]

{"sheet":"Top Sheet","index":7,"n_rows":62,"n_cols":16,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,0,1,15],[2,0,2,15]]}
[]
["ASSOCIATION OF INDEPENDENT COMMERCIAL PRODUCERS"]
["FILM PRODUCTION COST SUMMARY"]
[null,"Bid Date:",{"$f":"TODAY()","v":"2023-05-22"}]
[null,"Production Co.:",null,null,null,null,"Agency:"]
[null,"Address:",null,null,null,null,"Address:"]
[]
[null,"Telephone:",null,null,null,null,"Telephone:"]
[null,"Fax:",null,null,null,null,"Fax:"]
[null,"Job #:",null,null,null,null,"Agency Prod:"]
[null,"Contact:",null,null,null,null,"Agency Art Dir:"]
[null,"Director:",null,null,null,null,"Agency Writer:"]
[null,"Producer:",null,null," ",null,"Agency Bus Mgr:"]
[null,"DP:",null,null,null,null,"Client:"]
[null,"Art Director:",null,null,null,null,"Product:"]
[null,"Editor:",null,null,null,null,"Bid Name:"]
[null,"Pre-Production Days:",null,null,null,null,"Commercial Title",null,null,null,null,null,"Code","Length","Code","Length"]
[null,"Build & Strike Days:",null,"Hours:",null,{"$f":"\"1.\"","v":"1."}]
[null,"Pre-light Days:",null,"Hours:",null,{"$f":"\"2.\"","v":"2."}]
[null,"Studio Shoot Days:",null,"Hours:",null,{"$f":"\"3.\"","v":"3."}]
[null,"Location Days:",1.0,"Hours:",12.0,{"$f":"\"4.\"","v":"4."}]
[null,"Location(s):",null,null,null,{"$f":"\"5.\"","v":"5."}]
[null,null,null,null,null,{"$f":"\"6.\"","v":"6."}]
[]
["SUMMARY OF ESTIMATED PRODUCTION COSTS",null,null,null,null,null,null,"true costs","insurance","markup","est","ESTIMATED","WORKING",{"$f":"IF(M47<>0,\"VARIANCE\",0)","v":"#REF!"},{"$f":"IF(A_TOTAL_GRAND=0, ,\"ACTUAL\")","v":""},{"$f":"IF(O47<>0,\"VARIANCE\",0)","v":0}]
[1.0,"Pre-production & Wrap Costs",null,null,null,null,"Totals A & C",{"$f":"E_TOTAL_A+E_TOTAL_C","v":0},{"$f":"ROUND(SUM(E_TOTAL_A+E_TOTAL_C)*ins_AtoK/100,0)","v":0},{"$f":"ROUND(SUM(E_TOTAL_A+E_TOTAL_C)*markup_AtoK/100,0)","v":0},{"$f":"H26+IF(Ins_Show=\"Show\",0,I26)+IF(Markup_Show=\"Show\",0,J26)","v":0},{"$f":"E_TOTAL_1","v":0},{"$f":"W_TOTAL_A+W_TOTAL_C","v":0},{"$f":"IF($M$47<>0,M26:M44-L26:L44,0)","v":"#REF!"},{"$f":"A_TOTAL_A+A_TOTAL_C","v":0},{"$f":"IF($O$47<>0,O26:O44-L26:L44,0)","v":0}]
[2.0,"Shooting Labor",null,null,null,null,"Total  B",{"$f":"E_TOTAL_B","v":0},{"$f":"ROUND(SUM(E_TOTAL_B)*ins_AtoK/100,0)","v":0},{"$f":"ROUND(SUM(E_TOTAL_B)*markup_AtoK/100,0)","v":0},{"$f":"H27+IF(Ins_Show=\"Show\",0,I27)+IF(Markup_Show=\"Show\",0,J27)","v":0},{"$f":"E_TOTAL_2","v":0},{"$f":"W_TOTAL_B","v":0},null,{"$f":"A_TOTAL_B","v":0}]
[3.0,"Location & Travel Expenses",null,null,null,null,"Total  D",{"$f":"E_TOTAL_D","v":0},{"$f":"ROUND(SUM(E_TOTAL_D)*ins_AtoK/100,0)","v":0},{"$f":"ROUND(SUM(E_TOTAL_D)*markup_AtoK/100,0)","v":0},{"$f":"H28+IF(Ins_Show=\"Show\",0,I28)+IF(Markup_Show=\"Show\",0,J28)","v":0},{"$f":"E_TOTAL_3","v":0},{"$f":"W_TOTAL_D","v":0},null,{"$f":"A_TOTAL_D","v":0}]
[4.0,"Props, Wardrobe, and Animals",null,null,null,null,"Total  E",{"$f":"E_TOTAL_E","v":0},{"$f":"ROUND(SUM(E_TOTAL_E)*ins_AtoK/100,0)","v":0},{"$f":"ROUND(SUM(E_TOTAL_E)*markup_AtoK/100,0)","v":0},{"$f":"H29+IF(Ins_Show=\"Show\",0,I29)+IF(Markup_Show=\"Show\",0,J29)","v":0},{"$f":"E_TOTAL_4","v":0},{"$f":"W_TOTAL_E","v":0},null,{"$f":"A_TOTAL_E","v":0}]
[5.0,"Studio & Set Construction Costs",null,null,null,null,"Totals  F, G, & H",{"$f":"E_TOTAL_F+E_TOTAL_G+E_TOTAL_H","v":0},{"$f":"ROUND(SUM(E_TOTAL_F+E_TOTAL_G+E_TOTAL_H)*ins_AtoK/100,0)","v":0},{"$f":"ROUND(SUM(E_TOTAL_F+E_TOTAL_G+E_TOTAL_H)*markup_AtoK/100,0)","v":0},{"$f":"H30+IF(Ins_Show=\"Show\",0,I30)+IF(Markup_Show=\"Show\",0,J30)","v":0},{"$f":"E_TOTAL_5","v":0},{"$f":"W_TOTAL_F+W_TOTAL_G+W_TOTAL_H","v":0},null,{"$f":"A_TOTAL_F+A_TOTAL_G+A_TOTAL_H","v":0}]
[6.0,"Equipment Costs",null,null,null,null,"Total  I",{"$f":"E_TOTAL_I","v":0},{"$f":"ROUND(SUM(E_TOTAL_I)*ins_AtoK/100,0)","v":0},{"$f":"ROUND(SUM(E_TOTAL_I)*markup_AtoK/100,0)","v":0},{"$f":"H31+IF(Ins_Show=\"Show\",0,I31)+IF(Markup_Show=\"Show\",0,J31)","v":0},{"$f":"E_TOTAL_6","v":0},{"$f":"W_TOTAL_I","v":0},null,{"$f":"A_TOTAL_I","v":0}]
[7.0,"Filmstock, Develop and Print",null,null,null,null,"Total  J",{"$f":"E_TOTAL_J","v":0},{"$f":"ROUND(SUM(E_TOTAL_J)*ins_AtoK/100,0)","v":0},{"$f":"ROUND(SUM(E_TOTAL_J)*markup_AtoK/100,0)","v":0},{"$f":"H32+IF(Ins_Show=\"Show\",0,I32)+IF(Markup_Show=\"Show\",0,J32)","v":0},{"$f":"E_TOTAL_7","v":0},{"$f":"W_TOTAL_J","v":0},null,{"$f":"A_TOTAL_J","v":0}]
[8.0,"Miscellaneous",null,null,null,null,"Total  K",{"$f":"E_TOTAL_K","v":0},{"$f":"ROUND(SUM(E_TOTAL_K)*ins_AtoK/100,0)","v":0},{"$f":"ROUND(SUM(E_TOTAL_K)*markup_AtoK/100,0)","v":0},{"$f":"H33+IF(Ins_Show=\"Show\",0,I33)+IF(Markup_Show=\"Show\",0,J33)","v":0},{"$f":"E_TOTAL_8","v":0},{"$f":"W_TOTAL_K","v":0},null,{"$f":"A_TOTAL_K","v":0}]
[9.0,null,null,null,"Sub-total",null,"A to K",{"$f":"SUM(H26:H33)","v":0},0,0,0,0,0,null,{"$f":"SUM(O26:O33)","v":0}]
[10.0,"Director / Creative Fees   (not included in Direct Costs)",null,null,null,null,"Total L",{"$f":"E_TOTAL_L","v":0},{"$f":"ROUND(SUM(E_TOTAL_L)*ins_Director/100,0)","v":0},{"$f":"ROUND(SUM(E_TOTAL_L)*markup_Director/100,0)","v":0},{"$f":"H35+IF(Ins_Show=\"Show\",0,I35)+IF(Markup_Show=\"Show\",0,J35)","v":0},{"$f":"E_TOTAL_10","v":0},{"$f":"W_TOTAL_L","v":0},null,{"$f":"A_TOTAL_L","v":0}]
[11.0,"Insurance",null,null,null,null,null,{"$f":"I34+I35+I39+I40+IF(Ins_Show=\"Show\",(base_Flat*ins_Flat/100),0)","v":"#REF!"},null,null,{"$f":"IF(Ins_Show=\"Hide\",0,H36)","v":"#REF!"},{"$f":"E_TOTAL_11","v":"#REF!"},{"$f":"IF(OR(W_TOTAL_AtoK<>0,SUM('Page 5'!Y39:Y44)<>0,SUM('Page 5'!Y50:Y54)<>0,W_TOTAL_O<>0,W_TOTAL_P<>0),((W_TOTAL_AtoK*ins_AtoK)+(W_TOTAL_L*ins_Director)+(SUM('Page 5'!Y39:Y44)*ins_Talent)+(SUM('Page 5'!Y50:Y54)*ins_TalentExpenses)+((W_TOTAL_O+W_TOTAL_P)*ins_Post))/100,0)+IF(Ins_Show=\"Show\",(base_Flat*ins_Flat/100))","v":"#REF!"},null,{"$f":"IF(OR(A_TOTAL_AtoK<>0,SUM('Page 5'!AH39:AH44)<>0,SUM(ACTUAL_N)<>0,A_TOTAL_O<>0,A_TOTAL_P<>0),((A_TOTAL_AtoK*ins_AtoK)+(A_TOTAL_L*ins_Director)+(SUM('Page 5'!AH39:AH44)*ins_Talent)+(SUM('Page 5'!AH50:AH54)*ins_TalentExpenses)+((A_TOTAL_O+A_TOTAL_P)*ins_Post))/100,0)+IF(A_TOTAL_AtoK=0, ,IF(Ins_Show=\"Show\",(base_Flat*ins_Flat/100)))","v":0}]
[12.0,null,null,null,"Sub-total",null,"Direct Costs",null,null,null,{"$f":"E_TOTAL_9+E_TOTAL_11","v":"#REF!"},{"$f":"E_TOTAL_AtoK+L36","v":"#REF!"},{"$f":"W_TOTAL_AtoK+W_TOTAL_INS","v":"#REF!"},null,{"$f":"A_TOTAL_AtoK+A_TOTAL_INS","v":0}]
[13.0,"Production Fee",{"$f":"markup_AtoK/100","v":0},null,null,null,null,{"$f":"J34+J35+IF(D_Talent=0,ROUND(SUM('Page 5'!N39:N44)*markup_Talent/100,0),0)+IF(D_TalentExpenses=0,ROUND(SUM('Page 5'!N50:N54)*markup_TalentExpenses/100,0),0)+IF(D_Post=0,ROUND(SUM(E_TOTAL_O+E_TOTAL_P)*markup_Post/100,0),0)+IF(Markup_Show=\"Show\",(base_Flat*markup_Flat/100),0)","v":"#REF!"},{"$f":"J34+J35+ROUND(SUM('Page 5'!N39:N44)*markup_Talent/100,0)+ROUND(SUM('Page 5'!N50:N54)*markup_TalentExpenses/100,0)+ROUND(SUM(E_TOTAL_O+E_TOTAL_P)*markup_Post/100,0)++IF(Markup_Show=\"Show\",(base_Flat*markup_Flat/100),0)","v":"#REF!"},{"$f":"ROUND(SUM('Page 5'!N39:N44)*markup_Talent/100,0)","v":0},{"$f":"IF(Markup_Show=\"Hide\",0,H38)","v":"#REF!"},{"$f":"E_TOTAL_13","v":"#REF!"},{"$f":"IF(OR(W_TOTAL_AtoK<>0,SUM('Page 5'!Y39:Y44)<>0,SUM('Page 5'!Y50:Y54),W_TOTAL_O<>0,W_TOTAL_P<>0),E_TOTAL_MARKUP+OVERAGE_MARKUP,0)","v":"#REF!"},null,{"$f":"IF(OR(A_TOTAL_AtoK<>0,SUM('Page 5'!AH39:AH44)<>0,SUM(ACTUAL_N)<>0,A_TOTAL_O<>0,A_TOTAL_P<>0),E_TOTAL_MARKUP+OVERAGE_MARKUP,0)","v":0}]
[14.0,"Talent",null,null,null,null,"Totals  M & N",{"$f":"E_TOTAL_M+E_TOTAL_N","v":0},{"$f":"ROUND(SUM('Page 5'!N39:N44)*ins_Talent/100+SUM('Page 5'!N50:N54)*ins_TalentExpenses/100,0)","v":0},{"$f":"ROUND(SUM('Page 5'!N50:N54)*markup_TalentExpenses/100,0)","v":0},{"$f":"H39+IF(Ins_Show=\"Show\",0,I39)+IF(Markup_Show=\"Show\",0,J38+J39)","v":0},{"$f":"E_TOTAL_14","v":0},{"$f":"W_TOTAL_M+W_TOTAL_N","v":0},null,{"$f":"A_TOTAL_M+A_TOTAL_N","v":0}]
[15.0,"Off-line & Crew Travel Expenses",null,null,null,null,"Totals  O & P",{"$f":"E_TOTAL_O+E_TOTAL_P","v":"#REF!"},{"$f":"ROUND(SUM(E_TOTAL_O+E_TOTAL_P)*ins_Post/100,0)","v":"#REF!"},{"$f":"ROUND(SUM(E_TOTAL_O+E_TOTAL_P)*markup_Post/100,0)","v":"#REF!"},{"$f":"H40+IF(Ins_Show=\"Show\",0,I40)+IF(Markup_Show=\"Show\",0,J40)","v":"#REF!"},{"$f":"E_TOTAL_15","v":"#REF!"},{"$f":"W_TOTAL_O+W_TOTAL_P","v":"#REF!"},null,{"$f":"A_TOTAL_O+A_TOTAL_P","v":0}]
[16.0,{"$f":"IF(Markup_Show=\"Hide\",0,IF(D_Post=0,0,\"Editorial Fee\"))","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(Markup_Show=\"Hide\",0,IF(D_Post=0,0,ROUND(SUM(E_TOTAL_O+E_TOTAL_P)*markup_Post/100,0)))","v":0},{"$f":"E_TOTAL_16","v":0},{"$f":"E_TOTAL_POSTMARKUP","v":0},null,{"$f":"IF(OR(A_TOTAL_AtoK<>0,SUM('Page 5'!AH39:AH44)<>0,SUM(ACTUAL_N)<>0,A_TOTAL_O<>0,A_TOTAL_P<>0),E_TOTAL_POSTMARKUP,0)","v":0}]
[17.0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L42","v":""}]
[18.0,null,null,null,null,null,null,null,null,null,null,null,""]
[19.0,{"$f":"IF(OVERAGE_TOTALS=0, ,\"Additional Billings\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"OVERAGE_TOTALS","v":0}]
[]
[null,null,null,"Contracted Total",{"$f":"E_TOTAL_GRAND-OVERAGE_TOTALS","v":"#REF!"}]
[null,null,null,null,null,null,"GRAND TOTAL",null,null,null,null,{"$f":"SUM(L37:L44)+L35","v":"#REF!"},"#REF!",{"$f":"IF($M$47<>0,M47:M63-L47:L63,0)","v":"#REF!"},{"$f":"SUM(O37:O44)+O35","v":0},{"$f":"IF($O$47<>0,O47-L47,0)","v":0}]
[null,null,null,"Contingency/Weather Day"]
[]
["COMMENTS"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"© 1996-2003 PointZero Media LLC"]

{"sheet":"Page 1A","index":8,"n_rows":59,"n_cols":38,"rows_kept":59,"cut":false,"hidden":false,"merged":[[3,31,3,36],[4,8,4,9],[4,18,4,19],[4,22,4,24],[4,34,4,35]]}
[]
[{"$f":"IF('Top Sheet'!$C$5=\"\",\"\",'Top Sheet'!$C$5)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1A",null,null,null,null,null,null,null,null,"Page 1A"]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$15=\"\",\"\",'Top Sheet'!$L$15),IF('Top Sheet'!$L$12=\"\",\"\",'Top Sheet'!$L$12))","v":""}]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$16=\"\",\"\",'Top Sheet'!$L$16),IF('Top Sheet'!$L$13=\"\",\"\",'Top Sheet'!$L$13))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OVERTIME CALCULATOR"]
[null,"PRE-PRO & WRAP",null,null,"%","OT",null,null,"OT Hours",null,"Rate",null,null,null,"%","OT",null,null,"OT Hours",null,null,null,"Payroll Log Detail",null,null,null,"Payroll Log Costs",null,"Other",null,null,"%","OT",null,"OT Hours",null,"OVERTIME"]
["A","CREW",null,"Notes","PT/P&W","Based","Days","Rate",1.5,2.0,"Change","ESTIMATED","PT/P&W",null,"PT/P&W","Based","Days","Rate",{"$f":"I6","v":1.5},2,"WORKING","PT/P&W","Days","Rate","OT Hrs","Misc","ST","OT","Logs","ACTUAL",null,"PT/P&W","Based","Rate",1.5,2.0,"TOTAL"]
[1.0,"Line Producer",null,null,29.0,10.0,null,1200.0,null,null,{"$f":"H7:H56*X_RATE","v":1200},{"$f":"ROUND((G7:G56*H7:H56)+(H7:H56/F7:F56*$I$6*I7:I56)+(H7:H56/F7:F56*$J$6*J7:J56),0)","v":0},{"$f":"ROUND(L7:L56*E7:E56/100,2)","v":0},null,{"$f":"E7","v":29},10,"",1200,"","",{"$f":"ROUND((Q7:Q56*R7:R56)+(R7:R56/P7:P56*$I$6*S7:S56)+(R7:R56/P7:P56*$J$6*T7:T56),2)","v":0},{"$f":"ROUND(U7:U56*O7:O56/100,2)","v":0},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O7","v":29},10,{"$f":"R7","v":1200},null,null,{"$f":"IF(AG7:AG56=0,0,ROUND((AH7:AH56/AG7:AG56*$AI$6*AI7:AI56)+(AH7:AH56/AG7:AG56*$AJ$6*AJ7:AJ56),2))","v":0},{"$f":"ROUND(AK7:AK56*AF7:AF56/100,2)","v":0}]
[2.0,"Assistant Director",null,null,43.0,12.0,null,1200.0,null,null,1200.0,0,0.0,null,{"$f":"E8","v":43},12,"",1200,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O8","v":43},12,1200,null,null,0.0,0.0]
[3.0,"Director of Photography",null,null,31.0,10.0,null,4500.0,null,null,4500.0,0,0.0,null,{"$f":"E9","v":31},10,"",4500,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O9","v":31},10,4500,null,null,0.0,0.0]
[4.0,"Camera Operator",null,null,31.0,10.0,null,1500.0,null,null,1500.0,0,0.0,null,{"$f":"E10","v":31},10,"",1500,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O10","v":31},10,1500,null,null,0.0,0.0]
[5.0,"1st Camera Assistant",null,null,31.0,10.0,null,600.0,null,null,600.0,0,0.0,null,{"$f":"E11","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O11","v":31},10,600,null,null,0.0,0.0]
[6.0,"2nd AC",null,null,31.0,10.0,null,575.0,null,null,575.0,0,0.0,null,{"$f":"E12","v":31},10,"",575,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O12","v":31},10,575,null,null,0.0,0.0]
[7.0,"Loader",null,null,31.0,10.0,null,550.0,null,null,550.0,0,0.0,null,{"$f":"E13","v":31},10,"",550,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O13","v":31},10,550,null,null,0.0,0.0]
[8.0,"Production Manager",null,null,29.0,10.0,null,600.0,null,null,600.0,0,0.0,null,{"$f":"E14","v":29},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O14","v":29},10,600,null,null,0.0,0.0]
[9.0,"Production Coordinator",null,null,29.0,10.0,null,400.0,null,null,400.0,0,0.0,null,{"$f":"E15","v":29},10,"",400,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O15","v":29},10,400,null,null,0.0,0.0]
[10.0,"2nd AD",null,null,43.0,12.0,null,550.0,null,null,550.0,0,0.0,null,{"$f":"E16","v":43},12,"",550,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O16","v":43},12,550,null,null,0.0,0.0]
[11.0,"Gaffer",null,null,31.0,10.0,null,600.0,null,null,600.0,0,0.0,null,{"$f":"E17","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O17","v":31},10,600,null,null,0.0,0.0]
[12.0,"Best Boy Electric",null,null,31.0,10.0,null,575.0,null,null,575.0,0,0.0,null,{"$f":"E18","v":31},10,"",575,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O18","v":31},10,575,null,null,0.0,0.0]
[13.0,"Electric",null,null,31.0,10.0,null,550.0,null,null,550.0,0,0.0,null,{"$f":"E19","v":31},10,"",550,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O19","v":31},10,550,null,null,0.0,0.0]
[14.0,"Electric Driver",null,null,31.0,10.0,null,550.0,null,null,550.0,0,0.0,null,{"$f":"E20","v":31},10,"",550,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O20","v":31},10,550,null,null,0.0,0.0]
[15.0,"Rigger",null,null,31.0,10.0,null,550.0,null,null,550.0,0,0.0,null,{"$f":"E21","v":31},10,"",550,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O21","v":31},10,550,null,null,0.0,0.0]
[16.0,"Key Grip",null,null,31.0,10.0,null,600.0,null,null,600.0,0,0.0,null,{"$f":"E22","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O22","v":31},10,600,null,null,0.0,0.0]
[17.0,"Best Boy Grip",null,null,31.0,10.0,null,575.0,null,null,575.0,0,0.0,null,{"$f":"E23","v":31},10,"",575,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O23","v":31},10,575,null,null,0.0,0.0]
[18.0,"Grip",null,null,31.0,10.0,null,550.0,null,null,550.0,0,0.0,null,{"$f":"E24","v":31},10,"",550,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O24","v":31},10,550,null,null,0.0,0.0]
[19.0,"Grip Driver",null,null,31.0,10.0,null,550.0,null,null,550.0,0,0.0,null,{"$f":"E25","v":31},10,"",550,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O25","v":31},10,550,null,null,0.0,0.0]
[20.0,"Mixer",null,null,31.0,10.0,null,730.0,null,null,730.0,0,0.0,null,{"$f":"E26","v":31},10,"",730,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O26","v":31},10,730,null,null,0.0,0.0]
[21.0,"Boom Man",null,null,31.0,10.0,null,525.0,null,null,525.0,0,0.0,null,{"$f":"E27","v":31},10,"",525,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O27","v":31},10,525,null,null,0.0,0.0]
[22.0,"Playback",null,null,31.0,10.0,null,600.0,null,null,600.0,0,0.0,null,{"$f":"E28","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O28","v":31},10,600,null,null,0.0,0.0]
[23.0,"Make-up",null,null,31.0,10.0,null,1000.0,null,null,1000.0,0,0.0,null,{"$f":"E29","v":31},10,"",1000,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O29","v":31},10,1000,null,null,0.0,0.0]
[24.0,"Hair Stylist",null,null,31.0,10.0,null,1000.0,null,null,1000.0,0,0.0,null,{"$f":"E30","v":31},10,"",1000,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O30","v":31},10,1000,null,null,0.0,0.0]
[25.0,"Make-up/Hair Assts.",null,null,31.0,10.0,null,450.0,null,null,450.0,0,0.0,null,{"$f":"E31","v":31},10,"",450,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O31","v":31},10,450,null,null,0.0,0.0]
[26.0,"Stylist",null,null,31.0,10.0,null,1000.0,null,null,1000.0,0,0.0,null,{"$f":"E32","v":31},10,"",1000,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O32","v":31},10,1000,null,null,0.0,0.0]
[27.0,"Wardrobe ",null,null,31.0,10.0,null,450.0,null,null,450.0,0,0.0,null,{"$f":"E33","v":31},10,"",450,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O33","v":31},10,450,null,null,0.0,0.0]
[28.0,"Script Supervisor",null,null,31.0,10.0,null,600.0,null,null,600.0,0,0.0,null,{"$f":"E34","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O34","v":31},10,600,null,null,0.0,0.0]
[29.0,"Home Economist",null,null,31.0,10.0,null,1200.0,null,null,1200.0,0,0.0,null,{"$f":"E35","v":31},10,"",1200,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O35","v":31},10,1200,null,null,0.0,0.0]
[30.0,"Asst. Home Economist",null,null,31.0,10.0,null,600.0,null,null,600.0,0,0.0,null,{"$f":"E36","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O36","v":31},10,600,null,null,0.0,0.0]
[31.0,"VTR Operator",null,null,31.0,10.0,null,600.0,null,null,600.0,0,0.0,null,{"$f":"E37","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O37","v":31},10,600,null,null,0.0,0.0]
[32.0,"Effects",null,null,31.0,10.0,null,650.0,null,null,650.0,0,0.0,null,{"$f":"E38","v":31},10,"",650,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O38","v":31},10,650,null,null,0.0,0.0]
[33.0,"FX Assistant",null,null,31.0,10.0,null,525.0,null,null,525.0,0,0.0,null,{"$f":"E39","v":31},10,"",525,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O39","v":31},10,525,null,null,0.0,0.0]
[34.0,"2nd 2nd AD",null,null,43.0,10.0,null,400.0,null,null,400.0,0,0.0,null,{"$f":"E40","v":43},10,"",400,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O40","v":43},10,400,null,null,0.0,0.0]
[35.0,"Camera Car Driver",null,null,31.0,10.0,null,650.0,null,null,650.0,0,0.0,null,{"$f":"E41","v":31},10,"",650,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O41","v":31},10,650,null,null,0.0,0.0]
[36.0,"Crane Tech",null,null,31.0,10.0,null,650.0,null,null,650.0,0,0.0,null,{"$f":"E42","v":31},10,"",650,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O42","v":31},10,650,null,null,0.0,0.0]
[37.0,"Remote Head Tech",null,null,31.0,10.0,null,650.0,null,null,650.0,0,0.0,null,{"$f":"E43","v":31},10,"",650,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O43","v":31},10,650,null,null,0.0,0.0]
[38.0,"Location Scout",null,null,31.0,10.0,null,650.0,null,null,650.0,0,0.0,null,{"$f":"E44","v":31},10,"",650,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O44","v":31},10,650,null,null,0.0,0.0]
[39.0,"Assistant Scout",null,null,31.0,10.0,null,450.0,null,null,450.0,0,0.0,null,{"$f":"E45","v":31},10,"",450,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O45","v":31},10,450,null,null,0.0,0.0]
[40.0,"Nurse/1st Aid",null,null,31.0,10.0,null,360.0,null,null,360.0,0,0.0,null,{"$f":"E46","v":31},10,"",360,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O46","v":31},10,360,null,null,0.0,0.0]
[41.0,"Craft Service",null,null,31.0,10.0,null,350.0,null,null,350.0,0,0.0,null,{"$f":"E47","v":31},10,"",350,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O47","v":31},10,350,null,null,0.0,0.0]
[42.0,"Firemen",null,null,20.0,10.0,null,500.0,null,null,500.0,0,0.0,null,{"$f":"E48","v":20},10,"",500,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O48","v":20},10,500,null,null,0.0,0.0]
[43.0,"Policemen",null,null,20.0,10.0,null,500.0,null,null,500.0,0,0.0,null,{"$f":"E49","v":20},10,"",500,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O49","v":20},10,500,null,null,0.0,0.0]
[44.0,"Welfare/Teacher",null,null,20.0,10.0,null,500.0,null,null,500.0,0,0.0,null,{"$f":"E50","v":20},10,"",500,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O50","v":20},10,500,null,null,0.0,0.0]
[45.0,"Choreographer",null,null,20.0,10.0,null,2500.0,null,null,2500.0,0,0.0,null,{"$f":"E51","v":20},10,"",2500,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O51","v":20},10,2500,null,null,0.0,0.0]
[46.0,"Gang Boss",null,null,31.0,10.0,null,460.0,null,null,460.0,0,0.0,null,{"$f":"E52","v":31},10,"",460,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O52","v":31},10,460,null,null,0.0,0.0]
[47.0,"Teamsters/Driver",null,null,31.0,10.0,null,420.0,null,null,420.0,0,0.0,null,{"$f":"E53","v":31},10,"",420,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O53","v":31},10,420,null,null,0.0,0.0]
[48.0,"Teamster/Caterers","2 people",null,31.0,10.0,null,850.0,null,null,850.0,0,0.0,null,{"$f":"E54","v":31},10,"",850,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O54","v":31},10,850,null,null,0.0,0.0]
[49.0,"Production Assistant",null,null,29.0,10.0,null,200.0,null,null,200.0,0,0.0,null,{"$f":"E55","v":29},10,"",200,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O55","v":29},10,200,null,null,0.0,0.0]
[50.0,"Runner",null,null,29.0,10.0,null,200.0,null,null,200.0,0,0.0,null,{"$f":"E56","v":29},10,"",200,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O56","v":29},10,200,null,null,0.0,0.0]
[null,null,null,null,null,null,{"$f":"SUM(G7:G56)","v":0},null,null,"Sub-total A",null,{"$f":"SUM(L7:L56)","v":0},0,null,null,null,{"$f":"SUM(Q7:Q56)","v":0},null,null,"Sub-total Aw",{"$f":"SUM(U7:U56)","v":0},0,null,null,null,null,null,null,"Sub-total A",{"$f":"SUM(AD7:AD56)","v":0},null,null,null,null,null,"Sub-total OT",{"$f":"SUM(AK7:AK56)","v":0},0]
[null,null,null,null,null,null,null,null,"PT/P&W",null,null,{"$f":"PT_A","v":0},null,null,null,null,null,null,"PT/P&W",null,{"$f":"PT_Aw","v":0},null,null,null,null,null,null,"PT/P&W",null,0.0,null,null,null,null,null,"PT/P&W",{"$f":"PT_Aot","v":0}]
[null,null,null,null,null,null,null,null,"TOTAL A",null,null,{"$f":"SUM(L57:L58)","v":0},null,null,null,null,null,null,"TOTAL Aw",null,{"$f":"SUM(U57:U58)","v":0},null,null,null,null,null,null,"TOTAL A",null,{"$f":"SUM(AD57:AD58)","v":0},null,null,null,null,null,"TOTAL OT",{"$f":"SUM(AK57:AK58)","v":0}]

{"sheet":"Page 1B","index":9,"n_rows":59,"n_cols":38,"rows_kept":59,"cut":false,"hidden":false,"merged":[[3,31,3,36],[4,8,4,9],[4,18,4,19],[4,22,4,24],[4,25,4,27],[4,34,4,35]]}
[]
[{"$f":"IF('Top Sheet'!$C$5=\"\",\"\",'Top Sheet'!$C$5)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1B",null,null,null,null,null,null,null,null,"Page 1B"]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$15=\"\",\"\",'Top Sheet'!$L$15),IF('Top Sheet'!$L$12=\"\",\"\",'Top Sheet'!$L$12))","v":""}]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$16=\"\",\"\",'Top Sheet'!$L$16),IF('Top Sheet'!$L$13=\"\",\"\",'Top Sheet'!$L$13))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OVERTIME CALCULATOR"]
[null,"SHOOTING",null,null,"%","OT",null,null,"OT Hours",null,"Rate",null,null,null,"%","OT",null,null,"OT Hours",null,null,null,"Payroll Log Detail",null,null,"Payroll Log Costs",null,null,"Other",null,null,"%","OT",null,"OT Hours",null,"OVERTIME"]
["B","CREW",null,"Notes","PT/P&W","Based","Days","Rate",1.5,2.0,"Change","ESTIMATED","PT/P&W",null,"PT/P&W","Based","Days","Rate",{"$f":"I6","v":1.5},2,"WORKING","PT/P&W","Days","Rate","OT Hrs","Misc","ST","OT","Logs","ACTUAL",null,"PT/P&W","Based","Rate",1.5,2.0,"TOTAL"]
[51.0,{"$f":"'Page 1A'!B7","v":"Line Producer"},null,null,{"$f":"'Page 1A'!E7","v":29},10.0,null,{"$f":"'Page 1A'!H7","v":1200},null,null,{"$f":"H7:H56*X_RATE","v":1200},{"$f":"ROUND((G7:G56*H7:H56)+(H7:H56/F7:F56*$I$6*I7:I56)+(H7:H56/F7:F56*$J$6*J7:J56),0)","v":0},{"$f":"ROUND(L7:L56*E7:E56/100,0)","v":0},null,{"$f":"E7","v":29},10,"",1200,"","",{"$f":"ROUND((Q7:Q56*R7:R56)+(R7:R56/P7:P56*$S$6*S7:S56)+(R7:R56/P7:P56*$T$6*T7:T56),2)","v":0},{"$f":"ROUND(U7:U56*O7:O56/100,2)","v":0},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O7","v":29},10,{"$f":"R7","v":1200},null,null,{"$f":"IF(AG7:AG56=0,0,ROUND((AH7:AH56/AG7:AG56*$AI$6*AI7:AI56)+(AH7:AH56/AG7:AG56*$AJ$6*AJ7:AJ56),2))","v":0},{"$f":"ROUND(AK7:AK56*AF7:AF56/100,2)","v":0}]
[52.0,{"$f":"'Page 1A'!B8","v":"Assistant Director"},null,null,{"$f":"'Page 1A'!E8","v":43},12.0,null,{"$f":"'Page 1A'!H8","v":1200},null,null,1200.0,0.0,0.0,null,{"$f":"E8","v":43},12,"",1200,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O8","v":43},12,1200,null,null,0.0,0.0]
[53.0,{"$f":"'Page 1A'!B9","v":"Director of Photography"},null,null,{"$f":"'Page 1A'!E9","v":31},10.0,null,{"$f":"'Page 1A'!H9","v":4500},null,null,4500.0,0.0,0.0,null,{"$f":"E9","v":31},10,"",4500,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O9","v":31},10,4500,null,null,0.0,0.0]
[54.0,{"$f":"'Page 1A'!B10","v":"Camera Operator"},null,null,{"$f":"'Page 1A'!E10","v":31},10.0,null,{"$f":"'Page 1A'!H10","v":1500},null,null,1500.0,0.0,0.0,null,{"$f":"E10","v":31},10,"",1500,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O10","v":31},10,1500,null,null,0.0,0.0]
[55.0,{"$f":"'Page 1A'!B11","v":"1st Camera Assistant"},null,null,{"$f":"'Page 1A'!E11","v":31},10.0,null,{"$f":"'Page 1A'!H11","v":600},null,null,600.0,0.0,0.0,null,{"$f":"E11","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O11","v":31},10,600,null,null,0.0,0.0]
[56.0,{"$f":"'Page 1A'!B12","v":"2nd AC"},null,null,{"$f":"'Page 1A'!E12","v":31},10.0,null,{"$f":"'Page 1A'!H12","v":575},null,null,575.0,0.0,0.0,null,{"$f":"E12","v":31},10,"",575,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O12","v":31},10,575,null,null,0.0,0.0]
[57.0,{"$f":"'Page 1A'!B13","v":"Loader"},null,null,{"$f":"'Page 1A'!E13","v":31},10.0,null,{"$f":"'Page 1A'!H13","v":550},null,null,550.0,0.0,0.0,null,{"$f":"E13","v":31},10,"",550,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O13","v":31},10,550,null,null,0.0,0.0]
[58.0,{"$f":"'Page 1A'!B14","v":"Production Manager"},null,null,{"$f":"'Page 1A'!E14","v":29},10.0,null,{"$f":"'Page 1A'!H14","v":600},null,null,600.0,0.0,0.0,null,{"$f":"E14","v":29},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O14","v":29},10,600,null,null,0.0,0.0]
[59.0,{"$f":"'Page 1A'!B15","v":"Production Coordinator"},null,null,{"$f":"'Page 1A'!E15","v":29},10.0,null,{"$f":"'Page 1A'!H15","v":400},null,null,400.0,0.0,0.0,null,{"$f":"E15","v":29},10,"",400,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O15","v":29},10,400,null,null,0.0,0.0]
[60.0,{"$f":"'Page 1A'!B16","v":"2nd AD"},null,null,{"$f":"'Page 1A'!E16","v":43},12.0,null,{"$f":"'Page 1A'!H16","v":550},null,null,550.0,0.0,0.0,null,{"$f":"E16","v":43},12,"",550,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O16","v":43},12,550,null,null,0.0,0.0]
[61.0,{"$f":"'Page 1A'!B17","v":"Gaffer"},null,null,{"$f":"'Page 1A'!E17","v":31},10.0,null,{"$f":"'Page 1A'!H17","v":600},null,null,600.0,0.0,0.0,null,{"$f":"E17","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O17","v":31},10,600,null,null,0.0,0.0]
[62.0,{"$f":"'Page 1A'!B18","v":"Best Boy Electric"},null,null,{"$f":"'Page 1A'!E18","v":31},10.0,null,{"$f":"'Page 1A'!H18","v":575},null,null,575.0,0.0,0.0,null,{"$f":"E18","v":31},10,"",575,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O18","v":31},10,575,null,null,0.0,0.0]
[63.0,{"$f":"'Page 1A'!B19","v":"Electric"},null,null,{"$f":"'Page 1A'!E19","v":31},10.0,null,{"$f":"'Page 1A'!H19","v":550},null,null,550.0,0.0,0.0,null,{"$f":"E19","v":31},10,"",550,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O19","v":31},10,550,null,null,0.0,0.0]
[64.0,{"$f":"'Page 1A'!B20","v":"Electric Driver"},null,null,{"$f":"'Page 1A'!E20","v":31},10.0,null,{"$f":"'Page 1A'!H20","v":550},null,null,550.0,0.0,0.0,null,{"$f":"E20","v":31},10,"",550,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O20","v":31},10,550,null,null,0.0,0.0]
[65.0,{"$f":"'Page 1A'!B21","v":"Rigger"},null,null,{"$f":"'Page 1A'!E21","v":31},10.0,null,{"$f":"'Page 1A'!H21","v":550},null,null,550.0,0.0,0.0,null,{"$f":"E21","v":31},10,"",550,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O21","v":31},10,550,null,null,0.0,0.0]
[66.0,{"$f":"'Page 1A'!B22","v":"Key Grip"},null,null,{"$f":"'Page 1A'!E22","v":31},10.0,null,{"$f":"'Page 1A'!H22","v":600},null,null,600.0,0.0,0.0,null,{"$f":"E22","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O22","v":31},10,600,null,null,0.0,0.0]
[67.0,{"$f":"'Page 1A'!B23","v":"Best Boy Grip"},null,null,{"$f":"'Page 1A'!E23","v":31},10.0,null,{"$f":"'Page 1A'!H23","v":575},null,null,575.0,0.0,0.0,null,{"$f":"E23","v":31},10,"",575,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O23","v":31},10,575,null,null,0.0,0.0]
[68.0,{"$f":"'Page 1A'!B24","v":"Grip"},null,null,{"$f":"'Page 1A'!E24","v":31},10.0,null,{"$f":"'Page 1A'!H24","v":550},null,null,550.0,0.0,0.0,null,{"$f":"E24","v":31},10,"",550,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O24","v":31},10,550,null,null,0.0,0.0]
[69.0,{"$f":"'Page 1A'!B25","v":"Grip Driver"},null,null,{"$f":"'Page 1A'!E25","v":31},10.0,null,{"$f":"'Page 1A'!H25","v":550},null,null,550.0,0.0,0.0,null,{"$f":"E25","v":31},10,"",550,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O25","v":31},10,550,null,null,0.0,0.0]
[70.0,{"$f":"'Page 1A'!B26","v":"Mixer"},null,null,{"$f":"'Page 1A'!E26","v":31},10.0,null,{"$f":"'Page 1A'!H26","v":730},null,null,730.0,0.0,0.0,null,{"$f":"E26","v":31},10,"",730,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O26","v":31},10,730,null,null,0.0,0.0]
[71.0,{"$f":"'Page 1A'!B27","v":"Boom Man"},null,null,{"$f":"'Page 1A'!E27","v":31},10.0,null,{"$f":"'Page 1A'!H27","v":525},null,null,525.0,0.0,0.0,null,{"$f":"E27","v":31},10,"",525,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O27","v":31},10,525,null,null,0.0,0.0]
[72.0,{"$f":"'Page 1A'!B28","v":"Playback"},null,null,{"$f":"'Page 1A'!E28","v":31},10.0,null,{"$f":"'Page 1A'!H28","v":600},null,null,600.0,0.0,0.0,null,{"$f":"E28","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O28","v":31},10,600,null,null,0.0,0.0]
[73.0,{"$f":"'Page 1A'!B29","v":"Make-up"},null,"incl. 20%agency",{"$f":"'Page 1A'!E29","v":31},10.0,null,{"$f":"'Page 1A'!H29","v":1000},null,null,1000.0,0.0,0.0,null,{"$f":"E29","v":31},10,"",1000,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O29","v":31},10,1000,null,null,0.0,0.0]
[74.0,{"$f":"'Page 1A'!B30","v":"Hair Stylist"},null,"incl. 20%agency",{"$f":"'Page 1A'!E30","v":31},10.0,null,{"$f":"'Page 1A'!H30","v":1000},null,null,1000.0,0.0,0.0,null,{"$f":"E30","v":31},10,"",1000,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O30","v":31},10,1000,null,null,0.0,0.0]
[75.0,{"$f":"'Page 1A'!B31","v":"Make-up/Hair Assts."},null,null,{"$f":"'Page 1A'!E31","v":31},10.0,null,{"$f":"'Page 1A'!H31","v":450},null,null,450.0,0.0,0.0,null,{"$f":"E31","v":31},10,"",450,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O31","v":31},10,450,null,null,0.0,0.0]
[76.0,{"$f":"'Page 1A'!B32","v":"Stylist"},null,"incl. 20%agency",{"$f":"'Page 1A'!E32","v":31},10.0,null,{"$f":"'Page 1A'!H32","v":1000},null,null,1000.0,0.0,0.0,null,{"$f":"E32","v":31},10,"",1000,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O32","v":31},10,1000,null,null,0.0,0.0]
[77.0,{"$f":"'Page 1A'!B33","v":"Wardrobe "},null,null,{"$f":"'Page 1A'!E33","v":31},10.0,null,{"$f":"'Page 1A'!H33","v":450},null,null,450.0,0.0,0.0,null,{"$f":"E33","v":31},10,"",450,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O33","v":31},10,450,null,null,0.0,0.0]
[78.0,{"$f":"'Page 1A'!B34","v":"Script Supervisor"},null,null,{"$f":"'Page 1A'!E34","v":31},10.0,null,{"$f":"'Page 1A'!H34","v":600},null,null,600.0,0.0,0.0,null,{"$f":"E34","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O34","v":31},10,600,null,null,0.0,0.0]
[79.0,{"$f":"'Page 1A'!B35","v":"Home Economist"},null,null,{"$f":"'Page 1A'!E35","v":31},10.0,null,{"$f":"'Page 1A'!H35","v":1200},null,null,1200.0,0.0,0.0,null,{"$f":"E35","v":31},10,"",1200,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O35","v":31},10,1200,null,null,0.0,0.0]
[80.0,{"$f":"'Page 1A'!B36","v":"Asst. Home Economist"},null,null,{"$f":"'Page 1A'!E36","v":31},10.0,null,{"$f":"'Page 1A'!H36","v":600},null,null,600.0,0.0,0.0,null,{"$f":"E36","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O36","v":31},10,600,null,null,0.0,0.0]
[81.0,{"$f":"'Page 1A'!B37","v":"VTR Operator"},null,null,{"$f":"'Page 1A'!E37","v":31},10.0,null,{"$f":"'Page 1A'!H37","v":600},null,null,600.0,0.0,0.0,null,{"$f":"E37","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O37","v":31},10,600,null,null,0.0,0.0]
[82.0,{"$f":"'Page 1A'!B38","v":"Effects"},null,null,{"$f":"'Page 1A'!E38","v":31},10.0,null,{"$f":"'Page 1A'!H38","v":650},null,null,650.0,0.0,0.0,null,{"$f":"E38","v":31},10,"",650,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O38","v":31},10,650,null,null,0.0,0.0]
[83.0,{"$f":"'Page 1A'!B39","v":"FX Assistant"},null,null,{"$f":"'Page 1A'!E39","v":31},10.0,null,{"$f":"'Page 1A'!H39","v":525},null,null,525.0,0.0,0.0,null,{"$f":"E39","v":31},10,"",525,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O39","v":31},10,525,null,null,0.0,0.0]
[84.0,{"$f":"'Page 1A'!B40","v":"2nd 2nd AD"},null,null,{"$f":"'Page 1A'!E40","v":43},10.0,null,{"$f":"'Page 1A'!H40","v":400},null,null,400.0,0.0,0.0,null,{"$f":"E40","v":43},10,"",400,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O40","v":43},10,400,null,null,0.0,0.0]
[85.0,{"$f":"'Page 1A'!B41","v":"Camera Car Driver"},null,null,{"$f":"'Page 1A'!E41","v":31},10.0,null,{"$f":"'Page 1A'!H41","v":650},null,null,650.0,0.0,0.0,null,{"$f":"E41","v":31},10,"",650,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O41","v":31},10,650,null,null,0.0,0.0]
[86.0,{"$f":"'Page 1A'!B42","v":"Crane Tech"},null,null,{"$f":"'Page 1A'!E42","v":31},10.0,null,{"$f":"'Page 1A'!H42","v":650},null,null,650.0,0.0,0.0,null,{"$f":"E42","v":31},10,"",650,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O42","v":31},10,650,null,null,0.0,0.0]
[87.0,{"$f":"'Page 1A'!B43","v":"Remote Head Tech"},null,null,{"$f":"'Page 1A'!E43","v":31},10.0,null,{"$f":"'Page 1A'!H43","v":650},null,null,650.0,0.0,0.0,null,{"$f":"E43","v":31},10,"",650,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O43","v":31},10,650,null,null,0.0,0.0]
[88.0,{"$f":"'Page 1A'!B44","v":"Location Scout"},null,null,{"$f":"'Page 1A'!E44","v":31},10.0,null,{"$f":"'Page 1A'!H44","v":650},null,null,650.0,0.0,0.0,null,{"$f":"E44","v":31},10,"",650,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O44","v":31},10,650,null,null,0.0,0.0]
[89.0,{"$f":"'Page 1A'!B45","v":"Assistant Scout"},null,null,{"$f":"'Page 1A'!E45","v":31},10.0,null,{"$f":"'Page 1A'!H45","v":450},null,null,450.0,0.0,0.0,null,{"$f":"E45","v":31},10,"",450,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O45","v":31},10,450,null,null,0.0,0.0]
[90.0,{"$f":"'Page 1A'!B46","v":"Nurse/1st Aid"},null,null,{"$f":"'Page 1A'!E46","v":31},10.0,null,{"$f":"'Page 1A'!H46","v":360},null,null,360.0,0.0,0.0,null,{"$f":"E46","v":31},10,"",360,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O46","v":31},10,360,null,null,0.0,0.0]
[91.0,{"$f":"'Page 1A'!B47","v":"Craft Service"},null,null,{"$f":"'Page 1A'!E47","v":31},10.0,null,{"$f":"'Page 1A'!H47","v":350},null,null,350.0,0.0,0.0,null,{"$f":"E47","v":31},10,"",350,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O47","v":31},10,350,null,null,0.0,0.0]
[92.0,{"$f":"'Page 1A'!B48","v":"Firemen"},null,null,{"$f":"'Page 1A'!E48","v":20},10.0,null,{"$f":"'Page 1A'!H48","v":500},null,null,500.0,0.0,0.0,null,{"$f":"E48","v":20},10,"",500,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O48","v":20},10,500,null,null,0.0,0.0]
[93.0,{"$f":"'Page 1A'!B49","v":"Policemen"},null,null,{"$f":"'Page 1A'!E49","v":20},10.0,null,{"$f":"'Page 1A'!H49","v":500},null,null,500.0,0.0,0.0,null,{"$f":"E49","v":20},10,"",500,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O49","v":20},10,500,null,null,0.0,0.0]
[94.0,{"$f":"'Page 1A'!B50","v":"Welfare/Teacher"},null,null,{"$f":"'Page 1A'!E50","v":20},10.0,null,{"$f":"'Page 1A'!H50","v":500},null,null,500.0,0.0,0.0,null,{"$f":"E50","v":20},10,"",500,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O50","v":20},10,500,null,null,0.0,0.0]
[95.0,{"$f":"'Page 1A'!B51","v":"Choreographer"},null,"incl. 20%agency",{"$f":"'Page 1A'!E51","v":20},10.0,null,{"$f":"'Page 1A'!H51","v":2500},null,null,2500.0,0.0,0.0,null,{"$f":"E51","v":20},10,"",2500,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O51","v":20},10,2500,null,null,0.0,0.0]
[96.0,{"$f":"'Page 1A'!B52","v":"Gang Boss"},null,null,{"$f":"'Page 1A'!E52","v":31},10.0,null,{"$f":"'Page 1A'!H52","v":460},null,null,460.0,0.0,0.0,null,{"$f":"E52","v":31},10,"",460,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O52","v":31},10,460,null,null,0.0,0.0]
[97.0,{"$f":"'Page 1A'!B53","v":"Teamsters/Driver"},null,null,{"$f":"'Page 1A'!E53","v":31},10.0,null,{"$f":"'Page 1A'!H53","v":420},null,null,420.0,0.0,0.0,null,{"$f":"E53","v":31},10,"",420,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O53","v":31},10,420,null,null,0.0,0.0]
[98.0,{"$f":"'Page 1A'!B54","v":"Teamster/Caterers"},{"$f":"'Page 1A'!C54","v":"2 people"},null,{"$f":"'Page 1A'!E54","v":31},10.0,null,{"$f":"'Page 1A'!H54","v":850},null,null,850.0,0.0,0.0,null,{"$f":"E54","v":31},10,"",850,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O54","v":31},10,850,null,null,0.0,0.0]
[99.0,{"$f":"'Page 1A'!B55","v":"Production Assistant"},null,null,{"$f":"'Page 1A'!E55","v":29},10.0,null,{"$f":"'Page 1A'!H55","v":200},null,null,200.0,0.0,0.0,null,{"$f":"E55","v":29},10,"",200,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O55","v":29},10,200,null,null,0.0,0.0]
[100.0,{"$f":"'Page 1A'!B56","v":"Runner"},null,null,{"$f":"'Page 1A'!E56","v":29},10.0,null,{"$f":"'Page 1A'!H56","v":200},null,null,200.0,0.0,0.0,null,{"$f":"E56","v":29},10,"",200,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O56","v":29},10,200,null,null,0.0,0.0]
[null,null,null,null,null,null,{"$f":"SUM(G7:G56)","v":0},null,null,"Sub-total B",null,{"$f":"SUM(L7:L56)","v":0},0,null,null,null,null,null,null,"Sub-total Bw",{"$f":"SUM(U7:U56)","v":0},0,null,null,null,null,null,null,"Sub-total B",{"$f":"SUM(AD7:AD56)","v":0},null,null,null,null,null,"Sub-total OT",{"$f":"SUM(AK7:AK56)","v":0},0]
[null,null,null,null,null,null,null,null,"PT/P&W",null,null,{"$f":"PT_B","v":0},null,null,null,null,null,null,"PT/P&W",null,{"$f":"PT_Bw","v":0},null,null,null,null,null,null,"PT/P&W",null,0.0,null,null,null,null,null,"PT/P&W",{"$f":"PT_Bot","v":0}]
[null,null,null,null,null,null,null,null,"TOTAL B",null,null,{"$f":"SUM(L57:L58)","v":0},null,null,null,null,null,null,"TOTAL Bw",null,{"$f":"SUM(U57:U58)","v":0},null,null,null,null,null,null,"TOTAL B",null,{"$f":"SUM(AD57:AD58)","v":0},null,null,null,null,null,"TOTAL OT",{"$f":"SUM(AK57:AK58)","v":0}]

{"sheet":"Page 2","index":10,"n_rows":63,"n_cols":14,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"IF('Top Sheet'!$C$5=\"\",\"\",'Top Sheet'!$C$5)","v":""},null,null,null,null,null,null,null,null,null,null,null,"Page 2","Page 2"]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$15=\"\",\"\",'Top Sheet'!$L$15),IF('Top Sheet'!$L$12=\"\",\"\",'Top Sheet'!$L$12))","v":""}]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$16=\"\",\"\",'Top Sheet'!$L$16),IF('Top Sheet'!$L$13=\"\",\"\",'Top Sheet'!$L$13))","v":""}]
["C","PRE-PRODUCTION & WRAP EXPENSES",null,"Amount","Rate","x","R/C","ESTIMATED",null,"Amount","Rate","x","WORKING","ACTUAL"]
[101.0,"Auto/Passenger Van Rentals",null,null,150.0,null,{"$f":"E6:E18*X_RATE","v":150},{"$f":"ROUND(D6:D18*E6:E18*IF(F6:F18=0,1,F6:F18),0)","v":0},null,{"$f":"D6","v":""},150,"",{"$f":"ROUND(J6:J18*K6:K18*IF(L6:L18=0,1,L6:L18),2)","v":0},0.0]
[102.0,"Air Fares",null,null,0.0,null,0.0,0.0,null,{"$f":"D7","v":""},0,"",0.0,0.0]
[103.0,"Per Diems",null,null,null,null,0.0,0.0,null,{"$f":"D8","v":""},"","",0.0,0.0]
[104.0,"Still Camera & Film",null,null,350.0,null,350.0,0.0,null,{"$f":"D9","v":""},350,"",0.0,0.0]
[105.0,"Messengers",null,null,300.0,null,300.0,0.0,null,{"$f":"D10","v":""},300,"",0.0,0.0]
[106.0,"Trucking",null,null,400.0,null,400.0,0.0,null,{"$f":"D11","v":""},400,"",0.0,0.0]
[107.0,"Deliveries & Taxis",null,null,null,null,0.0,0.0,null,{"$f":"D12","v":""},"","",0.0,0.0]
[108.0,"Video Conferencing",null,null,0.0,null,0.0,0.0,null,{"$f":"D13","v":""},0,"",0.0,0.0]
[109.0,"Telephone & Cable",null,null,null,null,0.0,0.0,null,{"$f":"D14","v":""},"","",0.0,0.0]
[110.0,"Casting Director ","Prep: 2   Cast:   2       Callback: 1",null,1200.0,null,1200.0,0.0,null,{"$f":"D15","v":""},1200,"",0.0,0.0]
[111.0,"Casting Facilities",null,null,1100.0,null,1100.0,0.0,null,{"$f":"D16","v":""},1100,"",0.0,0.0]
[112.0,"Polaroids/Internet Posting",null,null,350.0,null,350.0,0.0,null,{"$f":"D17","v":""},350,"",0.0,0.0]
[113.0,"Scouting Expenses",null,{"$f":"'Page 1A'!G44","v":""},150.0,null,150.0,0.0,null,{"$f":"D18","v":""},150,"",0.0,0.0]
[" "," ",null,null,"TOTAL C",null,null,{"$f":"SUM(H6:H18)","v":0},null,null,"TOTAL Cw",null,{"$f":"SUM(M6:M18)","v":0},0]
["                                                                                                                                                    ","                                                                                                                                                    "]
["D","LOCATION EXPENSES",null,"Amount","Rate","x","R/C","ESTIMATED",null,"Amount","Rate","x","WORKING","ACTUAL"]
[114.0,"Location Fees           ",null,null,20000.0,null,{"$f":"E22:E47*X_RATE","v":20000},{"$f":"ROUND(D22:D47*E22:E47*IF(F22:F47=0,1,F22:F47),0)","v":0},null,{"$f":"D22","v":""},20000,"",{"$f":"ROUND(J22:J47*K22:K47*IF(L22:L47=0,1,L22:L47),2)","v":0},0.0]
[115.0,"Permits",null,null,1500.0,null,1500.0,0.0,null,{"$f":"D23","v":""},1500,"",0.0,0.0]
[116.0,"Car Rentals",null,null,null,null,0.0,0.0,null,{"$f":"D24","v":""},"","",0.0,0.0]
[117.0,"Bus/Passenger Van Rentals",null,null,150.0,1.0,150.0,0.0,null,{"$f":"D25","v":""},150,1,0.0,0.0]
[118.0,"Dressing Room Vehicles",null,null,1100.0,1.0,1100.0,0.0,null,{"$f":"D26","v":""},1100,1,0.0,0.0]
[119.0,"Parking, Tolls, and Gas",null,null,1500.0,1.0,1500.0,0.0,null,{"$f":"D27","v":""},1500,1,0.0,0.0]
[120.0,"Production Trucking",null,null,250.0,3.0,250.0,0.0,null,{"$f":"D28","v":""},250,3,0.0,0.0]
[121.0,"Camera Truck",null,null,300.0,3.0,300.0,0.0,null,{"$f":"D29","v":""},300,3,0.0,0.0]
[122.0,"Stake Bed/Pick UP/ATV/Lighting and grip",null,null,250.0,1.0,250.0,0.0,null,{"$f":"D30","v":""},250,1,0.0,0.0]
[123.0,"Customs",null,null,null,null,0.0,0.0,null,{"$f":"D31","v":""},"","",0.0,0.0]
[124.0,"Excess Bags",null,null,0.0,null,0.0,0.0,null,{"$f":"D32","v":""},0,"",0.0,0.0]
[125.0,"Air Fares",null,null,0.0,null,0.0,0.0,null,{"$f":"D33","v":""},0,"",0.0,0.0]
[126.0,"Hotel/Per Diems",null,null,null,null,0.0,0.0,null,{"$f":"D34","v":""},"","",0.0,0.0]
[127.0,"Tech Scout Breakfast & Lunch",null,null,200.0,null,200.0,0.0,null,{"$f":"D35","v":""},200,"",0.0,0.0]
[128.0,"Pre-Production Meeting & Fittings Meals",null,null,500.0,null,500.0,0.0,null,{"$f":"D36","v":""},500,"",0.0,0.0]
[129.0,"Breakfast",null,null,18.0,1.0,18.0,0.0,null,{"$f":"D37","v":""},18,1,0.0,0.0]
[130.0,"Lunch",null,null,21.0,1.0,21.0,0.0,null,{"$f":"D38","v":""},21,1,0.0,0.0]
[131.0,"Dinner",null,null,15.0,1.0,15.0,0.0,null,{"$f":"D39","v":""},15,1,0.0,0.0]
[132.0,"Set Security",null,null,350.0,2.0,350.0,0.0,null,{"$f":"D40","v":""},350,2,0.0,0.0]
[133.0,"Limousines",null,null,400.0,null,400.0,0.0,null,{"$f":"D41","v":""},400,"",0.0,0.0]
[134.0,"Cabs and Other Transportation",null,null,200.0,1.0,200.0,0.0,null,{"$f":"D42","v":""},200,1,0.0,0.0]
[135.0,"Kit Rental",null,null,100.0,4.0,100.0,0.0,null,{"$f":"D43","v":""},100,4,0.0,0.0]
[136.0,"Art Work",null,null,null,null,0.0,0.0,null,{"$f":"D44","v":""},"","",0.0,0.0]
[137.0,"Talent Meal",null,null,39.0,null,39.0,0.0,null,{"$f":"D45","v":""},39,"",0.0,0.0]
[138.0,"Craft Services",null,null,10.0,1.0,10.0,0.0,null,{"$f":"D46","v":""},10,1,0.0,0.0]
[139.0,"Cell Phones",null,null,null,null,0.0,0.0,null,{"$f":"D47","v":""},"","",0.0,0.0]
[null,null,null,null,"TOTAL D",null,null,{"$f":"SUM(H22:H47)","v":0},null,null,"TOTAL Dw",null,{"$f":"SUM(M22:M47)","v":0},0]
[]
["E","PROPS, WARDROBE & ANIMALS",null,"Amount","Rate","x","R/C","ESTIMATED",null,"Amount","Rate","x","WORKING","ACTUAL"]
[140.0,"Prop Rentals",null,null,500.0,null,{"$f":"E51:E61*X_RATE","v":500},{"$f":"ROUND(D51:D61*E51:E61*IF(F51:F61=0,1,F51:F61),0)","v":0},null,{"$f":"D51","v":""},500,"",{"$f":"ROUND(J51:J61*K51:K61*IF(L51:L61=0,1,L51:L61),2)","v":0},0.0]
[141.0,"Prop Purchases",null,null,500.0,null,500.0,0.0,null,{"$f":"D52","v":""},500,"",0.0,0.0]
[142.0,"Wardrobe Rentals",null,null,1000.0,2.0,1000.0,0.0,null,{"$f":"D53","v":""},1000,2,0.0,0.0]
[143.0,"Wardrobe Purchases",null,null,1000.0,2.0,1000.0,0.0,null,{"$f":"D54","v":""},1000,2,0.0,0.0]
[144.0,"Picture Vehicles",null,null,null,null,0.0,0.0,null,{"$f":"D55","v":""},"","",0.0,0.0]
[145.0,"Animals and Handlers",null,null,null,null,0.0,0.0,null,{"$f":"D56","v":""},"","",0.0,0.0]
[146.0,"Wigs & Mustaches",null,null,null,null,0.0,0.0,null,{"$f":"D57","v":""},"","",0.0,0.0]
[147.0,"Color Correction",null,null,null,null,0.0,0.0,null,{"$f":"D58","v":""},"","",0.0,0.0]
[148.0,"Atmospheric FX (Wind, Fog, Rain, Etc.)",null,null,null,null,0.0,0.0,null,{"$f":"D59","v":""},"","",0.0,0.0]
[149.0,"Water Truck ",null,null,1200.0,null,1200.0,0.0,null,{"$f":"D60","v":""},1200,"",0.0,0.0]
[150.0,null,null,null,0.0,null,0.0,0.0,null,{"$f":"D61","v":""},0,"",0.0,0.0]
[null,null,null,null,"TOTAL E",null,null,{"$f":"SUM(H51:H61)","v":0},null,null,"TOTAL Ew",null,{"$f":"SUM(M51:M61)","v":0},0]
["                                                                                                                                                    ","                                                                                                                                                    "]

{"sheet":"Page 3","index":11,"n_rows":61,"n_cols":38,"rows_kept":61,"cut":false,"hidden":false,"merged":[[24,31,24,36],[25,8,25,10],[25,18,25,19],[25,22,25,24],[25,25,25,27],[25,34,25,35]]}
[]
[{"$f":"IF('Top Sheet'!$C$5=\"\",\"\",'Top Sheet'!$C$5)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 3",null,null,null,null,null,null,null,null,"Page 3"]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$15=\"\",\"\",'Top Sheet'!$L$15),IF('Top Sheet'!$L$12=\"\",\"\",'Top Sheet'!$L$12))","v":""}]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$16=\"\",\"\",'Top Sheet'!$L$16),IF('Top Sheet'!$L$13=\"\",\"\",'Top Sheet'!$L$13))","v":""}]
["F","STUDIO RENTAL & EXPENSES",null,null,null,null,null,"Amount","Rate","x","R/C","ESTIMATED",null,null,null,null,null,"Amount","Rate","x","WORKING",null,null,null,null,null,null,null,null,"ACTUAL"]
[151.0,"Rental for Build",null,null,null,null,null,null,null,null,{"$f":"I6:I22*X_RATE","v":0},{"$f":"ROUND(H6:H22*I6:I22*IF(J6:J22=0,1,J6:J22),0)","v":0},null,null,null,null,null,{"$f":"H6","v":""},"","",{"$f":"ROUND(R6:R22*S6:S22*IF(T6:T22=0,1,T6:T22),2)","v":0},null,null,null,null,null,null,null,null,0.0]
[152.0,"Build OT Hours",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H7","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[153.0,"Rental for Pre-Lite Days",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,null,null,{"$f":"J8","v":""},0.0,null,null,null,null,null,null,null,null,0.0]
[154.0,"Pre-Lite OT Hours",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H8","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[155.0,"Rental for Shoot Days",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,null,null,null,0.0,null,null,null,null,null,null,null,null,0.0]
[156.0,"Shoot OT Hours",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H10","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[157.0,"Rental for Strike Days",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H11","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[158.0,"Strike OT Hours",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H13","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[159.0,"Generator and Operator",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H14","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[160.0,"Studio Security",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H15","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[161.0,"Power Charges",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H16","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[162.0,"Trash",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H17","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[163.0,"Stage Manager",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H18","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[164.0,"Parking",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H19","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[165.0,"Telephones & Fax Machines",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H20","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[166.0,"Heat/Air Conditioning",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H21","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[167.0,"Misc Studio Charges",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H22","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[null,null,null,null,null,null,null,null,"TOTAL F",null,null,{"$f":"SUM(L6:L22)","v":0},null,null,null,null,null,null,"TOTAL Fw",null,{"$f":"SUM(U6:U22)","v":0},null,null,null,null,null,null,"TOTAL F",null,{"$f":"SUM(AD6:AD22)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OVERTIME CALCULATOR"]
[null,"SET CONSTRUCTION",null,null,"%","OT",null,null,"OT Hours",null,null,null,null,null,"%","OT",null,null,"OT Hours",null,null,null,"Payroll Log Detail",null,null,"Payroll Log Costs",null,null,"Other",null,null,"%","OT",null,"OT Hours",null,"OVERTIME"]
["G","CREW",null,"Notes","PT/P&W","Based","Days","Rate",1.5,2.0,"R/C","ESTIMATED","PT/P&W",null,"PT/P&W","Based","Days","Rate",{"$f":"I27","v":1.5},2,"WORKING","PT/P&W","Days","Rate","OT Hrs","Misc","ST","OT","Logs","ACTUAL",null,"PT/P&W","Based","Rate",1.5,2.0,"TOTAL"]
[168.0,"Production Designer","Prep:   Shoot:     Wrap:",null,31.0,10.0,null,1200.0,null,null,{"$f":"H28:H40*X_RATE","v":1200},{"$f":"ROUND((G28:G40*H28:H40)+(H28:H40/F28:F40*$I$27*I28:I40)+(H28:H40/F28:F40*$J$27*J28:J40),0)","v":0},{"$f":"ROUND(L28:L40*E28:E40/100,0)","v":0},null,{"$f":"E28","v":31},10,"",1200,"","",{"$f":"ROUND((Q28:Q40*R28:R40)+(R28:R40/P28:P40*$S$27*S28:S40)+(R28:R40/P28:P40*$T$27*T28:T40),2)","v":0},{"$f":"ROUND(U28:U40*O28:O40/100,2)","v":0},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O28","v":31},10,{"$f":"R28","v":1200},null,null,{"$f":"IF(AG28:AG240=0,0,ROUND((AH28:AH40/AG28:AG40*$AI$27*AI28:AI40)+(AH28:AH40/AG28:AG40*$AJ$27*AJ28:AJ40),2))","v":0},{"$f":"ROUND(AK28:AK40*AF28:AF40/100,2)","v":0}]
[169.0,"Art Director",null,null,31.0,10.0,null,850.0,null,null,850.0,0.0,0.0,null,{"$f":"E29","v":31},10,"",850,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O29","v":31},10,850,null,null,0.0,0.0]
[170.0,"Art Department Coordinator",null,null,31.0,10.0,null,650.0,null,null,650.0,0.0,0.0,null,{"$f":"E30","v":31},10,"",650,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O30","v":31},10,650,null,null,0.0,0.0]
[171.0,"Buyer",null,null,31.0,10.0,null,600.0,null,null,600.0,0.0,0.0,null,{"$f":"E31","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O31","v":31},10,600,null,null,0.0,0.0]
[172.0,"Prop Master",null,null,31.0,10.0,null,600.0,null,null,600.0,0.0,0.0,null,{"$f":"E32","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O32","v":31},10,600,null,null,0.0,0.0]
[173.0,"Prop Assts.",null,null,31.0,10.0,null,500.0,null,null,500.0,0.0,0.0,null,{"$f":"E33","v":31},10,"",500,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O33","v":31},10,500,null,null,0.0,0.0]
[174.0,"Scenic",null,null,31.0,10.0,null,600.0,null,null,600.0,0.0,0.0,null,{"$f":"E34","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O34","v":31},10,600,null,null,0.0,0.0]
[175.0,"Set Dresser",null,null,31.0,10.0,null,450.0,null,null,450.0,0.0,0.0,null,{"$f":"E35","v":31},10,"",450,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O35","v":31},10,450,null,null,0.0,0.0]
[176.0,"Lead Man",null,null,31.0,10.0,null,600.0,null,null,600.0,0.0,0.0,null,{"$f":"E36","v":31},10,"",600,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O36","v":31},10,600,null,null,0.0,0.0]
[177.0,"Painter",null,null,31.0,10.0,null,450.0,null,null,450.0,0.0,0.0,null,{"$f":"E37","v":31},10,"",450,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O37","v":31},10,450,null,null,0.0,0.0]
[178.0,"Art PAs",null,null,31.0,10.0,null,225.0,null,null,225.0,0.0,0.0,null,{"$f":"E38","v":31},10,"",225,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O38","v":31},10,225,null,null,0.0,0.0]
[179.0,"Strike Crew",null,null,31.0,10.0,null,450.0,null,null,450.0,0.0,0.0,null,{"$f":"E39","v":31},10,"",450,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O39","v":31},10,450,null,null,0.0,0.0]
[180.0,"Illustrator",null,null,20.0,10.0,null,750.0,null,null,750.0,0.0,0.0,null,{"$f":"E40","v":20},10,"",750,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"O40","v":20},10,750,null,null,0.0,0.0]
[null,null,null,null,null,null,{"$f":"SUM(G28:G40)","v":0},null,null,"Sub-total G",null,{"$f":"SUM(L27:L40)","v":0},{"$f":"SUM(M28:M40)","v":0},null,null,null,{"$f":"SUM(Q28:Q40)","v":0},null,null,"Sub-total Gw",{"$f":"SUM(U28:U40)","v":0},0,null,null,null,null,null,null,"Sub-total G",{"$f":"SUM(AD28:AD40)","v":0},null,null,null,null,null,"Sub-total OT",{"$f":"SUM(AK28:AK40)","v":0},0]
[null,null,null,null,null,null,null,null,"PT/P&W",null,null,{"$f":"PT_G","v":0},null,null,null,null,null,null,"PT/P&W",null,{"$f":"PT_Gw","v":0},null,null,null,null,null,null,"PT/P&W",null,0.0,null,null,null,null,null,"PT/P&W",{"$f":"PT_Got","v":0}]
[null,null,null,null,null,null,null,null,"TOTAL G",null,null,{"$f":"SUM(L41:L42)","v":0},null,null,null,null,null,null,"TOTAL Gw",null,{"$f":"SUM(U41:U42)","v":0},null,null,null,null,null,null,"TOTAL G",null,{"$f":"SUM(AD41:AD42)","v":0},null,null,null,null,null,"TOTAL OT",{"$f":"SUM(AK41:AK42)","v":0}]
[null,"                                                                                                                                                    "]
[null,"                                                                                                                                                    "]
["H","SET CONSTRUCTION MATERIALS",null,null,null,null,null,"Amount","Rate","x","R/C","ESTIMATED",null,null,null,null,null,"Amount","Rate","x","WORKING",null,null,null,null,null,null,null,null,"ACTUAL"]
[181.0,"Set Dressing Purchases",null,null,null,null,null,null,null,null,{"$f":"I47:I58*X_RATE","v":0},{"$f":"ROUND(H47:H58*I47:I58*IF(J47:J58=0,1,J47:J58),0)","v":0},null,null,null,null,null,{"$f":"H47","v":""},"","",{"$f":"ROUND(R47:R58*S47:S58*IF(T47:T58=0,1,T47:T58),2)","v":0},null,null,null,null,null,null,null,null,0.0]
[182.0,"Set Dressing Rentals",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H48","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[183.0,"Polaroid/Film/Developing",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H49","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[184.0,"Art Supplies",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H50","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[185.0,"Paint/Hardware",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H51","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[186.0,"Special effects",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H52","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[187.0,"Set Build",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H53","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[188.0,"Art Trucking",null,null,null,null,null,null,250.0,null,250.0,0.0,null,null,null,null,null,{"$f":"H54","v":""},250,"",0.0,null,null,null,null,null,null,null,null,0.0]
[189.0,"Messengers/Deliveries",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H55","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[190.0,"Parking/Gasoline/Mileage",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H56","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[191.0,"Kit Rental",null,null,null,null,null,null,250.0,null,250.0,0.0,null,null,null,null,null,{"$f":"H57","v":""},250,"",0.0,null,null,null,null,null,null,null,null,0.0]
[192.0,"Expendables",null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,{"$f":"H58","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[null,null,null,null,null,null,null,null,"TOTAL H",null,null,{"$f":"SUM(L47:L58)","v":0},null,null,null,null,null,null,"TOTAL Hw",null,{"$f":"SUM(U47:U58)","v":0},null,null,null,null,null,null,"TOTAL H",null,{"$f":"SUM(AD47:AD58)","v":0}]
[]
[null,"                  "]

{"sheet":"Page 4","index":12,"n_rows":61,"n_cols":16,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"IF('Top Sheet'!$C$5=\"\",\"\",'Top Sheet'!$C$5)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 4","Page 4"]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$15=\"\",\"\",'Top Sheet'!$L$15),IF('Top Sheet'!$L$12=\"\",\"\",'Top Sheet'!$L$12))","v":""}]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$16=\"\",\"\",'Top Sheet'!$L$16),IF('Top Sheet'!$L$13=\"\",\"\",'Top Sheet'!$L$13))","v":""}]
["I","EQUIPMENT RENTAL",null,null,"Amount","Rate","x","R/C","ESTIMATED",null,null,"Amount","Rate","x","WORKING","ACTUAL"]
[193.0,"Camera Rental",null,null,null,5500.0,1.0,{"$f":"F6:F23*X_RATE","v":5500},{"$f":"ROUND(E6:E23*F6:F23*IF(G6:G23=0,1,G6:G23),0)","v":0},null,null,{"$f":"E6","v":""},5500,1,{"$f":"ROUND(L6:L23*M6:M23*IF(N6:N23=0,1,N6:N23),2)","v":0},0.0]
[194.0,"Sound Rental",null,null,null,850.0,1.0,850.0,0.0,null,null,{"$f":"E7","v":""},850,1,0.0,0.0]
[195.0,"Lighting Rental",null,null,null,7000.0,1.0,7000.0,0.0,null,null,{"$f":"E8","v":""},7000,1,0.0,0.0]
[196.0,"Grip Rental",null,null,null,3500.0,1.0,3500.0,0.0,null,null,{"$f":"E9","v":""},3500,1,0.0,0.0]
[197.0,"Generator Rental",null,null,null,950.0,1.0,950.0,0.0,null,null,{"$f":"E10","v":""},950,1,0.0,0.0]
[198.0,"Crane Rental",null,null,null,1500.0,null,1500.0,0.0,null,null,{"$f":"E11","v":""},1500,"",0.0,0.0]
[199.0,"VTR Rental",null,null,null,850.0,1.0,850.0,0.0,null,null,{"$f":"E12","v":""},850,1,0.0,0.0]
[200.0,"Walkie Talkie Rental",null,null,null,12.0,1.0,12.0,0.0,null,null,{"$f":"E13","v":""},12,1,0.0,0.0]
[201.0,"Dolly Rental",null,null,null,450.0,1.0,450.0,0.0,null,null,{"$f":"E14","v":""},450,1,0.0,0.0]
[202.0,"Camera Car Rental",null,null,null,null,null,0.0,0.0,null,null,{"$f":"E15","v":""},"","",0.0,0.0]
[203.0,"Helicopter",null,null,null,null,null,0.0,0.0,null,null,{"$f":"E16","v":""},"","",0.0,0.0]
[204.0,"Production Supplies",null,null,null,1000.0,1.0,1000.0,0.0,null,null,{"$f":"E17","v":""},1000,1,0.0,0.0]
[205.0,"Construction Cranes",null,null,null,null,null,0.0,0.0,null,null,{"$f":"E18","v":""},"","",0.0,0.0]
[206.0,"Remote Head",null,null,null,null,null,0.0,0.0,null,null,{"$f":"E19","v":""},"","",0.0,0.0]
[207.0,"Special Camera Equipment",null,null,null,null,null,0.0,0.0,null,null,{"$f":"E20","v":""},"","",0.0,0.0]
[208.0,"Blue/Green Screen",null,null,null,null,null,0.0,0.0,null,null,{"$f":"E21","v":""},"","",0.0,0.0]
[209.0,"Expendables",null,null,null,1000.0,1.0,1000.0,0.0,null,null,{"$f":"E22","v":""},1000,1,0.0,0.0]
[210.0,"Steadicam",null,null,null,1500.0,null,1500.0,0.0,null,null,{"$f":"E23","v":""},1500,"",0.0,0.0]
[null,null,null,null,null,"TOTAL I",null,null,{"$f":"SUM(I6:I23)","v":0},null,null,null,"TOTAL Iw",null,{"$f":"SUM(O6:O23)","v":0},0]
[]
[]
["J","FILMSTOCK, DEVELOP & PRINT",null,null,"Amount","Rate","x","R/C","ESTIMATED",null,null,"Amount","Rate","x","WORKING","ACTUAL"]
[211.0,"Purchase Filmstock",null,null,null,0.72,{"$f":"'Page 1B'!G7","v":""},{"$f":"F28:F33*X_RATE","v":0.72},{"$f":"ROUND(E28:E33*F28:F33*IF(G28:G33=0,1,G28:G33),0)","v":0},null,null,{"$f":"E28","v":""},0.72,"",{"$f":"ROUND(L28:L33*M28:M33*IF(N28:N33=0,1,N28:N33),2)","v":0},0.0]
[212.0,"Develop Filmstock",null,null,null,0.21,{"$f":"G28","v":""},0.21,0.0,null,null,{"$f":"E29","v":""},0.21,"",0.0,0.0]
[213.0,"Hard Drives/Tapes",null,null,null,350.0,null,350.0,0.0,null,null,{"$f":"E30","v":""},350,"",0.0,0.0]
[214.0,"HD MOS Video Dailies",null,null,null,0.55,null,0.55,0.0,null,null,{"$f":"E31","v":""},0.55,"",0.0,0.0]
[215.0,"SD MOS Video Dallies",null,null,null,0.35,{"$f":"G28","v":""},0.35,0.0,null,null,{"$f":"E32","v":""},0.35,"",0.0,0.0]
[216.0,"Transcoding",null,null,null,0.0,null,0.0,0.0,null,null,{"$f":"E33","v":""},0,"",0.0,0.0]
[null,null,null,null,null,"TOTAL J",null,null,{"$f":"SUM(I28:I33)","v":0},null,null,null,"TOTAL Jw",null,{"$f":"SUM(O28:O33)","v":0},0]
[null,"                                                                                                                                                    "]
[null,"                                                                                                                                                    "]
["K","MISCELLANEOUS COSTS",null,null,"Amount","Rate","x","R/C","ESTIMATED",null,null,"Amount","Rate","x","WORKING","ACTUAL"]
[217.0,"Petty Cash ",null,null,null,0.0,null,{"$f":"F38:F47*X_RATE","v":0},{"$f":"ROUND(E38:E47*F38:F47*IF(G38:G47=0,1,G38:G47),0)","v":0},null,null,{"$f":"E38","v":""},0,"",{"$f":"ROUND(L38:L47*M38:M47*IF(N38:N47=0,1,N38:N47),2)","v":0},0.0]
[218.0,"Air Shipping and Carriers",null,null,null,1000.0,null,1000.0,0.0,null,null,{"$f":"E39","v":""},1000,"",0.0,0.0]
[219.0,"Phones and Cables",null,null,null,0.0,null,0.0,0.0,null,null,{"$f":"E40","v":""},0,"",0.0,0.0]
[220.0,"Cash Under $15 Each",null,null,null,0.0,null,0.0,0.0,null,null,{"$f":"E41","v":""},0,"",0.0,0.0]
[221.0,"Internal Billing Costs                                               ",null,null,null,null,null,0.0,0.0,null,null,{"$f":"E42","v":""},"","",0.0,0.0]
[222.0,"Special Insurance",null,null,null,0.0,null,0.0,0.0,null,null,{"$f":"E43","v":""},0,"",0.0,0.0]
[223.0,"Foreign Work Comp",null,null,null,150.0,null,150.0,0.0,null,null,{"$f":"E44","v":""},150,"",0.0,0.0]
[224.0,"Negative/Dailies Shipping",null,null,null,0.0,null,0.0,0.0,null,null,{"$f":"E45","v":""},0,"",0.0,0.0]
[225.0,"Glam Squad Agents fees",null,null,null,{"$f":"'Page 1A'!L29+'Page 1A'!L30+'Page 1A'!L32+'Page 1B'!L29+'Page 1B'!L30+'Page 1B'!L32","v":0},1.0,0.0,0.0,null,null,{"$f":"E46","v":""},0,1,0.0,0.0]
[226.0,null,null,null,null,0.0,null,0.0,0.0,null,null,{"$f":"E47","v":""},0,"",0.0,0.0]
[null,null,null,null,null,"TOTAL K",null,null,{"$f":"SUM(I38:I47)","v":0},null,null,null,"TOTAL Kw",null,{"$f":"SUM(O38:O47)","v":0},0]
[null,"                                                                                                                                                    "]
[null,"                                                                                                                               ",null,"%"]
["L","DIRECTOR/CREATIVE FEES",null,"PT/P&W","Amount","Rate","x","R/C","ESTIMATED","PT/P&W",null,"Amount","Rate","x","WORKING","ACTUAL"]
[227.0,"Director Prep",null,null,null,null,null,{"$f":"F52:F58*X_RATE","v":0},{"$f":"ROUND(E52:E58*F52:F58*IF(G52:G58=0,1,G52:G58),0)","v":0},{"$f":"ROUND(I52:I58*D52:D58/100,0)","v":0},null,{"$f":"E52","v":""},"","",{"$f":"ROUND(L52:L58*M52:M58*IF(N52:N58=0,1,N52:N58),2)","v":0},0.0]
[228.0,"Director Travel",null,null,null,null,null,0.0,0.0,0.0,null,{"$f":"E53","v":""},"","",0.0,0.0]
[229.0,"Director Shoot",null,null,null,21500.0,1.0,21500.0,0.0,0.0,null,{"$f":"E54","v":""},21500,1,0.0,0.0]
[230.0,"Director Post",null,null,null,null,null,0.0,0.0,0.0,null,{"$f":"E55","v":""},"","",0.0,0.0]
[231.0,"Fringes",null,null,null,null,null,0.0,0.0,0.0,null,{"$f":"E56","v":""},"","",0.0,0.0]
[232.0,null,null,null,null,null,null,0.0,0.0,0.0,null,{"$f":"E57","v":""},"","",0.0,0.0]
[233.0,null,null,null,null,0.0,null,0.0,0.0,0.0,null,{"$f":"E58","v":""},0,"",0.0,0.0]
[null,null,null,null,null,null,"Sub-total L",null,{"$f":"SUM(I52:I58)","v":0},0,null,null,null,"Sub-total Lw",{"$f":"SUM(O52:O58)","v":0},0]
[null,null,null,null,null,"PT/P&W",null,null,{"$f":"PT_L","v":0},null,null,null,"PT/P&W",null,{"$f":"I60","v":0},0.0]
[null,null,null,null,null,"TOTAL L",null,null,{"$f":"SUM(I59:I60)","v":0},null,null,null,"TOTAL Lw",null,{"$f":"SUM(O59:O60)","v":0},0]

{"sheet":"Page 5","index":13,"n_rows":58,"n_cols":42,"rows_kept":58,"cut":false,"hidden":false,"merged":[[3,35,3,40],[4,10,4,11],[4,22,4,23],[4,26,4,28],[4,29,4,31],[4,38,4,39]]}
[]
[{"$f":"IF('Top Sheet'!$C$5=\"\",\"\",'Top Sheet'!$C$5)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 5",null,null,null,null,null,null,null,null,"Page 5"]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$15=\"\",\"\",'Top Sheet'!$L$15),IF('Top Sheet'!$L$12=\"\",\"\",'Top Sheet'!$L$12))","v":""}]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$16=\"\",\"\",'Top Sheet'!$L$16),IF('Top Sheet'!$L$13=\"\",\"\",'Top Sheet'!$L$13))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OVERTIME CALCULATOR"]
[null,"Talent",null,null,"%","OT",null,"Travel","Shoot",null,"OT Hours",null,"Rate",null,null,null,"%","OT",null,"Travel","Shoot",null,"OT Hours",null,null,null,"Payroll Log Detail",null,null,"Payroll Log Costs",null,null,"Other",null,null,"%","OT",null,"OT Hours",null,"OVERTIME"]
["M",null,null,"Notes","PT/P&W","Based","No.","Days","Days","Rate",1.5,2.0,"Change","ESTIMATED","PT/P&W",null,"PT/P&W","Based","No.","Days","Days","Rate",{"$f":"K6","v":1.5},2,"WORKING","PT/P&W","Days","Rate","OT Hrs","Misc","ST","OT","Logs","ACTUAL",null,"PT/P&W","Based","Rate",1.5,2.0,"TOTAL"]
[234.0,"O/C Principals",null,null,20.0,8.0,null,null,null,null,null,null,{"$f":"J7:J38*X_RATE","v":0},{"$f":"ROUND(G7:G38*(((I7:I38+H7:H38)*J7:J38)+(J7:J38/F7:F38*$K$6*K7:K38)+(J7:J38/F7:F38*$L$6*L7:L38)),0)","v":0},{"$f":"ROUND(N7:N38*E7:E38/100,0)","v":0},null,{"$f":"E7","v":20},8,"","","","","","",{"$f":"ROUND(S7:S38*(((U7:U38+T7:T38)*V7:V38)+(V7:V38/R7:R38*$W$6*W7:W38)+(V7:V38/R7:R38*$X$6*X7:X38)),2)","v":0},{"$f":"ROUND(Y7:Y38*Q7:Q38/100,2)","v":0},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q7","v":20},8,{"$f":"V7","v":""},null,null,{"$f":"IF(AK7:AK38=0,0,ROUND((AL7:AL38/AK7:AK38*$AM$6*AM7:AM38)+(AL7:AL38/AK7:AK38*$AN$6*AN7:AN38),2))","v":0},{"$f":"ROUND(AO7:AO38*AJ7:AJ38/100,2)","v":0}]
[235.0,"O/C Principals",null,null,20.0,8.0,null,null,null,null,null,null,0.0,0.0,0.0,null,{"$f":"E8","v":20},8,"","","","","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q8","v":20},8,"",null,null,0.0,0.0]
[236.0,"O/C Principals",null,null,20.0,8.0,null,null,null,null,null,null,0.0,0.0,0.0,null,{"$f":"E9","v":20},8,"","","","","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q9","v":20},8,"",null,null,0.0,0.0]
[237.0,"O/C Principals",null,null,20.0,8.0,null,null,null,null,null,null,0.0,0.0,0.0,null,{"$f":"E10","v":20},8,"","","","","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q10","v":20},8,"",null,null,0.0,0.0]
[238.0,"O/C Principals",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E11","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q11","v":20},8,0,null,null,0.0,0.0]
[239.0,"O/C Principals",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E12","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q12","v":20},8,0,null,null,0.0,0.0]
[240.0,"O/C Principals",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E13","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q13","v":20},8,0,null,null,0.0,0.0]
[241.0,"O/C Principals",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E14","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q14","v":20},8,0,null,null,0.0,0.0]
[242.0,"O/C Principals",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E15","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q15","v":20},8,0,null,null,0.0,0.0]
[243.0,"O/C Principals",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E16","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q16","v":20},8,0,null,null,0.0,0.0]
[244.0,null,null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E17","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q17","v":20},8,0,null,null,0.0,0.0]
[245.0,null,null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E18","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q18","v":20},8,0,null,null,0.0,0.0]
[246.0,null,null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E19","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q19","v":20},8,0,null,null,0.0,0.0]
[247.0,"General Extras",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E20","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q20","v":20},8,0,null,null,0.0,0.0]
[248.0,"General Extras",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E21","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q21","v":20},8,0,null,null,0.0,0.0]
[249.0,"General Extras",null,null,20.0,8.0,null,null,null,null,null,null,0.0,0.0,0.0,null,{"$f":"E22","v":20},8,"","","","","","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q22","v":20},8,"",null,null,0.0,0.0]
[250.0,"General Extras",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E23","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q23","v":20},8,0,null,null,0.0,0.0]
[251.0,"General Extras",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E24","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q24","v":20},8,0,null,null,0.0,0.0]
[252.0,"General Extras",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E25","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q25","v":20},8,0,null,null,0.0,0.0]
[253.0,null,null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E26","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q26","v":20},8,0,null,null,0.0,0.0]
[254.0,null,null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E27","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q27","v":20},8,0,null,null,0.0,0.0]
[255.0,null,null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E28","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q28","v":20},8,0,null,null,0.0,0.0]
[256.0,"Hand Models",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E29","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q29","v":20},8,0,null,null,0.0,0.0]
[257.0,null,null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E30","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q30","v":20},8,0,null,null,0.0,0.0]
[258.0,null,null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E31","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q31","v":20},8,0,null,null,0.0,0.0]
[259.0,"Voice Over",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E32","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q32","v":20},8,0,null,null,0.0,0.0]
[260.0,"Fitting Fees",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E33","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q33","v":20},8,0,null,null,0.0,0.0]
[261.0,"Fitting Fees",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E34","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q34","v":20},8,0,null,null,0.0,0.0]
[262.0,null,null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E35","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q35","v":20},8,0,null,null,0.0,0.0]
[263.0,"Audition Fees",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E36","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q36","v":20},8,0,null,null,0.0,0.0]
[264.0,"Audition Fees",null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E37","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q37","v":20},8,0,null,null,0.0,0.0]
[265.0,null,null,null,20.0,8.0,null,null,null,0.0,null,null,0.0,0.0,0.0,null,{"$f":"E38","v":20},8,"","","",0,"","",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"Q38","v":20},8,0,null,null,0.0,0.0]
[null," ",null,null,null,null,{"$f":"SUM(G7:G38)","v":0},{"$f":"SUM(H13:H38)","v":0},{"$f":"SUM(I7:I38)","v":0},null,null,"Sub-total M",null,{"$f":"SUM(N7:N38)","v":0},0,null,null,null,{"$f":"SUM(S7:S38)","v":0},0,0,null,null,"Sub-total Mw",{"$f":"SUM(Y7:Y38)","v":0},0,null,null,null,null,null,null,"Sub-total M",{"$f":"SUM(AH7:AH38)","v":0},null,null,null,null,null,"Sub-total OT",{"$f":"SUM(AO7:AO38)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,"R/C",{"$f":"PT_M","v":0},null,null,null,null,null,null,null,null,"PT/P&W",null,{"$f":"PT_Mw","v":0},null,null,null,null,null,null,"PT/P&W",null,0.0,null,null,null,null,null,"PT/P&W",{"$f":"PT_Mot","v":0}]
[266.0,"Talent Agency Fees",null,null,null,null,null,null,null,0.2,{"$f":"N39","v":0},null,{"$f":"K41:K44*X_RATE","v":0},{"$f":"ROUND(J41:J44*K41:K44*IF(L41:L44=0,1,L41:L44),0)","v":0},null,null,null,null,null,null,null,{"$f":"J41","v":0.2},0,"",{"$f":"ROUND(V41:V44*W41:W44*IF(X41:X44=0,1,X41:X44),2)","v":0},null,null,null,null,null,null,null,null,0.0,null,null,null,null,null,"TOTAL OT",{"$f":"SUM(AO39:AO40)","v":0}]
[267.0,"Talent Payroll Service",null,null,null,null,null,null,null,null,0.0,null,0.0,0.0,null,null,null,null,null,null,null,{"$f":"J42","v":""},0,"",0.0,null,null,null,null,null,null,null,null,0.0]
[268.0,"Talent Wardrobe Allowance",null,null,null,null,null,null,null,null,null,null,0.0,0.0,null,null,null,null,null,null,null,{"$f":"J43","v":""},"","",0.0,null,null,null,null,null,null,null,null,0.0]
[269.0,"Other ",null,null,null,null,null,null,null,null,0.0,null,0.0,0.0,null,null,null,null,null,null,null,{"$f":"J44","v":""},0,"",0.0,null,null,null,null,null,null,null,null,0.0]
[270.0,"Mark Up",null,null,null,null,null,null,null,0.15,{"$f":"SUM(N39:N44)","v":0},null,null,{"$f":"J45*K45","v":0},null,null,null,null,null,null,null,{"$f":"IF(D_Talent=0,0,\"Talent Labor Mark-up\")","v":0},null,null,{"$f":"IF(D_Talent=0,0,'Top Sheet'!J38)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(A_TOTAL_AtoK<>0,SUM('Page 5'!AH39:AH44)<>0,SUM(ACTUAL_N)<>0,A_TOTAL_O<>0,A_TOTAL_P<>0),E_TOTAL_TALENTMARKUP,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"TOTAL M",null,null,{"$f":"SUM(N39:N45)","v":0},null,null,null,null,null,null,null,null,"TOTAL Mw",null,{"$f":"SUM(Y39:Y45)","v":0},null,null,null,null,null,null,"TOTAL M",null,{"$f":"SUM(AH39:AH45)","v":0}]
[]
[null,"                                                                                                                                                    "]
["N","TALENT EXPENSES                                                                                           ",null,null,null,null,null,null,null,"Amount","Rate","x","R/C","ESTIMATED",null,null,null,null,null,null,null,"Amount","Rate","x","WORKING",null,null,null,null,null,null,null,null,"ACTUAL"]
[271.0,"Talent Air Fares",null,null,null,null,null,null,null,null,null,null,{"$f":"K50:K54*X_RATE","v":0},{"$f":"ROUND(J50:J54*K50:K54*IF(L50:L54=0,1,L50:L54),0)","v":0},null,null,null,null,null,null,null,{"$f":"J50","v":""},"","",{"$f":"ROUND(V50:V54*W50:W54*IF(X50:X54=0,1,X50:X54),2)","v":0},null,null,null,null,null,null,null,null,0.0]
[272.0,"Talent Per Diem",null,null,null,null,null,null,null,null,0.0,null,0.0,0.0,null,null,null,null,null,null,null,{"$f":"J51","v":""},0,"",0.0,null,null,null,null,null,null,null,null,0.0]
[273.0,"Talent Ground Transportation",null,null,null,null,null,null,null,null,0.0,null,0.0,0.0,null,null,null,null,null,null,null,{"$f":"J52","v":""},0,"",0.0,null,null,null,null,null,null,null,null,0.0]
[274.0,"Other",null,null,null,null,null,null,null,null,0.0,null,0.0,0.0,null,null,null,null,null,null,null,{"$f":"J53","v":""},0,"",0.0,null,null,null,null,null,null,null,null,0.0]
[275.0,"Other",null,null,null,null,null,null,null,null,0.0,null,0.0,0.0,null,null,null,null,null,null,null,{"$f":"J54","v":""},0,"",0.0,null,null,null,null,null,null,null,null,0.0]
[276.0,"Mark Up",null,null,null,null,null,null,null,0.15,{"$f":"N50+N51+N52+N53+N54","v":0},null,null,{"$f":"J55*K55","v":0},null,null,null,null,null,null,null,{"$f":"IF(D_TalentExpenses=0,0,\"Talent Exp Mark-up\")","v":"Talent Exp Mark-up"},null,null,{"$f":"IF(D_TalentExpenses=0,0,'Top Sheet'!J39)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(A_TOTAL_AtoK<>0,SUM('Page 5'!AH39:AH44)<>0,SUM(ACTUAL_N)<>0,A_TOTAL_O<>0,A_TOTAL_P<>0),E_TOTAL_TALENTEXPENSESMARKUP,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"TOTAL N",null,null,{"$f":"SUM(N50:N55)","v":0},null,null,null,null,null,null,null,null,"TOTAL Nw",null,{"$f":"SUM(Y50:Y55)","v":0},null,null,null,null,null,null,"TOTAL N",null,{"$f":"SUM(AH50:AH55)","v":0}]
[null,"                                                                                                                                                    "]
[null,"                                                                                                                                                    "]

{"sheet":"Page 6","index":14,"n_rows":64,"n_cols":16,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"IF('Top Sheet'!$C$5=\"\",\"\",'Top Sheet'!$C$5)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 6","Page 6"]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$15=\"\",\"\",'Top Sheet'!$L$15),IF('Top Sheet'!$L$12=\"\",\"\",'Top Sheet'!$L$12))","v":""}]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$16=\"\",\"\",'Top Sheet'!$L$16),IF('Top Sheet'!$L$13=\"\",\"\",'Top Sheet'!$L$13))","v":""},null,null,"%"]
["O","OFF-LINE ",null,"PT/P&W","Amount","Rate","x","R/C","ESTIMATED","PT/P&W",null,"Amount","Rate","x","WORKING","ACTUAL"]
[277.0,"Post Supervisor",null,20.0,null,650.0,null,{"$f":"F6:F10*X_RATE","v":650},{"$f":"ROUND(E6:E10*F6:F10*IF(G6:G10=0,1,G6:G10),0)","v":0},{"$f":"ROUND(I6:I10*D6:D10/100,0)","v":0},null,{"$f":"E6","v":""},650,"",{"$f":"ROUND(L6:L10*M6:M10*IF(N6:N10=0,1,N6:N10),2)","v":0},0.0]
[278.0,"Off-line Editor",null,20.0,null,2500.0,null,2500.0,0.0,0.0,null,{"$f":"E7","v":""},2500,"",0.0,0.0]
[279.0,"Assistant Editor",null,20.0,null,425.0,null,425.0,0.0,0.0,null,{"$f":"E8","v":""},425,"",0.0,0.0]
[280.0,"Avid Rental",null,20.0,null,1500.0,null,1500.0,0.0,0.0,null,{"$f":"E9","v":""},1500,"",0.0,0.0]
[281.0,"Miscellaneous",null,20.0,null,0.0,null,0.0,0.0,0.0,null,{"$f":"E10","v":""},0,"",0.0,0.0]
[null,null,null,null,null,null,"Sub-total O",null,{"$f":"SUM(I6:I10)","v":0},0,null,null,null,"Sub-total Ow",{"$f":"SUM(O6:O10)","v":0},0]
[null,null,null,null,null,"P&W",null,null,{"$f":"PT_O","v":0},null,null,null,"PT/P&W",null,{"$f":"I12","v":0},0.0]
[null,null,null,null,null,"TOTAL O",null,null,{"$f":"SUM(I11:I12)","v":0},null,null,null,"TOTAL Ow",null,{"$f":"SUM(O11:O12)","v":0},0]
[null,"                                                                                                                                                    "]
["P","TRAVEL",null,null,"Amount","Rate","x","R/C","ESTIMATED",null,null,"Amount","Rate","x","WORKING","ACTUAL"]
[282.0,"Airport Transfers","per person",null,null,120.0,4.0,{"$f":"F16:F63*X_RATE","v":120},{"$f":"ROUND(E16:E63*F16:F63*IF(G16:G63=0,1,G16:G63),0)","v":"#REF!"},null,null,{"$f":"E16","v":""},120,4,{"$f":"ROUND(L16:L63*M16:M63*IF(N16:N63=0,1,N16:N63),2)","v":0},0.0]
[283.0,"Local Production Office & Conference Room",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E17","v":""},0,"",0.0,0.0]
[284.0,null,null,null,null,0.0,null,0.0,null,null,null,{"$f":"E18","v":""},0,"",0.0,0.0]
[285.0,"Director",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E19","v":""},0,"",0.0,0.0]
[286.0,"Airfare",null,null,null,null,null,0.0,null,null,null,{"$f":"E20","v":""},"","",0.0,0.0]
[287.0,"Hotel/Per Diem",null,null,null,null,null,0.0,null,null,null,{"$f":"E21","v":""},"","",0.0,0.0]
[288.0,"Producer",null,null,null,null,null,0.0,null,null,null,{"$f":"E22","v":""},"","",0.0,0.0]
[289.0,"Airfare",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E23","v":""},0,"",0.0,0.0]
[290.0,"Hotel/Per Diem",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E24","v":""},0,"",0.0,0.0]
[291.0,"Director of Photography",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E25","v":""},0,"",0.0,0.0]
[292.0,"Airfare",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E26","v":""},0,"",0.0,0.0]
[293.0,"Hotel/Per Diem",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E27","v":""},0,"",0.0,0.0]
[294.0,"Production Designer",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E28","v":""},0,"",0.0,0.0]
[295.0,"Airfare",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E29","v":""},0,"",0.0,0.0]
[296.0,"Hotel/Per Diem",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E30","v":""},0,"",0.0,0.0]
[297.0,"1AD",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E31","v":""},0,"",0.0,0.0]
[298.0,"Airfare",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E32","v":""},0,"",0.0,0.0]
[299.0,"Hotel/Per Diem",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E33","v":""},0,"",0.0,0.0]
[300.0,"Stylist",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E34","v":""},0,"",0.0,0.0]
[301.0,"Airfare",null,null,null,0.0,null,0.0,null,null,null,{"$f":"C35","v":""},{"$f":"F35","v":0},"",0.0,0.0]
[302.0,"Hotel/Per Diem",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E36","v":""},0,"",0.0,0.0]
[303.0,"PM",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E37","v":""},0,"",0.0,0.0]
[304.0,"Airfare",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E38","v":""},0,"",0.0,0.0]
[305.0,"Hotel/Per Diem",null,null,null,null,null,0.0,null,null,null,{"$f":"E39","v":""},"","",0.0,0.0]
[306.0,"AC/Gaffer/Grip",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E40","v":""},0,"",0.0,0.0]
[307.0,"Airfare",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E41","v":""},0,"",0.0,0.0]
[308.0,"Hotel/Per Diem",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E42","v":""},0,"",0.0,0.0]
[309.0,"SFX Supervisor",null,null,null,null,null,0.0,null,null,null,{"$f":"E43","v":""},"","",0.0,0.0]
[310.0,"Airfare",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E44","v":""},0,"",0.0,0.0]
[311.0,"Hotel/Per Diem",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E45","v":""},0,"",0.0,0.0]
[312.0,"Postproduction Supervisor",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E46","v":""},0,"",0.0,0.0]
[313.0,"Airfare",null,null,null,null,null,0.0,null,null,null,{"$f":"E47","v":""},"","",0.0,0.0]
[314.0,"Hotel/Per Diem",null,null,null,0.0,null,0.0,null,null,null,{"$f":"E48","v":""},0,"",0.0,0.0]
[315.0,null,null,null,null,null,null,0.0,null,null,null,{"$f":"E49","v":""},"","",0.0,0.0]
[316.0,null,null,null,null,null,null,0.0,null,null,null,{"$f":"E50","v":""},"","",0.0,0.0]
[317.0,null,null,null,null,null,null,0.0,null,null,null,{"$f":"E51","v":""},"","",0.0,0.0]
[318.0,null,null,null,null,null,null,0.0,null,null,null,{"$f":"E52","v":""},"","",0.0,0.0]
[319.0,null,null,null,null,null,null,0.0,null,null,null,{"$f":"E53","v":""},"","",0.0,0.0]
[320.0,null,null,null,null,null,null,0.0,null,null,null,{"$f":"E54","v":""},"","",0.0,0.0]
[321.0,null,null,null,null,null,null,0.0,null,null,null,{"$f":"E55","v":""},"","",0.0,0.0]
[322.0,null,null,null,null,null,null,0.0,null,null,null,{"$f":"E56","v":""},"","",0.0,0.0]
[323.0,null,null,null,null,null,null,0.0,null,null,null,{"$f":"E57","v":""},"","",0.0,0.0]
[324.0,null,null,null,null,null,null,0.0,null,null,null,{"$f":"E58","v":""},"","",0.0,0.0]
[325.0,null,null,null,null,null,null,0.0,null,null,null,{"$f":"E59","v":""},"","",0.0,0.0]
[326.0,null,null,null,null,null,null,0.0,null,null,null,{"$f":"E60","v":""},"","",0.0,0.0]
[327.0,null,null,null,null,null,null,0.0,null,null,null,{"$f":"E61","v":""},"","",0.0,0.0]
[328.0,null,null,null,null,null,null,0.0,null,null,null,{"$f":"E62","v":""},"","",0.0,0.0]
[329.0,"Travel  Handling Fee (P)",null,null,0.15,{"$f":"SUM(I16:I62)","v":"#REF!"},null,{"$error":"#REF!"},null,null,null,{"$f":"E63","v":0.15},"#REF!","",{"$error":"#REF!"},0.0]
[null,null,null,null,null,"TOTAL P",null,null,{"$f":"SUM(I16:I63)","v":"#REF!"},null,null,null,"TOTAL Pw",null,{"$f":"SUM(O16:O63)","v":"#REF!"},0]

{"sheet":"Sales Log","index":15,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
[]
["SALES LOG"]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$15=\"\",\"\",'Top Sheet'!$L$15),IF('Top Sheet'!$L$12=\"\",\"\",'Top Sheet'!$L$12))","v":""}]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$16=\"\",\"\",'Top Sheet'!$L$16),IF('Top Sheet'!$L$13=\"\",\"\",'Top Sheet'!$L$13))","v":""}]
[{"$f":"IF('Top Sheet'!$C$10=\"\",\"\",\"Job #: \"&'Top Sheet'!$C$10)","v":""}]
[]
["Line","Payer","Notes","Receive ID","ACTUAL","Description","Row"]
[null,null,null,null,null,{"$f":"IF(A8=\"\",\"\",IF(AND(A8>0,A8<330),VLOOKUP(A8,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},1.0]
[null,null,null,null,null,{"$f":"IF(A9=\"\",\"\",IF(AND(A9>0,A9<330),VLOOKUP(A9,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},2.0]
[null,null,null,null,null,{"$f":"IF(A10=\"\",\"\",IF(AND(A10>0,A10<330),VLOOKUP(A10,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},3.0]
[null,null,null,null,null,{"$f":"IF(A11=\"\",\"\",IF(AND(A11>0,A11<330),VLOOKUP(A11,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},4.0]
[null,null,null,null,null,{"$f":"IF(A12=\"\",\"\",IF(AND(A12>0,A12<330),VLOOKUP(A12,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},5.0]
[null,null,null,null,null,{"$f":"IF(A13=\"\",\"\",IF(AND(A13>0,A13<330),VLOOKUP(A13,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},6.0]
[null,null,null,null,null,{"$f":"IF(A14=\"\",\"\",IF(AND(A14>0,A14<330),VLOOKUP(A14,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},7.0]
[null,null,null,null,null,{"$f":"IF(A15=\"\",\"\",IF(AND(A15>0,A15<330),VLOOKUP(A15,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},8.0]
[null,null,null,null,null,{"$f":"IF(A16=\"\",\"\",IF(AND(A16>0,A16<330),VLOOKUP(A16,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},9.0]
[null,null,null,null,null,{"$f":"IF(A17=\"\",\"\",IF(AND(A17>0,A17<330),VLOOKUP(A17,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},10.0]
[]
[null,null,null,"TOTAL SALES",{"$f":"SUM(E8:E17)","v":0}]

{"sheet":"Purchase Order Log","index":16,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,0,1,6]]}
[]
["PURCHASE ORDER LOG"]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$15=\"\",\"\",'Top Sheet'!$L$15),IF('Top Sheet'!$L$12=\"\",\"\",'Top Sheet'!$L$12))","v":""}]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$16=\"\",\"\",'Top Sheet'!$L$16),IF('Top Sheet'!$L$13=\"\",\"\",'Top Sheet'!$L$13))","v":""},null,"              ","           "]
[{"$f":"IF('Top Sheet'!$C$10=\"\",\"\",\"Job #: \"&'Top Sheet'!$C$10)","v":""},null,null,null,null,null," "]
[]
["Line","Payee","PO","Date","Pay ID","ACTUAL","Description","Row"]
[null,null,null,null,null,null,{"$f":"IF(A8=\"PC\",\"PETTY CASH LOG\",IF(A8=\"PR\",\"PAYROLL LOG\",IF(A8=\"\",\"\",IF(AND(A8>0,A8<330),VLOOKUP(A8,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},1.0]
[null,null,null,null,null,null,{"$f":"IF(A9=\"PC\",\"PETTY CASH LOG\",IF(A9=\"PR\",\"PAYROLL LOG\",IF(A9=\"\",\"\",IF(AND(A9>0,A9<330),VLOOKUP(A9,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},2.0]
[null,null,null,null,null,null,{"$f":"IF(A10=\"PC\",\"PETTY CASH LOG\",IF(A10=\"PR\",\"PAYROLL LOG\",IF(A10=\"\",\"\",IF(AND(A10>0,A10<330),VLOOKUP(A10,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},3.0]
[null,null,null,null,null,null,{"$f":"IF(A11=\"PC\",\"PETTY CASH LOG\",IF(A11=\"PR\",\"PAYROLL LOG\",IF(A11=\"\",\"\",IF(AND(A11>0,A11<330),VLOOKUP(A11,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},4.0]
[null,null,null,null,null,null,{"$f":"IF(A12=\"PC\",\"PETTY CASH LOG\",IF(A12=\"PR\",\"PAYROLL LOG\",IF(A12=\"\",\"\",IF(AND(A12>0,A12<330),VLOOKUP(A12,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},5.0]
[null,null,null,null,null,null,{"$f":"IF(A13=\"PC\",\"PETTY CASH LOG\",IF(A13=\"PR\",\"PAYROLL LOG\",IF(A13=\"\",\"\",IF(AND(A13>0,A13<330),VLOOKUP(A13,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},6.0]
[null,null,null,null,null,null,{"$f":"IF(A14=\"PC\",\"PETTY CASH LOG\",IF(A14=\"PR\",\"PAYROLL LOG\",IF(A14=\"\",\"\",IF(AND(A14>0,A14<330),VLOOKUP(A14,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},7.0]
[null,null,null,null,null,null,{"$f":"IF(A15=\"PC\",\"PETTY CASH LOG\",IF(A15=\"PR\",\"PAYROLL LOG\",IF(A15=\"\",\"\",IF(AND(A15>0,A15<330),VLOOKUP(A15,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},8.0]
[null,null,null,null,null,null,{"$f":"IF(A16=\"PC\",\"PETTY CASH LOG\",IF(A16=\"PR\",\"PAYROLL LOG\",IF(A16=\"\",\"\",IF(AND(A16>0,A16<330),VLOOKUP(A16,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},9.0]
[null,null,null,null,null,null,{"$f":"IF(A17=\"PC\",\"PETTY CASH LOG\",IF(A17=\"PR\",\"PAYROLL LOG\",IF(A17=\"\",\"\",IF(AND(A17>0,A17<330),VLOOKUP(A17,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},10.0]
[null,null,null,null,null,null,{"$f":"IF(A18=\"PC\",\"PETTY CASH LOG\",IF(A18=\"PR\",\"PAYROLL LOG\",IF(A18=\"\",\"\",IF(AND(A18>0,A18<330),VLOOKUP(A18,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},11.0]
[null,null,null,null,null,null,{"$f":"IF(A19=\"PC\",\"PETTY CASH LOG\",IF(A19=\"PR\",\"PAYROLL LOG\",IF(A19=\"\",\"\",IF(AND(A19>0,A19<330),VLOOKUP(A19,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},12.0]
[null,null,null,null,null,null,{"$f":"IF(A20=\"PC\",\"PETTY CASH LOG\",IF(A20=\"PR\",\"PAYROLL LOG\",IF(A20=\"\",\"\",IF(AND(A20>0,A20<330),VLOOKUP(A20,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},13.0]
[null,null,null,null,null,null,{"$f":"IF(A21=\"PC\",\"PETTY CASH LOG\",IF(A21=\"PR\",\"PAYROLL LOG\",IF(A21=\"\",\"\",IF(AND(A21>0,A21<330),VLOOKUP(A21,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},14.0]
[null,null,null,null,null,null,{"$f":"IF(A22=\"PC\",\"PETTY CASH LOG\",IF(A22=\"PR\",\"PAYROLL LOG\",IF(A22=\"\",\"\",IF(AND(A22>0,A22<330),VLOOKUP(A22,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},15.0]
[null,null,null,null,null,null,{"$f":"IF(A23=\"PC\",\"PETTY CASH LOG\",IF(A23=\"PR\",\"PAYROLL LOG\",IF(A23=\"\",\"\",IF(AND(A23>0,A23<330),VLOOKUP(A23,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},16.0]
[null,null,null,null,null,null,{"$f":"IF(A24=\"PC\",\"PETTY CASH LOG\",IF(A24=\"PR\",\"PAYROLL LOG\",IF(A24=\"\",\"\",IF(AND(A24>0,A24<330),VLOOKUP(A24,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},17.0]
[null,null,null,null,null,null,{"$f":"IF(A25=\"PC\",\"PETTY CASH LOG\",IF(A25=\"PR\",\"PAYROLL LOG\",IF(A25=\"\",\"\",IF(AND(A25>0,A25<330),VLOOKUP(A25,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},18.0]
[null,null,null,null,null,null,{"$f":"IF(A26=\"PC\",\"PETTY CASH LOG\",IF(A26=\"PR\",\"PAYROLL LOG\",IF(A26=\"\",\"\",IF(AND(A26>0,A26<330),VLOOKUP(A26,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},19.0]
[null,null,null,null,null,null,{"$f":"IF(A27=\"PC\",\"PETTY CASH LOG\",IF(A27=\"PR\",\"PAYROLL LOG\",IF(A27=\"\",\"\",IF(AND(A27>0,A27<330),VLOOKUP(A27,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},20.0]
[null,null,null,null,null,null,{"$f":"IF(A28=\"PC\",\"PETTY CASH LOG\",IF(A28=\"PR\",\"PAYROLL LOG\",IF(A28=\"\",\"\",IF(AND(A28>0,A28<330),VLOOKUP(A28,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))))","v":""},21.0]
[]
[null,null,null,null,"TOTAL PURCHASE ORDERS",{"$f":"SUM(F8:F28)","v":0}]

{"sheet":"Petty Cash Log","index":17,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,0,1,8],[5,1,5,6]]}
[]
["PETTY CASH LOG"]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$15=\"\",\"\",'Top Sheet'!$L$15),IF('Top Sheet'!$L$12=\"\",\"\",'Top Sheet'!$L$12))","v":""}]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$16=\"\",\"\",'Top Sheet'!$L$16),IF('Top Sheet'!$L$13=\"\",\"\",'Top Sheet'!$L$13))","v":""}]
[{"$f":"IF('Top Sheet'!$C$10=\"\",\"\",\"Job #: \"&'Top Sheet'!$C$10)","v":""}]
[null,"PC Envelopes"]
["Line","name?","name?","name?","name?","name?","name?","ACTUAL","Description","Row"]
[null,null,null,null,null,null,null,{"$f":"SUM(B8:G8)","v":0},{"$f":"IF(A8=0,\"\",IF(AND(A8>0,A8<330),VLOOKUP(A8,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},1.0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A9=0,\"\",IF(AND(A9>0,A9<330),VLOOKUP(A9,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},2.0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A10=0,\"\",IF(AND(A10>0,A10<330),VLOOKUP(A10,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},3.0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A11=0,\"\",IF(AND(A11>0,A11<330),VLOOKUP(A11,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},4.0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A12=0,\"\",IF(AND(A12>0,A12<330),VLOOKUP(A12,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},5.0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A13=0,\"\",IF(AND(A13>0,A13<330),VLOOKUP(A13,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},6.0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A14=0,\"\",IF(AND(A14>0,A14<330),VLOOKUP(A14,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},7.0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A15=0,\"\",IF(AND(A15>0,A15<330),VLOOKUP(A15,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},8.0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A16=0,\"\",IF(AND(A16>0,A16<330),VLOOKUP(A16,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},9.0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A17=0,\"\",IF(AND(A17>0,A17<330),VLOOKUP(A17,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},10.0]
[null,1.0,2.0,3.0,4.0,5.0,6.0]
[null,{"$f":"SUM(B8:B17)","v":0},0,0,0,0,0,0,"TOTAL PC RECEIPTS"]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(B21:G21)","v":0},"Cash Received"]
[null,{"$f":"B19-B21","v":0},0,0,0,0,0,0,"Due Personnel / (Due Co)"]
[]
[null,null,null,null,null,null,null,{"$f":"Totals!K358","v":0},"Total PC from POs"]
[null,null,null,null,null,null,null,{"$f":"ROUND(H21-H24,2)","v":0},{"$f":"IF(H25=0,\"PC Reconciled\",\"PC Not Reconciled\")","v":"PC Reconciled"}]

{"sheet":"Payroll Log","index":18,"n_rows":33,"n_cols":19,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,0,1,17],[5,7,5,9]]}
[]
["PAYROLL LOG"]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$15=\"\",\"\",'Top Sheet'!$L$15),IF('Top Sheet'!$L$12=\"\",\"\",'Top Sheet'!$L$12))","v":""}]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$16=\"\",\"\",'Top Sheet'!$L$16),IF('Top Sheet'!$L$13=\"\",\"\",'Top Sheet'!$L$13))","v":""}]
[{"$f":"IF('Top Sheet'!$C$10=\"\",\"\",\"Job #: \"&'Top Sheet'!$C$10)","v":""}]
[null,null,null,"%","OT",null,null,"OT  Hours",null,null,"Misc","Misc"]
["Line","Payee","PO"," PT/P&W ","Based","Days","Rate",1.5,2.0,3.0,"Taxable","Non-taxable","Total ST","OT hrs","Total OT","ACTUAL","Description","PT/P&W","Row"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F8*G8","v":0},{"$f":"H8+I8+J8","v":0},{"$f":"ROUND(IF(E8>0,(G8/E8*$H$7*H8)+(G8/E8*$I$7*I8)+(G8/E8*$J$7*J8),0),2)","v":0},{"$f":"K8+L8+M8+O8","v":0},{"$f":"IF(A8=\"\",\"\",IF(AND(A8>0,A8<330),VLOOKUP(A8,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},{"$f":"ROUND((K8+M8+O8)*D8/100,2)","v":0},1.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A9=\"\",\"\",IF(AND(A9>0,A9<330),VLOOKUP(A9,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,2.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A10=\"\",\"\",IF(AND(A10>0,A10<330),VLOOKUP(A10,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,3.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A11=\"\",\"\",IF(AND(A11>0,A11<330),VLOOKUP(A11,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,4.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A12=\"\",\"\",IF(AND(A12>0,A12<330),VLOOKUP(A12,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,5.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A13=\"\",\"\",IF(AND(A13>0,A13<330),VLOOKUP(A13,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,6.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A14=\"\",\"\",IF(AND(A14>0,A14<330),VLOOKUP(A14,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,7.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A15=\"\",\"\",IF(AND(A15>0,A15<330),VLOOKUP(A15,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,8.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A16=\"\",\"\",IF(AND(A16>0,A16<330),VLOOKUP(A16,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,9.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A17=\"\",\"\",IF(AND(A17>0,A17<330),VLOOKUP(A17,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,10.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A18=\"\",\"\",IF(AND(A18>0,A18<330),VLOOKUP(A18,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,11.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A19=\"\",\"\",IF(AND(A19>0,A19<330),VLOOKUP(A19,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,12.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A20=\"\",\"\",IF(AND(A20>0,A20<330),VLOOKUP(A20,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,13.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A21=\"\",\"\",IF(AND(A21>0,A21<330),VLOOKUP(A21,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,14.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A22=\"\",\"\",IF(AND(A22>0,A22<330),VLOOKUP(A22,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,15.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A23=\"\",\"\",IF(AND(A23>0,A23<330),VLOOKUP(A23,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,16.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A24=\"\",\"\",IF(AND(A24>0,A24<330),VLOOKUP(A24,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,17.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A25=\"\",\"\",IF(AND(A25>0,A25<330),VLOOKUP(A25,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,18.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A26=\"\",\"\",IF(AND(A26>0,A26<330),VLOOKUP(A26,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,19.0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(A27=\"\",\"\",IF(AND(A27>0,A27<330),VLOOKUP(A27,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},0,20.0]
[]
[null,null,null,null,null,null,null,null,null,"TOTAL PAYROLL",{"$f":"SUM(K8:K27)","v":0},0,0,null,{"$f":"SUM(O8:O27)","v":0},0,"TOTAL PT/P&W",{"$f":"SUM(R8:R27)","v":0}]
[]
[null,null,"PO",null,null,null,"Total for PO",null,null,null,null,null,null,null,"Total Payroll",{"$f":"P29+R29","v":0}]
[null,null,null,null,null,null,{"$f":"DSUM(PAYROLLLOG2,\"ACTUAL\",C31:C32)+DSUM(PAYROLLLOG2,\"PT/P&W\",C31:C32)","v":0},null,null,null,null,null,null,null,"Total Payroll from POs",{"$f":"Totals!K359","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P33=0,\"Payroll Reconciled\",\"Payroll not Reconciled\")","v":"Payroll Reconciled"},{"$f":"ROUND(P31-P32,2)","v":0}]

{"sheet":"Check Log","index":19,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,1,6]]}
[]
["CHECK LOG"]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$15=\"\",\"\",'Top Sheet'!$L$15),IF('Top Sheet'!$L$12=\"\",\"\",'Top Sheet'!$L$12))","v":""}]
[{"$f":"IF('Top Sheet'!$G$5=\"Agency:\",IF('Top Sheet'!$L$16=\"\",\"\",'Top Sheet'!$L$16),IF('Top Sheet'!$L$13=\"\",\"\",'Top Sheet'!$L$13))","v":""},null,"              ","           "]
[{"$f":"IF('Top Sheet'!$C$10=\"\",\"\",\"Job #: \"&'Top Sheet'!$C$10)","v":""},null,null,null,null,null," "]
[]
["Line","Payee","Check ID","Date","PO","ACTUAL","Description","Row"]
[null,null,null,null,null,null,{"$f":"IF(A8=\"\",\"\",IF(AND(A8>0,A8<330),VLOOKUP(A8,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},1.0]
[null,null,null,null,null,null,{"$f":"IF(A9=\"\",\"\",IF(AND(A9>0,A9<330),VLOOKUP(A9,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},2.0]
[null,null,null,null,null,null,{"$f":"IF(A10=\"\",\"\",IF(AND(A10>0,A10<330),VLOOKUP(A10,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},3.0]
[null,null,null,null,null,null,{"$f":"IF(A11=\"\",\"\",IF(AND(A11>0,A11<330),VLOOKUP(A11,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},4.0]
[null,null,null,null,null,null,{"$f":"IF(A12=\"\",\"\",IF(AND(A12>0,A12<330),VLOOKUP(A12,Totals!$B$1:$C$359,2),\"LINE NUMBER?\"))","v":""},5.0]
["NOTE: ","The figures in this Check Log are"]
[null,"not linked to the Actual Budget.",null,null,"TOTAL CHECKS",{"$f":"SUM(F8:F12)","v":0}]