tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 356662d1415181655-column-sort-without-chaning-formulae-jc-booking-september-2014
Sheet: 21st

Date |  |  |  |  |  |  |  |  |  |  |  | DAY SHEET
Job No | Due | Contact | Contact No. | Car | Imax | 13 Pax | 20 Pax | 24 Pax | 29 Pax | 44 Pax | FROM | TO | Retn | Price  $ | Dep  $ | Bal | Mode | Pax | Trailer | Con | Bus | Des | Driver
 | 0730 | Viva Fitness Centre | Janice [PHONE] |  |  |  | 1 |  |  |  | Viva Fitness Keele Place Kidman Pk | City | y | 100 | 0 |  | acct | 16 |  | x |  |  | Cat
 | 0815 | Viva Fitness Centre | Janice [PHONE] |  | 1 |  |  |  |  |  | Viva Fitness Keele Place Kidman Pk | [NAME] Pk | no | 65 | 0 |  | acct | 4 |  | x |  |  | [NAME]
 | 0830 | [NAME] |  |  |  |  | 1 |  |  |  | Self Drive x 1 day |  |  | 240 | 240 |  | c/card |  |  | x |  |  | P/Up 0900
9548 | 0850 | Encounter SA J-6841 | DT [NAME] |  |  |  |  | 1 |  |  | Grand Chifley | Full Day sightseeing .George Wild Life Park Rundle Mall terminate 1500 -Airport | no | 510 | 0 |  | acct | 17 | yes | x |  |  | [NAME] 9
 | 0930 | [NAME] | [PHONE] |  |  |  |  | 1 |  |  | [NAME], Modbury Soccer Club | Hndmarsh Stadium | no | 95 | 0 |  | cash | 24 | no | x |  |  | Sully
 | 1030 | Viva Fitness Centre | Janice [PHONE] |  |  |  | 1 |  |  |  | Buffalo Rest Glenelg | Viva Fitness Keele Place Kidman Pk | no | 100 | 0 |  | acct | 20 |  | x |  |  | cat
 | 1220 | [NAME] | [PHONE] |  |  |  | 1 |  |  |  | 11 Omnia Ct Salisbury Hts | [NAME] | no | 110 | 0 |  | cash | 20 |  | x |  |  | cat
 | 1230 | TBA | TBA |  |  |  | 1 |  |  |  | 5 leanne  Ace Ridge haven | [NAME] | y | 120 | 0 |  | cash | 20 |  | x |  |  | Sully
 | 1230 | [NAME] | [PHONE] |  |  | 1 |  |  |  |  | 1 Battams Rd Royston Pk | Adelaide Oval | y | 75 | 0 | 75 | cash | 13 | no | x |  |  | dean
 | 1300 | Bek Footner Mount Carmel College PO Box 35 Poert Adelaide Business Centre SA 5015 email [EMAIL] | 84470500 Corstons 52 seat coach booked 21st August email |  |  |  |  |  |  | 1 | [NAME] | Mt Carmel College | no | 752 | 0 | 752 | acct | 80 | no | x |  |  | [NAME]
 | 1730 | tba | TBA |  |  |  | 1 |  |  |  | Adelaide Oval | Ridgehaven or Norwood $88 | no | 120 | 0 |  | cash | 20 |  | x |  |  | Sully
 | 1815 | [NAME] | [PHONE] |  |  | 1 |  |  |  |  | Adelaide Oval | Norwood | no | 75 | 0 | 75 | cash | 13 | no | x |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Malaysia - 0645 Hotel
 |  |  |  |  |  |  |  |  |  |  | Malaysia - 0730 - Apt
TOTAL
Spreadsheet: 83832d1283873050-excel-2007-formula-to-find-specific-data-and-then-insert-it-into-next-available-row-returneachinstance-2-
Sheet: The Question

Currently the data set would look like this: |  |  |  | I would like the formula to find the data and then display it like this, adding entries that match the criteria:
A | B |  |  | A | B | C
[NAME] | 100 |  |  | [NAME] | 100 | 92
[NAME] | 90 |  |  | [NAME] | 90 | 120
[NAME] | 95 |  |  | [NAME] | 95
[NAME] | 92
[NAME] | 100 |  |  | [NAME] | 100
[NAME] | 120
Spreadsheet: 678228d1589789360-dynamic-reporting-possible-pivot-table-with-multiple-columns-on-one-sheet-to-source-from-pivottest
Sheet: Sheet5

