tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 748144d1631912872-hard-time-figuring-out-this-problem-involving-match-and-index-wright_excel_ch05_ps2_musiclessons
Sheet: LessonData

Lesson Data
Date | [NAME] | Student | Teacher | [NAME] | Skill Level | Total Fee
2018-01-07 00:00:00 | 000018 | [NAME] | [NAME] | 0.5
2018-01-08 00:00:00 | 000001 | [NAME] | [NAME] | 1.5
2018-01-12 00:00:00 | 000033 | [NAME] | [NAME] | 0.5
2018-01-16 00:00:00 | 000010 | [NAME] | [NAME] | 1.5
2018-01-17 00:00:00 | 000018 | [NAME] | Anne | 2
2018-01-19 00:00:00 | 000028 | [NAME] | [NAME] | 1
2018-01-21 00:00:00 | 000022 | [NAME] | Debbie | 1
2018-02-03 00:00:00 | 000008 | Violet Ward | Debbie | 1
2018-02-14 00:00:00 | 000008 | Violet Ward | [NAME] | 0.5
2018-02-16 00:00:00 | 000001 | [NAME] | Mark | 1
2018-02-20 00:00:00 | 000016 | [NAME] | [NAME] | 1
2018-03-10 00:00:00 | 000002 | [NAME] | Mark | 2
2018-04-02 00:00:00 | 000006 | [NAME] | Debbie | 1.5
2018-04-15 00:00:00 | 000022 | [NAME] | [NAME] | 1
2018-04-16 00:00:00 | 000006 | [NAME] | [NAME] | 2
2018-04-19 00:00:00 | 000018 | [NAME] | [NAME] | 2
2018-04-20 00:00:00 | 000033 | [NAME] | [NAME] | 1.5
2018-05-06 00:00:00 | 000008 | Violet Ward | Anne | 1
2018-05-07 00:00:00 | 000018 | [NAME] | Anne | 2
2018-05-07 00:00:00 | 000025 | [NAME] | Mark | 0.5
2018-05-08 00:00:00 | 000008 | Violet Ward | Debbie | 2
2018-05-09 00:00:00 | 000028 | [NAME] | [NAME] | 2
2018-05-12 00:00:00 | 000016 | [NAME] | Anne | 1
2018-05-15 00:00:00 | 000016 | [NAME] | Mark | 1.5
2018-05-17 00:00:00 | 000001 | [NAME] | Anne | 2
2018-05-21 00:00:00 | 000010 | [NAME] | Mark | 0.5
2018-05-29 00:00:00 | 000001 | [NAME] | Debbie | 1
Spreadsheet: 0f1f7833-0537-44d1-a158-126a5c6b18b8
Sheet: International classification

ملحق رقم 1: [NAME] لأسباب الوفاة
Annex 1: International Classification of Causes of Death
Serial no. | Cause of Death | سبب الوفاة | [NAME]
1 | Certain infectious and parasitic diseases | أمراض معدية وطفيلية معينة | 1
2 | [NAME] | الأورام | 2
3 | Endocrine, nutritional and metabolic diseases | أمراض الغدد الصماء [NAME] والتمثيل الغذائي | 3
4 | Disorders of the blood and blood-forming organs and certain disorders involving the immune mechanism | إضطرابات الدم وأعضاء تكوين [NAME] معينة تشمل اضطرابات المناعة | 4
5 | Mental and behavioural disorders | [NAME] والسلوكية | 5
6 | Diseases of the nervous system | أمراض الجهاز العقلي وأعضاء الحس | 6
7 | Diseases of the circulatory system | أمراض الجهاز الدوري الدموي | 7
8 | Diseases of the respiratory system | أمراض الجهاز التنفسي | 8
9 | Diseases of the digestive system | أمراض الجهاز الهضمي | 9
10 | Diseases of the genitourinary system | أمراض الجهاز التناسلي البولي | 10
11 | Pregnancy, child birth and the puerperium | [NAME] | 11
12 | Diseases of the skin and subcutaneous tissue | أمراض الجلد [NAME] الجلد | 12
13 | Diseases of the musculoskeletal system and connective tissue | أمراض الجهاز الهيكلي العظمي [NAME] | 13
14 | Congenital malformations, deformations and chromosomal abnormalities | [NAME] | 14
15 | Certain conditions originating in the perinental period | أسباب معينة لحالات المرض والوفاة حول موعد الولادة | 15
16 | Symptoms, signs and abnormal clinical and laboratory findings, not elsewhere classified | أمراض وحالات غير معينة وغير [NAME] في مكان آخر | 16
17 | Injury, poisoning and certain other consequences of external causes | الإصابات والتسمم ونتائج أخرى معينة لأسباب خارجية | 17
18 | Codes for special purposes | حالات غير مشخصة | 18
19 | Diseases of the eye and adnexa | أمراض النظر | 19
20 | Diseases of the ear and mastoid process | أمراض السمع | 20
21 | External causes of morbidity and mortality | لأسباب [NAME] للمرض والوفاة | 21
22 | Factors influencing health status and contact with health services | [NAME] الصحي واتصال بالخدمات الصحية | 22
Spreadsheet: 100434d1298815400-formula-to-merge-two-worksheets-example
Sheet: llo_studentsdemo

