Hi Dallas
This spreadsheet work fine on Windows machines but the Mac version of Excel does some strange things when creating the Pivottable and chart.
Conclusion, stay with my Windows laptop to run the statistics.
Thanks again for this spreadsheet it certainly will help when looking at a glance to see which races to run with.
Playbyte
Simple Profit & Loss Chart Spreadsheet
-
- Posts: 41
- Joined: Fri Aug 29, 2014 3:36 pm
anybody any idea if in PRACTICE MODE you can use spreadsheets such as this
I use Horseracebase to download the previous days results, see attached. Then just copy and paste the required columns across to this sheet.WinSJS67 wrote:Could you recommend a website to clearly extract info for the spreadsheet?
Regards SJS
I have filtered it to show just the winners (so only one row from each race is shown).
The only column of info not on this sheet is the surface. (Turf or AW)
The race type also shows the full name but that takes 2 seconds to edit down for example
EBF Stallions Median Auction Maiden Fillies Stakes (Plus 10) to Mdn
Yes this thread details ways to save profit and losses using practice mode which can then be added to this spreadsheet just as normal.winevaults wrote:anybody any idea if in PRACTICE MODE you can use spreadsheets such as this
viewtopic.php?f=47&t=11349
You do not have the required permissions to view the files attached to this post.
-
- Posts: 10
- Joined: Sat Jul 23, 2016 3:41 pm
Your spreadsheet is fantastic!!!
thank you dallas. Your attached file was just what i was looking for and haved checked out Horseracebase. Currently on a free trial but for just £15 PCM will save so much time
Thanks again for all your advice to us newbies, to share your expertise and ideas for nothing in return shows your a true gent
thank you dallas. Your attached file was just what i was looking for and haved checked out Horseracebase. Currently on a free trial but for just £15 PCM will save so much time
Thanks again for all your advice to us newbies, to share your expertise and ideas for nothing in return shows your a true gent
Dallas wrote:I use Horseracebase to download the previous days results, see attached. Then just copy and paste the required columns across to this sheet.WinSJS67 wrote:Could you recommend a website to clearly extract info for the spreadsheet?
Regards SJS
I have filtered it to show just the winners (so only one row from each race is shown).
The only column of info not on this sheet is the surface. (Turf or AW)
The race type also shows the full name but that takes 2 seconds to edit down for example
EBF Stallions Median Auction Maiden Fillies Stakes (Plus 10) to Mdn
Yes this thread details ways to save profit and losses using practice mode which can then be added to this spreadsheet just as normal.winevaults wrote:anybody any idea if in PRACTICE MODE you can use spreadsheets such as this
viewtopic.php?f=47&t=11349
-
- Posts: 10
- Joined: Sat Jul 23, 2016 3:41 pm
Hi Dallas,
Great spreadsheet, just one little problem. I have deleted the test info in "my results" tab and entered my own. When i right click to refresh my new data (in row A) an error message is displayed stating "cannot open Pivottable source file"
Is this something easy to fix?
your continued support is much appreciated
Brooksyyid
Great spreadsheet, just one little problem. I have deleted the test info in "my results" tab and entered my own. When i right click to refresh my new data (in row A) an error message is displayed stating "cannot open Pivottable source file"
Is this something easy to fix?
your continued support is much appreciated
Brooksyyid
Thanks for your comments, if you have just removed the actual test data (this should be done anyway) then refreshing with your own should nt be a problem.
But if you have removed changed any of the column headers (Row A) this would cause it not to work as the pivottables are looking for these names.
If there is a column you dont want to use it can be left completely blank (not NA or 0)
ie, you could just fill in the going and distance columns along with your P&L if thats all the info you needed charting
But if you have removed changed any of the column headers (Row A) this would cause it not to work as the pivottables are looking for these names.
If there is a column you dont want to use it can be left completely blank (not NA or 0)
ie, you could just fill in the going and distance columns along with your P&L if thats all the info you needed charting
-
- Posts: 10
- Joined: Sat Jul 23, 2016 3:41 pm
Hi Dallas again,
sorry to bother you again
I love the idea of this spreadsheet but just cannot get it to work.
Step by step i
updated betangel to newest version
downloaded excel attachment
deleted test data starting from A2 downwards (didn't touch column headings)
entered 10 entries filling in each cell. No cells were blank or contained 0 or N/A
clicked on "type tab"
right clicked in column "A" to refresh.
then the attached screenshot is displayed
Again sorry to bother you
thanks
brooksyyid
sorry to bother you again
I love the idea of this spreadsheet but just cannot get it to work.
Step by step i
updated betangel to newest version
downloaded excel attachment
deleted test data starting from A2 downwards (didn't touch column headings)
entered 10 entries filling in each cell. No cells were blank or contained 0 or N/A
clicked on "type tab"
right clicked in column "A" to refresh.
then the attached screenshot is displayed
Again sorry to bother you
thanks
brooksyyid
You do not have the required permissions to view the files attached to this post.
Im not overly familiar with excel errors but that looks like you have it stored in one location but are updating from another.
Do you have the downloaded file saved to your local PC desktop or folder and are you opening it from and with Excel installed on that same computer?
Do you have the downloaded file saved to your local PC desktop or folder and are you opening it from and with Excel installed on that same computer?
You would just enter them manually on the 'My Results' tab (first delete out the samples ones that are their already) then just refresh as per the instructions on the OP to update all the charts etc