tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 851094d1701346081-how-to-vlook-up-one-cell-from-a-sheet-to-show-the-whole-row-on-another-sheet-113023
Sheet: Biometrics Masterfile

Biometrics Name | First Name | Middle Name | Last Name | Full Name | Company | Area | Position | SSS | PAG-IBIG | PHILHEALTH | TIN | RATE
AAAlasagas
RASajonia
VAArenilla2 |  |  |  | [NAME]
ATOmac
JZTabid2 |  |  |  | [NAME] Tabid
LOCambarihan
EVTagaro
[NAME] |  |  |  | [NAME] Tabid
AVGaldo
MCVillaren
MMUnson
RDAniel
RRMaandig
RTSiarot
EPSujetado
RIDumaboc
VEFlores
FOMosqueda
WCCainoy
JOCambarihan
DBImbor
EBBangcong
MBImbor
DMBulontad
RADayas
JOCanete
MPDatu
DDHermogenes
AMSereno
DVLagunay
MVEgan
JYArancana
MABardon
RAGurro
RAMarianas
AKRementizo
JDSalmo
Spreadsheet: 570382d1524006645-looking-for-a-work-breakdown-structure-wbs-sample-spreadsheet-wbf-for-jeff
Sheet: Sheet2

[Table="class: grid"]
[tr] [td] | Index | [/td] [td] | Input | [/td] [td] | Output Function | [/td] [td] | Output Result | [/td] [/tr]
[tr] [td] |  | [/td] [td] |  | [/td] [td] | 00.00.00 | [/td] [td] | 00.00.00 | [/td] [/tr]
[tr] [td] | 1 | [/td] [td] | 1 | [/td] [td] |  | [/td] [td] | 01.00.00 | [/td] [/tr]
[tr] [td] | 2 | [/td] [td] | 2 | [/td] [td] |  | [/td] [td] | 01.01.00 | [/td] [/tr]
[tr] [td] | 3 | [/td] [td] | 2 | [/td] [td] |  | [/td] [td] | 01.02.00 | [/td] [/tr]
[tr] [td] | 4 | [/td] [td] | 3 | [/td] [td] |  | [/td] [td] | 01.02.01 | [/td] [/tr]
[tr] [td] | 5 | [/td] [td] | 3 | [/td] [td] |  | [/td] [td] | 01.02.02 | [/td] [/tr]
[tr] [td] | 6 | [/td] [td] | 1 | [/td] [td] |  | [/td] [td] | 02.00.00 | [/td] [/tr]
[tr] [td] | 7 | [/td] [td] | 2 | [/td] [td] |  | [/td] [td] | 02.01.00 | [/td] [/tr]
[tr] [td] | 8 | [/td] [td] | 2 | [/td] [td] |  | [/td] [td] | 02.02.00 | [/td] [/tr]
[tr] [td] | 9 | [/td] [td] | 3 | [/td] [td] |  | [/td] [td] | 02.02.01 | [/td] [/tr]
[tr] [td] | 10 | [/td] [td] | 3 | [/td] [td] |  | [/td] [td] | 02.02.02 | [/td] [/tr]
[/table]
Spreadsheet: 63ec9170-dda3-4538-82d2-6b05dca18d7d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-06-02 09:43:03.790000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.75 | 102.625 | 102.5 | 102.125
4.5 | 102.715 | 102.59 | 102.465 | 102.09 |  | Note: | Refer To Price [NAME]
4.375 | 102.271 | 102.146 | 102.021 | 101.646 |  |  | For all Price Adjs
4.25 | 101.685 | 101.56 | 101.435 | 100.81
4.125 | 100.829 | 100.704 | 100.579 | 99.954
4 | 99.835 | 99.71 | 99.585 | 98.96
3.875 | 98.798 | 98.673 | 98.548 | 97.923
3.75 | 97.923 | 97.798 | 97.673 | 97.048
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.873 | 102.748 | 102.623 | 102.248
3.625 | 102.488 | 102.363 | 102.238 | 101.863
3.5 | 101.945 | 101.82 | 101.695 | 101.32
3.375 | 101.225 | 101.1 | 100.975 | 100.6
3.25 | 100.633 | 100.508 | 100.383 | 99.758
3.125 | 100.199 | 100.074 | 99.949 | 99.324
3 | 99.449 | 99.324 | 99.199 | 98.574 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-06-16 09:43:03.790000
30 DAY | 2014-07-01 09:43:03.790000
45 DAY | 2014-07-16 09:43:03.790000
60 DAY | 2014-07-31 09:43:03.790000
90 DAY | 2014-08-30 09:43:03.790000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 1abeb744-2d3e-4c4a-921f-d6c04d8f5fec
Sheet: Personnel Type Payroll

