tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kevin_ruscitti__20276__market briefs
Sheet: Sheet1

Market Brief | Tuesday, June 5
Stocks | Close | Change | % Change
DJIA | 11175.84 | 114.32 | 0.0103349268454968
DJ 15 Util. | 381.71 | -8.54000000000002 | -0.02188340807174893
NASDAQ | 2233.66 | 77.73 | 0.03605404628165108
S&P 500 | 1283.57 | 16.46 | 0.01299019027550886
Market Vols | Close | Change | % Change
AMEX (000) | 118606 | 38143 | 0.474043970520612
NASDAQ (000) | 1842839 | 529096 | 0.4027393485636079
NYSE (000) | 1115717 | 275408 | 0.3277461029216633
Commodities | Close | Change | % Change
Crude Oil (Jul) | 28.24 | 0.1099999999999994 | 0.00391041592605757
Heating Oil (Jul) | 0.7695 | 0.01029999999999998 | 0.01356691253951525
Nat. Gas (Henry) | 3.892 | -0.177 | -0.04349963135905629
Palo Verde (Jul) | 222 | -43 | -0.1622641509433962
COB (Jul) | 205 | -40 | -0.163265306122449
PJM (Jul) | 82 | -1 | -0.01204819277108434
Dollar US $ | Close | Change | % Change
Australia $ | 1.963 | -0.01 | -0.005068423720223015
Canada $ | 1.53 | -0.006000000000000005 | -0.00390625
Germany Dmark | 2.295 | -0.02200000000000024 | -0.009495036685369116
Euro | 0.854 | 0.007699999999999929 | 0.009098428453267079
Japan ¥en | 120.4 | 1 | 0.008375209380234505
Mexico NP | 9.14 | -0.01999999999999957 | -0.002183406113537071
[NAME] | 0.7084 | 0.001000000000000001 | 0.001413627367825842
Foreign Indices | Close | Change | % Change
Arg MerVal | 442.9 | -0.8300000000000409 | -0.001870506839744982
[NAME]. | 3354.5 | -4.800000000000182 | -0.00142886910963599
[NAME] | 15394.82 | 290.9599999999991 | 0.01926394974529684
Can TSE 300 | 8258.82 | -42.38999999999942 | -0.005106484476359401
Germany DAX | 6242.13 | 64.39000000000033 | 0.01042290546381044
[NAME] | 13253.39 | 45.89999999999964 | 0.003475300757373251
Japan Nikkei 225 | 13191.01 | -121.34 | -0.009114844486510657
[NAME] | 6672.35 | 40.60000000000036 | 0.006122064311833281
UK FTSE 100 | 5922.5 | 66 | 0.01126952958251515
Source:  Yahoo! & TradingDay.com
Spreadsheet: 815158d1674772176-finding-percentage-change-in-trendline-joliet_unemployment_rates
Sheet: Unemployment-Joliet

