Ventana software support forum

I would like to reitare a excel table for my simulation: I import xls data on 24 hours, my step time is of 1 hour but i would like to reiterate it on 8760 hours without chancing my folder.

Thank you for your help

You will need to use GET XLS TABLES and then give the table the input modulo the repeat time as in

cyclic results = table on hour(MODULO(Time/Unit Hour,8760))

I'm sorry but i try to use this syntax and I can't get a result. I don't no really how you define the variable " table on hour" and in my Vensim Version there is not the function "GET XLS TABLES". So can you give more details to solve my problem.

Thanks for the second time

This is just a Lookup - for example

table on hour((0,1),(6,3),(12,4),(18,2))


for 24 hours - obviously lots more values for a full year, though you probably won't be able to enter 8760 because of size limitations.

Hi Bob - I think you mean GET XLS LOOKUPS ? - Tom

Yes, that should have read

You will need to use GET XLS LOOKUPS and then give the table the input modulo the repeat time as in

cyclic results = table on hour(MODULO(Time/Unit Hour,8760))