tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 167003d1341861706-vlookup-from-set-ranges-one-below-the-other-book1-1-
Sheet: sheet1

bob | 12 | 2
 | aaa | 12
 |  |  |  |  |  |  | match |  | aaa | bbb | [NAME]
 | bbb | 13 |  |  |  |  |  | bob
 |  |  |  |  |  |  |  | [NAME]
 | [NAME] | 45 |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Sofi
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
[NAME] |  |  |  |  |  |  |  | xx
 | aaa | 675 |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 | bbb | 65 |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 | [NAME] | 75 |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
[NAME] |  |  |  |  |  |  |  | xx
 | aaa | 23 |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 | bbb | 56 |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 | [NAME] | 89 |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
Sofi
 | aaa | 65
 | bbb | 65
 | [NAME] | 75
[NAME]
 | aaa | 75
 | bbb | 23
 | [NAME] | 23
Spreadsheet: 866397d1713319697-multiple-checks-across-text-values-for-condition-to-be-returned-4-possible-outcomes-caculation-assistance
Sheet: Sheet1

Calculated values from previous data entry across 5 areas |  |  |  |  | Evaluation of values '= IF (****<0, "Improved", IF(X2>0, "Deteriorated",  "Unchanged")) |  |  |  |  | Need help to determine this column formula
-1 | 0 | 0 | 1 | 1 | Improved | Unchanged | Unchanged | Deteriorated | Deteriorated | MIXED
2 | 2 | 1 | 1 | 2 | Deteriorated | Deteriorated | Deteriorated | Deteriorated | Deteriorated | Deteriorated
0 | 0 | -1 | 0 | -1 | Unchanged | Unchanged | Improved | Unchanged | Improved | MIXED
-1 | -1 | -2 | -1 | 0 | Improved | Improved | Improved | Improved | Unchanged | MIXED
-1 | 1 | 4 | -1 | 0 | Improved | Deteriorated | Deteriorated | Improved | Unchanged | MIXED
-1 | 0 | 4 | 0 | 0 | Improved | Unchanged | Deteriorated | Unchanged | Unchanged | MIXED
Spreadsheet: 24539d1215009512-continue-searching-a-table-with-vlookup-despite-finding-one-match-ceconfigoutput
Sheet: Output Query

Account Manager | IFE Name | Avionics Name | Payloads Name | Confirm | Region | Begin Day | End Day | Customer | [NAME]
Ed Ives | [NAME] | [NAME] |  | 1 | Americas | 2008-07-02 00:00:00 | 2008-07-04 00:00:00 | CQT
 |  | [NAME] |  | 1 | _ | 2008-07-02 00:00:00 | 2008-07-04 00:00:00
[NAME] |  |  |  | 0 | Europe | 2008-07-07 00:00:00 | 2008-07-10 00:00:00 | AAL
Spreadsheet: 21778d1209694113-lookup-and-if-help-resi-weekly-update
Sheet: Monday

 |  |  | Monday
 |  |  | Contract Number | Comments |  |  |  |  |  | TVP done
 |  | 1 | 173054 |  |  |  |  |  |  | y | 1
 |  | 1 | 173052 |  |  |  |  |  |  | y | 1
 |  | 1 | 4576 | waiting for fax c/x forgot to sign 2nd sheet |  |  |  |  |  |  | 0
 |  | 1 | 173027 | cannot get a hold of c/x morning and evening |  |  |  |  |  |  | 0
 |  | 1 | 173051 | evening tpv |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
Back to worksheet |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 | Total | 5 |  |  |  |  |  |  |  |  | 2 | Total
Spreadsheet: 767873d1644685652-having-trouble-coming-up-with-combination-lookup-value-based-on-rank-result-2021-auto-update-test
Sheet: FISH-OFF

FISH OFF AT LAKE CUMBERLAND
October 16th and 17th, 2021
ANGLER | FISH CT. | WGTS. LBs | BIG BASS | PLACED
Spreadsheet: 874824d1721328722-auto-fill-an-occurrence-of-numbers-from-2-columns-in-a-new-sheet-ref-occurance-sample
Sheet: Occur result

 |  |  |  |  | on sheet 1
