{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["התחלה","הוצאות מתוכננות","הוצאות בפועל","שונות הוצאות","ניתוח הוצאות"],"not_rendered":{"charts":2,"images":3,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"התחלה","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"אודות תבנית זו"]
[null,"השתמש בחוברת עבודה זו של תקציב הוצאות עסקיות זו כדי לעקוב אחר ההוצאות המתוכננות, ההוצאות בפועל והשונות."]
[null,"מלא את שם החברה והוסף את סמל החברה."]
[null,"הזן פרטים בטבלאות בגליון העבודה 'הוצאות מתוכננות' ובגליון העבודה 'הוצאות בפועל'."]
[null,"הטבלאות מתעדכנות באופן אוטומטי בגליון העבודה 'שונות הוצאות'. התרשימים מתעדכנים באופן אוטומטי בגליון העבודה 'ניתוח הוצאות'"]
[null,"הערה: "]
[null,"הוראות נוספות סופקו בעמודה A בכל גליון עבודה. טקסט זה הוסתר במכוון. כדי להסיר את הטקסט, בחר את עמודה A ולאחר מכן הקש DELETE. כדי לבטל את הסתרת הטקסט, בחר את עמודה A ולאחר מכן שנה את צבע הגופן."]
[null,"לקבלת מידע נוסף על הטבלאות, הקש SHIFT ולאחר מכן F10 בתוך טבלה, בחר את האפשרות 'טבלה' ולאחר מכן בחר 'טקסט חלופי'"]

{"sheet":"הוצאות מתוכננות","index":1,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,10,1,12],[2,10,2,12],[3,17,12,19]]}
[{"$nulls":15}," "]
[null,"שם החברה",{"$nulls":8},"פירוט ההוצאות המשוערות"]
[{"$nulls":10},"התאים המוצללים כוללים חישובים."]
[null,"הוצאות מתוכננות","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"עלויות עובדים","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"שכר",{"v":85000,"d":"₪ 85,000.00"},{"v":85000,"d":"₪ 85,000.00"},{"v":85000,"d":"₪ 85,000.00"},{"v":87500,"d":"₪ 87,500.00"},{"v":87500,"d":"₪ 87,500.00"},{"v":87500,"d":"₪ 87,500.00"},{"v":87500,"d":"₪ 87,500.00"},{"v":92400,"d":"₪ 92,400.00"},{"v":92400,"d":"₪ 92,400.00"},{"v":92400,"d":"₪ 92,400.00"},{"v":92400,"d":"₪ 92,400.00"},{"v":92400,"d":"₪ 92,400.00"},{"$f":"SUM(C6:N6)","v":{"v":1067000,"d":"₪ 1,067,000.00"}}]
[null,"הטבות",{"$f":"C6*0.27","v":{"v":22950,"d":"₪ 22,950.00"}},{"v":22950,"d":"₪ 22,950.00"},{"v":22950,"d":"₪ 22,950.00"},{"v":23625,"d":"₪ 23,625.00"},{"v":23625,"d":"₪ 23,625.00"},{"v":23625,"d":"₪ 23,625.00"},{"v":23625,"d":"₪ 23,625.00"},{"v":24948,"d":"₪ 24,948.00"},{"v":24948,"d":"₪ 24,948.00"},{"v":24948,"d":"₪ 24,948.00"},{"v":24948,"d":"₪ 24,948.00"},{"v":24948,"d":"₪ 24,948.00"},{"$f":"SUM(C7:N7)","v":{"v":288090,"d":"₪ 288,090.00"}}]
[null,"סכום ביניים",{"$f":"SUBTOTAL(109,EmployeePlan[ינו])","v":{"v":107950,"d":"₪ 107,950.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[פבר])","v":{"v":107950,"d":"₪ 107,950.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[מרץ])","v":{"v":107950,"d":"₪ 107,950.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[אפר])","v":{"v":111125,"d":"₪ 111,125.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[מאי])","v":{"v":111125,"d":"₪ 111,125.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[יונ])","v":{"v":111125,"d":"₪ 111,125.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[יול])","v":{"v":111125,"d":"₪ 111,125.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[אוג])","v":{"v":117348,"d":"₪ 117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[ספט])","v":{"v":117348,"d":"₪ 117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[אוק])","v":{"v":117348,"d":"₪ 117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[נוב])","v":{"v":117348,"d":"₪ 117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[דצמ])","v":{"v":117348,"d":"₪ 117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[שנה])","v":{"v":1355090,"d":"₪ 1,355,090.00"}}]
[]
[null,"עלויות משרדיות","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"שכ\"ד למשרד",{"v":9800,"d":"₪ 9,800.00"},{"v":9800,"d":"₪ 9,800.00"},{"v":9800,"d":"₪ 9,800.00"},{"v":9800,"d":"₪ 9,800.00"},{"v":9800,"d":"₪ 9,800.00"},{"v":9800,"d":"₪ 9,800.00"},{"v":9800,"d":"₪ 9,800.00"},{"v":9800,"d":"₪ 9,800.00"},{"v":9800,"d":"₪ 9,800.00"},{"v":9800,"d":"₪ 9,800.00"},{"v":9800,"d":"₪ 9,800.00"},{"v":9800,"d":"₪ 9,800.00"},{"$f":"SUM(C11:N11)","v":{"v":117600,"d":"₪ 117,600.00"}}]
[null,"גז",null,{"v":400,"d":"₪ 400.00"},{"v":400,"d":"₪ 400.00"},{"v":100,"d":"₪ 100.00"},{"v":100,"d":"₪ 100.00"},{"v":100,"d":"₪ 100.00"},{"v":100,"d":"₪ 100.00"},{"v":100,"d":"₪ 100.00"},{"v":100,"d":"₪ 100.00"},{"v":100,"d":"₪ 100.00"},{"v":400,"d":"₪ 400.00"},{"v":400,"d":"₪ 400.00"},{"v":2300,"d":"₪ 2,300.00"}]
[null,"חשמל",{"v":300,"d":"₪ 300.00"},{"v":300,"d":"₪ 300.00"},{"v":300,"d":"₪ 300.00"},{"v":300,"d":"₪ 300.00"},{"v":300,"d":"₪ 300.00"},{"v":300,"d":"₪ 300.00"},{"v":300,"d":"₪ 300.00"},{"v":300,"d":"₪ 300.00"},{"v":300,"d":"₪ 300.00"},{"v":300,"d":"₪ 300.00"},{"v":300,"d":"₪ 300.00"},{"v":300,"d":"₪ 300.00"},{"v":3600,"d":"₪ 3,600.00"}]
[null,"מים",{"v":40,"d":"₪ 40.00"},{"v":40,"d":"₪ 40.00"},{"v":40,"d":"₪ 40.00"},{"v":40,"d":"₪ 40.00"},{"v":40,"d":"₪ 40.00"},{"v":40,"d":"₪ 40.00"},{"v":40,"d":"₪ 40.00"},{"v":40,"d":"₪ 40.00"},{"v":40,"d":"₪ 40.00"},{"v":40,"d":"₪ 40.00"},{"v":40,"d":"₪ 40.00"},{"v":40,"d":"₪ 40.00"},{"v":480,"d":"₪ 480.00"}]
[null,"טלפון",{"v":250,"d":"₪ 250.00"},{"v":250,"d":"₪ 250.00"},{"v":250,"d":"₪ 250.00"},{"v":250,"d":"₪ 250.00"},{"v":250,"d":"₪ 250.00"},{"v":250,"d":"₪ 250.00"},{"v":250,"d":"₪ 250.00"},{"v":250,"d":"₪ 250.00"},{"v":250,"d":"₪ 250.00"},{"v":250,"d":"₪ 250.00"},{"v":250,"d":"₪ 250.00"},{"v":250,"d":"₪ 250.00"},{"v":3000,"d":"₪ 3,000.00"}]
[null,"גישה לאינטרנט",{"v":180,"d":"₪ 180.00"},{"v":180,"d":"₪ 180.00"},{"v":180,"d":"₪ 180.00"},{"v":180,"d":"₪ 180.00"},{"v":180,"d":"₪ 180.00"},{"v":180,"d":"₪ 180.00"},{"v":180,"d":"₪ 180.00"},{"v":180,"d":"₪ 180.00"},{"v":180,"d":"₪ 180.00"},{"v":180,"d":"₪ 180.00"},{"v":180,"d":"₪ 180.00"},{"v":180,"d":"₪ 180.00"},{"v":2160,"d":"₪ 2,160.00"}]
[null,"ציוד משרדי",{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":2400,"d":"₪ 2,400.00"}]
[null,"אבטחה",{"v":600,"d":"₪ 600.00"},{"v":600,"d":"₪ 600.00"},{"v":600,"d":"₪ 600.00"},{"v":600,"d":"₪ 600.00"},{"v":600,"d":"₪ 600.00"},{"v":600,"d":"₪ 600.00"},{"v":600,"d":"₪ 600.00"},{"v":600,"d":"₪ 600.00"},{"v":600,"d":"₪ 600.00"},{"v":600,"d":"₪ 600.00"},{"v":600,"d":"₪ 600.00"},{"v":600,"d":"₪ 600.00"},{"v":7200,"d":"₪ 7,200.00"}]
[null,"סכום ביניים",{"$f":"SUBTOTAL(109,OfficePlan[ינו])","v":{"v":11370,"d":"₪ 11,370.00"}},{"$f":"SUBTOTAL(109,OfficePlan[פבר])","v":{"v":11770,"d":"₪ 11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[מרץ])","v":{"v":11770,"d":"₪ 11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[אפר])","v":{"v":11470,"d":"₪ 11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[מאי])","v":{"v":11470,"d":"₪ 11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[יונ])","v":{"v":11470,"d":"₪ 11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[יול])","v":{"v":11470,"d":"₪ 11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[אוג])","v":{"v":11470,"d":"₪ 11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[ספט])","v":{"v":11470,"d":"₪ 11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[אוק])","v":{"v":11470,"d":"₪ 11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[נוב])","v":{"v":11770,"d":"₪ 11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[דצמ])","v":{"v":11770,"d":"₪ 11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[שנה])","v":{"v":138740,"d":"₪ 138,740.00"}}]
[]
[null,"עלויות שיווק","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"אירוח אתר אינטרנט",{"v":500,"d":"₪ 500.00"},{"v":500,"d":"₪ 500.00"},{"v":500,"d":"₪ 500.00"},{"v":500,"d":"₪ 500.00"},{"v":500,"d":"₪ 500.00"},{"v":500,"d":"₪ 500.00"},{"v":500,"d":"₪ 500.00"},{"v":500,"d":"₪ 500.00"},{"v":500,"d":"₪ 500.00"},{"v":500,"d":"₪ 500.00"},{"v":500,"d":"₪ 500.00"},{"v":500,"d":"₪ 500.00"},{"$f":"SUM(C22:N22)","v":{"v":6000,"d":"₪ 6,000.00"}}]
[null,"עדכוני אתר אינטרנט",{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":4000,"d":"₪ 4,000.00"}]
[null,"הכנת חומרי שיווק",{"v":5000,"d":"₪ 5,000.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":5000,"d":"₪ 5,000.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":5000,"d":"₪ 5,000.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":5000,"d":"₪ 5,000.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":20000,"d":"₪ 20,000.00"}]
[null,"הדפסת חומרי שיווק",{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":2400,"d":"₪ 2,400.00"}]
[null,"אירועים שיווקיים",{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":5000,"d":"₪ 5,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":5000,"d":"₪ 5,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":5000,"d":"₪ 5,000.00"},{"v":33000,"d":"₪ 33,000.00"}]
[null,"הוצאות שונות",{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":2400,"d":"₪ 2,400.00"}]
[null,"סכום ביניים",{"$f":"SUBTOTAL(109,MarketingPlan[ינו])","v":{"v":8100,"d":"₪ 8,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[פבר])","v":{"v":3100,"d":"₪ 3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[מרץ])","v":{"v":3100,"d":"₪ 3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[אפר])","v":{"v":11100,"d":"₪ 11,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[מאי])","v":{"v":3100,"d":"₪ 3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[יונ])","v":{"v":3900,"d":"₪ 3,900.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[יול])","v":{"v":8100,"d":"₪ 8,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[אוג])","v":{"v":6100,"d":"₪ 6,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[ספט])","v":{"v":3100,"d":"₪ 3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[אוק])","v":{"v":8100,"d":"₪ 8,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[נוב])","v":{"v":3100,"d":"₪ 3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[דצמ])","v":{"v":6900,"d":"₪ 6,900.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[שנה])","v":{"v":67800,"d":"₪ 67,800.00"}}]
[]
[null,"הדרכה/נסיעה","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"קורסי הדרכה",{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"$f":"SUM(C31:N31)","v":{"v":24000,"d":"₪ 24,000.00"}}]
[null,"עלויות נסיעה הקשורות להדרכה",{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"$f":"SUM(C32:N32)","v":{"v":24000,"d":"₪ 24,000.00"}}]
[null,"סכום ביניים",{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[ינו])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[פבר])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[מרץ])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[אפר])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[מאי])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[יונ])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[יול])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[אוג])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[ספט])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[אוק])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[נוב])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[דצמ])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[שנה])","v":{"v":48000,"d":"₪ 48,000.00"}}]
[]
[null,"סכומים כוללים","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"הוצאות מתוכננות חודשיות",{"$f":"TrainingAndTravelPlan[[#Totals],[ינו]]+MarketingPlan[[#Totals],[ינו]]+OfficePlan[[#Totals],[ינו]]+EmployeePlan[[#Totals],[ינו]]","v":{"v":131420,"d":"₪ 131,420.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[פבר]]+MarketingPlan[[#Totals],[פבר]]+OfficePlan[[#Totals],[פבר]]+EmployeePlan[[#Totals],[פבר]]","v":{"v":126820,"d":"₪ 126,820.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[מרץ]]+MarketingPlan[[#Totals],[מרץ]]+OfficePlan[[#Totals],[מרץ]]+EmployeePlan[[#Totals],[מרץ]]","v":{"v":126820,"d":"₪ 126,820.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[אפר]]+MarketingPlan[[#Totals],[אפר]]+OfficePlan[[#Totals],[אפר]]+EmployeePlan[[#Totals],[אפר]]","v":{"v":137695,"d":"₪ 137,695.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[מאי]]+MarketingPlan[[#Totals],[מאי]]+OfficePlan[[#Totals],[מאי]]+EmployeePlan[[#Totals],[מאי]]","v":{"v":129695,"d":"₪ 129,695.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[יונ]]+MarketingPlan[[#Totals],[יונ]]+OfficePlan[[#Totals],[יונ]]+EmployeePlan[[#Totals],[יונ]]","v":{"v":130495,"d":"₪ 130,495.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[יול]]+MarketingPlan[[#Totals],[יול]]+OfficePlan[[#Totals],[יול]]+EmployeePlan[[#Totals],[יול]]","v":{"v":134695,"d":"₪ 134,695.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[אוג]]+MarketingPlan[[#Totals],[אוג]]+OfficePlan[[#Totals],[אוג]]+EmployeePlan[[#Totals],[אוג]]","v":{"v":138918,"d":"₪ 138,918.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[ספט]]+MarketingPlan[[#Totals],[ספט]]+OfficePlan[[#Totals],[ספט]]+EmployeePlan[[#Totals],[ספט]]","v":{"v":135918,"d":"₪ 135,918.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[אוק]]+MarketingPlan[[#Totals],[אוק]]+OfficePlan[[#Totals],[אוק]]+EmployeePlan[[#Totals],[אוק]]","v":{"v":140918,"d":"₪ 140,918.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[נוב]]+MarketingPlan[[#Totals],[נוב]]+OfficePlan[[#Totals],[נוב]]+EmployeePlan[[#Totals],[נוב]]","v":{"v":136218,"d":"₪ 136,218.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[דצמ]]+MarketingPlan[[#Totals],[דצמ]]+OfficePlan[[#Totals],[דצמ]]+EmployeePlan[[#Totals],[דצמ]]","v":{"v":140018,"d":"₪ 140,018.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[שנה]]+MarketingPlan[[#Totals],[שנה]]+OfficePlan[[#Totals],[שנה]]+EmployeePlan[[#Totals],[שנה]]","v":{"v":1609630,"d":"₪ 1,609,630.00"}}]
[null,"הוצאות מתוכננות כוללות",{"$f":"SUM($C$36:C36)","v":{"v":131420,"d":"₪ 131,420.00"}},{"$f":"SUM($C$36:D36)","v":{"v":258240,"d":"₪ 258,240.00"}},{"$f":"SUM($C$36:E36)","v":{"v":385060,"d":"₪ 385,060.00"}},{"$f":"SUM($C$36:F36)","v":{"v":522755,"d":"₪ 522,755.00"}},{"$f":"SUM($C$36:G36)","v":{"v":652450,"d":"₪ 652,450.00"}},{"$f":"SUM($C$36:H36)","v":{"v":782945,"d":"₪ 782,945.00"}},{"$f":"SUM($C$36:I36)","v":{"v":917640,"d":"₪ 917,640.00"}},{"$f":"SUM($C$36:J36)","v":{"v":1056558,"d":"₪ 1,056,558.00"}},{"$f":"SUM($C$36:K36)","v":{"v":1192476,"d":"₪ 1,192,476.00"}},{"$f":"SUM($C$36:L36)","v":{"v":1333394,"d":"₪ 1,333,394.00"}},{"$f":"SUM($C$36:M36)","v":{"v":1469612,"d":"₪ 1,469,612.00"}},{"$f":"SUM($C$36:N36)","v":{"v":1609630,"d":"₪ 1,609,630.00"}}]

{"sheet":"הוצאות בפועל","index":2,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,10,1,12],[2,10,2,12]]}
[{"$nulls":15}," "]
[null,{"$f":"'הוצאות מתוכננות'!B2:D3","v":"שם החברה"},{"$nulls":8},{"$f":"worksheet_title","v":"פירוט ההוצאות המשוערות"}]
[{"$nulls":10},"התאים המוצללים כוללים חישובים."]
[null,"הוצאות בפועל","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"עלויות עובדים","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"שכר",{"v":85000,"d":"₪ 85,000.00"},{"v":85000,"d":"₪ 85,000.00"},{"v":85000,"d":"₪ 85,000.00"},{"v":88000,"d":"₪ 88,000.00"},{"v":88000,"d":"₪ 88,000.00"},{"v":88000,"d":"₪ 88,000.00"},{"$nulls":6},{"$f":"SUM(C6:N6)","v":{"v":519000,"d":"₪ 519,000.00"}}]
[null,"הטבות",{"$f":"C6*0.27","v":{"v":22950,"d":"₪ 22,950.00"}},{"v":22950,"d":"₪ 22,950.00"},{"v":22950,"d":"₪ 22,950.00"},{"v":23760,"d":"₪ 23,760.00"},{"v":23760,"d":"₪ 23,760.00"},{"v":23760,"d":"₪ 23,760.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"$f":"SUM(C7:N7)","v":{"v":140130,"d":"₪ 140,130.00"}}]
[null,"סכום ביניים",{"$f":"SUBTOTAL(109,EmployeeActual[ינו])","v":{"v":107950,"d":"₪ 107,950.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[פבר])","v":{"v":107950,"d":"₪ 107,950.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[מרץ])","v":{"v":107950,"d":"₪ 107,950.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[אפר])","v":{"v":111760,"d":"₪ 111,760.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[מאי])","v":{"v":111760,"d":"₪ 111,760.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[יונ])","v":{"v":111760,"d":"₪ 111,760.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[יול])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[אוג])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[ספט])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[אוק])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[נוב])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[דצמ])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[שנה])","v":{"v":659130,"d":"₪ 659,130.00"}}]
[]
[null,"עלויות משרדיות","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"שכ\"ד למשרד",{"v":9800,"d":"₪ 9,800.00"},{"v":9800,"d":"₪ 9,800.00"},{"v":9800,"d":"₪ 9,800.00"},{"v":9800,"d":"₪ 9,800.00"},{"v":9800,"d":"₪ 9,800.00"},{"v":9800,"d":"₪ 9,800.00"},{"$nulls":6},{"$f":"SUM(C11:N11)","v":{"v":58800,"d":"₪ 58,800.00"}}]
[null,"גז",{"v":4,"d":"₪ 4.00"},{"v":430,"d":"₪ 430.00"},{"v":385,"d":"₪ 385.00"},{"v":230,"d":"₪ 230.00"},{"v":87,"d":"₪ 87.00"},{"v":88,"d":"₪ 88.00"},{"$nulls":6},{"v":1224,"d":"₪ 1,224.00"}]
[null,"חשמל",{"v":288,"d":"₪ 288.00"},{"v":278,"d":"₪ 278.00"},{"v":268,"d":"₪ 268.00"},{"v":299,"d":"₪ 299.00"},{"v":306,"d":"₪ 306.00"},{"v":290,"d":"₪ 290.00"},{"$nulls":6},{"v":1729,"d":"₪ 1,729.00"}]
[null,"מים",{"v":35,"d":"₪ 35.00"},{"v":33,"d":"₪ 33.00"},{"v":34,"d":"₪ 34.00"},{"v":36,"d":"₪ 36.00"},{"v":34,"d":"₪ 34.00"},{"v":36,"d":"₪ 36.00"},{"$nulls":6},{"v":208,"d":"₪ 208.00"}]
[null,"טלפון",{"v":224,"d":"₪ 224.00"},{"v":235,"d":"₪ 235.00"},{"v":265,"d":"₪ 265.00"},{"v":245,"d":"₪ 245.00"},{"v":245,"d":"₪ 245.00"},{"v":220,"d":"₪ 220.00"},{"$nulls":6},{"v":1434,"d":"₪ 1,434.00"}]
[null,"גישה לאינטרנט",{"v":180,"d":"₪ 180.00"},{"v":180,"d":"₪ 180.00"},{"v":180,"d":"₪ 180.00"},{"v":180,"d":"₪ 180.00"},{"v":180,"d":"₪ 180.00"},{"v":180,"d":"₪ 180.00"},{"$nulls":6},{"v":1080,"d":"₪ 1,080.00"}]
[null,"ציוד משרדי",{"v":256,"d":"₪ 256.00"},{"v":142,"d":"₪ 142.00"},{"v":160,"d":"₪ 160.00"},{"v":221,"d":"₪ 221.00"},{"v":256,"d":"₪ 256.00"},{"v":240,"d":"₪ 240.00"},{"$nulls":6},{"v":1275,"d":"₪ 1,275.00"}]
[null,"אבטחה",{"v":600,"d":"₪ 600.00"},{"v":600,"d":"₪ 600.00"},{"v":600,"d":"₪ 600.00"},{"v":600,"d":"₪ 600.00"},{"v":600,"d":"₪ 600.00"},{"v":600,"d":"₪ 600.00"},{"$nulls":6},{"v":3600,"d":"₪ 3,600.00"}]
[null,"סכום ביניים",{"$f":"SUBTOTAL(109,OfficeActual[ינו])","v":{"v":11387,"d":"₪ 11,387.00"}},{"$f":"SUBTOTAL(109,OfficeActual[פבר])","v":{"v":11698,"d":"₪ 11,698.00"}},{"$f":"SUBTOTAL(109,OfficeActual[מרץ])","v":{"v":11692,"d":"₪ 11,692.00"}},{"$f":"SUBTOTAL(109,OfficeActual[אפר])","v":{"v":11611,"d":"₪ 11,611.00"}},{"$f":"SUBTOTAL(109,OfficeActual[מאי])","v":{"v":11508,"d":"₪ 11,508.00"}},{"$f":"SUBTOTAL(109,OfficeActual[יונ])","v":{"v":11454,"d":"₪ 11,454.00"}},{"$f":"SUBTOTAL(109,OfficeActual[יול])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[אוג])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[ספט])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[אוק])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[נוב])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[דצמ])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[שנה])","v":{"v":69350,"d":"₪ 69,350.00"}}]
[]
[null,"עלויות שיווק","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"אירוח אתר אינטרנט",{"v":500,"d":"₪ 500.00"},{"v":500,"d":"₪ 500.00"},{"v":500,"d":"₪ 500.00"},{"v":500,"d":"₪ 500.00"},{"v":500,"d":"₪ 500.00"},{"v":500,"d":"₪ 500.00"},{"$nulls":6},{"$f":"SUM(C22:N22)","v":{"v":3000,"d":"₪ 3,000.00"}}]
[null,"עדכוני אתר אינטרנט",{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":1500,"d":"₪ 1,500.00"},{"$nulls":6},{"v":2500,"d":"₪ 2,500.00"}]
[null,"הכנת חומרי שיווק",{"v":4800,"d":"₪ 4,800.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":5500,"d":"₪ 5,500.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"$nulls":6},{"v":10300,"d":"₪ 10,300.00"}]
[null,"הדפסת חומרי שיווק",{"v":100,"d":"₪ 100.00"},{"v":500,"d":"₪ 500.00"},{"v":100,"d":"₪ 100.00"},{"v":100,"d":"₪ 100.00"},{"v":600,"d":"₪ 600.00"},{"v":180,"d":"₪ 180.00"},{"$nulls":6},{"v":1580,"d":"₪ 1,580.00"}]
[null,"אירועים שיווקיים",{"v":1800,"d":"₪ 1,800.00"},{"v":2200,"d":"₪ 2,200.00"},{"v":2200,"d":"₪ 2,200.00"},{"v":4700,"d":"₪ 4,700.00"},{"v":1500,"d":"₪ 1,500.00"},{"v":2300,"d":"₪ 2,300.00"},{"$nulls":6},{"v":14700,"d":"₪ 14,700.00"}]
[null,"הוצאות שונות",{"v":145,"d":"₪ 145.00"},{"v":156,"d":"₪ 156.00"},{"v":123,"d":"₪ 123.00"},{"v":223,"d":"₪ 223.00"},{"v":187,"d":"₪ 187.00"},{"v":245,"d":"₪ 245.00"},{"$nulls":6},{"v":1079,"d":"₪ 1,079.00"}]
[null,"סכום ביניים",{"$f":"SUBTOTAL(109,MarketingActual[ינו])","v":{"v":7545,"d":"₪ 7,545.00"}},{"$f":"SUBTOTAL(109,MarketingActual[פבר])","v":{"v":3556,"d":"₪ 3,556.00"}},{"$f":"SUBTOTAL(109,MarketingActual[מרץ])","v":{"v":3123,"d":"₪ 3,123.00"}},{"$f":"SUBTOTAL(109,MarketingActual[אפר])","v":{"v":11223,"d":"₪ 11,223.00"}},{"$f":"SUBTOTAL(109,MarketingActual[מאי])","v":{"v":2987,"d":"₪ 2,987.00"}},{"$f":"SUBTOTAL(109,MarketingActual[יונ])","v":{"v":4725,"d":"₪ 4,725.00"}},{"$f":"SUBTOTAL(109,MarketingActual[יול])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[אוג])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[ספט])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[אוק])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[נוב])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[דצמ])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[שנה])","v":{"v":33159,"d":"₪ 33,159.00"}}]
[]
[null,"הדרכה/נסיעה","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"קורסי הדרכה",{"v":1600,"d":"₪ 1,600.00"},{"v":2400,"d":"₪ 2,400.00"},{"v":1400,"d":"₪ 1,400.00"},{"v":1600,"d":"₪ 1,600.00"},{"v":1200,"d":"₪ 1,200.00"},{"v":2800,"d":"₪ 2,800.00"},{"$nulls":6},{"$f":"SUM(C31:N31)","v":{"v":11000,"d":"₪ 11,000.00"}}]
[null,"עלויות נסיעה הקשורות להדרכה",{"v":1200,"d":"₪ 1,200.00"},{"v":2200,"d":"₪ 2,200.00"},{"v":1400,"d":"₪ 1,400.00"},{"v":1200,"d":"₪ 1,200.00"},{"v":800,"d":"₪ 800.00"},{"v":3500,"d":"₪ 3,500.00"},{"$nulls":6},{"$f":"SUM(C32:N32)","v":{"v":10300,"d":"₪ 10,300.00"}}]
[null,"סכום ביניים",{"$f":"SUBTOTAL(109,TrainingAndTravelActual[ינו])","v":{"v":2800,"d":"₪ 2,800.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[פבר])","v":{"v":4600,"d":"₪ 4,600.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[מרץ])","v":{"v":2800,"d":"₪ 2,800.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[אפר])","v":{"v":2800,"d":"₪ 2,800.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[מאי])","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[יונ])","v":{"v":6300,"d":"₪ 6,300.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[יול])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[אוג])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[ספט])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[אוק])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[נוב])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[דצמ])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[שנה])","v":{"v":21300,"d":"₪ 21,300.00"}}]
[]
[null,"הוצאות מתוכננות כוללות","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"הוצאות חודשיות בפועל",{"$f":"TrainingAndTravelActual[[#Totals],[ינו]]+MarketingActual[[#Totals],[ינו]]+OfficeActual[[#Totals],[ינו]]+EmployeeActual[[#Totals],[ינו]]","v":{"v":129682,"d":"₪ 129,682.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[פבר]]+MarketingActual[[#Totals],[פבר]]+OfficeActual[[#Totals],[פבר]]+EmployeeActual[[#Totals],[פבר]]","v":{"v":127804,"d":"₪ 127,804.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[מרץ]]+MarketingActual[[#Totals],[מרץ]]+OfficeActual[[#Totals],[מרץ]]+EmployeeActual[[#Totals],[מרץ]]","v":{"v":125565,"d":"₪ 125,565.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[אפר]]+MarketingActual[[#Totals],[אפר]]+OfficeActual[[#Totals],[אפר]]+EmployeeActual[[#Totals],[אפר]]","v":{"v":137394,"d":"₪ 137,394.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[מאי]]+MarketingActual[[#Totals],[מאי]]+OfficeActual[[#Totals],[מאי]]+EmployeeActual[[#Totals],[מאי]]","v":{"v":128255,"d":"₪ 128,255.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[יונ]]+MarketingActual[[#Totals],[יונ]]+OfficeActual[[#Totals],[יונ]]+EmployeeActual[[#Totals],[יונ]]","v":{"v":134239,"d":"₪ 134,239.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[יול]]+MarketingActual[[#Totals],[יול]]+OfficeActual[[#Totals],[יול]]+EmployeeActual[[#Totals],[יול]]","v":{"v":0,"d":"₪ 0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[אוג]]+MarketingActual[[#Totals],[אוג]]+OfficeActual[[#Totals],[אוג]]+EmployeeActual[[#Totals],[אוג]]","v":{"v":0,"d":"₪ 0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[ספט]]+MarketingActual[[#Totals],[ספט]]+OfficeActual[[#Totals],[ספט]]+EmployeeActual[[#Totals],[ספט]]","v":{"v":0,"d":"₪ 0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[אוק]]+MarketingActual[[#Totals],[אוק]]+OfficeActual[[#Totals],[אוק]]+EmployeeActual[[#Totals],[אוק]]","v":{"v":0,"d":"₪ 0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[נוב]]+MarketingActual[[#Totals],[נוב]]+OfficeActual[[#Totals],[נוב]]+EmployeeActual[[#Totals],[נוב]]","v":{"v":0,"d":"₪ 0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[דצמ]]+MarketingActual[[#Totals],[דצמ]]+OfficeActual[[#Totals],[דצמ]]+EmployeeActual[[#Totals],[דצמ]]","v":{"v":0,"d":"₪ 0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[שנה]]+MarketingActual[[#Totals],[שנה]]+OfficeActual[[#Totals],[שנה]]+EmployeeActual[[#Totals],[שנה]]","v":{"v":782939,"d":"₪ 782,939.00"}}]
[null,"הוצאות כוללות בפועל",{"$f":"SUM($C$36:C36)","v":{"v":129682,"d":"₪ 129,682.00"}},{"$f":"SUM($C$36:D36)","v":{"v":257486,"d":"₪ 257,486.00"}},{"$f":"SUM($C$36:E36)","v":{"v":383051,"d":"₪ 383,051.00"}},{"$f":"SUM($C$36:F36)","v":{"v":520445,"d":"₪ 520,445.00"}},{"$f":"SUM($C$36:G36)","v":{"v":648700,"d":"₪ 648,700.00"}},{"$f":"SUM($C$36:H36)","v":{"v":782939,"d":"₪ 782,939.00"}},{"$f":"SUM($C$36:I36)","v":{"v":782939,"d":"₪ 782,939.00"}},{"$f":"SUM($C$36:J36)","v":{"v":782939,"d":"₪ 782,939.00"}},{"$f":"SUM($C$36:K36)","v":{"v":782939,"d":"₪ 782,939.00"}},{"$f":"SUM($C$36:L36)","v":{"v":782939,"d":"₪ 782,939.00"}},{"$f":"SUM($C$36:M36)","v":{"v":782939,"d":"₪ 782,939.00"}},{"$f":"SUM($C$36:N36)","v":{"v":782939,"d":"₪ 782,939.00"}}]

{"sheet":"שונות הוצאות","index":3,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,10,1,12],[2,10,2,12]]}
[{"$nulls":15}," "]
[null,{"$f":"'הוצאות מתוכננות'!B2:D3","v":"שם החברה"},{"$nulls":8},{"$f":"worksheet_title","v":"פירוט ההוצאות המשוערות"}]
[{"$nulls":10},"התאים המוצללים כוללים חישובים."]
[null,"שונות הוצאות","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"עלויות עובדים","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"שכר",{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[ינו]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[ינו]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[ינו]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[ינו]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[פבר]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[פבר]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[פבר]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[פבר]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[מרץ]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[מרץ]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[מרץ]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[מרץ]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[אפר]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[אפר]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[אפר]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[אפר]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"₪ -500.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[מאי]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[מאי]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[מאי]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[מאי]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"₪ -500.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[יונ]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[יונ]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[יונ]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[יונ]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"₪ -500.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[יול]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[יול]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[יול]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[יול]],EmployeeActual[#Headers],0))","v":{"v":87500,"d":"₪ 87,500.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[אוג]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[אוג]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[אוג]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[אוג]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"₪ 92,400.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[ספט]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[ספט]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[ספט]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[ספט]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"₪ 92,400.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[אוק]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[אוק]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[אוק]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[אוק]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"₪ 92,400.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[נוב]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[נוב]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[נוב]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[נוב]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"₪ 92,400.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[דצמ]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[דצמ]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[דצמ]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[דצמ]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"₪ 92,400.00"}},{"$f":"SUM(EmployeeVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":548000,"d":"₪ 548,000.00"}}]
[null,"הטבות",{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[ינו]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[ינו]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[ינו]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[ינו]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[פבר]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[פבר]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[פבר]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[פבר]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[מרץ]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[מרץ]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[מרץ]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[מרץ]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[אפר]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[אפר]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[אפר]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[אפר]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"₪ -135.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[מאי]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[מאי]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[מאי]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[מאי]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"₪ -135.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[יונ]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[יונ]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[יונ]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[יונ]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"₪ -135.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[יול]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[יול]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[יול]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[יול]],EmployeeActual[#Headers],0))","v":{"v":23625,"d":"₪ 23,625.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[אוג]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[אוג]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[אוג]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[אוג]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"₪ 24,948.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[ספט]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[ספט]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[ספט]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[ספט]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"₪ 24,948.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[אוק]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[אוק]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[אוק]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[אוק]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"₪ 24,948.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[נוב]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[נוב]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[נוב]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[נוב]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"₪ 24,948.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[דצמ]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[דצמ]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[דצמ]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[דצמ]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"₪ 24,948.00"}},{"$f":"SUM(EmployeeVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":147960,"d":"₪ 147,960.00"}}]
[null,"סכום ביניים",{"$f":"SUBTOTAL(109,EmployeeVariances[ינו])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[פבר])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[מרץ])","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[אפר])","v":{"v":-635,"d":"₪ -635.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[מאי])","v":{"v":-635,"d":"₪ -635.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[יונ])","v":{"v":-635,"d":"₪ -635.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[יול])","v":{"v":111125,"d":"₪ 111,125.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[אוג])","v":{"v":117348,"d":"₪ 117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[ספט])","v":{"v":117348,"d":"₪ 117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[אוק])","v":{"v":117348,"d":"₪ 117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[נוב])","v":{"v":117348,"d":"₪ 117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[דצמ])","v":{"v":117348,"d":"₪ 117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[שנה])","v":{"v":695960,"d":"₪ 695,960.00"}}]
[]
[null,"עלויות משרדיות","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"שכ\"ד למשרד",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ינו]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ינו]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ינו]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ינו]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[פבר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[פבר]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[פבר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[פבר]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מרץ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מרץ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מרץ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מרץ]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אפר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אפר]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אפר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אפר]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מאי]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מאי]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מאי]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מאי]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יונ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יונ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יונ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יונ]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יול]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יול]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יול]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יול]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₪ 9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוג]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוג]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוג]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוג]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₪ 9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ספט]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ספט]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ספט]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ספט]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₪ 9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוק]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוק]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוק]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוק]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₪ 9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[נוב]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[נוב]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[נוב]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[נוב]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₪ 9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[דצמ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[דצמ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[דצמ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[דצמ]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₪ 9,800.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":58800,"d":"₪ 58,800.00"}}]
[null,"גז",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ינו]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ינו]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ינו]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ינו]],OfficeActual[#Headers],0))","v":{"v":-4,"d":"₪ -4.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[פבר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[פבר]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[פבר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[פבר]],OfficeActual[#Headers],0))","v":{"v":-30,"d":"₪ -30.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מרץ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מרץ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מרץ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מרץ]],OfficeActual[#Headers],0))","v":{"v":15,"d":"₪ 15.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אפר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אפר]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אפר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אפר]],OfficeActual[#Headers],0))","v":{"v":-130,"d":"₪ -130.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מאי]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מאי]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מאי]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מאי]],OfficeActual[#Headers],0))","v":{"v":13,"d":"₪ 13.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יונ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יונ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יונ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יונ]],OfficeActual[#Headers],0))","v":{"v":12,"d":"₪ 12.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יול]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יול]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יול]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יול]],OfficeActual[#Headers],0))","v":{"v":100,"d":"₪ 100.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוג]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוג]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוג]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוג]],OfficeActual[#Headers],0))","v":{"v":100,"d":"₪ 100.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ספט]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ספט]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ספט]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ספט]],OfficeActual[#Headers],0))","v":{"v":100,"d":"₪ 100.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוק]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוק]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוק]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוק]],OfficeActual[#Headers],0))","v":{"v":100,"d":"₪ 100.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[נוב]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[נוב]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[נוב]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[נוב]],OfficeActual[#Headers],0))","v":{"v":400,"d":"₪ 400.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[דצמ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[דצמ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[דצמ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[דצמ]],OfficeActual[#Headers],0))","v":{"v":400,"d":"₪ 400.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":1076,"d":"₪ 1,076.00"}}]
[null,"חשמל",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ינו]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ינו]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ינו]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ינו]],OfficeActual[#Headers],0))","v":{"v":12,"d":"₪ 12.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[פבר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[פבר]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[פבר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[פבר]],OfficeActual[#Headers],0))","v":{"v":22,"d":"₪ 22.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מרץ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מרץ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מרץ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מרץ]],OfficeActual[#Headers],0))","v":{"v":32,"d":"₪ 32.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אפר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אפר]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אפר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אפר]],OfficeActual[#Headers],0))","v":{"v":1,"d":"₪ 1.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מאי]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מאי]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מאי]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מאי]],OfficeActual[#Headers],0))","v":{"v":-6,"d":"₪ -6.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יונ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יונ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יונ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יונ]],OfficeActual[#Headers],0))","v":{"v":10,"d":"₪ 10.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יול]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יול]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יול]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יול]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₪ 300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוג]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוג]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוג]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוג]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₪ 300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ספט]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ספט]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ספט]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ספט]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₪ 300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוק]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוק]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוק]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוק]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₪ 300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[נוב]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[נוב]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[נוב]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[נוב]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₪ 300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[דצמ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[דצמ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[דצמ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[דצמ]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₪ 300.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":1871,"d":"₪ 1,871.00"}}]
[null,"מים",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ינו]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ינו]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ינו]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ינו]],OfficeActual[#Headers],0))","v":{"v":5,"d":"₪ 5.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[פבר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[פבר]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[פבר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[פבר]],OfficeActual[#Headers],0))","v":{"v":7,"d":"₪ 7.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מרץ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מרץ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מרץ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מרץ]],OfficeActual[#Headers],0))","v":{"v":6,"d":"₪ 6.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אפר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אפר]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אפר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אפר]],OfficeActual[#Headers],0))","v":{"v":4,"d":"₪ 4.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מאי]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מאי]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מאי]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מאי]],OfficeActual[#Headers],0))","v":{"v":6,"d":"₪ 6.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יונ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יונ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יונ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יונ]],OfficeActual[#Headers],0))","v":{"v":4,"d":"₪ 4.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יול]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יול]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יול]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יול]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₪ 40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוג]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוג]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוג]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוג]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₪ 40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ספט]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ספט]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ספט]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ספט]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₪ 40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוק]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוק]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוק]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוק]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₪ 40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[נוב]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[נוב]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[נוב]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[נוב]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₪ 40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[דצמ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[דצמ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[דצמ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[דצמ]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₪ 40.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":272,"d":"₪ 272.00"}}]
[null,"טלפון",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ינו]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ינו]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ינו]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ינו]],OfficeActual[#Headers],0))","v":{"v":26,"d":"₪ 26.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[פבר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[פבר]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[פבר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[פבר]],OfficeActual[#Headers],0))","v":{"v":15,"d":"₪ 15.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מרץ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מרץ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מרץ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מרץ]],OfficeActual[#Headers],0))","v":{"v":-15,"d":"₪ -15.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אפר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אפר]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אפר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אפר]],OfficeActual[#Headers],0))","v":{"v":5,"d":"₪ 5.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מאי]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מאי]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מאי]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מאי]],OfficeActual[#Headers],0))","v":{"v":5,"d":"₪ 5.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יונ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יונ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יונ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יונ]],OfficeActual[#Headers],0))","v":{"v":30,"d":"₪ 30.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יול]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יול]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יול]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יול]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₪ 250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוג]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוג]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוג]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוג]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₪ 250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ספט]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ספט]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ספט]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ספט]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₪ 250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוק]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוק]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוק]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוק]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₪ 250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[נוב]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[נוב]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[נוב]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[נוב]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₪ 250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[דצמ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[דצמ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[דצמ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[דצמ]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₪ 250.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":1566,"d":"₪ 1,566.00"}}]
[null,"גישה לאינטרנט",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ינו]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ינו]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ינו]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ינו]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[פבר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[פבר]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[פבר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[פבר]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מרץ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מרץ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מרץ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מרץ]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אפר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אפר]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אפר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אפר]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מאי]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מאי]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מאי]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מאי]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יונ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יונ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יונ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יונ]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יול]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יול]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יול]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יול]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₪ 180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוג]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוג]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוג]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוג]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₪ 180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ספט]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ספט]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ספט]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ספט]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₪ 180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוק]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוק]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוק]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוק]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₪ 180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[נוב]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[נוב]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[נוב]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[נוב]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₪ 180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[דצמ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[דצמ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[דצמ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[דצמ]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₪ 180.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":1080,"d":"₪ 1,080.00"}}]
[null,"ציוד משרדי",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ינו]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ינו]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ינו]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ינו]],OfficeActual[#Headers],0))","v":{"v":-56,"d":"₪ -56.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[פבר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[פבר]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[פבר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[פבר]],OfficeActual[#Headers],0))","v":{"v":58,"d":"₪ 58.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מרץ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מרץ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מרץ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מרץ]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₪ 40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אפר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אפר]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אפר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אפר]],OfficeActual[#Headers],0))","v":{"v":-21,"d":"₪ -21.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מאי]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מאי]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מאי]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מאי]],OfficeActual[#Headers],0))","v":{"v":-56,"d":"₪ -56.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יונ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יונ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יונ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יונ]],OfficeActual[#Headers],0))","v":{"v":-40,"d":"₪ -40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יול]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יול]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יול]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יול]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוג]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוג]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוג]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוג]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ספט]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ספט]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ספט]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ספט]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוק]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוק]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוק]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוק]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[נוב]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[נוב]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[נוב]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[נוב]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[דצמ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[דצמ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[דצמ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[דצמ]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":1125,"d":"₪ 1,125.00"}}]
[null,"אבטחה",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ינו]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ינו]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ינו]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ינו]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[פבר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[פבר]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[פבר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[פבר]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מרץ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מרץ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מרץ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מרץ]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אפר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אפר]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אפר]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אפר]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מאי]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מאי]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[מאי]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[מאי]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יונ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יונ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יונ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יונ]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יול]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יול]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[יול]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[יול]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₪ 600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוג]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוג]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוג]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוג]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₪ 600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ספט]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ספט]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[ספט]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[ספט]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₪ 600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוק]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוק]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[אוק]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[אוק]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₪ 600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[נוב]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[נוב]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[נוב]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[נוב]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₪ 600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[דצמ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[דצמ]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[דצמ]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[דצמ]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₪ 600.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":3600,"d":"₪ 3,600.00"}}]
[null,"סכום ביניים",{"$f":"SUBTOTAL(109,OfficeVariances[ינו])","v":{"v":-17,"d":"₪ -17.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[פבר])","v":{"v":72,"d":"₪ 72.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[מרץ])","v":{"v":78,"d":"₪ 78.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[אפר])","v":{"v":-141,"d":"₪ -141.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[מאי])","v":{"v":-38,"d":"₪ -38.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[יונ])","v":{"v":16,"d":"₪ 16.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[יול])","v":{"v":11470,"d":"₪ 11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[אוג])","v":{"v":11470,"d":"₪ 11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[ספט])","v":{"v":11470,"d":"₪ 11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[אוק])","v":{"v":11470,"d":"₪ 11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[נוב])","v":{"v":11770,"d":"₪ 11,770.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[דצמ])","v":{"v":11770,"d":"₪ 11,770.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[שנה])","v":{"v":69390,"d":"₪ 69,390.00"}}]
[]
[null,"עלויות שיווק","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"אירוח אתר אינטרנט",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ינו]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ינו]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ינו]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ינו]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[פבר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[פבר]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[פבר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[פבר]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מרץ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מרץ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מרץ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מרץ]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אפר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אפר]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אפר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אפר]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מאי]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מאי]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מאי]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מאי]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יונ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יונ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יונ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יונ]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יול]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יול]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יול]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יול]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₪ 500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוג]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוג]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוג]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוג]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₪ 500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ספט]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ספט]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ספט]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ספט]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₪ 500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוק]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוק]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוק]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוק]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₪ 500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[נוב]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[נוב]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[נוב]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[נוב]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₪ 500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[דצמ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[דצמ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[דצמ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[דצמ]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₪ 500.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":3000,"d":"₪ 3,000.00"}}]
[null,"עדכוני אתר אינטרנט",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ינו]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ינו]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ינו]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ינו]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[פבר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[פבר]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[פבר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[פבר]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מרץ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מרץ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מרץ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מרץ]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אפר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אפר]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אפר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אפר]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מאי]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מאי]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מאי]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מאי]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יונ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יונ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יונ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יונ]],MarketingActual[#Headers],0))","v":{"v":-500,"d":"₪ -500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יול]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יול]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יול]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יול]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוג]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוג]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוג]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוג]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ספט]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ספט]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ספט]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ספט]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוק]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוק]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוק]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוק]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[נוב]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[נוב]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[נוב]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[נוב]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[דצמ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[דצמ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[דצמ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[דצמ]],MarketingActual[#Headers],0))","v":{"v":1000,"d":"₪ 1,000.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":1500,"d":"₪ 1,500.00"}}]
[null,"הכנת חומרי שיווק",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ינו]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ינו]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ינו]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ינו]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[פבר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[פבר]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[פבר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[פבר]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מרץ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מרץ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מרץ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מרץ]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אפר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אפר]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אפר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אפר]],MarketingActual[#Headers],0))","v":{"v":-500,"d":"₪ -500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מאי]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מאי]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מאי]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מאי]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יונ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יונ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יונ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יונ]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יול]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יול]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יול]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יול]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"₪ 5,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוג]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוג]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוג]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוג]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ספט]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ספט]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ספט]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ספט]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוק]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוק]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוק]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוק]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"₪ 5,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[נוב]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[נוב]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[נוב]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[נוב]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[דצמ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[דצמ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[דצמ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[דצמ]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₪ 0.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":9700,"d":"₪ 9,700.00"}}]
[null,"הדפסת חומרי שיווק",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ינו]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ינו]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ינו]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ינו]],MarketingActual[#Headers],0))","v":{"v":100,"d":"₪ 100.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[פבר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[פבר]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[פבר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[פבר]],MarketingActual[#Headers],0))","v":{"v":-300,"d":"₪ -300.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מרץ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מרץ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מרץ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מרץ]],MarketingActual[#Headers],0))","v":{"v":100,"d":"₪ 100.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אפר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אפר]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אפר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אפר]],MarketingActual[#Headers],0))","v":{"v":100,"d":"₪ 100.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מאי]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מאי]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מאי]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מאי]],MarketingActual[#Headers],0))","v":{"v":-400,"d":"₪ -400.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יונ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יונ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יונ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יונ]],MarketingActual[#Headers],0))","v":{"v":20,"d":"₪ 20.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יול]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יול]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יול]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יול]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוג]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוג]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוג]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוג]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ספט]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ספט]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ספט]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ספט]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוק]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוק]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוק]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוק]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[נוב]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[נוב]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[נוב]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[נוב]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[דצמ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[דצמ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[דצמ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[דצמ]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":820,"d":"₪ 820.00"}}]
[null,"אירועים שיווקיים",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ינו]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ינו]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ינו]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ינו]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[פבר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[פבר]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[פבר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[פבר]],MarketingActual[#Headers],0))","v":{"v":-200,"d":"₪ -200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מרץ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מרץ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מרץ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מרץ]],MarketingActual[#Headers],0))","v":{"v":-200,"d":"₪ -200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אפר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אפר]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אפר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אפר]],MarketingActual[#Headers],0))","v":{"v":300,"d":"₪ 300.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מאי]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מאי]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מאי]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מאי]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₪ 500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יונ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יונ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יונ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יונ]],MarketingActual[#Headers],0))","v":{"v":-300,"d":"₪ -300.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יול]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יול]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יול]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יול]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוג]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוג]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוג]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוג]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"₪ 5,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ספט]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ספט]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ספט]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ספט]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוק]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוק]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוק]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוק]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[נוב]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[נוב]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[נוב]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[נוב]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[דצמ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[דצמ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[דצמ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[דצמ]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"₪ 5,000.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":18300,"d":"₪ 18,300.00"}}]
[null,"הוצאות שונות",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ינו]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ינו]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ינו]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ינו]],MarketingActual[#Headers],0))","v":{"v":55,"d":"₪ 55.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[פבר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[פבר]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[פבר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[פבר]],MarketingActual[#Headers],0))","v":{"v":44,"d":"₪ 44.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מרץ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מרץ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מרץ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מרץ]],MarketingActual[#Headers],0))","v":{"v":77,"d":"₪ 77.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אפר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אפר]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אפר]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אפר]],MarketingActual[#Headers],0))","v":{"v":-23,"d":"₪ -23.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מאי]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מאי]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[מאי]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[מאי]],MarketingActual[#Headers],0))","v":{"v":13,"d":"₪ 13.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יונ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יונ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יונ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יונ]],MarketingActual[#Headers],0))","v":{"v":-45,"d":"₪ -45.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יול]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יול]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[יול]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[יול]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוג]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוג]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוג]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוג]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ספט]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ספט]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[ספט]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[ספט]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוק]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוק]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[אוק]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[אוק]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[נוב]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[נוב]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[נוב]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[נוב]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[דצמ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[דצמ]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[דצמ]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[דצמ]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₪ 200.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":1321,"d":"₪ 1,321.00"}}]
[null,"סכום ביניים",{"$f":"SUBTOTAL(109,MarketingVariances[ינו])","v":{"v":555,"d":"₪ 555.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[פבר])","v":{"v":-456,"d":"₪ -456.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[מרץ])","v":{"v":-23,"d":"₪ -23.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[אפר])","v":{"v":-123,"d":"₪ -123.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[מאי])","v":{"v":113,"d":"₪ 113.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[יונ])","v":{"v":-825,"d":"₪ -825.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[יול])","v":{"v":8100,"d":"₪ 8,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[אוג])","v":{"v":6100,"d":"₪ 6,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[ספט])","v":{"v":3100,"d":"₪ 3,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[אוק])","v":{"v":8100,"d":"₪ 8,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[נוב])","v":{"v":3100,"d":"₪ 3,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[דצמ])","v":{"v":6900,"d":"₪ 6,900.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[שנה])","v":{"v":34641,"d":"₪ 34,641.00"}}]
[]
[null,"הדרכה/נסיעה","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"קורסי הדרכה",{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[ינו]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[ינו]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[ינו]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[ינו]],TrainingAndTravelActual[#Headers],0))","v":{"v":400,"d":"₪ 400.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[פבר]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[פבר]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[פבר]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[פבר]],TrainingAndTravelActual[#Headers],0))","v":{"v":-400,"d":"₪ -400.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[מרץ]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[מרץ]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[מרץ]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[מרץ]],TrainingAndTravelActual[#Headers],0))","v":{"v":600,"d":"₪ 600.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[אפר]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[אפר]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[אפר]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[אפר]],TrainingAndTravelActual[#Headers],0))","v":{"v":400,"d":"₪ 400.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[מאי]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[מאי]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[מאי]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[מאי]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"₪ 800.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[יונ]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[יונ]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[יונ]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[יונ]],TrainingAndTravelActual[#Headers],0))","v":{"v":-800,"d":"₪ -800.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[יול]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[יול]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[יול]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[יול]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[אוג]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[אוג]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[אוג]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[אוג]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[ספט]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[ספט]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[ספט]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[ספט]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[אוק]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[אוק]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[אוק]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[אוק]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[נוב]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[נוב]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[נוב]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[נוב]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[דצמ]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[דצמ]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[דצמ]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[דצמ]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"SUM(TrainingAndTravelVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":13000,"d":"₪ 13,000.00"}}]
[null,"עלויות נסיעה הקשורות להדרכה",{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[ינו]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[ינו]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[ינו]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[ינו]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"₪ 800.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[פבר]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[פבר]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[פבר]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[פבר]],TrainingAndTravelActual[#Headers],0))","v":{"v":-200,"d":"₪ -200.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[מרץ]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[מרץ]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[מרץ]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[מרץ]],TrainingAndTravelActual[#Headers],0))","v":{"v":600,"d":"₪ 600.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[אפר]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[אפר]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[אפר]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[אפר]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"₪ 800.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[מאי]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[מאי]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[מאי]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[מאי]],TrainingAndTravelActual[#Headers],0))","v":{"v":1200,"d":"₪ 1,200.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[יונ]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[יונ]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[יונ]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[יונ]],TrainingAndTravelActual[#Headers],0))","v":{"v":-1500,"d":"₪ -1,500.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[יול]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[יול]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[יול]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[יול]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[אוג]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[אוג]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[אוג]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[אוג]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[ספט]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[ספט]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[ספט]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[ספט]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[אוק]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[אוק]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[אוק]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[אוק]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[נוב]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[נוב]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[נוב]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[נוב]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[דצמ]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[דצמ]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[דצמ]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[דצמ]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"SUM(TrainingAndTravelVariances[[#This Row],[ינו]:[דצמ]])","v":{"v":13700,"d":"₪ 13,700.00"}}]
[null,"סכום ביניים",{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[ינו])","v":{"v":1200,"d":"₪ 1,200.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[פבר])","v":{"v":-600,"d":"₪ -600.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[מרץ])","v":{"v":1200,"d":"₪ 1,200.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[אפר])","v":{"v":1200,"d":"₪ 1,200.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[מאי])","v":{"v":2000,"d":"₪ 2,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[יונ])","v":{"v":-2300,"d":"₪ -2,300.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[יול])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[אוג])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[ספט])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[אוק])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[נוב])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[דצמ])","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[שנה])","v":{"v":26700,"d":"₪ 26,700.00"}}]
[]
[null,"סכומים כוללים","ינו","פבר","מרץ","אפר","מאי","יונ","יול","אוג","ספט","אוק","נוב","דצמ","שנה"]
[null,"הוצאות חודשיות בפועל",{"$f":"TrainingAndTravelVariances[[#Totals],[ינו]]+MarketingVariances[[#Totals],[ינו]]+OfficeVariances[[#Totals],[ינו]]+EmployeeVariances[[#Totals],[ינו]]","v":{"v":1738,"d":"₪ 1,738.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[פבר]]+MarketingVariances[[#Totals],[פבר]]+OfficeVariances[[#Totals],[פבר]]+EmployeeVariances[[#Totals],[פבר]]","v":{"v":-984,"d":"₪ -984.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[מרץ]]+MarketingVariances[[#Totals],[מרץ]]+OfficeVariances[[#Totals],[מרץ]]+EmployeeVariances[[#Totals],[מרץ]]","v":{"v":1255,"d":"₪ 1,255.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[אפר]]+MarketingVariances[[#Totals],[אפר]]+OfficeVariances[[#Totals],[אפר]]+EmployeeVariances[[#Totals],[אפר]]","v":{"v":301,"d":"₪ 301.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[מאי]]+MarketingVariances[[#Totals],[מאי]]+OfficeVariances[[#Totals],[מאי]]+EmployeeVariances[[#Totals],[מאי]]","v":{"v":1440,"d":"₪ 1,440.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[יונ]]+MarketingVariances[[#Totals],[יונ]]+OfficeVariances[[#Totals],[יונ]]+EmployeeVariances[[#Totals],[יונ]]","v":{"v":-3744,"d":"₪ -3,744.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[יול]]+MarketingVariances[[#Totals],[יול]]+OfficeVariances[[#Totals],[יול]]+EmployeeVariances[[#Totals],[יול]]","v":{"v":134695,"d":"₪ 134,695.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[אוג]]+MarketingVariances[[#Totals],[אוג]]+OfficeVariances[[#Totals],[אוג]]+EmployeeVariances[[#Totals],[אוג]]","v":{"v":138918,"d":"₪ 138,918.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[ספט]]+MarketingVariances[[#Totals],[ספט]]+OfficeVariances[[#Totals],[ספט]]+EmployeeVariances[[#Totals],[ספט]]","v":{"v":135918,"d":"₪ 135,918.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[אוק]]+MarketingVariances[[#Totals],[אוק]]+OfficeVariances[[#Totals],[אוק]]+EmployeeVariances[[#Totals],[אוק]]","v":{"v":140918,"d":"₪ 140,918.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[נוב]]+MarketingVariances[[#Totals],[נוב]]+OfficeVariances[[#Totals],[נוב]]+EmployeeVariances[[#Totals],[נוב]]","v":{"v":136218,"d":"₪ 136,218.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[דצמ]]+MarketingVariances[[#Totals],[דצמ]]+OfficeVariances[[#Totals],[דצמ]]+EmployeeVariances[[#Totals],[דצמ]]","v":{"v":140018,"d":"₪ 140,018.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[שנה]]+MarketingVariances[[#Totals],[שנה]]+OfficeVariances[[#Totals],[שנה]]+EmployeeVariances[[#Totals],[שנה]]","v":{"v":826691,"d":"₪ 826,691.00"}}]
[null,"הוצאות כוללות בפועל",{"$f":"SUM($C$36:C36)","v":{"v":1738,"d":"₪ 1,738.00"}},{"$f":"SUM($C$36:D36)","v":{"v":754,"d":"₪ 754.00"}},{"$f":"SUM($C$36:E36)","v":{"v":2009,"d":"₪ 2,009.00"}},{"$f":"SUM($C$36:F36)","v":{"v":2310,"d":"₪ 2,310.00"}},{"$f":"SUM($C$36:G36)","v":{"v":3750,"d":"₪ 3,750.00"}},{"$f":"SUM($C$36:H36)","v":{"v":6,"d":"₪ 6.00"}},{"$f":"SUM($C$36:I36)","v":{"v":134701,"d":"₪ 134,701.00"}},{"$f":"SUM($C$36:J36)","v":{"v":273619,"d":"₪ 273,619.00"}},{"$f":"SUM($C$36:K36)","v":{"v":409537,"d":"₪ 409,537.00"}},{"$f":"SUM($C$36:L36)","v":{"v":550455,"d":"₪ 550,455.00"}},{"$f":"SUM($C$36:M36)","v":{"v":686673,"d":"₪ 686,673.00"}},{"$f":"SUM($C$36:N36)","v":{"v":826691,"d":"₪ 826,691.00"}}]

{"sheet":"ניתוח הוצאות","index":4,"n_rows":10,"n_cols":16,"rows_kept":10,"merged":[[2,4,2,6],[11,1,11,5]]}
[{"$nulls":6}," ",{"$nulls":8}," "]
[null,{"$f":"'הוצאות מתוכננות'!B2:D3","v":"שם החברה"}]
[{"$nulls":4},{"$f":"worksheet_title","v":"פירוט ההוצאות המשוערות"}]
[]
[null,"קטגוריית הוצאות","הוצאות מתוכננות","הוצאות בפועל","שונות הוצאות","אחוז שונות"]
[null,"עלויות עובדים",{"$f":"EmployeePlan[[#Totals],[שנה]]","v":{"v":1355090,"d":"₪ 1,355,090.00"}},{"$f":"EmployeeActual[[#Totals],[שנה]]","v":{"v":659130,"d":"₪ 659,130.00"}},{"$f":"C6-D6","v":{"v":695960,"d":"₪ 695,960.00"}},{"$f":"E6/C6","v":{"v":0.5135895032802249,"d":"51%"}}]
[null,{"$f":"'הוצאות מתוכננות'!B10","v":"עלויות משרדיות"},{"$f":"OfficePlan[[#Totals],[שנה]]","v":{"v":138740,"d":"₪ 138,740.00"}},{"$f":"OfficeActual[[#Totals],[שנה]]","v":{"v":69350,"d":"₪ 69,350.00"}},{"$f":"C7-D7","v":{"v":69390,"d":"₪ 69,390.00"}},{"$f":"E7/C7","v":{"v":0.5001441545336601,"d":"50%"}}]
[null,{"$f":"'הוצאות מתוכננות'!B21","v":"עלויות שיווק"},{"$f":"MarketingPlan[[#Totals],[שנה]]","v":{"v":67800,"d":"₪ 67,800.00"}},{"$f":"MarketingActual[[#Totals],[שנה]]","v":{"v":33159,"d":"₪ 33,159.00"}},{"$f":"C8-D8","v":{"v":34641,"d":"₪ 34,641.00"}},{"$f":"E8/C8","v":{"v":0.510929203539823,"d":"51%"}}]
[null,{"$f":"'הוצאות מתוכננות'!B30","v":"הדרכה/נסיעה"},{"$f":"TrainingAndTravelPlan[[#Totals],[שנה]]","v":{"v":48000,"d":"₪ 48,000.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[שנה]]","v":{"v":21300,"d":"₪ 21,300.00"}},{"$f":"C9-D9","v":{"v":26700,"d":"₪ 26,700.00"}},{"$f":"E9/C9","v":{"v":0.55625,"d":"56%"}}]
[null,{"$f":"'הוצאות מתוכננות'!B35","v":"סכומים כוללים"},{"$f":"'הוצאות מתוכננות'!O36","v":{"v":1609630,"d":"₪ 1,609,630.00"}},{"$f":"'הוצאות בפועל'!O36","v":{"v":782939,"d":"₪ 782,939.00"}},{"$f":"C10-D10","v":{"v":826691,"d":"₪ 826,691.00"}},{"$f":"E10/C10","v":{"v":0.5135907009685455,"d":"51%"}}]