tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50165d1249554826-splitting-and-extracting-certain-info-samplestring
Sheet: Sheet1

CO ADD 1 | CO ADD 2 | CO ADD 3
1 | CAE GWEN, MYDROILYN | SA48 7AH LAMPETER
1 | CAE GWEN | SA48 7AH MYDROILYN, LAMPETER
2 | BROADWAY CATTAGE | CF320HY LALESTON
2 | BROADWAY COTTAGE | CF32 0HY BRIDGEND
2 | LAKEFIELD PLACE | SA15 2TY LLANELLI DYFED
2 | BROADWAY COTTAGE | CF32 0HY BRIDGEND
3 | PEN YR ALLT | SA114DS NEATH
3 | PEN YR ALT | SA11 4DS NEATH
3 | PEN YR ALLT | SA114DS RHEOLA
3 | PEN YR ALLT | SA11 4DS RHEOLA NEATH
4 | WOODLAND PARK | SA6 5AR SWANSEA
8 | CEFN PARC | SA106YR SKEWEN, NEATH
9 | ELWYN DRIVE | CF470NJ TWYNYRODYN MERTHYR TYD
9 | DANYLAN | CF32 9AB ABERKENFIG
11 | MAES-YR-AWEL | SA16 0UN PEMBREY , BURRY PORT
19 | [NAME] | SA155AW LLANELLI
20 | CONAUGHT STREET | SA13 1ET PORT TALBOT
21 | SKYLARK ROAD, | CF33 4PD NORTH CORNELLY, BRIDG
21 | SKYLARK ROAD | CF33, 4P NORTH CORNELLY, BRIDG
21 | SKYLARK ROAD | CF33 4PD NORTH CORNELLY, BRIDG
24 | HEOL BRYNGWILI | SA14 6LR CROSS HANDS
25 | GER YR [NAME] | SA16 0FT BURRY PORT,CAMARTHENS
25 | GER YR [NAME] | SA16 0FT BURRY PORT
26 | WEST STREET | CF34 9AF MAESTEG
28 | DERWEN CLOSE | SA5 4QQ SWANSEA
29 | GOETRE BELLAF ROAD | [NAME]
31 | [NAME] | CF35 6JR BRIDGEND
31 | [NAME] | CF35 6JR BRIDGEEND
31 | [NAME] | CF35 6JR BRIDGEND
45 | SALISBURY CLOSE | CF48 1SD MERTHYR TYDFIL
46 | HOOKLAND ROAD | CF36 5SF PORTHCAWL
50 | LLWYN MEREDITH | SA31 1EF CARMARTHEN
62 | CWMPHIL ROAD | SA9 2QB LOWER CWMTWRCH
62 | CWMPHIL ROAD | SA9 2QB LOWER CWMTWRCH
73 | BRONLLT ROAD | SA41UD SWANSEA
113 | HIGHFIELD | BRACKLA CF312PD
Spreadsheet: 84692f9c-4a88-42c7-9a73-5a7b2f77898c
Sheet: EMR

 |  | Diet and Physical Activity for the Prevention of Non Communicable Diseases in Low and Middle-Income Countries: A Systematic Policy Review
 |  | Lachat et al. Plosmed
 |  | Table S1: Availability of national policy documents and strategies for NCD prevention in low- and middle- income countries by WHO region
 |  | Eastern Mediterranean Region
 |  | Short name | Full name | Classification | WHO region | Policy status assessed | County with policy elibigle for review | Reason for exclusion from review | Language | Type of policy | Classification code | NCD strategies
 |  |  |  |  |  |  |  |  |  |  |  | Salt | Fat | FV | PA | Number of strategies
 | 1 | Afghanistan | the Islamic Republic of Afghanistan | Low income | EMR | yes | yes |  | English | NP | 3
 | 2 | Djibouti | the Republic of Djibouti | Lower middle income | EMR | yes | yes |  | French | NP | 4 | yes |  | yes | yes
 | 3 | Egypt, Arab Rep. | Arab Republic of Egypt | Lower middle income | EMR | no |  |  |  |  | 1
 | 4 | Iran, Islamic Rep. | the Islamic Republic of Iran | Upper middle income | EMR | yes | yes |  | Farsi | NP | 4 | yes | yes | yes | yes
 | 5 | Iraq | Republic of Iraq | Lower middle income | EMR | no |  |  |  |  | 1
 | 6 | Jordan | the Hashemite Kingdom of Jordan | Lower middle income | EMR | yes | yes |  | English | NP | 4 | yes | yes | yes | yes
 | 7 | Lebanon | Lebanese Republic | Upper middle income | EMR | no |  |  |  |  | 1
 | 8 | Libya | Libya | Upper middle income | EMR | no |  |  |  |  | 1
 | 9 | Morocco | the Kingdom of Morocco | Lower middle income | EMR | yes | yes |  | French | NP | 4 |  |  |  | yes
 | 10 | Pakistan | the Islamic Republic of Pakistan | Lower middle income | EMR | yes | yes |  | English | NP | 4 |  | yes
 | 11 | Somalia | Somali Republic | Low income | EMR | yes | no | published before 2004 |  |  | 2
 | 12 | Sudan | the Republic of the Sudan | Lower middle income | EMR | yes | yes |  | English | NP | 4 | yes
 | 13 | Syrian Arab Republic | Syrian Arab Republic | Lower middle income | EMR | no |  |  |  |  | 1
 | 14 | Tunisia | Republic of Tunisia | Lower middle income | EMR | yes | no | Policy was available but could not be obtained |  |  | 2
 | 15 | Yemen, Rep. | Republic of Yemen | Lower middle income | EMR | no |  |  |  |  | 1
