tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 329056d1404187901-trying-to-get-a-lookup-function-to-retrieve-multiple-results-proving-hard-pokemon2
Sheet: Type Chart

Types | Normal | Fighting | Flying | Poison | Ground | Rock | Bug | Ghost | Steel | Fire | Water | Grass | Electric | Psychic | Ice | Dragon | Dark | Fairy |  | 2
Normal | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 0 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Fighting | 2 | 1 | 0.5 | 0.5 | 1 | 2 | 0.5 | 0 | 2 | 1 | 1 | 1 | 1 | 0.5 | 2 | 1 | 2 | 0.5
Flying | 1 | 2 | 1 | 1 | 1 | 0.5 | 2 | 1 | 0.5 | 1 | 1 | 2 | 0.5 | 1 | 1 | 1 | 1 | 1
Poison | 1 | 1 | 1 | 0.5 | 0.5 | 0.5 | 1 | 0.5 | 0 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 2
Ground | 1 | 1 | 0 | 2 | 1 | 2 | 0.5 | 1 | 2 | 2 | 1 | 0.5 | 2 | 1 | 1 | 1 | 1 | 1
Rock | 1 | 0.5 | 2 | 1 | 0.5 | 1 | 2 | 1 | 0.5 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1
Bug | 1 | 0.5 | 0.5 | 0.5 | 1 | 1 | 1 | 0.5 | 0.5 | 0.5 | 1 | 2 | 1 | 2 | 1 | 1 | 2 | 0.5
Ghost | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 0.5 | 1
Steel | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 0.5 | 0.5 | 0.5 | 1 | 0.5 | 1 | 2 | 1 | 1 | 2
Fire | 1 | 1 | 1 | 1 | 1 | 0.5 | 2 | 1 | 2 | 0.5 | 0.5 | 2 | 1 | 1 | 2 | 0.5 | 1 | 1
Water | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 1 | 2 | 0.5 | 0.5 | 1 | 1 | 1 | 0.5 | 1 | 1
Grass | 1 | 1 | 0.5 | 0.5 | 2 | 2 | 0.5 | 1 | 0.5 | 0.5 | 2 | 0.5 | 1 | 1 | 1 | 0.5 | 1 | 1
Electric | 1 | 1 | 2 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 2 | 0.5 | 0.5 | 1 | 1 | 0.5 | 1 | 1
Psychic | 1 | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 0 | 1
Ice | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 1 | 0.5 | 0.5 | 0.5 | 2 | 1 | 1 | 0.5 | 2 | 1 | 1
Dragon | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 0
Dark | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 0.5 | 0.5
Fairy | 1 | 2 | 1 | 0.5 | 1 | 1 | 1 | 1 | 0.5 | 0.5 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1
Spreadsheet: daren_farmer__5666__Texas_Desk_Wellhead_Supply_January_2001_01_08
Sheet: Texoma

Texoma |  |  | PGE Texoma (Mtr 71) |  |  | Paramaters (North) |  |  | Carthage
Carthage |  |  | North Central | 15000 |  | Short | -10000 |  | Avail to Trans | 0
NNGB | 71650 |  | [NAME] | 0 |  | Long | 70000
Zone 8 | -97518 |  | [NAME] | 0
[NAME] | 0 |  | PGE | 0
24x5 | 0 |  | Carthage
Same waha | 0 |  | [NAME] | 0
Waha | 0 |  | [NAME] | -15000
HSC East Roll-off |  |  | Transport | 0
HSC East New |  |  | Spot | 0
 |  |  | Waha
Zone Balance
South Zone
Roll-Off | 0
New | 0
South Balance |  |  | Monday Changes
 |  |  | [NAME] | 0
 |  |  | Spot | 0
North Balance
 |  |  | Monday Bal
Texoma Summary
Need to Buy
Need to Sell
Carthage to Sell
Spreadsheet: 127447d1320349179-pivot-table-report-help-test-7-ccm-reporting-sumproduct
Sheet: Overall Reporting

