tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 25c4d4ca-0f4c-4ab6-90bc-d5a173f29ffc
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
FAPG | Test | FAPG | ADmark ApoE Genotype Analysis & Interpretation (Symptomatic) | ApoE Genotyping | SISAR and RFLP |  |  |  | 10 |  | 10 mL whole blood collected in a lavender top EDTA tube  and sent ambient.   Required:  1.       Collection date is required. 2.       Clinical indications/symptoms for patients under 60 years of age   NOTE:  Athena does not perform ApoE testing for individuals                   under the age of 18. | 10 mL | Specimens other than	Whole blood Anticoagulants other than	EDTA, ACD-A Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | A final report will be faxed under separate cover.   TEST PERFORMED BY ATHENA DIAGNOSTICS                                                   377 PLANTATION ST                                                    FOUR BIOTECH PARK                                                   WORCESTER, MA 01605 | Monday, Friday | 7-14 days | 9-18 days | 1 | 81401 |  |  |  |  | Athena Diagnostics
FAPG | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient | 72 hours
FAPG | Result | Z2274 | ApoE Genotyping | ApoE Genotyping | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 34837d1232181263-excel-comparing-rows-testfile
Sheet: Sheet1

mon | 11 | 13 | 45 | 52 | 65 | 44 |  | 12 | -5 | -13 | -8 | 7 | 16
tues | 23 | 8 | 32 | 44 | 72 | 60
wed | 8 | 12 | 22 | 29 | 74 | 55 |  | 6 | -1 | 14 | -4 | -60 | 14
[NAME] | 14 | 11 | 36 | 25 | 14 | 69
fri | 5 | 4 | 5 | 85 | 41 | 41 |  | -3 | -1 | -3 | -60 | 1 | -6
sat | 2 | 3 | 2 | 25 | 42 | 35
 |  |  |  |  |  |  |  | 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 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 846757d1697902982-test-many-records-against-many-conditions-that-are-in-other-records-test
Sheet: test

id | Wegnaam | hecto | [NAME] | rijder |  | id | [NAME] | [NAME] | van | tm | rijder
1 | A4 | 10.6 | Re |  |  | 1 | A4 | [NAME] | 28.5 | 44.9 | [NAME]
2 | A12 | 33.5 | Re |  |  | 2 | A4 | [NAME] | 45 | 52.4 | [NAME]
3 | A4 | 205 | [NAME] |  |  | 3 | A4 | [NAME] | 52.5 | 56.5 | [NAME]
4 | A12 | 147.4 | Re |  |  | 4 | A4 | [NAME] | 56.6 | 71 | [NAME]
5 | A4 | 43 | [NAME] |  |  | 5 | A4 | [NAME] | 71.1 | 76.3 | [NAME]
6 | A4 | 28.5 | [NAME] |  |  | 6 | A4 | [NAME] | 211 | 232.6 | [NAME]
7 | A15 | 54.5 | [NAME] |  |  | 7 | A4 | [NAME] | 232.7 | 240.8 | [NAME]
8 | A4 | 72.3 | [NAME] |  |  | 8 | A4 | [NAME] | 240.9 | 250.2 | [NAME]
9 | A10 | 23.3 | Re |  |  | 9 | A4 | Re | 0.1 | 2.9 | [NAME]
10 | A4 | 144.7 | Re |  |  | 10 | A4 | Re | 3 | 11.6 | [NAME]
11 | A2 | 175.8 | [NAME] |  |  | 11 | A4 | Re | 11.7 | 30.1 | [NAME]
12 | A4 | 78.3 | Re |  |  | 12 | A4 | Re | 30.2 | 44.7 | [NAME]
13 | A4 | 18.8 | [NAME] |  |  | 13 | A4 | Re | 44.8 | 54.5 | [NAME]
14 | A12 | 112.9 | [NAME] |  |  | 14 | A4 | Re | 54.6 | 70.7 | [NAME]
15 | A7 | 4.4 | [NAME] |  |  | 15 | A4 | Re | 70.8 | 74.7 | [NAME]
16 | A10 | 15.3 | [NAME] |  |  | 16 | A4 | Re | 74.8 | 77.3 | [NAME]
17 | A10 | 8.3 | [NAME] |  |  | 17 | A4 | Re | 211 | 215.3 | [NAME]
18 | A4 | 163.2 | Onbekend |  |  | 18 | A4 | Re | 215.4 | 233.7 | [NAME]
19 | A12 | 130.8 | [NAME] |  |  | 19 | A4 | Re | 233.8 | 241.7 | [NAME]
20 | A4 | 57 | Re
Spreadsheet: 115496d1311091254-multiple-sumif-criteria-within-same-column-multiple-sumif-example-
Sheet: End table

