arbrandt / OPGEE

Oil Production Greenhouse Gas Emissions Estimator
18 stars 3 forks source link

Add boundary for fraction type input parameters in the 'Input' tab #486

Open wennanlong opened 1 year ago

wennanlong commented 1 year ago

In the 'Input' tab, row 64 to row 68 are not bounded by [0, 1]. Add it to the error message in the 'Active Field' tab.

In the 'Active Field' tab, Cell I104 =IF(OR(Fraction_remaining_gas_inj<0, Fraction_remaining_gas_inj>1, AND(AND(J53=1,J90=1),NOT(J104=1))),"ERROR","OK")

Cell I105 =IF(OR(Fraction_water_reinjected<0, Fraction_water_reinjected>1, AND(J51=1,NOT(Fraction_water_reinjected=1))),"ERROR","OK")

Cell I106 =IF(OR(Fraction_steam_cogen<0, Fraction_steam_cogen>1),"ERROR","OK")

Cell I107 =IF(OR(Fraction_steam_solar<0, Fraction_steam_solar>1),"ERROR","OK")