Spreadsheet: 845501d1697006275-copy-formulas-and-format-from-existing-row-to-a-new-row-my-gites-aligw
Sheet: Data

Direct |  | 1
Booking |  | 2 |  | BACS |  | 2 Bruce Springsteen
 |  | 3 |  | Cheque |  | 3 Mick Jagger
 |  | 4 |  | Cash |  | 4 [NAME]
 |  | 5 |  | CB |  | 5 [NAME]
 |  | 6 |  |  |  | 6 [NAME]
 |  | 7 |  |  |  | 7 [NAME]
 |  | 8 |  |  |  | 8 [NAME]
 |  | 9 |  |  |  | 9 [NAME]
 |  | 10 |  |  |  | 10 Ringo Starr
 |  | 11
 |  | 12
Spreadsheet: 764748d1642951417-how-to-auto-select-2-names-based-on-multiple-criteria-sample-sheet-1-
Sheet: Sheet 1

Ps | Gender | B. # | Column1 |  |  |  |  |  | P. | B. # | Cost
Vane | F | 0 |  |  |  |  |  |  |  | 0 | 2000
[NAME] | M | 0 |  |  |  |  |  |  | Vane | 0 | 2000
Loki | M | 1
[NAME] | F | 1
Sith | F | 2 |  |  | 0 | 2000
Sia | F | 2 |  |  | 1 | 4000
Thor | M | 2 |  |  | 2 | 6000
[NAME] | M | 2 |  |  | 3 | 10000
Dew | F | 2 |  |  | 4 | 16000
Felk | M | 3 |  |  | 5 | 26000
Eras | F | 3 |  |  | 6 | 42000
Ades | M | 4 |  |  | 7
Adel | F | 5
Tuck | M | 6
Spreadsheet: 35413d1233008498-lookup-value-in-filtered-date-range-crazy-wonky-lookup-mew
Sheet: Sheet1

