tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 868790d1715482780-auto-insert-rows-excel_spacing_question
Sheet: Sheet2

Row Labels | Description |  |  | Row Labels | Description |  | Row Labels | Description |  | Row Labels | Description
 | EE CI |  |  |  | EE CI |  |  | EE CI |  |  | EE CI
12300 | EE OP AD&D |  |  |  |  |  |  |  |  | 12300 | EE OP AD&D
12300 | EE OP LIFE INS |  |  | 12300 | EE OP LIFE INS |  | 12300 | EE OP LIFE INS |  | 12300 | EE OP LIFE INS
12300 | FAMILY RESPONSILBILTY |  |  |  |  |  | 12300 | FAMILY RESPONSILBILTY |  | 12300 | FAMILY RESPONSILBILTY
12300 | GARNISHMENT |  |  |  |  |  |  |  |  | 12300 | GARNISHMENT
12300 | [NAME] |  |  |  |  |  | 12300 | [NAME] |  | 12300 | [NAME]
12300 | SPOUSE OP AD&D |  |  |  |  |  |  |  |  | 12300 | SPOUSE OP AD&D
12300 | SPOUSE OP LIFE |  |  |  |  |  | 12300 | SPOUSE OP LIFE |  | 12300 | SPOUSE OP LIFE
22000 | United Way |  |  | 22000 | United Way |  | 22000 | United Way |  | 22000 | United Way
22200 | Employer WSIB |  |  | 22200 | Employer WSIB |  | 22200 | Employer WSIB |  | 22200 | Employer WSIB
22300 | Employer EHT |  |  | 22300 | Employer EHT |  | 22300 | Employer EHT |  | 22300 | Employer EHT
22400 | RRSP EE |  |  | 22400 | RRSP EE |  | 22400 | RRSP EE |  | 22400 | RRSP EE
22400 | RRSP EE VOL |  |  | 22400 | RRSP EE VOL |  | 22400 | RRSP EE VOL |  | 22400 | RRSP EE VOL
22400 | RRSP ER |  |  | 22400 | RRSP ER |  | 22400 | RRSP ER |  | 22400 | RRSP ER
22500 | Social Club |  |  | 22500 | Social Club |  | 22500 | Social Club |  | 22500 | Social Club
22700 | Vacation paid |  |  | 22700 | Vacation paid |  | 22700 | Vacation paid |  | 22700 | Vacation paid
22700 | Vacation pay Accrual |  |  | 22700 | Vacation pay Accrual |  | 22700 | Vacation pay Accrual |  | 22700 | Vacation pay Accrual
23200 | STAT PAY ACCRUAL |  |  | 23200 | STAT PAY ACCRUAL |  | 23200 | STAT PAY ACCRUAL |  | 23200 | STAT PAY ACCRUAL
 |  |  |  | 23700 | Federal extra income tax |  | 23700 | Federal extra income tax
 |  |  |  | 23700 | Federal income tax |  | 23700 | Federal income tax
 |  |  |  | 23700 | Ontario income tax |  | 23700 | Ontario income tax
 |  |  |  | 23800 | Employment insurance
 |  |  |  | 23800 | Employment insurance (ER)
 |  |  |  | 23900 | Canada pension plan
Spreadsheet: 161818d1339637239-autocalculate-current-week-of-fiscal-year-fiscal-week
Sheet: Sheet1

Fiscal Year Start | Today/Evaluated Date | Fiscal Week | Fiscal Quarter
2012-01-01 00:00:00 | 2012-06-13 00:00:00 | 24 | 2
Eval Different Dates: | 2012-01-13 00:00:00 | 2 | 1
 | 2012-03-31 00:00:00 | 13 | 1
 | 2012-04-01 00:00:00 | 14 | 2
 | 2012-06-30 00:00:00 | 26 | 2
 | 2012-07-01 00:00:00 | 27 | 3
 | 2012-09-30 00:00:00 | 40 | 3
 | 2012-10-01 00:00:00 | 40 | 4
 |  | No Date to Evaluate
 |  | No Date to Evaluate
 |  | No Date to Evaluate
 |  | No Date to Evaluate
Spreadsheet: 98598d1297453908-pivot-table-displaying-data-rows-into-columns-inventory
Sheet: Inventory Items