Ref fro |  | Ref to.
1 |  | 1 |  |  | k9 = 1, so 1 in A8
1 |  | 2 |  |  | L9 = 2, so 1 in A9 and 2 in C9 for the next two rows
1 |  | 2
2 |  | 3
2 |  | 3
2 |  | 3
2 |  | 3
3 |  | 4
3 |  | 4
3 |  | 4
3 |  | 4
4 |  | 4
4 |  | 4
4 |  | 6
4 |  | 6
Spreadsheet: 779924d1652190229-fuzzy-matching-text-list-with-variations-of-same-text-fuzzy-match-example
Sheet: Sheet2

List to be fuzzy matched to Master | Result column |  | Master List
Bombay Science and Technology University, Phuna, India | e.g. "Match" or "Yes" etc |  | Bombay University of Science and Technology, Phuna, India
Bombay University of Science and Technology, Phuna, India |  |  | School of Craft and Technology, Toronto University
Bombay University of Science and  Technology, India |  |  | Columbus University
Bombay University of Science and Technology, Phuna, India. |  |  | Rhode Island University
Bombay University of Science & Technology |  |  | Connetticut College of Fashion
School of Craft & Technology, The University of Toronto |  |  | DRAP University
School of Craft and Technology, Toronto University
Columbus University
Columbus University
Columbus University
Rhode Island University
Rhode Island Uni.
Connetticut College of Fashion
Connetticut Fashion College
DRAP [NAME], (Univeristy of DRAP)
Spreadsheet: 745875d1630334436-index-match-small-countifs-returning-duplicated-results-examplecostdeviation
Sheet: Feuil1

Key | Cost Deviation | Fix Versions |  |  | TOP 5 Cost Devation
1 | 0 | V1 |  |  |  | OK
2 | 10 | V2 |  |  |  | OK
3 | 5 | V1 |  |  |  | Repeated
4 | 5 | V2 |  |  |  | Wrong, #10 has also cost deviation = 10 and has been ignored
5 | 1 | V1 |  |  |  | Repeated
6 | 3 | V1
7 | 8 | V1
8 | 1 | V1
9 | 15 | V1
10 | 10 | V1
11 | 2 | V1
12 | 4 | V1
13 | 8 | V1
Spreadsheet: 160669d1339163251-conditional-sum-with-linked-conditions-in-different-tables-copy-of-conditionalsum
Sheet: Result

[NAME] Input2!A:A | Job \ Week number > | 1 | 2 | 3 | 4 | 5
Driver | Architect | 0 | 1 | 0 | 0 | 0
Driver | Driver | 2 | 2 | 1 | 0 | 0
Architect | Salesperson | 0 | 1 | 2 | 0 | 0
Salesperson
Salesperson
Spreadsheet: 49288d1248607777-specific-data-collection-chimero
Sheet: Pivot

Month | (All)
 | Values
Row Labels | Count of Qty | Sum of Total Cost
1 | 3 | 18540
ITEM A | 3 | 18540
2 | 3 | 152650
ITEM B | 3 | 152650
3 | 3 | 201910
ITEM C | 3 | 201910
4 | 3 | 32233.5
ITEM D | 3 | 32233.5
5 | 3 | 133858.12
ITEM E | 3 | 133858.12
6 | 3 | 16728
ITEM F | 3 | 16728
7 | 3 | 383813.9697599999
ITEM G | 3 | 383813.9697599999
8 | 3 | 92720
ITEM I | 3 | 92720
9 | 3 | 30691.1
ITEM H | 3 | 30691.1
(blank) |  | 0
(blank) |  | 0
Grand Total | 27 | 1063144.68976
Spreadsheet: 116920d1312305760-selective-columns-farthingstone
Sheet: lf

Loom. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 37cab6f0-5f87-48d3-9f0c-0cc60c70c8de
Sheet: satpol pp