3 | jill | 3 |  | 2 | 50
4 | bob | 4
2 | lisa | 2
5 | [NAME] | 5
6 | mark | 6
10 | [NAME] | 7
3 | cookie monster | 2
1 | elvis | 3
3 | gord | 4
4 | [NAME] | 1
1 | [NAME] | 5
2 | tanis | 3 |  |  |  |  | bob
41 | frederick | 5 |  |  |  |  | 4
 |  | 6
Spreadsheet: daren_farmer__5333__HPL-July
Sheet: June 00

 |  | Reliant Energy - Entex
 |  | Enron Capital &  Trade/Houston Pipe Line
 |  | MONTHLY NOMINATION SUMMARY
 |  |  | From |  | Month to Date
Gas Flow Day |  | [NAME]. | 2000-07-01 00:00:00 | 1999-09-18 00:00:00
Houston Pipe Line
982000 |  | HPL  Points | 78000
981258 | Industrial Tier 1 & 2 | CHAMPIONS | 0
981195 | Industrial Tier 1 & 2 | Huntsman East | 4000
981279, 981280, 981293 | Lufkin/Diboll- Temple Inland
980073 | Huntv,Woodls,[NAME]
Total HPL
Midcon |  |  | 65000
Total  Midcon
PAYBACK |  |  | 0
Total Available
Allocated as Follows:
Residential
012-41991-301 | 91% Domestic | HPL 76 | 910
016-41991-301 | Transactions 2-5,7 | ECT Trans # 1
016-41991-313 | existing | NGMS 308 | 10000
016-41991-306 | Trans 6- Silsbee |  | 250
016-41991-301 | Trans 10 [NAME]. | Lufkin Diboll | 0
 | Subtotal
016-41991-301 | Transaction 1 - Overflow | ECT Trans # 1
Total Residential
Industrial
012-41991-301 | 9% Industrial | HPL 76 | 90
016-41991-311 |  | CNG | 250
016-41991-306 | Trans 6 -Tier 1 - Entex | Tier 1 | 21000
016-91000-303 | Trans 6 -Tier 1 - Unit | Tier 1
016-41991-306 | Trans 6 -Tier 2 - Entex | [NAME] | 7500
016-91000-303 | Trans 6 - Tier 2  - Unit | [NAME] | 2000
016-41991-306 | VA Hospital | VA Hosp | 500
Total Industrial at meter 2000
016-91000-301 | existing | NSS/Vidor | 4000
016-41991-306 | [NAME]. | Lufkin Diboll | 8000
016-41991-312 | [NAME]. | Temple Inland | 2800
Total Industrial not at meter 2000
Total Industrial
Huntsville/Woodlands/Conroe
016-41991-301 | Trans 6 -Huntsville |  | 500
016-41991-301 | Trans 9 -Woodlands |  | 2000
016-41991-301 | Trans 8 - Conroe |  | 0
Total H/W/C
Transportation
012-41991-204 |  | IT | 10000
012-41991-203 |  | Firm Trsp
Total Transportation
Total Allocated
Check Available = Allocated
Transport Receipts |  | [NAME]
012-41991-204 | TEJAS THOMPSONVILLE | 6296 | 10000
012-41991-203 | TEJAS THOMPSONVILLE | 6351 | 5000
012-41991-203 | TEJAS THOMPSONVILLE | 6351 | 10000
Spreadsheet: 850459d1700794880-expected-result-base-on-few-conditions-sample-82-
Sheet: Sheet1

 |  |  | Item Code | Item 1 | Item 2 | Posted Code | result |  | Match Item Code | Expected Result
 |  |  | PT-001-223 | 0 | 0 | 45 |  |  | PT-001-223
 |  |  | PT-001-224 | 0 | 50 | 60 |  |  | PT-001-226
 |  |  | PT-001-225 | 50 | 100 | 75 |  |  | PT-001-228
 |  |  | PT-001-226 | 0 | 150 | 90
 |  |  | PT-001-227 | 0 | 200 | 105
 |  |  | PT-001-228 | 45 | 250 | 120
 |  |  | PT-001-229 | 0 | 300 | 135
 |  |  | PT-001-230 | 0 | 350 | 150
