01 November 2008

Revelations concerning Excel

So I was working late last night getting payroll ready for the latest round. While I was working of the Excel spread a new way of doing the same things struck me. The changes go from:

=IF(ISERROR(INDEX('Master Driver Log'!$C$6:$C$93,MATCH($B8&$A$5,'Master Driver Log'!$A$6:$A$93&'Master Driver Log'!$B$6:$B$93,0)))," ",INDEX('Master Driver Log'!$C$6:$C$93,MATCH(B8&$A$5,'Master Driver Log'!$A$6:$A$93&'Master Driver Log'!$B$6:$B$93,0)))

repeated 16 times to:

=DSUM('Master Driver Log'!$A$4:$L$107,B$9,$L10:$N11)

done once. The new way is definetly much better than the old way. I am glad that the Lord helps me with Excel. The change in code not only makes the formulas easier to follow and troubleshoot but also reduce the total file size by 15%. Okay it is really only 100kb but the changes also make the file process faster.

No comments:

Post a Comment