Many thanks for posting the spreadsheet and for the whole thread.
In nthe spreadsheet, I think you convert the VIX number to a Var strike, I guess b/c VIX is calculated in calendar days.
You use the formula: =C40/SQRT((D40*365)/((B40-A40)*252))
whereC40 is VIX, D40 is business days and...