tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 121074d1315833497-average-the-largest-n-if-average_large
Sheet: Sheet2

x | y |  | 1 | 9 |  | Q1 2008 | 5000 | Suffolk |  | #N/A
a | y | 1 | 1 | 9 |  | Q1 2009 | 5000 | West Glamorgan |  | #N/A
x | y | 2 | 3 | 6.666666666666667 |  | Q1 2011 | 5000 | West Midlands |  | #N/A
x | y | 3 | 4 | 5.75 |  | Q1 2011 | 5000 | Northumberland |  | #N/A
x | x | 4 | 5 | 5 |  | Q2 2008 | 5000 | [NAME] |  | #N/A
x | y | 5 | 6 | #N/A |  | Q2 2008 | 5000 | West Yorkshire |  | #N/A
x | y | 6 |  |  |  | Q2 2008 | 5000 | Northumberland |  | #N/A
u | a | 7 |  |  |  | Q2 2008 | 5000 | South Yorkshire |  | #N/A
x | a | 8 |  |  |  | Q2 2009 | 5000 | Lancashire |  | #N/A
x | y | 9 |  |  |  | Q2 2011 | 5000 | [NAME] and [NAME]
 |  |  |  |  |  | Q3 2008 | 5000 | [NAME] and [NAME]
 |  |  |  |  |  | Q4 2008 | 5000 | Derbyshire
 |  |  |  |  |  | Q4 2010 | 5000 | [NAME]
 |  |  |  |  |  | Q4 2010 | 5000 | [NAME] and [NAME]
 |  |  |  |  |  | Q4 2010 | 5000 | West Glamorgan
 |  |  |  |  |  | Q1 2008 | 15000 | South Humberside
 |  |  |  |  |  | Q1 2008 | 15000 | South Humberside
 |  |  |  |  |  | Q1 2008 | 15000 | Lancashire
 |  |  |  |  |  | Q1 2008 | 15000 | Lincolnshire
 |  |  |  |  |  | Q1 2008 | 15000 | Norfolk
 |  |  |  |  |  | Q1 2008 | 15000 | Lincolnshire
 |  |  |  |  |  | Q1 2008 | 15000 | South Yorkshire
 |  |  |  |  |  | Q1 2008 | 15000 | Cheshire
 |  |  |  |  |  | Q1 2008 | 15000 | Lancashire
 |  |  |  |  |  | Q1 2009 | 15000 | Essex
 |  |  |  |  |  | Q1 2009 | 15000 | Gwynedd
 |  |  |  |  |  | Q1 2009 | 15000 | West Glamorgan
 |  |  |  |  |  | Q1 2009 | 15000 | West Glamorgan
 |  |  |  |  |  | Q1 2009 | 15000 | Cleveland
 |  |  |  |  |  | Q1 2011 | 15000 | North Humberside
 |  |  |  |  |  | Q1 2011 | 15000 | Suffolk
Spreadsheet: 139151d1328106780-multiple-vlookups-with-a-match-and-isna-component-or-not-multiple-lookups-with-one-using-a-string-match
Sheet: Sheet1

The table to be filled |  |  | The table for a single word match |  |  | The list of exact business names to match
Business | [NAME] |  | Name Match | [NAME] |  | Business Match | [NAME]
Pharmacy on Main |  |  | Pharmacy | 44611 |  | Vacant | 9999
Doug's Pharmacy |  |  | Convenience | 44512 |  | Convenience Supercenter | 44512
Corner Convenience
Convenience Supercenter
Vacant
What I am used to so far
Business | [NAME]
Pharmacy on Main |  | The problem: while each of these have the word Pharmacy OR Convenience, they are not an exact match for VLOOKUP.  What I would like to do is match the string "Pharmacy" or "Convenience" to return the respective NAICS codes in Col2 of the Name Match table.  Likely this will be in the terms if IF(ISNA) such that if the Business match doesnt provide an exact match it will return #N/A directing Excel to perform the alternative search.
Doug's Pharmacy
Corner Convenience
Convenience Supercenter
Vacant
 |  | THANK YOU FOR GIVING THIS A LOOK!!!
