tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 794061d1661864938-financial-statement-ytd-12-month-rolling-average-based-on-dropdown-copy-of-kopi-av-handlingsplaner-2022-1-aligw
Sheet: Bolig

[NAME] | KPI | [NAME] | Resultat 2021 | Mål 2022 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
HR / HMS
Bolig
HMS
 | 0 skader med fravær | Magdalena
 | 20 RUH | [NAME]
 | 100% gjennomføring vernerunder | Magdalena
Kvalitet
 | Ikke dagmulkt/ ikke brukstillatelse | Søren
 | 0-10 feil (0-3 feil 95%, 4-6 feil 90%, 7-10 feil 85%, mer enn 10 - 80%) | Søren
 | FDV levert til forhåndsbefaring | Søren
Miljø
 | Sorteringsgrad per prosjekt / avdeling | Stine
[NAME]
 | DG | Ivar
 | Reklamasjonskost rullerende 12 mnd | Ivar |  | 0.012
 | Omsetning | Ivar
Spreadsheet: 99680d1298294649-combining-the-data-from-2-columns-sample
Sheet: After

Column1 | Column2
The Chronicles Of Narnia | Ad1
The Chronicles Of Narnia | Ad2
The Chronicles Of Narnia | Ad3
The Green Hornet | Ad1
The Green Hornet | Ad2
The Green Hornet | Ad3
The Smurfs | Ad1
The Smurfs | Ad2
The Smurfs | Ad3
The Social Network | Ad1
The Social Network | Ad2
The Social Network | Ad3
Spreadsheet: 54a01656-ce93-4aa4-96f6-72c548c068a9
Sheet: Template Landscape Calendar 

 | TITAN TRANSIT        2012-13
 |  | = | Late Night Only |  |  |  |  |  |  | = | Evening Only |  |  |  |  |  |  | = | Late Night and Evening
 | JULY 2012 |  |  |  |  |  |  |  | AUGUST 2012 |  |  |  |  |  |  |  | SEPTEMBER 2012
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 | 1
 | OCTOBER 2012 |  |  |  |  |  |  |  | NOVEMBER 2012 |  |  |  |  |  |  |  | DECEMBER 2012
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 | JANUARY 2013 |  |  |  |  |  |  |  | FEBRUARY 2013 |  |  |  |  |  |  |  | MARCH 2013
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 | APRIL 2013 |  |  |  |  |  |  |  | MAY 2013 |  |  |  |  |  |  |  | JUNE 2013
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
Spreadsheet: 104845d1302281224-excel-2007-getting-data-from-another-sheet-page-excelforum
Sheet: Utgiftsrapport_MALL

 |  |  |  |  |  |  |  |  | Endast avsedd för internt bruk
 | Utgiftsrapport
 | SYFTE: | Skoldisko |  |  | UTDRAGSNR: |  |  |  | PERIOD: | Från
 |  |  |  |  |  |  |  |  |  | Till
 | INFORMATION OM ANSVARIG:
 | Namn |  |  |  | Befattning |  |  |  | Telefonnr
 | Skola |  |  |  | Lärare |  |  |  | Klass
 | Datum | Konto | Beskrivning | Ansvarig | [NAME] till | --- | ---2 | Utgifter | Betalningsdatum | [NAME] | Summa
 | 2011-04-14 00:00:00 | [NAME] | Inköp av godis/läsk | [NAME] | Privab |  |  | 861
 | Summa
 |  |  |  |  |  |  |  |  |  | Delsumma
 |  |  |  |  |  |  |  |  |  | [NAME] förskott | 0
 | GODKÄND AV: |  |  |  | KOMMENTAR: |  |  |  |  | Summa
