tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 288587d1389242768-one-very-large-123-sheets-into-a-tenant-rent-database-rent-spreadsheet
Sheet: Data

 |  |  |  |  |  | http://www.excelforum.com/excel-general/979946-one-very-large-123-sheets-into-a-tenant-rent-database.html
Current Date | 2013-12-08 00:00:00
Unit - Tenant | Date | Check # | Months Paid | Fees | Due | Paid | Balance | Initials | Last Month Paid | Overdue? | Days overdue
[NAME] | 2013-11-26 00:00:00 | #5555 | November-13 Pro-Rated |  | 6.68
[NAME] |  |  | Deposit |  | 20
[NAME] |  |  | 2013-12-13 00:00:00 |  | 50 | 76.68 | 76.68
[NAME] | 2013-12-05 00:00:00 | CC | 2014-01-14 00:00:00 |  | 50 | 50 | 0 | AKS
[NAME] | 2014-01-03 00:00:00 | Cash | 2014-02-01 00:00:00 |  | 50 | 5 | 0 | AKS
B25 - Brad Smith | 2013-11-14 00:00:00 | #6666 | November-13 Pro-Rated |  | 6.68
B25 - Brad Smith |  |  | Deposit |  | 30
B25 - Brad Smith | 2013-12-01 00:00:00 | CC | 2013-12-14 00:00:00 |  | 60 | 50 | 0 | AKS
B25 - Brad Smith | 2013-12-03 00:00:00 | Cash | 2014-01-05 00:00:00 |  | 60 | 5 | 0 | AKS
B26 - Ryan Cotts | 2013-09-24 00:00:00 | #9889 | [NAME] |  | 6.68
B26 - Ryan Cotts |  |  | Deposit |  | 10
B26 - Ryan Cotts |  |  |  |  | 70 | 65.5 | 65.5
B26 - Ryan Cotts | 2013-10-07 00:00:00 | CC | 2013-10-14 00:00:00 |  | 70 | 50 | 0 | AKS
B26 - Ryan Cotts | 2013-11-03 00:00:00 | Cash | 2013-11-01 00:00:00 |  | 70 | 5 | 0 | AKS
C28 - Bill Daly | 2012-09-24 00:00:00 | #9889 |  |  | 6.68
C28 - Bill Daly |  |  | Deposit |  | 10
C28 - Bill Daly |  |  |  |  | 65 | 65.5 | 65.5
C28 - Bill Daly | 2013-10-07 00:00:00 | CC | 2013-05-14 00:00:00 |  | 65 | 65 | 0 | AKS
C28 - Bill Daly | 2013-05-28 00:00:00 | Cash | 2013-06-01 00:00:00 |  | 65 | 65 | 0 | AKS
D308B - [NAME] | 2012-09-24 00:00:00 | #9889 |  |  | 6.68
D308B - [NAME] |  |  | Deposit |  | 10
D308B - [NAME] |  |  |  |  | 45 | 65.5 | 65.5
D308B - [NAME] |  | CC | 2013-02-14 00:00:00 |  | 45 | 45 | 0 | AKS
D308B - [NAME] | 2013-02-03 00:00:00 | Cash | 2013-03-01 00:00:00 |  | 45 | 45 | 0 | AKS
Spreadsheet: 143443d1330425209-referecing-worksheets-and-returning-areas-eol_checker_new_angusdn
Sheet: Pagecount Data

