tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 777338d1650337611-xirr-causing-bizarre-num-result-xirr-num
Sheet: Sheet1

1989-01-01 00:00:00 | 20000 |  |  | %discnt | NPV (B1:B15) | NPV (B1:B14) | Solver (B1:B14) |  |  | Newton-Raphson (B1:B14)
1989-02-01 00:00:00 | 144.8 |  |  | -0.9999 |  |  | IRR | NPV |  | step# | x | diff x | NPV(x) | NPV'(x)
1989-03-01 00:00:00 | 519.13 | XIRR |  | -0.99 |  |  | -0.9801726382998047 |  |  |  | -0.975
1989-04-01 00:00:00 | -15014.74 |  | C4: =XIRR($B$1:B4,$A$1:A4) | -0.95
1989-05-01 00:00:00 | 132.28 |  | C5: =XIRR($B$1:B5,$A$1:A5) | -0.9
1989-06-01 00:00:00 | 73.09 |  | C6: =XIRR($B$1:B6,$A$1:A6) | -0.85
1989-07-01 00:00:00 | 74.26 |  | C7: =XIRR($B$1:B7,$A$1:A7) | -0.8
1989-08-01 00:00:00 | 75.94 |  | C8: =XIRR($B$1:B8,$A$1:A8) | -0.75
1989-09-01 00:00:00 | 76.07 |  | C9: =XIRR($B$1:B9,$A$1:A9) | -0.7
1989-10-01 00:00:00 | 75.12 |  | [NAME]: =XIRR($B$1:B10,$A$1:A10) | -0.65
1989-11-01 00:00:00 | 76 |  | C11: =XIRR($B$1:B11,$A$1:A11) | -0.6
1989-12-01 00:00:00 | 75.55 |  | C12: =XIRR($B$1:B12,$A$1:A12) | -0.550000000000001
1990-01-01 00:00:00 | 75.95 |  | C13: =XIRR($B$1:B13,$A$1:A13) | -0.500000000000001
1990-02-01 00:00:00 | 73.79 |  | C14: =XIRR($B$1:B14,$A$1:A14) | -0.450000000000001
1990-03-01 00:00:00 | 76.07 |  | C15: =XIRR($B$1:B15,$A$1:A15,-92.5%) | -0.400000000000001
 |  |  |  | -0.350000000000001
 |  |  |  | -0.300000000000001
 |  |  |  | -0.250000000000001
 |  |  |  | -0.200000000000001
 |  |  |  | -0.150000000000001
 |  |  |  | -0.100000000000001
 |  |  |  | -0.0500000000000009
 |  |  |  | -9.99200722162641e-16
 |  |  |  | 0.049999999999999
 |  |  |  | 0.1
 |  |  |  | 0.15
 |  |  |  | 0.2
 |  |  |  | 0.25
 |  |  |  | 0.3
 |  |  |  | 0.35
 |  |  |  | 0.4
 |  |  |  | 0.45
 |  |  |  | 0.5
 |  |  |  | 0.55
 |  |  |  | 0.6
 |  |  |  | 0.65
 |  |  |  | 0.7
 |  |  |  | 0.75
 |  |  |  | 0.8
 |  |  |  | 0.85
 |  |  |  | 0.9
 |  |  |  | 0.95
 |  |  |  | 1
Spreadsheet: 855242d1704889172-concerting-time-to-degrees-time-and-degrees-aligw
Sheet: Sheet1

TIME | DEGREE | [NAME] | Format
18:00:00 | 0"
20:00:10 | 30
21:00:00 | 45 |  |  | 24 | HOURs
22:00:00 | 60 |  |  | 360 | DEGREES
22:48:00 | 72
00:00:00 | 90 |  |  |  | DEGRESS/HOUR
02:00:00 | 120
03:00:00 | 135
03:36:00 | 144
04:00:00 | 150
06:00:00 | 180
08:00:00 | 210
08:24:00 | 216
09:00:00 | 225
10:00:00 | 240
12:00:00 | 270
13:12:00 | 288
14:00:00 | 300
15:00:00 | 315
16:00:00 | 330
18:00:00 | 360
Spreadsheet: 790443d1659709484-creating-a-rolling-sum-formula-excel-forum-solved
Sheet: Sheet1

1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1 |  | [NAME] is here
1
4
Spreadsheet: 240162d1370240353-conditional-formating-copy-of-time-line
Sheet: Sheet2

