tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 10688e21-50c7-42b3-9f2f-b7d2c537a667
Sheet: L

 | COURSES IN RED ARE GENERAL EDUCATION COURSES FOR FALL  2012 |  |  | PURPLE J-TERM |  | GREEN BOTH FALL & J-TERM
Latin | AOK designation | CAR designation | Comment
LATN 211 & 212 or LATN 215 | Foreign Language
LATN 341 | Arts & Literature-Literature
LATN 342 | Arts & Literature-Literature
LATN 343 | Arts & Literature-Literature
LATN 344 | Arts & Literature-Literature
LATN 345 | Arts & Literature-Literature
LATN 346 | Arts & Literature-Literature
LATN 347 | Arts & Literature-Literature
LATN 348 | Arts & Literature-Literature
LATN 481-482 |  | Experiential-Research
LATN 487-488 |  | Experiential-Research
LATN 496-498 |  | Experiential-Research
Spreadsheet: 176172d1345746668-custom-number-format-book2
Sheet: Sheet1

2011-07-22 00:00:00 | 2011-07-01 00:00:00 | or | Jul | or | Jul - 11
2011-07-25 00:00:00 | 2011-07-01 00:00:00 |  | Jul |  | Jul - 11
2011-07-26 00:00:00 | 2011-07-01 00:00:00 |  | Jul |  | Jul - 11
2011-07-27 00:00:00 | 2011-07-01 00:00:00 |  | Jul |  | Jul - 11
2011-07-28 00:00:00 | 2011-07-01 00:00:00 |  | Jul |  | Jul - 11
2011-07-29 00:00:00 | 2011-07-01 00:00:00 |  | Jul |  | Jul - 11
2011-08-01 00:00:00 | 2011-08-01 00:00:00 |  | Aug |  | Aug - 11
2011-08-02 00:00:00 | 2011-08-01 00:00:00 |  | Aug |  | Aug - 11
2011-08-03 00:00:00 | 2011-08-01 00:00:00 |  | Aug |  | Aug - 11
2011-08-04 00:00:00 | 2011-08-01 00:00:00 |  | Aug |  | Aug - 11
2011-08-05 00:00:00 | 2011-08-01 00:00:00 |  | Aug |  | Aug - 11
2011-08-08 00:00:00 | 2011-08-01 00:00:00 |  | Aug |  | Aug - 11
2011-08-09 00:00:00 | 2011-08-01 00:00:00 |  | Aug |  | Aug - 11
2011-08-10 00:00:00 | 2011-08-01 00:00:00 |  | Aug |  | Aug - 11
2011-08-11 00:00:00 | 2011-08-01 00:00:00 |  | Aug |  | Aug - 11
2011-08-12 00:00:00 | 2011-08-01 00:00:00 |  | Aug |  | Aug - 11
2011-08-15 00:00:00 | 2011-08-01 00:00:00 |  | Aug |  | Aug - 11
2011-08-16 00:00:00 | 2011-08-01 00:00:00 |  | Aug |  | Aug - 11
2011-08-17 00:00:00 | 2011-08-01 00:00:00 |  | Aug |  | Aug - 11
2011-08-18 00:00:00 | 2011-08-01 00:00:00 |  | Aug |  | Aug - 11
2011-08-19 00:00:00 | 2011-08-01 00:00:00 |  | Aug |  | Aug - 11
2011-08-22 00:00:00 | 2011-08-01 00:00:00 |  | Aug |  | Aug - 11
Spreadsheet: gerald_nemec__11521__Purchase Price Adjustment
Sheet: Summary

Combined Companies Post Closing Adjustment to the Purchase Price
Through October, 2000
Additional Due Enron
 |  | Purchase Price Adjustments Through October, 2000
