tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 31489d1227310286-counting-the-number-of-times-a-date-appears-in-a-list-date-list
Sheet: Sheet1

dos
2008-04-08 00:00:00
2008-04-10 00:00:00
2008-04-16 00:00:00
2008-04-21 00:00:00
2008-04-24 00:00:00
2008-05-01 00:00:00
2008-05-05 00:00:00
2008-05-12 00:00:00
2008-05-13 00:00:00
2008-05-14 00:00:00
2008-05-14 00:00:00
2008-05-15 00:00:00
2008-05-16 00:00:00
2008-05-21 00:00:00
2008-05-21 00:00:00
2008-05-27 00:00:00
2008-05-28 00:00:00
2008-05-28 00:00:00
2008-05-29 00:00:00
2008-05-29 00:00:00
2008-05-30 00:00:00
2008-06-02 00:00:00
2008-06-04 00:00:00
2008-06-04 00:00:00
2008-06-05 00:00:00
2008-06-06 00:00:00
2008-06-09 00:00:00
2008-06-11 00:00:00
2008-06-12 00:00:00
2008-06-13 00:00:00
2008-06-16 00:00:00
2008-06-23 00:00:00
2008-06-23 00:00:00
2008-06-24 00:00:00
2008-06-25 00:00:00
2008-06-26 00:00:00
2008-06-30 00:00:00
2008-06-30 00:00:00
2008-07-03 00:00:00
2008-07-07 00:00:00
2008-07-08 00:00:00
2008-07-08 00:00:00
2008-07-09 00:00:00
2008-07-09 00:00:00
2008-07-10 00:00:00
2008-07-17 00:00:00
2008-07-24 00:00:00
2008-07-24 00:00:00
2008-09-09 00:00:00
2008-08-06 00:00:00
2008-09-08 00:00:00
2008-07-29 00:00:00
2008-08-06 00:00:00
2008-08-07 00:00:00
2008-08-13 00:00:00
2008-08-15 00:00:00
2008-08-21 00:00:00
2008-08-21 00:00:00
2008-08-27 00:00:00
2008-09-03 00:00:00
2008-09-04 00:00:00
2008-09-11 00:00:00
2008-09-15 00:00:00
2008-09-15 00:00:00
2008-09-16 00:00:00
2008-09-22 00:00:00
2008-09-29 00:00:00
2008-09-30 00:00:00
2008-10-02 00:00:00
2008-10-06 00:00:00
2008-10-06 00:00:00
2008-10-08 00:00:00
2008-10-09 00:00:00
2008-10-10 00:00:00
2008-10-13 00:00:00
2008-10-22 00:00:00
2008-10-23 00:00:00
2008-10-30 00:00:00
2008-11-03 00:00:00
2008-11-06 00:00:00
2008-11-13 00:00:00
2008-11-13 00:00:00
2008-11-14 00:00:00
2008-11-17 00:00:00
2008-11-18 00:00:00
2008-11-21 00:00:00
Spreadsheet: 104373d1302011249-colour-change-column-chart-based-on-cell-colour-771123
Sheet: draft

CAERPHILLY LOCALITY TRAINING COMPLIANCE |  |  |  | 2011-04-05 00:00:00
<70%
70%-85%
>85%
 |  |  | Min | 0 | 0.7 | 0.85
 |  |  | [NAME] | 0.69 | 0.84 | 1
 | TOTAL STAFF | STAFF COMPLIANT | % | <70% | 70%-85% | >85%
