tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 874633d1721199857-query-that-shows-only-the-following-day-and-after-date_after
Sheet: Sheet1

Column1 |  |  |  | [NAME]
2024-07-17 00:00:00 |  |  |  | 2024-07-18 00:00:00
2024-07-18 00:00:00 |  |  |  | 2024-07-19 00:00:00
2024-07-19 00:00:00 |  |  |  | 2024-07-20 00:00:00
2024-07-20 00:00:00 |  |  |  | 2024-07-21 00:00:00
2024-07-21 00:00:00 |  |  |  | 2024-07-22 00:00:00
2024-07-22 00:00:00 |  |  |  | 2024-07-23 00:00:00
2024-07-23 00:00:00 |  |  |  | 2024-07-24 00:00:00
2024-07-24 00:00:00 |  |  |  | 2024-07-25 00:00:00
2024-07-25 00:00:00 |  |  |  | 2024-07-26 00:00:00
2024-07-26 00:00:00 |  |  |  | 2024-07-27 00:00:00
2024-07-27 00:00:00 |  |  |  | 2024-07-28 00:00:00
2024-07-28 00:00:00 |  |  |  | 2024-07-29 00:00:00
2024-07-29 00:00:00 |  |  |  | 2024-07-30 00:00:00
2024-07-30 00:00:00 |  |  |  | 2024-07-31 00:00:00
2024-07-31 00:00:00 |  |  |  | 2024-08-01 00:00:00
2024-08-01 00:00:00 |  |  |  | 2024-08-02 00:00:00
2024-08-02 00:00:00 |  |  |  | 2024-08-03 00:00:00
2024-08-03 00:00:00 |  |  |  | 2024-08-04 00:00:00
2024-08-04 00:00:00 |  |  |  | 2024-08-05 00:00:00
2024-08-05 00:00:00 |  |  |  | 2024-08-06 00:00:00
2024-08-06 00:00:00 |  |  |  | 2024-08-07 00:00:00
2024-08-07 00:00:00
Spreadsheet: 120905d1315622745-cell-reads-other-cells-from-another-sheet-nfl-football-schedule-2011-2012-testing-
Sheet: Week 1

Thursday, September 8, 2011
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
New Orleans Saints | 7 | 10 | 10 | 7
Green Bay Packers | 21 | 7 | 7 | 7
Sunday, September 11, 2011
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Atlanta Falcons
Chicago Bears
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Cincinnati Bengals
[NAME]
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Buffalo Bills
Kansas City Chiefs
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Philadelphia Eagles
St. Louis Rams
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Detroit Lions
Tampa Bay Buccaneers
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Tennessee Titans
[NAME]
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Pittsburgh Steelers
Baltimore Ravens
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Indianapolis Colts
Houston Texans
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
New York Giants
Washington Redskins
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
[NAME]
San Francisco 49ers
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Minnesota Vikings
San Diego Chargers
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Carolina Panthers
Arizona Cardinals
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Dallas Cowboys
New York Jets
Monday, September 12, 2011
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
New England Patriots
[NAME]
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Oakland Raiders
Denver Broncos
Spreadsheet: 469329d1467880308-formula-performed-across-all-columns-to-return-value-in-a-single-cell-example
Sheet: Sheet1

Value 1 | 0.04916192223360078 | 0.07682386895645682 | 0.07066720239174672 | 0.1353329771198827 | 0.0651721452667318
Value 2 | 2 | 2 | 2 | 2 | 2
Account 1 | 320.06 | 721.16 | 2039.59 | 579.43 | 18363.99
Account 2 | 2807.49 | 5207.269999999999 | 19492.33000000001 | 3658.629999999998 | 48323.85999999999
Spreadsheet: 41211d1239720569-countif-with-multiple-conditions-help_count
Sheet: Graphs

SINGLE
 |  | MPCOUNT = P
 | 2006-01-01 00:00:00 |  | 2007-01-01 00:00:00 |  | 2008-01-01 00:00:00
 | # Pj | # of PM | # Pj | # of PM | # Pj | # of PM
