tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 657b2e6f-7bb3-43c2-81da-e9f4aa391d69
Sheet: Stmts. of Comp. Earnings

 | HASBRO, INC. AND SUBSIDIARIES
 | Consolidated Statements of Comprehensive Earnings
 | Fiscal Years Ended in December
 | (Thousands of Dollars)
 |  |  | 2012 |  | 2011 |  | 2010
 | Net earnings…………………………………………………………………………………………………. |  | 335999 |  | 385367 |  | 397752
 | Other comprehensive earnings (loss):
 | Foreign currency translation adjustments….……………………………………………………………. |  | 8325 |  | -21844 |  | -32457
 | Net (losses) gains on cash flow hedging activities, net of tax……………………..………………….. |  | -3704 |  | -8689 |  | 10444
 | Changes in unrecognized pension and postretirement amounts, net of tax…………………………. |  | -38335 |  | -20237 |  | -1812
 | Reclassifications to earnings, net of tax:
 | Net (gains) losses on cash flow hedging activties………………………………………………. |  | -7385 |  | 3338 |  | -15422
 | Amortization of unrecognized pension and postretirement amounts…………………………. |  | 4735 |  | 3340 |  | -11235
 | Other comprehensive loss …………………………………………...………………………………….. |  | -36364 |  | -44092 |  | -50482
 | Total comprehensive earnings …………………………………………...………………………………….. |  | 299635 |  | 341275 |  | 347270
See accompanying notes to consolidated financial statements.
Spreadsheet: sally_beck__35304__9910_IC_Analysis wo
Sheet: BS - Explanations

Enron Corp.
Intercompany Imbalances
Summary of Imbalances Greater than $1 Million - Balance Sheet
Business Unit |  | Business Unit |  | Imbalance ($ Million) |  | Income Statement Exposure |  | Explanation of Imbalance |  | Expected Resolution Date (G/L Month) |  | Business Unit Financial Rep |  | Business Unit Financial Rep
[NAME] |  | [NAME] |  | 1.3 |  | 1.3 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
[NAME] |  | EUR |  | -48.9 |  | 3.2 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
[NAME] |  | EES |  | 9.6 |  | 9.6 |  |  |  |  |  | [NAME] |  | [NAME]
[NAME] |  | CORP |  | 1.5 |  | 0 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
EUR |  | EUR |  | 217.4 |  | 0 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
EUR |  | Asia/Africa |  | 3.8 |  | 0 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
EUR |  | EECC |  | -7.6 |  | 0 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
EUR |  | INT'L HQ |  | -45.4 |  | 0 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
EUR |  | GPG |  | -1.2 |  | 0 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
EUR |  | EREC |  | 1.2 |  | 0 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
EUR |  | ECM |  | 1.4 |  | 0 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
EUR |  | CORP |  | -44.5 |  |  |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
Carib/M.E. |  | Carib/M.E. |  | 1.4 |  | 1.4 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
Carib/M.E. |  | INT'L HQ |  | 14.9 |  | 0 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
Asia/Africa |  | INT'L HQ |  | -3.9 |  | 0 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
EECC |  | EECC |  | -9.9 |  | 0 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
EECC |  | CORP |  | 1.1 |  | 1.1 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
INT'L HQ |  | INT'L HQ |  | -2 |  | 0 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
INT'L HQ |  | CORP |  | -3.5 |  | -3.5 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
GPG |  | CORP |  | -2.2 |  | 0 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
EGEP |  | EGEP |  | 2 |  | 2 |  |  |  | 1999-12-01 00:00:00 |  | [NAME] |  | [NAME]
EES |  | EES |  | 6.4 |  | 0 |  |  |  | 1999-12-01 00:00:00 |  | [NAME] |  | [NAME]
EES |  | CORP |  | -1.7 |  | 0 |  |  |  | 1999-11-01 00:00:00 |  | [NAME] |  | [NAME]
Total
Spreadsheet: 267551d1380109879-look-up-formatting-testfile
Sheet: Blad1

 |  |  |  |  |  |  | Membership
 |  |  |  |  |  |  | Weekend Trip
 |  |  |  |  |  |  | Other
