{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Blad1"],"not_rendered":{"charts":0,"images":2,"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":"Blad1","index":0,"n_rows":80,"n_cols":21,"rows_kept":80,"cut":false,"hidden":false,"merged":[[7,2,7,11],[7,12,7,17],[3,2,3,20]]}
[null,null,null,null,null,null,null,null,"ZIE VOORBEELD ONDERAAN"]
[]
[]
[null,null,"LOTTO - DE VRIENDEN VAN WALTER"]
[]
[null,"MANUEEL",null,null,null,"MANUELE INVULLING",null,null,null,null,null,null,null,null,"MANUELE INVULLING",null,null,null,"MANUEEL",null,"MANUEEL"]
[]
[null,"NAAM","VUL HIER UW GETALLEN IN VAN 1 TOT EN MET 45",null,null,null,null,null,null,null,null,null,"TREKKING NUMMERS (6)",null,null,null,null,null,"DATUM","AANTAL","POT"]
[]
[null,"Walter Van Eester",1,2,3,4,5,6,7,8,9,45,1,3,5,7,9,44,"2026-07-15",{"$f":"IF(C10<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C10:L10)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C10:L10)<>0),))),\"\")","v":"JACKPOT"}]
[null,"iemand",3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,45,null,{"$f":"IF(C11<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C11:L11)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C11:L11)<>0),))),\"\")","v":"JACKPOT"}]
[null,"anders",12,11,14,13,15,16,17,18,19,20,6,8,10,11,12,null,null,{"$f":"IF(C12<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C12:L12)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C12:L12)<>0),))),\"\")","v":8}]
[null,null,1,3,5,7,9,44,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C13<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C13:L13)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C13:L13)<>0),))),\"\")","v":3}]
[null,null,1,2,3,4,5,6,7,8,null,null,null,null,null,null,null,null,null,{"$f":"IF(C14<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C14:L14)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C14:L14)<>0),))),\"\")","v":2}]
[null,null,1,2,3,4,5,6,7,8,9,36,null,null,null,null,null,null,null,{"$f":"IF(C15<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C15:L15)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C15:L15)<>0),))),\"\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C16<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C16:L16)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C16:L16)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C17<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C17:L17)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C17:L17)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C18<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C18:L18)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C18:L18)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C19<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C19:L19)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C19:L19)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C20<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C20:L20)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C20:L20)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C21<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C21:L21)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C21:L21)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C22<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C22:L22)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C22:L22)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C23<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C23:L23)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C23:L23)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C24<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C24:L24)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C24:L24)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C25<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C25:L25)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C25:L25)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C26<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C26:L26)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C26:L26)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C27<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C27:L27)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C27:L27)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C28<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C28:L28)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C28:L28)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C29<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C29:L29)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C29:L29)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C30<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C30:L30)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C30:L30)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C31<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C31:L31)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C31:L31)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C32<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C32:L32)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C32:L32)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C33<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C33:L33)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C33:L33)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C34<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C34:L34)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C34:L34)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C35<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C35:L35)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C35:L35)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C36<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C36:L36)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C36:L36)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C37<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C37:L37)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C37:L37)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C38<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C38:L38)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C38:L38)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C39<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C39:L39)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C39:L39)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C40<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C40:L40)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C40:L40)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C41<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C41:L41)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C41:L41)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C42<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C42:L42)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C42:L42)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C43<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C43:L43)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C43:L43)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C44<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C44:L44)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C44:L44)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C45<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C45:L45)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C45:L45)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C46<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C46:L46)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C46:L46)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C47<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C47:L47)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C47:L47)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C48:L48)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C48:L48)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C49<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C49:L49)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C49:L49)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C50<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C50:L50)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C50:L50)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C51<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C51:L51)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C51:L51)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C52<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C52:L52)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C52:L52)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C53<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C53:L53)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C53:L53)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C54<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C54:L54)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C54:L54)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C55<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C55:L55)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C55:L55)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C56<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C56:L56)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C56:L56)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C57<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C57:L57)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C57:L57)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C58<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C58:L58)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C58:L58)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C59<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C59:L59)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C59:L59)<>0),))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C60<>\"\",IF(10-SUM(INDEX(N(COUNTIF(M$10:R$60,C60:L60)<>0),))=0,\"JACKPOT\",10-SUM(INDEX(N(COUNTIF(M$10:R$60,C60:L60)<>0),))),\"\")","v":""}]
[]
[null,"Namen worden manueel","Gekozen nummers van de deelnemers worden uiteraard MANUEEL ingevuld",null,null,null,null,null,null,null,null,null,"Trekking nummers worden elke week MANUEEL ingevuld, en ",null,null,null,null,null,"MANUEEL",null,"MANUEEL"]
[null,"ingevuld.","Na de trekking worden de nummers automatisch gecontroleerd en de numers die voorkomen op de",null,null,null,null,null,null,null,null,null,"getoetst aan de ingevulde nummers van alle deelnemers"]
[null,null,"trekking worden rood ingekleurd. Die inkleuring blijft bestaan. ",null,null,null,null,null,null,null,null,null,"Dus elke trekking wordt afzonderlijk ingegeven en getoest"]
[null,null,"In het vak AANTAL wordt dan weegegeven hoeveel nummers er nog NIET ingekleurd zijn.",null,null,null,null,null,null,null,null,null,"met de ingevulde nummers van de deelnemers."]
[null,null,"Staat er maar 3 nummers meer open, dan wordt dat in het vak AANTAL LICHTBLAUW ingekleurd. "]
[null,null,"Staan er maar 2 nummers meer open dan wordt dat in het vak AANTAL GEEL ingekleurd."]
[null,null,"Staat er maar 1 nummer meer open dan wordt dat in het vak AANTAL ROOD ingekleurd."]
[null,null,"Zijn alle nummers getrokken, dan wordt dat in het vak AANTAL GROEN  en JACKPOT"]
[null,null,"Dus, de nummers die door de deelnemer ingevuld werden, wijzigen nooit."]
[]
[null,"Voorbeeld",1,2,3,4,5,6,7,8,9,10,1,3,5,6,7,9,"2026-07-15",4,"XX"]
[null,null,"Stel dat bij de volgende trekking de cijfers 2 ook uitkomt dan worden die ook rood ingekleurd"]
[null,null,1,2,3,4,5,6,7,8,9,10,2,11,13,17,23,41,"2026-07-16",3,"XX"]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,2,4,17,21,33,41,"2026-07-18",2,"XX"]
[null,null,"En bij nog een volgende trekking komen ook het nummer 8 uit, dan"]
[null,null,1,2,3,4,5,6,7,8,9,10,3,8,12,15,17,19,"2026-07-20",1,"XX"]
[null,null,"Zijn alle nummers getrokken dan."]
[null,null,1,2,3,4,5,6,7,8,9,10,10,22,27,31,35,36,"2026-07-23","JACKPOT","XX"]