tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 726770d1617444940-sumifs-function-doesnt-calculate-values-as-expected-accounting-module-1-sumproduct
Sheet: Journal Entries

 | MONTHLY EXPENSES SUMMARY |  | CHARITABLES & SPONSORSHIPS
 | Journal Entries
 | Date | Item Code | Descrtiption of Transaction | Amt. | Transaction Type | Ref/ Invoice No. | Cheque No. | Request/ Received By | Journal Entry By | Payee/Donor Details | Debit Amt. | Credit Amt. |  |  |  | Month | Date
 | 2018-01-21 00:00:00 |  | Internet Charges | 2000 | Credit
 | 2018-02-25 00:00:00 |  | Building Rent | 35000 | Credit
 | 2018-12-20 00:00:00 |  | Statationery | 1500
 | 2018-12-21 00:00:00 |  | Statationery | 2500
 | 2018-12-22 00:00:00 |  | Furniture
 | 2018-12-23 00:00:00 |  | Statationery
 | 2018-12-24 00:00:00 |  | Computers
 | 2018-12-25 00:00:00 |  | Fuel
 | 2018-12-26 00:00:00 |  | Building Rent
 |  |  | Document Charges
 |  |  | [NAME]
Spreadsheet: 486028d1477269460-non-array-formula-to-pull-unique-values-and-sort-in-a-range-non-array-formula-to-pull-unique-values-and-sort-in-a-range
Sheet: Sheet1

Vermont
Illinois
Utah
Minnesota
Florida
Wyoming
North Dakota
Maryland
Colorado
Colorado
Texas
Arizona
New Jersey
Wyoming
Wyoming
Nebraska
New Jersey
Connecticut
Massachusetts
Louisiana
Idaho
Utah
North Carolina
South Dakota
Nevada
Spreadsheet: 3155c0a8-3a12-41e1-bb98-7ea7829b2203
Sheet: Sheet1

Northern New Jersey Council | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Show-n-Sell Order Worksheet
Number of Selling Hours* | 20 | Enter data
 | Total | Retail | Product Mix
Item | Cases | Price | Containers |  |  | cont | Cases
White Chocolatey Pretzels | 7 | 22 | 0.05 |  |  | 6.138392857142858 | 6.138392857142858
Sweet & Savory Collection | 2 | 40 | 0.015 |  |  | 1.841517857142857 | 1.841517857142857
Cheese Lover's Collection | 3 | 30 | 0.02 |  |  | 2.455357142857143 | 2.455357142857143
18--pack [NAME] | 1 | 22 | 0.03 |  |  | 3.683035714285714 | 0.6138392857142857
18-pack [NAME] | 3 | 18 | 0.11 |  |  | 13.50446428571428 | 2.250744047619047
18-pack Butter Light | 3 | 18 | 0.1 |  |  | 12.27678571428572 | 2.046130952380953
[NAME] | 2 | 18 | 0.09 |  |  | 11.04910714285714 | 1.381138392857143
Gourmet Caramel Corn with Almonds, Pecans and Cashews | 2 | 18 | 0.115 |  |  | 14.11830357142857 | 1.764787946428571
Butter Toffee Caramel Corn | 1 | 18 | 0.06 |  |  | 7.366071428571428 | 0.9207589285714285
11oz Caramel Corn | 4 | 10 | 0.38 |  |  | 46.65178571428572 | 3.88764880952381
Popping Corn | 1 | 10 | 0.03 |  |  | 3.683035714285714 | 0.6138392857142857
 |  |  |  |  |  | 122.7678571428571
Estimated Total Containers | 122.7678571428571 | Average Retail per Container
Gross Sales | 2500 | 20.36363636363636
Base Commission | 750
 | 0.3 | Average Unit Profit per Container
Bonus Commission Potential | 175 | 6.109090909090908
 | 0.07
Total Commission Potential | 925
*Units usually sell at a rate of $125 per hour
Spreadsheet: 494106d1482178506-transpose-based-on-criteria-transpose-1-
Sheet: Folha1

 |  |  |  | A | B | C
 | A | 1
 | B | 20
 | B | 3
 | B | 2
 | C | 14
 | A | 5
 | C | 3
 | A | 2
 | B | 7