Frame | SHOP DRAWING | ORDERED | BUILT | RECEIVED | CLADDING | CAULKING | DELIVERED | DUE DATE | COUNT DOWN
A-GL | YES | NO | NO | NO | NO | NO | NO | 2013-05-20 00:00:00 | -14 |  | Early
A-L1 | YES | YES | YES | NO | NO | NO | NO | 2013-05-20 00:00:00 | -14
A-L2 | YES | NO | NO | NO | NO | NO | NO | 2013-05-20 00:00:00 | -14 |  |  | 0
A-L3 | YES | NO | NO | NO | NO | NO | NO | 2013-05-20 00:00:00 | -14
A-L4 | YES | NO | NO | NO | NO | NO | NO | 2013-05-20 00:00:00 | -14
A-L5 | YES | NO | NO | NO | NO | NO | NO | 2013-06-03 00:00:00 | 0
A-L6 | YES | NO | NO | NO | NO | NO | NO | 2013-06-03 00:00:00 | 0
A-L7 | YES | NO | NO | NO | NO | NO | NO | 2013-06-03 00:00:00 | 0
A-L8 | YES | NO | NO | NO | NO | NO | NO | 2013-06-03 00:00:00 | 0
A-L9 | YES | NO | NO | NO | NO | NO | NO | 2013-06-03 00:00:00 | 0
A-L10 | YES | NO | NO | NO | NO | NO | NO | 2013-06-19 00:00:00 | 16
A-L11 | YES | NO | NO | NO | NO | NO | NO | 2013-06-19 00:00:00 | 16
A-L12 | YES | NO | NO | NO | NO | NO | NO | 2013-06-19 00:00:00 | 16
A-L13 | YES | NO | NO | NO | NO | NO | NO | 2013-06-19 00:00:00 | 16
A-L14 | YES | NO | NO | NO | NO | NO | NO | 2013-06-19 00:00:00 | 16
A-L15 | YES | NO | NO | NO | NO | NO | NO | 2013-06-19 00:00:00 | 16
A-L16 | YES | NO | NO | NO | NO | NO | NO | 2013-06-19 00:00:00 | 16
A-L17 | YES | NO | NO | NO | NO | NO | NO | 2013-08-28 00:00:00 | 86
A-L18 | YES | NO | NO | NO | NO | NO | NO | 2013-08-28 00:00:00 | 86
 | 28 | 21 | 14 | 12 | 7 | 3 | 0 | 0 | Days From due date
 |  |  |  |  |  |  |  |  | Before cells go red
Spreadsheet: 696784d1600970225-adding-different-values-based-on-five-different-cells-ins-cost-example
Sheet: Info Plug

EMPLOYEE |  |  |  |  |  |  |  |  |  | Salaried MGR |  |  |  |  |  |  |  |  |  | SR Leadership
MIEEE2180 |  |  | MIESA2110 |  |  | MIBCO2050 |  |  |  | MIEEE2180 |  |  | MIESA2110 |  |  | MIBCO2050 |  |  |  | MIEEE2180 |  |  | MIESA2110 |  |  | MIBCO2050
SUB | 47.54 |  | SUB |  |  | SUB | 114.16 |  |  | SUB | 0 |  | SUB | 0 |  | SUB | 0 |  |  | SUB | 0 |  | SUB | 0 |  | SUB | 0
SPS | 309.91 |  | SPS | 340.36 |  | SPS | 448.64 |  |  | SPS | 115.73 |  | SPS | 126.88 |  | SPS | 167.24 |  |  | SPS | 115.73 |  | SPS | 126.88 |  | SPS | 167.24
CH1+ | 234.86 |  | CH1+ | 257.94 |  | CH1+ | 339.99 |  |  | CH1+ | 78 |  | CH1+ | 85.66 |  | CH1+ | 112.91 |  |  | CH1+ | 78 |  | CH1+ | 85.66 |  | CH1+ | 112.91
SPS+ | 465.91 |  | SPS+ | 511.69 |  | SPS+ | 674.46 |  |  | SPS+ | 193.53 |  | SPS+ | 212.54 |  | SPS+ | 280.15 |  |  | SPS+ | 193.53 |  | SPS+ | 212.54 |  | SPS+ | 280.15
Dental |  |  |  |  |  | Vision |  |  |  | Dental |  |  | Vision |  |  |  |  |  |  | Dental |  |  | Vision
SUB | 11.05 |  |  |  |  | SUB | 1.43 |  |  | SUB | 0 |  | SUB | 0 |  |  |  |  |  | SUB | 0 |  | SUB | 0
SPS | 22.44 |  |  |  |  | SPS | 2.41 |  |  | SPS | 5.7 |  | SPS | 0.49 |  |  |  |  |  | SPS | 5.7 |  | SPS | 0.49
CH1+ | 23.28 |  |  |  |  | CH1+ | 2.46 |  |  | CH1+ | 6.12 |  | CH1+ | 0.52 |  |  |  |  |  | CH1+ | 6.12 |  | CH1+ | 0.52
SPS+ | 36.54 |  |  |  |  | SPS+ | 3.89 |  |  | SPS+ | 12.75 |  | SPS+ | 1.23 |  |  |  |  |  | SPS+ | 12.75 |  | SPS+ | 1.23
Spreadsheet: 138136d1327524932-something-instead-or-addition-to-vlookup-because-of-many-same-values-invoice-check_test
Sheet: Supplier_invoice

