{"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":22,"n_cols":30,"rows_kept":22,"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,"©טכנופוב מתמחים טופ"]
["מצילים את ירושלים (חביליו)","כן",10155,{"$f":"IF(C2=\"\",\"\",IFERROR(VLOOKUP($A2,$T$3:$X$20,5,FALSE),$R2))","v":1},531,null,null,null,"הסכמי עודפים            ",null,null,null,{"$f":"IF(C2<$G$9,0,C2)","v":10155},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":10155},{"$f":"INT(O2/$G$10)","v":1},{"$f":"$O2-(P2*$G$10)","v":2920.322580645161},{"$f":"IF($P$22=0,$P2,IF($Q2>=LARGE($Q$2:$Q$21,$P$22),$P2+1,$P2))","v":1},null,null,null,{"$f":"SUM($U3:$U4)/VLOOKUP($T3,$A$2:$R$21,18,FALSE)","v":6777.5},null,null,null,10155,1,10685,-1]
["הליכוד","מחל",7910,1,2777,null,null,null,null,null,null,null,{"$f":"IF(C3<$G$9,0,C3)","v":7910},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$22=0,$P3,IF($Q3>=LARGE($Q$2:$Q$21,$P$22),$P3+1,$P3))","v":0},null,{"$f":"I4","v":"התעוררות"},{"$f":"VLOOKUP($T3,$A$2:$M$21,13,FALSE)","v":46310},{"$f":"INT($U3/$V2)","v":6},{"$f":"U3-(V3*V2)","v":5645},{"$f":"IF($V5=0,$V3,IF($W3=$W5,$V3+1,$V3))","v":7},null,7910,1,10686,-1]
["בדרך לפסגה","נ",2235,0,3925,null,null,null,"התעוררות","הליכוד",{"$f":"VLOOKUP($I4,$A$2:$M$21,13,FALSE)+VLOOKUP($J4,$A$2:$M$21,13,FALSE)","v":54220},0,0,null,0,{"$f":"INT(O4/$G$10)","v":0},0,0,null,{"$f":"J4","v":"הליכוד"},{"$f":"VLOOKUP($T4,$A$2:$M$21,13,FALSE)","v":7910},{"$f":"INT($U4/$V2)","v":1},{"$f":"U4-(V4*V2)","v":1132.5},{"$f":"IF($V5=0,$V4,IF($W4=$W5,$V4+1,$V4))","v":1},null,2235,0,6159,-1]
["הבית היהודי","טב",14252,{"$f":"IF(C5=\"\",\"\",IFERROR(VLOOKUP($A5,$T$3:$X$20,5,FALSE),$R5))","v":2},6023,"מספר מושבים:",null,31,"ירושלים תצליח (אלקין)","הבית היהודי",26419,0,{"$f":"IF(C5<$G$9,0,C5)","v":14252},null,{"$f":"IFERROR(VLOOKUP($A5,$I$4:$K$8,3,FALSE),IF(M5=0,0,IFERROR(VLOOKUP(A5,$J$4:$L$8,3,FALSE),$C5)))","v":0},0,0,0,null,null,null,{"$f":"VLOOKUP($T3,$A$2:$R$21,18,FALSE)-SUM($V3:$V4)","v":1},{"$f":"MAX(W3:W4)","v":5645},null,null,14252,2,20274,-1]
["אני ירושלים (אבי סלמן)","ף",862,{"$f":"IF(C6=\"\",\"\",IFERROR(VLOOKUP($A6,$T$3:$X$20,5,FALSE),$R6))","v":0},5332,null,null,null,"שס","דגל התורה (ליטאים)",75952,0,{"$f":"IF(C6<$G$9,0,C6)","v":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":6604.75},null,null,null,862,0,6193,-1]
["אריה קינג","ק",12030,{"$f":"IF(C7=\"\",\"\",IFERROR(VLOOKUP($A7,$T$3:$X$20,5,FALSE),$R7))","v":2},6625,null,null,null,"משה ליאון - מפלגה","פסגת זאב על המפה",0,0,{"$f":"IF(C7<$G$9,0,C7)","v":12030},null,{"$f":"IFERROR(VLOOKUP($A7,$I$4:$K$8,3,FALSE),IF(M7=0,0,IFERROR(VLOOKUP(A7,$J$4:$L$8,3,FALSE),$C7)))","v":0},0,0,0,null,{"$f":"I5","v":"ירושלים תצליח (אלקין)"},{"$f":"VLOOKUP($T7,$A$2:$M$21,13,FALSE)","v":12167},{"$f":"INT($U7/$V6)","v":1},{"$f":"U7-(V7*V6)","v":5562.25},{"$f":"IF($V9=0,$V7,IF($W7=$W9,$V7+1,$V7))","v":2},null,12030,2,18654,-1]
["מרצ","מרצ",10306,{"$f":"IF(C8=\"\",\"\",IFERROR(VLOOKUP($A8,$T$3:$X$20,5,FALSE),$R8))","v":1},414,null,null,null,"אגודת ישראל (חסידים)","אריה קינג",38146,0,{"$f":"IF(C8<$G$9,0,C8)","v":10306},null,{"$f":"IFERROR(VLOOKUP($A8,$I$4:$K$8,3,FALSE),IF(M8=0,0,IFERROR(VLOOKUP(A8,$J$4:$L$8,3,FALSE),$C8)))","v":10306},1,3071.322580645161,1,null,{"$f":"J5","v":"הבית היהודי"},{"$f":"VLOOKUP($T8,$A$2:$M$21,13,FALSE)","v":14252},{"$f":"INT($U8/$V6)","v":2},{"$f":"U8-(V8*V6)","v":1042.5},{"$f":"IF($V9=0,$V8,IF($W8=$W9,$V8+1,$V8))","v":2},null,10306,1,10719,-1,1]
["צעירי ירושלים","צי",2238,{"$f":"IF(C9=\"\",\"\",IFERROR(VLOOKUP($A9,$T$3:$X$20,5,FALSE),$R9))","v":0},3922,"חסימה:",{"$f":"SUM(C:C)/H5*0.75","v":6064.6693548387093},null,"אני ירושלים (אבי סלמן)","בדרך לפסגה",null,null,{"$f":"IF(C9<$G$9,0,C9)","v":0},null,{"$f":"IFERROR(VLOOKUP($A9,$I$4:$K$8,3,FALSE),IF(M9=0,0,IFERROR(VLOOKUP(A9,$J$4:$L$8,3,FALSE),$C9)))","v":0},0,0,0,null,null,null,{"$f":"VLOOKUP($T7,$A$2:$R$21,18,FALSE)-SUM($V7:$V8)","v":1},{"$f":"MAX(W7:W8)","v":5562.25},null,null,2238,0,6159,-1]
["ירושלים עירי (ערבים)","י",2999,{"$f":"IF(C10=\"\",\"\",IFERROR(VLOOKUP($A10,$T$3:$X$20,5,FALSE),$R10))","v":0},3142,null,{"$f":"SUM(M:M)/$H$5","v":7234.677419354839},null,null,null,null,null,{"$f":"IF(C10<$G$9,0,C10)","v":0},null,{"$f":"IFERROR(VLOOKUP($A10,$I$4:$K$8,3,FALSE),IF(M10=0,0,IFERROR(VLOOKUP(A10,$J$4:$L$8,3,FALSE),$C10)))","v":0},0,0,0,null,null,null,{"$f":"SUM($U11:$U12)/VLOOKUP($T11,$A$2:$R$21,18,FALSE)","v":6904.727272727273},null,null,null,2999,0,6140,-1]
["למען השכונות","זך",628,{"$f":"IF(C11=\"\",\"\",IFERROR(VLOOKUP($A11,$T$3:$X$20,5,FALSE),$R11))","v":0},5572,null,null,null,null,null,null,null,{"$f":"IF(C11<$G$9,0,C11)","v":0},null,{"$f":"IFERROR(VLOOKUP($A11,$I$4:$K$8,3,FALSE),IF(M11=0,0,IFERROR(VLOOKUP(A11,$J$4:$L$8,3,FALSE),$C11)))","v":0},0,0,0,null,{"$f":"I6","v":"שס"},{"$f":"VLOOKUP($T11,$A$2:$M$21,13,FALSE)","v":34412},{"$f":"INT($U11/$V10)","v":4},{"$f":"U11-(V11*V10)","v":6793.0909090909081},{"$f":"IF($V13=0,$V11,IF($W11=$W13,$V11+1,$V11))","v":5},null,628,0,6199,-1]
["ירושלים תצליח (אלקין)","א",12167,{"$f":"IF(C12=\"\",\"\",IFERROR(VLOOKUP($A12,$T$3:$X$20,5,FALSE),$R12))","v":2},6023,null,null,null,null,null,null,null,{"$f":"IF(C12<$G$9,0,C12)","v":12167},null,{"$f":"IFERROR(VLOOKUP($A12,$I$4:$K$8,3,FALSE),IF(M12=0,0,IFERROR(VLOOKUP(A12,$J$4:$L$8,3,FALSE),$C12)))","v":26419},3,4714.9677419354848,4,null,{"$f":"J6","v":"דגל התורה (ליטאים)"},{"$f":"VLOOKUP($T12,$A$2:$M$21,13,FALSE)","v":41540},{"$f":"INT($U12/$V10)","v":6},{"$f":"U12-(V12*V10)","v":111.63636363636033},{"$f":"IF($V13=0,$V12,IF($W12=$W13,$V12+1,$V12))","v":6},null,12167,2,18189,-1]
["משה ליאון - מפלגה","יד",5500,{"$f":"IF(C13=\"\",\"\",IFERROR(VLOOKUP($A13,$T$3:$X$20,5,FALSE),$R13))","v":0},579,null,null,null,null,null,null,null,{"$f":"IF(C13<$G$9,0,C13)","v":0},null,{"$f":"IFERROR(VLOOKUP($A13,$I$4:$K$8,3,FALSE),IF(M13=0,0,IFERROR(VLOOKUP(A13,$J$4:$L$8,3,FALSE),$C13)))","v":0},0,0,0,null,null,null,{"$f":"VLOOKUP($T11,$A$2:$R$21,18,FALSE)-SUM($V11:$V12)","v":1},{"$f":"MAX(W11:W12)","v":6793.0909090909081},null,null,5500,0,6078,-1]
["ירושלים ביתנו (של ליברמן)","ל",3282,{"$f":"IF(C14=\"\",\"\",IFERROR(VLOOKUP($A14,$T$3:$X$20,5,FALSE),$R14))","v":0},2852,null,null,null,null,null,null,null,{"$f":"IF(C14<$G$9,0,C14)","v":0},null,{"$f":"IFERROR(VLOOKUP($A14,$I$4:$K$8,3,FALSE),IF(M14=0,0,IFERROR(VLOOKUP(A14,$J$4:$L$8,3,FALSE),$C14)))","v":0},0,0,0,null,null,null,{"$f":"SUM($U15:$U16)/VLOOKUP($T15,$A$2:$R$21,18,FALSE)","v":{"$error":"#DIV/0!"}},null,null,null,3282,0,6133,-1]
["מעורב ירושלמי","נץ",1096,{"$f":"IF(C15=\"\",\"\",IFERROR(VLOOKUP($A15,$T$3:$X$20,5,FALSE),$R15))","v":0},5092,null,null,null,null,null,null,null,{"$f":"IF(C15<$G$9,0,C15)","v":0},null,{"$f":"IFERROR(VLOOKUP($A15,$I$4:$K$8,3,FALSE),IF(M15=0,0,IFERROR(VLOOKUP(A15,$J$4:$L$8,3,FALSE),$C15)))","v":0},0,0,0,null,{"$f":"I7","v":"משה ליאון - מפלגה"},{"$f":"VLOOKUP($T15,$A$2:$M$21,13,FALSE)","v":0},{"$f":"INT($U15/$V14)","v":{"$error":"#DIV/0!"}},{"$f":"U15-(V15*V14)","v":{"$error":"#DIV/0!"}},{"$f":"IF($V17=0,$V15,IF($W15=$W17,$V15+1,$V15))","v":{"$error":"#DIV/0!"}},null,1096,0,6187,-1]
["שס","שס",34412,{"$f":"IF(C16=\"\",\"\",IFERROR(VLOOKUP($A16,$T$3:$X$20,5,FALSE),$R16))","v":5},7128,null,null,null,null,null,null,null,{"$f":"IF(C16<$G$9,0,C16)","v":34412},null,{"$f":"IFERROR(VLOOKUP($A16,$I$4:$K$8,3,FALSE),IF(M16=0,0,IFERROR(VLOOKUP(A16,$J$4:$L$8,3,FALSE),$C16)))","v":75952},10,3605.2258064516063,11,null,{"$f":"J7","v":"פסגת זאב על המפה"},{"$f":"VLOOKUP($T16,$A$2:$M$21,13,FALSE)","v":0},{"$f":"INT($U16/$V14)","v":{"$error":"#DIV/0!"}},{"$f":"U16-(V16*V14)","v":{"$error":"#DIV/0!"}},{"$f":"IF($V17=0,$V16,IF($W16=$W17,$V16+1,$V16))","v":{"$error":"#DIV/0!"}},null,34412,5,41539,-1]
["עץ (הפלג)","עץ",9077,{"$f":"IF(C17=\"\",\"\",IFERROR(VLOOKUP($A17,$T$3:$X$20,5,FALSE),$R17))","v":1},1367,null,null,null,null,null,null,null,{"$f":"IF(C17<$G$9,0,C17)","v":9077},null,{"$f":"IFERROR(VLOOKUP($A17,$I$4:$K$8,3,FALSE),IF(M17=0,0,IFERROR(VLOOKUP(A17,$J$4:$L$8,3,FALSE),$C17)))","v":9077},1,1842.322580645161,1,null,null,null,{"$f":"VLOOKUP($T15,$A$2:$R$21,18,FALSE)-SUM($V15:$V16)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(W15:W16)","v":{"$error":"#DIV/0!"}},null,null,9077,1,10443,-1]
["התעוררות","הת",46310,{"$f":"IF(C18=\"\",\"\",IFERROR(VLOOKUP($A18,$T$3:$X$20,5,FALSE),$R18))","v":7},8692,null,null,null,null,null,null,null,{"$f":"IF(C18<$G$9,0,C18)","v":46310},null,{"$f":"IFERROR(VLOOKUP($A18,$I$4:$K$8,3,FALSE),IF(M18=0,0,IFERROR(VLOOKUP(A18,$J$4:$L$8,3,FALSE),$C18)))","v":54220},7,3577.2580645161288,8,null,null,null,{"$f":"SUM($U19:$U20)/VLOOKUP($T19,$A$2:$R$21,18,FALSE)","v":7629.2},null,null,null,46310,7,55001,-1]
["דגל התורה (ליטאים)","דת",41540,{"$f":"IF(C19=\"\",\"\",IFERROR(VLOOKUP($A19,$T$3:$X$20,5,FALSE),$R19))","v":6},8167,null,null,null,null,null,null,null,{"$f":"IF(C19<$G$9,0,C19)","v":41540},null,{"$f":"IFERROR(VLOOKUP($A19,$I$4:$K$8,3,FALSE),IF(M19=0,0,IFERROR(VLOOKUP(A19,$J$4:$L$8,3,FALSE),$C19)))","v":0},0,0,0,null,{"$f":"I8","v":"אגודת ישראל (חסידים)"},{"$f":"VLOOKUP($T19,$A$2:$M$21,13,FALSE)","v":26116},{"$f":"INT($U19/$V18)","v":3},{"$f":"U19-(V19*V18)","v":3228.4000000000015},{"$f":"IF($V21=0,$V19,IF($W19=$W21,$V19+1,$V19))","v":3},null,41540,6,49706,-1]
["פסגת זאב על המפה","פז",5514,{"$f":"IF(C20=\"\",\"\",IFERROR(VLOOKUP($A20,$T$3:$X$20,5,FALSE),$R20))","v":0},565,null,null,null,null,null,null,null,{"$f":"IF(C20<$G$9,0,C20)","v":0},null,{"$f":"IFERROR(VLOOKUP($A20,$I$4:$K$8,3,FALSE),IF(M20=0,0,IFERROR(VLOOKUP(A20,$J$4:$L$8,3,FALSE),$C20)))","v":0},0,0,0,null,{"$f":"J8","v":"אריה קינג"},{"$f":"VLOOKUP($T20,$A$2:$M$21,13,FALSE)","v":12030},{"$f":"INT($U20/$V18)","v":1},{"$f":"U20-(V20*V18)","v":4400.8},{"$f":"IF($V21=0,$V20,IF($W20=$W21,$V20+1,$V20))","v":2},null,5514,0,6078,-1]
["אגודת ישראל (חסידים)","ג",26116,{"$f":"IF(C21=\"\",\"\",IFERROR(VLOOKUP($A21,$T$3:$X$20,5,FALSE),$R21))","v":3},1406,null,null,null,null,null,null,null,{"$f":"IF(C21<$G$9,0,C21)","v":26116},null,{"$f":"IFERROR(VLOOKUP($A21,$I$4:$K$8,3,FALSE),IF(M21=0,0,IFERROR(VLOOKUP(A21,$J$4:$L$8,3,FALSE),$C21)))","v":38146},5,1972.6129032258032,5,null,null,null,{"$f":"VLOOKUP($T19,$A$2:$R$21,18,FALSE)-SUM($V19:$V20)","v":1},{"$f":"MAX(W19:W20)","v":4400.8},null,null,26116,3,27521,-1]
["עם","עם",2044,{"$f":"IF(C22=\"\",\"\",IFERROR(VLOOKUP($A22,$T$3:$X$20,5,FALSE),$R22))","v":0},262144,null,null,null,null,null,null,null,null,null,null,{"$f":"$H$5-SUM(P2:P21)","v":3},null,{"$f":"$H$5-SUM(R2:R21)","v":0},null,null,null,null,null,null,null,2044,0,264187,-1]