{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Instructions","EXAMPLE - Statutes","Statutes Template"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Instructions","index":0,"n_rows":79,"n_cols":14,"rows_kept":79,"merged":[[0,0,4,16],[6,0,9,16],[11,0,11,2],[11,4,11,6],[11,8,11,10],[11,12,11,14],[12,1,12,2],[12,5,12,6],[12,9,12,10],[12,13,12,14],[13,1,13,2],[13,5,13,6],[13,9,13,10],[13,13,13,14],[14,1,14,2],[14,5,14,6],[14,9,14,10],[14,13,14,14],[15,1,15,2],[15,5,15,6],[15,9,15,10],[15,13,15,14],[16,1,16,2],[16,5,16,6],[16,9,16,10],[16,13,16,14],[17,1,17,2],[17,5,17,6],[17,9,17,10],[17,13,17,14],[18,1,18,2],[18,5,18,6],[18,9,18,10],[18,13,18,14],[19,1,19,2],[19,5,19,6],[19,9,19,10],[19,13,19,14],[20,1,20,2],[20,5,20,6],[20,9,20,10],[20,13,20,14],[21,1,21,2],[21,5,21,6],[21,9,21,10],[21,13,21,14],[22,1,22,2],[22,5,22,6],[22,9,22,10],[22,13,22,14],[24,0,24,2],[24,4,24,6],[24,8,24,10],[24,12,24,14],[25,1,25,2],[25,5,25,6],[25,9,25,10],[25,13,25,14],[26,1,26,2],[26,5,26,6],[26,9,26,10],[26,13,26,14],[27,1,27,2],[27,5,27,6],[27,9,27,10],[27,13,27,14],[28,1,28,2],[28,5,28,6],[28,9,28,10],[28,13,28,14],[29,1,29,2],[29,5,29,6],[29,9,29,10],[29,13,29,14],[30,1,30,2],[30,5,30,6],[30,9,30,10],[30,13,30,14],[31,1,31,2],[31,5,31,6],[31,9,31,10],[31,13,31,14],[32,1,32,2],[32,5,32,6],[32,9,32,10],[32,13,32,14],[33,1,33,2],[33,5,33,6],[33,9,33,10],[33,13,33,14],[34,1,34,2],[34,5,34,6],[34,9,34,10],[34,13,34,14],[38,0,38,1],[38,2,38,3],[38,4,38,5],[38,6,38,7],[39,0,39,1],[39,2,39,3],[39,4,39,5],[39,6,39,7],[40,0,40,1],[40,2,40,3],[40,4,40,5],[40,6,40,7],[41,0,41,1],[41,2,41,3],[41,4,41,5],[41,6,41,7],[42,0,42,1],[42,2,42,3],[42,4,42,5],[42,6,42,7],[43,0,43,1],[43,2,43,3],[43,4,43,5],[43,6,43,7],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,6,44,7],[45,0,45,1],[45,2,45,3],[45,4,45,5],[45,6,45,7],[46,0,46,1],[46,2,46,3],[46,4,46,5],[46,6,46,7],[47,0,47,1],[47,2,47,3],[47,4,47,5],[47,6,47,7],[48,0,48,1],[48,2,48,3],[48,4,48,5],[48,6,48,7],[49,0,49,1],[49,2,49,3],[49,4,49,5],[49,6,49,7],[50,0,50,1],[50,2,50,3],[50,4,50,5],[50,6,50,7],[51,0,51,1],[51,2,51,3],[51,4,51,5],[51,6,51,7],[52,0,52,1],[52,2,52,3],[52,4,52,5],[52,6,52,7],[53,0,53,1],[53,2,53,3],[53,4,53,5],[53,6,53,7],[54,0,54,1],[54,2,54,3],[54,4,54,5],[54,6,54,7],[55,0,55,1],[55,2,55,3],[55,4,55,5],[55,6,55,7],[56,0,56,1],[56,2,56,3],[56,4,56,5],[56,6,56,7],[57,0,57,1],[57,2,57,3],[57,4,57,5],[57,6,57,7],[58,0,58,1],[58,2,58,3],[58,4,58,5],[58,6,58,7],[59,0,59,1],[59,2,59,3],[59,4,59,5],[59,6,59,7],[60,0,60,1],[60,2,60,3],[60,4,60,5],[60,6,60,7],[61,0,61,1],[61,2,61,3],[61,4,61,5],[61,6,61,7],[62,0,62,1],[62,2,62,3],[62,4,62,5],[62,6,62,7],[63,0,63,1],[63,2,63,3],[63,4,63,5],[63,6,63,7],[64,0,64,1],[64,2,64,3],[64,4,64,5],[64,6,64,7],[65,0,65,1],[65,2,65,3],[65,4,65,5],[65,6,65,7],[66,0,66,1],[66,2,66,3],[66,4,66,5],[66,6,66,7],[67,0,67,1],[67,2,67,3],[67,4,67,5],[67,6,67,7],[68,0,68,1],[68,2,68,3],[68,4,68,5],[68,6,68,7],[69,0,69,1],[69,2,69,3],[69,4,69,5],[69,6,69,7],[70,0,70,1],[70,2,70,3],[70,4,70,5],[70,6,70,7],[71,0,71,1],[71,2,71,3],[71,4,71,5],[71,6,71,7],[72,0,72,1],[72,2,72,3],[72,4,72,5],[72,6,72,7],[73,0,73,1],[73,2,73,3],[73,4,73,5],[73,6,73,7],[74,0,74,1],[74,2,74,3],[74,4,74,5],[74,6,74,7],[75,0,75,1],[75,2,75,3],[75,4,75,5],[75,6,75,7],[76,0,76,1],[76,2,76,3],[76,4,76,5],[76,6,76,7],[77,0,77,1],[77,2,77,3],[77,4,77,5],[77,6,77,7],[78,0,78,1],[78,2,78,3],[78,4,78,5],[78,6,78,7]],"flags":["formulas_cached_only"]}
["INSTRUCTIONS:  \n\nTake a look at the [EXAMPLE - Statutes] tab for an example of how to fill out the [Statutes Template] tab.  Add a row for each statute.  There are several lookup lists available for each row, the default values for these lookup lists are included as tables below.  Each of these lists is also available for you to customize from within eProsecutor Online, and the codes you add there can then be used in the statute import.\n\nOnce you have completed the Statutes Template:\n1. Right-click on the 'Statute Template' sheet and select 'Move or Copy'\n2. Select 'Create a Copy', set the 'To book:' field to '(new book)', and click 'OK'\n3. Inside the new book, save the sheet as a 'Excel 97-2003 Workbook (*.xls)' file at the location of your choice\n4. Open up eProsecutor Online, and browse to 'Statutes' in System Administration\n5. Click the 'Import All Statutes as XLS' button\n6. Click 'Choose File' and select the file you saved previously\n7. Click 'Import'\n8. eProsecutor Online will show you a list of the statutes being imported, along with whether they are being created or updated.\n9. Click 'Confirm' to finish importing the statutes"]
[]
[]
[]
[]
[]
["The lists below are the existing lookup list values.  If you need additional values, please add to the lists below. \n\nThe Code column should be unique for each entry.  The columns marked with an asterisk * are required."]
[]
[]
[]
[]
["STATUTE_CLASSIFICATION",{"$nulls":3},"STATUTE_CATEGORY",{"$nulls":3},"STATUTE_SUBCATEGORY",{"$nulls":3},"STATUTE_SOURCE"]
["Code","Label",null,null,"Code","Label",null,null,"Code","Label",null,null,"Code","Label"]
["jtdF1","First Degree Felony",null,null,"jtdC","Citation",null,null,"jtdALCH","Alcohol","Persons Crimes",null,"jtdBCC","Business and Commerce Code"]
["jtdF2","Second Degree Felony",null,null,"jtdE","EXPUNGED",null,null,"jtdDRUG","Drug","Property Crimes",null,"jtdEDC","Education Code"]
["jtdF3","Third Degree Felony",null,null,"jtdF","Felony",null,null,"jtdDW","Deadly Weapon","Drug offense crimes",null,"jtdEC","Election Code"]
["jtdFCAP","Capital",null,null,"jtdM","Misdemeanor",null,null,"jtdDWFZ","Drug or Weapon Free Zone","Traffic Offenses",null,"jtdGC","Government Code"]
["jtdMA","Class A Misdemeanor ",{"$nulls":6},"jtdFV","Family Violence","Unclassified Offenses",null,"jtdIC","Insurance Code"]
["jtdMB","Class B Misdemeanor ",{"$nulls":6},"jtdSXO","Sex Offender","Sexual Assault Offenses",null,"jtdPWC","Parks & Wildlife Code"]
["jtdMC","Class C Misdemeanor ",{"$nulls":6},"jtdTHEF","Theft",null,null,"jtdTC","Tax Code"]
["jtdEXP","EXPUNGED",{"$nulls":6},"jtdU21","Under 21"]
[{"$nulls":8},"jtdVIOL","Violence"]
[{"$nulls":8},"jtdEXP","EXPUNGED"]
[]
["JURISDICTION",{"$nulls":3},"Status",{"$nulls":3},"STATUTE_ACTION",{"$nulls":3},"STATUTE_REPORT_CATEGORY"]
["Code","Label",null,null,"Code","Label",null,null,"Code","Label",null,null,"Code","Label"]
[{"$nulls":4},"ACTIVE","Active",null,null,"MA","Must Appear"]
[{"$nulls":4},"INACTIVE","Inactive",null,null,"PE","Priors Eligible"]
[{"$nulls":8},"SC","School Correctible"]
[{"$nulls":8},"PC","Proof Correctible"]
[{"$nulls":8},"FR","Financial Responsibility"]
[]
[]
[]
[]
[]
[]
["Statute Import Columns+",{"$nulls":8}," +There are several columns that are required for the import that are unused.  These are hidden below and in the template"]
["Column Name",null,"Description",null,"Lookup List",null,"Notes"]
["ID",null,"Should be ignored"]
["Config Code",null,"Should be ignored"]
["County Code",null,"Should be ignored"]
["RBC Exempt",null,"(Optional) Determines if the statute should be exempt from race blind charging.",{"$nulls":3},"true, false, or empty.\nDefaults to false.\nHas no effect unless Race Blind Charging is used."]
["Marijuana",null,"Should be ignored"]
["USJR Code",null,"Should be ignored"]
["Special Fee",null,"Should be ignored"]
["Report Category",null,"(Optional) Used to set a statute reporting category",null,"STATUTE_REPORT_CATEGORY",null,"No default values"]
["Statute of Limitations",null,"(Optional) Number of years expressed as an integer"]
["Total Amount",null,"Should be ignored"]
["Display Amount",null,"Should be ignored"]
["Conversion ID",null,"Should be ignored"]
["Version",null,"Should be ignored"]
["Group (ID)",null,"Should be ignored"]
["StatuteFine: ID, Base Amount, Fine Amount, Effective From, Effective To",null,"Should be ignored"]
["Category (ID)",null,"Should be ignored"]
["Research (ID)",null,"Should be ignored"]
["Keyword (ID)",null,"Should be ignored"]
["Mapping (ID)",null,"Should be ignored"]
["Section No. *",null,"Statute number (e.g., 76-6-302)"]
["Code",null,"(Optional)  Sets the statue Code field"]
["Section Name *",null,"Statute Title"]
["Short Name",null,"(Optional) Short name for statute"]
["Notes",null,"(Optional) Notes for statute"]
["Description",null,"(Optional) Description for statute"]
["Statute/Charging Language",null,"Language included in charging documents"]
["Classification",null,"(Optional) degree of violation (e.g., first degree, second degree, etc.)",null,"STATUTE_CLASSIFICATION"]
["Category",null,"(Optional) Severity (e.g., F1, MA, etc.)",null,"STATUTE_CATEGORY"]
["Subcategory",null,"(Optional) Additional categorization such as person crime, traffic crime, etc.",null,"STATUTE_SUBCATEGORY"]
["Source",null,"(Optional) Source of statute (e.g., VC vehicle code)",null,"STATUTE_SOURCE"]
["Jurisdiction",null,"(Optional) Categorization for multi-jurisdictional statute use",null,"JURISDICTION",null,"No default values"]
["Base Offense Level",null,"(Optional) Severity level"]
["Points",null,"(Optional) Traffic violation points"]
["Status *",null,"Active or Inactive status",{"$nulls":3},"ACTIVE or INACTIVE"]
["Moving Violation",null,"(Optional) Indicator of whether statute is for moving traffic violation",{"$nulls":3},"true, false, or empty"]
["Vehicle Info. Reqd.",null,"(Optional) Indicator of whether vehicle information is required",{"$nulls":3},"true, false, or empty"]
["Effective From",null,"(Optional) Date statute enacted",{"$nulls":3},"Ensure the column type is text, and use the format MM/DD/YY"]
["Effective To",null,"(Optional) Date statute repealed",{"$nulls":3},"Ensure the column type is text, and use the format MM/DD/YY"]
["Actions",null,"(Optional) Codes for statute actions list (e.g., MA, PE, etc.)",null,"STATUTE_ACTION",null,"Comma separated list"]
["Assessment Group Pool",null,"Should be ignored"]

