tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 40954d1239357409-conditional-formatting-objects-679172
Sheet: Conditional Formatting

 | Data per Week |  |  |  |  |  |  |  | Data Graphed Week over Week
 |  | Day - (Date) |  | Visitors |  | % Chg.
 |  | Sun - (Mar 29, 2009) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MOCK DATA
 |  | Last Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WUVs | Other WUVs |  | WUVs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 3115610 | 194403 |  | 2009-02-22 00:00:00 | 5106277
 |  | Mon - (Mar 30, 2009) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar 23, 2009 | 649197 | 75454 |  | 2009-03-01 00:00:00 | 5201879 |  | 1
 |  | Last Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 372063 | 53319 |  | 2009-03-08 00:00:00 | 5032144 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 264106 | 41998 |  | 2009-03-15 00:00:00 | 4897536 |  | 1
 |  | [NAME] - (Mar 31, 2009) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 26, 2009 | 221354 | 36518 |  | 2009-03-22 00:00:00 | 5141244 |  | 1
 |  | Last Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar 27, 2009 | 257226 | 44351 |  | 2009-03-29 00:00:00 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar 28, 2009 | 261688 | 54389
 |  | Wed - (Apr 1, 2009) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar 29, 2009 | 3162575 | 206184 |  | Other WUVs
 |  | Last Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar 30, 2009 | 627092 | 70540 |  | 2009-02-22 00:00:00 | 489756
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar 31, 2009 | 357121 | 51944 |  | 2009-03-01 00:00:00 | 500013
 |  | Thurs - (Apr 2, 2009) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr 1, 2009 | 255969 | 40599 |  | 2009-03-08 00:00:00 | 497562
 |  | Last Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr 2, 2009 | 205363 | 37962 |  | 2009-03-15 00:00:00 | 492518
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr 3, 2009 | 240867 | 42835 |  | 2009-03-22 00:00:00 | 500432
 |  | Fri - (Apr 3, 2009) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr 4, 2009 | 233269 | 46997 |  | 2009-03-29 00:00:00 | 497061
 |  | Last Week
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prior Week | 5141244 | 500432
 |  | Sat - (Apr 4, 2009) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last Week | 5082256 | 497061
 |  | Last Week
 |  |  |  |  |  |  |  |  |  | I need for the arrows above to only display if the number next to it is ≥ 0.0% ([NAME]) or < 0.0% (Red Arrow)