Agency name | Count |  | Organisation Type | Count |  | Progress | Count
ONETAKE | 3 |  | GOVERNMENT | 6 |  | STARTUP | 9
TWOTAKE | 3 |  | PRIVATE | 10 |  | ONGOING | 5
GIVEONE | 5 |  | CORPORATION | 6 |  | STALLED | 5
GIVETWO | 5 |  |  |  |  | FINISHED | 3
OUTTERONE | 3
OUTTERTWO | 3
Spreadsheet: 740590d1626403716-counting-winner-across-multiple-columns-most-high-scores
Sheet: Sheet1

 | Game 1 | Game 2 | Game 3 | Game 4 | Game 5 | Game 6 | # of times scored highest
[NAME] | 433 | 107 | 345 | 223 | 109 | 306
[NAME] | 512 | 483 | 209 | 377 | 455 | 118
[NAME] | 202 | 306 | 402 | 187 | 502 | 409
[NAME] | 388 | 154 | 398 | 209 | 318 | 227
[NAME] | 129 | 411 | 271 | 329 | 198 | 212
[NAME] | 88 | 179 | 209 | 401 | 333 | 343
[NAME] | 309 | 238 | 298 | 128 | 254 | 199
Spreadsheet: 113955d1309850674-count-number-of-times-value-is-present-i-area-count
Sheet: Sheet1

Area
11
22
33
44
55
66
77
88
99
11
11
22
33
33
33
44
88
99
99
99
99
Spreadsheet: 794736d1662281427-sumifs-function-with-latest-dates-as-one-of-the-criteria-2022-09-04-oeldere-laxminarayana-sample-format-1-
Sheet: Sheet1

Category | Sub Category | Date Sold | Amount | criteria | Helpcolumn
Grapes | Black | 2022-07-05 00:00:00 | 70
Grapes | Black | 2022-07-15 00:00:00 | 70
Grapes | Green | 2022-07-17 00:00:00 | 60
Capsicum | Green | 2022-08-03 00:00:00 | 45
Capsicum | Yellow | 2022-08-05 00:00:00 | 50
Capsicum | Yellow | 2022-08-10 00:00:00 | 50
Apples | Green | 2022-08-15 00:00:00 | 30
Apples | Red | 2022-08-15 00:00:00 | 50
Apples | Green | 2022-08-31 00:00:00 | 40
Spreadsheet: 49674d1249012185-autofill-numbers-in-a-range-test
Sheet: Sheet1

