tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 148024d1333105386-excel-2007-3-way-lookup-index-match
Sheet: charging

 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00
1 | 10 | 10 | 10 | 10 | 10
2 | 10 | 10 | 10 | 10 | 10
3 |  | 10 | 10 | 10 | 10
4 |  | 10 | 10 | 10 | 10
5 |  |  | 10 | 10 | 10
6 |  |  | 10 | 10 | 10
7 |  |  |  | 10 | 10
8 |  |  |  | 10 | 10
9 |  |  |  |  | 10
10 |  |  |  |  | 10
Spreadsheet: 736911d1623940878-create-a-table-from-another-table-based-on-critera-pq-unpivot-and-filter
Sheet: Raw Data

Site | Attribute 1 | Attribute 2 | Attribute 3 | Attribute 4 | Attribute 5 | Attribute 6
Site 1 |  |  | 0.8064516129032258
Site 2 |  |  |  | 0.6666666666666666
Site 3 |  |  |  |  | 0.5698924731182796
Site 4 | 0.01075268817204301 |  | 0.5483870967741935
Site 5 |  |  | 0.01075268817204301 | 0.5268817204301075
Site 6 | 0.02150537634408602 |  | 0.4838709677419355
Site 7 |  |  |  | 0.4838709677419355
Site 8 |  | 0.3870967741935484 |  |  | 0.4408602150537634 | 0.1397849462365591
Site 9 |  |  |  | 0.4301075268817204
Site 10 |  | 0.2903225806451613 |  |  | 0.4086021505376344
Site 11 |  |  | 0.02150537634408602 |  | 0.4086021505376344 | 0.1827956989247312
Site 12 |  |  | 0.01075268817204301 |  |  | 0.3978494623655914
Site 13 |  |  |  | 0.3870967741935484
Site 14 |  | 0.3655913978494624 | 0.04301075268817205 |  | 0.1827956989247312
Site 15 |  | 0.3440860215053764 | 0.02150537634408602 |  | 0.1397849462365591
Site 16 | 0.01075268817204301 | 0.08602150537634409 | 0.2580645161290323 |  | 0.3225806451612903 | 0.01075268817204301
Site 17 | 0.03225806451612903 | 0.3225806451612903 | 0.07526881720430108 |  | 0.2258064516129032
Site 18 | 0.3118279569892473 |  | 0.02150537634408602
Site 19 | 0.3010752688172043 |  | 0.1827956989247312
Site 20 |  |  |  | 0.3010752688172043
Site 21 |  | 0.05376344086021505 |  |  | 0.1182795698924731 | 0.2795698924731183
Site 22 | 0.2795698924731183
Site 23 |  |  | 0.05376344086021505 |  |  | 0.2688172043010753
Site 24 | 0.01075268817204301 | 0.1720430107526882 | 0.2258064516129032 |  | 0.2473118279569892
Site 25 | 0.2473118279569892 |  | 0.1075268817204301 |  | 0.04301075268817205
Site 26 |  | 0.2473118279569892 |  |  | 0.1290322580645161
Site 27 |  |  |  |  | 0.2473118279569892
Site 28 | 0.02150537634408602 |  | 0.2365591397849462
Site 29 | 0.2258064516129032 |  |  |  | 0.1075268817204301
Site 30 | 0.04301075268817205 |  | 0.1075268817204301 |  | 0.2150537634408602
Site 31 | 0.1182795698924731 |  | 0.2150537634408602
Site 32 |  |  | 0.2150537634408602
Site 33 | 0.2043010752688172 |  | 0.04301075268817205
Site 34 |  |  | 0.2043010752688172
Site 35 |  |  |  |  | 0.2043010752688172
Site 36 | 0.01075268817204301 |  | 0.1935483870967742
Site 37 | 0.01075268817204301 |  | 0.1935483870967742
Site 38 |  |  | 0.1935483870967742
Spreadsheet: 3713d5d0-f450-4fb5-be9a-d5eb6151a05b
Sheet: Table 2.4

