{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Worksheet","Day Care Credit","Tax Rate","Age of Children","Tax Cons.","EPT Final","Schedules","Interstate Pay","Extended","EPT Draft","Sheet11","Tax Rates"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Worksheet","index":0,"n_rows":327,"n_cols":58,"rows_kept":327,"cut":false,"hidden":false,"merged":[[44,6,44,8],[8,1,8,11],[3,1,3,11],[4,1,4,11],[7,1,7,11],[65,1,65,4],[83,6,83,7],[89,6,89,7],[89,1,89,4],[74,1,74,4],[72,1,72,4],[85,6,85,7],[75,1,75,4],[76,1,76,4],[83,1,83,4],[77,1,77,4],[78,1,78,4],[25,1,25,4],[26,1,26,4],[31,1,31,4],[27,1,27,4],[29,1,29,4],[60,1,60,4],[39,1,39,4],[0,1,0,11],[1,1,1,11],[2,1,2,11],[5,1,5,11],[32,5,32,6],[39,5,39,6],[35,1,35,4],[15,1,15,4],[20,1,20,4],[24,1,24,4],[11,1,11,4],[12,1,12,4],[9,4,9,5],[10,4,10,5],[21,1,21,4],[16,1,16,4],[14,1,14,4],[9,1,9,3],[10,1,10,3],[13,1,13,4],[19,1,19,4],[18,1,18,4],[23,1,23,4],[6,1,6,11],[32,1,32,4],[33,1,33,4],[34,1,34,4],[59,1,59,4],[55,1,55,4],[41,1,41,4],[42,1,42,4],[44,1,44,4],[40,1,40,4],[47,1,47,4],[48,1,48,4],[215,3,215,5],[108,2,108,11],[109,2,109,11],[118,2,118,11],[162,7,162,9],[205,7,205,9],[208,7,208,9],[149,4,149,5],[151,4,151,5],[152,4,152,5],[117,2,117,11],[110,6,110,7],[111,3,111,5],[213,3,213,5],[211,7,211,9],[207,3,207,4],[155,8,155,9],[101,6,101,8],[100,6,100,8],[100,2,100,4],[62,1,62,4],[70,1,70,4],[71,1,71,4],[73,1,73,4],[212,3,212,5],[102,2,102,4],[210,3,210,4],[211,3,211,4],[93,1,93,4],[99,2,99,4],[105,1,105,7],[79,1,79,4],[84,1,84,4],[85,1,85,4],[86,1,86,4],[88,1,88,4],[92,1,92,4],[91,1,91,4],[106,1,106,7],[104,1,104,7],[103,1,103,4],[94,1,94,4],[95,1,95,4],[96,1,96,4],[97,1,97,4],[98,1,98,4],[208,3,208,5],[209,3,209,5],[101,2,101,4],[51,1,51,4],[90,1,90,4]]}
["INSTRUCTIONS","1.  Blue Fields:       User must enter data into the location e.g. Name of Petitioner user must type in the name of the Petitioner.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attorney for Petitioner"]
[null,"2.  Yellow Fields:    User must select from the drop down box only e.g. Main. Requested (Y or N) and answer is No, user ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attorney for Respondent"]
[null,"                                 must select N from the drop down box and not type in the letter N.    Such typing will be rejected.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pro Se"]
[null,"                                 To activate the drop down choices place the cursor (mouse) in the box and hit the left button on the mouse, drop                        "]
[null,"                                 down arrow will appear on the right side of the location."]
[null,"3.  Black or White Fields:     User should disregard as the information sought does not apply to user's case.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Allen",null,null,"Johnson  "]
["TIPS","IMPORTANT TO FOLLOW THE DIRECTIONS ENTIRELY FOR THE CALCULATOR TO WORK PROPERLY.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Allen  "]
[null,"PLACE AND HOLD CURSOR IN FIELD AND HINT SHOULD APPEAR EXPLAINING WHAT IS BEING SOUGHT."]
[null,"USER SHOULD BE ABLE TO UTILIZE THE TAB KEY TO MOVE TO THE NEXT FIELD.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anderson  "]
["CAPTION","Name of Petitioner",null,null,null,null,null,null,null,null,null,null,null,null,"P","Head of Household",null,null,"Yes",null,"Atty for Petitioner",null,null,null,"Anderson",null,null,"Atchison  "]
[null,"Name of Respondent",null,null,null,null,null,null,null,null,null,null,"Alternate",null,"R","Single",null,null,"No",null,"Atty for Respondent",null,null,null,"Atchison",null,null,"Barber  "]
[null,"Case No",null,null,null,null,null,null,null,null,null,null,"Mother",null,null,"Married-Joint",null,null,null,null,"Pro Se",null,null,null,"Barber",null,null,"Barton  "]
[null,"Court No",null,null,null,null,null,null,null,null,null,null,"Father",{"$f":"H20/12","v":0},null,"Married-Sep.",null,null,null,null,"Petitioner",null,null,null,"Butler",null,null,"Bourbon  "]
[null,"County of Action",null,null,null,"Johnson  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Respondent",null,null,null,"Cheyenne",null,null,"Brown  "]
["INCOME/MAINTENANCE","Father's Income (Wages) ; Monthly or Annually",null,null,null,"Monthly","Amount Paid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clark",null,null,"Butler  "]
[null,"Father's Income (Annual)",null,null,null,{"$f":"IF(F15=\"Annually\",H15,M17)","v":0},null,null,null,null,null,null,{"$f":"F16/12","v":0},null,null,null,null,null,null,null,null,null,null,null,"Barton",null,null,"Chase  "]
[null,"Father's Income (Monthly )",null,null,null,{"$f":"IF(F15=\"Monthly\",H15+J131,M16)","v":0},null,null,null,null,null,12,{"$f":"F17*L17","v":0},null,null,null,null,null,null,null,null,null,null,null,"Bourbon",null,null,"Chautauqua  "]
[null,null,null,null,null,"************",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brown",null,null,"Cherokee  "]
[null,"Father's Self Employment Income, if any",null,null,null,null,"Father's Bus. Exp. ",null,null,null,null,null,null,null,"Head of Household",null,null,null,null,null,null,null,null,null,"Cloud",null,null,"Cheyenne  "]
[null,"Mother's Income (Wages);  Monthly or Annually",null,null,null,"Monthly","Amount Paid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coffey",null,null,"Clark  "]
[null,"Mother's Income (Annual)",null,null,null,{"$f":"IF(F20=\"Annually\",H20,M22)","v":0},null,null,null,null,null,null,{"$f":"F21/12","v":0},null,"Single",null,null,null,null,null,null,null,null,null,"Chase",null,null,"Clay  "]
[null,"Mother's Income (Monthly)",null,null,null,{"$f":"IF(F20=\"Monthly\",H20+H131,N13)","v":0},null,null,null,null,null,12,{"$f":"F22*L22","v":0},null,"Married-Joint",null,null,null,null,null,null,null,null,null,"Chautauqua",null,null,"Cloud  "]
[null,null,null,null,null,"************",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cherokee",null,null,"Coffey  "]
[null,"Mother's Self Employment Income, if any",null,null,null,null,"Mother's Bus. Exp.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cowley",null,null,"Comanche  "]
[null,"Maintenance/Alimony Requested  (Y or N)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dickinson",null,null,"Cowley  "]
[null,"Monthly Income Difference",null,null,null,{"$f":"IF(M16>M21,M16-M21,M21-M16)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clay",null,null,"Crawford  "]
[null,"Main/Alimony Upon Percentage.See Comment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Finney",null,null,"Decatur  "]
[null,"Main. Amount ",null,null,null,{"$f":"F26*F27/100","v":0},null,null,null,null,null,null,null,null,"Do Not Complete",null,null,null,null,null,null,null,null,null,"Graham",null,null,"Dickinson  "]
[null,null,null,null,null,"***********",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comanche",null,null,"Doniphan  "]
["REPRESENTATION","Party Worksheet Prepared for (P or R)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Greeley",null,null,"Douglas  "]
[null,null,null,"Number of Children",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crawford",null,null,"Edwards  "]
[null,"Party Status As Mother or Father (M or F)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Decatur",null,null,"Elk  "]
["TAX FILING","Tax Filing of Cust. Parent See Comment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harvey",null,null,"Ellis  "]
[null,"Parent Child Reside File HOHousehold",null,null,null,{"$f":"IF(F33=\"Head of Household\",\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Doniphan",null,null,"Ellsworth  "]
[null,"Parent Child Reside File Single",null,null,null,{"$f":"IF(F33=\"Single\",\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,"Y",null,null,null,null,null,null,null,null,null,null,"Douglas",null,null,"Finney  "]
[null,"Parent Child Reside With File Joint",null,null,null,{"$f":"IF(F33=\"Married-Joint\",\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,"N",null,null,null,null,null,null,null,null,null,null,"Edwards",null,null,"Ford  "]
[null,null,null,"Noncust. File Single",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elk",null,null,"Franklin  "]
[null,null,null,"Noncust. File Married",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ellis",null,null,"Geary  "]
[null,"Noncustodial File HOH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ellsworth",null,null,"Gove  "]
[null,"Tax Filing of Noncust. Parent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jefferson",null,null,"Graham  "]
[null,"Noncustodial Parent File HOHousehold",null,null,null,{"$f":"IF(F40=\"Head of Household\",\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ford",null,null,"Grant  "]
[null,"Noncustodial Parent File Joint",null,null,null,{"$f":"IF(F40=\"Married-Joint\",\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Franklin",null,null,"Gray  "]
[null,"Noncustodial Parent File Single",null,null,null,{"$f":"IF(F40=\"Single\",\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geary",null,null,"Greeley  "]
["CHILDREN",null,null,null,null,"************",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gove",null,null,"Greenwood  "]
["CHILDREN","Parent Children Reside With (M or F)",null,null,null,null,"How Exemption Claimed (Alternate, Mother, Father)",null,null,null,null,null,"F","M",null,null,null,null,null,null,null,null,null,null,"Johnson",null,null,"Hamilton  "]
[null,"Total Day Care Paid by Mother",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grant",null,null,"Harper  "]
[null,"Total Day Care Paid by Father",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gray",null,null,"Harvey  "]
[null,"Birthday Child #1 (format 1/1/2012 for ex.)",null,null,null,null,null,{"$f":"IFERROR(IF(YEARFRAC(F48,TODAY(),1)>18,\"Highschool Grad?\",\"\"),\"\")","v":"Highschool Grad?"},null,null,null,null,{"$f":"IF(G48=\"Father\",1,0)","v":0},{"$f":"IF(G48=\"Mother\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,"Kingman",null,null,"Haskell  "]
[null,"Work Related Day Care Amt. #1",null,null,null,null,null,null,null,{"$f":"IF(F49>0,1)","v":false},null,{"$f":"IF(G49=\"M\",1,0)","v":0},{"$f":"IF(G49=\"F\",1,0)","v":0},0,null,null,null,null,null,null,null,null,null,null,"Greenwood",null,null,"Hodgeman  "]
[null,"Mother Pays Work Related Day Care #1",null,null,null,null,null,null,null,{"$f":"IF(F53>0,1)","v":false},null,0,0,0,null,null,null,null,null,null,null,null,null,null,"Hamilton",null,null,"Jackson  "]
[null,"Father Pays Work Related Day Care #1",null,null,null,null,null,null,null,{"$f":"IF(F57>0,1)","v":false},null,0,0,0,null,null,null,null,null,null,null,null,null,null,"Harper",null,null,"Jefferson  "]
[null,"Birthday Child #2, if any",null,null,null,"NA",null,{"$f":"IFERROR(IF(YEARFRAC(F52,TODAY(),1)>18,\"Highschool Grad?\",\"\"),\"\")","v":""},null,null,null,null,0,{"$f":"IF(G52=\"M\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,"Kiowa",null,null,"Jewell  "]
[null,"Work Related Day Care Amt #2",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,"Haskell",null,null,"Johnson  "]
[null,"Mother Pays Work Related Day Care #2",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,"Hodgeman",null,null,"Kearny  "]
[null,"Father Pays Work Related Day Care #2",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,"Jackson",null,null,"Kingman  "]
[null,"Birthday Child #3, if any",null,null,null,"NA",null,{"$f":"IFERROR(IF(YEARFRAC(F56,TODAY(),1)>18,\"Highschool Grad?\",\"\"),\"\")","v":""},null,null,null,null,0,{"$f":"IF(G56=\"M\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,"KS Counties",null,null,"Kiowa  "]
[null,"Work Related Day Care Amt #3",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,"Jewell",null,null,"Labette  "]
[null,"Mother Pays Work Related Day Care #3",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,"Johnson",null,null,"Lane  "]
[null,"Father Pays Work Related Day Care #3",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,"Kearny",null,null,"Leavenworth  "]
[null,"Birthday Child #4, if any",null,null,null,"NA",null,{"$f":"IFERROR(IF(YEARFRAC(F60,TODAY(),1)>18,\"Highschool Grad?\",\"\"),\"\")","v":""},null,null,null,null,0,{"$f":"IF(G60=\"M\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,"Lane",null,null,"Lincoln  "]
[null,"Birthday Child #5, if any",null,null,null,"NA",null,{"$f":"IFERROR(IF(YEARFRAC(F61,TODAY(),1)>18,\"Highschool Grad?\",\"\"),\"\")","v":""},null,null,null,null,0,{"$f":"IF(G61=\"M\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,"Linn",null,null,"Linn  "]
[null,"Children reside with (M or F)",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,"Labette",null,null,"Logan  "]
[null,"Birthday Child #6, if any",null,null,null,"NA",null,{"$f":"IFERROR(IF(YEARFRAC(F63,TODAY(),1)>18,\"Highschool Grad?\",\"\"),\"\")","v":""},null,null,null,null,0,{"$f":"IF(G63=\"M\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,"Logan",null,null,"Lyon  "]
[null,null,null,null,null,"************",null,null,null,null,null,{"$f":"SUM(L48:L63)","v":0},{"$f":"SUM(M48:M63)","v":0},{"$f":"SUM(N48:N63)","v":0},null,null,null,null,null,null,null,null,null,null,"Leavenworth",null,null,"McPherson  "]
[null,"Total Number Children  in Day Care",null,null,null,{"$f":"'Age of Children'!G9+'Age of Children'!H9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lincoln",null,null,"Marion  "]
[null," Tax Consideration (Value) For Exemptions",null,null,null,{"$f":"IF(D68<0,-D68,D68)","v":{"$error":"#DIV/0!"}}]
[null,"Mother",null,"Father"]
[null,{"$f":"'Tax Cons.'!N10","v":{"$error":"#DIV/0!"}},null,{"$f":"'Tax Cons.'!N11","v":{"$error":"#DIV/0!"}},"Apply Tax Cons."]
[]
[]
["DAY CARE/HEALTH CARE","Total Day Care Paid by Mother",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M64>L64,'Tax Cons.'!O8,0)","v":0},{"$f":"IF(N64>M64,'Tax Cons.'!Q8,0)","v":0},null,null,null,null,null,null,"Y","M",null,null,"Lyon",null,null,"Marshall  "]
[null,"Total Day Care Paid by Father",null,null,null,null,null,null,null,null,null,null,{"$f":"M64-L64","v":0},{"$f":"N64-M64","v":0},null,null,null,null,null,null,"N","F",null,null,"McPherson",null,null,"Meade  "]
[null,"Health and Dental Mother",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M72>0,M72,0)","v":0},{"$f":"IF(N72>0,N72,0)","v":0},null,"Number of Add Children",null,null,null,null,null,null,null,null,"Neosho",null,null,"Miami  "]
[null,"Health and Dental Father",null,null,null,null,null,null,null,null,null,null,{"$f":"M73*M71","v":0},{"$f":"N73*N71","v":0},null,null,null,null,null,null,null,null,null,null,"Norton",null,null,"Mitchell  "]
["ENFORCEMENT FEE","Enforcement Fee",null,null,null,"N","Amount of Fee ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marion",null,null,"Montgomery  "]
[null,"Name of Respondent",null,null,null,"___",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marshall",null,null,"Morris  "]
[null,"Case No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meade",null,null,"Morton  "]
[null,"Court No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Miami",null,null,"Nemaha  "]
[null,"Health and Dental Dad",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mitchell",null,null,"Neosho  "]
[null,"Health and Dental Mom",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montgomery",null,null,"Ness  "]
[null,null,null,"Work Related Dad",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Morris",null,null,"Norton  "]
[null,null,null,"Work Related Mom",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Morton",null,null,"Osage  "]
[null,null,null,null,null,"************",null,null,null,null,null,{"$f":"L74*0.5","v":0},{"$f":"M74*0.5","v":0},{"$f":"N74*0.5","v":0},null,null,null,null,null,null,null,null,null,null,"Nemaha",null,null,"Osborne  "]
["ADJUST: a. Multi Family","Multiple Family (Assume No)",null,null,null,"N",{"$f":"P73","v":"Number of Add Children"},null,null,null,null,null,{"$f":"M74/2","v":0},{"$f":"N74/2","v":0},null,"Party Lives Out of State (M or F)",null,null,null,null,null,null,null,null,"Ottawa",null,null,"Ottawa  "]
[null,"Number of Add Children for Multi Family",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ness",null,null,"Pawnee  "]
["    b. Interstate ","Interstate Pay (Assume No)",null,null,null,"N",{"$f":"P84","v":"Party Lives Out of State (M or F)"},null,null,null,null,null,null,null,null,"Interstate Pay Identify the State",null,null,null,null,null,null,null,null,"Pawnee",null,null,"Phillips  "]
[null,"Party Lives Out of State (M or F)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Osage",null,null,"Pottawatomie  "]
[null,null,null,null,null,"************",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Osborne",null,null,"Pratt  "]
["                        Pay",{"$f":"P86","v":"Interstate Pay Identify the State"},null,null,null,"Alabama",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pottawatomie",null,null,"Rawlins  "]
["    c.  Equal Parent","Equal Parenting Time Worksheet (Y or N)",null,null,null,"N",{"$f":"P92","v":"Written Agreement Clothing (Y or N)"},null,"Y",null,null,null,null,null,null,"Do Not Complete If Prev. Response No",null,null,null,null,null,null,null,null,"Pratt",null,null,"Reno  "]
[null,"Written Agreement for Clothing (Y or N)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phillips",null,null,"Republic  "]
["                       Time",{"$f":"IF(F90=\"N\",P90,P93)","v":"Do Not Complete If Prev. Response No"},null,null,null,"M",null,null,null,null,null,null,null,null,null,"Written Agreement Clothing (Y or N)",null,null,null,null,null,null,null,null,"Rawlins",null,null,"Rice  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mother"]
["    d. Child Support","Father Pay Child Support Another Case",null,null,null,"N",{"$f":"P100","v":"Amt Father Pays"},null,null,null,null,null,null,null,null,"Who Is to Pay Direct Expenses (M or F)",null,null,null,null,null,null,null,null,"Reno",null,null,"Riley  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Father"]
["                      Other Case","Mother Pay Child Support Another Case",null,null,null,"N",{"$f":"P101","v":"Amt Mother Pays"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Republic",null,null,"Rooks  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A"]
["    e.  Long Distance Travel","Long Distance Travel Costs Adj. (Y or N)",null,null,null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attorney for Petitioner",null,null,null,null,null,"M"]
["    f.  Special Needs","Special Needs Adj. (Y or N)",null,null,null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attorney for Respondent",null,null,null,null,null,"F"]
["   g.  Support Past Majority","Support Past Majority Adj. (Y or N)",null,null,null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pro Se"]
["   h.  Overall Fin. Condition","Overall Financial Condition Adj. (Y or N)",null,null,null,"N"]
["   i.  Parent Time (Not EPT)","Parenting Time Adj. (Equal Parenting Time)",null,null,null,"N"]
["NAME OF PREPARER","Name",null,null,null,"Bar #",null,null,null,null,null,null,null,null,null,"Amt Father Pays",null,null,null,null,null,null,null,null,"Rice",null,null,"Rush  "]
[null,"Add.",null,null,null,"City,State",null,null,null,null,null,null,null,null,null,"Amt Mother Pays",null,null,null,null,null,null,null,null,"Riley",null,null,"Russell  "]
[null,"Phone",null,null,null,"Fax",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rooks",null,null,"Saline  "]
[null,"Email",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rooks",null,null,"Scott  "]
[null,"Indicate Status as Attorney or Pro Se"]
["PRINT SELECTION","1.  Print Child Support Worksheet (WS) Only, SELECT BUTTON TO RIGHT"]
[null,"2.  Print WS and Tax Considerations (1 and 2), SELECT BUTTON TO RIGHT"]
[null,"3.  Print WS ,Tax Cons. and Equal Parent Time Worksheet (1-3), SELECT BUTTON TO RIGHT"]
[]
[null,null,{"$f":"\"IN THE DISTRICT COURT OF \"&UPPER(F14)&\" COUNTY, KANSAS\"","v":"IN THE DISTRICT COURT OF JOHNSON   COUNTY, KANSAS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rush",null,null,"Sedgwick  "]
[null,null,"CIVIL COURT DEPARTMENT",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P92","v":"Written Agreement Clothing (Y or N)"},null,null,null,null,null,null,null,null,"Rush",null,null,"Seward  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Russell",null,null,"Shawnee  "]
[null,null,null,"In the matter of the Marriage of:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Russell",null,null,"Sheridan  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saline",null,null,"Sherman  "]
[null,null,null,{"$f":"E10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saline",null,null,"Smith  "]
[null,null,null,"and",null,null,null,null,"Case No.",{"$f":"F12","v":0},null,null,null,{"$f":"IF(F32=\"F\",N118)","v":false},null,null,null,null,null,null,null,null,null,null,"Scott",null,null,"Stafford  "]
[null,null,null,{"$f":"E11","v":0},null,null,null,null,"Court   ",{"$f":"F13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scott",null,null,"Stanton  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sedgwick",null,null,"Stevens  "]
[null,null,{"$f":"IF(F30=\"p\",N118,N119)","v":"CHILD SUPPORT WORKSHEET OF RESPONDENT"},null,null,null,null,null,null,null,null,null,null,"CHILD SUPPORT WORKSHEET OF PETITIONER",null,null,null,null,null,null,null,null,null,null,"Sedgwick",null,null,"Sumner  "]
[null,null,{"$f":"IF(F30=\"p\",\"PETITIONER\",\"RESPONDENT\")","v":"RESPONDENT"},null,null,null,null,null,null,null,null,null,null,"CHILD SUPPORT WORKSHEET OF RESPONDENT",null,null,null,null,null,null,null,null,null,null,"Seward",null,null,"Thomas  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seward",null,null,"Trego  "]
[null,null,null,null,null,null,null,"  MOTHER",null,"  FATHER",null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,"Shawnee",null,null,"Wabaunsee  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shawnee",null,null,"Wallace  "]
[null,null,"A.","INCOME COMPUTATION – WAGE EARNER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheridan",null,null,"Washington  "]
[null,null,null,1,"Domestic Gross Income ",null,null,{"$f":"IF(F20=\"Monthly\",H20,N13)","v":0},null,{"$f":"IF(F15=\"Monthly\",H15,M16)","v":0},null,{"$f":"H124+J124","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Sheridan",null,null,"Wichita  "]
[null,null,null,2,"Interstate Pay Adjustment",null,null,{"$f":"IF(I86=\"M\",'Interstate Pay'!N56,0)","v":0},null,{"$f":"IF(I86=\"F\",'Interstate Pay'!N56,0)","v":0},null,{"$f":"L124+H125+J125","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Sherman",null,null,"Wilson  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sherman",null,null,"Woodson  "]
[null,null,"B.","INCOME COMPUTATION – SELF-EMPLOYED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Smith",null,null,"Wyandotte  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Smith"]
[null,null,null,1,"Self-Employment Gross Income*",null,null,{"$f":"F24","v":0},null,{"$f":"F19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stafford"]
[null,null,null,2,"Reasonable Business Expenses",null,null,{"$f":"-H24","v":0},null,{"$f":"-H19","v":0},null,{"$f":"H130+J130","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Stafford"]
[null,null,null,3,"Self Employment After Expenses",null,null,{"$f":"H129+H130","v":0},null,{"$f":"J129+J130","v":0},null,{"$f":"H131+J131","v":0},null,null,null,{"$f":"AND(F7=\"Y\",F16>F21)*F28","v":0},null,null,null,null,null,null,null,null,"Stanton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stanton"]
[null,null,"C.","ADJUSTMENTS TO DOMESTIC GROSS INCOME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stevens"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-Q134","v":-5},5,null,null,null,null,null,null,null,"Stevens"]
[null,null,null,1,"Domestic Gross Income",null,null,{"$f":"H124+H125+H131","v":0},null,{"$f":"J124+J125+J131","v":0},null,{"$f":"H135+J135","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Sumner"]
[null,null,null,2,"Other Court-Ordered Child Support Paid (-)",null,null,{"$f":"-H94","v":0},null,{"$f":"-H93","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sumner"]
[null,null,null,3,"Court-Ordered Maint Paid in this Case (-)",null,null,{"$f":"-O137","v":0},null,{"$f":"-P137","v":0},null,null,null,null,{"$f":"AND(F25=\"Y\",M16<M21)*F28","v":0},{"$f":"AND(F25=\"Y\",M16>M21)*F28","v":0},null,null,null,null,null,null,null,null,"Thomas"]
[null,null,null,4,"Court-Ordered Maint Recd in this Case (+)",null,null,{"$f":"AND(F25=\"Y\",M16>M21)*F28","v":0},null,{"$f":"AND(F25=\"Y\",M16<M21)*F28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thomas"]
[null,null,null,5,"Court Ordered Main. Paid in Other Case  (-)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trego"]
[null,null,null,6,"Court-Ordered Main. Recd in Other Case (+)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trego"]
[null,null,null,7,"Child Support Income",null,null,{"$f":"H135+H136+H137+H138+H139+H140","v":0},null,{"$f":"J135+J136+J137+J138+J139+J140","v":0},null,{"$f":"H141+J141","v":0},null,"Wife Rounding",null,null,null,null,null,null,null,null,null,null,"Wabaunsee"]
[null,null,null,null,"(Insert on Line D.1. below)",null,null,null,null,null,null,null,null,{"$f":"H142/L142*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,"Wabaunsee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(N142,1)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,"Wallace"]
[null,null,"D.","COMPUTATION OF CHILD SUPPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wallace"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washington"]
[null,null,null,1,"Child Support Income",null,null,{"$f":"H141","v":0},null,{"$f":"J141","v":0},null,null,null,"Wife Rounding",null,"Husband Rounding",null,null,null,null,null,null,null,null,"Washington"]
[null,null,null,2,"Proportionate Shares of Combined Income",null,null,{"$f":"N150","v":{"$error":"#DIV/0!"}},"(Percent)",{"$f":"P150","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"H146/L141*100","v":{"$error":"#DIV/0!"}},null,{"$f":"J146/L141*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Wichita"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wichita"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wilson"]
[null,null,null,null,"Age of Children",null,"0-5","6-11","12-18","Total",null,null,null,{"$f":"ROUND(N147,1)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(P147,1)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Wilson",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15560]
[null,null,null,null,"Number Per Age Category",null,{"$f":"'Age of Children'!G9","v":0},{"$f":"'Age of Children'!H9","v":0},{"$f":"'Age of Children'!I9","v":1},{"$f":"I151+H151+G151","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woodson"]
[null,null,null,null,"Amount Per Child",null,{"$f":"Schedules!AJ19","v":0},{"$f":"Schedules!AK19","v":0},{"$f":"Schedules!AL19","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woodson"]
[null,null,null,null,"Total Amount",null,{"$f":"G152*G151","v":0},{"$f":"H152*H151","v":0},{"$f":"I152*I151","v":{"$error":"#N/A"}},{"$f":"I153+H153+G153","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wyandotte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ext. formula applied"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Schedules!AD27<50,Extended!I25,Schedules!AD27)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"Wyandotte"]
[]
[null,null,null,3,"Gross Child Support Obligation**",null,null,null,{"$f":"IF(L141<15500,\"\",AZ153)","v":""},null,null,{"$f":"J153","v":{"$error":"#N/A"}}]
[null,null,null,null,"* Interstate Pay Differential Adjustment?",null,null,{"$f":"IF(F86=\"Y\",N157,N159)","v":"No"},null,null,null,null,null,"Yes"]
[null,null,null,null,"**Multiple Family Application?",null,null,{"$f":"IF(F84=\"Y\",N157,N159)","v":"No"}]
[null,null,null,null,"    Number of Additional Children",null,null,{"$f":"I84","v":0},null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[]
[null,null,null,"Case No.",{"$f":"F12","v":0}]
[]
[null,null,"D. ","COMPUTATION OF CHILD SUPPORT",null,null,null,"MOTHER",null,"FATHER",null,"TOTAL",null,null,-5,-5,{"$f":"O164+P164","v":-10}]
[]
[null,null,null,3,"Gross Child Support Carried Over Page 1",null,null,null,null,null,null,{"$f":"L156","v":{"$error":"#N/A"}}]
[null,null,null,4,"Health and Dental Insurance Premium",null,null,{"$f":"F73","v":0},null,{"$f":"F74","v":0},null,{"$f":"H167+J167","v":0}]
[null,null,null,5,"Work-Related Child Care Costs",null,null,{"$f":"F71","v":0},null,{"$f":"F72","v":0},null,{"$f":"H168+J168","v":0}]
[null,null,null,null,"Formula: Amt. – ((Amt. X %) + (.25 x (Amt.  x  %)))"]
[null,null,null,null,"for each child care credit",null,null,null,null,null,null,null,700]
[null,null,null,null,"Example: 200 – ((200 x .30%) + (.25 x (200 x .30%)))",null,null,null,null,null,null,null,{"$f":"700*0.3","v":210}]
[null,null,null,null,"(Tax Credit)",null,null,{"$f":"-N172","v":0},null,{"$f":"-O172","v":0},null,{"$f":"H172+J172","v":0},null,{"$f":"IF(H168>0,'Day Care Credit'!N54)+OR(H168=0)*0","v":0},{"$f":"IF(J168>0,'Day Care Credit'!N54)+OR(J168=0)*0","v":0}]
[]
[]
[]
[]
[null,null,null,6,"Parents' Total Child Support",null,null,null,null,null,null,{"$f":"L156+L167+L168+L172","v":{"$error":"#N/A"}}]
[null,null,null,null,"(Line D3 plus D4 and D5)"]
[null,null,null,7,"Parent Child Support Oblig.",null,null,{"$f":"L177*H147/100","v":{"$error":"#N/A"}},null,{"$f":"L177*J147/100","v":{"$error":"#N/A"}}]
[null,null,null,8,"Adjustment for Health/Work Related",null,null,{"$f":"-(H167+H168+H172)","v":0},null,{"$f":"-(J167+J168+J172)","v":0}]
[null,null,null,9,"Basic Parental Child Support Obligation",null,null,{"$f":"H179+H180","v":{"$error":"#N/A"}},null,{"$f":"J179+J180","v":{"$error":"#N/A"}},null,{"$f":"J181+H181","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DAD","moM"]
[null,null,"E.","CHILD SUPPORT ADJUSTMENTS ",null,null,null,null,null,null,null,null,null,null,{"$f":"'Tax Cons.'!H52","v":0},{"$f":"'Tax Cons.'!H51","v":0},0]
[null,null,null,null,"            ",null,null,"MOTHER",null,"FATHER",null,null,null,null,"JAK Ex.","JAK HOH",5]
[null,null,null,1,"Long Distance Parenting Costs",null,null,{"$f":"IF(G95=\"Mother\",-H95,0)","v":0},null,{"$f":"IF(G95=\"Father\",-H95,0)","v":0},null,null,null,"        ",{"$f":"'Tax Cons.'!J13","v":{"$error":"#DIV/0!"}},{"$f":"'Tax Cons.'!J35","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q183:Q184)","v":5}]
[null,null,null,2,"Parenting Time Adjustment",null,null,{"$f":"IF(G99=\"Mother\",-H99,0)","v":0},null,{"$f":"IF(G99=\"Father\",-H99,0)","v":0}]
[null,null,null,3,"Income Tax Cons:   Exemption",null,null,{"$f":"BD189","v":0},null,{"$f":"BF189","v":0},null,null,null,{"$f":"'Tax Cons.'!J13","v":{"$error":"#DIV/0!"}},{"$f":"'Tax Cons.'!J31","v":{"$error":"#DIV/0!"}},{"$f":"'Tax Rates'!E72","v":{"$error":"#DIV/0!"}},{"$f":"-Q185","v":-5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Income Tax Cons:   Exemption",null,null,{"$f":"IF(F67=\"Y\",B68,0)","v":0},null,{"$f":"IF(F67=\"Y\",D68,0)","v":0}]
[null,null,null,4,"Income Tax Cons: Head of Household",null,null,{"$f":"'Tax Cons.'!J51","v":0},null,{"$f":"'Tax Cons.'!J52","v":0},null,null,null,null,{"$f":"IF(P189>0,\"=-O154\",0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F68=\"y\",2*B68,0)","v":0},null,{"$f":"IF(F68=\"y\",2*D68,0)","v":0}]
[null,null,null,5,"Special Needs",null,null,{"$f":"IF(G96=\"Mother\",-H96,0)","v":0},null,{"$f":"IF(G96=\"Father\",-H96,0)","v":0},null,null,null,{"$f":"'Tax Cons.'!Q6","v":0},{"$f":"-P189","v":0},{"$f":"AND(F34=\"y\",F41=\"y\",'Tax Rate'!T67)*'Tax Rate'!V67","v":0},null,null,null,null,null,null,null,null,"Difference",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BD187:BD188)","v":0},null,{"$f":"SUM(BF187:BF188)","v":0}]
[null,null,null,6,"Support Past Minority",null,null,{"$f":"IF(G97=\"Mother\",-H97,0)","v":0},null,{"$f":"IF(G97=\"Father\",-H97,0)","v":0},null,null,null,{"$f":"SUM(N187:N189)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O187:O189)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"Mother","Father"]
[null,null,null,7,"Overall Fin. Condition",null,null,{"$f":"IF(G98=\"Mother\",-H98,0)","v":0},null,{"$f":"IF(G98=\"Father\",-H98,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H198-J198","v":{"$error":"#N/A"}},{"$f":"J198-H198","v":{"$error":"#N/A"}}]
[null,null,null,8,"Total Adjustments",null,null,{"$f":"H185+H186+H187+H188+H189+H190+H191","v":0},null,{"$f":"SUM(J185:J191)","v":0},null,null,null,null,{"$f":"IF(F45=\"M\",L71,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F46=\"f\",L71,0)","v":0},null,null,null,null,"enforcement",null,{"$f":"Y205*0.02*0.5","v":{"$error":"#N/A"}},{"$f":"Z205*0.02*0.5","v":{"$error":"#N/A"}},null,"higher earner/pay earner"]
[null,null,"F.","ADJUSTED CHILD SUPPORT SUMMARY",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O192:O193)","v":0},null,null,null,null,null,null,{"$f":"IF(V193>5,5,V193)","v":{"$error":"#N/A"}},{"$f":"IF(W193>5,5,W193)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"MOTHER",null,"FATHER",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F45=\"M\",0,V194)","v":{"$error":"#N/A"}},{"$f":"IF(F45=\"f\",0,W194)","v":{"$error":"#N/A"}},null,"Father/Mother P","Mother/moth"]
[null,null,null,1,"Basic Parental Child Support",null,null,{"$f":"H181","v":{"$error":"#N/A"}},null,{"$f":"J181","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V195<0,0,V195)","v":{"$error":"#N/A"}},{"$f":"IF(W195<0,0,W195)","v":{"$error":"#N/A"}},null,"Father/father","Mother/fat"]
[null,null,null,2,{"$f":"IF(F90=\"N\",N209,T209)","v":"Section E Adjustments"},null,null,{"$f":"IF(F90=\"N\",R209,W209)","v":0},null,{"$f":"IF(F90=\"N\",S209,X209)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('EPT Draft'!K31>0,'EPT Draft'!K31,0)","v":{"$error":"#N/A"}},{"$f":"IF('EPT Draft'!K32<0,-'EPT Draft'!K32,0)","v":{"$error":"#N/A"}}]
[{"$f":"IF(F90=\"n\",\"\",'EPT Draft'!K23)","v":""},null,null,3,{"$f":"IF(F90=\"N\",N210,N210)","v":"Adjustment Subtotal"},null,null,{"$f":"R210","v":{"$error":"#N/A"}},null,{"$f":"S210","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"Mother","Father",null,null,null,{"$f":"IF('EPT Draft'!K32<0,-'EPT Draft'!K32,0)","v":{"$error":"#N/A"}},{"$f":"IF('EPT Draft'!K31>0,'EPT Draft'!K31,0)","v":{"$error":"#N/A"}}]
[null,null,null,4,"Parent Time Adjustment ",null,null,{"$f":"IF(F90=\"N\",R211,Y205)","v":0},{"$f":"IF(F90=\"n\",\"\",'EPT Draft'!K23)","v":""},{"$f":"IF(F90=\"N\",S211,Z205)","v":0},null,null,null,{"$f":"J196*0.02","v":{"$error":"#N/A"}},{"$f":"IF(F45=\"M\",N199,0)","v":0},{"$f":"IF(F45=\"F\",N199,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Y197:Y198)","v":{"$error":"#N/A"}},{"$f":"SUM(Z197:Z198)","v":{"$error":"#N/A"}}]
[null,null,null,5,"Enforcement Fee",null,null,{"$f":"IF(F90=\"N\",R221,V196)","v":{"$error":"#N/A"}},null,{"$f":"IF(F90=\"N\",S221,W196)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,{"$f":"H196-J196","v":{"$error":"#N/A"}},{"$f":"J196-H196","v":{"$error":"#N/A"}},null,null,{"$f":"'EPT Draft'!K31","v":{"$error":"#N/A"}},{"$f":"-'EPT Draft'!K32","v":{"$error":"#N/A"}}]
[null,null,null,6,"Net Parental Child Support Obligation",null,null,{"$f":"IF(F90=\"N\",R214,W213)","v":{"$error":"#N/A"}},null,{"$f":"IF(F90=\"N\",S213,X213)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,{"$f":"IF(T200>0,T200,0)","v":{"$error":"#N/A"}},{"$f":"IF(U200>0,U200,0)","v":{"$error":"#N/A"}}]
[null,null,null,"   ","         ",null,null,null,null,null,null,null,null,"Father","Mother",null,null,null,null,{"$f":"IF(T201>0,W201,0)","v":{"$error":"#N/A"}},{"$f":"IF(U201>0,W201,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J198>H198,-'EPT Draft'!K32,0)","v":{"$error":"#N/A"}},{"$f":"IF(H198>J198,-'EPT Draft'!K32,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J198<H198,'EPT Draft'!K31,0)","v":{"$error":"#N/A"}},{"$f":"IF(H198<J198,'EPT Draft'!K31,0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"Mother","Father"]
[null,null,null,null,null,null,null,"___________________________________",null,null,null,null,null,{"$f":"SUM(N203:N204)","v":{"$error":"#N/A"}},{"$f":"SUM(O203:O204)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,{"$f":"'EPT Draft'!Q26","v":{"$error":"#N/A"}},{"$f":"'EPT Draft'!P26","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"Judge/Hearing Officer",null,null,null,null,null,{"$f":"IF(F90=\"Y\",N205,0)","v":0},{"$f":"IF(F90=\"Y\",O205,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(H198>J198,Y205,0)","v":{"$error":"#N/A"}},{"$f":"IF(J198>H198,Z205,0)","v":{"$error":"#N/A"}}]
[]
[null,null,"s/",{"$f":"C100","v":0},null,{"$f":"IF(G100=\"\",\"\",G100)","v":""},null,"___________________________________",null,null,null,null,null,null,null,null,null,"Mother","Father",null,null,null,"Mother","Father"]
[null,null,null,{"$f":"C101","v":0},null,null,null,"Date Signed",null,null,null,null,null,"Section E Adjustments",null,null,null,{"$f":"H192","v":0},{"$f":"J192","v":0},"Section E Adjustments",null,null,{"$f":"R209","v":0},{"$f":"S209","v":0}]
[null,null,null,{"$f":"G101","v":0},null,null,null,null,null,null,null,null,null,"Adjustment Subtotal",null,null,null,{"$f":"H196+H197","v":{"$error":"#N/A"}},{"$f":"J196+J197","v":{"$error":"#N/A"}},"Difference Adj. Subtotal",null,null,{"$f":"T201","v":{"$error":"#N/A"}},{"$f":"U201","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"C102","v":0},null,"Phone",null,"___________________________________",null,null,null,null,null,"Parenting Time Adjustment",null,null,null,0,0,"Parenting  Adjustment"]
[null,null,null,{"$f":"G102","v":0},null,"Fax",null,"Date Approved",null,null,null,null,null,"Enforcement Fee"]
[null,null,null,{"$f":"C103","v":0},null,null,null,null,null,null,null,null,null,"Net Parental Child Support Obligation",null,null,null,{"$f":"H198+H199+H200","v":{"$error":"#N/A"}},{"$f":"J198+J199+J200","v":{"$error":"#N/A"}},"Net Parental Child Support",null,null,{"$f":"Y206+H200","v":{"$error":"#N/A"}},{"$f":"Z206+J200","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"F104","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F45=\"Mother\",0,R213)","v":{"$error":"#N/A"}},{"$f":"IF(F45=\"Father\",0,S213)","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(F45=\"Mother\",0,1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R213:R214)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H198*0.02","v":{"$error":"#N/A"}},{"$f":"J198*0.02","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"            ",null,null,null,"        ",null,null,null,null,null,null,{"$f":"R217/2","v":{"$error":"#N/A"}},{"$f":"S217/2","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R218>5,5,R218)","v":{"$error":"#N/A"}},{"$f":"IF(S218>5,5,S218)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F45=\"Mother\",0,H75)","v":0},{"$f":"IF(G45=\"Father\",0,H75)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F45=\"Mother\",0,R219)","v":{"$error":"#N/A"}},{"$f":"IF(G45=\"Father\",0,S219)","v":{"$error":"#N/A"}}]
[null,null,null,"Johnson  ",null,"Alabama"]
[null,null,null,"Allen  ",null,"Alaska",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F75=\"Y\",H75,R221)","v":{"$error":"#N/A"}},{"$f":"IF(F75=\"Y\",H75,S221)","v":{"$error":"#N/A"}}]
[null,null,null,"Anderson  ",null,"Arizona"]
[null,null,null,"Atchison  ",null,"Arkansas"]
[null,null,null,"Barber  ",null,"California "]
[null,null,null,"Barton  ",null,"Colorado "]
[null,null,null,"Bourbon  ",null,"Connecticut "]
[null,null,null,"Brown  ",null,"Delaware "]
[null,null,null,"Butler  ",null,"District of Columbia "]
[null,null,null,"Chase  ",null,"Florida "]
[null,null,null,"Chautauqua  ",null,"Georgia "]
[null,null,null,"Cherokee  ",null,"Hawaii "]
[null,null,null,"Cheyenne  ",null,"Idaho"]
[null,null,null,"Clark  ",null,"Illinois"]
[null,null,null,"Clay  ",null,"Indiana "]
[null,null,null,"Cloud  ",null,"Iowa"]
[null,null,null,"Coffey  ",null,"Kansas "]
[null,null,null,"Comanche  ",null,"Kentucky "]
[null,null,null,"Cowley  ",null,"Louisiana "]
[null,null,null,"Crawford  ",null,"Maine "]
[null,null,null,"Decatur  ",null,"Maryland "]
[null,null,null,"Dickinson  ",null,"Massachusetts "]
[null,null,null,"Doniphan  ",null,"Michigan "]
[null,null,null,"Douglas  ",null,"Minnesota"]
[null,null,null,"Edwards  ",null,"Mississippi "]
[null,null,null,"Elk  ",null,"Missouri "]
[null,null,null,"Ellis  ",null,"Montana "]
[null,null,null,"Ellsworth  ",null,"Nebraska "]
[null,null,null,"Finney  ",null,"Nevada "]
[null,null,null,"Ford  ",null,"New Hampshire"]
[null,null,null,"Franklin  ",null,"New Jersey"]
[null,null,null,"Geary  ",null,"New Mexico "]
[null,null,null,"Gove  ",null,"New York "]
[null,null,null,"Graham  ",null,"North Carolina "]
[null,null,null,"Grant  ",null,"North Dakota "]
[null,null,null,"Gray  ",null,"Ohio "]
[null,null,null,"Greeley  ",null,"Oklahoma "]
[null,null,null,"Greenwood  ",null,"Oregon "]
[null,null,null,"Hamilton  ",null,"Pennsylvania "]
[null,null,null,"Harper  ",null,"Rhode Island "]
[null,null,null,"Harvey  ",null,"South Carolina "]
[null,null,null,"Haskell  ",null,"South Dakota "]
[null,null,null,"Hodgeman  ",null,"Tennessee "]
[null,null,null,"Jackson  ",null,"Texas "]
[null,null,null,"Jefferson  ",null,"Utah"]
[null,null,null,"Jewell  ",null,"Vermont "]
[null,null,null,"Johnson  ",null,"Virginia "]
[null,null,null,"Kearny  ",null,"Washington"]
[null,null,null,"Kingman  ",null,"West Virginia "]
[null,null,null,"Kiowa  ",null,"Wisconsin "]
[null,null,null,"Labette  ",null,"Wyoming "]
[null,null,null,"Lane  "]
[null,null,null,"Leavenworth  "]
[null,null,null,"Lincoln  "]
[null,null,null,"Linn  "]
[null,null,null,"Logan  "]
[null,null,null,"Lyon  "]
[null,null,null,"McPherson  "]
[null,null,null,"Marion  "]
[null,null,null,"Marshall  "]
[null,null,null,"Meade  "]
[null,null,null,"Miami  "]
[null,null,null,"Mitchell  "]
[null,null,null,"Montgomery  "]
[null,null,null,"Morris  "]
[null,null,null,"Morton  "]
[null,null,null,"Nemaha  "]
[null,null,null,"Neosho  "]
[null,null,null,"Ness  "]
[null,null,null,"Norton  "]
[null,null,null,"Osage  "]
[null,null,null,"Osborne  "]
[null,null,null,"Ottawa  "]
[null,null,null,"Pawnee  "]
[null,null,null,"Phillips  "]
[null,null,null,"Pottawatomie  "]
[null,null,null,"Pratt  "]
[null,null,null,"Rawlins  "]
[null,null,null,"Reno  "]
[null,null,null,"Republic  "]
[null,null,null,"Rice  "]
[null,null,null,"Riley  "]
[null,null,null,"Rooks  "]
[null,null,null,"Rush  "]
[null,null,null,"Russell  "]
[null,null,null,"Saline  "]
[null,null,null,"Scott  "]
[null,null,null,"Sedgwick  "]
[null,null,null,"Seward  "]
[null,null,null,"Shawnee  "]
[null,null,null,"Sheridan  "]
[null,null,null,"Sherman  "]
[null,null,null,"Smith  "]
[null,null,null,"Stafford  "]
[null,null,null,"Stanton  "]
[null,null,null,"Stevens  "]
[null,null,null,"Sumner  "]
[null,null,null,"Thomas  "]
[null,null,null,"Trego  "]
[null,null,null,"Wabaunsee  "]
[null,null,null,"Wallace  "]
[null,null,null,"Washington  "]
[null,null,null,"Wichita  "]
[null,null,null,"Wilson  "]
[null,null,null,"Woodson  "]
[null,null,null,"Wyandotte  "]

{"sheet":"Day Care Credit","index":1,"n_rows":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,null,"Day Care Computation"]
[]
[]
[]
[]
[null,null,null,"Work Related Day Care"]
[null,null,null,null,null,null,null,1,2,{"$f":"Worksheet!J151","v":1}]
[null,null,null,null,15000,0.35,null,88,175]
[null,null,null,null,17000,0.34,null,85,170]
[null,null,null,null,19000,0.33,null,83,165]
[null,null,null,null,21000,0.32,null,80,160]
[null,null,null,null,23000,0.31,null,78,155]
[null,null,null,null,25000,0.3,null,75,150]
[null,null,null,null,27000,0.28999999999999998,null,73,145]
[null,null,null,null,29000,0.28000000000000003,null,70,140]
[null,null,null,null,31000,0.27,null,68,135]
[null,null,null,null,33000,0.26,null,65,130]
[null,null,null,null,35000,0.25,null,63,125]
[null,null,null,null,37000,0.24000000000000099,null,60,120]
[null,null,null,null,39000,0.23000000000000101,null,58,115]
[null,null,null,null,41000,0.220000000000001,null,55,110]
[null,null,null,null,43000,0.21000000000000099,null,53,105]
[null,null,null,null,45000,0.20000000000000101,null,50,100]
[null,null,null,null,47000,0.190000000000001,null,47.5]
[null,null,null,null,49000,0.18000000000000099,null,45]
[null,null,null,null,51000,0.17000000000000101,null,42.5]
[null,null,null,null,53000,0.160000000000001,null,40]
[null,null,null,null,55000,0.15000000000000099,null,37.5]
[null,null,null,null,57000,0.14000000000000101,null,35]
[null,null,null,null,null,"monthly","annually"]
[null,null,null,null,"Mother",{"$f":"Worksheet!H135+Worksheet!H137+Worksheet!H138","v":0},12,{"$f":"F34*G34","v":0},{"$f":"IF(Worksheet!H168>0,H34,0)","v":0},null,"`"]
[null,null,null,null,"Father",{"$f":"Worksheet!J135+Worksheet!J137+Worksheet!J138","v":0},12,{"$f":"F35*G35","v":0},{"$f":"IF(Worksheet!J168>0,H35,0)","v":0},null,"Number of Kids"]
[null,null,null,null,"Day Care Payor",null,{"$f":"I34+I35","v":0},null,null,null,{"$f":"Worksheet!F65","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AND(K36=1,G36<E11)*H11","v":0},"<15000",{"$f":"AND(K36>1,G36<E11)*175","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AND(K36=1,G36>=E11,G36<E12)*H12","v":0},"<17000",{"$f":"AND(K36>1,G36>=E11,G36<E12)*I12","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AND(K36=1,G36>=E12,G36<E13)*H13","v":0},"<19000",{"$f":"AND(K36>1,G36>=E12,G36<E13)*I13","v":0}]
[null,null,null,null,"Main Rec. by Payor",null,"Dcare","Main. Rec","Main Pd",null,{"$f":"AND(K36=1,G36>=E13,G36<E14)*H14","v":0},"<21000",{"$f":"AND(K36>1,G36>=E13,G36<E14)*I14","v":0}]
[null,null,null,null,"Mother",null,{"$f":"IF(Worksheet!F71>0,Worksheet!F71,0)","v":0},{"$f":"IF(Worksheet!H138>0,Worksheet!H138,0)","v":0},null,null,{"$f":"AND(K36=1,G36>=E14,G36<E15)*H15","v":0},"<23000",{"$f":"AND(K36>1,G36>=E14,G36<E15)*I15","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AND(K36=1,G36>=E15,G36<E16)*H16","v":0},"<25000",{"$f":"AND(K36>1,G36>=E15,G36<E16)*I16","v":0}]
[null,null,null,null,"Father",null,{"$f":"IF(Worksheet!F72>0,Worksheet!F72,0)","v":0},{"$f":"IF(Worksheet!J138>0,Worksheet!J138,0)","v":0},null,null,{"$f":"AND(K36=1,G36>=E16,G36<E17)*H17","v":0},"<27000",{"$f":"AND(K36>1,G36>=E16,G36<E17)*I17","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AND(K36=1,G36>=E17,G36<E18)*H18","v":0},"<29000",{"$f":"AND(K36>1,G36>=E17,G36<E18)*I18","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AND(K36=1,G36>=E18,G36<E19)*H19","v":0},"<31000",{"$f":"AND(K36>1,G36>=E18,G36<E19)*I19","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AND(K36=1,G36>=E19,G36<E20)*H20","v":0},"<33000",{"$f":"AND(K36>1,G36>=E19,G36<E20)*I20","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AND(K36=1,G36>=E20,G36<E21)*H21","v":0},"<35000",{"$f":"AND(K36>1,G36>=E20,G36<E21)*I21","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AND(K36=1,G36>=E21,G36<E22)*H22","v":0},"<37000",{"$f":"AND(K36>1,G36>=E21,G36<E22)*I22","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AND(K36=1,G36>=E22,G36<E23)*H23","v":0},"<39000",{"$f":"AND(K36>1,G36>=E22,G36<E23)*I23","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AND(K36=1,G36>=E23,G36<E24)*H24","v":0},"<41000",{"$f":"AND(K36>1,G36>=E23,G36<E24)*I24","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AND(K36=1,G36>=E24,G36<E25)*H25","v":0},"<43000",{"$f":"AND(K36>1,G36>=E24,G36<E25)*I25","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AND(K36=1,G36>=E25,G36<E26)*H26","v":0},"<45000",{"$f":"AND(K36>1,G36>=E25,G36<E26)*I26","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AND(K36=1,G36>=E26)*H26","v":0},"<47000",{"$f":"AND(K36>1,G36>=E26)*I26","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K37:K53)","v":0},null,{"$f":"SUM(M37:M53)","v":0},{"$f":"K54+M54","v":0}]

{"sheet":"Tax Rate","index":2,"n_rows":78,"n_cols":22,"rows_kept":78,"cut":false,"hidden":true,"merged":[[18,13,18,14],[41,4,41,5],[41,7,41,8],[40,4,40,9],[42,4,42,5]]}
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Worksheet!F34=\"N\",Worksheet!F45=\"M\")*Worksheet!F21","v":0},null,"Mother Cust Not HH"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Worksheet!F34=\"N\",Worksheet!F45=\"F\")*Worksheet!F16","v":0},null,"Father Cust Not HH",null,null,null,null,null,null,null,null,"noncustodial"]
[null,null,null,null,null,null,null,null,null,{"$f":"K4+K5","v":0},{"$f":"IF(Worksheet!F45=\"M\",Worksheet!F34=\"Y\")*Worksheet!F21","v":0},"Mother Head of HH",null,null,null,"Noncustodial",null,"Gross",{"$f":"IF(Worksheet!F45=\"m\",Worksheet!F16,Worksheet!F21)","v":0},null,"federal tax rates"]
[null,null,null,null,null,null,null,null,null,50000,{"$f":"IF(Worksheet!F45=\"F\",Worksheet!F34=\"Y\")*Worksheet!F16","v":0},"Father Head of HH",null,null,null,null,null,null,null,null,"Single","Joint"]
[null,null,null,null,"Federal",null,null,2013,null,null,{"$f":"K4+K5","v":0},null,null,null,null,"Single",null,"Joint"]
[null,null,null,"(HOH)","Standard Deduction",null,null,8950,null,null,null,null,null,"Stand. Deduction",null,6100,null,12200,null,null,{"$f":"IF(S4>E27,S4<E28)*F28","v":0},{"$f":"IF(S4>M27,S4<M28)*N28","v":0}]
[null,null,null,null,"Normal Exemption",null,null,3900,null,null,null,null,null,"Normal Exempt",null,3900,null,3900,null,null,{"$f":"IF(S4>=E28,S4<E29)*F29","v":0},{"$f":"IF(S4>=M28,S4<M29)*N29","v":0}]
[null,null,null,null,"Available Exemption",null,null,3900,null,null,null,null,null,"Total Deduction",null,{"$f":"SUM(P7:P8)","v":10000},null,{"$f":"SUM(R7:R8)","v":16100},null,null,{"$f":"IF(S4>=E29,S4<E30)*F30","v":0},{"$f":"IF(S4>=M29,S4<M30)*N30","v":0}]
[null,null,null,null,"Parent's Exemption",null,null,1,null,null,null,null,null,"Fed Adj Gross",null,{"$f":"S4-P9","v":-10000},null,{"$f":"S4-R9","v":-16100},null,null,{"$f":"IF(S4>=E30,S4<E31)*F31","v":0},{"$f":"IF(S4>=M30,S4<M31)*N31","v":0}]
[null,null,null,null,"Exemption Value",null,null,3900,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S4>=E31,S4<E32)*F32","v":0},{"$f":"IF(S4>=M31,S4<M32)*N32","v":0}]
[null,null,null,null,"Deduction's Total",null,null,{"$f":"H7+H8","v":12850},null,null,null,null,null,"Federal","Single",{"$f":"U14","v":0},null,null,null,null,{"$f":"IF(S4>=E32,S4<E33)*F33","v":0},{"$f":"IF(S4>=M32,S4<M33)*N33","v":0}]
[null,null,null,null,"FEDERAL ADJ. GROSS",null,null,{"$f":"J5-H12","v":37150},null,null,null,null,null,null,"Joint",{"$f":"V14","v":0},null,null,null,null,{"$f":"IF(S4>=E33,E33,0)","v":0},{"$f":"IF(S4>=M33,M33,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U7:U13)","v":0},{"$f":"SUM(V7:V13)","v":0}]
[null,null,null,null,"State",null,null,null,null,null,null,null,null,null,null,"State"]
[null,null,null,"(HOH) ","Standard Ded.",null,null,9000,null,null,null,null,null,null,null,"Single",null,"Joint",null,"Ks Margin Rate",null,"Single"]
[null,null,null,null,"Normal Exemption",null,null,2250,null,null,null,null,null,null,"Standard",3000,null,9000,null,null,null,{"$f":"IF(S4>I27,S4<I28)*0.035","v":0}]
[null,null,null,null,"# of Claims",null,null,2,null,null,null,{"$f":"Worksheet!J151","v":1},null,"(Parent)","Exemption",2250,null,2250,null,null,null,{"$f":"IF(S4>=I28,0.049)","v":false}]
[null,null,null,null,"(parent plus number of child)",null,null,null,null,null,null,null,null,"Total Deduction",null,5250,null,11250,null,null,null,{"$f":"SUM(V17:V18)","v":0}]
[null,null,null,null,"Exemption Value",null,null,{"$f":"H18*H17","v":4500},null,null,null,null,null,"KS Adj Gross",null,{"$f":"S4-P19","v":-5250},null,{"$f":"S4-R19","v":-11250}]
[null,null,null,null,"Ded. Total",null,null,{"$f":"H20+H16","v":13500}]
[null,null,null,null,"KANSAS ADJUST GROSS",null,null,{"$f":"J5-H21","v":36500},null,null,null,null,null,"Ks Margin Rate","Ks",{"$f":"V19","v":0},null,{"$f":"V25","v":0},null,null,null,"Joint"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S4>I27,S4<I28)*0.035","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S4>=I28,0.049)","v":false}]
[null,null,null,null,"Federal Tax Rate",null,null,null,"State",null,null,null,"Federal Married filing Jointly",null,null,null,"Federal Head of Household",null,null,null,null,{"$f":"SUM(V23:V24)","v":0}]
[null,null,null,null,"Single",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,0,3.5,null,null,0,null,null,null,12400,10]
[null,null,null,null,8700,10,null,null,15000,4.9000000000000004,null,null,17400,10,null,null,47350,15,1240]
[null,null,null,null,35350,15,null,null,30000,null,null,null,70700,15,1740,null,122300,25,68483]
[null,null,null,null,85650,25,null,null,null,null,null,null,142700,25,9735,null,198050,28,25220]
[null,null,null,null,178650,28,null,null,null,null,null,null,217450,28,27735,null,388350,33,46430]
[null,null,null,null,388350,33,null,null,null,null,null,null,388350,33,48665,null,388351,35,109229]
[null,null,null,null,388351,35,null,null,null,null,null,null,388351,35,105062]
[]
[null,null,null,null,"Head of Household Exemption"]
[null,null,null,null,"Federal",null,null,null,"Kansas Increase",null,"KS Exempt."]
[null,null,null,null,2013,null,null,null,2013,null,2013]
[null,null,null,"Single",null,6100,null,null,3000,null,2250]
[null,null,null,"Head of Household",null,8950,null,null,9000]
[null,null,null,"Benefit",null,{"$f":"F39-F38","v":2850},null,null,{"$f":"I39-I38","v":6000}]
[null,null,null,null,"HEAD OF HOUSEHOLD TAX BENEFIT"]
[null,null,null,null,{"$f":"Worksheet!E10","v":0},null,"and",{"$f":"Worksheet!E11","v":0}]
[null,null,null,null,{"$f":"Worksheet!F12","v":0},null,null,null,null,null,"Kansas"]
[null,null,null,null,"Head of Household Benefit",null,null,null,null,null,"Marginal Tax Rate"]
[null,null,null,null,"Kansas",null,null,null,null,null,null,null,null,null,"Father",null,"Mother"]
[null,null,null,null,"Value of Extra Exemption",null,null,{"$f":"K38","v":2250},null,null,{"$f":"IF(J5>I27,J5<I28)*0.035","v":0},null,null,null,{"$f":"IF(K4>I27,J5<I28)*0.035","v":0},null,{"$f":"IF(K5>I27,J5<I28)*0.035","v":0},2250]
[null,null,null,null,"Cust Parent's Marginal Tax Rate",null,null,{"$f":"K48","v":4.9000000000000002E-2},null,null,{"$f":"IF(J5>=I28,0.049)","v":4.9000000000000002E-2},null,null,null,{"$f":"IF(K4>=I28,0.049)","v":false},null,{"$f":"IF(K5>=I28,0.049)","v":false},null,"Father","Mother"]
[null,null,null,null,"Annual Tax Savings",null,null,{"$f":"H46*H47","v":110.25},null,null,{"$f":"K46+K47","v":4.9000000000000002E-2},null,null,null,{"$f":"O47*R46","v":0},null,{"$f":"Q47*R46","v":0},null,{"$f":"O51","v":{"$error":"#DIV/0!"}},{"$f":"Q51","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Monthly Tax Savings",null,null,{"$f":"H48/12","v":9.1875},null,null,null,null,null,null,{"$f":"O48/12","v":0},null,{"$f":"Q48/12","v":0}]
[null,null,null,null,"% Income Noncustodial",null,null,{"$f":"Worksheet!J147","v":{"$error":"#DIV/0!"}},null,{"$f":"H51","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"Worksheet!H147","v":{"$error":"#DIV/0!"}},null,{"$f":"Worksheet!J147","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Noncustodial's Share",null,null,{"$f":"H50*H49/100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"O50*O49/100","v":{"$error":"#DIV/0!"}},null,{"$f":"Q50*Q49/100","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,"Standard Deduction Benefit",null,null,null,null,null,"Federal","HOH",null,null,null,"Federal Married",null,"Federal Married"]
[null,null,null,null,"Federal",null,null,{"$f":"F40","v":2850},null,null,"Marginal Tax Rate",null,null,null,null,null,null,null,null,2850]
[null,null,null,null,"Cust Parent's Marginal Tax Rate",null,null,{"$f":"IF(Worksheet!F34=\"Y\",K62,P62)","v":15},null,null,{"$f":"IF(J5>Q26,J5<Q27)*R27","v":0},null,null,null,null,{"$f":"IF(J5>M27,J5<M28)*N28","v":0},null,{"$f":"IF(L5>O27,L5<O28)*P28","v":0},null,{"$f":"U77","v":0},null,{"$f":"V77","v":0}]
[null,null,null,null,"Value Tax Savings",null,null,{"$f":"H56*H55/100","v":427.5},null,null,{"$f":"IF(J5>=Q27,J5<Q28)*R28","v":0},null,null,null,null,{"$f":"IF(J5>=M28,J5<M29)*N29","v":15},null,{"$f":"IF(L5>=O28,L5<O29)*P29","v":0},null,{"$f":"T56*T55/100","v":0},null,{"$f":"V56*T55/100","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J5>=Q28,J5<Q29)*R29","v":25},null,null,null,null,{"$f":"IF(J5>=M29,J5<M30)*N30","v":0},null,{"$f":"IF(L5>=O29,L5<O30)*P30","v":0}]
[null,null,null,null,"Kansas",null,null,{"$f":"I40","v":6000},null,null,{"$f":"IF(J5>=Q29,J5<Q30)*R30","v":0},null,null,null,null,{"$f":"IF(J5>=M30,J5<M31)*N31","v":0},null,{"$f":"IF(L5>=O30,L5<O31)*P31","v":0},null,6000,null,6000]
[null,null,null,null,"Cust Parent's Marginal Tax Rate",null,null,{"$f":"H47","v":4.9000000000000002E-2},null,null,{"$f":"IF(J5>Q30,J5<Q31)*R31","v":0},null,null,null,null,{"$f":"IF(J5>=M31,J5<M32)*N32","v":0},null,{"$f":"IF(L5>=O31,L5<O32)*P32","v":0},null,{"$f":"U77","v":0},null,{"$f":"V77","v":0}]
[null,null,null,null,"Value of Tax Savings",null,null,{"$f":"H59*H60","v":294},null,null,{"$f":"IF(J5>Q31,35)*R27","v":0},null,null,null,null,{"$f":"IF(J5>=M32,J5<M33)*N33","v":0},null,{"$f":"IF(L5>=O32,L5<O33)*P33","v":0},null,{"$f":"T60*T59","v":0},null,{"$f":"V60*V59","v":0}]
[null,null,null,null,"Total Tax Savings",null,null,{"$f":"H57+H61","v":721.5},null,null,{"$f":"SUM(K56:K61)","v":25},null,null,null,null,{"$f":"SUM(P56:P61)","v":15},null,{"$f":"SUM(R56:R61)","v":0},null,{"$f":"T61+T57","v":0},null,{"$f":"V61+V57","v":0}]
[null,null,null,null,"Mother's Monthly Tax Savings",null,null,{"$f":"H62/12","v":60.125},null,null,null,null,null,null,null,null,null,null,null,{"$f":"T62/12","v":0},null,{"$f":"V62/12","v":0}]
[null,null,null,null,"Noncust Parent's % of Income",null,null,{"$f":"H50","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"T63/12","v":0},null,{"$f":"V63/12","v":0}]
[null,null,null,null,"Noncust Parent's  Share",null,null,{"$f":"H64*H63/100","v":{"$error":"#DIV/0!"}},null,{"$f":"H65","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,{"$f":"T64*T63/100","v":0},null,{"$f":"V63*V64/100","v":0}]
[null,null,null,null,"Adjustment",null,null,null,null,{"$f":"J50+J65","v":{"$error":"#DIV/0!"}},null,null,{"$f":"J66","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"T65+U48","v":0},null,{"$f":"V65+V48","v":0}]
[null,null,null,null,"Remove HOH",null,null,null,null,{"$f":"IF(K4=0,K5=0)*-J66","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"T66-V66","v":0}]
[null,null,null,null,"TOTAL ADJUSTMENT",null,null,null,null,{"$f":"J66+J67","v":{"$error":"#DIV/0!"}},null,null,{"$f":"ROUND(J66,0)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"If not alternate",null,"Assumes Single then Joint",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M5>S26,M5<S27)*T27","v":0},{"$f":"IF(M4>S26,M4<S27)*T27","v":0}]
[null,null,null,null,"Exemption x tax rate is annual value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M5>=S27,M5<S28)*T28","v":0},{"$f":"IF(M4>S27,M4<S28)*T28","v":0}]
[null,null,null,null,"Federal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M5>=S28,M5<S29)*T29","v":0},{"$f":"IF(M4>S28,M4<S29)*T29","v":0}]
[null,null,null,null,{"$f":"H8","v":3900},"x",{"$f":"IF(Worksheet!F43=\"y\",'Tax Rate'!P12)*P13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M5>=S29,M5<S30)*T30","v":0},{"$f":"IF(M4>S29,M4<S30)*T30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M5>=S30,M5<S31)*T31","v":0},{"$f":"IF(M4>S30,M4<S31)*T31","v":0}]
[null,null,null,null,"State",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M5>=S31,M5<S32)*T32","v":0},{"$f":"IF(M4>S31,M4<S32)*T32","v":0}]
[null,null,null,null,{"$f":"H17","v":2250},"x ",{"$f":"IF(Worksheet!F43=\"y\",'Tax Rate'!P22)*R22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M5>=S32,M5<S33)*T33","v":0},{"$f":"IF(M4>S32,M4<S33)*T33","v":0}]
[null,null,null,null,null,null,{"$f":"G73+G76","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U70:U76)","v":0},{"$f":"SUM(V70:V76)","v":0}]
[null,null,null,null,null,null,{"$f":"G77/2","v":0}]

{"sheet":"Age of Children","index":3,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,"0-5","6-11","12-18"]
[null,"Child 1",{"$f":"Worksheet!F48","v":"00:00:00"},null,0,null,{"$f":"IF(C6>E3,C6<E4)*1","v":0},{"$f":"IF(C6>=E4,C6<E5)*1","v":0},{"$f":"IF(C6>=E5,1,0)","v":1}]
[null,null,{"$f":"TODAY()","v":"2013-09-11"},null,5.5,null,{"$f":"IF(C11>E3,C11<E4)*1","v":0},{"$f":"IF(C11>=E4,C11<E5)*1","v":0},{"$f":"IF(C11>=E5,1,0)","v":0}]
[null,null,{"$f":"C4-C3","v":41528},null,11.5,null,{"$f":"IF(C16>E3,C16<E4)*1","v":0},{"$f":"IF(C16>=E4,C16<E5)*1","v":0},{"$f":"IF(C16>=E5,1,0)","v":0}]
[null,null,{"$f":"C5/365","v":113.77534246575343},null,null,null,{"$f":"IF(C21>E3,C21<E4)*1","v":0},{"$f":"IF(C21>=E4,C21<E5)*1","v":0},{"$f":"IF(C21>=E5,1,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(C26>E3,C26<E4)*1","v":0},{"$f":"IF(C26>=E4,C26<E5)*1","v":0},{"$f":"IF(C26>=E5,1,0)","v":0}]
[null,"Child 2",{"$f":"Worksheet!F52","v":"NA"},null,null,null,{"$f":"IF(C31>E3,C31<E4)*1","v":0},{"$f":"IF(C31>=E4,C31<E5)*1","v":0},{"$f":"IF(C31>=E5,1,0)","v":0}]
[null,null,{"$f":"TODAY()","v":"2013-09-11"},null,null,null,{"$f":"SUM(G3:G8)","v":0},{"$f":"SUM(H3:H8)","v":0},{"$f":"SUM(I3:I8)","v":1}]
[null,null,{"$f":"IF(C8=\"na\",0,C9-C8)","v":0}]
[null,null,{"$f":"C10/365","v":0}]
[]
[null,"Child 3",{"$f":"Worksheet!F56","v":"NA"}]
[null,null,{"$f":"TODAY()","v":"2013-09-11"}]
[null,null,{"$f":"IF(C13=\"na\",0,C14-C13)","v":0}]
[null,null,{"$f":"C15/365","v":0}]
[]
[null,"Child 4",{"$f":"Worksheet!F60","v":"NA"}]
[null,null,{"$f":"TODAY()","v":"2013-09-11"}]
[null,null,{"$f":"IF(C18=\"na\",0,C19-C18)","v":0}]
[null,null,{"$f":"C20/365","v":0}]
[]
[null,"Child 5",{"$f":"Worksheet!F61","v":"NA"}]
[null,null,{"$f":"TODAY()","v":"2013-09-11"}]
[null,null,{"$f":"IF(C23=\"na\",0,C24-C23)","v":0}]
[null,null,{"$f":"C25/365","v":0}]
[]
[null,"Child 6",{"$f":"Worksheet!F63","v":"NA"}]
[null,null,{"$f":"TODAY()","v":"2013-09-11"}]
[null,null,{"$f":"IF(C28=\"na\",0,C29-C28)","v":0}]
[null,null,{"$f":"C30/365","v":0}]

{"sheet":"Tax Cons.","index":4,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,8,2,8],[1,7,2,7]]}
[null,null,null,null,{"$f":"Worksheet!D162","v":"Case No."},{"$f":"Worksheet!E162","v":0}]
[null,null,null,null,null,null,null,"Exempt Value","Non Cust Tax Rate","Product"]
[null,null,null,null,"Tax Ex. Not Alternated"]
[null,null,null,null,"Tax Exemption (Federal)",null,null,3900,{"$f":"H40","v":0},{"$f":"H4*I4","v":0}]
[null,null,null,null,"Tax Exemption (State)",null,null,2250,{"$f":"H44","v":0},{"$f":"H5*I5","v":0}]
[null,null,null,null,"Annual Value",null,null,null,null,{"$f":"SUM(J4:J5)","v":0}]
[null,null,null,null,"Noncustodial % of Earnings",null,null,null,null,{"$f":"H48","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Noncustodial's Value",null,null,null,null,{"$f":"J6*J7/100","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Monthly Value",null,null,null,null,{"$f":"J8/12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Number of More Children Claimed by Mother",null,null,null,null,{"$f":"Worksheet!N73","v":0},null,null,"Mother",{"$f":"IF(J10>0,M20,-M20)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Number of More Children Claimed by Father",null,null,null,null,{"$f":"Worksheet!M73","v":0},null,null,"Father",{"$f":"IF(J11>0,M20,-M20)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Sum",null,null,null,null,{"$f":"J10+J11","v":0}]
[null,null,null,null,"Tax Consideration ",null,null,null,null,{"$f":"J9*J12","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Additional Tax Credit",null,null,1000,null,1000]
[null,null,null,null,"Noncustodial % of Earnings",null,null,null,null,{"$f":"J7","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Annual Value Noncustodial",null,null,null,null,{"$f":"J15*J16/100","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Monthly Value Noncustodial",null,null,null,null,{"$f":"J17/12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Number of More Children Claimed by Mother",null,null,null,null,{"$f":"J10","v":0}]
[null,null,null,null,"Number of More Children Claimed by Father",null,null,null,null,{"$f":"J11","v":0},null,null,{"$f":"J13+J22","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Sum",null,null,null,null,{"$f":"J12","v":0}]
[null,null,null,null,"Tax Consideration ",null,null,null,null,{"$f":"J18*J21","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Head of Household"]
[null,null,null,null,"Federal",null,null,2850,{"$f":"H41","v":0},{"$f":"H25*I25","v":0},{"$f":"H25*I25","v":0}]
[null,null,null,null,"State",null,null,6000,{"$f":"H45","v":0},{"$f":"H26*I26","v":0}]
[null,null,null,null,"Add.",null,null,2250,{"$f":"H45","v":0},0]
[null,null,null,null,"Annual Value",null,null,null,null,{"$f":"SUM(J25:J27)","v":0}]
[null,null,null,null,"Noncustodial % of Earnings",null,null,null,null,{"$f":"H48","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Noncustodial's Value",null,null,null,null,{"$f":"J28*J29/100","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Monthly Value",null,null,null,null,{"$f":"J30/12","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Exemption Value",null,null,null,null,{"$f":"J13","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Tax Credit Value",null,null,null,null,{"$f":"J22","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Head of Household Value",null,null,null,null,{"$f":"J31","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Total Tax Consideration",null,null,null,null,{"$f":"SUM(J33:J35)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Federal"]
[null,null,null,null,"Noncustodial Parent ",null,null,{"$f":"'Tax Rates'!K57","v":0}]
[null,null,null,null,"Custodial",null,null,{"$f":"'Tax Rates'!K50","v":0}]
[]
[null,null,null,null,"State"]
[null,null,null,null,"Noncustodial",null,null,{"$f":"'Tax Rates'!M57","v":0}]
[null,null,null,null,"Custodial",null,null,{"$f":"'Tax Rates'!M50","v":0}]
[]
[null,null,null,null,"Percent Earnings"]
[null,null,null,null,"Noncustodial",null,null,{"$f":"IF(Worksheet!F45=\"Mother\",Worksheet!J147,Worksheet!H147)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,{"$f":"IF(Worksheet!F45=\"Mother\",1,0)","v":0},null,{"$f":"IF(Worksheet!F33=\"Head of Household\",1,0)","v":0},{"$f":"IF(E51+G51=2,J35,0)","v":0},{"$f":"-H52","v":0},{"$f":"SUM(H51:I51)","v":0}]
[null,null,null,null,{"$f":"IF(Worksheet!F45=\"Father\",1,0)","v":0},null,{"$f":"IF(Worksheet!F33=\"Head of Household\",1,0)","v":0},{"$f":"IF(E52+G52=2,J35,0)","v":0},{"$f":"-H51","v":0},{"$f":"SUM(H52:I52)","v":0}]

{"sheet":"EPT Final","index":5,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,5,1,8]]}
[null,null,null,{"$f":"Worksheet!D162","v":"Case No."},{"$f":"Worksheet!E162","v":0}]
[null,null,null,null,null,"Equal Parenting Time Worksheet"]
[]
[null,null,null,"Step 1",1,"Higher Amount from Line F.3",null,null,null,null,{"$f":"IF(Worksheet!H198>Worksheet!J198,Worksheet!H198,Worksheet!J198)","v":{"$error":"#N/A"}}]
[null,null,null,null,2,"Lower Amount from Line F.3",null,null,null,null,{"$f":"IF(Worksheet!J198<Worksheet!H198,Worksheet!J198,Worksheet!H198)","v":{"$error":"#N/A"}}]
[null,null,null,null,3,"Subtract 2 from 1",null,null,null,null,{"$f":"K4-K5","v":{"$error":"#N/A"}}]
[null,null,null,null,4,"Line 3 x .5",null,null,null,null,{"$f":"K6*0.5","v":{"$error":"#N/A"}}]
[null,null,null,"Step 2",5,"Enter the total Line D.1",null,null,null,null,{"$f":"Worksheet!L141","v":0}]
[null,null,null,null,6,"Enter the total Line D.3",null,null,null,null,{"$f":"Worksheet!L156","v":{"$error":"#N/A"}}]
[null,null,null,null,7,"If written agreement provide clothing (Y or N)",null,null,null,null,{"$f":"Worksheet!F90","v":"N"}]
[null,null,null,null,8,"If no written agreement:"]
[null,null,null,"Step 2a",null,"If the amount on line 5 is:"]
[null,null,null,null,null,"a.  Equal to or less than $4690, enter 13%",null,null,null,null,{"$f":"IF(K8<=F13,0.13,0)","v":0.13}]
[null,null,null,null,null,"b.  Greater than $4690 but less than $8125, enter 15%",null,null,null,null,{"$f":"IF(K8>F13,K8<F14,)*0.15","v":0}]
[null,null,null,null,null,"c.  Equal to or greater than $8126, enter 18%",null,null,null,null,{"$f":"IF(K8>=F15,0.18,0)","v":0}]
[null,null,null,null,9,"Sum Unwritten",null,null,null,null,{"$f":"SUM(K13:K15)","v":0.13}]
[null,null,null,null,10,"Percentage to apply, if no written agreement",null,null,null,null,{"$f":"IF(K10=\"N\",K16,0)","v":0.13}]
[null,null,null,"Step 2b",11,"If written agreement"]
[null,null,null,null,null,"a.  Equal to or less than $4690, enter 11%",null,null,null,null,{"$f":"IF(K8<=F13,0.11,0)","v":0.11}]
[null,null,null,null,null,"b.  Greater than $4690 but less than $8125, enter 13%",null,null,null,null,{"$f":"IF(K8>F13,K8<F14,)*0.13","v":0}]
[null,null,null,null,null,"c.  Equal to or greater than $8126, enter 16%",null,null,null,null,{"$f":"IF(K8>=F15,0.16,0)","v":0}]
[null,null,null,null,12,"Sum Written",null,null,null,null,{"$f":"SUM(K19:K21)","v":0.11}]
[null,null,null,null,12,"Percentage to apply, if written agreement",null,null,null,null,{"$f":"IF(K10=\"Y\",K22,0)","v":0}]
[null,null,null,null,14,"Sum unwritten and written",null,null,null,null,{"$f":"K17+K23","v":0.13}]
[null,null,null,null,13,"Multiply Line 6 by the percentage",null,null,null,null,{"$f":"K24*K9","v":{"$error":"#N/A"}}]
[null,null,null,"Step 3",14,"If parent designated to pay all of the direct"]
[null,null,null,null,null,"expenses is:"]
[null,null,null,null,null,"a.  the parent with the lower adjusted total go to line 15"]
[null,null,null,null,null,"b.  The parent with the higher income go to line 16"]
[null,null,null,null,null,"Mother",null,"Father"]
[null,null,null,null,null,{"$f":"Worksheet!H198","v":{"$error":"#N/A"}},null,{"$f":"Worksheet!J198","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Designated to Pay (M or F)",null,null,null,null,{"$f":"Worksheet!F92","v":"M"}]
[null,null,null,null,15,"Add Line 4 and 10",null,null,null,null,{"$f":"N33","v":{"$error":"#N/A"}},null,null,{"$f":"'EPT Draft'!R24","v":{"$error":"#N/A"}}]
[null,null,null,null,16,"Subtract Line 10 and 4",null,null,null,null,{"$f":"N34","v":{"$error":"#N/A"}},null,null,{"$f":"'EPT Draft'!R25","v":{"$error":"#N/A"}}]

{"sheet":"Schedules","index":6,"n_rows":177,"n_cols":40,"rows_kept":177,"cut":false,"hidden":true,"merged":[]}
[null,null,"One",null,null,"Two",null,null,"Three",null,null,"Four",null,null,"Five",null,null,"Six"]
["Income","0-5","6-11","12-19","0-5","6-11","12-19","0-5","6-11","12-19","0-5","6-11","12-19","0-5","6-11","12-19","0-5","6-11","12-19",null,null,"Income","0-5","6-11","12-18","Income","0-5","6-11","12-18"]
[50,8,10,11,6,7,8,5,6,7,4,5,6,4,4,5,3,4,4,null,null," 1650  "," 275  "," 317  "," 344  "," 4500  "," 628  "," 723  "," 786  "]
[100,17,19,21,12,14,16,11,12,13,9,10,11,8,9,10,7,8,9,null,null," 1700  "," 282  "," 324  "," 353  "," 4600  "," 640  "," 736  "," 800  ",null,null,{"$f":"IF(Worksheet!L141<2000,ROUND(Worksheet!L141/50,0)*50,ROUND(Worksheet!L141/100,0)*100)","v":0},"Rounded Income"]
[150,25,29,32,19,21,23,16,19,20,13,15,17,12,13,15,10,12,13,null,null," 1750  "," 289  "," 332  "," 361  "," 4700  "," 651  "," 749  "," 814  ",null,{"$f":"Worksheet!L141","v":0}]
[200,34,39,42,25,29,31,22,25,27,18,20,22,16,18,20,14,16,17,null,null," 1800  "," 296  "," 340  "," 370  "," 4800  "," 663  "," 762  "," 828  ",null,{"$f":"IF(AF4<=15500,AF4,100)","v":0},"Income"]
[250,42,49,53,31,36,39,27,31,34,22,26,28,20,22,24,17,20,22,null,null," 1850  "," 302  "," 348  "," 378  "," 4900  "," 674  "," 775  "," 843  "]
[300,51,58,63,37,43,47,32,37,40,27,31,33,23,27,29,21,24,26,null,null," 1900  "," 309  "," 356  "," 386  "," 5000  "," 685  "," 788  "," 857  ",null,"Amt:",null,"Age:","Group",{"$f":"Worksheet!I84","v":0},"Number of Children if Multi Family"]
[350,59,68,74,43,50,54,38,43,47,31,36,39,27,31,34,24,28,30,null,null," 1950  "," 316  "," 363  "," 395  "," 5100  "," 697  "," 801  "," 871  ",{"$f":"IF(ISBLANK(AG9),\"\",VLOOKUP(AE$6,A$3:S$177,ROUNDUP(AG9/5,0)+1+(AG$15-1)*3))","v":{"$error":"#N/A"}},{"$f":"AD9","v":{"$error":"#N/A"}},"Child 1",{"$f":"'Age of Children'!C6","v":113.77534246575343},{"$f":"IF(AND(AG9>=18,Worksheet!I48=\"Y\"),99,IF(AG9>=11.5,3,IF(AG9>=5.5,2,IF(AG9>0,1,99))))","v":3},{"$f":"IF(AG9>1,1)","v":1}]
[400,67,78,84,50,57,62,43,50,54,36,41,44,31,36,39,28,32,35,null,null," 2000  "," 322  "," 371  "," 403  "," 5200  "," 708  "," 814  "," 885  ",{"$f":"IF(ISBLANK(AG10),\"\",VLOOKUP(AE$6,A$3:S$177,ROUNDUP(AG10/5,0)+1+(AG$15-1)*3))","v":{"$error":"#N/A"}},{"$error":"#N/A"},"Child 2",{"$f":"'Age of Children'!C11","v":0},{"$f":"IF(AND(AG10>=18,Worksheet!I52=\"Y\"),99,IF(AG10>=11.5,3,IF(AG10>=5.5,2,IF(AG10>0,1,99))))","v":99},false]
[450,76,87,95,56,64,70,48,56,61,40,46,50,35,40,44,31,36,39,null,null," 2100  "," 336  "," 386  "," 420  "," 5300  "," 719  "," 827  "," 899  ",{"$f":"IF(ISBLANK(AG11),\"\",VLOOKUP(AE$6,A$3:S$177,ROUNDUP(AG11/5,0)+1+(AG$15-1)*3))","v":{"$error":"#N/A"}},{"$error":"#N/A"},"Child 3",{"$f":"'Age of Children'!C16","v":0},{"$f":"IF(AND(AG11>=18,Worksheet!I56=\"Y\"),99,IF(AG11>=11.5,3,IF(AG11>=5.5,2,IF(AG11>0,1,99))))","v":99},false]
[500,84,97,105,62,71,78,54,62,67,44,51,56,39,45,49,35,40,43,null,null," 2200  "," 349  "," 401  "," 436  "," 5400  "," 730  "," 840  "," 913  ",{"$f":"IF(ISBLANK(AG12),\"\",VLOOKUP(AE$6,A$3:S$177,ROUNDUP(AG12/5,0)+1+(AG$15-1)*3))","v":{"$error":"#N/A"}},{"$error":"#N/A"},"Child 4",{"$f":"'Age of Children'!C21","v":0},{"$f":"IF(AND(AG12>=18,Worksheet!I60=\"Y\"),99,IF(AG12>=11.5,3,IF(AG12>=5.5,2,IF(AG12>0,1,99))))","v":99},false]
[550,93,107,116,68,79,85,59,68,74,49,56,61,43,49,54,38,44,47,null,null," 2300  "," 362  "," 416  "," 452  "," 5500  "," 741  "," 852  "," 927  ",{"$f":"IF(ISBLANK(AG13),\"\",VLOOKUP(AE$6,A$3:S$177,ROUNDUP(AG13/5,0)+1+(AG$15-1)*3))","v":{"$error":"#N/A"}},{"$error":"#N/A"},"Child 5",{"$f":"'Age of Children'!C26","v":0},{"$f":"IF(AND(AG13>=18,Worksheet!I61=\"Y\"),99,IF(AG13>=11.5,3,IF(AG13>=5.5,2,IF(AG13>0,1,99))))","v":99},false]
[600,101,116,127,75,86,93,65,74,81,53,61,67,47,54,59,41,48,52,null,null," 2400  "," 375  "," 431  "," 468  "," 5600  "," 752  "," 865  "," 940  ",{"$f":"IF(ISBLANK(AG14),\"\",VLOOKUP(AE$6,A$3:S$177,ROUNDUP(AG13/5,0)+1+(AG$15-1)*3))","v":{"$error":"#N/A"}},{"$error":"#N/A"},"Child 6",{"$f":"'Age of Children'!C31","v":0},{"$f":"IF(AND(AG14>=18,Worksheet!I63=\"Y\"),99,IF(AG14>=11.5,3,IF(AG14>=5.5,2,IF(AG14>0,1,99))))","v":99},false]
[650,110,126,137,81,93,101,70,81,88,58,66,72,51,58,63,45,52,56,null,null," 2500  "," 387  "," 446  "," 484  "," 5700  "," 763  "," 878  "," 954  ",null,null,"Total Amount",{"$f":"AI15","v":1},null,{"$f":"SUM(AI8:AI14)","v":1},{"$f":"AI9+AI10+AI11+AI12+AI13+AI14","v":1}]
[700,118,136,148,87,100,109,75,87,94,62,72,78,55,63,68,48,56,60,null,null," 2600  "," 400  "," 460  "," 500  "," 5800  "," 774  "," 890  "," 968  ",null,null,null,null,null,null,1,2,3]
[750,127,146,158,93,107,116,81,93,101,67,77,83,59,67,73,52,60,65,null,null," 2700  "," 413  "," 475  "," 516  "," 5900  "," 785  "," 903  "," 982  ","0-6.4","6.5-11.4","11.5-18",null,"Age of Children",null,"0-5","6-11","12-18","Total"]
[800,135,155,169,99,114,124,86,99,108,71,82,89,62,72,78,55,63,69,null,null," 2800  "," 425  "," 489  "," 532  "," 6000  "," 796  "," 916  "," 995  ",{"$f":"IF(AG9<5.5,AE9,0)","v":0},{"$f":"AND(AG9>=5.5,AG9<11.5,AE9)*AE9","v":{"$error":"#N/A"}},{"$f":"AND(AG9>=11.5,AE9)*AE9","v":{"$error":"#N/A"}},null,"Number Per Age Category",null,{"$f":"COUNTIF(AH9:AH14,1)","v":0},{"$f":"COUNTIF(AH9:AH14,2)","v":0},{"$f":"COUNTIF(AH9:AH14,3)","v":1},{"$f":"AL18+AK18+AJ18+AI8","v":1}]
[850,143,165,179,106,121,132,92,105,114,76,87,94,66,76,83,59,67,73,null,null," 2900  "," 438  "," 503  "," 547  "," 6100  "," 807  "," 928  "," 1009  ",{"$f":"AND(AG10>0,AG10<5.5)*AE10","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,"Amount Per Child",null,{"$f":"IF(AJ18=0,0,AJ23)","v":0},{"$f":"IF(AK18=0,0,AK23)","v":0},{"$f":"IF(AL18=0,0,AL23)","v":{"$error":"#N/A"}}]
[900,152,175,190,112,129,140,97,111,121,80,92,100,70,81,88,62,71,78,null,null," 3000  "," 450  "," 518  "," 563  "," 6200  "," 818  "," 941  "," 1023  ",{"$f":"AND(AG11>0,AG11<5.5)*AE11","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
[950,160,184,200,118,136,147,102,118,128,84,97,106,74,85,93,66,75,82,null,null," 3100  "," 462  "," 532  "," 578  "," 6300  "," 829  "," 953  "," 1036  ",{"$f":"AND(AG12>0,AG12<5.5)*AE12","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$f":"Extended!I25","v":0},{"$f":"Extended!I26","v":0},{"$f":"Extended!I27","v":0}]
[1000,169,194,211,124,143,155,108,124,135,89,102,111,78,90,98,69,79,86,null,null," 3200  "," 475  "," 546  "," 593  "," 6400  "," 840  "," 966  "," 1050  ",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$f":"VLOOKUP($AE$6,$A$3:$S$177,1+1+($AM$18-1)*3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AE$6,$A$3:$S$177,1+2+($AM$18-1)*3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AE$6,$A$3:$S$177,1+3+($AM$18-1)*3)","v":{"$error":"#N/A"}}]
[1050,177,204,221,130,150,163,113,130,141,93,107,117,82,94,102,72,83,91,null,null," 3300  "," 487  "," 560  "," 609  "," 6500  "," 850  "," 978  "," 1063  ",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$f":"IF(AJ22>25,AJ22,AJ21)","v":{"$error":"#N/A"}},{"$f":"IF(AK22>25,AK22,AK21)","v":{"$error":"#N/A"}},{"$f":"IF(AL22>25,AL22,AL21)","v":{"$error":"#N/A"}},null,{"$f":"IF(AK18=0,0,AK22)","v":0}]
[1100,186,213,232,137,157,171,119,136,148,98,112,122,86,99,107,76,87,95,null,null," 3400  "," 499  "," 574  "," 624  "," 6600  "," 861  "," 990  "," 1076  ",{"$f":"SUM(AD18:AD22)","v":{"$error":"#N/A"}},{"$f":"SUM(AE18:AE22)","v":{"$error":"#N/A"}},{"$f":"SUM(AF18:AF22)","v":{"$error":"#N/A"}}]
[1150,194,223,243,143,164,179,124,142,155,102,118,128,90,103,112,79,91,99,null,null," 3500  "," 511  "," 588  "," 639  "," 6700  "," 872  "," 1003  "," 1090  ",{"$f":"Worksheet!G151","v":0},{"$f":"Worksheet!H151","v":0},{"$f":"Worksheet!I151","v":1}]
[1200,202,233,253,149,171,186,129,149,162,107,123,133,94,108,117,83,95,104,null,null," 3600  "," 523  "," 601  "," 654  "," 6800  "," 883  "," 1015  "," 1103  ",{"$f":"AD24/AD25","v":{"$error":"#N/A"}},{"$f":"AE24/AE25","v":{"$error":"#N/A"}},{"$f":"AF24/AF25","v":{"$error":"#N/A"}}]
[1250,211,243,264,155,179,194,135,155,168,111,128,139,98,112,122,86,99,108,null,null," 3700  "," 535  "," 615  "," 669  "," 6900  "," 893  "," 1027  "," 1117  ",{"$f":"IF(AD24>0,AD24/AD25,0)","v":{"$error":"#N/A"}},{"$f":"IF(AE24>0,AE24/AE25,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[1300,219,252,274,161,186,202,140,161,175,116,133,144,101,117,127,90,103,112,null,null," 3800  "," 547  "," 629  "," 684  "," 7000  "," 904  "," 1039  "," 1130  "]
[1350,228,262,285,168,193,210,145,167,182,120,138,150,105,121,132,93,107,116,null,null," 3900  "," 559  "," 642  "," 698  "," 7100  "," 915  "," 1052  "," 1143  "]
[1400,236,272,295,174,200,217,151,173,189,124,143,156,109,126,137,97,111,121,null,null," 4000  "," 570  "," 656  "," 713  "," 7200  "," 925  "," 1064  "," 1156  "]
[1450,245,281,306,180,207,225,156,180,195,129,148,161,113,130,141,100,115,125,null,null," 4100  "," 582  "," 669  "," 728  "," 7300  "," 936  "," 1076  "," 1170  "]
[1500,253,291,316,186,214,233,162,186,202,133,153,167,117,135,146,104,119,129,null,null," 4200  "," 594  "," 683  "," 742  "," 7400  "," 946  "," 1088  "," 1183  "]
[1550,261,301,327,193,221,241,167,192,209,138,159,172,121,139,151,107,123,134,null,null," 4300  "," 605  "," 696  "," 757  "," 7500  "," 957  "," 1100  "," 1196  "]
[1600,268,309,336,199,229,248,172,198,215,142,164,178,125,144,156,110,127,138,null,null," 4400  "," 617  "," 709  "," 771  "," 7600  "," 967  "," 1112  "," 1209  "]
[1650,275,317,344,205,236,256,178,204,222,147,169,183,129,148,161,114,131,142]
[1700,282,324,353,211,243,264,183,211,229,151,174,189,133,153,166,117,135,147]
[1750,289,332,361,217,250,272,189,217,236,156,179,195,137,157,171,121,139,151]
[1800,296,340,370,224,257,279,194,223,242,160,184,200,140,162,176,124,143,155]
[1850,302,348,378,230,264,287,199,229,249,165,189,206,144,166,180,128,147,160]
[1900,309,356,386,235,270,293,205,235,256,169,194,211,148,170,185,131,151,164]
[1950,316,363,395,240,276,300,210,242,263,173,199,217,152,175,190,135,155,168]
[2000,322,371,403,245,281,306,215,248,269,178,205,222,156,179,195,138,159,173]
[2100,336,386,420,254,293,318,226,260,283,187,215,233,164,188,205,145,167,181]
[2200,349,401,436,264,304,330,236,271,295,196,225,245,172,197,215,152,175,190]
[2300,362,416,452,274,315,342,245,281,306,205,235,256,179,206,224,159,183,198]
[2400,375,431,468,283,326,354,253,291,316,213,245,267,187,215,234,166,190,207]
[2500,387,446,484,293,337,366,261,301,327,222,256,278,195,224,244,173,198,216]
[2600,400,460,500,302,348,378,270,310,337,231,266,289,203,233,254,179,206,224]
[2700,413,475,516,312,358,390,278,320,348,238,274,298,211,242,263,186,214,233]
[2800,425,489,532,321,369,401,286,329,358,245,282,307,218,251,273,193,222,242]
[2900,438,503,547,330,380,413,295,339,368,252,290,316,225,259,281,200,230,250]
[3000,450,518,563,339,390,424,303,348,378,259,298,324,231,266,289,207,238,259]
[3100,462,532,578,348,401,435,311,357,389,266,306,333,237,273,297,214,246,267]
[3200,475,546,593,357,411,447,319,367,399,273,314,342,243,280,304,221,255,277]
[3300,487,560,609,366,421,458,327,376,409,280,322,350,250,287,312,227,261,284]
[3400,499,574,624,375,432,469,335,385,419,287,330,359,256,294,319,233,267,291]
[3500,511,588,639,384,442,480,343,394,428,294,338,367,262,301,327,238,274,297]
[3600,523,601,654,393,452,491,351,403,438,300,345,375,268,308,334,243,280,304]
[3700,535,615,669,402,462,502,358,412,448,307,353,384,274,315,342,249,286,311]
[3800,547,629,684,410,472,513,366,421,458,314,361,392,279,321,349,254,292,318]
[3900,559,642,698,419,482,524,374,430,467,320,368,400,285,328,357,260,299,325]
[4000,570,656,713,428,492,535,382,439,477,327,376,409,291,335,364,265,305,331,null,null," 10400  "," 1252  "," 1440  "," 1565  "," 13100  "," 1514  "," 1741  "," 1892  "]
[4100,582,669,728,436,502,545,389,448,486,333,384,417,297,342,371,270,311,338,null,null," 10500  "," 1262  "," 1451  "," 1577  "," 13200  "," 1523  "," 1752  "," 1904  "]
[4200,594,683,742,445,512,556,397,456,496,340,391,425,303,348,379,276,317,344,null,null," 10600  "," 1272  "," 1462  "," 1590  "," 13300  "," 1533  "," 1763  "," 1916  "]
[4300,605,696,757,453,521,567,404,465,505,347,398,433,309,355,386,281,323,351,null,null," 10700  "," 1282  "," 1474  "," 1602  "," 13400  "," 1542  "," 1774  "," 1928  "]
[4400,617,709,771,462,531,577,412,474,515,353,406,441,314,362,393,286,329,358,null,null," 10800  "," 1291  "," 1485  "," 1614  "," 13500  "," 1552  "," 1784  "," 1940  "]
[4500,628,723,786,470,541,588,419,482,524,359,413,449,320,368,400,291,335,364]
[4600,640,736,800,479,551,599,427,491,534,366,421,457,326,375,407,296,341,371]
[4700,651,749,814,487,560,609,434,500,543,372,428,465,332,381,414,302,347,377]
[4800,663,762,828,496,570,619,442,508,552,379,435,473,337,388,422,307,353,383]
[4900,674,775,843,504,579,630,449,517,561,385,443,481,343,394,429,312,359,390]
[5000,685,788,857,512,589,640,457,525,571,391,450,489,348,401,436,317,365,396]
[5100,697,801,871,520,598,650,464,533,580,397,457,497,354,407,443,322,370,403]
[5200,708,814,885,529,608,661,471,542,589,404,464,505,360,414,450,327,376,409]
[5300,719,827,899,537,617,671,478,550,598,410,471,512,365,420,456,332,382,415]
[5400,730,840,913,545,627,681,486,558,607,416,479,520,371,426,463,337,388,422]
[5500,741,852,927,553,636,691,493,567,616,422,486,528,376,433,470,342,394,428]
[5600,752,865,940,561,645,701,500,575,625,428,493,536,382,439,477,347,399,434]
[5700,763,878,954,569,655,711,507,583,634,435,500,543,387,445,484,352,405,440]
[5800,774,890,968,577,664,721,514,592,643,441,507,551,393,452,491,357,411,446]
[5900,785,903,982,585,673,731,521,600,652,447,514,559,398,458,498,362,416,453]
[6000,796,916,995,593,682,741,529,608,661,453,521,566,403,464,504,367,422,459]
[6100,807,928,1009,601,691,751,536,616,670,459,528,574,409,470,511,372,428,465]
[6200,818,941,1023,609,700,761,543,624,678,465,535,581,414,476,518,377,433,471]
[6300,829,953,1036,617,710,771,550,632,687,471,542,589,420,483,525,382,439,477]
[6400,840,966,1050,625,719,781,557,640,696,477,549,596,425,489,531,387,445,483]
[6500,850,978,1063,633,728,791,564,648,705,483,555,604,430,495,538,391,450,489]
[6600,861,990,1076,641,737,801,571,656,713,489,562,611,436,501,545,396,456,495]
[6700,872,1003,1090,648,746,810,578,664,722,495,569,619,441,507,551,401,461,501,null,null," 10900  "," 1301  "," 1496  "," 1627  "," 13600  "," 1561  "," 1795  "," 1951  "]
[6800,883,1015,1103,656,755,820,585,672,731,501,576,626,446,513,558,406,467,507,null,null," 11000  "," 1311  "," 1508  "," 1639  "," 13700  "," 1571  "," 1806  "," 1963  "]
[6900,893,1027,1117,664,763,830,591,680,739,507,583,633,451,519,564,411,472,513,null,null," 11100  "," 1321  "," 1519  "," 1651  "," 13800  "," 1580  "," 1817  "," 1975  "]
[7000,904,1039,1130,672,772,840,598,688,748,513,590,641,457,525,571,415,478,519,null,null," 11200  "," 1331  "," 1530  "," 1663  "," 13900  "," 1589  "," 1828  "," 1987  "]
[7100,915,1052,1143,679,781,849,605,696,756,519,596,648,462,531,577,420,483,525,null,null," 11300  "," 1340  "," 1541  "," 1675  "," 14000  "," 1599  "," 1839  "," 1998  "]
[7200,925,1064,1156,687,790,859,612,704,765,524,603,656,467,537,584,425,489,531,null,null," 11400  "," 1350  "," 1553  "," 1688  "," 14100  "," 1608  "," 1849  "," 2010  "]
[7300,936,1076,1170,695,799,868,619,712,774,530,610,663,472,543,591,430,494,537,null,null," 11500  "," 1360  "," 1564  "," 1700  "," 14200  "," 1618  "," 1860  "," 2022  "]
[7400,946,1088,1183,702,808,878,626,719,782,536,617,670,478,549,597,434,500,543,null,null," 11600  "," 1370  "," 1575  "," 1712  "," 14300  "," 1627  "," 1871  "," 2034  "]
[7500,957,1100,1196,710,817,888,632,727,791,542,623,677,483,555,603,439,505,549,null,null," 11700  "," 1379  "," 1586  "," 1724  "," 14400  "," 1636  "," 1882  "," 2045  "]
[7600,967,1112,1209,718,825,897,639,735,799,548,630,685,488,561,610,444,510,555,null,null," 11800  "," 1389  "," 1597  "," 1736  "," 14500  "," 1646  "," 1892  "," 2057  "]
[7700,978,1124,1222,725,834,907,646,743,807,554,637,692,493,567,616,449,516,561]
[7800,988,1136,1235,733,843,916,653,751,816,559,643,699,498,573,623,453,521,567]
[7900,998,1148,1248,740,852,926,659,758,824,565,650,706,503,579,629,458,527,572]
[8000,1009,1160,1261,748,860,935,666,766,833,571,656,713,508,585,636,463,532,578]
[8100,1019,1172,1274,756,869,944,673,774,841,577,663,721,514,591,642,467,537,584]
[8200,1030,1184,1287,763,877,954,679,781,849,582,670,728,519,596,648,472,543,590]
[8300,1040,1196,1300,771,886,963,686,789,858,588,676,735,524,602,655,476,548,596]
[8400,1050,1208,1313,778,895,972,693,797,866,594,683,742,529,608,661,481,553,601]
[8500,1060,1220,1326,785,903,982,699,804,874,599,689,749,534,614,667,486,559,607]
[8600,1071,1231,1338,793,912,991,706,812,882,605,696,756,539,620,674,490,564,613]
[8700,1081,1243,1351,800,920,1000,713,819,891,611,702,763,544,626,680,495,569,619]
[8800,1091,1255,1364,808,929,1010,719,827,899,616,709,770,549,631,686,499,574,624]
[8900,1101,1267,1377,815,937,1019,726,835,907,622,715,777,554,637,692,504,580,630]
[9000,1112,1278,1389,822,946,1028,732,842,915,627,722,784,559,643,699,509,585,636]
[9100,1122,1290,1402,830,954,1037,739,850,924,633,728,791,564,649,705,513,590,641]
[9200,1132,1302,1415,837,963,1046,745,857,932,639,734,798,569,654,711,518,595,647]
[9300,1142,1313,1427,845,971,1056,752,865,940,644,741,805,574,660,717,522,600,653]
[9400,1152,1325,1440,852,980,1065,758,872,948,650,747,812,579,666,724,527,606,658]
[9500,1162,1336,1453,859,988,1074,765,880,956,655,754,819,584,671,730,531,611,664]
[9600,1172,1348,1465,866,996,1083,771,887,964,661,760,826,589,677,736,536,616,670]
[9700,1182,1360,1478,874,1005,1092,778,894,972,666,766,833,594,683,742,540,621,675]
[9800,1192,1371,1490,881,1013,1101,784,902,980,672,773,840,599,688,748,545,626,681]
[9900,1202,1383,1503,888,1021,1110,791,909,988,677,779,847,604,694,754,549,631,686]
[10000,1212,1394,1515,895,1030,1119,797,917,996,683,785,854,608,700,761,553,637,692]
[10100,1222,1405,1528,903,1038,1128,803,924,1004,688,792,861,613,705,767,558,642,697]
[10200,1232,1417,1540,910,1046,1137,810,931,1012,694,798,867,618,711,773,562,647,703]
[10300,1242,1428,1553,917,1055,1146,816,939,1020,699,804,874,623,716,779,567,652,708]
[10400,1252,1440,1565,924,1063,1155,823,946,1028,705,811,881,628,722,785,571,657,714]
[10500,1262,1451,1577,931,1071,1164,829,953,1036,710,817,888,633,728,791,576,662,720]
[10600,1272,1462,1590,938,1079,1173,835,961,1044,716,823,895,638,733,797,580,667,725]
[10700,1282,1474,1602,946,1087,1182,842,968,1052,721,829,901,642,739,803,584,672,731]
[10800,1291,1485,1614,953,1096,1191,848,975,1060,727,836,908,647,744,809,589,677,736]
[10900,1301,1496,1627,960,1104,1200,854,982,1068,732,842,915,652,750,815,593,682,741]
[11000,1311,1508,1639,967,1112,1209,860,990,1076,737,848,922,657,755,821,598,687,747]
[11100,1321,1519,1651,974,1120,1217,867,997,1083,743,854,928,662,761,827,602,692,752]
[11200,1331,1530,1663,981,1128,1226,873,1004,1091,748,860,935,666,766,833,606,697,758]
[11300,1340,1541,1675,988,1136,1235,879,1011,1099,753,866,942,671,772,839,611,702,763]
[11400,1350,1553,1688,995,1144,1244,886,1018,1107,759,873,949,676,777,845,615,707,769]
[11500,1360,1564,1700,1002,1152,1253,892,1026,1115,764,879,955,681,783,851,619,712,774]
[11600,1370,1575,1712,1009,1161,1261,898,1033,1123,770,885,962,686,788,857,624,717,780]
[11700,1379,1586,1724,1016,1169,1270,904,1040,1130,775,891,969,690,794,863,628,722,785]
[11800,1389,1597,1736,1023,1177,1279,910,1047,1138,780,897,975,695,799,869,632,727,790]
[11900,1399,1608,1748,1030,1185,1288,917,1054,1146,785,903,982,700,805,875,637,732,796]
[12000,1408,1620,1760,1037,1193,1296,923,1061,1154,791,909,988,704,810,881,641,737,801]
[12100,1418,1631,1772,1044,1201,1305,929,1068,1161,796,915,995,709,816,886,645,742,806]
[12200,1428,1642,1785,1051,1209,1314,935,1075,1169,801,922,1002,714,821,892,649,747,812]
[12300,1437,1653,1797,1058,1217,1323,941,1083,1177,807,928,1008,719,826,898,654,752,817]
[12400,1447,1664,1809,1065,1225,1331,947,1090,1184,812,934,1015,723,832,904,658,757,822]
[12500,1456,1675,1821,1072,1233,1340,954,1097,1192,817,940,1021,728,837,910,662,762,828]
[12600,1466,1686,1833,1079,1241,1348,960,1104,1200,822,946,1028,733,843,916,666,766,833]
[12700,1476,1697,1844,1086,1248,1357,966,1111,1207,828,952,1035,737,848,922,671,771,838]
[12800,1485,1708,1856,1093,1256,1366,972,1118,1215,833,958,1041,742,853,927,675,776,844]
[12900,1495,1719,1868,1099,1264,1374,978,1125,1223,838,964,1048,747,859,933,679,781,849]
[13000,1504,1730,1880,1106,1272,1383,984,1132,1230,843,970,1054,751,864,939,683,786,854]
[13100,1514,1741,1892,1113,1280,1391,990,1139,1238,849,976,1061,756,869,945,688,791,860]
[13200,1523,1752,1904,1120,1288,1400,996,1146,1245,854,982,1067,761,875,951,692,796,865]
[13300,1533,1763,1916,1127,1296,1409,1002,1153,1253,859,988,1074,765,880,956,696,801,870]
[13400,1542,1774,1928,1134,1304,1417,1008,1160,1261,864,994,1080,770,885,962,700,805,875]
[13500,1552,1784,1940,1140,1312,1426,1014,1167,1268,869,1000,1087,774,891,968,705,810,881]
[13600,1561,1795,1951,1147,1319,1434,1021,1174,1276,874,1006,1093,779,896,974,709,815,886]
[13700,1571,1806,1963,1154,1327,1443,1027,1181,1283,880,1012,1100,784,901,980,713,820,891]
[13800,1580,1817,1975,1161,1335,1451,1033,1187,1291,885,1018,1106,788,906,985,717,825,896]
[13900,1589,1828,1987,1168,1343,1460,1039,1194,1298,890,1023,1112,793,912,991,721,829,902]
[14000,1599,1839,1998,1174,1351,1468,1045,1201,1306,895,1029,1119,797,917,997,725,834,907]
[14100,1608,1849,2010,1181,1358,1476,1051,1208,1313,900,1035,1125,802,922,1002,730,839,912]
[14200,1618,1860,2022,1188,1366,1485,1057,1215,1321,905,1041,1132,807,928,1008,734,844,917]
[14300,1627,1871,2034,1195,1374,1493,1063,1222,1328,910,1047,1138,811,933,1014,738,849,922]
[14400,1636,1882,2045,1201,1382,1502,1069,1229,1336,916,1053,1145,816,938,1020,742,853,928]
[14500,1646,1892,2057,1208,1389,1510,1074,1236,1343,921,1059,1151,820,943,1025,746,858,933]
[14600,1655,1903,2069,1215,1397,1518,1080,1242,1351,926,1065,1157,825,948,1031,750,863,938]
[14700,1664,1914,2080,1221,1405,1527,1086,1249,1358,931,1071,1164,829,954,1037,754,868,943]
[14800,1674,1925,2092,1228,1412,1535,1092,1256,1365,936,1076,1170,834,959,1042,759,872,948]
[14900,1683,1935,2104,1235,1420,1544,1098,1263,1373,941,1082,1176,838,964,1048,763,877,953]
[15000,1692,1946,2115,1242,1428,1552,1104,1270,1380,946,1088,1183,843,969,1054,767,882,958]
[15100,1701,1957,2127,1248,1435,1560,1110,1277,1388,951,1094,1189,847,974,1059,771,887,964]
[15200,1711,1967,2138,1255,1443,1569,1116,1283,1395,956,1100,1195,852,980,1065,775,891,969]
[15300,1720,1978,2150,1262,1451,1577,1122,1290,1402,961,1106,1202,856,985,1071,779,896,974]
[15400,1729,1989,2161,1268,1458,1585,1128,1297,1410,966,1111,1208,861,990,1076,783,901,979]
[15500,1738,1999,2173,1275,1466,1593,1134,1304,1417,971,1117,1214,865,995,1082,787,905,984]

{"sheet":"Interstate Pay","index":7,"n_rows":56,"n_cols":14,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,"State","Weekly Wage ","Kansas Weekly Wage","h/g","agi","State","Adjusted AGI"]
[]
[null,null,null,null,null,"Alaska",null,null,{"$f":"H4/G4","v":{"$error":"#DIV/0!"}},{"$f":"IF(Worksheet!F45=\"m\",Worksheet!J124,Worksheet!H124)","v":0},null,0,{"$f":"J4-L4","v":0},{"$f":"-M4","v":0}]
[null,null,null,null,null,"Alabama",784,null,{"$f":"G21/G5","v":0.97066326530612246},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F5,L5,0)","v":0},{"$f":"I5*J5","v":0},{"$f":"J5-L5","v":0},{"$f":"-M5","v":0}]
[null,null,null,null,null,"Alaska",961,null,{"$f":"G21/G6","v":0.79188345473465138},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F6,L6,0)","v":0},{"$f":"I6*J7","v":0},{"$f":"J7-L6","v":0},0]
[null,null,null,null,null,"Arizona",846,null,{"$f":"G21/G7","v":0.89952718676122934},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F7,L7,0)","v":0},0,0,0]
[null,null,null,null,null,"Arkansas",708,null,{"$f":"G21/G8","v":1.0748587570621468},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F8,L8,0)","v":0},0,0,0]
[null,null,null,null,null,"California ",1036,null,{"$f":"G21/G9","v":0.73455598455598459},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F9,L9,0)","v":0},0,0,0]
[null,null,null,null,null,"Colorado ",936,null,{"$f":"G21/G10","v":0.81303418803418803},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F10,L10,0)","v":0},0,0,0]
[null,null,null,null,null,"Connecticut ",1087,null,{"$f":"G21/G11","v":0.70009199632014718},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F11,L11,0)","v":0},0,0,0]
[null,null,null,null,null,"Delaware ",925,null,{"$f":"G21/G12","v":0.82270270270270274},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F12,L12,0)","v":0},0,0,0]
[null,null,null,null,null,"District of Columbia ",1514,null,{"$f":"G21/G13","v":0.50264200792602376},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F13,L13,0)","v":0},0,0,0]
[null,null,null,null,null,"Florida ",800,null,{"$f":"G21/G14","v":0.95125000000000004},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F14,L14,0)","v":0},0,0,0]
[null,null,null,null,null,"Georgia ",854,null,{"$f":"G21/G15","v":0.8911007025761124},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F15,L15,0)","v":0},0,0,0]
[null,null,null,null,null,"Hawaii ",827,null,{"$f":"G21/G16","v":0.92019347037484889},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F16,L16,0)","v":0},0,0,0]
[null,null,null,null,null,"Idaho",687,null,{"$f":"G21/G17","v":1.1077147016011646},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F17,L17,0)","v":0},0,0,0]
[null,null,null,null,null,"Illinois",945,null,{"$f":"G21/G18","v":0.80529100529100528},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F18,L18,0)","v":0},0,0,0]
[null,null,null,null,null,"Indiana ",772,null,{"$f":"G21/G19","v":0.98575129533678751},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F19,L19,0)","v":0},0,0,0]
[null,null,null,null,null,"Iowa",756,null,{"$f":"G21/G20","v":1.0066137566137565},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F20,L20,0)","v":0},0,0,0]
[null,null,null,null,null,"Kansas ",761,null,{"$f":"G21/G21","v":1},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F21,L21,0)","v":0},0,0,0]
[null,null,null,null,null,"Kentucky ",751,null,{"$f":"G21/G22","v":1.0133155792276964},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F22,L22,0)","v":0},0,0,0]
[null,null,null,null,null,"Louisiana ",805,null,{"$f":"G21/G23","v":0.94534161490683233},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F23,L23,0)","v":0},0,0,0]
[null,null,null,null,null,"Maine ",722,null,{"$f":"G21/G24","v":1.054016620498615},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F24,L24,0)","v":0},0,0,0]
[null,null,null,null,null,"Maryland ",1007,null,{"$f":"G21/G25","v":0.75571002979145974},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F25,L25,0)","v":0},0,0,0]
[null,null,null,null,null,"Massachusetts ",1102,null,{"$f":"G21/G26","v":0.69056261343012704},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F26,L26,0)","v":0},0,0,0]
[null,null,null,null,null,"Michigan ",862,null,{"$f":"G21/G27","v":0.88283062645011601},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F27,L27,0)","v":0},0,0,0]
[null,null,null,null,null,"Minnesota",915,null,{"$f":"G21/G28","v":0.8316939890710382},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F28,L28,0)","v":0},0,0,0]
[null,null,null,null,null,"Mississippi ",672,null,{"$f":"G21/G29","v":1.1324404761904763},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F29,L29,0)","v":0},0,0,0]
[null,null,null,null,null,"Missouri ",793,null,{"$f":"G21/G30","v":0.95964691046658257},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F30,L30,0)","v":0},0,0,0]
[null,null,null,null,null,"Montana ",689,null,{"$f":"G21/G31","v":1.104499274310595},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F31,L31,0)","v":0},0,0,0]
[null,null,null,null,null,"Nebraska ",742,null,{"$f":"G21/G32","v":1.0256064690026954},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F32,L32,0)","v":0},0,0,0]
[null,null,null,null,null,"Nevada ",820,null,{"$f":"G21/G33","v":0.92804878048780493},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F33,L33,0)","v":0},0,0,0]
[null,null,null,null,null,"New Hampshire",874,null,{"$f":"G21/G34","v":0.87070938215102978},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F34,L34,0)","v":0},0,0,0]
[null,null,null,null,null,"New Jersey",1053,null,{"$f":"G21/G35","v":0.72269705603038936},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F35,L35,0)","v":0},0,0,0]
[null,null,null,null,null,"New Mexico ",761,null,{"$f":"G21/G36","v":1},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F36,L36,0)","v":0},0,0,0]
[null,null,null,null,null,"New York ",1088,null,{"$f":"G21/G37","v":0.69944852941176472},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F37,L37,0)","v":0},0,0,0]
[null,null,null,null,null,"North Carolina ",806,null,{"$f":"G21/G38","v":0.94416873449131511},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F38,L38,0)","v":0},{"$f":"I38*J39","v":0},{"$f":"J39-L38","v":0},0]
[null,null,null,null,null,"North Dakota ",872,null,{"$f":"G21/G39","v":0.87270642201834858},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F39,L39,0)","v":0},0,0,0]
[null,null,null,null,null,"Ohio ",828,null,{"$f":"G21/G40","v":0.91908212560386471},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F40,L40,0)","v":0},0,0,0]
[null,null,null,null,null,"Oklahoma ",779,null,{"$f":"G21/G41","v":0.97689345314505782},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F41,L41,0)","v":0},0,0,0]
[null,null,null,null,null,"Oregon ",834,null,{"$f":"G21/G42","v":0.91247002398081534},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F42,L42,0)","v":0},0,0,0]
[null,null,null,null,null,"Pennsylvania ",899,null,{"$f":"G21/G43","v":0.84649610678531706},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F43,L43,0)","v":0},0,0,0]
[null,null,null,null,null,"Rhode Island ",855,null,{"$f":"G21/G44","v":0.89005847953216377},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F44,L44,0)","v":0},0,0,0]
[null,null,null,null,null,"South Carolina ",738,null,{"$f":"G21/G45","v":1.0311653116531165},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F45,L45,0)","v":0},0,0,0]
[null,null,null,null,null,"South Dakota ",683,null,{"$f":"G21/G46","v":1.1142020497803806},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F46,L46,0)","v":0},0,0,0]
[null,null,null,null,null,"Tennessee ",814,null,{"$f":"G21/G47","v":0.93488943488943488},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F47,L47,0)","v":0},0,0,0]
[null,null,null,null,null,"Texas ",930,null,{"$f":"G21/G48","v":0.81827956989247308},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F48,L48,0)","v":0},0,0,0]
[null,null,null,null,null,"Utah",766,null,{"$f":"G21/G49","v":0.99347258485639689},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F49,L49,0)","v":0},0,0,0]
[null,null,null,null,null,"Vermont ",763,null,{"$f":"G21/G50","v":0.99737876802096981},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F50,L50,0)","v":0},0,0,0]
[null,null,null,null,null,"Virginia ",960,null,{"$f":"G21/G51","v":0.79270833333333335},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F51,L51,0)","v":0},0,0,0]
[null,null,null,null,null,"Washington",1024,null,{"$f":"G21/G52","v":0.7431640625},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F52,L52,0)","v":0},0,0,0]
[null,null,null,null,null,"West Virginia ",724,null,{"$f":"G21/G53","v":1.0511049723756907},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F53,L53,0)","v":0},0,0,0]
[null,null,null,null,null,"Wisconsin ",770,null,{"$f":"G21/G54","v":0.98831168831168836},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F54,L54,0)","v":0},0,0,0]
[null,null,null,null,null,"Wyoming ",828,null,{"$f":"G21/G55","v":0.91908212560386471},{"$f":"IF(Worksheet!I86=\"F\",Worksheet!J124,Worksheet!H124)","v":0},{"$f":"IF(Worksheet!F89='Interstate Pay'!F55,L55,0)","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K5:K55)","v":0},null,null,{"$f":"-J55+K56","v":0}]

{"sheet":"Extended","index":8,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,1,2,3,4,5,6]
[null,"Income",{"$f":"Worksheet!L141","v":0},{"$f":"C3","v":0},{"$f":"C3","v":0},{"$f":"C3","v":0},{"$f":"C3","v":0},{"$f":"C3","v":0}]
[null,"Power",{"$f":"POWER(C3,0.689838232)","v":0},{"$f":"POWER(C3,0.689838232)","v":0},{"$f":"POWER(C3,0.689838232)","v":0},{"$f":"POWER(C3,0.689838232)","v":0},{"$f":"POWER(C3,0.689838232)","v":0},{"$f":"POWER(C3,0.689838232)","v":0}]
[null,"Multiplier",2.7951823930000002,2.0497424120000001,1.822812799,1.5619646949999999,1.3914601520000001,1.265842221]
[null,"Product",{"$f":"C4*C5","v":0},{"$f":"D4*D5","v":0},0,0,0,0]
[null,"12-18",{"$f":"C6","v":0},{"$f":"D6","v":0},0,0,0,0]
[null,null,0.92,0.92,0.92,0.92,0.92,0.92]
[null,"6-11",{"$f":"C7*C8","v":0},{"$f":"D7*D8","v":0},0,0,0,0]
[null,null,0.8,0.8,0.8,0.8,0.8,0.8]
[null,"0-5",{"$f":"C7*C10","v":0},{"$f":"D7*D10","v":0},0,0,0,0]
[]
[]
[]
[null,"Income",{"$f":"IF(Schedules!AE6>15500,Schedules!AE6,0)","v":0},{"$f":"IF(Schedules!AE6>15500,Schedules!AE6,0)","v":0},{"$f":"IF(Schedules!AE6>15500,Schedules!AE6,0)","v":0},{"$f":"IF(Schedules!AE6>15500,Schedules!AE6,0)","v":0},{"$f":"IF(Schedules!AE6>15500,Schedules!AE6,0)","v":0},{"$f":"IF(Schedules!AE6>15500,Schedules!AE6,0)","v":0}]
[null,"# of Children",{"$f":"Schedules!AJ15","v":1}]
[null,"Age of Children"]
[null,"0-5.5",{"$f":"'Age of Children'!G9","v":0},{"$f":"C18","v":0},{"$f":"C18","v":0},{"$f":"C18","v":0},{"$f":"C18","v":0},{"$f":"C18","v":0}]
[null,"5.5-11.5",{"$f":"'Age of Children'!H9","v":0},{"$f":"C19","v":0},{"$f":"C19","v":0},{"$f":"C19","v":0},{"$f":"C19","v":0},{"$f":"C19","v":0}]
[null,"11.5-18",{"$f":"'Age of Children'!I9","v":1},{"$f":"C20","v":1},{"$f":"C20","v":1},{"$f":"C20","v":1},{"$f":"C20","v":1},{"$f":"C20","v":1}]
[]
[]
[]
[]
[null,"0-5",{"$f":"IF(C16=1,C18*C11,0)","v":0},{"$f":"IF(C16=2,D18*D11,0)","v":0},{"$f":"IF(C16=3,E18*E11,0)","v":0},{"$f":"IF(C16=4,F18*F11,0)","v":0},{"$f":"IF(C16=5,G18*G11,0)","v":0},{"$f":"IF(C16=6,H18*H11,0)","v":0},{"$f":"SUM(C25:H25)","v":0}]
[null,"6-11",{"$f":"IF(C16=1,C19*C9,0)","v":0},{"$f":"IF(C16=2,D19*D9,0)","v":0},{"$f":"IF(C16=3,E19*E9,0)","v":0},{"$f":"IF(C16=4,F19*F9,0)","v":0},{"$f":"IF(C16=5,G19*G9,0)","v":0},{"$f":"IF(C16=6,H19*H9,0)","v":0},{"$f":"SUM(C26:H26)","v":0}]
[null,"12-18",{"$f":"IF(C16=1,C20*C7,0)","v":0},{"$f":"IF(C16=2,D20*D7,0)","v":0},{"$f":"IF(C16=3,E20*E7,0)","v":0},{"$f":"IF(C16=4,F20*F7,0)","v":0},{"$f":"IF(C16=5,G20*G7,0)","v":0},{"$f":"IF(C16=6,H20*H7,0)","v":0},{"$f":"SUM(C27:H27)","v":0}]

{"sheet":"EPT Draft","index":9,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":true,"merged":[[1,5,1,8]]}
[]
[null,null,null,null,null,"Equal Parenting Time Worksheet"]
[]
[null,null,null,"Step 1",1,"Higher Amount from Line F.3",null,null,null,null,{"$f":"IF(Worksheet!H198>Worksheet!J198,Worksheet!H198,Worksheet!J198)","v":{"$error":"#N/A"}}]
[null,null,null,null,2,"Lower Amount from Line F.3",null,null,null,null,{"$f":"IF(Worksheet!J198<Worksheet!H198,Worksheet!J198,Worksheet!H198)","v":{"$error":"#N/A"}}]
[null,null,null,null,3,"Subtract 2 from 1",null,null,null,null,{"$f":"K4-K5","v":{"$error":"#N/A"}}]
[null,null,null,null,4,"Line 3 x .5",null,null,null,null,{"$f":"K6*0.5","v":{"$error":"#N/A"}}]
[null,null,null,"Step 2",5,"Enter the total Line D.1",null,null,null,null,{"$f":"Worksheet!L141","v":0},null,null,{"$f":"Worksheet!L141","v":0}]
[null,null,null,null,6,"Enter the total Line D.3",null,null,null,null,{"$f":"Worksheet!L156","v":{"$error":"#N/A"}}]
[null,null,null,null,7,"If written agreement provide clothing (Y or N)",null,null,null,null,{"$f":"Worksheet!I90","v":"Y"}]
[null,null,null,null,8,"If no written agreement:"]
[null,null,null,null,null,4690,null,null,null,null,{"$f":"IF(K8<=F12,0.13,0)","v":0.13},null,null,{"$f":"IF(K8<=F12,0.13,0)","v":0.13}]
[null,null,null,null,null,8125,null,null,null,null,{"$f":"IF(K8>F12,K8<F13,)*0.15","v":0}]
[null,null,null,null,null,8126,null,null,null,null,{"$f":"IF(K8>=F14,0.18,0)","v":0}]
[null,null,null,null,9,"Sum Unwritten",null,null,null,null,{"$f":"SUM(K12:K14)","v":0.13}]
[null,null,null,null,10,"If no written agreement Multiplier",null,null,null,null,{"$f":"IF(K10=\"N\",K15,0)","v":0}]
[null,null,null,null,11,"If written agreement"]
[null,null,null,null,null,4690,null,null,null,null,{"$f":"IF(K8<=F12,0.11,0)","v":0.11}]
[null,null,null,null,null,8125,null,null,null,null,{"$f":"IF(K8>F12,K8<F13,)*0.13","v":0}]
[null,null,null,null,null,8126,null,null,null,null,{"$f":"IF(K8>=F14,0.16,0)","v":0}]
[null,null,null,null,12,"Sum Written",null,null,null,null,{"$f":"SUM(K18:K20)","v":0.11}]
[null,null,null,null,13,"If written agreement",null,null,null,null,{"$f":"IF(K10=\"Y\",K21,0)","v":0.11}]
[null,null,null,null,14,"Sum unwritten and written",null,null,null,null,{"$f":"K16+K22","v":0.11},null,null,null,null,"Father","Mother"]
[null,null,null,null,15,"Multiplier",null,null,null,null,{"$f":"K23*K9","v":{"$error":"#N/A"}},null,{"$f":"K22+K16*K9","v":{"$error":"#N/A"}},null,null,{"$f":"IF(N29=1,K31,0)","v":{"$error":"#N/A"}},{"$f":"IF(N28=1,K31,0)","v":0},{"$f":"SUM(P24:Q24)","v":{"$error":"#N/A"}}]
[null,null,null,"Step 3",16,"If parent designated to pay all of the direct",null,null,null,null,null,null,null,null,null,{"$f":"IF(N30=2,K32,0)","v":0},{"$f":"IF(N31=2,K32,0)","v":{"$error":"#N/A"}},{"$f":"SUM(P25:Q25)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"expenses is:",null,null,null,null,null,null,null,null,null,{"$f":"SUM(P24:P25)","v":{"$error":"#N/A"}},{"$f":"SUM(Q24:Q25)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"the lower adjusted subtotal from Line F.3"]
[null,null,null,null,null,"Mother",null,"Father",null,null,null,null,null,{"$f":"IF(K30=\"F\",F29>=H29)*1","v":0}]
[null,null,null,null,null,{"$f":"Worksheet!H198","v":{"$error":"#N/A"}},null,{"$f":"Worksheet!J198","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(K30=\"M\",F29<=H29)*1","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Designated to Pay (M or F)",null,null,null,null,{"$f":"Worksheet!F92","v":"M"},null,null,{"$f":"IF(K30=\"F\",F29<=H29)*2","v":0}]
[null,null,null,null,17,"Add Line 4 and 10",null,null,null,null,{"$f":"IF(N32>0,N33,0)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(K30=\"M\",F29>=H29)*2","v":{"$error":"#N/A"}},{"$f":"K9+K24","v":{"$error":"#N/A"}}]
[null,null,null,null,18,"Subtract Line 4 and 10",null,null,null,null,{"$f":"IF(N32>0,N34,0)","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(N28:N31)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K24+K7","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K7-K24","v":{"$error":"#N/A"}}]

{"sheet":"Sheet11","index":10,"n_rows":73,"n_cols":9,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,"Custodial Parent",null,null,null,"Noncustodial Parent"]
[null,null,null,null,"Filing Status",null,null,null,"Filing Status"]
[null,null,null,null,"Federal Tax Rate",null,null,null,"Federal Tax Rate"]
[null,null,null,null,"State Tax Rate",null,null,null,"State Tax Rate"]
[null,null,null,null,"% of Income",null,null,null,"% of Income"]
[null,null,null,null,"Adjusted Gross ",null,null,null,"Adjusted Gross"]
[]
[]
[]
[]
[]
[null,null,null,"Head of Household"]
[null,null,null,2013]
[]
[null,null,"Federal",null,null,2013]
[null,null,"Standard Deduction",null,null,8950]
[null,null,"Normal Exemption",null,null,3900]
[null,null,"Available Exemption",null,null,3900]
[null,null,"Parent's Exemption",null,null,1]
[null,null,"Exemption Value",null,null,3900]
[null,null,"Deduction's Total",null,null,{"$f":"F17+F18","v":12850}]
[null,null,"FEDERAL ADJ. GROSS",null,null,{"$f":"H15-F22","v":-12850}]
[]
[null,null,"State"]
[null,null,"Standard Ded.",null,null,9000]
[null,null,"Normal Exemption",null,null,2250]
[null,null,"# of Claims",null,null,2]
[null,null,"(parent plus one)"]
[null,null,"Exemption Value",null,null,{"$f":"F28*F27","v":4500}]
[null,null,"Ded. Total",null,null,{"$f":"F30+F26","v":13500}]
[null,null,"KANSAS ADJUST GROSS",null,null,{"$f":"H15-F31","v":-13500}]
[]
[]
[null,null,null,"Head of Household Exemption"]
[null,null,null,2013]
[null,null,"Federal"]
[null,null,"Single",null,6100]
[null,null,"Head of Household",null,8950]
[null,null,"Benefit",null,{"$f":"E39-E38","v":2850}]
[]
[null,null,"Kansas Increase"]
[null,null,"Single",null,3000]
[null,null,"Head of Household",null,9000]
[null,null,"Benefit",null,{"$f":"E44-E43","v":6000}]
[]
[null,null,"KS Exempt.",null,2250]
[]
[null,null,"Head of Household Benefit"]
[null,null,"Kansas"]
[null,null,"Value of Extra Exemption",null,null,{"$f":"E47","v":2250}]
[null,null,"Cust Parent's Marginal Tax Rate",null,null,{"$f":"I53","v":0}]
[null,null,"Annual Tax Savings",null,null,{"$f":"F51*F52","v":0}]
[null,null,"Monthly Tax Savings",null,null,{"$f":"F53/12","v":0}]
[null,null,"% Income Noncustodial",null,null,{"$f":"Worksheet!H151","v":0}]
[null,null,"Noncustodial's Share",null,null,{"$f":"F55*F54/100","v":0}]
[]
[]
[null,null,"Standard Deduction Benefit"]
[null,null,"Federal",null,null,{"$f":"E40","v":2850}]
[null,null,"Cust Parent's Marginal Tax Rate",null,null,{"$f":"IF(Worksheet!D38=\"Y\",I67,N67)","v":0}]
[null,null,"Value Tax Savings",null,null,{"$f":"F61*F60/100","v":0}]
[]
[null,null,"Kansas",null,null,{"$f":"E45","v":6000}]
[null,null,"Cust Parent's Marginal Tax Rate",null,null,{"$f":"F52","v":0}]
[null,null,"Value of Tax Savings",null,null,{"$f":"F64*F65","v":0}]
[null,null,"Total Tax Savings",null,null,{"$f":"F62+F66","v":0}]
[null,null,"Mother's Monthly Tax Savings",null,null,{"$f":"F67/12","v":0}]
[null,null,"Noncust Parent's % of Income",null,null,{"$f":"F55","v":0}]
[null,null,"Noncust Parent's  Share",null,null,{"$f":"F69*F68/100","v":0}]
[null,null,"Adjustment",null,null,{"$f":"F56+F70","v":0}]
[null,null,"Remove HOH",null,null,null,"Assumes HOH so Subtract if not"]
[null,null,"TOTAL ADJUSTMENT",null,null,{"$f":"F71+F72","v":0}]

{"sheet":"Tax Rates","index":11,"n_rows":72,"n_cols":22,"rows_kept":72,"cut":false,"hidden":true,"merged":[[3,13,3,14]]}
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"M1*12","v":0},{"$f":"IF(Worksheet!F45=\"M\",Worksheet!J141,Worksheet!H141)","v":0},null,null,{"$f":"Q1*12","v":0},{"$f":"IF(Worksheet!F45=\"M\",Worksheet!H141,Worksheet!J141)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(Worksheet!F33=\"Head of Household\",-D38,0)","v":0},{"$f":"IF(Worksheet!F33=\"Single\",-D37,0)","v":0},{"$f":"IF(Worksheet!F33=\"Married-Joint\",-G37,0)","v":0},{"$f":"IF(Worksheet!F33=\"Married-Sep.\",-G37,0)","v":0},null,{"$f":"G2+H2+I2+J2","v":0},null,null,null,{"$f":"T2+S2+R2+Q2","v":0},{"$f":"IF(Worksheet!F40=\"Married-Sep.\",-G37,0)","v":0},{"$f":"IF(Worksheet!F40=\"Married-Joint\",-G37,0)","v":0},{"$f":"IF(Worksheet!F40=\"Single\",-D37,0)","v":0},{"$f":"IF(Worksheet!F40=\"Head of Household\",-D38,0)","v":0}]
[]
[null,"Custodial Parent",null,null,null,"Noncustodial Parent",null,null,null,null,"Custodial",{"$f":"L1+L2","v":0},null,"Noncustodial",null,{"$f":"P1+P2","v":0}]
[null,"Filing Status",null,null,null,"Filing Status",{"$f":"IF(Worksheet!F33=\"Head of Household\",-D43,0)","v":0},{"$f":"IF(Worksheet!F33=\"Single\",-D42,0)","v":0},{"$f":"IF(Worksheet!F33=\"Married-Joint\",-D43,0)","v":0},{"$f":"IF(Worksheet!F33=\"Married-Sep.\",-D43,0)","v":0},null,{"$f":"G5+H5+I5+J5","v":0},null,null,null,{"$f":"T5+S5+R5+Q5","v":0},{"$f":"IF(Worksheet!F40=\"Married-Sep.\",-D43,0)","v":0},{"$f":"IF(Worksheet!F40=\"Married-Joint\",-D43,0)","v":0},{"$f":"IF(Worksheet!F40=\"Single\",-D42,0)","v":0},{"$f":"IF(Worksheet!F40=\"Head of Household\",-D43,0)","v":0}]
[null,"Federal Tax Rate",null,null,null,"Federal Tax Rate",null,null,"Federal Tax Rate",null,null,"Federal Married filing Jointly",null,null,null,"Federal Head of Household",null,null,null,"Federal Married filing Separately"]
[null,"State Tax Rate",null,null,null,"State Tax Rate",null,null,"Single"]
[null,"% of Income",null,null,null,"% of Income",null,null,0,null,null,0,null,null,null,0,null,null,null,0]
[null,"Adjusted Gross ",null,null,null,"Adjusted Gross",null,null,8925,0.1,null,17850,0.1,null,null,12750,0.1,null,null,8925,0.1]
[null,null,null,null,null,null,null,null,36250,15,null,72500,15,1740,null,48600,15,1240,null,36250,15,892.5]
[null,{"$f":"Worksheet!D162","v":"Case No."},{"$f":"Worksheet!E162","v":0},null,null,null,null,null,87850,25,null,146400,25,9735,null,125450,25,68483,null,73200,25,4991.25]
[null,null,"Head of Household",null,null,null,null,null,183250,28,null,223050,28,27735,null,203150,28,25220,null,111525,28,14228.75]
[null,null,2013,null,null,null,null,null,398350,33,null,398350,33,48665,null,398350,33,46430,null,199175,33,24959.25]
[null,null,null,null,null,null,null,null,400000,35,null,450000,35,105062,null,425000,35,109229,null,22500,35,62923]
[null,"Federal",null,null,2013,null,null,null,400001,39.6,null,450001,39.6,null,null,425001,39.6,null,null,225001,39.6]
[null,"Standard Deduction",null,null,8950]
[null,"Normal Exemption",null,null,3900]
[null,"Available Exemption",null,null,3900]
[null,"Parent's Exemption",null,null,1,null,null,null,"Custodial","Noncust",null,"Cust","Noncust",null,null,"Cust","Noncust",null,null,"Cust","Noncust"]
[null,"Exemption Value",null,null,3900,null,null,null,{"$f":"IF(L4<=I9,J9,0)","v":0.1},{"$f":"IF(P4<=I9,J9,0)","v":0.1},null,{"$f":"IF(L4<L9,M9,0)","v":0.1},{"$f":"IF(P4<=L9,M9,0)","v":0.1},null,null,{"$f":"IF(L4<P9,Q10,0)","v":15},{"$f":"IF(T4<=P9,Q9,0)","v":0.1},null,null,{"$f":"IF(L4<T9,U10,0)","v":15},{"$f":"IF(P4<=T9,U9,0)","v":0.1}]
[null,"Deduction's Total",null,null,{"$f":"E16+E17","v":12850},null,null,null,{"$f":"IF(L4>I9,L4<=I10)*0.15","v":0},{"$f":"IF(P4>I9,P4<=I10)*0.15","v":0},null,{"$f":"IF(L4>L9,L4<=L10)*0.15","v":0},{"$f":"IF(P4>L9,P4<=L10)*0.15","v":0},null,null,{"$f":"IF(L4>P9,L4<=P10)*0.15","v":0},{"$f":"IF(P4>P9,P4<=P10)*0.15","v":0},null,null,{"$f":"IF(L4>T9,L4<=T10)*0.15","v":0},{"$f":"IF(P4>T9,P4<=T10)*0.15","v":0}]
[null,"FEDERAL ADJ. GROSS",null,null,{"$f":"G14-E21","v":-12850},null,null,null,{"$f":"IF(L4>I10,L4<=I11)*0.25","v":0},{"$f":"IF(P4>I10,P4<=I11)*0.25","v":0},null,{"$f":"IF(L4>L10,L4<=L11)*0.25","v":0},{"$f":"IF(P4>L10,P4<=L11)*0.25","v":0},null,null,{"$f":"IF(L4>P10,L4<=P11)*0.25","v":0},{"$f":"IF(P4>P10,P4<=P11)*0.25","v":0},null,null,{"$f":"IF(L4>T10,L4<=T11)*0.25","v":0},{"$f":"IF(P4>T10,P4<=T11)*0.25","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(L4>I11,L4<=I12)*0.28","v":0},{"$f":"IF(P4>I11,P4<=I12)*0.28","v":0},null,{"$f":"IF(L4>L11,L4<=L12)*0.28","v":0},{"$f":"IF(P4>L11,P4<=L12)*0.28","v":0},null,null,{"$f":"IF(L4>P11,L4<=P12)*0.28","v":0},{"$f":"IF(P4>P11,P4<=P12)*0.28","v":0},null,null,{"$f":"IF(L4>T11,L4<=T12)*0.28","v":0},{"$f":"IF(P4>T11,P4<=T12)*0.28","v":0}]
[null,"State",null,null,null,null,null,null,{"$f":"IF(L4>I12,L4<=I13)*0.33","v":0},{"$f":"IF(P4>I12,P4<=I13)*0.33","v":0},null,{"$f":"IF(L4>L12,L4<=L13)*0.33","v":0},{"$f":"IF(P4>L12,P4<=L13)*0.33","v":0},null,null,{"$f":"IF(L4>P12,L4<=P13)*0.33","v":0},{"$f":"IF(P4>P12,P4<=P13)*0.33","v":0},null,null,{"$f":"IF(L4>T12,L4<=T13)*0.33","v":0},{"$f":"IF(P4>T12,P4<=T13)*0.33","v":0}]
[null,"Standard Ded.",null,null,9000,null,null,null,{"$f":"IF(L4>I13,L4<=I14)*0.35","v":0},{"$f":"IF(P4>I13,P4<=I14)*0.35","v":0},null,{"$f":"IF(L4>L13,L4<=L14)*0.35","v":0},{"$f":"IF(P4>L13,P4<=L14)*0.35","v":0},null,null,{"$f":"IF(L4>P13,L4<=P14)*0.35","v":0},{"$f":"IF(P4>P13,P4<=P14)*0.35","v":0},null,null,{"$f":"IF(L4>T13,L4<=T14)*0.35","v":0},{"$f":"IF(P4>T13,P4<=T14)*0.35","v":0}]
[null,"Normal Exemption",null,null,2250,null,null,null,{"$f":"IF(L4>=I15,J15,0)","v":0},{"$f":"IF(P4>=I15,J15,0)","v":0},null,{"$f":"IF(L4>=L15,M15,0)","v":0},{"$f":"IF(P4>=L15,M15,0)","v":0},null,null,{"$f":"IF(L4>=L15,Q15,0)","v":0},{"$f":"IF(P4>=P15,Q15,0)","v":0},null,null,{"$f":"IF(P4>=P15,U15,0)","v":0},{"$f":"IF(P4>=T15,U15,0)","v":0}]
[null,"# of Claims",null,null,2,null,null,null,{"$f":"SUM(I20:I26)","v":0.1},{"$f":"SUM(J20:J26)","v":0.1},null,{"$f":"SUM(L20:L26)","v":0.1},{"$f":"SUM(M20:M26)","v":0.1},null,null,{"$f":"SUM(P20:P26)","v":15},{"$f":"SUM(Q20:Q26)","v":0.1},null,null,{"$f":"SUM(T20:T26)","v":15},{"$f":"SUM(U20:U26)","v":0.1}]
[null,"(parent plus one)",null,null,null,null,null,null,"State Tax Rate",null,null,"State Married filing Jointly",null,null,null,"State Head of Household",null,null,null,"State Married filing Separately"]
[null,"Exemption Value",null,null,{"$f":"E27*E26","v":4500},null,null,null,"Single"]
[null,"Ded. Total",null,null,{"$f":"E29+E25","v":13500}]
[null,"KANSAS ADJUST GROSS",null,null,{"$f":"G14-E30","v":-13500},null,null,null,0,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,15000,0.03,null,30000,0.03,null,null,15000,0.03,null,null,30000,0.03]
[null,null,null,null,null,null,null,null,15001,4.9000000000000002E-2,null,30001,4.9000000000000002E-2,null,null,15001,4.9000000000000002E-2,null,null,30001,4.9000000000000002E-2]
[null,null,"Head of Household Exemption"]
[null,null,2013]
[null,"Federal"]
[null,"Single",null,6100,null,"Married-Joint",12200]
[null,"Head of Household",null,8950,null,null,null,null,"Custodial","Noncust",null,"Cust","Noncust",null,null,"Cust","Noncust",null,null,"Cust","Noncust"]
[null,"Benefit",null,{"$f":"D38-D37","v":2850},null,null,null,null,{"$f":"IF(P47<=I32,J32,0)","v":0.03},{"$f":"IF(Q47<=I32,J32,0)","v":0.03},null,{"$f":"IF(P47<=L32,M32,0)","v":0.03},{"$f":"IF(Q47<=L32,M32,0)","v":0.03},null,null,{"$f":"IF(P47<=P32,Q32,0)","v":0.03},{"$f":"IF(Q47<=P32,Q32,0)","v":0.03},null,null,{"$f":"IF(P47<=T32,U32,0)","v":0.03},{"$f":"IF(Q47<=T32,U32,0)","v":0.03}]
[]
[null,"Kansas Increase",null,null,null,null,null,null,{"$f":"IF(P47>I32,J33,0)","v":0},{"$f":"IF(Q47>I32,J33,0)","v":0},null,{"$f":"IF(P47>L32,M33,0)","v":0},{"$f":"IF(Q47>L32,M33,0)","v":0},null,null,{"$f":"IF(P47>P32, Q33,0)","v":0},{"$f":"IF(Q47>P32, Q33,0)","v":0},null,null,{"$f":"IF(P47>T32,U33,0)","v":0},{"$f":"IF(Q47>T32,U33,0)","v":0}]
[null,"Single",null,3000,null,null,null,null,{"$f":"SUM(I39:I41)","v":0.03},{"$f":"SUM(J39:J41)","v":0.03},null,{"$f":"SUM(L39:L41)","v":0.03},{"$f":"SUM(M39:M41)","v":0.03},null,null,{"$f":"SUM(P39:P41)","v":0.03},{"$f":"SUM(Q39:Q41)","v":0.03},null,null,{"$f":"SUM(T39:T41)","v":0.03},{"$f":"SUM(U39:U41)","v":0.03}]
[null,"Head of Household",null,9000]
[null,"Benefit",null,{"$f":"D43-D42","v":6000}]
[null,null,null,null,null,null,null,null,"Cust",null,"Federal",null,"State",null,null,"State "]
[null,"KS Exempt.",null,2250,null,null,null,null,"Head of Household",null,{"$f":"IF(Worksheet!F33=\"Head of Household\",P27,0)","v":0},null,{"$f":"IF(Worksheet!F33=\"Head of Household\",P42,0)","v":0},null,null,"Cust","Noncust"]
[null,null,null,null,null,null,null,null,"Single",null,{"$f":"IF(Worksheet!F33=\"Single\",I27,0)","v":0},null,{"$f":"IF(Worksheet!F33=\"Single\",I42,0)","v":0},null,null,{"$f":"L1+L5","v":0},{"$f":"P1+P5","v":0},null,null,"Head of Household"]
[null,"Head of Household Benefit",null,null,null,null,null,null,"Married-Joint",null,{"$f":"IF(Worksheet!F33=\"Married-Joint\",L27,0)","v":0},null,{"$f":"IF(Worksheet!F33=\"Married-Joint\",L42,0)","v":0},null,null,null,null,null,null,"Single"]
[null,"Kansas",null,null,null,null,null,null,"Married-Sep",null,{"$f":"IF(Worksheet!F33=\"Married-Sep.\",T27,0)","v":0},null,{"$f":"IF(Worksheet!F33=\"Married-Sep.\",T42,0)","v":0},null,null,null,null,null,null,"Married-Joint"]
[null,"Value of Extra Exemption",null,null,{"$f":"D46","v":2250},null,null,null,"Total",null,{"$f":"SUM(K46:K49)","v":0},null,{"$f":"SUM(M46:M49)","v":0},null,null,null,null,null,null,"Married-Sep."]
[null,"Cust Parent's Marginal Tax Rate",null,null,{"$f":"M50","v":0}]
[null,"Annual Tax Savings",null,null,{"$f":"E50*E51","v":0},null,null,null,"Noncust"]
[null,"Monthly Tax Savings",null,null,{"$f":"E52/12","v":0},null,null,null,"Head of Household",null,{"$f":"IF(Worksheet!F40=\"Head of Household\",Q27,0)","v":0},null,{"$f":"IF(Worksheet!F40=\"Head of Household\",Q42,0)","v":0}]
[null,"% Income Noncustodial",null,null,{"$f":"Worksheet!G147+IF(Worksheet!F45=\"Mother\",Worksheet!J147,Worksheet!H147)","v":{"$error":"#DIV/0!"}},null,null,null,"Single",null,{"$f":"IF(Worksheet!F40=\"Single\",J27,0)","v":0},null,{"$f":"IF(Worksheet!F40=\"Single\",J42,0)","v":0}]
[null,"Noncustodial's Share",null,null,{"$f":"E54*E53/100","v":{"$error":"#DIV/0!"}},null,null,null,"Married-Joint",null,{"$f":"IF(Worksheet!F40=\"Married-Joint\",M27,0)","v":0},null,{"$f":"IF(Worksheet!F40=\"Married-Joint\",M42,0)","v":0}]
[null,null,null,null,null,null,null,null,"Married-Sep",null,{"$f":"IF(Worksheet!F40=\"Married-Sep.\",U27,0)","v":0},null,{"$f":"IF(Worksheet!F40=\"Married-Sep.\",U42,0)","v":0}]
[null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(K53:K56)","v":0},null,{"$f":"SUM(M53:M56)","v":0}]
[null,"Standard Deduction Benefit"]
[null,"Federal",null,null,{"$f":"D39","v":2850}]
[null,"Cust Parent's Marginal Tax Rate",null,null,{"$f":"K50","v":0}]
[null,"Value Tax Savings",null,null,{"$f":"E60*E59","v":0}]
[]
[null,"Kansas",null,null,{"$f":"D44","v":6000}]
[null,"Cust Parent's Marginal Tax Rate",null,null,{"$f":"M50","v":0}]
[null,"Value of Tax Savings",null,null,{"$f":"E63*E64","v":0}]
[null,"Total Tax Savings",null,null,{"$f":"E61+E65","v":0}]
[null,"Mother's Monthly Tax Savings",null,null,{"$f":"E66/12","v":0}]
[null,"Noncust Parent's % of Income",null,null,{"$f":"E54","v":{"$error":"#DIV/0!"}}]
[null,"Noncust Parent's  Share",null,null,{"$f":"E68*E67/100","v":{"$error":"#DIV/0!"}}]
[null,"Adjustment",null,null,{"$f":"E55+E69","v":{"$error":"#DIV/0!"}}]
[null,"Remove HOH",null,null,{"$f":"IF(K46=0,-E70,0)","v":{"$error":"#DIV/0!"}}]
[null,"TOTAL ADJUSTMENT",null,null,{"$f":"E70+E71","v":{"$error":"#DIV/0!"}}]