Excel to Guardian SV's

[goldfinch77]

I have looked in here but cannot find the specific answer
Lets say i am working on the BA template Sheet2, I have value in Sheet 2 B20
Is there anyway I can get that value back into Guardian as a stored value ?

Thanks.

[ODPaul82]

SET_SV FOR:SELECTION NAME:Test1 VALUE:42 NAME:Test2 Value:99 NAME:Test3 Value:200
https://www.betangel.com/user-guide/syn ... mands.html

[goldfinch77]

Yes, I have seen all that, however I am working in Sheet2 of the BA template to do some number crunchig, the result ( a single value) I would like to get back into Guardian as Stored value so I can use it in my wonder strategy.

[ODPaul82]

Yes, I have seen all that, however I am working in Sheet2 of the BA template to do some number crunchig, the result ( a single value) I would like to get back into Guardian as Stored value so I can use it in my wonder strategy.

Then reference Sheet2 in the formula on the BA sheet
="SET_SV FOR:WHATEVER NAME:MySV VALUE:" & Sheet2!$B$20