tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 708023d1607589493-how-to-report-the-top-20-and-bottom-20-of-a-data-table-report-with-2-conditions-dashboard
Sheet: ITALY

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 137205d1326999769-find-neareast-value-with-multiple-criteria-dummy-file-2-2-
Sheet: Week Counter

CALENDAR
MONTH | WEEKNUM | MONTH/ WEEK START | MONTH/ WEEK END | WEEKSTART | WEEK END
 |  | 2011-10-01 00:00:00
Spreadsheet: 889544d1740404225-need-excel-formula-to-sum-child-references-based-on-parent-reference-complus865-2019-aligw
Sheet: Sheet1

Given Data |  |  | Expected Result
All References | Quantity |  | Parent References | Quantity |  |  | 365 Solution
12552AB.KC.1200AB.33 | 8 |  | 12550 |  |  |  |  | 17
87654TC.OC.90911.91 | 7 |  | 87650 |  |  |  | 87650 | 7
96232RR.ZA.1111S2.PO | 7 |  | 96230 |  |  |  | 96230 | 7
12553RR.ZA.1111S2.PO | 4
12556TC.OC.1200AB.33 | 5
Spreadsheet: 163568d1340369168-send-unique-duplicates-and-3x-duplicates-to-a-seperate-sheet-cut-sort-list
Sheet: match 2

Gage ID | Description | Asset No | Location | Last Cal Date | Next Due Date | list
QE-001515 | [NAME] |  |  | 2011-01-13 00:00:00 | 2014-01-13 00:00:00 | [NAME]
QE-001515 |  |  | A200 |  |  | inventory
QE-001516 | [NAME] |  |  | 2011-01-13 00:00:00 | 2014-01-13 00:00:00 | [NAME]
QE-001516 |  |  | A200 |  |  | inventory
QE-001517 | KJ OEC |  |  | 2011-02-03 00:00:00 | 2016-02-03 00:00:00 | [NAME]
QE-001517 |  |  | D300 |  |  | inventory
QE-001518 | Profile - Flat |  |  | 2011-01-13 00:00:00 | 2014-01-13 00:00:00 | [NAME]
QE-001518 |  |  | A200 |  |  | inventory
QE-001519 | Bezel  RH Flat |  |  | 2011-12-13 00:00:00 | 2014-12-12 00:00:00 | [NAME]
QE-001519 |  |  | A200 |  |  | inventory
Spreadsheet: 183251d1348760934-changing-cell-color-from-an-if-statement-colour-cell
Sheet: Sheet1

ESTIMATED TIME | EST/COMP | % OF COMPLETION TIME | ACTUAL
8 | 0.25 | 2 | 2
8 | 0.75 | 6 | 4
8 | 1 | 8 | 5
8 | 0.5 | 4 | 3
4 | 0.5 | 2 | 1
6 | 0.25 | 1.5 | 5
10 | 0.75 | 7.5 | 8
 |  | 0 | 19
100 |  | 0 | 5
 |  | 0 | 5
 |  | 0 | 10
 |  | 0
 |  | 0
152 | 0.5714285714285714 | 31 | 67
Spreadsheet: 300435d1393468722-how-to-get-invoice-amount-with-corresponding-date-range-book4
Sheet: Sheet1

Invoice Number | [NAME] From/Bill To | Invoice Amount | Dec '13 | Jan '14 | Feb '14
1 | 01/01/2014 00:00 | 38764.68
 | 01/02/2014 00:00
2 | 12/30/2013 00:00 | 61931.81
 | 01/01/2014 00:00
3 | 01/01/2014 00:00 | 8190.06
 | 01/02/2014 00:00
Spreadsheet: 01e0300c-6e80-41f6-9704-6ee70dab2909
Sheet: Sheet1

