{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Sheet1","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,1,17,2],[18,1,18,2],[2,1,2,2]]}
[]
[]
[null,"Renewal Estimator"]
[]
[null,"License protected list price *",100000]
[null,"Annual Enhancement Plan, 16%",{"$f":"0.16*C5","v":16000}]
[null,"Lapse Date","2020-05-01"]
[null,"Expected Lapse-To Date","2020-06-30"]
[null,"Estimated # of days lapsed",{"$f":"C8-C7","v":60}]
[]
[null,"Due at Renewal Date *"]
[null,"Lapse Penalty ",{"$f":"(C5*0.19)*(C9/365)","v":3123.2876712328766}]
[null,"One Year Forward Enhancement",{"$f":"C6","v":16000}]
[]
[null,"Sum Due Upon Renewal **",{"$f":"SUM(C12:C13)","v":19123.287671232876}]
[null,"New Annual Renewal Date",{"$f":"C8","v":"2020-06-30"}]
[]
[null,"* Assumes no change in protected list price.  Lapsed enhancement plans are subject to an update to current protected list price "]
[null,"** This is a estimate only, for a valid quote please reach out to Licensing"]