{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Criteria","+++++","Result(было)","Result(после макроса)","+++++(должно стать)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"Criteria","index":0,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
["Критерии для юр. лиц (1)","Вес оценки","Критерии для ИП (3)","Вес оценки"]
["Критерий 10",3,"Критерий 2",2]
["Критерий 11",5,"Критерий 3",11]
["Критерий 12",60,"Критерий 4",61]
["Критерий 13",35,"Критерий 5",5]
["Критерий 14",10]

{"sheet":"+++++","index":1,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,0,3,0],[1,1,3,1],[1,2,3,2],[1,3,3,3],[1,4,3,4]]}
[]
["Код","Тип клиента (3-ИП, 1-ЮР)","ИНН","Клиент","Индекс"]

{"sheet":"Result(было)","index":2,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[1,2,3,5,5,6,10,8]
[1,1,3,1,1,3,1,3]
[1234567890,987548346,123456789012,1234567890,987548346,573234527441,9269976185,124563716591]
["Критерий 10","Критерий 11","Критерий 2","Критерий 11","Критерий 12","Критерий 2"]
["Критерий 11","Критерий 12","Критерий 5","Критерий 12",null,"Критерий 5"]
["Критерий 12",null,null,null,null,"Критерий 4"]
["Критерий 13"]
[]
[9,10,11,12,13,14,15,16]
[" ",3,1,3,3," "," ",1]
[null,448885773967,4144589425,128732956459,347193691287," "," ",3421625433]
[]
[]
[]
[]
[]
[17]
["Неверно указан ИНН"]
["334345c"]

{"sheet":"Result(после макроса)","index":3,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[1,2,3,5,5,6,10,8]
[1,1,3,1,1,3,1,3]
[1234567890,987548346,123456789012,1234567890,987548346,573234527441,9269976185,124563716591]
[3,5,2,5,60,2]
[5,60,5,60,null,5]
[60,null,null,null,null,61]
[35]
[]
[9,10,11,12,13,14,15,16]
[" ",3,1,3,3," "," ",1]
[null,448885773967,4144589425,128732956459,347193691287," "," ",3421625433]
[]
[]
[]
[]
[]
[17]
["Неверно указан ИНН"]
["334345c"]

{"sheet":"+++++(должно стать)","index":4,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,0,3,0],[1,1,3,1],[1,2,3,2],[1,3,3,3],[1,4,3,4]]}
[]
["Код","Тип клиента (3-ИП, 1-ЮР)","ИНН","Клиент","Индекс"]
[]
[null,null,null,null,null,"Критерии"]
[1,1,1234567890,null,{"$f":"SUM('Result(после макроса)'!A4:A7)","v":103},"Критерий 10_Критерий 11_Критерий 12_Критерий 13"]
[2,1,987548346,null,{"$f":"SUM('Result(после макроса)'!B4:B5)","v":65},"Критерий 11_Критерий 12"]
[3,3,123456789012,null,{"$f":"SUM('Result(после макроса)'!B5:B6)","v":60}]
[4,1,1234567890,null,{"$f":"SUM('Result(после макроса)'!B6:B7)","v":0}]
[5,1,987548346]
[6,3,573234527441]
[7,1,9269976185]
[8,3,124563716591]
[9," "]
[10,3,448885773967]
[11,1,4144589425]
[12,3,128732956459]
[13,3,347193691287]
[14," "," "]
[15," "," "]
[16,1,3421625433]
[17,"Неверно указан ИНН","334345c"]