tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 686389d1594574031-index-indirect-function-need-help-inventory
Sheet: Inventory 

 | Massage |  |  | Golf |  |  | Food |  |  | Novelty |  |  | Reading |  |  | Clothing
 | Item | Projection |  | Item | Projection |  | Item | Projection |  | Item | Projection |  | Item | Projection |  | Item | Projection
 | A9 | 4 |  | A16 | 5 |  | A1 | 4 |  | A13 | 5 |  | A5 |  |  | A2
 | A10 | 5 |  | A17 | 5 |  | A3 | 4 |  | A14 | 6 |  | A6 |  |  | A4
 | A11 | 6 |  | A18 | 5 |  | A20 | 4 |  | A15 | 7 |  | A7
 | A12 | 6 |  | A19 | 5 |  |  |  |  |  |  |  | A8
Item | Description | Max_On_Hand | WholeSell Price | Sale Price | Category | Delivery Time | Current Inventory | ReOrder_Point | RushReOrderPoint | Discontinue | ReorderStatus | Vendor
A1 | [NAME] | 45 | 15.99 | 21.99 | Food | 10 | 23 | 20 | 10 | N |  | Vendor 1
A2 | Resort Polo | 35 | 29.48 | 45.34 | Clothing | 14 | 15 | 17 | 10 | N |  | Vendor 2
A3 | Healthy Energy Bar | 25 | 3.9 | 9.95 | Food | 4 | 5 | 15 | 10 | N |  | Vendor 1
A4 | Spirits Lifted Through Yoga | 15 | 6.9 | 14.95 | Reading | 7 | 5 | 15 | 10 | Y |  | Vendor 4
A5 | [NAME] | 50 | 1.3 | 2.59 | Golf | 11 | 27 | 20 | 10 | N |  | Vendor 5
A6
A7
A8
A9
A10
A11
A12
A13
A14
A15
A16
A17
A18
A19
A20
Spreadsheet: 10c15d5f-7521-46a7-9a14-30452587634d
Sheet: Sheet1

Table 5--USDA-calculated world market rice prices (rough basis) 1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | 2012/13 |  |  | 2011/12 |  |  | 2010/11
 |  | Medium/ |  |  | Medium/ |  |  | Medium/
Month | Long | short |  | Long | short |  | Long | short
 | $/cwt
