{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Start Here","Espanol Empiece Aqui","CS Worksheet","Schedule A","Self Employment Calculator","Schedule B","Schedule C","Schedule D","Schedule D Supplemental Tables","Schedule E","Schedule E Supplemental Tables","Footnotes","Explanation of Terms","BCSO"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":624,"comments":8,"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":"Start Here","index":0,"n_rows":127,"n_cols":4,"rows_kept":127,"cut":false,"hidden":false,"merged":[[99,2,99,3],[126,1,126,3],[113,2,113,3],[116,2,116,3],[119,2,119,3],[122,2,122,3],[109,2,109,3],[110,2,110,3],[103,2,103,3],[106,2,106,3],[102,2,102,3],[84,2,84,3],[85,2,85,3],[86,2,86,3],[95,2,95,3],[91,2,91,3],[87,2,87,3],[92,2,92,3],[96,2,96,3],[65,2,65,3],[69,2,69,3],[73,2,73,3],[41,2,41,3],[52,2,52,3],[50,2,50,3],[54,2,54,3],[56,2,56,3],[66,2,66,3],[81,2,81,3],[61,1,61,3],[58,1,58,3],[90,2,90,3],[77,2,77,3],[82,2,82,3],[15,1,15,3],[16,1,16,3],[39,1,39,3],[14,1,14,3],[10,1,10,3],[19,1,19,3],[35,1,35,3],[38,1,38,3],[1,1,1,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[9,1,9,3],[8,1,8,3]]}
[]
[null,"Georgia Child Support Guidelines Calculators"]
[]
[null,"Helpful Information for Using the"]
[null,"Excel™ Downloadable Electronic Worksheet"]
[null,"(Electronically Calculates the Child Support Obligation)"]
[]
[null,"1)  General Information"]
[null,"Welcome!  The Child Support Guidelines downloadable Electronic Worksheet is a Microsoft Excel™ (.xls) file used for creating a Child Support Worksheet.  All of the functionality of Microsoft Excel is present in the file.  The worksheet and schedule’s auto-calculation formulas are protected and are in a view only "]
[null,"format so the user may only enter information in the fields that are highlighted in "]
[null,"color.  This protection also prevents one from accidently changing formulas used for calculations.  Calculations automatically occur and display on worksheet/schedules as yellow fields are updated with dollar amounts.  An asterisk * indicates a required field that must be completed to generate a Worksheet.  See the Explanation of Terms tab for helpful definitions.  Print a copy of this resource as you may want to refer to it while creating the worksheet.  Important: ALWAYS ENABLE MACROS as you open the Worksheet  (See below, Requirements to run the Excel Calculator Tool.)"]
[]
[null,"Here are a few helpful hints for entering information on the Excel Worksheet:"]
[]
[null,"·         To access a drop-down menu: (Ex: Court and County fields): place cursor over field, click and down arrow will\n           display; click down arrow to reveal a list of choices; make selection by clicking desired choice; selection will display."]
[null,"·         To populate check boxes: place cursor over box; click and a check mark will display; click again and the check\n           mark will be removed."]
[null,"·         To access Bubble Boxes of instructions, definitions or information: place cursor over red triangles to display\n           information; move cursor away to close display."]
[]
[null,"2)  Contents of the Calculator"]
[null,"This calculator is an Excel workbook consisting of thirteen worksheet tabs that allow data entry and are labeled as indicated below:"]
[]
[null,"1)             Start Here  (view only)","1)","Start Here  (view only)"]
[null,"2)             CS Worksheet  (the Child Support Worksheet)","2)","CS Worksheet  (the Child Support Worksheet)"]
[null,"3)             Schedule A  (Gross Income)","3)","Schedule A  (Gross Income)"]
[null,"4)             Self-Employment Calculator","4)","Self-Employment Calculator"]
[null,"5)             Schedule B  (Adjusted Income)","5)","Schedule B  (Adjusted Income)"]
[null,"6)             Schedule C  (RESERVED FOR FUTURE USE)","6)","Schedule C  (RESERVED FOR FUTURE USE)"]
[null,"7)             Schedule D  (Additional Expenses)","7)","Schedule D  (Additional Expenses)"]
[null,"8)             Schedule D Supplemental Tables  (Additional Supplemental Tables 2, 3 & 4)","8)","Schedule D Supplemental Tables  (Additional Supplemental Tables 2, 3 & 4)"]
[null,"9)             Schedule E  (Deviation Special Circumstances)","9)","Schedule E  (Deviation Special Circumstances)"]
[null,"10)         Schedule E Supplemental Tables  (Additional Supplemental Tables 2, 3 & 4)","10)","Schedule E Supplemental Tables  (Additional Supplemental Tables 2, 3 & 4)"]
[null,"11)         Footnotes","11)","Footnotes"]
[null,"12)         Explanation of Terms  (view only)","12)","Explanation of Terms  (view only)"]
[null,"13)         BCSO (the Basic Child Support Obligation) Table  (view only)","13)","BCSO (the Basic Child Support Obligation) Table  (view only)"]
[]
[null,"Note:  While using the Tab key is the best way to reach the next cell, if some sections do not apply to your case, click into the \nnext yellow cell that does apply and continue."]
[]
[null,"3)  Requirements to run the Excel Calculator Tool"]
[null,"The Excel calculators will run on Microsoft Excel 2007 or newer, but the calculators are not compatible with Microsoft Office 365, Corel Quattro Pro, Open Office, or other spreadsheet software programs."]
[null,"Important Note:  The Excel calculator is designed to always open at the Start Here tab.  If you enable Macros after you have begun entering data, the calculator will take you back to the “Start Here tab.”"]
[]
[null,"  a)","Instructions for Microsoft Excel 2007 (included in Vista Operating System) (ALWAYS ENABLE MACROS as you open the Worksheet.)  Follow steps below to adjust Macro security settings:"]
[null,null,"• Find Microsoft Windows Office Button              located at top left of screen; click and drop down menu will open."]
[null,null,"• Find “Excel Options,” click and box will open."]
[null,null,"• Find “Trust Center” and “Trust Center Settings,” click and Macros settings box will open."]
[null,null,"• Under Macro settings, click 2nd radio button, “Disable All Macros with Notification.”"]
[null,null,"• Click OK and OK again; boxes will close and steps are completed."]
[null,null,"• This message may display each time Data Entry Form is opened; if so, select Options and click “Enable this content,\" then"]
[null,"            click OK.  Ex:  "]
[]
[null,"  b)","Instructions for Microsoft Excel 2010 (ALWAYS ENABLE MACROS as you open the Worksheet.)  Follow steps below to adjust Macro security settings:"]
[]
[null,null,"• Click the File tab, and then click Options (The Excel Options Dialog box appears.)\n• Click the Trust Center tab, and then click the Trust Center Settings button (The Trust Center dialog box appears with the Macro Settings tab selected.)\n• Select the security level to \"Disable All Macros with Notification.\"\n• Click OK and OK again; boxes will close and steps are completed.\n• This message may display each time Data Entry Form is opened; if so, select “Enable Content.”\n                     Ex:  "]
[]
[null,"  c)","Instructions for Microsoft Excel 2013 (ALWAYS ENABLE MACROS as you open the Worksheet.)  Follow steps below to adjust Macro security settings:"]
[]
[null,null,"• Click the File tab.\n• Click Info.\n• In the Security Warning section, Click Enable Content.\n• The following messages may be displayed each time the Worksheet is opened; if so, select \"Enable Editing\" and “Enable Content.”\n\n          Ex:  \n\n          Ex:    "]
[]
[null,"IMPORTANT:  If the Macros are not enabled, formulas for calculations will not work correctly and the resulting calculations in the worksheet will be wrong."]
[]
[null,"4)  Saving the File"]
[null,"It is suggested that one save the Downloadable Excel Worksheet periodically while entering data.  (ALWAYS ENABLE MACROS as you open the Worksheet.)"]
[]
[null,"Excel 2007 Users"]
[]
[null,null,"If you selected “Open” when downloading the workbook, click on the Microsoft icon "]
[null,null,"in the top left corner, and then select “Save As” from the drop down list.  Next, save the workbook to a location you choose, and give the file a new name along with \"Save as type\" of Excel Macro-Enabled Workbook."]
[null,"Excel 2010 Users"]
[]
[null,null,"If you selected “Open” when downloading the workbook, save the file by selecting “Save As\" from the menu.  Next, save the workbook to a location you choose, and give the file a new name along with \"Save as type\" of Excel Macro-Enabled Workbook."]
[]
[null,"Excel 2011 for the Mac Users"]
[]
[null,null,"Save the file by selecting “File” from the menu, and then select “Save As.”  Next, give the file a new name, save the workbook to a location you choose, and choose Excel Macro-Enabled Workbook (.xlsm) as the format."]
[]
[null,"Excel 2013 Users"]
[]
[null,null,"If you selected “Open” when downloading the workbook, save the file by selecting “Save As\" from the menu.  Next, save the workbook to a location you choose, and give the file a new name along with \"Save as type\" of Excel Macro-Enabled Workbook.\n\nALERT: In addition, you may get a false Compatibility Checker message stating that significant loss of functionality may occur.  This does not affect the Child Support Calculator, so you can respond by clicking on \"Continue\" when saving this workbook."]
[null,"5)  Start Here (page you are viewing now)"]
[]
[null,"6)  CS Worksheet"]
[null,null,"·   Add children in this order - 1 through 12.  Click box to left of child’s name field; choose “X” for each child involved in current case.  Type name and dates of birth for children in appropriate fields.  Total Number of Children will automatically display just below this area."]
[null,null,"·   Final Monthly Child Support Amount (rounded) will display on Line 13 after all data has been entered on the worksheet and schedules."]
[null,"7)  Schedule A"]
[null,null,"·   Do not include income for a Nonparent Custodian."]
[null,null,"·   Self-Employment income may be entered on Schedule A, Line 3 or entered and calculated using the Self-Employment Calculator."]
[null,null,"     Click                               to access the Self Employment Calculator tab."]
[null,null,"·   If Imputed Income is entered for a parent on Line 23, use appropriate box labeled Mother or Father to explain how Imputed Income was determined."]
[]
[null,"8)  Self-Employment Calculator"]
[null,null,"·   Self-Employment income may be entered and calculated using Self-Employment Calculator or by entering income"]
[null,null,"     directly on Schedule A, Line 3.  Amounts from the Self-Employment Calculator, Line 13, will display on Schedule "]
[null,null,"     A, Line 3, when the                                button is clicked."]
[]
[null,"9)  Schedule B"]
[null,null,"·   If Qualified Children apply, select box under “Mark X if Mother or Father is Claiming Credit” to indicate parent claiming child."]
[null,null,"·   Select “X” under Date of Birth Column for “Total number of QUALIFIED children for whom adjustment is being claimed.”  If box does not display “X,” calculation here will not occur."]
[]
[null,"10)  Schedule C"]
[null,null,"·   This schedule is reserved for future use."]
[]
[null,"11)  Schedule D"]
[null,null,"·   Health Insurance Premiums Paid for the Children is entered on Line 2 in the top section."]
[null,null,"·    Work Related Child Care is entered below the top section using Supplemental Table 1 found on this same page."]
[]
[null,"12)  Supplemental Schedule D (more than three children)"]
[null,null,"·   Supplemental Tables 2, 3, 4, are used when more than three children are included in current action."]
[]
[null,"13)  Schedule E"]
[null,null,"·   If noncustodial parent requests a Low Income Deviation, request box must be checked; otherwise, deviation will not be included on Line 14."]
[null,null,"·   Extraordinary Educational, Medical and Special Expenses for Child Rearing are entered on Supplemental Table 1 and calculations appear on Lines 12(a) – 12(g)."]
[]
[null,"14)  Supplemental Schedule E"]
[null,null,"·   Supplemental Tables 2, 3, 4, are used when more than three children are included in current action."]
[]
[null,"15)  Footnotes"]
[null,null,"·   Footnotes allow for the entry of notes related to the current case.  Click the tab and enter information in the three columns.  Notes may help one recall, or the court to understand, why one entered certain information on the worksheet or schedules.  ONLY enter information related to the calculations."]
[null,null,"  "]
[null,"16)  Explanation of Terms"]
[null,null,"·   Explanation of Terms provides information from guidelines statute about terms used on worksheet and schedules."]
[]
[null,"17)  Basic Child Support Obligation (BCSO) Table"]
[null,null,"·   A chart that displays the dollar amount of the BCSO table matching to various levels of combined adjusted income of children's parents and number of children for whom child support order is being established or modified. The chart is view only and should not be taken as the child support obligation of the noncustodial parent.  The calculator uses this table in the automatic formulas of the calculator."]
[]
[null,"The Worksheet has been completed – what’s next?"]
[]
[null,"Save the Worksheet file for the final time.  If you are using a public computer, save the file to a jump drive, cd, or other media.  The final child support obligation amount appears on Line 13 of the Worksheet.  Using the computers print feature, print the CS Worksheet and only the Schedules that contain the data you entered and the resulting calculations.  Keep a copy of the worksheet and schedules for your records and provide a copy to the court, along with all necessary proof/evidence to support the Worksheet.  Most courts will want you to email the worksheet to the Clerk or Judge.  If you do not know the exact process used in your court, check with the Clerk or ask your attorney.  If you have more than three (3) children in this case, be sure to also print the supplemental schedules for Schedules D and E."]

{"sheet":"Espanol Empiece Aqui","index":1,"n_rows":125,"n_cols":4,"rows_kept":125,"cut":false,"hidden":false,"merged":[[120,2,120,3],[122,1,122,3],[124,1,124,3],[111,2,111,3],[113,1,113,3],[114,2,114,3],[116,1,116,3],[117,2,117,3],[119,1,119,3],[110,1,110,3],[94,2,94,3],[96,1,96,3],[97,2,97,3],[99,1,99,3],[100,2,100,3],[101,2,101,3],[103,1,103,3],[104,2,104,3],[106,1,106,3],[107,2,107,3],[108,2,108,3],[93,2,93,3],[77,2,77,3],[79,1,79,3],[81,1,81,3],[82,2,82,3],[83,2,83,3],[85,2,85,3],[86,2,86,3],[87,2,87,3],[89,1,89,3],[90,2,90,3],[92,1,92,3],[75,1,75,3],[60,1,60,3],[61,1,61,3],[63,1,63,3],[65,2,65,3],[66,2,66,3],[67,1,67,3],[69,2,69,3],[71,1,71,3],[73,2,73,3],[58,1,58,3],[40,2,40,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[50,2,50,3],[52,2,52,3],[54,2,54,3],[56,2,56,3],[38,1,38,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[17,1,17,3],[18,1,18,3],[34,1,34,3],[36,1,36,3],[37,1,37,3],[8,1,8,3],[1,1,1,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3]]}
[]
[null,"Pautas Para las Calculadora de Manutención Infantil de Georgia"]
[]
[null,"Información útil para usar la"]
[null,"Hoja de Cálculo Excel™ Descargable"]
[null,"(Calcula Electrónicamente la Obligación de la Manutención Infantil)"]
[]
[null,"1) Información General"]
[null,"¡Bienvenido!  La hoja electrónica de cálculo descargable Pautas para Manutención Infantil es un archivo Excel™ (.xls) de Microsoft que se usa para crear una Hoja de cálculo de Manutención Infantil. Toda la funcionalidad de Excel de Microsoft está presente en el archivo. La hoja de cálculo y las fórmulas de cálculo automático de las escalas están protegidas, en un formato solamente para ver, para que el usuario sólo pueda ingresar información en los espacios resaltados de color amarillo. "]
[null,"Esta protección también evita que uno, accidentalmente, cambie las fórmulas usadas para los cálculos. Los cálculos son ejecutados de forma automática y se muestran en la hoja de cálculo y en las escalas mientras los espacios amarillos se actualizan with dollar amounts. Un asterisco * indica que se trata de un espacio requerido que se debe llenar para generar una Hoja de cálculo. Vea \"Explanation of Terms\" (Explicación de términos) para definiciones útiles.  Imprima una copia de este recurso ya que existe la posibilidad que usted quiera consultarlo al crear la hoja de cálculo. Importante: SIEMPRE HABILITE MACROS al abrir la Hoja de cálculo (Vea a continuación, Requisitos para hacer funcionar a la Herramienta Calculadora de Excel.)"]
[]
[null,"Éstas son algunas pistas útiles para ingresar la información en la Hoja de cálculo de Excel:"]
[]
[null,"·         Para obtener acceso a un menú desplegable: (Ejemplo: en los espacios donde dice “Court” (Tribunal) y “County” (Condado)): ponga\n           el cursor sobre el espacio, haga clic y aparecerá una flecha hacia abajo; haga clic en la flecha hacia abajo y aparecerá una lista de \n           opciones, haga su selección haciendo clic en la opción deseada; la selección aparecerá."]
[null,"·         Para rellenar la casillas de verificación: Coloque el cursor sobre la casilla; haga clic y la marca de verificación aparecerá; vuelva a\n           hacer clic y la marca de verificatión desaparecerá."]
[null,"·         Para obtener acceso a las ventanas de comentario “pop up” de instrucciones, definiciones o información: coloque el cursor sobre\n           los triángulos rojos para que la información aparezca; aleje el cursor para hacer que la imagen se cierre."]
[]
[null,"2) Contenido de la Calculadora"]
[null,"Esta calculadora es un plantilla Excel que consiste en trece pestañas de hojas de cálculo que permiten el ingreso de datos y que se indican a continuación:"]
[]
[null,"1)             Start Here  (view only)","1)","Start Here (Empiece aquí) (sólo para ver)"]
[null,"2)             CS Worksheet  (the Child Support Worksheet)","2)","CS Worksheet  (la Hoja de Cálculo de Manutención Infantil)"]
[null,"3)             Schedule A  (Gross Income)","3)","Schedule A (Anexo A) (Ingresos Brutos)"]
[null,"4)             Self-Employment Calculator","4)","Self-Employment Calculator (Calculadora de trabajo por cuenta propia)"]
[null,"5)             Schedule B  (Adjusted Income)","5)","Schedule B (Anexo B) (Ingresos Ajustados)"]
[null,"6)             Schedule C  (RESERVED FOR FUTURE USE)","6)","Schedule C  (Anexo C) (RESERVADO PARA USO FUTURO)"]
[null,"7)             Schedule D  (Additional Expenses)","7)","Schedule D  (Anexo D) (Gastos Adicionales)"]
[null,"8)             Schedule D Supplemental Tables  (Additional Supplemental Tables 2, 3 & 4)","8)","Schedule D Supplemental Tables (Tablas Suplementarias de la Anexo D) (Tablas Suplementarias Adicionales 2, 3 y 4)"]
[null,"9)             Schedule E  (Deviation Special Circumstances)","9)","Schedule E  (Anexo E) (Circunstancias de Desviaciones Especiales)"]
[null,"10)         Schedule E Supplemental Tables  (Additional Supplemental Tables 2, 3 & 4)","10)","Schedule E Supplemental Tables (Tablas Suplementarias de la Anexo E) (Tablas Suplementarias Adicionales 2, 3 y 4)"]
[null,"11)         Footnotes","11)","Footnotes (Notas de pie)"]
[null,"12)         Explanation of Terms  (view only)","12)","Explanation of Terms (Explicación de términos) (sólo para ver)"]
[null,"13)         BCSO (the Basic Child Support Obligation) Table  (view only)","13)","BCSO Table (Tabla de responsabilidad básica de Manutención Infantil) (sólo para ver)"]
[]
[null,"Nota:   Aunque la tecla “Tab” es la mejor manera de moverse a la siguiente celda, si algunas secciones no se aplican a su caso, haga clic en la próxima celda amarilla aplicable y continúe."]
[]
[null,"3) Requisitos para hacer funcionar a la Herramienta Calculadora de Excel"]
[null,"Las calculadoras de Excel funcionarán en las versiones de Excel 1997, o más nuevas, de Microsoft, pero no son compatibles con Microsoft Office 365, Corel Quattro Pro, Open Office, ni otros programas de hojas de cálculo."]
[null,"Nota Importante:  La calculadora de Excel ha sido diseñada para siempre abrirse en la pestaña “Start Here”. Si usted habilita las Macros después de haber comenzado a ingresar los datos, la calculadora le volverá a llevar a la pestaña “Start Here”."]
[]
[null,"  a)","Instrucciones para Excel 2007 de Microsoft (incluido en el Sistema Operativo Vista) (SIEMPRE HABILITE MACROS al abrir la Hoja de cálculo.) Siga los pasos siguientes para ajustar la configuración de seguridad de Macros:"]
[]
[null,null,"• Busque el botón de Windows Office de Microsoft              ue está situado en la parte superior izquierda de la pantalla; haga clic en \n   él y se abrirá un menú desplegable."]
[null,null,"• Busque “Excel Options” (Opciones de Excel), haga clic y se abrirá un cuadro."]
[null,null,"• Busque “Trust Center” (Centro de Confianza) y “Trust Center Settings,” (Configuración del Centro de Confianza), haga clic y se \n   abrirá el cuadro de configuración de Macros."]
[null,null,"• En “Macro settings” (configuración de Macros), haga clic en el segundo botón de selección de radio, “Disable All Macros with \n   Notification” (Deshabilitar todas las macros con notificación)."]
[null,null,"• Seleccione “OK” y otra vez “OK”; los cuadros se cerrarán y los pasos se han completado."]
[null,null,"• Es posible que este mensaje aparezca cada vez que se abra la hoja de cálculo. Si éste es el caso, seleccione “Options” \n   (Opciones) y haga clic en “Enable this content,” (Habilitar este Contenido), haga clic en \"OK\"."]
[null,null,null,"Ejemplo:"]
[]
[null,"  b)","Instrucciones para Excel 2010 de Microsoft (SIEMPRE HABILITE MACROS al abrir la Hoja de cálculo.) Siga los pasos siguientes para ajustar la configuración de seguridad de Macros:"]
[]
[null,null,"• Haga clic en la pestaña “File” (Archivo), y luego en “Options” (Opciones) (El cuadro del diálogo de Opciones de Excel aparece.)\n• Haga clic en la pestaña “Trust Center” (Centro de Confianza) y luego en el botón “Trust Center Settings” (Configuración del Centro\n  de Confianza) (Aparece el cuadro de diálogos del Centro de Confianza con la pestaña “Macro Settings” (Configuración de las \n  Macros) seleccionada.)\n• Seleccione el nivel de seguridad para \"Disable All Macros with Notification\" (Deshabilitar todas las macros con notificación).\n• Seleccione “OK” y otra vez “OK”; los cuadros se cerrarán y los pasos se han completado.\n• Es posible que este mensaje aparezca cada vez que se abra el “Data Entry Form” (Formulario de entrada de datos); si este es el \n  caso seleccione “Enable Content” (Habilitar contenido)\n\n                     Ejemplo: "]
[]
[null,"  c)","d) Instrucciones para Excel 2013 de Microsoft (SIEMPRE HABILITE MACROS al abrir la Hoja de cálculo.) Siga los pasos siguientes para ajustar la configuración de seguridad de Macros:"]
[]
[null,null,"•  Haga clic en la pestaña “File” (Archivo).\n•  Haga clic en Info.\n•  En la sección “Security Warning” (Advertencia de seguridad), haga clic en “Enable Content” (Habilitar contenido).\n•  Es posible que los siguientes mensajes aparezcan cada vez que se abra la Hoja de cálculo; si este es el caso, seleccione \"Enable Editing\" (Habilitar edición) y “Enable Content”(Habilitar contenido).\n\n          Ejemplo:  \n\n          Ejemplo:    "]
[]
[null,"IMPORTANTE: Si no se habilitan las Macros, las fórmulas para los cálculos no funcionarán correctamente y los cálculos resultantes en la hoja de cálculo estarán equivocados."]
[]
[null,"4)  Guardar el Archivo"]
[null,"Se sugiere que se guarde periódicamente la Hoja de Cálculo Descargable de Excel mientras se ingresen los datos.    (SIEMPRE HABILITE MACROS al abrir la Hoja de cálculo.)"]
[]
[null,"Usarios de Excel 2007"]
[]
[null,null,"Si seleccionó “Open” (Abrir) al bajar la planilla, haga clic en el icono de Microsoft             que se encuentra en la esquina superior izquierda y seleccione “Save As” (Guardar Como) de la lista desplegable. Luego, guarde  el cuaderno de trabajo en la ubicación que usted escoja, y provéale un nuevo nombre al archivo conjuntamente con \"Save as type\" (Guardar como tipo) de \"Excel Macro-Enabled Workbook.\""]
[]
[null,"Usuarios de Excel 2010"]
[]
[null,null,"Si seleccionó “Open” (Abrir) al bajar la planilla, guarde el archivo seleccionando “Save As\" (Guardar como) en el menú. Luego, guarde  el libro de trabajo en la ubicación que usted escoja, y provéale un nuevo nombre al archivo conjuntamente con \"Save as type\" (Guardar como tipo) de \"Excel Macro-Enabled Workbook.\""]
[]
[null,"Excel 2011 for the Mac Users"]
[]
[null,null,"Guarde el archivo seleccionando “File” (Archivo) en el menú, y luego seleccione “Save As” (Guardar como).  Luego, provéale un nuevo nombre al archivo, guárdelo en la ubicación que usted escoja, y escoja el formato de \"Excel Macro-Enabled Workbook.\""]
[]
[null,"Usuarios de Excel 2013"]
[]
[null,null,"Si seleccionó “Open” (Abrir) al descargar el cuaderno de trabajo, guarde el archivo seleccionando “Save As\" (Guardar como) en el menú. Luego, guarde  el libro de trabajo en la ubicación que usted escoja, y déle un nuevo nombre al archivo conjuntamente con \"Save as type\" (Guardar como tipo) de \"Excel Macro-Enabled Workbook.\"\nALERTA: Además, es posible que reciba un mensaje “false Compatibility Checker” (falso del Revisor de compatibilidad) declarando que puede ocurrir una significativa pérdida de funcionalidad.  Esto no afecta a la Calculadora de Manutención Infantil, así es que al guardar este cuaderno de trabajo puede responder haciendo clic en \"Continue\" (Continuar)."]
[]
[null,"5)  “Start Here” (la página que usted está viendo en este momento)"]
[]
[null,"6)  \"CS Worksheet\" (Hoja de cálculo de manutención infantil)"]
[null,null,"·   Añada los niños en este orden: 1 a 12.  Haga clic en el cuadro situado a la izquierda del espacio para el nombre del menor; escoja “X” para cada niño involucrado en el caso actual. Escriba los nombres y las fechas de nacimiento de los menores en los espacios apropiados. El “Total Number of Children” (número total de niños) aparecerá automáticamente justo debajo de esta área."]
[null,null,"·   “Final Monthly Child Support Amount” (Mensual la cantidad final de Manutención Infantil) (redondeada) aparecerá en la Línea 13 cuando todos los datos han sido ingresados en la hoja de cálculo y las escalas."]
[null,"7)  Schedule A"]
[null,null,"·   No incluya los ingresos del Tutor sin ser padre/madre."]
[null,null,"·   “Self-Employment income” (Ingresos de trabajo por cuenta propia) se pueden ingresar en \"Schedule A\", Línea 3 o se pueden \n      ingresar y calcular usando la “Self-Employment Calculator” (Calculadora de trabajo por cuenta propia).\n      Haga clic en                              para obtener acceso a la pestaña “Self Employment Calculator” (Calculadora de trabajo por \n      cuenta propia)."]
[null,null,"·   Si se ingresan los Ingresos atribuidos a un padre en la Líniea 23, us el cuadro adecuado etiquetado \"Mother\" o \"Father\" para\n     explicar cómo se determinaron estos ingresos."]
[]
[null,"8)  \"Self-Employment Calculator\""]
[null,null,"·   Los Ingresos de trabajo por cuenta propia pueden ser ingresados y calculados usando el “Self-Employment Calculator” o poniendo estos ingresos directamente en \"Schedule A\", Línea 3.  Las cantidades de la “Self-Employment Calculator”, Línea 13 aparecerán en \"Schedule A\", Línea 3 cuando al hacer clic en el botón\n"]
[]
[null,"9)  \"Schedule B\""]
[null,null,"·  Si aplican Menores Calificados, seleccione el cuadro debajo de “Mark X if Mother or Father is Claiming Credit” (Marque \n    con una X si la madre o el padre está reclamando el crédito) para indicar cuál padre está reclamando al menor."]
[null,null,"·  Seleccione “X” bajo la columna “Date of Birth” (Fecha de Nacimiento) para “Total number of QUALIFIED children for whom \n    adjustment is being claimed” (Número total de menores CALIFICADOS para quienes se está reclamando un ajuste).  Si el \n    cuadro no muestra una “X,” no ocurrirá un cálculo aquí."]
[]
[null,"10)  \"Schedule C\""]
[null,null,"·   Este \"Schedule\" está reservado para uso futuro."]
[]
[null,"11)  \"Schedule D\""]
[null,null,"·   “Health Insurance Premiums Paid for the Children” (Primas de seguro de salud pagadas para los menores) se ingregan \n      en la Línea 2 en la sección más arriba."]
[null,null,"·    “Work Related Child Care” (Cuidado de menores relacionado con el trabajo) se ingresa a continuación usando \n      \"Supplemental Table 1\" que se encuentra en esta misma página."]
[]
[null,"12)  \"Supplemental Schedule D\" (más de tres menores)"]
[null,null,"·   Las tablas \"Supplemental Tables\" 2,3 y 4 se usan cuando más de tres menores se incluyen en la acción actual."]
[]
[null,"13)  \"Schedule E\""]
[null,null,"·   Si un padre o madre sin custodia pide un “Low Income Deviation” (Desviación por bajos ingresos), se debe marcar la \n     casilla de petición; de lo contrario, la desviación no será incluida en Línea 14."]
[null,null,"·   “Extraordinary Educational, Medical and Special Expenses for Child Rearing” (Gastos extraordinarios educativos, médicos y especiales para la crianza de niños) se ingresan en el “Supplemental Table 1” los cálculos aparecen en las Líneas 12(a) a 12(g)."]
[]
[null,"14)  Supplemental Schedule E"]
[null,null,"·   Las tablas \"Supplemental Tables\" 2,3 y 4 se usan cuando más de tres menores se incluyen en la acción actual."]
[]
[null,"15)  \"Footnotes\""]
[null,null,"·   Las notas de pie de página permiten ingresar notas relacionadas con el caso actual.  Haga clic en la pestaña y ponga la \n     información en las tres columnas. Las notas le pueden ayudar a recordar, o pueden hacer que el tribunal comprenda por \n     qué ingresó cierta información en la hoja de cálculo o en las escalas. SÓLO ingrese información relacionada con los \n     cálculos."]
[null,null,"  "]
[null,"16)  \"Explanation of Terms\""]
[null,null,"·   “Explanation of Terms” proporciona información del estatuto de pautas sobre los términos utilizados en la hoja de cálculo y \n      las escalas."]
[]
[null,"17)  \"Basic Child Support Obligation (BCSO) Table\""]
[null,null,"·   Una tabla que muestra la cantidad de dólares de la tabla BCSO correspondiente a varios niveles de ingresos ajustados \n     combinados de los padres del menor y al número de menores para quienes se está estableciendo o modificando la orden de   \n     manutención infantil. La tabla es sólo para verse y no debe tomarse como la responsabilidad de manutención infantil del \n     padre/madre sin custodia. La calculadora usa esta tabla en sus fórmulas automáticas."]
[]
[null,"La Hoja de cálculo ha sido completada – ¿qué es lo que sigue?"]
[]
[null,"Guarde la Hoja de cálculo por última vez. Si está usando una computadora pública, guarde el archivo en una memoria USB, CD o en otros medios. La cantidad final de la manutención infantil aparece en la Línea 13 de la Hoja de cálculo.  Use la función de imprimir de su computadora para imprimir la “CS Worksheet” (Hoja de cálculo de manutención infantil) y solamente los “Schedules” (Anexos) que contengan los datos que usted ingresó y los cálculos resultantes. Mantenga una copia de la hoja de cálculo y de los anexos para sus archivos y proporcione una copia al tribunal, junto con todas las pruebas necesarias/evidencias que respalden a la Hoja de cálculo. La mayoría de los tribunales querrán que usted envíe la hoja de cálculo por correo electrónico al Oficial o al Juez  Si no sabe cuál es el proceso exacto usado en su tribunal, averigüe con el Oficial de la corte o pregúntele a su abogado. Si tiene más de tres (3) menores en el caso, asegúrese de imprimir las tablas suplementarias para “Schedules” (Anexos) D y E."]

{"sheet":"CS Worksheet","index":2,"n_rows":234,"n_cols":13,"rows_kept":234,"cut":false,"hidden":false,"merged":[[0,8,0,9],[18,3,18,5],[19,3,19,5],[20,3,20,5],[0,6,0,7],[1,1,1,12],[13,7,13,9],[17,3,17,5],[2,2,2,3],[15,1,15,8],[15,9,15,11],[52,3,53,9],[47,3,48,9],[49,1,49,2],[44,1,45,2],[47,1,48,2],[9,2,9,3],[10,2,10,3],[3,8,3,9],[8,1,8,5],[5,1,5,5],[4,1,4,6],[7,8,7,9],[7,1,7,6],[6,1,6,5],[8,8,8,12],[21,3,21,5],[19,9,19,11],[20,9,20,11],[26,11,26,12],[24,5,24,6],[31,3,32,9],[29,3,29,9],[24,8,24,9],[26,1,26,4],[3,14,3,15],[5,8,5,9],[11,5,11,6],[5,10,5,11],[3,10,3,11],[36,3,36,9],[37,3,37,9],[40,3,40,9],[46,3,46,9],[44,11,46,11],[41,1,41,12],[36,12,37,12],[38,3,38,9],[45,3,45,9],[44,3,44,9],[44,10,46,10],[38,1,38,2],[39,1,39,2],[43,1,43,9],[39,3,39,9],[40,1,40,2],[46,1,46,2],[34,1,34,2],[34,3,34,9],[68,1,68,12],[65,1,65,12],[66,2,66,6],[11,1,11,4],[25,7,25,9],[16,1,16,2],[16,7,16,8],[13,10,13,12],[13,1,13,3],[13,4,13,6],[36,1,37,2],[30,3,30,9],[33,3,33,9],[49,3,49,9],[52,1,53,2],[55,1,55,12],[56,3,56,9],[56,1,56,2],[54,1,54,12],[52,11,53,11],[52,10,53,10],[57,1,57,12],[47,10,48,10],[47,11,48,11],[35,3,35,9],[14,1,14,12],[36,10,37,10],[25,11,25,12],[30,11,32,11],[30,12,32,12],[28,1,28,9],[26,5,26,6],[30,10,32,10],[36,11,37,11],[35,1,35,2],[21,9,21,11],[22,9,22,11],[18,9,18,11],[22,3,22,5],[17,9,17,11],[26,8,26,9],[29,1,29,2],[30,1,32,2],[33,1,33,2],[16,3,16,5],[16,9,16,11],[24,11,24,12]]}
[null,null,null,null,"IN THE",null,"COURT OF",null,null,null,"COUNTY"]
[null,"STATE OF GEORGIA"]
[null,false,"DHS, ex rel., o/b/o"]
[null,null,null,null,null,null,null,null,"Civil Action Case No.:"]
[null,null,null,null,null,null,null,null,null," "]
[null,"* Plaintiff,",null,null,null,null,null,null,"IV-D Case No.:"]
[null,"vs.",null,null,null,null,null,"    ","    ",null,null,null," "]
[null,null,null,null,null,null,null,null,"Comments for Court:"]
[null,"* Defendant,"]
[null,false,"  Initial Action"]
[null,false,"  Modification"]
[null,"Date of Initial Child Support Order:"]
[]
[null,"Mother:",null,null,null,null,null,"Father:"]
[null,"Child Support Worksheet  -  Enter amounts/data in yellow fields only.  Calculations will automatically display in the appropriate white fields."]
[null,"Next to the numbers below, enter the Name and Birth Year of all children for whom child",null,null,null,null,null,null,null,"support is being determined in this case."]
[null,"Included",null,"* Name",null,null,"Birth Year","Included",null,"* Name",null,null,"Birth Year"]
[null,"1.",false,null,null,null,null,"7.",false]
[null,"2.",false,null,null,null,null,"8.",false]
[null,"3.",false,null,null,null,null,"9.",false]
[null,"4.",false,null,null,null,null,"10",false]
[null,"5.",false,null,null,null,null,"11.",false]
[null,"6.",false,null,null,null,null,"12.",false]
[]
[null,"Total Number of Children:",null,null,null,{"$f":"COUNTIF(C18:C23,TRUE)+COUNTIF(I18:I23,TRUE)","v":0},null,null,"Noncustodial Parent",null,false,"Mother"]
[null,null,null,null,null,null,null,null,null,null,false,"Father"]
[null,"Submitted by:",null,null,null,null,null,null,"Nonparent Custodian",null,false]
[]
[null,"Lines 12 and 14 are enterable fields; all other fields will automatically calculate and display amounts.",null,null,null,null,null,null,null,null,"Mother","Father","Total"]
[null,"1.",null,"Monthly Gross Income",null,null,null,null,null,null,{"$f":"'Schedule A'!C29","v":0},{"$f":"'Schedule A'!D29","v":0},{"$f":"'Schedule A'!E29","v":0}]
[null,"2.",null,"Monthly Adjusted Income",null,null,null,null,null,null,{"$f":"IF('Schedule B'!F54=0,'Schedule B'!G25,'Schedule B'!F54)","v":0},{"$f":"IF('Schedule B'!G54=0,'Schedule B'!H25,'Schedule B'!G54)","v":0},{"$f":"K31+L31","v":0}]
[null,null,null,"From Schedule B, Line 9 or 14."]
[]
[null,"3.",null,"Pro Rata Shares of Combined Income",null,null,null,null,null,null,{"$f":"CROUND(IF(K31>0,IF($M$31<800,K31/$M$31,K31/$M$31)))","v":0},{"$f":"CROUND(IF(L31>0,IF($M$31<800,L31/$M$31,L31/$M$31)))","v":0},{"$f":"K34+L34","v":0}]
[null,"4.",null,"Basic Child Support Obligation (from the Table)",null,null,null,null,null,null,null,null,{"$f":"IF(M31<800,VLOOKUP(800,BCSO!A10:H594,IF(2+F25>8,8,F25+2),TRUE),IF(M31>30000,VLOOKUP(30000,BCSO!A10:H594,IF(2+F25>8,8,F25+2),TRUE),VLOOKUP(broundTO(M31),BCSO!A10:H594,IF(2+F25>8,8,F25+2),TRUE)))","v":0}]
[null,"5.",null,"Pro rata shares of Basic Child Support Obligation",null,null,null,null,null,null,{"$f":"IF(K25=TRUE,tround($M$35*(CROUND(IF(K31>0,IF($M$31<800,K31/$M$31,K31/$M$31),0))))-0,tround($M$35*(CROUND(IF(K31>0,IF($M$31<800,K31/$M$31,K31/$M$31),0)))))","v":0},{"$f":"IF(L25=TRUE,tround($M$35*(CROUND(IF(L31>0,IF($M$31<800,L31/$M$31,L31/$M$31),0))))-0,tround($M$35*(CROUND(IF(L31>0,IF($M$31<800,L31/$M$31,L31/$M$31),0)))))","v":0}]
[null,"6.",null,"Adjustment for Work Related Child Care and Health Insurance Expenses",null,null,null,null,null,null,{"$f":"IF('Schedule D'!C7>0,'Schedule D'!C7,0)","v":0},{"$f":"IF('Schedule D'!D7>0,'Schedule D'!D7,0)","v":0}]
[null,null,null,"From Schedule D, Line 5."]
[null,"7.",null,"Adjusted Child Support Obligation\nTotal of Lines 5 & 6.",null,null,null,null,null,null,{"$f":"SUM(K36:K38)","v":0},{"$f":"SUM(L36:L38)","v":0}]
[null,"8.",null,"Adjustment for Additional Expenses Paid.\nFrom Schedule D, Line 3.",null,null,null,null,null,null,{"$f":"IF('Schedule D'!C5>0,'Schedule D'!C5,0)","v":0},{"$f":"IF('Schedule D'!D5>0,'Schedule D'!D5,0)","v":0}]
[null,"9.",null,"Presumptive Amount of Child Support\nLine 8 subtracted from Line 7.\n\n\n",null,null,null,null,null,null,{"$f":"K39-K40","v":0},{"$f":"L39-L40","v":0}]
[null,"The amount on Line 9 is the Presumptive Child Support Amount."]
[]
[null,null,null,null,null,null,null,null,null,null,"Mother","Father"]
[null,"10.",null,"Deviations from Presumptive Child Support Amount",null,null,null,null,null,null,{"$f":"'Schedule E'!F45","v":0},{"$f":"'Schedule E'!G45","v":0}]
[null,null,null,"Amounts from Schedule E, Line 14 will automatically display."]
[]
[null,"11.",null,"Subtotal (Line 9 plus Line 10)",null,null,null,null,null,null,{"$f":"K41+K45","v":0},{"$f":"L41+L45","v":0}]
[]
[null,"12.",null,"Social Security Payments (excludes Supplemental Security Income (SSI))\nIf a child receives Title II Social Security benefits as a dependent on a parent's account, enter that monthly amount here in that parent's column.  If none, leave blank. (See User Guide.)",null,null,null,null,null,null,0,0]
[]
[]
[null,"13.",null,"Final Monthly Child Support Amount (rounded to a whole number)\nIf the amount on Line 12 is equal to or greater than Line 11, the child support responsibility is met and no further obligation is owed.",null,null,null,null,null,null,{"$f":"ROUND(IF(K50>=K48,0,K48-K50),0)","v":0},{"$f":"ROUND(IF(L50>=L48,0,L48-L50),0)","v":0}]
[]
[null,"The amount on Line 13 is the Final Child Support Amount."]
[null,"Uninsured Health Expenses"]
[null,"14.",null,"\nCarry down percentages from Line 3; enter percentages agreed to; or enter percentages otherwise ordered by the Court.",null,null,null,null,null,null,0,0]
[null,"v"]
[null,"Schedules",null,null,null,null,null,null,null,"Attached","Not Applicable"]
[null,"A",null,"Gross Income",null,null,null,null,null,false]
[null,"B",null,"Adjusted Income",null,null,null,null,null,false,true]
[null,"C",null,"Schedule C is not in use and is intentionally left blank"]
[null,"D",null,"Additional Expenses",null,null,null,null,null,false,true]
[null,"E",null,"Deviations from Presumptive Amount",null,null,null,null,null,false,true]
[]
[null,"v"]
[null,null,"Print Instructions for the Child Support Worksheet and Schedules"]
[]
[null,{"$f":"CONCATENATE(\"Names of Parties:  \", LEFT('CS Worksheet'!$B$5,100),\"    vs. \",'CS Worksheet'!$B$8)","v":"Names of Parties:      vs. "}]
[null,{"$f":"CONCATENATE(\"Submitted by:  \", 'CS Worksheet'!$F$27)","v":"Submitted by:  "},null,null,null,null,null,null,null,null,null,null,{"$f":"\"Today's date: \" & TEXT(TODAY(),\"mm/dd/yyyy\")","v":{"$error":"#VALUE!"}}]
[null,{"$f":"\"Case #: \" &  'CS Worksheet'!$K$4","v":"Case #: "},null,null,null,null,null,null,null,null,null,null,"Version 9.2"]
[]
[null,null,null,"Counties","Court",null,"Deviation Descriptions",null,null,"Version Number"]
[null,null,null,null,null,null,null,null,null,"Version 8.8"]
[null,null,null,"APPLING","JUVENILE",null,"\"Low Income Deviation\""]
[null,null,null,"ATKINSON","OSAH",null,"\"High Income Deviation\""]
[null,null,null,"BACON","STATE",null,"\"Specific Deviations\""]
[null,null,null,"BAKER","SUPERIOR",null,"\"Non-Specific Deviations\""]
[null,null,null,"BALDWIN",null,null,"\"Parenting Time Deviation\""]
[null,null,null,"BANKS",null,null,"\"Extraordinary Educational Expenses\""]
[null,null,null,"BARROW",null,null,"\"Extraordinary Medical Expenses\""]
[null,null,null,"BARTOW",null,null,"\"Special Expenses for Child Rearing\""]
[null,null,null,"BEN HILL"]
[null,null,null,"BERRIEN"]
[null,null,null,"BIBB"]
[null,null,null,"BLECKLEY"]
[null,null,null,"BRANTLEY"]
[null,null,null,"BROOKS"]
[null,null,null,"BRYAN"]
[null,null,null,"BULLOCH"]
[null,null,null,"BURKE"]
[null,null,null,"BUTTS"]
[null,null,null,"CALHOUN"]
[null,null,null,"CAMDEN"]
[null,null,null,"CANDLER"]
[null,null,null,"CARROLL"]
[null,null,null,"CATOOSA"]
[null,null,null,"CHARLTON"]
[null,null,null,"CHATHAM"]
[null,null,null,"CHATTAHOOCHEE"]
[null,null,null,"CHATTOOGA"]
[null,null,null,"CHEROKEE"]
[null,null,null,"CLARKE"]
[null,null,null,"CLAY "]
[null,null,null,"CLAYTON"]
[null,null,null,"CLINCH"]
[null,null,null,"COBB"]
[null,null,null,"COFFEE"]
[null,null,null,"COLQUITT"]
[null,null,null,"COLUMBIA"]
[null,null,null,"COOK"]
[null,null,null,"COWETA"]
[null,null,null,"CRAWFORD"]
[null,null,null,"CRISP"]
[null,null,null,"DADE"]
[null,null,null,"DAWSON"]
[null,null,null,"DECATUR"]
[null,null,null,"DEKALB"]
[null,null,null,"DODGE"]
[null,null,null,"DOOLY"]
[null,null,null,"DOUGHERTY"]
[null,null,null,"DOUGLAS"]
[null,null,null,"EARLY"]
[null,null,null,"ECHOLS"]
[null,null,null,"EFFINGHAM"]
[null,null,null,"ELBERT"]
[null,null,null,"EMANUEL"]
[null,null,null,"EVANS"]
[null,null,null,"FANNIN"]
[null,null,null,"FAYETTE"]
[null,null,null,"FLOYD"]
[null,null,null,"FORSYTH"]
[null,null,null,"FRANKLIN"]
[null,null,null,"FULTON"]
[null,null,null,"GILMER"]
[null,null,null,"GLASCOCK"]
[null,null,null,"GLYNN"]
[null,null,null,"GORDON"]
[null,null,null,"GRADY"]
[null,null,null,"GREENE"]
[null,null,null,"GWINNETT"]
[null,null,null,"HABERSHAM"]
[null,null,null,"HALL"]
[null,null,null,"HANCOCK"]
[null,null,null,"HARALSON"]
[null,null,null,"HARRIS"]
[null,null,null,"HART"]
[null,null,null,"HEARD"]
[null,null,null,"HENRY"]
[null,null,null,"HOUSTON"]
[null,null,null,"IRWIN"]
[null,null,null,"JACKSON"]
[null,null,null,"JASPER"]
[null,null,null,"JEFF DAVIS"]
[null,null,null,"JEFFERSON"]
[null,null,null,"JENKINS"]
[null,null,null,"JOHNSON"]
[null,null,null,"JONES"]
[null,null,null,"LAMAR"]
[null,null,null,"LANIER"]
[null,null,null,"LAURENS"]
[null,null,null,"LEE"]
[null,null,null,"LIBERTY"]
[null,null,null,"LINCOLN"]
[null,null,null,"LONG"]
[null,null,null,"LOWNDES"]
[null,null,null,"LUMPKIN"]
[null,null,null,"MACON"]
[null,null,null,"MADISON"]
[null,null,null,"MARION"]
[null,null,null,"MCDUFFIE"]
[null,null,null,"MCINTOSH"]
[null,null,null,"MERIWETHER"]
[null,null,null,"MILLER"]
[null,null,null,"MITCHELL"]
[null,null,null,"MONROE"]
[null,null,null,"MONTGOMERY"]
[null,null,null,"MORGAN"]
[null,null,null,"MURRAY"]
[null,null,null,"MUSCOGEE"]
[null,null,null,"NEWTON"]
[null,null,null,"OCONEE"]
[null,null,null,"OGLETHORPE"]
[null,null,null,"OTHER/UNKNOWN"]
[null,null,null,"PAULDING"]
[null,null,null,"PEACH"]
[null,null,null,"PICKENS"]
[null,null,null,"PIERCE"]
[null,null,null,"PIKE"]
[null,null,null,"POLK"]
[null,null,null,"PULASKI"]
[null,null,null,"PUTNAM"]
[null,null,null,"QUITMAN"]
[null,null,null,"RABUN"]
[null,null,null,"RANDOLPH"]
[null,null,null,"RICHMOND"]
[null,null,null,"ROCKDALE"]
[null,null,null,"SCHLEY"]
[null,null,null,"SCREVEN"]
[null,null,null,"SEMINOLE"]
[null,null,null,"SPALDING"]
[null,null,null,"STEPHENS"]
[null,null,null,"STEWART"]
[null,null,null,"SUMTER"]
[null,null,null,"TALBOT"]
[null,null,null,"TALIAFERRO"]
[null,null,null,"TATTNALL"]
[null,null,null,"TAYLOR"]
[null,null,null,"TELFAIR"]
[null,null,null,"TERRELL"]
[null,null,null,"THOMAS"]
[null,null,null,"TIFT"]
[null,null,null,"TOOMBS"]
[null,null,null,"TOWNS"]
[null,null,null,"TREUTLEN"]
[null,null,null,"TROUP"]
[null,null,null,"TURNER"]
[null,null,null,"TWIGGS"]
[null,null,null,"UNION"]
[null,null,null,"UPSON"]
[null,null,null,"WALKER"]
[null,null,null,"WALTON"]
[null,null,null,"WARE"]
[null,null,null,"WARREN"]
[null,null,null,"WASHINGTON"]
[null,null,null,"WAYNE"]
[null,null,null,"WEBSTER"]
[null,null,null,"WHEELER"]
[null,null,null,"WHITE"]
[null,null,null,"WHITFIELD"]
[null,null,null,"WILCOX"]
[null,null,null,"WILKES"]
[null,null,null,"WILKINSON"]
[null,null,null,"WORTH"]

{"sheet":"Schedule A","index":3,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,0,33,4],[34,0,34,11],[3,0,3,4],[1,4,2,4],[1,0,1,1],[4,0,4,4],[0,0,0,1],[29,0,29,4],[30,0,30,3],[31,0,31,4],[32,0,32,3]]}
["* Schedule A - Gross Income  The entry of income in this section is required to generate a Worksheet.",null,"(a) Mother","(b) Father","(c) Combined"]
["If a parent receives TANF, click in box, check mark will appear; click again to remove check mark; otherwise leave blank.  Do not include monthly TANF check amount as income.",null,false,false]
[]
["Use Schedule A to enter Gross Income of each parent.  Enter amounts/data in yellow fields only.\nCalculations will automatically display in the appropriate white fields."]
["Convert all amounts to a monthly average."]
["1.","Salary and Wages (Do not include means-tested public assistance, such as TANF or food stamps.)",0,0]
["2.","Commissions, Fees, Tips",0,0]
["3.","Income From Self-Employment",0,0]
["4.","Bonuses",0,0]
["5.","Overtime Payments",0,0]
["6.","Severance Pay",0,0]
["7.","Recurring Income from Pensions or Retirement Plans",0,0]
["8.","Interest Income",0,0]
["9.","Income from Dividends",0,0]
["10.","Trust Income",0,0]
["11.","Income from Annuities",0,0]
["12.","Capital Gains",0,0]
["13.","Social Security Disability or Retirement Benefits received as income by a parent in this case. (Excludes SSI or payments for children)",0,0]
["14.","Federal Veterans' Disability Benefits",0,0]
["15.","Worker's Compensation Benefits",0,0]
["16.","Unemployment Benefits",0,0]
["17.","Judgments from Personal Injury or Other Civil Cases",0,0]
["18.","Gifts (cash or other gifts that can be converted to cash)",0,0]
["19.","Prizes / Lottery Winnings",0,0]
["20.","Alimony & maintenance from persons not in this case",0,0]
["21.","Assets which are used for support of family",0,0]
["22.","Fringe Benefits (if significantly reduce living expenses)",0,0]
["23.","Any Other Income, including Imputed Income (Do not include means-tested public assistance.)",0,0]
["24.","* TOTAL GROSS MONTHLY INCOME\nTotal will automatically display here, on Line 1 of Worksheet, and Line 1 of Schedule B.",{"$f":"SUM(C6:C28)","v":0},{"$f":"SUM(D6:D28)","v":0},{"$f":"SUM(C29:D29)","v":0}]
["Enter below explanations for the basis of Other Income, explain the basis for Other Income, including Imputed Income, as entered on Line 23 above for Mother and/or Father.\n"]
["Mother"]
[]
["Father"]
[]
[{"$f":"CONCATENATE(\"Names of Parties:  \", LEFT('CS Worksheet'!$B$5,100),\"    vs. \",'CS Worksheet'!$B$8)","v":"Names of Parties:      vs. "}]
[{"$f":"CONCATENATE(\"Submitted by:  \", 'CS Worksheet'!$F$27)","v":"Submitted by:  "},null,null,null,{"$f":"\"Today's date: \" & TEXT(TODAY(),\"mm/dd/yyyy\")","v":{"$error":"#VALUE!"}}]
[{"$f":"\"Case #: \" &  'CS Worksheet'!$K$4","v":"Case #: "},null,null,null,"Version 9.2"]

{"sheet":"Self Employment Calculator","index":4,"n_rows":56,"n_cols":5,"rows_kept":56,"cut":false,"hidden":false,"merged":[[51,1,51,4],[3,1,3,5],[11,2,11,4],[0,1,0,4],[1,1,1,4],[2,1,2,4],[36,1,36,2],[48,1,48,4]]}
[null,"Self-Employment Calculator  -  O.C.G.A. §19-6-15(f)(1)(B) states, \"Income from self-employment includes income from, but not limited to, business operations, work as an independent contractor or consultant, sales of goods or services, and rental properties, less ordinary and reasonable expenses necessary to produce such income.  Income from self-employment, rent, royalties, proprietorship of a business, or joint ownership of a partnership, limited liability company, or closely held corporation is defined as gross receipts minus ordinary and reasonable expenses required for self-employment or business operations.\""]
[]
[null,"Guidance: To calculate Self-Employment Income, you may use this Self-Employment Calculator OR you may enter Self-Employment income on Schedule A, Line 3. If you use this Self-Employment calculator, enter amounts below in yellow fields only. Calculations will automatically display in the appropriate fields.  If there is more than one owner in a business, ONLY include the self-employment income for a parent associated with this child support calculation."]
[]
[null,null,"Mother",null,"Father"]
[]
[null,"1) Description of Business"]
[]
[null,"2) Name of Business"]
[]
[null,"3) Type of Business (Sole Proprietorship, LLC, Partnership, \n                                 S Corp., Rental Income)"]
[null,null,"Business Income (per month)"]
[null,"4) Gross Receipts (A)",0,null,0]
[null,"5) Cost of Sales (B)",0,null,0]
[null,"6) Equals Gross Profit (A-B=C)",{"$f":"C13-C14","v":0},null,{"$f":"E13-E14","v":0}]
[null,"7) Business Expenses"]
[null,"7(a) Compensation to owner",0,null,0]
[null,"7(b) Other salaries and wages",0,null,0]
[null,"7(c) Advertising/promotion",0,null,0]
[null,"7(d) Car and truck expenses",0,null,0]
[null,"7(e) Depreciation",0,null,0]
[null,"7(f) Employee benefits (including medical insurance)",0,null,0]
[null,"7(g) Insurance - business",0,null,0]
[null,"7(h) Interest",0,null,0]
[null,"7(i) Office supplies and expenses",0,null,0]
[null,"7(j) Rent or lease - building",0,null,0]
[null,"7(k) Rent or lease - equipment",0,null,0]
[null,"7(l) Taxes and licenses (including payroll taxes)",0,null,0]
[null,"7(m) Travel and entertainment",0,null,0]
[null,"7(n) Utilities",0,null,0]
[null,"7(o) Other - ",0,null,0]
[null,"7(p) Other - ",0,null,0]
[null,"7(q) Other - ",0,null,0]
[]
[null,"8) Total Business Expenses (D)",{"$f":"SUM(C17:C33)","v":0},null,{"$f":"SUM(E17:E33)","v":0}]
[null,"9) Net Income  (C - D = E)",{"$f":"C15-C35","v":0},null,{"$f":"E15-E35","v":0}]
[null,"10) Add back expenses included above that are not deductible for child support.\n     See O.C.G.A.§19-6-15(f)(1)(B)."]
[null,"Compensation to owner (Do not include this amount on Line 1 of Schedule A as it is included here with self-employment income.)",{"$f":"C17","v":0},null,{"$f":"E17","v":0}]
[null,"Excessive promotional, travel, vehicle or personal living expenses",0,null,0]
[null,"Home office expenses",0,null,0]
[null,"Equipment depreciation, accelerated depreciation, tax credits",0,null,0]
[null,"Other - ",0,null,0]
[]
[null,"11) Total Non-Deductible Expenses (F)",{"$f":"SUM(C38:C42)","v":0},null,{"$f":"SUM(E38:E42)","v":0}]
[null,"12) Total Self-Employment Income (E + F)       ",{"$f":"C36+C44","v":0},null,{"$f":"E36+E44","v":0}]
[]
[null,"13) To continue, click box at right; \nanswers display on Schedule A, Line 3.",{"$f":"IF(C13>0,IF(C45>0,C45,0),0)","v":0},null,{"$f":"IF(E13>0,IF(E45>0,E45,0),0)","v":0}]
[]
[null,"Answer(s) from the Self-employment Calculator will display on Schedule A, Line 3 as a positive number for a profit, or as a zero for a loss."]
[]
[null,"Use the box below to enter notes related to self employment income as indicated above."]
[]
[]
[null,{"$f":"CONCATENATE(\"Names of Parties:  \", LEFT('CS Worksheet'!$B$5,100),\"    vs. \",'CS Worksheet'!$B$8)","v":"Names of Parties:      vs. "}]
[null,{"$f":"CONCATENATE(\"Submitted by:  \", 'CS Worksheet'!$F$27)","v":"Submitted by:  "},null,null,{"$f":"\"Today's Date: \" & TEXT(TODAY(),\"mm/dd/yyyy\")","v":{"$error":"#VALUE!"}}]
[null,{"$f":"\"Case #: \" &  'CS Worksheet'!$K$4","v":"Case #: "},null,null,"Version 9.2"]

{"sheet":"Schedule B","index":5,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[[30,1,30,6],[27,0,27,6],[1,1,1,4],[2,0,2,6],[3,1,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,4],[29,0,29,6],[32,1,32,6],[33,1,33,6],[31,1,31,6],[39,1,39,3],[38,1,38,3],[34,1,34,6],[35,0,35,6],[42,1,42,3],[45,0,45,6],[41,1,41,3],[36,0,42,0],[40,1,40,3],[36,1,36,3],[37,1,37,3],[53,1,53,4],[43,1,43,3],[50,1,50,4],[51,1,51,4],[52,1,52,4],[48,0,48,6],[44,0,44,6],[46,0,46,6],[47,0,47,6],[0,0,0,4],[26,0,26,6],[9,0,9,6],[28,0,28,6],[25,0,25,6],[23,1,23,5],[24,1,24,5],[7,1,7,4],[8,0,8,5]]}
["Schedule B-Adjusted Income  -  Enter amounts/data in yellow fields only.  Calculations will automatically display in the appropriate white fields.",null,null,null,null,"(a) Mother","(b)Father"]
["1.","Total Gross Monthly Income from Schedule A, Line 24",null,null,null,{"$f":"'Schedule A'!C29","v":0},{"$f":"'Schedule A'!D29","v":0}]
["Self Employment Tax Adjustment"]
["2.","Enter monthly Self-Employment Income on which parent paid Self-Employment Taxes for FICA & Medicare",null,null,null,0,0]
["3.","FICA (Line 2 multiplied by .062)",null,null,null,{"$f":"tround(IF(F4*0.062>612.25,612.25,F4*0.062))","v":0},{"$f":"tround(IF(G4*0.062>612.25,612.25,G4*0.062))","v":0}]
["4.","Medicare tax (Line 2 multiplied by 0.0145)",null,null,null,{"$f":"tround(F4*0.0145)","v":0},{"$f":"tround(G4*0.0145)","v":0}]
["5.","Total of Lines 3 & 4",null,null,null,{"$f":"SUM(F5:F6)","v":0},{"$f":"SUM(G5:G6)","v":0}]
["6.","Line 5 subtracted from Line 1",null,null,null,{"$f":"IF(F2-F7<0,0,F2-F7)","v":0},{"$f":"IF(G2-G7<0,0,G2-G7)","v":0}]
["Adjustment for Preexisting Child Support Orders Being Paid for Other Children"]
["Enter the required information and the amount actually paid monthly. (Do not include arrears payments.)  "]
[null,"Court Name","Court Case #","Child Name","Birth Year","Date of Initial Order","Preexisting Child Support Amount Paid by Mother","Preexisting Child Support Amount Paid by Father"]
["7(a)",null,null,null,null,null,0,0]
[]
[]
["7(b)",null,null,null,null,null,0,0]
[]
[]
["7(c)",null,null,null,null,null,0,0]
[]
[]
["7(d)",null,null,null,null,null,0,0]
[]
[]
["8.","Total Adjustment for Preexisting Child Support Orders for each parent",null,null,null,null,{"$f":"SUM(G12:G23)","v":0},{"$f":"SUM(H12:H23)","v":0}]
["9.","Line 8 is subtracted from Line 6.  If a discretionary adjustment is being claimed for other qualified children living in the home, continue at Line 10; otherwise, the answer on Line 9 will automatically display on Line 2 of the Child Support Worksheet.",null,null,null,null,{"$f":"IF(F8-G24<0,0,F8-G24)","v":0},{"$f":"IF(G8-H24<0,0,G8-H24)","v":0}]
["Discretionary Adjustment to Income for Other Qualified Children Living in Parent's Home"]
["The Court has the discretion to consider an Adjustment to Income for qualified children under this section for the purpose of reducing a parent’s gross income, if failure to consider an adjustment would cause substantial hardship to the parent."]
[]
["If the Court considers an Adjustment to Income under this section, then the Court must also consider whether this Adjustment to Income is in the best interest of the child(ren) in this action "]
["Adjustment may be considered only for children who meet ALL FIVE of the following requirements:"]
["A.","The parent is legally responsible for the qualified child (Stepchildren do not qualify);"]
["B.","The qualified child lives in the parent's home;"]
["C.","The parent is actually supporting the qualified child;"]
["D.","The qualified child is not subject to a preexisting child support order; and"]
["E.","The qualified child is not currently before the court to set, modify or enforce child support."]
["Adjustment for other QUALIFIED children pursuant to the five factors listed above"]
["10.","Name(s)",null,null,"Birth Year","Enter Checkmark if Mother is Claiming Credit","Enter Checkmark if Father is Claiming Credit"]
[null,null,null,null,null,false,false]
[null,null,null,null,null,false,false]
[null,null,null,null,null,false,false]
[null,null,null,null,null,false,false]
[null,null,null,null,null,false,false]
[null,null,null,null,null,false,false]
["10(a).","Click the checkbox until a check mark appears to include QUALIFIED children for whom adjustment is claimed, and automatic calculation will display.  ",null,null,false,{"$f":"IF($E$44=TRUE,COUNTIF(F38:F43,TRUE),0)","v":0},{"$f":"IF($E$44=TRUE,COUNTIF(G38:G43,TRUE),0)","v":0}]
["Enter a comment here explaining why you have included an Other Qualified Child in the Current Court Case.\n"]
["Mother"]
[]
["Father"]
[]
[null,null,null,null,null,"(a) Mother","(b)Father"]
["11.","Amount from Line 6 for the parent(s) seeking adjustment and a Theoretical child support order.",null,null,null,{"$f":"IF(F44>0,F8,0)","v":0},{"$f":"IF(G44>0,G8,0)","v":0}]
["12.","Basic Child Support Obligation (from table) automatically displays for  number of children on Line 10 and income on Line 11, for parent seeking the adjustment.",null,null,null,{"$f":"IF(E44=TRUE,IF(F51<800,VLOOKUP(800,BCSO!A10:H594,IF(2+F44>8,8,F44+2),TRUE),IF(F51>30000,VLOOKUP(30000,BCSO!A10:H594,IF(2+F44>8,8,F44+2),TRUE),VLOOKUP(broundTO(F51),BCSO!A10:H594,IF(2+F44>8,8,F44+2),TRUE))),0)","v":0},{"$f":"IF(E44=TRUE,IF(G51<800,VLOOKUP(800,BCSO!A10:H594,IF(2+G44>8,8,G44+2),TRUE),IF(G51>30000,VLOOKUP(30000,BCSO!A10:H594,IF(2+G44>8,8,G44+2),TRUE),VLOOKUP(broundTO(G51),BCSO!A10:H594,IF(2+G44>8,8,G44+2),TRUE))),0)","v":0}]
["13.","75% of the amount on Line 12 for the parent seeking the adjustment.",null,null,null,{"$f":"IF(F52>0,F52*0.75,0)","v":0},{"$f":"IF(G52>0,G52*0.75,0)","v":0}]
["14.","If this adjustment is allowed, Line 13 will be subtracted from Line 9 and this amount will automatically display on Line 2 of the Worksheet.",null,null,null,{"$f":"IF(F44>0,IF(F53>G25,0,G25-F53),0)","v":0},{"$f":"IF(G44>0,IF(G53>H25,0,H25-G53),0)","v":0}]
[{"$f":"CONCATENATE(\"Names of Parties:  \", LEFT('CS Worksheet'!$B$5,85),\"    vs. \",'CS Worksheet'!$B$8)","v":"Names of Parties:      vs. "}]
[{"$f":"CONCATENATE(\"Submitted by:  \", 'CS Worksheet'!$F$27)","v":"Submitted by:  "},null,null,null,null,null,null,{"$f":"\"Today's date: \" & TEXT(TODAY(),\"mm/dd/yyyy\")","v":{"$error":"#VALUE!"}}]
[{"$f":"\"Case #: \" &  'CS Worksheet'!$K$4","v":"Case #: "},null,null,null,null,null,null,"Version 9.2"]

{"sheet":"Schedule C","index":6,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,40,14]]}
["Schedule C is not in use and is intentionally left blank"]