Spreadsheet: 732132d1620790534-how-can-i-make-this-formula-simpler-shorter-sumif-test-file-actual-format-ans
Sheet: Sheet1

Partner number | C1 - city |  |  |  |  |  |  |  |  | C2 - city |  |  |  |  |  |  |  |  | C3 - city |  |  |  |  |  |  |  |  | C4 - city
 | Expert/trainer 1 |  |  |  | Expert/trainer 2 |  |  |  |  | Expert/trainer 1 |  |  |  | Expert/trainer 2 |  |  |  |  | Expert/trainer 1 |  |  |  | Expert/trainer 2 |  |  |  |  | Expert/trainer 1 |  |  |  | Expert/trainer 2
 | # days | other data | other data | other data | # days | other data | other data | other data | other data | # days | other data | other data | other data | # days | other data | other data | other data | other data | # days | other data | other data | other data | # days | other data | other data | other data | other data | # days | other data | other data | other data | # days | other data | other data | other data | other data
P1 | 2 |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | 3 |  |  |  | 2 |  |  |  |  | 1 |  |  |  | 1
P2 | 3 |  |  |  | 2 |  |  |  |  | 4 |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  | 3 |  |  |  | 3
P3 |  |  |  |  | 4 |  |  |  |  | 2 |  |  |  | 3 |  |  |  |  | 4 |  |  |  | 4
P4 | 2 |  |  |  | 3 |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 2
P5 | 4 |  |  |  |  |  |  |  |  | 1 |  |  |  | 4 |  |  |  |  | 3 |  |  |  | 3 |  |  |  |  | 3 |  |  |  | 3
P6 |  |  |  |  | 5 |  |  |  |  | 3 |  |  |  | 1
P7 | 4 |  |  |  | 2 |  |  |  |  |  |  |  |  | 3 |  |  |  |  | 1 |  |  |  | 3 |  |  |  |  | 3
P8 | 2 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 2 |  |  |  | 2 |  |  |  |  | 2 |  |  |  | 3
P9 | 3 |  |  |  | 4 |  |  |  |  | 2 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
P10 | 1 |  |  |  |  |  |  |  |  | 3 |  |  |  | 2 |  |  |  |  | 2 |  |  |  | 2 |  |  |  |  | 2
TOTAL
 |  |  | FORMULA
Total participants
Spreadsheet: 20ad4b35-0e39-45c8-a18d-252afe785683
Sheet: InstructionalMethod

