tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 7a34ca5a-93a0-4708-bd6e-288a284aa29f
Sheet: Sheet1

Title | Upload Date | Module | Authors | Print Publication Date | DOI | ISBN | Sub-discipline | LINK | Site Module Name
The Astaires | May-12 | Dance | Riley | 2012 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780199738410 | Music, Dance, Popular | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | [NAME]
Dance: Rituals of Experience | Oct-11 | Dance | [NAME] | 1997 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780195112054 | Music, Dance | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | [NAME]
Dancefilm | May-11 | Dance | Brannigan | 2011 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780195367232 | Music, Dance | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | [NAME]
Dancing Revelations | Oct-11 | Dance | DeFrantz | 2006 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780195301717 | Music, Dance | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | [NAME]
Embodying Mexico | Sep-11 | Dance | Hellier-Tinoco | 2011 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780195340365 | Music, Ethnomusicology, World Music, Dance | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | [NAME]
Hermes Pan | Sep-12 | Dance | Franceschina | 2012 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780199754298 | Music, Dance, Popular | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | [NAME]
[NAME] in Love and War | Sep-12 | Dance | [NAME] | 2012 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780199777662 | Music, Dance, History, American | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | [NAME]
[NAME] and the Ballets Russes | Sep-11 | Dance | Chazin-Bennahum | 2011 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780195399332 | Music, Dance | [NAME] | [NAME]
Screendance | Sep-12 | Dance | [NAME] | 2012 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780199772612 | Music, Dance | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | [NAME]
Tap Dancing America | Feb-10 | Dance | Hill | 2009 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780195390827 | Music, History, American, Dance | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | [NAME]
When Men Dance | Feb-10 | Dance | Fisher, Shay | 2009 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780195386691 | Music, Dance | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | [NAME]
Spreadsheet: 685517d1594051118-extract-every-words-after-certain-character-in-any-position-within-a-cell-then-split-pq-ask-ask-aligw
Sheet: Sheet1

 | Please read until line 37
 | LIST OF DATA | Column1 | Column13 | Column14 | Column12 | Column2
 | Kids>Boy (4 years and above)|Type>Christmas|Type>Festive|Brand>Mayoral|Type>Outerwear
 | Type>Chinese New Year|Chinese New Year|Baby>Girl (0-36 Months)|Type>Sets|Brand>Sissae
 | Baby>Girl (0-36 Months)|Type>Shoes|Brand>Tiny Soles
 | [NAME]
 | 1. How to extract EVERY TYPE, within each cell?
 | Result needed: |  | Category | Sub-Category
 | Christmas, Festive, Outerwear |  | Outerwear | Christmas, Festive
 | Chinese New Year, Sets |  | Sets | Chinese New Year
 | Shoes |  | Shoes
 | 2. And then let's assume there's list of item type
 | Column1
 | Top
 | Bottom
 | Outerwear
 | Sets
 | Shoes
 | and so on
 | How to automatically put those type,
 | which exist in list of item, in the first column?
 | which doesn't exist in list of item, in the second column?
 | Final Result needed: | 2nd column
 | 1st column | Christmas, Festive
 | Outerwear | Chinese New Year
 | Sets | -
 | Shoes
 | if there's solution to solve all questions above in a single move, it would be very helpful
 | thank you
Spreadsheet: 03f8bff6-9b02-445c-9208-fd1f74d13666
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
ANCA | Test | ANCA | Cytoplasmic Neutrophil Antibodies, Serum | [NAME], S | Indirect Immunofluorescence | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top  Acceptable: Serum gel [NAME]: 0.5 mL Additional Information: This test should not be mistaken for granulocyte antibodies. | 0.35 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | Negative If positive for cANCA, results are titered. | Monday through Saturday; 11 a.m. | 2 days | 4 days | 1 | 86255 |  |  |  |  | Rochester
ANCA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ANCA | Result | 3114 | c-ANCA | c-ANCA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35279-9
ANCA | Result | 3119 | p-ANCA | p-ANCA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17357-5
Spreadsheet: 694364d1599569032-average-days-based-on-matching-data-in-different-rows-metrics2
Sheet: METRICS

 | Jan-Jun | Week Starting
 | Weekly Average | 2020-06-29 00:00:00 | 2020-07-06 00:00:00 | 2020-07-13 00:00:00 | 2020-07-20 00:00:00 | 2020-07-27 00:00:00 | 2020-08-03 00:00:00 | 2020-08-10 00:00:00 | 2020-08-17 00:00:00 | 2020-08-24 00:00:00 | 2020-08-31 00:00:00 | 2020-09-07 00:00:00 | 2020-09-14 00:00:00 | 2020-09-21 00:00:00
