tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 549832d1511954923-vlookup-with-match-function-test
Sheet: Interpretation_Rev1

KP Start | Schedule 22 Min Speed (m/hr) | Expected result |  |  | Start KP | Stop KP | Minimum Burial speed (m/h)
70.4890000000023 |  | 81 |  |  | 70.474 |  | 81
70.4900000000023 |  | 81 |  |  | 71.02109 | 72.356 | 81
70.4910000000023 |  | 81 |  |  | 72.3562 | 72.967 | 81
70.4920000000023 |  | 81 |  |  | 72.967 | 73.97965 | 81
70.4930000000024 |  | 81 |  |  | 73.97965 | 74.96992 | 81
70.4940000000024 |  | 81 |  |  | 74.96992 | 75.92519 | 81
70.4950000000024 |  | 81 |  |  | 75.92519 | 77.98744 | 81
70.4960000000024 |  | 81 |  |  | 77.98744 | 78.99078 | 100
70.4970000000024 |  | 81 |  |  | 78.99078 | 82.005 | 190
70.4980000000024 |  | 81 |  |  | 82.005 | 82.9441 | 190
70.4990000000024 |  | 81 |  |  | 82.9441 | 85.01115 | 153
70.5000000000024 |  | 81 |  |  | 85.01115 | 86.07169 | 87
70.5010000000024 |  | 81 |  |  | 86.07169 | 86.99271 | 87
70.5020000000024 |  | 81 |  |  | 86.99271 | 87.7476 | 87
70.5030000000024 |  | 81 |  |  | 87.7476 | 88.60056 | 87
70.5040000000024 |  | 81 |  |  | 88.60056 | 89.6694 | 87
70.5050000000024 |  | 81 |  |  | 89.6694 | 89.92472 | 87
70.5060000000024 |  | 81 |  |  | 89.92472 | 90.87414 | 87
70.5070000000024 |  | 81 |  |  | 90.87414 | 92.90171 | 87
70.5080000000024 |  | 81 |  |  | 92.90171 | 93.99482 | 87
70.5090000000024 |  | 81 |  |  | 93.99482 | 94.94792 | 87
70.5100000000024 |  | 81 |  |  | 94.94792 | 95.96433 | 87
70.5110000000024 |  | 81 |  |  | 95.96433 |  | 87
70.5120000000024 |  | 81 |  |  | 96.19409 | 96.3258
70.5130000000024 |  | 81 |  |  |  | 98.98056 | 87
70.5140000000025 |  | 81 |  |  |  | 99.41724 | 150
70.5150000000025 |  | 81 |  |  | 99.41724 | 99.96499 | 150
70.5160000000025 |  | 81 |  |  | 99.96499 | 100.14456 | 150
70.5170000000025 |  | 81 |  |  |  | 100.96085 | 107
70.5180000000025 |  | 81 |  |  | 100.96085 | 102.73333 | 107
70.5190000000025 |  | 81 |  |  | 102.73333 | 106.53045 | 107
70.5200000000025 |  | 81 |  |  | 106.53045 | 107.13664 | 74
70.5210000000025 |  | 81 |  |  | 107.13664 | 107.88334 | 74
70.5220000000025 |  | 81 |  |  | 107.88334 | 108.66357 | 74
70.5230000000025 |  | 81 |  |  | 108.66357 | 109.49037 | 56
82.94 |  | 190 |  |  | 109.49037 | 110.02472 | 56
88.602 |  | 87 |  |  | 110.02472 | 110.96233 | 58
 |  |  |  |  | 110.96233 | 111.97156 | 100
 |  |  |  |  | 111.97156 | 112.83777 | 100
 |  |  |  |  | 112.83777 | 113.60087 | 100
 |  |  |  |  | 113.60087 | 114.5734 | 100
 |  |  |  |  | 114.5734 | 115.31222 | 100
 |  |  |  |  |  | 116.65982 | 150
 |  |  |  |  |  | 117.15259 | 107
 |  |  |  |  | 117.15259 | 118.06932 | 127
 |  |  |  |  | 118.06932 | 120.98744 | 127
 |  |  |  |  |  |  | 116
 |  |  |  |  | 123.49854 | 124.22918 | 150
 |  |  |  |  | 124.22918 |  | 150
 |  |  |  |  | 124.88348 |  | 150
 |  |  |  |  | 125.49 |  | 150
 |  |  |  |  | 126.90248 | 128.827 | N/A