Spreadsheet: 3bba3854-f300-4720-8fc8-3d60ac4e9027
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
[NAME] | 38081379883 | Skillet | Awake | 2010-09-21 | Guitar Book | Guitar Folio | 21.95 | Y | Available
Merch | 679143049247 | Skillet | Black Skillet 'Rise' Unisex Adult Medium | 2013-06-25 | T-Shirt | Na | 17.99 | N | Available
Merch | 679143049254 | Skillet | Black Skillet 'Rise' Unisex Adult Large | 2013-06-25 | T-Shirt | Na | 17.99 | N | Available
Merch | 679143049261 | Skillet | Black Skillet 'Rise'  Unisex Adult Xlarge | 2013-06-25 | T-Shirt | Na | 17.99 | N | Available
Merch | 679143049353 | Skillet | White Skillet 'Rise' Womens Adult Small | 2013-06-25 | T-Shirt | Na | 17.99 | N | Available
Merch | 679143049360 | Skillet | Black Skillet 'Rise' Unisex Adult Small | 2013-06-25 | T-Shirt | Na | 17.99 | N | Available
Word Records | 403002676912 | Skillet | Skillet [NAME] | 2013-06-25 | Misc | Rock | 0 | Y | Available
Atlantic-Elektra | 75678732225 | Skillet | Rise | 2013-06-25 | Compact Disc | Rock | 13.99 | Y | Available
Atlantic-Elektra | 75678731969 | Skillet | Rise Deluxe Edition Cd/Dvd | 2013-06-25 | Compact Disc With DVD | Rock | 18.99 | Y | Available
Merch | 679143049162 | Skillet | Skillet Drumsticks | 2013-06-25 | Misc | Na | 14.99 | N | Available
Merch | 679143049179 | Skillet | Skillet Trucker Hat | 2013-06-25 | Misc | Na | 14.99 | N | Available
Merch | 679143049155 | Skillet | Skillet 18" X 24" Band Image Poster | 2013-06-25 | Poster | Na | 4.99 | N | Available
Merch | 679143049186 | Skillet | Skillet Black Logo Dog Tag | 2013-06-25 | Misc | Na | 4.99 | N | Available
Merch | 679143049193 | Skillet | Black Skillet Logo Wristband | 2013-06-25 | Misc | Na | 4.99 | N | Available
Merch | 679143049124 | Skillet | Skillet Logo Earbuds | 2013-06-25 | Misc | Na | 14.99 | N | Available
Merch | 679143049131 | Skillet | Skillet Logo Iphone 4 Phone Cover (Hard Case) | 2013-06-25 | Misc | Na | 9.99 | N | Available
Merch | 679143049148 | Skillet | Skillet Logo Iphone 5 Phone Cover (Hard Case) | 2013-06-25 | Misc | Na | 9.99 | N | Available
Merch | 679143049223 | Skillet | White Skillet 'Rise' Womens Adult Large | 2013-06-25 | T-Shirt | Na | 17.99 | N | Available
Merch | 679143049216 | Skillet | White Skillet 'Rise' Womens Adult Medium | 2013-06-25 | T-Shirt | Na | 17.99 | N | Available
Merch | 679143049230 | Skillet | White Skillet 'Rise' Womens [NAME] | 2013-06-25 | T-Shirt | Na | 17.99 | N | Available
Word Records | 403002680513 | Skillet | Skillet 5' X 5' [NAME] | 2013-05-27 | [NAME] | Na | 115 | Y | Available
Spreadsheet: michelle_lokay__26621__imbalsumm0102
Sheet: GPM

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled
1 | 25933 | 25000 | 24799 | 24000
2 | 26491 | 25000 | 24763 | 24000
3 | 25000 | 25000 | 24413 | 24000
4 | 24998 | 25000 | 24252 | 24000
5 | 29668 | 25000 | 24253 | 13474
6 | 22951 | 30000 | 24278 | 24000
7 | 24954 | 25000 | 24397 | 24000
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00 | Balance | -772485 |  | -64735
2001-02-07 00:00:00 | Balance
 | Contract #
 | 22864 |  |  |  | -58339.66
 | 20379 |  |  |  | -51695.87
 | 21459 |  |  |  | 10570.56
 | 26357 |  |  |  | 44144.84
 | 21544 |  |  |  | 61340.16
 | 24532 |  |  |  | -186461.09
 | Total Duke
Spreadsheet: 34613d1231941840-countif-multiple-variables-multiple-sheets-helpwcountif
Sheet: Sheet1

 | [NAME] | [NAME] | Doug | [NAME] | [NAME]
 | 0 | 0 | 0 | 0 | 0
Nov. 16-22 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
Nov. 23-29
 | 0 | 0 | 0 | 0 | 0
Nov.30 - Dec. 6
 | 0 | 0 | 0 | 0 | 0
Dec. 7-13
 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 842938d1694927871-using-sumproduct-to-rank-by-group-need-to-break-tie-rank
Sheet: h_22SEP22

DATE | ID | pq | RANK
9/22/2022 | 2022-09-22RAS6 | 1.105541814
9/22/2022 | 2022-09-22RAS6 | 1.320816819
9/22/2022 | 2022-09-22RAS6 | 1.320816819 |  | <---- should be 3
9/22/2022 | 2022-09-22RAS6 | 1.389979305
9/22/2022 | 2022-09-22RAS6 | 1.454043606
9/22/2022 | 2022-09-22RAS6 | 1.529743825
9/22/2022 | 2022-09-22RAS6 | 1.60003801
9/22/2022 | 2022-09-22RAS6 | 1.664364518
9/22/2022 | 2022-09-22RAS6 | 1.676241628
9/22/2022 | 2022-09-22RAS6 | 1.851029466
9/22/2022 | 2022-09-22RAS6 | 1.913304948
9/22/2022 | 2022-09-22RAS6 | 2.262634276
9/22/2022 | 2022-09-22RAS7 | 0.867735254
9/22/2022 | 2022-09-22RAS7 | 1.320816819
9/22/2022 | 2022-09-22RAS7 | 1.412181546
9/22/2022 | 2022-09-22RAS7 | 1.454043606
9/22/2022 | 2022-09-22RAS7 | 1.454043606 |  | <---- should be 5
9/22/2022 | 2022-09-22RAS7 | 1.565383486
9/22/2022 | 2022-09-22RAS7 | 1.617393528
9/22/2022 | 2022-09-22RAS7 | 1.676241628
9/22/2022 | 2022-09-22RAS7 | 1.781893894
9/22/2022 | 2022-09-22RAS7 | 1.793072091
9/22/2022 | 2022-09-22RAS7 | 1.945533859
Spreadsheet: 780332d1652389794-sorting-by-and-displaying-items-in-a-list-based-on-multiple-criteria-calendar-draft
Sheet: 10 Events Per Day Monthly View

