Sponsored

Firn

Well-known member
Joined
Aug 26, 2024
Threads
32
Messages
1,505
Reaction score
1,700
Location
USA
Vehicles
23 Pro ER
Following up on my previous post about deconstructing PIDs from Forscan and CarScanner, I’ve been using a long-term monitoring setup to see how my Lightning Pro ER actually behaves under the hood.

The Setup:

  • Hardware: An old phone permanently mounted in the cubby.
  • Software: Torque Pro (logging) + Tasker + Auto-upload to Google Drive.
  • Backend: Raw logs cleaned and ingested into DuckDB using Python scripts.
  • The "Brain": Full disclosure—I used Google Gemini to write the Python scripts and build the dashboards. It’s been virtually hands-off once the automation was set up.
Here are the findings from the data so far:

1. Performance vs. State of Charge (SOC)
A common question is whether the truck limits current as the SOC drops.

Current: Looking at the data, the answer appears to be no. Maximum current remains remarkably consistent even as SOC decreases.

Ford F-150 Lightning Deep-Dive: Lightning Pro ER Performance & Efficiency via Custom PID Logging 1769915282367-gq


Power: While current stays steady, total power does drop slightly as SOC falls. This is the expected result of voltage sag as the battery depletes.

Ford F-150 Lightning Deep-Dive: Lightning Pro ER Performance & Efficiency via Custom PID Logging 1769915448700-4


2. Acceleration & Speed
We know acceleration feel tapers off at higher speeds, and the data confirms why:

Wind Resistance: Obviously, the "brick" shape of the truck plays a role.
Current Limiting: The data shows the truck actively tapers current once you cross approximately 60 mph. You can see the clear "roll-off" in the current chart at the top end of the speed range.
Ford F-150 Lightning Deep-Dive: Lightning Pro ER Performance & Efficiency via Custom PID Logging 1769915589993-5q


Ford F-150 Lightning Deep-Dive: Lightning Pro ER Performance & Efficiency via Custom PID Logging 1769915697290-uc




3. Battery Capacity & Temperature Effects
Does temperature affect stored energy? Yes, but the way Ford displays it is the real story.

