tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 873036d1719478639-conditional-formatting-book2
Sheet: Sheet1

FP |  | CB |  | KT |  | AW |  | DB |  | KR |  | EC |  | CL |  | DW |  | TM |  | MB |  | RA |  | SG |  | KM |  | AS
Stores | Units | Stores | Units | Stores | Units | Stores | Units | Stores | Units | Stores | Units | Stores | Units | Stores | Units | Stores | Units | Stores | Units | Stores | Units | Stores | Units | Stores | Units | Stores | Units | Stores | Units
710 | 8 | 19 | 72 | 198 | 49 | 45 | 95 | 944 | 101 | 35 | 122 | 305 | 3 | 46 | 60 | 1719 | 112 | 410 | 141 | 79 | 51 | 899 | 32 | 403 | 26 | 1259 | 59 | 738 | 178
733 | 16 | 1305 | 56 | 455 | 71 | 199 | 73 | 1730 | 77 | 407 | 30 | 350 | 42 | 1371 | 59 | 1826 | 64 | 1062 | 48 | 872 | 104 | 1445 | 144 | 1553 | 353 | 1738 | 238 | 1586 | 386
1743 | 94 | 1768 | 42 | 1187 | 82 | 1408 | 38 | 1855 | 30 | 838 | 38 | 1675 | 165 | 1757 | 142 | 1909 | 69 | 1394 | 111 | 1267 | 87 | 1700 | 56 | 1877 | 14 | 1903 | 87 | 1825 | 256
 |  | 1797 | 106 | 1766 | 77 | 1542 | 81 | 2065 | 34 | 1172 | 80 | 1985 | 0 | 1759 | 50 | 1997 | 86 | 2052 | 49 | 1684 | 119 | 1896 | 173 |  |  | 1931 | 166 | 1957 | 67
Spreadsheet: 121277d1315966827-excel-2007-consolidate-data-based-on-date-alerts
Sheet: Sheet1

# of Alerts | Date | Helper column (not sure if needed) |  | Today |  |  | Total Alerts
63 | 2011-08-04 00:00:00 | 1
472 | 2011-08-04 00:00:00
103 | 2011-08-04 00:00:00
953 | 2011-08-04 00:00:00
296 | 2011-08-09 00:00:00
27 | 2011-08-11 00:00:00
198 | 2011-08-13 00:00:00
271 | 2011-08-13 00:00:00
168 | 2011-08-16 00:00:00
207 | 2011-08-16 00:00:00
76 | 2011-08-17 00:00:00
85 | 2011-08-18 00:00:00
66 | 2011-08-19 00:00:00
68 | 2011-08-20 00:00:00
71 | 2011-08-21 00:00:00
24 | 2011-08-22 00:00:00
233 | 2011-08-23 00:00:00
30 | 2011-08-23 00:00:00
89 | 2011-08-24 00:00:00
69 | 2011-08-25 00:00:00
89 | 2011-08-26 00:00:00
74 | 2011-08-27 00:00:00
59 | 2011-08-28 00:00:00
26 | 2011-08-29 00:00:00
Spreadsheet: 757675d1638390385-remove-alphabets-from-number-string-in-a-cell-sample-3-
Sheet: Summary

Part |  |  | Part
1011011011A |  |  | 1011011011
1021021022 |  |  | 1021021022
1031031033C |  |  | 1031031033
12345-12 |  |  | 12345-12
45678-90E |  |  | 45678-90
2012012012 |  |  | 2012012012
1041041044 |  |  | 1041041044
1061061066D |  |  | 1061061066
Spreadsheet: a7ee8392-525a-406f-b0da-aec8bef5cb9a
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
EPOR | Test | EPOR | Erythropoietin Receptor (EPOR) Gene, Exon 8 Sequencing | [NAME], Mutation Analysis, B | Polymerase Chain Reaction (PCR) Amplification/Sanger Sequence Analysis |  |  |  |  |  | Only orderable as part of a profile. For further information see HEMP/61337 Hereditary Erythrocytosis Mutations. | 0.5 mL |  | Only orderable as part of a profile. For further information see HEMP/61337 Hereditary Erythrocytosis Mutations. |  |  |  | 1 | 81479 |  |  |  |  | Rochester
EPOR | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 30 days
EPOR | Result | 34645 | EPOR Gene Sequencing Result | EPOR Gene Sequencing Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 687504d1595254945-how-do-i-split-long-paragraphs-by-character-count-without-separating-words-dividing-paragraphs-aligw
Sheet: Sheet1