Criteria | MAY-11 | JUN-11 | JUL-11 | AUG-11 | SEP-11
Apple | 0 | 7 | 24.99999999999994 | 20.99999999999951 | -52.1519600000001
Ford |  |  | 0 | 0 | 0
Porsche |  |  | 63.8032666285716 | 74.4371445 | 74.4371445
Mango | 0 | 0 | 117.7714285714266 | 717.72882 | -272
Toyota |  | 0 | 0 | 0
Nissan |  |  | 23.6785723285773 | -3.25000010000001 | -3.2500001
Honda |  |  | 366.642870557143 | -914.50003659999 | -15.5000013000008
Carrot | 0 | 0 | -351.517859221429 | 1047.7500062 | -1.00000079328311e-07
Spreadsheet: 12996263-7983-4f41-85f3-a30a71e586b5
Sheet: Sheet1

2012-13 New York State Conservation Partnership Program | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
BUDGET & STATEMENT OF MATCHING FUNDS
Please write or type directly on this form, use additional sheets necessary
Project Budget Categories* | NYSCPP Funds Requested* | Matching Funds** | Total Project Budget | Source and Status of the Matching Funds (received/ pending)
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
TOTAL | 0 | 0 | 0
*Budget categories may include: consultants/ contractors, project related staff, travel, printing, phone, postage, meetings and facilities, training, equipment, title search, title insurance, survey, appraisal (land trust’s not landowners), legal and filing fees, environmental assessment, baseline documentation and/ or management plan, public access improvements, and contributions to stewardship and/ or easement defense funds (transaction grants)
**Equipment costs, fees for accreditation registration/ application or accreditation renewal and registration fees for Land Trust Alliance trainings and events are NOT covered by grant funds, but may be used as part of the land trusts match
In-kind match contributions must be documented and may include: donation of professional services (legal, facilitation, etc. as well as the donation of travel costs from that individual), or donation of goods (meeting rooms, equipment, printing costs, food or refreshments). Regular board member activities are not considered in-kind match; however, volunteer work (e.g. easement monitoring, trail building, etc.) that otherwise would be a land trust project expense may be included but must be valued using the Independent Sector’s standard benchmark for New York, http://www.independentsector.org/programs/research/volunteer_time.html .
Spreadsheet: 93928d1293696867-vertical-and-horizontal-offset-match-row-and-column-758136_david_brown
Sheet: Date Offset

 | Business Start date |  |  |  | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2nd example, business starts 2018
 |  |  |  |  |  |  |  |  | In this example - the business starts in 2013 (not 2011)
 | Units sold | [000] |  |  |  | 0 | 0 | 0 | 0.2260067602040816 | 1.310702986563727 | 2.790749373605568 | 2.782056969265996 | 2.952614313404107 | 1.192885266521737 | 1.099738158260871 | 0.9317769221739134
 | Business Service Uptake (mid yr)
 |  |  |  |  |  |  | Yr-1 | Yr-2 | [NAME] | Yr-4 | Yr-5 | Yr-6 | [NAME] | Yr-8 | Yr-9 | Yr-10
 | FTTH Brownfield | Build Start Date
 |  | 2011 |  |  |  |  | 0.5 | 0.55 | 0.6
 |  |  |  |  |  |  |  |  |  | 0.45 | 0.45 | 0.47
 |  |  |  |  |  |  |  |  |  |  | 0.4 | 0.4 | 0.45
 | Superfast B'B premises connected - cum
 | FTTH Brownfield | Build Start Date
 |  | 2011
 | Superfast B'B premises connected - cum
Spreadsheet: 221245d1363443407-need-help-comparing-two-tables-and-populating-a-field-in-one-of-them-compare-master-and-servant-table
Sheet: Sheet1

MASTER
Account | Company 1 | Company 2
Asset 1 | ABC1 | CBA1
Asset 1 | [NAME] | FED2
Liability 1 | ABC1 | CBA1
Liability 1 | [NAME] | FED2
Liability 2 | ACB1 | CBA1
Liability 2 | [NAME] | FED2
SERVANT
Account | Company 1 | Company 2
Asset 1 | ABC1
Liability 1 | [NAME]
Liability 2 | [NAME]
Spreadsheet: 717849d1612881704-vlookup-to-look-up-value-based-on-accoun-number-use-vlookup-with-match-for-period
Sheet: Sheet1

