tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 220486d1363180098-extract-non-zero-value-data-sample
Sheet: Sheet1

 |  | Models
 |  | [NAME] | Helen | [NAME] | Isabel
 | Product Code | Unit Price | Unit Price | Unit Price | Unit Price
 | Door x 40 | 100 | 90 | 0 | 0
 | Door x 41 | 110 | 100 | 0 | 91
 | Door x 42 | 0 | 0 | 85 | 100
 | Door x 43 | 95 | 0 | 85 | 0
 | Door x 44 | 81 | 0 | 90 | 0
 | Door x 45 | 95 | 95 | 100 | 115
 | Door x 46 | 0 | 110 | 105 | 105
 | Door x 47 | 0 | 92 | 95 | 0
 | Door x 48 | 112 | 0 | 0 | 85
 | Door x 49 | 0 | 100 | 0 | 0
 | Door x 50 | 83 | 95 | 0 | 95
 | Door x 51 | 0 | 100 | 0 | 0
 | Door x 52 | 110 | 110 | 85 | 85
 | Door x 53 | 0 | 104 | 95 | 95
 | Door x 54 | 112 | 112 | 0 | 100
 | Door x 55 | 0 | 95 | 95 | 95
 | Door x 56 | 95 | 0 | 0 | 0
 | Door x 57 | 0 | 0 | 0 | 0
 | Door x 58 | 102 | 100 | 105 | 120
 | Door x 59 | 100 | 0 | 85 | 110
 | Door x 60 | 100 | 100 | 95 | 110
Spreadsheet: 215002d1361221331-sumproduct-statement-atlanta-rsa-survey-trends-130218
Sheet: Pooler, GA

 | 2012 Q1 | 2012 Q2 | 2012 Q3 | 2012 Q4 | 2013 Q1 | 2013 Q2 | 2013 Q3 | 2013 Q4 | Q1-Q2 Variance | Q2-Q3 Variance | Q3-Q4 Variance | Q4-Q1 Variance | Q1-Q2 Variance | Q2-Q3 Variance | Q3-Q4 Variance
Total Surveys Completed | 17 | 10 | 18 | 13 | 3
Overall Pharmacy Average | 3.856621947024424 | 3.983959899749374 | 4.055796353629171 | 4.311955588271378 | 4.105263157894737
Ease of ordering (e.g. fax, phone) process | 3.625 | 0 | 4 | 4.230769230769231 | 3.333333333333333
Medication accuracy (i.e. Right Drug/Right Patient) | 4 | 4.2 | 4 | 4.461538461538462 | 3.666666666666667
Spreadsheet: 804903d1668432950-normalizing-dates-sample_date_file_111422
Sheet: Sample

Account Number | Account Description | Payee | Transaction Description | Cost Center | Date | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Date | Desired Outcome
1 | Some Account | Unassigned | Sample 1 | Some Cost 1 | 31 |  |  | 1620734 |  |  |  |  |  |  |  | 2022-03-31 00:00:00
1 | Some Account | Unassigned | Sample 2 | Some Cost 2 | 1 |  |  |  | -1620734 |  |  |  |  |  |  | 2022-04-01 00:00:00
1 | Some Account | Unassigned | Sample 3 | Some Cost 3 | 30 |  |  |  |  |  | 3516783 |  |  |  |  | 2022-06-30 00:00:00
1 | Some Account | Unassigned | Sample 4 | Some Cost 4 | 1 |  |  |  |  |  |  | -3516783 |  |  |  | 2022-07-01 00:00:00
1 | Some Account | Unassigned | Sample 5 | Some Cost 5 | 30 |  |  |  |  |  |  |  |  | 4697089 |  | 2022-09-30 00:00:00
1 | Some Account | Unassigned | Sample 6 | Some Cost 6 | 30 |  |  |  |  |  |  |  |  | 233275 |  | 2022-09-30 00:00:00
1 | Some Account | Unassigned | Sample 7 | Some Cost 7 | 8 |  | -500 |  |  |  |  |  |  |  |  | 2022-02-08 00:00:00
Spreadsheet: tracy_geaccone__40260__C0366-112458
Sheet: Dept_100192

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
CAFETERIA - Dept. 100192
June, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-06-21 00:00:00 | CFT2001/06-0366/112458 |  | Work Place | Work Place Count | 2 | 14.08 | /MNTH | 28.16
 |  |  |  |  |  |  | Ticket Total |  | 28.16
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 28.16
 |  |  |  |  |  |  | Total for Dept_100192 |  | 28.16