2022 |  | COMLEX-USA
June
Spreadsheet: darrell_schoolcraft__7322__imball0202
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 | -3 | -2142
500046 | -7907 |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134 | -15554 | -29104
500528
500529
500619
INDEX
2002-01-31 00:00:00 |  |  | -547260.79
2002-02-17 00:00:00
CBS Volume
 |  |  | -41423
Spreadsheet: 683217d1592562224-how-to-sort-columns-horizontally-according-to-their-name-now-for-google-sheets-sort
Sheet: Sheet1

 |  |  | PROD1 | PROD5 | PROD2 | PROD9 | PROD3 |  |  |  |  |  | PROD1 | PROD2 | PROD3 | PROD5 | PROD9
 |  | cal/100g | 100 | 300 | 200 | 500 | 800 |  |  |  |  | cal/100g | 100 | 200 | 800 | 300 | 500
MEAL NAME 1 | [NAME] |  | 50 | 20 | 10 | 30 | 10 |  |  | MEAL NAME 1 | [NAME] |  | 50 | 10 | 10 | 20 | 30
 | Sum kcal |  |  |  |  |  |  |  |  |  | Sum kcal
MEAL NAME 2 | [NAME] |  | 30 | 50 | 100 | 50 | 10 |  |  | MEAL NAME 2 | [NAME] |  | 30 | 100 | 10 | 50 | 50
 | Sum kcal |  |  |  |  |  |  |  |  |  | Sum kcal
MEAL NAME 3 | [NAME] |  | 10 | 10 | 10 | 10 | 10 |  |  | MEAL NAME 3 | [NAME] |  | 10 | 10 | 10 | 10 | 10
 | Sum kcal |  |  |  |  |  |  |  |  |  | Sum kcal
MEAL NAME 4 | [NAME] |  | 20 | 20 | 20 | 20 | 20 |  |  | MEAL NAME 4 | [NAME] |  | 20 | 20 | 20 | 20 | 20
 | Sum kcal |  |  |  |  |  |  |  |  |  | Sum kcal
MEAL NAME 5 | [NAME] |  | 80 | 40 | 30 | 20 | 10 |  |  | MEAL NAME 5 | [NAME] |  | 80 | 30 | 10 | 40 | 20
 | Sum kcal |  |  |  |  |  |  |  |  |  | Sum kcal
 |  |  |  |  |  |  |  |  | s
Spreadsheet: 52269d1251981674-cant-unhide-cells-and-got-hidden-formulas-personal-account
Sheet: Account

 |  |  |  |  |  | Latest Balance from Statement/online | 635.92
 |  |  |  |  |  | Amount left to reconcile: | 0
 |  |  |  |  |  | Nationwide
 |  |  |  |  |  | 2009-09-03 00:00:00
 | DATE | TYPE | ITEM # | PAYEE | CATEGORY | MEMO | DEBIT | CREDIT | C | BALANCE | 635.92
 | DATE | TYPE | ITEM # | PAYEE | CATEGORY | MEMO | DEBIT | CREDIT | c | 150 | 150
 | 2007-01-03 00:00:00 | Check | 1009 | [NAME]'s Stoves | Household | For flame-retardant cooktop | 55.71 |  | c | 94.28999999999999 | -55.71
 | 2007-01-07 00:00:00 | Check | 1010 | Doug's Barber Shop | Personal |  | 12 |  | c | 82.28999999999999 | -12
 | 2007-01-08 00:00:00 | Check | 1000 | Big Lots | Household |  | 52 |  | c | 30.28999999999999 | -52
 | 2007-01-09 00:00:00 | Check |  | [NAME] | Income - Salary | Stiffed again - Missing 6 hours |  | 631.88 | c | 662.17 | 631.88
 | 2007-01-15 00:00:00 | CkCd |  | ABC Grocery | Grocery |  | 45 |  | c | 617.17 | -45
 | 2007-02-02 00:00:00 | Deposit |  | Big Lots | Refund |  |  | 18.75 | c | 635.92 | 18.75