{"sheet":"Schedule D","index":7,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,1],[7,0,7,5],[11,0,11,1],[18,0,18,1],[8,1,9,1],[8,0,9,0]]}
["Schedule D-Additional Expenses  -  Enter amounts/data in yellow fields only.  Calculations will automatically display in the appropriate white fields on this schedule.",null,"(a) Mother","(b)Father","(c) Nonparent Custodian","(d) Combined"]
["1.","Child Care Expenses necessary for parent's employment, education or vocational training.  Monthly average amount paid by each Parent (or Nonparent Custodian) for child care for the children for whom support is being determined from all Supplemental Tables from Lines 7, 13 and 19.",{"$f":"SROUND(SUM(F17,'Schedule D Supplemental Tables'!F9,'Schedule D Supplemental Tables'!F37,'Schedule D Supplemental Tables'!F66))","v":0},{"$f":"SROUND(SUM(F24,'Schedule D Supplemental Tables'!F16,'Schedule D Supplemental Tables'!F44,'Schedule D Supplemental Tables'!F73))","v":0},{"$f":"SROUND(SUM(F31,'Schedule D Supplemental Tables'!F23,'Schedule D Supplemental Tables'!F51,'Schedule D Supplemental Tables'!F80))","v":0},{"$f":"SUM(C2:E2)","v":0}]
["2.","Health Insurance Premiums Paid for the Children\nEnter monthly amount paid or will be paid by each parent or Nonparent Custodian for health insurance.  (If portion is unknown, prorate for children by dividing total premium by number of persons covered then multiply by number of covered children in this action.)",0,0,0,{"$f":"SUM(C3:E3)","v":0}]
[null,"Enter monthly amount paid or will be paid by each parent or Nonparent Custodian for health insurance.  (If portion is unknown, prorate for children by dividing total premium by number of persons covered then multiply by number of covered children in this action.)"]
["3.","Total Monthly Additional Expenses (Line 1 plus Line 2)",{"$f":"SUM(C2:C4)","v":0},{"$f":"SUM(D2:D4)","v":0},{"$f":"SUM(E2:E4)","v":0},{"$f":"SUM(F2:F4)","v":0}]
["4.","Pro Rata Share of Parents' Income (from Child Support Worksheet Line 3)",{"$f":"(CROUND(IF('CS Worksheet'!K31>0,IF(SUM('CS Worksheet'!K31:L31)<800,('CS Worksheet'!K31/(SUM('CS Worksheet'!K31:L31))),'CS Worksheet'!K31/'CS Worksheet'!M31),0)))","v":0},{"$f":"(CROUND(IF('CS Worksheet'!L31>0,IF(SUM('CS Worksheet'!K31:L31)<800,('CS Worksheet'!L31/(SUM('CS Worksheet'!K31:L31))),'CS Worksheet'!L31/'CS Worksheet'!M31))))","v":0},null,{"$f":"SUM(C6:D6)","v":0}]
["5.","Pro Rata Share of Additional Expenses.  Amount in Column (d) of Line 3 is multiplied by percentages on Line 4.  Results automatically display on Line 6 of Worksheet.",{"$f":"CROUND(F5*(CROUND(IF('CS Worksheet'!K31>0,IF(SUM('CS Worksheet'!K31:L31)<800,('CS Worksheet'!K31/(SUM('CS Worksheet'!K31:L31))),'CS Worksheet'!K31/'CS Worksheet'!M31),0))))","v":0},{"$f":"(F5)-C7","v":0},null,{"$f":"SUM(C7:D7)","v":0}]
["Supplemental Table 1.  Use this table to calculate amounts for line 1 Schedule D, children 1, 2 and 3.\nFor additional children use Supplemental Table 2, 3, and/or 4."]
["1.","Children's Names →\n(Names will automatically display)"]
[null,null,"Child 1","Child 2","Child 3"]
[" ","Indicate if child is included in child support calculation"," "," "," "]
["Child Care Paid by Mother ",null,{"$f":"CONCATENATE('CS Worksheet'!$D$18)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$D$19)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$D$20)","v":""},"Totals"]
["2.","Total yearly amount during school year",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,C13)+SUMIF('CS Worksheet'!$C$19,TRUE,D13)+SUMIF('CS Worksheet'!$C$20,TRUE,E13)","v":0}]
["3.","Total yearly amount during summer break",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,C14)+SUMIF('CS Worksheet'!$C$19,TRUE,D14)+SUMIF('CS Worksheet'!$C$20,TRUE,E14)","v":0}]
["4.","Total yearly amount during school breaks",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,C15)+SUMIF('CS Worksheet'!$C$19,TRUE,D15)+SUMIF('CS Worksheet'!$C$20,TRUE,E15)","v":0}]
["5.","Total yearly amount of other child care (e.g. pre-school or child with disability)",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,C16)+SUMIF('CS Worksheet'!$C$19,TRUE,D16)+SUMIF('CS Worksheet'!$C$20,TRUE,E16)","v":0}]
["6.","Total Yearly Amounts",{"$f":"IF('CS Worksheet'!$C$18=TRUE,SUM(C13:C16),0)","v":0},{"$f":"IF('CS Worksheet'!$C$19=TRUE,SUM(D13:D16),0)","v":0},{"$f":"IF('CS Worksheet'!$C$20=TRUE,SUM(E13:E16),0)","v":0},{"$f":"SUM(C17:E17)","v":0}]
["7.","Monthly Average (Divide Line 6 by 12 months)",{"$f":"SROUND(C17)","v":0},{"$f":"SROUND(D17)","v":0},{"$f":"SROUND(E17)","v":0},{"$f":"SROUND(F17)","v":0}]
["Child Care Paid by Father",null,{"$f":"CONCATENATE('CS Worksheet'!$D$18)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$D$19)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$D$20)","v":""},"Totals"]
["8.","Total yearly amount during school",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,C20)+SUMIF('CS Worksheet'!$C$19,TRUE,D20)+SUMIF('CS Worksheet'!$C$20,TRUE,E20)","v":0}]
["9.","Total yearly amount during summer break",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,C21)+SUMIF('CS Worksheet'!$C$19,TRUE,D21)+SUMIF('CS Worksheet'!$C$20,TRUE,E21)","v":0}]
["10.","Total yearly amount during other school breaks",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,C22)+SUMIF('CS Worksheet'!$C$19,TRUE,D22)+SUMIF('CS Worksheet'!$C$20,TRUE,E22)","v":0}]
["11.","Total yearly amount of other child care (e.g. pre-school or child with disability)",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,C23)+SUMIF('CS Worksheet'!$C$19,TRUE,D23)+SUMIF('CS Worksheet'!$C$20,TRUE,E23)","v":0}]
["12.","Total Yearly Amounts",{"$f":"IF('CS Worksheet'!$C$18=TRUE,SUM(C20:C23),0)","v":0},{"$f":"IF('CS Worksheet'!$C$19=TRUE,SUM(D20:D23),0)","v":0},{"$f":"IF('CS Worksheet'!$C$20=TRUE,SUM(E20:E23),0)","v":0},{"$f":"SUM(C24:E24)","v":0}]
["13.","Monthly Average (Divide Line 12 by 12 months)",{"$f":"SROUND(C24)","v":0},{"$f":"SROUND(D24)","v":0},{"$f":"SROUND(E24)","v":0},{"$f":"SROUND(F24)","v":0},0]
["Child Care Paid by Nonparent Custodian",null,{"$f":"CONCATENATE('CS Worksheet'!$D$18)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$D$19)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$D$20)","v":""},"Totals"]
["14.","Total yearly amount during school",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,C27)+SUMIF('CS Worksheet'!$C$19,TRUE,D27)+SUMIF('CS Worksheet'!$C$20,TRUE,E27)","v":0}]
["15.","Total yearly amount summer break",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,C28)+SUMIF('CS Worksheet'!$C$19,TRUE,D28)+SUMIF('CS Worksheet'!$C$20,TRUE,E28)","v":0}]
["16.","Total yearly amount during other school breaks",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,C29)+SUMIF('CS Worksheet'!$C$19,TRUE,D29)+SUMIF('CS Worksheet'!$C$20,TRUE,E29)","v":0}]
["17.","Total yearly amount of other child care (e.g. pre-school or child with disability)",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,C30)+SUMIF('CS Worksheet'!$C$19,TRUE,D30)+SUMIF('CS Worksheet'!$C$20,TRUE,E30)","v":0}]
["18.","Total Yearly Amounts",{"$f":"IF('CS Worksheet'!$C$18=TRUE,SUM(C27:C30),0)","v":0},{"$f":"IF('CS Worksheet'!$C$19=TRUE,SUM(D27:D30),0)","v":0},{"$f":"IF('CS Worksheet'!$C$20=TRUE,SUM(E27:E30),0)","v":0},{"$f":"SUM(C31:E31)","v":0}]
["19.","Monthly Average (Divide Line 18 by 12 months)",{"$f":"SROUND(C31)","v":0},{"$f":"SROUND(D31)","v":0},{"$f":"SROUND(E31)","v":0},{"$f":"SROUND(F31)","v":0}]
[" ","Monthly Average to Include in Calc",{"$f":"IF(C$11=\"N\",0,C32)","v":0},{"$f":"IF(D$11=\"N\",0,D32)","v":0},{"$f":"IF(E$11=\"N\",0,E32)","v":0},{"$f":"SUM(C33:E33)","v":0}]
[{"$f":"CONCATENATE(\"Names of Parties:  \", LEFT('CS Worksheet'!$B$5,100),\"    vs. \",'CS Worksheet'!$B$8)","v":"Names of Parties:      vs. "}]
[{"$f":"CONCATENATE(\"Submitted by:  \", 'CS Worksheet'!$F$27)","v":"Submitted by:  "},null,null,null,null,{"$f":"\"Today's date: \" & TEXT(TODAY(),\"mm/dd/yyyy\")","v":{"$error":"#VALUE!"}},null,{"$f":"\"Today's date: \" & TEXT(TODAY(),\"mm/dd/yyyy\")","v":{"$error":"#VALUE!"}}]
[{"$f":"\"Case #: \" &  'CS Worksheet'!$K$4","v":"Case #: "},null,null,null,null,"Version 9.2"]

