On Aug 22, 3:29 pm, "Don Guillett" wrote:
How about a sample layout and before/after desires.

I can't figure out how to paste cells. So here is what I have.

this is my initail worksheet

Name Property Gas Price Oil Price NGL Price Revenue MCFE Total LOE LOE/
MCFE Ad Val Compression Overhead R&M SWD Subsurface Utilities Workover
All Other Sev Tax Op Cash Flow Capital Cash Flow
AMERICAN HORSE 1-5 153240 $4.66 $0.00 $0.00 966,972 207,437 35,617
$0.17 0 0 11,939 4,904 972 0 0 0 17,802 56,268 875,086 17,046 858,040

Line Item Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07
Feb-07 Mar-07 Apr-07 May-07 Jun-07 Total
Cash Flow 68,064 52,562 86,331 76,175 43,437 81,001 86,359 53,142
48,517 65,995 55,346 68,337 72,773 858,041
AWTREY 1-16 156900 $5.34 $59.83 $0.00 280,832 49,406 61,312 $1.24
0 9,790 16,188 7,449 1,023 1,628 0 0 25,234 16,422 203,098 0 203,098

Line Item Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07
Feb-07 Mar-07 Apr-07 May-07 Jun-07 Total
Cash Flow 20,446 25,241 24,319 19,214 11,756 28,780 15,306 9,129
15,915 40,188 12,905 -15,129 -4,974 203,098
AWTREY 2-16 159180 $5.37 $65.07 $0.00 2,121,348 380,824 600,568
$1.58 0 1,786 16,188 11,808 2,964 46,057 0 496,930 24,835 124,755
1,396,025

Line Item Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07
Feb-07 Mar-07 Apr-07 May-07 Jun-07 Total
Cash Flow 231,433 208,885 216,316 133,400 79,612
257,359 -256,983 -76,792 137,166 166,584 112,418 77,687 96,070
1,383,154

this is what I would like to be the final.

AMERICAN HORSE 1-5 153240 $68,064 $52,562 $86,331 $76,175
$43,437 $81,001 $86,359 $53,142 $48,517 $65,995