Spreadsheet: 831643d1685795012-i-want-to-group-some-items-from-a-table-i-have-created-s666-pq-quickmart-sales-record
Sheet: Sheet2

Item Name | Item Code | Price |  | Payment Type |  | Cashier |  | Supervisor |  | Branch
Geisha |  | 120 |  | Mpesa |  | [NAME] |  | Nyandolo |  | Kisumu
Blue band Original |  | 250 |  | Cash |  | Fabian |  | Ochuodho |  | Siaya
[NAME] 500g |  | 335 |  | Zooma |  | Virginia |  | Nera |  | Tassia
Santa Lucia Supagetti |  | 123 |  | Aitel Money |  | Aketch |  | [NAME] |  | Moi Avenue
KCC Gold Crown 500ml |  | 65 |  | [NAME] |  | Jakabondo |  | Nyauyoma |  | [NAME]
Nice&Soft Tissue 10-pack |  | 550 |  | Telkom Cash |  | Atwara |  | [NAME] |  | Eldoret
Milk Buns 200gms |  | 70 |  |  |  | [NAME] |  | Symprose |  | Mtwapa
Menengai 1kg |  | 150 |  |  |  | [NAME] |  | Esther |  | Diani
Ranee Premium Basmati 5kg |  | 1250 |  |  |  | Maathai
Tampons Original 16 super |  | 280 |  |  |  | Mboya
[NAME] 250gms |  | 197 |  |  |  | [NAME]
Downy Valley 750ml |  | 820
Hannan Flushable 72' |  | 130
[NAME] sticks 1kg Pack |  | 560
Kentaste Coconut Oil 100gms |  | 45
[NAME] |  | 174
Big Daddy Pinpop |  | 12
Axe Dark Temptation Spray 150ml |  | 368
Ilara Natural Yorghut 50ml |  | 72
White Cap Can 500ml |  | 203
Spreadsheet: 874954d1721478502-pulling-data-from-multiple-tables-across-multiple-sheets-book_test-bsb-
Sheet: CAD Corrections

CON # | INCIDENT # | NATURE | PRIORITY CODE | ADDRESS | CITY | UNIT | UNIT ASSIGNED | UNIT ON SCENE | RT: | NOTES:
 | 51208597 | 28 Stroke | A1 | 16101 N El Mirage Rd | El Mirage | WAr121 | 45444.04179398148 | 45444.05012731482 | 0.008333333338669036 | O/S 00:08:00 |  | Need to pull data from any calls that have anything other than "NA" in the notes colum across 10/15/20 Min Exception sheets and have it fill in with the data to the left of here. If the "NOTES" say NA, do not transfer that call to this table. But if it has anything else, we need the respective colums reflected.
CON136 | 51209344 | 13 Diabetic Problems | A1 | 102 S 4Th Ave | Avondale | WAr173 | 45444.04179398148 | 45444.05082175926 | 0.009027777778101154 | R/M CALL
CON136 | 51212753 | 13 Diabetic Problems | A1 | 12576 W Coronado Rd | Avondale | WAr173 | 45444.04179398148 | 45444.05359953704 | 0.0118055555576575 | CORRECTED
CON136 | 51208597 | 28 Stroke | A1 | 16101 N El Mirage Rd | El Mirage | WAr121 | 45444.04179398148 | 45444.05012731482 | 0.008333333338669036 | IFT CALL
Spreadsheet: 66666d1267316992-populating-cells-from-other-worksheets-test1
Sheet: March