Spreadsheet: 713540d1610772514-how-to-calculate-exeact-sum-and-using-formula-calculation-sum-and-
Sheet: Sheet1

 | % | Total | Count | Total Rent | Rent for CC | Sum() | Diff.
 | 0.2424242424242424 |  | 1
 | 0.2121212121212121 |  | 1
 | 0.1515151515151515 |  | 1
 | 0.0303030303030303 |  | 1
 | 0.0303030303030303 |  | 1
 | 0.1212121212121212 |  | 1
 | 0.1515151515151515 |  | 1
 | 0.06060606060606061 |  | 1
 |  |  | 1 Total | 123
 | 0.5 |  | 2
 | 0.5 |  | 2
 |  |  | 2 Total | 1001
 | 0.09523809523809523 |  | 3
 | 0.4761904761904762 |  | 3
 | 0.04761904761904762 |  | 3
 | 0.2380952380952381 |  | 3
 | 0.1428571428571428 |  | 3
 |  |  | 3 Total | 127
Spreadsheet: 5de3fc3e-065f-4a0b-a83e-efc71793782c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Housing and Interest Rate Forecast, 8/1/2014
 |  | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00
 | Housing Activity (000)
 | Total Housing Starts | 585.5 | 611.916666666666 | 783.75 | 929.6666666666661 | 986.0611386759259 | 1243.986816571454 | 1540.640459570822
 | Single Family | 471.416666666667 | 434.333333333333 | 537 | 621.083333333333 | 642.7378035937501 | 874.8892835056531 | 1173.051712786525
 | Multifamily | 114.083333333333 | 177.583333333333 | 246.75 | 308.583333333333 | 343.3233350821758 | 369.0975330658005 | 367.5887467842968
 | New Single Family Sales | 321.25 | 306.416666666667 | 367.833333333333 | 430.333333333333 | 441.1856785516343 | 596.7988373326483 | 839.1632688994748
 | Existing Single-Family Home Sales | 3705 | 3792.5 | 4130 | 4470.83333333333 | 4251.417598447804 | 4523.575040093679 | 4663.296958591165
 | Interest Rates
 | Federal Funds Rate | 0.00125 | 0.00125 | 0.00125 | 0.00125 | 0.00125 | 0.0025 | 0.0175
 | 90 day T [NAME] | 0.00136666666666667 | 0.000525 | 0.000858333333333333 | 0.000583333333333333 | 0.000323625 | 0.00149829951171875 | 0.015
 | Treasury Yields:
 | One Year Maturity | 0.00318333333333333 | 0.00181666666666667 | 0.00175 | 0.00131666666666667 | 0.00110681583333333 | 0.003373538247291384 | 0.0177
 | Ten Year Maturity | 0.0321416666666667 | 0.0278583333333333 | 0.018025 | 0.0235083333333333 | 0.02796666666666665 | 0.03840995604000001 | 0.044504560906934
 | Freddie Mac Commitment Rates:
 | Fixed Rate Mortgages | 0.0469058332840602 | 0.0445583335856597 | 0.0365591666400433 | 0.0398191666666667 | 0.04369916666666668 | 0.05490995604000001 | 0.06100456090693399
 | ARMs | 0.0378874999384085 | 0.0303991668621699 | 0.0268816664616267 | 0.0261245833333333 | 0.02461698250000001 | 0.02787353824729139 | 0.0417
 | Prime Rate | 0.0325 | 0.0325 | 0.0325 | 0.0325 | 0.0325 | 0.033125 | 0.0475
 | Data are averages of seasonally adjusted quarterly data and may not match annual
 | data published elsewhere.
 | For more forecast details, visit www.HousingEconomics.com.