Alert | 240 | 114 | 0.475 | 0.475 | #N/A | #N/A
Anaphylaxis | 58 | 55 | 0.9482758620689655 | #N/A | #N/A | 0.9482758620689655
Basic Life Support | 249 | 107 | 0.429718875502008 | 0.429718875502008 | #N/A | #N/A
Blood Glucose Monitoring | 43 | 6 | 0.1395348837209302 | 0.1395348837209302 | #N/A | #N/A
Blood Transfusion | 195 | 153 | 0.7846153846153846 | #N/A | 0.7846153846153846 | #N/A
[NAME] | 158 | 14 | 0.08860759493670886 | 0.08860759493670886 | #N/A | #N/A
Child Protection | 252 | 0 | 0 | #N/A | #N/A | #N/A
DSE | 6 | 2 | 0.3333333333333333 | 0.3333333333333333 | #N/A | #N/A
Equality & Diversity | 205 | 172 | 0.8390243902439024 | #N/A | 0.8390243902439024 | #N/A
Fire Safety | 81 | 29 | 0.3580246913580247 | 0.3580246913580247 | #N/A | #N/A
Food Hygiene | 294 | 49 | 0.1666666666666667 | 0.1666666666666667 | #N/A | #N/A
Health & Safety | 223 | 200 | 0.8968609865470852 | #N/A | #N/A | 0.8968609865470852
Hicc-Picc Line | 50 | 20 | 0.4 | 0.4 | #N/A | #N/A
Infection Control | 287 | 232 | 0.8083623693379791 | #N/A | 0.8083623693379791 | #N/A
Information Governance | 139 | 1 | 0.007194244604316547 | 0.007194244604316547 | #N/A | #N/A
IV's | 62 | 56 | 0.9032258064516129 | #N/A | #N/A | 0.9032258064516129
KSF/IPR | 153 | 80 | 0.5228758169934641 | 0.5228758169934641 | #N/A | #N/A
Manual Handling | 252 | 53 | 0.2103174603174603 | 0.2103174603174603 | #N/A | #N/A
Mentorship update | 48 | 31 | 0.6458333333333334 | 0.6458333333333334 | #N/A | #N/A
Personal Safety | 95 | 42 | 0.4421052631578947 | 0.4421052631578947 | #N/A | #N/A
POVA 2 | 92 | 32 | 0.3478260869565217 | 0.3478260869565217 | #N/A | #N/A
POVA 3 | 263 | 82 | 0.311787072243346 | 0.311787072243346 | #N/A | #N/A
Syringe Driver | 288 | 215 | 0.7465277777777778 | #N/A | 0.7465277777777778 | #N/A
Venepuncture | 128 | 68 | 0.53125 | 0.53125 | #N/A | #N/A
Spreadsheet: 676411d1588792845-data-validation-based-on-2-other-data-validations-investigation
Sheet: Instegation Types 

Column1 | Column2 | Column3 | Column4 |  |  |  |  |  | Column1 |  | Column1 | Column2 |  | Column1 | Column2 | Column3
Data | Theft | Intel | Server No XX |  | Stored | 1st drop down uses data in column A |  |  | Data |  | Data | Store Process Issue |  | Data | Store Process Issue | Investigation
Data | Theft | Intel | Known Suspect |  |  |  |  |  | Stored |  | Data | Theft |  | Data | Theft | Intel
Data | Theft | Intel | Unknown Suspect |  | Theft | 2nd drop down shows data from column B dependant on whats selected in 1st drop down |  |  |  |  | Data | Till |  | Data | Till | Investigation
Data | Theft | Intel | Way in |  |  |  |  |  |  |  | Data | Walk |  | Data | Walk | Intel
Data | Walk | Intel | Entance No XX |  | Intel | 3rd drop down shows data from column C dependant on 1st and 2nd drop down boxes |  |  |  |  | Stored | Theft |  | Data | Walk | Investigation
Data | Walk | Intel | Location |  |  |  |  |  |  |  | Stored | Till |  | Stored | Theft | Intel
Data | Till | Investigation | Employee Name |  | Unknown Suspect / Suspect XX seen on MDDYYYY Involved in theft of XXXXXX | this cell shows the data from column D dependant on whats selected in the other 3 drop down boxes |  |  |  |  | Stored | Walk |  | Stored | Till | Investigation
Data | Till | Investigation | Customer |  |  |  |  |  |  |  |  |  |  | Stored | Walk | Intel
Data | Walk | Investigation | Payment |  |  |  |  |  |  |  |  |  |  | Stored | Walk | Investigation
Data | Walk | Investigation | Stored
Data | Store Process Issue | Investigation | Perimeter door left unsecure out of hours
Data | Store Process Issue | Investigation | fixture not secured
Data | Store Process Issue | Investigation | High Value left unsecure
Data | Store Process Issue | Investigation | Service Area left unsecure
Data | Store Process Issue | Investigation | High Value Stock left unattended
Data | Store Process Issue | Investigation | High Value stock left unattended in warehouse
Stored | Theft | Intel | XXXX associated with known suspect. On [NAME]
Stored | Theft | Intel | Unknown Suspect / Suspect seen on MDDYYYY
Stored | Theft | Intel | Unknown Suspect / Suspect XX seen on MDDYYYY Involved in theft of XXXXXX
Stored | Walk | Intel | Payment fails resulting in XXXXXX
Stored | Till | Investigation | XXXX fails to follow process after [NAME]
Stored | Walk | Investigation | Payment fails resulting in xxxxx fails to follow process
Spreadsheet: 52607d1252451235-getting-data-to-display-from-an-adjacent-cell-example-header
Sheet: Test data sheets1