What is [NAME]? [NAME] is simply dummy text of the printing and typesetting industry. [NAME] has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing [NAME] passages, and more recently with desktop publishing software like Aldus PageMaker including versions of [NAME]. Why do we use it? It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using [NAME] is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use [NAME] as their default model text, and a search for '[NAME] ipsum' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).
Spreadsheet: 86925d1286879832-outstanding-balance-on-each-ref-no-pivot-table-ramzes
Sheet: Working

 | 016453 | 750 | 500 | 0 | 250 | 1
 | 014583 | 1300 | 1200 | 0 | 100 | 2
 | 016823 | 1340 | 0 | 0 | 1340 | 3
 | 015734 | 700 | 0 | 0 | 700 | 4
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
9 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
17
25
37
Spreadsheet: 77443d1277912394-extract-room-number-and-student-id-and-put-them-in-other-cells-studenthousing-3-
Sheet: 3910

Building No:- 3910 | Mr. [NAME] Mask Roman | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME]
Date | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo
2010-06-30 00:00:00 | 131 | 107A | 108B | 112B | 116A | 120B | 127A | 127B | 129A | 137B
OUTSTANDING
SATISFACTORY
UNSATISFACTORY
DOOR UNLOCKED
WINDOW UNLOCKED
LOCKER UNLOCKED
CARPET Not SWEPT
DUST
BEDS UNMADE
MESSY
MICROWAVE DIRTY
FREEZER DIRTY
REFRIGERATOR DIRTY
LIGHTS / APPLIANCES ON
CEILING FAN ON
OPEN FOOD NOT STORED
TRASH IN ROOM / HEAD
MIRROR / SHELF DIRTY
SINK / BRIGHTWORK DIRTY
FLOOR IN BATH DIRTY
TUB / SHOWER DIRTY
SHOWER CURTAIN DIRTY
TOILET DIRTY
ODOR
Dirty TILE
Spreadsheet: 0e26dee2-3d59-4bf4-8733-b59e20dedf48
Sheet: DeadEND

