{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Question","Try","MrExcel","MrExcel2","excelisfun","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":6,"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":"Question","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
["Start","2014-09-07"]
["End","2014-09-10"]

{"sheet":"Try","index":1,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
["Start","2014-09-07"]
["End","2014-09-10"]

{"sheet":"MrExcel","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
["Start","2014-09-07",null,{"$f":"DAY(ROW(INDIRECT(B7&\":\"&B8)))","v":7},null,{"$f":"DAY(ROW(INDIRECT(B7&\":\"&B8)))","v":7}]
["End","2014-09-17",null,null,null,8]
[null,null,null,null,null,9]
[null,null,null,null,null,10]
[null,null,null,null,null,11]
[null,null,null,null,null,12]
[null,null,null,null,null,13]
[null,null,null,null,null,14]

{"sheet":"MrExcel2","index":3,"n_rows":10,"n_cols":20,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Start","End"]
[null,"2014-09-07","2014-09-10",7,8,9,10]
[null,"2014-09-21","2014-09-21",21]
[null,"2015-02-17","2015-03-05",17,18,19,20,21,22,23,24,25,26,27,28,1,2,3,4,5]

{"sheet":"excelisfun","index":4,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Start","2014-09-28",null,"# of Days","Days","Not ROW(A1)",null,"Why not ROW(A1)?",null,null,"Days"]
[null,"End","2014-10-02",null,{"$f":"C5-C4+1","v":5},{"$f":"IF(ROWS(F$5:F5)>$E$5,\"\",DAY($C$4+ROWS(F$5:F5)-1))","v":28},{"$f":"IF(ROW(A1)>$E$5,\"\",DAY($C$4+ROW(A1)-1))","v":28},null,"1) Delete A1",null,null,{"$f":"CHOOSE((ROWS(L$5:L5)>$E$5)+1,DAY($C$4)+ROWS(L$5:L5)-1,\"\")","v":28}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F6)>$E$5,\"\",DAY($C$4+ROWS(F$5:F6)-1))","v":29},{"$f":"IF(ROW(A2)>$E$5,\"\",DAY($C$4+ROW(A2)-1))","v":29},null,"2) Delete Column A",null,null,{"$f":"CHOOSE((ROWS(L$5:L6)>$E$5)+1,DAY($C$4)+ROWS(L$5:L6)-1,\"\")","v":29}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F7)>$E$5,\"\",DAY($C$4+ROWS(F$5:F7)-1))","v":30},30,null,"3) Delete Row 1",null,null,{"$f":"CHOOSE((ROWS(L$5:L7)>$E$5)+1,DAY($C$4)+ROWS(L$5:L7)-1,\"\")","v":30}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F8)>$E$5,\"\",DAY($C$4+ROWS(F$5:F8)-1))","v":1},1,null,"4) Insert Row 1",null,null,{"$f":"CHOOSE((ROWS(L$5:L8)>$E$5)+1,DAY($C$4)+ROWS(L$5:L8)-1,\"\")","v":31}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F9)>$E$5,\"\",DAY($C$4+ROWS(F$5:F9)-1))","v":2},2,null,"Ctrl + Shift + Enter:",null,null,{"$f":"CHOOSE((ROWS(L$5:L9)>$E$5)+1,DAY($C$4)+ROWS(L$5:L9)-1,\"\")","v":32}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F10)>$E$5,\"\",DAY($C$4+ROWS(F$5:F10)-1))","v":""},"",null,"Chapter 8: pages 101-112",null,null,{"$f":"CHOOSE((ROWS(L$5:L10)>$E$5)+1,DAY($C$4)+ROWS(L$5:L10)-1,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F11)>$E$5,\"\",DAY($C$4+ROWS(F$5:F11)-1))","v":""},"",null,null,null,null,{"$f":"CHOOSE((ROWS(L$5:L11)>$E$5)+1,DAY($C$4)+ROWS(L$5:L11)-1,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F12)>$E$5,\"\",DAY($C$4+ROWS(F$5:F12)-1))","v":""},"",null,null,null,null,{"$f":"CHOOSE((ROWS(L$5:L12)>$E$5)+1,DAY($C$4)+ROWS(L$5:L12)-1,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F13)>$E$5,\"\",DAY($C$4+ROWS(F$5:F13)-1))","v":""},"",null,null,null,null,{"$f":"CHOOSE((ROWS(L$5:L13)>$E$5)+1,DAY($C$4)+ROWS(L$5:L13)-1,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F14)>$E$5,\"\",DAY($C$4+ROWS(F$5:F14)-1))","v":""},"",null,null,null,null,{"$f":"CHOOSE((ROWS(L$5:L14)>$E$5)+1,DAY($C$4)+ROWS(L$5:L14)-1,\"\")","v":""}]