Item Name | Unique ID | Total purchased | [NAME] | Total Price | Quantity on Hand
RAM DDR2 PC3200 400 Mhz 1GB | DDR2 400 1GB
RAM DDR2 PC3200 400 Mhz 512MB | DDR2 400 512
RAM DDR2 PC4200 533 512 MB | DDR2 533 512
HD IDE 80 GB | [NAME]
HD SATA 160 GB | SATA160GB
HD SATA 250 GB | [NAME]
HD SATA 500 GB | SATA500GB
HD SATA 750 GB | SATA750GB
HD SATA 80 GB | SATA80GB
RAM DDR PC3200 400Mhz 512MB | DDR 400 512
RAM DDR 533 1GB | DDR 533 1 GB
HD SATA 2.5" 100GB | [NAME]
[NAME] D620 | ADAPTERD620
Adapter Mac G4 A1106 | ADAPTERG4
DVDROM | DVDROM
CDRW | CDRW
Spreadsheet: 737781d1624603156-leave-calendar-to-count-number-of-days-of-leave-left-leave-plan-draft-v6-ans-2
Sheet: December

Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Monday |  | Tuesday
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
Spreadsheet: tracy_geaccone__40213__EGA fcst
Sheet: October 25

2001 Fourth Quarter Forecast
(Millions of Dollars)
 |  |  |  |  |  | 4th quarter
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Revised |  |  |  | From
 |  |  |  |  |  | Forecast |  | 3rd CE |  | 3rd CE |  | Plan
Income Before Int. Expense & Income Taxes * |  |  |  |  |  | -29.8 |  | -29.8 |  |  |  | 291
Interest Expense
 | 3rd Party interest expense |  |  |  |  | 16.3 |  | 16.3 |  |  |  | 27.7
 | Intercompany capital charge expense (income) |  |  |  |  | 15.5 |  | 15.5 |  |  |  | 129.6
 | Other intercompany interest expense (income) |  |  |  |  | 16 |  | 16 |  |  |  | 28.4
 | Other - including capitalized interest |  |  |  |  | 2 |  | 2
Minority Interest |  |  |  |  |  | -0.5 |  | -0.5 |  |  |  | 5.9
Pre-tax income
Income Tax |  |  |  |  |  | -9.7 |  | -9.7 |  |  |  | -20.6
Net Income before Financing Costs
[NAME] (items greater than $1.0) |  |  |  |  |  |  |  |  |  | Interest |  |  |  | Net
 |  |  |  |  |  |  |  | IBIT |  | Expense |  | Taxes |  | Income
Prior Forecast
 | [NAME] |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | [NAME] |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | Other |  |  |  |  |  |  | 0 |  | 0 |  | 0
Current Forecast
*    INCOME BEFORE INTEREST EXPENSE AND INCOME TAXES INCLUDES OUTSIDE (NOT INTERCOMPANY)
INTEREST INCOME.
Spreadsheet: 55438d1255547080-date-references-copy2-of-powertrain-predictor-working_oct2009
Sheet: Distribution (T)

Component Miles
Bus Model: |  |  | [NAME]
Units:
[NAME]
Low | 0
High | 100000
Count
[NAME] |  | 1
B500
HT740
HT746
ZF
[NAME] |  | 2
C
D
G
M
O |  | 1
R
Spreadsheet: 153749d1336041844-counting-the-number-of-peaks-in-a-column-of-data-peaks
Sheet: Sheet1

100
94.96
101.17
110.03
110.5
107.46
106.88
111.01
111.33
119.95
122.04
124.18
130.86
123.98
119.87
126.36
126.87
126.44
128.54
128.21
117.48
109.96
118.36
112.93
115.44
123.76
129.2
134.89
Spreadsheet: 808744d1670609218-index-match-2-cells-then-drag-formula-to-return-unique-results-w-o-leaving-blank-results-index-match-2-cells_return-another-cells-value-and-dont-have-blank-cell-results
Sheet: Sheet1

 |  |  | 50
 | Station | Material |  | State | OP | Issue |  |  |  |  | Station | Material
 |  |  |  | Material | 50 | Damper label
 |  |  |  | Material | 50 | Damper label |  |  |  |  |  | [NAME] Issue
 |  |  |  | Material | 50 | [NAME] issue |  |  |  |  | 50 | [NAME]
 |  |  |  | Material | 50 | Damper label
 |  |  |  | Material | 50 | [NAME] issue
 |  |  |  | Material | 50 | Top layer
 |  |  |  | Material | 50 | [NAME] issue