LARGE | 2 | 2 | 1 | 1 | 1 | 1 | 4 | 4
MEDIUM | 3 | 3 | 1 | 1 | 2 | 2 | 6 | 6
SMALL | 14 | 8 | 11 | 8 | 10 | 7 | 35 | 23
TOTAL | 19 | 13 | 13 | 10 | 13 | 10 | 45 | 33
MULTI
 | 2006-01-01 00:00:00 |  | 2007-01-01 00:00:00 |  | 2008-01-01 00:00:00
 | # Pj | # of PM | # Pj | # of PM | # Pj | # of PM
LARGE | 3 | 3 | 2 | 2 | 3 | 3 | 8 | 8
MEDIUM | 0 | 0 | 6 | 5 | 4 | 3 | 10 | 8
SMALL | 3 | 2 | 3 | 2 | 6 | 4 | 12 | 8
[NAME] | 6 | 5 | 11 | 9 | 13 | 10 | 30 | 24
 |  |  |  |  |  |  | 75
Note:
Large    > 15000 MH
Medium > 5000 MH
Small    > 400 MH
Spreadsheet: lisa_gang__22417__Hanson Scheduling Model_5_2
Sheet: Scheduling

 |  |  |  |  | HANSON PERMANENTE CEMENT
 |  |  |  |  |  | Power Usage Forecast
 | CALIFORNIA SCHEDULING COORDINATION AND
 | ENERGY PURCHASES AND SALES AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday: Tuesday Scheduling
 | Day of Scheduling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday: Wednesday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday: Thursday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday: Friday & Saturday Scheduling
 | 2002-05-02 00:00:00 | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | Total |  |  |  |  |  |  |  |  | Friday: Sunday and Monday LLH Scheduling
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  |  |  |  |  |  |  | Friday: Monday HLH
 |  | 30.336 | 29.472 | 30.516 | 30.708 | 30.936 | 30.876 | 30.972 | 30.984 | 30.768 | 30.276 | 30.072 | 30.024 | 20.244 | 16.128 | 15.648 | 15.264 | 15.216 | 15.276 | 15.252 | 15.096 | 15.636 | 15.48 | 15.132 | 15.3 |  |  |  |  |  |  |  |  |  | Holiday
 |  | 31.19023590669259 | 31.19023590669259 | 31.19023590669259 | 31.19023590669259 | 31.94023590669259 | 31.94023590669259 | 32.14023590669259 | 32.14023590669259 | 32.14023590669259 | 32.14023590669259 | 32.14023590669259 | 32.14023590669259 | 30.61523590669259 | 30.61523590669259 | 31.36523590669259 | 30.48523590669259 | 30.48523590669259 | 30.48523590669259 | 31.06023590669259 | 31.06023590669259 | 31.94023590669259 | 31.94023590669259 | 31.19023590669259 | 31.19023590669259
 | Day Ahead Incremental Quantity (Hanson needs to purchase)
 | Day Ahead Decremental Quantity (Hanson needs to sell)
 | Contact Persons
 | EPMI | Telephone |  |  | E-Mail
 | [NAME] | 503/464-3829 |  |  | [EMAIL]
 | [NAME] | 503/464-5053 |  |  | [EMAIL]
 | [NAME] | 503/464-3822 |  |  | [EMAIL]
 | [NAME] | 503/464-3824 |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
 | Hanson | Telephone |  |  | E-Mail
 | [NAME] Manager | [PHONE] |  |  | [EMAIL]
 | [NAME] Engineer | [PHONE] |  |  | [EMAIL]
 | [NAME]  - VP Operations | [PHONE] |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
Spreadsheet: 795661d1662824372-populating-a-team-game-log-from-a-master-schedule-game-schedule-and-log-tim418-
Sheet: Schedule

