tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: lindy_donoho__22158__XTransCanadaSept01
Sheet: TransCanadaDataSheet

TRANSCANADA  PIPELINE
Volumes in MMcf/d
Date | RECEIVED |  |  |  | DELIVERED
 | Empress | Suffield | Bayhurst | Kirkwall | Emerson |  |  | Iroquois | [NAME] | Chippawa | Trans | Philipsburg | Central | Eastern
 |  |  |  |  | Viking | Great Lakes | Total |  | Falls | Empire G I | Quebec |  | Zone | Zone
1999-01-01 00:00:00
1999-02-01 00:00:00
1999-03-01 00:00:00
1999-04-01 00:00:00
1999-05-01 00:00:00
1999-06-01 00:00:00
1999-07-01 00:00:00
1999-08-01 00:00:00
1999-09-01 00:00:00
1999-10-01 00:00:00
1999-11-01 00:00:00
1999-12-01 00:00:00
[NAME]
2000-01-01 00:00:00
2000-02-01 00:00:00
2000-03-01 00:00:00
2000-04-01 00:00:00
2000-05-01 00:00:00
2000-06-01 00:00:00
2000-07-01 00:00:00
2000-08-01 00:00:00
2000-09-01 00:00:00
2000-10-01 00:00:00
2000-11-01 00:00:00
2000-12-01 00:00:00
[NAME]
2001-01-01 00:00:00
2001-02-01 00:00:00
2001-03-01 00:00:00
2001-04-01 00:00:00
2001-05-01 00:00:00
2001-06-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
2001-11-01 00:00:00
2001-12-01 00:00:00
Avg 01
2002-01-01 00:00:00
2002-02-01 00:00:00
2002-03-01 00:00:00
2002-04-01 00:00:00
2002-05-01 00:00:00
2002-06-01 00:00:00
2002-07-01 00:00:00
2002-08-01 00:00:00
2002-09-01 00:00:00
2002-10-01 00:00:00
2002-11-01 00:00:00
2002-12-01 00:00:00
Avg 02
Spreadsheet: 274834d1383233123-max-value-mult-criteria-excel-help-2
Sheet: Sheet2

 | CAT ID | 49 | 56 | 85 | 100 | 115
 | TOP PERFORMING ITEMS (NS$) |  |  |  |  |  | Lowest PERFORMING ITEMS (NS$)
Top | [NAME] | [NAME] | NS$ |  |  | Top | [NAME] | [NAME] | NS$
1 |  |  |  |  |  | 5
2 |  |  |  |  |  | 4
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 2
5 |  |  |  |  |  | 1
 | TOTAL |  | 0 |  |  |  | TOTAL |  | 0
Spreadsheet: 63422d1264347472-running-count-and-conditional-formating-example
Sheet: Sheet1

 | cur rnds | fired | total rnds | A maint. | B. maint.
