{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Test"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Test","index":0,"n_rows":31,"n_cols":30,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Material","Material Description","Posting Date","Purchase Order","Material Document","Plant","Movement Type","Movement Type Text","Qty in Un. of Entry","Unit of Entry","Amount in LC","Storage Location","Qty in OPUn","Document Date","Entry Date","Vendor","Quantity","Base Unit of Measure","Material Doc. Year","Currency","Reference","User name","Reason for Movement","Time of Entry","Company Code","Movement indicator","Order"]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2012-12-11","5400094864","5032007415","6900","101","GR goods receipt",1,"EA",794.42,"0002",1,"2012-12-07","2012-12-11","1394506",1,"EA","2012","UAH","0000408","F081063","0","10:55:30","UA1","B","",null,{"$f":"IF(AND($G2=\"261\",SUMIF($A$1:$A2,A2,$I$1:$I2)=0),0,IF(G2=\"101\",0,1))","v":0}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2013-01-03","","4935439399","6900","261","GI for order",-1,"EA",-795.42,"0002",0,"2013-01-03","2013-01-03","",-1,"EA","2013","UAH","","G080931","0","06:42:31","UA1","","5474100",null,{"$f":"IF(AND($G3=\"261\",SUMIF($A$1:$A3,A3,$I$1:$I3)=0),0,1)","v":0}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2013-01-15","5400095760","5032341291","6900","101","GR goods receipt",1,"EA",795.42,"0002",1,"2013-01-11","2013-01-15","1394506",1,"EA","2013","UAH","PH-0000005","G080931","0","08:08:17","UA1","B","",null,{"$f":"IF(AND($G4=\"261\",SUMIF($A$1:$A4,A4,$I$1:$I4)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2013-02-27","","4936089800","6900","261","GI for order",-1,"EA",-795.42,"0002",0,"2013-02-27","2013-02-27","",-1,"EA","2013","UAH","","G080931","0","10:34:49","UA1","","5489241",null,{"$f":"IF(AND($G5=\"261\",SUMIF($A$1:$A5,A5,$I$1:$I5)=0),0,1)","v":0}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2013-03-05","5400098226","5032904064","6900","101","GR goods receipt",1,"EA",795.42,"0002",1,"2013-03-04","2013-03-05","1394506",1,"EA","2013","UAH","PH-0000074","G080931","0","08:05:59","UA1","B","",null,{"$f":"IF(AND($G6=\"261\",SUMIF($A$1:$A6,A6,$I$1:$I6)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2013-05-07","","4936962214","6900","261","GI for order",-1,"EA",-874.97,"0002",0,"2013-05-07","2013-05-07","",-1,"EA","2013","UAH","","G080931","0","05:32:11","UA1","","5509302",null,{"$f":"IF(AND($G7=\"261\",SUMIF($A$1:$A7,A7,$I$1:$I7)=0),0,1)","v":0}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2013-05-17","5400101274","5033766762","6900","101","GR goods receipt",1,"EA",874.97,"0002",1,"2013-05-16","2013-05-17","1394268",1,"EA","2013","UAH","PH-0000176","G080931","0","07:55:07","UA1","B","",null,{"$f":"IF(AND($G8=\"261\",SUMIF($A$1:$A8,A8,$I$1:$I8)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2013-06-01","","4937275504","6900","261","GI for order",-1,"EA",-1006.22,"0002",0,"2013-06-01","2013-06-01","",-1,"EA","2013","UAH","","G080931","0","05:02:08","UA1","","5521103",null,{"$f":"IF(AND($G9=\"261\",SUMIF($A$1:$A9,A9,$I$1:$I9)=0),0,1)","v":0}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2013-07-03","5400102528","5034298968","6900","101","GR goods receipt",2,"EA",2012.44,"0002",2,"2013-07-01","2013-07-03","1394268",2,"EA","2013","UAH","PH-0000238","G080931","0","12:06:16","UA1","B","",null,{"$f":"IF(AND($G10=\"261\",SUMIF($A$1:$A10,A10,$I$1:$I10)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2013-07-28","","4937951501","6900","261","GI for order",-1,"EA",-1006.22,"0002",0,"2013-07-28","2013-07-28","",-1,"EA","2013","UAH","","G080931","0","07:44:07","UA1","","5546840",null,{"$f":"IF(AND($G11=\"261\",SUMIF($A$1:$A11,A11,$I$1:$I11)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2013-08-06","5400105312","5034687064","6900","101","GR goods receipt",1,"EA",1006.22,"0002",1,"2013-08-01","2013-08-06","1405905",1,"EA","2013","UAH","PH-0000054","G080931","0","07:36:35","UA1","B","",null,{"$f":"IF(AND($G12=\"261\",SUMIF($A$1:$A12,A12,$I$1:$I12)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2013-10-02","","4938701945","6900","261","GI for order",-1,"EA",-940.61,"0002",0,"2013-10-02","2013-10-02","",-1,"EA","2013","UAH","","G080931","0","05:58:52","UA1","","5575215",null,{"$f":"IF(AND($G13=\"261\",SUMIF($A$1:$A13,A13,$I$1:$I13)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2013-10-08","5400108769","5035402491","6900","101","GR goods receipt",1,"EA",940.61,"0002",1,"2013-10-04","2013-10-08","1405905",1,"EA","2013","UAH","0000175","G080931","0","09:40:44","UA1","B","",null,{"$f":"IF(AND($G14=\"261\",SUMIF($A$1:$A14,A14,$I$1:$I14)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2013-11-27","","4939345705","6900","261","GI for order",-1,"EA",-907.81,"0002",0,"2013-11-27","2013-11-27","",-1,"EA","2013","UAH","","G080931","0","12:19:16","UA1","","5598918",null,{"$f":"IF(AND($G15=\"261\",SUMIF($A$1:$A15,A15,$I$1:$I15)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2013-12-03","5400111802","5036039083","6900","101","GR goods receipt",1,"EA",907.8,"0002",1,"2013-12-02","2013-12-03","1405905",1,"EA","2013","UAH","PH-0000256","G080931","0","08:27:42","UA1","B","",null,{"$f":"IF(AND($G16=\"261\",SUMIF($A$1:$A16,A16,$I$1:$I16)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2014-04-01","","4940704548","6900","261","GI for order",-1,"EA",-891.4,"0002",0,"2014-04-01","2014-04-01","",-1,"EA","2014","UAH","","G080931","0","09:32:42","UA1","","5653085",null,{"$f":"IF(AND($G17=\"261\",SUMIF($A$1:$A17,A17,$I$1:$I17)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2014-04-08","5400118260","5037390216","6900","101","GR goods receipt",1,"EA",891.4,"0002",1,"2014-04-02","2014-04-08","1405905",1,"EA","2014","UAH","PH-0000098","G080931","0","07:31:51","UA1","B","",null,{"$f":"IF(AND($G18=\"261\",SUMIF($A$1:$A18,A18,$I$1:$I18)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2015-01-08","","4943846864","6900","261","GI for order",-1,"EA",-1078.2,"0002",0,"2015-01-08","2015-01-08","",-1,"EA","2015","UAH","","G080931","0","07:03:24","UA1","","5771533",null,{"$f":"IF(AND($G19=\"261\",SUMIF($A$1:$A19,A19,$I$1:$I19)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2015-01-08","","4943846863","6900","261","GI for order",-1,"EA",-1078.2,"0002",0,"2015-01-08","2015-01-08","",-1,"EA","2015","UAH","","G080931","0","07:03:12","UA1","","5771533",null,{"$f":"IF(AND($G20=\"261\",SUMIF($A$1:$A20,A20,$I$1:$I20)=0),0,1)","v":0},"на этом этапе все все выше \"0\" должно отображать ноль."]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2015-01-16","5400132930","5040319587","6900","101","GR goods receipt",2,"EA",2156.4,"0002",2,"2015-01-13","2015-01-16","1405905",2,"EA","2015","UAH","РН-0000004","G080931","0","09:50:06","UA1","B","",null,{"$f":"IF(AND($G21=\"261\",SUMIF($A$1:$A21,A21,$I$1:$I21)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2015-12-11","5400150753","5043899840","6900","101","GR goods receipt",1,"EA",1799.17,"0002",1,"2015-12-07","2015-12-11","1405905",1,"EA","2015","UAH","PH-0000351","G080931","0","11:57:13","UA1","B","",null,{"$f":"IF(AND($G22=\"261\",SUMIF($A$1:$A22,A22,$I$1:$I22)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2016-01-04","","4948137249","6900","261","GI for order",-1,"EA",-2130.62,"0002",0,"2016-01-04","2016-01-04","",-1,"EA","2016","UAH","","G080931","0","08:59:25","UA1","","5922131",null,{"$f":"IF(AND($G23=\"261\",SUMIF($A$1:$A23,A23,$I$1:$I23)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2016-07-07","","4950364441","6900","261","GI for order",-1,"EA",-2130.63,"0002",0,"2016-07-07","2016-07-07","",-1,"EA","2016","UAH","","G080931","0","10:26:58","UA1","","5998903",null,{"$f":"IF(AND($G24=\"261\",SUMIF($A$1:$A24,A24,$I$1:$I24)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2016-07-19","5400162491","5046182382","6900","101","GR goods receipt",1,"EA",2130.62,"0002",1,"2016-07-14","2016-07-19","1405905",1,"EA","2016","UAH","PH-0000204","G080931","0","06:27:22","UA1","B","",null,{"$f":"IF(AND($G25=\"261\",SUMIF($A$1:$A25,A25,$I$1:$I25)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2016-11-15","","4951896543","6900","261","GI for order",-1,"EA",-2435.73,"0002",0,"2016-11-15","2016-11-15","",-1,"EA","2016","UAH","","G080931","0","08:13:05","UA1","","6048235",null,{"$f":"IF(AND($G26=\"261\",SUMIF($A$1:$A26,A26,$I$1:$I26)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2016-11-25","5400169800","5047588497","6900","101","GR goods receipt",1,"EA",2435.73,"0002",1,"2016-11-16","2016-11-25","1405905",1,"EA","2016","UAH","PH-0000369","G080931","0","09:15:09","UA1","B","",null,{"$f":"IF(AND($G27=\"261\",SUMIF($A$1:$A27,A27,$I$1:$I27)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2017-12-15","","4956277990","6900","261","GI for order",-1,"EA",-2746.37,"0002",0,"2017-12-15","2017-12-15","",-1,"EA","2017","UAH","","G080931","0","08:38:28","UA1","","6192842",null,{"$f":"IF(AND($G28=\"261\",SUMIF($A$1:$A28,A28,$I$1:$I28)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2017-12-27","5400190233","5051687864","6900","101","GR goods receipt",1,"EA",2746.36,"0002",1,"2017-12-22","2017-12-27","1405905",1,"EA","2017","UAH","PH-0000503","G080931","0","09:01:11","UA1","B","",null,{"$f":"IF(AND($G29=\"261\",SUMIF($A$1:$A29,A29,$I$1:$I29)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2018-07-10","","4958476518","6900","261","GI for order",-1,"EA",-2418.1799999999998,"0002",0,"2018-07-10","2018-07-10","",-1,"EA","2018","UAH","","G080931","0","12:27:05","UA1","","6278278",null,{"$f":"IF(AND($G30=\"261\",SUMIF($A$1:$A30,A30,$I$1:$I30)=0),0,1)","v":1}]
["10115787","Motor MS 712-4 0,37кВт1400 B14 71","2018-07-18","5400200123","5053701704","6900","101","GR goods receipt",1,"EA",2418.1799999999998,"0002",1,"2018-07-17","2018-07-18","1405905",1,"EA","2018","UAH","РН-0000263","G080931","0","05:58:10","UA1","B","",null,{"$f":"IF(AND($G31=\"261\",SUMIF($A$1:$A31,A31,$I$1:$I31)=0),0,1)","v":1},"Начало формулы идет снизу"]