Code | Type | Definition
CR | Classroom | Instruction is predominately face-to-face in a classroom setting; internet and other instructional management systems maybe employed to track grades, assignments and homework.
CP | Computer Program | All instruction is delivered through a computer program which may be online or from a CD-ROM.
ITVS | ITV Sending | Interactive live video course.  This designation denotes the section where the instructor is present.
ITVR | ITV Receiving | Interactive live video course.  This designation denotes the section in which students receive the course via ITV.
BH | Blended/Hybrid | This designation denotes reduced classroom seat time and some instruction delivered online.  This designation blends online and face-to-face delivery.
G | Guided | Teacher acts as guide or mentor to student independent work.  Use this designation for scheduled courses classified according to the MCCC as Independent Study.
CO | Completely Online | All instruction is delivered online.  This designation has no required face-to-face meetings.  A student may arrange meetings with small groups of classmates or the instructor.
O | Other | Use this designation when no other designation adequately describes the course delivery type.
Spreadsheet: lynn_blair__24416__NNGWKednotes
Sheet: June 9 & 10, 2001 

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-06-09 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | FRI |  |  | Not able to complete Final AM due server down.
 | 8:00 AM Final Storage |  |  |  | [NAME] and [NAME]  completed the 8:00 am process on 6/10 @3:00 a.m.
 | Gas Day: | SAT |  |  | No process  ran due to server being down.  Customers were emailed
 | 10:00 A.M. Intraday 1: |  |  |  | stating that due to server problems NNG would use the evening scheduled
 |  |  |  |  | for  ID1, ID2, and Final 8 am process
 | Gas Day: | SAT | 2001-06-10 00:00:00 |  | Due to server being down used 6/9/01 final scheduled volumes for
 | 11:30 A.M. Timely |  |  |  | all cycles
 | Gas Day: | SAT |  |  | used evening scheduled volumes
 | 5:00 P.M. Intraday 2:
 | Gas Day: | SAT | 2001-06-10 00:00:00 |  | Due to server being down used 6/9/01 final scheduled volumes for
 | 6:00 P.M. Evening |  |  |  | all cycles
 | Comments:
 |  |  |  |  | On Call Reps. | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 | SUNDAY
 | Gas Day: | SUN | 2001-06-10 00:00:00 |  | Due to server being down used 6/9/01 final scheduled volumes for
 | 7:00 A.M. Non-grid: |  |  |  | all cycles
 | Gas Day: | SUN | 2001-06-10 00:00:00 |  | Due to server being down used 6/9/01 final scheduled volumes for
 | 10:00 A.M. Intraday 1: |  |  |  | all cycles
 | Gas Day: | SUN | 2001-06-11 00:00:00 |  | No difficulties with the process
 | 11:30 A.M. Timely
 | Gas Day: | SUN | 2001-06-10 00:00:00 |  | Due to server being down used 6/9/01 final scheduled volumes for
 | 5:00 P.M. Intraday 2: |  |  |  | all cycles
 | Gas Day: | SUN | 2001-06-11 00:00:00 |  | No difficulties with the process
 | 6:00 P.M. Evening
 | Other Comments: |  | The schedulers would like to thank [NAME] and  Legale Black for
 |  |  | their assistance during the weekend.
 |  |  | [NAME] went to Omaha, he did NBPL confirmations
 | On Call Reps. |  |  |  | [NAME] |  | 6:30 - 3:00
 |  |  |  |  | [NAME] |  | 7:30 -11:00 /  5:00 - 10:00
 |  |  |  |  | [NAME] |  | 10:30 - 10:00
 |  |  |  |  | [NAME] |  | 10:30 - 5:15
 |  |  |  |  | [NAME] |  | 6:30 - 5:00
 |  |  |  |  | [NAME] |  | 2:00 - 9:00
Spreadsheet: 2883f166-51fb-4cd5-a7c6-22b825abcacd
Sheet: NOC India