Revenues Increased |  | -1939374.31
Operating and O&M Costs Increased |  | 1660545.07
Equity Earnings Increased |  | 0
Net Federal Tax Expense Increased |  | 0
Affiliate Interest Expense Increased |  | 0
Third Party Interest & Other Income |  | -0.4
Net Income Change |  | -278829.64
Increase in Accounts Receivable - Third Party |  | 159586.74
Cash Advanced to Bighorn |  | 250000
Investment in Fort Union Decreased
Equity Earnings
Received Cash from Fort Union |  | -850582
Lost Creek Gathering Funding |  | 17500
Capital Expenditures |  | 6253378.710000001
Net Affiliate Payable Increases |  | 0
Net Third Party Payable Increases |  | 277.12
Accrued Liabilities Increased |  | -2116.24
Use Tax Payable |  | 0
Deferred Tax Liability Increased
Other Changes (Primarily Quantam and Shapphire) |  | 194696.47
Total |  | 5743911.16
Gathering Fee due Enron (Excess only, per S. Sitter)
July |  | 251159.86
August |  | 234509.31
September |  | 198284.66
Denver office costs due Enron
July |  | 87399.74
August |  | 148524.82
September |  | 170639.57
Total |  | 6834429.120000001
Previously Paid |  | 4705000
Additional Due |  | 2129429.12
Spreadsheet: 296612d1392139433-league-table-based-on-head-to-head-results-general-football-season-with-fixtures-creator
Sheet: Blad1

 |  | All matchen |  |  |  |  |  |  |  |  |  | matches between equal rankings
ranking | team | Matches played | W | D | L | goal saldo | Goals made | points | PSD-rank | matches played | W | D | L | goal saldo | Goals made | points | PSD-rank | loting | result
1 | Fiorentina | 4 | 3 | 0 | 1 | 4 | 9 | 9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | 0
2 | Inter Milan | 4 | 3 | 0 | 1 | 3 | 8 | 9 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | 0
3 | Genoa | 4 | 2 | 1 | 1 | 2 | 8 | 7 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | 0
4 | AS Roma | 4 | 2 | 0 | 2 | 0 | 7 | 6 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | loting | 0
4 | AC Milan | 4 | 2 | 0 | 2 | 0 | 7 | 6 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | loting | 0
6 | Juventus | 4 | 2 | 0 | 2 | 0 | 6 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | 0
7 | Wolfsburg | 3 | 1 | 1 | 1 | 0 | 6 | 4 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | 0
8 | [NAME] | 4 | 1 | 0 | 3 | -4 | 5 | 3 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | 0
9 | Bayern Munich | 3 | 1 | 0 | 2 | -2 | 4 | 3 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | 0
10 | [NAME] | 4 | 1 | 0 | 3 | -3 | 4 | 3 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | 0
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 329644d1404375592-calculation-of-mean-meadian-max-from-data-in-a-range-from-to-of-dates-without-vba-excelproblem_if-date-from-to
Sheet: Tabelle1

HH | date | t1 | t2 | xy (%) |  |  | HH |  | TAG | MONAT |  | datum |  | solange es
e | 2013-05-04 00:00:00 | l | w | 5 |  | write by hand -> | e | von | 4 | 1 |  | 4.1.2013
e | 2013-08-08 00:00:00 | l | w | 3 |  |  |  | bis | 5 | 10 |  | 5.10.2013
e | 2013-01-01 00:00:00 | l | w | 2
e | 2013-01-04 00:00:00 | hs | t | 1 |  |  |  |  | l |  | hs
g | 2013-02-12 00:00:00 | hs | t | 5.3 |  |  |  |  | w | t | w | t
g | 2013-05-19 00:00:00 | sss | t | 8 |  |  | e |  | 0
g | 2013-01-17 00:00:00 | ss | t | 4.8 |  |  | g
g | 2013-02-28 00:00:00 | l | w | 8.4 |  |  | k
e | 2013-12-31 00:00:00 | l | w | 0.2 |  |  | …etc
e | 2013-05-04 00:00:00 | l | w | 8.1
e | 2013-08-08 00:00:00 | l | w | 3.6 |  |  |  |  | (I know I have to execute the formula with Ctrl shift and Enter)
e | 2013-01-01 00:00:00 | l | w | 2 |  |  |  |  | I tried many diffrent things like datum(); M3=B2:B23; u.a.
e | 2013-01-04 00:00:00 | l | t | 8 |  |  |  |  | I also tried diffrent formatting
k | 2013-02-12 00:00:00 | l | w | 8.2 |  |  |  |  | please find a solution without VBA
k | 2013-05-19 00:00:00 | hs | t | 6
k | 2013-01-17 00:00:00 | hs | w | 8
i | 2013-02-28 00:00:00 | s | w | 2
i | 2013-12-31 00:00:00 | s | w | 8
i | 2013-02-12 00:00:00 | ss | w | 6
i | 2013-05-19 00:00:00 | sss | t | 8
i | 2013-01-17 00:00:00 | l | t | 5
i | 2013-12-12 00:00:00 | l | w | 4
…etc | …etc | …etc | …etc | …etc
 | >mehrere tausend zeilen [NAME]