Spreadsheet: 811383d1672459867-need-formula-to-calculate-average-state-total-fuel-expense-and-price-per-gallon-average-need-formula-to-calculate-average-state-total-fuel-expense-and-price-per-gallon-average
Sheet: Sheet1

Need formula to calculate average state total fuel expense and price per gallon average
https://www.excelforum.com/excel-formulas-and-functions/1396560-need-formula-to-calculate-average-state-total-fuel-expense-and-price-per-gallon-average.html
Type | Amount | State | PPG |  | Arizona Amount Average |  |  | Average of Amount | State
Diesel | 170.54 | AZ | 5.12 |  | Diesel |  |  | Type | AZ | CA | Grand Total
DEF | 25.32 | AZ | 3.99 |  | DEF |  |  | Diesel | 199.1666666666667 | 205.9 | 201.86
DEF | 32.54 | CA | 3.99 |  |  |  |  | DEF | 24.7925 | 37.59666666666666 | 30.28
DEF | 41.21 | CA | 3.99 |  | California Amount Average |  |  | Grand Total | 129.417 | 133.77 | 131.2094117647059
Diesel | 109.56 | CA | 5.08 |  | Diesel
DEF | 19.09 | AZ | 3.97 |  | DEF
Diesel | 220.89 | AZ | 5.11
Diesel | 210.27 | AZ | 5.15 |  | Average PPG
DEF | 25.75 | AZ | 3.95 |  | Diesel | Insert formula here
Diesel | 178.12 | AZ | 5.01 |  | DEF | Insert formula here
Diesel | 164.02 | CA | 5.64
Diesel | 225.09 | AZ | 5.12
Diesel | 179.01 | CA | 5.15
Diesel | 190.09 | AZ | 5.1
DEF | 29.01 | AZ | 5.01
Diesel | 371.01 | CA | 5.5
DEF | 39.04 | CA | 5.49
Spreadsheet: bc011643-6848-4ae5-bf58-8bf5a41a9103
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
AMPHM | Test | AMPHM | Amphetamine-Type Stimulants, Confirmation, Meconium | Amphetamines, Confirmation, M | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Stool Container: Stool |  |  | 5 | g | Chain-of-custody is recommended for this test. Chain-of-Custody Meconium Kit (Supply T653) is available upon request.      Container/Tube: Stool container (Supply T288) [NAME]: 5 g (approximately 1 tablespoon) Collection Instructions: Collect entire random meconium specimen. Additional Information: 1. For chain-of-custody information, see Chain-of-Custody Meconium Kit (Supply T653). 2. Specimen that arrives with a broken seal does not meet the chain-of-custody requirements. 3. The laboratory recommends sending chain-of-custody specimens by overnight shipment. | 2 g (approximately 1 teaspoon) | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Grossly bloody reject; Pink OK | Negative Positives are reported with a quantitative LC-MS/MS result. [NAME] concentrations: Amphetamine by LC-MS/MS: >50 ng/g Methamphetamine by LC-MS/MS: >50 ng/g 3,4-Methylenedioxyamphetamine by LC-MS/MS: >50 ng/g 3,4-Methylenedioxyethylamphetamine by LC-MS/MS: >50 ng/g 3,4-Methylenedioxymethamphetamine by LC-MS/MS: >50 ng/g | Monday through Friday, Sunday; Varies | 2 days |  | 2 | 82145 |  |  |  |  | Rochester
AMPHM | [NAME] | [NAME] | Meconium |  |  |  | Frozen | 14 days
AMPHM | Result | 31854 | Amphetamine | Amphetamine | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | 43934-9
AMPHM | Result | 31855 | Methamphetamine | Methamphetamine | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | 27289-8
AMPHM | Result | 31856 | 3,4-methylenedioxyamphetamine | 3,4-methylenedioxyamphetamine | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | 27244-3
AMPHM | Result | 31858 | 3,4-methylene-dioxyethylamphetamine | 3,4-methylene-dioxyethylamphetamine | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | 27080-1
AMPHM | Result | 31857 | 3,4-methylene-dioxy-methamphetamine | 3,4-methylene-dioxy-methamphetamine | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | In Process
AMPHM | Result | 31882 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69050-3
AMPHM | Result | 31883 | Chain of Custody | Chain of Custody | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: jeffrey_a_shankman__13783__CA rate exposure 8-26 JT
Sheet: New

