Just wondering ?
I am exporting some stored values for football (Home, Away under 2.5).
I want to use those values in another spreadsheet to calculate something > which in turn will be read back into Betangel.
But... Betangel will only export values to a closed workbook, and my other excel workbook won't read values form a closed workbook.
How do you get around it? Otherwise, aside form collected stats, I cannot see how the export to csv option will be of much use??
How do you guys do it? Using exported SVs
You can push SVs back to the BA workbook by enabling their export under Settings -> Edit Settings -> Excel -> Shared Stored Values
You then just have your other workbook open and reference the cell in the BA worksheet the stored value is in
You then just have your other workbook open and reference the cell in the BA worksheet the stored value is in
-
- Posts: 16
- Joined: Sat Dec 26, 2020 7:47 pm
Hey - thanks, found the setting - but what does that do exactly?? Will it allow the stored values to be exported to the csv file whist the file is open?
It exports them to the BA template spreadsheet which you can link via guardian
https://www.betangel.com/user-guide/mic ... ation.html
https://www.betangel.com/user-guide/mic ... ation.html