gun 1 | 36333 | 200 |  |  |  | <------------- I have conditionallty formated two columns to highlight when a certain amount of rounds have been shot. The problem that I am running into now is |  |  |  |  |  |  |  |  |  |  |  |  | n
gun 2 |  |  |  | I will need to enter the new number and I want the total rounds count to continure to keep a cumlative total. |  | that the currnet rounds do not go up with the total round count, thus I am not able to reset the rounds on the conditional columns
gun 3 |  |  |  |  |  | after I have done the maintenance. Does this make sense? If a gun shoots over a 1000 rounds then the b maint. Column highlights and if the gun
gun 4 |  |  |  |  |  | shoots over 42000 rounds then the A. Maint. Column hightlights. Is there a way to reset these back to zero after I have performed the maintenance
 |  |  |  |  |  | without deleting the formulas or fomats? And is there a way to get the current rounds to keep a running total and reflect the same number as the total rounds | without deleting the formulas or formats? And is there a way that the current round cells will go up concurrently with the total round cells, eventhough
 |  |  |  |  |  |  | I use the cell for some of the formulas (i.e. total rounds formual= current rounds + recent fired rounds and A. maint and B. Maint. Are conditonally involved with
 |  |  |  |  |  |  | currnt round cells as well.             I hope this makes sense. Thank you for your help thus far
Spreadsheet: 738526d1625087364-return-all-results-using-filter-all-results
Sheet: All Results (2)

Color | Return Value |  | Lookup Value | 2nd  Lookup Value
Blue | asc-1 |  | Green | Blue
Orange you glad I didn't say [NAME]? | [NAME] |  | Single Lookup Value
two red bugs | asc-3 |  | Wildcard Return | No Wildcard
Envy Green | asc-4
Blue is blue | asc-5 |  |  | asc-15
Yellow | asc-6
green | [NAME]
Snot Green | asc-8
I'm so blue | asc-9
Snot Yellow | asc-10
Blue Moon | asc-11
Almost red | asc-12
orange | asc-13
red | asc-14
green | asc-15
 |  |  | With Two Lookup Values
 |  |  | Wildcard Return | No Wildcard
Spreadsheet: 852541d1702545981-group-array-items-monthly-based-on-start-and-finish-dates-group-array-based-on-start-and-finish-dates-excelforum
Sheet: Sheet1

Area | Process | Start | Finish
Area 1 | Production | 2023-01-01 00:00:00 | 2023-11-02 00:00:00
Area 1 | Assembly
Area 1 | Dispatch
Area 1 | Delivery
Area 2 | Production
Area 2 | Assembly
Area 2 | Dispatch
Area 2 | Delivery
 | Area 1 | Area 2 |  |  | Area 1 | Area 2
2023-01-01 00:00:00 | Production |  |  | 2023-01-01 00:00:00 | Production
2023-02-01 00:00:00 | Production |  |  | 2023-02-01 00:00:00 | Production
 | Assembly |  |  | 2023-03-01 00:00:00 | Production
2023-03-01 00:00:00 | Assembly |  |  | 2023-04-01 00:00:00 | Production
2023-04-01 00:00:00 | Dispatch |  |  | 2023-05-01 00:00:00 | Production
2023-05-01 00:00:00 | Dispatch |  |  | 2023-06-01 00:00:00 | Production
 | Delivery |  |  | 2023-07-01 00:00:00 | Production
2023-06-01 00:00:00 | Delivery |  |  | 2023-08-01 00:00:00 | Production
2023-07-01 00:00:00 |  | Production |  | 2023-09-01 00:00:00 | Production
2023-08-01 00:00:00 |  | Production |  | 2023-10-01 00:00:00 | Production
 |  | Assembly |  | 2023-11-01 00:00:00 | Production
2023-09-01 00:00:00 |  | Assembly |  |  | Assembly
2023-10-01 00:00:00 |  | Dispatch |  | 2023-12-01 00:00:00 | Assembly
2023-11-01 00:00:00 |  | Delivery |  | 2024-01-01 00:00:00 | Dispatch
2023-12-01 00:00:00 |  | Delivery |  | 2024-02-01 00:00:00 | Delivery
 |  |  |  | 2024-03-01 00:00:00 | Delivery
 |  |  |  | 2024-04-01 00:00:00 |  | Production
 |  |  |  | 2024-05-01 00:00:00 |  | Assembly
 |  |  |  | 2024-06-01 00:00:00 |  | Assembly
 |  |  |  | 2024-07-01 00:00:00 |  | Dispatch
 |  |  |  | 2024-08-01 00:00:00 |  | Delivery
 |  |  |  | 2024-09-01 00:00:00 |  | Delivery
Spreadsheet: 762067d1641384351-need-help-with-attendance-formula-in-an-excel-template-e11-attdendance-2022-2-
Sheet: Employee Leave Tracker

 | Employee [NAME]
 | Employee Name | Start Date | End Date | Type of Leave | Days
 | [NAME] | 2022-01-03 00:00:00 | 2022-01-03 00:00:00 | [NAME]
Spreadsheet: 57307d1257421488-league-table-706095_maffew
Sheet: Sheet1

# | Fixture |  | Nick |  |  |  |  | [NAME] |  |  |  |  | Result |  |  |  | POS | Name | Points
 |  |  | Home | Away | Result | Points |  | Home | Away |  | Points |  | Home | Away |  |  | 1 | [NAME] | 0
1 | Man Utd vs CSKA |  | 3 | 1 | HOME | 0 |  | 1 | 0 | HOME | 0 |  | 3 | 3 | DRAW |  | 2 | Nick | 0
2 | Chelsea vs Man Utd |  | 1 | 1 |  |  |  | 1 | 0
3 | Man Utd vs Everton
4 | Man Utd vs Beshiktas
5 | Portsmouth vs Man Utd
6 | West Ham vs Man Utd
7 | Wolfsburg vs Man Utd
8 | Man Utd vs [NAME]
9 | Man Utd vs Wolves
10 | Fulham vs Man Utd
11 | Hull vs Man Utd
12 | Man Utd vs [NAME]
 | Total Points |  |  |  |  | 0 |  |  |  | 0 | 0
Spreadsheet: 112796d1308788441-please-help-offset-and-match-returns
Sheet: Sheet1 

 | Number Reference | Date | fund1 | fund2 | fund3 | fund4 | [NAME]
 | 1 | 2010-04-30 00:00:00 | 0.02 | 0.03 | 0.02 | 0.05 | 0.02
 | 2 | 2010-05-30 00:00:00 | 0.05 | 0.08 | 0.0324 | 0.025 | 0.02
 | 3 | 2010-06-30 00:00:00 | 0.05 | 0.08 | 0.0324 | 0.025 | 0.0175
 | 4 | 2010-07-31 00:00:00 | 0.08 | 0.0324 | 0.025 | 0.02 | 0.02
 | 5 | 2010-08-31 00:00:00 | 0.0175 | 0.0175 | 0.0175 | 0.0175 | 0.02
 | 6 | 2010-09-30 00:00:00 | 0.02 | 0.04 | 0.0175 | 0.05 | 0.016
 | 7 | 2010-10-31 00:00:00 | 0.05 | 0.08 | 0.0324 | 0.025 | 0.02
 | 8 | 2010-11-30 00:00:00 | 0.04 | 0.015 | 0.01 | 0.01 | 0.02
 | 9 | 2010-12-31 00:00:00 | 0.01 | 0.025 | 0.032 | 0.02 | 0.042
 | 10 | 2011-01-31 00:00:00 | 0.05 | 0.08 | 0.0324 | 0.025 | 0.02
 | 11 | 2011-02-28 00:00:00 | 0.02 | 0.04 | 0.05 | 0.05 | 0.016
 | 12 | 2011-03-31 00:00:00 | 0.05 | 0.08 | 0.0324 | 0.025 | 0.02
 | 13 | 2011-04-30 00:00:00 | 0.05 | 0.08 | 0.0324 | 0.025 | 0.02
 | 14 | 2011-05-31 00:00:00 | 0.05 | 0.07 | 0.05 | 0.05 | 0.02
 | 15 | 2011-06-30 00:00:00
 | 16 | 2011-07-31 00:00:00
 |  |  |  | Cumulative Return | YTD (number 10 to 14) | 1st Quarter 2011 (number 10 to 12) | Last 12 months (number 3 to 14)
 |  |  | fund1 | 0.7236079764811074
 |  |  | fund2 | 1.06729538593753
 |  |  | fund3 | 0.506123266029118
Spreadsheet: 748448d1632149466-conditional-formatting-based-on-future-month-and-text-sample
Sheet: sample

Date | Type
2021-07-01 00:00:00 | TARN
2021-11-12 00:00:00 | RN
2021-08-14 00:00:00 | RN
2021-08-15 00:00:00 | RN
2021-08-15 00:00:00 | RN
2021-08-17 00:00:00 | RN
2021-08-18 00:00:00 | RN
2021-08-23 00:00:00 | RN
2021-08-31 00:00:00 | RN
2021-08-15 00:00:00 | RN
2021-09-01 00:00:00 | RN
2021-09-01 00:00:00 | CN
2021-06-02 00:00:00 | TARN
2021-08-10 00:00:00 | TARN
2021-07-30 00:00:00 | RN
2021-12-03 00:00:00 | RN
2021-09-01 00:00:00 | RN
2021-07-09 00:00:00 | PN
2021-01-22 00:00:00 | TARN
2021-04-18 00:00:00 | NBRW
2021-04-18 00:00:00 | NB
2021-06-18 00:00:00 | TARN
2021-08-20 00:00:00 | NB
2021-08-21 00:00:00 | NB
2021-12-22 00:00:00 | NB
2021-11-23 00:00:00 | NB
2021-10-24 00:00:00 | NB
Spreadsheet: phillip_m_love__30675__0002 OA detail
Sheet: 3rd Party Revenue

 | 3rd Party Transport Revenue
Counterparty | [NAME] | GL Amount | Difference
Amoco Eenrgy Trading | 47029.8
Anadarko Energy Services | 25307.4
[NAME]. | 504.07 | 508.11
Chevron USA | 6429.32 | 7505.46
Conoco Inc. | 44676.47 | 44450.02
Copano Energy Services | 13105.21
Coral Energy Resources | 2635.32
Dow Hydrocarbons | 353.39 | 315.58
Duke Energy Field | 4946.67 | 4930.28
Duke Energy Trading | 1632.48
Dynegy Marketing and Trade | 111610.91 | 105772.72
El Paso Merchant Energy | 1950.54 | 1950.54
Engage Energy US | 15919.26 | 13209.42
Entex Gas Marketing | 46774.88
EOG Resources Mktg. Inc. | 38662.84 | 38624.74
Esenjay Exploration | 802.82 | 802.82
Exxon Company USA | 81209.22
Four Square Gas Company | 2076.33 | 1790.6
GulkMark Energy | 1349.27
Helmerich & Payne Inc. | 412.9
Mobil Natural Gas | 539.47 | 536.79
ONEOK Gas Mktg. | 1155.75 | 1150
PG&E Texas Pipeline | 126.63 | 30.9
Reliant Energy Entex | 103464.75
Reliant Energy Services | 42280.36 | 42070
Sempra Energy | 14572.5 | 14500
Tejas Gas Pipeline | 180.9 | 180
Tejas Ship Channel, LLC | 2937.97 | 2970.9
Texaco Exploration & Production | 14753.65 | 14629.63
Texaco Natural Gas | 192.33 | 192.33
Texas General Land Office | 33047.53 | 30898.78
TXU Lone Star
Union Pacific Resources | 5149.11 | 4750.98
Vastar Resources | 2011.46 | 1603.25
Total
4950 999
Calpine Fuels Texas |  | 911.38
CP&L |  | 387.9
Lamay |  | 350
Reliant Energy
Temple Inland |  | 5450.66
Zeneca |  | 350
Total
4950 999
1999 HMS Income |  | -37634.75 |  | Schneider
4920 951 -Condensate Sales
Riser HPL Drip |  |  | 0 | Schneider
4890 999 Tsf to Storage
Sempra Energy |  |  |  | Storage
Spreadsheet: 53307d1253199647-points-system-table-standing
Sheet: Sheet2

 | Chelsea | Vs | Hull
 | 2 |  | 1
Particpants | Chelsea |  | Hull | Actual Team A | Actual Team B | Correct goals (1) | No Goals (1) | Correct Result (3) | Win Score (3) | Draw Score (3) | Correct Match (5) | Points
[NAME] | 4 |  | 0 | 2 | 1 |  |  |  | 3 |  |  | 3
Angiiie | 2 |  | 1 | 2 | 1 | 1 |  | 3 | 3 |  | 5 | 5
Bakchang |  |  |  | 2 | 1
Blue Rascal | 3 |  | 0 | 2 | 1 |  |  |  | 3 |  |  | 3
[NAME] (1) | 2 |  | 0 | 2 | 1 | 1 |  |  | 3 |  |  | 4
[NAME] | 4 |  | 0 | 2 | 1 |  |  |  | 3 |  |  | 3
Chelseapaul | 4 |  | 0 | 2 | 1 |  |  |  | 3 |  |  | 3
[NAME] |  |  |  | 2 | 1
[NAME] | 3 |  | 0 | 2 | 1 |  |  |  | 3 |  |  | 3
Double D |  |  |  | 2 | 1
[NAME] | 4 |  | 0 | 2 | 1 |  |  |  | 3 |  |  | 3
Fookwing | 3 |  | 0 | 2 | 1 |  |  |  | 3 |  |  | 3
Harmony2828 |  |  |  | 2 | 1
[NAME] | 1 |  | 0 | 2 | 1 |  |  |  | 3 |  |  | 3
[NAME] | 3 |  | 0 | 2 | 1 |  |  |  | 3 |  |  | 3
JWNY | 5 |  | 0 | 2 | 1 |  |  |  | 3 |  |  | 3
Karthigesh | 2 |  | 0 | 2 | 1 | 1 |  |  | 3 |  |  | 4
[NAME] (1) | 2 |  | 0 | 2 | 1 | 1 |  |  | 3 |  |  | 4
[NAME] (: | 4 |  | 0 | 2 | 1 |  |  |  | 3 |  |  | 3
[NAME] | 3 |  | 0 | 2 | 1 |  |  |  | 3 |  |  | 3
Lighthouse | 2 |  | 0 | 2 | 1 | 1 |  |  | 3 |  |  | 4
[NAME] | 4 |  | 0 | 2 | 1 |  |  |  | 3 |  |  | 3
Monir | 3 |  | 1 | 2 | 1 | 1 |  |  | 3 |  |  | 4
North Stand | 2 |  | 0 | 2 | 1 | 1 |  |  | 3 |  |  | 4
[NAME] (2) | 2 |  | 0 | 2 | 1 | 1 |  |  | 3 |  |  | 4
[NAME] | 2 |  | 0 |  |  |  |  |  |  |  |  | 4
[NAME] | 2 |  | 0 |  |  |  |  |  |  |  |  | 4
petrcech
Polobear
Ray | 2 |  | 0 |  |  |  |  |  |  |  |  | 4
[NAME] | 3 |  | 0 |  |  |  |  |  |  |  |  | 3
Shevchenko
Shiesse | 3 |  | 0 |  |  |  |  |  |  |  |  | 3
Silent
Singablue | 2 |  | 0 |  |  |  |  |  |  |  |  | 4
Stellazio
Stephen | 3 |  | 0 |  |  |  |  |  |  |  |  | 3
tab
[NAME] (6) | 3 |  | 0 |  |  |  |  |  |  |  |  | 3
The Ridz
Uncle gg | 3 |  | 0 |  |  |  |  |  |  |  |  | 3
Zenden | 4 |  | 0 |  |  |  |  |  |  |  |  | 3
Spreadsheet: 92166d1291823110-lookup-for-specific-values-in-multiple-cells-export
Sheet: Tooling 

 | Area | Machine | Description | Equipment | Location | Notes
AM054F | PATT SHOP | [NAME] | CORESETTER | AM054.02 | Z3 |  | 1
AM054F | PATT SHOP | [NAME] | RAM PLATE | AM054.02 | A3 |  | 2
AM054F | PATT SHOP | [NAME] | SWING PLATE | AM054.02 | A3 |  | 3
AM054F | CORE SHOP | HANSBERG | UCB VANE INSERT | AM054B
AM054F | CORE SHOP | HANSBERG | LCB VANE INSERT | AM054B
AM054F | CORE SHOP | HANSBERG | BLOW TUBE | 3GB1
AM054F | PATT SHOP | [NAME] | SWING PL. INSERT | AM054B |  | NO INSERTS FOUND | 4
AM054F | PATT SHOP | [NAME] | ADAPTOR SET  R/S | T305 |  |  | 5
AM054F | PATT SHOP | [NAME] | ADAPTOR CSETTER | T295 |  |  | 6
AM054F | FETT SHOP | AUTO FETT | AUTOFETT JIG | JIG 1
AM054F | FETT SHOP | AUTO FETT | AUTOFETT CLAMP | CLAMP 4
AM054F | FETT SHOP | AUTO FETT | AUTOFETT LOADER | LOADER 150
AM054F | FETT SHOP | AUTO FETT | AUTOFETT GAUGE | GAUGE 4
AM054F | CORE SHOP | HANSBERG 7 | BLOW TUBE | BT03
AM054F | CORE SHOP | HANSBERG | LCB CENT. INSERT | AM054B
Spreadsheet: eric_saibi__9799__091801R
Sheet: Valley 04

Owner Name | Los Angeles Department of Water & Power
Station Name | Valley Generating Station
Unit Name | Unit 04
NERC Region | WSCC
State | CA
Fuel Type | Natural Gas
Capacity | 173 MW
Start Date | 2001-07-05 00:00:00
End Date | 2001-09-19 00:00:00
Prv. Start Date | 2001-07-08 00:00:00
Prv. End Date | 2001-09-17 00:00:00
Comments
SIC | 4911
Plant ID | 1509677
Unit ID | 1012702
Outage ID | 17270
Spreadsheet: 746963d1631138196-using-if-i-think-to-have-equation-switch-between-two-columns-example-1
Sheet: Sheet1

Account | Date 1 | Date 2 | Today | Aging | Aging Bucket |  |  |  | Account | Date 1 | Date 2 | Aging | Aging Bucket
123 |  |  | 2021-09-08 00:00:00 |  |  |  |  |  | 123
124 | 2020-07-08 00:00:00 |  | 2021-09-08 00:00:00 |  |  |  |  |  | 124 | 2020-07-08 00:00:00
125 | 2020-10-08 00:00:00 |  | 2021-09-08 00:00:00 |  |  |  |  |  | 125 | 2020-10-08 00:00:00
156 | 2019-01-04 00:00:00 |  | 2021-09-08 00:00:00 |  |  |  |  |  | 156 | 2019-01-04 00:00:00
167 | 2019-01-03 00:00:00 | 2009-11-15 00:00:00 | 2021-09-08 00:00:00 |  |  |  |  |  | 167 |  | 2009-11-15 00:00:00
138 |  | 2011-06-21 00:00:00 | 2021-09-08 00:00:00 |  |  |  |  |  | 138 |  | 2011-06-21 00:00:00
146 |  | 2011-07-18 00:00:00 | 2021-09-08 00:00:00 |  |  |  |  |  | 146 |  | 2011-07-18 00:00:00
871 |  | 2011-09-07 00:00:00 | 2021-09-08 00:00:00 |  |  |  |  |  | 871 |  | 2011-09-07 00:00:00
568 |  |  | 2021-09-08 00:00:00 | NA |  |  |  |  | 568
487 |  |  | 2021-09-08 00:00:00 | NA |  |  |  |  | 487
988 |  |  | 2021-09-08 00:00:00 | NA |  |  |  |  | 988
547 |  |  | 2021-09-08 00:00:00 | NA |  |  |  |  | 547
267 |  |  | 2021-09-08 00:00:00 | NA |  |  |  |  | 267
Spreadsheet: 792733d1661109326-rolling-total-for-points-scored-in-last-3-games-rolling-total-for-points-scored-in-last-3-games
Sheet: Totals

Name |  |  |  | 3
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Bethany
[NAME]
[NAME]
Nicki
Spreadsheet: 88641d1288433015-need-dropdown-to-auto-filter-table-and-say-custom-when-table-is-manually-filtered-dropdownautofilter
Sheet: Dropdown

I would like the DROPDOWN menu below to Auto-Filter the Data Table by GROUP (based on pre-defined combinations)
When I change GROUP filtering manually (using the table header button):
 | 1.) The [NAME] text should reflect that the table is now filtered by a custom combination (not one of the pre-defined menu choices).     It should go blank or say "CUSTOM" or "Manual Filtering"
 | 2.) The CATEGORY TITLES (Pink) should revert to the Generic categories (Other_Combinations)
