tbcomputerguy Posted September 21, 2020 Share Posted September 21, 2020 I have an excel sheet that controls bills of ladings for a forestry company. In the example you can see that there is lots going on with this Bill. It has a payperiod, mill, truck that delivered it, etc. I would like setup a database to monitor this. The fields CT1, CT2, Skid1, Skid2. PROC1, PROC2 are all contractor numbers. There are 6 contactors. The percentages in each line are the amount of the volume they performed In the third line there is a value in CT1 only...they get 100% of the volume. I can figure out most of this, but am stumped on how I can monitor when a contractor does multiple jobs..ie in line one, contractor 5, cuts and skids. All 6 contractors could be involved in one BOL. Each one of these jobs, cutting, skidding and processing each has their own respective rate of pay as well. I think i need a way to break down each line so that I can produce pay summaries for each of the contractors. I had started this years ago, and thought I asked in a forum, but can't remember where. Nonetheless, they stopped using multiple contractors per load...Now they have returned, so I am back at it. So if this is a repost from years ago I apologize. Thanks in Advance tbcomputerguy Link to comment Share on other sites More sharing options...
This topic is 992 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now