Spreadsheet: 158972d1338470023-scrolling-chart-not-working-in-2007-scroll_example
Sheet: Sheet1

 | Site # | Site Name | Value
 | 1 | A |  |  | Scrolling Chart Example
 | 2 | B
 | 3 | C
 | 4 | D
 | 5 | E |  |  | 21 | < START from control
 | 6 | F
 | 7 | G |  |  | 10 | < STEP
 | 8 | H |  |  |  | no. displayed
 | 9 | I
 | 10 | J
 | 11 | K |  |  | =OFFSET(REFERENCE,ROWS,COLS,HEIGHT,WIDTH)
 | 12 | L
 | 13 | M
 | 14 | N
 | 15 | O
 | 16 | P
 | 17 | Q
 | 18 | R
 | 19 | S
 | 20 | T
 | 21 | U
 | 22 | V
 | 23 | W
 | 24 | X
 | 25 | Y
 | 26 | Z
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
Spreadsheet: 266597d1379674239-how-to-automatically-time-update-in-a-column-time
Sheet: FOR YOU

S.NO | TYPE | DATE | TIME | CAF DATE | RECEIPT | AMOUNT | ENTRY/DEP | MISSION | Pincode | CAF NO
1 | P2P | 2013-09-19 00:00:00 | 19:28:00 | 2013-09-19 00:00:00 |  |  | GOVT | 9884434343 | 623504 | PTNE213019
2 | NR | 2013-09-19 00:00:00 | 19:28:00 | 2013-09-19 00:00:00 | 15418 | 250 | D | 9884455533 | 620010 | CTNA 234938
3 | MNP | 2013-09-19 00:00:00 | 19:28:00 | 2013-09-19 00:00:00 |  |  |  | 9884455555 | 641402 | CTNA167860
4 | P2P | 2013-09-19 00:00:00 |  | 2013-09-19 00:00:00 |  |  | CORP | 9884485786 | 621212 | CTNA155310
5 | NR | 2013-09-19 00:00:00 |  | 2013-09-19 00:00:00 |  |  | CORP | 9047437177 | 621212 | CTNA155311
6 | MNP | 2013-09-19 00:00:00 |  | 2013-09-19 00:00:00 |  |  |  | 8754339344 | 642005 | CTNA167665
7 | P2P | 2013-09-19 00:00:00 |  | 2013-09-19 00:00:00 | 15412 | 250 | CORP | 9655567676 | 620008 | CTNA155312
8 | NR | 2013-09-19 00:00:00 |  | 2013-09-19 00:00:00 | 15413 | 250 | CORP | 9943336069 | 630302 | CTNA155313
9 | NR | 2013-09-19 00:00:00 |  | 2013-09-19 00:00:00 | 9625 | 250 | D | 9047454000 | 638005 | CTNA207342
 |  |  |  |  |  |  |  | If I entered numbers in this column , time will automatically update in time column, is it possible ?
Spreadsheet: 61489d1262369010-totals-how-can-i-group-values-to-give-totals-712451-totals-how-can-i-group-values-to-give-totals
Sheet: Sheet1

Value
100
100
100 |  |  |  | Row Labels | Count of Value
20 |  |  |  | 100 | 3
20 |  |  |  | 20 | 3
20 |  |  |  | 13 | 4
13 |  |  |  | 8 | 5
13
13
13
8
8
8
8
8
Spreadsheet: 743896d1628797980-help-correlate-an-output-based-on-two-inputs-time-per-cut-orrie
Sheet: Sheet3

