Application of VBA Macro in Fast and Accurate Fluid Property Identification

Fluid property identification is very important in logging data interpretation. Crossplot technique is a simple and effective method to identify reservoir fluid property, with advantages of simplicity and visuality. In daily work, it is very slow to compare crossplots on the basis of logging curve or interpreted parameters, and lots of mistakes occur and the results can not be visually display. Especially when some parameters are at critical value, it is more difficult to identify the fluid properties. In this paper, some cross plots were mapped on the basis of the geological and logging data, the fine ones with clearer boundaries and better effects are selected to identify fluid property. With program compiled in Excel VBA, the reservoir parameters of target layer can be automatically projected on all of the selected cross plots once. Fluid property can be identified quickly and accurately according to the position of the projections on the cross plots and by comprehensively contrasting with the criteria of the parameters. The simple and useful program compiled in VBA can improve our work efficiency and accuracy by displaying results automatically and intuitively rather than artificial cognition. The program has be used to identify fluid property accurately, quickly and intuitively, and good application results have been obtained.