tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 138515d1327691540-pivot-sort-by-two-columns-book1
Sheet: Source

DEPTID | POSITION | PROGRAM | VENDOR_NAME | 092011 | 102011 | 112011 | 122011 | Grand Total
[PHONE] | 00032688 | 11008 | Colon,[NAME] |  | 100.8 |  |  | 100.8
[PHONE] | 00031506 | 11000 | Wilson,[NAME] |  |  | 116.7 |  | 116.7
[PHONE] | 00031507 | 11000 | Forbes,August S. |  | 201.35 | 291.05 | -201.35 | 291.05
[PHONE] | 00065009 | 11008 | [NAME],[NAME] |  | 85.1 | 114.05 | 96.87 | 296.02
[PHONE] | 00062790 | 11000 | Mcmahon,[NAME] |  | 244.3 | 408.88 | -244.3 | 408.88
[PHONE] | 00062818 | 11008 | Riley,[NAME] |  | 477.05 |  |  | 477.05
[PHONE] | 00031506 | 11008 | Wilson,[NAME] |  | 243.2 |  | 251.35 | 494.55
[PHONE] | 00062200 | 11008 | [NAME],[NAME] |  | 146.85 | 161.6 | 264.75 | 573.2
[PHONE] | 00031512 | 11008 | Adams,[NAME] |  | 282.3 | 305.05 |  | 587.35
[PHONE] | 00031507 | 11008 | Forbes,August S. |  |  |  | 618.35 | 618.35
[PHONE] | 00062790 | 11008 | Mcmahon,[NAME] |  | 34.5 |  | 642.5 | 677
[PHONE] | 00062818 | 11006 | Riley,[NAME] |  |  | 697.78 | 411.18 | 1108.96
[PHONE] | 00058845 | 11008 | Espinoza,[NAME] |  |  | 127.3 |  | 127.3
[PHONE] | 00063077 | 11008 | Salas,[NAME] |  | 87.15 |  | 99 | 186.15
[PHONE] | 00064068 | 11008 | Vance,[NAME] |  | 287.25 |  |  | 287.25
[PHONE] | 00065544 | 11008 | [NAME],[NAME] |  | 417.9 |  |  | 417.9
[PHONE] | 00065544 | 11000 | [NAME],[NAME] |  |  | 440.7 |  | 440.7
[PHONE] | 00064068 | 11005 | Vance,[NAME] |  |  |  | 490.8 | 490.8
[PHONE] | 00064068 | 11000 | Vance,[NAME] |  |  | 615.77 |  | 615.77
[PHONE] | 00058851 | 11008 | Allen,Elijah A. |  | 216.9 |  | 453.55 | 670.45
[PHONE] | 00058849 | 11008 | Nicholson,[NAME] |  |  |  | 685 | 685
[PHONE] | 00058850 | 11008 | Beard,[NAME] |  |  | 976.4 | 362.22 | 1338.62
[PHONE] | 00058876 | 11000 | Wagner,[NAME] |  | 301.85 |  | -301.85 | 0
[PHONE] | 00066126 | 11008 | Price,[NAME] |  | 50.8 |  |  | 50.8
[PHONE] | 00066126 | 11000 | Price,[NAME] |  |  |  | 207.15 | 207.15
[PHONE] | 00058872 | 11008 | Mercer,[NAME] |  | 210.75 |  |  | 210.75
[PHONE] | 00064052 | 11005 | [NAME],[NAME] |  |  |  | 377.36 | 377.36
[PHONE] | 00064052 | 11008 | [NAME],[NAME] |  | 517.7 |  |  | 517.7
[PHONE] | 00064052 | 11000 | [NAME],[NAME] |  | 0 | 651.45 |  | 651.45
[PHONE] | 00058876 | 11008 | Wagner,[NAME] |  |  | 351.8 | 646.6 | 998.4
[PHONE] | 00058879 | 11008 | [NAME],[NAME] |  | 326.35 | 371.35 | 369.25 | 1066.95
[PHONE] | 00031576 | 11000 | Lyons,Coleman O. | 36.2 | 42.55 |  | -78.75 | 0
[PHONE] | 00063075 | 11000 | Mcguire,[NAME] |  | 421.1 |  | -421.1 | 0
[PHONE] | 00031580 | 11008 | Clements,[NAME] |  |  | 89.95 |  | 89.95
[PHONE] | 00036828 | 11008 | [NAME],[NAME] |  |  | 107.7 |  | 107.7
[PHONE] | 00065880 | 11008 | [NAME],[NAME] |  |  | 19.2 | 135.75 | 154.95
[PHONE] | 00031576 | 11008 | Lyons,Coleman O. |  | 315.45 |  | 78.75 | 394.2
[PHONE] | 00031581 | 11008 | [NAME],[NAME] |  |  | 424.25 |  | 424.25
[PHONE] | 00031581 | 11000 | [NAME],[NAME] |  |  | 438.5 |  | 438.5
[PHONE] | 00063075 | 11008 | Mcguire,[NAME] |  |  | 383.9 | 421.1 | 805
Spreadsheet: 190428d1351642511-dividing-two-numbers-in-the-same-cell-example
Sheet: Sheet1