Income
Date | Mention | Amount | Category
2013-08-31 00:00:00 | Payment [NAME] | 20 | Membership
2013-09-21 00:00:00 | Payment from [NAME] | 20 | Membership
2013-09-22 00:00:00 | [NAME] | 50 | Weekend Trip
2013-09-25 00:00:00 | Reservation | 5 | Weekend Trip
TOTAL
Spreadsheet: 793098d1661310500-sum-across-multiple-sheets-food-ordering
Sheet: Recipes

Recipe | Product | Quatity
Biscuits | Oats | 30
Biscuits | Honey | 25
Biscuits | Sugar | 0.15
Biscuits | Eggs | 2
BBQ | [NAME] | 1
BBQ | Tomato Sauce | 0.2
BBQ | Sausage | 1
BBQ | Eggs | 1
Spreadsheet: 763237d1642072323-searching-for-multiple-keywords-in-multiple-sources-of-text-sample-sheet-keywords
Sheet: Rawdata input

 |  |  | Text 1 | Text 2 | Text 3 | Text 4
 |  |  | xxxxxxxxxxxxbluepinkxxxxxxxxxxx | xxxxxxxxxxxxpinkxxxxxxxxxxx | xxxxxxxxgroenxxxxxxx | xxxxxazulxxxxxx
 |  |  | xxxxxgoudgoldxxxx | xxxxxxxx | xxxxxgoudgoldxxxx | xxxxxgoudgoldxxxx
 |  |  | xxxxxxvioletxxxxpurper | xxxxxxvioletxxxxpurper | xxxxxwalnutpurperxxxxxxx | xxxxxxxx
 |  |  | xxxxxxxxxsilverxxsilber | xxxxxxxcocacolaxxxxxx | xxxxxxxxcomputerxxxxxx | xxxxxxxlaptopxxxxxxxx
 |  |  | [NAME] | xxxxxgelexxxxbrown | xxxxxxx | xxxxxxxxxxxxxx
Spreadsheet: 783040d1654533992-special-transposing-phonebook-to-sim-format-book2
Sheet: Sheet2

[NAME] (LMF) | NUMBER | [NAME] (FML)
SMITHJ/P | +[PHONE] | JSMITH/P | 204 | J/P
SMITHJ | [PHONE] | JSMITH | 208 | J
SMITHJ/A | 28 | JSMITH/A | 223 | J/A
MacGilleFhJP/W | [PHONE] | JPMacGilleFh/W | 305 | JP/W
MacGilleFhaoJP | 12 | JPMacGilleFhao | 308 | JP
MacGilleFJP/Xz | +[PHONE] | JPMacGilleF/Xz | 325 | JP/Xz
[NAME] length 14 characters (Truncate last name)
 | Retain only "+", remove all other than numbers
Spreadsheet: benjamin_rogers__1070__gencomodel
Sheet: Assumptions

Assumptions Sheet
 | EA & Fuel Pricing Assumptions
 |  |  | NOx
 | SO2 | NOx | Seas = 1 | Gas | Oil |  | Seasonal Adjustment
 | Price | Price | Ann = 2 | Price | Price |  | Gas | Oil |  | General Assumptions