NEW CUSTOMERS (DA for first time as of 10/1/01)
PG&E | Utility Undercollection |  |  |  | Bonds |  |  |  | Above Market Contract Cost
 | Scenario | 1 | 2 | 3 |  | 1 | 2 | 3 |  | 1 | 2 | 3
 | % Collected | 0.8 | 0.8 | 0.8 | % Collected | 1 | 1 | 0 | % Collected | 1 | 1 | 0
 | Probability | 0.95 | 0.95 | 0.95 | Probability | 0.3 | 0.3 | 0.3 | Probability | 0.3 | 0.3 | 0.3
Amortization (years)
5
7
10
12
15
Edison | Utility Undercollection |  |  |  | Bonds |  |  |  | Above Market Contract Cost
 | Scenario | 1 | 2 | 3 |  | 1 | 2 | 3 |  | 1 | 2 | 3
 | % Collected | 0.8 | 0.8 | 0.8 | % Collected | 1 | 1 | 0 | % Collected | 1 | 1 | 0
 | Probability | 0.95 | 0.95 | 0.95 | Probability | 0.3 | 0.3 | 0.3 | Probability | 0.3 | 0.3 | 0.3
Amortization (years)
5
7
10
12
15
SDG&E | Utility Undercollection |  |  |  | Bonds |  |  |  | Above Market Contract Cost
 | Scenario | 1 | 2 | 3 |  | 1 | 2 | 3 |  | 1 | 2 | 3
 | % Collected | 0.8 | 0.8 | 0.8 | % Collected | 1 | 1 | 0 | % Collected | 1 | 1 | 0
 | Probability | 0.95 | 0.95 | 0.95 | Probability | 0.3 | 0.3 | 0.3 | Probability | 0.3 | 0.3 | 0.3
Amortization (years)
5
7
10
12
15
Spreadsheet: 482965d1475395265-calculate-the-growth-book2-3-
Sheet: Sheet1

Member | Value | Growth | Growth Increase | Growth Decrease
G0857175P | 30
abcdef | 44
G0857175P | 50
S8774172I | 30
S8774172I | 150
S8734024D | 30
S2699705D | 55
S8026058Z | 25
S8026058Z | 20
Spreadsheet: 766640d1643980558-populating-cells-with-data-from-another-sheet-using-dropdown-managementcoveragesample
Sheet: Overlap

Select Supervisor Below | List |  | Name | Schedule | Overlap
[NAME] | [NAME] |  | [NAME], [NAME] | 5/8 | 80
 | [NAME] |  | Pal, Gal | 5/8 | 70
 |  |  | Woman, [NAME] | 5/8 | 70
 |  |  | Kent, [NAME] | 4/10 | 50.5
 |  |  | Wayne, [NAME] | VarDay | 45
Spreadsheet: 541650d1507463723-count-of-rows-where-multiple-criteria-are-met-book1
Sheet: Sheet1

1 | 2 | 3 | 4
1 | 3 | 5 | 7
2 | 4 | 5 | 6
1 | 3 | 4 | 5
Spreadsheet: joe_parks__14544__EquityEntry
Sheet: Trades

0
Open Date | Close Date | Account | Symbol | Shares | Purchase Price | Sale Price | Commission | Location | Location Curve | +/- | Desk | Customer | Trade Finished | Commission | Origination | Notes |  | PROCEEDS
2001-12-03 00:00:00 | 2002-03-21 09:27:00 | OP | sunw | 2 | 1.25 | 2.15 | 35
2002-01-01 00:00:00 | 2002-03-21 09:29:00 | OP | QQQ | 5 | 1.15 | 1.35 | 15
Spreadsheet: 201417d1355982849-basic-forecasting-method-used-on-excel-book1
Sheet: Sheet1

 | 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 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
 | 536800 | 222450 | 604200 | 655400 | 437550 | 763350 | 85600 | 204400 | 310200 | 252550 | 366500 | 217550 | 440850 | 428450 | 767400 | 856330 | 640713 | 481875 | 1079250 | 549450 | 500700 | 277100 | 639400 | 333650
Spreadsheet: lisa_gang__22247__EPE_APRIL_2002
Sheet: APRIL (3)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-04-03 00:00:00
HR ENDING | HR ENDING | FOUR CORNERS
Pacific | Mountain | SALE
Standard | Standard | EPMI
Time | Time | 22.25
 |  | CARRY OVER FROM 4/2
 |  | 4/1/02-4/30/02
 |  | EPMI TAG#41815 |  |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST | DIRECT BILL
