Spreadsheet: 821366d1678665507-indirect-formula-automate-other-then-just-year-yyyy-ev-2021-toedit
Sheet: EV2041

EV CHRG TIME PREDICT "ON MILES" |  |  |  | EV CHRG MILES PREDICT "ON TIME" |  |  |  |  | EV CHRG £ @ ELEC KHW PRICE |  |  |  | KWxHRx£ |  | [NAME] | RANGE | [NAME]
KW | 3 | COMBO |  |  | 3 | COMBO |  |  | [NAME] | EV CHRG (W/V=A) | KW (AxV=W) | HR (KW Bat / KW Chrg) | 0.33 |  |  | 220
[NAME] | 200 | ENTER FIGURE |  | HOURS : | 12:00:00 | ENTER NUMBER |  |  | 100 | LEAD PH1 (13A) | 3
HOURS |  | FORMULA |  | [NAME] |  | FORMULA |  |  |  | SLOW PH1 (32A) | 7 |  |  |  | EV 3-7KW HOME CHRG TYPE/LEVEL 2: 7 PIN
PPM |  | FORMULA |  |  |  | FORMULA |  |  |  | FAST PH3 (92A) | 22 |  |  |  | LEAD: TYPE 2 (Slow/Fast) & Phase1 UK 3Pin/IP44
COST |  | FORMULA |  | COST |  | FORMULA |  |  |  | RAPID PH3 (209A) | 50 |  |  |  | RANGE | PPM | COST
START DATE/TIME |  | 2023-03-10 17:00:00 |  | START DATE |  | 2023-03-12 13:00:00
FINISH DATE/TIME |  |  |  | FINISH DATE |  |  |  |  |  |  |  |  |  |  | ê
 |  |  |  |  |  |  |  |  | KW | [NAME] | DATE/TIME EX |  | CHRG HR |  | 440
 |  |  |  |  |  |  |  |  | 3 |  | 2023-03-11 23:20:00
 |  |  |  |  |  |  |  |  | 7 |  | 2023-03-11 04:17:00 |  |  |  | ê
 |  |  |  |  |  |  |  |  | 22 |  | 2023-03-10 18:32:00 |  |  |  | DIESEL RUNNING COST EQUIV
 |  |  |  |  |  |  |  |  | 50 |  | 2023-03-10 16:00:00 |  |  |  | PPL | MILE TANK | PPM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.687 | 440
 |  |  |  |  |  |  |  |  | NOTE: FAST/RAPID CHRG > £ [NAME] : CELL Q25 |  |  |  |  |  | ê
 |  |  |  |  |  |  |  |  | NOTE: DATE write as:  DD-MM-YY HR PM |  |  |  |  |  | COST PER 440 MILES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ê
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RAPID 22-50KW CHRG |  | 0.79
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHARGER: CCS or CHAdeMO (RAPID) & PHASE 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RANGE | PPM | COST
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ê
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 440
EV CHARGING STATS: TIME / % / MILES / £
COMBO | ENTER/FORMULA | ENTER/FORMULA | ENTER | ENTER | ENTER | ENTER | ENTER | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | ENTER NEXT | ENTER NEXT | FORMULA | FORMULA
CHARGER | MILEAGE START | START DATE/TIME CHRG | START % BATTERY | START RANGE | FINISH DATE/TIME CHRG | FINISH % BATTERY | FINISH RANGE | CHRG TIME TOTAL | % BAT INCREASE | RANGE INCREASE | [NAME] HR CHRG | CHRG £ TOTAL HRS | PPM CHARGE | > RECHARGE DATE/TIME | > MILEAGE FINISH | [NAME] | DAYS PER RANGE
3 | 100000 | 2023-03-11 13:00:00 | 0.1 | 50 | 2023-03-12 21:00:00 | 1 | 220 |  |  |  |  |  |  | 2023-03-25 14:00:00 | 100210
3 |  |  | 0.5 | 100 | 2023-03-26 18:00:00 | 0.9 | 210 |  |  |  |  |  |  | 2023-04-10 13:00:00 | 100415
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
NUMBER OF EV CHARGES | MILEAGE PER YR | CHRG COST PER YR | AV BAT START% | AV START RANGE |  | [NAME] FINISH% | AV FINISH RANGE | AV CHARGE TIME TOTAL | AV BAT INCREASE% | AV RANGE INCREASE | [NAME] | AV CHRG £ TOTAL HRS | AV PPM CHARGE |  |  | [NAME] RANGE | AV DAY RANGE