PO Number | Article number | Article description | Amount | Date | Orderer | Cost center | GL account | Piece price e | Total ordering amount | Catalogue price | Price Difference
660000123 | 100 | Phone | 2 | 3.12.2011 | [NAME] | 123 | 531000 | 100 | 200 | 99.5
660000123 | 105 | [NAME] | 1 | 3.12.2011 | [NAME] | 123 | 531000 | 300 | 300 | 99.5
660000123 | 156 | Bluetooth | 1 | 3.12.2011 | [NAME] | 123 | 531000 | 50 | 50 | 99.5
660000456 | 2010 | Pencil | 12 | 5.12.2011 | [NAME] | 444 | 651000 | 0.5 | 6 | 0.6000000000000001
660000456 | 2030 | Paper | 1 | 5.12.2011 | [NAME] | 444 | 651000 | 2 | 2 | 0.6000000000000001
660000456 | 2080 | Eraser | 10 | 5.12.2011 | [NAME] | 444 | 651000 | 0.6000000000000001 | 6.000000000000001 | 0.6000000000000001
660000789 | 50760 | Headset | 1 | 1.12.2011 | [NAME] | 555 | 721000 | 20 | 20 | 20
Spreadsheet: 728820d1618672841-how-to-look-up-value-in-a-cell-dynamically-lookup-last-entry-value
Sheet: Sales

 |  |  |  |  |  |  |  | Q4
Date | SalesTeam | Q1 | Q2 | Q3 | Q4
2021-04-01 00:00:00 | A | 100 | 200 | 200 | 400
2021-04-02 00:00:00 | B | 50 | 60 | 60 | 70
2021-04-03 00:00:00 | A | 100 | 100 | 200 | 450
2021-04-04 00:00:00 | B | 250 | 350 | 150 | 100
2021-04-05 00:00:00 | A | 58 | 90 | 100 | 100
2021-04-06 00:00:00 | B | 100 | 200 | 250 | 300
2021-04-07 00:00:00 | A | 20 | 50 | 100 | 200
2021-04-08 00:00:00 | B | 20 | 30 | 100 | 15
2021-04-14 00:00:00 | C | 10 | 10 | 10 | 11
Spreadsheet: 730181d1619596294-calculate-total-hours-scheduled-each-hours-of-the-day-calculate-total-hours-scheduled-each-hours-of-the-day-v2
Sheet: counting (3)

 |  | 00:00:00
22:30:00 | 07:00:00
22:30:00 | 07:00:00
22:30:00 | 07:00:00
22:30:00 | 07:00:00
22:30:00 | 07:00:00
19:00:00 | 03:30:00
19:00:00 | 03:30:00
19:00:00 | 03:30:00
19:00:00 | 03:30:00
02:30:00 | 11:00:00
02:30:00 | 11:00:00
02:30:00 | 11:00:00
23:00:00 | 04:30:00
23:00:00 | 04:30:00
23:00:00 | 04:30:00
20:00:00 | 04:30:00
20:00:00 | 04:30:00
20:00:00 | 04:30:00
22:00:00 | 06:30:00
22:00:00 | 06:30:00
Spreadsheet: 223355d1364180131-referring-to-different-matrices-dependant-on-value-entry-multimatrix-ref
Sheet: Product A

 | 3m | 5m | 8m | 10m | 12.5m | 16m | 20m | 22m | 25m