Year | Dept | No | Contractor(s) | Services | Start Date | Expiration Date | Annual Value
12 | FS | 41 | Municipal or County Motor Vehicle Service Provider Agreement | New Mexico Motor Vehicle Department | 3/20/12 | Indefinite
12 | PW | 45 | GE Water & Process Technologies, Inc. | Service Agreement for Cabezon WWTP | 3/24/12 | 3/23/13 | $14,019
12 | FS | 40 | ASK Development Solutions, Inc. | Analysis of Impediments to Fair Housing Choice | 4/2/12 | 4/1/13 | Not To Exceed $6,000
12 | PW | 46 | Anderson-Brown, Inc. | City Center Booster Pump Station | 4/2/12 | 2012-12-31 00:00:00 | 1468066.6
12 | [NAME] | 47 | Daktronicks, Inc. | City Center/Event Center Electronic Marquee | 6/26/12 | NTP | $293,632.94
12 | UT | 51 | Trinity Technical Corporation | Programming Services for Water and Wastewater Facilities | 4/5/12 | 4/4/16 | Based on Fee Schedule
12 | PW | 52 | Lifespan Design Studio | Senior Center Design Consultation Services | 4/2/2012 | 4/1/2013 | Based on Fee Schedule
12 | PR | 54 | Kells & Craig | Design of New Senior Center | 4/10/12 | 4/9/13 | 455013.11
12 | PW | 56 | Anderson-Brown | Cabezon WWTF#6 - 0.6 MGD Expansion | 5/12/12 | 12/31/12 | $3,324,300.00
12 | HR | 59 | Regents of the University of New Mexico (UNM) | College Intern Work Study Program | 5/12/12 | 5/11/13
12 | PW | 60 | CDM Smith, Inc. | Septage Dump Station Design | 5/25/12 | 5/24/13 | Based on Fee Schedule
12 | IT | 62 | IBM Credit Corp | Term Lease Supplement | 5/24/12 | 5/23/15 | $47,203
12 | FS | 64 | [NAME] | FY 2012 Annual City-wide Audit | 5/8/12 | 6/30/16 | $68,758
12 | PR | 65 | Western Enterprises | 2012 4th of July Fireworks Display | 5/18/12 | 7/4/12 | $25,000
12 | PW | 66 | RMCI, Inc. | Advanced Water Treatment Facility Phase I | 6/4/12 | 6/3/13 | $1,856,710
12 | PW | 68 | Sparling Construction Co., Inc. | [NAME] | 6/4/12 | 8/31/12 | $212,756
12 | PR | 69 | New Mexico Interstate Stream Commission | Bosque Wildlife Habitat Improvements Design | 6/5/12 | 6/30/14
Spreadsheet: 697021d1601105875-extract-the-numbers-but-not-to-repeat-twice-extract-copy
Sheet: Sheet2

 |  | [NAME] not working for B7 & B8 | Expected Result
 | Wonder Materials Pvt Lat (606845933) |  | 606845933
 | Yashoda Foods (P) Ltd. (603584857) |  | 603584857
 | Unique Rubber Udhyog, Damak (607835052) |  | 607835052
 | Triveni Soap & Chemical Ind (602790851) |  | 602790851
 | Shiv [NAME] 304392421 (304392421) |  | 304392421
 | Om Shankar Food Products 601818912(601818912) |  | 601818912
Spreadsheet: chris_germany__2129__FebCohCHOICE-ENA
Sheet: Feb 21

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-02-21 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | Upstream K# | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1590 |  | 1375 |  | 67694 |  |  |  |  |  |  | 17 | 1 | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 2 | 18
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 13578 |  | 13578 |  | 67694 |  |  |  |  |  |  | 18 | 3 | 22
 |  |  |  |  |  |  |  |  | 3000 |  | 3000 |  | 68918 | 103722 | 0 |  |  |  |  | 17 | 4 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 5 | 25
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 4905 |  | 4782 |  | 67694 |  |  |  |  |  |  | 21 | 6 | 24
 |  |  |  |  |  |  |  |  | 2000 |  | 2000 |  | 68915 | 103722 | 0 |  |  |  |  | 18 | 7 | 19
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69148 |  | 0 |  |  |  |  | 23 | 8 | 26
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0 |  |  |  |  | 22 | 9 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | 15 | 32
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 24538 |  | 22013 |  | 67694 |  |  |  |  |  |  | 21 | 35 | 21
 |  |  |  |  |  |  |  |  | 25 |  | 25 |  | 68917 | 103722 | 0 |  |  |  |  | 17 | 39 | 18
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 |  | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 3102 |  | 2718 |  | 67694 |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 2597 |  | 2521 |  | 67694 |  |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 68916 | 103722 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 19138 |  | 17947 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 3669 |  | 3353 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 4269 |  | 3927 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 5438 |  | 5157 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1915 |  | 1915 |  | 67694
 |  |  |  |  |  |  |  |  | 257 |  | 257 |  | 69708 | 53858 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 53858 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 52 |  | 51 |  | 67694 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20146 | FOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86918 | 20596 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 267159d1379973931-conditional-formatting-highlight-column-nth-case-of-a-letter-conditional-formatting-nth-column
