{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["משפך מכירות לקמפיין","scratch"],"not_rendered":{"charts":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"משפך מכירות לקמפיין","index":0,"n_rows":9,"n_cols":6,"rows_kept":9,"merged":[[0,1,0,4],[0,5,13,15],[1,1,1,4],[8,1,9,4]]}
[null,"משפך מכירות",{"$nulls":3},"תרשים משפך מכירות שמציג את שלבי המכירות ואת הנתונים המתאימים נמצא בתא זה."]
[null,"לקמפיין"]
[null,"שלב","קשרים פוטנציאליים","הפסדים","לא אושרו"]
[null,"זוהו",250,20,9]
[null,"נוצר קשר",150,15]
[null,"דיון",100,35]
[null,"זכיות",15]
[]
[null,"עצה: הזן את הנתונים שלך בתאים שלעיל כדי לעדכן את תרשים משפך המכירות."]

{"sheet":"scratch","index":1,"n_rows":17,"n_cols":36,"rows_kept":17,"hidden":true}
["*** גיליון זה צריך להישאר מוסתר ***"]
[]
[]
[]
[]
[]
[null,"Y ממוצע:",{"$f":"AVERAGE(AD13:AE13)","v":183}]
[]
[{"$nulls":29},{"$f":"AA12/2+8+50","v":183}]
[{"$nulls":4},"סדרות אחוזים ותוויות",{"$nulls":4},"סכומים כוללים לשלב ותוויות",{"$nulls":4},"סכומים כוללים ותוויות - הפסדים",{"$nulls":4},"סכום כולל ותווית - לא אושרו",{"$nulls":4},"קצוות"]
[null,"שלב","x",null,"הפרשים",null,0.45,{"$f":"3.85%*C7","v":7.0455},null,"הפרשים",null,0.45,{"$f":"-3.85%*C7","v":-7.0455},null,"הפרשים",null,0.45,{"$f":"-19.2%*C7","v":-35.136},null,"הפרשים",null,0.45,{"$f":"-25.7%*C7","v":-47.031},null,1.8,{"$nulls":4},{"$f":"AD12-8","v":50},{"$f":"AE12+8","v":316}]
[null,"מסגרת",null,null,"תווית","ערך","x","y",null,"תווית","ערך","x","y",null,"תווית","ערך","x","y",null,"תווית","ערך","x","y",null,2,null,{"$f":"K13","v":250},"זוהו",null,{"$f":"-AA12/2+$AD$9","v":58},{"$f":"AA12/2+$AD$9","v":308},null,{"$f":"AE12","v":308},0,0,0]
[null,"זוהו",2,null,{"$f":"F13","v":{"v":1,"d":"100%"}},{"v":1,"d":"100%"},{"$f":"$C13+G$11","v":2.45},{"$f":"$C$7+$H$11","v":190.0455},null,{"$f":"UPPER(B13)&\" \"&K13","v":"זוהו 250"},{"$f":"'משפך מכירות לקמפיין'!C4","v":250},{"$f":"$C13+L$11","v":2.45},{"$f":"$C$7+$M$11","v":175.9545},null,{"$f":"\"הפסדים \" & P13","v":"הפסדים 20"},{"$f":"'משפך מכירות לקמפיין'!D4","v":20},{"$f":"$C13+Q$11","v":2.45},{"$f":"$C$7+$R$11","v":147.864},null,{"$f":"\"לא אושרו \"&U13","v":"לא אושרו 9"},{"$f":"'משפך מכירות לקמפיין'!E4","v":9},{"$f":"$C13+V$11","v":2.45},{"$f":"$C$7+$W$11","v":135.969},null,{"$f":"Y12+1","v":3},null,null,"זוהו",null,{"$f":"-K13/2+$AD$9","v":58},{"$f":"K13/2+$AD$9","v":308},null,{"$f":"AE13","v":308},{"$f":"AE13","v":308},0,0]
[null,"נוצר קשר",3,null,{"$f":"F14","v":{"v":0.6,"d":"60%"}},{"$f":"'משפך מכירות לקמפיין'!C5/'משפך מכירות לקמפיין'!$C$4","v":{"v":0.6,"d":"60%"}},{"$f":"$C14+G$11","v":3.45},{"$f":"$C$7+$H$11","v":190.0455},null,{"$f":"UPPER(B14)&\" \"&K14","v":"נוצר קשר 150"},{"$f":"'משפך מכירות לקמפיין'!C5","v":150},{"$f":"$C14+L$11","v":3.45},{"$f":"$C$7+$M$11","v":175.9545},null,{"$f":"\"הפסדים \" & P14","v":"הפסדים 15"},{"$f":"'משפך מכירות לקמפיין'!D5","v":15},{"$f":"$C14+Q$11","v":3.45},{"$f":"$C$7+$R$11","v":147.864},{"$nulls":6},{"$f":"Y13+1","v":4},null,null,"נוצר קשר",null,{"$f":"-K14/2+$AD$9","v":108},{"$f":"K14/2+$AD$9","v":258},null,null,{"$f":"AE14","v":258},{"$f":"AE14","v":258},0]
[null,"דיון",4,null,{"$f":"F15","v":{"v":0.4,"d":"40%"}},{"$f":"'משפך מכירות לקמפיין'!C6/'משפך מכירות לקמפיין'!$C$4","v":{"v":0.4,"d":"40%"}},{"$f":"$C15+G$11","v":4.45},{"$f":"$C$7+$H$11","v":190.0455},null,{"$f":"UPPER(B15)&\" \"&K15","v":"דיון 100"},{"$f":"'משפך מכירות לקמפיין'!C6","v":100},{"$f":"$C15+L$11","v":4.45},{"$f":"$C$7+$M$11","v":175.9545},null,{"$f":"\"הפסדים \" & P15","v":"הפסדים 35"},{"$f":"'משפך מכירות לקמפיין'!D6","v":35},{"$f":"$C15+Q$11","v":4.45},{"$f":"$C$7+$R$11","v":147.864},{"$nulls":6},{"$f":"Y14+1","v":5},null,null,"דיון",null,{"$f":"-K15/2+$AD$9","v":133},{"$f":"K15/2+$AD$9","v":233},{"$nulls":3},{"$f":"AE15","v":233},{"$f":"AE15","v":233}]
[null,"זכיות",5,null,{"$f":"F16","v":{"v":0.06,"d":"6%"}},{"$f":"'משפך מכירות לקמפיין'!C7/'משפך מכירות לקמפיין'!$C$4","v":{"v":0.06,"d":"6%"}},{"$f":"$C16+G$11 - 0.1","v":5.3500000000000005},{"$f":"$C$7+$H$11","v":190.0455},null,{"$f":"UPPER(B16)","v":"זכיות"},{"$f":"'משפך מכירות לקמפיין'!C7","v":15},{"$f":"$C16+L$11 -0.1","v":5.3500000000000005},{"$f":"$C$7+$M$11","v":175.9545},{"$nulls":11},{"$f":"Y15+1","v":6},null,null,"זכיות",null,{"$f":"-K16/2+$AD$9","v":175.5},{"$f":"K16/2+$AD$9","v":190.5},{"$nulls":4},{"$f":"AE16","v":190.5}]
[null,"זכיות - נקודה",6,{"$nulls":7},{"$f":"K16","v":15},6.44,{"$f":"C7","v":183}]