{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Employees","Terrain","Master","10-27-2011","10-24-2011"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Employees","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Name","Wage"]
["No employee",0]
["Celestino Benavides",{"$f":"RANDBETWEEN(8,20)","v":17},null,null,null,11]
["Benjimin Galaniz",{"$f":"RANDBETWEEN(8,20)","v":16},null,null,null,9]
["Ryan Eastburn",17,null,null,null,9]
["Danny Rodriguez",19,null,null,null,11]
["George Corriz",17,null,null,null,9.5]
["Leon Ibarra",17,null,null,null,10]
["Pablo Parra",20,null,null,null,11]
["Antonio Anchondo",12,null,null,null,9]
["Salvador Chavez",8,null,null,null,9.5]
["Marcelino Carlos",16,null,null,null,17]
["Edgar Mojica",18,null,null,null,14]
["Jorge Nunez",11,null,null,null,10]

{"sheet":"Terrain","index":1,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Terrain Type","Rate"]
["None",0,null,null,null,0]
["Basic",6.54,null,null,null,5.64]
["Rocky",7.98,null,null,null,8.0399999999999991]
["Severely Rocky",10.11,null,null,null,10.44]
["Drill Team",41.2,null,null,null,41.2]

{"sheet":"Master","index":2,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[29,0,30,0],[39,0,40,0],[0,0,0,8],[1,0,1,8],[9,0,10,0],[19,0,20,0]]}
["Weekly Production Totals"]
["Week of 10/17/2011"]
[]
["Members of Crew 1","Information","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Totals"]
["No employee","Job Number"]
["No employee","Hours Worked",null,null,null,null,null,null,{"$f":"SUM(C6:H6)","v":0}]
["No employee","Total Feet Installed",null,null,null,null,null,null,0]
["No employee","Revenue Rate","Rocky","Rocky","Basic","Basic","None","None"]
["No employee","Labor",0,0,0,0,0,0,{"$f":"SUM(C9:H9)","v":0}]
[null,"Revenue",0,0,0,0,0,0,{"$f":"SUM(C10:H10)","v":0}]
[null,"Other Revenue",null,null,null,null,null,null,{"$f":"SUM(C11:H11)","v":0}]
[null,"Cost of Labor %",{"$f":"C9/(C10+C11)","v":{"$error":"#DIV/0!"}},{"$f":"D9/(D10+D11)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Members of Crew 2","Information","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Totals"]
["No employee","Job Number"]
["No employee","Hours Worked",null,null,null,null,null,null,{"$f":"SUM(C16:H16)","v":0}]
["No employee","Total Feet Installed",null,null,null,null,null,null,0]
["No employee","Revenue Rate","Rocky","Rocky","Basic","Basic","None","None"]
["No employee","Labor",0,0,0,0,0,0,{"$f":"SUM(C19:H19)","v":0}]
[null,"Revenue",0,0,0,0,0,0,{"$f":"SUM(C20:H20)","v":0}]
[null,"Other Revenue",null,null,null,null,null,null,{"$f":"SUM(C21:H21)","v":0}]
[null,"Cost of Labor %",{"$f":"C19/(C20+C21)","v":{"$error":"#DIV/0!"}},{"$f":"D19/(D20+D21)","v":{"$error":"#DIV/0!"}},{"$f":"E19/(E20+E21)","v":{"$error":"#DIV/0!"}},{"$f":"F19/(F20+F21)","v":{"$error":"#DIV/0!"}},{"$f":"G19/(G20+G21)","v":{"$error":"#DIV/0!"}},{"$f":"H19/(H20+H21)","v":{"$error":"#DIV/0!"}},{"$f":"I19/(I20+I21)","v":{"$error":"#DIV/0!"}}]
[]
["Members of Crew 3","Information","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Totals"]
["No employee","Job Number"]
["No employee","Hours Worked",null,null,null,null,null,null,{"$f":"SUM(C26:H26)","v":0}]
["No employee","Total Feet Installed",null,null,null,null,null,null,0]
["No employee","Revenue Rate","Rocky","Rocky","Basic","Basic","None","None"]
["No employee","Labor",0,0,0,0,0,0,{"$f":"SUM(C29:H29)","v":0}]
[null,"Revenue",0,0,0,0,0,0,{"$f":"SUM(C30:H30)","v":0}]
[null,"Other Revenue",null,null,null,null,null,null,{"$f":"SUM(C31:H31)","v":0}]
[null,"Cost of Labor %",{"$f":"C29/(C30+C31)","v":{"$error":"#DIV/0!"}},{"$f":"D29/(D30+D31)","v":{"$error":"#DIV/0!"}},{"$f":"E29/(E30+E31)","v":{"$error":"#DIV/0!"}},{"$f":"F29/(F30+F31)","v":{"$error":"#DIV/0!"}},{"$f":"G29/(G30+G31)","v":{"$error":"#DIV/0!"}},{"$f":"H29/(H30+H31)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
["Members of Crew 4","Information","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Totals"]
["No employee","Job Number"]
["No employee","Hours Worked",null,null,null,null,null,null,{"$f":"SUM(C36:H36)","v":0}]
["No employee","Total Feet Installed",null,null,null,null,null,null,0]
["No employee","Revenue Rate","Rocky","Rocky","Basic","Basic","None","None"]
["No employee","Labor",0,0,0,0,0,0,{"$f":"SUM(C39:H39)","v":0}]
[null,"Revenue",0,0,0,0,0,0,{"$f":"SUM(C40:H40)","v":0}]
[null,"Other Revenue",null,null,null,null,null,null,{"$f":"SUM(C41:H41)","v":0}]
[null,"Cost of Labor %",{"$f":"C39/(C40+C41)","v":{"$error":"#DIV/0!"}},{"$f":"D39/(D40+D41)","v":{"$error":"#DIV/0!"}},{"$f":"E39/(E40+E41)","v":{"$error":"#DIV/0!"}},{"$f":"F39/(F40+F41)","v":{"$error":"#DIV/0!"}},{"$f":"G39/(G40+G41)","v":{"$error":"#DIV/0!"}},{"$f":"H39/(H40+H41)","v":{"$error":"#DIV/0!"}},{"$f":"I39/(I40+I41)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Crew Totals","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Totals"]
[null,"Footage by Day",{"$f":"SUMIF($B$4:$B$43,\"Total Feet Installed\",C4:C43)","v":0},0,0,0,0,0,{"$f":"SUM(C46:H46)","v":0}]
[null,"Labor by Day",{"$f":"SUMIF($B$4:$B$43,\"Labor\",C4:C43)","v":0},0,0,0,0,0,{"$f":"SUM(C47:H47)","v":0}]
[null,"Revenue by Day",{"$f":"C10+C11+C20+C21+C30+C31+C40+C41","v":0},0,0,0,0,0,{"$f":"SUM(C48:H48)","v":0}]

{"sheet":"10-27-2011","index":3,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[9,0,10,0],[19,0,20,0],[29,0,30,0],[39,0,40,0]]}
["Weekly Production Totals"]
["Week of 10/27/2011"]
[]
["Members of Crew 1","Information","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Totals"]
["Celestino Benavides","Job Number"]
["Benjimin Galaniz","Hours Worked",10,10,10,10,10,null,{"$f":"SUM(C6:H6)","v":50}]
["Ryan Eastburn","Total Feet Installed",null,null,null,null,null,null,0]
["No employee","Revenue Rate","Rocky","Rocky","Basic","Basic","None","None"]
["No employee","Labor",380,380,380,380,570,0,{"$f":"SUM(C9:H9)","v":2090}]
[null,"Revenue",0,0,0,0,0,0,{"$f":"SUM(C10:H10)","v":0}]
[null,"Other Revenue",null,null,null,null,null,null,{"$f":"SUM(C11:H11)","v":0}]
[null,"Cost of Labor %",{"$f":"C9/(C10+C11)","v":{"$error":"#DIV/0!"}},{"$f":"D9/(D10+D11)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Members of Crew 2","Information","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Totals"]
["Ryan Eastburn","Job Number"]
["George Corriz","Hours Worked",10,10,10,10,10,null,{"$f":"SUM(C16:H16)","v":50}]
["Pablo Parra","Total Feet Installed",null,null,null,null,null,null,0]
["No employee","Revenue Rate","Rocky","Rocky","Basic","Basic","None","None"]
["No employee","Labor",480,480,480,480,720,0,{"$f":"SUM(C19:H19)","v":2640}]
[null,"Revenue",0,0,0,0,0,0,{"$f":"SUM(C20:H20)","v":0}]
[null,"Other Revenue",null,null,null,null,null,null,{"$f":"SUM(C21:H21)","v":0}]
[null,"Cost of Labor %",{"$f":"C19/(C20+C21)","v":{"$error":"#DIV/0!"}},{"$f":"D19/(D20+D21)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Members of Crew 3","Information","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Totals"]
["No employee","Job Number"]
["No employee","Hours Worked",null,null,null,null,null,null,{"$f":"SUM(C26:H26)","v":0}]
["No employee","Total Feet Installed",null,null,null,null,null,null,0]
["No employee","Revenue Rate","Rocky","Rocky","Basic","Basic","None","None"]
["No employee","Labor",0,0,0,0,0,0,{"$f":"SUM(C29:H29)","v":0}]
[null,"Revenue",0,0,0,0,0,0,{"$f":"SUM(C30:H30)","v":0}]
[null,"Other Revenue",null,null,null,null,null,null,{"$f":"SUM(C31:H31)","v":0}]
[null,"Cost of Labor %",{"$f":"C29/(C30+C31)","v":{"$error":"#DIV/0!"}},{"$f":"D29/(D30+D31)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Members of Crew 4","Information","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Totals"]
["No employee","Job Number"]
["No employee","Hours Worked",null,null,null,null,null,null,{"$f":"SUM(C36:H36)","v":0}]
["No employee","Total Feet Installed",null,null,null,null,null,null,0]
["No employee","Revenue Rate","Rocky","Rocky","Basic","Basic","None","None"]
["No employee","Labor",0,0,0,0,0,0,{"$f":"SUM(C39:H39)","v":0}]
[null,"Revenue",0,0,0,0,0,0,{"$f":"SUM(C40:H40)","v":0}]
[null,"Other Revenue",null,null,null,null,null,null,{"$f":"SUM(C41:H41)","v":0}]
[null,"Cost of Labor %",{"$f":"C39/(C40+C41)","v":{"$error":"#DIV/0!"}},{"$f":"D39/(D40+D41)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[null,"Crew Totals","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Totals"]
[null,"Footage by Day",{"$f":"SUMIF($B$4:$B$43,\"Total Feet Installed\",C4:C43)","v":0},0,0,0,0,0,{"$f":"SUM(C46:H46)","v":0}]
[null,"Labor by Day",{"$f":"SUMIF($B$4:$B$43,\"Labor\",C4:C43)","v":860},860,860,860,1290,0,{"$f":"SUM(C47:H47)","v":4730}]
[null,"Revenue by Day",{"$f":"C10+C11+C20+C21+C30+C31+C40+C41","v":0},0,0,0,0,0,{"$f":"SUM(C48:H48)","v":0}]

{"sheet":"10-24-2011","index":4,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[9,0,10,0],[19,0,20,0],[29,0,30,0],[39,0,40,0]]}
["Weekly Production Totals"]
["Week of 10/24/2011"]
[]
["Members of Crew 1","Information","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Totals"]
["No employee","Job Number"]
["No employee","Hours Worked",null,null,null,null,null,null,{"$f":"SUM(C6:H6)","v":0}]
["No employee","Total Feet Installed",null,null,null,null,null,null,0]
["No employee","Revenue Rate","Rocky","Rocky","Basic","Basic","None","None"]
["No employee","Labor",0,0,0,0,0,0,{"$f":"SUM(C9:H9)","v":0}]
[null,"Revenue",0,0,0,0,0,0,{"$f":"SUM(C10:H10)","v":0}]
[null,"Other Revenue",null,null,null,null,null,null,{"$f":"SUM(C11:H11)","v":0}]
[null,"Cost of Labor %",{"$f":"C9/(C10+C11)","v":{"$error":"#DIV/0!"}},{"$f":"D9/(D10+D11)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Members of Crew 2","Information","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Totals"]
["No employee","Job Number"]
["No employee","Hours Worked",null,null,null,null,null,null,{"$f":"SUM(C16:H16)","v":0}]
["No employee","Total Feet Installed",null,null,null,null,null,null,0]
["No employee","Revenue Rate","Rocky","Rocky","Basic","Basic","None","None"]
["No employee","Labor",0,0,0,0,0,0,{"$f":"SUM(C19:H19)","v":0}]
[null,"Revenue",0,0,0,0,0,0,{"$f":"SUM(C20:H20)","v":0}]
[null,"Other Revenue",null,null,null,null,null,null,{"$f":"SUM(C21:H21)","v":0}]
[null,"Cost of Labor %",{"$f":"C19/(C20+C21)","v":{"$error":"#DIV/0!"}},{"$f":"D19/(D20+D21)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Members of Crew 3","Information","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Totals"]
["No employee","Job Number"]
["No employee","Hours Worked",null,null,null,null,null,null,{"$f":"SUM(C26:H26)","v":0}]
["No employee","Total Feet Installed",null,null,null,null,null,null,0]
["No employee","Revenue Rate","Rocky","Rocky","Basic","Basic","None","None"]
["No employee","Labor",0,0,0,0,0,0,{"$f":"SUM(C29:H29)","v":0}]
[null,"Revenue",0,0,0,0,0,0,{"$f":"SUM(C30:H30)","v":0}]
[null,"Other Revenue",null,null,null,null,null,null,{"$f":"SUM(C31:H31)","v":0}]
[null,"Cost of Labor %",{"$f":"C29/(C30+C31)","v":{"$error":"#DIV/0!"}},{"$f":"D29/(D30+D31)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Members of Crew 4","Information","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Totals"]
["No employee","Job Number"]
["No employee","Hours Worked",null,null,null,null,null,null,{"$f":"SUM(C36:H36)","v":0}]
["No employee","Total Feet Installed",null,null,null,null,null,null,0]
["No employee","Revenue Rate","Rocky","Rocky","Basic","Basic","None","None"]
["No employee","Labor",0,0,0,0,0,0,{"$f":"SUM(C39:H39)","v":0}]
[null,"Revenue",0,0,0,0,0,0,{"$f":"SUM(C40:H40)","v":0}]
[null,"Other Revenue",null,null,null,null,null,null,{"$f":"SUM(C41:H41)","v":0}]
[null,"Cost of Labor %",{"$f":"C39/(C40+C41)","v":{"$error":"#DIV/0!"}},{"$f":"D39/(D40+D41)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[null,"Crew Totals","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Totals"]
[null,"Footage by Day",{"$f":"SUMIF($B$4:$B$43,\"Total Feet Installed\",C4:C43)","v":0},0,0,0,0,0,{"$f":"SUM(C46:H46)","v":0}]
[null,"Labor by Day",{"$f":"SUMIF($B$4:$B$43,\"Labor\",C4:C43)","v":0},0,0,0,0,0,{"$f":"SUM(C47:H47)","v":0}]
[null,"Revenue by Day",{"$f":"C10+C11+C20+C21+C30+C31+C40+C41","v":0},0,0,0,0,0,{"$f":"SUM(C48:H48)","v":0}]