Date | W | L | Winner Runs Scored | Winner Runs Allowed | [NAME] | [NAME]
19770406 | SDN | CIN | 3 | 1 | 1 | 3
19770406 | CAL | SEA | 7 | 4 | 4 | 7
19770407 | BAL | TEX | 3 | 0 | 0 | 3
19770407 | BOS | CLE | 4 | 3 | 3 | 4
19770407 | NYN | CHN | 6 | 5 | 5 | 6
19770407 | KCA | DET | 12 | 1 | 1 | 12
19770407 | LAN | SFN | 9 | 8 | 8 | 9
19770407 | MIL | NYA | 5 | 3 | 3 | 5
19770407 | PIT | SLN | 6 | 4 | 4 | 6
19770407 | SEA | CAL | 10 | 6 | 6 | 10
19770407 | CHA | TOR | 6 | 4 | 4 | 6
19770408 | SDN | CIN | 3 | 0 | 0 | 3
19770408 | HOU | ATL | 6 | 2 | 2 | 6
19770408 | SEA | CAL | 8 | 4 | 4 | 8
19770409 | BAL | TEX | 7 | 0 | 0 | 7
19770409 | CHN | NYN | 3 | 0 | 0 | 3
19770409 | CIN | SDN | 4 | 3 | 3 | 4
19770409 | KCA | DET | 9 | 1 | 1 | 9
19770409 | ATL | HOU | 4 | 3 | 3 | 4
Spreadsheet: 10d7765e-d7e1-41d0-a7fd-4f9814dc03f9
Sheet: 7X

[NAME], 12,500-23,999  GVWR, 2-WHEEL DRIVE ([NAME])
Vehicles with capital values greater than $75K will receive a unique rate; please contact FSR for details
 | Equip. | Federal | 2014 Monthly | 2014 Mileage
Vehicle Description | Code | Std. Item(s) | Rate | Rate
Chassis & Cab, 2-Door | 7100 | 74B, 74F, 74H | 297 | 0.4
Chassis & Cab, 2-Door | 7101 | 95B | 273 | 0.6
Chassis & Cab, 2-Door | 7102 | 95C | 290 | 0.4
Chassis & Cab, 2-Door | 7109 | 75B | 216 | 0.42
Chassis & Cab, 2-Door | 7110 | 74D, 74G, 74J | 318 | 0.45
Chassis & Cab, 2-Door | 7120 | 414 | 352 | 0.515
Stake [NAME], 2-Door | 7200 | 124B | 297 | 0.39
Stake [NAME], 2-Door | 7210 | 124D | 318 | 0.44
Stake [NAME], 2-Door | 7220 | 434, 434Z | 352 | 0.505
Stake Dump | 7300 | 124F, 124H, 124J | 297 | 0.4
Stake Dump | 7310 | 124G | 342 | 0.45
Delivery Van, Cut-off Cab | 7400 | 94B, 94H | 297 | 0.4
Delivery Van, Cut-off Cab | 7420 | 474, 474Z | 379 | 0.54
Van, Refrigerated, with [NAME] | 7520 | 484, 484Z | 503 | 0.58
Service Utility, with [NAME] | 7600 | 84B, 144A | 297 | 0.4
Multistop Van (FC) Truck | 7700 | 134B, 134F, 134H | 297 | 0.4
Dump Truck | 7800 | 154B | 297 | 0.4
Dump Truck | 7810 | 154H | 342 | 0.45
Dump Truck | 7820 | 444 | 379 | 0.54
[NAME], 12,500-23,999  GVWR, ALL-WHEEL DRIVE (4X4)
 | Equip. | Federal | 2014 Monthly | 2014 Mileage
Vehicle Description | Code | Std. Item(s) | Rate | Rate
4X4 Pickup, [NAME] | 7103 | 59B | 273 | 0.4
Chassis & Cab, 2-Door | 7104 | 79B | 305 | 0.41
Chassis and [NAME] | 7105 | 79D | 311 | 0.41
Chassis & Cab, [NAME] | 7108 | 79H | 301 | 0.42
Chassis & Cab, 2-Door | 7114 | 79F | 327 | 0.445
Chassis and [NAME] | 7115 | 79G | 332 | 0.445
Chassis & Cab, [NAME] | 7119 | 79J | 308 | 0.42
Stake [NAME], 2-Door | 7204 | 129A | 305 | 0.4
Stake [NAME], 2-Door | 7214 | 129B | 327 | 0.44
Stake [NAME], [NAME] | 7215 | 129F, 129H, 129J | 345 | 0.44
Service Utility, with [NAME] | 7604 | 89B, 149A | 371 | 0.45
Service Utility, with [NAME] | 7610 | 84D, 84H, 84J, 144B | 342 | 0.45
Service Utility, with [NAME] | 7614 | 89D, 89H, 89J, 149B | 399 | 0.505
Dump Truck | 7804 | 159A | 371 | 0.45
Dump Truck | 7814 | 159H | 399 | 0.505
Spreadsheet: 878499d1725602152-time-series-closing-bank-balance-bank-balances
Sheet: Sheet1

Balance | Date |  |  |  |  | 2024-08-20 00:00:00
100283 | 2024-08-24 00:00:00 |  |  |  |  | 2024-08-21 00:00:00
101599 | 2024-08-24 00:00:00 |  |  |  |  | 2024-08-22 00:00:00 | 0 | if no balance, is it possible to take prior one?
102527 | 2024-08-23 00:00:00 |  |  |  |  | 2024-08-23 00:00:00
103111 | 2024-08-23 00:00:00 |  |  |  |  | 2024-08-24 00:00:00
104210 | 2024-08-23 00:00:00
104333 | 2024-08-21 00:00:00
104750 | 2024-08-21 00:00:00 |  |  |  |  | 2024-08-20 00:00:00
104900 | 2024-08-20 00:00:00 |  |  |  |  | 2024-08-21 00:00:00
105300 | 2024-08-20 00:00:00 |  |  |  |  | 2024-08-22 00:00:00
105100 | 2024-08-20 00:00:00 |  |  |  |  | 2024-08-23 00:00:00
 |  |  |  |  |  | 2024-08-24 00:00:00
Spreadsheet: 01ed928d-5fe4-486b-ad2f-e95a46266d9b
Sheet: $ mono by vendor

Monograph Expenditures by Vendor FY10 and FY11
Library | Code | Vendor | FY10 | FY11 | % change | % of total FY11
[NAME] | nbh | PELL BookHouse | 0 | 569.59 | N/A
[NAME] | nksb | PELL Koeltz Scientific Books | 317.39 | 227.42
[NAME] | nmsi | PELL Marine Science Institute | 87.5 | 0
[NAME] | nmts | MARINE TECHNOLOGY SOCIETY | 80 | 0
URI | none | [NAME]. media vendors | 29477.24 | 26984.13
URI | uaca | Academic Book Center | 0 | 188 | N/A
URI | uanp | American Nurses Publishing | 86.05 | 103.9
URI | ubwa | Blackwell North America, Inc. | 0 | 0 | 0
URI | ubws | Blackwell North America, Inc. | 15.25 | 0
URI | ucas | [NAME] | 487.75 | 158.61
URI | uebc | Eastern Book Company | 83078.44 | 100761.67
URI | ufac | Facets Multimedia, Inc. | 260.02 | 29.95
URI | uffh | Films for the Humanities | 0 | 0 | 0
URI | ufro | T Front Musical Literature, Inc. | 817.56 | 0
URI | uhar | HARRASSOWITZ | 738.69 | 553.02
URI | [NAME] | HELIN (books through YBP approval pilot) | 0 | 179.74 | 0
URI | uibb | IBERBOOK International, S.L. | 902.16 | 107.25
URI | uneu | Neuwerk Buch & Musikalienhandlun GMBH | 0 | 0 | 0
URI | upbs | PBS VIDEO | 480.34 | 104.23
URI | ustr | [NAME] | 149544.95 | 103007.2
URI | uvisa | [NAME] (Amazon & other orders by [NAME]) | 0 | 2722.61 | N/A
URI | uybp | Yankee Book Peddler | 93097.88 | 109334.97
URI | uybp1 | Yankee Book Peddler | 2205.72 | 2121.32
CCE | xbnt | CCE Baker & Taylor | 0 | 0 | 0
CCE | xcqp | CCE CongressQuart | 400.7 | 187.85
CCE | xdust | CCE dustbooks | 46.95 | 0
CCE | ximf | CCE IMF | 54 | 0
 |  | TOTAL