Year
2007-2009
2007-2009
2007-2009
2007-2009
2007-2009
2007-2009
2002-2009
2004-2009
2004-2009
2004-2007
1999-2007
1999-2007
1999-2007
1988-1998
1988-1998
1988-1998
1994-2009
1996-2009
2002-2009
2007-2009
2007-2009
2007-2009
2007-2009
2007-2009
2007-2009
2004-2009
2004-2009
2004-2007
1999-2007
1999-2007
1999-2007
1988-1998
1988-1998
1988-1998
1994-2009
1996-2009
2002-2009
2002-2009
1995-2001
1995-2001
2000-2009
1986-2009
2004-2009
2004-2009
2004-2009
2004-2009
2001-2004
1997-2004
1997-2004
1997-2004
1999-2009
1999-2009
2000-2006
1993-2009
1995-2009
1994-2009
2006-2009
2006-2009
2004-2009
2004-2009
2005-2009
2005-2009
2000-2004
1998-2004
2007-2009
2007-2009
2007-2009
2004-2006
2003-2006
2000-2006
2005-2009
2005-2009
2001-2004
1989-2004
Spreadsheet: 160101d1338974903-how-to-simplify-criteria-conditions-for-dget-formula-proyecto
Sheet: Sales Monthly

 |  |  |  |  |  | Sales in 2011
 | Sold To | Company Name | Details | Note | Sales | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | YTD
 | 10926576 | Client 6 |  |  | Fixed NO | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | Variable |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | NO | 1087.92 |  |  |  |  |  |  |  |  |  |  |  | 1087.92
 |  |  |  |  | PO |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | AO |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | CO |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 10904703 | Client 21 |  |  | Fixed NO | 9124.6 | 9124.6 | 9124.6 | 9124.6 | 9124.6 | 9124.6 | 9124.6 | 9124.6 | 9124.6 | 9124.6 | 9124.6 | 9124.6 | 109495.2
 |  |  |  |  | Variable
 |  |  |  |  | NO
 |  |  |  |  | PO
 |  |  |  |  | AO
 |  |  |  |  | CO
 | etc
 |  | Find the Client by the "Sold To" number and return all the sales for each month where Column 3 data ended in NO  or AO  or PO…etc
 | etc
 |  | Data in Raw data will always have the same number of columns but the number of rows will change depending if there was a a sale on the month or not.
 | (*) | For the Fixed cost in the current year, the data that i need to bring over to the Sales Monthly Sheet will always be in Column 8 and the data in Column 3 will end in "NO"
 | (*) | For the variable cost in the current year, the data that i need to bring over to the Sales Monthly Sheet will always be in Column 10 and the data in Column 3 will end in "NO" or "AO" or "PO" or "CO"
 |  | i tried using the DGET formula but the criteria will change by date and by Material Type (ending NO, PO, AO or CO) and this will mean that i need to create an enourmous matrix with all the different conditions.
 |  | I need something more automatic and simpler if possible
Spreadsheet: 328805d1404099163-comparing-cells-with-a-reference-source-and-skip-blanks-book2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BATCH NO.: |  |  |  | 4021
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REMARKS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1234 |  |  |  | 5678 |  |  |  | Judge
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1234 |  |  |  | 5678
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4021 |  | 4021
 |  |  | Specification
 |  |  | 6 | to | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 6
Spreadsheet: 485434d1476882084-need-to-call-upon-workbook-and-sheetname-from-cell-jan2016
Sheet: Jan

Month of Jan | Store 1 | Store 2 | Store 3 | Store 4 | Store 5
Item 1 | 2 | 23 | 23 | 64 | 73
Item 2 | 10 | 122 | 35 | 124 | 56
Item 3 | 50 | 15 | 51 | 3 | 9
Item 4 | 23 | 64 | 63 | 56 | 79
Item 5 | 16 | 76 | 63 | 97 | 23
Total
Spreadsheet: 122852d1317207305-choose-data-to-populate-main-worksheet-populate_worksheet-1-
Sheet: Tabela Auxiliar

 | 10 | 10.1 | 11 | 11.1 | 12 | 12.1 | 13 | 13.1 | 14 | 14.1
 | 10 M | 10 F | 11 M | 11 F | 12 M | 12 F | 13 M | 13 F | 14 M | 14 F | Categoria
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BP
 | 14.65 | 14.62 | 14.98 | 15.06 | 15.36 | 15.63 | 15.85 | 16.27 | 16.42 | 16.89 | N
 | 19.84 | 19.86 | 20.55 | 20.74 | 21.22 | 21.68 | 21.91 | 22.58 | 22.62 | 23.34 | EP
 | 24 | 24.11 | 25.1 | 25.42 | 26.02 | 26.67 | 26.84 | 27.76 | 27.63 | 28.57 | O
Spreadsheet: 32428979-774c-4a1a-be4c-a33bc448eacb
Sheet: Sheet1

