tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 37283d1235246241-excel-2007-hope-someone-can-help-with-formula-rank-names_ef
Sheet: rank

 |  | names |  |  |  | numbers
 |  | [NAME] |  |  |  | 11 |  |  | rank | number | name
 |  | [NAME] |  |  |  | 17 |  |  | 1 | 20 | [NAME]
 |  | [NAME] |  |  |  | 16 |  |  | 2 | 19 | [NAME]
 |  | callum barnes |  |  |  | 11 |  |  | 3 | 18 | [NAME]
 |  | [NAME] |  |  |  | 3 |  |  | 4 | 18 | [NAME]
 |  | [NAME] |  |  |  | 17 |  |  | 5 | 18 | martina ibbott
 |  | [NAME] |  |  |  | 2 |  |  | 6 | 18 | [NAME]
 |  | [NAME] |  |  |  | 19 |  |  | 7 | 17 | [NAME]
 |  | eddie [NAME] |  |  |  | 7 |  |  | 8 | 17 | [NAME]
 |  | [NAME] cave |  |  |  | 1 |  |  | 9 | 17 | [NAME]
 |  | [NAME] |  |  |  | 20 |  |  | 10 | 17 | [NAME]
 |  | [NAME] |  |  |  | 6
 |  | [NAME] |  |  |  | 1
 |  | geraldine davies |  |  |  | 11
 |  | gertrude Delaware |  |  |  | 7
 |  | [NAME] |  |  |  | 18
 |  | [NAME] |  |  |  | 10
 |  | henrietta [NAME] |  |  |  | 8
 |  | hope everett |  |  |  | 15
 |  | [NAME] |  |  |  | 6
 |  | [NAME] |  |  |  | 8
 |  | janice frith |  |  |  | 6
 |  | [NAME] |  |  |  | 16
 |  | [NAME] |  |  |  | 16
 |  | kiera grant |  |  |  | 9
 |  | laura green |  |  |  | 16
 |  | [NAME] |  |  |  | 10
 |  | [NAME] |  |  |  | 18
 |  | martina ibbott |  |  |  | 18
 |  | [NAME] |  |  |  | 17
 |  | [NAME] |  |  |  | 7
 |  | millie jones |  |  |  | 3
 |  | [NAME] keen |  |  |  | 8
 |  | nathan lampard |  |  |  | 5
 |  | [NAME] |  |  |  | 8
 |  | [NAME] |  |  |  | 5
 |  | opal miller |  |  |  | 14
 |  | [NAME] |  |  |  | 17
 |  | [NAME] |  |  |  | 18
 |  | [NAME] |  |  |  | 5
 |  | rhiannon oates |  |  |  | 7
 |  | [NAME] |  |  |  | 15
 |  | shannon pritchard |  |  |  | 15
 |  | [NAME] |  |  |  | 16
 |  | [NAME] |  |  |  | 13
 |  | [NAME] |  |  |  | 13
 |  | todd rolfe |  |  |  | 10
 |  | vernon smith |  |  |  | 4
 |  | will stevens |  |  |  | 6
 |  | xavier stevenson |  |  |  | 1
Spreadsheet: 85a1b7a1-6013-4f98-849d-1e8dd3f1622f
Sheet: Sheet1

BUCS Squash 2010/11 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
Women's Results Card
 | Home Team |  |  |  |  |  |  |  |  |  |  |  |  | Away Team
 | Essex | Match Date: |  |  | 2010-11-17 00:00:00 |  |  |  |  |  |  |  |  | Royal Holloway
 |  | Games | Individual Game Scores |  |  |  |  |  |  |  |  |  | Games
 |  |  | H | A | H | A | H | A | H | A | H | A
 | 1) [NAME] | 0 | 2 | 11 | 2 | 11 | 5 | 11 |  |  |  |  | 3 | 1) [NAME]
 | 2) Sam | 3 | 11 | 3 | 11 | 3 | 11 | 6 |  |  |  |  | 0 | 2) [NAME]
 | 3) Jo | 3 | 11 | 6 | 11 | 5 | 11 | 7 |  |  |  |  | 0 | 3) [NAME]
 | 4) Rachel | 0 | 0 | 11 | 2 | 11 | 1 | 11 |  |  |  |  | 3 | 4) Sofiya
 | MATCH RESULT
 | Essex |  |  |  |  | 2 | - | 2 | Royal Holloway
 |  |  |  |  | GAMES
 |  |  |  |  |  | 6 | - | 6
 |  |  |  |  |  | POINTS
 |  |  |  |  | 78 |  | - | 96
