{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Adding Checkbox","Add checkbox without dev","Format checkbox","linked cell","conditional formatting","print","delete","Simple with Checkbox","Checklist_Conditional Format","Checklist_Summary"],"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":"Adding Checkbox","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Adding a Checkbox"]
[]
[null,"Home Office Checklist ","Availability"]
[null,"Computer and/or Laptop"]
[null,"Highspeed Internet"]
[null,"The Perfect Space"]
[null,"Adequate Lighting"]
[null,"Traditional/Ergonomic Desk"]
[null,"Comfortable Chair"]
[null,"Multipurpose Printer"]
[null,"File Cabinet"]
[null,"Paper Shredder"]
[null,"Keyboard and Mouse"]

{"sheet":"Add checkbox without dev","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Adding a Checkbox without Developer Tab"]
[]
[null,"Home Office Checklist ","Availability"]
[null,"Computer and/or Laptop"]
[null,"Highspeed Internet"]
[null,"The Perfect Space"]
[null,"Adequate Lighting"]
[null,"Traditional/Ergonomic Desk"]
[null,"Comfortable Chair"]
[null,"Multipurpose Printer"]
[null,"File Cabinet"]
[null,"Paper Shredder"]
[null,"Keyboard and Mouse"]

{"sheet":"Format checkbox","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Format Checkbox"]
[]
[null,"Home Office Checklist ","Availability"]
[null,"Computer and/or Laptop"]
[null,"Highspeed Internet"]
[null,"The Perfect Space"]
[null,"Adequate Lighting"]
[null,"Traditional/Ergonomic Desk"]
[null,"Comfortable Chair"]
[null,"Multipurpose Printer"]
[null,"File Cabinet"]
[null,"Paper Shredder"]
[null,"Keyboard and Mouse"]

{"sheet":"linked cell","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Link a Checkbox to a Cell"]
[]
[null,"Home Office Checklist ","Availability","Linked Cell"]
[null,"Computer and/or Laptop",null,true]
[null,"Highspeed Internet"]
[null,"The Perfect Space"]
[null,"Adequate Lighting"]
[null,"Traditional/Ergonomic Desk"]
[null,"Comfortable Chair"]
[null,"Multipurpose Printer"]
[null,"File Cabinet"]
[null,"Paper Shredder"]
[null,"Keyboard and Mouse"]

{"sheet":"conditional formatting","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use Conditional Formatting "]
[]
[null,"Home Office Checklist ","Availability","Linked Cell"]
[null,"Computer and/or Laptop",null,true]
[null,"Highspeed Internet",null,false]
[null,"The Perfect Space",null,false]
[null,"Adequate Lighting",null,false]
[null,"Traditional/Ergonomic Desk",null,true]
[null,"Comfortable Chair",null,false]
[null,"Multipurpose Printer",null,false]
[null,"File Cabinet",null,false]
[null,"Paper Shredder",null,false]
[null,"Keyboard and Mouse",null,false]

{"sheet":"print","index":5,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Print Checkbox"]
[]
[null,"Home Office Checklist ","Availability"]
[null,"Computer and/or Laptop"]
[null,"Highspeed Internet"]
[null,"The Perfect Space"]
[null,"Adequate Lighting"]
[null,"Traditional/Ergonomic Desk"]
[null,"Comfortable Chair"]
[null,"Multipurpose Printer"]
[null,"File Cabinet"]
[null,"Paper Shredder"]
[null,"Keyboard and Mouse"]

{"sheet":"delete","index":6,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Delete Checkbox"]
[]
[null,"Home Office Checklist ","Availability"]
[null,"Computer and/or Laptop"]
[null,"Highspeed Internet"]
[null,"The Perfect Space"]
[null,"Adequate Lighting"]
[null,"Traditional/Ergonomic Desk"]
[null,"Comfortable Chair"]
[null,"Multipurpose Printer"]
[null,"File Cabinet"]
[null,"Paper Shredder"]
[null,"Keyboard and Mouse"]

{"sheet":"Simple with Checkbox","index":7,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Creative a Simple Checklist for Home Office"]
[]
[null,"Home Office Checklist ","Availability","Linked Cell"]
[null,"Computer and/or Laptop",null,true]
[null,"Highspeed Internet",null,true]
[null,"The Perfect Space",null,true]
[null,"Adequate Lighting",null,true]
[null,"Traditional/Ergonomic Desk",null,false]
[null,"Comfortable Chair",null,false]
[null,"Multipurpose Pinter",null,true]
[null,"File Cabinet",null,false]
[null,"Paper Shredder",null,false]
[null,"Keyboard and Mouse",null,true]

{"sheet":"Checklist_Conditional Format","index":8,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Creating Interactive Checklist"]
[]
[null,"Home Office Checklist ","Availability","Cell Linked","Availability Status"]
[null,"Computer and/or Laptop",null,true,{"$f":"IF(D5=TRUE,\"Available\", \"Not Available\")","v":"Available"}]
[null,"Highspeed Internet",null,true,{"$f":"IF(D6=TRUE,\"Available\", \"Not Available\")","v":"Available"}]
[null,"The Perfect Space",null,false,"Not Available"]
[null,"Adequate Lighting",null,true,"Available"]
[null,"Traditional/Ergonomic Desk",null,false,"Not Available"]
[null,"Comfortable Chair",null,false,"Not Available"]
[null,"Multipurpose Printer",null,true,"Available"]
[null,"File Cabinet",null,false,"Not Available"]
[null,"Paper Shredder",null,false,"Not Available"]
[null,"Keyboard and Mouse",null,true,"Available"]

{"sheet":"Checklist_Summary","index":9,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,3,18,4],[14,1,14,4],[2,1,2,4],[1,1,1,4],[16,3,16,4],[17,3,17,4],[15,3,15,4]]}
[]
[null,"Creating Interactive Checklist with Summary Using Checkbox"]
[null,"Interactive Checklist for Home Office"]
[null,"Home Office Checklist ",null,"Cell Linked","Availability Status"]
[null,"Computer and/or Laptop",null,false,{"$f":"IF(D5=TRUE,\"Available\", \"Not Available\")","v":"Not Available"}]
[null,"Highspeed Internet",null,true,{"$f":"IF(D6=TRUE,\"Available\", \"Not Available\")","v":"Available"}]
[null,"The Perfect Space",null,false,"Not Available"]
[null,"Adequate Lighting",null,true,"Available"]
[null,"Traditional/Ergonomic Desk",null,false,"Not Available"]
[null,"Comfortable Chair",null,false,"Not Available"]
[null,"Multipurpose Printer",null,true,"Available"]
[null,"File Cabinet",null,false,"Not Available"]
[null,"Paper Shredder",null,true,"Available"]
[null,"Keyboard and Mouse",null,false,"Not Available"]
[null,"Summary"]
[null,"What You Want to Find","Output","Formula"]
[null,"Number of All Items",{"$f":"COUNTA(B5:B14)","v":10},{"$f":"_xlfn.FORMULATEXT(C17)","v":"=COUNTA(B5:B14)"}]
[null,"Number of Available Items",{"$f":"COUNTIF(D5:D14, TRUE)","v":4},{"$f":"_xlfn.FORMULATEXT(C18)","v":"=COUNTIF(D5:D14, TRUE)"}]
[null,"% of Available Items",{"$f":"C18/C17","v":0.4},"=C18/C17"]