{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["חשוב","סולבר- חברת ריי","ש 2 מועד ב 2024","סינון ומיון דינמיים","xlookup  בתוך  xlookup","xlookup + xlookup","search X 2","רגישות סדר 1","חתירה למטרה minIfs","שם משתמש וסיסמה"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":2,"defined_names":58,"comments":2,"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":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"נושאים למבחן:"]
[]
[null,"יוניק",null,"countifs",null,"mid",null,"חתירה למטרה"]
[null,"עיצוב מותנה",null,"xlookup",null,"len",null,"ניתוח רגישות"]
[null,"מיון",null,"iferror",null,"find",null,"הקלטת מאקרו"]
[null,"פילטר",null,"averageifs",null,"text",null,"סולבר"]
[null,"SORT",null,"sumifs",null,"left"]
[null,null,null,"minifs",null,"right"]
[]
[]
[null,"בשלב הזה רק מבחנים, לא תרגילי כיתה ולא תרגילי בית!"]

{"sheet":"סולבר- חברת ריי","index":1,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,3],[8,0,8,2],[40,0,41,5]]}
["חברת RAY"]
[]
["עלות התשומות ליחידה:"]
["עלות לק\"ג עץ",150]
["עלות לק\"ג בד",180]
["עלות לק\"ג פלסטיק",175]
[]
[]
["מספר יחידות תשומה לצורך ייצור יח' אחת של מוצר:"]
["מוצרים:","כורסא","שולחן","כיסא","שידה"]
["עץ (ק\"ג)",6,20,4,2]
["בד (ק\"ג)",8,0,2,2]
["פלסטיק (ק\"ג)",2,0,1,2]
[]
["מחיר מכירה ליח' מוצר:",5000,2500,150,1500]
[]
["תוכנית ייצור:"]
["מוצרים:","כורסא","שולחן","כיסא","שידה"]
["כמות יח' מוצר שיוצרו לצורך מכירה"]
[]
["קיבולת ייצור של כל מוצר",500,750,1000,1200]
[]
["אילוצי תשומות:","בשימוש",null,"במלאי"]
["עץ (ק\"ג)",null,null,10000]
["בד (ק\"ג)",null,null,6000]
["פלסטיק (ק\"ג)",null,null,4000]
[]
[]
["סיכום מכירות ופידיון:"]
["סניפים","כורסא","שולחן","כיסא","שידה","סה\"כ"]
["סה\"כ פידיון:",{"$f":"B15*B19","v":0},{"$f":"C15*C19","v":0},0,0,{"$f":"SUM(B31:E31)","v":0}]
["עלות התשומות:"]
["עץ",{"$f":"B4*B11*B19","v":0},{"$f":"B4*C11*C19","v":0},{"$f":"B4*D11*D19","v":0},{"$f":"B4*E11*E19","v":0},{"$f":"SUM(B33:E33)","v":0}]
["בד",{"$f":"B5*B12*B19","v":0},{"$f":"B5*C12*C19","v":0},{"$f":"B5*D12*D19","v":0},{"$f":"B5*E12*E19","v":0},{"$f":"SUM(B34:E34)","v":0}]
["פלסטיק",{"$f":"B6*B13*B19","v":0},{"$f":"B6*C13*C19","v":0},{"$f":"B6*D13*D19","v":0},{"$f":"B6*E13*E19","v":0},{"$f":"SUM(B35:E35)","v":0}]
[]
["רווח",{"$f":"B31-B33-B34-B35","v":0},{"$f":"C31-C33-C34-C35","v":0},0,0,{"$f":"B37+C37+D37+E37","v":0}]
[]
[]
[]
["הכנת תאי עזר:"]

{"sheet":"ש 2 מועד ב 2024","index":2,"n_rows":51,"n_cols":33,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["מספר לקוח","שם פרטי","שם משפחה","כתובת אימייל","מספר טלפון נייד","עיר מגורים","תאריך הצטרפות למועדון לקוחות","מוצר מועדף","סיווג המוצר","רמת שביעות רצון מהשירות","סכום קנייה ממוצעת","ממוצע מספר היחידות בהזמנה","שעת ביצוע ההזמנה","שעת קבלת המשלוח"]
[1,"אבי","שחר","avi@hotmail.com","053-2223333","תל אביב","2014-03-22","Palermo Kaza","קפסולות קפה",7,320,7,"16:30:00","17:15:00",null,null,null,null,null,null,null,null,null,null,null,null,"תא עזר שאלה 4 א. "]
[2,"אביב","גור","aviv@gov.il","053-1112222","ירושלים","2013-04-11","Altission","קפסולות קפה",7,1200,17,"16:15:00","17:00:00",null,null,null,null,null,null,null,null,null,null,null,null,"שווה לקטגוריה",{"$f":"'ש 2 מועד ב 2024'!I2","v":"קפסולות קפה"},null,"עלות משלוח ממוצעת",null,"ערך לקבל","פערים"]
[3,"אורן","כהן","oren@gmail.com","050-4445555","רמת גן","2013-12-01","Ispirazione Napolion","קפסולות קפה",2,200,9,"14:30:00","15:15:00",null,null,null,null,null,null,null,null,null,null,null,null,"הזמנה קטן שווה",8,null,{"$f":"AVERAGE(U2:U42)","v":{"$error":"#DIV/0!"}},null,2.9146141215106902]
[4,"איליה","קליין","ilia@gmail.com","053-1234567","חיפה","2016-09-14","Vertuo Ne","מכונות קפה",7,600,17,"15:30:00","16:15:00",null,null,null,null,null,null,null,null,null,null,null,null,"יקבל",null,null,null,null,{"$f":"AF4+$AG$5","v":10.91461412151069},8]
[5,"אילן","רון","ilan@hotmail.com","053-9998888","רעננה","2016-04-25","Sccuro","קפסולות קפה",6,700,17,"17:00:00","17:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF5+$AG$6","v":13.91461412151069},3]
[6,"אלון","פלג","alon@gmail.com","052-6667777","נתניה","2013-07-16","זוג ספלי קפוצ'ינו ","אביזרים נלווים",7,600,17,"12:45:00","13:30:00",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ש 2 מועד ב 2024'!F31","v":"פתח תקווה"}]
[7,"אלונה","רובינוביץ","alona@yahoo.com","053-5556666","אילת","2016-10-08","Odacioo","קפסולות קפה",7,500,14,"18:15:00","19:00:00",null,null,null,null,null,null,null,null,null,null,null,null,"ולאחר","16:00:00"]
[8,"אמיר","גיל","amir@gov.il","052-5556666","רמת גן","2014-03-03","Creatista Pluss","מכונות קפה",7,500,18,"21:30:00","22:15:00",null,null,null,null,null,null,null,null,null,null,null,null,"יקבל"]
[9,"גיל","כהן","gil@gmail.com","050-5556666","רעננה","2015-11-17","Stormion","קפסולות קפה",7,680,20,"21:45:00","22:30:00",null,null,null,null,null,null,null,null,null,null,null,null,"היתר"]
[10,"דור","לוי","dor@gmail.com","050-5556666","פתח תקווה","2015-06-03","Lattissima Onn","מכונות קפה",2,300,8,"18:45:00","19:30:00"]
[11,"דינה","לייבה","dina@yahoo.com","052-8765432","פתח תקווה","2019-04-02","Vertuo Pl","מכונות קפה",7,400,10,"20:30:00","21:15:00"]
[12,"דנה","מלמד","dana@yahoo.com","052-8889999","באר שבע","2017-02-28","כוסות אספרסו קריסטל ","אביזרים נלווים",3,250,7,"21:00:00","21:45:00"]
[13,"דני","חיון","danny@hotmail.com","050-1234567","רעננה","2023-05-03","Romm","קפסולות קפה",3,600,16,"18:20:00","19:00:00"]
[14,"דניאל","מינץ","dan@yahoo.com","052-4445555","ירושלים","2020-11-08","Grann Latisimma","מכונות קפה",4,1000,19,"21:15:00","22:00:00"]
[15,"יהונתן","גלעדי","yonatan@gov.il","053-4445555","חיפה","2015-03-26","ESENZA PLUSS","מכונות קפה",5,650,17,"18:00:00","18:45:00"]
[16,"יואב","פרידמן","yoav@gmail.com","054-8889999","רמת גן","2014-09-30","כוס מאג Festive","אביזרים נלווים",5,650,18,"15:45:00","16:30:00"]
[17,"יובל","שרי","yuval@gmail.com","054-6667777","חולון","2018-07-09","Palermo Kaza","קפסולות קפה",7,800,18,"08:30:00","09:15:00"]
[18,"יוסי","כהן","yossi@gmail.com","053-7778888","אילת","2023-01-15","Ristro","קפסולות קפה",3,400,18,"10:30:00","11:00:00"]
[19,"יעל","גולדשטיין","yael@colman.ac.il","054-4445555","רעננה","2019-06-30","Intenso","קפסולות קפה",3,450,13,"13:30:00","14:15:00"]
[20,"יעל","רוזנברג","yael@yahoo.com","050-9876543","תל אביב","2022-04-19","Vertuo Pl","מכונות קפה",5,500,14,"14:00:00","14:45:00"]
[21,"יפה","קרן","yafeh@gmail.com","054-1112222","חולון","2020-06-27","Sccuro","קפסולות קפה",5,450,13,"14:30:00","15:15:00"]
[22,"מאיה","אליהו","maya@muni.il","053-1112233","באר שבע","2014-10-18","Pixie","מכונות קפה",4,500,14,"11:30:00","12:15:00"]
[23,"מרים","אזולאי","miriam@net.il","050-6667777","רמת גן","2016-05-19","כוס מאג Festive","אביזרים נלווים",5,1500,20,"11:00:00","11:45:00"]
[24,"נועה","חיים","noa@org.il","054-1239876","תל אביב","2015-10-21","כוסות אספרסו קריסטל ","אביזרים נלווים",6,550,19,"14:00:00","14:45:00"]
[25,"נועה","יוסף","noa@muni.il","054-6667777","תל אביב","2017-06-12","CITIS PLATINUM","מכונות קפה",6,350,15,"14:15:00","15:00:00"]
[26,"נועה","יחיאל","noa@muni.il","052-9876543","נתניה","2018-09-05","Altission","קפסולות קפה",6,350,15,"09:00:00","09:45:00"]
[27,"נועם","שור","noam@gmail.com","050-1112222","חולון","2013-01-07","Atelierer","מכונות קפה",6,450,18,"09:45:00","10:30:00"]
[28,"נועם","יצחקי","noam@yahoo.com","050-8889999","רמת גן","2019-12-05","מקציף חלב אירוצ'ינו","אביזרים נלווים",7,450,13,"10:30:00","11:15:00"]
[29,"ניסן","דויד","nissan@gov.il","050-3334444","אשדוד","2015-01-14","Intenso","קפסולות קפה",7,350,15,"11:45:00","12:30:00"]
[30,"ניר","גולדברג","nir@colman.ac.il","052-5556666","פתח תקווה","2020-03-09","Citi & Milk","מכונות קפה",6,400,12,"16:00:00","16:45:00"]
[31,"ניר","סולם","nir@gmail.com","052-1234567","חיפה","2017-11-26","Vertuo Ne","מכונות קפה",6,400,17,"10:15:00","11:00:00"]
[32,"עדי","אברהם","adi@hotmail.com","054-5556666","נתניה","2017-08-14","Essenza Mini","מכונות קפה",4,650,18,"19:15:00","20:00:00"]
[33,"עדן","חיים","eden@hotmail.com","054-1112233","חיפה","2013-09-17","Atelierer","מכונות קפה",7,850,19,"17:30:00","18:15:00"]
[34,"עירית","גולן","yael@bgu.ac.il","050-1239876","פתח תקווה","2014-08-03","Kazar","קפסולות קפה",7,900,19,"13:15:00","14:00:00"]
[35,"קובי","גבע","yam@org.il","054-3334444","נתניה","2018-12-27","Creatista Pluss","מכונות קפה",7,935,19,"12:00:00","12:45:00"]
[36,"רבקה","אביב","rivka@org.il","054-9876543","אשדוד","2012-08-10","Kazar","קפסולות קפה",7,890,19,"12:15:00","13:00:00"]
[37,"רוני","ברקוביץ'","roni@org.il","053-6667777","פתח תקווה","2021-05-24","כוסות אספרסו קריסטל ","אביזרים נלווים",5,600,8,"17:45:00","18:30:00"]
[38,"שיר","אהרונוביץ","shir@yahoo.com","052-1112233","חיפה","2021-02-08","Odacioo","קפסולות קפה",3,500,11,"10:00:00","10:45:00"]
[39,"שרה","לוי","sarah@yahoo.com","052-1239876","נתניה","2022-11-20","Diavol","קפסולות קפה",3,350,10,"14:45:00","15:30:00"]
[40,"תמר","כהן","tamar@gmail.com","052-3334444","חיפה","2019-09-22","Stormion","קפסולות קפה",1,500,7,"19:45:00","20:30:00"]
[41,"תמר","זריף","tamar@org.il","053-8889999","פתח תקווה","2018-02-13","זוג ספלי קפוצ'ינו ","אביזרים נלווים",7,700,14,"19:30:00","20:15:00"]
[]
[]
["נתונים עבור שאלה 2 סעיף ב':"]
[]
["                                       סיווג מוצר \nממוצע מספר המוצרים בהזמנה","אביזרים נלווים","קפסולות קפה","מכונות קפה"]
[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]

{"sheet":"סינון ומיון דינמיים","index":3,"n_rows":44,"n_cols":21,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,14,0,22],[44,4,44,6],[41,1,41,8],[41,11,41,22]]}
["מספר לקוח","שם לקוח","כתובת דוא\"ל","מעמד לקוח","תחילת ההשקעה","סכום השקעה בדולר ","מספר קרן","דמי ניהול ","ערך השקעה נכון להיום",null,null,null,null,null,"תוצאות הסינון הדינאמי, שאלה 3 סעיף ג"]
[1855,"NI_IAV","NI_IAV@colman.ac.il","שכיר","2022-09-15",2500,10,8.9999999999999993E-3,16761.877886011072]
[1856,"KF_GLD","KF_GLD@colman.ac.il","עצמאי","2022-03-12",146726,12,2.8999999999999998E-3,214094.11260178176]
[1855,"CC_GB","CC_GB@hotmail.com","שכיר","2022-09-29",253094,10,6.0000000000000001E-3,307637.33883750002]
[1858,"BJ_VLS","BJ_VLS@colman.ac.il","שכיר","2022-12-29",70131,13,1E-3,332458.09982047207]
[1859,"DE_APS","DE_APS@hotmail.com","שכיר","2022-02-05",63372,15,1E-3,1229261.9753939065]
[1860,"BJ_DDX","BJ_DDX@colman.ac.il","עצמאי","2022-05-19",72483,15,1E-3,1877660.4186721272]
[1861,"CK_UUE","CK_UUE@ynet.co.il","עצמאי","2022-07-11",108877,13,2.8999999999999998E-3,986671.12314671697]
[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]
[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]
[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]
[1869,"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]
[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]
[1876,"FJ_YQG","FJ_YQG@colman.ac.il","בעל שליטה","2022-02-09",25719,12,5.7999999999999996E-3,186489.11906743521]
[1867,"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]
[]
[]
[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,"דוח דינאמי =סינון דינאמי FILTER"]
[null,"ב\"מערך\"",null,null,null,"נסמן את כל הטבלה, ללא כותרות, ללא קיבוע"]
[null,"ב\"כלול\"",null,null,null,"בתנאים שנבנה נסמן את כל העמודה (לא רק תא ראשון), ללא כותרות: רק תאי העזר יקובעו!"]
[null,null,null,null,null,"פלוס   או"]
[null,null,null,null,null,"כפל   וגם"]
[]
[]
[null,"תאי עזר שאלה 3 סעיף ד",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,"רשימה נפתחת שתאפשר לבחור עמודת מיון"]

{"sheet":"xlookup  בתוך  xlookup","index":4,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,7,2,16],[8,10,8,15],[31,0,33,15]]}
["מעמד לקוח","תחילת ההשקעה","סכום השקעה ","מספר קרן","ערך השקעה נכון להיום","ערך ההשקעה בשקלים"]
["שכיר","2022-09-15",2500,10,16761.877886011072,null,null,"חוק: בכל פעם שנקבל טבלה עם קטגוריות בשורות ובעמודות (דומה לריבוע הקסם) נעבוד עם XLOOKUP בתוך XLOOKUP"]
["עצמאי","2022-03-12",146726,13,214094.11260178176]
["שכיר","2022-09-29",253094,10,307637.33883750002]
["שכיר","2022-12-29",70131,14,332458.09982047207]
["שכיר","2022-02-05",63372,15,1229261.9753939065]
["עצמאי","2022-05-19",72483,15,1877660.4186721272]
["עצמאי","2022-07-11",108877,13,986671.12314671697]
["עצמאי","2022-05-05",96681,10,191421.76696540037,null,null,null,null,null,"במבחן קיבלנו את טבלת העזר הבאה:"]
["עצמאי","2022-10-27",66590,15,377756.68354481296]
["בעל שליטה","2022-05-26",224708,10,3453180.5195543682]
["שכיר","2022-07-17",49492,14,2044762.0534205888,null,null,null,null,null,"מעמד לקוח/מספר קרן",10,13,14,15,12]
["שכיר","2022-04-28",76982,13,2617985.4305046364,null,null,null,null,null,"עצמאי",0.12,0.2,0.18,0.15,0.09]
["בעל שליטה","2022-09-13",184883,10,2226133.6383189736,null,null,null,null,null,"בעל שליטה",0.14000000000000001,0.25,0.16,0.14000000000000001,0.12]
["בעל שליטה","2022-10-12",8780,10,122381.75185310727,null,null,null,null,null,"שכיר",0.13,0.27,0.11,0.1,0.26]
["שכיר","2022-11-18",46900,14,80582.931834117058]
["שכיר","2022-05-25",162174,14,1078268.712803452]
["שכיר","2022-12-09",10321,14,372444.86881914415]
["שכיר","2022-06-22",56091,15,1453028.3037917621,null,null,null,null,null,"השאלה ממועד ב 2023, שאלה מספר 1, 10 נקודות"]
["עצמאי","2022-07-10",12866,10,133822.73527755728]
["עצמאי","2022-07-01",71270,13,142479.52031448073,null,null,null,null,null,3.1,"שער הדולר שנתון"]
["עצמאי","2022-02-01",10129,14,22812.44860458418]
["בעל שליטה","2022-01-17",143689,13,1900016.8003544933]
["בעל שליטה","2022-02-09",25719,12,186489.11906743521]
["שכיר","2022-09-16",215746,14,1094342.8807251898]
["בעל שליטה","2022-11-28",131191,10,203520.29998243746]
[]
[]
[]
[]
[]
["דוגמה נוספת ממועד א 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":5,"n_rows":59,"n_cols":29,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,24,1,25],[11,24,11,25],[19,24,19,25]]}
["שם פרטי לקוח","שם משפחה לקוח","כתובת דוא\"ל","תאריך הרכישה","שעת הרכישה","דגם הרכב ","סיווג הרכב","שם הסוכנות","מיקום הסוכנות","תאריך עליית הרכב לכביש","מחיר יבואן ","מספר ק\"מ ","שם משתמש","מחיר רכישה"]
["יוסי","שמעון","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":"S2+T2","v":0},null,null,null,null,null,null,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,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D3,\"MMM\")","v":"וק#מאי"},0,null,null,null,null,null,null,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,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D4,\"MMM\")","v":"וז#פבר"},0,null,null,null,null,null,null,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,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D5,\"MMM\")","v":"רב#יונ"},0,null,null,null,null,null,null,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,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D6,\"MMM\")","v":"רל#נוב"},0,null,null,null,null,null,null,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,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D7,\"MMM\")","v":"לי#מאי"},0,null,null,null,null,null,null,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,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D8,\"MMM\")","v":"רו#ספט"},0,null,null,null,null,null,null,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,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D9,\"MMM\")","v":"יב#יול"},0]
["מיכל","בן עמי","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":"ן #אוק"},0,null,null,null,null,null,null,null,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":"גנ#יונ"},0]
["אבי ","היינריך","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":"יי#יונ"},0,null,null,null,null,null,null,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,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D13,\"MMM\")","v":"הן#ספט"},0,null,null,null,null,null,null,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,'[2]נתוני עזר'!$A$10,'[2]נתוני עזר'!$A$11)&'[2]נתוני עזר'!$A$12&TEXT(D14,\"MMM\")","v":"וי#ינו"},0,null,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":"ול#מרץ"},null,null,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":"פת#ספט"},null,null,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":"יר#ינו"},null,null,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":"מר#יול"}]
["אבי ","אור אורטרגר","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":"ור#אוק"}]
["רם","אברמוביץ","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":"בר#אפר"},null,null,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":"גא#אוק"}]
["אסי","וידר","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":"יד#מאי"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"רועי עידן                   052-546-6016    www.roy-idan.co.il"]
["אאוריקה ","גורכוב","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":"ור#יונ"}]
["אאוג'ן ","מנוליאו","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":"נו#יול"}]
["שירי","מנור","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":"נו#אוק"}]
["טלי","רונן","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":"ונ#יול"}]
["שרה","שוורץ","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":"וו#אוק"}]
["יאנה","גלון","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":"לו#ספט"}]
["תומר","בוקאי","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":"וק#נוב"}]
["דניאלה","שטיין","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":"טי#אוק"}]
["מור","אילומים","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":"יל#אפר"}]
["אמה","בנוב","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":"נו#מרץ"}]
["גלי","גרבר","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":"רב#אוג"}]
["אבי ","רינגל","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":"ינ#מאי"}]
["צחי","וינר","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":"ינ#ינו"}]
["אריה","אונרוביל","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":"ונ#ספט"}]
["רואי","חנוביץ","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":"נו#ספט"}]
["לישי","ברמן","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":"רמ#אפר"}]
["לנה","יצחקי","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":"צח#נוב"}]
["דור","וויינר","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":"וי#מאי"}]
["נדב","רווח","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":"וו#דצמ"}]
["אלון","כהן","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":"הן#דצמ"}]
["אאוריקה ","יאסין","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":"אס#אוג"}]
["שירי","הסנר","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":"סנ#דצמ"}]
["נועם","מי דן","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":"י #יונ"}]
["אסי","כצוביץ","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":"צו#ינו"}]
["אורי","לוין","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":"וי#מרץ"}]
["אבי ","ממלידר","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":"מל#דצמ"}]
["ירדן","קלנר","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":"לנ#נוב"}]
["טל","בן סלומון","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":"ן #יול"}]
["אודי","חיים","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":"יי#אוק"}]
["גדי","ראפס","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":"אפ#מרץ"}]
["מירב","ברטס","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":"רט#יונ"}]
["ליה","רוטשילד","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":"וט#אפר"}]
["עמרי","יגאנה","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":"גא#דצמ"}]
["דן","טננבאום","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":"ננ#מאי"}]
["מיטל","דורון","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":"ור#ינו"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"תאי עזר"]