PACKLISTA AROS JUNI 2009 | Unnamed: 1 | Unnamed: 2
Dit | [NAME] | Vad ska packas
 |  | Gräsfotbollsskor gärna två par (har du inte två gräs kan du ta gräs + grus)
 |  | Gula fotbollstrumpor (2-3 par)
 |  | Benskydd
 |  | Matchshorts
 |  | Matchtröja
 |  | Uppvärmnings T-shirts
 |  | [NAME] (mjukisplagg)
 |  | Vattenflaska
 |  | Foppatofflor eller liknande (kan vara skönt mellan matcherna)
 |  | Vind /regnjacka + byxor
 |  | Varm tröja / fleece/college
 |  | Kalsonger
 |  | Strumpor
 |  | Shorts
 |  | T-shirts
 |  | [NAME] till discot på lördagskvällen
 |  | Gympaskor att ha när du inte spelar
 |  | Badkläder
 |  | Handduk
 |  | Luftmadrass/liggunderlag & lakan
 |  | Kudde
 |  | Sovsäck
 |  | Något att sova i (pyjamas)
 |  | Skavsårsplåster
 |  | Solskyddskräm
 |  | Tvål & schampo
 |  | Tandborste & tandkräm
 |  | Deodorant, hårborste & vax (kan ju finnas snygga tjejor)
 |  | Eventuella mediciner
 |  | Ev linser eller glasögon
 |  | [NAME] ryggsäck/[NAME] ha sina saker i till badet o [NAME]
 |  | klädnypor med namn på (används för att hänga upp blöta strumpor)
 |  | Fickpengar till glass/godis max 150 kr dvs 50 kr/dag
 |  | Spelkort om du har
 |  | [NAME] tas med ,men med eget [NAME] hålla rätt på den
OBS! [NAME] gärna kläderna & ta bara med värdesaker som du kan hålla reda på!
Spreadsheet: 865455d1712535653-check-format-of-cell-value-various-combinations-case4
Sheet: Sheet1

236926786
237009011
237019842
237020046
237063194
BRMNSYD11
237203014
237204837
237077547
237017869
720021122
609993467
609993464
VSTU5140388
237705753
236393458
237267489
238056500
237389866
236725621
236779573
236967557
237158589
237289693
236725744
609993468
237252654
237489313
SALE0032553
237153964
720043028
237448413
[NAME]
[NAME]
720055960
237633077
237636498
237644907
237668516
237668679
237668753
236280797
237394739
237536907
237635598
720018747
720018746
236394301
720043051
720022458
237292967
237349704
237450957
237494074
237342038
237694727
237696890
[NAME]
BRMNSYD14
BRMNSYD14
237536955
237695058
SALE0032641
720018756
720018752
238038429
238040424
237633130
720081687
1280061
ASYD$11352
238091430
237247726
237997102
237997002
238091876
237253103
238096196
238119161
238119236
237238760
235745251
720079278
SALE0032356
237256617
237997152
237997203
237162874
237351531
237452791
237489044
237535228
237544196
237804459
237869269
237696746
237948364
237955725
237537788
237746793
238044961
238047790
238048849
238048898
BRMNCSY15
BRMNESD15
BRMNSYD15
BRMNSYD15
238044343
720018757
720018755
237348521
237396884
237489017
238093183
237153976
237292990
237535260
237744791
237804338
237806538
237867752
238040534
237998978
238045139
238122407
720018753
720018754
237494141
237859595
237585513
237642767
237744822
237541556
237635719
237696792
237371403
237752980
237999103
238048649
238123135
237494286
237695297
237635007
237635252
237755532
237988520
237988534
237986471
238091491
Spreadsheet: 53279d1253183261-display-an-array-of-data-based-on-other-data-lookup
Sheet: Sheet1

1Wright | [NAME] | A-1 | Beltran | A-21 | #N/A | #N/A |  |  | A-21
1Pujols | Pujols | B-3 | Jeter | C-22 | #N/A | #N/A |  |  | C-22
1Jeter | Jeter | C-22 | Pujols | B-3 | J-22 | #N/A |  |  | B-3 | J-22
2Wright | [NAME] | F-38 | [NAME] | A-1 | F-38 | mmmm |  |  | A-1 | F-38 | mmmm
1Beltran | Beltran | A-21
2Pujols | Pujols | J-22 |  |  |  |  |  |  | alternative hiding #N/A
3Wright | [NAME] | mmmm
Spreadsheet: 1a8f159d-c3ff-43c4-997c-8ce7d6f0a2e8
Sheet: Sheet1