Monthly Statistical Bulletin
2.4 Consumer price index
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Consumer price index (a)
September | 93.8 | 96.5 | 99.8 | 101.8 | 104
December | 94.3 | 96.9 | 99.8 | 102 | 104.8
March | 95.2 | 98.3 | 99.9 | 102.4 | 105.4
June | 95.8 | 99.2 | 100.4 | 102.8
Annual average | 94.8 | 97.7 | 100 | 102.3
Consumer price index quarterly change – per cent
September | 0.9687836383207582 | 0.7306889352818313 | 0.6048387096774244 | 1.394422310756971 | 1.167315175097272
December | 0.5330490405117239 | 0.4145077720207224 | 0 | 0.1964636542239662 | 0.7692307692307665
March | 0.9544008483563182 | 1.444788441692468 | 0.1002004008016089 | 0.3921568627450966 | 0.5725190839694694
June | 0.6302521008403339 | 0.9155645981688831 | 0.5005005005005003 | 0.390625
Consumer price index annual change (b) – per cent
September | 1.186623516720609 | 2.878464818763327 | 3.419689119170988 | 2.004008016032066 | 2.16110019646365
December | 2.056277056277045 | 2.757158006362692 | 2.992776057791535 | 2.204408817635284 | 2.745098039215677
March | 2.918918918918911 | 3.256302521008392 | 1.627670396744674 | 2.502502502502502 | 2.9296875
June | 3.121636167922492 | 3.549060542797511 | 1.209677419354849 | 2.39043824701195
Annual average | 2.348178137651824 | 3.059071729957807 | 2.354145342886382 | 2.299999999999991
Underlying inflation annual change (c) – per cent
September | 3.5 | 2.65 | 2.7 | 2.45 | 2.3
December | 3.55 | 2.35 | 2.75 | 2.4 | 2.55
March | 3.25 | 2.4 | 2.25 | 2.45 | 2.65
June | 3 | 2.8 | 2 | 2.45
Annual average | 3.325 | 2.55 | 2.425 | 2.4375
(a) All groups, eight capital cities index.  Base: 2011-12 = 100.0.
(b) Referred to as the 'headline' inflation rate.
(c) The average of the Reserve Bank of Australia weighted median and trimmed
mean price inflation measures. Referred to as the 'underlying' inflation rate.
Source: ABS, Consumer price index, Cat. no. 6401.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6401.0&viewtitle=Consumer%20Price%20Index,%20Australia~Dec%202007~Latest~23/01/2008&&tabname=Past%20Future%20Issues&prodno=6401.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6401.0&viewtitle=Consumer%20Price%20Index,%20Australia~Dec%202007~Latest~23/01/2008&&tabname=Past%20Future%20Issues&prodno=6401.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6401.0&viewtitle=Consumer%20Price%20Index,%20Australia~Dec%202007~Latest~23/01/2008&&tabname=Past%20Future%20Issues&prodno=6401.0&issue=Dec%202007&num=&view=&
RBA, Statistical Tables, Prices and Inflation |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-07-23 00:00:00
Spreadsheet: 79f45500-f79e-41ba-a940-eea80158acad
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6735 | 30747 | [NAME] | [NAME] | ARG | 0 | 00:22:59 | 00:00:41 | 00:35:30 | 00:00:44 | 00:08:12 | 1 | 01:08:09
6735 | 50240 | Ana | [NAME] | PAN | 0 | 00:24:32 | 00:01:06 | 00:37:38 | 00:01:18 | 00:09:24 | 2 | 01:14:01
6735 | 50276 | [NAME] | [NAME] | PAN | 0 | 00:22:57 | 00:01:08 | 00:40:32 | 00:00:59 | 00:14:14 | 3 | 01:19:54
6735 | 50241 | Natalia | [NAME] | PAN | 0 | 00:30:07 | [NAME] | 00:36:24 | 00:01:33 | 00:14:06 | 4 | 01:24:08
6735 | 50242 | [NAME] | [NAME] | PAN | 0 | 00:29:37 | 00:01:53 | 00:40:34 | 00:01:08 | 00:11:44 | 5 | 01:24:59
Spreadsheet: 762713d1641760102-copy-1-column-to-another-based-on-text-in-a-different-cell-2022-pre-call-planning-calender-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTE: | ***insert appropriate data (in columns V to Y) from weekly calendar(lines 5 - 19) based on "yes" being typed in appropriate cell in line 20. "Yes" can only be entered in 1 cell at a time, not multiple cells at a time.
Week #1 |  |  |  | January |  |  |  |  |  |  |  |  |  |  |  |  | 2022
 | 2022-01-03 00:00:00