2T | Model A | Model AM | [NAME] | Model AXL | Model AXXL | Model AG | Model AGG | Model AGG2 | Model AGG3 | M | L | XL | XXL | G | GG | GG2 | GG3
5T | Model B | Model BM | Model BL | Model BXL | Model BXXL | Model BG | Model BGG | [NAME] | [NAME] | M | L | XL | XXL | G | GG | GG2 | GG3
7T | Model C | Model CM | Model CL | Model CXL | Model CXXL | Model CG | Model CGG | [NAME] | [NAME] | M | L | XL | XXL | G | GG | GG2 | GG3
10T | Model D | Model DM | Model DL | Model DXL | Model DXXL | Model DG | Model DGG | Model DGG2 | Model DGG3 | M | L | XL | XXL | G | GG | GG2 | GG3
12T | Model E | [NAME] | Model EL | Model EXL | Model EXXL | Model EG | Model EGG | Model EGG2 | Model EGG3 | M | L | XL | XXL | G | GG | GG2 | GG3
15T | Model F | Model FM | Model FL | Model FXL | Model FXXL | Model FG | Model FGG | Model FGG2 | Model [NAME] | M | L | XL | XXL | G | GG | GG2 | GG3
30T | Model G | Model GM | Model GL | Model GXL | Model GXXL | Model GG | Model GGG | Model GGG2 | Model GGG3 | M | L | XL | XXL | G | GG | GG2 | GG3
Spreadsheet: 807711d1670004675-calculate-easy-when-i-add-a-form-mileage-in-parish
Sheet: Sheet1

Column1 | CPSB | MC/SP | FLE | FUE | FJH | FHS | CEC | CPA | VHS | VJH | VUE | VLE | MHS | HS C | HS V
CPSB | 0 | 2.5 | 7.5 | 7 | 7 | 7.5 | 7.5 | 5 | 1 | 3.5 | 3 | 3 | 26 | 13 | 0.5
MC/SP | 2.5 | 0 | 10 | 9 | 9 | 9.5 | 9.5 | 7.5 | 2 | 0.5 | 0.5 | 0.5 | 25 | 16 | 2.5
FLE | 7.5 | 10 | 0 | 2.5 | 2.5 | 1.5 | 3 | 4 | 8 | 10.5 | 10.5 | 10.5 | 21 | 6.5 | 8
FUE | 6.5 | 9 | 2.5 | 0 | 0 | 2.5 | 0.5 | 3 | 7.5 | 10 | 9.5 | 9.5 | 20 | 8 | 7
FJH | 6.5 | 9 | 2.5 | 0 | 0 | 2.5 | 0.5 | 3 | 7.5 | 10 | 9.5 | 9.5 | 20 | 8 | 7
FHS | 7 | 9.5 | 1.5 | 2.5 | 2.5 | 0 | 2 | 4.5 | 8 | 10.5 | 10 | 10 | 20.5 | 6.5 | 7.5
CEC | 7 | 9.5 | 3 | 0.5 | 0.5 | 2 | 0 | 4 | 8 | 10.5 | 10 | 10 | 20 | 8.5 | 7.5
CPA | 5 | 7.5 | 4 | 3 | 3 | 4.5 | 4 | 0 | 6 | 8.5 | 8 | 8 | 23 | 10 | 5
VHS | 1 | 2 | 8 | 7.5 | 7.5 | 8 | 8 | 6 |  | 2.5 | 2 | 2 | 26.5 | 14.5 | 1
VJH | 3.5 | 0.5 | 10.5 | 10 | 10 | 10.5 | 10.5 | 8.5 | 2.5 | 0 | 1 | 1 | 24.5 | 17 | 3
VUE | 3 | 0.5 | 10.5 | 9.5 | 9.5 | 10 | 10 | 8 | 2 | 1 | 0 | 0.5 | 25 | 16.5 | 3
VLE | 3 | 0.5 | 10.5 | 9.5 | 9.5 | 10 | 10 | 8 | 2 | 1 | 0.5 | 0 | 25.5 | 16.5 | 3
MHS | 26 | 25 | 21 | 20 | 20 | 20.5 | 20 | 23 | 26.5 | 24.5 | 25 | 25.5 |  | 26 | 25.5
HS C | 13 | 16 | 6.5 | 8 | 8 | 6.5 | 8.5 | 10 | 14.5 | 17 | 16.5 | 16.5 | 26 | 0 | 13
HS V | 0.5 | 2.5 | 8 | 7 | 7 | 7.5 | 7.5 | 5 | 1 | 3 | 3 | 3 | 25.5 | 13 | 0
 | From | To | Distance
 | CPA | MHS
