tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 114381d1310130644-pivot-table-calculation-book2
Sheet: Data

What is your favorite color? | What is your favorite lunch meat? | In which state were you born?
Blue | Turkey | Ohio
Blue | Turkey | Tennessee
Blue | Ham | Tennessee
Red | Ham | Tennessee
Yellow | Ham | Texas
Yellow | Roast Beef | Ohio
Yellow | Roast Beef | Texas
Green | Pastrami | Texas
Green | Pastrami | Tennessee
Orange | Roast Beef | Tennessee
Blue | Pastrami | Ohio
Blue | Ham | Tennessee
Yellow | Ham | Texas
Yellow | Roast Beef | Tennessee
Green | Pastrami | Tennessee
Yellow | Roast Beef | Ohio
Yellow | Pastrami | Tennessee
Green | Pastrami | Ohio
Green | Pastrami | Ohio
Orange | Roast Beef | Texas
Yellow | Pastrami | Texas
Green | Ham | Tennessee
Spreadsheet: 880760d1728621149-find-latest-date-in-excel-based-on-multiple-conditions-testing-example
Sheet: Sheet3

Test | Date | Done | NEED |  | open |  | Test | Date most recent
ABC | 2024-08-01 00:00:00 | Open | Most Recent
ABC | 2024-07-01 00:00:00 | Closed
ABC | 2024-06-01 00:00:00 | Closed
LMN | 2024-02-02 00:00:00 | Closed
LMN | 2024-03-02 00:00:00 | Open | No
LMN | 2024-04-02 00:00:00 | Closed
QRS | 2024-09-03 00:00:00 | Closed
QRS | 2024-07-03 00:00:00 | Closed
QRS | 2024-05-03 00:00:00 | Open | No
XYZ | 2021-01-04 00:00:00 | Open | No
XYZ | 2021-05-03 00:00:00 | Closed
XYZ | 2021-07-07 00:00:00 | Open | No
XYZ | 2021-09-12 00:00:00 | Closed
Spreadsheet: 164965d1340973328-can-do-in-access-cant-in-excel-auctionsample
Sheet: Sheet1

Street No | Street Name | Street Type | City | Zip | OwnerLName | OwnerFName | [NAME] | County | Open Bid
799 | Steele | Dr | Hampton | 30228 | [NAME] | [NAME] | McCurdy & Candler, L.L.C. 07-11137 | HENRY | 1
404 | Preakness | Ln | Mcdonough | 30252 | Almeida | [NAME] | McCurdy & Candler, L.L.C. 08-06169 | HENRY | 1
129 | [NAME] | Dr | Hampton | 30228 | Salvador | [NAME] | McCurdy & Candler, L.L.C. 08-09467 | HENRY | 1
1025 | Odelle | Cir | Mcdonough | 30253 | Black | [NAME] | McCurdy & Candler, L.L.C. 08-13325 | HENRY | 1
170 | Old Mill | Dr | Locust Grove | 30248 | Puzder | Debbie J  and [NAME] | McCurdy & Candler, L.L.C. 08-14869 | HENRY | 1
2060 | Tudor | Dr | Mcdonough | 30253 | Woodruff | [NAME] | McCurdy & Candler, L.L.C. 08-22603 | HENRY | 170796
109 | Watkins Glen | Dr | Mcdonough | 30252 | Morgan | [NAME] | McCurdy & Candler, L.L.C. 08-23440 | HENRY | 414839.44
1953 | Hampton Locust Grove | Rd | Locust Grove | 30248 | Harper | [NAME] | McCurdy & Candler, L.L.C. 08-28888 | HENRY | 1
115 | Sterling | Ave | Mcdonough | 30252 | [NAME] | [NAME] and Melisa | McCurdy & Candler, L.L.C. 09-04225 | HENRY | 5
860 | Brisley | Cir | Hampton | 30228 | Bergin | Eldred | McCurdy & Candler, L.L.C. 09-09647 | HENRY | 166758
700 | Bethpage | Dr | Mcdonough | 30253 | Knight | Bernard | McCurdy & Candler, L.L.C. 09-11866 | HENRY | 1
831 | Cog | Hl | Mcdonough | 30253 | Carrandi | [NAME] | McCurdy & Candler, L.L.C. 09-16381 | HENRY | 5
166 | Old Stonewall | Dr | Locust Grove | 30248 | George | Melinda  and [NAME] | McCurdy & Candler, L.L.C. 09-19367 | HENRY | 5
1704 | Rising View | Cir | Mcdonough | 30253 | Roe | [NAME] | McCurdy & Candler, L.L.C. 09-25579 | HENRY | 5
Spreadsheet: 777443d1650381906-how-can-you-give-back-a-value-when-it-might-not-be-the-first-to-be-shown-question-ellen
Sheet: question

