{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Codes","API Keys"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Instructions","index":0,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["INSTRUCTIONS"]
["Step 1 - In order to use this tool, you must obtain an Application programming interface (API) key from the FRED Website"]
["Step 1a - you must first set up a user account with FRED by going to https://research.stlouisfed.org/useraccount/register/step1"]
["step 1b - you must request an API Key by going to https://research.stlouisfed.org/useraccount/apikeys/"]
["You should be granted an API key immediately, but be sure to read the terms and conditions, and other legal documents"]
["Step 2 - Click on the \"Get Unemployment Rates\" button in the \"unemployment\" tab.  If you are a new user, you will be asked to enter your name and API Key and will be asked if you would like to be the default user "]
["Step 3 - Click on the \"Make Charts\" button in the \"Unemployment\" tab"]
["Step 4 - Open the PowerPoint presentation you would like to create the slides in"]
["Step 5 - Click on the \"Make Slides\" button in the \"Unemployment\" tab"]
["Step 6 (Optional) - you clear the charts by clicking on the \"Clear Data\" button"]
[]
[]
["Legal Disclaimer required by law: FRED Does not support or endorse this tool"]

{"sheet":"Codes","index":1,"n_rows":70,"n_cols":9,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Series ID","Name","Date","Unemployment Rate",null,"State Chart Data"]
["UNRATE","USA","<?xml version=",1,null,"Series ID","Name","Date","Rate"]
["ALUR","Alabama","<?xml version=",1,null,"UNRATE","USA","2014-03-01",6.6999998092651367]
["AKUR","Alaska","<?xml version=",1,null,"UTUR","Utah","2014-02-01",3.9000000953674316]
["AZUR","Arizona","<?xml version=",1,null,"NDUR","North Dakota","2014-02-01",2.5999999046325684]
["ARUR","Arkansas","<?xml version=",1,null,"RIUR","Rhode Island","2014-02-01",9]
["CAUR","California","<?xml version=",1,null,"PAUR","Pennsylvania","2014-02-01",6.1999998092651367]
["COUR","Colorado","<?xml version=",1]
["CTUR","Connecticut","<?xml version=",1,null,"UNRATE","USA","2014-03-01",6.6999998092651367]
["DEUR","Delaware","<?xml version=",1,null,"LNS14000001","Men","2014-03-01",6.8000001907348633]
["DCUR","District of Columbia","<?xml version=",1,null,"LNS14000002","Women","2014-03-01",6.5999999046325684]
["FLUR","Florida","<?xml version=",1,null,"LNS14000003","White","2014-03-01",5.8000001907348633]
["GAUR","Georgia","<?xml version=",1,null,"LNS14000006","African American","2014-03-01",12.399999618530273]
["IDUR","Idaho","<?xml version=",1,null,"LNS14000009","Hispanic or Latino","2014-03-01",7.9000000953674316]
["ILUR","Illinois","<?xml version=",1,null,"LNU04027660","High School Only ","2014-03-01",6.8000001907348633]
["INUR","Indiana","<?xml version=",1,null,"LNS14000012","16 to 19 years years old","2014-03-01",20.899999618530273]
["IAUR","Iowa","<?xml version=",1]
["KSUR","Kansas","<?xml version=",1,null,"UNRATE","USA","2014-03-01",6.6999998092651367]
["KYUR","Kentucky","<?xml version=",1,null,"LRUNTTTTBRM156S","Brazil","2013-12-01",5.1278443336486816]
["LAUR","Louisiana","<?xml version=",1,null,"LMUNRRTTCNQ156S","China","2011-07-01",4.0999999046325684]
["MEUR","Maine","<?xml version=",1,null,"LMUNRRTTRUM156S","Russia","2013-12-01",1.2101651430130005]
["MDUR","Maryland","<?xml version=",1]
["MAUR","Massachusetts","<?xml version=",1,null,"UNRATE","USA","2014-03-01",6.6999998092651367]
["MIUR","Michigan","<?xml version=",1,null,"LRHUTTTTEZM156S","Euro Area","2013-12-01",12]
["MNUR","Minnesota","<?xml version=",1,null,"PRTURHARMMDSMEI","Portugal","2012-04-01",15.199999809265137]
["MSUR","Mississippi","<?xml version=",1,null,"IRLURHARMMDSMEI","Ireland","2012-04-01",14.199999809265137]
["MOUR","Missouri","<?xml version=",1,null,"LRHUTTTTITM156S","Italy","2013-12-01",12.699999809265137]
["MTUR","Montana","<?xml version=",1,null,"LRHUTTTTDEM156S","Germany","2013-12-01",5.0999999046325684]
["NEUR","Nebraska","<?xml version=",1,null,"ESPURHARMMDSMEI","Spain","2012-04-01",24.299999237060547]
["NVUR","Nevada","<?xml version=",1,null,"GRCURHARMMDSMEI","Greece","2012-02-01",21.700000762939453]
["NHUR","New Hampshire","<?xml version=",1,null,"GBRURHARMMDSMEI","Great Britain","2012-02-01",8.1000003814697266]
["NJUR","New Jersey","<?xml version=",1]
["NMUR","New Mexico","<?xml version=",1]
["NYUR","New York","<?xml version=",1]
["NCUR","North Carolina","<?xml version=",1]
["NDUR","North Dakota","<?xml version=",1]
["OHUR","Ohio","<?xml version=",1]
["OKUR","Oklahoma","<?xml version=",1]
["ORUR","Oregon","<?xml version=",1]
["PAUR","Pennsylvania","<?xml version=",1]
["RIUR","Rhode Island","<?xml version=",1]
["SCUR","South Carolina","<?xml version=",1]
["SDUR","South Dakota","<?xml version=",1]
["TNUR","Tennessee","<?xml version=",1]
["TXUR","Texas","<?xml version=",1]
["UTUR","Utah","<?xml version=",1]
["VTUR","Vermont","<?xml version=",1]
["VAUR","Virginia","<?xml version=",1]
["WAUR","Washington","<?xml version=",1]
["WVUR","West Virginia","<?xml version=",1]
["WIUR","Wisconsin","<?xml version=",1]
["WYUR","Wyoming","<?xml version=",1]
["LNS14000001","Men","<?xml version=",1]
["LNS14000002","Women","<?xml version=",1]
["LNS14000003","White","<?xml version=",1]
["LNS14000006","African American","<?xml version=",1]
["LNS14000009","Hispanic or Latino","<?xml version=",1]
["LNU04027660","High School Only ","<?xml version=",1]
["LNS14000012","16 to 19 years years old","<?xml version=",1]
["LRUNTTTTBRM156S","Brazil","<?xml version=",1]
["LMUNRRTTCNQ156S","China","<?xml version=",1]
["LMUNRRTTRUM156S","Russia","<?xml version=",1]
["LRHUTTTTEZM156S","Euro Area","<?xml version=",1]
["PRTURHARMMDSMEI","Portugal","<?xml version=",1]
["IRLURHARMMDSMEI","Ireland","<?xml version=",1]
["LRHUTTTTITM156S","Italy","<?xml version=",1]
["LRHUTTTTDEM156S","Germany","<?xml version=",1]
["ESPURHARMMDSMEI","Spain","<?xml version=",1]
["GRCURHARMMDSMEI","Greece","<?xml version=",1]
["GBRURHARMMDSMEI","Great Britain","<?xml version=",1]

{"sheet":"API Keys","index":2,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["User Name","API Key","Default User","Default User API Key"]
["David Toronto","a0b8064b7769e54ae09ec232a07e7843","David Toronto","a0b8064b7769e54ae09ec232a07e7843"]
["Grant McQueen","a0b8064b7769e54ae09ec232a07e7843"]
["Mark Walker","a0b8064b7769e54ae09ec232a07e7843"]
["Nancy Toronto","a0b8064b7769e54ae09ec232a07e7843"]