{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main File","Leaffilter Labor sheet","Labor sheet for Employees"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Main File","index":0,"n_rows":2,"n_cols":16,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Date","#","Customer","Customer Adress & Pfone","Leaffilter Contract price","Contract sale date","Date done","Installers","Bill","Used","L/G/S/F","Labor notes","My comments","PAID","Service","Reason for no installation"]
["04.30.20","MIL 18238","KIMBERLY SCHMIDT",null,null,null,"04.30.20","ALLEN",394.24,null,null,"RAIN,NEEDED 40 LADDER TO FINISH ,CUSTOMER NOR HOME FOR INSTALL",null,394.24,72.400000000000006]

{"sheet":"Leaffilter Labor sheet","index":1,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["Leaf Filter  Labor sheet"]
[null,null,null,"Installer:",null,"H в mainfile"]
[]
["Office Location",null,null,"Колонка D в mainfile"]
[]
["Job#",null,null,"это колонка B на первой странице"]
[]
["Job Adress"]
[]
["Date Completed",null,null,"Это ячейка G в main file"]
[]
[]
["Item","Price","Unit","Quantity"]
["5\" Leaf Filter™  1st story",1,"Ft.",null,{"$f":"B14*D14","v":0}]
["5\" Leaf Filter™  2nd story",1.5,"Ft.",null,{"$f":"B15*D15","v":0}]
["5\" Leaf Filter™  3rd story",2,"Ft.",null,{"$f":"B16*D16","v":0}]
["6\" Leaf Filter™  1st story",1,"Ft.",null,0]
["6\" Leaf Filter™  2nd story",1.5,"Ft.",null,0]
["6\" Leaf Filter™  3rd story",2,"Ft.",null,0]
["Conner Gutter Accessories",0,"Ft.",null,0]
["Valley Screen (Metal, Flat Roof)",0,"Ft.",null,0]
["Inside or Outside Miter",2,"Ea.",null,0]
["Straps",0.5,"Ft.",null,0]
["New 5\" Gutters",3.5,"Ft.",null,0]
["New 5\" (2x3) Downspouts",3,"Ft.",null,0]
["Install 5\" (2x3) Extensions",3,"Ft.",null,0]
["Alunimum \"Y\" Adaptor",0,"Ea.",null,0]
["New 6\" Gutters",4,"Ft.",null,0]
["New 6\" (3x4) Downspouts",3.5,"Ft.",null,0]
["Install 6\" (3x4) Extensions",3.5,"Ft.",null,0]
["Clean, Seal & Reinforce",0.6,"Ft.",null,0]
["Install New Drip Edge/Flashing",0.5,"Ft.",null,0]
["Install New Fascia Boards",2.5,"Ft.",null,0]
["Install New Metal fascia Only",1.5,"Ft.",null,0]
["Install New Soffit & Fascia",3.5,"Ft.",null,0]
["Install New Soffia Only-Less than 3`",2,"Ft.",null,0]
["Install Porch Ceiling -Over 3`",1.25,"Sq.Ft.",null,0]
["Extra Labor",20,"Hr.",null,0]
["R&R Existing Gutters",1,"Ft.",null,0]
["Replace Existing Gutter Miter",15,"Ea.",null,0]
["Remove Gutter Helmet ",0.35,"Ft.",null,0]
["Remove Existing Hangers (Sawzaii)",0.2,"Ft.",null,0]
["Install New AZEK Fascia Board",2.5,"Ft.",null,0]
["Cut and Remove Shingle Overhang",0.5,"Ft.",null,0]
["Gas Allowance",0.3,"ML",null,0]
[null,null,null,"Total:",{"$f":"E14+E15+E16+E17+E18+E19+E20+E21+E23+E22+E24+E25+E26+E27+E28+E29+E30+E31+E32+E33+E34+E35+E36+E37+E38+E39+E40+E41+E42+E43+E44+E45","v":0}]
[]
["Reson for no installation"]

{"sheet":"Labor sheet for Employees","index":2,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Installer: "]
[null,null,null,"H"]
[]
[]
[]
["Office Location","D"]
[]
["Job#","B"]
[]
["Job Adress"]
[]
["Date Completed","G"]
[]
[]
["Item","Price","Unit","Quantity"]
["5\" Leaf Filter™  1st story",0.8,"Ft.",null,{"$f":"B16*D16","v":0}]
["5\" Leaf Filter™  2nd story",1,"Ft.",null,{"$f":"B17*D17","v":0}]
["5\" Leaf Filter™  3rd story",1.2,"Ft.",null,0]
["6\" Leaf Filter™  1st story",0.8,"Ft.",null,0]
["6\" Leaf Filter™  2nd story",1,"Ft.",null,0]
["6\" Leaf Filter™  3rd story",1.2,"Ft.",null,0]
["Conner Gutter Accessories",0,"Ft.",null,0]
["Valley Screen (Metal, Flat Roof)",0,"Ft.",null,0]
["Inside or Outside Miter",0.8,"Ea.",null,0]
["Straps",0.2,"Ft.",null,0]
["New 5\" Gutters",3.5,"Ft.",null,0]
["New 5\" (2x3) Downspouts",3,"Ft.",null,0]
["Install 5\" (2x3) Extensions",3,"Ft.",null,0]
["Alunimum \"Y\" Adaptor",0,"Ea.",null,0]
["New 6\" Gutters",4,"Ft.",null,0]
["New 6\" (3x4) Downspouts",3.5,"Ft.",null,0]
["Install 6\" (3x4) Extensions",3.5,"Ft.",null,0]
["Clean, Seal & Reinforce",0.2,"Ft.",null,0]
["Install New Drip Edge/Flashing",0.2,"Ft.",null,0]
["Install New Fascia Boards",2.5,"Ft.",null,0]
["Install New Metal fascia Only",1.5,"Ft.",null,0]
["Install New Soffit & Fascia",3.5,"Ft.",null,0]
["Install New Soffia Only-Less than 3`",2,"Ft.",null,0]
["Install Porch Ceiling -Over 3`",1.25,"Sq.Ft.",null,0]
["Extra Labor",10,"Hr.",null,0]
["R&R Existing Gutters",1,"Ft.",null,0]
["Replace Existing Gutter Miter",15,"Ea.",null,0]
["Remove Gutter Helmet ",0.15,"Ft.",null,0]
["Remove Existing Hangers (Sawzaii)",0.1,"Ft.",null,0]
["Install New AZEK Fascia Board",2.5,"Ft.",null,0]
["Cut and Remove Shingle Overhang",0.5,"Ft.",null,0]
["Gas Allowance",0.2,"ML",null,0]
[null,null,null,"Total:",{"$f":"SUM(E16:E47)","v":0},"Это значение в колонку I"]
[]
["Reson for no installation","P"]