Spreadsheet: 222535d1363877236-perhaps-conditional-formatting-tabs-sample-resourcing
Sheet: DOC

MONTH | 2013 Actual - RFA | 2013 Actual - EHP | 2013 Actual - EHSQ | 2013 Actual - WHP | Total Days Available
December |  |  |  |  | 22
November |  |  |  |  | 21
October |  |  |  |  | 23
September |  |  |  |  | 21
August |  |  |  |  | 22
July |  |  |  |  | 22
June |  |  |  |  | 23
May |  |  |  |  | 20
April |  |  |  |  | 23
March |  |  |  |  | 21
February | 3.5 | 8.5 |  |  | 20
January | 1 | 11 |  |  | 18
MONTH | 2013 Forecast - RFA | 2013 Forecast - EHP | 2013 Forecast - EHSQ | 2013 Forecast - WHP | Total Days Available
December | 2 | 20 | 5 |  | 22
November | 2 | 27 | 5 |  | 21
October | 7 | 22 | 5 |  | 23
September | 9 | 22 | 5 |  | 21
August | 11 | 22 | 5 | 1 | 22
July | 11 | 18 | 2 | 1 | 22
June | 8 | 28 |  | 1 | 23
May | 9 | 22 |  | 1 | 20
April | 6 | 22 |  | 1 | 23
March | 4 | 12 |  |  | 21
February |  |  |  |  | 20
January |  |  |  |  | 18
MONTH | 2013 Combined - RFA | 2013 Combined - EHP | 2013 Combined - EHSQ | 2013 Combined - WHP | Total Days Available
December |  |  |  |  | 22
November |  |  |  |  | 21
October |  |  |  |  | 23
September |  |  |  |  | 21
August |  |  |  |  | 22
July |  |  |  |  | 22
June |  |  |  |  | 23
May |  |  |  |  | 20
April |  |  |  |  | 23
March |  |  |  |  | 21
February |  |  |  |  | 20
January |  |  |  |  | 18
Spreadsheet: 295184d1391619112-reorganizing-data-to-show-info-from-two-separate-columns-in-a-third-new-column-excel-problem-example
Sheet: Sheet1

participant | when t2 | t2 correct |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
607 | 1 | 1 |  | participant | t2_correct_lag_1 | t2_correct_lag_2 | t2_correct_lag_3 | [NAME] | t2_correct_lag_5 | t2_correct_lag_6 | t2_correct_lag_7 | t2_correct_lag_8
607 | 2 | 1 |  | 607
607 | 3 | 1 |  | 209
607 | 4 | 1
607 | 5 | 0 |  | participant | t2_correct_lag_1 | t2_correct_lag_2 | t2_correct_lag_3 | [NAME] | t2_correct_lag_5 | t2_correct_lag_6 | t2_correct_lag_7 | t2_correct_lag_8
607 | 6 | 0 |  | 607
607 | 7 | 0 |  | 209
607 | 8 | 1
607 | 7 | 1
607 | 4 | 1
607 | 5 | 1
607 | 8 | 1
607 | 2 | 1
607 | 1 | 0
607 | 3 | 1
209 | 1 | 1
209 | 2 | 1
209 | 3 | 1
209 | 4 | 1
209 | 5 | 0
209 | 6 | 0
209 | 7 | 0
209 | 8 | 1
209 | 7 | 1
209 | 4 | 1
209 | 5 | 1
209 | 8 | 1
209 | 2 | 1
209 | 1 | 0
209 | 3 | 1
Spreadsheet: 862983d1710528684-function-to-find-value-if-index-row-overlaps-formula-to-find-new-values
Sheet: Sheet1