id | myNewID
4046588 |  | <--- '[NAME]' will appear in B2 when done
4255856
4333770
4335977
4340344
4319626
4046588
4064430
4278140
4325955
2992239
4311739
4297574
4308273
4354489
4359889
4265930
4307699
4323292
4354322
4341925
915133
3086265
4331712
4340612
4321557
4251737
1461309
4128446
4332447
4176052
4353615
4243869
4275513
4316872
4090302
4322719
4314225
4323157
4349106
4336430
4196463
4340109
4318664
1084852
4311612
3867715
4307676
4099620
4230879
4323326
4302429
4347054
4349595
4341054
4352370
4301164
4345506
4335555
4331586
4269546
4248560
4284961
4193237
4314809
4287559
4299496
4323672
4058657
4349047
4272009
4295686
4096216
3006358
4301644
4324231
4328516
3704349
4307888
4176298
4350636
Spreadsheet: 734385d1622133067-new-and-repeat-customer-new-and-rep-customers
Sheet: Sheet1

Qtr | Cust Name | New/Rep
2020Q1 | [NAME]
2020Q2 | [NAME]
2020Q3 | Margie Purtee
2020Q4 | [NAME]
2020Q1 | Bell Ishii
2020Q2 | [NAME]
2020Q3 | [NAME]
2020Q4 | [NAME]
2020Q1 | Seema Friedman
2020Q2 | Mose Tienda
2020Q3 | [NAME]
2020Q4 | [NAME]
2020Q1 | Elva Shum
2020Q2 | [NAME]
2020Q3 | Bernardine Condict
2020Q4 | [NAME]
2020Q1 | Brook Due
2020Q2 | Tiffany Burmeister
2020Q3 | [NAME]
2020Q4 | [NAME]
2020Q1 | [NAME]
2020Q2 | [NAME]
2020Q3 | Margie Purtee
2020Q4 | [NAME]
2020Q1 | Bell Ishii
2020Q2 | [NAME]
2020Q3 | [NAME]
2020Q4 | [NAME]
2020Q4 | Seema Friedman
2020Q4 | Mose Tienda
2020Q4 | [NAME]
2020Q4 | [NAME]
2020Q4 | Elva Shum
2020Q4 | [NAME]
2020Q4 | Bernardine Condict
2020Q4 | [NAME]
2020Q4 | Brook Due
2020Q4 | Tiffany Burmeister
2020Q4 | [NAME]
2020Q4 | [NAME]
Spreadsheet: 206598d1358237559-how-to-create-a-functional-drop-down-menu-to-update-expiry-dates-timestamp-plus-adding-months-1
Sheet: Members

2013-01-15 00:00:00
 |  |  |  |  |  |  |  | 2013-01-21 18:04:18