2022-11-01 00:00:00 | 1 | 4.9
2022-10-01 00:00:00 | 57 | 4.7
2022-09-01 00:00:00 | 56 | 4.7 |  |  |  |  | 5.753519448014647
2022-08-01 00:00:00 | 55 | 5.3 |  |  |  |  | 8.755463365052829e+48
2022-07-01 00:00:00 | 54 | 5.2
2022-06-01 00:00:00 | 53 | 5.3
2022-05-01 00:00:00 | 52 | 4.5
2022-04-01 00:00:00 | 51 | 4.7
2022-03-01 00:00:00 | 50 | 5.7
2022-02-01 00:00:00 | 49 | 6.2
2022-01-01 00:00:00 | 48 | 6.5
2021-12-01 00:00:00 | 47 | 5.2
2021-11-01 00:00:00 | 46 | 5
2021-10-01 00:00:00 | 45 | 5.7
2021-09-01 00:00:00 | 44 | 5.8
2021-08-01 00:00:00 | 43 | 7
2021-07-01 00:00:00 | 42 | 7.7
2021-06-01 00:00:00 | 41 | 8.9
2021-05-01 00:00:00 | 40 | 7.3
2021-04-01 00:00:00 | 39 | 7.8
2021-03-01 00:00:00 | 38 | 8.4
2021-02-01 00:00:00 | 37 | 9.1
2021-01-01 00:00:00 | 36 | 9.2
2020-12-01 00:00:00 | 35 | 8.5
2020-11-01 00:00:00 | 34 | 8.2
2020-10-01 00:00:00 | 33 | 8.3
2020-09-01 00:00:00 | 32 | 9.8
2020-08-01 00:00:00 | 31 | 10.7
2020-07-01 00:00:00 | 30 | 12.7
2020-06-01 00:00:00 | 29 | 14.2
2020-05-01 00:00:00 | 28 | 16.1
2020-04-01 00:00:00 | 27 | 20.5
2020-03-01 00:00:00 | 26 | 8.8
2020-02-01 00:00:00 | 25 | 6.1
2020-01-01 00:00:00 | 24 | 5.8
2019-12-01 00:00:00 | 23 | 4.3
2019-11-01 00:00:00 | 22 | 3.6
2019-10-01 00:00:00 | 21 | 3.7
2019-09-01 00:00:00 | 20 | 3.7
2019-08-01 00:00:00 | 19 | 4.3
2019-07-01 00:00:00 | 18 | 4.9
2019-06-01 00:00:00 | 17 | 5.2
2019-05-01 00:00:00 | 16 | 4.3
2019-04-01 00:00:00 | 15 | 4.9
2019-03-01 00:00:00 | 14 | 5.7
2019-02-01 00:00:00 | 13 | 6.4
2019-01-01 00:00:00 | 12 | 6.8
2018-12-01 00:00:00 | 11 | 5
2018-11-01 00:00:00 | 10 | 3.8
2018-10-01 00:00:00 | 9 | 4.1
2018-09-01 00:00:00 | 8 | 4
2018-08-01 00:00:00 | 7 | 4.6
2018-07-01 00:00:00 | 6 | 5.2
2018-06-01 00:00:00 | 5 | 5.6
2018-05-01 00:00:00 | 4 | 4.4
2018-04-01 00:00:00 | 3 | 4.7
2018-03-01 00:00:00 | 2 | 5.8
2018-02-01 00:00:00 | 1 | 6.9
2018-01-01 00:00:00 | 0 | 7.1
2017-12-01 00:00:00 | 1 | 5.8
2017-11-01 00:00:00 |  | 5.2
2017-10-01 00:00:00 |  | 5.2
2017-09-01 00:00:00 |  | 5.3
2017-08-01 00:00:00 |  | 6.2
2017-07-01 00:00:00 |  | 6.4
2017-06-01 00:00:00 |  | 6.8
2017-05-01 00:00:00 |  | 5.6
2017-04-01 00:00:00 |  | 5.8
2017-03-01 00:00:00 |  | 6.4
2017-02-01 00:00:00 |  | 7.1
2017-01-01 00:00:00 |  | 7.7
2016-12-01 00:00:00 |  | 6.7
2016-11-01 00:00:00 |  | 6
2016-10-01 00:00:00 |  | 6.4
2016-09-01 00:00:00 |  | 6.4
2016-08-01 00:00:00 |  | 6.9
2016-07-01 00:00:00 |  | 7.3
2016-06-01 00:00:00 |  | 7.9
2016-05-01 00:00:00 |  | 6.8
2016-04-01 00:00:00 |  | 7.8
2016-03-01 00:00:00 |  | 8.4
2016-02-01 00:00:00 |  | 8.7
2016-01-01 00:00:00 |  | 9
2015-12-01 00:00:00 |  | 7.5
2015-11-01 00:00:00 |  | 6.6
2015-10-01 00:00:00 |  | 6.4
2015-09-01 00:00:00 |  | 6.2
2015-08-01 00:00:00 |  | 6.7
2015-07-01 00:00:00 |  | 7.6
2015-06-01 00:00:00 |  | 8.1
2015-05-01 00:00:00 |  | 7.5
2015-04-01 00:00:00 |  | 7.6
2015-03-01 00:00:00 |  | 8.4
2015-02-01 00:00:00 |  | 9
2015-01-01 00:00:00 |  | 9.6
2014-12-01 00:00:00 |  | 7.7
2014-11-01 00:00:00 |  | 7.4
2014-10-01 00:00:00 |  | 7.5
2014-09-01 00:00:00 |  | 7.6
2014-08-01 00:00:00 |  | 8.5
Spreadsheet: 0674fc01-d395-4a37-9c46-e7818af2978f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Cuadro 4.1.14
[NAME]
Porcentaje de viviendas a nivel nacional por año y tenencia, según [NAME], 2002, 2005-2007
[NAME] y tinaco | CENSO 2002 |  | ENHOGAR 2005 |  | ENHOGAR 2006 |  | ENHOGAR 2007 |  | ENIGH 2007
 | Sí | No | Sí | No | Sí | No | Sí | No | Sí | No