SFY 2015 STATE CODE SHEET
SFY 2015 STATE EDRS-UFARS codes crosswalk
UFARS Object Codes to EDRS Personnel Type Code
Payroll Personnel - SERVICE CODE A
UFARS OBJECT CODE | EDRS PTC | [NAME]
140 | 1 | Teacher (Requires Setting Code)
143 | 2 | Program Coordinator/Due Process Faciliator/Teacher on Special Education Assgnment (TOSA) (Non-Supervisory)
140 | 3 | Academic & Behavioral Strategist
150 | 4 | Physical Therapy Services
151 | 5 | Occupational Therapy Services
154 | 6 | School Nurse
152 | 7 | Educational Speech/Language Pathologist (Requires Setting Code)
161 | 8 | Paraprofessional/Personal Care Assistant
110 | 9 | Director of Special Education
110 | 10 | Assistant Director/Supervisor
156 | 11 | School Social Worker
175 | 12 | Cultural Liaison (Requires Activity Code)
157 | 13 | School Psychologist
153 | 14 | Audiologist
174 | 15 | Adaptive Physical Education Specialist
145 | 23 | Substitute Teachers
143 | 25 | Other Licensed/Certified Therapist - e.g. Music Therapist (Prior Approval Required)
163 | 26 | Foreign Language Interpreter
144 | 27 | Vision Media Assistant
164 | 28 | Interpreter for the Deaf
173 | 29 | Certified Orientation/Mobility Speciaist for Visually Impaired
143 | 34 | Assistative Technology Specialist
165 | 35 | School Counselor
173 | 37 | Certified Orientation/Mobility Assistant for Visually Impaired
168 | 38 | Security Specialist (Prior Approval Required)
176 | 40 | Social Worker for Interagency Activities
172 | 42 | Physician (Evaluation Only)
155 | 44 | Licensed Nursing Services
170 | 45 | Teacher Clerical Support Aide (Due Process)
143 | 48 | Behavioral Specialist
158 | 49 | Qualified Mental Health Professional
159 | 50 | Mental Health Behavioral Aide
160 | 52 | Mental Health Practitioner
162 | 53 | One - to -  One Paraprofessional
143 | 55 | Mentors for Interpreters of The Deaf & Hard of Hearing
174 | 57 | Contracted Therapeutic Recreational
146 | 58 | Substitute Para/PCA/One -to - One Para
144 | 59 | Speech/Language Pathology Assistant
155 | 60 | Special Transportation Nursing Services (IEP MA Reporting Only)
161 | 61 | Specail Transportation PCA Services (IEP MA Reporting Only)
185 | 62 | Extracurricular Activities (Staff Only) (Requires Activity Code)
185 | 63 | Licensed Staff Extra Duty Time
186 | 64 | Non-Licensed Staff Extra Duty Time
185 | 99 | Salaries Personnel for Settled Contracts (Can only be used with Service Code 4)
end of worksheet
Spreadsheet: 140829d1328903429-excel-2007-calculating-conditional-and-cumulative-numbers-and-percents-in-a-pivot-table-cumulative-and-conditional-percents
Sheet: Sheet2

