{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Title","Goal","BillTry","MikeTry","Wrap Up"],"not_rendered":{"charts":0,"images":7,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,184]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: Counselling / Pixabay"]

{"sheet":"Goal","index":1,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Tenor","6 Months"]
["Start Date","Maturity Date"]
["2016-05-09","2016-05-31"]
["2016-06-01","2016-06-30"]
["2016-07-01","2016-07-31"]
["2016-08-01","2016-08-31"]
["2016-09-01","2016-09-30"]
["2016-10-01","2016-10-31"]
["2016-11-01","2016-11-09"]
["2016-11-10","2016-11-30"]
["2016-12-01","2016-12-31"]
["2017-01-01","2017-01-31"]
["2017-02-01","2017-02-28"]
["2017-03-01","2017-03-31"]
["2017-04-01","2017-04-30"]
["2017-05-01","2017-05-09"]
["2017-05-10","2017-05-31"]
["2017-06-01","2017-06-30"]
["2017-07-01","2017-07-31"]
["2017-08-01","2017-08-31"]
["2017-09-01","2017-09-30"]

{"sheet":"BillTry","index":2,"n_rows":30,"n_cols":18,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Bond Earnings Per Day",1]
[null,"Mos:",3]
["Name of the Bond","Start","End","Next Special Date","# of Days","Bond Earnings"]
["Bond A","2017-05-31",{"$f":"MIN(EOMONTH(B4,0),D4)","v":"2017-05-31"},{"$f":"EDATE(B4,C2)","v":"2017-08-31"},{"$f":"F4/1","v":1},{"$f":"(C4-B4+1)*$C$1","v":1},null,null,null,null,null,null,null,null,null,null,null,"EOMONTH"]
["Bond A",{"$f":"C4+1","v":"2017-06-01"},{"$f":"MIN(EOMONTH(B5,0),D5)","v":"2017-06-30"},{"$f":"IF(C4=D4,EDATE(C4,$C$2),D4)","v":"2017-08-31"},{"$f":"F5/1","v":30},30,null,null,null,null,null,null,null,null,null,null,null,"EDATE"]
["Bond A",{"$f":"C5+1","v":"2017-07-01"},"2017-07-31",{"$f":"IF(C5=D5,EDATE(C5,$C$2),D5)","v":"2017-08-31"},31,31,null,null,null,null,null,null,null,null,null,null,null,"MIN"]
["Bond A","2017-08-01","2017-08-31","2017-08-31",31,31,null,null,null,null,null,null,null,null,null,null,null,"IF"]
["Bond B","2017-09-01","2017-09-30","2017-11-30",30,30]
["Bond B","2017-10-01","2017-10-31","2017-11-30",31,31]
["Bond B","2017-11-01","2017-11-30","2017-11-30",30,30]
["Bond C","2017-12-01","2017-12-31","2018-02-28",31,31]
["Bond C","2018-01-01","2018-01-31","2018-02-28",31,31]
["Bond C","2018-02-01","2018-02-28","2018-02-28",28,28]
["Bond D","2018-03-01","2018-03-31","2018-05-28",31,31]
["Bond D","2018-04-01","2018-04-30","2018-05-28",30,30]
["Bond D","2018-05-01","2018-05-28","2018-05-28",28,28]
["Bond E","2018-05-29","2018-05-31","2018-08-28",3,3]
["Bond E","2018-06-01","2018-06-30","2018-08-28",30,30]
["Bond E","2018-07-01","2018-07-31","2018-08-28",31,31]
["Bond E","2018-08-01","2018-08-28","2018-08-28",28,28]
[null,"2018-08-29","2018-08-31","2018-11-28",3,3]
[null,"2018-09-01","2018-09-30","2018-11-28",30,30]
[null,"2018-10-01","2018-10-31","2018-11-28",31,31]
[null,"2018-11-01","2018-11-28","2018-11-28",28,28]
[null,"2018-11-29","2018-11-30","2019-02-28",2,2]
[null,"2018-12-01","2018-12-31","2019-02-28",31,31]
[null,"2019-01-01","2019-01-31","2019-02-28",31,31]
[null,"2019-02-01","2019-02-28","2019-02-28",28,28]
[null,"2019-03-01","2019-03-31","2019-05-28",31,31]
[null,"2019-04-01","2019-04-30","2019-05-28",30,30]

{"sheet":"MikeTry","index":3,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Mos:",6]
["Start","End"]
["2016-05-09"]

{"sheet":"Wrap Up","index":4,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Goal is to fill start/end dates for tracking a bond monthly"]
[null,"Bill's method. EOMONTH. EDATE."]
[null,"IF to pull EDATE over if it is MIN(EDATE,EOMONTH)"]
[null,"Helper column calculates a new EDATE when the EDATE is used"]
[null,"Start date in next row is easy: Former End Date + 1"]
[null,"Mike's method:"]
[null,"DNF"]