FJTEXTDATA
16
$TOT | 1904
$FIL | Test.txt
$PAR | 2
$P1R | 5000
$P1S | Area
$[NAME] | P1
$P1B | 16
$P1G | 1
$P1E | 0, 0
$P2R | 2
$P2S | Cell Shape
$P2N | p2
$P2B | 16
$[NAME] | 1
$P2E | 0, 0
$[NAME] | L
Spreadsheet: 135049d1325776035-cost-calculation-based-on-more-than-one-variable-sstepro-example
Sheet: Sheet1

CATEGORY 1 |  |  | CATEGORY 2 |  |  | CATEGORY 3
1' Imagery |  |  | 1' Imagery |  |  | 1' Imagery
Cost Area | Per tile cost |  | Cost Area | Per tile cost |  | Cost Area | Per tile cost
1 | 5 |  | 1 | 7 |  | 1 | 9
2 | 9 |  | 2 | 12 |  | 2 | 14
3 | 15 |  | 3 | 17 |  | 3 | 20
LiDAR |  |  | LiDAR |  |  | LiDAR
Cost Area | Per tile cost |  | Cost Area | Per tile cost |  | Cost Area | Per tile cost
1 | 19 |  | 1 | 22 |  | 1 | 24
2 | 25 |  | 2 | 26 |  | 2 | 28
3 | 27 |  | 3 | 28 |  | 3 | 30
Spreadsheet: 809254d1670992366-coloring-cells-based-on-a-formula-book2
Sheet: Sheet1

 |  | 1 | Text A | 1, 3, 5
 |  | 2 | Text B | 1
 |  | 3 | Text C | 4
 |  | 4 | Text D | 3, 4
 |  | 5 | Text E | 7
 |  | 6 | Text F
 |  | 7 | Text G | 2
 |  |  | D5 should be GREEN if the count of C5 in the range (E5 to E11) is greater than 1
 |  |  | D5 should be YELLOW if the count of C5 in the range (E5 to E11) is 1
 |  |  | D5 should be RED if the count of C5 in the range (E5 to E11) is less than 1
Spreadsheet: 103721d1301444624-vlookup-applied-to-mulitple-cells-based-on-dropdown-testbook
Sheet: Sheet1

shirt | 1 | What size?
shirt | 2 | What color?
shirt | 3 |  |  | pants
pants | 1 | waist size? | 1
pants | 2 | length? | 2
pants | 3 | style? | 3
shoes | 1 | size?
shoes | 2 | style?
shoes | 3 | color?
Spreadsheet: 177333d1346265929-sumproduct-and-sumifs-using-multiple-criteria-across-worksheets-sumifs
Sheet: 4

 |  |  | 1
 |  |  |  |  | Condition1 |  |  |  |  | Condition2
Spreadsheet: 103693d1301420648-golf-spreadsheet-golf-par-for-less-than-18-holes
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par | par |  |  | holes played | Par
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Out | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | In | Total | Played Front | [NAME] | par played | [NAME]
 | Par | 4 | 3 | 5 | 4 | 4 | 4 | 5 | 3 | 4 | 36 | 5 | 4 | 3 | 4 | 4 | 3 | 4 | 4 | 5 | 36 | 72 | 36 | 29 | 65 |  | 1 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 7
 | Scores | 5 | 4 | 4 | 5 | 4 | 4 | 6 | 3 | 5 | 40 | 6 | 4 | 3 | 3 | 5 | 4 | 4 |  |  | 29 | 69 | 9 | 7 |  | 16 | 3 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 52
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 59
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 63
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 67
Spreadsheet: 94237d1294098648-and-function-rj-nursery-stock-records
Sheet: Sheet1

