Data to Information - What can I do with my logs

[chimpster23]

I have been logging charge stats as best as I can for months now since I have had the car. I tried to trace as much as I can and make decisions as best as I can such as when to charge, temp, pricing and so forth.

I have been aggregating this on excel till date and I feel like I have maxed out my analysis for tracking this.

I am looking to see if I should monitor track anything differently or if there is a better way to summarize this data now that I have a good subset of it.
I am open to hearing any other ideas or data points from you that I should try to track and also any behaviors to change / follow based on the log.

Notes
On the kWh column, it's calculation based, as ford didn't add this on the app until months after I got the car.
On the pricing some of it is estimated while others (noted at work) are hard prices paid with charge-point
I am a movie buff, and this summer was one of the better ones vs the past few years so I was constantly at AMC....
I think very occasionally I do tap over 80%, but I am getting better with trying to stay just at it now

Location

Date

Plugged In %

Unplugged %

Distance Added

Total Charge Time

Temperature

Total Charge Added

Minutes Charge Time

Charge Start

Average Miles Added Per Hour

Month

Season

kWh added

Price

Energy kWh/ Hour

Home

12/1/2022​

41%​

98%​

156

7:24:00​

30-50 Degrees

57%​

444

Low

21

12​

Winter

50

$ 6.02

6.8

Home

12/2/2022​

95%​

100%​

20

2:19:00​

30-50 Degrees

5%​

139

High

9

12​

Winter

4

$ 0.53

1.9

Home

12/4/2022​

82%​

83%​

10

1:05:00​

30-50 Degrees

1%​

65

High

9

12​

Winter

1

$ 0.11

0.8

Home

12/5/2022​

70%​

80%​

24

1:17:00​

30-50 Degrees

10%​

77

Low

19

12​

Winter

9

$ 1.06

6.9

Pizza / Diner

12/7/2022​

69%​

74%​

15

0:44:00​

30-50 Degrees

5%​

44

Low

20

12​

Winter

4

6.0

Home

12/8/2022​

61%​

75%​

30

1:36:00​

30-50 Degrees

14%​

96

Low

19

12​

Winter

12

$ 1.48

7.7

Friend

12/16/2022​

51%​

52%​

1

0:06:00​

30-50 Degrees

1%​

6

Low

10

12​

Winter

1

8.8

Mall / AMC A List

1/8/2023​

28%​

37%​

19

1:32:00​

30-50 Degrees

9%​

92

Low

12

1​

Winter

8

5.2

Pizza / Diner

1/9/2023​

23%​

29%​

11

0:45:00​

30-50 Degrees

6%​

45

Low

15

1​

Winter

5

7.0

Home

1/9/2023​

23%​

79%​

120

7:00:00​

30-50 Degrees

56%​

420

Low

17

1​

Winter

49

$ 5.91

7.0

Home

1/12/2023​

40%​

64%​

54

2:59:00​

30-50 Degrees

24%​

179

Low

18

1​

Winter

21

$ 2.53

7.1

Mall / AMC A List

1/13/2023​

29%​

43%​

26

2:06:00​

30-50 Degrees

14%​

126

Low

12

1​

Winter

12

5.9

Home

1/15/2023​

49%​

76%​

60

3:25:00​

30-50 Degrees

27%​

205

Low

18

1​

Winter

24

$ 2.85

7.0

Mall / AMC A List

1/15/2023​

38%​

51%​

26

2:02:00​

30-50 Degrees

13%​

122

Low

13

1​

Winter

11

5.6

Home

1/16/2023​

53%​

60%​

15

0:48:00​

30-50 Degrees

7%​

48

Low

19

1​

Winter

6

$ 0.74

7.7

Home

1/19/2023​

17%​

79%​

125

7:16:00​

30-50 Degrees

62%​

436

Low

17

1​

Winter

55

$ 6.55

7.5

Mall / AMC A List

1/21/2023​

58%​

73%​

28

2:21:00​

30-50 Degrees

15%​

141

Low

12

1​

Winter

13

5.6

Mall / AMC A List

3/24/2023​

45

2:49:00​

30-50 Degrees

169

Low

16

3​

Winter

19

6.7

Mall / AMC A List

3/25/2023​

35

2:10:00​

30-50 Degrees

130

Low

16

3​

Winter

15

6.7

Mall / AMC A List

3/31/2023​

36

2:14:00​

30-50 Degrees

134

Low

16

3​

Winter

15

6.7

Mall / AMC A List

4/1/2023​

35

2:05:00​

30-50 Degrees

125

Low

17

4​

Spring

14

6.7

Mall / AMC A List

4/8/2023​

33

1:56:00​

50-80 Degrees

116

Low

17

4​

Spring

13

6.7

Mall / AMC A List

4/9/2023​

31

1:51:00​

50-80 Degrees

111

Low

17

4​

Spring

12

6.7

Home

4/16/2023​

25%​

80%​

147

8:24:00​

50-80 Degrees

55%​

504

Low

18

4​

Spring

48

$ 5.81

5.8

Home

4/20/2023​