2000 | 181.1559951017635 | 0 |  | 2.884210015833706 | 3.122669702563461 | Jan | 1.128 | 1.08
2001 | 198.9252086638742 | 0 |  | 4.047189789510409 | 3.974390243902439 | Feb | 1.011 | 1.07 |  | Var. O&M Escalation | 0.02
2002 | 218.8025810259074 | 0 |  | 3.688561673388989 | 3.616167070217919 | Mar | 0.994 | 1.03 |  | Fixed O&M Escalation | 0.02
2003 | 240.4080539178627 | 4274.503975464974 | 1 | 3.536928666963888 | 3.526292682926829 | Apr | 0.945 | 0.99 |  | Corporate Tax Rate | 0.4
2004 | 264.1465956966534 | 3642.145326358393 | 1 | 3.559125311854018 | 3.559490566037737 | May | 0.995 | 0.95 |  | Discount Rate | 0.1
2005 | 290.2209692883127 | 3781.044439756625 | 1 | 3.593927563949319 | 3.595042639593909 | Jun | 0.948 | 0.95 |  | Leverage Level | 0
2006 | 319.9247374215356 | 3926.947561657237 | 1 | 3.619467015511121 | 3.626264705882353 | Jul | 0.945 | 0.95 |  | Amortization Period Years | 15
2007 | 354.6110145782363 | 2147.654380448627 | 2 | 3.676875803633559 | 3.680132075471699 | Aug | 0.896 | 0.95 |  | Interest Rate on Debt | 0.0875
2008 | 391.2985187101938 | 1807.342130027606 | 2 | 3.410601255731905 | 3.318178529487583 | Sep | 0.893 | 0.95 |  | Capital Addition Book Life (Years) | 20
2009 | 429.779581218291 | 1985.562679241154 | 2 | 3.535735457692378 | 3.439094302517748 | Oct | 0.989 | 0.95 |  | Environmental CapEX Book Depr | 20
2010 | 477.9809731344426 | 1889.338934283572 | 2 | 3.687055381579251 | 3.58008814167733 | Nov | 1.083 | 1.03
2011 | 526.5321886264389 | 1943.451158513079 | 2 | 3.763408402475727 | 3.655910908064844 | Dec | 1.172 | 1.08
2012 | 583.3818790857277 | 1993.846541670912 | 2 | 3.754629874793263 | 3.649536914379113
2013 | 654.1245507335215 | 1780.92328465844 | 2 | 3.919196639797543 | 3.817760814002264
2014 | 728.1426991521217 | 1844.599624187053 | 2 | 3.941551233649534 | 3.812098859468128
2015 | 806.5596759331302 | 1882.718978585268 | 2 | 4.305749119123843 | 4.215884437630761
2016 | 885.601532299286 | 1999.315278720192 | 2 | 4.499597819240261 | 4.384586803563047
2017 | 870.0603303281033 | 1879.563724209901 | 2 | 4.647832041335125 | 4.521213596261275
2018 | 744.3836719980144 | 2070.108333380814 | 2 | 4.909019897007217 | 4.794404762139923
2019 | 771.7885316520482 | 1127.071629751227 | 2 | 4.953879561068314 | 4.861901203371897
Spreadsheet: 108317d1305327882-conditional-formatting-in-out
Sheet: Sheet1

Employee In / Out Chart
Number in Camp | Name | Date In | Date Out
1 | [NAME] | 2011-04-24 00:00:00
 | [NAME] | 2011-05-01 00:00:00
Spreadsheet: 785523d1656475130-formula-required-to-identify-presence-of-activity-by-type-by-individual-per-month-4p
Sheet: Sheet1

 |  |  | Caller ID | Contact 1 | Contact 1 Result | Contact 2 | Contact 2 Result | Contact 3 | Contact 3 Result | Contact 4 | Contact 4 Result | Contact 5 | Contact 5 Result
 |  |  | 1 | 2022-06-27 00:00:00 | Hang up | 2022-06-28 00:00:00 | Hang up | 2022-07-04 00:00:00 | Purchased
 |  |  | 2 | 2022-05-28 00:00:00 | Purchased | 2022-06-29 00:00:00 | Hang up | 2022-07-02 00:00:00 | Purchased | 2022-07-04 00:00:00 | Purchased | 2022-07-05 00:00:00 | Call back
 |  |  | 3 | 2022-06-29 00:00:00 | Purchased | 2022-06-30 00:00:00 | Purchased | 2022-07-01 00:00:00 | Hang up | 2022-07-02 00:00:00 | Purchased | 2022-08-03 00:00:00 | Hang up
 |  |  | 4 | 2022-06-30 00:00:00 | Call back | 2022-07-01 00:00:00 | Purchased | 2022-07-04 00:00:00 | Purchased | 2022-08-05 00:00:00 | Call back
 |  |  | 5 | 2022-07-01 00:00:00 | Hang up | 2022-07-02 00:00:00 | Call back | 2022-07-03 00:00:00 | Purchased
 |  |  | This is the data I would like |  |  |  | There is only one repetition |  | Repeat more than or equal to 2 times or more
 |  |  | Number of callers hang up in July |  |  | 2 | 1 |  | 2
 |  |  | Number of callers Purchased in July |  |  | 5 | 4 |  | 5
 |  |  | Number of callers Call back in July |  |  | 2 | 2 |  | 0
 |  |  | This is the data I do not want
 |  |  | Number of hang up in July |  |  | 2 |  | There are only 3 possibilities
 |  |  | Number of Purchased in July |  |  | 7
 |  |  | Number of Call back in July |  |  | 2
