Can you export an entire card to one excel tab? - Pace and Cap

sq764 · 12-07-2009, 03:23 PM

Is there a way to export an entire race card to one excel file? If this has ben mentioned before somewhere sorry..

Ted Craven · 12-07-2009, 04:08 PM

Check ALL lines from ALL horses to the Analysis screen, then Export to Excel, then collate in another worksheet by tab, or however. I've never tried this. Depending on how many lines that is, it may or may not work. Try it and let us know.

Ted

sq764 · 12-07-2009, 04:14 PM

Maybe I asked this wrong... Instead of individually exporting each race's BL screen to seperate excel spreadsheets, is there a way to put all 9 or 10 BL screens on one spreadsheet?

Ted Craven · 12-07-2009, 04:20 PM

Yes, check out Richie's video on using the Export to Excel, then copying single lines (i.e. the Winner's) to a spreadsheet for your track, distance and surface.

If you want all 5 lines (say, for 5 race contenders) per race to appear in one sheet, not just the Winner's line, then simply copy and paste all lines in the Excel export file. Not sure what this would achieve though. Can you explain your goal? To model factors, you probably want to capture what the Winner did from the line you chose for it (or perhaps the Place horse, in a separate model).

Ted

sq764 · 12-07-2009, 04:57 PM

Quote:

Originally Posted by Ted Craven

Yes, check out Richie's video on using the Export to Excel, then copying single lines (i.e. the Winner's) to a spreadsheet for your track, distance and surface.

If you want all 5 lines (say, for 5 race contenders) per race to appear in one sheet, not just the Winner's line, then simply copy and paste all lines in the Excel export file. Not sure what this would achieve though. Can you explain your goal? To model factors, you probably want to capture what the Winner did from the line you chose for it (or perhaps the Place horse, in a separate model).

Ted

Say for sake of ease, I wanted to take a printout of 2 or 3 racecards to simulcast from RDSS exports. (The actual BL ratings for 2 or 3 tracks) and I wanted all the races for each track on one sheet..

Ted Craven · 12-07-2009, 05:13 PM

Take at look at the Excel Sheets posted by Seattlesnake. Among other data, he has made screen captures of the BL/BL screen with his final contenders, with all the colours and ranks and markings, and pasted it into his worksheet. You could do that, one tab for each card, one race's BL/BL (or other) screen after the other, with any notes you might want to add as cues for betting or reminders.

I think the raw output of factors to an Excel file, factor ranks and numbers would be very much less intuitive to read and way overkill and mind-numbing - not the intent of that Export to Excel feature.

You can paste your screen captures into Excel, or Word, or an Outlook message, or a RTF file composed in Wordpad, or whatever. I suggest retaining the nice markups amd impactful nature of the Analysis screen formatting in RDSS.

Ted

12-07-2009, 03:23 PM	#1
sq764 AlwNW3X Join Date: Jun 2005 Posts: 45	Can you export an entire card to one excel tab? Is there a way to export an entire race card to one excel file? If this has ben mentioned before somewhere sorry..

12-07-2009, 04:08 PM	#2
Ted Craven Grade 1 Join Date: Jun 2005 Location: Nanaimo, British Columbia, Canada Posts: 8,853	Check ALL lines from ALL horses to the Analysis screen, then Export to Excel, then collate in another worksheet by tab, or however. I've never tried this. Depending on how many lines that is, it may or may not work. Try it and let us know. Ted __________________ RDSS - Racing Decision Support System™

12-07-2009, 04:20 PM	#4
Ted Craven Grade 1 Join Date: Jun 2005 Location: Nanaimo, British Columbia, Canada Posts: 8,853	Yes, check out Richie's video on using the Export to Excel, then copying single lines (i.e. the Winner's) to a spreadsheet for your track, distance and surface. If you want all 5 lines (say, for 5 race contenders) per race to appear in one sheet, not just the Winner's line, then simply copy and paste all lines in the Excel export file. Not sure what this would achieve though. Can you explain your goal? To model factors, you probably want to capture what the Winner did from the line you chose for it (or perhaps the Place horse, in a separate model). Ted __________________ RDSS - Racing Decision Support System™

12-07-2009, 05:13 PM	#6
Ted Craven Grade 1 Join Date: Jun 2005 Location: Nanaimo, British Columbia, Canada Posts: 8,853	Take at look at the Excel Sheets posted by Seattlesnake. Among other data, he has made screen captures of the BL/BL screen with his final contenders, with all the colours and ranks and markings, and pasted it into his worksheet. You could do that, one tab for each card, one race's BL/BL (or other) screen after the other, with any notes you might want to add as cues for betting or reminders. I think the raw output of factors to an Excel file, factor ranks and numbers would be very much less intuitive to read and way overkill and mind-numbing - not the intent of that Export to Excel feature. You can paste your screen captures into Excel, or Word, or an Outlook message, or a RTF file composed in Wordpad, or whatever. I suggest retaining the nice markups amd impactful nature of the Analysis screen formatting in RDSS. Ted __________________ RDSS - Racing Decision Support System™

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
TP/KD Sept 26 - Problem Card	Ted Craven	RDSS	3	09-28-2009 07:43 AM
RDSS Excel Template	Zaf	RDSS	2	08-29-2009 10:11 PM
Release Notes - Version 0.98.8	Ted Craven	RDSS Info, Reference	3	07-28-2009 08:35 PM
RDSS Modeller Export	Ted Craven	RDSS	16	07-26-2009 05:30 PM

12-07-2009, 04:14 PM	#3
sq764 AlwNW3X Join Date: Jun 2005 Posts: 45	Maybe I asked this wrong... Instead of individually exporting each race's BL screen to seperate excel spreadsheets, is there a way to put all 9 or 10 BL screens on one spreadsheet?