THIS RESULTS CARD MUST BE EMAILED TO [EMAIL] WITHIN 5 WORKING DAYS OF THE MATCH
 | MATCH RESULT |  | H | A
 | Match 1 |  | 0 | 1
 | Match 2 |  | 1 | 0
 | Match 3 |  | 1 | 0
 | Match 4 |  | 0 | 1
 | GAMES
 |  | Game | 1 | 2 | 3 | 4 | 5 | Total Games
 | Match 1
 | H |  | 0 | 0 | 0 | 0 | 0 | 0
 | A |  | 1 | 1 | 1 | 0 | 0 | 3
 | Match 2
 | H |  | 1 | 1 | 1 | 0 | 0 | 3
 | A |  | 0 | 0 | 0 | 0 | 0 | 0
 | Match 3
 | H |  | 1 | 1 | 1 | 0 | 0 | 3
 | A |  | 0 | 0 | 0 | 0 | 0 | 0
 | Match 4
 | H |  | 0 | 0 | 0 | 0 | 0 | 0
 | A |  | 1 | 1 | 1 | 0 | 0 | 3
Spreadsheet: phillip_m_love__30152__9905_OA
Sheet: EAST-LRC-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  LRC
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -76
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  | 170000 |  | 0
 |  | TOTAL
Spreadsheet: e9f3a01c-9a06-46a2-8fbf-fb6c7d40170d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6271 | 40954 | Faye | Mcclelland | GBR | 7 | 00:06:20 | 00:00:49 | 00:15:23 | 00:00:31 | 00:14:56 | 1 | 00:37:58
6271 | 30601 | Clare | Cunningham | GBR | 6 | 00:06:27 | 00:00:49 | 00:15:47 | 00:00:34 | 00:15:22 | 2 | 00:38:58
6271 | 23650 | [NAME] | Dasse | FRA | 9 | 00:08:20 | [NAME] | 00:16:01 | 00:00:24 | 00:16:22 | 3 | 00:41:59
6271 | 40921 | Anna | [NAME] | ESP | 8 | 00:08:16 | 00:00:48 | 00:15:56 | [NAME] | 00:17:19 | 4 | 00:42:57
Spreadsheet: 220535d1363187847-autofill-data-once-a-selection-is-made-from-a-dropdown-box-sample
Sheet: Sheet1

Month | Sales | FAM | P Sales | P | F | F1 | D | D1 | M | T-lbs | N-lbs | P-lbs |  |  |  |  | D | <-- Dropdown
J '03 | 300000 | 80000 | 85000 | 61000 | 71000 | 81000 | 205000 | 105000 | 310 | 305 | 302 | 350 |  | List for dropdown |  | J '03 |  | I want the yellow cells to match
F | 400000 | 90000 | 95000 | 62000 | 72000 | 82000 | 210000 | 110000 | 320 | 310 | 304 | 400 |  | Sales |  | F |  | what is in the data box
M | 450000 | 100000 | 105000 | 63000 | 73000 | 83000 | 215000 | 115000 | 330 | 315 | 306 | 450 |  | FAM |  | M |  | based on what is selected on the
A | 500000 | 110000 | 115000 | 64000 | 74000 | 84000 | 220000 | 120000 | 340 | 320 | 308 | 500 |  | P Sales |  | A |  | dropdown
M | 600000 | 120000 | 125000 | 65000 | 75000 | 85000 | 225000 | 125000 | 350 | 325 | 310 | 550 |  | P |  | M
J | 700000 | 130000 | 135000 | 66000 | 76000 | 86000 | 230000 | 130000 | 360 | 330 | 312 | 600 |  | F |  | J
Jul | 800000 | 140000 | 145000 | 67000 | 77000 | 87000 | 235000 | 135000 | 370 | 335 | 314 | 650 |  | F1 |  | Jul
A | 900000 | 150000 | 155000 | 68000 | 78000 | 88000 | 240000 | 140000 | 380 | 340 | 316 | 700 |  | D |  | A
S | 1000000 | 160000 | 165000 | 69000 | 79000 | 89000 | 245000 | 145000 | 390 | 345 | 318 | 750 |  | D1 |  | S
O | 1100000 | 170000 | 175000 | 70000 | 80000 | 90000 | 250000 | 150000 | 400 | 350 | 320 | 800 |  | M-lbs |  | O
N | 1200000 | 180000 | 185000 | 71000 | 81000 | 91000 | 255000 | 155000 | 410 | 355 | 322 | 850 |  | T-lbs |  | N
D | 1300000 | 190000 | 195000 | 72000 | 82000 | 92000 | 260000 | 160000 | 420 | 360 | 324 | 900 |  | N-lbs |  | D
J '04 | 1400000 | 200000 | 205000 | 73000 | 83000 | 93000 | 265000 | 165000 | 430 | 365 | 326 | 950 |  | P-lbs |  | J '04
Spreadsheet: 1160b714-2cae-4a30-83cf-e6aa682598c6
Sheet: Perpus