{"sheet":"Schedule D Supplemental Tables","index":8,"n_rows":85,"n_cols":6,"rows_kept":85,"cut":false,"hidden":false,"merged":[[57,0,57,5],[58,1,59,1],[58,0,59,0],[0,0,0,5],[28,0,28,5],[1,0,2,0],[1,1,2,1],[29,1,30,1],[29,0,30,0]]}
["Schedule D-Additional Expenses-Supplemental Table 2.  Use this table to calculate amounts for Line 1 Schedule D, children 4, 5 and 6.\nFor additional children use Supplemental Tables 3 and/or 4.\nEnter amounts/data in yellow fields only.  Calculations will automatically display in the appropriate white fields."]
["1.","Children's Names →\n(Names will automatically display)"]
[null,null,"Child 4","Child 5","Child 6"]
["Child Care Paid by Mother ",null,{"$f":"CONCATENATE('CS Worksheet'!$D$21)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$D$22)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$D$23)","v":""},"Totals"]
["2.","Total yearly amount during school",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,C5)+SUMIF('CS Worksheet'!$C$22,TRUE,D5)+SUMIF('CS Worksheet'!$C$23,TRUE,E5)","v":0}]
["3.","Total yearly amount during summer break",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,C6)+SUMIF('CS Worksheet'!$C$22,TRUE,D6)+SUMIF('CS Worksheet'!$C$23,TRUE,E6)","v":0}]
["4.","Total yearly amount during other school breaks",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,C7)+SUMIF('CS Worksheet'!$C$22,TRUE,D7)+SUMIF('CS Worksheet'!$C$23,TRUE,E7)","v":0}]
["5.","Total yearly amount of other child care (e.g. pre-school or child with disability)",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,C8)+SUMIF('CS Worksheet'!$C$22,TRUE,D8)+SUMIF('CS Worksheet'!$C$23,TRUE,E8)","v":0}]
["6.","Total Yearly Amounts",{"$f":"IF('CS Worksheet'!$C$21=TRUE,SUM(C5:C8),0)","v":0},{"$f":"IF('CS Worksheet'!$C$22=TRUE,SUM(D5:D8),0)","v":0},{"$f":"IF('CS Worksheet'!$C$23=TRUE,SUM(E5:E8),0)","v":0},{"$f":"SUM(C9:E9)","v":0}]
["7.","Monthly Average (Divide Line 6 by 12 months)",{"$f":"SROUND(C9)","v":0},{"$f":"SROUND(D9)","v":0},{"$f":"SROUND(E9)","v":0},{"$f":"SROUND(F9)","v":0}]
["Child Care Paid by Father",null,{"$f":"CONCATENATE('CS Worksheet'!$D$21)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$D$22)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$D$23)","v":""},"Totals"]
["8.","Total yearly amount during school",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,C12)+SUMIF('CS Worksheet'!$C$22,TRUE,D12)+SUMIF('CS Worksheet'!$C$23,TRUE,E12)","v":0}]
["9.","Total yearly amount during summer break",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,C13)+SUMIF('CS Worksheet'!$C$22,TRUE,D13)+SUMIF('CS Worksheet'!$C$23,TRUE,E13)","v":0}]
["10.","Total yearly amount during other school breaks",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,C14)+SUMIF('CS Worksheet'!$C$22,TRUE,D14)+SUMIF('CS Worksheet'!$C$23,TRUE,E14)","v":0}]
["11.","Total yearly amount of other child care (e.g. pre-school or child with disability)",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,C15)+SUMIF('CS Worksheet'!$C$22,TRUE,D15)+SUMIF('CS Worksheet'!$C$23,TRUE,E15)","v":0}]
["12.","Total Yearly Amounts",{"$f":"IF('CS Worksheet'!$C$21=TRUE,SUM(C12:C15),0)","v":0},{"$f":"IF('CS Worksheet'!$C$22=TRUE,SUM(D12:D15),0)","v":0},{"$f":"IF('CS Worksheet'!$C$23=TRUE,SUM(E12:E15),0)","v":0},{"$f":"SUM(C16:E16)","v":0}]
["13.","Monthly Average (Divide Line 12 by 12 months)",{"$f":"SROUND(C16)","v":0},{"$f":"SROUND(D16)","v":0},{"$f":"SROUND(E16)","v":0},{"$f":"SROUND(F16)","v":0}]
["Child Care Paid by Nonparent Custodian",null,{"$f":"CONCATENATE('CS Worksheet'!$D$21)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$D$22)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$D$23)","v":""},"Totals"]
["14.","Total yearly amount during school",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,C19)+SUMIF('CS Worksheet'!$C$22,TRUE,D19)+SUMIF('CS Worksheet'!$C$23,TRUE,E19)","v":0}]
["15.","Total yearly amount during summer break",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,C20)+SUMIF('CS Worksheet'!$C$22,TRUE,D20)+SUMIF('CS Worksheet'!$C$23,TRUE,E20)","v":0}]
["16.","Total yearly amount during other school breaks",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,C21)+SUMIF('CS Worksheet'!$C$22,TRUE,D21)+SUMIF('CS Worksheet'!$C$23,TRUE,E21)","v":0}]
["17.","Total yearly amount of other child care (e.g. pre-school or child with disability)",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,C22)+SUMIF('CS Worksheet'!$C$22,TRUE,D22)+SUMIF('CS Worksheet'!$C$23,TRUE,E22)","v":0}]
["18.","Total Yearly Amounts",{"$f":"IF('CS Worksheet'!$C$21=TRUE,SUM(C19:C22),0)","v":0},{"$f":"IF('CS Worksheet'!$C$22=TRUE,SUM(D19:D22),0)","v":0},{"$f":"IF('CS Worksheet'!$C$23=TRUE,SUM(E19:E22),0)","v":0},{"$f":"SUM(C23:E23)","v":0}]
["19.","Monthly Average (Divide Line 18 by 12 months)",{"$f":"SROUND(C23)","v":0},{"$f":"SROUND(D23)","v":0},{"$f":"SROUND(E23)","v":0},{"$f":"SROUND(F23)","v":0}]
[]
[{"$f":"CONCATENATE(\"Names of Parties:  \", LEFT('CS Worksheet'!$B$5,100),\"    vs. \",'CS Worksheet'!$B$8)","v":"Names of Parties:      vs. "}]
[{"$f":"CONCATENATE(\"Submitted by:  \", 'CS Worksheet'!$F$27)","v":"Submitted by:  "},null,null,null,null,{"$f":"\"Today's date: \" & TEXT(TODAY(),\"mm/dd/yyyy\")","v":{"$error":"#VALUE!"}}]
[{"$f":"\"Case #: \" &  'CS Worksheet'!$K$4","v":"Case #: "},null,null,null,null,"Version 9.2"]
["Schedule D-Additional Expenses-Supplemental Table 3.  Use this table to calculate amounts for line 1 Schedule D, children 7, 8 and 9.\nFor additional children use Supplemental Table 4.\nEnter amounts/data in yellow fields only.  Calculations will automatically display in the appropriate white fields."]
["1.","Children's Names →\n(Names will automatically display)"]
[null,null,"Child 7","Child 8","Child 9"]
["Child Care Paid by Mother ",null,{"$f":"CONCATENATE('CS Worksheet'!$J$18)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$J$19)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$J$20)","v":""},"Totals"]
["2.","Total yearly amount during school",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,C33)+SUMIF('CS Worksheet'!$I$19,TRUE,D33)+SUMIF('CS Worksheet'!$I$20,TRUE,E33)","v":0}]
["3.","Total yearly amount during summer break",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,C34)+SUMIF('CS Worksheet'!$I$19,TRUE,D34)+SUMIF('CS Worksheet'!$I$20,TRUE,E34)","v":0}]
["4.","Total yearly amount during other school breaks",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,C35)+SUMIF('CS Worksheet'!$I$19,TRUE,D35)+SUMIF('CS Worksheet'!$I$20,TRUE,E35)","v":0}]
["5.","Total yearly amount of other child care (e.g. pre-school or child with disability)",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,C36)+SUMIF('CS Worksheet'!$I$19,TRUE,D36)+SUMIF('CS Worksheet'!$I$20,TRUE,E36)","v":0}]
["6.","Total Yearly Amounts",{"$f":"IF('CS Worksheet'!$I$18=TRUE,SUM(C33:C36),0)","v":0},{"$f":"IF('CS Worksheet'!$I$19=TRUE,SUM(D33:D36),0)","v":0},{"$f":"IF('CS Worksheet'!$I$20=TRUE,SUM(E33:E36),0)","v":0},{"$f":"SUM(C37:E37)","v":0}]
["7.","Monthly Average (Divide Line 6 by 12 months)",{"$f":"SROUND(C37)","v":0},{"$f":"SROUND(D37)","v":0},{"$f":"SROUND(E37)","v":0},{"$f":"SROUND(F37)","v":0}]
["Child Care Paid by Father",null,{"$f":"CONCATENATE('CS Worksheet'!$J$18)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$J$19)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$J$20)","v":""},"Totals"]
["8.","Total yearly amount during school",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,C40)+SUMIF('CS Worksheet'!$I$19,TRUE,D40)+SUMIF('CS Worksheet'!$I$20,TRUE,E40)","v":0}]
["9.","Total yearly amount during summer break",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,C41)+SUMIF('CS Worksheet'!$I$19,TRUE,D41)+SUMIF('CS Worksheet'!$I$20,TRUE,E41)","v":0}]
["10.","Total yearly amount during other school breaks",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,C42)+SUMIF('CS Worksheet'!$I$19,TRUE,D42)+SUMIF('CS Worksheet'!$I$20,TRUE,E42)","v":0}]
["11.","Total yearly amount of other child care (e.g. pre-school or child with disability)",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,C43)+SUMIF('CS Worksheet'!$I$19,TRUE,D43)+SUMIF('CS Worksheet'!$I$20,TRUE,E43)","v":0}]
["12.","Total Yearly Amounts",{"$f":"IF('CS Worksheet'!$I$18=TRUE,SUM(C40:C43),0)","v":0},{"$f":"IF('CS Worksheet'!$I$19=TRUE,SUM(D40:D43),0)","v":0},{"$f":"IF('CS Worksheet'!$I$20=TRUE,SUM(E40:E43),0)","v":0},{"$f":"SUM(C44:E44)","v":0}]
["13.","Monthly Average (Divide Line 12 by 12 months)",{"$f":"SROUND(C44)","v":0},{"$f":"SROUND(D44)","v":0},{"$f":"SROUND(E44)","v":0},{"$f":"SROUND(F44)","v":0}]
["Child Care Paid by Nonparent Custodian",null,{"$f":"CONCATENATE('CS Worksheet'!$J$18)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$J$19)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$J$20)","v":""},"Totals"]
["14.","Total yearly amount during school",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,C47)+SUMIF('CS Worksheet'!$I$19,TRUE,D47)+SUMIF('CS Worksheet'!$I$20,TRUE,E47)","v":0}]
["15.","Total yearly amount during summer break",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,C48)+SUMIF('CS Worksheet'!$I$19,TRUE,D48)+SUMIF('CS Worksheet'!$I$20,TRUE,E48)","v":0}]
["16.","Total yearly amount during other school breaks",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,C49)+SUMIF('CS Worksheet'!$I$19,TRUE,D49)+SUMIF('CS Worksheet'!$I$20,TRUE,E49)","v":0}]
["17.","Total yearly amount of other child care (e.g. pre-school or child with disability)",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,C50)+SUMIF('CS Worksheet'!$I$19,TRUE,D50)+SUMIF('CS Worksheet'!$I$20,TRUE,E50)","v":0}]
["18.","Total Yearly Amounts",{"$f":"IF('CS Worksheet'!$I$18=TRUE,SUM(C47:C50),0)","v":0},{"$f":"IF('CS Worksheet'!$I$19=TRUE,SUM(D47:D50),0)","v":0},{"$f":"IF('CS Worksheet'!$I$20=TRUE,SUM(E47:E50),0)","v":0},{"$f":"SUM(C51:E51)","v":0}]
["19.","Monthly Average (Divide Line 18 by 12 months)",{"$f":"SROUND(C51)","v":0},{"$f":"SROUND(D51)","v":0},{"$f":"SROUND(E51)","v":0},{"$f":"SROUND(F51)","v":0}]
[]
[{"$f":"CONCATENATE(\"Names of Parties:  \", LEFT('CS Worksheet'!$B$5,100),\"    vs. \",'CS Worksheet'!$B$8)","v":"Names of Parties:      vs. "}]
[{"$f":"CONCATENATE(\"Submitted by:  \", 'CS Worksheet'!$F$27)","v":"Submitted by:  "},null,null,null,null,{"$f":"\"Today's date: \" & TEXT(TODAY(),\"mm/dd/yyyy\")","v":{"$error":"#VALUE!"}}]
[{"$f":"\"Case #: \" &  'CS Worksheet'!$K$4","v":"Case #: "},null,null,null,null,"Version 9.2"]
[]
["Schedule D-Additional Expenses-Supplemental Table 4.  Use this table to calculate amounts for line 1 Schedule D, children 10, 11 and 12.\nEnter amounts/data in yellow fields only.  Calculations will automatically display in the appropriate white fields."]
["1.","Children's Names →\n(Names will automatically display)"]
[null,null,"Child 10","Child 11","Child 12"]
["Child Care Paid by Mother ",null,{"$f":"CONCATENATE('CS Worksheet'!$J$21)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$J$22)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$J$23)","v":""},"Totals"]
["2.","Total yearly amount during school",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,C62)+SUMIF('CS Worksheet'!$I$22,TRUE,D62)+SUMIF('CS Worksheet'!$I$23,TRUE,E62)","v":0}]
["3.","Total yearly amount during summer break",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,C63)+SUMIF('CS Worksheet'!$I$22,TRUE,D63)+SUMIF('CS Worksheet'!$I$23,TRUE,E63)","v":0}]
["4.","Total yearly amount during other school breaks",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,C64)+SUMIF('CS Worksheet'!$I$22,TRUE,D64)+SUMIF('CS Worksheet'!$I$23,TRUE,E64)","v":0}]
["5.","Total yearly amount of other child care (e.g. pre-school or child with disability)",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,C65)+SUMIF('CS Worksheet'!$I$22,TRUE,D65)+SUMIF('CS Worksheet'!$I$23,TRUE,E65)","v":0}]
["6.","Total Yearly Amounts",{"$f":"IF('CS Worksheet'!$I$21=TRUE,SUM(C62:C65),0)","v":0},{"$f":"IF('CS Worksheet'!$I$22=TRUE,SUM(D62:D65),0)","v":0},{"$f":"IF('CS Worksheet'!$I$23=TRUE,SUM(E62:E65),0)","v":0},{"$f":"SUM(C66:E66)","v":0}]
["7.","Monthly Average (Divide Line 6 by 12 months)",{"$f":"SROUND(C66)","v":0},{"$f":"SROUND(D66)","v":0},{"$f":"SROUND(E66)","v":0},{"$f":"SROUND(F66)","v":0}]
["Child Care Paid by Father",null,{"$f":"CONCATENATE('CS Worksheet'!$J$21)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$J$22)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$J$23)","v":""},"Totals"]
["8.","Total yearly amount during school",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,C69)+SUMIF('CS Worksheet'!$I$22,TRUE,D69)+SUMIF('CS Worksheet'!$I$23,TRUE,E69)","v":0}]
["9.","Total yearly amount during summer break",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,C70)+SUMIF('CS Worksheet'!$I$22,TRUE,D70)+SUMIF('CS Worksheet'!$I$23,TRUE,E70)","v":0}]
["10.","Total yearly amount during other school breaks",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,C71)+SUMIF('CS Worksheet'!$I$22,TRUE,D71)+SUMIF('CS Worksheet'!$I$23,TRUE,E71)","v":0}]
["11.","Total yearly amount of other child care (e.g. pre-school or child with disability)",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,C72)+SUMIF('CS Worksheet'!$I$22,TRUE,D72)+SUMIF('CS Worksheet'!$I$23,TRUE,E72)","v":0}]
["12.","Total Yearly Amounts",{"$f":"IF('CS Worksheet'!$I$21=TRUE,SUM(C69:C72),0)","v":0},{"$f":"IF('CS Worksheet'!$I$22=TRUE,SUM(D69:D72),0)","v":0},{"$f":"IF('CS Worksheet'!$I$23=TRUE,SUM(E69:E72),0)","v":0},{"$f":"SUM(C73:E73)","v":0}]
["13.","Monthly Average (Divide Line 12 by 12 months)",{"$f":"SROUND(C73)","v":0},{"$f":"SROUND(D73)","v":0},{"$f":"SROUND(E73)","v":0},{"$f":"SROUND(F73)","v":0}]
["Child Care Paid by Nonparent Custodian",null,{"$f":"CONCATENATE('CS Worksheet'!$J$21)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$J$22)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$J$23)","v":""},"Totals"]
["14.","Total yearly amount during school",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,C76)+SUMIF('CS Worksheet'!$I$22,TRUE,D76)+SUMIF('CS Worksheet'!$I$23,TRUE,E76)","v":0}]
["15.","Total yearly amount during summer break",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,C77)+SUMIF('CS Worksheet'!$I$22,TRUE,D77)+SUMIF('CS Worksheet'!$I$23,TRUE,E77)","v":0}]
["16.","Total yearly amount during other school breaks",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,C78)+SUMIF('CS Worksheet'!$I$22,TRUE,D78)+SUMIF('CS Worksheet'!$I$23,TRUE,E78)","v":0}]
["17.","Total yearly amount of other child care (e.g. pre-school or child with disability)",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,C79)+SUMIF('CS Worksheet'!$I$22,TRUE,D79)+SUMIF('CS Worksheet'!$I$23,TRUE,E79)","v":0}]
["18.","Total Yearly Amounts",{"$f":"IF('CS Worksheet'!$I$21=TRUE,SUM(C76:C79),0)","v":0},{"$f":"IF('CS Worksheet'!$I$22=TRUE,SUM(D76:D79),0)","v":0},{"$f":"IF('CS Worksheet'!$I$23=TRUE,SUM(E76:E79),0)","v":0},{"$f":"SUM(C80:E80)","v":0}]
["19.","Monthly Average (Divide Line 18 by 12 months)",{"$f":"SROUND(C80)","v":0},{"$f":"SROUND(D80)","v":0},{"$f":"SROUND(E80)","v":0},{"$f":"SROUND(F80)","v":0}]
[]
[{"$f":"CONCATENATE(\"Names of Parties:  \", LEFT('CS Worksheet'!$B$5,100),\"    vs. \",'CS Worksheet'!$B$8)","v":"Names of Parties:      vs. "}]
[{"$f":"CONCATENATE(\"Submitted by:  \", 'CS Worksheet'!$F$27)","v":"Submitted by:  "},null,null,null,null,{"$f":"\"Today's date: \" & TEXT(TODAY(),\"mm/dd/yyyy\")","v":{"$error":"#VALUE!"}}]
[{"$f":"\"Case #: \" &  'CS Worksheet'!$K$4","v":"Case #: "},null,null,null,null,"Version 9.2"]

