VBA
11.06.2021 16:18:53
Markus
Und zwar läuft das Programm durch aber ab V9 trifft VBA die Falsche Auswahl. Ich habe das Programm Step bei Step Laufen lassen und da macht es die Entscheidungen richtig. Kann mir jemand ein Tip geben? Würde gerne das Excel Teilen jedoch kriege ich es nicht unter 300kB.
Danke schon mal für eure Tips
If MW_prod_FillerV1 / SW_prod_FillerV1 > 1 And Tank_SpringwaterV0 < Tank_MineralwaterV0 Then GoTo V1_Line1 Else GoTo V1_Line2
V1_Line1:
Range("F17").Value = Range("F14").Value * (2 / 3)
Range("F18").Value = Range("F14").Value * (1 / 3)
GoTo V1_LineEND
V1_Line2:
If MW_prod_FillerV1 / SW_prod_FillerV1 < 0.1 And MW_prod_FillerV1 / SW_prod_FillerV1 < 1 And Tank_SpringwaterV0 <= Tank_MineralwaterV0 Then GoTo V1_Line3 Else GoTo V1_Line4
V1_Line3:
Range("F17").Value = Range("F14").Value * (1)
Range("F18").Value = Range("F14").Value * (0)
GoTo V1_LineEND
V1_Line4:
If MW_prod_FillerV1 / SW_prod_FillerV1 < 0.1 And MW_prod_FillerV1 / SW_prod_FillerV1 < 1 And Tank_SpringwaterV0 >= Tank_MineralwaterV0 Then GoTo V1_Line5 Else GoTo V1_Line6
V1_Line5:
Range("F17").Value = Range("F14").Value * (0)
Range("F18").Value = Range("F14").Value * (1)
GoTo V1_LineEND
V1_Line6:
If MW_prod_FillerV1 / SW_prod_FillerV1 > 0.1 And MW_prod_FillerV1 / SW_prod_FillerV1 < 1 And Tank_SpringwaterV0 >= Tank_MineralwaterV0 Then GoTo V1_Line7 Else GoTo V1_Line8
V1_Line7:
Range("F17").Value = Range("F14").Value * (0)
Range("F18").Value = Range("F14").Value * (1)
GoTo V1_LineEND
V1_Line8:
If MW_prod_FillerV1 / SW_prod_FillerV1 > 0.1 And MW_prod_FillerV1 / SW_prod_FillerV1 < 1 And Tank_SpringwaterV0 <= Tank_MineralwaterV0 Then GoTo V1_Line9 Else GoTo V1_Line10
V1_Line9:
Range("F17").Value = Range("F14").Value * (1)
Range("F18").Value = Range("F14").Value * (0)
GoTo V1_LineEND
V1_Line10:
If MW_prod_FillerV1 / SW_prod_FillerV1 < 1 And MW_prod_FillerV1 / SW_prod_FillerV1 > 0.1 Then GoTo V1_Line11 Else GoTo V1_Line12
V1_Line11:
Range("F17").Value = Range("F14").Value / 2
Range("F18").Value = Range("F14").Value / 2
GoTo V1_LineEND
V1_Line12:
If MW_prod_FillerV1 / SW_prod_FillerV1 > 1 And Tank_SpringwaterV0 >= Tank_MineralwaterV0 Then GoTo V1_Line13
V1_Line13:
Range("F17").Value = Range("F14").Value * (1 / 3)
Range("F18").Value = Range("F14").Value * (2 / 3)
GoTo V1_LineEND
V1_LineEND:
If MW_prod_FillerV2 / SW_prod_FillerV2 > 1 And Tank_SpringwaterV1 < Tank_MineralwaterV1 Then GoTo V2_Line1 Else GoTo V2_Line2
V2_Line1:
Range("G17").Value = Range("G14").Value * (2 / 3)
Range("G18").Value = Range("G14").Value * (1 / 3)
GoTo V2_LineEND
V2_Line2:
If MW_prod_FillerV2 / SW_prod_FillerV2 < 0.1 And MW_prod_FillerV2 / SW_prod_FillerV2 < 1 And Tank_SpringwaterV1 <= Tank_MineralwaterV1 Then GoTo V2_Line3 Else GoTo V2_Line4
V2_Line3:
Range("G17").Value = Range("G14").Value * (1)
Range("G18").Value = Range("G14").Value * (0)
GoTo V2_LineEND
V2_Line4:
If MW_prod_FillerV2 / SW_prod_FillerV2 < 0.1 And MW_prod_FillerV2 / SW_prod_FillerV2 < 1 And Tank_SpringwaterV1 >= Tank_MineralwaterV1 Then GoTo V2_Line5 Else GoTo V2_Line6
V2_Line5:
Range("G17").Value = Range("G14").Value * (0)
Range("G18").Value = Range("G14").Value * (1)
GoTo V2_LineEND
V2_Line6:
If MW_prod_FillerV2 / SW_prod_FillerV2 > 0.1 And MW_prod_FillerV2 / SW_prod_FillerV2 < 1 And Tank_SpringwaterV1 >= Tank_MineralwaterV1 Then GoTo V2_Line7 Else GoTo V2_Line8
V2_Line7:
Range("G17").Value = Range("G14").Value * (0)
Range("G18").Value = Range("G14").Value * (1)
GoTo V2_LineEND
V2_Line8:
If MW_prod_FillerV2 / SW_prod_FillerV2 > 0.1 And MW_prod_FillerV2 / SW_prod_FillerV2 < 1 And Tank_SpringwaterV1 <= Tank_MineralwaterV1 Then GoTo V2_Line9 Else GoTo V2_Line10
V2_Line9:
Range("G17").Value = Range("G14").Value * (1)
Range("G18").Value = Range("G14").Value * (0)
GoTo V2_LineEND
V2_Line10:
If MW_prod_FillerV2 / SW_prod_FillerV2 < 1 And MW_prod_FillerV2 / SW_prod_FillerV2 > 0.1 Then GoTo V2_Line11 Else GoTo V2_Line12
V2_Line11:
Range("G17").Value = Range("G14").Value / 2
Range("G18").Value = Range("G14").Value / 2
GoTo V2_LineEND
V2_Line12:
If MW_prod_FillerV2 / SW_prod_FillerV2 > 1 And Tank_SpringwaterV1 >= Tank_MineralwaterV1 Then GoTo V2_Line13
V2_Line13:
Range("G17").Value = Range("G14").Value * (1 / 3)
Range("G18").Value = Range("G14").Value * (2 / 3)
GoTo V2_LineEND
V2_LineEND:
If MW_prod_FillerV3 / SW_prod_FillerV3 > 1 And Tank_SpringwaterV2 < Tank_MineralwaterV2 Then GoTo V3_Line1 Else GoTo V3_Line2
V3_Line1:
Range("H17").Value = Range("H14").Value * (2 / 3)
Range("H18").Value = Range("H14").Value * (1 / 3)
GoTo V3_LineEND
V3_Line2:
If MW_prod_FillerV3 / SW_prod_FillerV3 < 0.1 And MW_prod_FillerV3 / SW_prod_FillerV3 < 1 And Tank_SpringwaterV2 <= Tank_MineralwaterV2 Then GoTo V3_Line3 Else GoTo V3_Line4
V3_Line3:
Range("H17").Value = Range("H14").Value * (1)
Range("H18").Value = Range("H14").Value * (0)
'GoTo V3_LineEND
V3_Line4:
If MW_prod_FillerV3 / SW_prod_FillerV3 < 0.1 And MW_prod_FillerV3 / SW_prod_FillerV3 < 1 And Tank_SpringwaterV2 >= Tank_MineralwaterV2 Then GoTo V3_Line5 Else GoTo V3_Line6
V3_Line5:
Range("H17").Value = Range("H14").Value * (0)
Range("H18").Value = Range("H14").Value * (1)
GoTo V3_LineEND
V3_Line6:
If MW_prod_FillerV3 / SW_prod_FillerV3 > 0.1 And MW_prod_FillerV3 / SW_prod_FillerV3 < 1 And Tank_SpringwaterV2 >= Tank_MineralwaterV2 Then GoTo V3_Line7 Else GoTo V3_Line8
V3_Line7:
Range("H17").Value = Range("H14").Value * (0)
Range("H18").Value = Range("H14").Value * (1)
GoTo V3_LineEND
V3_Line8:
If MW_prod_FillerV3 / SW_prod_FillerV3 > 0.1 And MW_prod_FillerV3 / SW_prod_FillerV3 < 1 And Tank_SpringwaterV2 <= Tank_MineralwaterV2 Then GoTo V3_Line9 Else GoTo V3_Line10
V3_Line9:
Range("H17").Value = Range("H14").Value * (1)
Range("H18").Value = Range("H14").Value * (0)
GoTo V3_LineEND
V3_Line10:
If MW_prod_FillerV3 / SW_prod_FillerV3 < 1 And MW_prod_FillerV3 / SW_prod_FillerV3 > 0.1 Then GoTo V3_Line11 Else GoTo V3_Line12
V3_Line11:
Range("H17").Value = Range("H14").Value / 2
Range("H18").Value = Range("H14").Value / 2
GoTo V3_LineEND
V3_Line12:
If MW_prod_FillerV3 / SW_prod_FillerV3 > 1 And Tank_SpringwaterV2 >= Tank_MineralwaterV2 Then GoTo V3_Line13
V3_Line13:
Range("H17").Value = Range("H14").Value * (1 / 3)
Range("H18").Value = Range("H14").Value * (2 / 3)
GoTo V3_LineEND
V3_LineEND:
If MW_prod_FillerV4 / SW_prod_FillerV4 > 1 And Tank_SpringwaterV3 < Tank_MineralwaterV3 Then GoTo V4_Line1 Else GoTo V4_Line2
V4_Line1:
Range("I17").Value = Range("I14").Value * (2 / 3)
Range("I18").Value = Range("I14").Value * (1 / 3)
GoTo V4_LineEND
V4_Line2:
If MW_prod_FillerV4 / SW_prod_FillerV4 < 0.1 And MW_prod_FillerV4 / SW_prod_FillerV4 < 1 And Tank_SpringwaterV3 <= Tank_MineralwaterV3 Then GoTo V4_Line3 Else GoTo V4_Line4
V4_Line3:
Range("I17").Value = Range("I14").Value * (1)
Range("I18").Value = Range("I14").Value * (0)
GoTo V4_LineEND
V4_Line4:
If MW_prod_FillerV4 / SW_prod_FillerV4 < 0.1 And MW_prod_FillerV4 / SW_prod_FillerV4 < 1 And Tank_SpringwaterV3 >= Tank_MineralwaterV3 Then GoTo V4_Line5 Else GoTo V4_Line6
V4_Line5:
Range("I17").Value = Range("I14").Value * (0)
Range("I18").Value = Range("I14").Value * (1)
GoTo V4_LineEND
V4_Line6:
If MW_prod_FillerV4 / SW_prod_FillerV4 > 0.1 And MW_prod_FillerV4 / SW_prod_FillerV4 < 1 And Tank_SpringwaterV3 >= Tank_MineralwaterV3 Then GoTo V4_Line7 Else GoTo V4_Line8
V4_Line7:
Range("I17").Value = Range("I14").Value * (0)
Range("I18").Value = Range("I14").Value * (1)
GoTo V4_LineEND
V4_Line8:
If MW_prod_FillerV4 / SW_prod_FillerV4 > 0.1 And MW_prod_FillerV4 / SW_prod_FillerV4 < 1 And Tank_SpringwaterV3 <= Tank_MineralwaterV3 Then GoTo V4_Line9 Else GoTo V4_Line10
V4_Line9:
Range("I17").Value = Range("I14").Value * (1)
Range("I18").Value = Range("I14").Value * (0)
GoTo V4_LineEND
V4_Line10:
If MW_prod_FillerV4 / SW_prod_FillerV4 < 1 And MW_prod_FillerV4 / SW_prod_FillerV4 > 0.1 Then GoTo V4_Line11 Else GoTo V4_Line12
V4_Line11:
Range("I17").Value = Range("I14").Value / 2
Range("I18").Value = Range("I14").Value / 2
GoTo V4_LineEND
V4_Line12:
If MW_prod_FillerV4 / SW_prod_FillerV4 > 1 And Tank_SpringwaterV3 >= Tank_MineralwaterV3 Then GoTo V4_Line13
V4_Line13:
Range("I17").Value = Range("I14").Value * (1 / 3)
Range("I18").Value = Range("I14").Value * (2 / 3)
GoTo V4_LineEND
V4_LineEND:
If MW_prod_FillerV5 / SW_prod_FillerV5 > 1 And Tank_SpringwaterV4 < Tank_MineralwaterV4 Then GoTo V5_Line1 Else GoTo V5_Line2
V5_Line1:
Range("J17").Value = Range("J14").Value * (2 / 3)
Range("J18").Value = Range("J14").Value * (1 / 3)
GoTo V5_LineEND
V5_Line2:
If MW_prod_FillerV5 / SW_prod_FillerV5 < 0.1 And MW_prod_FillerV5 / SW_prod_FillerV5 < 1 And Tank_SpringwaterV4 <= Tank_MineralwaterV4 Then GoTo V5_Line3 Else GoTo V5_Line4
V5_Line3:
Range("J17").Value = Range("J14").Value * (1)
Range("J18").Value = Range("J14").Value * (0)
GoTo V5_LineEND
V5_Line4:
If MW_prod_FillerV5 / SW_prod_FillerV5 < 0.1 And MW_prod_FillerV5 / SW_prod_FillerV5 < 1 And Tank_SpringwaterV4 >= Tank_MineralwaterV4 Then GoTo V5_Line5 Else GoTo V5_Line6
V5_Line5:
Range("J17").Value = Range("J14").Value * (0)
Range("J18").Value = Range("J14").Value * (1)
'GoTo V5_LineEND
V5_Line6:
If MW_prod_FillerV5 / SW_prod_FillerV5 > 0.1 And MW_prod_FillerV5 / SW_prod_FillerV5 < 1 And Tank_SpringwaterV4 >= Tank_MineralwaterV4 Then GoTo V5_Line7 Else GoTo V5_Line8
V5_Line7:
Range("J17").Value = Range("J14").Value * (0)
Range("J18").Value = Range("J14").Value * (1)
GoTo V5_LineEND
V5_Line8:
If MW_prod_FillerV5 / SW_prod_FillerV5 > 0.1 And MW_prod_FillerV5 / SW_prod_FillerV5 < 1 And Tank_SpringwaterV4 <= Tank_MineralwaterV4 Then GoTo V5_Line9 Else GoTo V5_Line10
V5_Line9:
Range("J17").Value = Range("J14").Value * (1)
Range("J18").Value = Range("J14").Value * (0)
GoTo V5_LineEND
V5_Line10:
If MW_prod_FillerV5 / SW_prod_FillerV5 < 1 And MW_prod_FillerV5 / SW_prod_FillerV5 > 0.1 Then GoTo V5_Line11 Else GoTo V5_Line12
V5_Line11:
Range("J17").Value = Range("J14").Value / 2
Range("J18").Value = Range("J14").Value / 2
GoTo V5_LineEND
V5_Line12:
If MW_prod_FillerV5 / SW_prod_FillerV5 > 1 And Tank_SpringwaterV4 >= Tank_MineralwaterV4 Then GoTo V5_Line13
V5_Line13:
Range("J17").Value = Range("J14").Value * (1 / 3)
Range("J18").Value = Range("J14").Value * (2 / 3)
GoTo V5_LineEND
V5_LineEND:
If MW_prod_FillerV6 / SW_prod_FillerV6 > 1 And Tank_SpringwaterV5 < Tank_MineralwaterV5 Then GoTo V6_Line1 Else GoTo V6_Line2
V6_Line1:
Range("K17").Value = Range("K14").Value * (2 / 3)
Range("K18").Value = Range("K14").Value * (1 / 3)
GoTo V6_LineEND
V6_Line2:
If MW_prod_FillerV6 / SW_prod_FillerV6 < 0.1 And MW_prod_FillerV6 / SW_prod_FillerV6 < 1 And Tank_SpringwaterV5 <= Tank_MineralwaterV5 Then GoTo V6_Line3 Else GoTo V6_Line4
V6_Line3:
Range("K17").Value = Range("K14").Value * (1)
Range("K18").Value = Range("K14").Value * (0)
GoTo V6_LineEND
V6_Line4:
If MW_prod_FillerV6 / SW_prod_FillerV6 < 0.1 And MW_prod_FillerV6 / SW_prod_FillerV6 < 1 And Tank_SpringwaterV5 >= Tank_MineralwaterV5 Then GoTo V6_Line5 Else GoTo V6_Line6
V6_Line5:
Range("K17").Value = Range("K14").Value * (0)
Range("K18").Value = Range("K14").Value * (1)
GoTo V6_LineEND
V6_Line6:
If MW_prod_FillerV6 / SW_prod_FillerV6 > 0.1 And MW_prod_FillerV6 / SW_prod_FillerV6 < 1 And Tank_SpringwaterV5 >= Tank_MineralwaterV5 Then GoTo V6_Line7 Else GoTo V6_Line8
V6_Line7:
Range("K17").Value = Range("K14").Value * (0)
Range("K18").Value = Range("K14").Value * (1)
GoTo V6_LineEND
V6_Line8:
If MW_prod_FillerV6 / SW_prod_FillerV6 > 0.1 And MW_prod_FillerV6 / SW_prod_FillerV6 < 1 And Tank_SpringwaterV5 <= Tank_MineralwaterV5 Then GoTo V6_Line9 Else GoTo V6_Line10
V6_Line9:
Range("K17").Value = Range("K14").Value * (1)
Range("K18").Value = Range("K14").Value * (0)
GoTo V6_LineEND
V6_Line10:
If MW_prod_FillerV6 / SW_prod_FillerV6 < 1 And MW_prod_FillerV6 / SW_prod_FillerV6 > 0.1 Then GoTo V6_Line11 Else GoTo V6_Line12
V6_Line11:
Range("K17").Value = Range("K14").Value / 2
Range("K18").Value = Range("K14").Value / 2
GoTo V6_LineEND
V6_Line12:
If MW_prod_FillerV6 / SW_prod_FillerV6 > 1 And Tank_SpringwaterV5 > Tank_MineralwaterV5 Then GoTo V6_Line13 Else GoTo V6_LineEND
V6_Line13:
Range("K17").Value = Range("K14").Value * (1 / 3)
Range("K18").Value = Range("K14").Value * (2 / 3)
GoTo V6_LineEND
V6_LineEND:
If MW_prod_FillerV7 / SW_prod_FillerV7 > 1 And Tank_SpringwaterV6 < Tank_MineralwaterV6 Then GoTo V7_Line1 Else GoTo V7_Line2
V7_Line1:
Range("L17").Value = Range("L14").Value * (2 / 3)
Range("L18").Value = Range("L14").Value * (1 / 3)
GoTo V7_LineEND
V7_Line2:
If MW_prod_FillerV7 / SW_prod_FillerV7 < 0.1 And MW_prod_FillerV7 / SW_prod_FillerV7 < 1 And Tank_SpringwaterV6 <= Tank_MineralwaterV6 Then GoTo V7_Line3 Else GoTo V7_Line4
V7_Line3:
Range("L17").Value = Range("L14").Value * (1)
Range("L18").Value = Range("L14").Value * (0)
GoTo V7_LineEND
V7_Line4:
If MW_prod_FillerV7 / SW_prod_FillerV7 < 0.1 And MW_prod_FillerV7 / SW_prod_FillerV7 < 1 And Tank_SpringwaterV6 >= Tank_MineralwaterV6 Then GoTo V7_Line5 Else GoTo V7_Line6
V7_Line5:
Range("L17").Value = Range("L14").Value * (0)
Range("L18").Value = Range("L14").Value * (1)
GoTo V7_LineEND
V7_Line6:
If MW_prod_FillerV7 / SW_prod_FillerV7 > 0.1 And MW_prod_FillerV7 / SW_prod_FillerV7 < 1 And Tank_SpringwaterV6 >= Tank_MineralwaterV6 Then GoTo V7_Line7 Else GoTo V7_Line8
V7_Line7:
Range("L17").Value = Range("L14").Value * (0)
Range("L18").Value = Range("L14").Value * (1)
GoTo V7_LineEND
V7_Line8:
If MW_prod_FillerV7 / SW_prod_FillerV7 > 0.1 And MW_prod_FillerV7 / SW_prod_FillerV7 < 1 And Tank_SpringwaterV6 <= Tank_MineralwaterV6 Then GoTo V7_Line9 Else GoTo V7_Line10
V7_Line9:
Range("L17").Value = Range("L14").Value * (1)
Range("L18").Value = Range("L14").Value * (0)
GoTo V7_LineEND
V7_Line10:
If MW_prod_FillerV7 / SW_prod_FillerV7 < 1 And MW_prod_FillerV7 / SW_prod_FillerV7 > 0.1 Then GoTo V7_Line11 Else GoTo V7_Line12
V7_Line11:
Range("L17").Value = Range("L14").Value / 2
Range("L18").Value = Range("L14").Value / 2
GoTo V7_LineEND
V7_Line12:
If MW_prod_FillerV7 / SW_prod_FillerV7 > 1 And Tank_SpringwaterV6 > Tank_MineralwaterV6 Then GoTo V7_Line13 Else GoTo V7_LineEND
V7_Line13:
Range("L17").Value = Range("L14").Value * (1 / 3)
Range("L18").Value = Range("L14").Value * (2 / 3)
GoTo V7_LineEND
V7_LineEND:
If MW_prod_FillerV8 / SW_prod_FillerV8 > 1 And Tank_SpringwaterV7 < Tank_MineralwaterV7 Then GoTo V8_Line1 Else GoTo V8_Line2
V8_Line1:
Range("M17").Value = Range("M14").Value * (2 / 3)
Range("M18").Value = Range("M14").Value * (1 / 3)
GoTo V8_LineEND
V8_Line2:
If MW_prod_FillerV8 / SW_prod_FillerV8 < 0.1 And MW_prod_FillerV8 / SW_prod_FillerV8 < 1 And Tank_SpringwaterV7 <= Tank_MineralwaterV7 Then GoTo V8_Line3 Else GoTo V8_Line4
V8_Line3:
Range("M17").Value = Range("M14").Value * (1)
Range("M18").Value = Range("M14").Value * (0)
GoTo V8_LineEND
V8_Line4:
If MW_prod_FillerV8 / SW_prod_FillerV8 < 0.1 And MW_prod_FillerV8 / SW_prod_FillerV8 < 1 And Tank_SpringwaterV7 >= Tank_MineralwaterV7 Then GoTo V8_Line5 Else GoTo V8_Line6
V8_Line5:
Range("M17").Value = Range("M14").Value * (0)
Range("M18").Value = Range("M14").Value * (1)
GoTo V8_LineEND
V8_Line6:
If MW_prod_FillerV8 / SW_prod_FillerV8 > 0.1 And MW_prod_FillerV8 / SW_prod_FillerV8 < 1 And Tank_SpringwaterV7 >= Tank_MineralwaterV7 Then GoTo V8_Line7 Else GoTo V8_Line8
V8_Line7:
Range("M17").Value = Range("M14").Value * (0)
Range("M18").Value = Range("M14").Value * (1)
GoTo V8_LineEND
V8_Line8:
If MW_prod_FillerV8 / SW_prod_FillerV8 > 0.1 And MW_prod_FillerV8 / SW_prod_FillerV8 < 1 And Tank_SpringwaterV7 <= Tank_MineralwaterV7 Then GoTo V8_Line9 Else GoTo V8_Line10
V8_Line9:
Range("M17").Value = Range("M14").Value * (1)
Range("M18").Value = Range("M14").Value * (0)
GoTo V8_LineEND
V8_Line10:
If MW_prod_FillerV8 / SW_prod_FillerV8 < 1 And MW_prod_FillerV8 / SW_prod_FillerV8 > 0.1 Then GoTo V8_Line11 Else GoTo V8_Line12
V8_Line11:
Range("M17").Value = Range("M14").Value / 2
Range("M18").Value = Range("M14").Value / 2
GoTo V8_LineEND
V8_Line12:
If MW_prod_FillerV8 / SW_prod_FillerV8 > 1 And Tank_SpringwaterV7 > Tank_MineralwaterV7 Then GoTo V8_Line13 Else GoTo V8_LineEND
V8_Line13:
Range("M17").Value = Range("M14").Value * (1 / 3)
Range("M18").Value = Range("M14").Value * (2 / 3)
GoTo V8_LineEND
V8_LineEND:
'Application.Wait Now + TimeSerial(0, 0, 20) 'wartet 20 Sekunden
If MW_prod_FillerV9 / SW_prod_FillerV9 > 1 And Tank_SpringwaterV8 < Tank_MineralwaterV8 Then GoTo V9_Line1 Else GoTo V9_Line2
V9_Line1:
Range("N17").Value = Range("N14").Value * (2 / 3)
Range("N18").Value = Range("N14").Value * (1 / 3)
GoTo V9_LineEND
V9_Line2:
If MW_prod_FillerV9 / SW_prod_FillerV9 < 0.1 And MW_prod_FillerV9 / SW_prod_FillerV9 < 1 And Tank_SpringwaterV8 <= Tank_MineralwaterV8 Then GoTo V9_Line3 Else GoTo V9_Line4
V9_Line3:
Range("N17").Value = Range("N14").Value * (1)
Range("N18").Value = Range("N14").Value * (0)
GoTo V9_LineEND
V9_Line4:
If MW_prod_FillerV9 / SW_prod_FillerV9 < 0.1 And MW_prod_FillerV9 / SW_prod_FillerV9 < 1 And Tank_SpringwaterV8 >= Tank_MineralwaterV8 Then GoTo V9_Line5 Else GoTo V9_Line6
V9_Line5:
Range("N17").Value = Range("N14").Value * (0)
Range("N18").Value = Range("N14").Value * (1)
GoTo V9_LineEND
V9_Line6:
If MW_prod_FillerV9 / SW_prod_FillerV9 > 0.1 And MW_prod_FillerV9 / SW_prod_FillerV9 < 1 And Tank_SpringwaterV8 >= Tank_MineralwaterV8 Then GoTo V9_Line7 Else GoTo V9_Line8
V9_Line7:
Range("N17").Value = Range("N14").Value * (0)
Range("N18").Value = Range("N14").Value * (1)
GoTo V9_LineEND
V9_Line8:
If MW_prod_FillerV9 / SW_prod_FillerV9 > 0.1 And MW_prod_FillerV9 / SW_prod_FillerV9 < 1 And Tank_SpringwaterV8 <= Tank_MineralwaterV8 Then GoTo V9_Line9 Else GoTo V9_Line10
V9_Line9:
Range("N17").Value = Range("N14").Value * (1)
Range("N18").Value = Range("N14").Value * (0)
GoTo V9_LineEND
V9_Line10:
If MW_prod_FillerV9 / SW_prod_FillerV9 < 1 And MW_prod_FillerV9 / SW_prod_FillerV9 > 0.1 Then GoTo V9_Line11 Else GoTo V9_Line12
V9_Line11:
Range("N17").Value = Range("N14").Value / 2
Range("N18").Value = Range("N14").Value / 2
GoTo V9_LineEND
V9_Line12:
If MW_prod_FillerV9 / SW_prod_FillerV9 > 1 And Tank_SpringwaterV8 > Tank_MineralwaterV8 Then GoTo V9_Line13 Else GoTo V9_LineEND
V9_Line13:
Range("N17").Value = Range("N14").Value * (1 / 3)
Range("N18").Value = Range("N14").Value * (2 / 3)
GoTo V9_LineEND
V9_LineEND:
If MW_prod_FillerV10 / SW_prod_FillerV10 > 1 And Tank_SpringwaterV9 < Tank_MineralwaterV9 Then GoTo V10_Line1 Else GoTo V10_Line2
V10_Line1:
Range("O17").Value = Range("O14").Value * (2 / 3)
Range("O18").Value = Range("O14").Value * (1 / 3)
GoTo V10_LineEND
V10_Line2:
If MW_prod_FillerV10 / SW_prod_FillerV10 < 0.1 And MW_prod_FillerV10 / SW_prod_FillerV10 < 1 And Tank_SpringwaterV9 <= Tank_MineralwaterV9 Then GoTo V10_Line3 Else GoTo V10_Line4
V10_Line3:
Range("O17").Value = Range("O14").Value * (1)
Range("O18").Value = Range("O14").Value * (0)
GoTo V10_LineEND
V10_Line4:
If MW_prod_FillerV10 / SW_prod_FillerV10 < 0.1 And MW_prod_FillerV10 / SW_prod_FillerV10 < 1 And Tank_SpringwaterV9 >= Tank_MineralwaterV9 Then GoTo V10_Line5 Else GoTo V10_Line6
V10_Line5:
Range("O17").Value = Range("O14").Value * (0)
Range("O18").Value = Range("O14").Value * (1)
GoTo V10_LineEND
V10_Line6:
If MW_prod_FillerV10 / SW_prod_FillerV10 > 0.1 And MW_prod_FillerV10 / SW_prod_FillerV10 < 1 And Tank_SpringwaterV9 >= Tank_MineralwaterV9 Then GoTo V10_Line7 Else GoTo V10_Line8
V10_Line7:
Range("O17").Value = Range("O14").Value * (0)
Range("O18").Value = Range("O14").Value * (1)
GoTo V10_LineEND
V10_Line8:
If MW_prod_FillerV10 / SW_prod_FillerV10 > 0.1 And MW_prod_FillerV10 / SW_prod_FillerV10 < 1 And Tank_SpringwaterV9 <= Tank_MineralwaterV9 Then GoTo V10_Line9 Else GoTo V10_Line10
V10_Line9:
Range("O17").Value = Range("O14").Value * (1)
Range("O18").Value = Range("O14").Value * (0)
GoTo V10_LineEND
V10_Line10:
If MW_prod_FillerV10 / SW_prod_FillerV10 < 1 And MW_prod_FillerV10 / SW_prod_FillerV10 > 0.1 Then GoTo V10_Line11 Else GoTo V10_Line12
V10_Line11:
Range("O17").Value = Range("O14").Value / 2
Range("O18").Value = Range("O14").Value / 2
GoTo V10_LineEND
V10_Line12:
If MW_prod_FillerV10 / SW_prod_FillerV10 > 1 And Tank_SpringwaterV9 > Tank_MineralwaterV9 Then GoTo V10_Line13 Else GoTo V10_LineEND
V10_Line13:
Range("O17").Value = Range("O14").Value * (1 / 3)
Range("O18").Value = Range("O14").Value * (2 / 3)
GoTo V10_LineEND
V10_LineEND:
If MW_prod_FillerV11 / SW_prod_FillerV11 > 1 And Tank_SpringwaterV10 < Tank_MineralwaterV10 Then GoTo V11_Line1 Else GoTo V11_Line2
V11_Line1:
Range("P17").Value = Range("P14").Value * (2 / 3)
Range("P18").Value = Range("P14").Value * (1 / 3)
GoTo V11_LineEND
V11_Line2:
If MW_prod_FillerV11 / SW_prod_FillerV11 < 0.1 And MW_prod_FillerV11 / SW_prod_FillerV11 < 1 And Tank_SpringwaterV10 <= Tank_MineralwaterV10 Then GoTo V11_Line3 Else GoTo V11_Line4
V11_Line3:
Range("P17").Value = Range("P14").Value * (1)
Range("P18").Value = Range("P14").Value * (0)
GoTo V11_LineEND
V11_Line4:
If MW_prod_FillerV11 / SW_prod_FillerV11 < 0.1 And MW_prod_FillerV11 / SW_prod_FillerV11 < 1 And Tank_SpringwaterV10 >= Tank_MineralwaterV10 Then GoTo V11_Line5 Else GoTo V11_Line6
V11_Line5:
Range("P17").Value = Range("P14").Value * (0)
Range("P18").Value = Range("P14").Value * (1)
GoTo V11_LineEND
V11_Line6:
If MW_prod_FillerV11 / SW_prod_FillerV11 > 0.1 And MW_prod_FillerV11 / SW_prod_FillerV11 < 1 And Tank_SpringwaterV10 >= Tank_MineralwaterV10 Then GoTo V11_Line7 Else GoTo V11_Line8
V11_Line7:
Range("P17").Value = Range("P14").Value * (0)
Range("P18").Value = Range("P14").Value * (1)
GoTo V11_LineEND
V11_Line8:
If MW_prod_FillerV11 / SW_prod_FillerV11 > 0.1 And MW_prod_FillerV11 / SW_prod_FillerV11 < 1 And Tank_SpringwaterV10 <= Tank_MineralwaterV10 Then GoTo V11_Line9 Else GoTo V11_Line10
V11_Line9:
Range("P17").Value = Range("P14").Value * (1)
Range("P18").Value = Range("P14").Value * (0)
GoTo V11_LineEND
V11_Line10:
If MW_prod_FillerV11 / SW_prod_FillerV11 < 1 And MW_prod_FillerV11 / SW_prod_FillerV11 > 0.1 Then GoTo V11_Line11 Else GoTo V11_Line12
V11_Line11:
Range("P17").Value = Range("P14").Value / 2
Range("P18").Value = Range("P14").Value / 2
GoTo V11_LineEND
V11_Line12:
If MW_prod_FillerV11 / SW_prod_FillerV11 > 1 And Tank_SpringwaterV10 > Tank_MineralwaterV10 Then GoTo V11_Line13 Else GoTo V11_LineEND
V11_Line13:
Range("P17").Value = Range("P14").Value * (1 / 3)
Range("P18").Value = Range("P14").Value * (2 / 3)
GoTo V11_LineEND
V11_LineEND:
If MW_prod_FillerV12 / SW_prod_FillerV12 > 1 And Tank_SpringwaterV11 < Tank_MineralwaterV11 Then GoTo V12_Line1 Else GoTo V12_Line2
V12_Line1:
Range("Q17").Value = Range("Q14").Value * (2 / 3)
Range("Q18").Value = Range("Q14").Value * (1 / 3)
GoTo V12_LineEND
V12_Line2:
If MW_prod_FillerV12 / SW_prod_FillerV12 < 0.1 And MW_prod_FillerV12 / SW_prod_FillerV12 < 1 And Tank_SpringwaterV11 <= Tank_MineralwaterV11 Then GoTo V12_Line3 Else GoTo V12_Line4
V12_Line3:
Range("Q17").Value = Range("Q14").Value * (1)
Range("Q18").Value = Range("Q14").Value * (0)
GoTo V12_LineEND
V12_Line4:
If MW_prod_FillerV12 / SW_prod_FillerV12 < 0.1 And MW_prod_FillerV12 / SW_prod_FillerV12 < 1 And Tank_SpringwaterV11 >= Tank_MineralwaterV11 Then GoTo V12_Line5 Else GoTo V12_Line6
V12_Line5:
Range("Q17").Value = Range("Q14").Value * (0)
Range("Q18").Value = Range("Q14").Value * (1)
GoTo V12_LineEND
V12_Line6:
If MW_prod_FillerV12 / SW_prod_FillerV12 > 0.1 And MW_prod_FillerV12 / SW_prod_FillerV12 < 1 And Tank_SpringwaterV11 >= Tank_MineralwaterV11 Then GoTo V12_Line7 Else GoTo V12_Line8
V12_Line7:
Range("Q17").Value = Range("Q14").Value * (0)
Range("Q18").Value = Range("Q14").Value * (1)
GoTo V12_LineEND
V12_Line8:
If MW_prod_FillerV12 / SW_prod_FillerV12 > 0.1 And MW_prod_FillerV12 / SW_prod_FillerV12 < 1 And Tank_SpringwaterV11 <= Tank_MineralwaterV11 Then GoTo V12_Line9 Else GoTo V12_Line10
V12_Line9:
Range("Q17").Value = Range("Q14").Value * (1)
Range("Q18").Value = Range("Q14").Value * (0)
GoTo V12_LineEND
V12_Line10:
If MW_prod_FillerV12 / SW_prod_FillerV12 < 1 And MW_prod_FillerV12 / SW_prod_FillerV12 > 0.1 Then GoTo V12_Line11 Else GoTo V12_Line12
V12_Line11:
Range("Q17").Value = Range("Q14").Value / 2
Range("Q18").Value = Range("Q14").Value / 2
GoTo V12_LineEND
V12_Line12:
If MW_prod_FillerV12 / SW_prod_FillerV12 > 1 And Tank_SpringwaterV11 > Tank_MineralwaterV11 Then GoTo V12_Line13 Else GoTo V12_LineEND
V12_Line13:
Range("Q17").Value = Range("Q14").Value * (1 / 3)
Range("Q18").Value = Range("Q14").Value * (2 / 3)
GoTo V12_LineEND
V12_LineEND:
If MW_prod_FillerV13 / SW_prod_FillerV13 > 1 And Tank_SpringwaterV12 < Tank_MineralwaterV12 Then GoTo V13_Line1 Else GoTo V13_Line2
V13_Line1:
Range("R17").Value = Range("R14").Value * (2 / 3)
Range("R18").Value = Range("R14").Value * (1 / 3)
GoTo V13_LineEND
V13_Line2:
If MW_prod_FillerV13 / SW_prod_FillerV13 < 0.1 And MW_prod_FillerV13 / SW_prod_FillerV13 < 1 And Tank_SpringwaterV12 <= Tank_MineralwaterV12 Then GoTo V13_Line3 Else GoTo V13_Line4
V13_Line3:
Range("R17").Value = Range("R14").Value * (1)
Range("R18").Value = Range("R14").Value * (0)
GoTo V13_LineEND
V13_Line4:
If MW_prod_FillerV13 / SW_prod_FillerV13 < 0.1 And MW_prod_FillerV13 / SW_prod_FillerV13 < 1 And Tank_SpringwaterV12 >= Tank_MineralwaterV12 Then GoTo V13_Line5 Else GoTo V13_Line6
V13_Line5:
Range("R17").Value = Range("R14").Value * (0)
Range("R18").Value = Range("R14").Value * (1)
GoTo V13_LineEND
V13_Line6:
If MW_prod_FillerV13 / SW_prod_FillerV13 > 0.1 And MW_prod_FillerV13 / SW_prod_FillerV13 < 1 And Tank_SpringwaterV12 >= Tank_MineralwaterV12 Then GoTo V13_Line7 Else GoTo V13_Line8
V13_Line7:
Range("R17").Value = Range("R14").Value * (0)
Range("R18").Value = Range("R14").Value * (1)
GoTo V13_LineEND
V13_Line8:
If MW_prod_FillerV13 / SW_prod_FillerV13 > 0.1 And MW_prod_FillerV13 / SW_prod_FillerV13 < 1 And Tank_SpringwaterV12 <= Tank_MineralwaterV12 Then GoTo V13_Line9 Else GoTo V13_Line10
V13_Line9:
Range("R17").Value = Range("R14").Value * (1)
Range("R18").Value = Range("R14").Value * (0)
GoTo V13_LineEND
V13_Line10:
If MW_prod_FillerV13 / SW_prod_FillerV13 < 1 And MW_prod_FillerV13 / SW_prod_FillerV13 > 0.1 Then GoTo V13_Line11 Else GoTo V13_Line12
V13_Line11:
Range("R17").Value = Range("R14").Value / 2
Range("R18").Value = Range("R14").Value / 2
GoTo V13_LineEND
V13_Line12:
If MW_prod_FillerV13 / SW_prod_FillerV13 > 1 And Tank_SpringwaterV12 > Tank_MineralwaterV12 Then GoTo V13_Line13 Else GoTo V13_LineEND
V13_Line13:
Range("R17").Value = Range("R14").Value * (1 / 3)
Range("R18").Value = Range("R14").Value * (2 / 3)
GoTo V13_LineEND
V13_LineEND:
If MW_prod_FillerV14 / SW_prod_FillerV14 > 1 And Tank_SpringwaterV13 < Tank_MineralwaterV13 Then GoTo V14_Line1 Else GoTo V14_Line2
V14_Line1:
Range("S17").Value = Range("S14").Value * (2 / 3)
Range("S18").Value = Range("S14").Value * (1 / 3)
GoTo V14_LineEND
V14_Line2:
If MW_prod_FillerV14 / SW_prod_FillerV14 < 0.1 And MW_prod_FillerV14 / SW_prod_FillerV14 < 1 And Tank_SpringwaterV13 <= Tank_MineralwaterV13 Then GoTo V14_Line3 Else GoTo V14_Line4
V14_Line3:
Range("S17").Value = Range("S14").Value * (1)
Range("S18").Value = Range("S14").Value * (0)
GoTo V14_LineEND
V14_Line4:
If MW_prod_FillerV14 / SW_prod_FillerV14 < 0.1 And MW_prod_FillerV14 / SW_prod_FillerV14 < 1 And Tank_SpringwaterV13 >= Tank_MineralwaterV13 Then GoTo V14_Line5 Else GoTo V14_Line6
V14_Line5:
Range("S17").Value = Range("S14").Value * (0)
Range("S18").Value = Range("S14").Value * (1)
GoTo V14_LineEND
V14_Line6:
If MW_prod_FillerV14 / SW_prod_FillerV14 > 0.1 And MW_prod_FillerV14 / SW_prod_FillerV14 < 1 And Tank_SpringwaterV13 >= Tank_MineralwaterV13 Then GoTo V14_Line7 Else GoTo V14_Line8
V14_Line7:
Range("S17").Value = Range("S14").Value * (0)
Range("S18").Value = Range("S14").Value * (1)
GoTo V14_LineEND
V14_Line8:
If MW_prod_FillerV14 / SW_prod_FillerV14 > 0.1 And MW_prod_FillerV14 / SW_prod_FillerV14 < 1 And Tank_SpringwaterV13 <= Tank_MineralwaterV13 Then GoTo V14_Line9 Else GoTo V14_Line10
V14_Line9:
Range("S17").Value = Range("S14").Value * (1)
Range("S18").Value = Range("S14").Value * (0)
GoTo V14_LineEND
V14_Line10:
If MW_prod_FillerV14 / SW_prod_FillerV14 < 1 And MW_prod_FillerV14 / SW_prod_FillerV14 > 0.1 Then GoTo V14_Line11 Else GoTo V14_Line12
V14_Line11:
Range("S17").Value = Range("S14").Value / 2
Range("S18").Value = Range("S14").Value / 2
GoTo V14_LineEND
V14_Line12:
If MW_prod_FillerV14 / SW_prod_FillerV14 > 1 And Tank_SpringwaterV13 > Tank_MineralwaterV13 Then GoTo V14_Line13 Else GoTo V14_LineEND
V14_Line13:
Range("S17").Value = Range("S14").Value * (1 / 3)
Range("S18").Value = Range("S14").Value * (2 / 3)
GoTo V14_LineEND
V14_LineEND:
If MW_prod_FillerV15 / SW_prod_FillerV15 > 1 And Tank_SpringwaterV14 < Tank_MineralwaterV14 Then GoTo V15_Line1 Else GoTo V15_Line2
V15_Line1:
Range("T17").Value = Range("T14").Value * (2 / 3)
Range("T18").Value = Range("T14").Value * (1 / 3)
GoTo V15_LineEND
V15_Line2:
If MW_prod_FillerV15 / SW_prod_FillerV15 < 0.1 And MW_prod_FillerV15 / SW_prod_FillerV15 < 1 And Tank_SpringwaterV14 <= Tank_MineralwaterV14 Then GoTo V15_Line3 Else GoTo V15_Line4
V15_Line3:
Range("T17").Value = Range("T14").Value * (1)
Range("T18").Value = Range("T14").Value * (0)
GoTo V15_LineEND
V15_Line4:
If MW_prod_FillerV15 / SW_prod_FillerV15 < 0.1 And MW_prod_FillerV15 / SW_prod_FillerV15 < 1 And Tank_SpringwaterV14 >= Tank_MineralwaterV14 Then GoTo V15_Line5 Else GoTo V15_Line6
V15_Line5:
Range("T17").Value = Range("T14").Value * (0)
Range("T18").Value = Range("T14").Value * (1)
GoTo V15_LineEND
V15_Line6:
If MW_prod_FillerV15 / SW_prod_FillerV15 > 0.1 And MW_prod_FillerV15 / SW_prod_FillerV15 < 1 And Tank_SpringwaterV14 >= Tank_MineralwaterV14 Then GoTo V15_Line7 Else GoTo V15_Line8
V15_Line7:
Range("T17").Value = Range("T14").Value * (0)
Range("T18").Value = Range("T14").Value * (1)
GoTo V15_LineEND
V15_Line8:
If MW_prod_FillerV15 / SW_prod_FillerV15 > 0.1 And MW_prod_FillerV15 / SW_prod_FillerV15 < 1 And Tank_SpringwaterV14 <= Tank_MineralwaterV14 Then GoTo V15_Line9 Else GoTo V15_Line10
V15_Line9:
Range("T17").Value = Range("T14").Value * (1)
Range("T18").Value = Range("T14").Value * (0)
GoTo V15_LineEND
V15_Line10:
If MW_prod_FillerV15 / SW_prod_FillerV15 < 1 And MW_prod_FillerV15 / SW_prod_FillerV15 > 0.1 Then GoTo V15_Line11 Else GoTo V15_Line12
V15_Line11:
Range("T17").Value = Range("T14").Value / 2
Range("T18").Value = Range("T14").Value / 2
GoTo V15_LineEND
V15_Line12:
If MW_prod_FillerV15 / SW_prod_FillerV15 > 1 And Tank_SpringwaterV14 > Tank_MineralwaterV14 Then GoTo V15_Line13 Else GoTo V15_LineEND
V15_Line13:
Range("T17").Value = Range("T14").Value * (1 / 3)
Range("T18").Value = Range("T14").Value * (2 / 3)
GoTo V15_LineEND
V15_LineEND:
If MW_prod_FillerV16 / SW_prod_FillerV16 > 1 And Tank_SpringwaterV15 < Tank_MineralwaterV15 Then GoTo V16_Line1 Else GoTo V16_Line2
V16_Line1:
Range("U17").Value = Range("U14").Value * (2 / 3)
Range("U18").Value = Range("U14").Value * (1 / 3)
GoTo V16_LineEND
V16_Line2:
If MW_prod_FillerV16 / SW_prod_FillerV16 < 0.1 And MW_prod_FillerV16 / SW_prod_FillerV16 < 1 And Tank_SpringwaterV15 <= Tank_MineralwaterV15 Then GoTo V16_Line3 Else GoTo V16_Line4
V16_Line3:
Range("U17").Value = Range("U14").Value * (1)
Range("U18").Value = Range("U14").Value * (0)
GoTo V16_LineEND
V16_Line4:
If MW_prod_FillerV16 / SW_prod_FillerV16 < 0.1 And MW_prod_FillerV16 / SW_prod_FillerV16 < 1 And Tank_SpringwaterV15 >= Tank_MineralwaterV15 Then GoTo V16_Line5 Else GoTo V16_Line6
V16_Line5:
Range("U17").Value = Range("U14").Value * (0)
Range("U18").Value = Range("U14").Value * (1)
GoTo V16_LineEND
V16_Line6:
If MW_prod_FillerV16 / SW_prod_FillerV16 > 0.1 And MW_prod_FillerV16 / SW_prod_FillerV16 < 1 And Tank_SpringwaterV15 >= Tank_MineralwaterV15 Then GoTo V16_Line7 Else GoTo V16_Line8
V16_Line7:
Range("U17").Value = Range("U14").Value * (0)
Range("U18").Value = Range("U14").Value * (1)
GoTo V16_LineEND
V16_Line8:
If MW_prod_FillerV16 / SW_prod_FillerV16 > 0.1 And MW_prod_FillerV16 / SW_prod_FillerV16 < 1 And Tank_SpringwaterV15 <= Tank_MineralwaterV15 Then GoTo V16_Line9 Else GoTo V16_Line10
V16_Line9:
Range("U17").Value = Range("U14").Value * (1)
Range("U18").Value = Range("U14").Value * (0)
GoTo V16_LineEND
V16_Line10:
If MW_prod_FillerV16 / SW_prod_FillerV16 < 1 And MW_prod_FillerV16 / SW_prod_FillerV16 > 0.1 Then GoTo V16_Line11 Else GoTo V16_Line12
V16_Line11:
Range("U17").Value = Range("U14").Value / 2
Range("U18").Value = Range("U14").Value / 2
GoTo V16_LineEND
V16_Line12:
If MW_prod_FillerV16 / SW_prod_FillerV16 > 1 And Tank_SpringwaterV15 > Tank_MineralwaterV15 Then GoTo V16_Line13 Else GoTo V16_LineEND
V16_Line13:
Range("U17").Value = Range("U14").Value * (1 / 3)
Range("U18").Value = Range("U14").Value * (2 / 3)
GoTo V16_LineEND
V16_LineEND:
If MW_prod_FillerV17 / SW_prod_FillerV17 > 1 And Tank_SpringwaterV16 < Tank_MineralwaterV16 Then GoTo V17_Line1 Else GoTo V17_Line2
V17_Line1:
Range("V17").Value = Range("V14").Value * (2 / 3)
Range("V18").Value = Range("V14").Value * (1 / 3)
GoTo V17_LineEND
V17_Line2:
If MW_prod_FillerV17 / SW_prod_FillerV17 < 0.1 And MW_prod_FillerV17 / SW_prod_FillerV17 < 1 And Tank_SpringwaterV16 <= Tank_MineralwaterV16 Then GoTo V17_Line3 Else GoTo V17_Line4
V17_Line3:
Range("V17").Value = Range("V14").Value * (1)
Range("V18").Value = Range("V14").Value * (0)
GoTo V17_LineEND
V17_Line4:
If MW_prod_FillerV17 / SW_prod_FillerV17 < 0.1 And MW_prod_FillerV17 / SW_prod_FillerV17 < 1 And Tank_SpringwaterV16 >= Tank_MineralwaterV16 Then GoTo V17_Line5 Else GoTo V17_Line6
V17_Line5:
Range("V17").Value = Range("V14").Value * (0)
Range("V18").Value = Range("V14").Value * (1)
GoTo V17_LineEND
V17_Line6:
If MW_prod_FillerV17 / SW_prod_FillerV17 > 0.1 And MW_prod_FillerV17 / SW_prod_FillerV17 < 1 And Tank_SpringwaterV16 >= Tank_MineralwaterV16 Then GoTo V17_Line7 Else GoTo V17_Line8
V17_Line7:
Range("V17").Value = Range("V14").Value * (0)
Range("V18").Value = Range("V14").Value * (1)
GoTo V17_LineEND
V17_Line8:
If MW_prod_FillerV17 / SW_prod_FillerV17 > 0.1 And MW_prod_FillerV17 / SW_prod_FillerV17 < 1 And Tank_SpringwaterV16 <= Tank_MineralwaterV16 Then GoTo V17_Line9 Else GoTo V17_Line10
V17_Line9:
Range("V17").Value = Range("V14").Value * (1)
Range("V18").Value = Range("V14").Value * (0)
GoTo V17_LineEND
V17_Line10:
If MW_prod_FillerV17 / SW_prod_FillerV17 < 1 And MW_prod_FillerV17 / SW_prod_FillerV17 > 0.1 Then GoTo V17_Line11 Else GoTo V17_Line12
V17_Line11:
Range("V17").Value = Range("V14").Value / 2
Range("V18").Value = Range("V14").Value / 2
GoTo V17_LineEND
V17_Line12:
If MW_prod_FillerV17 / SW_prod_FillerV17 > 1 And Tank_SpringwaterV16 > Tank_MineralwaterV16 Then GoTo V17_Line13 Else GoTo V17_LineEND
V17_Line13:
Range("V17").Value = Range("V14").Value * (1 / 3)
Range("V18").Value = Range("V14").Value * (2 / 3)
GoTo V17_LineEND
V17_LineEND:
If MW_prod_FillerV18 / SW_prod_FillerV18 > 1 And Tank_SpringwaterV17 < Tank_MineralwaterV17 Then GoTo V18_Line1 Else GoTo V18_Line2
V18_Line1:
Range("W17").Value = Range("W14").Value * (2 / 3)
Range("W18").Value = Range("W14").Value * (1 / 3)
GoTo V18_LineEND
V18_Line2:
If MW_prod_FillerV18 / SW_prod_FillerV18 < 0.1 And MW_prod_FillerV18 / SW_prod_FillerV18 < 1 And Tank_SpringwaterV17 <= Tank_MineralwaterV17 Then GoTo V18_Line3 Else GoTo V18_Line4
V18_Line3:
Range("W17").Value = Range("W14").Value * (1)
Range("W18").Value = Range("W14").Value * (0)
GoTo V18_LineEND
V18_Line4:
If MW_prod_FillerV18 / SW_prod_FillerV18 < 0.1 And MW_prod_FillerV18 / SW_prod_FillerV18 < 1 And Tank_SpringwaterV17 >= Tank_MineralwaterV17 Then GoTo V18_Line5 Else GoTo V18_Line6
V18_Line5:
Range("W17").Value = Range("W14").Value * (0)
Range("W18").Value = Range("W14").Value * (1)
GoTo V18_LineEND
V18_Line6:
If MW_prod_FillerV18 / SW_prod_FillerV18 > 0.1 And MW_prod_FillerV18 / SW_prod_FillerV18 < 1 And Tank_SpringwaterV17 >= Tank_MineralwaterV17 Then GoTo V18_Line7 Else GoTo V18_Line8
V18_Line7:
Range("W17").Value = Range("W14").Value * (0)
Range("W18").Value = Range("W14").Value * (1)
GoTo V18_LineEND
V18_Line8:
If MW_prod_FillerV18 / SW_prod_FillerV18 > 0.1 And MW_prod_FillerV18 / SW_prod_FillerV18 < 1 And Tank_SpringwaterV17 <= Tank_MineralwaterV17 Then GoTo V18_Line9 Else GoTo V18_Line10
V18_Line9:
Range("W17").Value = Range("W14").Value * (1)
Range("W18").Value = Range("W14").Value * (0)
GoTo V18_LineEND
V18_Line10:
If MW_prod_FillerV18 / SW_prod_FillerV18 < 1 And MW_prod_FillerV18 / SW_prod_FillerV18 > 0.1 Then GoTo V18_Line11 Else GoTo V18_Line12
V18_Line11:
Range("W17").Value = Range("W14").Value / 2
Range("W18").Value = Range("W14").Value / 2
GoTo V18_LineEND
V18_Line12:
If MW_prod_FillerV18 / SW_prod_FillerV18 > 1 And Tank_SpringwaterV17 > Tank_MineralwaterV17 Then GoTo V18_Line13 Else GoTo V18_LineEND
V18_Line13:
Range("W17").Value = Range("W14").Value * (1 / 3)
Range("W18").Value = Range("W14").Value * (2 / 3)
GoTo V18_LineEND
V18_LineEND:
If MW_prod_FillerV19 / SW_prod_FillerV19 > 1 And Tank_SpringwaterV18 < Tank_MineralwaterV18 Then GoTo V19_Line1 Else GoTo V19_Line2
V19_Line1:
Range("X17").Value = Range("X14").Value * (2 / 3)
Range("X18").Value = Range("X14").Value * (1 / 3)
GoTo V19_LineEND
V19_Line2:
If MW_prod_FillerV19 / SW_prod_FillerV19 < 0.1 And MW_prod_FillerV19 / SW_prod_FillerV19 < 1 And Tank_SpringwaterV18 <= Tank_MineralwaterV18 Then GoTo V19_Line3 Else GoTo V19_Line4
V19_Line3:
Range("X17").Value = Range("X14").Value * (1)
Range("X18").Value = Range("X14").Value * (0)
GoTo V19_LineEND
V19_Line4:
If MW_prod_FillerV19 / SW_prod_FillerV19 < 0.1 And MW_prod_FillerV19 / SW_prod_FillerV19 < 1 And Tank_SpringwaterV18 >= Tank_MineralwaterV18 Then GoTo V19_Line5 Else GoTo V19_Line6
V19_Line5:
Range("X17").Value = Range("X14").Value * (0)
Range("X18").Value = Range("X14").Value * (1)
GoTo V19_LineEND
V19_Line6:
If MW_prod_FillerV19 / SW_prod_FillerV19 > 0.1 And MW_prod_FillerV19 / SW_prod_FillerV19 < 1 And Tank_SpringwaterV18 >= Tank_MineralwaterV18 Then GoTo V19_Line7 Else GoTo V19_Line8
V19_Line7:
Range("X17").Value = Range("X14").Value * (0)
Range("X18").Value = Range("X14").Value * (1)
GoTo V19_LineEND
V19_Line8:
If MW_prod_FillerV19 / SW_prod_FillerV19 > 0.1 And MW_prod_FillerV19 / SW_prod_FillerV19 < 1 And Tank_SpringwaterV18 <= Tank_MineralwaterV18 Then GoTo V19_Line9 Else GoTo V19_Line10
V19_Line9:
Range("X17").Value = Range("X14").Value * (1)
Range("X18").Value = Range("X14").Value * (0)
GoTo V19_LineEND
V19_Line10:
If MW_prod_FillerV19 / SW_prod_FillerV19 < 1 And MW_prod_FillerV19 / SW_prod_FillerV19 > 0.1 Then GoTo V19_Line11 Else GoTo V19_Line12
V19_Line11:
Range("X17").Value = Range("X14").Value / 2
Range("X18").Value = Range("X14").Value / 2
GoTo V19_LineEND
V19_Line12:
If MW_prod_FillerV19 / SW_prod_FillerV19 > 1 And Tank_SpringwaterV18 > Tank_MineralwaterV18 Then GoTo V19_Line13 Else GoTo V19_LineEND
V19_Line13:
Range("X17").Value = Range("X14").Value * (1 / 3)
Range("X18").Value = Range("X14").Value * (2 / 3)
GoTo V19_LineEND
V19_LineEND:
If MW_prod_FillerV20 / SW_prod_FillerV20 > 1 And Tank_SpringwaterV19 < Tank_MineralwaterV19 Then GoTo V20_Line1 Else GoTo V20_Line2
V20_Line1:
Range("Y17").Value = Range("Y14").Value * (2 / 3)
Range("Y18").Value = Range("Y14").Value * (1 / 3)
GoTo V20_LineEND
V20_Line2:
If MW_prod_FillerV20 / SW_prod_FillerV20 < 0.1 And MW_prod_FillerV20 / SW_prod_FillerV20 < 1 And Tank_SpringwaterV19 <= Tank_MineralwaterV19 Then GoTo V20_Line3 Else GoTo V20_Line4
V20_Line3:
Range("Y17").Value = Range("Y14").Value * (1)
Range("Y18").Value = Range("Y14").Value * (0)
GoTo V20_LineEND
V20_Line4:
If MW_prod_FillerV20 / SW_prod_FillerV20 < 0.1 And MW_prod_FillerV20 / SW_prod_FillerV20 < 1 And Tank_SpringwaterV19 >= Tank_MineralwaterV19 Then GoTo V20_Line5 Else GoTo V20_Line6
V20_Line5:
Range("Y17").Value = Range("Y14").Value * (0)
Range("Y18").Value = Range("Y14").Value * (1)
GoTo V20_LineEND
V20_Line6:
If MW_prod_FillerV20 / SW_prod_FillerV20 > 0.1 And MW_prod_FillerV20 / SW_prod_FillerV20 < 1 And Tank_SpringwaterV19 >= Tank_MineralwaterV19 Then GoTo V20_Line7 Else GoTo V20_Line8
V20_Line7:
Range("Y17").Value = Range("Y14").Value * (0)
Range("Y18").Value = Range("Y14").Value * (1)
GoTo V20_LineEND
V20_Line8:
If MW_prod_FillerV20 / SW_prod_FillerV20 > 0.1 And MW_prod_FillerV20 / SW_prod_FillerV20 < 1 And Tank_SpringwaterV19 <= Tank_MineralwaterV19 Then GoTo V20_Line9 Else GoTo V20_Line10
V20_Line9:
Range("Y17").Value = Range("Y14").Value * (1)
Range("Y18").Value = Range("Y14").Value * (0)
GoTo V20_LineEND
V20_Line10:
If MW_prod_FillerV20 / SW_prod_FillerV20 < 1 And MW_prod_FillerV20 / SW_prod_FillerV20 > 0.1 Then GoTo V20_Line11 Else GoTo V20_Line12
V20_Line11:
Range("Y17").Value = Range("Y14").Value / 2
Range("Y18").Value = Range("Y14").Value / 2
GoTo V20_LineEND
V20_Line12:
If MW_prod_FillerV20 / SW_prod_FillerV20 > 1 And Tank_SpringwaterV19 > Tank_MineralwaterV19 Then GoTo V20_Line13 Else GoTo V20_LineEND
V20_Line13:
Range("Y17").Value = Range("Y14").Value * (1 / 3)
Range("Y18").Value = Range("Y14").Value * (2 / 3)
GoTo V20_LineEND
V20_LineEND:
'*************************************************************
End Sub