Been busy updating the back end of things how the data is stored. Here's a sneak peek for any Excel nerds (
@tigeo ). This is the "fact sheet" with all the pertinent data to tie together:
And this is a look at the "relational database" structure used. By converting everything to this I was able to cut the data model size and loading times by about 75%.
So enough of that... as far as the end user viewing it goes here are some notable changes:
Updated cover page detailing what goes into each log, etc and what is contained inside
At the front is a data table to be a central key for all sample numbers/users/etc. Important temps are color coded to visually see what may stick out, with some basic info on each sample. Refer to the specific sample pages for more info as needed.
And then a chart showing IAT mins and averages, broken down per intercooler + turbo combo. If there are multiple examples, their mins and averages get averaged together. Summary of how many were averaged into each bar on the right.
Then there are a bunch of user samples. I've got all the pages standardized to show oil temp actual and oil temp modeled (what most people log) so it's clear which is being used. All 200 second snips of logs are shown to see the lines going up and down with speed, etc. Ambient temp hardly changes per car so that one chart is a comparison against ALL other samples for reference. I'm also trying to get more people logging the coolant outlet PID... which combined with the ECT we can sort of tell how well the radiator is working (more on that towards the end). The oil temp modeled value is a dotted line because in many cases it's basically bullshit anyway.
Then at the end these are just some charts of stuff that currently interests me - it's not enough data to deduce conclusions yet but I really want to get more samples to see if the CSF radiator actually even makes a difference. My hunch is that the added capacity helps temps for maybe an initial lap or so, but it doesn't shed heat as quickly as the OEM (or perhaps is basically a lateral move with no real improvement). The large spread in ambient temps and and average TPS of course makes comparisons kind of hard. Currently only interested in IS38 + tuned + aftermarket intercooler samples in an attempt to keep it as close to controlled as possible.
And also comparing the coolant outlet vs engine coolant temp of the above radiators. Unfortunately data available with coolant outlet temp is limited, so there are currently both IS20 and IS38 cars on here. The only IS38 CSF equipped car that has logged coolant outlet temps also has a well-ducted oil cooler so this can go a few different ways:
1. The coolant is already many degrees cooler so smaller delta-T means it just doesn't HAVE to drop as much temp
2. If it's anything like IATs, the amount of heat in the system won't make a big difference as far as deltas go.
Not sure but it interests me.
I have a few logs from my own car to add but that's a low priority. I've been working on this redesign for a while which should make things easier in the long run.
FULL REPORT HERE:
https://drive.google.com/file/d/17OmZvC_tlsmpFnLV45jxSy9Ocyry3ZaX/view?usp=sharing