RENCANA UMUM PENGADAAN BARANG/JASA PEMERINTAH
PA/KPA |  | : Ardiansyah, S.Sos
K/L/D/I |  | : [NAME]. [NAME]
SATKER/SKPD |  | : [NAME], Arsip, dan [NAME]
PPK |  | :
[NAME] |  | : 2012
NO | KEGIATAN |  | SUB KEGIATAN/ PEKERJAAN | NAMA PAKET PEKERJAAN | VOLUME | LOKASI PEKERJAAN (PROVINSI/KAB/KOTA) | RENCANA PENGANGGARAN |  |  | CARA PENGADAAN | PERKIRAAN WAKTU MULAI PELAKSANAAN PENGADAAN ￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼ | WAKTU PELAKSANAAN (BULAN) | [NAME]
 |  |  |  |  |  |  | PERKIRAAN BIAYA (RP,-) | [NAME] (APBN/APBD) | RENCANA PEMBIAYAAN
(1) | (2) |  | (3) | (4) | (5) | (6) | (7) | (8) | (9) | (10) | (11) | (12) | (13)
1 | Program pelayanan administrasi perkantoran |  | Penyediaan peralatan [NAME] kantor | Belanja modal mesin sidik jari/ finger print | 22 | [NAME] | 20000000 | APBD | Dibiayai oleh K/L/D/I | PBJ | Januari 2012 | 7 hari kerja
 |  |  |  | Belanja modal pengadaan meja [NAME] | 1 | [NAME] | 2500000 | APBD | Dibiayai oleh K/L/D/I | Swakelola | Maret 2012 | 7 hari kerja
2 | Program pengembangan budaya [NAME] pembinaan perpustakaan |  | Penyediaan bahan pustaka perpustakaan umum daerah | Pengadaan bahan pustaka untuk anak-anak | 300 | [NAME] | 15000000 | APBD | Dibiayai oleh K/L/D/I | PBJ | Maret 2012 | 15 hari kerja
 |  |  |  | Pengadaan bahan pustaka untuk layanan umum | 400 | [NAME] | 20000000 | APBD | Dibiayai oleh K/L/D/I | PBJ | Maret 2012 | 15 hari kerja
 |  |  |  | Pengadaan pustaka untuk layanan perpustakaan keliling | 400 | [NAME] | 18000000 | APBD | Dibiayai oleh K/L/D/I | PBJ | Maret 2012 | 15 hari kerja
 |  |  |  | Pengadaan bahan pustaka untuk referensi | 50 | [NAME] | 3750000 | APBD | Dibiayai oleh K/L/D/I | PBJ | Maret 2012 | 15 hari kerja