6213100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3/2021
6213110
6213115
6213120
6213200
6213210
6213290
6213300
6213801
6213310
6213315
6213350
6213352
6213359
6213400
6213975
6213410
6213415
6213420
Spreadsheet: 730056d1619528857-function-to-coverts-all-specific-numbers-in-a-cell-to-1-and-2-numeric-values-test
Sheet: Sheet1

 | Raw Data | Result |  | Function to convert column B data to results in column C
 | 1241335 | 1221111
 | 3344445 | 1122221
 | 1234555 | 1212111
 | 4443555 | 2221111
 | 3513245 | 1111221
 | Total 7 digits in a cell
 | in given cell function to convert:
 | 1 | remains as 1
 | 2 | remain as 2
 | 3 | converts to1
 | 4 | converts to2
 | 5 | converts to1
 | currently I use Control +  F; replace 3 to replace with  1
 | currently I use Control + F ;replace 4 to replace with 2
 | currently I use Control + F;replace 5 to replace with  1
Spreadsheet: 117157d1312478737-how-to-create-a-number-with-a-tille-tille
Sheet: Dept

 | format I have my numbers in | format I need #s in
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
 | 3010 | 3010
Spreadsheet: larry_campbell__21455__Nomfrm
Sheet: NOMFORM

KED-NY TRANSPORTATION NOMINATION FORM
All Quantities Are In DTH
New York
Marketer/Customer Name: |  |  |  |  |  |  |  |  | Telephone Number:
Acting As Agent for: |  |  |  |  |  |  |  |  | Fax Number:
Contact Name: |  |  |  |  |  |  |  |  | Pager Number:
Date |  |  |  | Time |  |  |  |  |  | Effective
Submitted: | /          /  00 |  |  | Submitted: |  |  |  |  |  | Date of Delivery: |  | /          /  00
 |  |  |  |  |  |  |  |  |  | Check One
 |  |  |  | Contract/ |  | City Gate |  |  |  | Nomination Type |  |  | Service
 | Tetco | Transco | Other* | Activity # |  | Quantity |  |  |  | New | Same | Revised | Class. #
1
2
3
4
5
6
7
Total KED-NY City Gate Deliveries:
KED-NY Nomination Timelines:
Daily: | Transco, Texas Eastern, - 12:30 PM, E.S.T., ONE BUSINESS DAY PRIOR to effective date of delivery.
 | *Iroquois, Tennessee - 10:30 AM, E.S.T., one business day prior to effective date of delivery.
Intra-day: | All Intra-day or Late nominations must be communicated to KED-NY.
Monthly: | ALL PIPELINES - 12:30 PM, E.S.T., ONE BUSINESS DAY PRIOR to FIRST OF MONTH PIPELINE DEADLINES.
PLEASE FAX COMPLETED FORM TO: [NAME], FAX. No.  (718) 643-6306
Weekend Telephone Number:  (718) 403-2922      Weekend Fax Number: (718) 624-1402
Spreadsheet: 159399d1338615076-excel-2007-how-do-i-fetch-data-based-on-conditions-hlookup-example-bvj-
Sheet: Sheet1

 |  |  |  | 2012-06-01 00:00:00 | 2012-06-02 00:00:00 | 2012-06-03 00:00:00 | 2012-06-04 00:00:00 | 2012-06-05 00:00:00 | 2012-06-06 00:00:00 | 2012-06-07 00:00:00 | 2012-06-08 00:00:00 | 2012-06-09 00:00:00 | 2012-06-10 00:00:00 | 2012-06-11 00:00:00 | 2012-06-12 00:00:00
Spreadsheet: 773369d1647829594-vlookup-and-if-functions-example-v2
Sheet: Total Hours

 |  |  | 2021-12-15 00:00:00 | 2021-12-31 00:00:00 | 2022-01-15 00:00:00 | 2022-01-31 00:00:00 | 2022-02-14 00:00:00 | 2022-02-28 00:00:00 | 2022-03-15 00:00:00 | 2022-03-31 00:00:00 | 2022-04-15 00:00:00
1001 | [NAME], [NAME] | Total Hours: | 0 | 5 | 5 | 10 | 5 | 5 | 10
2403 | Doe, [NAME] | Total Hours: | 0 | 10 | 10 | 10 | 10 | 19 | 10 | 0 | 0
2050 | Fisher, Mary | Total Hours:
1920 | [NAME], [NAME] | Total Hours:
 | *[NAME] should pull Row15 from the "By [NAME]"
 | *Doe should be Row30 from the "By Employee" tab