Receipts
Inspected
Delivered
 |  | July Receipt Average |  |  |  |  | August Receipt Average |  |  |  | [NAME]
 |  | July Inspection Average |  |  |  |  | Aug Inspection Average |  |  |  | Sept Inspection Average
 |  | July Delivery Average |  |  |  |  | August Delivery Average |  |  |  | Sept Delivery Average
 | Week Starting
 | 2020-09-28 00:00:00 | 2020-10-05 00:00:00 | 2020-10-12 00:00:00 | 2020-10-19 00:00:00 | 2020-10-26 00:00:00 | 2020-11-02 00:00:00 | 2020-11-09 00:00:00 | 2020-11-16 00:00:00 | 2020-11-23 00:00:00 | 2020-11-30 00:00:00 | 2020-12-07 00:00:00 | 2020-12-14 00:00:00 | 2020-12-21 00:00:00 | 2020-12-28 00:00:00
Receipts
Inspected
Delivered
 |  | July Receipt Average |  |  |  | August Receipt Average |  |  |  |  | [NAME]
 |  | July Inspection Average |  |  |  | Aug Inspection Average |  |  |  |  | Sept Inspection Average
 |  | July Delivery Average |  |  |  | August Delivery Average |  |  |  |  | Sept Delivery Average
Daily Average | Week Starting
 | 2020-06-29 00:00:00 | 2020-07-06 00:00:00 | 2020-07-13 00:00:00 | 2020-07-20 00:00:00 | 2020-07-27 00:00:00 | 2020-08-03 00:00:00 | 2020-08-10 00:00:00 | 2020-08-17 00:00:00 | 2020-08-24 00:00:00 | 2020-08-31 00:00:00 | 2020-09-07 00:00:00 | 2020-09-14 00:00:00 | 2020-09-21 00:00:00
Receipts
Inspected
Delivered
 | 2020-09-28 00:00:00 | 2020-10-05 00:00:00 | 2020-10-12 00:00:00 | 2020-10-19 00:00:00 | 2020-10-26 00:00:00 | 2020-11-02 00:00:00 | 2020-11-09 00:00:00 | 2020-11-16 00:00:00 | 2020-11-23 00:00:00 | 2020-11-30 00:00:00 | 2020-12-07 00:00:00 | 2020-12-14 00:00:00 | 2020-12-21 00:00:00 | 2020-12-28 00:00:00
Receipts
Inspected
Delivered
Individual Average | Week Starting
 | 2020-06-29 00:00:00 | 2020-07-06 00:00:00 | 2020-07-13 00:00:00 | 2020-07-20 00:00:00 | 2020-07-27 00:00:00 | 2020-08-03 00:00:00 | 2020-08-10 00:00:00 | 2020-08-17 00:00:00 | 2020-08-24 00:00:00 | 2020-08-31 00:00:00 | 2020-09-07 00:00:00 | 2020-09-14 00:00:00 | 2020-09-21 00:00:00
Receipts
Inspected
Delivered
 | 2020-09-28 00:00:00 | 2020-10-05 00:00:00 | 2020-10-12 00:00:00 | 2020-10-19 00:00:00 | 2020-10-26 00:00:00 | 2020-11-02 00:00:00 | 2020-11-09 00:00:00 | 2020-11-16 00:00:00 | 2020-11-23 00:00:00 | 2020-11-30 00:00:00 | 2020-12-07 00:00:00 | 2020-12-14 00:00:00 | 2020-12-21 00:00:00 | 2020-12-28 00:00:00
Receipts
Inspected
Delivered
Dock to Stock Average
Spreadsheet: 0a379928-a7f3-47bb-908f-f8e3939b92db
Sheet: TSN (Canada)

