How to create a spreadsheet?

Posts: 12
I'm trying to create an overlay for Current/Live champ points. I have no idea what info should be in a spreadsheet or where the spreadsheet should go within the theme. Not sure I am explaining this very well but any help would be appreciated.
Posts: 287
For spreadsheet you have to use first column for iRacing ID, and then put information you want to show in other column. In them editor you have to add your Spreadsheet in the Spreadsheet section and configurate it for use first column as row-identifier. In row identifier type select CustomerId and check Use row identifier.
Then you can use in your widget informations from spreadsheet
Posts: 12
Emmanuel, Could you help me out in creating Champ/Live champ points overlay? I tried to figure it out myself from the past posts but I am a real noob. I don't understand the script stuff or how the widgets and data should be applied. I could use a real simple step by step. Thanks for the spreadsheet info.
Posts: 12
I got the spreadsheet made and it seems to be working. My only issue is it is not loading all the info in the spreadsheet. If I bind it to the position column it only shows P1 in overlay, it's not showing P2, P3, P4 etc. It's not populating the info beyond the first line in the spreadsheet. What am I missing?
Posts: 785
In short, spreadsheet data can be displayed in two ways:

- Use the spreadsheet as a data source: your widget will pull data from the spreadsheet row by row, you can display column data (of a row) in a label via data binding. Select the column name as the data binding. The Data Offset controls which row to show (0 is the first row, 1 is the second row, etc).

- Use the spreadsheet with an identifier to link it to drivers in the session. Follow what Emmanuel said to set up the spreadsheet in this way. Now the first column will be used to match a row of your spreadsheet to a driver in the session. To display column data for that driver, you can use the regular data binding system (select anything else as the data source), but at the bottom of the "Select data binding" list it should display the columns of your spreadsheet(s).


To be honest, building a fully live championship standings widget is going to be very complex. Possible perhaps but not easy unfortunately.
Posts: 12
Nick, Thank you for the info. I thought doing live points was possible with the bindings that are already in the editor. It would be a basic point system.