Reporting by quarters, broken down by periods
Fiscal Quarter | Period | Start Date | End Date | Yes [NAME] | No | Site | Total Encounters
Q 1 | P 1 | April 1,2011 | April 28,2011 |  |  | A
Q 1 | P 2 | 2011-04-29 00:00:00 | 2011-05-26 00:00:00 |  |  | A
Q 1 | P 3 | 2011-05-27 00:00:00 | June 23,2011 |  |  | A
Q 1 | P 1 | 2011-04-01 00:00:00 | April 28,2011 |  |  | B
Q 1 | P 2 | 2011-04-29 00:00:00 | 2011-05-26 00:00:00 |  |  | B
Q 1 | P 3 | 2011-05-27 00:00:00 | June 23,2011 |  |  | B
Q 1 | P 1 | 2011-04-01 00:00:00 | April 28,2011 |  |  | C
Q 1 | P 2 | 2011-04-29 00:00:00 | 2011-05-26 00:00:00 |  |  | C
Q 1 | P 3 | 2011-05-27 00:00:00 | June 23,2011 |  |  | C
Q 2 | P 4 | 2011-06-24 00:00:00 | 2011-07-21 00:00:00 |  |  | A
Q 2 | P 5 | 2011-07-22 00:00:00 | 2011-08-18 00:00:00 |  |  | A
Q 2 | P 6 | 2011-08-19 00:00:00 | 2011-09-15 00:00:00 |  |  | A
Q 2 | P 4 | 2011-06-24 00:00:00 | 2011-07-21 00:00:00 |  |  | B
Q 2 | P 5 | 2011-07-22 00:00:00 | 2011-08-18 00:00:00 |  |  | B
Q 2 | P 6 | 2011-08-19 00:00:00 | 2011-09-15 00:00:00 |  |  | B
Q 2 | P 4 | 2011-06-24 00:00:00 | 2011-07-21 00:00:00 |  |  | C
Q 2 | P 5 | 2011-07-22 00:00:00 | 2011-08-18 00:00:00 |  |  | C
Q 2 | P 6 | 2011-08-19 00:00:00 | 2011-09-15 00:00:00 |  |  | C
Q 3 | P 7 | 2011-09-16 00:00:00 | 2011-10-13 00:00:00 |  |  | A
Q 3 | P 8 | 2011-10-14 00:00:00 | 2011-11-10 00:00:00 |  |  | A
Q 3 | P 9 | 2011-11-11 00:00:00 | 2011-12-08 00:00:00 |  |  | A
Q 3 | P 7 | 2011-09-16 00:00:00 | 2011-10-13 00:00:00 |  |  | B
Q 3 | P 8 | 2011-10-14 00:00:00 | 2011-11-10 00:00:00 |  |  | B
Q 3 | P 9 | 2011-11-11 00:00:00 | 2011-12-08 00:00:00 |  |  | B
Q 3 | P 7 | 2011-09-16 00:00:00 | 2011-10-13 00:00:00 |  |  | C
Q 3 | P 8 | 2011-10-14 00:00:00 | 2011-11-10 00:00:00 |  |  | C
Q 3 | P 9 | 2011-11-11 00:00:00 | 2011-12-08 00:00:00 |  |  | C
Q 4 | P 10 | 2011-12-09 00:00:00 | 2012-01-05 00:00:00 |  |  | A
Q 4 | P 11 | 2012-01-06 00:00:00 | 2012-02-02 00:00:00 |  |  | A
Q 4 | P 12 | 2012-02-03 00:00:00 | 2012-03-01 00:00:00 |  |  | A
Q 4 | P 13 | 2012-03-02 00:00:00 | 2012-03-31 00:00:00 |  |  | A
Q 4 | P 10 | 2011-12-09 00:00:00 | 2012-01-05 00:00:00 |  |  | B
Q 4 | P 11 | 2012-01-06 00:00:00 | 2012-02-02 00:00:00 |  |  | B
Q 4 | P 12 | 2012-02-03 00:00:00 | 2012-03-01 00:00:00 |  |  | B
Q 4 | P 13 | 2012-03-02 00:00:00 | 2012-03-31 00:00:00 |  |  | B
Q 4 | P 10 | 2011-12-09 00:00:00 | 2012-01-05 00:00:00 |  |  | C
Q 4 | P 11 | 2012-01-06 00:00:00 | 2012-02-02 00:00:00 |  |  | C
Q 4 | P 12 | 2012-02-03 00:00:00 | 2012-03-01 00:00:00 |  |  | C
Q 4 | P 13 | 2012-03-02 00:00:00 | 2012-03-31 00:00:00 |  |  | C
Spreadsheet: 743148d1628251867-closing-rate-per-month-sample
Sheet: Sheet1

Date? | Customer Name | Call Type? | Proposed Work ($) | Approved Work($) |  | Month | Close Rate %
2021-07-30 00:00:00 | Test Call | Service | 5200 | 4100 |  | Jan
2021-07-29 00:00:00 | [NAME] | Maintenance/System Check | 1350 | 978 |  | Feb
2021-07-28 00:00:00 | [NAME] | Service | 3675 | 3450 |  | Mar
2021-08-03 00:00:00 | Tough Call | Service | 5600 | 69 |  | Apr
2021-08-05 00:00:00 | [NAME] | Service | 4300 | 0 |  | May
2021-08-05 00:00:00 | [NAME] | Maintenance/System Check | 575 | 125 |  | Jun
2021-08-05 00:00:00 | Jonny grapeseed | Service | 7800 | 1250 |  | Jul
 |  |  |  |  |  | Aug
 |  |  |  |  |  | Sep
 |  |  |  |  |  | Oct
 |  |  |  |  |  | Nov
 |  |  |  |  |  | Dec
Spreadsheet: 109744d1306510798-group-totaling-trialforproject
Sheet: Sheet1

Nutrient | Market Form | Activity | % of product | Total Nutrient per 100g
Calcium | Tricalcium Phosphate | 0.35 | 14 | 4.899999999999999
Calcium | Calcium Citrate | 0.34 | 33 | 11.22
Calcium | Calcium Ascorbate | 0.08 | 6 | 0.48
 |  |  |  |  | 16.6
Sodium | Sodium Chloride | 0.31 | 2 | 0.62
Sodium | Sodium Citrate | 0.25 | 9 | 2.25
 |  |  |  |  | 2.87
Potassium | Potassium Chloride | 0.5 | 18 | 9
 |  |  |  |  | 9
Chloride | Sodium Chloride | 0.606 | 2 | 1.212
Chloride | Potassium Chloride | 0.47 | 18 | 8.459999999999999
 |  |  |  |  | 9.671999999999999
Phosphorous | Tricalcium Phosphate | 0.18 | 14 | 2.52
 |  |  |  |  | 2.52
Vitamin C | Calcium Ascorbate | 0.89 | 6 | 5.34
 |  |  |  |  | 5.34
Spreadsheet: 99594d1298212499-pivot-table-issue-book3
Sheet: Data

Customer | Vehicle No | Chassis No | Brand | date
[NAME] | 12993 | 3GKEC16TO1G121214 | Toyota | 2009
[NAME] | 14262 | 3GKFK16T85G285694 | Toyota | 2007
Zubair Mohd Shaikh | 25030 | 93CXH19J85C121010 | OPEL | 2008
[NAME] | 31670 | 1GKS28E35BR200363 | Toyota | 2006
Zuhair Nazir Asad Hatouqa | 27733 | 3GYFNDEY4AS532633 | CADILLAC | 2005
Zubaidha Al Suwaidi | 11964 | 1GTHK23U06F256913 | Toyota | 2004
[NAME] | 28827 | 1GKLVNED9AJ235049 | Toyota | 2003
Zubair Mohd Shaikh | 1258 | 1GKEV33708J151884 | Toyota | 2002
Zubaidha Al Suwaidi | 22775 | 1GKDT13S522389502 | Toyota | 2001
[NAME] | 28818 | 1GKLVNEDXAJ208426 | Toyota | 2011
Spreadsheet: 579091d1529679588-networkdays-intl-and-lunch-break-sickness-test
Sheet: Bank Holidays

New Year's Day | 2018-01-01 00:00:00
Good Friday | 2018-03-30 00:00:00
Easter Monday | 2018-04-02 00:00:00
Early May bank holiday | 2018-05-07 00:00:00
Spring bank holiday | 2018-05-28 00:00:00
Summer bank holiday | 2018-08-27 00:00:00
Christmas Day | 2018-12-25 00:00:00
Boxing Day, [NAME] (off.) | 2018-12-26 00:00:00
New Year's Day | 2019-01-01 00:00:00
Good Friday | 2019-03-19 00:00:00
Easter Monday | 2019-04-22 00:00:00
Early May bank holiday | 2019-05-06 00:00:00
Spring bank holiday | 2019-05-27 00:00:00
Summer bank holiday | 2019-08-26 00:00:00
Christmas Day | 2019-12-25 00:00:00
Boxing Day, [NAME] (off.) | 2019-12-26 00:00:00
New Year's Day | 2020-01-01 00:00:00
Good Friday | 2020-04-10 00:00:00
Easter Monday | 2020-04-12 00:00:00
Early May bank holiday | 2020-05-04 00:00:00
Spring bank holiday | 2020-05-25 00:00:00
Summer bank holiday | 2020-08-31 00:00:00
Christmas Day | 2020-12-25 00:00:00
Boxing Day, [NAME] (off.) | 2020-12-26 00:00:00
Spreadsheet: 138761d1327886672-conditional-formatting-using-vlookup-or-find-events-calendar-mock
Sheet: Data