Country | Title | Name | Surname | Company | Position | Country Code | Area Code | [NAME] | Fax | [NAME] | Website
India | Mr. | [NAME] | Tinel | Clause (India) Private Limited | Manager Sales & Marketing | 91 | 40 | 27504677 | 27504641 | nicolas.tinel@clause | www.clausetezier.com
India | Mr. | G.V.Bhasker | [NAME] |  | Convenor, NOC
India | Mr. | Harish | Reddy | Ganga Kaveri Seeds (P) Ltd | Managing Director, |  |  |  |  | [EMAIL]
India | Mr. | Dinesh C. | [NAME] | Indian Foundation Seed and Services Association(IFSSA) | Coordinator | 91 | 40 | 2337 2174 | 2332 5965 | [EMAIL] | [NAME]
India | Mr. | [NAME] | G.V. | Kaveri Seed Company Limited | Chairman and Managing Director | 91 | 40 | 27899833 | 27811237 | [EMAIL] | www.kaveriseeds.in
India | Mr. | [NAME] | Tinel |  | Member, NOC
India | Mr. | [NAME] | Kanwal | Namdhari Seeds Pvt. Ltd. | Chairman, NOC
India | Mr. | [NAME] | [NAME] | Nuziveedu Seeds Pvt Ltd | Co-Chairman [NAME] |  |  |  |  | [EMAIL]
India | Mr. | ASN | Reddy | SeedWorks India Pvt. Ltd. | COO | 91 | 40 | 23356354 | 23356359 | [EMAIL] | www.seedworksindia.com
Spreadsheet: 887537d1737758502-conditional-formatting-match-fill-font-adjacent-cell-activity-report
Sheet: Sheet1

 | SALES EFFORT  JANUARY 1-17 | OPPORTUNITES | CALLS CONNECTED | EMAILS | TEXTS | VIDEOS | APPOINTMENTS | TOTAL ACTIVITY | MASTERMIND
 | [NAME] | 109 | 128 | 693 | 436 | 94 | 14 |  | 92
 | [NAME] | 93 | 17 | 490 | 575 | 174 | 19 |  | 0
 | [NAME] | 84 | 34 | 290 | 539 | 73 | 23 |  | 30
 | [NAME] | 43 | 19 | 81 | 657 | 43 | 14 |  | 0
 | [NAME] | 44 | 37 | 96 | 559 | 14 | 14 |  | 0
 | [NAME] | 71 | 8 | 69 | 490 | 47 | 7 |  | 0
 | [NAME] | 63 | 44 | 124 | 349 | 42 | 18 |  | 4
 | [NAME] | 56 | 24 | 77 | 444 | 13 | 13 |  | 21
 | [NAME] | 61 | 39 | 379 | 114 | 5 | 0 |  | 38
 | [NAME] | 80 | 60 | 124 | 262 | 70 | 21 |  | 2
 | [NAME] | 24 | 4 | 156 | 202 | 29 | 5 |  | 0
 | [NAME] | 48 | 11 | 46 | 244 | 22 | 1 |  | 0
 | [NAME] | 37 | 39 | 48 | 164 | 20 | 2 |  | 1
 | [NAME] | 8 | 3 | 63 | 182 | 5 | 1 |  | 0
 | Ashraf [NAME] | 66 | 15 | 133 | 26 | 58 | 6 |  | 0
 | [NAME] | 45 | 6 | 144 | 34 | 12 | 6 |  | 4
 | [NAME] | 54 | 7 | 46 | 127 | 11 | 6 |  | 1
 | Blanca Feliu | 30 | 10 | 97 | 82 | 2 | 3 |  | 1
 | [NAME] | 41 | 1 | 38 | 111 | 23 | 7 |  | 0
 | Kendry Candelario | 13 | 1 | 15 | 123 | 10 | 1 |  | 0
 | [NAME] | 13 | 12 | 65 | 66 | 3 | 2 |  | 0
 | [NAME] | 19 | 18 | 83 | 8 | 12 | 5 |  | 40
 | [NAME] | 29 | 14 | 21 | 59 | 10 | 9 |  | 0
 | [NAME] | 30 | 7 | 40 | 34 | 10 | 8 |  | 0
 | [NAME] | 14 | 22 | 14 | 39 | 14 | 0 |  | 15
 | [NAME] | 4 | 8 | 9 | 1 | 1 | 3 |  | 11
 | [NAME] | 22 | 2 | 3 | 1 | 0 | 0 |  | 0
 | [NAME] | 15 | 0 | 0 | 1 | 0 | 3 |  | 0
Spreadsheet: darrell_schoolcraft__7353__imball0201
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 178998 | 177703 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 179049 | 178823 |  | -643 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 200325 | 201502 |  | -1041 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 198276 | 198103 |  | -1127 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 182664 | 181182 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 185625 | 184935 |  | -64 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 180945 | 182612 |  | -413 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 171448 | 170921 |  | -766 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 167085 | 165766 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 180242 | 185290 |  | -5992 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 | 156730 | 168069 |  | -2752 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 | 161920 | 162390 |  | -1246 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 | 168860 | 168387 |  | -785 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14 | 176296 | 175896 |  | -227
15 | 178640 | 178477 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 | 174560 | 173631 |  | -412 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 | 168943 | 168259 |  | -181 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18 | 165038 | 165930 |  | -329
19 | 165527 | 164522
20 | 167474 | 167124
21
22
23
24
25
26
27
28
29
30
31
 | 2001-12-31 00:00:00 |  |  |  | -22389
 | 2002-01-20 00:00:00
 | CBS Dollars
 |  |  |  | -507608