Spreadsheet: 797850d1664197244-convert-the-xx-xx-xxx-text-onto-numbers-for-sum-up-question
Sheet: _PRD_ VMI Report #all plants# R

Vendor | Current Date | Plant | Plant Description | Material | Material Description | Requirements Date | Requirement Quantity | Open Order Qty | Order unit | Purchase Order(s) | Purchasing group | Purch.group name | Plant status | Plant status description | MRP-Area | MRP-Area description
905937 | 08.09.2022 | P003 | Ontex Eeklo (Eutima) | G1.431 | FF U RAY JLDE ECF 8% 508/1511 FSC | 05.09.2022 | 4.265,009 | 0 | DKG |  | 102
905937 | 08.09.2022 | P003 | Ontex Eeklo (Eutima) | G1.431 | FF U RAY JLDE ECF 8% 508/1511 FSC | 12.09.2022 | 7.506,489 | 130.000,000 | DKG | [PHONE]-000010 | 102
905937 | 08.09.2022 | P003 | Ontex Eeklo (Eutima) | G1.431 | FF U RAY JLDE ECF 8% 508/1511 FSC | 19.09.2022 | 21.307,508 | 130.000,000 | DKG | [PHONE]-000010 | 102
905937 | 08.09.2022 | P003 | Ontex Eeklo (Eutima) | G1.431 | FF U RAY JLDE ECF 8% 508/1511 FSC | 26.09.2022 | 28.006,023 | 0 | DKG |  | 102
905937 | 08.09.2022 | P003 | Ontex Eeklo (Eutima) | G1.431 | FF U RAY JLDE ECF 8% 508/1511 FSC | 03.10.2022 | 33.280,574 | 0 | DKG |  | 102
905937 | 08.09.2022 | P003 | Ontex Eeklo (Eutima) | G1.431 | FF U RAY JLDE ECF 8% 508/1511 FSC | 10.10.2022 | 40.241,789 | 0 | DKG |  | 102
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: GOA

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
[NAME] CN | 10737 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-26 00:00:00 | 297475 | [NAME] | 11162 | 5
GOAT TRP BERRY 12/12Z CN | 10735
GOAT PK  CANDY 12/12Z CN | 10736
[NAME] | 10907
GOAT PEACH PIN 12/12Z CN | 10906
GOAT GUMMY BEA 12/12Z CN | 10908
GOAT MNGO PSSN 12/12Z CN | 10965
[NAME] 12/12Z CN | 11071
[NAME] | 11162
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
[NAME] CN | 10737
GOAT TRP BERRY 12/12Z CN | 10735
GOAT PK  CANDY 12/12Z CN | 10736
[NAME] | 10907
GOAT PEACH PIN 12/12Z CN | 10906
GOAT GUMMY BEA 12/12Z CN | 10908
GOAT MNGO PSSN 12/12Z CN | 10965
[NAME] 12/12Z CN | 11071
[NAME] | 11162
Spreadsheet: 1a27dd9b-8643-4550-81d3-ada6c47ec0be
Sheet: Sheet1

Table 6--U.S. textile imports, by fiber | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Dec. | Jan. | Feb. | Feb
Item | 2012 | 2013 | 2013 | 2012
 | 1,000 pounds 1/
