- Messages
- 4,148
- Reaction score
- 5
- Points
- 38
Offering my services for(in order of most compitent):
MS Excel, can do alot with this,
complex equations eg :
small amount of macro writting eg: buttons and stuff
Perl & PHP small amount of each, but enough to get by.
PS. Excel is an amazing program(shame microsoft came up with it).
The extent of what you can do goes beyond most peoples comprehension.
Edit:
note the 1st equation is part of a system that works out how much I owe a staff member that I pay on an hourly rate. That specific equation works out the mins she has worked with the input cells being stating hours and mins and ending hours and mins.
Excel can lock sheets and cells and and and... thus the workbook I use runs the whole restraunt and is user friendly with out them worrying they will stuff up an equation.
MS Excel, can do alot with this,
complex equations eg :
Code:
=IF(B3>D3,(24-B3+D3)*60,(D3-B3)*60)+IF(E3<=C3,(60-(C3-E3))-60,E3-C3)
=IF(H3>0,COUNTA(J3:AC3)*10,0)
& so on...Perl & PHP small amount of each, but enough to get by.
PS. Excel is an amazing program(shame microsoft came up with it).
The extent of what you can do goes beyond most peoples comprehension.
Edit:
note the 1st equation is part of a system that works out how much I owe a staff member that I pay on an hourly rate. That specific equation works out the mins she has worked with the input cells being stating hours and mins and ending hours and mins.
Excel can lock sheets and cells and and and... thus the workbook I use runs the whole restraunt and is user friendly with out them worrying they will stuff up an equation.
Last edited: