help with Bet Angel multiple file

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
fwcon
Posts: 15
Joined: Mon Aug 10, 2020 10:51 am

I can only get 10 sheets on the Bet Angel multiple file, i.e. Bet Angel 10 is the last sheet in the file and I can't create more than that, the next sheet is named "blank". Is 10 the maximum amount of sheets?
User avatar
Dallas
Posts: 22673
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

You add your own and just name them Bet Angel 11, Bet Angel 12 etc
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

i did one for 180 events for greyhounds
fwcon
Posts: 15
Joined: Mon Aug 10, 2020 10:51 am

thanks guys, silly me.
captainbang
Posts: 82
Joined: Tue May 01, 2018 1:33 pm

I am using the spreadsheet "IXL Data Capture Multi Market" I downloaded from this forum for capturing data and always wondered how I'd create new sheets as currently there are only 12 sheets on this one. For some reason this forum wont allow me attach the spreadsheet but after seeing this post I went and created upto 60 sheets and tested it last night on the australian racing, but it didnt record any data on any of my new sheets from 13 to 60

All I did was copy existing sheets and named them the same as the original in sequence all the way upto 60 sheets, so each sheet is data, data (1), data (2) etc etc upto data (60)

Is there some VBA script I have to apply to make these work?
Atho55
Posts: 637
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

Firstly

Are your sheets numbered like this
BA Tabs.jpg
You do not have the required permissions to view the files attached to this post.
captainbang
Posts: 82
Joined: Tue May 01, 2018 1:33 pm

Yes

Atho55 wrote:
Mon Sep 14, 2020 1:20 pm
Firstly

Are your sheets numbered like this

BA Tabs.jpg
You do not have the required permissions to view the files attached to this post.
Anbell
Posts: 2004
Joined: Fri Apr 05, 2019 2:31 am

captainbang wrote:
Mon Sep 14, 2020 7:05 pm
Yes

Atho55 wrote:
Mon Sep 14, 2020 1:20 pm
Firstly

Are your sheets numbered like this

BA Tabs.jpg
It needs to be Bet Angel (xx) not data(xx)
captainbang
Posts: 82
Joined: Tue May 01, 2018 1:33 pm

But all the data of the race gets stored in the data & data (1) tabs, I dont even use the bet angel tabs they are just like the betfair interface for doing manual bets i think.
Currently the whole days racing is being captured on the data & data (1) tabs and its a nightmare to split them all up (well with my excel skills anyway) and what I wanted to do after reading this post was to create upto 60 tabs so I could guarentee that only 1 race would be on a tab each day which would make my life much easier.

So what I did was create upto 60 bet angel tabs using the same naming convention and the same with the data tabs.

So I have 60 bet angel tabs and 60 data tabs, but when i tested it data was only captured upto the 12th tab which is the last of the original tabs and nothing got captured on any of the newly created ones.
Anbell wrote:
Mon Sep 14, 2020 11:54 pm
captainbang wrote:
Mon Sep 14, 2020 7:05 pm
Yes

Atho55 wrote:
Mon Sep 14, 2020 1:20 pm
Firstly

Are your sheets numbered like this

BA Tabs.jpg
It needs to be Bet Angel (xx) not data(xx)
Atho55
Posts: 637
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

Captain, Bet Angel NEEDS the Excel sheets to be be Bet Angel, Bet Angel (2), Bet Angel (3), Bet Angel (4) etc etc to Bet Angel (100) or whatever you want the last sheet to be numbered.

Not Data.....

Do you understand that now
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”