From ab1582d638b11850e2886dd85d5fd4e263c655ae Mon Sep 17 00:00:00 2001
From: Paul Duncan <pabs@pablotron.org>
Date: Fri, 22 Oct 2021 03:37:45 -0400
Subject: ev-crash-course: move all tables to data/tables

---
 .../all_eugene_to_port_angeles.yaml                | 40 ++++++++++++++++++++++
 data/tables/ev_crash_course/l1_charging_cost.yaml  |  2 +-
 data/tables/ev_crash_course/l2_charging_cost.yaml  | 29 ++++++++++++++++
 data/tables/ev_crash_course/l2_cost_per_mile.yaml  | 31 +++++++++++++++++
 data/tables/ev_crash_course/l3_charging_cost.yaml  | 29 ++++++++++++++++
 data/tables/ev_crash_course/l3_cost_per_mile.yaml  | 31 +++++++++++++++++
 .../tesla_eugene_to_port_angeles.yaml              | 32 +++++++++++++++++
 7 files changed, 193 insertions(+), 1 deletion(-)
 create mode 100644 data/tables/ev_crash_course/all_eugene_to_port_angeles.yaml
 create mode 100644 data/tables/ev_crash_course/l2_charging_cost.yaml
 create mode 100644 data/tables/ev_crash_course/l2_cost_per_mile.yaml
 create mode 100644 data/tables/ev_crash_course/l3_charging_cost.yaml
 create mode 100644 data/tables/ev_crash_course/l3_cost_per_mile.yaml
 create mode 100644 data/tables/ev_crash_course/tesla_eugene_to_port_angeles.yaml

diff --git a/data/tables/ev_crash_course/all_eugene_to_port_angeles.yaml b/data/tables/ev_crash_course/all_eugene_to_port_angeles.yaml
new file mode 100644
index 0000000..049d2fc
--- /dev/null
+++ b/data/tables/ev_crash_course/all_eugene_to_port_angeles.yaml
@@ -0,0 +1,40 @@
+---
+# table name (required)
+name: "Cost Per Mile Comparison, Tesla Supercharger"
+
+# table columns (required)
+cols:
+  - id: "vehicle"
+    name: "Vehicle"
+    tip: "Vehicle."
+  - id: "num_stops"
+    name: "Number of Stops"
+    tip: "Number of stops required on this trip."
+    align: "right"
+  - id: "stop_time"
+    name: "Total Stop Time (min)"
+    tip: "Total amount of time stopped, in minutes."
+    align: "right"
+  - id: "cost"
+    name: "Cost"
+    tip: "Total cost of energy."
+    align: "right"
+
+# table rows (required)
+rows:
+- vehicle: "[2017 Hyundai Ioniq Hybrid](https://www.fueleconomy.gov/feg/noframes/38484.shtml \"2017 Hyundia Ioniq Hybrid\")"
+  num_stops: "**0**"
+  stop_time: "**0**"
+  cost: "$23.09"
+- vehicle: "[2019 Tesla Model 3 LR AWD](https://fueleconomy.gov/feg/Find.do?action=sbs&id=41190 \"2019 Tesla Model 3 LR AWD (my car)\")"
+  num_stops: "2"
+  stop_time: "17"
+  cost: "**$10.48**"
+- vehicle: "[2021 Ford Mustang Mach-E RWD](https://fueleconomy.gov/feg/Find.do?action=sbs&id=43604 \"2021 Ford Mustang Mach-E Standard RWD\")"
+  num_stops: "2"
+  stop_time: "51"
+  cost: "$23.27"
+- vehicle: "[2020 Hyundia Kona EV](https://fueleconomy.gov/feg/Find.do?action=sbs&id=44444 \"2020 Hyundai Kona EV\")"
+  num_stops: "2"
+  stop_time: "38"
+  cost: "$18.55"
diff --git a/data/tables/ev_crash_course/l1_charging_cost.yaml b/data/tables/ev_crash_course/l1_charging_cost.yaml
index d0aca01..a6b7bb3 100644
--- a/data/tables/ev_crash_course/l1_charging_cost.yaml
+++ b/data/tables/ev_crash_course/l1_charging_cost.yaml
@@ -8,7 +8,7 @@ cols:
     name: "Description"
     tip: "Amount of charge."
   - id: "energy"
