tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0074bc84-6d13-4d5b-8df5-6c78f3242a22
Sheet: SCHED-A CONT (2)

OGE Form 278 (Rev. 12/2011)
5 C.F.R. Part 2634
U.S. Office of Government Ethics
Reporting Individual's Name |  |  |  |  | SCHEDULE A continued     (Use only if needed) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page Number
Assets and Income |  |  |  |  |  | Valuation of Assets |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income: type and amount.  If "None (or less than $201)" is checked,
 |  |  |  |  |  | at close of reporting period |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no other entry is needed in Block C for that item.
BLOCK A |  |  |  |  |  | BLOCK B |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BLOCK C
 |  |  |  |  |  | None (or less than $1,001) | $1,001 - $15,000 | $15,001 - $50,000 | $50,001 - $100,000 | $100,001 - $250,000 | $250,001 - $500,000 | $500,001 - $1,000,000 | Over $1,000,000* | $1,000,001 - $5,000,000 | $5,000,001 - $25,000,000 | $25,000,001 - $50,000,000 | Over $50,000,000 | Excepted Investment Fund | Excepted Trust | Qualified Trust | Type |  |  |  | Amount
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dividends | Rent and Royalties | Interest | Capital Gains | None (or less than $201) | $201 - $1,000 | $1,001 - $2,500 | $2,501 - $5,000 | $5,001 - $15,000 | $15,001 - $50,000 | $50,001 - $100,000 | $100,001 - $1,000,000 | Over $1,000,000* | $1,000,001 - $5,000,000 | Over $5,000,000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other | Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income | (Mo., Day,
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Specify | Yr.)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Type &
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual | Only if
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amount) | Honoraria
1
2
3
4
5
6
7
8
9
*   This category applies only if the asset/income is solely that of the filer's spouse or dependent children.  If the asset/income is either that of the filer or jointly held
by the filer with the spouse or dependent children, mark the other higher categories of value, as appropriate.
Spreadsheet: 858071d1706845056-enter-first-date-of-the-year-only-and-will-populate-the-rest-of-the-months-calendar-test
Sheet: Oct

 |  |  | WK No. |  | 40 | 40 | 40 | 40 | 40 | 41 | 41 | 41 | 41 | 41 | 41 | 41 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 44 | 44 | 44 | 44
 |  |  | Day |  | 2024-10-02 00:00:00 | 2024-10-03 00:00:00 | 2024-10-04 00:00:00 | 2024-10-05 00:00:00 | 2024-10-06 00:00:00 | 2024-10-07 00:00:00 | 2024-10-08 00:00:00 | 2024-10-09 00:00:00 | 2024-10-10 00:00:00 | 2024-10-11 00:00:00 | 2024-10-12 00:00:00 | 2024-10-13 00:00:00 | 2024-10-14 00:00:00 | 2024-10-15 00:00:00 | 2024-10-16 00:00:00 | 2024-10-17 00:00:00 | 2024-10-18 00:00:00 | 2024-10-19 00:00:00 | 2024-10-20 00:00:00 | 2024-10-21 00:00:00 | 2024-10-22 00:00:00 | 2024-10-23 00:00:00 | 2024-10-24 00:00:00 | 2024-10-25 00:00:00 | 2024-10-26 00:00:00 | 2024-10-27 00:00:00 | 2024-10-28 00:00:00 | 2024-10-29 00:00:00 | 2024-10-30 00:00:00 | 2024-10-31 00:00:00
 |  |  |  |  | 2024-10-02 00:00:00 | 2024-10-03 00:00:00 | 2024-10-04 00:00:00 | 2024-10-05 00:00:00 | 2024-10-06 00:00:00 | 2024-10-07 00:00:00 | 2024-10-08 00:00:00 | 2024-10-09 00:00:00 | 2024-10-10 00:00:00 | 2024-10-11 00:00:00 | 2024-10-12 00:00:00 | 2024-10-13 00:00:00 | 2024-10-14 00:00:00 | 2024-10-15 00:00:00 | 2024-10-16 00:00:00 | 2024-10-17 00:00:00 | 2024-10-18 00:00:00 | 2024-10-19 00:00:00 | 2024-10-20 00:00:00 | 2024-10-21 00:00:00 | 2024-10-22 00:00:00 | 2024-10-23 00:00:00 | 2024-10-24 00:00:00 | 2024-10-25 00:00:00 | 2024-10-26 00:00:00 | 2024-10-27 00:00:00 | 2024-10-28 00:00:00 | 2024-10-29 00:00:00 | 2024-10-30 00:00:00 | 2024-10-31 00:00:00