(Helper Cell)
DROPDOWN: | All Groups
 |  |  |  |  |  |  |  |  | DROPDOWN MENU CHOICES
 | NAME | Group | Category1 | Category2 | Category3 | Category4 | Category5 |  | Group A
 |  |  |  |  |  |  |  |  | Group B
 |  |  |  |  |  |  |  |  | Group C
 |  |  |  |  |  |  |  |  | Group D
 |  |  |  |  |  |  |  |  | Groups A&D
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | All Groups
 | Category Titles:
 | Category | A | B | C | D | A&D | B&C | Other_Combinations
 | Category1 | BLUE | CAR | PAPER | RICH | SHOE | TRAP | CAT1 - GENERAL
 | Category2 | RED | TRUCK | PENCIL | POOR | HAT | BRUSH | CAT2 - GENERAL
 | Category3 | OLIVE | TRACTOR | INK | BEGGAR | GLOVE | BELLYBUTTON | CAT3 - GENERAL
 | Category4 | SEPIA | TRAIN | STAPLE | THIEF | PANTS | ASSAIL | CAT4 - GENERAL
 | Category5 | GREEN | UNICYCLE | PAPERCLIP | UNCLE | PAJAMAS | EXCEL | CAT5 - GENERAL
Spreadsheet: 165069d1341001011-excel-2007-finding-max-value-in-a-pivot-table-count-max-days
Sheet: Sheet1

