5,934 views
SETTLEMENT OF WORK WORK BY CONTRACT - EXCEL TEMPLATE (Adjustments, Amortizations, Deductibles that do not correspond, MGG, Penalties, Interest, etc.) PART 1 ❗❗ STEP BY STEP ❗❗ 📕 LEARN HOW TO BUILD YOUR SETTLEMENT TEMPLATE STEP BY STEP 📕👇👇👇👇👇👇👇👇👇 ⏰TIMESTAMPS⏰ 👉 00:00 Presentation - Introduction 👉 01:36 Concept of a Settlement of Work by Contract 👉 07:38 Content of a Settlement of Work by Contract 👉 11:10 Texts and Books on Work Settlement (Downloadable) 👉13:11 Download all OSCE Opinions 👉15:13 Necessary information to collect for a Liquidation of Work by contract 👉 16:35 All the content of the Liquidation of Work in EDITABLE FORMAT 👉 25:58 PRESENTATION OF THE EXCEL OF LIQUIDATION OF WORK (TEMPLATE) 👉 29:00 Download Technical Files of the SEACE 👉 34:55 Polynomial Formula (Building the Template) 👉 39:25 Valued Work Progress (Building the Template) 👉 43:26 Recalculated Work Progress (Building the Template) 👉 45:45 Unified indexes and how to correctly determine the base date of the Budget (Building the Template) 👉 1:13:21 Calculation of Readjustment Coefficients (K) (Building the Template) 📚 To Acquire the EXCEL TEMPLATE and LIQUIDATION MODEL IN EDITABLE FORMAT, request it here: 👉 https://wa.link/ie012f 📚 Link to Texts and Books on Work Liquidation ✔ https://drive.google.com/drive/folder... 📚 SEACE link to download Technical Files ✔ https://prodapp2.seace.gob.pe/seacebu... 📚 Walter Villavicencio Ugarte ✔ https://www.inei.gob.pe/estadisticas/... If you liked the video, leave your like, make a comment and don't forget to subscribe to this CHANNEL so that you stay inside the next videos that I will be uploading