{"sheet":"search X 2","index":6,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,14,8,15]]}
["מספר לקוח","שם לקוח","כתובת דוא\"ל","מעמד לקוח","תחילת ההשקעה","סכום השקעה ","מספר קרן","דמי ניהול ","ערך השקעה נכון להיום","סיסמה"]
[1855,"NI_IAV","NI_IAV@colman.ac.il","שכיר","2022-09-15",2500,10,8.9999999999999993E-3,16761.877886011072]
[1856,"KF_GLD","KF_GLD@colman.ac.il","עצמאי","2022-03-12",146726,13,2.8999999999999998E-3,214094.11260178176]
[1857,"CC_GB","CC_GB@hotmail.com","שכיר","2022-09-29",253094,10,6.0000000000000001E-3,307637.33883750002]
[1858,"BJ_VLS","BJ_VLS@colman.ac.il","שכיר","2022-12-29",70131,14,1E-3,332458.09982047207]
[1859,"DE_APS","DE_APS@hotmail.com","שכיר","2022-02-05",63372,15,1E-3,1229261.9753939065]
[1860,"BJ_DDX","BJ_DDX@colman.ac.il","עצמאי","2022-05-19",72483,15,1E-3,1877660.4186721272]
[1861,"CK_UUE","CK_UUE@ynet.co.il","עצמאי","2022-07-11",108877,13,2.8999999999999998E-3,986671.12314671697]
[1862,"JK_67J","JK_67J@yahoo.com","עצמאי","2022-05-05",96681,10,7.0000000000000001E-3,191421.76696540037,null,null,null,null,null,"תאי עזר"]
[1863,"DJ_IPO","DJ_IPO@yahoo.com","עצמאי","2022-10-27",66590,15,1E-3,377756.68354481296]
[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]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"רועי עידן                   052-546-6016    www.roy-idan.co.il"]