name | items | tag |  |  | result | tag
ellen | 1 |  |  |  |  | [NAME]
ellen | 2 | [NAME] |  |  | [NAME] | blie
[NAME] | 3 | blie |  |  | Bianca | bloe
[NAME] | 4 |  |  |  | emiel | blue
Bianca | 5
Bianca | 6 | bloe
emiel | 7 | blue
emiel | 8
Spreadsheet: 265532d1379317268-setting-text-to-date-arnevos
Sheet: Blad1

Datum | Converted1 | Converted2 | Converted3
01/01/2013
02/01/2013
02/01/2013
02/01/2013
02/01/2013
03/01/2013
03/01/2013
03/01/2013
Spreadsheet: 600545d1543838347-adding-a-value-to-last-cell-in-a-column-rotas-1
Sheet: Week 2

Shift Information
Period 3 Wk 2 |  | 43436 |  | 43437 |  | 43438 |  | 43439 |  | 43440 |  | 43441 |  | 43442 |  | Contacted Hrs |  | KEY:
Area | Day | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  |  |  |  | Shift Request
 | Name | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM |  |  |  | Time off Request
MGMT | Rich | 8-4 |  | [NAME] |  | x |  | x |  | 12-10 |  | 12-10 |  | 12-10 |  | 48 |  |  | Unavailable
 | Kiran |  |  |  |  | 12-10 |  | 9-6 |  | 9-6 |  | 3-f |  | 12-10 |  | 48 |  |  | Training
 | [NAME] | 11-7 |  | x |  | x |  | x |  | 3-f |  | 12-10 |  | 8-6 |  | 48 |  | WS | Wet Stock
 | Lesley |  |  | x |  | 9-6 |  | x |  | x |  | 8:30-10 |  | 12-f |  | 48 |  |  | Meeting
SS | [NAME] | 8-6 | x | x | 3-f | x | x | x | x |  |  |  |  |  |  | 40 |  | FT | Full Timer
 | Meg | x | 4-f | x | x | x | x | x | 3-f |  |  |  |  |  |  | 40 |  | PT | Part Timer
 | [NAME] | 1 | 9 | 9-6 | x | x | 3-f | 12 | 10 | x | x | x | x |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SS | Shift Supervisor (Management Shifts where Required)
Set Shifts | Kelly |  |  |  |  |  |  |  | 6-f |  | 6-f |  | 6-f |  |  | 16 |  | NS | New Starter Required
 | [NAME] |  |  | 10-6 |  | 10-6 |  | 10-6 |  |  |  |  |  |  |  | 24 |  | BD | [NAME] |  | 9am-1pm
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 | Pennie |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  | Working at alternative Site
FT | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
 | Zoe |  |  | BD |  |  |  |  |  |  |  |  |  |  |  | 35
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
 | George |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
