tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: barry_tycholiz__882__PGTfuel
Sheet: ex9

 | b | c | d | e | f | g | h | i | j | k | l | m
2 |  |  | PGT est | PGT est | PGT est | est | est | est | est | estimate | posted | posted
 | Month | #days | throughput | fuel+loss | system avg | throughput | throughput | fuel+loss | fuel+loss | exceeds | fuel+loss | exceeds
 |  |  | Mdt/mo | Mdt/mo | miles | e9 dt.mi | e9 dt.mi/d | Mdt/day | %/mile | 0.0041% | %/mile | 0.0041%
 | 1993-11-01 00:00:00 |  |  | for Feb-94 through Apr-95 estimated mileage is derived.
 | 1993-12-01 00:00:00 |  |  | example: Nov-94, 1.8374%/(0.0037%/mile) = 496.6 miles
 | 1994-01-01 00:00:00
 | 1994-02-01 00:00:00
 | 1994-03-01 00:00:00
 | 1994-04-01 00:00:00
 | 1994-05-01 00:00:00
 | 1994-06-01 00:00:00
 | 1994-07-01 00:00:00
 | 1994-08-01 00:00:00
 | 1994-09-01 00:00:00
 | 1994-10-01 00:00:00
 | 1994-11-01 00:00:00
 | 1994-12-01 00:00:00
 | 1995-01-01 00:00:00
 | 1995-02-01 00:00:00
 | 1995-03-01 00:00:00
 | 1995-04-01 00:00:00
 | 1995-05-01 00:00:00
 | 1995-06-01 00:00:00
 | 1995-07-01 00:00:00
 | 1995-08-01 00:00:00
 | 1995-09-01 00:00:00
 | 1995-10-01 00:00:00
 | 1995-11-01 00:00:00
 | 1995-12-01 00:00:00
 | 1996-01-01 00:00:00
 | 1996-02-01 00:00:00
 | 1996-03-01 00:00:00
 | 1996-04-01 00:00:00
 | 1996-05-01 00:00:00
 | 1996-06-01 00:00:00
 | 1996-07-01 00:00:00
 | 1996-08-01 00:00:00
 | 1996-09-01 00:00:00
 | 1996-10-01 00:00:00
 | 1996-11-01 00:00:00
 | 1996-12-01 00:00:00
 | 1997-01-01 00:00:00
 | 1997-02-01 00:00:00
 | 1997-03-01 00:00:00
 | 1997-04-01 00:00:00
 | 1997-05-01 00:00:00
 | 1997-06-01 00:00:00
 | 1997-07-01 00:00:00
 | 1997-08-01 00:00:00
 | 1997-09-01 00:00:00
 | 1997-10-01 00:00:00
 | 1997-11-01 00:00:00
 | 1997-12-01 00:00:00
 | 1998-01-01 00:00:00
 | 1998-02-01 00:00:00
 | 1998-03-01 00:00:00
 | 1998-04-01 00:00:00
 | 1998-05-01 00:00:00
 | 1998-06-01 00:00:00
 | 1998-07-01 00:00:00
 | 1998-08-01 00:00:00
 | 1998-09-01 00:00:00
 | 1998-10-01 00:00:00
 | 1998-11-01 00:00:00
 | 1998-12-01 00:00:00
 | 1999-01-01 00:00:00
 | 1999-02-01 00:00:00
 | 1999-03-01 00:00:00
 | 1999-04-01 00:00:00
 | 1999-05-01 00:00:00
 | 1999-06-01 00:00:00
 | 1999-07-01 00:00:00
 | 1999-08-01 00:00:00
 | 1999-09-01 00:00:00
 | 1999-10-01 00:00:00
 | 1999-11-01 00:00:00
 | 1999-12-01 00:00:00
 | 2000-01-01 00:00:00
 | 2000-02-01 00:00:00
 | 2000-03-01 00:00:00
 | 2000-04-01 00:00:00
 | 2000-05-01 00:00:00
 | 2000-06-01 00:00:00
 | 2000-07-01 00:00:00
 | 2000-08-01 00:00:00
 | 2000-09-01 00:00:00
 | 2000-10-01 00:00:00
 | 2000-11-01 00:00:00
 | 2000-12-01 00:00:00
 | 2001-01-01 00:00:00
 | 2001-02-01 00:00:00
 | 2001-03-01 00:00:00
 | 2001-04-01 00:00:00
 | 2001-05-01 00:00:00
 | 2001-06-01 00:00:00
 | 2001-07-01 00:00:00
 | Count
 | Count>=0.0041%