Spreadsheet: 870850d1717313886-countif-conditional-formatting-lotto-bingo2
Sheet: Input

 | DRAW DATE | NUMBERS DRAWN |  |  |  |  |  |  | WINNER
 | 2024-05-18 00:00:00 | 9 | 13 | 22 | 45 | 46 | 48
 | 2024-05-25 00:00:00 | 6 | 28 | 30 | 40 | 53 | 58
 | 2024-06-01 00:00:00 | 6 | 11 | 16 | 21 | 43 | 50
 | 2024-06-08 00:00:00
 | 2024-06-15 00:00:00
Spreadsheet: darrell_schoolcraft__7314__imball0202
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 46181 | 46125
2 | 45310 | 45501
3 | 45365 | 45393
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 4386
2002-02-03 00:00:00
CBS Volume
 |  |  | 1925
Spreadsheet: 669229d1585252940-sort-on-column-by-criteria-in-other-column-q2
Sheet: Sheet1

 | B | C |  | C Sorted | B Sorted |  |  | I have data in B:C
 | ABCDEF1 | 0 |  |  |  |  |  | In E, I have sorted C, ascending
 | ABCDEF2 | 2 |  |  |  |  |  | At F4 , I need B to follow E
 | ABCDEF3 | 3 |  |  |  |  |  | This is to bypass [NAME]
 | ABCDEF4 | 4
 | ABCDEF5 | 1
 | ABCDEF6 | 1
 | ABCDEF7 | 2
 | ABCDEF8 | 2
 | ABCDEF9 | 3
 | ABCDEF10 | 2
 | ABCDEF11 | 1
 | ABCDEF12 | 4
 | ABCDEF13 | 5
 | ABCDEF14 | 5
 | ABCDEF15 | 5
 | ABCDEF16 | 3
 | ABCDEF17 | 1
 | [NAME] | 1
 | ABCDEF19 | 2
 | ABCDEF20 | 3
Spreadsheet: 804748d1668267411-stock-allocation-value-book1-isskint-
Sheet: Stock age

 |  |  |  |  | Order Date | 2022-08-12 00:00:00 | 2022-08-18 00:00:00 | 2022-09-01 00:00:00 | 2022-09-17 00:00:00 | 2022-10-01 00:00:00 | 2022-10-21 00:00:00
 |  |  |  |  | SKU | PROD1234 | PROD1234 | PROD1234 | PROD1234 | PROD1234 | PROD1234
 |  |  |  |  | Quantity | 17 | 12 | 9 | 13 | 5 | 15