Energy per 1% SOC: My analysis shows there is more energy per 1% of battery at higher SOCs than at lower ones (the scale isn't perfectly linear).
Ford F-150 Lightning Deep-Dive: Lightning Pro ER Performance & Efficiency via Custom PID Logging 1769916399821-wt


The "Cold" Manipulation: When looking at energy by SOC colored by temperature, you can see how cold weather affects the pack. More specifically, it shows how Ford's BMS manipulates the displayed SOC to show a "higher" percentage for a given amount of raw energy when temps drop.

Ford F-150 Lightning Deep-Dive: Lightning Pro ER Performance & Efficiency via Custom PID Logging 1769916537460-dz


4. Aerodynamics & Efficiency
I attempted to correlate average power by speed and temperature. While the speed/temp data is interesting, trying to isolate the effects of wind speed and direction on efficiency has been difficult—the data is still a bit too noisy to draw a "smoking gun" conclusion there.

Ford F-150 Lightning Deep-Dive: Lightning Pro ER Performance & Efficiency via Custom PID Logging 1769916141473-p9


Ford F-150 Lightning Deep-Dive: Lightning Pro ER Performance & Efficiency via Custom PID Logging 1769915986048-e2


Ford F-150 Lightning Deep-Dive: Lightning Pro ER Performance & Efficiency via Custom PID Logging 1769916073695-d2


Sadly attempts to determine the effects of wind speed and direction on efficiency are not as clear.

5. Tire Pressure (TPMS)
I tried to quantify the efficiency gains of higher tire pressure.

The Verdict: My data (and separate controlled tests) suggests that tire pressure has a negligible effect on overall efficiency in this platform.

Ford F-150 Lightning Deep-Dive: Lightning Pro ER Performance & Efficiency via Custom PID Logging 1769916945077-wt


6. The "Secret" Drive Map
One of the coolest features of the DuckDB setup is the ability to generate a GPS heat map of every drive. I can color the map by any metric—kiloWatts used, motor temp, or speed. (I’m keeping the map private for obvious reasons, but the visualization is a game-changer for spotting efficiency "black holes" on my daily routes!)



I want to be clear—I didn’t manually write the code for this. I used Google Gemini as my lead engineer to build the entire backend. If you’ve been sitting on piles of CSV logs but don't know Python or SQL, this is the way to do it.

What the AI handled:
  • Python Automation: Gemini wrote the scripts that monitor my Google Drive, grab the raw Torque CSVs, and handle the "cleaning" (fixing timestamps, removing nulls, and filtering out GPS glitches).
  • The Database (DuckDB): It devised the logic to ingest that data into DuckDB, creating a high-performance local database that makes querying months of driving data nearly instant.
  • The Dashboard Logic: It wrote the Streamlit and Python code to generate the actual charts and performance visuals, including the logic to calculate "Energy per 1% SOC."
  • The Workflow: It even helped me set up the .bat files and Tasker triggers so the whole pipeline runs with a single click (or no clicks at all).
The barrier to entry for this kind of "Big Data" analysis on our trucks is gone. I just described what I wanted the data to show, and the AI provided the syntax to make it happen.
Sponsored

 
Last edited:

mr.Magoo

Well-known member
Joined
May 27, 2022
Threads
24
Messages
965
Reaction score
1,228
Location
Michigan
Vehicles
2022 Lariat ER, AMB
2. Acceleration & Speed
We know acceleration feel tapers off at higher speeds, and the data confirms why:
I think it would be helpful for the rest of us who is doing some data collection to see what values you're looking at.

Plus It would probably be more relevant to look at commanded torque (instead of amps) vs. speed vs. throttle position unless you drive your truck strictly digital (ie, all or nothing).
 
OP
OP
Firn

Firn

Well-known member
Joined
Aug 26, 2024
Threads
32
Messages
1,505
Reaction score
1,700
Location
USA
Vehicles
23 Pro ER
I think it would be helpful for the rest of us who is doing some data collection to see what values you're looking at.

Plus It would probably be more relevant to look at commanded torque (instead of amps) vs. speed vs. throttle position unless you drive your truck strictly digital (ie, all or nothing).
Lots of ways to mix and match the data, this is certainly just the first go at it.

In this case my primary interest was in the current capabilities as that is likely to be the biggest limiting factor of the Lightnings design. Specifically where does Ford set the limit and how do they enforce it.

Torque vs speed vs throttle position (torque, not torque commanded)
Ford F-150 Lightning Deep-Dive: Lightning Pro ER Performance & Efficiency via Custom PID Logging 1769954090328-1a
 

Sponsored

branden

Active member
First Name
Branden
Joined
Mar 12, 2025
Threads
2
Messages
28
Reaction score
43
Vehicles
'22 Lightning Lariat ER
Yeah, I could do that.

I will admit, right now its just a large number of messy scripts.
The data pipeline would be interesting as well
 
OP
OP
Firn

Firn

Well-known member
Joined
Aug 26, 2024
Threads
32
Messages
1,505
Reaction score
1,700
Location
USA
Vehicles
23 Pro ER
The data pipeline would be interesting as well
Front end is pretty easy.

Old Android phone mounted in the cubby. It where I can see it if needed, but it's mounted on the front wall of the cubby so it's out of the way.

The android app Tasker opens the logging app once the phone gets power, and sends it to the home screen when power is stopped so that the phone can naturally sleep.

For logging (and as a dashboard) I use Torque, specifically because it makes well structured CSV files directly, no export or cleanup required.

From there I use an app (can't remember the name, I just googled something) that automatically syncs to my Google drive when the phone connects to my wifi.

After that I use Google Drive for Desktop with the sync for offline enabled and the script pull from the "G" drive for bringing into the Database.

The rest is scripts for ingestion, cleanup, etc. Then of course the dashboards.
Sponsored

 
Last edited:
 







Top