TSN (Canada)
Date | Channel | Start (Local) | End (Local) | Notes
2010-11-22 00:00:00 | TSN | 14:00:00 | 16:00:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | TSN | 12:30:00 | 14:30:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | TSN | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | TSN | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | TSN | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-27 00:00:00 | TSN2 | 12:30:00 | 15:00:00 | Semi-Final 1 - Delayed (Singles)
2010-11-27 00:00:00 | TSN2 | 15:00:00 | 17:30:00 | Semi-Final 2 - Live (Singles)
2010-11-28 00:00:00 | TSN2 | 16:00:00 | 19:00:00 | Singles Final - Live
Spreadsheet: 681991d1591862947-conditional-formatting-severity-matrix-excel-samples
Sheet: Sheet1

Likelihood of the risk occurring | Impact if the risk occurs | Severity Rating based on impact & likelihood.
Medium | Medium | Medium |  |  |  | Likelihood
 |  |  |  |  |  | 1 | 2 | 3
 |  |  |  | Impact | 1 | Low | Low | Medium
 |  |  |  |  | 2 | Low | Medium | High
 |  |  |  |  | 3 | Medium | High | High
Spreadsheet: 177888d1346503543-how-to-tell-excel-not-to-check-column-in-sequence-book1
Sheet: Sheet1

 | Report | 1st Submission | 1st Reject | 2nd Submission | 2nd Reject | Date Submission | Date Reject
 | Report1 | 2012-08-01 00:00:00 | 2012-08-02 00:00:00 | 2012-08-04 00:00:00 | 2012-08-07 00:00:00 | 2012-08-04 00:00:00 | 2012-08-07 00:00:00
 | Report2 | 2012-08-05 00:00:00 | 2012-08-07 00:00:00 |  |  | 2012-08-05 00:00:00 | 2012-08-07 00:00:00
 | Report3 | 2012-08-04 00:00:00 |  |  |  | 2012-08-04 00:00:00
 | Report4
Spreadsheet: 124632d1318517201-approximate-break-even-point-with-lookup-analyse-bc
Sheet: Uren allocatie

[NAME] uren | [NAME] teksten | Week nr (teksten) | Linkbuild uren | [NAME] linkbuilding | Week nr (linkbuilding)
74 | KLOKKEN-EXPERT | 17 | 74 | KLOKKEN-EXPERT | 21 |  | FOTOSTUDIO-EXPERT
132 | KLOKKEN-EXPERT | 18 | 74 | KLOKKEN-EXPERT | 22
132 | KLOKKEN-EXPERT | 19 | 70 | KLOKKEN-EXPERT | 23
132 | KLOKKEN-EXPERT | 20 | 52 | KLOKKEN-EXPERT | 24
66 | KLOKKEN-EXPERT | 21 | 53 | KLOKKEN-EXPERT | 25
66 | KLOKKEN-EXPERT | 22 | 70 | KLOKKEN-EXPERT | 26
48 | KLOKKEN-EXPERT | 23 | 40 | KLOKKEN-EXPERT | 27
12 | KLOKKEN-EXPERT | 24 | 8 | KLOKKEN-EXPERT | 28
25 | FOTOSTUDIO-EXPERT | 40 |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT |  |  |  |  | NVT
 | NVT |  |  | NVT |  |  |  |  | BRIEVENBUS-EXPERT
 | NVT |  |  | NVT |  |  |  |  | EXPERT-SHOPS
 | NVT |  |  | NVT |  |  |  |  | FERNGLAS-EXPERT
 | NVT |  |  | NVT |  |  |  |  | FOTOSTUDIO-EXPERT
 | NVT |  |  | NVT |  |  |  |  | GLOBUS-EXPERT
 | NVT |  |  | NVT |  |  |  |  | KAPSTOK-EXPERT
 | NVT |  |  | NVT |  |  |  |  | KINDERBOEK-EXPERT
 | NVT |  |  | NVT |  |  |  |  | KLOKKEN-EXPERT
 | NVT |  |  | NVT |  |  |  |  | MICROSCOOP-EXPERT
 | NVT |  |  | NVT |  |  |  |  | MUURBEUGEL-EXPERT
 | NVT |  |  | NVT |  |  |  |  | PRODUCTGROEPEN
 | NVT |  |  | NVT |  |  |  |  | REKENMACHINE-EXPERT
 | NVT |  |  | NVT |  |  |  |  | STROPDAS-EXPERT
 | NVT |  |  | NVT |  |  |  |  | TELESCOOP-EXPERT
 | NVT |  |  | NVT |  |  |  |  | TELESCOPEPLANET
 | NVT |  |  | NVT |  |  |  |  | VERREKIJKER-EXPERT
 | NVT |  |  | NVT |  |  |  |  | VITRINEKAST-EXPERT
 | NVT |  |  | NVT |  |  |  |  | WEERSTATIONEXPERT
 | NVT |  |  | NVT |  |  |  |  | WERELDBOL-EXPERT
 | NVT |  |  | NVT |  |  |  |  | WIELERSPORT-EXPERT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
