This paper analyzes the problems of low efficiency of large-scale instruments and equipment on the interdisciplinary platform, inaccurate recording of equipment operation data, and difficulty in statistical data of scientific research output. In addition, with the help of the university-level sharing platform, the information management of large instruments and equipment of the interdisciplinary platform is carried out, A simple system based on Excel VBA enables the correlation of scientific output with equipment and the establishment of a database of scientific research output and large instruments and equipment is explored. Under the premise of saving money and expenditure, it can effectively promote the open sharing of large-scale instruments and equipment and provide accurate relevant data support.