Spreadsheet: 77fde286-c84e-4f5c-9579-20d1f1edee4d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
SEATTLE UNIVERSITY |  |  |  |  | Sponsored Agreement |  |  |  |  | PLEASE DO NOT WRITE IN THIS AREA
[NAME]
When complete, please send to Purchasing Office to generate PO.  All orders over $500.00 require a PO.
TODAYS DATE |  |  |  |  | PRODUCT NEED BY DATE |  |  | REQUISITION # | (IF USED) | ENTRY DATE |  | P.O. #
2010-10-06 15:55:10.430000
SU ORG / DEPARTMENT |  |  |  |  | SHIPPING METHOD | (BEST WAY ) |  |  |  | ENTERED BY |  | VENDOR #
END USER NAME |  | PHONE |  | PHONE | [NAME] TO:  NAME |  | BLDG |  | ROOM # | ORDER#
BILLING CONTACT NAME |  | PHONE |  | PHONE | PO COPIES TO:  NAME |  | BLDG |  | ROOM # | CONFIRMATION #
# | ITEM # | [NAME] |  |  |  | UNIT | UNIT PRICE | QUANTITY | TOTAL PRICE | BILL TO ACCOUNT
EX | 123-456 | Product Details |  |  |  | EA | 1 | 9 | 9 | XX - XXXXXX - XXXXX
1 |  |  |  |  |  |  |  |  | 0
2 |  |  |  |  |  |  |  |  | 0
3 |  |  |  |  |  |  |  |  | 0
4 |  |  |  |  |  |  |  |  | 0
5 |  |  |  |  |  |  |  |  | 0
6 |  |  |  |  |  |  |  |  | 0
7 |  |  |  |  |  |  |  |  | 0
8 |  |  |  |  |  |  |  |  | 0
9 |  |  |  |  |  |  |  |  | 0
10 |  |  |  |  |  |  |  |  | 0
11 |  |  |  |  |  |  |  |  | 0
12 |  |  |  |  |  |  |  |  | 0
13 |  |  |  |  |  |  |  |  | 0
14 |  |  |  |  |  |  |  |  | 0
15 |  |  |  |  |  |  |  |  | 0
16 | SHIPPING & HANDLING FEE (TAXABLE) |  |  |  |  | LOT |  | 1 | 0
SPECIAL INSTRUCTIONS: |  |  |  |  |  |  |  | SUB TOTAL | 0
 |  |  |  |  |  |  |  | TAX       9.5% | 0 | AUTHORIZED DEPT SIGNATURE
WORKORDER OR PROJECT TO BE USED FOR: |  |  |  |  |  |  |  | TOTAL | 0
SUGGESTED VENDOR: |  | ADDRESS | ADDRESS |  | PHONE |  |  | FAX |  | PRINTED NAME
 |  |  |  |  |  |  |  |  |  | REQUIRES ORSSP APPROVAL FOR CONTRACT AND GRANT ACCOUNTS
 | Vendor is on the ORSSP Approved Vendor List--No W-9 is required
PRICE SOURCE: |  |  |  |  |  |  | TERMS | FOB
Example: Catalog; [NAME]; Phone; Verbal; Written; Estimate.   Attach quotation. |  |  |  |  |  |  | Net 30 | Source
Spreadsheet: 0ee4e49b-fecd-4431-ac12-cf9842084db4
Sheet: Sheet1

Challenges of value-added data component | 52
Desire for MDE support:  communication, models, training, etc. | 40
Financial burden of unfunded mandate | 39
Flexibility in plan development & implementation; local control | 31
Keep plan simple, feasible, realistic, reasonable, manageable | 27
Amount of time to implement | 13
Unique schools:  small, rural, charter, intermediate, itinerant staff | 12
Plan is research-based, appropriately measures all staff, & tied to PD | 11
Timeline & legislative feedback for initial implementation | 10
Difficulty of juggling all responsibilities & required mandates | 5
Spreadsheet: keith_holst__19410__DIRT
Sheet: Matt SCAL

B/S | Counterparty | Volume | Term | Broker | Deal Date | TAGG No.
S | Mirant | 5000 | N-M | APB | 2001-10-09 00:00:00 | Y89050
B | Cinergy | 5000 | N-M | TFS | 2001-10-11 00:00:00 | Y97298
Spreadsheet: 99148d1297878485-pop-up-menu-appears-when-certain-option-is-picked-uploadtest_5
Sheet: Associations

