ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 3A375BA95D95AEEEE06362FB0905F3E4 with opm_batch_lot_costs as ( select x.top_batch_id, x.top_item_id, x.batch_id, x.material_detail_id, x.organization_id, x.product_item_id, x.inventory_item_id, x.primary_uom_code, x.dtl_um, x.dtl_prim_uom_conv_rate, x.plan_qty, x.actual_qty, x.scaled_actual_qty, x.ingredient_usage_factor, x.lot_number, x.lot_cost * x.dtl_prim_uom_conv_rate lot_cost, x.lot_qty, x.scaled_lot_qty, x.intermediate_ingred, x.uom_conv_error, x.line_type, x.lot_source, x.step_level, x.sort_order, x.group_id from xmltable ( '/BATCHLOTCOST/ROW' passing xxen_opm.get_report_xml columns top_batch_id number path 'TOP_BATCH_ID' , top_item_id number path 'TOP_ITEM_ID' , batch_id number path 'BATCH_ID' , material_detail_id number path 'MATERIAL_DETAIL_ID' , organization_id number path 'ORGANIZATION_ID' , product_item_id number path 'PRODUCT_ITEM_ID' , inventory_item_id number path 'INVENTORY_ITEM_ID' , primary_uom_code varchar2(3) path 'PRIMARY_UOM_CODE' , dtl_um varchar2(3) path 'DTL_UM' , dtl_prim_uom_conv_rate number path 'DTL_PRIM_UOM_CONV_RATE' , plan_qty number path 'PLAN_QTY' , actual_qty number path 'ACTUAL_QTY' , scaled_actual_qty number path 'SCALED_ACTUAL_QTY' , ingredient_usage_factor number path 'SCALING_FACTOR' , lot_number varchar2(150) path 'LOT_NUMBER' , lot_cost number path 'LOT_COST' , lot_qty number path 'LOT_QTY' , scaled_lot_qty number path 'SCALED_LOT_QTY' , intermediate_ingred varchar2(1) path 'INTERMEDIATE_INGRED' , uom_conv_error varchar2(1) path 'UOM_CONV_ERROR' , line_type number path 'LINE_TYPE' , lot_source varchar2(150) path 'LOT_SOURCE' , step_level number path 'STEP_LEVEL' , sort_order varchar2(2000) path 'SORT_ORDER' , group_id number path 'GROUP_ID' ) x ) -- -- select ood.organization_code organization, gbh1.batch_no, (select gfc.formula_class_desc from fm_form_mst ffm,gmd_formula_class gfc where ffm.formula_class = gfc.formula_class and ffm.formula_id = gbh1.formula_id) batch_type, gbh1.actual_cmplt_date batch_completion_date, (select gllv.currency_code from gl_ledger_le_v gllv where gllv.ledger_id = ood.set_of_books_id) currency_code, -- product msiv1.concatenated_segments product, msiv1.description product_desc, xxen_util.meaning(msiv1.item_type,'ITEM_TYPE',3) product_item_type, case when oblc.step_level = 0 then gmd.plan_qty else null end batch_size, case when oblc.step_level = 0 then gmd.actual_qty else null end batch_actual_output, case when oblc.step_level = 0 then round(gmd.actual_qty/gmd.plan_qty*100,2) else null end batch_yield, case when oblc.step_level = 0 then trunc(trunc(oblc.lot_cost,:p_precision) * oblc.actual_qty,:p_precision) else null end batch_cost, case when oblc.step_level = 0 then trunc(oblc.lot_cost,:p_precision) else null end batch_unit_cost, -- ingredients oblc.step_level "Level", xxen_util.meaning(oblc.line_type,'GMD_FORMULA_ITEM_TYPE',552) type, xxen_util.meaning(decode(oblc.intermediate_ingred,'Y','Y',null),'YES_NO',0) intermediate_ingredient, msiv2.concatenated_segments item, msiv2.description item_desc, xxen_util.meaning(msiv2.item_type,'ITEM_TYPE',3) item_type, -- lot oblc.lot_number, trunc(oblc.lot_cost,:p_precision) lot_cost, trunc(oblc.scaled_lot_qty,:p_precision) lot_quantity, trunc(trunc(oblc.lot_cost,:p_precision) * trunc(oblc.scaled_lot_qty,:p_precision),:p_precision) lot_extended_cost, gbh2.batch_no line_batch_no, oblc.lot_source, oblc.ingredient_usage_factor, oblc.dtl_um detail_uom, oblc.primary_uom_code, oblc.dtl_prim_uom_conv_rate, xxen_util.meaning(oblc.uom_conv_error,'YES_NO',0) uom_conv_error, case when oblc.line_type = 1 then trunc(trunc(oblc.lot_cost,:p_precision) * trunc(oblc.scaled_lot_qty,:p_precision),:p_precision) else null end product_cost, case when oblc.intermediate_ingred = 'N' and oblc.step_level > 0 then trunc(trunc(oblc.lot_cost,:p_precision) * trunc(oblc.scaled_lot_qty,:p_precision),:p_precision) else null end ingredient_cost, case when oblc.intermediate_ingred = 'Y' and oblc.step_level > 0 then trunc(trunc(oblc.lot_cost,:p_precision) * trunc(oblc.scaled_lot_qty,:p_precision),:p_precision) else null end intemediate_ingredient_cost, -- &lp_prod_category_segments &lp_prod_catalog_elements &lp_prod_item_dff &lp_ingred_category_segments &lp_ingred_catalog_elements &lp_ingred_item_dff -- oblc.sort_order, oblc.top_batch_id, oblc.batch_id, oblc.material_detail_id from opm_batch_lot_costs oblc, gme_batch_header gbh1, gme_batch_header gbh2, gme_material_details gmd, org_organization_definitions ood, mtl_system_items_vl msiv1, mtl_system_items_vl msiv2 where oblc.top_batch_id = gbh1.batch_id and oblc.top_batch_id = gmd.batch_id and oblc.top_item_id = gmd.inventory_item_id and gmd.line_type = 1 and oblc.batch_id = gbh2.batch_id and gbh1.organization_id = ood.organization_id and oblc.organization_id = msiv1.organization_id and oblc.top_item_id = msiv1.inventory_item_id and oblc.organization_id = msiv2.organization_id and oblc.inventory_item_id = msiv2.inventory_item_id and -- -- only the top batch product line to be selected (oblc.step_level = 0 or oblc.line_type = -1) and -- (:p_show_interm_ingred = 'Y' or oblc.intermediate_ingred = 'N') and 1=1 order by gbh1.batch_no, oblc.sort_order Y XXEN_OPM US OPM Batch Lot Cost Trends OPM Batch Lot Costing Trends Report This report shows the Batch Lot Costs for the specified Organization and Product over a specified date range. The report shows the Lot Cost for the batch product and explodes the batch to display all the lowest level ingredient lot costs involved in producing the batch. Where an ingredient is sourced from another (child) batch, the (child) batch ingredient quantities are apportioned based on the actual usage of the ingredient in the batch consuming that ingredient. By default, intermediate ingredients are not displayed in the report, so as not to overstate the ingredient lot costs. To override this default behaviour set the ‘Show Intermediate Ingredients’ report parameter to Yes The report allows the user to pull in several additional data points to allow further analysis of data based on the customer specific configuration. Specifically, for the both the batch product (same for all lines in the batch) and for the batch ingredients (are specific to each line in the batch), the following additional data can be pulled into the report. - Item Catalog Descriptive Elements for a specific Item Catalog Group - Item Category Segments for a specific Item Category Set - Item Descriptive Flexfield Attributes Enginatics R12 only &lp_ingred_catalog_elements &lp_ingred_category_segments &lp_ingred_item_dff &lp_prod_catalog_elements &lp_prod_category_segments &lp_prod_item_dff 1=1 :p_batch_no :p_conc_request_id :p_cost_type :p_cost_type_id :p_date_from :p_date_to :p_formula_class :p_item :p_master_org_id :p_org_code :p_org_id :p_precision :p_report_code :p_show_interm_ingred 1 -20 :p_report_code Char OPM_BATCH_LOT_COST US Report Code 2 -10 :p_precision Number 3 US Precision 3 10 :p_org_code LOV custom Y select goav.organization_code value, goav.organization_name description from gmd_org_access_vw goav order by value select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') Y US Organization Code 4 20 :p_date_from Date Y US From Date 5 30 :p_date_to Date Y US To Date 6 40 :p_item LOV custom Y Y select msiv.concatenated_segments value, msiv.description from mtl_parameters mp, mtl_system_items_vl msiv where msiv.organization_id=mp.organization_id and xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y' and exists (select null from gme_batch_header gbh, gme_material_details gmd, mtl_material_transactions mmt, mtl_transaction_lot_numbers mln where gbh.batch_id = gmd.batch_id and gbh.organization_id = msiv.organization_id and gmd.inventory_item_id = msiv.inventory_item_id and gmd.batch_id = mmt.transaction_source_id and gmd.material_detail_id = mmt.trx_source_line_id and gmd.inventory_item_id = mmt.inventory_item_id and mmt.transaction_source_type_id = 5 and mmt.transaction_id = mln.transaction_id and gmd.line_type = 1 and gbh.actual_cmplt_date is not null and trunc(gbh.actual_cmplt_date) between :$flex$.from_date and :$flex$.to_date and (:$flex$.formula_class is null or gbh.formula_id in (select ffm.formula_id from fm_form_mst ffm where ffm.formula_class = :$flex$.formula_class and ffm.owner_organization_id = mp.organization_id) ) ) order by value Y US Product 7 50 :p_formula_class LOV custom Y select gfc.formula_class id, gfc.formula_class_desc value, null description from gmd_formula_class gfc order by value US Formula Class 8 60 :p_batch_no LOV custom Y select gbh.batch_no value, to_char(gbh.actual_cmplt_date,'DD-MM-YYYY HH24:MI:SS') description from mtl_parameters mp, gme_batch_header gbh where gbh.organization_id = mp.organization_id and xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y' and gbh.actual_cmplt_date is not null and trunc(gbh.actual_cmplt_date) between :$flex$.from_date and :$flex$.to_date and (:$flex$.formula_class is null or gbh.formula_id in (select ffm.formula_id from fm_form_mst ffm where ffm.formula_class = :$flex$.formula_class and ffm.owner_organization_id = mp.organization_id) ) and exists (select null from gme_material_details gmd, mtl_system_items_vl msiv, mtl_material_transactions mmt, mtl_transaction_lot_numbers mln where gmd.batch_id = gbh.batch_id and gmd.line_type = 1 and gmd.organization_id = msiv.organization_id and gmd.inventory_item_id = msiv.inventory_item_id and gmd.batch_id = mmt.transaction_source_id and gmd.material_detail_id = mmt.trx_source_line_id and gmd.inventory_item_id = mmt.inventory_item_id and mmt.transaction_source_type_id = 5 and mmt.transaction_id = mln.transaction_id and msiv.concatenated_segments = :$flex$.product ) order by value US Batch 9 70 :p_cost_type_id LOV custom Y select cmm.cost_type_id id, cmm.cost_mthd_code value, cmm.cost_mthd_desc description from cm_mthd_mst cmm where cmm.cost_type = 6 order by value select cmm.cost_mthd_code from mtl_parameters mp, cm_mthd_mst cmm, gmf_fiscal_policies gfp, org_organization_definitions ood where cmm.default_lot_cost_type_id = gfp.cost_type_id and gfp.legal_entity_id = ood.legal_entity and xxen_util.contains(:$flex$.organization_code,ood.organization_code) = 'Y' Y US Cost Type 10 80 &lp_prod_category_segments select x.* from ( select '(select min(mcb.'||lower(fifsv.application_column_name)||') keep (dense_rank first order by mic.category_id) from mtl_item_categories mic, mtl_categories_b mcb where mic.category_set_id=' || mcsv.category_set_id || ' and msiv1.organization_id=mic.organization_id and msiv1.inventory_item_id=mic.inventory_item_id and mic.category_id=mcb.category_id) "'||substrb('Prd: ' || fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",' sql_text from mtl_category_sets_vl mcsv, (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where mcsv.category_set_name=:p_prod_cat_set_name and mcsv.structure_id=fifsv.id_flex_num and fifsv.application_id=401 and fifsv.id_flex_code='MCAT' and fifsv.enabled_flag='Y' order by fifsv.id_flex_num, fifsv.segment_num ) x 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 US Product Category Set 11 90 &lp_prod_catalog_elements select distinct '(select mdev.element_value from mtl_descr_element_values_v mdev where mdev.inventory_item_id = msiv1.inventory_item_id and mdev.item_catalog_group_id = msiv1.item_catalog_group_id and mdev.element_name = ''' || mdv.element_name || ''')' || ' "' || substrb('Prd: ' || mdv.element_name,1,xxen_report.max_column_length) || '",' value from mtl_descr_element_values_v mdv where mdv.item_catalog_group_id = :p_prod_catlg_grp_id order by value LOV custom Y select micgbk.item_catalog_group_id id, micgbk.concatenated_segments value, null description from mtl_item_catalog_groups_b_kfv micgbk where exists (select null from mtl_parameters mp, mtl_system_items_b msib where mp.organization_id = msib.organization_id and msib.item_catalog_group_id = micgbk.item_catalog_group_id and xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y' ) US Product Item Catalog 12 100 &lp_prod_item_dff select xxen_util.dff_columns(p_table_name=>'mtl_system_items_b',p_table_alias=>'msiv1', p_row_id=>'row_id',p_column_name_prefix=>'Prd: ') sql_text from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Product Item DFF 13 110 &lp_ingred_category_segments select x.* from ( select '(select min(mcb.'||lower(fifsv.application_column_name)||') keep (dense_rank first order by mic.category_id) from mtl_item_categories mic, mtl_categories_b mcb where oblc.step_level > 0 and mic.category_set_id=' || mcsv.category_set_id || ' and msiv2.organization_id=mic.organization_id and msiv2.inventory_item_id=mic.inventory_item_id and mic.category_id=mcb.category_id) "'||substrb('Ing: ' || fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",' sql_text from mtl_category_sets_vl mcsv, (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where mcsv.category_set_name=:p_ingred_cat_set_name and mcsv.structure_id=fifsv.id_flex_num and fifsv.application_id=401 and fifsv.id_flex_code='MCAT' and fifsv.enabled_flag='Y' order by fifsv.id_flex_num, fifsv.segment_num ) x 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 US Ingredient Category Set 14 120 &lp_ingred_catalog_elements select distinct '(select mdev.element_value from mtl_descr_element_values_v mdev where oblc.step_level > 0 and mdev.inventory_item_id = msiv2.inventory_item_id and mdev.item_catalog_group_id = msiv2.item_catalog_group_id and mdev.element_name = ''' || mdv.element_name || ''')' || ' "' || substrb('Ing: ' || mdv.element_name,1,xxen_report.max_column_length) || '",' value from mtl_descr_element_values_v mdv where mdv.item_catalog_group_id = :p_ingred_catlg_grp_id order by value LOV custom Y select micgbk.item_catalog_group_id id, micgbk.concatenated_segments value, null description from mtl_item_catalog_groups_b_kfv micgbk where exists (select null from mtl_parameters mp, mtl_system_items_b msib where mp.organization_id = msib.organization_id and msib.item_catalog_group_id = micgbk.item_catalog_group_id and xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y' ) US Ingredient Item Catalog 15 130 &lp_ingred_item_dff select xxen_util.dff_columns(p_table_name=>'mtl_system_items_b',p_table_alias=>'msiv2', p_row_id=>'row_id',p_column_name_prefix=>'Ing: ') sql_text from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Ingredient Item DFF 16 140 :p_show_interm_ingred LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Include Intermediate Ingredients :$flex$.formula_class Formula Class Batch :$flex$.formula_class Formula Class Product :$flex$.from_date From Date Y Batch :$flex$.from_date From Date Y Product :$flex$.organization_code Organization Code Batch :$flex$.organization_code Organization Code Cost Type :$flex$.organization_code Organization Code Ingredient Category Set :$flex$.organization_code Organization Code Ingredient Item Catalog :$flex$.organization_code Organization Code Product :$flex$.organization_code Organization Code Product Category Set :$flex$.organization_code Organization Code Product Item Catalog :$flex$.product Product Batch :$flex$.to_date To Date Y Batch :$flex$.to_date To Date Y Product Detail SYSADMIN -7.0008 ACTUAL_LOT_QUANTITY -7.0008 ACTUAL_QUANTITY 2 BATCH_NO 12 BATCH_SIZE 13 BATCH_YIELD -7.0009 EXTENDED_COST 11 INGREDIENT_COST 4 ITEM 7 LOT_COST 9 LOT_EXTENDED_COST 5 LOT_NUMBER 8 LOT_QUANTITY 6 LOT_SOURCE -8.0009 LOT_VALUE 1 ORGANIZATION 10 PRODUCT_COST -5.0006 SOURCE -8.0009 TOTAL_COST 3 TYPE -8.0009 VALUE S Site Detail Pivot ERIC.CLEGG 10 BATCH_ACTUAL_OUTPUT 4 BATCH_COMPLETION_DATE 12 BATCH_COST 2 BATCH_NO 9 BATCH_SIZE 3 BATCH_TYPE 13 BATCH_UNIT_COST 11 BATCH_YIELD 5 CURRENCY_CODE 27 DETAIL_UOM 29 DTL_PRIM_UOM_CONV_RATE 32 INGREDIENT_COST 26 INGREDIENT_USAGE_FACTOR 33 INTEMEDIATE_INGREDIENT_COST 16 INTERMEDIATE_INGREDIENT 17 ITEM 18 ITEM_DESC 19 ITEM_TYPE 24 LINE_BATCH_NO 21 LOT_COST 23 LOT_EXTENDED_COST 20 LOT_NUMBER 22 LOT_QUANTITY 25 LOT_SOURCE 14 Level 35 MATERIAL_DETAIL_ID 1 ORGANIZATION 28 PRIMARY_UOM_CODE 6 PRODUCT 31 PRODUCT_COST 7 PRODUCT_DESC 8 PRODUCT_ITEM_TYPE 34 SORT_ORDER 15 TYPE 30 UOM_CONV_ERROR OPM Batch Lot Cost Trends Template 20250801.xlsx US UEsDBBQAAAAIAFlhllyQ7xzWmgEAAG0HAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbM2V30/CMBDH3038H5a+mq2AiTGGwQPqoxLFP6CsB2vY2qZXEP57bx34g0yQgNGXtVt79/20d7vr9pdlES3AoTI6Ze2kxSLQmZFKT1P2MrqPr1mEXmgpCqMhZStA1u+dn3VHKwsYkbXGlOXe2xvOMcuhFJgYC5pWJsaVwtOrm3IrspmYAu+0Wlc8M9qD9rGvfLBe9xYmYl746G5Jn2sSBwWyaFBvrLRSJqwtVCY8rfOFllsq8VohIcuwB3Nl8YIwGG9UqFa+F1jbPdLVOCUhGgrnH0RJGHxZ8FfjZmNjZsluJw2UZjJRGUiTzUs6WILWgZCYA/iySMKYlELpDfcO/bAZeRjaJwapzhccH8jR+Sccl3/EYdXC+IGg34B/TCm7lVZVSp46TE0aeyLWSPgEmXESfw9vLbCHzVP1AB6ex6MEN3sE0a8KwBPnSu10n3IuHMhn76jOnhzgs++fpMNIjIm4ztgwP/72v9a1D8+7cKgoDp2xSO3BweFB2dT/yjq25AicV7sD8a5IreVwwa1SDlXzkiAbtHlolr03UEsDBBQAAAAIAFlhlly1VTAj7gAAAEwCAAALAAAAX3JlbHMvLnJlbHONks9OwzAMxu9IvEPk++puSAihpbtMSLshVB7AJO4ftY2jJED39oQDgkpj29H2588/W97u5mlUHxxiL07DuihBsTNie9dqeK2fVg+gYiJnaRTHGo4cYVfd3mxfeKSUm2LX+6iyi4saupT8I2I0HU8UC/HscqWRMFHKYWjRkxmoZdyU5T2Gvx5QLTzVwWoIB3sHqj76PPmytzRNb3gv5n1il06MQJ4TO8t25UNmC6nP26iaQstJgxXznNMRyfsiYwOeJtpcT/T/tjhxIkuJ0Ejg8zzfinNA6+uBLp9oqfi9zjzip4ThTWT4YcHFD1RfUEsDBBQAAAAIAFlhllyKtF2BqAEAAG4DAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJ2TwW7bMAyG7wP2DoLujdxmKIZAVtGlG3po0WBxu7Mq07FQWTJExkj29JMdxHHannYj+VPUR5GSN7vGsQ4i2uBzfjnLOANvQmn9JufPxa+L75whaV9qFzzkfA/Ib9TXL3IVQwuRLCBLJTzmvCZqF0KgqaHROEuyT0oVYqMpuXEjQlVZA3fBbBvwJK6y7FrAjsCXUF60Y0F+qLjo6H+LlsH0fPhS7NsErGQRSLvCNqAyKU6OvG1bZ42m1L16tCYGDBWxnzsDToqpKBP1Gsw2Wtr3NaauXBvtYJkuVJV2CFKcAvIedP+YK20jKtnRogNDITK0f9NzXnH2qhF6zJx3OlrtKeH2aQdnsF2LFNWfEN+wBiCUYgwO5jR3attvaj4kJOM8cTg1gCThHLGw5ACfqpWO9AnxfEo8gB14D4zrsI0G2J0mPYUc9afVI/uhydTsIRBbBiRWxDR/ZL+hDfHTMwlEN0BpRz/0fezgHfOD9W/43BYhccBxJudBua51hDKNcZzZGJD3aRzR9UWWtfYbKI85H4V+g14O30ddXs+yeZaWYxKT4vRR1D9QSwMEFAAAAAgAWWGWXD0eC005AQAAUQIAABEAAABkb2NQcm9wcy9jb3JlLnhtbI2SX0vDMBTF3wW/Q8l7m7SzY5a2A5U9ORCsKL6F5G4LNn9Iot2+vWm71Q324OO959xfzr2kXO5lG/2AdUKrCqUJQREoprlQ2wq9Nat4gSLnqeK01QoqdACHlvXtTclMwbSFF6sNWC/ARYGkXMFMhXbemwJjx3YgqUuCQwVxo62kPpR2iw1lX3QLOCNkjiV4yqmnuAfGZiKiI5KzCWm+bTsAOMPQggTlHU6TFP95PVjprg4MyplTCn8wYadj3HM2Z6M4ufdOTMau65JuNsQI+VP8sX5+HVaNhepvxQDVJWcFs0C9tnUZ0v4V4XAtdX4dbrwRwB8OQb/S42yIO84Bj0KAYox7Ut5nj0/NCtUZyfKYLGKSNmReZHmR5p/9kxfzfaCxIY8P/4OY3jdZ1hPzuzPiCTDmvvwE9S9QSwMEFAAAAAgAWWGWXE1B1tIaAQAAewQAABoAAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc72UwUrEMBCG74LvEOZu03Z1Fdl0Dy7CXnV9gNBO27BtEjJxtW9vrNBaWOoeipfAzCT//zHMZLP9bBt2QkfKaAFJFANDnZtC6UrA2+H55gEYeakL2RiNAjok2GbXV5sXbKQPj6hWllhQ0SSg9t4+ck55ja2kyFjUoVIa10ofQldxK/OjrJCncbzm7rcGZBNNti8EuH2xAnbobHD+W9uUpcpxZ/L3FrU/Y8E/jDtSjeiDqHQVegFDinhfWUWBGPh5mPslYaiWDotX70KvaQSapOdg0iVhLuhMOgeT/DNMMgezXhKGfNeEoR8G5iees79b0t6HVcLRvQ95f8624HZJBqtOxj/JsNU7LJVW33s/Io1Vfu7igMknX0b2BVBLAwQUAAAACABZYZZc4it/e7sAAAAzAQAAMgAAAHhsL3Bpdm90Q2FjaGUvX3JlbHMvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbC5yZWxzhY/BasMwEETvhf6D2HstO4dQiuUcEgK5BucDFmlti9haoVVC/PfRMaGFHodh3sy0u8cyqzsl8RwMNFUNioJl58No4NIfv75BScbgcOZABlYS2HWfH+2ZZswlJJOPogoliIEp5/ijtdiJFpSKI4XiDJwWzEWmUUe0VxxJb+p6q9MrA7o3pjo5A+nkGlD9Gkvz/2weBm/pwPa2UMh/VOjo75z3WOadyXJyUuCYRsoGfllNVaaD7lr9drV7AlBLAwQUAAAACABZYZZc6nzNChoKAADEOAAAJwAAAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbO1bXW/byBV9L9D/QOhh0T4oEr8k0Wt74c+tF3acrpMF+khLtE1EJAWScu0t+t97ZiiJ5ziOpST2blIECBIeHXrumTlzZ+5MrO2f7rKpc5uUVVrkOx33Vb/jJPm4mKT59U7n3dvj7qjjVHWcT+JpkSc7nfuk6vy0+9e/bM/S26I+iMc3yWFyleZpjQYcNJZXO52bup5t9XoVyCyuXhWzJAdzVZRZXAOW171qVibxpLpJkjqb9rx+f9DL4jTvNC1slZu0UVxdpePksBjPsySvm0bKZBobJdVNOquWrWXjTZrL4vL9fNYdF9kMTVym07S+t412nGy8dXKdF2V8OcUQ3JXLhu8+1Jml47Koiqv6FRrqNRI/6K0bQOhtasa845Rb6WSnU55MXDwnV2VS3Zznp0WMD9tPksn+/U5nb17fFIi+eC2ZHMY1BAXhaBS9Cnw/CCM38EMXnmVpVcHDkzrJqtM0S+udDqwdY9TrZPLb0m+8uGqLP8zS/NdGiunyivHN6+OinBwU8xwtehiIcmtu9P8n8odhdHB82I1Cf9QN9vtH3Wg42use7/mHx5E7CNyj4L+d3e2xmTIXxbwcJ059P4P8fxflezsTwK6eF2/kcYY3GoDOxp3e7naPmli0d5wm00nljBtZfrSMYz93mkbOy+s4T3+306Pj5PPsOKtPoLyPl9HPMpnYwVoFsD/L7S/a2Y/r8Y3zuniiDQjJa0zn6iLJ0rP0Lpm8RU+RGMaCJVWXNsfoo9fz7DLBlILty7dO8jq5XnwGU36Lp3N0BS9k8V0LFv120ZPcuTW86QV1ajloT/fJiNykV6+LvJl4T3dnfxrn75dirGdPhz9A5k0Tu46Y5lkJpo+6tMkIPyaz0U0DfNHagPFtaCR9v9t38edtv79l/9gBf8B6xJIDE+PAY0184MmVmWE/l8V85sxi+O6P2un9saE6mJclFuh756CYPGXW2mn8piwm83H9JZmwaMI5TKrxc7Rj8s/5kyfhRfr7RjlA82aZq6v5vpqcGyd0M78WCd1fPwuaNWhvXM/jqXM+r2fzp4x8as35w0X/y0z6TVaZ5x1hd5HDy0UTcG2KNKN8UFTfzOC+Qx32jQg+TW6T6Ubz4GX2UEm5ZsN8co9avy4tSiJUE2YHWK6vaNjik/waJUaKSvVTN2dTA5QZfhabk0PNfLyGaReg596pzRL9tGl2FEwlYnv9eu+Te2s2gTU7yrLQ+9Iw6z1tyrhnL3hOi9ppNoeXHUwT5+H65Q7CT6+lHlmMP3dzY/NstdqsxJ9QrZpe/XMe5zVOaFol/j/07OiuTvJJMvnqjFu7RJ6meeJ8fcej9boxn5oj5ib7EVdMqyU/Wy7zn7HgrTYG510VXyfOcTyuzSn/o0fUTQ4/X5KwD46Xa8fvMMEqOXXeFU9tDWtbeVOmuIK5d96dn33x4eawnjqmPaMJjeW3zq8PTpQPTv1f25CudB+V5WZz4dn3qOXp7tuof9u66Bupf01V92FRt7H4Z7f7oihr57ycrCtJXvRi61OL8jNkdZniDLxYgk42O1n+ASeKDY6XF7hKzXFr+bflOVOuv/6uG4Azwe3nZVw1d2jNrSXdHxkGF0j4sIzz6+RN6VybeyVzaVw1Yew1flk/ccOFquPjN1xYvm2L9o50WcINvGWd/8O0/tHt9V1zYW67bqt/c3HWPttD1uJzj559eg7oOaTnAT0P6dnemC3ajNpnl+K6FNeluC7FdSmuS3FdiutSXNywr+K6FNejuB7F9SiuR3E9iutRXI/iehTXo7gexfUprk9xfYrrU1yf4voU16e4PsVtbiabccbt+uo5oLgBxQ0obkBxA4obUNyA4gYUN6C4AcUNKW5IcUOKG1LckOKGFDekuCHFDSlu2Mb94br+0eNZ3mtzAkeYNh/XXSacpfm8Tl489XGjbcJ8T31M2++pv0jf76lvl7E/K/X/gYPmiyf+jQnyEmmPjWmxDzy+47ues3e22h9cBsL4zAQMQgYDBkMGIwaRBO0LEg2Q94blERDG59cCBiGDAYMhgxGDSIL2BbmMnm1/OYzvX3yOTRDjJaaYPxitmWPdX+J8Ncc8Qb6gQFAoaCBoKGgkKBLk9hW6ClWOq3pcFeSqIlcluarJVVGuqvJUlaeqPFXlqSpPVXmqylNVnqryVJWnqnxV5T8Yq+5xckk+MvKFCwSFggaChoJGgiJB8JEDuq5CT6HqgY/ys6oIPgqrmuCjsKoKPsqgqCr4KKyqgo/Cqir4KKyqgo/CPhir7llcklOMfOECQaGggaChoJGgSBCc4oBwSqCnUPXAKXlZFcEpYVUTnBJWVcEpGRRVBaeEVVVwSlhVBaeEVVVwSlhVhYwTcx6MVXdvxj4y8oULBIWCBoKGgkaCIkHwkQPCR4GeQtUDH+VlVQQfhVVN8FFYVQUfZVBUFXwUVlXBR2FVFXwUVlXBR2FVFXwUzXD1XhKwRWZqtcjMrBaZidUiM69aZKZVi8ysapGZVC2yCUjQTCqCZqoTVD02AYlVRTYBiVVNNgGJVVU2AWlQVJVNQGJVlU1AYlWVTUBiVZVNQGJVlU1AMufBWHV/mUvpQgibMiHsyYSwJRPCjkwIGzIh7MeEsB0TMqULQ2zHDFEkMFQ9pnRhVhWZ0oVZ1WRKF2ZVlSldeFBUlSldmFVVpnRhVlWZ0oVZVWVKF2ZVlSldWDPQlGtOQkZSyxlFLTKCWmT0tMjIaZFR0yIjpkXWOIJmiAiaISKoeqxxxKoiaxyxqskaR6yqssbRoKgqaxyxqsoaR6yqssYRq6qsccSqKmtcy5qak7vQ3Ztfk4+MsLYTh6WdEFZ2QljYCWFdJ4RlnRBWdUJmB2SIvYYh9hqGqsfsgMyqIrMDMquazA7IrKoyOyAPiqoyOyCzqsrsgMyqKrMDMquqzA7IrKoyOyCx8FG60L1IZuQjI1+4QFAoaCBoKGgkKBIEHzkgKhmBnkLVAx/lZVUEH4VVTfBRWFUFH2VQVBV8FFZVwUdhVRV8FFZVwUdhVRV8FM3dc/zS8fI/EDxBvqBAUChoIGgoaCQoEgTjODyME6hycHgXVgXh8C6sSsLhXVgVhcO7jIKqwuFdWFWFw7uwqgqHd2FVFQ7vwqoqHN6ZhXECH4xV93VxSz4y8oULBIWCBoKGgkaCIkHwkQPCR4GeQtWDBJSXVRESUFjVhAQUVlUhAWVQVBUSUFhVhQQUVlUhAYVVVUhAYVUVfBTN3cNkTMYx8oULBIWCBoKGgkaCIkEwjgPCOIGeQtUD4+RlVQTjhFVNME5YVQXjZFBUFYwTVlXBOGFVFYwTVlXBOGFVFYwTc1TV594V0285V7vbyV19WtX2X2depvge19AL9468PXx7K4jcbjC6TLr73n7QDY72o2FwfOD3R/ge1+J7endu8MFX6zb6Blw/6kXNN/52t9HI1mPfJjS/MQZdzd9WZe+x13b/B1BLAwQUAAAACABZYZZc2sMou1YBAAAGBAAAJAAAAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZVJlY29yZHMxLnhtbK2T32qDMBTG7wd7h3Du22gZYxS1jHWD3exiWx8gjbGGmT8kqdi3X4y01oqsg155ku/kl/N9wWTViArVzFiuZArxPALEJFU5l7sUNt9vsydA1hGZk0pJlsKBWVhl93eJ5rVyL4SW7JNRZXKLPEnaFErn9BJj6xVB7FxpJr1SKCOI80uzw1YbRnJbMuZEhRdR9IgF4RI6wtJcw1BFwSlbK7oXTLoOYlhFnPdhS67tkSboNThBzM9ez6gS2iO2vOLuEKCABF2+76QyZFt5/405gpvxnIJTo6wq3NyDcDfiyG384AeteRs4IKr20qWwgCwxWWJRncLHM+AsadoyaisxWIWWzde6Vc7az8q2X55OX1RxFJiTelCn7v57v++4vHfIDWp88vAaLAcPXdnrQzftasof9gHeMsPjXefffq7gNDgYvs9NMgrc/2U0zqk/379FmxEe/bnZL1BLAwQUAAAACABZYZZcCkEM6r0AAABHAQAAKQAAAHhsL3Bpdm90VGFibGVzL19yZWxzL3Bpdm90VGFibGUxLnhtbC5yZWxzhY/BCsIwDIbvgu9QcrfdPIjIOg+K4FX0AUKXbcUtLW0VfXvrbQPBY8if789X7V/jIJ4UonWsoZQFCGLjGsudhtv1tNqCiAm5wcExaXhThH29XFQXGjDlo9hbH0WmcNTQp+R3SkXT04hROk+cN60LI6Y8hk55NHfsSK2LYqPClAH1jCnOjYZwbkoQ17fPzf/Zrm2toaMzj5E4/ahQ3j5dOmB+70itZfsVyHwMHSUNUk4CP7OlzDqg6krN9OsPUEsDBBQAAAAIAFlhllw8G3H2EgoAALA4AAAeAAAAeGwvcGl2b3RUYWJsZXMvcGl2b3RUYWJsZTEueG1s7Ztvc9u4Ecbfd6bfgcP3irgLkhI9tm9ky+plJnfnXtzr9CUtQTbnKFJDUoncTr97F6BE8YGds+PEbXrnF/kDiFo9AIEfsMDu8XfbVe590FWdlcWJT28C39PFvFxkxc2J/7er2WDse3WTFos0Lwt94t/p2v/u9M9/Ol5nH8rmKr3O9VQvsyJrxIAnxor6xL9tmvXRcFjPb/Uqrd+Ua13IJ8uyWqWNFKubYb2udLqob7VuVvmQgyAertKs8FsLR6v5U4ys0urXzXowL1frtMmuszxr7qwt31vNj97eFGVl9J3422pveFvdM7zK5lVZl8vmjRgalstlNtf39FE4rPSHzPSSmKqONtnixP/X+dksPp8GajA9i6NBODqLBsksiAaTMU8uJvEoTib0b98r0pWIuOw6jH1vnkrfvBUbHEmPp+t1fvfjZnWtq1nbSSf+vvqsrBYPVM/Korn37GXaNLoq7tVP8uymWOkHvvH3bNHcfq+zm9uDNfK9Rdqk5+navNMT/5c038hb9zZrqdaLX/aDRUbGKit+1stK17emo7tPlIyZ2/LjtMry3LZkU+vJpilbYY0dW/IrVfnxL5UMrauySfO2yfMyd6uyRq8uq6xorrIm1/KYfHMuo8eRkhULaeDOiAyIOfx/Kg2yn602eZOtcz3LdL6YZbn0l/3l0+O8nMsokkFc6eWJP6GjHyPfW2ZV3XwvQ1VXP5cfrQVbZezZChHTVZyX0tqxPzxtJ4f9iVqatDG6VCK/caiX6oPIctPkmZldYt503GTXbQu9TEXv+811Y7rIfA7GvXSbiXrzt4gxvfe4zayoddWc5Wnx664Bp8emizuhLDpNhbfd/Z4tSAt2aoyEof2G/Hto0NdvXL81xWY1WzVmwlAc+t5ndJjTOnJb919vymdox5f9lLf76Ij5KkYMHuzobifjE0bdH1vXt9NDzwBGXVbN1d1a6LTQ9VwXZmsgK8R9ND2JIwIV6hNEb5t3dXN6LP96myqTRZWTML6YjuPBhEayqCpOB+PJOQ3i8CI4j8J4OppeyKLabhS2FD5vQQ+SYdJuOU6PxchRj8xLWbWm5cfiXXqtzbLU6hWB7d9W7ouC7xkv6fHX8Unw/c7ewGvn/bGG76dm4m+Mg/5mQvZ4n7Egf+lm4tML5+9L0wtsXF5kXj+813XXqBeF/bezN/h2lLzA/vIFTH47/fW/VOIgMe5PKbtz2vuS3C+ofiHsF6J+Ie4XRv2CdbP3ppN+gayTvP+IQAOBCAIVBDIIdBAIIVBCIIVAC4MWxv4ALQxaGLQwaGHQwqCFQQuDFgVaFGhR+HJAiwItCrQo0KJAiwItcvzReyshaAlBSwhaQhwpoCUELSFoCUFLCFpC0CIHcD1lEWiJQEsEWiIctqAlAi0RaIlASwRaYtAChRjcpq+8JL1O4tdJvDvye53E+6Xj/3wSyzrRWwZfV2LogWeuxLicW+Q/dn7cXv54Z2kzv/XO5ag01/aWQW4QtNz8fP4B/uNHPSoev7763sbzdRO2Z/vrJmzXE0/fhLX7rv2aIO5NvwQbQrmY6n+GjgxsCGPYEMps7X8P3tEIxu4ItIxAywi0jEDLCLSM0KsCLSPQMgItY9AyBi1j0DIGLWPQMgYtY9AyRhcPtIxBSwJaEtCSgJYEtCSgJQEtCWhJQEuC/qbjcKLHGaDLGaDPGaDTGaDXGaDbKaEMfV82QMczwE1rgKpcPxhVOZ6w4wo7vrDjDDvesOMOO/4wOsSEHjGhS0yMfYVOMaFXTOgWE/rFhI4xoWdM6BoT+saEzjGhd0wK3yD6x4QOMqGHTLi7JvSRCZ1kQi+Z0E0m9JMJHWUKcVyhq0zoKxM6y4TeMqG7TOgvEzrMhB4zoctM6DNThKMdN9yEbjMhsgkdZ0LPmZDahNimGN8ggpti5+gH5yCymxDeFOMcRHwT8psQ4IQEJ0S43IUCChDiNEIyIMYJOU4IckKSE6KckOWEMCekOSHOCXlOY+QVEp0Q6YRMJ4Q6IdUJsU7IdUKwE5KdEO2UOAd4uHlEtjOynZHtjGxnZDsj2xnZzsh2RrYzsp3xkJOR7YxsZ2Q7I9sZ2c7Idka2s3PY6Zx2usedeN7pHHg6J57Okadz5ukcejqnnsh2RrYzsp2R7YxsZ2Q7I9sZ2c7Idka2M7Kdke2MbGdkOyPbGdnOyHZGtjOynZHtjGw3wYj9E3tkOyPbGdnOyHZGtjOynZHtjGxnZDsj2xnZzsh2RrYzsp2R7RzjWTqynZHtjGxnZDsj2xnZzsh2RrYzsp2R7YxsZ2Q7I9sZ2c7Idka2M7Kdke2MbGdkOyPbGdnOyHZGtjOynZHtjGyXcCAYk8h2RrYzsp2R7YxsVwHeiCDbFbJdIdsVsl0h2xWyXSHbFbJdIdsVsl0h2xWyXSHbFbJdIdsVsl0h2xWyXSHbFbJdIdsV7tsVsl0h2xWyXSHbFbJdIduVc6Xl3Gk5l1rurRZeazn3Ws7FlnOz5ZyKO3dbyHaFbFfIdoVsV8h2hWxXyHaFbFfIdoVsV8h2hWxXyHaFbFfIdoVsV8h2hWxXyHaFbFfIdoVsV8h2hWxXyHaFbFfIdoVsx6negv7Bo9vezZoEOEuIOoZxm5PVpQl9NeHR7TDoitbDPpQstw5Fu9QcilbBoWh3nV2xnTGHolU/7MRYXW/7QduhOfCVSEZ57Lf+DOWZzJMcCHNLv/U+7IIb4StQ236hF/xtvmxCCc1Xug+vTTS5xPPjR0avFXl6LGH92I3GRNe8gd0ZDruH7PPQPHuV0f9RCRS1KjqxrRap7lrWGt1Xq/3TFgJdtek3a8R2eFcd7at3R/ytul1julCSLmTeyOtqd+ke3ruy8f66SYtGslIkScAESws1veu0bpMPbLS/KRmztoAxYKLnQZsX20aCcPVCLhPqZm9YUkp6hgXWn7Zsx+E9y5dVudjMm75RgesXGn1b3FR6kUleBtjFXniG2PYy5X32T7lBsR0rqShf1vzd/cw/zIvZ2ZR1+MlGW5wcBoYM7jaPZ5/9Yce7rfIW26XJYzAD0gYdTySXxSbc/FTkd3Yc9AMS7SS5LGubX9Umqkh+iq4kSUuD9a5W8lEOkfk29URM3rs0aqMJDqb2Ic1Gjfy/1dr9R6bwId/rfXOX67fFsuwnNtnKH+Rlb1ZJm8Qi2SVt4kybsmOqJEHGrZKn3jdVtjaJPbvsF3nKrXqX1o1Ub1YmR80ovx+0nMR8MYumNIjOJzwI54kajC9moaRmzaLzIApVMuUXCht3s+Bus4Vuk6b2KUK7YHWZ5k5q3IPJZ3o71/2kOPOmbPj5IUh+FI4msaTCDOQEZjIIg+m5BMlPosEskAM5jiiYRuGhteuF5A495ZfdtDyK2+VwN3zy9E7GpmGjWGxD5p22U+xdFCYXbLFPWqolPdAkMdnX21X+VFyV694nXROdCHvH/Ol/AFBLAwQUAAAACABZYZZc6mP+EfEDAAB1DgAADQAAAHhsL3N0eWxlcy54bWztV1uP4jYUfq/U/2BlXhtyIWEIJayWS6SVtquqM5UqlaoyiQPW2nHkmGlo1f/eYydAmGFmmCl96wvYJ/Z37p/t8YeaM/RAZEVFEVtez7UQKVKR0WIdWz/fJ/bQQpXCRYaZKEhs7UhlfZh8+824UjtG7jaEKAQQRRVbG6XKkeNU6YZwXPVESQr4kgvJsYKpXDtVKQnOKr2JM8d33YHDMS2sBmHE00tAOJZft6WdCl5iRVeUUbUzWBbi6ejTuhASrxiYWnsBTlHtDaSParlXYqRP9HCaSlGJXPUA1xF5TlPy1NzIiRycHpEA+X1IXui4/onvtXwnUuBI8kB1+qzJuNjyhKsKpWJbqNgKDiLUfPmUQY4HgYWarMxEBnHKljbnfGnvdku02Yw4H1WV5ezBTnaGpztvvru5cXuu637/608k+21pHwTP7IccdTUflv+OniAs0TMYt+cxnkI0CE4bk8k4F8UxND5kUVfC6Gsh/igS/QlCA/HSqybj6k/0gBlIXI2RCiYkUlDXEC7P2IU5aVbMMKMrSbUwx5yyXSP2tcC0QruOUyhMY1Cjofld6VX/uS6jsgKdlLGT4tCCyRj6SBFZJDBB7fh+V4KrBbR8Y7JZ98rqtcQ7zw8v31AJRjMd8vXMBFiuV7GVJIuPiyQxMKv2Ay0yUhOoXShdbU7H4EuNe6yrTWbfQorqVnF7t1EUDb3BcDiMgr4XBCaDb7HARAmivBIyA0LdN6EuqkY0GTOSK0CVdL3R/0qUWodQCkhnMs4oXosCM+3ifkc7ANiUMHanSfeX/AS7zjstCvStc637XA/BoHbY4DUTjd9Fa7C7sD7Y/HZcVOcHBc/t9o5WQQt2rTrsRrgs2U63pG62dgaetK13gtyS2WseP8L+suUrIhPDgedRDdFdGTW4KDlvNPWNmCV9EGq6hYLTp72uhEfhNAx9Zce9geHsK6Oe9xwa+qWieraMzvv9MtrjMnqtVM9H4bo6zhfuv9Rh2AL4oUNCJxR0IBOkz8XY+qI7i8EJ2/IBWm0pA549Qz+AmdVHQtM3Fpi/etbs6XzPzxfS+dmTwzEK/9d6evZfP8I6zpBupW/n5iA71BC0ckZyvGXq/vAxto7jH0hGtxzOi3bVj5rFDERsHcfNqkiTGqnV5wquV/CPtpLG1l+L6W00XyS+PXSnQzvok9COwuncDoPZdD5PItd3Z3933gjvu427+oVgnjRArF4wqhi8I2TrbGv83VEWW53JZ30pMJTsgNld2yN/4H4MPddO+q5nBwM8tIeDfmgnoefPB8F0ESZhx/bwfbZ7ruN5R+PDkaKcMFrsc7XPUFcKSYLpC05oV0wmnON7cfIPUEsDBBQAAAAIAFlhllzCh9vyUQYAANcbAAATAAAAeGwvdGhlbWUvdGhlbWUxLnhtbO1ZT2/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/AFBLAwQUAAAACABZYZZc9/F0ZhoDAAAGBwAADwAAAHhsL3dvcmtib29rLnhtbKVVa2/aMBT9Pmn/wbMqbZUGiU2gEAEVLUVD6gMN2n5EJjHEahJHtnmp6n/fdSA8yiZVXYCE62sfn3N87TQvV0mMFlxpIdMWJmUXI54GMhTprIUfR71SHSNtWBqyWKa8hddc48v21y/NpVQvEylfEACkuoUjYzLfcXQQ8YTpssx4CpmpVAkzEKqZozPFWagjzk0SO9R1a07CRIo3CL76CIacTkXAuzKYJzw1GxDFY2aAvo5Epgu0JPgIXMLUyzwrBTLJAGIiYmHWOShGSeD3Z6lUbBKD7BWpopWCbw1+xIUbLWaC1MlUiQiU1HJqygDtbEif6CeuQ8iRBatTDz6G5IEJC2HXcMdK1T7Jyhq6wQIXNktjJf83GoHSKuDoJ9GqO24Ut5tTEfOnTekilmX3LLErFWMUM21uQmF42MIXEMol3zd4GKl5djUXMWRpw6UN7LR35TxQCGANVwMlFixYw57AKBIhH4iFND3B4/BWaJM3h3zK5rEZQcUXPKCdepTWLORK+YWTA6MQ/O93b4HZkC2AJ7gRbsu4D0RIZZwGyifjV7dB6hduh5aq1S4teV6vW+p0PbfU8Op1cuHVb1zSfQMrVc0PJJubaGuBhW5hD/SepO7YqsgQ15+LcE/j1d1eJft8dytyb1aO3exPgi/13iwbotWzSEO5bOFKndZB1bqIS4RCuMyzzyI0ke1S83Ztv7iYRUCZgmXQyAIjFnzEJrm3sMEs0RY+ItjdEOzBld+OCDoHDPNTBpjmT5TmlTGUcxVw1GWGwZlmE7nxUA6+nUj1Q2J1Hg55GNyhK2aCCN1Kg66lNmikeBpq9JtnUh3AVA5g6HuYAVPAAIoKjqfdxHCA7Cau2BFOQRrqSqQ8tPUMEg6irZDxKk6T8riX16mVM2Ga2zIPWDwsdIGjULYht6c6bn8/EP/921nnjPhnnf4ZaToH8H+bazMu96z90OsNb0Y/TrF+uvC5fni8H3VOsjDP+T9ywIGcn7+jcEgI1IOkAPakfeSrRSkl+TJldj9eM3jdQK99AD2hyXalVbBg57CXO3w0yCleYe0/UEsDBBQAAAAIAFlhllzIobj6uAAAADQBAAAjAAAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDIueG1sLnJlbHOFj8EKwjAQRO+C/xD2btJ6EJGmvYjgVeoHrOm2DbZJyEbRvzfHCoK32R32zU7VvOZJPCmy9U5DKQsQ5IzvrBs0XNvTZg+CE7oOJ+9Iw5sYmnq9qi40YcpHPNrAIlMcaxhTCgel2Iw0I0sfyGWn93HGlMc4qIDmjgOpbVHsVFwyoP5iinOnIZ67EkT7Djn5P9v3vTV09OYxk0s/IlSwT59avE2UqRgHShqkXKx5oUuZfwdVV+qra/0BUEsDBBQAAAAIAFlhllySQGE+9wMAAOAOAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1spZddj6M2FIbvK/U/IC56N4BNmHw0yWo7o2hH2lVHnW177YBJrAFMjTNfVf97jw0HZzWthLOjDD5geH18/Ng+Xn94qavgiatOyGYTkigJA97kshDNYRP+/nV3tQiDTrOmYJVs+CZ85V34YfvjD+tnqR67I+c6AIWm24RHrdtVHHf5kdesi2TLG6gppaqZhlt1iLtWcVbYj+oqpklyHddMNGGvsFJTNGRZipzfyvxU80b3IopXTIP/3VG0HarV+RS5mqnHU3uVy7oFib2ohH61omFQ56u7QyMV21fQ7xcyY3nwouBH4T/FZuzzdy3VIleyk6WOQDnufX7f/WW8jFk+Kr3v/yQZMoMAPAkzgE6KXuYSyUYt6sTSC8XMyPSOmXCp1UkUm/DvZPi7gpKYS+IuWPdPuF0XAkbYfBwoXm7Cj2T18S4N4+3aAvSH4M/dmR0YHvdSPpqKO2gnAYmWNTx4fWhhVIHtMNCy/cxLfcOrCgShhyzX4onfw2ubcC+1lrWpt8RreFQq+cYb2yavOLwLzhjNb1/uRZxo91fvMDUfxqO35zZ6vrOz414FBS/ZqdI3svpTFPoI3pJoRrP5gtAsxNrf5PMnLg5H0xkazaHC0rcqXm95l8N0gF5HttVcVtAEXINamGkNNLMXWz4P8mlEFxnJro38nnd6N4QoP3UQBXRi0OpVIF5WBUpUgeZ8VQAFqwIlqpBokWWz64Xp0URfZoMKlIMKJdGcJMvUQwSas65Aia7MvEXMSmFEoBxElv5BmQ8iUA4iaeofFFiqrStQYn/m/irLQQVKN0BklvigQmAb6YkDA1UuiAsZyT1DF/ibSAlBZI3hOpPNk9TOq6kyyCw5gzY7m59TdZBa4rCdR76hRWqJw3bhP8oEuTUGTiEaeYcGySUO3esLvEF0iWN3trggwggv+R56KdJrDMTGPzYU4TXGuDa4VX0iNXRcd88gBhCnfo7w0jN4594DTZFdY4yr5XQvkFoz7YbPZxcsCBSxNYbD1nsXositMdwQe85FitgaA1UW/rFFaqmjlvrzliK2xkBvMu8NLUVsjfEd6UKK3BrDuePNfzpmDA5gmvmvMSkSbAyHjueQpwiyMdwuO00l7vMymxLeMs0wJextdtJyJyrN1VnGC2Pwn5nz8n8zZ0j/WnbgX5g6iKYLKkhoTV4InKs+d7Q2pMLWMrugTXzx7ghHNA5HkSSCcJdSgjv9zaD7wPWphSy45epBvEEqDMxKJSD7tGewTVjBYbHLoT4MjlDxJqGmum2FScnNSVOLfLwHzb69nW1ou5ZF8ck+2P7E6vbnm1/vvwS/MJ0fg89SBzey08FXxaGBdexeXcffisTj2XT7L1BLAwQUAAAACABZYZZcJPLSOXUEAADXDwAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbJ1XbZOiOBD+flX3Hyi+CwRF1BK3fBlHHbW2du/lM2JUaoBwEB3nru6/XycxItGjGKt2NrG786T76U4n9L+d40g74SwPSeLpyLB0DScB2YbJ3tN//23a6OhaTv1k60ckwZ7+iXP92+DXX/ofJHvPDxhTDRCS3NMPlKY908yDA4793CApTkCzI1nsU/iZ7c08zbC/5YviyLQtq23GfpjoAqGX1cEgu10Y4AkJjjFOqADJcORT8D8/hGku0eKgDlzsZ+/HtBGQOAWITRiF9JOD6loc9Ob7hGT+JoK4z6jlB9o5g382/DXlNlx+t1McBhnJyY4agGwKn+/D75pd0w+uSPfx14JBLSDgFLIEFlD2cy4h54plF2DNJ8FYZoRjjK6sdwy3nv7PaNTuDMfIbYxehlajNUKdRmc87jS67e5o4rgj10KTf/VBfxtChtliLcM7Tx+i3trRzUGf188fIf7Ib+Ya9Tc/cYQDimEPpGusPDeEvDPDOYgsQEz9BGvnnykk2dNbuvZ5mYI5JekS7+gYR5Gnv0DsfkDDE/4OKzx9Qygl8Y9wf6D8MFCQ7TLyN064P3xb5ifD93SAupgKjAsmbJL/xSN5QY+WiU2YE3JzsXAIzlwWwvTBfiXvSlsWKyEiWGleqbudSxqn/KR+z7Qt3vnHiP4gHzPMYgY+bcN1IIWs1nvbzwnOAzh8QKrBcQMSAQj8r8UhayJwdvyzyEK4pQdPt5FhdxzktG1A2eCcTlkGQB8ccwj6T2HFabmigPMcBcYLCnoCBQqPo8AoUSyj4zitdodFVNMXqBWOAqOMyK10HqD5AhgvCxxkoJb1FQJYC2IYMMpNbaNlO24HMRorqAPf+EoY5e721xMAjZ+jwHhB6d5sX5O57gUERsl/++v8I7iVREnBROI4T+BcS7OoTaiqgtSaUSFZnGwi/Wkajms1eW7qwsjqREV5dr9aJkgWJyqKDVlPxCTrDRVlg5y6MZmiB/AGM/GpP+hn5EODG421PeiL8D5APebqwx4Cx57ZDpkxPzTQHXJo2KeB1TdP0KyCi8Xo3gKVLcb3FnbZYnJv0SxbQINW/WiVLab3Fk7Z4vXeol22mN1buGWLObuYJBOdsm5xq+uWdW+3OqRQuCwpFfZWJaVC3LqkLDgzIdXXfLM7p3a+wfgaH1IoHtm8ANT0lpYonE9KSoVudqkXmynKaZXytaRUcjRjAbP75UG1zit0C6FrP1r3VqFbSh27K9mhWVUYr4XOFUxaRSWUUgbNp3bKxmBcsKjU5KSkVPmvUk6rlK9Vyhnz/v/4r9AthO4x/1InOV5WGK9U47UQuPzFdXs0oPvV5nnEjPndW7CtnPKxNJFeTlTBiyqYqoJXVTBTBXMhQOhRoS6EsvuwiCt0ywrdqkK3vjjDHvMVBQ0XSG2i58yY1Y9kcSEE7avgTRUsVcFKFcCHilIC4uktbsbU3+OVn+3DJNcieO+zdzTcuZl4a/M5fEPwGXtL8O8C+esAH9AYTr1lQJXtCKHyByu26yf54D9QSwECFAAUAAAACABZYZZckO8c1poBAABtBwAAEwAAAAAAAAAAACAAtoEAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQIUABQAAAAIAFlhlly1VTAj7gAAAEwCAAALAAAAAAAAAAAAIAC2gcsBAABfcmVscy8ucmVsc1BLAQIUABQAAAAIAFlhllyKtF2BqAEAAG4DAAAQAAAAAAAAAAAAIAC2geICAABkb2NQcm9wcy9hcHAueG1sUEsBAhQAFAAAAAgAWWGWXD0eC005AQAAUQIAABEAAAAAAAAAAAAgALaBuAQAAGRvY1Byb3BzL2NvcmUueG1sUEsBAhQAFAAAAAgAWWGWXE1B1tIaAQAAewQAABoAAAAAAAAAAAAgALaBIAYAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzUEsBAhQAFAAAAAgAWWGWXOIrf3u7AAAAMwEAADIAAAAAAAAAAAAgALaBcgcAAHhsL3Bpdm90Q2FjaGUvX3JlbHMvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbC5yZWxzUEsBAhQAFAAAAAgAWWGWXOp8zQoaCgAAxDgAACcAAAAAAAAAAAAgALaBfQgAAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbFBLAQIUABQAAAAIAFlhllzawyi7VgEAAAYEAAAkAAAAAAAAAAAAIAC2gdwSAAB4bC9waXZvdENhY2hlL3Bpdm90Q2FjaGVSZWNvcmRzMS54bWxQSwECFAAUAAAACABZYZZcCkEM6r0AAABHAQAAKQAAAAAAAAAAACAAtoF0FAAAeGwvcGl2b3RUYWJsZXMvX3JlbHMvcGl2b3RUYWJsZTEueG1sLnJlbHNQSwECFAAUAAAACABZYZZcPBtx9hIKAACwOAAAHgAAAAAAAAAAACAAtoF4FQAAeGwvcGl2b3RUYWJsZXMvcGl2b3RUYWJsZTEueG1sUEsBAhQAFAAAAAgAWWGWXOpj/hHxAwAAdQ4AAA0AAAAAAAAAAAAgALaBxh8AAHhsL3N0eWxlcy54bWxQSwECFAAUAAAACABZYZZcwofb8lEGAADXGwAAEwAAAAAAAAAAACAAtoHiIwAAeGwvdGhlbWUvdGhlbWUxLnhtbFBLAQIUABQAAAAIAFlhllz38XRmGgMAAAYHAAAPAAAAAAAAAAAAIAC2gWQqAAB4bC93b3JrYm9vay54bWxQSwECFAAUAAAACABZYZZcyKG4+rgAAAA0AQAAIwAAAAAAAAAAACAAtoGrLQAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDIueG1sLnJlbHNQSwECFAAUAAAACABZYZZckkBhPvcDAADgDgAAGAAAAAAAAAAAACAAtoGkLgAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sUEsBAhQAFAAAAAgAWWGWXCTy0jl1BAAA1w8AABgAAAAAAAAAAAAgALaB0TIAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbFBLBQYAAAAAEAAQAH8EAAB8NwAAAAA= xl/worksheets/sheet1.xml xl/worksheets/sheet3.xml 1 0 Batch Completion Date 1 Batch No 2 Type 3 Item 4 Item Desc 5 Lot Number 6 Lot Source 7 Lot Cost 8 Lot Quantity 9 Lot Extended Cost 10 Product Cost 11 Ingredient Cost 12 Batch Size 13 Batch Yield 14 1-Jan 15 Product 16 NA 17 (blank) 18 Ingredient 19 1 Total data A1 1 data AA1 1 data AB1 1 data AC1 1 data AD1 1 data AE1 1 data AF1 1 data AG1 1 data AH1 1 data AI1 1 data B1 1 data C1 1 data D 2 data D1 1 data E1 1 data F1 1 data G1 1 data H1 1 data I 3 data I1 1 data J 3 data J1 1 data K 4 data K1 1 data L 3 data L1 1 data M 3 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 U 3 data U1 1 data V 3 data V1 1 data W 3 data W1 1 data X1 1 data Y1 1 data Z1 1 parameter A1 1 parameter A10 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 A9 1 parameter B3 2 S Site Summary SYSADMIN 7 BATCH_ACTUAL_OUTPUT SUM 8 BATCH_COST SUM 4 BATCH_NO 3 -4.0008 BATCH_PACK_COUNT SUM 5 BATCH_SIZE SUM 6 BATCH_UNIT_COST SUM 9 BATCH_YIELD SUM -4.0005 DOSAGE_FORM -10.0012 EXCIPIENT_COST SUM -9.001 FINAL_NUMBER_OF_UNITS -7.0008 FINAL_PACK_COUNT 10 INGREDIENT_COST SUM 3 ORGANIZATION 2 -10.0013 PACKING_MATERIAL_COST SUM -4.0007 PACK_STYLE 1 PRODUCT 1 2 PRODUCT_DESC -10.0011 RAW_MATERIAL_COST SUM -4.0006 STRENGTH -10.0014 TOTAL_MATERIAL_COST SUM S Site Detail Pivot