Spreadsheet: 767238d1644352019-power-query-transforming-and-organizing-very-messy-data-need-help-guidance-bds_example_powquery
Sheet: Glycol Schedules

 |  |  |  |  |  | Drop Down Menus
 | Pale #1 |  |  |  |  | Beer Style | Yeast Strains | Suppliers
 | Step | Temperature | Hours | Note: |  | - | -
 | 1 | 68 | 240 | Knockout Temperature |  |  | Yeast 1
 | 2 | 68 | 240 | Manual Skip to Step 3 after [NAME] |  | Pale #2 | Yeast 2
 | 3 | 68 | 48 | 48 Hour Timer for Dry Hop |  | Pale #3 | Yeast 3
 | 4 | 34 | 240 | Cold Crash |  | Pale #4 | Yeast 4
 | 5 | 34 | 240 | Cold Crash - Safety |  | Pale #5 | Yeast 5
 | 6 | 68 | 240 | N/A |  | Lager #1 | Yeast 6
 |  |  |  |  |  | Lager #2 | Yeast 7
 | Pale #2 |  |  |  |  | Lager #3 | Yeast 8
 | Step | Temperature | Hours | Note: |  | Lager #4 | Yeast 9
 | 1 | 72 | 240 | Knockout Temperature |  | Lager #5 | Yeast 10
 | 2 | 72 | 240 | Manual Skip to Step 3 after [NAME] |  | Stout #1 | Yeast 11
 | 3 | 72 | 48 | 48 Hour Timer for Dry Hop |  | Stout #2 | Yeast 12
 | 4 | 34 | 240 | Cold Crash |  | EXP #3 | Yeast 13
 | 5 | 34 | 240 | Cold Crash - Safety |  | EXP #4 | Yeast 14
 | 6 | 68 | 240 | N/A |  | Exp #5 | Yeast 15
 |  |  |  |  |  | EXP #6
 | Pale #3 |  |  |  |  | EXP #7
 | Step | Temperature | Hours | Note: |  | EXP #8
 | 1 | 70 | 240 | Knockout Temperature |  | EXP #9
 | 2 | 70 | 240 | Manual Skip to Step 3 after [NAME]
 | 3 | 70 | 48 | 48 Hour Timer for Dry Hop
 | 4 | 34 | 240 | Cold Crash
 | 5 | 34 | 240 | Cold Crash - Safety
 | 6 | 68 | 240 | N/A
 | Pale #4
 | Step | Temperature | Hours | Note:
 | 1 | 64 | 72 | Knockout Teperature
 | 2 | 68 | 240 | Manual Skip to Step 3 After Dry Hop
 | 3 | 68 | 48 | 48 Hour Timer for Dry Hop
 | 4 | 34 | 240 | Cold Crash
 | 5 | 34 | 240 | Cold Crash - Safety
 | 6 | 68 | 240 | N/A
 | Pale #5
 | Step | Temperature | Hours | Note:
 | 1 | 65 | 12 | Knockout Temperature
 | 2 | 68 | 240 | Manual Skip to Step 3 After Dry Hop
 | 3 | 68 | 48 | 48 Hour Timer for Dry Hop
 | 4 | 34 | 240 | Cold Crash
 | 5 | 34 | 240 | Cold Crash - Safety
 | 6 | 68 | 240 | N/A
 | Lager #1
 | Step | Temperature | Hours | Note:
 | 1 | 54 | 480 | Knockout
 | 2 | 54 | 240 | Skip to Step 3 when gravity <1.030
 | 3 | 68 | 240 | Skip to Step 4 when no diacetyl and no sulfur
 | 4 | 28.7 | 240 | Cold Crash
 | 5 | 28.7 | 240 | Extended Lager
 | 6 | 68 | 240 | N/A
 | Lager #2
 | Step | Temperature | Hours | Note:
 | 1 | 48 | 336 | [NAME], Setp 2 Once <1.016. Spund @ 0.8 bar
 | 2 | 58 | 240 | Diacetyl Rest
 | 3 | 54 | 24 | Do NOT allow this step until passes diacetly test
 | 4 | 50 | 24 | [NAME]
 | 5 | 40 | 24 | [NAME]
 | 6 | 28 | 480 | Lager, then reset set point to 68 degrees
 | Lager #3
 | Step | Temperature | Hours | Note:
 | 1 | 48 | 12 | [NAME].
 | 2 | 52 | 504 | Free rise to 52F until Gravity has reached <1.025, then skip to Step 3
 | 3 | 68 | 240 | Hold at 68F until cleared from diacetyl and sulfer, then move to step 4
 | 4 | 42 | 96 | Temperature Drop
 | 5 | 30 | 526 | Lager for 12-14 weeks
 | 6 | 30 | 526 | N/A
 | Lager #4
 | Step | Temperature | Hours | Note:
 | 1 | 52 | 24 | [NAME] And Day 1 of Fermentation
 | 2 | 50 | 4 | Automatic, Slow temperature [NAME] to arrive at 48F
 | 3 | 48 | 526 | Ferment at 48F Until Gravity <1.025, then move to step 4
 | 4 | 68 | 526 | Hold Set temp at 68F until clear fro Diacetyl and [NAME], them move to step 5
 | 5 | 58 | 526 | Manually Drop Temperature 2F Per Day until temperatrue hits 30F
 | 6 | 30 | 526 | Lager for 12-14 weeks
 | Lager #5
 | Step | Temperature | Hours | Note:
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | Stout #1
 | Step | Temperature | Hours | Note:
 | 1 | 68 | 240 | Knockout Temperature
 | 2 | 68 | 240 | Fermentation Safety Backup
 | 3 | 68 | 240 | Post Centrifuge, Recirculation Temperature
 | 4 | 34 | 240 | Cold Crash
 | 5 | 34 | 240 | Cold Crash - Safety
 | 6 | 68 | 240 | N/A
 | Stout #2
 | Step | Temperature | Hours | Note:
 | 1 | 65 | 24 | Knockout Temperature
 | 2 | 68 | 240 | Fermentation Safety Back up
 | 3 | 68 | 240 | Post Centrifuge, Recirculation Temprature
 | 4 | 34 | 240 | Cold Crash
 | 5 | 34 | 240 | Cold Crash - Safety
 | 6 | 68 | 240 | Maintain temperature for Barreling
 | Experimental #3
 | Step | Temperature | Hours | Note:
 | 1 | 65 | 12 | Knockout Temperature
 | 2 | 67 | 24 | Temperature Ramp up
 | 3 | 69 | 240 | Manual Skip to step 4 after [NAME]
 | 4 | 70 | 48 | 48 hour timer for [NAME]
 | 5 | 34 | 240 | Cold Crash
 | 6 | 34 | 240 | Cold Crash - Saftey
 | Experimental #4
 | Step | Temperature | Hours | Note:
 | 1 | 72 | 24 | Knockout Temperature - Activity Dependent
 | 2 | 68 | 8 | Slow Temperature Ramp Down
 | 3 | 64 | 240 | Manually Skip to Step 4 Once gravity is <1.025
 | 4 | 70 | 240 | Manually Skip to Step 5 After Dry Hop
 | 5 | 70 | 48 | 48 Hour Timer for Dry Hop
 | 6 | 34 | 526 | Cold Crash
 | Experimental #5
 | Step | Temperature | Hours | Note:
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | Experimental #6
 | Step | Temperature | Hours | Note:
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | Experimental #7
 | Step | Temperature | Hours | Note:
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | Experimental #8
 | Step | Temperature | Hours | Note:
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | Experimental #9
 | Step | Temperature | Hours | Note:
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | Experimental #10
 | Step | Temperature | Hours | Note:
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6