Domestic Relations Clinic Reference Forms

    >  Click here for DR Clinic reference forms

 

Excel Child Support Training Notes

 

The attached link will take you to the Excel Child Support Calculator we will be

using this year for calculations at the Child Support Project.  Please feel free to

use this read only version to practice data entry and to become familiar with the

program.  Below are some tips and hypothetical client information you can use to

practice.

 

» Link to Child Support Calculator

 

Annie Barrett will be available to meet with you one half hour before your first

volunteer session (noon) to run through the program with you in person.  Please

let her know via email if you wish to do this at abarrett@sazlegalaid.org.

 

-----------------------------------------------------------------------------

 

Tips

 

When you click on the link, the read only program will appear.  When you are

done, do not save your work, just exit.

 

The first screen to appear is the Worksheet.  There are 3 other tabs on the

bottom of the page: Child Support Order; Order of Assignment; and

Judgement Data.  Fill out the Worksheet first because a lot of the data

will automatically insert in the other documents.

 

Fill in the blue areas on the screen – these are prompts for you.  Use the “tab”

to move to next blue box.  If you move the cursor over the blue prompt field,

a yellow dialogue box will appear which instructs you regarding input.

 

Try This – enter the following hypothetical information into the worksheet

and see how the calculations appear!

 

-----------------------------------------------------------------------------

 

Worksheet

 

Type in the hypothetical information in the BLUE worksheet fields.  For example,

for Petitioner you would type “Jane Doe.”

 

NO:  D2006-1234 (case number)

Petitioner:  Jane Doe

Respondent:  John Doe Sr.

DOB:   8/3/01 and 7/12/90 (birth dates of the children subject to the order. Ages

            and the presumptive termination date are figured automatically)

Primary Custodian:  Mother (x) 

Gross Monthly Income:    5000 a month for father

                                        18.00 an hour for mother (enter 1 option: hourly,  

                                        monthly, annually)

Additions to Child Support:    120 medical expenses for mother

                                               500 in child care for mother

Total Child Support Obligation:  

Under Parenting Time Table A enter 82 days.

 

The child support amount from the input of data above should calculate

to be $1,031.

 

Issue Order of Assignment Against:           

John Doe Sr. enter an “x” (the person paying the child support)

 

OBLIGOR:    “John Doe Sr.” will automatically appear.

 

In the yellow fields underneath the name, enter the employer information

for the obligor (the person paying the child support).

ABC Distribution Inc.

1234 Main Street

Tucson

AZ

85715

(520)456-8569

 

That’s It!  Please mix up the numbers and try different scenarios if you

wish.

 

Now hit the tab at the bottom of the page and move on to the child

support order.

 

-----------------------------------------------------------------------------

 

Child Support Order

 

The names of the respondent and petitioner will appear automatically along with

the dates of birth of the children.  You need to input the following:

 

1.         Names of Children             Sally Doe

                                                      Christopher Doe

 

2.         N/A

 

3.         Deviation      hit space bar and enter TO PROVIDE deviation         

                                 language, otherwise just hit tab to move on.

 

4.         Arrears          hit space bar and enter for NO arrears.

 

5.         Past Care      hit space bar and enter for NO past care and support.

 

-----------------------------------------------------------------------------