Reaction ID | reversibility | Metabolites ID | Metabolites character | Metabolites state
R0033 | r | gam | reactant | oneSub_Product
R0050 | irev | agm | reactant | IsDeadEnd
[NAME] | irev | hpglu | Product | IsDeadEnd
[NAME] | irev | mhpglu | reactant | IsDeadEnd
R0109 | irev | metsox-S-L | reactant | IsDeadEnd
R0258 | r | [NAME] | Product | oneSub_Product
R0265 | r | f1p | reactant | oneSub_Product
R0288 | r | [NAME] | reactant | oneSub_Product
R0292 | irev | 5oxpro | reactant | IsDeadEnd
R0345 | irev | clpn_SC | Product | IsDeadEnd
R0348 | irev | mi4p-D | reactant | IsDeadEnd
R0353 | irev | mi145tp-D | Product | IsDeadEnd
R0355 | irev | ptd135bp_SC | Product | IsDeadEnd
R0385 | irev | glyclt | reactant | IsDeadEnd
R0402 | irev | meoh | reactant | IsDeadEnd
R0458 | irev | fmettrna | Product | IsDeadEnd
R0458 | irev | mettrna | reactant | IsDeadEnd
R0465 | irev | pad | reactant | IsDeadEnd
R0466 | r | peamn | reactant | oneSub_Product
R0472 | irev | ptth | reactant | IsDeadEnd
R0477 | irev | ptcys | reactant | IsDeadEnd
[NAME] | r | udpglcur | Product | oneSub_Product
R0486 | irev | glcn-D | reactant | IsDeadEnd
R0495 | irev | urate | reactant | IsDeadEnd
R0509 | r | C04051 | Product | oneSub_Product
R0518 | r | didp | reactant | oneSub_Product
R0579 | irev | pheme | Product | IsDeadEnd
R0581 | irev | sheme | Product | IsDeadEnd
R0674 | r | [NAME] | Product | oneSub_Product
R0718 | irev | mip2c124_SC | Product | IsDeadEnd
R0719 | irev | mip2c126_SC | Product | IsDeadEnd
R0720 | irev | mip2c224_SC | Product | IsDeadEnd
R0721 | irev | [NAME] | Product | IsDeadEnd
R0722 | irev | mip2c324_SC | Product | IsDeadEnd
R0723 | irev | mip2c326_SC | Product | IsDeadEnd
R0741 | r | suc6p | reactant | oneSub_Product
R0777 | irev | hyptaur | Product | IsDeadEnd
R0790 | irev | pydx5p | Product | IsDeadEnd
R0801 | irev | dxyl | reactant | IsDeadEnd
R0802 | irev | thmtp | Product | IsDeadEnd
R0809 | irev | [NAME] | Product | IsDeadEnd
R0813 | irev | Lkynr | reactant | IsDeadEnd
R0816 | irev | [NAME] | Product | IsDeadEnd
R0816 | irev | ppccvn | Product | IsDeadEnd
R0821 | irev | iad | reactant | IsDeadEnd
R0823 | irev | trnatrp | reactant | IsDeadEnd
R0823 | irev | [NAME] | Product | IsDeadEnd
R0836 | irev | homoval | Product | IsDeadEnd
R0837 | irev | dopa | reactant | IsDeadEnd
R0853 | irev | [NAME] | Product | IsDeadEnd
R0853 | irev | trnaile | reactant | IsDeadEnd
R0854 | irev | leutrna | Product | IsDeadEnd
R0854 | irev | trnaleu | reactant | IsDeadEnd
R0855 | irev | trnaval | reactant | IsDeadEnd
R0855 | irev | valtrna | Product | IsDeadEnd
R0897 | r | b124tc | Product | oneSub_Product
R0898 | r | ppcdhpa | Product | oneSub_Product
R0900 | irev | dimp | Product | IsDeadEnd
R0920 | irev | [NAME] | Product | IsDeadEnd
R0934 | irev | dolichol | reactant | IsDeadEnd
Spreadsheet: daren_farmer__5640__HPLN1222
Sheet: Sheet1

[NAME] |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - December 22-26, 2000
 |  |  |  |  |  | **Friday | **Sat/Sun | **Mon/Tues
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-12-22 00:00:00 | 12/23-24/2000 | 12/25-26/2000
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | Enron | 10 | 10 | 10 | 10
Enron (S) |  | LS HPL [NAME] |  | Enron | 30 | 0 | 0 | 0
Enron (S) |  | Oasis Sealy |  | Enron | 30 | 0 | 0 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 66650d1267290603-solved-removing-a-div-0-error-sample101
Sheet: Sheet1

 | 0.88 | T1 | T1
 | 0.66 | T2 | T2
 | 0.77 | T2 | T3
 | 0.46 | T2
 | 0.39 | T1
 | 0.21 | T1
 | 0.65 | T2
 | 0.46 | T1
 | 0.89 | T2
Spreadsheet: a88c4c15-e7f4-4c3d-bdf5-df16439da684
Sheet: Sheet1

Unnamed: 0 | SVG Coater and [NAME] Use Only | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Week of Jan 24 - Jan 31, 2011
 |  | 1um | 1.6um | 3um | 7um | 1um | 1.6um | 1.6um | 1.6um | 3um
SVG                         Coater | Date (Coat) | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 |  | 2011-01-25 00:00:00 | 2011-01-25 00:00:00
 | Track | 1 | 1 | 1 |  | 2 | 2
 | Prime Program | Yes Oven | Yes Oven | Yes Oven |  | Yes Oven | Yes Oven
 | Coat Program | 7 | 8 | 4 |  | 7 | 8
 | Oven Program | 1 | 2 | 3 |  | 1 | 2
 | Problems
Thickness Measurements                                (NanoSpec) | Date (Measurement) | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 |  | 2011-01-25 00:00:00 | 2011-01-25 00:00:00
 | Top (A) | 10133 | 16752 | 30032 |  | 10224 | 16957 |  |  | -
 | Center (A) | 10109 | 16729 | 30105 |  | 10193 | 16954 |  |  | -
 | Flat (A) | 10128 | 16738 | 30022 |  | 10222 | 16943 |  |  | -
 | Left  (A) | 10146 | 16738 | 30000 |  | 10217 | 16963 |  |  | -
 | Right (A) | 10142 | 16740 | 30046 |  | 10225 | 16954 |  |  | -
 | Average (A) | 10131.6 | 16739.4 | 30041 |  | 10216.2 | 16954.2 |  |  | -
 | [NAME]  (A) | 14.50172403533524 | 8.234075540819438 | 39.50949253027682 |  | 13.33041634769823 | 7.259476564331554 |  |  | -
 | Comments
Exposure | Date (Exposure) | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 |  | 2011-01-25 00:00:00 | 2011-01-25 00:00:00
 | Tool | Ks1 | Ks1 | Ks1 |  | Ks2 | Ks2
 | Contact Type | Vac | Vac | Vac |  | Vac | Vac
 | Exposure Time | 1 | 1.6 | 3 |  | 1 | 1.6
 | Problems
SVG                            Developer | Date (Develop) | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 |  | 2011-01-25 00:00:00 | 2011-01-25 00:00:00
 | Track | 1 | 1 | 1 |  | 2 | 2
 | Pre-bake Program | 1 | 3 | 9 |  | 1 | 3
 | Develop Program | 3 | 4 | 7 |  | 3 | 4
 | Post-base Program | 1 | 2 | 9 |  | 1 | 2
 | Problems
Resolution                         Measurements                         (Dark Field) | Date (Measurement) | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 |  | 2011-01-25 00:00:00 | 2011-01-25 00:00:00
 | Top (H/V) (um) | 1 | 1.5 | 2 |  | 1.5 | 1
 | Center (H/V) (um) | 1 | 1.5 | 1.5 |  | 1.5 | 1
 | Flat (H/V) (um) | 1 | 1.5 | 1.5 |  | 1.5 | 1.5
 | Left (H/V) (um) | 1 | 1.5 | 1.5 |  | 1.5 | 1.5
 | Right (H/V) (um) | 1 | 1.5 | 2 |  | 1.5 | 1.5
 | Comments
Resolution                         Measurements                         (Light Field) | Date (Measurement) | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 |  | 2011-01-25 00:00:00 | 2011-01-25 00:00:00
 | Top (H/V) (um) | 1-1.5 | 1.5 | 1.5 |  | 1.5 | 1.5
 | Center (H/V) (um) | 1.5 | 1.5 | 1.5 |  | 1.5 | 1.5
 | Flat (H/V) (um) | 1.5 | 1.5 | 2 |  | 1.5 | 2
 | Left (H/V) (um) | 1.5 | 1.5 | 2 |  | 1.5 | 1.5
 | Right (H/V) (um) | 1.5 | 1.5 | 1.5 |  | 1.5 | 1.5
 | Comments
Spreadsheet: 785622d1656516524-return-most-recent-value-that-is-not-zero-test-hsa
Sheet: Sheet1

Plan Year | Employee ID | ER Contribution |  |  |  |  | Expected Value
21-22 | CHA003 | 0 |  |  |  | CHA003 | 600
20-21 | CHA003 | 600 |  |  |  | UHA000 | 300
19-20 | CHA003 | 0 |  |  |  | KEN003 | 600
21-22 | UHA000 | 300 |  |  |  | MOY004 | 300
20-21 | UHA000 | 300 |  |  |  | ZAD000 | 0
19-20 | UHA000 | 300
20-21 | KEN003 | 600
21-22 | MOY004 | 0
20-21 | MOY004 | 300
19-20 | MOY004 | 600
Spreadsheet: 851131d1701362174-vlookup-formulas-with-3-criterias-kev56_example-2-with-similar-country-id
Sheet: Sheet1

Document Number | Country ID | Product Name | [NAME]
IN000496 | BE | Tables | 16
IN000496 | HR | Beds | 24
IN000496 | BE | Tables | 6
IN000497 | CZ | Sofas | 9
IN000498 | PT | Sofas | 10
IN000498 | FR | Tables | 5
IN000498 | PT | Sofas | 4
IN000499 | IE | Tables | 5
IN000499 | ES | Beds | 12
Spreadsheet: 24145d1214258733-continually-increasing-the-value-of-a-cell-and-implying-the-result-on-a-column-example1
Sheet: deffad

Prod | Diff | Stat | Dis |  | St.size | Dis/prod -ratio
84 | 55 | 55 | 0 |  |  | 0.2324324324324324
64 | 34 | 70 | 19 |  |  |  |  | St.size | 70
110 | 85 | 70 | 85
50 | -15 | 55 | 0
25 | -43 | 12 | 0
44 | -28 | 0 | 0
58 | -10 | 0 | 0
120 | 95 | 70 | 25
Spreadsheet: 697861d1601573542-calculating-overtime-past-40-hours-work-hours-and-cost-estimate
Sheet: Work Hours and Cost Estimate

People per Shift | 8
Total Man hours | 1500
Regular Rate | 75
OT Rate | 140
 |  |  |  |  |  |  |  |  | Revise formula
Scenario | Hours | RP | Total Hours | OT Factor | OT Hours |  | Calc | Number of Hours | Number of Days | Regular Rate Cost | OT Rate Cost
8x5 | 8 | 5 |  | 0
8x5+Sat | 8 | 6 |  | 8
8x5+Sat/Sun | 8 | 7 |  | 16
10x5 | 10 | 5 |  | 10
10x5+Sat | 10 | 6 |  | 20
10x5+Sat/Sun | 10 | 7 |  | 30
12x5 | 12 | 5 |  | 20
12x5+Sat | 12 | 6 |  | 32
12x5+Sat/Sun | 12 | 7 |  | 44
16x5 CON | 16 | 5 |  | 40
16x6 Sat CON | 16 | 6 |  | 56
16x7 Sun CON | 16 | 7 |  | 72
20x5 CON | 20 | 5 |  | 60
20x6 CON | 20 | 6 |  | 80
24x5 CON | 24 | 5 |  | 80
24x6 CON | 24 | 6 |  | 104
 | Need to add overtime hours after regular dayshift
 | 5/6/7 day option 16 hours for sat/sun
Spreadsheet: 263959d1378740541-auto-inserting-data-in-cells-test
Sheet: Mon

Duty Allocation Sheet
Date | 9th | SEPT |  | PRINTED | 2013-09-09 16:28:26
Day | 1900-01-01 00:00:00 |  |  |  | MONDAY | TEAM A STAFF CANNOT BE CHANGED ONLY THOSE WORKING OT ON SHIFT
 |  |  |  |  |  |  |  |  |  |  | THIS PAGE IS PROTECTED AS UNAUTHORISED CHANGES WILL EFFECT ANY FORMULAS THEREIN                        TIMES CAN ONLY BE CHANGED IN COLUMN "H" THIS WILL AUTOMATICALLY CHANGE IN COLUMN "C"                                                                       NAMES CAN BE MANUALLY ENTERED IN COLUMN "B" BUT MUST BE EXACTLY AS SPELT IN COLUMN "G"
Position | NAME | Start/Finish | Break | O/T |  |  | MON
Team Manager | [NAME] | 1300-2200 |  |  |  |  | 9th
Asst Manager | EMMA TURK | H |  |  | DC40 | [NAME] | 1300-2200
 |  |  |  |  |  | EMMA TURK | H
[NAME] |  |  |  |  |  | [NAME] | 1400-2300
 |  |  |  |  |  | [NAME] | SALES
 | NAME |  |  |  |  | HELEN MCCOMB | S
[NAME] | [NAME] | SALES |  |  | SALES DESK | MERVYN TODD | 1700-0200
PSA | MERVYN TODD | 1700-0200 |  |  | SPEEDY BOARDING | [NAME] | 1430-1900
PSA |  |  |  |  |  | PATRICIA PHILLIPS | X
PSA | [NAME] | 1430-1900 |  |  | BAG DROP | GEMMA McDONNELL | 0730-1630
PSA |  |  |  |  |  | JULIE DAVIES | 1230-2130
 | LAUREN MCKIMM | 1230-1700 |  |  | ALL FLIGHTS | EMILIA DE LA TORRE
PSA |  |  |  |  |  | SIMON LYTTLE | 1230-2130
PSA | ERIN SCOTT | 1100-1900 |  |  |  | [NAME] | 1400-2300
PSA |  |  |  |  |  | [NAME] | 1230-2130
PSA | TIERNAGH BIGLEY | 1230-1700 |  |  |  | LEANNE MARTIN | MAT
PSA |  |  |  |  |  | LAUREN HORNER | X
PSA |  |  |  |  |  | LORRAINE NESBITT | X
PSA |  |  |  |  |  | COLETTE WEIR | H
 |  |  |  |  |  | TIERNAGH BIGLEY | 1230-1700
Ezy Departures |  |  |  |  |  | LAUREN MCKIMM | 1230-1700
 |  |  |  |  |  | ROSIE O'HARA | 1230-2130
PSA | [NAME] | 1230-2130 |  |  |  | MARIE MCATEER | 1230-2130
PSA | SIMON LYTTLE | 1230-2130 |  |  |  | [NAME] | H
PSA | JULIE DAVIES | 1230-2130 |  |  |  | ERIN SCOTT | 1100-1900
PSA | [NAME] | 1400-2300
PSA | GEMMA McDONNELL | 0730-1630
PSA | ROSIE O'HARA | 1230-2130
PSA | MARIE MCATEER | 1230-2130
ADHOC ETC
PSA
PSA
PSA
PSA
PSA
Baggage Facilites/Lost Luggage
PSA | [NAME] | 1400-2300
Staff Off Shift
NAME | COLETTE WEIR | H
NAME | [NAME] | H
NAME | LORRAINE NESBITT | X
NAME | LEANNE MARTIN | MAT
NAME | EMILIA DE LA TORRE | 0
NAME | PATRICIA PHILLIPS | X
 | LAUREN HORNER | X
NAME | HELEN MCCOMB | S
NAME
NAME
NAME
NAME
 |  |  | STAFF OFF SHIFT |  | 8
Spreadsheet: 778771d1651308447-unable-to-get-index-match-to-make-data-from-one-worksheet-to-to-a-summary-worksheet-index-match-sample-file-aligw
Sheet: Combined

This is the worksheet FROM which I want to pull data using INDEX/Match
to go INTO the BT worksheet
Account Source | Account Number | Bank Statement Order Number | Date
BT Investors Choice | 1026 |  | 2020-07-01 00:00:00
BT Investors Choice | 2180 | 1 | 2020-10-01 00:00:00
BT Investors Choice | 2180 | 2 | 2020-01-01 00:00:00
BT Investors Choice | 2180 | 3 | 2020-04-01 00:00:00
BT Investors Choice | 2180 | 4 | 2021-06-30 00:00:00
USAOz Company Shares | 1026 |  | 2020-07-01 00:00:00
USAOz Company Shares | 2180 | 1 | 2020-10-01 00:00:00
USAOz Company Shares | 2180 | 2 | 2020-01-01 00:00:00
USAOz Company Shares | 2180 | 3 | 2020-04-01 00:00:00
USAOz Company Shares | 2180 | 4 | 2021-06-30 00:00:00
Spreadsheet: ff1226de-f906-49f8-a0de-939647f48feb
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
42349033 | 2014-07-18 07:18:59 | ALLIES | 1 | 6 | 2 | 679790 | Hermann | 12904 | mediterranean | 1940-12-17 |  |  | Bardia 1940 (libye)
42349082 | 2014-07-18 07:29:20 | AXIS | 1 | 6 | 4 | 679790 | Hermann | 12904 | mediterranean | 1940-12-17 |  |  | Bardia 1940 (libye)
42349136 | 2014-07-18 07:42:35 | AXIS | 1 | 6 | 5 | 679790 | Hermann | 8151 | western | 1944-08-20 |  | The Las river Valley
42349210 | 2014-07-18 07:52:03 | ALLIES | 0 | 3 | 6 | 679790 | Hermann | 8151 | western | 1944-08-20 |  | The Las river Valley
42361266 | 2014-07-19 06:08:17 | ALLIES | 1 | 7 | 8 | 679790 | Hermann | 8203 | pacific | 1944-06-06 |  | Pyrrhic Valley
42361364 | 2014-07-19 06:19:57 | AXIS | 1 | 9 | 6 | 679790 | Hermann | 8203 | pacific | 1944-06-06 |  | Pyrrhic Valley
42361447 | 2014-07-19 06:30:52 | AXIS | 1 | 7 | 5 | 679790 | Hermann | 10172 | western | 1940-04-09 |  | Operation Weserübung
42361517 | 2014-07-19 06:43:30 | ALLIES | 1 | 6 | 4 | 679790 | Hermann | 10172 | western | 1940-04-09 |  | Operation Weserübung
42372703 | 2014-07-20 02:18:13 | ALLIES | 0 | 5 | 6 | 679790 | Hermann | 13562 | eastern | 1942-11-11 | 1942-11-12 | Paulus' Last Offensive | Dernière offensive de Paulus
42372815 | 2014-07-20 02:25:07 | ALLIES | 0 | 1 | 6 | 679790 | Hermann | 13562 | eastern | 1942-11-11 | 1942-11-12 | Paulus' Last Offensive | Dernière offensive de Paulus
42372887 | 2014-07-20 02:33:21 | ALLIES | 0 | 1 | 6 | 679790 | Hermann | 13562 | eastern | 1942-11-11 | 1942-11-12 | Paulus' Last Offensive | Dernière offensive de Paulus
42372959 | 2014-07-20 02:44:08 | ALLIES | 1 | 6 | 4 | 679790 | Hermann | 13562 | eastern | 1942-11-11 | 1942-11-12 | Paulus' Last Offensive | Dernière offensive de Paulus
Spreadsheet: 730380d1619681538-combine-data-from-two-columns-combine-data-from-two-columns-
Sheet: Sheet1

1) Data from the previous month |  |  | 3) Data from previous month and raw data are combined here |  |  | 2) Raw data from the insurance provider is pasted here
Customers | Comments |  | Customers | Comments |  | Insured
Lazy | Get up |  |  | Get up |  | Lazy
New | Call |  | New | Call |  | New
Old | Boss |  | Old | Boss |  | Old
Cheezy | Good |  | Cheezy | Good |  | Cheezy
Burger | Later |  | Burger | Later |  | Burger
Chocolate | Smooth |  | Chocolate | Smooth |  | Chocolate
Stick |  |  | Stick |  |  | Stick
Chewy |  |  | Chewy |  |  | Chewy
Puppy |  |  | Puppy |  |  | Puppy
Cat | Get out |  | Cat | Get out
Duck | Fly |  | Duck | Fly
Dog | Eat a snack |  | Dog | Eat a snack
Spreadsheet: 641ac014-5f60-4bc4-a08d-fc31c55c5af8
Sheet: Sheet1

9TH GRADE FOOTBALL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
2011
 |  | Game Time: 4:00
DATE |  | HOKE |  | SCOTLAND |  | PINECREST |  | RICHMOND
Thur | 2011-09-08 00:00:00 | Soctlamd |  | at Hoke |  | at Richmond |  | Pinecrest
Thur | 2011-09-15 00:00:00 | at Pinecrest |  | Richmond |  | Hoke |  | at Scotland
Thur | 2011-09-22 00:00:00 | at Richmond |  | at Pinecrest |  | Scotland |  | Hoke
Thur | 2011-09-29 00:00:00 | at Scotland |  | Hoke |  | Richmond |  | at Pinecrest
Thur | 2011-10-06 00:00:00 | Pinecrest |  | at Richond |  | at Hoke |  | Scotland
Thur | 2011-10-13 00:00:00 | Richmond |  | Pinecrest |  | at Scotland |  | at Hoke
Thur | 2011-10-20 00:00:00
DATE
Thur | 2011-09-08 00:00:00
Thur | 2011-09-15 00:00:00
Thur | 2011-09-22 00:00:00
Thur | 2011-09-29 00:00:00
Thur | 2011-10-06 00:00:00
Thur | 2011-10-13 00:00:00
Thur | 2011-10-20 00:00:00