RENCANA UMUM PENGADAAN BARANG/JASA PEMERINTAH
PA/KPA |  | : Ir. Mariani, MP
K/L/D/I |  | : -
SATKER/SKPD |  | : Satuan Polisi Pamong Praja [NAME]
PPK |  | : Drs. Mahdiansyah
TAHUN ANGGARAN |  | : 2013
NO | KEGIATAN |  | SUB KEGIATAN/ | NAMA PAKET PEKERJAAN | VOLUME | LOKASI PEKERJAAN | RENCANA PENGANGGARAN |  |  | CARA PENGADAAN | PERKIRAAN WAKTU MULAI PELAKSANAAN PENGADAAN | WAKTU | KET.
 |  |  | PEKERJAAN |  |  | (PROVINSI/KAB/KOTA) | PERKIRAAN | [NAME] | RENCANA |  |  | PELAKSANAAN
 |  |  |  |  |  |  | BIAYA (Rp.-) | (APBN/APBD) | PEMBIAYAAN
1 | 2 |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
1 | Belanja Modal |  | Pengadaan | Brankas | 1 | Kab. [NAME] | 3800000 | APBD | - | [NAME] | Maret | 1 Bulan | -
2 | Belanja Modal |  | Pengadaan | [NAME]/PC | 2 | Kab. [NAME] | 13000000 | APBD | - | [NAME] | Februari | 1 Bulan | -
3 | Belanja Modal |  | Pengadaan | Printer | 2 | Kab. [NAME] | 5090000 | APBD | - | [NAME] | Februari | 1 Bulan | -
4 | Belanja Modal |  | Pengadaan | Meja [NAME] | 4 | Kab. [NAME] | 6700000 | APBD | - | [NAME] | Maret | 1 Bulan | -
5 | Belanja Modal |  | Pengadaan | Kursi [NAME] | 4 | Kab. [NAME] | 3500000 | APBD | - | [NAME] | Maret | 1 Bulan | -
6 | Belanja Barang dan Jasa |  | Pengadaan | [NAME].Pol PP | 152 | Kab. [NAME] | 30400000 | APBD | - | [NAME] | April | 1 Bulan | -
7 | Belanja Barang dan Jasa |  | Pengadaan | [NAME] | 152 | Kab. [NAME] | 51100000 | APBD | - | [NAME] | Juni | 1 Bulan | -
8 | Belanja Barang dan Jasa |  | Pengadaan | Atribut Pakaian dan Kelengkapannya | 116 | Kab. [NAME] | 75455000 | APBD | - | [NAME] | Agustus | 1 Bulan | -
 |  |  |  |  |  |  |  |  |  | Batulicin, 14 Januari 2013
 |  |  |  |  |  |  |  |  |  | Plt. [NAME] Pamong Praja
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Ir. Mariani, MP
 |  |  |  |  |  |  |  |  |  | Pembina TK.I
 |  |  |  |  |  |  |  |  |  | NIP. 19630814 199003 2 002
Spreadsheet: 130992d1322680141-excel-2007-cant-pass-variables-properly-tigeravatar-example-for-grizzlypete44
Sheet: Sheet1

HeaderA | HeaderB | HeaderC
Data A01 | Data B01 | Data C01
Data A02 | Data B02 | Data C02
Data A03 | Data B03 | Data C03
Data A04 | Data B04 | Data C04
Data A05 | Data B05 | Data C05
Data A06 | Data B06 | Data C06
Data A07 | Data B07 | Data C07
Data A08 | Data B08 | Data C08
Data A09 | Data B09 | Data C09
Data A10 | Data B10 | Data C10
Data A11 | Data B11 | Data C11
Data A12 | Data B12 | Data C12
Data A13 | Data B13 | Data C13
Data A14 | Data B14 | Data C14
Data A15 | Data B15 | Data C15
Data A16 | Data B16 | Data C16
Data A17 | Data B17 | Data C17
Data A18 | Data B18 | Data C18
Data A19 | Data B19 | Data C19
Data A20 | Data B20 | Data C20
Spreadsheet: 848244d1699005099-3rd-syntax-issue-sf_080141
Sheet: Master

 | Sort2-Order | Sort1-Order
 | #Oman flower.
 | Sunflower | Poland
 | Begonia | Mexico
 | African lily | Portugal
 | Kerria | Bolivia
 | Magnolia | India
 | Polemonium | Chile
 | [NAME] | Romania
 | Forget-me-not | Western Sahara
 | [NAME] | Peru
 | Balloon Flower
 | Jasmine
 | Actaea
Spreadsheet: 0bfa174d-6231-4cb6-a593-94303eadfe09
Sheet: Sheet1

Last name (Apellido) | Unnamed: 1 | Unnamed: 2 | First Name (Nombre) | Unnamed: 4 | Unnamed: 5 | Birthdate (month/day/year)                        Fecha de nacimiento (mes/dai/año) | Unnamed: 7
Oral Testing
Date | Pre/Post |  | Test Number |  | Score | SPL | Test Admin.
Written Testing
Date | Pre/Post | Form (B-C-D) | Reading Score (RAW) | Writing Score (RAW) | Total Score | SPL | Test Admin.
Placement
Qtr/Year | Class:   M/W/F    T/Th/F    S    A.M.     P.M. |  |  | Student Hrs in Class       _____________
 |  |  |  | Total Class Hrs            _________________
 |  |  |  | Successfully completed 75% or higher:  YES  /  NO
Qtr/Year | Class:   M/W/F    T/Th/F    S    A.M.     P.M. |  |  | Student Hrs in Class       _____________
 |  |  |  | Total Class Hrs            _________________
 |  |  |  | Successfully completed 75% or higher:  YES  /  NO
Qtr/Year | Class:   M/W/F    T/Th/F    S    A.M.     P.M. |  |  | Student Hrs in Class       _____________
 |  |  |  | Total Class Hrs            _________________
 |  |  |  | Successfully completed 75% or higher:  YES  /  NO
Qtr/Year | Class:   M/W/F    T/Th/F    S    A.M.     P.M. |  |  | Student Hrs in Class       _____________
 |  |  |  | Total Class Hrs            _________________
 |  |  |  | Successfully completed 75% or higher:  YES  /  NO
Qtr/Year | Class:   M/W/F    T/Th/F    S    A.M.     P.M. |  |  | Student Hrs in Class       _____________
 |  |  |  | Total Class Hrs            _________________
 |  |  |  | Successfully complete 75% or higher:  YES  /  NO
Qtr/Year | Class:   M/W/F     T/Th/F    S    A.M.    P.M. |  |  | Student Hrs in Class       _____________
 |  |  |  | Total Class Hrs            _________________
 |  |  |  | Successfully completed 75% or higher:  YES  /  NO
Qtr/Year | Class:   M/W/F    T/Th/F    S    A.M.     P.M. |  |  | Student Hrs in Class       _____________
 |  |  |  | Total Class Hrs            _________________
 |  |  |  | Successfully completed 75% or higher:  YES  /  NO
Qtr/Year | Class:   M/W/F    T/Th/F    S    A.M.     P.M. |  |  | Student Hrs in Class       _____________
 |  |  |  | Total Class Hrs            _________________
 |  |  |  | Successfully completed 75% or higher:  YES  /  NO
Spreadsheet: 694159d1599398523-formula-to-extract-a-value-based-on-a-client-code-match-and-that-fits-within-a-date-range-example-file
Sheet: Sheet1