Sum of TIME PER CUT | Column Labels
Row Labels | 2.8 | 5 | 5.2 | 5.3 | 5.5 | 5.6 | 5.8 | 6 | 6.1 | 6.2 | 6.45 | 6.5 | 6.7 | 6.8 | 7 | 7.5 | 7.6 | 7.8 | 8 | 8.4 | 9 | 9.2 | 9.4 | 9.5 | 10 | 10.5 | Grand Total
29.25 |  |  |  |  | 7.7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.7
32.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.75 |  |  | 5.48 | 5.7 |  | 4.66 |  |  | 4.6 |  | 26.19
33.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.38 |  | 5 |  |  |  | 10.38
34.5 |  | 19.2 |  |  |  |  |  | 8.5 |  | 8.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.6
38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.75 |  |  |  |  |  |  |  |  |  | 6.75
41.25 |  |  |  |  | 10.5 |  |  |  |  | 8.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
42.19 |  |  |  |  |  |  |  |  | 9.35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.35
42.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.7 |  |  | 6.7
43 |  |  |  |  |  |  |  |  |  |  |  |  |  | 18.15 |  |  |  |  |  |  |  |  |  |  |  |  | 18.15
43.5 |  |  |  |  |  |  |  |  |  |  | 10.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.1
46.28 |  |  |  |  |  |  |  |  | 9.65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.65
48 | 22.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22.5
48.5 |  |  |  |  |  |  |  |  |  |  |  |  | 10.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.5
50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.2 |  |  |  |  |  |  |  |  | 10.2
50.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.8 |  |  |  |  |  |  |  |  |  |  |  | 10.8
53 |  |  |  |  |  | 13.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.9
56.5 |  |  |  | 13.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.9
62.375 |  |  |  |  |  | 14.63 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14.63
63.95 |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
65 |  |  | 16.2 |  |  |  | 5.5 |  |  |  |  | 12.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.9
66 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.3 | 9.3
Grand Total | 22.5 | 19.2 | 16.2 | 13.9 | 18.2 | 39.53 | 5.5 | 8.5 | 19 | 17.4 | 10.1 | 12.2 | 10.5 | 18.15 | 10.8 | 5.75 | 6.75 | 10.2 | 5.48 | 5.7 | 5.38 | 4.66 | 5 | 6.7 | 4.6 | 9.3 | 311.2
Spreadsheet: 1eaa78c3-f7e5-4b21-8a9d-8caa2715dbc6
Sheet: Sheet1

Table 10--U.S. oilseed meal prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Marketing | Soybean | Cottonseed | Sunflowerseed | Peanut | Canola | Linseed
year | meal 2 | meal 3 | meal 4 | meal 5 | meal 6 | meal 7
 | $/Short ton