[NAME] o tinaco | 16 | 84 | … | … | 2.123038781177629 | 97.79250086715759 | … | … | … | …
[NAME]: bomba de agua | … | … | 11.41504162719028 | 88.09277505842985 | 11.7859200451339 | 88.12961960320132 | 12.72537743414338 | 87.24219385664532 | … | …
[NAME]: calentador de agua | … | … | 3.21268720556956 | 96.36210071692615 | 3.550664139031644 | 96.36487550930357 | 3.859644859546822 | 96.1009714367595 | … | …
Fuente: Censo Nacional de Población y Vivienda 2002
Encuesta de Hogar de Propósitos Múltiples 2005-2006-2007
Encuesta Nacional de Ingresos y Gastos de los Hogares 2007
Spreadsheet: 111468d1307834107-showing-and-calculating-dates-as-ages-yy-mm-adjusted-ages
Sheet: Ages (2)

 |  | Actual |  | Adjusted |  | Difference
DOB | Test Date | Y | M | Y | M | Y | M | + or -
2002-04-01 00:00:00 | 2011-04-01 00:00:00 |  |  | 7 | 5
2002-04-01 00:00:00 | 2011-05-01 00:00:00 |  |  | 9 | 7
2002-04-01 00:00:00 | 2011-06-01 00:00:00 |  |  | 9 | 8
2002-04-01 00:00:00 | 2011-07-01 00:00:00 |  |  | 10 | 1
2002-04-01 00:00:00 | 2011-08-01 00:00:00 |  |  | 9 | 10
2002-04-01 00:00:00 | 2011-09-01 00:00:00 |  |  | 9 | 0
2002-04-01 00:00:00 | 2011-10-01 00:00:00 |  |  | 8 | 9
2002-04-01 00:00:00 | 2011-11-01 00:00:00 |  |  | 10 | 1
2002-04-01 00:00:00 | 2011-12-01 00:00:00 |  |  | 10 | 2
2002-04-01 00:00:00 | 2012-01-01 00:00:00 |  |  | 10 | 3
2002-04-01 00:00:00 | 2012-02-01 00:00:00 |  |  | 10 | 4
2002-04-01 00:00:00 | 2012-03-01 00:00:00 |  |  | 10 | 5
Spreadsheet: 143279d1330346770-how-do-you-make-a-cell-change-color-which-is-dependant-on-another-cell-example
Sheet: Sheet1

 |  | expenditure
DATE | DETAILS | INVOICE NUMBER | REFERENCE | TOTAL |  | DRAWINGS | STOCK | DIRECT WAGES | H/L/W | RENT/RATES | INTERNET SERVICES | TELEPHONE | REPAIRS & Renewals | ADVERTISING | WITHDRAWLS | BANK CHARGES | SUNDRIES | INSURANCE
 |  |  |  | 1
 |  |  |  | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS
 |  |  | TOTALS
Spreadsheet: 70418d1271175539-excel-2007-holiday-planner-auto-update-traffic-office-holiday-plan-2010-2011
Sheet: June

June
 |  |  |  |  | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W