Student ID | Funder | School | Service Codes | Code | Client Name | Term Start Date | Term End Date | SA Units | Unit Rate | Used Units | Balance
BNE5936 | DoE | Canterbury | Biology |  | Twinkle | 2020-03-01 00:00:00 | 2021-02-28 00:00:00 | 6810 | 10 | 4500
BNE5936 | DoE | Canterbury | Biology |  | Twinkle | 2019-05-05 00:00:00 | 2020-02-29 00:00:00 | 6810 | 10 | 5067
BNE5936 | DoE | Canterbury | Biology |  | Twinkle | 2018-05-19 00:00:00 | 2019-05-04 00:00:00 | 6271 | 10 | 4509
BPV5568 | DoE | Canterbury | Biology |  | Coyote | 2020-03-30 00:00:00 | 2021-03-29 00:00:00 | 2654 | 10 | 1567
BPV5568 | DoE | Canterbury | Biology |  | Coyote | 2019-11-11 00:00:00 | 2020-03-29 00:00:00 | 2654 | 10 | 1689
GFC4323 | DoE | Canterbury | Biology |  | [NAME] | 2019-10-22 00:00:00 | 21/20/2020 | 2465 | 10 | 1985
[NAME] | MoE | St. Marys | Maths |  | [NAME] | 2020-07-27 00:00:00 | 2020-12-06 00:00:00 | 247 | 31.23 | 45.5
[NAME] | MoE | St. Marys | Literacy |  | [NAME] | 2020-07-27 00:00:00 | 2020-12-06 00:00:00 | 95 | 31.23 | 45
[NAME] | MoE | St. Marys | Science |  | [NAME] | 2019-12-09 00:00:00 | 2020-12-06 00:00:00 | 975 | 31.23 | 45.5
NEX0060 | DoE | Canterbury | Biology |  | Goofy | 2019-02-02 00:00:00 | 2020-02-06 00:00:00 | 480 | 10 | 346
NEX0060 | DoE | Canterbury | Biology |  | Goofy | 2019-09-02 00:00:00 | 2019-02-01 00:00:00 | 480 | 10 | 220
RTL9261 | MoE | [NAME] | Science |  | Roadrunner | 2020-05-18 00:00:00 | 2021-05-16 00:00:00 | 812 | 10 | 456
VJE2063 | DoE | Canterbury | Biology |  | Popeye | 2020-03-27 00:00:00 | 2021-03-26 00:00:00 | 1554 | 10 | 1001
VJE2063 | DoE | Canterbury | Biology |  | Popeye | 2019-03-27 00:00:00 | 2020-03-26 00:00:00 | 1554 | 10 | 1560
Spreadsheet: 723644d1615818263-if-isnumber-formula-update-cells-with-character-depending-on-dates-holiday-forms-2021
Sheet: Colleague 12

HOLIDAY FORM 2021
NAME: |  |  |  | 2021 BANK HOLIDAY DATES | TAKEN Y/N (IF NO ADD LIEU DAY TO TABLE)
2021 HOLIDAY ENTITLEMENT |  |  |  | 01/01/2020 (New Years Day) | Y
To be completed - |  |  |  | 02/04/2020 (Good Friday)
2020 ENTITLEMENT |  | 25 |  | 05/04/2020 (Easter Monday)
CARRIED OVER FROM 2020 |  | 8 |  | 03/05/2020 (May Bank Hol)
LIEU DAYS |  | 1 |  | 31/05/2020 (May Bank Hol)
BOUGHT HOLIDAYS FOR 2021 |  | 0 |  | 30/08/2020 (Aug Bank Hol)
OTHER ENTITLEMENT (PLEASE ADD DETAILS) |  | 0 |  | 27/12/2020 (Xmas Day)
Reason: |  |  |  | 28/12/2020 (Xmas BH Day)
TOTAL FOR 2021:
HOLIDAY BOOKING PROCESS
1) | Send a request for holiday dates to your line manager
2) | Once approval is gained, issue a meeting invite to your line manager and direct team so they are aware of holiday dates
2) | Update this holiday form yourself and re-save on the network once approved
FROM | TO | DAYS | DAYS | AUTHORISED | DATE OF APPROVAL
 | (INCLUSIVE) | TAKEN | LEFT | BY