PLAYER | FGM-FGA
A.J. Price | 59-174
[NAME] | 83-161
[NAME] | 345-773 |  |  | a.j.price | 0
[NAME] | 57-103
[NAME] | 516-1048 |  |  |  | how can I get aj price 59-174 in F4 ?
[NAME] | 55-142
[NAME] | 153-357
[NAME] | 150-365
Spreadsheet: 159788d1338843035-excel-2007-i-need-a-formula-to-calculate-six-months-at-a-time-from-separate-sheet-tabs-hr-calendar-with-formulas
Sheet: Jan

 |  |  |  |  |  |  |  |  |  |  | SELECT YEAR:
 |  |  |  |  |  |  |  |  |  |  |  | 2012
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY |  | 1. Absent - EX  2. Absent - UN  3. Bereavement  4. Discipline  5. FMLA  6. Tardy
 |  |  | Bryant 1 |  |  | Franklin 6
 |  |  |  | Collins 2
 |  |  | Franklin 6 |  |  | Franklin 6
 |  |  | NOTES:
 |  |  | Type in Employee's Last Name and the Corresponding Number
Spreadsheet: chris_germany__1791__Exhibit1
Sheet: Storage

VIRGINIA NATURAL GAS
INTERSTATE PIPELINE CAPACITY CONTRACTS
STORAGE SERVICES
PIPELINE |  | SERVICE | MDQ | MDWQ | Contract | [NAME]. | Delivery Pt | Expiration | Comments
 |  |  | dth/day | dth |  |  |  | Date
CNGT |  | GSS | 789000 | 15148 | 300008 | CNG STRG | [NAME] | 2012-03-31 00:00:00 | Total VNG Storage on contract 300008 is 2,791,000
 |  | GSS | 1040000 | 20000 | 300008 | CNG STRG | [NAME] | 2015-03-31 00:00:00 | MSQ can be reduced on the expiration dates listed.
 |  | GSS | 702000 | 13500 | 300008 | CNG STRG | [NAME] | 2016-03-31 00:00:00
 |  | GSS | 260000 | 5000 | 300008 | CNG STRG | [NAME] | 2017-03-31 00:00:00
 |  | GSS | 761250 | 15225 | 300107 | CNG STRG | [NAME] | 2015-03-31 00:00:00
COLUMBIA GAS |  | FSS | 2848655 | 49030 | 53004 | STRG | VNG City Gate | 2004-10-31 00:00:00 | Combined in Navigator under Contract 38079
 |  | FSS | 731250 | 14625 | 60537 | STRG | VNG City Gate | 2014-10-31 00:00:00 | Combined in Navigator under Contract 38079
TRANSCO |  | GSS | 98790 | 2070 | 0.3768 | STRG | Emporia | 2013-03-31 00:00:00 | On 7/1/01 contract reduced to MSQ=54,364, MDWQ=1,087
 |  | ESS | 90254 | 8970 | 6558 | STRG | Zone 4 |  | Storage under agency control of WESCO as part of FS deal
 |  | WSS | 724500 | 8523 | 3767 | STRG | Station 54 | 1998-03-31 00:00:00