Nursery Stock Tracking Records
[NAME] | [NAME] (QO) | Import Permit (IP) Number | Type of Plant material | Importer's Name | Address or Company name | Consignment Total | Fumigation Date | Inspection Date | Other Treatment Date | Isolation Completed | Status | Other Comments | PDI | Results
23.06.08 | T08000186 | IP | [NAME] | Tas berry Gardens | 123 Test Data Street | 100000 | 2011-01-01 00:00:00 | 2011-01-05 00:00:00 | N/A | 2011-03-05 00:00:00 |  | Sent To knoxfield
19.05.09 |  |  |  |  |  |  | 2011-01-01 00:00:00 | 2011-01-05 00:00:00 |  | 2011-03-05 00:00:00
28.07.09 |  |  |  |  |  |  | 2011-01-01 00:00:00 |  | N/A | 2011-03-05 00:00:00
04.11.09 |  |  |  |  |  |  |  | 2011-01-05 00:00:00 | N/A | 2011-03-05 00:00:00
04.11.09 |  |  |  |  |  |  | N/A | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-03-05 00:00:00
24.02.10
Spreadsheet: fletcher_sturm__11004__Power Trading Start2
Sheet: East Power Products

East Power Product List
Location | Physical / | Peak /
 | Financial | Off-Peak
Northeast |  |  |  | Term List | 2002 | 2003
PJM | Phys. / Fin. | Peak / Off-P |  | Hourly | *  see below | *  see below
NEPool | Phys. / Fin. | Peak / Off-P |  | Daily | yes | no
NY Zone A | Fin. | Peak / Off-P |  | Bal. Wk. | yes | no
NY Zone G | Fin. | Peak / Off-P |  | Bal. Mo. | yes | no
NY Zone J | Fin. | Peak / Off-P |  | Feb | yes | no
 |  |  |  | [NAME] | yes | yes
 |  |  |  | May | yes | yes
Midwest |  |  |  | Jun | yes | yes
Cinergy | Phys. / Fin. | Peak / Off-P |  | Jul - Aug | yes | yes
ComEd | Phys. | Peak / Off-P |  | Sep | yes | yes
TVA | Phys. | Peak |  | Q4 | yes | yes
 |  |  |  | Cal | yes | yes
 |  |  |  | Jan - Feb | no | yes
Southeast
Entergy | Phys. | Peak |  | *  Hourly and Day-Ahead financial markets available
Soco | Phys. | Peak / Off-P |  | online for ISO pool markets only:
 |  |  |  | PJM, NEPool, NY, and ERCOT
ERCOT | Phys. | Peak / Off-P
Spreadsheet: john_zufferli__16805__marks
Sheet: Sheet1

 |  |  |  |  |  |  | Jan 4 2002
 |  | *2001 actual published PP
 |  |  | flat | on | off |  | 2002 | BID | OFFER | MID
 |  | JAN* | 131.23 | 145.5 | 113.1 |  | JAN | 34.5 | 36
 |  | FEB* | 116.75 | 134.4 | 93.16 |  | FEB | 33 | 34
 |  | MAR* | 97.23 | 114.6 | 73.12 |  | MAR | 34 | 34.75
 |  | APR* | 114.82 | 138.4 | 85.25 |  | APR | 32 | 34
 |  | MAY* | 88.34 | 107.4 | 61.85 |  | MAY | 32 | 34
 |  | JUN* | 63.59 | 79.85 | 41.34 |  | JUN | 32 | 34
 |  | JUL* | 53.47 | 64.64 | 40.48 |  | JUL | 36 | 38
 |  | AUG* | 52.37 | 63.54 | 36.91 |  | AUG | 36 | 38
 |  | SEP* | 29.84 | 35.9 | 23.11 |  | SEP | 36 | 38
 |  | OCT* | 43.92 | 54.2 | 29.73 |  | OCT | 38.5 | 39.5
 |  | NOV* | 33.31 | 42.28 | 22.09 |  | NOV | 38.5 | 39.5
 |  | DEC | 33.3 |  |  |  | DEC | 38.5 | 39.5
 |  |  |  |  |  |  | Cal 2002
