tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 58872d1259158418-daily-repetitive-import-and-sort-macro-lookup-or-am-i-totally-on-the-wrong-track-book1
Sheet: SPEC

 | [NAME] | SKU NUMBER | SKU NAME | TRADED UNIT | ITEMS PER TRAY | ITEMS PER BATCH | BATCH WEIGHT KG | INGRED1 | INGRED2 | INGRED3 | INGRED4 | MEASURE TIME PER BATCH MINS | MIX TIME PER BATCH MINS | FILL TIME PER BATCH MINS | BAKE TIME PER BATCH MINS | SLICE TIME PER BATCH MINS | PACK TIME PER BATCH MINS
 | 1 | 100 | A | TRAY | 10 | 100 | 10 | 1 | 2 | 3 | 3 | 5 | 5 | 5 | 50 | 1 | 10
 |  |  | B | TRAY | 10 | 100 | 10 | 1 | 2 | 3 | 3 | 5 | 5 | 5 | 50 | 1 | 10
 |  |  | C | TRAY | 10 | 100 | 10 | 1 | 2 | 3 | 3 | 5 | 5 | 5 | 50 | 1 | 10
 |  |  | D | TRAY | 10 | 100 | 10 | 1 | 2 | 3 | 3 | 5 | 5 | 5 | 50 | 1 | 10
 |  |  | E | TRAY | 10 | 100 | 10 | 1 | 2 | 3 | 3 | 5 | 5 | 5 | 50 | 1 | 10
 |  |  | F | TRAY | 10 | 100 | 10 | 1 | 2 | 3 | 3 | 5 | 5 | 5 | 50 | 1 | 10
 |  |  | G | TRAY | 10 | 100 | 10 | 1 | 2 | 3 | 3 | 5 | 5 | 5 | 50 | 1 | 10
 |  |  | H | TRAY | 10 | 100 | 10 | 1 | 2 | 3 | 3 | 5 | 5 | 5 | 50 | 0 | 10
 |  |  | I | TRAY | 20 | 100 | 20 |  |  |  |  | 5 | 10 | 10 | 50 | 1 | 10
 |  |  | J | TRAY | 30 | 100 | 30 |  |  |  |  | 5 | 20 | 20 | 50 | 1 | 10
 | 11 | 999 | Z | TRAY | 20 | 100 | 20 |  |  |  |  | 5 | 10 | 10 | 50 | 0 | 10
Spreadsheet: 850596d1700975084-automatically-expand-formula-when-adding-coumns-book1-75-ans
Sheet: Sheet2

1 | 2 | 10
4 | 6 | 10
6 | 9 | 10 |  |  | Inserted  column 3
8 | 15 | 20
5 | 9 | 20
Spreadsheet: 170403d1343255908-odd-interpolation-problem-interpolation3
Sheet: Kullanıcı için Uygulama

 |  |  |  | 35
X | Y | [NAME] | [NAME]
4.853 | -40 | 5.005
4.798 | -35 | 4.927
4.726 | -30 | 4.848
4.633 | -25 | 4.77
4.518 | -20 | 4.692
4.376 | -15 | 4.614
4.205 | -10 | 4.536
4 | -5 | 4.457
3.776 | 0 | 4.379
3.522 | 5 | 4.301
3.25 | 10 | 4.223
2.965 | 15 | 4.145
2.676 | 20 | 4.066
2.392 | 25 | 3.988
2.118 | 30 | 3.91
1.86 | 35 | 3.832
1.623 | 40 | 3.754
1.408 | 45 | 3.675
1.216 | 50 | 3.597
1.048 | 55 | 3.519
0.901 | 60 | 3.441
0.775 | 65 | 3.363
0.667 | 70 | 3.284
0.573 | 75 | 3.206
0.494 | 80 | 3.128
0.425 | 85 | 3.05
0.367 | 90 | 2.972
0.318 | 95 | 2.893
0.276 | 100 | 2.815
0.24 | 105 | 2.737
0.209 | 110 | 2.659
0.182 | 115 | 2.581
0.16 | 120 | 2.502
0.14 | 125 | 2.424
0.124 | 130 | 2.346
0.109 | 135 | 2.268
0.097 | 140 | 2.19
0.086 | 145 | 2.111
0.076 | 150 | 2.033
 |  | 1.955
 |  | 1.877
 |  | 1.799
 |  | 1.72
 |  | 1.642
 |  | 1.564
 |  | 1.486
 |  | 1.408
 |  | 1.329
 |  | 1.251
 |  | 1.173
 |  | 1.095
 |  | 1.017
 |  | 0.938
 |  | 0.86
 |  | 0.782
 |  | 0.704
 |  | 0.626
 |  | 0.547
 |  | 0.469
 |  | 0.391
 |  | 0.313
 |  | 0.235
 |  | 0.156
 |  | 0.078
