tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1e0eecd6-1cba-4381-bdd8-3aa25a00d487
Sheet: Sheet1

CDBG Missing Data | 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 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
SALEM OR
Data as of 06/01/2009
Act ID | Status | [NAME] | Matrix CD | Prop Accomp MA04 | Actual [NAME] | Total [NAME] CDBG08 | Create FT Jobs CDBG11 | Create FT Jobs LM CDBG11 | Create PT Hours CDBG11 | Create PT Hours LM CDBG11 | Retain FT Jobs CDBG11 | Retain FT Jobs LM CDBG11 | Retain PT Hours CDBG11 | Retain PT Hours LM CDBG11 | Assist Type CDBG11 | [NAME] CDBG13 | [NAME] CDBG13 | Num Very Low Incm CDBG13 | Units Start CDBG14 | Units [NAME] CDBG14 | Units Occ LM Start CDBG14 | Units Exp CDBG14 | Units [NAME] CDBG14 | Units Occ LM Exp CDBG14 | LMA % CDBG07
2869 | 3 | LMH | 01 |  | 2 | 0 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
2924 | 3 | LMC | 03 | 0
Spreadsheet: 810462d1671787339-find-and-return-a-value-based-each-date-date-by-rev
Sheet: Main

Part Num | EUTR | Filter | Group | Sub-Group | Range | Sales Code? | Description | Finish | Region | Type Code | Stock | Sold | Sold2 | Stock Balance | CG Stock | Wayfair Feed QTY | WSB BALANCE | WSB Outstanding PO | Buy to Order | dif | Holding | QC | QU PARTS? | Sec | BHF | WBS | WSB LAST QTY | WSB LAST DATE | New Avg Sales | Dec Sales |  | AVG | GL0067 | CS0002 | BU0068 | AM0040 | WH0006 | BH0005 | Old PO formula | New PO |  |  | CG PO | ETA 1 | ETA 2 | ETA 3 | ETA 4 | ETA 5 | REV1 | REV2 | REV3 | [NAME] | REV5
400-402-005
400-402-098
400-402-007
400-402-130
400-402-131
400-401-167
400-401-001
400-402-066
200-205-001
200-201-003
200-201-002
200-201-066
Spreadsheet: 824404d1680546912-basic-formula-for-convert-in-numbers-book1
Sheet: Sheet1

Followers_Twitter | Followers_Facebook | Followers_LinkedIn | result
7046 | NA | NA | 7046 | NA | NA
NA | 1.5K | 4299 | NA | 1500 | 4299
96.9K | NA | 1922 | 969000 | NA | 1922
Spreadsheet: 689812d1596665596-conditional-formatting-date-range-brettk
Sheet: Site Summary

 | City | Address | State | LED | FTE at Site | % FTE at Site | Cost/FTE | RSF/FTE
 | A | A | FL | 2021-10-31 00:00:00 | 13 | 0.8666666666666667 | 27005.22866666667 | 322.4
 | B | B | MI | 2022-05-31 00:00:00 | 2 | 1 | 17284.09 | 700
 | C | C | FL | 2022-12-31 00:00:00 | 14 | 0.7368421052631579 | 69353 | 509.2105263157895
 | D | D | MO | 2021-07-07 00:00:00 | 113 | 0.8248175182481752 | 15168.08642335766 | 130.4452554744526
 | E | E | NJ | 2025-02-19 00:00:00 | 183 | 0.9104477611940298 | 4375.271592039801 | 165.9353233830846
 | F | F | MO | 2021-07-31 00:00:00 | 1 | 1 | 30080 | 752
 | G | G | TX | 2023-07-31 00:00:00 | 4 | 0.06779661016949153 | 7218.246271186439 | 235.5762711864407
 | H | H | FL | 2024-09-30 00:00:00 | 14 | 1 | 17.49428571428571 | 243.4285714285714
 | I | I | MO | 2027-05-30 00:00:00 | 158 | 0.9518072289156626 | 7112.092831325301 | 89.19277108433735
 | J | J | NC | 2026-09-30 00:00:00 | 2 | 0.00816326530612245 | 6537.469061224489 | 194.7224489795918
 | K | K | NY | 2029-04-30 00:00:00 | 17 | 0.06227106227106227 | 24595.88908424908 | 251.4139194139194
 | L | L | DE | 2027-01-31 00:00:00 | 5 | 0.8333333333333334 | 26217.87333333333 | 605.8333333333334
 | M | M | MN | owned | 1 | 0.09090909090909091 | 83000 | 296.7272727272727
 | N | N | MN | owned | 2 | 0.1538461538461539 | 22751.17076923077 | 262.3076923076923
 | O | O | MN | 2024-05-31 00:00:00 | 452 | 0.2308478038815117 | 7585.212323799821 | 226.9979570990807
 |  |  |  | any cell within the range of 1/1/2020 - 12/31/2025 to be red | any cell with less than or equal to 20 to be red and between 21 - 30 to be yellow | any cell with greater than 50% to be yellow and any cell with greater than 70% to be red | any cell between $30,000 - $59,999 in yellow and anything greater than or equal to $60,000 in red | any cell between 300 - 599 in yellow and anything at or over 600 in red