Spreadsheet: 94507d1294309702-excel-2007-excel-experts-plz-i-need-help-project-data-4
Sheet: Accounting

 |  |  |  | ID | 900012394
 |  |  | Accounting
 |  |  |  | Course | Grade |  | Course | Grade |  |  |  | Course | Grade |  | Course | Grade
 |  |  |  | WRI101 |  |  | ENG204 |  |  |  |  | ENG208 |  |  | ACC305
 |  |  | 1st semester | BIS101 |  | 3rd semester | ACC201 |  |  |  | 5th semester | BLW301 |  | 7th semester | ACC410
 |  |  |  | MTH101 |  |  | ECO201 |  |  |  |  | QBA202 |  |  | MJEXXX
 |  |  |  | HUMXXX |  |  | QBA201 |  |  |  |  | ACC301 |  |  | FREEXXX
 |  |  |  | SCIXXX |  |  | MGT201 |  |  |  |  | FREEXXX |  |  | FREEXXX
 |  |  |  |  | Grade |  |  | Grade |  |  |  | Course | Grade |  | Course | Grade
 |  |  |  | WRI102 |  |  | ECO202 |  |  |  |  | [NAME] |  |  | MGT406
 |  |  | 2nd semester | ARAXXX |  | 4th semester | ACC202 |  |  |  | 6th semester | ACC302 |  | 8th semester | ACC406
 |  |  |  | MTH102 |  |  | FIN201 |  |  |  |  | HSSXXX |  |  | MJEXXX
 |  |  |  | SCIXXX |  |  | MKT201 |  |  |  |  | MGT360 |  |  | FREEXXX
 |  |  |  | HUMXXX |  |  | MIS201 |  |  |  |  | ACC303 |  |  | FREEXXX
 |  |  |  |  |  |  |  |  |  |  |  | FREEXXX
Spreadsheet: 83124d1283181662-check-for-xx-yy-point-inside-outside-graphic-area-743629-point-in-polygon
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | [NAME] |  | Mark2 |  | [NAME] |  | Mark4
 |  |  |  |  |  |  |  |  | x | y | x | y | x | y | x | y
 |  |  |  |  |  | Random Points |  |  | 0.1876368781743887 | 0.9500340057334906 | 0.2841191437429418 | 0.48484580802273 | 0.8910035863899475 | 0.03572188151073341 | 0.2484249545352146 | 0.754778945891128
 | min | [NAME] | min | [NAME] |  | x | y
 | 0 | 0.25 | 0 | 0.25 |  | 0.1754577492718636 | 0.07365731455757984 |  |  | 0.02170342113232138 |  | 0.1024610596749479 |  | 0.6409224005318022 |  | 0.07378843606269732
 | 0 | 0.25 | 0.5 | 1 |  | 0.1631496947195485 | 0.9700210115283476 |  |  | 0.007372831198990799 |  | 0.1804123269041785 |  | 0.3459134090515236 |  | 0.07994157098380653
 | 0.5 | 1 | 0.5 | 1 |  | 0.5357580547730683 | 0.9669788383544319 |  |  | 0.3184331067603935 |  | 0.2930512566141962 |  | -0.1980304946485982 |  | 0.2893508642336604
 | 0.5 | 1 | 0 | 0.5 |  | 0.6695618475785667 | 0.05877260115749472 |  |  | 0.4332025976136621 |  | 0.2047873135120453 |  | -0.008093358229359691 |  | 0.3376310854252036
 |  |  |  |  | Duplicate first point >> | 0.1754577492718636 | 0.07365731455757984
 |  |  |  |  |  |  |  |  | Inside? | 1 |  | 1 |  | 0 |  | 1 | << Using formulas
 |  |  |  |  |  |  |  |  | Inside? | 1 |  | 1 |  | 0 |  | 1 | << Using UDF