Sum of Count | [NAME] |  |  |  |  | Hide if you want
[NAME] | Place 1 | Place 2 | Place 3 | Place 4 |  | Place 1 | Place 1
0 | 42 |  | 118 |  |  | 0 | 0
1 | 158 |  | 530 | 281 |  | 1 | 1
2 |  |  | 329 | 2 |  |  | 4
3 |  |  | 251
4 | 13 | 2 | 92 | 3 |  | 4
5 |  |  | 42
6 |  |  | 6
7 |  |  | 13
8 |  |  | 6
10 |  |  | 1
11
13 |  |  |  | 1
14 |  |  |  | 1
15 |  |  |  | 2
16
17
18
19
31
39
45
53 |  |  |  | 2
92 |  | 5
112 |  | 4
Grand Total | 213 | 11 | 1388 | 292
Spreadsheet: 275052d1383318863-having-trouble-using-matching-vlookup-between-sheets-rip-times
Sheet: Sheet1

Thickness |  | Inches |  | [NAME] |  | Time in Min |  |  | Time in Hours
Ex. | 0.25 | 240 |  | 225
Spreadsheet: 837867d1690470151-increasing-hours-to-accommodate-number-of-times-an-instructors-name-appears-academy-hours-aligw-saheer123-
Sheet: July