Spreadsheet: 400762e5-8683-4271-8d30-e0d043d8299e
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
PBRU | Test | PBRU | Lead, Random, [NAME] | Lead, [NAME], U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) |  |  |  | 2 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 6-mL tube (Supply T465) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 2 mL Collection Instructions: 1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 2 mL | Hemolysis	NA Thawing	Warm OK;  Cold OK Lipemia	NA Icterus	NA Other	NA | 0-4 mcg/L Reference values apply to all ages. | Monday through Friday; 3 p.m. - 9 p.m.; Saturday; 8 a.m. - 3 p.m./Continuously | 1 day | 2 days | 1 | 83655 |  |  |  |  | Rochester
PBRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
PBRU | Result | 60246 | Lead, [NAME], U | Lead, [NAME], U | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 5676-2
Spreadsheet: 01fc3012-3306-4784-9030-fdf70023969c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | SUPPLEMENTAL FUNDS-SOURCE & USE | FY13-14 | FY14-15 | TOTAL 13-15
PURCHASE COST
TOTAL PURCHASE COST |  |  | 0 | 0 | 0
APPRAISAL COSTS
TOTAL APPRAISAL COSTS |  |  | 0 | 0 | 0
INSPECTION COSTS
TOTAL INSPECTION COSTS |  |  | 0 | 0 | 0
OTHER COSTS
TOTAL OTHER COSTS |  |  | 0 | 0 | 0
TOTAL EXPENSES |  |  | 0 | 0 | 0
Spreadsheet: 274855d1383237384-formula-when-the-number-of-referenced-cells-changes-workbook-test
Sheet: Sheet1

Name | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Amount | 3 | 2 | 4 | 1 | 6 | 3 | 2 | 5 | 8
Total for person
Name | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Amount | 3 | 2 | 4 | 1 | 6 | 3 | 2 | 5 | 8
Total for person
Spreadsheet: 3a2b128a-cc48-4fbb-9697-3ab3db151afa
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
FORM E:  Privilege Tax Report Form - City of Portland, Oregon
This form for use by companies subject to a privilege tax (City Code 7.12).
LINE 1a | Name of Company:_______________________________________________________
LINE 1b | Address (city, state, zip):_______________________________________________________
LINE 2 | Reporting Period:  Year:_______
 |  | ____ | Quarterly report: | ___[NAME] | ___Apr-Jun | ___[NAME] | ___Oct-Dec
LINE 3 | Total Revenues Earned in Portland for Reporting Period: |  |  |  |  | $________________
LINE 4 | Revenues Earned in Portland Not Subject to Fee: |  |  |  |  | $________________
 | ( list all by source and amount; attach additional pages if needed )
 | 1. Uncollectibles/bad debt |  |  | $________________
 | 2. Customer late fees & interest |  |  | $________________
 | 3. Federal, state, or local law limitations (specify) |  |  | $________________
 | 4. Other (specify) |  |  | $________________
 | Total |  |  |  |  | $________________
LINE 5 | Subtotal of revenues subject to fee ( subtract LINE 4 from LINE 3 ) |  |  |  |  | $________________
LINE 6 | Compensation rate: |  |  |  |  | 0.05
LINE 7 | Subtotal of fee ( multiply LINE 5 by LINE 6 ) |  |  |  |  | $________________
LINE 8 | Other Credits / Adjustments ( list all by source and amount; attach additional pages if needed ):
 | 1. Franchise or other fees for use of the streets. 7.12.110. |  |  | $________________
 | 2. Other (specify) |  |  | $________________
 | Total |  |  |  |  | $________________
LINE 9 | TOTAL FEE ( Subtract LINE 8 from LINE 7 for net credits; add LINE 8 to LINE 7 for net debits )
 |  |  |  |  |  | $________________