Member ID | First Name | Last Name | Membership Type | Start Date | [NAME]
1 | [NAME] | Kimuyu | 1 Week | 2013-01-14 18:04:18 | 2013-01-21 18:04:18 |  |  | 1 Week
2 | Rhys | McDonald |  |  |  |  |  | 1 Month
3 | [NAME] | Sharp |  |  |  |  |  | 3 Months
4 | Adam | Simnott |  |  |  |  |  | 6 Months
5 | Mark | Finch |  |  |  |  |  | 12 Months
6 | [NAME] | [NAME] | 12 Months | 2013-01-14 18:05:01 | 2013-02-14 00:00:00
7 | [NAME] | [NAME]
8 | Vishal | [NAME]
9 | [NAME] | Edwards
10 | [NAME] | Bradley | 1 Month | 2013-01-15 08:40:41 | 2013-02-15 00:00:00
11 | [NAME] | Knight
12 | [NAME] | Palmer
13 | Kristen | Duffin | 3 Months | 2013-01-15 08:40:47 | 2013-04-15 00:00:00
14 | [NAME] | Burrows
15 | [NAME] | Watson
16 | [NAME] | [NAME] | 6 Months | 2013-01-15 09:27:06 | 2013-07-15 00:00:00
17 | [NAME] | Illson
18 | [NAME] | Murphy
19 | [NAME] | Whitehead
20 | [NAME] | Bone
21 | [NAME] | Lampard
22 | [NAME] | Craven
23 | [NAME] | [NAME]
24 | Aby | [NAME]
25 | Micheal | Beeby
26 | [NAME] | [NAME]
27 | [NAME] | Wroughton
28 | Peri | Theodosiou
29 | [NAME] | Coulsons
30 | Shaun | Guthrit
31 | Mark | Bailey
32 | [NAME] | Betts
33 | [NAME] | [NAME]
34 | [NAME] | [NAME]
35 | [NAME] | Thorpe
36 | [NAME] | Bhamra
37 | Arran | Coffey
38 | [NAME] | Smith
39 | George | draper
40 | [NAME] | Wilson
41 | Adrian | Mulligan
42 | [NAME] | [NAME]
43 | Brett | Mitchell
44 | [NAME] | Gibbons
45 | Callum | Smith
46 | Callum | [NAME]
47 | [NAME] | [NAME]
48 | [NAME] | Griffiths
49 | [NAME] | McAdam
50 | [NAME] | Would
51 | Jon | [NAME]
52 | [NAME] | Orridge
53 | Adam | [NAME]
54 | Niall | Gibbons
55 | [NAME] | [NAME]
56 | [NAME] | Mclocklin
57 | [NAME] | Ward
58 | [NAME] | Thorpe
59 | [NAME] | Durner
Spreadsheet: 697812d1601553650-solved-help-analyzing-data-in-a-table-shared-expense-who-owes-whom-splitting-costs-tactics-pq
Sheet: Balance

Date | Credit | Debit | Amount | Project
2017-04-10 00:00:00 | Adam | [NAME] | 150 | Proj-8
2017-04-10 00:00:00 | Adam | [NAME] | 180 | Proj-8
2017-04-10 00:00:00 | Adam | [NAME] | 105 | Proj-10
2017-06-02 00:00:00 | Adam | [NAME] | 280 | Proj-1
2017-06-04 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2017-06-10 00:00:00 | Adam | [NAME] | 320 | Proj-5
2017-06-10 00:00:00 | Adam | [NAME] | 1000 | Proj-5
2017-07-10 00:00:00 | Adam | [NAME] | 2000 | Proj-5
2018-02-09 00:00:00 | [NAME] | Ellen | 400 | Proj-6
2018-02-13 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2018-04-11 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2018-04-15 00:00:00 | [NAME] | [NAME] | 1000 | Proj-5
2018-04-15 00:00:00 | [NAME] | Adam | 500 | Proj-5
2018-04-24 00:00:00 | [NAME] | Adam | 495 | Proj-5
2018-06-28 00:00:00 | [NAME] | [NAME] | 1000 | Proj-5
2018-07-09 00:00:00 | [NAME] | [NAME] | 350 | Proj-5
2018-07-12 00:00:00 | [NAME] | Adam | 495 | Proj-5
2018-07-12 00:00:00 | Adam | [NAME] | 350 | Proj-5
2018-08-02 00:00:00 | Emma | Adam | 920 | Proj-10
2018-08-04 00:00:00 | [NAME] | Emily | 250 | Proj-1
2018-08-12 00:00:00 | Ellen | Adam | 500 | Proj-6
2018-08-15 00:00:00 | Adam | [NAME] | 2000 | Proj-5
2018-08-26 00:00:00 | [NAME] | Adam | 500 | Proj-5
2018-09-27 00:00:00 | [NAME] | Adam | 1170 | Proj-5
2018-10-05 00:00:00 | Emma | Adam | 550 | Proj-5
2018-10-31 00:00:00 | [NAME] | Adam | 1500 | Proj-5
2018-11-07 00:00:00 | Adam | Emily | 185 | Proj-6
2018-11-17 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2018-11-23 00:00:00 | Ellen | Adam | 1500 | Proj-6
2018-12-07 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2019-01-09 00:00:00 | [NAME] | Ellen | 1700 | Proj-2
2019-02-05 00:00:00 | Emma | Ellen | 3400 | Proj-7
2019-02-15 00:00:00 | Adam | [NAME] | 2000 | Proj-5
2019-03-15 00:00:00 | [NAME] | Ellen | 280 | Proj-6
2019-03-15 00:00:00 | [NAME] | Emily | 360 | Proj-6
2019-04-20 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2019-08-15 00:00:00 | Ellen | Emily | 700 | Proj-8
2019-08-19 00:00:00 | Ellen | [NAME] | 500 | Proj-8
2019-08-19 00:00:00 | Ellen | Emily | 300 | Proj-8
2019-11-05 00:00:00 | Ellen | [NAME] | 400 | Proj-3
2019-11-13 00:00:00 | Emily | [NAME] | 650 | Proj-9
2019-11-20 00:00:00 | Adam | [NAME] | 300 | Proj-9
2019-11-20 00:00:00 | Adam | [NAME] | 450 | Proj-9
2019-11-24 00:00:00 | [NAME] | Emily | 650 | Proj-4
2019-11-25 00:00:00 | Ellen | [NAME] | 300 | Proj-9
2019-11-28 00:00:00 | Ellen | [NAME] | 400 | Proj-9
2019-12-23 00:00:00 | Ellen | [NAME] | 150 | Proj-1
2020-04-22 00:00:00 | Adam | [NAME] | 400 | Proj-3
2020-04-26 00:00:00 | Adam | [NAME] | 250 | Proj-3
2020-04-30 00:00:00 | Adam | [NAME] | 200 | Proj-3
2020-12-31 00:00:00 | Adam | [NAME] | 3960 | Proj-11
2020-12-31 00:00:00 | [NAME] | Emma | 2210 | Proj-11
2020-12-31 00:00:00 | Emily | Emma | 1795 | Proj-11
2020-12-31 00:00:00 | [NAME] | [NAME] | 1205 | Proj-11
2020-12-31 00:00:00 | Ellen | [NAME] | 795 | Proj-11
2020-12-31 00:00:00 | [NAME] | Emma | 730 | Proj-11
2020-12-31 00:00:00 | Ellen | Emma | 135 | Proj-11
2020-12-31 00:00:00 | Ellen | [NAME] | 100 | Proj-11
Spreadsheet: 273421d1382709528-solved-if-than-giving-points-to-corresponding-cells-acording-to-lowest-values-etc-product-table
Sheet: OBJEKT

