ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDECB79D2E0530100007F1FF2 INV Category Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs US 8E2FF36EDECA79D2E0530100007F1FF2 INV Category Set Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name US 8E2FF36EDE8579D2E0530100007F1FF2 INV Item Type Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code US 8E2FF36EDF2F79D2E0530100007F1FF2 PO Buyer Y Y select ppx.full_name value, ppx.employee_number description from per_people_x ppx where ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and ppx.person_id in ( select paaf.person_id from per_all_assignments_f paaf where trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and (:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') ) ) order by ppx.full_name Corrected restriction to show buyers of the inventory orgs business group US C7BD0D887E6561DBE0530100007F00F0 with mmp as ( select mmp.plan_id , mmp.organization_id , mmp.compile_designator , mmp.inventory_item_id , mmp.item_segments , mmp.horizontal_plan_type , mmp.bucket_type , mmp.horizontal_plan_type_text , mmp.plan_organization_id , mmp.organization_code , case seq.column_value when 1 then (mwbd.date1) when 2 then (mwbd.date2) when 3 then (mwbd.date3) when 4 then (mwbd.date4) when 5 then (mwbd.date5) when 6 then (mwbd.date6) when 7 then (mwbd.date7) when 8 then (mwbd.date8) when 9 then (mwbd.date9) when 10 then (mwbd.date10) when 11 then (mwbd.date11) when 12 then (mwbd.date12) when 13 then (mwbd.date13) when 14 then (mwbd.date14) when 15 then (mwbd.date15) when 16 then (mwbd.date16) when 17 then (mwbd.date17) when 18 then (mwbd.date18) when 19 then (mwbd.date19) when 20 then (mwbd.date20) when 21 then (mwbd.date21) when 22 then (mwbd.date22) when 23 then (mwbd.date23) when 24 then (mwbd.date24) when 25 then (mwbd.date25) when 26 then (mwbd.date26) when 27 then (mwbd.date27) when 28 then (mwbd.date28) when 29 then (mwbd.date29) when 30 then (mwbd.date30) when 31 then (mwbd.date31) when 32 then (mwbd.date32) when 33 then (mwbd.date33) when 34 then (mwbd.date34) when 35 then (mwbd.date35) when 36 then (mwbd.date36) else to_date(null) end bucket_date , to_number(xxen_mrp_horizplan.format_quantity ( case seq.column_value when 1 then (mmp.quantity1) when 2 then (mmp.quantity2) when 3 then (mmp.quantity3) when 4 then (mmp.quantity4) when 5 then (mmp.quantity5) when 6 then (mmp.quantity6) when 7 then (mmp.quantity7) when 8 then (mmp.quantity8) when 9 then (mmp.quantity9) when 10 then (mmp.quantity10) when 11 then (mmp.quantity11) when 12 then (mmp.quantity12) when 13 then (mmp.quantity13) when 14 then (mmp.quantity14) when 15 then (mmp.quantity15) when 16 then (mmp.quantity16) when 17 then (mmp.quantity17) when 18 then (mmp.quantity18) when 19 then (mmp.quantity19) when 20 then (mmp.quantity20) when 21 then (mmp.quantity21) when 22 then (mmp.quantity22) when 23 then (mmp.quantity23) when 24 then (mmp.quantity24) when 25 then (mmp.quantity25) when 26 then (mmp.quantity26) when 27 then (mmp.quantity27) when 28 then (mmp.quantity28) when 29 then (mmp.quantity29) when 30 then (mmp.quantity30) when 31 then (mmp.quantity31) when 32 then (mmp.quantity32) when 33 then (mmp.quantity33) when 34 then (mmp.quantity34) when 35 then (mmp.quantity35) when 36 then (mmp.quantity36) else to_number(null) end )) bucket_quantity from mrp_material_plans mmp , mrp_workbench_bucket_dates mwbd , table(xxen_util.rowgen(36)) seq where mmp.plan_id = xxen_mrp_horizplan.get_hp_plan_id and mmp.bucket_type = xxen_mrp_horizplan.get_hp_bucket_type and xxen_mrp_horizplan.hp_source_enabled(mmp.horizontal_plan_type) = 'Y' and mwbd.compile_designator = xxen_mrp_horizplan.get_compile_designator and mwbd.organization_id = xxen_mrp_horizplan.get_plan_organization_id and nvl(mwbd.planned_organization ,mwbd.organization_id) = xxen_mrp_horizplan.get_planned_organization_id and mwbd.bucket_type = xxen_mrp_horizplan.get_hp_bucket_type ) -- -- select hp.* from ( select /*+ push_pred(mea) */ mmp.compile_designator plan , mmp.organization_code organization_code , nvl( mea.end_assembly , case when xxen_mrp_horizplan.is_end_assembly(mmp.compile_designator,mmp.organization_id,mmp.inventory_item_id)='Y' then msiv.concatenated_segments else null end ) end_assembly , nvl( mea.end_assembly_desc , case when xxen_mrp_horizplan.is_end_assembly(mmp.compile_designator,mmp.organization_id,mmp.inventory_item_id)='Y' then msiv.description else null end ) end_assembly_description , xxen_util.meaning(nvl(mea.mrp_end_assembly,xxen_mrp_horizplan.is_end_assembly(mmp.compile_designator,mmp.organization_id,mmp.inventory_item_id)),'YES_NO',0) mrp_end_assembly , case when mea.end_assembly_id is not null then nvl(xxen_mrp_horizplan.get_bom_level(mmp.organization_id,mea.end_assembly_id,msiv.inventory_item_id),0) else null end bom_level , mmp.item_segments item , msiv.description item_description , xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) item_type , msiv.primary_unit_of_measure uom , mck.concatenated_segments category , msiv.preprocessing_lead_time , msiv.full_lead_time , msiv.postprocessing_lead_time , msiv.cumulative_total_lead_time , msiv.cum_manufacturing_lead_time cumulative_mfg_lead_time , (select asu.vendor_name from mrp_system_items msi , ap_suppliers asu where msi.compile_designator = mmp.compile_designator and msi.organization_id = mmp.organization_id and msi.inventory_item_id = mmp.inventory_item_id and asu.vendor_id = msi.primary_vendor_id ) primary_supplier , (select ppx.full_name from per_people_x ppx where ppx.person_id = msiv.buyer_id and rownum=1 ) buyer , xxen_util.meaning(msiv.planning_make_buy_code ,'MTL_PLANNING_MAKE_BUY',700) make_or_buy , xxen_util.meaning(msiv.wip_supply_type ,'WIP_SUPPLY',700) wip_supply_type , msiv.planner_code , mpl.description planner_description , xxen_util.meaning(msiv.mrp_planning_code ,'MRP_PLANNING_CODE',700) planning_method , xxen_util.meaning(msiv.ato_forecast_control ,'MRP_ATO_FORECAST_CONTROL',700) forecast_control , xxen_util.meaning(msiv.end_assembly_pegging_flag ,'ASSEMBLY_PEGGING_CODE',0) pegging , xxen_util.meaning(msiv.planning_time_fence_code ,'MTL_TIME_FENCE',700) planning_time_fence , xxen_mrp_horizplan.get_end_assemblies(mmp.compile_designator,mmp.organization_id,mmp.inventory_item_id) end_assemblies , mmp.horizontal_plan_type_text source_type_text , mmp.bucket_date , mmp.bucket_quantity , mmp.horizontal_plan_type source_type , case when mea.end_assembly_id is not null then nvl(xxen_mrp_horizplan.get_bom_sort_order(mmp.organization_id,mea.end_assembly_id,msiv.inventory_item_id),'0000001') else null end bom_sort_order from mmp mmp , mtl_system_items_vl msiv , mtl_item_categories mic , mtl_categories_kfv mck , mtl_planners mpl , ( select distinct bset.organization_id , bset.component_item_id inventory_item_id , bset.top_item_id end_assembly_id , msiv.concatenated_segments end_assembly , msiv.description end_assembly_desc , nvl2(mea.end_assembly_id,'Y',null) mrp_end_assembly from bom_small_expl_temp bset , mtl_system_items_vl msiv , mrp_end_assemblies mea where bset.organization_id = msiv.organization_id and bset.top_item_id = msiv.inventory_item_id and mea.compile_designator (+) = xxen_mrp_horizplan.get_compile_designator and mea.organization_id (+) = bset.organization_id and mea.end_assembly_id (+) = bset.top_item_id and mea.inventory_item_id (+) = bset.component_item_id ) mea where msiv.organization_id = mmp.organization_id and msiv.inventory_item_id = mmp.inventory_item_id and mic.category_set_id (+) = xxen_mrp_horizplan.get_category_set_id and mic.organization_id (+) = mmp.organization_id and mic.inventory_item_id (+) = mmp.inventory_item_id and mck.category_id (+) = mic.category_id and mpl.planner_code (+) = msiv.planner_code and mpl.organization_id (+) = msiv.organization_id and mea.organization_id (+) = mmp.organization_id and mea.inventory_item_id (+) = mmp.inventory_item_id ) hp where 1=1 order by hp.plan , hp.organization_code , hp.end_assembly , hp.bom_sort_order , hp.item , hp.source_type Y XXEN_MRP_HORIZPLAN US MRP Horizontal Plan MRP: Horizontal Plan from the Planners Workbench. - The report can be run for multiple organizations and items within a selected plan - The report can be used to explode BOMS and display the HP for all components within the BOM - Select a template to choose to either display the HP by individual components, or by End Assemblies, Components. Enginatics R12 only 1=1 :p_bucket_type :p_buyer :p_cat_set_name :p_category :p_compile_designator :p_exclude_item_type :p_exclude_no_activity :p_explode_boms_yn :p_hp_curr_snp_data_type :p_ind_demand_type :p_item_limit :p_item_type :p_make_or_buy :p_orders_cutoff_date :p_planned_item_code :p_planned_item_code_from :p_planned_item_code_to :p_planned_item_code_txt :p_planned_organization_code :p_planner_code :p_source_list 1 -10 1=1 1=1 Char F compiler_designator|organization_id|inventory_item_id US compile_designator|organization_id|inventory_item_id 2 10 :p_compile_designator LOV custom Y select distinct mpsv.compile_designator value, mpsv.plan_type_text||': '||mpsv.description description from mrp_plans_sc_v mpsv where nvl(mpsv.disable_date,sysdate)>=sysdate and mpsv.data_completion_date is not null and nvl(mpsv.plan_type,mpsv.curr_plan_type) in (1,2,3,4) and mpsv.planned_organization in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) order by mpsv.compile_designator Y US Plan 3 20 :p_hp_curr_snp_data_type LOV custom Y select value, description from (select 'Current' value, null description from dual union select 'Snapshot' value, null description from dual ) order by value Current Y F Données actuelles ou instantanées US Current or Snapshot Data 4 30 :p_bucket_type LOV custom Y select flv.meaning value, null description from fnd_lookup_values_vl flv where lookup_type='MRP_WORKBENCH_BUCKET_TYPE' and flv.view_application_id=700 order by flv.meaning xxen_util.meaning(nvl((select mwdo.bucket_type from mrp_workbench_display_options mwdo where mwdo.user_id=fnd_global.user_id),1),'MRP_WORKBENCH_BUCKET_TYPE',700) Y F Seaux US Buckets 5 40 1=1 hp.organization_code=:p_planned_organization_code LOV custom Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id in (select mpsv.planned_organization from mrp_plans_sc_v mpsv where xxen_util.contains(:$flex$.plan,mpsv.compile_designator)='Y') order by ood.organization_code select mp.organization_code from mtl_parameters mp, mrp_plans_sc_v mpsv where mp.organization_id=mpsv.planned_organization and mpsv.compile_designator=:$flex$.plan and mpsv.organization_selection=1 F Code de l'organisation US Organization Code 6 50 :p_cat_set_name LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name select category_set_name from mtl_default_sets_view where functional_area_id = 1 Y F Ensemble de la catégorie US Category Set 7 60 1=1 hp.category=:p_category LOV INV Category 8E2FF36EDECB79D2E0530100007F1FF2 Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs F Catégorie US Category 8 70 1=1 hp.item_type=:p_item_type LOV INV Item Type 8E2FF36EDE8579D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code F Type d'article US Item Type 9 80 1=1 hp.item_type!=:p_exclude_item_type LOV INV Item Type 8E2FF36EDE8579D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code F Exclure le type d'article US Exclude Item Type 10 90 1=1 (hp.item=:p_planned_item_code or hp.end_assembly=:p_planned_item_code) LOV custom Y Y select distinct msisv.item_segments value, msisv.description from mrp_system_items_sc_v msisv ,mtl_system_items_b msib where msib.organization_id = msisv.organization_id and msib.inventory_item_id = msisv.inventory_item_id and msisv.compile_designator = :$flex$.plan and (:$flex$.organization_code is null or msisv.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) and (:$flex$.category is null or exists (select null from mtl_category_sets mcs, mtl_categories_kfv mck, mtl_item_categories mic where mic.inventory_item_id = msisv.inventory_item_id and mic.organization_id = msisv.organization_id and mcs.category_set_id = mic.category_set_id and mcs.category_set_name = :$flex$.category_set and mck.category_id = mic.category_id and xxen_util.contains(:$flex$.category,mck.concatenated_segments)='Y' ) ) and (:$flex$.item_type is null or msib.item_type in (select flvv.lookup_code from fnd_lookup_values_vl flvv where flvv.lookup_type = 'ITEM_TYPE' and flvv.view_application_id = 3 and xxen_util.contains(:$flex$.item_type,flvv.meaning)='Y')) and (:$flex$.exclude_item_type is null or msib.item_type not in (select flvv.lookup_code from fnd_lookup_values_vl flvv where flvv.lookup_type = 'ITEM_TYPE' and flvv.view_application_id = 3 and xxen_util.contains(:$flex$.exclude_item_type,flvv.meaning)='Y')) order by msisv.item_segments F Article US Item 11 100 :p_planned_item_code_from LOV custom Y Y select distinct msisv.item_segments value, msisv.description from mrp_system_items_sc_v msisv ,mtl_system_items_b msib where msib.organization_id = msisv.organization_id and msib.inventory_item_id = msisv.inventory_item_id and msisv.compile_designator = :$flex$.plan and (:$flex$.organization_code is null or msisv.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) and (:$flex$.category is null or exists (select null from mtl_category_sets mcs, mtl_categories_kfv mck, mtl_item_categories mic where mic.inventory_item_id = msisv.inventory_item_id and mic.organization_id = msisv.organization_id and mcs.category_set_id = mic.category_set_id and mcs.category_set_name = :$flex$.category_set and mck.category_id = mic.category_id and xxen_util.contains(:$flex$.category,mck.concatenated_segments)='Y' ) ) and (:$flex$.item_type is null or msib.item_type in (select flvv.lookup_code from fnd_lookup_values_vl flvv where flvv.lookup_type = 'ITEM_TYPE' and flvv.view_application_id = 3 and xxen_util.contains(:$flex$.item_type,flvv.meaning)='Y')) and (:$flex$.exclude_item_type is null or msib.item_type not in (select flvv.lookup_code from fnd_lookup_values_vl flvv where flvv.lookup_type = 'ITEM_TYPE' and flvv.view_application_id = 3 and xxen_util.contains(:$flex$.exclude_item_type,flvv.meaning)='Y')) order by msisv.item_segments F Article de US Item From 12 110 :p_planned_item_code_to LOV custom Y Y select distinct msisv.item_segments value, msisv.description from mrp_system_items_sc_v msisv ,mtl_system_items_b msib where msib.organization_id = msisv.organization_id and msib.inventory_item_id = msisv.inventory_item_id and msisv.compile_designator = :$flex$.plan and (:$flex$.organization_code is null or msisv.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) and (:$flex$.category is null or exists (select null from mtl_category_sets mcs, mtl_categories_kfv mck, mtl_item_categories mic where mic.inventory_item_id = msisv.inventory_item_id and mic.organization_id = msisv.organization_id and mcs.category_set_id = mic.category_set_id and mcs.category_set_name = :$flex$.category_set and mck.category_id = mic.category_id and xxen_util.contains(:$flex$.category,mck.concatenated_segments)='Y' ) ) and (:$flex$.item_type is null or msib.item_type in (select flvv.lookup_code from fnd_lookup_values_vl flvv where flvv.lookup_type = 'ITEM_TYPE' and flvv.view_application_id = 3 and xxen_util.contains(:$flex$.item_type,flvv.meaning)='Y')) and (:$flex$.exclude_item_type is null or msib.item_type not in (select flvv.lookup_code from fnd_lookup_values_vl flvv where flvv.lookup_type = 'ITEM_TYPE' and flvv.view_application_id = 3 and xxen_util.contains(:$flex$.exclude_item_type,flvv.meaning)='Y')) order by msisv.item_segments :$flex$.item_from F Objet à US Item To 13 120 :p_planned_item_code_txt LOV custom Y select distinct msisv.item_segments value, msisv.description from mrp_system_items_sc_v msisv ,mtl_system_items_b msib where msib.organization_id = msisv.organization_id and msib.inventory_item_id = msisv.inventory_item_id and msisv.compile_designator = :$flex$.plan and (:$flex$.organization_code is null or msisv.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) and (:$flex$.category is null or exists (select null from mtl_category_sets mcs, mtl_categories_kfv mck, mtl_item_categories mic where mic.inventory_item_id = msisv.inventory_item_id and mic.organization_id = msisv.organization_id and mcs.category_set_id = mic.category_set_id and mcs.category_set_name = :$flex$.category_set and mck.category_id = mic.category_id and xxen_util.contains(:$flex$.category,mck.concatenated_segments)='Y' ) ) and (:$flex$.item_type is null or msib.item_type in (select flvv.lookup_code from fnd_lookup_values_vl flvv where flvv.lookup_type = 'ITEM_TYPE' and flvv.view_application_id = 3 and xxen_util.contains(:$flex$.item_type,flvv.meaning)='Y')) and (:$flex$.exclude_item_type is null or msib.item_type not in (select flvv.lookup_code from fnd_lookup_values_vl flvv where flvv.lookup_type = 'ITEM_TYPE' and flvv.view_application_id = 3 and xxen_util.contains(:$flex$.exclude_item_type,flvv.meaning)='Y')) order by msisv.item_segments F L'article contient US Item Contains 14 130 :p_explode_boms_yn LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N Y F Explosion des nomenclatures US Explode BOMs 15 135 :p_exclude_no_activity LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y US Exclude Items with No Activity 16 140 :p_make_or_buy LOV custom Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='MTL_PLANNING_MAKE_BUY' and flvv.view_application_id=700 and flvv.security_group_id=0 order by flvv.meaning F Fabriquer ou acheter US Make or Buy 17 150 1=1 hp.planner_code=:p_planner_code LOV custom Y select mp.planner_code value, mp.description from mtl_planners mp where nvl(mp.disable_date,sysdate+1)>=sysdate and mp.organization_id in (select mpsv.planned_organization from mtl_parameters mp, mrp_plans_sc_v mpsv where mp.organization_id = mpsv.planned_organization and mpsv.compile_designator = :$flex$.plan and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y' ) ) order by mp.planner_code F Planificateur US Planner 18 160 1=1 hp.buyer=:p_buyer LOV PO Buyer 8E2FF36EDF2F79D2E0530100007F1FF2 Y Y select ppx.full_name value, ppx.employee_number description from per_people_x ppx where ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and ppx.person_id in ( select paaf.person_id from per_all_assignments_f paaf where trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and (:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') ) ) order by ppx.full_name F Acheteur US Buyer 19 170 1=1 hp.source_type_text=:p_source_type LOV custom Y select ml.meaning value, null description from mfg_lookups ml where ml.lookup_type = 'MRP_HORIZONTAL_PLAN_TYPE_SC' and ml.lookup_code not in (25,82,97,125) and ml.lookup_code <= 160 and xxen_mrp_horizplan.hp_source_enabled(ml.lookup_code) = 'Y' order by ml.lookup_code F Source de l'offre et de la demande US Supply/Demand Source :$flex$.category Category Item :$flex$.category Category Item Contains :$flex$.category Category Item From :$flex$.category Category Item To :$flex$.category_set Category Set Category :$flex$.category_set Category Set Item :$flex$.category_set Category Set Item Contains :$flex$.category_set Category Set Item From :$flex$.category_set Category Set Item To :$flex$.exclude_item_type Exclude Item Type Item :$flex$.exclude_item_type Exclude Item Type Item Contains :$flex$.exclude_item_type Exclude Item Type Item From :$flex$.exclude_item_type Exclude Item Type Item To :$flex$.item_from Item From Item To :$flex$.item_type Item Type Item :$flex$.item_type Item Type Item Contains :$flex$.item_type Item Type Item From :$flex$.item_type Item Type Item To :$flex$.organization_code Organization Code Buyer :$flex$.organization_code Organization Code Category Set :$flex$.organization_code Organization Code Item :$flex$.organization_code Organization Code Item Contains :$flex$.organization_code Organization Code Item From :$flex$.organization_code Organization Code Item To :$flex$.organization_code Organization Code Planner :$flex$.plan Plan Item :$flex$.plan Plan Item Contains :$flex$.plan Plan Item From :$flex$.plan Plan Item To :$flex$.plan Plan Organization Code :$flex$.plan Plan Planner HP by Components Y SYSADMIN 26 BUCKET_DATE 5 27 BUCKET_QUANTITY 14 BUYER 7 CATEGORY 12 CUMULATIVE_MFG_LEAD_TIME 11 CUMULATIVE_TOTAL_LEAD_TIME 23 END_ASSEMBLIES 20 FORECAST_CONTROL 9 FULL_LEAD_TIME 3 ITEM 3 4 ITEM_DESCRIPTION 5 ITEM_TYPE 15 MAKE_OR_BUY 2 ORGANIZATION_CODE 2 21 PEGGING 1 PLAN 1 17 PLANNER_CODE 18 PLANNER_DESCRIPTION 19 PLANNING_METHOD 22 PLANNING_TIME_FENCE 10 POSTPROCESSING_LEAD_TIME 8 PREPROCESSING_LEAD_TIME 13 PRIMARY_SUPPLIER 25 SOURCE_TYPE 4 24 SOURCE_TYPE_TEXT 6 UOM 16 WIP_SUPPLY_TYPE BUCKET_DATE COLUMN 1 BUCKET_QUANTITY VALUE 1 SUM BUYER ROW 12 CATEGORY ROW 7 CUMULATIVE_MFG_LEAD_TIME ROW 10 CUMULATIVE_TOTAL_LEAD_TIME ROW 9 END_ASSEMBLIES ROW 21 FORECAST_CONTROL ROW 18 ITEM ROW 3 ITEM_DESCRIPTION ROW 4 ITEM_TYPE ROW 5 MAKE_OR_BUY ROW 13 ORGANIZATION_CODE ROW 2 PEGGING ROW 19 PLAN ROW 1 PLANNER_CODE ROW 15 PLANNER_DESCRIPTION ROW 16 PLANNING_METHOD ROW 17 PLANNING_TIME_FENCE ROW 20 POSTPROCESSING_LEAD_TIME ROW 8 PRIMARY_SUPPLIER ROW 11 SOURCE_TYPE ROW 22 SOURCE_TYPE_TEXT ROW 23 UOM ROW 6 WIP_SUPPLY_TYPE ROW 14 MRP Horizontal Plan - HP by Components Template.xlsx US UEsDBBQAAAAIABBzm1yQ7xzWmgEAAG0HAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbM2V30/CMBDH3038H5a+mq2AiTGGwQPqoxLFP6CsB2vY2qZXEP57bx34g0yQgNGXtVt79/20d7vr9pdlES3AoTI6Ze2kxSLQmZFKT1P2MrqPr1mEXmgpCqMhZStA1u+dn3VHKwsYkbXGlOXe2xvOMcuhFJgYC5pWJsaVwtOrm3IrspmYAu+0Wlc8M9qD9rGvfLBe9xYmYl746G5Jn2sSBwWyaFBvrLRSJqwtVCY8rfOFllsq8VohIcuwB3Nl8YIwGG9UqFa+F1jbPdLVOCUhGgrnH0RJGHxZ8FfjZmNjZsluJw2UZjJRGUiTzUs6WILWgZCYA/iySMKYlELpDfcO/bAZeRjaJwapzhccH8jR+Sccl3/EYdXC+IGg34B/TCm7lVZVSp46TE0aeyLWSPgEmXESfw9vLbCHzVP1AB6ex6MEN3sE0a8KwBPnSu10n3IuHMhn76jOnhzgs++fpMNIjIm4ztgwP/72v9a1D8+7cKgoDp2xSO3BweFB2dT/yjq25AicV7sD8a5IreVwwa1SDlXzkiAbtHlolr03UEsDBBQAAAAIABBzm1y1VTAj7gAAAEwCAAALAAAAX3JlbHMvLnJlbHONks9OwzAMxu9IvEPk++puSAihpbtMSLshVB7AJO4ftY2jJED39oQDgkpj29H2588/W97u5mlUHxxiL07DuihBsTNie9dqeK2fVg+gYiJnaRTHGo4cYVfd3mxfeKSUm2LX+6iyi4saupT8I2I0HU8UC/HscqWRMFHKYWjRkxmoZdyU5T2Gvx5QLTzVwWoIB3sHqj76PPmytzRNb3gv5n1il06MQJ4TO8t25UNmC6nP26iaQstJgxXznNMRyfsiYwOeJtpcT/T/tjhxIkuJ0Ejg8zzfinNA6+uBLp9oqfi9zjzip4ThTWT4YcHFD1RfUEsDBBQAAAAIABBzm1yry29kqQEAAG0DAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJ2Ty27bMBBF9wXyD4T2NpW4CAqDYlA4KbxoUKFW0vWEGllEKFIgJ4Kdry8lwbKcdNXdPK5GZx4Ud4fGsA590M5myfUyTRha5Upt91nyVPxYfEtYILAlGGcxS44Ykjt59UXk3rXoSWNgsYQNWVITtWvOg6qxgbCMaRszlfMNUHT9nruq0grvnXpr0BK/SdNbjgdCW2K5aKeCyVhx3dH/Fi2d6vnCc3FsI7AUhSMwhW5QpoKfHfG9bY1WQLF7+aiVd8FVxB4OCo3g86SI1DtUb17Tsa8xd8VOgcFN/KGswAQU/BwQW4R+mDloH6ToaN2hIudZ0O9xnDcJe4GAPWaWdOA1WIq4vWx0Btu0gbz84/xrqBEpCD4FB3Oundv6q1wNgmhcCoevBpCYuEQsNBkMv6ocPP2DeDUnHsBG3pHx8XfOts7rd2fjwFluwM5hJ12uO0eLbc5ejmzjmjbelr3s6ywFDw1SPNFPbZ8a+ID8U9vX8NQW7h4ITyu5DIpdDR7LuMVpZVNAbOM2vOmLbGqweyxPms+J/oCex9cjr2+X6SqNtzGLCX5+J/IvUEsDBBQAAAAIABBzm1xq5OzlNwEAAFECAAARAAAAZG9jUHJvcHMvY29yZS54bWyNks1qwzAQhO+FvoPR3ZZspyEVtgNtyamBQlNSehPSJjG1fpDUOnn7ynbiJJBDj7sz+2l2UTHfyyb6BetqrUqUJgRFoLgWtdqW6GO1iGcocp4pwRqtoEQHcGhe3d8V3FCuLbxZbcD6GlwUSMpRbkq0895QjB3fgWQuCQ4VxI22kvlQ2i02jH+zLeCMkCmW4JlgnuEOGJuRiI5IwUek+bFNDxAcQwMSlHc4TVJ89nqw0t0c6JULp6z9wYSdjnEv2YIP4ujeu3o0tm2btHkfI+RP8efy9b1fNa5VdysOqCoEp9wC89pWRUh7LsLhGub8Mtx4U4N4OgT9Rk/wPu4wByIKAegQ96Ss8+eX1QJVGcmymORx+rAiOc1SOpl+dU9ezXeBhoY8PvxP4oRmj5TMLognwJD7+hNUf1BLAwQUAAAACAAQc5tcTUHW0hoBAAB7BAAAGgAAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzvZTBSsQwEIbvgu8Q5m7TdnUV2XQPLsJedX2A0E7bsG0SMnG1b2+s0FpY6h6Kl8DMJP//Mcxks/1sG3ZCR8poAUkUA0Odm0LpSsDb4fnmARh5qQvZGI0COiTYZtdXmxdspA+PqFaWWFDRJKD23j5yTnmNraTIWNShUhrXSh9CV3Er86OskKdxvObutwZkE022LwS4fbECduhscP5b25SlynFn8vcWtT9jwT+MO1KN6IOodBV6AUOKeF9ZRYEY+HmY+yVhqJYOi1fvQq9pBJqk52DSJWEu6Ew6B5P8M0wyB7NeEoZ814ShHwbmJ56zv1vS3odVwtG9D3l/zrbgdkkGq07GP8mw1TsslVbfez8ijVV+7uKAySdfRvYFUEsDBBQAAAAIABBzm1ziK397uwAAADMBAAAyAAAAeGwvcGl2b3RDYWNoZS9fcmVscy9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1sLnJlbHOFj8FqwzAQRO+F/oPYey07h1CK5RwSArkG5wMWaW2L2FqhVUL899ExoYUeh2HezLS7xzKrOyXxHAw0VQ2KgmXnw2jg0h+/vkFJxuBw5kAGVhLYdZ8f7ZlmzCUkk4+iCiWIgSnn+KO12IkWlIojheIMnBbMRaZRR7RXHElv6nqr0ysDujemOjkD6eQaUP0aS/P/bB4Gb+nA9rZQyH9U6OjvnPdY5p3JcnJS4JhGygZ+WU1VpoPuWv12tXsCUEsDBBQAAAAIABBzm1wXDsyGJwYAAP8YAAAnAAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1s3Vlfc+I2EH/vTL+Dxs/nYBknYCbkBgj0uAsXCtzd9FHYAtTYlivZFK5z370r2YCTHG6Uzj20TCYxu/L++Wl3tatcv93FEdpSIRlPuha+cCxEk4CHLFl3rU+Lkd22kMxIEpKIJ7Rr7am03t78/NN1yrY8G5BgQ2/piiUsAwEIhCWya22yLO00GhKYMZEXPKUJcFZcxCSDr2LdkKmgJJQbSrM4ariOc9WICUusQkJHvEQGX61YQG95kMc0yQohgkZEWSI3LJUHaXHwEnExEQ95agc8TkHEkkUs22uhFoqDznidcEGWEUCwEwfBu+d2xiwQXPJVdgGCGoWJz7zFHhi6ZQpzC4kOC7uWGIcYnulKUEAl7O+7Vi/PNhx0lcT75I4TWFlddksyMMjzcMu/uGpeYt/Frn/VtFAA8GY0/HzYWHDiKLtKjFkyK3Qq344ckCBowEU44HmSda0r7ILPopMrU/9yyo8Nf3vql2OP4KN/XQFi6vPNurkOVHTMeS4CirJ9Cpb+ycWD3nTgHp/LFWAf+Iw7vZ7reT5EnVrXtSazKXrHBfvKk4xEaBqRxGrcXDcqwktNI0ajUKKgMNltHSzQdJSQGAzQr6Mkj0dxNgZfHFgEvgsajjMaH1/Gioy2Wrs9wfZ0dquVVpYeTNDSqxaUmu7FmiTsq45GNOAhNVKLTdUp8000DCa43br0X6MG3VIZCJYqz0xUfqD7JSciRDbCDkbw9VXaFxBJJmqnEH8bImmImMLIcBs/3U9MlA0h5E1VDCBT11zsTfRMh7Px9N1w1ru7+DD8rX/fMw/QqaCp4AGVEmo9uoNyjBYs/gdoIQdZIueZ0OcDHBaBSksg9SGxHnRxOlA+5vGSQoGskMYJeFrSoPJ8JlEOOQlSYrI7fSkTWOVgbLhbozyKKq48ze3SehqzCdvRUEUSnFYVL77j2IvdgJp5ckOV4KIOKTcSVUqapnEx5TL73+3QII9zdURvKVpwVdDNAu8/snUVLycr0+T6MT7WZJkOT8c4PAWDlmmP5nmaRoxCo/LyY7UXbgkk45rCyShSU839fG+mbh6zbPMGTcQFes8Tkm3KHsLgOJ+QB4ruBQLdJo6q5YY17Mt4WmC6R6ZH3X1KRdFwTKEQmipWvVFChXGz8v4CaYBfq++V7cRn6KwRHGKShdD+w+7CMSoYieSr7FBn4IRCwx2abK9qTlMFG7xuqnbEocUmMgO8k0zwyEQvvCJh6kEwl0E3JlQ1PYgzNWNK12tlvUH2DkFrT0oaL6N9A81h2EEHKYaxrkNOQa86DzSCydOotfskqbBDNX5Cd5cpESstwtCKij8MxlsDJHpz3Pa91hvUm1967Xa7ePB94766nIFUwqMF3WUvMUINOHpImZOISgTTGkx7yndNrMaDJtxSGMNVqqAQpvIkPK6ckv2SBA8QSI/Iv8AcK2EM/CNngqoJ+yT7C4xxT/Ud2uyn9JkSIPX1wEnAOEELQRIgH60A0owGlG3LVNI2FyUpfKartLgok0cRRUMhHxP7FMJbxxiURSj8Fb8F/50GMCUjsiUsUgMwWhLQWESQNmCQC6EgU1cZYR7BWkhaCrPPyZfpUUxFgcmkWNn7+m3/oe0rftQg4EvdFRcdrAo03SPAGgBGP7qnx+bp0bs8LmidqG09zerX2roLLh5Pa9utE1Wnjl7gnyT4p7XYOZGxU6FXjMNeZQ14YlgP+nnwQDOkLlf+5YZ85ElxRVOZMQpCZSqqDB0wFBVs13Fd22na+HLhOB39o8eLKtezXafCLXereQW7FRZb9FwGIPGYd3WS8IzXquG1a3j+eV7V4qf6XFzznlvDa9bwvBpeBdtnttTg4tbg4tbg4tbg0qzs5FNbmmdx8WynjncWM3jvLGbAO4sZ8M5iBryzmAHvLGbAO4sZ8M5i5tn4LGbAq8EF1+CCa3DBNbhU8/Tx/oEtNbjgGlxwDS74MS4mx01Z3X7NYQKDK+6aCne8Zi3vOIs71+Ka9eYaupQ7mem/KBcM7oVb7mVv6PaGtu/52PbaS2r33b5ne8O+3/JGg6bT9r4d786x9+xW/kWX547f8It/Ftxc77DX+d4/IpTlYFfxW1vZ+N6ym78BUEsDBBQAAAAIABBzm1xRHdiU7AoAABicAgAkAAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlUmVjb3JkczEueG1s7d3BThtXFIDhfaW+gzX7YAw0TRGQRapK3UbtAzhmAKu2x5oxiLx9zbWS66n/I2Xd80tdTNUKJZ8uPn/OXNqbj6/r1eSl7Ydlt7ltZmfnzaTdLLr75ebxtvn7rz/efWgmw26+uZ+vuk1723xth+bj3c8/3WyXL93u03zx1H5uF11/P0z2X2kz3DZPu932ejod9v9kPR/Oum272f+Th65fz3f7v+0fp8O2b+f3w1Pb7tar6cX5+fvper7cNIevcN3/yNfoHh6Wi/b3bvG8bje7wxfp29V8t/99DE/L7fDtq60XP/Ll1vP+n+ftu0W33u6/xJflarn7Wr5oM1kvrv983HT9/Mtq//t/7b994dfTX+d6uei7oXvYne2/0PTwSzz53c6u9r/Ql+UbeDNZdM+b3W3zfnbR3N30dzevk5fb5ryZZn4avhtM9yKizN6Ogyjj74wLUU4/JC5FOUW5EuUU5RdRTlHei3KK8qsopygfRDlF+U2UU5RZiXnrbVxvM5sW/oy3/0OgZ+XkT74zq5bOillLKnYtqRi2pGLZkoppSyq2Lahc2LakYtuSim1LKrYtqdi2pGLbkoptSyq2LanYtqRi24LKpW1LKrYtqdi2pGLbkoptSyrp27Z8sJbbf/Up/QgilPQTiFDSDyBCST9/CCX9+CEUpw9Mn/SLFTop6fcqhJJ+rUIo6bcqGG8mLXzSehsOz4pRS2fFqiUVs5ZU7FpSMWxJxbIlFdOWVGxbUPE2HG4m3dfSWbFtScW2JRXbllRsW1KxbUnFtiUV25ZUbFtQ8TYcvmC2bems2LakYtuSim1LKunbtnyElNtw9Sn9q0NCST+BCCX9ACKU9POHUNKPH0Jx+sD0Sb9YoZOSfq9CKOnXKoSSfquC8WbSwiett+HwrBi1dFasWlIxa0nFriUVw5ZULFtSMW1JxbYFFW/D4WbSfS2dFduWVGxbUrFtScW2JRXbllRsW1KxbUnFtgUVb8PhC2bbls6KbUsqti2p2Lakkr5tyzdLuQ1Xn9K/OiSU9BOIUNIPIEJJP38IJf34IRSnD0yf9IsVOinp9yqEkn6tQijptyoYbyYtfNJ6Gw7PilFLZ8WqJRWzllTsWlIxbEnFsiUV05ZUbFtQ8TYcbibd19JZsW1JxbYlFduWVGxbUrFtScW2JRXbllRsW1DxNhy+YLZt6azYtqRi25KKbUsq6du2HItyG64+pX91SCjpJxChpB9AhJJ+/hBK+vFDKE4fmD7pFyt0UtLvVQgl/VqFUNJvVTDeTFr4pPU2HJ4Vo5bOilVLKmYtqdi1pGLYkoplSyqmLanYtqDibTjcTLqvpbNi25KKbUsqti2p2LakYtuSim1LKrYtqdi2oOJtOHzBbNvSWbFtScW2JRXbllTSt20BKLfh6lP6V4eEkn4CEUr6AUQo6ecPoaQfP4Ti9IHpk36xQicl/V6FUNKvVQgl/VYF482khU9ab8PhWTFq6axYtaRi1pKKXUsqhi2pWLakYtqSim0LKt6Gw82k+1o6K7Ytqdi2pGLbkoptSyq2LanYtqRi25KKbQsq3obDF8y2LZ0V25ZUbFtSsW1JJX3blowtt+HqU/pXh4SSfgIRSvoBRCjp5w+hpB8/hOL0gemTfrFCJyX9XoVQ0q9VCCX9VgXjzaSFT1pvw+FZMWrprFi1pGLWkopdSyqGLalYtqRi2pKKbQsq3obDzaT7Wjorti2p2LakYtuSim1LKrYtqdi2pGLbkoptCyrehsMXzLYtnRXbllRsW1KxbUklfduWYCu34epT+leHhJJ+AhFK+gFEKOnnD6GkHz+E4vSB6ZN+sUInJf1ehVDSr1UIJf1WBePNpIVPWm/D4VkxaumsWLWkYtaSil1LKoYtqVi2pGLakoptCyrehsPNpPtaOiu2LanYtqRi25KKbUsqti2p2LakYtuSim0LKt6GwxfMti2dFduWVGxbUrFtSSV925Y0Kbfh6lP6V4eEkn4CEUr6AUQo6ecPoaQfP4Ti9IHpk36xQicl/V6FUNKvVQgl/VYF482khU9ab8PhWTFq6axYtaRi1pKKXUsqhi2pWLakYtqSim0LKt6Gw82k+1o6K7Ytqdi2pGLbkoptSyq2LanYtqRi25KKbQsq3obDF8y2LZ0V25ZUbFtSsW1JJX3bliFcbsPVp/SvDgkl/QQilPQDiFDSzx9CST9+CMXpA9Mn/WKFTkr6vQqhpF+rEEr6rQrGm0kLn7TehsOzYtTSWbFqScWsJRW7llQMW1KxbEnFtCUV2xZUvA2Hm0n3tXRWbFtSsW1JxbYlFduWVGxbUrFtScW2JRXbFlS8DYcvmG1bOiu2LanYtqRi25JK+radlfeE5Trc0WP6l4fMkn4KMUv6McQs6ecQs6QfRMziJMJJlH7Nwqcl/Z6FWdIvWpgl/aYlyDkzFz9zvSUXnBdDl8+Lpcsupi672LrsYuyyi7XLLuYuu9i76OK9uWB/6V6Xz4u9yy72LrvYu+xi77KLvcsu9i672LvsYu+ii3fpghfT9i6fF3uXXexddrF32cXeLZ+wh1t19dHXjcjiNEIWhxGyOIuQxVGELE4iZHHxgizuXZDFtQuyuHXhnDNz2cXOZRdDl10sXXYxddnF1mUXY5ddrF12MXfZxd7lPZ29yy72LrvYu+xi77KLvcsu9i672LvsYu+yi73LLvYuv4C1d9nF3mUXe5dd7F12sXfZxd4tnySHW3X10XGELE4jZHEYIYuzCFkcRcjiJEIWFy/I4t4FWVy7IItbF845M5dd7Fx2MXTZxdJlF1OXXWxddjF22cXaZRdzl13sXd7T2bvsYu+yi73LLvYuu9i77GLvsou9yy72LrvYu+xi7/ILWHuXXexddrF32cXeZRd7l13s3fIdc7hVVx/rOLq6Ks/T/u5m/1f59+p/9e///HSkcfz4hjF8V5DlcCQcR/ht5DRCFocRsjiLkMXVC7K4eUEWFy/I4t4FWQ7/hXx77r/97/8DNsh/Q5e/jyxddjF12cXWZRdjl12sXXYxd9nF3kUX/x+w3HUXvmfk82Lvsou9yy72LrvYu+xi77KLvcsu9i672Lv8Atb9LrvYu+xi77KLvcsu9i672LvlZBzeq9VH79UdaxzB1HmU98Ihnpg6kIQZfSvViSTMCKaOJGFGMHUmCTOCqUsYYUYwdQsjzAimrmGEGcHUPYwwI5ijm3bKjGVs3+gPBcZvJGP9RjLmbyRj/0YyBnAkYwFHMiZwJGMDBzJHt+9s4FEDH92/U2YsYwNH3002cCRjA0cyNnAkYwNHMjZwJGMDRzI2cCBz6RWISMY9cCRjA0cyNnAkYwNHMjZwMysGh9t59dHL4sjiXXFk8ao4snhTHFm8KI4s3hNHFn8sEln8qUhk8YcikcWfieScM3PZxc5lF0OXXSxddjF12cXWZRdjl12sXXYxd9nF3uU9nb3LLvYuu9i77GLvsou9yy72LrvYu+xi77KLvcsu9i6/gLV32cXeZRd7l13sXXaxd9nF3i1le7hVVx+98H2scQTjfe8AxuveAYy3vQMYL3sHMHUm5f25apxK/rhjcGL8accAxh92DGD8Wcco8EzfSMb2jWSM30jG+o1kzN9Ixv6NZAzgSMYCjmRM4EjGBo52eTZwJGMDRzI2cCRjA0cyNnAkYwNHMjZwJGMDRzI2cCRjA0evbW3gSMYGjmRs4EjGBo5kbOBIBht4ul2+dLtP88VT+7lddP39cPcvUEsDBBQAAAAIABBzm1wKQQzqvQAAAEcBAAApAAAAeGwvcGl2b3RUYWJsZXMvX3JlbHMvcGl2b3RUYWJsZTEueG1sLnJlbHOFj8EKwjAMhu+C71Byt908iMg6D4rgVfQBQpdtxS0tbRV9e+ttA8FjyJ/vz1ftX+MgnhSidayhlAUIYuMay52G2/W02oKICbnBwTFpeFOEfb1cVBcaMOWj2FsfRaZw1NCn5HdKRdPTiFE6T5w3rQsjpjyGTnk0d+xIrYtio8KUAfWMKc6NhnBuShDXt8/N/9muba2hozOPkTj9qFDePl06YH7vSK1l+xXIfAwdJQ1STgI/s6XMOqDqSs306w9QSwMEFAAAAAgAEHObXF/3z6luBgAAgzQAAB4AAAB4bC9waXZvdFRhYmxlcy9waXZvdFRhYmxlMS54bWztW21v2zYQ/j5g/0HQd9WWLNlxELtw7HgN0G1dk3WfGYmOieoNEpU4GPbfdzxKlM6ygaBdgSFQgSbm8Xx8eHxIMeLDq/eHJLaeeFGKLF3Y7ruxbfE0zCKRPi7sP++3zoVtlZKlEYuzlC/sF17a75c//3SVi6dM3rOHmG/4TqRCQgALgqXlwt5LmV+ORmW45wkr32U5T6FmlxUJk1AsHkdlXnAWlXvOZRKPvPF4OkqYSG0d4TIJXxMkYcXXKnfCLMmZFA8iFvIFY9lWEl7ePqZZofAt7EPRBD4UvcCJCIuszHbyHQQaZbudCHkPn+uPCv4kVJYgVHFZiWhh/z2u/znwe6Z+jJ2xq350/v1jWylLAMQnkzDXtkIGubmFGP4ESizP45ffquSBF1udpIUNA4Hm66yITpi3WSp7vp+YlLxIe/ZVLB7ThJ/4xl8ikvsPXDzu22gAKGKSrVmuxnRhf2FxBaNuVTmYefSlIcsM0izSz3xX8HKvEm1qJuBc8lUlMw1FIpsgbpE9/1IAme4zyWLdyTCLj01C8uRTIVJ5L2TMwU0lDPjSbRzGWKQRdKkOAhQIyecNdAHrkiqWIo/5VvA42ooYMoQtL6/iLATeAG0LvlvYK/fy+tad29ZOFKX8APTkxefsGVtHk4qIBq9jWGcxGAJ7tNQzAlspoVeVgubNoJnWbrGDgLbVTwik+t7CzioZCzXDAHK5z55XMQRWn7NC3r/kUMHKkKdqYsL48B2Dbt1VD1JlUndHpc207NYG66AqAd0Iq5dX/CA/lhJ/W1UhgMXe3J/ebC6mzsqdBY4/8ZhzsVq7ztS/Ga8Df7qZbW6AxXpmHlz/22bQeD6a6zm+vIIgl52s7EQcb7Ln9CN74IoVLuIFgPonwh21/kNG6zVzyOjA0WHWD+to/dSBp9SwjtKd56v2dsOT6e0+64eNUrM4fMPWc0jedyRv2LcP+/bT7xKG583bfd4Ms36Y9cOsH94oDe/ohreeeK4xvKMb3tEN7+iGd3TDO7rh9EidwA3nccMJ5//2hFOdVjckdSfqFNaU8IS7KXmkqlvwu4V5t3DRLdDYeN5rWsLTalMiAd1pt44UZt0aGoKgxX4MZ+Hfqy7oMoVm+yxPyJiTYSXcOj+qhEGEWy6FQPlEyUqZR9lFcGiuvXmmgH6F6lDSKtkmUkmT3MC2/mNVymR6LEsxE/1t8cZ0i6xLLqEwaI26ayrhsEc47BEOe4TDHuGwViKZdZpMJhAjdesIFo9gmRAsoFDrfG9CsEwIlgnBMnnLa61SyKHWS6vTXiHkOnma9hbUWB1pFujLQOJ3pIELYM7vVKrM3teUkFmmhMwyJWSWKSGzTAmZZUrIclNClpsSstyUkOVt60jztkjRuBSO3g+1zhQQrJWklkJyKSa9DLShKCqPotIrQZsjikrP/rYWQY7MGOBw3BJdID65QYIHfj/0v/UEMwPRjaA5YYHwFhYuaBQrlB0/acB9D+wmeuCnEx74TfTA7J7wwNbR4xwOHDWNqH7c96CiXbucQ4Lta5dz3cERR5dz7SAJ0KNeNvtJQ2KgCzqfymubWGzxlEubWU3aUz46t2cq27TqfdepAJ3EnnPpJFYLPoEEirlI1+UV6ILpOqIUrS3RNXTjhP6E6Hqr0elFl3oIucevHiV77OmNUG9Qe5SsDe1w9IawAdYms7GYvDRYOxTsM66xtGRvLO0499neWNpJ1Fh6kPWGheSuh1kvV8SnnTZNxttZ0lh6mPVGhsRpZ07zrR5mr4dZb2y6cfTmhlh6mPUmh/j0MOvNDvExmBUxax6bjQKRZhtrfTngrkqsbGddV+FXLq0/KpZKuMwAOnO1wfBA7P7ASq1gx2UUi6oBtVpYnS37VENoG63F0nhR406+xPw23WXdGwlo/JVHokpA+66U5yBN1+p3rbxXJvgr4dgEXneyELnS59eSdfA6Nn1kpQRzlajLJQpaf8Mzn3o322DjOsF65Tl+OJ84Fzdb39lcb4P1OPAn8433g+Tnx9dXqIAS7rUokT0mYS8iru9BNFcCajk8jMDRbZeTmkN+CHn3nosaJBS4tzL8mT9bTd2p77gXwcrxx5s1yPBXgbMdu4HrBe54E/htHvIIVP+vafn4po071fu1ejsasxf4G089lyGiFuUfZcWdWjepok/UXDcoTWZg4I3x9/Q+yzs1potHGv6j8Mt/AVBLAwQUAAAACAAQc5tc06NI1XEDAADACQAADQAAAHhsL3N0eWxlcy54bWy1VtuO2zYQfS/QfyC4r9XqspZjO5aD+CIgQBoU2Q1QIC4KWqJsIrwIFLWRWvTfO6RkW25uGyN9sckh58yZmUNS8xeN4OiR6oopmeDwNsCIykzlTO4T/O4h9SYYVYbInHAlaYJbWuEXi59/mlem5fT+QKlBACGrBB+MKWe+X2UHKkh1q0oqYaVQWhADU733q1JTklfWSXA/CoKxLwiTuEOYiewpIILoD3XpZUqUxLAd48y0Dgsjkc1e7aXSZMeBahOOSIaacKwj1OhjEGf9JI5gmVaVKswt4PqqKFhGP6U79ac+yc5IgHwdUhj7QXSRe6OvRBr5mj4y2z68mMtapMJUKFO1NAmOTibUrbzKocfjEUZdV1YqhzrlW08IsfXadosOh5kQs6rC/hHswjO+9Lz55eYm+BM9f/+W5n9sPTfdIuvr90wW80LJISHoB9R/9kGqjzK1S0AIWNpdi3n1F3okHCyBxcgUVxoZUBOQDB0jImi3Y0U422lmjQURjLedObIGJ8B+n2AgB0eoi9D97uyu/z2WC1lBTMb5qSV3NlkwLOagXkO1TGGC+vFDW0KqEg5aR9nt+8buvSZtGMVPd6gUZ7llsV+5Auv9LsFpunm5SVMHs+sXmMxpQ0ExIBhLZ0D4RM5xhBx3SudwiRyFZ1vamRZzTgsD7prtD/bfqNLGUMbAQVvMc0b2ShJuAxw9+gHAZpTze3vR/F5cYDfFQJZwZdlKW23bIRDqhx1eN7H4Q7QOewD7DCh/PyxqihP+l7zDM6kIoyGpkzciZclbex6s0vsZJNLr/gI5dIfwW/n+B/pNLXZUp+7Ufxa0uxR+MOqTOnNVEb4TuWSPyixr0Jx95KwYLks6/kE1dRIDUQ2Ue6HbkwKRvcoS/MY2hMOD0qsI7WrGDZOf0Sxg5s35FDhFG/vQufNxigKFyWlBam4eTosJPo9/pTmrBeiw3/WbrYyDSPB53O2a2hi0Ma8ruDPhH9WaJfjvzfLZdL1JI28SLCfe6I7G3jRerr14tFqu1+k0iILVP4Pn9rqHLbCPrfs6gGaFo1nF4UnWfbI9+fuzLcGDyWt717g2+0B7yH0ajYOXcRh46V0QeqMxmXiT8V3spXEYrcej5SZO4wH3+DruYeCH4Zl8PDNMUM7ksVfHDg2t0CSYfiUJm4rrhH/+9Fr8C1BLAwQUAAAACAAQc5tcvaC/vRwHAAAdIgAAEwAAAHhsL3RoZW1lL3RoZW1lMS54bWztWktvGzcQvhfofyD2nliyJccyIgeWLMVJ/IKtpMiRWlG7tLjLBUnZ0a1IjgUKFE2LXgr01kPRNkAC9JL+Grcp2hTIX+iQqwcpUbGcB/qyA8RL7jfD4bw4O/T1Gw8Shk6IkJSn1aB4tRAgkoa8Q9OoGtxtNa+sBUgqnHYw4ympBgMigxsbH35wHa+rmCQEAX0q13E1iJXK1peWZAjTWF7lGUnhXZeLBCsYimipI/Ap8E3Y0nKhsLqUYJoGKMUJsN3vdmlIUEuzDDZGzBsMhqmSeiJk4kizJg6FwXZ6Rf1LDmSdCXSCWTWAdTr8tEUeqAAxLBW8qAYF8xMsbVxfGhMxNYfWomuanyHdkKDTWzZriqg9XrTYLFWubY35GwBTs7hGo1FvFMf8DACHIew0l8XmWWquFWsjnhYof5zlXS+UCyUXb/FfmeFfqdVq5cpQlpypAeWPpRn8WmG1tLns4A0ox5dn5a9t1uurDt6AcvzqDL55rbJacvEGFDOa9mbQ2p5jy4whXc62vfA1gK+NHGCCAm8Ye5deostTNc/XEnzMRRMAxrhY0RSpQUa6OAQvruOkLSgOUIZTLmGisFxoFlbgf/2vZJ5KWhd4nWCLLp8K5cyUlgTJUNBMVYPbwDWwIK+ef//q+VP06vmTs4fPzh7+dPbo0dnDH3NeDuE2TiOb8OW3n/359cfoj6ffvHz8hR8vbfyvP3zyy8+f+4EQX5P9v/jyyW/Pnrz46tPfv3vsgW8K3LbhLZoQifbIKTrkCezNIzlpi4tRtGJMHQocA28P64aKHeDeADMfrkZc5d0TkFp8wJv9Y0fWo1j0FfWsfCdOHOAu56zGhVcBd/RaloZb/TTyLy76Nu4Q4xPf2nWcOqZt9DPIqeCys7qvx8QR84DhVOGIpEQh/Y73CPGQ3afU0esuDQWXvKvQfYpqmHpV0qJtx5EmRNs0AbsMfAKCqR3d7N5DNc58u94iJy4SAgIzj/Atwhw13sR9hRMfyxZOmK3wHaxin5BHAxHauIZUYOmIMI4aHSKlj2ZfwH4to9/BkM28Zt9lg8RFCkV7Pp47mHMbucV79RgnmVdmmsY29pbsgYtidMCVD77L3QjRY7ADTuea+x4ljrnPTwR3aeSINHEQ/aYvPLa8SbgbjwPWxcSXZTZF4iTWTcjhPu+o9SPHtXcIYfgUdwhBd295JKjxzNH5ROjbMWSVbeJzrNvY9VU9TomE2kgXM7NhukOl47JHJOJz5NkdTCWeAU4TLOZx3gOrO64LZ5s3le6zsGcD9yjUfOAvXqXsS+BhOXdjHteDGDunlh5Lv78OhGO/RWIM4vL4onEJNOTCNJDYF9ZNCzNngYnDtDBFO750CySO+Sck+lw1ZH0vXdcN2okZoBpyipyEpq+reBgFA05VPOXLiicv2aYrnnmZZXuqzpmH+xdWN1u4nx4QOFBmU9dlcXNZ3AT/+eJmXixfljSXJc1lSeP7CHsvJc2kioECZ9LhMc2SZG67p0sZO1IDRnak6fhI+LDpNGHSDEw/ctz+y2J4HHa6HFwksKFBgquPqIqPYpxBc6hompeRHLKOJMq4hJ6RmfbyNo1RCi0h0+Msj7qZgMZql3fy6RW7yzlmY3qekemkjhZa0QwWXWzl2rB1+oaLFXOpFtxa0YhmKgZna+Mtw2Zmt2Z2ONQmfDEj+M4GLa9Cs1lzgz4alNcdrfe8Azwyi9HJuzSRjOGbcGgjve/ZjRSNkUa+MnIjj410x/IcrVmrVTTbt1htESPZy5XmLDey3ttYaaSdiZV03E6FI0vt4GQpOq0GlfJyOUAhzqpBFxq08JhkYHWpv3cwi+CWI1Qid8Rzg9mgJtas+N2yCD33OdZ0lsiEVFtYxrlrmFejS4DUtJON/MtlUOu72kDu6W8gxcoaOMPfJgXI7JqWdLskVLaxrRnTTzeAYfDzviLiKO6cojbri0MM5teuCvvpUAmfZSYj6AFcCmltm5GbnIdBZ1/FGFw+j1kW42G61SE6iuQcbnQ+lsGMLPHGI7ObiexTw0W3YkL+HW3FduP/2Vb0eQKt7ZWOuYmBO0mBkY7XasCFijlkoSymYVPAhYzxAPAWuFiE16B8uBk1vwU50b/zmMt5mLCGDqU6pBESFM4jFQtCDiAtGe87h1lxeHblLEeM8pieiCuzXOw2OSGspXPIqj7bAxSPsskwDRjctP+546HbtSNdsPxTK588mC9aHkwqn5x+wVqkZCV96yiovJ0IFzxq84w1s+Pl8sJHbQYXFHAvqcAnQipCaDSa0hes3OKHkDrRuKJE4NVX8sID6QSZP7WhcMonc2fSrN5vGTWpdMfrvsfi0zrmx8WZu5wTi6+vPi+m7KGGHV3bla5H1WCA6RDV5dHoQ8YYxvx9hv0nFLx9DIbegsvqPlMyv4Z+ANdRcGTl190Q/LlxDenGX1BLAwQUAAAACAAQc5tcX1VoPdwCAAByBgAADwAAAHhsL3dvcmtib29rLnhtbKVVXW/aMBR9n7T/4FmV+hQSh5BBRKhaoCrSOqG1ax+RSQyxmtiRYyC06n/fdUL4GHuouggc7Ot7fM7xtelflVmK1kwVXIoQk5aDERORjLlYhvj3463VxajQVMQ0lYKFeMsKfDX4+qW/keplLuULAgBRhDjROg9su4gSltGiJXMmILKQKqMaumppF7liNC4SxnSW2q7j+HZGucA1QqA+giEXCx6xkYxWGRO6BlEspRroFwnPiwYtiz4Cl1H1ssqtSGY5QMx5yvW2AsUoi4LJUkhF5ynILkkHlQo+PnyJA43brAShs6UyHilZyIVuAbRdkz7TTxybkBMLynMPPobkgQlrbvZwz0r5n2RlDK2xwIV6a4zk/0YjUFoNnPtJtM6em4sH/QVP2VNduojm+U+amZ1KMUppoccx1ywO8Xfoyg07GVCr/GbFU4i6Xq9NsD3Yl/NUIYDVTE0VX9NoC2cCo5gt6CrVj1DazYIw7nqu65vcUgWNZVOtEPyejH4AhQe6BkIgO97V6wRWJO2ZiFRAZm89p9NznaFnOZ2ub3lDn1jXozGxxn57OHZvet2u130Hz5QfRJKudLLTaqBD7IGws9A9LZsIcYIVjw803pzdY5n3X00TezdyzKl+4mxTHFwxXVQ+cxHLTYgt4oKo7Wl3UwWfeawTsLXneDClHrtjfJkAY9LpmkEaab5mj3ReWQsHyfAM8Qm/Uc3vFp6qOeFnHxGsbhMgWr2RqCrg/tcU3UnFX6XQNEXTlMKpqCZU/mOkArOgmsTVzh+nTvlaautuiuZbNIRLAa48oeFO2WfDqd9nu2fZVAEBqJ3jjPZRRttk2A1nqCouWGzKFhQc9XY6ZmUqstbstirHEdV0Tgtmqjmi6UMjBwxNeBwzc3njweU/tF9+u7i+IMHFNbR9+2gZoHJKAXAjqH/zqpxyXZdUFuXGliGFqx2IHjowE4bMVA8O0cEYr5J5kmQ3fxeDP1BLAwQUAAAACAAQc5tcyKG4+rgAAAA0AQAAIwAAAHhsL3dvcmtzaGVldHMvX3JlbHMvc2hlZXQyLnhtbC5yZWxzhY/BCsIwEETvgv8Q9m7SehCRpr2I4FXqB6zptg22SchG0b83xwqCt9kd9s1O1bzmSTwpsvVOQykLEOSM76wbNFzb02YPghO6DifvSMObGJp6vaouNGHKRzzawCJTHGsYUwoHpdiMNCNLH8hlp/dxxpTHOKiA5o4DqW1R7FRcMqD+YopzpyGeuxJE+w45+T/b9701dPTmMZNLPyJUsE+fWrxNlKkYB0oapFyseaFLmX8HVVfqq2v9AVBLAwQUAAAACAAQc5tcnm1ymZ8DAAB2DAAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbKVXXY+jNhR9r9T/gHjo2wB2Qr6aZDWaUTQrdaXRTrt9dsAk1gBGxpmvVf97jw2GrGYrxdMo4V4wPj7XPr6+WX96qcrgiatWyHoTkigJA15nMhf1YRP+9efuahEGrWZ1zkpZ8034ytvw0/bXX9bPUj22R851AIS63YRHrZtVHLfZkVesjWTDa7QUUlVM41Yd4rZRnOW2U1XGNElmccVEHXYIK3UJhiwKkfFbmZ0qXusORPGSafBvj6JpHVqVXQJXMfV4aq4yWTWA2ItS6FcLGgZVtvp8qKVi+xJxv5Apy4IXhS/Fb+KGsc/fjVSJTMlWFjoCctxxfh/+Ml7GLBuQ3sd/EQyZYgKehFnAEYp+jBJJByw6gk0+CGZWpiNmpkutTiLfhN+T/nMFS8wlGS+u7Z9wu84FVth0DhQvNuE1WV1fz8gkjLdrK6Fvgj+3Z35gFLmX8tE0fMZICUAaVvPg9aHBukLdYaBl8wcv9A0vS0AiRpZp8cTv8dom3EutZWXareY1HhVKvvHajslLjndBx2D+8DJa44HSue/o7ewmuFdBzgt2KvWNLP8WuT6CEvZb//CrfL7j4nA0RGk0TzFlRlur/PWWtxnEjogiaqhksgQyrkElzKaFVtmLtc89KonSeTIhFCB73updH312ahGgG7qH6kAwFRYE1oHMoylN5wsfFKyzRYHtURbeTKY9Bqxjgt14YRgI2BKAdZ3B5cLOZtObzrB953lEpsnMYxrnPQSsG3/pP43IuZYIbI9CqT/KskeBdVymEV2kJPWJyCi0kxccx2byAZxBpqNO6TRapOl0tjBqv3CRiFOqcRwfaOXS7k6iyCSjvnyXmTiRGmdQqbfUiZOrcQa9epNxuiWjcMnMG8VJl5xpd+KvOuLEaxy3Pkhc3rpz8iVn+p15TzF18jWOv1yoU61x/sdepEN+PUuwy2hOkuXEQ/zUqdc442b0ztPU6dc4Y1ieyc7kxe7QOJMv9V8ip196pt8P5DvqFGwct5vSS+c47k5Ve47fMs3cOd757KTlTpSaq7NqBJL4aVWz/M+qBod3ww78C1MHUbdBiVLDnOrgq7qT3/ooUqxnkqItSdzdEeUzR5mYRFj+QkrQ6W563AeuTw3qk4arB/GGIgVbRyqB2sHWx5uwRCHfZmgPgyMa3iRayttGmGLJ/AvQIhvugdmNt7MDbdcyz+/sg+1vrGp+v/ny9T64G1CCe4Cv4/Gldfxj93j4x7D9F1BLAwQUAAAACAAQc5tc2yBlTTESAABbjgAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbKWdW1MbybJG30/E+Q8E7wO0QAIctneodL+h+/VNBmEUA4gtyfbMObH/+85St1B/md1fCI9jxshaldXdWZksXaD0+V9/vTyf/FysN8vV65fT4Ozi9GTxer96WL5+/3I6HJT/uDk92Wznrw/z59Xr4svp34vN6b++/u//fP61Wv+5eVosticyw+vmy+nTdvv26fx8c/+0eJlvzlZvi1chj6v1y3wr/1x/P9+8rRfzh13Qy/N55uIid/4yX76ehjN8Wh8zx+rxcXm/KK7uf7wsXrfhJOvF83wr5795Wr5t9rO93B8z3ct8/eePtz/uVy9vMsW35fNy+/du0tOTl/tPte+vq/X827Nc91/B1fz+5K+1/JeR/y/3h9ndb470srxfrzarx+2ZzHwenrO9/Nvz2/P5/ftM9vqPmia4kgT8XPoFPEyV+b1TCrLvc2UOk13+5mR+ZcIT8+laf/qxfPhy+v8X0Z8/5Gvg/7r44yLwf8X+/Of06+eHpaywDz5ZLx6/nOaDT64W3J6ef/28q6DRcvFrE7t9sp1/6y+eF/fbhRwlOD3xBfpttfrTD6zJXRcy59v8dXHyd/9NlvnLqVzhdvXWXDxuC4vnZzmCnOX8frv8uejIsC+n31bb7erF810LbOWux/Xq/xavu3PYHcqfnZ8TB4eTHCbd/Du8gksfeP5+9vHb+ysp79qlsz55WDzOfzxvC6vn8fJh+yRXFJxdZbLXN0Eme7qnvdWv6mL5/UkuJsicXQvYleOnh7+Li8299Idc9VnGH/V+9SyHkL9PXpa+z6W853+FaQqnzwRn18HF7aWf5P7HRi58f9woPAyUnO0C5WsUGFzHzuvbYrMt+9zKxGQWSfRuFvm6nyV3lrnJBtmcvzoSeRVFytd95M1ZcHWxizvy6DJyd3T5up8j+9E5/PcHP4d8jea4Pvr4MnIXK1/3yb84u8lmr3I3PvtHXoV8X97NIl/3s2TOstcXl7sCOXKS22gS+bpPxdVHUxGIMsJikhv7U7n8eFEE70V5qMog9+Gz2VdocCjRzMevaV+hAZToBwst2Ferv3Eo148uUrAvWH9jP42c15FrHOxr1d94b7fjw/flGhzqNfid5d0XbPCPKlYMEFVbrGZzH6+2zL5q/Y1DA31whTP7mvU39rNkP9yGmfdvq7GizXy09DP7ovU3/kEjZvZl62/sCybzGyne163/hvRPzmdfwJlYAf/O+ewr+eqQ5duYdo7sp6t9mrOHNZeSPjI6u1/q3CFaKplHn4f63j1yKM6386+f16tfJ/J4UebYyOMPefQdfPITJupfvO/H5v3gnfXEzxt5MPTz68Xn85/yKOQ+GjGzI4L3EedyyPfjykUcf1w/GI+bweM6O+ISRxTsiCscUbQjsjiiZEfkcETZjrjGERU74gZHVO2IWxxRsyMCtRD1hCGHlditZiNhiEprM2GIymsrYYhK7F3CEJXZdsIQldpOwhCV227CEJXcXsIQld1+QrWp7A4ShqjsDhOGqOyOEoao7I4ThqjsThKGqOxOE4ao7M7CIZldU19d5S7VFPm8HqAmyEcteJhBLU4+6sDDALU0+agBDwPUwuSj/nsfcKWWJR+132GAWpR81H2HAWpJ8lHzHQaoBclHvXcYoJYjH3XeYYDOZNR3hwE6k1HXHQboTEY9dxigMxl13GGAzmTUb+8DsjqTUbcdBuhMRr12GKAzGXXaYYDOZNRnhwE6k1GXHQboTEY9dhigMxl12GGAzmTUX4cBOpNRdx0G6ExGvfU+IKczqTsrpzLpdGfltNt0Z+VUJp3urJzKpNOdlVOZdLqzciqTTndWTmXS6c7KqUw63Vk5lUmnO+v6kEl45CAPno5/5CCD3x+rZPQ5A1TnWwCozrUYh5dqxUsA1WqXAaqVrgBUq1wFqFa4drn7xq1C6iykkRjSDO9Vl9SCiVTx3AFUhdMGqBagA1AtQBegWoBeHGoN9AGqBRgAVAswBKiyOQKoFmAMUGVoEiZVP0abQowWsi9z/+pQwnLk/euMqdAx6Ms6NdKXdSr0ZZ0KfVmnQl/WqdCXdSqUsk6HvrpTI6W606EUeTr0tZ46ra/1VOhrPRX6Wk+FvtZToa/1VOhrPRX6Wk+FvtZToa/1VOhrPRVKradDX/GpkTMCHat4xyresYp3rOIdq3jHKt6xines4l1KxYMA5TWV4wUog9MFCFALEKAWYBwaAQLUAgSoBQhQCxCgFuBVogBZSCMxpBneqwUIE2kBAtQCBKgFCFALEKAWYBwaAQLUAgSoBQhQCxCgFiBALcAwqRmV1SnEqNzMfJmnCpBBx2CBwSKDJQbLDFYYrDJYY7DOoFQ3ESCDLQbvGGwz2GGwy2CPwT6DAwaHDI4YHDM4YdBXfLoACXR5BlnFO1bxjlW8YxXvWMU7VvGOVbxLqXgQoLwAfbwA469Wm2eAALUAAWoBxqERIEAtQIBagAC1AAFqAWYTBchCGokhzfBeLUCYSAsQoBYgQC1AgFqAALUA49AIEKAWIEAtQIBagAC1AAFqAUap1gKEGHX5M1/mqQJk0DFYYLDIYInBMoMVBqsM1hisMyjVTQTIYIvBOwbbDHYY7DLYY7DP4IDBIYMjBscMThicMsgq3uVJpGMV71jFO1bxjlW8YxXvWMU7VvEupeJBgPIu9vEClMHpzwABagEC1AKMQyNAgFqAALUAAWoBAtQCDF8q0y+BspBGYkgz8TW3FkykBQhQCxCgFiBALUCAWoBxaAQIUAsQoBYgQC1AgFqAALUAw6Re6XcmIUZd4cyXeaoAGXQMFhgsMlhisMxghcEqgzUG6wxKdRMBMuhrPf0lUAbbDHYY7DLYY7DP4IDBIYMjBscMThicMsgq3uVJpGMV71jFO1bxjlW8YxXvWMU7VvEupeJBgPJzWMcLUAanCxCgFiBALcA4NAIEqAUIUAsQoBYgQC3A60QBspBGYkgzvFc/A4SJtAABagEC1AIEqAUIUAswDo0AAWoBAtQCBKgFCFALEKAWYJjU2Jvaux/CmsZj9E9hzHyZpwqQQcdggcEigyUGywxWGKwyWGOwzqBUNxEggy0G7xhsM9hhsMtgj8E+gwMGhwyOGBwzOGHQV3z6S6AEujyDrOIdq3jHKt6xines4h2reMcq3qVUPAjQ/07d0T+2K4PTBQhQCxCgFmAcGgEC1AIEqAUIUAsQoBbgTaIAWUgjMaQZ3qsFCBNpAQLUAgSoBQhQCxCgFmAcGgEC1AIEqAUIUAsQoBYgQC3AMKk36lSm8ZisgjNf5qkCZNAxWGCwyGCJwTKDFQarDNYYrDMo1U0EyGCLwTsG2wx2GOwy2GOwz+CAwSGDIwbHDE4Y9BWfLkACXZ5BVvGOVbxjFe9YxTtW8Y5VvGMV71IqHgQov/FyvABlcLoAAWoBAtQCjEMjQIBagAC1AAFqAQLUArxNFCALaSSGNMN7tQBhIi1AgFqAALUAAWoBAtQCjEMjQIBagAC1AAFqAQLUAgSoBRgm9UZNOI3HZNWpzHyZpwqQQcdggcEigyUGywxWGKwyWGOwzqBUNxEggy0G7xhsM9hhsMtgj8E+gwMGhwyOGBwzOGHQV3y6AAl0eQZZxTtW8Y5VvGMV71jFO1bxjlW8S6l4EKD/XfnjDehHpysQqXYgUi1BoMaCSLUGkWoPItUiRKpNKDTp3UAa1EgOakZ3axviXFqHSLUPkWohItVGRKqVCNQ4EamWIlJtRaRai0i1F5FqMUYJvtFvDkJUVh1xtmuAVDdS6igtUFqktERpmdIKpVVKa5TWKfV1TzRJaYvSO0rblHYo7VLao7RP6YDSIaUjSseUTiidUkp7weVZrKO94GgvONoLjvaCo73gaC842guyx1NyPaM+P7bxgYwm+gRq9AnU6DNOrT6BGn0CNfoEavQJ1OgzSNYnC2rI9jsJzm1Gdxt9wlxGn0CNPoEafQI1+gRq9BmnVp9AjT6BGn0CNfoEavQJ1OgzzPuNysPUb4f0XrRZNefMU6JPRh2NLVBapLREaZnSCqVVSmuU1in1dc/0yWiLxt5R2qa0Q2mX0h6lfUoHlA4pHVE6pnRC6a4X0p9zMir6JLGiT0ZpL4g+WSztBdEni6W9IPpksWm9gPr80P49fic1ok+gRp9AjT7j1OoTqNEnUKNPoEafQI0+w+0g9M+iQhouVVBDaKI+w7uNPuEEjD6BGn0CNfoEavQJ1OgzTq0+gRp9AjX6BGr0CdToE6jRZ5jgG3UtU1itrIqaeUr0yaijsQVKi5SWKC1TWqG0SmmN0jqlvu6ZPhlt0dg7StuUdijtUtqjtE/pgNIhpSNKx5ROKN31AtEnoaJPRmkvyLNPFkt7QZ59sljaC/Lsk8XSXpBnn8mxqE+/18HRP7/jtxAl+gRq9AnU6DNOrT6BGn0CNfoEavQJ1OgzeTcbSIPVZ/J+NhKUqE84AaNPoEafQI0+gRp9AjX6jFOrT6BGn0CNPoEafQI1+gRq9Bkm+Fb/aiOsVlbvbuMp0SejjsYWKC1SWqK0TGmF0iqlNUrrlDYobVLaovSO0jalHUq7lPYo7VM6oHRI6YjSMaUTSqeUzhgVfbJtcWgviD5ZLO0F0SeLpb0g+mSxtBdEn8mxqE+/GcLx+oxvM2K2APA7ax/kavQJ1OgzTq0+gRp9AjX6BGr0CdToM3kvHLhQq8/k3XAkKFGfcAJGn0CNPoEafQI1+gRq9BmnVp9AjT6BGn0CNfoEavQJ1OgzTPCtee8zHpXVe+P4tST6ZNTR2AKlRUpLlJYprVBapbRGaZ3SBqVNSluU3lHaprRDaZfSHqV9SgeUDikdUTqmdELplNIZo6JPum8OpbQX5MVbNjPtBXnxlsXSXpAXb1lsWi+gPv1WCsfrM75JidUnUKNPoEafcWr1CdToE6jRJ1CjT6BGn8k76fiPznh/nGD1mbyXjgQl6hPmMvoEavQJ1OgTqNEnUKPPOLX6BGr0CdToE6jRJ1CjT6BGn2GC5dOfcIv8KSxXVm+t4ynxJ6OOxhYoLVJaorRMaYXSKqU1SuuUNihtUtqi9I7SNqUdSruU9ijtUzqgdEjpiNIxpRNKd71AXr1lG+vkWay8+cliaS+IP1ks7QXxJ4ulvSD+ZLFpvYD+9DsxHO/P+B4n1p9AjT+BGn/GqfUnUONPoMafQI0/gRp/Jm/E4z87ivgzeSseCUr0J8xl/AnU+BOo8SdQ40+gxp9xav0J1PgTqPEnUONPoMafQI0/wwQHF+b5Zzwsq3fm8YtJ/Mmoo7EFSouUligtU1qhtEppjdI6pQ1Km5S2KL2jtE1ph9IupT1K+5QOKB1SOqJ0TOmE0imlM0bl+SfdtYdS2gviTzYz7QXxJ4ulvSD+ZLFpvYD+9Bs5HO/P+BYp1p9AjT+BGn/GqfUnUONPoMafQI0/gRp/Ju/j4z88kfgzeScfCUr0J8xl/AnU+BOo8SdQ40+gxp9xav0J1PgTqPEnUONPoMafQI0/wwQH5rM9YLn0hwLNPCX+ZNTR2AKlRUpLlJYprVBapbRGaZ3SBqVNSluU3lHaprRDaZfSHqV9SgeUDikdUTqmdELplFLaC+JPuukPpbQXxJ9sZtoL4k8WS3tB/Mli03oB/en3gTjen/EdVqw/gRp/AjX+jFPrT6DGn0CNP4EafwI1/kzeBsh/aDDxZ/JGQBKU6E+Yy/gTqPEnUONPoMafQI0/49T6E6jxJ1DjT6DGn0CNP4Eaf4YJlg9N1q/fxsP0Z+bN/GISfzLqaGyB0iKlJUrLlFYorVJao7ROaYPSJqUtSu8obVPaobRLaY/SPqUDSoeUjigdUzqhdEop7QXxJ90ziFLaC+JPNjPtBfEni6W9IP5ksWm9gP7020gc78/4Bi3Wn0CNP4Eaf8ap9SdQ40+gxp9AjT+BGn8m7yIUsKCG0MRfXkneSAjnMv6EIxl/AjX+BGr8CdT4M06tP4EafwI1/gRq/AnU+BOo8WeY4EBvHTuFFOuPlJ15SvzJqKOxBUqLlJYoLVNaobRKaY3SOqW+8NlvrzDaorF3lLYp7VDapbRHaZ/SAaVDSkeUjimdULrrBfL+J91xiMXK+58slvaC+JPF0l4Qf7JY2gviTxab1guhP883T4vFtjjfzr9+fpt/X7Tm6+/L183J8+JRnlpdnMkz2/Xy+9P+9nb1trtX3nD9ttpuVy/7fz0t5g8L2f364kx+2Pdxtdru/3Eux/i1Wv+5O87X/wJQSwECFAAUAAAACAAQc5tckO8c1poBAABtBwAAEwAAAAAAAAAAACAAtoEAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQIUABQAAAAIABBzm1y1VTAj7gAAAEwCAAALAAAAAAAAAAAAIAC2gcsBAABfcmVscy8ucmVsc1BLAQIUABQAAAAIABBzm1yry29kqQEAAG0DAAAQAAAAAAAAAAAAIAC2geICAABkb2NQcm9wcy9hcHAueG1sUEsBAhQAFAAAAAgAEHObXGrk7OU3AQAAUQIAABEAAAAAAAAAAAAgALaBuQQAAGRvY1Byb3BzL2NvcmUueG1sUEsBAhQAFAAAAAgAEHObXE1B1tIaAQAAewQAABoAAAAAAAAAAAAgALaBHwYAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzUEsBAhQAFAAAAAgAEHObXOIrf3u7AAAAMwEAADIAAAAAAAAAAAAgALaBcQcAAHhsL3Bpdm90Q2FjaGUvX3JlbHMvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbC5yZWxzUEsBAhQAFAAAAAgAEHObXBcOzIYnBgAA/xgAACcAAAAAAAAAAAAgALaBfAgAAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbFBLAQIUABQAAAAIABBzm1xRHdiU7AoAABicAgAkAAAAAAAAAAAAIAC2gegOAAB4bC9waXZvdENhY2hlL3Bpdm90Q2FjaGVSZWNvcmRzMS54bWxQSwECFAAUAAAACAAQc5tcCkEM6r0AAABHAQAAKQAAAAAAAAAAACAAtoEWGgAAeGwvcGl2b3RUYWJsZXMvX3JlbHMvcGl2b3RUYWJsZTEueG1sLnJlbHNQSwECFAAUAAAACAAQc5tcX/fPqW4GAACDNAAAHgAAAAAAAAAAACAAtoEaGwAAeGwvcGl2b3RUYWJsZXMvcGl2b3RUYWJsZTEueG1sUEsBAhQAFAAAAAgAEHObXNOjSNVxAwAAwAkAAA0AAAAAAAAAAAAgALaBxCEAAHhsL3N0eWxlcy54bWxQSwECFAAUAAAACAAQc5tcvaC/vRwHAAAdIgAAEwAAAAAAAAAAACAAtoFgJQAAeGwvdGhlbWUvdGhlbWUxLnhtbFBLAQIUABQAAAAIABBzm1xfVWg93AIAAHIGAAAPAAAAAAAAAAAAIAC2ga0sAAB4bC93b3JrYm9vay54bWxQSwECFAAUAAAACAAQc5tcyKG4+rgAAAA0AQAAIwAAAAAAAAAAACAAtoG2LwAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDIueG1sLnJlbHNQSwECFAAUAAAACAAQc5tcnm1ymZ8DAAB2DAAAGAAAAAAAAAAAACAAtoGvMAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sUEsBAhQAFAAAAAgAEHObXNsgZU0xEgAAW44AABgAAAAAAAAAAAAgALaBhDQAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbFBLBQYAAAAAEAAQAH8EAADrRgAAAAA= xl/worksheets/sheet1.xml xl/worksheets/sheet3.xml 1 0 Sum of Bucket Quantity 1 Bucket Date 2 Plan 3 Organization Code 4 Item 5 Item Description 6 Item Type 7 UOM 8 Category 9 Preprocessing Lead Time 10 Full Lead Time 11 Postprocessing Lead Time 12 Cumulative Total Lead Time 13 Cumulative Mfg Lead Time 14 Primary Supplier 15 Buyer 16 Make Or Buy 17 WIP Supply Type 18 Planner Code 19 Planner Description 20 Planning Method 21 Forecast Control 22 Pegging 23 Planning Time Fence 24 End Assemblies 25 Source Type 26 Source Type Text 27 MRP-M1-PRD 28 M1 29 CM18759 30 Keyboard - 101 Key 31 Purchased item 32 Each 33 PERIPHERAL.KEYBOARD 34 (blank) 35 Advantage Corp 36 Smith, Mr. Jonathan 37 Buy 38 Operation Pull 39 J. Smith 40 Vice President, Materials 41 MRP planning 42 Consume and Derive Forecast 43 End Assembly/ Soft Pegging 44 User-defined time fence 45 AS18947, AS54888, AS54999 46 Sales orders 47 Forecast 48 Dependent demand 49 Payback Demand 50 Gross requirements 51 Work orders 52 Purchase orders 53 Requisitions 54 In Transit 55 In Receiving 56 Planned orders 57 Payback Supply 58 Total supply 59 Beginning on hand 60 Projected available balance 61 Current scheduled receipts 62 Projected on hand data A1 1 data AA1 1 data B1 1 data C1 1 data D1 1 data E1 1 data F1 1 data G1 1 data H1 1 data I1 1 data J1 1 data K1 1 data L1 1 data M1 1 data N1 1 data O1 1 data P1 1 data Q1 1 data R1 1 data S1 1 data T1 1 data U1 1 data V1 1 data W1 1 data X1 1 data Y1 1 data Z 2 data Z1 1 parameter A1 1 parameter A10 1 parameter A11 1 parameter A12 1 parameter A13 1 parameter A14 1 parameter A15 1 parameter A16 1 parameter A2 1 parameter A3 1 parameter A4 1 parameter A5 1 parameter A6 1 parameter A7 1 parameter A8 1 parameter B1 4 parameter B10 4 parameter B11 4 parameter B12 4 parameter B13 4 parameter B14 4 parameter B15 4 parameter B16 4 parameter B2 4 parameter B3 3 parameter B4 4 parameter B5 4 parameter B6 4 parameter B7 4 parameter B8 4 S Site HP by End Assemblies, Components Includes separate columns for End Assembly. The Horizontal Plan for each component will be repeated for each end assembly is used in. SYSADMIN 6 BOM_LEVEL 30 BOM_SORT_ORDER 4 31 BUCKET_DATE 7 32 BUCKET_QUANTITY 18 BUYER 11 CATEGORY 16 CUMULATIVE_MFG_LEAD_TIME 15 CUMULATIVE_TOTAL_LEAD_TIME 27 END_ASSEMBLIES 3 END_ASSEMBLY 3 4 END_ASSEMBLY_DESCRIPTION 24 FORECAST_CONTROL 13 FULL_LEAD_TIME 7 ITEM 5 8 ITEM_DESCRIPTION 9 ITEM_TYPE 19 MAKE_OR_BUY 5 MRP_END_ASSEMBLY 2 ORGANIZATION_CODE 2 25 PEGGING 1 PLAN 1 21 PLANNER_CODE 22 PLANNER_DESCRIPTION 23 PLANNING_METHOD 26 PLANNING_TIME_FENCE 14 POSTPROCESSING_LEAD_TIME 12 PREPROCESSING_LEAD_TIME 17 PRIMARY_SUPPLIER 29 SOURCE_TYPE 6 28 SOURCE_TYPE_TEXT 10 UOM 20 WIP_SUPPLY_TYPE BOM_SORT_ORDER ROW 5 BUCKET_DATE COLUMN 1 BUCKET_QUANTITY VALUE 1 SUM BUYER ROW 11 CUMULATIVE_MFG_LEAD_TIME ROW 9 CUMULATIVE_TOTAL_LEAD_TIME ROW 8 END_ASSEMBLIES ROW 20 END_ASSEMBLY ROW 3 END_ASSEMBLY_DESCRIPTION ROW 4 FORECAST_CONTROL ROW 17 ITEM ROW 6 MAKE_OR_BUY ROW 12 ORGANIZATION_CODE ROW 2 PEGGING ROW 18 PLAN ROW 1 PLANNER_CODE ROW 14 PLANNER_DESCRIPTION ROW 15 PLANNING_METHOD ROW 16 PLANNING_TIME_FENCE ROW 19 POSTPROCESSING_LEAD_TIME ROW 7 PRIMARY_SUPPLIER ROW 10 SOURCE_TYPE ROW 21 SOURCE_TYPE_TEXT ROW 22 WIP_SUPPLY_TYPE ROW 13 MRP Horizontal Plan - HP by End Assemblies, Components 25-Mar-2025.xlsx US UEsDBBQAAAAIABBzm1yQ7xzWmgEAAG0HAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbM2V30/CMBDH3038H5a+mq2AiTGGwQPqoxLFP6CsB2vY2qZXEP57bx34g0yQgNGXtVt79/20d7vr9pdlES3AoTI6Ze2kxSLQmZFKT1P2MrqPr1mEXmgpCqMhZStA1u+dn3VHKwsYkbXGlOXe2xvOMcuhFJgYC5pWJsaVwtOrm3IrspmYAu+0Wlc8M9qD9rGvfLBe9xYmYl746G5Jn2sSBwWyaFBvrLRSJqwtVCY8rfOFllsq8VohIcuwB3Nl8YIwGG9UqFa+F1jbPdLVOCUhGgrnH0RJGHxZ8FfjZmNjZsluJw2UZjJRGUiTzUs6WILWgZCYA/iySMKYlELpDfcO/bAZeRjaJwapzhccH8jR+Sccl3/EYdXC+IGg34B/TCm7lVZVSp46TE0aeyLWSPgEmXESfw9vLbCHzVP1AB6ex6MEN3sE0a8KwBPnSu10n3IuHMhn76jOnhzgs++fpMNIjIm4ztgwP/72v9a1D8+7cKgoDp2xSO3BweFB2dT/yjq25AicV7sD8a5IreVwwa1SDlXzkiAbtHlolr03UEsDBBQAAAAIABBzm1y1VTAj7gAAAEwCAAALAAAAX3JlbHMvLnJlbHONks9OwzAMxu9IvEPk++puSAihpbtMSLshVB7AJO4ftY2jJED39oQDgkpj29H2588/W97u5mlUHxxiL07DuihBsTNie9dqeK2fVg+gYiJnaRTHGo4cYVfd3mxfeKSUm2LX+6iyi4saupT8I2I0HU8UC/HscqWRMFHKYWjRkxmoZdyU5T2Gvx5QLTzVwWoIB3sHqj76PPmytzRNb3gv5n1il06MQJ4TO8t25UNmC6nP26iaQstJgxXznNMRyfsiYwOeJtpcT/T/tjhxIkuJ0Ejg8zzfinNA6+uBLp9oqfi9zjzip4ThTWT4YcHFD1RfUEsDBBQAAAAIABBzm1whqNavsAEAAHYDAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJ2TTW/bMAyG7wP2HwSdl9hthmIIZBVF2iGHFTMWtzsrMh0LlSVDZI2kv36yjSRO29Nu/NKrhyIlbveNZR0ENN5l/GqecgZO+9K4Xcafip+zH5whKVcq6x1k/ADIb+XXLyIPvoVABpBFCYcZr4naZZKgrqFROI9pFzOVD42i6IZd4qvKaLj3+rUBR8l1mt4ksCdwJZSz9iTIR8VlR/8rWnrd8+FzcWgjsBSFJ2UL04BMRXJ2xF3bWqMVxe7lo9HBo6+IPew1WJFMkyJSb0C/BkOHXmPqio1WFlbxQlkpiyCSc0CsQfWPmSsTUIqOlh1o8oGheYvPec3ZViH0mBnvVDDKUcTty0ZnsG2LFORfH16wBiAUySk4mNPaqW2+y8VQEI3LwuHUABITl4iFIQv4u8pVoE+IF1PiAWzkHRkf/+Rs7YN58y4+OMutclPYU11uOk+zdc62B/bgSnaHCM3Wxm36xla++fyMCqoBirv6of9jJ+/Yfxn3gk9t4e8VwXE2l0GxqVWAMo7zNLtTQKzjWILtRVa1cjsojzUfE/0mPY/fSF7dzNNFGpdkEhPJ+cPIf1BLAwQUAAAACAAQc5tcDMR01TMBAABRAgAAEQAAAGRvY1Byb3BzL2NvcmUueG1sjZLNasMwEITvhb6D0d2W7eBQhO1AW3JqoNCUlt6EtElErR8ktY7fvrKdOA7kUNBld2Y/jRaVq6Nsol+wTmhVoSxJUQSKaS7UvkLv23X8gCLnqeK00Qoq1IFDq/r+rmSGMG3h1WoD1gtwUSApR5ip0MF7QzB27ACSuiQ4VBB32krqQ2n32FD2TfeA8zRdYgmecuop7oGxmYjohORsQpof2wwAzjA0IEF5h7MkwxevByvdzYFBmTml8J0JbzrFnbM5G8XJfXRiMrZtm7SLIUbIn+HPzcvb8NRYqH5XDFBdckaYBeq1rcuQ9lKExTXU+U3Y8U4Af+yCfqPH2RB3nAMehQBkjHtWPhZPz9s1qvM0L+J0EefFNs1Jf5Zf/ZVX832gsSFPF/+fWJBiTjwDxtzXn6D+A1BLAwQUAAAACAAQc5tcTUHW0hoBAAB7BAAAGgAAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzvZTBSsQwEIbvgu8Q5m7TdnUV2XQPLsJedX2A0E7bsG0SMnG1b2+s0FpY6h6Kl8DMJP//Mcxks/1sG3ZCR8poAUkUA0Odm0LpSsDb4fnmARh5qQvZGI0COiTYZtdXmxdspA+PqFaWWFDRJKD23j5yTnmNraTIWNShUhrXSh9CV3Er86OskKdxvObutwZkE022LwS4fbECduhscP5b25SlynFn8vcWtT9jwT+MO1KN6IOodBV6AUOKeF9ZRYEY+HmY+yVhqJYOi1fvQq9pBJqk52DSJWEu6Ew6B5P8M0wyB7NeEoZ814ShHwbmJ56zv1vS3odVwtG9D3l/zrbgdkkGq07GP8mw1TsslVbfez8ijVV+7uKAySdfRvYFUEsDBBQAAAAIABBzm1ziK397uwAAADMBAAAyAAAAeGwvcGl2b3RDYWNoZS9fcmVscy9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1sLnJlbHOFj8FqwzAQRO+F/oPYey07h1CK5RwSArkG5wMWaW2L2FqhVUL899ExoYUeh2HezLS7xzKrOyXxHAw0VQ2KgmXnw2jg0h+/vkFJxuBw5kAGVhLYdZ8f7ZlmzCUkk4+iCiWIgSnn+KO12IkWlIojheIMnBbMRaZRR7RXHElv6nqr0ysDujemOjkD6eQaUP0aS/P/bB4Gb+nA9rZQyH9U6OjvnPdY5p3JcnJS4JhGygZ+WU1VpoPuWv12tXsCUEsDBBQAAAAIABBzm1zaSUmbZQcAAPUjAAAnAAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1szVpdc+I4Fn3fqv0PKj+Pg21MgFSSqZCE3cw2HSbQPc+OrQRtbIuV7SzM1vz3PZIMccBtgVPd1VQKiHR1P4+uri4+/3WVxOSViozx9MJyTxyL0DTkEUufL6wv87E9sEiWB2kUxDylF9aaZtavl3//2/mSvfL8OggX9IY+sZTlYEDALM0urEWeL886nQyTSZCd8CVNMfPERRLk+Fc8d7KloEGULSjNk7jjOc5pJwlYamkOZ+IQHvzpiYX0hodFQtNcMxE0DqQm2YItsw23JDyEXRKIl2JphzxZgsUji1m+VkwtkoRnd88pF8FjDBesxIbxal/PhIWCZ/wpPwGjjlZxz1rXh6KvTPrcIuKMRReWuItcfKdPgmaL+/QTDzD4NkKj0frCuiryBYf0koxGN0EOhfxe33dPTr2B73SH3Z47GFokhH9zGn3dRBZWbFdtBxHbhKUPWqg0bjvTleQhF9E1L9JcabISZ4XU9H9O+bLxeSXfHHuMl3o7hcPk6y/r8jyU4JjxQoSU5OslFP0vFy8q5pjdfi8poB0MdM+uxh4QJ4kurMnDlPyTC/YnT/MgJtM4SK3O5XmnwrkUM2Y0jjISam273ka8GidpkEC6Wk7SIhkn+R0McUAEswWN7nKabBfLtRl5vbA+X0lh6isUsSeuPX24sUghvSG1qKzd6KTEVVUqRd+L5yBlfypokmse0bZ6IA5t5N+mEbnKMpo8xuuWoq9mwJXf/7h8ckOzULCl9EVLXWbY7yylMVjFxYpKji85X7bTbSKW5HD/AIgszT7zVG89pMtQghNjs1yopFkZGgFxLxu4KNB+CyAjnpBP9JXGzR5pJ32zLVwgOzkSuXJrtIzShxAj5f5sSFE6zZHJWjpkjGMSmS0iz5xH7cD65X5ygHAZaJW3boG5Y3PVNYD9zEXbPHF9P5l+md8+nNzczv41v5+2s3Mq6FLwkGYZ9hR2RhCROUsMjv/xu2NcxPF31640q0geKeoNnACbjHOXIlLlGM7xr0FcICWBIAlWb/+UZ6I81uTmTyUuWh4jU57lbcMyowmbsBWN5AZCjdicOT8fai3YvFmreJb1SmmpczT8i6SQNeQrJXMuq47vDb698L6FsnfiDlxZpG3juRmpC+pmrk2BcP1m9eTp+2+4nwjSgqHwX5NZsVzGjKK4bioQf3yGGRVrk1IK8HVV6yxh+eIXMhEn5DeeBvlC1r9t0DEJXii5FwTKHHP6yGXHbr8/7qY6FuuPnLT3Syp0sT1Fhm5ntLwupFR8pFz/7YSoGHxMgY/Xy19xCSU4UjMWoXIGInDECxbEuCG3gYPyjDyXJxT3UVQyxjvVtiCZTGdkWS4/FhpjjitpkOWISJoLbiiVt8eAKoSwJEObgKCRgapSyOy+YXesGlP6/Azjj7G6er3okBm6A2TD5chyfOt6WQ2RMVo1hxSjW/d/yaiwI9mvQRWaSxZPisWRWlTsYegH/WQps2woyDqDzOkqPyRSg5pL/yyIaUbQA0EP5W2jKDhtsbPdP2r4hqLTJbcYidD4Sis1vpqeBuvHIHwBAGsm/4G2UYamy38KJqhsaO3K/APNk3ptpmixLIKM1s8+SJaZ6s/tsrxLyVwEKSZ37MPEAw0pe1VA3+QIbYRKi9E3NCkt1Bl8Z6Uup7K6qRHFllIpBSkbx9Se5wT/Nw3RzyLBa8Bi2aoijwE0kfB/p951IYQMgOw9RkWMFUgaFN2GXdunW5Z7Io/p7FTAdsg++BFVsNur1MES2KrkV4WwLv4xvfGZGvB2B7q7A35vZ0l/l2JQuVIopgO0EN9JGezyGFSaSXoJ+pbvlgx3pQx3ebjOLonr7NHsGez6e6ukz9qchbJxM+MiR3mEPHEIBI7tHX2kezMqwheaE9mrqqrm9vZan2UP69uXtDq1dQ+sciOt9MBwiymnB8Oh7Xp21507zpn6UzcaPes5Xs92XdvrVWbL202/CzUjBdkaHoCzmlMcnK7t+RUOm1C+o3inQQ2Fbzv9Zh6+7Rqk+LZXtbNWijdolgJzqt6o4QGXeSYe7tBE4Z02U5zajkEKKAxSTm3XKMXrmvToOs0UfWPk+sbI9Y2RA4UhcgPbMeBjALA32wIKo5R3u6UGH0PbMUgBhUEKNq0BhUPbM+ADFM34cB3bacYHKNxmfIDCa8aHpGje2chAjkGKa7sGKaAwSmnMUp7MY41e1xRNHtMUTXpoiqboa4qmyCmKRq9riiYUaoomBGmKprhoiqY9pymakKwpjD5tRJDmYfRp425QPBoznaYw+BSnmJnC4HXwMHgdFAavg8LgdVAYvG44keEPUBi8DgoDknGqN+1sJaUxa2sKo08b85jmYfSpKTuAh9GnpuwAHkaf1maHYy5OZWn6exHgt9zc0Fc0Vqc1P762/Qlh+4BB+VutftpAP2BweY5+wqcsV5+kEAyPQ/S93tWtd3VrD/2ha/uDR2qPvJFv+7ejYd8fX3edgf/X9okR1997FuWgR0acYWeoH5G5PF+5/lnd4zdSc+il35WWnTqyy/8DUEsDBBQAAAAIABBzm1yGK2tpAAEAAN8CAAAkAAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlUmVjb3JkczEueG1s1dLBasMwDAbg+2DvYHRvnY4xRkjSw8Zg17E9gOsoiaktGdsJ6dvPW+guOTTX3WwkPqQfVcfZWTFhiIaphsO+AIGkuTXU1/D1+bZ7BhGTolZZJqzhghGOzf1d5c3E6UXpAT9Qc2ijyBLFGoaUfCllzBWn4p49Uq50HJxK+Rt6GX1A1cYBMTkrH4riSTplCBahDFsM7jqj8ZX16JDSggS0KuU94mB8vGpOb+GcCufR7zQ7n4mTsSZdflEQTpfvPXFQJ5v3n8MVntdzOqMDR+7SPkNyGXG17eExDzqZn8BBaB4p5dyhqUJTzWKqoQB56+VudmyV/ncf/eUlc3pydZLNN1BLAwQUAAAACAAQc5tcCkEM6r0AAABHAQAAKQAAAHhsL3Bpdm90VGFibGVzL19yZWxzL3Bpdm90VGFibGUxLnhtbC5yZWxzhY/BCsIwDIbvgu9QcrfdPIjIOg+K4FX0AUKXbcUtLW0VfXvrbQPBY8if789X7V/jIJ4UonWsoZQFCGLjGsudhtv1tNqCiAm5wcExaXhThH29XFQXGjDlo9hbH0WmcNTQp+R3SkXT04hROk+cN60LI6Y8hk55NHfsSK2LYqPClAH1jCnOjYZwbkoQ17fPzf/Zrm2toaMzj5E4/ahQ3j5dOmB+70itZfsVyHwMHSUNUk4CP7OlzDqg6krN9OsPUEsDBBQAAAAIABBzm1whhLNFbgYAAC08AAAeAAAAeGwvcGl2b3RUYWJsZXMvcGl2b3RUYWJsZTEueG1s7Vttb9s2EP4+YP9B0HfV1qvtwHbh2vEaoNu6Jus+MxIdE5VEQaISB8P++46kLVnypUm3tChSFqhjnqjjPceHJ9rmM329y1LrlpYV4/nMdl8NbYvmMU9YfjOz/7xaO2PbqgTJE5LynM7se1rZr+c//zQt2C0XV+Q6pSu6YTkT4MACZ3k1s7dCFGeDQRVvaUaqV7ygOVzZ8DIjAprlzaAqSkqSakupyNKBNxxGg4yw3NYezrL4KU4yUn6qCyfmWUEEu2YpE/fKl21l8dnFTc5LGd/M3pUHx7vyxHHG4pJXfCNegaMB32xYTE/ic4NBSW+ZzBK4Ks9qlszsv4f7fw78HcmXoTN05cvRv39sKycZBPG+SZhrWzGB3FyAj2g8sS1SFOn9b3V2Tcu1TtLMholQ5je8TBDzmufipO97IgQt8xP7ImU3eUaRO/5iidi+pexm23qD8BIiyJIUck5n9keS1jDrVl2AmSYfD2QBZmQs/0A3Ja22MtHNFR86V3RRC65DEYpN4Lfkd7+UQKYrLkiqQcY87ZuYoNn7kuXiiomUQjeZMODL8eAwxyxPANLeCVAg7rxfAQR1LatTwYqUrhlNkzVLIUNq5Pk05THwBmhb0s3MXrhnixVEvmFlJd4CO2n5gd+pwZVJOlQG78iw5CkYJvZgrheEGqQCULWMzPdglNZukR2DoeUrOJLQ26h5LVImFxhEXG353SIFx/I9L8XVfQEXSBXTXK5LmB66IYDqsr4WMpEajcxaM7IcWBqsTAHYyVeIUZmgMZSNgbpjPqU78a4S6q9Vlwx47U2C6Hw1jpyFOwqdwPeIM14sXScKzofLMIhWo9U58Fqv1Z0b/Lc1NZwMJnrVz6fg5OwoURuWpit+l78j11TyRAU/gAD1qwp30PY3SX6wcJkkGyZ/Qbk41AakdrzQcvFgEd4X1ytenBRlNKGmjD7OM/fwWDLPIPOgh50S7Ky+6YP+cYaajdOX7E5NPp93I/p4Pk0FtR76qPR48szift7FbchoyPh9f0Q3DH2QoeabJfPN0g/99Z2pDV+tNvx4XyN9u6/2DW0Nbc2PJeYXqc/+7GcK8Nf7bdUU4OcuwCajJqPf+4/9hqOGo989R8enx36C5txPexQoOrX5pybv1BQiztRZou55AXUeqnPWqHsdiwkZzW3PLLWxYyGMTkNATGMkeMSEZELl64Wef/iGH1wbdn5md9olCkIKZHoQOiEsQUj/NJK0bG5ZiJAeZSvGagSBi60IjOkICFehMOz8nycmf7znO5xd7Z5BzetsnQl5KtkN7ed+2o/8/tmf7lL3kcXoIyXbR5ZjgCzHAHl4BMhyDLCCgizHAFmOAbIcAwRHgOAIEBwhgiNEcITYoxnBEWKVEcERIjhCBEeI4AgRHBGCI0JwRAiOCHv+IjgirMQjOCIER4TgiBAcIwTHCMExwsr8kzZU5mnWP6aOTJeL7dyQ6fKQ6fKQ6fKQ6fKwDTBCOw+hnYfQzkNweAgOrR3olUIEh4/gAHnB6b0IDh/B4SM4/Je8z5WSFqXO0HKSJ3w9+GJP+R4pJ0D+AZqcrmoFKDmfbmSqGqlI01IsbFqKf01LMa+9pojdNBXdmpYiWtNSS6VpqUXStLpeXLUy2mi64bjdeNxuQHqP3d7bjcjthqQ31W3nblBuNypdd1rkvSR1o9KFpu3cjUqXl/ZqNypdQNqreuffTKCay4tjGZDa1IK6xrrda2jQd+Bkd/j/eM+2h7znoVbXjo9wbO2/l/fvP9hoiArXfApysS5bJcSWglrY1HRS/dGMqI9Muuvec1MgGhGVdN1Y9yq+yzqz+MZ6U8efqLD+qEkuQHUIijBZWKBIW9ek0lIz0IWBSE025QCQ/wCUgO0OW+9fBu2oexGTklReivuUXuQbfqwdVMZfacLqDDSDUiQGKjItVNMaOWmCTX3fBL0uRckKqaTbq8ugV9/0jlQCzHUmZaAytFM9wyTyztfhynXC5cJzgnjiO+PzdeCs3qzD5TAM/MnK+0qysL7QtHtuHBSoUg+nkrBlCdWKxYN6by9Tgyno6VJR5SfdxfRYkSonSQnPWnncKBgtIjcKHHccLpxguFqCPG4ROuuhG7pe6A5XYdDmoUjgl7qnjNzXxLqRLtT751BK7uHkq9TKgUctlutlxY2s81zSJzkoA6smMzDxjfH3HEQtR1caiD1tXc/9/F9QSwMEFAAAAAgAEHObXBi87YFsAwAAZgkAAA0AAAB4bC9zdHlsZXMueG1stVbbjts2EH0v0H8guK/V6rKWazuWg/giIEAaFN0tUKAOCkqibCK8CBS1kVr03zukZFtubttF+mKRQ86ZM5zDoZcvW8HRI9U1UzLB4W2AEZW5Kpg8JPjXh9SbYVQbIgvClaQJ7miNX66+/25Zm47T+yOlBgGErBN8NKZa+H6dH6kg9a2qqISVUmlBDEz1wa8rTUlRWyfB/SgIpr4gTOIeYSHyp4AIot83lZcrURHDMsaZ6RwWRiJfvD5IpUnGgWobTkiO2nCqI9TqUxBn/SiOYLlWtSrNLeD6qixZTj+mO/fnPskvSID8PKQw9oPoKvdWPxNp4mv6yGz58GopG5EKU6NcNdIkODqbUL/yuoAaTycY9VXZqALOqdh7Qoi913V7dDwuhFjUNfZPYFee8bXnzQ83N8Ef6MXvv9Di3d5z0z2yvv7AZLUslRwTgnrA+S/eS/VBpnYJCAFLu2u1rP9Ej4SDJbAYueJKIwNqApKhY0QE7XdsCGeZZtZYEsF415sja3ACHPYJBnJwhPoI/W9md/3vsVzIGmIyzs8lubPJgmG1BPUaqmUKEzSMH7oKUpVw0XrKbt9Xdh806cIofrpDrTgrLIvDxh2wPmQJTtPdq12aOphsWGCyoC0FxYBgLJ0R4TM5xxFyzJQuoImchGdL2ptWS05LA+6aHY72a1RlYyhj4KKtlgUjByUJtwFOHsMAYHPK+b1tNL+VV9htOZIltCx70lbbdgiEhmGP108s/hitxx7BToHyf4dFbXnG/5x3eCEVYTQmdfZGpKp4Z++DVfowg0QG3V8hh+4Sfi3ff0G/bURGdepu/SdB+6bwjVGfVJkL04o9KrNuQBn2KbIlu058+o0yd0KA0o/0daWus06QbTgJfmuPjUPbH2qNsoZxw+QnlAWYRXvRqtOdsc+RU/E5ChxMQUvScPNwXkzwZfwTLVgjQC3Drp/tyTiIBF/G/a65jUFb86aGzgZf1GiW4L926x/n210aebNgPfMmdzT25vF668WTzXq7TedBFGz+Hj2Kz3t+AvskujccihVOFjWHh1MPyQ7k7y+2BI8mb2xHcGX2gfaY+zyaBq/iMPDSuyD0JlMy82bTu9hL4zDaTifrXZzGI+7x87iHgR+GF/LxwjBBOZOnWp0qNLZCkWD6hSRsKq4S/uUP0uofUEsDBBQAAAAIABBzm1zCh9vyUQYAANcbAAATAAAAeGwvdGhlbWUvdGhlbWUxLnhtbO1ZT2/bNhS/D9h3IHRvYye2Ewd1itixm61NGyRuhx5pmZbYUKJA0kl9G9rjgAHDumGXAbvtMGwr0AK7dJ8mW4etA/oV9khKthgzjdOm2L/mEIvUj+//e3ykrly9nzB0SISkPG0F1cuVAJE05EOaRq3gdr93aS1AUuF0iBlPSSuYEBlc3Xj/vSt4XcUkIQjWp3Idt4JYqWx9aUmGMI3lZZ6RFN6NuEiwgqGIloYCHwHdhC0tVyqNpQTTNEApToDsrdGIhgT1DUl4u4ouwU+1EmwUjLoMXqVK6omQiX3NhrirT64bHlQ1Wk5khwl0iFkrAP5DftQn91WAGJYKXrSCivkLljauLOH1fBFTp6wtreuZv3xdvmB4sGx4imgwZVrt1ZqrW1P6BsDUPK7b7Xa61Sk9A8BhCFpbWco0a721arugWQLZx3nanUq9UnPxJforc/Sb7Xa73sxlsUQNyD7W5vBrlUZtc9nBG5DF1+flb292Og0Hb0AW35jD91abjZqLN6CY0fRgDq39OfXMFDLibNsLXwP4WhEAMxREwzTSNIsRT9UicZfge1z0AGwcjRVNkZpkZIRDiPQOTgaCYq05Xie49MZOhXJuSvNFMhQ0U63gwwxD1szovXz2/ctnT9DLZ4+PHzw9fvDT8cOHxw9+tLSchds4jcoLX3z72Z9ff4z+ePLNi0df+PGyjP/1h09++flzPxCyaSbR8y8f//b08fOvPv39u0ce+KbAgzK8TxMi0U1yhPZ4Arp5JCcDcb4V/RhTZwWOgbaHdFfFDvDmBDMfrk1c490RUEh8wGvje46s+7EYK+rhfD1OHOAO56zNhdcA1zWvkoX74zTyMxfjMm4P40Mf7w5OHdd2xxlU0yIonajpxMQRc5fhVOGIpEQh/Y4fEOLR7i6ljl13aCi45COF7lLUxtRrkj4dOIE0W7RNE/DLxKczuNqxzc4d1ObMp/UWOXSRkBCYeYTvE+aY8RoeK5z4SPZxwsoGv4FV7BNyfyLCMq4rFXg6Ioyj7pBI6VtzS4C+Jadfx1C7vG7fYZPERQpFD3w0b2DOy8gtftCJcZJ5ZaZpXMZ+IA8gRDHa5coH3+Fuhugx+AGnp7r7DiWOu88uBLdp5Ig0CxD9Ziw8vrxGuJuPEzbCxFQZKO9OpU5o+qqyzSjU7Xdlu9jHNmET8yXP9olifRruX1iit/A43SWQFfNb1LsK/a5CB//5Cn1aLl98XZ6VYqjSs77bNLXJQk34iDK2ryaM3JCmD5ewGQ17MGkG5vQ4PaBlMTzmW4KDiwQ2a5Dg6iOq4v0YZ9DDV82xNJI56UiijEs4R5ppL21zjKXQxptTaL04bwIaqx0+tNMr5XPolIzZqCJz7i0YrWgCizJbWc0Pt6/JrGqlWlC1qhHNFEhHtanKoMy8akbD3JrQ5SDojcDKDTjQa2pw9sGMDLXd7bZduMXY5CJdJGM8JLmPtN7zilSNk4pYKcLI4yN9pjzDaiVuTU32Dbgt4qQyu9op7ArvvYmXCuvMvKRz+EQ6srScnCxFR62gWV+uByjEWSsYwbEZHpMMvC51Y4lZBPdToRI2EM9MZoOaebPpD8sq3Iqc4k2HRSak2sIytqFhXhXXNKk55Bv5l+tg1otSwEb6a0ixsgbB8LdJATK7riWjEQlV2dmlGXMHYgB58vOxImI/Hh6hARuLPQzu16EK+gyphNsPUxH0AK7ttLXNyC3OedKVL8sMzs5jlsU4L7c6RYtMtnBj86kMZlQSbzoy2sxkPzFcVBWT8hekSjmM/2eq6P0EriNWhub2DG6TBUY6X1sBFyrmUIWymIY9AZdoJgIgWuDqF16D8eFO2/wKcqh/bc5ZGiat4VSp9miEBIX9SMWCkF0oSyb6ziBWzfcuS7IgZHN6Jq7MrNgDckhYX9eQht7bAxQX1SQvAwZ3Mv7ccR52g0g3LP/Uzscm83nbg1nnY9cv2IvUSkW/tBU030yEc261tmLNabxcX3irzeBSCel/sP9RETJi9Ncbap/vQelE044SQVRfso0H0gXSPg2gcbKTNpg0qbfbRs063Snft9h8lrb5aXPmsnNy8dXd5/mMnVvYsXW50/WYGhxwMkV1e1QcaoxjzJe18gcvPrgHjt6CTwhjpqT9dHAfrhBhy7IfJCD5rXPN0o2/AFBLAwQUAAAACAAQc5tc45M5Uu0CAACLBgAADwAAAHhsL3dvcmtib29rLnhtbKVVXW/aMBR9n7T/4FlIe1kIcSFARKg6PlSkdkJr1z5WJjHEqhNHtoGwqv991wmhMPZQdRE42Nc+95zjazO4LFKBNkxpLrMQe80WRiyLZMyzVYh/3U+dHkba0CymQmYsxDum8eXw86fBVqrnhZTPCAAyHeLEmDxwXR0lLKW6KXOWQWQpVUoNdNXK1bliNNYJYyYVLmm1fDelPMMVQqDegyGXSx6xsYzWKctMBaKYoAbo64TnukZLo/fApVQ9r3MnkmkOEAsuuNmVoBilUTBbZVLRhQDZhddBhYKPD1+vBQ2pM0HoLFXKIyW1XJomQLsV6TP9Xsv1vBMLinMP3ofUBhM23O7hgZXyP8jKGlphgQvV1ljJ/43mQWnVcOSDaJ0DN4KHgyUX7KEqXUTz/AdN7U4JjATVZhJzw+IQd6Ert+xkQK3z72suIEp6HeJjd3go57lCAGuYmiu+odEOzgRGCY/ZnG+kmXIm4huuTTkcsyVdC3MPFV/zgHHSJhVkoYLayblRCH7PxjfA7I5ugCe4Ee/LeAZEek8vXdLpXEwmfWfsE89p9/q+0x+TrjMeTUYjr9MbkU73FTxUfhBJujbJXrvFDHEbhJ6FbmlRR7xWsObxW/6X1v5x7Puvpo69Wh32lD9wttVvLtkuKh55FsttiB2PgJrdaXdbBh95bJIQX/T8Nkypxq4ZXyXAmIBVMEgjwzfsni5KT+FgWZ4hPuE3rvhN4SmbE37uEcHydgGi5RtlZUXc/pyja6n4b5kZKtBcUDgl5QRrPORUgU2oZrFn5R4vLTfduZ6jxQ5Nshhdac3SheBMf0MjmR7BwHVwgCFnMFQBEygquJ4OiS+OVlzYFW5NHuqKZyy29QxSjnp7QU+FyNLm07Ss0zE1dEE1s2UeUXFX6wJnoWxjZm91PPz6DxO+fmlcNbygcTVteAP3KA1QOaUAuBEcDPsqLSOEeKVXufVnROHOB6JvHZgJQ3aq3+sfyWyXMk8WufX/yPAPUEsDBBQAAAAIABBzm1zIobj6uAAAADQBAAAjAAAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDIueG1sLnJlbHOFj8EKwjAQRO+C/xD2btJ6EJGmvYjgVeoHrOm2DbZJyEbRvzfHCoK32R32zU7VvOZJPCmy9U5DKQsQ5IzvrBs0XNvTZg+CE7oOJ+9Iw5sYmnq9qi40YcpHPNrAIlMcaxhTCgel2Iw0I0sfyGWn93HGlMc4qIDmjgOpbVHsVFwyoP5iinOnIZ67EkT7Djn5P9v3vTV09OYxk0s/IlSwT59avE2UqRgHShqkXKx5oUuZfwdVV+qra/0BUEsDBBQAAAAIABBzm1xMOk1c0wMAAA0OAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1snZdbb6M4FMffV5rvgPwwbwVsILdJMhq1ijrSjlRN9/LsgEmsAmZsp7fRfvc9NhioOruKU6X4gOHn43P+Nof15+e6Ch6ZVFw0G4TDGAWsyUXBm8MG/fnH7mqBAqVpU9BKNGyDXphCn7cffls/CfmgjozpAAiN2qCj1u0qilR+ZDVVoWhZAz2lkDXVcCoPkWolo4V9qK4iEsezqKa8QR1hJc9hiLLkObsR+almje4gklVUg//qyFvlaHV+Dq6m8uHUXuWibgGx5xXXLxaKgjpffT00QtJ9BfN+xinNg2cJPwL/iRvGXn83Us1zKZQodQjkqPP5/fSX0TKi+UB6P/+zMDiFADxyk8ARRS5zCWcDi4yw5EKYyUznmAmXXJ14sUE/4/7vClpsDvF4cH3/oO264JBh83AgWblBX/Dqy46gaLu2AvqLsyc1sQOjx70QD6bjK4wTA6KlDQte7lvIKmgbBVq0v7NSX7OqAiDMkOaaP7I7uG2D9kJrUZt+q3gNl0opXlljx2QVg3vBGcN8e3MHGaHqR+ewdTYavJ3azvOdXR13MihYSU+VvhbV37zQR/AWhynJ5gtMMuR6v4unW8YPRzMZEs6hw6pvVbzcMJXDcoBZh3bUXFQwBByDmptlDWqmz7Z9GvDZPE4sfc+U3vURyk8KguB86FEdBMJlIdA6yDyc43iZGE/OhIAQLARaB0lDnMYzD0fSngFtzyBJuMiydLbw8AR8tp5A+yvK/wTC7A3mSWjHaI7JOjMS854CbU+BnfbMZ+FO6wG0zoOlfwSWPQXacR7eccTwxujEBUbPmYdkkeHMJ6l40OhEpPPJGjgzNNjJ1BguscQ/ONgp1RijVH0XDXZiNcaoM99lg51ajeEwme/CwU65xnCU9IIYO+3iUbx4dkHOnY7xRMizC3LllIwnUk5C31wRp2RjuJTP/MNDnJSN4TiJ91ZJhg13ouTYf1ZOyGQi5Jm/N07IZCLk1D/nZp/vXiMTJV+wPonTsjHGTdB3YREnZWM4TOYfZKdk8kbJ3t44IZOJkOFN7/uSdUJOJkLO/DFOx8lExxekKnFCNsa4rs5760ddKWOrqBuqqauiOpuetNjxSjM5KRLB218Wm8v/LDahYmrpgX2j8sAbFVRQA5pSCiQhu3LL2lA9WstUO7ZWdGdH+KphUL3HISyxUghwpzvpufdMn1ooHFsm7/krVI+QXSE5FGz2s2WDKvi+Ujn0o+AIHa8Ceqqblpsq1nycaZ4P58DsxtvZgbZrURS39sL2I63bT9ffvt8FtwMluAP4OhpvWkdvH4+GD7ntv1BLAwQUAAAACAAQc5tcSrXi2FEFAADkFwAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbKVYW3ObOhB+PzPnPzC8BxAXG3tsd9y4adMmbZpr2zeM5ZgJIBfI7Zw5//2swGtAKAy4nsTI3k/fSt/uSrIm716iUHmiSRqweKoSzVAVGvtsFcT3U/Xm+uTIVZU08+KVF7KYTtVXmqrvZn//NXlmyUO6oTRTgCFOp+omy7ZjXU/9DY28VGNbGoNlzZLIy+Bjcq+n24R6q7xTFOqmYQz0yAtitWAYJ1042Hod+HTB/MeIxllBktDQy2D86SbYpsgW+V3oIi95eNwe+SzaAsUyCIPsNSdVlcgfn97HLPGWIcz7hdier7wk8GfCv4Vu8u8bnqLAT1jK1pkGzHox5ub0R/pI9/w9U3P+nWiIDQI8BTyAJZV52JCIs+cySzLrQDIemWJgXK5k/Bispuq/xu51BE/C34wjg/C3yus/dTZZBRBh3llJ6Hqqzsl4vrBUfTbJE+g2oM9ppa1k3vKKhtTPKDghqsLzc8nYAweewlcGUG69mCqvV1uI8lSFCWZse0bX2TENQ3AAg/T8LHiiFwCbqkuWZSzi9rwCMvhqnbB/aJyPIXfFB8c56+CCpCB9D6Tp73wC0ISO+n701TbO5CSvlotEWdG19xhmxyy8C1bZBmZENNt0hi4xHRWtl+z5Ew3uNzAZYmpDMOTZOF69LmjqQ3nArDWTe/VZCC7gXYkCXuaQ3d5LIVNBbxLNdB3iDDi9/5jCzNHxrn/RE0TLe8Jz15PYlZ5LmmYnXFxgbmEBUXIWeCKLW5leS0971xOeOHKr0rOjf5hj7h+e6N/RnKFh5ep2JOFLBCeBJ5IQjdhGLmFHjuGOA57IMewmBCzLuXd4ohDd3Y52neGJne2+QyewUxRJBA0c/KA3yz4Vy1wkbu9YEMxL3sApmf1pMDFJJTMhvh2jSTA7eeMP0pNgfvJG/+gSzEzeODy+mJukTE5z0L/WCGYqb5SjcR3HHrh8zeoqLiYtKbOWh6ljdxPTlTfKou9ZryamK28gi9lfFHO/jlZCdMBCZmKQeOPwWWGIzDJEsKGU+01XjTFEZiVEB6SMhbHijT9Q2cJo8caOZ3TAboXBssrFBYTqKIq13+zKYgZ5uvbGWrbKRKlulV1pME+sMjKj/gG2MTB2KehQGxJjZPWoZBv1tMtl0u3PgoukXeo67Lv92CivXeri9iVxUBWnzI9RbxJME6ciSuc0cfYnmnId6J5kDtY/b+zqZKj1XqEdLP9BmR1uf5oBpgdv7Ebj9q/aAQo6qNRdZxq9ODHnh/WFl3mzScKeFfiFBlNL4cgPv3fJmC9P0hM3HLU5ds7BUxUCCifiFH5/PM2Mif4EB38fEYsmhOwhOvjcOwYxujvm4Lpjs+74fRNh1RHHTYRdRyyaCKeO+NBEDOqIkyZiWEd8bCLcOuJTEzGqI06bCCJE4rMEUkYiD+cXCUSQ9UwCEXQ9l0AEYb9KIIKy3yQQQdoLCUTQ9rsEIoh7KYEI6l5Jsk1Q91oCEdS9kUAEdW8lEEHdOwlEUPeHBCKo+1MCEdT9JYEI6s7nEowg71xSiKag71xSilZjISl8mfkq88YSwu8iOq9dAN6vWpYQK36r8abxuM0INzhv9/xQMwrBP2kzfmyj/dRmPG0zfq4ZhVT70tbzrG20523Gr5Zso/jW1uWizfi9zXjZNoermlGoouu2njdtxts2413NKJTlj5pRKMifNaNQir9qRrEG+c1fmc5C3s0h2WU7d2ua85tKXo6O0LXY0Ys7wOJYsfXu6bmX3AdxqoRw18iv7OAMlxTXenkbbinzFv+tnN9J4qcN3KZT2JgMDbytGcvwA79n3N/Pz/4HUEsBAhQAFAAAAAgAEHObXJDvHNaaAQAAbQcAABMAAAAAAAAAAAAgALaBAAAAAFtDb250ZW50X1R5cGVzXS54bWxQSwECFAAUAAAACAAQc5tctVUwI+4AAABMAgAACwAAAAAAAAAAACAAtoHLAQAAX3JlbHMvLnJlbHNQSwECFAAUAAAACAAQc5tcIajWr7ABAAB2AwAAEAAAAAAAAAAAACAAtoHiAgAAZG9jUHJvcHMvYXBwLnhtbFBLAQIUABQAAAAIABBzm1wMxHTVMwEAAFECAAARAAAAAAAAAAAAIAC2gcAEAABkb2NQcm9wcy9jb3JlLnhtbFBLAQIUABQAAAAIABBzm1xNQdbSGgEAAHsEAAAaAAAAAAAAAAAAIAC2gSIGAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc1BLAQIUABQAAAAIABBzm1ziK397uwAAADMBAAAyAAAAAAAAAAAAIAC2gXQHAAB4bC9waXZvdENhY2hlL19yZWxzL3Bpdm90Q2FjaGVEZWZpbml0aW9uMS54bWwucmVsc1BLAQIUABQAAAAIABBzm1zaSUmbZQcAAPUjAAAnAAAAAAAAAAAAIAC2gX8IAAB4bC9waXZvdENhY2hlL3Bpdm90Q2FjaGVEZWZpbml0aW9uMS54bWxQSwECFAAUAAAACAAQc5tchitraQABAADfAgAAJAAAAAAAAAAAACAAtoEpEAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlUmVjb3JkczEueG1sUEsBAhQAFAAAAAgAEHObXApBDOq9AAAARwEAACkAAAAAAAAAAAAgALaBaxEAAHhsL3Bpdm90VGFibGVzL19yZWxzL3Bpdm90VGFibGUxLnhtbC5yZWxzUEsBAhQAFAAAAAgAEHObXCGEs0VuBgAALTwAAB4AAAAAAAAAAAAgALaBbxIAAHhsL3Bpdm90VGFibGVzL3Bpdm90VGFibGUxLnhtbFBLAQIUABQAAAAIABBzm1wYvO2BbAMAAGYJAAANAAAAAAAAAAAAIAC2gRkZAAB4bC9zdHlsZXMueG1sUEsBAhQAFAAAAAgAEHObXMKH2/JRBgAA1xsAABMAAAAAAAAAAAAgALaBsBwAAHhsL3RoZW1lL3RoZW1lMS54bWxQSwECFAAUAAAACAAQc5tc45M5Uu0CAACLBgAADwAAAAAAAAAAACAAtoEyIwAAeGwvd29ya2Jvb2sueG1sUEsBAhQAFAAAAAgAEHObXMihuPq4AAAANAEAACMAAAAAAAAAAAAgALaBTCYAAHhsL3dvcmtzaGVldHMvX3JlbHMvc2hlZXQyLnhtbC5yZWxzUEsBAhQAFAAAAAgAEHObXEw6TVzTAwAADQ4AABgAAAAAAAAAAAAgALaBRScAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbFBLAQIUABQAAAAIABBzm1xKteLYUQUAAOQXAAAYAAAAAAAAAAAAIAC2gU4rAAB4bC93b3Jrc2hlZXRzL3NoZWV0Mi54bWxQSwUGAAAAABAAEAB/BAAA1TAAAAAA xl/worksheets/sheet1.xml xl/worksheets/sheet3.xml 1 0 Sum of Bucket Quantity 1 Bucket Date 2 Plan 3 Organization Code 4 End Assembly 5 End Assembly Description 6 Bom Sort Order 7 Bom Level 8 Item 9 Item Description 10 Item Type 11 UOM 12 Category 13 Preprocessing Lead Time 14 Full Lead Time 15 Postprocessing Lead Time 16 Cumulative Total Lead Time 17 Cumulative Mfg Lead Time 18 Primary Supplier 19 Buyer 20 Make Or Buy 21 WIP Supply Type 22 Planner Code 23 Planner Description 24 Planning Method 25 Forecast Control 26 Pegging 27 Planning Time Fence 28 End Assemblies 29 Source Type 30 Source Type Text 31 NA 32 (blank) 33 Each 34 Make 35 MPS planning 36 Consume and Derive Forecast 37 End Assembly/ Soft Pegging 38 User-defined time fence data A1 1 data AA1 1 data AB1 1 data AC1 1 data AD1 1 data AE 2 data AE1 1 data AF 4 data AF1 1 data B1 1 data C1 1 data D1 1 data E1 1 data F1 1 data G1 1 data H1 1 data I1 1 data J1 1 data K1 1 data L1 1 data M1 1 data N1 1 data O1 1 data P1 1 data Q1 1 data R1 1 data S1 1 data T1 1 data U1 1 data V1 1 data W1 1 data X1 1 data Y1 1 data Z1 1 parameter A1 1 parameter A10 1 parameter A11 1 parameter A12 1 parameter A13 1 parameter A14 1 parameter A15 1 parameter A16 1 parameter A2 1 parameter A3 1 parameter A4 1 parameter A5 1 parameter A6 1 parameter A7 1 parameter A8 1 parameter B3 3 S Site SYSADMIN HP by End Assemblies, Components DEVELOPER HP by End Assemblies, Components ENGINATICS HP by End Assemblies, Components ANDY.HAACK HP by End Assemblies, Components HP by Components