ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2973869E053B46B63588994 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.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, pa_paxbubss_xmlp_pkg.c_indented_task_numberformula(pt.wbs_level,pt.task_number) indented_task_number, pa_paxbubss_xmlp_pkg.c_indented_task_nameformula(pt.wbs_level,pt.task_name) indented_task_name, substr(sys_connect_by_path(pt.task_number, '&lp_path_delimiter'),2) task_hierarchy, 'Task' report_level from pa_tasks pt, per_people_x ppx, hr_all_organization_units_tl haout where pt.wbs_level = decode(nvl(:explode_sub_tasks,'N'),'N',1,pt.wbs_level) 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') connect by prior pt.project_id = pt.project_id and prior pt.task_id = pt.parent_task_id start with 2=2 and pt.parent_task_id is null union select p.project_id, 0 task_id, null wbs_level, null task_number, null task_name, null task_organization, null task_manager, null top_level_task, null indented_task_number, null indented_task_name, null task_hierarchy, 'Project' report_level from pa_projects p where nvl(:p_report_level,'T') = 'P' ), actuals as ( select pah.project_id, pah.task_id, nvl(paa.revenue_itd,0) actual_revenue_amount, nvl(paa.burdened_cost_itd,0) actual_cost_amount, nvl(paa.labor_hours_itd,0) actual_hours, paa.* from pa_project_accum_headers pah, pa_project_accum_actuals paa where pah.project_accum_id = paa.project_accum_id and pah.resource_list_member_id = 0 ), commitments as ( select pah.project_id, pah.task_id, nvl(ppac.cmt_burdened_cost_ptd,0) cmt_burdened_cost_ptd from pa_project_accum_headers pah, pa_project_accum_commitments ppac where pah.project_accum_id = ppac.project_accum_id and pah.resource_list_member_id = 0 ), budget_costs as ( select pah.project_id, pah.task_id, nvl(base_burdened_cost_tot,0) budget_cost_amount, nvl(base_labor_hours_tot,0) budget_cost_hours, -- nvl(pab.base_raw_cost_itd,0) baseline_raw_cost_itd, nvl(pab.base_raw_cost_ytd,0) baseline_raw_cost_ytd, nvl(pab.base_raw_cost_pp,0) baseline_raw_cost_pp, nvl(pab.base_raw_cost_ptd,0) baseline_raw_cost_ptd, nvl(pab.base_burdened_cost_itd,0) baseline_burdened_cost_itd, nvl(pab.base_burdened_cost_ytd,0) baseline_burdened_cost_ytd, nvl(pab.base_burdened_cost_pp,0) baseline_burdened_cost_pp, nvl(pab.base_burdened_cost_ptd,0) baseline_burdened_cost_ptd, nvl(pab.orig_raw_cost_itd,0) original_raw_cost_itd, nvl(pab.orig_raw_cost_ytd,0) original_raw_cost_ytd, nvl(pab.orig_raw_cost_pp,0) original_raw_cost_pp, nvl(pab.orig_raw_cost_ptd,0) original_raw_cost_ptd, nvl(pab.orig_burdened_cost_itd,0) original_burdened_cost_itd, nvl(pab.orig_burdened_cost_ytd,0) original_burdened_cost_ytd, nvl(pab.orig_burdened_cost_pp,0) original_burdened_cost_pp, nvl(pab.orig_burdened_cost_ptd,0) original_burdened_cost_ptd, nvl(pab.orig_labor_hours_itd,0) original_labor_hours_itd, nvl(pab.orig_labor_hours_ytd,0) original_labor_hours_ytd, nvl(pab.orig_labor_hours_pp,0) original_labor_hours_pp, nvl(pab.orig_labor_hours_ptd,0) original_labor_hours_ptd, nvl(pab.base_labor_hours_itd,0) baseline_labor_hours_itd, nvl(pab.base_labor_hours_ytd,0) baseline_labor_hours_ytd, nvl(pab.base_labor_hours_pp,0) baseline_labor_hours_pp, nvl(pab.base_labor_hours_ptd,0) baseline_labor_hours_ptd, nvl(pab.base_raw_cost_tot,0) baseline_raw_cost_tot, nvl(pab.base_burdened_cost_tot,0) baseline_burdened_cost_tot, nvl(pab.orig_raw_cost_tot,0) original_raw_cost_tot, nvl(pab.orig_burdened_cost_tot,0) original_burdened_cost_tot, nvl(pab.orig_labor_hours_tot,0) original_labor_hours_tot, nvl(pab.base_labor_hours_tot,0) baseline_labor_hours_tot from pa_project_accum_headers pah, pa_project_accum_budgets pab, pa_budget_types pbt where pah.project_accum_id = pab.project_accum_id and pab.budget_type_code = pbt.budget_type_code and pab.budget_type_code = pa_paxbubss_xmlp_pkg.c_cost_bgt_code_p and pah.resource_list_member_id = 0 and pbt.budget_amount_code = 'C' ), budget_revenues as ( select pah.project_id, pah.task_id, nvl(base_revenue_tot,0) budget_revenue_amount, nvl(base_labor_hours_tot,0) budget_revenue_hours, -- nvl(pab.base_revenue_itd,0) baseline_revenue_itd, nvl(pab.base_revenue_ytd,0) baseline_revenue_ytd, nvl(pab.base_revenue_pp,0) baseline_revenue_pp, nvl(pab.base_revenue_ptd,0) baseline_revenue_ptd, nvl(pab.orig_revenue_itd,0) original_revenue_itd, nvl(pab.orig_revenue_ytd,0) original_revenue_ytd, nvl(pab.orig_revenue_pp,0) original_revenue_pp, nvl(pab.orig_revenue_ptd,0) original_revenue_ptd, nvl(pab.orig_labor_hours_itd,0) original_labor_hours_itd, nvl(pab.orig_labor_hours_ytd,0) original_labor_hours_ytd, nvl(pab.orig_labor_hours_pp,0) original_labor_hours_pp, nvl(pab.orig_labor_hours_ptd,0) original_labor_hours_ptd, nvl(pab.base_labor_hours_itd,0) baseline_labor_hours_itd, nvl(pab.base_labor_hours_ytd,0) baseline_labor_hours_ytd, nvl(pab.base_labor_hours_pp,0) baseline_labor_hours_pp, nvl(pab.base_labor_hours_ptd,0) baseline_labor_hours_ptd, nvl(pab.base_revenue_tot,0) baseline_revenue_tot, nvl(pab.orig_revenue_tot,0) original_revenue_tot, nvl(pab.orig_labor_hours_tot,0) original_labor_hours_tot, nvl(pab.base_labor_hours_tot,0) baseline_labor_hours_tot from pa_project_accum_headers pah, pa_project_accum_budgets pab, pa_budget_types pbt where pah.project_accum_id = pab.project_accum_id and pab.budget_type_code = pbt.budget_type_code and pah.resource_list_member_id = 0 and pab.budget_type_code = pa_paxbubss_xmlp_pkg.c_rev_bgt_code_p and pbt.budget_amount_code = 'R' ) -- -- Main Query -- select /*+ ordered push_pred(t) push_pred(a) push_pred(c) push_pred(bc) push_pred(br) */ 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, -- tasks t.report_level, t.wbs_level task_level, t.task_number, t.task_name, t.top_level_task, t.task_hierarchy, t.task_organization, t.task_manager, -- actuals case when a.project_id is not null then a.actual_revenue_amount else null end actual_revenue_amount, case when a.project_id is not null then a.actual_cost_amount else null end actual_cost_amount, case when a.project_id is not null then a.actual_hours else null end actual_hours, -- cost_budget case when bc.project_id is not null then bc.budget_cost_amount else null end budget_cost_amount, case when bc.project_id is not null then bc.budget_cost_hours else null end budget_cost_hours, -- revenue_budget case when br.project_id is not null then br.budget_revenue_amount else null end budget_revenue_amount, case when br.project_id is not null then br.budget_revenue_hours else null end budget_revenue_hours, -- -- The following column list is from the Project Status Inquiry Form -- decode((sign((nvl(bc.baseline_burdened_cost_itd,0) * 1.1) - (nvl(a.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(a.revenue_itd,0)) itd_act_rev, round(nvl(bc.baseline_burdened_cost_itd,0)) itd_cst_bgt, round(nvl(a.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(a.labor_hours_itd,0)) itd_act_hrs, -- round(nvl(bc.baseline_burdened_cost_ptd,0)) ptd_cst_bgt, round(nvl(a.burdened_cost_ptd,0)) ptd_act_cost, round(nvl(bc.baseline_labor_hours_ptd,0)) ptd_bgt_hrs, round(nvl(a.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, (a.burdened_cost_itd/bc.baseline_burdened_cost_tot) * 100)) fin_pct_cmplt, round(decode(bc.baseline_labor_hours_tot,0,0, (a.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(a.burdened_cost_itd,0)) est_to_cmplt, round(nvl(a.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(a.revenue_itd,0) - nvl(a.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, -- -- p.project_id, t.task_id from projects p, tasks t, actuals a, commitments c, budget_costs bc, budget_revenues br where p.project_id = t.project_id and -- t.project_id = a.project_id (+) and t.task_id = a.task_id (+) and -- t.project_id = c.project_id (+) and t.task_id = c.task_id (+) and -- t.project_id = bc.project_id (+) and t.task_id = bc.task_id (+) and -- t.project_id = br.project_id (+) and t.task_id = br.task_id (+) order by operating_unit, project_organization, project_manager, project_number, task_hierarchy Y PA PAXBUBSS_XML AR PA الإيرادات والتكلفة والموازنات حسب هيكل تقسيم العمل (بتنسيق XML) Application: المشروعات Source: MGT: الإيرادات والتكلفة والموازنات حسب هيكل تقسيم العمل (بتنسيق XML) Short Name: PAXBUBSS_XML DB package: PA_PAXBUBSS_XMLP_PKG D PA Umsatz, Kosten, Budgets nach Projektgliederungsstruktur Application: Projects Source: PA: Umsatz, Kosten, Budgets nach Projektgliederungsstruktur (XML) Short Name: PAXBUBSS_XML DB package: PA_PAXBUBSS_XMLP_PKG F PA Produit, coût et budgets par structure de projet Application: Projects Source: MGT : Produit, coût et budgets par structure de projet (XML) Short Name: PAXBUBSS_XML DB package: PA_PAXBUBSS_XMLP_PKG US PA Revenue, Cost, Budgets by Work Breakdown Structure This Blitz report implements the standard Oracle report: MGT: Revenue, Cost, Budgets by Work Breakdown Structure (XML) The 'Report Level' parameter determines if the report is run at the Project Level or Task Level Report Level Parameter: Project - will pull back revenue, costs and budgets accumulated at the project level Task - will pull back revenue, costs and budgets accumulated at the task level The report has been extended to pull in additional datapoints as displayed in the Project Status Inquiry Form. Application: Projects Source: MGT: Revenue, Cost, Budgets by Work Breakdown Structure (XML) Short Name: PAXBUBSS_XML DB package: PA_PAXBUBSS_XMLP_PKG ZHS PA MGT：按工作细分结构列出的收入、成本和预算 Application: 项目 Source: MGT：按工作细分结构列出的收入、成本和预算 (XML) Short Name: PAXBUBSS_XML DB package: PA_PAXBUBSS_XMLP_PKG Enginatics R12 only &lp_path_delimiter 1=1 2=2 :c_company_name_header :c_cost_bgt_code :c_cost_bgt_name :c_explode :c_mgr :c_no_data_found :c_org :c_proj_name :c_proj_num :c_proj_type :c_rev_bgt_code :c_rev_bgt_name :c_task_name :c_task_num :cost_bgt_code :explode_sub_tasks :mgr :operating_unit :org :p_conc_request_id :p_debug_mode :p_report_level :p_rule_optimizer :proj :proj_type :rev_bgt_code :toptask 1 -10 &lp_path_delimiter <parameter_value> Char > US Path Delimiter 2 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 3 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 AR تنظيم المشروع D Projektorganisation F Organisation du projet US Project Organization ZHS 项目组织 4 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 AR مدير المشروع D Projektmanager F Chef de projet US Project Manager ZHS 项目经理 5 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 项目编号 6 2=2 pt.project_id = :proj US Project Number 7 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 8 2=2 pt.project_id = :proj_name_id US Project Name 9 50 1=1 pi.project_type = :proj_type LOV Oracle PA_SRS_PROJECT_TYPE Y select project_type id, project_type value, description description from pa_project_types order by project_type AR نوع المشروع D Projektart F Type de projet US Project Type ZHS 项目类型 10 60 1=1 exists (select null from pa_tasks pt where pt.project_id = p.project_id and pt.task_number = :toptask_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' ) and ptav.parent_task_id is null order by ptav.task_number AR المهمة الأولى D Teilprojekt höchster Ebene F Tâche supérieure US Top Task ZHS 顶层任务 11 2=2 pt.task_number = :toptask_number US Top Task 12 70 :p_report_level LOV custom Y select x.id, x.value, null description from (select 'P' id, 'Project' value from dual where :$flex$.top_task is null union select 'T' id, 'Task' value from dual ) x order by value T Y US Report Level 13 80 :explode_sub_tasks LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.report_level = 'T' AR تقسيم المهام الفرعية D Aufgaben aufgliedern F Eclater sous-tâches US Explode Subtasks ZHS 展开子任务 14 90 :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 成本预算类型 15 100 :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 收入预算类型 :$flex$.operating_unit Operating Unit Project Name :$flex$.operating_unit Operating Unit Project Number :$flex$.project_name Project Name Top Task :$flex$.project_number Project Number Top Task :$flex$.report_level Report Level Explode Subtasks :$flex$.top_task Top Task Report Level Default Y Default detailed extract SYSADMIN 9 ACCOUNTS_RECEIVABLE 19 ACTUAL_COST_AMOUNT 20 ACTUAL_HOURS 18 ACTUAL_REVENUE_AMOUNT 45 ACT_MGN_ITD 44 BGT_MGN 21 BUDGET_COST_AMOUNT 22 BUDGET_COST_HOURS 23 BUDGET_REVENUE_AMOUNT 24 BUDGET_REVENUE_HOURS 30 COMMIT_AMT 42 EST_TO_CMPLT 40 FIN_PCT_CMPLT 7 FUNCTIONAL_CURRENCY 41 HRS_PCT_CMPLT 29 ITD_ACT_COST 32 ITD_ACT_HRS 27 ITD_ACT_REV 31 ITD_BGT_HRS 28 ITD_CST_BGT 48 ITD_ORIG_CST_BGT 46 ITD_ORIG_REV_BGT 26 ITD_REV_BGT 1 OPERATING_UNIT 25 OVR_BGT 51 PROJECT_ID 3 PROJECT_MANAGER 6 PROJECT_NAME 5 PROJECT_NUMBER 2 PROJECT_ORGANIZATION 4 PROJECT_TYPE 34 PTD_ACT_COST 36 PTD_ACT_HRS 35 PTD_BGT_HRS 33 PTD_CST_BGT 17 TASK_HIERARCHY 52 TASK_ID 13 TASK_LEVEL 15 TASK_NAME 14 TASK_NUMBER -51.0052 TASK_PATH 16 TOP_LEVEL_TASK -15.0016 TOP_TASK 8 TOTAL_INVOICED_AMOUNT 39 TOT_BGT_HRS 38 TOT_CST_BGT 43 TOT_CST_ITD 50 TOT_ORIG_BGT_HRS 49 TOT_ORIG_CST_BGT 47 TOT_ORIG_REV_BGT 37 TOT_REV_BGT 10 UNBILLED_RECEIVABLE 12 UNBILLED_RETENTION 11 UNEARNED_REVENUE US S Site Pivot Summary SYSADMIN 9 ACCOUNTS_RECEIVABLE 22 ACTUAL_COST_AMOUNT 23 ACTUAL_HOURS 21 ACTUAL_REVENUE_AMOUNT 48 ACT_MGN_ITD 47 BGT_MGN 24 BUDGET_COST_AMOUNT 25 BUDGET_COST_HOURS 26 BUDGET_REVENUE_AMOUNT 27 BUDGET_REVENUE_HOURS 33 COMMIT_AMT 45 EST_TO_CMPLT 43 FIN_PCT_CMPLT 7 FUNCTIONAL_CURRENCY 44 HRS_PCT_CMPLT 32 ITD_ACT_COST 35 ITD_ACT_HRS 30 ITD_ACT_REV 34 ITD_BGT_HRS 31 ITD_CST_BGT 51 ITD_ORIG_CST_BGT 49 ITD_ORIG_REV_BGT 29 ITD_REV_BGT 1 OPERATING_UNIT 28 OVR_BGT 54 PROJECT_ID 3 PROJECT_MANAGER 6 PROJECT_NAME 5 PROJECT_NUMBER 2 PROJECT_ORGANIZATION 4 PROJECT_TYPE 37 PTD_ACT_COST 39 PTD_ACT_HRS 38 PTD_BGT_HRS 36 PTD_CST_BGT 13 REPORT_LEVEL 18 TASK_HIERARCHY 55 TASK_ID 14 TASK_LEVEL 20 TASK_MANAGER 16 TASK_NAME 15 TASK_NUMBER 19 TASK_ORGANIZATION -51.0052 TASK_PATH 17 TOP_LEVEL_TASK -15.0016 TOP_TASK 8 TOTAL_INVOICED_AMOUNT 42 TOT_BGT_HRS 41 TOT_CST_BGT 46 TOT_CST_ITD 53 TOT_ORIG_BGT_HRS 52 TOT_ORIG_CST_BGT 50 TOT_ORIG_REV_BGT 40 TOT_REV_BGT 10 UNBILLED_RECEIVABLE 12 UNBILLED_RETENTION 11 UNEARNED_REVENUE PA Revenue, Cost, Budgets by Work Breakdown Structure 31-Mar-2025 051220.xlsx US UEsDBBQAAAAIAKR5qFyQ7xzWmgEAAG0HAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbM2V30/CMBDH3038H5a+mq2AiTGGwQPqoxLFP6CsB2vY2qZXEP57bx34g0yQgNGXtVt79/20d7vr9pdlES3AoTI6Ze2kxSLQmZFKT1P2MrqPr1mEXmgpCqMhZStA1u+dn3VHKwsYkbXGlOXe2xvOMcuhFJgYC5pWJsaVwtOrm3IrspmYAu+0Wlc8M9qD9rGvfLBe9xYmYl746G5Jn2sSBwWyaFBvrLRSJqwtVCY8rfOFllsq8VohIcuwB3Nl8YIwGG9UqFa+F1jbPdLVOCUhGgrnH0RJGHxZ8FfjZmNjZsluJw2UZjJRGUiTzUs6WILWgZCYA/iySMKYlELpDfcO/bAZeRjaJwapzhccH8jR+Sccl3/EYdXC+IGg34B/TCm7lVZVSp46TE0aeyLWSPgEmXESfw9vLbCHzVP1AB6ex6MEN3sE0a8KwBPnSu10n3IuHMhn76jOnhzgs++fpMNIjIm4ztgwP/72v9a1D8+7cKgoDp2xSO3BweFB2dT/yjq25AicV7sD8a5IreVwwa1SDlXzkiAbtHlolr03UEsDBBQAAAAIAKR5qFy1VTAj7gAAAEwCAAALAAAAX3JlbHMvLnJlbHONks9OwzAMxu9IvEPk++puSAihpbtMSLshVB7AJO4ftY2jJED39oQDgkpj29H2588/W97u5mlUHxxiL07DuihBsTNie9dqeK2fVg+gYiJnaRTHGo4cYVfd3mxfeKSUm2LX+6iyi4saupT8I2I0HU8UC/HscqWRMFHKYWjRkxmoZdyU5T2Gvx5QLTzVwWoIB3sHqj76PPmytzRNb3gv5n1il06MQJ4TO8t25UNmC6nP26iaQstJgxXznNMRyfsiYwOeJtpcT/T/tjhxIkuJ0Ejg8zzfinNA6+uBLp9oqfi9zjzip4ThTWT4YcHFD1RfUEsDBBQAAAAIAKR5qFzSY4fBzgEAABkEAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJ1TS0/bQBC+V+p/WPbCBWKnIFRFayMaijj0EREDx2pYj+MV611rd2wl/fVd20piSgRqb/Oeb76ZEZfrSrMWnVfWJHw6iTlDI22uzCrh99nN6WfOPIHJQVuDCd+g55fpxw9i4WyNjhR6FkoYn/CSqJ5FkZclVuAnwW2Cp7CuAgqqW0W2KJTEayubCg1Fn+L4IsI1ockxP613BflQcdbS/xbNrezw+YdsUwfAqcgsgc5UhWksor0irupaKwkUpk+/K+mstwWxr2uJWkRjpwiolygbp2jT1RirYilB4zw0TAvQHkW0N4hbhI7MBSjnU9HSrEVJ1jGvfgc6zzl7Ao8dzIS34BQYCnC7sEHpZV17cumjdc++RCQvop2xF8exY1mdp2d9QBDeDBwa/IAKc3YHZoX/0mJ6uEUPrJ819H7JQqZIo/9ZLMDRe6T00AZKBpSLK3aHLZoGT9jcejphX5p8FVhhTxv2aMfc7HNUa4ktm6oCtzkcAS5MT+ERDrqP3+l6fPTrRumQfg0E3UZfrWjLxF+zf1Pm2d/XmQ2JuD2fl0axLMFhHi5ud147g7gNl+N0V2RedovLtzGvHd2xPwyfnk4vJvFZHO54ZBPR/qfTP1BLAwQUAAAACACkeahc/gy0HzoBAABRAgAAEQAAAGRvY1Byb3BzL2NvcmUueG1shZJRa8MgFIXfB/sPwfdETbpRJElhG31aYbCMlb2J3rZh0Yi6pf33M0mbtlAY+HLvOffzeDFf7FUT/YJ1dasLRBOCItCilbXeFuijWsZzFDnPteRNq6FAB3BoUd7f5cIw0Vp4s60B62twUSBpx4Qp0M57wzB2YgeKuyQ4dBA3rVXch9JuseHim28Bp4Q8YgWeS+457oGxmYjoiJRiQpof2wwAKTA0oEB7h2lC8dnrwSp3c2BQLpyq9gcT3nSMe8mWYhQn997Vk7HruqTLhhghP8Xr1ev78NS41v2uBKAyl4IJC9y3tsxD2nMRFtdw51dhx5sa5NMh6Dd6UgxxxzmQUQjAxrgn5TN7fqmWqExJ+hCTLM5oRTJGU5bSr/7Kq/k+0NhQx4v/Jc5iMqsIYeHQ+QXxBBhzX3+C8g9QSwMEFAAAAAgApHmoXE1B1tIaAQAAewQAABoAAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc72UwUrEMBCG74LvEOZu03Z1Fdl0Dy7CXnV9gNBO27BtEjJxtW9vrNBaWOoeipfAzCT//zHMZLP9bBt2QkfKaAFJFANDnZtC6UrA2+H55gEYeakL2RiNAjok2GbXV5sXbKQPj6hWllhQ0SSg9t4+ck55ja2kyFjUoVIa10ofQldxK/OjrJCncbzm7rcGZBNNti8EuH2xAnbobHD+W9uUpcpxZ/L3FrU/Y8E/jDtSjeiDqHQVegFDinhfWUWBGPh5mPslYaiWDotX70KvaQSapOdg0iVhLuhMOgeT/DNMMgezXhKGfNeEoR8G5iees79b0t6HVcLRvQ95f8624HZJBqtOxj/JsNU7LJVW33s/Io1Vfu7igMknX0b2BVBLAwQUAAAACACkeahc4it/e7sAAAAzAQAAMgAAAHhsL3Bpdm90Q2FjaGUvX3JlbHMvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbC5yZWxzhY/BasMwEETvhf6D2HstO4dQiuUcEgK5BucDFmlti9haoVVC/PfRMaGFHodh3sy0u8cyqzsl8RwMNFUNioJl58No4NIfv75BScbgcOZABlYS2HWfH+2ZZswlJJOPogoliIEp5/ijtdiJFpSKI4XiDJwWzEWmUUe0VxxJb+p6q9MrA7o3pjo5A+nkGlD9Gkvz/2weBm/pwPa2UMh/VOjo75z3WOadyXJyUuCYRsoGfllNVaaD7lr9drV7AlBLAwQUAAAACACkeahc3uza4ZQEAACGJwAAJwAAAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbNVaW2/iOBR+X2n/gxVp3yaFQKAFASOuGqS2VC2dfTaJAW9jO7IdFnY1/32PkwCZpdPC7FLhPlDimHO+cz++tD6vWYRWRCoqeNvxrsoOIjwQIeWLtvM8Hbk3DlIa8xBHgpO2syHK+dz59ZdWTFdC93GwJAMyp5xqIICAGFdtZ6l13CyVFLxkWF2JmHB4MxeSYQ2PclFSsSQ4VEtCNItKlXK5XmKYciej0JTH0BDzOQ3IQAQJI1xnRCSJsEGiljRWW2osOIYcw/Ilid1AsBhIzGhE9SYl6iAWNMcLLiSeRaCCtdwSXh/iZDSQQom5vgJCpQzigbSeD0BX1OjcQbJJw7Yjx6EH38lcErWc8FuBYXA/QsLepu10E70UwD2fRsIB1gDIr13XvKua7/k3dc/8VQEyVQpsONaEqVvKqG47YNoAtK5J+HVrbzDujlZxkFH+mEExIu/eAF1JAiHDvkg4UAR8a9lMDP6/641qzWvU627Nv264ft333V61MXS9Wq/cH9W6fqNb/eZ0WoFxmSeRyIAgvYkB/p9CvqSeAG933/MZgA7E9pq9fgX80ExqOw9d9EhWhCfkE+oLpT+hXhIuiFZotkG/C6fUaZUKXHKWI0qiUKEgQ16rbaGk44hjBkgmMZFge75Az+DQDuIJGzE9BvHKMB2UIUmYanTHIv11kUNO6UGKP0ig0UQuMKd/pT75Br0tLM+wQau2c99NxSiw3Ar1Hsc7zPGCgJP8EPz/yGwKBvwYTvcJm32UVPfgDOeVapTwwLgEjlA/kRIy7uYUhs9Pg1PdYyo0MBvzlYCEFKIuM3HwNk+uISOre8GzLGPSh8jGnrRM60NhqBdh/pJmhDzCjCuzE324G6Q/VhDfAaErk3suDeIzh8oQgQYvGSLBkqcQ0yx5wSrUULjfzYwf74ePJBZSo1vQX3QO7b1bPqZYvRzP/okwekfXJDTpGNqvtyM1y6R5qGa6HXNNoGakY1D6v+IogYA3D3i9fygENjc1yjs5BxmpTk/kP8nn7El8KuLMRsiY6xx+8l9yaepCXyg0NDJYvlVdjnPG4xuZnwvX41Ac1dycCUA30AmU0DypvlJB/X81iftyeZ74hDDfx2d53/b+qEPMBTAts73ov8DKARZ2++b20rWerU3ShYqFWi+it1X19kZsrv2tANYZYAIbS/ni/Bzl8d2aMZ4Ocvav9cKXnjkM+u+Ljk15r6B7k/tsg14oljZB7wsGe30WFpqCu1iX5gqBah32h32KtC1MDXRLw7SgdSs9Jle7ddink6nFDUEBvW2xWoBundNke+XoN1jDsTgi+rsN1UtvIlNtW4p9qKiGE2M4JxRW6j47c0lX/tAi2NRG5gvPOywX5lDent2WvDBlwG3T+kTSBXINaouLVC6E3ZX20BK2FdxDM9gvgXWdw/YWyDg8ZvvrTMd4px4TpAdHl4w4u9yT3efptMha3yqd/keJpHAT6bpS6w4r3aHb8Bue69/MiNur9HzXH/Ya1/6oXy3f+N92V7g8/+By2FF3uMqNUiO7s9ZprT2/+dp9OLNBCbiyzxRl6bVpnX8AUEsDBBQAAAAIAKR5qFxUjeQ8GAEAALUDAAAkAAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlUmVjb3JkczEueG1szZPBSsQwEEDvgv8Q5r5NKyKytF1EEbx4EP2AbDrdBptMyKSl+/emu6yXXlZWxENgwjAvb4ZJuZlsL0YMbMhVUGQ5CHSaGuN2FXy8P6/uQXBUrlE9Oaxgjwyb+vqq9Gak+Kh0h2+oKTQsEslxBV2Mfi0lp4xVnJFHlzItBatiuoadZB9QNdwhRtvLmzy/k1YZB0fCOpzDoLY1Gp9IDxZdPEIC9iqmPrgznk80q8/BWRU+B7/SZH1CbE1v4v4ABWH1+mXnKKhtn/qfwgk8LT2t0YGY2pglkDwqLrotbpPoaOaBg9A0uJjmDnUZ6pLFWMHrA8i6nOYw/6vI/uDFg6QsZrW5bD7uW/aS6PdIl1j8p1qZdkIuPlr9BVBLAwQUAAAACACkeahcCkEM6r0AAABHAQAAKQAAAHhsL3Bpdm90VGFibGVzL19yZWxzL3Bpdm90VGFibGUxLnhtbC5yZWxzhY/BCsIwDIbvgu9QcrfdPIjIOg+K4FX0AUKXbcUtLW0VfXvrbQPBY8if789X7V/jIJ4UonWsoZQFCGLjGsudhtv1tNqCiAm5wcExaXhThH29XFQXGjDlo9hbH0WmcNTQp+R3SkXT04hROk+cN60LI6Y8hk55NHfsSK2LYqPClAH1jCnOjYZwbkoQ17fPzf/Zrm2toaMzj5E4/ahQ3j5dOmB+70itZfsVyHwMHSUNUk4CP7OlzDqg6krN9OsPUEsDBBQAAAAIAKR5qFxkaFvpCwYAAOciAAAeAAAAeGwvcGl2b3RUYWJsZXMvcGl2b3RUYWJsZTEueG1s7Vpdj5s4FH1faf8D4p0SGCDJKEnFJEEdqbs7ame7zw6YxCpgZMxMotX+9722+c5EzTSd7T7kodP4Yl/OPb425h5m7/dpoj1hVhCazXXr3UjXcBbSiGTbuf7nY2BMdK3gKItQQjM81w+40N8vfv1llpMnyh/RJsErHJOMcHCggbOsmOs7zvNb0yzCHU5R8Y7mOIMrMWUp4tBkW7PIGUZRscOYp4lpj0aemSKS6crDbRqe4yRF7GuZGyFNc8TJhiSEH6QvXUvD2/ttRpnAN9f3rHa8Z0eOUxIyWtCYvwNHJo1jEuIjfJZjMvxEBEvgit2WJJrrfwfW2l+6wdgYrb2J4dyMLGMSjKaGZfvj1XrsTj3L/UfXMpQCiIeGMEvXQgTc3IMPe3KjayjPk8PvZbrBLFAkzXWYCGm+oyx6wRzQjB/1fUCcY5Yd2f2EbLMUvzDiLxLx3QdMtrvWG8CLEEdLlIs5netfUFLCrGtlDmYcfamTBTIjJdknHDNc7ATRzRUIqdjR5xUjSSIjKQvsl5wqYFzmFtyFcJw+MJLxR8ITDDELYiAvBjchWQTQpR851WHv9wqgymtpmXCSJzggOIkCkgATksbFLKEh5AekJ8PxXPed28eprsWEFfwDJCFmn+iz9CBNwp80AJjGsKQQhwVhMfr8gLZ4SUuBSOClSc9gLtTKkCgKuCw7ui7AaO29OGjJEyKWFiAQrPmKs54jDe0JBCP+ArY+DyfGL2aC3gaBDQCEQdtXzmUDoEU4RsCcuJ8pRyxmeM8/Flz+r5WMQKLbU8dbryae4VtjFxLdRsbEX1qG56xHS9fxVpDukOhq8e4t5/sW2WhqTtU2sJiBk9sOYTFk0oo+Zx/RBicyUwReAKj+Srhm279H9uu50ypSPpcbTjmS8zHg0xryeSWvStwrefXy/45VeyXvEvJIVmDG7xKUfa228OsuWD2K/uNc/H/sxVcU7UP9ysW3uegeL195LBOHwLc+l/3AKSwo44+HHE6dqAhxJl734NSvjoLfc+r5cdAu2LFPgThjWn/OXftn/DNgXjhAvNbJF5Pq1aV9mTor26/DfxZ1F6VGVqZBykWxwYFXzLNmunu/6/Ardde0+WaF5qIlel2U36h/XTckVfS8cDN+dZ6dHtA5bEHJEOqi/YonFEsXs1icNUTFUZbrmpbda930Wm6v5fRaXq817rUmvda017JkNbUF00dj9W9iSQRmE5CM7b5bShW1XAIVSuj22n8mjCPdqqsGeoRgSjhqLm5EAQNqzS9cqqu1gxFbBgpNx42ALzEvZlCgHsxMd2IMORdm00n270U7bqNVAKEeLIqfe+2pLsPWZlFjlmbltDbL+IRZznRjdmqz5L8xC3ZlbzUPtROvNsskEGYBuooxh5ev4yAbqxbLEy+U73cEA6uGqh63oxaz5mjbFMxF3I21knA0P+QlSrRP+AlnJdb8VJT3QScQ/m1YnhtUKCDygC1aAuFg5VqeDO2U8yUt+MBz5etSzx9oyUDHUWjtC9HeldEWc+0FtMDzRTx0PfcgOz/G8cuz557tXGbg0exVqGvnPeAgSL6GEbPNRti2lCDYKEli9UqTFu1jcTK1prW25IN2JqW7P7LkIJOuu33L/e+BFlKpVYoG6GGYgdyLG/diZTdW0L9kKgM1lY4FLo+KBGoxta5qIUaggd8K7BHoSQ90dSNQFLksSmxKzoXS2gsmEdqPCg0WRDe0gcIziFQ+KE7hEMtc6kaSvAoHyINvgEM+ok7hEPvbEQ54cL0FEPl0PAWkUSq7hFhA+Bswoh7MDZLqBzy02o8LPvNDgu+zmHZVdGn8DUekTGGqhGgK5X6l5SoVWZhAsx2aoNdnzkgutOZKbYVeQ9NHVHAwl6n4IEIAPNZDp569DtyVZbhL3zaccHpjTNaBY6zuAnc5cp2b6cp+Iz10+MnFjkRYKfS1al2psPDYGXyH8eKXDngf4u4XGI2u2qq/Y2fse5bnGNbE9Q1ntFqC+uu7RjCyXMt2rdHKddpo8wj00nPuPPwGxPLUmbLaYRJ0gDUuHvvgUWnBg9hhwAkReNBx8S9QSwMEFAAAAAgApHmoXA7kec0SBAAANhEAAA0AAAB4bC9zdHlsZXMueG1s7Vhtj+I2EP5eqf/Byn5tyAsJRyjhdLykOunuVHW3UqVSVSZxwDo7Ro7ZQqv77x07gQSOXdjt9qST7guxx/YzM56ZxzbD11vO0D2RJRVFbHkd10KkSEVGi2Vs/XqX2H0LlQoXGWaiILG1I6X1evT9d8NS7Ri5XRGiEEAUZWytlFoPHKdMV4TjsiPWpICRXEiOFXTl0inXkuCs1Is4c3zX7Tkc08KqEAY8vQaEY/lxs7ZTwddY0QVlVO0MloV4Oni7LITECwambr0Ap2jr9aSPtnKvxEg/08NpKkUpctUBXEfkOU3J5+ZGTuTgtEEC5OcheaHj+ke+b+UzkQJHknuqw2eNhsWGJ1yVKBWbQsVW9yBC1cjbDGLcCyxURWUiMtinLJt3OJ93drs5Wq0GnA/K0nL2YEcrw+OVNz/c3Lgd1/0T/fj7LyT7Y27vJXP0AAJEqa37eLXuVSud2pPRMBdF45APe6/jN/hYiL+KRA+BQ+ClnjUaln+je8xA4mqMVDAhkYJsBCc9Yw/mpJoxwYwuJNXCHHPKdpXY1wKTwPU8TiGdjEGVhup3oWf977qMyhJ0UsYOIQ20syAYDSH7FZFFAh1Ut+92a3C1gEKtTDbzLsxeSrzz/PD6BaVgNNNWLCdmg+VyEVtJMnszSxIDs6gHaJGRLYGMg4TT5rQMvta4U111MCGBFdUJ7nZeRVHU93r9fj8Kul4QmAg+xQKzS7DLCyEzoMF96eikqkSjISO5AlRJlyv9VWKtdQilgCpGw4zipSgw0y7uV9QNgE0JY7eaKn/Lj7C3eauwgHR1rHV16iYYVDcrvKqj8dtoFXYbVtv8dFy0zQ8KHlrtNVZBCbatOqxGeL1mO12SutjqHnhSl94Rck1Blzw+wf6w4QsiE8Nc51CDq7bxiaBPxFzTe6HGG0gNfZrqmJ04bhj0hR33eoZVXxj1vOfdx8P/YMDP+/042mnALyXV+V14SR3/LRsq+8+ksalrqOQWXRyRxaHskT7BYuuDrgEGZ2FduWixoQwY8QxRAGa2bajHd4EjQHDxWNgz755Kr2TesyTvGIXmpzrWT6mvuYv8RAoiwTVNdl/TqguH7Lfd3N8+TQVdive33fxa6+BL1vcXzxLNSMCnSj8vzZ3uQNKQ1RnJ8Yapu8NgbDXt9ySjGw5Xp3rWz/qaYCBiq2lXsyJNfmSr3pXw0oAv2kgaW//Mxq+i6Szx7b477ttBl4R2FI6ndhhMxtNpErm+O/nUeuQ+7znp6ieueZPDzcULBiWDh7Csna2Nv21ksdXqvNP3Y3PnccDstu2R33PfhJ5rJ13Xs4Me7tv9Xje0k9Dzp71gPAuTsGV7+DzbPdfxvMb4cKAoJ4wW+1jtI9SWQpCg+4gT2hUTCaf5w2P0L1BLAwQUAAAACACkeahcwofb8lEGAADXGwAAEwAAAHhsL3RoZW1lL3RoZW1lMS54bWztWU9v2zYUvw/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+a1zzdKNvwBQSwMEFAAAAAgApHmoXIsfMEPqAgAAjgYAAA8AAAB4bC93b3JrYm9vay54bWylVV1v2jAUfZ+0/+BZSH1pSGxCiCKgagtoSN2E1q59RCYxYDWJI8eBoKr/fdcJ4WM8rOoicLi+9vG5x8emf1MmMdpwlQuZDjBpOxjxNJSRSFcD/PtpYvkY5ZqlEYtlygd4x3N8M/z6pb+V6nUh5SsCgDQf4LXWWWDbebjmCcvbMuMpZJZSJUxDqFZ2ninOonzNuU5imzqOZydMpLhGCNRHMORyKUI+kmGR8FTXIIrHTAP9fC2yvEFLwo/AJUy9FpkVyiQDiIWIhd5VoBglYTBdpVKxRQxll6SLSgUfD77EgYY2K0HqYqlEhErmcqnbAG3XpC/qJ45NyJkE5aUGH0NyQYSNMHt4YKW8T7IygtZYoEK9Nabk/0YjYK0Gjn4SrXvgRvGwvxQxf66ti1iW/WSJ2akYo5jlehwJzaMB7kEot/zY4WKkiuyuEDFkqd+lHraHBzvPFAJYzdVMiQ0Ld3AmMFqLiM/ERuqJ4HH0IHJddUd8yYpYP4HjGx7QT11aQ5YqaJScaYXg93T0AMwe2QZ4ghrR3sZTIEI68zRUAZm/dUdezx+Pfavjdj3LHU96lj+ixPInHvG7Y9fpjSfvIKXyglCyQq/3EhjoAXah3ovUD1Y2GeIEhYiONN6c/WOZ919Nk3s35ZjD/iz4Nj+KZUJUvog0ktsB7vjUh6p2TWwRCuG2yr6ISK/NEM899H3nYrUGyhQkg04WarHhT2xRaQsHzBAd4DOCo5rgBJ6qOSNonzCsbhlgWr1RWjljdot+8Q1PC36N7mWur9FdEa1gGFrs0IuEe84MrjYDLBKYxdU0Iqb2MxhjBPRYJHB57E4mdU4m0YtJTAEHsBVcUIdl4Ao5LNMxM+yGNjhLpDwyjoYiTqJ9KfMyTpP2fFI5dcQ0W7CcG6OHLH5sqnDw8OofNV99a922SNC6u2+Rvn2yDnA55wDAIZwN86oUopSSSprMyHHP4NoHpscARkKXGUr9U2Xcqs6zSXbzVzL8A1BLAwQUAAAACACkeahcyKG4+rgAAAA0AQAAIwAAAHhsL3dvcmtzaGVldHMvX3JlbHMvc2hlZXQyLnhtbC5yZWxzhY/BCsIwEETvgv8Q9m7SehCRpr2I4FXqB6zptg22SchG0b83xwqCt9kd9s1O1bzmSTwpsvVOQykLEOSM76wbNFzb02YPghO6DifvSMObGJp6vaouNGHKRzzawCJTHGsYUwoHpdiMNCNLH8hlp/dxxpTHOKiA5o4DqW1R7FRcMqD+YopzpyGeuxJE+w45+T/b9701dPTmMZNLPyJUsE+fWrxNlKkYB0oapFyseaFLmX8HVVfqq2v9AVBLAwQUAAAACACkeahcajB8XrYEAACuEwAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbKWY227jNhCG7wv0HQRd9GojiTr4VNuLTYJgF2iBYNN2r2WJtoVIokpROS367p2hPKKCbAPRXWTNsWn9HM58HJNcf3yqSueBy7YQ9cZlXuA6vM5EXtSHjfvnHzcXC9dpVVrnaSlqvnGfeet+3P780/pRyPv2yLlyQKFuN+5RqWbl+2125FXaeqLhNfTshaxSBW/lwW8bydNcP1SVfhgEM79Ki9rtFVZyiobY74uMX4usq3itehHJy1SB/+2xaFpSq7IpclUq77vmIhNVAxK7oizUsxZ1nSpbfTnUQqa7Eub9xOI0c54k/IXwP6Jh9OdvRqqKTIpW7JUHyn7v89vpL/2ln2aD0tv5T5JhMQTgocAEGqnwPJdYMmiFRiw6Uwwz0zuG4ZKrrsg37vfg9O8CWoYvgXmhvn/c7TovIMP4sCP5fuN+YqvLq9D1t2sN0F8Ff2xHtoM87oS4x44vME4AEk1ac+f5roGsAtuuo0TzG9+rK16WIAgzTDNVPPBb+NrG3QmlRIX9mngFH+2leOG1HpOXHL4LzqDm6y/3Ika0/bt3WDvrD96ObfL8Rq+OW+nkfJ92pboS5bciV0fwlnlxmMwXLExc6v0qHj/z4nDEyYTeHDo0fav8+Zq3GSwHmLWnR81ECUPAq1MVuKyB5vRJt48neXh4x1t1c4pM1rUweRr7JNE/DGHSD0N7ejicjXybqAIEaBVoSSXywkXCkhnOcKJKfFKBliaysPcFxtO+QEu+QGQmuoCVAR+G1oRjzoJlhAmZKDI/iUBr5rFIkni2sFCB0qxdgXaYh8fiwCaiy5MGtOTJ0j6iDH42esLAGHQmh4MNgI4IXXjJPIg0/xOjyghVNExcrSljBCsaP9J5Z7UwQhQNepbZZoURomgMS9azJoQRrWiY/FoywghXNN6qvBcNQpQZRtnMs10ujCgNR3iNZN6rXoRWaNAKQ2u0wqEKjtACryaSGRJRaFAEz6h/IdGFhsmEbTxxTfU1fYQXZGjqbIiqcFQEz5kNcRUarkJmnxuCLBxBdo47A2WviqFtFYqoFqLxP6p7ROSiQToQ8IlJiohYNEwJsVz60fC7PQJ3Zv/DHRG4aJA38zN0iNxoVNDO2Y4QetGopCXW6EWEHhpmWrbrMSLy0BhSbV/uY0IPDdoSgDkRmZiIQ8O4YfahU3UIvXiE3ty66sfEHhqm2Nmux3jYNL5Cz/q3NCb00BiCa41MTMUTDZpVbLtBiIlfNOz39DFxi4bh1j7TBG5swA1j65gkxC0aFNrp+76EuEXDZMY6wwlxi4bZUVvvHxMCFw3Ssd9zJAQuGpSkwHoZJcNxx3A7eW/t9ydJfYi9TlVKh9jeTjslbopScTk6o0MOfnjWX/7nWR8OrE164L+n8lDUrVPCERxPskC27E+72obDu7aQC31Up3dHuFTicHkSeBDuvRDgTv/mpHvHVdfAub3h8q54gcM7sCpkAedlfWu0cUu43moz6HedI3S8COgpr5sCLxHwbkwV2fAeNPvxbvRA27XI88/6g+0vadX8enX7yfnKH3jd8Q/OlWjVB+eyyw9ctc7u2fkGlxTOJdyC3efisXbulOwy1Um+9o3M2n89gD/ctG3/BVBLAwQUAAAACACkeahclf+SuQAFAACRFAAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbJ1YW5OqOBB+36r9DxTvAkFRtMRTs17m7niZs/uMGJUaIC5kbmdr//vpEAGJTAqmahxif91fmu4vATP88REGyhuOE59Ejoo0Q1Vw5JGtH+0d9efzrGWrSkLdaOsGJMKO+okT9cfozz+G7yR+SQ4YUwUYosRRD5QeB7qeeAccuolGjjgCZEfi0KXwNd7ryTHG7jYNCgPdNIyuHrp+pHKGQVyHg+x2vocnxHsNcUQ5SYwDl0L+ycE/Jhlb6NWhC9345fXY8kh4BIqNH/j0MyVVldAb3O4jErubAO77A3VcT/mI4c+ETzubJrVfzBT6XkwSsqMaMOs858vb7+t93fVypsv7r0WDOlCAN581sKAyv5cSsnIusyBrf5OMdYYnxsoVD179raP+1+2h7sQyx62r9nTc6hhmt2XbU7PVuZpZve7UNmd98391NNz60GEWrMR456hX5uC5r+qjYaqfv338npyNFepu1jjAHsUwB1IVJs8NIS/M8RZMBjAe3QgrH+sjNNlRLVX5PA07qkLJ8QHv6BgHgaPOAHM96r/hBUQ46oZQSsKVvz/QdDFQsO1i8gtHaT7ptCxPxu+oQHVy5RwnTsgp+Te9kxmqCuOTsCSyyXngFSRzCoRhxXyl7EpTFpFwRxCp56U7H2dlnKUrdRErW7xzXwO6Iu83mN0z1NPUekCWan2w/ZzgxIPFB0XVTMbrkQBI4L8S+mwTgbXjfvAu+Ft6cFQTNhHvNYH7+4cb0grkASC1NACuWQDMJgkAOaUBcM0C2hrqGF0T4jY4oTPWYZhfwgFNTzngeuJoI83qGW3UgASmS0ngWiRi2haymqTCNhvGAtcTC7Ibp9I7kcA1S8XQbMvqdG3Wu5pVgUalqcC1SKUxS//EAteCpXFZEDyLuJBgUPA07DPK5VjoEfWaVwZlKmWDPJvahUWZZtkgC0dax7R6dhPFoUy3bFA0uoeMfrtBn1GmXDbI0ulpzXuUaRediRd9gyeTLyr0i0CENWXLXLlUzoQLGdUNzwSLCsWazXcDMxOseSa1ft2VrPNtNN2jJy51R8OYvCvwUgB6S+DRAq9YaMCmqNyGYTtlvlfMOd3UYANM4Jn3NjKG+hvs997J4y/wyDGUYzpMls8I4fVnZM7lGU1hxkuPdtljfOnRKXtMLj2sssf00qNb9phdevTKHteXHnbZ44Z7sB0pL2K/7HJb4YKEJtxV+RTNSFt5X+UjlPbhMmEk1PaxwkUo7vxcLkio61MJFEq6KIFCNZclUCjkqgQKJVyfg6ZQu+cS+IWC2atP7TUDznkzTVG8MnAsAycycCoD2ftnkZDQz+sSKHTyRgbeysA7GXgvAx9KoKCeR9l9zlmX2MtTxTb1JMEWEmwpwVYSbM2xblUuz9VxpS0THjb1BQfOXwtOBo5l4ITl4KjwAC3IhfU6zVzY6zfbZGai4Vo03IiGW9FwJxruRcODaHgUDXNusCulIMEWEmwpwVYSbM2xfqUUquNKUoAG1JbCnDmzJZA15Ek0LETDUjSsRMOaG7o56fOZRylVdrhTe5sE5y+FNWdMXy1lCbaQYEsJtpJga45VL+XquFJR4B2wflHAuSiK8ACcM6aviiLBFhJsKcFWEmzNseqiVMfxovBDA/5CenT3+NGN936UKAGcVLATAJBWzE8J0jGcfqQj9pMzPdHIvh3g6A/DjmNo8ANoRwjNvrCDifwwcfQbUEsBAhQAFAAAAAgApHmoXJDvHNaaAQAAbQcAABMAAAAAAAAAAAAgALaBAAAAAFtDb250ZW50X1R5cGVzXS54bWxQSwECFAAUAAAACACkeahctVUwI+4AAABMAgAACwAAAAAAAAAAACAAtoHLAQAAX3JlbHMvLnJlbHNQSwECFAAUAAAACACkeahc0mOHwc4BAAAZBAAAEAAAAAAAAAAAACAAtoHiAgAAZG9jUHJvcHMvYXBwLnhtbFBLAQIUABQAAAAIAKR5qFz+DLQfOgEAAFECAAARAAAAAAAAAAAAIAC2gd4EAABkb2NQcm9wcy9jb3JlLnhtbFBLAQIUABQAAAAIAKR5qFxNQdbSGgEAAHsEAAAaAAAAAAAAAAAAIAC2gUcGAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc1BLAQIUABQAAAAIAKR5qFziK397uwAAADMBAAAyAAAAAAAAAAAAIAC2gZkHAAB4bC9waXZvdENhY2hlL19yZWxzL3Bpdm90Q2FjaGVEZWZpbml0aW9uMS54bWwucmVsc1BLAQIUABQAAAAIAKR5qFze7NrhlAQAAIYnAAAnAAAAAAAAAAAAIAC2gaQIAAB4bC9waXZvdENhY2hlL3Bpdm90Q2FjaGVEZWZpbml0aW9uMS54bWxQSwECFAAUAAAACACkeahcVI3kPBgBAAC1AwAAJAAAAAAAAAAAACAAtoF9DQAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlUmVjb3JkczEueG1sUEsBAhQAFAAAAAgApHmoXApBDOq9AAAARwEAACkAAAAAAAAAAAAgALaB1w4AAHhsL3Bpdm90VGFibGVzL19yZWxzL3Bpdm90VGFibGUxLnhtbC5yZWxzUEsBAhQAFAAAAAgApHmoXGRoW+kLBgAA5yIAAB4AAAAAAAAAAAAgALaB2w8AAHhsL3Bpdm90VGFibGVzL3Bpdm90VGFibGUxLnhtbFBLAQIUABQAAAAIAKR5qFwO5HnNEgQAADYRAAANAAAAAAAAAAAAIAC2gSIWAAB4bC9zdHlsZXMueG1sUEsBAhQAFAAAAAgApHmoXMKH2/JRBgAA1xsAABMAAAAAAAAAAAAgALaBXxoAAHhsL3RoZW1lL3RoZW1lMS54bWxQSwECFAAUAAAACACkeahcix8wQ+oCAACOBgAADwAAAAAAAAAAACAAtoHhIAAAeGwvd29ya2Jvb2sueG1sUEsBAhQAFAAAAAgApHmoXMihuPq4AAAANAEAACMAAAAAAAAAAAAgALaB+CMAAHhsL3dvcmtzaGVldHMvX3JlbHMvc2hlZXQyLnhtbC5yZWxzUEsBAhQAFAAAAAgApHmoXGowfF62BAAArhMAABgAAAAAAAAAAAAgALaB8SQAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbFBLAQIUABQAAAAIAKR5qFyV/5K5AAUAAJEUAAAYAAAAAAAAAAAAIAC2gd0pAAB4bC93b3Jrc2hlZXRzL3NoZWV0Mi54bWxQSwUGAAAAABAAEAB/BAAAEy8AAAAA xl/worksheets/sheet1.xml xl/worksheets/sheet3.xml 1 0 Task Level 1 (All) 2 Project Organization 3 Project Manager 4 Project Type 5 Project Name 6 Project Number 7 Functional Currency 8 Total Invoiced Amount 9 Accounts Receivable 10 Unbilled Receivable 11 Unearned Revenue 12 Unbilled Retention 13 Task Number 14 Task Name 15 Actual Revenue Amount 16 Actual Cost Amount 17 Actual Hours 18 Budget Cost Amount 19 Budget Cost Hours 20 Budget Revenue Amount 21 Budget Revenue Hours 22 NA 23 USD 24 (blank) 25 1 26 NA Total 27 Grand Total data A1 1 data AA 3 data AA1 1 data AB1 1 data AC 3 data AC1 1 data AD 3 data AD1 1 data AE 3 data AE1 1 data AF 3 data AF1 1 data AG 3 data AG1 1 data AH 3 data AH1 1 data AI 3 data AI1 1 data AJ 3 data AJ1 1 data AK 3 data AK1 1 data AL 3 data AL1 1 data AM 3 data AM1 1 data AN 3 data AN1 1 data AO 3 data AO1 1 data AP 3 data AP1 1 data AQ 3 data AQ1 1 data AR 3 data AR1 1 data AS 3 data AS1 1 data AT 3 data AT1 1 data AU 3 data AU1 1 data AV 3 data AV1 1 data AW 3 data AW1 1 data AX 3 data AX1 1 data AY 3 data AY1 1 data AZ 3 data AZ1 1 data B1 1 data BA 3 data BA1 1 data BB1 1 data BC1 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 3 data U1 1 data V 3 data V1 1 data W 3 data W1 1 data X 3 data X1 1 data Y 3 data Y1 1 data Z 3 data Z1 1 parameter A1 1 parameter A10 1 parameter A11 1 parameter A12 1 parameter A2 1 parameter A3 1 parameter A4 1 parameter A5 1 parameter A6 1 parameter A7 1 parameter A9 1 parameter B3 2 S Site SYSADMIN Pivot Summary MARK.SPIRNAK Pivot Summary Default