{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["الودائع","المسحوبات"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"الودائع","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,3,2]]}
[null,"شهري\nبنك\nبيان",null,"الشهر","الرصيد السابق","إجمالي الودائع"]
[{"$nulls":3},{"$f":"UPPER(TEXT(TODAY(),\"mmmm\"))","v":"مايو"},{"v":2525.54,"d":"ر.س.‏ 2,525.54"},{"$f":"Deposit_total","v":{"v":5400,"d":"ر.س.‏ 5,400.00"}}]
[{"$nulls":3},"السنة","الرصيد النهائي","إجمالي المسحوبات"]
[{"$nulls":3},{"$f":"YEAR(TODAY())","v":2018},{"$f":"IFERROR(الرصيد_النهائي+Deposit_total-Withdrawls_total, \"\")","v":{"v":6550.54,"d":"ر.س.‏ 6,550.54"}},{"$f":"Withdrawls_total","v":{"v":1375,"d":"ر.س.‏ 1,375.00"}}]
[null,"الودائع"]
[null,"رقم الإيداع","التاريخ","المبلغ","الوصف","التسوية"]
[null,{"$f":"ROW()-ROW(الودائع[[#Headers],[رقم الإيداع]])","v":1},{"$f":"TODAY()-15","v":"2018-05-01"},{"v":1500,"d":"ر.س.‏ 1,500.00"},"مهمة 1، الشيك 1","نعم"]
[null,{"$f":"ROW()-ROW(الودائع[[#Headers],[رقم الإيداع]])","v":2},{"$f":"TODAY()-10","v":"2018-05-06"},{"v":1200,"d":"ر.س.‏ 1,200.00"},"مهمة 2، الشيك 1","نعم"]
[null,{"$f":"ROW()-ROW(الودائع[[#Headers],[رقم الإيداع]])","v":3},{"$f":"TODAY()-5","v":"2018-05-11"},{"v":1500,"d":"ر.س.‏ 1,500.00"},"مهمة 1، الشيك 2","نعم"]
[null,{"$f":"ROW()-ROW(الودائع[[#Headers],[رقم الإيداع]])","v":4},{"$f":"TODAY()","v":"2018-05-16"},{"v":1200,"d":"ر.س.‏ 1,200.00"},"مهمة 2، الشيك 2","نعم"]
[null,"الإجمالي",null,{"$f":"SUBTOTAL(109,الودائع[المبلغ])","v":{"v":5400,"d":"ر.س.‏ 5,400.00"}}]

{"sheet":"المسحوبات","index":1,"n_rows":8,"n_cols":6,"rows_kept":8}
[null,"المسحوبات"]
[null,"النوع","التاريخ","المبلغ","الغرض","التسوية"]
[null,"شيك رقم 1001",{"$f":"TODAY()-8","v":"2018-05-08"},{"v":150,"d":"ر.س.‏ 150.00"},"كهرباء","نعم"]
[null,"شيك رقم 1002",{"$f":"TODAY()-6","v":"2018-05-10"},{"v":150,"d":"ر.س.‏ 150.00"},"مياه/صرف/مهملات","نعم"]
[null,"شيك رقم 1003",{"$f":"TODAY()-4","v":"2018-05-12"},{"v":850,"d":"ر.س.‏ 850.00"},"رهن","نعم"]
[null,"خصم",{"$f":"TODAY()-2","v":"2018-05-14"},{"v":125,"d":"ر.س.‏ 125.00"},"بقالة","نعم"]
[null,"ماكينة الصرّاف الآلي",{"$f":"TODAY()","v":"2018-05-16"},{"v":100,"d":"ر.س.‏ 100.00"},"نقدية","نعم"]
[null,"الإجمالي",null,{"$f":"SUBTOTAL(109,الشيكات[المبلغ])","v":{"v":1375,"d":"ر.س.‏ 1,375.00"}}]