2400 | 0100 | 25
0100 | 0200 | 0
0200 | 0300 | 0
0300 | 0400 | 0
0400 | 0500 | 0
0500 | 0600 | 0
0600 | 0700 | 0
0700 | 0800 | 0
0800 | 0900 | 0
0900 | 1000 | 0
1000 | 1100 | 0
1100 | 1200 | 0
1200 | 1300 | 0
1300 | 1400 | 0
1400 | 1500 | 0
1500 | 1600 | 0
1600 | 1700 | 0
1700 | 1800 | 0
1800 | 1900 | 0
1900 | 2000 | 0
2000 | 2100 | 0
2100 | 2200 | 0
2200 | 2300 | 0
2300 | 2400 | 0
2400 | 0100 | 0
 | MST Total |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  | TOTAL SALES | TOTAL PURCHASES
 | PST TOTAL
 |  | EPE(G)4C
 |  | EPMI
 |  | AZPS(T)FC3/PPD2
 |  | WALC(T)PPD2/COOLIDGE
 |  | CRSP(L)COOLIDGE
Spreadsheet: 710416d1608946934-formula-to-count-and-label-number-of-clinic-visits-over-time-sample-data-oedema
Sheet: Sheet4

date | [NAME] | visit (formula) | Visit (manual)
2018-03-12 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 1
2018-03-19 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 2
2018-03-26 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 3
2018-04-09 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 4
2018-04-16 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 5
2018-04-23 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 6
2018-04-30 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 7
2018-05-03 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 8
2018-05-17 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 9
2018-05-22 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 10
2018-05-29 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 11
2018-06-05 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 12
2018-06-12 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 13
2018-06-19 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 14
2018-06-26 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 15
2018-06-28 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 16
2018-07-12 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 17
2018-07-26 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 18
2018-08-09 | 7f90f587-7c84-4223-bc74-813645f4fdd9 |  | 19
2017-05-23 | 83653333-b057-489d-805a-19e901b29e7c |  | 1
2017-05-30 | 83653333-b057-489d-805a-19e901b29e7c |  | 2
2017-06-06 | 83653333-b057-489d-805a-19e901b29e7c |  | 3
2017-06-12 | 83653333-b057-489d-805a-19e901b29e7c |  | 4
2017-06-20 | 83653333-b057-489d-805a-19e901b29e7c |  | 5
2017-06-27 | 83653333-b057-489d-805a-19e901b29e7c |  | 6
2017-07-04 | 83653333-b057-489d-805a-19e901b29e7c |  | 7
2017-07-11 | 83653333-b057-489d-805a-19e901b29e7c |  | 8
2017-07-18 | 83653333-b057-489d-805a-19e901b29e7c |  | 9
2017-07-25 | 83653333-b057-489d-805a-19e901b29e7c |  | 10
2017-08-01 | 83653333-b057-489d-805a-19e901b29e7c |  | 11
2017-08-09 | 83653333-b057-489d-805a-19e901b29e7c |  | 12
2017-08-23 | 83653333-b057-489d-805a-19e901b29e7c |  | 13
2017-09-06 | 83653333-b057-489d-805a-19e901b29e7c |  | 14
2017-09-20 | 83653333-b057-489d-805a-19e901b29e7c |  | 15
2017-10-04 | 83653333-b057-489d-805a-19e901b29e7c |  | 16
2017-10-18 | 83653333-b057-489d-805a-19e901b29e7c |  | 17
Spreadsheet: 92649d1292237606-many-user-open-same-excel-sharing
Sheet: Sheet1

example one
this is no good becauseas jobs come in  everyone may try to select any cell
date | done by | job reference | pass fail
2010-12-13 00:00:00 | mw | 1001 | pass
2010-12-13 00:00:00 | fdwc | 1004 | fail
2010-12-14 00:00:00 | xyz | 1002 | pass
this is better because jobs were pre listed in col a and only one user is likely to update any field
job reference | date | done by | pass/fail
1001 | 2010-12-13 00:00:00 | mw | pass
1002 | 2010-12-14 00:00:00 | xyz | pass
1003
1004 | 2010-12-13 00:00:00 | fdwc | fail
Spreadsheet: 476914d1472064702-can-someone-tell-me-how-this-worksheet-is-changing-the-unused-cells-and-how-to-recreate-test
Sheet: test