2001/02 | 167.72 | 136.16 | 87.27 | 112.32 | 143.33 | 121.29
2002/03 | 181.58 | 146.12 | 105 | 128.35 | 144.06 | 122.91
2003/04 | 256.05 | 183.47 | 111.14 | 177.56 | 188.45 | 159.25
2004/05 | 182.9 | 124.04 | 85.5 | 118.34 | 139.75 | 115.55
2005/06 | 174.1658333333333 | 144.2716666666667 | 77.46400000000001 | 106.9781818181818 | 140.5183333333333 | 115.53
2006/07 | 205.44 | 150.36 | 104.88 | 100 | 173.5 | 133.01
2007/08 | 335.94 | 253.81 | 172.81 |  | 251.32 | 228.81
2008/09 | 331.17 | 255.23 | 152.46 |  | 248.82 | 220.89
2009/10 | 311.27 | 220.9 | 151.04 |  | 224.92 | 209.23
2010/11 | 345.52 | 273.84 | 219.72 |  | 263.63 | 240.65
2011/12 | 393.53 | 275.13 | 246.75 |  | 307.59 | 265.68
2012/131 | 415-435 | 295-315 | 230-250 |  | 320-340 | 280-300
2011/12
October | 301.45 | 255.63 | 232.5 |  | 238.7 | 243.75
November | 290.37 | 240.5 | 224 |  | 235.2 | 239
December | 281.65 | 220.63 | 225.63 |  |  | 221.25
January | 310.65 | 213 | 223.5 |  | 253.98 | 209
February | 330.37 | 190 | 191.88 |  | 257.63 | 193.75
March | 365.95 | 225 | 191.88 |  | 277.83 | 216.25
April | 394.29 | 240.63 | 211.25 |  | 313.38 | 256.25
May | 415.17 | 270 | 230.5 |  | 333.69 | 279
June | 422.59 | 294.38 | 226.88 |  | 335.26 | 287.5
July | 515.82 | 350.5 | 300.5 |  | 378.86 | 343
August | 564.69 | 407.5 | 348.13 |  | 388.13 | 358.75
September | 529.37 | 393.75 | 354.38 |  | 370.79 | 340.63
2012/13
October | 488.46 | 343 | 287 |  | 354.49 | 334
November | 465.64 | 376.88 | 269.38 |  | 334.46 | 297.5
December | 459.4 | 345 | 266.67 |  | 349.55 | 335.83
January | 431.39 | 327.5 | 252 |  | 347.22 | 296
February | 440.66 | 279.38 | 237.5 |  | 359.23 | 303.75
March1 | 437.33 | 301.88 | 231.25 |  | 356.74 | 303.75
1 Preliminary.  2 High-protein Decatur, IL.  3 41-percent Memphis.  4 34-percent North Dakota-Minnesota.
5 50-percent Southeast mills.  6 36-percent Pacific Northwest. 7 34-percent Minneapolis.
NA= Not available.
Source: USDA, Agricultural Marketing Service, Monthly Feedstuff Prices.
Last update: | 2013-04-12 11:42:35.210000
Spreadsheet: 6aa4da68-30da-41c5-a9e7-0b7d20b2f0e7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-04-15 09:17:59.710000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 102 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
5.125 | 101.349 | 101.099 | 100.974 | 100.599
5 | 100.924 | 100.674 | 100.549 | 100.174 |  | Note: | Refer To Price [NAME]
4.875 | 100.379 | 100.129 | 100.004 | 99.629 |  |  | For all Price Adjs
4.75 | 99.395 | 99.145 | 99.02
4.625 | 98.238 | 97.988 | 97.863
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.5 | 101.773 | 101.523 | 101.398 | 101.023
4.375 | 101.393 | 101.143 | 101.018 | 100.643
4.25 | 100.856 | 100.606 | 100.481 | 100.106
4.125 | 99.74 | 99.49 | 99.365 | 98.99
4 | 99.403 | 99.153 | 99.028
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-04-29 09:17:59.710000
30 DAY | 2011-05-14 09:17:59.710000
45 DAY | 2011-05-29 09:17:59.710000
60 DAY | 2011-06-13 09:17:59.710000
90 DAY | 2011-07-13 09:17:59.710000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 713476d1610729092-using-countifs-across-numerous-columns-within-a-subtotal-forum-example
Sheet: Sheet1

 | # of Outlets | Green | Amber | Red
01. Bar
02. Bar & Kitchen
03. Events Venue
04. Holiday Park
05. Hotel
06. [NAME]
07. Local
08. [NAME]
09. Restaurant
10. Sports/Social Club
11. Leisure/Health Club
12. Unknown
Total
 | % Open
