{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data Entry Form with Checkboxes","Making To Do List","Determining Monthly Payment","Creating Checklist with Summary","Creating Interactive Report"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Data Entry Form with Checkboxes","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Creating Data Entry Form with Checkboxes"]
[]
[null,true]
[null,true]
[]
[null,"Name","Edward"]
[null,"Age",12]

{"sheet":"Making To Do List","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Making To Do List with Conditional Formatting"]
[]
[null,"Works to Do","Checkbox","Status"]
[null,"Complete Assignments",null,{"$f":"IF(E5=TRUE, \"Done\", \"To Be Done\")","v":"Done"},true]
[null,"Buy Books",null,{"$f":"IF(E6=TRUE, \"Done\", \"To Be Done\")","v":"To Be Done"},false]
[null,"Do Laundry",null,"Done",true]
[null,"Reply to Mails",null,"To Be Done",false]

{"sheet":"Determining Monthly Payment","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Determining Monthly Payment"]
[]
[null,"Particulates","Value"]
[null,"Borrowed Amount",200000]
[null,"Annual Interest Rate",7.0000000000000007E-2]
[null,"No of Payments",12]
[null,null,true]
[]
[null,"Monthly Payments",{"$f":"PMT(C6,C7,C5,0,C8)","v":-23533.081991592608}]

{"sheet":"Creating Checklist with Summary","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Creating Checklist with Data Summary"]
[]
[null,"Project Planning Checklist","Checklist"]
[null,"Set Goals & Objectives",null,true]
[null,"Meet Project Manager",null,true]
[null,"Select Project Land",null,true]
[null,"Appoint Workers",null,false]
[null,"Make Project Plan",null,true]
[null,"Make Project Budget",null,false]
[]
[null,"Total Task",{"$f":"COUNTA(B5:B10)","v":6}]
[null,"Completed Task",{"$f":"COUNTIF(D5:D10,TRUE)","v":4}]

{"sheet":"Creating Interactive Report","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,7,3,8],[1,1,1,8]]}
[]
[null,"Using Checkboxes to Create Interactive Report"]
[]
[null,null,null,null,null,null,"Total Sales",{"$f":"DSUM(A6:E10, \"Total Sales\", I6:I10)","v":1840}]
[]
[null,"Product","Sales (Jan)","Sales (Feb)","Total Sales",null,"Checkbox","Linked Cell","Product"]
[null,"T-shirt",340,550,{"$f":"SUM(C7:D7)","v":890},null,"T-shirt",true,{"$f":"IF(H7=TRUE, G7, \"-\")","v":"T-shirt"}]
[null,"Shirt",450,500,{"$f":"SUM(C8:D8)","v":950},null,"Shirt",true,{"$f":"IF(H8=TRUE, G8, \"-\")","v":"Shirt"}]
[null,"Coat",500,600,1100,null,"Coat",false,"-"]
[null,"Jeans",300,350,650,null,"Jeans",false,"-"]