Data 1 | Data 2 | Data 3
a | 1 | state
b | 2 | state
c | 3 | state
d | 4 | state
c | 5 | state
d | 6 | state
c | 7 | state
d | 8 | state
c | 9 | state
d | 10 | state
c | 11 | state
d | 12 | state
c | 13 | state
d | 14 | state
c | 15 | state
d | 16 | state
c | 17 | state
d | 18 | state
Spreadsheet: 160787-count-the-number-of-populated-cells-in-column-n-based-on-data-in-column-d-june-202012-20doc-1-
Sheet: KPI's

 |  |  |  | £400 METAL MIN OBJECTIVE |  | £300 FINANCE MIN OBJECTIVE |  |  |  | MIN 35% |  | MIN 35% |  | MIN 20% |  | MIN 10% | MIN 100%
 |  | [NAME] | Confirmed Deals |  | Retail Metal (PPU) | F&I Income (PPU) | Total PPU | Finance Pen% | Gap Profit | GAP Pen% | P/Guard Profit | P/G Pen% | [NAME] | Tyre Pen% | Smart Profit | Smart Pen% | AV PROD SOLD
 |  | [NAME]
 |  | BB
 |  | SO
 |  | RH
 |  | Other
Spreadsheet: 0982691f-22b9-4749-9a77-0bdab6b07a06
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
LEPTO | Test | LEPTO | [NAME], Serum | [NAME], S | Indirect Hemagglutination | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative | Monday, Wednesday, Friday; 9 a.m. | 1 day if negative 2 days if positive | 5 days | 1 | 86720 |  |  |  |  | Rochester
LEPTO | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
LEPTO | Result | 9697 | [NAME], S | [NAME], S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23196-9 | [NAME]:ACnc:Pt:Ser:Ord:
Spreadsheet: 457058d1461180527-value-lookups-from-a-table-rccs-refi
Sheet: Conventional

 | Your actual rate, payment, and costs could be higher. Get an official [NAME] before choosing a loan.
 |  |  |  |  |  | NMLS:
 |  |  |  |  |  | Office:
 |  |  |  |  |  | Cell:
 |  |  |  |  |  | Fax:
 |  |  |  |  |  | [NAME]:
 | Loan Program: Conventional Fixed
 | Loan Details |  |  |  |  | Monthly Payment Information
 | Estimated Value |  |  |  |  | Principal and Interest |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Property Taxes |  |  |  |  |  | [NAME] | 0.45
 | Total Loan Amount |  |  |  |  | Estimated Homeowners Insurance |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Mortgage Insurance |  | 0.85 |  |  |  | PMI Percentage
 |  |  |  |  |  | Homeowners Association Dues |  |  | 0 |  |  | [NAME]
 | Interest Rate |  |  | 0.03875 |  |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  | 30
 | Discount Points |  |  | 0
 | Number of Units |  |  | 1 |  | Total Monthly Payment
 | Cash to Close Amounts
 | Closing Costs
 | Prepaid Costs
 |  | Total
 | Closing Costs |  |  |  |  | Prepaid Expenses
 | [NAME] fee |  |  |  |  | Interest | 15 | days
 | [NAME] |  |  | 750 |  | Taxes | 7 | months
 | Discount Points |  |  |  |  | Homeowners Insurance | 14 | months
 | Credit Report fee |  |  | 50 |  | Homeowners Dues | 0 | months
 | Wire fee |  |  | 40 |  |  |  |  | 0
 | [NAME] fee |  |  | 290
 | Tax registration fee |  |  | 72 |  | Total
 | Flood Certification |  |  | 11 |  | Income Ratios
 | Title Closing fees |  |  | 250
 | Title Insurance - ALTA |  |  |  |  | Income
 | Recording Fees |  |  | 100 |  | Monthly debts
 |  |  |  | 0 |  | Housing Ratio
 | Total |  |  |  |  | [NAME]
Spreadsheet: a401270f-3a75-41e8-b422-5bdfefcb1a11
Sheet: MD