-    name: "Energy (kWh)"
+    name: "Energy"
     tip: "Amount of energy gained, in kilowatt-hours (kWh)."
     align: "right"
   - id: "cost"
diff --git a/data/tables/ev_crash_course/l2_charging_cost.yaml b/data/tables/ev_crash_course/l2_charging_cost.yaml
new file mode 100644
index 0000000..e9ea674
--- /dev/null
+++ b/data/tables/ev_crash_course/l2_charging_cost.yaml
@@ -0,0 +1,29 @@
+---
+# table name (required)
+name: "Charging Cost, Home Level 2 Charger"
+
+# table columns (required)
+cols:
+  - id: "description"
+    name: "Description"
+    tip: "Amount of charge."
+  - id: "energy"
+    name: "Energy"
+    tip: "Amount of energy gained, in kilowatt-hours (kWh)."
+    align: "right"
+  - id: "cost"
+    name: "Cost"
+    tip: "Total cost of charge."
+    align: "right"
+
+# table rows (required)
+rows:
+- description: "50 miles of range"
+  energy: "14 kWh"
+  cost: "$1.99"
+- description: "90% SoC (270 miles)"
+  energy: "65.7 kWh"
+  cost: "$9.23"
+- description: "100% SoC (310 miles)"
+  energy: "75 kWh"
+  cost: "$10.27"
diff --git a/data/tables/ev_crash_course/l2_cost_per_mile.yaml b/data/tables/ev_crash_course/l2_cost_per_mile.yaml
new file mode 100644
index 0000000..3e55a67
--- /dev/null
+++ b/data/tables/ev_crash_course/l2_cost_per_mile.yaml
@@ -0,0 +1,31 @@
+---
+# table name (required)
+name: "Cost Per Mile Comparison, Home Level 2 Charger"
+
+# table columns (required)
+cols:
+  - id: "vehicle"
+    name: "Vehicle"
+    tip: "Vehicle."
+  - id: "source"
+    name: "Energy Source"
+    tip: "Source of energy."
+  - id: "unit_price"
+    name: "Unit Price"
+    tip: "Price of energy per unit."
+    align: "right"
+  - id: "cost_per_mile"
+    name: "Cost per Mile"
+    tip: "Cost to travel 1 mile in this vehicle and energy source."
+    align: "right"
+
+# table rows (required)
+rows:
+- vehicle: "[2017 Hyundai Ioniq Hybrid](https://www.fueleconomy.gov/feg/noframes/38484.shtml \"2017 Hyundia Ioniq Hybrid\")"
+  source: "Gasoline"
+  unit_price: "[$3.189/gallon](https://gasprices.aaa.com/?state=VA \"Cost of gas per gallon in Fairfax County\")"
+  cost_per_mile: "$0.0580"
+- vehicle: "[2019 Tesla Model 3 LR AWD](https://fueleconomy.gov/feg/Find.do?action=sbs&id=41190 \"2019 Tesla Model 3 LR AWD (my car)\")"
+  source: "Home L2 EVSE"
+  unit_price: "$0.13/kWh"
+  cost_per_mile: "**$0.0398**"
diff --git a/data/tables/ev_crash_course/l3_charging_cost.yaml b/data/tables/ev_crash_course/l3_charging_cost.yaml
new file mode 100644
index 0000000..20f3019
--- /dev/null
+++ b/data/tables/ev_crash_course/l3_charging_cost.yaml
@@ -0,0 +1,29 @@
+---
+# table name (required)
+name: "Charging Cost, Tesla Supercharger"
+
+# table columns (required)
+cols:
+  - id: "description"
+    name: "Description"
+    tip: "Amount of charge."
+  - id: "energy"
+    name: "Energy"
+    tip: "Amount of energy gained, in kilowatt-hours (kWh)."
+    align: "right"
+  - id: "cost"
+    name: "Cost"
+    tip: "Total cost of charge."
+    align: "right"
+
+# table rows (required)
+rows:
+- description: "50 miles of range"
+  energy: "14 kWh"
+  cost: "$3.50"
+- description: "90% SoC (270 miles)"
+  energy: "65.7 kWh"
+  cost: "$16.88"
+- description: "100% SoC (310 miles)"
+  energy: "75 kWh"
+  cost: "$18.75"
diff --git a/data/tables/ev_crash_course/l3_cost_per_mile.yaml b/data/tables/ev_crash_course/l3_cost_per_mile.yaml
new file mode 100644
index 0000000..ee69a38
--- /dev/null
+++ b/data/tables/ev_crash_course/l3_cost_per_mile.yaml
@@ -0,0 +1,31 @@
+---
+# table name (required)
+name: "Cost Per Mile Comparison, Tesla Supercharger"
+
+# table columns (required)
+cols:
+  - id: "vehicle"
+    name: "Vehicle"
+    tip: "Vehicle."
+  - id: "source"
+    name: "Energy Source"
+    tip: "Source of energy."
+  - id: "unit_price"
+    name: "Unit Price"
+    tip: "Price of energy per unit."
+    align: "right"
+  - id: "cost_per_mile"
+    name: "Cost per Mile"
+    tip: "Cost to travel 1 mile in this vehicle and energy source."
+    align: "right"
+
+# table rows (required)
+rows:
+- vehicle: "[2017 Hyundai Ioniq Hybrid](https://www.fueleconomy.gov/feg/noframes/38484.shtml \"2017 Hyundia Ioniq Hybrid\")"
+  source: "Gasoline"
+  unit_price: "[$3.189/gallon](https://gasprices.aaa.com/?state=VA \"Cost of gas per gallon in Fairfax County\")"
+  cost_per_mile: "**$0.0580**"
+- vehicle: "[2019 Tesla Model 3 LR AWD](https://fueleconomy.gov/feg/Find.do?action=sbs&id=41190 \"2019 Tesla Model 3 LR AWD (my car)\")"
+  source: "Supercharger"
+  unit_price: "$0.25/kWh"
+  cost_per_mile: "$0.0700"
diff --git a/data/tables/ev_crash_course/tesla_eugene_to_port_angeles.yaml b/data/tables/ev_crash_course/tesla_eugene_to_port_angeles.yaml
new file mode 100644
index 0000000..75305e6
--- /dev/null
+++ b/data/tables/ev_crash_course/tesla_eugene_to_port_angeles.yaml
@@ -0,0 +1,32 @@
+---
+# table name (required)
+name: "Cost Per Mile Comparison, Tesla Supercharger"
+
+# table columns (required)
+cols:
+  - id: "vehicle"
+    name: "Vehicle"
+    tip: "Vehicle."
+  - id: "num_stops"
+    name: "Number of Stops"
+    tip: "Number of stops required on this trip."
+    align: "right"
+  - id: "stop_time"
+    name: "Total Stop Time (min)"
+    tip: "Total amount of time stopped, in minutes."
+    align: "right"
+  - id: "cost"
+    name: "Cost"
+    tip: "Total cost of energy."
+    align: "right"
+
+# table rows (required)
+rows:
+- vehicle: "[2017 Hyundai Ioniq Hybrid](https://www.fueleconomy.gov/feg/noframes/38484.shtml \"2017 Hyundia Ioniq Hybrid\")"
+  num_stops: "**0**"
+  stop_time: "**0**"
+  cost: "$23.09"
+- vehicle: "[2019 Tesla Model 3 LR AWD](https://fueleconomy.gov/feg/Find.do?action=sbs&id=41190 \"2019 Tesla Model 3 LR AWD (my car)\")"
+  num_stops: "2"
+  stop_time: "17"
+  cost: "**$10.48**"
-- 
cgit v1.2.3