PRODUCT | NUMBER OF PRODUCTS ON SHELF | PERCENTAGE OF  TAKEN SHELVES | POINTS | SPACE TAKEN BY PACKAGES IN STOREHOUSE (m²) | PERCENTAGE OF TAKEN SPACE IN STOREHOUSE | P      O        I        N       T        S | HAS CONTENT  I. | P      O        I        N       T        S | PRICE | P      O        I        N       T        S | HAS CONTENT  II. | P       O        I        N        T        S | HAS CONTENT III. | P      O        I        N       T        S | T     O     T      A     L
TOTAL
PRODUCT A | 4 |  | 0.5 | 1.5 |  | 0.5 | YES | 1 | 6.79 | 0 | [NAME],bla | 0.5 | bla, no, yes | 1
PRODUCT B | 13 |  | 1 | 0 |  | 0 | NO | 0 | 6.79 | 0 | NOT YET BUT… | 0.5 |  | 0
PRODUCT C | 10 |  | 1 | 4 |  | 1 | NOT YET | 0 | 5.29 | 0 |  | 0 | YES | 1
PRODUCT D | 0 |  | 0 | 0.1 |  | 0.5 |  | 0 | 2.99 | 2 | YES | 0.5 |  | 0
PRODUCT E | 42 |  | 1.5 | 1 |  | 0.5 | YES | 1 | 2.99 | 2 |  | 0 | No | 1
PRODUCT F | 2 |  | 0.5 | 0 |  | 0 | YES | 1 | 4.49 | 0 |  | 0 | yes | 0
PRODUCT G | 7 |  | 0.5 | 7 |  | 1.5 |  | 0 | 4.45 | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  | OR
How to give points: | EXPLANATION |  |  |  |  |  | POINTS
PERCENTAGE OF  TAKEN SHELVES                      (D column) | 1 - 10% |  |  |  |  |  | 0.5 |  | 6.79 | 0
 | 10 - 50% |  |  |  |  |  | 1 |  | 6.79 | 0
 | 50 - 100% |  |  |  |  |  | 1.5 |  | 5.29 | 0
PERCENTAGE OF TAKEN SPACE IN STOREHOUSE  (G column) | 1 - 25% |  |  |  |  |  | 0.5 |  | 3.49 | 1
 | 25 - 50% |  |  |  |  |  | 1 |  | 3.99 | 0
 | 50 - 100% |  |  |  |  |  | 1.5 |  | 4.49 | 0
HAS [NAME] (I column) | 'YES'' |  |  |  |  |  | 1 |  | 4.45 | 0
 | ANYTHING EXCEPT  ''YES'' |  |  |  |  |  | 0
PRICE  (K column) | LOWEST PRICE THAT IS LOWER BY LESS THAN 1 OF NEXT  LOWEST PRICE |  |  |  |  |  | 1 |  | OR
 | LOWEST PRICE THAT IS LOWER BY MORE THAN 1 OF NEXT  LOWEST PRICE |  |  |  |  |  | 2
HAS CONTENT II.   (M column) | WHATEVER IS WRITTEN |  |  |  |  |  | 0.5
 | IF IT'S EMPTY |  |  |  |  |  | 0
HAS CONTENT III.   (O column) | WHATEVER IS WRITTEN |  |  |  |  |  | 1
 | IF IT'S EMPTY |  |  |  |  |  | 0 |  | 6.79 | 0
 |  |  |  |  |  |  |  |  | 6.79 | 0
 |  |  |  |  |  |  |  |  | 5.29 | 0
 |  |  |  |  |  |  |  |  | 3.99 | 1
 |  |  |  |  |  |  |  |  | 3.99 | 1
 |  |  |  |  |  |  |  |  | 4.49 | 0
 |  |  |  |  |  |  |  |  | 4.45 | 0
 |  |  |  |  |  |  |  |  | OR
 |  |  |  |  |  |  |  |  | 2.98 | 2
 |  |  |  |  |  |  |  |  | 6.79 | 0
 |  |  |  |  |  |  |  |  | 5.29 | 0
 |  |  |  |  |  |  |  |  | 3.99 | 0
 |  |  |  |  |  |  |  |  | 3.99 | 0
 |  |  |  |  |  |  |  |  | 4.49 | 0
 |  |  |  |  |  |  |  |  | 4.45 | 0