Receipt date | Serial | [NAME] | qty | unit cost
2021-05-18 00:00:00 | SN44334-1 | PROD1016 | 18 | 5.71
2021-05-25 00:00:00 | SN44341-1 | PROD1001 | 6 | 2.24
2021-06-08 00:00:00 | SN44355-1 | PROD1033 | 9 | 6.73
2021-07-04 00:00:00 | SN44381-1 | PROD1033 | 26 | 8.6
2021-07-14 00:00:00 | SN44391-1 | PROD1111 | 3 | 5.7
2021-08-10 00:00:00 | SN44418-1 | PROD1197 | 1 | 6.24
2021-08-10 00:00:00 | SN44418-2 | PROD1197 | 1 | 6.24
2021-08-10 00:00:00 | SN44418-3 | PROD1197 | 1 | 6.24
2021-08-10 00:00:00 | SN44418-4 | PROD1197 | 1 | 6.24
2021-08-11 00:00:00 | SN44419-1 | PROD1143 | 28 | 1.57
2021-08-21 00:00:00 | SN44429-1 | PROD1090 | 15 | 7.33
2021-08-25 00:00:00 | SN44433-1 | PROD1063 | 6 | 2.17
2021-08-29 00:00:00 | SN44437-1 | PROD1094 | 23 | 8.04
2021-09-16 00:00:00 | SN44455-1 | PROD1096 | 11 | 1.1
2021-09-29 00:00:00 | SN44468-1 | PROD1194 | 21 | 1.34
2021-09-30 00:00:00 | SN44469-1 | PROD1051 | 20 | 1.75
2021-10-11 00:00:00 | SN44480-1 | PROD1197 | 23 | 7.5
2021-10-15 00:00:00 | SN44484-1 | PROD1234 | 13 | 1.79
2021-10-21 00:00:00 | SN44490-2 | PROD1234 | 13 | 3.33
2021-10-21 00:00:00 | SN44490-2 | PROD1160 | 10 | 3.2
2021-11-21 00:00:00 | SN44521-1 | PROD1021 | 25 | 8.67
2021-11-26 00:00:00 | SN44526-1 | PROD1190 | 10 | 1.37
2021-12-12 00:00:00 | SN44542-1 | PROD1152 | 8 | 6.6
2021-12-14 00:00:00 | SN44544-1 | PROD1157 | 29 | 9.06
2022-01-31 00:00:00 | SN44592-1 | PROD1179 | 9 | 6.7
2022-02-18 00:00:00 | SN44610-1 | PROD1064 | 23 | 7.59
2022-03-07 00:00:00 | SN44627-1 | PROD1185 | 29 | 3.1
2022-03-12 00:00:00 | SN44632-1 | PROD1234 | 22 | 8.58
2022-03-15 00:00:00 | SN44635-1 | PROD1072 | 17 | 4.02
2022-03-31 00:00:00 | SN44651-1 | PROD1234 | 24 | 1.16
2022-04-26 00:00:00 | SN44677-1 | PROD1111 | 5 | 1.51
2022-05-15 00:00:00 | SN44696-1 | PROD1035 | 23 | 7.48
2022-05-25 00:00:00 | SN44706-1 | PROD1234 | 28 | 5.72
2022-06-15 00:00:00 | SN44727-1 | PROD1080 | 19 | 8.78
2022-06-27 00:00:00 | SN44739-1 | PROD1190 | 1 | 2.68
2022-07-16 00:00:00 | SN44758-1 | PROD1048 | 5 | 4.9
2022-07-25 00:00:00 | SN44767-1 | PROD1234 | 30 | 1.21
2022-08-01 00:00:00 | SN44774-1 | PROD1022 | 3 | 6.12
2022-08-13 00:00:00 | SN44786-1 | PROD1085 | 27 | 3.94
Spreadsheet: 879209d1726663541-extract-specific-number-from-cells-formula-82
Sheet: Sheet1

INPUT
Folder | File | Size |  | OUTPUT
C:\Users\Shraddha Patil\Downloads\MT SEP | C:\Users\Shraddha Patil\Downloads\MT SEP\8261592 (1).pdf | 6506577 |  | 8261592
C:\Users\Shraddha Patil\Downloads\MT SEP | C:\Users\Shraddha Patil\Downloads\MT SEP\8261708.pdf | 2367345 |  | 8261708
C:\Users\Shraddha Patil\Downloads\MT SEP | C:\Users\Shraddha Patil\Downloads\MT SEP\8279070.jpeg | 180082 |  | 8279070
C:\Users\Shraddha Patil\Downloads\MT SEP\09092024 | C:\Users\Shraddha Patil\Downloads\MT SEP\09092024\8270918.pdf | 2652294 |  | 8270918
C:\Users\Shraddha Patil\Downloads\MT SEP\09092024 | C:\Users\Shraddha Patil\Downloads\MT SEP\09092024\8277440 (1).pdf | 3826291 |  | 8277440
C:\Users\Shraddha Patil\Downloads\MT SEP\09092024 | C:\Users\Shraddha Patil\Downloads\MT SEP\09092024\8280656-[PHONE]-49.pdf | 3301519 |  | 8280656
Spreadsheet: 58991d1259305636-how-to-avoid-value-book2
Sheet: Sample

 | ENTITY | PO Number | PO VALUE  FOR 12  MONTHS | CITY | Site | Designation | CONTRACTED COST INR PER MONTH | CONTRACTED COST      $ PER MONTH | Actual Spend in Nov-09     INR | Actual Spend in Nov-09         $ | Actual Spend in Dec-09     INR | Actual Spend in Dec-09         $ | Actual Spend in Jan-10     INR | Actual Spend in Jan-10         $ | Actual Spend in Feb-10     INR | Actual Spend in Feb-10         $ | Actual Spend in Mar-10     INR | Actual Spend in Mar-10         $ | Actual Spend in Apr-10     INR | Actual Spend in Apr-10         $ | Actual Spend in May-10     INR | Actual Spend in May-10         $ | Actual Spend in Jun-10     INR | Actual Spend in Jun-10         $ | Actual Spend in Jul-10     INR | Actual Spend in Jul-10         $ | Actual Spend in Aug-10     INR | Actual Spend in Aug-10         $ | Actual Spend in Sep-10     INR | Actual Spend in Sep-10         $ | Actual Spend in Oct-10     INR | Actual Spend in Oct-10         $ |  | Grand Total INR | Grand Total $
 | H P G S
 |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | #N/A
 |  |  |  | B A N G A L O R E
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | #N/A
 |  |  |  |  |  | Assign Mgr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  | A S O
 |  |  |  |  |  | Sec Officer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  | Supervisor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  | Head Guard
 |  |  |  |  |  | Security Guard |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  | Switch Board Op |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  | Receptionist |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Spreadsheet: 831967d1686035101-combine-pairing-multiple-row-in-one-column-to-another-column-learning-excel-case-2