Spreadsheet: 0000399e-5ae3-4bcd-8292-de1cf646da21
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 | From: |  |  |  |  |  |  |  |  | From:
 |  |  |  | Fair Code: | 1587 |  |  |  |  |  |  |  | Fair Code: | 1587
 |  |  |  | Fair Name: | IIE Spring 2014 |  |  |  |  |  |  |  | Fair Name: | IIE Spring 2014
 |  |  |  | FAIR CITY: |  |  |  |  |  |  |  |  | FAIR CITY:
 |  |  |  | #BOXES per |  |  |  |  |  |  |  |  | #BOXES per
 |  |  |  | CITY ABOVE: |  |  |  |  |  |  |  |  | CITY ABOVE:
 |  | SHIP TO: |  | OCS America Inc. |  |  |  |  |  |  | SHIP TO: |  | OCS America Inc.
 |  |  |  | Boston Branch |  |  |  |  |  |  |  |  | Boston Branch
 |  |  |  | 29 Draper Street |  |  |  |  |  |  |  |  | 29 Draper Street
 |  |  |  | Woburn MA. 01801 USA |  |  |  |  |  |  |  |  | Woburn MA. 01801 USA
 |  |  |  | Tel: [PHONE] |  |  |  |  |  |  |  |  | Tel: [PHONE]
 | From: |  |  |  |  |  |  |  |  | From:
 |  |  |  | Fair Code: | 1587 |  |  |  |  |  |  |  | Fair Code: | 1587
 |  |  |  | Fair Name: | IIE Spring 2014 |  |  |  |  |  |  |  | Fair Name: | IIE Spring 2014
 |  |  |  | FAIR CITY: |  |  |  |  |  |  |  |  | FAIR CITY:
 |  |  |  | #BOXES per |  |  |  |  |  |  |  |  | #BOXES per
 |  |  |  | CITY ABOVE: |  |  |  |  |  |  |  |  | CITY ABOVE:
 |  | SHIP TO: |  | OCS America Inc. |  |  |  |  |  |  | SHIP TO: |  | OCS America Inc.
 |  |  |  | Boston Branch |  |  |  |  |  |  |  |  | Boston Branch
 |  |  |  | 29 Draper Street |  |  |  |  |  |  |  |  | 29 Draper Street
 |  |  |  | Woburn MA. 01801 USA |  |  |  |  |  |  |  |  | Woburn MA. 01801 USA
 |  |  |  | Tel: [PHONE] |  |  |  |  |  |  |  |  | Tel: [PHONE]
Spreadsheet: 837699d1690364315-calculating-values-between-date-ranges-excel-date-forum-request
Sheet: Training View

 |  | Training Impact | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00
 |  | Skill | M01 | M02 | M03 | M04 | M05 | M06 | M07 | M08 | M09 | M10 | M11 | M12
 |  | AMS CLINICAL TEAM LEADER
 |  | AMS CORE
 |  | AMS CHAT
 |  | AMS CRM
 |  | AMS CRM - CLINICAL
 |  | AMS PRE AUTH
 |  | AMS TEAM LEADER
 |  | BM CHO
 |  | BM CLINICAL TEAM LEADER
 |  | BM CORE
 |  | BM CORE CHAT
 |  | BM CRM - CLINICAL
 |  | BM CRM FTQ
 |  | BM ESC CRM
 |  | BM PRE AUTH
 |  | BM PRE AUTH SPEC
 |  | BM SPEC
 |  | BM TEAM LEADER
