tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: f3703712-1433-4375-b038-db805f51a3dd
Sheet: 6

 | Jul 19 |  | Jul 26 |  | Aug 2 |  | Aug 9
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rate* | 84500 | 84500 | 84500 | 84500 | 84500 | 84500 | 84500 | 84500
SD/MSPs** | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equity | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly total, estimated swap event volumes by asset class and participant type (in number of events), all products and tenors, cleared and uncleared.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL]
Spreadsheet: 161954d1339680830-comparing-multiple-cells-sample
Sheet: After

Code | Name | Entry Date | Location | [NAME] | Line | Qty | Promise_Date | Promise_Date
SSS1 | Sample Inc. | 20101117 | P | 21178 | 2 | 20657 | 2012-07-02 00:00:00
SSS1 | Sample Inc. | 20120116 | P | 31712 | 3 | 2500 | 2012-07-04 00:00:00
SSS1 | Sample Inc. | 20120116 | P | 31712 | 4 | 2000 | 2012-10-05 00:00:00
SSS1 | Sample Inc. | 20120127 | A | 18708 | 1 | 7 | 2012-07-27 00:00:00 | Line was for location A but was not delete because there is no similar order in location P
SSS1 | Sample Inc. | 20120127 | P | 69050 | 16 | 250 | 2012-06-12 00:00:00 | Line was for location P but there was no line for location A
SSS1 | Sample Inc. | 20110801 | A | 16291 | 1 | 1 | 2012-06-08 00:00:00 | Line was for location A but was not delete because there is no similar order in location P
SSS1 | Sample Inc. | 20120209 | P | 56381 | 1 | 2500 | 2012-06-22 00:00:00
Spreadsheet: 141107d1329109937-consecutive-dates-in-excel-07-5-or-6-where-dates-are-consecutive-niven_sample
Sheet: Sheet1

date
2010-01-04 00:00:00
2010-01-15 00:00:00
2010-01-25 00:00:00
2010-01-26 00:00:00
2010-01-27 00:00:00
2010-01-28 00:00:00
2010-01-29 00:00:00 |  |  | period | no of occuences
2010-01-30 00:00:00 |  |  | 5 days
2010-01-31 00:00:00 |  |  | 6 days
2010-03-01 00:00:00
2010-03-02 00:00:00
2010-03-03 00:00:00
2010-03-04 00:00:00
2010-03-05 00:00:00
2010-05-08 00:00:00
2010-05-09 00:00:00
2010-05-10 00:00:00
2010-05-11 00:00:00
2010-05-12 00:00:00
2010-05-13 00:00:00
2010-05-14 00:00:00
Spreadsheet: 98632d1297480201-automatically-show-data-for-3-weeks-before-and-after-current-week-in-graph-line_chart-1
Sheet: Sheet1

 | 2011-02-07 00:00:00
FC | 13 | 17 | 25 | 34 | 39 | 45 | 48 | 55
AC | 23 | 30 | 32 | 48 | 50 | 50 | 55 | 60
Spreadsheet: 770921d1646336171-help-with-royalty-scale-calculation-royalty
Sheet: 2019

 |  |  |  |  |  |  |  |  |  | 2019
article | EAN | publishing date | retail price | net retail price | title | original title | series | printed copies | remaining copies from 2018 sales | sold copies | gross turnover at net retail price HUF | royalty up to 6000 copies: 8% on gross turnover HUF | royalty up to 6000 copies: 8% on gross turnover EUR | royalty up to 12.000 copies: 10% on gross turnover HUF | royalty up to 12.000 copies: 10% on gross turnover EUR | royalty thereafter: 12% on gross turnover HUF | royalty thereafter: 12% on gross turnover EUR | royalty total HUF | royalty total EUR | royalty advance paid (remaining from 2018) | royalty to be paid
 |  |  | 1699 |  | title 1 |  |  | 3146 | 1489 | 1757
 |  |  | 1699 |  | title 2 |  |  |  | 2106 | 1615
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019 Total:
2019 | exchange rate (EUR/HUF): |  |  | 325.35
Spreadsheet: 168286d1342369453-auto-create-hyperlink-map-the-same-cell-name-with-worksheet-name-hyperlink
Sheet: Sheet1

