tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 68552d1269083483-validation-or-define-problem-inventory
Sheet: Sheet1

 | Date | Outlet Name | [NAME] | Description | Head | Qty | Rate | Amounts | Sales Tax |  | Tax Amounts | [NAME]
 |  | [NAME] | I need to create the group from supplier |  |  |  |  | 100 |  | 0 |  | Coca Cola
 |  |  | Cocacola | Product Automatically tracked(i.e) |  |  |  | 200 |  | 0
 |  |  |  | Coke 20 ltr BIB |  |  |  | 300 |  | 0
 |  |  |  | Sprite 20 ltr BIB SO ON |  |  |  | 400 |  | 0
 |  |  | KandNfood | Chicken |  |  |  | 400 |  | 0
 |  |  |  | Breast Fillet |  |  |  | 400 |  | 0
 |  |  |  | [NAME] |  |  |  | 400 |  | 0
 |  |  |  | Kiddies Breast |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
Spreadsheet: 149206d1333744656-pulling-multiple-results-by-matching-one-variable-from-list-of-variables-example-file
Sheet: Data Sheet

 |  | Item Code | Quantity | Type
 |  | 1 | 850 | a
 |  | 2 | 109 | b
 |  | 3 | 860 | c
 |  | 4 | 555 | c
 |  | 5 | 546 | a
 |  | 6 | 8 | b
 |  | 1 | 879 | b
 |  | 2 | 7 | b
 |  | 3 | 786 | a
 |  | 4 | 154 | c
 |  | 6 | 269 | b
 |  | 5 | 543 | c
 |  | 3 | 541 | a
 |  | 1 | 871 | c
 |  | 4 | 87 | a
 |  | 5 | 481 | b
 |  | 1 | 356 | c
 |  | 6 | 87 | a
 |  | 7 | 81 | a
 |  | 3 | 963 | b
 |  | 4 | 42 | b
Spreadsheet: 01bfa562-b7be-4055-80f8-65f00cada4ad
Sheet: Summer

Acad. Yr. | Acad. Year | Class Schedule: First Year - Student |  |  |  |  |  |  | Summer
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
700 |  |  |  |  | CLINICAL ROTATIONS  0700 - 1530 |  | CLINICAL ROTATIONS  0700 - 1530
800
900 | RC 135 |  | RC 135
 | # 1098 |  | # 1098
1000
 | [NAME] |  | [NAME]
1100
1200
1300
1400
1500
1600
Spreadsheet: 63237d1264159549-hiding-cells-if-empty-book1
Sheet: TTAPR2

 |  | hide |  |  | hide
Skills | Skill 1 | Skill 2 | Skill 3 | Skill 4 | Skill 5 | Skill 6
2010-01-01 00:00:00 | 1 |  |  | 1 |  | 1
2010-01-02 00:00:00 | 1 |  |  | 1
2010-01-03 00:00:00 | 1 |  |  | 1
2010-01-04 00:00:00 | 1 |  | 1
2010-01-05 00:00:00 | 1 |  | 1
2010-01-06 00:00:00 | 1 |  |  | 1
Spreadsheet: 160769d1339185733-update-date-in-a-cell-when-any-changes-are-made-and-saved-on-a-worksheet-test
Sheet: 4. People Needs

 |  | People Needs for
 |  | [NAME]
 |  | Location | GM Needs | Associate Needs | Assistant Needs | FPS Needs | At Risk | NI Managers | MIT Count
