BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Smart Training Center - ECPv6.16.3//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Smart Training Center
X-ORIGINAL-URL:https://smart-training-center.com
X-WR-CALDESC:Events for Smart Training Center
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:Asia/Krasnoyarsk
BEGIN:STANDARD
TZOFFSETFROM:+0700
TZOFFSETTO:+0700
TZNAME:+07
DTSTART:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Krasnoyarsk:20260615T083000
DTEND;TZID=Asia/Krasnoyarsk:20260616T160000
DTSTAMP:20260615T010950
CREATED:20241122T100849Z
LAST-MODIFIED:20260305T044201Z
UID:893-1781512200-1781625600@smart-training-center.com
SUMMARY:Powerful Database Analysis & Dashboard Reporting using Microsoft Excel
DESCRIPTION:BACKGROUND:\nWhy Choose Microsoft Excel for Database Analysis?\nProses analisis data dan pembuatan dashboard summary report dari file text hasil import aplikasi besar seperti SAP/ERP seringkali memakan waktu lama\, bahkan berhari-hari\, meskipun menggunakan Microsoft Excel. Pelatihan ini\, “Powerful Database Analysis & Dashboard Reporting using Microsoft Excel\,” akan membantu menyelesaikan proses ini lebih cepat dan sesuai kebutuhan pimpinan. Excel memiliki berbagai metode canggih dan fungsi terbaru yang mampu mempercepat pengolahan\, validasi\, analisis\, dan pelaporan data\, bahkan untuk jumlah data lebih dari 100.000 record. Dengan teknik yang tepat\, proses ini dapat diselesaikan lebih cepat dan sesuai kebutuhan pimpinan. \nExcel juga menawarkan fitur pembuatan dashboard summary report yang interaktif\, dinamis\, dan menarik untuk mendukung analisis lebih lanjut. Salah satu fitur tersembunyi yang jarang dimanfaatkan adalah Solver Analysis Tool Pack\, yang memungkinkan simulasi budgeting analysis secara cepat dan akurat. Fitur ini memungkinkan pengguna melakukan optimasi dan prediksi dengan hasil yang lebih presisi. Dengan berbagai fungsi validasi dan analisis yang tersedia\, pengguna tidak perlu lagi mengembangkan program database analysis dan summary reporting menggunakan bahasa pemrograman tertentu. Semua kebutuhan analisis data dan pelaporan dapat diselesaikan dengan cepat dan efisien menggunakan Excel\, mendukung pengambilan keputusan yang lebih berbasis data. \nOBJECTIVES:\n\nMastering advanced data analysis techniques\nEnhancing data visualization skills\nOptimizing database utilization in Excel\nUnderstanding advanced tools & features in Excel\nImproving work efficiency\nSupporting data-driven decision-making\n\nRECOMMENDED PARTICIPANTS:\n\nData Analysts & Business Analyst\nFinance & Accounting Professionals\nSales & Marketing Teams\nOperations & Supply Chain Managers\nProject Managers who require data processing\nHuman Resources Analysts\nIT Support Staff handling data reporting\nAdministrative Staff responsible for data management\nEntrepreneurs or Small Business Owners managing their own data\n\nCOURSE OUTLINE:\n\nStep-by-step operation for external data converting process to Excel database.\nCreated & designed worksheet using Sparklines object\nHow to use Auto Filter with union field key &Custom Filter\nOptimization filtering column in the database.\nHow to make an Advance Filter (Criteria and Output Data Query).\nHow to make and use Consolidate Methods.\nRemoving Duplicate Rows\nUsing the Excel Built-In Data Entry Form\nCreating a Drop-Down List in a Cell\nHow to make Ranking Values\nPerforming a LOOKUP function.\nHow to use Operational Table with ADVANCE LOOKUP Function\nHow to make and use PivotTable Optimization\nCreated and designed worksheet report using PivotTable\nCreating and Utilizing Pivot Charts Optimized with Slicer Panels\nCreated and designed Cells Graphic using Spark Lines\nHow to make and use Data Validation\nHow to make and use Data Validation Automation with Table Function.\nHow to make and use the Data Table Method for one-cell input and two-cell input.\nHow to make & use data analysis method (What If Analysis).\nHow to make and use the analysis function.\nHow to make active and use solver analysis tool pack:\n\n\n\n\nHow using of Format Cells for Locked & Hidden Cells\nHow using of Using Allow Users to Edit Range (Permission User Access Setting)\nHow to use of Protect Sheet (Select Locked Cells & Select Unlocked Cells)\n\n\n\n\nCase study implementation\n\nABOUT THE COURSE LEADERS:\nAndika Bayu Saputra\, S.Kom\, M.Kom\, Pada tahun 2013 mendapatkan gelar master (S2) dibidang IT dengan predikat memuaskan di program pasca sarjana Magister Teknik Informatika FTI UII. \nMenjadi Consultant IT sejak 2013 dan banyak menangani proyek yang berkaitan dengan IT. Selain sebagai akademisi dan praktisi dibidang IT juga sering memberikan pelatihan dan certified dibidang IT. \nPublic Training berikutnya : 19 – 20 Oktober\, 2026
URL:https://smart-training-center.com/event/powerful-database-analysis-and-dashboard-reporting/
LOCATION:Jakarta
CATEGORIES:Engineering,Finance,General,HRD,Manajemen,Oil & Gas,Power Generation,Project,Q-HSE,Supply Chain
ATTACH;FMTTYPE=image/jpeg:https://smart-training-center.com/wp-content/uploads/2024/11/powerful-database-analysis-dashboard-reporting-using-microsoft-excel.jpg
ORGANIZER;CN="PT Fiqry Jaya Manunggal":MAILTO:info@fiqry.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Krasnoyarsk:20260615T083000
DTEND;TZID=Asia/Krasnoyarsk:20260617T160000
DTSTAMP:20260615T010950
CREATED:20241122T160421Z
LAST-MODIFIED:20260310T072131Z
UID:979-1781512200-1781712000@smart-training-center.com
SUMMARY:Process Control & Instrument System
DESCRIPTION:Background\nControl systems play a crucial role in modern industrial processes\, ensuring efficiency\, accuracy\, and stability. The ability to design\, analyze\, and optimize these systems is essential for maintaining consistent operation and improving performance. \nThis course is designed to equip participants with a strong foundation in control system principles and practices. From understanding core terminology and analyzing time-domain responses to mastering PID control modes and advanced tuning methods\, participants will gain the skills needed to implement and troubleshoot control systems effectively. \n\nObjectives\nAfter completing this course\, participants will be able to: \n\nUnderstand key control system terminology.\nAnalyze time-domain responses in control systems.\nExplain the types of control modes (PID) and their algorithms.\nApply cascade control in industrial settings.\nDifferentiate between feedback and feedforward control systems.\nUtilize various methods for PID tuning to enhance system performance.\n\n\nRecommended Participants\nThis course is ideal for professionals involved in control system operations\, including: \n\nOperators and Instrument Technicians.\nInstrument Foremen and Control System Technicians.\nInstrument Engineers and Supervisors.\nControl System Supervisors.\nIT System Integrators specializing in industrial automation.\n\n\nCourse Outline\n1. Control System Terminology\n\nControl system input and output.\nOpen-loop and closed-loop control systems.\nFeedback\, controlled variable\, manipulated variable\, and disturbances.\nProcess time lags and control loop diagrams.\n\n2. Time Domain Analysis\n\nTransient and steady-state response.\nTime domain input functions.\nLaplace transform and transfer functions.\nTime-domain response for first- and second-order systems.\nStep response analysis.\n\n3. Control Modes – PID Controller\n\nON/OFF control.\nProportional\, integral\, and derivative control modes.\nVariations of PID control (PI\, PD\, PID).\n\n4. Cascade Loop Control\n\nAdvantages of cascade control.\nComponents of cascade control.\nCascade primary and secondary loops.\nPractical examples of cascade control applications.\n\n5. Feedback & Feedforward Control\n\nComparison between feedback and feedforward control systems.\nLimitations and advantages of each control method.\n\n6. PID Controller Tuning\n\nPID tuning methods: Ziegler-Nichols closed-loop method and Cohen-Coon method.\nDemonstrations and hands-on exercises for each tuning method.\n\n\nMethodology\n\nInstructor-led theory presentations.\nGroup discussions and case-solving exercises.\nLaboratory or field visits for practical demonstrations.\nCase studies based on real-world scenarios.\n\nThis course combines theoretical learning with practical applications to ensure participants can confidently apply their knowledge in professional settings. \nAbout the Course Leader:\nProf. Endra Joelianto\, Ir.\, Ph.D.\, SMIEEE \nPublic Training berikutnya : 10 – 12 Agustus\, 2026
URL:https://smart-training-center.com/event/process-control-instrument-system/
LOCATION:Bandung\, Jawa Barat\, Indonesia
CATEGORIES:Electrical,Production Operation
ATTACH;FMTTYPE=image/jpeg:https://smart-training-center.com/wp-content/uploads/2024/11/instrumentation-electrical-and-control-system-1.jpg
ORGANIZER;CN="PT Fiqry Jaya Manunggal":MAILTO:info@fiqry.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Krasnoyarsk:20260615T083000
DTEND;TZID=Asia/Krasnoyarsk:20260617T160000
DTSTAMP:20260615T010950
CREATED:20241122T163235Z
LAST-MODIFIED:20260306T064213Z
UID:1029-1781512200-1781712000@smart-training-center.com
SUMMARY:Enhanced Oil Recovery (EOR)
DESCRIPTION:Background & About the Course:\nThe global demand for energy continues to rise\, making the efficient extraction of hydrocarbons from reservoirs increasingly critical. Enhanced Oil Recovery (EOR) plays a pivotal role in maximizing recovery from mature fields\, often increasing output by 30-60% beyond primary and secondary recovery techniques. With advancements in technology and innovative techniques such as thermal\, chemical\, and gas injection methods\, EOR has become a game-changer in the oil and gas industry. \nEOR not only improves the recovery factor but also supports energy transition efforts by facilitating the storage of CO₂ in subsurface reservoirs through carbon capture\, utilization\, and storage (CCUS) integration. This course offers comprehensive insights into these advanced recovery techniques\, their principles\, and their practical applications. \nThis intensive training program is designed to provide participants with a solid understanding of the science\, technologies\, and strategies behind Enhanced Oil Recovery. It bridges theoretical knowledge with real-world applications\, equipping attendees with the skills to assess\, design\, and implement EOR projects effectively. \nCourse Objectives:\n\nUnderstand the fundamental principles of Enhanced Oil Recovery (EOR).\nEvaluate different EOR techniques and their suitability for various reservoir conditions.\nLearn about the latest advancements and trends in EOR technologies.\nAssess the economic and environmental considerations of EOR projects.\nDevelop practical skills in designing and planning EOR strategies.\n\nWho Should Attend:\n\nReservoir engineers and geoscientists.\nPetroleum engineers involved in field development.\nTechnical staff working on mature oil fields.\nProject managers and decision-makers in the oil and gas sector.\n\nCourse Content:\n\nIntroduction to Enhanced Oil Recovery (EOR): Overview of EOR principles\, importance\, and applications in maximizing oil recovery.\nThermal EOR Methods: Techniques like steam injection and in-situ combustion\, focusing on their mechanisms and field applications.\nChemical EOR Methods: Methods such as polymer flooding and surfactant-polymer flooding\, emphasizing chemical interactions and efficiency.\nGas Injection Techniques: CO₂\, nitrogen\, and hydrocarbon gas injection\, with a focus on miscible and immiscible processes and their impact on recovery.\nPrinciple of Immiscibility: Explanation of immiscible processes in porous media and how they improve oil displacement.\nMicrobial EOR (MEOR): Use of microorganisms to enhance oil recovery through biological processes in reservoirs.\nElectric EOR: Methods like electromagnetic and resistive heating to mobilize hydrocarbons in challenging conditions.\nGas Lift: Application of gas injection to maintain production rates and optimize EOR methods.\nScreening Criteria for EOR Projects: Identifying suitable reservoirs and conditions for implementing EOR.\nEconomic and Environmental Impacts: Overview of cost challenges\, project feasibility\, and environmental considerations.\nCCUS (Carbon Capture\, Utilization\, and Storage) and EOR Integration: Combining carbon storage with EOR to enhance recovery sustainably.\nField Application and Case Studies: Examples of successful EOR projects\, best practices\, and innovations.\n\nAbout the Course Leader:\nProf. Dr.-Ing. Bonar Tua Halomoan Marbun \n 
URL:https://smart-training-center.com/event/enhanced-oil-recovery-eor/
LOCATION:Bandung\, Jawa Barat\, Indonesia
CATEGORIES:Oil & Gas
ATTACH;FMTTYPE=image/jpeg:https://smart-training-center.com/wp-content/uploads/2024/11/Enhance-oil-recovery.jpg
ORGANIZER;CN="PT Fiqry Jaya Manunggal":MAILTO:info@fiqry.com
END:VEVENT
END:VCALENDAR