{"sheet":"Sheet2","index":5,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Start","2014-09-07",null,"# of Days","Days","Not ROW(A1)",null,"Why not ROW(A1)?",null,null,"Days"]
[null,"End","2014-09-10",null,{"$f":"C5-C4+1","v":4},{"$f":"IF(ROWS(F$5:F5)>$E$5,\"\",DAY($C$4)+ROWS(F$5:F5)-1)","v":7},{"$f":"IF(ROW(A1)>E$5,\"\",DAY(C$4+ROW(A1)-1))","v":7},null,"1) Delete A1",null,null,{"$f":"CHOOSE((ROWS(L$5:L5)>$E$5)+1,DAY($C$4)+ROWS(L$5:L5)-1,\"\")","v":7}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F6)>$E$5,\"\",DAY($C$4)+ROWS(F$5:F6)-1)","v":8},{"$f":"IF(ROW(A2)>E$5,\"\",DAY(C$4+ROW(A2)-1))","v":8},null,"2) Delete Column A",null,null,{"$f":"CHOOSE((ROWS(L$5:L6)>$E$5)+1,DAY($C$4)+ROWS(L$5:L6)-1,\"\")","v":8}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F7)>$E$5,\"\",DAY($C$4)+ROWS(F$5:F7)-1)","v":9},9,null,"3) Delete Row 1",null,null,{"$f":"CHOOSE((ROWS(L$5:L7)>$E$5)+1,DAY($C$4)+ROWS(L$5:L7)-1,\"\")","v":9}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F8)>$E$5,\"\",DAY($C$4)+ROWS(F$5:F8)-1)","v":10},10,null,"4) Insert Row 1",null,null,{"$f":"CHOOSE((ROWS(L$5:L8)>$E$5)+1,DAY($C$4)+ROWS(L$5:L8)-1,\"\")","v":10}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F9)>$E$5,\"\",DAY($C$4)+ROWS(F$5:F9)-1)","v":""},"",null,null,null,null,{"$f":"CHOOSE((ROWS(L$5:L9)>$E$5)+1,DAY($C$4)+ROWS(L$5:L9)-1,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F10)>$E$5,\"\",DAY($C$4)+ROWS(F$5:F10)-1)","v":""},"",null,null,null,null,{"$f":"CHOOSE((ROWS(L$5:L10)>$E$5)+1,DAY($C$4)+ROWS(L$5:L10)-1,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F11)>$E$5,\"\",DAY($C$4)+ROWS(F$5:F11)-1)","v":""},"",null,null,null,null,{"$f":"CHOOSE((ROWS(L$5:L11)>$E$5)+1,DAY($C$4)+ROWS(L$5:L11)-1,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F12)>$E$5,\"\",DAY($C$4)+ROWS(F$5:F12)-1)","v":""},"",null,null,null,null,{"$f":"CHOOSE((ROWS(L$5:L12)>$E$5)+1,DAY($C$4)+ROWS(L$5:L12)-1,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F13)>$E$5,\"\",DAY($C$4)+ROWS(F$5:F13)-1)","v":""},"",null,null,null,null,{"$f":"CHOOSE((ROWS(L$5:L13)>$E$5)+1,DAY($C$4)+ROWS(L$5:L13)-1,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ROWS(F$5:F14)>$E$5,\"\",DAY($C$4)+ROWS(F$5:F14)-1)","v":""},"",null,null,null,null,{"$f":"CHOOSE((ROWS(L$5:L14)>$E$5)+1,DAY($C$4)+ROWS(L$5:L14)-1,\"\")","v":""}]

{"sheet":"Sheet3","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}