Signature: |  |  |  |  | Date
_____________________________________________________________________________
Print name, title, telephone number and email address
I hereby certify that all statements made in this report and any of its attachments are true, complete and accurate to the best of my knowledge.
Remit to: City of Portland, Office for Community Technology, P.O. Box 745, Portland, OR 97207-0745
Form issue date:  12/29/09
Spreadsheet: 76b7849a-3e83-4dd5-8433-cb34cc562d32
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2469 | 13356 | [NAME] | [NAME] | USA | 0 | 00:36:29 | 00:11:23 | 00:07:30 | 00:22:03 | 02:11:40 | 1 | 03:29:03
2469 | 8089 | [NAME] | Nash | USA | 0 | 00:31:55 | 00:12:04 | 00:07:35 | 00:22:56 | 02:26:44 | 2 | 03:41:13
2469 | 13355 | [NAME] | Hall | GBR | 0 | 00:48:39 | 00:12:56 | 00:08:25 | 00:24:45 | 02:23:48 | 3 | 03:58:34
2469 | 14124 | [NAME] | D'Erbee | BEL | 0 | 00:48:07 | 00:12:49 | 00:08:35 | 00:26:36 | 02:24:39 | 4 | 04:00:43
2469 | 7399 | [NAME] | Turco | ITA | 0 | 00:35:54 | 00:13:03 | 00:08:01 | 00:24:53 | 02:41:04 | 5 | 04:02:53
2469 | 8001 | [NAME] | [NAME] | AUS | 0 | 00:46:45 | 00:18:22 | 00:08:37 | 00:27:15 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 793361d1661431388-function-for-adding-strings-in-one-cell-together-and-rounding-money-amount-on-2-decimals-function
Sheet: function

name | date | Moneyamount | function | Preferred function result
[NAME] | 2022-06-19 00:00:00 | 100 |  | [NAME] | 19-6-2022 | €100
[NAME] | 2022-06-20 00:00:00 | 101 |  | [NAME] | 19-6-2022 | €101
[NAME] | 2022-06-21 00:00:00 | 102 |  | [NAME] | 19-6-2022 | €102
[NAME] | 2022-06-22 00:00:00 | 103 |  | [NAME] | 19-6-2022 | €103
[NAME] | 2022-06-23 00:00:00 | 104 |  | [NAME] | 19-6-2022 | €104
[NAME] | 2022-06-24 00:00:00 | 105 |  | [NAME] | 19-6-2022 | €105
[NAME] | 2022-06-25 00:00:00 | 106 |  | [NAME] | 19-6-2022 | €106
Spreadsheet: 38411d1236598118-excel-2007-issue-with-using-formulas-to-pull-data-from-one-sheet-to-another-lwnnsalariesprojections
Sheet: White Sox

Chicago White Sox | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 |  | Chicago White Sox | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
Actual |  |  |  |  |  |  |  | Operations
Budget | 90 | 90 | 90 | 90 | 90 | 90
Difference |  |  |  |  |  |  |  | Fan Base Factors
 |  |  |  |  |  |  |  | Record Reward
