tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 783221d1654676808-count-distinct-multiple-conditions-and-time-range-rdt_01042022
Sheet: breakdown

DATE | HOUR | START_TIME | END_TIME | [NAME] | RDT_USER_COUNT_2021 | RDT_UNITS_COUNT_2021
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | SPORT
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | RIDING
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | ACCESSORY
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | CAMPING
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | CARAVANS
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | ROD
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | FISHING
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | TENT
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | HAZ
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | TRAVEL
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | CLIMBING
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | CYCLING
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | TEXTILE
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | RUCKSACK
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | FOOTWEAR
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | FOOD
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | BIKE
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | HOT
2021-01-01 00:00:00 | HH01 | 00:00:01 | 00:59:59 | MAP
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | SPORT
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | RIDING
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | ACCESSORY
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | CAMPING
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | CARAVANS
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | ROD
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | FISHING
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | TENT
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | HAZ
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | TRAVEL
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | CLIMBING
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | CYCLING
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | TEXTILE
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | RUCKSACK
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | FOOTWEAR
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | FOOD
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | BIKE
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | HOT
2021-01-01 00:00:00 | HH02 | 01:00:00 | 01:59:59 | MAP
2021-01-01 00:00:00 | HH03 | 02:00:00 | 02:59:59 | SPORT
2021-01-01 00:00:00 | HH03 | 02:00:00 | 02:59:59 | RIDING
2021-01-01 00:00:00 | HH03 | 02:00:00 | 02:59:59 | ACCESSORY
Spreadsheet: 64281d1265148450-multiple-workbook-vlookup-formula-iam2
Sheet: Sheet1

ID | Age | Name | Surname
GBRX11 | 34 | [NAME] | [NAME]
GBRXKT | 43 | Barnes | [NAME]
[NAME] | 45 | Burroughs | [NAME]
GBRXV3 | 23 | Calderhead | [NAME]
GBRY2A | 56 | chamberlain | [NAME]
GBRSML | 56 | [NAME] | Jenifer
GBVE5Z | 87 | [NAME] | [NAME]
GBRUDY | 56 | Coles | [NAME]
GBRZ89 | 34 | Corner | Philippa
[NAME] | 43 | Davies | Sophie
GBVAQ6 | 45 | Davies | Kerry
GBRDKP | 34 | [NAME] | martin
GBVARE | 56 | [NAME] | Mark
GBVAQ9 | 87 | Ekins | Swatee
GBVAQX | 56 | [NAME] | Nicola
GBVAQZ | 56 | Green | [NAME]
GBRLLG | 45 | [NAME] | [NAME]
GBVCA5 | 43 | [NAME] | Helen
GBRIG7 | 43 | Santos | Nick
GBVC1K | 34 | Santos | [NAME]
GBRSC2 | 87 | [NAME] | Scott
GBVCSY | 45 | [NAME] | [NAME]
GBRCT1 | 56 | [NAME] | Philippa
GBVARC | 34 | [NAME] | [NAME]
Spreadsheet: 96178d1295594554-show-data-in-sequence-row-groupautolist
Sheet: Sheet2

SELECT GROUP | GROUP1 |  |  | Select Group | GroupNum | << Does making it a list and auto filter work?
NAME | START | FINISH |  | A | GROUP1
 |  |  |  | B | [NAME]
 |  |  |  | C | GROUP3
 |  |  |  | D | GROUP3
 |  |  |  | F | GROUP3
 |  |  |  | G | GROUP3
 |  |  |  | H | [NAME]
 |  |  |  | I | [NAME]
 |  |  |  | J | [NAME]
 |  |  |  | K | [NAME]
 |  |  |  | L | [NAME]
M |  |  |  | M | GROUP1
N |  |  |  | N | GROUP1
Spreadsheet: 04762504-4d66-453c-bd04-2768a73b646c
Sheet: Sheet1