Spreadsheet: 745771d1630178218-compare-two-columns-in-two-sheets-to-remove-duplicates-and-return-one-copy-only-book1-4-
Sheet: Sheet1

Column1
2021 - NTOR ( 3.0 -AM )
2021 - Cor T ( 1.4-Sty-Cloth )
2021 - NTOR ( 3.0 -AM-PLUS )
2021 - TERA ( 3.6 - CL )
2021 - GIT ( 2.0 -R Line )
2021 - GIT ( 2.0 -Eleg )
2021 - TERA ( 3.6 - HL )
2021 - GIT ( 1.4 -Life )
2021 - ITG - P2 ( Leather )
2021 - SSAP ( 2.5 -TL )
2021 - Cor T ( 1.4-TL )
2021 - Cor T ( 1.4-Sty-Leather )
Spreadsheet: 215477d1361389246-searchign-for-multple-combination-of-string-text-test-workbook
Sheet: Sheet1

Reference list |  |  | Data | Desired Result
abc |  |  | abc fjs fjs rjw
def |  |  | def tue asq | def
ghi |  |  | abc djs def | abc def
jkl |  |  | shw wuq aui | -
mno |  |  | muw jkl qwe | jkl
pqr
[NAME]
vwxyz
Spreadsheet: louise_kitchen__23097__EES Risk - Ops - IT
Sheet: EWS Retail

 | Retail Risk Management - Power | 1 | [NAME] |  | EAM, etc.
 |  | 1 | Misra, Narsimha |  |  | 1 | Ozzie Pagan
 |  | 1 | Ring, Richard |  |  | 1 | [NAME]
 |  | 1 | [NAME], [NAME] |  |  | 1 | [NAME]
 |  | 1 | Padron, [NAME] |  |  | 1 | [NAME]
 |  | 1 | Wagner, [NAME] |  |  | 1 | [NAME]
 |  | 1 | Hemani, Sanjay |  |  | 1 | [NAME]
 |  | 1 | Moore, [NAME] |  |  | 1 | [NAME]
 |  | 1 | [NAME], [NAME] |  |  | 1 | [NAME]
 |  | 1 | Sharfman, [NAME]
 |  | 1 | [NAME], [NAME]
 |  | 1 | [NAME]
 |  | 1 | [NAME]
 |  | 1 | [NAME]
 |  | 1 | Santucci, [NAME]
 | Retail Structuring / Phoenix | 1 | Aucoin, [NAME]
 |  | 1 | [NAME], [NAME]
 |  | 1 | Cross, [NAME]
 |  | 1 | Jones, [NAME]
 |  | 1 | Pan, Liqun
 |  | 1 | Simoes, Catherine
 |  | 1 | Persson, [NAME]
 | URM | 1 | [NAME]
 |  | 1 | [NAME], [NAME]
 |  | 1 | Vaze, Sunil
 |  | 1 | Savage, [NAME]
 |  | 1 | Stoness, [NAME]
 |  | 1 | Ulrich, [NAME]
 |  | 1 | Brown, [NAME]
 |  | 1 | Vita, [NAME]
 |  | 1 | Farrar, [NAME]
 |  | 1 | Swain, [NAME]
 |  | 1 | Butler, [NAME]
 |  | 1 | [NAME], [NAME]
 |  | 1 | Parikh, [NAME]
 |  | 1 | [NAME], Mina
 |  | 1 | Jenarro, [NAME]
 |  | 1 | Merrill, [NAME]
 |  | 1 | Paynter, [NAME]
 |  | 1 | Surface, [NAME]
 |  | 1 | [NAME], [NAME]
 |  | 1 | Datta, [NAME]
 |  | 1 | [NAME], [NAME]
 | Gas | 1 | [NAME]
 |  | 1 | [NAME]
 |  | 1 | [NAME]
 |  | 1 | [NAME]
 |  | 1 | [NAME]
 |  | 1 | [NAME]
 |  | 1 | [NAME]
 |  | 1 | [NAME]
 |  | 1 | [NAME]
 |  | 1 | [NAME]
 |  | 1 | Barend Vanderhorst
 |  | 1 | [NAME]
 |  | 1 | [NAME]
 |  | 1 | [NAME]
 |  | 1 | [NAME]
 |  | 1 | [NAME]
 | Total
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 11a