Spreadsheet: 236dfb4c-9a37-488b-bb55-710b8cdd4595
Sheet: Sheet1

Families of transposable elements identified in the Aspergillus genomes | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Af293 | A1163 | N. fischeri | A.clavatus
cacta |  | cacta | cacta
DDE_1 | DDE_1 | DDE_1 | DDE_1
gypsy | gypsy | gypsy | gypsy
hAT | hAT | hAT
LINE | LINE | LINE | LINE
ltr_Roo | ltr_Roo | ltr_Roo
mariner | mariner | mariner | mariner
mariner_ant1 | mariner_ant1 | mariner_ant1 | mariner_ant1
MuDR_A_B | MuDR_A_B | MuDR_A_B | MuDR_A_B
TY1_Copia | TY1_Copia | TY1_Copia | TY1_Copia
Spreadsheet: 133055d1324139922-copy-and-sort-data-sample-data
Sheet: Data

Date | operator | solids | Units | Weight | Pigments | Days | Distance
2010-11-15 00:00:00 | a | 48.8 | 252 | 3350 | 48.8 | 33 | 24
2010-10-13 00:00:00 | b | 60.7 | 257 | 3326 | 60.7 | 27 | 16
2010-09-16 00:00:00 | c | 69.2 | 494 | 3310 | 69.2 | 34 | 13
2010-08-13 00:00:00 | e | 75.5 | 620 | 3297 | 75.5 | 30 | 9
2010-07-14 00:00:00 | a | 73.6 | 641 | 3288 | 73.6 | 30 | 13
2010-06-14 00:00:00 | b | 67.9 | 341 | 3275 | 67.9 | 30 | 14
2010-05-15 00:00:00 | k | 53.8 | 247 | 3261 | 53.8 | 30 | 25.2
2010-04-15 00:00:00 | d | 50.4 | 356 | 3236 | 50.4 | 30 | 52.5
2010-03-16 00:00:00 | e | 34 | 490 | 3184 | 34 | 32 | 152.5
2010-02-12 00:00:00 | b | 24.3 | 511 | 3033 | 24.3 | 28 | 176.4
2010-01-15 00:00:00 | c | 22.9 | 634 | 2859 | 22.9 | 32 | 206.8
2009-12-14 00:00:00 | k | 36.5 | 547 | 2655 | 36.5 | 32 | 134.7
2009-11-12 00:00:00 | a | 48.5 | 378 | 2522 | 48.5 | 29 | 73.2
2009-10-14 00:00:00 | e | 54.1 | 390 | 2449 | 54.1 | 29 | 39.1
2009-09-15 00:00:00 | c | 66.4 | 428 | 2410 | 66.4 | 34 | 39.2
2009-08-12 00:00:00 | d | 69.7 | 344 | 2371 | 69.7 | 28 | 14
2009-07-15 00:00:00 | a | 71.4 | 333 | 2357 | 71.4 | 30 | 16
2009-06-15 00:00:00 | e | 63 | 235 | 2341 | 63 | 32 | 12.1
2009-05-14 00:00:00 | k | 56.2 | 283 | 2329 | 56.2 | 29 | 20.2
2009-04-15 00:00:00 | c | 42.5 | 456 | 2309 | 42.5 | 30 | 69.2
2009-03-16 00:00:00 | d | 31.9 | 592 | 2241 | 31.9 | 32 | 130.6
2009-02-12 00:00:00 | e | 23.2 | 448 | 2113 | 23.2 | 27 | 119.4
2009-01-16 00:00:00 | k | 20.3 | 679 | 1996 | 20.3 | 31 | 187.3
2008-12-16 00:00:00 | b | 29.1 | 662 | 1812 | 29.1 | 34 | 192
Spreadsheet: 54142d1254161941-excel-2007-irr-function-case09_alslezak_2
Sheet: Depreciation