worksheet |  | or |  |  |  | or | sheet names
1 |  | 1 |  |  |  | 1 | 1
2 |  | 2 |  |  |  | 2 | 2
3 |  | 3 |  |  |  | 3 | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
Spreadsheet: 751498d1634140953-consolidate-txt-from-multiple-columns-into-one-column-and-remove-duplicates-text-to-single-column
Sheet: Sheet1

Raw List: |  |  | Desired Results
 |  |  | DAI
 |  |  | MAI
 |  |  | IMX
 |  |  | AVAX
 |  |  | SUSHI
 |  |  | WETH
 |  |  | MATIC
DAI | MAI |  | CRV
 |  |  | QI
 |  |  | USDT
 |  |  | QUICK
MAI | USDT
IMX | WETH
AVAX | WETH
SUSHI | WETH
WETH | DAI
WETH | USDT
MATIC | QUICK
CRV | WETH
QI | WETH
Spreadsheet: 875546d1722147064-calculating-per-diem-meals-on-multiple-variables-sallyd028-per-diems-example-aligw
Sheet: Per Diems

 | Example
 | Departure Date | Start Time |  | Return Date | End Time
 | 2024-07-30 00:00:00 | 07:00:00 |  | 2024-08-03 00:00:00 | 17:00:00 |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Breakfast | Lunch | Dinner
 |  |  |  |  |  |  |  |  |  | 2024-07-30 00:00:00 | 0 | 1 | 1
 | Number of Nights |  |  |  |  |  |  |  |  | 2024-07-31 00:00:00 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  | 2024-08-01 00:00:00 | 1 | 1 | 1
 | Meals entitlement - calculated from trip dates |  |  | Breakfast | Lunch | Dinner |  |  |  | 2024-08-02 00:00:00 | 1 | 1 | 1
 |  |  |  |  | 5 | 4 |  |  |  | 2024-08-03 00:00:00 | 1 | 1 | 0
 | Departure |  |  |  | Return
 | Meal | Before |  |  | Meal | After
 | Breakfast | 07:00:00 |  |  | Breakfast | 08:00:00
 | Lunch | 11:00:00 |  |  | Lunch | 14:00:00
 | Dinner | 17:00:00 |  |  | Dinner | 19:00:00
 | Question 1
 | How do I calculate the number of meals based on multiple variables:
 | 1 | Departure date and start time
 | 2 | Return date and end time
 | 3 | Departure before time for breakfast, lunch and dinner
 | 4 | Return after time for breakfast, lunch and dinner
 | Answer should populate the following:
 | 4 | in cell E14 Breakfast
 | 5 | in cell F14 Lunch
 | 4 | in cell E14 Dinner
 | Question 2
 | I want the time displayed as 24 hour time. But when you enter you must put the colon in. Is there any way to alter the way the time is entered to display as 24 hour time without having to put a colon in?
 | For example if I have formatted the cell to display 24 hour time:
 | But when I enter the time as "0700" without a colon
 | It will display like this 0:00
Spreadsheet: 804491d1668099831-i-need-a-formula-for-an-avg-of-a-data-set-found-on-multiple-sheets-but-must-exclude-zeroes-dans-driver-list
Sheet: 1111

First | Last | 4 week Score Avg | 4 week Incident per [NAME] | Week 41 Score | Week 41 Incidents Per Mile | Week 42 Score | Week 42 Incidents Per Mile | Week 43 Score | Week 43 Incidents Per Mile | Week 44 Score | Week 44 Incidents Per Mile
[NAME] | [NAME] |  |  | n/a | n/a | n/a | n/a | 82 | 2.5 | 90 | 1.95
Desarae | Carroll |  |  | 89 | 1.29 | 83 | 1.32 | 84 | 1.28 | 91 | 1.01
Brandi | Donnelly |  |  | 96 | 0.77 | 97 | 0.52 | n/a | n/a | n/a | n/a
Shelby | [NAME] |  |  | n/a | n/a | 85 | 1.94 | 80 | 1.82 | 94 | 1.15
[NAME] | King |  |  | 90 | 1.28 | 94 | 0.91 | 94 | 0.93 | 95 | 0.82
[NAME] | [NAME] |  |  | 85 | 2.31 | 81 | 2.7 | n/a | n/a | 90 | 2.34
 | Store Average
Spreadsheet: 196548d1354036090-calculating-hours-worked-for-3rd-shift-weekly-timesheet-a
Sheet: Weekly Time Record