[NAME], thread, and fabric: | 219435.181 | 252843.201 | 233182.734 | 213268.822
Cotton | 46700.87 | 53632.401 | 49718.474 | 47266.068
Linen | 19382.952 | 25325.432 | 17408.625 | 16580.406
Wool | 3358.762 | 3555.503 | 3126.851 | 3149.176
Silk | 529.848 | 546.943 | 429.056 | 603.801
Manmade | 149462.749 | 169782.922 | 162499.728 | 145669.371
Apparel: | 790893.1270000001 | 889304.1190000001 | 875083.9299999999 | 758790.887
Cotton | 451946.669 | 499298.839 | 499440.142 | 443759.827
Linen | 7010.917 | 9830.58 | 10397.966 | 10180.045
Wool | 16110.126 | 18543.334 | 17178.492 | 14730.791
Silk | 7282.568 | 10045.461 | 10301.503 | 8653.147
Manmade | 308542.847 | 351585.905 | 337765.827 | 281467.077
Home furnishings: | 193737.573 | 214129.219 | 213658.218 | 164412.593
Cotton | 106733.187 | 123562.709 | 123263.348 | 100501.3
Linen | 986.727 | 920.439 | 864.426 | 649.515
Wool | 258.593 | 402.997 | 315.166 | 340.677
Silk | 147.569 | 146.094 | 174.805 | 86.452
Manmade | 85611.497 | 89096.98 | 89040.473 | 62834.649
Floor coverings: | 60398.113 | 66620.488 | 56210.929 | 50710.122
Cotton | 7205.327 | 7884.405 | 6695.796 | 6144.344
Linen | 14811.735 | 18081.768 | 15384.178 | 12955.836
Wool | 10405.418 | 9271.104 | 7792.537 | 7203.939
Silk | 1796.64 | 1618.289 | 1205.358 | 1571.43
Manmade | 26178.993 | 29764.922 | 25133.06 | 22834.573
Total imports: 2/ | 1264806.479 | 1423362.61 | 1378474.213 | 1187836.767
Cotton | 612768.141 | 684611.241 | 679320.418 | 597884.075
Linen | 42192.33 | 54158.219 | 44055.195 | 40365.803
Wool | 30149.962 | 31778.068 | 28420.061 | 25433.599
Silk | 9756.625 | 12356.788 | 12110.723 | 10914.83
Manmade | 569939.421 | 640458.294 | 614567.816 | 513238.46
1/ Raw-fiber equivalent.  2/ Includes headgear.
Sources: USDA, Economic Research Service; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update: 04/12/13.
Spreadsheet: 133285d1324316453-excel-2007-how-to-do-a-data-fitting-test
Sheet: Sheet1

Ƞ(cP) | Ƞ(cP) | Ƞav(cP) | T(C°)
125 | 119 |  | 10
160.8 | 159.8 |  | 12
134.8 | 134 |  | 15
116.8 | 116.4 |  | 17
96.2 | 95.8 |  | 20
84.2 | 83.8 |  | 22
66.4 | 66.2 |  | 25
58.6 | 57.8 |  | 27
45.8 | 45.4 |  | 30
66.1 | 65.7 |  | 32
56.8 | 56.5 |  | 35
52.3 | 52.1 |  | 37
46.3 | 46.1 |  | 40
42.8 | 42.7 |  | 42
37.6 | 37.3 |  | 45
34.7 | 34.6 |  | 47
31.4 | 31 |  | 50
29.2 | 29 |  | 52
26.1 | 25.9 |  | 55
23.4 | 23.4 |  | 57
22.1 | 22 |  | 60
21 | 21 |  | 62
Spreadsheet: john_griffith__15560__Brazos-Volumes
Sheet: Preston Oil Vol.

 |  | PRESTON VPP
 |  | Scheduled Volumes and Cash Flows for Oil Volumes
 |  | Delivery Point:  BP Amoco Charenton
 |  | Index:  NYMEX TWI less basis adjustments |  |  |  |  |  | Class A Volumes and Notional Amounts |  |  | Class B Volumes and Notional Amounts
 |  | Vol/ Day | Vol/ Month | Contract Price | Gross Value
 |  |  |  |  |  |  |  | [NAME] | Notional Value |  | [NAME] | Notional Value
 |  |  | 415205 |  | 10543126.6
2000-12-31 00:00:00 | 31 | 540 | 16740 | 31 | 518940
2001-01-31 00:00:00 | 31 | 550 | 17050 | 25.59 | 436309.5
2001-02-28 00:00:00 | 28 | 600 | 16800 | 25.59 | 429912
2001-03-31 00:00:00 | 31 | 530 | 16430 | 25.59 | 420443.7
2001-04-30 00:00:00 | 30 | 540 | 16200 | 25.59 | 414558
2001-05-31 00:00:00 | 31 | 515 | 15965 | 25.59 | 408544.35
2001-06-30 00:00:00 | 30 | 525 | 15750 | 25.59 | 403042.5
2001-07-31 00:00:00 | 31 | 500 | 15500 | 25.19 | 390445
2001-08-31 00:00:00 | 31 | 485 | 15035 | 25.19 | 378731.65
2001-09-30 00:00:00 | 30 | 490 | 14700 | 25.19 | 370293
2001-10-31 00:00:00 | 31 | 465 | 14415 | 25.19 | 363113.85
2001-11-30 00:00:00 | 30 | 470 | 14100 | 25.19 | 355179
2001-12-31 00:00:00 | 31 | 450 | 13950 | 25.19 | 351400.5
2002-01-31 00:00:00 | 31 | 435 | 13485 | 25.09 | 338338.65
2002-02-28 00:00:00 | 28 | 475 | 13300 | 25.09 | 333697
2002-03-31 00:00:00 | 31 | 420 | 13020 | 25.09 | 326671.8
2002-04-30 00:00:00 | 30 | 430 | 12900 | 25.09 | 323661
2002-05-31 00:00:00 | 31 | 410 | 12710 | 25.09 | 318893.9
2002-06-30 00:00:00 | 30 | 415 | 12450 | 25.09 | 312370.5
2002-07-31 00:00:00 | 31 | 400 | 12400 | 24.94 | 309256
2002-08-31 00:00:00 | 31 | 390 | 12090 | 24.94 | 301524.6
2002-09-30 00:00:00 | 30 | 445 | 13350 | 24.94 | 332949
2002-10-31 00:00:00 | 31 | 425 | 13175 | 24.94 | 328584.5
2002-11-30 00:00:00 | 30 | 430 | 12900 | 24.94 | 321726
2002-12-31 00:00:00 | 31 | 410 | 12710 | 24.94 | 316987.4
2003-01-31 00:00:00 | 31 | 385 | 11935 | 24.79 | 295868.65
2003-02-28 00:00:00 | 28 | 400 | 11200 | 24.79 | 277648
2003-03-31 00:00:00 | 31 | 325 | 10075 | 24.79 | 249759.25
2003-04-30 00:00:00 | 30 | 300 | 9000 | 24.79 | 223110
2003-05-31 00:00:00 | 31 | 270 | 8370 | 24.79 | 207492.3
2003-06-30 00:00:00 | 30 | 250 | 7500 | 24.49 | 183675
2003-07-31 00:00:00
Spreadsheet: 299305d1393100416-first-payment-of-each-group-thau-khoan-ver2
Sheet: Pivot1

Group | thu | <-Choose
Som [NAME] |  | Date
Contract | [NAME] | 2013-08-07 00:00:00 | 2013-08-19 00:00:00 | 2013-08-20 00:00:00 | 2013-08-29 00:00:00 | 2013-09-15 00:00:00 | 2013-10-01 00:00:00 | 2013-11-15 00:00:00 | 2013-12-03 00:00:00 | 2013-12-16 00:00:00 | 2013-12-31 00:00:00 | 2014-01-16 00:00:00 | 2014-01-27 00:00:00 | 2014-02-17 00:00:00 | Eindtotaal
434 | Đường ống sấy tinh bột thuộc Công trình nhà máy chế biến tinh bột [NAME] | 10000000 | 8000000 | 10000000 | 25600000 | 20000000 | 15000000 | 10000000 |  |  |  |  |  |  | 98600000
437 | [NAME] đặt 02 lò đốt trấu Xưởng phân bón |  |  |  |  |  |  | 3300000 | 20000000 | 4250000 |  |  | 1000000 |  | 28550000
443 | [NAME] bồn 1500 m3 [NAME] T 821F |  |  |  |  |  |  |  | 500000 | 1250000 |  |  |  |  | 1750000
445 | Sửa chữa bồn 300 m3 [NAME] Acid |  |  |  |  |  |  |  |  | 8500000 | 6250000 | 23250000 | 1250000 |  | 39250000
 | Tạm ứng không khối lượng thi công |  |  |  |  |  |  |  |  |  |  |  | 10000000 |  | 10000000
