Reinstatement and ceding formula

[stufraser1]

Reinstatement and ceding are formats that you overwrite (see cell W27/W28 and column R).

I think as people build on the example version they may be confused and think a formula is needed here. Could the formula not be replaced with data validation? It’s minor but would improve user experience (and they won’t know to add the formula back once overwritten).

[stufraser1]

Column H (L1 ceded %) and Column R (L2 ceded %) - some cells were formula, others user entry - looks like formula were included in error. Action taken: removed the formula in those cells, added data validation including new guidance in error message.

Column M (L1 reinst) and Column W (L2 reinst) - I’m not sure why these are driven from whether country-peril combination is TRUE - is that on purpose, or should these follow the ceded % process, in which case I’ll take the same action for these REINST columns

[stufraser1]

Completed. With data validation (0,1,2) on resintatement count.