PT | Chloe |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
>18yo | Erin |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
Seasonal | Eve |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Polly |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | PAR | 8 | 5 | 4 | 4 | 4 | 4 | 4 | 6 | 4 | 7 | 5 | 9 | 7 | 10
Alfie Bookings:
Sales Forecast: |  | 7500 |  | 2600 |  | 3200 |  | 3900 |  | 5300 |  | 8300 |  | 9200
Additional Information |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Hrs
Spreadsheet: 00e48444-182b-4950-a0ee-68ad8609ab61
Sheet: Course Totals

MSJC Dual Enrollment Total by Course | Success Rates
Click Back to Subject Totals
Course | AY11-12 |  |  | AY12-13
Dual Enrollment Courses | SU11 | FA11 | SP12 | SU12 | FA12 | SP13
ART-101 |  | 0.9411764705882353
ART-102 |  |  | 0.9166666666666666
ASL-103 |  | 1 |  |  | 0.9583333333333334
ASL-104 |  |  | 1 |  |  | 1
BADM-103 |  |  |  |  |  | 0.8333333333333334
BIOL-117 |  |  | 0.9629629629629629 |  |  | 1
ENGL-101 |  | 0.9310344827586207 |  |  | 0.9566666666666667
ENGL-103 |  |  | 0.9553571428571429 |  |  | 0.91796875
ENVS-101 |  | 1 |  |  | 1
GUID-100 |  |  |  |  | 0.7857142857142857
HIST-111 |  | 0.9615384615384616 |  |  | 0.873015873015873
HIST-112 |  |  | 0.96 |  |  | 0.9365079365079365
HS-121 |  |  |  |  | 0.8947368421052632
HS-123 |  |  |  |  |  | 0.7142857142857143
MATH-105 |  | 0.9426751592356688 |  |  | 0.9151943462897526
MATH-110 |  | 1 | 0.9591836734693877 |  | 0.9 | 0.9274193548387096
MATH-211 |  | 0.6923076923076923 | 0.6470588235294118 |  | 0.8571428571428571 | 0.75
MATH-212 |  |  | 1 |  |  | 0.8333333333333334
MUL-110 |  | 0.8064516129032258 |  |  | 0.9285714285714286 | 1
MUL-123 |  |  |  |  |  | 1
[NAME] |  | 1 |  |  | 0.8333333333333334
MUL-137 |  |  |  |  |  | 1
MUS-100 |  |  |  |  |  | 1
MUS-103 |  |  |  |  | 0.9333333333333333
PS-101 |  |  |  |  | 1
PSYC-101 |  | 1 | 0.875 |  | 0.9736842105263158 | 0.96
SPAN-101 |  | 0.9789473684210527 |  |  | 1
SPAN-102 |  |  | 0.9782608695652174 |  |  | 1
Spreadsheet: bad83ff0-993c-404c-8df8-44c903207d0d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Annual Rate for Housing Units Started: United States
 |  | Seasonally Adjusted Total Units [Thousands of Units]
 |  | Period: 2006 to 2012
 |  | Data Extracted on: September 3, 2014 (3:25 am)
