{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["متعقب الفاتورة"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"متعقب الفاتورة","index":0,"n_rows":9,"n_cols":10,"rows_kept":9}
[null,"متعقب الفاتورة"]
[null,"الفاتورة رقم #","التاريخ","استحقاق الدفعة","اسم العميل","المبلغ ","رسوم تأخير ","الإجمالي المدفوع","تاريخ الدفع","المستحق"]
[null,1001,{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2022-01-15"},{"$f":"DATE(YEAR(TODAY()),2,15)","v":"2022-02-15"},"جميل زاهر",{"v":20199,"d":"ر.س.‏ 20,199.00"},{"$f":"IFERROR(IF(فواتير[[#This Row],[استحقاق الدفعة]]>=فواتير[[#This Row],[تاريخ الدفع]],,5), \"\")","v":0},{"v":20199,"d":"ر.س.‏ 20,199.00"},{"$f":"DATE(YEAR(TODAY()),2,1)","v":"2022-02-01"},{"$f":"IFERROR(فواتير[[#This Row],[المبلغ ]]-فواتير[[#This Row],[الإجمالي المدفوع]]+فواتير[[#This Row],[رسوم تأخير ]], \"\")","v":0}]
[null,1002,{"$f":"DATE(YEAR(TODAY()),2,11)","v":"2022-02-11"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2022-04-01"},"جميل زاهر",{"v":15700,"d":"ر.س.‏ 15,700.00"},{"$f":"IFERROR(IF(فواتير[[#This Row],[استحقاق الدفعة]]>=فواتير[[#This Row],[تاريخ الدفع]],,5), \"\")","v":{"v":5,"d":"ر.س.‏ 5.00"}},{"v":7500,"d":"ر.س.‏ 7,500.00"},{"$f":"DATE(YEAR(TODAY()),4,10)","v":"2022-04-10"},{"$f":"IFERROR(فواتير[[#This Row],[المبلغ ]]-فواتير[[#This Row],[الإجمالي المدفوع]]+فواتير[[#This Row],[رسوم تأخير ]], \"\")","v":{"v":8205,"d":"ر.س.‏ 8,205.00"}}]
[null,1003,{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2022-02-17"},{"$f":"DATE(YEAR(TODAY()),4,15)","v":"2022-04-15"},"Contoso",{"v":13799,"d":"ر.س.‏ 13,799.00"},{"$f":"IFERROR(IF(فواتير[[#This Row],[استحقاق الدفعة]]>=فواتير[[#This Row],[تاريخ الدفع]],,5), \"\")","v":0},{"v":5500,"d":"ر.س.‏ 5,500.00"},{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2022-03-17"},{"$f":"IFERROR(فواتير[[#This Row],[المبلغ ]]-فواتير[[#This Row],[الإجمالي المدفوع]]+فواتير[[#This Row],[رسوم تأخير ]], \"\")","v":{"v":8299,"d":"ر.س.‏ 8,299.00"}}]
[null,1004,{"$f":"DATE(YEAR(TODAY()),3,8)","v":"2022-03-08"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2022-04-01"},"رجب قريشي",{"v":120,"d":"ر.س.‏ 120.00"},{"$f":"IFERROR(IF(فواتير[[#This Row],[استحقاق الدفعة]]>=فواتير[[#This Row],[تاريخ الدفع]],,5), \"\")","v":{"v":5,"d":"ر.س.‏ 5.00"}},{"v":75,"d":"ر.س.‏ 75.00"},{"$f":"DATE(YEAR(TODAY()),4,16)","v":"2022-04-16"},{"$f":"IFERROR(فواتير[[#This Row],[المبلغ ]]-فواتير[[#This Row],[الإجمالي المدفوع]]+فواتير[[#This Row],[رسوم تأخير ]], \"\")","v":{"v":50,"d":"ر.س.‏ 50.00"}}]
[null,1005,{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2022-03-17"},{"$f":"DATE(YEAR(TODAY()),4,30)","v":"2022-04-30"},"Contoso",{"v":150,"d":"ر.س.‏ 150.00"},{"$f":"IFERROR(IF(فواتير[[#This Row],[استحقاق الدفعة]]>=فواتير[[#This Row],[تاريخ الدفع]],,5), \"\")","v":0},{"v":75,"d":"ر.س.‏ 75.00"},{"$f":"DATE(YEAR(TODAY()),4,11)","v":"2022-04-11"},{"$f":"IFERROR(فواتير[[#This Row],[المبلغ ]]-فواتير[[#This Row],[الإجمالي المدفوع]]+فواتير[[#This Row],[رسوم تأخير ]], \"\")","v":{"v":75,"d":"ر.س.‏ 75.00"}}]
[null,1006,{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2022-04-01"},{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2022-06-01"},"ماجدة كنعان",{"v":1475,"d":"ر.س.‏ 1,475.00"},{"$f":"IFERROR(IF(فواتير[[#This Row],[استحقاق الدفعة]]>=فواتير[[#This Row],[تاريخ الدفع]],,5), \"\")","v":0},{"v":1200,"d":"ر.س.‏ 1,200.00"},{"$f":"DATE(YEAR(TODAY()),4,28)","v":"2022-04-28"},{"$f":"IFERROR(فواتير[[#This Row],[المبلغ ]]-فواتير[[#This Row],[الإجمالي المدفوع]]+فواتير[[#This Row],[رسوم تأخير ]], \"\")","v":{"v":275,"d":"ر.س.‏ 275.00"}}]
[null,"الإجمالي",{"$nulls":3},{"$f":"SUBTOTAL(109,فواتير[[المبلغ ]])","v":{"v":51443,"d":"ر.س.‏ 51,443.00"}},null,{"$f":"SUBTOTAL(109,فواتير[الإجمالي المدفوع])","v":{"v":34549,"d":"ر.س.‏ 34,549.00"}},null,{"$f":"SUBTOTAL(109,فواتير[المستحق])","v":{"v":16904,"d":"ر.س.‏ 16,904.00"}}]