Spreadsheet: 117594d1312902534-remove-unwanted-cells-excel-problem
Sheet: Sheet1

Item Description |  | Notes | Currency 1 | Currency 2 | UOM | Currency 1 | Currency 2
Cat 1
A |  | Hold1 | 249.99 |  | Each | 145.6
B |  | Hold2 | 174.99 |  | Each | 102
Cat 2
A |  | Hold5 | 249.99 |  | Each | 144.6
B |  | Hold6 | 219.99 |  | Each | 127.3
C |  | [NAME] | 169.99 |  | Each | 98.3
Cat 3
A |  | Hold10 | 199.99 |  | Each | 111.1
B |  | Hold11 | 169.99 |  | Each | 94.5
C |  | Hold12 | 139.99 |  | Each | 77.8
Cat 4
A |  | Hold15 | 19.99 |  | Each | 10.82
B |  | [NAME] | 19.99 |  | Each | 10.82
C |  | Hold17 | 1.49 |  | Each | 0.8
Cat 5
A |  | Hold20 | 54.99 |  | Each | 31.88
B |  | Hold21 | 54.99 |  | Each | 31.82
C |  | Hold22 | 9.99 |  | Each | 5.8
Spreadsheet: 108609d1305642495-fining-the-first-2-digits-of-a-6-digit-number-timesheet-1
Sheet: Project

Please Select | --
TMC | 1
Field Master | 2
VRC | 3
Booms | 4
Axles | 5
Chassis | 6
Demount | 7
[NAME] | 8
Cab | 9
Wheels | 10
Machine on Navision | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
Spreadsheet: 799623d1665158873-pull-consonant-f-column-minus-a-column-pull-alpha-and-letter-1-
Sheet: Sheet1

TT | ATAATAS |  |  | 30781 | AAAASTT
TT | TAUPATA |  | s | 28541 | AAAPTTU
TT | TUATARA |  | s | 21481 | AAARTTU
TT | BATTEAU |  | x | 13666 | AABETTU
TT | ACETATE |  | ds | 11347 | AACEETT
TT | ACTUATE |  | ds | 13668 | AACETTU
TT | AGITATE |  | ds | 3514 | AAEGITT
TT | APATITE |  | s | 5977 | AAEIPTT
TT | ARIETTA |  | s | 972 | AAEIRTT
TT | AETATIS |  |  | 2224 | AAEISTT
TT | SATIATE |  | ds | 2225 | AAEISTT
TT | TUATERA |  | s | 4537 | [NAME]
TT | AGITATO |  | r | 6591 | AAGIOTT
TT | TAUTAUG |  | s | 28371 | AAGTTUU
TT | TITANIA |  | s | 7797 | AAIINTT
TT | TUTANIA |  | s | 6921 | [NAME]
TT | AUTOMAT |  | aes | 18052 | AAMOTTU
TT | TATOUAY |  | s | 18055 | AAOTTUY
TT | TUATUAS |  |  | 27033 | AASTTUU
TT | OUTDATE |  | ds | 2249 | ADEOTTU
TT | AILETTE |  | s | 1131 | AEEILTT
TT | TEATIME |  | s | 3593 | AEEIMTT
TT | TAENITE |  | s | 447 | AEEINTT
TT | ARIETTE |  | s | 449 | AEEIRTT
TT | ITERATE | l | ds | 450 | AEEIRTT
TT | AVIETTE |  | s | 3596 | AEEITTV
TT | EVITATE | l | ds | 3597 | AEEITTV
TT | OUTGATE |  | s | 3618 | AEGOTTU
TT | IMITATE |  | ds | 5981 | AEIIMTT
TT | VITIATE |  | ds | 5985 | [NAME]
TT | OATIEST | g |  | 323 | AEIOSTT
TT | OSTIATE |  |  | 324 | AEIOSTT
TT | TOASTIE |  | rs | 325 | AEIOSTT
TT | SITUATE |  | ds | 1772 | AEISTTU
TT | ATTUITE |  | ds | 10152 | AEITTTU
TT | OUTTAKE |  | ns | 10753 | AEKOTTU
TT | TAKEOUT | s | s | 10754 | AEKOTTU
TT | TOLUATE |  | s | 2250 | AELOTTU
TT | OUTRATE |  | ds | 1018 | AEORTTU
TT | OUTEATS |  |  | 2252 | AEOSTTU
TT | NOTITIA |  | es | 2263 | AIINOTT
TT | PITUITA |  | s | 16639 | AIIPTTU
TT | OUTWAIT |  | s | 8881 | AIOTTUW
TT | AUTOPUT |  | s | 25857 | AOPTTUU
TT | BIOTITE |  | s | 6912 | BEIIOTT
TT | ENTETEE |  |  | 19353 | EEEENTT
TT | FOUETTE |  | s | 11597 | EEFOTTU
TT | TOEIEST |  |  | 1552 | EEIOSTT
TT | TOETOES |  |  | 7926 | EEOOSTT
TT | PETITIO |  | ns | 6915 | EIIOPTT
TT | PITUITE |  | s | 13690 | EIIPTTU
TT | TIMEOUT |  | s | 6216 | EIMOTTU
TT | TOOTSIE |  | s | 3506 | EIOOSTT
TT | TOUTIER |  |  | 1044 | EIORTTU
TT | TOUSTIE |  | r | 2261 | EIOSTTU
TT | OUTVOTE |  | drs | 16283 | EOOTTUV
TT | OUTFOOT |  | s | 30363 | FOOOTTU
TT | TUITION |  | s | 7950 | IINOTTU
TT | TOITOIS |  |  | 14179 | IIOOSTT
TT | OUSTITI |  | s | 11898 | IIOSTTU
TT | OUTTOOK |  |  | 31919 | KOOOTTU
TT | OUTROOT |  | s | 24880 | OOORTTU
Spreadsheet: 887664d1737969805-find-and-sort-nearest-date-testing
Sheet: Entry