Spreadsheet: geir_solberg__11283__12-16act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: mike_grigsby__27821__HS_WESTminusPA1029
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEST NATURAL GAS BASIS POSITIONS
 | West Region Basis Notional
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month | Change | Prompt Month | Change | Winter 2001-02 | Change | Summer 2002 | Change | Winter 2002-03 | Change | Remainder | Change | Total | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  | RISK TYPE |  | 1
 | West Region Basis Notional
 | NGI-PGE/CG |  |  |  | NGI-PGE/CG |  | GDP-PG&E/CITIGA | NGI-PGE/CG | GDP-PG&E/LG-PKG |  |  |  | M | D
 | NGI-MALIN |  |  |  | NGI-MALIN |  | GDP-MALIN-CTYGA | NGI-MALIN |  |  |  |  | M | D
 | NGI-SOCAL |  |  |  | NGI-SOCAL | IF-SOCAL | GDP-CAL BORDER | NGI-SOCAL |  |  |  |  | M | D
 | TOPOCK |  |  |  | NGI-SOBDR-PG&E |  | NGI-SOBDR-PG&E |  |  |  |  |  | M | D
 | NWPL-ROCKIES |  |  | NW-STANFIELD | IF-NWPL_ROCKY_M | IF-QUESTAR | GDP-WYOMING | GDP-KERN/OPAL | GDP-NW STANFIEL | IF-NWPL_ROCKY_M | IF-QUESTAR | GDP-NWPL_ROCKYM | M | D
 | CIG-ROCKIES | IF-CIG/WINDRVR | IF-CIG/WIC | IF-CIG/RKYMTN | IF-CIG/SOUTHERN | IF-CIG/GLENROCK | IF-CIG/ROCKPORT | GDP-CIG/RKYMTN | GDP-CIG/CHEYENN | IM-CIG/SOUTHERN | IM_WINDRIVER |  | M | D
 | PERMIAN |  | IF-TW/PERMIAN |  | IF-ELPO/PERMIAN | IF-NNG/TOK | GDP-ELPO/PERM2 | IF-ELPO/PERMIAN | IF-TW/PERMIAN |  |  |  | M | D
 | SAN JUAN |  | IF-BONDAD(100%) | IF-ELPO/SJ | IF-EPSJ(BONDAD) |  | GDP-ELPO/SANJUA |  | IM-TW/SJ | IF-EPSJ(BONDAD) |  |  | M | D
 | KINGSGATE |  |  |  | CGPR-KINGSGATE |  | CGPR-KINGSGATE |  |  |  |  |  | M | D
 | WAHA |  |  |  | IF-WAHA-TX | IF-WAHA | WAHA KCBT | GDP-WAHA |  |  |  |  | M | D
 | Other |  |  |  |  |  |  |  |  |  |  |  | M | D
 | TOTAL
 | Western Canada Region Notional
 | SUMAS |  |  |  | IF-NTHWST/CANBR |  | SUMAS-US/IM | GDP-NTHWST/CANB | IF-NTHWST/CANBR |  |  |  | m | D
 | AECO/EMPRESS/STA2 |  |  |  | CGPR-AECO/BASIS |  | GD-CGPR-AECO/AV | GD-AECOCD/FRWKD | GD-AECOUS/FRWKD | [NAME] | GDP-AECO |  | m | D
 | Other |  |  |  |  |  |  |  |  |  |  |  | M | D
 | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | p
 | West Summary |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month | Change | Prompt Month | Change | Winter 2001-02 | Change | Summer 2002 | Change | Winter 2002-03 | Change | Remainder | Change | Total | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  | RISK TYPE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 |  | 2001-11-01 00:00:00 |  | Dec-01/Mar-02 |  | Apr-02/Oct-02 |  | Nov-02/Mar-03 |  | Apr-03/Mar-29
 | CALIFORNIA
 | Socal
 | PG&E CTYG & TOPOCK
 | Malin
 | NorthWest
 | Sumas
 | Aeco & Kingsgate
 | Rockies (NW & CIG)
 | SouthWest
 | San Juan
 | Permian
 | Waha
Spreadsheet: 761772d1641214348-multiply-specific-cells-with-criteria-example
Sheet: Sheet1

