tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 67085d1267713025-adding-data-over-existing-chart-720326
Sheet: Graph Data

Sum :
Days :
Average per day for the league :
 |  | 0.5 | 1.5 | 2.5 | 3.5 | 4.5 | 5.5 | 6.5 | 7.5 | 8.5 | 9.5 | 10.5 | 11.5 | 12.5 | 13.5 | 14.5 | 15.5 | 16.5 | 17.5 | 18.5 | 19.5 | 20.5 | 21.5 | 22.5 | 23.5 | 24.5 | 25.5 | 26.5 | 27.5 | 28.5 | 29.5
Spreadsheet: 8bcd465f-cc3d-4a8a-96d3-1e2c4d3ecfa7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
260459 | 71619 | [NAME] | Avellana | PHI | 107 | 00:17:55 | 00:00:00 | 00:36:00 | 00:00:00 | 00:46:48 | 1 | 01:40:43
260459 | 71299 | Arnel | Aba | PHI | 106 | 00:13:13 | 00:00:00 | 00:40:31 | 00:00:00 | 00:47:17 | 2 | 01:41:01
Spreadsheet: 680542d1591083130-returnvalue-count-functions-countwd
Sheet: Sheet1

Name | 2020-05-01 00:00:00 |  |  |  | 2020-05-02 00:00:00 |  |  |  | 2020-05-03 00:00:00 |  |  |  | 2020-05-04 00:00:00 |  |  |  | 2020-05-06 00:00:00 |  |  |  | 2020-05-07 00:00:00 |  |  |  | Total Working Days | Total Off Day OD/RD | Total MC Day
 | Time In | TimeOut | ActualIn | ActualOut | Time In | TimeOut | ActualIn | ActualOut | Time In | TimeOut | ActualIn | ActualOut | Time In | TimeOut | ActualIn | ActualOut | Time In | TimeOut | ActualIn | ActualOut | Time In | TimeOut | ActualIn | ActualOut
Ricky | 08:00:00 | 17:00:00 | MC | MC | 12:00:00 | 21:00:00 | 12:00PM |  | 13:00:00 | 22:00:00 | 13:00:00 | 22:00:00 | OD | OD | OD | OD | RD | RD | OD | OD | 13:00:00 | 22:00:00 | 13:15:00 | 22:00:00 | 4 | 2 | 1
Spreadsheet: 174067d1344905135-getting-a-row-of-data-based-on-a-condition-jhsaio-2012-08-13
Sheet: Sheet1

Location | Month 1 | Month 2 | Month 3
New York | 0.7 | 0.76 | 0.82
London | 0.65 | 0.68 | 0.71
Paris | 0.53 | 0.77 | 0.74
Milan | 0.2 | 0.59 | 0.9
Tokyo | 0.5 | 0.69 | 0.88
Spreadsheet: 727032d1617670269-index-match-with-multiple-criteria-and-treat-blank-cells-as-all-to-return-a-value-excel-forum-example_v2
Sheet: Sheet1

Reference table |  |  |  |  |  |  |  |  |  |  |  | Raw Transaction Data |  |  |  |  |  |  |  | ([NAME] I'm trying to build)
 | Product_ID |  | Customer_Type | Price_line | New_Price_class | Select_code |  | Discount |  |  |  |  | Product_ID |  | Customer_Type | Price_line | New_Price_class | Select_code |  | Discount | What it should return |  | Notes
 | 1001 |  |  |  | Gold |  |  | -0.1 |  |  |  |  | 1001 |  | Ecomm | Brand C | Gold | SKU A |  |  | -0.1 |  | Matches Product_ID and Gold; the blanks in the table are essentially *all* so returns -10%
 | 1002 |  |  |  | Silver |  |  | -0.2 |  |  |  |  | 1001 |  | Distributor | Brand C | Silver | SKU C |  |  |  |  | Although it matches the product ID, it does not match listed criteria (i..e, New_Price_Class) for that specific Product_ID from table so returns a blank (i.e., "")
 | 1003 |  | Dealer | Brand A |  | SKU A |  | -0.3 |  |  |  |  | 1001 |  | Dealer | Brand C | Platinum | SKU D |  |  |  |  | Although it matches the product ID, it does not match listed criteria (i..e, New_Price_Class) for that specific Product_ID from table so returns a blank (i.e., "")
 | 1004 |  | Dealer | Brand B |  | SKU B |  | -0.4 |  |  |  |  | 1002 |  | Distributor | Brand C | Silver | SKU D |  |  | -0.2 |  | Matches Product_ID and Silver (New_Price_class); the blanks in the table are essentially *all* so returns -10%
 |  |  |  |  |  |  |  |  |  |  |  |  | 1002 |  | Ecomm | Brand C | Platinum | SKU D |  |  |  |  | Although it matches the product ID, it does not match listed criteria (i..e, New_Price_Class) for that specific Product_ID from table so returns a blank (i.e., "")
 |  |  |  |  |  |  |  |  |  |  |  |  | 1003 |  | Dealer | Brand A | Gold | SKU A |  |  | -0.3 |  | Matches Product_ID, Customer_Type, Price_line, and Select_code; the blank in the table for New_Price_class is essentially *all* so returns -30%
 |  |  |  |  |  |  |  |  |  |  |  |  | 1003 |  | Dealer | Brand A | Gold | SKU C |  |  |  |  | Although it matches the Product_ID, Customer_Type and Price_Line, it does not match Select_code for that specific Product_ID from table so returns a blank (i.e., "")
 |  |  |  |  |  |  |  |  |  |  |  |  | 1004 |  | Dealer | Brand B | Gold | SKU B |  |  | -0.4 |  | Matches Product_ID, Customer_Type, Price_line, and Select_code; the blank in the table for New_Price_class is essentially *all* so returns -30%
 |  |  |  |  |  |  |  |  |  |  |  |  | 1004 |  | Dealer | Brand B | Gold | SKU C |  |  |  |  | Although it matches the Product_ID, Customer_Type and Price_Line, it does not match Select_code for that specific Product_ID from table so returns a blank (i.e., "")
 |  |  |  |  |  |  |  |  |  |  |  |  | 1005 |  | Dealer | Brand A | Gold | SKU A |  |  |  |  | It does not match the Product_ID so it returns a blank (i.e., "")
Spreadsheet: 0f27515c-f582-42ef-8228-a636eeb792ca
Sheet: Sheet1

Instructor Name | Year | BUAF |  | CIHR   Internal |  | SSRC Internal |  | [NAME] |  | Department |  | Other |  | Year Total | Individual  Total
 |  | # | Amount | # | Amount | # | Amount | # | Amount | # | Amount | # | Amount
[NAME] | 10/11 | 2 | 376 | 1 | 63 | 0 | 0 | 3 | 896 | 5 | 1228 | 12 | 1440
[NAME] | 11/12 | 1 | 500 | 1 | 400 | 0 | 0 | 2 | 500 | 6 | 1000 | 3 | 1200
Spreadsheet: 2dd49325-0068-430a-ab66-473dfc8e3e97
Sheet: Sheet1

Unnamed: 0 | CLASSIFICA DI SOCIETA' ADULTI | Unnamed: 2
Cl. | [NAME] | Pt.
1 | TO211 ATLETICA SETTIMESE | 1038
2 | TO047 A.S.D. BORGARETTO 75 | 1025
3 | TO045 POD.TRANESE UNIONE INDUSTRIALE | 792
4 | TO170 TIGER SPORT RUNNING TEAM ASD | 588
5 | [NAME]. TAPPOROSSO | 406
6 | TO221 G.S. INTERFORZE TORINO | 330
7 | [NAME] PODISTICA NONE | 324
8 | [NAME] CLUB TO/CN | 294
9 | [NAME] LEGGERA | 261
10 | TO049 GRUPPO PODISTICO AVIS TORINO | 261
11 | TO062 G.S.P.T. 75 | 254
12 | [NAME]. [NAME] | 209
13 | [NAME] VALLE VARAITA | 208
14 | TO005 ATL CUMIANA STILCAR | 208
15 | TO003 ATLETICA SUSA | 199
16 | CN001 A.S.D. ATL. FOSSANO '75 | 182
17 | TO130 UNIONE SPORTIVA SAN MICHELE | 177
18 | CN018 ASDGRUPPOPODISTI ALBESI MOKAFE | 164
19 | TO043 POLISPORTIVA ATLETICA '71 | 149
20 | TO019 ASD G.S. POMARETTO '80 | 127
21 | TO169 TEAM 2000 TORINO | 93
22 | VC056 A.S.D. PODISMO DI SERA | 89
23 | TO004 ATLETICA GIO' 22 RIVERA | 88
24 | TO134 POD.DEGLI AMICI PIANEZZA TO | 87
25 | TO076 POLISPORT. NOVATLETICA CHIERI | 85
26 | TO094 ATLETICA EST TORINO | 83
27 | [NAME] | 78
28 | TO200 BASE RUNNING | 75
29 | TO202 CRAL SOCIETA' REALE MUTUA ASS. | 71
30 | TO020 ATL. CHIERESE & LEO | 67
31 | [NAME] TORINO MARATONA | 65
32 | TO015 ATLETICA CANAVESANA | 63
33 | TO246 APPLERUN TEAM | 60
34 | [NAME] | 59
35 | [NAME]. ATLETICA CAFASSE | 57
36 | [NAME] | 57
37 | TO021 A.S.D. TO021 | 55
38 | CN004 A.S.D.DRAGONERO | 51
39 | TO183 ATLETICA VALPELLICE | 47
40 | VC008 A.S.GAGLIANICO 1974 | 38
41 | [NAME] | 37
42 | AT001 S.S. VITTORIO ALFIERI ASTI | 36
43 | TO002 SISPORT FIAT | 35
44 | TO224 A.S.D. PODISTICA TORINO | 35
45 | TO001 C.U.S. TORINO | 34
46 | CN025 A.S.D. BOVES RUN | 32
47 | CN019 A.S.D. PODISTICA 2000 MARENE | 31
48 | TO245 ASD ATLETICA MORENICA | 30
49 | CN021 A.S.D PAM MONDOVI-CHIUSA PESIO | 29
50 | CN012 A.S.D.ATLETICA CARMAGNOLA | 28
51 | [NAME] CLUB | 23
52 | TO025 C.C.R.SPORT. ALPINI TROFARELLO | 21
53 | VC060 A.S.D. OLIMPIA RUNNERS | 21
54 | TO104 GRUPPO SPORTIVO MONCENISIO | 19
55 | TO086 CRAL TRASPORTI TORINESI | 18
56 | TO164 A.S.D. ATLETICA TEAM CARIGNANO | 17
57 | TO029 RUNNING CENTER CLUB TORINO | 13
58 | TO098 GRUPPO SPORTIVO PORTE DILETT. | 7
Spreadsheet: 19704058-d0fd-4ccf-a565-005896ce1952
Sheet: Sheet1

 | Additional File 8. PCR Efficiency, Limits of Detection, and Limits of Quantification
 |  | Efficiency | Efficiency (%) | LOD | LOQ
 | Average | 1.91 | 91.38 | 39.93 | 36.3
 | ACTB | 1.86 | 86.12 | 40 | 35.25
 | ACTR3B | 1.91 | 90.69 | 40 | 36.9
 | ANLN | 1.89 | 89.13 | 40 | 36.63
 | BAG1 | 1.84 | 83.67 | 40 | 37.27
 | BCL2 | 2.01 | 101.14 | 40 | 36.51
 | BIRC5 | 1.85 | 85.09 | 40 | 35.65
 | BLVRA | 1.81 | 80.84 | 40 | 36.55
 | CCNB1 | 1.88 | 88.44 | 40 | 36
 | CCNE1 | 1.83 | 83.26 | 38.74 | 35.87
 | CDC20 | 1.96 | 96.34 | 40 | 36.14
 | CDC6 | 1.93 | 93.13 | 40 | 37.12
 | CDCA1 | 1.89 | 89.2 | 40 | 36.17
 | CDH3 | 1.85 | 84.82 | 40 | 36.73
 | CENPF | 1.87 | 86.52 | 40 | 36.24
 | CEP55 | 1.86 | 86.26 | 40 | 36.7
 | CXXC5 | 1.95 | 94.74 | 38.36 | 36.22
 | EGFR | 1.86 | 86.09 | 40 | 36.23
 | ERBB2 | 1.85 | 84.91 | 40 | 35.59
 | ESR1 | 1.74 | 74.45 | 40 | 35.38
 | [NAME] | 1.93 | 92.88 | 40 | 36.69
 | FGFR4 | 1.81 | 81.31 | 40 | 36.94
 | FOXA1 | 1.87 | 87.43 | 40 | 36.6
 | FOXC1 | 1.77 | 76.87 | 40 | 36.05
 | GPR160 | 1.87 | 86.97 | 40 | 36.71
 | GRB7 | 1.87 | 86.78 | 40 | 35.82
 | KIF2C | 1.72 | 71.9 | 40 | 35.86
 | KNTC2 | 1.83 | 83.14 | 40 | 36.01
 | KRT14 | 3.9 | 289.79 | 40 | 38.93
 | KRT17 | 1.99 | 99.42 | 40 | 36.36
 | KRT5 | 1.91 | 91.07 | 40 | 35.54
 | MAPT | 2.1 | 109.83 | 40 | 37.54
 | MDM2 | 1.93 | 93.49 | 40 | 36.48
 | MELK | 1.97 | 96.71 | 40 | 37.79
 | MIA | 1.86 | 85.57 | 40 | 36.2
 | MKI67 | 1.81 | 81.39 | 40 | 35.72
 | MLPH | 1.97 | 97.48 | 40 | 36.05
 | MMP11 | 2.11 | 110.85 | 40 | 36.29
 | MRPL19 | 1.83 | 82.91 | 40 | 35.92
 | MYBL2 | 1.92 | 91.77 | 38.95 | 36.09
 | MYC | 1.82 | 82.47 | 40 | 35.61
 | NAT1 | 1.99 | 98.99 | 40 | 37.16
 | ORC6L | 1.95 | 95.08 | 40 | 36.8
 | PGR | 1.89 | 89.49 | 40 | 37.25
 | PHGDH | 1.81 | 81.33 | 40 | 35.83
 | PSMC4 | 1.78 | 77.7 | 40 | 36.17
 | PTTG1 | 1.81 | 81.44 | 40 | 35.51
 | RPLP0 | 1.77 | 76.92 | 40 | 35.9
 | RRM2 | 1.82 | 82.01 | 40 | 35.34
 | SF3A1 | 1.87 | 87.44 | 40 | 37.12
 | SFRP1 | 1.86 | 86.31 | 40 | 35.83
 | SLC39A6 | 1.86 | 85.64 | 40 | 35.84
 | TMEM45B | 1.87 | 86.83 | 40 | 36.36
 | TYMS | 1.8 | 80.25 | 40 | 36.31
 | UBE2C | 1.76 | 76.43 | 40 | 34.82
 | UBE2T | 1.95 | 95.02 | 40 | 35.79
Spreadsheet: 770265d1645966350-error-when-using-if-function-function-aligw
Sheet: Sheet1

 |  |  | function compares data from two cells of a  row  to data from two cells one row below
 |  | correct desired result | my incorrect function
 |  |  | IF(A11=A10,"R",""&IF(A11=B10,"X",""))
1 | 2 |  |  | correct
3 | 1 | X |  | correct | 3 | 1 | X
1 | 3 |  |  | correct | 1 | 3
2 | 1 |  |  | correct
1 | 2 |  |  | SHOULD BE BLANK | 2 | 1 | X
1 | 1 |  |  | correct | 1 | 2
2 | 1 | X |  | correct
1 | 2 | R |  | correct | 1 | 2 | Repeat
1 | 2 | R |  | SHOULD BE BLANK | 1 | 2
1 | 1 |  |  | correct
0 | 2 |  |  | correct
1 | 2 |  |  | SHOULD BE BLANK
2 | 3 |  |  | correct
1 | 3 |  |  | correct
1 | 4 |  |  | correct
3 | 2 |  |  | correct
1 | 1 |  |  | SHOULD BE BLANK
1 | 2 | R |  | correct
1 | 2 |  |  | SHOULD BE BLANK
2 | 2 | R |  | correct
2 | 2 |  |  | SHOULD BE BLANK
2 | 3 | R |  | correct
2 | 3 | X |  | correct
3 | 2 |  |  | correct
4 | 2 |  |  | correct
1 | 2 |  |  | correct
0 | 2
Spreadsheet: louise_kitchen__22532__2base329c
Sheet: Daily Position

Security/ | Trade | Settlement | [NAME] |  | Posi- | Strike | Notional |  | Terminations |  |  |  | Market |  | Unrealized | Realized | Total | Prior Day |  | Prior Day |  |  |  |  | Prior YTD |  | Current QTR
Ticker | Date | Date | ment | Cost | tion | Price | Units | Value | Date | Price | Units | Value | Price/Value | Report Date | Gain/(Loss) | Gain/(Loss) | Gain/(Loss) | Realized | Total | Price/Value | Column | Check |  |  | Realized | Total | Realized | Total
RAPTOR II
EI Brazil Gas Holdings and
EI Brazil 1997 and
EI Brazil Investments 1997 | 2000-09-22 00:00:00 | 2003-06-29 00:00:00 | Swap | 0 | Long |  |  |  | 2001-03-26 00:00:00 |  |  |  |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0
Hanover Compressor | 2000-12-28 00:00:00 | 2003-06-29 00:00:00 | Collar | 0 | [NAME] | 92.678
 | 2000-12-28 00:00:00 | 2003-06-29 00:00:00 | Collar |  | Floor | 34.875
 | 2000-12-28 00:00:00 | 2003-06-29 00:00:00 | Swap |  | Swap | 44.875
Enron 60% |  |  | Swap |  |  |  | 3314340 |  | 2001-03-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -7040064 | -33143400
EGF 36.12% |  |  | Swap |  |  |  |  |  | 2001-03-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -4238118.528000001 | -19952320
end
 | Totals
 |  |  |  |  |  |  | Terminations |  |  |  |  |  |  |  |  |  | Realized Losses
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Realized Gains |  |  |  |  |  |  |  |  |  |  |  | MAX
 |  |  |  |  |  |  | Remaining |  |  |  |  |  |  |  |  |  | check
 |  |  |  |  |  |  |  | Asset value
Spreadsheet: 266006d1379462370-drop-down-menu-when-selected-auto-populates-another-cell-with-linked-data-order-form-test
Sheet: Data

 |  |  |  |  | Summer
 |  |  |  |  | Fall | 20100 | 1 | 1
 |  |  |  |  |  | 20101 | 2 | 2
 |  |  |  |  |  | 20102 | 3 | 3
 |  |  |  |  |  | 20103 | 4 | 4
 |  |  |  |  |  | 20104 | 5 | 5
 |  |  |  |  |  | 20105 | 6 | 6
 |  |  |  |  |  | 20106 |  | 7
 |  |  |  |  |  | 20107 |  | 8
 |  |  |  |  |  | 20108 |  | 9
 |  |  |  |  |  | 20109 |  | 10
 |  |  |  |  |  | 20110 |  | 11
 |  |  |  |  |  | 20111 |  | 12
 |  |  |  |  |  | 20112 |  | 13
 |  |  |  |  |  | 20113 |  | 14
 |  |  |  |  |  | 20114 |  | 15
 |  |  |  |  |  | 20115 |  | 16
 |  |  |  |  |  | 20116 |  | 17
 |  |  |  |  |  | 20117 |  | 18
 |  |  |  |  |  | 20118 |  | 19
 |  |  |  |  |  | 20119 |  | 20
 |  |  |  |  |  | 20120 |  | 21
 |  |  |  |  |  | 20121 |  | 22
 |  |  |  |  |  | 20122 |  | 23
 |  |  |  |  |  | 20123 |  | 24
 |  |  |  |  |  | 20124 |  | 25
 |  |  |  |  |  | 20125 |  | 26
 |  |  |  |  |  | 20126 |  | 27
 |  |  |  |  |  | 20127 |  | 28
 |  |  |  |  |  | 20128 |  | 29
 |  |  |  |  |  | 20129 |  | 30
 |  |  |  |  |  | 20130 |  | 36
 |  |  |  |  |  | 20131 |  | 48
 |  |  |  |  |  | 20132 |  | 60
 |  |  |  |  |  | 20133
 |  |  |  |  |  | 20134
 |  |  |  |  |  | 20135
 |  |  |  |  |  | 20136
 |  |  |  |  |  | 20137
 |  |  |  |  |  | 20138
 |  |  |  |  |  | 20139
 |  |  |  |  |  | 20140
 |  |  |  |  |  | 20141
 |  |  |  |  |  | 20142
 |  |  |  |  |  | 20143
Spreadsheet: 60014d1260534941-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-new-budget-planner1
Sheet: Loan N'thn Rock

LOAN
MONTH | YEAR | APR | PAYMENT | BALANCE
January | 2008
February | 2008
March | 2008
April | 2008
May | 2008
June | 2008
July | 2008
August | 2008
September | 2008
October | 2008
November | 2008
December | 2008 | 2
January | 2009 | 2
February | 2009
March | 2009
April | 2009
May | 2009
June | 2009
July | 2009
August | 2009
September | 2009
October | 2009
November | 2009
December | 2009
January | 2010
February | 2010
March | 2010
April | 2010
May | 2010
June | 2010
July | 2010
August | 2010
September | 2010
October | 2010
November | 2010
December | 2010
Spreadsheet: 726925d1617610457-match-codes-from-file-master-code-list-1-
Sheet: Test Sheet

 |  | 589323 CB
 |  | 548168 CB
 |  | 554023 4CB
 |  | 555567 CB
 |  | 050001 34211994
 |  | 554021 CB
 |  | 513111 CB
 |  | 589326 CB
 |  | 579367 SPMEU
 |  | 554811 2CB
 |  | 589661 CB
 |  | 589931 CB
 |  | 589411 CB
 |  | 579361 SPPF
 |  | 588382 CB
 |  | 513147 CB
 |  | 513140 1CB
 |  | 588884 1CBPOF
 |  | 569800 CBI
 |  | 589640 CB
 |  | 555765 CB
 |  | 589206 CB
 |  | 555294 CB
 |  | 509408 SPM
 |  | 585309 10SPM
 |  | 585270 10SPM
 |  | 534199 SPM
 |  | 554258 1CBEU
 |  | 513000 1SPM
 |  | 575568 1SPM
 |  | 588503 4CB
 |  | 522631 SPMK
 |  | 050001 33229086
 |  | 554870 1CB
 |  | 537503 SPM
 |  | 540550 SPM
 |  | 510404 SPM
 |  | 585270 SPM
Spreadsheet: 775668d1649250895-adding-hours-to-date-and-time-stamp-target-sample-060422
Sheet: Sheet1

Req. ID | Task Priority | Task Logged Date | Response time (Hours) | Target Attendance Date
567 | A - Emergency, response time to be 4 hour
Manual Calculation
Req. ID | Task Priority | Task Logged Date | Response time (Hours) | Target Attendance Date
567 | A - Emergency, response time to be 4 hour |  |  | 2022-04-06 17:03:35
567 | B - Priority, response time to be 24 hours | 2022-04-06 13:03:34.640000 |  | 2022-04-07 17:03:35
567 | C - Normal, work to be commenced within 7 days | 2022-04-06 13:03:34.640000 |  | 2022-04-13 17:03:35
567 | D - Non-urgent, work to be commenced within 28 days | 2022-04-06 13:03:34.640000 |  | 2022-05-04 17:03:35
Spreadsheet: 716408d1612197650-sum-values-with-criteria-sample
Sheet: SHPR TRACKER

 | DATE | PERCENTAGE | PAY |  |  | DATE | PAY AMOUNT
 | 2021-02-02 00:00:00 | 0.9 | 50 |  |  | Feb
 | 2021-02-21 00:00:00 | 1 | 60 |  |  | Mar
 | 2021-02-24 00:00:00 | 0.98 | 70 |  |  | Apr
 | 2021-03-05 00:00:00 | 0.65 | 50 |  |  | May
 | 2021-03-21 00:00:00 | 1 | 80 |  |  | Jun
 | 2021-03-29 00:00:00 | 0.98 | 50 |  |  | Jul
 | 2021-04-06 00:00:00 | 0.5 | 60 |  |  | Aug
 | 2021-04-23 00:00:00 | 1 | 85 |  |  | Sep
 | 2021-04-24 00:00:00 | 0.98 | 82 |  |  | Oct
 | 2021-05-02 00:00:00 | 1 | 72 |  |  | Nov
 | 2021-05-27 00:00:00 | 0.98 | 64 |  |  | Dec
 | 2021-05-20 00:00:00 | 0.1 | 18
Spreadsheet: 827068d1682456657-divide-points-by-rank-divide-points-test-answer5
Sheet: Sheet1

Points | Rank 1 | Player # | Rank | SCORE | 0.1 | 0.05 |  | [NAME] |  | [NAME] | count | points | Free | Fixed | share | points2
100 | 0.3 | 4 | 1 |  |  |  |  |  |  |  |  |  |  | 0.3
 | 0.15 | 7 | 2 | 18.14441472947953 | 18.14441472947953 | 18.14441472947953 |  |  |  |  |  |  |  | 0.15
Players |  | 1 | 3 | 12.09627648631969 | 12.09627648631969 | 12.09627648631969
10 |  | 9 | 4 | 9.072207364739766 | 9.072207364739766 | 9.072207364739766
 |  | 8 | 5 | 7.257765891791813 | 7.257765891791813 | 7.257765891791813
 |  | 6 | 6 | 6.048138243159844 | 6.048138243159844 | 6.048138243159844
 |  | 5 | 7 | 5.184118494137009 | 5.184118494137009 | 5.184118494137009
 |  | 10 | 8 | 4.536103682369883 | 4.536103682369883 | 4.536103682369883
 |  | 2 | 9 | 4.032092162106562 | 4.032092162106562 | 4.032092162106562
 |  | 3 | 10 | 3.628882945895906 | 3.628882945895906 | 3.628882945895906
 |  |  |  | SUM |  |  |  |  |  | Totaal
 |  |  |  |  |  |  |  |  |  |  |  |  | saldo
Points | Rank 1 | Player # | Rank | SCORE |  |  | [NAME]
100 | 0.3 | 4 | 1 |  | 1 | [NAME]
 |  | 7 | 1 |  | 2 | D32
Players |  | 1 | 3 |  | 3 | D33
 |  | 9 | 4 |  | 4 | D34
 |  | 8 | 5 |  | 5 | D35
 |  | 6 | 6 |  | 6 | [NAME]
 |  | 5 | 7 |  | 7 | D37
 |  | 10 | 8 |  | 8 | D38
 |  | 2 | 9 |  | 9 | D39
 |  | 3 | 10 |  | 10 | D40
 |  |  |  |  | 11 | D41
 |  |  |  |  | 12 | D42
 |  |  |  |  | 13 | D43
 |  |  |  |  | 14 | D44
 |  |  |  |  | 15 | D45
 |  |  |  |  | 16 | D46
 |  |  |  |  | 17 | D47
 |  |  |  |  | 18 | D48
 |  |  |  |  | 19 | D49
 |  |  |  |  | 20 | D50
 |  |  |  |  | 21 | D51
 |  |  |  | SUM
Spreadsheet: 01145da5-3f7d-445c-afa6-89cf87f382b0
Sheet: Sheet1

Note: P=Permanent | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Communications/Government Relations
Record Series | In Office | Archives | Total Retention Period | Notes
Brochures, programs, invitations, postcards | 2 years | P | P | 2 copies to Archives
Budgets | 2 years |  | 2 years
Electronic tear sheets | Until run |  | Until run
Faculty files with photographs, biographical information | Until termination | P | P
Historical Files | Send to Archives | P | P
Roosevelt-Auditorium Theatre dispute | Send to Archives | P | P
Opening of Gage Building, [NAME], 60th Anniversary | Send to Archives | P | P
Proposed merger with National Louis University | Send to Archives | P | P
Installations of Presidents Gross and [NAME] | Send to Archives | P | P
President Weil files | Send to Archives | P | P
Opening of the University | Send to Archives | P | P
Academic programs information | Send to Archives | P | P
Publications | Send to Archives | P | P
Articles on founding of Roosevelt University | Send to Archives | P | P
Invoices | 2 years |  | 2 years
Logo changes | Current | P | P
Magazine and other publications | Send to Archives | P | P | 2 copies to Archives
Manuals | Current | P | P | 2 copies to Archives
Newsletters | 3 years | P | P | 2 copies to Archives
Press/news releases (electronic, on Web site) | Current | P | P | Archives will print out
Press/news releases (paper) | Send to Archives | P | P
[NAME] (electronic, on CDs) | Current | P | P | Thumbnails/CD to Archives
Radio spots on Intranet | Send recording to Archives | P | P
"Swag," "Tshatshkes," or memorabilia | Send sample to Archives | P | P
Videos | 2 years | P | P
Ad Creative | 3 years | P | P
Website Content | 3 years | P | P
Government Grant/Earmark Requests (successful) | 3 years | P | P
Government Grant Earmark Requests (unsuccessful) | 3 years |  | 3 years
Major Policy/Legislative Corres. | 3 years | P | P
Major Events -- Program, invitations, etc. | 3 years | P | P
Consular Corps Events | 3 years | P | P
Contracts (record copy) | Expiration + 7 years | P | P | If record copy is in another department, duplicatecontract is temporary
Spreadsheet: 757479d1638284568-need-help-with-if-formula-statement-if-formula-pricing-strategy-change-sample-error
Sheet: Sheet1

New Pricing | Current Pricing Strategy Code | Credit Bureau Score Number |  | this | or this
 | AS02 | 816
 | AS03 | 729
 | AS04 | 650 |  |  |  | IF(C2>"729","AS21",IF(C2="680-729","AS25",IF(C2="640-679","AS26",IF(C2="600-639","AS24",IF(C2="565-599","AS60",IF(C2<"565","AS60",))))))
 | AS05 | 639
 | AS06 | 600
 | AS07 | 599
 | AS08 | 566
 | AS09 | 564
 | AS10 | 0
Spreadsheet: 0bcd5ad7-934f-4994-970e-0b8702bcabb7
Sheet: 1

 | Apr 26 | May 3 | May 10 | May 17 | May 24
Total Interest Rate | 393435317 | 398512394 | 387954732 | 397914082 | 402094720
Cleared** | 188165176 | 190914654 | 180958931 | 191544662 | 194599924
Uncleared | 205270141 | 207597740 | 206995801 | 206369420 | 207494796
Total Cross-Currency | 16302929 | 16390061 | 16324215 | 16198271 | 16225526
Cleared | N/A*** | N/A | N/A | N/A | N/A
Uncleared | 16302929 | 16390061 | 16324215 | 16198271 | 16225526
Total Credit | 21497620 | 21671672 | 21656424 | 21581441 | 21732462
Cleared | 2800161 | 2873243 | 2832895 | 2810345 | 2864839
Uncleared | 18697460 | 18798429 | 18823529 | 18771096 | 18867623
Total Equity | 5745280 | N/A | N/A | N/A | N/A
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 5745280 | N/A | N/A | N/A | N/A
Total Other Commodity | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 440072146 | 439665127 | 429026371 | 438784794 | 443143708
Weekly snapshot, estimated gross notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions and Explanatory Notes for data sources.
**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].