{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["רבעון1","רבעון2","רבעון3","רבעון4","דוח שנתי","פתרון 12-16","פתרון 17-19","פתרון 20-24"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":22,"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":"רבעון1","index":0,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["מכירות"]
["כמות"]
["מחיר"]
["ס\"ה לפני מע\"מ",{"$f":"B2*B3","v":0}]
["מע\"מ",{"$f":"B4*C5","v":0},0.16]
["ס\"ה לאחר מע\"מ",{"$f":"B4+B5","v":0}]

{"sheet":"רבעון2","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["מכירות"]
["כמות"]
["מחיר"]
["ס\"ה לפני מע\"מ",{"$f":"B2*B3","v":0}]
["מע\"מ",{"$f":"B4*C5","v":0},0.16]
["ס\"ה לאחר מע\"מ",{"$f":"B4+B5","v":0}]

{"sheet":"רבעון3","index":2,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["מכירות"]
["כמות"]
["מחיר"]
["ס\"ה לפני מע\"מ",{"$f":"B2*B3","v":0}]
["מע\"מ",{"$f":"B4*C5","v":0},0.16]
["ס\"ה לאחר מע\"מ",{"$f":"B4+B5","v":0}]

{"sheet":"רבעון4","index":3,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["מכירות"]
["כמות",1]
["מחיר",100]
["ס\"ה לפני מע\"מ",{"$f":"B2*B3","v":100}]
["מע\"מ",{"$f":"B4*C5","v":16},0.16]
["ס\"ה לאחר מע\"מ",{"$f":"B4+B5","v":116}]

{"sheet":"דוח שנתי","index":4,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["מכירות","ב- ₪","ב- $"]
["כמות",{"$f":"SUM(רבעון1:רבעון4!B2)","v":1}]
["מחיר",{"$f":"SUM(רבעון1:רבעון4!B3)","v":100}]
["ס\"ה לפני מע\"מ",{"$f":"SUM(רבעון1:רבעון4!B4)","v":100},{"$f":"B4/[1]גיליון1!$D$4","v":20}]
["מע\"מ",{"$f":"SUM(רבעון1:רבעון4!B5)","v":16},{"$f":"B5/[1]גיליון1!$D$4","v":3.2}]
["ס\"ה לאחר מע\"מ",{"$f":"SUM(רבעון1:רבעון4!B6)","v":116},{"$f":"B6/[1]גיליון1!$D$4","v":23.2}]

{"sheet":"פתרון 12-16","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["מ (כולל)","עד (לא כולל)","מס' אקראי"]
[0,100,{"$f":"RAND()*(B2-A2)+A2","v":10.36446805902742}]
[60,80,{"$f":"INT(RAND()*(B3-A3)+A3)","v":77}]
[]
[]
["מ (כולל)","עד (כולל)","מס' אקראי"]
[10,25,{"$f":"INT(RAND()*(B7-A7+1)+A7)","v":12}]
[10,25,17]
[10,100,{"$f":"RANDBETWEEN(A9,B9)","v":66}]

{"sheet":"פתרון 17-19","index":6,"n_rows":107,"n_cols":21,"rows_kept":107,"cut":false,"hidden":false,"merged":[[0,0,0,17],[2,0,12,0],[2,19,2,22],[14,0,29,0],[14,15,14,17],[22,15,22,17],[23,15,23,17],[25,15,25,17],[26,15,26,17],[28,15,28,17],[29,15,29,16],[30,15,30,16],[31,0,36,0],[31,15,31,16],[34,14,34,17],[35,14,35,15],[38,0,41,0],[43,0,45,0],[43,1,43,2],[41,14,41,19],[44,14,44,16],[45,14,45,16]]}
["תרגול באקסל"]
[]
["נתונים","ת.ז.","שם הסטודנט","מגדר","טלפון","מיקוד","התמחות","ציון ת. 1","ציון ת. 2","ציון ת. 3","ממוצע  תרגילים","ציון פרויקט","ציון בחינה","ציון סופי","ציון במילים","נשים מצטיינות","נשים או מצטיינים","לא נכשלו",null,"קריטריונים לסינון מתקדם"]
[null,123456789,"דניאל","ז",9877665,123,"שיווק",89,86,99,{"$f":"AVERAGE(H4:J4)","v":91.333333333333329},99,80,{"$f":"ROUND(H4*$C$32+I4*$C$33+J4*$C$34+L4*$C$35+M4*$C$36,0)","v":89},{"$f":"IF(N4<$C$41,$B$40,IF(N4<$C$42,$B$41,$B$42))","v":"מצטיין"},{"$f":"IF(AND(D4=$C$46,O4=$B$42),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D4=$C$46,O4=$B$42),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N4<$C$41),\"מלגה\",\"\")","v":"מלגה"}]
[null,193878400,"טלי","נ",9876544,70000,"שיווק",81,80,82,81,81,81,81,"עובר","","מלגה","מלגה"]
[null,244576280,"שחר","נ",3252524,44451,"חשבונאות",94,100,93,95.666666666666671,95,100,97,"מצטיין","מלגה","מלגה","מלגה"]
[null,298754355,"רמי","ז",8763456,83934,"חשבונאות",88,90,74,84,55,45,60,"עובר","","","מלגה"]
[null,388923057,"מיכל","נ",8743644,44141,"חשבונאות",60,100,80,80,40,61,60,"עובר","","מלגה","מלגה"]
[null,658370843,"יעל","נ",2118758,55326,"שיווק",67,99,69,78.333333333333329,90,85,85,"מצטיין","מלגה","מלגה","מלגה"]
[null,830998987,"מיכל","נ",3527439,56324,"שיווק",80,null,87,83.5,90,null,44,"נכשל","","מלגה",""]
[null,947465892,"שחר","ז",3434324,41466,"חשבונאות",null,79,99,89,86,65,70,"עובר","","","מלגה"]
[null,983687692,"שרון","נ",6347234,55235,"חשבונאות",45,60,null,52.5,99,94,78,"עובר","","מלגה","מלגה"]
[null,987654321,"יעקב","ז",7563094,86534,"שיווק",91,79,85,85,100,50,76,"עובר","","","מלגה"]
[]
["חישובים","ממוצע  כיתתי ",null,null,null,null,null,{"$f":"AVERAGE(H4:H13)","v":77.222222222222229},{"$f":"AVERAGE(I4:I13)","v":85.888888888888886},85.333333333333329,82.033333333333331,83.5,73.444444444444443,74,null,"התפלגות ציונים סופיים"]
[null,"חציון",null,null,null,null,null,{"$f":"MEDIAN(H4:H13)","v":81},{"$f":"MEDIAN(I4:I13)","v":86},85,83.75,90,80,77,null,"0-59",59,{"$f":"FREQUENCY(N4:N13,Q16:Q21)","v":1}]
[null,"שכיח",null,null,null,null,null,{"$f":"MODE(H4:H13)","v":{"$error":"#N/A"}},{"$f":"MODE(I4:I13)","v":100},99,{"$error":"#N/A"},99,{"$error":"#N/A"},60,null,"60-74",74,3]
[null,"מקסימום",null,null,null,null,null,{"$f":"MAX(H4:H13)","v":94},{"$f":"MAX(I4:I13)","v":100},99,95.666666666666671,100,100,97,null,"75-84",84,3]
[null,"מינימום",null,null,null,null,null,{"$f":"MIN(H4:H13)","v":45},{"$f":"MIN(I4:I13)","v":60},69,52.5,40,45,44,null,"85-94",94,2]
[null,"סטיית תקן",null,null,null,null,null,{"$f":"STDEV(H4:H13)","v":16.536155673083279},{"$f":"STDEV(I4:I13)","v":13.166666666666675},10.428326807307105,11.67534069082849,20.23885152648517,19.190564811327921,15.818414023606231,null,"95-100",100,1]
[null,"שונות",null,null,null,null,null,{"$f":"VAR(H4:H13)","v":273.44444444444434},{"$f":"VAR(I4:I13)","v":173.36111111111131},108.75,136.31358024691548,409.61111111111109,368.27777777777737,250.22222222222223,null,"מעל 100",null,0]
[null,"שלחו תרגיל/ נבחנו",null,null,null,null,null,{"$f":"COUNT(H4:H13)","v":9},{"$f":"COUNT(I4:I13)","v":9},9,10,10,9,10]
[null,"נכשלו",null,null,null,null,null,{"$f":"COUNTIF(H4:H13,\"<\"&$C$41)","v":1},0,0,1,2,2,1,null,"הסטודנט עם הציון הגבוה ביותר"]
[null,"עברו",null,null,null,null,null,{"$f":"COUNTIFS(H4:H13,\">=\"&$C$41,H4:H13,\"<\"&$C$42)","v":4},4,4,5,1,4,6,null,{"$f":"LOOKUP(N18,N4:N13,C4:C13)","v":"יעקב"}]
[null,"מצטיינים",null,null,null,null,null,{"$f":"COUNTIF(H4:H13,E42)","v":4},{"$f":"COUNTIF(I4:I13,\">=\"&$C$42)","v":5},5,4,7,3,3]
[null,"מתוכם:",{"$f":"B45","v":"סטודנטים"},null,null,null,null,{"$f":"COUNTIFS($D$4:$D$13,$C$45,H4:H13,\">=\"&$C$42)","v":3},2,3,3,3,0,1,null,"המיקום של 'ציון סופי'"]
[null,null,{"$f":"B46","v":"סטודנטיות"},null,null,null,null,{"$f":"COUNTIFS($D$4:$D$13,$C$46,H4:H13,$E$42)","v":1},3,2,1,4,3,2,null,{"$f":"MATCH(N3,B3:R3,0)","v":13}]
[null,"ס\"ה סטודנטים",null,{"$f":"COUNTA(C4:C13)","v":10},null,null,"ממוצע של מקבלי ציון \"עובר\":",{"$f":"AVERAGEIFS(H4:H13,H4:H13,\">=\"&$C$41,H4:H13,\"<\"&$C$42)","v":72},74.5,76.25,81.36666666666666,81,71.75,70.833333333333329]
[null,"מתוכם:",{"$f":"B45","v":"סטודנטים"},{"$f":"COUNTIF(D4:D13,C45)","v":4},null,null,"בממוצע:",{"$f":"AVERAGEIF($D$4:$D$13,$C45,H$4:H$13)","v":89.333333333333329},83.5,89.25,87.333333333333329,85,60,73.75,null,"שליפת מידע עם index+match"]
[null,null,{"$f":"B46","v":"סטודנטיות"},{"$f":"COUNTIF(D4:D13,C46)","v":6},null,null,"בממוצע:",71.166666666666671,87.8,82.2,78.5,82.5,84.2,74.166666666666671,null,"הזן ציון",null,81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"בחר מידע מבוקש",null,"שם הסטודנט"]
["טבלת משקולות","משקל תרגיל 1",0.1,null,null,null,null,null,null,null,null,null,null,null,null,"תוצאה:",null,{"$f":"INDEX(B4:R13,MATCH(R30,N4:N13,0),MATCH(R31,B3:R3,0))","v":"טלי"}]
[null,"משקל תרגיל 2",0.1]
[null,"משקל תרגיל 3",0.1]
[null,"משקל פרויקט",0.3,null,null,null,null,null,null,null,null,null,null,null,"שליפת מידע עם Vlookup"]
[null,"משקל מבחן",0.4,null,null,null,null,null,null,null,null,null,null,null,"הזן ת.ז.",null,123456789]
[null,"סה\"כ",{"$f":"SUM(C32:C36)","v":1},null,null,null,null,null,null,null,null,null,null,null,"בחר מידע מבוקש",null,"ממוצע  תרגילים",{"$f":"VLOOKUP($Q$36,$B$3:$R$13,MATCH(Q37,$B$3:$R$3,0),FALSE)","v":91.333333333333329}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"בחר מידע מבוקש",null,"ציון פרויקט",{"$f":"VLOOKUP($Q$36,$B$3:$R$13,MATCH(Q38,$B$3:$R$3,0),FALSE)","v":99}]
["טבלת עזר",null,"מ-","עד",null,null,null,null,null,null,null,null,null,null,"בחר מידע מבוקש",null,"ציון בחינה",{"$f":"VLOOKUP($Q$36,$B$3:$R$13,MATCH(Q39,$B$3:$R$3,0),FALSE)","v":80}]
[null,"נכשל",0,59.49,null,null,null,null,null,null,null,null,null,null,"בחר מידע מבוקש",null,"ציון סופי",{"$f":"VLOOKUP($Q$36,$B$3:$R$13,MATCH(Q40,$B$3:$R$3,0),FALSE)","v":89}]
[null,"עובר",59.5,84.49]
[null,"מצטיין",{"$f":"84.5","v":84.5},100,">=84.50",null,null,null,null,null,null,null,null,null,"הגרלת מלגות"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ת.ז.",{"$f":"VLOOKUP(INT(RAND()*(MAX($B$4:$B$13)-MIN($B$4:$B$13))+MIN($B$4:$B$13)+1),$B$4:$B$13,1,1)","v":658370843},"שם הסטודנט",{"$f":"VLOOKUP(P43,$B$3:$R$13,MATCH(Q43,$B$3:$R$3,0),FALSE)","v":"יעל"},"התמחות",{"$f":"VLOOKUP(P43,$B$3:$R$13,MATCH(S43,$B$3:$R$3,0),FALSE)","v":"שיווק"}]
["סמלים","מגדר",null,null,null,null,null,null,null,null,null,null,null,null,"ת.ז.",{"$f":"VLOOKUP(INT(RAND()*(MAX($B$4:$B$13)-MIN($B$4:$B$13))+MIN($B$4:$B$13)+1),$B$4:$B$13,1,1)","v":298754355},"שם הסטודנט",{"$f":"VLOOKUP(P44,$B$3:$R$13,MATCH(Q44,$B$3:$R$3,0),FALSE)","v":"רמי"},"התמחות",{"$f":"VLOOKUP(P44,$B$3:$R$13,MATCH(S44,$B$3:$R$3,0),FALSE)","v":"חשבונאות"}]
[null,"סטודנטים","ז",null,null,null,null,null,null,null,null,null,null,null,"מס' זוכי המלגות מהתמחות",null,null,"שיווק",{"$f":"COUNTIF($T$43:$T$44,R45)","v":1}]
[null,"סטודנטיות","נ",null,null,null,null,null,null,null,null,null,null,null,"מס' זוכי המלגות מהתמחות",null,null,"חשבונאות",{"$f":"COUNTIF($T$43:$T$44,R46)","v":1}]
[]
[]
[]
[null,"ת.ז.","שם הסטודנט","מגדר","טלפון","מיקוד","התמחות","ציון ת. 1","ציון ת. 2","ציון ת. 3","ממוצע  תרגילים","ציון פרויקט","ציון בחינה","ציון סופי","ציון במילים","נשים מצטיינות","נשים או מצטיינים","לא נכשלו",null,"מגדר"]
[null,193878400,"טלי","נ",9876544,70000,"שיווק",81,80,82,81,81,81,81,"עובר","","מלגה","מלגה",null,"נ"]
[null,244576280,"שחר","נ",3252524,44451,"חשבונאות",94,100,93,95.666666666666671,95,100,97,"מצטיין","מלגה","מלגה","מלגה"]
[null,388923057,"מיכל","נ",8743644,44141,"חשבונאות",60,100,80,80,40,61,60,"עובר","","מלגה","מלגה"]
[null,658370843,"יעל","נ",2118758,55326,"שיווק",67,99,69,78.333333333333329,90,85,85,"מצטיין","מלגה","מלגה","מלגה"]
[null,830998987,"מיכל","נ",3527439,56324,"שיווק",80,null,87,83.5,90,null,44,"נכשל","","מלגה",""]
[null,983687692,"שרון","נ",6347234,55235,"חשבונאות",45,60,null,52.5,99,94,78,"עובר","","מלגה","מלגה"]
[]
[null,"ת.ז.","שם הסטודנט",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"מגדר"]
[null,123456789,"דניאל",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ז"]
[null,298754355,"רמי"]
[null,947465892,"שחר"]
[null,987654321,"יעקב"]
[]
[null,"שם הסטודנט","ציון סופי",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"מגדר","ציון במילים"]
[null,"שחר",97,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"נ","מצטיין"]
[null,"יעל",85]
[]
[null,"שם הסטודנט","ציון סופי",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ציון סופי"]
[null,"דניאל",89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">=85"]
[null,"שחר",97,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<60"]
[null,"יעל",85]
[null,"מיכל",44]
[]
[null,"שם הסטודנט","ציון בחינה",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ציון בחינה","ציון בחינה"]
[null,"דניאל",80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">=60","<85"]
[null,"טלי",81]
[null,"מיכל",61]
[null,"שחר",65]
[]
[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,null,null,null,null,null,null,null,null,null,"מגדר","ציון במילים"]
[null,"דניאל","ז",89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"נ"]
[null,"טלי","נ",81,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ז","מצטיין"]
[null,"שחר","נ",97]
[null,"מיכל","נ",60]
[null,"יעל","נ",85]
[null,"מיכל","נ",44]
[null,"שרון","נ",78]
[]
[null,"שם הסטודנט","ציון סופי"]
[null,"דניאל",89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N4>$N$15","v":true}]
[null,"טלי",81]
[null,"שחר",97]
[null,"יעל",85]
[null,"שרון",78]
[null,"יעקב",76]
[]
[null,"שם הסטודנט","ציון סופי",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ציון סופי"]
[null,"דניאל",89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\">\"&AVERAGE(N4:N13)","v":">74"}]
[null,"טלי",81]
[null,"שחר",97]
[null,"יעל",85]
[null,"שרון",78]
[null,"יעקב",76]

{"sheet":"פתרון 20-24","index":7,"n_rows":107,"n_cols":21,"rows_kept":107,"cut":false,"hidden":false,"merged":[[0,0,0,17],[2,0,12,0],[2,19,2,22],[14,0,29,0],[14,15,14,17],[22,15,22,17],[23,15,23,17],[25,15,25,17],[26,15,26,17],[28,15,28,17],[29,15,29,16],[30,15,30,16],[31,0,36,0],[31,15,31,16],[34,14,34,17],[35,14,35,15],[38,0,41,0],[41,14,41,19],[43,0,45,0],[43,1,43,2],[44,14,44,16],[45,14,45,16]]}
["תרגול באקסל"]
[]
["נתונים","ת.ז.","שם הסטודנט","מגדר","טלפון","מיקוד","התמחות","ציון ת. 1","ציון ת. 2","ציון ת. 3","ממוצע  תרגילים","ציון פרויקט","ציון בחינה","ציון סופי","ציון במילים","נשים מצטיינות","נשים או מצטיינים","לא נכשלו",null,"קריטריונים לסינון מתקדם"]
[null,123456789,"דניאל","ז",9877665,123,"שיווק",89,86,99,{"$f":"AVERAGE(H4:J4)","v":91.333333333333329},99,80,{"$f":"ROUND(H4*$C$32+I4*$C$33+J4*$C$34+L4*$C$35+M4*$C$36,0)","v":89},{"$f":"IF(N4<$C$41,$B$40,IF(N4<$C$42,$B$41,$B$42))","v":"מצטיין"},{"$f":"IF(AND(D4=$C$46,O4=$B$42),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D4=$C$46,O4=$B$42),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N4<$C$41),\"מלגה\",\"\")","v":"מלגה"}]
[null,193878400,"טלי","נ",9876544,70000,"שיווק",81,80,82,81,81,81,81,"עובר","","מלגה","מלגה"]
[null,244576280,"שחר","נ",3252524,44451,"חשבונאות",94,100,93,95.666666666666671,95,100,97,"מצטיין","מלגה","מלגה","מלגה"]
[null,298754355,"רמי","ז",8763456,83934,"חשבונאות",88,90,74,84,55,45,60,"עובר","","","מלגה"]
[null,388923057,"מיכל","נ",8743644,44141,"חשבונאות",60,100,80,80,40,61,60,"עובר","","מלגה","מלגה"]
[null,658370843,"יעל","נ",2118758,55326,"שיווק",67,99,69,78.333333333333329,90,85,85,"מצטיין","מלגה","מלגה","מלגה"]
[null,830998987,"מיכל","נ",3527439,56324,"שיווק",80,null,87,83.5,90,null,44,"נכשל","","מלגה",""]
[null,947465892,"שחר","ז",3434324,41466,"חשבונאות",null,79,99,89,86,65,70,"עובר","","","מלגה"]
[null,983687692,"שרון","נ",6347234,55235,"חשבונאות",45,60,null,52.5,99,94,78,"עובר","","מלגה","מלגה"]
[null,987654321,"יעקב","ז",7563094,86534,"שיווק",91,79,85,85,100,50,76,"עובר","","","מלגה"]
[]
["חישובים","ממוצע  כיתתי ",null,null,null,null,null,{"$f":"AVERAGE(H4:H13)","v":77.222222222222229},{"$f":"AVERAGE(I4:I13)","v":85.888888888888886},85.333333333333329,82.033333333333331,83.5,73.444444444444443,74,null,"התפלגות ציונים סופיים"]
[null,"חציון",null,null,null,null,null,{"$f":"MEDIAN(H4:H13)","v":81},{"$f":"MEDIAN(I4:I13)","v":86},85,83.75,90,80,77,null,"0-59",59,{"$f":"FREQUENCY(N4:N13,Q16:Q21)","v":1}]
[null,"שכיח",null,null,null,null,null,{"$f":"MODE(H4:H13)","v":{"$error":"#N/A"}},{"$f":"MODE(I4:I13)","v":100},99,{"$error":"#N/A"},99,{"$error":"#N/A"},60,null,"60-74",74,3]
[null,"מקסימום",null,null,null,null,null,{"$f":"MAX(H4:H13)","v":94},{"$f":"MAX(I4:I13)","v":100},99,95.666666666666671,100,100,97,null,"75-84",84,3]
[null,"מינימום",null,null,null,null,null,{"$f":"MIN(H4:H13)","v":45},{"$f":"MIN(I4:I13)","v":60},69,52.5,40,45,44,null,"85-94",94,2]
[null,"סטיית תקן",null,null,null,null,null,{"$f":"STDEV(H4:H13)","v":16.536155673083279},{"$f":"STDEV(I4:I13)","v":13.166666666666675},10.428326807307105,11.67534069082849,20.23885152648517,19.190564811327921,15.818414023606231,null,"95-100",100,1]
[null,"שונות",null,null,null,null,null,{"$f":"VAR(H4:H13)","v":273.44444444444434},{"$f":"VAR(I4:I13)","v":173.36111111111131},108.75,136.31358024691548,409.61111111111109,368.27777777777737,250.22222222222223,null,"מעל 100",null,0]
[null,"שלחו תרגיל/ נבחנו",null,null,null,null,null,{"$f":"COUNT(H4:H13)","v":9},{"$f":"COUNT(I4:I13)","v":9},9,10,10,9,10]
[null,"נכשלו",null,null,null,null,null,{"$f":"COUNTIF(H4:H13,\"<\"&$C$41)","v":1},0,0,1,2,2,1,null,"הסטודנט עם הציון הגבוה ביותר"]
[null,"עברו",null,null,null,null,null,{"$f":"COUNTIFS(H4:H13,\">=\"&$C$41,H4:H13,\"<\"&$C$42)","v":4},4,4,5,1,4,6,null,{"$f":"LOOKUP(N18,N4:N13,C4:C13)","v":"יעקב"}]
[null,"מצטיינים",null,null,null,null,null,{"$f":"COUNTIF(H4:H13,E42)","v":4},{"$f":"COUNTIF(I4:I13,\">=\"&$C$42)","v":5},5,4,7,3,3]
[null,"מתוכם:",{"$f":"B45","v":"סטודנטים"},null,null,null,null,{"$f":"COUNTIFS($D$4:$D$13,$C$45,H4:H13,\">=\"&$C$42)","v":3},2,3,3,3,0,1,null,"המיקום של 'ציון סופי'"]
[null,null,{"$f":"B46","v":"סטודנטיות"},null,null,null,null,{"$f":"COUNTIFS($D$4:$D$13,$C$46,H4:H13,$E$42)","v":1},3,2,1,4,3,2,null,{"$f":"MATCH(N3,B3:R3,0)","v":13}]
[null,"ס\"ה סטודנטים",null,{"$f":"COUNTA(C4:C13)","v":10},null,null,"ממוצע של מקבלי ציון \"עובר\":",{"$f":"AVERAGEIFS(H4:H13,H4:H13,\">=\"&$C$41,H4:H13,\"<\"&$C$42)","v":72},74.5,76.25,81.36666666666666,81,71.75,70.833333333333329]
[null,"מתוכם:",{"$f":"B45","v":"סטודנטים"},{"$f":"COUNTIF(D4:D13,C45)","v":4},null,null,"בממוצע:",{"$f":"AVERAGEIF($D$4:$D$13,$C45,H$4:H$13)","v":89.333333333333329},83.5,89.25,87.333333333333329,85,60,73.75,null,"שליפת מידע עם index+match"]
[null,null,{"$f":"B46","v":"סטודנטיות"},{"$f":"COUNTIF(D4:D13,C46)","v":6},null,null,"בממוצע:",71.166666666666671,87.8,82.2,78.5,82.5,84.2,74.166666666666671,null,"הזן ציון",null,81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"בחר מידע מבוקש",null,"שם הסטודנט"]
["טבלת משקולות","משקל תרגיל 1",0.1,null,null,null,null,null,null,null,null,null,null,null,null,"תוצאה:",null,{"$f":"INDEX(B4:R13,MATCH(R30,N4:N13,0),MATCH(R31,B3:R3,0))","v":"טלי"}]
[null,"משקל תרגיל 2",0.1]
[null,"משקל תרגיל 3",0.1]
[null,"משקל פרויקט",0.3,null,null,null,null,null,null,null,null,null,null,null,"שליפת מידע עם Vlookup"]
[null,"משקל מבחן",0.4,null,null,null,null,null,null,null,null,null,null,null,"הזן ת.ז.",null,123456789]
[null,"סה\"כ",{"$f":"SUM(C32:C36)","v":1},null,null,null,null,null,null,null,null,null,null,null,"בחר מידע מבוקש",null,"ממוצע  תרגילים",{"$f":"VLOOKUP($Q$36,$B$3:$R$13,MATCH(Q37,$B$3:$R$3,0),FALSE)","v":91.333333333333329}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"בחר מידע מבוקש",null,"ציון פרויקט",{"$f":"VLOOKUP($Q$36,$B$3:$R$13,MATCH(Q38,$B$3:$R$3,0),FALSE)","v":99}]
["טבלת עזר",null,"מ-","עד",null,null,null,null,null,null,null,null,null,null,"בחר מידע מבוקש",null,"ציון בחינה",{"$f":"VLOOKUP($Q$36,$B$3:$R$13,MATCH(Q39,$B$3:$R$3,0),FALSE)","v":80}]
[null,"נכשל",0,59.49,null,null,null,null,null,null,null,null,null,null,"בחר מידע מבוקש",null,"ציון סופי",{"$f":"VLOOKUP($Q$36,$B$3:$R$13,MATCH(Q40,$B$3:$R$3,0),FALSE)","v":89}]
[null,"עובר",59.5,84.49]
[null,"מצטיין",{"$f":"84.5","v":84.5},100,">=84.50",null,null,null,null,null,null,null,null,null,"הגרלת מלגות"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ת.ז.",{"$f":"VLOOKUP(INT(RAND()*(MAX($B$4:$B$13)-MIN($B$4:$B$13))+MIN($B$4:$B$13)+1),$B$4:$B$13,1,1)","v":123456789},"שם הסטודנט",{"$f":"VLOOKUP(P43,$B$3:$R$13,MATCH(Q43,$B$3:$R$3,0),FALSE)","v":"דניאל"},"התמחות",{"$f":"VLOOKUP(P43,$B$3:$R$13,MATCH(S43,$B$3:$R$3,0),FALSE)","v":"שיווק"}]
["סמלים","מגדר",null,null,null,null,null,null,null,null,null,null,null,null,"ת.ז.",{"$f":"VLOOKUP(INT(RAND()*(MAX($B$4:$B$13)-MIN($B$4:$B$13))+MIN($B$4:$B$13)+1),$B$4:$B$13,1,1)","v":244576280},"שם הסטודנט",{"$f":"VLOOKUP(P44,$B$3:$R$13,MATCH(Q44,$B$3:$R$3,0),FALSE)","v":"שחר"},"התמחות",{"$f":"VLOOKUP(P44,$B$3:$R$13,MATCH(S44,$B$3:$R$3,0),FALSE)","v":"חשבונאות"}]
[null,"סטודנטים","ז",null,null,null,null,null,null,null,null,null,null,null,"מס' זוכי המלגות מהתמחות",null,null,"שיווק",{"$f":"COUNTIF($T$43:$T$44,R45)","v":1}]
[null,"סטודנטיות","נ",null,null,null,null,null,null,null,null,null,null,null,"מס' זוכי המלגות מהתמחות",null,null,"חשבונאות",{"$f":"COUNTIF($T$43:$T$44,R46)","v":1}]
[]
[]
[]
[null,"ת.ז.","שם הסטודנט","מגדר","טלפון","מיקוד","התמחות","ציון ת. 1","ציון ת. 2","ציון ת. 3","ממוצע  תרגילים","ציון פרויקט","ציון בחינה","ציון סופי","ציון במילים","נשים מצטיינות","נשים או מצטיינים","לא נכשלו",null,"מגדר"]
[null,193878400,"טלי","נ",9876544,70000,"שיווק",81,80,82,81,81,81,81,"עובר","","מלגה","מלגה",null,"נ"]
[null,244576280,"שחר","נ",3252524,44451,"חשבונאות",94,100,93,95.666666666666671,95,100,97,"מצטיין","מלגה","מלגה","מלגה"]
[null,388923057,"מיכל","נ",8743644,44141,"חשבונאות",60,100,80,80,40,61,60,"עובר","","מלגה","מלגה"]
[null,658370843,"יעל","נ",2118758,55326,"שיווק",67,99,69,78.333333333333329,90,85,85,"מצטיין","מלגה","מלגה","מלגה"]
[null,830998987,"מיכל","נ",3527439,56324,"שיווק",80,null,87,83.5,90,null,44,"נכשל","","מלגה",""]
[null,983687692,"שרון","נ",6347234,55235,"חשבונאות",45,60,null,52.5,99,94,78,"עובר","","מלגה","מלגה"]
[]
[null,"ת.ז.","שם הסטודנט",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"מגדר"]
[null,123456789,"דניאל",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ז"]
[null,298754355,"רמי"]
[null,947465892,"שחר"]
[null,987654321,"יעקב"]
[]
[null,"שם הסטודנט","ציון סופי",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"מגדר","ציון במילים"]
[null,"שחר",97,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"נ","מצטיין"]
[null,"יעל",85]
[]
[null,"שם הסטודנט","ציון סופי",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ציון סופי"]
[null,"דניאל",89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">=85"]
[null,"שחר",97,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<60"]
[null,"יעל",85]
[null,"מיכל",44]
[]
[null,"שם הסטודנט","ציון בחינה",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ציון בחינה","ציון בחינה"]
[null,"דניאל",80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">=60","<85"]
[null,"טלי",81]
[null,"מיכל",61]
[null,"שחר",65]
[]
[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,null,null,null,null,null,null,null,null,null,"מגדר","ציון במילים"]
[null,"דניאל","ז",89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"נ"]
[null,"טלי","נ",81,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ז","מצטיין"]
[null,"שחר","נ",97]
[null,"מיכל","נ",60]
[null,"יעל","נ",85]
[null,"מיכל","נ",44]
[null,"שרון","נ",78]
[]
[null,"שם הסטודנט","ציון סופי"]
[null,"דניאל",89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N4>$N$15","v":true}]
[null,"טלי",81]
[null,"שחר",97]
[null,"יעל",85]
[null,"שרון",78]
[null,"יעקב",76]
[]
[null,"שם הסטודנט","ציון סופי",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ציון סופי"]
[null,"דניאל",89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\">\"&AVERAGE(N4:N13)","v":">74"}]
[null,"טלי",81]
[null,"שחר",97]
[null,"יעל",85]
[null,"שרון",78]
[null,"יעקב",76]