Sheet: Sheet1

 | Enter 1st of month: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
 | 2013-02-01 00:00:00 |  |  |  |  |  |  | H |  |  |  |  |  |  |  | H
 | February
 | Employee | 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 | 31
 | Alvin
 | [NAME]
Spreadsheet: 487636d1478179103-power-pivot-and-data-model-theory-powerpivot-test
Sheet: Sheet1

 | Empl./Appl.Name | Pers.No. | Date | Hours | Time type descript. | Cost Ctr | Org. Unit | Org. Unit2 | Pers. subarea | Job key | EE subgroup | EE subgrp | Subarea | TmType | Work schedule rule (short) | End Date | Position
 | NICOLE |  | 2016-05-24 00:00:00 | 8 | Pre-Retirement | 102564 | 86329401 | S1 DOCK | Gr1 [NAME] | clown | CP Regular Full-time | 7A | 0210 | 9274 | 0003087 | 9999-12-31 00:00:00 | 83061278
 | [NAME] |  | 2016-05-25 00:00:00 | 4.1 | Regular Hours | 102564 | 86329401 | S1 DOCK | Gr1 [NAME] | chef | CP Regular Full-time | 7A | 0210 | 9310 | 0003087 | 9999-12-31 00:00:00 | 80456462
 | CAROLE |  | 2016-05-26 00:00:00 | 8 | Regular Hours | 102564 | 86318604 | S1 COMM | Gr1 [NAME] | cop | CP Regular Full-time | 7A | 0210 | 9310 | Y010101 | 9999-12-31 00:00:00 | 83199486
 | JORDAN |  | 2016-05-27 00:00:00 | 8 | Regular Hours | 102564 | 86810277 | S3 COMM | Gr1 [NAME] | teacher | CP Regular Part-time | 7B | 0210 | 9310 | [NAME] | 9999-12-31 00:00:00 | 83137922
 | PAUL |  | 2016-05-28 00:00:00 | 8 | Regular Hours | 102564 | 86075906 | S1 COMM | Gr2 [NAME] | lawyer | CP Regular Full-time | 7A | 0210 | 9310 | Y010101 | 9999-12-31 00:00:00 | 80460451
 | KATHLEEN |  | 2016-05-29 00:00:00 | 8 | Regular Hours | 102564 | 86810275 | S3 COMM | Gr2 [NAME] | clown | CP Regular Part-time | 7B | 0210 | 9310 | 0001182 | 9999-12-31 00:00:00 | 83168797
 | CHANTALE |  | 2016-05-30 00:00:00 | 8 | Regular Hours | 102564 | 86810275 | S3 COMM | Gr2 [NAME] | clown | CP Regular Part-time | 7B | 0210 | 9310 | 0001182 | 9999-12-31 00:00:00 | 83152124
 | MARIE |  | 2016-05-31 00:00:00 | 8 | Regular Hours | 102564 | 86344737 | S3 COMM | Gr2 [NAME] | waiter | CP Regular Part-time | 7B | 0210 | 9310 | 0003254 | 9999-12-31 00:00:00 | 80465186
 | DON |  | 2016-06-01 00:00:00 | 8 | Regular Hours | 102564 | 86344737 | S3 COMM | Gr2 [NAME] | unemployed | CP Regular Part-time | 7B | 0210 | 9310 | 0003254 | 9999-12-31 00:00:00 | 83002291
Spreadsheet: 83229d1283260890-if-countif-output-count-rank-sumproduct-rankoutput
Sheet: Sheet1

