{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Input","Cash & Tax Lot Input","Restrictions Input","Glossary","Disclosures","Reference Data (not seen by FA)","Version History","EUCT_Temp"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":11,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[27,7,27,10],[29,9,29,10],[23,2,23,5],[26,2,26,5],[31,9,31,10],[27,2,27,5],[25,2,25,5],[24,2,24,5],[49,1,49,5],[32,9,32,10],[28,7,28,8],[28,9,28,10],[33,9,33,10],[30,9,30,10],[31,7,31,8],[29,7,29,8],[36,2,36,5],[18,7,18,8],[18,9,18,10],[24,7,24,8],[25,9,25,10],[23,9,23,10],[19,7,20,10],[22,7,22,10],[25,7,25,8],[23,7,23,8],[9,2,9,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[15,2,15,5],[16,2,16,5],[19,2,19,5],[22,2,22,5]]}
[]
[]
[null,"Input"]
[]
[null,"INSTRUCTIONS"]
[null,"Please use this form to receive a transition analysis for a new account or to amend the guidelines for an existing account. "]
[null,"*Required field"]
[]
[null,"01  Basic Information"]
[null,"Client Name(s)*"]
[null,"Account Name*"]
[null,"Funding Source*","Choose one from list"]
[null,"Total Market Value (including cash)"]
[null,"Broker Dealer or Firm Name*"]
[null,"Group/Team Name"]
[null,"Advisor Name*"]
[null,"Advisor Email*"]
[]
[null,"02  Select Strategy",null,null,null,null,null,"PLATFORM AVAILABILITY "]
[null,"Strategy*","Choose one from list",null,null,null,null,"For questions about platform availability, please reach out to your sales specialist."]
[]
[null,"03  Special Instructions (Preferences)"]
[null,"State Preference Option","Choose one from list (default is National)",null,null,null,null,"STRATEGY DETAILS"]
[null,"Minimum Maturity [1]","Choose one from list",null,null,null,null,"MINIMUM CREDIT QUALITY",null,{"$f":"IFERROR(VLOOKUP(C20,'Reference Data (not seen by FA)'!C6:R39,3,FALSE),\"-\")","v":"  "}]
[null,"Maximum Maturity [1]","Choose one from list",null,null,null,null,"MAX MATURITY",null,{"$f":"IFERROR(VLOOKUP(C20,'Reference Data (not seen by FA)'!C6:R39,4,FALSE),\"-\")","v":"  "},{"$f":"IFERROR(IF(VLOOKUP(C20,'Reference Data (not seen by FA)'!C6:R39,5,FALSE)=\"N/A\", \"\", VLOOKUP(C20,'Reference Data (not seen by FA)'!C6:R39,5,FALSE)),\"\")","v":"  "}]
[null,"ESG Preference","Choose one from list",null,null,null,null,"NATIONAL/STATE OPTION",null,{"$f":"IFERROR(VLOOKUP(C20,'Reference Data (not seen by FA)'!C6:R39,2,FALSE),\"-\")","v":"  "}]
[null,"State Exclusions","Choose one or more from list"]
[null,"Sector Exclusions","Choose one or more from list",null,null,null,null,"CUSTOMIZATIONS ALLOWED"]
[null,"Credit Quality Special Instructions","Credit Quality","Include","Min (%)*","Max (%)*",null,"STATE PREFERENCE",null,{"$f":"IFERROR(VLOOKUP(C20,'Reference Data (not seen by FA)'!C6:U39,13,FALSE),\"-\")","v":"[Select Strategy]"}]
[null,null,"AAA","Y",0,100,null,"MATURITY[1]",null,{"$f":"IFERROR(VLOOKUP(C20,'Reference Data (not seen by FA)'!C6:U39,10,FALSE),\"-\")","v":"[Select Strategy]"}]
[null,null,"AA","Y",0,100,null,"ESG PREFERENCE",null,{"$f":"IFERROR(VLOOKUP(C20,'Reference Data (not seen by FA)'!C6:U39,16,FALSE),\"-\")","v":"[Select Strategy]"}]
[null,null,"A","Y",0,100,null,"STATE EXCLUSIONS",null,{"$f":"IFERROR(VLOOKUP(C20,'Reference Data (not seen by FA)'!C6:U39,14,FALSE),\"-\")","v":"[Select Strategy]"}]
[null,null,"BBB","N/A","N/A","N/A",null,"SECTOR EXCLUSIONS",null,{"$f":"IFERROR(VLOOKUP(C20,'Reference Data (not seen by FA)'!C6:U39,12,FALSE),\"-\")","v":"[Select Strategy]"}]
[null,null,"MIN (%) defaults to 0; MAX (%) defaults to 100",null,null,null,null,"CREDIT QUALITY",null,{"$f":"IFERROR(VLOOKUP(C20,'Reference Data (not seen by FA)'!C6:U39,11,FALSE),\"-\")","v":"[Select Strategy]"}]
[]
[null,"04  Client Tax Information (optional, but more information provides more accurate transition analysis and plan)"]
[null,"Tax State","Choose one from list"]
[null,"Short Term Tax Rate[2]","Enter"]
[null,"Long Term Tax Rate[2]","Enter"]
[null,"Max Realized Short-Term Gains Allowed (Current Tax Year)","Enter"]
[null,"Max Realized Long-Term Gains Allowed (Current Tax Year)","Enter"]
[null,"Years to Transition",1]
[null,"ST YTD Realized Gain[3]","Enter"]
[null,"ST YTD Realized Loss[3]","Enter"]
[null,"LT YTD Realized Gain[3]","Enter"]
[null,"LT YTD Realized Loss[3]","Enter"]
[null,"Carry Forward Losses[3]","Enter"]
[null,"Cash to Raise[3]","Enter"]
[]
[null,"[1] For customized maturity, either the maturity of total portfolio can be targeted (for example, maturity of the portfolio less than 3), or more commonly, client can specify parts of the ladder they want to exclude/include (example: 5-10 ladder instead of 1-10 ladder)."]
[null,"[2] All inclusive of federal, state, and local taxes. If not provided the highest federal tax rate will be used and no state tax rate included."]
[null,"[3] If not provided 0 will be used."]
[]
[null,"FOR INVESTMENT PROFESSIONAL USE ONLY"]

