{"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,"©טכנופוב מתמחים טופ"]
["רמת גן שלנו","א",478,{"$f":"IF(C2=\"\",\"\",IFERROR(VLOOKUP($A2,$T$3:$X$20,5,FALSE),$R2))","v":1},194,null,null,null,"הסכמי עודפים            ",null,null,null,{"$f":"IF(C2<$G$9,0,C2)","v":478},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$22=0,$P2,IF($Q2>=LARGE($Q$2:$Q$21,$P$22),$P2+1,$P2))","v":0},null,null,null,{"$f":"SUM($U3:$U4)/VLOOKUP($T3,$A$2:$R$21,18,FALSE)","v":399.25},null,null,null,478,1,671,-1]
["רמת גן אחת","רג",685,2,445,null,null,null,null,null,null,null,{"$f":"IF(C3<$G$9,0,C3)","v":685},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":685},{"$f":"INT(O3/$G$10)","v":1},243.09090909090907,{"$f":"IF($P$22=0,$P3,IF($Q3>=LARGE($Q$2:$Q$21,$P$22),$P3+1,$P3))","v":2},null,{"$f":"I4","v":"הרמתגנים עם אביהוא"},{"$f":"VLOOKUP($T3,$A$2:$M$21,13,FALSE)","v":1119},{"$f":"INT($U3/$V2)","v":2},{"$f":"U3-(V3*V2)","v":320.5},{"$f":"IF($V5=0,$V3,IF($W3=$W5,$V3+1,$V3))","v":3},null,685,2,1129,-1]
["זינגר לרמת גן","יז",353,0,25,null,null,null,"הרמתגנים עם אביהוא","רמת גן שלנו",{"$f":"VLOOKUP($I4,$A$2:$M$21,13,FALSE)+VLOOKUP($J4,$A$2:$M$21,13,FALSE)","v":1597},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":478},{"$f":"INT($U4/$V2)","v":1},{"$f":"U4-(V4*V2)","v":78.75},{"$f":"IF($V5=0,$V4,IF($W4=$W5,$V4+1,$V4))","v":1},null,353,0,377,-1]
["הרמתגנים עם אביהוא","אב",1119,3,569,"מספר מושבים:",null,11,"מרצ","יש עתיד",647,0,1119,null,1597,3,271.27272727272725,4,null,null,null,{"$f":"VLOOKUP($T3,$A$2:$R$21,18,FALSE)-SUM($V3:$V4)","v":1},{"$f":"MAX(W3:W4)","v":320.5},null,null,1119,3,1687,-1]
["יש עתיד","פה",294,0,88,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":647},null,null,null,294,0,381,-1]
["הליכוד","מחל",814,2,313,null,null,null,null,null,{"$error":"#N/A"},0,814,null,814,1,372.09090909090907,2,null,{"$f":"I5","v":"מרצ"},{"$f":"VLOOKUP($T7,$A$2:$M$21,13,FALSE)","v":647},{"$f":"INT($U7/$V6)","v":1},{"$f":"U7-(V7*V6)","v":0},{"$f":"IF($V9=0,$V7,IF($W7=$W9,$V7+1,$V7))","v":1},null,814,2,1126,-1]
["מרצ","מרצ",647,1,38,null,null,null,null,null,{"$error":"#N/A"},0,647,null,647,1,205.09090909090907,1,null,{"$f":"J5","v":"יש עתיד"},{"$f":"VLOOKUP($T8,$A$2:$M$21,13,FALSE)","v":0},{"$f":"INT($U8/$V6)","v":0},{"$f":"U8-(V8*V6)","v":0},{"$f":"IF($V9=0,$V8,IF($W8=$W9,$V8+1,$V8))","v":0},null,647,1,684,-1]
["רשימת הצעירים","צע",1118,2,10,"חסימה:",{"$f":"SUM(C:C)/H5*0.75","v":375.54545454545456},null,null,null,null,null,1118,null,1118,2,234.18181818181813,2,null,null,null,{"$f":"VLOOKUP($T7,$A$2:$R$21,18,FALSE)-SUM($V7:$V8)","v":0},{"$f":"MAX(W7:W8)","v":0},null,null,1118,2,1127,-1,1]
[null,null,null,"",null,null,{"$f":"SUM(M:M)/$H$5","v":441.90909090909093},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,"",null,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,null,null,"",null,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,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,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,null,"",null,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,"",null,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,null,null,"",null,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,null,null,"",null,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,null,"",null,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,"",null,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,null,null,"",null,null,null,null,null,null,null,null,0,null,0,0,0,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,0,0,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":3},null,{"$f":"$H$5-SUM(R2:R21)","v":0}]