{"sheet":"רגישות סדר 1","index":7,"n_rows":51,"n_cols":14,"rows_kept":51,"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"]
[2,"אביב","גור","aviv@gov.il","053-1112222","ירושלים","2013-04-11","Altission","קפסולות קפה",7,1200,17,"16:15:00","17:00:00"]
[3,"אורן","כהן","oren@gmail.com","050-4445555","רמת גן","2013-12-01","Ispirazione Napolion","קפסולות קפה",2,200,9,"14:30:00","15:15:00"]
[4,"איליה","קליין","ilia@gmail.com","053-1234567","חיפה","2016-09-14","Vertuo Ne","מכונות קפה",7,600,17,"15:30:00","16:15:00"]
[5,"אילן","רון","ilan@hotmail.com","053-9998888","רעננה","2016-04-25","Sccuro","קפסולות קפה",6,700,17,"17:00:00","17:45:00"]
[6,"אלון","פלג","alon@gmail.com","052-6667777","נתניה","2013-07-16","זוג ספלי קפוצ'ינו ","אביזרים נלווים",7,600,17,"12:45:00","13:30:00"]
[7,"אלונה","רובינוביץ","alona@yahoo.com","053-5556666","אילת","2016-10-08","Odacioo","קפסולות קפה",7,500,14,"18:15:00","19:00:00"]
[8,"אמיר","גיל","amir@gov.il","052-5556666","רמת גן","2014-03-03","Creatista Pluss","מכונות קפה",7,500,18,"21:30:00","22:15:00"]
[9,"גיל","כהן","gil@gmail.com","050-5556666","רעננה","2015-11-17","Stormion","קפסולות קפה",7,680,20,"21:45:00","22:30:00"]
[10,"דור","לוי","dor@gmail.com","050-5556666","פתח תקווה","2015-06-03","Lattissima Onn","מכונות קפה",2,300,8,"18:45:00","19:30:00"]
[11,"דינה","לייבה","dina@yahoo.com","052-8765432","פתח תקווה","2019-04-02","Vertuo Pl","מכונות קפה",7,400,10,"20:30:00","21:15:00"]
[12,"דנה","מלמד","dana@yahoo.com","052-8889999","באר שבע","2017-02-28","כוסות אספרסו קריסטל ","אביזרים נלווים",3,250,7,"21:00:00","21:45:00"]
[13,"דני","חיון","danny@hotmail.com","050-1234567","רעננה","2023-05-03","Romm","קפסולות קפה",3,600,16,"18:20:00","19:00:00"]
[14,"דניאל","מינץ","dan@yahoo.com","052-4445555","ירושלים","2020-11-08","Grann Latisimma","מכונות קפה",4,1000,19,"21:15:00","22:00:00"]
[15,"יהונתן","גלעדי","yonatan@gov.il","053-4445555","חיפה","2015-03-26","ESENZA PLUSS","מכונות קפה",5,650,17,"18:00:00","18:45:00"]
[16,"יואב","פרידמן","yoav@gmail.com","054-8889999","רמת גן","2014-09-30","כוס מאג Festive","אביזרים נלווים",5,650,18,"15:45:00","16:30:00"]
[17,"יובל","שרי","yuval@gmail.com","054-6667777","חולון","2018-07-09","Palermo Kaza","קפסולות קפה",7,800,18,"08:30:00","09:15:00"]
[18,"יוסי","כהן","yossi@gmail.com","053-7778888","אילת","2023-01-15","Ristro","קפסולות קפה",3,400,18,"10:30:00","11:00:00"]
[19,"יעל","גולדשטיין","yael@colman.ac.il","054-4445555","רעננה","2019-06-30","Intenso","קפסולות קפה",3,450,13,"13:30:00","14:15:00"]
[20,"יעל","רוזנברג","yael@yahoo.com","050-9876543","תל אביב","2022-04-19","Vertuo Pl","מכונות קפה",5,500,14,"14:00:00","14:45:00"]
[21,"יפה","קרן","yafeh@gmail.com","054-1112222","חולון","2020-06-27","Sccuro","קפסולות קפה",5,450,13,"14:30:00","15:15:00"]
[22,"מאיה","אליהו","maya@muni.il","053-1112233","באר שבע","2014-10-18","Pixie","מכונות קפה",4,500,14,"11:30:00","12:15:00"]
[23,"מרים","אזולאי","miriam@net.il","050-6667777","רמת גן","2016-05-19","כוס מאג Festive","אביזרים נלווים",5,1500,20,"11:00:00","11:45:00"]
[24,"נועה","חיים","noa@org.il","054-1239876","תל אביב","2015-10-21","כוסות אספרסו קריסטל ","אביזרים נלווים",6,550,19,"14:00:00","14:45:00"]
[25,"נועה","יוסף","noa@muni.il","054-6667777","תל אביב","2017-06-12","CITIS PLATINUM","מכונות קפה",6,350,15,"14:15:00","15:00:00"]
[26,"נועה","יחיאל","noa@muni.il","052-9876543","נתניה","2018-09-05","Altission","קפסולות קפה",6,350,15,"09:00:00","09:45:00"]
[27,"נועם","שור","noam@gmail.com","050-1112222","חולון","2013-01-07","Atelierer","מכונות קפה",6,450,18,"09:45:00","10:30:00"]
[28,"נועם","יצחקי","noam@yahoo.com","050-8889999","רמת גן","2019-12-05","מקציף חלב אירוצ'ינו","אביזרים נלווים",7,450,13,"10:30:00","11:15:00"]
[29,"ניסן","דויד","nissan@gov.il","050-3334444","אשדוד","2015-01-14","Intenso","קפסולות קפה",7,350,15,"11:45:00","12:30:00"]
[30,"ניר","גולדברג","nir@colman.ac.il","052-5556666","פתח תקווה","2020-03-09","Citi & Milk","מכונות קפה",6,400,12,"16:00:00","16:45:00"]
[31,"ניר","סולם","nir@gmail.com","052-1234567","חיפה","2017-11-26","Vertuo Ne","מכונות קפה",6,400,17,"10:15:00","11:00:00"]
[32,"עדי","אברהם","adi@hotmail.com","054-5556666","נתניה","2017-08-14","Essenza Mini","מכונות קפה",4,650,18,"19:15:00","20:00:00"]
[33,"עדן","חיים","eden@hotmail.com","054-1112233","חיפה","2013-09-17","Atelierer","מכונות קפה",7,850,19,"17:30:00","18:15:00"]
[34,"עירית","גולן","yael@bgu.ac.il","050-1239876","פתח תקווה","2014-08-03","Kazar","קפסולות קפה",7,900,19,"13:15:00","14:00:00"]
[35,"קובי","גבע","yam@org.il","054-3334444","נתניה","2018-12-27","Creatista Pluss","מכונות קפה",7,935,19,"12:00:00","12:45:00"]
[36,"רבקה","אביב","rivka@org.il","054-9876543","אשדוד","2012-08-10","Kazar","קפסולות קפה",7,890,19,"12:15:00","13:00:00"]
[37,"רוני","ברקוביץ'","roni@org.il","053-6667777","פתח תקווה","2021-05-24","כוסות אספרסו קריסטל ","אביזרים נלווים",5,600,8,"17:45:00","18:30:00"]
[38,"שיר","אהרונוביץ","shir@yahoo.com","052-1112233","חיפה","2021-02-08","Odacioo","קפסולות קפה",3,500,11,"10:00:00","10:45:00"]
[39,"שרה","לוי","sarah@yahoo.com","052-1239876","נתניה","2022-11-20","Diavol","קפסולות קפה",3,350,10,"14:45:00","15:30:00"]
[40,"תמר","כהן","tamar@gmail.com","052-3334444","חיפה","2019-09-22","Stormion","קפסולות קפה",1,500,7,"19:45:00","20:30:00"]
[41,"תמר","זריף","tamar@org.il","053-8889999","פתח תקווה","2018-02-13","זוג ספלי קפוצ'ינו ","אביזרים נלווים",7,700,14,"19:30:00","20:15:00"]
[]
[]
["נתונים עבור שאלה 2 סעיף ב':"]
["הנחה לחברי מועדון הלקוחות"]
["                                       סיווג מוצר \nממוצע מספר המוצרים בהזמנה","אביזרים נלווים","קפסולות קפה","מכונות קפה"]
[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,"רועי עידן                   052-546-6016    www.roy-idan.co.il"]