{"sheet":"Cash & Tax Lot Input","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,7,23,13]]}
[]
[]
[null,"Tax Lot Input"]
[null,null,null,null,null,null,null,"IMPORTANT  \n\nFor Fixed Income Strategies - \nAny zero coupon bonds,  matured/called bonds or securities of a different issue type than are held in the strategy will be treated as cash and invested toward the target model portfolio. The aforementioned bonds are assumed to be liquidated based on par value. Any potential realized gains/losses and tax cost/savings form the \"liquidated\" securities will not be reflected in the report. Allspring does not guarantee that securities received in-kind can be liquidated and reserves the right to reject securities during the in-kind transfer account funding process.  Please note, any bonds issued by Puerto Rico or Guam are removed from the proposal because we do not have the ability to transact in these securities.\n\nEquities, including individual stock, mutual funds, and ETFs, are assumed to be liquidated based on yesterday's close price and reinvested in the targeted strategy.\n\nFor Equity Strategies - \n\nUncovered securities, including but not limited to non-equity securities, ADRs and ORDs, non-equity ETFs, and Mutual Funds, will be disregarded from the analysis. Fractional shares of securities are assumed to be liquidated based on yesterday's close price and reinvested in the target strategy. Any potential realized gains/losses and tax cost/savings form the \"liquidated\" securities will not be reflected in the report. \n\nPlease enter in adjusted cost basis in USD."]
[null,"05  If funding includes cash enter total USD Cash Amount here"]
[]
[null,"Cash (USD) Amount"]
[]
[]
[null,"06   Enter Tax Lot Data"]
[]
[null,"CUSIP or TICKER","PURCHASE DATE","ADJUSTED COST BASIS (USD)","QUANTITY/UNITS"]

{"sheet":"Restrictions Input","index":2,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Restrictions Input"]
[]
[null,"07   Enter Account Restrictions  No restrictions? No problem, just move to the next step and submit to the SMA Customization Mailbox."]
[null,null,null,null,null,null,null,"When complete, please email this template to:  "]
[null,"CUSIP or TICKER","DON'T BUY","DON'T SELL","MINIMUM EXPOSURE","MAXIMUM EXPOSURE"]

{"sheet":"Glossary","index":3,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Glossary of terms"]
[]
[]
[null,"TERMS","DESCRIPTION"]
[null,"Bond Ladder Strategy","A bond ladder is an investment strategy that involves constructing a portfolio in which bonds mature continuously at equally spaced intervals. As the bonds closest to maturity expire, the investments are rolled over to the end."]
[null,"Tax Sensitivity","Client sensitivity to tax cost when transitioning:"]
[null,null,"HIGH: Highly sensitive to capital gains, minimize tax costs, high tracking error to model"]
[null,null,"MEDIUM: Medium sensitivity to tax costs, balance tas cost and tracking error, mid-level tracking error to model"]
[null,null,"LOW: Low tax sensitivity, high tax cost, and low error to model"]
[null,"Tax State","State where client pays taxes"]
[null,"Short Term Tax Rate (all inclusive)","Used to determine taxes for short-term gains"]
[null,"Long Term Tax Rate (all inclusive)","Used to determine taxes for long-term gains"]
[null,"Max Realized Gains Allowed","Allows gains to be restricted when modeling the transition portfolio"]
[null,"Years to Transition","Number of years before transitioning to lowest tracking error of the model"]
[null,"ST YTD Realized Gain/Loss","Realized ST YTD Gains/Losses—used in transition cost analysis"]
[null,"LT YTD Realized Gain/Loss","Realized LT YTD Gains/Losses—used in transition cost analysis"]
[null,"Carry Forward Losses","Any carry forward losses from prior years, used in transition cost analysis"]
[null,"Cash to Raise","Specified by client if there is a need to raise cash, used in transition plan"]
[null,"ESG Rating Buckets"]
[null,"AAA – AA","LEADER: A company leading its industry in managing the most significant ESG risk and opportunities"]
[null,"A – BBB – BB","AVERAGE: A company with a mixed or unexceptional track record of managing the most significant ESG risk and opportunities relative to industry peers"]
[null,"B – CCC","LAGGARD: A company lagging its industry biased on high exposure and managing the most significant ESG risk and opportunities"]

{"sheet":"Disclosures","index":4,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Disclosures"]
[]
[null,"MARKETING COMMUNICATION"]
[]
[null,"Investments in fixed-income securities are subject to market, interest rate, credit and other risks. Bond prices fluctuate inversely to changes in interest rates. Therefore, a general rise in interest rates can result in the decline in the bond’s price. Credit risk is the risk that an issuer will default on payments of interest and/or principal. This risk is heightened in lower rated bonds. If sold prior to maturity, fixed income securities are subject to market risk. All fixed income investments may be worth less than their original cost upon redemption or maturity.\n"]
[null,"This material has been prepared by Allspring Global Investments, LLC, a registered Investment Advisor, and the material is intended for use by investment professionals with their clients. This material is for general informational and educational purposes only and is NOT intended to provide investment advice or a recommendation of any kind — including a recommendation for any specific investment, strategy, or plan.\n"]
[null,"Allspring Global Investments™ is the trade name for the asset management firms of Allspring Global Investments Holdings, LLC, a holding company indirectly owned by certain private funds of GTCR LLC and Reverence Capital Partners, L.P. These firms include but are not limited to Allspring Global Investments, LLC, and Allspring Funds Management, LLC. Certain products managed by Allspring entities are distributed by Allspring Funds Distributor, LLC (a broker-dealer and Member FINRA/SIPC).\n"]
[null,"ALL-01202023-szjqyben"]

{"sheet":"Reference Data (not seen by FA)","index":5,"n_rows":57,"n_cols":41,"rows_kept":57,"cut":false,"hidden":true,"merged":[[3,7,3,8],[3,9,3,10],[3,11,3,20]]}
[]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,null,null,null,null,"Platform\nAvailability ",null,"Minimums ($)",null,"Customizations",null,null,null,null,null,null,null,null,null,"Tax Info"]
[null,null,"Strategy","Nat/State","Credit Quality","Max Maturity","Maturity Date Part","P-UMA","PAN","P-UMA","PAN","Maturity","Credit","Sector Exclusion","State Preference","State Exclusion","Yield","ESG Preference","GICS Industry Exclusion","Security Exclusions","ESG Screen Exclusion","Year to Transition",null,null,"TaxSensitivity","YearsToTransition","Tax State",null,"YesNo","AMT Bonds","Funding Source","ESG",null,"State Preference","State Exposure",null,null,"Sector Exposure"]
[null,null,"Choose one from list","  ","  ","  ","  "," "," "," "," ","[Select Strategy]","[Select Strategy]","[Select Strategy]","[Select Strategy]","[Select Strategy]","[Select Strategy]","[Select Strategy]","[Select Strategy]","[Select Strategy]","[Select Strategy]","[Select Strategy]",null,null,"N/A",1,"Choose one from list",null,"Choose one from list","N/A","Choose one from list","Choose one from list",null,"Choose one from list (default is National)","Alabama",2.098885E-2,{"$f":"AI6&\" (\"&TEXT(AJ6,\"0.00%\")&\")\"","v":"Alabama (2.10%)"},"Banking",0.310224952,{"$f":"AL6&\" (\"&TEXT(AM6,\"0.00%\")&\")\"","v":"Banking (31.02%)"},"Maturity Range"]
[null,null,"Municipal Bond Ladder 1-7 Year","National","A",7,"Years","N","Y","N/A","2.5mm","Y",{"$f":"IF(OR(Input!$C$23=\"National\", Input!$C$23=\"Choose one from list (default is National)\",Input!$C$23=\"N/A\"),\"Y\",\"N\")","v":"Y"},"N","Y","Y","N","N",null,null,null,"N",null,null,null,null,"AL"," Alabama","Y",null,"Cash Only","Leaders + Average excluding Laggards (AAA through A)",null,"National","Alaska",1.59523E-3,{"$f":"AI7&\" (\"&TEXT(AJ7,\"0.00%\")&\")\"","v":"Alaska (0.16%)"},"Basic Industry",2.2782604599999999E-2,{"$f":"AL7&\" (\"&TEXT(AM7,\"0.00%\")&\")\"","v":"Basic Industry (2.28%)"},"Choose one from list"]
[null,null,"Municipal Bond Ladder 1-7 Year California","State","A",7,"Years","N","Y","N/A","2.5mm","Y","N","N","N","N","N","N",null,null,null,"N",null,null,null,null,"AK"," Alaska","N",null,"Securities Only","Leaders + Average excluding Laggards (AAA through BBB)",null,"FL","Arizona",1.443586E-2,"Arizona (1.44%)","Brokerage/Asset Managers/Exchanges",1.7492083499999998E-2,"Brokerage/Asset Managers/Exchanges (1.75%)",1]
[null,null,"Municipal Bond Ladder 1-7 Year New York","State","A",7,"Years","N","Y","N/A","2.5mm","Y","N","N","N","N","N","N",null,null,null,"N",null,null,null,null,"AZ"," Arizona","N/A",null,"Cash and Securities","Leaders + Average excluding Laggards (AAA through BB)",null,"IL","Arkansas",9.4689000000000004E-4,"Arkansas (0.09%)","Capital Goods",5.4360960899999998E-2,"Capital Goods (5.44%)",2]
[null,null,"Municipal Bond Ladder 1-7 Year New Jersey","State","A",7,"Years","N","Y","N/A","2.5mm","Y","N","N","N","N","N","N",null,null,null,"N",null,null,null,null,"AR"," Arkansas"," ",null,null,"N/A",null,"MA","California",0.16825404999999999,"California (16.83%)","Cash",0,"Cash (0.00%)",3]
[null,null,"Municipal Bond Ladder 1-10 Year","National","A",10,"Years","Y","Y","150k","2.5mm","Y",{"$f":"IF(OR(Input!$C$23=\"National\", Input!$C$23=\"Choose one from list (default is National)\",Input!$C$23=\"N/A\"),\"Y\",\"N\")","v":"Y"},"N","Y","Y","N","N",null,null,null,"N",null,null,null,null,"CA"," California","YesNo",null,null,null,null,"PA","Colorado",2.0409940000000001E-2,"Colorado (2.04%)","Communications",6.70181834E-2,"Communications (6.70%)",4]
[null,null,"Municipal Bond Ladder 1-10 Year California","State","A",10,"Years","Y","Y","150k","2.5mm","Y","N","N","N","N","N","N",null,null,null,"N",null,null,null,null,"CO"," Colorado","Y",null,null,null,null,"TX","Connecticut",2.270486E-2,"Connecticut (2.27%)","Consumer Cyclical",7.3680074700000001E-2,"Consumer Cyclical (7.37%)",5]
[null,null,"Municipal Bond Ladder 1-10 Year New York","State","A",10,"Years","Y","Y","150k","2.5mm","Y","N","N","N","N","N","N",null,null,null,"N",null,null,null,null,"CT"," Connecticut","N",null,null,null,null,"WA","Delaware",3.7513799999999999E-3,"Delaware (0.38%)","Consumer Non Cyclical",0.1272602155,"Consumer Non Cyclical (12.73%)",6]
[null,null,"Municipal Bond Ladder 1-10 Year New Jersey","State","A",10,"Years","Y","Y","150k","2.5mm","Y","N","N","N","N","N","N",null,null,null,"N",null,null,null,null,"DE"," Delaware","N/A",null,null,null,null,"AZ","District of Columbia",1.28164E-2,"District of Columbia (1.28%)","Electric",6.0441342100000003E-2,"Electric (6.04%)",7]
[null,null,"Municipal Bond Ladder 1-20 Year","National","A",20,"Years","N","Y","N/A","2.5mm","Y",{"$f":"IF(OR(Input!$C$23=\"National\", Input!$C$23=\"Choose one from list (default is National)\",Input!$C$23=\"N/A\"),\"Y\",\"N\")","v":"Y"},"N","Y","Y","N","N",null,null,null,"N",null,null,null,null,"DC"," District of Columbia",null,null,null,null,null,"CO","Florida",3.2759299999999998E-2,"Florida (3.28%)","Energy",5.9705031899999997E-2,"Energy (5.97%)",8]
[null,null,"Municipal Bond Ladder 1-20 Year California","State","A",20,"Years","N","Y","N/A","2.5mm","Y","N","N","N","N","N","N",null,null,null,"N",null,null,null,null,"FL"," Florida",null,null,null,null,null,"CT","Georgia",2.8312859999999999E-2,"Georgia (2.83%)","Finance Companies",1.6657653299999998E-2,"Finance Companies (1.67%)",9]
[null,null,"Municipal Bond Ladder 1-20 Year New York","State","A",20,"Years","N","Y","N/A","2.5mm","Y","N","N","N","N","N","N",null,null,null,"N",null,null,null,null,"GA"," Georgia",null,null,null,null,null,"GA","Hawaii",8.8790699999999993E-3,"Hawaii (0.89%)","Financial Other",7.8169019999999999E-4,"Financial Other (0.08%)",10]
[null,null,"Municipal Bond Ladder 1-20 Year New Jersey","State","A",20,"Years","N","Y","N/A","2.5mm","Y","N","N","N","N","N","N",null,null,null,"N",null,null,null,null,"HI"," Hawaii",null,null,null,null,null,"MI","Idaho",7.1007999999999998E-4,"Idaho (0.07%)","Industrial Other",1.7472503E-3,"Industrial Other (0.17%)",11]
[null,null,"Corporate Bond Ladder 1-5 Year","N/A","BBB",5,"Years","N","Y","N","2.5mm","Y","Y","Y","N","N","N","Y",null,null,null,"N",null,null,null,null,"ID"," Idaho",null,null,null,null,null,"MN","Illinois",4.4199250000000002E-2,"Illinois (4.42%)","Insurance",3.71376374E-2,"Insurance (3.71%)",12]
[null,null,"Corporate Bond Ladder 1-10 Year","N/A","BBB",10,"Years","N","Y","N","2.5mm","Y","Y","Y","N","N","N","Y",null,null,null,"N",null,null,null,null,"IL"," Illinois",null,null,null,null,null,"MO","Indiana",8.4356699999999993E-3,"Indiana (0.84%)","Natural Gas",5.4956711000000002E-3,"Natural Gas (0.55%)",13]
[null,null,"Corporate Bond Non-Ladder","N/A","BBB",10,"Years","N","Y","N","2.5mm","Y","Y","Y","N","N","N","Y",null,null,null,"N",null,null,null,null,"IN"," Indiana",null,null,null,null,null,"MD","Iowa",2.38441E-3,"Iowa (0.24%)","REITS",3.4899447E-2,"REITS (3.49%)",14]
[null,null,"Treasury Bond Ladder 0-6 Month","National","AA",6,"Months","N","Y","N/A","2.5mm","Y","N","N","N","N","N","N",null,null,null,"N",null,null,null,null,"IA"," Iowa",null,null,null,null,null,"NC","Kansas",3.9565099999999999E-3,"Kansas (0.40%)","Technology",9.4767479000000002E-2,"Technology (9.48%)",15]
[null,null,"Treasury Bond Ladder 0-1 Year","National","AA",12,"Months","N","Y","N/A","2.5mm","Y","N","N","N","N","N","N",null,null,null,"N",null,null,null,null,"KS"," Kansas",null,null,null,null,null,"OH","Kentucky",1.094698E-2,"Kentucky (1.09%)","Transportation",1.4268152900000001E-2,"Transportation (1.43%)",16]
[null,null,"Treasury Bond Ladder 0-2 Year","National","AA",2,"Years","N","Y","N/A","2.5mm","Y","N","N","N","N","N","N",null,null,null,"N",null,null,null,null,"KY"," Kentucky",null,null,null,null,null,"OR","Louisiana",1.1014309999999999E-2,"Louisiana (1.10%)","Utility Other",1.2795702999999999E-3,"Utility Other (0.13%)",17]
[null,null,"Treasury Bond Ladder 1-5 Year","National","AA",5,"Years","N","Y","N/A","2.5mm","Y","N","N","N","N","N","N",null,null,null,"N",null,null,null,null,"LA"," Louisiana",null,null,null,null,null,"VA","Maine",1.0931300000000001E-3,"Maine (0.11%)",null,null,null,18]
[null,null,"Treasury Bond Ladder 1-10 Year","National","AA",10,"Years","N","Y","N/A","2.5mm","Y","N","N","N","N","N","N",null,null,null,"N",null,null,null,null,"ME"," Maine",null,null,null,null,null,"UT","Maryland",2.87034E-2,"Maryland (2.87%)",null,null,null,19]
[null,null,"Large Core","N/A","N/A","N/A","N/A",null,null,null,null,"N","N","N","N","N","N","N",null,null,null,"Y",null,null,null,null,"MD"," Maryland",null,null,null,null,null,"N/A","Massachusetts",3.3143609999999997E-2,"Massachusetts (3.31%)",null,null,null,20]
[null,null,"SMArt Large Core 500 (S&P 500)","N/A","N/A","N/A","N/A",null,null,null,null,"N","N","N","N","N","N","N",null,null,null,"Y",null,null,null,null,"MA"," Massachusetts",null,null,null,null,null,null,"Michigan",1.428196E-2,"Michigan (1.43%)",null,null,null,"N/A"]
[null,null,"SMArt Large Blend 1000 (Russell 1000)","N/A","N/A","N/A","N/A",null,null,null,null,"N","N","N","N","N","N","N",null,null,null,"Y",null,null,null,null,"MI"," Michigan",null,null,null,null,null,null,"Minnesota",1.232166E-2,"Minnesota (1.23%)"]
[null,null,"SMArt Large Growth 1000 (Russell 1000G)","N/A","N/A","N/A","N/A",null,null,null,null,"N","N","N","N","N","N","N",null,null,null,"Y",null,null,null,null,"MN"," Minnesota",null,null,null,null,null,null,"Mississippi",3.3157099999999999E-3,"Mississippi (0.33%)"]
[null,null,"SMArt Large Value 1000 (Russell 1000V)","N/A","N/A","N/A","N/A",null,null,null,null,"N","N","N","N","N","N","N",null,null,null,"Y",null,null,null,null,"MS"," Mississippi",null,null,null,null,null,null,"Missouri",7.6640900000000001E-3,"Missouri (0.77%)"]
[null,null,"SMArt Large Core 500 ESG-Screened (S&P 500)","N/A","N/A","N/A","N/A",null,null,null,null,"N","N","N","N","N","N","N",null,null,null,"Y",null,null,null,null,"MO"," Missouri",null,null,null,null,null,null,"Montana",3.6849000000000002E-4,"Montana (0.04%)"]
[null,null,"SMArt All Cap 3000 (Russell 3000)","N/A","N/A","N/A","N/A",null,null,null,null,"N","N","N","N","N","N","N",null,null,null,"Y",null,null,null,null,"MT"," Montana",null,null,null,null,null,null,"Nebraska",5.5701500000000003E-3,"Nebraska (0.56%)"]
[null,null,"SMArt International Core","N/A","N/A","N/A","N/A",null,null,null,null,"N","N","N","N","N","N","N",null,null,null,"Y",null,null,null,null,"NE"," Nebraska",null,null,null,null,null,null,"Nevada",9.0849499999999996E-3,"Nevada (0.91%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NV"," Nevada",null,null,null,null,null,null,"New Hampshire",3.8487999999999999E-4,"New Hampshire (0.04%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NH"," New Hampshire",null,null,null,null,null,null,"New Jersey",3.8224649999999999E-2,"New Jersey (3.82%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NJ"," New Jersey",null,null,null,null,null,null,"New Mexico",5.78328E-3,"New Mexico (0.58%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NM"," New Mexico",null,null,null,null,null,null,"New York",0.13630286,"New York (13.63%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NY"," New York",null,null,null,null,null,null,"North Carolina",1.6491510000000001E-2,"North Carolina (1.65%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NC"," North Carolina",null,null,null,null,null,null,"North Dakota",4.1566999999999998E-4,"North Dakota (0.04%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ND"," North Dakota",null,null,null,null,null,null,"Ohio",2.5555350000000001E-2,"Ohio (2.56%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OH"," Ohio",null,null,null,null,null,null,"Oklahoma",3.6044100000000002E-3,"Oklahoma (0.36%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OK"," Oklahoma",null,null,null,null,null,null,"Oregon",9.9467900000000005E-3,"Oregon (0.99%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR"," Oregon",null,null,null,null,null,null,"Pennsylvania",3.4422880000000003E-2,"Pennsylvania (3.44%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PA"," Pennsylvania",null,null,null,null,null,null,"Rhode Island",1.6895600000000001E-3,"Rhode Island (0.17%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RI"," Rhode Island",null,null,null,null,null,null,"South Carolina",8.8227800000000006E-3,"South Carolina (0.88%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SC"," South Carolina",null,null,null,null,null,null,"South Dakota",5.3023999999999996E-4,"South Dakota (0.05%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SD"," South Dakota",null,null,null,null,null,null,"Tennessee",1.2851929999999999E-2,"Tennessee (1.29%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TN"," Tennessee",null,null,null,null,null,null,"Texas",9.2775399999999994E-2,"Texas (9.28%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TX"," Texas",null,null,null,null,null,null,"Utah",6.30717E-3,"Utah (0.63%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UT"," Utah",null,null,null,null,null,null,"Vermont",2.836E-5,"Vermont (0.00%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VT"," Vermont",null,null,null,null,null,null,"Virginia",2.1582460000000001E-2,"Virginia (2.16%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA"," Virginia",null,null,null,null,null,null,"Washington",3.3991239999999999E-2,"Washington (3.40%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA"," Washington",null,null,null,null,null,null,"West Virginia",1.7641899999999999E-3,"West Virginia (0.18%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WV"," West Virginia",null,null,null,null,null,null,"Wisconsin",1.3240429999999999E-2,"Wisconsin (1.32%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WI"," Wisconsin",null,null,null,null,null,null,"Wyoming",2.6035000000000001E-4,"Wyoming (0.03%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WY"," Wyoming"]

{"sheet":"Version History","index":6,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
["Version History"]
["Version","Date","Description"]
[]
["v5.0.2","2024-05-09","Added SMArt International Core"]
["v5.0.1","2023-11-13","Added SMArt All Cap 3000 (Russell 3000), removed US territories from State Specific list, fixed bug in req field check "]
["v5.0.0","2023-08-15","Steve Talmage:  Major enhancement removing freeform fields and replacing with list seletions.  New Special Instructions fields added for EQ DI strategies - GICS Industry Grp & ESG Screens exclusions.  New tax field added:  Max Realized Long-Term Gains Allowed. "]
["v4.1.05","2023-06-28","Jen Wong updated disclaimer on Cash & Tax Lot Input tab"]
["v4.1.04","2023-06-21","Steve Talmage:  Minor Big Fixes on State Exclusion"]
["v4.1.03","2023-02-10","Commented out State Exclusion validation - unhandled exception prevented email object creation. "]
["v4.1.02","2023-01-23","Added State Exposure to Special Instructions"]
["Generic v1.1","2022-09-08","Rename Firm to free form editable field named Broker-Dealer or Firm Name, removed platform availability and minimums – replaced with generic text"]
["v3.0.7","2022-06-27","Added two Ultra Short Treasury strategies.  On Restrictions tab, re-enabled Restrict Sell"]
["v3.0.6","2022-05-26","Reskinned version, includes updates from Jen Wong to switch the credit customization to N for preference states is missing"]
["v3.0.5",null,"Credit Quality SI enhancements to capture in grid on Input tab"]
["v3.0.4",null,"Added Treasury Bond Ladder Short and Intermediate Strategies"]
["v3.0.3","2022-02-17","Updated ESG Preference Options - added Leaders + Average excluding Laggards (AAA through A) and Leaders + Average excluding Laggards (AAA through BBB) "]
["v3.0.2","2022-02-02","Removed “Leaders Only (AAA & AA)” from ESG Preferences "]

{"sheet":"EUCT_Temp","index":7,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["File Name"]
["Remi_SMA_Questionnaire_Input_V2.xlsm"]