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

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

{"sheet":"תקציב שיווק לערוצי הפצה","index":1,"n_rows":70,"n_cols":17,"rows_kept":70,"merged":[[0,1,0,19],[1,16,1,19],[2,16,2,19],[4,16,4,19],[5,16,5,19],[35,16,35,19],[36,16,36,19],[37,16,37,19],[38,16,38,19],[39,16,39,19],[40,16,40,19]]}
[]
[null," ","תעריף","חודש 1","חודש 2","חודש 3","חודש 4","חודש 5","חודש 6","חודש 7","חודש 8","חודש 9","חודש 10","חודש 11","חודש 12",null,"סה\"כ"]
[null,"סה\"כ מכירות צפויות (000) דולר"," ",750,200,500,{"v":1500,"d":"1,500"},{"v":1200,"d":"1,200"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1800,"d":"1,800"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},null,{"$f":"SUM(D3:O3)","v":{"v":16950,"d":"16,950"}}]
["הזן פרטים בטבלה 'כוח אדם', החל מהתא שמשמאל. 'הסכום הכולל של כוח האדם' עבור כל חודש מחושב באופן אוטומטי בסוף הטבלה ו'הסכום הכולל' השנתי מופיע בתא Q9. תרשים זעיר מתעדכן בתא S9. ההוראה הבאה מופיעה בתא A10.","פריטי כוח אדם","תעריף","חודש 1","חודש 2","חודש 3","חודש 4","חודש 5","חודש 6","חודש 7","חודש 8","חודש 9","חודש 10","חודש 11","חודש 12"]
[null,"כוח אדם (% מסה\"כ המכירות)",null,{"$f":"D11+D36+D44+D51","v":{"v":1.1,"d":"110%"}},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":0.8500000000000001,"d":"85%"},{"v":0.8500000000000001,"d":"85%"},{"v":0.8500000000000001,"d":"85%"},{"v":0.8500000000000001,"d":"85%"}]
[null,"משאבי אנוש - מספר עובדים",5,{"$f":"+$C$6","v":5},5,5,5,5,5,5,5,5,5,5,5]
[null,"משאבי אנוש - עלות",null,{"$f":"$C$6*D6","v":{"v":25,"d":"25.00"}},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D7:$O7)","v":{"v":300,"d":"300.00"}}]
[null,"עמלה",{"v":1E-3,"d":"0.10%"},{"$f":"D3*$C$8","v":0.75},{"v":0.2,"d":"0.20"},{"v":0.5,"d":"0.50"},{"v":1.5,"d":"1.50"},{"v":1.2,"d":"1.20"},{"v":1.5,"d":"1.50"},{"v":1.5,"d":"1.50"},{"v":1.8,"d":"1.80"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D8:$O8)","v":{"v":16.950000000000003,"d":"16.95"}}]
[null,"סה\"כ כוח אדם (000) דולר",null,{"$f":"SUM(D7:D8)","v":25.75},{"$f":"SUM(E7:E8)","v":{"v":25.2,"d":"25.20"}},{"v":25.5,"d":"25.50"},{"v":26.5,"d":"26.50"},{"v":26.2,"d":"26.20"},{"v":26.5,"d":"26.50"},{"v":26.5,"d":"26.50"},{"v":26.8,"d":"26.80"},{"v":27,"d":"27.00"},{"v":27,"d":"27.00"},{"v":27,"d":"27.00"},{"v":27,"d":"27.00"},null,{"$f":"SUM(Q7:Q8)","v":316.95}]
[null,"פריטי שיווק ישיר","תעריף","חודש 1","חודש 2","חודש 3","חודש 4","חודש 5","חודש 6","חודש 7","חודש 8","חודש 9","חודש 10","חודש 11","חודש 12"]
[null,"שיווק ישיר (% מסך כל המכירות)",null,{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":0.75,"d":"75%"},{"v":0.4,"d":"40%"},{"v":0.33,"d":"33%"},{"v":0.25,"d":"25%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"}]
[null,"טלמרקטינג (% מהמכירות הישירות)",null,{"v":1,"d":"100%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"}]
[null,"משאבי אנוש - מספר עובדים",3,{"$f":"$C$13*D12","v":3},1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D13:$O13)","v":{"v":19.5,"d":"19.50"}}]
[null,"תמיכה בתשתית",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D14:$O14)","v":{"v":210,"d":"210.00"}}]
[null,"עמלה",{"v":1E-3,"d":"0.10%"},{"$f":"$C$15*D3*D11*D12","v":0.75},{"v":0.1,"d":"0.10"},{"v":0.1875,"d":"0.19"},{"v":0.30000000000000004,"d":"0.30"},{"v":0.198,"d":"0.20"},{"v":0.1875,"d":"0.19"},{"v":0.15000000000000002,"d":"0.15"},{"v":0.09000000000000001,"d":"0.09"},0.05,0.05,0.05,0.05,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D15:$O15)","v":{"v":2.163,"d":"2.16"}}]
[null,"הדרכה",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D16:$O16)","v":{"v":210,"d":"210.00"}}]
[null,"סה\"כ טלמרקטינג (000) דולר",null,{"$f":"SUM(D13:D16)","v":53.75},{"$f":"SUM(E13:E16)","v":{"v":21.6,"d":"21.60"}},{"$f":"SUM(F13:F16)","v":{"v":51.6875,"d":"51.69"}},{"v":21.8,"d":"21.80"},{"v":51.698,"d":"51.70"},{"v":21.6875,"d":"21.69"},51.65,21.59,51.55,21.55,51.55,21.55,null,{"$f":"SUM(Q13:Q16)","v":{"v":441.663,"d":"441.66"}}]
[null,"פריטי שיווק באינטרנט","תעריף","חודש 1","חודש 2","חודש 3","חודש 4","חודש 5","חודש 6","חודש 7","חודש 8","חודש 9","חודש 10","חודש 11","חודש 12"]
[null,"שיווק באינטרנט (% מהמכירות הישירות)",null,{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"}]
[null,"משאבי אנוש - מספר עובדים",1,{"$f":"$C$20*D19","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D20:$O20)","v":{"v":3,"d":"3.00"}}]
[null,"פיתוח אתר אינטרנט (עלות חד-פעמית)",null,500,{"$nulls":12},{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D21:$O21)","v":{"v":500,"d":"500.00"}}]
[null,"אירוח",null,10,10,10,10,10,10,10,10,10,10,10,10,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D22:$O22)","v":{"v":120,"d":"120.00"}}]
[null,"תמיכה ותחזוקה",null,25,{"$nulls":9},25,null,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D23:$O23)","v":{"v":50,"d":"50.00"}}]
[null,"Facebook",null,null,100,null,100,null,100,null,100,null,100,null,100,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D24:$O24)","v":{"v":600,"d":"600.00"}}]
[null,"Twitter",null,100,null,100,null,100,null,100,null,100,null,100,null,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D25:$O25)","v":{"v":600,"d":"600.00"}}]
[null,"YouTube",null,null,100,null,100,100,{"$nulls":3},100,100,null,100,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D26:$O26)","v":{"v":600,"d":"600.00"}}]
[null,"סה\"כ שיווק באינטרנט (000) דולר",null,{"$f":"SUM(D20:D23)","v":535.25},10.25,10.25,10.25,10.25,10.25,10.25,10.25,10.25,10.25,35.25,10.25,null,{"$f":"SUM(Q20:Q23)","v":{"v":673,"d":"673.00"}}]
[null,"פריטי דואר ישיר","תעריף","חודש 1","חודש 2","חודש 3","חודש 4","חודש 5","חודש 6","חודש 7","חודש 8","חודש 9","חודש 10","חודש 11","חודש 12"]
[null,"דואר ישיר (% מהמכירות הישירות)"]
[null,"משאבי אנוש - עלות",{"$nulls":14},{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D30:$O30)","v":{"v":0,"d":"0.00"}}]
[null,"חומרים",null,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D31:$O31)","v":{"v":12000,"d":"12,000.00"}}]
[null,"דמי דואר",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D32:$O32)","v":{"v":3000,"d":"3,000.00"}}]
[null,"סה\"כ דואר ישיר (000) דולר",null,{"$f":"SUM(D30:D32)","v":{"v":1250,"d":"1,250.00"}},{"$f":"SUM(E30:E32)","v":{"v":1250,"d":"1,250.00"}},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},null,{"$f":"SUM(Q30:Q32)","v":{"v":15000,"d":"15,000.00"}}]
[null,"סה\"כ שיווק ישיר (000) דולר",null,{"$f":"SUM(דואר_ישיר[[#Totals],[חודש 1]],שיווק_באינטרנט[[#Totals],[חודש 1]],שיווק_ישיר[[#Totals],[חודש 1]])","v":{"v":1839,"d":"1,839.00"}},{"$f":"SUM(דואר_ישיר[[#Totals],[חודש 2]],שיווק_באינטרנט[[#Totals],[חודש 2]],שיווק_ישיר[[#Totals],[חודש 2]])","v":{"v":1281.85,"d":"1,281.85"}},{"$f":"SUM(דואר_ישיר[[#Totals],[חודש 3]],שיווק_באינטרנט[[#Totals],[חודש 3]],שיווק_ישיר[[#Totals],[חודש 3]])","v":{"v":1311.9375,"d":"1,311.94"}},{"$f":"SUM(דואר_ישיר[[#Totals],[חודש 4]],שיווק_באינטרנט[[#Totals],[חודש 4]],שיווק_ישיר[[#Totals],[חודש 4]])","v":{"v":1282.05,"d":"1,282.05"}},{"$f":"SUM(דואר_ישיר[[#Totals],[חודש 5]],שיווק_באינטרנט[[#Totals],[חודש 5]],שיווק_ישיר[[#Totals],[חודש 5]])","v":{"v":1311.948,"d":"1,311.95"}},{"$f":"SUM(דואר_ישיר[[#Totals],[חודש 6]],שיווק_באינטרנט[[#Totals],[חודש 6]],שיווק_ישיר[[#Totals],[חודש 6]])","v":{"v":1281.9375,"d":"1,281.94"}},{"$f":"SUM(דואר_ישיר[[#Totals],[חודש 7]],שיווק_באינטרנט[[#Totals],[חודש 7]],שיווק_ישיר[[#Totals],[חודש 7]])","v":{"v":1311.9,"d":"1,311.90"}},{"$f":"SUM(דואר_ישיר[[#Totals],[חודש 8]],שיווק_באינטרנט[[#Totals],[חודש 8]],שיווק_ישיר[[#Totals],[חודש 8]])","v":{"v":1281.84,"d":"1,281.84"}},{"$f":"SUM(דואר_ישיר[[#Totals],[חודש 9]],שיווק_באינטרנט[[#Totals],[חודש 9]],שיווק_ישיר[[#Totals],[חודש 9]])","v":{"v":1311.8,"d":"1,311.80"}},{"$f":"SUM(דואר_ישיר[[#Totals],[חודש 10]],שיווק_באינטרנט[[#Totals],[חודש 10]],שיווק_ישיר[[#Totals],[חודש 10]])","v":{"v":1281.8,"d":"1,281.80"}},{"$f":"SUM(דואר_ישיר[[#Totals],[חודש 11]],שיווק_באינטרנט[[#Totals],[חודש 11]],שיווק_ישיר[[#Totals],[חודש 11]])","v":{"v":1336.8,"d":"1,336.80"}},{"$f":"SUM(דואר_ישיר[[#Totals],[חודש 12]],שיווק_באינטרנט[[#Totals],[חודש 12]],שיווק_ישיר[[#Totals],[חודש 12]])","v":{"v":1281.8,"d":"1,281.80"}},null,{"$f":"SUM(Q33,Q27,Q17,Q9)","v":{"v":16431.613,"d":"16,431.61"}}]
[null,"פריטי סוכן/מתווך","תעריף","חודש 1","חודש 2","חודש 3","חודש 4","חודש 5","חודש 6","חודש 7","חודש 8","חודש 9","חודש 10","חודש 11","חודש 12"]
[null,"סוכן/מתווך (% מסך כל המכירות)",null,{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"}]
[null,"תקשורת",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D37:$O37)","v":{"v":600,"d":"600.00"}}]
[null,"הדרכה",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"},null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D38:$O38)","v":{"v":3000,"d":"3,000.00"}}]
[null,"מבצעים",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"},null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D39:$O39)","v":{"v":7200,"d":"7,200.00"}}]
[null,"הנחות",{"v":0.1,"d":"10.00%"},{"$f":"D3*D36*$C$40","v":{"v":7.5,"d":"7.50"}},{"v":2,"d":"2.00"},{"v":5,"d":"5.00"},{"v":15,"d":"15.00"},{"v":12,"d":"12.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":18,"d":"18.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D40:$O40)","v":{"v":169.5,"d":"169.50"}}]
[null,"עמלה (% מהמכירות של הסוכן)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D36*$C$41","v":{"v":7.5,"d":"7.50"}},{"v":2,"d":"2.00"},{"v":5,"d":"5.00"},{"v":15,"d":"15.00"},{"v":12,"d":"12.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":18,"d":"18.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D41:$O41)","v":{"v":169.5,"d":"169.50"}}]
[null,"סה\"כ סוכן/מתווך (000) דולר",null,{"$f":"SUM(D37:D41)","v":{"v":915,"d":"915.00"}},{"$f":"SUM(E37:E41)","v":{"v":904,"d":"904.00"}},{"v":910,"d":"910.00"},{"v":930,"d":"930.00"},{"v":924,"d":"924.00"},{"v":930,"d":"930.00"},{"v":930,"d":"930.00"},{"v":936,"d":"936.00"},{"v":940,"d":"940.00"},{"v":940,"d":"940.00"},{"v":940,"d":"940.00"},{"v":940,"d":"940.00"},null,{"$f":"SUM(Q37:Q41)","v":{"v":11139,"d":"11,139.00"}}]
[null,"פריטי מפיצים","תעריף","חודש 1","חודש 2","חודש 3","חודש 4","חודש 5","חודש 6","חודש 7","חודש 8","חודש 9","חודש 10","חודש 11","חודש 12"]
[null,"מפיצים (% מסך כל המכירות)",null,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.15,"d":"15%"},{"v":0.2,"d":"20%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"}]
[null,"תקשורת",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D45:$O45)","v":{"v":600,"d":"600.00"}}]
[null,"הדרכה",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"},null,{"$f":"SUM(מפיצים[[#This Row],[חודש 1]:[חודש 12]])","v":{"v":3000,"d":"3,000.00"}}]
[null,"מבצעים",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"},null,{"$f":"SUM(מפיצים[[#This Row],[חודש 1]:[חודש 12]])","v":{"v":7200,"d":"7,200.00"}}]
[null,"עמלה/הנחות (% מהמכירות של מפיצים)",{"v":0.15,"d":"15.00%"},{"$f":"D3*D44*$C$48","v":0},0,0,0,0,33.75,45,108,120,120,120,120,null,{"$f":"SUM(מפיצים[[#This Row],[חודש 1]:[חודש 12]])","v":666.75}]
[null,"סה\"כ מפיצים (000) דולר",null,{"$f":"SUM(D45:D48)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E45:E48)","v":{"v":900,"d":"900.00"}},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},933.75,{"v":945,"d":"945.00"},{"v":1008,"d":"1,008.00"},{"v":1020,"d":"1,020.00"},{"v":1020,"d":"1,020.00"},{"v":1020,"d":"1,020.00"},{"v":1020,"d":"1,020.00"},null,{"$f":"SUM(Q45:Q48)","v":{"v":11466.75,"d":"11,466.75"}}]
[null,"פריטי קמעונאות","תעריף","חודש 1","חודש 2","חודש 3","חודש 4","חודש 5","חודש 6","חודש 7","חודש 8","חודש 9","חודש 10","חודש 11","חודש 12"]
[null,"קמעונאות (% מסך כל המכירות)",null,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.25,"d":"25%"},{"v":0.6,"d":"60%"},{"v":0.67,"d":"67%"},{"v":0.6,"d":"60%"},{"v":0.6,"d":"60%"},{"v":0.5,"d":"50%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"}]
[null,"תקשורת",null,50,50,50,50,50,50,50,50,50,50,50,50]
[null,"הדרכה",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"},null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D52:$O52)","v":{"v":600,"d":"600.00"}}]
[null,"מבצעים",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"},null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D53:$O53)","v":{"v":3000,"d":"3,000.00"}}]
[null,"עמלה/הנחות (% מהמכירות הקמעונאיות)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D51*$C$55","v":0},0,12.5,90,80.4,90,90,90,60,60,60,60,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D55:$O55)","v":{"v":692.9,"d":"692.90"}}]
[null,"סה\"כ קמעונאות (000) דולר",null,{"$f":"SUM(D52:D55)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E52:E55)","v":{"v":900,"d":"900.00"}},{"v":912.5,"d":"912.50"},{"v":990,"d":"990.00"},{"v":980.4,"d":"980.40"},{"v":990,"d":"990.00"},{"v":990,"d":"990.00"},{"v":990,"d":"990.00"},{"v":960,"d":"960.00"},{"v":960,"d":"960.00"},{"v":960,"d":"960.00"},{"v":960,"d":"960.00"},null,{"$f":"SUM(Q53:Q55)","v":{"v":4292.9,"d":"4,292.90"}}]
[null,"פריטי גיוס ושימור לקוחות (CAR)","תעריף","חודש 1","חודש 2","חודש 3","חודש 4","חודש 5","חודש 6","חודש 7","חודש 8","חודש 9","חודש 10","חודש 11","חודש 12"]
[null,"גיוס ושימור לקוחות (CAR)"]
[null,"משאבי אנוש",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D59:$O59)","v":{"v":600,"d":"600.00"}}]
[null,"תקשורת",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"},null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D60:$O60)","v":{"v":3000,"d":"3,000.00"}}]
[null,"מבצעים/קופונים",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D61:$O61)","v":{"v":7200,"d":"7,200.00"}}]
[null,"סה\"כ גיוס ושימור לקוחות (000) דולר",null,{"$f":"SUM(D59:D61)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E59:E61)","v":{"v":900,"d":"900.00"}},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},null,{"$f":"SUM(Q59:Q61)","v":{"v":10800,"d":"10,800.00"}}]
[null,"פריטי הוצאות אחרות","תעריף","חודש 1","חודש 2","חודש 3","חודש 4","חודש 5","חודש 6","חודש 7","חודש 8","חודש 9","חודש 10","חודש 11","חודש 12"]
[null,"הוצאות אחרות"]
[null,"נסיעות",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D65:$O65)","v":{"v":600,"d":"600.00"}}]
[null,"תשתית (מחשבים, טלפונים וכד')",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"},null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D66:$O66)","v":{"v":3000,"d":"3,000.00"}}]
[null,"תמיכה בערוצי הפצה",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('תקציב שיווק לערוצי הפצה'!$D67:$O67)","v":{"v":7200,"d":"7,200.00"}}]
[null,"סה\"כ הוצאות אחרות (000) דולר",null,{"$f":"SUM(D65:D67)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E65:E67)","v":{"v":900,"d":"900.00"}},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},null,{"$f":"SUM(Q65:Q67)","v":{"v":10800,"d":"10,800.00"}}]
[]
[null,"סה\"כ תקציב שיווק:",null,{"$f":"SUM(D34,סוכנים_וברוקרים[[#Totals],[חודש 1]],מפיצים[[#Totals],[חודש 1]],קמעונאות[[#Totals],[חודש 1]],רכב[[#Totals],[חודש 1]],הוצאות_אחרות[[#Totals],[חודש 1]])","v":{"v":6354,"d":"6,354.00"}},{"$f":"SUM(הוצאות_אחרות[[#Totals],[חודש 2]],רכב[[#Totals],[חודש 2]],קמעונאות[[#Totals],[חודש 2]],מפיצים[[#Totals],[חודש 2]],סוכנים_וברוקרים[[#Totals],[חודש 2]],E34)","v":{"v":5785.85,"d":"5,785.85"}},{"$f":"SUM(הוצאות_אחרות[[#Totals],[חודש 3]],רכב[[#Totals],[חודש 3]],קמעונאות[[#Totals],[חודש 3]],מפיצים[[#Totals],[חודש 3]],סוכנים_וברוקרים[[#Totals],[חודש 3]],F34)","v":{"v":5834.4375,"d":"5,834.44"}},{"$f":"SUM(הוצאות_אחרות[[#Totals],[חודש 4]],רכב[[#Totals],[חודש 4]],קמעונאות[[#Totals],[חודש 4]],מפיצים[[#Totals],[חודש 4]],סוכנים_וברוקרים[[#Totals],[חודש 4]],G34)","v":{"v":5902.05,"d":"5,902.05"}},{"$f":"SUM(הוצאות_אחרות[[#Totals],[חודש 5]],רכב[[#Totals],[חודש 5]],קמעונאות[[#Totals],[חודש 5]],מפיצים[[#Totals],[חודש 5]],סוכנים_וברוקרים[[#Totals],[חודש 5]],H34)","v":{"v":5916.348,"d":"5,916.35"}},{"$f":"SUM(הוצאות_אחרות[[#Totals],[חודש 6]],רכב[[#Totals],[חודש 6]],קמעונאות[[#Totals],[חודש 6]],מפיצים[[#Totals],[חודש 6]],סוכנים_וברוקרים[[#Totals],[חודש 6]],I34)","v":{"v":5935.6875,"d":"5,935.69"}},{"$f":"SUM(הוצאות_אחרות[[#Totals],[חודש 7]],רכב[[#Totals],[חודש 7]],קמעונאות[[#Totals],[חודש 7]],מפיצים[[#Totals],[חודש 7]],סוכנים_וברוקרים[[#Totals],[חודש 7]],J34)","v":{"v":5976.9,"d":"5,976.90"}},{"$f":"SUM(הוצאות_אחרות[[#Totals],[חודש 8]],רכב[[#Totals],[חודש 8]],קמעונאות[[#Totals],[חודש 8]],מפיצים[[#Totals],[חודש 8]],סוכנים_וברוקרים[[#Totals],[חודש 8]],K34)","v":{"v":6015.84,"d":"6,015.84"}},{"$f":"SUM(הוצאות_אחרות[[#Totals],[חודש 9]],רכב[[#Totals],[חודש 9]],קמעונאות[[#Totals],[חודש 9]],מפיצים[[#Totals],[חודש 9]],סוכנים_וברוקרים[[#Totals],[חודש 9]],L34)","v":{"v":6031.8,"d":"6,031.80"}},{"$f":"SUM(הוצאות_אחרות[[#Totals],[חודש 10]],רכב[[#Totals],[חודש 10]],קמעונאות[[#Totals],[חודש 10]],מפיצים[[#Totals],[חודש 10]],סוכנים_וברוקרים[[#Totals],[חודש 10]],M34)","v":{"v":6001.8,"d":"6,001.80"}},{"$f":"SUM(הוצאות_אחרות[[#Totals],[חודש 11]],רכב[[#Totals],[חודש 11]],קמעונאות[[#Totals],[חודש 11]],מפיצים[[#Totals],[חודש 11]],סוכנים_וברוקרים[[#Totals],[חודש 11]],N34)","v":{"v":6056.8,"d":"6,056.80"}},{"$f":"SUM(הוצאות_אחרות[[#Totals],[חודש 12]],רכב[[#Totals],[חודש 12]],קמעונאות[[#Totals],[חודש 12]],מפיצים[[#Totals],[חודש 12]],סוכנים_וברוקרים[[#Totals],[חודש 12]],O34)","v":{"v":6001.8,"d":"6,001.80"}},null,{"$f":"Q72","v":{"v":0,"d":"0.00"}}]