Name | Hours | Pay | 20 |  | AliGW
Stuti | 7
Taran | 10
Asis | 9.5
Chiraag | 7.5
Megha | 1.5
Soorya | 2.5
Amal | 4.5
 | Total
Spreadsheet: 117383d1312752055-filtering-lookup-array-question-filtered
Sheet: 44006

CONTROL CABLE
CORE CARD
Location
Cable Number |  | 44006
Number of cores |  | 4
Spare cores |  | 2
Core size |  | 4mm2
Cable Type |  | Cu, PVC
Drawing References
Cable Service |  | VT Cable, 16kV VT(VT1-GCB4), [NAME]
Panel Number | T44 PP |  | Panel Number |  | GCB4
Cable Insulation resistance >100MΩ
Core Number | Ferrule Number |  | T44 PP | INITIAL | GCB4 | INITIAL
1 | 04/BAA1304 |  | TBX4:1 |  | X83:29
2 | Spare
3 | Spare
4 | 04/BAA1305 |  | TBX4:2 |  | [NAME]
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Termination Notes | 2011-08-01 00:00:00 | Drawing shows terminal block X83:28 in wrong place |  |  |  | DJC
 |  | Core numbers (colours) chosen in keeping with G6
Edition Notes | 2011-08-01 00:00:00 | Was cable 4506 |  |  |  | DJC
Spreadsheet: c7a29b87-67f7-4c58-9478-1c33aec7a609
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3992 | 5526 | Emma | [NAME] | AUS | 31 | 00:24:17 | 00:00:00 | 01:04:49 | 00:00:00 | 00:35:17 | 1 | 02:04:21
3992 | 17660 | [NAME] | Crowley | AUS | 33 | 00:28:01 | 00:00:00 | 01:05:46 | 00:00:00 | 00:37:23 | 2 | 02:11:11
3992 | 25481 | Dinah | [NAME] | SIN | 0 | 00:32:43 | 00:00:00 | 01:09:32 | 00:00:00 | 00:44:02 | 3 | 02:26:16
3992 | 17772 | Sophie | Hawken | AUS | 34 | 00:29:01 | 00:00:00 | 01:11:24 | 00:00:00 | 00:49:59 | 4 | 02:30:22
3992 | 17903 | [NAME] | Woo [NAME] | SIN | 0 | 00:32:10 | 00:00:00 | 01:19:23 | 00:00:00 | 00:54:05 | 5 | [NAME]
3992 | 8609 | Anel | Radford | RSA | 32 | 00:25:58 | 00:00:00 | 01:10:07 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 126893d1320045824-excel-2007-find-duplicate-numbers-in-string-search-duplicate
Sheet: example

 | code | duplicate check
 | 1
 | 2
 | 3 , 6
 | 4, 5
 | 6
 | 7
 | 3
 | 4
Spreadsheet: 862965d1710517678-calendar-formulas-and-conditional-formatting-annual-calendar
Sheet: May

 |  |  |  |  |  |  |  |  | MAY
 | NOTES
Spreadsheet: 3a97a2b4-f926-43b3-a5f5-118b5b1579e3
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
08/29/2014 | Women's Cross Country | Lehigh Invitational | 05:30 PM | First Place
09/13/2014 | Women's Cross Country | PSU Spiked Shoe Invitational | 10:00 AM | Fifth Place
10/04/2014 | Women's Cross Country | Greater Louisville Classic | 10:15 AM | Second Place
10/17/2014 | Women's Cross Country | Wisconsin Adidas Invitational | 12:00 PM | Fifth Place
11/01/2014 | Women's Cross Country | Big 12 Championships
11/14/2014 | Women's Cross Country | NCAA Mid-Atlantic Regional
11/22/2014 | Women's Cross Country | NCAA Cross Country Championships
Spreadsheet: 816003d1675303293-lookup-function-s666-pq-trial
Sheet: Sheet2

 |  | Monday | Value |  | Tuesday | Value |  | Wednesday | Value |  | Thursday | Value |  | Friday | Value
 |  | 16:30:00 | 6 |  | 16:30:00 | 6 |  | 16:30:00 | 7 |  | 16:30:00 | 7 |  | 16:30:00 | 6
 |  | 17:00:00 | 7 |  | 17:00:00 | 7 |  | 17:00:00 | 8 |  | 17:00:00 | 8 |  | 17:00:00 | -
 |  | 17:30:00 | - |  | 17:30:00 | - |  | 17:30:00 | 9 |  | 17:30:00 | - |  | 17:30:00 | -
 |  | 18:00:00 | 8 |  | 18:00:00 | 8 |  | 18:00:00 | - |  | 18:00:00 | 9 |  | 18:00:00 | 7
 |  | 18:30:00 | 9 |  | 18:30:00 | - |  | 18:30:00 | 10 |  | 18:30:00 | 10 |  | 18:30:00 | -
 |  | 19:00:00 | - |  | 19:00:00 | 9 |  | 19:00:00 | - |  | 19:00:00 | - |  | 19:00:00 | 8
 |  | 19:30:00 | - |  | 19:30:00 | - |  | 19:30:00 | 11 |  | 19:30:00 | - |  | 19:30:00 | -
 |  | 20:00:00 | 10 |  | 20:00:00 | 10 |  | 20:00:00 | - |  | 20:00:00 | - |  | 20:00:00 | -
 |  | 20:30:00 | - |  | 20:30:00 | - |  | 20:30:00 | - |  | 20:30:00 | 11 |  | 20:30:00 | 9
 |  | 21:00:00 | 11 |  | 21:00:00 | 11 |  | 21:00:00 | 12 |  | 21:00:00 | - |  | 21:00:00 | -
 |  | 21:30:00 | - |  | 21:30:00 | - |  | 21:30:00 | 13 |  | 21:30:00 | 12 |  | 21:30:00 | 10
 |  | 22:00:00 | 12 |  | 22:00:00 | 12 |  | 22:00:00 | - |  | 22:00:00 | - |  | 22:00:00 | 11
 |  | 22:30:00 | - |  | 22:30:00 | 13 |  | 22:30:00 | 14 |  | 22:30:00 | 13 |  | 22:30:00