{"sheet":"חתירה למטרה minIfs","index":8,"n_rows":36,"n_cols":23,"rows_kept":36,"cut":false,"hidden":false,"merged":[[27,16,27,20]]}
["מספר לקוח","שם לקוח","כתובת דוא\"ל","מעמד לקוח","תחילת ההשקעה","סכום השקעה ","מספר קרן","דמי ניהול ","ערך השקעה נכון להיום","ערך השקעה נכון להיום בש\"ח"]
[1855,"NI_IAV","NI_IAV@colman.ac.il","שכיר","2022-09-15",2500,10,8.9999999999999993E-3,16761.877886011072,{"$f":"I2*$M$2","v":51961.821446634327},null,null,3.1,"שער הדולר שנתון"]
[1856,"KF_GLD","KF_GLD@colman.ac.il","עצמאי","2022-03-12",146726,13,2.8999999999999998E-3,214094.11260178176,{"$f":"I3*$M$2","v":663691.7490655235}]
[1857,"CC_GB","CC_GB@hotmail.com","שכיר","2022-09-29",253094,10,6.0000000000000001E-3,307637.33883750002,953675.75039625005]
[1858,"BJ_VLS","BJ_VLS@colman.ac.il","שכיר","2022-12-29",70131,14,1E-3,332458.09982047207,1030620.1094434634]
[1859,"DE_APS","DE_APS@hotmail.com","שכיר","2022-02-05",63372,15,1E-3,1229261.9753939065,3810712.1237211102]
[1860,"BJ_DDX","BJ_DDX@colman.ac.il","עצמאי","2022-05-19",72483,15,1E-3,1877660.4186721272,5820747.2978835944]
[1861,"CK_UUE","CK_UUE@ynet.co.il","עצמאי","2022-07-11",108877,13,2.8999999999999998E-3,986671.12314671697,3058680.4817548227]
[1862,"JK_67J","JK_67J@yahoo.com","עצמאי","2022-05-05",96681,10,7.0000000000000001E-3,191421.76696540037,593407.47759274114]
[1863,"DJ_IPO","DJ_IPO@yahoo.com","עצמאי","2022-10-27",66590,15,1E-3,377756.68354481296,1171045.7189889201]
[1864,"LB_MI8","LB_MI8@walla.co.il","בעל שליטה","2022-05-26",224708,10,6.0000000000000001E-3,3453180.5195543682,10704859.610618541]
[1865,"LM_TBP","LM_TBP@ynet.co.il","שכיר","2022-07-17",49492,14,1.1000000000000001E-3,2044762.0534205888,6338762.365603826]
[1866,"BK_UDG","BK_UDG@colman.ac.il","שכיר","2022-04-28",76982,13,3.8999999999999998E-3,2617985.4305046364,8115754.8345643729]
[1867,"DK_EAU","DK_EAU@colman.ac.il","בעל שליטה","2022-09-13",184883,10,6.0000000000000001E-3,2226133.6383189736,6901014.278788818]
[1868,"KL_XLD","KL_XLD@ynet.co.il","בעל שליטה","2022-10-12",8780,10,8.9999999999999993E-3,122381.75185310727,379383.43074463255]
[1869,"NE_ANL","NE_ANL@gmail.com","שכיר","2022-11-18",46900,14,1.1000000000000001E-3,80582.931834117058,249807.08868576289]
[1870,"MK_MO5","MK_MO5@yahoo.com","שכיר","2022-05-25",162174,14,8.0000000000000004E-4,1078268.712803452,3342633.0096907015]
[1871,"LM_V7U","LM_V7U@walla.co.il","שכיר","2022-12-09",10321,14,1.1000000000000001E-3,372444.86881914415,1154579.0933393468]
[1872,"FD_DIK","FD_DIK@walla.co.il","שכיר","2022-06-22",56091,15,1E-3,1453028.3037917621,4504387.7417544629]
[1873,"KD_HH7","KD_HH7@yahoo.com","עצמאי","2022-07-10",12866,10,8.0000000000000002E-3,133822.73527755728,414850.47936042759]
[1874,"EL_NGQ","EL_NGQ@ynet.co.il","עצמאי","2022-07-01",71270,13,3.8999999999999998E-3,142479.52031448073,441686.5129748903]
[1875,"KK_ZJH","KK_ZJH@colman.ac.il","עצמאי","2022-02-01",10129,14,1.1000000000000001E-3,22812.44860458418,70718.590674210966]
[1876,"MC_IEL","MC_IEL@colman.ac.il","בעל שליטה","2022-01-17",143689,13,2.8999999999999998E-3,1900016.8003544933,5890052.081098929]
[1877,"FJ_YQG","FJ_YQG@colman.ac.il","בעל שליטה","2022-02-09",25719,12,5.7999999999999996E-3,186489.11906743521,578116.26910904911]
[1878,"AI_MAH","AI_MAH@hotmail.com","שכיר","2022-09-16",215746,14,8.0000000000000004E-4,1094342.8807251898,3392462.9302480887]
[1879,"GI_JDG","GI_JDG@gmail.com","בעל שליטה","2022-11-28",131191,10,6.0000000000000001E-3,203520.29998243746,630912.9299455561]
[]
[]
[]
["רועי עידן                   052-546-6016    www.roy-idan.co.il"]
[]
[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,3.1]
[]
[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,0.2]

