I have made a spreadsheet for 40/60 split. Not as complicated as some of yours may be, but, in our situation it doesn't need to be. Pretty much, I just enter the date the load was delivered, truck number (which never changes ), miles being paid, the dollar amount for each mile, then the pro#...