Spreadsheet: 555699d1515700189-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018-3-
Sheet: Tournament 3

 |  |  | Tournament 3 |  |  |  |  |  |  | DNP
 |  |  |  |  |  |  |  |  | # of Members Played | Did not Play | # of Players with Low Score | # of Players with MAX Score
 |  |  |  | Tournament |  | After Adjustments
 |  |  | Player | Score | Sub - Points | Actual Score | Actual Points |  | Tournament low score [NAME] (s)
 |  |  |  |  |  |  |  |  | Player | Points | Low Score
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | Enter Data into the Tournament Score column only
 |  |  |  |  |  |  |  |  | Enter DNP against the Members who DID NOT PLAY
 |  | x | x | x
Spreadsheet: 682908d1592392234-formula-indice-corresp-exemplo
Sheet: GRANEL 

DATA: 02/06
TOTAIS
VASILHA |  |  | VTN | VTUE | VBN | VBUE | VRN
TIPO | Nº. | CAP.
Sub | 1 A | 90920
Sub | 2 A | 140520 | 140520
Sub | 3 A | 136660
Sub | 4 A | 177840 |  | 177840
Sub | 5 A | 90920 |  | 90920
Sub | 6 A | 140520
Sub | 7 A | 136660 |  | 136660
Sub | 8 A | 177840
Sub | 9 A | 90920 |  | IGP
Sub | 10 A | 140520 |  | IGP
Sub | 11 A | 136660 |  | 136660
Sub | 12 A | 177840 | 177840
Spreadsheet: phillip_m_love__30504__ft-southeast value
Sheet: Sheet1

ft-southeast basis
Sum of Value
Counterparty | Total
FLORIDA | 72873.62220000003
MUNICIPALGAS | 361650.9096000001
Grand Total | 434524.5318000001
ft-southeast index
Sum of Value
Counterparty | Total
CHEVRONCHELLC | 0
CPR-NORTHEAST | 0
FLORIDASTATE | 79801.3306
Grand Total | 79801.3306