This study focused on the needs of a lean, light, mobile, and accurate simulation methods, which has been demanded for years. Utilizing the spreadsheet as a tool of calculation, the used by authors is line pack calculation approach. From mass conservation we calculated line pack, then we had delta line pack from which we got the average pressure, and table we could obtain the values from table iteration. They later were used for gas transmission transient analysis. Further, this calculation method is not only available for transient analysis, but also for gas properties tracking/forecasting (Gross Heating Value, CO2, H2S, CH4, etc.) as well for pipeline capacity analysis. The calculation method has been tested in studying PGN gas transmission pipeline which has two parallel pipelines that span more than 600 miles onshore and offshore with four supply points and four demand points. The result were encouraging, the transient analysis accuracy was 99% and the gas properties tracking result also reached above 90% for CO2 and Gross Heating Value compared to actual data from the fields for a certain timeline.
PT Perusahaan Gas Negara (Persero) Tbk. or "PGN" transports natural gas through gas pipeline systems in the coverage area of its business. In the gas transportation management process, it is important to plan, monitor, and control the supply-demand so that the network reliability and the balance of gas can be maintained. Currently, PGN operates gas transmission pipeline system that connects the gas supply and demand with total length of 624 miles of parallel pipelines from South Sumatera to West Java (SSWJ Transmission Pipeline). The pipeline capacity is influenced by several factors such as supply pressure, delivery pressure, the point of supply and distribution scheme. It is essential for PGN to monitor these factors to operate the pipelines effectively and efficiently. With that reason in mind and also growing needs of more lean, light, mobile, accurate simulation methods from network operators, the authors created this modelling with limited usage of data.
The objectives of this paper are to calculate the line pack and maximum capacity of the transmission pipeline, conduct the transient analysis, and track or forecast the CO2 content as well caloric value of the gas using model that runs in spreadsheet. PGN's SSWJ transmission pipeline configuration can be seen in Figure 1.
