{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["ITEM","NAM","CUS","CLI","DATE","AINSTALL","OUT","PAID","BLANCE","MOVEMENT"]
[{"$f":"IF((A1)<>\"ITEM\",(A1)+1,1)","v":1},1,"cust","CL1","18/6/2022",170,null,{"$f":"SUMIFS(F$2:F2,C2:C$2,C2)","v":170},null,"NOT PAID"]
[{"$f":"IF((A2)<>\"ITEM\",(A2)+1,1)","v":2},1,"cust","CL2","19/6/2022",170,null,{"$f":"SUMIFS(F$2:F3,C$2:C3,C3)","v":340},{"$f":"SUMIFS(F$2:F3,D$2:D3,D3)-SUMIFS(G$2:G3,D$2:D3,D3)","v":170},"NOT PAID"]
[3,1,"cust","CL3","20/6/2022",170,null,{"$f":"SUMIFS(F$2:F4,C$2:C4,C4)","v":510},{"$f":"SUMIFS(F$2:F4,D$2:D4,D4)-SUMIFS(G$2:G4,D$2:D4,D4)","v":170},"NOT PAID"]
[4,2,"cust","CL4","2022-06-17",null,null,{"$f":"SUMIFS(F$2:F5,C$2:C5,C5)","v":510},{"$f":"SUMIFS(F$2:F5,D$2:D5,D5)-SUMIFS(G$2:G5,D$2:D5,D5)","v":0},"NOT PAID"]
[5,3,"supp","CL5","2022-06-01",null,1200,{"$f":"SUMIFS(F$2:F6,C$2:C6,C6)","v":0},{"$f":"SUMIFS(F$2:F6,D$2:D6,D6)-SUMIFS(G$2:G6,D$2:D6,D6)","v":-1200},"PAID"]
[6,4,"cust","CL6","2022-06-21",null,1400,{"$f":"SUMIFS(F$2:F7,C$2:C7,C7)","v":510},{"$f":"SUMIFS(F$2:F7,D$2:D7,D7)-SUMIFS(G$2:G7,D$2:D7,D7)","v":-1400},"PAID"]
[7,5,"cust","CL1","2022-06-22",null,1000,{"$f":"SUMIFS(F$2:F8,C$2:C8,C8)","v":510},{"$f":"SUMIFS(F$2:F8,D$2:D8,D8)-SUMIFS(G$2:G8,D$2:D8,D8)","v":-830},"PAID"]
[8,6,"cust","CL2","2022-06-23",null,1001,{"$f":"SUMIFS(F$2:F9,C$2:C9,C9)","v":510},{"$f":"SUMIFS(F$2:F9,D$2:D9,D9)-SUMIFS(G$2:G9,D$2:D9,D9)","v":-831},"PAID"]