Cost of Goods
Personnel |  |  |  |  |  |  |  | Income
Boshers, [NAME] | ML | ML | ML | ML | ML | ML |  | From Astros | -1
Holt, Brad | ML | ML | ML | ML | ML | ML |  | From Cardinals | -0.4
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | From Cubs | -1.2
Posey, Buster | ML | ML | ML | ML | ML | ML
[NAME] | ML | ML | ML | ML | ML | ML |  | Expenses
Alaniz, Adrian | ML | ML | ML | ML | ML | ML |  | Dellucci, [NAME] | 0.2
Beato, [NAME] | ML | ML | ML | ML | ML | ML |  | Mateo, [NAME] | 0.1
Bell, [NAME] | ML | ML | ML | ML | ML | ML |  | [NAME], [NAME] | 0.2
Buck, Dallas | ML | ML | ML | ML | ML | ML |  | To Astros | 3
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | Vizcaino, [NAME] | 0.2
Crowe, Trevor | ML | ML | ML | ML | ML | ML
Cruz, [NAME] | ML | ML | ML | ML | ML | ML
Doherty, [NAME] | ML | ML | ML | ML | ML | ML
Dorn, [NAME] | ML | ML | ML | ML | ML | ML
Drennen, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Hedrick, Justin | ML | ML | ML | ML | ML | ML
Hefner, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], Blake | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Moscoso, [NAME] | ML | ML | ML | ML | ML | ML
Pichardo, [NAME] | ML | ML | ML | ML | ML | ML
Rodriguez, Joshua | ML | ML | ML | ML | ML | ML
Skelton, [NAME] | ML | ML | ML | ML | ML | ML
Slayden, [NAME] | ML | ML | ML | ML | ML | ML
Still, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], Damon | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Vasquez, [NAME] | ML | ML | ML | ML | ML | ML
Viola, [NAME] | ML | ML | ML | ML | ML | ML
Wood, Blake | ML | ML | ML | ML | ML | ML
Martinez, [NAME] | 14.3
Huff, [NAME] | 14
Ordonez, Magglio | 12.5
Garland, [NAME] | 9
Burrell, [NAME] | 7.9 | 7.9
Matsui, Hideki | 6.8
[NAME], [NAME] | 6.6
Mora, Melvin | 4.3
Fielder, Prince | 3 | A2 | A3
Olsen, [NAME] | 2.7 | A2 | A3
Dobbs, Greg | 2.2
Betancourt, [NAME] | 1.7 | 1.7
Aybar, Willy | 1.5 | A2 | A3
Colon, [NAME] | 1.2
Baek, Cha-Seung | 0.7 | A1 | A2 | A3
[NAME], Dustin | 0.3 | 0.7 | A1 | A2 | A3
[NAME], [NAME] | 0.1
[NAME], [NAME] | 0.1
Spreadsheet: 783643d1655008267-tiered-pricing-waterrates
Sheet: Sheet1

1-10 m3 : 10 x 1,500 = 15,000 |  | Volume Tiers | Rates | Marginal Rates | Usage | Cost
11-15 : 5 x 1.850 = 9.250 |  | 0 | 1500 | 1500 | 100
16-20 : 5 x 2,400 = 12,000 |  | 10 | 1850
> 20 : 80 x 3,000 = 240,000 |  | 15 | 2400
 |  | 20 | 3000
See ….
http://www.mcgimpsey.com/excel/variablerate.html
 |  | Tiers | [NAME] 1 | [NAME] | [NAME] 3 | [NAME] 4 | [NAME] 5
 |  | Volume Tiers | Marginal Rates | Marginal Rates | Marginal Rates | Marginal Rates | Marginal Rates
 |  | 0 | 1500 | 1600 | 1700 | 1800 | 1900
 |  | 10 | 350 | 450 | 450 | 450 | 450
 |  | 15 | 550 | 600 | 600 | 600 | 600
 |  | 20 | 600 | 600 | 600 | 600 | 600
 |  |  | USAGE PER MONTH |  |  |  | TOTAL COST
 |  |  | Jan | Feb | Maret | April
 |  |  | 100 | 120 | 80 | 90 | ???? | <---- | What is the formula for making Total Cost from January to April
Spreadsheet: 140134d1328630972-display-all-cells-info-on-another-worksheet-if-meets-criteria-position-list-example
Sheet: Sheet1

Unique ID | Dept |  | Position
1 | 0100 |  | VP
2 | 0110 |  | VP
3 | 0100 |  | Mgr
4 | 0100 |  | Ast Mgr
5 | 0110 |  | Supervisor
6 | 0100 |  | Supervisor
7 | 0100 |  | Sales Rep
8 | 0110 |  | Lead Sales Rep
Spreadsheet: 167983d1342178848-sumproduct-with-date-restrictions-book1_jayres14
Sheet: Lookups

State | Region
IA | Midwest
IL | Midwest
IN | Midwest
KS | Midwest
MI | Midwest
MN | Midwest
MO | Midwest
ND | Midwest
NE | Midwest
OH | Midwest
SD | Midwest
WI | Midwest
CT | Notheast
MA | Notheast
ME | Notheast
NH | Notheast
NJ | Notheast
NY | Notheast
PA | Notheast
RI | Notheast
VT | Notheast
AL | Pacific
HI | Pacific
AL | South
AR | South
DE | South
FL | South
GA | South
KY | South
LA | South
MD | South
MS | South
NC | South
OK | South
SC | South
TN | South
TX | South
VA | South
VA | South
WV | South
AZ | West
CA | West
CO | West
ID | West
MT | West
NM | West
NV | West
OR | West
UT | West
WA | West
WY | West
Spreadsheet: 685820d1594213934-counting-pieces-in-a-lump-sentence-2020-07-08-oeldere-complus865-685818d1594213069-counting-pieces-in-a-lump-sentence-stocktake-
Sheet: Oeldere