Outlet Type | Outlet Quality | Outlet Open? | Owner | Outdoor Space?
01. Bar | P | GREEN | Company A | Y
02. Bar & Kitchen | P | AMBER | Company B | N
03. Events Venue | U | RED | Company C | Y
04. Holiday Park | P | GREEN | Company A | N
05. Hotel | P | AMBER | Company B | Y
06. [NAME] | U | RED | Company C | N
07. Local | P | GREEN | Company A | Y
08. [NAME] | V | AMBER | Company B | N
09. Restaurant | M | RED | Company C | Y
10. Sports/Social Club | P | GREEN | Company A | N
11. Leisure/Health Club | U | AMBER | Company B | Y
12. Unknown | U | RED | Company C | N
01. Bar | P | GREEN | Company A | Y
02. Bar & Kitchen | P | AMBER | Company B | N
03. Events Venue | V | RED | Company C | Y
04. Holiday Park | U | GREEN | Company A | N
05. Hotel | P | AMBER | Company B | Y
06. [NAME] | P | RED | Company C | N
07. Local | M | GREEN | Company A | Y
08. [NAME] | M | AMBER | Company B | N
09. Restaurant | P | RED | Company C | Y
10. Sports/Social Club | M | GREEN | Company A | N
11. Leisure/Health Club | U | AMBER | Company B | Y
12. Unknown | P | RED | Company C | N
01. Bar | M | GREEN | Company A | Y
02. Bar & Kitchen | P | AMBER | Company B | N
03. Events Venue | M | RED | Company C | Y
04. Holiday Park | P | GREEN | Company A | N
05. Hotel | V | AMBER | Company B | Y
06. [NAME] | M | RED | Company C | N
07. Local | V | GREEN | Company A | Y
08. [NAME] | M | AMBER | Company B | N
09. Restaurant | P | RED | Company C | Y
10. Sports/Social Club | M | GREEN | Company A | N
11. Leisure/Health Club | V | AMBER | Company B | Y
12. Unknown | P | RED | Company C | N
01. Bar | P | GREEN | Company A | Y
02. Bar & Kitchen | P | AMBER | Company B | N
03. Events Venue | M | RED | Company C | Y
04. Holiday Park | P | GREEN | Company A | N
05. Hotel | M | AMBER | Company B | Y
06. [NAME] | P | RED | Company C | N
07. Local | P | GREEN | Company A | Y
08. [NAME] | P | AMBER | Company B | N
09. Restaurant | P | RED | Company C | Y
10. Sports/Social Club | P | GREEN | Company A | N
11. Leisure/Health Club | V | AMBER | Company B | Y
12. Unknown | U | RED | Company C | N
01. Bar | P | GREEN | Company A | Y
02. Bar & Kitchen | P | AMBER | Company B | N
03. Events Venue | V | RED | Company C | Y
04. Holiday Park | P | GREEN | Company A | N
05. Hotel | M | AMBER | Company B | Y
Spreadsheet: 719963d1613932644-formula-with-multiple-criteria-excelhelp2
Sheet: Weeks

 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11
Customer 1
Customer 2
Customer 3
Customer 4
Customer 5
Customer 6
Customer 7
Customer 8
Customer 9
Customer 10
Spreadsheet: 134632d1325525298-multiple-values-within-a-single-worksheet-cell-excel-forum-submission-010212
Sheet: Sheet1

2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00
OFF | 9am-5pm | 9am-5pm | 9am-5pm | 8v | 8v | OFF | OFF | 1v 7s | 8s | 12pm-5pm 3s | 9am-5pm | OFF
Vacation |  | (should total 17)
Sick |  | (should total 18)
Spreadsheet: 832580d1686450568-sum-up-until-a-blank-cell-appears-summations
Sheet: Sheet1

All the red zeros are cells that reference another worksheet. Aka, they have formulas.
This summation forward I would like to not see. I have been trying to play around with my current formula to somehow detect the blank row and no longer continue with the summation.
What I currently have |  |  |  |  |  |  | What I want
Room # | Room Name | Individual Size | Group size |  |  |  | Room # | Room Name | Individual Size | Group size
1-a | KITCHEN LEVEL 1 | 1300.888888888888 |  |  |  |  | 1-a | KITCHEN LEVEL 1 | 1300.888888888888
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
1-b | KITCHEN LEVEL 2 | 405.555555555555 |  |  |  |  | 1-b | KITCHEN LEVEL 2 | 405.555555555555
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
1-c | KITCHEN LEVEL 3 | 833.3333333333352 |  |  |  |  | 1-c | KITCHEN LEVEL 3 | 833.3333333333352
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
1-04 | PROGRAM LEVEL 1 | 309.9999999999972 |  |  |  |  | 1-04 | PROGRAM LEVEL 1 | 309.9999999999972
 | PROGRAM LEVEL 1 | 309.9999999999972 |  |  |  |  |  | PROGRAM LEVEL 1 | 309.9999999999972
