sorting jobs list

[Ian1976]

Hi,
Could somene tell me if there is a way to sort a list of jobs that are required to be done over a monthly period (per day)

I have a list of tools and how many hours they have been used for, i'd like to be able to plan how many jobs i can do per day ( 3,4,5,6) is there a formula i can use that would automaticaly sort them then start filling in the next days jobs until the list if tools is complete?

Thanks

[TABLE="width: 500"]
<tbody>[TR]
[TD]tool[/TD]
[TD]hours[/TD]
[TD]per day[/TD]
[TD][/TD]
[TD]14/09/19[/TD]
[TD]15/09/19[/TD]
[TD]16/09/19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0457893[/TD]
[TD]-12[/TD]
[TD]3 (changeable)
[/TD]
[TD][/TD]
[TD]0457893[/TD]
[TD]4376203[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0247584[/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD]0247584[/TD]
[TD]2846729[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1498045[/TD]
[TD]25[/TD]
[TD][/TD]
[TD][/TD]
[TD]1498045[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4376203[/TD]
[TD]33[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2846729[/TD]
[TD]43[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[DSCfromCFA]

G'day Ian,

I've read over your request a few times and I'm still unsure as to what you are trying to achieve, and unfortunately the example you have included is not helping me.

For a start:
1. where do the 'hours' come from, and what is the relevance of the data (and how is -12 achieved)?
2. what is the significance of '3(changeable)' in the per day column?
3. how are the tool numbers assigned to a date column
4. what is meant by 'until the list of tools is complete'?

cheers

shane

 

[Ian1976]

Hi mate,
Sorry about the lack of info,
1) hours will be on a separate sheet from an imported cvs file
2) the significance of the changeable figure will be if I can service 3 tools a day everyday I’ll set it at 3 to get 3 tools in that days column for the whole period, if I have other work planned in that week I may have to set it lower to 1 to only return 1 tool per day for the whole period!
3) the tools aren’t currently assigned in any way to a date, that’s my ultimate goal, I’d like them to automatically assign themselves, the csv file on say sheet 2 I would use a formula just to put them on sheet 1 for visibility and tidiness
4) I assumed that i may need a macro or code as I have about 70 tools so once all 70 are planned and allocated to a date the macro/code needs to stop?

Thanks Shane!

 

[DSCfromCFA]

Thanks for the clarification Ian,

Now down to the nitty gritty - This is what I understand you want.

You have a list of tools that have been used for varying lengths of time and you need to schedule regular servicing of those tools across a month.
You would like the schedule to be automatically generated based on the number of tools, the time used and how many tools you estimate you can service per day.
If other work interrupts the schedule, you want to be able to alter the number of tools per day and have the schedule be automatically adjusted

My assumptions:
Tools only make it on to your list once they need servicing - (Are they all assigned at the beginning of the month, or do they appear randomly through the month?)
All tools on the list are actually available for any given day they are on the schedule
There is some means of removing tools from the list once they have been serviced i.e. an hours used of zero

As you are probably beginning to see, there are a lost of structural questions that need to be answered in order to achieve what you want, and ultimately it may be in a form that is not what you currently envisage. For example, it may actually be easier to produce a list of tools in priority order and assign a date, rather than as list of dates and assign tools.

If the ultimate answer relies on VBA than I will be of no use whatsoever as that is still pretty much unchartered waters for me - but we are not there yet

Cheers

shane