Family |  | Monthly | Annual | 5 year
SWITCHBACK |  | 464
EAGLE EYE |  | 295
MERCURY |  | 2015
SAPPHIRE |  | 2979
[NAME] |  | 1426
THUNDERBIRD |  | 526
TSUNAMI |  | 444
SUN |  | 765
CHEETAH |  | 674
DENALI |  | 1953
EVEREST |  | 3644
ANNAPURNA |  | 2948 |  |  |  |  |  |  | jackal xh
CICADA |  | 315 |  |  |  |  |  |  | [NAME]
NIIHAU |  | 3010 |  |  |  |  |  |  | caracal nw
TAISHAN |  | 665 |  |  |  |  |  |  | caracal
JERSEY |  | 1727 |  |  |  |  |  |  | mamba fskm
ZEBU |  | 4519 |  |  |  |  |  |  | mamba f
ANGUS |  | 2336 |  |  |  |  |  |  | mamba h
BUCK |  | 305 |  |  |  |  |  |  | mamba
MAMBA_JAZ |  | 4636 |  |  |  |  |  |  | [NAME]
Coral |  | 2640 |  |  |  |  |  |  | angus x
King |  | 2811 |  |  |  |  |  |  | angus dn
Kingli |  | 2130 |  |  |  |  |  |  | zebu xh
Garnet |  | 2568 |  |  |  |  |  |  | [NAME]
Sid |  | 159 |  |  |  |  |  |  | [NAME]
Lone Pine |  | 718 |  |  |  |  |  |  | cicada w
Mantis |  | 819 |  |  |  |  |  |  | niihau x
Caracal |  | 276 |  |  |  |  |  |  | niihau dn
 |  |  |  |  |  |  |  |  | niihau d
 |  |  |  |  |  |  |  |  | eagle eye
 |  |  |  |  |  |  |  |  | eagle eye nw
Spreadsheet: 874128d1720698984-capping-a-percentage-of-a-number-added-based-on-the-total-number-test-juli-2024
Sheet: Huidig

 | Adres
 | Meergezinswoning
 | Meergezingswoning40M2
 |  |  |  |  |  |  | m² | Punten | Opmerking
 |  |  |  |  |  |  | m² | Punten
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | # | Punten
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | # | Punten
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Label | Punten
 |  |  |  |  |  |  | A
 |  |  |  |  |  |  | Aantal | Punten
 |  |  |  |  |  |  | 0 | 7
 |  |  |  | Inductie |  |  | 0 | 1.75
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Aantal | Punten
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 | Totaal punten sanitair
 | Renovatie(woningverbetering) |  |  |  |  |  | Aantal | Punten
 | 0,2 punt per €1.000 investering |  |  |  |  |  | 0 | 0 | [NAME] toepassing
 | Privé Buitenruimte |  |  |  |  |  | m² | Punten
 | [NAME], balkon |  |  |  |  |  | 11.5
 | [NAME] |  |  |  |  | m² | Aantal gebruikers | Punten
 |  |  |  |  |  |  |  | 0
 | WOZ-waarde |  |  |  |  |  |  | Punten
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 49
 | Totaal punten WOZ waarde |  |  |  |  |  |  | 50
 | Zorgopslag 35% |  |  |  |  |  | 0 | 0
 | Totaal punten
 | Huur per maand |  |  |  |  |  |  |  | Per 1 juli 2024 volgens tabel huurprijzen
 | Gebaseerd op Wet betaalbare huur
Spreadsheet: 285548d1387714237-total-after-zero-month-to-date
Sheet: Sheet1

Week1 |  |  |  | Week2 |  |  |  | Week3 |  |  |  | Week4
Score | Bonus | Quality | Total | Score | Bonus | Quality | Total | Score | Bonus | Quality | Total | Score | Bonus | Quality | Total
10 | 1 | N |  | 1 | 0 | Y |  | 2 | 0 | N |  | 3 | 1 | N
Scenario
1 | Whenever the total is zero in any week start summing from next week (For Example in a total week1,2..4,  series of total 11 0 2  4 sum should be 6 because zero is in week 2 in the same way if we get series 11 1 2 0 total should be 0)
[NAME]
 | Data is entered on a daily basis so normally if data is not entered total for week 2 ,3 & 4 will show zero so that will give wrong total
Example if the data is already there no problem it works with the formula below
 | Total
 | week1 | week2 | week 3 | week4 | Month to Date
 |  |  |  |  |  |  |  | Problem: if data is entered on a weekly basis it gives incorrect answer in Month to Date Column that is always Zero
 | Problem for the same thing please see below