Spreadsheet: 45277d1244049461-percentile-percentile
Sheet: Sheet1

Grade | Amount
B2 | 3
B2 | 2
B3 | 5
B3 | 6
B4 | 8
B4 | 9
B5 | 10
B5 | 11
B6 | 15
B2 | 3
B3 | 7
B6 | 14
Need function for the table below
Percentile | 0.1 | 0.25 | 0.5 | 0.6 | 0.75 | 0.9
B2
B3
B4
B5
Spreadsheet: 96182500-9f80-45f9-a203-cd20eb9e860e
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
MOLPS | Test | MOLPS | Molybdenum, Serum | Molybdenum, S | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 1.6 | mL | Container/Tube: Plain, royal blue-top Monoject trace element blood collection tube-product #8881-307006 (Supply T184) [NAME]: 1.6 mL Collection Instructions: See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.4 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm, OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	NA | 0.3-2.0 ng/mL | Thursday; 11 a.m. | 1 day | 7 days | 1 | 82190 |  |  |  |  | Rochester
MOLPS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
MOLPS | Result | 89270 | Molybdenum, S | Molybdenum, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 5698-6 | Molybdenum:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 755662d1637019030-help-label-a-record-depending-on-country-and-amount-sheet-1
Sheet: Test

 | Purchase #
 | Total  Purchases |  |  |  |  |  | Date:
 |  |  |  |  | TNXDL
Order # | Invoicel# | Column2 | Priority | Department | Vendor | Description | Pce | Wgt | Val | Cntry | Category
1 | 123 | ABC | 1 | HR | AYZ | Office Supplies | 1 | 1
2 | 123 | ABC | 2 | TAX | AYZ | Office Supplies | 1 | 1
3 | 123 | ABC | 3 | PAYROLL | AYZ | Office Supplies | 1 | 1
4 | 123 | ABC | 4 | A | AYZ | Office Supplies | 1 | 1
5 | 123 | ABC | 5 | B | AYZ | Office Supplies | 1 | 1
6 | 123 | ABC | 6 | C | AYZ | Office Supplies | 1 | 1
7 | 123 | ABC | 7 | D | AYZ | Office Supplies | 1 | 1
8 | 123 | ABC | 8 | A | AYZ | Office Supplies | 1 | 1
9 | 123 | ABC | 9 | B | AYZ | Office Supplies | 1 | 1
10 | 123 | ABC | 10 | C | AYZ | Office Supplies | 1 | 1
11 | 123 | ABC | 11 | D | AYZ | Office Supplies | 1 | 1
12 | 123 | ABC | 12 | A | AYZ | Office Supplies | 1 | 1
13 | 123 | ABC | 13 | B | AYZ | Office Supplies | 1 | 1
14 | 123 | ABC | 14 | C | AYZ | Office Supplies | 1 | 1
15 | 123 | ABC | 15 | D | AYZ | Office Supplies | 1 | 1
16 | 123 | ABC | 16 | A | AYZ | Office Supplies | 1 | 1
17 | 123 | ABC | 17 | B | AYZ | Office Supplies | 1 | 1
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
Spreadsheet: 274719d1383203790-range-of-cells-defined-by-other-cells-for-maximum-minimum-average-and-standard-deviation-array-functions-for-taniwha-modified-20131031
Sheet: Sheet1

Distance Start | Distance End | Height | [NAME] | Section Start | SectionEnd | [NAME] | Min | [NAME] | Avg |  |  |  |  |  |  |  |  | I would like to find the minimum, maximum, average and standard deviation for a range of cells, however the range of cells in the formula would be defined by other cells. If you look at the attached spreadsheet, I would like to find the maximum height that lies between each Section Start and Section End. I would like to formula to look at the cell E2 (0.000) and cell F2 (0.020) . The formula would then look at all the  Heights (column C) which lie between the corresponding Distance Start and Distance End, ie: in this case the formula would find the maximum value for C2:C21, because these heights lie between the Section Start and Section End defined in E2 and F2. I would like to do the same thing with minimum, average and standard deviation.
0 | 0.001 | 40.1 |  | 0 | 0.02
0.001 | 0.002 | 28.5 |  | 0.02 | 0.04
0.002 | 0.003 | 21.2 |  | 0.04 | 0.06
0.003 | 0.004 | 12.2
0.004 | 0.005 | 9.2 | Manual Formula | Section Start | SectionEnd | [NAME] | Min | [NAME] | Avg
0.005 | 0.006 | 10 |  | 0 | 0.02
0.006 | 0.007 | 11.1 |  | 0.02 | 0.04
0.007 | 0.008 | 9.6 |  | 0.04 | 0.06
0.008 | 0.009 | 4.6
0.009 | 0.01 | 1.8
0.01 | 0.011 | 2.2
0.011 | 0.012 | 3.1
0.012 | 0.013 | 2.7
0.013 | 0.014 | 3.2
0.014 | 0.015 | 2.6
0.015 | 0.016 | 2.4
0.016 | 0.017 | 3.1
0.017 | 0.018 | 30.6
0.018 | 0.019 | 40
0.019 | 0.02 | 37.8
0.02 | 0.021 | 17.2
0.021 | 0.022 | 3.2
0.022 | 0.023 | 4.5
0.023 | 0.024 | 3.5
0.024 | 0.025 | 2.7
0.025 | 0.026 | 1.7
0.026 | 0.027 | 2.7
0.027 | 0.028 | 2.3
0.028 | 0.029 | 2
0.029 | 0.03 | 1.4
0.03 | 0.031 | 1.3
0.031 | 0.032 | 2
0.032 | 0.033 | 3.3
0.033 | 0.034 | 1.8
0.034 | 0.035 | 2
0.035 | 0.036 | 2.5
0.036 | 0.037 | 3
0.037 | 0.038 | 3.2
0.038 | 0.039 | 2.2
0.039 | 0.04 | 1.2
0.04 | 0.041 | 1.5
0.041 | 0.042 | 1.3
0.042 | 0.043 | 1.4
0.043 | 0.044 | 2.4
0.044 | 0.045 | 2.1
0.045 | 0.046 | 2.9
0.046 | 0.047 | 2.5
0.047 | 0.048 | 1.3
0.048 | 0.049 | 1.5
0.049 | 0.05 | 1.7
0.051 | 0.051 | 2.2
0.052 | 0.052 | 2.1
0.053 | 0.053 | 1.6
0.054 | 0.054 | 1.7
0.055 | 0.056 | 2
0.056 | 0.057 | 2.1
0.057 | 0.058 | 1.6
0.058 | 0.059 | 1.8
0.059 | 0.06 | 1.6
0.06 | 0.061 | 2.3
Spreadsheet: 9c2a133c-d7ec-4d4c-8277-4e0b141d32c3
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7076 | 40922 | Francesc | Sola Garcia | ESP | 5 | 00:12:40 | 00:02:42 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:24:59
7076 | 30318 | Rafael | Lopez Ordoñez | ESP | 1 | [NAME] | 00:03:02 | 00:49:43 | 00:02:09 | [NAME] | 2 | 01:43:03
7076 | 49381 | Norberto | [NAME] | ESP | 4 | 00:23:10 | 00:05:46 | 00:54:15 | 00:00:00 | 00:00:00 | 3 | 01:53:52
7076 | 30672 | [NAME] | Goddard | GBR | 3 | 00:14:01 | 00:05:50 | 01:10:09 | 00:02:28 | 00:00:00 | DQ | 00:00:00
Spreadsheet: 680690d1591140085-formula-to-calculate-minutes-with-conditions-of-data-from-another-sheet-time-different-por2gal-
Sheet: Time Diff