CC ID | Type | Plant | City | State | ID | CBI | Status | Desig | Handles CCW? | Electric Utility? | Special Waste Addition? | Latitude | Longitude | Lined* | Is Leachate Collected? | Distance from Nearest Surface Waterbody (Ft.) | Year Initially Brought Online Or Planned to be Brought Online | Inactive | Representative | Party | Congressional District ID
[NAME].SPD-5 | Pond | [NAME] | Baltimore | MD | SPD-5 | 0 | Active/Inactive/Open Pond/Impoundment Units | 01 Lagoon | YES | YES | NO | 39.184444 | -76.536667 | Yes | No | 1900 | 1984 | No | [NAME] | Democrat | 2402
[NAME].SPD-6 | Pond | [NAME] | Baltimore | MD | SPD-6 | 0 | Active/Inactive/Open Pond/Impoundment Units | 02 Lagoon | YES | YES | NO | 39.184444 | -76.536667 | Yes | No | 1900 | 1984 | No | [NAME] | Democrat | 2402
[NAME].SPD-7 | Pond | [NAME] | Baltimore | MD | SPD-7 | 0 | Active/Inactive/Open Pond/Impoundment Units | 03 Lagoon | YES | YES | NO | 39.184444 | -76.536667 | Yes | No | 1900 | 1988 | No | [NAME] | Democrat | 2402
Chalk Point LLC.LANDFILL-1 | Landfill | Chalk Point LLC | Aquasco | MD | LANDFILL-1 | 0 | Active/Inactive/Open Landfills | brandywine | YES | YES | NO | 38.705833 | -76.802778 | Yes | Yes | 30 | 1972 | No | [NAME] | Democrat | 2405
[NAME].LANDFILL-2 | Landfill | [NAME] | Dickersburg | MD | LANDFILL-2 | 0 | Active/Inactive/Open Landfills | [NAME] Site | YES | YES | NO | 39.192222 | -77.4575 | Yes | Yes | 500 | 1980 | No | [NAME] | Democrat | 2408
Morgantown Generating Plant.LANDFILL-2 | Landfill | Morgantown Generating Plant | Newburg | MD | LANDFILL-2 | 0 | Active/Inactive/Open Landfills | [NAME] | YES | YES | NO | 38.437389 | -76.959528 | Yes | Yes | 520 | 1970 | Yes | [NAME] | Democrat | 2405
Morgantown Generating Plant.SPD-2 | Pond | Morgantown Generating Plant | Newburg | MD | SPD-2 | 0 | Active/Inactive/Open Pond/Impoundment Units | Primary Settling Pond | YES | YES | NO | 38.361667 | -76.978611 | No | No | 150 | 1970 | No | [NAME] | Democrat | 2405
Morgantown Generating Plant.SPD-3 | Pond | Morgantown Generating Plant | Newburg | MD | SPD-3 | 0 | Active/Inactive/Open Pond/Impoundment Units | Secondary Settling Pond | YES | YES | NO | 38.3625 | -76.979722 | No | No | 150 | 1970 | No | [NAME] | Democrat | 2405
*Does not necessarily mean a composite liner
Spreadsheet: 90068d1289830006-excel-2007-dsum-question-referralsreceived2-example
Sheet: ReferralsReceived

