{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Fields & Descriptions - Simple ","Sample for Entry - Simple Store"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"1904"}

{"sheet":"Fields & Descriptions - Simple ","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,8],[2,1,2,8],[1,1,1,8],[3,0,3,8]]}
["WBFI Find-a-Retailer Widget Data Sheet"]
["Widget Description","On the landing page for the consumer campaign, we are including a way for people to find online and brick-and-mortar retail stores that are WBFI members and/or sell WBFI member products so we can push them to purchase as they're learning more about feeding wild birds. The widget will allow people to type in their zip code and it would populate a list and map of the surrounding retail stores that carry WBFI member products. It will also include a list of online retailers with ecommerce capabilities. "]
["Instructions","On the next tab, you will find the data entry form. Information on each field is below. Please not the following:\n1) If a retailer has multiple locations, please fill out a separate row for each separate location.\n2) The final column says \"WebStore.\" This is for any online retailer (e.g. Amazon.com) or stores that also have an e-commerce site to purchase products (e.g. HomeDepot.com). If they have this capability to sell online nationwide, please type \"TRUE\" in the \"WebStore\" column and any other information you have for the other columns that can be published (using the Amazon example, we would just need the Store Name, website, and WebStore marked \"TRUE\").\n3) They key pieces of information are the store name, address, and Webstore, everything else is optional but definitely nice to have. \n4) We will need the initial list filled out and sent back to us by December 13, 2020. \n5) Once complete, please send your filled out form to Cole Hinz: cole@nonprofitresources.us \n6) There will be opportunities to continually update this information by updating the spreadsheet and sending back to Cole."]
["Store Finder Content Model"]
["UniqueID","Unique identifier to be used for creating relationships and quick reference; We will generate","GUID","Leave Blank"]
["Store Name","Primary content for the listing in the store finder","Text (255 characters)"]
["Address","Required field for calculating proximity and adding any mapping functionality.","Text (255 characters)"]
["State","Required field for calculating proximity and adding any mapping functionality.","Text"]
["City","Required field for calculating proximity and adding any mapping functionality.","Text"]
["Zip","Required field for calculating proximity and adding any mapping functionality.","Numeric"]
["Country","Required field for calculating proximity and adding any mapping functionality.","Text"]
["Phone (optional)","Optional content to make the store finder more effective","Text","(xxx) xxx-xxxx"]
["Website (optional)","Optional content to make the store finder more effective","Text (255 characters)","www.URL.com"]
["Email (optional)","Optional content to make the store finder more effective","Text","[username]@[domain]"]
["Description (optional)","Optional content to make the store finder more effective","Text (255 characters)"]
["Lat (optional)","If available, this field may be used to simplify the proximity function. Joy Riot can calculate based on address, or this site can be used: https://www.latlong.net/convert-address-to-lat-long.html","Numeric"]
["Long (optional)","If available, this field may be used to simplify the proximity function. Joy Riot can calculate based on address, or this site can be used: https://www.latlong.net/convert-address-to-lat-long.html","Numeric"]
["WebStore","Flag to indicate if a store should be displayed as a part of the ‘perpetual’ web listing","Boolean","True | False"]

{"sheet":"Sample for Entry - Simple Store","index":1,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,13]]}
["Simple Store Finder Content Model"]
["UniqueID\n(JR to generate)","Store Name","Address","State","City","Zip","Country","Phone (optional)","Website (optional)","Email (optional)","Description (optional)","Lat (optional)","Long (optional)","WebStore"]
["SAMPLE","Joy Riot","950 N. Washington Street","VA","Alexandria",22314,"USA","(571) 549-1569","www.joyriotagency.com","hello@joyriotagency.com","(any information about them including who they are or what they carry)",null,null,true]