Month | Activity | Count
June | Hang up | 3
July | Purchased | 7
May | Purchased | 1
July | Call back | 2
June | Purchased | 2
July | Hang up | 2
August | Hang up | 1
June | Call back | 1
August | Call back | 1
Spreadsheet: 475268d1471249259-count-cost-from-one-tab-into-a-table-in-another-tab-test-2
Sheet: Summary

 | Complaints | April | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | May | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | June | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | July | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | August | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | September | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | October | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | November | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | December | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | January | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | February | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | March | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost
1 | Monday - Breakfast
 | Monday - Lunch
 | Monday - Dinner
 | Tuesday - Breakfast
 | Tuesday - Lunch
 | Tuesday - Dinner
 | Wednesday - Breakfast
 | Wednesday - Lunch
 | Wednesday- Dinner
 | Thursday - Breakfast
 | Thursday - Lunch
 | Thursday - Dinner
 | Friday - Breakfast
 | [NAME]
 | Friday- Dinner
 | Saturday - Breakfast
 | Saturday - Lunch
 | Saturday - Dinner
 | Sunday - Breakfast
 | Sunday- Lunch
 | [NAME]
23
24
25
26
27
28
 |  | April | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Cost | May | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | June | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | July | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | August | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | September | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | October | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | November | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | December | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | January | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | February | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost | March | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | cost
Spreadsheet: 53422730-5c93-4217-8c89-ff27604e34cf
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: |  |  | 2012-09-07 15:14:31.360000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.682 | 101.557 | 101.432 | 101.057
3.75 | 101.551 | 101.426 | 101.301 | 100.926 |  | Note: | Refer To Price [NAME]
3.625 | 101.139 | 101.014 | 100.889 | 100.514 |  |  | For all Price Adjs
3.5 | 100.502 | 100.377 | 100.252 | 99.627
3.375 | 99.627 | 99.502 | 99.377 | 98.752
3.25 | 98.67 | 98.545 | 98.42 | 97.795
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 101.84 | 101.715 | 101.59 | 101.215
3.25 | 101.442 | 101.317 | 101.192 | 100.817
3.125 | 101.142 | 101.017 | 100.892 | 100.517
3 | 100.791 | 100.666 | 100.541 | 100.166
2.875 | 100.171 | 100.046 | 99.921 | 99.296
2.75 | 99.512 | 99.387 | 99.262 | 98.637
 |  |  |  |  |  | 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 | 2012-09-21 15:14:31.360000
30 DAY | 2012-10-06 15:14:31.360000
45 DAY | 2012-10-21 15:14:31.360000
60 DAY | 2012-11-05 15:14:31.360000
90 DAY | 2012-12-05 15:14:31.360000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 0a71e24a-7afa-4dda-9454-c1ef43190a89
Sheet: Sheet1