34%​

80%​

129

6:52:00​

50-80 Degrees

46%​

412

Low

19

4​

Spring

40

$ 4.86

5.9

home

4/24/2023​

37%​

81%​

120

5:41:00​

50-80 Degrees

44%​

341

Low

21

4​

Spring

39

$ 4.65

6.8

Mall / AMC A List

4/30/2023​

25%​

42%​

41

2:39:00​

50-80 Degrees

17%​

159

Low

15

4​

Spring

15

5.6

Home

5/1/2023​

21%​

80%​

160

8:27:00​

50-80 Degrees

59%​

507

Low

19

5​

Spring

52

$ 6.23

6.1

Mall / AMC A List

5/4/2023​

47%​

70%​

65

3:40:00​

50-80 Degrees

23%​

220

Low

18

5​

Spring

20

5.5

Mall / AMC A List

5/5/2023​

68%​

80%​

33

1:57:00​

50-80 Degrees

12%​

117

Low

17

5​

Spring

11

5.4

Pizza / Diner

5/10/2023​

71%​

79%​

25

1:01:00​

50-80 Degrees

8%​

61

Low

25

5​

Spring

7

6.9

Mall / AMC A List

5/11/2023​

67%​

79%​

37

2:05:00​

50-80 Degrees

12%​

125

Low

18

5​

Spring

11

5.1

Mall / AMC A List

5/14/2023​

78%​

90%​

36

2:12:00​

50-80 Degrees

12%​

132

Low

16

5​

Spring

11

4.8

Mall / AMC A List

5/18/2023​

65%​

88%​

65

3:57:00​

50-80 Degrees

23%​

237

Low

16

5​

Spring

20

5.1

Mall / AMC A List

5/24/2023​

26%​

36%​

28

1:32:00​

50-80 Degrees

10%​

92

Low

18

5​

Spring

9

5.7

Mall / AMC A List

5/25/2023​

26%​

44%​

46

2:46:00​

50-80 Degrees

18%​

166

Low

17

5​

Spring

16

5.7

Mall / AMC A List

5/26/2023​

37%​

52%​

40

2:19:00​

50-80 Degrees

15%​

139

Low

17

5​

Spring

13

5.7

Friends Parking Garage

5/28/2023​

38%​

64%​

69

8:01:00​

50-80 Degrees

26%​

481

Low

9

5​

Spring

23

2.9

Mall / AMC A List

5/29/2023​

53%​

65%​

38

1:55:00​

50-80 Degrees

12%​

115

Low

20

5​

Spring

11

5.5

Home

6/3/2023​

33%​

80%​

127

8:36:00​

50-80 Degrees

47%​

516

Low

15

6​

Spring

41

$ 4.96

4.8

Friends Parking Garage

6/3/2023​

67%​

69%​

4

0:36:00​

50-80 Degrees

2%​

36

Low

7

6​

Spring

2

2.9

Work

6/7/2023​

29%​

42%​

35

3:03:00​

50-80 Degrees

13%​

183

Low

11

6​

Spring

11

$ 0.98

3.8

Mall / AMC A List

6/7/2023​

35%​

55%​

53

2:48:00​

50-80 Degrees

20%​

168

Low

19

6​

Spring

18

6.3

Mall / AMC A List

6/10/2023​

51%​

66%​

48

2:32:00​

50-80 Degrees

15%​

152

Low

19

6​

Spring

13

5.2

Work

6/12/2023​

53%​

71%​

46

3:51:00​

50-80 Degrees

18%​

231

Low

12

6​

Spring

16

$ 1.37

4.1

Work

6/13/2023​

61%​

80%​

50

5:27:00​

50-80 Degrees

19%​

327

Low

9

6​

Spring

17

$ 1.49

3.1

Work

6/21/2023​

28%​

71%​

124

10:16:00​

50-80 Degrees

43%​

616

Low

12

6​

Summer

38

$ 3.36

3.7

Work

6/22/2023​

62%​

79%​

49

5:22:00​

50-80 Degrees

17%​

322

Low

9

6​

Summer

15

$ 1.34

2.8

Mall / AMC A List

6/24/2023​

48%​

64%​

49

2:40:00​

50-80 Degrees

16%​

160

Low

18

6​

Summer

14

5.3

Work

6/26/2023​

56%​

80%​

71

4:03:00​

50-80 Degrees

24%​

243

Low

18

6​

Summer

21

$ 1.90

5.2

Work

6/28/2023​

42%​

68%​

76

4:15:00​

50-80 Degrees

26%​

255

Low

18

6​

Summer

23

$ 2.00

5.4

Mall / AMC A List

6/29/2023​

60%​

82%​

68

3:44:00​

50-80 Degrees

22%​

224

Low

18

6​

Summer

19

5.2

Work

7/5/2023​

28%​

83%​

155

9:24:00​

50-80 Degrees

55%​

564

Low

16

7​

Summer

48

$ 4.32

5.1

Work

7/10/2023​

28%​

81%​

149

8:49:00​

50-80 Degrees

53%​

529

Low

17

7​

