83K Excel 2010 spreadsheet with five page macro (VBA code). There are 2 tables, one 2x56 and the other 55x45 (3 variables: Income, # of children, age category). Data input is 4 alphanumeric fields of 1 column and 1 row, 3 rows, 8 rows, and 9 rows, 34 currency inputs, 6 integer inputs, 2 two character alphas, and 2 percentages. Input template size of 2 sheets of regular paper. Calcualtions are straight arithetic and 2 table look-ups. User opens Excel, retrieves template, fills it out, calculations are done, template updated, printed (2 page report), and saved in new Excel file for future operations. 2x56 table updated quarterly so that table must have read/write abilitiy but larger table read only.
I would like the user to only see then template but the user can make any changes to the template but cannot access the macro. I also am worried about security flags if user executes macro. Don't care if template comes from web or drive. [login to view URL] is competitor. Kansas Child Support Guidelines found at [login to view URL] This template is a proof-of-concept as new tables go into effect in November of 2011.
I'm IT's student. I just finished my IT course from NIIT computer center. I have all knowledge of computer and entertainment. I finished any computer work easily. My typing speed is so fast because I already take 1 year web designing training.