{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["חשוב","xlookup  בתוך  xlookup","xlookup + xlookup","search X 3","רגישות סדר 1","רגישות סדר 1 DMIN","חתירה למטרה minIfs","סינון ומיון דינמיים","שם משתמש וסיסמה","חשוב ביותר"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":4,"defined_names":13,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"חשוב","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"xlookup  בתוך  xlookup","index":1,"n_rows":52,"n_cols":18,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,7,2,16],[8,10,8,15],[31,0,33,15]]}
["מעמד לקוח","תחילת ההשקעה","סכום השקעה ","מספר קרן","ערך השקעה נכון להיום","ערך ההשקעה בשקלים",null,null,null,null,null,null,null,null,null,null,null,"ערך ההשקעה בשקלים"]
["שכיר","2022-09-15",2500,10,16761.877886011072,{"$f":"(E2-_xlfn.XLOOKUP(A2,$L$25:$L$27,_xlfn.XLOOKUP(D2,$M$24:$Q$24,$M$25:$Q$27))*E2)*$K$21","v":45206.784658571865},null,"חוק: בכל פעם שנקבל טבלה עם קטגוריות בשורות ובעמודות (דומה לריבוע הקסם) נעבוד עם XLOOKUP בתוך XLOOKUP",null,null,null,null,null,null,null,null,null,{"$f":"(Q2-(_xlfn.XLOOKUP(L2,$Q$13:$Q$15,_xlfn.XLOOKUP(O2,$R$12:$V$12,$R$13:$V$15)))*Q2)*$N$4","v":45206.784658571865}]
["עצמאי","2022-03-12",146726,13,214094.11260178176,{"$f":"(E3-_xlfn.XLOOKUP(A3,$L$25:$L$27,_xlfn.XLOOKUP(D3,$M$24:$Q$24,$M$25:$Q$27))*E3)*$K$21","v":530953.39925241878},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q3-(_xlfn.XLOOKUP(L3,$Q$13:$Q$15,_xlfn.XLOOKUP(O3,$R$12:$V$12,$R$13:$V$15)))*Q3)*$N$4","v":530953.39925241878}]
["שכיר","2022-09-29",253094,10,307637.33883750002,{"$f":"(E4-_xlfn.XLOOKUP(A4,$L$25:$L$27,_xlfn.XLOOKUP(D4,$M$24:$Q$24,$M$25:$Q$27))*E4)*$K$21","v":829697.90284473763},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q4-(_xlfn.XLOOKUP(L4,$Q$13:$Q$15,_xlfn.XLOOKUP(O4,$R$12:$V$12,$R$13:$V$15)))*Q4)*$N$4","v":829697.90284473763}]
["שכיר","2022-12-29",70131,14,332458.09982047207,{"$f":"(E5-_xlfn.XLOOKUP(A5,$L$25:$L$27,_xlfn.XLOOKUP(D5,$M$24:$Q$24,$M$25:$Q$27))*E5)*$K$21","v":917251.89740468236},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q5-(_xlfn.XLOOKUP(L5,$Q$13:$Q$15,_xlfn.XLOOKUP(O5,$R$12:$V$12,$R$13:$V$15)))*Q5)*$N$4","v":917251.89740468236}]
["שכיר","2022-02-05",63372,15,1229261.9753939065,{"$f":"(E6-_xlfn.XLOOKUP(A6,$L$25:$L$27,_xlfn.XLOOKUP(D6,$M$24:$Q$24,$M$25:$Q$27))*E6)*$K$21","v":3429640.911348999},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q6-(_xlfn.XLOOKUP(L6,$Q$13:$Q$15,_xlfn.XLOOKUP(O6,$R$12:$V$12,$R$13:$V$15)))*Q6)*$N$4","v":3429640.911348999}]
["עצמאי","2022-05-19",72483,15,1877660.4186721272,{"$f":"(E7-_xlfn.XLOOKUP(A7,$L$25:$L$27,_xlfn.XLOOKUP(D7,$M$24:$Q$24,$M$25:$Q$27))*E7)*$K$21","v":4947635.2032010555},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q7-(_xlfn.XLOOKUP(L7,$Q$13:$Q$15,_xlfn.XLOOKUP(O7,$R$12:$V$12,$R$13:$V$15)))*Q7)*$N$4","v":4947635.2032010555}]
["עצמאי","2022-07-11",108877,13,986671.12314671697,{"$f":"(E8-_xlfn.XLOOKUP(A8,$L$25:$L$27,_xlfn.XLOOKUP(D8,$M$24:$Q$24,$M$25:$Q$27))*E8)*$K$21","v":2446944.385403858},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q8-(_xlfn.XLOOKUP(L8,$Q$13:$Q$15,_xlfn.XLOOKUP(O8,$R$12:$V$12,$R$13:$V$15)))*Q8)*$N$4","v":2446944.385403858}]
["עצמאי","2022-05-05",96681,10,191421.76696540037,{"$f":"(E9-_xlfn.XLOOKUP(A9,$L$25:$L$27,_xlfn.XLOOKUP(D9,$M$24:$Q$24,$M$25:$Q$27))*E9)*$K$21","v":522198.58028161217},null,null,null,null,"במבחן קיבלנו את טבלת העזר הבאה:",null,null,null,null,null,null,{"$f":"(Q9-(_xlfn.XLOOKUP(L9,$Q$13:$Q$15,_xlfn.XLOOKUP(O9,$R$12:$V$12,$R$13:$V$15)))*Q9)*$N$4","v":522198.58028161217}]
["עצמאי","2022-10-27",66590,15,377756.68354481296,{"$f":"(E10-_xlfn.XLOOKUP(A10,$L$25:$L$27,_xlfn.XLOOKUP(D10,$M$24:$Q$24,$M$25:$Q$27))*E10)*$K$21","v":995388.86114058213},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q10-(_xlfn.XLOOKUP(L10,$Q$13:$Q$15,_xlfn.XLOOKUP(O10,$R$12:$V$12,$R$13:$V$15)))*Q10)*$N$4","v":995388.86114058213}]
["בעל שליטה","2022-05-26",224708,10,3453180.5195543682,{"$f":"(E11-_xlfn.XLOOKUP(A11,$L$25:$L$27,_xlfn.XLOOKUP(D11,$M$24:$Q$24,$M$25:$Q$27))*E11)*$K$21","v":9206179.2651319467},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q11-(_xlfn.XLOOKUP(L11,$Q$13:$Q$15,_xlfn.XLOOKUP(O11,$R$12:$V$12,$R$13:$V$15)))*Q11)*$N$4","v":9206179.2651319467}]
["שכיר","2022-07-17",49492,14,2044762.0534205888,{"$f":"(E12-_xlfn.XLOOKUP(A12,$L$25:$L$27,_xlfn.XLOOKUP(D12,$M$24:$Q$24,$M$25:$Q$27))*E12)*$K$21","v":5641498.5053874049},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q12-(_xlfn.XLOOKUP(M24,$Q$13:$Q$15,_xlfn.XLOOKUP(P24,$R$12:$V$12,$R$13:$V$15)))*Q12)*$N$4","v":5641498.5053874049}]
["שכיר","2022-04-28",76982,13,2617985.4305046364,{"$f":"(E13-_xlfn.XLOOKUP(A13,$L$25:$L$27,_xlfn.XLOOKUP(D13,$M$24:$Q$24,$M$25:$Q$27))*E13)*$K$21","v":5924501.0292319916},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q13-(_xlfn.XLOOKUP(M25,$Q$13:$Q$15,_xlfn.XLOOKUP(P25,$R$12:$V$12,$R$13:$V$15)))*Q13)*$N$4","v":5924501.0292319916}]
["בעל שליטה","2022-09-13",184883,10,2226133.6383189736,{"$f":"(E14-_xlfn.XLOOKUP(A14,$L$25:$L$27,_xlfn.XLOOKUP(D14,$M$24:$Q$24,$M$25:$Q$27))*E14)*$K$21","v":5934872.2797583835},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q14-(_xlfn.XLOOKUP(M26,$Q$13:$Q$15,_xlfn.XLOOKUP(P26,$R$12:$V$12,$R$13:$V$15)))*Q14)*$N$4","v":5934872.2797583835}]
["בעל שליטה","2022-10-12",8780,10,122381.75185310727,{"$f":"(E15-_xlfn.XLOOKUP(A15,$L$25:$L$27,_xlfn.XLOOKUP(D15,$M$24:$Q$24,$M$25:$Q$27))*E15)*$K$21","v":326269.75044038403},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q15-(_xlfn.XLOOKUP(M27,$Q$13:$Q$15,_xlfn.XLOOKUP(P27,$R$12:$V$12,$R$13:$V$15)))*Q15)*$N$4","v":326269.75044038403}]
["שכיר","2022-11-18",46900,14,80582.931834117058,{"$f":"(E16-_xlfn.XLOOKUP(A16,$L$25:$L$27,_xlfn.XLOOKUP(D16,$M$24:$Q$24,$M$25:$Q$27))*E16)*$K$21","v":222328.30893032896},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q16-(_xlfn.XLOOKUP(L16,$Q$13:$Q$15,_xlfn.XLOOKUP(O16,$R$12:$V$12,$R$13:$V$15)))*Q16)*$N$4","v":222328.30893032896}]
["שכיר","2022-05-25",162174,14,1078268.712803452,{"$f":"(E17-_xlfn.XLOOKUP(A17,$L$25:$L$27,_xlfn.XLOOKUP(D17,$M$24:$Q$24,$M$25:$Q$27))*E17)*$K$21","v":2974943.3786247242},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q17-(_xlfn.XLOOKUP(L17,$Q$13:$Q$15,_xlfn.XLOOKUP(O17,$R$12:$V$12,$R$13:$V$15)))*Q17)*$N$4","v":2974943.3786247242}]
["שכיר","2022-12-09",10321,14,372444.86881914415,{"$f":"(E18-_xlfn.XLOOKUP(A18,$L$25:$L$27,_xlfn.XLOOKUP(D18,$M$24:$Q$24,$M$25:$Q$27))*E18)*$K$21","v":1027575.3930720187},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q18-(_xlfn.XLOOKUP(L18,$Q$13:$Q$15,_xlfn.XLOOKUP(O18,$R$12:$V$12,$R$13:$V$15)))*Q18)*$N$4","v":1027575.3930720187}]
["שכיר","2022-06-22",56091,15,1453028.3037917621,{"$f":"(E19-_xlfn.XLOOKUP(A19,$L$25:$L$27,_xlfn.XLOOKUP(D19,$M$24:$Q$24,$M$25:$Q$27))*E19)*$K$21","v":4053948.9675790165},null,null,null,null,"השאלה ממועד ב 2023, שאלה מספר 1, 10 נקודות",null,null,null,null,null,null,{"$f":"(Q19-(_xlfn.XLOOKUP(L19,$Q$13:$Q$15,_xlfn.XLOOKUP(O19,$R$12:$V$12,$R$13:$V$15)))*Q19)*$N$4","v":4053948.9675790165}]
["עצמאי","2022-07-10",12866,10,133822.73527755728,{"$f":"(E20-_xlfn.XLOOKUP(A20,$L$25:$L$27,_xlfn.XLOOKUP(D20,$M$24:$Q$24,$M$25:$Q$27))*E20)*$K$21","v":365068.42183717625},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q20-(_xlfn.XLOOKUP(L20,$Q$13:$Q$15,_xlfn.XLOOKUP(O20,$R$12:$V$12,$R$13:$V$15)))*Q20)*$N$4","v":365068.42183717625}]
["עצמאי","2022-07-01",71270,13,142479.52031448073,{"$f":"(E21-_xlfn.XLOOKUP(A21,$L$25:$L$27,_xlfn.XLOOKUP(D21,$M$24:$Q$24,$M$25:$Q$27))*E21)*$K$21","v":353349.21037991223},null,null,null,null,3.1,"שער הדולר שנתון",null,null,null,null,null,{"$f":"(Q21-(_xlfn.XLOOKUP(L21,$Q$13:$Q$15,_xlfn.XLOOKUP(O21,$R$12:$V$12,$R$13:$V$15)))*Q21)*$N$4","v":353349.21037991223}]
["עצמאי","2022-02-01",10129,14,22812.44860458418,{"$f":"(E22-_xlfn.XLOOKUP(A22,$L$25:$L$27,_xlfn.XLOOKUP(D22,$M$24:$Q$24,$M$25:$Q$27))*E22)*$K$21","v":57989.244352852991},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q22-(_xlfn.XLOOKUP(L22,$Q$13:$Q$15,_xlfn.XLOOKUP(O22,$R$12:$V$12,$R$13:$V$15)))*Q22)*$N$4","v":57989.244352852991}]
["בעל שליטה","2022-01-17",143689,13,1900016.8003544933,{"$f":"(E23-_xlfn.XLOOKUP(A23,$L$25:$L$27,_xlfn.XLOOKUP(D23,$M$24:$Q$24,$M$25:$Q$27))*E23)*$K$21","v":4417539.0608241968},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q23-(_xlfn.XLOOKUP(L23,$Q$13:$Q$15,_xlfn.XLOOKUP(O23,$R$12:$V$12,$R$13:$V$15)))*Q23)*$N$4","v":4417539.0608241968}]
["בעל שליטה","2022-02-09",25719,12,186489.11906743521,{"$f":"(E24-_xlfn.XLOOKUP(A24,$L$25:$L$27,_xlfn.XLOOKUP(D24,$M$24:$Q$24,$M$25:$Q$27))*E24)*$K$21","v":508742.31681596325},null,null,null,null,null,"מעמד לקוח/מספר קרן",10,13,14,15,12,{"$f":"(#REF!-(_xlfn.XLOOKUP(#REF!,$Q$13:$Q$15,_xlfn.XLOOKUP(#REF!,$R$12:$V$12,$R$13:$V$15)))*#REF!)*$N$4","v":{"$error":"#REF!"}}]
["שכיר","2022-09-16",215746,14,1094342.8807251898,{"$f":"(E25-_xlfn.XLOOKUP(A25,$L$25:$L$27,_xlfn.XLOOKUP(D25,$M$24:$Q$24,$M$25:$Q$27))*E25)*$K$21","v":3019292.0079207988},null,null,null,null,null,"עצמאי",0.12,0.2,0.18,0.15,0.09,{"$f":"(#REF!-(_xlfn.XLOOKUP(#REF!,$Q$13:$Q$15,_xlfn.XLOOKUP(#REF!,$R$12:$V$12,$R$13:$V$15)))*#REF!)*$N$4","v":{"$error":"#REF!"}}]
["בעל שליטה","2022-11-28",131191,10,203520.29998243746,{"$f":"(E26-_xlfn.XLOOKUP(A26,$L$25:$L$27,_xlfn.XLOOKUP(D26,$M$24:$Q$24,$M$25:$Q$27))*E26)*$K$21","v":542585.11975317821},null,null,null,null,null,"בעל שליטה",0.14000000000000001,0.25,0.16,0.14000000000000001,0.12,{"$f":"(#REF!-(_xlfn.XLOOKUP(#REF!,$Q$13:$Q$15,_xlfn.XLOOKUP(#REF!,$R$12:$V$12,$R$13:$V$15)))*#REF!)*$N$4","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"שכיר",0.13,0.27,0.11,0.1,0.26]
[]
[]
[]
[]
["דוגמה נוספת ממועד א 2023 שפותרים אותה בעזרת איקס-לוק-אפ בתוך איקס-לוק-אפ:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"הטבת לקוח פר חודש התקשרות ועיר מגורים"]
[]
[null,null,"רבעון / עיר","רעננה","כפר סבא","חולון","ראשון לציון","רחובות","נס-ציונה","הרצליה","יבנה","ירושלים","חיפה","באר שבע","קרית אתא"]
[null,null,"רבעון 1","מוצר חינם","זיכוי ברכישה הבאה","אין הטבה","הנחה על הרכישה הבאה","זיכוי ברכישה הבאה","מוצר חינם","זיכוי ברכישה הבאה","הנחה על הרכישה הבאה","אין הטבה","זיכוי ברכישה הבאה","אין הטבה","הנחה על הרכישה הבאה"]
[null,null,"רבעון 2","הנחה על הרכישה הבאה","זיכוי ברכישה הבאה","הנחה על הרכישה הבאה","מוצר חינם","אין הטבה","זיכוי ברכישה הבאה","הנחה על הרכישה הבאה","מוצר חינם","זיכוי ברכישה הבאה","הנחה על הרכישה הבאה","מוצר חינם","הנחה על הרכישה הבאה"]
[null,null,"רבעון 3","אין הטבה","הנחה על הרכישה הבאה","מוצר חינם","הנחה על הרכישה הבאה","זיכוי ברכישה הבאה","הנחה על הרכישה הבאה","מוצר חינם","זיכוי ברכישה הבאה","זיכוי ברכישה הבאה","מוצר חינם","זיכוי ברכישה הבאה","אין הטבה"]
[null,null,"רבעון 4","מוצר חינם","הנחה על הרכישה הבאה","זיכוי ברכישה הבאה","זיכוי ברכישה הבאה","הנחה על הרכישה הבאה","מוצר חינם","זיכוי ברכישה הבאה","אין הטבה","זיכוי ברכישה הבאה","אין הטבה","זיכוי ברכישה הבאה","מוצר חינם"]

{"sheet":"xlookup + xlookup","index":2,"n_rows":59,"n_cols":26,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,24,1,25],[11,24,11,25]]}
["שם פרטי לקוח","שם משפחה לקוח","כתובת דוא\"ל","תאריך הרכישה","שעת הרכישה","דגם הרכב ","סיווג הרכב","שם הסוכנות","מיקום הסוכנות","תאריך עליית הרכב לכביש","מחיר יבואן ","מספר ק\"מ ","שם משתמש","סיסמה","מחיר רכישה",null,null,"תוספת סיווג","אחוזXמחיר יבואן","אחוז ממחיר יבואן","שם החברה","מיקום קו תחתון"]
["יוסי","שמעון","ELVLSUAM@colman.ac.il","2022-08-02","17:10:35","Mazda_6","פרטי","רכבי דניאלס","יהוד","2010-06-29",132100,53490,{"$f":"MID(B2,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D2,\"MMM\")","v":"מע#אוג"},{"$f":"LEN(C2)&LEFT(F2,'[2]נתוני עזר'!$A$15)&HOUR(E2)","v":"21Maz17"},{"$f":"S2+R2","v":92570},null,{"$f":"_xlfn.XLOOKUP(LEFT(F2,SEARCH($Y$21,F2)-$Y$22),$Z$4:$Z$8,$Y$4:$Y$8,$Z$10)*K2+_xlfn.XLOOKUP(G2,$Z$14:$Z$17,$Y$14:$Y$17)/MINUTE(E2)","v":92570},{"$f":"_xlfn.XLOOKUP(G2,$Z$14:$Z$17,$Y$14:$Y$17)/MINUTE(E2)","v":100},{"$f":"T2*K2","v":92470},{"$f":"_xlfn.XLOOKUP(LEFT(F2,SEARCH($Y$21,F2)-$Y$22),$Z$4:$Z$8,$Y$4:$Y$8,$Z$10)","v":0.7},{"$f":"LEFT(F2,SEARCH($Y$21,F2)-$Y$22)","v":"Mazda"},{"$f":"SEARCH($Y$21,F2)","v":6},null,null,"טבלה מס' 1"]
["נטע","פוקס","KEZZLDMD@colman.ac.il","2022-05-03","19:16:55","Mazda_6","פרטי","גלגלי הזהב","חולון","2011-03-29",132100,25829,{"$f":"MID(B3,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D3,\"MMM\")","v":"וק#מאי"},{"$f":"LEN(C3)&LEFT(F3,'[2]נתוני עזר'!$A$15)&HOUR(E3)","v":"21Maz19"},{"$f":"S3+R3","v":92532.5},null,{"$f":"_xlfn.XLOOKUP(LEFT(F3,SEARCH($Y$21,F3)-$Y$22),$Z$4:$Z$8,$Y$4:$Y$8,$Z$10)*K3+_xlfn.XLOOKUP(G3,$Z$14:$Z$17,$Y$14:$Y$17)/MINUTE(E3)","v":92532.5},{"$f":"_xlfn.XLOOKUP(G3,$Z$14:$Z$17,$Y$14:$Y$17)/MINUTE(E3)","v":62.5},{"$f":"T3*K3","v":92470},{"$f":"_xlfn.XLOOKUP(LEFT(F3,SEARCH($Y$21,F3)-$Y$22),$Z$4:$Z$8,$Y$4:$Y$8,$Z$10)","v":0.7},{"$f":"LEFT(F3,SEARCH($Y$21,F3)-$Y$22)","v":"Mazda"},{"$f":"SEARCH($Y$21,F3)","v":6},null,null,"אחוז ממחיר יבואן","סוג רכב"]
["אורי","גוזמן","BEXLDPPA11@ynet.co.il","2022-02-19","17:20:28.333","Citroen_C3","פרטי","רכב דיל מאיר","חיפה","2011-01-15",125000,65509,{"$f":"MID(B4,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D4,\"MMM\")","v":"וז#פבר"},{"$f":"LEN(C4)&LEFT(F4,'[2]נתוני עזר'!$A$15)&HOUR(E4)","v":"21Cit17"},68800,null,68800,50,68750,0.55000000000000004,"Citroen",8,null,null,0.6,"Nissan"]
["אורן","ברבור","COZ66@walla.co.il","2022-06-28","17:09:30.994","Honda_Civic","פרטי","גלגלי הזהב","חולון","2009-05-24",119200,31704,{"$f":"MID(B5,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D5,\"MMM\")","v":"רב#יונ"},{"$f":"LEN(C5)&LEFT(F5,'[2]נתוני עזר'!$A$15)&HOUR(E5)","v":"17Hon17"},53751.111111111109,null,53751.111111111109,111.11111111111111,53640,0.45,"Honda",6,null,null,0.7,"Mazda"]
["אבי ","ברלב","SVET6@walla.co.il","2022-11-08","19:35:47.084","Citroen_C5","פרטי","גלגלי הזהב","חולון","2010-10-04",114500,28286,{"$f":"MID(B6,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D6,\"MMM\")","v":"רל#נוב"},{"$f":"LEN(C6)&LEFT(F6,'[2]נתוני עזר'!$A$15)&HOUR(E6)","v":"17Cit19"},63003.571428571435,null,63003.571428571435,28.571428571428573,62975.000000000007,0.55000000000000004,"Citroen",8,null,null,0.8,"BMW"]
["נוי","סליקטר","VWQXYKIY@colman.ac.il","2022-05-07","18:16:10","Mazda_3","פרטי","סוכנות המוביל","תל אביב","2011-04-03",99200,99037,{"$f":"MID(B7,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D7,\"MMM\")","v":"לי#מאי"},{"$f":"LEN(C7)&LEFT(F7,'[2]נתוני עזר'!$A$15)&HOUR(E7)","v":"21Maz18"},69502.5,null,69502.5,62.5,69440,0.7,"Mazda",6,null,null,0.75,"Audi"]
["אמיר","שרון","AUTBPAME@ynet.co.il","2022-09-15","16:07:25","BMW_Z4","פרטי","סוכנות המוביל","תל אביב","2011-08-11",185200,23650,{"$f":"MID(B8,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D8,\"MMM\")","v":"רו#ספט"},{"$f":"LEN(C8)&LEFT(F8,'[2]נתוני עזר'!$A$15)&HOUR(E8)","v":"19BMW16"},148302.85714285713,null,148302.85714285713,142.85714285714286,148160,0.8,"BMW",4,null,null,0.55000000000000004,"Citroen"]
["אאוגן ","ליבוביץ","YIDOJL@colman.ac.il","2022-07-29","13:51:02","renault_kangoo","מסחרי","רכבי דניאלס","יהוד","2011-06-25",148000,56507,{"$f":"MID(B9,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D9,\"MMM\")","v":"יב#יול"},{"$f":"LEN(C9)&LEFT(F9,'[2]נתוני עזר'!$A$15)&HOUR(E9)","v":"19ren13"},66623.529411764699,null,66623.529411764699,23.529411764705884,66600,0.45,"renault",8]
["מיכל","בן עמי","KE78OMD@colman.ac.il","2022-10-31","13:33:55","toyota_hilux","מסחרי","סוכנות המוביל","תל אביב","2010-09-27",135200,76935,{"$f":"MID(B10,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D10,\"MMM\")","v":"ן #אוק"},{"$f":"LEN(C10)&LEFT(F10,'[2]נתוני עזר'!$A$15)&HOUR(E10)","v":"20toy13"},60876.36363636364,null,60876.36363636364,36.363636363636367,60840,0.45,"toyota",7,null,null,null,0.45]
["מושיקו","דגנוש","BDZJHBUB@colman.ac.il","2022-06-19","16:20:30.696","Audi_A4","פרטי","רכב דיל מאיר","חיפה","2008-05-15",133200,43076,{"$f":"MID(B11,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D11,\"MMM\")","v":"גנ#יונ"},{"$f":"LEN(C11)&LEFT(F11,'[2]נתוני עזר'!$A$15)&HOUR(E11)","v":"21Aud16"},99950,null,99950,50,99900,0.75,"Audi",5]
["אבי ","היינריך","FF22WT@ynet.co.il","2022-06-03","15:46:52","Nissan_Juke","גיפ","רכב דיל מאיר","חיפה","2008-04-30",133200,13221,{"$f":"MID(B12,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D12,\"MMM\")","v":"יי#יונ"},{"$f":"LEN(C12)&LEFT(F12,'[2]נתוני עזר'!$A$15)&HOUR(E12)","v":"17Nis15"},79950.434782608689,null,79950.434782608689,30.434782608695652,79920,0.6,"Nissan",7,null,null,"טבלה מס' 2"]
["עמית","כהן","EAUDGT@colman.ac.il","2022-09-14","11:51:37.007","Honda_Accord","פרטי","סוכנות המוביל","תל אביב","2011-08-10",125900,40682,{"$f":"MID(B13,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D13,\"MMM\")","v":"הן#ספט"},{"$f":"LEN(C13)&LEFT(F13,'[2]נתוני עזר'!$A$15)&HOUR(E13)","v":"19Hon11"},56674.607843137252,null,56674.607843137252,19.607843137254903,56655,0.45,"Honda",6,null,null,"תוספת סיווג","סווג הרכב"]
["אריק","לוין","FFNGQQWT@ynet.co.il","2023-01-10","14:09:00.555","Audi_A4","פרטי","רכב דיל","בני ברק","2008-12-06",125300,23927,{"$f":"MID(B14,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D14,\"MMM\")","v":"וי#ינו"},{"$f":"LEN(C14)&LEFT(F14,'[2]נתוני עזר'!$A$15)&HOUR(E14)","v":"19Aud14"},0,null,null,null,null,null,null,null,null,null,1000,"פרטי"]
["מור","גולדברג","JXI45LUBY@colman.ac.il","2022-03-28","14:01:39","Nissan_Micra","פרטי","גלגלי הזהב","חולון","2008-02-24",117200,28169,{"$f":"MID(B15,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D15,\"MMM\")","v":"ול#מרץ"},{"$f":"LEN(C15)&LEFT(F15,'[2]נתוני עזר'!$A$15)&HOUR(E15)","v":"22Nis14"},0,null,null,null,null,null,null,null,null,null,1200,"מסחרי"]
["ענבר","יפת","KIEAUDGT@colman.ac.il","2022-09-10","14:32:09","Nissan_Pathfinder","מסחרי","גלגלי הזהב","חולון","2011-08-06",114500,22743,{"$f":"MID(B16,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D16,\"MMM\")","v":"פת#ספט"},{"$f":"LEN(C16)&LEFT(F16,'[2]נתוני עזר'!$A$15)&HOUR(E16)","v":"21Nis14"},0,null,null,null,null,null,null,null,null,null,1400,"גיפ"]
["עדי","גירו","EXOOYULR@colman.ac.il","2023-01-26","14:23:21.892","Audi_A6","מנהלים","רכבי דניאלס","יהוד","2010-12-22",114500,10716,{"$f":"MID(B17,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D17,\"MMM\")","v":"יר#ינו"},{"$f":"LEN(C17)&LEFT(F17,'[2]נתוני עזר'!$A$15)&HOUR(E17)","v":"21Aud14"},0,null,null,null,null,null,null,null,null,null,1600,"מנהלים"]
["אלכס","עמרמי ויצמן","FAOL5@walla.co.il","2022-07-13","13:55:29","Honda_Civic","פרטי","רכב דיל","בני ברק","2008-06-09",114500,40383,{"$f":"MID(B18,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D18,\"MMM\")","v":"מר#יול"},{"$f":"LEN(C18)&LEFT(F18,'[2]נתוני עזר'!$A$15)&HOUR(E18)","v":"17Hon13"},0]
["אבי ","אור אורטרגר","CTA86@walla.co.il","2022-10-26","15:48:53","Subaru_B4","פרטי","רכב דיל","בני ברק","2010-09-22",112500,20389,{"$f":"MID(B19,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D19,\"MMM\")","v":"ור#אוק"},{"$f":"LEN(C19)&LEFT(F19,'[2]נתוני עזר'!$A$15)&HOUR(E19)","v":"17Sub15"},0]
["רם","אברמוביץ","XPDDXH@colman.ac.il","2022-04-19","16:37:49.888","toyota_hilux","מסחרי","רכב דיל מאיר","חיפה","2010-03-15",112000,38679,{"$f":"MID(B20,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D20,\"MMM\")","v":"בר#אפר"},{"$f":"LEN(C20)&LEFT(F20,'[2]נתוני עזר'!$A$15)&HOUR(E20)","v":"19toy16"},0,null,null,null,null,null,null,null,null,null,"תאי עזר"]
["עומר","יגאנה","WTUUETX@ynet.co.il","2022-10-15","13:38:56.356","Audi_A3","פרטי","רכבי דניאלס","יהוד","2009-09-11",110410,26284,{"$f":"MID(B21,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D21,\"MMM\")","v":"גא#אוק"},{"$f":"LEN(C21)&LEFT(F21,'[2]נתוני עזר'!$A$15)&HOUR(E21)","v":"18Aud13"},0,null,null,null,null,null,null,null,null,null,"_"]
["אסי","וידר","JXIELUBY@colman.ac.il","2022-05-15","09:24:14.616","fiat_ducato","מסחרי","רכב דיל","בני ברק","2008-04-11",106000,6474,{"$f":"MID(B22,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D22,\"MMM\")","v":"יד#מאי"},{"$f":"LEN(C22)&LEFT(F22,'[2]נתוני עזר'!$A$15)&HOUR(E22)","v":"21fia9"},0,null,null,null,null,null,null,null,null,null,1]
["אאוריקה ","גורכוב","MYGLDVTD@colman.ac.il","2022-06-21","10:58:13.226","Nissan_Navare","מסחרי","סוכנות המוביל","תל אביב","2011-05-17",103000,57178,{"$f":"MID(B23,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D23,\"MMM\")","v":"ור#יונ"},{"$f":"LEN(C23)&LEFT(F23,'[2]נתוני עזר'!$A$15)&HOUR(E23)","v":"21Nis10"},0]
["אאוג'ן ","מנוליאו","NYIAVES@colman.ac.il","2022-07-08","16:17:18","BMW_325","פרטי","סוכנות המוביל","תל אביב","2011-06-04",99600,18823,{"$f":"MID(B24,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D24,\"MMM\")","v":"נו#יול"},{"$f":"LEN(C24)&LEFT(F24,'[2]נתוני עזר'!$A$15)&HOUR(E24)","v":"20BMW16"},0]
["שירי","מנור","GIMI89FG@walla.co.il","2022-10-13","14:29:31.541","Mazda_3","פרטי","סוכנות המוביל","תל אביב","2011-09-09",92200,63326,{"$f":"MID(B25,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D25,\"MMM\")","v":"נו#אוק"},{"$f":"LEN(C25)&LEFT(F25,'[2]נתוני עזר'!$A$15)&HOUR(E25)","v":"20Maz14"},0]
["טלי","רונן","FADIKOL55@walla.co.il","2022-07-20","12:51:18","Mazda_3","פרטי","רכבי דניאלס","יהוד","2009-06-16",90890,48294,{"$f":"MID(B26,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D26,\"MMM\")","v":"ונ#יול"},{"$f":"LEN(C26)&LEFT(F26,'[2]נתוני עזר'!$A$15)&HOUR(E26)","v":"21Maz12"},0]
["שרה","שוורץ","RVPNJHQO33@ynet.co.il","2022-10-30","12:56:34.880","Mazda_6","פרטי","רכב דיל","בני ברק","2010-09-26",90890,8931,{"$f":"MID(B27,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D27,\"MMM\")","v":"וו#אוק"},{"$f":"LEN(C27)&LEFT(F27,'[2]נתוני עזר'!$A$15)&HOUR(E27)","v":"21Maz12"},0]
["יאנה","גלון","RAV8O@walla.co.il","2022-09-27","09:29:23","Audi_A6","מנהלים","גלגלי הזהב","חולון","2008-08-23",90890,50833,{"$f":"MID(B28,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D28,\"MMM\")","v":"לו#ספט"},{"$f":"LEN(C28)&LEFT(F28,'[2]נתוני עזר'!$A$15)&HOUR(E28)","v":"17Aud9"},0]
["תומר","בוקאי","RAV7U8O@walla.co.il","2022-11-26","10:05:24","renault_kangoo","מסחרי","סוכנות המוביל","תל אביב","2009-10-22",90100,74516,{"$f":"MID(B29,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D29,\"MMM\")","v":"וק#נוב"},{"$f":"LEN(C29)&LEFT(F29,'[2]נתוני עזר'!$A$15)&HOUR(E29)","v":"19ren10"},0]
["דניאלה","שטיין","EXOOIS5@colman.ac.il","2022-10-09","14:05:53.175","BMW_325","פרטי","רכבי דניאלס","יהוד","2010-09-05",89000,38944,{"$f":"MID(B30,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D30,\"MMM\")","v":"טי#אוק"},{"$f":"LEN(C30)&LEFT(F30,'[2]נתוני עזר'!$A$15)&HOUR(E30)","v":"20BMW14"},0]
["מור","אילומים","YXYQGYVQ@colman.ac.il","2022-04-25","09:02:29.426","Volkswagen_Passat","פרטי","סוכנות המוביל","תל אביב","2008-03-21",85300,40146,{"$f":"MID(B31,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D31,\"MMM\")","v":"יל#אפר"},{"$f":"LEN(C31)&LEFT(F31,'[2]נתוני עזר'!$A$15)&HOUR(E31)","v":"21Vol9"},0]
["אמה","בנוב","RV7HQO33@ynet.co.il","2022-03-28","12:38:25.082","Honda_Civic","פרטי","רכבי דניאלס","יהוד","2008-02-24",79000,33741,{"$f":"MID(B32,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D32,\"MMM\")","v":"נו#מרץ"},{"$f":"LEN(C32)&LEFT(F32,'[2]נתוני עזר'!$A$15)&HOUR(E32)","v":"19Hon12"},0]
["גלי","גרבר","SVETR@walla.co.il","2022-08-07","15:35:40.927","Hyundai_Tuscon","גיפ","סוכנות המוביל","תל אביב","2009-07-03",69900,52888,{"$f":"MID(B33,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D33,\"MMM\")","v":"רב#אוג"},{"$f":"LEN(C33)&LEFT(F33,'[2]נתוני עזר'!$A$15)&HOUR(E33)","v":"17Hyu15"},0]
["אבי ","רינגל","BD12BUB@colman.ac.il","2022-05-17","09:52:31.682","Subaru_B4","פרטי","סוכנות המוביל","תל אביב","2008-04-13",42320,34120,{"$f":"MID(B34,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D34,\"MMM\")","v":"ינ#מאי"},{"$f":"LEN(C34)&LEFT(F34,'[2]נתוני עזר'!$A$15)&HOUR(E34)","v":"20Sub9"},0]
["צחי","וינר","JILI6@yahoo.com","2023-01-27","19:07:43.211","Audi_A6","מנהלים","סוכנות המוביל","תל אביב","2010-12-23",156000,54194,{"$f":"MID(B35,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D35,\"MMM\")","v":"ינ#ינו"},{"$f":"LEN(C35)&LEFT(F35,'[2]נתוני עזר'!$A$15)&HOUR(E35)","v":"15Aud19"},0]
["אריה","אונרוביל","TAB@hotmail.com","2022-09-21","18:16:34.929","Hyundai_Tuscon","גיפ","רכב דיל מאיר","חיפה","2010-08-17",148000,37483,{"$f":"MID(B36,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D36,\"MMM\")","v":"ונ#ספט"},{"$f":"LEN(C36)&LEFT(F36,'[2]נתוני עזר'!$A$15)&HOUR(E36)","v":"15Hyu18"},0]
["רואי","חנוביץ","GT67JK@yahoo.com","2022-09-28","17:02:19","Nissan_qashqai","גיפ","רכב דיל","בני ברק","2009-08-24",132100,20688,{"$f":"MID(B37,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D37,\"MMM\")","v":"נו#ספט"},{"$f":"LEN(C37)&LEFT(F37,'[2]נתוני עזר'!$A$15)&HOUR(E37)","v":"16Nis17"},0]
["לישי","ברמן","LCMAHAOP@hotmail.com","2022-04-11","18:23:19.898","Nissan_Micra","פרטי","סוכנות המוביל","תל אביב","2008-03-07",114600,56149,{"$f":"MID(B38,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D38,\"MMM\")","v":"רמ#אפר"},{"$f":"LEN(C38)&LEFT(F38,'[2]נתוני עזר'!$A$15)&HOUR(E38)","v":"20Nis18"},0]
["לנה","יצחקי","TUKU7K@yahoo.com","2022-11-15","19:26:56.881","toyota_hilux","מסחרי","רכב דיל","בני ברק","2008-10-11",98700,39354,{"$f":"MID(B39,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D39,\"MMM\")","v":"צח#נוב"},{"$f":"LEN(C39)&LEFT(F39,'[2]נתוני עזר'!$A$15)&HOUR(E39)","v":"16toy19"},0]
["דור","וויינר","RVHJHDT@gmail.com","2022-05-18","17:02:22.317","Audi_A3","פרטי","רכב דיל","בני ברק","2009-04-14",97800,17489,{"$f":"MID(B40,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D40,\"MMM\")","v":"וי#מאי"},{"$f":"LEN(C40)&LEFT(F40,'[2]נתוני עזר'!$A$15)&HOUR(E40)","v":"17Aud17"},0]
["נדב","רווח","RFANLGI22@gmail.com","2022-12-09","10:49:57","Ford_Focus","פרטי","רכב דיל מאיר","חיפה","2010-11-05",148000,60630,{"$f":"MID(B41,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D41,\"MMM\")","v":"וו#דצמ"},{"$f":"LEN(C41)&LEFT(F41,'[2]נתוני עזר'!$A$15)&HOUR(E41)","v":"19For10"},0]
["אלון","כהן","XIJDGGVC@gmail.com","2022-12-09","14:58:59.772","Nissan_Navare","מסחרי","גלגלי הזהב","חולון","2011-11-05",133500,30206,{"$f":"MID(B42,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D42,\"MMM\")","v":"הן#דצמ"},{"$f":"LEN(C42)&LEFT(F42,'[2]נתוני עזר'!$A$15)&HOUR(E42)","v":"18Nis14"},0]
["אאוריקה ","יאסין","YEGB@hotmail.com","2022-08-25","14:44:53.260","Citroen_C3","פרטי","רכב דיל מאיר","חיפה","2010-07-21",133200,37698,{"$f":"MID(B43,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D43,\"MMM\")","v":"אס#אוג"},{"$f":"LEN(C43)&LEFT(F43,'[2]נתוני עזר'!$A$15)&HOUR(E43)","v":"16Cit14"},0]
["שירי","הסנר","GZBJLAY@gmail.com","2022-12-20","16:33:01.363","Hyundai_Tuscon","גיפ","רכב דיל מאיר","חיפה","2011-11-16",124900,49309,{"$f":"MID(B44,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D44,\"MMM\")","v":"סנ#דצמ"},{"$f":"LEN(C44)&LEFT(F44,'[2]נתוני עזר'!$A$15)&HOUR(E44)","v":"17Hyu16"},0]
["נועם","מי דן","PAB@hotmail.com","2022-06-23","16:43:58.850","Volkswagen_Golf","פרטי","רכב דיל מאיר","חיפה","2009-05-19",122300,6330,{"$f":"MID(B45,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D45,\"MMM\")","v":"י #יונ"},{"$f":"LEN(C45)&LEFT(F45,'[2]נתוני עזר'!$A$15)&HOUR(E45)","v":"15Vol16"},0]
["אסי","כצוביץ","MIKI6@yahoo.com","2023-01-26","12:36:06.172","Honda_Accord","פרטי","רכבי דניאלס","יהוד","2008-12-22",118800,43882,{"$f":"MID(B46,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D46,\"MMM\")","v":"צו#ינו"},{"$f":"LEN(C46)&LEFT(F46,'[2]נתוני עזר'!$A$15)&HOUR(E46)","v":"15Hon12"},0]
["אורי","לוין","GGHH77JK@yahoo.com","2022-03-12","12:46:17.416","Nissan_Pathfinder","מסחרי","סוכנות המוביל","תל אביב","2009-02-08",117800,36392,{"$f":"MID(B47,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D47,\"MMM\")","v":"וי#מרץ"},{"$f":"LEN(C47)&LEFT(F47,'[2]נתוני עזר'!$A$15)&HOUR(E47)","v":"18Nis12"},0]
["אבי ","ממלידר","YAKI5@yahoo.com","2022-12-02","15:22:52","Nissan_qashqai","גיפ","רכבי דניאלס","יהוד","2010-10-28",114600,31480,{"$f":"MID(B48,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D48,\"MMM\")","v":"מל#דצמ"},{"$f":"LEN(C48)&LEFT(F48,'[2]נתוני עזר'!$A$15)&HOUR(E48)","v":"15Nis15"},0]
["ירדן","קלנר","ARIPOR5@yahoo.com","2022-11-28","12:39:01","Ford_Focus","פרטי","רכב דיל","בני ברק","2011-10-24",112000,7902,{"$f":"MID(B49,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D49,\"MMM\")","v":"לנ#נוב"},{"$f":"LEN(C49)&LEFT(F49,'[2]נתוני עזר'!$A$15)&HOUR(E49)","v":"17For12"},0]
["טל","בן סלומון","TIMO5GH@yahoo.com","2022-07-01","12:36:10.706","Citroen_C5","פרטי","גלגלי הזהב","חולון","2010-05-27",112000,49972,{"$f":"MID(B50,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D50,\"MMM\")","v":"ן #יול"},{"$f":"LEN(C50)&LEFT(F50,'[2]נתוני עזר'!$A$15)&HOUR(E50)","v":"17Cit12"},0]
["אודי","חיים","PADI5@yahoo.com","2022-10-02","14:03:12","Citroen_C5","פרטי","רכב דיל","בני ברק","2010-08-28",110410,12170,{"$f":"MID(B51,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D51,\"MMM\")","v":"יי#אוק"},{"$f":"LEN(C51)&LEFT(F51,'[2]נתוני עזר'!$A$15)&HOUR(E51)","v":"15Cit14"},0]
["גדי","ראפס","GILIUU8@gmail.com","2022-03-05","10:06:50.571","Mazda_6","פרטי","גלגלי הזהב","חולון","2009-02-01",110410,74616,{"$f":"MID(B52,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D52,\"MMM\")","v":"אפ#מרץ"},{"$f":"LEN(C52)&LEFT(F52,'[2]נתוני עזר'!$A$15)&HOUR(E52)","v":"17Maz10"},0]
["מירב","ברטס","GH77JK@yahoo.com","2022-06-24","13:49:00","Nissan_Juke","גיפ","גלגלי הזהב","חולון","2008-05-20",97800,45473,{"$f":"MID(B53,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D53,\"MMM\")","v":"רט#יונ"},{"$f":"LEN(C53)&LEFT(F53,'[2]נתוני עזר'!$A$15)&HOUR(E53)","v":"16Nis13"},0]
["ליה","רוטשילד","R5HJ9DT@gmail.com","2022-04-14","15:23:17.829","Nissan_Juke","גיפ","רכבי דניאלס","יהוד","2009-03-10",95000,39959,{"$f":"MID(B54,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D54,\"MMM\")","v":"וט#אפר"},{"$f":"LEN(C54)&LEFT(F54,'[2]נתוני עזר'!$A$15)&HOUR(E54)","v":"17Nis15"},0]
["עמרי","יגאנה","HRNFSEKR@gmail.com","2022-12-03","13:54:01","BMW_540","פרטי","רכב דיל מאיר","חיפה","2011-10-29",80900,79021,{"$f":"MID(B55,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D55,\"MMM\")","v":"גא#דצמ"},{"$f":"LEN(C55)&LEFT(F55,'[2]נתוני עזר'!$A$15)&HOUR(E55)","v":"18BMW13"},0]
["דן","טננבאום","OQAPSDFQ@hotmail.com","2022-05-31","11:59:30","renault_kangoo","מסחרי","רכב דיל","בני ברק","2010-04-27",76000,33193,{"$f":"MID(B56,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D56,\"MMM\")","v":"ננ#מאי"},{"$f":"LEN(C56)&LEFT(F56,'[2]נתוני עזר'!$A$15)&HOUR(E56)","v":"20ren11"},0]
["מיטל","דורון","TUTUU7@yahoo.com","2023-01-15","16:12:41","fiat_ducato","מסחרי","סוכנות המוביל","תל אביב","2010-12-11",58100,29954,{"$f":"MID(B57,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D57,\"MMM\")","v":"ור#ינו"},{"$f":"LEN(C57)&LEFT(F57,'[2]נתוני עזר'!$A$15)&HOUR(E57)","v":"16fia16"},0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"תאי עזר"]

{"sheet":"search X 3","index":3,"n_rows":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["מספר לקוח","שם לקוח","כתובת דוא\"ל","מעמד לקוח","תחילת ההשקעה","סכום השקעה ","מספר קרן","דמי ניהול ","ערך השקעה נכון להיום",null,"סיסמה",null,"ההפרש יגלה את אורך השרת שבאמצע","חיפוש מיקום התו @","חיפוש מיקום התו ."]
[1855,"NI_IAV","NI_IAV@colman.ac.il","שכיר","2022-09-15",2500,10,8.9999999999999993E-3,16761.877886011072,null,{"$f":"MID(C2,N2+$Q$7,M2-$Q$7)&DAY(E2)","v":"colman15"},null,{"$f":"O2-N2","v":7},{"$f":"SEARCH($Q$9,C2)","v":7},{"$f":"SEARCH($Q$8,C2)","v":14}]
[1856,"KF_GLD","KF_GLD@colman.ac.il","עצמאי","2022-03-12",146726,13,2.8999999999999998E-3,214094.11260178176,null,{"$f":"MID(C3,N3+$Q$7,M3-$Q$7)&DAY(E3)","v":"colman12"},null,{"$f":"O3-N3","v":7},{"$f":"SEARCH($Q$9,C3)","v":7},{"$f":"SEARCH($Q$8,C3)","v":14}]
[1857,"CC_GB","CC_GB@hotmail.com","שכיר","2022-09-29",253094,10,6.0000000000000001E-3,307637.33883750002,null,"hotmail29",null,8,6,14]
[1858,"BJ_VLS","BJ_VLS@colman.ac.il","שכיר","2022-12-29",70131,14,1E-3,332458.09982047207,null,"colman29",null,7,7,14]
[1859,"DE_APS","DE_APS@hotmail.com","שכיר","2022-02-05",63372,15,1E-3,1229261.9753939065,null,"hotmail5",null,8,7,15,null,"תאי עזר"]
[1860,"BJ_DDX","BJ_DDX@colman.ac.il","עצמאי","2022-05-19",72483,15,1E-3,1877660.4186721272,null,"colman19",null,7,7,14,null,1]
[1861,"CK_UUE","CK_UUE@ynet.co.il","עצמאי","2022-07-11",108877,13,2.8999999999999998E-3,986671.12314671697,null,"ynet11",null,5,7,{"$f":"SEARCH($Q$8,C8)","v":12},null,"."]
[1862,"JK_67J","JK_67J@yahoo.com","עצמאי","2022-05-05",96681,10,7.0000000000000001E-3,191421.76696540037,null,"yahoo5",null,6,7,13,null,"@"]
[1863,"DJ_IPO","DJ_IPO@yahoo.com","עצמאי","2022-10-27",66590,15,1E-3,377756.68354481296,null,"yahoo27",null,6,7,13]
[1864,"LB_MI8","LB_MI8@walla.co.il","בעל שליטה","2022-05-26",224708,10,6.0000000000000001E-3,3453180.5195543682]
[1865,"LM_TBP","LM_TBP@ynet.co.il","שכיר","2022-07-17",49492,14,1.1000000000000001E-3,2044762.0534205888]
[1866,"BK_UDG","BK_UDG@colman.ac.il","שכיר","2022-04-28",76982,13,3.8999999999999998E-3,2617985.4305046364]
[1867,"DK_EAU","DK_EAU@colman.ac.il","בעל שליטה","2022-09-13",184883,10,6.0000000000000001E-3,2226133.6383189736]
[1868,"KL_XLD","KL_XLD@ynet.co.il","בעל שליטה","2022-10-12",8780,10,8.9999999999999993E-3,122381.75185310727]
[1869,"NE_ANL","NE_ANL@gmail.com","שכיר","2022-11-18",46900,14,1.1000000000000001E-3,80582.931834117058]
[1870,"MK_MO5","MK_MO5@yahoo.com","שכיר","2022-05-25",162174,14,8.0000000000000004E-4,1078268.712803452]
[1871,"LM_V7U","LM_V7U@walla.co.il","שכיר","2022-12-09",10321,14,1.1000000000000001E-3,372444.86881914415]
[1872,"FD_DIK","FD_DIK@walla.co.il","שכיר","2022-06-22",56091,15,1E-3,1453028.3037917621]
[1873,"KD_HH7","KD_HH7@yahoo.com","עצמאי","2022-07-10",12866,10,8.0000000000000002E-3,133822.73527755728]
[1874,"EL_NGQ","EL_NGQ@ynet.co.il","עצמאי","2022-07-01",71270,13,3.8999999999999998E-3,142479.52031448073]
[1875,"KK_ZJH","KK_ZJH@colman.ac.il","עצמאי","2022-02-01",10129,14,1.1000000000000001E-3,22812.44860458418]
[1876,"MC_IEL","MC_IEL@colman.ac.il","בעל שליטה","2022-01-17",143689,13,2.8999999999999998E-3,1900016.8003544933]
[1877,"FJ_YQG","FJ_YQG@colman.ac.il","בעל שליטה","2022-02-09",25719,12,5.7999999999999996E-3,186489.11906743521]
[1878,"AI_MAH","AI_MAH@hotmail.com","שכיר","2022-09-16",215746,14,8.0000000000000004E-4,1094342.8807251898]
[1879,"GI_JDG","GI_JDG@gmail.com","בעל שליטה","2022-11-28",131191,10,6.0000000000000001E-3,203520.29998243746]
[1880,"SSS"]

{"sheet":"רגישות סדר 1","index":4,"n_rows":81,"n_cols":20,"rows_kept":81,"cut":false,"hidden":false,"merged":[[45,0,45,4]]}
["מספר לקוח","שם פרטי","שם משפחה","כתובת אימייל","מספר טלפון נייד","עיר מגורים","תאריך הצטרפות למועדון לקוחות","מוצר מועדף","סיווג המוצר","רמת שביעות רצון מהשירות","סכום קנייה ממוצעת","ממוצע מספר היחידות בהזמנה","שעת ביצוע ההזמנה","שעת קבלת המשלוח","שם משתמש ","סיסמה ","סיווג לקוח","הנחה","עלות משלוח"]
[1,"אבי","שחר","avi@hotmail.com","053-2223333","תל אביב","2014-03-22","Palermo Kaza","קפסולות קפה",7,320,7,"16:30:00","17:15:00",{"$f":"LEFT(B2,Q1A_1)&MID(C2,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G2)","v":"אר!22"},{"$f":"LEN(I2)&RIGHT(H2,Q1A_2)&HOUR(M2)","v":"11za16"},{"$f":"_xlfn.XLOOKUP(K2,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L2,$A$48:$A$51,_xlfn.XLOOKUP(I2,$B$47:$D$47,$B$48:$D$51),,-1)*K2","v":6.4},{"$f":"IF(AND(I2=$N$55,L2<$P$55),$P$55*L2,IF(AND(F2=$N$58,HOUR(M2)>$P$56),$P$56*L2,$P$57*L2))","v":112}]
[2,"אביב","גור","aviv@gov.il","053-1112222","ירושלים","2013-04-11","Altission","קפסולות קפה",7,1200,17,"16:15:00","17:00:00",{"$f":"LEFT(B3,Q1A_1)&MID(C3,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G3)","v":"אר!11"},{"$f":"LEN(I3)&RIGHT(H3,Q1A_2)&HOUR(M3)","v":"11on16"},{"$f":"_xlfn.XLOOKUP(K3,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"כוכבי קפה "},{"$f":"_xlfn.XLOOKUP(L3,$A$48:$A$51,_xlfn.XLOOKUP(I3,$B$47:$D$47,$B$48:$D$51),,-1)*K3","v":60},{"$f":"IF(AND(I3=$N$55,L3<$P$55),$P$55*L3,IF(AND(F3=$N$58,HOUR(M3)>$P$56),$P$56*L3,$P$57*L3))","v":272}]
[3,"אורן","כהן","oren@gmail.com","050-4445555","רמת גן","2013-12-01","Ispirazione Napolion","קפסולות קפה",2,200,9,"14:30:00","15:15:00",{"$f":"LEFT(B4,Q1A_1)&MID(C4,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G4)","v":"אן!1"},{"$f":"LEN(I4)&RIGHT(H4,Q1A_2)&HOUR(M4)","v":"11on14"},{"$f":"_xlfn.XLOOKUP(K4,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"טעימות קפה"},{"$f":"_xlfn.XLOOKUP(L4,$A$48:$A$51,_xlfn.XLOOKUP(I4,$B$47:$D$47,$B$48:$D$51),,-1)*K4","v":4},{"$f":"IF(AND(I4=$N$55,L4<$P$55),$P$55*L4,IF(AND(F4=$N$58,HOUR(M4)>$P$56),$P$56*L4,$P$57*L4))","v":144}]
[4,"איליה","קליין","ilia@gmail.com","053-1234567","חיפה","2016-09-14","Vertuo Ne","מכונות קפה",7,600,17,"15:30:00","16:15:00",{"$f":"LEFT(B5,Q1A_1)&MID(C5,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G5)","v":"אי!14"},{"$f":"LEN(I5)&RIGHT(H5,Q1A_2)&HOUR(M5)","v":"10Ne15"},{"$f":"_xlfn.XLOOKUP(K5,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"מומחי קפה"},{"$f":"_xlfn.XLOOKUP(L5,$A$48:$A$51,_xlfn.XLOOKUP(I5,$B$47:$D$47,$B$48:$D$51),,-1)*K5","v":36},272]
[5,"אילן","רון","ilan@hotmail.com","053-9998888","רעננה","2016-04-25","Sccuro","קפסולות קפה",6,700,17,"17:00:00","17:45:00",{"$f":"LEFT(B6,Q1A_1)&MID(C6,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G6)","v":"אן!25"},{"$f":"LEN(I6)&RIGHT(H6,Q1A_2)&HOUR(M6)","v":"11ro17"},{"$f":"_xlfn.XLOOKUP(K6,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"מומחי קפה"},{"$f":"_xlfn.XLOOKUP(L6,$A$48:$A$51,_xlfn.XLOOKUP(I6,$B$47:$D$47,$B$48:$D$51),,-1)*K6","v":35},272]
[6,"אלון","פלג","alon@gmail.com","052-6667777","נתניה","2013-07-16","זוג ספלי קפוצ'ינו ","אביזרים נלווים",7,600,17,"12:45:00","13:30:00",{"$f":"LEFT(B7,Q1A_1)&MID(C7,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G7)","v":"אג!16"},{"$f":"LEN(I7)&RIGHT(H7,Q1A_2)&HOUR(M7)","v":"14ו 12"},{"$f":"_xlfn.XLOOKUP(K7,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"מומחי קפה"},{"$f":"_xlfn.XLOOKUP(L7,$A$48:$A$51,_xlfn.XLOOKUP(I7,$B$47:$D$47,$B$48:$D$51),,-1)*K7","v":24},272]
[7,"אלונה","רובינוביץ","alona@yahoo.com","053-5556666","אילת","2016-10-08","Odacioo","קפסולות קפה",7,500,14,"18:15:00","19:00:00",{"$f":"LEFT(B8,Q1A_1)&MID(C8,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G8)","v":"אב!8"},{"$f":"LEN(I8)&RIGHT(H8,Q1A_2)&HOUR(M8)","v":"11oo18"},{"$f":"_xlfn.XLOOKUP(K8,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L8,$A$48:$A$51,_xlfn.XLOOKUP(I8,$B$47:$D$47,$B$48:$D$51),,-1)*K8","v":15},224]
[8,"אמיר","גיל","amir@gov.il","052-5556666","רמת גן","2014-03-03","Creatista Pluss","מכונות קפה",7,500,18,"21:30:00","22:15:00",{"$f":"LEFT(B9,Q1A_1)&MID(C9,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G9)","v":"אל!3"},{"$f":"LEN(I9)&RIGHT(H9,Q1A_2)&HOUR(M9)","v":"10ss21"},{"$f":"_xlfn.XLOOKUP(K9,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L9,$A$48:$A$51,_xlfn.XLOOKUP(I9,$B$47:$D$47,$B$48:$D$51),,-1)*K9","v":30},288]
[9,"גיל","כהן","gil@gmail.com","050-5556666","רעננה","2015-11-17","Stormion","קפסולות קפה",7,680,20,"21:45:00","22:30:00",{"$f":"LEFT(B10,Q1A_1)&MID(C10,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G10)","v":"גן!17"},{"$f":"LEN(I10)&RIGHT(H10,Q1A_2)&HOUR(M10)","v":"11on21"},{"$f":"_xlfn.XLOOKUP(K10,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"מומחי קפה"},{"$f":"_xlfn.XLOOKUP(L10,$A$48:$A$51,_xlfn.XLOOKUP(I10,$B$47:$D$47,$B$48:$D$51),,-1)*K10","v":40.799999999999997},320]
[10,"דור","לוי","dor@gmail.com","050-5556666","פתח תקווה","2015-06-03","Lattissima Onn","מכונות קפה",2,300,8,"18:45:00","19:30:00",{"$f":"LEFT(B11,Q1A_1)&MID(C11,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G11)","v":"די!3"},{"$f":"LEN(I11)&RIGHT(H11,Q1A_2)&HOUR(M11)","v":"10nn18"},{"$f":"_xlfn.XLOOKUP(K11,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"טעימות קפה"},{"$f":"_xlfn.XLOOKUP(L11,$A$48:$A$51,_xlfn.XLOOKUP(I11,$B$47:$D$47,$B$48:$D$51),,-1)*K11","v":9},64]
[11,"דינה","לייבה","dina@yahoo.com","052-8765432","פתח תקווה","2019-04-02","Vertuo Pl","מכונות קפה",7,400,10,"20:30:00","21:15:00",{"$f":"LEFT(B12,Q1A_1)&MID(C12,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G12)","v":"די!2"},{"$f":"LEN(I12)&RIGHT(H12,Q1A_2)&HOUR(M12)","v":"10Pl20"},{"$f":"_xlfn.XLOOKUP(K12,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L12,$A$48:$A$51,_xlfn.XLOOKUP(I12,$B$47:$D$47,$B$48:$D$51),,-1)*K12","v":12},80]
[12,"דנה","מלמד","dana@yahoo.com","052-8889999","באר שבע","2017-02-28","כוסות אספרסו קריסטל ","אביזרים נלווים",3,250,7,"21:00:00","21:45:00",{"$f":"LEFT(B13,Q1A_1)&MID(C13,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G13)","v":"דמ!28"},{"$f":"LEN(I13)&RIGHT(H13,Q1A_2)&HOUR(M13)","v":"14ל 21"},{"$f":"_xlfn.XLOOKUP(K13,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"טעימות קפה"},{"$f":"_xlfn.XLOOKUP(L13,$A$48:$A$51,_xlfn.XLOOKUP(I13,$B$47:$D$47,$B$48:$D$51),,-1)*K13","v":2.5},112]
[13,"דני","חיון","danny@hotmail.com","050-1234567","רעננה","2023-05-03","Romm","קפסולות קפה",3,600,16,"18:20:00","19:00:00",{"$f":"LEFT(B14,Q1A_1)&MID(C14,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G14)","v":"דו!3"},{"$f":"LEN(I14)&RIGHT(H14,Q1A_2)&HOUR(M14)","v":"11mm18"},{"$f":"_xlfn.XLOOKUP(K14,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"מומחי קפה"},{"$f":"_xlfn.XLOOKUP(L14,$A$48:$A$51,_xlfn.XLOOKUP(I14,$B$47:$D$47,$B$48:$D$51),,-1)*K14","v":30},256]
[14,"דניאל","מינץ","dan@yahoo.com","052-4445555","ירושלים","2020-11-08","Grann Latisimma","מכונות קפה",4,1000,19,"21:15:00","22:00:00",{"$f":"LEFT(B15,Q1A_1)&MID(C15,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G15)","v":"דנ!8"},{"$f":"LEN(I15)&RIGHT(H15,Q1A_2)&HOUR(M15)","v":"10ma21"},{"$f":"_xlfn.XLOOKUP(K15,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"כוכבי קפה "},{"$f":"_xlfn.XLOOKUP(L15,$A$48:$A$51,_xlfn.XLOOKUP(I15,$B$47:$D$47,$B$48:$D$51),,-1)*K15","v":60},{"$f":"IF(AND(I15=$N$55,L15<$P$55),$P$55*L15,IF(AND(F15=$N$58,HOUR(M15)>$P$56),$P$56*L15,$P$57*L15))","v":304}]
[15,"יהונתן","גלעדי","yonatan@gov.il","053-4445555","חיפה","2015-03-26","ESENZA PLUSS","מכונות קפה",5,650,17,"18:00:00","18:45:00",{"$f":"LEFT(B16,Q1A_1)&MID(C16,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G16)","v":"יע!26"},{"$f":"LEN(I16)&RIGHT(H16,Q1A_2)&HOUR(M16)","v":"10SS18"},{"$f":"_xlfn.XLOOKUP(K16,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"מומחי קפה"},{"$f":"_xlfn.XLOOKUP(L16,$A$48:$A$51,_xlfn.XLOOKUP(I16,$B$47:$D$47,$B$48:$D$51),,-1)*K16","v":39},{"$f":"IF(AND(I16=$N$55,L16<$P$55),$P$55*L16,IF(AND(F16=$N$58,HOUR(M16)>$P$56),$P$56*L16,$P$57*L16))","v":272}]
[16,"יואב","פרידמן","yoav@gmail.com","054-8889999","רמת גן","2014-09-30","כוס מאג Festive","אביזרים נלווים",5,650,18,"15:45:00","16:30:00",{"$f":"LEFT(B17,Q1A_1)&MID(C17,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G17)","v":"יי!30"},{"$f":"LEN(I17)&RIGHT(H17,Q1A_2)&HOUR(M17)","v":"14ve15"},{"$f":"_xlfn.XLOOKUP(K17,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"מומחי קפה"},{"$f":"_xlfn.XLOOKUP(L17,$A$48:$A$51,_xlfn.XLOOKUP(I17,$B$47:$D$47,$B$48:$D$51),,-1)*K17","v":26},{"$f":"IF(AND(I17=$N$55,L17<$P$55),$P$55*L17,IF(AND(F17=$N$58,HOUR(M17)>$P$56),$P$56*L17,$P$57*L17))","v":288}]
[17,"יובל","שרי","yuval@gmail.com","054-6667777","חולון","2018-07-09","Palermo Kaza","קפסולות קפה",7,800,18,"08:30:00","09:15:00",{"$f":"LEFT(B18,Q1A_1)&MID(C18,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G18)","v":"יי!9"},{"$f":"LEN(I18)&RIGHT(H18,Q1A_2)&HOUR(M18)","v":"11za8"},{"$f":"_xlfn.XLOOKUP(K18,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"כוכבי קפה "},{"$f":"_xlfn.XLOOKUP(L18,$A$48:$A$51,_xlfn.XLOOKUP(I18,$B$47:$D$47,$B$48:$D$51),,-1)*K18","v":40},{"$f":"IF(AND(I18=$N$55,L18<$P$55),$P$55*L18,IF(AND(F18=$N$58,HOUR(M18)>$P$56),$P$56*L18,$P$57*L18))","v":288}]
[18,"יוסי","כהן","yossi@gmail.com","053-7778888","אילת","2023-01-15","Ristro","קפסולות קפה",3,400,18,"10:30:00","11:00:00",{"$f":"LEFT(B19,Q1A_1)&MID(C19,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G19)","v":"ין!15"},{"$f":"LEN(I19)&RIGHT(H19,Q1A_2)&HOUR(M19)","v":"11ro10"},{"$f":"_xlfn.XLOOKUP(K19,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L19,$A$48:$A$51,_xlfn.XLOOKUP(I19,$B$47:$D$47,$B$48:$D$51),,-1)*K19","v":20},288]
[19,"יעל","גולדשטיין","yael@colman.ac.il","054-4445555","רעננה","2019-06-30","Intenso","קפסולות קפה",3,450,13,"13:30:00","14:15:00",{"$f":"LEFT(B20,Q1A_1)&MID(C20,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G20)","v":"יל!30"},{"$f":"LEN(I20)&RIGHT(H20,Q1A_2)&HOUR(M20)","v":"11so13"},{"$f":"_xlfn.XLOOKUP(K20,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L20,$A$48:$A$51,_xlfn.XLOOKUP(I20,$B$47:$D$47,$B$48:$D$51),,-1)*K20","v":13.5},208]
[20,"יעל","רוזנברג","yael@yahoo.com","050-9876543","תל אביב","2022-04-19","Vertuo Pl","מכונות קפה",5,500,14,"14:00:00","14:45:00",{"$f":"LEFT(B21,Q1A_1)&MID(C21,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G21)","v":"יז!19"},{"$f":"LEN(I21)&RIGHT(H21,Q1A_2)&HOUR(M21)","v":"10Pl14"},{"$f":"_xlfn.XLOOKUP(K21,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L21,$A$48:$A$51,_xlfn.XLOOKUP(I21,$B$47:$D$47,$B$48:$D$51),,-1)*K21","v":20},224]
[21,"יפה","קרן","yafeh@gmail.com","054-1112222","חולון","2020-06-27","Sccuro","קפסולות קפה",5,450,13,"14:30:00","15:15:00",{"$f":"LEFT(B22,Q1A_1)&MID(C22,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G22)","v":"ין!27"},{"$f":"LEN(I22)&RIGHT(H22,Q1A_2)&HOUR(M22)","v":"11ro14"},{"$f":"_xlfn.XLOOKUP(K22,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L22,$A$48:$A$51,_xlfn.XLOOKUP(I22,$B$47:$D$47,$B$48:$D$51),,-1)*K22","v":13.5},208]
[22,"מאיה","אליהו","maya@muni.il","053-1112233","באר שבע","2014-10-18","Pixie","מכונות קפה",4,500,14,"11:30:00","12:15:00",{"$f":"LEFT(B23,Q1A_1)&MID(C23,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G23)","v":"מי!18"},{"$f":"LEN(I23)&RIGHT(H23,Q1A_2)&HOUR(M23)","v":"10ie11"},{"$f":"_xlfn.XLOOKUP(K23,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L23,$A$48:$A$51,_xlfn.XLOOKUP(I23,$B$47:$D$47,$B$48:$D$51),,-1)*K23","v":20},224]
[23,"מרים","אזולאי","miriam@net.il","050-6667777","רמת גן","2016-05-19","כוס מאג Festive","אביזרים נלווים",5,1500,20,"11:00:00","11:45:00",{"$f":"LEFT(B24,Q1A_1)&MID(C24,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G24)","v":"מו!19"},{"$f":"LEN(I24)&RIGHT(H24,Q1A_2)&HOUR(M24)","v":"14ve11"},{"$f":"_xlfn.XLOOKUP(K24,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"כוכבי קפה "},{"$f":"_xlfn.XLOOKUP(L24,$A$48:$A$51,_xlfn.XLOOKUP(I24,$B$47:$D$47,$B$48:$D$51),,-1)*K24","v":75},320]
[24,"נועה","חיים","noa@org.il","054-1239876","תל אביב","2015-10-21","כוסות אספרסו קריסטל ","אביזרים נלווים",6,550,19,"14:00:00","14:45:00",{"$f":"LEFT(B25,Q1A_1)&MID(C25,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G25)","v":"ני!21"},{"$f":"LEN(I25)&RIGHT(H25,Q1A_2)&HOUR(M25)","v":"14ל 14"},{"$f":"_xlfn.XLOOKUP(K25,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"מומחי קפה"},{"$f":"_xlfn.XLOOKUP(L25,$A$48:$A$51,_xlfn.XLOOKUP(I25,$B$47:$D$47,$B$48:$D$51),,-1)*K25","v":22},304]
[25,"נועה","יוסף","noa@muni.il","054-6667777","תל אביב","2017-06-12","CITIS PLATINUM","מכונות קפה",6,350,15,"14:15:00","15:00:00",{"$f":"LEFT(B26,Q1A_1)&MID(C26,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G26)","v":"נס!12"},{"$f":"LEN(I26)&RIGHT(H26,Q1A_2)&HOUR(M26)","v":"10UM14"},{"$f":"_xlfn.XLOOKUP(K26,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L26,$A$48:$A$51,_xlfn.XLOOKUP(I26,$B$47:$D$47,$B$48:$D$51),,-1)*K26","v":21},{"$f":"IF(AND(I26=$N$55,L26<$P$55),$P$55*L26,IF(AND(F26=$N$58,HOUR(M26)>$P$56),$P$56*L26,$P$57*L26))","v":240}]
[26,"נועה","יחיאל","noa@muni.il","052-9876543","נתניה","2018-09-05","Altission","קפסולות קפה",6,350,15,"09:00:00","09:45:00",{"$f":"LEFT(B27,Q1A_1)&MID(C27,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G27)","v":"ני!5"},{"$f":"LEN(I27)&RIGHT(H27,Q1A_2)&HOUR(M27)","v":"11on9"},{"$f":"_xlfn.XLOOKUP(K27,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L27,$A$48:$A$51,_xlfn.XLOOKUP(I27,$B$47:$D$47,$B$48:$D$51),,-1)*K27","v":17.5},{"$f":"IF(AND(I27=$N$55,L27<$P$55),$P$55*L27,IF(AND(F27=$N$58,HOUR(M27)>$P$56),$P$56*L27,$P$57*L27))","v":240}]
[27,"נועם","שור","noam@gmail.com","050-1112222","חולון","2013-01-07","Atelierer","מכונות קפה",6,450,18,"09:45:00","10:30:00",{"$f":"LEFT(B28,Q1A_1)&MID(C28,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G28)","v":"נר!7"},{"$f":"LEN(I28)&RIGHT(H28,Q1A_2)&HOUR(M28)","v":"10er9"},{"$f":"_xlfn.XLOOKUP(K28,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L28,$A$48:$A$51,_xlfn.XLOOKUP(I28,$B$47:$D$47,$B$48:$D$51),,-1)*K28","v":27},{"$f":"IF(AND(I28=$N$55,L28<$P$55),$P$55*L28,IF(AND(F28=$N$58,HOUR(M28)>$P$56),$P$56*L28,$P$57*L28))","v":288}]
[28,"נועם","יצחקי","noam@yahoo.com","050-8889999","רמת גן","2019-12-05","מקציף חלב אירוצ'ינו","אביזרים נלווים",7,450,13,"10:30:00","11:15:00",{"$f":"LEFT(B29,Q1A_1)&MID(C29,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G29)","v":"נח!5"},{"$f":"LEN(I29)&RIGHT(H29,Q1A_2)&HOUR(M29)","v":"14נו10"},{"$f":"_xlfn.XLOOKUP(K29,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L29,$A$48:$A$51,_xlfn.XLOOKUP(I29,$B$47:$D$47,$B$48:$D$51),,-1)*K29","v":9},208]
[29,"ניסן","דויד","nissan@gov.il","050-3334444","אשדוד","2015-01-14","Intenso","קפסולות קפה",7,350,15,"11:45:00","12:30:00",{"$f":"LEFT(B30,Q1A_1)&MID(C30,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G30)","v":"ני!14"},{"$f":"LEN(I30)&RIGHT(H30,Q1A_2)&HOUR(M30)","v":"11so11"},{"$f":"_xlfn.XLOOKUP(K30,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L30,$A$48:$A$51,_xlfn.XLOOKUP(I30,$B$47:$D$47,$B$48:$D$51),,-1)*K30","v":17.5},240]
[30,"ניר","גולדברג","nir@colman.ac.il","052-5556666","פתח תקווה","2020-03-09","Citi & Milk","מכונות קפה",6,400,12,"16:00:00","16:45:00",{"$f":"LEFT(B31,Q1A_1)&MID(C31,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G31)","v":"נל!9"},{"$f":"LEN(I31)&RIGHT(H31,Q1A_2)&HOUR(M31)","v":"10lk16"},{"$f":"_xlfn.XLOOKUP(K31,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L31,$A$48:$A$51,_xlfn.XLOOKUP(I31,$B$47:$D$47,$B$48:$D$51),,-1)*K31","v":16},96]
[31,"ניר","סולם","nir@gmail.com","052-1234567","חיפה","2017-11-26","Vertuo Ne","מכונות קפה",6,400,17,"10:15:00","11:00:00",{"$f":"LEFT(B32,Q1A_1)&MID(C32,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G32)","v":"נל!26"},{"$f":"LEN(I32)&RIGHT(H32,Q1A_2)&HOUR(M32)","v":"10Ne10"},{"$f":"_xlfn.XLOOKUP(K32,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L32,$A$48:$A$51,_xlfn.XLOOKUP(I32,$B$47:$D$47,$B$48:$D$51),,-1)*K32","v":24},272]
[32,"עדי","אברהם","adi@hotmail.com","054-5556666","נתניה","2017-08-14","Essenza Mini","מכונות קפה",4,650,18,"19:15:00","20:00:00",{"$f":"LEFT(B33,Q1A_1)&MID(C33,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G33)","v":"ער!14"},{"$f":"LEN(I33)&RIGHT(H33,Q1A_2)&HOUR(M33)","v":"10ni19"},{"$f":"_xlfn.XLOOKUP(K33,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"מומחי קפה"},{"$f":"_xlfn.XLOOKUP(L33,$A$48:$A$51,_xlfn.XLOOKUP(I33,$B$47:$D$47,$B$48:$D$51),,-1)*K33","v":39},288]
[33,"עדן","חיים","eden@hotmail.com","054-1112233","חיפה","2013-09-17","Atelierer","מכונות קפה",7,850,19,"17:30:00","18:15:00",{"$f":"LEFT(B34,Q1A_1)&MID(C34,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G34)","v":"עי!17"},{"$f":"LEN(I34)&RIGHT(H34,Q1A_2)&HOUR(M34)","v":"10er17"},{"$f":"_xlfn.XLOOKUP(K34,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"כוכבי קפה "},{"$f":"_xlfn.XLOOKUP(L34,$A$48:$A$51,_xlfn.XLOOKUP(I34,$B$47:$D$47,$B$48:$D$51),,-1)*K34","v":51},304]
[34,"עירית","גולן","yael@bgu.ac.il","050-1239876","פתח תקווה","2014-08-03","Kazar","קפסולות קפה",7,900,19,"13:15:00","14:00:00",{"$f":"LEFT(B35,Q1A_1)&MID(C35,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G35)","v":"על!3"},{"$f":"LEN(I35)&RIGHT(H35,Q1A_2)&HOUR(M35)","v":"11ar13"},{"$f":"_xlfn.XLOOKUP(K35,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"כוכבי קפה "},{"$f":"_xlfn.XLOOKUP(L35,$A$48:$A$51,_xlfn.XLOOKUP(I35,$B$47:$D$47,$B$48:$D$51),,-1)*K35","v":45},152]
[35,"קובי","גבע","yam@org.il","054-3334444","נתניה","2018-12-27","Creatista Pluss","מכונות קפה",7,935,19,"12:00:00","12:45:00",{"$f":"LEFT(B36,Q1A_1)&MID(C36,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G36)","v":"קע!27"},{"$f":"LEN(I36)&RIGHT(H36,Q1A_2)&HOUR(M36)","v":"10ss12"},{"$f":"_xlfn.XLOOKUP(K36,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"כוכבי קפה "},{"$f":"_xlfn.XLOOKUP(L36,$A$48:$A$51,_xlfn.XLOOKUP(I36,$B$47:$D$47,$B$48:$D$51),,-1)*K36","v":56.1},304]
[36,"רבקה","אביב","rivka@org.il","054-9876543","אשדוד","2012-08-10","Kazar","קפסולות קפה",7,890,19,"12:15:00","13:00:00",{"$f":"LEFT(B37,Q1A_1)&MID(C37,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G37)","v":"רי!10"},{"$f":"LEN(I37)&RIGHT(H37,Q1A_2)&HOUR(M37)","v":"11ar12"},{"$f":"_xlfn.XLOOKUP(K37,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"כוכבי קפה "},{"$f":"_xlfn.XLOOKUP(L37,$A$48:$A$51,_xlfn.XLOOKUP(I37,$B$47:$D$47,$B$48:$D$51),,-1)*K37","v":44.5},{"$f":"IF(AND(I37=$N$55,L37<$P$55),$P$55*L37,IF(AND(F37=$N$58,HOUR(M37)>$P$56),$P$56*L37,$P$57*L37))","v":304}]
[37,"רוני","ברקוביץ'","roni@org.il","053-6667777","פתח תקווה","2021-05-24","כוסות אספרסו קריסטל ","אביזרים נלווים",5,600,8,"17:45:00","18:30:00",{"$f":"LEFT(B38,Q1A_1)&MID(C38,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G38)","v":"רק!24"},{"$f":"LEN(I38)&RIGHT(H38,Q1A_2)&HOUR(M38)","v":"14ל 17"},{"$f":"_xlfn.XLOOKUP(K38,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"מומחי קפה"},{"$f":"_xlfn.XLOOKUP(L38,$A$48:$A$51,_xlfn.XLOOKUP(I38,$B$47:$D$47,$B$48:$D$51),,-1)*K38","v":6},{"$f":"IF(AND(I38=$N$55,L38<$P$55),$P$55*L38,IF(AND(F38=$N$58,HOUR(M38)>$P$56),$P$56*L38,$P$57*L38))","v":64}]
[38,"שיר","אהרונוביץ","shir@yahoo.com","052-1112233","חיפה","2021-02-08","Odacioo","קפסולות קפה",3,500,11,"10:00:00","10:45:00",{"$f":"LEFT(B39,Q1A_1)&MID(C39,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G39)","v":"שר!8"},{"$f":"LEN(I39)&RIGHT(H39,Q1A_2)&HOUR(M39)","v":"11oo10"},{"$f":"_xlfn.XLOOKUP(K39,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L39,$A$48:$A$51,_xlfn.XLOOKUP(I39,$B$47:$D$47,$B$48:$D$51),,-1)*K39","v":10},{"$f":"IF(AND(I39=$N$55,L39<$P$55),$P$55*L39,IF(AND(F39=$N$58,HOUR(M39)>$P$56),$P$56*L39,$P$57*L39))","v":176}]
[39,"שרה","לוי","sarah@yahoo.com","052-1239876","נתניה","2022-11-20","Diavol","קפסולות קפה",3,350,10,"14:45:00","15:30:00",{"$f":"LEFT(B40,Q1A_1)&MID(C40,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G40)","v":"שי!20"},{"$f":"LEN(I40)&RIGHT(H40,Q1A_2)&HOUR(M40)","v":"11ol14"},{"$f":"_xlfn.XLOOKUP(K40,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L40,$A$48:$A$51,_xlfn.XLOOKUP(I40,$B$47:$D$47,$B$48:$D$51),,-1)*K40","v":7},160]
[40,"תמר","כהן","tamar@gmail.com","052-3334444","חיפה","2019-09-22","Stormion","קפסולות קפה",1,500,7,"19:45:00","20:30:00",{"$f":"LEFT(B41,Q1A_1)&MID(C41,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G41)","v":"תן!22"},{"$f":"LEN(I41)&RIGHT(H41,Q1A_2)&HOUR(M41)","v":"11on19"},{"$f":"_xlfn.XLOOKUP(K41,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"חברים לקפה"},{"$f":"_xlfn.XLOOKUP(L41,$A$48:$A$51,_xlfn.XLOOKUP(I41,$B$47:$D$47,$B$48:$D$51),,-1)*K41","v":10},112]
[41,"תמר","זריף","tamar@org.il","053-8889999","פתח תקווה","2018-02-13","זוג ספלי קפוצ'ינו ","אביזרים נלווים",7,700,14,"19:30:00","20:15:00",{"$f":"LEFT(B42,Q1A_1)&MID(C42,Q1A_3,Q1A_1)&Q1A_KRIA&DAY(G42)","v":"תי!13"},{"$f":"LEN(I42)&RIGHT(H42,Q1A_2)&HOUR(M42)","v":"14ו 19"},{"$f":"_xlfn.XLOOKUP(K42,'[1]נתוני עזר'!$C$3:$C$6,'[1]נתוני עזר'!$D$3:$D$6,,-1)","v":"מומחי קפה"},{"$f":"_xlfn.XLOOKUP(L42,$A$48:$A$51,_xlfn.XLOOKUP(I42,$B$47:$D$47,$B$48:$D$51),,-1)*K42","v":14},112]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(S2:S42)","v":223.80487804878049},"עלות משלוח ממוצעת לכלל הלקוחות"]
["נתונים עבור שאלה 2 סעיף ב':"]
["הנחה לחברי מועדון הלקוחות"]
["                                       סיווג מוצר \nממוצע מספר המוצרים בהזמנה","אביזרים נלווים","קפסולות קפה","מכונות קפה",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xleta.SUM","v":{"$error":"#VALUE!"}}]
[7,0.01,0.02,0.03]
[12,0.02,0.03,0.04]
[15,0.04,0.05,0.06]
[20,0.05,0.06,7.0000000000000007E-2]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"שאלה 4 סעיף א:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"קפסולות קפה",null,6.9999999999813749]
[null,"סיווג מוצר ",null,"רמת שביעות רצון",null,null,null,null,null,null,null,null,null,8,8,8]
[null,"קפסולות קפה",null,7,null,null,null,null,null,null,null,null,null,null,3,{"$f":"P56+$O$56","v":16}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"פתח תקווה",null,{"$f":"P57+$O$57","v":19}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N56+$O$56","v":16}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N59+$O$57","v":19}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"חוק: בכל פעם שידברו על משתמש ועל לחצן חובה לעבוד עם מאקרו "]
[]
[null,null,null,null,null,null,null,null,null,null,null,"חוק"]
[null,null,null,null,null,null,null,null,null,null,null,"בכל פעם שיאמרו \"ערך ראשוני או ההתחלתי\" וגם \"מרווחים\" או \"קפיצות\" אנו בניתוח רגישות."]
[{"$f":"_xlfn.XLOOKUP(23,$A$2:$A$42,$Q$2:$Q$42)","v":"כוכבי קפה "},null,null,null,null,null,null,null,null,null,null,"זיהינו משתנה יחיד שערכיו משתנים ולכן מדובר על ניתוח רגישות מסדר ראשון"]
[null,null,null,null,null,null,"שאלה 3 סעיף ב"]
[{"$f":"SUMIF(Q2:Q42,_xlfn.XLOOKUP(23,$A$2:$A$42,$Q$2:$Q$42),R2:R42)","v":431.6},"שאלה 3 א"]
[null,null,null,null,null,null,"סכום ההנחות של כולם",null,{"$f":"SUM(R2:R42)","v":1068.3000000000002},null,null,null,"ערך ראשוני",0.4]
[null,null,null,null,null,null,null,{"$f":"N71","v":0.4},1778.8999999999999]
[null,null,null,null,null,null,null,{"$f":"H72+$N$73","v":0.45},1872.3999999999999,null,null,null,"מרווחים",0.05]
[null,null,null,null,null,null,null,{"$f":"H73+$N$73","v":0.5},1965.8999999999999]
[null,null,null,null,null,null,null,0.55000000000000004,2059.3999999999996]
[null,null,null,null,null,null,null,0.60000000000000009,2152.9]
[null,null,null,null,null,null,null,0.65000000000000013,2246.4]
[null,null,null,null,null,null,null,0.70000000000000018,2339.9]
[null,null,null,null,null,null,null,0.75000000000000022,2433.4]
[null,null,null,null,null,null,null,0.80000000000000027,2526.9]
[null,null,null,null,null,null,null,0.85000000000000031,2620.4000000000005]

{"sheet":"רגישות סדר 1 DMIN","index":5,"n_rows":57,"n_cols":26,"rows_kept":57,"cut":false,"hidden":false,"merged":[[1,19,1,20],[11,19,11,20],[24,16,28,16]]}
["שם פרטי לקוח","שם משפחה לקוח","כתובת דוא\"ל","תאריך הרכישה","שעת הרכישה","דגם הרכב ","סיווג הרכב","שם הסוכנות","מיקום הסוכנות","תאריך עליית הרכב לכביש","מחיר יבואן ","מספר ק\"מ ","שם משתמש","סיסמה","מחיר רכישה"]
["יוסי","שמעון","ELVLSUAM@colman.ac.il","2022-08-02","17:10:35","Mazda_6","פרטי","רכבי דניאלס","יהוד","2010-06-29",132100,53490,{"$f":"MID(B2,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D2,\"MMM\")","v":"מע#אוג"},{"$f":"LEN(C2)&LEFT(F2,'[3]נתוני עזר'!$A$15)&HOUR(E2)","v":"21Maz17"},{"$f":"_xlfn.XLOOKUP(LEFT(F2,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F2)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K2+_xlfn.XLOOKUP(G2,$U$14:$U$17,$T$14:$T$17)/MINUTE(E2)","v":92570},null,null,null,null,"טבלה מס' 1"]
["נטע","פוקס","KEZZLDMD@colman.ac.il","2022-05-03","19:16:55","Mazda_6","פרטי","גלגלי הזהב","חולון","2011-03-29",132100,25829,{"$f":"MID(B3,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D3,\"MMM\")","v":"וק#מאי"},{"$f":"LEN(C3)&LEFT(F3,'[3]נתוני עזר'!$A$15)&HOUR(E3)","v":"21Maz19"},{"$f":"_xlfn.XLOOKUP(LEFT(F3,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F3)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K3+_xlfn.XLOOKUP(G3,$U$14:$U$17,$T$14:$T$17)/MINUTE(E3)","v":92532.5},null,null,null,null,"אחוז ממחיר יבואן","סוג רכב"]
["אורי","גוזמן","BEXLDPPA11@ynet.co.il","2022-02-19","17:20:28.333","Citroen_C3","פרטי","רכב דיל מאיר","חיפה","2011-01-15",125000,65509,{"$f":"MID(B4,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D4,\"MMM\")","v":"וז#פבר"},{"$f":"LEN(C4)&LEFT(F4,'[3]נתוני עזר'!$A$15)&HOUR(E4)","v":"21Cit17"},{"$f":"_xlfn.XLOOKUP(LEFT(F4,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F4)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K4+_xlfn.XLOOKUP(G4,$U$14:$U$17,$T$14:$T$17)/MINUTE(E4)","v":68800},null,null,null,null,0.6,"Nissan"]
["אורן","ברבור","COZ66@walla.co.il","2022-06-28","17:09:30.994","Honda_Civic","פרטי","גלגלי הזהב","חולון","2009-05-24",119200,31704,{"$f":"MID(B5,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D5,\"MMM\")","v":"רב#יונ"},{"$f":"LEN(C5)&LEFT(F5,'[3]נתוני עזר'!$A$15)&HOUR(E5)","v":"17Hon17"},{"$f":"_xlfn.XLOOKUP(LEFT(F5,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F5)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K5+_xlfn.XLOOKUP(G5,$U$14:$U$17,$T$14:$T$17)/MINUTE(E5)","v":53751.111111111109},null,null,null,null,0.7,"Mazda"]
["אבי ","ברלב","SVET6@walla.co.il","2022-11-08","19:35:47.084","Citroen_C5","פרטי","גלגלי הזהב","חולון","2010-10-04",114500,28286,{"$f":"MID(B6,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D6,\"MMM\")","v":"רל#נוב"},{"$f":"LEN(C6)&LEFT(F6,'[3]נתוני עזר'!$A$15)&HOUR(E6)","v":"17Cit19"},{"$f":"_xlfn.XLOOKUP(LEFT(F6,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F6)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K6+_xlfn.XLOOKUP(G6,$U$14:$U$17,$T$14:$T$17)/MINUTE(E6)","v":63003.571428571435},null,null,null,null,0.8,"BMW"]
["נוי","סליקטר","VWQXYKIY@colman.ac.il","2022-05-07","18:16:10","Mazda_3","פרטי","סוכנות המוביל","תל אביב","2011-04-03",99200,99037,{"$f":"MID(B7,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D7,\"MMM\")","v":"לי#מאי"},{"$f":"LEN(C7)&LEFT(F7,'[3]נתוני עזר'!$A$15)&HOUR(E7)","v":"21Maz18"},{"$f":"_xlfn.XLOOKUP(LEFT(F7,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F7)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K7+_xlfn.XLOOKUP(G7,$U$14:$U$17,$T$14:$T$17)/MINUTE(E7)","v":69502.5},null,null,null,null,0.75,"Audi"]
["אמיר","שרון","AUTBPAME@ynet.co.il","2022-09-15","16:07:25","BMW_Z4","פרטי","סוכנות המוביל","תל אביב","2011-08-11",185200,23650,{"$f":"MID(B8,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D8,\"MMM\")","v":"רו#ספט"},{"$f":"LEN(C8)&LEFT(F8,'[3]נתוני עזר'!$A$15)&HOUR(E8)","v":"19BMW16"},{"$f":"_xlfn.XLOOKUP(LEFT(F8,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F8)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K8+_xlfn.XLOOKUP(G8,$U$14:$U$17,$T$14:$T$17)/MINUTE(E8)","v":148302.85714285713},null,null,null,null,0.55000000000000004,"Citroen"]
["אאוגן ","ליבוביץ","YIDOJL@colman.ac.il","2022-07-29","13:51:02","renault_kangoo","מסחרי","רכבי דניאלס","יהוד","2011-06-25",148000,56507,{"$f":"MID(B9,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D9,\"MMM\")","v":"יב#יול"},{"$f":"LEN(C9)&LEFT(F9,'[3]נתוני עזר'!$A$15)&HOUR(E9)","v":"19ren13"},{"$f":"_xlfn.XLOOKUP(LEFT(F9,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F9)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K9+_xlfn.XLOOKUP(G9,$U$14:$U$17,$T$14:$T$17)/MINUTE(E9)","v":66623.529411764699}]
["מיכל","בן עמי","KE78OMD@colman.ac.il","2022-10-31","13:33:55","toyota_hilux","מסחרי","סוכנות המוביל","תל אביב","2010-09-27",135200,76935,{"$f":"MID(B10,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D10,\"MMM\")","v":"ן #אוק"},{"$f":"LEN(C10)&LEFT(F10,'[3]נתוני עזר'!$A$15)&HOUR(E10)","v":"20toy13"},{"$f":"_xlfn.XLOOKUP(LEFT(F10,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F10)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K10+_xlfn.XLOOKUP(G10,$U$14:$U$17,$T$14:$T$17)/MINUTE(E10)","v":60876.36363636364},null,{"$f":"SUM(O2:O37)","v":2458551.6663886062},null,null,null,0.45]
["מושיקו","דגנוש","BDZJHBUB@colman.ac.il","2022-06-19","16:20:30.696","Audi_A4","פרטי","רכב דיל מאיר","חיפה","2008-05-15",133200,43076,{"$f":"MID(B11,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D11,\"MMM\")","v":"גנ#יונ"},{"$f":"LEN(C11)&LEFT(F11,'[3]נתוני עזר'!$A$15)&HOUR(E11)","v":"21Aud16"},{"$f":"_xlfn.XLOOKUP(LEFT(F11,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F11)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K11+_xlfn.XLOOKUP(G11,$U$14:$U$17,$T$14:$T$17)/MINUTE(E11)","v":99950}]
["אבי ","היינריך","FF22WT@ynet.co.il","2022-06-03","15:46:52","Nissan_Juke","גיפ","רכב דיל מאיר","חיפה","2008-04-30",133200,13221,{"$f":"MID(B12,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D12,\"MMM\")","v":"יי#יונ"},{"$f":"LEN(C12)&LEFT(F12,'[3]נתוני עזר'!$A$15)&HOUR(E12)","v":"17Nis15"},{"$f":"_xlfn.XLOOKUP(LEFT(F12,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F12)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K12+_xlfn.XLOOKUP(G12,$U$14:$U$17,$T$14:$T$17)/MINUTE(E12)","v":79950.434782608689},null,null,null,null,"טבלה מס' 2"]
["עמית","כהן","EAUDGT@colman.ac.il","2022-09-14","11:51:37.007","Honda_Accord","פרטי","סוכנות המוביל","תל אביב","2011-08-10",125900,40682,{"$f":"MID(B13,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D13,\"MMM\")","v":"הן#ספט"},{"$f":"LEN(C13)&LEFT(F13,'[3]נתוני עזר'!$A$15)&HOUR(E13)","v":"19Hon11"},{"$f":"_xlfn.XLOOKUP(LEFT(F13,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F13)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K13+_xlfn.XLOOKUP(G13,$U$14:$U$17,$T$14:$T$17)/MINUTE(E13)","v":56674.607843137252},null,null,null,null,"תוספת סיווג","סווג הרכב"]
["אריק","לוין","FFNGQQWT@ynet.co.il","2023-01-10","14:09:00.555","Audi_A4","פרטי","רכב דיל","בני ברק","2008-12-06",125300,23927,{"$f":"MID(B14,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D14,\"MMM\")","v":"וי#ינו"},{"$f":"LEN(C14)&LEFT(F14,'[3]נתוני עזר'!$A$15)&HOUR(E14)","v":"19Aud14"},{"$f":"_xlfn.XLOOKUP(LEFT(F14,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F14)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K14+_xlfn.XLOOKUP(G14,$U$14:$U$17,$T$14:$T$17)/MINUTE(E14)","v":94086.111111111109},null,null,null,null,1000,"פרטי"]
["מור","גולדברג","JXI45LUBY@colman.ac.il","2022-03-28","14:01:39","Nissan_Micra","פרטי","גלגלי הזהב","חולון","2008-02-24",117200,28169,{"$f":"MID(B15,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D15,\"MMM\")","v":"ול#מרץ"},{"$f":"LEN(C15)&LEFT(F15,'[3]נתוני עזר'!$A$15)&HOUR(E15)","v":"22Nis14"},{"$f":"_xlfn.XLOOKUP(LEFT(F15,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F15)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K15+_xlfn.XLOOKUP(G15,$U$14:$U$17,$T$14:$T$17)/MINUTE(E15)","v":71320},null,null,null,null,1200,"מסחרי"]
["ענבר","יפת","KIEAUDGT@colman.ac.il","2022-09-10","14:32:09","Nissan_Pathfinder","מסחרי","גלגלי הזהב","חולון","2011-08-06",114500,22743,{"$f":"MID(B16,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D16,\"MMM\")","v":"פת#ספט"},{"$f":"LEN(C16)&LEFT(F16,'[3]נתוני עזר'!$A$15)&HOUR(E16)","v":"21Nis14"},{"$f":"_xlfn.XLOOKUP(LEFT(F16,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F16)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K16+_xlfn.XLOOKUP(G16,$U$14:$U$17,$T$14:$T$17)/MINUTE(E16)","v":68737.5},null,null,null,null,1400,"גיפ"]
["עדי","גירו","EXOOYULR@colman.ac.il","2023-01-26","14:23:21.892","Audi_A6","מנהלים","רכבי דניאלס","יהוד","2010-12-22",114500,10716,{"$f":"MID(B17,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D17,\"MMM\")","v":"יר#ינו"},{"$f":"LEN(C17)&LEFT(F17,'[3]נתוני עזר'!$A$15)&HOUR(E17)","v":"21Aud14"},{"$f":"_xlfn.XLOOKUP(LEFT(F17,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F17)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K17+_xlfn.XLOOKUP(G17,$U$14:$U$17,$T$14:$T$17)/MINUTE(E17)","v":85944.565217391311},null,null,null,null,1600,"מנהלים"]
["אלכס","עמרמי ויצמן","FAOL5@walla.co.il","2022-07-13","13:55:29","Honda_Civic","פרטי","רכב דיל","בני ברק","2008-06-09",114500,40383,{"$f":"MID(B18,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D18,\"MMM\")","v":"מר#יול"},{"$f":"LEN(C18)&LEFT(F18,'[3]נתוני עזר'!$A$15)&HOUR(E18)","v":"17Hon13"},{"$f":"_xlfn.XLOOKUP(LEFT(F18,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F18)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K18+_xlfn.XLOOKUP(G18,$U$14:$U$17,$T$14:$T$17)/MINUTE(E18)","v":51543.181818181816}]
["אבי ","אור אורטרגר","CTA86@walla.co.il","2022-10-26","15:48:53","Subaru_B4","פרטי","רכב דיל","בני ברק","2010-09-22",112500,20389,{"$f":"MID(B19,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D19,\"MMM\")","v":"ור#אוק"},{"$f":"LEN(C19)&LEFT(F19,'[3]נתוני עזר'!$A$15)&HOUR(E19)","v":"17Sub15"},{"$f":"_xlfn.XLOOKUP(LEFT(F19,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F19)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K19+_xlfn.XLOOKUP(G19,$U$14:$U$17,$T$14:$T$17)/MINUTE(E19)","v":50645.833333333336}]
["רם","אברמוביץ","XPDDXH@colman.ac.il","2022-04-19","16:37:49.888","toyota_hilux","מסחרי","רכב דיל מאיר","חיפה","2010-03-15",112000,38679,{"$f":"MID(B20,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D20,\"MMM\")","v":"בר#אפר"},{"$f":"LEN(C20)&LEFT(F20,'[3]נתוני עזר'!$A$15)&HOUR(E20)","v":"19toy16"},{"$f":"_xlfn.XLOOKUP(LEFT(F20,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F20)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K20+_xlfn.XLOOKUP(G20,$U$14:$U$17,$T$14:$T$17)/MINUTE(E20)","v":50432.432432432433}]
["עומר","יגאנה","WTUUETX@ynet.co.il","2022-10-15","13:38:56.356","Audi_A3","פרטי","רכבי דניאלס","יהוד","2009-09-11",110410,26284,{"$f":"MID(B21,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D21,\"MMM\")","v":"גא#אוק"},{"$f":"LEN(C21)&LEFT(F21,'[3]נתוני עזר'!$A$15)&HOUR(E21)","v":"18Aud13"},{"$f":"_xlfn.XLOOKUP(LEFT(F21,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F21)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K21+_xlfn.XLOOKUP(G21,$U$14:$U$17,$T$14:$T$17)/MINUTE(E21)","v":82833.81578947368}]
["אסי","וידר","JXIELUBY@colman.ac.il","2022-05-15","09:24:14.616","fiat_ducato","מסחרי","רכב דיל","בני ברק","2008-04-11",106000,6474,{"$f":"MID(B22,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D22,\"MMM\")","v":"יד#מאי"},{"$f":"LEN(C22)&LEFT(F22,'[3]נתוני עזר'!$A$15)&HOUR(E22)","v":"21fia9"},{"$f":"_xlfn.XLOOKUP(LEFT(F22,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F22)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K22+_xlfn.XLOOKUP(G22,$U$14:$U$17,$T$14:$T$17)/MINUTE(E22)","v":47750}]
["אאוריקה ","גורכוב","MYGLDVTD@colman.ac.il","2022-06-21","10:58:13.226","Nissan_Navare","מסחרי","סוכנות המוביל","תל אביב","2011-05-17",103000,57178,{"$f":"MID(B23,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D23,\"MMM\")","v":"ור#יונ"},{"$f":"LEN(C23)&LEFT(F23,'[3]נתוני עזר'!$A$15)&HOUR(E23)","v":"21Nis10"},{"$f":"_xlfn.XLOOKUP(LEFT(F23,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F23)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K23+_xlfn.XLOOKUP(G23,$U$14:$U$17,$T$14:$T$17)/MINUTE(E23)","v":61820.689655172413},null,null,null,null,"DSUM"]
["אאוג'ן ","מנוליאו","NYIAVES@colman.ac.il","2022-07-08","16:17:18","BMW_325","פרטי","סוכנות המוביל","תל אביב","2011-06-04",99600,18823,{"$f":"MID(B24,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D24,\"MMM\")","v":"נו#יול"},{"$f":"LEN(C24)&LEFT(F24,'[3]נתוני עזר'!$A$15)&HOUR(E24)","v":"20BMW16"},{"$f":"_xlfn.XLOOKUP(LEFT(F24,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F24)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K24+_xlfn.XLOOKUP(G24,$U$14:$U$17,$T$14:$T$17)/MINUTE(E24)","v":79738.823529411762},null,null,null,null,null,"טבלת קריטריונים"]
["שירי","מנור","GIMI89FG@walla.co.il","2022-10-13","14:29:31.541","Mazda_3","פרטי","סוכנות המוביל","תל אביב","2011-09-09",92200,63326,{"$f":"MID(B25,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D25,\"MMM\")","v":"נו#אוק"},{"$f":"LEN(C25)&LEFT(F25,'[3]נתוני עזר'!$A$15)&HOUR(E25)","v":"20Maz14"},{"$f":"_xlfn.XLOOKUP(LEFT(F25,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F25)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K25+_xlfn.XLOOKUP(G25,$U$14:$U$17,$T$14:$T$17)/MINUTE(E25)","v":64574.482758620681},null,"אפשר לפתור עם minifs במקום dmin"]
["טלי","רונן","FADIKOL55@walla.co.il","2022-07-20","12:51:18","Mazda_3","פרטי","רכבי דניאלס","יהוד","2009-06-16",90890,48294,{"$f":"MID(B26,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D26,\"MMM\")","v":"ונ#יול"},{"$f":"LEN(C26)&LEFT(F26,'[3]נתוני עזר'!$A$15)&HOUR(E26)","v":"21Maz12"},{"$f":"_xlfn.XLOOKUP(LEFT(F26,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F26)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K26+_xlfn.XLOOKUP(G26,$U$14:$U$17,$T$14:$T$17)/MINUTE(E26)","v":63642.607843137244},null,null,null,null,null,null,null,null,null,"תא עזר לערך ראשוני ולמרווחים"]
["שרה","שוורץ","RVPNJHQO33@ynet.co.il","2022-10-30","12:56:34.880","Mazda_6","פרטי","רכב דיל","בני ברק","2010-09-26",90890,8931,{"$f":"MID(B27,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D27,\"MMM\")","v":"וו#אוק"},{"$f":"LEN(C27)&LEFT(F27,'[3]נתוני עזר'!$A$15)&HOUR(E27)","v":"21Maz12"},{"$f":"_xlfn.XLOOKUP(LEFT(F27,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F27)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K27+_xlfn.XLOOKUP(G27,$U$14:$U$17,$T$14:$T$17)/MINUTE(E27)","v":63640.857142857138},null,null,null,null,"מחיר יבואן ","מחיר יבואן ","מספר ק\"מ ","מספר ק\"מ ",null,null,0.5]
["יאנה","גלון","RAV8O@walla.co.il","2022-09-27","09:29:23","Audi_A6","מנהלים","גלגלי הזהב","חולון","2008-08-23",90890,50833,{"$f":"MID(B28,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D28,\"MMM\")","v":"לו#ספט"},{"$f":"LEN(C28)&LEFT(F28,'[3]נתוני עזר'!$A$15)&HOUR(E28)","v":"17Aud9"},{"$f":"_xlfn.XLOOKUP(LEFT(F28,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F28)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K28+_xlfn.XLOOKUP(G28,$U$14:$U$17,$T$14:$T$17)/MINUTE(E28)","v":68222.672413793101},null,null,null,null,"<=200000",">=100000"]
["תומר","בוקאי","RAV7U8O@walla.co.il","2022-11-26","10:05:24","renault_kangoo","מסחרי","סוכנות המוביל","תל אביב","2009-10-22",90100,74516,{"$f":"MID(B29,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D29,\"MMM\")","v":"וק#נוב"},{"$f":"LEN(C29)&LEFT(F29,'[3]נתוני עזר'!$A$15)&HOUR(E29)","v":"19ren10"},{"$f":"_xlfn.XLOOKUP(LEFT(F29,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F29)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K29+_xlfn.XLOOKUP(G29,$U$14:$U$17,$T$14:$T$17)/MINUTE(E29)","v":40785},null,null,null,null,null,null,"<=75000",">=25000",null,"תא עזר למרווחים"]
["דניאלה","שטיין","EXOOIS5@colman.ac.il","2022-10-09","14:05:53.175","BMW_325","פרטי","רכבי דניאלס","יהוד","2010-09-05",89000,38944,{"$f":"MID(B30,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D30,\"MMM\")","v":"טי#אוק"},{"$f":"LEN(C30)&LEFT(F30,'[3]נתוני עזר'!$A$15)&HOUR(E30)","v":"20BMW14"},{"$f":"_xlfn.XLOOKUP(LEFT(F30,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F30)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K30+_xlfn.XLOOKUP(G30,$U$14:$U$17,$T$14:$T$17)/MINUTE(E30)","v":71400},null,null,null,null,null,null,null,null,null,null,0.05]
["מור","אילומים","YXYQGYVQ@colman.ac.il","2022-04-25","09:02:29.426","Volkswagen_Passat","פרטי","סוכנות המוביל","תל אביב","2008-03-21",85300,40146,{"$f":"MID(B31,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D31,\"MMM\")","v":"יל#אפר"},{"$f":"LEN(C31)&LEFT(F31,'[3]נתוני עזר'!$A$15)&HOUR(E31)","v":"21Vol9"},{"$f":"_xlfn.XLOOKUP(LEFT(F31,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F31)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K31+_xlfn.XLOOKUP(G31,$U$14:$U$17,$T$14:$T$17)/MINUTE(E31)","v":38885}]
["אמה","בנוב","RV7HQO33@ynet.co.il","2022-03-28","12:38:25.082","Honda_Civic","פרטי","רכבי דניאלס","יהוד","2008-02-24",79000,33741,{"$f":"MID(B32,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D32,\"MMM\")","v":"נו#מרץ"},{"$f":"LEN(C32)&LEFT(F32,'[3]נתוני עזר'!$A$15)&HOUR(E32)","v":"19Hon12"},{"$f":"_xlfn.XLOOKUP(LEFT(F32,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F32)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K32+_xlfn.XLOOKUP(G32,$U$14:$U$17,$T$14:$T$17)/MINUTE(E32)","v":35576.315789473687}]
["גלי","גרבר","SVETR@walla.co.il","2022-08-07","15:35:40.927","Hyundai_Tuscon","גיפ","סוכנות המוביל","תל אביב","2009-07-03",69900,52888,{"$f":"MID(B33,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D33,\"MMM\")","v":"רב#אוג"},{"$f":"LEN(C33)&LEFT(F33,'[3]נתוני עזר'!$A$15)&HOUR(E33)","v":"17Hyu15"},{"$f":"_xlfn.XLOOKUP(LEFT(F33,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F33)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K33+_xlfn.XLOOKUP(G33,$U$14:$U$17,$T$14:$T$17)/MINUTE(E33)","v":31495},null,null,null,null,"סך מחיר הרכישה למי שעמד בתנאים"]
["אבי ","רינגל","BD12BUB@colman.ac.il","2022-05-17","09:52:31.682","Subaru_B4","פרטי","סוכנות המוביל","תל אביב","2008-04-13",42320,34120,{"$f":"MID(B34,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D34,\"MMM\")","v":"ינ#מאי"},{"$f":"LEN(C34)&LEFT(F34,'[3]נתוני עזר'!$A$15)&HOUR(E34)","v":"20Sub9"},{"$f":"_xlfn.XLOOKUP(LEFT(F34,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F34)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K34+_xlfn.XLOOKUP(G34,$U$14:$U$17,$T$14:$T$17)/MINUTE(E34)","v":19063.23076923077},null,null,null,null,{"$f":"DSUM($A$1:$O$57,O1,$T$27:$W$29)","v":3310081.472176977}]
["צחי","וינר","JILI6@yahoo.com","2023-01-27","19:07:43.211","Audi_A6","מנהלים","סוכנות המוביל","תל אביב","2010-12-23",156000,54194,{"$f":"MID(B35,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D35,\"MMM\")","v":"ינ#ינו"},{"$f":"LEN(C35)&LEFT(F35,'[3]נתוני עזר'!$A$15)&HOUR(E35)","v":"15Aud19"},{"$f":"_xlfn.XLOOKUP(LEFT(F35,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F35)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K35+_xlfn.XLOOKUP(G35,$U$14:$U$17,$T$14:$T$17)/MINUTE(E35)","v":117228.57142857143},null,null,null,{"$f":"Z27","v":0.5},3427417.472176977]
["אריה","אונרוביל","TAB@hotmail.com","2022-09-21","18:16:34.929","Hyundai_Tuscon","גיפ","רכב דיל מאיר","חיפה","2010-08-17",148000,37483,{"$f":"MID(B36,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D36,\"MMM\")","v":"ונ#ספט"},{"$f":"LEN(C36)&LEFT(F36,'[3]נתוני עזר'!$A$15)&HOUR(E36)","v":"15Hyu18"},{"$f":"_xlfn.XLOOKUP(LEFT(F36,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F36)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K36+_xlfn.XLOOKUP(G36,$U$14:$U$17,$T$14:$T$17)/MINUTE(E36)","v":66687.5},null,null,null,{"$f":"S35+$Z$30","v":0.55000000000000004},3544753.472176977]
["רואי","חנוביץ","GT67JK@yahoo.com","2022-09-28","17:02:19","Nissan_qashqai","גיפ","רכב דיל","בני ברק","2009-08-24",132100,20688,{"$f":"MID(B37,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D37,\"MMM\")","v":"נו#ספט"},{"$f":"LEN(C37)&LEFT(F37,'[3]נתוני עזר'!$A$15)&HOUR(E37)","v":"16Nis17"},{"$f":"_xlfn.XLOOKUP(LEFT(F37,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F37)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K37+_xlfn.XLOOKUP(G37,$U$14:$U$17,$T$14:$T$17)/MINUTE(E37)","v":79960},null,null,null,{"$f":"S36+$Z$30","v":0.60000000000000009},3662089.472176977]
["לישי","ברמן","LCMAHAOP@hotmail.com","2022-04-11","18:23:19.898","Nissan_Micra","פרטי","סוכנות המוביל","תל אביב","2008-03-07",114600,56149,{"$f":"MID(B38,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D38,\"MMM\")","v":"רמ#אפר"},{"$f":"LEN(C38)&LEFT(F38,'[3]נתוני עזר'!$A$15)&HOUR(E38)","v":"20Nis18"},{"$f":"_xlfn.XLOOKUP(LEFT(F38,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F38)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K38+_xlfn.XLOOKUP(G38,$U$14:$U$17,$T$14:$T$17)/MINUTE(E38)","v":68803.478260869568},null,null,null,0.65000000000000013,3779425.472176977]
["לנה","יצחקי","TUKU7K@yahoo.com","2022-11-15","19:26:56.881","toyota_hilux","מסחרי","רכב דיל","בני ברק","2008-10-11",98700,39354,{"$f":"MID(B39,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D39,\"MMM\")","v":"צח#נוב"},{"$f":"LEN(C39)&LEFT(F39,'[3]נתוני עזר'!$A$15)&HOUR(E39)","v":"16toy19"},{"$f":"_xlfn.XLOOKUP(LEFT(F39,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F39)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K39+_xlfn.XLOOKUP(G39,$U$14:$U$17,$T$14:$T$17)/MINUTE(E39)","v":44461.153846153844},null,null,null,0.70000000000000018,3896761.472176977]
["דור","וויינר","RVHJHDT@gmail.com","2022-05-18","17:02:22.317","Audi_A3","פרטי","רכב דיל","בני ברק","2009-04-14",97800,17489,{"$f":"MID(B40,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D40,\"MMM\")","v":"וי#מאי"},{"$f":"LEN(C40)&LEFT(F40,'[3]נתוני עזר'!$A$15)&HOUR(E40)","v":"17Aud17"},{"$f":"_xlfn.XLOOKUP(LEFT(F40,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F40)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K40+_xlfn.XLOOKUP(G40,$U$14:$U$17,$T$14:$T$17)/MINUTE(E40)","v":73850},null,null,null,0.75000000000000022,4014097.472176977]
["נדב","רווח","RFANLGI22@gmail.com","2022-12-09","10:49:57","Ford_Focus","פרטי","רכב דיל מאיר","חיפה","2010-11-05",148000,60630,{"$f":"MID(B41,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D41,\"MMM\")","v":"וו#דצמ"},{"$f":"LEN(C41)&LEFT(F41,'[3]נתוני עזר'!$A$15)&HOUR(E41)","v":"19For10"},{"$f":"_xlfn.XLOOKUP(LEFT(F41,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F41)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K41+_xlfn.XLOOKUP(G41,$U$14:$U$17,$T$14:$T$17)/MINUTE(E41)","v":66620.408163265311},null,null,null,0.80000000000000027,4131433.472176977]
["אלון","כהן","XIJDGGVC@gmail.com","2022-12-09","14:58:59.772","Nissan_Navare","מסחרי","גלגלי הזהב","חולון","2011-11-05",133500,30206,{"$f":"MID(B42,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D42,\"MMM\")","v":"הן#דצמ"},{"$f":"LEN(C42)&LEFT(F42,'[3]נתוני עזר'!$A$15)&HOUR(E42)","v":"18Nis14"},{"$f":"_xlfn.XLOOKUP(LEFT(F42,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F42)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K42+_xlfn.XLOOKUP(G42,$U$14:$U$17,$T$14:$T$17)/MINUTE(E42)","v":80120.338983050853},null,null,null,0.85000000000000031,4248769.4721769765]
["אאוריקה ","יאסין","YEGB@hotmail.com","2022-08-25","14:44:53.260","Citroen_C3","פרטי","רכב דיל מאיר","חיפה","2010-07-21",133200,37698,{"$f":"MID(B43,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D43,\"MMM\")","v":"אס#אוג"},{"$f":"LEN(C43)&LEFT(F43,'[3]נתוני עזר'!$A$15)&HOUR(E43)","v":"16Cit14"},{"$f":"_xlfn.XLOOKUP(LEFT(F43,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F43)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K43+_xlfn.XLOOKUP(G43,$U$14:$U$17,$T$14:$T$17)/MINUTE(E43)","v":73282.727272727279},null,null,null,0.90000000000000036,4366105.4721769765]
["שירי","הסנר","GZBJLAY@gmail.com","2022-12-20","16:33:01.363","Hyundai_Tuscon","גיפ","רכב דיל מאיר","חיפה","2011-11-16",124900,49309,{"$f":"MID(B44,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D44,\"MMM\")","v":"סנ#דצמ"},{"$f":"LEN(C44)&LEFT(F44,'[3]נתוני עזר'!$A$15)&HOUR(E44)","v":"17Hyu16"},{"$f":"_xlfn.XLOOKUP(LEFT(F44,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F44)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K44+_xlfn.XLOOKUP(G44,$U$14:$U$17,$T$14:$T$17)/MINUTE(E44)","v":56247.42424242424},null,null,null,0.9500000000000004,4483441.4721769774]
["נועם","מי דן","PAB@hotmail.com","2022-06-23","16:43:58.850","Volkswagen_Golf","פרטי","רכב דיל מאיר","חיפה","2009-05-19",122300,6330,{"$f":"MID(B45,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D45,\"MMM\")","v":"י #יונ"},{"$f":"LEN(C45)&LEFT(F45,'[3]נתוני עזר'!$A$15)&HOUR(E45)","v":"15Vol16"},{"$f":"_xlfn.XLOOKUP(LEFT(F45,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F45)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K45+_xlfn.XLOOKUP(G45,$U$14:$U$17,$T$14:$T$17)/MINUTE(E45)","v":55058.255813953489}]
["אסי","כצוביץ","MIKI6@yahoo.com","2023-01-26","12:36:06.172","Honda_Accord","פרטי","רכבי דניאלס","יהוד","2008-12-22",118800,43882,{"$f":"MID(B46,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D46,\"MMM\")","v":"צו#ינו"},{"$f":"LEN(C46)&LEFT(F46,'[3]נתוני עזר'!$A$15)&HOUR(E46)","v":"15Hon12"},{"$f":"_xlfn.XLOOKUP(LEFT(F46,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F46)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K46+_xlfn.XLOOKUP(G46,$U$14:$U$17,$T$14:$T$17)/MINUTE(E46)","v":53487.777777777781}]
["אורי","לוין","GGHH77JK@yahoo.com","2022-03-12","12:46:17.416","Nissan_Pathfinder","מסחרי","סוכנות המוביל","תל אביב","2009-02-08",117800,36392,{"$f":"MID(B47,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D47,\"MMM\")","v":"וי#מרץ"},{"$f":"LEN(C47)&LEFT(F47,'[3]נתוני עזר'!$A$15)&HOUR(E47)","v":"18Nis12"},{"$f":"_xlfn.XLOOKUP(LEFT(F47,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F47)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K47+_xlfn.XLOOKUP(G47,$U$14:$U$17,$T$14:$T$17)/MINUTE(E47)","v":70706.086956521744}]
["אבי ","ממלידר","YAKI5@yahoo.com","2022-12-02","15:22:52","Nissan_qashqai","גיפ","רכבי דניאלס","יהוד","2010-10-28",114600,31480,{"$f":"MID(B48,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D48,\"MMM\")","v":"מל#דצמ"},{"$f":"LEN(C48)&LEFT(F48,'[3]נתוני עזר'!$A$15)&HOUR(E48)","v":"15Nis15"},{"$f":"_xlfn.XLOOKUP(LEFT(F48,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F48)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K48+_xlfn.XLOOKUP(G48,$U$14:$U$17,$T$14:$T$17)/MINUTE(E48)","v":68823.636363636368}]
["ירדן","קלנר","ARIPOR5@yahoo.com","2022-11-28","12:39:01","Ford_Focus","פרטי","רכב דיל","בני ברק","2011-10-24",112000,7902,{"$f":"MID(B49,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D49,\"MMM\")","v":"לנ#נוב"},{"$f":"LEN(C49)&LEFT(F49,'[3]נתוני עזר'!$A$15)&HOUR(E49)","v":"17For12"},{"$f":"_xlfn.XLOOKUP(LEFT(F49,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F49)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K49+_xlfn.XLOOKUP(G49,$U$14:$U$17,$T$14:$T$17)/MINUTE(E49)","v":50425.641025641024}]
["טל","בן סלומון","TIMO5GH@yahoo.com","2022-07-01","12:36:10.706","Citroen_C5","פרטי","גלגלי הזהב","חולון","2010-05-27",112000,49972,{"$f":"MID(B50,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D50,\"MMM\")","v":"ן #יול"},{"$f":"LEN(C50)&LEFT(F50,'[3]נתוני עזר'!$A$15)&HOUR(E50)","v":"17Cit12"},{"$f":"_xlfn.XLOOKUP(LEFT(F50,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F50)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K50+_xlfn.XLOOKUP(G50,$U$14:$U$17,$T$14:$T$17)/MINUTE(E50)","v":61627.777777777788}]
["אודי","חיים","PADI5@yahoo.com","2022-10-02","14:03:12","Citroen_C5","פרטי","רכב דיל","בני ברק","2010-08-28",110410,12170,{"$f":"MID(B51,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D51,\"MMM\")","v":"יי#אוק"},{"$f":"LEN(C51)&LEFT(F51,'[3]נתוני עזר'!$A$15)&HOUR(E51)","v":"15Cit14"},{"$f":"_xlfn.XLOOKUP(LEFT(F51,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F51)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K51+_xlfn.XLOOKUP(G51,$U$14:$U$17,$T$14:$T$17)/MINUTE(E51)","v":61058.833333333343}]
["גדי","ראפס","GILIUU8@gmail.com","2022-03-05","10:06:50.571","Mazda_6","פרטי","גלגלי הזהב","חולון","2009-02-01",110410,74616,{"$f":"MID(B52,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D52,\"MMM\")","v":"אפ#מרץ"},{"$f":"LEN(C52)&LEFT(F52,'[3]נתוני עזר'!$A$15)&HOUR(E52)","v":"17Maz10"},{"$f":"_xlfn.XLOOKUP(LEFT(F52,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F52)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K52+_xlfn.XLOOKUP(G52,$U$14:$U$17,$T$14:$T$17)/MINUTE(E52)","v":77453.666666666672}]
["מירב","ברטס","GH77JK@yahoo.com","2022-06-24","13:49:00","Nissan_Juke","גיפ","גלגלי הזהב","חולון","2008-05-20",97800,45473,{"$f":"MID(B53,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D53,\"MMM\")","v":"רט#יונ"},{"$f":"LEN(C53)&LEFT(F53,'[3]נתוני עזר'!$A$15)&HOUR(E53)","v":"16Nis13"},{"$f":"_xlfn.XLOOKUP(LEFT(F53,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F53)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K53+_xlfn.XLOOKUP(G53,$U$14:$U$17,$T$14:$T$17)/MINUTE(E53)","v":58708.571428571428}]
["ליה","רוטשילד","R5HJ9DT@gmail.com","2022-04-14","15:23:17.829","Nissan_Juke","גיפ","רכבי דניאלס","יהוד","2009-03-10",95000,39959,{"$f":"MID(B54,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D54,\"MMM\")","v":"וט#אפר"},{"$f":"LEN(C54)&LEFT(F54,'[3]נתוני עזר'!$A$15)&HOUR(E54)","v":"17Nis15"},{"$f":"_xlfn.XLOOKUP(LEFT(F54,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F54)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K54+_xlfn.XLOOKUP(G54,$U$14:$U$17,$T$14:$T$17)/MINUTE(E54)","v":57060.869565217392}]
["עמרי","יגאנה","HRNFSEKR@gmail.com","2022-12-03","13:54:01","BMW_540","פרטי","רכב דיל מאיר","חיפה","2011-10-29",80900,79021,{"$f":"MID(B55,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D55,\"MMM\")","v":"גא#דצמ"},{"$f":"LEN(C55)&LEFT(F55,'[3]נתוני עזר'!$A$15)&HOUR(E55)","v":"18BMW13"},{"$f":"_xlfn.XLOOKUP(LEFT(F55,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F55)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K55+_xlfn.XLOOKUP(G55,$U$14:$U$17,$T$14:$T$17)/MINUTE(E55)","v":64738.518518518518}]
["דן","טננבאום","OQAPSDFQ@hotmail.com","2022-05-31","11:59:30","renault_kangoo","מסחרי","רכב דיל","בני ברק","2010-04-27",76000,33193,{"$f":"MID(B56,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D56,\"MMM\")","v":"ננ#מאי"},{"$f":"LEN(C56)&LEFT(F56,'[3]נתוני עזר'!$A$15)&HOUR(E56)","v":"20ren11"},{"$f":"_xlfn.XLOOKUP(LEFT(F56,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F56)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K56+_xlfn.XLOOKUP(G56,$U$14:$U$17,$T$14:$T$17)/MINUTE(E56)","v":34220.338983050846}]
["מיטל","דורון","TUTUU7@yahoo.com","2023-01-15","16:12:41","fiat_ducato","מסחרי","סוכנות המוביל","תל אביב","2010-12-11",58100,29954,{"$f":"MID(B57,'[3]נתוני עזר'!$A$10,'[3]נתוני עזר'!$A$11)&'[3]נתוני עזר'!$A$12&TEXT(D57,\"MMM\")","v":"ור#ינו"},{"$f":"LEN(C57)&LEFT(F57,'[3]נתוני עזר'!$A$15)&HOUR(E57)","v":"16fia16"},{"$f":"_xlfn.XLOOKUP(LEFT(F57,SEARCH('[3]נתוני עזר'!$A$24,'[4]ניתוח רגישות'!F57)-'[3]נתוני עזר'!$A$25),$U$4:$U$8,$T$4:$T$8,$U$10)*K57+_xlfn.XLOOKUP(G57,$U$14:$U$17,$T$14:$T$17)/MINUTE(E57)","v":26245}]

{"sheet":"חתירה למטרה minIfs","index":6,"n_rows":41,"n_cols":23,"rows_kept":41,"cut":false,"hidden":false,"merged":[[27,16,27,20],[27,3,27,8]]}
["מספר לקוח","שם לקוח","כתובת דוא\"ל","מעמד לקוח","תחילת ההשקעה","סכום השקעה ","מספר קרן","דמי ניהול ","ערך השקעה נכון להיום","ערך השקעה נכון להיום בש\"ח"]
[1855,"NI_IAV","NI_IAV@colman.ac.il","שכיר","2022-09-15",2500,10,8.9999999999999993E-3,16761.877886011072,{"$f":"I2*$M$2","v":410891.59859707026},null,null,24.513458539152541,"שער הדולר שנתון"]
[1856,"KF_GLD","KF_GLD@colman.ac.il","עצמאי","2022-03-12",146726,13,2.8999999999999998E-3,214094.11260178176,{"$f":"I3*$M$2","v":5248187.1527404329}]
[1857,"CC_GB","CC_GB@hotmail.com","שכיר","2022-09-29",253094,10,6.0000000000000001E-3,307637.33883750002,7541255.1506882785]
[1858,"BJ_VLS","BJ_VLS@colman.ac.il","שכיר","2022-12-29",70131,14,1E-3,332458.09982047207,8149697.8459545793]
[1859,"DE_APS","DE_APS@hotmail.com","שכיר","2022-02-05",63372,15,1E-3,1229261.9753939065,30133462.467575278]
[1860,"BJ_DDX","BJ_DDX@colman.ac.il","עצמאי","2022-05-19",72483,15,1E-3,1877660.4186721272,46027950.823726989]
[1861,"CK_UUE","CK_UUE@ynet.co.il","עצמאי","2022-07-11",108877,13,2.8999999999999998E-3,986671.12314671697,24186721.669036116]
[1862,"JK_67J","JK_67J@yahoo.com","עצמאי","2022-05-05",96681,10,7.0000000000000001E-3,191421.76696540037,4692409.5479976619]
[1863,"DJ_IPO","DJ_IPO@yahoo.com","עצמאי","2022-10-27",66590,15,1E-3,377756.68354481296,9260122.7999635395,null,"תשובה לסעיף א שאלה 4"]
[1864,"LB_MI8","LB_MI8@walla.co.il","בעל שליטה","2022-05-26",224708,10,6.0000000000000001E-3,3453180.5195543682,84649397.494305238]
[1865,"LM_TBP","LM_TBP@ynet.co.il","שכיר","2022-07-17",49492,14,1.1000000000000001E-3,2044762.0534205888,50124189.818958022,null,"שכיר",{"$f":"_xlfn.MINIFS($J$2:$J$26,$D$2:$D$26,L12)","v":410891.59859707026}]
[1866,"BK_UDG","BK_UDG@colman.ac.il","שכיר","2022-04-28",76982,13,3.8999999999999998E-3,2617985.4305046364,64175877.306780823,null,"עצמאי",{"$f":"_xlfn.MINIFS($J$2:$J$26,$D$2:$D$26,L13)","v":559212.0130450225}]
[1867,"DK_EAU","DK_EAU@colman.ac.il","בעל שליטה","2022-09-13",184883,10,6.0000000000000001E-3,2226133.6383189736,54570234.645544961,null,"בעל שליטה",{"$f":"_xlfn.MINIFS($J$2:$J$26,$D$2:$D$26,L14)","v":3000000}]
[1868,"KL_XLD","KL_XLD@ynet.co.il","בעל שליטה","2022-10-12",8780,10,8.9999999999999993E-3,122381.75185310727,3000000]
[1869,"NE_ANL","NE_ANL@gmail.com","שכיר","2022-11-18",46900,14,1.1000000000000001E-3,80582.931834117058,1975366.3584789839]
[1870,"MK_MO5","MK_MO5@yahoo.com","שכיר","2022-05-25",162174,14,8.0000000000000004E-4,1078268.712803452,26432095.385372799,null,"סעיף ב שאלה 4"]
[1871,"LM_V7U","LM_V7U@walla.co.il","שכיר","2022-12-09",10321,14,1.1000000000000001E-3,372444.86881914415,9129911.8499181978,null,"המילים \"מה צריך להיות\" שייכות רק לחתיר למטרה "]
[1872,"FD_DIK","FD_DIK@walla.co.il","שכיר","2022-06-22",56091,15,1E-3,1453028.3037917621,35618749.081214502,null,"בתוך \"על ידי שינוי התא\" נכניס תמיד את שם המשתנה שהופיע אחרי המילים \"מה צריך להיות\", אצלינו מדובר ב\"שער הדולר\""]
[1873,"KD_HH7","KD_HH7@yahoo.com","עצמאי","2022-07-10",12866,10,8.0000000000000002E-3,133822.73527755728,3280458.0728223864]
[1874,"EL_NGQ","EL_NGQ@ynet.co.il","עצמאי","2022-07-01",71270,13,3.8999999999999998E-3,142479.52031448073,3492665.8139073658,null,"המילים \"משתמש\" ו\"לחצן\" אומרות שחובה כאן מאקרו"]
[1875,"KK_ZJH","KK_ZJH@colman.ac.il","עצמאי","2022-02-01",10129,14,1.1000000000000001E-3,22812.44860458418,559212.0130450225]
[1876,"MC_IEL","MC_IEL@colman.ac.il","בעל שליטה","2022-01-17",143689,13,2.8999999999999998E-3,1900016.8003544933,46575983.059183143]
[1877,"FJ_YQG","FJ_YQG@colman.ac.il","בעל שליטה","2022-02-09",25719,12,5.7999999999999996E-3,186489.11906743521,4571493.288262655]
[1878,"AI_MAH","AI_MAH@hotmail.com","שכיר","2022-09-16",215746,14,8.0000000000000004E-4,1094342.8807251898,26826128.834273696]
[1879,"GI_JDG","GI_JDG@gmail.com","בעל שליטה","2022-11-28",131191,10,6.0000000000000001E-3,203520.29998243746,4988986.4354953682]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"סעיף ג שאלה 4"]
[null,null,null,null,null,null,null,null,null,null,null,"המילים \"מרווחים (קפיצות)\" וינוע \"בין לבין\" מעידות על ניתוח רגישות"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ערך ראשון"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"M14","v":3000000},null,null,null,null,null,null,null,null,null,null,3.1]
[null,null,null,null,null,null,null,null,null,null,3.1,379383.43074463255]
[null,null,null,null,null,null,null,null,null,null,3.3,403859.78111525398,null,null,null,null,null,null,null,null,null,null,"מרווח"]
[null,null,null,null,null,null,null,null,null,null,3.5,428336.13148587546,null,null,null,null,null,null,null,null,null,null,0.2]
[null,null,null,null,null,null,null,null,null,null,3.7,452812.48185649695]
[null,null,null,null,null,null,null,null,null,null,3.9,477288.83222711837]
[null,null,null,null,null,null,null,null,null,null,4.0999999999999996,501765.1825977398]
[null,null,null,null,null,null,null,null,null,null,4.3,526241.53296836128]
[null,null,null,null,null,null,null,null,null,null,4.5,550717.88333898271]

{"sheet":"סינון ומיון דינמיים","index":7,"n_rows":59,"n_cols":23,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,14,0,22],[46,14,46,18],[46,1,46,7]]}
["מספר לקוח","שם לקוח","כתובת דוא\"ל","מעמד לקוח","תחילת ההשקעה","סכום השקעה בדולר ","מספר קרן","דמי ניהול ","ערך השקעה נכון להיום",null,null,null,null,null,"תוצאות הסינון הדינאמי, שאלה 3 סעיף ג"]
[1855,"NI_IAV","NI_IAV@colman.ac.il","שכיר","2022-09-15",2500,10,8.9999999999999993E-3,16761.877886011072,null,null,null,null,null,{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(A2:I26,(F2:F26>$G$36)+(D2:D26=$G$37)*(H2:H26>=$G$38)*(H2:H26<=$F$38)),U52,N52)","v":1859},"KK_ZJH","KK_ZJH@colman.ac.il","עצמאי",44593,10129,14,1.1000000000000001E-3,22812.44860458418]
[1856,"KF_GLD","KF_GLD@colman.ac.il","עצמאי","2022-03-12",146726,12,2.8999999999999998E-3,214094.11260178176,null,null,null,null,null,1863,"DJ_IPO","DJ_IPO@yahoo.com","עצמאי",44861,66590,15,1E-3,377756.68354481296]
[1855,"CC_GB","CC_GB@hotmail.com","שכיר","2022-09-29",253094,10,6.0000000000000001E-3,307637.33883750002,null,null,null,null,null,1873,"EL_NGQ","EL_NGQ@ynet.co.il","עצמאי",44743,71270,13,3.8999999999999998E-3,142479.52031448073]
[1858,"BJ_VLS","BJ_VLS@colman.ac.il","שכיר","2022-12-29",70131,13,1E-3,332458.09982047207,null,null,null,null,null,1860,"BJ_DDX","BJ_DDX@colman.ac.il","עצמאי",44700,72483,15,1E-3,1877660.4186721272]
[1859,"DE_APS","DE_APS@hotmail.com","שכיר","2022-02-05",63372,15,1E-3,1229261.9753939065,null,null,null,null,null,1861,"CK_UUE","CK_UUE@ynet.co.il","עצמאי",44753,108877,13,2.8999999999999998E-3,986671.12314671697]
[1860,"BJ_DDX","BJ_DDX@colman.ac.il","עצמאי","2022-05-19",72483,15,1E-3,1877660.4186721272,null,null,null,null,null,1856,"KF_GLD","KF_GLD@colman.ac.il","עצמאי",44632,146726,12,2.8999999999999998E-3,214094.11260178176]
[1861,"CK_UUE","CK_UUE@ynet.co.il","עצמאי","2022-07-11",108877,13,2.8999999999999998E-3,986671.12314671697,null,null,null,null,null,1855,"CC_GB","CC_GB@hotmail.com","שכיר",44833,253094,10,6.0000000000000001E-3,307637.33883750002]
[1861,"JK_67J","JK_67J@yahoo.com","עצמאי","2022-05-05",96681,10,7.0000000000000001E-3,191421.76696540037]
[1863,"DJ_IPO","DJ_IPO@yahoo.com","עצמאי","2022-10-27",66590,15,1E-3,377756.68354481296]
[1863,"LB_MI8","LB_MI8@walla.co.il","בעל שליטה","2022-05-26",224708,10,6.0000000000000001E-3,3453180.5195543682]
[1865,"LM_TBP","LM_TBP@ynet.co.il","שכיר","2022-07-17",49492,14,1.1000000000000001E-3,2044762.0534205888]
[1866,"BK_UDG","BK_UDG@colman.ac.il","שכיר","2022-04-28",76982,13,3.8999999999999998E-3,2617985.4305046364]
[1867,"DK_EAU","DK_EAU@colman.ac.il","בעל שליטה","2022-09-13",184883,10,6.0000000000000001E-3,2226133.6383189736,null,null,null,"תא עזר סעיף ב שאלה 3"]
[1868,"KL_XLD","KL_XLD@ynet.co.il","בעל שליטה","2022-10-12",8780,10,8.9999999999999993E-3,122381.75185310727,null,null,null,2]
[1869,"NE_ANL","NE_ANL@gmail.com","שכיר","2022-11-18",46900,14,1.1000000000000001E-3,80582.931834117058]
[1869,"MK_MO5","MK_MO5@yahoo.com","שכיר","2022-05-25",162174,14,8.0000000000000004E-4,1078268.712803452]
[1869,"LM_V7U","LM_V7U@walla.co.il","שכיר","2022-12-09",10321,14,1.1000000000000001E-3,372444.86881914415,null,null,null,"שאלה 3 סעיף ג"]
[1869,"FD_DIK","FD_DIK@walla.co.il","שכיר","2022-06-22",56091,15,1E-3,1453028.3037917621,null,null,null,"חוק"]
[1873,"KD_HH7","KD_HH7@yahoo.com","עצמאי","2022-07-10",12866,10,8.0000000000000002E-3,133822.73527755728,null,null,null,"המילים \"דוח דינאמי\" או \"סינון דינמי\" + קריטריונים בשאלה מעידות שמדובר על סינון  FILTER"]
[1873,"EL_NGQ","EL_NGQ@ynet.co.il","עצמאי","2022-07-01",71270,13,3.8999999999999998E-3,142479.52031448073]
[1859,"KK_ZJH","KK_ZJH@colman.ac.il","עצמאי","2022-02-01",10129,14,1.1000000000000001E-3,22812.44860458418]
[1859,"MC_IEL","MC_IEL@colman.ac.il","בעל שליטה","2022-01-17",143689,13,2.8999999999999998E-3,1900016.8003544933,null,null,null,"שאלה 3 סעיף ד"]
[1876,"FJ_YQG","FJ_YQG@colman.ac.il","בעל שליטה","2022-02-09",25719,12,5.7999999999999996E-3,186489.11906743521,null,null,null,"חוק"]
[1867,"AI_MAH","AI_MAH@hotmail.com","שכיר","2022-09-16",215746,14,8.0000000000000004E-4,1094342.8807251898,null,null,null,"המילים \"מיין דינאמית\""]
[1879,"GI_JDG","GI_JDG@gmail.com","בעל שליטה","2022-11-28",131191,10,6.0000000000000001E-3,203520.29998243746,null,null,null,"אומרות שמדובר ב SORT"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"שער הדולר"]
[null,null,null,null,null,"תאי עזר שאלה 3 ג סינון דינמי",null,null,null,null,null,null,4]
[null,null,null,null,null,null,250000]
[null,null,null,null,null,null,"עצמאי"]
[null,null,null,null,null,5.0000000000000001E-3,1E-3]
[]
[null,null,null,null,null,"דוח דינאמי =סינון דינאמי FILTER"]
[null,"ב\"מערך\"",null,null,null,"נסמן את כל הטבלה, ללא כותרות, ללא קיבוע"]
[null,"ב\"כלול\"",null,null,null,"בתנאים שנבנה נסמן את כל העמודה (לא רק תא ראשון), ללא כותרות: רק תאי העזר יקובעו!",null,null,null,null,null,null,{"$f":"COUNTIF($A$2:$A$26,A2)=1","v":false}]
[null,null,null,null,null,"פלוס   או"]
[null,null,null,null,null,"כפל   וגם"]
[]
[]
[null,"תאי עזר שאלה 3 סעיף ד",null,null,null,null,null,null,null,null,null,null,null,null,"שאלה 3 סעיף ד מיון דינאמי"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"רשימה נפתחת שתאפשר לבחור סדר עולה או סדר יורד",null,null,null,null,null,null,"רשימה נפתחת שתאפשר לבחור עמודת מיון"]
[null,null,null,"סדר עולה",1,null,null,null,null,null,null,null,null,"סדר עולה",null,null,null,null,null,null,"סכום השקעה בדולר "]
[null,null,null,"סדר יורד",-1,"מספר לקוח",1]
[null,null,null,null,null,"שם לקוח",2,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(N50,$D$50:$D$51,$E$50:$E$51)","v":1},null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(U50,$F$51:$F$59,$G$51:$G$59)","v":6}]
[null,null,null,null,null,"כתובת דוא\"ל",3]
[null,null,null,null,null,"מעמד לקוח",4]
[null,null,null,null,null,"תחילת ההשקעה",5]
[null,null,null,null,null,"סכום השקעה בדולר ",6]
[null,null,null,null,null,"מספר קרן",7]
[null,null,null,null,null,"דמי ניהול ",8]
[null,null,null,null,null,"ערך השקעה נכון להיום",9]

{"sheet":"שם משתמש וסיסמה","index":8,"n_rows":57,"n_cols":21,"rows_kept":57,"cut":false,"hidden":false,"merged":[[1,19,1,20],[11,19,11,20],[20,17,20,19],[27,17,27,19]]}
["שם פרטי לקוח","שם משפחה לקוח","כתובת דוא\"ל","תאריך הרכישה","שעת הרכישה","דגם הרכב ","סיווג הרכב","שם הסוכנות","מיקום הסוכנות","תאריך עליית הרכב לכביש","מחיר יבואן ","מספר ק\"מ ","שם משתמש","סיסמה"]
["אאוגן ","ליבוביץ","ELVLSUAM@colman.ac.il","2022-08-02","17:10:35","Mazda_6","פרטי","רכבי דניאלס","יהוד","2010-06-29",132100,53490,{"$f":"MID(B2,$S$22,$S$23)&$S$24&TEXT(D2,\"mmm\")","v":"יב#אוג"},{"$f":"LEN(C2)&LEFT(F2,$S$30)&MINUTE(E2)","v":"21Maz10"},null,null,null,{"$f":"RIGHT(C2,$R$36)=$R$35","v":true},null,"טבלה מס' 1"]
["אאוג'ן ","מנוליאו","KEZZLDMD@colman.ac.il","2022-05-03","19:16:55","Mazda_6","פרטי","גלגלי הזהב","חולון","2011-03-29",132100,25829,"נו#מאי","21Maz16",null,null,null,{"$f":"RIGHT(C3,$R$36)=$R$35","v":true},null,"אחוז ממחיר יבואן","סוג רכב"]
["אאוריקה ","גורכוב","BEXLDPPA11@ynet.co.il","2022-02-19","17:20:28.333","Citroen_C3","פרטי","רכב דיל מאיר","חיפה","2011-01-15",125000,65509,"ור#פבר","21Cit20",null,null,null,true,null,0.6,"Nissan"]
["אאוריקה ","יאסין","COZ66@walla.co.il","2022-06-28","17:09:30.994","Honda_Civic","פרטי","גלגלי הזהב","חולון","2009-05-24",119200,31704,"אס#יונ","17Hon9",null,null,null,true,null,0.7,"Mazda"]
["יוסי","שמעון","SVET6@walla.co.il","2022-11-08","19:35:47.084","Citroen_C5","פרטי","גלגלי הזהב","חולון","2010-10-04",114500,28286,"מע#נוב","17Cit35",null,null,null,true,null,0.8,"BMW"]
["דן","טננבאום","VWQXYKIY@colman.ac.il","2022-05-07","18:16:10","Mazda_3","פרטי","סוכנות המוביל","תל אביב","2011-04-03",99200,99037,"ננ#מאי","21Maz16",null,null,null,true,null,0.75,"Audi"]
["רם","אברמוביץ","AUTBPAME@ynet.co.il","2022-09-15","16:07:25","BMW_Z4","פרטי","סוכנות המוביל","תל אביב","2011-08-11",185200,23650,"בר#ספט","19BMW7",null,null,null,true,null,0.55000000000000004,"Citroen"]
["עומר","יגאנה","YIDOJL@colman.ac.il","2022-07-29","13:51:02","renault_kangoo","מסחרי","רכבי דניאלס","יהוד","2011-06-25",148000,56507,"גא#יול","19ren51",null,null,null,true]
["רואי","חנוביץ","KE78OMD@colman.ac.il","2022-10-31","13:33:55","toyota_hilux","מסחרי","סוכנות המוביל","תל אביב","2010-09-27",135200,76935,"נו#אוק","20toy33",null,null,null,true,null,null,0.45]
["ירדן","קלנר","BDZJHBUB@colman.ac.il","2022-06-19","16:20:30.696","Audi_A4","פרטי","רכב דיל מאיר","חיפה","2008-05-15",133200,43076,"לנ#יונ","21Aud20",null,null,null,{"$f":"RIGHT(C11,$R$36)=$R$35","v":true}]
["שירי","מנור","FF22WT@ynet.co.il","2022-06-03","15:46:52","Nissan_Juke","גיפ","רכב דיל מאיר","חיפה","2008-04-30",133200,13221,"נו#יונ","17Nis46",null,null,null,true,null,"טבלה מס' 2"]
["אמיר","שרון","EAUDGT@colman.ac.il","2022-09-14","11:51:37.007","Honda_Accord","פרטי","סוכנות המוביל","תל אביב","2011-08-10",125900,40682,"רו#ספט","19Hon51",null,null,null,true,null,"תוספת סיווג","סווג הרכב"]
["עמית","כהן","FFNGQQWT@ynet.co.il","2023-01-10","14:09:00.555","Audi_A4","פרטי","רכב דיל","בני ברק","2008-12-06",125300,23927,"הן#ינו","19Aud9",null,null,null,true,null,1000,"פרטי"]
["ענבר","יפת","JXI45LUBY@colman.ac.il","2022-03-28","14:01:39","Nissan_Micra","פרטי","גלגלי הזהב","חולון","2008-02-24",117200,28169,"פת#מרץ","22Nis1",null,null,null,true,null,1200,"מסחרי"]
["אורי","גוזמן","KIEAUDGT@colman.ac.il","2022-09-10","14:32:09","Nissan_Pathfinder","מסחרי","גלגלי הזהב","חולון","2011-08-06",114500,22743,"וז#ספט","21Nis32",null,null,null,true,null,1400,"גיפ"]
["נדב","רווח","EXOOYULR@colman.ac.il","2023-01-26","14:23:21.892","Audi_A6","מנהלים","רכבי דניאלס","יהוד","2010-12-22",114500,10716,"וו#ינו","21Aud23",null,null,null,true,null,1600,"מנהלים"]
["טל","בן סלומון","FAOL5@walla.co.il","2022-07-13","13:55:29","Honda_Civic","פרטי","רכב דיל","בני ברק","2008-06-09",114500,40383,"ן #יול","17Hon55",null,null,null,true]
["תומר","בוקאי","CTA86@walla.co.il","2022-10-26","15:48:53","Subaru_B4","פרטי","רכב דיל","בני ברק","2010-09-22",112500,20389,"וק#אוק","17Sub48",null,null,null,true]
["טלי","רונן","XPDDXH@colman.ac.il","2022-04-19","16:37:49.888","toyota_hilux","מסחרי","רכב דיל מאיר","חיפה","2010-03-15",112000,38679,"ונ#אפר","19toy37"]
["אורי","לוין","WTUUETX@ynet.co.il","2022-10-15","13:38:56.356","Audi_A3","פרטי","רכבי דניאלס","יהוד","2009-09-11",110410,26284,"וי#אוק","18Aud38",null,null,null,"תאי עזר לכבוד שאלה 1 סעיף א 1"]
["אריק","לוין","JXIELUBY@colman.ac.il","2022-05-15","09:24:14.616","fiat_ducato","מסחרי","רכב דיל","בני ברק","2008-04-11",106000,6474,"וי#מאי","21fia24",null,null,null,"אות שנייה",2]
["מושיקו","דגנוש","MYGLDVTD@colman.ac.il","2022-06-21","10:58:13.226","Nissan_Navare","מסחרי","סוכנות המוביל","תל אביב","2011-05-17",103000,57178,"גנ#יונ","21Nis58",null,null,null,"שנייה ושלישית",2]
["אסי","וידר","NYIAVES@colman.ac.il","2022-07-08","16:17:18","BMW_325","פרטי","סוכנות המוביל","תל אביב","2011-06-04",99600,18823,"יד#יול","20BMW17",null,null,null,null,"#"]
["מור","אילומים","GIMI89FG@walla.co.il","2022-10-13","14:29:31.541","Mazda_3","פרטי","סוכנות המוביל","תל אביב","2011-09-09",92200,63326,"יל#אוק","20Maz29"]
["לישי","ברמן","FADIKOL55@walla.co.il","2022-07-20","12:51:18","Mazda_3","פרטי","רכבי דניאלס","יהוד","2009-06-16",90890,48294,"רמ#יול","21Maz51"]
["אלון","כהן","RVPNJHQO33@ynet.co.il","2022-10-30","12:56:34.880","Mazda_6","פרטי","רכב דיל","בני ברק","2010-09-26",90890,8931,"הן#אוק","21Maz56"]
["עמרי","יגאנה","RAV8O@walla.co.il","2022-09-27","09:29:23","Audi_A6","מנהלים","גלגלי הזהב","חולון","2008-08-23",90890,50833,"גא#ספט","17Aud29",null,null,null,"תאי עזר לכבוד שאלה 1 א 2"]
["נוי","סליקטר","RAV7U8O@walla.co.il","2022-11-26","10:05:24","renault_kangoo","מסחרי","סוכנות המוביל","תל אביב","2009-10-22",90100,74516,"לי#נוב","19ren5"]
["נטע","פוקס","EXOOIS5@colman.ac.il","2022-10-09","14:05:53.175","BMW_325","פרטי","רכבי דניאלס","יהוד","2010-09-05",89000,38944,"וק#אוק","20BMW5",null,null,null,null,3]
["עדי","גירו","YXYQGYVQ@colman.ac.il","2022-04-25","09:02:29.426","Volkswagen_Passat","פרטי","סוכנות המוביל","תל אביב","2008-03-21",85300,40146,"יר#אפר","21Vol2"]
["שרה","שוורץ","RV7HQO33@ynet.co.il","2022-03-28","12:38:25.082","Honda_Civic","פרטי","רכבי דניאלס","יהוד","2008-02-24",79000,33741,"וו#מרץ","19Hon38"]
["אודי","חיים","SVETR@walla.co.il","2022-08-07","15:35:40.927","Hyundai_Tuscon","גיפ","סוכנות המוביל","תל אביב","2009-07-03",69900,52888,"יי#אוג","17Hyu35"]
["גלי","גרבר","BD12BUB@colman.ac.il","2022-05-17","09:52:31.682","Subaru_B4","פרטי","סוכנות המוביל","תל אביב","2008-04-13",42320,34120,{"$f":"MID(B34,$S$22,$S$23)&$S$24&TEXT(D34,\"mmm\")","v":"רב#מאי"},{"$f":"LEN(C34)&LEFT(F34,$S$30)&MINUTE(E34)","v":"20Sub52"},null,null,null,"תא עזר סעיף ב 2"]
["אורן","ברבור","JILI6@yahoo.com","2023-01-27","19:07:43.211","Audi_A6","מנהלים","סוכנות המוביל","תל אביב","2010-12-23",156000,54194,"רב#ינו","15Aud7",null,null,null,"il"]
["נועם","מי דן","TAB@hotmail.com","2022-09-21","18:16:34.929","Hyundai_Tuscon","גיפ","רכב דיל מאיר","חיפה","2010-08-17",148000,37483,"י #ספט","15Hyu16",null,null,null,2]
["דור","וויינר","GT67JK@yahoo.com","2022-09-28","17:02:19","Nissan_qashqai","גיפ","רכב דיל","בני ברק","2009-08-24",132100,20688,"וי#ספט","16Nis2"]
["שירי","הסנר","LCMAHAOP@hotmail.com","2022-04-11","18:23:19.898","Nissan_Micra","פרטי","סוכנות המוביל","תל אביב","2008-03-07",114600,56149,"סנ#אפר","20Nis23"]
["צחי","וינר","TUKU7K@yahoo.com","2022-11-15","19:26:56.881","toyota_hilux","מסחרי","רכב דיל","בני ברק","2008-10-11",98700,39354,"ינ#נוב","16toy26",null,null,null,"תא עזר סעיף ב 3"]
["מיטל","דורון","RVHJHDT@gmail.com","2022-05-18","17:02:22.317","Audi_A3","פרטי","רכב דיל","בני ברק","2009-04-14",97800,17489,"ור#מאי","17Aud2",null,null,null,"17:00:00"]
["מיכל","בן עמי","RFANLGI22@gmail.com","2022-12-09","10:49:57","Ford_Focus","פרטי","רכב דיל מאיר","חיפה","2010-11-05",148000,60630,"ן #דצמ","19For49"]
["דניאלה","שטיין","XIJDGGVC@gmail.com","2022-12-09","14:58:59.772","Nissan_Navare","מסחרי","גלגלי הזהב","חולון","2011-11-05",133500,30206,"טי#דצמ","18Nis59"]
["אמה","בנוב","YEGB@hotmail.com","2022-08-25","14:44:53.260","Citroen_C3","פרטי","רכב דיל מאיר","חיפה","2010-07-21",133200,37698,"נו#אוג","16Cit44"]
["אבי ","ממלידר","GZBJLAY@gmail.com","2022-12-20","16:33:01.363","Hyundai_Tuscon","גיפ","רכב דיל מאיר","חיפה","2011-11-16",124900,49309,"מל#דצמ","17Hyu33"]
["אבי ","ברלב","PAB@hotmail.com","2022-06-23","16:43:58.850","Volkswagen_Golf","פרטי","רכב דיל מאיר","חיפה","2009-05-19",122300,6330,"רל#יונ","15Vol43"]
["אבי ","אור אורטרגר","MIKI6@yahoo.com","2023-01-26","12:36:06.172","Honda_Accord","פרטי","רכבי דניאלס","יהוד","2008-12-22",118800,43882,"ור#ינו","15Hon36"]
["אריה","אונרוביל","GGHH77JK@yahoo.com","2022-03-12","12:46:17.416","Nissan_Pathfinder","מסחרי","סוכנות המוביל","תל אביב","2009-02-08",117800,36392,"ונ#מרץ","18Nis46"]
["ליה","רוטשילד","YAKI5@yahoo.com","2022-12-02","15:22:52","Nissan_qashqai","גיפ","רכבי דניאלס","יהוד","2010-10-28",114600,31480,"וט#דצמ","15Nis22"]
["גדי","ראפס","ARIPOR5@yahoo.com","2022-11-28","12:39:01","Ford_Focus","פרטי","רכב דיל","בני ברק","2011-10-24",112000,7902,"אפ#נוב","17For39"]
["אסי","כצוביץ","TIMO5GH@yahoo.com","2022-07-01","12:36:10.706","Citroen_C5","פרטי","גלגלי הזהב","חולון","2010-05-27",112000,49972,"צו#יול","17Cit36"]
["לנה","יצחקי","PADI5@yahoo.com","2022-10-02","14:03:12","Citroen_C5","פרטי","רכב דיל","בני ברק","2010-08-28",110410,12170,"צח#אוק","15Cit3"]
["יאנה","גלון","GILIUU8@gmail.com","2022-03-05","10:06:50.571","Mazda_6","פרטי","גלגלי הזהב","חולון","2009-02-01",110410,74616,"לו#מרץ","17Maz6"]
["אלכס","עמרמי ויצמן","GH77JK@yahoo.com","2022-06-24","13:49:00","Nissan_Juke","גיפ","גלגלי הזהב","חולון","2008-05-20",97800,45473,"מר#יונ","16Nis49"]
["מירב","ברטס","R5HJ9DT@gmail.com","2022-04-14","15:23:17.829","Nissan_Juke","גיפ","רכבי דניאלס","יהוד","2009-03-10",95000,39959,"רט#אפר","17Nis23"]
["אבי ","היינריך","HRNFSEKR@gmail.com","2022-12-03","13:54:01","BMW_540","פרטי","רכב דיל מאיר","חיפה","2011-10-29",80900,79021,"יי#דצמ","18BMW54"]
["אבי ","רינגל","OQAPSDFQ@hotmail.com","2022-05-31","11:59:30","renault_kangoo","מסחרי","רכב דיל","בני ברק","2010-04-27",76000,33193,"ינ#מאי","20ren59"]
["מור","גולדברג","TUTUU7@yahoo.com","2023-01-15","16:12:41","fiat_ducato","מסחרי","סוכנות המוביל","תל אביב","2010-12-11",58100,29954,"ול#ינו","16fia12"]

{"sheet":"חשוב ביותר","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}