Summer

47

$ 4.11

5.3

Work

7/12/2023​

61%​

85%​

67

4:01:00​

50-80 Degrees

24%​

241

Low

17

7​

Summer

21

$ 1.88

5.3

Mall / AMC A List

7/13/2023​

71%​

85%​

39

2:06:00​

50-80 Degrees

14%​

126

Low

19

7​

Summer

12

5.9

Work

7/19/2023​

48%​

66%​

52

3:11:00​

50-80 Degrees

18%​

191

Low

16

7​

Summer

16

$ 1.48

5.0

Work

7/19/2023​

66%​

79%​

43

3:18:00​

50-80 Degrees

13%​

198

Low

13

7​

Summer

11

$ 1.14

3.5

Work

7/24/2023​

34%​

53%​

54

4:33:00​

50-80 Degrees

19%​

273

Low

12

7​

Summer

17

$ 1.46

3.7

Work

7/24/2023​

53%​

76%​

70

4:04:00​

50-80 Degrees

23%​

244

Low

17

7​

Summer

20

$ 1.90

5.0

Work

7/25/2023​

48%​

68%​

56

3:27:00​

50-80 Degrees

20%​

207

Low

16

7​

Summer

18

$ 1.56

5.1

Work

7/26/2023​

56%​

85%​

94

5:37:00​

50-80 Degrees

29%​

337

Low

17

7​

Summer

26

$ 2.62

4.5

Work

8/1/2023​

60%​

70%​

30

3:23:00​

50-80 Degrees

10%​

203

Low

9

8​

Summer

9

$ 0.85

2.6

Work

8/1/2023​

69%​

82%​

38

3:21:00​

50-80 Degrees

13%​

201

Low

11

8​

Summer

11

$ 1.03

3.4

Work

8/7/2023​

56%​

74%​

69

4:07:00​

50-80 Degrees

18%​

247

Low

17

8​

Summer

16

$ 1.92

3.8

Work

8/7/2023​

74%​

79%​

23

2:20:00​

50-80 Degrees

5%​

140

Low

10

8​

Summer

4

$ 0.64

1.9

Work

8/8/2023​

65%​

69%​

18

1:43:00​

50-80 Degrees

4%​

103

Low

10

8​

Summer

4

$ 0.39

2.1

Work

8/8/2023​

69%​

76%​

19

2:14:00​

50-80 Degrees

7%​

134

Low

9

8​

Summer

6

$ 0.56

2.8

Work

8/8/2023​

75%​

82%​

50-80 Degrees

7%​

-

Low

-

8​

Summer

6

-

Sponsored

 

[Mach-Lee]

I don't understand, what do YOU want to know based on your data? What's your goal?

It seems like you are just collecting data for the sake of collecting data?

Unless you have a reason not to, the answer is "charge at night" in most cases.

 

[Logal727]

I usually make a nice fire

 

[chimpster23]

My main objective was tracking cost, L2 charge speeds and charge efficiency (output from charge point vs input based on fordpass)

Then I used these results to project what my typical cost / standard would be over time.

 

[tbrumleve]

Most of this I get from my ChargePoint Home Flex. I get monthly statements showing cost, energy, and miles for each charge session. Way more info than I ever needed, and never cared about on my ICE vehicle.

 

[ebeponyan]

What can I do with my logs

I'd be wary of any data pulled from FordPass. You could get a vague sense of cost and energy usage (as you are), but it won't be precise or controlled enough to REALLY drill into. Even if you get a solid answer for, say, charging loss percent at your home charger by temperature, what do you do with that information? What do we do with it? Although even more uncontrolled, there's a little more value in anecdotal driving and DCFC data because it's more immediately actionable for trip planning, but L2 tends to just be plug in and forget.

That said, you have all this data, so you might as well play around with it and see if you can identify any trends, or reject any hypotheses. I just can't think of much to make from this.

I am a movie buff

In that case:

 

[RickMachE]

I don't understand, what do YOU want to know based on your data? What's your goal?

It seems like you are just collecting data for the sake of collecting data?

Unless you have a reason not to, the answer is "charge at night" in most cases.

Sure, burst the balloon.

Data is good. I have Quicken data back to 1996. Not sure how much gas was then? I know.

 

[chimpster23]

I'd be wary of any data pulled from FordPass. You could get a vague sense of cost and energy usage (as you are), but it won't be precise or controlled enough to REALLY drill into. Even if you get a solid answer for, say, charging loss percent at your home charger by temperature, what do you do with that information? What do we do with it? Although even more uncontrolled, there's a little more value in anecdotal driving and DCFC data because it's more immediately actionable for trip planning, but L2 tends to just be plug in and forget.

That said, you have all this data, so you might as well play around with it and see if you can identify any trends, or reject any hypotheses. I just can't think of much to make from this.



In that case:

I was able to infer less energy loss at the charge point charger at my work vs at home as well as price it out a little better due to subsidized pricing. Based on that I changed how I charge the car and rarely use it at the home charger anymore

also to the gif....my dad introduced me to the airplane! series, fun flicks to watch