{"sheet":"EXAMPLE - Statutes","index":1,"n_rows":5,"n_cols":40,"rows_kept":5,"flags":["formulas_cached_only"]}
["ID","Config Code","County Code","RBC Exempt","Marijuana","USJR Code","Special Fee","Report Category","Statute of Limitations","Total Amount","Display Amount","Conversion ID","Version","Group (ID)","StatuteFine: ID, Base Amount, Fine Amount, Effective From, Effective To","Category (ID)","Research (ID)","Keyword (ID)","Mapping (ID)","Section No.","Code","Section Name","Short Name","Notes","Description","Statute/Charging Language","Classification","Category","Subcategory","Source","Jurisdiction","Base Offense Level","Points","Status","Moving Violation","Vehicle Info. Reqd.","Effective From","Effective To","Actions","Assessment Group Pool"]
[{"$nulls":3},false,{"$nulls":4},5,{"$nulls":10},"PC211","PC-211","Robbery","Robbery","Elements Required to Prove PC 211 Robbery:\n* To support a robbery charge, the prosecution must prove:\n* A person had possession of property.\n* The property was taken from the person or their immediate presence.\n* The property was taken against that person's will.\n* The taking was accomplished by force or fear.\n* The defendant intended to permanently deprive the person of the property.","Robbery - Here is where the statute text appears","On or about [date], in the County of [County Name], the defendant, [Defendant’s Name], did unlawfully take personal property in the possession of another, from his or her person or immediate presence, and against his or her will, accomplished by means of force or fear, in violation of Penal Code section 211, a felony.","jtdF1","jtdF","jtdDW",{"$nulls":4},"ACTIVE",null,null,"01/01/01","02/02/02"]
[{"$nulls":3},true,{"$nulls":15},120.05,"PL120.05","Assault in the Second Degree","Assault as Hate Crime","The defendant intentionally selected the victim in whole or in substantial part based on a belief or perception regarding:\n* Race, religion, sexual orientation, disability, gender identity, national origin, etc.","This statute involves intentionally causing physical injury to another person and is a Class D felony. When charged as a hate crime, it is elevated to a Class C felony.","The defendant, on or about [DATE], in the County of [COUNTY], intentionally caused physical injury to [VICTIM] by means of a [DANGEROUS INSTRUMENT or OTHER SPECIFIC MEANS], and did so in whole or in substantial part because of a belief or perception regarding the victim’s [protected characteristic, e.g., sexual orientation, race, religion, etc.], in violation of New York Penal Law §§ 120.05 and 485.05, Assault in the Second Degree as a Hate Crime, a Class C felony.","jtdF1",{"$nulls":6},"ACTIVE",{"$nulls":4},"PE, MA"]
[{"$nulls":19},"1180(b)",null,"11–20 mph over the limit",{"$nulls":10},4,"ACTIVE",true,true]
[{"$nulls":19},155.25,"PL155.25","Petit Larceny","Shoplifting","To prove Petit Larceny, show:\n- Theft: The defendant wrongfully took, obtained, or withheld property.\n- Intent: The defendant intended to deprive the owner of the property.\n- Value: The property was worth $1,000 or less.","Knowingly stealing property valued at $1,000 or less.","The defendant, on or about [DATE], in the County of [COUNTY], did steal property, to wit: [ITEM DESCRIPTION], having a value of $[AMOUNT], the property of [VICTIM OR STORE], in violation of New York Penal Law § 155.25, Petit Larceny, a Class A misdemeanor.","jtdMA","jtdM",null,"jtdGC",null,6,null,"INACTIVE",false,false,null,"02/02/28"]

{"sheet":"Statutes Template","index":2,"n_rows":1,"n_cols":40,"rows_kept":1,"flags":["formulas_cached_only"]}
["ID","Config Code","County Code","RBC Exempt","Marijuana","USJR Code","Special Fee","Report Category","Statute of Limitations","Total Amount","Display Amount","Conversion ID","Version","Group (ID)","StatuteFine: ID, Base Amount, Fine Amount, Effective From, Effective To","Category (ID)","Research (ID)","Keyword (ID)","Mapping (ID)","Section No.","Code","Section Name","Short Name","Notes","Description","Statute/Charging Language","Classification","Category","Subcategory","Source","Jurisdiction","Base Offense Level","Points","Status","Moving Violation","Vehicle Info. Reqd.","Effective From","Effective To","Actions","Assessment Group Pool"]