2022-01-01 00:00:00 | 3 | 1.45 | Product 1 =5.76971 | Expected result is : Product of C1*C2*C3*C4*C5*C6=1.45*1.65*1.13*1.19*1.47*1.22=5.76971. Product of C7*C8=1.72*1.34=2.30. Product of C9*C10*C11*C12*C13=1.5*1.82*2.15*1.9*1.83=20.40
2022-01-01 00:00:00 | 3 | 1.65
2022-01-01 00:00:00 | 3 | 1.13
2022-01-01 00:00:00 | 3 | 1.19
2022-01-01 00:00:00 | 3 | 1.47
2022-01-01 00:00:00 | 3 | 1.22
2022-01-01 00:00:00 | 5 | 1.72 | Product 2 =2.30
2022-01-01 00:00:00 | 5 | 1.34
2022-01-02 00:00:00 | 0.52 | 1.5 | Product 3 =20.40
2022-01-02 00:00:00 | 0.52 | 1.82
2022-01-02 00:00:00 | 0.52 | 2.15
2022-01-02 00:00:00 | 0.52 | 1.9
2022-01-02 00:00:00 | 0.52 | 1.83
Spreadsheet: chris_germany__1885__Oglethorpe2001_05
Sheet: Oglethorpe2001_05

Sales_Sub_Contract_Name | Delivery_Start_Date | Delivery_End_Date | Pipeline_Id | Pipeline_Point_Code | Point_Name | Quantity | Quantity_Unit_Id | Unit_Price | Statement_Amount
766316 | 5/3/2001 00:00:00 | 5/3/2001 00:00:00 | TRCO | 3162 | DOYLE POWER PLANT | 4250 | MMBtu | 4.9 | 20825
793871 | 5/17/2001 00:00:00 | 5/17/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP | 32000 | MMBtu | 4.4 | 140800
774325 | 5/8/2001 00:00:00 | 5/31/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP |  |  | 1 | 93835
774325 | 5/8/2001 00:00:00 | 5/8/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP | 4500 | MMBtu | 4.395 | 19777.5
774325 | 5/9/2001 00:00:00 | 5/9/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP | 10000 | MMBtu | 4.29 | 42900
774325 | 5/10/2001 00:00:00 | 5/10/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP | 10000 | MMBtu | 4.2 | 42000
774325 | 5/11/2001 00:00:00 | 5/11/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP | 5500 | MMBtu | 4.245 | 23347.5
774325 | 5/18/2001 00:00:00 | 5/18/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP | 15000 | MMBtu | 4.29 | 64350
774325 | 5/25/2001 00:00:00 | 5/25/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP | 1893 | MMBtu | 4.22 | 7988.46
774325 | 5/31/2001 00:00:00 | 5/31/2001 00:00:00 | TRCO | 6991 | STATION 85 MLP | 5 | MMBtu | 3.825 | 19.13
774072 | 5/1/2001 [NAME] | 5/31/2001 00:00:00 | TRCO | 3162 | DOYLE POWER PLANT | 77407 | MMBtu | 0 | 0
774072 | 5/1/2001 [NAME] | 5/31/2001 00:00:00 | TRCO | 3162 | DOYLE POWER PLANT |  |  | 0.1861 | 14405.44
Spreadsheet: 125681d1319158364-sumif-on-multiple-sheets-feb-2010
Sheet: Feb 2010

Render | Charge Amount | Payments | wRVUs
Physician 1 | 45158 |  | 1.01
Physician 1 | 60254 |  | 0.25
Physician 1 | 150444 |  | 0.45
Physician 1 | 6414 |  | 6.5
Physician 1 | 84156 |  | 6.1
Physician 1 | 84456 |  | 1.1
Physician 2 | 1725 |  | 5.8
Physician 2 | 1014 |  | 5.2
Physician 2 | 4977 |  | 2.5
Physician 2 | 7414 |  | 3.1
Physician 2 | 1009 |  | 7.4
Physician 2 | 8897 |  | 0.22
Physician 2 | 98745 |  | 8.69
Spreadsheet: 884798d1734068868-sliding-scale-scoring-function-based-on-time-time_based_scoring-1
Sheet: Sheet1

Airline | Dep | Arr | Duration | Dep | Arr | Duration | Total | Per person | Airline Quality | TripAdvisor rating | Outbound time | Duration | Inbound  time | Price | Reviews | Total
 | OUTBOUND |  |  | RETURN |  |  |  |  |  |  | SCORING