{"sheet":"Schedule E","index":9,"n_rows":100,"n_cols":13,"rows_kept":100,"cut":false,"hidden":false,"merged":[[81,9,82,9],[81,5,82,5],[77,9,78,9],[79,5,80,5],[79,9,80,9],[77,5,78,5],[69,2,69,4],[40,6,40,9],[60,2,60,4],[61,2,61,4],[68,2,68,4],[41,1,41,9],[46,1,46,9],[43,1,43,9],[45,1,45,6],[53,1,54,1],[44,2,44,4],[55,1,55,4],[64,2,64,4],[59,2,59,4],[82,2,82,4],[42,7,42,9],[42,2,42,4],[47,1,47,9],[96,2,96,4],[95,2,95,4],[94,2,94,4],[93,2,93,4],[92,2,92,4],[91,2,91,4],[88,2,88,4],[86,2,86,4],[70,2,70,4],[78,2,78,4],[76,1,76,4],[71,2,71,4],[73,2,73,4],[72,2,72,4],[90,2,90,4],[89,2,89,4],[79,2,79,4],[77,2,77,4],[80,2,80,4],[87,2,87,4],[83,2,83,4],[85,1,85,4],[81,2,81,4],[81,1,82,1],[84,2,84,4],[66,2,66,4],[75,2,75,4],[74,2,74,4],[79,1,80,1],[77,1,78,1],[56,2,56,4],[57,2,57,4],[65,2,65,4],[67,1,67,4],[58,2,58,4],[62,2,62,4],[63,2,63,4],[51,1,51,9],[53,2,54,5],[49,1,49,9],[48,1,48,9],[50,1,50,9],[52,1,52,9],[1,1,1,9],[0,1,0,9],[16,2,16,4],[34,2,34,4],[17,2,17,5],[7,2,7,4],[20,2,20,4],[22,2,22,4],[24,2,24,4],[23,2,23,4],[2,1,2,9],[6,2,6,4],[3,1,3,9],[4,1,4,6],[4,7,4,8],[5,2,5,4],[8,2,8,4],[9,2,9,4],[11,2,11,8],[18,1,19,4],[12,1,12,9],[13,1,13,9],[14,2,14,8],[15,1,15,8],[10,2,10,4],[40,1,40,5],[26,2,26,4],[29,2,29,4],[33,2,33,4],[37,2,37,4],[39,2,39,4],[35,2,35,4],[36,2,36,4],[30,2,30,4],[38,2,38,4],[25,2,25,4],[28,2,28,4],[31,1,31,4],[32,1,32,8],[18,7,18,8],[27,2,27,4],[21,2,21,4]]}
[null,"Schedule E  -  Deviations and Special Circumstances"]
[null,"A.  For each section completed, provide monthly amounts (annual amounts in certain areas) or other information as required.  Enter amounts/data in yellow fields only. Calculations will automatically display in the appropriate white fields."]
[null,"Low Income Deviation\nThe Court or Jury has discretion to allow or not allow the noncustodial parent to receive a Low Income Deviation that will reduce the Presumptive Amount of Child Support.  If Low Income Deviation does not apply in this case, skip this section and begin at Line 2(a) of this Schedule."]
[null,"Weighing Considerations Based Upon Sufficient Evidence:\nWhen considering a Low Income Deviation, please read the statute at O.C.G.A. §19-6-15(i)(2)(B) or review the User Guide for the appropriate criteria for this deviation.\nIn weighing the income sources and expenses of both parents, and taking into account each parent’s basic child support obligation as adjusted by health insurance and work related child care costs –\n\n> Can the noncustodial parent provide evidence sufficient to demonstrate no earning capacity?  Or, does his/her pro rata share of the presumptive amount of child support create an extreme economic hardship for such parent?\n\n> What will be the relative hardship that a reduction in the amount of child support would have on the custodial parent's household? The needs of each parent? The needs of the child(ren) for whom child support is being determined? The ability of the noncustodial parent to pay child support?\n"]
[null,"NOTE:  Low Income Deviation is entered as a positive number but treated as a subtraction when included with all other deviations. By use of this deviation, court or jury is not prohibited from granting an increase or decrease to the presumptive amount of child support by use of another deviation.",null,null,null,null,null,"Court or Jury Allowable Deviations\nOnly the Court or Jury may enter an amount under column (c) or (d)."]
[null,false,"To request Low Income Deviation, click in box at left, check mark will display.  White fields in Line 1a for Noncustodial Parent will become yellow in color and allow data entry.  Uncheck box to remove request.  Continue to Line 1a.",null,null,"(a) Mother","(b) Father","*(c) Mother","*(d) Father"]
[null,"1a.","Enter \"Proposed Low Income Deviation amount\" AS A POSITIVE NUMBER under noncustodial parent's column. Amount will be used unless Line 1b applies.",null,null,0,0,0,0]
[null,"1b.",">If amount entered in Line 1a will make final child support obligation less than minimum order amount allowed when Low Income Deviation is granted, new deviation amount will display in Line 1b and used in calculations.\n>If entry in Line 1a results in amount equal to or greater than minimum order allowed, amount in Line 1a will automatically be used in the calculations.",null,null,0,0,0,0]
[]
[]
[]
[null,false,"DISCRETIONARY CHECK BOX FOR COURT OR JURY ONLY:  Use to exclude or change deviation amount that displays in Line 1b.\nEnter \"Discretionary amount allowed by Court/Jury\" AS A POSITIVE NUMBER under noncustodial parent's column. (See Bubble Box for details.)"]
[null,"Explanation for Requesting a Low Income Deviation: Write in box below any additional explanation as to why the noncustodial parent should be granted a Low Income Deviation.  (Questions at Boxes B, C and D must also be answered for this deviation.)"]
[]
[]
[null,"High Income and Other Amounts\nEnter a positive (+) or negative (-) dollar amount in the appropriate column for the noncustodial parent to increase or decrease the amount of child support.  Enter only the amount of the deviation in the noncustodial parent’s column.  Only amounts listed in the noncustodial parent’s column will affect the child support calculation."]
[]
[null,"2(a).","High Income - Combined Adjusted Income greater than $30,000/month from Child Support Worksheet, Line 2.",null,null,null,{"$f":"IF('CS Worksheet'!M31>30000,'CS Worksheet'!M31-30000,0)","v":0}]
[null,"Instructions for this section:  Enter requested deviation amounts under the noncustodial parent column as a “positive (+)” number for an upward deviation or as a “negative (-)” number for a downward deviation.  Do not enter the monthly amount of expenses in Lines 2(b)-10; enter only amount(s) you want the court to consider as a requested deviation from the Presumptive Amount of Child Support.  The Specific and Non-specific Deviation section does not represent a financial affidavit.",null,null,null,null,null,"Court or Jury Allowable Deviations"]
[null,null,null,null,null,"(a) Mother","(b) Father","*(c)Mother","*(d)Father"]
[null,"2(b).","Deviation Based on High Income",null,null,0,0,0,0]
[null,"3.","Other Health Related Insurance (dental, vision)",null,null,0,0,0,0]
[null,"4.","Life Insurance",null,null,0,0,0,0]
[null,"5.","Child and Dependent Care Tax Credit",null,null,0,0,0,0]
[null,"6.","Visitation Related Travel Expenses",null,null,0,0,0,0]
[null,"7.","Alimony PAID",null,null,0,0,0,0]
[null,"8.","Mortgage (if Noncustodial Parent is providing cost of home where child resides)",null,null,0,0,0,0]
[null,"9.","Permanency Plan or Foster Care Plan",null,null,0,0,0,0]
[null,"10.","Other - Non-specific Deviations",null,null,0,0,0,0]
[null,"11.","Deviation(s) will automatically display on this line.  This is the recommended deviation based on the amounts entered above that will total with other deviations on Line 14 of this schedule.",null,null,{"$f":"SUM(F21:F29)","v":0},{"$f":"SUM(G21:G29)","v":0},{"$f":"SUM(H21:H29)","v":0},{"$f":"SUM(I21:I29)","v":0}]
[null,false,"FOR COURT OR JURY USE ONLY:  Check this box to override amounts entered in columns (a) and (b) for Mother and Father.  Enter Court or Jury amount(s) in columns (c) and (d), which will then total with all other deviations."]
[null," ",null,null,null,"(a) Mother","(b) Father","(c) Nonparent Custodian","(d) Combined"]
[null,"Extraordinary and Special Expenses - Complete Supplemental Tables\nEnter amounts/data in yellow fields only.  Calculations will automatically display in the appropriate white fields."]
[null,"12(a).","Extraordinary Educational Expenses \n>Total amounts from Line 9(a) of each Supplemental Table for Mother.\n>Total amounts from Line 9(b) of each Supplemental Table for Father.\n>Total amounts from Line 9(c) of each Supplemental Table for Nonparent Custodian.",null,null,{"$f":"J65+'Schedule E Supplemental Tables'!I13+'Schedule E Supplemental Tables'!I50+'Schedule E Supplemental Tables'!I87","v":0},{"$f":"J66+'Schedule E Supplemental Tables'!I14+'Schedule E Supplemental Tables'!I51+'Schedule E Supplemental Tables'!I88","v":0},{"$f":"J67+'Schedule E Supplemental Tables'!I15+'Schedule E Supplemental Tables'!I52+'Schedule E Supplemental Tables'!I89","v":0},{"$f":"SUM(F34:H34)","v":0}]
[null,"12(b).","Extraordinary Medical Expenses \n>Total amounts from Line 14(a) of each Supplemental Table for Mother.\n>Total amounts from Line 14(b) of each Supplemental Table for Father.\n>Total amounts from Line 14(c) of each Supplemental Table for Nonparent Custodian.",null,null,{"$f":"J74+'Schedule E Supplemental Tables'!I22+'Schedule E Supplemental Tables'!I59+'Schedule E Supplemental Tables'!I96","v":0},{"$f":"J75+'Schedule E Supplemental Tables'!I23+'Schedule E Supplemental Tables'!I60+'Schedule E Supplemental Tables'!I97","v":0},{"$f":"J76+'Schedule E Supplemental Tables'!I24+'Schedule E Supplemental Tables'!I61+'Schedule E Supplemental Tables'!I98","v":0},{"$f":"SUM(F35:H35)","v":0}]
[null,"12(c).","Allowable Special Expenses \n>Amount from Line 28 of each Supplemental Table for Mother.\n>Amount from Line 29 of each Supplemental Table for Father.\n>Amount from Line 30 of each Supplemental Table for Nonparent Custodian.",null,null,{"$f":"J95","v":0},{"$f":"J96","v":0},{"$f":"J97","v":0},{"$f":"SUM(F36:H36)","v":0}]
[null,"12(d).","Total Extraordinary and Allowable Special Expenses.  Lines 12(a), 12(b) and 12(c) added.",null,null,{"$f":"SUM(F34:F36)","v":0},{"$f":"SUM(G34:G36)","v":0},{"$f":"SUM(H34:H36)","v":0},{"$f":"SUM(F37:H37)","v":0},null,null,{"$f":"MIN(F7,F8)","v":0},"MOTHER"]
[null,"12(e).","Parent's Pro Rata Share of Income from Child Support Worksheet, Line 3.",null,null,{"$f":"'CS Worksheet'!K34","v":0},{"$f":"'CS Worksheet'!L34","v":0},null,{"$f":"SUM(F38:G38)","v":0},null,null,{"$f":"MIN(H7,H8)","v":0},"MOTHER"]
[null,"12(f).","Parent's share of extraordinary/special expenses.  Line 12(d) multiplied by percentages for each Parent on Line 12(e).",null,null,{"$f":"tround(I37*F38)","v":0},{"$f":"(I37)-F39","v":0},null,{"$f":"SUM(F39:H39)","v":0},null,null,{"$f":"MIN(G7,G8)","v":0},"FATHER"]
[null,"12(g).","Deviation for extraordinary/special expenses.  Line 12(f) minus 12(d).",null,null,{"$f":"F39-F37","v":0},{"$f":"G39-G37","v":0},null,null,null,null,{"$f":"MIN(I7,I8)","v":0},"FATHER"]
[null,"Parenting Time Deviation        ",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(B6=TRUE,B12=FALSE),L37,IF(B6 = FALSE, 0, L38))","v":0}]
[null,"Complete only if Parenting Time Deviation is being considered for Noncustodial Parent based on court ordered visitation.",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(B6=TRUE,B12=FALSE),L39,IF(B6=FALSE,0,L40))","v":0}]
[null,"13.","Enter monthly amount of Parenting Time deviation here; otherwise, leave field blank.  Do not enter a negative number.",null,null,0,0]
[null,"Total Allowable Deviation"]
[null,"14.","Total Allowable Deviations on Lines 1(a) or 1(b), 11, 12(g), and 13, if any apply, automatically display here and on Line 10 of the Child Support Worksheet Line 10.  (The total can be a negative number.)",null,null,{"$f":"-L41+IF(B31=FALSE,F30,H30)+F40-F43","v":0},{"$f":"-L42+IF(B31=FALSE,G30,I30)+G40-G43","v":0}]
[null,"Important Requirement About Deviations - No Deviations are permitted under the law unless\nall three questions below [ (B), (C) and (D) ] have been answered for each requested deviation."]
[null,"B. Would the presumptive amount be unjust or inappropriate?  Explain"]
[]
[null,"C. Would deviation serve the best interests of the children for whom support is being determined?  Explain"]
[]
[null,"D. Would deviation seriously impair the ability of the CUSTODIAL Parent or NONPARENT Custodian to maintain minimally adequate housing, food and clothing for the children being supported by the order and to provide other basic necessities?  Explain"]
[]
[null,"Supplemental Table 1. Use this table to calculate amount for Line 12 Schedule E, children 1, 2 and 3.  For additional children use Supplemental Table 2, 3, or 4.\nEnter amounts/data in yellow fields only.  Calculations will automatically display in the appropriate white fields."]
[null,"1.","Children's Names →\n(Names will automatically display)",null,null,null,"Child 1","Child 2","Child 3"]
[null,null,null,null,null,null,{"$f":"CONCATENATE('CS Worksheet'!$D$18)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$D$19)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$D$20)","v":""}]
[null,"Extraordinary Educational Expenses",null,null,null,"Paid by",null,null,null,"Totals"]
[null,"2.","Total yearly amount paid for Tuition, Room & Board, Fees and Books",null,null,"Mother",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,G57)+SUMIF('CS Worksheet'!$C$19,TRUE,H57)+SUMIF('CS Worksheet'!$C$20,TRUE,I57)","v":0}]
[null,"3.","Total yearly amount paid for Other Extraordinary Educational Expenses ",null,null,"Mother",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,G58)+SUMIF('CS Worksheet'!$C$19,TRUE,H58)+SUMIF('CS Worksheet'!$C$20,TRUE,I58)","v":0}]
[null,"4.","Total yearly amount paid for Tuition, Room & Board, Fees and Books",null,null,"Father",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,G59)+SUMIF('CS Worksheet'!$C$19,TRUE,H59)+SUMIF('CS Worksheet'!$C$20,TRUE,I59)","v":0}]
[null,"5.","Total yearly amount paid for Other Extraordinary Educational Expenses ",null,null,"Father",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,G60)+SUMIF('CS Worksheet'!$C$19,TRUE,H60)+SUMIF('CS Worksheet'!$C$20,TRUE,I60)","v":0}]
[null,"6.","Total yearly amount paid for Tuition, Room & Board, Fees and Books",null,null,"Nonparent Custodian",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,G61)+SUMIF('CS Worksheet'!$C$19,TRUE,H61)+SUMIF('CS Worksheet'!$C$20,TRUE,I61)","v":0}]
[null,"7.","Total yearly amount paid for Other Extraordinary Educational Expenses ",null,null,"Nonparent Custodian",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,G62)+SUMIF('CS Worksheet'!$C$19,TRUE,H62)+SUMIF('CS Worksheet'!$C$20,TRUE,I62)","v":0}]
[null,"8.","Total Yearly Amounts",null,null,null,{"$f":"IF('CS Worksheet'!$C$18=TRUE,SUM(G57:G62),0)","v":0},{"$f":"IF('CS Worksheet'!$C$19=TRUE,SUM(H57:H62),0)","v":0},{"$f":"IF('CS Worksheet'!$C$20=TRUE,SUM(I57:I62),0)","v":0},{"$f":"SUM(G63:I63)","v":0}]
[null,"9.","Monthly Average (Line 8 divided by 12 months)",null,null,null,{"$f":"SROUND(G63)","v":0},{"$f":"SROUND(H63)","v":0},{"$f":"SROUND(I63)","v":0},{"$f":"SUM(J65:J67)","v":0}]
[null,"9(a)","Mother's monthly Extraordinary Educational Expenses",null,null,"Mother",{"$f":"IF('CS Worksheet'!$C$18=TRUE,SROUND((G57+G58)),0)","v":0},{"$f":"IF('CS Worksheet'!$C$19=TRUE,SROUND((H57+H58)),0)","v":0},{"$f":"IF('CS Worksheet'!$C$20=TRUE,SROUND((I57+I58)),0)","v":0},{"$f":"SUM(G65:I65)","v":0}]
[null,"9(b)","Father's monthly Extraordinary Educational Expenses",null,null,"Father",{"$f":"IF('CS Worksheet'!$C$18=TRUE,SROUND((G59+G60)),0)","v":0},{"$f":"IF('CS Worksheet'!$C$19=TRUE,SROUND((H59+H60)),0)","v":0},{"$f":"IF('CS Worksheet'!$C$20=TRUE,SROUND((I59+I60)),0)","v":0},{"$f":"SUM(G66:I66)","v":0}]
[null,"9(c)","Nonparent's monthly Extraordinary Educational Expenses",null,null,"Nonparent Custodian",{"$f":"IF('CS Worksheet'!$C$18=TRUE,SROUND((G61+G62)),0)","v":0},{"$f":"IF('CS Worksheet'!$C$19=TRUE,SROUND((H61+H62)),0)","v":0},{"$f":"IF('CS Worksheet'!$C$20=TRUE,SROUND((I61+I62)),0)","v":0},{"$f":"SUM(G67:I67)","v":0}]
[null,"Extraordinary Medical Expenses",null,null,null,"Paid by",null,null,null,"Totals"]
[null,"10.","Total yearly amount paid for extraordinary medical expenses",null,null,"Mother",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,G69)+SUMIF('CS Worksheet'!$C$19,TRUE,H69)+SUMIF('CS Worksheet'!$C$20,TRUE,I69)","v":0}]
[null,"11.","Total yearly amount paid for extraordinary medical expenses",null,null,"Father",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,G70)+SUMIF('CS Worksheet'!$C$19,TRUE,H70)+SUMIF('CS Worksheet'!$C$20,TRUE,I70)","v":0}]
[null,"12.","Total yearly amount paid for extraordinary medical expenses",null,null,"Nonparent Custodian",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,G71)+SUMIF('CS Worksheet'!$C$19,TRUE,H71)+SUMIF('CS Worksheet'!$C$20,TRUE,I71)","v":0}]
[null,"13.","Total Yearly Amounts",null,null,null,{"$f":"IF('CS Worksheet'!$C$18=TRUE,SUM(G69:G71),0)","v":0},{"$f":"IF('CS Worksheet'!$C$19=TRUE,SUM(H69:H71),0)","v":0},{"$f":"IF('CS Worksheet'!$C$20=TRUE,SUM(I69:I71),0)","v":0},{"$f":"SUM(G72:I72)","v":0}]
[null,"14.","Monthly Average (Line 13 divided by 12 months)",null,null,null,{"$f":"SROUND(G72)","v":0},{"$f":"SROUND(H72)","v":0},{"$f":"SROUND(I72)","v":0},{"$f":"SUM(J74:J76)","v":0}]
[null,"14(a).","Mother's monthly Extraordinary Medical Expenses",null,null,"Mother",{"$f":"IF('CS Worksheet'!$C$18=TRUE,SROUND(G69),0)","v":0},{"$f":"IF('CS Worksheet'!$C$19=TRUE,SROUND(H69),0)","v":0},{"$f":"IF('CS Worksheet'!$C$20=TRUE,SROUND(I69),0)","v":0},{"$f":"SUM(G74:I74)","v":0}]
[null,"14(b).","Father's monthly Extraordinary Medical Expenses",null,null,"Father",{"$f":"IF('CS Worksheet'!$C$18=TRUE,SROUND(G70),0)","v":0},{"$f":"IF('CS Worksheet'!$C$19=TRUE,SROUND(H70),0)","v":0},{"$f":"IF('CS Worksheet'!$C$20=TRUE,SROUND(I70),0)","v":0},{"$f":"SUM(G75:I75)","v":0}]
[null,"14(c).","Nonparent's monthly Extraordinary Medical Expenses",null,null,"Nonparent Custodian",{"$f":"IF('CS Worksheet'!$C$18=TRUE,SROUND(G71),0)","v":0},{"$f":"IF('CS Worksheet'!$C$19=TRUE,SROUND(H71),0)","v":0},{"$f":"IF('CS Worksheet'!$C$19=TRUE,SROUND(I71),0)","v":0},{"$f":"SUM(G76:I76)","v":0}]
[null,"Special Expenses for Child Rearing (including, but not limited to summer camp, music or art lessons, band, clubs, athletics, etc.) Write brief description of expenses in yellow fields.",null,null,null,"Paid by",null,null,null,"Totals"]
[null,"15.","Total yearly amount paid for:",null,null,"Mother",null,null,null,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,G79)+SUMIF('CS Worksheet'!$C$19,TRUE,H79)+SUMIF('CS Worksheet'!$C$20,TRUE,I79)","v":0}]
[null,null,null,null,null,null,0,0,0]
[null,"16.","Total yearly amount paid for:",null,null,"Father",null,null,null,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,G81)+SUMIF('CS Worksheet'!$C$19,TRUE,H81)+SUMIF('CS Worksheet'!$C$20,TRUE,I81)","v":0}]
[null,null,null,null,null,null,0,0,0]
[null,"17.","Total yearly amount paid for:",null,null,"Nonparent Custodian",null,null,null,{"$f":"SUMIF('CS Worksheet'!$C$18,TRUE,G83)+SUMIF('CS Worksheet'!$C$19,TRUE,H83)+SUMIF('CS Worksheet'!$C$20,TRUE,I83)","v":0}]
[null,null,null,null,null,null,0,0,0]
[null,"18.","Total Yearly Amounts (Lines 15, 16  & 17 added)",null,null,null,{"$f":"IF('CS Worksheet'!$C$18=TRUE,SUM(G79:G83),0)","v":0},{"$f":"IF('CS Worksheet'!$C$19=TRUE,SUM(H79:H83),0)","v":0},{"$f":"IF('CS Worksheet'!$C$20=TRUE,SUM(I79:I83),0)","v":0},{"$f":"SUM(G84:I84)","v":0}]
[null,"19.","Monthly Average (Line 18 divided by 12 months)",null,null,null,{"$f":"SROUND(G84)","v":0},{"$f":"SROUND(H84)","v":0},{"$f":"SROUND(I84)","v":0},{"$f":"SROUND(J84)","v":0}]
[null,"7 Percent Test to Calculate Allowable Expenses",null,null,null,"Paid by",null,null,null,"Totals"]
[null,"20.","Total Yearly amount paid for Special Expenses for Child Rearing\n>Total amounts from Line 15 of each Supplemental Table.",null,null,"Mother",null,null,null,{"$f":"SUM(J78,'Schedule E Supplemental Tables'!I26,'Schedule E Supplemental Tables'!I63,'Schedule E Supplemental Tables'!I100)","v":0}]
[null,"21.","Total Yearly amount paid for Special Expenses for Child Rearing\n>Total amounts from Line 16 of each Supplemental Table.",null,null,"Father",null,null,null,{"$f":"SUM(J80,'Schedule E Supplemental Tables'!I28,'Schedule E Supplemental Tables'!I65,'Schedule E Supplemental Tables'!I102)","v":0}]
[null,"22.","Total Yearly amount paid for Special Expenses for Child Rearing\n>Total amounts from Line 17 of each Supplemental Table.",null,null,"Nonparent Custodian",null,null,null,{"$f":"SUM(J82,'Schedule E Supplemental Tables'!I30,'Schedule E Supplemental Tables'!I67,'Schedule E Supplemental Tables'!I104)","v":0}]
[null,"23.","Total Yearly Amounts (Lines 20, 21 & 22 added)",null,null,null,null,null,null,{"$f":"SUM(J87:J89)","v":0}]
[null,"24.","Monthly Average (Line 23 divided by 12 months)",null,null,null,null,null,null,{"$f":"SROUND(J90)","v":0}]
[null,"25.","Basic Child Support Obligation (from Child Support Worksheet, Line 4)",null,null,null,null,null,null,{"$f":"IF('CS Worksheet'!F25>0,'CS Worksheet'!M35,0)","v":0}]
[null,"26.","Special Expenses Limitation (Line 25 x 7% (.07))",null,null,null,null,null,null,{"$f":"tround(J92*0.07)","v":0}]
[null,"27.","If Line 24 is greater than Line 26, Line 26 will be subtracted from Line 24.\nIf Line 24 is less than Line 26, zero will display.",null,null,null,null,null,null,{"$f":"IF(J91>J93,J91-J93,0)","v":0}]
[null,"28.","Mother's Monthly Allowable Special Expenses for Child Rearing\n>Line 20 divided by Line 23, and percentage multiplied by amount on Line 27.",null,null,null,null,null,null,{"$f":"IF(J90>0,tround(J94*(CROUND(SUM(J78,'Schedule E Supplemental Tables'!I26,'Schedule E Supplemental Tables'!I63,'Schedule E Supplemental Tables'!I100)/J90))),0)","v":0}]
[null,"29.","Father's Monthly Allowable Special Expenses for Child Rearing\n>Line 21 divided by Line 23, and percentage multiplied by amount on Line 27.",null,null,null,null,null,null,{"$f":"IF(J91>0,tround(J94*(CROUND(SUM(J80,'Schedule E Supplemental Tables'!I28,'Schedule E Supplemental Tables'!I65,'Schedule E Supplemental Tables'!I102)/J90))),0)","v":0}]
[null,"30.","Nonparent's Monthly Allowable Special Expenses for Child Rearing\n>Line 22 divided by Line 23, and percentage multiplied by amount on Line 27.",null,null,null,null,null,null,{"$f":"IF(J91>0,tround(J94*(CROUND(SUM(J82,'Schedule E Supplemental Tables'!I30,'Schedule E Supplemental Tables'!I67,'Schedule E Supplemental Tables'!I104)/J90))),0)","v":0}]
[null,{"$f":"CONCATENATE(\"Names of Parties:  \", LEFT('CS Worksheet'!$B$5,100),\"    vs. \",'CS Worksheet'!$B$8)","v":"Names of Parties:      vs. "}]
[null,{"$f":"CONCATENATE(\"Submitted by:  \", 'CS Worksheet'!$F$27)","v":"Submitted by:  "},null,null,null,null,null,null,null,{"$f":"\"Today's date: \" & TEXT(TODAY(),\"mm/dd/yyyy\")","v":{"$error":"#VALUE!"}}]
[null,{"$f":"\"Case #: \" &  'CS Worksheet'!$K$4","v":"Case #: "},null,null,null,null,null,null,null,"Version 9.2"]

