Sunday, November 6, 2011

Petroleum Goodies: Convert Hourly Production Data To Daily Data

Petroleum Goodies: Convert Hourly Production Data To Daily Data

Convert Hourly Production Data To Daily Data

Posted: 05 Nov 2011 02:49 PM PDT

Tool To Convert Hourly Production Data To Daily Data

If you have big daily production data, sometime it can take your time to convert them to daily production using Excel Average function.

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 hourly data to daily in this tool. If you want to convert your daily data to monthly or yearly you can use Convert Daily to Monthly tool which has been posted earlier.

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

Use VBA macro? No

Note: There is a file embedded within this post, please visit this post to download the file.Similar Posts:

Posted by R. Pratama at 12:05 PM

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)