{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Customers2","Work","Billed","Paid","Non LOM Work","Non LOM Billed","Non LOM Paid","Miles","Estes","Sheet1","Bill","Payments","Customers","Sent","Settings"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Customers2","index":0,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Employee Responsible","Customer","Phone","Email"]
["Pete","Allan, Collin","no phone number online","jc_allan@comcast.net","Yes"]
["Bruce","Asay, Jason","787-0454","asayjason@gmail.com","Email comprehensive bid"]
["Pete","Brown, Nad","489-7707","nadbmarb@gmail.com"]
["Bruce","Croft, Harvey","489-6084",null,"Fax bid to 801-766-0206"]
["Bruce","Dahl, Jordan","801-372-8806",null,"No answer.  Left message"]
["Pete","Estes, Ben","no phone number online"]
["Pete","Frischknecht, Jon","no phone number online","susanfrisch@gmail.com","Yes","Wait to hear back"]
["Bruce","Gardner, Ben","no phone number online",null,"Yes"]
["Bruce","Garlitz, Parker","491-9625",null,"Yes"]
["Pete","Gillett, Tim","489-5590","gillettfamily@yahoo.com","Not sure.  They'll get back to us"]
["Bruce","Goodsell, Jeff","491-0521","jeff@jeffgoodsellart.com","Yes","See email"]
["Pete","Hagens","491-8991","juliemhagen@gmail.com","No"]
["Pete","Iris","489-6631",null,"Yes"]
["Bruce","Johnson, Clay","491-0965","clayton3_4@msn.com"]
["Pete","Jones, Ruston","491-3291","natruston@aol.com"]
["Pete","Kreihbel","-"]
["Bruce","Lambert, Brian","489-4336","summercampranch@yahoo.com","Yes"]
["Bruce","Mahin, Dian","489-3392","dian_69@msn.com","Yes","Whenever we normally start"]
["Bruce","Maturlo, Susan","319-1223","bozk@aol.com","Yes","Fertilize late march.  Begin mowing beginning of April"]
["Bruce","McKellar, Jan","801-373-3363",null,"Yes","Aerate for free"]
["Pete","Olsen, Steve","491-8250","solsen@emcity.org","Yes","Mid to late April"]
["Bruce","Papa Murphy's","489-8968","ferg4us9@aol.com","Yes"]
["Pete","Peterson, Richard","491-9492",null,"Yes","Mid to late April"]
["Bruce","Sabin, Bob","491-4289","eskimos@comcast.net","Yes"]
["Pete","Welch, Arthur","no phone number online",null,"Yes","Mid to late April"]
["Pete","West, Linda","491-9061","wlinda816@hotmail.com","Yes"]
["Bruce","Winnie, Daniel","489-4330",null,"Yes","She'll call when they want us to start"]
["Bruce","Wolfgramm, Mark","319-7947"]
["Bruce","Thomas, Dick","801-489-7674",null,"Yes","No aerating.  Start beginning of April"]
["Bruce","Thomsen",null,null,"Yes"]
["Bruce","Tudor","801-489-6323"]
["Bruce","Audra Call",null,null,"Yes","Mowing: $25, Spraying: $30, Weeding: $15/hr"]
["Bruce","Garrett Watkins",null,"watkinsfam@hotmail.com","Edging only.  Only do the front.  $15/month (Mahin's neighbor)"]
[]
["Bids Outstanding"]
["Bruce","Norm Eakins","91 S. 450 W. Springville","801-361-8325",40]

{"sheet":"Work","index":1,"n_rows":1048249,"n_cols":9,"rows_kept":4500,"cut":true,"hidden":false,"merged":[],"bounds":{"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0}}
["WorkID","Date","Customer","Service","Amount","Bruce","Ryan","LOM","Check Number"]
[null,"2011-11-25","Lance Kirkland","Credit",-55,null,null,null,4582]
[null,"2011-11-25","Lance Kirkland","Credit",-55,null,null,null,4567]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(G61:G1048248)","v":0}]

{"sheet":"Billed","index":2,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["WorkID","Date","Customer","Service","Amount","Bruce","Ryan","LOM","Check Number"]
[null,"2011-11-28","Brian Jensen","Mowing",55,36.666666666666664,0,18.333333333333332]
[null,"2011-11-02","Daniel Childs","Mowing",30,0,20,10]
[null,"2011-11-09","Daniel Childs","Mowing",30,20,0,10]
[null,"2011-11-16","Daniel Childs","Mowing",30,10,10,10]
[null,"2011-11-23","Daniel Childs","Mowing",30,0,20,10]
[null,"2011-11-30","Daniel Childs","Mowing",30,10,10,10]
[null,"2011-11-02","Dian Parks","Mowing",30,0,20,10]
[null,"2011-11-09","Dian Parks","Mowing",30,20,0,10]
[null,"2011-11-16","Dian Parks","Mowing",30,10,10,10]
[null,"2011-11-23","Dian Parks","Mowing",30,0,20,10]
[null,"2011-11-30","Dian Parks","Mowing",30,10,10,10]
[null,"2011-11-02","Garrett Wall","Edging",3.75,1.25,1.25,1.25]
[null,"2011-11-09","Garrett Wall","Edging",3.75,1.25,1.25,1.25]
[null,"2011-11-16","Garrett Wall","Edging",3.75,1.25,1.25,1.25]
[null,"2011-11-23","Garrett Wall","Edging",3.75,2.5,0,1.25]
[null,"2011-11-30","Garrett Wall","Edging",3.75,1.25,1.25,1.25]
[null,"2011-11-02","Harvey Maw","Mowing",30,10,10,10]
[null,"2011-11-09","Harvey Maw","Mowing",30,0,20,10]
[null,"2011-11-16","Harvey Maw","Mowing",30,10,10,10]
[null,"2011-11-23","Harvey Maw","Mowing",30,20,0,10]
[null,"2011-11-30","Harvey Maw","Mowing",30,10,10,10]
[null,"2011-11-02","Jan Temple","Mowing",30,20,0,10]
[null,"2011-11-09","Jan Temple","Mowing",30,20,0,10]
[null,"2011-11-16","Jan Temple","Mowing",30,8.3333333333333339,10,10]
[null,"2011-11-23","Jan Temple","Mowing",30,20,0,10]
[null,"2011-11-04","Jeff Dewey","Mowing",25,16.666666666666668,0,8.3333333333333339]
[null,"2011-11-11","Jeff Dewey","Mowing",25,16.666666666666668,0,8.3333333333333339]
[null,"2011-11-18","Jeff Dewey","Mowing",25,8.3333333333333339,8.3333333333333339,8.3333333333333339]
[null,"2011-11-25","Jeff Dewey","Mowing",25,16.666666666666668,0,8.3333333333333339]
[null,"2011-11-07","John Paulsen","Mowing",45,30,0,15]
[null,"2011-11-14","John Paulsen","Mowing",45,0,30,15]
[null,"2011-11-21","John Paulsen","Mowing",45,15,15,15]
[null,"2011-11-28","John Paulsen","Mowing",45,30,0,15]
[null,"2011-11-07","Linda Brockbank","Mowing",25,16.666666666666668,0,8.3333333333333339]
[null,"2011-11-14","Linda Brockbank","Mowing",25,0,16.666666666666668,8.3333333333333339]
[null,"2011-11-21","Linda Brockbank","Mowing",25,0,16.666666666666668,8.3333333333333339]
[null,"2011-11-28","Linda Brockbank","Mowing",25,16.666666666666668,0,8.3333333333333339]
[null,"2011-11-28","Richard Allen","Mowing",30,20,0,10]
[null,"2011-11-04","Rusty Jenkins","Mowing",30,20,0,10]
[null,"2011-11-11","Rusty Jenkins","Mowing",30,20,0,10]
[null,"2011-11-18","Rusty Jenkins","Mowing",30,20,0,10]
[null,"2011-11-25","Rusty Jenkins","Mowing",30,10,10,10]
[null,"2011-11-18","Shirley Clark","Edging",7.5,5,0,2.5]
[null,"2011-11-25","Shirley Clark","Edging",7.5,2.5,2.5,2.5]
[null,"2011-11-04","Susan Singley","Mowing",30,20,0,10]
[null,"2011-11-11","Susan Singley","Mowing",30,0,20,10]
[null,"2011-11-18","Susan Singley","Mowing",30,0,20,10]
[null,"2011-11-25","Susan Singley","Mowing",30,10,10,10]
[null,"2011-11-04","Suzanne Ricks","Edging",5,3.3333333333333335,0,1.6666666666666667]
[null,"2011-11-11","Suzanne Ricks","Edging",5,0,3.3333333333333335,1.6666666666666667]
[null,"2011-11-18","Suzanne Ricks","Edging",5,0,3.3333333333333335,1.6666666666666667]
[null,"2011-11-25","Suzanne Ricks","Edging",5,1.6666666666666667,1.6666666666666667,1.6666666666666667]
[null,"2011-11-02","Bob Kopps","Mowing",20,13.333333333333334,0,6.666666666666667]
[null,"2011-11-09","Bob Kopps","Mowing",20,0,13.333333333333334,6.666666666666667]
[null,"2011-11-16","Bob Kopps","Mowing",20,6.666666666666667,6.666666666666667,6.666666666666667]
[null,"2011-11-23","Bob Kopps","Mowing",20,6.666666666666667,6.666666666666667,6.666666666666667]
[null,"2011-11-30","Bob Kopps","Mowing",20,6.666666666666667,6.666666666666667,6.666666666666667]
[null,"2011-11-04","Suzanne Ricks","Edging",5,3.3333333333333335,0,1.6666666666666667]
[null,"2011-11-11","Suzanne Ricks","Edging",5,0,3.3333333333333335,1.6666666666666667]
[null,"2011-11-18","Suzanne Ricks","Edging",5,0,3.3333333333333335,1.6666666666666667]
[null,"2011-11-25","Suzanne Ricks","Edging",5,1.6666666666666667,1.6666666666666667,1.6666666666666667]

{"sheet":"Paid","index":3,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["WorkID","Date","Customer","Service","Amount","Bruce","Ryan","LOM","Check Number"]
[null,"2011-11-04","Lance Kirkland","Edging",5,3.3333333333333335,0,1.6666666666666667,4582]
[null,"2011-11-11","Lance Kirkland","Edging",5,3.3333333333333335,0,1.6666666666666667,4582]
[null,"2011-11-18","Lance Kirkland","Edging",5,0,3.3333333333333335,1.6666666666666667,4582]
[null,"2011-11-25","Lance Kirkland","Edging",5,1.6666666666666667,1.6666666666666667,1.6666666666666667,4582]
[null,"2011-11-07","Brian Jensen","Mowing",55,0,36.666666666666664,18.333333333333332,7642]
[null,"2011-11-14","Brian Jensen","Mowing",55,36.666666666666664,0,18.333333333333332,7642]
[null,"2011-11-21","Brian Jensen","Mowing",55,18.333333333333332,18.333333333333332,18.333333333333332,7642]

{"sheet":"Non LOM Work","index":4,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["WorkID","Date","Customer","Service","Amount","Bruce","Ryan","Check Number"]
[null,"2011-09-21","Shirley Valyupek","Edging",20,0,20]
[null,"2011-10-10","Linda West","Mowing",20,10,10]
[null,"2011-10-17","Bob Sabin","Mowing",20,0,20]
[null,"2011-10-19","Chuck Taylor","Mowing",50,0,50]
[null,"2011-10-21","Linda West","Mowing",25,25,0]
[null,"2011-10-21","Outback","Mowing",15,15,0]
[null,"2011-10-21","Jeffs","Mowing",30,30,0]
[null,"2011-10-10","Chuck Taylor","Mowing",50,50,0]
[null,"2011-10-14","Arthur Welch","Mowing",25,25,0]
[null,"2011-10-07","Jeffs","Mowing",30,30,0]
[null,"2011-10-07","Outback","Mowing",15,15,0]
[null,"2011-10-29","Chuck Taylor","Mowing",50,0,50]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Lance Black has $5 Credit from Check Number 7169"]

{"sheet":"Non LOM Billed","index":5,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["WorkID","Date","Customer","Service","Amount","Bruce","Ryan","Check Number"]
[null,"2011-09-16","Arthur Welch","Mowing",25,25,0]
[null,"2011-08-11","Linda West","Mowing",25,0,25]
[null,"2011-08-17","Linda West","Mowing",25,0,25]
[null,"2011-09-02","Linda West","Mowing",25,25,0]
[null,"2011-09-09","Linda West","Mowing",25,25,0]
[null,"2011-09-16","Linda West","Mowing",25,25,0]
[null,"2011-09-23","Linda West","Mowing",25,25,0]
[null,"2011-09-30","Linda West","Mowing",25,25,0]

{"sheet":"Non LOM Paid","index":6,"n_rows":147,"n_cols":11,"rows_kept":147,"cut":false,"hidden":true,"merged":[[138,9,138,10]]}
["WorkID","Date","Customer","Service","Amount","Bruce","Ryan","Check Number"]
[null,"2011-04-05","Boyer","Aerating",35,{"$f":"E2*2/3","v":23.333333333333332},null,"Cash"]
[null,"2011-04-05","Linda Priest","Aerating",20,{"$f":"E3*2/3","v":13.333333333333334},null,"Cash"]
[null,"2011-03-23","Arthur Welch","Aerating",30,30,null,353]
[null,"2011-04-19","Arthur Welch","Mowing",25,25,null,353]
[null,"2011-05-16","Jim Wall","Edging",20,20,null,"Cash"]
[null,null,null,null,null,{"$f":"SUM(F2:F6)","v":111.66666666666666}]
[]
[]
[null,"2011-04-05","Linda West","Mowing",25,25,null,1651]
[null,"2011-04-14","Linda West","Mowing",25,25,null,1651]
[null,"2011-04-23","Linda West","Mowing",25,25,null,1651]
[null,"2011-05-02","Linda West","Mowing",25,25,null,1651]
[null,"2011-05-10","Linda West","Mowing",25,25,null,1651]
[null,"2011-05-16","Linda West","Mowing",25,{"$f":"E15","v":25},null,1651]
[null,"2011-05-24","Linda West","Mowing",25,{"$f":"E16","v":25},null,1651]
[null,"2011-05-31","Linda West","Mowing",25,{"$f":"E17","v":25},null,1651]
[null,"2011-05-16","Welch Neighbor","Mowing",10,10,null,"Cash"]
[null,"2011-05-23","Welch Neighbor","Mowing",10,10,null,"Cash"]
[null,"2011-05-31","Welch Neighbor","Mowing",10,10,null,"Cash"]
[null,"2011-05-09","Welch Neighbor","Trimming",5,5,null,"Cash"]
[null,"2011-06-13","Arthur Welch","Mowing",25,{"$f":"E22","v":25},null,365]
[null,"2011-05-02","Arthur Welch","Mowing",25,25,null,365]
[null,"2011-05-16","Arthur Welch","Mowing",25,{"$f":"E24","v":25},null,365]
[null,"2011-05-31","Arthur Welch","Mowing",25,{"$f":"E25","v":25},null,365]
[null,"2011-05-02","Lance Black","Edging",5,5,null,7065]
[null,"2011-05-10","Lance Black","Edging",5,5,null,7065]
[null,"2011-05-24","Lance Black","Edging",5,{"$f":"E28","v":5},null,7065]
[null,"2011-04-14","Lance Black","Edging",5,{"$f":"E29*2/3","v":3.3333333333333335},null,7065]
[null,null,null,null,null,{"$f":"SUM(F10:F29)","v":353.33333333333331},null,null,"Recognized in Quickbooks 6/26/2011"]
[]
[]
[null,"2011-06-06","Welch Neighbor","Mowing",10,{"$f":"E33","v":10},null,"Cash"]
[null,"2011-06-13","Welch Neighbor","Mowing",10,10,null,"Cash"]
[null,"2011-06-20","Welch Neighbor","Mowing",10,10,null,"Cash"]
[null,"2011-06-27","Welch Neighbor","Mowing",10,10,null,"Cash"]
[null,"2011-06-04","Outback","Mowing",15,15]
[null,"2011-06-10","Outback","Mowing",15,15]
[null,"2011-06-18","Outback","Mowing",15,15]
[null,"2011-06-24","Outback","Mowing",15,15]
[null,"2011-06-30","Outback","Mowing",15,15]
[null,"2011-06-10","Darnell Jeffs","Mowing",30,{"$f":"E42","v":30}]
[null,"2011-06-18","Darnell Jeffs","Mowing",30,{"$f":"E43","v":30}]
[null,"2011-06-24","Darnell Jeffs","Mowing",30,{"$f":"E44","v":30}]
[null,"2011-06-30","Darnell Jeffs","Mowing",30,{"$f":"E45","v":30}]
[null,"2011-04-14","Bob Sabin","Mowing",20,20,null,833]
[null,"2011-04-23","Bob Sabin","Mowing",20,20,null,833]
[null,"2011-05-02","Bob Sabin","Mowing",20,20,null,833]
[null,"2011-05-10","Bob Sabin","Mowing",20,20,null,833]
[null,"2011-05-16","Bob Sabin","Mowing",20,{"$f":"E50","v":20},null,833]
[null,"2011-06-06","Lance Black","Edging",5,{"$f":"E51","v":5},null,"7080"]
[null,"2011-06-13","Lance Black","Edging",5,{"$f":"E52","v":5},null,"7080"]
[null,"2011-06-28","Lance Black","Edging",5,{"$f":"E53","v":5},null,"7080"]
[null,"2011-07-06","Stafford","Mowing",10,0,10,"Cash"]
[null,"2011-07-11","Stafford","Mowing",10,0,10,"Cash"]
[null,"2011-07-18","Stafford","Mowing",10,0,10,"Cash"]
[null,"2011-07-25","Stafford","Mowing",10,"-",10,"Cash"]
[null,"2011-07-06","Linda West","Mowing",25,0,25,1712]
[null,"2011-07-12","Linda West","Mowing",25,0,25,1712]
[null,"2011-07-19","Linda West","Mowing",25,0,25,1712]
[null,"2011-07-26","Linda West","Mowing",25,0,25,1712]
[null,"2011-06-06","Linda West","Mowing",25,{"$f":"E62","v":25},null,1712]
[null,"2011-06-13","Linda West","Mowing",25,{"$f":"E63","v":25},null,1712]
[null,"2011-06-21","Linda West","Mowing",25,{"$f":"E64","v":25},null,1712]
[null,"2011-06-28","Linda West","Mowing",25,{"$f":"E65","v":25},null,1712]
[null,"2011-08-02","Linda West","Mowing",25,0,25,"1712"]
[null,null,null,null,null,{"$f":"SUM(F33:F66)","v":450},{"$f":"SUM(G33:G66)","v":165},"Paid Ryan w/ check: 1112"]
[null,null,null,null,null,null,null,"Recognized in Quickbooks 7/31/2011"]
[]
[]
[]
[null,"2011-07-09","Darnell Jeffs","Mowing",30,30,0]
[null,"2011-07-15","Darnell Jeffs","Mowing",30,0,30]
[null,"2011-07-22","Darnell Jeffs","Mowing",30,30,0]
[null,"2011-07-29","Darnell Jeffs","Mowing",30,30,0]
[null,"2011-07-09","Outback","Mowing",15,15,0]
[null,"2011-07-15","Outback","Mowing",15,0,15]
[null,"2011-07-22","Outback","Mowing",15,15,0]
[null,"2011-06-27","Arthur Welch","Mowing",25,{"$f":"E79","v":25},0,"385"]
[null,"2011-07-11","Arthur Welch","Mowing",25,0,25,"385"]
[null,"2011-07-26","Arthur Welch","Mowing",25,0,25,"385"]
[null,"2011-07-14","Parker Garlitz","Trimming bushes in front of house (5.5 hours)",{"$f":"5.5*20","v":110},null,110,"0004425406"]
[null,"2011-07-21","Parker Garlitz","Removing bushes (1.5 hours)",30,null,30,"0004425406"]
[null,"2011-07-29","Parker Garlitz","Removing bushes (4 hours)",80,null,80,"0004425406"]
[null,"2011-07-06","Lance Black","Edging",5,0,5,7087]
[null,"2011-07-12","Lance Black","Edging",5,0,5,7087]
[null,"2011-07-19","Lance Black","Edging",5,0,5,7087]
[null,"2011-07-26","Lance Black","Edging",5,0,5,7087]
[null,"2011-05-24","Bob Sabin","Mowing",20,{"$f":"E89","v":20},null,"930","But he made the check to LOM.  I'm going to try and cash it anyways."]
[null,"2011-06-06","Bob Sabin","Mowing",20,{"$f":"E90","v":20},null,"930"]
[null,"2011-06-13","Bob Sabin","Mowing",20,{"$f":"E91","v":20},null,"930","$80 of this check is for Bruce.  Just have Bruce pay me $80 less in the future.  I paid tithin on the $130 I received."]
[null,"2011-06-28","Bob Sabin","Mowing",20,{"$f":"E92","v":20},null,"930"]
[null,"2011-07-06","Bob Sabin","Mowing",20,0,20,"930"]
[null,"2011-07-12","Bob Sabin","Mowing",20,0,20,"930"]
[null,"2011-07-19","Bob Sabin","Mowing (first half)",10,0,10,"930"]
[null,"2011-08-01","Stafford","Mowing",10,0,10,"CASH"]
[null,"2011-08-09","Stafford","Mowing",10,0,10,"CASH"]
[null,"2011-08-15","Stafford","Mowing",10,0,10,"CASH"]
[null,"2011-08-22","Stafford","Mowing",10,0,10,"CASH"]
[null,null,null,null,null,{"$f":"SUM(F72:F99)","v":225},{"$f":"SUM(G72:G99)","v":425}]
[]
[]
[null,"2011-08-05","Outback","Mowing",15,15,0]
[null,"2011-08-12","Outback","Mowing",15,15,0]
[null,"2011-08-19","Outback","Mowing",15,15,0]
[null,"2011-08-29","Outback","Mowing",15,15,0]
[null,"2011-08-05","Darnell Jeffs","Mowing",30,30,0]
[null,"2011-08-12","Darnell Jeffs","Mowing",30,30,0]
[null,"2011-08-19","Darnell Jeffs","Mowing",30,30,0]
[null,"2011-08-29","Darnell Jeffs","Mowing",30,30,0]
[null,"2011-08-09","Arthur Welch","Mowing",25,0,25,"402"]
[null,"2011-08-22","Arthur Welch","Mowing",25,0,25,"402"]
[null,"2011-09-03","Arthur Welch","Mowing",25,12.5,12.5,"402",null,"$37.50 of this is for Bruce"]
[null,"2011-09-16","Arthur Welch","Mowing",25,25,null,"402"]
[null,"2011-07-19","Bob Sabin","Mowing (second half)",10,0,10,788]
[null,"2011-07-26","Bob Sabin","Mowing",20,0,20,788]
[null,"2011-08-02","Bob Sabin","Mowing",20,0,20,788]
[null,"2011-08-11","Bob Sabin","Mowing",20,0,20,788]
[null,"2011-08-23","Bob Sabin","Mowing",20,0,20,788,null,"Lavar Cardon wants us to start the Storage place now.  E-mail bills to \"Emily Humes\" with e-mail address: astoragesecret@aol.com and a carbon copy to lcardon1944@msn.com.  Address of place is 1201 W. Center, Provo, UT, Price= $20/week.  Mow his house next Spring, price for house= $45/week."]
[null,"2011-08-29","Stafford","Mowing",10,0,10,"Cash"]
[null,"2011-09-05","Stafford","Mowing",10,0,10,"Cash"]
[null,"2011-09-12","Stafford","Mowing",10,0,10,"Cash"]
[null,"2011-08-02","Lance Black","Edging",5,0,5,"1091"]
[null,"2011-08-11","Lance Black","Edging",5,0,5,"1091",null,null,{"$f":"1322.76-37.5","v":1285.26}]
[null,"2011-08-23","Lance Black","Edging",5,0,5,"1091"]
[null,null,null,null,{"$f":"SUM(E103:E125)","v":415},{"$f":"SUM(F103:F125)","v":217.5}]
[]
[]
[null,"2011-09-06","Jeffs","Mowing",30,30,0]
[null,"2011-09-14","Jeffs","Mowing",30,20,0]
[null,"2011-09-22","Jeffs","Mowing",30,30,0]
[null,"2011-09-29","Jeffs","Mowing",30,30,0]
[null,"2011-09-06","Outback","Mowing",15,15,0]
[null,"2011-09-14","Outback","Mowing",15,15,0]
[null,"2011-09-22","Outback","Mowing",15,15,0]
[null,"2011-09-29","Outback","Mowing",15,15,0]
[null,"2011-09-05","Bob Sabin","Mowing",20,0,20,"236"]
[null,"2011-09-19","Bob Sabin","Mowing",20,0,20,"236"]
[]
[null,"2011-09-24","Chuck Taylor","Mowing",50,25,25,9179,"This check was made out to LOM.  Bruce cashed it.  He owes Karl"]
[null,"2011-09-30","Chuck Taylor","Mowing",50,50,0,9179]
[null,"2011-10-23","Roger Davis","Aerating",35,35,0,11923]
[null,"2011-09-05","Lance Black","Edging",5,0,5,7169,"The check 7169 was for $20.  He has $5 credit."]
[null,"2011-09-19","Lance Black","Edging",5,0,5,7169]
[null,"2011-10-17","Lance Black","Edging",5,0,5,7169]
[null,"2011-08-27","John Czirr","Trimming",20,0,20,0,5536]
[null,"2011-10-29","John Czirr","Trimming",20,0,20,0,"5536 + $10 Cash"]

{"sheet":"Miles","index":7,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Date","Miles"]

{"sheet":"Estes","index":8,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":true,"merged":[[16,2,16,3]]}
["WorkID","Date","Customer","Service","Amount","Bruce","Ryan","Check Number"]
[null,"2011-05-10","Ben Estes","Pre-Payment",-700]
[null,"2011-05-10","Ben Estes","Mowing",25,25]
[null,"2011-05-11","Ben Estes","Mowing",25,25]
[null,"2011-05-16","Ben Estes","Mowing",25,{"$f":"E5","v":25}]
[null,"2011-05-19","Ben Estes","Cutting Edge",15,15]
[null,"2011-05-24","Ben Estes","Mowing",25,25]
[null,"2011-05-24","Ben Estes","Pruning",25,25]
[null,"2011-05-28","Ben Estes","Weeding/Cutting Edge",40,40]
[null,"2011-05-31","Ben Estes","Mowing",25,25]
[null,"2011-06-01","Ben Estes","Weeding",7.5,7.5]
[null,"2011-06-13","Ben Estes","Mowing",25,{"$f":"E12","v":25}]
[null,"2011-06-06","Ben Estes","Mowing",25,25]
[null,"2011-06-13","Ben Estes","Spraying Weeds",25,25]
[null,"2011-06-21","Ben Estes","Mowing",25,25]
[null,"2011-06-25","Ben Estes","Weeding",7.5,7.5]
[null,"2011-06-26","Tithing",null,0,0,"Recognized $320 for tithing"]
[null,"2011-06-27","Ben Estes","Mowing",25,25]
[null,"2011-06-28","Ben Estes","Weeding/Rototilling/Installing Fabric",{"$f":"15*5","v":75},75]
[null,"2011-07-06","Ben Estes","Mowing",25,0,25]
[null,"2011-07-12","Ben Estes","Mowing",25,0,25]
[null,"2011-07-19","Ben Estes","Mowing",25,0,25]
[null,"2011-07-26","Ben Estes","Mowing",25,0,25]
[null,"2011-08-11","Ben Estes","Mowing",25,0,25,null,"Paid Ryan for all of Estes' with check#1115"]
[null,"2011-08-13","Ben Estes","Spraying Weeds on sidewalk and west of driveway",15,0,15]
[null,"2011-08-14","Tithing",null,0,0,"Recognized tithing for everything above"]
[null,"2011-08-23","Ben Estes","Mowing",25,0,25]
[null,"2011-08-25","Tithing",null,0,0,"Recognized tithing for everything above"]
[null,"2011-09-05","Ben Estes","Mowing",25,0,25]
[null,"2011-09-26","Ben Estes","Mowing",25,0,25]
[null,"2011-10-17","Ben Estes","Mowing",25,0,25]
[]
[]
[null,null,null,"Funds Remaining",{"$f":"SUM(E2:E31)","v":-40}]

{"sheet":"Sheet1","index":9,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Bruce",{"$f":"SUM('Non LOM Paid'!F62:F65,'Non LOM Paid'!F79:F79,#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]

{"sheet":"Bill","index":10,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[24,2,24,4],[25,2,25,4],[26,2,26,4],[14,2,14,4],[31,1,33,5],[23,2,23,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[0,1,0,2],[15,2,15,4],[16,2,16,4],[21,2,21,4],[22,2,22,4]]}
[null,"Lawn-O-Matic",null,null,"Invoice"]
[null," Professional Lawncare Service"]
[null," 975 E 800 N"]
[null," Mapleton, UT 84664"]
[]
[]
[]
[null," Bill To"]
[null,"Suzanne Ricks"]
[null,"426 N. 150 W.",null,null,"Invoice Date:",{"$f":"NOW()","v":"2011-12-08T10:44:24.190"}]
[null,"Mapleton, UT 84664",null,null,"Due Date:",{"$f":"F10+15","v":"2011-12-23T10:44:24.190"}]
[]
[]
[]
[null,"Date","Service",null,null,"Amount"]
[null,"2011-11-04","Edging",null,null,5]
[null,"2011-11-11","Edging",null,null,5]
[null,"2011-11-18","Edging",null,null,5]
[null,"2011-11-25","Edging",null,null,5]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Balance Due:",{"$f":"SUM(F16:F27)","v":20}]
[]
[]
[]
[null,"Payment is due 15 days from the invoice date.  Late payments will result in a $10 late fee.  Please make all checks payable to \"Lawn-O-Matic\".  If you have any questions concerning your bill, please call us at (801)-427-2642."]

{"sheet":"Payments","index":11,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Customer","Date","Check Number","Amount"]
["Lance Kirkland","2011-11-07","4582",75]
["Lance Kirkland","2011-11-07","4567",75]
["Brian Jensen","2011-11-07","7642",200]

{"sheet":"Customers","index":12,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["CustomerName","Active Customer","Day","Freqency","Amount","Service","Address","City","State","Zip","Phone","Email"]
["Amy Lundmark","Y","Monday","Weekly",30,"Mowing","955 N. 130 E.","Springville","UT",84663,"801-489-7557"]
["Arthur Waite","Y","Wednesday","Weekly",25,"Mowing","452 S. 900 E.","Mapleton","UT",84664,"801-489-2866"]
["Ben Jones","Y","Monday","Weekly",45,"Mowing","910 N. 600 E.","Mapleton","UT",84664,"801-489-7853"]
["Bob Kopps","Y","Wednesday","Weekly",20,"Mowing","975 E. 800 N.","Mapleton","UT",84664,"801-491-3785"]
["Brian Jensen","Y","Monday","Weekly",55,"Mowing","401 E. 1200 N.","Mapleton","UT",84664,"801-491-9625"]
["Daniel Childs","Y","Wednesday","Weekly",30,"Mowing","1532 E. 900 S.","Springville","UT",84663,"801-491-8564"]
["Dian Parks","Y","Wednesday","Weekly",30,"Mowing","142 E. 950 S.","Springville","UT",84663,"801-489-4658"]
["Garrett Wall","Y","Wednesday","Weekly",3.75,"Edging","148 E. 950 S.","Springville","UT",84663,""]
["Harvey Maw","Y","Wednesday","Weekly",30,"Mowing","689 N. 1200 E.","Mapleton","UT",84664,"801-489-8978"]
["Jan Temple","Y","Wednesday","Weekly",30,"Mowing","2892 Oneida Ln","Provo","UT",84606,"801-375-6571"]
["Jeff Dewey","Y","Friday","Weekly",25,"Mowing","1078 S. 600 E.","Springville","UT",84663,"801-491-3159"]
["John Paulsen","Y","Monday","Weekly",45,"Mowing","130 S. 400 E.","Mapleton","UT",84664,"801-489-8834"]
["Lance Kirkland","Y","Friday","Weekly",5,"Edging","398 N. 800 W.","Mapleton","UT",84664,"801-491-7534"]
["Linda Brockbank","Y","Monday","Weekly",25,"Mowing","6231 N. 800 E.","Mapleton","UT",84664,"801-491-1564"]
["Parker Call","Y","Friday","Weekly",25,"Mowing","558 S. 400 E.","Mapleton","UT",84664,""]
["Richard Allen","Y","Monday","Weekly",30,"Mowing","168 E. 970 S.","Springville","UT",84663,""]
["Ron Applegate","Y","Monday","Weekly",30,"Mowing","210 E. 1600 S.","Mapleton","UT",84664]
["Rusty Jenkins","Y","Friday","Weekly",30,"Mowing","462 W. 1200 N.","Mapleton","UT",84664,"801-491-9145"]
["Shirley Clark","Y","Friday","Weekly",7.5,"Edging","449 S. 400 W.","Mapleton","UT",84664,""]
["Susan Singley","Y","Friday","Weekly",30,"Mowing","1239 W. 750 S.","Springville","UT",84663,"801-491-8615"]
["Suzanne Ricks","Y","Friday","Weekly",5,"Edging","426 N. 150 W.","Mapleton","UT",84664,"801-489-7248"]
["stop"]

{"sheet":"Sent","index":13,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Date Sent","Customer","File Name"]
["Bad Email","Suzanne Ricks","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Suzanne Ricks_Nov.pdf"]
["2011-11-25T12:33:46","Brian Jensen","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Brian Jensen_Nov.pdf"]
["2011-11-25T12:33:52","Daniel Childs","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Daniel Childs_Nov.pdf"]
["2011-11-25T12:33:58","Dian Parks","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Dian Parks_Nov.pdf"]
["2011-11-25T12:34:09","Garrett Wall","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Garrett Wall_Nov.pdf"]
["2011-11-25T12:34:15","Harvey Maw","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Harvey Maw_Nov.pdf"]
["2011-11-25T12:34:21","Jan Temple","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Jan Temple_Nov.pdf"]
["2011-11-25T12:34:27","Jeff Dewey","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Jeff Dewey_Nov.pdf"]
["2011-11-25T12:34:34","John Paulsen","C:\\Users\\Sommerfeldts\\Documents\\LOM\\John Paulsen_Nov.pdf"]
["2011-11-25T12:34:40","Lance Kirkland","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Lance Kirkland_Nov.pdf"]
["2011-11-25T12:34:47","Linda Brockbank","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Linda Brockbank_Nov.pdf"]
["2011-11-25T12:34:55","Richard Allen","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Richard Allen_Nov.pdf"]
["2011-11-25T12:35:01","Rusty Jenkins","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Rusty Jenkins_Nov.pdf"]
["2011-11-25T12:35:07","Shirley Clark","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Shirley Clark_Nov.pdf"]
["2011-11-25T12:35:13","Susan Singley","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Susan Singley_Nov.pdf"]
["2011-11-25T12:35:20","Suzanne Ricks","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Suzanne Ricks_Nov.pdf"]
["2011-11-25T12:52:56","Bob Kopps","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Bob Kopps_Nov.pdf"]
["2011-11-25T14:24:17","Suzanne Ricks","C:\\Users\\Sommerfeldts\\Documents\\LOM\\Suzanne Ricks_Nov.pdf"]

{"sheet":"Settings","index":14,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Save to Folder:","C:\\Users\\Sommerfeldts\\Documents\\LOM"]