{"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,"©טכנופוב מתמחים טופ"]
["אגודת ישראל","ג",null,{"$f":"IF(C2=\"\",\"\",IFERROR(VLOOKUP($A2,$T$3:$X$20,5,FALSE),$R2))","v":""},null,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":{"$error":"#DIV/0!"}},{"$f":"$O2-(P2*$G$10)","v":{"$error":"#DIV/0!"}},{"$f":"IF($P$22=0,$P2,IF($Q2>=LARGE($Q$2:$Q$21,$P$22),$P2+1,$P2))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"SUM($U3:$U4)/VLOOKUP($T3,$A$2:$R$21,18,FALSE)","v":{"$error":"#DIV/0!"}},null,null,null,3639,4,5262,-1]
["דגל התורה","דגל",null,"",null,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":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF($P$22=0,$P3,IF($Q3>=LARGE($Q$2:$Q$21,$P$22),$P3+1,$P3))","v":{"$error":"#DIV/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,3145,3,3676,-1]
["ברק צברי","ה",null,"",null,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":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/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,1198,1,1452,-1]
["אבי דיין","חי",null,"",null,"מספר מושבים:",null,15,"אבי דיין","ברק צברי",0,0,0,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/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,1444,1,1481,-1]
["הבית שלנו","טב",null,"",null,null,null,null,"שס","הבית שלנו",0,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},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,{"$f":"SUM($U7:$U8)/VLOOKUP($T7,$A$2:$R$21,18,FALSE)","v":{"$error":"#DIV/0!"}},null,null,null,1453,1,1482,-1,1]
["תושבים שווים - חלה","כן",null,"",null,null,null,null,null,null,{"$error":"#N/A"},0,0,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/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,624,0,883,-1]
["עץ בני תורה","עץ",null,"",null,null,null,null,null,null,{"$error":"#N/A"},0,0,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/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,612,0,884,-1]
["מאוחדים","צ",null,"",null,"חסימה:",{"$f":"SUM(C:C)/H5*0.75","v":0},null,null,null,null,null,0,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/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,41,0,914,-1]
["שס","שס",null,"",null,null,{"$f":"SUM(M:M)/$H$5","v":0},null,null,null,null,null,{"$f":"IF(C10<$G$9,0,C10)","v":0},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,{"$f":"SUM($U11:$U12)/VLOOKUP($T11,$A$2:$R$21,18,FALSE)","v":{"$error":"#DIV/0!"}},null,null,null,5263,5,5937,-1]
[null,null,null,"",null,null,null,null,null,null,null,null,0,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"I6","v":"שס"},{"$f":"VLOOKUP($T11,$A$2:$M$21,13,FALSE)","v":0},{"$f":"INT($U11/$V10)","v":{"$error":"#DIV/0!"}},{"$f":"U11-(V11*V10)","v":{"$error":"#DIV/0!"}},{"$f":"IF($V13=0,$V11,IF($W11=$W13,$V11+1,$V11))","v":{"$error":"#DIV/0!"}}]
[null,null,null,"",null,null,null,null,null,null,null,null,0,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"J6","v":"הבית שלנו"},{"$f":"VLOOKUP($T12,$A$2:$M$21,13,FALSE)","v":0},{"$f":"INT($U12/$V10)","v":{"$error":"#DIV/0!"}},{"$f":"U12-(V12*V10)","v":{"$error":"#DIV/0!"}},{"$f":"IF($V13=0,$V12,IF($W12=$W13,$V12+1,$V12))","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"IF(C13=\"\",\"\",IFERROR(VLOOKUP($A13,$T$3:$X$20,5,FALSE),$R13))","v":""},null,null,null,null,null,null,null,null,0,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,{"$f":"VLOOKUP($T11,$A$2:$R$21,18,FALSE)-SUM($V11:$V12)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(W11:W12)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"",null,null,null,null,null,null,null,null,0,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,{"$f":"SUM($U15:$U16)/VLOOKUP($T15,$A$2:$R$21,18,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,"",null,null,null,null,null,null,null,null,0,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/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,null,null,"",null,null,null,null,null,null,null,null,0,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/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,null,null,"",null,null,null,null,null,null,null,null,0,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/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,null,"",null,null,null,null,null,null,null,null,0,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,{"$f":"SUM($U19:$U20)/VLOOKUP($T19,$A$2:$R$21,18,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,"",null,null,null,null,null,null,null,null,0,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/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,null,null,"",null,null,null,null,null,null,null,null,0,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},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,null,null,"",null,null,null,null,null,null,null,null,0,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$H$5-SUM(P2:P21)","v":{"$error":"#DIV/0!"}},null,{"$f":"$H$5-SUM(R2:R21)","v":{"$error":"#DIV/0!"}}]