Period | Value
Jan-2006 | 2273
Feb-2006 | 2119
Mar-2006 | 1969
Apr-2006 | 1821
May-2006 | 1942
Jun-2006 | 1802
Jul-2006 | 1737
Aug-2006 | 1650
Sep-2006 | 1720
Oct-2006 | 1491
Nov-2006 | 1570
Dec-2006 | 1649
[NAME] | 1409
Feb-2007 | 1480
Mar-2007 | 1495
Apr-2007 | 1490
May-2007 | 1415
Jun-2007 | 1448
Jul-2007 | 1354
Aug-2007 | 1330
Sep-2007 | 1183
Oct-2007 | 1264
Nov-2007 | 1197
Dec-2007 | 1037
Jan-2008 | 1084
Feb-2008 | 1103
Mar-2008 | 1005
Apr-2008 | 1013
May-2008 | 973
Jun-2008 | 1046
Jul-2008 | 923
Aug-2008 | 844
Sep-2008 | 820
Oct-2008 | 777
Nov-2008 | 652
Dec-2008 | 560
Jan-2009 | 490
Feb-2009 | 582
Mar-2009 | 505
Apr-2009 | 478
May-2009 | 540
Jun-2009 | 585
Jul-2009 | 594
Aug-2009 | 586
Sep-2009 | 585
Oct-2009 | 534
Nov-2009 | 588
Dec-2009 | 581
[NAME] | 614
[NAME] | 604
Mar-2010 | 636
Apr-2010 | 687
[NAME] | 583
[NAME] | 536
[NAME] | 546
Aug-2010 | 599
Sep-2010 | 594
Oct-2010 | 543
Nov-2010 | 545
Dec-2010 | 539
Jan-2011 | 630
Feb-2011 | 517
Mar-2011 | 600
Apr-2011 | 554
May-2011 | 561
Jun-2011 | 608
Jul-2011 | 623
Aug-2011 | 585
Sep-2011 | 650
Oct-2011 | 610
Nov-2011 | 711
Dec-2011 | 694
Jan-2012 | 723
Feb-2012 | 704
Mar-2012 | 695
Apr-2012 | 753
May-2012 | 708
Jun-2012 | 757
Jul-2012 | 740
Aug-2012 | 754
Sep-2012 | 847
Oct-2012 | 915
Nov-2012 | 833
Dec-2012 | 976
Spreadsheet: 116490d1311866209-duplicate-value-in-pivot-tabel-help-pipelength
Sheet: Sheet1

Name | Length
[NAME] | 201
Fred | 201 |  | Row Labels | Count of Length | Sum of Length2
[NAME] | 100 |  | 90 | 1 | 90
[NAME] | 502 |  | 100 | 1 | 100
Billy | 678 |  | 155 | 1 | 155
[NAME] | 400 |  | 400 | 1 | 400
[NAME] | 90 |  | 502 | 1 | 502
[NAME] | 201 |  | 678 | 1 | 678
Sue | 201 |  | Grand Total | 6 | 1925
[NAME] | 155
Spreadsheet: 156305d1337261369-if-statement-05172012-help-with-if-statement
Sheet: Sheet1

2010-05-14 00:00:00
CURRENT TECH DATE | CNT | FDIC reimbursement %
 | 1
 | 1
 | 1
 | 1
 | 1
2011-12-17 00:00:00 | 1
 | 1
 | 1
2006-02-06 00:00:00 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
2009-11-04 00:00:00 | 1
Spreadsheet: 263520d1378500352-trying-to-create-a-spreadsheet-with-3-variables-dummy-worksheet-letter-names
Sheet: Sheet4

Date | Name | Sum of Score
2013-09-02 00:00:00 | [NAME] | 1
 | [NAME] | 2
 | [NAME] | 2
 | [NAME] | 2
2013-09-09 00:00:00 | [NAME] | 2
 | [NAME] | 4
 | [NAME] | 4
 | [NAME] | 4
Spreadsheet: 55943d1256093544-vllokup-formula-setup-vlookup1
Sheet: Sheet2