PRESIDENT OF THE UNITED STATES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Republican
1992-02-18 00:00:00
Belknap County | Bosa, r | Buchanan, r | [NAME], r | Latchford, r | Lennane, r | [NAME], r | Paulsen, r | Stassen, r | [NAME], Jr., d
Alton | - | 376 | 469 | - | 8 | - | 2 | - | 7
Barnstead | 1 | 239 | 309 | 9 | 1 | - | - | - | 8
Belmont | 1 | 318 | 424 | - | 8 | 2 | 2 | - | 4
Center Harbor | - | 92 | 112 | - | 1 | - | 1 | - | 2
Gilford | 3 | 493 | 792 | 1 | 13 | 2 | 1 | - | 13
Gilmanton | 3 | 197 | 261 | - | 7 | - | - | 1 | 7
[NAME] | - | 189 | 303 | - | 4 | - | 2 | 2 | 1
[NAME] | - | 139 | 182 | - | - | - | - | - | 1
[NAME] 3 | 1 | 166 | 250 | - | - | 1 | 1 | 1 | 4
[NAME] | 1 | 142 | 140 | - | 2 | - | 2 | - | 1
[NAME] | 1 | 106 | 127 | - | 3 | - | 1 | - | 2
[NAME] 6 | 1 | 265 | 375 | - | 2 | 1 | 8 | - | 1
Meredith | 3 | 347 | 676 | - | 5 | 2 | 2 | - | 14
New Hampton | - | 98 | 183 | - | 4 | - | 3 | 2 | 2
Sanbornton | 1 | 182 | 229 | - | 2 | 1 | 1 | 2 | 8
[NAME] | 3 | 222 | 266 | - | 7 | - | 2 | 2 | 8
Totals | 19 | 3571 | 5098 | 10 | 67 | 9 | 28 | 10 | 83
 | [NAME], d | Harkin, d | Kerrey, d | [NAME], d | Tsongas, d | Woods, d | [NAME], [NAME] | Cuomo | [NAME]
Alton | 5 | 2 | 2 | 0 | 7 | 8 | 0 | 6 | 14
Barnstead | 6 | 4 | 1 | 2 | 8 | 2 | 3 | 6 | 7
Belmont | 14 | 2 | 8 | 4 | 18 | 2 | 0 | 5 | 16
Center Harbor | 9 | 2 | 0 | 2 | 6 | 0 | 0 | 1 | 3
Gilford | 17 | 6 | 8 | 0 | 38 | 1 | 1 | 9 | 38
Gilmanton | 6 | 3 | 3 | 0 | 14 | 2 | 2 | 0 | 19
[NAME] | 3 | 3 | 1 | 0 | 14 | 2 | 0 | 1 | 11
[NAME] | 5 | 4 | 1 | 0 | 3 | 4 | 0 | 2 | 3
[NAME] 3 | 6 | 0 | 3 | 0 | 17 | 0 | 1 | 7 | 10
[NAME] | 3 | 3 | 0 | 2 | 6 | 1 | 0 | 0 | 2
[NAME] | 3 | 0 | 1 | 0 | 3 | 4 | 0 | 2 | 3
[NAME] 6 | 6 | 4 | 6 | 0 | 14 | 5 | 4 | 1 | 3
Meredith | 29 | 4 | 12 | 2 | 22 | 2 | 0 | 13 | 10
New Hampton | 4 | 2 | 0 | 0 | 7 | 2 | 0 | 3 | 9
Sanbornton | 11 | 2 | 5 | 2 | 10 | 1 | 0 | 4 | 12
[NAME] | 9 | 3 | 14 | 2 | 12 | 1 | 0 | 0 | 14
Totals | 136 | 44 | 65 | 16 | 199 | 37 | 11 | 60 | 174
Bertasavage: 1-Meredith. [NAME]: 1-Barnstead; 1-Gilford; 1-Gilmanton; 1-Tilton. [NAME]: 1-Barnstead; 1-Belmont; 1-Gilmanton; 1-Sanbornton; 1-Tilton.
Doerschuck: 1-Sanbornton. [NAME]: 1-Meredith. Fabish: 1-Alton. Fellure: 1-Belmont; 1-Gilford. Koczak: 1-Barnstead. [NAME]: 2-Barnstead.
Rogers: 1-Tilton. Ryden: 1-Belmont. Trinsey: 1-Laconia Ward 1. Zimmermann: 2-Alton. LaRouche: 1-Laconia Ward 3; 1-Meredith.
Mahoney: 1-Gilmanton; 1-Laconia Ward 3; 1-Laconia Ward 4.
Spreadsheet: 846786d1697928239-trying-to-understand-index-and-match-index_match_test
Sheet: PROJECTS