Spreadsheet: 539369d1506085362-sumif-positive-number-only-book1
Sheet: Example

 |  |  |  | Example
 |  |  | Agent A | B | C
 | Sale | Cash | 3000 | 6000 | 2000
 |  | Card | 2000 | 1000 | 1000
 | Fees | Management 2%
 |  | Card 5%
 |  |  | 60 | 62 | 63
 | Total Sale
 | Sale Comm | Sale Tier
 |  | 5/5
 |  | Sale Tier
 |  | 6/4
 |  | Sale Tier | "=IF(D9=0,0,MAX(MIN(D9-5000)))
 |  | 7/3 | "=D14/100*70
 |  | Sale Tier | "=IF(D9=0,0,MAX(MIN(D9-10000)))
 |  | 8/2 | "=D16/100*80
 |  | Sale Tier
 |  | 9/1
 |  |  | Agent A | B | C
 |  | Salary | "=D11+D13+D15+D17+D19
 |  | [NAME]
 |  | Total Fees
 |  | Final Salary | "=D22-D23-D24
Spreadsheet: 80004d1280249594-sorting-customer-recomendation-program
Sheet: Sheet1

Customer |  | New Customer | Hours | Date | [NAME] | Accumulated | Used | Date | Left
 |  |  | 2.9
 |  | [NAME]
Allard | [NAME]
Bisset | [NAME] | [NAME] | 8.5 |  |  |  | 0.5
 |  |  | 3.5 |  |  |  | 1.25
 |  |  | 0 |  |  |  | 1.25
Bowness | [NAME] | [NAME]
 |  | [NAME]
 |  | [NAME]
Bonsfield | [NAME] | [NAME]
Spreadsheet: 0b3d2d1f-f54a-4fe9-861d-d7ddf86aa66c
Sheet: Sheet1

