Closed

BestPracticeKSChildSupCalc

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. [url removed, login to view] is competitor. Kansas Child Support Guidelines found at [url removed, login to view] This template is a proof-of-concept as new tables go into effect in November of 2011.

Skills: Excel, Templates

See more: only about children, vba access excel, kansas, excel templates, character concept, excel vba read page, paper forms web forms, spreadsheet vba code, excel access table, write macro, excel 2011 vba, excel vba report, excel macro row, web page vba, excel report macro, excel vba macro file, excel inputs, access vba read code, vba excel 2011, ups report, macro report spreadsheet, vba 2011, excel table 2010, excel vba macro spreadsheet, excel macro access

About the Employer:
( 0 reviews ) Wichita, United States

Project ID: #1146823

12 freelancers are bidding on average $273 for this job

vserv

Pls see your messages. Thanks

$250 USD in 5 days
(60 Reviews)
5.8
best4best

I am an Excel expert. Please see PMB.

$300 USD in 5 days
(79 Reviews)
5.3
gshiels

Please see PM

$350 USD in 3 days
(11 Reviews)
5.1
SamNanton

See PM for details.

$250 USD in 7 days
(25 Reviews)
4.9
chriskerpini

Please check PMB

$280 USD in 10 days
(20 Reviews)
4.8
SilviaT

Please check PM.

$250 USD in 7 days
(5 Reviews)
2.3
kanadyanako

For your consideration.

$250 USD in 3 days
(1 Review)
1.8
birudvora

Please see your PMB

$300 USD in 15 days
(0 Reviews)
0.0
dal22

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 yea More

$300 USD in 6 days
(0 Reviews)
0.0
dineshmhatre

Dear Sir, Please check the PM regards

$250 USD in 1 day
(0 Reviews)
0.0
erry

let's do this

$250 USD in 5 days
(0 Reviews)
0.0
sajalislam

I've excellent typing speed for completed your job.

$250 USD in 3 days
(0 Reviews)
0.0