Week1 |  |  |  | Week2 |  |  |  | Week3 |  |  |  | Week4
Score | Bonus | Quality | Total | Score | Bonus | Quality | Total | Score | Bonus | Quality | Total | Score | Bonus | Quality | Total
10 | 1 | N
 | Data is  updated weekly so week 1 data is there and month to date should show 11 but it is showing 0
 | Future dated data is not available which can be collated after the test
 | Total
 | week1 | week2 | week 3 | week4 | Month to Date
Spreadsheet: 109881d1306703009-count-hours-worked-inputted-in-a-single-cell-test-for-forumlas
Sheet: Planner

 |  |  |  |  |  | PERIOD:
 |  | MCO: |  | DCO: |  | WEEK:
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 | 2011-05-23 00:00:00 | 2011-05-24 00:00:00 | 2011-05-25 00:00:00 | 2011-05-26 00:00:00 | 2011-05-27 00:00:00 | 2011-05-28 00:00:00 | 2011-05-29 00:00:00
 | 9 AM - 12:30 PM | 9 AM - 11 AM | 10:30 AM - 11:30 AM
 |  |  |  | OFF
 |  | 11 AM - 12:30 PM | 12:00 - 2:00 PM
 |  | 12:30 PM - 3:00 PM
 | 12:30 - 3:00 PM |  | 2:00 - 4 PM
 |  | 3:30 - 6:30 PM
# of Hours Scheduled
# of Visits
 | Last Week |  |  | This Week |  |  | Types of Visits
 | # of Visits |  |  | WTB AWUS
 | Projected EBITDA |  |  | Projected PCYA
 | PCYA % |  |  | # of MCO Scheduled Hours
 | DOT % |  |  | # of Planned Visits
 | GM/AM Turnover |  |  | # of Hours Overscheduled
 |  |  |  | 5 Things to Do List
Spreadsheet: 8c63bde4-3061-45f7-a951-708f82bea8cd
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
STCH | Test | STCH | Strychnine,  Serum/Plasma | Strychnine | Gas Chromatography (GC) | Plain, Red-Top Tube: Red OR 2 EDTA (lavender-top) Tubes: 2 OR |  |  | 4 | mL | Submit only 1 of the following specimens:   Preferred: Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.) Spin down and send 5 mL of serum refrigerate in  a plastic vial. Note:	1. Indicate serum on request form. 	2. Label specimen appropriately (serum).    [NAME] blood in 2 lavender-top (EDTA) or 2 green-top (heparin) tubes.  ([NAME] is not acceptable.)Spin down and  send 5 mL of EDTA or heparinized plasma refrigerate in a plastic vial. Note:	1. Indicate plasma on request form. 	2. Label specimen appropriately (plasma). | 2.2 mL | Specimens other than	Serum, plasma Anticoagulants other than	Plain red-top, EDTA, heparin Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icteric	NA | Reporting limit determined each analysis  Potentially lethal concentrations are in excess of 500 ng/mL.   Test Performed By: NMS Labs 	                      3701 Welsh Road 		      PO Box 433A 		      Willow Grove, PA 19090-0437 | Monday through Thursday | 2 days | 4 - 8 days | 1 | 82491 |  |  |  |  | NMS Labs
STCH | [NAME] | VARIES | Varies |  |  |  | Refrigerated
STCH | Result | Z1312 | Strychnine | Strychnine | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 5738-0 | Strychnine:MCnc:Pt:[NAME]:Qn:
STCH | Result | Z1920 | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 49725d1249046134-vlookup-401-ded-worksheet-upload
Sheet: Hours

