ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2B13869E053B46B63588994Y with projects as ( select pi.project_id, haouv.name operating_unit, pi.organization_name project_organization, pi.manager_name project_manager, pi.project_type, pi.project_name, pi.project_number, iv.total_invoiced_amount, iv.total_revenue_amount, p.project_currency_code, p.projfunc_currency_code, iv.pfc_total_invoice_amount, iv.unbilled_retention, nvl(p.retn_accounting_flag,'N') retn_accounting_flag, xxen_util.meaning(pt.burden_cost_flag,'YES_NO',0) costs_burdened, pa_paxbubss_xmlp_pkg.unearned_revformula(nvl(p.retn_accounting_flag,'N'),iv.pfc_total_invoice_amount,iv.unbilled_retention,iv.total_revenue_amount) unearned_rev, pa_paxbubss_xmlp_pkg.accounts_receivableformula(pi.project_id) accounts_receivable, pa_paxbubss_xmlp_pkg.unbilled_recformula(nvl(p.retn_accounting_flag,'N'),iv.total_revenue_amount,iv.pfc_total_invoice_amount,iv.unbilled_retention) unbilled_rec, pa_paxbubss_xmlp_pkg.unbilled_retnformula(nvl(p.retn_accounting_flag,'N'),iv.unbilled_retention) unbilled_retn from pa_proj_info_view pi, pa_projects p, pa_project_types pt, pa_proj_invoice_summary_view iv, hr_all_organization_units_vl haouv where 1=1 and p.template_flag !='Y' and p.project_type = pt.project_type and p.project_id = pi.project_id and p.project_id = iv.project_id (+) and pi.org_id = haouv.organization_id and haouv.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and p.project_id in (select p.project_id from pa_projects p, pa_project_status_controls s where p.project_status_code = s.project_status_code and s.status_type = 'PROJECT' and s.action_code = 'STATUS_REPORTING' and s.enabled_flag='Y' ) ), tasks as ( select pt.project_id, pt.task_id, pt.parent_task_id, pt.wbs_level, pt.task_number, pt.task_name, substr(haout.name,1,60) task_organization, decode(pt.task_manager_person_id,ppx.person_id,ppx.full_name,null,'No Task Manager') task_manager, xxen_util.meaning(decode(pt.wbs_level,1,'Y'),'YES_NO',0) top_level_task, 'Task' report_level from pa_tasks pt, per_people_x ppx, hr_all_organization_units_tl haout where 2=2 and nvl(:p_report_level,'T') = 'T' and pt.task_manager_person_id = ppx.person_id (+) and ppx.employee_number (+) is not null and pt.carrying_out_organization_id = haout.organization_id (+) and haout.language (+) = userenv('lang') union select p.project_id, 0 task_id, null parent_task_id, null wbs_level, null task_number, null task_name, null task_organization, null task_manager, null top_level_task, 'Project' report_level from pa_projects p where nvl(:p_report_level,'T') = 'P' ), resource_list as ( select distinct ppah.project_id, ppah.task_id, pbt.budget_amount_code, prlm.resource_list_member_id, prlm.member_level, prlm.alias, pbt.budget_type_code, prla.resource_list_id, decode(prlm.parent_member_id, null, prlm.sort_order, prlm2.sort_order) parent_sort_order, decode(prlm.parent_member_id, null, 0, prlm.sort_order) sort_order, case when pbt.budget_type_code = :c_rev_bgt_code then 'Y' else 'N' end rev_rsc, case when pbt.budget_type_code = :c_cost_bgt_code then 'Y' else 'N' end cost_rsc, xxen_util.meaning(decode(prlm.parent_member_id,null,'Y'),'YES_NO',0) top_level_resource from pa_project_accum_headers ppah, pa_resource_list_assignments prla, pa_resource_list_uses prlu, pa_budget_types pbt, pa_resource_list_members prlm, pa_resource_list_members prlm2 where ppah.project_id = prla.project_id and prla.resource_list_assignment_id = prlu.resource_list_assignment_id and prlu.use_code = pbt.budget_type_code and prla.resource_list_id = prlm.resource_list_id and nvl(prlm.parent_member_id, prlm.resource_list_member_id) = prlm2.resource_list_member_id and pbt.budget_type_code in (:c_rev_bgt_code,:c_cost_bgt_code) and (ppah.resource_list_member_id = prlm.resource_list_member_id or exists (select 'x' from pa_resource_list_members prlm3 where prlm.resource_list_member_id = prlm3.parent_member_id and prlm3.resource_list_member_id = ppah.resource_list_member_id ) ) ), actuals as ( select parav.project_id, parav.task_id, parav.resource_list_member_id, nvl(parav.revenue_itd,0) actual_rev, pa_paxmgtsd_xmlp_pkg.c_act_per_revformula(parav.resource_list_member_id, decode(parav.task_id,0,to_number(null),parav.task_id),:period_name,parav.project_id) actual_rev_prd, nvl(parav.burdened_cost_itd,0) actual_cst, pa_paxmgtsd_xmlp_pkg.c_act_per_costformula(parav.resource_list_member_id,decode(parav.task_id,0,to_number(null),parav.task_id),:period_name,parav.project_id) actual_cst_prd, -- parav.raw_cost_itd, parav.raw_cost_ytd, parav.raw_cost_pp, parav.raw_cost_ptd, parav.billable_raw_cost_itd, parav.billable_raw_cost_ytd, parav.billable_raw_cost_pp, parav.billable_raw_cost_ptd, parav.burdened_cost_itd, parav.burdened_cost_ytd, parav.burdened_cost_pp, parav.burdened_cost_ptd, parav.billable_burdened_cost_itd, parav.billable_burdened_cost_ytd, parav.billable_burdened_cost_pp, parav.billable_burdened_cost_ptd, parav.actuals_quantity_itd, parav.actuals_quantity_ytd, parav.actuals_quantity_pp, parav.actuals_quantity_ptd, parav.billable_quantity_itd, parav.billable_quantity_ytd, parav.billable_quantity_pp, parav.billable_quantity_ptd, parav.actuals_labor_hours_itd, parav.actuals_labor_hours_ytd, parav.actuals_labor_hours_pp, parav.actuals_labor_hours_ptd, parav.billable_labor_hours_itd, parav.billable_labor_hours_ytd, parav.billable_labor_hours_pp, parav.billable_labor_hours_ptd, parav.revenue_itd, parav.revenue_ytd, parav.revenue_pp, parav.revenue_ptd from pa_accum_rsrc_act_v parav ), commitments as ( select parcv.project_id, parcv.task_id, parcv.resource_list_member_id, -- parcv.cmt_raw_cost_itd, parcv.cmt_raw_cost_ytd, parcv.cmt_raw_cost_pp, parcv.cmt_raw_cost_ptd, parcv.cmt_burdened_cost_itd, parcv.cmt_burdened_cost_ytd, parcv.cmt_burdened_cost_pp, parcv.cmt_burdened_cost_ptd, parcv.cmt_quantity_itd, parcv.cmt_quantity_ytd, parcv.cmt_quantity_pp, parcv.cmt_quantity_ptd from pa_accum_rsrc_cmt_v parcv ), budget_costs as ( select parcbv.project_id, parcbv.task_id, parcbv.resource_list_member_id, parcbv.budget_type_code, nvl(parcbv.baseline_burdened_cost_tot,0) budget_cst, -- parcbv.baseline_raw_cost_itd, parcbv.baseline_raw_cost_ytd, parcbv.baseline_raw_cost_pp, parcbv.baseline_raw_cost_ptd, parcbv.baseline_burdened_cost_itd, parcbv.baseline_burdened_cost_ytd, parcbv.baseline_burdened_cost_pp, parcbv.baseline_burdened_cost_ptd, parcbv.original_raw_cost_itd, parcbv.original_raw_cost_ytd, parcbv.original_raw_cost_pp, parcbv.original_raw_cost_ptd, parcbv.original_burdened_cost_itd, parcbv.original_burdened_cost_ytd, parcbv.original_burdened_cost_pp, parcbv.original_burdened_cost_ptd, parcbv.baseline_quantity_itd, parcbv.baseline_quantity_ytd, parcbv.baseline_quantity_pp, parcbv.baseline_quantity_ptd, parcbv.original_quantity_itd, parcbv.original_quantity_ytd, parcbv.original_quantity_pp, parcbv.original_quantity_ptd, parcbv.original_labor_hours_itd, parcbv.original_labor_hours_ytd, parcbv.original_labor_hours_pp, parcbv.original_labor_hours_ptd, parcbv.baseline_labor_hours_itd, parcbv.baseline_labor_hours_ytd, parcbv.baseline_labor_hours_pp, parcbv.baseline_labor_hours_ptd, parcbv.baseline_raw_cost_tot, parcbv.baseline_burdened_cost_tot, parcbv.original_raw_cost_tot, parcbv.original_burdened_cost_tot, parcbv.original_labor_hours_tot, parcbv.baseline_labor_hours_tot, parcbv.baseline_quantity_tot, parcbv.original_quantity_tot from pa_accum_rsrc_cost_bgt_v parcbv where parcbv.budget_type_code = :c_cost_bgt_code ), budget_revenues as ( select parrbv.project_id, parrbv.task_id, parrbv.resource_list_member_id, parrbv.budget_type_code, nvl(parrbv.baseline_revenue_tot,0) budget_rev, -- parrbv.baseline_revenue_itd, parrbv.baseline_revenue_ytd, parrbv.baseline_revenue_pp, parrbv.baseline_revenue_ptd, parrbv.original_revenue_itd, parrbv.original_revenue_ytd, parrbv.original_revenue_pp, parrbv.original_revenue_ptd, parrbv.baseline_quantity_itd, parrbv.baseline_quantity_ytd, parrbv.baseline_quantity_pp, parrbv.baseline_quantity_ptd, parrbv.original_quantity_itd, parrbv.original_quantity_ytd, parrbv.original_quantity_pp, parrbv.original_quantity_ptd, parrbv.original_labor_hours_itd, parrbv.original_labor_hours_ytd, parrbv.original_labor_hours_pp, parrbv.original_labor_hours_ptd, parrbv.baseline_labor_hours_itd, parrbv.baseline_labor_hours_ytd, parrbv.baseline_labor_hours_pp, parrbv.baseline_labor_hours_ptd, parrbv.baseline_revenue_tot, parrbv.original_revenue_tot, parrbv.original_labor_hours_tot, parrbv.baseline_labor_hours_tot, parrbv.baseline_quantity_tot, parrbv.original_quantity_tot from pa_accum_rsrc_rev_bgt_v parrbv where parrbv.budget_type_code = :c_rev_bgt_code ) -- -- Main Query -- select x.* from ( select /*+ ordered push_pred(t) push_pred(rl) push_pred(a) push_pred(c) push_pred(bc) push_pred(br) */ distinct p.operating_unit, p.project_organization, p.project_manager, p.project_type, p.project_number, p.project_name, p.projfunc_currency_code functional_currency, p.pfc_total_invoice_amount total_invoiced_amount, p.accounts_receivable accounts_receivable, p.unbilled_rec unbilled_receivable, p.unearned_rev unearned_revenue, p.unbilled_retn unbilled_retention, p.costs_burdened, t.report_level, t.wbs_level task_level, t.task_number, t.task_name, t.top_level_task, t.task_organization, t.task_manager, -- resource_list rl.member_level resource_level, rl.alias resource_name, rl.top_level_resource, -- actuals br.budget_rev budget_revenue, ar.actual_rev actual_revenue, ar.actual_rev_prd period_actual_revenue, -- bc.budget_cst budget_burdened_cost, ac.actual_cst actual_burdened_cost, ac.actual_cst_prd period_actual_burdened_cost, -- -- The following column list is from the Project Status Inquiry Form -- decode((sign((nvl(bc.baseline_burdened_cost_itd,0) * 1.1) - (nvl(ac.burdened_cost_itd,0) + nvl(c.cmt_burdened_cost_ptd,0)))), -1, xxen_util.meaning('Y','YES_NO',0), null) ovr_bgt, round(nvl(br.baseline_revenue_itd,0)) itd_rev_bgt, round(nvl(ar.revenue_itd,0)) itd_act_rev, round(nvl(bc.baseline_burdened_cost_itd,0)) itd_cst_bgt, round(nvl(ac.burdened_cost_itd,0)) itd_act_cost, round(nvl(c.cmt_burdened_cost_ptd,0)) commit_amt, round(nvl(bc.baseline_labor_hours_itd,0)) itd_bgt_hrs, round(nvl(ac.actuals_labor_hours_itd,0)) itd_act_hrs, -- round(nvl(bc.baseline_burdened_cost_ptd,0)) ptd_cst_bgt, round(nvl(ac.burdened_cost_ptd,0)) ptd_act_cost, round(nvl(bc.baseline_labor_hours_ptd,0)) ptd_bgt_hrs, round(nvl(ac.actuals_labor_hours_ptd,0)) ptd_act_hrs, -- round(nvl(br.baseline_revenue_tot,0)) tot_rev_bgt, round(nvl(bc.baseline_burdened_cost_tot,0)) tot_cst_bgt, round(nvl(bc.baseline_labor_hours_tot,0)) tot_bgt_hrs, -- round(decode(bc.baseline_burdened_cost_tot, 0, 0, (ac.burdened_cost_itd/bc.baseline_burdened_cost_tot) * 100)) fin_pct_cmplt, round(decode(bc.baseline_labor_hours_tot,0,0, (ac.actuals_labor_hours_itd/bc.baseline_labor_hours_tot) * 100)) hrs_pct_cmplt, round(nvl(bc.baseline_burdened_cost_tot,0) - nvl(c.cmt_burdened_cost_ptd,0) - nvl(ac.burdened_cost_itd,0)) est_to_cmplt, round(nvl(ac.burdened_cost_itd,0) + nvl(c.cmt_burdened_cost_ptd,0)) tot_cst_itd, round(nvl(br.baseline_revenue_tot,0) - nvl(bc.baseline_burdened_cost_tot,0)) bgt_mgn, round(nvl(ar.revenue_itd,0) - nvl(ac.burdened_cost_itd,0)) act_mgn_itd, -- round(nvl(br.original_revenue_itd,0)) itd_orig_rev_bgt, round(nvl(br.original_revenue_tot,0)) tot_orig_rev_bgt, round(nvl(bc.original_burdened_cost_itd,0)) itd_orig_cst_bgt, round(nvl(bc.original_burdened_cost_tot,0)) tot_orig_cst_bgt, round(nvl(bc.original_labor_hours_tot,0)) tot_orig_bgt_hrs, -- :period_name period, t.project_id, t.task_id, t.parent_task_id, rl.resource_list_member_id, rl.parent_sort_order resource_parent_sort_order, rl.sort_order resource_sort_order, first_value(nvl2(coalesce(ar.project_id,ac.project_id,br.project_id,bc.project_id),'N','Y')) over (partition by p.project_id order by nvl2(coalesce(ar.project_id,ac.project_id,br.project_id,bc.project_id),'N','Y') rows between unbounded preceding and unbounded following ) exclude_project from projects p, tasks t, resource_list rl, actuals ar, actuals ac, commitments c, budget_revenues br, budget_costs bc where p.project_id = t.project_id and -- t.project_id = rl.project_id (+) and t.task_id = rl.task_id (+) and -- case when rl.rev_rsc = 'Y' then rl.project_id else null end = ar.project_id (+) and case when rl.rev_rsc = 'Y' then rl.task_id else null end = ar.task_id (+) and case when rl.rev_rsc = 'Y' then rl.resource_list_member_id else null end = ar.resource_list_member_id (+) and -- case when rl.cost_rsc = 'Y' then rl.project_id else null end = ac.project_id (+) and case when rl.cost_rsc = 'Y' then rl.task_id else null end = ac.task_id (+) and case when rl.cost_rsc = 'Y' then rl.resource_list_member_id else null end = ac.resource_list_member_id (+) and -- case when rl.cost_rsc = 'Y' then rl.project_id else null end = c.project_id (+) and case when rl.cost_rsc = 'Y' then rl.task_id else null end = c.task_id (+) and case when rl.cost_rsc = 'Y' then rl.resource_list_member_id else null end = c.resource_list_member_id (+) and -- rl.project_id = br.project_id (+) and rl.task_id = br.task_id (+) and rl.resource_list_member_id = br.resource_list_member_id (+) and -- rl.project_id = bc.project_id (+) and rl.task_id = bc.task_id (+) and rl.resource_list_member_id = bc.resource_list_member_id (+) ) x where x.exclude_project = 'N' order by operating_unit, task_organization, task_manager, project_number, decode(report_level,'Task',1,2), task_number, resource_parent_sort_order, resource_sort_order, resource_name PA PAXMGTSD_XML AR PA المهمة - الإيرادات والتكلفة والموازنات حسب الموارد (بتنسيق XML) Application: المشروعات Source: MGT: المهمة - الإيرادات والتكلفة والموازنات حسب الموارد (بتنسيق XML) Short Name: PAXMGTSD_XML DB package: PA_PAXMGTSD_XMLP_PKG D PA Teilprojekt - Umsatz, Kosten, Budgets nach Ressourcen Application: Projects Source: PA: Teilprojekt - Umsatz, Kosten, Budgets nach Ressourcen (XML) Short Name: PAXMGTSD_XML DB package: PA_PAXMGTSD_XMLP_PKG F PA Produit, coût et budgets par tâche et par ressource Application: Projects Source: MGT : Produit, coût et budgets par tâche et par ressource (XML) Short Name: PAXMGTSD_XML DB package: PA_PAXMGTSD_XMLP_PKG US PA Revenue, Cost, Budgets by Resources This Blitz Report is the implements the following standard oracle reports. - MGT: Task - Revenue, Cost, Budgets by Resources - MGT: Revenue, Cost, Budgets by Resources (Project Level) The 'Report Level' parameter determines if the report is run at the Project Level or Task Level Report Level Parameter: Project - equivalent to running the MGT: Revenue, Cost, Budgets by Resources (Project Level) report Task - equivalent to running the MGT: Task - Revenue, Cost, Budgets by Resources report The report has been extended to pull in additional datapoints as displayed in the Project Status Inquiry Form. Application: Projects Source: MGT: Task - Revenue, Cost, Budgets by Resources (XML) Short Name: PAXMGTSD_XML DB package: PA_PAXMGTSD_XMLP_PKG ZHS PA MGT：任务 - 按资源列出的收入、成本和预算 Application: 项目 Source: MGT：任务 - 按资源列出的收入、成本和预算 (XML) Short Name: PAXMGTSD_XML DB package: PA_PAXMGTSD_XMLP_PKG Enginatics R12 only 1=1 2=2 :c_company_name_header :c_cost_bgt_code :c_cost_bgt_name :c_end_date :c_mgr :c_no_data_found :c_org :c_proj_name :c_proj_num :c_rev_bgt_code :c_rev_bgt_name :c_start_date :c_sum_rpt_totals :c_task_name :c_task_num :cost_bgt_code :operating_unit :p_conc_request_id :p_debug_mode :p_report_level :p_rule_optimizer :pa_period :period_name :proj :rev_bgt_code :task :task_mgr :task_org 1 -20 1=1 exists (select null from pa_tasks pt where pt.project_id = p.project_id and pt.carrying_out_organization_id =:task_org) LOV Oracle PA_SRS_PROJECT_ORGANIZATION Y Y select organization_id id, name value, null description from pa_organizations_project_v where active_flag='Y' order by value,description AR تنظيم المهمة D Teilprojektorganisation F Organisation des tâches US Task Organization ZHS 任务组织 2 2=2 pt.carrying_out_organization_id =:task_org US Task Organization 3 -10 1=1 exists (select null from pa_tasks pt where pt.project_id = p.project_id and pt.task_manager_person_id=:task_mgr) LOV Oracle PA_SRS_EMPLOYEE_LOV Y Y select person_id id, full_name value, employee_number description from pa_employees order by full_name AR مدير المهمة D Teilprojektmanager F Gestionnaire des tâches US Task Manager ZHS 任务经理 4 2=2 pt.task_manager_person_id=:task_mgr US Task Manager 5 10 1=1 haouv.name=:operating_unit LOV custom Y select hou.name value, null description from hr_operating_units hou, pa_implementations pi where hou.organization_id = pi.org_id and sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 6 20 1=1 p.carrying_out_organization_id = :org LOV Oracle PA_SRS_PROJECT_ORGANIZATION Y Y select organization_id id, name value, null description from pa_organizations_project_v where active_flag='Y' order by value,description US Project Organization 7 30 1=1 pi.manager_person_id = :mgr LOV Oracle PA_SRS_PROJECT_MANAGERS Y select person_id id, full_name value, employee_number description from pa_project_managers_v order by value,description US Project Manager 8 40 1=1 p.project_id=:proj LOV custom Y Y select ppbv.project_id id, ppbv.project_number value, ppbv.project_name description from pa_projects_basic_v ppbv where ppbv.template_flag!='Y' and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,ppbv.operating_unit) = 'Y' ) order by ppbv.project_number_sort_order AR رقم المشروع D Projektnummer F Numéro de projet US Project Number ZHS 项目编号 9 2=2 pt.project_id=:proj US Project Number 10 45 1=1 pi.project_id=:proj_name_id LOV custom Y Y select ppbv.project_id id, ppbv.project_name value, ppbv.project_number description from pa_projects_basic_v ppbv where ppbv.template_flag!='Y' and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,ppbv.operating_unit) = 'Y' ) order by ppbv.project_name US Project Name 11 2=2 pt.project_id=:proj_name_id US Project Name 12 50 1=1 exists (select null from pa_tasks pt where pt.project_id = p.project_id and pt.task_number = :task_number) LOV custom Y select ptav.task_number value, ptav.task_name description from pa_tasks_all_v ptav where ( xxen_util.contains(:$flex$.project_number,ptav.project_id) = 'Y' or xxen_util.contains(:$flex$.project_name,ptav.project_id) = 'Y' ) order by ptav.task_number AR رقم المهمة D Teilprojektnummer F Numéro de tâche US Task Number ZHS 任务编号 13 2=2 pt.task_number=:task_number US Task Number 14 75 :p_report_level LOV custom Y select x.id, x.value, null description from (select 'P' id, 'Project' value from dual where :$flex$.task_number is null union select 'T' id, 'Task' value from dual ) x order by value T Y US Report Level 15 80 :cost_bgt_code LOV Oracle PA_SRS_BUDGET_TYPE_COST Y select budget_type_code id, budget_type value, description description from pa_budget_types where budget_amount_code='C' order by budget_type select budget_type_code from pa_budget_types where budget_amount_code = 'C' and predefined_flag = 'Y' and budget_type_code = 'AC' Y AR نوع موازنة التكلفة D Kostenbudgetart F Type de coûts budgétés US Cost Budget Type ZHS 成本预算类型 16 90 :rev_bgt_code LOV Oracle PA_SRS_BUDGET_TYPE_REV Y select budget_type_code id, budget_type value, description description from pa_budget_types where budget_amount_code='R' order by budget_type select budget_type_code from pa_budget_types where budget_amount_code = 'R' and predefined_flag = 'Y' and budget_type_code = 'AR' Y AR نوع موازنة الإيرادات D Umsatzbudgetart F Type de produit budgété US Revenue Budget Type ZHS 收入预算类型 17 100 :pa_period LOV Oracle PA_SRS_PERIODS Y select period_name id, period_name value, null description from pa_periods order by start_date desc AR اسم الفترة D Periodenbezeichnung F Nom de la période US Period Name ZHS 期间名称 :$flex$.operating_unit Operating Unit Project Name :$flex$.operating_unit Operating Unit Project Number :$flex$.project_name Project Name Task Number :$flex$.project_number Project Number Task Number :$flex$.task_number Task Number Report Level 5936A33385A68931168ABA7A54B84ED8 Default Y Default Detailed Data Extract SYSADMIN 9 ACCOUNTS_RECEIVABLE 28 ACTUAL_BURDENED_COST 25 ACTUAL_REVENUE 50 ACT_MGN_ITD 49 BGT_MGN 27 BUDGET_BURDENED_COST 24 BUDGET_REVENUE 35 COMMIT_AMT 13 COSTS_BURDENED 47 EST_TO_CMPLT EXCLUDE_PROJECT 45 FIN_PCT_CMPLT 7 FUNCTIONAL_CURRENCY 46 HRS_PCT_CMPLT 34 ITD_ACT_COST 37 ITD_ACT_HRS 32 ITD_ACT_REV 36 ITD_BGT_HRS 33 ITD_CST_BGT 53 ITD_ORIG_CST_BGT 51 ITD_ORIG_REV_BGT 31 ITD_REV_BGT 1 OPERATING_UNIT 30 OVR_BGT 59 PARENT_TASK_ID 56 PERIOD 29 PERIOD_ACTUAL_BURDENED_COST 26 PERIOD_ACTUAL_REVENUE 57 PROJECT_ID 3 PROJECT_MANAGER 6 PROJECT_NAME 5 PROJECT_NUMBER 2 PROJECT_ORGANIZATION 4 PROJECT_TYPE 39 PTD_ACT_COST 41 PTD_ACT_HRS 40 PTD_BGT_HRS 38 PTD_CST_BGT 14 REPORT_LEVEL 21 RESOURCE_LEVEL 60 RESOURCE_LIST_MEMBER_ID -56.0057 RESOURCE_MEMBER_LEVEL 22 RESOURCE_NAME 61 RESOURCE_PARENT_SORT_ORDER 62 RESOURCE_SORT_ORDER 58 TASK_ID 15 TASK_LEVEL 20 TASK_MANAGER 17 TASK_NAME 16 TASK_NUMBER 19 TASK_ORGANIZATION 23 TOP_LEVEL_RESOURCE 18 TOP_LEVEL_TASK 8 TOTAL_INVOICED_AMOUNT 44 TOT_BGT_HRS 43 TOT_CST_BGT 48 TOT_CST_ITD 55 TOT_ORIG_BGT_HRS 54 TOT_ORIG_CST_BGT 52 TOT_ORIG_REV_BGT 42 TOT_REV_BGT 10 UNBILLED_RECEIVABLE 12 UNBILLED_RETENTION 11 UNEARNED_REVENUE US S Site AC005881057FC68668D8748208C41CE4 Pivot Summary SYSADMIN 9 ACCOUNTS_RECEIVABLE 28 ACTUAL_BURDENED_COST 25 ACTUAL_REVENUE 50 ACT_MGN_ITD 49 BGT_MGN 27 BUDGET_BURDENED_COST 24 BUDGET_REVENUE 35 COMMIT_AMT 13 COSTS_BURDENED 47 EST_TO_CMPLT 45 FIN_PCT_CMPLT 7 FUNCTIONAL_CURRENCY 46 HRS_PCT_CMPLT 34 ITD_ACT_COST 37 ITD_ACT_HRS 32 ITD_ACT_REV 36 ITD_BGT_HRS 33 ITD_CST_BGT 53 ITD_ORIG_CST_BGT 51 ITD_ORIG_REV_BGT 31 ITD_REV_BGT 1 OPERATING_UNIT 30 OVR_BGT 59 PARENT_TASK_ID 56 PERIOD 29 PERIOD_ACTUAL_BURDENED_COST 26 PERIOD_ACTUAL_REVENUE 57 PROJECT_ID 3 PROJECT_MANAGER 6 PROJECT_NAME 5 PROJECT_NUMBER 2 PROJECT_ORGANIZATION 4 PROJECT_TYPE 39 PTD_ACT_COST 41 PTD_ACT_HRS 40 PTD_BGT_HRS 38 PTD_CST_BGT 14 REPORT_LEVEL 21 RESOURCE_LEVEL 60 RESOURCE_LIST_MEMBER_ID -58.0059 RESOURCE_MEMBER_LEVEL 22 RESOURCE_NAME 61 RESOURCE_PARENT_SORT_ORDER 62 RESOURCE_SORT_ORDER 58 TASK_ID 15 TASK_LEVEL 20 TASK_MANAGER 17 TASK_NAME 16 TASK_NUMBER 19 TASK_ORGANIZATION 23 TOP_LEVEL_RESOURCE 18 TOP_LEVEL_TASK 8 TOTAL_INVOICED_AMOUNT 44 TOT_BGT_HRS 43 TOT_CST_BGT 48 TOT_CST_ITD 55 TOT_ORIG_BGT_HRS 54 TOT_ORIG_CST_BGT 52 TOT_ORIG_REV_BGT 42 TOT_REV_BGT 10 UNBILLED_RECEIVABLE 12 UNBILLED_RETENTION 11 UNEARNED_REVENUE PA Revenue, Cost, Budgets by Resources - Pivot Summary 04-Apr-2025 010314.xlsx US UEsDBBQAAAAIAOuZ4VyQ7xzWmgEAAG0HAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbM2V30/CMBDH3038H5a+mq2AiTGGwQPqoxLFP6CsB2vY2qZXEP57bx34g0yQgNGXtVt79/20d7vr9pdlES3AoTI6Ze2kxSLQmZFKT1P2MrqPr1mEXmgpCqMhZStA1u+dn3VHKwsYkbXGlOXe2xvOMcuhFJgYC5pWJsaVwtOrm3IrspmYAu+0Wlc8M9qD9rGvfLBe9xYmYl746G5Jn2sSBwWyaFBvrLRSJqwtVCY8rfOFllsq8VohIcuwB3Nl8YIwGG9UqFa+F1jbPdLVOCUhGgrnH0RJGHxZ8FfjZmNjZsluJw2UZjJRGUiTzUs6WILWgZCYA/iySMKYlELpDfcO/bAZeRjaJwapzhccH8jR+Sccl3/EYdXC+IGg34B/TCm7lVZVSp46TE0aeyLWSPgEmXESfw9vLbCHzVP1AB6ex6MEN3sE0a8KwBPnSu10n3IuHMhn76jOnhzgs++fpMNIjIm4ztgwP/72v9a1D8+7cKgoDp2xSO3BweFB2dT/yjq25AicV7sD8a5IreVwwa1SDlXzkiAbtHlolr03UEsDBBQAAAAIAOuZ4Vy1VTAj7gAAAEwCAAALAAAAX3JlbHMvLnJlbHONks9OwzAMxu9IvEPk++puSAihpbtMSLshVB7AJO4ftY2jJED39oQDgkpj29H2588/W97u5mlUHxxiL07DuihBsTNie9dqeK2fVg+gYiJnaRTHGo4cYVfd3mxfeKSUm2LX+6iyi4saupT8I2I0HU8UC/HscqWRMFHKYWjRkxmoZdyU5T2Gvx5QLTzVwWoIB3sHqj76PPmytzRNb3gv5n1il06MQJ4TO8t25UNmC6nP26iaQstJgxXznNMRyfsiYwOeJtpcT/T/tjhxIkuJ0Ejg8zzfinNA6+uBLp9oqfi9zjzip4ThTWT4YcHFD1RfUEsDBBQAAAAIAOuZ4Vz9Y5cYqwEAAHADAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJ2TwW7bMAyG7wP6DoLObew2QzEEsoo23dDDhgWL251ZmY6FypIh0Ua8p59sI4mz9rQbyZ+iPoqUuNvXhnXog3Y249eLlDO0yhXa7jL+nH+7+sJZILAFGGcx4z0GficvPomNdw160hhYLGFDxiuiZpUkQVVYQ1hE2UaldL4Giq7fJa4stcJHp9oaLSU3aXqb4J7QFlhcNceCfKq46uh/ixZODXzhJe+bCCxF7ghMrmuUqUhOjrhvGqMVUOxe/tDKu+BKYl/3Co1I5qKI1FtUrdfUDzXmrtgqMLiOF8oSTECRnALiCWF4zA1oH6ToaNWhIudZ0H/ic95w9goBB8yMd+A1WIq4Q9rkjLZpAnn52/m3UCFSEMkxOJrz3LmtP8vlmBCN88Tx1AgShXPEXJPB8LPcgKcPiJdz4hFs4p0YN/fsF3ZoW7xkaxfokj20xS4is9c+KnPw0xndOWLbtq7B9x9ngIcaKW7pu84PPfxD/V3bt/Dc5O4RCA9TOQ+KbQUeizjI49SOAfEUB+LNUGRdgd1hcch5Lww79DJ9IHl9u0iXaVyPWUwkp68i/wJQSwMEFAAAAAgA65nhXGMbsdg1AQAAUQIAABEAAABkb2NQcm9wcy9jb3JlLnhtbI2SwWrDMBBE74X+g9Hdlmw3IQjbgbbk1EChKS29CWnjiFqykNQ6+fvKduIkkEOPuzP7NLuoWO5VE/2CdbLVJUoTgiLQvBVS1yV636ziBYqcZ1qwptVQogM4tKzu7wpuKG8tvNrWgPUSXBRI2lFuSrTz3lCMHd+BYi4JDh3EbWsV86G0NTaMf7MacEbIHCvwTDDPcA+MzURER6TgE9L82GYACI6hAQXaO5wmKT57PVjlbg4MyoVTSX8wYadj3Eu24KM4ufdOTsau65IuH2KE/Cn+XL+8DavGUve34oCqQnDKLTDf2qoIac9FOFzDnF+HG28liMdD0G/0BB/ijnMgohCAjnFPykf+9LxZoSoj2SwmDzHJN1lOSU7TxVf/5NV8H2hsqOPD/ybOMprNL4gnwJj7+hNUf1BLAwQUAAAACADrmeFcTUHW0hoBAAB7BAAAGgAAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzvZTBSsQwEIbvgu8Q5m7TdnUV2XQPLsJedX2A0E7bsG0SMnG1b2+s0FpY6h6Kl8DMJP//Mcxks/1sG3ZCR8poAUkUA0Odm0LpSsDb4fnmARh5qQvZGI0COiTYZtdXmxdspA+PqFaWWFDRJKD23j5yTnmNraTIWNShUhrXSh9CV3Er86OskKdxvObutwZkE022LwS4fbECduhscP5b25SlynFn8vcWtT9jwT+MO1KN6IOodBV6AUOKeF9ZRYEY+HmY+yVhqJYOi1fvQq9pBJqk52DSJWEu6Ew6B5P8M0wyB7NeEoZ814ShHwbmJ56zv1vS3odVwtG9D3l/zrbgdkkGq07GP8mw1TsslVbfez8ijVV+7uKAySdfRvYFUEsDBBQAAAAIAOuZ4VziK397uwAAADMBAAAyAAAAeGwvcGl2b3RDYWNoZS9fcmVscy9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1sLnJlbHOFj8FqwzAQRO+F/oPYey07h1CK5RwSArkG5wMWaW2L2FqhVUL899ExoYUeh2HezLS7xzKrOyXxHAw0VQ2KgmXnw2jg0h+/vkFJxuBw5kAGVhLYdZ8f7ZlmzCUkk4+iCiWIgSnn+KO12IkWlIojheIMnBbMRaZRR7RXHElv6nqr0ysDujemOjkD6eQaUP0aS/P/bB4Gb+nA9rZQyH9U6OjvnPdY5p3JcnJS4JhGygZ+WU1VpoPuWv12tXsCUEsDBBQAAAAIAOuZ4Vyy2Ekc4AQAAFkrAAAnAAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1s3Vptb+I4EP5+0v0HK9J9W0oCoRQErHjVcWpL1dKV7qObGPA1tiPb4eBO+99vnBeaHt1S1O0evi8tJGHmmZnHMxN7Op83LEJrIhUVvOt4Z66DCA9ESPmy69zPJ5ULBymNeYgjwUnX2RLlfO79/FMnpmuhhzhYkRFZUE41CEAgjKuus9I6blerCm4yrM5ETDjcWQjJsIavcllVsSQ4VCtCNIuqNdc9rzJMuZNJaMu3yBCLBQ3ISAQJI1xnQiSJsEGiVjRWhTQWvEUcw/IxiSuBYDGIeKAR1dtUqINY0J4uuZD4IQIXbGQheLOPk9FACiUW+gwEVTOIe9Z6PgBdU+NzB8k2DbuOnIYefCYLSdRqxi8FhotPV0g42HadfqJXArTnj5FwhDUA8hvNhnfWqJ/X6m695rtNA5kqBTGcasLUJWVUdx0IbQBe1yT8UsQbgruTVb7IKL/NoBiTd3fq5vFAyHAoEg4SAd9GthOD/+/apDYYuI2Litca+xXfbTUqg0HTrUwumhN/Uh+3RnX3q9PrBIYydyKRAUF6GwP8P4V8TJkAd3ef8ycAHZjttQe/1YCH5qGuc9NHt2RNeEI+oaFQ+hMaJOGSaIUetnDHqfY61ZKWXOWEkihUKMiQn9cKKOl1xDEDJLOYSIg9X6J7ILSDeMImTE/BPBceB2dIEqYe3alIf13WkEu6keIPEmg0k0vM6V8pJ1+RV8DyjBq07jrX/dSMksrCqEMarzDHSwIk+Sb476hsDgH8Hm66TtjDj8J8DaH+WO9MEh6YgOMIDRMpIZ9uj1F4fzc6NvhzoUHZlK8FpJsQ9Zlh+es6uYZ8q+4Io1d0Q0ITScjcJkeI/JaWaREoXcrClK774qkp1wToll6DrPEFRwksJPgNw5vdl4PLpR+k61LB8g0IXZukYxH6ew7VIgK/W4qeYMlT9GlStdPxGlqAgzn2pDhvSpeC0iVDAt4/JkH8Dj3YkdXhlsRCanQJIY7ek7DnWD0elPKUQj4mu5hUs8suaS7Ku5Feh5vi6R3rndSqH1GDMkUfXoDmIs6ChIzCd8f7jU3MwSyfWn+4Pzko55aorH/co7N33njeqH00Ff9V6Pao6B5LxZ1tP5IlhdL3MCXrwV8qIv91UA7yqR/oBNqnF+rfyUO/IZIKaPjstSDnTVEH0ze6Mg9PPgS57+014DmH7LVjBttY+VbAW3rYa8Gz7ZPX33kGEeaPRU+Rbit86w18Oh/l6q1MJQa+xXmk5H3rUkjJ9dZhHwoGu4svbDmcfOIuMeZX6Cdhu/hpy8wK8PlqtQ/8zVOmtI7vBnvueCux5/2WnaSxlvHz2dzm3qAE3zrSl7DbR/psJx/9Aq9FLI6IfrY7e/JFKvW3reDHimo4r4ZTSmGn97NDIbNeEbQ6VnU3eZG6wnJphgIs6svyCpUht87vM0mXqGJg21ytcissr7n7sbCu9O4H4n9ggn1NRLbB957N/WKcZfpMysn3H+mBk2WYb2DICDo+G6E/nctR6DmuiBkWsc39OxvyONyZY/MZnNE/m6g6eebvzLADfzavl43o9Tpkoy+VTv+jRFIYLmzWGv1xrT+utPyWV/EvHkhlUBvAmOF40Gr6k2HdvfC/7qYyPX9v3vNNY5luq9rKxlB7nY3nt18acTWHiYAr+5uirL70WO8fUEsDBBQAAAAIAOuZ4VwKgyt6MgEAABcEAAAkAAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlUmVjb3JkczEueG1s1ZPBS8MwFMbvgv9DyH1NJyIy2g5RBC8eZB48ZmnahjV5IS8t3X/v2+bcdIqFnby98N73y/c9kmw+2Jb1OqABl/NpknKmnYLSuDrnr4vHyS1nGKUrZQtO53ytkc+Ly4vMmx7ivVSNftEKQomMSA5z3sToZ0IgdazEBLx21KkgWBnpGGqBPmhZYqN1tK24StMbYaVxfEeYhTEMqCqj9AOozmoXd5CgWxkpBzbG455m1RiclWHV+YkC6wmxNK2J6y2UM6tmT7WDIJct5R/CHjyc+rRGBUCoYkIgsbN4knZ6TUZ7s1k4Zwo6F2nvvMhCkSHrc/58x0WRDZsy/Vr90T5I3Kd4bHXQbi9ZSFz95uLb6Bs9CPJ75G1Mig/VWHs/zVm69Rz9/9YeLfmcIIJenTj5ysU7UEsDBBQAAAAIAOuZ4VwKQQzqvQAAAEcBAAApAAAAeGwvcGl2b3RUYWJsZXMvX3JlbHMvcGl2b3RUYWJsZTEueG1sLnJlbHOFj8EKwjAMhu+C71Byt908iMg6D4rgVfQBQpdtxS0tbRV9e+ttA8FjyJ/vz1ftX+MgnhSidayhlAUIYuMay52G2/W02oKICbnBwTFpeFOEfb1cVBcaMOWj2FsfRaZw1NCn5HdKRdPTiFE6T5w3rQsjpjyGTnk0d+xIrYtio8KUAfWMKc6NhnBuShDXt8/N/9muba2hozOPkTj9qFDePl06YH7vSK1l+xXIfAwdJQ1STgI/s6XMOqDqSs306w9QSwMEFAAAAAgA65nhXJT7Rpa/BQAAiyIAAB4AAAB4bC9waXZvdFRhYmxlcy9waXZvdFRhYmxlMS54bWztWt9vozgQfj/p/gfEOyUQIE2VZEVCoq3Uu63a3t6zAyaxFjAypk21uv/9xjaQQNK7pmn3Tqs89IfH9vjzeMbY83n0aZMm2iNmBaHZWLcuerqGs5BGJFuN9T8eFsalrhUcZRFKaIbH+jMu9E+TX38Z5eSR8ge0THCAY5IRDgo0UJYVY33NeX5lmkW4xikqLmiOM6iJKUsRhyJbmUXOMIqKNcY8TUy71/PMFJFMVxqu0vA1SlLEvpW5EdI0R5wsSUL4s9Sla2l4db3KKBP4xvqG1Yo3bE9xSkJGCxrzC1Bk0jgmId7DZzkmw49EWAlUsauSRGP9u2sFnuPN5sbU8geGM59axuXAcQ3bmfasaX/qDqz5X7qWoRRA3DYGc3QtRGCba9BhO0NdQ3mePP9epkvMFspIYx0WQoqnlEUHxAua8b22t4hzzLI9uZ+QVZbiAz3+JBFff8Zktd5qs3QtQhzNUC7WdKx/RUkJq66VOYhx9LV2FvCMlGR3OGa4WAtDNzV98Jk1fQoYSRI5k7LAfsmpAsalb8EohOP0lpGMPxCeYJgzyELwi84gJIsAutQjlzps/R8AVFmXlgkneYIXBCfRgiRgCWnGySihIfgHuCfD8Vj33asvFowUE1bwz+CFmN3RJ6lCioRCKajbCMGMwkRgpRh9ukUrPKOlQGQLRMmOwNLNiYoMiaKAatnQswHGVt6aBy15QkRoAQBhNV/ZrKVIQxsCkxG/AVrbDi/0n4yEeRsEAoAQaJtKuSwAtAjHCCwnxjNlj8kIb/hNweVfrWQEHN0eOt48uPQM3xq4htO3kXHpzyzDc+a9met4wSAQjq6Cd2M5bwuy3tAcqm1gMgIlVzsGi8GTAvqU3aAlTqSnCLwAUP2WcM1t+5axj7edVhnlvlxyypFcj449ra49f1Lj7UbcB3mqRrICMz5NUPatCryz81Y7yBsC/+y89fb7g4330v5zdAj9DB3Om+4JX6yjHWBrbXEY+ejzwft9aM/7/HmfV0dlOHu//YR3dLx8fId/isisTBcpF7c/y3N17f0P8P+LAH23z6G4jEofURfEnSvgqw6kL3ffroMDd68Tlf233X/8VI5eh90Ob4B77q7SHmfTiY3z1QF7dhvlNq/ans4xffasox3lxA3p6PHOHVpJ4p1jFqRuIT/dzjwPIU8ZywM2JH5l1rQp2a2S0yq5rZLVKXqt2nbJaqu1Vaa2wSUhXu9mpj2RSYWELzT7tx8T2pHdpLUGdI4jssUye32gUqS9W5VLkWWEPL5I3r/QryNeMWC/dtqKucgJTEaQ/G9bW2SFG/sa0hJm00i2f2nqCj3k2oWKjfZYp7hrsUQrxEppLe7X4n5LLG0iWstVbVq7tViupxALdNVkcsgctGcjSYtaqsXyAA7c1ZpgMJ+huI52tQ1fmt1qc6t0MmoO4ltaBAZopBVNpk3LaIW5docfcVZCLkOOawOltESFAijvAaIkkHcOReJGBbj2tPohL1HS1QqzOUnrLWaERtph5XC1O0l5ZYhpCQRghiNtRgtemwMozpN0V4gP6h6cqLttlINDAHV4DHxz6zoQX4ohrak14aRKpEWbWF6qhZtLLsgHMlFymV+y5HnvGCQD9ZYWkrpWFA8QhJgB/40b9SIcGykkKZT7wdJWzB44/B5ZVG15ja6amhJw4H+Fdg+1iNkPRS1oZ0VHngC6Qg+b3/YBwD1/TvB1FtNdplsKf8MRKVPgTQWxCdyOolsV0ytEQKt2RdDqnjOSCz64YkShVVd0gwoO4jIVjxZEwO9zlkPPni/cwDLcmW8bTjjsG5fzhWME04U767lOfxjYH8RZdp9FrEmEFYteE8sVUwq7V+etxMHXCHgT4t1XEg33uWVoB87A9yzPMaxL1zecXjADhtZ3jUXPci3btXqB62xnm0fAab5m5O47DctT543K5xP0DMcx8VUBjYqv7cwdOrxA1HYaTv4GUEsDBBQAAAAIAOuZ4VwsAjYk5wMAACISAAANAAAAeGwvc3R5bGVzLnhtbO1YW4/iNhR+r9T/YHleG3IhYRNKWC2XSCttV1VnKlUqVWUSB6y1Y+SYaWi1/32PkwBhlhnYkVr1gRewj+3vfD432xm9rQRHj1SVTBYxdnsORrRIZcaKVYx/fUisEKNSkyIjXBY0xjta4rfj778blXrH6f2aUo0AoihjvNZ6M7TtMl1TQcqe3NACRnKpBNHQVSu73ChKstIsEtz2HGdgC8IK3CAMRXoNiCDq03ZjpVJsiGZLxpne1VgYiXT4flVIRZYcqFauT1JUuQPloUrtldTSr/QIlipZylz3ANeWec5S+jXdyI5skh6RAPl1SG5gO97J3iv1SiTfVvSRGffh8ajYikToEqVyW+gYewcRakbeZ+DjgY9R45WpzMBOWbboCbHo7XYLtF4PhRiWJbb3YCcrg9OVdz/c3Tk9x/kT/fj7LzT7Y2HtJQtkEOyWz3iUy6JLC7wCXhh+KuRfRWKGgBZwNbPGo/Jv9Eg4SByDkUouFdIQU0DVrXkRQZsZU8LZUjEjzIlgfNeIPSOow7CdJxgERU2o0dD8Ls2sf11XrbIEnYzzg2N8s1kQjEcQw5qqIoEOatsPuw1stYB0ayjX8y7MXimyc73g+gWl5CwzLFbT2sBqtYxxkszfzZOkhlm2A6zIaEUhbiBsDJ0O4WvJPdXVOrOPkWYmTJ3emyiKQncQhmHk913frz34LQxqK4GVl1JlUMz2CWCCqhGNR5zmGlAVW63Nv5Ybo0NqDQk/HmWMrGRBuNnifkXbANiUcn5vCt5v+Ql2lXfSA0qn8bXJMdMEQm2zwWs6Br+L1mB3YEOg/O2wqMoP+M+tdo+kPIy6pA6rEdls+M5kpMm1tgcbaTPvBLmtI5c2/AT741YsqUrq8nMO9SojHjE37FHqyRacaE4vY90nHOuK9Z9whHB+yabPWvE8w5fRnlrxkqc6Oq6Ogmd0PBcbdVRDHHeS5SRVDkGPTP2O8UcTAhzO0jZw0XLLONSDM2kCmFnVSbwBpAgILhbFfd3ZF5Ir687ZEmfXCm9aTw+pm4XxpVPsFk23zDlzvbtlzi1zOnfd/12VMOcdnLvaPKXrm+/hMIcbWkZzsuX64TAY42P7J5qxrYAbZjvrZ3NFqyFifGw3syJzY6OV/lDCewz+0VaxGP8zn7yJZvPEs0JnElp+nwZWFExmVuBPJ7NZEjmeM/3cedC/7unsmOd8/f0Bbo2uPyw5PPpVu9mW/P1RFuNO54N5RdT3TRtod7lH3sB5F7iOlfQd1/IHJLTCQT+wksD1ZgN/Mg+SoMM9eB1317Fd90g+GGomKGfF3ld7D3Wl4CTovrAJs5XaE/bx4874C1BLAwQUAAAACADrmeFcwofb8lEGAADXGwAAEwAAAHhsL3RoZW1lL3RoZW1lMS54bWztWU9v2zYUvw/YdyB0b2MnthMHdYrYsZutTRskboceaZmW2FCiQNJJfRva44ABw7phlwG77TBsK9ACu3SfJluHrQP6FfZISrYYM43Tpti/5hCL1I/v/3t8pK5cvZ8wdEiEpDxtBdXLlQCRNORDmkat4Ha/d2ktQFLhdIgZT0krmBAZXN14/70reF3FJCEI1qdyHbeCWKlsfWlJhjCN5WWekRTejbhIsIKhiJaGAh8B3YQtLVcqjaUE0zRAKU6A7K3RiIYE9Q1JeLuKLsFPtRJsFIy6DF6lSuqJkIl9zYa4q0+uGx5UNVpOZIcJdIhZKwD+Q37UJ/dVgBiWCl60gor5C5Y2rizh9XwRU6esLa3rmb98Xb5geLBseIpoMGVa7dWaq1tT+gbA1Dyu2+12utUpPQPAYQhaW1nKNGu9tWq7oFkC2cd52p1KvVJz8SX6K3P0m+12u97MZbFEDcg+1ubwa5VGbXPZwRuQxdfn5W9vdjoNB29AFt+Yw/dWm42aizegmNH0YA6t/Tn1zBQy4mzbC18D+FoRADMURMM00jSLEU/VInGX4Htc9ABsHI0VTZGaZGSEQ4j0Dk4GgmKtOV4nuPTGToVybkrzRTIUNFOt4MMMQ9bM6L189v3LZ0/Qy2ePjx88PX7w0/HDh8cPfrS0nIXbOI3KC198+9mfX3+M/njyzYtHX/jxsoz/9YdPfvn5cz8Qsmkm0fMvH//29PHzrz79/btHHvimwIMyvE8TItFNcoT2eAK6eSQnA3G+Ff0YU2cFjoG2h3RXxQ7w5gQzH65NXOPdEVBIfMBr43uOrPuxGCvq4Xw9ThzgDueszYXXANc1r5KF++M08jMX4zJuD+NDH+8OTh3XdscZVNMiKJ2o6cTEEXOX4VThiKREIf2OHxDi0e4upY5dd2gouOQjhe5S1MbUa5I+HTiBNFu0TRPwy8SnM7jasc3OHdTmzKf1Fjl0kZAQmHmE7xPmmPEaHiuc+Ej2ccLKBr+BVewTcn8iwjKuKxV4OiKMo+6QSOlbc0uAviWnX8dQu7xu32GTxEUKRQ98NG9gzsvILX7QiXGSeWWmaVzGfiAPIEQx2uXKB9/hboboMfgBp6e6+w4ljrvPLgS3aeSINAsQ/WYsPL68RribjxM2wsRUGSjvTqVOaPqqss0o1O13ZbvYxzZhE/Mlz/aJYn0a7l9YorfwON0lkBXzW9S7Cv2uQgf/+Qp9Wi5ffF2elWKo0rO+2zS1yUJN+Igytq8mjNyQpg+XsBkNezBpBub0OD2gZTE85luCg4sENmuQ4OojquL9GGfQw1fNsTSSOelIooxLOEeaaS9tc4yl0MabU2i9OG8CGqsdPrTTK+Vz6JSM2agic+4tGK1oAosyW1nND7evyaxqpVpQtaoRzRRIR7WpyqDMvGpGw9ya0OUg6I3Ayg040GtqcPbBjAy13e22XbjF2OQiXSRjPCS5j7Te84pUjZOKWCnCyOMjfaY8w2olbk1N9g24LeKkMrvaKewK772JlwrrzLykc/hEOrK0nJwsRUetoFlfrgcoxFkrGMGxGR6TDLwudWOJWQT3U6ESNhDPTGaDmnmz6Q/LKtyKnOJNh0UmpNrCMrahYV4V1zSpOeQb+ZfrYNaLUsBG+mtIsbIGwfC3SQEyu64loxEJVdnZpRlzB2IAefLzsSJiPx4eoQEbiz0M7tehCvoMqYTbD1MR9ACu7bS1zcgtznnSlS/LDM7OY5bFOC+3OkWLTLZwY/OpDGZUEm86MtrMZD8xXFQVk/IXpEo5jP9nquj9BK4jVobm9gxukwVGOl9bARcq5lCFspiGPQGXaCYCIFrg6hdeg/HhTtv8CnKof23OWRomreFUqfZohASF/UjFgpBdKEsm+s4gVs33LkuyIGRzeiauzKzYA3JIWF/XkIbe2wMUF9UkLwMGdzL+3HEedoNINyz/1M7HJvN524NZ52PXL9iL1EpFv7QVNN9MhHNutbZizWm8XF94q83gUgnpf7D/UREyYvTXG2qf70HpRNOOEkFUX7KNB9IF0j4NoHGykzaYNKm320bNOt0p37fYfJa2+Wlz5rJzcvHV3ef5jJ1b2LF1udP1mBoccDJFdXtUHGqMY8yXtfIHLz64B47egk8IY6ak/XRwH64QYcuyHyQg+a1zzdKNvwBQSwMEFAAAAAgA65nhXFS8hXzxAgAAmAYAAA8AAAB4bC93b3JrYm9vay54bWylVV1v2jAUfZ+0/+BZSH1pyAchg4hQQWk0pm5Ca9c+IpMYsJrYkeNAUNX/vuuE8DEeVnVRSLCvfe45x9fO4KZME7ShMmeCB9huWxhRHomY8VWAfz+GRg+jXBEek0RwGuAdzfHN8POnwVbIl4UQLwgAeB7gtVKZb5p5tKYpydsioxwiSyFToqApV2aeSUrifE2pShPTsSzPTAnjuEbw5XswxHLJIjoRUZFSrmoQSROigH6+ZlneoKXRe+BSIl+KzIhEmgHEgiVM7SpQjNLIn664kGSRgOzS7qJSwu3Bz7bg4TSZIHSRKmWRFLlYqjZAmzXpC/22Zdr2mQXlpQfvQ3LBhA3Ta3hgJb0PstKG1ljgQr00WvJ/o9lQWg2c80G07oGbg4eDJUvoU126iGTZT5LqlUowSkiu7mKmaBzgr9AUW3rscDGSRTYuWAJRp9d1PGwOD+U8kwhgFZUzyTYk2sGewGjNYjpjG6FCRpP4nuWq6o7pkhSJeoSKb3hAv+M6NWQp/cbJmZII/k8n98DsgWyAJ7gR78t4CkTszpxH0rfnr6Nx3wo91zU63d6t4Y49z+iH4di463pu2O+Nxm7PeQMrpedHghRqvbdAQwfYBb0XoR+kbCK25RcsPtJ4tfaXod9/PZrYm5ajN/sTo9v8aJZuovKZ8VhsA2zYDojanTe3VfCZxWod4E7Pc2FI3feNstUaGDvgGHSSSLENfSSLylrYX5pngM/4TWp+IVzV44yfeUKwOmSAaPVGvCqM2Qj9ohvKC3qNbkWurtG4iFcwDC12EIFjTg+u1gIqxNfJ5TS2tfQzGF0H6KFI4ezYnUzqnExyLiYRCRygquB8OqSBE+SQpqNnmA1tKCzGaawLGkSctPZS5mXC0/Y8rAp1QhRZkBwEJCIiyUOjAjyFuo2pPtbx8Oof8q++tEYt22+Nv7fsgXmSEmid04EcEewS/arMchzHrlzKtDO3BD4AQPrYgJHQpYc6bv9EsltJPptkNh+V4R9QSwMEFAAAAAgA65nhXMihuPq4AAAANAEAACMAAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0Mi54bWwucmVsc4WPwQrCMBBE74L/EPZu0noQkaa9iOBV6ges6bYNtknIRtG/N8cKgrfZHfbNTtW85kk8KbL1TkMpCxDkjO+sGzRc29NmD4ITug4n70jDmxiaer2qLjRhykc82sAiUxxrGFMKB6XYjDQjSx/IZaf3ccaUxziogOaOA6ltUexUXDKg/mKKc6chnrsSRPsOOfk/2/e9NXT05jGTSz8iVLBPn1q8TZSpGAdKGqRcrHmhS5l/B1VX6qtr/QFQSwMEFAAAAAgA65nhXH1fHWPhBAAA3hUAABgAAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWylmF1vozgUhu9X2v+AuNirKWADSZpNMpppVc2MdqVquh/XhDgJKmAWO23T1f73PcfkYKqOKpyOOvFLHF5/PT6Ys/j4VJXeg2hVIeulz4LI90Sdy01R75b+n3/cXMx8T+ms3mSlrMXSPwrlf1z9/NPiUbb3ai+E9sChVkt/r3UzD0OV70WVqUA2ooaarWyrTMNluwtV04psY26qypBH0SSssqL2O4d5O8ZDbrdFLq5lfqhErTuTVpSZhv6rfdEocqvyMXZV1t4fmotcVg1YrIuy0Edj6ntVPv+6q2WbrUsY9xNLstx7auGPw/+YmjHfv2qpKvJWKrnVATiHXZ9fD/8yvAyzvHd6Pf5RNiyBCXgocAGtFT+vSyztvbg1i880w5XpOobT1c4PxWbp/xud/l1AyfAjsh9U95+/WmwKWGG82WvFdul/YvPP37gfrhYGoL8K8agG2kMe11LeY8VXaCcCiyarhXe8a2BVgW3f07L5TWz1lShLMIQRZrkuHsQt/Gzpr6XWssJ6Q7yGr7atfBa1aVOUAn4LnUHPlz/uTKyp+qfrsOls2Pd2qKnnN2Z33LbeRmyzQ6mvZPl3sdF76C0LEp5OZ4ynPtV+l49fRLHb42B4MIUKQ998c7wWKoftAKMOTKu5LKEJ+PSqArc10Jw9mfLxZA83r4XSN6eZyQ8KBk9tnyy6m2GazM1Qnm7mk0HfRroAAcYFSurCJOCzlKUTHOFIl+TkAiW5gOHIm6EZ0wUo+1kIpiy6jHEqR5pgYEATKMkkCWZpmkxmDi7TkwuU5DJzd4HQbPoCJa0MC1gSuczo5ckDSurJpfvqMnhsdISB6H1GTyrrAR0QOgvSaRQb/keuDSNUUdh5daaMEawozkeFEa0oelzdoWcELoof+byxeRnxisIOxRlYRsSisBvYeYUIWWaZZRO70G+NhEhlFtVzAhEnVFHYLey4bTgRi4I2H8Rkx2jC++A6IDZ1tyFg+Y+BfSu6E6R8AOkwvit9xPMP1I7chbhhuwfGi0Dbo+JuSAxzyzBng33k7kg0c0szOBID7n6ENR+E4mgQRt0diXb+gvazexgT9SjeEYti4h6FfWC4xoGYuEfxjidg3B8rhueK0ajGBD8KGx0dY0FMwKN4x+EmJs5RkM/U/XkRE93xiyBrj5MjN3JMDKKws+O61gmhh8IOyzVUJkQeCjvLzk+yhNBDQZEbejZyUhIiDoXthvPkJv1RdoDe1DnyJ8QeivP3Y0LoobBr5D65hF4yCKyR80EuoXiK4uxndEL8ouj5Hb3SKXGLws6J80qnBC4KAi5xnpOUuEVBNuPPxilxi6LH3v2dIyVuUdi3Duczdtq/jVlwOXefFQI3teDOXN+BUqIWBa105LwXU6IWxcnG/SUmJWpRWPadsZsQvihooWL3p8mE8EXRc3eGD/E7GTzyx79qhl1Kw2RTrjOdUTal0022E79n7a6olVdCBgcTIbCWbZcsMRpyP0bhljGZHrraQ05SQO4tCmBnbKXUdAF5FPS9E/rQQNqnEe1d8QxHYVgX2RaQbjFJx6VfQnZU5VDve3uoeJZQU143BeagMLWqi7y/Bs+uvRvT0GohN5sv5ovVL1nV/Hp1+8n7Lh5EfRAfvCup9Afv82GzE1p56yPUKHloc6EWob1vEb50DPvM7Op/UEsDBBQAAAAIAOuZ4VyJI/BAvQQAAGMTAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDIueG1spVhbk6o4EH7fqv0PFO8CQRgvJZ5yvMyM4+XUOXt5RoxKDRAXMrfd2v++3UFEoqZwtmocYn/dX3e6Owmx9+0jjrQ3mmYhSzydGJau0SRg6zDZevrvv00abV3LuJ+s/Ygl1NM/aaZ/6//6S++dpS/ZjlKuAUOSefqO833XNLNgR2M/M9ieJoBsWBr7HL6mWzPbp9RfC6M4Mm3LujNjP0z0nKGb1uFgm00Y0BELXmOa8JwkpZHPIf5sF+6zgi0O6tDFfvryum8ELN4DxSqMQv4pSHUtDrpP24Sl/iqCeX8Qxw+0jxT+bPg0CzdCfuYpDoOUZWzDDWA285jPp98xO6YfHJnO51+LhjiQgLcQC1hS2V8LibhHLrska36RDCuTB4bpSruv4drT/xmP7lvDSbPVaHYmzYbTHjiNe3c0aXQsd+IOBq1x03L+1fu9dQgVRmMtpRtPH9jdJSG62e+JBvojpO/ZyVjj/uonjWjAKTghuob9uWLsBRWfQGQB5d5PqPbxcw9V9nQo8edh6OoaZ/sZ3fAhjSJPfwDMD3j4Rr+DhaevGOcs/hFud1ysBg6yTcr+pomIR7jFQJHf04HqoJpzHDghpuwvMZWHfBqSWe4Egyic54YDCOZgCMOrhpdclpYwI7A0j6k7HRdpnIil+j3V1nTjv0b8B3t/pDhnyKdttCBJotm7688RzQJYfZBUw0begEVAAv+1OMRdBBaP/5FXIVzznafbbcOx3Vab2MCyohmfYAUAD14zmPSfuZZIy5EFGlCwwLNggc2ppjE0nDCG58GYdAy77RL37oYQnAMLPIsQ6scPmiIEeBbGjtF2XeeujbmsORHciJAFniULcaxbptE6cMCzSEbbcFtW85ZywDkgAumUJO7tRSVQwrw3YFAE43yB59hjZZORptEiVqd5Q3ZJ0WQ4KBvl5l4lRb/h4H80HCk6DgdfrxUpeg8HZdvU7X8zX89isxj53O/3UvauwfEEScpgj4PDnnSR+uJ+AEsYdQeoLBYgrPQMNt+3vtUz32DjCQ4a96BxxMgRM8HZ0SOY1/eIylWPtuTxNJorHmFa9T2ictVjU/J4ruFUNYbnGm5VY3SucVfVGJ9rtKoak3ONdlXj4VyjU9V4PNcgUkmfLqiUeRZ9McXDtugIIhXouQJKuZxVQCmN8wooZXBRAaXkLStgmbdKH+JJWrvzQbmcoZTmexU4VIEjFThWgRMViO86ZbRyyU9BWy62inaKGfN059LCf1ZgMwU2V2ALBba8jFUKDGdj/QKD8vUCq8ChChypwDEGKF4mjp5taWVNChV8i8Kl9iALHmXBkyyY5oK7i2VTYDMFNldgCwW2vIxVyoa309rrEpSvl00FDtGNOvmjQqVI/lgWTGTBgyx4lAVPsmCaCy6XR4HNFNhcgS0U2PIyVikPvCzWLs8UlXHHKDL4LAtmsmAuCxayYHkiqESG75+1Qxug9tV1NxVc1/Y6FThTgXMVuFCByytgNQF4H629dODmfZIA6dSeIno9AQpwprKcq8CFCsQfCi4FlCcgvwXnL7Z7f0vnfroNk0yL4OqNV1rYdtL82ivGcJ0XI7yziSt68W0HP2ZR2GYtA14rN4zx4gvetI8/j/X/A1BLAQIUABQAAAAIAOuZ4VyQ7xzWmgEAAG0HAAATAAAAAAAAAAAAIAC2gQAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAhQAFAAAAAgA65nhXLVVMCPuAAAATAIAAAsAAAAAAAAAAAAgALaBywEAAF9yZWxzLy5yZWxzUEsBAhQAFAAAAAgA65nhXP1jlxirAQAAcAMAABAAAAAAAAAAAAAgALaB4gIAAGRvY1Byb3BzL2FwcC54bWxQSwECFAAUAAAACADrmeFcYxux2DUBAABRAgAAEQAAAAAAAAAAACAAtoG7BAAAZG9jUHJvcHMvY29yZS54bWxQSwECFAAUAAAACADrmeFcTUHW0hoBAAB7BAAAGgAAAAAAAAAAACAAtoEfBgAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHNQSwECFAAUAAAACADrmeFc4it/e7sAAAAzAQAAMgAAAAAAAAAAACAAtoFxBwAAeGwvcGl2b3RDYWNoZS9fcmVscy9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1sLnJlbHNQSwECFAAUAAAACADrmeFcsthJHOAEAABZKwAAJwAAAAAAAAAAACAAtoF8CAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1sUEsBAhQAFAAAAAgA65nhXAqDK3oyAQAAFwQAACQAAAAAAAAAAAAgALaBoQ0AAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZVJlY29yZHMxLnhtbFBLAQIUABQAAAAIAOuZ4VwKQQzqvQAAAEcBAAApAAAAAAAAAAAAIAC2gRUPAAB4bC9waXZvdFRhYmxlcy9fcmVscy9waXZvdFRhYmxlMS54bWwucmVsc1BLAQIUABQAAAAIAOuZ4VyU+0aWvwUAAIsiAAAeAAAAAAAAAAAAIAC2gRkQAAB4bC9waXZvdFRhYmxlcy9waXZvdFRhYmxlMS54bWxQSwECFAAUAAAACADrmeFcLAI2JOcDAAAiEgAADQAAAAAAAAAAACAAtoEUFgAAeGwvc3R5bGVzLnhtbFBLAQIUABQAAAAIAOuZ4VzCh9vyUQYAANcbAAATAAAAAAAAAAAAIAC2gSYaAAB4bC90aGVtZS90aGVtZTEueG1sUEsBAhQAFAAAAAgA65nhXFS8hXzxAgAAmAYAAA8AAAAAAAAAAAAgALaBqCAAAHhsL3dvcmtib29rLnhtbFBLAQIUABQAAAAIAOuZ4VzIobj6uAAAADQBAAAjAAAAAAAAAAAAIAC2gcYjAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0Mi54bWwucmVsc1BLAQIUABQAAAAIAOuZ4Vx9Xx1j4QQAAN4VAAAYAAAAAAAAAAAAIAC2gb8kAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWxQSwECFAAUAAAACADrmeFciSPwQL0EAABjEwAAGAAAAAAAAAAAACAAtoHWKQAAeGwvd29ya3NoZWV0cy9zaGVldDIueG1sUEsFBgAAAAAQABAAfwQAAMkuAAAAAA== xl/worksheets/sheet1.xml xl/worksheets/sheet3.xml 1 0 Task Level 1 (All) 2 Resource Level 3 Project Organization 4 Project Manager 5 Project Number 6 Project Name 7 Task Number 8 Task Name 9 Functional Currency 10 Costs Burdened 11 Resource Name 12 Budget Revenue 13 Actual Revenue 14 Period Actual Revenue 15 Budget Burdened Cost 16 Actual Burdened Cost 17 Period Actual Burdened Cost 18 NA 19 USD 20 Yes 21 NA Total 22 Grand Total data A1 1 data AA 4 data AA1 7 data AB 4 data AB1 7 data AC 4 data AC1 7 data AD1 1 data AE 4 data AE1 1 data AF 4 data AF1 1 data AG 4 data AG1 1 data AH 4 data AH1 1 data AI 4 data AI1 1 data AJ 4 data AJ1 1 data AK 4 data AK1 1 data AL 4 data AL1 1 data AM 4 data AM1 1 data AN 4 data AN1 1 data AO 4 data AO1 1 data AP 4 data AP1 1 data AQ 4 data AQ1 1 data AR 4 data AR1 1 data AS 4 data AS1 1 data AT 4 data AT1 1 data AU 4 data AU1 1 data AV 4 data AV1 1 data AW 4 data AW1 1 data AX 4 data AX1 1 data AY 4 data AY1 1 data AZ 4 data AZ1 1 data B1 1 data BA 4 data BA1 1 data BB 4 data BB1 1 data BC 4 data BC1 1 data BD1 1 data BE 4 data BE1 1 data BF 4 data BF1 1 data BG 4 data BG1 1 data BH 4 data BH1 1 data BI 4 data BI1 1 data BJ 4 data BJ1 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 U 4 data U1 1 data V1 1 data W1 1 data X 4 data X1 7 data Y 4 data Y1 7 data Z 4 data Z1 7 parameter A1 1 parameter A10 1 parameter A11 1 parameter A12 1 parameter A13 1 parameter A14 1 parameter A2 1 parameter A3 1 parameter A4 1 parameter A5 1 parameter A6 1 parameter A7 1 parameter A8 1 parameter B3 2 S Site SYSADMIN AC005881057FC68668D8748208C41CE4 5936A33385A68931168ABA7A54B84ED8