Date (dd/mm/yyyy) | Date (dd/mm/yyyy) | 0 |  | Add line manager name | Add date (dd/mm/yyyy)
26/11/2021 | 2021-10-12 00:00:00 | 11
Spreadsheet: kate_symes__18660__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-16 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160
 | 2001-02-15 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 348.8 | 1693 | 398.23 | 784
 | 2001-02-14 00:00:00 |  | 327.05 | 15664 | 314.82 | 3928 | 479.05 | 452 | 472.12 | 165
 | 2001-02-13 00:00:00 |  | 335.68 | 13424 | 322.6 | 4728 | 386.38 | 1053 | 330 | 0
 | 2001-02-12 00:00:00 |  | 302.64 | 12624 | 279.2 | 4528 | 271.84 | 1346 | 324.32 | 544
 | 2001-02-11 00:00:00 |  | 285 | 0 | 270 | 0 | 312.37 | 316 | 326.04 | 96 |  | 278.81 | 12600
 | 2001-02-10 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 322.06 | 790 | 309.3 | 328
 | 2001-02-09 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 341.87 | 3340 | 307.19 | 1050
 | 2001-02-08 00:00:00 |  | 381.43 | 15120 | 316.79 | 3376 | 341.12 | 2521 | 320.97 | 373
 | 2001-02-07 00:00:00 |  | 274.49 | 8688 | 253.14 | 4024 | 294.97 | 2143 | 251.02 | 216
 | 2001-02-06 00:00:00 |  | 213.71 | 10784 | 195.79 | 4096 | 259.92 | 63 | 196.16 | 307
 | 2001-02-05 00:00:00 |  | 200.43 | 11824 | 196.63 | 3968 | 204.52 | 1904 | 179.61 | 727
 | 2001-02-04 00:00:00 |  | 200 | 0 | 185 | 0 | 181.95 | 1513 | 175.11 | 1100 |  | 196.25 | 10704
 | 2001-02-03 00:00:00 |  | 222.8 | 15824 | 195.9 | 7648 | 185 | 35 | 199.94 | 233
 | 2001-02-02 00:00:00 |  | 222.8 | 15824 | 195.9 | 7648 | 203.95 | 380 | 200 | 48
 | 2001-02-01 00:00:00 |  | 355.71 | 7984 | 306.05 | 3728 | 255.73 | 1202 | 198.09 | 315
 | 2001-01-31 00:00:00 |  | 409.15 | 12656 | 342.56 | 3280 | 313.68 | 3766 | 275 | 70
 | 2001-01-30 00:00:00 |  | 468.99 | 11456 | 403.48 | 2872 | 383.47 | 304 | 351 | 25
 | 2001-01-29 00:00:00 |  | 420.48 | 19824 | 407.62 | 3832 | 383.33 | 4070 | 304.86 | 1442
 | 2001-01-28 00:00:00 |  | 450 | 800 | 350 | 0 | 488.38 | 355 | 460.46 | 416 |  | 408.68 | 12240
 | 2001-01-27 00:00:00 |  | 294.85 | 19024 | 254.41 | 4032 | 456.54 | 845 | 457.01 | 236
 | 2001-01-26 00:00:00 |  | 295.64 | 17424 | 254.65 | 3832 | 369.4 | 402 | 350 | 75
 | 2001-01-25 00:00:00 |  | 319.38 | 15024 | 295.88 | 1272 | 296.66 | 437 | 234.61 | 965
 | 2001-01-24 00:00:00 |  | 307.59 | 18224 | 261.91 | 2872 | 290.03 | 291 | 291.18 | 807
 | 2001-01-23 00:00:00 |  | 329.11 | 18624 | 254.24 | 4712 | 309.54 | 1107 | 305 | 200
 | 2001-01-22 00:00:00 |  | 393.64 | 26784 | 333.06 | 3312 | 351.61 | 465 | 314.65 | 1500
 | 2001-01-21 00:00:00 |  | 300 | 800 | 337.5 | 0 | 367 | 625 | 318.16 | 435 |  | 335.88 | 8736
 | 2001-01-20 00:00:00 |  | 559.4 | 25088 | 411.6 | 8344 | 362.89 | 291 | 286.58 | 300
 | 2001-01-19 00:00:00 |  | 559.4 | 25088 | 411.6 | 8344 | 376.11 | 836 | 283.47 | 546
 | 2001-01-18 00:00:00 |  | 481.44 | 21424 | 392.14 | 5112 | 454.07 | 393 | 294.21 | 380
 | 2001-01-17 00:00:00 |  | 272.66 | 29824 | 248.16 | 6312 | 428.17 | 196 | 285.3 | 495
 |  |  |  |  |  | ..
Spreadsheet: 859699d1707992575-count-if-it-is-not-working-correctly-p1-aligw
Sheet: Total_Absence

