{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["AR Detail","Instructions"],"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":"AR Detail","index":0,"n_rows":518,"n_cols":11,"rows_kept":518,"cut":false,"hidden":false,"merged":[]}
["Date","Transaction Type","Num","Status","RT Status","Client","Due Date","Days Late","Amount","Open Balance","Notes"]
["03/07/2013","Check",null,"Paid",null,"779 WZ Properties","03/07/2013",{"$f":"TODAY()-G2","v":644},{"$f":"RANDBETWEEN(1,100)","v":28},{"$f":"RANDBETWEEN(1,100)","v":51},"Hi"]
["05/23/2013","Credit Card Expense",null,"Paid",null,"779 WZ Properties","05/23/2013",{"$f":"TODAY()-G3","v":567},{"$f":"RANDBETWEEN(1,100)","v":51},9,1]
["05/01/2013","Invoice","RT169","Paid","Completed","138 Heber City","05/31/2013",559,55,40,2]
["06/10/2013","Payment"," 03968C","Paid",null,"430 dirt dawgs","06/10/2013",549,30,51,3]
["05/13/2013","Invoice","RT325","Paid","Contract sent","2 Rocky Mountain West Telecom","06/12/2013",547,24,13,4]
["06/12/2013","Payment"," 09468C","Paid",null,"430 dirt dawgs","06/12/2013",547,67,3,44]
["05/18/2013","Invoice","RT406","Paid","Completed","294 Moonlight Construction","06/17/2013",542,45,51]
["05/23/2013","Invoice","RT458","Paid","Completed","319 Marshal Mcfarland","06/22/2013",537,83,72,32]
["05/28/2013","Invoice","RT634","Need to Contact","Contract sent","157 Wasatch County Parks and Rec ATTN Tom Bonner","06/27/2013",532,3,80,2]
["05/31/2013","Invoice","RT520","Need to Contact","Completed","319 Marshal Mcfarland","06/30/2013",529,62,90,3]
["06/15/2013","Invoice","RT577","Need to Contact","Contract sent","157 Wasatch County Parks and Rec ATTN Tom Bonner","07/15/2013",514,58,59,1]
["06/20/2013","Invoice","RT756","Over Paid","Completed","456 John Gallagher","07/20/2013",509,90,44,431]
["06/20/2013","Invoice","RT865","Over Paid","Contract sent","484 Kelly  Walker","07/20/2013",509,61,65,2]
["07/02/2013","Invoice","RT859","Over Paid","Completed","296 rick mecham costruction","08/01/2013",497,13,20,321]
["07/02/2013","Invoice","RT853","Over Paid","Completed","296 rick mecham costruction","08/01/2013",497,83,88,3]
["07/10/2013","Invoice","RT916","Over Paid","Contract sent","138 Heber City","08/09/2013",489,34,54,43]
["07/15/2013","Invoice",1053,"Over Paid",null,"578 Heber City Public Works","08/14/2013",484,28,98,4]
["08/14/2013","Journal Entry",229,"Over Paid",null,"321 Shane Cox","08/14/2013",484,67,76,23]
["07/27/2013","Invoice","RT1105",null,"Cancelled","589 Cornelio Garcia","08/26/2013",472,55,2]
["08/04/2013","Invoice","RT1148","Over Paid","Contract sent","653 Ed Kren","09/03/2013",464,31,97,12]
["08/09/2013","Invoice","RT1249","Over Paid","Completed","589 Cornelio Garcia","09/08/2013",459,62,51,3]
["08/10/2013","Invoice","RT1250","Over Paid","Completed","589 Cornelio Garcia","09/09/2013",458,31,26,123]
["09/13/2013","Journal Entry",220,"Over Paid",null,"2 Rocky Mountain West Telecom","09/13/2013",454,77,49,12]
["09/15/2013","Credit Card Expense",null,"Over Paid",null,"484 Kelly  Walker","09/15/2013",452,38,1,312]
["09/16/2013","Check",1155,"Over Paid",null,"484 Kelly  Walker","09/16/2013",451,86,18,3123]
["08/19/2013","Invoice","RT1366","Over Paid","Completed","372 Elias  Granado","09/18/2013",449,82,13]
["08/20/2013","Invoice","RT1375",null,"Contract sent","372 Elias  Granado","09/19/2013",448,94,32]
["08/20/2013","Invoice","RT1340",null,"Completed","643 Brad Probst","09/19/2013",448,45,89]
["09/19/2013","Invoice","RT1429",null,"Completed","776 Joseph  Naciongayo","09/19/2013",448,53,31]
["08/21/2013","Invoice","RT1393",null,"Contract sent","757 Paulsen Fence","09/20/2013",447,65,5]
["09/20/2013","Invoice","RT1627",null,"Cancelled","2 Rocky Mountain West Telecom","09/20/2013",447,46,50]
["09/25/2013","Credit Card Expense",null,null,null,"321 Shane Cox","09/25/2013",442,48,51,"wow"]
["08/27/2013","Invoice","RT1395",null,"Contract sent","759 Andy Berry","09/26/2013",441,77,52]
["08/29/2013","Invoice",1064,null,null,"2 Rocky Mountain West Telecom","09/28/2013",439,50,37]
["08/30/2013","Invoice","RT1473",null,"Contract sent","2 Rocky Mountain West Telecom","09/29/2013",438,8,4]
["08/31/2013","Invoice","RT1513",null,"Contract sent","43 Jody Chadwick","09/30/2013",437,31,76]
["09/04/2013","Invoice","RT1532",null,"Contract sent","653 Ed Kren","10/04/2013",433,44,59]
["09/13/2013","Invoice","RT1635",null,"Completed","96 Robert Benson","10/13/2013",424,65,7]
["09/13/2013","Invoice","RT1646",null,"Completed","857 Ron Eastin","10/13/2013",424,55,6]
["09/18/2013","Invoice","RT1665",null,"Contract sent","591 Chris Black","10/18/2013",419,91,33]
["09/19/2013","Invoice","RT1712",null,"Contract sent","886 Beck construction","10/19/2013",418,48,25]
["09/21/2013","Invoice","RT1741",null,"Completed","899 Dee Jones","10/21/2013",416,32,11]
["09/21/2013","Invoice","RT1692",null,"Contract sent","321 Shane Cox","10/21/2013",416,25,61]
["09/24/2013","Invoice","RT1780",null,"Contract sent","371 Kimball Property Maintenance","10/24/2013",413,9,48]
["09/26/2013","Invoice","RT1738",null,"Completed","338 Morgan Urcanbrack","10/26/2013",411,72,66]
["09/26/2013","Invoice","RT1782",null,"Contract sent","356 Pinetop Landscaping","10/26/2013",411,10,67]
["09/28/2013","Invoice","RT1836",null,"Completed","944 BK Williams","10/28/2013",409,7,32]
["10/05/2013","Invoice","RT1925",null,"Completed","493 bryan Arnold","11/04/2013",402,97,94]
["10/05/2013","Invoice","RT1929",null,"Contract sent","321 Shane Cox","11/04/2013",402,88,26]
["10/10/2013","Invoice","RT1967",null,"Contract sent","321 Shane Cox","11/09/2013",397,35,100]
["10/12/2013","Invoice","RT1970",null,"Completed","684 Lava Corp","11/11/2013",395,29,78]
["10/15/2013","Invoice","RT2035",null,"Contract sent","321 Shane Cox","11/14/2013",392,70,32]
["10/17/2013","Invoice","RT2062",null,"Cancelled","589 Cornelio Garcia","11/16/2013",390,38,59]
["10/21/2013","Invoice","RT2117",null,"Contract sent","321 Shane Cox","11/20/2013",386,98,45]
["10/25/2013","Invoice","RT2180",null,"Contract sent","1066 John Shibonis","11/24/2013",382,16,68]
["10/25/2013","Invoice","RT2165",null,"Completed","356 Pinetop Landscaping","11/24/2013",382,49,24]
["10/25/2013","Invoice","RT2178",null,"Contract sent","321 Shane Cox","11/24/2013",382,4,100]
["10/25/2013","Invoice","RT2177",null,"Contract sent","321 Shane Cox","11/24/2013",382,5,96]
["10/26/2013","Invoice","RT2126",null,"Cancelled","91 Jolley Electric","11/25/2013",381,78,38]
["10/29/2013","Invoice","RT2208",null,"Completed","294 Moonlight Construction","11/28/2013",378,14,28]
["11/01/2013","Invoice","RT2324",null,"Contract sent","321 Shane Cox","12/01/2013",375,47,27]
["11/01/2013","Invoice","RT2255",null,"Completed","749 Aspen Ridge Development","12/01/2013",375,44,16]
["11/01/2013","Invoice","RT2233",null,"Completed","749 Aspen Ridge Development","12/01/2013",375,94,95]
["11/01/2013","Invoice","RT2256",null,"Contract sent","321 Shane Cox","12/01/2013",375,16,15]
["12/02/2013","Payment"," 052812",null,null,"589 Cornelio Garcia","12/02/2013",374,26,6]
["11/08/2013","Invoice","RT2307",null,"Contract sent","749 Aspen Ridge Development","12/08/2013",{"$f":"TODAY()-G67","v":368},{"$f":"RANDBETWEEN(1,100)","v":7},49]
["11/09/2013","Invoice","RT2302",null,"Contract sent","321 Shane Cox","12/09/2013",367,60,90,"this"]
["12/09/2013","Invoice","RT2536",null,"Completed","1182 Steve Tozier","12/09/2013",367,40,26]
["11/12/2013","Invoice","RT2354",null,"Completed","493 bryan Arnold","12/12/2013",364,32,80]
["11/16/2013","Invoice","RT2399",null,"Contract sent","321 Shane Cox","12/16/2013",360,62,78]
["11/19/2013","Invoice","RT2410",null,"Completed","1156 Volvo Rents","12/19/2013",357,67,51]
["12/23/2013","Check",1286,null,null,"779 WZ Properties","12/23/2013",353,63,85,"is"]
["11/25/2013","Invoice","RT2466",null,"Completed","294 Moonlight Construction","12/25/2013",351,21,93,"coool"]
["12/31/2013","Payment",null,null,null,"Karen  Ellis","12/31/2013",345,86,41]
["12/31/2013","Credit Card Expense",null,"Paid",null,"779 WZ Properties","12/31/2013",345,61,51,1]
["01/01/2014","Journal Entry",371,null,null,"321 Shane Cox","01/01/2014",344,4,60]
["01/01/2014","Credit Memo","CM2241",null,null,"91 Jolley Electric","01/01/2014",344,17,97]
["01/01/2014","Journal Entry",393,null,null,"2 Rocky Mountain West Telecom","01/01/2014",344,59,15]
["01/02/2014","Payment"," 002993",null,null,"Unknown Customer","01/02/2014",343,73,15]
["01/03/2014","Payment"," 003559",null,null,"Unknown Customer","01/03/2014",342,85,78]
["01/05/2014","Credit Card Expense",null,"Paid",null,"779 WZ Properties","01/05/2014",340,51,60,1]
["12/09/2013","Invoice","RT2542",null,"Completed","294 Moonlight Construction","01/08/2014",337,64,75]
["01/08/2014","Payment"," 06224Z",null,null,"Unknown Customer","01/08/2014",337,96,3]
["01/09/2014","Credit Card Expense",null,"Paid",null,"779 WZ Properties","01/09/2014",336,41,13,1]
["12/11/2013","Invoice","RT2574",null,"Completed","294 Moonlight Construction","01/10/2014",335,85,18]
["12/12/2013","Invoice","RT2565",null,"Completed","294 Moonlight Construction","01/11/2014",334,15,65]
["01/11/2014","Payment"," 000518",null,null,"Unknown Customer","01/11/2014",334,12,35]
["01/11/2014","Payment"," 02269J",null,null,"Unknown Customer","01/11/2014",334,57,59]
["12/13/2013","Invoice","RT2581",null,"Contract sent","1216 Legends Bar and Grill","01/12/2014",333,78,94]
["01/15/2014","Payment",805795,null,null,"Unknown Customer","01/15/2014",330,87,5]
["01/15/2014","Payment"," 898556",null,null,"Unknown Customer","01/15/2014",330,25,43]
["12/20/2013","Invoice","RT2616",null,"Completed","1204 Park City School District","01/19/2014",326,4,74]
["01/20/2014","Invoice","RT2715",null,"Completed","646 Brian  fleck","01/20/2014",325,33,72]
["01/21/2014","Credit Card Expense",null,"Paid",null,"779 WZ Properties","01/21/2014",324,31,38,1]
["12/24/2013","Invoice","RT2789",null,"Contract sent","1250 Snowplow Customer","01/23/2014",322,11,20]
["01/23/2014","Invoice","RT2721",null,"Contract sent","830 Heber City Public Works","01/23/2014",322,31,47]
["01/24/2014","Payment"," 799076",null,null,"Unknown Customer","01/24/2014",321,83,50]
["12/27/2013","Invoice","RT2639",null,"Completed","294 Moonlight Construction","01/26/2014",319,59,31]
["01/27/2014","Payment",90259,null,null,"Unknown Customer","01/27/2014",318,50,23]
["01/27/2014","Payment",2525,null,null,"Unknown Customer","01/27/2014",318,22,6]
["01/27/2014","Invoice","RT2756",null,"Contract sent","830 Heber City Public Works","01/27/2014",318,88,93]
["01/01/2014","Invoice","RT5450",null,"Contract sent","2165 Neal  Clegg","01/31/2014",314,91,11]
["02/03/2014","Check",1367,null,null,"484 Kelly  Walker","02/03/2014",311,69,11]
["02/13/2014","Invoice","RT2840",null,"Completed","493 bryan Arnold","02/13/2014",301,39,15]
["02/17/2014","Payment",92752,null,null,"Unknown Customer","02/17/2014",297,8,89]
["02/20/2014","Payment",528082,null,null,"Unknown Customer","02/20/2014",294,75,24]
["02/20/2014","Invoice","RT2814",null,"Completed","294 Moonlight Construction","02/20/2014",294,17,33]
["02/20/2014","Invoice","RT2817",null,"Completed","294 Moonlight Construction","02/20/2014",294,59,68]
["02/20/2014","Invoice","RT2819",null,"Completed","294 Moonlight Construction","02/20/2014",294,77,13]
["01/22/2014","Invoice","RT2834",null,"Completed","1262 Tyler Fowkes","02/21/2014",293,64,29]
["02/21/2014","Payment",21509,null,null,"Unknown Customer","02/21/2014",293,89,26]
["02/24/2014","Payment","1614FF",null,null,"Unknown Customer","02/24/2014",290,2,58]
["02/24/2014","Payment",452793,null,null,"Unknown Customer","02/24/2014",290,81,87]
["02/26/2014","Payment",63326,null,null,"Unknown Customer","02/26/2014",288,4,51]
["02/26/2014","Payment",26159,null,null,"Unknown Customer","02/26/2014",288,69,61]
["02/26/2014","Invoice","RT2911",null,"Completed","654 Pro Build","02/26/2014",288,41,2]
["01/29/2014","Invoice","RT2742",null,"Contract sent","91 Jolley Electric","02/28/2014",286,61,66]
["02/28/2014","Invoice","RT2886",null,"Completed","1023 Diamond Vault Construction","02/28/2014",286,32,64]
["02/28/2014","Invoice","RT2892",null,"Contract sent","1046 Bob Kelez","02/28/2014",286,20,2]
["02/28/2014","Invoice","RT2905",null,"Contract sent","908 Seth  Lloyd","02/28/2014",286,56,80]
["02/28/2014","Invoice","RT2908",null,"Completed","1023 Diamond Vault Construction","02/28/2014",286,6,86]
["02/28/2014","Invoice","RT2900",null,"Completed","485 Kurtis Pyrah","02/28/2014",286,24,97]
["02/28/2014","Invoice","RT2932",null,"Contract sent","1250 Snowplow Customer","02/28/2014",286,65,59]
["01/31/2014","Invoice","RT2822",null,"Contract sent","1250 Snowplow Customer","03/02/2014",284,54,27]
["03/05/2014","Payment","02719J",null,null,"379 Jorgason Builders","03/05/2014",281,52,4]
["03/06/2014","Check",6744,null,null,"779 WZ Properties","03/06/2014",280,75,66]
["03/11/2014","Invoice","RT2951",null,"Cancelled","1284 Toney Trinnaman","03/11/2014",275,57,37]
["03/12/2014","Payment","6061FF",null,null,"Unknown Customer","03/12/2014",274,74,93]
["03/12/2014","Payment",528012,null,null,"Unknown Customer","03/12/2014",274,8,27]
["03/15/2014","Invoice","RT2988",null,"Completed","1309 Woody Linton","03/15/2014",{"$f":"TODAY()-G131","v":271},{"$f":"RANDBETWEEN(1,100)","v":62},95]
["03/15/2014","Invoice","RT3019",null,"Completed","1310 Super Daves","03/15/2014",271,72,15]
["03/18/2014","Invoice","RT3036",null,"Completed","367 Wasatch Back Property Management","03/18/2014",268,30,4]
["03/22/2014","Payment",723920,null,null,"Unknown Customer","03/22/2014",264,100,29]
["03/22/2014","Payment","02216R",null,null,"Unknown Customer","03/22/2014",264,46,39]
["03/25/2014","Payment","Zwick",null,null,"Unknown Customer","03/25/2014",261,38,91]
["03/25/2014","Payment","North",null,null,"Unknown Customer","03/25/2014",261,49,85]
["03/31/2014","Invoice","RT3110",null,"Contract sent","509 Kimbail Roofing","03/31/2014",255,40,23]
["03/31/2014","Invoice","RT2956",null,"Contract sent","1040 Preston Broadhead","03/31/2014",255,57,64]
["03/31/2014","Invoice","RT3065",null,"Contract sent","932 CH Properties","03/31/2014",255,20,73]
["03/31/2014","Invoice","RT3161",null,"Contract sent","1250 Snowplow Customer","03/31/2014",255,63,97]
["03/31/2014","Invoice","RT3138",null,"Contract sent","1322 Rock Canyon Oil","03/31/2014",255,83,48]
["03/31/2014","Invoice","RT3093",null,"Contract sent","589 Cornelio Garcia","03/31/2014",255,17,96]
["03/31/2014","Invoice","RT2996",null,"Contract sent","1165 Cracar Construction","03/31/2014",255,10,95]
["03/31/2014","Invoice","RT3089",null,"Contract sent","509 Kimbail Roofing","03/31/2014",255,88,89]
["03/31/2014","Invoice","RT3111",null,"Completed","1165 Cracar Construction","03/31/2014",255,9,22]
["03/31/2014","Invoice","RT3132",null,"Completed","1165 Cracar Construction","03/31/2014",255,41,56]
["03/31/2014","Invoice","RT2965",null,"Contract sent","1165 Cracar Construction","03/31/2014",255,89,66]
["03/31/2014","Journal Entry",312,null,null,"1165 Cracar Construction","03/31/2014",255,28,87]
["03/31/2014","Invoice","RT3042",null,"Contract sent","1165 Cracar Construction","03/31/2014",255,73,55]
["03/31/2014","Invoice","RT3035",null,"Completed","1165 Cracar Construction","03/31/2014",255,39,94]
["04/01/2014","Payment",35831,null,null,"55 Ryan  Simpson","04/01/2014",254,28,13]
["04/07/2014","Invoice","RT3211",null,"Completed","366 Josa  unda","04/07/2014",248,55,8]
["04/10/2014","Payment",334477,null,null,"1346 Ryan  Brown","04/10/2014",245,52,53]
["04/10/2014","Journal Entry",337,null,null,"15 Brian Myers","04/10/2014",245,24,12]
["04/25/2014","Payment",2543,null,null,"233 Mounteer Enterprise","04/25/2014",230,50,17]
["04/25/2014","Payment",21395,null,null,"139 Wasatch County School District","04/25/2014",230,76,95]
["04/25/2014","Payment",44551,null,null,"1498 Brett Robinson","04/25/2014",230,94,34]
["04/26/2014","Payment",166364,null,null,"1233 Propane Sales","04/26/2014",229,3,43]
["04/29/2014","Payment",188571,null,null,"157 Wasatch County Parks and Rec ATTN Tom Bonner","04/29/2014",226,28,71]
["04/01/2014","Invoice","RT3173",null,"Completed","1165 Cracar Construction","05/01/2014",224,57,40]
["04/02/2014","Invoice","RT3183",null,"Contract sent","830 Heber City Public Works","05/02/2014",223,60,1]
["04/02/2014","Invoice","RT3188",null,"Completed","1165 Cracar Construction","05/02/2014",223,90,36]
["05/02/2014","Payment",433130,null,null,"736 Cles Pace","05/02/2014",223,25,52]
["04/03/2014","Invoice","RT3190",null,"Completed","1165 Cracar Construction","05/03/2014",222,84,68]
["04/04/2014","Invoice","RT3205",null,"Completed","1165 Cracar Construction","05/04/2014",221,79,26]
["04/05/2014","Invoice","RT3210",null,"Contract sent","509 Kimbail Roofing","05/05/2014",220,99,71]
["04/05/2014","Invoice","RT3199",null,"Contract sent","509 Kimbail Roofing","05/05/2014",220,13,97]
["04/07/2014","Invoice","RT3231",null,"Contract sent","1165 Cracar Construction","05/07/2014",218,65,92]
["05/07/2014","Invoice","RT3636",null,"Contract sent","589 Cornelio Garcia","05/07/2014",218,69,58]
["04/12/2014","Invoice","RT3278",null,"Contract sent","509 Kimbail Roofing","05/12/2014",213,66,42]
["04/16/2014","Invoice","RT3349",null,"Contract sent","830 Heber City Public Works","05/16/2014",209,21,9]
["04/16/2014","Invoice","RT3340",null,"Completed","1146 Watts Enterprises","05/16/2014",209,36,27]
["04/17/2014","Invoice","RT3362",null,"Contract sent","1165 Cracar Construction","05/17/2014",208,35,51]
["04/18/2014","Invoice","RT3355",null,"Contract sent","1329 Ever Last Construction","05/18/2014",207,51,14]
["04/18/2014","Invoice","RT3409",null,"Contract sent","589 Cornelio Garcia","05/18/2014",207,50,63]
["04/19/2014","Invoice","RT3414",null,"Completed","646 Brian  fleck","05/19/2014",206,15,10]
["04/19/2014","Invoice","RT3377",null,"Contract sent","509 Kimbail Roofing","05/19/2014",206,77,50]
["05/19/2014","Invoice","RT3829",null,"Completed","75 Brandon Willson","05/19/2014",206,82,79]
["05/20/2014","Journal Entry",374,null,null,"Workhorse Construction","05/20/2014",205,41,76]
["04/21/2014","Invoice","RT3444",null,"Contract sent","589 Cornelio Garcia","05/21/2014",204,7,67]
["04/25/2014","Invoice","RT3522",null,"Contract sent","1046 Bob Kelez","05/25/2014",200,76,3]
["04/25/2014","Invoice","RT3499",null,"Completed","233 Mounteer Enterprise","05/25/2014",200,30,19]
["04/25/2014","Invoice","RT3484",null,"Contract sent","589 Cornelio Garcia","05/25/2014",200,77,44]
["04/28/2014","Invoice","RT3521",null,"Completed","1146 Watts Enterprises","05/28/2014",197,44,16]
["05/29/2014","Invoice","RT3800",null,"Completed","1512 JB Cummings","05/29/2014",196,77,35]
["05/29/2014","Invoice","RT3952",null,"Completed","567 Brandon Russall","05/29/2014",196,89,96]
["04/30/2014","Invoice","RT3567",null,"Cancelled","830 Heber City Public Works","05/30/2014",195,98,30]
["05/06/2014","Invoice","RT3656",null,"Contract sent","2 Rocky Mountain West Telecom","06/05/2014",189,17,47]
["06/05/2014","Payment",21757,null,null,"139 Wasatch County School District","06/05/2014",189,64,49]
["05/09/2014","Invoice","RT3690",null,"Contract sent","1040 Preston Broadhead","06/08/2014",186,55,24]
["05/09/2014","Invoice","RT3694",null,"Completed","1570 Chase Wright","06/08/2014",186,99,98]
["05/09/2014","Invoice","RT3801",null,"Contract sent","589 Cornelio Garcia","06/08/2014",186,74,80]
["06/09/2014","Invoice","RT4069",null,"Contract sent","536 Luke Willson","06/09/2014",185,86,86]
["06/09/2014","Invoice","RT3990",null,"Contract sent","1698 Bryan Jorgenson","06/09/2014",{"$f":"TODAY()-G195","v":185},{"$f":"RANDBETWEEN(1,100)","v":82},47]
["05/12/2014","Invoice","RT3728",null,"Completed","1146 Watts Enterprises","06/11/2014",183,31,63]
["05/13/2014","Invoice","RT3749",null,"Contract sent","1595 Altitude Equipment Rental","06/12/2014",182,56,62]
["06/12/2014","Payment",81017,null,null,"1819 chipian construction","06/12/2014",182,90,10]
["05/17/2014","Invoice","RT3844",null,"Contract sent","482 Shane D Olson","06/16/2014",178,40,91]
["05/19/2014","Invoice","RT3862",null,"Contract sent","372 Elias  Granado","06/18/2014",176,59,12]
["05/21/2014","Invoice","RT3887",null,"Contract sent","157 Wasatch County Parks and Rec ATTN Tom Bonner","06/20/2014",174,62,24]
["06/26/2014","Invoice","RT4080",null,"Completed","339 Joy Williams","06/26/2014",168,90,51]
["06/26/2014","Invoice","RT4149",null,"Contract sent","1766 Robert ahpoin","06/26/2014",168,49,48]
["06/26/2014","Invoice","RT4355",null,"Completed","372 Elias  Granado","06/26/2014",168,48,21]
["06/26/2014","Invoice","RT4465",null,"Contract sent","1861 devon Mrs calls","06/26/2014",168,29,34]
["06/26/2014","Invoice","RT4403",null,"Completed","175 Shane Cluff","06/26/2014",168,57,64]
["06/26/2014","Invoice","RT4242",null,"Cancelled","963 Alisha Richardson","06/26/2014",168,53,91]
["06/26/2014","Invoice","RT4353",null,"Completed","372 Elias  Granado","06/26/2014",168,5,2]
["06/26/2014","Invoice","RT4294",null,"Contract sent","255 Peter Mcdermott","06/26/2014",168,16,58]
["06/26/2014","Invoice","RT4236",null,"Contract sent","60 Greylight Construction","06/26/2014",168,61,2]
["06/26/2014","Invoice","RT4143",null,"Completed","1568 Allison Andrews","06/26/2014",168,47,10]
["06/26/2014","Invoice","RT4267",null,"Contract sent","372 Elias  Granado","06/26/2014",168,26,22]
["06/26/2014","Invoice","RT4402",null,"Contract sent","836 Lorin Fotheringham","06/26/2014",168,4,100]
["06/26/2014","Invoice","RT4175",null,"Completed","1568 Allison Andrews","06/26/2014",168,82,33]
["06/26/2014","Invoice","RT4286",null,"Contract sent","1046 Bob Kelez","06/26/2014",168,96,98]
["06/26/2014","Invoice","RT4266",null,"Contract sent","371 Kimball Property Maintenance","06/26/2014",168,38,12]
["06/26/2014","Invoice","RT4182",null,"Contract sent","91 Jolley Electric","06/26/2014",168,97,70]
["06/26/2014","Invoice","RT4292",null,"Contract sent","372 Elias  Granado","06/26/2014",168,28,46]
["05/30/2014","Invoice","RT4041",null,"Completed","96 Robert Benson","06/29/2014",165,57,11]
["05/31/2014","Invoice","FC514",null,null,"1165 Cracar Construction","06/30/2014",164,97,88]
["06/30/2014","Invoice","RT4518",null,"Cancelled","184 Ted Mcmauns","06/30/2014",164,57,61]
["06/30/2014","Invoice","RT4556",null,"Contract sent","1890 edward  vozar","06/30/2014",164,57,30]
["06/30/2014","Invoice","RT4569",null,"Completed","233 Mounteer Enterprise","06/30/2014",164,32,77]
["06/30/2014","Invoice","RT4552",null,"Completed","370 Ben Pearson","06/30/2014",164,74,54]
["06/30/2014","Invoice","RT4232",null,"Contract sent","1255 Log Craft","06/30/2014",164,6,80]
["06/30/2014","Journal Entry",341,null,null,"188 PCS Landscaping","06/30/2014",164,12,47]
["06/10/2014","Invoice","RT4254",null,"Completed","1806 All Things Included Handyman","07/10/2014",154,25,57]
["06/14/2014","Invoice","RT4280",null,"Completed","1811 Teranc pohl","07/14/2014",150,86,26]
["07/14/2014","Payment",40222,null,null,"294 Moonlight Construction","07/14/2014",150,94,44]
["06/18/2014","Invoice","RT4825",null,"Completed","188 PCS Landscaping","07/18/2014",146,44,88]
["07/24/2014","Invoice","RT4636",null,"Completed","248 Jason Lively","07/24/2014",140,73,77]
["06/30/2014","Invoice","FC614",null,null,"1165 Cracar Construction","07/30/2014",134,34,56]
["07/31/2014","Payment",25385,null,null,"2015 Sandrra schramm","07/31/2014",133,71,29]
["07/03/2014","Invoice","RT4549",null,"Contract sent","1266 Chase  S.","08/02/2014",131,69,44]
["07/07/2014","Invoice","RT4673",null,"Contract sent","1322 Rock Canyon Oil","08/06/2014",127,77,47]
["07/07/2014","Invoice","RT4678",null,"Completed","319 Marshal Mcfarland","08/06/2014",127,77,15]
["07/08/2014","Invoice","RT4682",null,"Completed","1090 Heber Light  Power","08/07/2014",126,58,28]
["07/09/2014","Invoice","RT4696",null,"Contract sent","1941 Chris  Smith","08/08/2014",125,63,75]
["07/10/2014","Invoice","RT4712",null,"Contract sent","1282 Mountain West Trailers","08/09/2014",124,8,72]
["07/12/2014","Invoice","RT4741",null,"Completed","1233 Propane Sales","08/11/2014",122,49,18]
["07/15/2014","Invoice","RT4789",null,"Contract sent","1890 edward  vozar","08/14/2014",119,18,49]
["08/15/2014","Invoice","RT5169",null,"Contract sent","564 BTM","08/15/2014",118,40,91]
["08/15/2014","Invoice","RT5035",null,"Contract sent","971 Marc Barcomb","08/15/2014",118,4,22]
["08/15/2014","Invoice","RT5137",null,"Contract sent","61 Center Creek Construction","08/15/2014",118,53,44]
["08/15/2014","Invoice","RT5039",null,"Completed","2013 Diane Swensen","08/15/2014",118,1,62]
["08/15/2014","Invoice","RT5102",null,"Cancelled","2060 Tyler Malnerich","08/15/2014",118,12,36]
["08/15/2014","Invoice","RT5166",null,"Completed","1090 Heber Light  Power","08/15/2014",118,87,38]
["08/15/2014","Invoice","RT5024",null,"Contract sent","2033 Ms Kall CAndy Kandy","08/15/2014",118,91,54]
["08/15/2014","Invoice","RT5145",null,"Contract sent","441 Surge Electric","08/15/2014",118,55,93]
["08/15/2014","Invoice","RT4909",null,"Contract sent","1994 Darrel Larsen","08/15/2014",118,49,65]
["08/15/2014","Check","NSF",null,null,"192 Placedo Vasquez","08/15/2014",118,15,96]
["08/15/2014","Invoice","RT5114",null,"Contract sent","233 Mounteer Enterprise","08/15/2014",118,79,8]
["08/15/2014","Invoice","RT4965",null,"Contract sent","138 Heber City","08/15/2014",118,91,6]
["08/15/2014","Invoice","RT5010",null,"Contract sent","248 Jason Lively","08/15/2014",118,25,43]
["08/15/2014","Invoice","RT5059",null,"Contract sent","1055 Neal Bowlen","08/15/2014",118,55,57]
["08/15/2014","Invoice","RT5147",null,"Contract sent","619 Custom Rustick","08/15/2014",118,11,66]
["08/15/2014","Invoice","RT5128",null,"Contract sent","441 Surge Electric","08/15/2014",118,66,73]
["08/15/2014","Invoice","RT5068",null,"Contract sent","2050 Justin Crail","08/15/2014",118,5,32]
["08/15/2014","Invoice","RT5034",null,"Completed","296 rick mecham costruction","08/15/2014",{"$f":"TODAY()-G259","v":118},{"$f":"RANDBETWEEN(1,100)","v":79},27]
["08/15/2014","Invoice","RT5108",null,"Contract sent","356 Pinetop Landscaping","08/15/2014",118,31,90]
["08/15/2014","Invoice","RT5116",null,"Contract sent","188 PCS Landscaping","08/15/2014",118,30,97]
["08/15/2014","Invoice","RT5129",null,"Contract sent","233 Mounteer Enterprise","08/15/2014",118,88,43]
["08/15/2014","Invoice","RT4973",null,"Contract sent","157 Wasatch County Parks and Rec ATTN Tom Bonner","08/15/2014",118,81,80]
["08/15/2014","Invoice","RT5029",null,"Contract sent","720 Mountain Valley Landscape","08/15/2014",118,72,43]
["08/15/2014","Invoice","RT5054",null,"Contract sent","188 PCS Landscaping","08/15/2014",118,5,52]
["08/15/2014","Invoice","RT5103",null,"Contract sent","356 Pinetop Landscaping","08/15/2014",118,13,10]
["08/15/2014","Invoice","RT5115",null,"Contract sent","188 PCS Landscaping","08/15/2014",118,28,5]
["07/17/2014","Invoice","RT4815",null,"Contract sent","188 PCS Landscaping","08/16/2014",117,41,96]
["07/18/2014","Invoice","RT4837",null,"Contract sent","1975 Hughes General contractors","08/17/2014",116,89,72]
["08/19/2014","Payment","00263G",null,null,"1144 prime development","08/19/2014",114,69,85]
["08/21/2014","Payment",21712,null,null,"1909 Blake  Davis","08/21/2014",112,98,32]
["07/23/2014","Invoice","RT4888",null,"Contract sent","604 Scott Peirce","08/22/2014",111,85,2]
["07/23/2014","Invoice","RT4881",null,"Contract sent","188 PCS Landscaping","08/22/2014",111,86,37]
["07/23/2014","Invoice","RT4836",null,"Contract sent","1255 Log Craft","08/22/2014",111,32,86]
["08/22/2014","Payment","02003J",null,null,"508 Grade tech services","08/22/2014",111,62,21]
["07/25/2014","Invoice","RT4927",null,"Contract sent","157 Wasatch County Parks and Rec ATTN Tom Bonner","08/24/2014",109,97,95]
["07/25/2014","Invoice","RT4901",null,"Contract sent","1071 Kevin Winterose","08/24/2014",109,80,72]
["07/25/2014","Invoice","RT4926",null,"Contract sent","1233 Propane Sales","08/24/2014",109,25,52]
["07/25/2014","Invoice","RT4921",null,"Contract sent","1109 Jake  Jorgenson","08/24/2014",109,5,62]
["07/25/2014","Invoice","RT4913",null,"Completed","1998 Miguel Carrano","08/24/2014",109,7,55]
["07/25/2014","Invoice","RT4902",null,"Contract sent","1992 R  M Pools","08/24/2014",109,46,61]
["07/26/2014","Invoice","RT4688",null,"Contract sent","157 Wasatch County Parks and Rec ATTN Tom Bonner","08/25/2014",108,28,62]
["08/26/2014","Invoice","RT4703",null,"Completed","252 Strong Property Management","08/26/2014",107,76,40]
["08/26/2014","Invoice","RT5267",null,"Contract sent","1228 Emily Jhonson","08/26/2014",107,2,49]
["08/26/2014","Invoice","RT4704",null,"Completed","277 Ray Ohm","08/26/2014",107,25,47]
["08/26/2014","Invoice","RT5262",null,"Contract sent","816 Monteer   Hmp","08/26/2014",107,38,13]
["08/26/2014","Invoice","RT4702",null,"Completed","338 Morgan Urcanbrack","08/26/2014",107,99,78]
["08/26/2014","Invoice","RT5228",null,"Contract sent","1209 kirk Sulser","08/26/2014",107,82,76]
["08/26/2014","Invoice","RT5149",null,"Contract sent","1645 JaCie Butters","08/26/2014",107,52,57]
["08/26/2014","Invoice","RT5243",null,"Contract sent","1282 Mountain West Trailers","08/26/2014",107,14,20]
["08/26/2014","Invoice","RT5285",null,"Contract sent","733 Bess construction Jim","08/26/2014",107,59,43]
["08/26/2014","Invoice","RT5268",null,"Contract sent","746 Cody bethers","08/26/2014",107,95,44]
["08/26/2014","Invoice","RT5272",null,"Contract sent","564 BTM","08/26/2014",107,98,38]
["08/26/2014","Invoice","RT5150",null,"Contract sent","1863 Elvin Worthington","08/26/2014",107,90,29]
["08/26/2014","Invoice","RT5209",null,"Contract sent","233 Mounteer Enterprise","08/26/2014",107,19,67]
["08/26/2014","Invoice","RT5283",null,"Contract sent","619 Custom Rustick","08/26/2014",107,81,98]
["08/26/2014","Invoice","RT5275",null,"Contract sent","189 Lone Peak Sprinkler and Landscape","08/26/2014",107,49,24]
["08/26/2014","Invoice","RT4997",null,"Contract sent","188 PCS Landscaping","08/26/2014",107,89,26]
["07/28/2014","Invoice","RT4715",null,"Contract sent","157 Wasatch County Parks and Rec ATTN Tom Bonner","08/27/2014",106,11,97]
["07/28/2014","Invoice","RT4934",null,"Contract sent","2005 Brent Patterson","08/27/2014",106,38,93]
["07/28/2014","Invoice","RT4858",null,"Contract sent","1349 Jordanell Special Service","08/27/2014",106,86,39]
["08/27/2014","Payment",82342,null,null,"1099 Park City landscape","08/27/2014",106,11,33]
["08/28/2014","Payment","03289G",null,null,"1920 SR mechanical","08/28/2014",105,6,16]
["08/28/2014","Payment",190493,null,null,"Unknown Customer","08/28/2014",105,47,18]
["07/30/2014","Invoice","RT4856",null,"Contract sent","830 Heber City Public Works","08/29/2014",104,67,36]
["07/30/2014","Invoice","RT4952",null,"Contract sent","1890 edward  vozar","08/29/2014",104,99,94]
["07/30/2014","Invoice","RT4955",null,"Completed","1219 Lacy Jenkins","08/29/2014",104,87,28]
["07/31/2014","Invoice","RT4948",null,"Contract sent","1255 Log Craft","08/30/2014",103,27,68]
["07/31/2014","Invoice","FC714",null,null,"1165 Cracar Construction","08/30/2014",103,15,97]
["07/31/2014","Invoice","RT5138",null,"Completed","1233 Propane Sales","08/30/2014",103,89,26]
["09/03/2014","Payment",1398,null,null,"182 KP Landscape","09/03/2014",99,44,76]
["09/03/2014","Payment","07311C",null,null,"103 Tommy Brunson","09/03/2014",99,95,41]
["08/16/2014","Invoice","RT5194",null,"Contract sent","1040 Preston Broadhead","09/15/2014",87,23,92]
["09/15/2014","Invoice","RT5415",null,"Completed","1233 Propane Sales","09/15/2014",87,5,78]
["09/15/2014","Invoice","RT5457",null,"Completed","1880 MATC","09/15/2014",87,13,93]
["09/15/2014","Invoice","RT5385",null,"Contract sent","2 Rocky Mountain West Telecom","09/15/2014",87,18,28]
["09/15/2014","Invoice","RT5466",null,"Contract sent","709 Beaver Creek Constitution","09/15/2014",87,18,15]
["09/15/2014","Invoice","RT5375",null,"Contract sent","986 Wasatch Back","09/15/2014",87,7,83]
["09/15/2014","Invoice","RT5410",null,"Contract sent","188 PCS Landscaping","09/15/2014",87,40,97]
["09/15/2014","Invoice","RT5470",null,"Contract sent","1023 Diamond Vault Construction","09/15/2014",87,46,76]
["09/15/2014","Invoice","RT5368",null,"Contract sent","157 Wasatch County Parks and Rec ATTN Tom Bonner","09/15/2014",87,3,63]
["09/15/2014","Invoice","RT5472",null,"Contract sent","233 Mounteer Enterprise","09/15/2014",87,21,58]
["09/15/2014","Invoice","RT5355",null,"Contract sent","2127 Jeff Wright","09/15/2014",{"$f":"TODAY()-G323","v":87},{"$f":"RANDBETWEEN(1,100)","v":56},31]
["09/15/2014","Invoice","RT5442",null,"Contract sent","1645 JaCie Butters","09/15/2014",87,12,52]
["09/15/2014","Invoice","RT5484",null,"Contract sent","218 CRC","09/15/2014",87,49,25]
["09/15/2014","Invoice","RT5464",null,"Contract sent","188 PCS Landscaping","09/15/2014",87,25,98]
["09/15/2014","Invoice","RT5447",null,"Completed","1146 Watts Enterprises","09/15/2014",87,64,81]
["09/15/2014","Invoice","RT5471",null,"Contract sent","78 john post","09/15/2014",87,71,34]
["09/15/2014","Invoice","RT5459",null,"Contract sent","233 Mounteer Enterprise","09/15/2014",87,72,100]
["09/15/2014","Invoice","RT5402",null,"Completed","727 Valley high construction","09/15/2014",87,45,28]
["09/15/2014","Invoice","RT5500",null,"Contract sent","294 Moonlight Construction","09/15/2014",87,26,42]
["09/15/2014","Invoice","RT5463",null,"Contract sent","1617 Mountain View Fellowship Church","09/15/2014",87,12,86]
["09/15/2014","Invoice","RT5401",null,"Contract sent","96 Robert Benson","09/15/2014",87,93,2]
["09/15/2014","Invoice","RT5358",null,"Contract sent","356 Pinetop Landscaping","09/15/2014",87,75,28]
["09/15/2014","Invoice","RT5430",null,"Contract sent","189 Lone Peak Sprinkler and Landscape","09/15/2014",87,15,34]
["09/15/2014","Invoice","RT5431",null,"Cancelled","188 PCS Landscaping","09/15/2014",87,80,57]
["09/15/2014","Invoice","RT5378",null,"Contract sent","709 Beaver Creek Constitution","09/15/2014",87,60,84]
["09/15/2014","Invoice","RT5288",null,"Contract sent","1046 Bob Kelez","09/15/2014",87,75,11]
["09/15/2014","Invoice","RT5432",null,"Cancelled","188 PCS Landscaping","09/15/2014",87,99,51]
["09/15/2014","Invoice","RT5151",null,"Contract sent","188 PCS Landscaping","09/15/2014",87,21,43]
["09/15/2014","Invoice","RT5162",null,"Contract sent","188 PCS Landscaping","09/15/2014",87,77,50]
["09/15/2014","Invoice","RT5476",null,"Contract sent","188 PCS Landscaping","09/15/2014",87,1,23]
["09/15/2014","Invoice","RT5477",null,"Contract sent","188 PCS Landscaping","09/15/2014",87,74,1]
["09/15/2014","Invoice","RT5474",null,"Contract sent","188 PCS Landscaping","09/15/2014",87,58,34]
["09/15/2014","Invoice","RT5473",null,"Contract sent","188 PCS Landscaping","09/15/2014",87,70,95]
["09/15/2014","Invoice","RT5475",null,"Cancelled","188 PCS Landscaping","09/15/2014",87,8,50]
["09/22/2014","Invoice","RT5591",null,"Completed","1233 Propane Sales","09/22/2014",80,28,50]
["09/22/2014","Invoice","RT5517",null,"Completed","2181 Tracy Fisher","09/22/2014",80,21,10]
["09/22/2014","Invoice","RT5523",null,"Contract sent","1941 Chris  Smith","09/22/2014",80,70,47]
["09/22/2014","Invoice","RT5570",null,"Contract sent","709 Beaver Creek Constitution","09/22/2014",80,36,8]
["09/22/2014","Invoice","RT5519",null,"Contract sent","1813 Jason Roseveare","09/22/2014",80,16,45]
["09/22/2014","Invoice","RT5572",null,"Contract sent","2196 cory hardman","09/22/2014",80,6,25]
["09/22/2014","Invoice","RT5516",null,"Contract sent","233 Mounteer Enterprise","09/22/2014",80,91,15]
["09/22/2014","Invoice","RT5490",null,"Contract sent","844 Timberlakes Road","09/22/2014",80,67,6]
["09/22/2014","Invoice","RT5531",null,"Contract sent","139 Wasatch County School District","09/22/2014",80,8,80]
["09/22/2014","Invoice","RT5583",null,"Contract sent","1422 Hightech","09/22/2014",80,99,5]
["09/22/2014","Invoice","RT5527",null,"Contract sent","367 Wasatch Back Property Management","09/22/2014",80,99,24]
["09/22/2014","Invoice","RT5501",null,"Contract sent","61 Center Creek Construction","09/22/2014",80,43,26]
["09/22/2014","Invoice","RT5534",null,"Contract sent","1255 Log Craft","09/22/2014",80,33,32]
["08/25/2014","Invoice","RT3500-2",null,null,"1496 Mark Donathan","09/24/2014",78,64,86]
["09/26/2014","Invoice","RT5615",null,"Contract sent","27 Blake Allen","09/26/2014",76,90,36]
["09/26/2014","Invoice","RT5650",null,"Contract sent","878 todd  willie","09/26/2014",76,10,37]
["09/26/2014","Invoice","RT5614",null,"Contract sent","807 Redoubt","09/26/2014",76,39,2]
["09/26/2014","Invoice","RT5635",null,"Contract sent","684 Lava Corp","09/26/2014",76,37,72]
["09/26/2014","Invoice","RT5652",null,"Contract sent","114 Jose Maciel","09/26/2014",76,1,21]
["09/26/2014","Invoice","RT5645",null,"Completed","727 Valley high construction","09/26/2014",76,2,6]
["09/26/2014","Invoice","RT5594",null,"Contract sent","1255 Log Craft","09/26/2014",76,88,73]
["09/26/2014","Invoice","RT5617",null,"Contract sent","2214 MIll stream Equip","09/26/2014",76,81,5]
["09/26/2014","Invoice","RT5612",null,"Contract sent","7 Heber Homes","09/26/2014",76,90,75]
["09/26/2014","Invoice","RT5642",null,"Contract sent","294 Moonlight Construction","09/26/2014",76,29,81]
["08/28/2014","Invoice","RT5301",null,"Contract sent","844 Timberlakes Road","09/27/2014",75,73,17]
["08/29/2014","Invoice","RT5342",null,"Cancelled","96 Robert Benson","09/28/2014",74,90,87]
["08/30/2014","Invoice","RT5347",null,"Cancelled","2125 Robert Sorensen","09/29/2014",73,80,65]
["08/31/2014","Invoice","FC814",null,null,"1165 Cracar Construction","09/30/2014",72,70,76]
["09/30/2014","Invoice","RT5685",null,"Completed","2237 Christen Jones","09/30/2014",72,13,42]
["09/30/2014","Invoice","RT5673",null,"Completed","2232 Andrew Olson","09/30/2014",72,71,17]
["09/30/2014","Invoice","RT5676",null,"Contract sent","1546 Craig Cuilter","09/30/2014",72,69,24]
["09/30/2014","Invoice","RT5643",null,"Contract sent","231 Heber Valley Camp","09/30/2014",72,42,54]
["09/30/2014","Invoice","RT5678",null,"Contract sent","709 Beaver Creek Constitution","09/30/2014",72,30,27]
["09/30/2014","Invoice","RT5683",null,"Contract sent","233 Mounteer Enterprise","09/30/2014",72,28,39]
["09/30/2014","Invoice","RT5666",null,"Contract sent","296 rick mecham costruction","09/30/2014",72,7,69]
["09/30/2014","Invoice","RT5647",null,"Contract sent","377 Bryan  Daybell","09/30/2014",72,84,45]
["09/30/2014","Invoice","RT5684",null,"Contract sent","964 tri state pluming","09/30/2014",72,79,43]
["09/30/2014","Invoice","RT5665",null,"Contract sent","196 Dave Gagnon","09/30/2014",72,1,58]
["09/30/2014","Invoice","RT5611",null,"Contract sent","189 Lone Peak Sprinkler and Landscape","09/30/2014",72,63,61]
["09/30/2014","Journal Entry",391,null,null,"U-Haul","09/30/2014",72,75,99]
["10/02/2014","Payment",22809,null,null,"139 Wasatch County School District","10/02/2014",{"$f":"TODAY()-G387","v":70},{"$f":"RANDBETWEEN(1,100)","v":38},68]
["10/02/2014","Payment",683987,null,null,"121 Malcom Hunsaker","10/02/2014",70,38,45]
["10/03/2014","Invoice","RT5712",null,"Contract sent","2242 John Call","10/03/2014",69,45,20]
["10/03/2014","Invoice","RT5721",null,"Contract sent","1570 Chase Wright","10/03/2014",69,41,36]
["10/03/2014","Invoice","RT5703",null,"Contract sent","709 Beaver Creek Constitution","10/03/2014",69,71,85]
["10/03/2014","Invoice","RT5717",null,"Contract sent","1262 Tyler Fowkes","10/03/2014",69,54,63]
["10/06/2014","Invoice","RT5739",null,"Contract sent","709 Beaver Creek Constitution","10/06/2014",66,66,48]
["10/06/2014","Invoice","RT5733",null,"Contract sent","964 tri state pluming","10/06/2014",66,11,53]
["10/06/2014","Invoice","RT5748",null,"Contract sent","296 rick mecham costruction","10/06/2014",66,61,29]
["10/06/2014","Invoice","RT5708",null,"Cancelled","261 Herb Burnett","10/06/2014",66,16,2]
["10/06/2014","Invoice","RT5699",null,"Contract sent","359 Jeff Peterson","10/06/2014",66,19,16]
["10/06/2014","Invoice","RT5735",null,"Cancelled","1072 Parker Cummings","10/06/2014",66,15,88]
["10/08/2014","Invoice","RT5795",null,"Contract sent","233 Mounteer Enterprise","10/08/2014",64,38,80]
["10/08/2014","Invoice","RT5788",null,"Contract sent","379 Jorgason Builders","10/08/2014",64,77,86]
["10/08/2014","Invoice","RT5787",null,"Contract sent","1146 Watts Enterprises","10/08/2014",64,30,67]
["10/08/2014","Invoice","RT5799",null,"Contract sent","160 heber valey prop","10/08/2014",64,56,53]
["10/08/2014","Invoice","RT5783",null,"Completed","267 Midway Construction","10/08/2014",64,61,65]
["10/08/2014","Invoice","RT5792",null,"Contract sent","2270 Robert Wilson","10/08/2014",64,20,68]
["10/08/2014","Invoice","RT5773",null,"Contract sent","121 Malcom Hunsaker","10/08/2014",64,17,99]
["10/08/2014","Invoice","RT5761",null,"Completed","1090 Heber Light  Power","10/08/2014",64,21,67]
["10/08/2014","Invoice","RT5789",null,"Contract sent","188 PCS Landscaping","10/08/2014",64,44,73]
["10/08/2014","Invoice","RT5755",null,"Contract sent","233 Mounteer Enterprise","10/08/2014",64,38,34]
["10/08/2014","Invoice","RT5750",null,"Contract sent","233 Mounteer Enterprise","10/08/2014",64,1,91]
["10/08/2014","Invoice","RT5803",null,"Contract sent","233 Mounteer Enterprise","10/08/2014",64,97,70]
["10/08/2014","Invoice","RT5769",null,"Completed","382 Derek Lawn An Landscaping","10/08/2014",64,59,61]
["10/09/2014","Payment",243895,null,null,"382 Derek Lawn An Landscaping","10/09/2014",63,42,44]
["10/13/2014","Invoice","RT5823",null,"Cancelled","2283 Natalie Treater","10/13/2014",59,31,44]
["10/13/2014","Invoice","RT5850",null,"Contract sent","1553 Lane Lythgoe","10/13/2014",59,95,49]
["10/13/2014","Invoice","RT5813",null,"Completed","267 Midway Construction","10/13/2014",59,53,69]
["10/13/2014","Invoice","RT5832",null,"Contract sent","238 Earnie Brown","10/13/2014",59,72,59]
["10/14/2014","Payment",264686,null,null,"382 Derek Lawn An Landscaping","10/14/2014",58,26,13]
["10/15/2014","Invoice","RT5888",null,"Contract sent","1349 Jordanell Special Service","10/15/2014",57,48,65]
["10/15/2014","Invoice","RT5858",null,"Contract sent","1375 Beebe Construction","10/15/2014",57,27,47]
["10/15/2014","Invoice","RT5886",null,"Cancelled","95 Josh Green","10/15/2014",57,49,67]
["10/15/2014","Invoice","RT5809",null,"Contract sent","2276 Division of Wildlife Resources","10/15/2014",57,100,57]
["10/15/2014","Invoice","RT5836",null,"Contract sent","121 Malcom Hunsaker","10/15/2014",57,14,46]
["10/15/2014","Invoice","RT5882",null,"Contract sent","121 Malcom Hunsaker","10/15/2014",57,15,32]
["10/15/2014","Invoice","RT5821",null,"Contract sent","711 Paul Proctor","10/15/2014",57,9,64]
["10/15/2014","Invoice","RT5862",null,"Cancelled","2299 Allan Kuerbis","10/15/2014",57,92,30]
["10/15/2014","Invoice","RT5816",null,"Contract sent","160 heber valey prop","10/15/2014",57,18,63]
["10/15/2014","Invoice","RT5879",null,"Completed","1415 Highmark","10/15/2014",57,10,92]
["10/15/2014","Invoice","RT5839",null,"Contract sent","61 Center Creek Construction","10/15/2014",57,72,4]
["10/15/2014","Invoice","RT5729",null,"Contract sent","844 Timberlakes Road","10/15/2014",57,58,12]
["10/15/2014","Invoice","RT5827",null,"Contract sent","267 Midway Construction","10/15/2014",57,16,96]
["10/15/2014","Invoice","RT5829",null,"Contract sent","188 PCS Landscaping","10/15/2014",57,32,60]
["10/15/2014","Invoice","RT5830",null,"Contract sent","188 PCS Landscaping","10/15/2014",57,10,23]
["10/15/2014","Invoice","RT5859",null,"Contract sent","2257 Gordan Dusfn","10/15/2014",57,33,25]
["10/20/2014","Invoice","RT5891",null,"Completed","733 Bess construction Jim","10/20/2014",52,69,44]
["10/20/2014","Invoice","RT5914",null,"Contract sent","182 KP Landscape","10/20/2014",52,39,3]
["10/20/2014","Invoice","RT5908",null,"Contract sent","733 Bess construction Jim","10/20/2014",52,93,97]
["10/20/2014","Invoice","RT5898",null,"Contract sent","1794 Dutch Canyon Development","10/20/2014",52,9,13]
["10/20/2014","Invoice","RT5909",null,"Completed","685 A Plus Sewer and Water","10/20/2014",52,98,23]
["10/20/2014","Invoice","RT5938",null,"Contract sent","204 clayton  simpson","10/20/2014",52,49,47]
["10/20/2014","Invoice","RT5901",null,"Contract sent","2312 Geneva Rock","10/20/2014",52,36,53]
["10/20/2014","Invoice","RT5843",null,"Contract sent","314 RA lawncare","10/20/2014",52,62,41]
["10/20/2014","Invoice","RT5873",null,"Contract sent","1110 eric  martinez","10/20/2014",52,6,57]
["10/20/2014","Invoice","RT5917",null,"Contract sent","377 Bryan  Daybell","10/20/2014",52,100,35]
["10/20/2014","Invoice","RT5939",null,"Contract sent","1726 Summit Line","10/20/2014",52,16,32]
["10/20/2014","Invoice","RT5930",null,"Cancelled","389 Shawn Johnstun","10/20/2014",52,28,90]
["10/20/2014","Invoice","RT5936",null,"Contract sent","749 Aspen Ridge Development","10/20/2014",52,66,97]
["10/20/2014","Invoice","RT5912",null,"Contract sent","847 Flatline Construction","10/20/2014",52,62,40]
["10/20/2014","Invoice","RT5880",null,"Completed","2261 Phil Babcock","10/20/2014",52,77,9]
["10/20/2014","Invoice","RT5924",null,"Contract sent","1262 Tyler Fowkes","10/20/2014",52,60,8]
["10/20/2014","Invoice","RT5911",null,"Contract sent","188 PCS Landscaping","10/20/2014",52,39,13]
["10/21/2014","Invoice","RT5955",null,"Completed","1099 Park City landscape","10/21/2014",{"$f":"TODAY()-G451","v":51},{"$f":"RANDBETWEEN(1,100)","v":80},50]
["10/21/2014","Invoice","RT5962",null,"Contract sent","121 Malcom Hunsaker","10/21/2014",51,100,57]
["10/21/2014","Invoice","RT5953",null,"Contract sent","1059 Liz Field","10/21/2014",51,8,14]
["10/21/2014","Invoice","RT5949",null,"Completed","382 Derek Lawn An Landscaping","10/21/2014",51,74,98]
["10/21/2014","Invoice","RT5797",null,"Completed","1684 Summit Earth Work","10/21/2014",51,62,15]
["10/24/2014","Invoice","RT5974",null,"Contract sent","1595 Altitude Equipment Rental","10/24/2014",48,34,57]
["10/24/2014","Invoice","RT5988",null,"Completed","60 Greylight Construction","10/24/2014",48,99,80]
["10/24/2014","Invoice","RT6003",null,"Contract sent","1165 Cracar Construction","10/24/2014",48,20,90]
["10/24/2014","Invoice","RT6001",null,"Completed","2345 Curt Williamson","10/24/2014",48,96,85]
["10/24/2014","Invoice","RT5991",null,"Completed","2137 Kim Kowallis","10/24/2014",48,49,89]
["10/24/2014","Invoice","RT6009",null,"Completed","2346 Paul Arnold","10/24/2014",48,16,48]
["10/24/2014","Invoice","RT5975",null,"Contract sent","822 Wes  Sc","10/24/2014",48,89,10]
["10/24/2014","Invoice","RT5968",null,"Contract sent","233 Mounteer Enterprise","10/24/2014",48,53,73]
["10/24/2014","Invoice","RT5972",null,"Completed","382 Derek Lawn An Landscaping","10/24/2014",48,65,64]
["10/24/2014","Invoice","RT5798",null,"Completed","1684 Summit Earth Work","10/24/2014",48,85,2]
["10/24/2014","Invoice","RT6002",null,"Contract sent","2330 Matt Knight","10/24/2014",48,74,16]
["10/24/2014","Invoice","RT4946",null,"Contract sent","139 Wasatch County School District","10/24/2014",48,59,23]
["10/24/2014","Invoice","RT6011",null,"Contract sent","1214 Bull River Log Homes","10/24/2014",48,59,40]
["10/24/2014","Invoice","RT5965",null,"Contract sent","2333 Habitat For Humanity","10/24/2014",48,75,93]
["10/24/2014","Invoice","RT5957",null,"Completed","1097 Dallin  Larson","10/24/2014",48,80,68]
["10/24/2014","Invoice","RT5987",null,"Completed","2158 Point Const","10/24/2014",48,99,33]
["10/24/2014","Invoice","RT5980",null,"Contract sent","1122 Deer  Valley Sand and Gravel","10/24/2014",48,83,48]
["10/27/2014","Invoice","RT5969",null,"Contract sent","2334 Aaron Gabrielson","10/27/2014",45,39,38]
["10/27/2014","Invoice","RT6024",null,"Completed","2013 Diane Swensen","10/27/2014",45,71,75]
["10/27/2014","Invoice","RT5992",null,"Contract sent","908 Seth  Lloyd","10/27/2014",45,95,47]
["10/27/2014","Invoice","RT6012",null,"Contract sent","296 rick mecham costruction","10/27/2014",45,36,38]
["10/27/2014","Invoice","RT5960",null,"Completed","2330 Matt Knight","10/27/2014",45,3,67]
["09/28/2014","Invoice","RT2740-2",null,null,"280 Mike  Clegg","10/28/2014",44,65,85]
["10/30/2014","Invoice","RT6084",null,"Completed","2335 Willoam Stanley","10/30/2014",42,7,56]
["10/30/2014","Invoice","RT6069",null,"Completed","431 Rod Riddle","10/30/2014",42,44,57]
["10/30/2014","Invoice","RT6082",null,"Completed","1527 Brent Hayes","10/30/2014",42,21,95]
["10/30/2014","Invoice","RT6051",null,"Completed","2357 Derrick LaPee","10/30/2014",42,28,39]
["10/30/2014","Invoice","RT6077",null,"Completed","2366 Don Bloxom","10/30/2014",42,24,91]
["10/30/2014","Invoice","RT6071",null,"Cancelled","2324 Carson Brown","10/30/2014",42,15,49]
["10/30/2014","Invoice","RT6049",null,"Completed","2356 Jeff Harding","10/30/2014",42,5,18]
["10/30/2014","Invoice","RT6052",null,"Completed","2281 Willie  Holdman","10/30/2014",42,17,75]
["10/30/2014","Invoice","RT6070",null,"Contract sent","233 Mounteer Enterprise","10/30/2014",42,16,63]
["10/30/2014","Invoice","RT6058",null,"Completed","2359 Utah Correctional ind","10/30/2014",42,51,11]
["10/30/2014","Invoice","RT6023",null,"Completed","2347 Jay  Schooler","10/30/2014",42,83,6]
["10/30/2014","Invoice","RT6042",null,"Completed","551 Nile Horner","10/30/2014",42,66,97]
["10/30/2014","Invoice","RT5884",null,"Completed","1568 Allison Andrews","10/30/2014",42,12,25]
["10/30/2014","Invoice","RT6079",null,"Contract sent","564 BTM","10/30/2014",42,91,31]
["10/30/2014","Invoice","RT6072",null,"Contract sent","2309 Bob Keysaw","10/30/2014",42,60,84]
["10/30/2014","Invoice","RT6067",null,"Completed","2364 Jay Burningham","10/30/2014",42,95,33]
["10/30/2014","Invoice","RT5723",null,"Completed","2244 Jared  Dahl","10/30/2014",42,35,97]
["10/30/2014","Invoice","RT6075",null,"Completed","204 clayton  simpson","10/30/2014",42,39,38]
["10/30/2014","Invoice","RT6076",null,"Completed","204 clayton  simpson","10/30/2014",42,47,80]
["10/30/2014","Invoice","RT6027",null,"Completed","1415 Highmark","10/30/2014",42,42,77]
["10/30/2014","Invoice","RT5905",null,"Contract sent","1097 Dallin  Larson","10/30/2014",42,45,88]
["10/30/2014","Invoice","RT6060",null,"Contract sent","121 Malcom Hunsaker","10/30/2014",42,56,77]
["10/30/2014","Invoice","RT6050",null,"Completed","403 Thomas Coleman","10/30/2014",42,96,7]
["10/30/2014","Invoice","RT6065",null,"Completed","2363 JaCo","10/30/2014",42,81,8]
["10/30/2014","Invoice","RT5997",null,"Completed","2168 Michaels LAndscaping","10/30/2014",42,56,4]
["10/30/2014","Invoice","RT6029",null,"Contract sent","1122 Deer  Valley Sand and Gravel","10/30/2014",42,18,58]
["10/30/2014","Invoice","RT6007",null,"Contract sent","139 Wasatch County School District","10/30/2014",42,27,44]
["10/30/2014","Invoice","RT6062",null,"Contract sent","2361 CR Painting","10/30/2014",42,69,33]
["10/30/2014","Invoice","RT6035",null,"Completed","2352 Mark Garcia","10/30/2014",42,46,41]
["10/30/2014","Invoice","RT6008",null,"Completed","2324 Carson Brown","10/30/2014",42,36,56]
["10/30/2014","Invoice","RT6046",null,"Contract sent","2355 Chris Newitt","10/30/2014",42,10,34]
["10/30/2014","Invoice","RT6032",null,"Contract sent","1351 Hunsaker Properties","10/30/2014",42,42,94]
["10/30/2014","Invoice","RT6063",null,"Contract sent","2361 CR Painting","10/30/2014",42,1,49]
["10/30/2014","Invoice","RT6057",null,"Contract sent","604 Scott Peirce","10/30/2014",42,44,80]
["10/30/2014","Invoice","RT6018",null,"Contract sent","1415 Highmark","10/30/2014",42,16,91]
["10/30/2014","Invoice","RT6044",null,"Contract sent","2257 Gordan Dusfn","10/30/2014",42,34,12]
["10/30/2014","Invoice","RT6004",null,"Contract sent","1165 Cracar Construction","10/30/2014",{"$f":"TODAY()-G515","v":42},{"$f":"RANDBETWEEN(1,100)","v":26},26]
["10/30/2014","Invoice","RT6031",null,"Contract sent","2349 Kory Boyd","10/30/2014",42,9,67]
["10/30/2014","Invoice","RT6064",null,"Contract sent","1165 Cracar Construction","10/30/2014",42,43,18]
["10/30/2014","Invoice","RT6047",null,"Contract sent","188 PCS Landscaping","10/30/2014",42,5,76]

{"sheet":"Instructions","index":1,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["This workbook is used to help you set up AR in a way that helps us better understand what is going on with AR and help us improve collections."]
[]
["Please reference the AR Setup tab at the top of the excel Ribbon."]
[]
["Files you need to have ready before starting:"]
["The new AR Detail sheet for the most recent date"]
["The old AR Detail sheet with the notes and status"]
["Orders spreadsheet from Rental Trax"]
[]
["AR Setup Button"]
["Clicking this button will prompt you to select the most recent AR detail sheet you downloaded."]
["Select and find that file and let the macro do its work."]
["This will format the AR Detail in a way that is easy to understand and make it ready to capture the right information."]
[]
["Update Last Week"]
["Clicking this button will prompt you to select last weeks or last period's AR sheet you used to keep track of information."]
["Select the file and let the macro update AR with past notes and status etc."]
[]
["RT Status"]
["Clicking this button will prompt you to select the orders file you downloaded from Rental Trax"]
["Find and select the orders file you downloaded and let the macro insert the RT status of the orders"]
["This will be helpful to see if an order has been cancelled recently etc."]