Improvement and Evaluation of VBA-Based Cell Retrieval Algorithms

The frequency of won numbers of in double color ball sports lottery is not regular. It is importance of referring to the pattern of historical numbers while making forecasts. We proposes a simple method of abstracting dot matrix numbers as cell grid in Excel, and realizes the retrieval and labeling of arbitrary graphs of cells and combined cells by Excel Visual basic for Application, and verified the cell custom retrieval algorithm based on minimum rectangle traversal(CrmrT), Finally, using the perspective of algorithm complexity and execution efficiency, evaluate the superiority of the CrmrL algorithm.