Spreadsheet: 152361d1335363749-looping-excel-formulas-sample-flow-rate
Sheet: GUI

 | Spreadsheet for Identifying Lowest Energy Consumption
1) | For a fixed flow rate, this spreadsheet finds the frequency 'W' and amplitude 'Z' which gives the lowest energy consumption
2) | It is able to interpolate between amplitudes, but unable to interpolate between frequencies (a limitation)
3) | ONLY MODIFY THE VALUE IN THE RED BOX
4) | DO NOT SAVE FILE
5) | Scroll down for program algorithm and calculations
 | GUI
 | INPUT |  |  |  |  |  |  | Internal use: for double checking
 | Enter flow rate between 0.036 and 1.61 ml/min | 0.036 | ml/min |  |  |  |  | CARS | CARA Rx | CARA Tx
 | Please set Frequency 'W' | 'Y' to
 | Please set Amplitude 'Z' to
 | Amplitude 'X' is always fixed at | 60
 | Actual flow rate |  | ml/min
 | Energy Consumed to pump 1ml in CARS |  | J
 | Energy Consumed to pump 1ml in CARA Rx |  | J
 | Energy Consumed to pump 1ml in CARA Tx |  | J
 | Program Algorithm
1) | Flow rate is entered by user
2) | Using the 8 curves in the 'Flow Rate' chart, 8 amplitudes are tracked down
3) | The 8 amplitudes are rounded to nearest integer, so that it can be entered into the computer program eventually
4) | The 8 amplitudes are checked to ensure they are achievable (i.e. between 18 and 60)
5) | If out of range, '#N/A' is produced and data discarded
6) | Remaining valid amplitude values are substituted into 'CARS & Pump Energy Consumption' chart
7) | Energy values are now read from the chart
8) | The energy values are compared to idenfity minimum energy consumption
9) | The corresponding amplitude, frequency, modified flow rate (due to rounding), and CARS energy consumption are returned
10) | Using these amplitude and frequency values, the CARA Rx and CARA Tx Energy Consumption charts are read
11) | This returns corresponding CARA Rx and CARA Tx energy consumption values
 | Live Calculations
 | DO NOT MODIFY ANY VALUES IN THIS SECTION |  | Flow Rate |  |  |  |  |  |  |  |  |  | CARS & Pump & Misc Energy |  |  |  |  |  |  |  |  |  | CARA Rx & Pump & Misc Energy |  |  |  |  |  |  |  |  |  | CARA Tx & Pump & Misc Energy
 |  |  | Equation Coeff. |  | Frequency |  | Amplitude |  |  | Flow rate after rounding |  |  | Equation Coeff. |  |  |  |  | Frequency |  | Energy Consumption (J) |  |  | Equation Coeff. |  |  |  |  | Frequency |  | Energy Consumption (J) |  |  | Equation Coeff. |  |  |  |  | Frequency |  | Energy Consumption (J)
 |  |  | x1 | [NAME] | W' | Y' | Z' | Round to Int | Is 'Z' between 18 & 60? |  |  |  | x4 | [NAME] | x2 | x1 | [NAME] | W' | Y' |  |  |  | x4 | [NAME] | x2 | x1 | [NAME] | W' | Y' |  |  |  | x4 | [NAME] | x2 | x1 | [NAME] | W' | Y'
 |  |  | 0.00236 | -0.00568 | 65535 | 63000 |  |  |  |  |  |  | 0.00016273 | -0.0291117 | 1.92275044 | -56.02536553 | 648.88727973 | 65535 | 63000 |  |  |  | 0.00022542 | -0.04039699 | 2.67340031 | -78.11837689 | 907.29351179 | 65535 | 63000 |  |  |  | 0.00022189 | -0.0397612 | 2.63111018 | -76.87370019 | 892.73541421 | 65535 | 63000
 |  |  | 0.00331 | -0.00731 | 25000 | 24000 |  |  |  |  |  |  |  |  | 0.03307 | -3.34155 | 101.53858 | 25000 | 24000 |  |  |  |  |  | 0.04957 | -5.04681 | 152.55765 | 25000 | 24000 |  |  |  |  |  | 0.04864 | -4.95074 | 149.68334 | 25000 | 24000
 |  |  | 0.00672 | -0.02954 | 12500 | 12000 |  |  |  |  |  |  |  |  | 0.01854 | -1.89648 | 57.18085 | 12500 | 12000 |  |  |  |  |  | 0.02771 | -2.86355 | 86.07859 | 12500 | 12000 |  |  |  |  |  | 0.02719 | -2.80907 | 84.45055 | 12500 | 12000
 |  |  | 0.01051 | -0.03954 | 8333 | 8000 |  |  |  |  |  |  |  |  | 0.00901 | -0.95291 | 31.1922 | 8333 | 8000 |  |  |  |  |  | 0.01346 | -1.4417 | 46.82919 | 8333 | 8000 |  |  |  |  |  | 0.01321 | -1.41416 | 45.94823 | 8333 | 8000
 |  |  | 0.01328 | -0.05198 | 6250 | 6000 |  |  |  |  |  |  |  |  | 0.00557 | -0.61025 | 21.77036 | 6250 | 6000 |  |  |  |  |  | 0.00862 | -0.95603 | 33.34342 | 6250 | 6000 |  |  |  |  |  | 0.00845 | -0.93655 | 32.69141 | 6250 | 6000
 |  |  | 0.02144 | -0.14896 | 4167 | 4000 |  |  |  |  |  |  |  |  | 0.0103 | -1.01154 | 27.73811 | 4167 | 4000 |  |  |  |  |  | 0.01531 | -1.51712 | 41.43018 | 4167 | 4000 |  |  |  |  |  | 0.01503 | -1.48864 | 40.6588 | 4167 | 4000
 |  |  | 0.02198 | -0.02441 | 3125 | 3000 |  |  |  |  |  |  |  |  | 0.00572 | -0.5661 | 17.26518 | 3125 | 3000 |  |  |  |  |  | 0.00815 | -0.81932 | 24.86579 | 3125 | 3000 |  |  |  |  |  | 0.00801 | -0.80506 | 24.43758 | 3125 | 3000
 |  |  | 0.0294 | -0.15414 | 2500 | 2400 |  |  |  |  |  |  |  |  | 0.00407 | -0.42645 | 14.1056 | 2500 | 2400 |  |  |  |  |  | 0.00602 | -0.63671 | 20.56678 | 2500 | 2400 |  |  |  |  |  | 0.00591 | -0.62487 | 20.20271 | 2500 | 2400
 | By | [NAME] |  |  |  |  |  | 0.0357 | extreme flow rates | 1.624 |  |  |  |  |  |  |  | For lowest energy |  |  |  |  |  |  |  |  |  | For lowest energy |  |  |  |  |  |  |  |  |  | For lowest energy
 | Last Modified |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Frequency 'W' | 'Y' |  |  |  |  |  |  |  |  |  | Frequency 'W' |  |  |  |  |  |  |  |  |  | Frequency 'W'
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amplitude 'Z' |  |  |  |  |  |  |  |  |  | Amplitude 'Z' |  |  |  |  |  |  |  |  |  | Amplitude 'Z'
 | Revision | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Energy Consumption |  |  |  |  |  |  |  |  |  | Energy Consumption |  |  |  |  |  |  |  |  |  | Energy Consumption
 | For NUS ME4105 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Flow Rate |  |  |  |  |  |  |  |  |  | Actual Flow Rate |  |  |  |  |  |  |  |  |  | Actual Flow Rate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Energy Consumption from CARA |  |  |  |  |  |  |  |  |  | Energy Consumption from CARA