{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","сверка"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Лист1","index":0,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9]
["071-011-005613-051-240-161 95-НР","071-011-005613","НР",2010,"051-240-161 95",10000,1212,0,0]
["071-011-005613-051-240-161 95-НР","071-011-005613","НР",2010,"051-240-161 95",10000,5000,0,0]
["071-011-005613-051-240-161 95-НР","071-011-005613","НР",2010,"051-240-161 95",10000,5000,0,0]
["071-011-005613-051-240-161 95-НР","071-011-005613","НР",2010,"051-240-161 95",10000,5000,0,0]
["071-011-005613-051-240-161 95-НР","071-011-005613","НР",2010,"051-240-161 95",10000,5000,0,0]
["071-011-005613-051-240-161 95-НР","071-011-005613","НР",2010,"051-240-161 95",10000,5000,0,0]
["071-011-005613-051-240-161 95-НР","071-011-005613","НР",2010,"051-240-161 95",10000,5000,0,0]
["071-011-005613-037-549-963 00-НР","071-011-005613","НР",2010,"037-549-963 00",9000,4000,0,0]
["071-011-005613-037-549-963 00-НР","071-011-005613","НР",2010,"037-549-963 00",9000,4000,0,0]
["071-011-005613-037-549-963 00-НР","071-011-005613","НР",2010,"037-549-963 00",9000,4000,0,0]
["071-011-005613-037-549-963 00-НР","071-011-005613","НР",2010,"037-549-963 00",9000,4000,0,0]
["071-011-005613-037-549-963 00-НР","071-011-005613","НР",2010,"037-549-963 00",9000,4000,0,0]
["071-011-005613-037-549-963 00-НР","071-011-005613","НР",2010,"037-549-963 00",9000,4000,0,0]
["071-011-005613-037-549-963 00-НР","071-011-005613","НР",2010,"037-549-963 00",9000,4000,0,0]
["071-011-005613-032-042-345 88-НР","071-011-005613","НР",2010,"032-042-345 88",8000,3000,0,0]
["071-011-005613-032-042-345 88-НР","071-011-005613","НР",2010,"032-042-345 88",8000,3000,0,0]
["071-011-005613-032-042-345 88-НР","071-011-005613","НР",2010,"032-042-345 88",8000,3000,0,0]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",7000,2000,5500,3000]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",7000,2000,5500,3000]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",7000,2000,5500,3000]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",7000,2000,5500,3000]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",7000,2000,5500,3000]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",7000,2000,5500,3000]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",7000,2000,5500,3000]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",7000,2000,5500,3000]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",7000,2000,5500,3000]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",7000,2000,5500,3000]
["071-011-005613-032-042-346 89-НР","071-011-005613","НР",2010,"032-042-346 89",11000,6000,4100,2600]
["071-011-005613-032-042-346 89-НР","071-011-005613","НР",2010,"032-042-346 89",11000,6000,4100,2600]
["071-011-005613-032-042-346 89-НР","071-011-005613","НР",2010,"032-042-346 89",11000,6000,4100,2600]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",12000,7000,3500,2000]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",12000,7000,3500,2000]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",12000,7000,3500,2000]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",12000,7000,3500,2000]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",12000,7000,3500,2000]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",12000,7000,3500,2000]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",12000,7000,3500,2000]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",12000,7000,3500,2000]