Spreadsheet: 220061d1363044793-indexing-return-value-from-a-certain-row-and-column-testdataset
Sheet: test1

 | Blended AHT Dish |  |  |  | CET/QA Dish |  |  |  | CSAT Dish |  |  |  | Reliability |  |  |  | Sales Conversion % Dish |  |  |  | Sched Adherence % |  |  |  | Tech Portal Dish
NAME | Metric Value | Percent to Target | [NAME] | Metric Score | Metric Value | Percent to Target | [NAME] | Metric Score | Metric Value | Percent to Target | [NAME] | Metric Score | Metric Value | Percent to Target | [NAME] | Metric Score | Metric Value | Percent to Target | [NAME] | Metric Score | Metric Value | Percent to Target | [NAME] | Metric Score | Metric Value | Percent to Target | [NAME] | Metric Score
[NAME], Alejandro |  | 0 | 0 | 0.1932 | 0 | 0 | 0 | 0.2252 | 0 | 0 | 0 | 0.2143 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2522 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Campos, Efrain | 0 | 0 | 0 | 0.2395 | 0 | 0 | 0 | 0.2391 | 0 | 0 | 0 | 0.2543 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2822 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME], [NAME] | 0 | 0 | 0 | 0.2414 | 0 | 0 | 0 | 0.2333 | 0 | 0 | 0 | 0.1964 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1739 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME], [NAME] | 0 | 0 | 0 | 0.2364 | 0 | 0 | 0 | 0.2229 | 0 | 0 | 0 | 0.1875 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2189 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME], [NAME] | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Galarza, [NAME] | 0 | 0 | 0 | 0.2339 | 0 | 0 | 0 | 0.2284 | 0 | 0 | 0 | 0.2143 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.3886 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME], [NAME] | 0 | 0 | 0 | 0.2354 | 0 | 0 | 0 | 0.2306 | 0 | 0 | 0 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.3657 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Gutierrez, [NAME] | 0 | 0 | 0 | 0.2231 | 0 | 0 | 0 | 0.2322 | 0 | 0 | 0 | 0.2857 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1643 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Gutierrez, [NAME] | 0 | 0 | 0 | 0.2366 | 0 | 0 | 0 | 0.2039 | 0 | 0 | 0 | 0.2245 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2268 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hernandez, Adan | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Posadas, [NAME] | 0 | 0 | 0 | 0.2369 | 0 | 0 | 0 | 0.2331 | 0 | 0 | 0 | 0.199 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2647 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ramos, Erick | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Viurquiz, [NAME] | 0 | 0 | 0 | 0.2894 | 0 | 0 | 0 | 0.2408 | 0 | 0 | 0 | 0.2143 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2689 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Help!
Spreadsheet: 462702d1464158348-consolidating-data-from-a-table-to-a-graph-confidential_ssp_calibration-data-rg1-rg2
Sheet: List View

 | Name | Business Unit | Department | [NAME] | Location | Role Group | User Name | Overall Form Rating | Overall Potential Rating
 |  |  |  |  |  |  | User A | 1 | 1
 |  |  |  |  |  |  | User B | 1 | 2
 |  |  |  |  |  |  | User C | 1 | 3
 |  |  |  |  |  |  | User D | 2 | 1
 |  |  |  |  |  |  | User F | 2 | 2
 |  |  |  |  |  |  | User G | 2 | 3
 |  |  |  |  |  |  | User H | 3 | 1
 |  |  |  |  |  |  | User I | 3 | 2
 |  |  |  |  |  |  | User J | 3 | 3
Legend
Gender
M | Male
F | Female
 |  |  |  | Overall Potential Rating | 3.0 High - High Potential
 |  |  |  |  | 2.0 Medium - Clear Potential
 |  |  |  |  | 1.0 Low - Well Placed
 |  |  |  |  |  | 1.0 Low (Talent Cycle) |  | 2.0 Medium (Talent Cycle) |  | 3.0 High (Talent Cycle)
 |  |  |  |  | Overall Form Rating
Spreadsheet: 128636d1321129929-vlookup-in-different-coumns-hooves-world-racing-syndicate-updated
Sheet: LEADERBOARD