MBT | [NAME] biến thế |  |  |  |  |  |  |  |  |  |  | 2000000 | 1250000 |  | 3250000
W3-0082-007-ndt | Bồn chứa than [NAME] 307 Tấn/h NaOH 9t |  |  |  |  |  |  |  |  |  |  |  | 9250000 | 18750000 | 28000000
 | Tạm ứng không khối lượng thi công Cao Việt Dũng buổi chiều |  |  |  |  |  |  |  |  |  |  |  | 5000000 |  | 5000000
Eindtotaal |  | 10000000 | 8000000 | 10000000 | 25600000 | 20000000 | 15000000 | 13300000 | 20500000 | 14000000 | 6250000 | 25250000 | 27750000 | 18750000 | 214400000
Spreadsheet: 69859d1270546635-financial-predictions-financial_predictions
Sheet: Sheet1

Log No | Scheme | Length of Course (Years) | Course Start Date | Course End Date | Amount Approved
D.001 | B | 1 | 2010-05-01 00:00:00 | 2011-02-01 00:00:00 | 350
D.002 | A | 2 | 2010-05-02 00:00:00 | 2012-02-02 00:00:00 | 350 |  |  |  | Select Criteria
D.003 | B | 3 | 2010-05-03 00:00:00 | 2013-02-03 00:00:00 | 350 |  |  |  | > |  | <=
D.004 | B | 4 | 2010-05-04 00:00:00 | 2014-02-04 00:00:00 | 350 |  |  |  | Select Financial Year
D.005 | B | 5 | 2010-05-05 00:00:00 | 2015-02-01 00:00:00 | 350 |  |  |  | 2010-04-01 00:00:00 |  | 2011-03-31 00:00:00
D.006 | A | 3 | 2011-05-05 00:00:00 | 2014-08-01 00:00:00 | 350
D.007 | C | 4 | 2011-12-01 00:00:00 | 2015-09-01 00:00:00 | 350 |  |  |  | Course Start Date |  | Course Start Date |  | Scheme
D.008 | B | 3 | 2012-09-01 00:00:00 | 2015-08-01 00:00:00 | 350 |  |  |  | >01/04/10 |  | <=31/03/11 |  | C
D.009 | A | 3 | 2013-08-01 00:00:00 | 2016-08-01 00:00:00 | 350
[NAME] | B | 2 | 2014-06-01 00:00:00 | 2016-09-01 00:00:00 | 350 |  |  |  | Total per financial Year  (Scheme Costs)
 |  |  |  |  |  |  |  |  | Scheme |  |  | Amount Approved
 |  |  |  |  |  |  |  |  | Scheme
 |  |  |  |  |  |  |  |  | C |  |  | 0
 |  |  |  |  |  |  |  |  | Scheme
 |  |  |  |  |  |  |  |  | C
Sum of Amount Approved
Scheme | Course Start Date | Course End Date | Total
A | 2010 | 2012 | 350
 | 2011 | 2014 | 350
 | 2013 | 2016 | 350
A Total |  |  | 1050
B | 2010 | 2011 | 350
 |  | 2013 | 350
 |  | 2014 | 350
 |  | 2015 | 350
 | 2012 | 2015 | 350
 | 2014 | 2016 | 350
B Total |  |  | 2100
C | 2011 | 2015 | 350
C Total |  |  | 350
Grand Total |  |  | 3500
Spreadsheet: 88923d1288729180-excel-scheduling-tool-help-total-scheduled-hours-calendar
Sheet: Sheet1

 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
[NAME] | 10:45:00 |  | 07:00:00 | 12:00:00 | 09:00:00 |  | 11:00:00 |  | off | off | off | off | 10:00:00 | 17:00:00
Split | 18:00:00 |  | 08:45:00 | 18:00:00 | 18:00:00 |  | 19:00:00 |  |  |  |  |  | 15:00:00 | 19:45:00 | Total
Spreadsheet: 220198d1363095567-calculating-averageif-with-or-statement-averageifs-sample
Sheet: Sheet1