Seniors Fixtures
Round | Date | [NAME] |  | [NAME]
1 | 2012-03-24 00:00:00 | 15:00:00 | H | [NAME]
2 | 2012-03-31 00:00:00 | 15:00:00 | A | West Adelaide Soccer Club
3 | 2012-04-09 00:00:00 | 15:00:00 | H | N.A.B Soccer Club
4 | 2012-04-14 00:00:00 | 15:00:00 | A | Noarlunga United
5 | 2012-04-21 00:00:00 | 15:00:00 | H | Adelaide Hills Hawks
6 | 2012-05-05 00:00:00 | 15:00:00 | A | Gawler Soccer & Sports Club Inc
7 | 2012-05-12 00:00:00 | 15:00:00 | H | Northern Demons
8 | 2012-05-26 00:00:00 | 15:00:00 | H | Western Toros
9 | 2012-06-02 00:00:00 | 15:00:00 | A | [NAME]
10 | 2012-06-09 00:00:00 | 15:00:00 | H | West Adelaide Soccer Club
11 | 2012-06-16 00:00:00 | 15:00:00 | A | N.A.B Soccer Club
12 | 2012-06-23 00:00:00 | 15:00:00 | H | Noarlunga United
13 | 2012-06-30 00:00:00 | 15:00:00 | A | Adelaide Hills Hawks
14 | 2012-07-07 00:00:00 | 15:00:00 | H | Gawler Soccer & Sports Club Inc
15 | 2012-07-21 00:00:00 | 15:00:00 | A | Northern Demons
16 | 2012-07-28 00:00:00 | 15:00:00 | A | Western Toros
17 | 2012-08-11 00:00:00 | 15:00:00 | H | [NAME]
18 | 2012-08-18 00:00:00 | 15:00:00 | A | [NAME] FC
 | 2012-03-15 00:00:00 | 18:00:00 | F | Fundraising event
 | 2012-01-31 00:00:00 | 18:30:00 | M | Committee Meeting
Spreadsheet: 709447d1608307277-do-i-use-index-and-match-to-count-products-on-different-sheets-stock-check-blanks-2
Sheet: A Aisle

 | Product code | Qty |  |  | Product code | Qty
A1A | apples | 3 |  | A5A
A1B | pears | 76 |  | A5B |  |  |  | want to count all of the different products
A1C | oranges | 44 |  | A5C |  |  |  | on this sheet:
A1D | grapes | 20 |  | A5D
A1E | plums | 50 |  | A5E |  |  |  | apples
 |  |  |  |  |  |  |  | pears
A2A |  |  |  | A6A |  |  |  | oranges
A2B |  |  |  | A6B |  |  |  | grapes
A2C |  |  |  | A6C |  |  |  | plums
A2D |  |  |  | A6D
A2E |  |  |  | A6E |  |  |  | Then I want to count all ths same products on the other sheets
 |  |  |  |  |  |  |  | to give me a grand total of my products.
A3A |  |  |  | A7A
A3B |  |  |  | A7B | apples | 2 |  | I have used fruit as an example
A3C |  |  |  | A7C | apples | 19
A3D |  |  |  | A7D | oranges | 5
[NAME] |  |  |  | A7E
A4A |  |  |  | A8A
A4B |  |  |  | A8B
A4C |  |  |  | A8C
A4D |  |  |  | A8D
A4E |  |  |  | A8E
 | Product code | Qty |  |  | Product code | Qty
A9A |  |  |  | A13A
A9B |  |  |  | A13B
A9C |  |  |  | A13C
A9D |  |  |  | A13D
A9E |  |  |  | A13E
A10A |  |  |  | A14A
A10B |  |  |  | A14B
[NAME] |  |  |  | A14C
A10D |  |  |  | A14D
A10E |  |  |  | A14E
A11A |  |  |  | A15A
A11B |  |  |  | A15B
A11C |  |  |  | A15C
A11D |  |  |  | A15D
A11E |  |  |  | A15E
A12A |  |  |  | A16A
A12B |  |  |  | A16B
A12C |  |  |  | A16C
A12D |  |  |  | A16D
A12E |  |  |  | A16E
 | Product code | Qty |  |  | Product code | Qty
