{"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(EndingBalance+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-02"},{"v":1500,"d":"₪ 1,500.00"},"עבודה 1, המחאה 1","כן"]
[null,{"$f":"ROW()-ROW(הפקדות[[#Headers],[מס'' הפקדה]])","v":2},{"$f":"TODAY()-10","v":"2018-05-07"},{"v":1200,"d":"₪ 1,200.00"},"עבודה 2, המחאה 1","כן"]
[null,{"$f":"ROW()-ROW(הפקדות[[#Headers],[מס'' הפקדה]])","v":3},{"$f":"TODAY()-5","v":"2018-05-12"},{"v":1500,"d":"₪ 1,500.00"},"עבודה 1, המחאה 2","כן"]
[null,{"$f":"ROW()-ROW(הפקדות[[#Headers],[מס'' הפקדה]])","v":4},{"$f":"TODAY()","v":"2018-05-17"},{"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-09"},{"v":150,"d":"₪ 150.00"},"חשמל","כן"]
[null,"המחאה 1002",{"$f":"TODAY()-6","v":"2018-05-11"},{"v":150,"d":"₪ 150.00"},"מים/ארנונה","כן"]
[null,"המחאה 1003",{"$f":"TODAY()-4","v":"2018-05-13"},{"v":850,"d":"₪ 850.00"},"משכנתה","כן"]
[null,"חיוב",{"$f":"TODAY()-2","v":"2018-05-15"},{"v":125,"d":"₪ 125.00"},"מצרכים","כן"]
[null,"ATM",{"$f":"TODAY()","v":"2018-05-17"},{"v":100,"d":"₪ 100.00"},"מזומנים","כן"]
[null,"סך הכל",null,{"$f":"SUBTOTAL(109,המחאות[סכום])","v":{"v":1375,"d":"₪ 1,375.00"}}]