tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 859317d1707741752-counting-occurrences-in-months-book-1
Sheet: Sheet3

Stage | (All)
Row Labels | Count of Area
<1.1.2024
(blank)
(blank)
2024 | 12
sij | 1
Area 1 | 1
vlj | 1
Area 3 | 1
tra | 2
Area 1 | 1
Area 2 | 1
svi | 3
Area 1 | 3
lip | 1
Area 2 | 1
srp | 2
Area 1 | 1
Area 2 | 1
kol | 1
Area 1 | 1
pro | 1
Area 3 | 1
2025 | 1
vlj | 1
Area 3 | 1
Grand Total | 13
Spreadsheet: 755923d1637183142-excel-formula-with-criteria-sample-prob
Sheet: Sheet5

Month | Date | Week# | Manager | Analyst | EID | Criticality | Response | QID | Score
November | 2021-11-04 00:00:00 | 1 | Iron Man | Black Widow | 15544 | Critical | Fail | 96
November | 2021-11-04 00:00:00 | 1 | Iron Man | Black Widow | 15544 | Non-Critical | Fail | 97
November | 2021-11-04 00:00:00 | 1 | Iron Man | Black Widow | 12311 | Non-Critical | Fail | 143
November | 2021-11-04 00:00:00 | 1 | Iron Man | Black Widow | 12311 | Non-Critical | Fail | 95
November | 2021-11-04 00:00:00 | 1 | Iron Man | Black Widow | 12311 | Non-Critical | Fail | 100
November | 2021-11-01 00:00:00 | 1 | Captain America | Spider-Man | 15548 | Non-Critical | Fail | 97
November | 2021-11-01 00:00:00 | 1 | Captain America | Antman | 19340 | Non-Critical | Fail | 95
November | 2021-11-03 00:00:00 | 1 | Iron Man | War Machine | 19340 | Critical | Fail | 143
November | 2021-11-04 00:00:00 | 1 | Iron Man | War Machine | 17302 | Non-Critical | Fail | 97
November | 2021-11-04 00:00:00 | 1 | Captain America | [NAME] | 10143 | Non-Critical | Fail | 97
November | 2021-11-04 00:00:00 | 1 | Captain America | [NAME] | 17302 | Non-Critical | Fail | 95
November | 2021-11-10 00:00:00 | 2 | Captain America | Antman | 15548 | Non-Critical | Fail | 115
November | 2021-11-10 00:00:00 | 2 | Captain America | [NAME] | 17302 | Non-Critical | Fail | 97
November | 2021-11-10 00:00:00 | 2 | Captain America | [NAME] | 17302 | Non-Critical | Fail | 96
Spreadsheet: 872888d1719334085-sumif-index-match-problem-agent-production-report
Sheet: Sheet1

Calls And Convestions |  |  |  |  | Calls And Convestions
Representative |  |  |  |  | Representative Totals
[NAME] |  |  |  |  | Name | User Status | Calls made | Answered calls | Scheduled
Calls made | 400 |  |  |  | [NAME] | Active
Answered calls | 200 |  |  |  | [NAME] | Active
Scheduled | 50 |  |  |  | [NAME] | Active
Answer Rate |  |  |  |  | Amber [NAME] | Active
Conversion Rate
Amber [NAME]
Calls made | 200
Answered calls | 100
Scheduled | 20
Answer Rate
Conversion Rate
[NAME]
Calls made | 200
Answered calls | 50
Scheduled | 10
Answer Rate
Conversion Rate
[NAME]
Calls made | 100
Answered calls | 25
Scheduled | 7
Answer Rate
Conversion Rate
Amber [NAME]
Calls made | 150
Answered calls | 25
Scheduled | 12
Answer Rate
Conversion Rate
Amber Mitchell
Calls made | 400
Answered calls | 200
Scheduled | 50
Answer Rate
Conversion Rate
[NAME]
Calls made | 400
Answered calls | 200
Scheduled | 50
Answer Rate
Conversion Rate
[NAME]
Calls made | 400
Answered calls | 200
Scheduled | 50
Answer Rate
Conversion Rate
[NAME]
Calls made | 400
Answered calls | 200
Scheduled | 50
Answer Rate
Conversion Rate
[NAME]
Calls made | 400
Answered calls | 200
Scheduled | 50
Answer Rate
Conversion Rate
Spreadsheet: 758723d1639040112-excel-dashboard-help-sum-data-from-multiple-tabs-service-support-management-db_v2
Sheet: Calculations (2)

 | PROJECTS | [NAME] | Kat | Kat | Matan | [NAME] | [NAME] | All Managers | Calls | [NAME] | Kat | [NAME] | [NAME]
CLIENT PROJECTS | January |  |  |  |  |  |  |  | CLIENT CALLS
 | February
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
 | PAT TICKETS
 | Month | Tickets
 | January | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
 | February | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
 | March | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18) |  |  |  |  |  | Days Spent | Hours spent
 | April | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
 | May | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
 | June | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
 | July | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
 | August | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
 | September | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
 | October
 | November
 | December
 | Client Information
 | Client Name
 | Total number of Client Calls
 | Average number of Client Calls
 | Not started
 | On hold
 | In progress
 | Completed
 | Total number of Client Proects
 | Completed
 | Total number of Client Projects
 | Average number of Client Projects
 | Not started
 | On hold
 | In progress
 | Completed
Spreadsheet: 128254d1320874732-lookup-or-if-functions-help-book
Sheet: Sheet1

Name |  | Made | Amount to | Rate
 |  | 33000 | 33000 |  |  |  |  |  |  | Production ICCS |  | Rate
Person A |  | 24713.91 |  |  |  |  |  |  |  | 0 | 29999 | 0
Person B |  | 27993.43 |  |  |  |  |  |  |  | 30000 | 39999 | 0.1
Person C |  | 43740.67 |  |  |  |  |  |  |  | 40000 | 49999 | 0.15
Person D |  | 36134.64 |  |  |  |  |  |  |  | 50000 | 59999 | 0.3
Person E |  | 78.9 |  |  |  |  |  |  |  | 60000 | 89999 | 0.4
Person F |  | 12173.51 |  |  |  |  |  |  |  | 90000 | 109999 | 0.45
Person G |  | 79000.77 |  |  |  |  |  |  |  | 110000 | 134999 | 0.5
Person H |  | 1055.45 |  |  |  |  |  |  |  | 135000 | 154999 | 0.55
Person I |  | 1055.45 |  |  |  |  |  |  |  | 155000 | 174999 | 0.6
Person J |  | 558.26 |  |  |  |  |  |  |  | 175000 | 249999 | 0.65
Person K |  | 703.85 |  |  |  |  |  |  |  | 250000 |  | 0.7
Person L |  | 6186.51
Person M |  | 27192.74
Person N |  | 1814.19
Spreadsheet: lisa_gang__22297__ENA_PGE_MAY 11_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 5/10-11/2002
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  |  | Total In To PGE Trans
0100 |  |  |  |  | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0 | 0
0700 | 25 | 25 | 25 | 25 | 25 | 25
0800 | 25 | 25 | 25 | 25 | 25 | 25
0900 | 25 | 25 | 25 | 25 | 25 | 25
1000 | 25 | 25 | 25 | 25 | 25 | 25
1100 | 25 | 25 | 25 | 25 | 25 | 25
1200 | 25 | 25 | 25 | 25 | 25 | 25
1300 | 25 | 25 | 25 | 25 | 25 | 25
1400 | 25 | 25 | 25 | 25 | 25 | 25
1500 | 25 | 25 | 25 | 25 | 25 | 25
1600 | 25 | 25 | 25 | 25 | 25 | 25
1700 | 25 | 25 | 25 | 25 | 25 | 25
1800 | 25 | 25 | 25 | 25 | 25 | 25
1900 | 25 | 25 | 25 | 25 | 25 | 25
2000 | 25 | 25 | 25 | 25 | 25 | 25
2100 | 25 | 25 | 25 | 25 | 25 | 25
2200 | 25 | 25 | 25 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24711 | BPA(G)24718 | BPA(G)24727 | BPA(G)24771 | BPA(G)24547 | BPA(G)24547
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AEP | AEP | AEP | AEP | AEP | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP | AEP | AEP
 | CDWR | CDWR | TID | MORGAN | SNCL | MORGAN
 | ISO(T)MALIN/NP15 | ISO(T)MALIN/NP15 | TID(T)CPJK/TRACEY/WESLEY | PAC(T)MALIN5/MALIN2 | ISO(T)CPJK/NP15 | MORGAN
 | CDWR(L,FS)NP15 (CA) | CDWR(L,FS)NP15 (CA) | TID | MORGAN | SNCL(L,FS)NP15 (CA) | PAC(T)MALIN5/MALIN2 | `
 |  |  | TID(L)WESLEY | SPP |  | MORGAN
 |  |  |  | BPA(T)MALIN2/HILLTOP |  | SPP
 |  |  |  | SPP |  | BPA(T)MALIN2/HILLTOP
 |  |  |  | MORGAN |  | SPP
 |  |  |  | SPP(L)HILLTOP |  | MORGAN
 |  |  |  |  |  | SPP(L)HILLTOP
Spreadsheet: 800224d1665553285-counting-cells-in-a-row-based-on-settings-in-a-table-count-example
Sheet: Sheet1

Category | Count |  |  | Tool | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | What counts should be (want to do by formula to auto update as data is entered daily)
Up | Yes |  |  | ToolA | Up | Qual | Qual | Down | Maintenance | Up | Up |  | 5
Down | Yes |  |  | ToolB | Up | Down | Up | Up | Up | Up | Up |  | 7
Qual | No |  |  | ToolC | Qual | Down | Up | Up | Maintenance | Qual | Qual |  | 4
Maintenance | Yes |  |  | ToolD | Down | Down | Maintenance | Qual | Up | Up | Up |  | 6
 |  |  |  |  | Want to count all status that has "Yes" in the Category table to the left
 |  |  |  |  | For this example, "Qual" status should not be counted
Spreadsheet: 2c7e2fd8-01e5-4a62-bab0-5c8c95a2515e
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
PRL | Test | PRL | Prolactin, Serum | Prolactin, S | Immunoenzymatic Assay | Serum Gel Tube: SGT |  |  | 0.6 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.6 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Males: 3-13 ng/mL Females: 3-27 ng/mL | Monday through Friday 5 a.m. - 12 a.m., Saturday 6 a.m. - 6 p.m. | Same day/1 day | 3 days | 1 | 84146 |  |  |  |  | Rochester
PRL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
PRL | Result | PRL | Prolactin, S | Prolactin, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 2842-3 | Prolactin:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: mary_fischer__25817__RETAIL4 1CE 2CE variance analysis
Sheet: RETAIL4

EES - RETAIL 4
Analysis of 1st CE to 2nd CE Variances
For the tax year 2001
(in millions)
DR/(CR)
(Income)/Loss
 | 1CE | 2CE | [NAME] |  | Reasons for variance
Net Income Before Tax | -169 | -189 |  |  | See Note 1
Permanent Differences
Dividends | 0 | 0
Equity Earnings | 0 | 0
Foreign Operations | 56 | 77 |  |  | See Note 2
Foreign Taxes | 0 | 0 | 0
Gain/Loss On Sale of Stock/Assets | 0 | 0
[NAME] | -7 | -7
Other - Mapping Issues | 1 | 0 |  |  | Mapping issues corrected
Other - Business Exp @ 50% | -4 | -4
Total Permanent Differences
Temporary Differences
Depreciation, Depletion, & Amort. | -4 | -2 |  |  | Adjusted estimate based on book numbers
Partnership Equity | 0 | 0
Gain/Loss On Sale of Stock/Assets | 0 | 0
Price Risk Management | 194 | 57 |  |  | Avista [NAME] transferred to WHSEES4
Regulatory Contingencies | 0 | 0
Computer Development Costs | 16 | 16
Investments in Subs | -46 | -46
Project Development | 42 | 37 |  |  | See Note 3
Employee Fringe Benefits | -11 | -16 |  |  | See Note 4
Other - FAS 140 Monetization of Warrants | 82 | 50 |  |  | See Note 5
Other - Bad Debt Expense | -1 | 1 |  |  | Adjusted estimate based on book numbers
Total Temporary Differences
Total State Taxable Income
Current State Tax Exp/(Bene) | 1 | 1
Total Federal Taxable (Income)/Loss
Current Tax Expense (Benefit)
Federal
State | 0 | 0
Foreign | 0 | 0
Federal Tax Credits | 0 | 0
Other Federal - NOL Prior Year Payment | -79 | -79
Other State | 1 | 1
Other Foreign | 8 | 0 |  |  | Adjustment due to changes in foreign NIBT
Total Current Tax Expense (Benefit)
Deferred Tax Expense (Benefit)
Federal
State | 0 | 0
Foreign | 0 | 0
Federal Tax Credits | 0 | 0
Other Federal - Return to Accrual | 0 | 0
Other Federal - NOL Prior Year Payment | 79 | 79
Other State - Return to Accrual | 0 | 0
Other State | 5 | 5
Other Foreign | 10 | 27 |  |  | Adjustment due to changes in foreign NIBT
Total Deferred Tax Expense (Benefit)
Total Tax Expense (Benefit)
Net (Income) / Loss
Effective Rate
Additional Notes regarding changes from 1CE to 2CE:  [NAME] (DR/(CR)
Note 1 - The following income/expense items changed between quarters:
Foreign Income - increase |  | -21
Note 2 - The following changes occurred in foreign income in Q2:
2 new Canadian entities were created which transferred income
from a partnership and created additional NIBT of $12 million |  | -12
MTM changed for UK companies Sainsbury project |  | -9
Total Change in NIBT
Note 3 - Company 985 adjusted estimate of expenditures
for software development project
Note 4 - EFS companies adjusted estimate of employee
benefit expenditures
Note 5 - In Q2 the TNPC warrant monetizations planned for Q3 and Q4
were removed
Spreadsheet: 876863d1723575611-i-want-condition-based-relative-date-if-condition-is-in-a-range-then-first-date-and-last-under-work-1-mubashir-naeem-
Sheet: TEST

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |  | 1234 |  | CL
PK | NM | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 | 2024-01-08 00:00:00 | 2024-01-09 00:00:00 | 2024-01-10 00:00:00 | 2024-01-11 00:00:00
1233 | AB | P | CL | P | P | P | P | P | P | P | P | kk
1234 | AC | P | P | CL | LL | LL | P | P | CL | CL | CL | P
1235 | AB | CL | P | CL | P | P | P | P | P | P | LL | kk
1236 | AC | P | P | P | P | P | P | P | P | P | AL | kk
1237 | AB | jj | P | LL | LL | LL | CL | LL | LL | P | P | kk
1238 | AC | P | P | P | P | P | P | P | P | P | P | P
1239 | AB | P | P | P | P | P | P | P | P | P | P | P
 |  |  |  |  |  | I want this out put only |  |  | where condition meet, display the relative date if condition is in range then first date (result in one column) and last date (result  in second column) where conditon meet
 |  |  |  |  |  | 2024-01-03 00:00:00 | 2024-01-03 00:00:00
 |  |  |  |  |  | 2024-01-08 00:00:00 | 2024-01-10 00:00:00
Spreadsheet: eric_saibi__9941__103101
Sheet: Zimmer A

Owner Name |  | Cinergy Corporation
Station Name |  | [NAME] Power Station
Unit Name |  | Zimmer A
NERC Region |  | ECAR
State |  | OH
Fuel Type |  | Coal
Capacity |  | 494 MW
Start Date |  | 2001-10-31 00:00:00
End Date |  | 2001-11-01 00:00:00
Comments |  | Plant is offline with Boiler Problems and having some difficulty getting it back online
SIC |  | 4911
Plant ID |  | 1009921
Unit ID |  | 1003896
Outage ID |  | 18775
Spreadsheet: 118633d1313810146-shorten-formula-to-avoid-maxing-of-cpu-master-budget-twitt-adjustments-ttrial
Sheet: Supplier breakdown

Supplier | Total Ex GST | Date Payment 1 | Date Payment 2 | Date Payment 3
Copyshop
QBSA
HIA
Qleave
Electrician
Electrical supplies
[NAME]
Coastal fasteners
Direct line timbers
Bebrok
Daniels earthmoving
Concretor
[NAME] concrete
ARCREO
Landscape supplies
Formwork
Fabrication
Termite treatment
Swimming pool
Carpenters
Austral bricks
Blocklayer
Kelly green
Trusses
Windows supplier
Suncoast stairs
Waterproofer
Plumber
Plumber PC
Telstra
Plasterer
Solid plasterer
Cabinetmaker
Balustrading
Tile store
Tiler
Shower screen/ Mirror supplier
Garage door supplier
Painter
Carpets
[NAME]
Driveway
Spreadsheet: 696169d1600686463-collating-multiple-tab-info-into-one-rj-projections_chrispq
Sheet: Supplier 1

Supplier 1 |  |  |  |  |  |  | Payment Dates
Forecast Month | [NAME] (Product) | [NAME] (Number) | Container Number | Time to arrive (M) | Order Date | Container Cost (£) | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21
2021-01-01 00:00:00 | Product A | 2000 | 1 | -3 |  | 30000
2021-02-01 00:00:00 | Product A |  | 2 | -3 |  | 40000
2021-03-01 00:00:00 | Product A |  | 3 | -3 |  | 50000
2021-04-01 00:00:00 | Product A |  | 4 | -3 |  | 10000
Spreadsheet: 692153d1598126203-combine-payments-to-specific-payment-days-but-split-at-crossover-point-between-2-months-month-end-v3
Sheet: Month-End

Month | Year | Last Day of Month | LDM Day | Last Working Day of Month, inc Holidays | LWDM
Dec | 2020-12-01 00:00:00
Jan | 2021-01-01 00:00:00
Feb | 2021-02-01 00:00:00
Mar | 2021-03-01 00:00:00
Apr | 2021-04-01 00:00:00
May | 2021-05-01 00:00:00
Jun | 2021-06-01 00:00:00
Jul | 2021-07-01 00:00:00
Aug | 2021-08-01 00:00:00
Sep | 2021-09-01 00:00:00
Oct | 2021-10-01 00:00:00
Nov | 2021-11-01 00:00:00
Dec | 2021-12-01 00:00:00
Jan | 2022-01-01 00:00:00
Feb | 2022-02-01 00:00:00
Mar | 2022-03-01 00:00:00
Apr | 2022-04-01 00:00:00
May | 2022-05-01 00:00:00
Jun | 2022-06-01 00:00:00
Jul | 2022-07-01 00:00:00
Aug | 2022-08-01 00:00:00
Sep | 2022-09-01 00:00:00
Oct | 2022-10-01 00:00:00
Nov | 2022-11-01 00:00:00
Dec | 2022-12-01 00:00:00
Jan | 2023-01-01 00:00:00
Feb | 2023-02-01 00:00:00
Mar | 2023-03-01 00:00:00
Apr | 2023-04-01 00:00:00
May | 2023-05-01 00:00:00
Jun | 2023-06-01 00:00:00
Jul | 2023-07-01 00:00:00
Aug | 2023-08-01 00:00:00
Sep | 2023-09-01 00:00:00
Oct | 2023-10-01 00:00:00
Nov | 2023-11-01 00:00:00
Dec | 2023-12-01 00:00:00
Jan | 2024-01-01 00:00:00
Feb | 2024-02-01 00:00:00
Mar | 2024-03-01 00:00:00
Apr | 2024-04-01 00:00:00
May | 2024-05-01 00:00:00
Jun | 2024-06-01 00:00:00
Jul | 2024-07-01 00:00:00
Aug | 2024-08-01 00:00:00
Sep | 2024-09-01 00:00:00
Oct | 2024-10-01 00:00:00
Nov | 2024-11-01 00:00:00
Dec | 2024-12-01 00:00:00
Spreadsheet: 7b516bf2-7f52-47e5-a2f2-ebc6df5e0b18
Sheet: Sheet1

 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Rubric Made Using:
RubiStar ( http://rubistar.4teachers.org )
Making A Poster : Lakota Values/Virtues poster
Teacher Name: Ms. [NAME]
Student Name:     ________________________________________
CATEGORY | 4 | 3 | 2 | 1
Title | Title can be read from 6 ft. away and is quite creative. | Title can be read from 6 ft. away and describes content well. | Title can be read from 4 ft. away and describes the content well. | The title is too small and/or does not describe the content of the poster well.
Lakota Leaders | Use of 2 Lakota Leaders and examples of value/virtue posses. | Use of 1 Lakota Leader and example of value/virtue posses. | Use of Lakota Leader, but no examples of value/virtue posses. | No Lakota Leader included.
Values/Virtues | Value/Virtue well defined and the importance of it. | Value/Virtue defined, but no importance of it. | Value/Virtue importance included, but value/virtue not defined. | Value/Virtue undefined.
Graphics -Clarity | Graphics are all in focus and the content easily viewed and identified from 6 ft. away. | Most graphics are in focus and the content easily viewed and identified from 6 ft. away. | Most graphics are in focus and the content is easily viewed and identified from 4 ft. away. | Many graphics are not clear or are too small.
Mechanics | Capitalization and punctuation are correct throughout the poster. | There is 1 error in capitalization or punctuation. | There are 2 errors in capitalization or punctuation. | There are more than 2 errors in capitalization or punctuation.
[NAME] | There are no grammatical mistakes on the poster. | There is 1 grammatical mistake on the poster. | There are 2 grammatical mistakes on the poster. | There are more than 2 grammatical mistakes on the poster.
Use of Class Time | Used time well during each class period. Focused on getting the project done. Never distracted others. | Used time well during each class period. Usually focused on getting the project done and never distracted others. | Used some of the time well during each class period. There was some focus on getting the project done but occasionally distracted others. | Did not use class time to focus on the project OR often distracted others.
Knowledge Gained | Student can accurately answer all questions related to facts in the poster and processes used to create the poster. | Student can accurately answer most questions related to facts in the poster and processes used to create the poster. | Student can accurately answer about 75% of questions related to facts in the poster and processes used to create the poster. | Student appears to have insufficient knowledge about the facts or processes used in the poster.
Date Created: November 09, 2011
Date Last Modified: November 30, 2011
Spreadsheet: 93853d1293632505-multiple-ifs-for-auto-fill-of-text-gm_sample-multiple-ifs
Sheet: Sheet1

Planned Closure Date | Open/Closed | Status | Date Implemented | Desired Tex to be automated in Column C
2010-11-15 00:00:00 | Open | Past Due |  | Past Due
2010-12-01 00:00:00 | Open | Past Due |  | Past Due
2010-12-10 00:00:00 | Closed | - | 2010-12-10 00:00:00
2010-08-11 00:00:00 | Closed | - | 2010-08-15 00:00:00
2010-09-11 00:00:00 | Closed | - | 2010-09-11 00:00:00
2010-10-04 00:00:00 | Open | Past Due |  | Past Due
2010-12-01 00:00:00 | Open | Past Due |  | Past Due
2010-12-01 00:00:00 | Closed | - | 2010-12-05 00:00:00
2010-06-15 00:00:00 | Open | Past Due |  | Past Due
2010-06-15 00:00:00 | Closed | - | 2010-06-01 00:00:00
2010-08-17 00:00:00 | Closed | - | 2010-09-01 00:00:00
2010-12-28 00:00:00 | Open | Past Due |  | Past Due
2010-12-01 00:00:00 | Closed | - | 2010-12-01 00:00:00
2010-12-01 00:00:00 | Open | Past Due |  | Past Due
2010-12-01 00:00:00 | Closed | - | 2010-12-01 00:00:00
2010-12-01 00:00:00 | Closed | - | 2010-12-01 00:00:00
2010-12-01 00:00:00 | Open | Past Due |  | Past Due
2010-11-27 00:00:00 | Open | Past Due |  | Past Due
2010-11-26 00:00:00 | Closed | - | 2010-12-01 00:00:00
2010-12-27 00:00:00 | Open | Past Due |  | Past Due
2011-01-03 00:00:00 | Open | - |  | Witin 30
2011-01-10 00:00:00 | Open | - |  | Witin 30
2011-01-17 00:00:00 | Closed | - | 2010-12-01 00:00:00
2011-01-24 00:00:00 | Open | - |  | Within 30
2011-01-31 00:00:00 | Open | -
2011-02-07 00:00:00 | Open | -
2011-02-14 00:00:00 | Open | -
2011-02-21 00:00:00 | Open | -
2011-02-28 00:00:00 | Open | -
 | Open |  |  | [NAME]
 | Open |  |  | [NAME]
 | Open |  |  | [NAME]
Spreadsheet: 150757d1334675487-lookup-part-of-a-value-in-a-cell-and-return-value-from-another-cell-zipcode-lookup
Sheet: Sheet2

350 | AL
351 | AL
352 | AL
353 | AL
354 | AL
355 | AL
356 | AL
357 | AL
358 | AL
359 | AL
360 | AL
361 | AL
362 | AL
363 | AL
364 | AL
365 | AL
366 | AL
367 | AL
368 | AL
369 | AL
Spreadsheet: 19f771e9-7a95-4dd9-b461-3b97d6d97c05
Sheet: 17

 |  | Broker** |  | Non-Broker |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Swap* | CFD |  | 0 |  | 32089 |  | 32089
 | Dividend |  | 9515 |  | 10477 |  | 19992
 | Equity Swap |  | 237877 |  | 672907 |  | 910784
 | Portfolio |  | 25860 |  | 320797 |  | 346657
 | [NAME] |  | 2540 |  | 2057 |  | 4597
Option | Accumulator/Decumulator |  | 1344 |  | 11782 |  | 13126
 | Vanilla (put/call) |  | 1536446 |  | 1976885 |  | 3513331
 | [NAME]
Forward | Vanilla
Exotic
Structured Products |  |  | 175681 |  | 1105360 |  | 1281041
TOTAL |  | N/A**** | 1989264 | N/A | 4132353 | N/A | 6121616
Estimated gross notional amount outstanding, November 30 monthly snapshot, by product, participant type, and cleared status (millions of USD). Data are adjusted for double-counting of inter-broker trades to show a single exposure for each trade.
Data for the equity asset class are currently made available to the Commission on a monthly basis, and the Swaps by Asset Class tables in this proposed version of the CFTC Swaps Report will thus be published with an effective delay of up to one month.
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 particpant type descriptions.
***See Explanatory Notes for cleared and uncleared 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].