Spreadsheet: 1e41dbe5-fecd-4d0f-8fa1-9951f0e5298a
Sheet: Cert Temp

Direct Support Work
Certificate
 |  |  |  |  |  |  |  | Revised 04/2013 KC |  |  |  |  |  |  |  |  |  |  |  | A
Name |  |  | Student ID Number |  |  |  | Date Entered: |  |  |  |  |  |  |  |  |  |  |  |  | B
Address |  |  | Phone: |  |  |  | Proj. Graduation Date: |  |  |  |  |  |  |  |  |  |  |  |  | C
 |  |  | [NAME]: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E
 |  |  | Student Signature: |  |  |  |  | Date:
 |  |  | Advisor Signature: |  |  |  |  | Date:
 |  |  | Authorizing Signature: |  |  |  |  | Date: |  | CUL 230
All incoming students must have First-Year Experience Course (FYE 105, GEN 100, GEN 102, or AHS 105) within in the first two (2) semesters of college. |  |  |  |  |  |  |  |  |  | NFS 101
Course |  |  |  | Credits | Recommended Courses | [NAME] | Notes:
HMS 102  Values of Human Services in a Contemporary Society |  |  |  | 3 | HMS 102 |  |  |  |  | CUL 298
HMS 265  Working with Disabilities in Human Services |  |  |  | 3 | HMS 265
MNA 100 OR NAA 100 |  |  |  | 3
SWK 275 OR FAM 252 |  |  |  | 3
Elective |  |  |  | 3
 |  |  |  |  |  |  |  |  |  | CUL 299
Total hours for Certificate |  |  |  | 15
Spreadsheet: 235554d1368539516-filtering-based-on-criteria-example
Sheet: Sheet1

Company Name | Venue | Target Language | Booking Start Date | [NAME] |  |  |  |  |  | Company Name | Venue | Target Language | Booking Start Date | [NAME]
Client 3 | CR9 2BY | [NAME] | 2013-04-02 09:00:00 | 6 |  | Language | somali
Client 1 | CR9 2BY | Somali | 2013-04-02 19:00:00 | 7 |  | Date | 2013-02-04 00:00:00
Client 1 | CR9 2BY | [NAME] | 2013-04-02 12:00:00 | 16 |  | Distance | <20
Client 2 | CR9 2BY | French | 2013-04-02 09:00:00 | 28
Client 1 | PO1 2LA | Japanese | 2013-04-02 09:00:00 | 9
Client 3 | WF10 5LT | Cantonese | 2013-04-02 18:00:00 | 12
Client 1 | CR9 2BY | [NAME] | 2013-04-02 09:00:00 | 13
Client 2 | CR9 2BY | French | 2013-04-02 09:00:00 | 15
Client 1 | CR9 2BY | [NAME] | 2013-04-02 19:00:00 | 25
Client 3 | CR9 2BY | Somali | 2013-04-02 09:00:00 | 27
Client 1 | BR1 5JX | Tigrinya | 2013-04-02 09:00:00 | 7
Client 1 | CM9 6EG | Portuguese | 2013-04-02 09:00:00 | 24
Client 3 | N18 1QX | Somali | 2013-04-02 09:00:00 | 9
Client 2 | WF10 5LT | Polish | 2013-04-02 09:00:00 | 25
Client 2 | S9 3XN | Polish | 2013-04-02 09:00:00 | 27
Client 2 | SW9  9NU | Spanish | 2013-04-02 09:00:00 | 26
Client 2 | SW9  8AP | Italian | 2013-04-02 09:00:00 | 22
Client 3 | CW1 9SA | Indonesian | 2013-04-02 09:00:00 | 8
Client 2 | SE13 6LW | Vietnamese | 2013-04-02 09:00:00 | 18
Client 1 | SW9  9NU | Spanish | 2013-04-02 09:00:00 | 15
Client 1 | HA1  1RX | Polish | 2013-04-02 09:00:00 | 10
Client 2 | DN4  8QN | Vietnamese | 2013-04-02 09:00:00 | 19
Client 3 | NW1 0PE | Albanian | 2013-04-02 09:00:00 | 8
Client 1 | S71 1AN | Polish | 2013-04-02 09:00:00 | 16
Client 1 | N19 4AL | Somali | 2013-04-02 09:00:00 | 29
Client 3 | N19 4AL | Somali | 2013-04-15 10:30:00 | 17
Client 2 | N19 4AL | Somali | 2013-04-15 10:30:00 | 27
Client 1 | SW10 9NH | Kurdish (Sorani) | 2013-04-16 14:30:00 | 6
Client 3 | PE1  4TU | Polish | 2013-04-15 10:15:00 | 23
Spreadsheet: 275437d1383514000-sum-cells-based-on-current-month-report-template
Sheet: Report 8

 | Date | Customer Type | Customer ID | CA ID | Customer Name | Transaction Type | Transaction Count | Registered Devices Quantity | Equipment Count
 | 2013-10-23 00:00:00 | RESIDENTIAL | 1391301 | 0 | Gavin just | DEVICE REGISTRATION | 1 | 3 | 1
 | 2013-10-23 00:00:00 | RESIDENTIAL | 74101 | 0 | Hayden Robinson | DEVICE REGISTRATION | 1 | 2 | 1
 | 2013-10-23 00:00:00 | RESIDENTIAL | 1455201 | 0 | Lyn Capill | DEVICE REGISTRATION | 1 | 2 | 1
 | 2013-10-23 00:00:00 | RESIDENTIAL | 1202901 | 0 | Rex Cooper | DEVICE REGISTRATION | 1 | 2 | 1
 | 2013-10-23 00:00:00 | RESIDENTIAL | 1449801 | 0 | [NAME] | DEVICE REGISTRATION | 1 | 2 | 1
 | 2013-10-23 00:00:00 | RESIDENTIAL | 1219601 | 0 | [NAME] | DEVICE REGISTRATION | 1 | 2 | 1
 |  |  |  |  |  | Sum: | 6
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 14 - Table 1