A17A |  |  |  | A21A
A17B |  |  |  | A21B
A17C |  |  |  | A21C
A17D |  |  |  | A21D
A17E |  |  |  | A21E
A18A |  |  |  | A22A | apples | 8
A18B | pears | 44 |  | A22B | apples | 1
A18C | oranges | 6 |  | A22C
A18D | grapes | 11 |  | A22D
A18E |  |  |  | A22E
A19A |  |  |  | A23A | pears | 12
A19B | plums | 66 |  | A23B | oranges | 3
A19C | plums | 2 |  | A23C | grapes | 95
A19D |  |  |  | A23D | plums | 2
A19E |  |  |  | A23E
A20A | apples |  |  | A24A
A20B |  |  |  | A24B
A20C | pears |  |  | A24C | plums | 6
A20D | oranges |  |  | A24D
A20E | grapes |  |  | A24E
 | Product code | Qty |  |  | Product code | Qty
A25A |  |  |  | A29A
A25B |  |  |  | A29B | apples | 8
A25C |  |  |  | A29C | apples | 4
A25D |  |  |  | A29D
A25E |  |  |  | A29E
A26A |  |  |  | A30A
A26B |  |  |  | [NAME]
A26C |  |  |  | A30C
A26D |  |  |  | A30D
A26E |  |  |  | A30E
A27A |  |  |  | A31A
A27B |  |  |  | A31B
A27C |  |  |  | A31C
A27D |  |  |  | A31D
A27E |  |  |  | A31E
A28A |  |  |  | A32A
A28B |  |  |  | A32B
A28C |  |  |  | A32C
A28D |  |  |  | [NAME]
A28E |  |  |  | A32E
 | Product code | Qty
A33A
A33B
[NAME]
A33D
A33E
Spreadsheet: 94040939-6c6a-4967-bc29-e112aab63c2f
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
Comparison of Output of Solar Systems of [NAME], [NAME] & [NAME]
 | [NAME] |  |  |  | [NAME] |  |  | [NAME]
 | 24 Lingard Street |  |  |  | 18 Yellow Cedar Place |  |  | 50 Winston Road South
 | Palmwoods |  |  |  | Palmwoods |  |  | Palmwoods
 | 30 x 60w Kaneeka Panels & |  |  |  | 30 x 60w Kaneeka Panels & |  |  | 32 x 60w Kaneeka Panels &
 | SB-1700 Inverter |  |  |  | SB-1700 Inverter |  |  | SB-1700 Inverter
Orientation |  |  | 331 o NNW |  | 0 o |  |  | 12 o NE
[NAME] |  |  | 23 o | 24 Panels | 22 o |  |  | 30 o
 |  |  | 15 o | 6 Panels
 | Strings |  | 10 x 3 |  | 10 x 3 |  |  | 8 x 4
Date | 10:00:00 | 12:00:00 | 14:00:00 |  | 10:00:00 | 12:00:00 | 14:00:00 | 10:00:00 | 12:00:00 | 14:00:00 | Weather
2011-06-14 00:00:00 | 795 | 993 | 810 |  | 1048 | 1157 | 818 | Away | 1209 | 973 | Fine & clear
2011-06-15 00:00:00 | 775 | 977 | 55 |  | Away |  |  | 1170 | 1243 | 225 | Fine AM, cloudy PM
2011-06-16 00:00:00 | 788 | 978 | 781 |  | 1049 | 1136 | 824 | 1139 | 1209 | 988 | Fine & clear
2011-06-17 00:00:00 | 786 | 981 | 830 |  | Away |  |  | 1157 | 1198 | 915 | Fine & windy, odd cloud around
2011-06-18 00:00:00 | 783 | 974 | 802 |  | 1043 | 1137 | 820 | Away | 1145 | 901 | Fine, clear & windy
2011-06-19 00:00:00 | 777 | 969 | 790 |  | 1047 | 1129 | 819 | 1170 | 1182 | 910 | Fine & clear
2011-06-20 00:00:00 | 770 | 963 | 805 |  | 998 | 1141 | 835 | 1154 | 1133 | 903 | Fine & clear
Spreadsheet: 870374d1716903921-create-table-from-rows-myrequest_1-aligw
Sheet: Sheet1

 | chair 1 |  |  |  |  | chair 2 |  |  |  |  | chair 3
 | choice 1 | choice 2 | choice 3 | choice 4 | choice 5 | choice 1 | choice 2 | choice 3 | choice 4 | choice 5 | choice 1 | choice 2 | choice 3 | choice 4 | choice 5
[NAME] | yellow | black | [NAME] | white | purple | [NAME] | orange | green | yellow | yellow | white |  | [NAME] | green
suzan | [NAME] | orange | green | pink | pink | orange | green | [NAME] | yellow | yellow |  | [NAME] | yellow | green | purple
 | chair 1 | chair 2 | chair 3 |  |  | In this table, choice numbers can be left out