{"sheet":"שם משתמש וסיסמה","index":9,"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,null,null,null,null,null,null,null,"טבלה מס' 1"]
["אאוג'ן ","מנוליאו","KEZZLDMD@colman.ac.il","2022-05-03","19:16:55","Mazda_6","פרטי","גלגלי הזהב","חולון","2011-03-29",132100,25829,null,null,null,null,null,null,null,"אחוז ממחיר יבואן","סוג רכב"]
["אאוריקה ","גורכוב","BEXLDPPA11@ynet.co.il","2022-02-19","17:20:28.333","Citroen_C3","פרטי","רכב דיל מאיר","חיפה","2011-01-15",125000,65509,null,null,null,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,null,null,null,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,null,null,null,null,null,null,null,0.8,"BMW"]
["דן","טננבאום","VWQXYKIY@colman.ac.il","2022-05-07","18:16:10","Mazda_3","פרטי","סוכנות המוביל","תל אביב","2011-04-03",99200,99037,null,null,null,null,null,null,null,0.75,"Audi"]
["רם","אברמוביץ","AUTBPAME@ynet.co.il","2022-09-15","16:07:25","BMW_Z4","פרטי","סוכנות המוביל","תל אביב","2011-08-11",185200,23650,null,null,null,null,null,null,null,0.55000000000000004,"Citroen"]
["עומר","יגאנה","YIDOJL@colman.ac.il","2022-07-29","13:51:02","renault_kangoo","מסחרי","רכבי דניאלס","יהוד","2011-06-25",148000,56507]
["רואי","חנוביץ","KE78OMD@colman.ac.il","2022-10-31","13:33:55","toyota_hilux","מסחרי","סוכנות המוביל","תל אביב","2010-09-27",135200,76935,null,null,null,null,null,null,null,null,0.45]
["ירדן","קלנר","BDZJHBUB@colman.ac.il","2022-06-19","16:20:30.696","Audi_A4","פרטי","רכב דיל מאיר","חיפה","2008-05-15",133200,43076]
["שירי","מנור","FF22WT@ynet.co.il","2022-06-03","15:46:52","Nissan_Juke","גיפ","רכב דיל מאיר","חיפה","2008-04-30",133200,13221,null,null,null,null,null,null,null,"טבלה מס' 2"]
["אמיר","שרון","EAUDGT@colman.ac.il","2022-09-14","11:51:37.007","Honda_Accord","פרטי","סוכנות המוביל","תל אביב","2011-08-10",125900,40682,null,null,null,null,null,null,null,"תוספת סיווג","סווג הרכב"]
["עמית","כהן","FFNGQQWT@ynet.co.il","2023-01-10","14:09:00.555","Audi_A4","פרטי","רכב דיל","בני ברק","2008-12-06",125300,23927,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,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,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,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]
["תומר","בוקאי","CTA86@walla.co.il","2022-10-26","15:48:53","Subaru_B4","פרטי","רכב דיל","בני ברק","2010-09-22",112500,20389]
["טלי","רונן","XPDDXH@colman.ac.il","2022-04-19","16:37:49.888","toyota_hilux","מסחרי","רכב דיל מאיר","חיפה","2010-03-15",112000,38679]
["אורי","לוין","WTUUETX@ynet.co.il","2022-10-15","13:38:56.356","Audi_A3","פרטי","רכבי דניאלס","יהוד","2009-09-11",110410,26284,null,null,null,null,null,"תאי עזר לכבוד שאלה 1 סעיף א 1"]
["אריק","לוין","JXIELUBY@colman.ac.il","2022-05-15","09:24:14.616","fiat_ducato","מסחרי","רכב דיל","בני ברק","2008-04-11",106000,6474]
["מושיקו","דגנוש","MYGLDVTD@colman.ac.il","2022-06-21","10:58:13.226","Nissan_Navare","מסחרי","סוכנות המוביל","תל אביב","2011-05-17",103000,57178]
["אסי","וידר","NYIAVES@colman.ac.il","2022-07-08","16:17:18","BMW_325","פרטי","סוכנות המוביל","תל אביב","2011-06-04",99600,18823]
["מור","אילומים","GIMI89FG@walla.co.il","2022-10-13","14:29:31.541","Mazda_3","פרטי","סוכנות המוביל","תל אביב","2011-09-09",92200,63326]
["לישי","ברמן","FADIKOL55@walla.co.il","2022-07-20","12:51:18","Mazda_3","פרטי","רכבי דניאלס","יהוד","2009-06-16",90890,48294]
["אלון","כהן","RVPNJHQO33@ynet.co.il","2022-10-30","12:56:34.880","Mazda_6","פרטי","רכב דיל","בני ברק","2010-09-26",90890,8931]
["עמרי","יגאנה","RAV8O@walla.co.il","2022-09-27","09:29:23","Audi_A6","מנהלים","גלגלי הזהב","חולון","2008-08-23",90890,50833,null,null,null,null,null,"תאי עזר לכבוד שאלה 1 א 2"]
["נוי","סליקטר","RAV7U8O@walla.co.il","2022-11-26","10:05:24","renault_kangoo","מסחרי","סוכנות המוביל","תל אביב","2009-10-22",90100,74516]
["נטע","פוקס","EXOOIS5@colman.ac.il","2022-10-09","14:05:53.175","BMW_325","פרטי","רכבי דניאלס","יהוד","2010-09-05",89000,38944]
["עדי","גירו","YXYQGYVQ@colman.ac.il","2022-04-25","09:02:29.426","Volkswagen_Passat","פרטי","סוכנות המוביל","תל אביב","2008-03-21",85300,40146]
["שרה","שוורץ","RV7HQO33@ynet.co.il","2022-03-28","12:38:25.082","Honda_Civic","פרטי","רכבי דניאלס","יהוד","2008-02-24",79000,33741]
["אודי","חיים","SVETR@walla.co.il","2022-08-07","15:35:40.927","Hyundai_Tuscon","גיפ","סוכנות המוביל","תל אביב","2009-07-03",69900,52888]
["גלי","גרבר","BD12BUB@colman.ac.il","2022-05-17","09:52:31.682","Subaru_B4","פרטי","סוכנות המוביל","תל אביב","2008-04-13",42320,34120]
["אורן","ברבור","JILI6@yahoo.com","2023-01-27","19:07:43.211","Audi_A6","מנהלים","סוכנות המוביל","תל אביב","2010-12-23",156000,54194]
["נועם","מי דן","TAB@hotmail.com","2022-09-21","18:16:34.929","Hyundai_Tuscon","גיפ","רכב דיל מאיר","חיפה","2010-08-17",148000,37483]
["דור","וויינר","GT67JK@yahoo.com","2022-09-28","17:02:19","Nissan_qashqai","גיפ","רכב דיל","בני ברק","2009-08-24",132100,20688]
["שירי","הסנר","LCMAHAOP@hotmail.com","2022-04-11","18:23:19.898","Nissan_Micra","פרטי","סוכנות המוביל","תל אביב","2008-03-07",114600,56149]
["צחי","וינר","TUKU7K@yahoo.com","2022-11-15","19:26:56.881","toyota_hilux","מסחרי","רכב דיל","בני ברק","2008-10-11",98700,39354]
["מיטל","דורון","RVHJHDT@gmail.com","2022-05-18","17:02:22.317","Audi_A3","פרטי","רכב דיל","בני ברק","2009-04-14",97800,17489]
["מיכל","בן עמי","RFANLGI22@gmail.com","2022-12-09","10:49:57","Ford_Focus","פרטי","רכב דיל מאיר","חיפה","2010-11-05",148000,60630]
["דניאלה","שטיין","XIJDGGVC@gmail.com","2022-12-09","14:58:59.772","Nissan_Navare","מסחרי","גלגלי הזהב","חולון","2011-11-05",133500,30206]
["אמה","בנוב","YEGB@hotmail.com","2022-08-25","14:44:53.260","Citroen_C3","פרטי","רכב דיל מאיר","חיפה","2010-07-21",133200,37698]
["אבי ","ממלידר","GZBJLAY@gmail.com","2022-12-20","16:33:01.363","Hyundai_Tuscon","גיפ","רכב דיל מאיר","חיפה","2011-11-16",124900,49309]
["אבי ","ברלב","PAB@hotmail.com","2022-06-23","16:43:58.850","Volkswagen_Golf","פרטי","רכב דיל מאיר","חיפה","2009-05-19",122300,6330]
["אבי ","אור אורטרגר","MIKI6@yahoo.com","2023-01-26","12:36:06.172","Honda_Accord","פרטי","רכבי דניאלס","יהוד","2008-12-22",118800,43882]
["אריה","אונרוביל","GGHH77JK@yahoo.com","2022-03-12","12:46:17.416","Nissan_Pathfinder","מסחרי","סוכנות המוביל","תל אביב","2009-02-08",117800,36392]
["ליה","רוטשילד","YAKI5@yahoo.com","2022-12-02","15:22:52","Nissan_qashqai","גיפ","רכבי דניאלס","יהוד","2010-10-28",114600,31480]
["גדי","ראפס","ARIPOR5@yahoo.com","2022-11-28","12:39:01","Ford_Focus","פרטי","רכב דיל","בני ברק","2011-10-24",112000,7902]
["אסי","כצוביץ","TIMO5GH@yahoo.com","2022-07-01","12:36:10.706","Citroen_C5","פרטי","גלגלי הזהב","חולון","2010-05-27",112000,49972]
["לנה","יצחקי","PADI5@yahoo.com","2022-10-02","14:03:12","Citroen_C5","פרטי","רכב דיל","בני ברק","2010-08-28",110410,12170]
["יאנה","גלון","GILIUU8@gmail.com","2022-03-05","10:06:50.571","Mazda_6","פרטי","גלגלי הזהב","חולון","2009-02-01",110410,74616]
["אלכס","עמרמי ויצמן","GH77JK@yahoo.com","2022-06-24","13:49:00","Nissan_Juke","גיפ","גלגלי הזהב","חולון","2008-05-20",97800,45473]
["מירב","ברטס","R5HJ9DT@gmail.com","2022-04-14","15:23:17.829","Nissan_Juke","גיפ","רכבי דניאלס","יהוד","2009-03-10",95000,39959]
["אבי ","היינריך","HRNFSEKR@gmail.com","2022-12-03","13:54:01","BMW_540","פרטי","רכב דיל מאיר","חיפה","2011-10-29",80900,79021]
["אבי ","רינגל","OQAPSDFQ@hotmail.com","2022-05-31","11:59:30","renault_kangoo","מסחרי","רכב דיל","בני ברק","2010-04-27",76000,33193]
["מור","גולדברג","TUTUU7@yahoo.com","2023-01-15","16:12:41","fiat_ducato","מסחרי","סוכנות המוביל","תל אביב","2010-12-11",58100,29954]