{"sheet":"Лист2","index":1,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9]
["071-011-005613-051-240-161 95-НР","071-011-005613","НР",2010,"051-240-161 95",18065.580000000002,99,0,0]
["071-011-005613-051-240-161 95-НР","071-011-005613","НР",2010,"051-240-161 95",18065.580000000002,16795.54,0,0]
["071-011-005613-051-240-161 95-НР","071-011-005613","НР",2010,"051-240-161 95",18065.580000000002,16795.54,0,0]
["071-011-005613-051-240-161 95-НР","071-011-005613","НР",2010,"051-240-161 95",18065.580000000002,16795.54,0,0]
["071-011-005613-051-240-161 95-НР","071-011-005613","НР",2010,"051-240-161 95",18065.580000000002,16795.54,0,0]
["071-011-005613-051-240-161 95-НР","071-011-005613","НР",2010,"051-240-161 95",18065.580000000002,16795.54,0,0]
["071-011-005613-051-240-161 95-НР","071-011-005613","НР",2010,"051-240-161 95",18065.580000000002,16795.54,0,0]
["071-011-005613-037-549-963 00-НР","071-011-005613","НР",2010,"037-549-963 00",21569.73,18606.650000000001,0,0]
["071-011-005613-037-549-963 00-НР","071-011-005613","НР",2010,"037-549-963 00",21569.73,18606.650000000001,0,0]
["071-011-005613-037-549-963 00-НР","071-011-005613","НР",2010,"037-549-963 00",21569.73,18606.650000000001,0,0]
["071-011-005613-037-549-963 00-НР","071-011-005613","НР",2010,"037-549-963 00",21569.73,18606.650000000001,0,0]
["071-011-005613-037-549-963 00-НР","071-011-005613","НР",2010,"037-549-963 00",21569.73,18606.650000000001,0,0]
["071-011-005613-037-549-963 00-НР","071-011-005613","НР",2010,"037-549-963 00",21569.73,18606.650000000001,0,0]
["071-011-005613-037-549-963 00-НР","071-011-005613","НР",2010,"037-549-963 00",21569.73,18606.650000000001,0,0]
["071-011-005613-032-042-345 88-НР","071-011-005613","НР",2010,"032-042-345 88",18526.43,18598.87,0,0]
["071-011-005613-032-042-345 88-НР","071-011-005613","НР",2010,"032-042-345 88",18526.43,18598.87,0,0]
["071-011-005613-032-042-345 88-НР","071-011-005613","НР",2010,"032-042-345 88",18526.43,18598.87,0,0]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",10959.77,10040.719999999999,4697.04,4219]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",10959.77,10040.719999999999,4697.04,4219]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",10959.77,10040.719999999999,4697.04,4219]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",10959.77,10040.719999999999,4697.04,4219]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",10959.77,10040.719999999999,4697.04,4219]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",10959.77,10040.719999999999,4697.04,4219]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",10959.77,10040.719999999999,4697.04,4219]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",10959.77,10040.719999999999,4697.04,4219]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",10959.77,10040.719999999999,4697.04,4219]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",10959.77,10040.719999999999,4697.04,4219]
["071-011-005613-032-042-346 89-НР","071-011-005613","НР",2010,"032-042-346 89",13931.47,13204.78,5970.63,5514.96]
["071-011-005613-032-042-346 89-НР","071-011-005613","НР",2010,"032-042-346 89",13931.47,13204.78,5970.63,5514.96]
["071-011-005613-032-042-346 89-НР","071-011-005613","НР",2010,"032-042-346 89",13931.47,13204.78,5970.63,5514.96]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",9782.93,8209.19,4192.68,3466.67]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",9782.93,8209.19,4192.68,3466.67]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",9782.93,8209.19,4192.68,3466.67]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",9782.93,8209.19,4192.68,3466.67]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",9782.93,8209.19,4192.68,3466.67]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",9782.93,8209.19,4192.68,3466.67]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",9782.93,8209.19,4192.68,3466.67]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",9782.93,8209.19,4192.68,3466.67]