[NAME] | yellow | [NAME] | white
[NAME] | black | orange
[NAME] | [NAME] | green | [NAME]
[NAME] | white | yellow | green
[NAME] | purple | yellow
suzan | [NAME] | orange
suzan | orange | green | [NAME]
suzan | green | [NAME] | yellow
suzan | pink | yellow | green
suzan | pink | yellow | purple
Spreadsheet: andy_zipper__195__Global_Prod 5-23-01 EM
Sheet: Taken Down Prior to Exp

Global Products that were not made available on
and have not yet expired
Global Product Short Desc.
[NAME]Jun01           USD/bbl
UK E-W FO Diff   Platts                  Jun01           USD/mt/m
US HeatOil2 Opt  NYMEX        EC81.0     Jun01           c/GL-L
US HeatOil2 Opt  NYMEX        EC82.0     Jun01           c/GL-L
US HeatOil2 Opt  NYMEX        EC83.0     Jun01           c/GL-L
US HeatOil2 Opt  NYMEX        EC84.0     Jun01           c/GL-L
US HeatOil2 Opt  NYMEX        EC85.0     Jun01           c/GL-L
US HeatOil2 Opt  NYMEX        EC86.0     Jun01           c/GL-L
US HeatOil2 Opt  NYMEX        EP76.0     Jun01           c/GL-L
US HeatOil2 Opt  NYMEX        EP77.0     Jun01           c/GL-L
US HeatOil2 Opt  NYMEX        EP78.0     Jun01           c/GL-L
US HeatOil2 Opt  NYMEX        EP79.0     Jun01           c/GL-L
US HeatOil2 Opt  NYMEX        EP80.0     Jun01           c/GL-L
US HeatOil2 Opt  NYMEX        EP81.0     Jun01           c/GL-L
US HeatOil2 Swap GC Crack Spread         CAL 2003        USD/bl/m
US HeatOil2 Swap GC Crack Spread         CAL 2004        USD/bl/m
US HeatOil2 Swap NYMEX HO CrkSpd         CAL 2003        USD/bl/m
US HeatOil2 Swap NYMEX HO CrkSpd         CAL 2004        USD/bl/m
US Prop FOB Phy  Bushton                 May01           c/Gl-b
US Prop FOB Phy  CONWY                   May01           c/Gl-b
US PuEthane Swap OPIS MB PurEth          Jul01           c/Gl-b
US PuEthane Swap OPIS MB PurEth          Oct-Dec01       c/Gl-b
US ResidOil Spd  NYH 1% Crack Spread     Jan-Dec02       USD/bl/m
US ResidOil Swap Platts No 6 GC 3%       Jul-Sep01       USD/bl/m
US ResidOil Swap Platts No 6 GC 3%       Oct-Dec01       USD/bl/m
US ResidOil Swap Platts No 6 NYH 1%      Jul-Sep01       USD/bl/m
US ResidOil Swap Platts No 6 NYH 1%      Jun01           USD/bl/m
US ResidOil Swap Platts No 6 NYH 1%      Oct-Dec01       USD/bl/m
US WTI Swap      Nymex LD                Jun01           USD/bl/m
Spreadsheet: 152605d1335450992-excel-2007-automatically-sizing-a-table-according-to-another-tables-size-maintenance-schedule-maintenance-summary-max-power-monthly-power
Sheet: Schedule