March 2010 |  |  |  |  |  |  |  | Monthly Recap
Date | Product/Service | Pay Type | Amount | Category |  | No Purchases |  | Meal |  | 0
2010-03-05 00:00:00 | Verizon | credit | 55 | Bills |  |  |  | Groceries |  | 0
 |  |  |  |  |  |  |  | Accessories |  | 0
 |  |  |  |  |  |  |  | Needs |  | 0
 |  |  |  |  |  |  |  | Gas |  | 0
 |  |  |  |  |  |  |  | Misc |  | 0
 |  |  |  |  |  |  |  | Bills |  | 55
 |  |  |  |  |  |  |  | Rent/Utilities |  | 0
 |  |  |  |  |  |  |  | School |  | 0
 |  |  |  |  |  |  |  | Charity |  | 0
 |  |  |  |  |  |  |  | Gifts |  | 0
 |  |  |  |  |  |  |  | Total |  | 55
 |  |  |  |  |  |  |  | Received Money
 |  |  |  |  |  |  |  | Total Income |  | 0
 |  |  |  |  |  |  |  | Net Income for Month |  | -55
 |  |  |  |  |  |  |  | MVP Savings
Spreadsheet: darron_c_giron__8010__EMW0831a
Sheet: P&L Without Sharing

Enron Midwest P&L Without Sharing
 |  |  |  | NSS1 |  | NSS2 |  | MEH |  | TP-NSS |  | EMW Total
CURRENT BOOK VALUE
 | Physical
 |  | Physical
 |  | Other |  | 0 |  | 0 |  | 0 |  | 0
 |  | Prompt
 |  | Reversal
 |  | TOTAL
 | Financial
 |  | Price Swaps
 |  | Options
 |  | Basis
 |  | Index
 |  | Gas Daily
 |  | Gas Daily Options
 |  | Broker Fees
 |  | TOTAL
 | Omicron
 |  | Physical |  | 0 |  | 0 |  | 0 |  | 0
 |  | Financial |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL
 | Transport - Accrued
 |  | Revenue (Gas Daily Spreads)
 |  | Commodity Expense
 |  | Fuel Expense
 |  | 3rd Party Demand Charges |  | 0 |  | 0 |  | 0 |  | 0
 |  | 3rd Party Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Charges |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL
 | Transport - MTM
 |  | Revenue (Gas Daily Spreads)
 |  | Commodity Expense
 |  | Fuel Expense
 |  | 3rd Party Demand Charges |  | 0 |  | 0 |  | 0 |  | 0
 |  | 3rd Party Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Charges |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL
 | Other
 |  | People's Share of P&L |  | 0 |  | 0 |  | 0 |  | 0
 |  | Origination
 |  | Flash to Actual |  | 0 |  | 0 |  | 0 |  | 0
 |  | Origination's Share of P&L |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL
NET CURRENT MONTH P&L
DAILY CHANGE
 | Physical
 |  | Physical
 |  | Other
 |  | Prompt
 |  | Reversal
 |  | TOTAL
 | Financial
 |  | Price Swaps
 |  | Options
 |  | Basis
 |  | Index
 |  | Gas Daily
 |  | Gas Daily Options
 |  | Broker Fees
 |  | TOTAL
 | Omicron
 |  | Physical
 |  | Financial
 |  | TOTAL
 | Transport - Accrued
 |  | Revenue (Gas Daily Spreads)
 |  | Commodity Expense
 |  | Fuel Expense
 |  | 3rd Party Demand Charges
 |  | 3rd Party Demand Reimbursements
 |  | Transport Book Demand Charges
 |  | Transport Book Demand Reimbursements
 |  | TOTAL
 | Transport - MTM
 |  | Revenue (Gas Daily Spreads)
 |  | Commodity Expense
 |  | Fuel Expense
 |  | 3rd Party Demand Charges
 |  | 3rd Party Demand Reimbursements
 |  | Transport Book Demand Charges
 |  | Transport Book Demand Reimbursements
 |  | TOTAL
 | Other
 |  | People's Share of P&L
 |  | Origination
 |  | Flash to Actual
 |  | Origination's Share of P&L
 |  | TOTAL
NET DAILY CHANGE P&L
MONTH TO DATE
YEAR TO DATE
 |  |  |  | NSS1 |  | NSS2 |  | MEH |  | TP-NSS |  | EMW Total
 |  | Physical:
 |  | Curve Shift |  | 0 |  | 0 |  | 0 |  | 0
 |  | New Deals |  | 0 |  | 0 |  | 0 |  | 0
 |  | Changed Deals |  | 0 |  | 0 |  | 0 |  | 0
 |  | Trans. Reversal |  | 0
 |  | Liquidated Day
 |  | New Financial Deals:
 |  | Price
 |  | Basis
 |  | Index
 |  | Gas Daily