Spreadsheet: 730963d1620070924-formula-to-search-compare-data-from-multiple-sheets-mappe2_test_engl-1
Sheet: Register

All_Fem_Catalog No. | Description | All_Tib_Catalog No. | Description | All_Inl_Catalog No. | Description
6307-00-020
Spreadsheet: 92937d1292449110-return-a-value-from-the-same-row-that-match-2-conditions-blast_podo_forum
Sheet: sheet2

P-GSP1 |  | PRSP2 | ID % | P-SSP3 | ID % | P-SSP7 | ID % | P-SSP9 | ID % | P-SSP10 | ID % | SYN5 | ID %
ORF1 | PGSP1_00001
[NAME] | PGSP1_00002
ORF3 | PGSP1_00003
ORF4 | PGSP1_00004
ORF5 | PGSP1_00005
[NAME] | PGSP1_00006
ORF7 | PGSP1_00007
ORF8 | PGSP1_00008
ORF9 | PGSP1_00009
ORF10 | PGSP1_00010
ORF11 | PGSP1_00011
ORF12 | PGSP1_00012
ORF13 | PGSP1_00013
ORF14 | PGSP1_00014
ORF15 | PGSP1_00015
ORF16 | PGSP1_00016
ORF17 | PGSP1_00017
ORF18 | PGSP1_00018
ORF19 | PGSP1_00019
ORF20 | PGSP1_00020
ORF21 | PGSP1_00021
ORF22 | PGSP1_00022
ORF23 | PGSP1_00023
ORF24 | PGSP1_00024 |  |  |  |  |  |  | x | 1
ORF25 | PGSP1_00025 |  |  |  |  |  |  | x | 2
ORF26 | PGSP1_00026 |  |  |  |  |  |  | x | 1
ORF27 | PGSP1_00027 |  |  |  |  |  |  | x | 2
[NAME] | PGSP1_00028 |  |  |  |  |  |  | x | 0.01
ORF29 | PGSP1_00029 |  |  |  |  |  |  | y | 2
ORF30 | PGSP1_00030 |  |  |  |  |  |  | y | 1
ORF31 | PGSP1_00031 |  |  |  |  |  |  | y | 2
ORF32 | PGSP1_00032 |  |  |  |  |  |  | y | 1
ORF33 | PGSP1_00033 |  |  |  |  |  |  | y | 2
ORF34 | PGSP1_00034 |  |  |  |  |  |  | yy | 1
ORF35 | PGSP1_00035
ORF36 | PGSP1_00036
ORF37 | PGSP1_00037
ORF38 | PGSP1_00038
ORF39 | PGSP1_00039
ORF40 | PGSP1_00040
ORF41 | PGSP1_00041
ORF42 | PGSP1_00042
ORF43 | PGSP1_00043
ORF44 | PGSP1_00044
ORF45 | PGSP1_00045
ORF46 | PGSP1_00046
ORF47 | PGSP1_00047
ORF48 | PGSP1_00048
ORF49 | PGSP1_00049
ORF50 | PGSP1_00050
ORF51 | PGSP1_00051
ORF52 | PGSP1_00052
ORF53 | PGSP1_00053
 | PGSP1_00054
 | PGSP1_00055
 | PGSP1_00056
 | PGSP1_00057
 | PGSP1_00058
 | PGSP1_00059
 | PGSP1_00060
Spreadsheet: 65394d1266087731-greater-then-less-then-in-between-sample
Sheet: Arkusz1