{"sheet":"Schedule E Supplemental Tables","index":10,"n_rows":110,"n_cols":9,"rows_kept":110,"cut":false,"hidden":false,"merged":[[6,1,6,3],[3,5,3,7],[15,5,15,7],[24,5,24,7],[3,0,3,3],[15,0,15,3],[7,1,7,3],[67,1,67,3],[64,0,65,0],[66,0,67,0],[65,1,65,3],[62,0,63,0],[60,1,60,3],[56,1,56,3],[14,1,14,3],[18,1,18,3],[25,0,26,0],[21,1,21,3],[22,1,22,3],[50,1,50,3],[52,5,52,7],[61,5,61,7],[55,1,55,3],[51,1,51,3],[0,0,0,8],[25,8,26,8],[27,0,28,0],[27,8,28,8],[27,4,28,4],[8,1,8,3],[1,0,2,0],[1,1,2,4],[26,1,26,3],[24,0,24,3],[20,1,20,3],[23,1,23,3],[25,1,25,3],[27,1,27,3],[4,1,4,3],[13,1,13,3],[5,1,5,3],[10,1,10,3],[16,1,16,3],[17,1,17,3],[9,1,9,3],[19,1,19,3],[11,1,11,3],[12,1,12,3],[28,1,28,3],[25,4,26,4],[40,5,40,7],[44,1,44,3],[31,1,31,3],[29,1,29,3],[42,1,42,3],[43,1,43,3],[37,0,37,8],[41,1,41,3],[29,0,30,0],[29,8,30,8],[29,4,30,4],[106,1,106,3],[105,1,105,3],[94,1,94,3],[84,1,84,3],[97,1,97,3],[93,1,93,3],[92,1,92,3],[90,1,90,3],[79,1,79,3],[80,1,80,3],[87,1,87,3],[88,1,88,3],[81,1,81,3],[86,1,86,3],[98,0,98,3],[96,1,96,3],[83,1,83,3],[82,1,82,3],[89,0,89,3],[100,1,100,3],[101,1,101,3],[102,1,102,3],[101,0,102,0],[103,0,104,0],[103,4,104,4],[99,8,100,8],[98,5,98,7],[101,8,102,8],[101,4,102,4],[103,8,104,8],[103,1,103,3],[104,1,104,3],[99,4,100,4],[53,1,53,3],[48,1,48,3],[32,1,32,3],[40,0,40,3],[38,0,39,0],[38,1,39,4],[47,1,47,3],[30,1,30,3],[62,4,63,4],[59,1,59,3],[49,1,49,3],[61,0,61,3],[57,1,57,3],[58,1,58,3],[54,1,54,3],[45,1,45,3],[46,1,46,3],[52,0,52,3],[64,4,65,4],[64,1,64,3],[62,1,62,3],[66,1,66,3],[95,1,95,3],[99,0,100,0],[99,1,99,3],[85,1,85,3],[68,1,68,3],[91,1,91,3],[69,1,69,3],[74,0,74,8],[75,0,76,0],[77,5,77,7],[78,1,78,3],[77,0,77,3],[89,5,89,7],[75,1,76,4],[66,8,67,8],[62,8,63,8],[64,8,65,8],[66,4,67,4],[63,1,63,3]]}
["Schedule E-Deviations-Supplemental Table 2. Use this table to calculate amount for Line 12 Schedule E, children 4, 5 and 6. For additional children use Supplemental Table 3 and/or 4. Enter amounts/data in yellow fields only.  Calculations automatically display in appropriate white fields on this schedule."]
["1.","Children's Names →\n(Names will automatically display)",null,null,null,"Child 4","Child 5","Child 6"]
[null,null,null,null,null,{"$f":"CONCATENATE('CS Worksheet'!$D$21)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$D$22)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$D$23)","v":""}]
["Extraordinary Educational Expenses",null,null,null,"Paid by",null,null,null,"Totals"]
["2.","Total yearly amount paid for Tuition, Room & Board, Fees and Books",null,null,"Mother",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,F5)+SUMIF('CS Worksheet'!$C$22,TRUE,G5)+SUMIF('CS Worksheet'!$C$23,TRUE,H5)","v":0}]
["3.","Total yearly amount paid for Other Extraordinary Educational Expenses ",null,null,"Mother",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,F6)+SUMIF('CS Worksheet'!$C$22,TRUE,G6)+SUMIF('CS Worksheet'!$C$23,TRUE,H6)","v":0}]
["4.","Total yearly amount paid for Tuition, Room & Board, Fees and Books",null,null,"Father",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,F7)+SUMIF('CS Worksheet'!$C$22,TRUE,G7)+SUMIF('CS Worksheet'!$C$23,TRUE,H7)","v":0}]
["5.","Total yearly amount paid for Other Extraordinary Educational Expenses ",null,null,"Father",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,F8)+SUMIF('CS Worksheet'!$C$22,TRUE,G8)+SUMIF('CS Worksheet'!$C$23,TRUE,H8)","v":0}]
["6.","Total yearly amount paid for Tuition, Room & Board, Fees and Books",null,null,"Nonparent Custodian",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,F9)+SUMIF('CS Worksheet'!$C$22,TRUE,G9)+SUMIF('CS Worksheet'!$C$23,TRUE,H9)","v":0}]
["7.","Total yearly amount paid for Other Extraordinary Educational Expenses ",null,null,"Nonparent Custodian",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,F10)+SUMIF('CS Worksheet'!$C$22,TRUE,G10)+SUMIF('CS Worksheet'!$C$23,TRUE,H10)","v":0}]
["8.","Total Yearly Amounts",null,null,null,{"$f":"IF('CS Worksheet'!$C$21=TRUE,SUM(F5:F10),0)","v":0},{"$f":"IF('CS Worksheet'!$C$22=TRUE,SUM(G5:G10),0)","v":0},{"$f":"IF('CS Worksheet'!$C$23=TRUE,SUM(H5:H10),0)","v":0},{"$f":"SUM(F11:H11)","v":0}]
["9.","Monthly Average (Divide Line 8 by 12 months)",null,null,null,{"$f":"ROUND(F11/12,2)","v":0},{"$f":"ROUND(G11/12,2)","v":0},{"$f":"ROUND(H11/12,2)","v":0},{"$f":"SUM(I13:I15)","v":0}]
["9(a).","Mother's monthly Extraordinary Educational Expenses",null,null,"Mother",{"$f":"IF('CS Worksheet'!$C$21=TRUE,SROUND((F5+F6)),0)","v":0},{"$f":"IF('CS Worksheet'!$C$22=TRUE,SROUND((G5+G6)),0)","v":0},{"$f":"IF('CS Worksheet'!$C$23=TRUE,SROUND((H5+H6)),0)","v":0},{"$f":"SUM(F13:H13)","v":0}]
["9(b).","Father's monthly Extraordinary Educational Expenses",null,null,"Father",{"$f":"IF('CS Worksheet'!$C$21=TRUE,SROUND((F7+F8)),0)","v":0},{"$f":"IF('CS Worksheet'!$C$22=TRUE,SROUND((G7+G8)),0)","v":0},{"$f":"IF('CS Worksheet'!$C$23=TRUE,SROUND((H7+H8)),0)","v":0},{"$f":"SUM(F14:H14)","v":0}]
["9(c).","Nonparent's monthly Extraordinary Educational Expenses",null,null,"Nonparent Custodian",{"$f":"IF('CS Worksheet'!$C$21=TRUE,SROUND((F9+F10)),0)","v":0},{"$f":"IF('CS Worksheet'!$C$22=TRUE,SROUND((G9+G10)),0)","v":0},{"$f":"IF('CS Worksheet'!$C$23=TRUE,SROUND((H9+H10)),0)","v":0},{"$f":"SUM(F15:H15)","v":0}]
["Extraordinary Medical Expenses","Extraordinary Medical Expenses",null,null,"Paid by",null,null,null,"Totals"]
["10.","Total yearly amount paid for extraordinary medical expenses",null,null,"Mother",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,F17)+SUMIF('CS Worksheet'!$C$22,TRUE,G17)+SUMIF('CS Worksheet'!$C$23,TRUE,H17)","v":0}]
["11.","Total yearly amount paid for extraordinary medical expenses",null,null,"Father",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,F18)+SUMIF('CS Worksheet'!$C$22,TRUE,G18)+SUMIF('CS Worksheet'!$C$23,TRUE,H18)","v":0}]
["12.","Total yearly amount paid for extraordinary medical expenses",null,null,"Nonparent Custodian",0,0,0,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,F19)+SUMIF('CS Worksheet'!$C$22,TRUE,G19)+SUMIF('CS Worksheet'!$C$23,TRUE,H19)","v":0}]
["13.","Total Yearly Amounts",null,null,null,{"$f":"IF('CS Worksheet'!$C$21=TRUE,SUM(F17:F19),0)","v":0},{"$f":"IF('CS Worksheet'!$C$22=TRUE,SUM(G17:G19),0)","v":0},{"$f":"IF('CS Worksheet'!$C$23=TRUE,SUM(H17:H19),0)","v":0},{"$f":"SUM(F20:H20)","v":0}]
["14.","Monthly Average (Divide Line 13 by 12 months)",null,null,null,{"$f":"ROUND(F20/12,2)","v":0},{"$f":"ROUND(G20/12,2)","v":0},{"$f":"ROUND(H20/12,2)","v":0},{"$f":"SUM(I22:I24)","v":0}]
["14(a).","Mother's monthly Extraordinary Medical Expenses",null,null,"Mother",{"$f":"IF('CS Worksheet'!$C$21=TRUE,SROUND(F17),0)","v":0},{"$f":"IF('CS Worksheet'!$C$22=TRUE,SROUND(G17),0)","v":0},{"$f":"IF('CS Worksheet'!$C$23=TRUE,SROUND(H17),0)","v":0},{"$f":"SUM(F22:H22)","v":0}]
["14(b).","Father's monthly Extraordinary Medical Expenses",null,null,"Father",{"$f":"IF('CS Worksheet'!$C$21=TRUE,SROUND(F18),0)","v":0},{"$f":"IF('CS Worksheet'!$C$22=TRUE,SROUND(G18),0)","v":0},{"$f":"IF('CS Worksheet'!$C$23=TRUE,SROUND(H18),0)","v":0},{"$f":"SUM(F23:H23)","v":0}]
["14(c).","Nonparent's monthly Extraordinary Medical Expenses",null,null,"Nonparent Custodian",{"$f":"IF('CS Worksheet'!$C$21=TRUE,SROUND(F19),0)","v":0},{"$f":"IF('CS Worksheet'!$C$22=TRUE,SROUND(G19),0)","v":0},{"$f":"IF('CS Worksheet'!$C$23=TRUE,SROUND(H19),0)","v":0},{"$f":"SUM(F24:H24)","v":0}]
["Special Expenses for Child Rearing (including, but not limited to summer camp, music or art lessons, band, clubs, athletics, etc.) Write brief description of expenses in yellow fields.",null,null,null,"Paid by",null,null,null,"Totals"]
["15.","Total yearly amount paid for:",null,null,"Mother",null,null,null,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,F27)+SUMIF('CS Worksheet'!$C$22,TRUE,G27)+SUMIF('CS Worksheet'!$C$23,TRUE,H27)","v":0}]
[null,null,null,null,null,0,0,0]
["16.","Total yearly amount paid for:",null,null,"Father",null,null,null,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,F29)+SUMIF('CS Worksheet'!$C$22,TRUE,G29)+SUMIF('CS Worksheet'!$C$23,TRUE,H29)","v":0}]
[null,null,null,null,null,0,0,0]
["17.","Total yearly amount paid for:",null,null,"Nonparent Custodian",null,null,null,{"$f":"SUMIF('CS Worksheet'!$C$21,TRUE,F31)+SUMIF('CS Worksheet'!$C$22,TRUE,G31)+SUMIF('CS Worksheet'!$C$23,TRUE,H31)","v":0}]
[null,null,null,null,null,0,0,0]
["18.","Total Yearly Amounts (Add Lines 15, 16  & 17)",null,null,null,{"$f":"IF('CS Worksheet'!$C$21=TRUE,SUM(F27:F31),0)","v":0},{"$f":"IF('CS Worksheet'!$C$22=TRUE,SUM(G27:G31),0)","v":0},{"$f":"IF('CS Worksheet'!$C$23=TRUE,SUM(H27:H31),0)","v":0},{"$f":"SUM(F32:H32)","v":0}]
["19.","Monthly Average (Divide Line 18 by 12 months)",null,null,null,{"$f":"ROUND(F32/12,2)","v":0},{"$f":"ROUND(G32/12,2)","v":0},{"$f":"ROUND(H32/12,2)","v":0},{"$f":"SROUND(I32)","v":0}]
[{"$f":"CONCATENATE(\"Names of Parties:  \", LEFT('CS Worksheet'!$B$5,100),\"    vs. \",'CS Worksheet'!$B$8)","v":"Names of Parties:      vs. "}]
[{"$f":"CONCATENATE(\"Submitted by:  \", 'CS Worksheet'!$F$27)","v":"Submitted by:  "},null,null,null,null,null,null,null,{"$f":"\"Today's date: \" & TEXT(TODAY(),\"mm/dd/yyyy\")","v":{"$error":"#VALUE!"}}]
[{"$f":"\"Case #:    \"&IF('CS Worksheet'!F25>0,IF('CS Worksheet'!K4=\"\",CONCATENATE('CS Worksheet'!K6),CONCATENATE('CS Worksheet'!K4)),\"\")","v":"Case #:    "},null,null,null,null,null,null,null,"Version 9.2"]
[]
["Schedule E-Deviations-Supplemental Table 3. Use this table to calculate amount for Line 12 Schedule E, children 7, 8 and 9. For additional children use Supplemental Table 4. Enter amounts/data in yellow fields only. Calculations automatically display in appropriate white fields on schedule."]
["1.","Children's Names →\n(Names will automatically display)",null,null,null,"Child 7","Child 8","Child 9"]
[null,null,null,null,null,{"$f":"CONCATENATE('CS Worksheet'!$J$18)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$J$19)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$J$20)","v":""}]
["Extraordinary Educational Expenses",null,null,null,"Paid by",null,null,null,"Totals"]
["2.","Total yearly amount paid for Tuition, Room & Board, Fees and Books",null,null,"Mother",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,F42)+SUMIF('CS Worksheet'!$I$19,TRUE,G42)+SUMIF('CS Worksheet'!$I$20,TRUE,H42)","v":0}]
["3.","Total yearly amount paid for Other Extraordinary Educational Expenses ",null,null,"Mother",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,F43)+SUMIF('CS Worksheet'!$I$19,TRUE,G43)+SUMIF('CS Worksheet'!$I$20,TRUE,H43)","v":0}]
["4.","Total yearly amount paid for Tuition, Room & Board, Fees and Books",null,null,"Father",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,F44)+SUMIF('CS Worksheet'!$I$19,TRUE,G44)+SUMIF('CS Worksheet'!$I$20,TRUE,H44)","v":0}]
["5.","Total yearly amount paid for Other Extraordinary Educational Expenses ",null,null,"Father",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,F45)+SUMIF('CS Worksheet'!$I$19,TRUE,G45)+SUMIF('CS Worksheet'!$I$20,TRUE,H45)","v":0}]
["6.","Total yearly amount paid for Tuition, Room & Board, Fees and Books",null,null,"Nonparent Custodian",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,F46)+SUMIF('CS Worksheet'!$I$19,TRUE,G46)+SUMIF('CS Worksheet'!$I$20,TRUE,H46)","v":0}]
["7.","Total yearly amount paid for Other Extraordinary Educational Expenses ",null,null,"Nonparent Custodian",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,F47)+SUMIF('CS Worksheet'!$I$19,TRUE,G47)+SUMIF('CS Worksheet'!$I$20,TRUE,H47)","v":0}]
["8.","Total Yearly Amounts",null,null,null,{"$f":"IF('CS Worksheet'!$I$18=TRUE,SUM(F42:F47),0)","v":0},{"$f":"IF('CS Worksheet'!$I$19=TRUE,SUM(G42:G47),0)","v":0},{"$f":"IF('CS Worksheet'!$I$20=TRUE,SUM(H42:H47),0)","v":0},{"$f":"SUM(F48:H48)","v":0}]
["9.","Monthly Average (Divide Line 8 by 12 months)",null,null,null,{"$f":"SROUND(F48)","v":0},{"$f":"SROUND(G48)","v":0},{"$f":"SROUND(H48)","v":0},{"$f":"SUM(I50:I52)","v":0}]
["9(a).","Mother's monthly Extraordinary Educational Expenses",null,null,"Mother",{"$f":"IF('CS Worksheet'!$I$18=TRUE,SROUND((F42+F43)),0)","v":0},{"$f":"IF('CS Worksheet'!$I$19=TRUE,SROUND((G42+G43)),0)","v":0},{"$f":"IF('CS Worksheet'!$I$20=TRUE,SROUND((H42+H43)),0)","v":0},{"$f":"SUM(F50:H50)","v":0}]
["9(b).","Father's monthly Extraordinary Educational Expenses",null,null,"Father",{"$f":"IF('CS Worksheet'!$I$18=TRUE,SROUND((F44+F45)),0)","v":0},{"$f":"IF('CS Worksheet'!$I$19=TRUE,SROUND((G44+G45)),0)","v":0},{"$f":"IF('CS Worksheet'!$I$20=TRUE,SROUND((H44+H45)),0)","v":0},{"$f":"SUM(F51:H51)","v":0}]
["9(c).","Nonparent's monthly Extraordinary Educational Expenses",null,null,"Nonparent Custodian",{"$f":"IF('CS Worksheet'!$I$18=TRUE,SROUND((F46+F47)),0)","v":0},{"$f":"IF('CS Worksheet'!$I$19=TRUE,SROUND((G46+G47)),0)","v":0},{"$f":"IF('CS Worksheet'!$I$20=TRUE,SROUND((H46+H47)),0)","v":0},{"$f":"SUM(F52:H52)","v":0}]
["Extraordinary Medical Expenses","Extraordinary Medical Expenses",null,null,"Paid by",null,null,null,"Totals"]
["10.","Total yearly amount paid for extraordinary medical expenses",null,null,"Mother",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,F54)+SUMIF('CS Worksheet'!$I$19,TRUE,G54)+SUMIF('CS Worksheet'!$I$20,TRUE,H54)","v":0}]
["11.","Total yearly amount paid for extraordinary medical expenses",null,null,"Father",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,F55)+SUMIF('CS Worksheet'!$I$19,TRUE,G55)+SUMIF('CS Worksheet'!$I$20,TRUE,H55)","v":0}]
["12.","Total yearly amount paid for extraordinary medical expenses",null,null,"Nonparent Custodian",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,F56)+SUMIF('CS Worksheet'!$I$19,TRUE,G56)+SUMIF('CS Worksheet'!$I$20,TRUE,H56)","v":0}]
["13.","Total Yearly Amounts",null,null,null,{"$f":"IF('CS Worksheet'!$I$18=TRUE,SUM(F54:F56),0)","v":0},{"$f":"IF('CS Worksheet'!$I$19=TRUE,SUM(G54:G56),0)","v":0},{"$f":"IF('CS Worksheet'!$I$20=TRUE,SUM(H54:H56),0)","v":0},{"$f":"SUM(F57:H57)","v":0}]
["14.","Monthly Average (Divide Line 13 by 12 months)",null,null,null,{"$f":"SROUND(F57)","v":0},{"$f":"SROUND(G57)","v":0},{"$f":"SROUND(H57)","v":0},{"$f":"SUM(I59:I61)","v":0}]
["14(a).","Mother's monthly Extraordinary Medical Expenses",null,null,"Mother",{"$f":"IF('CS Worksheet'!I$18=TRUE,SROUND(F54),0)","v":0},{"$f":"IF('CS Worksheet'!$I$19=TRUE,SROUND(G54),0)","v":0},{"$f":"IF('CS Worksheet'!$I$20=TRUE,SROUND(H54),0)","v":0},{"$f":"SUM(F59:H59)","v":0}]
["14(b).","Father's monthly Extraordinary Medical Expenses",null,null,"Father",{"$f":"IF('CS Worksheet'!$I$18=TRUE,SROUND(F55),0)","v":0},{"$f":"IF('CS Worksheet'!$I$19=TRUE,SROUND(G55),0)","v":0},{"$f":"IF('CS Worksheet'!$I$20=TRUE,SROUND(H55),0)","v":0},{"$f":"SUM(F60:H60)","v":0}]
["14(c).","Nonparent's monthly Extraordinary Medical Expenses",null,null,"Nonparent Custodian",{"$f":"IF('CS Worksheet'!$I$18=TRUE,SROUND(F56),0)","v":0},{"$f":"IF('CS Worksheet'!$I$19=TRUE,SROUND(G56),0)","v":0},{"$f":"IF('CS Worksheet'!$I$20=TRUE,SROUND(H56),0)","v":0},{"$f":"SUM(F61:H61)","v":0}]
["Special Expenses for Child Rearing (including, but not limited to summer camp, music or art lessons, band, clubs, athletics, etc.) Write brief description of expenses in yellow fields.",null,null,null,"Paid by",null,null,null,"Totals"]
["15.","Total yearly amount paid for:",null,null,"Mother",null,null,null,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,F64)+SUMIF('CS Worksheet'!$I$19,TRUE,G64)+SUMIF('CS Worksheet'!$I$20,TRUE,H64)","v":0}]
[null,null,null,null,null,0,0,0]
["16.","Total yearly amount paid for:",null,null,"Father",null,null,null,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,F66)+SUMIF('CS Worksheet'!$I$19,TRUE,G66)+SUMIF('CS Worksheet'!$I$20,TRUE,H66)","v":0}]
[null,null,null,null,null,0,0,0]
["17.","Total yearly amount paid for:",null,null,"Nonparent Custodian",null,null,null,{"$f":"SUMIF('CS Worksheet'!$I$18,TRUE,F68)+SUMIF('CS Worksheet'!$I$19,TRUE,G68)+SUMIF('CS Worksheet'!$I$20,TRUE,H68)","v":0}]
[null,null,null,null,null,0,0,0]
["18.","Total Yearly Amounts (Add Lines 15, 16  & 17)",null,null,null,{"$f":"IF('CS Worksheet'!$I$18=TRUE,SUM(F64:F68),0)","v":0},{"$f":"IF('CS Worksheet'!$I$19=TRUE,SUM(G64:G68),0)","v":0},{"$f":"IF('CS Worksheet'!$I$20=TRUE,SUM(H64:H68),0)","v":0},{"$f":"SUM(F69:H69)","v":0}]
["19.","Monthly Average (Divide Line 18 by 12 months)",null,null,null,{"$f":"SROUND(F69)","v":0},{"$f":"SROUND(G69)","v":0},{"$f":"SROUND(H69)","v":0},{"$f":"SROUND(I69)","v":0}]
[{"$f":"CONCATENATE(\"Names of Parties:  \", LEFT('CS Worksheet'!$B$5,100),\"    vs. \",'CS Worksheet'!$B$8)","v":"Names of Parties:      vs. "}]
[{"$f":"CONCATENATE(\"Submitted by:  \", 'CS Worksheet'!$F$27)","v":"Submitted by:  "},null,null,null,null,null,null,null,{"$f":"\"Today's date: \" & TEXT(TODAY(),\"mm/dd/yyyy\")","v":{"$error":"#VALUE!"}}]
[{"$f":"\"Case #:         \"&IF('CS Worksheet'!F25>0,IF('CS Worksheet'!K4=\"\",CONCATENATE('CS Worksheet'!K6),CONCATENATE('CS Worksheet'!K4)),\"\")","v":"Case #:         "},null,null,null,null,null,null,null,"Version 9.2"]
[]
["Schedule E-Deviations-Supplemental Table 4. Use this table to calculate amount for Line 12 Schedule E, children 10, 11 and 12.\nEnter amounts/data in yellow fields only. Calculations automatically display in appropriate white fields on schedule."]
["1.","Children's Names →\n(Names will automatically display)",null,null,null,"Child 10","Child 11","Child 12"]
[null,null,null,null,null,{"$f":"CONCATENATE('CS Worksheet'!$J$21)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$J$22)","v":""},{"$f":"CONCATENATE('CS Worksheet'!$J$23)","v":""}]
["Extraordinary Educational Expenses",null,null,null,"Paid by",null,null,null,"Totals"]
["2.","Total yearly amount paid for Tuition, Room & Board, Fees and Books",null,null,"Mother",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,F79)+SUMIF('CS Worksheet'!$I$22,TRUE,G79)+SUMIF('CS Worksheet'!$I$23,TRUE,H79)","v":0}]
["3.","Total yearly amount paid for Other Extraordinary Educational Expenses ",null,null,"Mother",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,F80)+SUMIF('CS Worksheet'!$I$22,TRUE,G80)+SUMIF('CS Worksheet'!$I$23,TRUE,H80)","v":0}]
["4.","Total yearly amount paid for Tuition, Room & Board, Fees and Books",null,null,"Father",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,F81)+SUMIF('CS Worksheet'!$I$22,TRUE,G81)+SUMIF('CS Worksheet'!$I$23,TRUE,H81)","v":0}]
["5.","Total yearly amount paid for Other Extraordinary Educational Expenses ",null,null,"Father",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,F82)+SUMIF('CS Worksheet'!$I$22,TRUE,G82)+SUMIF('CS Worksheet'!$I$23,TRUE,H82)","v":0}]
["6.","Total yearly amount paid for Tuition, Room & Board, Fees and Books",null,null,"Nonparent Custodian",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,F83)+SUMIF('CS Worksheet'!$I$22,TRUE,G83)+SUMIF('CS Worksheet'!$I$23,TRUE,H83)","v":0}]
["7.","Total yearly amount paid for Other Extraordinary Educational Expenses ",null,null,"Nonparent Custodian",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,F84)+SUMIF('CS Worksheet'!$I$22,TRUE,G84)+SUMIF('CS Worksheet'!$I$23,TRUE,H84)","v":0}]
["8.","Total Yearly Amounts",null,null,null,{"$f":"IF('CS Worksheet'!$I$21=TRUE,SUM(F79:F84),0)","v":0},{"$f":"IF('CS Worksheet'!$I$22=TRUE,SUM(G79:G84),0)","v":0},{"$f":"IF('CS Worksheet'!$I$23=TRUE,SUM(H79:H84),0)","v":0},{"$f":"SUM(F85:H85)","v":0}]
["9.","Monthly Average (Divide Line 8 by 12 months)",null,null,null,{"$f":"SROUND(F85)","v":0},{"$f":"SROUND(G85)","v":0},{"$f":"SROUND(H85)","v":0},{"$f":"SUM(I87:I89)","v":0}]
["9(a).","Mother's monthly Extraordinary Educational Expenses",null,null,"Mother",{"$f":"IF('CS Worksheet'!$I$21=TRUE,SROUND((F79+F80)),0)","v":0},{"$f":"IF('CS Worksheet'!$I$22=TRUE,SROUND((G79+G80)),0)","v":0},{"$f":"IF('CS Worksheet'!$I$23=TRUE,SROUND((H79+H80)),0)","v":0},{"$f":"SUM(F87:H87)","v":0}]
["9(b).","Father's monthly Extraordinary Educational Expenses",null,null,"Father",{"$f":"IF('CS Worksheet'!$I$21=TRUE,SROUND((F81+F82)),0)","v":0},{"$f":"IF('CS Worksheet'!$I$22=TRUE,SROUND((G81+G82)),0)","v":0},{"$f":"IF('CS Worksheet'!$I$23=TRUE,SROUND((H81+H82)),0)","v":0},{"$f":"SUM(F88:H88)","v":0}]
["9(c).","Nonparent's monthly Extraordinary Educational Expenses",null,null,"Nonparent Custodian",{"$f":"IF('CS Worksheet'!$I$21=TRUE,SROUND((F83+F84)),0)","v":0},{"$f":"IF('CS Worksheet'!$I$22=TRUE,SROUND((G83+G84)),0)","v":0},{"$f":"IF('CS Worksheet'!$I$23=TRUE,SROUND((H83+H84)),0)","v":0},{"$f":"SUM(F89:H89)","v":0}]
["Extraordinary Medical Expenses","Extraordinary Medical Expenses",null,null,"Paid by",null,null,null,"Totals"]
["10.","Total yearly amount paid for extraordinary medical expenses",null,null,"Mother",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,F91)+SUMIF('CS Worksheet'!$I$22,TRUE,G91)+SUMIF('CS Worksheet'!$I$23,TRUE,H91)","v":0}]
["11.","Total yearly amount paid for extraordinary medical expenses",null,null,"Father",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,F92)+SUMIF('CS Worksheet'!$I$22,TRUE,G92)+SUMIF('CS Worksheet'!$I$23,TRUE,H92)","v":0}]
["12.","Total yearly amount paid for extraordinary medical expenses",null,null,"Nonparent Custodian",0,0,0,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,F93)+SUMIF('CS Worksheet'!$I$22,TRUE,G93)+SUMIF('CS Worksheet'!$I$23,TRUE,H93)","v":0}]
["13.","Total Yearly Amounts",null,null,null,{"$f":"IF('CS Worksheet'!$I$21=TRUE,SUM(F91:F93),0)","v":0},{"$f":"IF('CS Worksheet'!$I$22=TRUE,SUM(G91:G93),0)","v":0},{"$f":"IF('CS Worksheet'!$I$23=TRUE,SUM(H91:H93),0)","v":0},{"$f":"SUM(F94:H94)","v":0}]
["14.","Monthly Average (Divide Line 13 by 12 months)",null,null,null,{"$f":"SROUND(F94)","v":0},{"$f":"SROUND(G94)","v":0},{"$f":"SROUND(H94)","v":0},{"$f":"SUM(I96:I98)","v":0}]
["14(a).","Mother's monthly Extraordinary Medical Expenses",null,null,"Mother",{"$f":"IF('CS Worksheet'!$I$21=TRUE,SROUND(F91),0)","v":0},{"$f":"IF('CS Worksheet'!$I$22=TRUE,SROUND(G91),0)","v":0},{"$f":"IF('CS Worksheet'!$I$23=TRUE,SROUND(H91),0)","v":0},{"$f":"SUM(F96:H96)","v":0}]
["14(b).","Father's monthly Extraordinary Medical Expenses",null,null,"Father",{"$f":"IF('CS Worksheet'!$I$21=TRUE,SROUND(F92),0)","v":0},{"$f":"IF('CS Worksheet'!$I$22=TRUE,SROUND(G92),0)","v":0},{"$f":"IF('CS Worksheet'!$I$23=TRUE,SROUND(H92),0)","v":0},{"$f":"SUM(F97:H97)","v":0}]
["14(c).","Nonparent's monthly Extraordinary Medical Expenses",null,null,"Nonparent Custodian",{"$f":"IF('CS Worksheet'!$I$21=TRUE,SROUND(F93),0)","v":0},{"$f":"IF('CS Worksheet'!$I$22=TRUE,SROUND(G93),0)","v":0},{"$f":"IF('CS Worksheet'!$I$23=TRUE,SROUND(H93),0)","v":0},{"$f":"SUM(F98:H98)","v":0}]
["Special Expenses for Child Rearing (including, but not limited to summer camp, music or art lessons, band, clubs, athletics, etc.) Write brief description of expenses in yellow fields.",null,null,null,"Paid by",null,null,null,"Totals"]
["15.","Total yearly amount paid for:",null,null,"Mother",null,null,null,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,F101)+SUMIF('CS Worksheet'!$I$22,TRUE,G101)+SUMIF('CS Worksheet'!$I$23,TRUE,H101)","v":0}]
[null,null,null,null,null,0,0,0]
["16.","Total yearly amount paid for:",null,null,"Father",null,null,null,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,F103)+SUMIF('CS Worksheet'!$I$22,TRUE,G103)+SUMIF('CS Worksheet'!$I$23,TRUE,H103)","v":0}]
[null,null,null,null,null,0,0,0]
["17.","Total yearly amount paid for:",null,null,"Nonparent Custodian",null,null,null,{"$f":"SUMIF('CS Worksheet'!$I$21,TRUE,F105)+SUMIF('CS Worksheet'!$I$22,TRUE,G105)+SUMIF('CS Worksheet'!$I$23,TRUE,H105)","v":0}]
[null,null,null,null,null,0,0,0]
["18.","Total Yearly Amounts (Add Lines 15, 16  & 17)",null,null,null,{"$f":"IF('CS Worksheet'!$I$21=TRUE,SUM(F101:F105),0)","v":0},{"$f":"IF('CS Worksheet'!$I$22=TRUE,SUM(G101:G105),0)","v":0},{"$f":"IF('CS Worksheet'!$I$23=TRUE,SUM(H101:H105),0)","v":0},{"$f":"SUM(F106:H106)","v":0}]
["19.","Monthly Average (Divide Line 18 by 12 months)",null,null,null,{"$f":"SROUND(F106)","v":0},{"$f":"SROUND(G106)","v":0},{"$f":"SROUND(H106)","v":0},{"$f":"SROUND(I106)","v":0}]
[{"$f":"CONCATENATE(\"Names of Parties:  \", LEFT('CS Worksheet'!$B$4,100),\"    vs. \",'CS Worksheet'!$B$8)","v":"Names of Parties:      vs. "}]
[{"$f":"CONCATENATE(\"Submitted by:  \", 'CS Worksheet'!$F$27)","v":"Submitted by:  "},null,null,null,null,null,null,null,{"$f":"\"Today's date: \" & TEXT(TODAY(),\"mm/dd/yyyy\")","v":{"$error":"#VALUE!"}}]
[{"$f":"\"Case #:         \"& 'CS Worksheet'!K4","v":"Case #:         "},null,null,null,null,null,null,null,"Version 9.2"]