RAW DATA |  |  |  |  |  |  | PIVOT TABLE |  |  |  |  |  | DESIRED PRESENTATION (which I had to calculate manually)
state | year | sex | interval | status | count |  | sex | (All)
AL | 2006 | M | 0-1 | Paroled | 50 |  |  |  |  |  |  |  | Data - Per Interval |  |  |  |  | Data - Cumulative
AL | 2006 | M | 0-1 | Died | 4 |  |  | Column Labels |  |  |  |  |  |  |  |  |  |  | Cumulative | Cumulative | Cumulative
AL | 2006 | F | 0-1 | Paroled | 20 |  |  | Paroled |  | Died |  |  | Number Entering Interval | Paroled | Died | % Paroled |  | Population | Paroled | Died | % Paroled
AL | 2006 | F | 0-1 | Died | 2 |  | Row Labels | No. per interval | Cumulative | No. per interval | Cumulative
AL | 2006 | M | 2-4 | Paroled | 15 |  | AL
AL | 2006 | F | 2-4 | Paroled | 10 |  | 2006
AL | 2006 | F | 2-4 | Died | 2 |  | 0-1 | 70 | 70 | 6 | 6
AL | 2006 | M | 5-6 | Paroled | 10 |  | 2-4 | 25 | 95 | 2 | 8
AL | 2006 | M | 5-6 | Died | 2 |  | 5-6 | 14 | 109 | 4 | 12
AL | 2006 | F | 5-6 | Paroled | 4 |  | CA
AL | 2006 | F | 5-6 | Died | 2 |  | 2006
CA | 2006 | M | 0-1 | Paroled | 200 |  | 0-1 | 300 | 300 | 30 | 30
CA | 2006 | M | 0-1 | Died | 20 |  | 2-4 | 80 | 380 | 14 | 44
CA | 2006 | F | 0-1 | Paroled | 100 |  | 5-6 | 80 | 460 | 12 | 56
CA | 2006 | F | 0-1 | Died | 10
CA | 2006 | M | 5-6 | Paroled | 50
CA | 2006 | M | 5-6 | Died | 10 |  |  |  |  |  |  |  | What I'd like to dynamically calculate in the pivot (in blue above)
CA | 2006 | F | 5-6 | Paroled | 30
CA | 2006 | F | 5-6 | Died | 2 |  |  |  |  |  |  |  | 1. The number entering each interval.
 |  |  |  |  |  |  |  |  |  |  |  |  | - For the first (0-1) interval, this is 121 or (70+6+25+2+14+4) (i.e., the Grand Total).
 |  |  |  |  |  |  |  |  |  |  |  |  | - For the subsequent intervals, it's the number of prisoners remaining in prison at the end of the previous interval.
 |  |  |  |  |  |  |  |  |  |  |  |  | For example, it's 45 for the 2-4 interval (121-(70+6)) and 18 for the 5-6 interval (45-(25+2).
 |  |  |  |  |  |  |  |  |  |  |  |  | 2. The % paroled per interval.
 |  |  |  |  |  |  |  |  |  |  |  |  | - The number paroled / the number entering (for each interval)
 |  |  |  |  |  |  |  |  |  |  |  |  | 3. The cumulative % paroled, by interval.
 |  |  |  |  |  |  |  |  |  |  |  |  | - The cumulative number paroled / the entering in the 1st year
Spreadsheet: 0dc62f89-127a-43c4-9972-89e9ae3a41e5
Sheet: Sheet1

Line # | MAKE/MODEL | VENDOR NAME: | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | Crown Victoria | UNIT COST / Part #
 | Part Name | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
1 | Air Filter
2 | Oil Filter
3 | [NAME]
4 | Transmission Filter
 |  | 2003 | 2004 | 2005 | 2010
 | F250 Truck 4x4
1 | Air Filter
2 | Oil Filter
3 | [NAME]
4 | Transmission Filter
 | F350 Truck 4x4
 |  | 2002 | 2003 | 2004 | 20052 | 2007 | 2010
1 | Air Filter
2 | Oil Filter
3 | [NAME]
4 | Transmission Filter
Spreadsheet: 851856d1701975150-seeking-help-need-guidance-on-creating-a-dynamic-calendar-in-excel-with-categorized-tasks-2024-event-calendar-silentia-
Sheet: Events

 | MONTH VIEW | WEEK VIEW
 | EVENTS
 | Description | Due Date (Month, DD, YYYY) | Category
 | Process map creation, gaps analysis | 2024-01-19 00:00:00 | Excellence
 | Test2 | 2024-02-01 00:00:00 | Change
 | Test3 | 2024-01-01 00:00:00 | Holiday
 | EventTalk | 2024-01-01 00:00:00 | Business
 | [NAME]
 | Assignment 6
 | Assignment 7
 | Assignment 8
 | Assignment 9
 | Assignment 10
 | Assignment 11
 | Assignment 12