Spreadsheet: 835300d1688486635-index-small-failed-to-replicate-example-index-small
Sheet: Sheet2

 | Movie | [NAME] | Actor | Release
 | Prisoners | Thriller | [NAME] | 2013 |  |  | [NAME] | Action
 | The [NAME] | Mystery | Christian Bale | 2006 |  |  | Actor | [NAME]
 | Logan | Action | [NAME] | 2017 |  |  | Movie
 | The Dark Knight | Action | Christian Bale | 2008
 | Inception | Action | [NAME] | 2010
 | Public Enemies | Action | [NAME] | 2009
 | The Machinist | Thriller | Christian Bale | 2004
 | The Tourist | Action | [NAME] | 2010
 | Catch Me If You Can | Thriller | [NAME] | 2002
 | The Wolverine | Action | [NAME] | 2013
 | Shutter Island | Thriller | [NAME] | 2010
 | Secret Window | Thriller | [NAME] | 2004
 | Real Steel | Action | [NAME] | 2011
 | The Dark Knight Rises | Thriller | Christian Bale | 2012
 | The Ninth Gate | Thriller | [NAME] | 1999
 | The Departed | Thriller | [NAME] | 2006
 | Website: | https://www.exceldemy.com/excel-extract-data-from-table-based-on-multiple-criteria/#I_Using_INDEX-MATCH_Array_Formula
Spreadsheet: 859958d1708181876-multi-return-lookup-from-2d-array-2d-multi-return-lookup-ans
Sheet: Sheet1

Fruit |  | Part of which combos? |  |  |  |  | Part of which combos?
Apple |  |  | Orange treats |  |  |  | Red bounty | Orange treats
[NAME] |  | Yellow bonanza |  |  |  |  | Yellow bonanza
Jujubees |  | Red bounty | Yellow bonanza | Orange treats |  |  | Red bounty | Yellow bonanza | Orange treats
Blueberries |  |  |  |  |  |  | ^A formula that looks up a fruit in the "combo ingredients" array and returns all Combos which have that Fruit.
Peach |  | Orange treats
[NAME] |  | Red bounty
Tomato |  | Red bounty
Lemon |  | Yellow bonanza
Orange |  | Orange treats
Combos |  | Combo ingredients
Red bounty |  | Apple | Tomato | Jujubees | [NAME]
Yellow bonanza |  | [NAME] | Jujubees | Lemon
Orange treats |  | Apple | Peach | Orange | Jujubees
Spreadsheet: 122652d1317047095-multiple-transpose-function-from-rows-into-columns-book1
Sheet: Sheet1

1 | LA1
1 | LA2
1 | LA3
1 | LA4
1 | LA5
2 | LB1
2 | LB2
2 | LB3
2 | LB4
2 | LB5
3 | LC1
3 | LC2
3 | LC4
3 | LC3
Spreadsheet: 011a9848-60fc-448f-8e5d-aed638b30857
Sheet: Sheet1

Table 5--U.S. and world fiber prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Mar. | Apr. | May | May
Item | 2012 | 2012 | 2012 | 2011
 | Cents per pound
Domestic cotton prices:
Adjusted world price | 78.11 | 78.34 | 68.75 | 147.31
Upland spot 41-34 | 83.14 | 83.37 | 72.51 | 151.93
Pima spot 03-46 | 129.5 | 127 | 123.55 | 247
Average price received by
upland producers | 90.2 | 90.9 | 95.1 | 80.3
Far Eastern cotton quotes:
A Index | 99.72 | 99.33 | 87.95 | 167.26
Memphis/Eastern | 101.9 | 102.13 | 90.85 | 180
Memphis/Orleans/Texas | 101.55 | 102.13 | 90.85 | 177.13
California/Arizona | 106.1 | 103.5 | 91.35 | NQ
 | Dollars per pound
Wool prices (clean):
U.S. 56s | NQ | NQ | NQ | 3.4
Australian 56s 1/ | 4.04 | 4.11 | 4.24 | 4.27
U.S. 60s | NQ | NQ | NQ | 4.36
Australian 60s 1/ | 7.72 | 6.03 | 6.29 | 8.28
U.S. 64s | NQ | NQ | NQ | 5.16
Australian 64s 1/ | 6.68 | 6.35 | 6.07 | 6.43
NQ = No quote.
1/  In bond, Charleston, SC.
Last update:  6/13/12.
Sources: USDA, Cotton Price Statistics; Cotlook Ltd., [NAME];
and trade reports.
Spreadsheet: 174978d1345281589-substitution-of-values-new-microsoft-office-excel-worksheet
Sheet: Sheet1

Input |  |  | Input
1 |  |  | A
2 |  |  | B
3 |  |  | C
 |  |  |  |  |  | RMG-1 | ADV LDS
 |  |  |  |  |  | RMG-26 | MOV
 |  |  |  |  |  | WT-6 | CARGO
 |  |  |  |  |  | RMG-48 | MOB
 |  |  |  |  |  | RMG-60 | DEMOB
 |  |  |  |  |  | RMG-94
 |  |  |  |  |  | RMG-98
 |  |  |  | RMG-1 | 1 |  | ADV LDS | A
 |  |  |  | RMG-26 | 2 |  | MOV | B
 |  |  |  | WT-6 | 3 |  | CARGO | C
 |  |  |  | RMG-48 | 4 |  | MOB | D
 |  |  |  | RMG-60 | 5 |  | DEMOB | E
 |  |  |  | RMG-94 | 6
 |  |  |  | RMG-98 | 7
Spreadsheet: 828365d1683453263-outputting-contents-of-a-cell-with-multiple-inputs-example-testing-aligw
Sheet: Sheet1

Date of match | Match and scoreline |  |  | Inputs |  |  |  | Outputs
2018-01-01 00:00:00 | Cincinnati Cats 3-0 Dallas Dogs |  |  | Team 1 | Team 2 |  |  |  | Cincinnati Cats 3-0 Dallas Dogs
2018-01-07 00:00:00 | Cincinnati Cats 2-3 Saudi Squirrels |  |  | Cats | Dogs |  |  | 2018-01-24 00:00:00 | Cincinnati Cats 1-3 Dallas Dogs
2018-01-12 00:00:00 | Dallas Dogs 1-3 Saudi Squirrels |  |  |  |  |  |  | 2018-02-05 00:00:00 | Cincinnati Cats 3-2 Dallas Dogs
2018-01-24 00:00:00 | Cincinnati Cats 1-3 Dallas Dogs
2018-01-31 00:00:00 | Dallas Dogs 3-2 Saudi Squirrels
2018-02-05 00:00:00 | Cincinnati Cats 3-2 Dallas Dogs
Spreadsheet: 97107d1296316291-file-size-increased-and-slow-after-formulas-and-conditional-formatting-test12
Sheet: Sheet2

