I coded the clustering algorithem into a excel public function.
Then VBA solver is used to adjust two parameters to reach the target.
Because most time is used in inputing a same large data file, I am wondering is there any way in VBA to read in data once into memory and use by rest of the...