0 | 0 | 0 |  |  |  |  | 0
1-d | PROGRAM LEVEL 2 | 1379.999999999999 |  |  |  |  | 1-d | PROGRAM LEVEL 2 | 1379.999999999999
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
1-e | PROGRAM LEVEL 3 | 309.9999999999997 |  |  |  |  | 1-e | PROGRAM LEVEL 3 | 309.9999999999997
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
1-f | LOBBY LEVEL 1 | 613.3333333333319 |  |  |  |  | 1-f | LOBBY LEVEL 1 | 613.3333333333319
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
1-g | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  | 1-g | LOBBY LEVEL 2 | 275.555555555558
 | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  | LOBBY LEVEL 2 | 275.555555555558
 | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  | LOBBY LEVEL 2 | 275.555555555558
 | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  | LOBBY LEVEL 2 | 275.555555555558
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
1-h | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  | 1-h | LOBBY LEVEL 2 | 275.555555555558 | 551.111111111116
 | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  | LOBBY LEVEL 2 | 275.555555555558
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
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
Spreadsheet: john_griffith__15702__fpl calc sheet feb put 2
Sheet: CashFlow Summary

 |  |  |  |  |  | 40 | Mobile Bay | 20
 | FPL Synthetic Storage Summary |  |  |  |  | 25 | Zone 2 | 12.5
 |  |  |  |  |  | 10 | Zone 1 | 5
 | 2001-01-24 00:00:00 | 75000 | 2
 |  | Volume | Nymex | Basis | Index | Nominal | Discount | PV | PV | Payment | Libor-AA
 | Month | Buy/(Sale) | Quote | Quote | Quote | Cashflow | Factor | Cashflow | Volume | Date | Quote
 | 2001-02-01 00:00:00 |  | 7.21 | -0.06 | 0 |  |  |  |  | 2001-03-25 00:00:00 | 0.05946622211267301
 | 2001-06-01 00:00:00 |  | 5.56 | -0.0075 | 0 |  |  |  |  | 2001-07-25 00:00:00 | 0.05553405683868101
 | 2001-07-01 00:00:00 |  | 5.56 | -0.0075 | 0 |  |  |  |  |  | 0.05493308450279501
 | 2001-08-01 00:00:00 |  | 5.56 | -0.0075 | 0 |  |  |  |  |  | 0.054332112287208
 | 2001-09-01 00:00:00 |  | 5.56 | -0.0075 | 0 |  |  |  |  |  | 0.05385683531918602
 | 2001-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  | payment up-front amount
 |  |  |  | \ |  |  | Interest charge |  |  | 2001-03-25 00:00:00 | 0.05946622211267301
 |  |  |  |  |  | Payment made to FPL on
Volume | [NAME] | Wtd. Average | Total |  |  |  |  | 50000
10 | -0.02 |  |  |  |  |  | Done
25 | 0.02
40 | -0.025 |  |  |  |  |  |  | 35000
Spreadsheet: 854517d1704362553-trying-to-use-unique-function-to-create-tracker-trial-sheet
Sheet: Calc

DATE | Enitity | DEPARTMENT | CLASS | Session 1 | Session 2 | Session 3
Example
2023-11-24 00:00:00 |  | Finance |  | 2 | 2
2023-11-24 00:00:00 |  | Front Office |  | 6 | 6
2023-11-29 00:00:00 |  | Nurses |  | 13 | 13 | 13
2023-11-29 00:00:00 |  | Physicians |  | 27
2023-12-08 00:00:00 |  | Finance |  | 2 | 2
2023-12-08 00:00:00 |  | Front Office |  | 4 | 4
2023-12-15 00:00:00 |  | Finance |  |  |  | 1
2023-12-16 00:00:00 |  | Finance |  |  |  | 1
Spreadsheet: c7834567-92b0-4bc0-8f3a-f1c08bfdbeee
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7854 | 13651 | Martin | Falch | AUT | 64 | 00:24:39 | [NAME] | 00:34:04 | 00:02:21 | 00:26:13 | 1 | 01:29:47
7854 | 57017 | Reitze | Bok | NED | 63 | 00:21:02 | 00:01:53 | 00:35:16 | 00:03:10 | 00:29:37 | 2 | 01:30:57
Spreadsheet: 551671d1513085023-frequency-distribution-problem-workbook1
Sheet: Sheet2

12 | 14 | 19 | 18
15 | 15 | 18 | 17
20 | 27 | 22 | 23
22 | 21 | 33 | 28
14 | 18 | 16 | 13
Bin | frequency
14
19 | #[NAME]?
24 | #[NAME]?
29 | #[NAME]?
34 | #[NAME]?