tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 823352d1679921548-vlookup-check-stock-next-batch-if-the-quantity-is-lower-than-minimum-qty-book1-22-
Sheet: Sheet1

 |  |  |  |  |  | Part | Batch | STOCK | Cum Stock
 |  |  | Min Requirement | Batch |  | Part A | 101 | 4000
 |  | Part A | 5000 |  |  | Part A | 102 | 6000
 |  | Part B | 3000 |  |  | Part B | 203 | 4000
 |  | Part C | 2000 |  |  | Part B | 204 | 5000
 |  | Part D | 5000 |  |  | Part B | 205 | 1000
 |  | Part E | 4000 |  |  | Part C | 301 | 1000
 |  |  |  |  |  | Part C | 302 | 2000
 |  |  |  |  |  | Part D | 401 | 4000
 |  |  |  |  |  | Part E | 501 | 4500
 |  |  |  |  |  | Part E | 502 | 3000
 |  |  |  |  |  | Part E | 503 | 1000
Spreadsheet: 582519d1531921520-formulas-work-separately-but-not-combined-test
Sheet: REF

REF |  |  |  | 7/18/1/-DEL F COL, DUP OF E
"INT | Direction | Substrate | CSV Edge | CSV Edge Code | Top | Code | Dim | Right | Code2 | Dim3 | Bottom | Code4 | Dim5 | Left | Code6 | Dim7 | N | Prog? | Panel Type | Panel Depth | [NAME] | P4 File | BA∠1W-X Axis | BA∠2X-X Axis | BA∠3W-Z Axis | BA∠4X-Z Axis | Face X | Face Z | Taper | TDepth | RDepth | BDepth | LDepth | TR∠ | RB∠ | BL∠ | RL∠ | RB dim | RB inches
"INT_ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF(B2="H",(COUNTIF('EDGES & BEND ALLOWANCE'!$Y$2:$Y$319,E2)>0)
\
_Z |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y | CHECK H |  |  | 1
.P4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AE | CHECK V |  |  | 2
// |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z | CHECK H_2 |  |  | 3
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | '=IF(CSV!AK3="E1",1.25) |  |  |  |  |  |  | AA | CHECK H_25 |  |  | 4
FaceZ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IF(CSV!AK3="V1","VAR") |  |  |  |  |  |  | AB | CHECK H_3 |  |  | 5
" |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IF(CSV!AK3="L1","VAR") |  |  |  |  |  |  | AC | CHECK H_35 |  |  | 6
_4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AD | CHECK H_4 |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AF | CHECK HZ |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AG | CHECK VZ |  |  | 9
Spreadsheet: 270423d1381483142-how-many-hours-within-each-day-the-workplace-is-empty-time-value
Sheet: Sheet1

02/07/2013 17:32 | 03/07/2013 07:25 |  |  | 2013-07-01 00:00:00
02/07/2013 16:40 | 02/07/2013 18:35
02/07/2013 15:36 | 03/07/2013 04:20
02/07/2013 08:11 | 02/07/2013 14:42
01/07/2013 23:23 | 02/07/2013 07:45
01/07/2013 23:49 | 02/07/2013 08:48
01/07/2013 20:32 | 01/07/2013 22:40
01/07/2013 16:15 | 01/07/2013 21:49
01/07/2013 17:58 | 01/07/2013 20:25
01/07/2013 14:41 | 01/07/2013 17:45
01/07/2013 14:09 | 01/07/2013 15:30
Spreadsheet: 769442d1645541187-need-help-with-a-challenging-lookup-match-type-of-situation-example-file
Sheet: DATA

 |  |  |  | Expected Result of formula