Sgmnt | Monday | Type | Time | Sgmnt | Tuesday | Type | Time | Sgmnt | Wednesday | Type | Time | Sgmnt | Thursday | Type | Time | Sgmnt | Friday | Type | Time |  | Time | Type | Sgmnt | Meeting | Comments
1 | Village at Cook Springs | FU | 10:30:00 | 1 | [NAME] | CI | 10:15:00 |  | Fast Start Meeting | Trng | 12:00:00 |  | Fast Start Meeting | Trng | 08:00:00 | non | [NAME] | Call | 08:00:00
1 | Meadowview | FU | 11:00:00 | non | [NAME] | Call |  |  |  |  |  |  |  |  |  | non | [NAME] | Call | 11:30:00
 | Pre-Call |  |  |  | Pre-Call |  |  |  | Pre-Call |  |  |  | Pre-Call |  |  | Yes | Pre-Call
Spreadsheet: 120073d1314965526-adding-values-based-on-both-month-and-text-criteria-saving-rev1
Sheet: April

Category | Date | Description | Credit | Debit | Running Balance
Holiday 2011 | 2011-04-29 00:00:00 | OVERSEAS TRANSACTION FEE |  | -1.25 | 4433.96
Holiday 2011 | 2011-04-29 00:00:00 | CARD PAYMENT TO USCUSTOMS ESTA APPL PMT,14.00 USD, RATE 0.60/Â£ ON 27-04-2011 (INTERNATIONA |  | -8.72 | 4435.21
Salary | 2011-04-28 00:00:00 | BANK GIRO CREDIT REF ICEGRADE LTD, ICEGRADE LTD | 1935.24 |  | 4443.93
Social | 2011-04-26 00:00:00 | CARD PAYMENT TO THE RED LION,50.00 GBP ON 23-04-2011 |  | -50 | 2508.69
Misc | 2011-04-26 00:00:00 | CARD PAYMENT TO BOOTS,WOKING,4.00 GBP ON 23-04-2011 |  | -4 | 2558.69
Misc | 2011-04-26 00:00:00 | CARD PAYMENT TO WAITROSE 181 ON 2011-04-23 |  | -22 | 2562.69
Social | 2011-04-25 00:00:00 | CASH WITHDRAWAL AT BARCLAYS BANK PLC ATM REIGATE, REIGATE, 60.00 GBP, ON 24-04-2011 |  | -60 | 2584.69
Social | 2011-04-23 00:00:00 | CASH WITHDRAWAL AT SANTANDER ATM WOKING, WOKING, 50.00 GBP, ON 23-04-2011 |  | -50 | 2644.69
Income | 2011-04-23 00:00:00 | CHEQUE PAID IN AT WOKING 6 PC | 150 |  | 2694.69
Misc | 2011-04-13 00:00:00 | CARD PAYMENT TO SERENATA FLOWERS L,39.99 GBP ON 11-04-2011 |  | -39.99 | 2544.69
Food | 2011-04-13 00:00:00 | CARD PAYMENT TO W M MORRISONS,10.28 GBP ON 11-04-2011 |  | -10.28 | 2584.68
Food | 2011-04-12 00:00:00 | CARD PAYMENT TO SACAT SAINSBURYS,35.38 GBP ON 09-04-2011 |  | -35.38 | 2594.96
Income | 2011-04-07 00:00:00 | INTEREST PAID AFTER TAX 0.19 DEDUCTED | 0.78 |  | 2630.34
Phone | 2011-04-07 00:00:00 | DIRECT DEBIT PAYMENT TO ORANGE REF 55498282/630564652, MANDATE NO 0002 |  | -24.5 | 2629.56
Clothes | 2011-04-06 00:00:00 | CARD PAYMENT TO HOUSE OF FRASER,175.00 GBP ON 04-04-2011 |  | -175 | 2654.06
Clothes | 2011-04-06 00:00:00 | CARD PAYMENT TO RIVER ISLAND 129,14.99 GBP ON 04-04-2011 |  | -14.99 | 2829.06
Misc | 2011-04-06 00:00:00 | CARD PAYMENT TO CARPARK MACHINE,9.00 GBP ON 04-04-2011 |  | -9 | 2844.05
Petrol | 2011-04-05 00:00:00 | CARD PAYMENT TO SAINSBURYS PETROL,51.95 GBP ON 02-04-2011 |  | -51.95 | 2853.05
Misc | 2011-04-05 00:00:00 | CARD PAYMENT TO HOMEBASE LTD 050,9.99 GBP ON 02-04-2011 |  | -9.99 | 2905
Social | 2011-04-04 00:00:00 | CASH WITHDRAWAL AT CO-OPERATIVE BANK PLC ATM COOP HIGH ST, H, WOKING, 100.00 GBP, ON 04-04 |  | -100 | 2914.99
Gym | 2011-04-04 00:00:00 | DIRECT DEBIT PAYMENT TO WOKING BC REF 510353, MANDATE NO 0003 |  | -38 | 3014.99
 | 2011-04-04 00:00:00 | CASH WITHDRAWAL AT CO-OPERATIVE BANK PLC ATM COOP HIGH ST, H, WOKING, 200.00 GBP, ON 03-04 |  |  | 3052.99 | 200
Social | 2011-04-02 00:00:00 | CASH WITHDRAWAL AT TESCO PERSONAL FINANCE ATM TESCO GUILDFORD, GUILDFORD, 30.00 GBP, ON 02 |  | -30 | 3252.99
Food | 2011-04-02 00:00:00 | CARD PAYMENT TO SAINSBURY'S S/MKT,7.14 GBP ON 31-03-2011 |  | -7.14 | 3282.99
Rent | 2011-04-01 00:00:00 | REGULAR TRANSFER PAYMENT TO ACCOUNT 090133 29153404, MANDATE NO 1 |  | -100 | 3290.13
Food | 2011-04-01 00:00:00 | CARD PAYMENT TO TESCO STORES SACAT,2.00 GBP ON 30-03-2011 |  | -2 | 3390.13
Spreadsheet: 698131d1601776624-criteria-based-ranking-test-39-ans
Sheet: Test

 |  |  |  |  |  |  |  | 2020-04-15 00:00:00
Item | Price | Category | Date | Except | Rank | Desired Rank
CTR_01 | 3.5 | Urgent | 2020-04-15 00:00:00 | [NAME] |  | 1
[NAME] | 3.2 | Not Urgent | 2020-04-05 00:00:00 |  |  |  |  |  |  | * Rank 1 is to be given for XXX & YYY items (in col. E), then ranking is to be done of only urgent item based on there price and date
CTR_03 | 3.44 | Not Urgent | 2020-04-06 00:00:00
CTR_08 | 3.5 | Urgent | 2020-05-11 00:00:00 |  |  | 2
CTR_18 | 3.44 | Urgent | 2020-04-21 00:00:00 | [NAME] |  | 1
CTR_06 | 3.41 | Urgent | 2020-04-21 00:00:00 |  |  | 3
CTR_07 | 3.2 | Urgent | 2020-04-06 00:00:00
CTR_17 | 3.2 | Urgent | 2020-04-20 00:00:00 | YYY |  | 1
CTR_09 | 3 | Not Urgent | 2020-04-12 00:00:00
CTR_10 | 2.1 | Not Urgent | 2020-04-06 00:00:00 | YYY |  | 1
CTR_11 | 3.4 | Not Urgent | 2020-05-14 00:00:00
CTR_12 | 3.2 | Not Urgent | 2020-04-15 00:00:00
CTR_13 | 3.44 | Not Urgent | 2020-04-16 00:00:00 | YYY |  | 1
CTR_14 | 3 | Not Urgent | 2020-04-17 00:00:00
CTR_15 | 2.1 | Not Urgent | 2020-04-18 00:00:00
CTR_16 | 3.4 | Not Urgent | 2020-04-19 00:00:00
CTR_04 | 3 | Urgent | 2020-04-06 00:00:00
CTR_19 | 3 | Urgent | 2020-04-06 00:00:00
CTR_05 | 2.1 | Urgent | 2020-04-23 00:00:00 |  |  | 4
CTR_20 | 2.1 | Urgent | 2020-04-23 00:00:00 |  |  | 4
Spreadsheet: 330348d1404726216-formula-to-return-column-header-formula-query
Sheet: Sheet1

 | Sydeny | China | Delhi | [NAME] | Newyork | output
T-111 | 1 | 1 | 1 |  |  | Sydney, China, Delhi
[NAME] |  | 1 | 1 | 1 |  | China, Delhi, [NAME]
T-113 | 1 |  |  |  |  | Sydney
T-114 |  | 1 | 1 |  | 1 | China, Delhi, [NAME]
T-115
T-116 | 1 | 1 |  | 1 |  | Sydney, China, [NAME]
T-117 |  | 1 |  |  |  | China
T-118 |  | 1 |  |  |  | China
T-119 |  |  |  | 1 |  | [NAME]
T-120 | 1 |  |  |  |  | Sydney
Spreadsheet: 833571d1687088848-offset-countif-index-match-no-value-for-searchable-drop-down-list-offset-countif-no-value
Sheet: LISTE MPs

BASES |  |  |  | born
 | MPs
 | MPs.colonneB | MPs.colonneC
 | MP | Column1
 | 2 ACETYL THIAZOLE
 | 5 METHYL 2 PHENYL 2 HEXENAL = COCAL
 | 5 METHYL 2 PHENYL 2 HEXENAL 1%
 | 5 METHYL 2 PHENYL 2 HEXENAL 10%
 | 5 METHYL FURFURAL
 | ACCORD CERISE
 | ACETAL R
 | ACETAL R 10%
 | ACETAL R 10% IPM
 | ACETANISOLE
 | ACETANISOLE 1 %
 | ACETANISOLE 10 %
 | ACETANISOLE 10 % IPM
 | ACETATE 2 METHYL BUTYL
 | ACETATE 2 METHYL BUTYL 10 %
 | ACETATE ALPHA TERPENYLE (MPs)
 | ACETATE ANISYLE
 | ACETATE ANISYLE 10 %
 | ACETATE BENZYLE
 | ACETATE BENZYLE 10 % IPM
 | ACETATE BENZYLE 10%
 | ACETATE BETA TERPENYLE (MPs)
 | ACETATE BORNYLE (MPs)
 | ACETATE BULNESYL (MPs)
 | ACETATE BULNESYL + EUGENOL (MPs)
 | ACETATE CARVYL CIS (MPs)
 | ACETATE CARYOPHYLLENE
 | ACETATE CARYOPHYLLENE 10%
 | ACETATE CEDRYLE
 | ACETATE CEDRYLE 10 %
 | ACETATE CEDRYLE 10% IPM
 | ACETATE CINNAMYLE
 | ACETATE CINNAMYLE 1%
 | ACETATE CINNAMYLE 10%
 | ACETATE CIS 3 HEXENYLE
 | ACETATE CIS 3 HEXENYLE 1 % IPM
 | ACETATE CIS 3 HEXENYLE 1%
 | ACETATE CIS 3 HEXENYLE 10%
 | ACETATE CIS 3 HEXENYLE 10% IPM
 | ACETATE CITRONELLYLE
 | ACETATE CITRONELLYLE 1 %
 | ACETATE CITRONELLYLE 10%
 | ACETATE CITRONELLYLE 10% IPM
 | ACETATE CYCLO HEXYL ETHYLE
 | ACETATE CYCLO HEXYL ETHYLE 1 %
 | ACETATE DIHYDRO MYRCENYLE
 | ACETATE DIHYDROCARVYL TRANS (MPs)
 | ACETATE DMBC
 | ACETATE DMBC 1%
 | ACETATE DMBC 10 % IPM
 | ACETATE DMBC 10%
 | ACETATE ETHYL LINALYLE
 | ACETATE ETHYLE
 | ACETATE ETHYLE 10%
 | ACETATE EUGENYL (MPs)
 | ACETATE FARNESYL (MPs)
 | ACETATE FENCHYLE
 | ACETATE FENCHYLE 10 %
 | ACETATE GAMMA TERPENYLE (MPs)
 | ACETATE GAYOL
 | ACETATE GAYOL 10%
 | ACETATE GERANYLE 98
 | ACETATE GERANYLE 98 10%
 | ACETATE GERANYLE 98 10% IPM
 | [NAME]
 | ACETATE HEXYLE
 | ACETATE HEXYLE 1 % IPM
 | ACETATE HEXYLE 10 %
 | ACETATE HEXYLE 10% IPM
 | ACETATE ISOAMYLE
 | ACETATE ISOAMYLE 1%
 | ACETATE ISOAMYLE 10 %
 | ACETATE ISOAMYLE 10% IPM
 | ACETATE ISOBORNYLE
 | ACETATE ISOBORNYLE 1 %
 | ACETATE ISOBORNYLE 1 % IPM
 | ACETATE ISOBORNYLE 10 %
 | ACETATE ISOBUTYLE
 | ACETATE ISONONYLE
 | ACETATE ISONONYLE 10 %
 | ACETATE LAVANDULYLE (MPs)
 | ACETATE LINALYLE
 | ACETATE LINALYLE 10 %
 | ACETATE LINALYLE 10 % IPM
 | ACETATE MENTHANYLE
 | ACETATE MENTHYLE
 | ACETATE MENTHYLE 10 %
 | ACETATE NERYLE
 | ACETATE NERYLE 1 % IPM
 | ACETATE NERYLE 1%
 | ACETATE NERYLE 10 % IPM
 | ACETATE NERYLE 10%
 | ACETATE NOPYLE
 | ACETATE OCTYLE
 | ACETATE OCTYLE 1%
 | ACETATE OCTYLE 10 %
 | ACETATE OCTYLE 10 % IPM
 | ACETATE P.A.
 | ACETATE PA 10%
 | ACETATE PARACRESYLE
 | ACETATE PARACRESYLE 1%
 | ACETATE PARACRESYLE 10%
 | ACETATE PARACRESYLE 10% IPM
 | ACETATE PHENYL ETHYLE
 | ACETATE PHENYL ETHYLE 1%
Spreadsheet: 704320d1605499719-index-and-match-returns-partially-incorrect-match-after-sorted-index_match_partially-matched_vlookup-100-matched_after_sort
Sheet: STATIC_Source

 |  | No. | Personnel | Origin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  | 2020-01-01 00:00:00 | 2020-01-02 00:00:00 | 2020-01-03 00:00:00 | 2020-01-04 00:00:00 | 2020-01-05 00:00:00 | 2020-01-06 00:00:00 | 2020-01-07 00:00:00 | 2020-01-08 00:00:00 | 2020-01-09 00:00:00 | 2020-01-10 00:00:00 | 2020-01-11 00:00:00 | 2020-01-12 00:00:00 |  |  |  |  |  | 2020-01-18 00:00:00 | 2020-01-19 00:00:00 | 2020-01-20 00:00:00 | 2020-01-21 00:00:00 | 2020-01-22 00:00:00 | 2020-01-23 00:00:00 | 2020-01-24 00:00:00 | 2020-01-25 00:00:00 | 2020-01-26 00:00:00 | 2020-01-27 00:00:00 | 2020-01-28 00:00:00 | 2020-01-29 00:00:00 | 2020-01-30 00:00:00 | 2020-01-31 00:00:00
 |  | 1 | Company | PG | 12
 |  | 2 | STAFF 1 | PG |  |  |  |  |  |  |  |  |  | 30
 |  | 3 | STAFF 2 | PG |  |  |  |  |  |  |  |  |  | 40
 |  | 4 | STAFF 3 | PG |  |  |  |  |  |  |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  | 13 | 10 | 17
 |  | 5 | STAFF 4 | PG |  |  |  |  |  |  |  |  |  | 60 |  |  |  |  |  |  |  |  |  |  |  | 16 | 22 | 22
 |  | 6 | STAFF 5 | PG |  |  |  |  |  |  |  |  |  | 70 |  |  |  |  |  |  |  |  |  |  |  | 14 | 23 | 30
 |  | 7 | STAFF 6 | PG |  | 50 |  |  |  |  |  |  |  | 80 |  |  |  |  |  |  |  |  |  |  |  | 11 | 15 | 30
 |  | 8 | STAFF 7 | PG |  |  |  |  |  |  |  |  |  | 90 |  |  |  |  |  |  |  |  |  |  |  | 22 | 13 | 29
 |  | 9 | STAFF 8 | PG |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  | 30 | 26 | 19
 |  | 10 | STAFF 9 | JB |  |  |  |  |  |  |  |  |  | 110 |  |  |  |  |  |  |  |  |  |  |  | 12 | 24 | 14
 |  | 11 | STAFF 10 | JB |  |  |  |  |  |  |  |  |  | 120 |  |  | 50 | 50 | 50 | 50 | 50 |  |  |  |  | 20 | 19 | 12
 |  | 12 | STAFF 11 | JB |  |  |  |  |  |  |  |  |  | 130 |  |  |  |  |  |  |  |  |  |  |  | 18 | 30 | 26
Spreadsheet: 697645d1601464423-vlookup-on-another-sheet-not-working-as-expected-vlookup-not-working
Sheet: Results

User Name | Title | Type | Duration | Status | Pass | Start Date | End Date | Actions | Helper
[NAME] | Essentials â€“ Safeguarding and Child Protection | Course | 45 | Not Started
[NAME] | Health and Safety in Education | Course | 60 | Completed | Passed | 2019-12-17 00:00:00 | 2019-12-18 00:00:00
[NAME] | Safeguarding and Child Protection | Course | 120 | Not Started
[NAME] | Safer Recruitment | Course | 60 | Completed | Passed | 2019-12-17 00:00:00 | 2019-12-17 00:00:00
[NAME] | Essentials â€“ Safeguarding and Child Protection | Course | 45 | Not Started |  | 2019-12-10 00:00:00 | 2019-12-10 00:00:00
[NAME] | Health and Safety in Education | Course | 60 | Completed | Passed | 2019-12-10 00:00:00 | 2019-12-10 00:00:00
[NAME] | Safeguarding and Child Protection | Course | 120 | Completed | Passed | 2019-12-10 00:00:00 | 2020-01-10 00:00:00
Spreadsheet: 83930d1283963801-finding-a-date-closest-to-the-target-date-test
Sheet: Sheet1

2011-02-17 00:00:00
2010-10-21 00:00:00 | 2010-10-28 00:00:00 | 2010-11-04 00:00:00 | 2010-11-11 00:00:00 | 2010-11-18 00:00:00
2010-12-02 00:00:00 | 2010-12-09 00:00:00 | 2010-12-16 00:00:00 | 2011-01-06 00:00:00 | 2011-01-13 00:00:00
2011-01-20 00:00:00 | 2011-01-27 00:00:00 | 2011-02-03 00:00:00 | 2011-02-10 00:00:00 | 2011-02-17 00:00:00
2011-02-24 00:00:00 | 2011-03-03 00:00:00 | 2011-03-10 00:00:00 | 2011-03-17 00:00:00 | 2011-03-31 00:00:00
2011-04-07 00:00:00 | 2011-04-14 00:00:00 | 2011-04-21 00:00:00 | 2011-04-28 00:00:00 | 2011-05-05 00:00:00
2011-05-12 00:00:00 | 2011-05-19 00:00:00 | 2011-05-26 00:00:00 | 2011-06-02 00:00:00 | 2011-06-09 00:00:00
2011-06-16 00:00:00 | 2011-06-23 00:00:00 | 2011-06-30 00:00:00 | 2011-07-14 00:00:00 | 2011-07-21 00:00:00
2011-07-28 00:00:00 | 2011-08-04 00:00:00 | 2011-08-11 00:00:00 | 2011-08-18 00:00:00 | 2011-08-25 00:00:00
2011-09-01 00:00:00 | 2011-09-08 00:00:00 | 2011-09-15 00:00:00 | 2011-09-22 00:00:00 | 2011-09-29 00:00:00
2011-10-06 00:00:00 | 2011-10-13 00:00:00 | 2011-10-20 00:00:00 | 2011-10-27 00:00:00 | 2011-11-03 00:00:00
2011-11-10 00:00:00 | 2011-11-17 00:00:00 | 2011-12-01 00:00:00 | 2011-12-08 00:00:00 | 2011-12-15 00:00:00
2012-01-05 00:00:00 | 2012-01-12 00:00:00 | 2012-01-19 00:00:00 | 2012-01-26 00:00:00 | 2012-02-02 00:00:00
2012-02-09 00:00:00 | 2012-02-16 00:00:00 | 2012-02-23 00:00:00 | 2012-03-01 00:00:00 | 2012-03-08 00:00:00
2012-03-15 00:00:00 | 2012-03-29 00:00:00 | 45/12 | 2012-04-12 00:00:00 | 2012-04-19 00:00:00
Spreadsheet: 180535d1347633965-concat-cells-based-on-date-range-tigeravatar-example-for-damianwars
Sheet: Sheet1

Date | Value |  | Non-Array Formula |  |  | [NAME]
2001-12-01 00:00:00 | 1
2001-12-01 00:00:00 | 2 |  | Date | Value |  | Date | Value
2002-12-01 00:00:00 | 3 |  | 2001-12-01 00:00:00 | 1,2 |  | 2001-12-01 00:00:00 | 1,2
2003-12-01 00:00:00 | 4 |  | 2002-12-01 00:00:00 | 3 |  | 2002-12-01 00:00:00 | 3
2003-12-01 00:00:00 | 5 |  | 2003-12-01 00:00:00 | 4,5 |  | 2003-12-01 00:00:00 | 4,5
Spreadsheet: 679216d1590259958-counting-multiple-sequences-within-one-formula-book1-1-
Sheet: Sheet1

 |  |  |  |  |  |  | 5 |  |  | 5 |  |  | 5
 |  | 1 |  |  | 1 | 2 |  |  | 2 |  |  | 1
 |  | 1 |  |  |  | 2 |  |  | 2 |  |  | 2
 |  | 2 |  |  |  | 1 |  |  | 1 |  |  | 1
 |  | 2 |  |  |  | 1 |  |  | 2 |  |  | 2
 |  | 2 |  |  |  | 1 |  |  | 1 |  |  | 1
 |  | 1 | example1 |  |  | 2 | example1 |  | 2 | example3 |  | 1 | example4
 |  | 1 |  |  |  | 2 |  |  | 2 |  |  | 2
 |  | 2 |  |  |  | 1 |  |  | 1 |  |  | 1
 |  | 2 |  |  |  | 1 |  |  | 2 |  |  | 2
 |  | 2 |  |  |  | 1 |  |  | 1 |  |  | 1
 |  | 1 |  |  |  | 2 |  |  | 2 |  |  | 1
 |  | 1 |  |  |  | 2 |  |  | 2 |  |  | 2
Spreadsheet: 601991f6-b5bf-4c34-84fe-be889e0441c9
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
TBMP | Test | TBMP | Mycobacteria Probe Ident Solid | Mycobacteria Probe Ident |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87150 |  |  |  |  | Rochester
TBMP | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 238365d1369497061-help-me-pivot-tables-sumif-vlook-up-excel-questions
Sheet: Questions

SUMIFS | Complete the table below from the 'PG Google' data
 | Using a pivot table & the sum formula
 |  | Office Accidents | Construction Accidents | Work Slips | Factory Accidents | Work Accident | Military Accidents | Both Work Campaigns | Total  (all campaigns)
 | 2011-01-01 00:00:00
 | 2011-01-02 00:00:00
 | 2011-01-03 00:00:00
 | 2011-01-04 00:00:00
 | 2011-01-05 00:00:00
 | 2011-01-06 00:00:00
FILTERS | Use a filter in the 'aspect calls' tab to find out how many calls Aspect had on the 2nd Jan, from campaigns which contained the term 'emergency' that lasted over 3 minutes
 | Call date | Campaign | Call length (minutes)
 | 02.01.2011 | Electrician Emergency | 3.5
TEXT TO COLUMNS OR LEFT/RIGHT, SUMIF & COUNTIF | Complete the table below from the 'Rush Data' tab
 | Then put this data into a line graph
 | Now change the 'sales' to a column graph
 | Use a SumIf Formula
 |  | Total revenue | Quantity
 | TIG
 | KER
 | RED
 | AME
VLOOKUP | Complete the table below from the 'Staff' tab
 | Use a vlookup formula
 |  | Holidays | Bonus
 | Stacy
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 81653d1281776974-data-collation-find-out-the-values-in-a-column-updated-data-collation-find-out-the-values-in-a-column-updated-datacollation-new
Sheet: Sheet1

 |  |  | Result | Result | Result (A) | Result (A) | If value of 'Result (A)' is repeated in the "Deal #' | Result (B) | Result (B) | If value of 'Result (A)' is repeated in the "Deal #'
Deal # | Package ID (A) | Package ID (B) |  |  | Available | Not Listed | Repetition Time | Available | Not Listed | Repetition Time
35454 | 36544 | 36544
34646 | 54541 | 32657
54451 | 565656 | 31186
4485 | 34570 | 45412-1658
54541 | 31155-4588 | 34646
36544 | 54148-1524 | 38879
346896 | 39977 | 37775
46546-1264 | 38641
56745-1518 | 32564
45412-1658 | 65124
54148-1524 | 34576
349063 | 30021
46546-1265 | 34552
56745-1519 | 34552
45412-1659 | 54155-4625
37775 | 34645-5610
34515
38497
31451
31186
36518
34579
34576
34573
34552
34567
34564
34561
34558
34555
34552
34552
34552
34552
34573
34573
38879
34845
30021
300025
38641
35456
34645-5610
54249-8520
31155-4588
36621
362145
32564
32657