Student | Grade | Assignment | [NAME]
[NAME] | 91 | Test |  |  | Student | Average Test/Quiz Score | Average Paper/Worksheet Score | Overall Average
[NAME] | 52 | Test |  |  | [NAME]
[NAME] | 23 | Quiz |  |  | [NAME]
[NAME] | 54 | Quiz
[NAME] | 14 | Paper
[NAME] | 30 | Paper
[NAME] | 77 | Worksheet
[NAME] | 10 | Worksheet
[NAME] | 52 | Quiz
[NAME] | 13 | Quiz
[NAME] | 36 | Quiz
[NAME] | 58 | Quiz
[NAME] | 1 | Worksheet
[NAME] | 99 | Worksheet
[NAME] | 80 | Worksheet
[NAME] | 4 | Worksheet
[NAME] | 22 | Paper
[NAME] | 6 | Paper
[NAME] | 79 | Test
[NAME] | 90 | Test
[NAME] | 82 | Worksheet
[NAME] | 12 | Worksheet
[NAME] | 14 | Worksheet
[NAME] | 23 | Worksheet
[NAME] | 44 | Quiz
[NAME] | 39 | Quiz
[NAME] | 2 | Test
[NAME] | 16 | Test
Spreadsheet: 669344d1585323689-reverse-and-reformat-one-to-many-data-set-tempdata
Sheet: Sheet1

Group 1 | user1,user2,user4,user8,user9,user12
Group 2 | user3,user6,user7
Group 3 | [NAME]
Group 4 | user10,user6,user11,user13
Group 5 | user13,user5
user1 | Group 1,Group3
user2 | Group 2,Group 3
user3 | Group 2
user4 | Group 1
user5 | Group 5
[NAME] | Group 2,Group 4
user7 | Group 2
user8 | Group 1
[NAME] | Group 1,Group 3
user10 | Group 4
user11 | Group 4
Spreadsheet: 215837d1361506520-offset-and-countif-with-dynamic-range-example
Sheet: Sheet1

As you can see on the right, the formula in F1 is taking into account the 4 x's placed in E2, E3, E4 and E6. Therefore it's resulitng in D1-D10 and providing the correct answer of 6. This is exactly what I want, as I want the formula to provide a range where if an X is placed within the next 5 "free cells" after E1, then D1 is subtracted by the next equivalent D row, 5 "free cells (in the E column)" below D1. |  |  | 10
 |  |  | 23 | x
Therefore, I want the range in the formula to represent the next 5 "non-"x"" cells in column E. If you try to place an x in E7 now, it doesnt alter the result in F1, but I'd like it to, as I'd like the range in the countif function to now read E2:E10. So if any "x"'s are placed within the 5 next "free cells" below E1 (which now extends to E10), then it keeps altering the value in F1 and keeps adjusting the range in the countif function accordingly. |  |  | 4 | x
 |  |  | 6 | x
Note that, I don't want the x's lower in column E to be taken into account for F1 UNLESS enough x's are placed in the 5 "free cells" below E1 that they start to fit into the new, dyncamically changing, range. |  |  | 7
 |  |  | 3 | x
 |  |  | 4
 |  |  | 5
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 3
 |  |  | 4 | x
 |  |  | 5
 |  |  | 3
 |  |  | 34 | x
 |  |  | 5
 |  |  | 3
 |  |  | 4
 |  |  | 5 | x
 |  |  | 7
 |  |  | 56
 |  |  | 7
Spreadsheet: 669174d1585235674-extract-unique-from-on-column-and-corresponded-max-value-from-other-column-q1
Sheet: Sheet1

 |  |  |  | Unique | [NAME]
 | AAA | 0 |  |  | 8
 | BBB | 1 |  |  | 3
 | AAA1 | 4 |  |  | 4
 | B1 | 4 |  |  | 6
 | BB5 | 3 |  |  | 3
 | AAA1 | 4 |  |  | 7
 | SSS | 5 |  |  | 2
 | BBB | 3 |  |  | 4
 | TTT | 2
 | TTT | 2
 | AAA | 1
 | AAA | 2
 | BBB | 3
 | EEE | 4
 | AAA | 5
 | B1 | 6
 | SSS | 7
 | AAA | 8
