This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
In a function, can parameters be instructed from an external tool such as csv? It would be nice to be able to create scripts.
When analyzing with the requirement that conditions change on a daily basis, By inputting and capturing requirements determined in the common format, I want to prevent mistakes. Example) · Variable schedule range Today is 60 days, next day 40 days, etc. · Variable scrubbing time for every 6 hours every 4 hours, etc. · Enable arithmetic operations freely ↓ For example, in the csv file input, Day 60 Time 4 Calculation /
Such,The average time for calculation every 4 hours in 60 days is output.
There are definitely ways you can accomplish this. If you are trying to use today's date as the controlling parameter then I would suggest using a custom filter after the CSV input to isolate the formulas for today and then you can use use the "Dynamic Formula' tool from the CREW macros to change your formulas. If you are looking to process all of the days, each with their own set of formulas, I would suggest building out a batch macro.
Let me know which case you are interested in if you would like a more detailed explanation.