POS | MEMBERS |  |  |  | TOTAL
1 | [NAME]
2 | [NAME]
3 | [NAME]
4 | Anne-Rita le Riche
5 | [NAME]
6 | [NAME]
7 | [NAME]
8 | [NAME]
9 | [NAME]
10 | Carola Larsson
11 | [NAME]
12 | Chezza Goodgirl
13 | [NAME]
14 | [NAME]
15 | [NAME]
16 | [NAME]
17 | [NAME]
18 | [NAME]
19 | Dante Love Dancel Lara
20 | [NAME]
21 | [NAME]
22 | Deb Mclean
23 | [NAME]
24 | Doreen Laws Hart
25 | [NAME]
26 | [NAME]
27 | [NAME]
28 | [NAME]
29 | [NAME]
30 | [NAME]
31 | [NAME]
32 | J T Patryck Voie
33 | [NAME]
34 | [NAME]
35 | Jane-Marie Nash
36 | [NAME]
37 | [NAME]
38 | [NAME]
39 | Jen Rayoso
40 | [NAME]
41 | [NAME]
42 | [NAME]
43 | [NAME]
44 | [NAME]
45 | [NAME]
46 | [NAME]
47 | [NAME]
48 | [NAME]
49 | [NAME]
50 | [NAME]
51 | [NAME]
52 | [NAME]
53 | [NAME]
54 | [NAME]
55 | [NAME] [NAME]
56 | [NAME]
57 | [NAME]
58 | [NAME]
59 | [NAME] Condely
60 | [NAME]
61 | [NAME]
62 | [NAME]
63 | [NAME]
64 | [NAME]
Spreadsheet: 739861d1626014002-correction-needed-for-outbound-quantity-example_avg_cost-warehouse-approach-v3-
Sheet: Version6

Limits: |  |  |  |  | TRANSACTION
 |  |  |  |  |  |  |  |  | SOLD |  |  |  | OUTSTANDING |  |  | P/L
Trade Symbol | Transaction | Date | Sale Portion | [NAME] | Quantity | Price | Fees | Amount | S# | Quantity | Price | Amount | Quantity | Price | Amount | Gain(+) /     Loss(-) | Gain(+) /     Loss(-) per Sales Only |  |  |  | Total Cost | Needed for correct cumulative average cost value |  | Cumulative Units | Cumulative Average Cost | Current Balance (FIFO) | Sales Only -  Separated for RAW data |  | Gain (Loss) P & L | Notes
 | Purchase | 2021-02-22 00:00:00 |  |  | 3.514923 | 14.21 | 0 |  | S1
 | Purchase |  |  |  | 1.95554 | 12.8 | 0 |  | S1
 | Purchase | 2021-02-23 00:00:00 |  |  | 2.121327 | 11.78 | 0 |  | S1
 | Purchase | 2021-03-24 00:00:00 |  |  | 374.242645 | 13.45 | 0 |  | S1
 | Sale | 2021-03-29 00:00:00 | All | Short | -381.834442 | 13.34 | 0 |  | S1
 | Purchase | 2021-04-17 00:00:00 |  |  | 13.380624 | 37.72 | 0 |  | S2
 | Purchase |  |  |  | 12.706329 | 39.39 | 0 |  | S2
 | Purchase | 2021-04-27 00:00:00 |  |  | 28.600846 | 35.18 | 0 |  | S2
 | Purchase | 2021-05-04 00:00:00 |  |  | 74.626678 | 67.52 | 0 |  | S2
 | Purchase |  |  |  | 270.208195 | 74.56 | 0 |  | S2
 | Sale | 2021-05-04 00:00:00 | All | Short | -399.522672 | 78.52 | 0 |  | S2
 | Purchase | 2021-05-04 00:00:00 |  |  | 179.734944 | 84.04 | 0 |  | S3
 | Purchase | 2021-05-05 00:00:00 |  |  | 49.622456 | 101.4 | 0 |  | S3
 | Purchase |  |  |  | 246.20782 | 102.55 | 0 |  | S3
 | Purchase |  |  |  | 165.37101 | 103.4 | 0 |  | S3
 | Sale | 2021-05-05 00:00:00 | All | Short | -640.93623 | 104.18 | 0 |  | S3
 | Purchase | 2021-05-05 00:00:00 |  |  | 30.301633 | 99.03 | 0 |  | [NAME]
 | Purchase | 2021-05-06 00:00:00 |  |  | 276.819944 | 145.41 | 0 |  | [NAME]
 | Sale | 2021-05-06 00:00:00 | All | Short | -307.121577 | 168.49 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 277.1079 | 182.23 | 0 |  | S5
 | Purchase |  |  |  | 138.149505 | 182.77 | 0 |  | S6
 | Sale | 2021-05-08 00:00:00 | Partial | Short | -107.381606 | 127.43 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Should be a negative number … here is where things get complicated…
 | Sale | 2021-06-30 00:00:00 | Partial | Short | -100 | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | How do we get Q26 to show a value that represents a portion of the loss based on the fact that this partial sale was done to minimize some of the losses when the price dropped $55 per share? That value should equate to somewhere around $5000.00
 |  |  |  | SUMMARY |  | Avg price |  |  |  | [NAME]
 |  |  |  | Purchase
 |  |  |  | Sale
 |  |  |  | Diff |  |  |  |  |  |  |  |  |  |  |  | In which,
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gain
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loss
Spreadsheet: mark_whitt__25242__Huber - Existing & Proposed Deals 111201
Sheet: Summary

Existing Deals with Huber
Start | End | Volume (MMBtu/d) | Delivery Point | Contract Price | 55 days payables*
2001-12-01 00:00:00 | 2006-09-30 00:00:00 | 5000 | [NAME] | IF NGPL MidContinent index | 994232
2001-12-01 00:00:00 | 2006-09-30 00:00:00 | 5000 | Lakin | IF PEPL index | 1002482
2002-06-01 00:00:00 | 2013-05-31 00:00:00 | 42000 | Gage | IF NGPL MidContinent Index minus $0.01 | 8328453
The current mark-to-market position of the existing deals is $11.3 MM
Proposed Deals with Huber
Start | End | Volume (MMBtu/d) | Delivery Point | Contract Price | 55 days payables*
2001-12-01 00:00:00 | 2002-05-31 00:00:00 | 45000 | Glenrock | IF CIG Rocky Mtns. index minus $0.03 | 6080660
2001-12-01 00:00:00 | 2006-05-31 00:00:00 | 20000 | PG&E Topock | Gas Daily PG&E Topock index minus $0.02 | 4291022
2001-12-01 00:00:00 | 2002-05-31 00:00:00 | 10000 | [NAME] | Gas Daily El Paso-San Juan index minus $0.10 | 1440313
2001-12-01 00:00:00 | 2002-05-31 00:00:00 | 10000 | [NAME] | Gas Daily NWPL Wyoming Pool index minus $0.10 | 1349922
* The "55 days payable" value above is calculated as 55 days times the Daily Volume times the average forward curve price (curve date = Nov 9, 2001)
Spreadsheet: 210455d1359468461-multiplying-column-header-with-the-row-items-trial
Sheet: Rowitems