File# | Name | Gross earnings | Rate | Regular Hours | Vacations Hours | Sick Hours | Floating Holiday | Holiday | Total
1 | Doe, [NAME] | 1000 | 25 | 40 | 0 | 0 | 0 | 0 | 40
2 | [NAME], [NAME] | 1000 | 25 | 24 | 8 | 0 | 0 | 8 | 40
2 | [NAME], [NAME] | 1000 | 25 | 40 | 0 | 0 | 0 | 0 | 40
4 | [NAME], [NAME] | 1000 | 25 | 40 | 0 | 0 | 0 | 0 | 40
4 | [NAME], [NAME] | 1000 | 25 | 40 | 0 | 0 | 0 | 0 | 40
6 | Thompson, Jake | 1000 | 25 | 40 | 0 | 0 | 0 | 0 | 40
7 | Garner, [NAME] | 1200 | 25 | 32 | 0 | 8 | 8 | 0 | 48
8 | Holland, Maria | 1000 | 25 | 32 | 8 | 0 | 0 | 0 | 40
9 | Graft, Scott | 1000 | 25 | 24 | 16 | 0 | 0 | 0 | 40
10 | Topper, [NAME] | 1000 | 25 | 0 | 40 | 0 | 0 | 0 | 40
11 | [NAME], [NAME] | 1000 | 25 | 8 | 24 | 0 | 0 | 8 | 40
12 | Trully, [NAME] | 1000 | 25 | 32 | 0 | 0 | 0 | 8 | 40
13 | Fanta, [NAME] | 1000 | 25 | 24 | 8 | 0 | 0 | 8 | 40
14 | Shelton, [NAME] | 1000 | 25 | 40 | 0 | 0 | 0 | 0 | 40
15 | Edwards, [NAME] | 800 | 20 | 40 | 0 | 0 | 0 | 0 | 40
16 | Earhardt, Dale | 800 | 20 | 40 | 0 | 0 | 0 | 0 | 40
17 | [NAME], [NAME] | 800 | 20 | 40 | 0 | 0 | 0 | 0 | 40
18 | Frontal, [NAME] | 800 | 20 | 24 | 16 | 0 | 0 | 0 | 40
19 | Edon, [NAME] | 800 | 20 | 16 | 24 | 0 | 0 | 0 | 40
20 | [NAME], [NAME] | 2400 | 30 | 40 | 0 | 40 | 0 | 0 | 80
21 | Bing, [NAME] | 1280 | 32 | 0 | 0 | 0 | 0 | 0 | 0
22 | [NAME], [NAME] | 1923.2 | 48.08 | 0 | 0 | 0 | 0 | 0 | 0
23 | [NAME], [NAME] | 600 | 15 | 0 | 16 | 0 | 0 | 0 | 16
Spreadsheet: 44740d1243508913-linking-drop-down-boxes-mock-up-2-
Sheet: SUBSTRUCTURE

MATERIAL |  |  |  |  | QUANTITY | UNIT | EE/UNIT (kgCO2) | EE (kgCO2) | Data Source
Concrete | TYPE | MIX | ADDITIONAL MATERIAL
 |  |  |  |  |  | [NAME] |  | 0
 |  |  |  |  |  |  | 0.209 | 0
 |  |  |  |  |  |  |  | 0
 | CELL LINL OF CB_1 | CELL LINL OF CB_2 |  |  |  |  |  | 0
 | 3 | 1 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
1 Sulphur: 3 Sand: 5 Aggregate |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Spreadsheet: 33d09c82-1608-4cd4-9a47-d062e9b06724
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Housing and Interest Rate Forecast, 12/1/2014
 |  | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00
 | Housing Activity (000)
 | Total Housing Starts | 585.5 | 611.916666666666 | 783.75 | 929.6666666666661 | 992.5083707486666 | 1162.456228029111 | 1463.397613507967
 | Single Family | 471.416666666667 | 434.333333333333 | 537 | 621.083333333333 | 640.7100374153333 | 804.2379088845565 | 1101.940911861773
 | Multifamily | 114.083333333333 | 177.583333333333 | 246.75 | 308.583333333333 | 351.7983333333333 | 358.2183191445542 | 361.4567016461937
 | New Single Family Sales | 321.25 | 306.416666666667 | 367.833333333333 | 430.333333333333 | 440.9632648502542 | 588.2039734736305 | 809.9925851998244
 | Existing Single-Family Home Sales | 3705 | 3792.5 | 4130 | 4470.83333333333 | 4358.067903764786 | 4690.801910411278 | 4753.223147870205
 | Interest Rates
 | Federal Funds Rate | 0.00125 | 0.00125 | 0.00125 | 0.00125 | 0.00125 | 0.006875000000000001 | 0.02625
 | 90 day T [NAME] | 0.00136666666666667 | 0.000525 | 0.000858333333333333 | 0.000583333333333333 | 0.0003136666666666667 | 0.005409500000000001 | 0.02375
 | Treasury Yields:
 | One Year Maturity | 0.00318333333333333 | 0.00181666666666667 | 0.00175 | 0.00131666666666667 | 0.001130416666666665 | 0.007415687500000001 | 0.0275
 | Ten Year Maturity | 0.0321416666666667 | 0.0278583333333333 | 0.018025 | 0.0235083333333333 | 0.02550833333333333 | 0.028226285568 | 0.03703675103134036
 | Freddie Mac Commitment Rates:
 | Fixed Rate Mortgages | 0.0469058332840602 | 0.0445583335856597 | 0.0365591666400433 | 0.0398191666666667 | 0.04173874999999999 | 0.044726285568 | 0.05353675103134036
 | ARMs | 0.0378874999384085 | 0.0303991668621699 | 0.0268816664616267 | 0.0261245833333333 | 0.02464458333333335 | 0.0319156875 | 0.0515
 | Prime Rate | 0.0325 | 0.0325 | 0.0325 | 0.0325 | 0.0321875 | 0.036875 | 0.05625
 | Data are averages of seasonally adjusted quarterly data and may not match annual
 | data published elsewhere.
 | For more forecast details, visit www.HousingEconomics.com.
