{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["סיכום תשלומים","יומן תשלומים"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"סיכום תשלומים","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,3],[0,4,0,10]]}
[null,"סיכום תשלומים",null,null,"שנה את שמות הקטגוריות בכותרת הטבלה 'סיכום תשלומים' שלהלן כדי להתאים תבנית זו לצרכיך. אם עליך להוסיף קטגוריות נוספות, העתק את העמודה האחרונה בטבלה והדבק אותה משמאל לעמודה שהועתקה. כשתשנה את שם הקטגוריה, הנוסחאות יתעדכנו באופן אוטומטי. ודא שטבלה זו מכילה את אותו מספר שורות כמו בגליון עבודה 'יומן תשלומים'."]
[null,"תאריך","ביטוח רכב","ציוד משרדי","חשמל","משכנתה","טלפון","ריק 1","ריק 2","ריק 3","ריק 4"]
[null,{"$f":"IFERROR(INDEX(רישום[],ROW(A1),1),\"\")","v":"2018-04-05"},{"$f":"IFERROR(INDIRECT(\"רישום[@סכום]\")*(INDIRECT(\"רישום[@קטגוריה]\")=CategoryName),\"\")","v":0},0,0,{"v":1200,"d":"₪ 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(רישום[],ROW(A2),1),\"\")","v":"2018-04-10"},0,0,{"v":85,"d":"₪ 85.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(רישום[],ROW(A3),1),\"\")","v":"2018-04-15"},{"v":100,"d":"₪ 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(רישום[],ROW(A4),1),\"\")","v":"2018-04-20"},0,0,0,{"v":1200,"d":"₪ 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(רישום[],ROW(A5),1),\"\")","v":"2018-04-25"},0,0,0,{"v":99,"d":"₪ 99.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(רישום[],ROW(A6),1),\"\")","v":"2018-04-30"},0,0,0,0,{"v":68,"d":"₪ 68.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(רישום[],ROW(A7),1),\"\")","v":"2018-05-05"},{"v":100,"d":"₪ 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(רישום[],ROW(A8),1),\"\")","v":"2018-05-10"},0,{"v":345,"d":"₪ 345.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(רישום[],ROW(A9),1),\"\")","v":"2018-05-15"},0,0,0,{"v":1200,"d":"₪ 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(רישום[],ROW(A10),1),\"\")","v":"2018-05-20"},0,0,{"v":74,"d":"₪ 74.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(רישום[],ROW(A11),1),\"\")","v":"2018-05-25"},0,0,0,0,{"v":123,"d":"₪ 123.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(רישום[],ROW(A12),1),\"\")","v":"2018-05-30"},0,{"v":99,"d":"₪ 99.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(רישום[],ROW(A13),1),\"\")","v":"2018-06-04"},{"v":100,"d":"₪ 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(רישום[],ROW(A14),1),\"\")","v":"2018-06-09"},0,0,0,{"v":1200,"d":"₪ 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(רישום[],ROW(A15),1),\"\")","v":"2018-06-14"},0,{"v":128,"d":"₪ 128.00"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,DisbursementSummary[ביטוח רכב])","v":{"v":300,"d":"₪ 300.00"}},{"$f":"SUBTOTAL(109,DisbursementSummary[ציוד משרדי])","v":{"v":572,"d":"₪ 572.00"}},{"$f":"SUBTOTAL(109,DisbursementSummary[חשמל])","v":{"v":159,"d":"₪ 159.00"}},{"$f":"SUBTOTAL(109,DisbursementSummary[משכנתה])","v":{"v":4899,"d":"₪ 4,899.00"}},{"$f":"SUBTOTAL(109,DisbursementSummary[טלפון])","v":{"v":191,"d":"₪ 191.00"}},{"$f":"SUBTOTAL(109,DisbursementSummary[ריק 1])","v":0},{"$f":"SUBTOTAL(109,DisbursementSummary[ריק 2])","v":0},{"$f":"SUBTOTAL(109,DisbursementSummary[ריק 3])","v":0},{"$f":"SUBTOTAL(109,DisbursementSummary[ריק 4])","v":0}]

{"sheet":"יומן תשלומים","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,3]]}
[null,"יומן תשלומים"]
[null,"תאריך","מספר","תיאור","קטגוריה","סכום"]
[null,{"$f":"TODAY()-70","v":"2018-04-05"},"100","Woodgrove Bank","משכנתה",{"v":1200,"d":"₪ 1,200.00"}]
[null,{"$f":"TODAY()-65","v":"2018-04-10"},101,"חשבון חשמל","חשמל",{"v":85,"d":"₪ 85.00"}]
[null,{"$f":"TODAY()-60","v":"2018-04-15"},102,"Humongous Insurance","ביטוח רכב",{"v":100,"d":"₪ 100.00"}]
[null,{"$f":"TODAY()-55","v":"2018-04-20"},103,"Woodgrove Bank","משכנתה",{"v":1200,"d":"₪ 1,200.00"}]
[null,{"$f":"TODAY()-50","v":"2018-04-25"},104,"חשבון חשמל","משכנתה",{"v":99,"d":"₪ 99.00"}]
[null,{"$f":"TODAY()-45","v":"2018-04-30"},105,"חברת טלפון","טלפון",{"v":68,"d":"₪ 68.00"}]
[null,{"$f":"TODAY()-40","v":"2018-05-05"},106,"Humongous Insurance","ביטוח רכב",{"v":100,"d":"₪ 100.00"}]
[null,{"$f":"TODAY()-35","v":"2018-05-10"},107,"Litware, Inc.‎","ציוד משרדי",{"v":345,"d":"₪ 345.00"}]
[null,{"$f":"TODAY()-30","v":"2018-05-15"},110,"Woodgrove Bank","משכנתה",{"v":1200,"d":"₪ 1,200.00"}]
[null,{"$f":"TODAY()-25","v":"2018-05-20"},111,"חשבון חשמל","חשמל",{"v":74,"d":"₪ 74.00"}]
[null,{"$f":"TODAY()-20","v":"2018-05-25"},108,"חברת טלפון","טלפון",{"v":123,"d":"₪ 123.00"}]
[null,{"$f":"TODAY()-15","v":"2018-05-30"},109,"Litware, Inc.‎","ציוד משרדי",{"v":99,"d":"₪ 99.00"}]
[null,{"$f":"TODAY()-10","v":"2018-06-04"},112,"Humongous Insurance","ביטוח רכב",{"v":100,"d":"₪ 100.00"}]
[null,{"$f":"TODAY()-5","v":"2018-06-09"},113,"Woodgrove Bank","משכנתה",{"v":1200,"d":"₪ 1,200.00"}]
[null,{"$f":"TODAY()","v":"2018-06-14"},114,"Litware, Inc.‎","ציוד משרדי",{"v":128,"d":"₪ 128.00"}]
[null,"סכומים כוללים",{"$nulls":3},{"$f":"SUBTOTAL(109,רישום[סכום])","v":{"v":6121,"d":"₪ 6,121.00"}}]