Class | Tutor | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday
ACCT 101 - GRAMLING/ SIMRALL | RODRIGUEZ | 6:00pm(B24)
BIOL 108 01-06 - KISER | SELK |  |  |  | 10am(P274)
BIOL 108 01-06 - KISER | HORRELL |  | 3pmP100)
BIOL 108 07-09 - PORTA | BOYCE |  |  |  |  | 11am(P100)
BIOL 108 07-09 - PORTA | [NAME] |  |  | 11am(P100)
BIOL 108 09/10 - LENTZ | HUTTON |  |  |  |  | 11am(P274)
BIOL 108 09/10 - LENTZ | CLARKE |  |  | 11am(P274)
BIOL 108 11/12  - RAMIREZ | [NAME] |  |  |  | 6pm(P275)
BIOL 108 11/12  - RAMIREZ | MILLET |  | 6pm(P275)
BIOL 130 01/02/03 - WILT | [NAME] | 5pmA13) |  | 7pm(P274)
BIOL 130 01/02/03 - WILT | MUELLER |  | 6:30pm(A13)
BIOL 231 01/02 - HUFF | DORMINEY |  |  | 7pm(A23
BIOL 300 - WALKER/ BENNETT/RAMIREZ | INGLE |  | 4:30pm(A24)
CHEM 103  - BURNS/ KRZYSIAK | MCCUBBINS | 12pm(A24) |  | 6:30pm(P214)
CHEM 103 - BURNS/ KRZYSIAK | LAMB |  | 7:30pm(P214)
CHEM 205 01/02 - ELLIS/ BURNS | MCCUBBINS | 2pm(A24) |  |  |  | 6:30pm(A24)
ECON 110 - MCCRICKARD/ HAFELE/BROWN | COUGHLIN |  |  |  |  | 11am(A24)
MATH 116 01 - THERKELSEN | TURI |  |  |  |  |  | 1:30pm(P109)
MATH 117 01- BANKHEAD | [NAME] |  | 6pm(A23)
MATH 117 02/03- ZIELINSKI | BEILMAN | 4pm(A23)
MATH 117 04 - ESCHELS | BEILMAN | 5pm(A23)
MATH 125 01 - THERKELSEN | [NAME] |  | 4:30pm(A23)
MATH 125 02 - THERKELSEN | [NAME] |  |  |  | 6pm(A23)
MATH 200 01 - WHITE
MATH 205 01 - BANKHEAD | BEILMAN | 6pm(A23)
MATH 205 02 - WHITE | BEILMAN |  |  |  |  | 7pm(A23)
MATH 205 03 - GOEBEL | BEILMAN |  |  |  |  | 8pm(23)
MATH 216 01 - RAYMOND | [NAME] |  |  | 4pm(A23)
MDLS 200 - GOLEMBOSKI | RYAN |  |  | 11am(A13)
MUSC 100 - LIGHT | BAIN | 5pm(MUS 101)
NURA 305 - MCEACHRON/ GALLOWAY | PACK
NURA 310 - REIBEL
NURA 330  - BRODERICK
NURA 330 - BRODERICK
NURA 330 - MCNEELEY
NURS 200 - BURD/ CHANDLER | [NAME] | 2pm(A13)
NURS 205 - MCNEELEY/ MINTON/STURGEON | TOWNSEND | 7pm(A24)
NURS 205 - MCNEELEY/ MINTON/STURGEON | HIX |  |  |  | 1pm(A24)
NURS 205 - MCNEELEY/ MINTON/STURGEON | COOMER |  |  |  |  | 4pm(A24)
NURS 206 - FITZGERALD/ DARNELL/JOSEFYK | HAAS |  | 3pm(A24)
NURS 206 - FITZGERALD/ DARNELL/JOSEFYK | DUZANE |  |  |  | 5pm(A13)
NURS 310 - DARNELL | URSCHEL |  |  |  |  | 12:30pm(P109)
NURS 310 - HAGER/ DARNELL | DIEBOLD |  |  | 2pm(P275)
NURS 311 - JACKSON/ REIBEL/BRODERICK/ SMITH/SWIDERSKI | WAGNER | 4:30pm(A24)
NURS 311 - JACKSON/ REIBEL/BRODERICK/ SMITH/SWIDERSKI | REARDON |  |  |  | 4pm(B10)
Spreadsheet: 540366d1506659587-please-critique-my-spreadsheet-payroll-worksheets-year-2017
Sheet: April 2017 summary

April 2017 Summary |  | Total Job Hours | Total Hours-Per Job
# |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
Job
1 |  |  | X
2 |  |  |  | X
3 |  |  |  |  | X
4 |  |  |  |  |  | X
5 |  |  |  |  |  |  | X
6 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  | 0 | 0
 | less shop hours
 | Hours less Shop
3 |  |  |  |  | X
5 |  |  |  |  |  |  | X
6 |  |  |  |  |  |  |  | X
7 |  |  |  |  |  |  |  |  | X
8 |  |  |  |  |  |  |  |  |  | X
 |  |  | 0 |  |  | 0
 | less shop hours
 | Hours less Shop
Hours without Shop
Totals |  |  |  |  |  |  |  | 0
%
Vehicles
 | Fuel | 719.84
 | Repairs & Maintenance | 2413.15
 | Total Overhead | 14547.54
Spreadsheet: 99191d1297904320-weekly-and-monthly-reporting-test
Sheet: ~~INFO~~

WEEK# | START | END |  | MONTH# | MONTH |  |  | WEEK BEGINS ON SUNDAY EXCEPT FOR THE FIRST WEEK OF THE YEAR.
1 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 |  | 1 | JAN
2 | 2011-01-02 00:00:00 | 2011-01-08 00:00:00 |  | 2 | FEB
3 | 2011-01-09 00:00:00 | 2011-01-15 00:00:00 |  | 3 | MAR
4 | 2011-01-16 00:00:00 | 2011-01-22 00:00:00 |  | 4 | APR
5 | 2011-01-23 00:00:00 | 2011-01-29 00:00:00 |  | 5 | MAY
6 | 2011-01-30 00:00:00 | 2011-02-05 00:00:00 |  | 6 | JUN
7 | 2011-02-06 00:00:00 | 2011-02-12 00:00:00 |  | 7 | JUL
8 | 2011-02-13 00:00:00 | 2011-02-19 00:00:00 |  | 8 | AUG
9 | 2011-02-20 00:00:00 | 2011-02-26 00:00:00 |  | 9 | SEP
10 | 2011-02-27 00:00:00 | 2011-03-05 00:00:00 |  | 10 | OCT
11 | 2011-03-06 00:00:00 | 2011-03-12 00:00:00 |  | 11 | NOV
12 | 2011-03-13 00:00:00 | 2011-03-19 00:00:00 |  | 12 | DEC
13 | 2011-03-20 00:00:00 | 2011-03-26 00:00:00
14 | 2011-03-27 00:00:00 | 2011-04-02 00:00:00
15 | 2011-04-03 00:00:00 | 2011-04-09 00:00:00
16 | 2011-04-10 00:00:00 | 2011-04-16 00:00:00
17 | 2011-04-17 00:00:00 | 2011-04-23 00:00:00
18 | 2011-04-24 00:00:00 | 2011-04-30 00:00:00
19 | 2011-05-01 00:00:00 | 2011-05-07 00:00:00
20 | 2011-05-08 00:00:00 | 2011-05-14 00:00:00
21 | 2011-05-15 00:00:00 | 2011-05-21 00:00:00
22 | 2011-05-22 00:00:00 | 2011-05-28 00:00:00
23 | 2011-05-29 00:00:00 | 2011-06-04 00:00:00
24 | 2011-06-05 00:00:00 | 2011-06-11 00:00:00
25 | 2011-06-12 00:00:00 | 2011-06-18 00:00:00
26 | 2011-06-19 00:00:00 | 2011-06-25 00:00:00
27 | 2011-06-26 00:00:00 | 2011-07-02 00:00:00
28 | 2011-07-03 00:00:00 | 2011-07-09 00:00:00
29 | 2011-07-10 00:00:00 | 2011-07-16 00:00:00
30 | 2011-07-17 00:00:00 | 2011-07-23 00:00:00
31 | 2011-07-24 00:00:00 | 2011-07-30 00:00:00
32 | 2011-07-31 00:00:00 | 2011-08-06 00:00:00
33 | 2011-08-07 00:00:00 | 2011-08-13 00:00:00
34 | 2011-08-14 00:00:00 | 2011-08-20 00:00:00
35 | 2011-08-21 00:00:00 | 2011-08-27 00:00:00
36 | 2011-08-28 00:00:00 | 2011-09-03 00:00:00
37 | 2011-09-04 00:00:00 | 2011-09-10 00:00:00
38 | 2011-09-11 00:00:00 | 2011-09-17 00:00:00
39 | 2011-09-18 00:00:00 | 2011-09-24 00:00:00
40 | 2011-09-25 00:00:00 | 2011-10-01 00:00:00
41 | 2011-10-02 00:00:00 | 2011-10-08 00:00:00
42 | 2011-10-09 00:00:00 | 2011-10-15 00:00:00
43 | 2011-10-16 00:00:00 | 2011-10-22 00:00:00
44 | 2011-10-23 00:00:00 | 2011-10-29 00:00:00
45 | 2011-10-30 00:00:00 | 2011-11-05 00:00:00
46 | 2011-11-06 00:00:00 | 2011-11-12 00:00:00
47 | 2011-11-13 00:00:00 | 2011-11-19 00:00:00
48 | 2011-11-20 00:00:00 | 2011-11-26 00:00:00
49 | 2011-11-27 00:00:00 | 2011-12-03 00:00:00
50 | 2011-12-04 00:00:00 | 2011-12-10 00:00:00
51 | 2011-12-11 00:00:00 | 2011-12-17 00:00:00
52 | 2011-12-18 00:00:00 | 2011-12-24 00:00:00
53 | 2011-12-25 00:00:00 | 2011-12-31 00:00:00
Spreadsheet: 592650d1538640561-wanting-to-retrieve-values-from-external-workbook-by-searching-name-of-column-values
Sheet: Values

 | Rx Location | Sensor Position & ID
 |  | RRO | RF | LRI | LRO | RRI | LF
 |  | 50000095 | 500004CEE |  | 5000009C |  | 50000071
 | SNR average (dB) |  |  |  |  |  |  |  |  | RX Block Frame Count
 | Last Peak RSSI |  |  |  |  |  |  |  |  | RX Average Peak Block RSSI
 | Average RSSI SNR
 | Average Frame Count
 | Total Blocks
 | RSSI Average
 | Frame Count
 | RSSI Counts
 | COIN Width Margin
 | PAL Normal Count
Spreadsheet: 550624d1512468645-for-bubble-chart-missing-data-zeszyt2
Sheet: Sheet2

country | billionaires per 10m residents | per capita income | no. of billionaires
us | 54.7 | 54600 | 1764
china | 1.5 | 12880 | 213
germany | 12.5 | 45888 | 103
india | 0.7 | 5855 | 90
russia | 6.2 | 24850 | 88
[NAME] | 1.2 | 17881 | 15
Spreadsheet: 59377d1259862698-countif-total-and-percentage-datasheet
Sheet: Sheet1

States | Number of Colleges
United States | 3559
Alabama | 87
Alaska | 7
Arizona | 38
Arkansas | 35
California | 310
Colorado | 57
Connecticut | 47
Delaware | 10
District of Columbia | 17
Florida | 101
Georgia | 95
Hawaii | 15
Idaho | 11
Illinois | 170
Indiana | 80
Iowa | 58
Kansas | 53
Kentucky | 62
Louisiana | 36
Maine | 31
Maryland | 57
Massachusetts | 116
Michigan | 97
Minnesota | 78
Mississippi | 46
Missouri | 93
Montana | 19
Nebraska | 34
Nevada | 9
New Hampshire | 28
New Jersey | 59
New York | 324
North Carolina | 125
North Dakota | 20
Ohio | 154
Oklahoma | 48
Oregon | 46
Pennsylvania | 220
Rhode Island | 12
South Carolina | 64
South Dakota | 19
Tennessee | 87
Texas | 172
Utah | 15
Vermont | 22
Virginia | 83
Washington | 57
West Virginia | 28
Wisconsin | 61
Wyoming | 9
Spreadsheet: 801851d1666429989-how-do-i-apply-rows-of-many-formulas-to-a-list-of-many-words-phrases-and-cities_jt
Sheet: Sheet1

toronto |  |  | london |  | london
toronto |  |  | berlin |  | london
toronto |  |  | tokyo |  | london
toronto |  |  | munich |  | london
 | Bistro in city |  | madrid |  | berlin
 |  |  | lisbon |  | berlin
 |  |  | jakarta |  | berlin
 |  |  | barcelona |  | berlin
 |  |  | New York |  | tokyo
 |  |  |  |  | tokyo
 |  |  |  |  | tokyo
 |  |  |  |  | tokyo
 |  |  |  |  | munich
 |  |  |  |  | munich
 |  |  |  |  | munich
 |  |  |  |  | munich
 |  |  |  |  | madrid
 |  |  |  |  | madrid
 |  |  |  |  | madrid
 |  |  |  |  | madrid
 |  |  |  |  | lisbon
 |  |  |  |  | lisbon
 |  |  |  |  | lisbon
 |  |  |  |  | lisbon
 |  |  |  |  | jakarta
 |  |  |  |  | jakarta
 |  |  |  |  | jakarta
 |  |  |  |  | jakarta
 |  |  |  |  | barcelona
 |  |  |  |  | barcelona
 |  |  |  |  | barcelona
 |  |  |  |  | barcelona
Spreadsheet: c6d8c679-967c-4f65-a0c1-42e934ec0f80
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 801193152329 | Joe Leavell & St Stephen Chr | God Is Able | 2009-02-24 | Compact Disc | Gospel | 13.99 | Y | Available
Spreadsheet: 855377d1704968312-if-with-averageifs-returning-value-sample-data
Sheet: Sample for Pete_UK

Month | Project Name | Cash Out Periodic | Forecast Cash Out 3 months rolling | Forecast Cash Out - 3 months rolling YTD
January | HVAC OEM Support | 100
February | HVAC OEM Support | 100
March | HVAC OEM Support | 100
April | HVAC OEM Support | 100
May | HVAC OEM Support | 100
June | HVAC OEM Support | 100
July | HVAC OEM Support | 100
August | HVAC OEM Support | 100
September | HVAC OEM Support | 100
October | HVAC OEM Support | 100
November | HVAC OEM Support | 100
December | HVAC OEM Support | 100
January | Ninja | 4990
February | Ninja | 576
March | Ninja | 0
April | Ninja | 18445
May | Ninja | 20783
June | Ninja | 53402
July | Ninja | 3127
August | Ninja | 8919
September | Ninja | 53512
October | Ninja | 78109
November | Ninja | 70641
December | Ninja | 0
Spreadsheet: lisa_gang__22292__ENA_PGE_MAY 9_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 2002-05-09 00:00:00
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  |  | Total In To PGE Trans
0100 |  |  |  |  | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0 | 0
0700 | 25 | 25 | 25 | 25 | 25 | 25
0800 | 25 | 25 | 25 | 25 | 25 | 25
0900 | 25 | 25 | 25 | 25 | 25 | 25
1000 | 25 | 25 | 25 | 25 | 25 | 25
1100 | 25 | 25 | 25 | 25 | 25 | 25
1200 | 25 | 25 | 25 | 25 | 25 | 25
1300 | 25 | 25 | 25 | 25 | 25 | 25
1400 | 25 | 25 | 25 | 25 | 25 | 25
1500 | 25 | 25 | 25 | 25 | 25 | 25
1600 | 25 | 25 | 25 | 25 | 25 | 25
1700 | 25 | 25 | 25 | 25 | 25 | 25
1800 | 25 | 25 | 25 | 25 | 25 | 25
1900 | 25 | 25 | 25 | 25 | 25 | 25
2000 | 25 | 25 | 25 | 25 | 25 | 25
2100 | 25 | 25 | 25 | 25 | 25 | 25
2200 | 25 | 25 | 25 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24711 | BPA(G)24718 | BPA(G)24727 | BPA(G)24771 | BPA(G)24547 | BPA(G)24547
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AEP | AEP | AEP | AEP | AEP | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP | AEP | AEP
 | CDWR | CDWR | TID | MORGAN | SNCL | MIRANT
 | ISO(T)MALIN/NP15 | ISO(T)MALIN/NP15 | TID(T)CPJK/TRACEY/WESLEY | APX | ISO(T)CPJK/NP15 | ISO(T)MALIN/NP15
 | CDWR(L,FS)NP15 (CA) | CDWR(L,FS)NP15 (CA) | TID | ISO(T)MALIN/NP15 | SNCL(L,FS)NP15 (CA) | MIRANT(L,FS)SYS
 |  |  | TID(L)WESLEY | APX(L,FS)SYS
Spreadsheet: 98960d1297769316-lots-of-data-to-collate-and-remove-duplicates-example
Sheet: Sheet1

Code | Back/Foward Code | Back Figure | Forward Figure | Matched? |  |  |  | Back/Foward Code | Back Figure | Forward Figure
 |  |  |  | 1 | ^^^ | ^^^ |  | <>0
 |  |  |  | 1 | ^^^ | ^^^ |  |  | <>0
 |  |  |  | 1 | ^^^ | ^^^ |  |  |  | <>0
 |  |  |  | 1 | ^^^ | ^^^
 |  |  |  | 1 | ^^^ | ^^^
 |  |  |  | 1 | ^^^ | ^^^
 |  |  |  | 1 | ^^^ | ^^^
 |  |  |  | 1 | ^^^ | ^^^
 |  |  |  | 1 | ^^^ | ^^^
 |  |  |  | 1 | ^^^ | ^^^
 |  |  |  | 1 | ^^^ | ^^^
 |  |  |  | 1 | ^^^ | ^^^
 |  |  |  | 1 | ^^^ | ^^^
 |  |  |  | 1 | ^^^ | ^^^
 |  |  |  | 1 | ^^^ | ^^^
 |  |  |  | 1 | ^^^ | ^^^
 |  |  |  | 1 | ^^^ | ^^^
Spreadsheet: 698766d1602167997-if-this-then-that-formula-2020-inventoryb
Sheet: 401 

DEPARTMENT
INVENTORY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EQ Type
Name: | [NAME] |  | Employee No: | 403 |  | Unit No: |  | 133-19 |  | Date: | 2020-10-07 00:00:00 |  |  |  |  |  |  |  |  | Baton - Expandable
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Camera Digital
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Camera Video
Equipment Type: | Make: | Model: | Year: | Serial: | Red No: | Blue No: | Blue/Silver | OAN: | Employee No. | Unit No: | Date |  |  |  |  |  |  |  |  | Camera Video In Car System
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flashlight
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Helmet - Motorcycle
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Helmet - Riot
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Radar Unit
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Radio Mobile - UHF  (EMS)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Radio Mobile - VHF  (LE)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Radio Portable UHF (EMS)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Radio Portable VHF (LE)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Radio Scanner
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vehicle
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weapon - Handgun
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weapon - Rifle
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weapon - Shotgun
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weapon - Taser
Spreadsheet: 884679d1733926697-formula-for-empty-cells-esito2
Sheet: Foglio1

casi |  | pos. |  | [NAME]. |  | in corso
 |  | pos. |  | [NAME]. |  | in corso
caso | esito
1 | 2°
2 | 3° |  |  | =CONTA.NUMERI(B4:B2493)
3 | 5°
4 | 2° |  | in cell D1 count the numbers in column B4:B2500 the numbers in column B are like this 1°/10° etc.
5 | 12°
6 | 8°
7 | 6° |  | in H1 how many yellow cells are there in column B4:B2500 if there is a value in column A
8 | 3°
9 | 9°
10 | 2°
11 | 9°
12 | [NAME].
13 | 4°
14 | 10°
15 | 8°
16 | 1°
17 | 1°
18 | 10°
19 | 2°
20 | 7°
21 | 12°
22 | 12°
23 | 6°
24 | 5°
25 | 10°
26 | 2°
27 | [NAME].
28 | 7°
29 | 9°
30 | 1°
31 | 1°
32 | 2°
33 | 8°
34 | 12°
35 | 6°
36 | [NAME].
37 | 2°
38 | 11°
39 | 9°
40 | 9°
41 | 4°
42 | 3°
43 | 4°
44 | 4°
45 | 4°
46 | 4°
47 | 5°
48 | 8°
49 | 11°
50 | 3°
51 | 2°
52 | 7°
53 | 2°
54 | 1°
55 | 3°
56 | 2°
57 | 7°
58 | 7°
59 | [NAME].
60 | 1°
61 | 9°
62 | 8°
63 | 6°
64 | [NAME].
65 | 1°
66 | 6°
67 | 5°
68 | 4°
69 | 11°
70 | 1°
71 | 2°
72 | 12°
73 | 7°
74 | 2°
75
76 | 9°
77
78 | 1°
79 | 11°
80 | 4°
81
82 | 5°
83 | 10°
84 | 8°
85 | 2°
86 | 1°
87
88 | 4°
89
90 | 3°
91 | 4°
92 | 4°
93
94 | 2°
95 | 4°
96 | 4°
97 | 5°
98 | 2°
99
100
101 | 4°
102
103
104
105
106 | 1°
107 | 4°
108
109 | 5°
110
111 | 2°
112 | 3°
113
114 | 2°
115
116 | 3°
117
118 | 2°
119
120 | 2°
121 | 1°
122 | 1°
123
124
125
126 | 1°
127 | 1°
128
129
130
131
132
133
134
135
136
137 | 1°
138
139
140
141
142
143
Spreadsheet: 100572d1298913477-adding-up-totals-from-drop-down-list-slections-sumif-craigbruce-ef766340-sdg10
Sheet: Drop Down Boxes

Payment Form | classes | classprice | name
x | x | 0 | x
Cash | Pilates Non Member | 7 | [NAME]
Cheque | Pilates Member | 4 | [NAME]
Card | Stretch & Tone | 3.5 | [NAME]
 | Circuits | 3.5 | Kia
 | Boxercise | 3.5
 | Aerobics | 3.5
Spreadsheet: 0f9c83ee-add7-4056-afa4-47aaa765bdae
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688857622 | Dara Maclean | Home | 2012-07-24 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Word Records | 80688857523 | Dara Maclean | Yours Forever | 2013-01-18 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Spreadsheet: 731050d1620139907-conditional-format-project-timeline-based-on-milestone-in-sub-task-preliminary-class-schedule
Sheet: Holiday

 | Holiday | Week Date
 | Independence Day | 2021-07-05 00:00:00
 | Labor Day | 2021-09-06 00:00:00
 | Thanksgiving | 2021-11-25 00:00:00
 | Christmas | 2021-12-24 00:00:00
 | New Year | 2021-12-31 00:00:00 | estimated date
 | Memorial Day | 2022-05-30 00:00:00
 | Independence Day | 2021-07-04 00:00:00
 | Labor Day | 2022-09-05 00:00:00
 | Thanksgiving | 2022-11-24 00:00:00
 | Christmas | 2022-12-26 00:00:00
Spreadsheet: 871209d1717600015-trouble-creating-dependent-drop-down-lists-best-way-to-go-about-this-health-tracking
Sheet: Dropdown Data

 |  | Bellwood;Toronto, ON | Edgewood;Nanaimo,BC | Homewood;Guelph, ON | Homewood-Ravensview;Saanich,BC
 |  | [NAME] Days | Core Addiction & Mental Health Program,70 Days | Addiction Medicine Program Mood Anxiety & Concurrent Program, 70 Days | [NAME] and Addiction Program,11 Days
 |  | Bell1,7 Weeks | Edge1,4 weeks | Home1, 20 days | Homeraven1,45 Days
 |  | Bell2,60 Days | Edge2,7 days | Home2, 9 days
 |  | Bell3,40 Days | Edge3,30 Days
 |  | Bell4,8 Weeks | Edge4,40 days
 |  | ↑ I thought with this table I could use the headers as a dropdown list.  I thought that because there is so much information to pack in, I could separate it with delimiters, and just extract the data I needed.  It did not work with Data validation dropdown lists.
 |  | Program Location | Program Name | Length
 |  | [NAME] | [NAME] Program | 56 Days
 |  | [NAME] | Duplicate Name | 50 days
 |  | Edgewood | Core Addiction & Mental Health Program | 50 Days
 |  | Homewood | Addiction Medicine Program Mood Anxiety & Concurrent Program | 63 Days
 |  | Homewood - Ravensview | [NAME] and Addiction Program | 9 Weeks
 |  | Homewood - Ravensview | Duplicate Name | 10 days
 |  | ↑ With this table, I'm able to organize the data easily, but I cannot get the drop downs to link properly.