Spreadsheet: mary_fischer__25640__31W - 2001
Sheet: E1.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031W
COMPANY NAME    Harper Mechanical Corp.
ANALYSIS OF A/R - OTHER
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:  Sonya City
EXTENSION:  3-9690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Accts Receivables - Unconsolidated Assoc Companies:
Total (Hyperion line 0053)
Asset/Expense Accts:  DR/(CR)
Accts Receivables - Other:
Total (Hyperion line 0060)
Asset/Expense Accts:  DR/(CR)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
Spreadsheet: 166684d1341719165-sum-unique-values-according-to-criteria-sumif-unique-values-sumif_unique_values
Sheet: Sheet1

Product Type | Global sum
Product 1 | 2 |  |  | I am looking for a formula that given a condition (Product type), sums all the unique values on another column (Global sum)
Product 2 | 4
Product 1 | 2
Product 2 | 4 |  |  | Expected results from example data:
Product 3 | 4 |  |  | Sum all unique values in column B for Product 1 = 2+3 = 5
Product 1 | 3 |  |  | Sum all unique values in column B for Product 2 = 4+5 = 9
Product 2 | 5
Product 3 | 3
Product 1 | 3 |  |  | I tried the solution on another post that seemed to describe my problem, but it didn't work…
Product 2 | 5 |  |  | SUM(IF(ISNUMBER(1/FREQUENCY(IF(B2:B13<>"";IF(A2:A13<>"";MATCH(A2:A13;A2:A13;0)));ROW(A2:A13)-ROW(A2)+1));B2:B13))
Product 1 | 3 |  |  | [NAME] result :
Product 2 | 5
Spreadsheet: 328209d1403815882-help-counting-unique-values-from-column-meeting-multiple-criteria-sample-attendence-spreadsheet
Sheet: Block Summary

 | Room No | Block |  | Spaces |  | Monday Week 1 |  |  |  |  |  |  |  |  |  |  |  | Week commencing | 2014-05-12 00:00:00 | Block Weekly Total Spaces | Block Weekly Total Allocated | Block Weekly Total Attend | Block Weekly Total Non Att | Block Weekly Total Acc Abs | Block Weekly Total Non Acc Abs
 |  |  |  |  |  | AM |  |  |  | Acceptable |  | PM |  |  |  | Acceptable
 |  |  |  | AM | PM | Spaces | Allocated | Actual | [NAME] | Yes | No | Spaces | Allocated | Actual | [NAME] | Yes | No
 | 1 | A | A | 182 | 182 | 59 | 123 | 117 | 6 | 0 | 6 | 153 | 29 | 29 | 0 | 0 | 0 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 2 | B | B | 175 | 175 | 131 | 44 | 43 | 1 | 0 | 1 | 53 | 122 | 101 | 21 | 15 | 6 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 3 | C | C | 57 | 57 | 31 | 26 | 20 | 6 | 0 | 6 | 34 | 23 | 22 | 1 | 0 | 1 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 5 | D | D | 69 | 69 | 14 | 55 | 55 | 0 | 0 | 0 | 12 | 57 | 56 | 1 | 0 | 1 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 7 | E | E | 97 | 97 | 57 | 40 | 39 | 1 | 0 | 1 | 28 | 69 | 63 | 6 | 1 | 5 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 10 | F | F | 192 | 192 | 37 | 155 | 139 | 16 | 7 | 9 | 31 | 161 | 154 | 7 | 3 | 4 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 10 | H | H | 21 | 21 | 6 | 15 | 15 | 0 | 0 | 0 | 3 | 18 | 18 | 0 | 0 | 0 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 11 | P | P | 6 | 6 | 1 | 5 | 3 | 2 | 2 | 0 | 1 | 5 | 3 | 2 | 2 | 0 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  | [NAME] |  | 2014-05-12 00:00:00 | Monday Week 1 Totals |  |  |  |  |  |  |  |  |  |  | Spaces |  | Block Weekly Total Spaces | Block Weekly Total Allocated | Block Weekly Total Attend | Block Weekly Total Non Att | Block Weekly Total Acc Abs | Block Weekly Total Non Acc Abs
 |  |  |  | AM | PM | AM |  |  |  | Acceptable |  | PM |  |  |  | Acceptable |  | AM | PM
 |  |  |  | 1598 |  | Spaces | Allocated | Actual | [NAME] | Yes | No | Spaces | Allocated | Actual | [NAME] | Yes | No | 7191
 |  | Totals |  | 799 | 799 | 336 | 463 | 431 | 32 | 9 | 23 | 315 | 484 | 446 | 38 | 21 | 17 | 3995 | 3196 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | Percentage |  | 0.5 | 0.5 | 0.4205256570713392 | 0.5794743429286608 | 0.9308855291576674 | 0.06911447084233262 | 0.28125 | 0.71875 | 0.3942428035043805 | 0.6057571964956195 | 0.9214876033057852 | 0.07851239669421488 | 0.5526315789473685 | 0.4473684210526316 | 0.5555555555555556 | 0.4444444444444444 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | I need : E.G. Cell H4 to calculate the number of unique values from Column C on Mon tab but only meeting the following criteria Mon!$N$3:$N$4000="AM", Mon!$O$3:$O$4000=D4, Mon!$B$3:$B$4000="mon1"
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 14d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other |  | IG | Other
Index Tranche | 6 | 30 | 76 | 4 | 60 | 30
Index | 1836 | 2528 | 3439 | 1495 | 2847 | 2277
OTHER* | - | - | 202 | - | - | 158
TOTAL
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 675583d1588357504-unique-drop-down-lists-2020-05-01-oeldere-deekster-675557d1588353303-unique-drop-down-lists-help-file
Sheet: Sheet1