Directions for Use:
Green Section Below:
Field Identification -  enter your field identfication information (example:  Field 35, Jones3, NW80, etc)    (Cell D18)
Legal Description -  Enter the Quarter, Section, Township, Range legal description of the property   (cells C19, E19, G19, and I19)
Enter the Nebraska Chemigation Permit Number for the site  (cell C20)
Enter the chemical application rate in gallons per acre (cell C21) and the product you will apply (28% UAN, 32% UAN, [NAME], etc.)  (cell G21)
Blue Section Below:
Replace 1298 with the length of your center pivot to the last tower in feet  (cell C24)
Replace 1315 with the length of your center pivot to the end of the pipelline in feet (cell C25)
Replace 27 with the radius of throw for the last sprinkler in feet  (cell C26)
Replace 110 with the radius of throw of the end gun on your pivot in feet  (cell C27)
Replace 800 with your system flow rate in gallons per minute  (cell C28)
Replace 24 with your center pivot's revolution time when set at the 100% timer setting in hours  (cell C29)
Replace 35 with the degrees of the revolution the end gun on your center pivot is on in each corner (cell C30)
Highlight the chart at the bottom and print it out for use in the pivot control panel.
Save this file on your computer for future use.
Field Information
Field Identification | Field 35
Legal Description (Q-S-T-R) | Quarter | NW | Section | 12 | Township | 28N | Range | 2E
Chemigation Permit Number | Certification No. | 41-04-44
Chemical Application | Application Rate | 20 | gal/ac |  | Product | 28% UAN Fertilizer
System Information | Example | Your Field
Irrigation system distance to last tower (feet) | 1280 | 1298
Irrigation system  pipeline length (feet) | 1274 | 1315
Throw of the last sprinkler (feet) | 20 | 27
Throw of the end gun (feet) | 90 | 110
Irrigation system flow rate (gpm) | 800 | 800
Pivot revolution time at the 100% setting (hr/rev) | 20 | 24
Degrees of a circle the end gun is on in each corner (degrees) | 30 | 35
Calculated Values | Example | Your Field
Distance Traveled by Last Tower per Revolution (feet) | 8042 |  | Circumference
Acres Treated per Revolution (acres) | 125 |  | Irrigated Area
Total Amount of Chemical Needed (gallons) | 1250 |  | Chemical volume needed
Injection Rate When System at 100% Timer (gph) | 62.6 |  | Rated capacity of injection pump
 |  | Chemigation  System Calibration Table
 |  | Quarter |  | Section |  | Township |  | Range
 |  | App. Rate: |  | gal/ac |  | Product:
 |  | Percent | Estimated | Estimated | Water | Area | Chemical | Chemical | Chemical
 |  | Timer | Revolution | Travel | Application | Irrigated | Injection | Injection | Injection
 |  | Setting | Time | Speed | Depth | Per Hour | Rate | Rate | Rate
 |  | % | Hours | feet/minute | Inches | ac/hr | gph | oz/min | ml/min
 |  | 5
 |  | 10
 |  | 15
Spreadsheet: 831937d1686003138-calculating-production-and-down-time-book1
Sheet: Prod Time 2

 | Product 1 | Product 2 | Product 3 | Product 4
Start | 07:00:00 | 04:20:00 | 13:10:00
Stop | 09:30:00 | 12:20:00 | 13:35:00
Start | 10:48:00 |  | 13:45:00
Stop | 14:21:00 |  | 18:20:00
Start
Stop
Start
Stop
Start
Stop
Start
Stop
Start
Stop
Start
Stop
Start
Stop
Run Time
Change Over - Down Time
Stop | 14:21:00 | 12:20:00 | 18:20:00
Start | 16:20:00 | 13:10:00 | 19:00:00
Down Time
% of Day
Ran
Down
Spreadsheet: 734277d1622087635-use-cell-address-in-formula-temp
Sheet: Sheet3

 |  | Series |  | [NAME] | [NAME]
 |  | 1518.6
 |  | 1590.85
 |  | 1570.4
 |  | 1556.45
 |  | 1565.6 |  | CELL ADDRESS FOR MAX VALUES
 |  | 1562.5
 |  | 1589.4
 |  | 1596.7
 |  | 1595.25 |  | ANS I AM LOOKING FOR | 1556
 |  |  |  | =MIN(E7:F7) | 0
 |  |  |  | =MIN($C$3:$C$9)