{"sheet":"Footnotes","index":11,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[[21,4,21,6]]}
["Schedule","Line No.","Footnotes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"CONCATENATE(\"Names of Parties:  \", LEFT('CS Worksheet'!$B$4,100),\"    vs. \",'CS Worksheet'!$B$8)","v":"Names of Parties:      vs. "}]
[{"$f":"CONCATENATE(\"Submitted by:  \",'CS Worksheet'!$F$27)","v":"Submitted by:  "},null,{"$f":"\"Today's date: \"&TEXT(TODAY(),\"mm/dd/yyyy\")","v":{"$error":"#VALUE!"}}]
[{"$f":"\"Case #:    \"&CONCATENATE('CS Worksheet'!$K$4)","v":"Case #:    "},null,"Version 9.2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CS Worksheet"]
["Schedule A"]
["Schedule B"]
["Schedule D"]
["Schedule D Supplemental Tables"]
["Schedule E"]
["Schedule E Supplemental Tables"]

{"sheet":"Explanation of Terms","index":12,"n_rows":68,"n_cols":2,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["Terms","Explanation"]
["Actual amount paid monthly","The amount of current child support being paid and averaged over a 12 month period as a result of a Preexisting Child Support Order that is supported by documentation including, but not limited to, a payment history from a court clerk, a IV-D agency, the Child Support Services Agency computer date base, canceled checks or other written proof of payments paid directly to the other Parent. Amounts paid on arrears are not included."]
["Adjusted Income","Adjusted income means the determination of a parent's monthly income, calculated by deducting from that parent's monthly gross income one-half of the amount of any applicable self-employment taxes being paid by the parent, any preexisting order for current child support which is being paid by the parent, and any theoretical child support order for other qualified children, if allowed by the court. For further reference see paragraph (5) of subsection (f) of this Code section."]
["Alimony","Alimony is actual payment allowances for support made under a court order and usually given by a man or woman to his former partner after a divorce or legal separation for livelihood maintenance. This amount is not considered as a deduction from the Gross Income of the Parent, but may be considered as a Deviation from the Presumptive Amount of Child Support for that Parent."]
["Basic Child Support Obligation","Basic child support obligation means the monthly amount of support displayed on the child support obligation table which corresponds to the combined adjusted income of the number of children for whom child support is being determined."]
["Child","Child means child or children who are minors and may apply to the child(ren) in this action, children who are in a pre-existing child support order or Other Qualified Child(ren)."]
["Child and Dependent Care Tax Credit","Child and Dependent Care Tax Credit means a Parent is eligible for a tax credit on their Federal Income Tax Return because they paid someone to care for a child so that they could work or look for work."]
["Child Care Expenses","Expenses for the care of a minor child for whom support is being determined in this action due to the employment, job search, training or education of either Parent. The cost may be estimated and averaged for the next consecutive 12 months to obtain a monthly amount."]
["Child Support Obligation Table","Child support obligation table means the chart in subsection (o) of O.C.G.A. § 19-6-15."]
["Child Support Services","Child support services\" means the agency within the Department of Human Resources which provides and administers child support services."]
["Child Support Worksheet","Worksheet or Child Support Worksheet means the document used to record information necessary to determine and calculate monthly child support.  For further reference see subsection (m) of O.C.G.A. § 19-6-15."]
["Children","Child means child or children who are minors and may apply to the child(ren) in this action, children who are in a pre-existing child support order or Other Qualified Child(ren)."]
["Civil Action Case Number","Civil Action Case Number for the current action: The number assigned to each legal pleading by a Clerk of Court in the various counties in the state of Georgia that identify all documents that are filed with a case. In order to submit a completed Web-based calculation to the court for a hearing, or as entered in consent by the parties or for other consideration, the Civil Action Case Number (written exactly as assigned by the Clerk) for the current action must be entered.  Civil Action Case Number for a Preexisting Child Support Order: The number assigned by a Clerk of Court in the various counties in the state of Georgia or by a Clerk in another state, that identify all documents and orders filed with a case for a Preexisting Child Support Order."]
["Combined Adjusted Income","Combined adjusted income\" means the amount of adjusted income of the custodial parent added to the amount of adjusted income of the noncustodial parent."]
["Court","The Court in Georgia where your present action will be heard and for which you are creating this child support worksheet calculation."]
["Current Case Information","The current case information identifies the plaintiff, defendant, the court, county, civil action number, Georgia Office of Child Support Services IV-D case number (if one applies), the children for whom support is sought, their dates of birth, the party submitting the calculation and today's date for the present action before the court."]
["Current Court Order Child Support Payment","The amount of child support paid as required by a court order for support. The current support payments are averaged over the past 12 months. These do not include repayment on any arrears owed."]
["Custodial Parent","Custodial parent\" means the parent with whom the child resides more than 50 percent of the time. Where a custodial parent has not been designated or where a child resides with both parents an equal amount of time, the court shall designate the custodial parent as the parent with the lesser support obligation and the other parent as the noncustodial parent. Where the child resides equally with both parents and neither parent can be determined as owing a greater amount than the other, the court shall determine which parent to designate as the custodial parent for the purpose of this Code section."]
["Date of initial child support order","The date of the \"first\" child support order entered between the parties. Subsequent orders resulting from a modification are not considered."]
["Date of initial child support order","The date of the \"first\" child support order entered between the parties. Subsequent orders resulting from a modification are not considered."]
["Defendant","The person who did not bring or file the current or present court action."]
["Deviation","Deviation means an increase or decrease from the Presumptive Amount of Child Support. Specific Deviations may be made based upon: (a) High Income (b) Low Income (c) Other Health Related Insurance (dental and vision) (d) Life Insurance (e) Child and Dependent Care Tax Credit (f) Parenting Time Related Travel Expenses (g) Alimony Paid (h) Mortgage (if the Noncustodial Parent is providing for the cost of home where the child resides) (i) Permanency Plan or Foster Care Plan.  The Court or the jury may consider other Deviations such as Extraordinary Educational, Medical and Special Expenses, Parenting Time and other Nonspecific Deviations."]
["Discretion","The Court or jury's authority to rule on evidence presented at a hearing in making a final determination of child support."]
["Existing Support Order","A child support order that exists at the time of filing of the present action and that will be considered by the court in a proceeding for modification."]
["Extraordinary Educational Expenses","Extraordinary Educational Expenses may be a basis for Deviation from the Presumptive Amount of Child Support and may include, but are not limited to tuition, room and board, lab fees, books, fees, and other expenses associated with special needs education, private elementary and secondary schooling (high school). In determining the amount of this Deviation, expenses, scholarships, grants, stipends, and other cost-reducing programs received by or on behalf of the Child will be considered and should be a monthly average and based on evidence. Evidence will consist of written documents, based on fact, used to support any adjustments and deviations used in reaching the child support calculation. If copies are used, they must be legible or readable."]
["Extraordinary Expenses","Extraordinary Expenses mean the expenses and costs, such as educational and medical, which are in excess of average amounts estimated in the Child Support Obligation Table for those families actually incurring the expense. These expenses are prorated between the Parents."]
["Father","The biological or legally adoptive, male parent of a child."]
["Final Child Support Order","Final child support order means the presumptive amount of child support adjusted by any deviations."]
["Gross Income","Gross income means all income to be included in the calculation of child support as set forth in subsection (f) of this Code section."]
["Health Insurance","Health Insurance means the cost of premiums for any general health or medical policy paid by the Mother, Father and/or Nonparent Custodian for children included in this action. Costs for vision, dental or life insurance are not considered a part of Health Insurance.  If the child's portion of the health insurance premium is not known, divide the total premium cost by the total number of persons included in the policy. Multiply that answer by the total number of children included in the policy to determine a per child premium cost. (Example: Total Monthly Health Insurance Premium of $200 divided by 4 persons = $50 per person, multiplied by 2 children covered and included in this action = $100. Answer - Each child's portion of the health insurance premium is $50 per month."]
["High Income","High Income means a Combined Adjusted Income of both Mother and Father that exceeds $30,000.00 per month."]
["Imputed Income","Imputed Income means income that is determined by using a 40 hour workweek at the minimum wage pay rate when there is no reliable evidence of income. Examples of sources used to gather reliable evidence of income may include, but are not limited to, income from tax returns for prior years, check stubs or other information for determining current ability to pay child support."]
["Income from Self Employment","Income from self-employment is gross income from business endeavors minus ordinary and reasonable expenses necessary to produce such income. Income from business endeavors include, but are not limited to, work as an independent contractor or consultant, sales of goods or services, and rental properties. Expenses necessary to produce income do not include expenses that are not considered ordinary and reasonable such as:  (i) Excessive promotional, travel, vehicle, or personal living expenses, depreciation on equipment, or costs of operation of home offices; or (ii) Amounts allowable by the Internal Revenue Service for the accelerated component of depreciation expenses, investment tax credits, or any other business expenses determined by the Court or the jury to be inappropriate for determining Gross Income.  Self-employment Taxes are those deductions from total monthly gross income of the self employed person for payment of FICA and Medicare. Only one-half of the Self-Employment and Medicare taxes shall be deducted. (See IRS Publication No. 533 for years after 2006.)"]
["IV-D Case Number","A unique case number issued and used by the Georgia Office of Child Support Services (OCSS) and assigned to cases maintained on their Support Tracking and Reporting System ($TARS) when a valid application for services has been made to the agency by a Parent or a Nonparent Custodian, or when a referral has been made to OCSS by the Georgia Division of Family and Children Services (DFCS)."]
["Life Insurance","Life Insurance means that either Parent has purchased life insurance for themselves with the Child as beneficiary."]
["Medical Expenses","Extraordinary Medical Expenses can be considered a deviation for cases involving extraordinary medical needs of the child of a Parent's current family or of the Parent, that are not covered by insurance."]
["Modification","Modification means reviewing an established court order for support using current information of the Mother, Father, Nonparent Custodian and Child(ren), and determining whether or not the support obligation should increase, decrease or remain unchanged."]
["Mortgage","Mortgage means that the Noncustodial Parent is providing shelter, such as paying the mortgage of the home, or has provided a home at no cost to the Custodial Parent in which the Child in this action resides."]
["Mother","The biological or legally adoptive, female parent of a child."]
["Noncustodial Parent","Noncustodial Parent means the Parent with whom the Child resides less than 50 percent of the time or the Parent who has the payment obligation for child support."]
["Nonparent Custodian","Noncustodial parent means the parent with whom the child resides less than 50 percent of the time or the parent who has the greater payment obligation for child support. Where the child resides equally with both parents and neither parent can be determined as owing a lesser amount than the other, the court shall determine which parent to designate as the noncustodial parent for the purpose of this Code section."]
["Non-specific Deviations","Non-Specific Deviations is a deviation from the Presumptive Amount of Child Support, and other than those already identified, that may be appropriate, and that the court of jury finds are in the best interest of the child in this action."]
["Other Health Related Insurance","Other Health Related Insurance means vision or dental insurance available at a reasonable cost for the Child as provided by the Mother, Father or Nonparent Custodian."]
["Other qualified children","Qualified Child or Qualified Children means any Child: (A) For whom the Parent is legally responsible; (B) That lives in the parent's home; (C) That the parent is actually supporting the child; (D) That is not subject to a Preexisting Child Support Order, and; (E) That is not currently before the court to set, modify or enforce child support.  All five (5) criteria must be met in order to claim a Child as a Qualified Child for a Theoretical Support Order.  If a child living in the parents home is subject to a Preexisting Order, but that order is not actually being paid by the parent in another case who owes the duty of support, then that child may be consider an 'Other Qualified Child'."]
["other source of income","Other Sources of Income, whether earned or unearned, may include, but are not limited to, the following:  (i) Salaries; (ii) Commissions, fees, and tips; (iii) Income from self-employment; (iv) Bonuses; (v) Overtime payments; (vi) Severance pay; (vi) Severance pay; (viii) Interest income; (viii) Interest income; (ix) Dividend income; (x) Trust income; (xi) Income from annuities; (xii) Capital gains; (xiii) Disability or retirement benefits that are received from the Social Security Administration pursuant to Title II of the federal Social Security Act; (xiv) Workers´ compensation benefits, whether temporary or permanent; (xv) Unemployment insurance benefits; (xvi) Judgments recovered for personal injuries and awards from other civil actions; (xvii) Gifts that consist of cash or other liquid instruments, or which can be converted to cash; (xviii) Prizes; (xix) Lottery winnings; (xx) Alimony or maintenance received from persons other than parties to the proceeding before the Court; and (xxi) Assets which are used for the support of the family."]
["Parent ","Parent means a person who owes a child a duty of support pursuant to Code Section 19-7-2."]
["Parenting Time Adjustment","Parenting Time Adjustment is a Deviation from a Parent's portion of the Basic Child Support Obligation based upon the Noncustodial Parent's court ordered visitation with a Child included in this action. NOTE: The Office of Child Support Services will not be involved with any action or claim related to visitation, including actions for contempt brought by the custodial parent against the non-custodial parent for failure to exercise the court ordered visitation upon which the parenting time adjustment deviation is based. The OCSS will apply the parenting time adjustment deviation to the presumptive amount of child support when there is a court order for visitation and the parents agree on the amount of the parenting time adjustment deviation to be applied. If both these criteria are not met, then OCSS will direct the parents to the court and will not apply the Parenting Time Adjustment Deviation."]
["Parenting Time Deviation","Parenting time deviation means a deviation from the noncustodial parent's portion of the basic child support obligation based upon the noncustodial parent's court ordered visitation with the child. For further reference see subsections (g) and (i) of this Code section."]
["Permanency Plan or Foster Care Plan","Permanency Plan or Foster Care Plan means the cost incurred in assisting a parent in regaining custody of a child who is in the legal custody of the Georgia Department of Human Resources (the Division of Family and Children Services-DFCS), the child protection or foster care agency of another state or territory, or any other child-caring entity, public or private. This total amount may be considered a deviation."]
["Plaintiff","The person who is bringing or intends to file the current or present action."]
["Preexisting Order","Preexisting order means:  (A) An order in another case that requires a parent to make child support payments for another child, which child support the parent is actually paying, as evidenced by documentation as provided in division (f)(5)(B)(iii) of this Code section; and (B) That the date and time of filing with the clerk of court of the initial order for each such other case is earlier than the date and time of filing with the clerk of court of the initial order in the case immediately before the court, regardless of the age of any child in any of the cases."]
["Presumptive Amount of Child Support","Presumptive amount of child support means the basic child support obligation including health insurance and work related child care costs."]
["Qualified Child","Qualified children means any child: (A) For whom the parent is legally responsible and in whose home the child resides; (B) That the parent is actually supporting; (C) Who is not subject to a preexisting order; and (D) Who is not before the court to set, modify, or enforce support in the case immediately under consideration.  Qualified children shall not include stepchildren or other minors in the home that the parent has no legal obligation to support."]
["Qualified Children","Qualified children means any child: (A) For whom the parent is legally responsible and in whose home the child resides; (B) That the parent is actually supporting; (C) Who is not subject to a preexisting order; and (D) Who is not before the court to set, modify, or enforce support in the case immediately under consideration.  Qualified children shall not include stepchildren or other minors in the home that the parent has no legal obligation to support."]
["Representative","Note: person entering data for mother, father, or nonparent custodian…"]
["Salary and Wages","Gross Income includes all income from any source, before deductions for allowable taxes and excludes needs based income such as Supplemental Security Income and TANF."]
["Self Employment Taxes for FICA & Medicare","The credit for self-employment taxes is calculated by deducting from that Parent's monthly gross income, one-half of the amounts of self-employment taxes paid by a Parent for FICA and Medicare.  The amount of self-employment taxes paid can be found on your previous year Federal Tax Form 1040, Schedule SE, Line 4. If you reported less than $400 self-employment income in the previous tax year, you will not enter an amount on Child Support Schedule B, Line 2.  For the maximum amount of self-employment income that is subject to Social Security tax, see IRS Publication 533 for the current taxable year. NOTE: The Office of Child Support Services updates the self-employment tax formula on January 1 of each calendar year."]
["Social Security Disability or Retirement Benefits","Social Security Disability or Retirement benefits received as part of Title II OASDI program which provides protection against the loss of income of earnings due to retirement, disability and death as income intended to replace a portion of lost earnings which is based on taxable earnings during a persons' lifetime. (Disability insurance or retirement benefits should not be confused with SSI, which is not considered income."]
["Special Expenses for Child Rearing","Special Expenses for Child Rearing means expenses incurred for child rearing related to food, clothing, and hygiene costs of children at different age levels that may include, but are not limited to, summer camp; music or art lessons; travel; school sponsored extracurricular activities, such as band, clubs, and athletics; and other activities intended to enhance the athletic, social, or cultural development of a Child. In order to determine if a Deviation for special expenses is warranted, the Court or the jury will consider the full amount of the special expenses; and when these special expenses exceed 7 percent of the monthly Basic Child Support Obligation, the additional amount may be considered as a Deviation to cover the total of special expenses."]
["Split Parenting","Split parenting can occur in a child support case only if there are two or more children of the same parents, where one parent is the custodial parent for at least one child of the parents, and the other parent is the custodial parent for at least one other child of the parents. In a split parenting case, each parent is the custodial parent of any child spending more than 50 percent of the time with that parent and is the noncustodial parent of any child spending more than 50 percent of the time with the other parent. A split parenting situation shall have two custodial parents and two noncustodial parents, but no child shall have more than one custodial parent or noncustodial parent."]
["STARS Case Number","A unique case number issued and used by the Georgia Office of Child Support Services (OCSS) and assigned to cases maintained on their Support Tracking and Reporting System ($TARS) when a valid application for services has been made to the agency by a Parent or a Nonparent Custodian, or when a referral has been made to OCSS by the Georgia Division of Family and Children Services (DFCS)."]
["TANF (Temporary Assistance for Needy Families)","Temporary Assistance for Needy Families (TANF) is a benefit paid to a person who qualifies through the Georgia Division of Family of Children Services (DFCS) or similar programs in other states or territories under Title IV-A of the federal Social Security Act. This benefit does not include Medicaid or Food Stamps."]
["Theoretical Child Support Order","Theoretical child support order means a hypothetical child support order for qualified children calculated as set forth in subparagraph (f)(5)(C) of this Code section which allows the court to determine the amount of child support as if a child support order existed."]
["Title II Social Security Benefits","Old age, survivors and disability benefits for a child who is either unmarried and has not attained the age of 18, is still in secondary school and under 19 years of age, or is under a disability which began before he attained the age of 22 years of age. The child must also be a dependent of the insured individual."]
["Uninsured Health Care Expenses","Uninsured health care expenses means a child's uninsured medical expenses including, but not limited to, health insurance copayments, deductibles, and such other costs as are reasonably necessary for orthodontia, dental treatment, asthma treatments, physical therapy, vision care, and any acute or chronic medical or health problem or mental health illness, including counseling and other medical or mental health expenses, that are not covered by insurance. For further reference see paragraph (3) of subsection (h) of this Code section."]
["Visitation Related Travel Expenses","Visitation Related Travel Expenses means travel expenses related to Court ordered visitation that are substantial in cost due to the distance between the Parents. The Court may order the allocation of such costs as a Deviation, taking into consideration the circumstances of the respective Parents as well as which Parent moved and the reason for such move."]
["Work Related Child Costs","Work related child care costs means expenses for the care of the child for whom support is being determined which are due to employment of either parent. In an appropriate case, the court may consider the child care costs associated with a parent's job search or the training or education of a parent necessary to obtain a job or enhance earning potential, not to exceed a reasonable time as determined by the court, if the parent proves by a preponderance of the evidence that the job search, job training, or education will benefit the child being supported. The term shall be projected for the next consecutive 12 months and averaged to obtain a monthly amount. For further reference see paragraph (1) of subsection (h) of this Code section."]
["Worksheet","Worksheet or Child Support Worksheet means the document used to record information necessary to determine and calculate monthly child support.  For further reference see subsection (m) of O.C.G.A. § 19-6-15."]

{"sheet":"BCSO","index":13,"n_rows":594,"n_cols":8,"rows_kept":594,"cut":false,"hidden":false,"merged":[[0,0,1,7],[2,0,2,7],[3,0,3,7]]}
["Georgia"]
[]
["Schedule of Basic Child Support Obligations"]
[]
["COMBINED"]
["ADJUSTED",null,"ONE","TWO","THREE","FOUR","FIVE","SIX"]
["GROSS",null,"CHILD","CHILDREN","CHILDREN","CHILDREN","CHILDREN","CHILDREN"]
["INCOME"]
[0,null,0,0,0,0,0,0]
[800,null,197,283,330,367,404,440]
[850,null,208,298,347,387,425,463]
[900,null,218,313,364,406,447,486]
[950,null,229,328,381,425,468,509]
[1000,null,239,343,398,444,489,532]
[1050,null,250,357,415,463,510,554]
[1100,null,260,372,432,482,530,577]
[1150,null,270,387,449,501,551,600]
[1200,null,280,401,466,520,572,622]
[1250,null,291,416,483,539,593,645]
[1300,null,301,431,500,558,614,668]
[1350,null,311,445,517,577,634,690]
[1400,null,321,459,533,594,654,711]
[1450,null,331,473,549,612,673,733]
[1500,null,340,487,565,630,693,754]
[1550,null,350,500,581,647,712,775]
[1600,null,360,514,597,665,732,796]
[1650,null,369,528,612,683,751,817]
[1700,null,379,542,628,701,771,838]
[1750,null,389,555,644,718,790,860]
[1800,null,398,569,660,736,809,881]
[1850,null,408,583,676,754,829,902]
[1900,null,418,596,692,771,848,923]
[1950,null,427,610,708,789,868,944]
[2000,null,437,624,723,807,887,965]
[2050,null,446,637,739,824,906,986]
[2100,null,455,650,754,840,924,1006]
[2150,null,465,663,769,857,943,1026]
[2200,null,474,676,783,873,961,1045]
[2250,null,483,688,798,890,979,1065]
[2300,null,492,701,813,907,997,1085]
[2350,null,501,714,828,923,1016,1105]
[2400,null,510,727,843,940,1034,1125]
[2450,null,519,740,858,956,1052,1145]
[2500,null,528,752,873,973,1070,1165]
[2550,null,537,765,888,990,1089,1184]
[2600,null,547,778,902,1006,1107,1204]
[2650,null,556,791,917,1023,1125,1224]
[2700,null,565,804,932,1039,1143,1244]
[2750,null,574,816,947,1056,1162,1264]
[2800,null,583,829,962,1073,1180,1284]
[2850,null,592,842,977,1089,1198,1303]
[2900,null,601,855,992,1106,1216,1323]
[2950,null,611,868,1006,1122,1234,1343]
[3000,null,620,881,1021,1139,1253,1363]
[3050,null,629,893,1036,1155,1271,1383]
[3100,null,638,906,1051,1172,1289,1402]
[3150,null,647,919,1066,1188,1307,1422]
[3200,null,655,930,1079,1203,1323,1440]
[3250,null,663,941,1092,1217,1339,1457]
[3300,null,671,952,1104,1231,1355,1474]
[3350,null,679,963,1117,1246,1370,1491]
[3400,null,687,974,1130,1260,1386,1508]
[3450,null,694,985,1143,1274,1402,1525]
[3500,null,702,996,1155,1288,1417,1542]
[3550,null,710,1008,1168,1303,1433,1559]
[3600,null,718,1019,1181,1317,1448,1576]
[3650,null,726,1030,1194,1331,1464,1593]
[3700,null,734,1041,1207,1345,1480,1610]
[3750,null,741,1051,1219,1359,1495,1627]
[3800,null,749,1062,1231,1373,1510,1643]
[3850,null,756,1072,1243,1386,1525,1659]
[3900,null,764,1083,1255,1400,1540,1675]
[3950,null,771,1093,1267,1413,1555,1691]
[4000,null,779,1104,1280,1427,1569,1707]
[4050,null,786,1114,1292,1440,1584,1724]
[4100,null,794,1125,1304,1454,1599,1740]
[4150,null,801,1135,1316,1467,1614,1756]
[4200,null,809,1146,1328,1481,1629,1772]
[4250,null,816,1156,1340,1494,1643,1788]
[4300,null,824,1167,1352,1508,1658,1804]
[4350,null,831,1177,1364,1521,1673,1820]
[4400,null,839,1188,1376,1534,1688,1836]
[4450,null,846,1198,1388,1548,1703,1853]
[4500,null,853,1209,1400,1561,1718,1869]
[4550,null,861,1219,1412,1575,1732,1885]
[4600,null,868,1230,1425,1588,1747,1901]
[4650,null,876,1240,1437,1602,1762,1917]
[4700,null,883,1251,1449,1615,1777,1933]
[4750,null,891,1261,1461,1629,1792,1949]
[4800,null,898,1271,1473,1642,1807,1966]
[4850,null,906,1282,1485,1656,1821,1982]
[4900,null,911,1289,1493,1664,1831,1992]
[4950,null,914,1293,1496,1668,1835,1997]
[5000,null,917,1297,1500,1672,1839,2001]
[5050,null,921,1300,1503,1676,1844,2006]
[5100,null,924,1304,1507,1680,1848,2011]
[5150,null,927,1308,1510,1684,1852,2015]
[5200,null,930,1312,1514,1688,1857,2020]
[5250,null,934,1316,1517,1692,1861,2025]
[5300,null,937,1320,1521,1696,1865,2029]
[5350,null,940,1323,1524,1700,1870,2034]
[5400,null,943,1327,1528,1704,1874,2039]
[5450,null,947,1331,1531,1708,1878,2044]
[5500,null,950,1335,1535,1711,1883,2048]
[5550,null,953,1339,1538,1715,1887,2053]
[5600,null,956,1342,1542,1719,1891,2058]
[5650,null,960,1347,1546,1724,1896,2063]
[5700,null,964,1352,1552,1731,1904,2071]
[5750,null,968,1357,1558,1737,1911,2079]
[5800,null,971,1363,1564,1744,1918,2087]
[5850,null,975,1368,1570,1750,1925,2094]
[5900,null,979,1373,1575,1757,1932,2102]
[5950,null,983,1379,1581,1763,1939,2110]
[6000,null,987,1384,1587,1770,1947,2118]
[6050,null,991,1389,1593,1776,1954,2126]
[6100,null,995,1394,1599,1783,1961,2133]
[6150,null,999,1400,1605,1789,1968,2141]
[6200,null,1003,1405,1610,1796,1975,2149]
[6250,null,1007,1410,1616,1802,1982,2157]
[6300,null,1011,1416,1622,1809,1989,2164]
[6350,null,1015,1421,1628,1815,1996,2172]
[6400,null,1018,1426,1633,1821,2003,2180]
[6450,null,1023,1432,1639,1828,2011,2188]
[6500,null,1027,1437,1646,1835,2018,2196]
[6550,null,1031,1442,1652,1841,2026,2204]
[6600,null,1035,1448,1658,1848,2033,2212]
[6650,null,1039,1453,1664,1855,2040,2220]
[6700,null,1043,1459,1670,1862,2048,2228]
[6750,null,1047,1464,1676,1869,2055,2236]
[6800,null,1051,1470,1682,1875,2063,2244]
[6850,null,1055,1475,1688,1882,2070,2252]
[6900,null,1059,1480,1694,1889,2078,2260]
[6950,null,1063,1486,1700,1896,2085,2269]
[7000,null,1067,1491,1706,1902,2092,2277]
[7050,null,1071,1497,1712,1909,2100,2285]
[7100,null,1075,1502,1718,1916,2107,2293]
[7150,null,1079,1508,1724,1923,2115,2301]
[7200,null,1083,1513,1730,1929,2122,2309]
[7250,null,1087,1518,1736,1936,2130,2317]
[7300,null,1092,1524,1742,1943,2137,2325]
[7350,null,1096,1529,1748,1950,2144,2333]
[7400,null,1100,1535,1755,1956,2152,2341]
[7450,null,1104,1540,1761,1963,2159,2349]
[7500,null,1108,1546,1767,1970,2167,2357]
[7550,null,1112,1552,1773,1977,2175,2366]
[7600,null,1116,1556,1778,1983,2181,2373]
[7650,null,1117,1557,1779,1984,2182,2375]
[7700,null,1118,1559,1781,1986,2184,2376]
[7750,null,1119,1560,1782,1987,2186,2378]
[7800,null,1120,1562,1784,1989,2188,2380]
[7850,null,1122,1563,1785,1990,2189,2382]
[7900,null,1123,1565,1786,1992,2191,2384]
[7950,null,1124,1566,1788,1993,2193,2386]
[8000,null,1125,1567,1789,1995,2194,2387]
[8050,null,1127,1569,1790,1996,2196,2389]
[8100,null,1128,1570,1792,1998,2198,2391]
[8150,null,1129,1572,1793,1999,2199,2393]
[8200,null,1130,1573,1795,2001,2201,2395]
[8250,null,1131,1575,1796,2003,2203,2397]
[8300,null,1133,1576,1797,2004,2204,2398]
[8350,null,1134,1578,1799,2006,2206,2400]
[8400,null,1135,1579,1800,2007,2208,2402]
[8450,null,1136,1580,1802,2009,2210,2404]
[8500,null,1138,1582,1803,2010,2211,2406]
[8550,null,1139,1583,1804,2012,2213,2408]
[8600,null,1140,1585,1806,2013,2215,2410]
[8650,null,1141,1586,1807,2015,2216,2411]
[8700,null,1142,1588,1808,2016,2218,2413]
[8750,null,1144,1589,1810,2018,2220,2415]
[8800,null,1145,1591,1811,2019,2221,2417]
[8850,null,1146,1592,1813,2021,2223,2419]
[8900,null,1147,1593,1814,2023,2225,2421]
[8950,null,1149,1595,1815,2024,2226,2422]
[9000,null,1150,1596,1817,2026,2228,2424]
[9050,null,1153,1601,1822,2032,2235,2431]
[9100,null,1159,1609,1831,2042,2246,2443]
[9150,null,1164,1617,1840,2052,2257,2455]
[9200,null,1170,1624,1849,2062,2268,2467]
[9250,null,1175,1632,1858,2071,2279,2479]
[9300,null,1181,1640,1867,2081,2290,2491]
[9350,null,1187,1648,1876,2091,2301,2503]
[9400,null,1192,1656,1885,2101,2311,2515]
[9450,null,1198,1663,1894,2111,2322,2527]
[9500,null,1203,1671,1902,2121,2333,2539]
[9550,null,1209,1679,1911,2131,2344,2551]
[9600,null,1214,1687,1920,2141,2355,2563]
[9650,null,1220,1694,1929,2151,2366,2574]
[9700,null,1226,1702,1938,2161,2377,2586]
[9750,null,1231,1710,1947,2171,2388,2598]
[9800,null,1237,1718,1956,2181,2399,2610]
[9850,null,1242,1725,1965,2191,2410,2622]
[9900,null,1248,1733,1974,2201,2421,2634]
[9950,null,1253,1741,1983,2211,2432,2646]
[10000,null,1259,1749,1992,2221,2443,2658]
[10050,null,1264,1757,2001,2231,2454,2670]
[10100,null,1270,1764,2010,2241,2465,2682]
[10150,null,1276,1772,2019,2251,2476,2694]
[10200,null,1281,1780,2028,2261,2487,2706]
[10250,null,1287,1788,2036,2271,2498,2718]
[10300,null,1292,1795,2045,2281,2509,2729]
[10350,null,1298,1803,2054,2291,2520,2741]
[10400,null,1303,1811,2063,2301,2531,2753]
[10450,null,1309,1819,2072,2311,2542,2765]
[10500,null,1313,1825,2079,2318,2550,2774]
[10550,null,1317,1830,2085,2325,2557,2782]
[10600,null,1321,1835,2091,2331,2564,2790]
[10650,null,1325,1841,2096,2338,2571,2798]
[10700,null,1329,1846,2102,2344,2578,2805]
[10750,null,1332,1851,2108,2351,2586,2813]
[10800,null,1336,1856,2114,2357,2593,2821]
[10850,null,1340,1862,2120,2364,2600,2829]
[10900,null,1344,1867,2126,2370,2607,2836]
[10950,null,1348,1872,2131,2377,2614,2844]
[11000,null,1351,1877,2137,2383,2621,2852]
[11050,null,1355,1883,2143,2390,2628,2860]
[11100,null,1359,1888,2149,2396,2636,2868]
[11150,null,1363,1893,2155,2403,2643,2875]
[11200,null,1367,1898,2161,2409,2650,2883]
[11250,null,1371,1904,2166,2415,2657,2891]
[11300,null,1374,1909,2172,2422,2664,2899]
[11350,null,1378,1914,2178,2428,2671,2906]
[11400,null,1382,1919,2184,2435,2678,2914]
[11450,null,1386,1925,2190,2441,2686,2922]
[11500,null,1390,1930,2195,2448,2693,2930]
[11550,null,1394,1935,2201,2454,2700,2938]
[11600,null,1397,1940,2207,2461,2707,2945]
[11650,null,1401,1946,2213,2467,2714,2953]
[11700,null,1405,1951,2219,2474,2721,2961]
[11750,null,1409,1956,2225,2480,2728,2969]
[11800,null,1413,1961,2230,2487,2736,2976]
[11850,null,1417,1967,2236,2493,2743,2984]
[11900,null,1420,1972,2242,2500,2750,2992]
[11950,null,1424,1977,2248,2506,2757,3000]
[12000,null,1428,1982,2254,2513,2764,3007]
[12050,null,1432,1988,2260,2519,2771,3015]
[12100,null,1436,1993,2265,2526,2779,3023]
[12150,null,1439,1998,2271,2532,2786,3031]
[12200,null,1443,2003,2277,2539,2793,3039]
[12250,null,1447,2009,2283,2545,2800,3046]
[12300,null,1451,2014,2289,2552,2807,3054]
[12350,null,1455,2019,2295,2558,2814,3062]
[12400,null,1459,2024,2300,2565,2821,3070]
[12450,null,1462,2030,2306,2571,2829,3077]
[12500,null,1466,2035,2312,2578,2836,3085]
[12550,null,1470,2040,2318,2584,2843,3093]
[12600,null,1474,2045,2324,2591,2850,3101]
[12650,null,1477,2050,2329,2597,2857,3108]
[12700,null,1481,2055,2335,2603,2863,3115]
[12750,null,1484,2060,2340,2609,2870,3123]
[12800,null,1487,2064,2345,2615,2877,3130]
[12850,null,1491,2069,2351,2621,2883,3137]
[12900,null,1494,2074,2356,2627,2890,3144]
[12950,null,1497,2078,2361,2633,2896,3151]
[13000,null,1501,2083,2367,2639,2903,3158]
[13050,null,1504,2087,2372,2645,2909,3165]
[13100,null,1507,2092,2377,2651,2916,3172]
[13150,null,1510,2097,2383,2657,2922,3180]
[13200,null,1514,2101,2388,2663,2929,3187]
[13250,null,1517,2106,2393,2668,2935,3193]
[13300,null,1520,2110,2398,2674,2941,3200]
[13350,null,1523,2114,2403,2679,2947,3206]
[13400,null,1526,2118,2408,2685,2953,3213]
[13450,null,1529,2123,2413,2690,2959,3220]
[13500,null,1532,2127,2418,2696,2965,3226]
[13550,null,1535,2131,2423,2701,2971,3233]
[13600,null,1538,2136,2428,2707,2977,3239]
[13650,null,1541,2140,2432,2712,2983,3246]
[13700,null,1544,2144,2437,2718,2989,3253]
[13750,null,1547,2148,2442,2723,2996,3259]
[13800,null,1550,2153,2447,2729,3002,3266]
[13850,null,1553,2157,2452,2734,3008,3272]
[13900,null,1556,2161,2457,2740,3014,3279]
[13950,null,1559,2166,2462,2745,3020,3285]
[14000,null,1562,2170,2467,2751,3026,3292]
[14050,null,1565,2174,2472,2756,3032,3299]
[14100,null,1568,2178,2477,2762,3038,3305]
[14150,null,1571,2183,2482,2767,3044,3312]
[14200,null,1574,2187,2487,2773,3050,3318]
[14250,null,1577,2191,2492,2778,3056,3325]
[14300,null,1581,2195,2497,2784,3062,3332]
[14350,null,1584,2200,2502,2789,3068,3338]
[14400,null,1587,2204,2506,2795,3074,3345]
[14450,null,1590,2208,2511,2800,3080,3351]
[14500,null,1593,2213,2516,2806,3086,3358]
[14550,null,1596,2217,2521,2811,3092,3365]
[14600,null,1599,2221,2526,2817,3098,3371]
[14650,null,1602,2225,2531,2822,3104,3378]
[14700,null,1605,2230,2536,2828,3111,3384]
[14750,null,1608,2234,2541,2833,3117,3391]
[14800,null,1611,2238,2546,2839,3123,3397]
[14850,null,1614,2243,2551,2844,3129,3404]
[14900,null,1617,2247,2556,2850,3135,3411]
[14950,null,1620,2251,2561,2855,3141,3417]
[15000,null,1623,2255,2566,2861,3147,3424]
[15050,null,1626,2260,2571,2866,3153,3430]
[15100,null,1629,2264,2576,2872,3159,3437]
[15150,null,1632,2268,2581,2877,3165,3444]
[15200,null,1635,2272,2585,2883,3171,3450]
[15250,null,1638,2277,2590,2888,3177,3457]
[15300,null,1641,2281,2595,2894,3183,3463]
[15350,null,1644,2285,2600,2899,3189,3470]
[15400,null,1647,2290,2605,2905,3195,3476]
[15450,null,1650,2294,2610,2910,3201,3483]
[15500,null,1653,2298,2615,2916,3207,3490]
[15550,null,1656,2302,2620,2921,3213,3496]
[15600,null,1659,2307,2625,2927,3219,3503]
[15650,null,1663,2311,2630,2932,3226,3509]
[15700,null,1666,2315,2635,2938,3232,3516]
[15750,null,1669,2320,2640,2943,3238,3523]
[15800,null,1672,2324,2645,2949,3244,3529]
[15850,null,1675,2328,2650,2954,3250,3536]
[15900,null,1678,2332,2655,2960,3256,3542]
[15950,null,1681,2337,2659,2965,3262,3549]
[16000,null,1684,2341,2664,2971,3268,3555]
[16050,null,1687,2345,2669,2976,3274,3562]
[16100,null,1690,2349,2674,2982,3280,3569]
[16150,null,1692,2353,2678,2986,3285,3574]
[16200,null,1695,2356,2682,2990,3289,3579]
[16250,null,1698,2360,2686,2994,3294,3584]
[16300,null,1700,2363,2689,2999,3299,3589]
[16350,null,1703,2367,2693,3003,3303,3594]
[16400,null,1706,2370,2697,3007,3308,3599]
[16450,null,1708,2374,2701,3011,3313,3604]
[16500,null,1711,2377,2705,3016,3317,3609]
[16550,null,1714,2381,2708,3020,3322,3614]
[16600,null,1716,2384,2712,3024,3327,3619]
[16650,null,1719,2388,2716,3028,3331,3624]
[16700,null,1722,2391,2720,3033,3336,3630]
[16750,null,1724,2395,2724,3037,3341,3635]
[16800,null,1727,2398,2728,3041,3345,3640]
[16850,null,1730,2402,2731,3045,3350,3645]
[16900,null,1732,2405,2735,3050,3355,3650]
[16950,null,1735,2409,2739,3054,3359,3655]
[17000,null,1737,2412,2743,3058,3364,3660]
[17050,null,1740,2416,2747,3062,3369,3665]
[17100,null,1743,2419,2750,3067,3373,3670]
[17150,null,1745,2423,2754,3071,3378,3675]
[17200,null,1748,2426,2758,3075,3383,3680]
[17250,null,1751,2430,2762,3079,3387,3685]
[17300,null,1753,2433,2766,3084,3392,3691]
[17350,null,1756,2437,2769,3088,3397,3696]
[17400,null,1759,2440,2773,3092,3401,3701]
[17450,null,1761,2444,2777,3096,3406,3706]
[17500,null,1764,2447,2781,3101,3411,3711]
[17550,null,1767,2451,2785,3105,3415,3716]
[17600,null,1769,2454,2788,3109,3420,3721]
[17650,null,1772,2458,2792,3113,3425,3726]
[17700,null,1774,2461,2796,3118,3429,3731]
[17750,null,1777,2465,2800,3122,3434,3736]
[17800,null,1780,2468,2804,3126,3439,3741]
[17850,null,1782,2472,2808,3130,3443,3746]
[17900,null,1785,2475,2811,3135,3448,3752]
[17950,null,1788,2478,2815,3139,3453,3757]
[18000,null,1790,2482,2819,3143,3457,3762]
[18050,null,1793,2485,2823,3147,3462,3767]
[18100,null,1796,2489,2827,3152,3467,3772]
[18150,null,1798,2492,2830,3156,3471,3777]
[18200,null,1801,2496,2834,3160,3476,3782]
[18250,null,1804,2499,2838,3164,3481,3787]
[18300,null,1806,2503,2842,3169,3485,3792]
[18350,null,1809,2506,2846,3173,3490,3797]
[18400,null,1812,2510,2849,3177,3495,3802]
[18450,null,1814,2513,2853,3181,3499,3807]
[18500,null,1817,2517,2857,3186,3504,3813]
[18550,null,1819,2520,2861,3190,3509,3818]
[18600,null,1822,2524,2865,3194,3513,3823]
[18650,null,1825,2527,2868,3198,3518,3828]
[18700,null,1827,2531,2872,3203,3523,3833]
[18750,null,1830,2534,2876,3207,3528,3838]
[18800,null,1833,2538,2880,3211,3532,3843]
[18850,null,1835,2541,2884,3215,3537,3848]
[18900,null,1838,2545,2888,3220,3542,3853]
[18950,null,1841,2548,2891,3224,3546,3858]
[19000,null,1843,2552,2895,3228,3551,3863]
[19050,null,1846,2555,2899,3232,3556,3868]
[19100,null,1849,2559,2903,3237,3560,3874]
[19150,null,1851,2562,2907,3241,3565,3879]
[19200,null,1854,2566,2910,3245,3570,3884]
[19250,null,1856,2569,2914,3249,3574,3889]
[19300,null,1859,2573,2918,3254,3579,3894]
[19350,null,1862,2576,2922,3258,3584,3899]
[19400,null,1864,2580,2926,3262,3588,3904]
[19450,null,1867,2583,2929,3266,3593,3909]
[19500,null,1870,2587,2933,3271,3598,3914]
[19550,null,1872,2590,2937,3275,3602,3919]
[19600,null,1875,2594,2941,3279,3607,3924]
[19650,null,1878,2597,2945,3283,3612,3929]
[19700,null,1880,2601,2948,3288,3616,3935]
[19750,null,1883,2604,2952,3292,3621,3940]
[19800,null,1886,2608,2956,3296,3626,3945]
[19850,null,1888,2611,2960,3300,3630,3950]
[19900,null,1891,2615,2964,3305,3635,3955]
[19950,null,1893,2618,2967,3309,3640,3960]
[20000,null,1896,2622,2971,3313,3644,3965]
[20050,null,1899,2625,2975,3317,3649,3970]
[20100,null,1901,2628,2979,3321,3654,3975]
[20150,null,1904,2632,2983,3326,3658,3980]
[20200,null,1907,2635,2987,3330,3663,3985]
[20250,null,1909,2639,2990,3334,3668,3990]
[20300,null,1912,2642,2994,3338,3672,3996]
[20350,null,1915,2646,2998,3343,3677,4001]
[20400,null,1917,2649,3002,3347,3682,4006]
[20450,null,1920,2653,3006,3351,3686,4011]
[20500,null,1923,2656,3009,3355,3691,4016]
[20550,null,1925,2660,3013,3360,3696,4021]
[20600,null,1928,2663,3017,3364,3700,4026]
[20650,null,1931,2667,3021,3368,3705,4031]
[20700,null,1933,2670,3025,3372,3710,4036]
[20750,null,1936,2674,3028,3377,3714,4041]
[20800,null,1938,2677,3032,3381,3719,4046]
[20850,null,1941,2681,3036,3385,3724,4051]
[20900,null,1944,2684,3040,3389,3728,4056]
[20950,null,1946,2688,3044,3394,3733,4062]
[21000,null,1949,2691,3047,3398,3738,4067]
[21050,null,1952,2695,3051,3402,3742,4072]
[21100,null,1954,2698,3055,3406,3747,4077]
[21150,null,1957,2702,3059,3411,3752,4082]
[21200,null,1960,2705,3063,3415,3756,4087]
[21250,null,1962,2709,3067,3419,3761,4092]
[21300,null,1965,2712,3070,3423,3766,4097]
[21350,null,1968,2716,3074,3428,3770,4102]
[21400,null,1970,2719,3078,3432,3775,4107]
[21450,null,1973,2723,3082,3436,3780,4112]
[21500,null,1975,2726,3086,3440,3784,4117]
[21550,null,1978,2730,3089,3445,3789,4123]
[21600,null,1981,2733,3093,3449,3794,4128]
[21650,null,1983,2737,3097,3453,3798,4133]
[21700,null,1986,2740,3101,3457,3803,4138]
[21750,null,1989,2744,3105,3462,3808,4143]
[21800,null,1991,2747,3108,3466,3812,4148]
[21850,null,1994,2751,3112,3470,3817,4153]
[21900,null,1997,2754,3116,3474,3822,4158]
[21950,null,1999,2758,3120,3479,3827,4163]
[22000,null,2002,2761,3124,3483,3831,4168]
[22050,null,2005,2765,3127,3487,3836,4173]
[22100,null,2007,2768,3131,3491,3841,4178]
[22150,null,2010,2772,3135,3496,3845,4184]
[22200,null,2012,2775,3139,3500,3850,4189]
[22250,null,2015,2779,3143,3504,3855,4194]
[22300,null,2018,2782,3147,3508,3859,4199]
[22350,null,2020,2785,3150,3513,3864,4204]
[22400,null,2022,2788,3153,3515,3867,4207]
[22450,null,2024,2790,3155,3517,3869,4210]
[22500,null,2025,2792,3157,3520,3872,4212]
[22550,null,2027,2793,3158,3522,3874,4215]
[22600,null,2028,2795,3160,3524,3876,4217]
[22650,null,2029,2797,3162,3526,3878,4220]
[22700,null,2031,2799,3164,3528,3881,4222]
[22750,null,2032,2801,3166,3530,3883,4225]
[22800,null,2034,2803,3168,3532,3885,4227]
[22850,null,2035,2804,3169,3534,3888,4230]
[22900,null,2036,2806,3171,3536,3890,4232]
[22950,null,2038,2808,3173,3538,3892,4235]
[23000,null,2039,2810,3175,3540,3894,4237]
[23050,null,2041,2812,3177,3542,3897,4240]
[23100,null,2042,2814,3179,3544,3899,4242]
[23150,null,2044,2816,3181,3546,3901,4245]
[23200,null,2045,2817,3182,3548,3904,4247]
[23250,null,2046,2819,3184,3550,3906,4250]
[23300,null,2048,2821,3186,3552,3908,4252]
[23350,null,2049,2823,3188,3555,3910,4254]
[23400,null,2051,2825,3190,3557,3913,4257]
[23450,null,2052,2827,3192,3559,3915,4259]
[23500,null,2053,2828,3193,3561,3917,4262]
[23550,null,2055,2830,3195,3563,3919,4264]
[23600,null,2056,2832,3197,3565,3922,4267]
[23650,null,2058,2834,3199,3567,3924,4269]
[23700,null,2059,2836,3201,3569,3926,4272]
[23750,null,2061,2838,3203,3571,3929,4274]
[23800,null,2062,2840,3204,3573,3931,4277]
[23850,null,2063,2841,3206,3575,3933,4279]
[23900,null,2065,2843,3208,3577,3935,4282]
[23950,null,2066,2845,3210,3579,3938,4284]
[24000,null,2068,2847,3212,3581,3940,4287]
[24050,null,2069,2849,3214,3583,3942,4289]
[24100,null,2070,2851,3216,3585,3945,4292]
[24150,null,2072,2852,3217,3587,3947,4294]
[24200,null,2073,2854,3219,3589,3949,4297]
[24250,null,2075,2856,3221,3592,3951,4299]
[24300,null,2076,2858,3223,3594,3954,4302]
[24350,null,2077,2860,3225,3596,3956,4304]
[24400,null,2079,2862,3227,3598,3958,4307]
[24450,null,2080,2864,3228,3600,3961,4309]
[24500,null,2082,2865,3230,3602,3963,4312]
[24550,null,2083,2867,3232,3604,3965,4314]
[24600,null,2085,2869,3234,3606,3967,4317]
[24650,null,2086,2871,3236,3608,3970,4319]
[24700,null,2087,2873,3238,3610,3972,4322]
[24750,null,2089,2875,3240,3612,3974,4324]
[24800,null,2090,2876,3241,3614,3977,4326]
[24850,null,2092,2878,3243,3616,3979,4329]
[24900,null,2093,2880,3245,3618,3981,4331]
[24950,null,2094,2882,3247,3620,3983,4334]
[25000,null,2096,2884,3249,3622,3986,4336]
[25050,null,2097,2886,3251,3624,3988,4339]
[25100,null,2099,2887,3252,3626,3990,4341]
[25150,null,2100,2889,3254,3629,3993,4344]
[25200,null,2102,2891,3256,3631,3995,4346]
[25250,null,2103,2893,3258,3633,3997,4349]
[25300,null,2104,2895,3260,3635,3999,4351]
[25350,null,2106,2897,3262,3637,4002,4354]
[25400,null,2107,2899,3264,3639,4004,4356]
[25450,null,2109,2900,3265,3641,4006,4359]
[25500,null,2110,2902,3267,3643,4009,4361]
[25550,null,2111,2904,3269,3645,4011,4364]
[25600,null,2113,2906,3271,3647,4013,4366]
[25650,null,2114,2908,3273,3649,4015,4369]
[25700,null,2116,2910,3275,3651,4018,4371]
[25750,null,2117,2911,3276,3653,4020,4374]
[25800,null,2119,2913,3278,3655,4022,4376]
[25850,null,2120,2915,3280,3657,4024,4379]
[25900,null,2121,2917,3282,3659,4027,4381]
[25950,null,2123,2919,3284,3661,4029,4384]
[26000,null,2124,2921,3286,3663,4031,4386]
[26050,null,2126,2923,3287,3666,4034,4389]
[26100,null,2127,2924,3289,3668,4036,4391]
[26150,null,2128,2926,3291,3670,4038,4394]
[26200,null,2130,2928,3293,3672,4040,4396]
[26250,null,2131,2930,3295,3674,4043,4399]
[26300,null,2133,2932,3297,3676,4045,4401]
[26350,null,2134,2934,3299,3678,4047,4403]
[26400,null,2136,2935,3300,3680,4050,4406]
[26450,null,2137,2937,3302,3682,4052,4408]
[26500,null,2138,2939,3304,3684,4054,4411]
[26550,null,2140,2941,3306,3686,4056,4413]
[26600,null,2141,2943,3308,3688,4059,4416]
[26650,null,2143,2945,3310,3690,4061,4418]
[26700,null,2144,2947,3311,3692,4063,4421]
[26750,null,2145,2948,3313,3694,4066,4423]
[26800,null,2147,2950,3315,3696,4068,4426]
[26850,null,2148,2952,3317,3698,4070,4428]
[26900,null,2150,2954,3319,3701,4072,4431]
[26950,null,2151,2956,3321,3703,4075,4433]
[27000,null,2153,2958,3323,3705,4077,4436]
[27050,null,2154,2959,3324,3707,4079,4438]
[27100,null,2155,2961,3326,3709,4082,4441]
[27150,null,2157,2963,3328,3711,4084,4443]
[27200,null,2158,2965,3330,3713,4086,4446]
[27250,null,2160,2967,3332,3715,4088,4448]
[27300,null,2161,2969,3334,3717,4091,4451]
[27350,null,2162,2970,3335,3719,4093,4453]
[27400,null,2164,2972,3337,3721,4095,4456]
[27450,null,2165,2974,3339,3723,4098,4458]
[27500,null,2167,2976,3341,3725,4100,4461]
[27550,null,2168,2978,3343,3727,4102,4463]
[27600,null,2170,2980,3345,3729,4104,4466]
[27650,null,2171,2982,3347,3731,4107,4468]
[27700,null,2172,2983,3348,3733,4109,4471]
[27750,null,2174,2985,3350,3735,4111,4473]
[27800,null,2175,2987,3352,3738,4114,4475]
[27850,null,2177,2989,3354,3740,4116,4478]
[27900,null,2178,2991,3356,3742,4118,4480]
[27950,null,2179,2993,3357,3744,4120,4483]
[28000,null,2181,2994,3359,3746,4122,4485]
[28050,null,2182,2996,3361,3748,4125,4488]
[28100,null,2184,2998,3363,3750,4127,4490]
[28150,null,2185,3000,3365,3752,4129,4492]
[28200,null,2186,3001,3366,3754,4131,4495]
[28250,null,2188,3003,3368,3756,4133,4497]
[28300,null,2189,3005,3370,3758,4136,4500]
[28350,null,2190,3007,3372,3759,4138,4502]
[28400,null,2192,3009,3374,3761,4140,4504]
[28450,null,2193,3010,3375,3763,4142,4507]
[28500,null,2194,3012,3377,3765,4145,4509]
[28550,null,2196,3014,3379,3767,4147,4512]
[28600,null,2197,3016,3381,3769,4149,4514]
[28650,null,2199,3017,3382,3771,4151,4516]
[28700,null,2200,3019,3384,3773,4153,4519]
[28750,null,2201,3021,3386,3775,4156,4521]
[28800,null,2203,3023,3388,3777,4158,4524]
[28850,null,2204,3025,3390,3779,4160,4526]
[28900,null,2205,3026,3391,3781,4162,4528]
[28950,null,2207,3028,3393,3783,4164,4531]
[29000,null,2208,3030,3395,3785,4167,4533]
[29050,null,2210,3032,3397,3787,4169,4536]
[29100,null,2211,3034,3398,3789,4171,4538]
[29150,null,2212,3035,3400,3791,4173,4540]
[29200,null,2214,3037,3402,3793,4175,4543]
[29250,null,2215,3039,3404,3795,4178,4545]
[29300,null,2216,3041,3406,3797,4180,4548]
[29350,null,2218,3042,3407,3799,4182,4550]
[29400,null,2219,3044,3409,3801,4184,4552]
[29450,null,2220,3046,3411,3803,4186,4555]
[29500,null,2222,3048,3413,3805,4189,4557]
[29550,null,2223,3050,3415,3807,4191,4560]
[29600,null,2225,3051,3416,3809,4193,4562]
[29650,null,2226,3053,3418,3811,4195,4564]
[29700,null,2227,3055,3420,3813,4197,4567]
[29750,null,2229,3057,3422,3815,4200,4569]
[29800,null,2230,3058,3423,3817,4202,4572]
[29850,null,2231,3060,3425,3819,4204,4574]
[29900,null,2233,3062,3427,3821,4206,4576]
[29950,null,2234,3064,3429,3823,4208,4579]
[30000,null,2236,3066,3431,3825,4211,4581]