Sheet: Sheet1

 | SKU | CHANNEL
 | ABC | AA
 | BCD | BB
 | CDE | CC
 | DEF
 | EFG
 | FGH
 | GHI
 | HIJ
 | IJK
 | JKL
 | MODEL | CHANNEL | UNIQUE
 | ABC | AA |  |  | blue color is expected result
 | ABC | BB
 | ABC | CC
 | BCD | AA
 | BCD | BB
 | BCD | CC
 | CDE | AA
 | CDE | BB
 | CDE | CC
 | DEF | AA
 | DEF | BB
 | DEF | CC
 | EFG | AA
 | EFG | BB
 | EFG | CC
 | FGH | AA
 | FGH | BB
 | FGH | CC
 | GHI | AA
 | GHI | BB
 | GHI | CC
 | HIJ | AA
 | HIJ | BB
 | HIJ | CC
 | IJK | AA
 | IJK | BB
 | IJK | CC
 |  | AA
 |  | BB
 |  | CC
 |  | AA
 |  | BB
 |  | CC
 |  | AA
 |  | BB
 |  | CC
 |  | AA
 |  | BB
 |  | CC
Spreadsheet: 275471d1383530304-nested-if-statements-are-returning-false-values-cannot-find-error-in-code-fairbank-roster-summary-page
Sheet: Production

Fairbank |  |  | ROSTER | Production |  |  |  |  |  |  |  | WEEK ENDING: |  |  | 2013-11-10 00:00:00
 |  |  | MONDAY |  | 2013-11-04 00:00:00 | TUESDAY |  | 2013-11-05 00:00:00 | WEDNESDAY |  | 2013-11-06 00:00:00 | THURSDAY |  | 2013-11-07 00:00:00 | FRIDAY |  | 2013-11-08 00:00:00 | SATURDAY |  | 2013-11-09 00:00:00 | SUNDAY |  | 2013-11-10 00:00:00
 |  | ROLE | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS
SUPERVISORS
 |  | ROLE | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS
MORNING SHIFT | Non-Skilled |  | [NAME] | 6am | 8 | [NAME] | 6am | 8 | [NAME] | 6am | 8 | [NAME] | 6am | 8 | [NAME] | 6am | 8 | [NAME] | 6am | 8 | [NAME] | 6am | 8
 | Skilled
 | Cleaners
 |  | ROLE | NAME | TIME | HRS | NAME |  | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS
AFTERNOON SHIFT | Non-Skilled
 | Skilled
Spreadsheet: 155412d1336819867-lookup-lookup-peiling
Sheet: Sheet1

 | 0 | -45 | 45 | 100 | 250 | 500 | 1000 |  |  |  | DEST weight RATES