Spreadsheet: 693560d1599035651-averageifs-based-on-multiple-criteria-example
Sheet: Sheet1

Criteria 1 | [NAME] | Criteria 3 | [NAME] | Criteria 5 | Average
 | SMALL | 2.5 |  | Basic
 |  |  |  |  | the result should be
Data:
Criteria 1 | [NAME] | Criteria 3 | [NAME] | Criteria 5 | Total
High Price | SMALL | 2.5 | RECTANGLE | Basic | 1.2
High Price | SMALL | 2.5 | RECTANGLE | Trendy | 3.2
High Price | MEDIUM | 3.2 | RECTANGLE | Trendy | 2.5
Low Price | SMALL | 2.5 | RECTANGLE | Basic | 5.6
Low Price | SMALL | 2.5 | TRAPEZE | Trendy | 4.1
Spreadsheet: 146222d1331994369-how-do-i-convert-quantities-into-a-numbered-sequence-baseball-card-example
Sheet: Sheet1

 |  | 1969 |  |  | 1970 |  |  | 1971 |  |  | 1972 |  |  | 1973
 | Totals | Total | Start | End | Total | Start | End | Total | Start | End | Total | Start | End | Total | Start | End
[NAME] |  | 0 |  |  | 0 |  |  | 0 |  |  | 2 |  |  | 0
Dunross |  | 0 |  |  | 0 |  |  | 0 |  |  | 1 |  |  | 16
Flair |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Fleer |  | 0 |  |  | 0 |  |  | 3 |  |  | 0 |  |  | 5
Goudy |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Leaf |  | 0 |  |  | 0 |  |  | 0 |  |  | 12 |  |  | 7
Kellogg's |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Oh Pee Chee |  | 0 |  |  | 0 |  |  | 5 |  |  | 0 |  |  | 9
Pacific |  | 0 |  |  | 0 |  |  | 0 |  |  | 9 |  |  | 0
Pinnacle |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Post |  | 0 |  |  | 0 |  |  | 0 |  |  | 11 |  |  | 0
Score |  | 0 |  |  | 0 |  |  | 1 |  |  | 6 |  |  | 4
[NAME] |  | 0 |  |  | 0 |  |  | 1 |  |  | 12 |  |  | 0
Topps/OC |  | 0 |  |  | 0 |  |  | 3 |  |  | 5 |  |  | 8
[NAME] |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Other |  | 0 |  |  | 0 |  |  | 6 |  |  | 0 |  |  | 0
Spreadsheet: 883806d1732536658-looking-for-match-index-formula-test-file
Sheet: Order 2

Article number | W48, 2024 | W49, 2024 | W50, 2024 | W51, 2024 | W52, 2024 | W1, 2025 | [NAME], 2025 | W3, 2025 | W4, 2025 | W5, 2025 | W6, 2025 | W7, 2025
6645
6938
1131
1948
1854
1275
3095
2079
1987
2265
6193
760
2898
1824
5776
5109
1449
1097
4802
3149
3142
6764
2236
2438
4087
4220
4216
1216
4070
5429
4857
841
2706
748
5616
5706
2237
1876
3141
6859
3136
2739
6423
2594
2779
1253
3251
2138
3736
4080
6346
1757
5854
3302
2008
6144
6160
3398
4587
747
2576
3723
3153
4700
3191
2677
3371
6978
5609
729
4577
863
6981
1910
6023
2362
3200
1959
2737
5673
4213
1551
1738
4855
2632
5608
2758
2902
5371
6877
2729
5948
6960
1169
6091
3335
3642
4196
3705
Spreadsheet: 780285d1652373171-return-multiple-values-across-many-rows-and-columns-20210302-projects
Sheet: Lathlain St

 |  |  |  | 2019-11-29 00:00:00
 |  |  | Task | Description | Contract Amount (ex GST) | Percent Complete | Billed To Date | Previously Billed | Current Billed
 |  |  | 1 | Literature review and Gap Analysis of background documents on Lathlain Street Precinct | 7840 |  |  | 0 | 7840
 |  |  |  | Project Total
 |  |  |  |  | Subtotal of This Invoice
 |  |  |  |  | GST
 |  |  |  |  | Invoice Total (Including GST)