{"sheet":"сверка","index":2,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9]
["071-011-005613-051-240-161 95-НР","071-011-005613","НР",2010,"051-240-161 95",20000,88,0,0,null,null,null,{"$f":"VLOOKUP(A2,Лист1!$A$2:$G$40,6,0)-VLOOKUP(A2,Лист1!$A$2:$G$40,7,0)+VLOOKUP(A2,Лист2!$A$2:$G$40,6,0)-VLOOKUP(A2,Лист2!$A$2:$G$40,7,0)+F2-G2","v":46666.58},{"$f":"VLOOKUP(A2,Лист1!$A$2:$I$40,8,0)-VLOOKUP(A2,Лист1!$A$2:$I$40,9,0)+VLOOKUP(A2,Лист2!$A$2:$I$40,8,0)-VLOOKUP(A2,Лист2!$A$2:$I$40,9,0)+H2-I2","v":0}]
["071-011-005613-037-549-963 00-НР","071-011-005613","НР",2010,"037-549-963 00",22000,21200,0,0,null,null,null,{"$f":"VLOOKUP(A3,Лист1!$A$2:$G$40,6,0)-VLOOKUP(A3,Лист1!$A$2:$G$40,7,0)+VLOOKUP(A3,Лист2!$A$2:$G$40,6,0)-VLOOKUP(A3,Лист2!$A$2:$G$40,7,0)+F3-G3","v":8763.0799999999981},{"$f":"VLOOKUP(A3,Лист1!$A$2:$I$40,8,0)-VLOOKUP(A3,Лист1!$A$2:$I$40,9,0)+VLOOKUP(A3,Лист2!$A$2:$I$40,8,0)-VLOOKUP(A3,Лист2!$A$2:$I$40,9,0)+H3-I3","v":0}]
["071-011-005613-032-042-345 88-НР","071-011-005613","НР",2010,"032-042-345 88",19000,18000,0,0,null,null,null,{"$f":"VLOOKUP(A4,Лист1!$A$2:$G$40,6,0)-VLOOKUP(A4,Лист1!$A$2:$G$40,7,0)+VLOOKUP(A4,Лист2!$A$2:$G$40,6,0)-VLOOKUP(A4,Лист2!$A$2:$G$40,7,0)+F4-G4","v":5927.5600000000013},{"$f":"VLOOKUP(A4,Лист1!$A$2:$I$40,8,0)-VLOOKUP(A4,Лист1!$A$2:$I$40,9,0)+VLOOKUP(A4,Лист2!$A$2:$I$40,8,0)-VLOOKUP(A4,Лист2!$A$2:$I$40,9,0)+H4-I4","v":0}]
["071-011-005613-032-131-191 85-НР","071-011-005613","НР",2010,"032-131-191 85",15000,14000,7000,5000,null,null,null,{"$f":"VLOOKUP(A5,Лист1!$A$2:$G$40,6,0)-VLOOKUP(A5,Лист1!$A$2:$G$40,7,0)+VLOOKUP(A5,Лист2!$A$2:$G$40,6,0)-VLOOKUP(A5,Лист2!$A$2:$G$40,7,0)+F5-G5","v":6919.0500000000029},{"$f":"VLOOKUP(A5,Лист1!$A$2:$I$40,8,0)-VLOOKUP(A5,Лист1!$A$2:$I$40,9,0)+VLOOKUP(A5,Лист2!$A$2:$I$40,8,0)-VLOOKUP(A5,Лист2!$A$2:$I$40,9,0)+H5-I5","v":4978.0400000000009}]
["071-011-005613-032-042-346 89-НР","071-011-005613","НР",2010,"032-042-346 89",14000,13500,6000,5200,null,null,null,{"$f":"VLOOKUP(A6,Лист1!$A$2:$G$40,6,0)-VLOOKUP(A6,Лист1!$A$2:$G$40,7,0)+VLOOKUP(A6,Лист2!$A$2:$G$40,6,0)-VLOOKUP(A6,Лист2!$A$2:$G$40,7,0)+F6-G6","v":6226.6900000000023},{"$f":"VLOOKUP(A6,Лист1!$A$2:$I$40,8,0)-VLOOKUP(A6,Лист1!$A$2:$I$40,9,0)+VLOOKUP(A6,Лист2!$A$2:$I$40,8,0)-VLOOKUP(A6,Лист2!$A$2:$I$40,9,0)+H6-I6","v":2755.67}]
["071-011-005613-061-736-924 70-НР","071-011-005613","НР",2010,"061-736-924 70",15300,15000,5600,5000,null,null,null,{"$f":"VLOOKUP(A7,Лист1!$A$2:$G$40,6,0)-VLOOKUP(A7,Лист1!$A$2:$G$40,7,0)+VLOOKUP(A7,Лист2!$A$2:$G$40,6,0)-VLOOKUP(A7,Лист2!$A$2:$G$40,7,0)+F7-G7","v":6873.739999999998},{"$f":"VLOOKUP(A7,Лист1!$A$2:$I$40,8,0)-VLOOKUP(A7,Лист1!$A$2:$I$40,9,0)+VLOOKUP(A7,Лист2!$A$2:$I$40,8,0)-VLOOKUP(A7,Лист2!$A$2:$I$40,9,0)+H7-I7","v":2826.01}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Посторонних листов в книге не д.б."]
[null,null,null,null,"Данные д.б. организованы одинаково: 1-я строка - заголовки, сами данные начинаются со 2-й строки."]
[null,null,null,null,"Синие столбцы с формулами"]
[null,null,null,null,"Строк д.б. не более 60000, в противном случае нужно немного по-другому."]