CDG | 100 | 20.45 | 4 | 3.9 | 3.8 | 3.5 | 3.2 |  |  |  | CDG | 100 | need to look up 3.90 from table 1)
IST | 100 | 20.45 | 3 | 2.8 | 2.7 | 2.7 | 2.5 |  |  |  | IST | 320 | need to look up 2.70 from table 1)
AMS | 100 | 20.45 | 3.9 | 3.8 | 3.7 | 3.4 | 3.1 |  |  |  | AMS | 250 | need to look up 3.70 from table 1)
HAM | 100 | 20.45 | 4.1 | 4 | 3.9 | 3.5 | 3.2 |  |  |  | HAM | 999 | need to look up 3.50 from table 1)
 |  |  |  |  |  |  |  |  |  |  | HAM | 4.9
Spreadsheet: 775601d1649224610-error-handling-extract-all-rows
Sheet: Dataset - range

 | Item | Name | Value | Company
 | 1 | [NAME] | 2 | North
 | 2 | [NAME] | 6 | North
 | 3 | [NAME] | 4 | South
 | 4 | [NAME] | 5 | West
 | 5 | [NAME] | 3 | South
 | 6 | [NAME] | 9 | East
 | 7 | [NAME] | 3 | West
 | 8 | [NAME] | 2 | West
 | 9 | [NAME] | 0 | South
 | 10 | [NAME] | 1 | East
 |  | Start value: | 0
 |  | End value: | 1
 |  | Column number: | 3
 | Search results
 | Item | Name | Value | Company
Spreadsheet: 882466d1730852190-using-vlookup-to-update-pricing-from-one-sheet-to-another-book2
Sheet: Sheet2

SKU | UNIQUE | [NAME] | COST
12276 | 0 | PSX24W 12276 12V BOX 1 | 29.29
17100 | 0 | GLOBE PREMIUM CABINET 12/24V | 566.43
17110 | 0 | GLOBE CABINET HEAVY DUTY/LONG LIFE 12/24V | 879.4
17171 | 0 | LONG LIFE 207 12V 5W Ba15s PK10 | 5.14
17177 | 0 | LONG LIFE 501 12V 5W T-10mm PK10 | 5.14
17181 | 0 | LONG LIFE 149 24V 5W Ba15s PK10 | 6.17
17197 | 0 | LONG LIFE 507 24V 5W T-10mm PK10 | 8.42
17241 | 0 | HEAVY DUTY 24V 21W BA15S PK10 | 20.85
17336 | 0 | HEAVY DUTY 24V 21/5W BAY15S PK10 | 16.72
17380 | 0 | HEAVY DUTY 12V 21/5W BAY15S PK10 | 11.13
17382 | 0 | HEAVY DUTY 12V 21W BA15S PK10 | 9.72
17384 | 0 | HEAVY DUTY 12V 21W BAU15S PK10 | 12.54
17440 | 0 | GLOBE BULB 12V 21W T20 WEDGE | 22.4
17443 | 0 | GLOBE PREM 12V 21/5W T20 WEDGE | 22.4
17635 | 0 | LONG LIFE 382 12V 21W Ba15s PK10 | 6.17
17638 | 0 | LONG LIFE 384 12V 21W BaU15s PK10 | 16.82
17643 | 0 | LONG LIFE 241 24V 21W Ba15s PK10 | 7.29
17649 | 0 | PREMIUM 24V 21W [NAME] AMBER PK10 | 27.46
17833 | 0 | GLOBE PREM. BULB 12V 10W Ba9sH | 5.88
17835 | 0 | GLOBE MINI HALOGEN 12V20W BA9s | 5.88
17916 | 0 | LONG LIFE 380 12V 21/5W BaY15d PK10 | 7.29
17925 | 0 | LONG LIFE 336 24V 21/5W BaY15d PK10 | 10.11
18161 | 0 | LED LOAD RESISTOR 12V H1 PAIR | 34.02
18164 | 0 | LED LOAD RESISTOR 12V H4 PAIR | 34.02
18165 | 0 | LED LOAD RESISTOR 12V HB3/4 PAIR | 34.02
18168 | 0 | LED LOAD RESISTOR 12V H7 PAIR | 34.02
18171 | 0 | LED LOAD RESISTOR 12V H8/H9/H11 PAIR | 34.02
18181 | 0 | H1 CANBUS MODULE PAIR | 35.75
18184 | 0 | H4 [NAME] | 35.75
18185 | 0 | HB3 CANBUS MODULE PAIR | 33.72
18186 | 0 | HB4 CANBUS MODULE PAIR | 33.72
Spreadsheet: 747164d1631265571-wildcard-search-by-text-part-and-its-assignment-version-forum-englisch
Sheet: Hilfstab