ID | City | Date | Column1 | YesYes | YesNo | No | Grand Total | Total Smoking | City | City | City
1 | 3 | 2010-10-15 00:00:00 |  | 0 | 3 | 2 | 5 | 3 | 1 | 2 | 3
2 | 2 | 2010-10-15 00:00:00 |  | 0 | 4 | 63 | 67 | 4
3 | 1 | 2010-10-15 00:00:00 |  | 0 | 1 | 2 | 3 | 1
4 | 1 | 2010-10-15 00:00:00 |  | 0 | 4 | 41 | 45 | 4
5 | 2 | 2010-10-15 00:00:00 |  | 0 | 11 | 86 | 97 | 11
6 | 2 | 2010-10-19 00:00:00 |  | 3 | 0 | 0 | 3 | 3
9 | 1 | 2010-10-19 00:00:00 |  | 2 | 0 | 0 | 2 | 2
10 | 1 | 2010-10-19 00:00:00 |  | 1 | 0 | 0 | 1 | 1
11 | 3 | 2010-10-19 00:00:00 |  | 3 | 0 | 0 | 3 | 3
12 | 2 | 2010-10-19 00:00:00 |  | 3 | 0 | 0 | 3 | 3
13 | 1 | 2010-10-19 00:00:00 |  | 8 | 0 | 0 | 8 | 8
14 | 1 | 2010-10-19 00:00:00 |  | 3 | 0 | 0 | 3 | 3
15 | 3 | 2010-10-19 00:00:00 |  | 3 | 0 | 0 | 3 | 3
16 | 2 | 2010-10-19 00:00:00 |  | 3 | 0 | 0 | 3 | 3
17 | 1 | 2010-10-19 00:00:00 |  | 2 | 0 | 0 | 2 | 2
18 | 1 | 2010-10-19 00:00:00 |  | 5 | 0 | 0 | 5 | 5
19 | 1 | 2010-10-19 00:00:00 |  | 2 | 0 | 0 | 2 | 2
20 | 3 | 2010-10-19 00:00:00 |  | 1 | 0 | 0 | 1 | 1
21 | 2 | 2010-10-19 00:00:00 |  | 2 | 0 | 0 | 2 | 2
23 | 1 | 2010-10-20 00:00:00 |  | 1 | 1 | 20 | 22 | 2
24 | 3 | 2010-10-20 00:00:00 |  | 0 | 2 | 23 | 25 | 2
25 | 2 | 2010-11-03 00:00:00 |  | 0 | 1 | 26 | 27 | 1
26 | 2 | 2010-11-12 00:00:00 |  | 2 | 2 | 31 | 35 | 4
Spreadsheet: 675610d1588366802-copy-data-between-sheets-having-same-col-names-but-not-col-numbers-hlookup
Sheet: Normalized Template

 |  |  |  | Tags | Open Date | Close Date | Symbol | Action | Units/Lots | SL | TP | Open Price | Close Price | Commission | Swap | Pips
I will have other calcs in columns A-D
Spreadsheet: 41071d1239550327-lookup-question-simplyvlookup
Sheet: Teams

Team 1 | Shares | Price | Value |  | Team 1 | Shares | Price | Value
Company C | 3 |  | 0 |  | Company F | 3 |  | 0
Company D | 5 |  | 0 |  | Company D | 5 |  | 0
Company E | 33 |  | 0 |  | Company E | 33 |  | 0
 |  | Total | 0 |  |  |  | Total | 0
Team 1 | Shares | Price | Value |  | Team 1 | Shares | Price | Value
Company A | 3 |  | 0 |  | Company C | 3 |  | 0
Company F | 5 |  | 0 |  | Company B | 5 |  | 0
Company E | 33 |  | 0 |  | Company E | 33 |  | 0
 |  | Total | 0 |  |  |  | Total | 0
Spreadsheet: 299990d1393346597-generate-list-of-data-based-on-sort-data-from-another-worksheet-blank-training-template-for-troubleshooting
Sheet: Area2

Hidden | Last | First | Area | Shift |  | Status | Seperation Date | Area2 | Task1 | [NAME] | Task3 | Task4 | Task5
G K
H L
I M
J N
K O
L P
N B
O C
P D
Spreadsheet: 752628d1634862410-if-and-formula-with-condition-book1
Sheet: Sheet1

 | CHECK 1 | CHECK 2 |  | THEN COMBINE 1 | THEN COMBINE 2 |  | RESULT SHOULD BE LIKE THIS
 | 3RD PARTY | BRAND |  | P- | 12000 |  | P-12000
 | ARC | BRAND |  | A- | 12000 |  | A-12000
 | 3RD PARTY | ACCOM |  | AC- | 12000 |  | AC-12000
 | 3RD PARTY | DC |  | D- | 12000 |  | D-12000
 | 3RD PARTY | OFFICE |  | OF- | 12000 |  | O-12000
 | ARC | OFFICE |  | OF- | 12000 |  | O-12000
 | 3RD PARTY | warehouse |  | W- | 12000 |  | W-12000
 | IF(AND(B2="3RD PARTY",C2="BRAND"),"P-"&D2),IF(AND(B2="ARC",C2="BRAND"),"A-"&D2)
 |  |  | ALL FORMULA SHOULD BE IN ONE PLACE LIKE ABOVE I MENTIONED
 | HI, i need one formula covering all conditions, if in b2 is "3rd party" and c2 is "brand" then result shoud be "P-12000 AND if i change b2 with "arc" and c2 with "office" then result should be "OF-12000" and so on, but all from b2 to b8 i need conditiond in one formula .I attached the jpeg file . Thanks