6BALL
7BALL
8BALL
B1238
B1239
B1240
B1241
B1243
B1244
B1246
B1247
B1248
[NAME]
B1252
B1253
[NAME]
BOX028
BOX040
BOX053
BOX063
[NAME]
BOX073
BOX090
BOX110
CAB030
CAB040
CAB050
CAB060
CAB080
CAB100
CG050
[NAME]
CG100
CG120
CG150
CG180
CG220
DB012-07
DB012-08
DB014-07
DB014-08
DB018-07
DB018-08
DB023-07
DB023-08
E1256
E1257
E1258
E1259
E1265
E1322
E422
E423
E424
E425
E428
FN413-07
FN413-16
FN413-18
FN413-20
FN414-07
FN414-16
FN414-18
FN414-20
FN415-16
FN415-18
FN415-20
FN416-16
FN416-18
FN416-20
FN417-16
FN417-18
FN418-16
FN418-18
FN419-16
FN419-18
FN420-17
FN421-16
FN421-18
FN430
FN431
FN432-07
FN432-17
FN433-07
FN433-17
[NAME]
FN436-07
FN436-08
FN437-07
FN437-08
[NAME]
FN440
FN442-08
FN442-26
FN443-08
FN443-24
FN444-08
FN444-24
FN445
[NAME]
FN453
FN457
FN458
[NAME]
FN470
FN477
FN490
FN491
FN492
FN493
FN494
FN495
FN497
FN503
FN504
FN505
FN507-17
FN508
FN510
FN511
FN512
FN514
FN515
FN516
FN518-07
FN518-18
FN520
FN523
[NAME]
FN526
FN535-07
FN535-17
FN537
FN538
FN541
FN542-07
FN542-18
FN543-07
FN543-18
FN544-07
FN544-17
FN545-07
FN545-17
FN549-07
FN549-17
FN550-07
FN550-17
FN551-07
FN551-17
FN553
FN556
FN557
FN560
FN561
FN562
FN563
FN566
FN567
FN568-07
FN568-18
FN571-07
FN571-17
FN575-17
FN576-07
FN576-17
FN577-07
FN578-07
FN578-17
FN579-07
FN579-17
FN581
FN584
FN587-17
FN588-07
FN588-17
FN600
FN600-07
FN601
FN602
FN602-07
FN604
FN605-07
FN606
[NAME]
FN608
[NAME]
FN610
FN631
FN632
FN633
FN634
FN635-07
FN635-18
FN636-18
FN637-07
FN637-17
FN638-07
FN638-18
FR040
FR050
G2002
G2003
G2006
G2011
G2013
G2014
G2015
[NAME]
G2017
G2020
G2024
G2026
G2028
G2030
G2037
[NAME]
G2040
G2042
G2043
G2046
G2047
G2049
G2050
G2051
G2052
G2056
G2057
G2058
G2059
G2060
G2061
G2063
G2065
G2066
G2067
G2068
G2070
G2071
G2072
G2073
G2074
G2075
G2077
G2078
[NAME]
G2080
[NAME]
[NAME]
G2083
G2085
G2093
G2094
G2095
G2097
G2100
G2101
G2126
G2132
G2133
G2134
G2135
LBOX040
OCB063
OCT1A
OCT1B
PG108
PG109
SC020
[NAME]
SC035
TM080
[NAME]
TR012-07
TR012-08
TR014-07
TR014-08
TR018-07
TR018-08
TT120
TT150
TURK1
TURK3
TURKH
WBOX028
WBOX045
WBOX053
WBOX063
WBOX068
[NAME]
WCAB040
WCAB050
WCAB060
WDB018-07
WDB018-08
WFR040
WFR050
WOCB063
WPVCG065
WPVCG080
WPVCG100
WPVCG120
WPVCG150
WSC025
WSC035
Spreadsheet: 718947d1613427225-fun-with-multiple-criteria-lookup-and-merged-cells-sample
Sheet: COVER

Entity >> | V - 6666
 | January | % age | YTD | % age
REVENUES
TOTAL: REVENUE
COST OF GOODS SOLD
STUFF
STUFF 1
STUFF 2
STUFF 3
Spreadsheet: 875014d1721558773-array-with-a-delayed-sequence-array-count-full-revised-21-7-2024
Sheet: Logistics (2)

 |  | variables |  |  |  |  |  |  |  | variables
 | intervals against 0 to 23 axis | 7 | << r in the formula in C10 |  |  |  |  |  | offset | 28 |  |  |  |  |  |  | Required
 | sequence from 1 to | 8 | << s in the formula in C10
 | columns in arrays | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I would like the formula that @windknife has already created in C10 to be amended such
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | that the countif formula in range C35:H35 equals those in range [NAME]:H37
 |  | ARRAY 1 |  |  |  |  |  |  |  | ARRAY 2 derived from ARRAY 1 |  |  |  |  |  |  | The countif formula is just there as a check - it shouldn't be included in any solution.
 |  | 1 | 2 | 3 | 4 | 5 | 6 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 0 |  | 0 | 7 | 2 | 0 |  |  | 0 |  | 0 | 4 | 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 | 1 | 0 | 7 | 2
 |  | 0 | 5 | 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
 |  | 2 | 0 | 8 | 3 | 0 |  |  |  | 0 | 0 | 5 | 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 | 2 | 0 | 8 | 3
 |  | 0 | 6 | 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
 |  | 3 | 0 | 1 | 4 | 0 |  |  |  | 0 | 0 | 6 | 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 | 3 | 0 | 1 | 4
 |  | 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
 |  | 4 | 0 | 0 | 5 | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<countif check
 |  | 5 | 3 | 3 | 4 | 0