Staff Member | Project: Task | Apple | [NAME] | [NAME] | Donut | Eggs | [NAME]
Person 1 | Project 1 | 15 | 15 | 15 | 15
Person 1 | Project 2 |  |  |  | 12 | 12 | 12
Person 2 | Project 1 | 20 | 10 | 10 | 5 | 5 | 5
Person 2 | Project 1 |  |  |  | 5 | 5 | 5
Person 2 | Project 3 |  |  |  | 0 | 0 | 0
Person 3 | Project 1 | 20 | 20 | 20 | 30 | 30 | 30
Person 3 | Project 2 | 10 |  | 23
Person 3 | Project 3 |  | 15 |  |  | 18
Person 3 | Project 4 | 5
Person 4 | Project 1 | 12 | 12 | 12 | 24 | 24 | 24
Person 4 | Project 2 | 4 | 4 | 4
Person 5 | Project 5 | 20 | 20 | 20 | 1
Person 6 | Project 2 | 20 | 20 | 20 | 30 | 30 | 30
Person 6 | Project 3 | 10 |  | 23
Person 6 | Project 4 | 40 | 40 | 40 | 40 | 20 | 20
Person 6 | Project 6 | 28 | 28 | 28 |  | 8 | 8
Person 7 | Project 7 | 20 | 20 | 20 | 30 | 30 | 30
Person 8 | Project 1 | 30 | 30 | 30 | 20 | 20 | 20
Person 8 | Project 2 | 20 | 20 | 20 | 30 | 30 | 30
Person 8 | Project 3 | 10 |  | 23
Person 8 | Project 4 | 30 | 30 | 30 | 20 | 20 | 20
Person 9 | Project 6 | 30 | 35 | 40 | 45 | 50 | 55
Person 9 | Project 7 | 4 | 4 | 4 | 6.6 | 6.6 | 6.6
Person 10 | Project 1 | 54 | 6 | 6 | 6 | 6 | 6
Person 10 | Project 3 | 64
Person 10 | Project 7 | 74
Person 11 | Project 2 | 37 | 37 | 37 | 32.5 | 32.5 | 32.5
Person 11 | Project 4 |  | 15 |  | 18
Spreadsheet: 386111d1427604928-summary-multiple-conditions-confusing-150329
Sheet: Sheet1

 | TABLE 1 |  |  |  |  |  |  |  | TABLE 2
 | WINDOW | SIZE | OBS | AWN | D/H |  |  |  | CODE | [NAME] | QTY | [NAME]
 | lounge | 2121 |  |  |  |  |  |  | 1001 | 2106 window, obscure
 | media | 2106 |  | YES |  |  |  |  | 1002 | 2106 window, double hung | 2 | bath, [NAME]
 | bath | 2106 |  |  | YES |  |  |  | 1003 | 2106 window, awning | 1 | media
 | [NAME] | 2106 |  |  | YES
 | ensuite | 2112 | YES
 | PROBLEM
 | Windows come in various sizes and configurations - obscure, awning and double hung
 | SOLUTION
 | To be able to "summarise" the types of windows required (desired result Table 2) - from the list of data from Table1
 | ISSUES
 | * windows can come with the same size, but different types, ie. 2106 obscure, 2106 awning and different locations
 | * each line item in Table 2 will be UNIQUE, ie. There are 3 types of windows per window size
