Spreadsheet: 784118d1655458427-index-and-match-formula-not-working-im-in-over-my-head-audit-schedule-aligw
Sheet: Yearly Plan

 |  | AUDIT SCHEDULE
 |  | UNIT |  |  |  |  |  |  |  |  |  |  |  | TANK
WEEK |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27
 |  | 44T IVECO | 44T IVECO | 44T IVECO | 44T IVECO | 44T IVECO | 44T IVECO | 44T IVECO | 44T IVECO | 44T IVECO | 44T IVECO | 44T IVECO |  | TANKER | TANKER | TANKER | TANKER | TANKER | TANKER | TANKER | TANKER | TANKER | TANKER | TANKER | TANKER | TANKER | TANKER | TANKER | TANKER
2243 | 2022-06-19 00:00:00 | X | X | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2244 |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2245 |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2246 |  | X |  |  |  |  |  |  |  |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2247 |  |  | X | X | X |  |  |  |  |  |  |  |  | X | X | X | X
2248 |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2249 |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2250 |  | X | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2251 |  |  |  | X | X | X |  |  |  |  |  |  |  | X | X | X | X
2252 |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  | X | X | X | X
2301 |  |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2302 |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2303 |  |  |  |  | X | X | X |  |  |  |  |  |  | X | X | X | X
2304 |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  | X | X | X | X
2305 |  | X |  |  |  |  |  |  |  |  | X | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2306 |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2307 |  |  |  |  |  | X | X | X |  |  |  |  |  | X | X | X | X
2308 |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  | X | X | X | X
2309 |  | X | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2310 |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2311 |  |  |  |  |  |  | X | X | X |  |  |  |  | X | X | X | X
2312 |  |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  | X | X | X | X
2313 |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2314 |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2315 |  |  |  |  |  |  |  | X | X | X |  |  |  | X | X | X | X
2316 |  | X |  |  |  |  |  |  |  |  | X | X |  |  |  |  |  | X | X | X | X
2317 |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2318 |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2319 |  |  |  |  |  |  |  |  | X | X | X |  |  | X | X | X | X
2320 |  | X | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  | X | X | X | X
2321 |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2322 |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2323 |  |  |  |  |  |  |  |  |  | X | X | X |  | X | X | X | X
2324 |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2325 |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2326 |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2327 |  | X |  |  |  |  |  |  |  |  | X | X |  | X | X | X | X
2328 |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2329 |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2330 |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2331 |  | X | X |  |  |  |  |  |  |  |  | X |  | X | X | X | X
2332 |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2333 |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2334 |  |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2335 |  | X | X | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2336 |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2337 |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2338 |  | X |  |  |  |  |  |  |  |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2339 |  |  | X | X | X |  |  |  |  |  |  |  |  | X | X | X | X
2340 |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2341 |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2342 |  | X | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2343 |  |  |  | X | X | X |  |  |  |  |  |  |  | X | X | X | X
2344 |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  | X | X | X | X
2345 |  |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2346 |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2347 |  |  |  |  | X | X | X |  |  |  |  |  |  | X | X | X | X
2348 |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  | X | X | X | X
2349 |  | X |  |  |  |  |  |  |  |  | X | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2350 |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2351 |  |  |  |  |  | X | X | X |  |  |  |  |  | X | X | X | X
2352 |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  | X | X | X | X
2401 |  | X | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2402 |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2403 |  |  |  |  |  |  | X | X | X |  |  |  |  | X | X | X | X
2404 |  |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  | X | X | X | X
2405 |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2406 |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2407 |  |  |  |  |  |  |  | X | X | X |  |  |  | X | X | X | X
2408 |  | X |  |  |  |  |  |  |  |  | X | X |  |  |  |  |  | X | X | X | X
2409 |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2410 |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2411 |  |  |  |  |  |  |  |  | X | X | X |  |  | X | X | X | X
2412 |  | X | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  | X | X | X | X
2413 |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2414 |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2415 |  |  |  |  |  |  |  |  |  | X | X | X |  | X | X | X | X
2416 |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2417 |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2418 |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2419 |  | X |  |  |  |  |  |  |  |  | X | X |  | X | X | X | X
2420 |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2421 |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2422 |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2423 |  | X | X |  |  |  |  |  |  |  |  | X |  | X | X | X | X
2424 |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2425 |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2426 |  |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2427 |  | X | X | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2428 |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2429 |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2430 |  | X |  |  |  |  |  |  |  |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2431 |  |  | X | X | X |  |  |  |  |  |  |  |  | X | X | X | X
2432 |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2433 |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2434 |  | X | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2435 |  |  |  | X | X | X |  |  |  |  |  |  |  | X | X | X | X
2436 |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  | X | X | X | X
2437 |  |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2438 |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2439 |  |  |  |  | X | X | X |  |  |  |  |  |  | X | X | X | X
2440 |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  | X | X | X | X
2441 |  | X |  |  |  |  |  |  |  |  | X | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2442 |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2443 |  |  |  |  |  | X | X | X |  |  |  |  |  | X | X | X | X
2444 |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  | X | X | X | X
2445 |  | X | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2446 |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2447 |  |  |  |  |  |  | X | X | X |  |  |  |  | X | X | X | X
2448 |  |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  | X | X | X | X
2449 |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2450 |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2451 |  |  |  |  |  |  |  | X | X | X |  |  |  | X | X | X | X
2452 |  | X |  |  |  |  |  |  |  |  | X | X |  |  |  |  |  | X | X | X | X
2501 |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2502 |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2503 |  |  |  |  |  |  |  |  | X | X | X |  |  | X | X | X | X
2504 |  | X | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  | X | X | X | X
2505 |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2506 |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2507 |  |  |  |  |  |  |  |  |  | X | X | X |  | X | X | X | X
2508 |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2509 |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2510 |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2511 |  | X |  |  |  |  |  |  |  |  | X | X |  | X | X | X | X
2512 |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2513 |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2514 |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2515 |  | X | X |  |  |  |  |  |  |  |  | X |  | X | X | X | X
2516 |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2517 |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2518 |  |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2519 |  | X | X | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2520 |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2521 |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2522 |  | X |  |  |  |  |  |  |  |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2523 |  |  | X | X | X |  |  |  |  |  |  |  |  | X | X | X | X
2524 |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2525 |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2526 |  | X | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2527 |  |  |  | X | X | X |  |  |  |  |  |  |  | X | X | X | X
2528 |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  | X | X | X | X
2529 |  |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2530 |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2531 |  |  |  |  | X | X | X |  |  |  |  |  |  | X | X | X | X
2532 |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  | X | X | X | X
2533 |  | X |  |  |  |  |  |  |  |  | X | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2534 |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2535 |  |  |  |  |  | X | X | X |  |  |  |  |  | X | X | X | X
2536 |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  | X | X | X | X
2537 |  | X | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  | X | X | X | X
2538 |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2539 |  |  |  |  |  |  | X | X | X |  |  |  |  | X | X | X | X
2540 |  |  |  |  |  |  |  |  |  | X | X | X |  |  |  |  |  | X | X | X | X
2541 |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2542 |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2543 |  |  |  |  |  |  |  | X | X | X |  |  |  | X | X | X | X
2544 |  | X |  |  |  |  |  |  |  |  | X | X |  |  |  |  |  | X | X | X | X
2545 |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2546 |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2547 |  |  |  |  |  |  |  |  | X | X | X |  |  | X | X | X | X
2548 |  | X | X |  |  |  |  |  |  |  |  | X |  |  |  |  |  | X | X | X | X
2549 |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2550 |  |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
2551 |  |  |  |  |  |  |  |  |  | X | X | X |  | X | X | X | X
2552 |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X