August | 11.91 | 12.13 |  | 14.08 | 14.4 |  | 9.58 | 9.68
September | 12.57 | 12.81 |  | 15.09 | 15.44 |  | 10.51 | 10.62
October | 12.72 | 12.97 |  | 15.63 | 15.99 |  | 12.15 | 12.29
November | 12.92 | 13.17 |  | 14.93 | 15.28 |  | 13.4 | 13.58
December  2/ | 12.66 | 12.9 |  | 13.9 | 14.21 |  | 14.5 | 14.67
January |  |  |  | 12.61 | 12.88 |  | 13.98 | 14.15
February |  |  |  | 11.81 | 12.2 |  | 12.68 | 13.35
March |  |  |  | 11.52 | 11.92 |  | 12.13 | 12.76
April |  |  |  | 11.15 | 11.54 |  | 11.76 | 12.36
May |  |  |  | 11.42 | 11.82 |  | 11.58 | 12.17
June |  |  |  | 11.93 | 12.35 |  | 11.78 | 12.39
July |  |  |  | 11.97 | 12.4 |  | 12.49 | 13.14
Market-year
average 1/ | 12.556 | 12.796 |  | 13.00333333333334 | 13.36916666666666 |  | 12.21166666666667 | 12.59666666666666
1/ Simple average of the U.S. Department of Agriculture's weekly adjusted world market price.  2/  Preliminary.
Source: [NAME] and Rice Weekly Prices (ftp://ftp.fsa.usda.gov/public/cotton/default.htm), Farm Service Agency, USDA.
Last updated December 12, 2012.
Spreadsheet: c27dc410-5478-4714-8d23-92b77a3eef3f
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Curb Records | 715187915725 | Plumb | Beautiful History: A Hits Collection | 2009-11-03 | Compact Disc | Rock | 13.99 | Y | Available
Curb Records | 715187874022 | Plumb | Beautiful Lumps Of Coal | 2003-03-08 | Compact Disc | Pop | 7.99 | N | To Be Retired
Curb Records | 715187888227 | Plumb | Chaotic Resolve | 2006-02-28 | Compact Disc | Rock | 9.99 | N | To Be Retired
Curb Records | 715187897823 | Plumb | Blink | 2007-10-09 | Compact Disc | Rock | 9.99 | N | To Be Retired
Curb Records | 715187915428 | Plumb | Beautiful History: A Hits Collection (2 Disc Version) | 2009-11-03 | Compact Disc | Rock | 13.99 | N | To Be Retired
Curb Records | 715187931725 | Plumb | Need You Now | 2013-02-26 | Compact Disc | Rock | 13.99 | Y | Available
Curb Records | 715187939622 | Plumb | Need You Now Deluxe Edition | 2014-09-16 | Compact Disc | Pop | 15.99 | Y | NYP
Spreadsheet: 804175d1667924862-dynamic-array-horizontal-lookup-across-2d-range-index_match_of_dynamic_2d_array
Sheet: Sheet1

Phase1 |  | Phase2 |  | Phase3 |  | Phase4 |  | Phase5 |  | Phase6 |  | Phase with most recent date/time |  | Dynamic array: Phase with most recent date/time
2020-02-13 10:48:40 |  | 2020-02-14 10:48:40 |  | 2020-02-10 00:00:00 |  | 2020-02-11 00:00:00 |  | 2020-02-19 00:00:00 |  | 2020-02-17 00:00:00
2020-02-26 11:39:33 |  | 2020-02-27 11:39:33 |  | 2020-02-14 00:00:00 |  | 2020-02-21 00:00:00 |  |  |  | 2020-02-24 00:00:00
2020-02-26 11:39:33 |  |  |  | 2020-02-14 00:00:00 |  | 2020-02-21 00:00:00 |  | 2020-02-25 00:00:00 |  | 2020-02-24 00:00:00
2020-02-29 07:50:18 |  | 2020-02-28 07:50:18 |  | 2020-02-14 00:00:00 |  | 2020-02-21 00:00:00 |  | 2020-02-25 00:00:00 |  | 2020-02-24 00:00:00
2020-02-26 12:24:40 |  | 2020-02-27 11:24:40 |  |  |  | 2020-02-21 00:00:00 |  | 2020-02-25 00:00:00 |  | 2020-02-28 00:00:00
2020-02-26 12:00:21 |  | 2020-02-27 12:00:21 |  | 2020-02-27 00:00:00 |  | 2020-02-24 00:00:00 |  | 2020-03-04 00:00:00 |  | 2020-03-02 00:00:00
2020-03-04 12:27:31 |  | 2020-03-05 12:27:31 |  | 2020-02-27 00:00:00 |  |  |  | 2020-03-04 00:00:00 |  | 2020-03-03 00:00:00
 |  | 2020-03-06 09:31:49 |  | 2020-02-27 00:00:00 |  | 2020-03-03 00:00:00 |  | 2020-03-04 00:00:00
2020-03-05 09:31:49 |  | 2020-03-06 09:31:49 |  | 2020-02-27 00:00:00 |  | 2020-03-03 00:00:00 |  | 2020-03-04 00:00:00 |  | 2020-03-17 00:00:00
2020-03-03 08:03:58 |  | 2020-03-04 08:03:58 |  | 2020-02-27 00:00:00 |  | 2020-03-03 00:00:00 |  | 2020-03-04 00:00:00 |  | 2020-03-05 00:00:00
Spreadsheet: 723214d1615561316-how-to-rank-by-4-criteria-rank-by-4-criteria
Sheet: Sheet1

Exam Roll | Math Score (2nd criteria) | Phy Score (3rd criteria) | Chem Score (4th criteria) | Eng Score | Total Score (1st criteria) | Rank [formula needed]
101 | 50 | 50 | 50 | 50 |  | 1
102 | 40 | 50 | 50 | 60 |  | 2
103 | 40 | 40 | 60 | 60 |  | 3
104 | 40 | 40 | 50 | 70 |  | 4
Spreadsheet: 681675d1591698168-conditional-formatting-not-working-after-certain-point-in-the-sheet-vla-schedule-2020
Sheet: Groups

Group ID. | Species + Amount ([NAME]) | Age Class | Height (m) ([NAME].) | Stem dia. ([NAME]) ([NAME].) | Physiological  Condition | Structural Condition | Observations / Comments | Recommendations | Work Priority | Re Inspect  (Years) |  | WP 1 | WP 2 | WP3 |  | WP1 Total | WP2 Total | WP3 Total |  | Total Groups Surveyed
Spreadsheet: 161502d1339531500-excel-2007-ranking-based-on-more-factors-in-2-columns-problem-with-ranking
Sheet: Kundedatabase

1.Kode | 2.Firmanavn | 3.Fornavn | 4.Mellem og efternavn | 5.Mobilnr | 6.Stilling | 7.E-mail | 8.Website | 9.Vejnavn | 10.nr. | 11.Postnr. | 12.By | 13.Lokale | 14.Fra kl. | 15.Til kl. | 16.Bordopstilling | 17.Aktivitet | 18.Forbered lokalet | 19.Afryder lokalet | 20.Brød | 21.Frugt | 22.Frokost | 23.Kage | 24.Lokale pris | 25.Forplejning pris | 2k fornavn | 2k mellem og efternavn | 2k mobil | 2k mail | 2k stilling
Astrup | [NAME] | Marianne | Astrup | 27465518 | Psykolog | [EMAIL] | www.marianneastrup.dk | Skæringvej | 94.4 | 8820 | Lystrup |  |  |  | Rundkreds af stole |  |  |  |  |  |  |  | Inhouse | Berit
TestV1 | Test virksomhed 1 |  |  |  |  |  |  |  |  |  |  | K1 | 08:00:00 | 09:00:00
TestV2 | Test virksomhed 2 |  |  |  |  |  |  |  |  |  |  | K2 | 08:00:00 | 09:00:00
TestV3 | Test virksomhed 3 |  |  |  |  |  |  |  |  |  |  | L2 | 08:00:00 | 09:00:00
TestV4 | Test virksomhed 4 |  |  |  |  |  |  |  |  |  |  | Hems tv | 08:00:00 | 09:00:00
TestV5 | Test virksomhed 5 |  |  |  |  |  |  |  |  |  |  | Hems th | 08:00:00 | 09:00:00
TestV6 | Test virksomhed 6 |  |  |  |  |  |  |  |  |  |  | NMH | 08:00:00 | 09:00:00
TestV7 | Test virksomhed 7 |  |  |  |  |  |  |  |  |  |  | K1 | 09:00:00 | 10:00:00
TestV8 | Test virksomhed 8 |  |  |  |  |  |  |  |  |  |  | K2 | 09:00:00 | 10:00:00
TestV9 | Test virksomhed 9 |  |  |  |  |  |  |  |  |  |  | L2 | 09:00:00 | 10:00:00
TestV10 | Test virksomhed 10 |  |  |  |  |  |  |  |  |  |  | Hems tv | 09:00:00 | 10:00:00
TestV11 | Test virksomhed 11 |  |  |  |  |  |  |  |  |  |  | Hems th | 09:00:00 | 10:00:00
TestV12 | Test virksomhed 12 |  |  |  |  |  |  |  |  |  |  | NMH | 09:00:00 | 10:00:00
TestV13 | Test virksomhed 13 |  |  |  |  |  |  |  |  |  |  | K1 | 09:15:00 | 11:00:00
TestV14 | Test virksomhed 14 |  |  |  |  |  |  |  |  |  |  | K2 | 09:15:00 | 11:00:00
TestV15 | Test virksomhed 15 |  |  |  |  |  |  |  |  |  |  | L2 | 09:15:00 | 11:00:00
TestV16 | Test virksomhed 16 |  |  |  |  |  |  |  |  |  |  | Hems tv | 09:15:00 | 11:00:00
TestV17 | Test virksomhed 17 |  |  |  |  |  |  |  |  |  |  | Hems th | 09:15:00 | 11:00:00
[NAME] | Test virksomhed 18 |  |  |  |  |  |  |  |  |  |  | NMH | 09:15:00 | 11:00:00
SletBook | Slettet booking |  |  |  |  |  |  |  |  |  |  | Slettet booking | 00:00:00 | 00:00:00 | Slettet booking | Ingen ting | Ingen | Ingen |  |  |  |  | Slettet booking | Slettet booking
Spreadsheet: 160528d1339098758-excel-2007-a-formula-calculates-a-cycle-open-and-close-same-day-an-extension-needed-different-day-spiros63_the_case_ron_v3
Sheet: Lists

 | Holidays2 |  |  | TrendDirection2 | EntryType2 | ExitType2
 | 2012-01-01 00:00:00 | 1
 | 2012-01-06 00:00:00 | 2 |  | ã | Wave Entry | Stop Loss
 | 2012-02-27 00:00:00 | 3 |  | ä | Breakout Entry | Take Profit Level
 | 2012-03-25 00:00:00 | 4 |  |  | Trend Reversal Entry | Take Profit Level 1
 | 2012-04-13 00:00:00 | 5 |  |  |  | Take Profit Level 2
 | 2012-04-16 00:00:00 | 6
 | 2012-05-01 00:00:00 | 7
 | 2012-06-04 00:00:00 | 8
 | 2012-08-15 00:00:00 | 9
 | 2012-10-28 00:00:00 | 10
 | 2012-12-24 00:00:00 | 11
 | 2012-12-25 00:00:00 | 12
 | 2012-12-26 00:00:00 | 13
Spreadsheet: 872510d1718883357-help-with-complex-formula-sor-template
Sheet: SOR Code Rates

SOR Code | Item | Description | Item Type | Star Rate | Trade | Unit | Unit Price | Scope
Rate 1 | Upto 0.1m2 | seal floor or wall (one face) Opening up to 0.1m2 | SOR | No | General Building | ITEM | 10 | Excluded
Rate 2 | upto 0.2m2 | seal floor or wall (one face) Opening up to 0.2m2 | SOR | No | General Building | ITEM | 20 | Excluded
Rate 3 | upto 0.4m2 | seal floor or wall (one face) Opening up to 0.4m2 | SOR | No | General Building | ITEM | 100 | Excluded
Rate 4 | upto 0.6m2 | seal floor or wall (one face) Opening up to 0.6m2 | SOR | No | General Building | ITEM | 200 | Excluded
Rate 5 | upto 0.8m2 | seal floor or wall (one face) Opening up to 0.8m2 | SOR | No | General Building | ITEM | 250 | Excluded
Rate 6 | upto 0.9m2 | seal floor or wall (one face) Opening up to 0.9m2 | SOR | No | General Building | ITEM | 290 | Excluded | 325
Spreadsheet: 765209d1643211326-large-function-does-not-appear-in-power-pivot-measures-bottom5-and-top5-slicers
Sheet: Sheet2

Sites | Period | Sum of Overdues |  |  |  |  |  |  | Sites | Period | Sum of Overdues
Barcelona |  | 7 |  |  |  |  |  |  | Barcelona | Q2 | 7
[NAME] | Q1 | 9 |  |  |  |  |  |  | [NAME] | Q2 | 8
Cartago | Q1 | 4 |  |  |  |  |  |  | Madrid | Q2 | 9
Nettetal | Q1 | 8 |  |  |  |  |  |  | Grand Total |  | 24
Sydney | Q1 | 5
Grand Total |  | 33
Spreadsheet: 157471d1337759877-convert-dates-in-excel-sample
Sheet: Sheet1

Format1 |  |  | Format2
2012-05-20 00:00:00 |  |  | 2011-11-05
2011-09-29 00:00:00 |  |  | 2012-03-31
2012-02-29 00:00:00 |  |  | 2011-10-26
2012-02-14 00:00:00 |  |  | 2012-04-30
2011-10-19 00:00:00 |  |  | 2012-01-26
2012-02-05 00:00:00 |  |  | 2012-02-16
2012-02-20 00:00:00 |  |  | 2011-12-05
2012-03-02 00:00:00 |  |  | 2012-03-14
2012-04-08 00:00:00 |  |  | 2011-10-04
2012-04-24 00:00:00 |  |  | 2011-09-19
2012-04-26 00:00:00 |  |  | 2011-12-14
2012-04-26 00:00:00 |  |  | 2012-04-17
2012-04-26 00:00:00 |  |  | 2012-02-11
2012-04-24 00:00:00 |  |  | 2012-02-26
2012-05-07 00:00:00 |  |  | 2012-04-25
2012-04-24 00:00:00 |  |  | 2012-04-11
2012-04-24 00:00:00 |  |  | 2011-08-25
2012-04-24 00:00:00 |  |  | 2011-11-15
2012-04-26 00:00:00 |  |  | 2012-03-30
2012-04-26 00:00:00 |  |  | 2011-11-09
2012-04-26 00:00:00 |  |  | 2011-11-08
2012-04-27 00:00:00 |  |  | 2011-10-11
2012-04-26 00:00:00 |  |  | 2011-08-24
2012-04-24 00:00:00 |  |  | 2012-03-19
2012-04-26 00:00:00 |  |  | 2012-02-14
2012-04-24 00:00:00 |  |  | 2012-03-19
2012-05-08 00:00:00 |  |  | 2012-01-30
2012-05-02 00:00:00 |  |  | 2011-08-24
2012-04-24 00:00:00 |  |  | 2012-03-30
2012-04-26 00:00:00 |  |  | 2011-10-11
2012-04-26 00:00:00 |  |  | 2011-11-08
2012-04-27 00:00:00 |  |  | 2012-01-30
2012-04-26 00:00:00 |  |  | 2012-04-25
2012-05-07 00:00:00 |  |  | 2012-03-19
2012-05-05 00:00:00 |  |  | 2011-11-15
2012-04-26 00:00:00 |  |  | 2012-02-14
Spreadsheet: 814149d1674185055-index-match-function-for-multimple-column-data-test_index_match_multiple_col
Sheet: Sheet1

Prod1 | Prod2 | Prod3 | Prod4 | Prod5 | Code
Soap | [NAME] |  |  |  | AAA
Pen | Pencil | Eraser |  |  | BBB
Book | Note | File |  |  | CCC
Red | Yellow | Pink | [NAME] |  | DDD
Suit | Trouser | Vest | Brief | Shirt | EEE
Prod | Code
Soap | AAA
Pencil | BBB
File | CCC
[NAME] | DDD
Shirt | EEE
Spreadsheet: 140619d1328821171-inventory-yfeb-food-total-values
Sheet: 2-10-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 | Daily Total
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
Spreadsheet: 022ac312-6419-4af1-a737-39c62cb3f661
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | WCC Champions | Unnamed: 7 | NCAA Tournament | 1992 | 2003 | All-Americans | Unnamed: 12 | Unnamed: 13
 |  |  |  |  |  |  | 1992 |  | 1993 | 2004 |  | [NAME]02, '03
 |  |  |  |  |  |  | 1993 |  | 1998 | 2005 |  | Cassie Perret '05
 |  |  |  |  |  |  | 2000 |  | 1999 | 2006 |  | Crystal Matich '05, '07
 |  |  |  |  |  |  | 2005 |  | 2000 | 2007 |  | [NAME]05, '06, '08
 |  |  |  |  |  |  | 2007 |  | 2001 | 2008
 |  |  |  |  |  |  |  |  | 2002 |  |  |  | FINAL FOUR 2005
 |  |  |  |  |  |  |  | PROSPECT QUESTIONNAIRE
Personal
 |  | Name: |  |  |  |  |  | Cell #: |  |  |  | [NAME]:
 |  | Address: |  |  |  |  |  |  |  |  |  | SS#:
 |  | City: |  |  |  |  |  | State: |  |  |  |  | Zip:
 |  | Mother's Name: |  |  |  |  |  | Cell #: |  |  |  | [NAME]:
 |  | Father's Name: |  |  |  |  |  | Cell #: |  |  |  | [NAME]:
 |  | Siblings (Name/Age):
Academic |  | High School:
 |  | Address:
 |  | City: |  |  |  |  |  | State: |  |  |  | Zip:
 |  | GPA: |  | Class Rank: |  |  |  | Year of Graduation: |  |  |  |  | SAT Date:
 |  | SAT: |  |  | Math: |  |  | Critical Reading: |  |  |  |  | Writing:
 |  | Guidance Counselor: |  |  |  |  |  |  | Desired Major:
 |  | Academic Accolades:
Volleyball
 |  | Club Team: |  |  |  |  |  | Jersey #: |  |  | Position:
 |  | Club Coach: |  |  |  |  |  | Cell #: |  |  | [NAME]:
 |  | HS Team (JV/V): |  |  |  |  |  | Jersey #: |  |  | Position:
 |  | HS Coach: |  |  |  |  |  | Cell #: |  |  | [NAME]:
 |  | Height: |  |  |  | Standing Reach: |  |  |  |  | Approach Touch:
 |  | Years Playing Club:
Miscellaneous |  | Indicate your interest in Santa Clara University:
 |  |  |  | Very Interested |  |  |  | Interested |  |  |  | More Information
 |  | Other schools who have contacted you regarding volleyball:
 |  | Your top 3 Universities at this time:
 |  |  |  | 1. |  |  |  | 2. |  |  |  | 3.
 |  | Other Sports, Hobbies, Interests:
 |  | Friends or Relatives that have attended Santa Clara University:
 |  |  |  |  |  |  |  | Santa Clara University [NAME] El Camino Real - Santa Clara, CA 95053
 |  |  |  |  |  |  |  | (408) 554-4676 - www.santaclarabroncos.com - www.SCUvolleyball.com
Spreadsheet: 703058d1604706307-countifs-funtion-for-multiple-criteria-test_1
Sheet: Sheet1

Name | Mon | Tue | Wed | Thu | Fri | Sat | Sun
[NAME] | 10:00 - 13:00 | 10:00 - 13:00 OT | OFF | OFF | 8:00 - 11:00 | 10:00 - 13:00 | 15:00 - 20:00 OT
Chase | 10:00 - 13:00 | 10:00 - 13:00 | 10:00 - 13:00 | OFF | OFF | 13:00 - 16:00 OT | 13:00 - 16:00
Billy | OFF | OFF | 8:00 - 11:00 OT | 13:00 - 16:00 | 10:00 - 13:00 OT | 15:00 - 20:00 | 10:00 - 13:00
[NAME] | 13:00 - 16:00 | 13:00 - 16:00 | 13:00 - 16:00 OT | 13:00 - 16:00 | 10:00 - 13:00 | OFF | OFF
Leo | 10:00 - 13:00 | 10:00 - 13:00 | OFF | OFF | 8:00 - 11:00 | 10:00 - 13:00 | 10:00 - 13:00
[NAME] | 10:00 - 13:00 | 15:00 - 20:00 | 15:00 - 20:00 OT | OFF | OFF | 13:00 - 16:00 OT | 10:00 - 13:00
[NAME] | OFF | 10:00 - 13:00 OT | OFF | 10:00 - 13:00 OT | 13:00 - 16:00 | 8:00 - 11:00 OT | 8:00 - 11:00 OT
[NAME] | 15:00 - 20:00 | 15:00 - 20:00 | 8:00 - 11:00 | 8:00 - 11:00 | 13:00 - 16:00 OT | 13:00 - 16:00 | 10:00 - 13:00 OT
Nikita | 10:00 - 13:00 | 8:00 - 11:00 | OFF | OFF | 10:00 - 13:00 OT | 10:00 - 13:00 | 13:00 - 16:00
[NAME] | 10:00 - 13:00 OT | 15:00 - 20:00 | 8:00 - 11:00 | 8:00 - 11:00 | OFF | OFF | 15:00 - 20:00 |  | Shift | OT shift
 |  |  |  |  |  |  |  |  | 10:00 - 13:00 | 10:00 - 13:00 OT
 |  |  |  |  |  |  |  |  | 8:00 - 11:00 | 8:00 - 11:00 OT
OT |  |  |  |  |  |  |  |  | 15:00 - 20:00 | 15:00 - 20:00 OT
OFF |  |  |  |  |  |  |  |  | 13:00 - 16:00 | 13:00 - 16:00 OT
Spreadsheet: 185909d1349877260-how-to-use-conditional-vlookup-0a1_fot_excel_query1
Sheet: Required Data

Name | [NAME] | Status
A | 3 | Fail |  | Fail<Blanks<Pass W/E<Pass.
B | 2 | Pass
C | 4 | Fail
D | 5 | Pass W/E
Name | [NAME] | Status
A
B
C
D
Spreadsheet: 133530d1324461660-iferror-and-vlookup-returns-n-a-can-you-help-me-fix-it-example-sched
Sheet: Statistics

2012 | Dec |  |  | Jan |  |  | Feb |  |  | March |  |  | April |  |  | May |  |  | June |  |  | July |  |  | Aug |  |  | Sep |  |  | Oct |  |  | Nov |  |  | Dec |  |  | TOTAL |  |  | Total PL | Days Left
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
2012 | Dec |  |  | Jan |  |  | Feb |  |  | March |  |  | April |  |  | May |  |  | June |  |  | July |  |  | Aug |  |  | Sep |  |  | Oct |  |  | Nov |  |  | Dec |  |  | TOTAL |  |  | Total PL | Days Left
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 49992d1249407978-count-and-total-the-unknown-matching-data-occurences-across-multi-worksheets-dummy2
Sheet: Mar

cat | 103
cat | 103
cat | 103
cat | 103
cat | 103
dog | 801
dog | 801
dog | 801
dog | 801
dog | 801
dog | 801
fly | 301
fly | 301
fly | 301
fly | 301
fly | 301
fly | 301
fly | 301
chicken | 201
chicken | 201
chicken | 201
chicken | 201
chicken | 201
chicken | 201
chicken | 201
chicken | 201
dog | 802
dog | 802
dog | 802
dog | 802
dog | 802
dog | 802
dog | 802
Spreadsheet: 831837d1685949743-list-values-that-match-criteria-multiple-ranges-into-one-list-participants-to-groups
Sheet: Sheet1

Group name | Participant 1 | Participant 2 | Participant 3 | Participant 4 |  | Joins group | Also joins group | Participant
[NAME] | [NAME] required |  |  |  |  | [NAME] | [NAME] | [NAME]
[NAME] |  |  |  |  |  | [NAME] |  | [NAME]
[NAME] |  |  |  |  |  | [NAME] | [NAME] | [NAME]
[NAME] |  |  |  |  |  | [NAME] |  | [NAME]
[NAME] |  |  |  |  |  | [NAME] | [NAME] | [NAME]
[NAME] |  |  |  |  |  | [NAME] | [NAME] | Rio
[NAME] |  |  |  |  |  | [NAME] |  | [NAME]
[NAME] |  |  |  |  |  | [NAME] | [NAME] | Hugh
9 |  |  |  |  |  | [NAME] |  | [NAME]
END RESULT
Group name | Participant 1 | Participant 2 | Participant 3 | Participant 4 |  | Joins group | Also joins group | Participant
[NAME] | [NAME] |  |  |  |  | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | Rio | [NAME] |  | [NAME] |  | [NAME]
[NAME] |  |  |  |  |  | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | Hugh | [NAME] |  |  | [NAME] |  | [NAME]
[NAME] | [NAME] | [NAME] |  |  |  | [NAME] | [NAME] | [NAME]
[NAME] |  |  |  |  |  | [NAME] | [NAME] | Rio
[NAME] | Rio | [NAME] |  |  |  | [NAME] |  | [NAME]
[NAME] | [NAME] | Hugh |  |  |  | [NAME] | [NAME] | Hugh
9 |  |  |  |  |  | [NAME] |  | [NAME]
Spreadsheet: 464842d1465337573-check-a-col-for-a-non-zero-value-in-another-col-and-place-incrementing-value-in-first-col-book1
Sheet: Sheet1

Year: | 2016
Period | 5 | From | 2015-04-07 00:00:00
Income
Item No: | Date | Description | Amount
 | 2015-04-09 00:00:00 | Income Stream 1 | 50
 |  | Income Stream 1
 |  | Income Stream 1 | 50
 |  | Income Stream 1
 |  | Income Stream 2 | 100
 |  | Income Stream 3 | 150
Totals
Spreadsheet: 116102d1311603263-compare-data-sample
Sheet: Sheet1

A | B | C | D
VBW2KORCCEE02 | HPDHP001 | HPDHP001 | 1826
VBW2KORCCEE02 | INTRPDB1 | INTRPDB1 | 1924
VBW2KORCCEE02 | INTRPDB1 | INTRPDB1 | 1650
VBW2KORCCEE01 | ECOMMPRD | ECOMMPRD | 1826
GENRENO01 | Genesys3 | Genesys3 | 1521
IMAGE06Z | IPDPROD | IPDPROD | 1521
Spreadsheet: 754288d1636057053-combining-filter-and-sortby-formulas-test2
Sheet: CDComp

Order | Column1 | Column2 | Material Description
7200033331 |  |  | Calcium
7200033331 |  |  | Copper Oxide
7200033331 |  |  | DRY VITAMIN D3
7200033331 |  |  | FOLIC ACID
7200033331 |  |  | Maltodextrin
7200033331 |  |  | ROCOAT THIAMINE
7200033331 |  |  | [NAME]
8200044441 |  |  | Ascorbic Acid
8200044441 |  |  | B-CAROTENE
8200044441 |  |  | Calcium
8200044441 |  |  | DRY VITAMIN
8200044441 |  |  | Ferrous
8200044441 |  |  | Magnesium
8200044441 |  |  | Microcrystalline
8200044441 |  |  | Niacinamide
8200044441 |  |  | Pyridoxine
8200044441 |  |  | RIBOFLAVIN
8200044441 |  |  | [NAME]
8200044441 |  |  | Vitamin E
8200044441 |  |  | Zinc
Spreadsheet: 778128d1650880127-get-number-of-seconds-between-two-dates-in-excel-excluding-part-of-weekend-and-holidays-time-between-hours
Sheet: CONFIG

Shift Name | Open | Close | Hours | 2013-03-11 00:00:00 | 2013-03-12 00:00:00 | 2013-03-13 00:00:00 | 2013-03-14 00:00:00 | 2013-03-15 00:00:00 | 2013-03-16 00:00:00 | 2013-03-17 00:00:00 | Week
FULL | 00:00:00 | 1900-01-01 00:00:00 |  | 0 | 0 | 0 | 1 | 1 | 1 | 0 |  | 0 is ON day
Thurs | 00:00:00 | 21:12:45 |  | 1 | 1 | 1 | 0 | 1 | 1 | 1 |  | 1 is OFF day
Sat | 05:30:50 | 1900-01-01 00:00:00 |  | 1 | 1 | 1 | 1 | 1 | 0 | 1
Spreadsheet: 672008d1586678536-building-summary-report-find-multiple-matches-in-a-table-find-multiple-matches-pivot-table
Sheet: Summary

Lot | [NAME]
Purchase
Date | Head Count | CMS# | [NAME] | Pay Wt. | Amount | Note
Death
Date | Head Count | CMS# | Note
Realizer
Date | Head Count | CMS# | [NAME] | Pay Wt. | Amount | Note
Sale
Date | Head Count | CMS# | [NAME] | Pay Wt. | Amount | Note
Spreadsheet: 160828d1339233225-if-problem-test-11-
Sheet: RESULTS

 | Kamper | Resultat |  | A | B
 | [NAME] | U
 | Russland - Tsjekkia | B
 | Nederland - Danmark | b
 | Tyskland - Portugal | b
 | Spania - Italia | u
 | Irland - Kroatia | u
 | Frankrike - England | u
 | [NAME] | h
 | Hellas - Tsjekkia | h
 | Polen-Russland | u
 | Danmark - Portugal | b
 | Nederland- Tyskland | u
 | Italia - Kroatia | h
 | Spania - Irland | h
 | Ukraina - Frankriket | b
 | Sverige - England | b
 | Tsjekkia - Polen | b
 | Hellas - Russland | u
 | Danmark - Tyskland | u
 | Portugal - Nederland | h
 | Italia - Irland | h
 | Kroatia - Spania | h
 | England - Ukraina | b
 | Sverige - Frankriket | b
 | Quarterfinale team 1 | England
 | Quarterfinale team 2 | France
 | Quarterfinale team 3 | Germany
 | Quarterfinale team 4 | Holland
 | Quarterfinale team 5 | Poland
 | Quarterfinale team 6 | Spain
 | Quarterfinale team 7 | Russia
 | Quarterfinale team 8 | Portugal
 | Semifinale team 1 | England
 | Semifinale team 2 | Germany
 | Semifinale team 3 | Spain
 | Semifinale team 4 | Holland
 | Final team 1 | England
 | Final team 2 | Spain
 | Winner Finale | England
Spreadsheet: 837860d1690467284-unable-to-vlookup-with-textsplit-function-textsplit
Sheet: Sheet1

1 | Saravanan |  |  |  |  |  |  |  | 1,3,5,6
2 | Rajendran |  |  |  |  |  |  | Rajendran,Maha | 2,5
3 | [NAME] |  |  |  |  |  |  | Saravanan,Rajendran,[NAME],[NAME],Gowri | 1,2,3,5,6
4 | Viji |  |  |  |  |  |  | Saravanan,Viji,Gowri | 1,4,6
5 | Maha
6 | Gowri
Spreadsheet: 879630d1727200533-dept-and-date-to-auto-calculate-based-on-todays-date-example
Sheet: Shift per dept

 |  | Shift
 | Dept | 1 | 2 | 3
 | Grocery |  | #[NAME]? | #[NAME]?
 | Deli | #[NAME]? | #[NAME]? | #[NAME]?
 | Meat | #[NAME]? | #[NAME]? | #[NAME]?
 | Freezer | #[NAME]? | #[NAME]? | #[NAME]?
 | Produce | #[NAME]? | #[NAME]? | #[NAME]?