Company Name
[NAME] | ID= | 30
Station
Grande_Prairie | ID= | -1376097810
Province
Alberta | ID= | -1732842940
Employee
W Andrews | ID= | 1417
C Szeszorak | ID= | 1374
A Hinman | ID= | 1398
0 | ID= | 0
0 | ID= | 0
R Bernas | ID= | 1407
0 | ID= | 0
0 | ID= | 0
Sub-Job Type |  | Grease or No Grease |  |  | Non-Ballistic Services | Ballistic Devices | Mis-runs Devices
0 |  | 0 |  |  | 0 | 0 | 1
0 |  | Grease |  |  | 0 | 0 | 0
0 |  | 0 |  |  | 0 | 1 | 0
0 |  | 0 |  |  | 1 | 0 | 0
0 |  | 0 |  |  | 1 | 1 | 0
0 |  | 0 |  |  | 0 | 1 | 0
0 |  | 0 |  |  | 0 | 1 | 0
0 |  | 0 |  |  | 0 | 0 | 1
0 |  | 0 |  |  | 0 | 1 | 0
0 |  | 0 |  |  | 0 | 1 | 0
0 |  | 0 |  |  | 0 | 1 | 0
0 |  | 0 |  |  | 0 | 1 | 0
0 |  | 0 |  |  | 0
0 |  | 0 |  |  | 0
0 |  | 0 |  |  | 0
0 |  | 0 |  |  | 0
0 |  | 0 |  |  | 0
0 |  | 0 |  |  | 0
0 |  | 0 |  |  | 0
0 |  | 0 |  |  | 0
0 |  | 0 |  |  | 0
0 |  | 0 |  |  | 0
0 |  | 0 |  |  | 0
0 |  | 0 |  |  | 0
0 |  | 0 |  |  | 0
0 |  | 0 |  |  | 0
0 |  | 0 |  |  | 0
0
Standard
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 2

 | November 15 | November 22 | November 29 | December 6 | December 13
Total Interest Rate* | 638969343 | 666542310 | 657834881 | 660225913 | 741509415
SDs and MSPs** | 531767215 | 559186535 | 552360963 | 557778712 | 633677555
Other | 107202128 | 107355775 | 105473917 | 102447202 | 107831860
Total Cross-Currency | 24113807 | 27033776 | 23418311 | 24292721 | 28367503
SDs and MSPs | 19092971 | 21978892 | 19826164 | 20605038 | 24586862
Other | 5020836 | 5054884 | 3592147 | 3687683 | 3780641
Total Credit | 18294795 | 18838704 | 18912214 | 18568590 | 18595270
SDs and MSPs | 13986002 | 14277808 | 14277521 | 13961086 | 13940658
Other | 4308793 | 4560896 | 4634693 | 4607504 | 4654612
Total FX**** | 62900000 | 62900000 | 62900000 | 62900000 | 62900000
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**** | 8840000 | 8840000 | 8840000 | 8840000 | 8840000
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**** | 3400000 | 3400000 | 3400000 | 3400000 | 3400000
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 | 756517945 | 787554790 | 775305406 | 778227224 | 863612188
Weekly snapshot, gross notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, and participant types, cleared and uncleared. For cleared swaps, the notional value for 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, the notional value of the swap is attributed to both swap counterparties. Because this table shows the aggregated notional values of swaps by participant, the totals on this table are twice those displayed on the "Gross Notional Outstanding 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.
****These numbers are estimates.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 769409d1645527678-if-and-function-gives-value-error-counting-not-summing-aligw
Sheet: Sheet1

Region | Client type | Ranking
EMEA | B | 4
APAC | A | 7
APAC | A | 7
APAC | A | 10
EMEA | A | 7
EMEA | C | -1
EMEA | A | 9
EMEA | A | 9
EMEA | A | 10
EMEA | B | 8
EMEA | B | 9
EMEA | A | 8
EMEA | B | -1
AMERICAS | A | 10
APAC | D | 10
EMEA | A | 8 |  |  |  |  |  |  |  |  |  |  |  | ENTER PARAMETERS HERE:
EMEA | E | -1
APAC | A | -1 |  |  |  |  |  |  |  |  |  |  |  | Region: | EMEA
APAC | F | 8 |  |  |  |  |  |  |  |  |  |  |  | Client Type: | A
APAC | A | 8 |  |  |  |  |  |  |  |  |  |  |  | Ranking from: | 7 | to: | 8
 |  |  |  |  |  |  |  |  |  |  | "A" | RESULT:
 |  |  |  |  |  |  |  |  |  | >8
 |  |  |  |  |  |  |  |  |  | 7, 8