Spreadsheet: 599638d1543233542-ststistic-bettter-solution-car-gps
Sheet: 3 Nov

 |  |  |  |  |  |  |  |  | DAY IN LOCATION |  |  |  |  |  |  | 1 Nov
Driver | car | Location | PA | LO | BE | WI | MA |  | Paris | London | Berlin | [NAME] | Madrid |  |  | 2 Nov
[NAME] | Car Blue | Paris |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 Nov
Carmen | Car Red | London
Sue | Car Green | Paris
[NAME] | Car Black | [NAME]
[NAME] | [NAME] | Madrid
 |  | this columns must wanish |  |  |  |  |  |  | this colunms must remain in every sheet
 |  |  |  |  |  |  | another solution??
Spreadsheet: darrell_schoolcraft__7638__imball0201
Sheet: PG&E

56698
Day | Measured | Scheduled
1 | -248536 | -247815
2 | -256988 | -257667
3 | -177704 | -177700
4 | -184043 | -182700
5 | -102760 | -120064
6 | -159504 | -157450
7 | -146645 | -155851
8 | -147570 | -155884
9 | -67555 | -76928
10 | -98016 | -106532
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 59071
2002-01-10 00:00:00
CBS Dollars
 |  |  | -80543.15
Spreadsheet: 155341d1336763356-populate-columns-in-one-sheet-based-off-of-a-few-lists-in-a-different-sheet-autopopulatecolumns-jd-5-11
Sheet: Results

Theme | Cluster | QuestionShort | Geography | DemographicType | DemographicSlice | SortOrder | Respondants | LongLegendValue1 | LongLegendValue2 | LongLegendValue3 | LongLegendValue4 | LongLegendValue5 | LongLegendValue6 | LongLegendValue7 | LongLegendValue8 | LongLegendValue9 | LongLegendValue10
 | Q2_1 |  |  |  | 2
 | Q2_1 |  |  |  | 3
 | Q2_1 |  |  |  | 4
 | Q2_1 |  |  |  | 5
 | Q2_1 |  |  |  | 6
 | Q2_1 |  |  |  | 7
 | Q2_1 |  |  |  | 8
 | Q2_1 |  |  |  | 9
 | Q2_1 |  |  |  | 10
 | Q2_1 |  |  |  | 11
 | Q2_1 |  |  |  | 12
 | Q2_1 |  |  |  | 2
 | Q2_1 |  |  |  | 3
 | Q2_1 |  |  |  | 4
 | Q2_1 |  |  |  | 5
 | Q2_1 |  |  |  | 6
 | Q2_1 |  |  |  | 7
 | Q2_1 |  |  |  | 8
 | Q2_1 |  |  |  | 9
 | Q2_1 |  |  |  | 10
 | Q2_1 |  |  |  | 11
 | Q2_1 |  |  |  | 12
 |  | Q2_1_1
 |  | Q2_1_1
 |  | Q2_1_1
 |  | Q2_1_1
 |  | Q2_1_1
 |  | Q2_1_1
 |  | Q2_1_1
 |  | Q2_1_1
 |  | Q2_1_1
 |  | Q2_1_1
 |  | Q2_1_1
 |  | Q2_1_1
 |  | Q2_1_2
 |  | Q2_1_2
 |  | Q2_1_2
 |  | Q2_1_2
 |  | Q2_1_2
 |  | Q2_1_2
 |  | Q2_1_2
 |  | Q2_1_2
 |  | Q2_1_2
 |  | Q2_1_2
 |  | Q2_1_2
 |  | Q2_1_2
 |  | Q2_1_3
 |  | Q2_1_3
 |  | Q2_1_3
 |  | Q2_1_3
 |  | Q2_1_3
 |  | Q2_1_3
 |  | Q2_1_3
 |  | Q2_1_3
 |  | Q2_1_3
 |  | Q2_1_3
 |  | Q2_1_3
 |  | Q2_1_3
Spreadsheet: 822276d1679234973-conditional-format-issue-cat1-vs-cat2-help
Sheet: Sheet1

Code | Name | Flaging | [NAME] | Feb22 | Mar22 | Apr22 | May22 | [NAME] | [NAME] | Aug22 | Sep22 | Oct22 | Nov22 | Dec22 | Jan23 | Feb23 | Mar23 | Grand Total
Code 1 | Name 1 | Cat1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | Conditional Formatting Notes:
Code3 | Name3 | Cat1 | 60 | 64 | 80 | 64 | 104 | 119 | 94 | 100 | 81 | 84 | 105 | 90 | 91 | 112 |  | 1248 |  | In column C I have 2 categories Cat1 App & Cat 2 Claims
Code3 | Name3 | Cat2 | 132 | 142 | 174 | 129 | 235 | 248 | 206 | 304 | 276 | 380 | 289 | 337 | 342 |  |  | 3194 |  | So, I need to highlight through conditional formatting if the below 2 conditions match
Code4 | Name4 | Cat1 |  | 2 | 5 | 1 | 4 | 2 | 6 | 4 | 3 | 3 | 1 | 5 | 1 | 2 |  | 39 |  | If no count in CAT1 approvals then cells in CAT2 in each months green claims green
Code4 | Name4 | Cat2 |  | 2 | 5 | 1 | 4 | 2 | 5 | 4 | 3 | 3 | 1 | 5 | 1 |  |  | 36 |  | If count is there in CAT1 approval then CAT2 no claims in each months will be red
Code8 | Name8 | Cat1 |  | 7 | 10 |  | 1 | 14 | 1 | 4 | 5 | 3 | 2 | 2 | 1 |  |  | 50 |  | If no count in CAT1 & CAT2 mar it green
Code8 | Name8 | Cat2 |  | 17 |  |  | 18 | 25 |  |  | 9 | 13 | 9 |  |  |  |  | 91
[NAME] | Name9 | Cat1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1
[NAME] | Name9 | Cat2 | 1 | 4 |  | 2 |  | 4 |  |  |  |  |  | 4 | 2 |  |  | 17
Code10 | Name10 | Cat1 | 64 | 49 | 70 | 51 | 70 | 75 | 65 | 48 | 33 | 73 | 59 | 48 | 54 | 45 |  | 804
Code10 | Name10 | Cat2 | 82 | 61 | 72 | 55 | 89 | 92 | 75 | 62 | 50 | 92 | 68 | 57 | 70 |  |  | 925
Code11 | Name11 | Cat1 | 4 | 2 | 5 | 3 | 7 | 8 | 8 | 21 | 11 | 19 | 12 | 10 | 11 | 14 |  | 135
Code11 | Name11 | Cat2 | 25 | 18 | 32 | 17 | 37 | 45 | 54 | 77 | 49 | 102 | 107 | 79 | 117 |  |  | 759
Code15 | Name15 | Cat1 | 5 | 5 | 11 | 5 |  | 2 | 2 | 3 | 5 | 5 | 2 | 2 | 2 | 1 |  | 50
Code15 | Name15 | Cat2 | 7 | 7 | 17 | 9 |  | 2 | 5 | 17 | 7 | 8 | 5 | 3 | 5 |  |  | 92
Spreadsheet: 72408ed7-cde0-40a7-82b5-b71e99ff70e0
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: |  |  | 2011-10-25 14:34:05.450000
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.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.401 | 101.276 | 101.151 | 100.776
4.25 | 100.674 | 100.549 | 100.424 | 100.049 |  | Note: | Refer To Price [NAME]
4.125 | 100.175 | 100.05 | 99.925 | 99.55 |  |  | For all Price Adjs
4 | 99.708 | 99.583 | 99.458 | 98.833
3.875 | 99.157 | 99.032 | 98.907 | 98.282
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.653 | 101.528 | 101.403 | 101.028
3.75 | 101.159 | 101.034 | 100.909 | 100.534
3.625 | 100.594 | 100.469 | 100.344 | 99.969
3.5 | 100.259 | 100.134 | 100.009 | 99.634
3.375 | 99.81 | 99.685 | 99.56 | 98.935
3.25 | 99.306 | 99.181 | 99.056 | 98.431
 |  |  |  |  |  | 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 | 2011-11-08 14:34:05.450000
30 DAY | 2011-11-23 14:34:05.450000
45 DAY | 2011-12-08 14:34:05.450000
60 DAY | 2011-12-23 14:34:05.450000
90 DAY | 2012-01-22 14:34:05.450000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 687196d1595015097-need-a-formula-for-certain-date-conditions-need-a-formula
Sheet: Sheet1

Condition: | If Due Date Is | Status |  |  | Example: | Due Date | Status
 | 7/19/2020 or less | LATE |  |  |  | 2020-06-01 00:00:00 | LATE
 | 7/20/2020 - 7/24/2020 | DUE THIS WEEK |  |  |  | 2020-07-22 00:00:00 | DUE THIS WEEK
 | 7/25/2020 - 7/31/2020 | APPROACHING |  |  |  | 2020-07-27 00:00:00 | APPROACHING
 | 8/1/2020 - 8/7/2020 | DUE DATE WITHIN 2 WKS |  |  |  | 2020-08-03 00:00:00 | DUE DATE WITHIN 2 WKS
 | 8/8/2020 or greater | DUE DATE >2 WKS |  |  |  | 2020-09-20 00:00:00 | DUE DATE >2 WKS
Spreadsheet: 103551d1301322811-if-next-formula-example
Sheet: Resident Charges

Acct # | Name | Location | Charges | Tip | Tax | Total
1111 | [NAME] | Bar | 5 | 1 | 0.3 | 6.3
1134 | [NAME] | [NAME] | 4 | 1 | 0.24 | 5.24
1111 | [NAME] | [NAME] | 5 | 1 | 0.3 | 6.3
Spreadsheet: 78228d1278615575-calculating-man-hours-and-days-worked-over-multiple-sheets-employee-hours-sample
Sheet: Employee Hours

 | Sun | Mon | Tue | Wed | Thu | Fri | Sat
Name | 2010-07-01 00:00:00 | 2010-07-02 00:00:00 | 2010-07-03 00:00:00 | 2010-07-04 00:00:00 | 2010-07-05 00:00:00 | 2010-07-06 00:00:00 | 2010-07-07 00:00:00 | Total Hours Worked | Total Days Worked
Example: |  |  |  |  |  |  |  | 0
[NAME] | 10.5 | 7 | 10.5 |  | 10.5 | 10.5 |  | 49 | 5
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
TOTAL |  |  |  |  |  |  |  | 49 | 5
This sheet needs to find the guys name and enter in their name, and hours. If possible also sort it by name.
Spreadsheet: 143596d1330471762-make-a-drop-down-list-i-e-from-data-validation-that-can-also-accept-any-value-freezer_stocks_2012
Sheet: Vectors and Bacteria

pCAMBIA 1300
pCAMBIA 1200 | K599
pFLEV | EHA 105
pMCS | DH5α
p201N-GFPi | C58
p201N-rvGFPi | R1000
p201_U3 | A281
pCON GFPi | LBA 4404
pCON rvGFPi | Other
pCON U3 | *
p30CO2iART
p4FO1iART
p30CO2Han 1300
p4FO1Han 1300
p10A06_1300
p10A06_1300
p10A06HH
p4FO Han 1300
p10A06 Han
p10A06
p4FO1
p30CO2
pAnda35HK 725
pAnda35HK 425
pAnda35HK
pAnda prp17
*
Spreadsheet: eff76b4f-d7ec-4415-9b7f-2dfdf7568537
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
42729270 | 2014-08-15 04:55:52 | AXIS | 0 | 5 | 6 | 538345 | AJBQC | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42729611 | 2014-08-15 05:21:29 | ALLIES | 1 | 6 | 2 | 538345 | AJBQC | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42742951 | 2014-08-16 05:11:50 | AXIS | 0 | 2 | 6 | 496922 | Helcat | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42743248 | 2014-08-16 06:05:37 | AXIS | 0 | 5 | 6 | 496922 | Helcat | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42768282 | 2014-08-17 23:42:01 | ALLIES | 1 | 6 | 4 | 716436 | Droopy007 | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42768832 | 2014-08-18 00:33:04 | AXIS | 1 | 6 | 2 | 716436 | Droopy007 | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
Spreadsheet: 682644d1592235800-summing-values-based-on-increasing-date-additional-criteria-sum-values-based-on-increasing-date-test2
Sheet: Sheet1

Order Number | Customer Number | Delivery Date | Invoiced Value
132097 | 40512 | 2019-10-01 00:00:00 | 316533
139319 | 40652 | 2019-10-01 00:00:00 | 328735
146165 | 40204 | 2019-10-01 00:00:00 | 426424
159603 | 40760 | 2019-10-01 00:00:00 | 339248
161034 | 40383 | 2019-10-01 00:00:00 | 312640
164354 | 40970 | 2019-10-01 00:00:00 | 306353
165620 | 40730 | 2019-10-01 00:00:00 | 339932
168149 | 40780 | 2019-10-01 00:00:00 | 152749
168332 | 40652 | 2019-10-01 00:00:00 | 312536
170038 | 40730 | 2019-10-01 00:00:00 | 132971
170047 | 40730 | 2019-10-01 00:00:00 | 143821
172146 | 40962 | 2019-10-01 00:00:00 | 679120
172624 | 40567 | 2019-10-01 00:00:00 | 164236
173166 | 40752 | 2019-10-01 00:00:00 | 520893
174570 | 40962 | 2019-10-01 00:00:00 | 365558
175608 | 40383 | 2019-10-01 00:00:00 | 159817
175666 | 40730 | 2019-10-01 00:00:00 | 0
175992 | 40730 | 2019-10-01 00:00:00 | 269608
177552 | 40780 | 2019-10-01 00:00:00 | 339932
Spreadsheet: 854561d1704386463-if-formula-to-indicate-if-a-user-has-completed-all-training-courses-excelquestion_jan04
Sheet: Sheet1

User Name | Training 1 | Training 2 | Training 3 | Overall Status
User 1 | In Progress | Not Started | Not Started | Incomplete
User 2 | Complete | Complete | Complete | Complete
User 3 | In Progress | In Progress | In Progress | Incomplete
User 4 | Complete | Complete | In Progress | Incomplete
User 5 | Complete | Complete | Complete | Complete
Spreadsheet: 865071d1712151378-replace-duplicates-sample-2-2-aligw
Sheet: Sheet1

 |  | #organic inspire E150 - B&C - WHT|XS-2XL - TU01B | 2.81 | 8.711
 |  | #organic inspire E150 - B&C - WHT|3XL-5XL - TU01B | 3.51 | 10.881
 |  | #organic inspire E150 - B&C - COL|XS-2XL - TU01B | 2.81 | 8.711
 |  | #organic inspire E150 - B&C - COL|3XL-5XL - TU01B | 3.51 | 10.881
 |  | #organic inspire E150 /women - B&C - WHT|XS-2XL - TW02B | 2.81 | 8.711
 |  | #organic inspire E150 /women - B&C - WHT|3XL - TW02B | 3.51 | 10.881
 |  | #organic inspire E150 /women - B&C - COL|XS-2XL - TW02B | 2.81 | 8.711
 |  | #organic inspire E150 /women - B&C - COL|3XL - TW02B | 3.51 | 10.881
 |  | Rhine 16x22 Wash Glove - SG ACCESSORIES -TOWELS - COL|One - TO3502 | 0.5 | 1.55
 |  | Seine 50x100 [NAME] ACCESSORIES -TOWELS - WHT|One - TO5503 | 3.84 | 11.904
 |  | Seine 50x100 [NAME] ACCESSORIES -TOWELS - COL|One - TO5503 | 3.92 | 12.152
 |  | Original Pull-On Beanie - Beechfield - COL|One - B44 | 1.32 | 4.092000000000001
 |  | Original Pull-On Beanie - Beechfield - MAR|One - B44 | 1.42 | 4.401999999999999
 |  | Seine 70x140 BathTowel - SG ACCESSORIES -TOWELS - WHT|One - TO5504 | 8.02 | 24.862
 |  | Seine 70x140 BathTowel - SG ACCESSORIES -TOWELS - COL|One - TO5504 | 8.67 | 26.877
 |  | [NAME] Wicking Polo - Regatta Professional - COL|XS-3XL - TRS147 | 7.74 | 23.994
 |  | Seine 40x60 [NAME] ACCESSORIES -TOWELS - WHT|40X60 - TO5505 | 2.17 | 6.727
 |  | [NAME] ACCESSORIES -TOWELS - WHT|30X50 - TO5505 | 1.77 | 5.487
 |  | Seine 40x60 [NAME] ACCESSORIES -TOWELS - COL|40X60 - TO5505 | 2.27 | 7.037000000000001
 |  | [NAME] ACCESSORIES -TOWELS - COL|30X50 - TO5505 | 1.87 | 5.797000000000001
 |  | Contrast [NAME] | 7.74 | 23.994
 |  | [NAME] | 24.24 | 75.14399999999999
 |  | Baby Reversible Hat - BabyBugz - COL|6-12 to 2-3y - BZ44 | 2.71 | 8.401
 |  | Seine 100x180 Beach Towel - SG ACCESSORIES -TOWELS - WHT|100X180 - TO5506 | 13.85 | 42.935
 |  | [NAME] Towel - SG ACCESSORIES -TOWELS - WHT|100X150 - TO5506 | 13.28 | 41.168
 |  | Seine 100x180 Beach Towel - SG ACCESSORIES -TOWELS - COL|100X180 - TO5506 | 13.83 | 42.873
 |  | [NAME] Towel - SG ACCESSORIES -TOWELS - COL|100X150 - TO5506 | 13.35 | 41.385
 |  | [NAME] [NAME] | 27.15 | 84.16499999999999
 |  | Tiber 50x100 [NAME] ACCESSORIES -TOWELS - WLB|One - TO5001 | 4.14 | 12.834
 |  | Tiber 50x100 [NAME] ACCESSORIES -TOWELS - COL|One - TO5001 | 4.34 | 13.454
 |  | [NAME] [NAME] | 32.99 | 102.269
Spreadsheet: 196251d1353933739-merging-data-from-differently-shaped-streams-elec-monitoring-example-workbook
Sheet: Desired results

Date | Time | Source A - Source B kWh | Source B kWh
2012-10-01 00:00:00 | 00:00:00 | 4 | 3
2012-10-01 00:00:00 | 00:30:00 | 4 | 3
2012-10-01 00:00:00 | 01:00:00 | 4 | 3
2012-10-01 00:00:00 | 01:30:00 | 4 | 3
2012-10-01 00:00:00 | 02:00:00 | 5 | 3
2012-10-01 00:00:00 | 02:30:00 | 4 | 4
2012-10-01 00:00:00 | 03:00:00 | 3 | 4
2012-10-01 00:00:00 | 03:30:00 | 4 | 3
2012-10-01 00:00:00 | 04:00:00 | 3 | 3
2012-10-01 00:00:00 | 04:30:00 | 3 | 3
2012-10-01 00:00:00 | 05:00:00 | 3 | 3
2012-10-01 00:00:00 | 05:30:00 | 3 | 3
2012-10-01 00:00:00 | 06:00:00 | 4 | 3
2012-10-01 00:00:00 | 06:30:00 | 4 | 3
2012-10-01 00:00:00 | 07:00:00 | 3 | 4
2012-10-01 00:00:00 | 07:30:00 | 4 | 4
2012-10-01 00:00:00 | 08:00:00 | 7 | 6
2012-10-01 00:00:00 | 08:30:00 | 6 | 7
2012-10-01 00:00:00 | 09:00:00 | 8 | 8
2012-10-01 00:00:00 | 09:30:00 | 7 | 7
2012-10-01 00:00:00 | 10:00:00 | 7 | 8
2012-10-01 00:00:00 | 10:30:00 | 8 | 7
2012-10-01 00:00:00 | 11:00:00 | 8 | 8
2012-10-01 00:00:00 | 11:30:00 | 11 | 8
2012-10-01 00:00:00 | 12:00:00 | 8 | 9
2012-10-01 00:00:00 | 12:30:00 | 8 | 8
2012-10-01 00:00:00 | 13:00:00 | 7 | 9
2012-10-01 00:00:00 | 13:30:00 | 9 | 9
2012-10-01 00:00:00 | 14:00:00 | 9 | 11
2012-10-01 00:00:00 | 14:30:00 | 8 | 9
2012-10-01 00:00:00 | 15:00:00 | 8 | 8
2012-10-01 00:00:00 | 15:30:00 | 10 | 8
2012-10-01 00:00:00 | 16:00:00 | 11 | 9
2012-10-01 00:00:00 | 16:30:00 | 8 | 8
2012-10-01 00:00:00 | 17:00:00 | 8 | 9
2012-10-01 00:00:00 | 17:30:00 | 9 | 9
2012-10-01 00:00:00 | 18:00:00 | 8 | 8
2012-10-01 00:00:00 | 18:30:00 | 9 | 8
2012-10-01 00:00:00 | 19:00:00 | 8 | 9
2012-10-01 00:00:00 | 19:30:00 | 7 | 8
2012-10-01 00:00:00 | 20:00:00 | 6 | 7
2012-10-01 00:00:00 | 20:30:00 | 7 | 6
2012-10-01 00:00:00 | 21:00:00 | 7 | 6
2012-10-01 00:00:00 | 21:30:00 | 6 | 6
2012-10-01 00:00:00 | 22:00:00 | 5 | 5
2012-10-01 00:00:00 | 22:30:00 | 4 | 5
2012-10-01 00:00:00 | 23:00:00 | 5 | 4
2012-10-01 00:00:00 | 23:30:00 | 5 | 5
2012-10-02 00:00:00 | 00:00:00 | 5 | 4
2012-10-02 00:00:00 | 00:30:00 | 4 | 3
2012-10-02 00:00:00 | 01:00:00 | 5 | 3
2012-10-02 00:00:00 | 01:30:00 | 4 | 3
2012-10-02 00:00:00 | 02:00:00 | 5 | 3
2012-10-02 00:00:00 | 02:30:00 | 4 | 4
Spreadsheet: acc39e1d-2806-4f65-bb20-c84d1af89679
Sheet: 4

 | Jul 5 |  | Jul 12 |  | Jul 19 |  | Jul 26
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rate* | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, net notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, cleared and uncleared.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 732822d1621257341-re-request-for-guidance-about-sorting-the-data-help-for-sorting
Sheet: Sheet1

Countries Name | Label | Label1 | 1960 | 1961 | 1962 | 1963 | 1964
Aruba | ABW | ABW
Afghanistan | AFG | [NAME]
United Arab Emirates | ARE | ARE
Argentina | ARG | ARM |  | 5.427842879512482 | -0.8520215234819659 | -5.308196826517275 | 10.13029766143383
Armenia | ARM | BDI
American Samoa | ASM | AZE
[NAME] and [NAME] | ATG
Australia | AUS |  |  | 2.485789429031996 | 1.295906080674285 | 6.214617910580827 | 6.97853350773255
Austria | AUT |  |  | 5.537979316845281 | 2.648675112952617 | 4.138267581570361 | 6.124353737628425
Azerbaijan | AZE
Burundi | BDI |  |  | -13.7461350547258 | 9.063157934596518 | 4.135407419775007 | 6.27303790305595
Belgium | BEL |  |  | 4.978423063191968 | 5.212003509255283 | 4.351584281670512 | 6.956684733441023
Benin | [NAME] |  |  | 3.141280458717958 | -3.426409822875783 | 4.73002797546205 | 6.650759118633204