Date | Instrument | Completed | * pending
2011-02-22 00:00:00 | [NAME] | stand maintenance only | † reserved
2011-03-09 00:00:00 | Axiovert1 | stand maintenance only | ‡ projected
2011-03-16 00:00:00 | LSM4 | stand maintenance, power meter readings | ** Scope remove from maintenance list pending an increase in usage.
2011-03-23 00:00:00 | TIRF | stand maintenance only
2011-04-01 00:00:00 | Pascal1 | complete but psf omitted
2011-04-06 00:00:00 | FLIM | complete but psf omitted
2011-04-12 00:00:00 | LSM3 | stand maintenance plus PH alignment investigation
2011-04-20 00:00:00 | LSM710
2011-04-27 00:00:00 | [NAME]
2011-05-04 00:00:00 | LSM4 | incomplete (laser testing not completed)
2011-05-12 00:00:00 | Axiovert2 | incomplete (lamp testing not completed)
2011-05-18 00:00:00 | Axiovert1 | CANCELLED
2011-05-25 00:00:00 | FLIM
2011-06-02 00:00:00 | LSM3
2011-06-08 00:00:00 | LSM710
2011-06-15 00:00:00 | Pascal1
2011-06-21 00:00:00 | LSM4 | need to do [NAME]
2011-06-27 00:00:00 | Pascal2
2011-06-29 00:00:00 | TIRF | CANCELLED
2011-07-07 00:00:00 | [NAME] | stand and laser power measurements
2011-07-13 00:00:00 | TIRF | July 15th and 18th as well. Was Axiovert1.
2011-07-20 00:00:00 | FLIM | CANCELLED
2011-08-05 00:00:00 | Axiovert1 | CANCELLED
2011-08-12 00:00:00 | Axiovert2
2011-08-14 00:00:00 | Axiovert1
2011-08-15 00:00:00 | LSM3 | CANCELLED?
2011-08-24 00:00:00 | LSM4 | Superceded by Zeiss PM,  PC repair and ZEN upgrade
2011-09-01 00:00:00 | Pascal1
2011-09-08 00:00:00 | LSM710
2011-09-11 00:00:00 | [NAME] | [NAME]
2011-09-18 00:00:00 | LSM4
November-30-11 | LSM710 | [NAME]
December-7-11 | FLIM
December-14-11 | LSM3
2012-01-12 00:00:00 | Pascal2
2012-02-09 00:00:00 | Axiovert2
2012-02-24 00:00:00 | Pascal1
2012-03-07 00:00:00 | Axiovert1
2012-03-15 00:00:00 | [NAME]
2012-03-22 00:00:00 | LSM4
2012-04-26 00:00:00 | FLIM
 | LSM710
 | LSM3
 | Pascal2
Spreadsheet: 877639d1724431212-entering-a-cell-number-to-control-a-formula-test-spreadsheet
Sheet: Test 

 |  |  | SS/FS | Cell Ref | + Days |  | Start | Complete | Days
 |  |  |  |  |  |  | 2024-08-04 00:00:00 |  | 5
 |  |  | FS | I4 | 2 |  | 2024-08-11 00:00:00 |  | 7
 |  |  | SS | H5 | 7 |  | 2024-08-25 00:00:00 |  | 4
 |  |  | FS | I5 | 9 |  | 2024-08-27 00:00:00 |  | 2
 |  |  | SS | H6 | 15 |  | 2024-09-09 00:00:00 |  | 5
Spreadsheet: 469705d1468075802-if-formula-for-finding-a-number-within-a-column-if-yes-no
Sheet: Sheet1

 |  |  |  | 5
Spreadsheet: 27897d1221617098-microsoft-query-seperates-parameters-in-pivot-table-upload
Sheet: Sheet1

(Multiple Items)
(Multiple Items)
Row Labels
300
300
302
302
303
303
400
400
410
410
421
421
430
430
431
431
440
460
460
470
470
472
472
501
502
503
503
504
504
Grand Total
Spreadsheet: 148851d1333577093-alphabetizing-but-keeping-the-same-format-also-find-same-cells-across-columns-sampleexcel
Sheet: Sheet1

Participant | Self Aspect 1 | Traits Aspect 1 | Self Aspect 2 | Traits Aspect 2 | Self Aspect 3 | Traits Aspect 3
Person 1 | Trait Name | Creative | Trait Name 2 | Funny
 |  | Funny |  | Thoughtful
 |  | Nice |  | Cheerful
 |  | Thoughtful |  | Neat
 |  | Understanding |  | Intelligent
 |  | Silly |  | Restless
 |  | Talkative |  | Serious
 |  | Thoughtful |  | Thorough
 |  | Understanding
Person 2 | Trait Name |  | Trait Name 2 | Consis | Trait Name 3 | Consistent
 |  | Forward |  | Consistent |  | Enthusiastic
 |  | Friendly |  | Imaginative |  | Friendly
 |  | Gullible |  | Thorough |  | Headstrong
 |  | Helpful |  | Methodical |  | Helpful
 |  | Reasonable |  | Prudent |  | Methodical
 |  | Responsible |  | Anxious |  | Open Minded
 |  | Self Conscious |  | Open Minded |  | Resourceful
 |  | Silly |  | Serious |  | Responsible
 |  | Talented |  | Resourceful |  | Thorough
 |  | Original
 |  | Talkative
 |  | Thoughtful
 |  | Timid
 |  | Tough
 |  | Understanding
Spreadsheet: 226039d1365216828-continuing-number-sequences-with-lines-20130406-navdatawithrequiredresult-v2
Sheet: navdata

