Title: "How to achieve rapid feedback progress through integrated EXCEL?"

Author: "Deyi.zhang/张德义"

Abstract: Although the functions of P6 are becoming more and more powerful, an unavoidable problem is that the feedback of the implementation of the plan has always been a nuisance to users. The more elaborate the plan, the more cumbersome the feedback, resulting in a multiple increase in the workload. This article focuses on how to form a secondary feedback tool for P6 through secondary development based on EXCEL.

Background introduction

With the increase of enterprise engineering projects, especially the overseas Belt and Road Project, it is not only necessary to consider how the project is organized and how to manage it. The use of P6 is a very good choice. Although the function of P6 is more and more powerful, an unavoidable problem is that The feedback on the implementation of the plan has always been an obstacle to users. The more detailed the plan, the more tedious the feedback, which has led to an increase in the workload. At the same time, it is also necessary to make a better and more accurate pre-measurement of cash flow based on plans in order to achieve a reasonable financing of project funds and reduce project costs. In the project bidding stage and early stage of the project, accurate prediction of cash flow not only can better evaluate the project and guide the project organization plan in the early stage of the project, but also can reduce the capital risk and reduce the financing cost at the project stage..

如何通过集成EXCEL实现快速反馈进度？

摘要

虽然P6的功能越来越强大，但一个不可回避的问题是计划执行情况的反馈一直是困扰广大用户的羁绊，计划越精细，反馈越繁琐，从而导致工作量成倍增加。本文重点介绍如何在EXCEL的基础上通过二次开发形成P6的辅助反馈工具。

背景介绍

随着企业工程项目的增加，特别是海外一带一路项目，不仅要考虑项目如何组织、如何管理，使用P6是一个非常好的选择，虽然P6的功能越来越强大，但一个不可回避的问题是计划执行情况的反馈一直是困扰广大用户的羁绊，计划越精细，反馈越繁琐，从而导致工作量成倍增加。与此同时，还要基于计划更好地、更准确预地测现金流，以实现项目资金的合理筹措，降低工程项目成本。在项目投标阶段、项目前期阶段，通过对现金流的准确预测，不仅可以在项目前期更好地评估项目、指导项目组织方案，而且还可以在项目进行阶段，减少资金风险，降低融资成本。