{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Alerts","Macro"],"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":"Alerts","index":0,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,2,3,3]]}
[{"$f":"TODAY()+3","v":"2019-03-03"},"Electric",2500,null,null,null,null,null,null,"2019-03-22"]
[{"$f":"DAY(A1)","v":3},{"$f":"DAY(A2)&IF(OR(DAY(A2)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(A2),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"3rd "},null,null,null,null,null,null,null,{"$f":"DAY($J$1)","v":22},{"$f":"DAY(J2)&IF(OR(DAY(J2)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(J2),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"22nd "}]
[]
["Invoices/Debts","Amount Due","Due Day\nof the Month",null,"ALERT\nCardinal #","ALERT\nOridinal #",null,null,null,"Check Your Answers"]
["Property Rent",4000,{"$f":"DAY(1)","v":"1900-01-01"},{"$f":"DAY(C5)&IF(OR(DAY(C5)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C5),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"1st"},{"$f":"IF(C5=$A$2,\"DUE NOW\", 0)","v":0},{"$f":"IF(D5=$B$2,\"DUE NOW\", 0)","v":0},null,null,null,{"$f":"IF(C5=$J$2, \"DUE NOW\", 0)","v":0}]
["Building Mortgage",6000,{"$f":"DAY(2)","v":"1900-01-02"},{"$f":"DAY(C6)&IF(OR(DAY(C6)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C6),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"2nd "},{"$f":"IF(C6=$A$2,\"DUE NOW\", 0)","v":0},{"$f":"IF(D6=$B$2,\"DUE NOW\", 0)","v":0},null,null,null,0]
["Electric",2500,{"$f":"DAY(3)","v":"1900-01-03"},{"$f":"DAY(C7)&IF(OR(DAY(C7)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C7),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"3rd "},"DUE NOW","DUE NOW",null,null,null,0]
["Gas",1800,{"$f":"DAY(4)","v":"1900-01-04"},{"$f":"DAY(C8)&IF(OR(DAY(C8)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C8),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"4th"},0,0,null,null,null,0]
["Water",1200,{"$f":"DAY(5)","v":"1900-01-05"},{"$f":"DAY(C9)&IF(OR(DAY(C9)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C9),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"5th"},0,0,null,null,null,0]
["Insurance",1125,{"$f":"DAY(5)","v":"1900-01-05"},{"$f":"DAY(C10)&IF(OR(DAY(C10)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C10),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"5th"},0,0,null,null,null,0]
["Landscape Maintenance",985,{"$f":"DAY(7)","v":"1900-01-07"},{"$f":"DAY(C11)&IF(OR(DAY(C11)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C11),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"7th"},0,0,null,null,null,0]
["Building Maintenance",1050,{"$f":"DAY(8)","v":"1900-01-08"},{"$f":"DAY(C12)&IF(OR(DAY(C12)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C12),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"8th"},0,0,null,null,null,0]
["Maid Service",1465,{"$f":"DAY(9)","v":"1900-01-09"},{"$f":"DAY(C13)&IF(OR(DAY(C13)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C13),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"9th"},0,0,null,null,null,0]
["Security",1500,{"$f":"DAY(10)","v":"1900-01-10"},{"$f":"DAY(C14)&IF(OR(DAY(C14)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C14),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"10th"},0,0,null,null,null,0]
["Property Rent",4000,{"$f":"DAY(11)","v":"1900-01-11"},{"$f":"DAY(C15)&IF(OR(DAY(C15)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C15),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"11th"},0,0,null,null,null,0]
["Building Mortgage",6000,{"$f":"DAY(12)","v":"1900-01-12"},{"$f":"DAY(C16)&IF(OR(DAY(C16)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C16),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"12th"},0,0,null,null,null,0]
["Electric",2500,{"$f":"DAY(13)","v":"1900-01-13"},{"$f":"DAY(C17)&IF(OR(DAY(C17)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C17),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"13th"},0,0,null,null,null,0]
["Gas",1800,{"$f":"DAY(14)","v":"1900-01-14"},{"$f":"DAY(C18)&IF(OR(DAY(C18)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C18),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"14th"},0,0,null,null,null,0]
["Water / Sewer",1200,{"$f":"DAY(15)","v":"1900-01-15"},{"$f":"DAY(C19)&IF(OR(DAY(C19)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C19),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"15th"},0,0,null,null,null,0]
["Insurance",1125,{"$f":"DAY(16)","v":"1900-01-16"},{"$f":"DAY(C20)&IF(OR(DAY(C20)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C20),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"16th"},0,0,null,null,null,0]
["Landscape Maintenance",985,{"$f":"DAY(17)","v":"1900-01-17"},{"$f":"DAY(C21)&IF(OR(DAY(C21)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C21),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"17th"},0,0,null,null,null,0]
["Building Maintenance",1050,{"$f":"DAY(18)","v":"1900-01-18"},{"$f":"DAY(C22)&IF(OR(DAY(C22)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C22),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"18th"},0,0,null,null,null,0]
["Maid Service",1465,{"$f":"DAY(19)","v":"1900-01-19"},{"$f":"DAY(C23)&IF(OR(DAY(C23)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C23),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"19th"},0,0,null,null,null,0]
["Security",1500,{"$f":"DAY(20)","v":"1900-01-20"},{"$f":"DAY(C24)&IF(OR(DAY(C24)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C24),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"20th"},0,0,null,null,null,0]
["Electronic Equipment",4200,{"$f":"DAY(21)","v":"1900-01-21"},{"$f":"DAY(C25)&IF(OR(DAY(C25)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C25),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"21st"},0,0,null,null,null,0]
["Network Management",1200,{"$f":"DAY(22)","v":"1900-01-22"},{"$f":"DAY(C26)&IF(OR(DAY(C26)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C26),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"22nd "},0,0,null,null,null,"DUE NOW"]
["Office Supplies",800,{"$f":"DAY(23)","v":"1900-01-23"},{"$f":"DAY(C27)&IF(OR(DAY(C27)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C27),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"23rd "},0,0,null,null,null,0]
["Water Delivery",425,{"$f":"DAY(24)","v":"1900-01-24"},{"$f":"DAY(C28)&IF(OR(DAY(C28)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C28),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"24th"},0,0,null,null,null,0]
["Break Room Snacks",685,{"$f":"DAY(25)","v":"1900-01-25"},{"$f":"DAY(C29)&IF(OR(DAY(C29)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C29),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"25th"},0,0,null,null,null,0]
["Media Deliveries",300,{"$f":"DAY(26)","v":"1900-01-26"},{"$f":"DAY(C30)&IF(OR(DAY(C30)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C30),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"26th"},0,0,null,null,null,0]
["Indoor Plants Maintenance",460,{"$f":"DAY(27)","v":"1900-01-27"},{"$f":"DAY(C31)&IF(OR(DAY(C31)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C31),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"27th"},0,0,null,null,null,0]
["Termite Bond",200,{"$f":"DAY(28)","v":"1900-01-28"},{"$f":"DAY(C32)&IF(OR(DAY(C32)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C32),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"28th"},0,0,null,null,null,0]
["Appliances Maintenance/Repairs",330,{"$f":"DAY(29)","v":"1900-01-29"},{"$f":"DAY(C33)&IF(OR(DAY(C33)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C33),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"29th"},0,0,null,null,null,0]
["Donations",700,{"$f":"DAY(30)","v":"1900-01-30"},{"$f":"DAY(C34)&IF(OR(DAY(C34)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C34),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"30th"},0,0,null,null,null,0]

{"sheet":"Macro","index":1,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,2,3,3]]}
[{"$f":"TODAY()+3","v":"2019-03-03"}]
[{"$f":"DAY(A1)","v":3},{"$f":"DAY(A2)&IF(OR(DAY(A2)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(A2),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"3rd "}]
[]
["Invoices/Debts","Amount Due","Due Day\nof the Month",null,"ALERT\nCardinal #","ALERT\nOridinal #"]
["Property Rent",4000,{"$f":"DAY(1)","v":"1900-01-01"},{"$f":"DAY(C5)&IF(OR(DAY(C5)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C5),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"1st"},{"$f":"IF(C5=$A$2,\"DUE NOW\", 0)","v":0},{"$f":"IF(D5=$B$2,\"DUE NOW\", 0)","v":0}]
["Building Mortgage",6000,{"$f":"DAY(2)","v":"1900-01-02"},{"$f":"DAY(C6)&IF(OR(DAY(C6)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C6),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"2nd "},{"$f":"IF(C6=$A$2,\"DUE NOW\", 0)","v":0},{"$f":"IF(D6=$B$2,\"DUE NOW\", 0)","v":0}]
["Electric",2500,{"$f":"DAY(3)","v":"1900-01-03"},{"$f":"DAY(C7)&IF(OR(DAY(C7)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C7),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"3rd "},"DUE NOW","DUE NOW"]
["Gas",1800,{"$f":"DAY(4)","v":"1900-01-04"},{"$f":"DAY(C8)&IF(OR(DAY(C8)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C8),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"4th"},0,0]
["Water",1200,{"$f":"DAY(5)","v":"1900-01-05"},{"$f":"DAY(C9)&IF(OR(DAY(C9)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C9),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"5th"},0,0]
["Insurance",1125,{"$f":"DAY(6)","v":"1900-01-06"},{"$f":"DAY(C10)&IF(OR(DAY(C10)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C10),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"6th"},0,0]
["Landscape Maintenance",985,{"$f":"DAY(7)","v":"1900-01-07"},{"$f":"DAY(C11)&IF(OR(DAY(C11)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C11),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"7th"},0,0]
["Building Maintenance",1050,{"$f":"DAY(8)","v":"1900-01-08"},{"$f":"DAY(C12)&IF(OR(DAY(C12)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C12),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"8th"},0,0]
["Maid Service",1465,{"$f":"DAY(9)","v":"1900-01-09"},{"$f":"DAY(C13)&IF(OR(DAY(C13)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C13),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"9th"},0,0]
["Security",1500,{"$f":"DAY(10)","v":"1900-01-10"},{"$f":"DAY(C14)&IF(OR(DAY(C14)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C14),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"10th"},0,0]
["Property Rent",4000,{"$f":"DAY(11)","v":"1900-01-11"},{"$f":"DAY(C15)&IF(OR(DAY(C15)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C15),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"11th"},0,0]
["Building Mortgage",6000,{"$f":"DAY(12)","v":"1900-01-12"},{"$f":"DAY(C16)&IF(OR(DAY(C16)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C16),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"12th"},0,0]
["Electric",2500,{"$f":"DAY(13)","v":"1900-01-13"},{"$f":"DAY(C17)&IF(OR(DAY(C17)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C17),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"13th"},0,0]
["Gas",1800,{"$f":"DAY(14)","v":"1900-01-14"},{"$f":"DAY(C18)&IF(OR(DAY(C18)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C18),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"14th"},0,0]
["Water / Sewer",1200,{"$f":"DAY(15)","v":"1900-01-15"},{"$f":"DAY(C19)&IF(OR(DAY(C19)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C19),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"15th"},0,0]
["Insurance",1125,{"$f":"DAY(16)","v":"1900-01-16"},{"$f":"DAY(C20)&IF(OR(DAY(C20)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C20),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"16th"},0,0]
["Landscape Maintenance",985,{"$f":"DAY(17)","v":"1900-01-17"},{"$f":"DAY(C21)&IF(OR(DAY(C21)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C21),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"17th"},0,0]
["Building Maintenance",1050,{"$f":"DAY(18)","v":"1900-01-18"},{"$f":"DAY(C22)&IF(OR(DAY(C22)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C22),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"18th"},0,0]
["Maid Service",1465,{"$f":"DAY(19)","v":"1900-01-19"},{"$f":"DAY(C23)&IF(OR(DAY(C23)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C23),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"19th"},0,0]
["Security",1500,{"$f":"DAY(20)","v":"1900-01-20"},{"$f":"DAY(C24)&IF(OR(DAY(C24)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C24),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"20th"},0,0]
["Electronic Equipment",4200,{"$f":"DAY(21)","v":"1900-01-21"},{"$f":"DAY(C25)&IF(OR(DAY(C25)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C25),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"21st"},0,0]
["Network Management",1200,{"$f":"DAY(22)","v":"1900-01-22"},{"$f":"DAY(C26)&IF(OR(DAY(C26)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C26),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"22nd "},0,0]
["Office Supplies",800,{"$f":"DAY(23)","v":"1900-01-23"},{"$f":"DAY(C27)&IF(OR(DAY(C27)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C27),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"23rd "},0,0]
["Water Delivery",425,{"$f":"DAY(24)","v":"1900-01-24"},{"$f":"DAY(C28)&IF(OR(DAY(C28)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C28),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"24th"},0,0]
["Break Room Snacks",685,{"$f":"DAY(25)","v":"1900-01-25"},{"$f":"DAY(C29)&IF(OR(DAY(C29)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C29),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"25th"},0,0]
["Media Deliveries",300,{"$f":"DAY(26)","v":"1900-01-26"},{"$f":"DAY(C30)&IF(OR(DAY(C30)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C30),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"26th"},0,0]
["Indoor Plants Maintenance",460,{"$f":"DAY(27)","v":"1900-01-27"},{"$f":"DAY(C31)&IF(OR(DAY(C31)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C31),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"27th"},0,0]
["Termite Bond",200,{"$f":"DAY(28)","v":"1900-01-28"},{"$f":"DAY(C32)&IF(OR(DAY(C32)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C32),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"28th"},0,0]
["Appliances Maintenance/Repairs",330,{"$f":"DAY(29)","v":"1900-01-29"},{"$f":"DAY(C33)&IF(OR(DAY(C33)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C33),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"29th"},0,0]
["Donations",700,{"$f":"DAY(30)","v":"1900-01-30"},{"$f":"DAY(C34)&IF(OR(DAY(C34)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY(C34),1),\"st\",\"nd \",\"rd \"),\"th\")","v":"30th"},0,0]