{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Internal Jobs","Contingency Jobs","Commissions and Reserves","Commissions Apr 14","Basic Info","Pay Scale"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":1},"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":"Internal Jobs","index":0,"n_rows":99,"n_cols":25,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
["Job Name","Profession","Recruiter","Date Created","Date Revised","Revision Notes","Job Market","Job Order Age","Full-time or Part Time","Status","Candidate Hired","Date Placed","Days to hire","Start Date","Hourly Wage","Years' Experience","Target Wage","Gross Commission","Manual Increase/Decrease","Explanation","Net Commission","Commission Payable ","Paid?","Start Date Verified By","Over 45 Days?"]
["Handmaker COTA Dec 2013","COTA","Cameron","2013-12-13",null,null,"Tucson",37,"Full-Time","Filled","Anastacio Castro","2014-01-19",37,"2014-01-29",23,"new grad",24,400,null,null,400,"2014-04-10","Yes","David","No"]
["Burien PTA Jan 2014","PTA","David","2014-01-15",null,null,"Seattle",19,"Full-Time","Filled","Sam Mabee","2014-02-03",19,"2014-02-03",24,"new grad",25,575,null,null,575,"2014-04-10","Yes","David","No"]
["Orchard Park OT Nov 2013","OT","Seth","2013-11-07",null,null,"Salt Lake",87,"Full-Time","Filled","Daniel Bolton","2014-02-02",87,"2014-02-05",37,">10",37,300,null,null,300,"2014-04-10","Yes","David","No"]
["Logan Square PTA Sep 2013","PTA","David","2013-09-09",null,null,"Philadelphia",138,"Full-Time","Filled","Belinda Rocchi","2014-01-25",138,"2014-02-06",31,"7-8",31,475,null,null,475,"2014-04-10","Yes","David","No"]
["Logan Square PT Jan 2014","PT","Seth","2014-01-21",null,null,"Philadelphia",15,"Full-Time","Filled","Amy McDougal","2014-02-05",15,"2014-02-24",32,"New Grad",33,400,null,null,400,"2014-05-10","Yes","David","No"]
["Watermark 3030 OT Feb 2014","OT","David","2014-02-26",null,null,"Connecticut",6,"Full-Time","Filled","MaryJo DiCreiscenzo","2014-03-04",6,"2014-03-10",33,"New Grad",34,575,null,null,575,"2014-05-10","Yes","David","No"]
["Handmaker PT ","PT","Seth","2014-02-12",null,null,"Tucson",7,"Part-time","Filled","Leah Shoemaker","2014-02-19",7,"2014-03-17",44,">10",44,300,null,null,300,"2014-05-25","Yes","David","No"]
["Legacy Pointe COTA Feb 2014","COTA","David","2014-02-19",null,null,"Des Moines",32,"Full-Time","Filled","Christine Columbus","2014-03-23",32,"2014-04-07",25,"3-4",25,475,null,null,475,"2014-06-10","Yes","David","No"]
["Madrid COTA Oct 2013","COTA","David","2013-11-30",null,null,"Des Moines",89,"Full-Time","Filled","Kiona Voland","2014-02-27",89,"2014-04-15",25,"3-4",25,475,null,null,475,"2014-06-25","Yes","David","No"]
["Washington House COTA James Curtis","COTA","David","2014-05-01",null,null,"Alexandria",8,"Full-Time","Filled","James 'Dusty' Curtis","2014-05-09",8,"2014-05-09",27,"1-2",28,575,null,null,575,"2014-07-10","Yes","David","No"]
["Watermark at 3030 Park COTA Feb 2014","COTA","Seth","2014-02-26",null,null,"Connecticut",12,"Full-Time","Filled","Susan Begley","2014-03-10",12,"2014-05-29",25,"new grad",26,400,null,null,400,"2014-08-10","Yes","David","No"]
["Fountains at Canterbury SLP Feb 2014","SLP","Seth","2014-02-05",null,null,"Oklahoma City",26,"Full-Time","Filled","Keri Waggoner","2014-03-03",26,"2014-06-09",29,"new grad",30,400,null,null,400,"2014-08-10","Yes","David","No"]
["Madrid Legacy Pointe SLP Floater May 2014","SLP","David","2014-05-19",null,null,"Des Moines",7,"Full-Time","Filled","Samantha McElhinney","2014-05-26",7,"2014-06-09",31,"new grad",32,575,null,null,575,"2014-08-10","Yes","David","No"]
["Oklahoma City PTA April 2014","PTA","Seth","2014-04-28",null,null,"Oklahoma City",22,"Full-Time","Filled","Kerry Arneson","2014-05-20",22,"2014-06-09",22,"new grad",24,500,150,"This placement is a replacement for Darren Rose who did not last 6 mos on the job. Darren was $28.50 and the replacement was $22 so owners agreed to pay the difference in a commission which equated to $650 (28.50-22=6.50 x 100)",650,"2014-08-10","Yes","David","No"]
["The Peaks PTA May 2014","PTA","David","2014-05-09",null,null,"Salt Lake",24,"Full-Time","Filled","Sarah Smith","2014-06-02",24,"2014-06-09",22,"1-2",22,475,null,null,475,"2014-08-10","Yes","David","No"]
["Philadelphia COTA May 2014","COTA","David","2014-05-07",null,null,"Philadelphia",25,"Full-Time","Filled","Marquis Bourne","2014-06-01",25,"2014-06-10",27,"1-2",28,575,null,null,575,"2014-08-10","Yes","David","No"]
["Handmaker SLP Jan 2014","SLP","Seth","2014-01-19",null,null,"Tucson",84,"Full-Time","Filled","Mikaela Burns","2014-04-13",84,"2014-06-16",33,"new grad",31,100,200,"Target wage too low",300,"2014-08-25","Yes","David","No"]
["Washington House OT","OT","Seth","2014-04-04",null,null,"Alexandria",46,"Full-Time","Filled","Sun Park","2014-05-20",46,"2014-06-16",34,"new grad",33,200,null,null,200,"2014-08-25","Yes","David","No"]
["Issaquah PT Mar 2014","PT","David","2014-03-27",null,null,"Seattle",35,"Full-Time","Filled","Michael Zarate","2014-05-01",35,"2014-06-19",35,"new grad",32,175,null,null,175,"2014-08-25","Yes","David","No"]
["Washington House COTA/OT Apr 2014","OT","Seth","2014-04-08",null,null,"Alexandria",42,"Full-Time","Filled","Linda Huang","2014-05-20",42,"2014-06-23",34,"new grad",33,200,null,null,200,"2014-08-25","Yes","David","No"]
["Washington House PTA May 2014","PTA","Seth","2014-05-06",null,null,"Alexandria",14,"Full-Time","Filled","Eden Massey","2014-05-20",14,"2014-06-23",24,"new grad",26,500,null,null,500,"2014-08-25","Yes","David","No"]
["Utah Facilities PTA Floater May 2014","PTA","David","2014-05-20",null,null,"Salt Lake",22,"Full-Time","Filled","Amber Meyer","2014-06-11",22,"2014-06-30",23,"1-2",23,475,null,null,475,"2014-09-10","Yes","David","No"]
["Outpatient Clinic PT Seattle June 2014","PT","David","2014-06-20",null,null,"Seattle",11,"Full-Time","Filled","Michele Gill","2014-07-01",11,"2014-07-07",43,">10",43,475,null,null,475,"2014-09-10","Yes","David","No"]
["Outpatient OT Seattle June 2014","OT","David","2014-06-13",null,null,"Seattle",17,"Full-Time","Filled","Lauren Sayoc","2014-06-30",17,"2014-07-07",34,"new grad",32,275,200,"Darin agreed to pay Lauren more because she will float between buildings and Lifecare offered her arount $35/hour",475,"2014-09-10","Yes","David","No"]
["Utah Facilities SLP June 2014","SLP","David","2014-06-10",null,null,"Salt Lake",22,"Full-Time","Filled","Andrea Smith","2014-07-02",22,"2014-07-10",30,"new grad",30,475,null,null,475,"2014-09-10","Yes","David","No"]
["Handmaker OT Feb 2014","OT","Seth","2014-02-27",null,null,"Tucson",54,"Full-Time","Filled","Breanna Hardy","2014-04-22",54,"2014-07-21",33,"new grad",33,300,null,null,300,"2014-09-25","Yes","David","No"]
["Philadelphia PTA May 2014","PTA","David","2014-05-06",null,null,"Philadelphia",14,"Full-Time","Filled","Danielle Hannon","2014-05-20",14,"2014-07-21",24,"new grad",26,675,null,null,675,"2014-09-25","Yes","David","No"]
["Seattle Outpatient PTA August 2014","PTA","Seth","2014-07-30",null,null,"Seattle",2,"Full-Time","Filled","Steve Yonck","2014-08-01",2,"2014-08-06",27.5,"1-2",27,250,null,null,250,"2014-10-10","Yes","David","No"]
["Washington House PTA July 2014","PTA","David","2014-07-10",null,null,"Alexandria",19,"Full-Time","Filled","Mary Berkley","2014-07-29",19,"2014-08-10",25,"new grad",26,575,null,null,575,"2014-10-10","Yes","David","No"]
["Burien COTA Aug 2014","COTA","David","2014-08-11",null,null,"Seattle",9,"Full-Time","Filled","Chantel Wieber","2014-08-20",9,"2014-08-25",23.5,"new grad",25,625,null,null,625,"2014-10-25","Yes","David","No"]
["Immanuel DOR OT/PT","PT","David","2014-07-21",null,null,"Phoenix",16,"Full-Time","Filled","Lisa Rigazio","2014-08-06",16,"2014-09-01",42,">10",43,575,null,null,575,"2014-11-10","Yes","David","No"]
["Scottsdale Village Square PTA Aug 2014","PTA","Seth","2014-08-11",null,null,"Phoenix",7,"Full-Time","Filled","Alison Salone","2014-08-18",7,"2014-09-02",25.5,"1-2",27,450,null,null,450,"2014-11-10","Yes","David","No"]
["Immanuel COTA Aug 2014","COTA","David","2014-08-11",null,null,"Tucson",11,"Full-Time","Filled","Jack Turner","2014-08-22",11,"2014-09-03",25,"new grad",24,375,null,null,375,"2014-11-10","Yes","David","No"]
["Philadelphia OT Aug 2014","OT","Seth","2014-08-13",null,null,"Philadelphia",20,"Full-Time","Filled","Sara Montgomery","2014-09-02",20,"2014-09-08",32,"new grad",33,400,null,null,400,"2014-11-10","Yes","David","No"]
["Burien PT Apr 2014","PT","David","2014-04-18",null,null,"Seattle",0,"Full-Time","Filled","Jenny Lewellen","2014-04-18",0,"2014-09-15",32,"new grad",32,475,null,null,475,"2014-11-25","Yes","David","No"]
["Philadelphia COTA Aug 2014","COTA","David","2014-08-15",null,null,"Philadelphia",18,"Full-Time","Filled","Megan Keel","2014-09-02",18,"2014-09-22",24,"new grad",26,675,null,null,675,"2014-11-25","Yes","David","No"]
["Pacific Regent COTA Sep 2014","COTA","David","2014-09-08",null,null,"Seattle",8,"Full-Time","Filled","Christopher Cargo","2014-09-16",8,"2014-10-15",24.5,"new grad",25,525,null,null,525,"2014-12-25","Yes","David","No"]
["Village at Legacy Pointe PT Sep 2014","PT","Seth","2014-09-08",null,null,"Des Moines",12,"Full-Time","Filled","Kristy Harken","2014-09-20",12,"2014-10-15",37,"3-4",36,200,null,null,200,"2014-12-25","Yes","David","No"]
["La Mesa DOR Oct 2014","OT","David","2014-10-05",null,null,"Yuma",20,"Full-Time","Filled","Daena Gibby Gibson","2014-10-25",20,"2014-11-01",41,">10",41,475,null,null,475,"2015-01-10","Yes","David","No"]
["La Mesa PTA Oct 2014","PTA","David","2014-10-02",null,null,"Yuma",18,"Full-Time","Filled","Amanda Vaughan Holly Kuhn","2014-10-20",18,"2014-11-01",29,"9-10",30,575,null,"Holly Kuhn started Nov 1, Amanda starts 1 Jan 2015",575,"2015-01-10","Yes","David","No"]
["Sunshine Terrace COTA Oct 2014 #1","COTA","Seth","2014-10-01",null,null,"Salt Lake",14,"Full-Time","Filled","Jamie McIntosh","2014-10-15",14,"2014-11-01",24,"1-2",22,100,200,"Timing/candidate",300,"2015-01-10","Yes","David","No"]
["Sunshine Terrace COTA Oct 2014 #2","COTA","Seth","2014-10-01",null,null,"Salt Lake",19,"Full-Time","Filled","Brandy Dansie","2014-10-20",19,"2014-11-01",22,"1-2",22,300,null,null,300,"2015-01-10","Yes","David","No"]
["Sunshine Terrace DOR","OT","Seth","2014-10-01",null,null,"Salt Lake",14,"Full-Time","Filled","Ryan Winn","2014-10-15",14,"2014-11-01",37,">10",37,300,null,null,300,"2015-01-10","Yes","David","No"]
["Sunshine Terrace PT Oct 14 #1","PT","Seth","2014-10-01",null,null,"Salt Lake",14,"Full-Time","Filled","Richard Penrod","2014-10-15",14,"2014-11-01",38,">10",37,200,100,"Timing/candidate",300,"2015-01-10","Yes","David","No"]
["Sunshine Terrace PTA Oct 14 #1","PTA","Seth","2014-10-02",null,null,"Salt Lake",13,"Full-Time","Filled","David Worthington","2014-10-15",13,"2014-11-01",25,"7-8",24,200,100,"Timing/candidate",300,"2015-01-10","Yes","David","No"]
["Sunshine Terrace PTA Oct 14 #2","PTA","Seth","2014-10-02",null,null,"Salt Lake",13,"Full-Time","Filled","Chelsea Post","2014-10-15",13,"2014-11-01",23,"3-4",23,300,null,null,300,"2015-01-10","Yes","David","No"]
["Sunshine Terrace PTA Oct 14 #3","PTA","Seth","2014-10-02",null,null,"Salt Lake",13,"Full-Time","Filled","Erin Kohl","2014-10-15",13,"2014-11-01",23,"3-4",23,300,null,null,300,"2015-01-10","Yes","David","No"]
["Sunshine Terrace COTA Part-time","COTA","Seth","2014-10-01",null,null,"Salt Lake",19,"Part-time","Filled","Mary Gainer","2014-10-20",19,"2014-11-03",25,">10",25,300,null,null,300,"2015-01-10","Yes","David","No"]
["Fountains at Washington House PTA Oct 2014","PTA","David","2014-11-10",null,null,"Alexandria",4,"Full-Time","Filled","Nicole Holt","2014-11-14",4,"2014-11-17",28,"1-2",28,475,null,null,475,"2015-01-25","Yes","David","No"]
["Splendido COTA Oct 2014","COTA","Seth","2014-10-01",null,null,"Tucson",31,"Full-Time","Filled","Jamie Hyler","2014-11-01",31,"2014-11-17",25,"1-2",25,300,null,null,300,"2015-01-25","Yes","David","No"]
["Splendido DOR","PT","David","2014-10-01",null,null,"Tucson",24,"Full-Time","Filled","Tim Pate","2014-10-25",24,"2014-11-17",41,">10",41,475,null,null,475,"2015-01-25","Yes","David","No"]
["Splendido PTA Oct 2014","PTA","David","2014-10-02",null,null,"Tucson",15,"Full-Time","Filled","Barbara Garate","2014-10-17",15,"2014-11-17",27,"3-4",26,375,100,"Timing/candidate",475,"2015-01-25","Yes","David","No"]
["La Mesa COTA Oct 2014","COTA","Seth","2014-10-20",null,null,"Yuma",12,"Full-Time","Filled","Barbara Berg","2014-11-01",12,"2014-11-18",27,"3-4",26,200,100,"Desperate- approved higher wage",300,"2015-01-25","Yes","David","No"]
["Pacific Regent PT Oct 2014","PT","David","2014-10-25",null,null,"Seattle",16,"Full-Time","Filled","Ramya Prenchand","2014-11-10",16,"2014-11-19",38,"5-6",38,475,null,null,475,"2015-01-25","Yes","David","No"]
["Issaquah COTA Nov 2014","COTA","David","2014-11-20",null,null,"Seattle",0,"Full-Time","Filled","Martha Ross","2014-11-20",0,"2014-12-01",26,"1-2",27,575,null,null,575,"2015-02-10","Yes","David","No"]
["Scottsdale Village Square SLP Sept 2014","SLP","Seth","2014-09-03",null,null,"Phoenix",56,"Full-Time","Filled","Heather Haas","2014-10-29",56,"2014-12-02",32,"new grad",32,300,null,null,300,"2015-02-10","No","David","No"]
["Splendido OT Oct 2014","OT","David","2014-10-02",null,null,"Tucson",43,"Full-Time","Filled","Suzanne Young","2014-11-14",43,"2014-12-06",41,">10",41,475,null,null,475,"2015-02-10","Yes","David","No"]
["Fountains at Canterbury OT Dec 2014","OT","David","2014-12-01",null,null,"Oklahoma City",2,"Part-time","Filled","Sofia Hoang","2014-12-03",2,"2014-12-08",50,">10",43,-225,null,null,100,"2015-02-10","Yes","David","No"]
["Fountains at Washington House SLP Nov 2014","SLP","David","2014-11-01",null,null,"Alexandria",25,"Full-Time","Filled","Nadine Joslin","2014-11-26",25,"2014-12-09",35,"new grad",33,275,null,null,275,"2015-02-10","Yes","David","No"]
["3030 Park SLP Dec 2014","SLP","David","2014-12-30",null,null,"Connecticut",0,"Full-Time","Filled","Aleeza Zeiger","2014-12-30",0,"2014-12-13",44,">10",44,475,null,null,475,"2015-02-25","Yes","David","No"]
["Cascades DOR Oct 2014","PT","David","2014-10-17",null,null,"Salt Lake",15,"Full-Time","Filled","Matt London","2014-11-01",15,"2014-12-15",37,">10",37,475,null,null,475,"2015-02-25","Yes","David","No"]
["Immanuel DOR Oct 2014","PT","David","2014-10-10",null,null,"Phoenix",49,"Full-Time","Filled","Shannon Halstead","2014-11-28",49,"2014-12-29",38,"5-6",38,475,null,null,475,"2015-03-10","Yes",null,"No"]
["Fountains at Canterbury COTA Nov 2014","COTA","David","2014-11-28",null,null,"Oklahoma City",5,"Full-Time","Filled","LaDawn Christopher","2014-12-03",5,"2015-01-01",32,">10",32,475,null,null,475,"2015-03-10","Yes",null,"No"]
["Sunshine Terrace PT Oct 14 #2","PT","Seth","2014-10-15",null,null,"Salt Lake",26,"Full-Time","Filled","Candace Gunnell","2014-11-10",26,"2015-01-01",33,"1-2",31,100,200,"Timing/candidate",300,"2015-03-10","Yes",null,"No"]
["Sunshine Terrace SLP Oct 14","SLP","Seth","2014-10-01",null,null,"Salt Lake",21,"Full-Time","Filled","Annie Jorgenson","2014-10-22",21,"2015-01-01",31,"new grad",30,200,100,null,300,"2015-03-10","Yes",null,"No"]
["Scottsdale Nursing OT ","OT","Seth","2014-12-01",null,null,"Phoenix",9,"Full-Time","Filled","Samantha Singler","2014-12-10",9,"2015-01-19",35,"5-6",38,600,null,null,600,"2015-03-25","No","David","No"]
["Seattle Outpatient PTA Brookdale/1st Hill Jan 15","PTA","David","2015-01-10",null,null,"Seattle",0,"Full-Time","Filled","Marissa Doohan","2015-01-10",0,"2015-01-19",27.5,"1-2",27,425,null,null,425,"2015-03-25","No","David","No"]
["Seattle Outpatient Overlake Terrace PTA Dec 2014","PTA","David","2014-12-30",null,null,"Seattle",9,"Full-Time","Filled","Bobbi Arnold","2015-01-08",9,"2015-01-22",24.5,"new grad",25,525,null,null,525,"2015-03-25","No","David","No"]
["La Mesa PTA #2 Jan 2015","PTA","Seth","2015-01-10",null,null,"Tucson",12,"Full-Time","Filled","Jennifer Kalas","2015-01-22",12,"2015-01-26",25,"1-2",25,300,0,"bosses said get one at any price",300,"2015-04-10","No","David","No"]
["Scottsdale Nursing OT Dec 14 #2","OT","Seth","2014-12-01",null,null,"Phoenix",30,"Full-Time","Filled","Margie Maples","2014-12-31",30,"2015-01-26",41,">10",43,500,null,null,500,"2015-04-10","No","David","No"]
["Cascades COTA #1","COTA","Seth","2014-12-20",null,null,"Salt Lake",10,"Full-Time","Filled","Tasha Thomas","2014-12-30",10,"2015-01-27",23,"3-4",23,300,null,null,300,"2015-04-10","No","David","No"]
["La Mesa PT Oct 2014","PT","Seth","2014-10-02",null,null,"Yuma",43,"Full-Time","Filled","Jarom Woodbury","2014-11-14",43,"2015-02-01",40,"new grad",34,-300,100,"Desperate-location and timing",100,"2015-04-10","No","David","No"]
["Arbor Village PTA Jan 2015","PTA","David","2015-01-16",null,null,"Seattle",5,"Full-Time","Filled","Mary Klueber","2015-01-21",5,"2015-02-02",28,"3-4",28,475,null,null,475,"2015-04-10","No","David","No"]
["La Mesa PTA #1 Jan 2015","PTA","Seth","2015-01-05",null,null,"Tucson",17,"Full-Time","Filled","Tami Otey","2015-01-22",17,"2015-02-02",29,"3-4",26,0,300,"Bosses said get one at any price",300,"2015-04-10","No","David","No"]
["Burien PTA Part-time Jan 2015","PTA","Seth","2015-01-21",null,null,"Seattle",1,"Part-time","Filled","Tim Rowe","2015-01-22",1,"2015-02-09",23,"new grad",25,500,-250,"part time commish plus $100 for under bogey",250,"2015-04-25","No","David","No"]
["Cascades PT Nov 2014","PT","David","2014-12-01",null,null,"Salt Lake",0,"Full-Time","Filled","Matt Brady","2014-12-01",0,"2015-02-15",31,"1-2",31,475,null,null,475,"2015-04-25","No","David","No"]
["Outpatient Seattle Overlake and Sunrise COTA Jan 2015","COTA","David","2015-01-15",null,null,"Seattle",8,"Full-Time","Filled","Whitney Freygang","2015-01-23",8,"2015-02-16",28,"1-2",27,375,100,"Outpatient pays more",475,"2015-04-25","No","David","No"]
["Fountains at Canterbury PTA Dec 2014",null,"David","2014-12-01",null,null,"Oklahoma City",65,"Full-Time","Filled","Kristi Ray","2015-02-04",65,"2015-02-19",32,">10",32,475,null,null,475,"2015-04-25","No","David","No"]
["Cascades OT Nov 2014","OT","Seth","2014-11-17",null,null,"Salt Lake",39,"Full-Time","Filled","Amanda Peterson","2014-12-26",39,"2015-02-23",30,"new grad",31,400,null,null,400,"2015-04-25","No","David","No"]
["Village Green OT Jan 2015","OT","Seth","2015-01-12",null,null,"Seattle",30,"Full-Time","Filled","Elizabeth Beane","2015-02-11",30,"2015-02-16",45,">10",43,100,null,null,100,"2015-04-25","No","David","No"]
["Cascades PTA #1 Dec 2014","PTA","David","2014-12-15",null,null,"Salt Lake",28,"Full-Time","Filled","Sabina Boies","2015-01-12",28,"2015-03-01",21.5,"3-4",22,525,null,null,525,"2015-05-10","No","David","No"]
["Cascades PTA #2 Dec 2014","PTA","David","2014-12-15",null,null,"Salt Lake",28,"Full-Time","Filled","Brittany Bailey","2015-01-12",28,"2015-03-01",23.5,"7-8",24,525,null,null,525,"2015-05-10","No","David","No"]
["Cascades OT #2 Dec 2014","OT","David","2014-12-15",null,null,"Salt Lake",58,"Full-Time","Filled","Diana Irick","2015-02-11",58,"2015-03-01",33.5,"3-4",33,425,50,"revising wages upward in UT",475,"2015-05-10","No","David","No"]
["Cascades PTA #3","PTA","David","2015-02-04",null,null,"Salt Lake",0,"Full-Time","Filled","Brian Hudson","2015-02-04",0,"2015-04-15",25,"5-6",25,475,null,null,475,"2015-06-25","No","David","No"]
["Arbor Village COTA Jan 2015","COTA","David","2015-01-19",null,null,"Seattle",85,"Full-Time","Closed Unfulfilled",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["Issaquah OT Dec 2014","OT","David","2014-12-25",null,null,"Seattle",64,"Full-Time","Filled","Adam Whaley","2015-02-27",64,"2015-03-02",36,"1-2",34,275,null,null,275,"2015-05-10","No","David","No"]
["La Mesa COTA #1 Jan 2015","COTA","David","2015-01-13",null,null,"Tucson",91,"Full-Time","Closed Unfulfilled",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["La Mesa COTA #2 Jan 2015","COTA","David","2015-01-14",null,null,"Tucson",90,"Full-Time","Closed Unfulfilled",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["Sun Valley OT Dec 2014","OT","Seth","2014-12-03",null,null,"Salt Lake",74,"Full-Time","Filled","Rob Semon","2015-02-15",74,"2015-03-26",48,"5-6",34,-1100,null,null,100,"2015-06-10","No",null,"No"]
["Village at Legacy Pointe PTA Jan 2015","PTA","Seth","2015-01-09",null,null,"Des Moines",35,"Full-Time","Filled","Shawn Reinert","2015-02-13",35,"2015-03-02",20,"new grad",23,600,null,null,600,"2015-05-10","No",null,"No"]
["Immanuel OT part-time Jan 2015","OT","Seth","2015-01-31",null,null,"Phoenix",17,"Part-Time","Filled","Brad McCallister","2015-02-17",17,"2015-02-23",40,"3-4",36,-100,null,null,100,"2015-04-25","No",null,"No"]
["Daystar Village Green PTA Feb 2015","PTA","David","2015-02-18",null,null,"Seattle",7,"Full-Time","Filled","Brenda Shaffer","2015-02-25",7,"2015-03-01",31,">10",31,475,null,null,475,"2015-05-10","No",null,"No"]
["Cascades COTA Mar 2015","COTA","Seth","2015-03-02",null,null,"Salt Lake",43,"Full-Time","Open",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
["Fountains at Bronson Place PT Mar 2015","PT","David","2015-03-02",null,null,"Kalamazoo",23,"Full-Time","Filled","Carmen Manning","2015-03-25",23,"2015-04-27",42,">10",42,475,null,null,475,"2015-07-10","No",null,"No"]
["Burien PT Mar 2015","PT","David","2015-03-04",null,null,"Seattle",41,"Full-Time","Open",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
["Burien OT Mar 2015","OT","Seth","2015-03-04",null,null,"Seattle",39,null,"Open","ASDF","2015-04-12",39,"2015-03-11",23,"1-2",34,1400,null,null,1400,"2015-05-25","No",null,"No"]
["iausldf","PT","Seth","2015-04-14",null,null,"Kalamazoo",0,"Full-Time","Open","Spanky","2015-04-14",0,"2015-04-23",29,"3-4",36,1000,null,null,1000,"2015-06-25","No",null,"No"]
["thssuusuu","OT","David","2015-04-14",null,null,"Tucson",0,"Full-Time","Open","thestuff","2015-04-14",0,"2015-04-23",33,"7-8",39,1075,null,null,1075,"2015-06-25","No",null,"No"]

{"sheet":"Contingency Jobs","index":1,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Job Name","Recruiter ","Date Created","Client Company","Candidate Hired","Date Placed","Fee Earned","Net Commission ","Start Date","Fee Due Date","Date Fee Received From Client","Commission Payable Date","Paid?","Start Date Verified By"]
["People's Injury Network PT","Seth","2014-02-01","Peoples Injury Network","Maria Bokor","2014-02-19",7000,2450,"2014-03-19","2014-04-18","2014-04-18","2014-04-25","Yes","David"]
["Westmoreland Rehab PT","David","2014-03-31","Cambridge Healthcare","Ruth Will","2014-04-17",5000,1750,"2014-05-05","2014-06-04","2014-05-19","2014-05-25","Yes","David"]
["Synertx OT","Seth","2014-04-01","Synertx","Christian Jackson","2014-05-01",3500,1225,"2014-07-07","2014-08-06","2014-08-27","2014-09-10","Yes","David"]
["Spanish Fork Nursing DON","David","2014-04-20","Spanish Fork Nursing","Jet Scorsone","2014-05-02",1360,475.99999999999994,"2014-05-11","2014-06-10","2014-06-01","2014-06-10","Yes","David"]
["Independence Rehab Dir of Business Dev","David","2014-06-25","Independence Rehab","Julie Anderson","2014-07-04",10000,3500,"2014-07-07","2014-08-06","2014-08-07","2014-08-10","Yes","David"]
["North American Park West PT","David","2014-08-18","North American","Adeline Chan","2014-08-18",5000,1750,"2014-08-25","2014-09-24","2014-09-22","2014-09-25","Yes","David"]
["People's Injury Network OT Olympia","Seth","2014-09-12","People's Injury Network","Brandon Imamshah","2014-09-12",7000,2450,"2014-10-15","2014-11-14","2014-11-11","2014-11-25","Yes","David"]
["HealthPro Rehab SLP Philly","Seth","2014-10-15","HealthPro","Colleen Cullen","2014-10-25",5000,1750,"2014-11-11","2014-12-11","2014-12-22","2014-12-25","Yes","David"]
["New Big Thing","David","2015-04-14","The Biggest",null,null,707500,247624.99999999997]
["stuff","Seth","2015-04-14","stuff & things","Jimmy Johns","2015-04-14",70754,24763.899999999998,"2015-04-27","2015-05-27","2015-04-30","2015-05-10","No"]

{"sheet":"Commissions and Reserves","index":2,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Summary"]
["Recruiter","Commission Owed on:","Apr 25, 2015",null,"On Hold?"]
[null,"Internal","Contingency","Total"]
["David",2850,{"$f":"SUMIFS(ContJobs[[Net Commission ]],ContJobs[[Recruiter ]],A4,ContJobs[Commission Payable Date],\"<=\"&IF(DAY(TODAY())<10,EOMONTH(TODAY(),-1)+10,IF(DAY(TODAY())<25,EOMONTH(TODAY(),-1)+25,EOMONTH(TODAY(),0)+10)),ContJobs[Start Date Verified By],\"<>\",ContJobs[Paid?],\"No\")","v":0},{"$f":"SUM(C4,B4)","v":2850},"Yes"]
["Seth",3150,{"$f":"SUMIFS(ContJobs[[Net Commission ]],ContJobs[[Recruiter ]],A5,ContJobs[Commission Payable Date],\"<=\"&IF(DAY(TODAY())<10,EOMONTH(TODAY(),-1)+10,IF(DAY(TODAY())<25,EOMONTH(TODAY(),-1)+25,EOMONTH(TODAY(),0)+10)),ContJobs[Start Date Verified By],\"<>\",ContJobs[Paid?],\"No\")","v":0},{"$f":"SUM(C5,B5)","v":3150},"No"]

{"sheet":"Commissions Apr 14","index":3,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Start Date Verified By","(Multiple Items)"]
["Paid?","No",null,"This report covers all unpaid internal commissions through the next pay period."]
[]
["Commission Summary","Column Labels"]
["Row Labels","2015-02-10","2015-03-25","2015-04-10","2015-04-25","Grand Total"]
["David",null,950,475,1425,2850]
["Kristi Ray",null,null,null,475,475]
["Mary Klueber",null,null,475,null,475]
["Whitney Freygang",null,null,null,475,475]
["Matt Brady",null,null,null,475,475]
["Marissa Doohan",null,425,null,null,425]
["Bobbi Arnold",null,525,null,null,525]
["Seth",300,600,1500,750,3150]
["Jennifer Kalas",null,null,300,null,300]
["Margie Maples",null,null,500,null,500]
["Elizabeth Beane",null,null,null,100,100]
["Heather Haas",300,null,null,null,300]
["Jarom Woodbury",null,null,100,null,100]
["Amanda Peterson",null,null,null,400,400]
["Tami Otey",null,null,300,null,300]
["Tim Rowe",null,null,null,250,250]
["Tasha Thomas",null,null,300,null,300]
["Samantha Singler",null,600,null,null,600]
["Grand Total",300,1550,1975,2175,6000]

{"sheet":"Basic Info","index":4,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Base Commission",null,null,"Disciplines","Market","Years Experience","Verifiers","Full/Part"]
["David",475,null,"OT","Seattle","new grad","David","Full-Time"]
["Seth",300,null,"PT","Salt Lake","1-2","Lisa","Part-Time"]
[null,null,null,"SLP","Phoenix","3-4","Belenda"]
[null,null,null,"COTA","Des Moines","5-6","Derek"]
[null,null,null,"PTA","Tucson","7-8","Darin"]
[null,null,null,null,"Oklahoma City","9-10","Chad"]
[null,null,null,null,"Kalamazoo",">10","Jason"]
[null,null,null,null,"Philadelphia"]
[null,null,null,null,"Alexandria"]
[null,null,null,null,"Connecticut"]
[null,null,null,null,"Yuma"]

{"sheet":"Pay Scale","index":5,"n_rows":116,"n_cols":9,"rows_kept":116,"cut":false,"hidden":false,"merged":[[3,8,9,13],[34,8,40,13],[67,8,73,13],[98,8,104,13]]}
["Seattle","OT","COTA","PT","PTA","SLP"]
["new grad","32","25","32","25","32"]
["1-2","34","27","34","27","34"]
["3-4","36","28","36","28","36",null,null,"When adding a market, make sure it is formatted exactly the same as the existing markets!"]
["5-6","38","29","38","29","38"]
["7-8","40","30","40","30","40"]
["9-10","42","31","42","31","42"]
[">10","43","31","43","31","43"]
[]
[]
["Salt Lake","OT","COTA","PT","PTA","SLP"]
["new grad","31","21","31","21","31"]
["1-2","32","22","32","22","32"]
["3-4","33","23","33","23","33"]
["5-6","34","23","34","23","34"]
["7-8","35","24","35","24","35"]
["9-10","36","25","36","25","36"]
[">10","37","26","37","26","38"]
[]
[]
["Phoenix","OT","COTA","PT","PTA","SLP"]
["new grad","32","25","32","25","32"]
["1-2","34","27","34","27","34"]
["3-4","36","28","36","28","36"]
["5-6","38","29","38","29","38"]
["7-8","40","30","40","30","40"]
["9-10","42","31","42","31","42"]
[">10","43","31","43","31","43"]
[]
[]
["Des Moines","OT","COTA","PT","PTA","SLP"]
["new grad","31","23","32","23","32"]
["1-2","33","24","34","24","33"]
["3-4","35","25","36","25","35"]
["5-6","37","26","38","26","36",null,null,"When adding a market, make sure it is formatted exactly the same as the existing markets!"]
["7-8","39","27","40","27","38"]
["9-10","41","28","42","28","40"]
[">10","41","29","43","29","43"]
[]
[]
["Tucson","OT","COTA","PT","PTA","SLP"]
["new grad","33","24","33","24","31"]
["1-2","35","25","35","25","33"]
["3-4","36","26","36","26","35"]
["5-6","37","27","37","27","37"]
["7-8","39","29","39","29","39"]
["9-10","41","30","41","30","40"]
[">10","42","30","42","30","40"]
[]
[]
["Oklahoma City","OT","COTA","PT","PTA","SLP"]
["new grad","31","24","32","24","30"]
["1-2","34","27","34","27","34"]
["3-4","36","28","36","28","36"]
["5-6","38","29","38","29","38"]
["7-8","40","30","40","30","40"]
["9-10","42","31","42","31","42"]
[">10","43","32","43","32","42"]
[]
[]
["Kalamazoo","OT","COTA","PT","PTA","SLP"]
["new grad","30","23","31","23","31"]
["1-2","32","24","34","24","33"]
["3-4","34","25","36","25","35"]
["5-6","36","26","38","26","37"]
["7-8","38","28","40","28","39"]
["9-10","40","29","42","30","40"]
[">10","41","30","42","31","41",null,null,"When adding a market, make sure it is formatted exactly the same as the existing markets!"]
[]
[]
["Philadelphia","OT","COTA","PT","PTA","SLP"]
["new grad","33","26","33","26","32"]
["1-2","36","28","36","28","35"]
["3-4","38","29","38","29","37"]
["5-6","41","30","41","30","39"]
["7-8","42","31","42","31","40"]
["9-10","43","33","43","33","42"]
[">10","44","34","44","34","44"]
[]
[]
["Alexandria","OT","COTA","PT","PTA","SLP"]
["new grad","33","26","33","26","33"]
["1-2","36","28","36","28","36"]
["3-4","38","28","38","28","38"]
["5-6","41","29","41","29","40"]
["7-8","41","32","43","32","40"]
["9-10","43","34","44","34","43"]
[">10","44","34","45","34","45"]
[]
[]
["Connecticut","OT","COTA","PT","PTA","SLP"]
["new grad","34","26","34","26","34"]
["1-2","36","28","36","28","37"]
["3-4","39","29","39","29","39"]
["5-6","41","30","41","30","41"]
["7-8","43","32","43","32","43"]
["9-10","44","33","44","33","44"]
[">10","44","34","44","34","44"]
[null,null,null,null,null,null,null,null,"When adding a market, make sure it is formatted exactly the same as the existing markets!"]
["Yuma","OT","COTA","PT","PTA","SLP"]
["new grad","34","26","34","26","34"]
["1-2","36","28","36","28","37"]
["3-4","39","29","39","29","39"]
["5-6","41","30","41","30","41"]
["7-8","43","32","43","32","43"]
["9-10","44","33","44","33","44"]
[">10","44","34","44","34","44"]
[]
["Logan","OT","COTA","PT","PTA","SLP"]
["new grad","32","22","32","22","32"]
["1-2","33","23","33","23","33"]
["3-4","34","24","34","24","34"]
["5-6","35","24","35","24","35"]
["7-8","35","25","35","25","35"]
["9-10","37","25","37","25","37"]
[">10","38","26","38","26","38"]