Date | ID | Member [NAME] | Monthly Contribution | Category | Helper |  | 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 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
2025-01-01 00:00:00 | M001 | Nutan Vishal Bhagare | 500 |  |  | Prev Cash in Hand
2025-01-01 00:00:00 | M002 | Suvarna N Gaikwad | 500 |  |  | Contribution
2025-01-01 00:00:00 | M003 | Rajjaka A Waghmode | 500 |  |  | Intest
2025-01-01 00:00:00 | M004 | Surkekha A Kirgat | 500 |  |  | Late Fee
2025-01-01 00:00:00 | M005 | Kamble | 500 |  |  | Late Intest
2025-01-01 00:00:00 | M006 | [NAME] | 500 |  |  | [NAME]
2025-01-21 00:00:00 | M007 | [NAME] | 500 |  |  | Expencess
2025-01-01 00:00:00 | M008 | Sunita R Madne | 500 |  |  | Total
2025-01-01 00:00:00 | M009 | [NAME] | 500 |  |  | Bank Balance
2025-01-01 00:00:00 | M010 | [NAME] | 500 |  |  | Loan Amount
2025-01-21 00:00:00 | L001 | Nutan Vishal Bhagare | 4282 |  |  | Cash in Hand
2025-01-26 00:00:00 | L001 | Nutan Vishal Bhagare
2025-01-27 00:00:00 | L001 | Nutan Vishal Bhagare
2025-01-01 00:00:00 | Loo1 | Nutan Vishal Bhagare | 200
2025-01-02 00:00:00 | L001 | [NAME]
 | E011
Spreadsheet: 866478d1713385698-looking-for-a-way-to-filter-a-text-variable-kansas-scheduler-v4-6-eba
Sheet: Kitting Schedule

[NAME] from date below↓ | ↓Minimum # of Kits↓ | DO NOT EDIT IN THIS REPORT
2024-04-04 00:00:00 | 25
Client | Job # | # of Stores | # of Pieces | Ship Date | Notes
 | 246061 | 120 | 120 | 2024-04-10 00:00:00 | 0