Spreadsheet: 169467d1342869873-countifs-statement-with-a-vlookup-as-well-countif-based-on-vlookup
Sheet: Totals

 | FY 09
 | 1st Qtr | 2nd Qtr | [NAME] | [NAME]
CA
IL
VT
AZ
OH
MA
OR
WY
 |  |  | SUMPRODUCT(VLOOKUP(Recieved!E:E,'Zip Codes'!'Zip Codes'!$C:$C,1,True))
 |  |  | COUNTIFS(VLOOKUP(Recieved!E:E,'Zip Codes'!$C$2$:C$11,3,true),,Recieved!I:I,2009,Recieved!J:J,1)
 | What I am trying to do is countif Received I:I, 2009 and Received J:J 1 and if Received E:E contains the first 5 numbers for the zip code for CA as marked in Zip Codes column C
Spreadsheet: a15a6a7b-512f-4d38-bf8f-603f4c283075
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 15 | 959 | 850 | 725 | 599
15 - 65 | 4630 | 4199 | 3721 | 3246
65 und mehr | 1611 | 1759 | 1940 | 2108
Insgesamt | 7200 | 6808 | 6386 | 5953
%
unter 15 | 13.31944444444444 | 12.48531139835488 | 11.35295959912308 | 10.06215353603225
15 - 65 | 64.30555555555556 | 61.67743830787309 | 58.2680864390855 | 54.52712917856542
65 und mehr | 22.375 | 25.83725029377203 | 30.37895396179142 | 35.41071728540231
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 20.71274298056155 | 20.24291497975709 | 19.4840096748186 | 18.45348120764017
Altenquotient | 34.79481641468682 | 41.89092641105025 | 52.13652244020425 | 64.9414664202095
Gesamtquotient | 55.50755939524839 | 62.13384139080733 | 71.62053211502284 | 83.39494762784966
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: d8a67612-1200-4532-ab6b-cab9afbd6061
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
36447922 | 2013-06-18 10:09:59 | ALLIES | 1 | 6 | 4 | 873251 | Flemish_Havy | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
36448025 | 2013-06-18 10:29:32 | AXIS | 1 | 6 | 2 | 873251 | Flemish_Havy | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
36448163 | 2013-06-18 10:47:48 | AXIS | 0 | 2 | 6 | 873251 | Flemish_Havy | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
36448235 | 2013-06-18 11:01:49 | ALLIES | 1 | 6 | 1 | 873251 | Flemish_Havy | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
36448306 | 2013-06-18 11:13:24 | ALLIES | 0 | 2 | 4 | 873251 | Flemish_Havy | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
36448354 | 2013-06-18 11:31:45 | AXIS | 0 | 3 | 4 | 873251 | Flemish_Havy | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
Spreadsheet: 828965d1683815542-if-date-is-between-two-dates-in-a-table-show-value-of-column-ifwithindaterange
Sheet: Sheet1

 |  |  | Days since Raise |  | Average Days Between Raises |  |  |  | I'd like this area to show the wage based upon the table to the right.
 |  |  |  | vvv User Filled |  | vvv User Filled |  |  |  | Wage By Month
 |  | Date | Days | Pay | Weekly Pay | Take Home Pay | Take Home % | Tax Rate |  | 2022-06-01 00:00:00
 |  | 2022-06-30 00:00:00 |  | 20 |  | 637.04 |  |  |  | 2022-07-01 00:00:00 | 20
 |  | 2022-11-21 00:00:00 |  | 22 |  | 699.71 |  |  |  | 2022-08-01 00:00:00 | 20
 |  |  |  |  |  |  |  |  |  | 2022-09-01 00:00:00 | 20
 |  |  |  |  |  |  |  |  |  | 2022-10-01 00:00:00 | 20
 |  |  |  |  |  |  |  |  |  | 2022-11-01 00:00:00 | 22
 |  |  |  |  |  |  |  |  |  | 2022-12-01 00:00:00 | 22
 |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 | 22
 |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00 | 22
 |  |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | 22
 |  |  |  |  |  |  |  |  |  | 2023-04-01 00:00:00 | 22
 |  |  |  |  |  |  |  |  |  | 2023-05-01 00:00:00 | 22
 |  |  |  |  |  |  |  |  |  | 2023-06-01 00:00:00 | 22
 |  |  |  |  |  |  |  |  |  | 2023-07-01 00:00:00 | 22
