{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["גיליון1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":41,"n_cols":30,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,8,2,9],[4,5,5,6],[4,7,5,7],[0,6,0,7]]}
["שם מפלגה","סמל\nמפלגה","מספר\nמצביעים","מספר\nמנדטים","הקולות החסרים\nלמנדט",null,"©טכנופוב מתמחים טופ"]
["רמת גן שלנו","א",100,{"$f":"IF(C2=\"\",\"\",IFERROR(VLOOKUP($A2,$T$3:$X$20,5,FALSE),$R2))","v":0},1832,null,null,null,"הסכמי עודפים            ",null,null,null,{"$f":"IF(C2<$G$9,0,C2)","v":0},null,{"$f":"IFERROR(VLOOKUP($A2,$I$4:$K$8,3,FALSE),IF(M2=0,0,IFERROR(VLOOKUP(A2,$J$4:$L$8,3,FALSE),$C2)))","v":0},{"$f":"INT(O2/$G$10)","v":0},{"$f":"$O2-(P2*$G$10)","v":0},{"$f":"IF($P$41=0,$P2,IF($Q2>=LARGE($Q$2:$Q$40,$P$41),$P2+1,$P2))","v":0},null,null,null,{"$f":"SUM($U3:$U4)/VLOOKUP($T3,$A$2:$R$21,18,FALSE)","v":{"$error":"#DIV/0!"}},null,null,null,100,0,1931,-1]
["רמת גן אחת","רג",200,0,1729,null,null,null,null,null,null,null,{"$f":"IF(C3<$G$9,0,C3)","v":0},null,{"$f":"IFERROR(VLOOKUP($A3,$I$4:$K$8,3,FALSE),IF(M3=0,0,IFERROR(VLOOKUP(A3,$J$4:$L$8,3,FALSE),$C3)))","v":0},{"$f":"INT(O3/$G$10)","v":0},0,{"$f":"IF($P$41=0,$P3,IF($Q3>=LARGE($Q$2:$Q$40,$P$41),$P3+1,$P3))","v":0},null,{"$f":"I4","v":"הרמתגנים עם אביהוא"},{"$f":"VLOOKUP($T3,$A$2:$M$21,13,FALSE)","v":0},{"$f":"INT($U3/$V2)","v":{"$error":"#DIV/0!"}},{"$f":"U3-(V3*V2)","v":{"$error":"#DIV/0!"}},{"$f":"IF($V5=0,$V3,IF($W3=$W5,$V3+1,$V3))","v":{"$error":"#DIV/0!"}},null,200,0,1928,-1]
["זינגר לרמת גן","יז",300,0,1627,null,null,null,"הרמתגנים עם אביהוא","רמת גן שלנו",{"$f":"VLOOKUP($I4,$A$2:$M$21,13,FALSE)+VLOOKUP($J4,$A$2:$M$21,13,FALSE)","v":0},0,0,null,0,{"$f":"INT(O4/$G$10)","v":0},0,{"$f":"IF($P$41=0,$P4,IF($Q4>=LARGE($Q$2:$Q$40,$P$41),$P4+1,$P4))","v":0},null,{"$f":"J4","v":"רמת גן שלנו"},{"$f":"VLOOKUP($T4,$A$2:$M$21,13,FALSE)","v":0},{"$f":"INT($U4/$V2)","v":{"$error":"#DIV/0!"}},{"$f":"U4-(V4*V2)","v":{"$error":"#DIV/0!"}},{"$f":"IF($V5=0,$V4,IF($W4=$W5,$V4+1,$V4))","v":{"$error":"#DIV/0!"}},null,300,0,1926,-1]
["הרמתגנים עם אביהוא","אב",400,0,1524,"מספר מושבים:",null,31,"מרצ","יש עתיד",0,0,0,null,0,0,0,0,null,null,null,{"$f":"VLOOKUP($T3,$A$2:$R$21,18,FALSE)-SUM($V3:$V4)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(W3:W4)","v":{"$error":"#DIV/0!"}},null,null,400,0,1923,-1]
["יש עתיד","פה",500,0,1422,null,null,null,null,null,{"$error":"#N/A"},0,0,null,{"$f":"IFERROR(VLOOKUP($A6,$I$4:$K$8,3,FALSE),IF(M6=0,0,IFERROR(VLOOKUP(A6,$J$4:$L$8,3,FALSE),$C6)))","v":0},0,0,0,null,null,null,{"$f":"SUM($U7:$U8)/VLOOKUP($T7,$A$2:$R$21,18,FALSE)","v":{"$error":"#DIV/0!"}},null,null,null,500,0,1921,-1]
["הליכוד","מחל",600,0,1320,null,null,null,null,null,{"$error":"#N/A"},0,0,null,0,0,0,0,null,{"$f":"I5","v":"מרצ"},{"$f":"VLOOKUP($T7,$A$2:$M$21,13,FALSE)","v":0},{"$f":"INT($U7/$V6)","v":{"$error":"#DIV/0!"}},{"$f":"U7-(V7*V6)","v":{"$error":"#DIV/0!"}},{"$f":"IF($V9=0,$V7,IF($W7=$W9,$V7+1,$V7))","v":{"$error":"#DIV/0!"}},null,600,0,1919,-1]
["מרצ","מרצ",700,0,1217,null,null,null,null,null,{"$error":"#N/A"},0,0,null,0,0,0,0,null,{"$f":"J5","v":"יש עתיד"},{"$f":"VLOOKUP($T8,$A$2:$M$21,13,FALSE)","v":0},{"$f":"INT($U8/$V6)","v":{"$error":"#DIV/0!"}},{"$f":"U8-(V8*V6)","v":{"$error":"#DIV/0!"}},{"$f":"IF($V9=0,$V8,IF($W8=$W9,$V8+1,$V8))","v":{"$error":"#DIV/0!"}},null,700,0,1916,-1]
["רשימת הצעירים","צע",800,0,1115,"חסימה:",{"$f":"SUM(C:C)/H5*0.75","v":1887.0967741935483},null,null,null,null,null,0,null,0,0,0,0,null,null,null,{"$f":"VLOOKUP($T7,$A$2:$R$21,18,FALSE)-SUM($V7:$V8)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(W7:W8)","v":{"$error":"#DIV/0!"}},null,null,800,0,1914,-1]
["פ","ל",900,0,1012,null,{"$f":"SUM(M:M)/$H$5","v":1964.516129032258},null,null,null,null,null,{"$f":"IF(C10<$G$9,0,C10)","v":0},null,0,0,0,0,null,null,null,{"$f":"SUM($U11:$U12)/VLOOKUP($T11,$A$2:$R$21,18,FALSE)","v":{"$error":"#N/A"}},null,null,null,900,0,1911,-1]
["ם","עכ",1000,0,910,null,null,null,null,null,null,null,0,null,0,0,0,0,null,{"$f":"I6","v":0},{"$f":"VLOOKUP($T11,$A$2:$M$21,13,FALSE)","v":{"$error":"#N/A"}},{"$f":"INT($U11/$V10)","v":{"$error":"#N/A"}},{"$f":"U11-(V11*V10)","v":{"$error":"#N/A"}},{"$f":"IF($V13=0,$V11,IF($W11=$W13,$V11+1,$V11))","v":{"$error":"#N/A"}},null,1000,0,1909,-1]
["ן","נ",1100,0,807,null,null,null,null,null,null,null,0,null,0,0,0,0,null,{"$f":"J6","v":0},{"$f":"VLOOKUP($T12,$A$2:$M$21,13,FALSE)","v":{"$error":"#N/A"}},{"$f":"INT($U12/$V10)","v":{"$error":"#N/A"}},{"$f":"U12-(V12*V10)","v":{"$error":"#N/A"}},{"$f":"IF($V13=0,$V12,IF($W12=$W13,$V12+1,$V12))","v":{"$error":"#N/A"}},null,1100,0,1906,-1]
["נ","ג",1200,{"$f":"IF(C13=\"\",\"\",IFERROR(VLOOKUP($A13,$T$3:$X$20,5,FALSE),$R13))","v":0},705,null,null,null,null,null,null,null,0,null,0,0,0,0,null,null,null,{"$f":"VLOOKUP($T11,$A$2:$R$21,18,FALSE)-SUM($V11:$V12)","v":{"$error":"#N/A"}},{"$f":"MAX(W11:W12)","v":{"$error":"#N/A"}},null,null,1200,0,1904,-1]
["ו","ד",1300,0,602,null,null,null,null,null,null,null,0,null,0,0,0,0,null,null,null,{"$f":"SUM($U15:$U16)/VLOOKUP($T15,$A$2:$R$21,18,FALSE)","v":{"$error":"#N/A"}},null,null,null,1300,0,1901,-1]
["ט","ה",1400,0,500,null,null,null,null,null,null,null,0,null,0,0,0,0,null,{"$f":"I7","v":0},{"$f":"VLOOKUP($T15,$A$2:$M$21,13,FALSE)","v":{"$error":"#N/A"}},{"$f":"INT($U15/$V14)","v":{"$error":"#N/A"}},{"$f":"U15-(V15*V14)","v":{"$error":"#N/A"}},{"$f":"IF($V17=0,$V15,IF($W15=$W17,$V15+1,$V15))","v":{"$error":"#N/A"}},null,1400,0,1899,-1]
["א","בב",1500,0,397,null,null,null,null,null,null,null,0,null,0,0,0,0,null,{"$f":"J7","v":0},{"$f":"VLOOKUP($T16,$A$2:$M$21,13,FALSE)","v":{"$error":"#N/A"}},{"$f":"INT($U16/$V14)","v":{"$error":"#N/A"}},{"$f":"U16-(V16*V14)","v":{"$error":"#N/A"}},{"$f":"IF($V17=0,$V16,IF($W16=$W17,$V16+1,$V16))","v":{"$error":"#N/A"}},null,1500,0,1896,-1]
["ר","סמל\nמפלגה",1600,0,295,null,null,null,null,null,null,null,0,null,0,0,0,0,null,null,null,{"$f":"VLOOKUP($T15,$A$2:$R$21,18,FALSE)-SUM($V15:$V16)","v":{"$error":"#N/A"}},{"$f":"MAX(W15:W16)","v":{"$error":"#N/A"}},null,null,1600,0,1894,-1]
["ק","ז",1700,0,192,null,null,null,null,null,null,null,0,null,0,0,0,0,null,null,null,{"$f":"SUM($U19:$U20)/VLOOKUP($T19,$A$2:$R$21,18,FALSE)","v":{"$error":"#N/A"}},null,null,null,1700,0,1891,-1]
["ף","פה",1800,0,90,null,null,null,null,null,null,null,0,null,0,0,0,0,null,{"$f":"I8","v":0},{"$f":"VLOOKUP($T19,$A$2:$M$21,13,FALSE)","v":{"$error":"#N/A"}},{"$f":"INT($U19/$V18)","v":{"$error":"#N/A"}},{"$f":"U19-(V19*V18)","v":{"$error":"#N/A"}},{"$f":"IF($V21=0,$V19,IF($W19=$W21,$V19+1,$V19))","v":{"$error":"#N/A"}},null,1800,0,1889,-1,1]
["ך","פה",1900,1,1100,null,null,null,null,null,null,null,1900,null,1900,0,1900,1,null,{"$f":"J8","v":0},{"$f":"VLOOKUP($T20,$A$2:$M$21,13,FALSE)","v":{"$error":"#N/A"}},{"$f":"INT($U20/$V18)","v":{"$error":"#N/A"}},{"$f":"U20-(V20*V18)","v":{"$error":"#N/A"}},{"$f":"IF($V21=0,$V20,IF($W20=$W21,$V20+1,$V20))","v":{"$error":"#N/A"}},null,1900,1,2999,-1]
["ל","ף",2000,1,900,null,null,null,null,null,null,null,{"$f":"IF(C21<$G$9,0,C21)","v":2000},null,2000,1,35.48387096774195,1,null,null,null,{"$f":"VLOOKUP($T19,$A$2:$R$21,18,FALSE)-SUM($V19:$V20)","v":{"$error":"#N/A"}},{"$f":"MAX(W19:W20)","v":{"$error":"#N/A"}},null,null,2000,1,2899,-1]
["ח","ך",2100,1,800,null,null,null,null,null,null,null,{"$f":"IF(C22<$G$9,0,C22)","v":2100},null,2100,{"$f":"INT(O22/$G$10)","v":1},135.48387096774195,1,null,null,null,null,null,null,null,2100,1,2899,-1]
["ע","ל",2200,1,700,null,null,null,null,null,null,null,{"$f":"IF(C23<$G$9,0,C23)","v":2200},null,2200,{"$f":"INT(O23/$G$10)","v":1},235.48387096774195,1,null,null,null,null,null,null,null,2200,1,2899,-1]
[null,null,2300,1,600,null,null,null,null,null,null,null,{"$f":"IF(C24<$G$9,0,C24)","v":2300},null,{"$f":"IFERROR(VLOOKUP($A24,$I$4:$K$8,3,FALSE),IF(M24=0,0,IFERROR(VLOOKUP(A24,$J$4:$L$8,3,FALSE),$C24)))","v":2300},{"$f":"INT(O24/$G$10)","v":1},335.48387096774195,1,null,null,null,null,null,null,null,2300,1,2899,-1]
[null,null,2400,1,534,null,null,null,null,null,null,null,{"$f":"IF(C25<$G$9,0,C25)","v":2400},null,2400,1,435.48387096774195,1,null,null,null,null,null,null,null,2400,1,2933,-1]
[null,null,2500,1,500,null,null,null,null,null,null,null,2500,null,2500,1,535.48387096774195,1,null,null,null,null,null,null,null,2500,1,2999,-1]
[null,null,2600,1,400,null,null,null,null,null,null,null,2600,null,2600,1,635.48387096774195,1,null,null,null,null,null,null,null,2600,1,2999,-1]
[null,null,2700,1,300,null,null,null,null,null,null,null,2700,null,{"$f":"IFERROR(VLOOKUP($A28,$I$4:$K$8,3,FALSE),IF(M28=0,0,IFERROR(VLOOKUP(A28,$J$4:$L$8,3,FALSE),$C28)))","v":2700},1,735.48387096774195,1,null,null,null,null,null,null,null,2700,1,2999,-1]
[null,null,2800,1,200,null,null,null,null,null,null,null,2800,null,2800,1,835.48387096774195,1,null,null,null,null,null,null,null,2800,1,2999,-1]
[null,null,2900,1,100,null,null,null,null,null,null,null,2900,null,2900,1,935.48387096774195,1,null,null,null,null,null,null,null,2900,1,2999,-1]
[null,null,3000,2,1864,null,null,null,null,null,null,null,3000,null,3000,1,1035.483870967742,2,null,null,null,null,null,null,null,3000,2,4863,-1]
[null,null,3100,2,1760,null,null,null,null,null,null,null,{"$f":"IF(C32<$G$9,0,C32)","v":3100},null,3100,1,1135.483870967742,2,null,null,null,null,null,null,null,3100,2,4859,-1]
[null,null,3200,2,1657,null,null,null,null,null,null,null,3200,null,3200,1,1235.483870967742,2,null,null,null,null,null,null,null,3200,2,4856,-1]
[null,null,3300,{"$f":"IF(C34=\"\",\"\",IFERROR(VLOOKUP($A34,$T$3:$X$20,5,FALSE),$R34))","v":2},1554,null,null,null,null,null,null,null,3300,null,3300,1,1335.483870967742,2,null,null,null,null,null,null,null,3300,2,4853,-1]
[null,null,3400,2,1450,null,null,null,null,null,null,null,3400,null,3400,1,1435.483870967742,2,null,null,null,null,null,null,null,3400,2,4849,-1]
[null,null,3500,2,1347,null,null,null,null,null,null,null,3500,null,3500,1,1535.483870967742,2,null,null,null,null,null,null,null,3500,2,4846,-1]
[null,null,3600,2,1244,null,null,null,null,null,null,null,3600,null,3600,1,1635.483870967742,2,null,null,null,null,null,null,null,3600,2,4843,-1]
[null,null,3700,2,1140,null,null,null,null,null,null,null,3700,null,3700,1,1735.483870967742,2,null,null,null,null,null,null,null,3700,2,4839,-1]
[null,null,3800,2,1037,null,null,null,null,null,null,null,3800,null,3800,1,1835.483870967742,2,null,null,null,null,null,null,null,3800,2,4836,-1]
[null,null,3900,2,934,null,null,null,null,null,null,null,3900,null,3900,1,1935.483870967742,2,null,null,null,null,null,null,null,3900,2,4833,-1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$H$5-SUM(P2:P40)","v":11},null,{"$f":"$H$5-SUM(R2:R40)","v":0}]