S.No. | Status | Name
1 | Completed | [NAME] |  |  | Result - Status Count
2 | Completed | [NAME] |  |  | Name | Completed | Pending | Already Done | Total Earned Points | Rank
3 | Completed | [NAME]
4 | Completed | [NAME]
5 | Completed | [NAME]
6 | Pending | [NAME]
7 | Completed | [NAME]
8 | Completed | [NAME]
9 | Completed | [NAME]
10 | Completed | [NAME]
11 | Completed | [NAME]
12 | Completed | [NAME]
13 | Pending | [NAME]
14 | Pending | Eminem
15 | Completed | Eminem
16 | Completed | Akon
17 | Completed | [NAME]
18 | Completed | [NAME]
19 | Completed | [NAME]
20 | Completed | [NAME]
21 | Completed | Eminem
22 | Completed | [NAME]
23 | Pending | [NAME] |  |  | Ranking
24 | Completed | [NAME] |  |  | Name | Total Earned Points | Rank
25 | Completed | [NAME]
26 | Completed | [NAME]
27 | Completed | [NAME]
28 | Completed | [NAME]
29 | Completed | [NAME]
30 | Completed | [NAME]
31 | Completed | [NAME]
32 | Completed | [NAME]
33 | Completed | [NAME]
34 | Already Done | [NAME]
35 | Completed | Celine Dion
36 | Completed | [NAME]
37 | Completed | [NAME]
38 | Completed | Celine Dion
39 | Already Done | [NAME]
40 | Completed | Eminem
41 | Completed | [NAME]
42 | Completed | [NAME]
43 | Completed | [NAME]
44 | Completed | Akon
45 | Completed | [NAME]
Spreadsheet: fba313ba-8ece-48b8-92ed-6c5c49a45016
Sheet: Sheet1

2008년 9월 르노삼성자동차 판매실적 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
[NAME] 출범 후 누적 판매대수(내수+수출) 100만대 돌파: 1,002,365대
(르노삼성자동차 출범일: 2000년 9월 1일)
[NAME], 전년대비 27.8% 증가
차종 |  | 2008년 9월 | 2008년 8월 | 전월대비(%) |  | 2007년 9월 | 전년동월대비(%) |  | 누계(~9月) |  | 전년누계대비(%)
 |  |  |  |  |  |  |  |  | 2008년 | 2007년
내수 | SM7 | 930 | 1230 | -24.39024390243902 |  | 1174 | -20.78364565587734 |  | 12150 | 11093 | 9.528531506355364
 | SM5 | 4452 | 5360 | -16.94029850746269 |  | 5915 | -24.73372781065089 |  | 42948 | 55825 | -23.06672637707121
 | SM3 | 1209 | 1614 | -25.09293680297398 |  | 1912 | -36.76778242677825 |  | 14827 | 21349 | -30.54944025481286
 | [NAME] | 1186 | 1167 | 1.628106255355613 |  |  |  |  | 9423
계 |  | 7777 | 9371 | -17.00992423433999 |  | 9001 | -13.59848905677147 |  | 79348 | 88267 | -10.10456909150645
수출 | SM7 | 5 | 6 | -16.66666666666666 |  | 5 | 0 |  | 48 | 55 | -12.72727272727273
 | SM5 | 420 | 243 | 72.8395061728395 |  |  |  |  | 1170 | 219 | 434.2465753424658
 | SM3 | 4005 | 4585 | -12.64994547437296 |  | 3988 | 0.4262788365095247 |  | 35209 | 37627 | -6.426236479124029
 | [NAME] | 4399 | 5050 | -12.89108910891089 |  |  |  |  | 38071
계 |  | 8829 | 9884 | -10.67381626871712 |  | 3993 | 121.1119459053343 |  | 74498 | 37901 | 96.559457534102
총계 |  | 16606 | 19255 | -13.75746559335238 |  | 12994 | 27.79744497460366 |  | 153846 | 126168 | 21.93741677762982
자료문의: | 르노삼성자동차 커뮤니케이션 본부 서규억 팀장 / 조주홍 대리 (3707-5362/5373)
Spreadsheet: 717416d1612639051-array-formula-that-return-city-with-two-condition-and-have-no-sales-new-microsoft-excel-worksheet
Sheet: Sheet1