SKuID | ItemName | Customer | Rate
11682 | Item 1 | Cust 1 | 312.56
11682 | Item 1 | Cust 2 | 411.27
11682 | Item 1 | Cust 3 | 411.27
11682 | Item 1 | Cust 4 | 411.27
11682 | Item 1 | Cust 5 | 329.02
11682 | Item 1 | Cust 6 | 296.11
11682 | Item 1 | Cust 7 | 267.33
11682 | Item 1 | Cust 8 | 246.76
11682 | Item 1 | Cust 9 | 226.2
11682 | Item 1 | Cust 10 | 226.2
11683 | Item 2 | Cust 1 | 304.34
11683 | Item 2 | Cust 2 | 427.72
11683 | Item 2 | Cust 3 | 427.72
11683 | Item 2 | Cust 4 | 427.72
11683 | Item 2 | Cust 5 | 342.18
11683 | Item 2 | Cust 6 | 307.96
11683 | Item 2 | Cust 7 | 278.02
11683 | Item 2 | Cust 8 | 256.63
11683 | Item 2 | Cust 9 | 235.25
11683 | Item 2 | Cust 10 | 235.25
Spreadsheet: 269908d1381323902-creating-a-list-without-duplicates-from-data-on-another-sheet-behavior-data-entry-sheet
Sheet: Weekly Summary

 | Weekly Totals |  |  |  |  | Weekly Totals
 | Weekly Totals |  |  |  |  | Weekly Totals
 | Weekly Totals |  |  |  |  | Weekly Totals
 | Weekly Totals |  |  |  |  | Weekly Totals
 | Weekly Totals |  |  |  |  | Weekly Totals
 | Weekly Totals |  |  |  |  | Weekly Totals
 | Weekly Totals |  |  |  |  | Weekly Totals
 | Weekly Totals |  |  |  |  | Weekly Totals |  |  |  |  | Weekly Totals
 | Weekly Totals |  |  |  |  | Weekly Totals
Spreadsheet: 42147d1240703304-if-cell-x-0-then-copy-range-of-cells-test-book111
Sheet: job sheet

 |  | mr smith |  |  |  |  |  |  |  | Ref no
 |  | a company |  |  |  |  |  |  |  | Ref no 2
 |  | 11 brookbond st |  |  |  |  |  |  |  | Quotation by
 |  | town |  |  |  |  |  |  |  | Date
 |  | district
 |  | wt3 8hy
 |  | Site Address |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Site Contact |  | 0 |  | [NAME] | 0
 |  | Treatment for |  | Rats
 |  | Total No Of Visits |  | 1
 |  | Quoitaion Type |  | One Of Treatment
 |  |  |  |  |  |  | Job details
 |  |  |  |  |  |  |  |  |  | Materials | 23.2
 |  |  |  |  |  |  |  |  |  | Labour | 43.2
 |  |  |  |  |  |  |  |  |  | VAT@15% | 6.48
 |  |  |  |  |  |  |  |  |  | Total | 49.68000000000001
 |  | Surveyor |  |  |  |  | Signature
 |  | Authorisation |  |  |  |  | Signature
Spreadsheet: 12a6418b-e4c1-4ccf-b318-05f94d849dae
Sheet: Sheet1

2014-15 GRADUATE RESEARCH GRANT PROGRAM |  |  |  |  |  |  | # | IPSSP USE
Shippensburg University of Pennsylvania
This worksheet is designed to assist you in preparing your proposal budget. Work with your faculty mentor to identify reasonable costs. Enter your information in the “green” shaded cells. The spreadsheet includes formulas which will auto-calculate totals for you. If you prefer, you may create your own worksheet. If you do so, you are expected to use the same budget categories and to use the same layout as provided on this template. Call IPSSP for questions and/or technical assistance: [PHONE].
Project Title:
Student Name:
Student ID #:
Proposed Budget
 |  |  |  |  |  | $/unit | # units | $
Supplies | Item | Example |  |  |  | 25 | 3
Use these lines for consumable supplies* and materials you will need for your project.  DO NOT request funding for electronic equipment and/or digital devices already available through the University. DO include shipping costs. | Item 1 | description
 | Item 2 | description
 | Item 3 | description
 | Item 4 | description
 | Item 5 | description
 | Item 6 | description
 | Item 7 | description
 |  |  |  |  |  |  | TOTAL SUPPLIES
 |  |  |  |  |  |  |  | $
Printing/Posters | Item 1 | description
 | Item 2 | description
 | Item 3 | description
 |  |  |  |  |  |  | TOTAL PRINTING
Travel | Dates of Travel: |  |  |  |  | Field Work | Conference | $
Be sure to place your travel estimates in the appropriate column:   field work OR conference expense. | Conference registration
 | Air fare
 | Automobile (miles X $0.56 per mile)
 | Tolls
 | Parking
 | Hotel
 | Meals ([NAME] = $25/day; itemized receipts required)
 | Other
 |  |  | TOTAL TRAVEL
 |  |  |  |  |  |  |  | $