NewLeaf Paper
Depreciation of Assets
Initial Asset Cost
Salvage Value
Life of Asset (in Years) | 8
 | Year
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
Straight-Line (SLN)
Cumulative Depreciation
Asset Value
Declining Balance (DB)
Cumulative Depreciation
Asset Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C53pp32u7240rrr241
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xi!pibwxh
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Al Slezak
Spreadsheet: 823262d1679859861-how-to-track-inventory-when-clearing-worksheet-excel-tracker
Sheet: Asphalt (2)

 |  |  |  |  | Pick Ticket Asphalt
 | Supplier : Beacon / ABC / ___________ |  |  |  | Job# | Date: __ /__ / __
 | Description |  |  | Qty | Unit price | Total price
 | Tri-Built Self adhering Ice & Water (2 sq) |  |  | 0 | 66.77
 | Tri-Built Galvanized steel roll valley - (20''x50') |  |  | 0 | 93.2
 | Tri-Built Lo-Omni roll ridge vent - Nailable (30') |  |  | 0 | 81.78
 | Tri-Built Starter |  |  | 0 | 39.93
 | Tri-Built Synthetic roofing underlayment (10 sq) |  |  | 0 | 65.89
 | Tri-Built Coil nails - 1 1/4'' (7200) |  |  |  | 50
 | Notes: |  |  |  | Subtotal
 |  |  |  |  | Adjustments
Spreadsheet: 188828d1351002883-sorting-rows-on-different-tabs-by-date-task-20list-20-help-1-
Sheet: A

Due Date: | Client Name | Person Responsible | Task
2012-10-27 00:00:00 | A | person 1 | Task A
2012-10-28 00:00:00 | A | person 2 | Task C
2012-11-02 00:00:00 | A | person 3 | Task B
2012-11-05 00:00:00 | A | person 4 | Task D
2012-11-15 00:00:00 | A | person 5 | Task E
2012-11-20 00:00:00 | A | person 6 | Task F
Spreadsheet: darrell_schoolcraft__7324__imball0202
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635
3531 |  | -240635
60667 | -18 | -657900
60749 |  | -2568
61206
61334 | -382739
62960
INDEX
2002-01-31 00:00:00 |  |  | 10496.07
2002-02-20 00:00:00
CBS Volume
2001-12-31 00:00:00 |  |  | 4346
Spreadsheet: 0bcd5ad7-934f-4994-970e-0b8702bcabb7
Sheet: 14a

Product |  | TOTAL
Single - Name* | Corporate | 703474
 | Loans | 3961
 | Municipal | 3958
 | Recovery
 | Sovereign | 208872
Index Tranche | Asia | <1,000
 | Europe | 153108
 | North America | 150225
Index | Asia | 28429
 | Europe | 373158
 | North America | 547378
Other | Exotic
 | Swaptions
 | Total Return Swap
TOTAL |  | 2172562
Estimated net notional amount outstanding, May 24 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies, cleared and uncleared. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 795623d1662807200-need-formula-to-delete-first-3-letters-from-the-date-stamp-book3-etaf
Sheet: Sheet1

 |  |  | Expected Result | 2022 | year
 |  | MonAug 1 | 2001-08-01 00:00:00
 |  | TueAug 2 | 2002-08-01 00:00:00
 |  | WedAug 3 | 2003-08-01 00:00:00
 |  | ThuAug 4 | 2004-08-01 00:00:00
 |  | FriAug 5 | 2005-08-01 00:00:00
 |  | SatAug 6 | 2006-08-01 00:00:00
 |  | SunAug 7 | 2007-08-01 00:00:00
 |  | MonAug 8 | 2008-08-01 00:00:00
 |  | TueAug 9 | 2009-08-01 00:00:00
 |  | WedAug 10 | 2010-08-01 00:00:00
 |  | ThuAug 11 | 2011-08-01 00:00:00
 |  | FriAug 12 | 2012-08-01 00:00:00
 |  | SatAug 13 | 2013-08-01 00:00:00
 |  | SunAug 14 | 2014-08-01 00:00:00
 |  | MonAug 15 | 2015-08-01 00:00:00
 |  | TueAug 16 | 2016-08-01 00:00:00
 |  | WedAug 17 | 2017-08-01 00:00:00
 |  | ThuAug 18 | 2018-08-01 00:00:00
 |  | FriAug 19 | 2019-08-01 00:00:00
 |  | SatAug 20 | 2020-08-01 00:00:00
 |  | SunAug 21 | 2021-08-01 00:00:00
 |  | MonAug 22 | 2022-08-01 00:00:00
 |  | TueAug 23 | 2023-08-01 00:00:00
 |  | WedAug 24 | 2024-08-01 00:00:00
 |  | ThuAug 25 | 2025-08-01 00:00:00
 |  | FriAug 26 | 2026-08-01 00:00:00
 |  | SatAug 27 | 2027-08-01 00:00:00
 |  | SunAug 28 | 2028-08-01 00:00:00
 |  | MonAug 29 | 2029-08-01 00:00:00
 |  | TueAug 30 | 1930-08-01 00:00:00
 |  | WedAug 31 | 1931-08-01 00:00:00
 |  | ThuSep 1 | 2001-09-01 00:00:00
 |  | FriSep 2 | 2002-09-01 00:00:00
 |  | SatSep 3 | 2003-09-01 00:00:00
 |  | SunSep 4 | 2004-09-01 00:00:00
 |  | MonSep 5 | 2005-09-01 00:00:00
 |  | TueSep 6 | 2006-09-01 00:00:00
 |  | WedSep 7 | 2007-09-01 00:00:00
 |  | ThuSep 8 | 2008-09-01 00:00:00
 |  | FriSep 9 | 2009-09-01 00:00:00
 |  | SatSep 10 | 2010-09-01 00:00:00
Spreadsheet: 877331d1724133083-count-available-employees-in-employee-break-schedule-based-on-color-adub22-excel-breaks-schedule-final-2016-aligw
Sheet: Formatted Break

Monday August 19, 2024
 | 0700 | 0730 | 0800 | 0830 | 0900 | 0930 | 1000 | 1030 | 1100 | 1130 | 1200 | 1230 | 1300 | 1330 | 1400 | 1430 | 1500 | 1530 | 1600 | 1630 | 1700 | 1730 | 1800 | 1830 | 1900 | 1930 | 2000 | 2030 | 2100 | 2130 | 2200 | 2230 | 2300 | 2330 | 0000 | 0030 | 100 | 130 | 200 | 230 | 300 | 330 | 400 | 0500 | 0600 | 0700
[NAME]
Josh/Mimosa |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | B | B | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S | S | S | S | S | S | S | S | S | S | S
Austin/Tiff |  |  |  |  |  |  |  |  |  |  |  |  | B | B | B | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S | S | S | S | S | S | S | S | S | S | S
Emilio/[NAME] | S | S |  |  |  |  |  |  |  |  |  |  |  |  | B | B | B | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S | S | S | S | S | S | S | S | S
Hailey |  |  |  |  |  |  | B | B | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O
[NAME] | S | S | S | S | S | S | S | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O
Wilbert |  |  |  |  |  |  |  |  | B | B | B | B |  |  |  |  |  |  |  |  |  |  |  |  | S | S | S | S | S | S | S | S | S | S | S | S
Sejal | S | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | B | B | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S | S | S | S | S | S | S | S | S
[NAME] |  |  | S | S | S | S | S | S | S | S | S | S | S | S | S | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | B | B | B
Zyali | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | B | B | B
Rory | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O |  |  |  |  |  |  |  |  | B | B | B
[NAME] |  |  | S | S | S | S | S | S | S | S | S | S | S | S | S |  |  |  |  |  |  |  |  |  |  |  |  |  | B | B | B | B
11
FCS TOTALS
FCD OFF
 | S | S | sleep (1800-0100 or 0100-0700) |  |  |  |  |  |  |  |  |  |  |  | COMM PLAN
 |  |  | floor coverage |  |  |  |  |  |  |  |  |  |  |  | FIRE OC  VFIRE 22 & VFIRE 24 CDF A/G1 T16  AIR TACTICS 6   PROS VICTOR: HMT 135.575 SOLAR VICTOR: 130.200
 | B | B | break
 | O | O | 12-hour shifts - off duty hours
 | T | T | training
Spreadsheet: 65f00402-a368-4859-901e-d63efa81f1b4
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
01/08/2010 | Gymnastics | at Michigan State | L, 191.225-193.925
01/08/2010 | Gymnastics | vs. Penn State (East Lansing, Mich.) | L, 191.225-193.9
01/08/2010 | Gymnastics | vs. Western Michigan (East Lansing, Mich.) | W, 191.225-189.525
01/16/2010 | Gymnastics | at Pitt | W, 192.425-190.55
01/16/2010 | Gymnastics | vs. [NAME] (at Pittsburgh, Pa.) | W, 192.425-190.625
01/24/2010 | Gymnastics | NC STATE | W, 194.0-193.225
01/24/2010 | Gymnastics | MARYLAND | W, 194.0-193.0
01/24/2010 | Gymnastics | [NAME] | W, 194.0-188.65
01/30/2010 | Gymnastics | at Maryland | W, 194.6-193.925
01/30/2010 | Gymnastics | vs. Denver (at College Park, Md.) | W, 194.6-192.85
01/30/2010 | Gymnastics | vs. Rutgers (at College Park, Md.) | W, 194.6-190.55
02/05/2010 | Gymnastics | MICHIGAN | L, 196.4-194.475
02/05/2010 | Gymnastics | WILLIAM & MARY | W, 194.475-187.725
02/12/2010 | Gymnastics | OHIO STATE | W, 195.65-192.8
02/20/2010 | Gymnastics | at Penn State | L, 195.95-194.925
02/28/2010 | Gymnastics | at Nebraska | L, 196.425-192.975
02/28/2010 | Gymnastics | vs. Arizona (Lincoln, Neb.) | L, 194.75-192.975
02/28/2010 | Gymnastics | vs. Denver (at Lincoln, Neb.) | L, 194.175-192.975
03/06/2010 | Gymnastics | BOWLING GREEN | W, 194.725-191.55
03/13/2010 | Gymnastics | at North Carolina | W, 193.775-193
03/19/2010 | Gymnastics | [NAME] | W, 194.725-190.85
03/27/2010 | Gymnastics | at EAGL Championships (Durham, N.H.) | Third Place, 195.075
04/10/2010 | Gymnastics | NCAA SOUTHEAST REGIONAL | Fourth Place, 195.1
Spreadsheet: 07e9b979-7616-47bc-a454-858dadbd8601
Sheet: Sheet1

Table 6--Wheat: National average prices received by farmers by class (dollars per bushel), 12/13/2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | Hard red winter |  | Soft red winter |  | Hard red spring |  | White
 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12
June | 3.94 | 7.2 | 4.5 | 7 | 4.59 | 9.34 | 4.28 | 6.94
July | 4.38 | 6.97 | 4.77 | 6.5 | 4.72 | 8.45 | 5.26 | 6.72
August | 5.42 | 7.4 | 5.75 | 7.08 | 5.49 | 8.39 | 5.52 | 6.79
September | 5.82 | 7.27 | 5.89 | 6.93 | 6.03 | 8.16 | 5.54 | 6.59
October | 6.09 | 6.83 | 6.12 | 6.63 | 5.96 | 8.39 | 5.76 | 6.06
November | 6.15 |  | 5.46 |  | 6.41 |  | 5.88
December | 6.51 |  | 6.73 |  | 6.64 |  | 6.07
January | 6.5 |  | 6.31 |  | 7.22 |  | 6.05
February | 7.07 |  | 7.11 |  | 7.7 |  | 6.78
March | 7.1 |  | 6.7 |  | 8.12 |  | 6.65
April | 7.5 |  | 7.27 |  | 8.75 |  | 7.06
May | 8 |  | 7.09 |  | 8.95 |  | 7.22
Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 12/9/2011
Spreadsheet: 886874d1736971365-importing-data-from-one-tab-into-a-template-audit-trial
Sheet: Sheet2

Address | Route Id
390 CHEROKEE BLVD | 510800
270 CHEROKEE BLVD | 510800
150 CHEROKEE BLVD | 510800
44 KELVINWAY DR | 510800
50 COLLINGSBROOK BLVD | 510800
10 CORINTHIAN BLVD | 510800
2300 PHARMACY AVE | 510800
2200 PHARMACY AVE | 510800
3121 SHEPPARD AVE E | 510800
3110 SHEPPARD AVE E | 510800
60 CLIPPER RD | 510800
70 CLIPPER RD | 510800
175 BRIAN DR | 510800
70 MARGARET AVE | 510800
95 BRIAN DR | 510800
25 MUIRHEAD RD | 510800
70 OLD SHEPPARD AVE | 510800
10 MUIRHEAD RD | 510800
5 OLD SHEPPARD AVE | 510800
55 SMOOTH ROSE CRT | 510800
325 YORKLAND BLVD | 510800
2721 VICTORIA PARK AVE | 510800
2739 VICTORIA PARK AVE | 510800
Spreadsheet: 835157d1688376385-calculating-running-percentage-for-rows-with-blank-cells-but-will-be-populated-feedback-stats-aligw
Sheet: 2023

 | Respondent identity | 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 | TOTAL | out of a total score of ??? | Average | Median | Mode
1 | Timeliness of papers (did you have enough time to read them etc?) | 3 | 4 | 4 | 5 | 5 | 5 | 4 | 2 | 4 | 5 | 5 | 3 | 5 | 3 | 5 | 3
2 | Information about the meeting (enough and in time) | 4 | 5 | 4 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 5 | 4 | 5 | 5 | 5 | 5
3 | How easy was it to find the venue / join the virtual meeting? | 5 | 5 | 4 | 5 | 5 | 4 | 5 | 3 | 4 | 5 | 3 | 4 | 5 | 5 | 4 | 4
4 | How did you find the room layout? | 4 | 4 | 5 | 4 | 4 | 4 | 5 | 3 | 3 | 4 | 5 | 5 | 5 | x | 3 | 3
5 | How did you find the refreshments and catering? | 4 | 5 | 4 | 4 | 4 | 4 | 5 | 3 | 4 | 3 | 5 | 5 | 5 | x | 5 | 4
6 | How did you find the venue environment, eg  temperature, accessibility, facilities? | 4 | 4 | 4 | 5 | 5 | 4 | 5 | 3 | 4 | 4 | 4 | 5 | 5 | x | 4 | 3
7 | How was the timing of the meeting? | 5 | 4 | 4 | 5 | 4 | 4 | 3 | 2 | 4 | 4 | 5 | 5 | 5 | x | 5 | 2
8 | Was the information presented easy to understand? | 4 | 5 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 5 | 4 | 5 | x | 5 | 4
9 | Were the presenters easily heard? | 4 | 5 | 4 | 5 | 4 | 5 | 5 | 3 | 4 | 5 | 5 | 5 | 5 | 4 | 5 | 5
10 | Were the presentations easily seen? | 4 | 5 | 4 | 5 | 5 | 3 | 5 | 3 | 4 | 5 | 5 | 3 | 5 | 5 | 4 | 5
11 | Do you feel meeting attendees had an opportunity to participate? | 3 | 4 | 5 | 5 | 5 | 5 | 3 | 3 | 2 | 4 | 5 | 3 | 5 | 4 | 4 | 5
12 | How useful did you find the meeting? | 3 | 5 | 3 | 4 | 5 | 4 | 3 | 3 | 4 | 3 | 5 | 3 | 5 | 5 | 4 | 3
13 | How enjoyable was the meeting? | 3 | 4 | 3 | 4 | 4 | 1 | 2 | 2 | 2 | 2 | 5 | 2 | 3 | 5 | 3 | 2
Spreadsheet: 827663d1682944061-how-to-update-to-reflect-the-new-extra-added-columns-updateheader-2nd-5throws
Sheet: Sheet1

1st
 | This is the main table that contains my data, so I've gave it a name "MainTable", but this name of course does not includes the header row.
 | And also set a defined name "EntireMainTable" to include the header row as well.
 | No. | Item | 2016 | 2017 | 2018 | 2019 | 2020
 | 1 | Cash | 586659031 | 480343056 | 20473172 | 605840237 | 1
 | 2 | Sales | 759051269 | 498365688 | 395887621 | 554353871 | 2
 | 3 | Receivables | 554603731 | 413440842 | 653946455 | 484659284 | 3
 | 4 | payables | 102298199 | 858026168 | 111387132 | 410342401 | 4
 | 5 | Loans | 826522204 | 873292758 | 320363304 | 389108069 | 5
 | 6 | Expenses | 722623185 | 34417935 | 579008782 | 333651085 | 6
2nd
 | Now if I want to copy the entire table and let the copy got updated automatically, I use the formula =EntireMainTable
 |  | Item | 2016 | 2017 | 2018 | 2019 | 2020
 | 1 | Cash | 586659031 | 480343056 | 20473172 | 605840237 | 1
 | 2 | Sales | 759051269 | 498365688 | 395887621 | 554353871 | 2
 | 3 | Receivables | 554603731 | 413440842 | 653946455 | 484659284 | 3
 | 4 | payables | 102298199 | 858026168 | 111387132 | 410342401 | 4
 | 5 | Loans | 826522204 | 873292758 | 320363304 | 389108069 | 5
 | 6 | Expenses | 722623185 | 34417935 | 579008782 | 333651085 | 6
3rd - When the table got updated
 | Now I want to copy only the header and the 2nd and 5th rows of that table, but also want if the table got updated by adding new columns for new years like 2020 …etc. I want the new added data to be copied automatically.
 | No. | Item | 2016 | 2017 | 2018 | 2019 | 2020
 | 1 | Cash | 586659031 | 480343056 | 20473172 | 605840237 | 322747307.5
 | 2 | Sales | 759051269 | 498365688 | 395887621 | 554353871 | 372772047
 | 3 | Receivables | 554603731 | 413440842 | 653946455 | 484659284 | 534330646
 | 4 | payables | 102298199 | 858026168 | 111387132 | 410342401 | 414886867.5
 | 5 | Loans | 826522204 | 873292758 | 320363304 | 389108069 | 136028619
 | 6 | Expenses | 722623185 | 34417935 | 579008782 | 333651085 | 261843883.5
4th - I want the copy to be updated automatically, copy only the header and the 2nd and 5th rows of that table
 | How to only copy the header, 2nd, and 5th rows, and include column 2020, and if more columns added later on to be included
 | I've tried to add a defined names for header, 2nd row, and 5th row, but it did not got updated except for header
 | No. | Item | 2016 | 2017 | 2018 | 2019 | 2020
 | 1 | Cash | 586659031 | 480343056 | 20473172 | 605840237 | 322747307.5
 | 2 | Sales | 759051269 | 498365688 | 395887621 | 554353871 | 372772047
 | 3 | Receivables | 554603731 | 413440842 | 653946455 | 484659284 | 534330646
 | 4 | payables | 102298199 | 858026168 | 111387132 | 410342401 | 414886867.5
 | 5 | Loans | 826522204 | 873292758 | 320363304 | 389108069 | 136028619
 | 6 | Expenses | 722623185 | 34417935 | 579008782 | 333651085 | 261843883.5
5th - Only the header worked! | I was not able to make a dynamic updated range for 2nd, and 5th rows
 |  | Item | 2016 | 2017 | 2018 | 2019 | 2020
Spreadsheet: 886232d1736264480-out-description-in-a-cell-position
Sheet: SCORE CARDS

Please sign |  |  | TUESDAY POST OFFICE GOLF LEAGUE OFFICIAL SCORE CARD
SCORE KEEPER SIGNATURE | OPPONENTS ATTEST SIGNATURE | Keep your head down |  | DATE | HANDICAP | 7 | 3 | 8 | 1 | 5 | 6 | 4 | 2 | 9
 |  | TEAM # |  | 9 Place | PAR | 4 | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 4
 |  | VS |  | 2025-05-16 00:00:00 | YARDS | 330/285 | 338/269 | 320/320 | 195/161 | 370/361 | 130/118 | 317/279 | 350/292 | 269/269 | 2629/2354
 |  | TEAM # |  | 8 Place | HOLE # | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | TOTAL
 |  |  |  | Handicap
 |  | REGULAR SCORE MINUS HANDICAP
 |  |  |  | Handicap
 |  | REGULAR SCORE MINUS HANDICAP
 |  |  | POINTS WON
 |  | PLAY FAST |  | PACE OF PLAY |  | :13 | :26 | :40 | :53 | 1:10 | 1:20 | 1:34 | 1:48 | 2:06
 |  |  |  | Handicap
 |  | REGULAR SCORE MINUS HANDICAP
 |  |  |  | Handicap |  | 1
 |  | REGULAR SCORE MINUS HANDICAP
 |  |  | POINTS WON
 |  | May move ball only 6 inches, If lost or nonplayable, drop one club length from where lost  or where unplayable lie was.    1 stroke