month | product | city | total sales |  |  |  | month | 4 |  | Not listed
1 | a2 | c1 | 1000 |  |  |  | product | a1
4 | a1 | c2 | 2000
2 | a1 | c3 | 3000
3 | a2 | c4 | 4000
4 | a1 | c5 | 5000
5 | a2 | c2 | 6000
Spreadsheet: 162834d1340099667-conditional-formatting-of-duplicate-rows-not-duplicate-cells-duplicates
Sheet: Tabelle1

Data |  |  |  |  | [NAME] (no conditional formatting used yet) |  |  |  |  | Example with only first column duplicates (conditional formatting unsed)
A | 1 |  |  |  | A | 1 |  |  |  | A | 1
B | 1 |  |  |  | B | 1 |  |  |  | B | 1
C | 1 |  |  |  | C | 1 |  |  |  | C | 1
D | 1 |  |  |  | D | 1 |  |  |  | D | 1
D | 1 |  |  |  | D | 1 |  |  |  | D | 1
D | 2 |  |  |  | D | 2 |  |  |  | D | 2
E | 1 |  |  |  | E | 1 |  |  |  | E | 1
F | 1 |  |  |  | F | 1 |  |  |  | F | 1
F | 1 |  |  |  | F | 1 |  |  |  | F | 1
F | 2 |  |  |  | F | 2 |  |  |  | F | 2
Goal: Conditional formatting of duplicates over several columns
Excel version: 2003
Spreadsheet: e068fea8-a8c4-4532-955a-fe13a051d9f1
Sheet: Sheet1

Základní popis závodů | 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
 |  | Místo konání: |  | LABE - Mlékojedy
 |  | Druh závodu: |  | ME MiČR LRU Feeder 2012
 |  | Datum konání: |  | 14.7.-15.7.2012
 |  | Sponzor: |  | DAIWA
 |  | Hl. rozhodčí: |  | [NAME]
Sektory | Index | Počet míst |  | Popis úseků |  |  |  | 1 závod |  | 2 závod |  | CELKEM
 |  | 1.záv. | 2.záv. |  |  |  |  | naloveno | prům. [NAME] | Naloveno | prům na závdníka | Naloveno | prům na závdníka
Suma |  | 82 | 82 |  |  |  |  | 260440 | 3176.09756097561 | 418210 | 5100.121951219512 | 678650 | 4138.109756097561
A | 3 | 14 | 14 |  |  |  |  | 40420 | 2887.142857142857 | 97990 | 6999.285714285715 | 138410 | 4943.214285714285
B | 8 | 14 | 14 |  |  |  |  | 53400 | 3814.285714285714 | 61240 | 4374.285714285715 | 114640 | 4094.285714285714
C | 13 | 14 | 14 |  |  |  |  | 48640 | 3474.285714285714 | 52380 | 3741.428571428572 | 101020 | 3607.857142857143
D | 18 | 13 | 13 |  |  |  |  | 38180 | 2936.923076923077 | 53240 | 4095.384615384615 | 91420 | 3516.153846153846
E | 23 | 13 | 13 |  |  |  |  | 42980 | 3306.153846153846 | 57560 | 4427.692307692308 | 100540 | 3866.923076923077
F | 28 | 14 | 14 |  |  |  |  | 36820 | 2630 | 95800 | 6842.857142857143 | 132620 | 4736.428571428572
G | 33 | 0 | 0 |  |  |  |  | 0 |  | 0 |  | 0
H | 38 | 0 | 0 |  |  |  |  | 0 |  | 0 |  | 0
I | 43 | 0 | 0 |  |  |  |  | 0 |  | 0 |  | 0
J | 48 | 0 | 0 |  |  |  |  | 0 |  | 0 |  | 0
K | 53 | 0 | 0 |  |  |  |  | 0 |  | 0 |  | 0
L | 58 | 0 | 0 |  |  |  |  | 0 |  | 0 |  | 0
M | 63 | 0 | 0 |  |  |  |  | 0 |  | 0 |  | 0
 |  |  | Maximálně naloveno |  |  |  |  | 11820 |  | 14400
 |  |  |  | Počet mužů (M) |  |  |  | 80
 |  |  |  | Počet juniorů (J,JŽ) |  |  |  | 1
 |  |  |  | Počet kadetů (K,KŽ) |  |  |  | 0
 |  |  |  | Počet žen (Ž,KŽ,JŽ) |  |  |  | 1
 |  |  |  | Počet hendikepovaných (H) |  |  |  | 0
Na základním listě se vypisuje [NAME], [NAME]. rozhodčí
list [NAME] listina:
1. jména, kategorii a registračka (REG.). Když nevím vyplním jednoznačný identifikátor (nesmí se opakovat). Družstvo není rozhodující
2. pořadí losování. Na jeho základě můžeme třídit tabulku.
3.  sektor a místo na základě losu (sl F,G). Po výpočtu na základě klávesy F9 se vyplní list 1. závod popřípadě 2. závod.
sloupce T-X jsou [NAME] na registračky, je možné smazat
list x.závod.
- při správně [NAME] v listě [NAME] listina [NAME] správně předplněn. [NAME].
1. vypisuje [NAME] hmotnost a to v gramech. [NAME] (klávesa [NAME]) a automaticky se přenáší na list [NAME]
[NAME] a penalizace se mohou řešit úpravou pořadí, ale je třeba napsat do kolonky podpis důvod.
list [NAME] listina:
při celkovém umístění nedokážu [NAME] pořadí při stejném počtu bodů a závodníky, [NAME].
Je třeba proto provést:
1. setřídit [NAME] výsledky: 1- počet závodů sestupně (sl S), 2- body vzestupně (sl. O), 3- CIPS sestupně (sl.N)
2. [NAME] pořadí v sloupci P
list Závod družstev
[NAME], jména a ostatní údaje se dotahují z ostatních tabulek na základě vyplnění sloupce [NAME] (sl. B)
Spreadsheet: 732358d1620909138-percentage-rate-formula-percentage-bracket-example
Sheet: Sheet1

 |  | Sum Total | 200000
 |  | Sum Total Bracket | Percentage Bracket | Marginal Rate | Percentage Rate Total
 |  | 0 | 0.09 | 0.09 | 4500
 |  | 50000 | 0.06 |  | 2999.94
 |  | 100000 | 0.05 |  | 4999.95
 |  |  | Total Percentage Rate
Spreadsheet: 858091d1706865311-table-cross-referencing-table-cross-referencing
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | Choose number: | Output: |  | Choose Letter: | Output:
Argos | - |  |  |  |  |  |  |  |  |  |  | 8 | D |  | Currys | 2
Boots |  |  |  |  |  |  |  |  | - | - |  |  | E |  |  | 4
Currys |  | - |  | - |  | - |  |  |  | - |  |  | G |  |  | 6
Decathlon |  |  |  | - |  |  |  | - |  |  |  |  |  |  |  | 10
Ebay | - | - | - |  |  | - |  | -
Fanta
Gatorade |  |  |  | - |  | - |  | - |  | -
Spreadsheet: 852235d1702322412-weighted-average-rent-per-square-foot-for-plaza-if-lease-started-after-a-certain-date-working-rent-roll
Sheet: Multi-Family Unit Mix

 | RR dated |  |  |  |  |  |  |  |  |  | Unit Mix (Multifamily) |  |  |  |  |  |  |  |  |  |  |  |  | Prior Year's [NAME]
 | Unit # | Unit Type | Unit Description | Occupancy Status | Market Rent | Actual Rent | Per Workbook = Actual + Vacant |  | Unit Type |  | Apartment Unit Type |  |  | # of Leased Units | # Vacant Units | Total # of Units | Actual Rent Per Month Per Unit | Actual Annual Rent | Vacant Unit Monthly Rent |  | SF | Tenant Code | [NAME] | Unit# | Type | SF/Rent | Status | From Prior Year's RR
 |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  | Source (Multifamily)
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Average per Latest RR
 |  |  |  |  |  |  |  |  |  |  | Average per Prior RR
 |  |  |  |  |  |  |  |  |  |  | % Inc or Dec.
 |  |  |  |  |  |  |  |  |  |  | CMHC's Weighted Avg
 |  |  |  |  |  |  |  |  |  |  | % Inc or Dec.
 |  |  |  |  |  |  |  |  |  |  | Rent for xxx occupied units
 |  |  |  |  |  |  |  |  |  |  | Rent for xxx vacant units |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | Rent for 'All Others' |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | Total Rent |  |  | 0
 |  |  | Total
 |  |  | Source
 |  |  | [NAME]