ORIGIN CITY | ORIGIN ST | DEST CITY | DEST ST | MATCH LINE
BIRMINGHA | AL | ELMIRAGE | AZ | 6 | Matches to 6 because ORIGIN CS is BIRMINGHAM AL and [NAME] is ELMIRAGE AZ
BIRMINGHA | AL | SANBERNAR | CA | 4 | Matches to 4 because its DEST ST is CA
CHICAGO | IL | BIGLIFT | CO | 1 | Matches to 1 because Origin C/S is CHICAGO IL
CHICAGO | IL | LAUREL | MT | 1 | Matches to 1 because Origin C/S is CHICAGO IL
CHICAGO | IL | PEARLAND | TX | 1 | Matches to 1 because Origin C/S is CHICAGO IL
CHICAGO | IL | SANBERNAR | CA | 2 | Matches to 2 because [NAME] is CHICAGO IL and DEST CS is SANBERNAR CA
CORCHRIST | TX | SANBERNAR | CA | 5 | Matches to 5 because its [NAME] is TX and its dest st is CA
BIRMINGHA | AL | RICHMOND | CA | 3 | Matches to 3 because its dest C/S is RICHMOND CA
BIRMINGHA | AL | SANBERNAR | CA | 4 | Matches to 4 because its dest st is CA
CHICAGO | IL | KANCITY | KS | 1 | Matches to 1 because Origin C/S is CHICAGO IL
CHICAGO | IL | KENT | WA | 1 | Matches to 1 because Origin C/S is CHICAGO IL
CHICAGO | IL | ORILLIA | WA | 1 | Matches to 1 because Origin C/S is CHICAGO IL
CHICAGO | IL | PEARLAND | TX | 1 | Matches to 1 because Origin C/S is CHICAGO IL
CHICAGO | IL | PORTERSIX | OR | 1 | Matches to 1 because Origin C/S is CHICAGO IL
CHICAGO | IL | RICHMOND | CA | 1 | Matches to 1 because Origin C/S is CHICAGO IL
CHICAGO | IL | SANBERNAR | CA | 2 | Matches to 2 because Origin is CHICAGO IL and DEST is SANBERNAR CA
CORCHRIST | TX | ALLIANCE | TX | N | No matches
 |  |  |  | N= NO MATCH
 |  |  |  |  | Row
Spreadsheet: 76132d1276695836-two-columns-count-of-data-list_help
Sheet: Sheet1

COUNTY | UNIT |  |  |  | SUMMARY
[NAME] | UNIT 1 | 1 |  |  | [NAME] | 3 | 3
[NAME] | UNIT 2 | 1 |  |  | LANCASHIRE | 6 | 6
[NAME] | UNIT 3 | 1
[NAME] | UNIT 3 | 2
LANCASHIRE | UNIT A | 1
LANCASHIRE | UNIT A | 2
LANCASHIRE | UNIT A | 3
LANCASHIRE | UNIT B | 1
LANCASHIRE | UNIT C | 1
LANCASHIRE | UNIT C | 2
LANCASHIRE | UNIT D | 1
LANCASHIRE | UNIT E | 1
LANCASHIRE | UNIT F | 1
Spreadsheet: 220038d1363038641-list-within-list-list-in-list
Sheet: Sheet1

California |  | in B1 --> if [NAME] is a state in the "Without Operations List", return "No operations currently in that state" | All States | States Without Operations
 |  |  | Alabama | Alaska
 |  |  | Alaska | Arkansas
 |  |  | Arizona | Hawaii
 |  |  | Arkansas | Indiana
 |  |  | California | Kansas
 |  |  | Colorado | Louisiana
 |  |  | Connecticut | Mississippi
 |  |  | Delaware | New Hampshire
 |  |  | Florida | North Dakota
 |  |  | Georgia | Vermont
 |  |  | Hawaii
 |  |  | Idaho
 |  |  | Illinois
 |  |  | Indiana
 |  |  | Iowa
 |  |  | Kansas
 |  |  | Kentucky
 |  |  | Louisiana
 |  |  | Maine
 |  |  | Maryland
 |  |  | Massachusetts
 |  |  | Michigan
 |  |  | Minnesota
 |  |  | Mississippi
 |  |  | Missouri
 |  |  | Montana
 |  |  | Nebraska
 |  |  | Nevada
 |  |  | New Hampshire
 |  |  | New Jersey
 |  |  | New Mexico
 |  |  | New York
 |  |  | North Carolina
 |  |  | North Dakota
 |  |  | Ohio
 |  |  | Oklahoma
 |  |  | Oregon
 |  |  | Pennsylvania
 |  |  | Rhode Island
 |  |  | South Carolina
 |  |  | South Dakota
 |  |  | Tennessee
 |  |  | Texas
 |  |  | Utah
 |  |  | Vermont
 |  |  | Virginia
 |  |  | Washington
 |  |  | West Virginia
 |  |  | Wisconsin
 |  |  | Wyoming