Spreadsheet: 878760d1726045457-referencing-multiple-sheet-inorder-to-create-pt-ekac-pl2-spill-indirect-365-aligw
Sheet: Pivot Table

Sheet Name > | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheets | Subjects
Subject > | Science |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lux | Math
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Science
 |  |  |  |  |  |  | Another way:
 |  |  |  |  |  |  | First convert the data into tables, naming the tables "Lux" and "[NAME]" respectively
 | Joshep |  |  |  |  |  | Then apply these formulas:
 | Aline |  |  |  |  |  | Name: =UNIQUE(INDIRECT(B1&"[Name]"))
 | [NAME] |  |  |  |  |  | Marks: =SUMIFS(INDIRECT(B1&"[Marks]"),INDIRECT(B1&"[Name]"),E5#,INDIRECT(B1&"[Subject]"),B2)
 |  |  |  |  |  |  | Name: =UNIQUE(FILTER(INDIRECT(B1&"[Name]"),INDIRECT(B1&"[Subject]")=B2))
 |  |  |  |  | Adding unique |  | filtering >1000
 |  |  |  | Name | Marks |  | Name | Marks
 |  |  |  | Shweta |  |  | Shweta
 |  |  | >>>>> | Check | 192 | >>>>>
Spreadsheet: 0c3f5b39-7628-4940-b7d5-b660832a339b
Sheet: Sheet1

[NAME] | ADDRESS | TYPE | CITY | ZIP | VERSION
Fred's Downtown Philly | 740 S Greenville # 400 | INSIDE | [NAME] | 75002 | [NAME]
Escape Donuts | 600 E Bethany Rd | BOX | [NAME] | 75002 | [NAME]
Little Caesars | 806 S [NAME] | BOX | [NAME] | 75002 | [NAME]
Comerica | 1610 E Stacy Rd | BOX | [NAME] | 75002 | [NAME]
Subway | 1546 E Stacy Rd  #150 | BOX | [NAME] | 75002 | [NAME]
[NAME]'s Donuts | 1228 Exchange Pkwy #106 | BOX | [NAME] | 75013 | [NAME]
Young Donuts | 1201 E Main St #280 | BOX | [NAME] | 75002 | [NAME]
Cakes and Donuts | 803 E Main St | BOX | [NAME] | 75002 | [NAME]
Allen Community Center | 801 E Main St | BOX | [NAME] | 75002 | [NAME]
The House Café | 600 E Main | INSIDE | [NAME] | 75002 | [NAME]
Jalapeno's Mexican Restaurant | 121 N Greenville | INSIDE | [NAME] | 75002 | [NAME]
Allen Bible Church | 109 N Greenville Ave | BOX | [NAME] | 75002 | [NAME]
Elk's Market Café | 105 N Greenville Ave #11 | INSIDE | [NAME] | 75002 | [NAME]
[NAME] of Commerce | [NAME] | BOX | [NAME] | 75013 | [NAME]
[NAME]'s Deli | 502 W McDermott Dr | BOX | [NAME] | 75013 | [NAME]
Allen Municipal Court House | 301 Century Pkwy | BOX | [NAME] | 75013 | [NAME]
MexiGo Grill | 533 W McDermott Dr | BOX | [NAME] | 75013 | [NAME]
Wing Stop | 543 W McDermott | BOX | [NAME] | 75013 | [NAME]
[NAME] in the Box | 804 W McDermott Dr | BOX | [NAME] | 75013 | [NAME]
5th Street Pizza | 1223 W McDermott Dr | BOX | [NAME] | 75013 | [NAME]
Trade [NAME] | 1007 W [NAME] Dr | BOX | [NAME] | 75013 | [NAME]
Presbyterian Hospital | 1105 N Central Expy | BOX | [NAME] | 75013 | [NAME]
Nate's Seafood | 190 Story # 1800 | INSIDE | [NAME] | 75002 | [NAME]
Spreadsheet: 113922d1309811610-search-function-in-price-list-price-list
Sheet: Sheet1

range | 0 - 60 | 61 - 120 | 121 - 170 | 171 - 220 | 221 - 270 | 271 - 320 | 321 - 420 | 421 - 520 | 521 - 620
country | 60 | 120 | 170 | 220 | 270 | 320 | 420 | 520 | 620
BE | 0.55 | 0.55 | 0.55 | 0.6 | 0.75 | 0.9 | 1.13 | 1.44 | 1.11
CZ | 0.26 | 0.36 | 0.46 | 0.54 | 0.78 | 0.78 | 0.82 | 0.87 | 0.86
ES | 0.51 | 0.51 | 0.58 | 0.58 | 0.86 | 0.98 | 1.11 | 1.1 | 1.09
FR | 0.42 | 0.37 | 0.44 | 0.5 | 0.63 | 0.76 | 0.93 | 1.13 | 1.23
[NAME] | 0.26 | 0.36 | 0.46 | 0.54 | 0.78 | 0.78 | 0.82 | 0.87 | 0.86
PL | 0.74 | 0.74 | 0.74 | 0.81 | 1.01 | 1.22 | 1.53 | 1.94 | 1.5
SE | 0.45 | 0.39 | 0.51 | 0.66 | 0.7 | 0.84 | 1.04 | 1.27 | 1.35
RU | 0.5 | 0.5 | 0.5 | 0.55 | 0.69 | 0.83 | 1.04 | 1.32 | 1.02
MAIL | WEIGHT | PRICE
FR | 20 | ??
FR | 100 | ??
BE | 200 | ??
RU | 200 | ??
SE | 300 | ??
FR | 362 | ??
FR | 428 | ??
BE | 494 | ??
RU | 560 | ??
SE | 626 | ??
FR | 692 | ??
FR | 758 | ??
Spreadsheet: 878995d1726405896-auto-number-generate-with-conditions-tps_srno_1509
Sheet: tbl_Data

Deno | Attribute | Value | Time | Rank
111 | [NAME] | 2024-01-01 00:00:00 |  |  |  |  | IF([@Attribute]="Receipt Dt",SUM([@Value],[@Deno]/10000),SUM([@Value],0.99))
111 | [NAME] | 2024-01-01 00:00:00
222 | [NAME] | 2024-01-01 00:00:00
111 | Return Dt | 2024-01-01 00:00:00
222 | Return Dt | 2024-01-01 00:00:00
444 | [NAME] | 2024-01-02 00:00:00
444 | [NAME] | 2024-01-02 00:00:00
555 | [NAME] | 2024-01-02 00:00:00
111 | Return Dt | 2024-01-02 00:00:00
444 | Return Dt | 2024-01-02 00:00:00
444 | Return Dt | 2024-01-02 00:00:00
555 | Return Dt | 2024-01-02 00:00:00
Spreadsheet: 683117d1592493309-inventory-with-ability-to-exclude-transactions-by-date-chemical-inventory
Sheet: Scottsbluff

Invoice # | Date | Grower/Reference | Transaction | Product | Quantity | Agriculturist
 | 2020-06-09 00:00:00 |  | Adjustment | [NAME] (2x2.5 gal) | 2.5 | MB
 | 2020-06-09 00:00:00 |  | Adjustment | Choice Weathermaster (2x2.5 gal) | 122.5 | MB
 | 2020-06-09 00:00:00 |  | Adjustment | Ethofumesate 4SC (2x2.5 gal) | 400 | MB
 | 2020-06-09 00:00:00 |  | Adjustment | Glystar Plus (2x2.5 gal) | 160 | MB
 | 2020-06-09 00:00:00 |  | Adjustment | Maximizer (2x2.5 gal) | 180 | MB
 | 2020-06-09 00:00:00 |  | Adjustment | [NAME] (2.5 gal) | 160 | MB
 | 2020-06-09 00:00:00 |  | Adjustment | [NAME] (2x2.5 gal) | 27.5 | MB
 | 2020-06-09 00:00:00 |  | Adjustment | [NAME] | 3 | MB
 | 2020-06-15 00:00:00 |  | Received from [NAME] | Mad Dog 5.4 (Bulk) | 130 | MAR | [NAME] for Ernie Douglas
33252 | 2020-06-10 00:00:00 | [NAME] | Sale | Glystar Plus (2x2.5 gal) | -20 | MAR | [NAME]
33253 | 2020-06-11 00:00:00 | Western Sugar- Piling Grounds | Sale | Glystar Plus (2x2.5 gal) | -2.5 | MAR | [NAME]
33253 | 2020-06-11 00:00:00 | Western Sugar- Piling Grounds | Sale | [NAME] (2x2.5 gal) | -2.5 | MAR | [NAME]
33254 | 2020-06-11 00:00:00 | Western Sugar- Agriculturlist | Sale | [NAME] | -2 | MAR | [NAME] Ticket
33255 | 2020-06-15 00:00:00 | Blackshirt Express LLC | Sale | [NAME] (2x2.5 gal) | -5 | MAR
33256 | 2020-06-15 00:00:00 | Coxbill Farms | Sale | Bedliner | -21 | MAR | [NAME]
Spreadsheet: 867494d1714373027-filter-sort-names-example
Sheet: Sheet1

Store |  | Net Sales
222 | [NAME] | 144993.0699999999
224 | Derby | 54838.23999999982
223 | coventry | 52849.64999999963
41 | Northampton | 33246.96999999986
100 | Hinckley | 31793.77999999986
13 | Bedworth | 30716.35999999987 |  |  | Trying to achieve these list but on separate pages
125 | Ullesthorpe | 18136.48999999999
 |  |  |  |  | 222 | [NAME] | 144993.0699999999
 |  |  |  |  | 222 | [NAME] | 139175.7399999992
222 | [NAME] | 139175.7399999992 |  |  | 222 | [NAME] | 151237.9000000001
224 | Derby | 55068.75999999979
223 | Coventry | 51267.03999999968 |  |  | 224 | Derby | 54838.23999999982
41 | Northampton | 32718.91999999988 |  |  | 224 | Derby | 55068.75999999979
100 | Hinckley | 32187.8899999999 |  |  | 224 | Derby | 58355.00999999979
13 | Bedworth | 30535.07999999991
125 | Ullesthorpe | 18701.97 |  |  | 41 | Northampton | 33246.96999999986
 |  |  |  |  | 41 | Northampton | 32718.91999999988
 |  |  |  |  | 41 | Northampton | 37353.51999999976
222 | [NAME] | 151237.9000000001
224 | Derby | 58355.00999999979
223 | Coventry | 53315.86999999964
41 | Northampton | 37353.51999999976
100 | Hinckley | 34468.2799999998
13 | Bedworth | 33791.13999999982
125 | Ullesthorpe | 18200.50999999995
Spreadsheet: 137119d1326970140-please-help-making-specific-chart-waterfalleffectchart_jpr73
Sheet: Waterfall

Mario | Values | Ends | Blanks | Up | Down
ASP | 0.91
shipmentCost | -0.15
warehousingCose | 1e-06
[NAME] | -0.5
OPEX | -0.05
netASP
Spreadsheet: 74966d1275496494-match-multiple-criteria-in-rows-and-columns-example2
Sheet: Sheet1

Item # | Cost/unit | Use Now? | Total Cost | Units | Better price available? | May Purchase Qty
600468651 | 2 | YES | 200 | 100 |  | 33
600468651 | 1 | NO | 500 | 500 |  | 0
167592369 | 3 | YES | 300 | 100 |  | 21
418577140 | 3 | YES | 1500 | 500 |  | 8
167981463 | 2 | YES | 200 | 100 |  | 8
664584893 | 1 | NO | 500 | 500 |  | 0
664584893 | 2 | YES | 200 | 100 |  | 0
664584893 | 2 | NO | 180 | 90 |  | 0
537358705 | 2 | YES | 200 | 100 |  | 45
296342672 | 1 | YES | 500 | 500 |  | 26
685181835 | 2 | YES | 200 | 100 |  | 20
416907891 | 1 | YES | 90 | 90 |  | 9
442194893 | 3 | YES | 180 | 60 |  | 14
125094487 | 4 | YES | 400 | 100 |  | 32
678390783 | 3 | YES | 750 | 250 |  | 21
644223880 | 1 | NO | 250 | 250 |  | 16
644223880 | 4 | YES | 400 | 100 |  | 0
644223880 | 1 | NO | 120 | 120 |  | 0
806148279 | 3 | YES | 1500 | 500 |  | 35
119297191 | 2 | YES | 200 | 100 |  | 26
786163235 | 3 | YES | 300 | 100 |  | 15
563293518 | 2 | YES | 1000 | 500 |  | 5
525817355 | 1 | YES | 120 | 120 |  | 48
749920488 | 4 | YES | 360 | 90 |  | 40
311342030 | 4 | YES | 480 | 120 |  | 22
311342030 | 3 | NO | 750 | 250 |  | 0
311342030 | 3 | NO | 1500 | 500 |  | 0
522468128 | 2 | YES | 1000 | 500 |  | 47
288718138 | 3 | YES | 300 | 100 |  | 61
723117862 | 2 | YES | 200 | 100 |  | 41
500800142 | 1 | NO | 500 | 500 |  | 25
500800142 | 2 | YES | 200 | 100 |  | 0
500800142 | 1 | NO | 250 | 250 |  | 0
862243827 | 3 | YES | 300 | 100 |  | 39
988409945 | 3 | YES | 270 | 90 |  | 42
910626344 | 4 | YES | 240 | 60 |  | 11
316266721 | 4 | YES | 400 | 100 |  | 60
456934891 | 2 | YES | 200 | 100 |  | 30
Spreadsheet: 879644d1727208231-conditional-format-not-working-and-giving-me-a-headache-vdc-coordination-schedule-template
Sheet: Help

HELP
 | https://www.vertex42.com/ExcelTemplates/construction-schedule.html
 |  | © 2019 Vertex42 LLC
About
 | This construction schedule was designed to provide an extremely simple way to create a professional-looking construction schedule. The bars in the gantt chart are created automatically using conditional formatting. Other formatting is up to you.
 | Want more features?
 | Learn about [NAME] Template Pro
Work Load
 | This version of the construction schedule shows how you can display and sum work loads. For each task, you assign a numeric work load. This may represent number of workers or some other quantity that you want to use as a metric.
 | Every cell in the gantt chart area contains a formula that displays the work load for the task, and a row at the top of the chart sums each column to show the total load for that day.
Adding More Rows
 | When you insert new rows, you should insert a blank row between rows that have the formatting you want. If you do that, the formatting will be copied automatically.
 | IMPORTANT: After inserting a new row, copy a previous row and paste over the new row so that all of the formula are copied into the new row!
Listing Non Work Days
 | Instead of using the WORKDAY or WORKDAY.INTL functions, this construction schedule has you enter the nonworking days in a list in the NonWorkDays worksheet. This allows you to completely customize your work schedule.
Adding More Columns to the Gantt Chart
 | If you want to increase the time span shown in chart, you can copy the last column in the gantt chart and then paste the copied column to the right of the gantt chart.
Changing the Bar Colors
 | The TYPE column can be used to choose a color for the bars in the schedule. If you want to change how this columns works, you will need to edit the conditional formatting rules.
Conditional Formatting
 | If you want to edit the colors used in the gantt chart, you will need to edit the conditional formatting rules.
 | To edit conditional formatting rules, go to Conditional Formatting > Manage Rules and select "This Worksheet" to see and edit all the rules.
Additional Help
 | The link at the top of this worksheet will take you to the web page on vertex42.com that talks about this template.
Spreadsheet: 849472d1699945499-help-with-formulas-please-classes-example-aligw
Sheet: MASTER

Code | Name | Gender | ENGLISH | SCIENCE
11 | [NAME] | F
22 | [NAME] | M
33 | Mark | M
44 | Tania | F
55 | [NAME] | F
66 | [NAME] | M
77 | [NAME] | M
88 | Bec | F
99 | [NAME] | M
0 | [NAME] | M
Spreadsheet: kate_symes__18394__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2000-12-27 00:00:00 |  | 394.68 | 12400 | 267.17 | 3320
 | 2000-12-26 00:00:00 |  | 451.15 | 10624 | 428.32 | 2712 | 182.26 | 2772 | 177.14 | 934
 | 2000-12-25 00:00:00 |  | 410 | 32 | 315 | 200 | 201.38 | 12441 | 207.74 | 775 |  | 377.09 | 5160
 | 2000-12-24 00:00:00 |  |  |  | 315 | 200 | 225.8 | 1588 | 225.35 | 855 |  | 377.09 | 5160
 | 2000-12-23 00:00:00 |  | 462.41 | 8224 | 382.64 | 1912 | 325.41 | 4915 | 244.19 | 2400
 | 2000-12-22 00:00:00 |  | 463 | 8624 | 382.94 | 1712 | 349.16 | 4653 | 309.33 | 2630
 | 2000-12-21 00:00:00 |  | 463 | 8624 | 384.75 | 2112 | 425 | 150 | 350 | 50
 | 2000-12-20 00:00:00 |  | 463.54 | 9424 | 386.4 | 1912 | 411.71 | 1117 | 365.63 | 240
 | 2000-12-19 00:00:00 |  | 471.25 | 7824 | 408.97 | 312 | 547.65 | 3749 | 506.72 | 1005
 | 2000-12-18 00:00:00 |  | 372.89 | 7600 | 321.88 | 1600 | 378.62 | 360 | 328.33 | 150
 | 2000-12-17 00:00:00 |  |  |  |  |  | 368.41 | 1404 | 355.96 | 663 |  | 321.88 | 4800
 | 2000-12-16 00:00:00 |  | 317.57 | 11504 | 272.19 | 1112 | 374.92 | 642 | 339.88 | 168
 | 2000-12-15 00:00:00 |  | 317.59 | 11424 | 272.19 | 1112 | 364.78 | 598 | 477.91 | 763
 | 2000-12-14 00:00:00 |  | 459.34 | 7024 | 342.87 | 1712 | 380.91 | 1574 | 283 | 1890
 | 2000-12-13 00:00:00 |  | 700.87 | 7824 | 485.4 | 1712 | 391.35 | 1561 | 349.97 | 318
 | 2000-12-12 00:00:00 |  | 956.16 | 9024 | 636.87 | 2712 | 526.56 | 322 | 355.87 | 412
 | 2000-12-11 00:00:00 |  | 3322.42 | 5744 | 2166.67 | 600 | 1285.47 | 695 | 451.85 | 621
 | 2000-12-10 00:00:00 |  |  |  |  |  | 595.02 | 1607 | 516.15 | 975 |  | 2125 | 2400
 | 2000-12-09 00:00:00 |  | 781.79 | 10896 | 449.75 | 808 | 423.26 | 1913 | 496.71 | 380
 | 2000-12-08 00:00:00 |  | 781.79 | 10896 | 449.75 | 808 | 604.06 | 1877 | 475.29 | 433
 | 2000-12-07 00:00:00 |  | 628.75 | 8000 | 490 | 1000 | 664.04 | 2134 | 377.22 | 552
 | 2000-12-06 00:00:00 |  | 360.3 | 13200 | 283.68 | 3800 | 417.71 | 480 | 254.49 | 195
 | 2000-12-05 00:00:00 |  | 278.15 | 16000 | 234.69 | 3200 | 305.36 | 1340 | 275 | 1155
 | 2000-12-04 00:00:00 |  | 276.46 | 14800 | 247.86 | 4200 | 261.33 | 1471 | 225.6 | 1552
 | 2000-12-03 00:00:00 |  | 268.33 | 1200 | 231.67 | 600 | 222.94 | 425 | 200 | 70 |  | 249.41 | 10200
 | 2000-12-02 00:00:00 |  | 264.7 | 26400 | 217.08 | 2400 | 223.95 | 2144 | 203.49 | 506
 | 2000-12-01 00:00:00 |  | 264.7 | 26400 | 217.08 | 2400 | 235.86 | 1637 | 204.07 | 800
 | 2000-11-30 00:00:00 |  | 254.19 | 17760 | 205.14 | 2800 | 244.29 | 175 | 204.3 | 465
 | 2000-11-29 00:00:00 |  | 251.79 | 21056 | 202.81 | 3200 | 244.89 | 1103 | 191.93 | 1385
 | 2000-11-28 00:00:00 |  | 252.35 | 10256 | 206.11 | 1800 | 215.95 | 1135 | 187.84 | 670
 | 2000-11-27 00:00:00 |  | 235.87 | 16160 | 212.32 | 3080 | 195.74 | 370 | 163.55 | 1325
 |  |  |  |  |  | ..
Spreadsheet: 122519d1316904207-auto-sort-rows-newest-football-statsheet
Sheet: Visitor

Team: |  |  |  |  | Record_____________ |  |  |  |  |  |  |  |  | Coach_______________ |  |  |  |  |  |  |  | Date______________
 |  |  |  |  |  | Receiving
Name | # | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 11 | 12 | 13 | 14 | Tot. |  | [NAME]. |  |  |  |  | Team Stats |  |  |  |  |  |  | Individual Stats
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pass: |  | for |  |  |  | yds. |  | Receiving
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INT |  |  | TD's |  |  |  |  |  | rec. for |  |  | yds, |  | TD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rush: |  |  |  | for |  | yds. |  |  |  |  |  | rec. for |  |  | yds, |  | TD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TD's |  |  |  |  |  | rec. for |  |  | yds, |  | TD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Off.: |  | TD's |  |  | yds. |  |  |  |  |  | rec. for |  |  | yds, |  | TD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Penalties: |  | for |  | yds. |  |  | Rushing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st downs: |  |  | TO's: |  |  |  |  |  |  |  | carries for |  |  | yds, |  | TD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Def: |  |  | YARDS ALLOWED |  |  |  |  |  |  |  |  | carries for |  |  | yds, |  | TD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SACKS |  |  |  | TFL |  |  |  |  |  | carries for |  |  | yds, |  | TD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INT |  |  |  | FUM |  |  |  |  |  | carries for |  |  | yds, |  | TD
incompletions: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total: |  |  |  |  |  | Times: |  |  |  |  |  |  |  |  |  |  |  |  | carries for |  |  | yds, |  | TD
 |  |  |  |  |  | Rushing
Name | # | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | Tot. |  | [NAME].
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total:
Yards
Drives        Plays
Time
Results
1st Downs:
Penalties: