{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["מעקב אחר תיקון כלי רכב"],"not_rendered":{"images":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"מעקב אחר תיקון כלי רכב","index":0,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"מעקב אחר תיקון כלי רכב"]
[null,"סכום כולל",{"$f":"IFERROR(SUM(תיקונים[סכום]), \"\")","v":{"v":4751.509999999999,"d":"₪ 4,751.51"}}]
[null,"סכום כולל עבור רכב 1",{"$f":"IFERROR(SUMIFS(תיקונים[סכום],תיקונים[רכב],שם_רכב_1), \"\")","v":{"v":4032.11,"d":"₪ 4,032.11"}},{"$f":" \"ערך \"&שם_רכב_1","v":"ערך רכב 1"},{"v":14000,"d":"₪ 14,000.00"},{"$f":"שם_רכב_1","v":"רכב 1"}]
[null,"סכום כולל עבור רכב 2",{"$f":"IFERROR(SUMIFS(תיקונים[סכום],תיקונים[רכב],שם_רכב_2), \"\")","v":{"v":719.4,"d":"₪ 719.40"}},{"$f":" \"ערך \"&שם_רכב_2","v":"ערך רכב 2"},{"v":7000,"d":"₪ 7,000.00"},{"$f":"שם_רכב_2","v":"רכב 2"}]
[null,"תאריך","סכום","רכב","מקום","תיאור"]
[null,{"$f":"TODAY()-800","v":"2016-05-03"},{"v":632.11,"d":"₪ 632.11"},"רכב 1","סוחר","החלפת רדיאטור"]
[null,{"$f":"TODAY()-270","v":"2017-10-15"},{"v":389.87,"d":"₪ 389.87"},"רכב 2","חנות צמיגים","ארבעה צמיגים חדשים"]
[null,{"$f":"TODAY()-400","v":"2017-06-07"},{"v":3400,"d":"₪ 3,400.00"},"רכב 1","מוסך","תיקון נזקי התנגשות"]
[null,{"$f":"TODAY()-90","v":"2018-04-13"},{"v":89.99,"d":"₪ 89.99"},"רכב 2","חנות צמיגים","יישור ציר אחורי"]
[null,{"$f":"TODAY()","v":"2018-07-12"},{"v":239.54,"d":"₪ 239.54"},"רכב 2","סוחר","טיפול עשרת אלפים"]