{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Data Element Comparison","Add or Remove Program Changes"],"not_rendered":{"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Data Element Comparison","index":0,"n_rows":35,"n_cols":8,"rows_kept":35,"merged":[[34,0,34,7]]}
["REGS","Old Element","New Element","REASON","OLD BURDEN (all respondents)","NEW BURDEN (all respondents)","DIFFERENCE","TYPE OF CHANGE"]
["7 CFR Part 457","P05 - CIMS Request Record *                                                        ",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"F2-E2","v":{"v":0,"d":"0.00"}},"Adj"]
[null,"P09 - Fund Designation Record (per company)*",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"Adj"]
[null,"P10 - Policy Record (Company Application)",null,null,{"$f":"39472.62+39487.61","v":{"v":78960.23000000001,"d":"78,960.23"}},{"v":103335.88,"d":"103,335.88"},{"v":24375.649999999994,"d":"24,375.65"},"Adj"]
[null,"P11 - Acreage Record (Company Acreage Report)",null,null,{"$f":"835392.6+556225.02","v":{"v":1391617.62,"d":"1,391,617.62"}},{"v":1494781.2,"d":"1,494,781.20"},{"v":103163.57999999984,"d":"103,163.58"},"Adj"]
[null,"P12 - Payment Record",null,null,{"$f":"63604.5+63604.5","v":{"v":127209,"d":"127,209.00"}},{"v":171983.4,"d":"171,983.40"},{"$f":"F6-E6","v":{"v":44774.399999999994,"d":"44,774.40"}},"Adj"]
[null,"P13 - Inventory Value Record",null,null,{"$f":"20912+1307","v":{"v":22219,"d":"22,219.00"}},{"v":10735.5,"d":"10,735.50"},{"v":-11483.5,"d":"-11,483.50"},"Adj"]
[null,"P14 - Insurance in Force Record *",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"Adj"]
[null,"P15 - Yield History Record",null,null,{"$f":"1113856.8+1668675.06","v":{"v":2782531.8600000003,"d":"2,782,531.86"}},{"v":2989562.5,"d":"2,989,562.50"},{"v":207030.63999999966,"d":"207,030.64"},"Adj"]
[null,null,"P19- WFRP Farm Reports","Whole Farm Revenue Protection insurance program was added in 2014. P19 collects additional information for the program that is not accounted for in the other data elements.",{"v":0,"d":"0.00"},{"v":488,"d":"488.00"},{"v":488,"d":"488.00"},"Prog"]
[null,"P20 - Loss Total Record *",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"Adj"]
[null,"P21 - Loss Line Record (Company Claim for Indemnity)",null,null,{"$f":"835390.5+834258.05","v":{"v":1669648.55,"d":"1,669,648.55"}},{"v":1793739.6,"d":"1,793,739.60"},{"v":124091.05000000005,"d":"124,091.05"},"Adj"]
[null,"P22 - Inventory Loss Record",null,null,{"$f":"302.5+302.5","v":{"v":605,"d":"605.00"}},{"v":290,"d":"290.00"},{"$f":"F13-E13","v":{"v":-315,"d":"-315.00"}},"Adj"]
[null,null,"P23- WFRP Indemnity Record","Whole Farm Revenue Protection insurance program was added in 2014. P23 collects additional information for the program that is not accounted for in the other data elements.",{"v":0,"d":"0.00"},{"v":11.8,"d":"11.80"},{"$f":"F14-E14","v":{"v":11.8,"d":"11.80"}},"Prog"]
[null,null,"P26-Production","Captures production information being reported by the producer at a lower level than the APH database which is required by WFRP and STAX programs at the county/crop/unit/practice/type, and attach the production to a specific land location, such as CLU. ",{"v":0,"d":"0.00"},{"v":5855.44,"d":"5,855.44"},{"$f":"F15-E15","v":{"v":5855.44,"d":"5,855.44"}},"Prog"]
[null,"P27- Land ID Record",null,null,{"$f":"472809.48","v":{"v":472809.48,"d":"472,809.48"}},{"v":508225.63,"d":"508,225.63"},{"$f":"F16-E16","v":{"v":35416.15000000002,"d":"35,416.15"}},"Adj"]
[null,"P48 - Delete Record *",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"Adj"]
[null,"P49 - Policy Delete Record",null,null,{"$f":"11124.9","v":{"v":11124.9,"d":"11,124.90"}},{"v":11958.3,"d":"11,958.30"},{"v":833.3999999999996,"d":"833.40"},"Adj"]
[null,"P51 - Conflict of Interest Policy Reporting Record",null,null,{"v":2503.4,"d":"2,503.40"},{"v":2071.4,"d":"2,071.40"},{"v":-432,"d":"-432.00"},"Adj"]
[null,"P54 - Agency/Company Employee Data Record *",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"Adj"]
[null,"P55 - Agent Data Record *",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"Adj"]
[null,"P56 - Loss Adjuster Data Record *",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"Adj"]
[null,"P57 - Quality Control Reporting Record",null,null,{"v":384,"d":"384.00"},{"v":432,"d":"432.00"},{"v":48,"d":"48.00"},"Adj"]
[null,"P58 - Notice of Loss Reporting Record",null,null,{"$f":"33415.62+50049.32","v":{"v":83464.94,"d":"83,464.94"}},{"v":35877.44,"d":"35,877.44"},{"v":-47587.5,"d":"-47,587.50"},"Adj"]
[null,null,"P75- Records Producer Certification","2014 Farm Bill change required capturing records for Beginning Farmer and Rancher information submitted by AIPs. ",{"v":0,"d":"0.00"},{"v":8133.6,"d":"8,133.60"},{"v":8133.6,"d":"8,133.60"},"Prog"]
[null,"P81 - Policy Holder Tracking Experience Inquiry Record *",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"Adj"]
[null,"Additional information provided as needed ",null,null,{"v":8250,"d":"8,250.00"},{"v":8250,"d":"8,250.00"},{"$f":"F27-E27","v":{"v":0,"d":"0.00"}},"Adj"]
[null,"Reading insurance documents",null,null,{"v":278204,"d":"278,204.00"},{"v":298018,"d":"298,018.00"},{"$f":"F28-E28","v":{"v":19814,"d":"19,814.00"}},"Adj"]
[null,"Record Retention",null,null,{"v":167078.52,"d":"167,078.52"},{"v":179373.75,"d":"179,373.75"},{"v":12295.23000000001,"d":"12,295.23"},"Adj"]
[null,"Travel Time",null,null,{"v":864154,"d":"864,154.00"},{"v":928783.92,"d":"928,783.92"},{"v":64629.92000000004,"d":"64,629.92"},"Adj"]
[null,"* Crop insurance companies transmittal of data elements to RMA",null,null,{"v":3217.5,"d":"3,217.50"},{"v":3935.56,"d":"3,935.56"},{"$f":"F31-E31","v":718.06},"Adj"]
[null,"Data elements associated w/Subpart U Ineligibility for Prog. Separate P-rule ICR submitted.",null,null,{"v":1448,"d":"1,448.00"},{"v":0,"d":"0.00"},{"$f":"F32-E32","v":{"v":-1448,"d":"-1,448.00"}},"Adj"]
[null,"Data elements associated w/Area Risk Protection Insurance (ARPI). Will be deleted upon approval of sepatrate final rule package.",null,null,{"v":176473.21,"d":"176,473.21"},{"v":0,"d":"0.00"},{"$f":"F33-E33","v":{"v":-176473.21,"d":"-176,473.21"}},"Adj"]
[{"$nulls":3},"Total Adjustment*",{"$f":"SUM(E2:E33)","v":{"v":8141903.210000001,"d":"8,141,903.21"}},{"$f":"SUM(F2:F33)","v":{"v":8555842.920000002,"d":"8,555,842.92"}},{"$f":"SUM(G2:G33)","v":{"v":413939.7099999996,"d":"413,939.71"}}]
["*Due to program changes and 2014 Farm Bill Implementation, FCIC added several data elements resulting in an increase in burden hours.  On Feb. 7, 2014, the President signed the Agricultural Act of 2014 (2014 Farm Bill) which continues existing programs with modifications, and authorizes several new programs administered by RMA.  New pilot programs, and privately developed crop insurance programs under section 508(h) of the Act for margin protection, peanut revenue, downed rice, machine harvested cucumbers, sprinkler irrigated rice, high amylose corn, peanut revenue, clary sage, hybrid rice seed, Texas citrus tree – lime trees.  These hours were added/removed from the applicable data elements above.\n"]

{"sheet":"Add or Remove Program Changes","index":1,"n_rows":3,"n_cols":2,"rows_kept":3}
["Program/Package Change","Savings/Additional Burden Under Re-evaluated Calculations)"]
["New pilot programs, and privately developed crop insurance programs under section 508(h) of the Act for margin protection, peanut revenue, downed rice, machine harvested cucumbers, sprinkler irrigated rice, high amylose corn, peanut revenue, clary sage, hybrid rice seed, Texas citrus tree – lime trees. The increases and decreases within industry resulted in an overall increase in burden of 413,953 hours.",413.953]
["Total",{"$f":"SUM(B2:B2)","v":413.953}]