Other | description
Use this category for expenses that do not fit categories above. | description
 |  |  |  |  |  |  | TOTAL OTHER
 |  |  |  |  |  |  | Total
 |  |  |  |  |  |  | Request
*Consumable supplies are those which will be used-up or spent during your project. (Durable equipment items – including electronics and digital devices – will not be funded unless they are unavailable through the University. Such items must be retained by the University upon project completion.)
Spreadsheet: 872755d1719179388-returning-partial-match-when-comparing-two-columns-of-project-names-text-phrases-20240623_excel-forum-ask
Sheet: Excel Forum

Project Name List 1 | Project Name List 2 | Expected Results |  |  | Words to ideally exclude from partial match test. Ideally not case sensitive.
Air Liquide CurtHyl Hydrogen Production Electrolysis Project Phase I | Air Liquide SA Hyper1 green Hydrogen project | partial match from B2 in: A2:A12 because the word "Hydrogen" appears |  |  | hydrogen
Air Liquide ELYgator Hydrogen Production Electrolysis PEM Project | Air Liquide SA [NAME] Green Hydrogen Project | partial match from B3 in: A2:A12 because the word "Hydrogen" appears |  |  | green
Air Liquide Trailblazer Hydrogen Production Electrolysis Project Phase I | Siemens Energy AG,Air Liquide SA | partial match from B4 in,A2, A3, A4 due to words "Air" and "Liquide" |  |  | hub
Cemex Concrete Chemicals Hydrogen Production Electrolysis Project Phase I | Enertrag AG,[NAME] | partial match from B5 in A5 due to [NAME], and A10 due to Enertrag |  |  | project
E.ON H2.Ruhr Hydrogen Production Electrolysis Project | SAP AG,E.ON SE,[NAME],Iberdrola SA,ABB Ltd | partial match from [NAME] in A6 and A7 due to [NAME] (might be difficult in this case as there is no " " separator. |  |  | electrolysis
E.ON SmartQuart Hydrogen Production Electrolysis Project | [NAME],OFB Projektentwicklung GmbH,[NAME],Viessmann Group,Hydrogenious LOHC Technologies GmbH,Cisco Systems Holding GmbH,RWE Power AG,Siemens AG
East Energy Finsterwalde Hydrogen Production Electrolysis Project | East Energy GmbH,Stadtwerke Finsterwalde GmbH
[NAME] | [NAME],VNG Gasspeicher GmbH
Enertag RefLau Hydrogen Production Stadtwerke Electrolysis Project Phase I | [NAME],Enertrag AG,[NAME]
Equinor GreenHyScale Hydrogen Production Electrolysis Project Phase I | Equinor ASA
European Energy Kasso Hydrogen Production Electrolysis Project | Green Hydrogen Example Project Proect Phase 1
Spreadsheet: 25dfb40e-41b4-4e1e-b07e-87dadf91dc9a
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2
Jugendfeuerwehr
[NAME]
2011/2012
 | Gruppe A
 | Platz | Jugendfeuerwehr
 | 1 | Beckeln A1
 | 2 | Beckeln A2
 | 3 | Pri-Ho-Kle-He A2
 | 4 | [NAME]
 | 5 | [NAME] und [NAME]
 | 6 | [NAME]
 | 7 | Schierbrok-Schönemoor A1
 | 8 | OL-Eversten A1
 | 9 | [NAME]
 | 10 | [NAME]
 | Gruppe B
 | 1 | Neerstedt B1
 | 2 | Beckeln B5
 | 3 | Beckeln B4
 | 4 | Neerstedt B2
 | 5 | Harpstedt
 | 6 | PriHoKleHe
 | 7 | Kirch-und [NAME]
 | 8 | Wardenburg
 | 9 | Ganderkesee
 | 10 | Ol-Ofenerdiek
 | 11 | Altenesch
 | 12 | Bookholzberg
 | 13 | Colnrade
 | 14 | Sandhatten
 | 15 | [NAME]
 | 16 | Sandkrug