Kenco Fleet Services
Fax:  [PHONE]
[EMAIL]
Time Period | 2012-11-26 00:00:00
Employee Name: |  |  |  |  | Location:
Date | Day | In | Out | In | Out | Regular Hrs. | [NAME]. | PTO | Total
 |  | 07:00:00 | 13:00:00 | 13:30:00 | 18:00:00
 |  | 18:00:00 | 00:00:00 | 00:30:00 | 06:00:00
 |  |  |  |  | Total Hrs.
Employee Name: |  |  |  |  | Location:
Date | Day | In | Out | In | Out | Regular Hrs. | [NAME]. | PTO | Total
 |  |  |  |  | Total Hrs.
Employee Name: |  |  |  |  | Location:
Date | Day | In | Out | In | Out | Regular Hrs. | [NAME]. | PTO | Total
 |  |  |  |  | Total Hrs.
Employee Name: |  |  |  |  | Location:
Date | Day | In | Out | In | Out | Regular Hrs. | [NAME]. | PTO | Total
 |  |  |  |  | Total Hrs.
Employee Name: |  |  |  |  | Location:
Date | Day | In | Out | In | Out | Regular Hrs. | [NAME]. | PTO | Total
 |  |  |  |  | Total Hrs.
Spreadsheet: 850338d1700689553-dynamic-calendar-calendar-2024-landscape-year-at-a-glance
Sheet: Calendar 2024 UK

 |  |  |  |  |  |  |  |  |  | Search |  |  |  |  |  |  |  | Count
Calendar 2024 UK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | https://www.calendarpedia.co.uk/
January |  |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  |  | March |  |  |  |  |  |  |  |  | April
Wk | Mo | [NAME] | We | Th | Fr | Sa | Su |  | Wk | Mo | [NAME] | We | Th | Fr | Sa | Su |  | Wk | Mo | [NAME] | We | Th | Fr | Sa | Su |  | Wk | Mo | [NAME] | We | Th | Fr | Sa | Su
1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  | 5 |  |  |  | 1 | 2 | 3 | 4 |  | 9 |  |  |  |  | 1 | 2 | 3 |  | 14 | 1 | 2 | 3 | 4 | 5 | 6 | 7
2 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |  | 6 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 10 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 15 | 8 | 9 | 10 | 11 | 12 | 13 | 14
3 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |  | 7 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 11 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 16 | 15 | 16 | 17 | 18 | 19 | 20 | 21
4 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  | 8 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 12 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 17 | 22 | 23 | 24 | 25 | 26 | 27 | 28
5 | 29 | 30 | 31 |  |  |  |  |  | 9 | 26 | 27 | 28 | 29 |  |  |  |  | 13 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 18 | 29 | 30
Spreadsheet: benjamin_rogers__1172__Wheatland_New - W 501 D5A
Sheet: Tax Calculations

State and Federal Tax Calculation
 |  |  | 1
STATE TAXES
Adjusted Gross Income Tax
Book Income
Adjusted Gross Income Rate
State Adjusted Gross Income Tax
State Gross Receipts Taxes
Gross Receipts
Gross Receipts Tax Rate
Gross Receipts Tax Liability
Greater of Adjusted or Gross Receipts
State Income Taxes
Pretax Book Income
Less: |  |  | 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
Less: |  |  | 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
Adjusted Pretax Income
Plus Book Depreciation & Amortization
Less State Tax Depreciation
State Taxable Income
Taxable Income
State Income Tax Rate
State Income Tax Expense (Benefit)
Beginning NOL's
New NOL's
Expired NOL's |  | 20 Years | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
TOTAL STATE TAXES
Plus: Supplemental Tax
Total State Taxes
FEDERAL TAXES
Pretax Book Income
Plus Book Depreciation & Amortization
Less: Federal Tax Depreciation
Less: State Taxes
Taxable Income
Federal Tax Rate
Federal Tax Expense/ (Benefit)
NOL Carryforward
NOL Utilization
Total Federal Cash Taxes Payable/(Benefit)
DEFERRED TAX LIABILITY
Total Cash Taxes
Total Book Taxes
Total Deferred Tax Liability
Cumulative DTL
Spreadsheet: chris_stokley__3932__Curves
Sheet: Sheet1