Spreadsheet: 51865d1251464615-conditional-formatting-with-a-tolerance-clearance-times-1
Sheet: Sheet1

Incident Type | Baseline Clearance Time minutes) | October 08 Clearance Times
a | 22 | 25 |  | 20.9
b | 65 | 65
c | 54 | 76
d | 22 | 30
e | 86 | 32
f | 6 | 4
g | 12 | 24
h | 91 | 25
i | 103 | 104
j | 33 | 43
k | 46 | 20
l | 80 | 116
Spreadsheet: c2487cbc-4322-4273-8dcf-136e6120b378
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0000488 | Unnamed: 3 | Facility Name: | Unnamed: 5 | [NAME] | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Chatham | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 50060 | 31616 | 00610 | 00625 | 00620 | 00400 | 00530
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Total Residual Chlorine | Fecal Coliform | Ammonia | Total [NAME] | Nitrate | pH | Total Suspended Solids
 | 24-hr | hrs | GPD | mg/L | mg/L | #/100 mL | mg/L | mg/L | mg/L | su | mg/L
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Estimate | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab
Monthly Limit: |  |  | 2350
Daily Limit:
Sample Frequency: |  |  | Monthly | 3 x Year |  | 3 x Year | 3 x Year | 3 x Year | 3 x Year |  | 3 x Year
Spreadsheet: 216458d1361783055-automatic-values-show-in-cells-based-on-reference-worksheet
Sheet: Sheet1

 | Master Data
 | Meterials | Qty
 | Aluminum | 25
 | [NAME] | 50
 | Mica | 75
 | Rockwool | 100
 | Glass Frame | 125
 | Aluminum Frame | 150 | For sheet2 Click
 | Screw | 175
 | Srew tight | 200
 | washer | 225
Spreadsheet: 206472d1358195360-build-a-dynamic-named-range-from-criteria-dynamic-range-criteria
Sheet: Sheet1

Name | Manager | Role |  |  | Temp | Contract | Perm
a | [NAME] | Temp |  |  | In these columns, I need a list of Managers that will dynamicly update from the "raw" data, which in this case are columns a, b, and c.
b | [NAME] | Contract
c | [NAME] | Perm
d | [NAME] | Temp
e | [NAME] | Contract
f | Michelle | Perm
g | [NAME] | Temp
h | [NAME] | Temp
i | [NAME] | Contract
j | [NAME] | Perm
k | [NAME] | Temp
l | [NAME] | Contract
m | Michelle | Perm
n | [NAME] | Temp
o | [NAME] | Temp
p | [NAME] | Contract
q | [NAME] | Perm
r | [NAME] | Temp
s | [NAME] | Contract
t | Michelle | Perm
u | [NAME] | Temp
v | [NAME] | Temp
w | [NAME] | Contract
x | [NAME] | Perm
y | [NAME] | Temp
z | [NAME] | Contract
a | [NAME] | Temp
b | [NAME] | Contract
c | [NAME] | Perm
d | [NAME] | Temp
e | [NAME] | Contract
f | Michelle | Perm
g | [NAME] | Temp
h | [NAME] | Temp
i | [NAME] | Contract
j | [NAME] | Perm
k | [NAME] | Temp
l | [NAME] | Contract
m | Michelle | Perm
n | [NAME] | Temp
o | [NAME] | Temp
p | [NAME] | Contract
q | [NAME] | Perm
r | [NAME] | Temp
s | [NAME] | Contract
t | Michelle | Perm
u | [NAME] | Temp
v | [NAME] | Temp
w | [NAME] | Contract
x | [NAME] | Perm
y | [NAME] | Temp
z | [NAME] | Contract
Spreadsheet: 120267d1315147928-share-data-and-formatting-between-two-sheets-autofilterexample
Sheet: Sheet1

