Spreadsheet: 810343d1671708304-how-to-use-index-match-instead-of-vlookup-photography-str-calc
Sheet: Rates

 |  | Area | Portable Equipment - ex Laptops (incl AD) Premises Only | Fixtures & Fittings & Fixed Equipment (inc AD) Premises Only | Other Equipment (inc AD) Premises Only | All Equipment UK/Europe & 60 days WW | All Equipment Worldwide | Laptops UK/Europe & 60 days WW | [NAME] |  |  |  | Annual Period
 |  | 1 | 0.00619 | 0.002476 | 0.00538 | 0.01386 | 0.01936 | 0.05 | 0.1 |  |  |  | 365
 |  | 2 | 0.00644 | 0.002576 | 0.00569 | 0.01584 | 0.02134 | 0.05 | 0.1
 |  | 3 | 0.00693 | 0.002772 | 0.00633 | 0.01782 | 0.02332 | 0.05 | 0.1
 |  | 4 | 0.00792 | 0.003168 | 0.00759 | 0.0198 | 0.0253 | 0.05 | 0.1
 |  | 5 | 0.00891 | 0.003564 | 0.00886 | 0.02178 | 0.02728 | 0.05 | 0.1
 |  | 6 | 0.0099 | 0.003960000000000001 | 0.01012 | 0.02376 | 0.02926 | 0.05 | 0.1
 |  | 7 | 0.01155 | 0.00462 | 0.01075 | 0.0286 | 0.0341 | 0.05 | 0.1
 |  | 8 | 0.01265 | 0.00506 | 0.01202 | 0.0308 | 0.0363 | 0.05 | 0.1
 |  | 9 | 0.01375 | 0.005500000000000001 | 0.01328 | 0.033 | 0.0385 | 0.05 | 0.1
 |  | 10 | 0.01485 | 0.005940000000000001 | 0.01455 | 0.03465 | 0.04015 | 0.05 | 0.1
 |  | 11 | 0.0176 | 0.007040000000000001 | 0.0176 | 0.0352 | 0.0407 | 0.05 | 0.1
 |  | 12 | 0.0231 | 0.00924 | 0.0231 | 0.0385 | 0.044 | 0.05 | 0.1
 |  |  | Days cover requested |  | Days to be charged | % of Annual Premium | Description
 |  |  | From | To
 |  |  | 1 | 1 | 30 |  | SHORT RATE APPLIES
 |  |  | 2 | 2 | 30
 |  |  | 3 | 3 | 30
 |  |  | 4 | 4 | 30
 |  |  | 5 | 5 | 30
 |  |  | 6 | 6 | 30
 |  |  | 7 | 7 | 30
 |  |  | 8 | 8 | 30
 |  |  | 9 | 9 | 30
 |  |  | 10 | 10 | 45
 |  |  | 11 | 11 | 45
 |  |  | 12 | 12 | 45
 |  |  | 13 | 13 | 45
 |  |  | 14 | 14 | 45
 |  |  | 15 | 15 | 45
 |  |  | 16 | 16 | 45
 |  |  | 17 | 17 | 45
 |  |  | 18 | 18 | 45
 |  |  | 19 | 19 | 45
 |  |  | 20 | 20 | 45
 |  |  | 21 | 21 | 90
 |  |  | 22 | 22 | 90
 |  |  | 23 | 23 | 90
 |  |  | 24 | 24 | 90
 |  |  | 25 | 25 | 90
 |  |  | 26 | 26 | 90
 |  |  | 27 | 27 | 90
 |  |  | 28 | 28 | 90
 |  |  | 29 | 29 | 90
 |  |  | 30 | 30 | 120
 |  |  | 31 | 31 | 120
 |  |  | 32 | 32 | 120
 |  |  | 33 | 33 | 120
 |  |  | 34 | 34 | 120
 |  |  | 35 | 35 | 120
 |  |  | 36 | 36 | 120
 |  |  | 37 | 37 | 120
 |  |  | 38 | 38 | 120
 |  |  | 39 | 39 | 120
 |  |  | 40 | 40 | 150
 |  |  | 41 | 41 | 150
 |  |  | 42 | 42 | 150
 |  |  | 43 | 43 | 150
 |  |  | 44 | 44 | 150
 |  |  | 45 | 45 | 150
 |  |  | 46 | 46 | 150
 |  |  | 47 | 47 | 150
 |  |  | 48 | 48 | 150
 |  |  | 49 | 49 | 150
 |  |  | 50 | 50 | 150
 |  |  | 51 | 51 | 150
 |  |  | 52 | 52 | 150
 |  |  | 53 | 53 | 150
 |  |  | 54 | 54 | 150
 |  |  | 55 | 55 | 180
 |  |  | 56 | 56 | 180
 |  |  | 57 | 57 | 180
 |  |  | 58 | 58 | 180
 |  |  | 59 | 59 | 180
 |  |  | 60 | 60 | 180
 |  |  | 61 | 61 | 180
 |  |  | 62 | 62 | 180
 |  |  | 63 | 63 | 180
 |  |  | 64 | 64 | 180
 |  |  | 65 | 65 | 180
 |  |  | 66 | 66 | 180
 |  |  | 67 | 67 | 180
 |  |  | 68 | 68 | 180
 |  |  | 69 | 69 | 180
 |  |  | 70 | 70 | 180
 |  |  | 71 | 71 | 180
 |  |  | 72 | 72 | 180
 |  |  | 73 | 73 | 180
 |  |  | 74 | 74 | 180
 |  |  | 75 | 75 | 220
 |  |  | 76 | 76 | 220
 |  |  | 77 | 77 | 220
 |  |  | 78 | 78 | 220
 |  |  | 79 | 79 | 220
 |  |  | 80 | 80 | 220
 |  |  | 81 | 81 | 220
 |  |  | 82 | 82 | 220
 |  |  | 83 | 83 | 220
 |  |  | 84 | 84 | 220
 |  |  | 85 | 85 | 220
 |  |  | 86 | 86 | 220
 |  |  | 87 | 87 | 220
 |  |  | 88 | 88 | 220
 |  |  | 89 | 89 | 220
 |  |  | 90 | 90 | 220
 |  |  | 91 | 91 | 220
 |  |  | 92 | 92 | 220
 |  |  | 93 | 93 | 220
 |  |  | 94 | 94 | 220
 |  |  | 95 | 95 | 220
 |  |  | 96 | 96 | 220
 |  |  | 97 | 97 | 220
 |  |  | 98 | 98 | 220
 |  |  | 99 | 99 | 220
 |  |  | 100 | 100 | 275
 |  |  | 101 | 101 | 275
 |  |  | 102 | 102 | 275
 |  |  | 103 | 103 | 275
 |  |  | 104 | 104 | 275
 |  |  | 105 | 105 | 275
 |  |  | 106 | 106 | 275
 |  |  | 107 | 107 | 275
 |  |  | 108 | 108 | 275
 |  |  | 109 | 109 | 275
 |  |  | 110 | 110 | 275
 |  |  | 111 | 111 | 275
 |  |  | 112 | 112 | 275
 |  |  | 113 | 113 | 275
 |  |  | 114 | 114 | 275
 |  |  | 115 | 115 | 275
 |  |  | 116 | 116 | 275
 |  |  | 117 | 117 | 275
 |  |  | 118 | 118 | 275
 |  |  | 119 | 119 | 275
 |  |  | 120 | 120 | 275
 |  |  | 121 | 121 | 275
 |  |  | 122 | 122 | 275
 |  |  | 123 | 123 | 275
 |  |  | 124 | 124 | 275
 |  |  | 125 | 125 | 275
 |  |  | 126 | 126 | 275
 |  |  | 127 | 127 | 275
 |  |  | 128 | 128 | 275
 |  |  | 129 | 129 | 275
 |  |  | 130 | 130 | 275
 |  |  | 131 | 131 | 275
 |  |  | 132 | 132 | 275
 |  |  | 133 | 133 | 275
 |  |  | 134 | 134 | 275
 |  |  | 135 | 135 | 275
 |  |  | 136 | 136 | 275
 |  |  | 137 | 137 | 275
 |  |  | 138 | 138 | 275
 |  |  | 139 | 139 | 275
 |  |  | 140 | 140 | 275
 |  |  | 141 | 141 | 275
 |  |  | 142 | 142 | 275
 |  |  | 143 | 143 | 275
 |  |  | 144 | 144 | 275
 |  |  | 145 | 145 | 275
 |  |  | 146 | 146 | 275
 |  |  | 147 | 147 | 275
 |  |  | 148 | 148 | 275
 |  |  | 149 | 149 | 275
 |  |  | 150 | 150 | 335
 |  |  | 151 | 151 | 335
 |  |  | 152 | 152 | 335
 |  |  | 153 | 153 | 335
 |  |  | 154 | 154 | 335
 |  |  | 155 | 155 | 335
 |  |  | 156 | 156 | 335
 |  |  | 157 | 157 | 335
 |  |  | 158 | 158 | 335
 |  |  | 159 | 159 | 335
 |  |  | 160 | 160 | 335
 |  |  | 161 | 161 | 335
 |  |  | 162 | 162 | 335
 |  |  | 163 | 163 | 335
 |  |  | 164 | 164 | 335
 |  |  | 165 | 165 | 335
 |  |  | 166 | 166 | 335
 |  |  | 167 | 167 | 335
 |  |  | 168 | 168 | 335
 |  |  | 169 | 169 | 335
 |  |  | 170 | 170 | 335
 |  |  | 171 | 171 | 335
 |  |  | 172 | 172 | 335
 |  |  | 173 | 173 | 335
 |  |  | 174 | 174 | 335
 |  |  | 175 | 175 | 335
 |  |  | 176 | 176 | 335
 |  |  | 177 | 177 | 335
 |  |  | 178 | 178 | 335
 |  |  | 179 | 179 | 335
 |  |  | 180 | 180 | 335
 |  |  | 181 | 181 | 335
 |  |  | 182 | 182 | 335
 |  |  | 183 | 183 | 335
 |  |  | 184 | 184 | 335
 |  |  | 185 | 185 | 335
 |  |  | 186 | 186 | 335
 |  |  | 187 | 187 | 335
 |  |  | 188 | 188 | 335
 |  |  | 189 | 189 | 335
 |  |  | 190 | 190 | 335
 |  |  | 191 | 191 | 335
 |  |  | 192 | 192 | 335
 |  |  | 193 | 193 | 335
 |  |  | 194 | 194 | 335
 |  |  | 195 | 195 | 335
 |  |  | 196 | 196 | 335
 |  |  | 197 | 197 | 335
 |  |  | 198 | 198 | 335
 |  |  | 199 | 199 | 335
 |  |  | 200 | 200 | 335
 |  |  | 201 | 201 | 335
 |  |  | 202 | 202 | 335
 |  |  | 203 | 203 | 335
 |  |  | 204 | 204 | 335
 |  |  | 205 | 205 | 335
 |  |  | 206 | 206 | 335
 |  |  | 207 | 207 | 335
 |  |  | 208 | 208 | 335
 |  |  | 209 | 209 | 335
 |  |  | 210 | 210 |  |  | From here apply full 12 months premium (allows for Leap Years)
 |  |  | 211 | 211
 |  |  | 212 | 212
 |  |  | 213 | 213
 |  |  | 214 | 214
 |  |  | 215 | 215
 |  |  | 216 | 216
 |  |  | 217 | 217
 |  |  | 218 | 218
 |  |  | 219 | 219
 |  |  | 220 | 220
 |  |  | 221 | 221
 |  |  | 222 | 222
 |  |  | 223 | 223
 |  |  | 224 | 224
 |  |  | 225 | 225
 |  |  | 226 | 226
 |  |  | 227 | 227
 |  |  | 228 | 228
 |  |  | 229 | 229
 |  |  | 230 | 230
 |  |  | 231 | 231
 |  |  | 232 | 232
 |  |  | 233 | 233
 |  |  | 234 | 234
 |  |  | 235 | 235
 |  |  | 236 | 236
 |  |  | 237 | 237
 |  |  | 238 | 238
 |  |  | 239 | 239
 |  |  | 240 | 240
 |  |  | 241 | 241
 |  |  | 242 | 242
 |  |  | 243 | 243
 |  |  | 244 | 244
 |  |  | 245 | 245
 |  |  | 246 | 246
 |  |  | 247 | 247
 |  |  | 248 | 248
 |  |  | 249 | 249
 |  |  | 250 | 250
 |  |  | 251 | 251
 |  |  | 252 | 252
 |  |  | 253 | 253
 |  |  | 254 | 254
 |  |  | 255 | 255
 |  |  | 256 | 256
 |  |  | 257 | 257
 |  |  | 258 | 258
 |  |  | 259 | 259
 |  |  | 260 | 260
 |  |  | 261 | 261
 |  |  | 262 | 262
 |  |  | 263 | 263
 |  |  | 264 | 264
 |  |  | 265 | 265
 |  |  | 266 | 266
 |  |  | 267 | 267
 |  |  | 268 | 268
 |  |  | 269 | 269
 |  |  | 270 | 270
 |  |  | 271 | 271
 |  |  | 272 | 272
 |  |  | 273 | 273
 |  |  | 274 | 274
 |  |  | 275 | 275
 |  |  | 276 | 276
 |  |  | 277 | 277
 |  |  | 278 | 278
 |  |  | 279 | 279
 |  |  | 280 | 280
 |  |  | 281 | 281
 |  |  | 282 | 282
 |  |  | 283 | 283
 |  |  | 284 | 284
 |  |  | 285 | 285
 |  |  | 286 | 286
 |  |  | 287 | 287
 |  |  | 288 | 288
 |  |  | 289 | 289
 |  |  | 290 | 290
 |  |  | 291 | 291
 |  |  | 292 | 292
 |  |  | 293 | 293
 |  |  | 294 | 294
 |  |  | 295 | 295
 |  |  | 296 | 296
 |  |  | 297 | 297
 |  |  | 298 | 298
 |  |  | 299 | 299
 |  |  | 300 | 300
 |  |  | 301 | 301
 |  |  | 302 | 302
 |  |  | 303 | 303
 |  |  | 304 | 304
 |  |  | 305 | 305
 |  |  | 306 | 306
 |  |  | 307 | 307
 |  |  | 308 | 308
 |  |  | 309 | 309
 |  |  | 310 | 310
 |  |  | 311 | 311
 |  |  | 312 | 312
 |  |  | 313 | 313
 |  |  | 314 | 314
 |  |  | 315 | 315
 |  |  | 316 | 316
 |  |  | 317 | 317
 |  |  | 318 | 318
 |  |  | 319 | 319
 |  |  | 320 | 320
 |  |  | 321 | 321
 |  |  | 322 | 322
 |  |  | 323 | 323
 |  |  | 324 | 324
 |  |  | 325 | 325
 |  |  | 326 | 326
 |  |  | 327 | 327
 |  |  | 328 | 328
 |  |  | 329 | 329
 |  |  | 330 | 330
 |  |  | 331 | 331
 |  |  | 332 | 332
 |  |  | 333 | 333
 |  |  | 334 | 334
 |  |  | 335 | 335
 |  |  | 336 | 336
 |  |  | 337 | 337
 |  |  | 338 | 338
 |  |  | 339 | 339
 |  |  | 340 | 340
 |  |  | 341 | 341
 |  |  | 342 | 342
 |  |  | 343 | 343
 |  |  | 344 | 344
 |  |  | 345 | 345
 |  |  | 346 | 346
 |  |  | 347 | 347
 |  |  | 348 | 348
 |  |  | 349 | 349
 |  |  | 350 | 350
 |  |  | 351 | 351
 |  |  | 352 | 352
 |  |  | 353 | 353
 |  |  | 354 | 354
 |  |  | 355 | 355
 |  |  | 356 | 356
 |  |  | 357 | 357
 |  |  | 358 | 358
 |  |  | 359 | 359
 |  |  | 360 | 360
 |  |  | 361 | 361
 |  |  | 362 | 362
 |  |  | 363 | 363
 |  |  | 364 | 364
 |  |  | 365 | 365
 |  |  | 366 | 366