CITY OF STEAMBOAT SPRINGS UTILITIES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | revised 01/04/13 - new rates | Unnamed: 6
PLANT INVESTMENT FEE CALCULATION FORM 2013 |  |  |  |  | revised 01/04/13 - new meter prices
FORM  NUMBER:
DATE: |  |  |  |  | Building Permit #
NAME OF APPLICANT:
MAILING ADDRESS:
PHONE:
PROPERTY ADDRESS:
LOCATOR KEY:
DESCRIBE USE:
 | DRAFT: FOR ESTIMATES ONLY
 | QUANTITY |  | POINTS |  | WATER | WASTE WATER
[NAME] |  | x | 0.008 | = | 0 | 0
TOILETS & URINALS PRIVATE |  | x | 8.1 | = | 0 | 0
TOILETS & URINALS PUBLIC |  | x | 16.2 | = | 0 | 0
SINKS - PRIVATE |  | x | 2.5 | = | 0 | 0
SINKS - PUBLIC |  | x | 5 | = | 0 | 0
SINKS - COMMERCIAL |  | x | 15 | = | 0 | 0
TUB AND/OR SHOWER - PRIVATE |  | x | 14.3 | = | 0 | 0
TUB AND/OR SHOWER - PUBLIC |  | x | 28.6 | = | 0 | 0
WASHING MACHINE - PRIVATE |  | x | 10 | = | 0 | 0
WASHING MACHINE - PUBLIC |  | x | 22 | = | 0 | 0
WASHING MACHINE - COMMERCIAL |  | x | 60 | = | 0 | 0
KITCHEN - PRIVATE |  | x | 7.2 | = | 0 | 0
DISHWASHER - PRIVATE |  | x | 8.7 | = | 0 | 0
DISHWASHER - COMMERCIAL |  | x | 100 | = | 0 | 0
WATER SPIGOT |  | x | 3.6 | = | 0 | XXXXXX
YARD HYDRANT |  | x | 8.1 | = | 0 | XXXXXX
DRINKING FOUNTAIN |  | x | 1.5 | = | 0 | 0
ICE MACHINE/WATER COOLERS |  | x | 1.5 | = | 0 | 0
FOUNTAINS |  | x | 2.5 | = | 0 | 0
[NAME] |  | x | 7.5 | = | XXXXXX | 0
WHIRLPOOLS/HOT TUBS |  | x | 5 | = | 0 | 0
SWIMMING POOL/gal. |  | x | 0.0025 | = | 0 | 0
CARWASH BAYS |  | x | 150 | = | 0 | 0
WASTEWATER DUMP |  | x | 500 | = | XXXXXX | 0
BIDET |  | x | 5 | = | 0 | 0
DRIVE UP RESTAURANT(per bay) |  | x | 15 | = | 0 | 0
WET BAR |  | x | 2.5 | = | 0 | 0
RESTAURANT(per seat) |  | x | 2.5 | = | 0 | 0
BAR(per seat) |  | x | 1.8 | = | 0 | 0
CONVENTION CENTER(per seat) |  | x | 1 | = | 0 | 0
IRRIGATION(per sq.ft.>3000) |  | x | 0.004 | = | 0 | XXXXXX
TOTAL POINTS |  |  |  |  | 0 | 0
 |  |  |  |  | X | X
 | Fee per point |  |  |  | 27.96 | 41.44
 | Water Rights Fee per point |  |  |  | 40.82
 | Current Plant Investment Fee |  |  |  | 0 | 0
 | Current Water Rights Fee |  |  |  | 0
 | Credit for previously paid fees |  |  |  | 0 | 0
3/4" WATER METER |  | x | 7.556 | = | 0 | 0
1" WATER METER |  | x | 8.691 | = | 0 | 0
 |  | x |  | = | 0 | 0
 | Total amount due or remaining credit |  |  |  | 0 | 0
 | TOTAL PLANT INVESTMENT FEE DUE |  |  |  |  | 0
Spreadsheet: 227596d2-601c-4c11-844b-c2e61b31c689
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Fervent Records | 9781933876115 | Big Daddy Weave | Redeemed Lyric/Gift Book (Book W/Cd) | 2013-03-12 | Printed Books | Ac | 13.99 | Y | Available
Spreadsheet: 4c987eaa-aa7a-4f1e-99b8-52b459740c7e
Sheet: Sheet1