Sign On & Depart |  | Arrival & Start |  | Start & Depart
convert hours and minutes to round up to the nearest minute
calculate what is |  | delay time | on time | early time
Spreadsheet: 799488d1665112377-if-then-and-greater-than-less-than-formula-blondielocks-example
Sheet: Sheet1

begin date | end date | result
2022-01-01 00:00:00 | 2022-01-01 00:00:00
2022-01-01 00:00:00 | 2022-01-02 00:00:00
2022-01-01 00:00:00 | 2022-01-29 00:00:00
2022-01-01 00:00:00 | 2022-01-30 00:00:00
2022-01-01 00:00:00 | 2022-01-31 00:00:00
2022-01-01 00:00:00 | 2022-02-01 00:00:00
2022-01-01 00:00:00 | 2022-02-15 00:00:00
Spreadsheet: 45653d1244473242-nesting-vlookup-in-if-vice-versa-and-pivot-table-sample3
Sheet: Feb Summary

Model | Year-to-Date: Cat1 | Year-to-Date: Cat2 | Total YTD
500 | -174.29 | 245.7489 | 71.45889999999997
750 | -2467.829620000004 | 3545.287138440006 | 1077.457518440002
900 | -2669.357555600005 | 4615.853085143529 | 1946.495529543524
AB | -1443.1102088 | 2284.12306358496 | 841.0128547849602
AD | -53.8898 | 75.984618 | 22.094818
AG | -63.58996399999999 | 109.9597657488 | 46.3698017488
AL | -1523.33 | 2147.8953 | 624.5652999999998
AN | -1797.5294 | 3108.28783848 | 1310.75843848
BX | -8842.635900000001 | 13995.92940228 | 5153.293502279999
BZ | -7039.132799999999 | 11141.38440576 | 4102.251605760001
CA | -4014.1539 | 6353.51440788 | 2339.360507880001
CB | -877.04125 | 1388.1615795 | 511.1203295000003
DE | -1471.4364 | 0 | -1471.4364
DF | 0 | 1143.86391 | 1143.86391
DS | 0 | 910.56672 | 910.56672
DV | -4460.2879 | 0 | -4460.2879
DX | -3484.0798 | 0 | -3484.0798
FA | 0 | 519.2621099999999 | 519.2621099999999
GL | -2868.781915198807 | 4044.982500430317 | 1176.200585231511
GM | -221.0269653693443 | 311.6480211707755 | 90.62105580143117
MF | -1646.582489341475 | 2606.174509102399 | 959.5920197609234
MR | -20226.46215053684 | 32013.99893857465 | 11787.53678803781
OA | -715.5376707607675 | 1132.537270322255 | 416.9995995614872
OB | -268.7207781562057 | 425.3253308778663 | 156.6045527216607
OR | -337.5699915762351 | 534.2983499331054 | 196.7283583568703
RA | -565.1764208362113 | 977.3030669099766 | 412.1266460737653
RF | -10622.17550350159 | 18367.86588065495 | 7745.69037715336
TM | -61.21638142096588 | 105.8553667531342 | 44.63898533216832
ZP | -591.955380684333 | 936.9339426672207 | 344.9785619828876
Grand Total | -78506.90014578278 | 113042.745422214 | 34535.84527643117
34535.84527643117
34535.84527643117
34535.84527643117
Spreadsheet: 81702d1281832157-counting-how-often-numbers-in-a-range-occur-in-rows-of-data-countoccurrences
Sheet: Sheet1

Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 |  | 40>49 | 30>49 | 20>29 | 10>19
10 | 11 | 32 | 38 | 41 | 44 |  | 2 | 2 | 0 | 2
12 | 17 | 23 | 31 | 43 | 46 |  | 2 | 1 | 1 | 2
15 | 18 | 23 | 29 | 32 | 43 |  | 1 | 1 | 2 | 2
Spreadsheet: 56416d1256625844-how-to-merge-repeated-data-cell-in-excel-sample-6
Sheet: Sheet2

