{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Topics","Spreadsheet Models","FC VC Analysis","Calcualte Revenue","Shipping Costs"],"not_rendered":{"charts":0,"images":2,"macros":0,"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":"Topics","index":0,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Good Spreadsheet Model Design"]
["Model 01: FC/VC Example"]
["Build Formula Input Area and Model area separately"]
["Goal Seek"]
["Data Tables"]
["Chart"]
["Model 02: Calculate Total Revenue from Transactional Data and Lookup Tables"]
["SUM, VLOOKUP, COUNTIFS, SUMPRODUCT and LOOKUP functions."]
["Model 03: Calculate Total Shipping Costs"]
["MIN, INDEX, MATCH, IF functions."]

{"sheet":"Spreadsheet Models","index":1,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Good Spreadsheet Model Building:"]
["1) Excel’s Golden Rule: If formula input (parameter, assumption, variable) can change put it in a cell and"]
["refer to it in the formula with a cell reference."]
["2) Label all formula inputs."]
["3) Separate the formula input area from the model area."]
["4) Model is where you create your formulas and where you can put your decision variable."]
["5) Label all elements in the model area."]
["6) Use appropriate Number & Stylistic Formatting to make the spreadsheet easy to understand."]
["Remember: Number Formatting is a Facade."]
["7) Keep default alignments to visually portray the data type (Numbers to the right, Text to the left)"]
["8) Name all sheets and files smartly."]
["9) Sometimes it is helpful to create math formulas or a influence diagram to describe your model."]

{"sheet":"FC VC Analysis","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Calcualte Revenue","index":3,"n_rows":179,"n_cols":17,"rows_kept":179,"cut":false,"hidden":false,"merged":[]}
["A company that sells rolls of fence needs to calculate total revenue from a list of customer transactions and a pricing table."]
["Given the transactional data table with the number of rolls of fence sold for each transaction and the pricing table,"]
["calculate total revenue and count the number of transactions that fell into each pricing category."]
[]
["Data set with number of rolls of fence sold for each transaction:",null,null,null,null,null,null,null,"Pricing Table:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOOKUP to get Price:"]
["Date","Number of Rolls",null,null,null,null,null,null,"Units From","Units To","Price per Roll (100 feet)",null,null,null,null,null,{"$f":"LOOKUP(B8,$I$8:$K$11)","v":168}]
["2015-09-16",540,null,null,null,null,null,null,0,143,198,null,null,null,null,null,168]
["2015-09-15",360,null,null,null,null,null,null,144,288,187,null,null,null,null,null,198]
["2015-09-16",12,null,null,null,null,null,null,289,577,168,null,null,null,null,null,168]
["2015-09-15",468,null,null,null,null,null,null,578,"and up",152,null,null,null,null,null,198]
["2015-09-17",48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-18",84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",540,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",492,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-18",204,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",408,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",780,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",444,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",432,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",456,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",768,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",528,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",624,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",372,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",588,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",504,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",504,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",660,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",468,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",492,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-18",204,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",168,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-17",84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",588,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",240,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",696,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",360,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",264,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(B40,$I$8:$K$11)","v":152}]
["2015-09-15",612,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",792,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-18",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",324,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",324,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",588,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",492,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",804,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",540,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",468,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",624,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",396,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-15",36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",384,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-15",132,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",312,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",492,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",516,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",744,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",240,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",252,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",768,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",468,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",720,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",804,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",192,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",732,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",216,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",648,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",432,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",384,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",144,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(B72,$I$8:$K$11)","v":152}]
["2015-09-18",684,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",216,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",480,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",384,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-15",84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",756,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",744,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",576,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",408,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",420,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-16",240,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-17",96,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",348,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",420,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-18",132,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",516,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",576,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-18",288,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",492,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",636,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",348,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",168,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",264,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",216,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",648,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",288,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",684,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",168,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",756,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",648,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(B104,$I$8:$K$11)","v":152}]
["2015-09-15",696,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",456,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",696,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",252,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",732,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-18",132,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",744,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",732,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",312,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-18",288,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-17",108,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",540,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",648,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-16",156,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-18",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-16",216,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",660,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-18",168,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",624,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-15",72,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",444,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",204,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",576,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-18",84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-18",108,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-16",228,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",408,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",516,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",804,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",696,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-16",264,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",396,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(B136,$I$8:$K$11)","v":152}]
["2015-09-15",780,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-17",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",432,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",216,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",768,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",204,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",540,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",804,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-16",132,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",804,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",168,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-15",96,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",588,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",384,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",456,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-17",24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",684,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",384,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",192,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",684,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-16",288,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",432,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",648,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",324,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-16",24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",552,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",168,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",744,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",228,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",636,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(B168,$I$8:$K$11)","v":168}]
["2015-09-16",312,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-16",36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",492,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",660,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",756,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-18",288,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",408,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",384,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",612,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",432,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",300]