Spreadsheet: 129132d1321463658-vlookup-over-multiple-sheets-2011-barter-and-trade-test
Sheet: May

Customer | Net | [NAME] | Size | Rep
Another Broken Egg Cafe | 1 | 1 | 1/3 Page Square | [NAME]
I Jump Kids Adventure | 2 | 2 | 1/4 Page | [NAME]
The Melting Pot | 3 | 3 | 1/3 Page Vertical | [NAME]
[NAME]'s Bakery | 4 | 4 | 1/3 Page Square | [NAME]
Spectrum Resorts/See Beach Club | 5 | 5 | 1/2 Page | [NAME]
Red Mountain Theatre Company | 6 | 6 | 2/3 Page | [NAME]
California Pizza Kitchen | 7 | 7 | 1/2 Page | [NAME]
[NAME] | 8 | 8 | 1/3 Page Square | [NAME]
McWane Science Center | 9 | 9 | 1/2 Page | [NAME]
Alabama Public Television | 10 | 10 | 1/3 Page Square | [NAME]
Books A Million | 11 | 11 | 1/3 Page Vertical | [NAME]
[NAME]'s Flower Market | 12 | 12 | 1/3 Page Square | [NAME]
JAMM Entertainment Services | 13 | 13 | 1/3 Page Square | [NAME]
Al.com | 14 | 14 | 2/3 Page | [NAME]
Digital Signage 3 | 15 | 15 | 1/3 Page Square | [NAME]
[NAME] | 16 | 16 | 1/3 Page Square | [NAME]
Zoots Music | 17 | 17 | 1/2 Page | [NAME]
Birmingham Mountain Radio | 18 | 18 | [NAME] | [NAME]
Cultural Alliance of Greater Birmingham - Birmingham 365 | 19 | 19 | [NAME] | [NAME]
The Birmingham News | 20 | 20 | [NAME] | [NAME]
Magic City Art Connection | 21 | 21 | [NAME] | [NAME]
Norton's Florist | 22 | 22 | [NAME] | [NAME]
The Hangout Music Festival (Music Allies) | 23 | 23 | [NAME] | [NAME]
Spreadsheet: 2280d794-6467-442d-a0d3-e4400228bed3
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43042700 | 2014-09-06 13:17:59 | ALLIES | 1 | 7 | 4 | 1392924 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43042808 | 2014-09-06 13:40:50 | AXIS | 1 | 7 | 5 | 1392924 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43048725 | 2014-09-06 21:59:30 | ALLIES | 0 | 3 | 7 | 1530567 | tommikins | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43048984 | 2014-09-06 22:22:46 | AXIS | 1 | 7 | 6 | 1530567 | tommikins | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43064077 | 2014-09-07 21:46:03 | AXIS | 1 | 7 | 3 | 550389 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43064456 | 2014-09-07 22:11:08 | ALLIES | 0 | 4 | 7 | 550389 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43067213 | 2014-09-08 01:29:27 | AXIS | 0 | 5 | 7 | 706396 | Intello | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43067395 | 2014-09-08 01:47:57 | ALLIES | 1 | 7 | 5 | 706396 | Intello | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
Spreadsheet: 145327d1331535054-sheet-number-to-be-dynamic-in-the-formula-copy_test-
Sheet: 2

 | Date
 | Total Invoices to be Processed
 | Total Invoices Processed
 | Total Pending
 | MTD Invoices Processed
 | Description | [NAME] |  | Assigned to |  | Status |  | Pending
 |  | Imported | Approved | Imported | Approved | Imported | Approved | Imported | Approved
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 6
Spreadsheet: 39738d1238014841-ms-query-question
Sheet: Sheet1

ST | Totals
AZ | 2
CA | 2
CO | 2
ID | 2
IN | 5
KY | 1
ME | 6
OH | 3
TX | 1
UT | 14
VT | 9
WA | 14
WI | 6
WY | 3
Grand Total | 70
**Like I mentioned here is the state list.. You wil notice that not all the states are listed because they have ZERO.  How do I make it so the query will return all the states even with a zero.
Thanks
Spreadsheet: 763870d1642437440-indirect-index-match-using-a-tables-name-file1
Sheet: P11