Area | [NAME] | Account Number | Business Name | ADDRESS | CITY | STATE | Vendor (Here is where I would like unique drop downs)
5 | [NAME] | 600881 | P | 1085 WESTFIELD Street | WESTFIELD | CA
5 | [NAME] | 603675 | Q | 3801 PORTSMOUTH Street | PORTSMOUTH | CA
5 | [NAME] | 614635 | J | 1075 SOUTH HADLEY Street | WINDHAM | FL
5 | [NAME] | 617679 | N | 4426 DOVER FOXCROFT Street | [NAME] | CA
5 | [NAME] | 618626 | E | 3801 PORTSMOUTH Street | WEST SPRINGFIELD | UT
5 | [NAME] | 648459 | L | 4619 CALAIS Street | AUGUSTA | FL
5 | [NAME] | 656705 | W | 4038 GORHAM Street | GORHAM | CA
5 | [NAME] | 666080 | I | 3874 SEABROOK Street | CHICOPEE | FL
5 | [NAME] | 667079 | B | 4426 DOVER FOXCROFT Street | WILBRAHAM | UT
5 | [NAME] | 667261 | V | 1075 SOUTH HADLEY Street | SOUTH HADLEY | CA
5 | [NAME] | 667446 | D | 1085 WESTFIELD Street | SOUTH HADLEY | UT
5 | [NAME] | 674205 | U | 3874 SEABROOK Street | SEABROOK | CA
5 | [NAME] | 674491 | T | 3275 PEMBROKE Street | PEMBROKE | CA
5 | [NAME] | 678355 | R | 4239 JAY Street | JAY | CA
5 | [NAME] | 678485 | Y | 1060 SYRACUSE Street | NORTHAMPTON | CA
5 | [NAME] | 678927 | S | 1028 EAST LONGMEADOW Street | EAST LONGMEADOW | CA
5 | [NAME] | 679125 | K | 4038 GORHAM Street | [NAME] | FL
5 | [NAME] | 679133 | O | 4046 ARUNDEL Street | ARUNDEL | CA
5 | [NAME] | 679428 | X | 4619 CALAIS Street | CALAIS | CA
5 | [NAME] | 679483 | A | 3103 MANCHESTER Street | CARIBOU | UT
5 | [NAME] | 680589 | H | 3275 PEMBROKE Street | SOUTHWICK | FL
5 | [NAME] | 680907 | F | 4239 JAY Street | BREWER | UT
5 | [NAME] | 680908 | G | 1028 EAST LONGMEADOW Street | BANGOR | UT
5 | [NAME] | 680964 | M | 3103 MANCHESTER Street | MANCHESTER | CA
5 | [NAME] | 682366 | C | 4046 ARUNDEL Street | CONCORD | UT
Spreadsheet: 925434ed-2dbd-452d-824e-a906a4a87bd5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7831 | 15967 | Leo | Meewisse | NED | 172 | 00:22:53 | 00:01:43 | 01:24:42 | 00:01:46 | [NAME] | 1 | 02:41:54
7831 | 58918 | Eelke | De Boer | NED | 171 | [NAME] | 00:02:45 | 01:34:31 | 00:01:55 | 00:59:26 | 2 | 02:58:56
7831 | 13474 | Jan | [NAME] | NED | 173 | 00:23:04 | 00:02:39 | 01:44:21 | 00:02:44 | 00:54:01 | 3 | 03:06:47
7831 | 55772 | [NAME] | [NAME] | GER | 176 | 00:00:00 | 00:00:00 | 01:43:57 | 00:02:49 | 00:57:23 | 4 | 03:11:15
7831 | 20781 | [NAME] | Kenny | GBR | 174 | [NAME] | 00:02:23 | 01:58:18 | 00:02:07 | 01:02:40 | 5 | [NAME]
7831 | 8035 | Stuart | Lumb | GBR | 175 | 00:30:16 | 00:04:27 | 02:09:35 | 00:04:14 | [NAME] | 6 | 04:11:05
Spreadsheet: 175097d1345390717-round-formula-giving-incorrect-result-book2
Sheet: Sheet1

 |  |  |  | 10.79999999999999 | 0.4 | -0.8 | -2 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1 | 0.7 | 0.1 | 0 | 0.1 | 0 | 0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 65407d1266105269-formula-to-distinguish-month-year-from-prior-month-years-excel-spreadsheet-with-formulas
Sheet: Tab 6

 | Date |  | Company | Invoice # | Description
1 | 2009-04-17 00:00:00 |  |  |  |  | 11779.58
2 | 2009-08-19 00:00:00 |  |  |  |  | 1677
3 | 2009-09-15 00:00:00 |  |  |  |  | 686.79
4 | 2009-11-17 00:00:00 |  |  |  |  | 4296.89
5 | 2009-12-09 00:00:00 |  |  |  |  | 2059.78
 |  |  |  |  |  | 20500.04 | 0
Spreadsheet: 02e4b555-05a6-40f8-a00e-8401a50136eb
Sheet: 23

 |  | Transactions
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated swap transaction volumes, week ending February 8, by product type, participant type, and cleared status (in number of transactions), all tenors, currencies, and deliveries. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].