First Name | Surname | Annual Leave Entitlement | Total Leave Entitlement |  | 2010-06-05 00:00:00 | 2010-06-06 00:00:00 | 2010-06-07 00:00:00 | 2010-06-08 00:00:00 | 2010-06-09 00:00:00 | 2010-06-10 00:00:00 | 2010-06-11 00:00:00 | 2010-06-12 00:00:00 | 2010-06-13 00:00:00 | 2010-06-14 00:00:00 | 2010-06-15 00:00:00 | 2010-06-16 00:00:00 | 2010-06-17 00:00:00 | 2010-06-18 00:00:00 | 2010-06-19 00:00:00 | 2010-06-20 00:00:00 | 2010-06-21 00:00:00 | 2010-06-22 00:00:00 | 2010-06-23 00:00:00 | 2010-06-24 00:00:00 | 2010-06-25 00:00:00 | 2010-06-26 00:00:00 | 2010-06-27 00:00:00 | 2010-06-28 00:00:00 | 2010-06-29 00:00:00 | 2010-06-30 00:00:00
[NAME] | Cooksey | 20
[NAME] | Weller | 20
Spreadsheet: 778384d1651044228-xlookup-or-what-formula-with-multiple-column-on-lookup-array-xlookup-question
Sheet: Sheet1

