tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: lisa_gang__22310__ENA_PGE_JUNE_3_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 2002-06-03 00:00:00
Total Transmission
HE
ENDING | 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 | [NAME] USED
(PPT) |  |  |  |  |  | Total In To PGE Trans
0100 | 0 | 0 | 0 | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0
0700 | 25 | 25 | 50 | 25 | 25
0800 | 25 | 25 | 50 | 25 | 25
0900 | 25 | 25 | 50 | 25 | 25
1000 | 25 | 25 | 50 | 25 | 25
1100 | 25 | 25 | 50 | 25 | 25
1200 | 25 | 25 | 50 | 25 | 25
1300 | 25 | 25 | 50 | 25 | 25
1400 | 25 | 25 | 50 | 25 | 25
1500 | 25 | 25 | 50 | 25 | 25
1600 | 25 | 25 | 50 | 25 | 25
1700 | 25 | 25 | 50 | 25 | 25
1800 | 25 | 25 | 50 | 25 | 25
1900 | 25 | 25 | 50 | 25 | 25
2000 | 25 | 25 | 50 | 25 | 25
2100 | 25 | 25 | 50 | 25 | 25
2200 | 25 | 25 | 50 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24966 | BPA(G)24966 | BPA(G)24966 | BPA(G)24661 | BPA(G)24718
 | 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
 | 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
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP | AEP
 | MID | NCPA | TID | MORGAN | SDGE
 | MID(T)CPJK/TRACEY/WESLEY | ISO(T)CPJK/NP15 | TID(T)CPJK/TRACEY/WESLEY | APX(L)NP15 | ISO(T)MALIN/NP15
 | MID(L)WESLEY | NCPA(L)NP15 | TID | ISO(T)MALIN/NP15 | SDGE(L)NP15
 |  |  | TID(L)WESLEY | APX(L)NP15
Spreadsheet: 145288d1331493424-highlight-entire-row-is-first-cell-is-60-days-older-than-today-0123
Sheet: Sheet1

JOIN | NAME | STATUS/REMARKS
2012-01-01 00:00:00 | ARMSTRONG, [NAME] |  | 70
2012-01-07 00:00:00 | AVELLANEDA, DANIEL E. |  | 64
2012-01-10 00:00:00 | BARAJAS JR, GUILLERMO. | COMPLETED | 61
2012-01-20 00:00:00 | ALLAIN, [NAME] |  | 51
2012-02-18 00:00:00 | GARRETT, TRAVIS P. |  | 22
2012-02-24 00:00:00 | ALBRIGHT, [NAME] |  | 16
2012-02-25 00:00:00 | FLORES, [NAME] |  | 15
2012-03-02 00:00:00 | [NAME], [NAME] |  | 9
2012-03-05 00:00:00 | ROMEROFERNANDEZ, MAURICIO. |  | 6
2012-03-06 00:00:00 | [NAME], [NAME] |  | 5
Spreadsheet: 156102d1337179850-formula-for-counting-filtered-matrixed-data-w-criteria-matrix-data-count
Sheet: Sheet1

OUTPUT
 | GREEN | WHITE | YELLOW
BOX A | 3 | 1 | 2
BOX B | 2 | 0 | 0
BOX C | 3 | 0 | 1
BOX D | 1 | 2 | 1
MATRIX
ITEM | QTY | COLOR | BOX A | BOX B | BOX C | BOX D
BOLT 1 | 1 | GREEN | 2
BOLT 2 | 2 | YELLOW | 0
BOLT 3 | 3 | WHITE |  |  |  | 2
BOLT 4 | 1 | WHITE | 2
BOLT 5 | 0 | GREEN |  | 0
BOLT 6 | 2 | GREEN | 3 |  |  | 1
BOLT 7 | 3 | YELLOW | 1 |  | 1
NUT 1 | 3 | WHITE |  | 0
NUT 2 | 0 | GREEN | 1 |  | 1
NUT 3 | 1 | GREEN | 0 |  | 2
NUT 4 | 1 | YELLOW | 4 |  |  | 3
NUT 5 | 2 | GREEN |  | 2 | 1
NUT 6 | 3 | WHITE |  |  |  | 1
NUT 7 | 2 | GREEN |  | 1
Spreadsheet: 93668d1293361400-highlight-rows-based-on-duplicate-with-conditions-highlight-dups-based-on-condtions
Sheet: Sheet1

Found | Option 1 | Target | Source | option 2 | Option 3 | Option 4 | Option 5 | Option 6 | Option 7
FOUND | yes | / | source 1 | [NAME] |  |  |  | YES | option 1
FOUND | no | / | source 2 | [NAME] |  |  |  | YES | option 1
FOUND | no | / | source 3 | [NAME] |  |  |  | YES | option 1
FOUND | yes | / | source 4 | anyword 2 |  |  |  | YES | option 1
FOUND | yes | /2 | source 5 | anyword 3 |  |  |  | YES | option 2
FOUND | no | / | source 6 | [NAME] |  |  |  | YES | option 2
Spreadsheet: 805806d1668944103-how-to-show-value-added-tax-separate-from-vat-exempt-and-vat-zero-rated-vat-separattion
Sheet: Exempt

[NAME] EXEMPT
Date | TIN | CUSTOMER NAME | TAX IONVOICE NUMBER / REFERENCE | Particulars of Supplies | Exempt Supplies | Zero Rated Supplies | Std Rated (Excl. VAT)
2022-10-07 00:00:00 | 100100400 | Grocery | 96247 | Brown Sugar | 20
2022-10-11 00:00:00 | 100200253 | Gas Station | 44711 | Fuel | 75
Spreadsheet: 860342d1708482932-if-greater-than-2-if-less-than-1-excel-forum-question
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Anything under .167 = 1 per store
 |  |  |  |  |  |  |  |  | Anything over .167 = 2 per store
4 | 172 | 426 | 689 | 1265 | 534 | 1348 | 774
0.875 | 0.9375 | 0.6936619718309859 | 0.4749637155297532 | 0.2992094861660079 | 0.1839887640449438 | 0.1568991097922849 | 0.08204134366925064
0.875 | 0.9375 | 0.6936619718309859 | 0.4749637155297532 | 0.2992094861660079 | 0.1839887640449438 | 0.1568991097922849 | 0.08204134366925064
Asking if cell A5 is greater than cell G2 = 2, if it is less than = 1
Spreadsheet: geir_solberg__11253__05-17
Sheet: MAY1501

DATE | FERC FILE | SERVICE CUST | HR BEG | HR END | TOTAL HRS | DEL PT | SUPPLY | MW PER HR | TOTAL MW | SCHEDULE ID | SELL PRICE
2001-05-17 00:00:00 |  | Y | 1 | 1 | 1 | SP15 | EESI | 18 | 18 |  | 15 | SOLD
2001-05-17 00:00:00 |  | Y | 2 | 2 | 1 | SP15 | EESI | 20 | 20 |  | 15 | SOLD
2001-05-17 00:00:00 |  | Y | 3 | 3 | 1 | SP15 | EESI | 23 | 23 |  | 15 | SOLD
2001-05-17 00:00:00 |  | Y | 4 | 4 | 1 | SP15 | EESI | 24 | 24 |  | 15 | SOLD
2001-05-17 00:00:00 |  | Y | 5 | 5 | 1 | SP15 | EESI | 21 | 21 |  | 15 | SOLD
2001-05-17 00:00:00 |  | Y | 6 | 6 | 1 | SP15 | EESI | 11 | 11 |  | 15 | SOLD
2001-05-17 00:00:00 |  | Y | 22 | 22 | 1 | SP15 | EES | 17 | 17 |  | 75 | SOLD
2001-05-17 00:00:00 |  | Y | 24 | 24 | 1 | SP15 | EES | 10 | 10 |  | 75 | SOLD
Spreadsheet: 727265d1617809451-remove-filterxml-from-formula-roster-vs-schedule-example
Sheet: Classes

Day | Monday | Monday | Monday | Monday | Tuesday | Tuesday | Tuesday | Tuesday | Wednesday | Wednesday | Wednesday | Wednesday | Wednesday | Thursday | Thursday | Thursday | Thursday | Thursday | Friday | Friday
System | System 1 | System A | System 2 | System 3 | System 4 | System B | System 5 | System 6 | System 7 | System 8 | System C | System D | System 9 | System E | System F | System 10 | System G | System G | System H | System 11
 | OVERFLOW
 | Monday | Tuesday | Wednesday | Thursday | Friday
 |  |  |  |  |  |  | In the System G (R column) above I can get it so the formula looks at the System column in the Names tab but when I change the Array to look at System and System 2 like the formula below (and in the S column). I loose students in the list.  =IFERROR(INDEX(Names!A:A,AGGREGATE(15,6,ROW(Roster[Student Name])/(Roster[[System]:[System 2]]={"System 8","System 9","System 10"})
Spreadsheet: phillip_m_love__31083__Orig-Central0201
Sheet: Summary Sched

 | Origination Summary Schedule - Feb-01
 |  |  |  | Origination |  | Number of |  | Volume on
 | Originator |  |  | Amount |  | Originated Deals |  | Transactions
 | [NAME] | Pollan
 | [NAME] | Carrabine
 | [NAME] | Frihart
 |  | Meyer
 |  | Barbe
 |  | [NAME]
 | [NAME] | [NAME]
Spreadsheet: 218244d1362407680-trying-to-use-match-and-index-but-return-a-text-not-numercial-answer-excel-forum
Sheet: Sheet1

Upper control room | 1 | Answer needs to say Not up to audit standard
Lower control room | 3 | Answer needs to say Up to audit standard
Loading bay | 4 |  |  |  |  |  | 1 | 2 | 3 | 4
 |  |  |  |  |  | Upper control room | Not up to audit standard | Nearly up to audit standard | Up to audit standard | Surpasses audit standard
 |  |  |  |  |  | Lower control room | Not up to audit standard | Nearly up to audit standard | Up to audit standard | Surpasses audit standard
 |  |  |  |  |  | Loading bay | Not up to audit standard | Nearly up to audit standard | Up to audit standard | Surpasses audit standard
Spreadsheet: 7495a785-7b4a-46a0-a329-ad6eed8dc876
Sheet: Summer 2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
MAEd
Summer 2016
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Instructor(s) | Instructor ID | FT or Adj | Contract Code | Percentage | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 63739d1264612985-sumif-formula-multiple-criteria-febuary-2010-dispatch
Sheet: Summary

Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand
 |  |  |  | NL | E10 | SNL | E10 | PNL | E10 | DS2 | [NAME] |  | DS1 | DSR1 |  | Total
Montly totals
Totals by truck
 | T1
 | T7
 | T15
 | T17
 | T18
 | T19
 | MW
 | ANK
 | DX
 | KLR
 | OTTS
 | other
 | other
 | other
Totals
[NAME]
Locations
 | 426
 | 457
 | 470
 | 417
 | 418
 | 433
 | 404
 | 407
 | PBG
 | crossroads
 | [NAME]
 | GCM
 | Friendly's
 | [NAME]'s Valley
 | Big Sky
 | H&R #1
 | RHJ #1
 | 25001
 | Wheat MT
 | Big Hole
Spreadsheet: 134716d1325600869-formula-to-sum-from-different-sheets-and-various-criteria-book5
Sheet: Summary

Company | [NAME] | Description | Amount
US | abc1 | blue
US | [NAME] | green
US | ghk3 | green
US | [NAME] | green
AE | ghk3 | red |  |  |  | I need a formula that will provide me with totals in column D on Summary sheet.
AE | [NAME] | black |  |  |  | I need to get the totals based on company, sku and description.
AE | [NAME] | black
AE | abc1 | red
AI | [NAME] | blue
AI | ghk3 | red
AI | ghk3 | black
AI | abc1 | blue
AI | abc1 | red
AI | ghk3 | black
AI | ghk3 | red
PL | [NAME] | red
PL | ghk3 | green
PL | abc1 | green
DL | [NAME] | red
DL | abc1 | blue
DL | abc1 | green
Spreadsheet: 34676d1231986283-filter-one-list-by-another-for-contains-copy-of-name-find-2
Sheet: Sheet1

[EMAIL] | lisa | noviss | [EMAIL]
[EMAIL] | [NAME] | blow | [EMAIL]
[EMAIL] | [NAME] | shmoe | [EMAIL]
[EMAIL] | [NAME] | duff
[EMAIL] | mark | wark
[EMAIL]
[EMAIL]
 | search the emails in column a for either strings from b or c and only return those with matches.
Spreadsheet: 215232d1361310930-extract-only-certain-values-from-a-list-which-contains-empty-rows-book1-2-
Sheet: Sheet1

List A: | List B: |  | Result
chihuahua | akita |  | chihuahua
 | chihuahua |  | great dane
great dane | collie |  | labrador retriever
labrador retriever | great dane |  | terrier
 | irish setter
siamese | labrador retriever
 | rottweiler
[NAME] | terrier
 | weimeraner
terrier
Spreadsheet: 033d4855-ec7b-4602-8b8c-aaab9c75b6fc
Sheet: 5

 | Jan 4 | Jan 11 | Jan 18 | Jan 25 | Feb 1
Total Interest Rate* | 84500 | 84500 | 84500 | 84500 | 84500
Cleared** | N/A*** | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 3500 | 3500 | 3500 | 3500 | 3500
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 105000 | 105000 | 105000 | 105000 | 105000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | 25000 | 25000 | 25000 | 25000 | 25000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | 105000 | 105000 | 105000 | 105000 | 105000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 323000 | 323000 | 323000 | 323000 | 323000
Weekly total, estimated swap event volumes by asset class and cleared status (in number of events), all products, tenors, and participant types.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey, which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class 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].
Spreadsheet: 858164d1706898426-multiple-results-for-multiple-references-classeur2
Sheet: Feuil1

Data : |  |  |  |  |  |  | What I need :
 |  |  |  |  |  |  |  |  |  |  | [NAME] that doesn't work properly :
Reference | Column2 | Column3 | Column4 | Column5 |  |  | Reference | [NAME] to give me this :
Example 1 | Office | Blabla | Blabla | Blabla |  |  | Example 5
Example 2 | Office | Blabla | Blabla | Blabla |  |  | Example 3 | Warehouse
Example 3 | Warehouse | Blabla | Blabla | Blabla |  |  | Example 3 | Parking
Example 4 | Office | Blabla | Blabla | Blabla |  |  | Example 3 | Office
Example 3 | Parking | Blabla | Blabla | Blabla |  |  | Example 4 | Office
Example 1 | Parking | Blabla | Blabla | Blabla |  |  | Example 4 | Parking
Example 3 | Office | Blabla | Blabla | Blabla |  |  | Example 1 | Office
Example 4 | Parking | Blabla | Blabla | Blabla |  |  | Example 1 | Parking
Example 2 | Green area | Blabla | Blabla | Blabla |  |  | Example 2 | Office
Example 5 | Bridge | Blabla | Blabla | Blabla |  |  | Example 2 | Green area
 |  |  |  |  |  |  | Note : the references may not be in order in column H
 |  |  |  |  |  |  | but they will be grouped.
 |  |  |  |  |  |  | We can sort them if needed.
Spreadsheet: 96314d1295719196-how-do-i-autofilter-across-multiple-sheets-autofilter
Sheet: Sheet3

Business Name | Contact Name
PEPSI | [NAME]
TYCO | [NAME]
ACME | [NAME]
ACME | [NAME]
ACME | [NAME]
TYCO | [NAME]
PEPSI | [NAME]
PEPSI | [NAME]
PEPSI | [NAME]
TYCO | [NAME]
TYCO | [NAME]
PEPSI | [NAME]
PEPSI | [NAME]
PEPSI | [NAME]
TYCO | [NAME]
ACME | [NAME]
PEPSI | [NAME]
PEPSI | [NAME]
ACME | [NAME]
ACME | [NAME]
ACME | [NAME]
TYCO | [NAME]
ACME | [NAME]
PEPSI | [NAME]
Spreadsheet: 726657d1617356990-calculation-in-power-query-dayfile
Sheet: Pricing

CITY | Zone |  | Zone | 0-3,5 | 4-6,5 | 7-10,5 | 10,5- |  | [NAME] ONLY all else 0
ESKILSTUNA | 1 |  | 1 | 103 | 66 | 54 | 45 |  | Cat | Price
TORSHALLA | 1 |  | 3 | 179 | 80 | 76 | 64 |  | A | 70
KVICKSUND | 1 |  | 4 | 206 | 116 | 94 | 88 |  | B | 90
HALLSTAHAMMAR | 3 |  |  |  |  |  |  |  | C | 120
STRANGNAS | 3 |  |  |  |  |  |  |  | D | 210
VASTERAS | 3
MALMKOPING | 3
SURAHAMMAR | 3
FLEN | 3
MARIEFRED | 3
KOLBACK | 3
SKULTUNA | 3
ENKOPING | 4
NYKVARN | 4
SALA | 4
Spreadsheet: 8c073251-e819-48e6-8661-488f00c82b8b
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | Accepting a certain easement in Kansas City, Clay County, Missouri and directing the City Clerk to record the easement and acceptance. |  |  |  | To construct, maintain, and repair a warning siren, and apurtenances located in Kansas City, Clay County, Missouri;
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | City Manager
 |  |  |  |  | Programs, |  |  |  | Public Works
 |  |  |  |  | Departments,
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
Discussion (continued) |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  |  |  | No |  |  |  | Yes
Details
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
Applicable Dates:
Fact Sheet Prepared by:
 | [NAME], Mgr. ROW Services
Reviewed by:
 | [NAME]
Reference Numbers
Spreadsheet: 02a449df-0f8d-4443-be95-916967e46e94
Sheet: Sheet1

Table 5--Wheat: National average price received by farmers (dollars per bushel) 1/, 1/14/2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | All wheat |  | Winter |  | Durum |  | Other spring
 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14
June | 6.7 | 7.32 | 6.55 | 7.18 | 8.31 | 8.26 | 7.78 | 7.72
July | 7.89 | 6.93 | 7.76 | 6.85 | 8.67 | 8.17 | 8.39 | 7.29
August | 8.04 | 6.87 | 7.92 | 6.81 | 7.76 | 7.76 | 8.27 | 6.97
September | 8.27 | 6.8 | 8.25 | 6.79 | 7.77 | 7.9 | 8.38 | 6.71
October | 8.38 | 7 | 8.33 | 7.07 | 7.61 | 7.12 | 8.56 | 6.84
November | 8.47 | 6.85 | 8.38 | 6.96 | 8.11 | 6.75 | 8.65 | 6.7
December | 8.3 | 6.59 | 8.15 | 6.62 | 8.31 | 6.76 | 8.48 | 6.54
January | 8.12 |  | 8.01 |  | 8.24 |  | 8.34
February | 7.97 |  | 7.85 |  | 8.19 |  | 8.11
March | 7.79 |  | 7.63 |  | 8.12 |  | 7.95
April | 7.71 |  | 7.52 |  | 8.01 |  | 7.9
May | 7.68 |  | 7.49 |  | 8.06 |  | 7.84
1/ Preliminary mid-month, weighted-average price for current month. Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 1/13/2014
Spreadsheet: 140346d1328714290-sum-of-data-from-consecutive-nonconsecutive-dates-example1
Sheet: Sheet1

Date | Score |  | Date | Score |  |  | Non Consecutive |  |  | Consecutive
2011-12-27 00:00:00 | 106 |  | 2011-12-28 00:00:00 | 101 |  |  | Sum: |  |  | Sum:
2011-12-31 00:00:00 | 84 |  | 2011-12-30 00:00:00 | 105
2012-01-02 00:00:00 | 100 |  | 2012-01-05 00:00:00 | 109
2012-01-03 00:00:00 | 74 |  | 2012-01-07 00:00:00 | 109
2012-01-06 00:00:00 | 102 |  | 2012-01-12 00:00:00 | 111
2012-01-09 00:00:00 | 106 |  | 2012-01-14 00:00:00 | 93
2012-01-11 00:00:00 | 84 |  | 2012-01-16 00:00:00 | 93
2012-01-20 00:00:00 | 76 |  | 2012-01-18 00:00:00 | 92
2012-01-25 00:00:00 | 97 |  | 2012-01-21 00:00:00 | 121
2012-01-27 00:00:00 | 83 |  | 2012-02-02 00:00:00 | 77
2012-01-29 00:00:00 | 107 |  | 2012-02-04 00:00:00 | 87
2012-01-31 00:00:00 | 94
Spreadsheet: 005b6801-8580-4d96-b866-5fd00c9c0c81
Sheet: 13b

 |  | Dealers** |  |  | Buyside |  |  | TOTAL
Product |  | HY*** | IG | Other | HY | IG | Other | HY | IG | Other
Index Tranche* | Asia |  | <100 | 954 |  | <100 | <100 |  |  | 954
 | Europe |  |  | 782388 |  |  | 86189 |  |  | 868577
 | North America | 130510 | 1058028 | 28572 | 9478 | 27555 | 1488 | 139988 | 1085583 | 30060
Index | Asia | 6377 | 91661 | 204042 | 527 | 8200 | 38428 | 6904 | 99860 | 241209
 | Europe |  |  | 2878369 |  |  | 665011 |  |  | 3258049
 | North America | 274108 | 1593364 | 223527 | 127366 | 667293 | 33646 | 325428 | 1830410 | 257173
TOTAL |  | 410994 | 2743053 | 4117853 | 137370 | 703048 | 824762 | 472319 | 3015854 | 4656022
Estimated gross notional amount outstanding, November 9 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 Data Dictionary for product grade descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 136211d1326473786-how-to-merge-multiple-lines-on-a-time-sheet-sched-time-sheet-integration-4-
Sheet: Site 1

Employee Number | Name |  |  |  |  |  |  |  | Reg Hours | OT Hours | Unworked Stat Hours | Total Weekly Hours | Su | Mo | [NAME] | We | Th | Fr | Sa | Reg Hours | OT Hours | Unworked Stat Hours | Total Weekly Hours | Total Bi-Weekly Hours
Spreadsheet: 35103d1232622325-mapping-the-data-from-back-of-the-column-help
Sheet: Details

policyno | Planstartdate | Plancommencingdate | Planexpirydate | Netpremium | Policystatus | orgid | coverageamount | cumulativebonus | organisation
52078680 | 2008-04-01 00:00:00 | 2008-04-01 00:00:00 | 2009-03-31 00:00:00 | 0 | 40000 | [NAME] | R1 | 743 | [NAME]
52078680 | 2008-04-01 00:00:00 | 2008-04-01 00:00:00 | 2009-03-31 00:00:00 | 0 | 100000 | [NAME] | R1 | 743 | [NAME]
52078680 | 2008-04-01 00:00:00 | 2008-04-01 00:00:00 | 2009-03-31 00:00:00 | 0 | 80000 | [NAME] | R2 | 441 | Bosch Chassis Systems India Ltd
52078680 | 2008-04-01 00:00:00 | 2008-04-01 00:00:00 | 2009-03-31 00:00:00 | 0 | 80000 | [NAME] | R2 | 441 | Bosch Chassis Systems India Ltd
52078680 | 2008-04-01 00:00:00 | 2008-04-01 00:00:00 | 2009-03-31 00:00:00 | 0 | 80000 | [NAME] | R2 | 441 | Bosch Chassis Systems India Ltd
52078680 | 2008-04-01 00:00:00 | 2008-04-01 00:00:00 | 2009-03-31 00:00:00 | 0 | 80000 | [NAME] | R1 | 441 | Bosch Chassis Systems India Ltd
52078680 | 2008-04-01 00:00:00 | 2008-07-26 00:00:00 | 2009-03-31 00:00:00 | 0 | 80000 | [NAME] | F | 441 | Bosch Chassis Systems India Ltd
52100661 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | 2009-09-30 00:00:00 | 0 | 500000 | [NAME] | R1 | 634 | SAS R and D India Pvt Ltd
52100661 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | 2009-09-30 00:00:00 | 0 | 500000 | [NAME] | R2 | 634 | SAS R and D India Pvt Ltd
52100661 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | 2009-09-30 00:00:00 | 0 | 300000 | [NAME] | R2 | 634 | SAS R and D India Pvt Ltd
52100661 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | 2009-09-30 00:00:00 | 0 | 300000 | [NAME] | R1 | 634 | SAS R and D India Pvt Ltd
52100661 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | 2009-09-30 00:00:00 | 0 | 500000 | [NAME] | R2 | 634 | SAS R and D India Pvt Ltd
Spreadsheet: 700458d1603199911-copy-table-to-new-shape-deliveries
Sheet: Sheet1 (2)

Trailer no | Branch NUMBER |  |  |  |  |  | Trailer no | 1st Branch No | 2nd Branch No | 3rd Branch No
Trailer 1 | 111 |  | <- BEFORE |  | AFTER ->
 | 222
 | 333
Trailer 2 | 444
 | 555
Trailer 3 | 666
 | 777
Trailer 4 | 888
 | 999
Trailer 5 | 122
 | 133
 | 144
Spreadsheet: 169293d1342774153-arranging-information-into-tables-new-problem-1
Sheet: Sheet4

Sheet Four
"Helper" | Unit/Process | Rating
 | Outlet works | C
 | Channels | D
 | Effluent Quality | A
 | Sampling Equipment | C
 | Flow | B
 | Solids Levels | A
 | Screen Opereration | D
Spreadsheet: 725565d1616750020-overtime-hours-between-two-datetimes-relative-to-custom-weekly-schedule-overtime
Sheet: Overtime

Table 1
Day of week | WEEKDAY | Work time start | Work time end | Standard hours worked
Noday | 0 | 00:00:00 | 00:00:00 | 0
Monday | 1
Tuesday | 2
Wednesday | 3
Thursday | 4
Friday | 5
Saturday | 6
Sunday | 7
Holidays | 2021-03-30 00:00:00
Holidays | 2021-03-31 00:00:00
Table 2 |  |  |  |  |  | Table 3
Start datetime | Stop datetime | Total hours worked | Standard hours worked | Overtime hours worked |  | Total hours worked | Standard hours worked | Overtime hours worked
2021-03-23 05:00:00 | 2021-03-25 06:00:00 |  | 32
2021-03-23 05:00:00 | 2021-03-25 08:00:00 |  | 33.5
2021-03-23 05:00:00 | 2021-03-25 23:00:00 |  | 48
2021-03-22 22:00:00 | 2021-03-25 23:00:00 |  | 48.50000000011642
2021-03-25 22:00:00 | 2021-03-27 14:30:00 |  | 9.5
2021-03-26 03:00:00 | 2021-03-26 16:30:00 |  | 9
2021-03-26 07:00:00 | 2021-03-29 06:30:00 |  | 8.5
2021-03-29 07:00:00 | 2021-03-31 16:30:00 |  | 15.5
2021-03-29 07:00:00 | 2021-03-30 16:30:00 |  | 15.5
Spreadsheet: 111067d1307557254-function-to-pull-cell-information-from-column-based-on-cell-location-worksheetcompare
Sheet: Sheet1

Col1 | Col2 | Col3
A | 1 | a
B | 2 | b
C | 3 | c
D | 4 | d
E | 5 | e
F | 6 | f
G | 7 | g