Name | LATENESS | NO SHOW | OTHER LEAVE | PAID VACATION | SICK | SUSPENSION | UNAUTHORIZED ABSENCE
[NAME]
[NAME]
Anna Carenina
Ariana Grande
Bontekoe Lars
[NAME]
[NAME]
Captain America
[NAME]
Channing Tatum
[NAME]
[NAME]
Dr. [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Mariah [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Novak Djokovic
[NAME]
Pewdiepie
[NAME]
[NAME]
Rihanna
Rio Ferdinand
[NAME]
Rodrygo
Ronaldinho
[NAME]
[NAME]
Sandra Bullock
[NAME]
[NAME]
[NAME]
[NAME]
Willy Wonka
[NAME]
total
Spreadsheet: 768497d1645001401-trying-to-look-up-and-filter-data-example
Sheet: K

 | Id numeric | Product | Brew number | Sampling point | Analysis | Component name | Result text
998518 | 998518 | KROK050 | 998395 |  | AE | AE | 1.83
998518 | 998518 | KROK050 | 998395 |  | COL | COL | 9.1
998518 | 998518 | KROK050 | 998395 |  | PH | PH | 4.29
998518 | 998518 | KROK050 | 998395 |  | CO2 | CO2 | 4.35
998518 | 998518 | KROK050 | 998395 |  | N2 | N2 | 5
998518 | 998518 | KROK050 | 998395 |  | VISUAL | VISUAL | PASS
998519 | 998519 | KROK050 | 99395 |  | AE | AE | 1.8
998519 | 998519 | KROK050 | 99395 |  | COL | COL | 9
998519 | 998519 | KROK050 | 99395 |  | PH | PH | 4.33
998519 | 998519 | KROK050 | 99395 |  | CO2 | CO2 | 4.38
998519 | 998519 | KROK050 | 99395 |  | N2 | N2 | 9
998519 | 998519 | KROK0100 | 99395 |  | VISUAL | VISUAL | PASS
998520 | 998520 | KROK100 | 998695 |  | COL | COL | 8.9
998520 | 998520 | KROK100 | 998695 |  | PH | PH | 4.3
998520 | 998520 | KROK100 | 998695 |  | VISUAL | VISUAL | PASS
998521 | 998521 | KROK050 | 998395 |  | CO2 | CO2 | 4.39
998521 | 998521 | KROK050 | 998395 |  | N2 | N2 | 9
998521 | 998521 | KROK050 | 998395 |  | BITT | ABS | 0.35
998521 | 998521 | KROK050 | 998395 |  | BITT | BITT | 17.5
998679 | 998679 | REDK050 | 998652 |  | AE | AE | 2.11
998679 | 998679 | REDK050 | 998652 |  | COL | COL | 7
998679 | 998679 | REDK050 | 998652 |  | PH | PH | 4.25
998679 | 998679 | REDK050 | 998652 |  | CO2 | CO2 | 4.2
998679 | 998679 | REDK050 | 998652 |  | N2 | N2 | 6
998679 | 998679 | REDK050 | 998652 |  | VISUAL | VISUAL | PASS
998680 | 998680 | REDK050 | 998652 |  | AE | AE | 2.1
998680 | 998680 | REDK050 | 998652 |  | COL | COL | 6.9
998680 | 998680 | REDK050 | 998652 |  | PH | PH | 4.24
998680 | 998680 | REDK050 | 998652 |  | CO2 | CO2 | 4.3
998680 | 998680 | REDK050 | 998652 |  | N2 | N2 | 6
998680 | 998680 | REDK050 | 998652 |  | VISUAL | VISUAL | PASS
Spreadsheet: 71108d1271841708-compare-two-column-and-highlight-comparelists
Sheet: Sheet1

Name | Age | Area |  |  | Name | Age | Area |  | Code used in the cells
[NAME] | 22 | 2c | Yes - found on row  (2) |  | [NAME] | 22 | 2c | Yes - found on row  (2)
[NAME] | 33 | 1a | Yes - found on row  (3) |  | [NAME] | 33 | 1a | Yes - found on row  (3)
[NAME] | 55 | 2d | Yes - found on row  (4) |  | [NAME] | 55 | 2d | Yes - found on row  (4)
[NAME] | 43 | 3d | No |  | [NAME] | 29 | 3d | Yes - found on row  (6)
[NAME] | 29 | 3d | Yes - found on row  (5) |  | [NAME] | 29 | 3d | Yes - found on row  (7)
[NAME] | 29 | 3d | Yes - found on row  (6) |  | Anne | 45 | 4a | Yes - found on row  (8)
Anne | 45 | 4a | Yes - found on row  (7) |  |  |  |  | No