110002 S. State StreetNI1 | 110002 S. State StreetX1 | 110002 S. State Street
110002 S. State StreetNI2 | 110002 S. State StreetX2
110076 Fourth SouthNI1 | 110076 Fourth SouthX1 | 110076 Fourth South |  |  | 1
110076 Fourth SouthNI2 | 110076 Fourth SouthX2
110081 BountifulNI1 | 110081 BountifulX1 | 110081 Bountiful
110081 BountifulNI2 | 110081 BountifulX2 |  |  |  |  |  |  |  | [NAME]
110085 TaylorsvilleNI1 | 110085 TaylorsvilleX1 | 110085 Taylorsville
110085 TaylorsvilleNI2 | 110085 TaylorsvilleX2
110750 OgdenNI1 | 110750 OgdenX1 | 110750 Ogden
110750 OgdenNI2 | 110750 OgdenX2 |  |  |  |  |  |  |  | [NAME]
110784 RoyNI1 | 110784 RoyX1 | 110784 [NAME]
110784 RoyNI2 | 110784 RoyX2
110854 S Ogden (SkylinNI1 | 110854 S Ogden (SkylinX1 | 110854 S Ogden (Skylin
110854 S Ogden (SkylinNI2 | 110854 S Ogden (SkylinX2
New StoreNI1 | New StoreX1 | New Store | 1 |  | 1
New StoreNI2 | New StoreX2
NI1 | X1
NI2 | X2
NI1 | X1
NI2 | X2
 |  | Total | 1 | 0 | 2 | 0 | 0 | 0 | 2
 |  |  |  |  |  |  |  |  | 2012-06-08 00:00:00
Spreadsheet: 687093d1594951321-calculate-total-in-range-that-are-before-specific-time-sample-3-
Sheet: Not change format

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1700
 |  |  |  |  |  |  |  |  | Time Opened | Time Closed | Hours   Open |  |  |  |  |  | 1800
 |  |  |  |  |  |  |  | A | 1700 | 2200 | 3 |  |  |  |  |  | 1900
 |  |  |  |  |  |  |  | B | 1700 | 2150 | 2.75 |  |  |  |  |  | 2000
 |  |  |  |  |  |  |  | C | 1700 | 2305 | 6 |  |  |  |  |  | 2100
 |  |  |  |  |  |  |  | D | 1700 | 2315 | 6.25 |  |  |  |  |  | 2200
 |  |  |  |  |  |  |  | E | 1700 | 2110 | 2.25 |  |  |  |  |  | 2300
 |  |  |  |  |  |  |  | F | 1700 | 1820 | 1.25 |  |  |  |  |  | 2400
Time | Open
1700
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calculate total in range that are before specific time:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I hope I can explain this clearly.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I have a range of A11:A18 that contain times (1700, 1800, 1900, 2000 through 2400 currently.)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B11:B18 is where the number of slots open that I'm tracking are recorded.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Range I3:K8 contain:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I= Slot labels
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] open times
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K= Slot close times
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | With B11 is where how many slots remain open at 1700 is input, I'd like a formula to auto fill that number based on the times in the range I3:K8.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Attached is a sample which I hope better explains what I'm trying to accomplish. I'm not certain the best approach for this other than no VBA.
Spreadsheet: 837413d1690157939-auto-populate-values-for-a-month-based-on-a-previous-months-value-book1-example-1-1-
Sheet: Sheet1

ADT040 | CURRENT HOURS | 10000 |  |  | HOURS PER MONTH | 450
 |  |  |  |  |  |  | 2022-09-01 00:00:00
Plant No | PM Task & Desc | Last Service ODO | [NAME] | UOM | Section | Cost | Sep-22 | Oct-22 | Nov-22 | Dec-22 | Jan-23 | Feb-23 | Mar-23 | Apr-23 | May-23 | Jun-23 | Jul-23 | Aug-23 | Sep-23 | Oct-23 | Nov-23 | Dec-23
ADT040 | 13 - CHANGEOUT POS1 TYRE TH551 SANDVIK  ([NAME]) | 8000 | 2000 | HRS | Components Change | 12229.06
ADT040 | 14 - CHANGEOUT POS2 TYRE TH551 SANDVIK  (TASK#14) | 10000 | 2000 | HRS | Components Change | 12229.06
ADT040 | 15 - CHANGEOUT POS3 TYRE TH551 SANDVIK  (TASK#15) | 10000 | 2000 | HRS | Components Change | 12229.06
ADT040 | 16 - CHANGEOUT POS4 TYRE TH551 SANDVIK  (TASK#16) | 10000 | 2000 | HRS | Components Change | 12229.06
ADT040 | 496 - CHANGEOUT FRONT AXLE TH551 SANDVIK TRUCK (TASK#496) | 10000 | 14000 | HRS | Components Change | 96080.53
ADT040 | 497 - CHANGEOUT REAR AXLE TH551 SANDVIK TRUCK (TASK#497) | 10000 | 14000 | HRS | Components Change | 96080.53
ADT040 | 4 - SERVICE FIRE SUPRESSION SYSTEMS - 4 MONTHLY  (TASK#004) | 2022-09-01 00:00:00 | 112 | DAYS | Service | 382
ADT040 | 8 - MOBILE PLANT FIRE PREVENTION INSPECTION (TASK#008) | 2022-09-01 00:00:00 | 28 | DAYS | Service | 202
ADT040 | 381 - WEEKLY NEWTRAX SERVICE  (PM TASK# 381) | 2022-10-15 00:00:00 | 7 | DAYS | Service | 320
ADT040 | 499 - FORTNIGHTLY SERVICE TH551 SANDVIK TRUCK (TASK#499) | 2022-09-01 00:00:00 | 14 | DAYS | Service | 234.97
Spreadsheet: 187204d1350378731-counting-text-values-across-multiple-columns-in-pivot-table-example
Sheet: Example

Name | Gender | Age | Likes | Likes | Likes | Likes
[NAME] | Boy | 12 | Ice Cream | Pizza
[NAME] | Boy | 9 | Pizza
[NAME] | Boy | 5 | Hot Dogs | Ice Cream | Pizza
[NAME] | Girl | 5 | Ice Cream
[NAME] | Boy | 6 | Pie | Ice Cream | Pizza | Hot Dogs
[NAME] | Girl | 7 | Pizza | Ice Cream
Pivot that is able to answer:
Number of kids who like Ice Cream?
Number of kids who like Ice Cream and Hot Dogs?
Number of kids who like more than one type of food?
Favourite foods in terms of number of likes per food item?
Favourite foods ordered by gender of kids?
What is the average age of kids who like pizza?
Spreadsheet: 352ee91e-715e-4aa8-8744-c8ef4004504d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
8915 | 10545 | Urmas | Utar | EST | 242 | [NAME] | 00:00:43 | 00:24:24 | 00:01:23 | 00:14:37 | 1 | 00:54:53
8915 | 39168 | Viktor | Korchagin | RUS | 244 | 00:15:06 | [NAME] | 00:26:02 | 00:00:54 | 00:14:43 | 2 | 00:57:24
8915 | 68530 | [NAME] | Pedari | EST | 241 | 00:16:00 | 00:00:34 | 00:25:05 | 00:00:57 | 00:15:52 | 3 | 00:58:28
8915 | 68351 | Marek | [NAME] | EST | 240 | 00:15:47 | [NAME] | 00:25:52 | 00:01:05 | 00:15:29 | 4 | 00:59:03
8915 | 68604 | Toms | Piksens | LAT | 243 | 00:16:47 | 00:00:30 | 00:27:20 | 00:01:29 | 00:17:29 | 5 | [NAME]
Spreadsheet: 57299d1257415570-count-example-database-for-services
Sheet: Sheet1

Service1(e.g. Introductory Mapping Event, OHS Training) | Date commencing | [NAME] work | Date commencing
 |  | visited only no service taken up | 01.02.09
management role consultation | 01.01.09
DBT training | 02.09.09
 |  | visited only no service taken up | 03.03.09
SCI | 03.04.09
SCI | 05.05.09
 |  | phone call | 11.11.09
SCI | 11.10.09 |  | .
DBT training | 20.01.09
consolidation event | 06.06.09
[NAME] mapping event | 16.04.09
team consultation | 13.09.09
DBT training | 12.06.09
DBT training | 17.08.09
DBT training | 28.09.09
 |  | email | 12.08.09
Spreadsheet: 810477d1671798836-auto-formulas-from-one-sheet-to-another-formula-help
Sheet: 3

[NAME]
 | Name: |  |  |  |  |  |  |  |  |  | Personalnummer: |  |  |  |  |  |  |  |  |  |  | Eintritt:
 | Vorname: |  |  |  |  |  |  |  |  |  | Kategorie: |  |  |  |  |  |  |  |  |  |  | Austritt:
 |  |  | KZ | Arbeitszeit |  |  |  | Zimmer |  |  | [NAME] |  |  | [NAME] |  | [NAME] |  | Zimmer | [NAME] |  |  |  | Abrechnung |  |  |  |  | [NAME]
Feiertag | Tag | Datum | A/F/K/U | Von | Bis | Pause (min.) | Std. o. Pause | Standard | Suit | Dom Suit | Standard | Suit | Dom Suit | Ex.Arbeit | Spät | Ex.[NAME] | MiniBar | Zusätzlich eingeteilt | DND | Kein Service | Clean Zimmer | OS / Sonstiges | Std. Zimmer | Std. Geasmt | +/- [NAME]. | +/- Min. | [NAME] | [NAME] | [NAME]
 |  | 1900-01-01 00:00:00
 |  | 1900-01-02 00:00:00
 |  | 1900-01-03 00:00:00
 |  | 1900-01-04 00:00:00
 |  | 1900-01-05 00:00:00
 |  | 1900-01-06 00:00:00
 |  | 1900-01-07 00:00:00
 |  | 1900-01-08 00:00:00
 |  | 1900-01-09 00:00:00
 |  | 1900-01-10 00:00:00
 |  | 1900-01-11 00:00:00
 |  | 1900-01-12 00:00:00
 |  | 1900-01-13 00:00:00
 |  | 1900-01-14 00:00:00
 |  | 1900-01-15 00:00:00
 |  | 1900-01-16 00:00:00
 |  | 1900-01-17 00:00:00
 |  | 1900-01-18 00:00:00
 |  | 1900-01-19 00:00:00
 |  | 1900-01-20 00:00:00
 |  | 1900-01-21 00:00:00
 |  | 1900-01-22 00:00:00
 |  | 1900-01-23 00:00:00
 |  | 1900-01-24 00:00:00
 |  | 1900-01-25 00:00:00
 |  | 1900-01-26 00:00:00
 |  | 1900-01-27 00:00:00
 |  | 1900-01-28 00:00:00
 |  | 1900-01-29 00:00:00
 |  | 1900-01-30 00:00:00
 |  | 1900-01-31 00:00:00
Summe
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | So. zusch. | Ft. Zusch.
 |  |  | Stunden pro Zimmer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gesamtstunden
 | Zimmer Stunden : |  |  |  |  |  |  |  |  |  | Krankheitstage : |  |  |  |  |  |  |  |  | [NAME] u. [NAME] :
 | Zimmer [NAME]  : |  |  |  |  |  |  |  |  |  | Krankheitsstunden : |  |  |  |  |  |  |  |  | [NAME] :
 | [NAME] : |  |  |  |  |  |  |  |  |  | Urlaubstage : |  |  |  |  |  |  |  |  | Feiertag :
 | [NAME] : |  |  |  |  |  |  |  |  |  | Urlaubsstunden : |  |  |  |  |  |  |  |  | [NAME] :
 | [NAME] : |  |  |  |  |  |  |  |  |  | Probetag Stunden : |  |  |  |  |  |  |  |  | Sonstiges :
Spreadsheet: 750077d1633216524-return-top-3-values-from-a-list-based-on-a-condition-example-1-
Sheet: Summary

Product | Brand Family | Sales $ | Price Category |  |  | Category | Top 3 Brand Families by Sales, separated by commas
1 | A | 76.73565053306362 | Mid Tier |  |  | Value | D, B, E
2 | B | 4.843957341565119 | Premium |  |  | Mid Tier | A, G, D
13 | A | 45.40117050564755 | Mid Tier |  |  | Premium | C, F, A
14 | B | 37.02587727354165 | Mid Tier |  |  | Super Premium | C
5 | E | 11.135460391762 | Value
6 | F | 52.86879157884299 | Premium
3 | C | 59.77331062291199 | Mid Tier
4 | D | 59.48460466098473 | Mid Tier
9 | A | 39.36390278216935 | Premium
10 | B | 42.98088480014386 | Value
11 | C | 64.76708577278556 | Premium
12 | D | 30.67175748080981 | Mid Tier
7 | G | 92.00931766727733 | Mid Tier
8 | H | 66.37430310745115 | Mid Tier
15 | C | 0.9325316627139202 | Super Premium
16 | D | 57.38669642416114 | Value
Spreadsheet: danny_mccarty__4627__Exhibit 7 - 2001- MKM
Sheet: August 2001

 | NORTHERN NATURAL GAS COMPANY |  |  |  | Privileged and Confidential.  Prepared for
 | System Levelized Account |  |  |  | Settlement purposes only.
 | August 2001
 |  |  |  |  |  |  |  |  |  |  | SLA Account
 |  |  |  |  |  |  |  |  |  |  | Total |  | Cash Portion - |  | Future
 |  | Operational |  |  |  |  |  |  |  |  |  |  | Cash Out/ |  | Liability
 |  | Storage |  | SLA Calculation |  |  |  |  |  |  |  |  | (Cash In)
 |  | [NAME] | Volume | Dollar | Dollar |  |  |  | Net |  | SLA Impact |  | Col (e)*-1 |  | Col (d)*(g)
Line |  | (Over)/Under | Valued | Valued | Amount | Cost |  | Monthly | Cost |  | Increase/
No. | Type of Volume | 14 Bcf | [NAME] | [NAME] | (Cash Out)/ | Per Mcf |  | MIP | Per Mcf |  | (Decrease)
 |  | Col (c)+(d) |  |  | Cash In | Col (e)/(d) |  |  | Col (g)-(f) |  | Col (d)*(h)
 | Column (a) | (b) | (c) | (d) | (e) | (f) |  | (g) | (h) |  | (i) |  | (j) |  | (k)
 | August, 2001
1 | 07/01 Balance Per Books: |  | -2165975 | 4737101 | -39201057 |  |  | 2.9322 |  |  |  |  | 39201057 |  | 13890128
2 | Revalue 07/01 Shortfall @ Current [NAME]: |  |  |  |  |  | 1/ | 2.8522
3 | 08/01 Activity
4 | Dollar Valued Imbalance |  |  | -6496
5 | Imbalance Tiering Gain |  |  |  | 72564
6 | Gas Purchases |  |  | 0 | 0
7 | Miscellaneous
8 | Net 08/01 Activity |  | 671833
9 | 08/01 Balance Per Books:
 | 1/  Prior Month's MIP
Spreadsheet: mary_fischer__25638__31U
Sheet: E2.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031U
COMPANY NAME   Limbach Mgmt Company
ANALYSIS OF OTHER CURRENT ASSETS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-2
 |  | 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.)
Hyperion Line 0189 - Fair Value Investment (current)
[NAME] rec |  | 120829 |  | -120829
Prepaid expenses |  | 4984 |  | -4984
Deferred royalty |  | -88316 |  |  |  |  |  | -34986
[NAME] deferred expense |  | -49665 |  | 49665
Other current assets |  | 41888 |  |  |  |  |  | 3891
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total Current Assets | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 195
Asset/Expense Accts:  DR/(CR)
Spreadsheet: 152377d1335367092-need-help-with-multiple-lookup-formulas-and-worksheets-fsfc-04-25-12
Sheet: List for Office

These are the fields needed for office print out - Pull data from Main
 |  |  |  |  |  |  |  | [NAME]
[NAME]) |  | Phone #s | Foster Child(ren) | County | Date of Arrival | Date of Term | D.O.B. | Age as of Today | Foster Care Coordination | Therapy | Adoption | Phone | CSD Social Worker | Phone | FS Social Worker
Smith, Tom & Jones Sally |  | 555-3687 | Rodgers, [NAME] | B | 2010-05-06 00:00:00 |  | 1995-03-03 00:00:00 |  | LTFC | City-Reddam | N/A | N/A | F. Pizzuto | 555-3755 | [NAME]
 | 30 Main Street | 555-4444 | Rodgers, [NAME] | B | 2010-05-06 00:00:00 |  | 1997-07-21 00:00:00 |  |  | City-Reddam | N/A | N/A | F. Pizzuto | 555-3755 | Rebecca
# Bio | City, ST 99999 | 555-3354
2 |  | 555-6578
Spreadsheet: 485622d1476979101-count-if-ryan-project-1
Sheet: Oct 2

Category # | What Happened | My Conclusion | Report # | Firm Name | Stock Symbol | What Issue | Trade Date
1 | insert explation here | what I think | BC123 | Firm E | QWA | RWNA | 2015-10-02 00:00:00
2 | insert explation here | what I think | [NAME] | FIRM A | KMN | RWNA | 2015-10-02 00:00:00
3 | insert explation here | what I think | BC345 | FIRM C | KMJ | ROETS | 2015-10-02 00:00:00
4 | insert explation here | what I think | [NAME] | Firm B | IMK | B/A | 2015-10-02 00:00:00
Spreadsheet: 822064d1679072054-separate-string-of-text-and-numbers-and-find-fartherst-right-values-s666-pq-separate-string-of-text-and-numbers-and-find-fartherst-right-values
Sheet: Sheet1

Horse | Form String | Latest1 | Latest2 | Latest3 |  | Horse | Form String | TS.1 | TS.2 | TS.3
Let's Have Another | 342/91517-P | P | - | 7 |  | Let's Have Another | 342/91517-P | 1 | 7 | P
Us And Them | 2583/UFPPP-4 | 4 | P | P |  | Us And Them | 2583/UFPPP-4 | P | P | 4
Weebill | 63/871/1231-3 | 3 | 1 | 3 |  | Weebill | 63/871/1231-3 | 3 | 1 | 3
Tonyx | 544/2341F5-5 |  |  |  |  | Tonyx | 544/2341F5-5 | F | 5 | 5
[NAME] | 11-P |  |  |  |  | [NAME] | 11-P | 1 | 1 | P
Henry's Friend | 132-4 |  |  |  |  | Henry's Friend | 132-4 | 3 | 2 | 4
[NAME] | 000/00080- |  |  |  |  | [NAME] | 000/00080- | 0 | 8 | 0
Fromposttopillar | 9 |  |  |  |  | Fromposttopillar | 9 | 9
Hey Mister Dj | 0-6P |  |  |  |  | Hey Mister Dj | 0-6P | 0 | 6 | P
Idealdes Villerets | 3/424-3 |  |  |  |  | Idealdes Villerets | 3/424-3 | 2 | 4 | 3
Import Export | 0 |  |  |  |  | Import Export | 0 | 0
Bear A Hand | 076- |  |  |  |  | Bear A Hand | 076- | 0 | 7 | 6
Spreadsheet: 797702d1664072624-possible-to-make-tedious-formula-more-efficient-and-scalable-sample-20-
Sheet: Sheet1

Employee | Wages | Taxes | Benefits | Hours | Column1 | Hrs/Proj 1 | Hrs/Proj 2 | Hrs/Proj 3
Employee 1 | 3000 |  |  | 120 |  | 80 | 40 | 0
Employee 2 | 1000 |  |  | 40 |  | 40 | 0 | 0
Employee 3 | 5000 |  |  | 200 |  | 100 | 50 | 50
Employee 4 | 500 |  |  | 20 |  | 10 | 0 | 10
Employee 5 | 750 |  |  | 30 |  | 10 | 10 | 10
Employee 6 | 4000 |  |  | 160 |  | 80 | 80 | 0
 |  |  |  | Wages
 |  |  |  | Taxes
 |  |  |  | Benefits
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 4

 | February 14 | February 21 | February 28 | March 7 | March 14
Total Interest Rate* | 46411 | 83208 | 86738 | 44913
SDs and MSPs** | 23842 | 34637 | 36828 | 23177 | 42661
Other | 22569 | 48571 | 49910 | 21736 | 36045
Total Cross-Currency | 1870 | 1722 | 2258 | 1348
SDs and MSPs | 1335 | 1229 | 1399 | 961 | 1265
Other | 535 | 493 | 859 | 387 | 459
Total Credit | 12858 | 11052 | 13123 | 17032
SDs and MSPs | 6528 | 4757 | 5103 | 7017 | 7324
Other | 6330 | 6295 | 8020 | 10015 | 9600
Total FX | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL | 61139 | 95982 | 102119 | 63293
Weekly total, swap ticket volumes by asset class and participant type (number of new trades), all products and tenors, cleared and uncleared. For cleared swaps, the creation of each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, each trade is attributed to both swap counterparties. All price-forming trade events, including new trades, terminations, amendments, and novations, are included in ticket volumes. Because this table shows transactions by participant, the totals on this table are twice those displayed on the "Transaction Ticket Volume by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***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].
Spreadsheet: 115864d1311343216-pull-data-from-one-sheet-to-another-using-multiple-criteria-book1-1-1-
Sheet: b

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr C
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr D
 |  | Mr A |  |  | Mr B |  |  | Mr C |  |  | Mr D
 |  | Product | Cost |  | Product | Cost |  | Product | Cost |  | Product | Cost
 |  | Meat | 42 |  | Bread | 21 |  | Smokes | 23 |  | Meat | 35
 |  | Cake | 21 |  | Meat | 22 |  | Smokes | 36 |  | Bread | 23
 |  | Meat | 52 |  | Paint | 23 |  | #N/A | #N/A |  | Bread | 43
 |  | Meat | 65 |  | Paint | 53 |  | #N/A | #N/A |  | Meat | 44
 |  | Chicken | 57 |  | #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
 |  |  |  |  | Note: | Select Name from Cell C6
 |  |  |  |  |  | Hide column O
 |  |  |  |  |  | use formula not to show #fNUM! Error
 |  |  |  |  |  | Array formual is used and should be confirmed though Ctrl+Shift+Entre
Spreadsheet: afd94d61-7e5d-4519-a352-44c43eefba3f
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
FEHA | Test | FEHA | Entamoeba histolytica Antigen, EIA | Entamoeba histolytica Antigen | Enzyme Immunoassay (EIA) | Stool Container: Stool |  |  | 1 | g | Collect 1 gram fresh unpreserved stool, ship frozen. NOTE: 1. Separate specimens must be submitted when multiple                      tests are ordered.                  2. Unacceptable: [NAME] transport media. | 1 gram | Specimens other than	Feces Anticoagulants other than	NA Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icteric	NA | Reference Range:  Negative   The Entamoeba histolytica antigen EIA test detects only the antigen of the pathogenic E. histolytica ; it will not detect the non-pathogenic E. dispar.    Test Performed by: Focus Diagnostics, Inc.                                        5785 Corporate Ave.                                        Cypress, CA 90630-4750 | Monday, Wednesday, Friday | 1-3 days | 3-5 days | 1 | 87337 |  |  |  |  | Focus Diagnositics, Inc.
FEHA | [NAME] | FECAL | Fecal |  |  |  | Frozen
FEHA | Result | Z2070 | Entamoeba histolytica Antigen | Entamoeba histolytica Antigen | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process