{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Prescrip Rgts","Calculations"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":6,"comments":0,"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":"Prescrip Rgts","index":0,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,4,3,5],[2,3,2,5],[29,4,30,4],[29,5,30,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[21,3,21,8],[22,3,22,8],[23,3,23,8],[20,3,20,8]]}
[null,null,null,"State of Wisconsin",null,null,null,"  Prescriptive Rights Calculator "]
[null,null,null,"Department of Transportation",null,null,null,"     Lands Acquired for the State"]
[null,null,null,"Project Description",null,null,"Project ID(s)"]
[null,null,null,"Title:",null,null,"Design:"]
[null,null,null,"Limits:",null,null,"Construction:"]
[null,null,null,"Highway:",null,null,"Right of Way:"]
[null,null,null,"County:",null,null,"Select"]
[null,null,null,"Company:",null,null,"Utility:"]
[null,null,null,null,"Parcel Number:  ",null,null,"     "]
[null,null,null,null,"Sheet Number: "]
[]
[null,null,null,null,"FACILITY OWNER",null,"DATE FACILITY WAS INSTALLED"]
[null,null,null,null,"Select"]
[]
[null,null,null,null,"FACILITY TYPE",null,"TODAY'S DATE"]
[null,null,null,null,"Select",null,{"$f":"TODAY()","v":"2023-05-22"}]
[]
[null,null,null,null,"LAND OWNER"]
[null,null,null,null,"Select"]
[]
[null,null,null,{"$f":"IF(AND(E19=\"Land is publicly owned\")*(G13>=Calculations!D5)*('Prescrip Rgts'!G13<=Calculations!E5)*(E13=\"Domestic Corporation\"),Calculations!L13,IF(AND(E19=\"Land is publicly owned\")*(G13>=Calculations!D5)*('Prescrip Rgts'!G13<=Calculations!E5)*(E13=\"Foreign Corporation\"),Calculations!L13,\"\"))","v":""},null,null,null,null,null,"Select"]
[null,null,null,{"$f":"IF(AND(E19=\"Land is publicly owned\")*(G13>=Calculations!D4)*('Prescrip Rgts'!G13<=Calculations!E4)*(E13=\"Domestic Corporation\"),Calculations!L24,IF(AND(E19=\"Land is publicly owned\")*(G13>=Calculations!D4)*('Prescrip Rgts'!G13<=Calculations!E4)*(E13=\"Foreign Corporation\"),Calculations!L24,\"\"))","v":""},null,null,null,null,null,"Select"]
[null,null,null,{"$f":"IF(AND(E19=\"Land is publicly owned\")*(G13>=Calculations!D4)*('Prescrip Rgts'!G13<=Calculations!E4)*(E13=\"Domestic Corporation\"),Calculations!L25,IF(AND(E19=\"Land is publicly owned\")*(G13>=Calculations!D4)*('Prescrip Rgts'!G13<=Calculations!E4)*(E13=\"Foreign Corporation\"),Calculations!L25,\"\"))","v":""},null,null,null,null,null,"Select"]
[null,null,null,{"$f":"IF(AND(E19=\"Land is publicly owned\")*(G13>=Calculations!D4)*('Prescrip Rgts'!G13<=Calculations!E4)*(E13=\"Domestic Corporation\"),Calculations!L26,IF(AND(E19=\"Land is publicly owned\")*(G13>=Calculations!D4)*('Prescrip Rgts'!G13<=Calculations!E4)*(E13=\"Foreign Corporation\"),Calculations!L26,\"\"))","v":""},null,null,null,null,null,"Select"]
[]
[]
[]
[]
[null,null,null,null,"ELIGIBLE FOR A PRESCRIPTIVE RIGHT?",{"$f":"IF(OR((Calculations!D16=\"NO\")*(Calculations!A7=\"FO\"),(G13=\"\"),(Calculations!D16=\"NO\")*(Calculations!A13=\"FT\"),(Calculations!D16=\"NO\")*(Calculations!A22=\"LO\"),(Calculations!D16=\"NO\")*(Calculations!A25=\"S\")*(G13<=Calculations!E5)*(Calculations!D24=\"Good\")),Calculations!L20,IF(OR((Calculations!H11=\"YES\"),(Calculations!H17=\"YES\"),(Calculations!H31=\"YES\")),Calculations!L16,IF(OR((G13>Calculations!E5),(Calculations!D16=\"NO\")),Calculations!L18)))","v":" "}]
[null,null,null,null,"Prescriptive Right established on:",{"$f":"IF(AND(E13=\"Domestic Corporation\")*(E19=\"Land is privately owned\")*(F29=\"NO\"),Calculations!H13,IF(AND(E19=\"Land is publicly owned\")*(G13>Calculations!E5),Calculations!L21,IF(AND(E13=\"Unit of Government\")*(E19=\"Land is publicly owned\"),Calculations!L21,IF(AND(E19=\"Land is publicly owned\")*(Calculations!D23=\"Yes\"),Calculations!L21,IF(AND(E13=\"Foreign Corporation\")*(E19=\"Land is privately owned\")*(F29=\"NO\"),Calculations!H19,IF(AND(E13=\"Unit of Government\")*(E19=\"Land is privately owned\")*(F29=\"NO\"),Calculations!H19,IF(AND(F29=\"YES\")*(Calculations!H31=\"YES\"),Calculations!H33,IF(AND(F29=\"YES\")*(Calculations!H17=\"YES\"),Calculations!H19,IF(AND(F29=\"YES\")*(Calculations!H11=\"YES\"),Calculations!H13,IF(AND(E13=\"Foreign Corporation\")*(E19=\"Land is publicly owned\")*(Calculations!D22=\"No\"),Calculations!L21,\"\"))))))))))","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"v. 2023-05"]

{"sheet":"Calculations","index":1,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":true,"merged":[[14,3,14,4],[15,3,15,4],[25,11,25,23],[17,11,17,13],[21,11,21,14],[20,11,20,14],[1,11,10,17],[12,11,13,17],[15,11,15,13],[23,11,23,23],[24,11,24,23],[16,11,16,14],[18,11,18,14],[19,11,19,14]]}
[]
[null,"Utility or UA Number",null,"Land Publicly Owned",null,null,"Domestic Corporation",{"$f":"IF(('Prescrip Rgts'!E13=\"Domestic Corporation\"),\"YES\",\"NO\")","v":"NO"},null,null,null,"Does it meet these requirements:\nLANDS CANNOT BE:\n- Real property held in trust by the state under s. 24.01 (2) to (6).\n- Real property of an abandoned railroad acquired by the state under s. 85.09.\n- Real property of a highway as defined in s. 340.01 (22) and including property held by the state or a political subdivision for highway purposes."]
[null,"UTL:",null,"Start Date","End Date",null,"Days occupied",{"$f":"IF(ISBLANK('Prescrip Rgts'!G13),\"\",'Prescrip Rgts'!G16-'Prescrip Rgts'!G13)","v":""}]
[null,"UA:",null,"1964-03-28","1978-04-28",null,"Occupied for 10 years?",{"$f":"IF((H3>=3652)*(H3<>\"\"),\"YES\",\"NO\")","v":"NO"}]
[null,"UTL or UA No.:",null,"1978-04-29","1996-03-03",null,"Occupied for 20 years?",{"$f":"IF((H3>=7305)*(H3<>\"\"),\"YES\",\"NO\")","v":"NO"}]
[null,null,null,null,null,null,"Private land?",{"$f":"IF(('Prescrip Rgts'!E19=\"Land is privately owned\"),\"YES\",\"NO\")","v":"NO"}]
[{"$f":"IF(('Prescrip Rgts'!E13=\"Select Owner\"),\"FO\",\"\")","v":""},"FACILITY OWNER",null,"PUBLIC LAND QUESTION",null,null,"Public land?",{"$f":"IF(('Prescrip Rgts'!E19=\"Land is publicly owned\"),\"YES\",\"NO\")","v":"NO"}]
[null,"Domestic Corporation",null,"Yes",null,null,"Meets Requirements (3 questions)?",{"$f":"IF((D22=\"Yes\"),\"YES\",\"NO\")","v":"NO"}]
[null,"Foreign Corporation",null,"No",null,null,"Non-establish date",{"$f":"IF(('Prescrip Rgts'!G13<=E5),\"YES\",\"NO\")","v":"YES"}]
[null,"Unit of Government",null,"Select",null,null,"Facility type correct?",{"$f":"IF(OR('Prescrip Rgts'!E16=\"Communication\",'Prescrip Rgts'!E16=\"Electricity\",'Prescrip Rgts'!E16=\"Gas or Petroleum\",'Prescrip Rgts'!E16=\"Sewer\",'Prescrip Rgts'!E16=\"Steam\",'Prescrip Rgts'!E16=\"Water\"),\"YES\",\"NO\")","v":"NO"}]
[null,"Select",null,"N/A",null,null,"Prescriptive Right?",{"$f":"IF(OR((H2=\"YES\")*(H4=\"YES\")*(H6=\"YES\")*(H10=\"YES\"),(H2=\"YES\")*(H7=\"YES\")*(H10=\"YES\")*(H14=\"YES\"),(H2=\"YES\")*(H5=\"YES\")*(H7=\"YES\")*(H8=\"YES\")*(H10=\"YES\")*(H9=\"YES\")),\"YES\",\"NO\")","v":"NO"}]
[null,null,null,null,null,null,"Days remaining to establish Prescrit. Rght.",{"$f":"3652-H3","v":{"$error":"#VALUE!"}}]
[{"$f":"IF(('Prescrip Rgts'!E16=\"Select Type\"),\"FT\",\"\")","v":""},"FACILITY TYPE",null,"NO",null,null,"Prescriptive Right Established on:",{"$f":"'Prescrip Rgts'!G16+H12","v":{"$error":"#VALUE!"}},null,null,null,"Is there a continuously maintained fence line which has been mutually agreed upon by the current land owners?"]
[null,"Communication",null,null,null,null,"Installed before 03/28/1964",{"$f":"IF(('Prescrip Rgts'!G13<Calculations!D4),\"YES\",\"NO\")","v":"YES"}]
[null,"Electricity",null,"Any Prescriptive right?"]
[null,"Gas or Petroleum",null,{"$f":"IF((H11=\"NO\")*(H17=\"NO\")*(H31=\"NO\"),\"NO\",\"\")","v":"NO"},null,null,"Foreign Corporation",{"$f":"IF(('Prescrip Rgts'!E13=\"Foreign Corporation\"),\"YES\",\"NO\")","v":"NO"},null,null,null,"YES"]
[null,"Sewer",null,null,null,null,"Prescriptive Right?",{"$f":"IF(OR((H16=\"YES\")*(H5=\"YES\")*(H6=\"YES\"),(H16=\"YES\")*(H7=\"YES\")*(H10=\"YES\")*(H14=\"YES\"),(H16=\"YES\")*(H5=\"YES\")*(H7=\"YES\")*(H8=\"YES\")*('Prescrip Rgts'!G13<=E5)),\"YES\",\"NO\")","v":"NO"}]
[null,"Steam",null,"Public Land Questions",null,null,"Days remaining to establish Prescrit. Rght.",{"$f":"7305-H3","v":{"$error":"#VALUE!"}},null,null,null,"NO"]
[null,"Water",null,"Select",null,null,"Prescriptive Right Established on:",{"$f":"'Prescrip Rgts'!G16+H18","v":{"$error":"#VALUE!"}}]
[null,"Select",null,"Yes",null,null,null,null,null,null,null," "]
[null,null,null,"No",null,null,null,null,null,null,null,"Prescriptive right cannot be established"]
[{"$f":"IF(('Prescrip Rgts'!E19=\"Select Owner\"),\"LO\",\"\")","v":""},"LAND OWNER",null,{"$f":"IF(OR(('Prescrip Rgts'!J22=\"No\")*('Prescrip Rgts'!J23=\"No\")*('Prescrip Rgts'!J24=\"No\"),('Prescrip Rgts'!J21=\"Yes\")),\"Yes\",\"\")","v":""},null,null,null,null,null,null,null,"Prescriptive Right established on:"]
[null,"Land is privately owned",null,{"$f":"IF(OR(('Prescrip Rgts'!J22=\"Yes\"),('Prescrip Rgts'!J23=\"Yes\"),('Prescrip Rgts'!J24=\"Yes\"),('Prescrip Rgts'!J21=\"No\")),\"Yes\",\"\")","v":""}]
[null,"Land is publicly owned",null,{"$f":"IF(AND(('Prescrip Rgts'!E13=\"Unit of Government\")*('Prescrip Rgts'!E19=\"Land is publicly owned\")),\"Void\",\"Good\")","v":"Good"},null,null,null,null,null,null,null,"Is the land owned by the University of Wisconsin, College of Menominee Nation, or Lac Courte Oreilles Ojibwa Community College?"]
[{"$f":"IF(OR(('Prescrip Rgts'!J21=\"Select\")*('Prescrip Rgts'!J22=\"Select\")*('Prescrip Rgts'!J23=\"Select\")*('Prescrip Rgts'!J24=\"Select\"),('Prescrip Rgts'!J22=\"No\")*('Prescrip Rgts'!J23=\"Select\")*('Prescrip Rgts'!J24=\"Select\"),('Prescrip Rgts'!J22=\"No\")*('Prescrip Rgts'!J23=\"No\")*('Prescrip Rgts'!J24=\"Select\"),('Prescrip Rgts'!J22=\"Select\")*('Prescrip Rgts'!J23=\"No\")*('Prescrip Rgts'!J24=\"Select\"),('Prescrip Rgts'!J22=\"Select\")*('Prescrip Rgts'!J23=\"Select\")*('Prescrip Rgts'!J24=\"No\"),('Prescrip Rgts'!J22=\"No\")*('Prescrip Rgts'!J23=\"Select\")*('Prescrip Rgts'!J24=\"No\"),('Prescrip Rgts'!J22=\"Select\")*('Prescrip Rgts'!J23=\"No\")*('Prescrip Rgts'!J24=\"No\"),('Prescrip Rgts'!J21=\"Yes\")),\"S\",\"\")","v":"S"},"Select",null,null,null,null,null,null,null,null,null,"Is the land an abandoned railroad acquired by the State?"]
[null,null,null,null,null,null,null,null,null,null,null,"Is the land for highway purposes?"]
[]
[]
[]
[null,null,null,null,null,null,"Unit of Government",{"$f":"IF(('Prescrip Rgts'!E13=\"Unit of Government\"),\"YES\",\"NO\")","v":"NO"}]
[null,null,null,null,null,null,"Prescriptive Right?",{"$f":"IF((H30=\"YES\")*(H5=\"YES\")*(H6=\"YES\"),\"YES\",\"NO\")","v":"NO"}]
[null,null,null,null,null,null,"Days remaining to establish Prescrit. Rght.",{"$f":"7305-H3","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,"Prescriptive Right Established on:",{"$f":"'Prescrip Rgts'!G16+H32","v":{"$error":"#VALUE!"}}]