Spreadsheet: 542022d1507670708-automate-this-table-automate-this-table-auto
Sheet: Sheet1

Just put new result in the table below
 |  |  |  |  |  |  |  | Use a sumproduct to do the math automatically as you update the results in the table |  |  |  |  |  |  |  |  |  |  | Results(note home player is always first )
Name | Result | Lookup value | Played | Result | Points |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] won don
[NAME] | won |  | 1 | won | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] lost to willy
[NAME] | lost |  | 1 | lost | 0 |  |  | Name | Played | won | lost | drew | won away | Points |  |  |  |  | Scully won gary
[NAME] | lost |  | 1 | drew | 1 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] lost to gary
[NAME] | lost |  | 1 | won away | 4 |  |  | [NAME] |  |  |  |  |  |  | 4 |  |  |  | [NAME] drew with [NAME]
[NAME] | won away |  | 1 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] lost to gary
[NAME] | won away |  | 1 |  |  |  |  | [NAME]
Willy | won away |  |  |  |  |  |  | [NAME]
Scully | won |  |  |  |  |  |  | [NAME]
[NAME] | drew |  |  |  |  |  |  | Damon
[NAME] | lost |  |  |  |  |  |  | [NAME]
[NAME] | lost |  |  |  |  |  |  | Willy
[NAME] | lost |  |  |  |  |  |  | Scully
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME] B
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Use a Pivot table to pull the results.  You will have to refresh the table each time you add results.
 |  |  |  |  |  |  |  | Sum of Lookup value | Column Labels
 |  |  |  |  |  |  |  | Row Labels | won | lost | drew | won away | Grand Total
 |  |  |  |  |  |  |  | [NAME] |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | [NAME] |  | 0 |  | 8 | 8
 |  |  |  |  |  |  |  | [NAME] | 3 | 0 |  |  | 3
 |  |  |  |  |  |  |  | [NAME] |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | Scully | 3 |  |  |  | 3
 |  |  |  |  |  |  |  | [NAME] |  |  | 1 |  | 1
 |  |  |  |  |  |  |  | Willy |  |  |  | 4 | 4
 |  |  |  |  |  |  |  | Grand Total | 6 | 0 | 1 | 12 | 19
Spreadsheet: 94966d1294696347-index-match-to-retreive-value-based-on-multiple-criteria-copy-of-2test
Sheet: Sheet1

Sum of Hours Minus  Down | Line #
Date | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Line # | Grand Total
Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
2011-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
2011-01-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
2011-01-03 00:00:00 | 7 | 7 | 7 | 8 | 7 | 7 | 7 | 7 | 7 | 7 | 0 | 0 | 0 | 0 | 5 | 7 | 7 | 0 |  | 90
2011-01-04 00:00:00 | 7 | 7 | 7.25 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 6 | 7 | 0 | 0 | 0 | 0 | 7.5 | 7.5 | 0 | 7.5 |  | 94.25
2011-01-05 00:00:00 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3.75 | 3.75 | 0 | 0 | 0 | 0 | 3.5 | 4 | 0 | 4 |  | 51
2011-01-06 00:00:00 | 3.75 | 4 | 3.75 | 4 | 4 | 4 | 4 | 4.25 | 3.75 | 4 | 0 | 0 | 0 | 0 | 3.75 | 0 | 3.5 | 4 |  | 50.75
2011-01-07 00:00:00 | 3.166666666666667 | 3.5 | 3.666666666666667 | 3.5 | 3.866666666666667 | 3.5 | 3.833333333333333 | 3.916666666666667 | 4 | 4 | 0 | 0 | 0 | 0 | 4 | 3.583333333333333 | 0 | 4 |  | 48.53333333333334
Grand Total | 24.91666666666667 | 25.5 | 25.66666666666667 | 27 | 26.36666666666667 | 26 | 26.33333333333333 | 26.66666666666667 | 24.5 | 25.75 | 0 | 0 | 0 | 0 | 23.75 | 22.08333333333333 | 10.5 | 19.5 | 0 | 334.5333333333334