Results 1 to 10 of 10

Thread: Temperature in Celsius

  1. #1
    Tuner in Training
    Join Date
    Jul 2020
    Posts
    12

    Temperature in Celsius

    Hi @all!
    Can you have temperature (from coolant) data from Torque output in RaceRender instead of Fahrenheit in Celsius?

  2. #2
    Advanced Tuner
    Join Date
    Apr 2018
    Posts
    293
    Since the conversion from *F to *C requires both subtraction and multiplication ((F-32)*5/9=C), there isn't an easy way to do this in RaceRender specifically. RaceRender does have conversions for speed built in, but those are mostly just multiplication anyway and could also be done with Custom Fields in the Input Data File Config.

    Even though you can't do it in RaceRender, it should be pretty easy to change what Torque displays and outputs. If you select the Gear/Settings Icon in the bottom left, select Settings, select Units, and check the "Use Celsius" box, then the next time you start logging, it should display and output Celsius.

    If you have a CSV file that you've already recorded and need converted, I could add an extra column with the appropriate units using Google Sheets pretty easily, but I think moving forward, that it would be easier to just have Torque output the desired units in the first place.

  3. #3
    Tuner in Training
    Join Date
    Jul 2020
    Posts
    12
    Thank you, i will try it.

  4. #4
    Tuner in Training
    Join Date
    Jul 2020
    Posts
    12
    Unfortunately that does not work. Excel converts various values when reading ...
    "16.33052061" becomes "1633052061", "-0.033998054" becomes "2.6E + 13" and so on. RaceRender can't do anything with that ...
    With the "Trim" e.g. any dashes or triangles are displayed instead of the actual route, etc.
    I also wrote to Torque - if I specify celsius for units, celsius should also be output everywhere!

  5. #5
    Advanced Tuner
    Join Date
    Apr 2018
    Posts
    293
    Quote Originally Posted by ozoffi View Post
    Unfortunately that does not work. Excel converts various values when reading ...
    "16.33052061" becomes "1633052061", "-0.033998054" becomes "2.6E + 13" and so on. RaceRender can't do anything with that ...
    With the "Trim" e.g. any dashes or triangles are displayed instead of the actual route, etc.
    I also wrote to Torque - if I specify celsius for units, celsius should also be output everywhere!
    Can you post the CSV here? I'm sure there's a way to get you the appropriate data if the CSV was working for you (even if it was just in the wrong units).

  6. #6
    Tuner in Training
    Join Date
    Jul 2020
    Posts
    12
    Here the CSV Files:
    "trackLog.csv" is original
    "trackLog2.cvs" is edit with Excel (inkl. coolant in Celsius)

    I got a slight improvement in the display by formatting it to text before converting text to columns. Nevertheless, this is then displayed in "trim2". Trim1 would be correct ....
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by ozoffi; 07-08-2020 at 08:30 AM.

  7. #7
    Advanced Tuner
    Join Date
    Apr 2018
    Posts
    293
    Quote Originally Posted by ozoffi View Post
    Here the CSV Files:
    "trackLog.csv" is original
    "trackLog2.cvs" is edit with Excel (inkl. coolant in Celsius)

    I got a slight improvement in the display by formatting it to text before converting text to columns. Nevertheless, this is then displayed in "trim2". Trim1 would be correct ....
    Wow, that's a really strange looking CSV. It definitely looks like Excel took the standard American formatting for each field (e.g. commas separating thousands and period as decimal: 16.33052061) and converted it to a European format (e.g. periods separating thousands and comma as decimal 1.633.052.061). It also appears to have replaced all the commas separating columns with semi-colons.

    Maybe uploading to Google Sheets would work better? That worked for me, but my locale would also default to the standard the Torque is outputting; so, I wouldn't run into those sorts of formatting issues. I added a column with:

    =(L2-32)*5/9

    And then dragged that for each row to give me this CSV:
    trackLog - trackLog.csv

    It has a few numbers rounded to 7 decimal places, but otherwise should be the same. Give that one a shot.

  8. #8
    Tuner in Training
    Join Date
    Jul 2020
    Posts
    12
    GREAT! It works

    But - whatever I'm doing wrong ... I don't know.
    I have now used Google Sheets and changed the country / language to English ... then loaded the original CSV, at the end put a new column with the formula - this is how it looks.

    I can't always request that someone edit the CVS accordingly ...
    So either Toruqe (since I already have the problem discussing ...) fixes the error, or RaceRender installs such a conversion feature.
    My current workaround is a pointer display without numbers - better than nothing.

    In any case, thank you for your effort!
    Attached Files Attached Files
    Last edited by ozoffi; 07-09-2020 at 03:21 AM.

  9. #9
    Tuner in Training
    Join Date
    Jul 2020
    Posts
    12
    Hello!
    By chance I found the solution to my problem - it's a function in RaceRender!
    E.g. open the "Coolant - Temp" object. Click on the "CONFIG" button in the properties to the right of the Input field. At the bottom of the field "Calculated Filed 1", open the field with "ADD" and select "F -> C", confirm with OK and you're done

    I am surprised that none of you specialists thought of this and that I was not offered this solution by the support either ...

  10. #10
    Advanced Tuner
    Join Date
    Apr 2018
    Posts
    293
    Those options under the calculated field do seem to be exactly what you need. I typically format my data with a script beforehand so that I get all my data to look nice prior to opening it in RaceRender. While I am aware of the Calculated Fields, I typically don't use them. I'll keep those options in mind for the next time someone has an issue like this.