{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":64,"n_cols":12,"rows_kept":64,"cut":false,"hidden":false,"merged":[[60,6,60,7],[61,6,61,7],[51,6,51,7],[52,6,52,7],[50,6,50,7],[57,6,57,7],[58,6,58,7],[59,6,59,7],[40,2,40,5],[55,6,55,7],[44,8,44,10],[41,9,41,10],[56,6,56,7],[53,6,53,7],[54,6,54,7],[47,8,47,10],[35,2,35,5],[36,2,36,5],[24,2,24,5],[27,7,27,8],[25,2,25,5],[2,1,2,4],[13,1,13,5],[11,2,11,5],[19,2,19,5],[17,2,17,5],[18,2,18,5],[9,2,9,11],[8,2,8,11],[10,2,10,11],[14,1,14,5],[63,6,71,7],[49,10,49,11],[15,1,15,5],[29,2,29,5],[31,1,31,5],[32,1,32,5],[20,2,20,5],[21,2,21,5],[33,2,33,5],[16,1,16,5],[28,2,28,5],[28,7,28,8],[26,7,26,8],[27,2,27,5],[26,2,26,5],[34,2,34,5]]}
[]
[null,"FILING FEES CALCULATOR (Version 5.0)"]
[null,"© 2019 Madison County Abstract Co. (Darin O'Brien)",null,null,null,null,null,null,null,null,"Filing Date:",{"$f":"TODAY()","v":"2022-12-07"}]
[null,null,null,null,null,null,null,null,null,null,"Seller:"]
[null,null,null,null,null,null,null,null,null,null,"Buyer:"]
[null,null,null,null,null,null,null,null,null,null,"Abstract No.:"]
[]
[null,"INSTRUCTIONS ON HOW TO USE THIS FILING FEES CALCULATOR"]
[null,null,"This spreadsheet is designed to calculate filing fees for various types of documents and transfer fees when filed in"]
[null,null,"the Recorder's office.  To use the spreadsheet, simply enter the information in the highlighted fields below.  The TOTAL FEES"]
[null,null,"required for filing are shown at the bottom of the page. NOTE: The highlighted fields are the only fields you should change!"]
[]
[]
[null,"INSTRUMENTS OF CONVEYANCE (includes all Deeds, Real"]
[null,"Contracts, Assignments of Contracts (other than for security purposes))",null,null,null,null,null,"No.","No. of ","No. of Sec.","Document ","Fee"]
[null,"than for Security Purposes), Change of Title, and Affidavit",null,null,null,null,null,null,"Pages","AND Subd.","Type"]
[null,"Affidavit of Surviving Spouse)",null,null,null,null,null,1,null,1,null,{"$f":"IF(I17>0,(I17*5) + 2 + (5*J17),0)","v":0}]
[null,null,"NOTE: This calculation is based on $5.00 per page, plus an",null,null,null,null,1,null,1,null,{"$f":"IF(I18>0,(I18*5) + 2 + (5*J18),0)","v":0}]
[null,null,"additional $2.00 for the first page, plus an additional $5.00",null,null,null,null,2,null,1,null,{"$f":"IF(I19>0,(I19*5) + 2 + (5*J19),0)","v":0}]
[null,null,"auditor's transfer fee, plus $5.00 for each SECTION in which the land is ",null,null,null,null,3,null,1,null,{"$f":"IF(I20>0,(I20*5) + 2 + (5*J20),0)","v":0}]
[null,null,"located if RURAL property and $5.00 for each SUBDIVISION if CITY",null,null,null,null,4,null,1,null,{"$f":"IF(I21>0,(I21*5) + 2 + (5*J21),0)","v":0}]
[null,null,"property.  ",null,null,null,null,null,null,null,"SUB-TOTAL:",{"$f":"SUM(L17:L21)","v":0}]
[]
[null,"TRANSFER TAX CALCULATION"]
[null,null,"This calculation is based on $1.60 tax per $1,000.00 of the purchase price. The first $500.00 is exempt and the value is rounded up to the nearest $500.00.  ENTER THE VALUE EXACTLY AS IT APPEARS ON THE DECLARATION OF VALUE (i.e. no rounding or other manipulations of the value are required)."]
[null,null,"price.  The first $500.00 is exempt and the value is rounded up to the ",null,null,null,null,null,null,null,null,"Tax Due"]
[null,null,"nearest $500.00.  ENTER THE VALUE EXACTLY AS IT ",null,null,null,null,"VALUE:",null,null,null,{"$f":"IF(J27>0,(CEILING(J27,500)-500)/1000*1.6,0)","v":0}]
[null,null,"APPEARS ON THE DECLARATION OF VALUE (i.e. no",null,null,null,null,"VALUE:",null,null,null,{"$f":"IF(J28>0,(CEILING(J28,500)-500)/1000*1.6,0)","v":0}]
[null,null,"rounding or other manipulations of the value are required).",null,null,null,null,"VALUE:",null,null,null,{"$f":"IF(J29>0,(CEILING(J29,500)-500)/1000*1.6,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"SUB-TOTAL:",{"$f":"SUM(L27:L29)","v":0}]
[]
[null,"OTHER INSTRUMENTS (Mortgages, Assignments,"]
[null,"Easements, Affidavits, Plats of Survey, Etc…)",null,null,null,null,null,"No.","No. of ","Document ",null,"Fee"]
[null,null,"NOTE:  This calculation is based on $5.00 per page, plus an additional ",null,null,null,null,null,"Pages","Type"]
[null,null,"$2.00 for the first page.",null,null,null,null,1,null,null,null,{"$f":"IF(I35>0,(I35*5) + 2,0)","v":0}]
[null,null,null,null,null,null,null,2,null,null,null,0]
[null,null,"NOTE:  If Mortgage Release is being filed and more than one mortgage",null,null,null,null,3,null,null,null,0]
[null,null,"is being released, include an additional $5.00",null,null,null,null,4,null,null,null,0]
[null,null,"per mortgage being released.",null,null,null,null,5,null,null,null,0]
[null,null,null,null,null,null,null,6,null,null,null,0]
[null,null,"NOTE:  If Reassignment of Contract, $5.00 per additoinal contract being ",null,null,null,null,7,null,null,null,0]
[null,null,"reassigned.  ",null,null,null,null,8,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"SUB-TOTAL:",{"$f":"SUM(L35:L42)","v":0}]
[null,null,"NOTE:  $5.00 transfer fee per BLOCK unless continguous"]
[null,null,"(then just $5.00 for all continguous blocks)"]
[]
[]
[null,null,null,null,null,null,null,null,"TOTAL RECORDING FEES DUE:",null,null,{"$f":"SUM(L22+L30+L43)","v":0}]
[null,null,null,null,null,null,"RECORDER'S FILING FEES",null,null,null,"OTHER  "]
[null,null,null,null,null,null,"CHECKS SUBMITTED:",null,null,null,"CHECKS SUBMITTED:"]
[null,null,null,null,null,null,"No.",null,"Amount",null,"Payee","Amount"]
[null,null,null,null,null,null,1,null,null,null,"Abstractor"]
[null,null,null,null,null,null,2,null,null,null,"Abstractor"]
[null,null,null,null,null,null,3,null,null,null,"Treasurer"]
[null,null,null,null,null,null,4,null,null,null,"Treasurer"]
[null,null,null,null,null,null,5,null,null,null,"Treasurer"]
[null,null,null,null,null,null,6,null,null,null,"Other"]
[null,null,null,null,null,null,7,null,null,null,"Other"]
[null,null,null,null,null,null,8,null,null,null,"Other"]
[null,null,null,null,null,null,9,null,null,null,"Other"]
[null,null,null,null,null,null,10,null,null,null,"Other"]
[null,null,null,null,null,null,"TOTAL:",null,{"$f":"SUM(I52:I61)","v":0},null,"Other"]
[]
[null,null,null,null,null,null,"DIFFERENCE BETWEEN AMOUNT REQUIRED AND AMOUNT SUBMITTED TO RECORDER:",null,{"$f":"I62-L48","v":0},{"$f":"IF(I64<0, \"SHORT\",\"TOO MUCH\")","v":"TOO MUCH"}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}