{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Номер вагона",null,2,1,2,1,2,1,2,1,null,"Проверка номера ж.д. вагонов на правильность"]
[52455664,{"$f":"SUMPRODUCT(RIGHT(MID(A2,ROW($A$1:$A$8),1)*(1+ISODD(ROW($A$1:$A$8))),1)+(--MID(A2,ROW($A$1:$A$8),1)>4)*ISODD(ROW($A$1:$A$8)))","v":30},{"$f":"(RIGHT(MID($A2,COLUMN()-2,1)*C$1,1)+(--MID($A2,COLUMN()-2,1)>4)*(C$1-1))","v":1},{"$f":"(RIGHT(MID($A2,COLUMN()-2,1)*D$1,1)+(--MID($A2,COLUMN()-2,1)>4)*(D$1-1))","v":2},8,5,1,6,3,4,{"$f":"SUM(C2:J2)","v":30},"Условие (нечетные символы*2(усл.если итог 2цифры, то 1с+2с)+ четные*1)) и если сумма всех символов =10,20,30,40,50 то правда"]
[52456076,30,{"$f":"(RIGHT(MID($A3,COLUMN()-2,1)*C$1,1)+(--MID($A3,COLUMN()-2,1)>4)*(C$1-1))","v":1},2,8,5,3,0,5,6,{"$f":"SUM(C3:J3)","v":30}]
[52437928,40,1,2,8,3,5,9,4,8,40]
[52437936,40,1,2,8,3,5,9,6,6,40]
[52423019,30,1,2,8,2,6,0,2,9,30]
[52455482,30,1,2,8,5,1,4,7,2,30]
[24000648,30,4,4,0,0,0,6,8,8,30]