They actually only involved subtotals, percentage deductions and additions, and so on. The tricky part was figuring out how to mimic the alignment of the original forms - their client wants the forms on specially-printed form paper which already has some labels and divisions and so on.
I didn't have a ruler, so I ended up holding the sample form to the screen (with Excel zoomed to as close to life size as possible) and estimating distances with the onscreen ruler.
Positioning the different fields was made easier by a trick I learned from seeing it used at work: turning all the cells in the sheet into tiny squares, and simply merging cells into the right size where they are needed. (Adjusting field positions was a pain, though!)
So, in summary, I suppose there could've been better/more efficient ways of doing what I just did, but I think I did well enough for an intermediate spreadsheet user.
No comments:
Post a Comment