Index | 1 | 2 | 3 | 4 | 5 | 6 | Total
A | 0 | 100 | 100 | 300 | 500 | 0
B | 0 | 100 | 100 | 100 | 100 | 100
A | 200 | 200 | 200 | 0 | 0 | 0
C | 0 | 0 | 0 | 10 | 23 | 7
A | 300 | 100 | 500 | 1000 | 10 | 8
c | 100 | 0 | 100 | 0 | 100 | 0
B | 200 | 200 | 0 | 0 | 0 | 2
X | 0 | 10 | 100 | 1000 | 10 | 20
B | 200 | 200 | 200 | 0 | 0 | 0
A | 200 | 200 | 200 | 0 | 0 | 0
Index | 1 | 2 | 3 | 4 | 5 | 6 | Total | %
A | 0 | 150 | 250 | 650 | 255 | 0
B | 0 | 166.7 | 150 | 100 | 100 | 51
A | 233 | 150 | 250 | 0 | 0 | 0
C | 0 | 0 | 0 | 10 | 61.5 | 7
A | 233 | 150 | 250 | 650 | 255 | 8
c | 100 | 0 | 100 | 0 | 61.5 | 0
B | 133.3 | 166.7 | 0 | 0 | 0 | 7
X | 0 | 10 | 100 | 1000 | 10 | 20
B | 133.3 | 166.7 | 150 | 100 | 0 | 0
A | 233 | 150 | 250 | 0 | 0 | 0
A | 233.3333333333333
B
c | 100
X | 0 | 10 | 100 | 1000 | 10 | 20
Totals |  |  |  |  |  |  | Equal 100% Check |  | 1
a | 4117 |  |  |  |  |  | A
B | 1424.7 |  |  |  |  |  | B
C | 340 |  |  |  |  |  | C
X | 1140 |  |  |  |  |  | X
Spreadsheet: 873621d1720118503-return-specific-text-if-within-range-of-days-excel-help-date-range-lookup-example
Sheet: MASTER DATA - ALL BRANCHES

DAYS SINCE LAST USED | PIVOT CATEGORY (BRANCH SPECIFIC) | MANUALLY WRITTEN ANSWER (AS CHECK)
NEVER |  | NEVER
210.2685719560031 |  | 6-7 MONTHS
8.437299421297212 |  | 0-1 MONTHS
35.28513356480107 |  | 1-2 MONTHS
27.69366408570204 |  | 0-1 MONTHS
49.56036096059688 |  | 1-2 MONTHS
90.58421982639993 |  | 2-3 MONTHS
483.7035456829035 |  | 1-2 YEARS
224.3621806365991 |  | 7-8 MONTHS
331.7326639699022 |  | 10-11 MONTHS
34.74347233799926 |  | 1-2 MONTHS
Spreadsheet: 584146d1532993821-combining-values-in-multiple-rows-into-1-row-of-comma-separated-values-based-on-duplicates-pq-group-and-extract-list-delimited
Sheet: The Data I Have

Supplier ID | Building Reference |  |  |  |  |  | Supplier ID | Custom
100 | A |  |  |  |  |  | 100 | A, B, C
100 | B |  | Do these steps to get your answer |  |  |  | 250 | A, Z
100 | C |  | 1. Select cell A1 |  |  |  | 600 | C, G, H, J
250 | A |  | 2. Click on the Data Tab
250 | Z |  | 3. Click on From Table/Range
600 | C |  | 4. Click on "OK"
600 | G |  | This will then bring up the Power Query window
600 | H |  | 5 click on Group By
600 | J |  |  | Supplier ID with operation of "All Rows"
 |  |  | 6. Click on "Add Column"
 |  |  | 7. Click "Custom Column"
 |  |  | 8. Type  =Table.Column ([Count], "Building Reference")
 |  |  | 9. Click the double arrow to the right of "Custom"
 |  |  |  | Extract Values…
 |  |  | 10. Change the "None" to Custom Delimiter of <comma><space>
 |  |  | 11. Remove the count Column
 |  |  | 12. Exit and save from the home tab to H1 (See above)
 |  |  | OR
 |  |  | Open this file and click on [NAME]
 |  |  | Click on Queries and Connections
 |  |  | Click on the Table Query and Edit
 |  |  | Follow those Power Query Steps in this file.
