Spreadsheet: 769296d1645456736-can-a-formula-be-modified-to-split-the-results-further-dsm-calving-pattern-v2
Sheet: Sheet1

Number | Next Calving | Sire | Likely [NAME] |  | Week Com | Using all Calves | Using just female calves |  | Week Com | Using only AA Calves | Using just female AA calves
3273 | 2022-04-15 00:00:00 | AA | 50% F |  | 2022-04-04 00:00:00 |  |  |  | 2022-04-04 00:00:00
3457 | 2022-04-16 00:00:00 | AA | 50% F
2614 | 2022-04-17 00:00:00 | AA | 50% F
2719 | 2022-04-17 00:00:00 | BB | 50% F
2769 | 2022-04-18 00:00:00 | AA | 50% F
3119 | 2022-04-20 00:00:00 | HF | 50% F
2871 | 2022-04-23 00:00:00 | AA | 50% F
3057 | 2022-04-24 00:00:00 | AA | 50% F
3315 | 2022-04-24 00:00:00 | HF | 50% F
2618 | 2022-04-25 00:00:00 | AA | 50% F
3252 | 2022-04-25 00:00:00 | HF | F
2668 | 2022-04-28 00:00:00 | AA | 50% F
2819 | 2022-04-28 00:00:00 | AA | 50% F
3295 | 2022-04-30 00:00:00 | HF | 50% F
2833 | 2022-05-01 00:00:00 | AA | 50% F
3475 | 2022-05-01 00:00:00 | HF | F
3071 | 2022-05-02 00:00:00 | HF | 50% F
3088 | 2022-05-02 00:00:00 | HF | 50% F
3484 | 2022-05-02 00:00:00 | HF | F
2952 | 2022-05-04 00:00:00 | AA | 50% F
2613 | 2022-05-05 00:00:00 | AA | 50% F
3283 | 2022-05-05 00:00:00 | HF | F
3289 | 2022-05-06 00:00:00 | HF | 50% F
2805 | 2022-05-07 00:00:00 | AA | 50% F
3260 | 2022-05-09 00:00:00 | HF | 50% F
2807 | 2022-05-11 00:00:00 | AA | 50% F
3299 | 2022-05-11 00:00:00 | HF | 50% F
3246 | 2022-05-12 00:00:00 | HF | F
2065 | 2022-05-13 00:00:00 | AA | 50% F
2369 | 2022-05-13 00:00:00 | AA | 50% F
2958 | 2022-05-13 00:00:00 | AA | 50% F
2767 | 2022-05-14 00:00:00 | AA | 50% F
3005 | 2022-05-16 00:00:00 | AA | 50% F
3291 | 2022-05-16 00:00:00 | HF | 50% F
2706 | 2022-05-18 00:00:00 | AA | 50% F
2863 | 2022-05-18 00:00:00 | AA | 50% F
3109 | 2022-05-18 00:00:00 | AA | 50% F
3452 | 2022-05-18 00:00:00 | HF | 50% F
2879 | 2022-05-19 00:00:00 | AA | 50% F
3117 | 2022-05-19 00:00:00 | AA | 50% F
2559 | 2022-05-20 00:00:00 | AA | 50% F
3340 | 2022-05-20 00:00:00 | HF | F
3429 | 2022-05-20 00:00:00 | HF | F
3282 | 2022-05-21 00:00:00 | HF | 50% F
2182 | 2022-05-23 00:00:00 | AA | 50% F
2867 | 2022-05-23 00:00:00 | AA | 50% F
3267 | 2022-05-23 00:00:00 | AA | 50% F
2245 | 2022-05-24 00:00:00 | AA | 50% F
2553 | 2022-05-24 00:00:00 | AA | 50% F
3027 | 2022-05-24 00:00:00 | HF | 50% F
3302 | 2022-05-24 00:00:00 | AA | 50% F
3508 | 2022-05-24 00:00:00 | HF | F
3520 | 2022-05-24 00:00:00 | HF | F
2322 | 2022-05-26 00:00:00 | AA | 50% F
3065 | 2022-05-27 00:00:00 | AA | 50% F
3432 | 2022-05-27 00:00:00 | HF | F
3505 | 2022-05-28 00:00:00 | HF | F
2316 | 2022-05-30 00:00:00 | AA | 50% F
2543 | 2022-05-30 00:00:00 | AA | 50% F
3341 | 2022-05-30 00:00:00 | HF | 50% F
3478 | 2022-05-31 00:00:00 | HF | F
2877 | 2022-06-01 00:00:00 | HF | 50% F
2251 | 2022-06-02 00:00:00 | AA | 50% F
2838 | 2022-06-02 00:00:00 | AA | 50% F
3130 | 2022-06-02 00:00:00 | HF | 50% F
2463 | 2022-06-03 00:00:00 | AA | 50% F
2469 | 2022-06-03 00:00:00 | AA | 50% F
2939 | 2022-06-03 00:00:00 | AA | 50% F
3064 | 2022-06-04 00:00:00 | HF | 50% F
3437 | 2022-06-06 00:00:00 | HF | F
3482 | 2022-06-06 00:00:00 | HF | F
3488 | 2022-06-06 00:00:00 | HF | F
3499 | 2022-06-06 00:00:00 | HF | F
3526 | 2022-06-06 00:00:00 | HF | F
3552 | 2022-06-06 00:00:00 | HF | F
2860 | 2022-06-07 00:00:00 | AA | 50% F
2901 | 2022-06-07 00:00:00 | AA | 50% F
2856 | 2022-06-08 00:00:00 | AA | 50% F
1788 | 2022-06-09 00:00:00 | AA | 50% F
3058 | 2022-06-09 00:00:00 | AA | 50% F
3502 | 2022-06-09 00:00:00 | HF | F
3459 | 2022-06-10 00:00:00 | HF | F
3529 | 2022-06-10 00:00:00 | HF | F
2046 | 2022-06-12 00:00:00 | AA | 50% F
2862 | 2022-06-12 00:00:00 | AA | 50% F
3107 | 2022-06-12 00:00:00 | AA | 50% F
3287 | 2022-06-12 00:00:00 | HF | 50% F
3514 | 2022-06-14 00:00:00 | HF | F
3504 | 2022-06-15 00:00:00 | HF | F
2848 | 2022-06-16 00:00:00 | AA | 50% F
2903 | 2022-06-16 00:00:00 | AA | 50% F
3438 | 2022-06-16 00:00:00 | AA | 50% F
2490 | 2022-06-17 00:00:00 | AA | 50% F
3338 | 2022-06-17 00:00:00 | HF | F
2133 | 2022-06-18 00:00:00 | AA | 50% F
3491 | 2022-06-18 00:00:00 | HF | F
2934 | 2022-06-19 00:00:00 | AA | 50% F
3121 | 2022-06-19 00:00:00 | HF | 50% F
3539 | 2022-06-19 00:00:00 | HF | F
2928 | 2022-06-20 00:00:00 | AA | 50% F
3072 | 2022-06-21 00:00:00 | HF | F
3305 | 2022-06-21 00:00:00 | HF | F
3536 | 2022-06-22 00:00:00 | AA | 50% F
3181 | 2022-06-23 00:00:00 | HF | 50% F
3308 | 2022-06-23 00:00:00 | HF | 50% F
3501 | 2022-06-24 00:00:00 | HF | F
3510 | 2022-06-24 00:00:00 | HF | F
3344 | 2022-06-25 00:00:00 | HF | 50% F
3500 | 2022-06-26 00:00:00 | HF | F
3509 | 2022-06-26 00:00:00 | HF | F
3095 | 2022-06-27 00:00:00 | HF | 50% F
3118 | 2022-06-27 00:00:00 | HF | 50% F
3165 | 2022-06-27 00:00:00 | HF | 50% F
3548 | 2022-06-27 00:00:00 | HF | F
3272 | 2022-06-28 00:00:00 | HF | 50% F
3458 | 2022-06-28 00:00:00 | AA | 50% F
3540 | 2022-06-28 00:00:00 | HF | F
2880 | 2022-06-30 00:00:00 | AA | 50% F
3364 | 2022-06-30 00:00:00 | HF | F
2906 | 2022-07-01 00:00:00 | AA | 50% F
3073 | 2022-07-01 00:00:00 | AA | 50% F
3343 | 2022-07-01 00:00:00 | HF | 50% F
2759 | 2022-07-02 00:00:00 | AA | 50% F
3361 | 2022-07-02 00:00:00 | HF | 50% F
3142 | 2022-07-03 00:00:00 | HF | 50% F
3306 | 2022-07-03 00:00:00 | HF | 50% F
3312 | 2022-07-04 00:00:00 | HF | 50% F
2367 | 2022-07-06 00:00:00 | AA | 50% F
2661 | 2022-07-06 00:00:00 | AA | 50% F
3054 | 2022-07-06 00:00:00 | AA | 50% F
3175 | 2022-07-07 00:00:00 | HF | 50% F
3311 | 2022-07-07 00:00:00 | HF | 50% F
3350 | 2022-07-07 00:00:00 | HF | F
3486 | 2022-07-07 00:00:00 | AA | 50% F
2841 | 2022-07-08 00:00:00 | AA | 50% F
3190 | 2022-07-08 00:00:00 | HF | F
3322 | 2022-07-08 00:00:00 | HF | 50% F
3362 | 2022-07-08 00:00:00 | HF | 50% F
3160 | 2022-07-09 00:00:00 | HF | F
2072 | 2022-07-10 00:00:00 | AA | 50% F
2851 | 2022-07-10 00:00:00 | AA | 50% F
3066 | 2022-07-10 00:00:00 | AA | 50% F
2730 | 2022-07-11 00:00:00 | AA | 50% F
2778 | 2022-07-11 00:00:00 | AA | 50% F
2840 | 2022-07-11 00:00:00 | AA | 50% F
3277 | 2022-07-11 00:00:00 | HF | 50% F
2854 | 2022-07-12 00:00:00 | AA | 50% F
3314 | 2022-07-12 00:00:00 | HF | 50% F
2208 | 2022-07-13 00:00:00 | AA | 50% F
3083 | 2022-07-13 00:00:00 | HF | 50% F
3149 | 2022-07-13 00:00:00 | HF | 50% F
2798 | 2022-07-14 00:00:00 | AA | 50% F
2576 | 2022-07-15 00:00:00 | AA | 50% F
3263 | 2022-07-15 00:00:00 | HF | 50% F
2237 | 2022-07-16 00:00:00 | AA | 50% F
3542 | 2022-07-17 00:00:00 | HF | F
3159 | 2022-07-19 00:00:00 | HF | 50% F
3242 | 2022-07-20 00:00:00 | AA | 50% F
2846 | 2022-07-21 00:00:00 | AA | 50% F
3148 | 2022-07-21 00:00:00 | AA | 50% F
2855 | 2022-07-22 00:00:00 | AA | 50% F
3506 | 2022-07-22 00:00:00 | AA | 50% F
2274 | 2022-07-23 00:00:00 | AA | 50% F
3110 | 2022-07-23 00:00:00 | HF | F
3132 | 2022-07-24 00:00:00 | HF | F
3551 | 2022-07-24 00:00:00 | HF | F
2607 | 2022-07-25 00:00:00 | AA | 50% F
2678 | 2022-07-25 00:00:00 | AA | 50% F
3522 | 2022-07-25 00:00:00 | HF | F
3124 | 2022-07-27 00:00:00 | HF | 50% F
2596 | 2022-07-28 00:00:00 | AA | 50% F
3186 | 2022-07-30 00:00:00 | HF | F
3544 | 2022-07-30 00:00:00 | AA | 50% F
3571 | 2022-07-30 00:00:00 | AA | 50% F
3122 | 2022-08-02 00:00:00 | AA | 50% F
3332 | 2022-08-02 00:00:00 | HF | F
3525 | 2022-08-02 00:00:00 | AA | 50% F
2402 | 2022-08-03 00:00:00 | AA | 50% F
3357 | 2022-08-03 00:00:00 | AA | 50% F
3556 | 2022-08-04 00:00:00 | HF | F
2823 | 2022-08-05 00:00:00 | AA | 50% F
3145 | 2022-08-05 00:00:00 | HF | 50% F
3335 | 2022-08-05 00:00:00 | HF | 50% F
3374 | 2022-08-05 00:00:00 | HF | F
3498 | 2022-08-05 00:00:00 | AA | 50% F
2535 | 2022-08-06 00:00:00 | AA | 50% F
3151 | 2022-08-06 00:00:00 | HF | F
3524 | 2022-08-06 00:00:00 | AA | 50% F
2460 | 2022-08-07 00:00:00 | AA | 50% F
3545 | 2022-08-07 00:00:00 | HF | F
3127 | 2022-08-09 00:00:00 | AA | 50% F
3513 | 2022-08-10 00:00:00 | HF | F
3535 | 2022-08-10 00:00:00 | HF | F
2060 | 2022-08-11 00:00:00 | AA | 50% F
3047 | 2022-08-11 00:00:00 | AA | 50% F
3250 | 2022-08-12 00:00:00 | AA | 50% F
2179 | 2022-08-14 00:00:00 | AA | 50% F
2883 | 2022-08-14 00:00:00 | AA | 50% F
3575 | 2022-08-14 00:00:00 | HF | F
2852 | 2022-08-16 00:00:00 | AA | 50% F
3103 | 2022-08-16 00:00:00 | AA | 50% F
3255 | 2022-08-16 00:00:00 | HF | F
2693 | 2022-08-17 00:00:00 | AA | 50% F
3324 | 2022-08-17 00:00:00 | HF | 50% F
3367 | 2022-08-17 00:00:00 | HF | 50% F
3531 | 2022-08-17 00:00:00 | AA | 50% F
3564 | 2022-08-17 00:00:00 | HF | F
2834 | 2022-08-18 00:00:00 | AA | 50% F
3153 | 2022-08-18 00:00:00 | AA | 50% F
2058 | 2022-08-19 00:00:00 | AA | 50% F
2253 | 2022-08-19 00:00:00 | AA | 50% F
2715 | 2022-08-19 00:00:00 | AA | 50% F
3298 | 2022-08-19 00:00:00 | HF | 50% F
3330 | 2022-08-19 00:00:00 | HF | 50% F
3546 | 2022-08-19 00:00:00 | HF | F
3550 | 2022-08-19 00:00:00 | HF | F
3567 | 2022-08-19 00:00:00 | HF | F
3134 | 2022-08-20 00:00:00 | AA | 50% F
3180 | 2022-08-20 00:00:00 | HF | F
3553 | 2022-08-20 00:00:00 | HF | F
2059 | 2022-08-21 00:00:00 | AA | 50% F
2689 | 2022-08-21 00:00:00 | AA | 50% F
2332 | 2022-08-22 00:00:00 | AA | 50% F
3001 | 2022-08-23 00:00:00 | AA | 50% F
3129 | 2022-08-25 00:00:00 | HF | F
2710 | 2022-08-26 00:00:00 | AA | 50% F
2914 | 2022-08-26 00:00:00 | AA | 50% F
3394 | 2022-08-27 00:00:00 | HF | F
3100 | 2022-08-28 00:00:00 | HF | 50% F
3120 | 2022-08-28 00:00:00 | AA | 50% F
3123 | 2022-08-28 00:00:00 | AA | 50% F
3166 | 2022-08-28 00:00:00 | AA | 50% F
2974 | 2022-08-29 00:00:00 | BB | 50% F
3389 | 2022-08-29 00:00:00 | HF | 50% F
2875 | 2022-08-31 00:00:00 | AA | 50% F
3193 | 2022-08-31 00:00:00 | AA | 50% F
3356 | 2022-08-31 00:00:00 | HF | 50% F
3034 | 2022-09-01 00:00:00 | AA | 50% F
2982 | 2022-09-02 00:00:00 | AA | 50% F
3155 | 2022-09-02 00:00:00 | AA | 50% F
3391 | 2022-09-02 00:00:00 | HF | 50% F
3579 | 2022-09-03 00:00:00 | AA | 50% F
3092 | 2022-09-04 00:00:00 | HF | F
3318 | 2022-09-04 00:00:00 | HF | F
2609 | 2022-09-05 00:00:00 | AA | 50% F
3176 | 2022-09-05 00:00:00 | AA | 50% F
3222 | 2022-09-05 00:00:00 | HF | 50% F
3534 | 2022-09-05 00:00:00 | HF | F
3512 | 2022-09-07 00:00:00 | HF | F
3527 | 2022-09-07 00:00:00 | HF | F
3528 | 2022-09-07 00:00:00 | HF | F
3543 | 2022-09-07 00:00:00 | HF | F
2789 | 2022-09-08 00:00:00 | AA | 50% F
2273 | 2022-09-09 00:00:00 | AA | F
2370 | 2022-09-09 00:00:00 | AA | 50% F
3169 | 2022-09-09 00:00:00 | HF | 50% F
3345 | 2022-09-09 00:00:00 | HF | 50% F
3349 | 2022-09-09 00:00:00 | HF | 50% F
3393 | 2022-09-09 00:00:00 | HF | F
2278 | 2022-09-10 00:00:00 | AA | 50% F
3382 | 2022-09-10 00:00:00 | HF | 50% F
3353 | 2022-09-11 00:00:00 | HF | 50% F
3021 | 2022-09-12 00:00:00 | AA | 50% F
3191 | 2022-09-12 00:00:00 | HF | 50% F
3358 | 2022-09-12 00:00:00 | HF | 50% F
2641 | 2022-09-13 00:00:00 | AA | 50% F
2676 | 2022-09-16 00:00:00 | AA | 50% F
2550 | 2022-09-17 00:00:00 | AA | 50% F
2893 | 2022-09-17 00:00:00 | AA | 50% F
3069 | 2022-09-17 00:00:00 | HF | F
3377 | 2022-09-17 00:00:00 | HF | F
3339 | 2022-09-18 00:00:00 | HF | 50% F
3167 | 2022-09-20 00:00:00 | HF | 50% F
3346 | 2022-09-20 00:00:00 | HF | 50% F
3578 | 2022-09-21 00:00:00 | HF | F
3594 | 2022-09-21 00:00:00 | HF | F
3178 | 2022-09-22 00:00:00 | HF | 50% F
3197 | 2022-09-22 00:00:00 | HF | 50% F
3220 | 2022-09-22 00:00:00 | HF | F
3146 | 2022-09-23 00:00:00 | AA | 50% F
3207 | 2022-09-24 00:00:00 | HF | 50% F
2648 | 2022-09-26 00:00:00 | AA | 50% F
3189 | 2022-09-27 00:00:00 | HF | F
3386 | 2022-09-27 00:00:00 | HF | 50% F
3570 | 2022-09-27 00:00:00 | HF | F
2874 | 2022-09-29 00:00:00 | AA | 50% F
3184 | 2022-09-30 00:00:00 | HF | 50% F
3307 | 2022-09-30 00:00:00 | AA | 50% F
3376 | 2022-09-30 00:00:00 | HF | F
3489 | 2022-09-30 00:00:00 | HF | F
3558 | 2022-09-30 00:00:00 | HF | F
3592 | 2022-09-30 00:00:00 | HF | F
3604 | 2022-09-30 00:00:00 | HF | F
3195 | 2022-10-01 00:00:00 | HF | F
3231 | 2022-10-01 00:00:00 | HF | 50% F
3147 | 2022-10-02 00:00:00 | HF | F
3200 | 2022-10-02 00:00:00 | HF | 50% F
3228 | 2022-10-02 00:00:00 | HF | F
3584 | 2022-10-04 00:00:00 | HF | F
3331 | 2022-10-06 00:00:00 | AA | 50% F
3563 | 2022-10-06 00:00:00 | HF | F
2616 | 2022-10-07 00:00:00 | AA | 50% F
3187 | 2022-10-07 00:00:00 | HF | 50% F
3060 | 2022-10-08 00:00:00 | AA | 50% F
3125 | 2022-10-08 00:00:00 | HF | F
3515 | 2022-10-08 00:00:00 | AA | 50% F
3541 | 2022-10-08 00:00:00 | AA | 50% F
2842 | 2022-10-09 00:00:00 | AA | 50% F
3293 | 2022-10-09 00:00:00 | AA | 50% F
3572 | 2022-10-10 00:00:00 | AA | 50% F
3334 | 2022-10-11 00:00:00 | AA | 50% F
3368 | 2022-10-11 00:00:00 | HF | 50% F
3605 | 2022-10-12 00:00:00 | HF | F
2828 | 2022-10-13 00:00:00 | AA | 50% F
3077 | 2022-10-13 00:00:00 | HF | 50% F
2679 | 2022-10-14 00:00:00 | AA | 50% F
3211 | 2022-10-14 00:00:00 | AA | 50% F
3316 | 2022-10-14 00:00:00 | AA | 50% F
2882 | 2022-10-15 00:00:00 | AA | 50% F
3518 | 2022-10-15 00:00:00 | AA | 50% F
3533 | 2022-10-15 00:00:00 | AA | 50% F
2824 | 2022-10-17 00:00:00 | BB | 50% F
3588 | 2022-10-17 00:00:00 | HF | F
3590 | 2022-10-17 00:00:00 | HF | F
3549 | 2022-10-18 00:00:00 | HF | 50% F
3517 | 2022-10-22 00:00:00 | AA | 50% F