{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Rating Calculator","Annual updates checklist","Data Validation","Variables"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Rating Calculator","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,2],[8,3,9,3]]}
[]
[]
[null,"AuguStar E&O Rating Calculator"]
[null,"Policy Effective Date (required format: mm/dd/yyyy)"]
[null,"Policy Expiration Date","2025-04-01"]
[null,"Coverage Selection"]
[null,"Select Limit of Liability"]
[null,"Aggregate Limit",{"$f":"$C$7","v":0}]
[null,"Prior Acts Extension for Registered Representatives *",null,"* Provides coverage to Registered Representatives for Securities transactions prior to their ONESCO contract date.  This optional rider is not applicable to the Life Agents Only coverage level.  Refer to the policy for a complete description."]
[]
[]
[null,"Base Premium"]
[null,"Prior Acts Extension for Registered Representatives  *"]
[null,"Total Premium"]

{"sheet":"Annual updates checklist","index":1,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
["Checklist for updating this workbook annually:"]
["• Review > Unprotect Workbook"]
["• Unhide sheets:"]
["  · 'Variables'"]
["  · 'Data Validation'"]
["• Review and update Variables"]
["  · Update B5 \"Policy Effective Date minimum\""]
["  · Update B6 \"Policy Expiration Date maximum\""]
["  · Update B10 downward as needed, if any rates have changed."]
["• Review and update Data Validation if needed"]
["  · For example, if Life_and_Financial_Products has a new $8,000,000/$8,000,000 option."]
["• Re-hide sheets"]
["• Review > Protect Workbook"]
["• Save and update filename as needed"]

{"sheet":"Data Validation","index":2,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Conditional data validation (see Name Manager)"]
[]
[null,null,"Coverage Selection",null,"Life_Only","Life_Agent_Plus_Mutual_Funds_and_Variable_Products","Life_and_Financial_Products"]
[null,null,"Life_Only",null,1000000,2000000,2000000]
[null,null,"Life_Agent_Plus_Mutual_Funds_and_Variable_Products",null,2000000,5000000,5000000]
[null,null,"Life_and_Financial_Products",null,5000000]

{"sheet":"Variables","index":3,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["Last updated:","2024-04-04","P&C BA Team (PW)"]
[]
[]
[]
["Policy Effective Date minimum","2024-04-01"]
["Policy Expiration Date maximum","2025-04-01"]
[]
[]
[]
["Life_Only / 1000000 / 1000000",690]
["Life_Only / 2000000 / 2000000",801]
["Life_Only / 5000000 / 5000000",941]
[]
[]
["Life_Agent_Plus_Mutual_Funds_and_Variable_Products / 2000000 / 2000000",1395]
["Life_Agent_Plus_Mutual_Funds_and_Variable_Products / 5000000 / 5000000",1675]
[]
[]
[]
["Life_and_Financial_Products / 2000000 / 2000000",1916]
["Life_and_Financial_Products / 5000000 / 5000000",2359]
[]
[]
[]
["fpax / Life_Agent_Plus_Mutual_Funds_and_Variable_Products / 2000000",470]
["fpax / Life_Agent_Plus_Mutual_Funds_and_Variable_Products / 5000000",564]
[]
[]
[]
["fpax / Life_and_Financial_Products / 2000000",645]
["fpax / Life_and_Financial_Products / 5000000",795]