Spreadsheet: 713404d1610705722-match-in-list-sample
Sheet: Sheet1

 |  | ADDRESS | Country |  | Deparment
 |  | 10 RUE DES JARDIN SAINT MANDE,[NAME],Val-de-Marne,94160 |  |  | Ain
 |  | 6 rue de la victoire,ermont ,Haute-Savoie,74380 |  |  | Aisne
 |  | 4 rue des berges, Franconville 95300 Val d'oise |  |  | Allier
 |  | [NAME] 9, Barcelona |  |  | Alpes-de-Haute-Provence
 |  | 9 impasse de la grange,Haute-Garonne-Toulouse |  |  | Hautes-Alpes
 |  |  |  |  | Alpes-Maritimes
 |  |  |  |  | Ardèche
 |  |  |  |  | Ardennes
 |  |  |  |  | Ariège
 |  |  |  |  | Aube
 |  |  |  |  | Aude
 |  |  |  |  | Aveyron
 |  |  |  |  | Bouches-du-Rhône
 |  |  |  |  | Calvados
 |  |  |  |  | Cantal
 |  |  |  |  | Charente
 |  |  |  |  | Charente-Maritime
 |  |  |  |  | [NAME]
 |  |  |  |  | Corrèze
 |  |  |  |  | Corse-du-Sud
 |  |  |  |  | Haute-Corse
 |  |  |  |  | Côte-d'Or
 |  |  |  |  | Côtes-d'Armor
 |  |  |  |  | Creuse
 |  |  |  |  | Dordogne
 |  |  |  |  | Doubs
 |  |  |  |  | Drôme
 |  |  |  |  | Eure
 |  |  |  |  | Eure-et-Loir
 |  |  |  |  | Finistère
 |  |  |  |  | Gard
 |  |  |  |  | Haute-Garonne
 |  |  |  |  | Gers
 |  |  |  |  | Gironde
 |  |  |  |  | Hérault
 |  |  |  |  | Ille-et-Vilaine
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]-et-Loire
 |  |  |  |  | Isère
 |  |  |  |  | [NAME]
 |  |  |  |  | Landes
 |  |  |  |  | Loir-et-Cher
 |  |  |  |  | Loire
 |  |  |  |  | Haute-Loire
 |  |  |  |  | Loire-Atlantique
 |  |  |  |  | [NAME]
 |  |  |  |  | Lot
 |  |  |  |  | Lot-et-Garonne
 |  |  |  |  | Lozère
 |  |  |  |  | Maine-et-Loire
 |  |  |  |  | Manche
 |  |  |  |  | Marne
 |  |  |  |  | Haute-Marne
 |  |  |  |  | Mayenne
 |  |  |  |  | Meurthe-et-Moselle
 |  |  |  |  | Meuse
 |  |  |  |  | Morbihan
 |  |  |  |  | Moselle
 |  |  |  |  | Nièvre
 |  |  |  |  | Nord
 |  |  |  |  | Oise
 |  |  |  |  | Orne
 |  |  |  |  | Pas-de-Calais
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | Hautes-Pyrénées
 |  |  |  |  | Pyrénées-Orientales
 |  |  |  |  | [NAME]
 |  |  |  |  | Haut-Rhin10
 |  |  |  |  | RhôneNote 7
 |  |  |  |  | Haute-Saône
 |  |  |  |  | Saône-et-Loire
 |  |  |  |  | Sarthe
 |  |  |  |  | Savoie
 |  |  |  |  | Haute-Savoie
 |  |  |  |  | Paris
 |  |  |  |  | Seine-Maritime
 |  |  |  |  | Seine-et-Marne
 |  |  |  |  | Yvelines
 |  |  |  |  | [NAME]
 |  |  |  |  | Somme
 |  |  |  |  | Tarn
 |  |  |  |  | Tarn-et-Garonne
 |  |  |  |  | Var
 |  |  |  |  | Vaucluse
 |  |  |  |  | Vendée
 |  |  |  |  | [NAME]
 |  |  |  |  | Haute-Vienne
 |  |  |  |  | Vosges
 |  |  |  |  | [NAME]
 |  |  |  |  | Territoire de Belfort
 |  |  |  |  | Essonne
 |  |  |  |  | Hauts-de-Seine
 |  |  |  |  | Seine-Saint-Denis
 |  |  |  |  | Val-de-Marne
 |  |  |  |  | Val-d'Oise
Spreadsheet: 703210d1604850001-sumif-concatenated-criteria-does-not-work-in-one-tab-but-works-in-all-others-sumif-example
Sheet: A

 | Sum of values thru current month
10 | Current month
Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Value | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Spreadsheet: 476793d1472027788-linked-input-cells-data-base-example
Sheet: Sheet1

