Fichiers Calibre Biometrics

5

Updated

Meanwhile a short cut:

Procedure: Creating a Combined Streams File for Intervals.icu

This guide outlines the steps to merge data from your Garmin Fit file (via Intervals.icu) with your Calibre CSV file using Microsoft Excel.

Prerequisites:

  • Ensure your phone/computer and Garmin/Edge device have their times synchronized recently.
  • Have the streams.csv file from Intervals.icu and your Calibre CSV file ready.

Step 1: Ensure Time Synchronization before doing a recording.

Accurate data merging requires perfectly synchronized timestamps.

  1. Reset your phone to ensure a fresh state for syncing and update from time servers.
  2. Re-sync time in your Garmin Edge device with that phone Garmin Connect.
  3. If possible, start recording on both devices at the same time.

Step 2: Prepare the CSV Files in Excel

  1. Check activity streams (power, heart rate, cadence etc.) and custom streams. Only these will be exported,
  2. Export streams.csv file from activity Data TAB
  3. Open the CSV file in Excel
  4. Open the CSV file exported from Calibre.
  5. You should now have both files open in separate Excel windows.

Step 3: Copy Data from Calibre to Intervals.icu File

  1. In the Calibre CSV file, identify and select the columns containing the data you need (e.g., Vo2, VCO2, RER…..).
  2. Copy these selected columns.
  3. Switch to the Intervals.icu streams.csv file.
  4. Click on the cell in the first empty column where you want the data to begin (e.g., column Z).
  5. Paste the Calibre data into this column, ensuring the rows align correctly with the corresponding timestamps(or Heart Rate or Power).

Important: Use the “David VO2 Master Customs Streams” and Missing some data from Tymewear - #11 by david as a reference for correct naming conventions and data mapping.

Step 4: Finalize and Upload

  1. Remove Unnecessary Columns from the combined file:
    Delete any Calibre columns you don’t need, but keep all columns from the Intervals streams.csv file to simplify the data and avoid potential conflicts.
  2. Save the modified Intervals.icu file, ensuring you maintain the CSV format.
  3. Check that column headers in the CSV match Code in custom activity streams Type definitions. Create missing custom activity stream using the headers in the combined streams.csv as Code.
  4. Upload this combined streams.csv file back to the corresponding activity on Intervals.icu.
  5. Ensure persistence: Activity>> Data>>Export Fit File
2 Likes