check | formula | REQUIRED RESULT | OLD DATA
 |  | 5 | 1 | [NAME] |  | Z999 | H |  | AUS | 47.400011 | 10.479875 |  | 5
 |  | 4 | 2 | BEMKI |  | Z999 | H |  | AUS | 47.5595 | 10.3055 |  | 5
 |  | 3 | 3 | KPT |  | Z999 | H |  | AUS | 47.745775 | 10.349833 |  | 3
 |  | 19 | 1 | LUB |  | Z998 | H |  | AUS | 53.940742 | 10.667786 |  | 3
 |  | 18 | 2 | RAMAR |  | Z998 | H |  | AUS | 53.710833 | 10.938834 |  | 5
 |  | 17 | 3 | NUSGU |  | Z998 | H |  | AUS | 53.266667 | 11.388667 |  | 5
 |  | 16 | 4 | [NAME] |  | Z998 | H |  | AUS | 53.148667 | 11.569667 |  | 5
 |  | 15 | 5 | PITEN |  | Z998 | H |  | AUS | 52.99 | 11.811333 |  | 5
 |  | 14 | 6 | BIRMO |  | Z998 | H |  | AUS | 52.872167 | 12.068667 |  | 5
 |  | 13 | 7 | RATMO |  | Z998 | H |  | AUS | 52.705333 | 12.429667 |  | 5
 |  | 12 | 8 | NISGA |  | Z998 | H |  | AUS | 52.2495 | 12.876167 |  | 5
 |  | 11 | 9 | GODUR |  | Z998 | H |  | AUS | 51.8305 | 13.279667 |  | 5
 |  | 10 | 10 | OSKAN |  | Z998 | H |  | AUS | 51.460833 | 13.627833 |  | 5
 |  | 3 | 1 | RATMO |  | Z997 | H |  | AUS | 52.705333 | 12.429667 |  | 5
 |  | 2 | 2 | SUI |  | Z997 | H |  | AUS | 52.379856 | 14.585603 |  | 3
 |  | 11 | 1 | NOBTO |  | Z994 | H |  | AUS | 23.923611 | 55.311111 |  | 5
 |  | 10 | 2 | [NAME] |  | Z994 | H |  | AUS | 24.316667 | 54.733333 |  | 5
 |  | 9 | 3 | TOXIG |  | Z994 | H |  | AUS | 24.533333 | 53.917222 |  | 5
 |  | 8 | 4 | DASLA |  | Z994 | H |  | AUS | 24.629722 | 53.546667 |  | 5
 |  | 7 | 5 | VEBAT |  | Z994 | H |  | AUS | 24.808333 | 52.85 |  | 5
 |  | 6 | 6 | BUNDU |  | Z994 | H |  | AUS | 25.006667 | 52.49 |  | 5
 |  | 13 | 1 | HLZ |  | Z990 | H |  | AUS | 52.363395 | 10.79522 |  | 3
 |  | 12 | 2 | DIRBO |  | Z990 | H |  | AUS | 52.832167 | 10.844167 |  | 5
 |  | 11 | 3 | IRKIS |  | Z990 | H |  | AUS | 53.248833 | 10.888667 |  | 5
 |  | 10 | 4 | ABMAL |  | Z990 | H |  | AUS | 53.442 | 10.912 |  | 5
 |  | 9 | 5 | RAMAR |  | Z990 | H |  | AUS | 53.710833 | 10.938834 |  | 5
 |  | 8 | 6 | [NAME] |  | Z990 | H |  | AUS | 54.113889 | 10.983611 |  | 5
 |  | 7 | 7 | MIC |  | Z990 | H |  | AUS | 54.305461 | 11.005186 |  | 3
 |  | 3 | 1 | RIMKI |  | [NAME] | H |  | AUS | 49.748833 | 9.363833 |  | 5
 |  | 2 | 2 | LOHRE |  | [NAME] | H |  | AUS | 50.067 | 9.486333 |  | 5
 |  | 9 | 1 | FER |  | Z982 | H |  | AUS | 44.8145 | 11.616333 |  | 3
 |  | 8 | 2 | GIPUK |  | Z982 | H |  | AUS | 44.588611 | 11.966667 |  | 5
 |  | 7 | 3 | RIBKI |  | Z982 | H |  | AUS | 44.514722 | 12.080833 |  | 5
 |  | 6 | 4 | DITUM |  | Z982 | H |  | AUS | 44.405833 | 12.247222 |  | 5
 |  | 5 | 5 | BAKEP |  | Z982 | H |  | AUS | 44.176944 | 12.594722 |  | 5