{"sheet":"Shipping Costs","index":4,"n_rows":77,"n_cols":8,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["A Compressor Sales Company has four shipping centers. It delevers the compressors to customers by truck. The per mile shipping charge is $3.11 with a minimum charge of $75."]
["For each customer, determine which Shipping Center has the shortest distance and then calculate the total shipping charge for each customer transaction."]
[]
[null,null,null,null,"Seattle, Washington","Milwaukee, Wisconsin","Birmingham, Alabama","Oakland, California"]
["Customer List of Destination Zip Codes for current transactions:",null,null,null,"Shipping Center Source Zip Code with Miles from Shipping Center to Destination:"]
[]
["City","State","Zip Code",null,"98108","53203","35203","94612"]
["Chandler","Arizona","85225",null,1447,1830,1686,766]
["Glendale","Arizona","85302",null,1405,1870,1715,744]
["Mesa","Arizona","85201",null,1440,1816,1702,758]
["Scottsdale","Arizona","85251",null,1435,1818,1706,754]
["Little Rock","Arkansas","72202",null,2277,743,373,1955]
["Antioch","California","94509",null,796,2146,2299,36]
["Berkeley","California","94704",null,795,2165,2319,4]
["Chula Vista","California","91910",null,1258,2124,1996,499]
["Concord","California","94520",null,785,2155,2319,25]
["Daly City","California","94015",null,813,2183,2329,21]
["Fairfield","California","94533",null,759,2129,2339,41]
["Hayward","California","94544",null,816,2186,2306,20]
["Huntington Beach","California","92647",null,1162,2063,2034,404]
["Long Beach","California","90802",null,1156,2071,2042,398]
["Modesto","California","95350",null,822,2158,2248,82]
["Santa Clara","California","95050",null,834,2204,2290,44]
["Sunnyvale","California","94086",null,835,2205,2293,44]
["Thousand Oaks","California","91362",null,1143,2092,2062,385]
["Vallejo","California","94590",null,773,2143,2328,25]
["Aurora","Colorado","80017",null,1332,1045,1318,1260]
["Colorado Springs","Colorado","80903",null,1388,1114,1312,1316]
["Denver","Colorado","80202",null,1318,1043,1328,1246]
["Chicago","Illinois","60607",null,2067,93,663,2124]
["Joliet","Illinois","60436",null,2052,126,671,2099]
["Evansville","Indiana","47708",null,2254,387,343,2214]
["Fort Wayne","Indiana","46802",null,2233,262,597,2269]
["Cedar Rapids","Iowa","52401",null,1832,244,782,1919]
["Kansas City","Kansas","66106",null,1842,576,695,1802]
["Topeka","Kansas","66603",null,1848,630,748,1776]
["Lexington-Fayette","Kentucky","40511",null,2406,468,411,2383]
["Louisville-Jefferson County5","Kentucky","40231",null,2340,401,363,2317]
["New Orleans","Louisiana","70113",null,2617,1016,344,2265]
["Baltimore","Maryland","21202",null,2771,800,781,2808]
["Ann Arbor","Michigan","48104",null,2314,343,710,2351]
["Detroit","Michigan","48233",null,2352,381,722,2389]
["St. Paul","Minnesota","55109",null,1668,332,1069,1970]
["Kansas City","Missouri","64108",null,1840,569,688,1800]
["St. Louis","Missouri","63155",null,2089,375,500,2050]
["Omaha","Nebraska","68108",null,1659,508,869,1661]
["Henderson","Nevada","89015",null,1145,1806,1799,568]
["Reno","Nevada","89510",null,738,1964,2267,256]
["Manchester","New Hampshire","03103",null,3087,1116,1214,3124]
["Elizabeth","New Jersey","07208",null,2857,886,950,2894]
["Jersey City","New Jersey","07302",null,2860,889,959,2896]
["Newark","New Jersey","07102",null,2852,881,952,2889]
["New York","New York","10199",null,2863,892,964,2900]
["Yonkers","New York","10701",null,2873,902,980,2910]
["Cary","North Carolina","27511",null,2876,905,543,2829]
["Durham","North Carolina","27701",null,2856,885,531,2808]
["Cincinnati","Ohio","45225",null,2327,389,468,2374]
["Cleveland","Ohio","44101",null,2417,446,712,2453]
["Norman","Oklahoma","73019",null,2007,892,705,1639]
["Tulsa","Oklahoma","74107",null,2000,773,639,1718]
["Eugene","Oregon","97401",null,278,2173,2494,523]
["Portland","Oregon","97208",null,168,2065,2480,629]
["Philadelphia","Pennsylvania","19104",null,2832,861,878,2869]
["Pittsburgh","Pennsylvania","15290",null,2535,564,753,2572]
["Providence","Rhode Island","02904",null,3046,1075,1153,3083]
["Columbia","South Carolina","29201",null,2835,903,362,2678]
["Sioux Falls","South Dakota","57104",null,1478,497,1053,1727]
["Clarksville","Tennessee","37043",null,2359,561,232,2294]
["Killeen","Texas","76541",null,2091,1156,741,1744]
["Laredo","Texas","78041",null,2219,1432,978,1780]
["Mesquite","Texas","75149",null,2123,1052,629,1734]
["Alexandria","Virginia","22314",null,2781,811,746,2818]
["Hampton","Virginia","23607",null,2945,974,716,2950]
["Seattle","Washington","98108",null,0,1995,2525,796]
["Spokane","Washington","99201",null,282,1714,2244,864]
["Green Bay","Wisconsin","54303",null,1934,121,878,2224]
["Madison","Wisconsin","53714",null,1927,74,811,2091]