Spreadsheet: 286706d1388427770-stack-columns-problem-revisited-stack-columns
Sheet: target 2

ID | Data | Price | Int | First Date | Last Date
A | 02/27/2009 | 100.005 | 0 | 01/06/1989 | 06/24/1992
A | 03/06/2009 | 102.388 | 0.05
A | 03/13/2009 | 99.85 | 0.166666666666667
A | 03/20/2009 | 97.676 | 0.283333333333333
A | 03/27/2009 | 98.617 | 0.4
A | 04/03/2009 | 98.481 | 0.5
A | 04/09/2009 | 99.846 | 0.6
A | 04/17/2009 | 101.099 | 0.733333333333333
A | 04/24/2009 | 101.239 | 0.8500000000000001
A | 05/01/2009 | 102.089 | 0.966666666666667
A | 05/08/2009 | 99.706 | 1.08333333333333
A | 05/15/2009 | 102.088 | 1.2
A | 05/22/2009 | 99.431 | 1.31666666666667
A | 05/29/2009 | 102.372 | 1.43333333333333
A | 06/05/2009 | 100.675 | 1.53333333333333
A | 06/12/2009 | 103.091 | 1.65
A | 06/19/2009 | 103.964 | 1.76666666666667
A | 06/26/2009 | 105.745 | 1.88333333333333
A | 07/02/2009 | 105.744 | 1.98333333333333
A | 07/10/2009 | 107.262 | 2.11666666666667
A | 07/17/2009 | 103.525 | 2.23333333333333
A | 07/24/2009 | 104.698 | 2.35
A | 07/31/2009 | 109.917 | 2.46666666666667
B | 01/06/1989 | 61.24 | -- | 01/06/1989 | 06/24/1992
B | 01/13/1989 | 61.63
B | 01/20/1989 | 62
B | 01/27/1989 | 62.34
B | 02/03/1989 | 62.22
B | 02/10/1989 | 62.06
B | 02/17/1989 | 62.07
B | 02/24/1989 | 61.81
B | 03/03/1989 | 61.83
B | 03/10/1989 | 62.03
C |  |  | -- |  |  |  |  | no date and price values for C; can either delete C group or stack C group in the target worksheet
D | 07/10/1987 | 113.95 | -- | 07/10/1987 | 08/08/1989
D | 07/17/1987 | 113.78
D | 07/24/1987 | 113.62
D | 07/31/1987 | 113.16
D | 08/07/1987 | 112.91
D | 08/14/1987 | 112.84
D | 08/21/1987 | 112.87
Spreadsheet: 141152d1329131653-dynamic-data-validation-list-generation-based-on-multiple-criteria-paragb_seat_sample
Sheet: Seat Pool

Seat No | Group Head | Status |  |  |  |  |  |  | HARRY_VACANT_LIST
GE6-43 | [NAME] | OCCUPIED
GE6-65 | [NAME] | OCCUPIED
GE6-69 | [NAME] | VACANT
GE6-78 | [NAME] | OCCUPIED
GE6-86 | [NAME] | OCCUPIED
GE6-87 | [NAME] | VACANT
GE6-89 | [NAME] | VACANT
GE6-90 | [NAME] | OCCUPIED
GE6-91 | [NAME] | OCCUPIED
GE6-92 | [NAME] | VACANT
GE6-93 | [NAME] | OCCUPIED
GE6-95 | [NAME] | VACANT
GE6-96 | [NAME] | VACANT
GE6-97 | [NAME] | VACANT
GE6-98 | [NAME] | OCCUPIED
GE6-99 | [NAME] | OCCUPIED
Spreadsheet: 775407d1649086488-matching-information-on-two-sheets-formula-test-aligw
Sheet: Sheet2