Qatar/BA | 14:55:00 | 12:05:00 | 14h 10m | 08:10:00 | 17:25:00 | 16h 15m | 2053 | 1026.5 | 7/10 | 4/5
Thai | 01:50:00 | 06:15:00 | 11h 25m | 00:05:00 | 06:40:00 | 13h 35m | 2047.24 | 1023.62 | 6/10 | 4/5
Oman | 20:05:00 | 17:05:00 | 14h 40m | 09:15:00 | 18:25:00 | 16h 10m | 1430 | 715 | 6/10 | 3.5/5
Spreadsheet: mark_whitt__25157__Process Flow Chart
Sheet: Sheet1

 |  |  | Commercial |  |  | checks
 |  | cash |  | cash
 |  |  | Accounting
 |  |  |  | cash packet
 |  |  | <group>
 |  |  | [NAME]
 |  |  | ENA Accounting
 |  |  | [NAME]
 |  |  | Underwriting
 |  |  | Chip | [NAME]
 |  |  | Schneider | Larson
 |  |  | [NAME]
 |  |  | Cash Management Committee
 |  |  | Treasury
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  |  |  | checks
 |  |  |  |  |  |  | [NAME]
 |  |  | wires | ??? |  |  | [NAME]
 |  |  | direct
Spreadsheet: 97fdc932-fcbd-4320-97d0-2dab2061e320
Sheet: Page 3

DIVISION OF WATER RESOURCES TAX CERTIFICATION & EXEMPTION APPLICATION |  |  |  |  |  |  |  |  |  | PAGE 3
Waste Treatment Systems & Equipment:  Waste treatment systems & equipment must be used exclusively for the abatement of water pollution |  |  |  |  |  |  |  |  |  | Rev 09/01/2013
For County Use Only |  | For DWR Use Only "A" Approved "D" Disapproved | Description of Waste Treatment Systems or Equipment | Was asset listed in the permit (Yes/No)           * | Asset Number, Vehicle Identification Number (VIN) | How is this equipment used for pollution abatement? | % of Use for Pollution Abatement | Year of Acquisition | Original Historical Cost** | Is this asset replacing a prior asset?
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
Attach additional pages if necessary
*   If the asset is listed in the DWR permit, the description must be identical as listed on the current permit.  If the asset is not specifically listed in the DWR permit, the applicant must attach detailed information as to why the asset should qualify for Tax Certification.
** When certifying systems or equipment, DENR is not certifying the cost of the equipment or the year of acquisition.
Applicant |  |  |  |  | Title: |  |  | Date:
Signature |  |  |  |  | Of:
 |  |  | (print name also) |  |  | (Name of Applicant Business Entity)                                                                                                                                                             TC-WQ
NOTICE:  The penalty for false statement, representation or certification                              herein includes imprisonnment and/or the assessment of civil penalties.
Spreadsheet: 845137d1696664414-generate-a-receipt-from-repeat-customer-file-hotel
Sheet: Clients

Unique ID | Name | First name | [NAME] | Phone
1 | Doe | [NAME]
2 | [NAME] | [NAME]
3 | Smith | [NAME]
4 | [NAME] | [NAME]
5 | [NAME] | [NAME]
Spreadsheet: 849794d1700174580-extract-list-of-all-partial-matches-after-comparing-two-columns-excelforumassit
Sheet: Review (2)

Record ID | Order Number | [NAME]
128417 | 5A59864E 5A59864E1 5A59864E2 5A59864E3 5A59864E4 | 5A16721E
128418 | 5A16721E 5A59642E1 5A59642E2 5A59642E3 5A59642E4 | 5A16755E
128419 | 5A16721E | 5A26509E
128420 | 5A51237E | 5A34172E
128421 | 5A50232E | 5A37407E
128422 | 5A16722E | 5A40708E
112590 | 5A51806E | 5A40782E
113511 | 5A52262E | 5A43624E
115089 | 5A46056E | 5A45926E
116564 | 5A54044E | 5A46056E
116658 | 5A54356E | 5A46060E
116758 | 5A52957E | 5A46061E
118700 | 5A54961E | 5A46062E