Spreadsheet: benjamin_rogers__1262__Pastoria CFTejon8a revised 21 - 750 MW
Sheet: Tejon

[NAME] Payments
[NAME])
[NAME] 12/99 Payment
[NAME] (AFC Filing)
[NAME] Payments
[NAME]
Total
NPV12 @ 4/30/99
Tejon Ranchcorp Post-Operational Payments
 |  |  | 1999-04-30 00:00:00
Fixed Rent Payment
Spark Spread Payment
[NAME] Payment |  |  |  | 0
Total |  |  | 0
NPV12 @ 4/30/99
NPV of Pre-Operational Payments
NPV of Post-Operational Payments
Total [NAME]
Spreadsheet: f5e022a9-766b-44fc-af47-8d7c3b828ca8
Sheet: Sheet1

NEW MEXICO HIGHLANDS UNIVERSITY | 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 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
STUDENT EMPLOYEE TIMESHEET
EMPLOYEE NAME:
LAST  NAME: |  |  |  | FIRST  NAME: |  |  |  |  |  | [NAME] ID:
 |  |  |  |  |  |  |  |  |  | @0
Department/School: |  |  |  | Pay Period: |  | Beginning Date: |  |  |  |  |  | Ending Date:
 |  |  |  | 2011-01-01 00:00:00 |  |  |  |  |  |  |  | 2011-01-14 00:00:00
Position Number 1: |  |  |  | Position Number 2: |  |  |  |  |  |  |  | Position Number 3:
Pay Rate: |  |  |  | Pay Rate: |  |  |  |  |  |  |  | Pay Rate:
FOAPL: |  |  |  | FOAPL: |  |  |  |  |  |  |  | FOAPL:
Month: | Sat | Sun | M | T | W | Th | F | 1st  Week Total | Sat | Sun | M | T | W | Th | F | 2nd  Week Total | Pay Period
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total  Hours
Dates: | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 |  | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00
Hours Worked |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 | 0
I hereby certify that the above information is true and correct in all respects.
Employee Signature |  |  |  |  | Date |  |  |  | Supervisor Signature |  |  |  |  |  |  | Date
INSTRUCTIONS
1.  [NAME] and employee must initial any changes.
2.  Do not use liquid paper on timesheet and do not complete in pencil.
3.  Timesheets are due in the Human Resources Department on the deadline date/time noted on the payroll schedule.
4.  To convert minutes to a decimal, divide minutes worked by 60 (example: 2 hours 22 minutes = 22/60 = .37 TOTAL 2.37.
5. [NAME] ID must be completed starting with the @ sign.
Spreadsheet: 227c0af8-b402-4690-a7ca-03f7a547023c
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0001602 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Town of Winton WWTP | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Hertford | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 01002 | 01007 | 00310 | 01027 | 00916 | 31616 | 01042 | 01051 | 00927 | 71900 | 01067 | 00610 | 00625 | 00620 | 00556
Day | ORC Arrival Time | ORC Time On Site | Flow | Arsenic | Barium | BOD5 | Cadmium | Calcium | Fecal Coliform | Copper | Lead | Magnesium | Mercury | Nickel | Ammonia | Total [NAME] | Nitrate | Oil & Grease
 | 24-hr | hrs | GPD | mg/L | mg/L | mg/L | mg/L | mg/L | #/100 mL | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab
Monthly Limit: |  |  | 585000
Daily Limit:
Sample Frequency: |  |  | [NAME] | 3 x Year | 3 x Year | Monthly | 3 x Year | 3 x Year | 3 x Year | 3 x Year | 3 x Year | 3 x Year | 3 x Year | 3 x Year | Monthly | Monthly | Monthly | 3 x Year
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 746704d1630958216-problems-with-dataset-index-formula-sheet1
Sheet: Ark1

Storename | Product |  | Storename | 1 | 2 | 3 | 4 | 5
Foodstore 1 | Apple |  | Foodstore 1 |  | Pear | [NAME] | Lemon
Foodstore 1 | Pear |  | Foodstore 2 | Grass | Blueberry
Foodstore 1 | [NAME]
Foodstore 1 | Lemon
Foodstore 2 | Grass
Foodstore 2 | Blueberry
Spreadsheet: a9e02bc1-96e9-4dde-a7be-d06020bd6cee
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | SAVE, Inc.
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 11 |  |  |  |  |  | Total
 | General Fund
 | Special Revenue |  |  |  | 0 |  |  |  |  |  | 0
 | Enterprise
 |  | Total: |  |  | 0 |  |  |  |  |  | 0
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 11 |  |  |  |  |  | Total
 | General Fund
 | Special Revenue |  |  |  | 0 |  |  |  |  |  | 0
 | Enterprise/Other
 |  | Total: |  |  | 0 |  |  |  |  |  | 0
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 706370d1606665969-compare-json-data-and-splitting-into-corrected-codes-deleted-codes-and-added-codes-sample-data-for-added-deleted-corrected-queries-11292019
Sheet: Output

Billid | Ctextid | codername | correctedcode | deletedcode | addedcode
2132 | 91156 | amt1 |  |  | 887756
5678 | 99344 | [NAME] | 90774
7789 | 60045 | ec1 | Z003345,H678 | U8923,Y98620 | J18907
Spreadsheet: 112121d1308257133-if-statement-comparing-3-values-if-statement-help
Sheet: Sheet1

Part Number | Manufacturer | Qty | Cost | Overhead | Price | Ext. |  | Cost | Overhead | Price | Ext. |  | Cost | Overhead | Price | Ext.
 |  |  | A |  |  |  |  | B |  |  |  |  | C
 |  | 1 | 103 |  |  |  |  | 102.56 |  |  |  |  | 98.94
 |  |  |  |  |  |  |  | I am trying to compare the three highlighted values and have the cell return the lowest value
 |  |  |  |  |  |  |  | hopefully with the representation of either A, B or C
Spreadsheet: 784768d1655944516-help-with-concatenate-sort-filter-table-formula-sample-1
Sheet: Data Table

Client | Name | Total | Data Month | In Filter
ABC | Name 1 | 100000 | 2022-01-01 00:00:00
ABC | Name 2 | 105000 | 2022-02-01 00:00:00 |  |  |  |  |  |  | How can I concatenate the Name with the Month in the top 5 list
ABC | Name 3 | -808.65 | 2022-03-01 00:00:00
ABC | Name 4 | -228.91 | 2022-04-01 00:00:00 |  |  |  |  |  |  | What it is |  |  |  | What I want
ABC | Name 5 | 300000 | 2022-05-01 00:00:00 |  |  |  |  |  |  | Top 5 |  |  |  | Top 5
ABC | Name 6 | 909.77 | 2022-06-01 00:00:00
ABC | Name 1 | 639.61 | 2022-01-01 00:00:00 |  |  |  |  |  |  |  | 360000 |  |  | Name 4- 4/1/2022 | 360000
ABC | Name 2 | 305000 | 2022-02-01 00:00:00 |  |  |  |  |  |  | Name 3 | 350000 |  |  | Name 3- 3/1/2022 | 350000
ABC | Name 3 | 50000 | 2022-03-01 00:00:00 |  |  |  |  |  |  | Name 2 | 340000 |  |  | Name 2- 2/1/2022 | 340000
ABC | Name 4 | 25000 | 2022-04-01 00:00:00 |  |  |  |  |  |  | Name 2 | 305000 |  |  | Name 2- 2/1/2022 | 305000
ABC | Name 5 | 10000 | 2022-05-01 00:00:00 |  |  |  |  |  |  | Name 5 | 300000 |  |  | Name 5- 5/1/2022 | 300000
ABC | Name 6 | 70000 | 2022-06-01 00:00:00
ABC | Name 1 | 120000 | 2022-01-01 00:00:00
ABC | Name 2 | 340000 | 2022-02-01 00:00:00
ABC | Name 3 | 350000 | 2022-03-01 00:00:00
ABC | Name 4 | 360000 | 2022-04-01 00:00:00
ABC | Name 5 | 660 | 2022-05-01 00:00:00
ABC | Name 6 | 66379.92 | 2022-06-01 00:00:00
Spreadsheet: e76797d6-449d-4cba-bff1-908fc5b3fe15
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
LAMB | Test | LAMB | Lamb, IgE | Lamb, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
LAMB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
LAMB | Result | LAMB | Lamb, IgE | Lamb, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6155-6
Spreadsheet: 127596d1320421946-average-formula-excluding-div-error-client-retentionzeronotblank
Sheet: Client Retention

SAP# | Unit Name | OCT | NOV | DEC | 1ST QTR ACTUALS | 1st QTR BUDGET | % | JAN | FEB | MAR | 2ND QTR ACTUALS | 2ND QTR BUDGETS | % | APR | MAY | JUN | 3RD QTR ACTUALS | 3RD QTR BUDGET | % | JUL | AUG | SEP | 4TH QTR ACTUALS | 4TH QTR BUDGET | % | Over All %
10423 | OCHSNER MEDICAL CENTER - WEST BANK | 0.95 | 0.95 | 0.95 |  | 1 |  | 0.95 | 0.95 | 0.95 |  | 1 |  | 0.8 | 0.8 | 0.8 |  | 1 |  | 0 | 0 | 0 |  | 1
10424 | OSCHNER MEDICAL CENTER - KENNER | 0 | 0 | 0 |  | 1 |  | 0 | 0 | 0 |  | 1 |  | 0 | 0 | 0 |  | 1 |  | 0 | 0 | 0 |  | 1
10429 | BILOXI REGIONAL MEDICAL CENTER | 0 | 0 | 0 |  | 1 |  | 0 | 0 | 0 |  | 1 |  | 0 | 0 | 0 |  | 1 |  | 0 | 0 | 0 |  | 1
10439 | SINGING RIVER HOSPITAL | 0 | 0 | 0 |  | 1 |  | 0 | 0 | 0 |  | 1 |  | 0 | 0 | 0 |  | 1 |  | 0 | 0 | 0 |  | 1
10440 | OCEAN SPRINGS HOSPITAL | 0 | 0 | 0 |  | 1 |  | 0 | 0 | 0 |  | 1 |  | 0 | 0 | 0 |  | 1 |  | 0 | 0 | 0 |  | 1
Spreadsheet: 707168d1607081308-find-the-earliest-occurence-date-and-time-and-the-corresponding-category-sample
Sheet: Sheet1

Resco Overview DATE | Resco Overview TIME | Resco Mobile CRM Application DATE | Resco Mobile CRM Application TIME | Woodford Walkthrough DATE | Woodford Walkthrough TIME | Entities DATE | Entities TIME | Entity Views DATE | Entity Views TIME | Entity Forms DATE | Entity Forms TIME | Views & Forms: Advanced Customizations DATE | Views & Forms: Advanced Customizations TIME | Business Logic via Rules DATE | Business Logic via Rules TIME | Component Configuration DATE | Component Configuration TIME | User full name
2019-10-21 00:00:00 | 16:13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | User 1
 |  |  |  |  |  |  |  | 2020-11-12 00:00:00 | 12:14 |  |  |  |  | 2020-11-12 00:00:00 | 12:14 |  |  | User 2
2019-10-24 00:00:00 | 13:25 |  |  |  |  | 2019-10-24 00:00:00 | 13:38 | 2019-10-24 00:00:00 | 13:39 | 2019-10-24 00:00:00 | 13:42 | 2019-10-24 00:00:00 | 13:46 | 2019-10-25 00:00:00 | 07:59 |  |  | User 3
2019-10-24 00:00:00 | 14:36 |  |  |  |  |  |  |  |  |  |  | 2019-10-24 00:00:00 | 14:38 |  |  |  |  | User 4
2019-10-24 00:00:00 | 16:42 | 2020-02-17 00:00:00 | 11:48 | 2020-02-17 00:00:00 | 12:36 | 2019-10-31 00:00:00 | 12:56 | 2020-02-18 00:00:00 | 10:50 | 2019-11-20 00:00:00 | 12:05 | 2019-10-31 00:00:00 | 16:07 | 2020-02-17 00:00:00 | 12:40 | 2020-02-17 00:00:00 | 12:40 | User 5
2019-10-25 00:00:00 | 10:17 | 2020-08-28 00:00:00 | 09:41 | 2020-08-28 00:00:00 | 09:41 | 2020-01-07 00:00:00 | 13:30 | 2020-01-07 00:00:00 | 13:30 | 2020-01-07 00:00:00 | 13:30 | 2020-01-07 00:00:00 | 13:30 | 2020-01-07 00:00:00 | 13:30 | 2020-01-07 00:00:00 | 13:31 | User 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | User 7
2019-10-27 00:00:00 | 00:40 | 2020-02-03 00:00:00 | 14:50 | 2020-07-02 00:00:00 | 21:41 | 2020-07-02 00:00:00 | 21:42 | 2020-07-02 00:00:00 | 21:42 | 2020-07-02 00:00:00 | 21:42 | 2020-07-02 00:00:00 | 21:43 | 2020-07-02 00:00:00 | 21:44 | 2020-07-02 00:00:00 | 21:45 | User 8
Spreadsheet: harry_arora__12174__Vol Book Daily Market
Sheet: Summary TVA

Daily Option Payoff |  |  |  | 1998 | 1998 |  |  |  | 1999 | 1999 |  |  |  | 2000 | 2000 |  |  |  | 2001 | 2001
 |  |  |  | C | P |  |  |  | C | P |  |  |  | C | P |  |  |  | C | P
35 |  | 2001-01-01 00:00:00
35 |  | 2001-02-01 00:00:00
30 |  | 2001-01-01 00:00:00
30 |  | 2001-02-01 00:00:00
25 |  | 2001-01-01 00:00:00
25 |  | 2001-02-01 00:00:00
20 |  | 2001-01-01 00:00:00
20 |  | 2001-02-01 00:00:00
100 |  | 2001-07-01 00:00:00
100 |  | 2001-08-01 00:00:00
50 |  | 2001-07-01 00:00:00
50 |  | 2001-08-01 00:00:00
40 |  | 2001-07-01 00:00:00
40 |  | 2001-08-01 00:00:00
30 |  | 2001-09-01 00:00:00
25 |  | 2001-09-01 00:00:00
20 |  | 2001-09-01 00:00:00
30 |  | 2001-10-01 00:00:00
30 |  | 2001-11-01 00:00:00
30 |  | 2001-12-01 00:00:00
30 |  | Q4
25 |  | 2001-10-01 00:00:00
25 |  | 2001-11-01 00:00:00
25 |  | 2001-12-01 00:00:00
25 |  | Q4
20 |  | 2001-10-01 00:00:00
20 |  | 2001-11-01 00:00:00
20 |  | 2001-12-01 00:00:00
20 |  | Q4
Cash Market |  |  |  | [NAME] | Gas | Gas | [NAME] |  | [NAME] | Gas | Gas | [NAME] |  | [NAME] | Gas | Gas | [NAME] |  | [NAME] | Gas | Gas | [NAME]
 |  |  |  | Daily | Daily | Heat | over |  | Daily | Daily | Heat | over |  | Daily | Daily | Heat | over |  | Daily | Daily | Heat | over
 |  |  |  | TVA | HH | Rate | Capacity |  | TVA | HH | Rate | Capacity |  | TVA | HH | Rate | Capacity |  | TVA | HH | Rate | Capacity
 |  |  |  | 1998 | 1998 | 1998 | 1998 |  | 1999 | 1999 | 1999 | 1999 |  | 2000 | 2000 | 2000 | 2000 |  | 2001 | 2001 | 2001 | 2001
 |  | Price
 |  | 2001-01-01 00:00:00
 |  | 2001-02-01 00:00:00
 |  | 2001-07-01 00:00:00
 |  | 2001-08-01 00:00:00
 |  | 2001-09-01 00:00:00
 |  | 2001-10-01 00:00:00 | 22 |  |  |  |  | 21 |  |  |  |  | 22
 |  | 2001-11-01 00:00:00 | 19 |  |  |  |  | 20 |  |  |  |  | 21
 |  | 2001-12-01 00:00:00 | 22 |  |  |  |  | 21 |  |  |  |  | 20
 |  | Q4
 |  | Actualized Vol
 |  | 2001-01-01 00:00:00
 |  | 2001-02-01 00:00:00
 |  | 2001-07-01 00:00:00
 |  | 2001-08-01 00:00:00
 |  | 2001-09-01 00:00:00
 |  | 2001-10-01 00:00:00 | 22 |  |  |  |  | 21 |  |  |  |  | 22
 |  | 2001-11-01 00:00:00 | 19 |  |  |  |  | 20 |  |  |  |  | 20
 |  | 2001-12-01 00:00:00 | 22 |  |  |  |  | 21 |  |  |  |  | 20
 |  | Q4
Spreadsheet: sara_shackleton__36501__ENE MTM 0630 revised 2
Sheet: DWR 1305741

Stock Hedge
Warburg Dillon Read - Ref #1305741 |  |  |  | Terminates | 2000-02-23 00:00:00
 |  | Quarter End |  | Quarter End | Quarter End | Quarter End | Quarter End
ENE |  |  |  | 2000-03-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | Year 2000 |  | LTD
 | Market Price
Shares: | 15000
Opening price | 55.9375
Equity Payment (Warburg pays if price goes up/Enron pays if price goes down)
 | Opening value
 | Closing Value
 | MTM
Interest Payment (Enron pays)
Expected quarterly dividend
Spread |  |  |  | 0.0065
Dividend rebate
Interest Rate |  |  |  | 0.0604 | 0.0669 | 0.0669 | 0.0669
Annual Day Count |  |  |  | 360 | 360 | 360 | 360
Beginning of period |  |  |  | 2000-01-21 00:00:00
End of period
Day Count
Annual Factor
All in Rate
Payment
Net receipt/(payment)
 |  |  |  |  |  |  |  |  |  | WDR1305741
Spreadsheet: 74568d1275053390-excel-2007-move-cells-from-right-to-left-in-a-table-test-example
Sheet: Sheet1

original table
 | 2008.01.31 | 2008.02.29 | 2008.03.31 | 2008.04.30 | 2008.05.31 | 2008.06.30
2008-01-01 00:00:00 | 50 | 51 | 52 | 53 | 0 | 55
2008-02-01 00:00:00 | 0 | 60 | 61 | 62 | 63 | 64
2008-03-01 00:00:00 | 0 | 0 | 70 | 71 | 0 | 73
2008-04-01 00:00:00 | 0 | 0 | 0 | 80 | 81 | 82
2008-05-01 00:00:00 | 0 | 0 | 0 | 0 | 90 | 90
2008-06-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 100
result
 | 2008.01.31 | 2008.02.29 | 2008.03.31 | 2008.04.30 | 2008.05.31 | 2008.06.30
2008-01-01 00:00:00 | 50 | 51 | 52 | 53 | 55 | 0
2008-02-01 00:00:00 | 60 | 61 | 62 | 63 | 64 | 0
2008-03-01 00:00:00 | 70 | 71 | 73 | 0 | 0 | 0
2008-04-01 00:00:00 | 80 | 81 | 82 | 0 | 0 | 0
2008-05-01 00:00:00 | 90 | 90 | 0 | 0 | 0 | 0
2008-06-01 00:00:00 | 100 | 0 | 0 | 0 | 0 | 0