HALL 246063 [10] | 246063 | 50 | 50 | 2024-04-10 00:00:00 | 0
P&S 246437 [10] | 246437 | ? | 5650 | 2024-04-10 00:00:00 | 0
Spreadsheet: 824054d1680267154-result-without-helper-columns-result-without-helper-columns
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 6 | 5 | 4 | 3 | 2 | 1 |  | ************************ Helper columns*********************************************************************** |  |  |  |  |  |  |  |  | ***************final Result********************************************************************
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test1 |  | 5387651.18 | 196620 | 393240 | 584817.73 | 402001.92 | 737438 | 970968.13 | 3558952.14
Spreadsheet: 774545d1648541063-lock-specific-rows-for-scrolling-but-not-the-first-rows-e-g-rows-8-and-9-scroll-example
Sheet: Sheet1

 |  |  |  |  |  |  | Theese rows I would like to scroll away
 | [NAME] and header
 | Document info1
 | Document info2
 | Document info3
 | Group |  | Cost | Weight | Comment |  | Theese rows I would like to lock in the top when scrolling
 |  | Part | DKK | Kg
 | Subassembly 1 |  |  |  |  |  | Theese rows also scroll
 |  | Part 1
 |  | Part 2
 |  | Part 3
 | Subassembly 2
 |  | Part 4
 |  | Part 5
 |  | Part 6
 | Subassembly 1
 |  | Part 1
 |  | Part 2
 |  | Part 3
 | Subassembly 2
 |  | Part 4
 |  | Part 5
 |  | Part 6
 | Subassembly 1
 |  | Part 1
 |  | Part 2
 |  | Part 3
 | Subassembly 2
 |  | Part 4
 |  | Part 5
 |  | Part 6
 | Subassembly 1
 |  | Part 1
 |  | Part 2
 |  | Part 3
 | Subassembly 2
 |  | Part 4
 |  | Part 5
 |  | Part 6
Spreadsheet: phillip_m_love__30140__200005_OA
Sheet: TX-HPLR-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  HPL
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 201641d1356052450-work-schedule-10hr-shifts-4-on-3-off-rotating-weekends-off-bid-example-4-10s
Sheet: Sheet1

 | 4/10's Example
SHIFT # | SUN | MON | TUE | WED | THU | FRI | SAT
TOTAL SHIFTS | 2 | 4 | 6 | 8 | 6 | 4 | 2
AM | OFF | OFF | 0500-1530 | 0500-1530 | 0500-1530 | 0500-1530 | OFF
AM | 0500-1530 | 0500-1530 | 0500-1530 | 0500-1530 | OFF | OFF | OFF
AM | OFF | 0500-1530 | 0500-1530 | 0500-1530 | 0500-1530 | OFF | OFF
AM | OFF | OFF | OFF | 0500-1530 | 0500-1530 | 0500-1530 | 0500-1530
PM | OFF | OFF | 0630-1700 | 0630-1700 | 0630-1700 | 0630-1700 | OFF
PM | 0630-1700 | 0630-1700 | 0630-1700 | 0630-1700 | OFF | OFF | OFF
PM | OFF | 0630-1700 | 0630-1700 | 0630-1700 | 0630-1700 | OFF | OFF
PM | OFF | OFF | OFF | 0630-1700 | 0630-1700 | 0630-1700 | 0630-1700
OPENS/CLOSES | 1 & 1 | 2 & 2 | 3 & 3 | 4 & 4 | 3 & 3 | 2 & 2 | 1 & 1
Spreadsheet: d1dc4f14-b309-4b3b-bd01-08746a418323
Sheet: Vendor 7

C R I T E R I A | Total Possible Score |  |  |  |  |  |  |  |  |  |  | Average
Qualification Requirements
Understanding the Problem |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Professional Personnel |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Soundness of Approach |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Terms and Conditions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Available Facilities |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Value Added Services |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Evaluation of Costs
Cost Rating
Total Qualification Requirements
Oral Presentation |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Score
Spreadsheet: 71124d1271853404-preventing-duplicate-entries-using-a-data-validation-list-duplicate-wagon-numbers
Sheet: Sheet2

WAGON NUMBERS
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 54430d1254407282-pdf-to-excel-samplefile2
Sheet: Sheet1

 |  |  |  |  | Mark |  |  | Height |  | AVG | Past Grade |  |  |  |  |  | Athlete |  | Car |  |  | [NAME] |  | Team
 |  |  |  |  | Pass (1) | Fail (2) | Score (Return number in column) | Tall (1) | Short (2) | (Return number in column) | A (1) | B (2) | C (3) | D (4) | E (5) | F (6) | Yes (1) | No (2) | Yes (1) | No (2) | Maybe (3) | No (1) | Yes (2) | Leafs (1) | Red Wings (2) | AreaCode (Return number in column)
 |  |  | Ex | Jan | x |  | 5 |  | x | 2 |  |  |  | x |  |  |  | x |  | x |  |  | X | x |  | 701
 |  |  | 1 |  |  | X | 1 | X |  | 3 |  | X |  |  |  |  | X |  | X |  |  | X |  |  |  | 605
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 6
 |  |  | 7