When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.
I guess my laptop doesn't have office to open the xlxs pid charting tool. Ive learned how to log with forscan and send it to my email just ran into a snag with the charting tool...not the best with computer stuff. Any recommendations on a computer with everything I need? Time to update.
I guess my laptop doesn't have office to open the xlxs pid charting tool. Ive learned how to log with forscan and send it to my email just ran into a snag with the charting tool...not the best with computer stuff. Any recommendations on a computer with everything I need? Time to update.
One of us could help you out, if you would like to shoot me a PM with your email address I can chart the data log for you and then post it here for you to view.
You can use "Open Office" to view the charts I believe. "Libre Office" is another free tool that may work. I know that "Microsoft Excel" is free to download and use across mobile devices.
Found this in a quick Google search.
At the new Office.com, you can use basic versions of Word, Excel, PowerPoint, and OneNote for free in your browser. They're the same Microsoft Office apps you're used to, only they run online and are 100% free.
You can purchase Microsoft Office from online sources like Amazon, more than likely you will want/need the "home and student" version like in the link below. If you are running Windows 7 instead of 10, there are other options available.
@ArmyLifer Eric, below are the 2 FSL data logs I took while riding in your Excursion the other day. I forgot that I have FSL set up for my ZF6 truck, so no transmission information was available. Perhaps @BWST can take a moment and look through the chart and/or data log in order to identify the "missing data" that you mentioned he saw before.
@FordTruckNoob taught me a new Excel trick this morning and I thought this might be a good place to share the information in case anyone else runs into this same problem.
Background: ArmyLifer has an Excursion that is experiencing an engine stumble once in a while. He hooked up his laptop to his OBDLink MX, but forgot to change the units of measurement from kPa to PSI for the ICP. I did not know how to mass convert the kPa to PSI, but Leonard was kind enough to do that for us all and then teach me how.
1. Open the Excel document with kPa as the measurement and insert a new column next to the kPa column and name it whatever you like. In this example I used ICP(PSI) because that is what the PID Charting Tool is looking for.
2. Select cell C2 or whichever cell is the first blank cell in the newly created column. In the example below, cell C2 is the new ICP(PSI) first cell and cell B2 is the existing ICP(kPa) cell. In cell C2, type =B2*0.145038 either in the cell or the cell editing bar near the top of the window.
Now that cell B2 is being multiplied by 0.145038 and the result is indicated in cell C2, you need to perform that equation for the entire C column.
3. Hover the mouse cursor over the bottom right corner of C2 and a + sign should appear.
4. Click and hold the bottom right corner of cell C2 once the plus sign appears and drag the mouse cursor down column C. This will populate column C with the equation of converting column B into PSI.
You are done! Now you can successfully chart the data log into the PID Charting Tool with the proper units of measurement. The data log you recorded is no longer wrong or useless to the PID Charting Tool. This same conversion can be used for any unit of measurement as long as you have the proper equation. For example, converting km/h to MPH.
@Sous Just an Excel shortcut I know: once you get the square on a box that you just entered your formula into...double click that square and it will auto fill that formula as far down as you have data.
@Sous Just an Excel shortcut I know: once you get the square on a box that you just entered your formula into...double click that square and it will auto fill that formula as far down as you have data.
Nice! I have learned two things today and it isn't even noon.
Originally Posted by Work Truck Fanatic
This is in the 7.3L section but am I correct that data logging from newer vehicles works also?
Yes, it will work for newer vehicles. But, the values on the vertical axis may not match up to the changed/edited PID's (you input) if they are not the same units of measurement or the same scale. Take a look at the improved version instructions (post #2) and let me know if you have questions or get stuck.
You could also try to use the older PID Charting Tool version (post #3) that has a video tutorial. There are a few more steps to manipulate the data, but it might work better for you since the vertical axis and scale is not fixed like it us in the improved version.
An updated version of the Improved PID Charting Tool has been uploaded to post #2. If you previously downloaded the tool to retain for use later, please delete that file and download the new file.
Nothing drastic changed, just a small time stamp bug in the 4th chart that resulted in the grid lines being a few milliseconds off from the other 3 charts. All of the data and trace lines are were still accurate.
Recently there was a question on how the sampling rate identified the ms timestamp when looking at the chart as a whole or one of the four graphs.
For example, the thread where jstihl was chasing a surge problem, we were unsure how the timestamp on the graph matched the data log. Link to the point of discovery which led to the question is here: https://www.ford-trucks.com/forums/1...l#post19580454
My direct question to BWST was as follows:
Originally Posted by Sous
The chart pinpoint information says "Point 232", but I am not exactly confident on how that relates to the raw data in the PID CSV tab. I don't know what line that Excel line "232" represents or what timestamp from FORScan "232" represents. My best guestimate is that it is the 232,xxx ms timestamp, but I would have to refer to BWST to verify that. The 232,xxx timestamp in the raw data log corresponds somewhat to the pinpoint information indicating "232", so maybe that is right.
The answer BWST provided was as follows:
Originally Posted by BWST
That's correct, Sous. The charts are set up to display in seconds rather than milliseconds to reduce clutter. The tool grabs every 10th data point, rounds it to the nearest 10th of a second, and plots it on the chart.
To expand on this a bit further, I have taken some snips of the data log and graph from jstihl's thread in order to illustrate what the quotes above mean. I feel this is important information to have for anyone looking at the chart and then wanting to see the details of the issue in the data log in the PID CSV tab.
Hovering the mouse over RPM near data log sampling point "186" provides the following pop up identifier.
This pop identifier shows us that at data log timestamp 186.4 the value of the cell is marked as 723. This can be seen below with a snip from the data log. Timestamp 186.4 represents 186XXX within the data log in the time(ms) column.
As of 8-13-2021 a new and updated version of the PID Charting Tool is available in post #2.
Our resident chart building expert Jeff (@BWST ) has been working hard behind the scenes to create an improved and updated version of the PID Charting Tool. I have had the easy task of working with him to test, break, fix and test again the product that is now being released to the public.
Some of the key updates are noted below...
.
PIDs displayed - The user now has the ability to display up to 20 PIDs on the chart with matching trace lines and values. These PIDs are indicated by the red arrow in the image below.
Chart resolution - There is a "chart resolution" block! This will allow the user to zoom in or out without loosing pertinent data being displayed. We have found this useful to use instead of the zoom slider bar in the bottom right. This allows for the user to upload a focus point to the FTE for others to view and dissect if requested. This resolution tool is indicated by the green arrow in the image below.
Imbedded instructions - The first tab in the worksheet is called "Instructions" which includes details on how to use the PID Charting Tool. This means that the only document you will need is the single PID Charting Tool. No need to download and utilize the separate instructions in PDF format. Although, we have included those instructions separately as some people prefer to use that method.
If possible, please take a moment thank BWST when you get the chance for devoting his own time and effort in making a tool for us to use at no charge. This PID Charting Tool has helped so many FTE'rs already and only has the potential to go up from here.
Thanks Jeff, we do appreciate your time and effort you have given selflessly to this community!
When we finally have the chance to shake hands and chat a bit, the beverages are on me!
Thanks for putting so much work into setting this up for everyone, can't wait to try this out. I was wondering if you could clarify what some of this data is stating. For instance I'm interested in comparing the engine speed in rpm's to the VSS in MPH. Is there a way to convert one to the other? I'm interested in detecting trans/ convertor slippage. When I look at the graphs above, specifically those two, I'm not sure if I'd be able to know if they are working correctly or not. Not sure if I'm even making any sense with my question to be honest, lol.