month | artikcle | Value
January | balloon | 10 |  | Som van Value | Kolomlabels
February | IWD | 2 |  | Rijlabels | balloon | Basketball | IWD | Softball | Tennis | (leeg) | Eindtotaal |  |  |  | Quantity
February | Basketball | 6 |  | April
March |  |  |  | September |  |  |  |  |  |  |  |  |  | Balloon | 10
April |  |  |  | November |  |  |  |  |  |  |  |  |  | Basketball | 15
May | Basketball | 8 |  | December |  |  |  |  |  |  |  |  |  | IWD | 2
May | Tennis | 7 |  | August
May | Softball | 2 |  | February |  | 6 | 2 |  |  |  | 8
June |  |  |  | January | 10 |  |  |  |  |  | 10 |  |  | Tennis | 7
July |  |  |  | July |  |  |  |  |  |  |  |  |  | Softball | 2
August |  |  |  | June
September |  |  |  | March
October |  |  |  | May |  | 8 |  | 2 | 7 |  | 17
November |  |  |  | October
December |  |  |  | (leeg)
 |  |  |  | Eindtotaal | 10 | 14 | 2 | 2 | 7 |  | 35
Hi, i have an excel here where my colleague has been working on.
I would like to count the quantity of each sports, but as the input was lumped together in an example sentence "basketball = 3 pcs" in a cell.
I am not sure exactly if vlookup or sumif can works.
One method i can think of is by dividing the cell using "text to column" into 2 columns "basket" and "3 pcs".
From there, use vlookup or sumif.
But i would like to know if there are other faster methods that can works too.
Spreadsheet: 730088d1619540598-help-with-date-range-within-countifs-formula-example
Sheet: Sheet1