Spreadsheet: 15c43e74-8951-4f44-a44e-9bf8601986ef
Sheet: Template

AGENCY: | Denver
SCHOOL TYPE: | Middle only
SLV DATE:
SCHOOL NAME:
SCHOOL POPULATION:
COUNT OF STUDENTS ELIGIBLE FOR VACCINE:
COUNT OF STUDENTS VACCINATED:
VACCINES OFFERED: | Flu & Catch-up
VACCINE FUNDING | PAYER SOURCE | PAYER SOURCE - WRITE IN | PRIVATE INSURER NAME | [NAME] IN | NON-STUDENT? | CLAIM PROCESSING? | VACCINE 1 | VACCINE 2 | VACCINE 3 | VACCINE 4 | VACCINE 5 | VACCINE 6 | VACCINE 7 | VACCINE 8 | VACCINE 9
Spreadsheet: 144828d1331152015-excel-2007-sumifs-problem-need-it-to-take-certain-information-depending-on-if-it-meets-the-criteria-book2
Sheet: Data

Date | s | Customer | Variety | Cut style | Red Boxes Dumped | [NAME] | Total [NAME] | Average WT per Box | Total lbs dumped | Hours worked | Pound per hour | Head Count | Total Labor dollars | Cost per pound | Finish Pounds | Overrun | Total Finished lbs
2012-01-16 00:00:00 | B | McDonald's | [NAME] | 1.2oz | 40 |  |  | 800 |  | 5 |  | 37 |  |  | 10920 | 0
2012-01-16 00:00:00 | B | McDonald's | Jonagold/gran | red/green dice | 11 | 5 |  | 800 |  | 3.8 |  | 37 |  |  | 2461 | 1518
2012-01-20 00:00:00 | B | McDonald's | Jonagold/gran | red/green dice | 51 | 20 |  | 800 |  | 9 |  | 34 |  |  | 19775 | 0
2012-01-23 00:00:00 | B | McDonald's | Jonagold/gran | red/green dice | 23 | 13 |  | 800 |  | 6.25 |  | 36 |  |  | 11141 | 690
2012-01-23 00:00:00 | B | NY DOD | NY Cortland | Red slices | 38 |  |  | 800 |  | 3.5 |  | 36 |  |  | 12500 | 750
2012-01-27 00:00:00 | B | NY DOD | NY Cortland | Red slices | 108 |  |  | 800 |  | 9.5 |  | 52 |  |  | 37750 | 525
2012-01-30 00:00:00 | B | McDonald's | [NAME] | 1.2oz | 108 |  |  | 800 |  | 8.75 |  | 43 |  |  | 27435 | 375
2012-02-01 00:00:00 | B | McDonald's | [NAME] | 1.2oz | 117 |  |  | 800 |  | 9 |  | 37 |  |  | 23520 | 735
2012-02-02 00:00:00 | B | McDonald's | Jonagold | 1.2oz | 112 |  |  | 800 |  | 9.6 |  | 40 |  |  | 27405 | 525
2012-02-03 00:00:00 | B | GFS/Sonic | Empire | Red slices | 78 |  |  | 800 |  | 6.5 |  | 42 |  |  | 27088 | 525
 |  |  | I need to have it sort for 1.2oz and  take the information to the yield page.
 |  |  | I need it to add all the jonathan 1.2 oz total lbs. dumped and total finished lbs.
 |  |  | and all the jonagold 1.2oz total lbs dumped and total finsihed lbs.
 |  |  | I want it to take the information automatically depending on if it meet the criteria.
 |  |  | When we do this the yield sheet will be on a separate workbook from the data.
 |  |  | I tried to use sumifs but it is too hard for me to do.