Product1 | Cleared2 | Uncleared | TOTAL
Cross-Currency Basis | 0 | 616 | 616
Cross-Currency Fixed-Fixed | 0 | 43 | 43
Cross-Currency Fixed-Float | 0 | 158 | 158
TOTAL | 0 | 817 | 817
Spreadsheet: 683553d1592827434-and-or-in-ifstatement-from-range-of-columns-test-workbook
Sheet: Test Sheet

Job Title | Job Number | Customer Name | Customer Reference | [NAME] | Order Date | Auditor Name | Audit Date | Quality Check Protocal | 1st Line |  |  | 2nd Line | 3rd Line |  | Pass or Fail?
 |  |  |  |  |  |  |  | Sufficent Quality | Audit Check 1 | Audit Check 2 | Audit Check 3 | Audit Check 4 | Audit Check 5 | Audit Check 6
Job Title 1 | Random Number 1 | Customer Name 1 | Randon Number 1 | [NAME] 1 | 2020-11-22 00:00:00 | Auditor Name 1 | 2020-11-23 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Job Title 2 | Random Number 2 | Customer Name 2 | Randon Number 2 | [NAME] 2 | 2020-11-23 00:00:00 | Auditor Name 3 | 2020-11-23 00:00:00 | Yes | No | Yes | No | Yes | No | No
Job Title 3 | Random Number 3 | Customer Name 3 | Randon Number 3 | [NAME] 2 | 2020-11-22 00:00:00 | Auditor Name 2 | 2020-11-23 00:00:00 | Yes | Yes | Yes | Yes | Yes | No | No
Job Title 4 | Random Number 4 | Customer Name 4 | Randon Number 4 | [NAME] 4 | 2020-11-25 00:00:00 | Auditor Name 2 | 2020-11-23 00:00:00 | No | Yes | Yes | Yes | Yes | Yes | Yes
Job Title 5 | Random Number 5 | Customer Name 5 | Randon Number 5 | [NAME] 3 | 2020-11-22 00:00:00 | Auditor Name 1 | 2020-11-23 00:00:00 | No | No | No | No | No | Yes | No
Job Title 6 | Random Number 6 | Customer Name 6 | Randon Number 6 | [NAME] 1 | 2020-11-27 00:00:00 | Auditor Name 2 | 2020-11-23 00:00:00 | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Spreadsheet: 470767d1468631883-excel-chart-with-multiple-data-excel-chart
Sheet: Sheet1

 | Individual POA Errors
Associate | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00
[NAME] | 0.8812820512820513 | 0.9239130434782609 | 0.9185416666666667 | - | - | - | - | - | -
[NAME] | 0.8685365853658537 | 0.8009259259259259 | 0.912613981762918 | - | - | - | - | - | -
Ishwarya Mohan | 0.9090673575129533 | 0.9277372262773723 | 0.949436090225564 | - | - | - | - | - | -
Vinod [NAME] | 0.8723350253807106 | 0.8872881355932204 | 0.902547770700637 | - | - | - | - | - | -
[NAME] | 0.9329015544041451 | 0.9028846153846154 | 0.9381481481481481 | - | - | - | - | - | -
[NAME] | 0.8963800904977376 | 0.7354838709677419 | - | - | - | - | - | - | -
[NAME] | 0.9266816143497758 | 0.8874358974358975 | 0.9507722007722008 | - | - | - | - | - | -
[NAME] | 0.9327354260089686 | 0.9017647058823529 | 0.8845381526104418 | - | - | - | - | - | -
Yaswanth Dharan | 0.9740030674846626 | 0.8973282442748092 | 0.8981566820276498 | - | - | - | - | - | -
[NAME] | - | 0.7681818181818182 | 0.66375 | - | - | - | - | - | -
[NAME] | 0.8294258373205742 | 0.7317535545023696 | 0.9286259541984733 | - | - | - | - | - | -
Spreadsheet: 44624d1243404108-index-match-and-multiple-values-schedexample
Sheet: Sheet1