P10
# [NAME] | Forecast | Previous forecast | Difference
111111 | 12000
222222 | 12000
333333 | 15500
444444 | 10750
555555 | 9000
666666 | 7500
777777 | 24000
888888 | 32000
999999 | 8000
What I need :
I need to combine INDIRECT and the formula in column C, using A3 value, so I dont have to change the table's name each time in the formula.
With INDIRECT, I guess we should see "FORE"&$A$3 in the formula. But I haven't succeded so far…
Spreadsheet: 841240d1693443706-unique-count-filter-count-lookup-test-solution-
Sheet: New Dept

 |  |  | Department Code | Job Description
 |  |  | TN-PR-3PL | Nashville Production 3PL
 |  |  | TN-PR-ADM | Nashville Production Administration
 |  |  | TN-PR-ASS | Nashville Production Assembly
 |  |  | TN-PR-FAC | Nashville Production Facility
 |  |  | TN-PR-PSH | Nashville Production Pack and Ship
 |  |  | TN-PR-QAS | Nashville Production Quality Control
 |  |  | TN-PR-REC | Nashville Production Receiving
 |  |  | TN-PR-REP | Nashville Production Replenishment
 |  |  | TN-PR-RMA | Nashville Production Returns
 |  |  | TN-PR-SHP | Nashville Production Shipping
 |  |  | TN-PR-SUP | Nashville Production Support
 |  |  | TN-PR-VAS | Nashville Production VAS
 |  |  | TN-PR-WAR | Nashville Production Warehouse
 |  |  | * Department List updated on 5/1/20.  TN-PR-INV is removed.
Spreadsheet: 624636d1558001377-excel-wont-let-me-click-on-the-cell-i-want-exam-planner
Sheet: PM

TPE Planner - PM |  |  |  |  | BIG PICTURE |  | Notes to remember/include |  | Ethical issues to carry forward to PM
 |  |  |  |  | 2. What's going on?
Timing | Normal | Time up to |  |  | Me
Reading & planning | 30 |  |  |  | Boss
Req 1 | 20 |  |  |  | Who do I work for?
Req 2 | 40 |  |  |  | Company
Req 3 | 30 |  |  |  | Client
Req 4 | 20 |  |  |  | Date
Req 5 | 10
Ethics | 20 |  |  |  | 3. Active reading. Financials-  trends/ movements, unusuals (high/low), profit/loss, B/S (debt, cash, assets)
Presentation | 10
Running total
Hardcoded total | 180
1. Requirement - what are they - structure?
Requirement | Deliverable and recipient |  | Identify - WHAT IS THE ISSUE, WHY IS IT AN ISSUE, WHAT IS THE IMPLICATION, WHAT DO WE RECOMMEND? |  |  |  |  | Timing
1
2
3
4
5
Spreadsheet: 81421d1281612700-selecting-a-cell-in-every-worksheet-media-preparation-sheet-testing
Sheet: 16 PB Miner

 |  | Name of the Formulation | PB Minor
 |  | Micro  elements
7 | H3BO3 | [NAME] | 6.2 | g
8 | MnSO4.H2O | Manganese Sulphate | 16.9 | g
9 | ZnSO4.7H2O | Zinc Sulphate | 8.6 | g
10 | KI | Potassium iodite | 0.83 | g
11 | CuSO4.5H2O | Copper Sulphate | 0.025 | g
12 | CoCl2.6H2O | Cobalt Chloride | 0.025 | g
13 | Na2MoO4.2H2O | Sodium Molibdate | 0.25 | g
Spreadsheet: 821533d1678780855-derive-column-value-based-on-multiple-criteria-sample-excel-4-ans
Sheet: Sheet1

Person ID | Value | Month | Action | Action number
1 | N | 2023-01-01 00:00:00 | 1st action
2 | Y | 2023-01-01 00:00:00
1 | N | 2023-02-01 00:00:00 | 2nd action
2 | N | 2023-02-01 00:00:00 | 1st action
2 | Y | 2023-03-01 00:00:00
3 | N | 2023-03-01 00:00:00 | 1st action
2 | N | 2023-04-01 00:00:00 | 1st action
3 | Y | 2023-04-01 00:00:00
4 | Y | 2023-04-01 00:00:00
Spreadsheet: 2221c500-1a35-40aa-b8bc-d710e0f6acb9
Sheet: 13a

 |  | Dealers** |  | Buyside |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Single - Name* | Corporate | 505495 | 7526325 | 505495 | 739221 | 1010990 | 8265547
 | Loans |  | 21354 |  |  |  | 21354
 | Municipal |  | 3336 |  | <1,000 |  | 3336
 | Recovery
 | Sovereign | 32408 | 2597979 | 32408 | 238945 | 64816 | 2836924
Index Tranche | Asia |  | <1,000 |  | <100 |  | <1,000
 | Europe |  | 782675 |  | 84910 |  | 867585
 | North America |  | 888540 |  | 32736 |  | 921276
Index | Asia | 1362 | 302684 | 1659 | 45799 | 3021 | 348483
 | Europe | 267762 | 2402624 | 267702 | 355834 | 535464 | 2758458
 | North America | 446777 | 1408409 | 469112 | 290725 | 915889 | 1699134
Other | Exotic
 | Swaptions
 | Total Return Swap
TOTAL* |  | 1253804 | 15933926 | 1276376 | 1788171 | 2530180 | 17722097
Estimated gross notional amount outstanding, December 21 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies. 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 Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 728792d1618651051-lookup-value-to-see-if-it-exists-within-a-range-and-use-for-formatting-test-location
Sheet: Test Location

Clients List
Test Location
Client | Code | Device Model | GPS Co-ordinates | Address | Static IP | Distance to H/S | PPPOE | Router IP | Antenna  User / Password |  | NOTES
Mr [NAME] | NON001 | Device1 | -29.886471,31.027081 | [NAME] | 192.168. 1.50 | 467 | PPPoE IPv6 | 192.168. 1.1 | admin | adminNON
Mr [NAME] | YAL001 | Device3 | -28.812999, 32.057427 | Richards [NAME] | 192.168. 1.70 | 1270 | PPPoE IPv6 | 192.168.1.8 | admin | adminYAL
 |  | Device2
 |  | Device2
 |  | Device6
 |  | Device2
 |  | Device8
 |  | Device6
Spreadsheet: 149086d1333687589-conditional-formatting-use-to-highlight-cells-that-correspond-to-a-time-sample
Sheet: Sheet1

 |  | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00
 |  | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00
Start | Finish
07:30:00 | 11:00:00
08:30:00 | 11:00:00
Spreadsheet: 297591d1392474405-two-column-based-validation-without-names-sample
Sheet: BRASSEURS

Brasseurs
Spreadsheet: 702891d1604593303-check-content-in-cell-and-return-value-book2
Sheet: Sheet1

1 | 2 |  |  | Contains | Value
eau de toi | [NAME] |  |  | eau de toi | [NAME]
edt | [NAME] |  |  | edt | [NAME]
eau de per | [NAME] |  |  | eau de per | [NAME]
shampoo | Shampoo |  |  | shampoo | Shampoo
Spreadsheet: 53186d1253116633-how-to-pick-up-latest-number-from-spread-sheet-september-fandi-report
Sheet: VJ

SOLD | SALE |  |  |  |  |  |  | DAILY GROSS |  |  |  |  | MONTH TO UNIT GROSS |  |  |  |  | AVERAGE GROSS AT UNIT
UNITS | DATE | CUSTOMER | STORE | YEAR | MAKE | MODEL | STOCK# | TOTAL | RESERVE | AM | WARR | GAP | TOTAL | RESERVE | AM | WARR | GAP | TOTAL | RESERVE | AM | WARR | GAP
1 | 2009-09-07 00:00:00 | RAYGOSA | SUB SUZ | 2008 | TOYOTA | RAV4 | 26061 | 1254.72 | 1254.72 | 0 | 0 | 0 | 1254.72 | 1254.72 | 0 | 0 | 0 | 1254.72 | 1254.72 | 0 | 0 | 0
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 887058d1737153440-pulling-a-list-of-values-based-on-two-conditions-spesifikasyon-ogecen-
Sheet: Sheet1

18 | Etiket Hatası (Ters, Kaymış, Yanlış) | [NAME] | Minor
19 | Barkod Etiket Hatası | [NAME] | Critical
20 | Eğri (Kafa, Boyun, Gövde) | Curve (Finis, Neck, Body) | Minor
21 | Göçük | [NAME] | Minor
22 | Şiş Gövde/ Geniş çap | Bulged sides | Major
23 | Dip Oturmazlığı | Rocker bottom | Major
24 | Kontaminasyon | Contamination | Critical
25 | [NAME] baskısı | Indistiınct serigraphy | Minor
26 | Menteşe kopması | Hinge break | Major
27 | Ezik | Crushed | Major
28 | Şekil dışı | Freaks | Critical
29 | [NAME] | Wounded mold | Major
30 | [NAME] | Lock failure | Major
31 | [NAME] | [NAME] isagreement | Major
32 | [NAME] | Mold sweating | Minor
Spreadsheet: cara_semperger__1433__PGE_NOVEMBER_MIDC_PATHS
Sheet: NOV (01)

 |  |  | To Portland General Electric : [NAME], [NAME], and [NAME]
 |  |  | Phone 464-7067
 |  |  | From Enron: Cara, [NAME], and [NAME] |  |  |  |  |  | DAILY COLSTRIP = 0
 |  |  | Phone 464-3814, 3902, 3831 |  |  |  |  |  | MONTH LONG COLSTRIP = 47 ATC
 |  |  |  |  |  |  |  |  | PARKING 24 HLH   22 LLH
 |  |  |  |  |  |  |  |  | BUSBAR B/R 25 LLH
 |  |  |  |  | Mid Columbia Paths
2001-11-01 00:00:00
 | HLH
 | DAY | 2 | BPA C#10440-CLATSKANPE-BPA(T)BPAP/PGE #10649NF | X | CLATSKANPE | ENRON | PGE | X | COLSTRIP B/R | 2
 | DAY | 20 | TEMU(G)CENTRALIA-BPA(T)SYS/PGE #361431NF-CINERGY-AVISTA | X | EPME | ENRON | PGE | X | COLSTRIP B/R | 20
 | DAY | 25 | TEMU(G)CENTRALIA-PWX-ALCOA BPA(T)CENT/MIDC-#10630NF-ALCOA-PWX-AQUILA | X | CARGILL | ENRON | PGE | X | COLSTRIP B/R | 25
 | DAY | 4 | [NAME] | X | EPME | ENRON | PGE | X | PARKING | 4
 | DAY | 5 | TEMU(G)CENTRALIA-BPA(T)SYS/PGE #361431NF-CINERGY-AVISTA | X | EPME | ENRON | PGE | X | PARKING | 5
 | DAY | 15 | TEMU(G)CENTRALIA-PWX-ALCOA BPA(T)CENT/MIDC-#10630NF-ALCOA-PWX-AQUILA | X | CARGILL | ENRON | PGE | X | PARKING | 15
 | LLH
 | DAY | 6 | C#24449 BPA(T)BPAP/PGE #95363NF | X | BPA | ENRON | PGE | X | BPA(T)BPAP/PGE #96095HNF-PARKING
 | DAY | 1 | PSPL(G)MIDC | X | MORGAN | ENRON | PGE | X | PARKING
 | DAY | 15 |  | X | PSPL | ENRON | PGE | X | PARKING
 | DAY | 25 | BPA C#23547 -PGE | X | MIECO | ENRON | PGE | X | BPA(T)BPAP/PGE #96095HNF
 | DAY | 25 | PGE B/R-(MIDC) | X | PGE | ENRON | EQUILON | X | PSEI SINK
 | DAY | 3 |  | X | CLATSKANPE | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 9 | PSPL(G)MIDC | X | MORGAN | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 10 |  | X | PSPL | ENRON | PGE | X | MIDC
 | DAY | 25 | WWP(G)MIDC | X | WWP | ENRON | PGE | X | COLSTRIP B/R
 | MONTH COLSTRIP PATHS
 | ALL HOURS
 | MONTH | 6 |  | X | PGE | ENRON | ASHGROVE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 6 |  | X | PGE | ENRON | EXPRESS PIPE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 7 |  | X | PGE | ENRON | HOLNAM | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 8 |  | X | PGE | ENRON | LOUISIANA P | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 5 |  | X | PGE | ENRON | LUZENAC | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 15 |  | X | PGE | ENRON | SMURFIT | X | MPCO NETWORK TRANSMISSION TO LOAD