Plot No | Area |  |  |  | Name of Owner
43 | 0 | 8 | 0 | 0 | A
43 | 0 | 8 | 0 | 0 | B
43 | 0 | 8 | 0 | 0 | C
44 | 0 | 5 | 0 | 0 | A
275 | 0 | 2 | 2 | 2 | A
275 | 0 | 2 | 2 | 2 | B
275 | 0 | 2 | 2 | 2 | C
275 | 0 | 2 | 2 | 2 | D
278 | 3 | 3 | 1 | 1 | A
278 | 1 | 2 | 1 | 1 | B
278 | 1 | 2 | 1 | 1 | C
278 | 1 | 2 | 1 | 1 | D
Spreadsheet: richard_shapiro__32170__shapiro-1
Sheet: charvel

COST CENTER |  | OUTSIDE SERVICES DISCRETIONARY | PRIORITY | REQUESTED | APPROVED | COMMENTS
Charvel (100) | L | outside services - Mexican deregulation for gas and electrict markets, leg matters, legal opinions on env and energy matters, env processing of permits, document production and translation |  | 110000 | RCR
Charvel Total |  | Charvel Total
COST CENTER |  | OTHER BUSINESS EXPENSE |  | REQUESTED | APPROVED
Charvel (100) | AP | other business expense - Mexican Assoc of Electric Energy, Mexican Academy of Energy Law and attendance at various conferences |  | 15000 | 15000
Charvel Total |  | Charvel Total
Budget - Outside Services |  |  |  | 9000000 | 9000000
Outside Discretionary
[NAME]
Budget - Outside Services |  |  |  | 9000000 | 9000000
Outside Fixed |  |  |  | 0 | 0
[NAME]
Budget - Other Business Expense |  |  |  | 1200000 | 1200000
Other Business Expense
[NAME]
Spreadsheet: phillip_m_love__30151__9906_OA
Sheet: Check

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - COMPREHENSIVE VARIANCE INTEGRITY CHECK
COMPANY:  ALL
REGION: ALL
PRODUCTION MONTH: 9906
Regions | NGP&L | Actuals | [NAME] |  | All Reclass
Central
Northeast | 0 | 0
East- EGM
East-LRC
FT-East
Texas-EGM
Texas-HPL
FT-SouthTexas
West
Storage
Ontario
FT-Ontario
BUG
Total Per Indiv. Tabs
Per TOTAL Tab
Regions | Revised NGP&L | Actuals | [NAME]
Central
Northeast | 0
East
Texas
West
Storage
Ontario
BUG
Total Per Indiv. Tabs
Per TOTAL Column
Spreadsheet: 837220d1689943880-scaling-reduction-of-a-price-based-on-gp-value-in-another-column-scaling-reduction-based-on-gp-value2
Sheet: Sheet1

 |  |  |  |  |  |  |  | Column K - If an item has a value in Column J, it knocks 10% column B and puts it in this column
Cost | Less VAT | £ea | Profit | GP % | Delivery | Nett | Trade Validity? | Alt -VAT -10%
5 |  | 7.5 |  |  | 1 |  |  |  | Example 1: If [NAME] is less than 25% then Column J - Nothing appears. Column K, uses the value in Column B
5 |  | 8.5 |  |  | 1 |  |  |  | Example: If an item is greater than 25%, then Column J - Note appears. Column K knocks another 10% off
5 |  | 9.5 |  |  | 1 |  |  |  | Example 3: If an item is between 30 to 35% GP then I'd like it to knock 15% off in Column K
5 |  | 10 |  |  | 1 |  |  |  | Example 4: If an item is between 35 to 45% GP then I'd like it to knock 20% off in Column K
Spreadsheet: vkaminski__40792__PnmaRegas021800
Sheet: CF