Name | 2009-01-01 00:00:00 | 2009-01-02 00:00:00 | 2009-01-03 00:00:00 | 2009-01-04 00:00:00 | 2009-01-05 00:00:00 | 2009-01-06 00:00:00 | 2009-01-07 00:00:00 | 2009-01-08 00:00:00 | 2009-01-09 00:00:00 | 2009-01-10 00:00:00 | 2009-01-11 00:00:00 | 2009-01-12 00:00:00 | 2009-01-13 00:00:00 | 2009-01-14 00:00:00 | 2009-01-15 00:00:00 | 2009-01-16 00:00:00 | 2009-01-17 00:00:00 | 2009-01-18 00:00:00 | 2009-01-19 00:00:00 | 2009-01-20 00:00:00 | 2009-01-21 00:00:00 | 2009-01-22 00:00:00 | 2009-01-23 00:00:00 | 2009-01-24 00:00:00 | 2009-01-25 00:00:00 | 2009-01-26 00:00:00 | 2009-01-27 00:00:00 | 2009-01-28 00:00:00 | 2009-01-29 00:00:00 | 2009-01-30 00:00:00 | 2009-01-31 00:00:00
[NAME] | D |  |  | D | D |  |  |  | D | D |  |  | D | D | D |  |  | D | D |  |  |  | D | D |  |  | D | D | D
Teresa | D |  |  | D | D |  |  |  | D | D |  |  | D | D | D |  |  | D | D |  |  |  | D | D |  |  | D | D | D
[NAME] |  | D | D |  |  | D | D | D |  |  | D | D |  |  |  | D | D |  |  | D | D | D |  |  | D | D |  |  |  | D | D
[NAME] |  | D | D |  |  | D | D | D |  |  | D | D |  |  |  | D | D |  |  | D | D | D |  |  | D | D |  |  |  | D | D
[NAME] | D | D |  |  | D | D | D |  |  | D | D |  |  | D |  | D |  |  | D | D | D |  |  | D | D |  |  | D |  | D
[NAME] |  |  | D | D |  |  | D | D | D |  |  | D | D |  | D |  | D | D |  |  | D | D | D |  |  | D | D |  | D |  | D
Date | 2009-01-09 00:00:00
Spreadsheet: 788965d1658825468-find-price-range-ex
Sheet: Foglio1