Spreadsheet: 876720d1723464053-trying-to-calculate-difference-in-days-between-2-dates-of-various-formats-test-1
Sheet: Sheet1

Format | Start Date | End Date | Difference in Days | Answer
DDMMYYYY | 2024-01-31 00:00:00 | 2024-02-01 00:00:00 |  | 2
DDMMYYYY | 2/2/2024 | 2024-02-02 00:00:00 |  | 1
DDMMYYYY | 2024-01-22 00:00:00 | 2024-01-24 00:00:00 |  | 3
 | 1/31/2024 8:30:00 AM | 2024-01-02 18:00:00 |  | 2
 | 2/28/2024 9:00:00 AM | 2/28/2024 6:00:00 PM |  | 1
MMDDYYYY | 2024-04-06 08:30:00 | 2024-07-06 18:00:00 |  | 3
Spreadsheet: 186697d1350155293-itemlist-orderlist-orderlist
Sheet: Order

Company
OrderDate
OrderNR
ItemNr | ItemDesc | QtyOrder
110001 | Item 1 | 5
110004 | Item 4 | 5
110006 | Item 6 | 10
110010 | Item 10 | 3
110012 | Item 12 | 1
110017 | Item 17 | 1
110019 | Item 19
Spreadsheet: 768374d1644938996-trying-to-look-up-and-filter-data-example
Sheet: Keg

 | Id numeric | Product | Brew number | Sampling point | Analysis | Component name | Result text
998518 | 998518 | KROK050 | 998395 |  | ABV | ABV | 5
998518 | 998518 | KROK051 | 998395 |  | AE | AE | 1.83
998518 | 998518 | KROK052 | 998395 |  | COL | COL | 9.1
998518 | 998518 | KROK053 | 998395 |  | PH | PH | 4.29
998518 | 998518 | KROK054 | 998395 |  | DO2_KBT | DO2_KBT | 98
998518 | 998518 | KROK055 | 998395 |  | CO2 | CO2 | 4.35
998518 | 998518 | [NAME] | 998395 |  | N2 | N2 | 5
998518 | 998518 | KROK057 | 998395 |  | VISUAL | VISUAL | PASS
998518 | 998518 | KROK058 | 998395 |  | HAZE_90DEG | HAZE_90DEG | 0.39
998519 | 998519 | KROK059 | 99395 |  | ABV | ABV | 4.95
998519 | 998519 | KROK060 | 99395 |  | AE | AE | 1.8
998519 | 998519 | KROK061 | 99395 |  | VISUAL | VISUAL | PASS
998519 | 998519 | KROK062 | 99395 |  | HAZE_90DEG | HAZE_90DEG | 0.41
998520 | 998520 | KROK063 | 998695 |  | DO2 | DO2 | 180
998520 | 998520 | KROK064 | 998695 |  | CO2 | CO2 | 4.39
998520 | 998520 | KROK065 | 998695 |  | N2 | N2 | 9
998679 | 998679 | REDK050 | 998652 |  | COL | COL | 7
998679 | 998679 | REDK050 | 998652 |  | PH | PH | 4.25
998679 | 998679 | REDK050 | 998652 |  | DO2_KBT | DO2_KBT | 93
998679 | 998679 | REDK050 | 998652 |  | CO2 | CO2 | 4.2
998679 | 998679 | REDK050 | 998652 |  | N2 | N2 | 6
998679 | 998679 | REDK050 | 998652 |  | VISUAL | VISUAL | PASS
998679 | 998679 | REDK050 | 998652 |  | HAZE_90DEG | HAZE_90DEG | 0.65
998680 | 998680 | REDK050 | 998652 |  | ABV | ABV | 4.63
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 |  | DO2_KBT | DO2_KBT | 102
998680 | 998680 | REDK050 | 998652 |  | CO2 | CO2 | 4.3
998680 | 998680 | REDK050 | 998652 |  | N2 | N2 | 6
998680 | 998680 | REDK050 | 998652 |  | VISUAL | VISUAL | PASS
998680 | 998680 | REDK050 | 998652 |  | HAZE_90DEG | HAZE_90DEG | 0.6