LAS CSD&Nanc |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | 4Q10 | Scope |  |  | 4Q11 | Reported | Organic
Volume ('000 hl) | 3850.34 | 0 | 0 | 65.89400000000023 | 3916.234 | 0.0171138133255766 | 0.01711381332557651
Net revenue | 310.087 | 0 | -7.923316704382216 | 95.11631670438214 | 397.2799999999999 | 0.2811888276515944 | 0.3067407427734221
Net revenue/hl | 80.53496574328501 | 0 | -2.023197976520866 | 22.93263009097365 | 101.4443978577378 | 0.2596317254433824 | 0.2847537076513348
[NAME] | -182.8428562351075 | 0 | 3.666928197885738 | -58.19883196277829 | -237.37476 | 0.2982446505581438 | 0.3182997310430529
[NAME]/hl | -47.48745727263241 | 0 | 0.9363404224277044 | -14.06190065589937 | -60.61301750610408 | 0.2764005694833462 | 0.29611820601739
Gross profit | 127.2441437648925 | 0 | -4.256388506496478 | 36.91748474160386 | 159.9052399999999 | 0.2566805455145731 | 0.2901311105508781
Gross margin | 0.4103498171961176 | 0 | 0 | 0 | 0.4025001006846555 | -80 | -50
SG&A excl. deprec.&amort. | -60.48300000000001 | 0 | 0.5877808422678541 | -15.79278084226783 | -75.68799999999999 | 0.2513929533918617 | 0.2611110699249017
SG&A deprec.&amort. | -7.680999999999997 | 0 | 0.009004685928877265 | -1.055004685928878 | -8.726999999999999 | 0.1361801848717616 | 0.13735251737129
SG&A total | -68.16400000000002 | 0 | 0.5967855281967331 | -16.84778552819671 | -84.41499999999999 | 0.2384103045595911 | 0.2471654469836968
Other operating income/expenses | 0.6698535067680451 | 0 | 0.3290242900308948 | -2.581768624265526 | -1.582890827466586 | nm | nm
Normalized EBIT | 59.74999727166055 | 0 | -3.33057868826885 | 17.48793058914162 | 73.90734917253333 | 0.2369431388675161 | 0.2926850441453686
Normalized EBIT margin | 0.1926878497700986 | 0 | 0 | 0 | 0.1860334000516848 | -70 | -20
Normalized EBITDA | 74.77099727166078 | 0 | -3.384471436799771 | 19.45582333767239 | 90.8423491725334 | 0.214940986308924 | 0.260205481371136
Normalized EBITDA margin | 0.2411290936790668 | 0 | 0 | 0 | 0.228660766141093 | -120 | -90
Spreadsheet: 813746d1673966798-formula-to-first-row-number-of-first-occurence-formula-find-col-and-row-number
Sheet: Sheet1

Nadine Frans | Oct
 |  |  |  |  |  |  |  | Oct
[NAME] | Oct |  |  |  | [NAME] |  |  | Nov
[NAME] | Nov |  |  |  | Nadine Frans |  |  | Dec
[NAME] | Dec |  |  |  | [NAME] |  |  | Jan
[NAME] | Jan |  |  |  |  |  |  | Feb
[NAME] | Feb |  |  |  |  |  |  | Mar
[NAME] | Mar |  |  |  |  |  |  | Apr
[NAME] | Apr |  |  |  |  |  |  | May
[NAME] | May |  |  |  |  |  |  | Jun
[NAME] | Jun |  |  |  |  |  |  | Jul
[NAME] | Jul |  |  |  |  |  |  | Aug
[NAME] | Aug |  |  |  |  |  |  | Sep
[NAME] | Sep
Nadine Frans | Oct
Nadine Frans | Nov
Nadine Frans | Dec
Nadine Frans | Jan
Nadine Frans | Feb
Nadine Frans | Mar
Nadine Frans | Apr
Nadine Frans | May
Nadine Frans | Jun
Nadine Frans | Jul
Nadine Frans | Aug
Nadine Frans | Sep
[NAME] | Oct
[NAME] | Nov
[NAME] | Dec
[NAME] | Jan
[NAME] | Feb
[NAME] | Mar
[NAME] | Apr
[NAME] | May
[NAME] | Jun
[NAME] | Jul
[NAME] | Aug
[NAME] | Sep
Spreadsheet: 681618d1591672217-highlight-the-approx-match-values-approx-match
Sheet: Sheet1

[NAME]
AMAN TRANSPORT COMPANY,S/o,
AMAN TRANSPORT COMPANY,S/o,
AMAN TRANSPORT COMPANY,S/o,
AMMONIA SUPPLY COMPANY,S/o,
ANIL KUMAR,S/o,MANI RAM GAJRAJ
ANIL KUMAR,S/o,MANI RAM
AMAN TRANSPORT COMPANY,S/o,
AMAN TRANSPORT COMPANY,S/o,
AMAN TRANSPORT COMPANY,S/o,
AMAN TRANSPORT COMPANY,S/o,
AMMONIA SUPPLY CO,S/o,
AMAN TRANSPORT COMPANY,S/o,
ANIL KUMAR,S/o,MANI RAM GAJRAJ
AMMONIA SUPPLY CO,S/o,
AMAN TRANSPORT CO.,S/o,.
AMMONIA SUPPLY COMPANY,S/o,
ANIL KUMAR,S/o,MANI RAM
AMAN TRANSPORT CO.,S/o,.
AMMONIA SUPPLY CO,S/o,
Spreadsheet: 76614d1277155159-nesting-more-than-7-if-then-statements-without-using-vlookup-grade-template2
Sheet: INPUT YOUR DATA HERE

TEACHER GRADEBOOK (314303-009 MP:ALL) |  |  |  |  |  |  |  |  |  |  |  | DO NOT REMOVE THIS A
 |  |  |  |  |  |  |  |  |  |  |  | A
CLICK ON CELL A5 AND PASTE YOUR DATA IN A5 | Quarter 1 | Quarter 2 | Semester 1 Exam | Quarter 3 | Quarter 4 | Semester 2 Exam | Q1 | Q2 | Q3 | Q4 | Semester 2 Ex | QP | FINAL GRADE
SAMPLE(DO NOT ERASE) | A | A | blank | A | A | A | 4 | 4 | 4 | 4 | 4 | 4 | A
example of dilemma | b | b |  | b | b | b+ | 3 | 3 | 3 | 3 | 3.3 | 3.06 | A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Students (List Count:28)
Spreadsheet: 34753d1232069648-cross-validation-rule-668183
Sheet: Sheet1

 |  |  |  |  | AA | BB | CC |  | Accounts
Account Flex-Fields |  |  |  |  | 444 | 111 | 777 |  | 721001
Center | Department | Account | MESSAGE |  | 555 | 222 | 888 |  | 721002
AA | 555 | 249001 | Valid |  | 666 | 333 | 999 |  | 721003
AA | 111 | 249001 | Valid |  |  |  |  |  | 249001
BB | 111 | 22010 | Invalid |  |  |  |  |  | 650001
BB | 999 | 249001 | Valid |  |  |  |  |  | 221001
CC | 777 | 249001 | Valid |  |  |  |  |  | 239005
CC | 555 | 249001 | Valid |  |  |  |  |  | 521111
 |  |  |  |  |  |  |  |  | 940001
 |  |  |  |  |  |  |  |  | 142001
 |  |  |  |  |  |  |  |  | 725001
 |  |  |  |  |  |  |  |  | 725099
 |  |  |  |  |  |  |  |  | 640002
 |  |  |  |  |  |  |  |  | 729002
 |  |  |  |  |  |  |  |  | 729003
 |  |  |  |  |  |  |  |  | 663001
 |  |  |  |  |  |  |  |  | 249008
 |  |  |  |  |  |  |  |  | 235006
 |  |  |  |  |  |  |  |  | 640001
 |  |  |  |  |  |  |  |  | 729004
Spreadsheet: 204221d1357405233-i-want-to-match-two-spread-sheet-with-time-excel2-1-
Sheet: Sheet2

date | time | Location | epos_id | Code | basket_value | Voucher from Excel 1
2013-04-01 00:00:00 | 14:55:25 | 14:55:25 | NEPTUNTEGKASA06 |  | 2990
2013-04-01 00:00:00 | 16:52:09 | 16:52:09 | NEPTUNTEGKASA06 |  | 11990
2013-04-01 00:00:00 | 10:59:47 | 10:59:47 | TEGFASHION15 |  | 2334
2013-04-01 00:00:00 | 11:11:43 | 11:11:43 | TEGFASHION15 |  | 6878
2013-04-01 00:00:00 | 11:45:40 | 11:45:40 | TEGFASHION04 |  | 2990
2013-04-01 00:00:00 | 11:54:53 | 11:54:53 | TEGFASHION11 |  | 3710
2013-04-01 00:00:00 | 12:00:04 | 12:00:04 | TEGFASHION11 |  | 2100
2013-04-01 00:00:00 | 12:15:54 | 12:15:54 | TEGFASHION12 |  | 13450
2013-04-01 00:00:00 | 12:31:03 | 12:31:03 | TEGFASHION15 |  | 4727
2013-04-01 00:00:00 | 13:48:20 | 13:48:20 | TEGFASHION12 |  | 18540
2013-04-01 00:00:00 | 13:54:44 | 13:54:44 | TEGFASHION12 |  | 14170
2013-04-01 00:00:00 | 14:20:04 | 14:20:04 | TEGFASHION12 |  | 5980
2013-04-01 00:00:00 | 15:57:31 | 15:57:31 | TEGFASHION11 |  | 2950
2013-04-01 00:00:00 | 15:59:18 | 15:59:18 | TEGFASHION14 |  | 1840
2013-04-01 00:00:00 | 16:40:11 | 16:40:11 | TEGFASHION02 |  | 4060
2013-04-01 00:00:00 | 16:45:49 | 16:45:49 | TEGFASHION14 |  | 1680
2013-04-01 00:00:00 | 16:59:41 | 16:59:41 | TEGFASHION02 |  | 1120
2013-04-01 00:00:00 | 17:05:38 | 17:05:38 | TEGFASHION12 |  | 3490
2013-04-01 00:00:00 | 17:11:45 | 17:11:45 | TEGFASHION15 |  | 11093
2013-04-01 00:00:00 | 17:17:31 | 17:17:31 | TEGFASHION12 |  | 10960
2013-04-01 00:00:00 | 17:23:55 | 17:23:55 | TEGFASHION15 |  | 1690
2013-04-01 00:00:00 | 17:32:01 | 17:32:01 | TEGFASHION05 |  | 5950
2013-04-01 00:00:00 | 17:34:16 | 17:34:16 | TEGFASHION12 |  | 24410
2013-04-01 00:00:00 | 17:57:52 | 17:57:52 | TEGFASHION12 |  | 27900
2013-04-01 00:00:00 | 17:58:08 | 17:58:08 | TEGFASHION11 |  | 1960
2013-04-01 00:00:00 | 18:10:11 | 18:10:11 | TEGFASHION12 |  | 22200
2013-04-01 00:00:00 | 18:34:37 | 18:34:37 | AFGESPRIT |  | 8800
2013-04-01 00:00:00 | 18:39:32 | 18:39:32 | TEGFASHION05 |  | 2980
2013-04-01 00:00:00 | 18:40:39 | 18:40:39 | TEGFASHION05 |  | 1980
2013-04-01 00:00:00 | 18:50:33 | 18:50:33 | TEGFASHION12 |  | 10990
2013-04-01 00:00:00 | 19:32:13 | 19:32:13 | TEGFASHION12 |  | 19160
2013-04-01 00:00:00 | 19:58:29 | 19:58:29 | AFGESPRIT |  | 3980
2013-04-01 00:00:00 | 20:30:06 | 20:30:06 | TEGFASHION11 |  | 2200
Spreadsheet: 800304d1665588685-using-if-function-inside-iferror-not-working-doubt-weight-or-cr-zero_corr
Sheet: Sheet1

Age | Weight | Crcl | Magic
60 | 70 | 45
80 | 0 | 10
Spreadsheet: 709710d1608512260-compare-to-cells-bouwcenter-poule-f1-2021-v3
Sheet: Stand

Stand
 | Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | Toaal | Ranking |  |  |  | Punten
1 | Player 1
2 | Player 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pole Position | 50
3 | Player 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Snelste ronden | 18
4 | Player 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Eeste uitvaller | 10
5 | Player 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Snelste Pitstop | 10
6 | Player 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Best of the rest | 25
7 | Player 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 25
8 | Player 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 18
9 | Player 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 15
10 | Player 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wereldkampioen | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contstructers | 100
Spreadsheet: 886871d1736970784-gather-totals-based-on-column-examples
Sheet: Sheet1

Example of worksheet
Account # | Total 1 | Total 2 | Total 3
123456 | 110 | 0 | 4411.66
123456 | 75 | 95.11 | 0
123456 | 0 | 100 | 55.12
345678 | 95.33 | 88.66 | 0
789456 | 55.96 | 2.55 | 88.99
Need this
123456
345678
789456