{"id":24415,"date":"2025-07-05T11:48:34","date_gmt":"2025-07-05T04:48:34","guid":{"rendered":"https:\/\/www.poultryindonesia.com\/?p=24415"},"modified":"2025-07-08T11:56:59","modified_gmt":"2025-07-08T04:56:59","slug":"formulasi-pakan-dengan-microsoft-excel-dan-fungsi-solver","status":"publish","type":"post","link":"https:\/\/www.poultryindonesia.com\/id\/formulasi-pakan-dengan-microsoft-excel-dan-fungsi-solver\/","title":{"rendered":"Formulasi Pakan dengan Microsoft Excel dan Fungsi Solver"},"content":{"rendered":"<h6><strong>POULTRYINDONESIA, Surabaya &#8211;<\/strong> Formulasi pakan merupakan langkah krusial dalam proses pencampuran pakan ternak. Salah satu metode praktis dan ekonomis yang kini banyak digunakan adalah dengan memanfaatkan Microsoft Excel, khususnya fitur Solver.<\/h6>\n<h6>Hal tersebut disampaikan oleh Riestyarta Adi, Regional Nutritionist PT Malindo Feedmill Tbk, dalam seminar teknis bertajuk \u201cPenyusunan Formulasi Pakan Ayam Petelur Berbasis Fungsi Solver Microsoft Excel\u201d yang diselenggarakan oleh ASOHI Jawa Timur dalam rangkaian acara Indolivestock 2025 di Grand City Convex, Surabaya, Rabu (3\/7).<\/h6>\n<h6>\u201cFormulasi pakan menggunakan Microsoft Excel dengan fungsi Solver itu gratis, karena programnya sudah tersedia. Tinggal bagaimana kita menerapkannya dengan benar,\u201d ujar Adi saat memaparkan materi.<\/h6>\n<h6>Adi menjelaskan, terdapat beberapa langkah penting dalam menggunakan Solver untuk formulasi pakan. Di antaranya adalah mengaktifkan Solver, menyusun matriks nutrisi bahan baku, melakukan quality control terhadap bahan, pengecekan fisik, menentukan harga bahan baku, dan akhirnya melakukan optimasi formulasi.<\/h6>\n<h6>\u201cTantangannya adalah memastikan kombinasi bahan baku yang digunakan mampu menghasilkan jumlah nutrisi yang tepat sesuai kebutuhan ternak,\u201d jelasnya.<\/h6>\n<h6>Menurut Adi, formulasi pakan sejatinya adalah proses pemilihan dan pencampuran berbagai bahan dalam rasio tertentu agar menghasilkan keseimbangan nutrisi yang optimal bagi hewan. Ia menekankan bahwa tujuan akhir dari pencampuran pakan adalah memberikan performa terbaik bagi ternak.<\/h6>\n<h6>\u201cHarapan kita, pakan yang kita racik bisa memberikan efek optimal pada hewan yang mengonsumsinya,\u201d tegas Adi.<\/h6>\n<h6>Ia juga menguraikan prinsip dasar dalam formulasi pakan, yakni memperhatikan kebutuhan nutrisi hewan, pemilihan bahan baku, daya cerna, bioavailabilitas, efisiensi biaya, serta keseimbangan antara energi dan protein.<\/h6>\n<h6>\u201cMemang nutrisi itu kompleks. Tapi paling tidak, yang jadi patokan utama adalah keseimbangan antara energi dan protein. Kalau dua ini sudah tercapai, maka yang lainnya akan mengikuti,\u201d tandasnya.<\/h6>\n<h6>Dalam praktiknya, Adi mengingatkan agar formulator selalu memastikan keakuratan data nutrisi dan harga bahan baku, mempertimbangkan dampak kualitas bahan terhadap formula, serta melibatkan bantuan laboratorium untuk memperoleh matriks nutrisi yang valid. Ia juga menyarankan penggunaan referensi ilmiah untuk memperkirakan kandungan bahan baku yang tidak bisa dianalisis oleh laboratorium lokal.<\/h6>\n<h6>\u201cSolver hanyalah alat bantu. Keputusan akhir tetap berada di tangan formulator,\u201d pungkasnya.<\/h6>\n","protected":false},"excerpt":{"rendered":"<p>POULTRYINDONESIA, Surabaya &#8211; Formulasi pakan merupakan langkah krusial dalam proses pencampuran pakan ternak. Salah satu metode praktis dan ekonomis yang kini banyak digunakan adalah dengan memanfaatkan Microsoft Excel, khususnya fitur Solver. Hal tersebut disampaikan oleh Riestyarta Adi, Regional Nutritionist PT Malindo Feedmill Tbk, dalam seminar teknis bertajuk \u201cPenyusunan Formulasi Pakan Ayam Petelur Berbasis Fungsi Solver [&hellip;]<\/p>\n","protected":false},"author":19,"featured_media":24416,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"cybocfi_hide_featured_image":"","spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false},"categories":[20,7],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v16.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.poultryindonesia.com\/id\/formulasi-pakan-dengan-microsoft-excel-dan-fungsi-solver\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Formulasi Pakan dengan Microsoft Excel dan Fungsi Solver | Poultry Indonesia\" \/>\n<meta property=\"og:description\" content=\"POULTRYINDONESIA, Surabaya &#8211; Formulasi pakan merupakan langkah krusial dalam proses pencampuran pakan ternak. Salah satu metode praktis dan ekonomis yang kini banyak digunakan adalah dengan memanfaatkan Microsoft Excel, khususnya fitur Solver. Hal tersebut disampaikan oleh Riestyarta Adi, Regional Nutritionist PT Malindo Feedmill Tbk, dalam seminar teknis bertajuk \u201cPenyusunan Formulasi Pakan Ayam Petelur Berbasis Fungsi Solver [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.poultryindonesia.com\/id\/formulasi-pakan-dengan-microsoft-excel-dan-fungsi-solver\/\" \/>\n<meta property=\"og:site_name\" content=\"Poultry Indonesia\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/PoultryIndonesiaOfficial\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-05T04:48:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-08T04:56:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.poultryindonesia.com\/wp-content\/uploads\/2025\/07\/Formulasi-Pakan-dengan-Microsoft-Excel-dan-Fungsi-Solver.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"853\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/#organization\",\"name\":\"Poultry Indonesia\",\"url\":\"https:\/\/www.poultryindonesia.com\/id\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/PoultryIndonesiaOfficial\/\",\"https:\/\/www.instagram.com\/poultryindonesia\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/#logo\",\"inLanguage\":\"id\",\"url\":\"https:\/\/i0.wp.com\/poultry.apps360.id\/wp-content\/uploads\/2020\/06\/2b06813e08c0623a94a39dd397da501b.jpg?fit=1071%2C321&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/poultry.apps360.id\/wp-content\/uploads\/2020\/06\/2b06813e08c0623a94a39dd397da501b.jpg?fit=1071%2C321&ssl=1\",\"width\":1071,\"height\":321,\"caption\":\"Poultry Indonesia\"},\"image\":{\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/#website\",\"url\":\"https:\/\/www.poultryindonesia.com\/id\/\",\"name\":\"Poultry Indonesia\",\"description\":\"Referensi Perunggasan Terpercaya\",\"publisher\":{\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.poultryindonesia.com\/id\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/formulasi-pakan-dengan-microsoft-excel-dan-fungsi-solver\/#primaryimage\",\"inLanguage\":\"id\",\"url\":\"https:\/\/www.poultryindonesia.com\/wp-content\/uploads\/2025\/07\/Formulasi-Pakan-dengan-Microsoft-Excel-dan-Fungsi-Solver.jpg\",\"contentUrl\":\"https:\/\/www.poultryindonesia.com\/wp-content\/uploads\/2025\/07\/Formulasi-Pakan-dengan-Microsoft-Excel-dan-Fungsi-Solver.jpg\",\"width\":1280,\"height\":853},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/formulasi-pakan-dengan-microsoft-excel-dan-fungsi-solver\/#webpage\",\"url\":\"https:\/\/www.poultryindonesia.com\/id\/formulasi-pakan-dengan-microsoft-excel-dan-fungsi-solver\/\",\"name\":\"Formulasi Pakan dengan Microsoft Excel dan Fungsi Solver | Poultry Indonesia\",\"isPartOf\":{\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/formulasi-pakan-dengan-microsoft-excel-dan-fungsi-solver\/#primaryimage\"},\"datePublished\":\"2025-07-05T04:48:34+00:00\",\"dateModified\":\"2025-07-08T04:56:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/formulasi-pakan-dengan-microsoft-excel-dan-fungsi-solver\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.poultryindonesia.com\/id\/formulasi-pakan-dengan-microsoft-excel-dan-fungsi-solver\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/formulasi-pakan-dengan-microsoft-excel-dan-fungsi-solver\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/\",\"url\":\"https:\/\/www.poultryindonesia.com\/id\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/formulasi-pakan-dengan-microsoft-excel-dan-fungsi-solver\/#webpage\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/formulasi-pakan-dengan-microsoft-excel-dan-fungsi-solver\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/formulasi-pakan-dengan-microsoft-excel-dan-fungsi-solver\/#webpage\"},\"author\":{\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/#\/schema\/person\/1dc8ee243a8499f3ae854f411b1b04b0\"},\"headline\":\"Formulasi Pakan dengan Microsoft Excel dan Fungsi Solver\",\"datePublished\":\"2025-07-05T04:48:34+00:00\",\"dateModified\":\"2025-07-08T04:56:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/formulasi-pakan-dengan-microsoft-excel-dan-fungsi-solver\/#webpage\"},\"wordCount\":331,\"publisher\":{\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/formulasi-pakan-dengan-microsoft-excel-dan-fungsi-solver\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.poultryindonesia.com\/wp-content\/uploads\/2025\/07\/Formulasi-Pakan-dengan-Microsoft-Excel-dan-Fungsi-Solver.jpg\",\"articleSection\":[\"Berita Terkini\",\"Peristiwa\"],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/#\/schema\/person\/1dc8ee243a8499f3ae854f411b1b04b0\",\"name\":\"Muhrisol Yafi\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.poultryindonesia.com\/id\/#personlogo\",\"inLanguage\":\"id\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fb239958cddfe08818c6a2246b09013a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fb239958cddfe08818c6a2246b09013a?s=96&d=mm&r=g\",\"caption\":\"Muhrisol Yafi\"},\"url\":\"https:\/\/www.poultryindonesia.com\/id\/author\/yafi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","jetpack_featured_media_url":"https:\/\/www.poultryindonesia.com\/wp-content\/uploads\/2025\/07\/Formulasi-Pakan-dengan-Microsoft-Excel-dan-Fungsi-Solver.jpg","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pd8n0R-6lN","jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.poultryindonesia.com\/id\/wp-json\/wp\/v2\/posts\/24415"}],"collection":[{"href":"https:\/\/www.poultryindonesia.com\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.poultryindonesia.com\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.poultryindonesia.com\/id\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/www.poultryindonesia.com\/id\/wp-json\/wp\/v2\/comments?post=24415"}],"version-history":[{"count":1,"href":"https:\/\/www.poultryindonesia.com\/id\/wp-json\/wp\/v2\/posts\/24415\/revisions"}],"predecessor-version":[{"id":24417,"href":"https:\/\/www.poultryindonesia.com\/id\/wp-json\/wp\/v2\/posts\/24415\/revisions\/24417"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.poultryindonesia.com\/id\/wp-json\/wp\/v2\/media\/24416"}],"wp:attachment":[{"href":"https:\/\/www.poultryindonesia.com\/id\/wp-json\/wp\/v2\/media?parent=24415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.poultryindonesia.com\/id\/wp-json\/wp\/v2\/categories?post=24415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.poultryindonesia.com\/id\/wp-json\/wp\/v2\/tags?post=24415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}