Spreadsheet: 54c5cd6a-5eed-4337-9dce-63507a26b787
Sheet: 2014-2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Biochemistry
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 7f200cbd-7ad5-4f23-ab8d-749995ece922
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
RHNI | Test | RHNI | Rhizopus nigricans, IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For one allergen: 0.3 mL/For mor | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
RHNI | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
RHNI | Result | RHNI | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6229-9 | Rhizopus nigricans [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 198139d1354666027-how-to-select-non_fill-rows-book-select-no-fill-rows
Sheet: Sheet1

Match 5 and 2 Stars: | 42363919 | 34505412 | $55,462,843 | Rollover 0
Match 5 and 1 Star: | 602940 | 432870 | $789,369 | 2
Match 5: | 66993 | 48097 | $87,708 | 6
[NAME] and 2 Stars: | 4276 | 3070 | $5,598 | 47
[NAME] and 1 Star: | 181.4 | 130.2 | $237.49 | 969
Match 4: | 95 | 68.2 | $124.37 | 1850
Match 3 and 2 Stars: | 52.4 | 37.6 | $68.60 | 2395
[NAME] and 2 Stars: | 16.8 | 12 | $21.99 | 34389
Match 3 and 1 Star: | 12.5 | 9 | $16.37 | 43993
Match 3: | 11.2 | 8.1 | $14.66 | 82263
Match 1 and 2 Stars: | 9.3 | 6.7 | $12.18 | 174096
[NAME] and 1 Star: | 7.1 | 5.1 | $9.30 | 615881
Match 2: | 3.8 | 2.7 | $4.98 | 1169425
Spreadsheet: 226505d1365429658-need-urgent-help-with-solver-it-does-not-change-value-qn3
Sheet: Qn 3

 | [NAME] |  |  |  |  | Demand |  |  |  |  |  |  | [NAME] per trip
Factory | A | B | C |  | Shop | P | Q | R | S | T |  |  | 180
Units | 4000 | 2000 | 1500 |  | Unit | 1000 | 1600 | 1500 | 2000 | 1400
Mileage per trip |  |  |  |  |  |  |  |  |  |  |  |  | COST
 | P | Q | R | S | T |  |  |  |  |  |  | MILEAGE COST /MILE | 15
A | 100 | 140 | 200 | 150 | 35
B | 50 | 65 | 60 | 70 | 80
C | 40 | 150 | 100 | 90 | 130
 | No of trip |  |  |  |  |  |  | No of units
 | P | Q | R | S | T |  |  | P | Q | R | S | T | Total
A |  |  |  |  |  |  |  | 1000 | 1600 | 0 | 0 | 1400
B |  |  |  |  |  |  |  | 0 | 0 | 0 | 2000 | 0
C |  |  |  |  |  |  |  | 0 | 0 | 1500 | 0 | 0
 |  |  |  |  |  |  | Total
Cost
 | P | Q | R | S | T | Total
A
B
C
 | Total cost
Spreadsheet: 722729d1615388067-input-cell-value-from-another-sheet-and-have-it-output-another-cells-value-in-other-sheet-master-st-albans-carpentry-and-lofts-work-sheet
Sheet: Master

Job Number: |  |  |  |  |  |  |  |  | Parts & Sub-Contractor Invoices
Date | Office Notes | Attendance Date | ID | Employee | Description of Works | Hours on Site | Parking Cost | Congestion Charge | Date of Invoice | Supplier/Sub-Contractor Name | Description of Works/Materials | Invoice Number | Parts Cost | Total Cost??
 |  | 2021-03-10 00:00:00 | 1 |  | Installed garden fence | 28 | 12 | 23 | 10 | BNQ | FENCE PANELS |  | 34234
Spreadsheet: 815781d1675194518-looking-for-a-formula-that-sums-depending-on-specific-dates-problem-excel
Sheet: Sheet1

Starting | Ending |  | Customer | Item | 202301 | 202302 | 202303 | 202304 | 202305 | 202306 | 202307 | 202308 | 202309 | ----> in weeks |  | Total
202301 | 202305 |  | Comp A | X | 2 | 6 | 9 | 1 | 0 | 2 | 8 | 1 | 2 | ------> Number of products |  | Sum of every row if Period is between 202301 and 202305
 |  |  | Comp B | Y | 4 | 7 | 5 | 0 | 3 | 0 | 9 | 7 | 2 |  |  | When changing the starting and ending period it should automatically
 |  |  | Comp C | X | 1 | 2 | 3 | 4 | 9 | 0 | 7 | 0 | 5 |  |  | update. Basically only the blue cells are input, yellow is data and the formula needed is the output for every single row