{"id":368,"date":"2026-10-23T20:23:01","date_gmt":"2026-10-23T20:23:01","guid":{"rendered":"https:\/\/xplorexcel.com\/store\/?post_type=product&#038;p=368"},"modified":"2026-10-25T10:00:12","modified_gmt":"2026-10-25T10:00:12","slug":"milk-collection-software-excel-macro-edition","status":"publish","type":"product","link":"https:\/\/xplorexcel.com\/store\/product\/milk-collection-software-excel-macro-edition\/","title":{"rendered":"XploreDairy PC Macro Edition \u2013 Milk Collection Centre Software in Excel with Entry Forms"},"content":{"rendered":"<h3>What the macro edition adds<\/h3>\n<ul>\n<li>Easy fill-in forms with buttons on a Windows computer<\/li>\n<li>A Data Entry page with every form one click away (Ctrl + Shift + E)<\/li>\n<li>A Find box in every form to edit old entries<\/li>\n<li>Includes the formula-only copy for the Excel app on Android and iPhone<\/li>\n<\/ul>\n<p><strong>Needs:<\/strong> Microsoft Excel on Windows (2016, 2019, 2021 or Microsoft 365) for the forms and buttons. The forms do not run on Mac, Excel Online or Google Sheets \u2014 use the included .xlsx copy there.<\/p>\n<p><strong>First time:<\/strong> right-click the .xlsm file \u2192 Properties \u2192 tick &#8220;Unblock&#8221; \u2192 OK, then click &#8220;Enable Content&#8221; when it opens.<\/p>\n<p>Digital file, so no refunds \u2014 but if the file doesn&#8217;t work for you, we&#8217;ll fix it.<\/p>\n<hr>\n<h3>Everything in XploreDairy<\/h3>\n<p><strong>XploreDairy is a complete milk collection system in one Excel file<\/strong> for village milk collection centres, dodhis and small dairies. Set your rates once, then enter each farmer&#8217;s morning and evening milk. Every rate, amount, 10-day bill, deduction and balance is worked out for you. There&#8217;s no machine software or monthly fee, and it works offline.<\/p>\n<div style=\"background:#E2EFDA;border-left:5px solid #006838;padding:16px 20px;margin:20px 0;border-radius:4px\">\n<p style=\"margin:0 0 8px\"><strong>What you can do with it<\/strong><\/p>\n<ul style=\"margin:0\">\n<li>Pay cow and buffalo milk your way: <strong>fat &amp; SNF (\u20b9 per kg)<\/strong>, <strong>fat only (\u20b9 per fat point)<\/strong>, your <strong>dairy&#8217;s rate chart<\/strong> or a <strong>fixed rate<\/strong>.<\/li>\n<li>Enter <strong>SNF or just the CLR<\/strong>. SNF is worked out for you.<\/li>\n<li>Make <strong>10-day, 15-day, monthly or weekly bills<\/strong>, with cattle feed, advance recovery and previous balance.<\/li>\n<li>Send every farmer&#8217;s bill on <strong>WhatsApp<\/strong> in one click from the bill register.<\/li>\n<li>Compare <strong>milk collected with milk sold to the dairy<\/strong>: quantity loss, fat loss and your margin.<\/li>\n<\/ul>\n<\/div>\n<h2>Features<\/h2>\n<h3>Rates<\/h3>\n<ul>\n<li>A separate method and rate for <strong>cow<\/strong> and <strong>buffalo<\/strong>, plus an optional incentive per litre.<\/li>\n<li><strong>Rate charts<\/strong> for cow (fat 2.5\u20137.0) and buffalo (fat 4.0\u201310.0) \u00d7 SNF 7.0\u20139.5. Paste your dairy&#8217;s chart.<\/li>\n<li>Choose <strong>litres or kg<\/strong>. The SNF-from-CLR constants can be changed.<\/li>\n<\/ul>\n<h3>Daily collection<\/h3>\n<ul>\n<li>Up to <strong>200 farmers<\/strong> and <strong>12,000 entries<\/strong> per file. Type the code, and the name, rate and amount fill in.<\/li>\n<li>Each entry is checked: unknown farmer, wrong shift, missing fat or SNF, or a value outside the chart.<\/li>\n<\/ul>\n<h3>Bills &amp; payments<\/h3>\n<ul>\n<li><strong>Farmer bill<\/strong> printed with every shift&#8217;s qty, fat, SNF, rate and amount, average fat and SNF, deductions, previous balance and net payable in words.<\/li>\n<li><strong>Bill register<\/strong> for all farmers in a cycle, used as your payment sheet, with WhatsApp bills.<\/li>\n<li><strong>Cattle feed \/ items, advance given, advance recovery, other deductions, bonus and payments<\/strong>, with the advance outstanding tracked for each farmer.<\/li>\n<li><strong>Farmer statement<\/strong> showing milk, deductions, payments and balance cycle by cycle.<\/li>\n<\/ul>\n<h3>Your business<\/h3>\n<ul>\n<li><strong>Dispatch<\/strong> register for milk sold to Verka, Amul or any plant, with the qty, fat, SNF and amount received.<\/li>\n<li><strong>Daily &amp; monthly summary:<\/strong> morning and evening qty, average fat, paid to farmers vs received from the dairy, <strong>quantity and fat-kg gain \/ loss<\/strong> and margin.<\/li>\n<li><strong>Dashboard:<\/strong> milk collected, average fat and SNF, average rate, balance payable, advances, margin, top suppliers and a monthly chart.<\/li>\n<\/ul>\n<h2>What you get<\/h2>\n<ul>\n<li><strong>XploreDairy 1.0 \u2013 Blank (Start Here).xlsx<\/strong> for your centre<\/li>\n<li><strong>XploreDairy 1.0 \u2013 Sample Data (Demo).xlsx<\/strong>: 25 farmers, about 1,900 entries, September to mid-October 2026<\/li>\n<li>A built-in <em>How to Use<\/em> sheet and a README<\/li>\n<\/ul>\n<h2>Requirements<\/h2>\n<p>Microsoft Excel 2016 or later on Windows or Mac. It has no macros and works offline. Use one file per period: a year for small centres, or a quarter if you have 100+ farmers.<\/p>\n<p style=\"font-size:13px;color:#666\"><em>The sample rates are examples, not any dairy&#8217;s official rates. Enter the rates you actually pay.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Everything in XploreDairy, plus easy fill-in forms with buttons on Windows Excel \u2014 open a form, fill it, press Save. Includes a formula-only copy for the Excel phone app. One-time payment, instant download, lifetime access.<\/p>\n<p class=\"xe-full\" style=\"margin-top:12px\"><a href=\"https:\/\/xplorexcel.com\/store\/xploredairy\/\" style=\"display:inline-block;padding:9px 16px;border:2px solid #0F7A6B;border-radius:8px;color:#0F7A6B;font-weight:600;text-decoration:none\">See XploreDairy in detail \u2014 screenshots, plans &amp; FAQ \u2192<\/a><\/p>\n","protected":false},"featured_media":398,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_brand":[],"product_cat":[16],"product_tag":[59,61,63,62,58,60],"class_list":["post-368","product","type-product","status-publish","has-post-thumbnail","product_cat-business-templates","product_tag-dairy-software-excel","product_tag-dudh-dairy-hisab","product_tag-farmer-milk-bill-format","product_tag-milk-collection-centre-management","product_tag-milk-collection-software-excel","product_tag-milk-fat-snf-rate-chart","first","instock","downloadable","virtual","taxable","purchasable","product-type-simple"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product\/368","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/comments?post=368"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/media\/398"}],"wp:attachment":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/media?parent=368"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product_brand?post=368"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product_cat?post=368"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product_tag?post=368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}