Name | Product | Date | y/n
[NAME] | Widget1 | 2011-01-06 00:00:00 | y
[NAME] | Widget1 | 2011-01-07 00:00:00 | n
[NAME] | Widget2 | 2011-01-07 00:00:00 | n
[NAME] | Widget3 | 2011-07-31 00:00:00 | y
[NAME] | Widget2 | 2011-08-04 00:00:00 | y
Spreadsheet: 694663d1599739282-formula-to-minus-preivious-figure-if-culomn-a-value-is-the-same-example
Sheet: Sheet1

route | van |  |  |  |  | Material Cost |  | Fuel Costs | FuelCost
BASILDON | 800 |  |  |  |  | 304.29 |  |  | 13.16
BASILDON | 800 |  |  |  |  | 1258.7 |  |  | 13.3
BURY ST EDMUNDS | 805 |  |  |  |  | 3728.98 |  |  | 6.02
BURY ST EDMUNDS | 805 |  |  |  |  | 329.44 |  |  | 6.16
SOUTHEND | 808 |  |  |  |  | 1568.77 |  |  | 14.28
A14 HUNTINGDON | 810 |  |  |  |  | 1893.86 |  |  | 12.18
NORWICH NORTH | 811 |  |  |  |  | 24.32 |  |  | 0.28
NORWICH NORTH | 811 |  |  |  |  | 453.9 |  |  | 0.56
NORWICH NORTH | 811 |  |  |  |  | 1380.22 |  |  | 1.4
A47  KINGS LYNN | 811 |  |  |  |  | 939.16 |  |  | 6.02
A47  KINGS LYNN | 811 |  |  |  |  | 800.71 |  |  | 7
A14 HUNTINGDON | 811 |  |  |  |  | 10.97 |  |  | 12.18
route | van |  |  |  |  | Material Cost |  | Fuel Costs | FuelCost
BASILDON | 800 |  |  |  |  | 304.29 |  | 13.16 | 13.16
BASILDON | 800 |  |  |  |  | 1258.7 |  |  | 13.3
BURY ST EDMUNDS | 805 |  |  |  |  | 3728.98 |  | 6.02 | 6.02
BURY ST EDMUNDS | 805 |  |  |  |  | 329.44 |  |  | 6.16
SOUTHEND | 808 |  |  |  |  | 1568.77 |  | 14.28 | 14.28
A14 HUNTINGDON | 810 |  |  |  |  | 1893.86 |  | 12.18 | 12.18
NORWICH NORTH | 811 |  |  |  |  | 24.32 |  | 0.28 | 0.28
NORWICH NORTH | 811 |  |  |  |  | 453.9 |  |  | 0.56
NORWICH NORTH | 811 |  |  |  |  | 1380.22 |  |  | 1.4
A47  KINGS LYNN | 811 |  |  |  |  | 939.16 |  |  | 6.02
A47  KINGS LYNN | 811 |  |  |  |  | 800.71 |  |  | 7
A14 HUNTINGDON | 811 |  |  |  |  | 10.97 |  |  | 12.18
Spreadsheet: 195684d1353599996-cell-formating-and-sheet-protection-gilwern-invoice-xlv1
Sheet: Sheet2

 |  | Invoice
 |  | Invoice Number
 |  | Date
 |  | Customer
 |  | Ordr Number
 |  | Invoice Address
 |  | Delivery/Site Address
 |  | Fixed Price Job | [NAME] |  |  |  | Quantity | Unit Price | Amount
 |  | Option 1 | As per our quotation reference:
 |  | Option 2 | As per customer order reference:
 |  | Other
 |  | Parts Supplied | Description |  |  |  | Quantity | Unit Price | Amount
 |  | Labour | Rate Detail |  |  |  | Quantity | Unit Price | Amount
 |  | First 1/2 Hour
 |  | Subsequent 1/2 Hours
 |  | Other
 |  | Comments: |  |  |  |  |  | Sub-total
 |  |  |  |  |  |  |  | Carriage
 |  |  |  |  |  |  |  | VAT
 |  |  | Thank you. We appreciate your business. |  |  |  |  | Grand Total
 |  | Deltapoint Services
 |  | VAT Registration: 922 5317 42
 |  | Bank Details: Santander, Sort 09-01-28, Act 36080651 |  |  |  |  |  | Internal Use Only
 |  | 1 Crossroads, Gilwern,[NAME], [NAME], NP7 0DX |  |  |  |  |  | Amount Paid:
 |  | Phone: [PHONE]                  Fax: [PHONE] |  |  |  |  |  | Date:
 |  | www.deltapointservices.net        email: [EMAIL]