NP15 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00
PG&E Embedded Gen | 61.127771025636 | 60.40757862357786 | 58.79312582894845 | 59.43256747708413 | 48.96865527254178 | 31.7827289284468 | 31.84309763270342 | 29.22609339285203 | 29.64585407564599 | 32.11372849889211
NP Wholesale Curve | 55.16018069234681 | 43.46930629873904 | 49.82258064516129 | 30.5 | 32.2 | 35.25 | 37.75 | 37.25 | 36 | 34.5
SP15
[NAME] | 80.69393557058285 | 79.36905669144096 | 68.38267087785496 | 73.81519703247416 | 42.45760704894467 | 41.77009755323155 | 41.1619741512337 | 41.51262476722149 | 41.88140505279726 | 41.91968559123667
SP Wholesale Curve | 46.21488353575018 | 34.25687481303213 | 38.07174913112857 | 30.35 | 31.5 | 31.85 | 34.65 | 35.25 | 34.75 | 33.75
Spreadsheet: 148778d1333551900-excel-2007-3-way-lookup-index-match-2
Sheet: charging

 | address | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00
1 | Pigeon street | 10 | 10 | 10 | 10 | 10
2 | Sesame street | 10 | 10 | 10 | 10 | 10
3 | [NAME] |  | 10 | 10 | 10 | 10
4 | Coronation street |  | 10 | 10 | 10 | 10
5 | The Dales |  |  | 10 | 10 | 10
6 | High Street |  |  | 10 | 10 | 10
7 | Hill Street |  |  |  | 10 | 10
8 | church [NAME] |  |  |  | 10 | 10
9 | Raleigh  Way |  |  |  |  | 10
10 | King street |  |  |  |  | 10
Spreadsheet: 841385d1693567455-transposing-and-assigning-values-with-power-query-sampleworkbook_2
Sheet: DesiredResult

Score | BD
1 | 0
1 | 1
1 | 2
1 | 3
1 | 4
1 | 5
1 | 6
1 | 7
2 | 8
2 | 9
2 | 10
3 | 11
3 | 12
3 | 13
3 | 14
4 | 15
4 | 16
4 | 17
4 | 18
4 | 19
5 | 20
5 | 21
5 | 22
5 | 23
5 | 24
6 | 25
6 | 26
6 | 27
6 | 28
6 | 29
7 | 30
7 | 31
7 | 32
7 | 33
7 | 34
7 | 35
8 | 36
8 | 37
8 | 38
8 | 39
8 | 40
9 | 41
9 | 42
9 | 43
9 | 44
10 | 45
10 | 46
10 | 47
10 | 48
11 | 49
11 | 50
11 | 51
11 | 52
11 | 53
12 | 54
12 | 55
12 | 56
13 | 57
13 | 58
14 | 59
14 | 60
15 | 61
15 | 62
16 | 63
17 | 64
18 | 65
19 | 66
Spreadsheet: 6c2673ad-75b1-4510-856f-1adda052fccf
Sheet: 12-11-2014

IRN | DISTRICT | COUNTY | FISCAL STATUS | CAUTION  DECLARED | WATCH  DECLARED
048462 | Black River Local SD | Medina | CAUTION | 2011-02-18 00:00:00
043711 | Canton City SD | [NAME] | CAUTION | 2007-03-22 00:00:00
047845 | East Knox Local SD | Knox | CAUTION | 2012-09-04 00:00:00
043968 | Fairborn City SD | Greene | CAUTION | 2013-01-14 00:00:00
045369 | Fairport Harbor Ex Vill SD | Lake | CAUTION | 2004-04-30 00:00:00
045823 | Hillsdale Local SD | Ashland | CAUTION | 2012-06-14 00:00:00
044230 | Lockland Local SD | [NAME] | CAUTION | 2013-11-22 00:00:00
044263 | Lorain City SD | Lorain | CAUTION | 2007-06-23 00:00:00
048025 | North Fork Local SD | Licking | CAUTION | 2010-03-25 00:00:00
046599 | Richmond Heights Local SD | Cuyahoga | CAUTION | 2014-03-17 00:00:00
046003 | Shadyside Local SD | Belmont | CAUTION | 2004-04-12 00:00:00
049064 | Southern Local SD | [NAME] | CAUTION | 2011-04-11 00:00:00
048652 | Switzerland of Ohio Local SD | Monroe | CAUTION | 2010-07-31 00:00:00
045005 | Warrensville Heights City SD | Cuyahoga | CAUTION | 2008-05-05 00:00:00
049999 | Coventry Local SD | Summit | WATCH |  | 1997-05-15 00:00:00
047845 | East Knox Local SD | Knox | Watch | 2012-09-04 00:00:00
044495 | Niles City SD | Trumbull | WATCH |  | 2003-03-10 00:00:00
043570 | Bellaire Local SD | Belmont | EMERGENCY |  | 2009-12-31 00:00:00
050120 | Brookfield Local SD | Trumbull | EMERGENCY |  | 2013-05-14 00:00:00
048488 | Cloverleaf Local SD | Medina | EMERGENCY |  | 2012-01-24 00:00:00
047209 | Ledgemont Local SD | [NAME] | EMERGENCY |  | 2011-07-11 00:00:00
044297 | Mansfield City SD | Richland | EMERGENCY |  | 2013-12-17 00:00:00
Spreadsheet: 168871d1342618062-vlookup-ref-error
Sheet: Sheet1