Textteile | Zuordnung
Januar | Januar
Februar | Februar
März | März
April | April
Mai | Mai
Juni | Juni
[NAME] | [NAME]
August | August
September | September
Oktober | Oktober
November | November
[NAME] | [NAME]
Jan | Januar
Feb | Februar
Aug | August
Sep | September
Okt | Oktober
Nov | November
Dez | [NAME]
2020-01-01 00:00:00 | Januar
2020-02-01 00:00:00 | Februar
2020-03-01 00:00:00 | März
2020-04-01 00:00:00 | April
2020-05-01 00:00:00 | Mai
2020-06-01 00:00:00 | Juni
2020-07-01 00:00:00 | [NAME]
2020-08-01 00:00:00 | August
2020-09-01 00:00:00 | September
2020-10-01 00:00:00 | Oktober
2020-11-01 00:00:00 | November
2020-12-01 00:00:00 | [NAME]
2021-01-01 00:00:00 | Januar
2021-02-01 00:00:00 | Februar
2021-03-01 00:00:00 | März
2021-04-01 00:00:00 | April
2021-05-01 00:00:00 | Mai
2021-06-01 00:00:00 | Juni
2021-07-01 00:00:00 | [NAME]
2021-08-01 00:00:00 | August
2021-09-01 00:00:00 | September
2021-10-01 00:00:00 | Oktober
2021-11-01 00:00:00 | November
2021-12-01 00:00:00 | [NAME]
2022-01-01 00:00:00 | Januar
2022-02-01 00:00:00 | Februar
2022-03-01 00:00:00 | März
2022-04-01 00:00:00 | April
2022-05-01 00:00:00 | Mai
2022-06-01 00:00:00 | Juni
2022-07-01 00:00:00 | [NAME]
2022-08-01 00:00:00 | August
2022-09-01 00:00:00 | September
2022-10-01 00:00:00 | Oktober
2022-11-01 00:00:00 | November
2022-12-01 00:00:00 | [NAME]
January | Januar
February | Februar
March | März
April | April
May | Mai
June | Juni
July | [NAME]
August | August
September | September
October | Oktober
November | November
December | [NAME]
01/20 | Januar
02/20 | Februar
03/20 | März
04/20 | April
05/20 | Mai
06/20 | Juni
07/20 | [NAME]
08/20 | August
09/20 | September
10/20 | Oktober
11/20 | November
12/20 | [NAME]
01/21 | Januar
02/21 | Februar
03/21 | März
04/21 | April
05/21 | Mai
06/21 | Juni
07/21 | [NAME]
08/21 | August
09/21 | September
10/21 | Oktober
11/21 | November
12/21 | [NAME]
01/22 | Januar
02/22 | Februar
03/22 | März
04/22 | April
05/22 | Mai
06/22 | Juni
07/22 | [NAME]
08/22 | August
09/22 | September
10/22 | Oktober
11/22 | November
12/22 | [NAME]
januar | Januar
februar | Februar
märz | März
april | April
mai | Mai
juni | Juni
[NAME] | [NAME]
august | August
september | September
oktober | Oktober
november | November
dezember | [NAME]
jan | Januar
feb | Februar
aug | August
sep | September
okt | Oktober
nov | November
dez | [NAME]
january | Januar
february | Februar
march | März
april | April
may | Mai
june | Juni
july | [NAME]
august | August
september | September
october | Oktober
november | November
december | [NAME]
Januar | Januar
Februar | Februar
März | März
April | April
Mai | Mai
Juni | Juni
[NAME] | [NAME]
August | August
September | September
Oktober | Oktober
November | November
[NAME] | [NAME]
Jan | Januar
Feb | Februar
Aug | August
Sep | September
Okt | Oktober
Nov | November
Dez | [NAME]