Spreadsheet: 156291d1337255958-waterfall-chart-problem-copy-of-waterfallchart
Sheet: WaterfallChart

 | Base | End | Down | Up | Start | Net Cash Flow
 | 5000
Start | 0 |  |  |  |  | 500
Region 1 |  |  |  |  |  | -549
Region 2 |  |  |  |  |  | -367.875
Region 3 |  |  |  |  |  | -135
Region 4 |  |  |  |  |  | 123.75
Region 5 |  |  |  |  |  | -121.5
Region 6 |  |  |  |  |  | -56.25
Region 7 |  |  |  |  |  | -49.5
Region 8 |  |  |  |  |  | -112.5
Region 9 |  |  |  |  |  | -186.75
End
 | 2000
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Heating & Air

AIR CONDITIONING AND REFRIGERATION TECHNOLOGY
Diploma - Heating, Ventilation and Air Conditioning Mechanic
Student Name:
ID #
General Education | Semester | Grade
___ Area 1 Writing/Accessing Information, Oral Communication, Humanities or [NAME] (3)
___ Area 2 Social Science, Beharvioral Science, Natural or Applied Science or Mathematics (3)
___ Area 3 CIT 105 Introduction to Computers OR IC3 Computer Literacy Exam (0-3)
Program Courses
___ ACR 100 (3) Regrigeration Fundamentals
___ ACR 101 (2) Refrigeration Fundamentals Lab
___ ACR 102 (3) HVAC Electricity AND ___ ACR 103 (2) HVAC Electricity  Lab
OR ___ Comparable Electircal Course* (4-5)
___ ACR 130 (3) Electrical Components
___ ACR 131 (2) Electrical Components Lab
___ ACR 170 (3) Heat Load/Duct Design
OR ___ ACR 209 (4) Manual and Commercial Load Calculations and Design
___ ACR 250 (3) Cooling & Dehumidification
___ ACR 251 (2) Cooling & Dehumidification Lab
___ ACR 260 (3) Heating & Humidification
___ ACR 261 (3) Heating & Humidification Lab
___ ACR 270 (3) Heat Pump Applications
___ ACR 271 (2) Heat Pump Applications Lab
OR ___ ACR 207 (5) Commercial HVAC Systems
___ Technical Electives (8-11) Approved by Program Coordinator
* Comparable Electrical Courses
___ EET 154 (2) Electrical Construction AND EET 155 Electrical Construction Lab (2)
OR ___ ETT 112 (3) Basic Electrical Theory: Telenetworking
AND ETT 113 (1) Basic Electrical Theory Lab
OR ___ ELT 110 (5) Circuits I
OR ___ IMT 110 (3) Industrial Maintenance Electrical Principles
AND ___ IMT 111 (2) Industrial Maintanance Electrical [NAME]
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 164211d1340693174-sum-over-overlapping-arrays-sumoverlappingarrays4
Sheet: Tabelle1

 | Input: Several arrays
Product1 | Period_i | Period_i+1 | Period_i+2
ProdCenterA | 1 | 2 | 4
ProdCenterB | 2 | 2 | 3
ProdCenterC | 3 | 2 | 1
ProdCenterD | 4 | 5 | 1
Product2
ProdCenterA | 3 | 5 | 4
ProdCenterB | 4 | 4 | 8
ProdCenterC | 3 | 1 | 1
ProdCenterD | 1 | 3 | 2
Product3
ProdCenterA | 6 | 4 | 7
ProdCenterB | 8 | 4 | 7
ProdCenterC | 5 | 4 | 5
ProdCenterD | 6 | 7 | 1
 | And the planning table (which says how many of the different tables to insert in each week)
 | [NAME] | Period_2 | Period_3 | Period_4
Product1 | 1
Product2 | 2 | 1
Product3 |  |  | 1 | 2
 | Output I'm looking for: "Overlapping sum of these arrays"
 | [NAME] | Period_2 | Period_3 | Period_4 | Period_5
ProdCenterA | 7 | 15 | 23 | 20 | 15 | 14
ProdCenterB | 10 | 14 | 31 | 28 | 15 | 14
ProdCenterC | 9 | 7 | 9 | 15 | 13 | 10
ProdCenterD | 6 | 12 | 14 | 21 | 15 | 2