Data | LOTE B | LOTE B % | LOTE C | LOTE C % | Grand Total | % | TOTAL %
2011-09-01 00:00:00 | 100 | 0.4672897196261682 | 114 | 0.5327102803738317 | 214 | 0.02895805142083897 | 1
2011-10-01 00:00:00 | 204 | 0.3349753694581281 | 405 | 0.6650246305418719 | 609 | 0.0824086603518268 | 1
2011-11-01 00:00:00 | 247 | 0.4029363784665579 | 366 | 0.5970636215334421 | 613 | 0.08294993234100136 | 1
2011-12-01 00:00:00 | 264 | 0.5057471264367817 | 258 | 0.4942528735632184 | 522 | 0.07063599458728011 | 1
2012-01-01 00:00:00 | 269 | 0.33625 | 531 | 0.66375 | 800 | 0.108254397834912 | 1
2012-02-01 00:00:00 | 377 | 0.4736180904522613 | 419 | 0.5263819095477387 | 796 | 0.1077131258457375 | 1
2012-03-01 00:00:00 | 402 | 0.41875 | 558 | 0.58125 | 960 | 0.1299052774018944 | 1
2012-04-01 00:00:00 | 266 | 0.4618055555555556 | 310 | 0.5381944444444444 | 576 | 0.07794316644113668 | 1
2012-05-01 00:00:00 | 465 | 0.3621495327102804 | 819 | 0.6378504672897196 | 1284 | 0.1737483085250338 | 1
2012-06-01 00:00:00 | 534 | 0.5255905511811023 | 482 | 0.4744094488188976 | 1016 | 0.1374830852503383 | 1
Grand Total | 3128 | 0.4232746955345061 | 4262 | 0.5767253044654939 | 7390 | 0.9999999999999999 | 1
1st Data | 2011-09-01 00:00:00
last Data | 2012-07-01 00:00:00
1ºMês
[NAME]
[NAME]
Spreadsheet: 875357d1721935036-avg-from-division-across-two-2d-ranges-inc-with-1d-criteria-and-ignoring-error-values-2-x-2d-sum-with-1d-range-ignoring-errors
Sheet: Excel Forum

 | Year: | 2024
 | Users |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
 |  | 2023 | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2025 | 2025 | 2025
 | 1 |  | 10 | 8 | 5 | 8 | 22 | 25 | 13 | 6 | 9
 | 2
 | 3 |  |  |  | 4 | 9 | 6 | 3 | 2 | 7 | 2
 | 4 |  |  |  |  |  | 45 | 4 | 7 | 7 | 48
 | 5
 | 6
 | 7 |  |  | 99 | 55 | 12 | 8 | 7 | 5 | 4 | 6
 | 8
 | 9
 | 10 |  |  |  |  |  | 4 | 4 | 7 | 7 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < Manually-calculated correct answer
 | Hours
 |  | 2023 | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2025 | 2025 | 2025 |  |  |  |  | Seeking a calculation, which:
 | 1 |  | 3 | 5 | 7 | 8 | 9 | 5 | 4 | 3 | 2
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Where criteria are met:
 | 3 |  |  |  | 32 | 5 | 6 | 3 | 2 | 2 | 5 |  |  |  |  |  | Year = 2024
 | 4 |  |  |  |  |  | 46 | 58 | 58 | 3 | 4 |  |  |  |  |  | Value <> NA()
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ..then divides the bottom cell by the corresponding top cell
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sums all cells which performs the above calculation
 | 7 |  |  | 2 | 6 | 6 | 46 | 46 | 47 | 7 | 7 |  |  |  |  | Divides the sum by the count of all cells which meet the criteria
 | 8
 | 9
 | 10 |  |  |  |  |  | 5 | 5 | 5 | 4 | 4
