Convert Daily Production Data To Monthly or Yearly Data

xiaobaiw · 发表于 2012-6-6 11:27:33

马上注册，下载丰富资料，享用更多功能，让你轻松玩转阳光石油论坛。

您需要登录才可以下载或查看，没有账号？欢迎注册

x

If you have big daily production data, sometime it can take your time to convert them to monthly or yearly production using Excel Average function. Depending how fluent use your Excel spreadsheet.

There is an easier way to do this is using the capability of Ms. Excel to do array calculations. This calculation is marked by curly brackets “{}”. You can find an example converting daily data to monthly or yearly in this tool. Please note that you can use this idea to any daily data to convert them to monthly or yearly.

Hint: When editing an array formula press Shift & Ctrl buttons (don’t release them yet) then hit Enter to apply.

		自动登录	找回密码
密码			欢迎注册

[VBA] Convert Daily Production Data To Monthly or Yearly Data

马上注册，下载丰富资料，享用更多功能，让你轻松玩转阳光石油论坛。