Spreadsheet: 719434d1613662554-drag-on-indirect-columns-esempio-1-
Sheet: AAA

 | AAA
 | Nome | Pro | + | - | TOT
 | A1 | C11 | 10 | 10
 | B2 | B22 | 500 | 200
 | Z3 | M33 | 300 | 300
 | G4 | G44 | 120 | 20
 | H5 | E22 | 30 | 20
 | Totali
Spreadsheet: 42fd2dea-5454-422e-acc7-8289a4a52d0a
Sheet: Sheet1

Unnamed: 0 | Weather Data | Unnamed: 2 | Precipitation Data | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Freeboard Data | Unnamed: 13 | Unnamed: 14
Day | Code | Temp | Gauge 1 | Gauge 2 | Gauge 3 | Gauge 4 | Gauge 5 | Gauge 6 | Gauge 7 | Gauge 8 | Gauge 9 | East | West | South
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
Total |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 34999d1232474587-recognizing-counting-and-displaying-duplicates-loopy-mclooperson
Sheet: Weekly Data

Gym Member Appointment No-shows
Week 1 |  |  |  |  |  |  | Week 2 |  |  |  |  |  |  | Week 3
2009-02-02 00:00:00 | 2009-02-03 00:00:00 | 2009-02-04 00:00:00 | 2009-02-05 00:00:00 | 2009-02-06 00:00:00 | 2009-02-07 00:00:00 | 2009-02-08 00:00:00 | 2009-02-02 00:00:00 | 2009-02-03 00:00:00 | 2009-02-04 00:00:00 | 2009-02-05 00:00:00 | 2009-02-06 00:00:00 | 2009-02-07 00:00:00 | 2009-02-08 00:00:00 | 2009-02-02 00:00:00 | 2009-02-03 00:00:00 | 2009-02-04 00:00:00 | 2009-02-05 00:00:00 | 2009-02-06 00:00:00 | 2009-02-07 00:00:00 | 2009-02-08 00:00:00
1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 3 | 4 | 5 | 6 | 7
1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 8 | 9 | 10 | 11 | 12 | 13 | 14
1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 15 | 16 | 17 | 18 | 19 | 20 | 21
1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 22 | 23 | 24 | 25 | 26 | 27 | 28
1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 29 | 30 | 31 | 32 | 33 | 34 | 35
1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 36 | 37 | 38 | 39 | 40 | 41 | 42
1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 43 | 44 | 45 | 46 | 47 | 48 | 49
1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 50 | 51 | 52 | 53 | 54 | 55 | 56
1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 57 | 58 | 59 | 60 | 61 | 62 | 63
1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 64 | 65 | 66 | 67 | 68 | 69 | 70
1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 71 | 72 | 73 | 74 | 75 | 76 | 77
1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 78 | 79 | 80 | 81 | 82 | 83 | 84
 |  | 26
Spreadsheet: 772066d1646992837-auto-fill-filling-with-colour-based-on-variables-golf-final
Sheet: Scoring

Scoring |  |  |  |  |  | Scoring
Range | Higher | Points Scored |  |  |  | Range | Points Scored
1 | 1 | 20 |  |  |  | Winner | 20
2 | 2 | 16 |  |  |  | 2 | 16
3 | 3 | 14 |  |  |  | 3 | 14
4 | 4 | 12 |  |  |  | 4 | 12
5 | 5 | 10 |  |  |  | 5 | 10
6 | 6 | 9 |  |  |  | 6 | 9
7 | 7 | 8 |  |  |  | 7 | 8
8 | 8 | 7 |  |  |  | 8 | 7
9 | 9 | 6 |  |  |  | 9 | 6
10 | 10 | 5 |  |  |  | 10 | 5
11 | 15 | 4 |  |  |  | 11 | 4
16 | 20 | 3 |  |  |  | 16 | 3
21 | 30 | 2 |  |  |  | 21 | 2
31 | 40 | 1 |  |  |  | 31 | 1
41 | 71 | 0 |  |  |  | 41 | 0
 |  | 3 |  |  |  |  | 3
72 | 160 | -3 |  |  |  | 72 | -3