Type | Brand | Model | Length | [NAME] | Height | Size | Price
 |  |  |  |  |  |  | 3500
[NAME] | Gypsey | Gypsey 2 | 3840 | 2075 | 2510 | Small | 3500
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
[NAME] | Gypsey | Gypsey 3 | 4490 | 2190 | 2160 | Medium | 3800
[NAME] | Gypsey | Gypsey 4 | 5143 | 2070 | 2160 | Large | 3950
[NAME] | Gypsey | Gypsey 5 | 5650 | 2190 | 2550 | X-Large | 4200
[NAME] | Gypsey | Gysey 3B | 5200 | - | - | XX-Large | 4450
[NAME] | Gypsey | Gypsey 3C | 4500 | - | - | [NAME] | 4650
[NAME] | Gypsey | Caravette 2 | 4500 | - | - | Small | 3500
[NAME] | Gypsey | Caravette 3 | 4100 | 1840 | 2005 | Medium | 3800
[NAME] | Gypsey | Caravette 4 | 4500 | 2082 | 2220 | Large | 3950
[NAME] | Gypsey | Caravette 5 | 4500 | 2082 | 2240 | X-Large | 4200
[NAME] | Gypsey | Caravette 6 | 5100 | 2193 | 2260 | XX-Large | 4450
[NAME] | Gypsey | Rapier | 4570 | 2270 | 2270 | [NAME] | 4650
[NAME] | Gypsey | Rapture | 4826 | 2246 | 2265 | Small | 3500
[NAME] | Gypsey | Rascal | 4327 | 2199 | 2220 | Medium | 3800
Spreadsheet: 109975d1306782531-sorting-datablocks-sort-blocks
Sheet: Sheet1

leave this row blank
name | id | 4585848 | day | ## | 3 |  | 4585848
street | number | stuff 1 | stuff 2 | stuff 3 | stuff 4 | stuff 5 | 4585848
12345566 | 123 | 123 | 123 | 123 | 123 | 123 | 4585848
23455666 | 123 | 123 | 123 | 123 | 123 | 123 | 4585848
 |  |  |  |  |  |  | 4585848
name | id | 4585827 | day | ## | 3 |  | 4585827
street | number | stuff 1 | stuff 2 | stuff 3 | stuff 4 | stuff 5 | 4585827 |  | now select all sort by col h decending
12345566 | 456 | 456 | 456 | 456 | 456 | 456 | 4585827
23455666 | 456 | 456 | 456 | 456 | 456 | 456 | 4585827
 |  |  |  |  |  |  | 4585827
name | id | 4585831 | day | ## | 3 |  | 4585831
street | number | stuff 1 | stuff 2 | stuff 3 | stuff 4 | stuff 5 | 4585831
12345566 | 345 | 345 | 345 | 345 | 345 | 345 | 4585831
23455666 | 345 | 345 | 345 | 345 | 345 | 345 | 4585831
 |  |  |  |  |  |  | 4585831
name | id | 4585841 | day | ## | 3 |  | 4585841
street | number | stuff 1 | stuff 2 | stuff 3 | stuff 4 | stuff 5 | 4585841
12345566 | 234 | 234 | 234 | 234 | 234 | 234 | 4585841
23455666 | 234 | 234 | 234 | 234 | 234 | 234 | 4585841
 |  |  |  |  |  |  | 4585841
Spreadsheet: 767850d1644675112-extracting-data-from-another-workbook-example-bradleyn1-
Sheet: Sheet1

 |  |  |  |  |  |  | [NAME] 2
 |  |  |  |  |  |  | ID | Review | Status | Completed by
 |  |  |  |  |  |  | 1 | Review 1 | Complete | Name 1
 |  |  |  |  |  |  | 2 | Review 1 | Not started | Name 2
 |  |  |  |  |  |  | 3 | Review 2 | Needs action | Name 3
 |  |  |  |  |  |  | 4 | Review 2 | Complete | Name 4
 | I want this workbook to pull across the status of reviews if the ID matches, and the review aligns to the header. Example results are populated.
Spreadsheet: 743448fd-dd76-4640-a490-a963f5f22ea0
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44320067 | 2014-12-05 23:57:37 | ALLIES | 0 | 8 | 10 | 185665 | bteistun | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44345822 | 2014-12-07 18:38:16 | ALLIES | 0 | 4 | 6 | 1103996 | HIRO-HITO | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
44346005 | 2014-12-07 18:50:50 | AXIS | 0 | 4 | 6 | 1103996 | HIRO-HITO | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
44347746 | 2014-12-07 20:50:27 | ALLIES | 1 | 5 | 2 | 1422784 | flarchi | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
44349710 | 2014-12-07 23:09:37 | ALLIES | 0 | 4 | 6 | 1009110 | HO-SA-KAI | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44349912 | 2014-12-07 23:26:10 | AXIS | 0 | 4 | 6 | 1009110 | HO-SA-KAI | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44403209 | 2014-12-11 22:46:52 | ALLIES | 0 | 4 | 6 | 1524381 | komark | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
44403427 | 2014-12-11 23:05:26 | AXIS | 0 | 3 | 6 | 1524381 | komark | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
44427771 | 2014-12-13 19:07:15 | ALLIES | 1 | 6 | 3 | 309734 | Lamanick | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44427881 | 2014-12-13 19:20:32 | AXIS | 1 | 6 | 4 | 309734 | Lamanick | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44428081 | 2014-12-13 19:43:49 | ALLIES | 0 | 5 | 6 | 1523772 | rice dolar | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
44429940 | 2014-12-13 21:58:19 | ALLIES | 1 | 6 | 1 | 1204546 | [NAME] | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44441858 | 2014-12-14 17:58:57 | ALLIES | 1 | 7 | 6 | 1077170 | [NAME] | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44442074 | 2014-12-14 18:14:04 | AXIS | 1 | 7 | 6 | 1077170 | [NAME] | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
Spreadsheet: 0517df54-0c30-4745-b7b0-d9d9e78c2682
Sheet: Table III.9

Table III.9 الجدول
Proportion of species threatened with extinction
نسبة الفصائل المهددة بالانقراض
 | Number of threatened mammal species |  |  |  | Number of threatened bird species |  |  | Number of threatened reptile species |  |  | Number of threatened amphibian species |  |  | Number of threatened fish species |  |  | Number of threatened plant species
 | عدد فصائل الثدييات المهددة بالانقراض |  |  |  | عدد فصائل الطيور المهددة بالانقراض |  |  | عدد فصائل الزواحف المهددة بالانقراض |  |  | عدد فصائل البرمائيات المهددة بالانقراض |  |  | عدد فصائل الأسماك المهددة بالانقراض |  |  | عدد فصائل النباتات المهددة بالانقراض
 | 2006 |  | 2008 | 2010 | 2006 | 2008 | 2010 | 2006 | 2008 | 2010 | 2006 | 2008 | 2010 | 2006 | 2008 | 2010 | 2006 | 2008 | 2010
Bahrain | 2 |  | 3 | 3 | 7 | 4 | 4 | 4 | 4 | 4 | - | - | - | 6 | 6 | 8 | - | - | - | البحرين
Egypt | 14 |  | 17 | 17 | 18 | 10 | 10 | 11 | 11 | 10 | - | - | - | 17 | 24 | 36 | 2 | 2 | 2 | مصر
Iraq | 12 |  | 13 | 13 | 18 | 18 | 18 | 2 | 2 | 2 | 2 | 1 | 1 | 5 | 6 | 11 | - | - | - | العراق
Jordan | 12 |  | 13 | 13 | 15 | 8 | 10 | 5 | 5 | 5 | - | - | - | 12 | 14 | 13 | - | - | 1 | الأردن
Kuwait | 5 |  | 6 | 6 | 12 | 8 | 9 | 2 | 2 | 2 | - | - | - | 9 | 10 | 11 | - | - | - | الكويت
Lebanon | 9 |  | 10 | 10 | 10 | 6 | 7 | 7 | 6 | 6 | - | - | - | 10 | 15 | 21 | - | - | 1 | لبنان
Oman | 13 |  | 9 | 9 | 14 | 9 | 10 | 4 | 4 | 4 | - | - | - | 21 | 20 | 24 | 6 | 6 | 6 | عمان
Palestine | - |  | 3 | 3 | 4 | 7 | 8 | 4 | 4 | 4 | - | 1 | 1 | - | 1 | - | - | - | - | فلسطين
Qatar | 1 |  | 2 | 2 | 7 | 4 | 5 | 2 | 1 | 1 | - | - | - | 6 | 7 | 11 | - | - | - | قطر
Saudi Arabia | 12 |  | 9 | 9 | 18 | 14 | 14 | 2 | 2 | 2 | - | - | - | 13 | 16 | 22 | 3 | 3 | 3 | المملكة العربية السعودية
The Sudan | … |  | 14 | 15 | … | 13 | 14 | … | 3 | 3 | … | - | - | … | 13 | 17 | … | 17 | 18 | السودان
Syrian Arab Republic |  | 10 | 16 | 16 | 14 | 13 | 13 | 7 | 6 | 6 | - | - | - | 22 | 27 | 33 | - | - | 3 | الجمهورية العربية السورية
United Arab Emirates |  | 7 | 7 | 7 | 12 | 8 | 10 | 2 | 2 | 2 | - | - | - | 8 | 9 | 13 | - | - | - | الإمارات العربية المتحدة
Yemen | 13* |  | 13* | 13* | 14 | 13 | 14 | 2 | 3 | 3 | 1 | 1 | 1 | 13 | 18 | 21 | 159 | 159 | 159 | اليمن
ESCWA** | 110 |  | 135 | 136 | 163 | 135 | 146 | 54 | 55 | 54 | 3 | 3 | 3 | 142 | 186 | 241 | 170 | 187 | 193 | [NAME]
Source: | IUCN Red List of Threatened Species, version 2010.4, International Union for Conservation of Nature and Natural Resources, accessed on 13 June 2011 from: http://www.iucnredlist.org/about/summary-statistics.
Notes: | * | Central Statistical Organization reply to ESCWA on the preliminary tables for the Compendium of Environment Statistics 2010-2011.
 | ** | ESCWA calculation.
Spreadsheet: b5764a0f-da1b-4fbf-90a1-c0de8eee10c6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8302 | 20820 | Rainer | Kotthaus | GER | 0 | 01:23:42 | 00:04:49 | 05:56:23 | 00:03:53 | 05:07:48 | 1 | [NAME]
Spreadsheet: 877916d1724851734-index-and-match-function-not-working-help-aop-per-tech
Sheet: Jan

TECH | HOURS | AVG-PER DAY | OBJ RATE | % OF TOTAL HOURS | OBJECTIVE |  |  | Column1 | Column2
[NAME], | 467.28 |  |  |  |  |  |  | AOP $ | 1062606
THOAI LE, | 409.8 |  |  |  |  |  |  | ELR | 150.26
[NAME], | 398.79 |  |  |  |  |  |  | AOP HOURS
MASON SHAWN, | 377.61 |  |  |  |  |  |  | WORKING DAYS | 24
DIEGO MERCADO, | 351.75
[NAME], | 332.22 |  |  |  |  |  |  | TOTAL HOURS | 7710.76
TRAVIS GREGORY, | 307.86
GIANCARLO PACHECO, | 299.99
[NAME], | 292.09
[NAME], | 276.4
ANZOR KHATAEV, | 265.93
TYLER MUNGER, | 256.13
[NAME], | 235
TYLER BIXLER, | 227.3
[NAME], | 215.75
SIMON NELSON, | 213.4
RYAN GUAGENTI, | 213.1
CHASE FRY, | 206.7
SHANE GILLESPIE, | 200.05
FLORES GUARDADO, | 190.35
SHAWN GROOVER, | 190.34
[NAME], | 184.75
XIAO ZHANG, | 176.2
COELLO VALLEJO, | 172.08
[NAME], | 170.13
GUARDADO RODAS, | 160.8
BRADLEY OLIVA, | 160.75
[NAME], | 154.46
[NAME], | 148.88
[NAME], | 141.19
[NAME], | 114.6
[NAME], | 103.8
WYLIE ROWE, | 52.93
[NAME], | 23.3
[NAME], | 8.4
[NAME], | 6.85