Net Income and Cash Flow
Calendar Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS
Months of Operation
Contract Year
Annual Volume:
Annual MMBTU Production
Adjustment Factor |  |  |  | 0.1695333333333334 | 0.1709333333333334 | 0.3286000000000001 | 0.3388 | 0.3403333333333334 | 0.3466 | 0.3488000000000002 | 0.6322666666666668 | 0.6716666666666665 | 0.6767999999999998 | 0.6832666666666669 | 0.6959333333333334 | 0.6959333333333334 | 0.6959333333333334 | 0.6959333333333334 | 0.6959333333333334 | 0.6959333333333334 | 0.6959333333333334 | 0.6959333333333334 | 0.6959333333333334 | 0.6959333333333334 | 0.6959333333333334 | 0.6959333333333334 | 0.6959333333333334 | 0.6959333333333334 | 0.6959333333333334 | 0.6959333333333334
Take or Pay Factor
Total Annual Production (MMBTU)
Total Annual Production (MMSCFD)
Fixed Revenue Calculation:
Fixed Regas Payment ($/MMBTU)
Total Fixed Regas Payment (000's)
Total Revenues
TOTAL REVENUES:
Total Revenues / MMBtu Production
Operating Expenses:
Total Operating Expenses
Total Expenses / MMBtu Production
Operating Income
Other Income/(Expense):
Property Taxes
Municipal Taxes
Other |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Other Income/(Expense)
EBITDA
Less: Interest on LT Debt
Less: Withholding Tax on Interest
Less: License Tax
Less: Book Depreciation Expense
Less: Book Income Taxes
PANAMA BOOK INCOME
EBITDA
Less: Interest on LT Debt
Less: Withholding Tax on Interest
Less: License Tax
Less: Cash Income Taxes
Less: Principal Payments
NET CASH FLOW DISTRIBUTED
Debt Service Ratio Calculation
EBITDA
Less: Cash Income Taxes
Cash Available for Debt Service
Total Debt Service Obligations
Before-Tax Debt Service Coverage Ratio
After-Tax Debt Service Coverage Ratio
 |  |  | Pre-Tax | After-Tax
Average DS Coverage Ratio
Minimum DS Coverage Ratio
Spreadsheet: benjamin_rogers__942__NY Calcs010201
Sheet: Zone J

 | ZONE J |  |  |  |  |  | CALENDER 2001 |  |  | J/A | J/G |  |  | CALENDER 2002
 |  |  |  |  |  | TERM | BID | OFFER | DAYS |  |  | TERM | BID | OFFER | DAYS | "02/01" |  | 47 | 21 | 72
 |  |  |  |  |  | JAN | 74 | 74 | 22 |  |  | JAN | 65 | 70 | 22 |  |  | 49 | 20 | 76
 |  |  |  |  |  | FEB | 74 | 74 | 20 |  |  | FEB | 65 | 70 | 20 |  |  | 60 | 22 | 102
 | Q4 | CALC |  | Days | J/G | JAN-FEB |  |  |  |  |  | JAN-FEB |  |  |  |  |  | 60 | 20 | 102
 | Oct |  |  | 22 |  | MAR | 65 | 68 | 22 |  |  | MAR | 59 | 62 | 21 |  |  | 46 | 22 | 71
 | Nov |  |  | 21 |  | Q-1 |  |  |  |  |  | Q-1 |  |  |  |  |  | 37 | 21 | 66
 | Dec | 66.75 | 66.75 | 20 |  | APR | 59 | 63 | 21 |  |  | APR | 52 | 53 | 22
 | Q4 | 55 | 65 |  |  | MAY | 67 | 73 | 22 |  |  | MAY | 59 | 60 | 22
 |  |  |  |  | 5@7.5 | [NAME] | 85 | 90 | 21 |  |  | [NAME] | 76 | 78 | 20
NOTES | BIDS | OFFERS | LAST |  |  | Q-2 |  |  |  |  |  | Q-2
CAL 01 | 74 | 77.25 | 2000-10-31 00:00:00 |  |  | JUL | 120 | 130 | 21 |  |  | JUL | 112 | 115 | 22
CAL O2 |  |  |  |  |  | AUG | 120 | 130 | 23 |  |  | AUG | 112 | 115 | 22
CAL 03 |  |  |  |  |  | JUL-AUG |  |  |  |  |  | JUL-AUG
CAL 04 |  |  |  |  |  | SEPT | 56 | 58 | 19 |  |  | SEPT | 55 | 56 | 20
[NAME] |  |  |  |  |  | Q3 |  |  |  |  |  | Q3
NYJ/PJM |  |  |  |  |  | Oct | 57 | 60 | 23 |  |  | Oct | 53 | 54 | 23
 |  |  |  |  |  | Nov | 59 | 62 | 21 |  |  | Nov | 54 | 55 | 20
 |  |  |  |  |  | Dec | 60 | 63 | 20 |  |  | Dec | 55 | 56 | 21
 |  |  |  |  |  | Q4 |  |  |  |  |  | Q4
 |  |  |  |  |  | CAL 01 |  |  |  |  |  | cal 02
 |  |  |  |  |  |  |  |  |  |  |  | cal01/02
 |  |  |  |  |  |  |  |  |  |  | 7@9.5
 |  | POS | SUM
MONTH | DEC | JAN | FEB | [NAME] | APRIL | MAY | [NAME] | JULY | AUG | SEP | OCT | NOV | DEC
SETTLE
POSITION |  |  |  |  |  |  |  |  |  |  | 100 | 100 | 100
Spreadsheet: 61242d1262069381-auto-hide-show-lines-based-on-data-in-cell-auto-hide
Sheet: mY REQUIREMENTS

 |  |  | TARIQ | 0
 |  |  | MICHLE | 45
 |  |  | JOSEPH1 | 0
 |  |  | JOSEPH2 | 58
 |  |  | JOSEPH3 | 0
 |  |  | JOSEPH4 | 0
 |  |  | JOSEPH5 | 0
 |  |  | JOSEPH6 | 5
 |  |  | JOSEPH7 | 0
 |  |  | [NAME] | 0
 |  |  | JOSEPH9 | 0
 |  |  | SER | NAME | PIECES | RATE | TOTAL
 |  |  | 1 | MICHLE | 45 | 5 | 225
 |  |  | 2 | JOSEPH2 | 58 | 5 | 290
 |  |  | 3 | JOSEPH6 | 5 | 3 | 15
 |  |  | TOTAL |  |  |  | 530
Spreadsheet: 767768d1644610154-create-a-summary-sheet-to-include-data-their-from-multiple-sheets-dummy-workbook
Sheet: Sheet2

 | Date | Time | Item | PO Number | Quantity  Ordered | Quantity  Delivered | Booking  Reference Number | STATUS
JANUARY | 2022-01-04 00:00:00 | 10:00 | [NAME] | 448327 | 22000 | 12000 | 21184 | DELIVERED
 | 2022-01-13 00:00:00 | 10:00 | [NAME] | 448572 | 4000 | 4000 | 21317 | DELIVERED
 | 2022-01-18 00:00:00 | 10:00 | [NAME] | 448599 | 12000 | 12000 | 21444 | DELIVERED
FEBRUARY | 2022-02-03 00:00:00 | 12:00 | [NAME] | 448830 | 8000 | 8000 | 21435 | DELIVERED
 | 2022-02-07 00:00:00 | 12:00 | [NAME] | 449423 | 8000 | 8000 | 21738 | DELIVERED
 | 2022-02-10 00:00:00 | 12:00 | [NAME] | 448831 | 8000 | 8000 | 21687 | DELIVERED
 | 2022-02-16 00:00:00 | 12:00 | [NAME] | 449769 | 8000 |  | 21889 | NOT DELIVERED