Lp. | Surname and Name | Net Salary | Number of sales | Commision | Over Time worked |  | Bonus | Bonus Amount | Gross Salary | Income Tax | Net Salary
1 | [NAME] | 850 | 12 |  | 24 |  | tak
2 | [NAME] | 650 | 4 |  | 15 |  | nie
3 | Kawka Ewa | 1200 | 25 |  | 8 |  | tak
4 | Meler Iwona | 950 | 20 |  | 4 |  | nie
5 | Tarka Marek | 780 | 10 |  | 21 |  | tak
6 | Sikora Jan | 1050 | 34 |  | 10 |  | tak
 | Średnia |  |  |  |  |  |  |  |  | Razem
 | Items |  |  |  |  |  |  |  | Premia
 | Less then |  |  | 20 | 0.08 | [NAME] |  |  | tak | 120
 | Greater then |  |  | 20 | 0.2 | [NAME] |  |  | nie
 | Between |  |  | 20 | 0.2 | [NAME]
Spreadsheet: 28282d1222340044-looking-up-value-to-a-name-test-1-
Sheet: Sheet1

Alina | 150
Beate | 80
[NAME] | 50
[NAME] | 60
[NAME] | 70
Christina | 96
Al | 110
[NAME] | 100
[NAME] | 40
Group 1 | Value | Group 2 | Value | Group 3 | Value
Alina | 150 | Beate | 80 | [NAME] | 70
[NAME] | 60 | [NAME] | 50 | Christina | 96
[NAME] | 100 | AL | 110 | [NAME] | 40
 |  | Silje |  | Kris
Spreadsheet: 742241d1627613847-multiple-entries-from-one-source-pq-list-mult-times
Sheet: Sheet1

employee | boss | number |  | employee
[NAME] | [NAME] | 8 |  | [NAME]
[NAME] | [NAME] | 10 |  | [NAME]
[NAME] | [NAME] | 10 |  | [NAME]
[NAME] | Mark | 8 |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
Spreadsheet: 676298d1588744522-unique-value-help
Sheet: Sheet1

 | Current formula | Answer should be | New formula | Name
 | 1 | 1 |  | A
 |  | 0 |  | A
 |  | 1 |  | B
 |  | 0 |  | B
 |  | 0 |  | B
 |  | 1 |  | C
 |  | 0 |  | C
 |  | 0 |  | C
 |  | 0 |  | C
 |  | 1 |  | Z
 |  | 0 |  | Z
 |  | 0 |  | Z
 |  | 1 |  | E
 |  | 0 |  | E
 |  | 0 |  | E
 |  | 0 |  | B
 |  | 0 |  | B
Spreadsheet: 113418d1309339001-refer-to-cell-on-another-sheet-test
Sheet: Sheet3

TEST1 | 85
TEST2 | 30
TEST3 | 53
TEST4 | 55
TEST5 | 44
TEST6 | 19
TEST7 | 68
TEST8 | 34
TEST9 | 47
TEST10 | 91
TEST11 | 81
TEST12 | 29
TEST13 | 49
TEST14 | 45
TEST15 | 21
TEST16 | 77
TEST17 | 14
TEST18 | 63
TEST19 | 81
Spreadsheet: 768207d1644879324-summing-across-multiple-worksheets-based-on-category-example-zenmusicman
Sheet: Sheet1

 | Category | Date | Price
 | Equipment | 2021-05-07 00:00:00 | 5
 | Education | 2021-05-08 00:00:00 | 5
 | Auto | 2021-05-09 00:00:00 | 5
 | Repairs | 2021-05-10 00:00:00 | 10
 | Fees | 2021-05-11 00:00:00 | 15
 | Education | 2021-05-12 00:00:00 | 20
 | Auto | 2021-05-13 00:00:00 | 30
 | Repairs | 2021-05-14 00:00:00 | 100
 | Education | 2021-05-15 00:00:00 | 5.5
 | Auto | 2021-05-16 00:00:00 | 3.25
 | Repairs | 2021-05-17 00:00:00 | 100
Spreadsheet: 174873d1345220827-date-interval-formula-interval-sample
Sheet: Sheet1

