I-XL's data capture spreadsheet multi market
- firlandsfarm
- Posts: 2720
- Joined: Sat May 03, 2014 8:20 am
Hey Memphis I can assure you snow doesn't sit on me for long. It should have been clear to anyone that my message was thanking Nigel for something he had already done and not looking to scrounge a feebe! Maybe I over reacted but I don't take kindly to someone questioning my honour. Let that be the end of it … love to all
-
- Posts: 5
- Joined: Wed Apr 15, 2009 4:53 pm
Hi Nigel,
I'd just like to thank you for this spreadsheet and the work you've put into it.
Many thanks
Steve
I'd just like to thank you for this spreadsheet and the work you've put into it.
Many thanks
Steve
-
- Posts: 5
- Joined: Wed Apr 15, 2009 4:53 pm
Hi Nigel,
I'd like capture some data with milliseconds incorporated into the timestamp format ("hh:mm:ss.000"). I'm thinking if I could change the countdown time format this would be possible. I've tried to find the format within the vba project, but I'm thinking this is the part of the project I can't access. Is there a way I can change this format without having to access the protected area? I'm trying to learn VBA but it's very minimal at this stage.
Also, I've created a sheet based on your spreadsheet with 50 Markets in it. I've made all the sheet code and formulae updates as outlined by yourself on the first page this post. In addition, I've added a new worksheet named 'CONSTANTS' - this can be found after worksheet 'Bet Angel (50)' and before worksheet 'Data'. I've added a 'INTERVAL.SECONDS' constant to this page. I've updated all the data sheets so that the user can change the 'Interval (seconds)' value in the 'CONSTANTS' worksheet and it will update the G1 cell across all the 50 data capture sheets.
If it's ok with you I can post this up for anybody who may find it useful.
Many Thanks
Steve
I'd like capture some data with milliseconds incorporated into the timestamp format ("hh:mm:ss.000"). I'm thinking if I could change the countdown time format this would be possible. I've tried to find the format within the vba project, but I'm thinking this is the part of the project I can't access. Is there a way I can change this format without having to access the protected area? I'm trying to learn VBA but it's very minimal at this stage.
Also, I've created a sheet based on your spreadsheet with 50 Markets in it. I've made all the sheet code and formulae updates as outlined by yourself on the first page this post. In addition, I've added a new worksheet named 'CONSTANTS' - this can be found after worksheet 'Bet Angel (50)' and before worksheet 'Data'. I've added a 'INTERVAL.SECONDS' constant to this page. I've updated all the data sheets so that the user can change the 'Interval (seconds)' value in the 'CONSTANTS' worksheet and it will update the G1 cell across all the 50 data capture sheets.
If it's ok with you I can post this up for anybody who may find it useful.
Many Thanks
Steve