Batch processing 1000s of runs

%3CLINGO-SUB%20id%3D%22lingo-sub-1285274%22%20slang%3D%22en-US%22%3EBatch%20processing%201000s%20of%20runs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1285274%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi!%20I%20have%20an%20Excel%20spreadsheet%20with%20lots%20of%20mathematical%20calculations.%20I%20want%20to%20repeat%20the%20same%20set%20of%20calculations%201000s%20of%20combinations%20by%20varying%20certain%20input%20parameters%20and%20getting%20a%20set%20of%20output%20results.%20I%20am%20creating%20one%20row%20of%20input%2Foutput%20results%20for%20each%20set.%20In%20the%20end%20I%20will%20get%201000s%20of%20rows%20of%20analysis%20results.%20I%20will%20then%20plot%20some%20of%20them%20as%20x-y%20graphs%20for%20various%20I%2FO%20combinations.%20I%20have%20labeled%20each%20run%20with%20a%20case%20number.%20Currently%20I%20am%20manually%20running%20each%20case%20%26amp%3B%20copying%20the%20results%20in%20one%20row.%26nbsp%3B%20That%20is%20slow%20%26amp%3B%20tedious.%20How%20do%20I%20automate%20the%20process%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1285274%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

Hi! I have an Excel spreadsheet with lots of mathematical calculations. I want to repeat the same set of calculations 1000s of combinations by varying certain input parameters and getting a set of output results. I am creating one row of input/output results for each set. In the end I will get 1000s of rows of analysis results. I will then plot some of them as x-y graphs for various I/O combinations. I have labeled each run with a case number. Currently I am manually running each case & copying the results in one row.  That is slow & tedious. How do I automate the process?

0 Replies