Spreadsheet: eric_saibi__9812__9-23-01
Sheet: Cntrprty

Enpower Name | [NAME]
FRONTERAGENLP | [NAME]
[NAME] | LCRA
CALPINEENESER | Calpine
[NAME] | HLP
TENASKAPOWSER | TNSK
AMERELECPOWSER | AEP
MIRANTAMEENE | Mirant
RELIANTENESER | RES
CONSTELLPOWSOU | [NAME]
CITYBRYAN | BTU
AUSTINCITY | COA
CORALPOWLLC | Coral
EPMI-LT-ERCOT | [NAME]
TXUELECO | TXU
EPMI-ERCOT-ASST | [NAME]
[NAME] | Exelon
SOUTHTEXELE | STEC
CARGILLALLLLC | Cargil
DYNEGYPOWMAR | DYPM
BPENERGYCO | BP
FPLENEPOW | FPL
ELPASOMERLP | EPE
ANPMARCOM | ANP
Spreadsheet: 834378d1687778639-filling-empty-cells-with-random-values-from-a-list-test-sheet-5-
Sheet: Sheet1

Student Name | # OF CLASSES |  |  | TIME/TEACHER | [NAME] | [NAME] | CHRIS | JEWEL | CHLOE
Mark | 5 |  |  | 08:00 - 08:50
[NAME] | 5 |  |  | 09:00 - 09:50
[NAME] | 5 |  |  | 10:00 - 10:50
Hyacinth | 5 |  |  | 11:00 - 11:50
[NAME] | 5 |  |  | 11:50 - 13:00
Gayle | 5 |  |  | 13:00 - 13:50
[NAME] | 5 |  |  | 14:00 - 14:50
Zack | 5 |  |  | 15:00 - 15:50
 |  |  |  | 16:00 - 16:50
 |  |  |  |  | New result: Press F9
Spreadsheet: 757768d1638450813-filter-formula-over-multiple-sheets-permit-register-example-2-12-2021
Sheet: To Approve

ABC Job Number | Address | Description | Client | Permit  Number | BP | OP | Inspection Status | Job Notes
 | Address 4 | Description 4 | Client 4 | 001/001/004 | 2021-05-04 00:00:00 | APPROVE | 18/1/21 - Waterproofing | 0
ABC-21022 | Address 22 | Description 22 | Client 22 | 001/001/022 | APPROVE | OP | 26/1/21 - Final | 0
ABC-21026 | Address 26 | Description 26 | Client 26 | 001/001/026 | APPROVE | 0 | 27/1/21 - Slab & Footings | 0