I am looking for a way to automatically propagate my lookup table.
I would like to enter data in blank cell. Find that data in a column of data and then copy that cell and all data below that into a new column.
The attached spreadsheet is an example of a sheet I use daily in my work.
I use it to convert time codes (HH:MM:SS:FR) from editorial reel length to continuous long play time codes.
Columns A through E is the lookup table and F-N is the conversion section.
Column B represents the time code sequence of 35mm film. The first frame of picture is always at 8 seconds (01:00:08:00) this is cell B3. The film has 24 frames in 1 second as demonstrated in cells B26 and B27.
An editorial reel of film is usually never more than 20 minutes, but it is variable.
Once all the editorial reels are finished and locked in length. They are assembled together to make the continuous long play video.
My task at work is to convert the editorial notes from the editorial work and find their continuous long play equivalent.
I do this by finding the time code of first frame of picture in each of editorial reels in Column B, In this example Reel 2 first frame of picture is 1:17:08:21 (or cell B24504) Selecting to the end of the column, Copying and pasting to column D at cell D3.
I then do the same for Reel 3. FFOP is 1:34:39:16 (cell B49723) pasted to column E at cell E3.
I’m wondering if there is an easier way to make Columns C,D,E instead of copy and paste?
It would be great if I could just enter the First Frame of Picture information and have the column propagate using the sequence in Column B.
Is there a guru out there that can help me with this?
Thanks for listening to my problem and I look forward to any help I could get in this matter.
Ethan Chase.
I tried to figure out how to paste examples. I hope this works.
Example of Lookup table.
A B C D E
[TABLE="width: 325"]
<!--StartFragment--> <colgroup><col width="65" span="5" style="width:65pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 65"]Frame[/TD]
[TD="class: xl64, width: 65"]Theatrical[/TD]
[TD="class: xl65, width: 65"]r1[/TD]
[TD="class: xl65, width: 65"]r2[/TD]
[TD="class: xl65, width: 65"]r3[/TD]
[/TR]
[TR]
[TD="class: xl66"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"]FFOP R1[/TD]
[TD="class: xl68"]FFOP R2[/TD]
[TD="class: xl68"]FFOP R3[/TD]
[/TR]
[TR]
[TD="class: xl69, align: right"]1[/TD]
[TD="class: xl70, align: right"]1000800[/TD]
[TD="class: xl71, align: right"]1000000[/TD]
[TD="class: xl72, align: right"]1170821[/TD]
[TD="class: xl73, align: right"]1343916[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]2[/TD]
[TD="class: xl73, align: right"]1000801[/TD]
[TD="class: xl75, align: right"]1000001[/TD]
[TD="class: xl72, align: right"]1170822[/TD]
[TD="class: xl73, align: right"]1343917[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]3[/TD]
[TD="class: xl73, align: right"]1000802[/TD]
[TD="class: xl75, align: right"]1000002[/TD]
[TD="class: xl72, align: right"]1170823[/TD]
[TD="class: xl73, align: right"]1343918[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]4[/TD]
[TD="class: xl73, align: right"]1000803[/TD]
[TD="class: xl75, align: right"]1000003[/TD]
[TD="class: xl72, align: right"]1170900[/TD]
[TD="class: xl73, align: right"]1343919[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]5[/TD]
[TD="class: xl73, align: right"]1000804[/TD]
[TD="class: xl75, align: right"]1000004[/TD]
[TD="class: xl72, align: right"]1170901[/TD]
[TD="class: xl73, align: right"]1343920[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]6[/TD]
[TD="class: xl73, align: right"]1000805[/TD]
[TD="class: xl75, align: right"]1000005[/TD]
[TD="class: xl72, align: right"]1170902[/TD]
[TD="class: xl73, align: right"]1343921[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]7[/TD]
[TD="class: xl73, align: right"]1000806[/TD]
[TD="class: xl75, align: right"]1000006[/TD]
[TD="class: xl72, align: right"]1170903[/TD]
[TD="class: xl73, align: right"]1343922[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]8[/TD]
[TD="class: xl73, align: right"]1000807[/TD]
[TD="class: xl75, align: right"]1000007[/TD]
[TD="class: xl72, align: right"]1170904[/TD]
[TD="class: xl73, align: right"]1343923[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]9[/TD]
[TD="class: xl73, align: right"]1000808[/TD]
[TD="class: xl75, align: right"]1000008[/TD]
[TD="class: xl72, align: right"]1170905[/TD]
[TD="class: xl73, align: right"]1344000[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]10[/TD]
[TD="class: xl73, align: right"]1000809[/TD]
[TD="class: xl75, align: right"]1000009[/TD]
[TD="class: xl72, align: right"]1170906[/TD]
[TD="class: xl73, align: right"]1344001[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]11[/TD]
[TD="class: xl73, align: right"]1000810[/TD]
[TD="class: xl75, align: right"]1000010[/TD]
[TD="class: xl72, align: right"]1170907[/TD]
[TD="class: xl73, align: right"]1344002[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]12[/TD]
[TD="class: xl73, align: right"]1000811[/TD]
[TD="class: xl75, align: right"]1000011[/TD]
[TD="class: xl72, align: right"]1170908[/TD]
[TD="class: xl73, align: right"]1344003[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]13[/TD]
[TD="class: xl73, align: right"]1000812[/TD]
[TD="class: xl75, align: right"]1000012[/TD]
[TD="class: xl72, align: right"]1170909[/TD]
[TD="class: xl73, align: right"]1344004[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]14[/TD]
[TD="class: xl73, align: right"]1000813[/TD]
[TD="class: xl75, align: right"]1000013[/TD]
[TD="class: xl72, align: right"]1170910[/TD]
[TD="class: xl73, align: right"]1344005[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]15[/TD]
[TD="class: xl73, align: right"]1000814[/TD]
[TD="class: xl75, align: right"]1000014[/TD]
[TD="class: xl72, align: right"]1170911[/TD]
[TD="class: xl73, align: right"]1344006[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]16[/TD]
[TD="class: xl73, align: right"]1000815[/TD]
[TD="class: xl75, align: right"]1000015[/TD]
[TD="class: xl72, align: right"]1170912[/TD]
[TD="class: xl73, align: right"]1344007[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]17[/TD]
[TD="class: xl73, align: right"]1000816[/TD]
[TD="class: xl75, align: right"]1000016[/TD]
[TD="class: xl72, align: right"]1170913[/TD]
[TD="class: xl73, align: right"]1344008[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]18[/TD]
[TD="class: xl73, align: right"]1000817[/TD]
[TD="class: xl75, align: right"]1000017[/TD]
[TD="class: xl72, align: right"]1170914[/TD]
[TD="class: xl73, align: right"]1344009[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]19[/TD]
[TD="class: xl73, align: right"]1000818[/TD]
[TD="class: xl75, align: right"]1000018[/TD]
[TD="class: xl72, align: right"]1170915[/TD]
[TD="class: xl73, align: right"]1344010[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]20[/TD]
[TD="class: xl73, align: right"]1000819[/TD]
[TD="class: xl75, align: right"]1000019[/TD]
[TD="class: xl72, align: right"]1170916[/TD]
[TD="class: xl73, align: right"]1344011[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]21[/TD]
[TD="class: xl73, align: right"]1000820[/TD]
[TD="class: xl75, align: right"]1000020[/TD]
[TD="class: xl72, align: right"]1170917[/TD]
[TD="class: xl73, align: right"]1344012[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]22[/TD]
[TD="class: xl73, align: right"]1000821[/TD]
[TD="class: xl75, align: right"]1000021[/TD]
[TD="class: xl72, align: right"]1170918[/TD]
[TD="class: xl73, align: right"]1344013[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]23[/TD]
[TD="class: xl73, align: right"]1000822[/TD]
[TD="class: xl75, align: right"]1000022[/TD]
[TD="class: xl72, align: right"]1170919[/TD]
[TD="class: xl73, align: right"]1344014[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]24[/TD]
[TD="class: xl73, align: right"]1000823[/TD]
[TD="class: xl75, align: right"]1000023[/TD]
[TD="class: xl72, align: right"]1170920[/TD]
[TD="class: xl73, align: right"]1344015[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]25[/TD]
[TD="class: xl73, align: right"]1000900[/TD]
[TD="class: xl75, align: right"]1000100[/TD]
[TD="class: xl72, align: right"]1170921[/TD]
[TD="class: xl73, align: right"]1344016[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]26[/TD]
[TD="class: xl73, align: right"]1000901[/TD]
[TD="class: xl75, align: right"]1000101[/TD]
[TD="class: xl72, align: right"]1170922[/TD]
[TD="class: xl73, align: right"]1344017[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]27[/TD]
[TD="class: xl73, align: right"]1000902[/TD]
[TD="class: xl75, align: right"]1000102[/TD]
[TD="class: xl72, align: right"]1170923[/TD]
[TD="class: xl73, align: right"]1344018[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]28[/TD]
[TD="class: xl73, align: right"]1000903[/TD]
[TD="class: xl75, align: right"]1000103[/TD]
[TD="class: xl72, align: right"]1171000[/TD]
[TD="class: xl73, align: right"]1344019[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]29[/TD]
[TD="class: xl73, align: right"]1000904[/TD]
[TD="class: xl75, align: right"]1000104[/TD]
[TD="class: xl72, align: right"]1171001[/TD]
[TD="class: xl73, align: right"]1344020[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]30[/TD]
[TD="class: xl73, align: right"]1000905[/TD]
[TD="class: xl75, align: right"]1000105[/TD]
[TD="class: xl72, align: right"]1171002[/TD]
[TD="class: xl73, align: right"]1344021[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]31[/TD]
[TD="class: xl73, align: right"]1000906[/TD]
[TD="class: xl75, align: right"]1000106[/TD]
[TD="class: xl72, align: right"]1171003[/TD]
[TD="class: xl73, align: right"]1344022[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]32[/TD]
[TD="class: xl73, align: right"]1000907[/TD]
[TD="class: xl75, align: right"]1000107[/TD]
[TD="class: xl72, align: right"]1171004[/TD]
[TD="class: xl73, align: right"]1344023[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]33[/TD]
[TD="class: xl73, align: right"]1000908[/TD]
[TD="class: xl75, align: right"]1000108[/TD]
[TD="class: xl72, align: right"]1171005[/TD]
[TD="class: xl73, align: right"]1344100[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]34[/TD]
[TD="class: xl73, align: right"]1000909[/TD]
[TD="class: xl75, align: right"]1000109[/TD]
[TD="class: xl72, align: right"]1171006[/TD]
[TD="class: xl73, align: right"]1344101[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]35[/TD]
[TD="class: xl73, align: right"]1000910[/TD]
[TD="class: xl75, align: right"]1000110[/TD]
[TD="class: xl72, align: right"]1171007[/TD]
[TD="class: xl73, align: right"]1344102[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]36[/TD]
[TD="class: xl73, align: right"]1000911[/TD]
[TD="class: xl75, align: right"]1000111[/TD]
[TD="class: xl72, align: right"]1171008[/TD]
[TD="class: xl73, align: right"]1344103[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]37[/TD]
[TD="class: xl73, align: right"]1000912[/TD]
[TD="class: xl75, align: right"]1000112[/TD]
[TD="class: xl72, align: right"]1171009[/TD]
[TD="class: xl73, align: right"]1344104[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]38[/TD]
[TD="class: xl73, align: right"]1000913[/TD]
[TD="class: xl75, align: right"]1000113[/TD]
[TD="class: xl72, align: right"]1171010[/TD]
[TD="class: xl73, align: right"]1344105[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]39[/TD]
[TD="class: xl73, align: right"]1000914[/TD]
[TD="class: xl75, align: right"]1000114[/TD]
[TD="class: xl72, align: right"]1171011[/TD]
[TD="class: xl73, align: right"]1344106[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]40[/TD]
[TD="class: xl73, align: right"]1000915[/TD]
[TD="class: xl75, align: right"]1000115[/TD]
[TD="class: xl72, align: right"]1171012[/TD]
[TD="class: xl73, align: right"]1344107[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]41[/TD]
[TD="class: xl73, align: right"]1000916[/TD]
[TD="class: xl75, align: right"]1000116[/TD]
[TD="class: xl72, align: right"]1171013[/TD]
[TD="class: xl73, align: right"]1344108[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]42[/TD]
[TD="class: xl73, align: right"]1000917[/TD]
[TD="class: xl75, align: right"]1000117[/TD]
[TD="class: xl72, align: right"]1171014[/TD]
[TD="class: xl73, align: right"]1344109[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]43[/TD]
[TD="class: xl73, align: right"]1000918[/TD]
[TD="class: xl75, align: right"]1000118[/TD]
[TD="class: xl72, align: right"]1171015[/TD]
[TD="class: xl73, align: right"]1344110[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]44[/TD]
[TD="class: xl73, align: right"]1000919[/TD]
[TD="class: xl75, align: right"]1000119[/TD]
[TD="class: xl72, align: right"]1171016[/TD]
[TD="class: xl73, align: right"]1344111[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]45[/TD]
[TD="class: xl73, align: right"]1000920[/TD]
[TD="class: xl72, align: right"]1000120[/TD]
[TD="class: xl72, align: right"]1171017[/TD]
[TD="class: xl73, align: right"]1344112[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]46[/TD]
[TD="class: xl73, align: right"]1000921[/TD]
[TD="class: xl72, align: right"]1000121[/TD]
[TD="class: xl72, align: right"]1171018[/TD]
[TD="class: xl73, align: right"]1344113[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]47[/TD]
[TD="class: xl73, align: right"]1000922[/TD]
[TD="class: xl72, align: right"]1000122[/TD]
[TD="class: xl72, align: right"]1171019[/TD]
[TD="class: xl73, align: right"]1344114[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]48[/TD]
[TD="class: xl73, align: right"]1000923[/TD]
[TD="class: xl72, align: right"]1000123[/TD]
[TD="class: xl72, align: right"]1171020[/TD]
[TD="class: xl73, align: right"]1344115[/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]
[TABLE="width: 327"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]24501[/TD]
[TD="align: right"]1170820[/TD]
[TD="align: right"]1170020[/TD]
[TD="align: right"]1340917[/TD]
[TD="align: right"]1514012[/TD]
[/TR]
[TR]
[TD="align: right"]24502[/TD]
[TD="align: right"]1170821[/TD]
[TD="align: right"]1170021[/TD]
[TD="align: right"]1340918[/TD]
[TD="align: right"]1514013[/TD]
[/TR]
[TR]
[TD="align: right"]24503[/TD]
[TD="align: right"]1170822[/TD]
[TD="align: right"]1170022[/TD]
[TD="align: right"]1340919[/TD]
[TD="align: right"]1514014[/TD]
[/TR]
[TR]
[TD="align: right"]24504[/TD]
[TD="align: right"]1170823[/TD]
[TD="align: right"]1170023[/TD]
[TD="align: right"]1340920[/TD]
[TD="align: right"]1514015[/TD]
[/TR]
[TR]
[TD="align: right"]24505[/TD]
[TD="align: right"]1170900[/TD]
[TD="align: right"]1170100[/TD]
[TD="align: right"]1340921[/TD]
[TD="align: right"]1514016[/TD]
[/TR]
[TR]
[TD="align: right"]24506[/TD]
[TD="align: right"]1170901[/TD]
[TD="align: right"]1170101[/TD]
[TD="align: right"]1340922[/TD]
[TD="align: right"]1514017[/TD]
[/TR]
</tbody>[/TABLE]
EXAMPLE OF THE CONVERSION SECTION FOR REEL 2 ONLY:
I J K
[TABLE="width: 524"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]R2[/TD]
[TD]R2[/TD]
[TD]R2[/TD]
[/TR]
[TR]
[TD]THEAT. LOC.[/TD]
[TD]REEL OFFSET[/TD]
[TD]LP EQUIV.[/TD]
[/TR]
[TR]
[TD]2000000[/TD]
[TD]=I3-1000000[/TD]
[TD]=VLOOKUP(J3,B:E,3,TRUE) [/TD]
[/TR]
[TR]
[TD]2000600[/TD]
[TD]=I4-1000000[/TD]
[TD]=VLOOKUP(J4,B:E,3,TRUE)[/TD]
[/TR]
[TR]
[TD]2000800[/TD]
[TD]=I5-1000000[/TD]
[TD]=VLOOKUP(J5,B:E,3,TRUE)[/TD]
[/TR]
[TR]
[TD]2173819[/TD]
[TD]=I6-1000000[/TD]
[TD]=VLOOKUP(J6,B:E,3,TRUE)[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]=I7-1000000[/TD]
[TD]=VLOOKUP(J7,B:E,3,TRUE)[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]=I8-1000000[/TD]
[TD]=VLOOKUP(J8,B:E,3,TRUE)[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]=I9-1000000[/TD]
[TD]=VLOOKUP(J9,B:E,3,TRUE)[/TD]
[/TR]
</tbody>[/TABLE]
I would like to enter data in blank cell. Find that data in a column of data and then copy that cell and all data below that into a new column.
The attached spreadsheet is an example of a sheet I use daily in my work.
I use it to convert time codes (HH:MM:SS:FR) from editorial reel length to continuous long play time codes.
Columns A through E is the lookup table and F-N is the conversion section.
Column B represents the time code sequence of 35mm film. The first frame of picture is always at 8 seconds (01:00:08:00) this is cell B3. The film has 24 frames in 1 second as demonstrated in cells B26 and B27.
An editorial reel of film is usually never more than 20 minutes, but it is variable.
Once all the editorial reels are finished and locked in length. They are assembled together to make the continuous long play video.
My task at work is to convert the editorial notes from the editorial work and find their continuous long play equivalent.
I do this by finding the time code of first frame of picture in each of editorial reels in Column B, In this example Reel 2 first frame of picture is 1:17:08:21 (or cell B24504) Selecting to the end of the column, Copying and pasting to column D at cell D3.
I then do the same for Reel 3. FFOP is 1:34:39:16 (cell B49723) pasted to column E at cell E3.
I’m wondering if there is an easier way to make Columns C,D,E instead of copy and paste?
It would be great if I could just enter the First Frame of Picture information and have the column propagate using the sequence in Column B.
Is there a guru out there that can help me with this?
Thanks for listening to my problem and I look forward to any help I could get in this matter.
Ethan Chase.
I tried to figure out how to paste examples. I hope this works.
Example of Lookup table.
A B C D E
[TABLE="width: 325"]
<!--StartFragment--> <colgroup><col width="65" span="5" style="width:65pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 65"]Frame[/TD]
[TD="class: xl64, width: 65"]Theatrical[/TD]
[TD="class: xl65, width: 65"]r1[/TD]
[TD="class: xl65, width: 65"]r2[/TD]
[TD="class: xl65, width: 65"]r3[/TD]
[/TR]
[TR]
[TD="class: xl66"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"]FFOP R1[/TD]
[TD="class: xl68"]FFOP R2[/TD]
[TD="class: xl68"]FFOP R3[/TD]
[/TR]
[TR]
[TD="class: xl69, align: right"]1[/TD]
[TD="class: xl70, align: right"]1000800[/TD]
[TD="class: xl71, align: right"]1000000[/TD]
[TD="class: xl72, align: right"]1170821[/TD]
[TD="class: xl73, align: right"]1343916[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]2[/TD]
[TD="class: xl73, align: right"]1000801[/TD]
[TD="class: xl75, align: right"]1000001[/TD]
[TD="class: xl72, align: right"]1170822[/TD]
[TD="class: xl73, align: right"]1343917[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]3[/TD]
[TD="class: xl73, align: right"]1000802[/TD]
[TD="class: xl75, align: right"]1000002[/TD]
[TD="class: xl72, align: right"]1170823[/TD]
[TD="class: xl73, align: right"]1343918[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]4[/TD]
[TD="class: xl73, align: right"]1000803[/TD]
[TD="class: xl75, align: right"]1000003[/TD]
[TD="class: xl72, align: right"]1170900[/TD]
[TD="class: xl73, align: right"]1343919[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]5[/TD]
[TD="class: xl73, align: right"]1000804[/TD]
[TD="class: xl75, align: right"]1000004[/TD]
[TD="class: xl72, align: right"]1170901[/TD]
[TD="class: xl73, align: right"]1343920[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]6[/TD]
[TD="class: xl73, align: right"]1000805[/TD]
[TD="class: xl75, align: right"]1000005[/TD]
[TD="class: xl72, align: right"]1170902[/TD]
[TD="class: xl73, align: right"]1343921[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]7[/TD]
[TD="class: xl73, align: right"]1000806[/TD]
[TD="class: xl75, align: right"]1000006[/TD]
[TD="class: xl72, align: right"]1170903[/TD]
[TD="class: xl73, align: right"]1343922[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]8[/TD]
[TD="class: xl73, align: right"]1000807[/TD]
[TD="class: xl75, align: right"]1000007[/TD]
[TD="class: xl72, align: right"]1170904[/TD]
[TD="class: xl73, align: right"]1343923[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]9[/TD]
[TD="class: xl73, align: right"]1000808[/TD]
[TD="class: xl75, align: right"]1000008[/TD]
[TD="class: xl72, align: right"]1170905[/TD]
[TD="class: xl73, align: right"]1344000[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]10[/TD]
[TD="class: xl73, align: right"]1000809[/TD]
[TD="class: xl75, align: right"]1000009[/TD]
[TD="class: xl72, align: right"]1170906[/TD]
[TD="class: xl73, align: right"]1344001[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]11[/TD]
[TD="class: xl73, align: right"]1000810[/TD]
[TD="class: xl75, align: right"]1000010[/TD]
[TD="class: xl72, align: right"]1170907[/TD]
[TD="class: xl73, align: right"]1344002[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]12[/TD]
[TD="class: xl73, align: right"]1000811[/TD]
[TD="class: xl75, align: right"]1000011[/TD]
[TD="class: xl72, align: right"]1170908[/TD]
[TD="class: xl73, align: right"]1344003[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]13[/TD]
[TD="class: xl73, align: right"]1000812[/TD]
[TD="class: xl75, align: right"]1000012[/TD]
[TD="class: xl72, align: right"]1170909[/TD]
[TD="class: xl73, align: right"]1344004[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]14[/TD]
[TD="class: xl73, align: right"]1000813[/TD]
[TD="class: xl75, align: right"]1000013[/TD]
[TD="class: xl72, align: right"]1170910[/TD]
[TD="class: xl73, align: right"]1344005[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]15[/TD]
[TD="class: xl73, align: right"]1000814[/TD]
[TD="class: xl75, align: right"]1000014[/TD]
[TD="class: xl72, align: right"]1170911[/TD]
[TD="class: xl73, align: right"]1344006[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]16[/TD]
[TD="class: xl73, align: right"]1000815[/TD]
[TD="class: xl75, align: right"]1000015[/TD]
[TD="class: xl72, align: right"]1170912[/TD]
[TD="class: xl73, align: right"]1344007[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]17[/TD]
[TD="class: xl73, align: right"]1000816[/TD]
[TD="class: xl75, align: right"]1000016[/TD]
[TD="class: xl72, align: right"]1170913[/TD]
[TD="class: xl73, align: right"]1344008[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]18[/TD]
[TD="class: xl73, align: right"]1000817[/TD]
[TD="class: xl75, align: right"]1000017[/TD]
[TD="class: xl72, align: right"]1170914[/TD]
[TD="class: xl73, align: right"]1344009[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]19[/TD]
[TD="class: xl73, align: right"]1000818[/TD]
[TD="class: xl75, align: right"]1000018[/TD]
[TD="class: xl72, align: right"]1170915[/TD]
[TD="class: xl73, align: right"]1344010[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]20[/TD]
[TD="class: xl73, align: right"]1000819[/TD]
[TD="class: xl75, align: right"]1000019[/TD]
[TD="class: xl72, align: right"]1170916[/TD]
[TD="class: xl73, align: right"]1344011[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]21[/TD]
[TD="class: xl73, align: right"]1000820[/TD]
[TD="class: xl75, align: right"]1000020[/TD]
[TD="class: xl72, align: right"]1170917[/TD]
[TD="class: xl73, align: right"]1344012[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]22[/TD]
[TD="class: xl73, align: right"]1000821[/TD]
[TD="class: xl75, align: right"]1000021[/TD]
[TD="class: xl72, align: right"]1170918[/TD]
[TD="class: xl73, align: right"]1344013[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]23[/TD]
[TD="class: xl73, align: right"]1000822[/TD]
[TD="class: xl75, align: right"]1000022[/TD]
[TD="class: xl72, align: right"]1170919[/TD]
[TD="class: xl73, align: right"]1344014[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]24[/TD]
[TD="class: xl73, align: right"]1000823[/TD]
[TD="class: xl75, align: right"]1000023[/TD]
[TD="class: xl72, align: right"]1170920[/TD]
[TD="class: xl73, align: right"]1344015[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]25[/TD]
[TD="class: xl73, align: right"]1000900[/TD]
[TD="class: xl75, align: right"]1000100[/TD]
[TD="class: xl72, align: right"]1170921[/TD]
[TD="class: xl73, align: right"]1344016[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]26[/TD]
[TD="class: xl73, align: right"]1000901[/TD]
[TD="class: xl75, align: right"]1000101[/TD]
[TD="class: xl72, align: right"]1170922[/TD]
[TD="class: xl73, align: right"]1344017[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]27[/TD]
[TD="class: xl73, align: right"]1000902[/TD]
[TD="class: xl75, align: right"]1000102[/TD]
[TD="class: xl72, align: right"]1170923[/TD]
[TD="class: xl73, align: right"]1344018[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]28[/TD]
[TD="class: xl73, align: right"]1000903[/TD]
[TD="class: xl75, align: right"]1000103[/TD]
[TD="class: xl72, align: right"]1171000[/TD]
[TD="class: xl73, align: right"]1344019[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]29[/TD]
[TD="class: xl73, align: right"]1000904[/TD]
[TD="class: xl75, align: right"]1000104[/TD]
[TD="class: xl72, align: right"]1171001[/TD]
[TD="class: xl73, align: right"]1344020[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]30[/TD]
[TD="class: xl73, align: right"]1000905[/TD]
[TD="class: xl75, align: right"]1000105[/TD]
[TD="class: xl72, align: right"]1171002[/TD]
[TD="class: xl73, align: right"]1344021[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]31[/TD]
[TD="class: xl73, align: right"]1000906[/TD]
[TD="class: xl75, align: right"]1000106[/TD]
[TD="class: xl72, align: right"]1171003[/TD]
[TD="class: xl73, align: right"]1344022[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]32[/TD]
[TD="class: xl73, align: right"]1000907[/TD]
[TD="class: xl75, align: right"]1000107[/TD]
[TD="class: xl72, align: right"]1171004[/TD]
[TD="class: xl73, align: right"]1344023[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]33[/TD]
[TD="class: xl73, align: right"]1000908[/TD]
[TD="class: xl75, align: right"]1000108[/TD]
[TD="class: xl72, align: right"]1171005[/TD]
[TD="class: xl73, align: right"]1344100[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]34[/TD]
[TD="class: xl73, align: right"]1000909[/TD]
[TD="class: xl75, align: right"]1000109[/TD]
[TD="class: xl72, align: right"]1171006[/TD]
[TD="class: xl73, align: right"]1344101[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]35[/TD]
[TD="class: xl73, align: right"]1000910[/TD]
[TD="class: xl75, align: right"]1000110[/TD]
[TD="class: xl72, align: right"]1171007[/TD]
[TD="class: xl73, align: right"]1344102[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]36[/TD]
[TD="class: xl73, align: right"]1000911[/TD]
[TD="class: xl75, align: right"]1000111[/TD]
[TD="class: xl72, align: right"]1171008[/TD]
[TD="class: xl73, align: right"]1344103[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]37[/TD]
[TD="class: xl73, align: right"]1000912[/TD]
[TD="class: xl75, align: right"]1000112[/TD]
[TD="class: xl72, align: right"]1171009[/TD]
[TD="class: xl73, align: right"]1344104[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]38[/TD]
[TD="class: xl73, align: right"]1000913[/TD]
[TD="class: xl75, align: right"]1000113[/TD]
[TD="class: xl72, align: right"]1171010[/TD]
[TD="class: xl73, align: right"]1344105[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]39[/TD]
[TD="class: xl73, align: right"]1000914[/TD]
[TD="class: xl75, align: right"]1000114[/TD]
[TD="class: xl72, align: right"]1171011[/TD]
[TD="class: xl73, align: right"]1344106[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]40[/TD]
[TD="class: xl73, align: right"]1000915[/TD]
[TD="class: xl75, align: right"]1000115[/TD]
[TD="class: xl72, align: right"]1171012[/TD]
[TD="class: xl73, align: right"]1344107[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]41[/TD]
[TD="class: xl73, align: right"]1000916[/TD]
[TD="class: xl75, align: right"]1000116[/TD]
[TD="class: xl72, align: right"]1171013[/TD]
[TD="class: xl73, align: right"]1344108[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]42[/TD]
[TD="class: xl73, align: right"]1000917[/TD]
[TD="class: xl75, align: right"]1000117[/TD]
[TD="class: xl72, align: right"]1171014[/TD]
[TD="class: xl73, align: right"]1344109[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]43[/TD]
[TD="class: xl73, align: right"]1000918[/TD]
[TD="class: xl75, align: right"]1000118[/TD]
[TD="class: xl72, align: right"]1171015[/TD]
[TD="class: xl73, align: right"]1344110[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]44[/TD]
[TD="class: xl73, align: right"]1000919[/TD]
[TD="class: xl75, align: right"]1000119[/TD]
[TD="class: xl72, align: right"]1171016[/TD]
[TD="class: xl73, align: right"]1344111[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]45[/TD]
[TD="class: xl73, align: right"]1000920[/TD]
[TD="class: xl72, align: right"]1000120[/TD]
[TD="class: xl72, align: right"]1171017[/TD]
[TD="class: xl73, align: right"]1344112[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]46[/TD]
[TD="class: xl73, align: right"]1000921[/TD]
[TD="class: xl72, align: right"]1000121[/TD]
[TD="class: xl72, align: right"]1171018[/TD]
[TD="class: xl73, align: right"]1344113[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]47[/TD]
[TD="class: xl73, align: right"]1000922[/TD]
[TD="class: xl72, align: right"]1000122[/TD]
[TD="class: xl72, align: right"]1171019[/TD]
[TD="class: xl73, align: right"]1344114[/TD]
[/TR]
[TR]
[TD="class: xl74, align: right"]48[/TD]
[TD="class: xl73, align: right"]1000923[/TD]
[TD="class: xl72, align: right"]1000123[/TD]
[TD="class: xl72, align: right"]1171020[/TD]
[TD="class: xl73, align: right"]1344115[/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]
[TABLE="width: 327"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]24501[/TD]
[TD="align: right"]1170820[/TD]
[TD="align: right"]1170020[/TD]
[TD="align: right"]1340917[/TD]
[TD="align: right"]1514012[/TD]
[/TR]
[TR]
[TD="align: right"]24502[/TD]
[TD="align: right"]1170821[/TD]
[TD="align: right"]1170021[/TD]
[TD="align: right"]1340918[/TD]
[TD="align: right"]1514013[/TD]
[/TR]
[TR]
[TD="align: right"]24503[/TD]
[TD="align: right"]1170822[/TD]
[TD="align: right"]1170022[/TD]
[TD="align: right"]1340919[/TD]
[TD="align: right"]1514014[/TD]
[/TR]
[TR]
[TD="align: right"]24504[/TD]
[TD="align: right"]1170823[/TD]
[TD="align: right"]1170023[/TD]
[TD="align: right"]1340920[/TD]
[TD="align: right"]1514015[/TD]
[/TR]
[TR]
[TD="align: right"]24505[/TD]
[TD="align: right"]1170900[/TD]
[TD="align: right"]1170100[/TD]
[TD="align: right"]1340921[/TD]
[TD="align: right"]1514016[/TD]
[/TR]
[TR]
[TD="align: right"]24506[/TD]
[TD="align: right"]1170901[/TD]
[TD="align: right"]1170101[/TD]
[TD="align: right"]1340922[/TD]
[TD="align: right"]1514017[/TD]
[/TR]
</tbody>[/TABLE]
EXAMPLE OF THE CONVERSION SECTION FOR REEL 2 ONLY:
I J K
[TABLE="width: 524"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]R2[/TD]
[TD]R2[/TD]
[TD]R2[/TD]
[/TR]
[TR]
[TD]THEAT. LOC.[/TD]
[TD]REEL OFFSET[/TD]
[TD]LP EQUIV.[/TD]
[/TR]
[TR]
[TD]2000000[/TD]
[TD]=I3-1000000[/TD]
[TD]=VLOOKUP(J3,B:E,3,TRUE) [/TD]
[/TR]
[TR]
[TD]2000600[/TD]
[TD]=I4-1000000[/TD]
[TD]=VLOOKUP(J4,B:E,3,TRUE)[/TD]
[/TR]
[TR]
[TD]2000800[/TD]
[TD]=I5-1000000[/TD]
[TD]=VLOOKUP(J5,B:E,3,TRUE)[/TD]
[/TR]
[TR]
[TD]2173819[/TD]
[TD]=I6-1000000[/TD]
[TD]=VLOOKUP(J6,B:E,3,TRUE)[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]=I7-1000000[/TD]
[TD]=VLOOKUP(J7,B:E,3,TRUE)[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]=I8-1000000[/TD]
[TD]=VLOOKUP(J8,B:E,3,TRUE)[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]=I9-1000000[/TD]
[TD]=VLOOKUP(J9,B:E,3,TRUE)[/TD]
[/TR]
</tbody>[/TABLE]