Table 5--USDA-calculated world market rice prices (rough basis) 1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | 2012/13 |  |  | 2011/12 |  |  | 2010/11
 |  | Medium/ |  |  | Medium/ |  |  | Medium/
Month | Long | short |  | Long | short |  | Long | short
 | $/cwt
August 2/ | 11.92 | 12.14 |  | 14.08 | 14.4 |  | 9.58 | 9.68
September |  |  |  | 15.09 | 15.44 |  | 10.51 | 10.62
October |  |  |  | 15.63 | 15.99 |  | 12.15 | 12.29
November |  |  |  | 14.93 | 15.28 |  | 13.4 | 13.58
December |  |  |  | 13.9 | 14.21 |  | 14.5 | 14.67
January |  |  |  | 12.61 | 12.88 |  | 13.98 | 14.15
February |  |  |  | 11.81 | 12.2 |  | 12.68 | 13.35
March |  |  |  | 11.52 | 11.92 |  | 12.13 | 12.76
April |  |  |  | 11.15 | 11.54 |  | 11.76 | 12.36
May |  |  |  | 11.42 | 11.82 |  | 11.58 | 12.17
June |  |  |  | 11.93 | 12.35 |  | 11.78 | 12.39
July |  |  |  | 11.97 | 12.4 |  | 12.49 | 13.14
Market-year
average 1/ | 11.92 | 12.14 |  | 13.00333333333334 | 13.36916666666666 |  | 12.21166666666667 | 12.59666666666666
1/ Simple average of the U.S. Department of Agriculture's weekly adjusted world market price.  2/  Preliminary.
Source: [NAME] and Rice Weekly Prices (ftp://ftp.fsa.usda.gov/public/cotton/default.htm), Farm Service Agency, USDA.
Last updated August 13, 2012.
Spreadsheet: 109883d1306703231-index-match-dfce_eais-products
Sheet: Wine Shelving

 | [NAME] |  |  |  | 350mm deep | Bottle capacity | 600mm deep | Bottle capacity |  | EAIS
 | Racking Trolleys | 6 tier - Wine Shelving – Chrome Wire | RAT084 | 600mm | 90 | 66 btls | 100 | 132 btls | N/A | EAIS
 | Racking Trolleys | 6 tier - Wine Shelving – Chrome Wire | RAT085 | 800mm | £95 90 | 90 btls | 105 | 180 btls | N/A | EAIS
 | Racking Trolleys | 6 tier - Wine Shelving – Chrome Wire | RAT086 | 900mm | 105 | 102 btls | 115 | 204 btls | N/A | EAIS
 | Racking Trolleys | 6 tier - Wine Shelving – Chrome Wire | RAT087 | 1000mm | 110 | 126 btls | 125 | 252 btls | N/A | EAIS
 | Racking Trolleys | 6 tier - Wine Shelving – Chrome Wire | RAT088 | 1200mm | 115 | 138 btls | 135 | 276 btls | N/A | EAIS
 | Racking Trolleys | 6 tier - Wine Shelving – Chrome Wire | RAT089 | 1500mm | 120 | 174 btls | 145 | 348 btls | N/A | EAIS
 | Racking Trolleys | 6 tier - Wine Shelving – Chrome Wire | RAT090 | 1800mm | 125 | 210 btls | 160 | 420 btls | N/A | EAIS
 | Racking Trolleys | 6 tier - Wine Shelving – Nylon Wire | RAT091 | 600mm | 100 | 66 btls | 115 | 132 btls | N/A | EAIS
 | Racking Trolleys | 6 tier - Wine Shelving – Nylon Wire | RAT092 | 800mm | 105 | 90 btls | 120 | 180 btls | N/A | EAIS
 | Racking Trolleys | 6 tier - Wine Shelving – Nylon Wire | RAT093 | 900mm | 110 | 102 btls | 125 | 204 btls | N/A | EAIS
 | Racking Trolleys | 6 tier - Wine Shelving – Nylon Wire | RAT094 | 1000mm | 125 | 126 btls | 135 | 252 btls | N/A | EAIS
 | Racking Trolleys | 6 tier - Wine Shelving – Nylon Wire | RAT095 | 1200mm | 130 | 138 btls | 150 | 276 btls | N/A | EAIS
 | Racking Trolleys | 6 tier - Wine Shelving – Nylon Wire | RAT096 | 1500mm | 140 | 174 btls | 160 | 348 btls | N/A | EAIS
 | Racking Trolleys | 6 tier - Wine Shelving – Nylon Wire | RAT097 | 1800mm | 150 | 210 btls | 175 | 420 btls | N/A | EAIS
Spreadsheet: 743949d1628839061-count-specific-numbers-in-a-cell-and-not-characters-count-number-in-cells
Sheet: Plot Order All (2)

 |  |  |  | column to count he numbers only |  |  |  |  | this is the outcome I want
 |  |  |  | 1 | 1 | The Lymner |  |  | 1
 |  |  |  | 1 | 2 | The Cutler |  |  | 1
 |  |  |  | 3 | 3-4 | The [NAME]-The Blacksmith |  |  | 2
 |  |  |  | 3 | 5-6 | The Thespian-The Tailor |  |  | 2
 |  |  |  | 1 | 7 | The Coppersmith M4(2) |  |  | 1
 |  |  |  | 1 | 8 | The Cobbler M4(2) |  |  | 1
 |  |  |  | 1 | 9 | The Mason |  |  | 1
 |  |  |  | 5 | 10-11 | The Joiner-The Joiner |  |  | 2
 |  |  |  | 2 | 12 | The Lymner |  |  | 1
 |  |  |  | 2 | 13 | The Lymner |  |  | 1
 |  |  |  | 2 | 14 | The Cobbler M4(2) |  |  | 1
 |  |  |  | 2 | 15 | The Cutler |  |  | 1
 |  |  |  | 5 | 16-17 | The [NAME]-The Blacksmith |  |  | 2
 |  |  |  | 12 | 18 - 19 - 20 | The Thespian-The Tailor |  |  | 3
 |  |  |  | 17 | 21 - 22 - 23 - 24 | The [NAME]-The Blacksmith - The Blacksmith-The Blacksmith |  |  | 4
Spreadsheet: 758576d1638957543-extracting-same-cell-data-from-multiple-worksheets-variation-tracker
Sheet: 61

NCE Reference:
Description of work | Test
Date:
QTY | Scope of Work Reference | Qty | Unit | Rate | Cost
 | STAFF
 | Staff Sub-Total | 0
 | Mark up Percentage | 0.16
 | Staff Total
 | LABOUR
 | Labour Sub-Total | 0
 | Mark up Percentage | 0.16
 | Labour Total
 | PLANT
 | Plant Sub-Total | 0
 | Mark up Percentage | 0.16
 | Plant Total
 | PERMANENT MATERIALS
 | Perm Materials Sub-Total | 0
 | Mark up Percentage | 0.16
 | Perm Materials Total
 | TEMPORARY MATERIALS
 | Temp Materials Sub-Total | 0
 | Mark up Percentage | 0.16
 | Temp Materials Total
 | SUBCONTRACTOR
 | [NAME] | 0
 | Mark up Percentage | 0.16
 | Subcontractor Total
 | OH/P
 | GRAND TOTAL
 | EOT |  |  | 0 | Days
Spreadsheet: 852329d1702396677-help-with-formula-current-tool-aligw
Sheet: Order Tool

 | Select customer from drop down ---> | Customer 2 |  |  | Green area below is where I want the dynamic formula
 | Paste customers order below in cell 8B |  |  |  | Copy and paste the corrected order below into SAP
 | Buyer Code | Quantity |  |  | Correct Code | Quantity
 | CF020006 | 1 |  |  |  | 1
 | CF020020 | 2 |  |  | H7917-00020 | 2
 | CF020054 | 1 |  |  | H7917-00054 | 1
 | CF020060 | 1 |  |  | H7917-00060 | 1
 | CF020067 | 1 |  |  | H7917-00067 | 1
 | CF020073 | 3 |  |  | H7917-00073 | 3
 | CF020080 | 5 |  |  | H7917-00080 | 5
 | CF020089 | 1 |  |  | H7917-00089 | 1
 | CF020507 | 2 |  |  | H7917-00507 | 2
 | CF020555 | 7 |  |  | H7917-00555 | 7
 | CF020634 | 1 |  |  | H7917-00634 | 1
 | CF020645 | 2 |  |  | H7917-00645 | 2
 | CF020700 | 1 |  |  | H7917-00700 | 1
 | CF020744 | 1 |  |  | H7917-00744 | 1
 | CF020774 | 2 |  |  | H7917-00774 | 2
 | CF020803 | 1 |  |  | H7917-00803 | 1
 | CF020881 | 1 |  |  | H7917-00881 | 1
 | CF021036 | 1 |  |  | H7917-01036 | 1
 | CF021039 | 3 |  |  | H7917-01039 | 3
 | CF021081 | 5 |  |  | H7917-01081 | 5
 | CF021083 | 1 |  |  | H8070-00001 | 1
 | CF021084 | 2 |  |  | H8070-00002 | 2
 | CF021085 | 7 |  |  | H9347 | 7
 | CF021086 | 1 |  |  | H9330 | 1
 | CF021087 | 2 |  |  | H8070-00005 | 2
 | CF021088 | 1 |  |  | H8070-00006 | 1
 | CF021089 | 1 |  |  | H8070-00007 | 1
 | CF021090 | 1 |  |  | H8070-00008 | 1
Spreadsheet: 92744d1292307101-iteration-continuously-increases-before
Sheet: 2009Week16

Week | Day | Date | Winner/tie | PtsW |  | [NAME]/tie | PtsL
16 | Fri | 2010-12-25 00:00:00 | San Diego Chargers | 42 | @ | Tennessee Titans | 17
16 | Sun | 2010-12-27 00:00:00 | Carolina Panthers | 41 | @ | New York Giants | 9
16 | Sun | 2010-12-27 00:00:00 | Tampa Bay Buccaneers | 20 | @ | New Orleans Saints | 17
16 | Sun | 2010-12-27 00:00:00 | New England Patriots | 35 |  | [NAME] | 7
16 | Sun | 2010-12-27 00:00:00 | Houston Texans | 27 | @ | [NAME] | 20
16 | Sun | 2010-12-27 00:00:00 | Pittsburgh Steelers | 23 |  | Baltimore Ravens | 20
16 | Sun | 2010-12-27 00:00:00 | San Francisco 49ers | 20 |  | Detroit Lions | 6
16 | Sun | 2010-12-27 00:00:00 | Philadelphia Eagles | 30 |  | Denver Broncos | 27
16 | Sun | 2010-12-27 00:00:00 | Dallas Cowboys | 17 | @ | Washington Redskins | 0
16 | Sun | 2010-12-27 00:00:00 | Arizona Cardinals | 31 |  | St. Louis Rams | 10
16 | Sun | 2010-12-27 00:00:00 | New York Jets | 29 | @ | Indianapolis Colts | 15
16 | Sun | 2010-12-27 00:00:00 | [NAME] | 23 |  | Oakland Raiders | 9
16 | Sun | 2010-12-27 00:00:00 | Atlanta Falcons | 31 |  | Buffalo Bills | 3
16 | Sun | 2010-12-27 00:00:00 | Green Bay Packers | 48 |  | [NAME] | 10
16 | Sun | 2010-12-27 00:00:00 | Cincinnati Bengals | 17 |  | Kansas City Chiefs | 10
16 | Mon | 2010-12-28 00:00:00 | Chicago Bears | 36 |  | Minnesota Vikings | 30
Spreadsheet: 48b37cac-0f14-48e0-8488-8fd483027e97
Sheet: science 5

TCAP/CSAP Science |  | Total Number | [NAME]
Grade 5 |  |  | Unsatisfactory | Partially Proficient | Proficient | Advanced | No Score
2010 | All Students | 60247 | 13 | 39 | 34 | 13
2011 |  | 61976 | 16 | 37 | 33 | 13
2012 | All Students | 62775 | 15 | 37 | 35 | 14
 | American Indian/Alaska Native | 522 | 22 | 45 | 27 | 6
 | Asian | 2021 | 11 | 30 | 37 | 21
 | Black/African American | 2881 | 30 | 45 | 21 | 3
 | Hispanic/Latino | 20404 | 27 | 46 | 22 | 4
 | White | 34768 | 6 | 31 | 43 | 20
 | Native Hawaiian/Pacific Islander | 123 | 22 | 35 | 32 | 11 | 1
 | Two or more races | 2055 | 11 | 35 | 37 | 17
 | Minority | 28006 | 25 | 44 | 24 | 6 | 1
 | Students with Disabilities | 6320 | 47 | 38 | 12 | 2 | 1
 | English Learners | 12068 | 32 | 45 | 19 | 3
 | Free/Reduced Lunch | 27855 | 25 | 46 | 23 | 4
 | Female | 30948 | 14 | 38 | 35 | 13
 | Male | 31823 | 15 | 35 | 35 | 15
 | Migrant | 190 | 39 | 47 | 11 | 2 | 1
Spreadsheet: 20ad4b35-0e39-45c8-a18d-252afe785683
Sheet: SubjectArea

Number | [NAME]
1 | English Language Arts and Literature
2 | Mathematics
3 | Science
4 | Social Sciences and History
5 | Visual and Performing Arts
6 | World Languages
7 | Religious Education and Theology
8 | Physical and Health Education
9 | Military Science
10 | Computer Information Sciences
11 | Communication and Audio/Visual Technology
12 | Business and Marketing
13 | Manufacturing
14 | Health Care Sciences
15 | Public, Protective, Government Services
16 | Hospitality and Tourism
17 | Architecture and Construction
18 | Agriculture, Food and Natural Resources
19 | Human Services
20 | Transportation, Distribution and Logistics
21 | Engineering and Technology
22 | Family and Consumer Science
23 | Academic, [NAME] and Nonspecific Electives
Spreadsheet: 673325d1587312713-extracting-data-from-a-table-with-multiple-rows-and-columns-spice-recipe-analyses-pivot-solution
Sheet: BC Spice range recipes

Ingredient | [NAME] | [NAME]
Absinthe
Achiote
Allspice | 2 |  |  |  | Desired end result:
Angelica
Anise |  | 2 |  |  | [NAME]
Annatto |  |  |  |  | Allspice | 2
Anti Caking Agent | 3 |  |  |  | [NAME] | 2
Asafoetida |  |  |  |  | [NAME] | 2.5
Balm |  | 1 |  |  | [NAME] | 2.5
Basil |  |  |  |  | Anti Caking Agent | 3
[NAME] | 2 | 1 |  |  | Black Pepper Ground | 4
Bay Leaves |  |  |  |  | Mustard Seeds Ground | 4
Bergamot |  |  |  |  | Garam Masala | 8
Black Cumin |  |  |  |  | Coriander [NAME] | 17
Black mustard |  |  |  |  | [NAME] | 17
Black Pepper Cracked/ coarse |  | 1 |  |  | [NAME] | 17
Black Pepper Ground | 4 |  |  |  | Kashmiri Mirch (Chilli) | 125
Black Pepper Whole
Borage
[NAME]
Brown mustard
Buchu |  |  |  |  | Row Labels | Sum of [NAME]
Burnet |  |  |  |  | [NAME] | 2
California Bay Leaf |  |  |  |  | Allspice | 2
Capers |  |  |  |  | [NAME] | 2.5
Caraway Seeds |  |  |  |  | [NAME] | 2.5
Cardamom Ground |  |  |  |  | Anti Caking Agent | 3
Cardamom Whole |  |  |  |  | Black Pepper Ground | 4
Carom (Ajwain) |  |  |  |  | Mustard Seeds Ground | 4
[NAME] |  |  |  |  | Garam Masala | 8
Catnip |  |  |  |  | [NAME] | 17
Cayenne Pepper |  |  |  |  | Coriander [NAME] | 17
Cayenne Pepper Extra Hot |  |  |  |  | [NAME] | 17
Cayenne Pepper Whole |  |  |  |  | Kashmiri Mirch (Chilli) | 125
Celery Seeds |  |  |  |  | Grand Total | 204
Chamomile
Chervil
[NAME]
Chicory
Chili pepper
[NAME]
[NAME]
Chinese Five Spice
Chives
Cicely
Cilantro
[NAME]
[NAME]
[NAME]
Cloves Whole
Coriander [NAME] |  | 1
Coriander [NAME] | 17
Coriander [NAME]
Costmary
[NAME] | 17
Cumin Seeds Whole
Curry leaf
Dextrose (Sugar)
Dill Seed
[NAME]
Fennel Seeds Whole
Fenugreek
Field mint
Filé
Galangal Root Ground
Garam Masala | 8
Garden nasturtium
[NAME] |  | 1
[NAME] | 2.5
[NAME] | 2.5
[NAME]
Gochugaru
Grains of Paradise
Horehound
Horseradish
[NAME]
Italian Herbs
Juniper berries
[NAME]
Kashmiri Mirch (Chilli) | 125
Lavender
Lemon
lemon balm
lemon grass
Lemon verbena
Licorice
Loomi
Lovage
[NAME]
Mahleb
Makrut lime
[NAME]
Marjoram Leaves
Mexican [NAME]
Mint
[NAME]
MSG
Mustard Seeds Coarsley Ground Yellow |  | 0.5
Mustard Seeds Ground | 4
Mustard Seeds Wholes
[NAME]
Myrtle
[NAME]
[NAME]
Nutritional Yeast
Onion Flakes |  | 1
Onion Powder
Oregano
[NAME] |  | 1
[NAME]
[NAME]
Parsley Flakes
Pepper White Gound
Peppercorns Pink
Peppermint
Pimento
Poppy Seeds
Pumpkin Spice
Red Pepper
Rosemary
Rue
Saffron
Sage Leaves Ground
Salt coarse
Salt fine |  | 1
Savory
Sesame Seeds
Sichuan pepper
Sorrel
Spearmint
Star Anise
Sumac
Szechuan Peppercorns
Tamarind
Tarragon
Thyme
[NAME] | 17
Vanilla
Wasabi
Wormwood
[NAME]
Zedoary
Spreadsheet: 704780d1605743810-create-a-list-from-multiple-entries-in-a-column-excel-question
Sheet: Excel Question

Starting Balance |  | 20000
Plan
Trade # | Date | Trade Profit/Loss | Balance |  |  |  | Date | Total P/L | Total ROI
1 | 2020-11-03 00:00:00 | 100 |  |  |  |  | 2020-11-03 00:00:00
2 | 2020-11-03 00:00:00 | 105 |  |  |  |  | 2020-11-04 00:00:00
3 | 2020-11-03 00:00:00 | -200 |  |  |  |  | 2020-11-07 00:00:00
4 | 2020-11-04 00:00:00 | 300 |  |  |  |  | 2020-11-10 00:00:00
5 | 2020-11-07 00:00:00 | -150 |  |  |  |  | 2020-11-11 00:00:00
6 | 2020-11-07 00:00:00 | 100
7 | 2020-11-07 00:00:00 | 500
8 | 2020-11-07 00:00:00 | -600
9 | 2020-11-07 00:00:00 | 200
10 | 2020-11-07 00:00:00 | 400
11 | 2020-11-07 00:00:00 | 450
12 | 2020-11-07 00:00:00 | -200
13 | 2020-11-07 00:00:00 | -100
14 | 2020-11-07 00:00:00 | -500
15 | 2020-11-07 00:00:00 | 100
16 | 2020-11-10 00:00:00 | -100
17 | 2020-11-10 00:00:00 | -400
18 | 2020-11-10 00:00:00 | 200
19 | 2020-11-11 00:00:00 | -100
20 | 2020-11-11 00:00:00 | 300
Spreadsheet: 876422d1723109855-if-or-statement-mick3911-book1-361-365-aligw
Sheet: Sheet1

Level | Date Raised | Status | Overdue?
Minor | 2024-07-29 00:00:00 | Open | No
major | 2024-07-10 00:00:00 | Closed | No
Critical | 2024-07-15 00:00:00 | Open | Yes
Minor | 2024-07-07 00:00:00 | Open | Yes
Spreadsheet: 703073d1604735171-inventory-tracking-formulas-and-formula-for-discounts-or-bulk-buying-example
Sheet: Product List

Product Name
Bracelet 1
Bracelet 2
Bracelet 3
Bracelet 4
Bracelet 5
Bracelet  6
Necklace 1
Necklace 2
Necklace 3
Necklace 4
Necklace 5
Necklace 6
Necklace 7
Bookmarks 1
Bookmarks 2
Bookmarks 3
Bookmarks 4
Bead 1
Bead 2
Bead 3
Bead 4
Bead 5
Bead 6
Bead 7
Bead 8
Paint 1
Paint 2
Paint 3
Paint 4
Paint 5
Paint 6
Spreadsheet: 169066d1342695869-align-data-in-different-columns-align-data-sample
Sheet: Sheet1

23560 | andrews | churchill
25982 | [NAME] | cross
25116 | bradley | harris
56236 | cameron | hughes
23584 | churchill | [NAME]
24585 | clark | [NAME]
25489 | cross | price
25695 | [NAME] | simons
25687 | fowler | woods
26989 | grant | [NAME]
26347 | harris
21485 | hughes
2569 | [NAME]
26598 | [NAME]
25791 | jones
26549 | [NAME]
26852 | [NAME]
23231 | paulson
24875 | peters
26589 | price
26587 | rose
24595 | simons
24871 | [NAME]
26571 | woods
29635 | [NAME]
Spreadsheet: 672363d1586845708-get-the-count-of-the-column-entries-comparing-2-sheets-data
Sheet: Sheet3

 |  |  | Name | P3 | P4 | P5 | Total
 |  |  | AA | 2 | 3 | 1 | 6
 |  |  | BB |  | 1 | 1 | 2
 |  |  | CC | 2 |  |  | 2
 |  |  | DD |  | 2 | 1 | 3
 |  |  | EE |  | 1 |  | 1
Spreadsheet: 118428d1313681503-sign-value-reference-to-value-in-column-quest18-08
Sheet: Sheet1

Sell value | 1.5 | Buy new | 0.7
 |  |  | HOW IT SHOULD BE |  | # OPTIONS | COST OPTIONS
 |  |  |  |  | 1 | 9.2
 |  |  |  |  |  |  |  |  | If there is a 1 in column E, you follow the row to column G and go up to find the first cell with a value. Then you calculate b1*value of cell column G.
 |  |  | 13.8 | 1 |  |  |  |  | If there is a 0 in column E, you follow the row to column G and go up to find the first cell with a value. Then you calculate d1*value of cell column G.
 |  |  | 27.375 | 1 | 1 | 18.25
 |  |  | 1.225 | 0 | 1 | 1.75
 |  |  |  |  | 2 | 3.5
 |  |  | 2.45 | 0
 |  |  |  |  | 3 | 15.75
 |  |  | 23.625 | 1
 |  |  | 0.175 | 0 | 1 | 0.25
 |  |  |  |  | 2 | 0.5
 |  |  | 0.35 | 0
 |  |  | 1.575 | 0 | 3 | 2.25
 |  |  | 18 | 1 | 4 | 12
 |  |  | 0.07500000000000001 | 1 | 1 | 0.05
 |  |  |  |  | 1 | 0.05