w/c Monday | w/e Sunday |  | Bugs
2020-10-19 00:00:00 | 2020-10-25 00:00:00
2020-10-26 00:00:00 | 2020-11-01 00:00:00
2020-11-02 00:00:00 | 2020-11-08 00:00:00
2020-11-09 00:00:00 | 2020-11-15 00:00:00
2020-11-16 00:00:00 | 2020-11-22 00:00:00
2020-11-23 00:00:00 | 2020-11-29 00:00:00
2020-11-30 00:00:00 | 2020-12-06 00:00:00
2020-12-07 00:00:00 | 2020-12-13 00:00:00
2020-12-14 00:00:00 | 2020-12-20 00:00:00
2020-12-21 00:00:00 | 2020-12-27 00:00:00
2020-12-28 00:00:00 | 2021-01-03 00:00:00
2021-01-04 00:00:00 | 2021-01-10 00:00:00
2021-01-11 00:00:00 | 2021-01-17 00:00:00
2021-01-18 00:00:00 | 2021-01-24 00:00:00
2021-01-25 00:00:00 | 2021-01-31 00:00:00
2021-02-01 00:00:00 | 2021-02-07 00:00:00
2021-02-08 00:00:00 | 2021-02-14 00:00:00
2021-02-15 00:00:00 | 2021-02-21 00:00:00
2021-02-22 00:00:00 | 2021-02-28 00:00:00
2021-03-01 00:00:00 | 2021-03-07 00:00:00
2021-03-08 00:00:00 | 2021-03-14 00:00:00
2021-03-15 00:00:00 | 2021-03-21 00:00:00
2021-03-22 00:00:00 | 2021-03-28 00:00:00
2021-03-29 00:00:00 | 2021-04-04 00:00:00
2021-04-05 00:00:00 | 2021-04-11 00:00:00
2021-04-12 00:00:00 | 2021-04-18 00:00:00
2021-04-19 00:00:00 | 2021-04-25 00:00:00
2021-04-26 00:00:00 | 2021-05-02 00:00:00
2021-05-03 00:00:00 | 2021-05-09 00:00:00
2021-05-10 00:00:00 | 2021-05-16 00:00:00
2021-05-17 00:00:00 | 2021-05-23 00:00:00
2021-05-24 00:00:00 | 2021-05-30 00:00:00
2021-05-31 00:00:00 | 2021-06-06 00:00:00
2021-06-07 00:00:00 | 2021-06-13 00:00:00
2021-06-14 00:00:00 | 2021-06-20 00:00:00
2021-06-21 00:00:00 | 2021-06-27 00:00:00
2021-06-28 00:00:00 | 2021-07-04 00:00:00
2021-07-05 00:00:00 | 2021-07-11 00:00:00
2021-07-12 00:00:00 | 2021-07-18 00:00:00
2021-07-19 00:00:00 | 2021-07-25 00:00:00
2021-07-26 00:00:00 | 2021-08-01 00:00:00
2021-08-02 00:00:00 | 2021-08-08 00:00:00
2021-08-09 00:00:00 | 2021-08-15 00:00:00
2021-08-16 00:00:00 | 2021-08-22 00:00:00
2021-08-23 00:00:00 | 2021-08-29 00:00:00
2021-08-30 00:00:00 | 2021-09-05 00:00:00
2021-09-06 00:00:00 | 2021-09-12 00:00:00
2021-09-13 00:00:00 | 2021-09-19 00:00:00
2021-09-20 00:00:00 | 2021-09-26 00:00:00
2021-09-27 00:00:00 | 2021-10-03 00:00:00
2021-10-04 00:00:00 | 2021-10-10 00:00:00
2021-10-11 00:00:00 | 2021-10-17 00:00:00
2021-10-18 00:00:00 | 2021-10-24 00:00:00
2021-10-25 00:00:00 | 2021-10-31 00:00:00
2021-11-01 00:00:00 | 2021-11-07 00:00:00
2021-11-08 00:00:00 | 2021-11-14 00:00:00
2021-11-15 00:00:00 | 2021-11-21 00:00:00
2021-11-22 00:00:00 | 2021-11-28 00:00:00
2021-11-29 00:00:00 | 2021-12-05 00:00:00
2021-12-06 00:00:00 | 2021-12-12 00:00:00
2021-12-13 00:00:00 | 2021-12-19 00:00:00
2021-12-20 00:00:00 | 2021-12-26 00:00:00
2021-12-27 00:00:00 | 2022-01-02 00:00:00
Spreadsheet: 77281d1277788041-removing-duplicates-that-are-not-being-detected-sample-duplicates
Sheet: Sheet1

[NAME] | BEI Associates Inc. | [PHONE] | Michigan
[NAME] | BEI Associates Inc. | [PHONE] | Michigan
[NAME] | Lankford & Associates Consulting Engineers Inc. | [PHONE] | Alabama Arizona Arkansas California Colorado Connecticut Illinois Indiana Iowa Kansas Kentucky Maine Maryland Michigan Minnesota Mississippi Missouri Nebraska New Mexico North Carolina Ohio Oklahoma Oregon Rhode Island South Carolina South Dakota Texas Virginia Wisconsin Wyoming
[NAME] | [NAME] | [PHONE] | Maine Massachusetts
[NAME] | [NAME] | [PHONE] | Maine Massachusetts
[NAME] | Consolidated Engineering Services | [PHONE] | Connecticut District of Columbia Illinois Maryland Virginia
[NAME] | EMCOR Government Services | [PHONE] | Colorado Connecticut District of Columbia Illinois Maryland North Carolina Texas Virginia
[NAME] | Oakhill Engineering | [PHONE] | California Indiana Michigan
[NAME] | Oakhill Engineering | [PHONE] | California Indiana Michigan
[NAME] | ninsula Engineering | [PHONE] | Alabama California Colorado Florida Georgia Louisiana Mississippi Missouri North Carolina nnsylvania Puerto Rico South Carolina Tennessee Texas U.S. Minor Outlying Islands Virginia
[NAME] | ninsula Engineering | [PHONE] | Alabama California Colorado Florida Georgia Louisiana Mississippi Missouri North Carolina nnsylvania Puerto Rico South Carolina Tennessee Texas U.S. Minor Outlying Islands Virginia
[NAME] | [NAME] | [PHONE] | Arizona District of Columbia Maryland Massachusetts Texas
[NAME] | [NAME] | [PHONE] | Arizona District of Columbia Maryland Massachusetts Texas