Spreadsheet: 329690d1404385183-counting-no-of-unique-columns-couting-unique-columns
Sheet: Sheet1

Market 1 | Market 2 | Market 3 | Market 4 | Market 5 | Market 6 | Market 7 | Market 8
H1 | H1 | H1 | H1 | H1 | H1 | H1 | H1 | No. Of unique columns
H5 | H5 | H5 | H5 | H5 | H5 | H5 | H5 | 5
I7 | I6 | I7 | I6 | I6 | I7 | I6 | I7
I9 | I7 | I9 | I7 | I7 | I9 | I7 | I9
 | I9 |  | I9 | I9 |  | I9 | K2
 |  |  |  | K2 |  | K2 | K3
 |  |  |  | K3 |  | K3 | K5
 |  |  |  | K6 |  | K5 | K6 | [NAME] columns
 |  |  |  | M7 |  | K6 | M7 | 3
 |  |  |  | O1 |  | M7 | O1
 |  |  |  |  |  | O1
 |  |  |  |  |  |  |  | for calculting code I have used array formula…
 |  |  |  |  |  |  |  | so use ctrl + shift + enter   to enter the formula…
 |  |  |  |  |  |  |  | don't use only enter
 |  |  |  |  |  |  |  | I have used conditional formatting so do care of it…
 |  |  |  |  |  |  |  | please click * to appreciate…
H1H5I7I9 | H1H5I6I7I9 | H1H5I7I9 | H1H5I6I7I9 | H1H5I6I7I9K2K3K6M7O1 | H1H5I7I9 | H1H5I6I7I9K2K3K5K6M7O1 | H1H5I7I9K2K3K5K6M7O1
3 | 2 | 3 | 2 | 1 | 3 | 1 | 1
 |  |  |  |  |  |  |  |  | function [NAME] as range)
 |  |  |  |  |  |  |  |  | combo=""
 |  |  |  |  |  |  |  |  | for each cell in x
 |  |  |  |  |  |  |  |  | Combo=combo & cell.value
 |  |  |  |  |  |  |  |  | next
 |  |  |  |  |  |  |  |  | end funtion
Spreadsheet: 59122d1259590735-formula-to-capture-values-from-one-sheet-to-another-sampletest
Sheet: Team View

 | [NAME] (000's) |  |  |  |  |  |  |  |  |  |  |  |  | F11 (000's) | F10 Total FTE
 | ACT | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | Total
Run Rate Reduction | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00
ISO
Six Sigma
LEAN/Broken Windows
Other
Productivity Initiatives
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Target | 31.8 | 37.7 | 43.5 | 60.2 | 60.2 | 60.2 | 69.3 | 103.5 | 103.5 | 103.5 | 111.8 | 115.2 | 900.4 | 1385.4 | 10.4
Net | -31.8 | -37.7 | -43.5 | -60.2 | -60.2 | -60.2 | -69.3 | -103.5 | -103.5 | -103.5 | -111.8 | -115.2 | -900.4 | -1385.4
 | [NAME] (000's) |  |  |  |  |  |  |  |  |  |  |  |  | F11 (000's) | F10 Total FTE
Run Rate Reduction | ACT | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | Total
Team | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00
Client Services | 0 | 0 | 4.17 | 9.17 | 9.17 | 9.17 | 9.17 | 9.17 | 9.17 | 9.17 | 9.17 | 9.17 | 86.7 | 110.04
Target | 10.6 | 12.5 | 14.5 | 20 | 20 | 20 | 23 | 34.4 | 34.4 | 34.4 | 37.2 | 38.3 | 299.3 |  | 3.4
Net | -10.6 | -12.5 | -10.33 | -10.83 | -10.83 | -10.83 | -13.83 | -25.23 | -25.23 | -25.23 | -28.03 | -29.13 | -212.6