Item | Range | Min | [NAME] |  |  |  | Range
itemA | Range1 | 80 | 119 |  | itemA | 125 | ???
itemA | Range2 | 120 | 139
itemA | Range3 | 140 | 165
itemA | Range4 | 166 | 195
itemA | Range5 | 196 | 245
itemA | Range6 | 246 | 295
itemA | Range7 | 296 | 350
itemB | Range1 | 15 | 39
itemB | Range2
itemB | Range3 | 40 | 80
itemB | Range4 | 81 | 101
itemB | Range5 | 102 | 178
itemB | Range6 | 179 | 200
itemB | Range7 | 201 | 220
Spreadsheet: 51a327bf-938f-41a9-ae0f-ced254fc7321
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Iowa Menu Production Work Sheet | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
Date |  |  |  |  |  | Traditional Food Based Menu Planning--Breakfast |  |  |  |  |  |  |  |  |  |  | Meal Counts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grade Group | Planned | Actual
School
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K-12
Offer [NAME]?    Yes___No___ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adults
Grades: ________ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Seconds/A la Carte?      Yes___No___
Menu |  |  | Serving Temperature | Component Contribution | Recipe No. or Brand & Product Code | Quantity Prep (# of servings, pounds, cans) | Grades: |  |  |  | Grades: |  |  | Adults/A la carte: |  |  | Total
 |  |  |  |  |  |  | Serving Size |  | Planned Servings |  | Serving Size | Planned Servings |  | Serving Size | Planned Servings |  | Amount Prepared | Seconds/ A la Carte Sold | Leftover/ comments
Meat/Meat Alternate
Vegetables/Fruits
Grain/Bread
Other
Milk
Spreadsheet: 275997d1383717106-please-help-sum-of-column-based-on-multiple-criteria-query
Sheet: Sheet3

 | [NAME] | a
 | Eye drops |  |  |  | a | b | c
 |  |  |  | Eye drops | 25 | 121 | 56
 |  |  |  | Ointment | 36 | 126 | 61
 |  |  |  | Injections | 41 | 936 | 871
 |  |  |  | Eye drops | 851 | 85 | 20
Spreadsheet: 142323d1329773721-copying-cell-that-meets-certain-criteria-dummy1
Sheet: Sheet1

Before
0.25
 |  | 0 | 0.01 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08 | 0.09 | 0.1 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.19 | 0.2 | 0.21 | 0.22 | 0.23 | 0.24 | 0.25 | 0.26 | 0.27 | 0.28 | 0.29 | 0.3 | 0.31 | 0.32 | 0.33 | 0.34 | 0.35 | 0.36 | 0.37 | 0.38 | 0.39 | 0.4 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.5
 |  | 0.179640718562874 | 0.182971456452793 | 0.186428038777032 | 0.190017734988599 | 0.193748385430121 | 0.197628458498024 | 0.201667114815811 | 0.205874279440022 | 0.210260723296888 | 0.214838155256373 | 0.219619326500732 | 0.224618149146451 | 0.229849831443457 | 0.235331032318795 | 0.241080038572806 | 0.247116968698517 | 0.253464008110848 | 0.260145681581686 | 0.267189169932312 | 0.27462467960454 | 0.282485875706215 | 0.290810391624661 | 0.299640431482221 | 0.30902348578492 | 0.31901318587835 | 0.32967032967033 | 0.34106412005457 | 0.353273669335845 | 0.366389838788471 | 0.380517503805175 | 0.395778364116095 | 0.412314458493678 | 0.430292598967298 | 0.449910017996401 | 0.471401634192332 | 0.495049504950495 | 0.521195274496178 | 0.550256786500367 | 0.582750582750583 | 0.619322873658134 | 0.66079295154185 | 0.708215297450425 | 0.762970498474059 | 0.826901874310915 | 0.902527075812274 | 0.993377483443708 | 1.10456553755523 | 1.24378109452736 | 1.42314990512334 | 1.6629711751663 | 2
After
0.25 | 0.33
0.48 | V
Spreadsheet: 88704d1288563062-convert-vertical-row-data-into-horizontal-transposedata
Sheet: Sheet1

C_ID | E_NAME | C_NAME | P_NAME | EVENT_DT |  | C_ID | E_NAME | C_NAME | P_NAME | EVENT_ID
1 | AB | A | A123 | 2010-07-15 00:00:00 |  | 1 | AB | A | A123 | 2010-07-15 00:00:00 | 2010-07-22 00:00:00 | 2010-07-29 00:00:00 | 2010-08-05 00:00:00 | 2010-08-12 00:00:00 | 2010-08-19 00:00:00 | 2010-08-26 00:00:00 | 2010-09-02 00:00:00
1 | AB | A | A123 | 2010-07-22 00:00:00 |  | 2 | AB | B | A123 | 2010-07-22 00:00:00 | 2010-07-29 00:00:00 | 2010-08-05 00:00:00 | 2010-08-12 00:00:00 | 2010-08-19 00:00:00 | 2010-08-26 00:00:00 | 2010-09-02 00:00:00
1 | AB | A | A123 | 2010-07-29 00:00:00 |  | 3 | ACD | C | B123 | 2010-07-15 00:00:00 | 2010-07-22 00:00:00 | 2010-07-29 00:00:00 | 2010-08-05 00:00:00 | 2010-09-02 00:00:00
1 | AB | A | A123 | 2010-08-05 00:00:00 |  | 4 | CD | D | B123 | 2010-07-15 00:00:00 | 2010-07-22 00:00:00 | 2010-07-29 00:00:00 | 2010-08-05 00:00:00 | 2010-08-12 00:00:00 | 2010-08-19 00:00:00
1 | AB | A | A123 | 2010-08-12 00:00:00
1 | AB | A | A123 | 2010-08-19 00:00:00
1 | AB | A | A123 | 2010-08-26 00:00:00
1 | AB | A | A123 | 2010-09-02 00:00:00
2 | AB | B | A123 | 2010-07-22 00:00:00
2 | AB | B | A123 | 2010-07-29 00:00:00
2 | AB | B | A123 | 2010-08-05 00:00:00
2 | AB | B | A123 | 2010-08-12 00:00:00
2 | AB | B | A123 | 2010-08-19 00:00:00
2 | AB | B | A123 | 2010-08-26 00:00:00
2 | AB | B | A123 | 2010-09-02 00:00:00
3 | CD | C | B123 | 2010-07-15 00:00:00
3 | CD | C | B123 | 2010-07-22 00:00:00
3 | CD | C | B123 | 2010-07-29 00:00:00
3 | CD | C | B123 | 2010-08-05 00:00:00
3 | CD | C | B123 | 2010-09-02 00:00:00
4 | CD | D | B123 | 2010-07-15 00:00:00
4 | CD | D | B123 | 2010-07-22 00:00:00
4 | CD | D | B123 | 2010-07-29 00:00:00
4 | CD | D | B123 | 2010-08-05 00:00:00
4 | CD | D | B123 | 2010-08-12 00:00:00
4 | CD | D | B123 | 2010-08-19 00:00:00
Spreadsheet: vkaminski__40901__CASH_EPE_0400MyCopy
Sheet: Annex 10-Plant

APPENDIX VI - PLANT TARIFF (ANNEX 10)
 |  | Plant & Transmission Tariff |  |  |  |  |  |  |  |  | Variable O&M Tariff
 |  |  |  | Escalated | Plant | Monthly | (Divide By) | Monthly | Annual |  |  |  | Escalated | Diesel / Gas | Monthly | (Divide By) | Monthly | Annual
 |  | P&T Tariff |  | P&T Tariff | MW | Revenues | Current | Revenues | Revenues |  | VOM Tariff |  | VOM Tariff | MW | Revenues | Current | Revenues | Revenues
Date |  | R$ / Mw-Mo |  | R$ / Mw-Mo | Capacity | R $000 | Exch Rate | US $000 | US $000 |  | R$ / Mwh |  | R$ / Mwh | Hours | R $000 | Exch Rate | US $000 | US $000
 |  |  |  |  |  |  |  | Total P&T Revenues |  |  |  |  |  |  |  |  | Total Variable O&M Revenues
1
Spreadsheet: 96f9054c-7588-4112-8068-1539597edc4b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8089 | 57980 | Remco | Grasman | NED | 0 | 00:15:32 | 00:01:02 | 00:32:33 | 00:01:13 | 00:09:48 | 1 | 01:00:08
8089 | 31774 | [NAME] | Goeckus | GER | 0 | 00:17:31 | 00:01:11 | [NAME] | 00:01:11 | 00:10:12 | 2 | 01:01:41
8089 | 13404 | Abbi | Westphal | GER | 0 | 00:18:02 | 00:01:20 | 00:36:07 | 00:01:24 | 00:10:55 | 3 | 01:07:46
Spreadsheet: 833054d1686754335-insert-rows-from-other-tab-when-value-is-x-testdocument
Sheet: Info

Dropdown
Keuzemenu
Wanden GLV
Wanden V1
Wanden V2
Roostering 1
Roostering 2
Wanden GLV
Binnenwanden |  |  |  |  | [NAME]
Grootte: |  | m² |  |  |  | m²
Aantal:
Beplating:
Inblaasgaten:
Extra opmerkingen:
Wanden V1
Afhaling |  |  |  |  | Intern
Aantal: |  | st |  |  |  | st
Aantal:
[NAME]:
Extra opmerkingen:
Wanden V2
Roostering 1
Roostering 2
Spreadsheet: 693605d1599054787-return-the-next-working-day-taking-in-consideration-the-days-off-on-a-2-days-interval-sample
Sheet: Admin

 |  |  |  |  | HOLIDAY LEAVE |  |  | LEGAL DAYS OFF |  |  | V | W1 D1 | W1 D2 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | W5 D1 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | W7 D1 | [NAME] | W8 D1 | W8 D2
 |  |  |  | Crit. | Start | End |  | 2020-06-01 00:00:00 |  |  | 2020-01-18 00:00:00
 |  |  |  | 1 | 2020-01-02 00:00:00 | 2020-01-05 00:00:00 |  | 2020-06-07 00:00:00 |  |  | 2020-01-13 00:00:00
 |  |  |  |  | 2020-01-15 00:00:00 | 2020-01-17 00:00:00 |  | 2020-06-08 00:00:00 |  |  | 2020-01-14 00:00:00
 |  |  |  |  | 2020-02-09 00:00:00 | 2020-02-19 00:00:00 |  | 2020-08-15 00:00:00 |  |  | 2020-02-14 00:00:00
 |  |  |  |  | 2020-06-09 00:00:00 | 2020-06-12 00:00:00 |  | 2020-11-30 00:00:00 |  |  | 2020-01-25 00:00:00
 |  |  |  |  | 2020-09-14 00:00:00 | 2020-09-19 00:00:00 |  | 2020-12-01 00:00:00 |  |  | 2020-01-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Based on the dates found in column L, if date falls in the holiday leave range or legal days off range, then W1 D1 should be the next working day. But if the found date is a Monday or Tuesday, then W1 D1 should be Wednesday. If is not Monday or Tuesday, then it should move to next week - Monday. If [NAME] is Wednesday then [NAME] should be Thursday, [NAME] should be Friday, otherwise, if [NAME] is Monday, then [NAME] should be Wednesday and [NAME] should be Friday. This should be the case up untill [NAME]. For W7 and W8, it should have the same rules but only for 2 days, Monday and Thursday.  The main point is that it should jump over the holiday intervals or legal days off.  I hope that is not too confusing
Spreadsheet: 76441d1276970459-conditional-formatting-based-on-different-cell-cf-example
Sheet: Sheet2

 | FCST | ACT | VAR %
Dept A | 595 | 571 | -0.04033613445378152 |  | I created a named range encompassing the columns A:D called Table
Dept B | 262 | 263.6428571428572 | 0.006270447110141859
Dept C | 342 | 362.1 | 0.05877192982456147
Dept D | 263 | 290.378125 | 0.1040993346007605
Dept E | 124 | 129.551724137931 | 0.04477196885428263
Spreadsheet: 233699d1367902223-merging-two-documents-without-adding-unique-rows-1
Sheet: Sheet1

Last Name | First Name | Company Name | Address | City | State | Zip | [NAME] | Phone Type | Phone Number
[NAME] | [NAME] |  |  |  |  |  | [EMAIL]
Anders | [NAME] |  |  |  |  |  | [EMAIL]
Brecht | Becky |  |  |  |  |  | [EMAIL]
[NAME] | [NAME] |  |  |  |  |  | [EMAIL]
Spreadsheet: 07cf8aa4-77e0-407b-a517-17839cd52e38
Sheet: Sheet1

Table 5--U.S. and world fiber prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Dec. | Jan. | Feb. |  | Feb.
Item | 2013 | 2014 | 2014 |  | 2013
 | Cents per pound
Domestic cotton prices:
Adjusted world price | 66.24 | 69.1 | 71.86 |  | 69
Upland spot 41-34 | 78.75 | 81.43 | 83.21 |  | 76.87
Pima spot 02-46 | 178 | 178 | 178 |  | 122.05
Average price received by
upland producers | 76.9 | 76.9 | 76.7 |  | 76.9
Far Eastern cotton quotes:
A Index | 87.37 | 91.01 | 93.55 |  | 89.86
Memphis/Eastern | 91.33 | 94.6 | 96.5 |  | 92.06
Memphis/Orleans/Texas | 91 | 94.35 | 96.25 |  | 91.69
California/Arizona | 92.75 | 96.45 | 98.44 |  | 95.31
 |  | Dollars per pound
Wool prices (clean):
U.S. 56s | NQ | NQ | NQ |  | NQ
Australian 56s 1/ | 3.43 | 3.21 | 3.2 |  | 3.95
U.S. 60s | NQ | NQ | NQ |  | NQ |  | `
Australian 60s 1/ | 4.8 | 5.1 | 5 |  | 5.76
U.S. 64s | NQ | NQ | NQ |  | NQ
Australian 64s 1/ | 4.89 | 5.18 | 5.06 |  | 5.86
NQ = No quote.
1/  In bond, Charleston, SC.
Sources: USDA, Cotton Price Statistics; Cotlook Ltd., [NAME];
and trade reports.
Last update:  3/12/14.
Spreadsheet: 45735d1244553282-nesting-vlookup-in-if-vice-versa-and-pivot-table-copy-of-sample3
Sheet: Mar Summary

 | Amount-Cat1 | Amount-Cat2
500 | -174.29 | 245.7489
750 | -2467.829620000004 | 3765.181162680006
900 | -4644.682146744009 | 7469.930183591055
AB | -2021.148664912 | 3119.31051936192
AG | -63.58996399999999 | 177.9501552576
AN | -1797.5294 | 5030.20627296
AD | -53.8898 | 75.984618
AL | -1523.33 | 2147.8953
BX | -12384.557766 | 19113.52786056
BZ | -7039.132799999999 | 15215.22116352
CA | -5622.025086 | 8676.67099176
CB | -877.04125 | 1895.741559
DE | -2560.299336
DV | -7760.900946
DX | -6062.298852
DF |  | 1143.86391
DS |  | 910.56672
FA |  | 519.2621099999999
GL | -2868.781915198807 | 4044.982500430317
GM | -221.0269653693443 | 311.6480211707755
LA | -4488.83374256 | 2456.4472599744
LJ | -3506.37791072
MF | -2306.121860760271 | 3559.119773860476
MR | -28328.18084312802 | 43719.88762251855
OA | -715.5376707607675 | 1546.648460937552
OB | -268.7207781562057 | 580.8451391739425
OR | -472.7838065507161 | 729.6640404340717
RA | -983.4069722550075 | 1581.589696068054
RF | -18482.58537609277 | 29725.09592899885
TM | -106.5165036724806 | 171.3079217684309
ZB | -3591.066994048001 | 2892.4240980096
ZP | -3397.057709260333 | 2586.375117222021
ZQ | -527.6314971350371
Spreadsheet: 158003d1337952085-separating-out-itemised-phone-bills-in-excel-phone-bill
Sheet: Sheet1

Date | Time | Originating Number | Number Called | Call Type | Duration | Amount £
2012-04-02 00:00:00 | 08:48:00 | 0800 000000 | 12345 | Mobile | 00:00:44 | 0.0788
2012-04-02 00:00:00 | 09:04:40 | 0800 000000 | 67890 | Local | 00:00:39 | 0.04
2012-04-02 00:00:00 | 09:06:54 | 0800 000000 | 98765 | Mobile | 00:00:14 | 0.04
2012-04-02 00:00:00 | 09:16:41 | 0800 000000 | 54321 | Mobile | 00:02:07 | 0.2857
2012-04-02 00:00:00 | 09:22:16 | 0800 000000 | 67436 | Local | 00:00:02 | 0.04
2012-04-02 00:00:00 | 09:22:32 | 0845 999999 | 98123 | Mobile | 00:00:21 | 0.0613
2012-04-02 00:00:00 | 09:22:35 | 0845 999999 | 19375 | Local | 00:01:18 | 0.04
2012-04-02 00:00:00 | 09:24:18 | 0845 999999 | 30049 | Mobile | 00:00:34 | 0.0609