Name | Accompanied | Full Delegate | Full Delegate plus Tour | Conference Day (8th June) |  |  |  | Science & Sustainability (4th June) |  |  | Great British Food (5th June) |  |  | Rural Enterprise & Modern Day Estates (6th June) |  |  | World Class Innovation (7th June) |  | The Power of Renewables (9th June) |  |  |  | Iconic Hills & Uplands (10th June) |  | Family Owned, [NAME] (11th June) |  | Gilet | Guest Gilet | Total | Amount Paid | Outstanding |  |  |  | Full Delegate | Full Delegate plus Tour | Conference Day (8th June) |  |  |  | Science & Sustainability (4th June) |  |  | Great British Food (5th June) |  |  | Rural Enterprise & Modern Day Estates (6th June) |  |  | World Class Innovation (7th June) |  | The Power of Renewables (9th June) |  |  |  | Iconic Hills & Uplands (10th June) |  | Family Owned, [NAME] (11th June) |  | Gilet | Guest Gilet | Total | Amount Paid | Outstanding
 |  |  |  | Day Ticket | Dinner | Dinner and Acc. | [NAME]. | Tour 1 | Tour 2 | Heritage | Tour 1 | Tour 2 | Tour 3 | Tour 1 | Tour 2 | Heritage | Tour 1 | Tour 2 | Tour 1 | Tour 2 | Tour 3 | Heritage | Tour 1 | Free Day | Tour 1 | Tour 2 |  |  |  |  |  |  |  |  |  |  | Day Ticket | Dinner | Dinner and Acc. | [NAME]. | Tour 1 | Tour 2 | Heritage | Tour 1 | Tour 2 | Tour 3 | Tour 1 | Tour 2 | Heritage | Tour 1 | Tour 2 | Tour 1 | Tour 2 | Tour 3 | Heritage | Tour 1 | Free Day | Tour 1 | Tour 2
[NAME] | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False
[NAME] | Yes
Spreadsheet: c6ec3af8-dbd5-45d5-87e4-a2e8d6d8f04d
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
BRAF | Test | BRAF | BRAF Mutation Analysis (V600E), Tumor | BRAF Mutation Analysis(V600E),Tumor | Polymerase Chain Reaction (PCR) Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Varies: Var |  |  |  | Varies | Pathology report must accompany specimen in order for testing to be performed.   Specimen Type: Tissue block or slide Collection Instructions: 1. Submit formalin-fixed, paraffin-embedded tissue block (preferred) or 1 slide stained with hematoxylin and eosin and 10 unstained, nonbaked slides (5-micrometers thick sections) of the tumor tissue. 2. Sections should contain both tumor and normal tissue. Forms:  1. [NAME] (Supply T519) in Special Instructions. 2. If not ordering electronically, submit a Molecular Genetics Request Form (Supply T245) with the specimen. |  | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretative report will be provided. | Monday, Wednesday, Friday; 10 a.m. | 14 days | Varies | 1 | 81210 |  |  |  |  | Rochester
BRAF | [NAME] | VARIES | Varies |  |  |  | Ambient
BRAF | Result | 26891 | [NAME] | [NAME] | Alphanumeric
BRAF | Result | 26892 | [NAME] | [NAME] | Alphanumeric
BRAF | Result | 26893 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
BRAF | Result | 26894 | Order Date | Order Date | Alphanumeric
BRAF | Result | 26895 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
BRAF | Result | 26896 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
BRAF | Result | 26897 | Results | Results | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53844-7 | BRAF gene mutation analysis:Prid:Pt:Bld/Tiss:Nar:Molgen
BRAF | Result | 26898 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
BRAF | Result | 26899 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53844-7 | BRAF gene mutation analysis:Prid:Pt:Bld/Tiss:Nar:Molgen
BRAF | Result | 26900 | Consultant | Consultant | Alphanumeric
BRAF | Result | 26901 | Report Date | Report Date | Alphanumeric
BRAF | [NAME] | SLRVW | Slide Review ([NAME] Only) | Slide Review |  |  |  |  |  |  | For billing purposes only. |  |  |  |  |  |  | 1 | 88381 |  |  | Yes | No
Spreadsheet: 149713d1334091245-stripping-out-value-from-thousands-of-uniformly-composed-jpg-file-names-forum
Sheet: Arkusz1

173364_685910082_1806180935_q.jpg
173371_815809745_914652661_q.jpg
173393_1823281336_495341315_q.jpg
173395_708302069_489863836_q.jpg
173410_1493363708_1008760165_q.jpg
173508_100001995621824_823757_q.jpg
173608_1426751920_22592946_q.jpg
173738_584908944_1229838231_q.jpg
173739_571064503_145054000_q.jpg
173749_100002835288099_1203807834_q.jpg
173770_1350850289_1506892704_q.jpg
173804_100001353347531_1424301650_q.jpg