I'm going to be stuck in the office for 3+ weeks, with not a lot to do.
But they could do with a spreadsheets or two, but it's been ages since I used excel, so will need some tutorial/helps to get me going on some of the more "advanced" features. The two main things are, which I have no idea how to do are:
tick/check boxes and linking them, so if one is selected all the other are deselected.
and a macro to work out how many lengths can be made out of a larger length.
Say you have 130, would need to find out how many times 92 and how many times 19 would fit into that and what the left over would be (so would be 1x92, 2x19 and 10 left over. Or even better if I could put ranges in say 91.0-93.5 and 18.2-19.0 (although not essential)
So anyone know any good tutorial websites for such things or could point me in the right direction.
But they could do with a spreadsheets or two, but it's been ages since I used excel, so will need some tutorial/helps to get me going on some of the more "advanced" features. The two main things are, which I have no idea how to do are:
tick/check boxes and linking them, so if one is selected all the other are deselected.
and a macro to work out how many lengths can be made out of a larger length.
Say you have 130, would need to find out how many times 92 and how many times 19 would fit into that and what the left over would be (so would be 1x92, 2x19 and 10 left over. Or even better if I could put ranges in say 91.0-93.5 and 18.2-19.0 (although not essential)
So anyone know any good tutorial websites for such things or could point me in the right direction.