Date 1 | Date 2 | Date 3 | Average Interval
2012-02-29 00:00:00 | 2012-04-04 00:00:00 | 2012-07-11 00:00:00
2012-03-01 00:00:00 | 2012-07-24 00:00:00 | 2012-07-24 00:00:00
2012-03-02 00:00:00 | 2012-04-24 00:00:00 | 2012-07-30 00:00:00
2012-03-03 00:00:00 |  | 2012-07-25 00:00:00
2012-01-23 00:00:00 | 2012-07-25 00:00:00 | 2012-09-22 00:00:00
2012-02-02 00:00:00 | 2012-03-24 00:00:00 | 2012-09-30 00:00:00
Spreadsheet: 5c7a8c62-6e48-4f6e-87b3-d502fb0007f7
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
TREE1 | Test | TREE1 | Tree Panel # 1 | Tree Panel # 1 | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL	 Additional Information: See Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
TREE1 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
TREE1 | Result | TREE1 | Tree Panel # 1 | Tree Panel # 1 | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 30184-6
Spreadsheet: darrell_schoolcraft__7299__imball0112
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -833448
3531 | -337735 | -132143
60667 | -9394 | -963908
60749 | 16714 | -185859
61206
61334 | -107375
62960
INDEX
2001-11-30 00:00:00 |  |  | 723510.56
2001-12-11 00:00:00
CBS Volume
 |  |  | 125165
Spreadsheet: 599515d1543157091-only-top-two-book3-ans
Sheet: Sheet1

A | B |  | A
A | B |  | C
A | B |  | B
B | B
B | C
B | C
C | S
C | R
C | S
C | E
Spreadsheet: 212999d1360316745-sum-all-values-up-to-a-specific-capped-amount-specific-total
Sheet: Sheet1

date | 2013-02-01 00:00:00 | 2013-02-02 00:00:00 | 2013-02-03 00:00:00 | 2013-02-04 00:00:00 | 2013-02-05 00:00:00 | 2013-02-06 00:00:00 | 2013-02-07 00:00:00 | 2013-02-08 00:00:00
amount | 230 | 56 | 50 | 120 | 30 | 100 | 230 | 30 |  |  |  | Total
Total |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 204099d1357342224-finding-multiple-entries-and-ignoring-others-with-a-formula-and-helper
Sheet: Sheet1

stuff | data | helper
LE3203 | 1 | 2 |  |  |  | LE3203 | 8
LE3203 | 1 |  |  |  |  | LE0001 | 140
LE3203 | 1 |  |  |  |  | LE0002 | 190
LE3203 | 1 |  |  |  |  | LE0004 | 110
LE0001 | 10 | 6 |  |  |  | LE0005 | 23
LE0001 | 20
LE0001 | 30
LE3203 | 1
LE3203 | 1
LE3203 | 1
LE3203 | 1
LE0001 | 80
LE0002 | 90 | 14
LE0002 | 100
LE0004 | 110 | 16
LE0005 | 23 | 17
Spreadsheet: 883601d1732222824-making-an-automatic-on-call-board-recreation-of-the-on-call-board-automatic-2025
Sheet: September

 | September
 |  | 1 | 2 | 3 | 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
 | [NAME]
 | [NAME]
 | Romo
 | [NAME]
 | Orlando
 | Nick
 | [NAME]
 | Zach
 | Pando
 | [NAME]
 | Art
 | Manuel
 | [NAME]
Spreadsheet: 102434d1300371699-max-per-month-book1-2-
Sheet: Sheet2

2010-01-01 00:00:00
2010-02-01 00:00:00
2010-03-01 00:00:00
2010-04-01 00:00:00
2010-05-01 00:00:00
2010-06-01 00:00:00
2010-07-01 00:00:00
2010-08-01 00:00:00
2010-09-01 00:00:00
2010-10-01 00:00:00
2010-11-01 00:00:00
2010-12-01 00:00:00
Spreadsheet: 485014d1476647648-color-in-a1-to-define-color-used-by-conditional-formatting-planner-shareversion
Sheet: Planner

 | Ideal week planner |  |  | 1/2 |  |  |  | start schedule: | 07:00:00
 |  |  |  |  |  |  |  | time interval: | 15
 |  |  |  |  |  |  |  | end schedule: | ??
 | THEME
 | time | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY