{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":49,"n_cols":13,"rows_kept":49,"merged":[[0,11,1,12],[6,11,17,12]]}
["CUSIP","AuctionDate","IssueDate","Term","CouponType","ModifiedDuration","TenYearOnTheRunCUSIP","OnTheRunModifiedDuration","TenYearEquivalentFactor","AuctionAwardDollars (User Input)",null,"10-Year Equivalent  Calculator"]
["91282CMF5","2025-01-06","2025-01-15","3-Year","COUPONS",{"v":2.7874918439402867,"d":"2.78749"},"91282CLW9",{"v":7.8663558697708345,"d":"7.86636"},0.35436,{"v":0,"d":"$0"}]
["91282CLW9","2025-01-07","2025-01-15","10-Year","COUPONS",{"v":7.859599720862749,"d":"7.85960"},"91282CLW9",{"v":7.859599720862749,"d":"7.85960"},1,{"v":0,"d":"$0"},null,"Auction Awards ($)",{"$f":"SUM(J2:J49)","v":{"v":0,"d":"$0"}}]
["912810UE6","2025-01-08","2025-01-15","30-Year","COUPONS",{"v":15.709817827958773,"d":"15.70982"},"91282CLW9",{"v":7.859097649854583,"d":"7.85910"},1.99893,{"v":0,"d":"$0"},null,"Auction Awards (10-Year Equivalent)",{"$f":"SUMPRODUCT(I2:I49,J2:J49)","v":{"v":0,"d":"$0"}}]
["912810UF3","2025-01-22","2025-01-31","20-Year","COUPONS",{"v":12.601563526511008,"d":"12.60156"},"91282CLW9",{"v":7.825492350434172,"d":"7.82549"},1.61032,{"v":0,"d":"$0"}]
["91282CML2","2025-01-23","2025-01-31","10-Year","TIPS COUPONS",{"v":4.444034843022379,"d":"4.44403"},"91282CML2",{"v":4.444034843022379,"d":"4.44403"},1,{"v":0,"d":"$0"},null,"Instructions"]
["91282CMG3","2025-01-27","2025-01-31","5-Year","COUPONS",{"v":4.459109566913179,"d":"4.45911"},"91282CLW9",{"v":7.834929910328909,"d":"7.83493"},0.56913,{"v":0,"d":"$0"},null,"To convert par amount awarded at auction to 10-year equivalent par, update Column J with the par amount awarded at auction. Cell M4 will show  total 10-year equivalents for Nominal Coupons and TIPS auctions between January and June 2025. \n\n10-year equivalent par is calculated by multiplying the par amount by the quotient of the modified duration of a security at auction by its 10-year benchmark security. The duration calculation uses end-of-day quotes and assumes the same settlement date as the auction for both securities. "]
["91282CMH1","2025-01-27","2025-01-31","2-Year","COUPONS",{"v":1.9002437282158313,"d":"1.90024"},"91282CLW9",{"v":7.834929910328909,"d":"7.83493"},0.24253,{"v":0,"d":"$0"}]
["91282CMK4","2025-01-28","2025-01-31","7-Year","COUPONS",{"v":5.970968713675382,"d":"5.97097"},"91282CLW9",{"v":7.8351772009125,"d":"7.83518"},0.76207,{"v":0,"d":"$0"}]
["91282CMN8","2025-02-11","2025-02-18","3-Year","COUPONS",{"v":2.7800125592571083,"d":"2.78001"},"91282CLW9",{"v":7.7861672208260035,"d":"7.78617"},0.35705,{"v":0,"d":"$0"}]
["91282CMM0","2025-02-12","2025-02-18","10-Year","COUPONS",{"v":7.9273310667536165,"d":"7.92733"},"91282CMM0",{"v":7.9273310667536165,"d":"7.92733"},1,{"v":0,"d":"$0"}]
["912810UG1","2025-02-13","2025-02-18","30-Year","COUPONS",{"v":16.00740452975181,"d":"16.00740"},"91282CLW9",{"v":7.786662824994797,"d":"7.78666"},2.05575,{"v":0,"d":"$0"}]
["912810UJ5","2025-02-19","2025-02-28","20-Year","COUPONS",{"v":12.756465449781475,"d":"12.75647"},"91282CMM0",{"v":7.910978569171321,"d":"7.91098"},1.6125,{"v":0,"d":"$0"}]
["912810UH9","2025-02-20","2025-02-28","30-Year","TIPS COUPONS",{"v":10.603679870460422,"d":"10.60368"},"91282CML2",{"v":4.414938353174283,"d":"4.41494"},2.40177,{"v":0,"d":"$0"}]
["91282CMP3","2025-02-24","2025-02-28","2-Year","COUPONS",{"v":1.9005507332772302,"d":"1.90055"},"91282CMM0",{"v":7.927584077294678,"d":"7.92758"},0.23974,{"v":0,"d":"$0"}]
["91282CGQ8","2025-02-25","2025-02-28","5-Year","COUPONS",{"v":4.487229050097284,"d":"4.48723"},"91282CMM0",{"v":7.940841829403456,"d":"7.94084"},0.56508,{"v":0,"d":"$0"}]
["91282CMR9","2025-02-26","2025-02-28","7-Year","COUPONS",{"v":6.02393076835959,"d":"6.02393"},"91282CMM0",{"v":7.94562510680865,"d":"7.94563"},0.75814,{"v":0,"d":"$0"}]
["91282CMS7","2025-03-11","2025-03-17","3-Year","COUPONS",{"v":2.8001839262294146,"d":"2.80018"},"91282CMM0",{"v":7.896728918845278,"d":"7.89673"},0.3546,{"v":0,"d":"$0"}]
["91282CMM0","2025-03-12","2025-03-17","10-Year","COUPONS",{"v":7.892645806608012,"d":"7.89265"},"91282CMM0",{"v":7.892645806608012,"d":"7.89265"},1,{"v":0,"d":"$0"}]
["912810UG1","2025-03-13","2025-03-17","30-Year","COUPONS",{"v":16.097376724350518,"d":"16.09738"},"91282CMM0",{"v":7.89816656033821,"d":"7.89817"},2.03812,{"v":0,"d":"$0"}]
["912810UJ5","2025-03-18","2025-03-31","20-Year","COUPONS",{"v":12.769461660847536,"d":"12.76946"},"91282CMM0",{"v":7.858535554853684,"d":"7.85854"},1.62492,{"v":0,"d":"$0"}]
["91282CML2","2025-03-20","2025-03-31","10-Year","TIPS COUPONS",{"v":4.382414756379658,"d":"4.38241"},"91282CML2",{"v":4.382414756379658,"d":"4.38241"},1,{"v":0,"d":"$0"}]
["91282CMV0","2025-03-25","2025-03-31","2-Year","COUPONS",{"v":1.9055713273358001,"d":"1.90557"},"91282CMM0",{"v":7.854685429733131,"d":"7.85469"},0.2426,{"v":0,"d":"$0"}]
["91282CMU2","2025-03-26","2025-03-31","5-Year","COUPONS",{"v":4.487811101904422,"d":"4.48781"},"91282CMM0",{"v":7.849854584222654,"d":"7.84985"},0.57171,{"v":0,"d":"$0"}]
["91282CMT5","2025-03-27","2025-03-31","7-Year","COUPONS",{"v":6.020954706197008,"d":"6.02095"},"91282CMM0",{"v":7.848885975351718,"d":"7.84889"},0.76711,{"v":0,"d":"$0"}]
["91282CMW8","2025-04-08","2025-04-15","3-Year","COUPONS",{"v":2.8122123299196287,"d":"2.81221"},"91282CMM0",{"v":7.816679026214133,"d":"7.81668"},0.35977,{"v":0,"d":"$0"}]
["91282CMM0","2025-04-09","2025-04-15","10-Year","COUPONS",{"v":7.811850135228572,"d":"7.81185"},"91282CMM0",{"v":7.811850135228572,"d":"7.81185"},1,{"v":0,"d":"$0"}]
["912810UG1","2025-04-10","2025-04-15","30-Year","COUPONS",{"v":15.695607679163784,"d":"15.69561"},"91282CMM0",{"v":7.800177595031267,"d":"7.80018"},2.01221,{"v":0,"d":"$0"}]
["912810UJ5","2025-04-16","2025-04-30","20-Year","COUPONS",{"v":12.607212929959399,"d":"12.60721"},"91282CMM0",{"v":7.778189599251496,"d":"7.77819"},1.62084,{"v":0,"d":"$0"}]
["91282CNB3","2025-04-17","2025-04-30","5-Year","TIPS COUPONS",{"v":2.3670849294124356,"d":"2.36708"},"91282CML2",{"v":4.335081669974795,"d":"4.33508"},0.54603,{"v":0,"d":"$0"}]
["91282CMY4","2025-04-22","2025-04-30","2-Year","COUPONS",{"v":1.9091849188951484,"d":"1.90918"},"91282CMM0",{"v":7.762664753349553,"d":"7.76266"},0.24594,{"v":0,"d":"$0"}]
["91282CMZ1","2025-04-23","2025-04-30","5-Year","COUPONS",{"v":4.501063342901392,"d":"4.50106"},"91282CMM0",{"v":7.765104310254591,"d":"7.76510"},0.57965,{"v":0,"d":"$0"}]
["91282CNA5","2025-04-24","2025-04-30","7-Year","COUPONS",{"v":6.046015101561468,"d":"6.04602"},"91282CMM0",{"v":7.773360490826872,"d":"7.77336"},0.77779,{"v":0,"d":"$0"}]
["91282CND9","2025-05-05","2025-05-15","3-Year","COUPONS",{"v":2.811766726181769,"d":"2.81177"},"91282CMM0",{"v":7.729290801736798,"d":"7.72929"},0.36378,{"v":0,"d":"$0"}]
["91282CNC1","2025-05-06","2025-05-15","10-Year","COUPONS",{"v":8.071273208960301,"d":"8.07127"},"91282CNC1",{"v":8.071273208960301,"d":"8.07127"},1,{"v":0,"d":"$0"}]
["912810UK2","2025-05-08","2025-05-15","30-Year","COUPONS",{"v":15.806248194132557,"d":"15.80625"},"91282CMM0",{"v":7.726125510089112,"d":"7.72613"},2.04582,{"v":0,"d":"$0"}]
["912810UL0","2025-05-21","2025-06-02","20-Year","COUPONS",{"v":12.44554585475888,"d":"12.44555"},"91282CNC1",{"v":7.987117191269504,"d":"7.98712"},1.5582,{"v":0,"d":"$0"}]
["91282CML2","2025-05-22","2025-05-30","10-Year","TIPS COUPONS",{"v":4.291780951550021,"d":"4.29178"},"91282CML2",{"v":4.291780951550021,"d":"4.29178"},1,{"v":0,"d":"$0"}]
["91282CNE7","2025-05-27","2025-06-02","2-Year","COUPONS",{"v":1.900518238302406,"d":"1.90052"},"91282CNC1",{"v":8.006255175066846,"d":"8.00626"},0.23738,{"v":0,"d":"$0"}]
["91282CNG2","2025-05-28","2025-06-02","5-Year","COUPONS",{"v":4.48408203726501,"d":"4.48408"},"91282CNC1",{"v":8.002111913165956,"d":"8.00211"},0.56036,{"v":0,"d":"$0"}]
["91282CNF4","2025-05-29","2025-06-02","7-Year","COUPONS",{"v":6.0168563594385915,"d":"6.01686"},"91282CNC1",{"v":8.009413204301662,"d":"8.00941"},0.75122,{"v":0,"d":"$0"}]
["91282CNH0","2025-06-10","2025-06-16","3-Year","COUPONS",{"v":2.8022523505158476,"d":"2.80225"},"91282CNC1",{"v":7.965813340425423,"d":"7.96581"},0.35178,{"v":0,"d":"$0"}]
["91282CNC1","2025-06-11","2025-06-16","10-Year","COUPONS",{"v":7.971905211657524,"d":"7.97191"},"91282CNC1",{"v":7.971905211657524,"d":"7.97191"},1,{"v":0,"d":"$0"}]
["912810UK2","2025-06-12","2025-06-16","30-Year","COUPONS",{"v":15.71460531084753,"d":"15.71461"},"91282CNC1",{"v":7.979413251141482,"d":"7.97941"},1.96939,{"v":0,"d":"$0"}]
["912810UL0","2025-06-16","2025-06-30","20-Year","COUPONS",{"v":12.448445837030862,"d":"12.44845"},"91282CNC1",{"v":7.93146680357861,"d":"7.93147"},1.5695,{"v":0,"d":"$0"}]
["91282CNB3","2025-06-17","2025-06-30","5-Year","TIPS COUPONS",{"v":2.2866877342403984,"d":"2.28669"},"91282CML2",{"v":4.256046931653593,"d":"4.25605"},0.53728,{"v":0,"d":"$0"}]
["91282CNL1","2025-06-24","2025-06-30","2-Year","COUPONS",{"v":1.9092256917898742,"d":"1.90923"},"91282CNC1",{"v":7.95010501435251,"d":"7.95011"},0.24015,{"v":0,"d":"$0"}]
["91282CNK3","2025-06-25","2025-06-30","5-Year","COUPONS",{"v":4.506703037057766,"d":"4.50670"},"91282CNC1",{"v":7.950584998024125,"d":"7.95058"},0.56684,{"v":0,"d":"$0"}]
["91282CNJ6","2025-06-26","2025-06-30","7-Year","COUPONS",{"v":6.053586391242653,"d":"6.05359"},"91282CNC1",{"v":7.956567399004547,"d":"7.95657"},0.76083,{"v":0,"d":"$0"}]