{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["1","פתרון 1","2-5","פתרון 2-5","6-27","פתרון 6-26","פתרון 27","28-31","פתרון 28-31"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":5,"defined_names":55,"comments":6,"pivot_tables":2},"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":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],[38,0,41,0],[43,0,45,0],[43,1,43,2],[29,15,29,16],[30,15,30,16],[31,0,36,0],[31,15,31,16],[34,14,34,17],[35,14,35,15]]}
["תרגול באקסל"]
[]
["נתונים","ת.ז.","שם הסטודנט","מגדר","טלפון","מיקוד","התמחות","ציון ת. 1","ציון ת. 2","ציון ת. 3","ממוצע  תרגילים","ציון פרויקט","ציון בחינה","ציון סופי","ציון במילים","נשים מצטיינות","נשים או מצטיינים","לא נכשלו",null,"קריטריונים לסינון מתקדם"]
[null,830998987,"מיכל","נ",3527439,56324,"שיווק",80,null,87,{"$f":"AVERAGE(H4:J4)","v":83.5},90,null,{"$f":"ROUND(H4*$C$32+I4*$C$33+J4*$C$34+L4*$C$35+M4*$C$36,0)","v":44},{"$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,298754355,"רמי","ז",8763456,83934,"חשבונאות",88,90,74,84,55,45,60,"עובר","","","מלגה"]
[null,388923057,"מיכל","נ",8743644,44141,"חשבונאות",60,100,80,80,40,61,60,"עובר","","מלגה","מלגה"]
[null,947465892,"שחר","ז",3434324,41466,"חשבונאות",null,79,99,89,86,65,70,"עובר","","","מלגה"]
[null,987654321,"יעקב","ז",7563094,86534,"שיווק",91,79,85,85,100,50,76,"עובר","","","מלגה"]
[null,983687692,"שרון","נ",6347234,55235,"חשבונאות",45,60,null,52.5,99,94,78,"עובר","","מלגה","מלגה"]
[null,193878400,"טלי","נ",9876544,70000,"שיווק",81,80,82,81,81,81,81,"עובר","","מלגה","מלגה"]
[null,658370843,"יעל","נ",2118758,55326,"שיווק",67,99,69,78.333333333333329,90,85,85,"מצטיין","מלגה","מלגה","מלגה"]
[null,123456789,"דניאל","ז",9877665,123,"שיווק",89,86,99,91.333333333333329,99,80,89,"מצטיין","","מלגה","מלגה"]
[null,244576280,"שחר","נ",3252524,44451,"חשבונאות",94,100,93,95.666666666666671,95,100,97,"מצטיין","מלגה","מלגה","מלגה"]
[]
["חישובים","ממוצע  כיתתי ",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"},90,{"$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.675340690828351,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.31358024691224,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},{"$f":"COUNTIF(I4:I13,\"<\"&$C$41)","v":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},{"$f":"COUNTIFS(I4:I13,\">=\"&$C$41,I4:I13,\"<\"&$C$42)","v":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},{"$f":"COUNTIFS($D$4:$D$13,$C$45,I4:I13,\">=\"&$C$42)","v":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},{"$f":"COUNTIFS($D$4:$D$13,$C$46,I4:I13,$E$42)","v":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},{"$f":"AVERAGEIFS(I4:I13,I4:I13,\">=\"&$C$41,I4:I13,\"<\"&$C$42)","v":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},{"$f":"AVERAGEIF($D$4:$D$13,$C45,I$4:I$13)","v":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,"בממוצע:",{"$f":"AVERAGEIF($D$4:$D$13,$C46,H$4:H$13)","v":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,"ת.ז.","שם הסטודנט","מגדר","טלפון","מיקוד","התמחות","ציון ת. 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":false}]
[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":"פתרון 1","index":1,"n_rows":114,"n_cols":21,"rows_kept":114,"cut":false,"hidden":false,"merged":[[0,0,0,17],[2,0,16,0],[2,19,2,22],[21,0,36,0],[21,15,21,17],[29,15,29,17],[30,15,30,17],[32,15,32,17],[33,15,33,17],[35,15,35,17],[45,0,48,0],[50,0,52,0],[50,1,50,2],[36,15,36,16],[37,15,37,16],[38,0,43,0],[38,15,38,16],[41,14,41,17],[42,14,42,15]]}
["תרגול באקסל"]
[]
["נתונים","ת.ז.","שם הסטודנט","מגדר","טלפון","מיקוד","התמחות","ציון ת. 1","ציון ת. 2","ציון ת. 3","ממוצע  תרגילים","ציון פרויקט","ציון בחינה","ציון סופי","ציון במילים","נשים מצטיינות","נשים או מצטיינים","לא נכשלו",null,"קריטריונים לסינון מתקדם"]
[null,298754355,"רמי","ז",8763456,83934,"חשבונאות",88,90,74,{"$f":"AVERAGE(H4:J4)","v":84},55,45,{"$f":"ROUND(H4*$C$39+I4*$C$40+J4*$C$41+L4*$C$42+M4*$C$43,0)","v":60},{"$f":"IF(N4<$C$48,$B$47,IF(N4<$C$49,$B$48,$B$49))","v":"עובר"},{"$f":"IF(AND(D4=$C$53,O4=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D4=$C$53,O4=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(NOT(N4<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,947465892,"שחר","ז",3434324,41466,"חשבונאות",null,79,99,{"$f":"AVERAGE(H5:J5)","v":89},86,65,{"$f":"ROUND(H5*$C$39+I5*$C$40+J5*$C$41+L5*$C$42+M5*$C$43,0)","v":70},{"$f":"IF(N5<$C$48,$B$47,IF(N5<$C$49,$B$48,$B$49))","v":"עובר"},{"$f":"IF(AND(D5=$C$53,O5=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D5=$C$53,O5=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(NOT(N5<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,{"$f":"SUBTOTAL(3,B4:B5)","v":2},null,"ז ספירה"]
[null,388923057,"מיכל","נ",8743644,44141,"חשבונאות",60,100,80,{"$f":"AVERAGE(H7:J7)","v":80},40,61,{"$f":"ROUND(H7*$C$39+I7*$C$40+J7*$C$41+L7*$C$42+M7*$C$43,0)","v":60},{"$f":"IF(N7<$C$48,$B$47,IF(N7<$C$49,$B$48,$B$49))","v":"עובר"},{"$f":"IF(AND(D7=$C$53,O7=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D7=$C$53,O7=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N7<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,983687692,"שרון","נ",6347234,55235,"חשבונאות",45,60,null,{"$f":"AVERAGE(H8:J8)","v":52.5},99,94,{"$f":"ROUND(H8*$C$39+I8*$C$40+J8*$C$41+L8*$C$42+M8*$C$43,0)","v":78},{"$f":"IF(N8<$C$48,$B$47,IF(N8<$C$49,$B$48,$B$49))","v":"עובר"},{"$f":"IF(AND(D8=$C$53,O8=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D8=$C$53,O8=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N8<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,244576280,"שחר","נ",3252524,44451,"חשבונאות",94,100,93,{"$f":"AVERAGE(H9:J9)","v":95.666666666666671},95,100,{"$f":"ROUND(H9*$C$39+I9*$C$40+J9*$C$41+L9*$C$42+M9*$C$43,0)","v":97},{"$f":"IF(N9<$C$48,$B$47,IF(N9<$C$49,$B$48,$B$49))","v":"מצטיין"},{"$f":"IF(AND(D9=$C$53,O9=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(OR(D9=$C$53,O9=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N9<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,{"$f":"SUBTOTAL(3,B7:B9)","v":3},null,"נ ספירה"]
[null,{"$f":"SUBTOTAL(3,B4:B9)","v":5},null,null,null,null,"חשבונאות ספירה"]
[null,987654321,"יעקב","ז",7563094,86534,"שיווק",91,79,85,{"$f":"AVERAGE(H12:J12)","v":85},100,50,{"$f":"ROUND(H12*$C$39+I12*$C$40+J12*$C$41+L12*$C$42+M12*$C$43,0)","v":76},{"$f":"IF(N12<$C$48,$B$47,IF(N12<$C$49,$B$48,$B$49))","v":"עובר"},{"$f":"IF(AND(D12=$C$53,O12=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D12=$C$53,O12=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(NOT(N12<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,123456789,"דניאל","ז",9877665,123,"שיווק",89,86,99,{"$f":"AVERAGE(H13:J13)","v":91.333333333333329},99,80,{"$f":"ROUND(H13*$C$39+I13*$C$40+J13*$C$41+L13*$C$42+M13*$C$43,0)","v":89},{"$f":"IF(N13<$C$48,$B$47,IF(N13<$C$49,$B$48,$B$49))","v":"מצטיין"},{"$f":"IF(AND(D13=$C$53,O13=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D13=$C$53,O13=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N13<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,{"$f":"SUBTOTAL(3,B12:B13)","v":2},null,"ז ספירה"]
[null,830998987,"מיכל","נ",3527439,56324,"שיווק",80,null,87,{"$f":"AVERAGE(H15:J15)","v":83.5},90,null,{"$f":"ROUND(H15*$C$39+I15*$C$40+J15*$C$41+L15*$C$42+M15*$C$43,0)","v":44},{"$f":"IF(N15<$C$48,$B$47,IF(N15<$C$49,$B$48,$B$49))","v":"נכשל"},{"$f":"IF(AND(D15=$C$53,O15=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D15=$C$53,O15=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N15<$C$48),\"מלגה\",\"\")","v":""}]
[null,193878400,"טלי","נ",9876544,70000,"שיווק",81,80,82,{"$f":"AVERAGE(H16:J16)","v":81},81,81,{"$f":"ROUND(H16*$C$39+I16*$C$40+J16*$C$41+L16*$C$42+M16*$C$43,0)","v":81},{"$f":"IF(N16<$C$48,$B$47,IF(N16<$C$49,$B$48,$B$49))","v":"עובר"},{"$f":"IF(AND(D16=$C$53,O16=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D16=$C$53,O16=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N16<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,658370843,"יעל","נ",2118758,55326,"שיווק",67,99,69,{"$f":"AVERAGE(H17:J17)","v":78.333333333333329},90,85,{"$f":"ROUND(H17*$C$39+I17*$C$40+J17*$C$41+L17*$C$42+M17*$C$43,0)","v":85},{"$f":"IF(N17<$C$48,$B$47,IF(N17<$C$49,$B$48,$B$49))","v":"מצטיין"},{"$f":"IF(AND(D17=$C$53,O17=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(OR(D17=$C$53,O17=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N17<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,{"$f":"SUBTOTAL(3,B15:B17)","v":3},null,"נ ספירה"]
[null,{"$f":"SUBTOTAL(3,B12:B17)","v":5},null,null,null,null,"שיווק ספירה"]
[null,{"$f":"SUBTOTAL(3,B4:B17)","v":10},null,null,null,null,"ספירה כוללת"]
[]
["חישובים","ממוצע  כיתתי ",null,null,null,null,null,{"$f":"AVERAGE(H4:H17)","v":77.222222222222229},{"$f":"AVERAGE(I4:I17)","v":85.888888888888886},85.333333333333329,82.033333333333331,83.5,73.444444444444443,74,null,"התפלגות ציונים סופיים"]
[null,"חציון",null,null,null,null,null,{"$f":"MEDIAN(H4:H17)","v":81},{"$f":"MEDIAN(I4:I17)","v":86},85,83.75,90,80,77,null,"0-59",59,{"$f":"FREQUENCY(N4:N17,Q23:Q28)","v":1}]
[null,"שכיח",null,null,null,null,null,{"$f":"MODE(H4:H17)","v":{"$error":"#N/A"}},{"$f":"MODE(I4:I17)","v":79},99,{"$error":"#N/A"},99,{"$error":"#N/A"},60,null,"60-74",74,3]
[null,"מקסימום",null,null,null,null,null,{"$f":"MAX(H4:H17)","v":94},{"$f":"MAX(I4:I17)","v":100},99,95.666666666666671,100,100,97,null,"75-84",84,3]
[null,"מינימום",null,null,null,null,null,{"$f":"MIN(H4:H17)","v":45},{"$f":"MIN(I4:I17)","v":60},69,52.5,40,45,44,null,"85-94",94,2]
[null,"סטיית תקן",null,null,null,null,null,{"$f":"STDEV(H4:H17)","v":16.536155673083279},{"$f":"STDEV(I4:I17)","v":13.166666666666675},10.428326807307105,11.675340690828351,20.23885152648517,19.190564811327921,15.818414023606231,null,"95-100",100,1]
[null,"שונות",null,null,null,null,null,{"$f":"VAR(H4:H17)","v":273.44444444444434},{"$f":"VAR(I4:I17)","v":173.36111111111131},108.75,136.31358024691224,409.61111111111109,368.27777777777737,250.22222222222223,null,"מעל 100",null,0]
[null,"שלחו תרגיל/ נבחנו",null,null,null,null,null,{"$f":"COUNT(H4:H17)","v":9},{"$f":"COUNT(I4:I17)","v":9},9,10,10,9,10]
[null,"נכשלו",null,null,null,null,null,{"$f":"COUNTIF(H4:H17,\"<\"&$C$48)","v":1},0,0,1,2,2,1,null,"הסטודנט עם הציון הגבוה ביותר"]
[null,"עברו",null,null,null,null,null,{"$f":"COUNTIFS(H4:H17,\">=\"&$C$48,H4:H17,\"<\"&$C$49)","v":4},4,4,5,1,4,6,null,{"$f":"LOOKUP(N25,N4:N17,C4:C17)","v":"יעל"}]
[null,"מצטיינים",null,null,null,null,null,{"$f":"COUNTIF(H4:H17,E49)","v":4},{"$f":"COUNTIF(I4:I17,\">=\"&$C$49)","v":5},5,4,7,3,3]
[null,"מתוכם:",{"$f":"B52","v":"סטודנטים"},null,null,null,null,{"$f":"COUNTIFS($D$4:$D$17,$C$52,H4:H17,\">=\"&$C$49)","v":3},2,3,3,3,0,1,null,"המיקום של 'ציון סופי'"]
[null,null,{"$f":"B53","v":"סטודנטיות"},null,null,null,null,{"$f":"COUNTIFS($D$4:$D$17,$C$53,H4:H17,$E$49)","v":1},3,2,1,4,3,2,null,{"$f":"MATCH(N3,B3:R3,0)","v":13}]
[null,"ס\"ה סטודנטים",null,{"$f":"COUNTA(C4:C17)","v":10},null,null,"ממוצע של מקבלי ציון \"עובר\":",{"$f":"AVERAGEIFS(H4:H17,H4:H17,\">=\"&$C$48,H4:H17,\"<\"&$C$49)","v":72},74.5,76.25,81.36666666666666,81,71.75,70.833333333333329]
[null,"מתוכם:",{"$f":"B52","v":"סטודנטים"},{"$f":"COUNTIF(D4:D17,C52)","v":4},null,null,"בממוצע:",{"$f":"AVERAGEIF($D$4:$D$17,$C52,H$4:H$17)","v":89.333333333333329},83.5,89.25,87.333333333333329,85,60,73.75,null,"שליפת מידע עם index+match"]
[null,null,{"$f":"B53","v":"סטודנטיות"},{"$f":"COUNTIF(D4:D17,C53)","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:R17,MATCH(R37,N4:N17,0),MATCH(R38,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(C39:C43)","v":1},null,null,null,null,null,null,null,null,null,null,null,"בחר מידע מבוקש",null,"ממוצע  תרגילים",{"$f":"VLOOKUP($Q$43,$B$3:$R$17,MATCH(Q44,$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$43,$B$3:$R$17,MATCH(Q45,$B$3:$R$3,0),FALSE)","v":99}]
["טבלת עזר",null,"מ-","עד",null,null,null,null,null,null,null,null,null,null,"בחר מידע מבוקש",null,"ציון בחינה",{"$f":"VLOOKUP($Q$43,$B$3:$R$17,MATCH(Q46,$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$43,$B$3:$R$17,MATCH(Q47,$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,"ת.ז.","שם הסטודנט","מגדר","טלפון","מיקוד","התמחות","ציון ת. 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$22","v":false}]
[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:N17)","v":">74"}]
[null,"טלי",81]
[null,"שחר",97]
[null,"יעל",85]
[null,"שרון",78]
[null,"יעקב",76]

{"sheet":"2-5","index":2,"n_rows":114,"n_cols":21,"rows_kept":114,"cut":false,"hidden":false,"merged":[[0,0,0,17],[2,0,16,0],[2,19,2,22],[21,0,36,0],[21,15,21,17],[29,15,29,17],[30,15,30,17],[32,15,32,17],[33,15,33,17],[35,15,35,17],[45,0,48,0],[50,0,52,0],[50,1,50,2],[36,15,36,16],[37,15,37,16],[38,0,43,0],[38,15,38,16],[41,14,41,17],[42,14,42,15]]}
["תרגול באקסל"]
[]
["נתונים","ת.ז.","שם הסטודנט","מגדר","טלפון","מיקוד","התמחות","ציון ת. 1","ציון ת. 2","ציון ת. 3","ממוצע  תרגילים","ציון פרויקט","ציון בחינה","ציון סופי","ציון במילים","נשים מצטיינות","נשים או מצטיינים","לא נכשלו",null,"קריטריונים לסינון מתקדם"]
[null,298754355,"רמי","ז",8763456,83934,"חשבונאות",88,90,74,{"$f":"AVERAGE(H4:J4)","v":84},55,45,{"$f":"ROUND(H4*$C$39+I4*$C$40+J4*$C$41+L4*$C$42+M4*$C$43,0)","v":60},{"$f":"IF(N4<$C$48,$B$47,IF(N4<$C$49,$B$48,$B$49))","v":"עובר"},{"$f":"IF(AND(D4=$C$53,O4=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D4=$C$53,O4=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(NOT(N4<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,947465892,"שחר","ז",3434324,41466,"חשבונאות",null,79,99,{"$f":"AVERAGE(H5:J5)","v":89},86,65,{"$f":"ROUND(H5*$C$39+I5*$C$40+J5*$C$41+L5*$C$42+M5*$C$43,0)","v":70},{"$f":"IF(N5<$C$48,$B$47,IF(N5<$C$49,$B$48,$B$49))","v":"עובר"},{"$f":"IF(AND(D5=$C$53,O5=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D5=$C$53,O5=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(NOT(N5<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,{"$f":"SUBTOTAL(3,B4:B5)","v":2},null,"ז ספירה"]
[null,388923057,"מיכל","נ",8743644,44141,"חשבונאות",60,100,80,{"$f":"AVERAGE(H7:J7)","v":80},40,61,{"$f":"ROUND(H7*$C$39+I7*$C$40+J7*$C$41+L7*$C$42+M7*$C$43,0)","v":60},{"$f":"IF(N7<$C$48,$B$47,IF(N7<$C$49,$B$48,$B$49))","v":"עובר"},{"$f":"IF(AND(D7=$C$53,O7=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D7=$C$53,O7=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N7<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,983687692,"שרון","נ",6347234,55235,"חשבונאות",45,60,null,{"$f":"AVERAGE(H8:J8)","v":52.5},99,94,{"$f":"ROUND(H8*$C$39+I8*$C$40+J8*$C$41+L8*$C$42+M8*$C$43,0)","v":78},{"$f":"IF(N8<$C$48,$B$47,IF(N8<$C$49,$B$48,$B$49))","v":"עובר"},{"$f":"IF(AND(D8=$C$53,O8=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D8=$C$53,O8=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N8<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,244576280,"שחר","נ",3252524,44451,"חשבונאות",94,100,93,{"$f":"AVERAGE(H9:J9)","v":95.666666666666671},95,100,{"$f":"ROUND(H9*$C$39+I9*$C$40+J9*$C$41+L9*$C$42+M9*$C$43,0)","v":97},{"$f":"IF(N9<$C$48,$B$47,IF(N9<$C$49,$B$48,$B$49))","v":"מצטיין"},{"$f":"IF(AND(D9=$C$53,O9=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(OR(D9=$C$53,O9=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N9<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,{"$f":"SUBTOTAL(3,B7:B9)","v":3},null,"נ ספירה"]
[null,{"$f":"SUBTOTAL(3,B4:B9)","v":5},null,null,null,null,"חשבונאות ספירה"]
[null,987654321,"יעקב","ז",7563094,86534,"שיווק",91,79,85,{"$f":"AVERAGE(H12:J12)","v":85},100,50,{"$f":"ROUND(H12*$C$39+I12*$C$40+J12*$C$41+L12*$C$42+M12*$C$43,0)","v":76},{"$f":"IF(N12<$C$48,$B$47,IF(N12<$C$49,$B$48,$B$49))","v":"עובר"},{"$f":"IF(AND(D12=$C$53,O12=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D12=$C$53,O12=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(NOT(N12<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,123456789,"דניאל","ז",9877665,123,"שיווק",89,86,99,{"$f":"AVERAGE(H13:J13)","v":91.333333333333329},99,80,{"$f":"ROUND(H13*$C$39+I13*$C$40+J13*$C$41+L13*$C$42+M13*$C$43,0)","v":89},{"$f":"IF(N13<$C$48,$B$47,IF(N13<$C$49,$B$48,$B$49))","v":"מצטיין"},{"$f":"IF(AND(D13=$C$53,O13=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D13=$C$53,O13=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N13<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,{"$f":"SUBTOTAL(3,B12:B13)","v":2},null,"ז ספירה"]
[null,830998987,"מיכל","נ",3527439,56324,"שיווק",80,null,87,{"$f":"AVERAGE(H15:J15)","v":83.5},90,null,{"$f":"ROUND(H15*$C$39+I15*$C$40+J15*$C$41+L15*$C$42+M15*$C$43,0)","v":44},{"$f":"IF(N15<$C$48,$B$47,IF(N15<$C$49,$B$48,$B$49))","v":"נכשל"},{"$f":"IF(AND(D15=$C$53,O15=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D15=$C$53,O15=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N15<$C$48),\"מלגה\",\"\")","v":""}]
[null,193878400,"טלי","נ",9876544,70000,"שיווק",81,80,82,{"$f":"AVERAGE(H16:J16)","v":81},81,81,{"$f":"ROUND(H16*$C$39+I16*$C$40+J16*$C$41+L16*$C$42+M16*$C$43,0)","v":81},{"$f":"IF(N16<$C$48,$B$47,IF(N16<$C$49,$B$48,$B$49))","v":"עובר"},{"$f":"IF(AND(D16=$C$53,O16=$B$49),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D16=$C$53,O16=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N16<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,658370843,"יעל","נ",2118758,55326,"שיווק",67,99,69,{"$f":"AVERAGE(H17:J17)","v":78.333333333333329},90,85,{"$f":"ROUND(H17*$C$39+I17*$C$40+J17*$C$41+L17*$C$42+M17*$C$43,0)","v":85},{"$f":"IF(N17<$C$48,$B$47,IF(N17<$C$49,$B$48,$B$49))","v":"מצטיין"},{"$f":"IF(AND(D17=$C$53,O17=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(OR(D17=$C$53,O17=$B$49),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N17<$C$48),\"מלגה\",\"\")","v":"מלגה"}]
[null,{"$f":"SUBTOTAL(3,B15:B17)","v":3},null,"נ ספירה"]
[null,{"$f":"SUBTOTAL(3,B12:B17)","v":5},null,null,null,null,"שיווק ספירה"]
[null,{"$f":"SUBTOTAL(3,B4:B17)","v":10},null,null,null,null,"ספירה כוללת"]
[]
["חישובים","ממוצע  כיתתי ",null,null,null,null,null,{"$f":"AVERAGE(H4:H17)","v":77.222222222222229},{"$f":"AVERAGE(I4:I17)","v":85.888888888888886},85.333333333333329,82.033333333333331,83.5,73.444444444444443,74,null,"התפלגות ציונים סופיים"]
[null,"חציון",null,null,null,null,null,{"$f":"MEDIAN(H4:H17)","v":81},{"$f":"MEDIAN(I4:I17)","v":86},85,83.75,90,80,77,null,"0-59",59,{"$f":"FREQUENCY(N4:N17,Q23:Q28)","v":1}]
[null,"שכיח",null,null,null,null,null,{"$f":"MODE(H4:H17)","v":{"$error":"#N/A"}},{"$f":"MODE(I4:I17)","v":79},99,{"$error":"#N/A"},99,{"$error":"#N/A"},60,null,"60-74",74,3]
[null,"מקסימום",null,null,null,null,null,{"$f":"MAX(H4:H17)","v":94},{"$f":"MAX(I4:I17)","v":100},99,95.666666666666671,100,100,97,null,"75-84",84,3]
[null,"מינימום",null,null,null,null,null,{"$f":"MIN(H4:H17)","v":45},{"$f":"MIN(I4:I17)","v":60},69,52.5,40,45,44,null,"85-94",94,2]
[null,"סטיית תקן",null,null,null,null,null,{"$f":"STDEV(H4:H17)","v":16.536155673083279},{"$f":"STDEV(I4:I17)","v":13.166666666666675},10.428326807307105,11.675340690828351,20.23885152648517,19.190564811327921,15.818414023606231,null,"95-100",100,1]
[null,"שונות",null,null,null,null,null,{"$f":"VAR(H4:H17)","v":273.44444444444434},{"$f":"VAR(I4:I17)","v":173.36111111111131},108.75,136.31358024691224,409.61111111111109,368.27777777777737,250.22222222222223,null,"מעל 100",null,0]
[null,"שלחו תרגיל/ נבחנו",null,null,null,null,null,{"$f":"COUNT(H4:H17)","v":9},{"$f":"COUNT(I4:I17)","v":9},9,10,10,9,10]
[null,"נכשלו",null,null,null,null,null,{"$f":"COUNTIF(H4:H17,\"<\"&$C$48)","v":1},0,0,1,2,2,1,null,"הסטודנט עם הציון הגבוה ביותר"]
[null,"עברו",null,null,null,null,null,{"$f":"COUNTIFS(H4:H17,\">=\"&$C$48,H4:H17,\"<\"&$C$49)","v":4},4,4,5,1,4,6,null,{"$f":"LOOKUP(N25,N4:N17,C4:C17)","v":"יעל"}]
[null,"מצטיינים",null,null,null,null,null,{"$f":"COUNTIF(H4:H17,E49)","v":4},{"$f":"COUNTIF(I4:I17,\">=\"&$C$49)","v":5},5,4,7,3,3]
[null,"מתוכם:",{"$f":"B52","v":"סטודנטים"},null,null,null,null,{"$f":"COUNTIFS($D$4:$D$17,$C$52,H4:H17,\">=\"&$C$49)","v":3},2,3,3,3,0,1,null,"המיקום של 'ציון סופי'"]
[null,null,{"$f":"B53","v":"סטודנטיות"},null,null,null,null,{"$f":"COUNTIFS($D$4:$D$17,$C$53,H4:H17,$E$49)","v":1},3,2,1,4,3,2,null,{"$f":"MATCH(N3,B3:R3,0)","v":13}]
[null,"ס\"ה סטודנטים",null,{"$f":"COUNTA(C4:C17)","v":10},null,null,"ממוצע של מקבלי ציון \"עובר\":",{"$f":"AVERAGEIFS(H4:H17,H4:H17,\">=\"&$C$48,H4:H17,\"<\"&$C$49)","v":72},74.5,76.25,81.36666666666666,81,71.75,70.833333333333329]
[null,"מתוכם:",{"$f":"B52","v":"סטודנטים"},{"$f":"COUNTIF(D4:D17,C52)","v":4},null,null,"בממוצע:",{"$f":"AVERAGEIF($D$4:$D$17,$C52,H$4:H$17)","v":89.333333333333329},83.5,89.25,87.333333333333329,85,60,73.75,null,"שליפת מידע עם index+match"]
[null,null,{"$f":"B53","v":"סטודנטיות"},{"$f":"COUNTIF(D4:D17,C53)","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:R17,MATCH(R37,N4:N17,0),MATCH(R38,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(C39:C43)","v":1},null,null,null,null,null,null,null,null,null,null,null,"בחר מידע מבוקש",null,"ממוצע  תרגילים",{"$f":"VLOOKUP($Q$43,$B$3:$R$17,MATCH(Q44,$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$43,$B$3:$R$17,MATCH(Q45,$B$3:$R$3,0),FALSE)","v":99}]
["טבלת עזר",null,"מ-","עד",null,null,null,null,null,null,null,null,null,null,"בחר מידע מבוקש",null,"ציון בחינה",{"$f":"VLOOKUP($Q$43,$B$3:$R$17,MATCH(Q46,$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$43,$B$3:$R$17,MATCH(Q47,$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,"ת.ז.","שם הסטודנט","מגדר","טלפון","מיקוד","התמחות","ציון ת. 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$22","v":false}]
[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:N17)","v":">74"}]
[null,"טלי",81]
[null,"שחר",97]
[null,"יעל",85]
[null,"שרון",78]
[null,"יעקב",76]

{"sheet":"פתרון 2-5","index":3,"n_rows":113,"n_cols":21,"rows_kept":113,"cut":false,"hidden":false,"merged":[[0,0,0,17],[2,0,14,0],[2,19,2,22],[20,0,35,0],[20,15,20,17],[28,15,28,17],[29,15,29,17],[31,15,31,17],[32,15,32,17],[34,15,34,17],[44,0,47,0],[49,0,51,0],[49,1,49,2],[35,15,35,16],[36,15,36,16],[37,0,42,0],[37,15,37,16],[40,14,40,17],[41,14,41,15]]}
["תרגול באקסל"]
[]
["נתונים","ת.ז.","שם הסטודנט","מגדר","טלפון","מיקוד","התמחות","ציון ת. 1","ציון ת. 2","ציון ת. 3","ממוצע  תרגילים","ציון פרויקט","ציון בחינה","ציון סופי","ציון במילים","נשים מצטיינות","נשים או מצטיינים","לא נכשלו",null,"קריטריונים לסינון מתקדם"]
[null,298754355,"רמי","ז",8763456,83934,"חשבונאות",88,90,74,{"$f":"AVERAGE(H4:J4)","v":84},55,45,{"$f":"ROUND(H4*$C$38+I4*$C$39+J4*$C$40+L4*$C$41+M4*$C$42,0)","v":60},{"$f":"IF(N4<$C$47,$B$46,IF(N4<$C$48,$B$47,$B$48))","v":"עובר"},{"$f":"IF(AND(D4=$C$52,O4=$B$48),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D4=$C$52,O4=$B$48),\"מלגה\",\"\")","v":""},{"$f":"IF(NOT(N4<$C$47),\"מלגה\",\"\")","v":"מלגה"}]
[null,947465892,"שחר","ז",3434324,41466,"חשבונאות",null,79,99,{"$f":"AVERAGE(H5:J5)","v":89},86,65,{"$f":"ROUND(H5*$C$38+I5*$C$39+J5*$C$40+L5*$C$41+M5*$C$42,0)","v":70},{"$f":"IF(N5<$C$47,$B$46,IF(N5<$C$48,$B$47,$B$48))","v":"עובר"},{"$f":"IF(AND(D5=$C$52,O5=$B$48),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D5=$C$52,O5=$B$48),\"מלגה\",\"\")","v":""},{"$f":"IF(NOT(N5<$C$47),\"מלגה\",\"\")","v":"מלגה"}]
[null,987654321,"יעקב","ז",7563094,86534,"שיווק",91,79,85,{"$f":"AVERAGE(H6:J6)","v":85},100,50,{"$f":"ROUND(H6*$C$38+I6*$C$39+J6*$C$40+L6*$C$41+M6*$C$42,0)","v":76},{"$f":"IF(N6<$C$47,$B$46,IF(N6<$C$48,$B$47,$B$48))","v":"עובר"},{"$f":"IF(AND(D6=$C$52,O6=$B$48),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D6=$C$52,O6=$B$48),\"מלגה\",\"\")","v":""},{"$f":"IF(NOT(N6<$C$47),\"מלגה\",\"\")","v":"מלגה"}]
[null,123456789,"דניאל","ז",9877665,123,"שיווק",89,86,99,{"$f":"AVERAGE(H7:J7)","v":91.333333333333329},99,80,{"$f":"ROUND(H7*$C$38+I7*$C$39+J7*$C$40+L7*$C$41+M7*$C$42,0)","v":89},{"$f":"IF(N7<$C$47,$B$46,IF(N7<$C$48,$B$47,$B$48))","v":"מצטיין"},{"$f":"IF(AND(D7=$C$52,O7=$B$48),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D7=$C$52,O7=$B$48),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N7<$C$47),\"מלגה\",\"\")","v":"מלגה"}]
[null,null,null,"ז ממוצע",null,null,null,null,null,null,{"$f":"SUBTOTAL(1,K4:K7)","v":87.333333333333329},{"$f":"SUBTOTAL(1,L4:L7)","v":85},{"$f":"SUBTOTAL(1,M4:M7)","v":60},{"$f":"SUBTOTAL(1,N4:N7)","v":73.75}]
[null,{"$f":"SUBTOTAL(3,B4:B7)","v":4},null,"ז ספירה"]
[null,388923057,"מיכל","נ",8743644,44141,"חשבונאות",60,100,80,{"$f":"AVERAGE(H10:J10)","v":80},40,61,{"$f":"ROUND(H10*$C$38+I10*$C$39+J10*$C$40+L10*$C$41+M10*$C$42,0)","v":60},{"$f":"IF(N10<$C$47,$B$46,IF(N10<$C$48,$B$47,$B$48))","v":"עובר"},{"$f":"IF(AND(D10=$C$52,O10=$B$48),\"מלגה\",\"\")","v":""},{"$f":"IF(OR(D10=$C$52,O10=$B$48),\"מלגה\",\"\")","v":"מלגה"},{"$f":"IF(NOT(N10<$C$47),\"מלגה\",\"\")","v":"מלגה"}]
[null,983687692,"שרון","נ",6347234,55235,"חשבונאות",45,60,null,52.5,99,94,78,"עובר","","מלגה","מלגה"]
[null,244576280,"שחר","נ",3252524,44451,"חשבונאות",94,100,93,95.666666666666671,95,100,97,"מצטיין","מלגה","מלגה","מלגה"]
[null,830998987,"מיכל","נ",3527439,56324,"שיווק",80,null,87,83.5,90,null,44,"נכשל","","מלגה",""]
[null,193878400,"טלי","נ",9876544,70000,"שיווק",81,80,82,81,81,81,81,"עובר","","מלגה","מלגה"]
[null,658370843,"יעל","נ",2118758,55326,"שיווק",67,99,69,78.333333333333329,90,85,85,"מצטיין","מלגה","מלגה","מלגה"]
[null,null,null,"נ ממוצע",null,null,null,null,null,null,{"$f":"SUBTOTAL(1,K10:K15)","v":78.5},{"$f":"SUBTOTAL(1,L10:L15)","v":82.5},{"$f":"SUBTOTAL(1,M10:M15)","v":84.2},{"$f":"SUBTOTAL(1,N10:N15)","v":74.166666666666671}]
[null,{"$f":"SUBTOTAL(3,B10:B15)","v":6},null,"נ ספירה"]
[null,null,null,"ממוצע כולל",null,null,null,null,null,null,{"$f":"SUBTOTAL(1,K4:K15)","v":82.033333333333331},{"$f":"SUBTOTAL(1,L4:L15)","v":83.5},{"$f":"SUBTOTAL(1,M4:M15)","v":73.444444444444443},{"$f":"SUBTOTAL(1,N4:N15)","v":74}]
[null,{"$f":"SUBTOTAL(3,B4:B15)","v":10},null,"ספירה כוללת"]
[]
["חישובים","ממוצע  כיתתי ",null,null,null,null,null,{"$f":"AVERAGE(H4:H15)","v":77.222222222222229},{"$f":"AVERAGE(I4:I15)","v":85.888888888888886},85.333333333333329,82.515151515151516,83.63636363636364,72.099999999999994,73.977272727272734,null,"התפלגות ציונים סופיים"]
[null,"חציון",null,null,null,null,null,{"$f":"MEDIAN(H4:H15)","v":81},{"$f":"MEDIAN(I4:I15)","v":86},85,84,90,72.5,76,null,"0-59",59,{"$f":"FREQUENCY(N4:N15,Q22:Q27)","v":1}]
[null,"שכיח",null,null,null,null,null,{"$f":"MODE(H4:H15)","v":{"$error":"#N/A"}},{"$f":"MODE(I4:I15)","v":79},99,{"$error":"#N/A"},99,{"$error":"#N/A"},60,null,"60-74",74,4]
[null,"מקסימום",null,null,null,null,null,{"$f":"MAX(H4:H15)","v":94},{"$f":"MAX(I4:I15)","v":100},99,95.666666666666671,100,100,97,null,"75-84",84,3]
[null,"מינימום",null,null,null,null,null,{"$f":"MIN(H4:H15)","v":45},{"$f":"MIN(I4:I15)","v":60},69,52.5,40,45,44,null,"85-94",94,2]
[null,"סטיית תקן",null,null,null,null,null,{"$f":"STDEV(H4:H15)","v":16.536155673083279},{"$f":"STDEV(I4:I15)","v":13.166666666666675},10.428326807307105,11.190882833175346,19.20558630853392,18.5858369016123,15.006854494469573,null,"95-100",100,1]
[null,"שונות",null,null,null,null,null,{"$f":"VAR(H4:H15)","v":273.44444444444434},{"$f":"VAR(I4:I15)","v":173.36111111111131},108.75,125.23585858585867,368.85454545454559,345.43333333333351,225.20568181818163,null,"מעל 100",null,0]
[null,"שלחו תרגיל/ נבחנו",null,null,null,null,null,{"$f":"COUNT(H4:H15)","v":9},{"$f":"COUNT(I4:I15)","v":9},9,11,11,10,11]
[null,"נכשלו",null,null,null,null,null,{"$f":"COUNTIF(H4:H15,\"<\"&$C$47)","v":1},0,0,1,2,2,1,null,"הסטודנט עם הציון הגבוה ביותר"]
[null,"עברו",null,null,null,null,null,{"$f":"COUNTIFS(H4:H15,\">=\"&$C$47,H4:H15,\"<\"&$C$48)","v":4},4,4,5,1,5,7,null,{"$f":"LOOKUP(N24,N4:N15,C4:C15)","v":"יעל"}]
[null,"מצטיינים",null,null,null,null,null,{"$f":"COUNTIF(H4:H15,E48)","v":4},{"$f":"COUNTIF(I4:I15,\">=\"&$C$48)","v":5},5,5,8,3,3]
[null,"מתוכם:",{"$f":"B51","v":"סטודנטים"},null,null,null,null,{"$f":"COUNTIFS($D$4:$D$15,$C$51,H4:H15,\">=\"&$C$48)","v":3},2,3,3,3,0,1,null,"המיקום של 'ציון סופי'"]
[null,null,{"$f":"B52","v":"סטודנטיות"},null,null,null,null,{"$f":"COUNTIFS($D$4:$D$15,$C$52,H4:H15,$E$48)","v":1},3,2,1,4,3,2,null,{"$f":"MATCH(N3,B3:R3,0)","v":13}]
[null,"ס\"ה סטודנטים",null,{"$f":"COUNTA(C4:C15)","v":10},null,null,"ממוצע של מקבלי ציון \"עובר\":",{"$f":"AVERAGEIFS(H4:H15,H4:H15,\">=\"&$C$47,H4:H15,\"<\"&$C$48)","v":72},74.5,76.25,81.36666666666666,81,69.400000000000006,71.25]
[null,"מתוכם:",{"$f":"B51","v":"סטודנטים"},{"$f":"COUNTIF(D4:D15,C51)","v":4},null,null,"בממוצע:",{"$f":"AVERAGEIF($D$4:$D$15,$C51,H$4:H$15)","v":89.333333333333329},83.5,89.25,87.333333333333329,85,60,73.75,null,"שליפת מידע עם index+match"]
[null,null,{"$f":"B52","v":"סטודנטיות"},{"$f":"COUNTIF(D4:D15,C52)","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:R15,MATCH(R36,N4:N15,0),MATCH(R37,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(C38:C42)","v":1},null,null,null,null,null,null,null,null,null,null,null,"בחר מידע מבוקש",null,"ממוצע  תרגילים",{"$f":"VLOOKUP($Q$42,$B$3:$R$15,MATCH(Q43,$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$42,$B$3:$R$15,MATCH(Q44,$B$3:$R$3,0),FALSE)","v":99}]
["טבלת עזר",null,"מ-","עד",null,null,null,null,null,null,null,null,null,null,"בחר מידע מבוקש",null,"ציון בחינה",{"$f":"VLOOKUP($Q$42,$B$3:$R$15,MATCH(Q45,$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$42,$B$3:$R$15,MATCH(Q46,$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,"ת.ז.","שם הסטודנט","מגדר","טלפון","מיקוד","התמחות","ציון ת. 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$21","v":false}]
[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:N15)","v":">73.9772727272727"}]
[null,"טלי",81]
[null,"שחר",97]
[null,"יעל",85]
[null,"שרון",78]
[null,"יעקב",76]

{"sheet":"6-27","index":4,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,8],[35,0,35,1],[38,0,38,1]]}
["נעלי ניצן"]
["שם הפריט","סוג","עלות ללא מע\"מ","מחיר לצרכן ללא מע\"מ","כמות במלאי","ערך המלאי","התראת עודף במלאי","שיעור הנחה לצרכן","מחיר לצרכן לאחר הנחה כולל מע\"מ"]
["נייקי 920","טניס נשים",325,650,18,{"$f":"MIN(D3,C3)*E3","v":5850},{"$f":"IF(E3>=$B$40,$B$41,\"\")","v":""},{"$f":"VLOOKUP(B3,$A$24:$B$34,2,0)","v":0.25},{"$f":"D3*(1-H3)*(1+$B$37)","v":565.5}]
["ניו בלנס 605","ריצה גברים",275,550,38,{"$f":"MIN(D4,C4)*E4","v":10450},"",{"$f":"VLOOKUP(B4,$A$24:$B$34,2,0)","v":0.15},542.29999999999995]
["נייקי 815","הליכה גברים",225,450,58,13050,"מוצר מועדף",0.45,287.10000000000002]
["דיאדורה XL","טניס ילדים",175,350,78,13650,"מוצר מועדף",0.2,324.79999999999995]
["פומה 6Z","הליכה נשים",150,300,98,14700,"מוצר מועדף",0.4,208.79999999999998]
["נייקי 800","ריצה נשים",325,650,18,5850,"",0.1,678.59999999999991]
["ניו בלנס 625","ריצה גברים",275,550,38,10450,"",0.15,542.29999999999995]
["נייקי 815","הליכה גברים",225,450,58,13050,"מוצר מועדף",0.45,287.10000000000002]
["דיאדורה KL","ריצה ילדים",175,350,78,13650,"מוצר מועדף",0.05,385.7]
["פומה 13B","טניס נשים",150,300,98,14700,"מוצר מועדף",0.25,261]
["נייקי 754","ריצה נשים",325,650,18,5850,"",0.1,678.59999999999991]
["ניו בלנס 555","ריצה גברים",275,550,38,10450,"",0.15,542.29999999999995]
["נייקי 987","הליכה גברים",225,450,58,13050,"מוצר מועדף",0.45,287.10000000000002]
["דיאדורה MW","טניס ילדים",175,350,78,13650,"מוצר מועדף",0.2,324.79999999999995]
["פומה 12C","ריצה נשים",150,300,98,14700,"מוצר מועדף",0.1,313.2]
[]
["ממוצע",null,null,{"$f":"AVERAGE(D3:D17)","v":460},{"$f":"AVERAGE(E3:E17)","v":58},{"$f":"AVERAGE(F3:F17)","v":11540},null,{"$f":"AVERAGE(H3:H17)","v":0.23000000000000004},{"$f":"AVERAGE(I3:I17)","v":415.28}]
["מינימום",null,null,{"$f":"MIN(D3:D17)","v":300},{"$f":"MIN(E3:E17)","v":18},{"$f":"MIN(F3:F17)","v":5850},null,{"$f":"MIN(H3:H17)","v":0.05},{"$f":"MIN(I3:I17)","v":208.79999999999998}]
["מקסימום",null,null,{"$f":"MAX(D3:D17)","v":650},{"$f":"MAX(E3:E17)","v":98},{"$f":"MAX(F3:F17)","v":14700},null,{"$f":"MAX(H3:H17)","v":0.45},{"$f":"MAX(I3:I17)","v":678.59999999999991}]
["הכמות במלאי של פריטים מסוג:",null,null,"ריצה נשים",{"$f":"SUMIF(B3:B17,D22,E3:E17)","v":134}]
[]
["סוג מוצר","הנחה"]
["ריצה ילדים",0.05]
["ריצה נשים",0.1]
["ריצה גברים",0.15]
["טניס ילדים",0.2]
["טניס נשים",0.25]
["טניס גברים",0.3]
["הליכה ילדים",0.35]
["הליכה נשים",0.4]
["הליכה גברים",0.45]
["קרוקס",0.5]
[]
["תאי עזר"]
["מע\"מ",0.16]
[]
["התראה לעודפי מלאי:"]
["מעל כמות",40]
["תופיע ההודעה","מוצר מועדף"]

{"sheet":"פתרון 6-26","index":5,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"ערכים"]
["תוויות שורה","ס\"ה הכמות במלאי","אחוז מתוך ס\"ה הכמות במלאי","ממוצע הכמות במלאי","ס\"ה ערך המלאי","ממוצע ערך המלאי"]
["ריצה ילדים",78,8.9655172413793102E-2,78,13650,13650]
["דיאדורה KL",78,8.9655172413793102E-2,78,13650,13650]
["הליכה נשים",98,0.11264367816091954,98,14700,14700]
["פומה 6Z",98,0.11264367816091954,98,14700,14700]
["ריצה גברים",114,0.1310344827586207,38,31350,10450]
["ניו בלנס 555",38,4.3678160919540229E-2,38,10450,10450]
["ניו בלנס 605",38,4.3678160919540229E-2,38,10450,10450]
["ניו בלנס 625",38,4.3678160919540229E-2,38,10450,10450]
["טניס נשים",116,0.13333333333333333,58,20550,10275]
["נייקי 920",18,2.0689655172413793E-2,18,5850,5850]
["פומה 13B",98,0.11264367816091954,98,14700,14700]
["ריצה נשים",134,0.15402298850574714,44.666666666666664,26400,8800]
["נייקי 754",18,2.0689655172413793E-2,18,5850,5850]
["נייקי 800",18,2.0689655172413793E-2,18,5850,5850]
["פומה 12C",98,0.11264367816091954,98,14700,14700]
["טניס ילדים",156,0.1793103448275862,78,27300,13650]
["דיאדורה MW",78,8.9655172413793102E-2,78,13650,13650]
["דיאדורה XL",78,8.9655172413793102E-2,78,13650,13650]
["הליכה גברים",174,0.2,58,39150,13050]
["נייקי 815",116,0.13333333333333333,58,26100,13050]
["נייקי 987",58,6.6666666666666666E-2,58,13050,13050]
["סכום כולל",870,1,58,173100,11540]

{"sheet":"פתרון 27","index":6,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"ערכים"]
["תוויות שורה","ממוצע של עלות ללא מע\"מ","ממוצע של מחיר לצרכן ללא מע\"מ"]
["הליכה גברים",225,450]
["הליכה נשים",150,300]
["טניס ילדים",175,350]
["טניס נשים",237.5,475]
["ריצה גברים",275,550]
["ריצה ילדים",175,350]
["ריצה נשים",266.66666666666669,533.33333333333337]
["סכום כולל",230,460]

{"sheet":"28-31","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":830998987},"שם הסטודנט",{"$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":658370843},"שם הסטודנט",{"$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":2}]
[null,"סטודנטיות","נ",null,null,null,null,null,null,null,null,null,null,null,"מס' זוכי המלגות מהתמחות",null,null,"חשבונאות",{"$f":"COUNTIF($T$43:$T$44,R46)","v":0}]
[]
[]
[]
[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":"פתרון 28-31","index":8,"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":388923057},"שם הסטודנט",{"$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":658370843},"שם הסטודנט",{"$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]