{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SOURCE ","المطلوب "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"SOURCE ","index":0,"n_rows":318,"n_cols":6,"rows_kept":318,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"SUM(C3:$C60)","v":0},{"$f":"SUM(D2:D60)","v":0},null,{"$f":"C1-D1","v":0}]
["Invice date","Type","original amount ","open amount ","status"]
[null,null,null,{"$f":"IF(E3=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E3:E59),E3)","v":0}]
[null,null,null,{"$f":"IF(E4=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E4:E59),E4)","v":0}]
[null,null,null,{"$f":"IF(E5=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E5:E60),E5)","v":0}]
[null,null,null,{"$f":"IF(E6=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E6:E61),E6)","v":0}]
[null,null,null,{"$f":"IF(E7=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E7:E62),E7)","v":0}]
[null,null,null,{"$f":"IF(E8=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E8:E63),E8)","v":0}]
[null,null,null,{"$f":"IF(E9=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E9:E64),E9)","v":0}]
[null,null,null,{"$f":"IF(E10=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E10:E65),E10)","v":0}]
[null,null,null,{"$f":"IF(E11=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E11:E66),E11)","v":0}]
[null,null,null,{"$f":"IF(E12=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E12:E67),E12)","v":0}]
[null,null,null,{"$f":"IF(E13=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E13:E68),E13)","v":0}]
[null,null,null,{"$f":"IF(E14=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E14:E69),E14)","v":0}]
[null,null,null,{"$f":"IF(E15=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E15:E70),E15)","v":0}]
[null,null,null,{"$f":"IF(E16=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E16:E71),E16)","v":0}]
[null,null,null,{"$f":"IF(E17=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E17:E72),E17)","v":0}]
[null,null,null,{"$f":"IF(E18=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E18:E73),E18)","v":0}]
[null,null,null,{"$f":"IF(E19=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E19:E74),E19)","v":0}]
[null,null,null,{"$f":"IF(E20=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E20:E75),E20)","v":0}]
[null,null,null,{"$f":"IF(E21=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E21:E76),E21)","v":0}]
[null,null,null,{"$f":"IF(E22=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E22:E77),E22)","v":0}]
[null,null,null,{"$f":"IF(E23=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E23:E78),E23)","v":0}]
[null,null,null,{"$f":"IF(E24=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E24:E79),E24)","v":0}]
[null,null,null,{"$f":"IF(E25=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E25:E80),E25)","v":0}]
[null,null,null,{"$f":"IF(E26=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E26:E81),E26)","v":0}]
[null,null,null,{"$f":"IF(E27=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E27:E82),E27)","v":0}]
[null,null,null,{"$f":"IF(E28=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E28:E83),E28)","v":0}]
[null,null,null,{"$f":"IF(E29=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E29:E84),E29)","v":0}]
[null,null,null,{"$f":"IF(E30=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E30:E85),E30)","v":0}]
[null,null,null,{"$f":"IF(E31=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E31:E86),E31)","v":0}]
[null,null,null,{"$f":"IF(E32=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E32:E87),E32)","v":0}]
[null,null,null,{"$f":"IF(E33=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E33:E88),E33)","v":0}]
[null,null,null,{"$f":"IF(E34=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E34:E89),E34)","v":0}]
[null,null,null,{"$f":"IF(E35=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E35:E90),E35)","v":0}]
[null,null,null,{"$f":"IF(E36=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E36:E91),E36)","v":0}]
[null,null,null,{"$f":"IF(E37=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E37:E92),E37)","v":0}]
[null,null,null,{"$f":"IF(E38=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E38:E93),E38)","v":0}]
[null,null,null,{"$f":"IF(E39=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E39:E94),E39)","v":0}]
[null,null,null,{"$f":"IF(E40=\"open\",SUMIF($C$3:C$60,\">0\",$C$3:C$60)+SUMIF($C$3:C$60,\"<0\",$C$3:C$60)-SUM(E40:E95),E40)","v":0}]
[null,null,null,{"$f":"IF(E41=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E41:E96),E41)","v":0}]
[null,null,null,{"$f":"IF(E42=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E42:E97),E42)","v":0}]
[null,null,null,{"$f":"IF(E43=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E43:E98),E43)","v":0}]
[null,null,null,{"$f":"IF(E44=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E44:E99),E44)","v":0}]
[null,null,null,{"$f":"IF(E45=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E45:E100),E45)","v":0}]
[null,null,null,{"$f":"IF(E46=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E46:E101),E46)","v":0}]
[null,null,null,{"$f":"IF(E47=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E47:E102),E47)","v":0}]
[null,null,null,{"$f":"IF(E48=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E48:E103),E48)","v":0}]
[null,null,null,{"$f":"IF(E49=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E49:E104),E49)","v":0}]
[null,null,null,{"$f":"IF(E50=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E50:E105),E50)","v":0}]
[null,null,null,{"$f":"IF(E51=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E51:E106),E51)","v":0}]
[null,null,null,{"$f":"IF(E52=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E52:E107),E52)","v":0}]
[null,null,null,{"$f":"IF(E53=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E53:E108),E53)","v":0}]
[null,null,null,{"$f":"IF(E54=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E54:E109),E54)","v":0}]
[null,null,null,{"$f":"IF(E55=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E55:E110),E55)","v":0}]
[null,null,null,{"$f":"IF(E56=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E56:E111),E56)","v":0}]
[null,null,null,{"$f":"IF(E57=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E57:E112),E57)","v":0}]
[null,null,null,{"$f":"IF(E58=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E58:E113),E58)","v":0}]
[null,null,null,{"$f":"IF(E59=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E59:E114),E59)","v":0}]
[null,null,null,{"$f":"IF(E60=\"open\",SUMIF($C$3:C$59,\">0\",$C$3:C$59)+SUMIF($C$3:C$59,\"<0\",$C$3:C$59)-SUM(E60:E115),E60)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C1:C317)","v":0}]

{"sheet":"المطلوب ","index":1,"n_rows":319,"n_cols":8,"rows_kept":319,"cut":false,"hidden":false,"merged":[[10,7,13,10]]}
[null,null,null,{"$f":"SUM(D2:$D70)","v":8607.777},{"$f":"SUM(E2:E69)","v":8607.777},null,{"$f":"D1-E1","v":0}]
["Invoice date","custemar ","Type","original amount ","open amount ","status"]
["2018-04-25",1,"invoice",4345.1149999999998,{"$f":"IF(F3=\"open\",SUMIF($D$3:$D65,\">0\",$D$3:$D67)+SUMIF($D$3:$D67,\"<0\",$D$3:$D67)-SUM(F3:F62),F3)","v":"closed"},"closed"]
["2018-05-24",1,"advance payment ",-116.19199999999999,{"$f":"IF(F4=\"open\",SUMIF($D$3:$D66,\">0\",$D$3:$D68)+SUMIF($D$3:$D68,\"<0\",$D$3:$D68)-SUM(F4:F63),F4)","v":0},0]
["2018-05-25",1,"invoice",566.00599999999997,{"$f":"IF(F5=\"open\",SUMIF($D$3:$D67,\">0\",$D$3:$D69)+SUMIF($D$3:$D69,\"<0\",$D$3:$D69)-SUM(F5:F64),F5)","v":"closed"},"closed"]
["2018-05-29",1,"advance payment ",-20,{"$f":"IF(F6=\"open\",SUMIF($D$3:$D68,\">0\",$D$3:$D70)+SUMIF($D$3:$D70,\"<0\",$D$3:$D70)-SUM(F6:F65),F6)","v":0},0]
["2018-06-25",1,"invoice",554.02700000000004,{"$f":"IF(F7=\"open\",SUMIF($D$3:$D69,\">0\",$D$3:$D71)+SUMIF($D$3:$D71,\"<0\",$D$3:$D71)-SUM(F7:F66),F7)","v":"closed"},"closed"]
["2018-06-27",1,"advance payment ",-566.00599999999997,{"$f":"IF(F8=\"open\",SUMIF($D$3:$D70,\">0\",$D$3:$D72)+SUMIF($D$3:$D72,\"<0\",$D$3:$D72)-SUM(F8:F67),F8)","v":0},0]
["2018-07-24",1,"advance payment ",-554.02700000000004,{"$f":"IF(F9=\"open\",SUMIF($D$3:$D71,\">0\",$D$3:$D73)+SUMIF($D$3:$D73,\"<0\",$D$3:$D73)-SUM(F9:F68),F9)","v":0},0]
["2018-07-25",2,"invoice",628.25199999999995,{"$f":"IF(F10=\"open\",SUMIF($D$3:$D72,\">0\",$D$3:$D74)+SUMIF($D$3:$D74,\"<0\",$D$3:$D74)-SUM(F10:F69),F10)","v":"closed"},"closed"]
["2018-08-25",2,"invoice",610.94100000000003,{"$f":"IF(F11=\"open\",SUMIF($D$3:$D73,\">0\",$D$3:$D75)+SUMIF($D$3:$D75,\"<0\",$D$3:$D75)-SUM(F11:F70),F11)","v":"closed"},"closed",null,"السلام عليكم  لدى كود يعمل على سداد القواتير وارغب ان يعمل الكود على حسب رقم العميل بحيث انة يتم سداد الفاتورة طبقا للمورد"]
["2018-08-29",2,"advance payment ",-628.25199999999995,{"$f":"IF(F12=\"open\",SUMIF($D$3:$D74,\">0\",$D$3:$D76)+SUMIF($D$3:$D76,\"<0\",$D$3:$D76)-SUM(F12:F71),F12)","v":0},0]
["2018-09-25",2,"advance payment ",-610.94100000000003,{"$f":"IF(F13=\"open\",SUMIF($D$3:$D75,\">0\",$D$3:$D77)+SUMIF($D$3:$D77,\"<0\",$D$3:$D77)-SUM(F13:F72),F13)","v":0},0]
["2018-09-25",1,"invoice",606.02700000000004,{"$f":"IF(F14=\"open\",SUMIF($D$3:$D76,\">0\",$D$3:$D78)+SUMIF($D$3:$D78,\"<0\",$D$3:$D78)-SUM(F14:F73),F14)","v":"closed"},"closed"]
["2018-10-25",1,"invoice",644.00800000000004,{"$f":"IF(F15=\"open\",SUMIF($D$3:$D77,\">0\",$D$3:$D79)+SUMIF($D$3:$D79,\"<0\",$D$3:$D79)-SUM(F15:F74),F15)","v":"closed"},"closed"]
["2018-10-29",1,"advance payment ",-606.02700000000004,{"$f":"IF(F16=\"open\",SUMIF($D$3:$D78,\">0\",$D$3:$D80)+SUMIF($D$3:$D80,\"<0\",$D$3:$D80)-SUM(F16:F75),F16)","v":0},0]
["2018-11-25",2,"invoice",619.58600000000001,{"$f":"IF(F17=\"open\",SUMIF($D$3:$D79,\">0\",$D$3:$D81)+SUMIF($D$3:$D81,\"<0\",$D$3:$D81)-SUM(F17:F76),F17)","v":"closed"},"closed"]
["2018-11-29",2,"advance payment ",-644.00800000000004,{"$f":"IF(F18=\"open\",SUMIF($D$3:$D80,\">0\",$D$3:$D82)+SUMIF($D$3:$D82,\"<0\",$D$3:$D82)-SUM(F18:F77),F18)","v":0},0]
["2018-12-25",2,"invoice",625.86,{"$f":"IF(F19=\"open\",SUMIF($D$3:$D81,\">0\",$D$3:$D83)+SUMIF($D$3:$D83,\"<0\",$D$3:$D83)-SUM(F19:F78),F19)","v":"closed"},"closed"]
["2018-12-30",2,"advance payment ",-619.58600000000001,{"$f":"IF(F20=\"open\",SUMIF($D$3:$D82,\">0\",$D$3:$D84)+SUMIF($D$3:$D84,\"<0\",$D$3:$D84)-SUM(F20:F79),F20)","v":0},0]
["2019-01-25",3,"invoice",652.60799999999995,{"$f":"IF(F21=\"open\",SUMIF($D$3:$D83,\">0\",$D$3:$D85)+SUMIF($D$3:$D85,\"<0\",$D$3:$D85)-SUM(F21:F80),F21)","v":"closed"},"closed"]
["2019-01-27",3,"advance payment ",-97.179000000000002,{"$f":"IF(F22=\"open\",SUMIF($D$3:$D84,\">0\",$D$3:$D86)+SUMIF($D$3:$D86,\"<0\",$D$3:$D86)-SUM(F22:F81),F22)","v":0},0]
["2019-01-30",3,"advance payment ",-625.86,{"$f":"IF(F23=\"open\",SUMIF($D$3:$D85,\">0\",$D$3:$D87)+SUMIF($D$3:$D87,\"<0\",$D$3:$D87)-SUM(F23:F82),F23)","v":0},0]
["2019-02-25",null,"invoice",694.51800000000003,{"$f":"IF(F24=\"open\",SUMIF($D$3:$D86,\">0\",$D$3:$D88)+SUMIF($D$3:$D88,\"<0\",$D$3:$D88)-SUM(F24:F83),F24)","v":"closed"},"closed"]
["2019-03-25",null,"invoice",1745.1510000000001,{"$f":"IF(F25=\"open\",SUMIF($D$3:$D87,\">0\",$D$3:$D89)+SUMIF($D$3:$D89,\"<0\",$D$3:$D89)-SUM(F25:F84),F25)","v":"closed"},"closed"]
["2019-04-02",null,"advance payment ",-652.60799999999995,{"$f":"IF(F26=\"open\",SUMIF($D$3:$D88,\">0\",$D$3:$D90)+SUMIF($D$3:$D90,\"<0\",$D$3:$D90)-SUM(F26:F85),F26)","v":0},0]
["2019-04-23",null,"advance payment ",-538.89,{"$f":"IF(F27=\"open\",SUMIF($D$3:$D89,\">0\",$D$3:$D91)+SUMIF($D$3:$D91,\"<0\",$D$3:$D91)-SUM(F27:F86),F27)","v":0},0]
["2019-04-25",null,"invoice",787.83299999999997,{"$f":"IF(F28=\"open\",SUMIF($D$3:$D90,\">0\",$D$3:$D92)+SUMIF($D$3:$D92,\"<0\",$D$3:$D92)-SUM(F28:F87),F28)","v":"closed"},"closed"]
["2019-05-19",null,"advance payment ",-694.51800000000003,{"$f":"IF(F29=\"open\",SUMIF($D$3:$D91,\">0\",$D$3:$D93)+SUMIF($D$3:$D93,\"<0\",$D$3:$D93)-SUM(F29:F88),F29)","v":0},0]
["2019-05-25",null,"invoice",876.56799999999998,{"$f":"IF(F30=\"open\",SUMIF($D$3:$D92,\">0\",$D$3:$D94)+SUMIF($D$3:$D94,\"<0\",$D$3:$D94)-SUM(F30:F89),F30)","v":"closed"},"closed"]
["2019-06-25",null,"advance payment ",-3465.7939999999999,{"$f":"IF(F31=\"open\",SUMIF($D$3:$D93,\">0\",$D$3:$D95)+SUMIF($D$3:$D95,\"<0\",$D$3:$D95)-SUM(F31:F90),F31)","v":0},0]
["2019-07-23",null,"advance payment ",-52,{"$f":"IF(F32=\"open\",SUMIF($D$3:$D94,\">0\",$D$3:$D96)+SUMIF($D$3:$D96,\"<0\",$D$3:$D96)-SUM(F32:F91),F32)","v":0},0]
["2019-07-25",null,"invoice",797.60799999999995,{"$f":"IF(F33=\"open\",SUMIF($D$3:$D95,\">0\",$D$3:$D97)+SUMIF($D$3:$D97,\"<0\",$D$3:$D97)-SUM(F33:F92),F33)","v":"closed"},"closed"]
["2019-08-25",null,"invoice",725.23400000000004,{"$f":"IF(F34=\"open\",SUMIF($D$3:$D96,\">0\",$D$3:$D98)+SUMIF($D$3:$D98,\"<0\",$D$3:$D98)-SUM(F34:F93),F34)","v":"closed"},"closed"]
["2019-09-25",null,"invoice",868.54399999999998,{"$f":"IF(F35=\"open\",SUMIF($D$3:$D97,\">0\",$D$3:$D99)+SUMIF($D$3:$D99,\"<0\",$D$3:$D99)-SUM(F35:F94),F35)","v":"closed"},"closed"]
["2019-10-27",null,"invoice",835.68700000000001,{"$f":"IF(F36=\"open\",SUMIF($D$3:$D98,\">0\",$D$3:$D100)+SUMIF($D$3:$D100,\"<0\",$D$3:$D100)-SUM(F36:F95),F36)","v":"closed"},"closed"]
["2019-10-29",null,"advance payment ",-850,{"$f":"IF(F37=\"open\",SUMIF($D$3:$D99,\">0\",$D$3:$D101)+SUMIF($D$3:$D101,\"<0\",$D$3:$D101)-SUM(F37:F96),F37)","v":0},0]
["2019-11-25",null,"invoice",758.94799999999998,{"$f":"IF(F38=\"open\",SUMIF($D$3:$D100,\">0\",$D$3:$D102)+SUMIF($D$3:$D102,\"<0\",$D$3:$D102)-SUM(F38:F97),F38)","v":"closed"},"closed"]
["2019-12-25",null,"invoice",762.39499999999998,{"$f":"IF(F39=\"open\",SUMIF($D$3:$D101,\">0\",$D$3:$D103)+SUMIF($D$3:$D103,\"<0\",$D$3:$D103)-SUM(F39:F98),F39)","v":"closed"},"closed"]
["2020-01-25",null,"invoice",677.38499999999999,{"$f":"IF(F40=\"open\",SUMIF($D$3:$D102,\">0\",$D$3:$D104)+SUMIF($D$3:$D104,\"<0\",$D$3:$D104)-SUM(F40:F99),F40)","v":"closed"},"closed"]
["2020-02-05",null,"advance payment ",-146.4,{"$f":"IF(F41=\"open\",SUMIF($D$3:$D103,\">0\",$D$3:$D105)+SUMIF($D$3:$D105,\"<0\",$D$3:$D105)-SUM(F41:F100),F41)","v":0},0]
["2020-02-24",null,"advance payment ",-1500,{"$f":"IF(F42=\"open\",SUMIF($D$3:$D104,\">0\",$D$3:$D106)+SUMIF($D$3:$D106,\"<0\",$D$3:$D106)-SUM(F42:F101),F42)","v":0},0]
["2020-02-25",null,"invoice",762.63,{"$f":"IF(F43=\"open\",SUMIF($D$3:$D105,\">0\",$D$3:$D107)+SUMIF($D$3:$D107,\"<0\",$D$3:$D107)-SUM(F43:F102),F43)","v":"closed"},"closed"]
["2020-03-25",null,"invoice",724.06200000000001,{"$f":"IF(F44=\"open\",SUMIF($D$3:$D106,\">0\",$D$3:$D108)+SUMIF($D$3:$D108,\"<0\",$D$3:$D108)-SUM(F44:F103),F44)","v":"closed"},"closed"]
["2020-04-25",null,"invoice",709.875,{"$f":"IF(F45=\"open\",SUMIF($D$3:$D107,\">0\",$D$3:$D109)+SUMIF($D$3:$D109,\"<0\",$D$3:$D109)-SUM(F45:F104),F45)","v":"closed"},"closed"]
["2020-05-25",null,"invoice",838.54200000000003,{"$f":"IF(F46=\"open\",SUMIF($D$3:$D108,\">0\",$D$3:$D110)+SUMIF($D$3:$D110,\"<0\",$D$3:$D110)-SUM(F46:F105),F46)","v":"closed"},"closed"]
["2020-06-25",null,"invoice",732.29,{"$f":"IF(F47=\"open\",SUMIF($D$3:$D109,\">0\",$D$3:$D111)+SUMIF($D$3:$D111,\"<0\",$D$3:$D111)-SUM(F47:F106),F47)","v":"closed"},"closed"]
["2020-07-25",null,"invoice",670.73699999999997,{"$f":"IF(F48=\"open\",SUMIF($D$3:$D110,\">0\",$D$3:$D112)+SUMIF($D$3:$D112,\"<0\",$D$3:$D112)-SUM(F48:F107),F48)","v":"closed"},"closed"]
["2020-07-29",null,"advance payment ",-1500,{"$f":"IF(F49=\"open\",SUMIF($D$3:$D111,\">0\",$D$3:$D113)+SUMIF($D$3:$D113,\"<0\",$D$3:$D113)-SUM(F49:F108),F49)","v":0},0]
["2020-08-25",null,"invoice",638.35,{"$f":"IF(F50=\"open\",SUMIF($D$3:$D112,\">0\",$D$3:$D114)+SUMIF($D$3:$D114,\"<0\",$D$3:$D114)-SUM(F50:F109),F50)","v":70.498999999999796},"open"]
["2020-09-25",null,"invoice",647.89700000000005,{"$f":"IF(F51=\"open\",SUMIF($D$3:$D113,\">0\",$D$3:$D115)+SUMIF($D$3:$D115,\"<0\",$D$3:$D115)-SUM(F51:F110),F51)","v":647.89700000000005},647.89700000000005]
["2020-10-25",null,"invoice",656.24699999999996,{"$f":"IF(F52=\"open\",SUMIF($D$3:$D114,\">0\",$D$3:$D116)+SUMIF($D$3:$D116,\"<0\",$D$3:$D116)-SUM(F52:F111),F52)","v":656.24699999999996},656.24699999999996]
["2020-11-25",null,"invoice",669.553,{"$f":"IF(F53=\"open\",SUMIF($D$3:$D115,\">0\",$D$3:$D117)+SUMIF($D$3:$D117,\"<0\",$D$3:$D117)-SUM(F53:F112),F53)","v":669.553},669.553]
["2020-12-13",null,"advance payment ",-3000,{"$f":"IF(F54=\"open\",SUMIF($D$3:$D116,\">0\",$D$3:$D118)+SUMIF($D$3:$D118,\"<0\",$D$3:$D118)-SUM(F54:F113),F54)","v":0},0]
["2020-12-25",null,"invoice",623.67200000000003,{"$f":"IF(F55=\"open\",SUMIF($D$3:$D117,\">0\",$D$3:$D119)+SUMIF($D$3:$D119,\"<0\",$D$3:$D119)-SUM(F55:F114),F55)","v":623.67200000000003},623.67200000000003]
["2021-01-25",null,"invoice",602.21500000000003,{"$f":"IF(F56=\"open\",SUMIF($D$3:$D118,\">0\",$D$3:$D120)+SUMIF($D$3:$D120,\"<0\",$D$3:$D120)-SUM(F56:F115),F56)","v":602.21500000000003},602.21500000000003]
["2021-02-02",null,"advance payment ",-1500,{"$f":"IF(F57=\"open\",SUMIF($D$3:$D119,\">0\",$D$3:$D121)+SUMIF($D$3:$D121,\"<0\",$D$3:$D121)-SUM(F57:F116),F57)","v":0},0]
["2021-02-25",null,"invoice",638.75800000000004,{"$f":"IF(F58=\"open\",SUMIF($D$3:$D120,\">0\",$D$3:$D122)+SUMIF($D$3:$D122,\"<0\",$D$3:$D122)-SUM(F58:F117),F58)","v":638.75800000000004},638.75800000000004]
["2021-03-25",null,"invoice",609.75599999999997,{"$f":"IF(F59=\"open\",SUMIF($D$3:$D121,\">0\",$D$3:$D123)+SUMIF($D$3:$D123,\"<0\",$D$3:$D123)-SUM(F59:F118),F59)","v":609.75599999999997},609.75599999999997]
["2021-04-25",null,"invoice",602.01300000000003,{"$f":"IF(F60=\"open\",SUMIF($D$3:$D122,\">0\",$D$3:$D124)+SUMIF($D$3:$D124,\"<0\",$D$3:$D124)-SUM(F60:F119),F60)","v":602.01300000000003},602.01300000000003]
["2021-05-25",null,"invoice",573.37099999999998,{"$f":"IF(F61=\"open\",SUMIF($D$3:$D123,\">0\",$D$3:$D125)+SUMIF($D$3:$D125,\"<0\",$D$3:$D125)-SUM(F61:F120),F61)","v":573.37099999999998},573.37099999999998]
["2021-05-30",null,"advance payment ",-1000,{"$f":"IF(F62=\"open\",SUMIF($D$3:$D124,\">0\",$D$3:$D126)+SUMIF($D$3:$D126,\"<0\",$D$3:$D126)-SUM(F62:F121),F62)","v":0},0]
["2021-06-25",null,"invoice",580.81799999999998,{"$f":"IF(F63=\"open\",SUMIF($D$3:$D125,\">0\",$D$3:$D127)+SUMIF($D$3:$D127,\"<0\",$D$3:$D127)-SUM(F63:F122),F63)","v":580.81799999999998},580.81799999999998]
["2021-07-26",null,"advance payment ",-1200,{"$f":"IF(F64=\"open\",SUMIF($D$3:$D126,\">0\",$D$3:$D128)+SUMIF($D$3:$D128,\"<0\",$D$3:$D128)-SUM(F64:F123),F64)","v":0},0]
["2021-07-25",null,"invoice",550.23500000000001,{"$f":"IF(F65=\"open\",SUMIF($D$3:$D127,\">0\",$D$3:$D129)+SUMIF($D$3:$D129,\"<0\",$D$3:$D129)-SUM(F65:F124),F65)","v":550.23500000000001},550.23500000000001]
["2021-08-25",null,"invoice 485837082021",586.69899999999996,{"$f":"IF(F66=\"open\",SUMIF($D$3:$D128,\">0\",$D$3:$D130)+SUMIF($D$3:$D130,\"<0\",$D$3:$D130)-SUM(F66:F125),F66)","v":586.69899999999996},586.69899999999996]
["2021-09-07",null,"advance payment  5584",-1200,{"$f":"IF(F67=\"open\",SUMIF($D$3:$D129,\">0\",$D$3:$D131)+SUMIF($D$3:$D131,\"<0\",$D$3:$D131)-SUM(F67:F126),F67)","v":0},0]
["2021-09-25",null,"invoice 487958092021",610.39400000000001,{"$f":"IF(F68=\"open\",SUMIF($D$3:$D130,\">0\",$D$3:$D132)+SUMIF($D$3:$D132,\"<0\",$D$3:$D132)-SUM(F68:F127),F68)","v":610.39400000000001},610.39400000000001]
["2021-10-25",null,"invoice",585.65,{"$f":"IF(F69=\"open\",SUMIF($D$3:$D131,\">0\",$D$3:$D133)+SUMIF($D$3:$D133,\"<0\",$D$3:$D133)-SUM(F69:F128),F69)","v":585.65},585.65]
["2021-11-25",null,"advance payment  5584",-2000,{"$f":"IF(F70=\"open\",SUMIF($D$3:$D132,\">0\",$D$3:$D134)+SUMIF($D$3:$D134,\"<0\",$D$3:$D134)-SUM(F70:F129),F70)","v":0},0]
["2021-11-25",null,"invoice",578.61,{"$f":"IF(F71=\"open\",SUMIF($D$3:$D133,\">0\",$D$3:$D135)+SUMIF($D$3:$D135,\"<0\",$D$3:$D135)-SUM(F71:F130),F71)","v":578.61},578.61]
["2021-12-25",null,"invoice",580.93499999999995,{"$f":"IF(F72=\"open\",SUMIF($D$3:$D134,\">0\",$D$3:$D136)+SUMIF($D$3:$D136,\"<0\",$D$3:$D136)-SUM(F72:F131),F72)","v":580.93499999999995},580.93499999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(D1:D318)","v":18375.099000000006}]