Group | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10
Group A | Apple | Apricots | Avocado | Acerola | Artichoke | Asparagus | Arrowroot | Amaranth | Arugula | Cherries
Group B | [NAME] | Blackberries | Blackcurrant | Breadfruit | Bamboo | Bean | Beets | Bell pepper | Black radish | Black eyed pea
Group C | Canteloupe | Carambola | Cherimoya | Cherries | Clementine | Coconut | Cherries | Cabbage | Cactus | [NAME]
 |  | Item | Cherries | <- Variable
 |  | Group |  | <- Formula (but instead of column B, needs to be column B:K
 |  |  | Group C
Spreadsheet: tracy_geaccone__40496__2002 Plan Template
Sheet: OtherFundsFlow

DETAIL of OTHER FUNDS FLOW
(Millions of Dollars)
 |  | 2002 Activities
 |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Total
Non-Cash I/S Items
Changes in FV taken to I/S |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Cash Received/(Paid Out) for:
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Transfers
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other
Other Funds Flow (line 101)
Spreadsheet: 104238d1301902458-excel-2008-solved-sum-of-values-in-a-column-based-on-values-in-a-different-column-book1_divingdata
Sheet: Sheet1

A | B | C | D | E | F |  | The number of each GEAR TYPE |  |  | Helper Columns |  |  | Data Validation List
[NAME] | 2800 | 700 | 34 | 37 | Hookah |  | Hookah | 4 |  | HookahAlyce | 1 |  | Hookah
Brett | 3000 | 700 | 35 | 35 | Open Circ |  |  |  |  | Open CircBrett | 1 |  | Open Circ
[NAME] | 3200 | 650 | 37 | 36 | Open Circ |  | The sum of the DIVE TIME |  |  | Open CircMike | 1 |  | Rebreather
Suzie | 2900 | 650 | 41 | 31 | Rebreather |  | Hookah | 139 |  | RebreatherSuzie | 1 |  | Surf Supply
[NAME] | 3000 | 700 | 42 | 40 | Surf Supply |  |  |  |  | Surf SupplyLaura | 1
[NAME] | 3000 | 800 | 45 | 31 | Rebreather |  | The number of divers using each GEAR TYPE |  |  | RebreatherMike | 1
[NAME] | 2900 | 550 | 47 | 33 | Surf Supply |  | Hookah | 4 |  | Surf SupplyDean | 1
[NAME] | 2000 | 800 | 48 | 13 | Open Circ |  |  |  |  | Open CircMike
[NAME] | 3000 | 800 | 48 | 31 | Open Circ |  | Basic [NAME] ([NAME]) |  |  | Open CircMike
Nathan | 3100 | 600 | 48 | 34 | Open Circ |  | Hookah | 1 |  | Open CircNathan | 1
Nathan | 3100 | 600 | 48 | 34 | Hookah |  | Two Dynamic Names |  |  | HookahNathan | 1
Brett | 3100 | 600 | 48 | 34 | Hookah |  | Hookah | 4 |  | HookahBrett | 1
Suzie | 3100 | 600 | 48 | 34 | Hookah |  | One Dynamic Name (Names) |  |  | HookahSuzie | 1
 |  |  |  |  |  |  | Hookah | 4 |  |  | 1
Spreadsheet: 150276d1334373246-hockey-stats-tracking-data-entry-add-to-data-on-other-sheets-in-specific-scenarios-scoresheet
Sheet: 27

 |  |  | DRESS | SCORING
 |  |  |  | GOALS | ASSISTS | POINTS | EVEN STR. | 5-4 PPG | SHG | EMPTY NET | PENALTY SHOT | PLUS/MINUS
GM # | DATE | OPP
1 | 2011-09-07 00:00:00 | vs NAN
2 | 2011-09-24 00:00:00 | vs NAN
3 | 2011-09-28 00:00:00 | at CVC
Spreadsheet: 735803d1623181027-sumif-function-skipping-1-column-datamanipulation
Sheet: Overview

Date | Name | Product 1 | Product 2 | Product 3 | Product 4 | Product 5
2021-01-01 00:00:00 | [NAME]
 | [NAME]
 | Lewis
Date | Name | Product 1 | Product 2 | Product 3 | Product 4 | Product 5
2021-01-01 00:00:00 | [NAME] | 7 | -97 | -6 | 1 | 2
 | [NAME] | -10 | 1 | 20 | 3 | -10
 | Lewis | 10 | 0 | 0 | -4 | 10
Spreadsheet: 89676d1289434943-cell-value-changes-another-cell-or-displays-a-notification-timecardwithholidays2
Sheet: Expense Voucher

 | AZO. EXPENSE REPORT
 |  |  |  |  | Name: |  |  |  | Dept: |  |  | Date: | 2010-11-10 16:18:06
 | Billable |  | [NAME] | Job # |  | Engr | Install | Warranty |  | Sales | Other
 | Dates of | Destination |  |  | Meals |  |  | Lodging | Airfare | Taxi/Limo | Auto | Auto | Total
 | Travel | From | To | Breakfast | Lunch | Dinner | Total Meals |  |  | Etc. | Rental | Mileage | Meals/Travel
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  | TOTALS |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ENTERTAINMENT EXPENSES
 | Date | Person/Group Entertained |  |  | Explanation: Location, Bus, Purpose |  |  |  | Amount |  | Grand Total |  | 0
 |  |  |  |  |  |  |  |  |  |  | Total of ALL Travel, Entertainment,
 |  |  |  |  |  |  |  |  |  |  | and [NAME]
 |  |  |  |  |  |  |  |  |  |  | Company Expense |  | 0
 |  |  |  |  |  |  |  |  |  |  | Balance Due Employee |  | 0
 | TOTAL |  |  |  |  |  |  |  | 0
 | [NAME] EXPENSES (phone, parking/tolls, postage, non-meal tips, etc.)
 | Date |  |  | Item and/or Explanation |  |  |  |  | Amount
 |  |  |  |  |  |  |  |  |  |  | Signature of Person Submitting
 |  |  |  |  |  |  |  |  |  |  | Approved By
 | TOTAL |  |  |  |  |  |  |  | 0
Spreadsheet: 682514d1592164046-if-find-spec-gross-weight-calculation-gross-weight
Sheet: PI

Shipping details |  |  |  | Packaging and other details
 |  |  |  |  |  |  | IBC | 56.5
 |  |  |  |  |  |  | Drums | 15
 |  |  |  |  |  |  | HDPE | 10
 |  | Est Gross Weight:
 |  | Total Pallets:
 |  | CAS N°:
Item | Item description | Drums | Qty Net / Weight KG | Unit price | Amount
 |  | 40 | 20000
Spreadsheet: 220606d1363202056-sumif-by-year-horizontally-sumifyearhelp
Sheet: Sheet1

2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013 Total
24000 | 24000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000
Spreadsheet: 756903d1637862289-suming-values-based-of-multiple-column-categories-and-comparing-month-to-month-calc-based-off-moving-categories-month-on-month
Sheet: Sheet1

 | DATA SET |  |  |  |  |  | OUTPUT
 | Period | Value | Name | Category |  | 1 | A | C | A
 | 1 | 16 | [NAME] | A |  |  | to | to | to
 | 1 | 37 | [NAME] | A |  | 2 | C | A | B
 | 1 | 41 | [NAME] | B |  |  |  |  |  | <---Automate
 | 1 | 74 | [NAME] | B
 | 1 | 85 | [NAME] | C
 | 1 | 44 | [NAME] | C
 | 1 | 65 | [NAME] | C
 | 1 | 42 | Zac | A
 | 2 | 98 | [NAME] | A
 | 2 | 54 | [NAME] | C
 | 2 | 12 | [NAME] | B
 | 2 | 9 | [NAME] | B
 | 2 | 45 | [NAME] | A
 | 2 | 8 | [NAME] | A
 | 2 | 34 | [NAME] | C
 | 2 | 30 | Zac | B
Spreadsheet: 172078d1343980827-dependent-combo-box-cbo-dependent-_1
Sheet: Sheet1

 | Group 1 | [NAME] | Group 2 | G2 | Group 3 | G3
Group 1 | [NAME] | Monday | Patrik | Tuesday | [NAME] | Monday
Group 2 | Jasmine | Wednesday | terence | Friday | Chrain | Thursday
Group 3 | Timmy | Friday | Rocky |  | [NAME] | Sunday
Spreadsheet: 164308d1340724155-need-help-extracting-data-from-a-table-in-one-worksheet-to-a-cell-in-another-worksheet-customers
Sheet: Table

Amount | 2012-03-25 00:00:00 | 2012-03-26 00:00:00 | 2012-03-27 00:00:00
1 | 2 | 3 | 10
2 | 3 | 5 | 11
3 | 5 | 7 | 15
4 | 7 | 15 | 45
5 | 8 | 19 | 52
6 | 9 | 20 | 35
7 | 10 | 65 | 53
8 | 11 | 75 | 44
9 | 13 | 100 | 25
10 | 15 | 125 | 54
11 | 19 | 80 | 60
12 | 25 | 70 | 74
Spreadsheet: 112853d1308835978-is-an-array-formula-best-here-sample-data-for-array-formula-question-2011-06-23
Sheet: Summary

Summary | Total  (SUMPRODUCT) |  | Total  (Your Array)
ASTN | 2 |  | 2
CHLS | 2 |  | 2
CHTA | 1 |  | 1
[NAME] | 1 |  | 1
HTSV | 1 |  | 1
PTLD | 1 |  | 1
TOPE | 2 |  | 2
Spreadsheet: 809325d1671031572-calculation-of-a-cumulative-penalty-with-2-different-penalty-rates-penalty-calculations-logic
Sheet: Sheet2

Month | Principal Due | Amount Paid | [NAME] | Months late as at (st july 2023) | Penalty | 0.2 | 0.1 | Months late | Cumulative % | Penalty due |  |  |  | Date | Percentage
2022-05-01 00:00:00 | 100 |  |  |  |  | 140%(7 months late) | 70%(7months late) | 14 | 2.1 |  |  |  |  | 2023-07-01 00:00:00 | 0.1
2022-06-01 00:00:00 | 100 |  |  |  |  | 120%(6 month late) | 70%(7months late) | 13 | 1.9 |  |  |  |  | 2022-12-31 00:00:00 | 0.2
2022-07-01 00:00:00 | 100 |  |  |  |  | 100%(5 months late) | 70%(7months late) | 12 | 1.7
2022-08-01 00:00:00 | 100 |  |  |  |  | 80%(4 months late) | 70%(7months late) | 11 | 1.5
2022-09-01 00:00:00 | 100 |  |  |  |  | 60%(3 months late) | 70%(7months late) | 10 | 1.3
2022-10-01 00:00:00 | 100 |  |  |  |  | 40%(2 months late) | 70%(7months late) | 9 | 1.1
2022-11-01 00:00:00 | 100 |  |  |  |  | 20%(1 months late) | 70%(7months late) | 8 | 0.9
2022-12-01 00:00:00 | 100 |  |  |  |  | 0%(0 months late) | 70%(7months late) | 7 | 0.7
2023-01-01 00:00:00 | 100 |  |  |  |  |  | 60%(6months late) | 6 | 0.6
2023-02-01 00:00:00 | 100 |  |  |  |  |  | 50%(5months late) | 5 | 0.5
2023-03-01 00:00:00 | 100 |  |  |  |  |  | 40%(4months late) | 4 | 0.4
2023-04-01 00:00:00 | 100 |  |  |  |  |  | 30%(3months late) | 3 | 0.3
2023-05-01 00:00:00 | 100 |  |  |  |  |  | 20%(2months late) | 2 | 0.2
2023-06-01 00:00:00 | 100 |  |  | 1 |  |  | 10%(1months late) | 1 | 0.1
2023-07-01 00:00:00 | 100
Spreadsheet: 99086d1297852059-excel-2007-average-certain-cells-of-5-worksheets-only-if-other-cells-meet-criteria-sample-averagas-by-category
Sheet: Person 3

 | Date | Date | Date | Date | Date | Date
 | 2009-01-15 00:00:00 | 2010-02-27 00:00:00 | 2011-01-12 00:00:00
Height
Age
Weight | 164 | 168 | 172
RHR
Title (L, E, or F) | E | E | L
(Of the three dates for which data was recoreded, in the most recent, D15 is not "F", so D10 should not be included in the average formula.)
Spreadsheet: 147685d1332930686-excel-2007-return-first-value-below-and-above-search-value-problem-find-closest-values
Sheet: Sheet1

Value |  | Closest values: |  |  |  |  |  | Try searching for these values
0 |  |  | <--- returns first value that is < search value
 |  |  | <--- returns first value that is > search value |  |  |  |  | 25
 |  |  |  |  |  |  |  | 60
 |  |  | Search value: |  | 147 |  |  | 115 |  | Some test values that give  wrong results
 |  |  |  |  |  |  |  | 147
 |  |  |  |  |  |  |  | 350
 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | 135
 |  |  |  |  |  |  |  | 243 |  | Some test values that give correct results
 |  |  |  |  |  |  |  | 279
 |  |  |  |  |  |  |  | 340
Spreadsheet: 752045d1634553166-adding-true-or-false-to-a-row-if-numbers-match-test
Sheet: Sheet1

11111 |  |  |  | 11111 | 11114
11111 |  |  |  | 11111 | 11114
11112 |  |  |  | 32456 | 11114
11113 |  |  |  | 35689 | 11114
11114 |  |  |  | 35246 | 6356
11114 |  |  |  | 49439 | 134343
11114 |  |  |  | 134426 | 3434
11114 |  |  |  | 13432451 | 64564
11115 |  |  |  | 23232 | 76657
11116 |  |  |  | 55365 | 3556
Spreadsheet: 0633a02a-86e6-49e2-adf6-78ae2a7ea888
Sheet: Installment Contracts

WASHTENAW  COUNTY INSTALLMENT  OBLIGATION
Debt Service Schedule
2013-12-31 00:00:00
 | Principal | Interest | Total
2013 | 60869 | 0
2014 | 60869 | 0
Issuance Date | 10/2012
Issuance Amount | 182607
Repayment Source: | General Fund
Spreadsheet: john_zufferli__16703__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Hedgeable Volume | Current Gas Hedges |  | AECO Basis Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (contracts/day) | (contracts/day) | % Hedged | (contracts/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25 |  |  |  |  | 12
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03 |  |  |  |  | 6
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9 |  |  |  |  | 5
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06 |  |  |  |  | 5
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5 |  |  |  |  | 4
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02 |  |  |  |  | 4
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09 |  |  |  |  | 4
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1 |  |  |  |  | 4
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14 |  |  |  |  | 4
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11 |  |  |  |  | 0
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08 |  |  |  |  | 0
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04 |  |  |  |  | 0
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03 |  |  |  |  | 0
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7 |  |  |  |  | 0
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7 |  |  |  |  | 0
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7 |  |  |  |  | 0
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7 |  |  |  |  | 0
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7 |  |  |  |  | 0
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7 |  |  |  |  | 0
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 05165766-85cd-47cb-b777-4f9fa87172f3
Sheet: 11d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | - | 698 | - | 376
Cross-Currency Fixed-Fixed | - | 52 | - | 50
Cross-Currency Fixed-Float | - | 84 | - | 26
TOTAL | - | 834 | - | 452