{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["водители","данные","данныестройка","поставщик","стройки","перевозки","прайс1","прайс2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"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":"водители","index":0,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Столбец1"]
["Иванов"]
["Петров"]
["Сидоров"]
["Козлов"]
["Кукушкин"]
["Никонов"]
["самовывоз"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["http://www.planetaexcel.ru/techniques/1/40/"]

{"sheet":"данные","index":1,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"поставщик",null,null,null,null,null,null,null,null,null,"стройка"]
[]
["арсенал","железобетон","жби3","жби4","завод12","завод2","жби12","завод1","завод22","завод23"]
["ФБС24.3.6-т","ФБС24.3.6-т","ФБВ9.5.6-т"]
["ФБС24.4.6-т","ФБС24.4.6-т","ФБВ9.5.6-т"]
["ФБС24.5.6-т","ФБС24.5.6-т","ФБП24.5.6-т"]
["ФБС12.5.6-т","ФБС12.5.6-т","2ПБ13-1"]
["ФБС12.6.6-т","ФБС12.6.6-т","ПК27.15-10"]
["ФБС12.4.3-т","ФБС12.4.3-т","ПК27.15-12"]
["2ПБ10-1","2ПБ10-1","ПК27.15-16"]
["2ПБ13-1-п","2ПБ13-1-п"]
["ПК56.12-10","ПК56.12-10"]
["ПК27.12-10","ПК27.12-10"]

{"sheet":"данныестройка","index":2,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"стройка",null,null,null,null,null,null,null,null,null,"стройка"]
[]
[]
["погорелки","норское","стр1","стр2","стр3","чип","чук","пробф","Столбец2","Столбец3"]
["ФБВ9.6.6-т"]
["ФБП24.4.6-т"]
["ФБП24.5.6-т"]
["2ПБ10-1-п"]
["2ПБ13-1"]

{"sheet":"поставщик","index":3,"n_rows":20,"n_cols":48,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[{"$f":"жби1[[#Headers],[арсенал]]","v":"арсенал"},null,null,null,null,null,{"$f":"жби1[[#Headers],[железобетон]]","v":"железобетон"},null,null,null,null,null,{"$f":"жби1[[#Headers],[жби3]]","v":"жби3"},null,null,null,null,null,{"$f":"жби1[[#Headers],[жби4]]","v":"жби4"},null,null,null,null,null,{"$f":"жби1[[#Headers],[завод12]]","v":"завод12"},null,null,null,null,null,{"$f":"жби1[[#Headers],[завод2]]","v":"завод2"},null,null,null,null,null,{"$f":"жби1[[#Headers],[жби12]]","v":"жби12"},null,null,null,null,null,{"$f":"жби1[[#Headers],[завод1]]","v":"завод1"}]
["номенклатура","вес","сум.вес","план","Столбец1","факт","номенклатура3","вес4","сум.вес5","план6","Столбец7","факт8","номенклатура2","вес3","сум.вес4","план5","Столбец16","факт7","номенклатура9","вес10","сум.вес11","план12","Столбец113","факт14","номенклатура16","вес17","сум.вес18","план19","Столбец120","факт21","номенклатура17","вес18","сум.вес19","план20","Столбец121","факт22","номенклатура172","вес183","сум.вес194","план205","Столбец1216","факт227","номенклатура173","вес184","сум.вес195","план206","Столбец1217","факт228"]
["ФБС24.3.6-т",0.54,null,21,null,null,"ФБС24.3.6-т",0.54,null,5,null,null,"ФБВ9.5.6-т",0.54,null,21]
["ФБС24.4.6-т",3.36,null,12,null,null,"ФБС24.4.6-т",3.36,null,7,null,null,"ФБВ9.5.6-т",3.36,null,12]
["ФБС24.5.6-т",1.58,null,6,null,null,"ФБС24.5.6-т",1.58,null,null,null,null,"ФБП24.5.6-т",1.58,null,6]
["ФБС12.5.6-т",0.43,null,10,null,null,"ФБС12.5.6-т",0.43,null,null,null,null,"2ПБ13-1",0.43,null,10]
["ФБС12.6.6-т",0.54,null,15,null,null,"ФБС12.6.6-т",0.54,null,null,null,null,"ПК27.15-10",0.54,null,15]
["ФБС12.4.3-т",3.36,null,12,null,null,"ФБС12.4.3-т",3.36,null,null,null,null,"ПК27.15-12",3.36,null,12]
["2ПБ10-1",1.58,null,3,null,null,"2ПБ10-1",1.58,null,null,null,null,"ПК27.15-16",1.58,null,3]
["2ПБ13-1-п",0.54,null,5,null,null,"2ПБ13-1-п",0.54]
["ПК56.12-10",3.36,null,7,null,null,"ПК56.12-10",3.36]
["ПК27.12-10",1.58,null,5,null,null,"ПК27.12-10",1.58]
[]
[]
[]
[]
[]
[null,null,null,"ПОИСКПОЗ(перевозки!F2;Таблица5[номенклатура];0)"]

{"sheet":"стройки","index":4,"n_rows":18,"n_cols":54,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[{"$f":"стройка8[[#Headers],[погорелки]]","v":"погорелки"},null,null,null,null,null,{"$f":"стройка8[[#Headers],[норское]]","v":"норское"},null,null,null,null,null,{"$f":"стройка8[[#Headers],[стр1]]","v":"стр1"},null,null,null,null,null,{"$f":"стройка8[[#Headers],[стр3]]","v":"стр3"},null,null,null,null,null,{"$f":"данныестройка!F4","v":"чип"},null,null,null,null,null,{"$f":"данныестройка!G4","v":"чук"},null,null,null,null,null,{"$f":"данныестройка!H4","v":"пробф"},null,null,null,null,null,{"$f":"данныестройка!I4","v":"Столбец2"},null,null,null,null,null,{"$f":"данныестройка!J4","v":"Столбец3"}]
["номенклатура","вес","сум.вес","план","Столбец1","факт","номенклатура3","вес2","сум.вес5","план6","Столбец7","факт8","номенклатура32","вес3","сум.вес2","план65","пред.день","факт87","номенклатура33","вес4","сум.вес55","план66","Столбец77","факт88","номенклатура332","вес5","сум.вес554","план665","Столбец776","факт887","номенклатура3322","вес4433","сум.вес5544","план6655","Столбец7766","факт8877","номенклатура3323","вес4434","сум.вес5545","план6656","Столбец7767","факт8878","номенклатура3324","вес4435","сум.вес5546","план6657","Столбец7768","факт8879","номенклатура3325","вес4436","сум.вес5547","план6658","Столбец7769","факт8880"]
["ФБС24.3.6-т",0.97,null,10,null,null,"ФБС24.3.6-т",1.96,null,10,null,null,"ФБС24.3.6-т",1.96]
["ФБС24.4.6-т",1.3,null,11,null,null,"ФБС24.4.6-т",0.64,null,11,null,null,"ФБС24.4.6-т",0.64]
["ФБС24.5.6-т",1.63,null,12,null,null,"ФБС24.5.6-т",0.79,null,12,null,null,"ФБС24.5.6-т",0.79]
["ФБС12.5.6-т",0.31,null,13,null,null,"ФБС12.5.6-т",0.96,null,13,null,null,"ФБС12.5.6-т",0.96]
["ФБС12.6.6-т",0.79,null,14,null,null,"ФБС12.6.6-т",0.43,null,14,null,null,"ФБС12.6.6-т",0.43]
["ФБС12.4.3-т",0.96,null,15,null,null,"ФБС12.4.3-т",0.54,null,15]
["2ПБ10-1",0.43,null,16,null,null,"2ПБ10-1",1.97,null,16]
["2ПБ13-1-п",0.54,null,21,null,null,"2ПБ13-1-п",2.37,null,5]
["ПК56.12-10",3.36,null,12,null,null,"ПК56.12-10",3.16,null,7]
["ПК27.12-10",1.58,null,6,null,null,"ПК27.12-10"]
["ФБВ9.5.6-т",null,null,null,null,null,"ПК27.15-10",0.54]
["ФБВ9.5.6-т",null,null,null,null,null,"ПК27.15-12",3.36]
["ФБП24.5.6-т",null,null,null,null,null,"ПК27.15-16",1.58]
["2ПБ13-1"]

{"sheet":"перевозки","index":5,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["дата","водитель",null,"куда","откуда","что","вес","количество","сум.вес"]
["2014-02-01","Козлов",null,"погорелки","арсенал","ФБС24.4.6-т",{"$f":"IFERROR(VLOOKUP(F2,прайс,2,FALSE),0)","v":3.36},20,{"$f":"G2*H2","v":67.2}]
["2014-03-01","Никонов",null,"погорелки","железобетон","ФБС12.5.6-т",0.43,21,{"$f":"G3*H3","v":9.0299999999999994}]
["2014-03-02","Иванов",null,"норское","жби3","ПК27.15-12",3.36,15,50.4]
["2014-03-03","Козлов",null,"погорелки","арсенал","ФБС24.4.6-т",3.36,22,73.92]
["2014-03-03","Козлов",null,"погорелки","арсенал","ФБС24.5.6-т",1.58,12,18.96]
["2014-03-03","Козлов",null,"норское","арсенал","2ПБ10-1",1.58,5,7.9]
["2014-03-04","Иванов",null,"погорелки","арсенал","ФБС12.5.6-т",0.43,3,1.29]
[null,null,null,"стр1","железобетон","ФБС24.3.6-т",0.54,3,1.62]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]

{"sheet":"прайс1","index":6,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
["ФБС24.3.6-т",0.54]
["ФБС24.4.6-т",3.36]
["ФБС24.5.6-т",1.58]
["ФБС12.5.6-т",0.43]
["ФБС12.6.6-т",0.54]
["ФБС12.4.3-т",3.36]
["2ПБ10-1",1.58]
["2ПБ13-1-п",0.54]
["ПК56.12-10",3.36]
["ПК27.12-10",1.58]
["ФБС24.3.6-т",0.54]
["ФБС24.4.6-т",3.36]
["ФБС24.5.6-т",1.58]
["ФБС12.5.6-т",0.43]
["ФБС12.6.6-т",0.54]
["ФБС12.4.3-т",3.36]
["2ПБ10-1",1.58]
["2ПБ13-1-п",0.54]
["ПК56.12-10",3.36]
["ПК27.12-10",1.58]
["ФБВ9.5.6-т",0.54]
["ФБВ9.5.6-т",3.36]
["ФБП24.5.6-т",1.58]
["2ПБ13-1",0.43]
["ПК27.15-10",0.54]
["ПК27.15-12",3.36]
["ПК27.15-16",1.58]

{"sheet":"прайс2","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}