Spreadsheet: tracy_geaccone__40536__CFNNGTWStan02
Sheet: TW-Prelim 2002 Plan

TRANSWESTERN PIPELINE GROUP
 |  |  |  |  |  |  |  |  |  | 113.2
 |  | Net Income Change |  |  |  |  |  |  | -5
 |  | Reserve Activity Change |  |  |  |  |  |  | -12.5
 |  | Decreased Income Taxes |  |  |  |  |  |  | 4.6
 |  | Others, net
 |  |  |  |  |  |  |  |  |  | 100.2
 |  |  |  |  |  |  |  |  |  | -115.8
 |  | Net Income Change |  |  |  |  |  |  | -5
 |  | Long Term Debt Repayment in 2001 |  |  |  |  |  |  | 150
 |  | Lower Debt Interest Expense |  |  |  |  |  |  | 7.8
 |  | Navajo and Laguna ROW Settlements in 2001
 |  | Decreased Income Taxes |  |  |  |  |  |  | 4.6
 |  | Lower Excess Fuel Sale Revenue (Primarily Lower Price per Mcf) and Net Imbalance Activity
 |  | Higher Capital Expenditures |  |  |  |  |  |  | -12.1
 |  | Others, net
 |  |  |  |  |  |  |  |  |  | 33.3
Spreadsheet: 689262d1596223908-running-total-in-table-from-bottom-up-sample
Sheet: Sheet1

Date | Merchant | Category | Amount $ | Balance
2020-07-30 00:00:00 | Netflix | Bills/Utilities | -15.99
2020-07-29 00:00:00 | Paypal Inst Xfer Cbsallacces | Transfer | -5.99
2020-07-28 00:00:00 | [NAME] | Transfer | -25.98
2020-07-28 00:00:00 | Paypal Inst Xfer Microsoft | Shopping | -0.79
2020-07-28 00:00:00 | Dbt Crd Chewy Fl | Shopping | -58.09
2020-07-24 00:00:00 | Paypal Inst Xfer Plex | Professional Services | -4.99
2020-07-24 00:00:00 | [NAME] Unlt | Shopping | -10.68
2020-07-23 00:00:00 | Dbt Crd Amzn Mktp | Shopping | -10.68
2020-07-22 00:00:00 | [NAME] | Groceries | -26.5
2020-07-21 00:00:00 | Dbt Crd Chewy Fl | Shopping | -20.24
2020-07-20 00:00:00 | [NAME] | Professional Services | -26.47
2020-07-20 00:00:00 | [NAME] | Groceries | -9.62
Spreadsheet: 374098d1422652828-need-help-combining-table-data-from-a-range-of-worksheets-to-a-separate-worksheet-orientation-roster
Sheet: DO NOT DELETE OR ALTER!