NAME | ID | Milestone1 | Milestone2 | Milestone3 | Milestone4 | Milestone5 | Milestone6 | Milestone7
A | A1 | C
B | B1 |  |  |  |  |  |  |  |  |  | -if the actual column of any milestone is date then I would get blue
C | C1 | S |  |  |  |  |  |  |  |  | - if the actual column of any milestone is P then Yellow
D | D1 |  |  |  |  |  |  |  |  |  | - if the actual column of any milestone is S then Red
E | E1 | P
Spreadsheet: 698807d1602184055-need-help-with-a-formula-i-cant-figure-out-example-sheet
Sheet: CAT

Date | Serial Number | INSPECTOR | INSPECTOR 2              (IF ANY) | Contorl Test Y/N | Job complied with | Number of Observations | FINDINGS
2020-09-29 00:00:00 | CAT117 |  |  | NO | HW6 | 86 | 4 | <--Example this row has 4 findings and is HW6 so I would like it to transfer certain data (Date, Serial Number, Job Complied with, and findingsover to the Weld defects sheet.
2020-10-02 00:00:00 | CAT118 |  |  | NO | Final | 1798 | 2
2020-10-04 00:00:00 | CAT120 |  |  | NO | HW10 | 322 | 0
2020-10-05 00:00:00 | CAT184 |  |  | NO | Drive | 33 | 2
2020-10-05 00:00:00 | CAT119 |  |  | NO | Paint and Processing | 7 | 7
2020-10-05 00:00:00 | CAT118 |  |  | NO | HW10 Turnover | 52 | 8
2020-10-05 00:00:00 | CAT119 |  |  | NO | Final | 1798 | 2
2020-10-07 00:00:00 | CAT118 |  |  | NO | HW3 |  | 1
 |  |  |  | NO
Spreadsheet: 168635d1342530200-interval-pricing-of-volumes-using-if-formula-book1
Sheet: Sheet1

 | Volume | Value |  | Rate | Intervals
2012-01-01 00:00:00 | 15000 |  |  | 3 | 0 to 80,000 Tonnes
2012-02-01 00:00:00 | 16000 |  |  | 4 | 80,000 to 120,000 Tonnes
2012-03-03 00:00:00 | 17000 |  |  | 5 | 120,001 to 240,000 Tonnes
2012-04-03 00:00:00 | 18000 |  |  | 6 | 240,001 to 400,000 Tonnes
2012-05-04 00:00:00 | 19000
2012-06-04 00:00:00 | 20000
2012-07-05 00:00:00 | 21000
2012-08-05 00:00:00 | 22000
2012-09-05 00:00:00 | 23000
2012-10-06 00:00:00 | 24000
2012-11-06 00:00:00 | 25000
2012-12-07 00:00:00 | 26000
Spreadsheet: 97629d1296753401-cross-sheet-calc-that-would-omit-0-possible-solution-but-am-getting-a-ref-error-2011trending
Sheet: 0120

01/20/11  Performance Data
 |  | 1st Work |  |  |  | QC |  |  | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT SURNOTACKL MNBENMMIG SURDTHCERT | SURBENCSMG SURFRM SURVALDOD SURCUSFLUP SURSPLIGO SRSPNIGO SURBENSPLT RAIDPS RAIDNP/TAIDIN-IA FAID/FAIDWF IAID/FAIDCO SURINQ | SURBENRSCH SURBENUPDT RAIDPB RAIDAR | SURBENLEGL SURPAYLNPO | MNTBENMMIG SURSPLIGO SURSPNIGO SURBENSPLT RAIDPS FAID | SURBENRSCH (PASS) SURBENUPDT (PASS/FAIL) RAIDPB RAIDAR | SURBENRSCH (FAIL)
 |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint | 7 |  | 9 |  |  |  |  | 86 | 3 | reporting/cap mgmt | 5 | 17.2
 | Dustin | 1 |  | 5 |  |  |  |  | 42 | 5 | trending/cap mgmt | 2.5 | 16.8
 | Sharron | 4 | 14 | 14 |  |  |  |  | 162 |  |  | 9.75 | 16.61538461538462
 | Roxy | 4 | 14 | 13 |  |  |  |  | 154 | 2 |  | 5.75 | 26.78260869565218
 | [NAME] | 5 |  | 1 |  | 1 | 10 |  | 100 |  |  | 8.25 | 12.12121212121212
 | Ana | 26 | 7 | 10 |  |  |  |  | 153 |  |  | 8 | 19.125
 |  |  |  |  |  |  |  |  | 0
 | [NAME] | 3 | 28 | 5 |  |  |  |  | 130 | 1 |  | 8 | 16.25
 | Petra | 2 | 1 | 2 |  | 4 | 8 | 3 | 119 | 4.5 | training | 8 | 14.875
 | Regina |  |  |  |  |  | 11 |  | 88 | 0.5 |  | 5.25 | 16.76190476190476
 | Noy |  |  |  |  |  | 12 | 1 | 104 | 1.5 |  | 6.75 | 15.40740740740741
 | [NAME] |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | [NAME] |  |  |  |  |  |  |  | 0.01 |  | SME | 0.01 | 1
 | Michelle | 33 |  |  |  |  |  |  | 66 |  | SME | 3 | 22
 | Keisha |  | 16 | 8 |  |  |  |  | 112 | 1 | resrch | 9.25 | 12.10810810810811
 | [NAME] | 1 | 34 | 1 |  |  |  |  | 112 | 3 | da training | 7.5 | 14.93333333333333
TEAM TOTALS | Pts Earned: | 2 | 3 | 8 | 12 | 2 | 8 | 8 |  |  |  |  | 208.0466257096692
 | TASK VOLUME: | 86 | 114 | 68 | 0 | 5 | 41 | 4 | 1428 | 21.5 |  | 87.02000000000001 | 16.41002068490002
 | Pts Earned: | 172 | 342 | 544 | 0 | 10 | 328 | 32
 |  |  |  |  |  |  |  | Average PTS | 89.25125 |  | Total Task Volume |  | 318
 | MID-DAY PPH  15.78
Spreadsheet: 268429d1380634701-nested-ifs-complex-if-test
Sheet: Sheet1

 |  | RRP | Cost Price | Margin % | Cost for carriage
Car | 1 | 134.95 | 67.84020000000001 |  |  |  |  | Cost Per Item < > |  | Cost for Deleivery
Book | 1 | 129.95 | 88.27080000000001 |  |  |  |  | 0 | 20 | 0
Bike | 1 | 149.95 | 97.8894 |  |  |  |  | 20.01 | 100 | 10
Bear | 1 | 51.95 | 22.44 |  |  |  |  | 100.01 | 200 | 20
Doll | 1 | 169.95 | 100 |  |  |  |  | 200.01 |  | 30
Train | 1 | 249.95 | 169.7076
Marbels | 1 | 189.95 | 126.3372
Plane | 2 | 55.95 | 28.407
Rocket | 1 | 199.99 | 156.264
Spreadsheet: 542894d1508158510-classroom-problem-sums-of-rows-with-overlapping-timeslots-overlapping-courses-part-2
Sheet: Sheet3

Start Time | End Time |  | School A | School B | School C | School D | School E | Totals: |  | How Many Time Slots Overlap? | How Many Classes Overlap? |  | Courses Started | Courses Ended | Courses in Session at Start
16:50:00 | 18:50:00 |  | 14 | 0 | 0 | 0 | 0
17:30:00 | 19:20:00 |  |  | 8 | 0 | 0 | 0
17:45:00 | 19:45:00 |  | 0 | 0 | 17 |  | 0
18:00:00 | 20:45:00 |  |  |  |  | 20 | 3
18:30:00 | 20:30:00 |  | 0 | 0 | 0 | 1 | 0
19:00:00 | 21:00:00 |  | 15 |  | 0 | 0 | 0
19:30:00 | 21:20:00 |  | 0 | 7 | 0 | 0
20:00:00 | 22:00:00 |  | 0 | 0 | 10 | 0
20:55:00 | 22:10:00 |  |  |  |  |  | 3 | 3