{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","How to"],"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":"Sheet1","index":0,"n_rows":101,"n_cols":16,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"         LIST TITLE"]
[{"$f":"IF(M2=\"Y\",1,0)","v":0},{"$f":"IF(M2=\"N\",1,0)","v":0},{"$f":"IF(M2=\"A\",1,0)","v":0},"NAME",null,null,{"$f":"IF(D2<>\"\",G1+1,\"\")","v":1},"TEXTTEXTTEXTTEXT",null,null,null,null,null,{"$f":"IF(M2<>0,1,0)","v":0},{"$f":"IF(D2<>0,1,0)","v":1},{"$f":"SUM(N2:N101)","v":0}]
[{"$f":"IF(M3=\"Y\",1,0)","v":0},{"$f":"IF(M3=\"N\",1,0)","v":0},{"$f":"IF(M3=\"A\",1,0)","v":0},null,null,null,"",null,null,null,null,null,null,0,0,{"$f":"SUM(O2:O101)-SUM(N2:N101)","v":1}]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,"↓"]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,{"$f":"P2+P3","v":1}]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,"Y="]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,{"$f":"SUM(A2:A101)","v":0}]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,"%="]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,{"$f":"(P13/P5)*100","v":0}]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,"N="]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,{"$f":"SUM(B2:B101)","v":0}]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,"%="]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,{"$f":"(P18/P5)*100","v":0}]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,"A="]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,{"$f":"SUM(C2:C101)","v":0}]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,"%="]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,{"$f":"(P23/P5)*100","v":0}]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,"T="]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,{"$f":"P13+P18+P23","v":0}]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,"%="]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0,{"$f":"(P28/P5)*100","v":0}]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,{"$f":"IF(D34<>\"\",G33+1,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(M34<>0,1,0)","v":0},{"$f":"IF(D34<>0,1,0)","v":0}]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,{"$f":"IF(D66<>\"\",G65+1,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(M66<>0,1,0)","v":0},{"$f":"IF(D66<>0,1,0)","v":0}]
[{"$f":"IF(M67=\"Y\",1,0)","v":0},{"$f":"IF(M67=\"N\",1,0)","v":0},{"$f":"IF(M67=\"A\",1,0)","v":0},null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,{"$f":"IF(M98<>0,1,0)","v":0},0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]
[0,0,0,null,null,null,"",null,null,null,null,null,null,0,0]

{"sheet":"How to","index":1,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["This app can be used in different ways."]
[]
["1. As a simple checklist."]
[]
["2. As a simple voting list."]
[]
["1. Checklist"]
[]
["Just fill in the information you want in the text spaces and if applicable check the appropriate cell"]
["(column M) with an X. The cell adjacent to the X will turn green."]
["Simultaneously the values of the cells in column P will change. When filling a cell in column M"]
["the value in cell P2 will increase with 1 and the cell in P3 will decrease with 1."]
["The value in cell P5 is determined by the number of cells you fill with characters (column D)."]
[]
["Don't worry about the macro in this sheet, it's just a quicker way to sort your list alphabetically."]
["The macro will sort data in column D to column N meaning that you will not loose your checked"]
["cells after sorting. In other words: each row should stay as it was before the sorting operation."]
["After entering data in a row you can simply hit [ctrl+s] to sort your list. The advantage here is"]
["that you can do this anywhere in your list without having to select the appropriate cells. "]
[]
["2. Voting list"]
[]
["This list will only work as a single topic voting list, not as a multiple topic list. So if you want"]
["to decide who is going to be your next CEO this isn't the right tool (unless there's only one"]
["candidate)."]
["It's quite simple: just fill in the names of your voters (column D) and if you like, any additional"]
["information in columns H to L. Then check the M cell in the same row with Y for yes, N for no"]
["and A for abstention. Excel will give you the number of voters for each category as well as the"]
["corresponding percentage. T stands for the total of all people who have voted."]
["Don't forget: to sort just hit [ctrl+s]."]
[]
["Remark:"]
[]
["You can freely delete an item from your list or add one and when you're ready just perform the  "]
["sort operation. So you won't have to start from scratch each time items change."]