RCCAT_8959 |  | [NAME] | RMZA | Barista | ZZAJ | Teller | VGRC | Cash Bartender | RMZA | [NAME] | RMZA | Premium Stand Supervisor | RGYQ | [NAME] | RGYQ | [NAME] | RCWD | Culinary Supervisor | RCWB | Floor/Level Supervisor | OCWA | Suite Captain | SGUB | Vendor - Alcohol | VIZP | Warehouse Supervisor | WCYD | Culinary Supervisor | RCWB
RCCON_8961 |  | [NAME] | RGZQ | [NAME] | ZZAJ | Auditor | IEZU | Beverage Bar Back | RMZE | [NAME] | RGZQ | Premium Cashier | RKVB | Cashier | RKVB | Facilities Supervisor | HDYY | Cook 1 | RCXE | Stand Leader | OCWA | Pantry Supervisor | RGYQ | Vendor - Non-Alcohol | VIZP | [NAME] | [NAME] | Cook 1 | RCXE
RCKIT_8959 |  | Banquet Captain | RGZD | [NAME] | RGYQ | Security Officer | IEZU | Supervisor |  | Banquet Captain | RGZD | Premium Counter Attendant | RKVK | [NAME] | RKVK | Facilities Lead | HDYY | [NAME] | RCXE | Retail Associate | NCTH | [NAME] | SGUB | Vendor [NAME] | RGYQ |  |  | [NAME] | RCXE
RSADM_8171 |  | Beverage Bar Back | RMZE | Cashier | RKVB | Money Room Supervisor | VGRB |  |  | Beverage Bar Back | RMZE | [NAME] | RCXA | [NAME] | RMZE | Core Crew - Day Shift | HDYZ | Cook 3 | RCXE | Texan Store Associate | NCTH | VIP Suite Attendant | SGUB | Vendor [NAME] | RKVB |  |  | Cook 3 | RCXE
[NAME] |  |  |  | [NAME] | RKVK |  |  |  |  |  |  | In-seat Supervisor/FOH | ZZDP | [NAME] | RCXA | Texans Crew - 3rd Shift | HDYZ | [NAME] | HCYF | [NAME] | [NAME] | [NAME] | RKZC | [NAME] | VIZP
RSCAT_8177 |  |  |  | [NAME] | RMZE |  |  |  |  |  |  | In-seat Supervisor/BOH | RGYQ | [NAME] | RKZC | Event Attendant | HDYZ | [NAME] | RCYG | Program Sales | VIZP | [NAME] | SGUB | Uniform Room Attendant | HGWA
RSCLB_8174 |  |  |  | [NAME] | RCXA |  |  |  |  |  |  | In-seat [NAME] | RKZC | Stand Supervisor | RGYQ | Post-event [NAME] | HDYZ
RSCON_8173 |  |  |  | [NAME] | RKZC |  |  |  |  |  |  | In-seat Server | ZZGH |  |  | Center Facilities Attendant | HDYZ
RSFAC_6925 |  |  |  | Stand Supervisor | RGYQ
RSKIT_8177
RSRET_8175
[NAME]
RSVND_8173
RSWHS_8176
Spreadsheet: 789539d1659170283-spill-arrays-multi-column-sumifs-and-countif-rearranging-columns-gk-ef
Sheet: Sheet1

Name | H1 | H2 | H3 |  |  |  | [NAME] | H1 | H2 | H3 | Count of name
Q | 1 | 11 | 111 |  |  |  |  | 2 | 22 | 222 | 2
W | 30 | 33 | 14 |  |  |  | W | 71 | 81 | 55 | 3
E | 2 | 22 | 222 |  |  |  | E | 6 | 66 | 666 | 3
W | 10 | 19 | 35 |  |  |  | R | 8 | 22 | 27 | 1
E | 2 | 22 | 222
R | 8 | 22 | 27
E | 2 | 22 | 222 |  |  |  |  | 2 | 22 | 222 | 2
W | 31 | 29 | 6 |  |  |  | W | 71 | 81 | 55 | 3
Q | 1 | 11 | 111 |  |  |  | R | 8 | 22 | 27 | 1
Spreadsheet: 801973d1666530668-search-formula-based-on-cell-value-colourexample-aligw
Sheet: Sheet1

Product Name | Needs to return value from list when A2 etc matches |  | List
Dress with red details |  |  | Colour
[NAME] |  |  | Red
Red Jumper |  |  | Gold
Blue Jumper |  |  | Red
Black Trousers |  |  | Blue
Dress with Red detail |  |  | Black
Orange Jumpsuits |  |  | Red
Yellow Jumpsuit
[NAME]
Top Red
Trousers Black
Orange Jumpsuits
Yellow Jumpsuit
[NAME]
Top Red
Trousers Black
Spreadsheet: 766194d1643794839-averaging-values-based-on-multiple-conditions-copy-of-sample-10-
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 |  |  | Start row | 3 |  | 3
A | 1 | 78 |  |  |  |  |  |  | Start column | C |  | 3
A | 2 | 99 |  | 83 |  |  |  |  | End row | 5 |  | 5
A | 3 | 72 | 93 |  | 79 | 85 |  |  | End Column | E |  | 5
A | 4 | 83 | 89 |  |  | 75
B | 1 | 89 |  | 82 |  |  |  | INDIRECT formula
B | 2 |  |  |  | 93 | 96
B | 3 | 81 |  | 72 |  |  |  | OFFSET formula
B | 4 |  |  |  |  | 91
C | 1 | 77 |  |  |  |  |  |  | C-G need 1,2,3
C | 2 |  | 91 | 79 |  |  |  |  | B need 2,3
C | 3 |  |  |  | 89 |  |  |  | A need A
C | 4 | 92 |  | 84 | 78