{"id":436,"date":"2026-10-25T09:48:30","date_gmt":"2026-10-25T09:48:30","guid":{"rendered":"https:\/\/xplorexcel.com\/store\/?page_id=436"},"modified":"2026-10-25T09:48:30","modified_gmt":"2026-10-25T09:48:30","slug":"xploredairy","status":"publish","type":"page","link":"https:\/\/xplorexcel.com\/store\/xploredairy\/","title":{"rendered":"XploreDairy \u2013 Milk Collection Centre Software in Excel"},"content":{"rendered":"\n<link rel=\"preconnect\" href=\"https:\/\/fonts.googleapis.com\">\n<link href=\"https:\/\/fonts.googleapis.com\/css2?family=Bricolage+Grotesque:opsz,wght@12..96,700;12..96,800&#038;family=IBM+Plex+Mono:wght@500&#038;family=IBM+Plex+Sans:wght@400;500;600&#038;display=swap\" rel=\"stylesheet\">\n<style>\n.xb{--g:#0F7A6B;--gd:#0B5F52;--ink:#13201A;--mut:#4A5A52;--mut2:#33433B;--bg:#F7F8F5;--line:#DDE3DD;--soft:#E8F7F3;--amber:#F2C94C;\nbackground:var(--bg);color:var(--ink);font-family:'IBM Plex Sans',system-ui,sans-serif;font-size:17px;line-height:1.6;margin:0;overflow-x:hidden}\n.xb-bleed{width:100vw;position:relative;left:50%;margin-left:-50vw}\n.xb *{box-sizing:border-box}\n.xb h1,.xb h2,.xb h3{font-family:'Bricolage Grotesque',sans-serif;color:var(--ink);margin:0;letter-spacing:-.02em;line-height:1.12}\n.xb h2{font-size:clamp(28px,3.4vw,40px);font-weight:700;margin-bottom:10px}\n.xb h3{font-size:19px;font-family:'IBM Plex Sans',sans-serif;letter-spacing:0;font-weight:600;margin-bottom:6px}\n.xb p{margin:0}\n.xb ul{margin:0}\n.xb a{color:var(--g)}\n.xb .wrap{max-width:1160px;margin:0 auto;padding:0 20px}\n.xb .sec{padding:64px 0}\n.xb .lead{color:var(--mut);max-width:40em;margin-bottom:30px}\n.xb .eyebrow{font-family:'IBM Plex Mono',monospace;font-size:13px;letter-spacing:.05em;text-transform:uppercase;color:var(--g)}\n.xb .btn{display:inline-block;min-height:52px;padding:14px 26px;border-radius:10px;font-weight:600;font-size:18px;text-decoration:none;text-align:center;line-height:1.35}\n.xb .btn-p{background:var(--g);color:#fff!important}.xb .btn-p:hover{background:var(--gd)}\n.xb .btn-o{border:1.5px solid var(--ink);color:var(--ink)!important;background:transparent}.xb .btn-o:hover{background:#fff}\n.xb .grid{display:grid;gap:18px;grid-template-columns:repeat(auto-fit,minmax(250px,1fr))}\n.xb .card{background:#fff;border:1px solid var(--line);border-radius:12px;padding:24px}\n.xb .card p{font-size:15px;color:var(--mut)}\n.xb .num{font-family:'IBM Plex Mono',monospace;font-size:13px;color:var(--g);margin-bottom:6px;display:flex;justify-content:space-between;align-items:center;gap:8px}\n.xb .tag{background:var(--g);color:#fff;font-family:'IBM Plex Sans',sans-serif;font-size:12px;font-weight:600;padding:2px 10px;border-radius:999px}\n.xb .hero{display:flex;flex-wrap:wrap;gap:48px;align-items:center;padding:56px 0}\n.xb .hero-txt{flex:1 1 460px;min-width:0;display:flex;flex-direction:column;gap:20px}\n.xb .hero h1{font-size:clamp(34px,5vw,56px);font-weight:800;letter-spacing:-.03em;line-height:1.05}\n.xb .hero .sub{font-size:19px;color:var(--mut2);max-width:34em}\n.xb .ctas{display:flex;flex-wrap:wrap;gap:12px}\n.xb .badges{list-style:none;padding:0;display:flex;flex-wrap:wrap;gap:10px;font-size:15px;font-weight:500}\n.xb .badges li{display:flex;align-items:center;gap:8px;background:#fff;border:1px solid #C9D3CB;border-radius:999px;padding:7px 14px;margin:0}\n.xb .badges svg{flex:none}\n.xb .hero-img{flex:1 1 380px;min-width:0;max-width:500px;margin:0}\n.xb .hero-img img{width:100%;height:auto;aspect-ratio:1\/1;display:block;border-radius:14px;box-shadow:0 18px 40px rgba(19,32,26,.14)}\n.xb .strip{background:var(--ink);color:#F7F8F5}\n.xb .strip .grid{padding:28px 0;gap:20px 32px;font-size:15px}\n.xb .strip strong{display:block;font-family:'Bricolage Grotesque',sans-serif;font-size:20px;color:#fff}\n.xb .ba{display:grid;gap:20px;grid-template-columns:repeat(auto-fit,minmax(300px,1fr))}\n.xb .ba > div{border-radius:12px;padding:28px}\n.xb .ba ul{padding-left:20px;display:flex;flex-direction:column;gap:10px}\n.xb .ba .old{background:#fff;border:1px solid var(--line);color:var(--mut2)}\n.xb .ba .old .eyebrow{color:#8A3B12}\n.xb .ba .new{background:var(--soft);border:1px solid #B9D6C2}\n.xb .ba .eyebrow{margin-bottom:14px}\n.xb .card.hl{background:#EEF8F5;border:1.5px solid var(--g)}\n.xb .card.hl p{color:var(--mut2)}\n.xb .gal{display:grid;gap:18px;grid-template-columns:repeat(auto-fit,minmax(240px,1fr))}\n.xb .gal figure{margin:0}\n.xb .gal img{width:100%;height:auto;aspect-ratio:1\/1;display:block;border-radius:10px;border:1px solid var(--line)}\n.xb .gal figcaption{margin-top:8px;font-size:15px}\n.xb .mshots{display:grid;gap:22px;grid-template-columns:repeat(auto-fit,minmax(320px,1fr));align-items:start}\n.xb .mshots figure{margin:0}\n.xb .mshots img{width:100%;height:auto;display:block;border-radius:10px;border:1px solid var(--line);box-shadow:0 10px 28px rgba(19,32,26,.10)}\n.xb .mshots figcaption{margin-top:10px;font-size:15px}\n.xb .fit{display:grid;gap:20px;grid-template-columns:repeat(auto-fit,minmax(300px,1fr))}\n.xb .fit ul{padding-left:20px;display:flex;flex-direction:column;gap:8px}\n.xb .notfit{background:#FFF6E5;border:1px solid #EBD3A3;border-radius:12px;padding:24px 28px;color:var(--mut2)}\n.xb .notfit h2{font-size:clamp(22px,2.6vw,28px);margin-bottom:14px}\n.xb .pricing{background:#fff;border-top:1px solid var(--line);border-bottom:1px solid var(--line)}\n.xb .plans{display:grid;gap:20px;grid-template-columns:repeat(auto-fit,minmax(280px,1fr));align-items:stretch}\n.xb .plan{border:1px solid #C9D3CB;border-radius:14px;padding:30px;display:flex;flex-direction:column;gap:14px;background:#fff}\n.xb .plan.best{border:2px solid var(--g);background:#EEF8F5}\n.xb .plan .pill{align-self:flex-start;background:var(--g);color:#fff;font-size:13px;font-weight:600;padding:4px 12px;border-radius:999px}\n.xb .plan .eyebrow{color:var(--mut)}.xb .plan.best .eyebrow{color:var(--g)}\n.xb .price{font-family:'Bricolage Grotesque',sans-serif;font-weight:800;font-size:48px;line-height:1}\n.xb .plan ul{padding-left:20px;display:flex;flex-direction:column;gap:8px;flex-grow:1}\n.xb .plan .btn{display:block;width:100%}\n.xb .xb-buy{cursor:pointer;font-family:inherit;text-transform:none!important;letter-spacing:0!important;font-size:18px!important;padding:14px!important;border-radius:10px!important;margin:0!important}\n.xb .xb-buy.btn-o{background:#fff!important;color:var(--ink)!important;border:1.5px solid var(--ink)!important}\n.xb .xb-buy.btn-p{background:var(--g)!important;color:#fff!important;border:0!important}\n.xb .fine{margin-top:22px;font-size:15px;color:var(--mut)}\n.xb .free a{display:block;background:#fff;border:1px solid var(--line);border-radius:10px;padding:18px 20px;text-decoration:none;color:var(--ink)}\n.xb .free a:hover{border-color:var(--g)}\n.xb .free span{font-size:14px;color:var(--g)}\n.xb .about{background:#fff;border:1px solid var(--line);border-radius:14px;padding:32px}\n.xb .about p{color:var(--mut2);max-width:42em}\n.xb .faq{max-width:860px}\n.xb details{border-bottom:1px solid var(--line);padding:18px 0}\n.xb .faq > div{border-top:1px solid var(--line)}\n.xb summary{cursor:pointer;font-weight:600;font-size:18px;list-style-position:outside}\n.xb details p{margin-top:10px;color:var(--mut2)}\n.xb .final{background:var(--ink);color:#F7F8F5}\n.xb .final .wrap{display:flex;flex-wrap:wrap;gap:24px;align-items:center;justify-content:space-between;padding-top:64px;padding-bottom:64px}\n.xb .final h2{color:#fff;font-weight:800;font-size:clamp(30px,4vw,46px)}\n.xb .final p{color:#C9D3CB}\n.xb .btn-y{background:var(--amber);color:var(--ink)!important;font-weight:700}\n.xb .mbar{display:none}\n@media (max-width:760px){\n.xb .sec{padding:44px 0}.xb .hero{padding:32px 0;gap:28px}\n.xb .mbar{display:flex;position:fixed;left:0;right:0;bottom:0;z-index:999;background:#fff;border-top:1px solid var(--line);padding:10px 16px;gap:12px;align-items:center;justify-content:space-between;box-shadow:0 -6px 18px rgba(0,0,0,.08)}\n.xb .mbar .btn{min-height:46px;padding:10px 18px;font-size:16px}\n.xb{padding-bottom:70px}\n}\n<\/style>\n<div class=\"xb\">\n<div class=\"wrap\"><section class=\"hero\"><div class=\"hero-txt\">\n<p class=\"eyebrow\">For village milk collection centres, dodhis &amp; small dairies<\/p>\n<h1>Milk entry, 10-day bills and farmer payments \u2014 in one Excel file.<\/h1>\n<p class=\"sub\">Set your rates once, then enter each farmer&#8217;s morning and evening milk. XploreDairy works out every rate, amount, 10-day bill, feed and advance deduction and balance \u2014 and shows your margin against what the plant pays you.<\/p>\n<div class=\"ctas\"><a class=\"btn btn-p\" href=\"#xb-plans\">See plans \u2014 from \u20b9599<\/a><a class=\"btn btn-o\" href=\"#xb-shots\">See the real sheets<\/a><\/div>\n<ul class=\"badges\"><li><svg width=\"18\" height=\"18\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"#0F7A6B\" stroke-width=\"2.2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" aria-hidden=\"true\"><path d=\"M12 4v11\"\/><path d=\"M7 10l5 5 5-5\"\/><path d=\"M5 20h14\"\/><\/svg>Instant Download<\/li><li><svg width=\"18\" height=\"18\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"#0F7A6B\" stroke-width=\"2.2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" aria-hidden=\"true\"><path d=\"M12 12c-2-2.7-4-4-6-4a4 4 0 0 0 0 8c2 0 4-1.3 6-4zm0 0c2 2.7 4 4 6 4a4 4 0 0 0 0-8c-2 0-4 1.3-6 4z\"\/><\/svg>Lifetime Access<\/li><li><svg width=\"18\" height=\"18\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"#0F7A6B\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\" aria-hidden=\"true\"><path d=\"M5 12l5 5L20 7\"\/><\/svg>No monthly fee<\/li><li><svg width=\"18\" height=\"18\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"#0F7A6B\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\" aria-hidden=\"true\"><path d=\"M5 12l5 5L20 7\"\/><\/svg>Works offline<\/li><\/ul>\n<\/div>\n<figure class=\"hero-img\"><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/10\/xploredairy-formula-cover.jpg\" width=\"1080\" height=\"1080\" alt=\"XploreDairy milk collection centre software in Excel\"><\/figure>\n<\/section><\/div>\n<section class=\"strip\"><div class=\"wrap grid\">\n<div><strong>Pay your way<\/strong>Fat &amp; SNF, fat only, your dairy&#8217;s rate chart or a fixed rate \u2014 cow and buffalo separately.<\/div>\n<div><strong>SNF from CLR<\/strong>Enter the lactometer reading and SNF is worked out for you.<\/div>\n<div><strong>Bills on WhatsApp<\/strong>Send every farmer&#8217;s bill from the bill register in one click.<\/div>\n<div><strong>Made in Punjab<\/strong>Built for Verka, Amul and village collection centres.<\/div>\n<\/div><\/section>\n<section class=\"sec\"><div class=\"wrap\"><h2>Bill day without the register<\/h2>\n<div class=\"ba\" style=\"margin-top:26px\">\n<div class=\"old\"><p class=\"eyebrow\">Register &amp; calculator<\/p><ul><li>Rate looked up in the chart for every entry<\/li><li>10-day totals added by hand for each farmer<\/li><li>Feed and advance deductions noted on loose slips<\/li><li>Farmers argue over fat and rate with no record to show<\/li><li>No idea whether the centre made or lost money<\/li><\/ul><\/div>\n<div class=\"new\"><p class=\"eyebrow\">With XploreDairy<\/p><ul><li>Type the code, qty and fat \u2014 rate and amount fill in<\/li><li>10-day, 15-day, weekly or monthly bills ready<\/li><li>Feed, advance recovery and previous balance on the bill<\/li><li>Every shift&#8217;s fat, SNF and rate printed for the farmer<\/li><li>Milk collected vs sold: quantity loss, fat loss and margin<\/li><\/ul><\/div>\n<\/div><\/div><\/section>\n<section class=\"sec\" style=\"padding-top:0\"><div class=\"wrap\"><h2>What you get<\/h2><p class=\"lead\">One Excel file for your centre. Each page does one job and passes the numbers on by itself.<\/p>\n<div class=\"grid\">\n<div class=\"card\"><p class=\"num\">01<\/p><h3>Rates &amp; rate chart<\/h3><p>Separate method for cow and buffalo, incentive per litre, and charts you can paste from your dairy.<\/p><\/div>\n<div class=\"card\"><p class=\"num\">02<\/p><h3>Milk entry<\/h3><p>Up to 200 farmers and 12,000 entries. Wrong code, shift or a value outside the chart is flagged.<\/p><\/div>\n<div class=\"card\"><p class=\"num\">03<\/p><h3>Farmer bill<\/h3><p>Every shift&#8217;s qty, fat, SNF, rate and amount, deductions, previous balance and net in words.<\/p><\/div>\n<div class=\"card\"><p class=\"num\">04<\/p><h3>Bill register<\/h3><p>All farmers for one cycle \u2014 your payment sheet, with WhatsApp bills.<\/p><\/div>\n<div class=\"card\"><p class=\"num\">05<\/p><h3>Feed &amp; advances<\/h3><p>Cattle feed, advance given and recovered, bonus and payments, with advance outstanding.<\/p><\/div>\n<div class=\"card\"><p class=\"num\">06<\/p><h3>Farmer statement<\/h3><p>Milk, deductions, payments and balance cycle by cycle.<\/p><\/div>\n<div class=\"card\"><p class=\"num\">07<\/p><h3>Dispatch &amp; margin<\/h3><p>Milk sold to Verka, Amul or any plant \u2014 quantity and fat-kg gain or loss, and your margin.<\/p><\/div>\n<div class=\"card\"><p class=\"num\">08<\/p><h3>Dashboard<\/h3><p>Milk collected, average fat and SNF, balance payable, advances and top suppliers.<\/p><\/div>\n<div class=\"card hl\"><p class=\"num\"><span>09<\/span><span class=\"tag\">Macro edition<\/span><\/p><h3>Every farmer&#8217;s bill as PDF, in one click<\/h3><p>Pick the cycle and press &#8220;PDF for all&#8221; \u2014 a separate milk bill for every farmer.<\/p><\/div>\n<\/div><\/div><\/section>\n<section class=\"sec\" style=\"padding-top:0\" id=\"xb-shots\"><div class=\"wrap\"><h2>See the real sheets<\/h2><p class=\"lead\">These are pages from the sample file in your download: 25 farmers and about 1,900 entries.<\/p>\n<div class=\"gal\">\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/10\/xploredairy-2-dashboard.jpg\" width=\"1200\" height=\"1200\" loading=\"lazy\" alt=\"Milk collection centre dashboard in Excel with average fat, SNF and margin\"><figcaption>Dashboard \u2014 milk, fat, margin<\/figcaption><\/figure>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/10\/xploredairy-3-farmer-bill.jpg\" width=\"1200\" height=\"1200\" loading=\"lazy\" alt=\"10-day farmer milk bill format in Excel with fat, SNF and rate\"><figcaption>10-day farmer milk bill<\/figcaption><\/figure>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/10\/xploredairy-4-milk-entry.jpg\" width=\"1200\" height=\"1200\" loading=\"lazy\" alt=\"Daily milk entry sheet in Excel with morning and evening shift\"><figcaption>Milk entry \u2014 morning and evening<\/figcaption><\/figure>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/10\/xploredairy-5-bill-register.jpg\" width=\"1200\" height=\"1200\" loading=\"lazy\" alt=\"Milk bill register for all farmers in Excel\"><figcaption>Bill register for all farmers<\/figcaption><\/figure>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/10\/xploredairy-6-daily-summary.jpg\" width=\"1200\" height=\"1200\" loading=\"lazy\" alt=\"Daily milk collection summary with dispatch and fat loss in Excel\"><figcaption>Daily summary \u2014 collected vs sold<\/figcaption><\/figure>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/10\/xploredairy-7-statement.jpg\" width=\"1200\" height=\"1200\" loading=\"lazy\" alt=\"Farmer milk statement in Excel\"><figcaption>Statement for any farmer<\/figcaption><\/figure>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/10\/xploredairy-8-payments-farmers.jpg\" width=\"1200\" height=\"1200\" loading=\"lazy\" alt=\"Farmer payments, advances and cattle feed register in Excel\"><figcaption>Payments, advances and feed<\/figcaption><\/figure>\n<\/div><\/div><\/section>\n<section class=\"sec\" style=\"padding-top:0\"><div class=\"wrap\"><h2>Macro edition: fill-in forms on your PC<\/h2><p class=\"lead\">Click a button, fill a short form, press Save. These are real screens from the macro edition.<\/p>\n<div class=\"mshots\">\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/10\/xploredairy-macro-data-entry.jpg\" width=\"1394\" height=\"444\" loading=\"lazy\" alt=\"XploreDairy macro edition Data Entry page with milk collection, milk sold, payment and milk bills buttons\"><figcaption>Data Entry page \u2014 every form one click away (Ctrl + Shift + E)<\/figcaption><\/figure>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/10\/xploredairy-macro-milk-form.jpg\" width=\"821\" height=\"611\" loading=\"lazy\" alt=\"XploreDairy milk collection entry form with farmer code, shift, qty, fat, CLR and SNF\"><figcaption>Milk collection form \u2014 pick the farmer, enter qty and fat, find and edit old entries<\/figcaption><\/figure>\n<\/div><\/div><\/section>\n<section class=\"sec\" style=\"padding-top:0\"><div class=\"wrap fit\">\n<div><h2>Made for<\/h2><ul style=\"margin-top:14px\"><li>Village milk collection centres<\/li><li>Dodhis buying from farmers<\/li><li>Small dairies and milk co-operatives<\/li><li>Centres supplying Verka, Amul or a private plant<\/li><\/ul><\/div>\n<div class=\"notfit\"><h2>Not the right fit if<\/h2><ul><li>You have more than 200 farmers in one file<\/li><li>You need the milk analyser to send readings straight into the file<\/li><li>You need a counter screen for farmers at the centre<\/li><\/ul><\/div>\n<\/div><\/section>\n<section class=\"pricing\" id=\"xb-plans\"><div class=\"wrap sec\"><h2>Pick your plan<\/h2><p class=\"lead\">Same rates, bills and reports in both. Choose how you want to enter data.<\/p>\n<div class=\"plans\">\n<div class=\"plan\"><p class=\"eyebrow\">Formula edition<\/p><p class=\"price\">\u20b9599<\/p><ul><li>Works on phone and PC<\/li><li>Type straight into the yellow boxes<\/li><li>All bills, payments and reports<\/li><\/ul><button type=\"button\" class=\"xe-qb-open xb-buy btn btn-o\" data-pid=\"278\" data-name=\"XploreDairy \u2013 Formula edition\" data-price=\"\u20b9599.00\" data-thumb=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/10\/xploredairy-formula-cover.jpg\">Buy now \u2014 \u20b9599<\/button><\/div>\n<div class=\"plan best\"><p class=\"pill\">Best for the centre<\/p><p class=\"eyebrow\">Macro edition<\/p><p class=\"price\">\u20b9899<\/p><ul><li>Everything in the formula edition<\/li><li>Easy fill-in forms for milk, payments, dispatch and farmers on a Windows computer<\/li><li><strong>&#8220;PDF for all&#8221;: every farmer&#8217;s milk bill as a separate PDF, in one click<\/strong><\/li><li>Bill register and statements \u2014 print or PDF in one click<\/li><li>Includes a phone copy for the Excel mobile app<\/li><\/ul><button type=\"button\" class=\"xe-qb-open xb-buy btn btn-p\" data-pid=\"368\" data-name=\"XploreDairy \u2013 PC Macro edition\" data-price=\"\u20b9899.00\" data-thumb=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/10\/xploredairy-macro-cover.jpg\">Buy now \u2014 \u20b9899<\/button><\/div>\n<\/div>\n<p class=\"fine\">Pay with UPI, cards or net banking. Digital file, so no refunds \u2014 but if the file doesn&#8217;t work for you, we&#8217;ll fix it.<\/p>\n<\/div><\/section>\n<section class=\"sec\" id=\"xb-free\"><div class=\"wrap\"><h2>Not sure yet? Try a free template first<\/h2><p class=\"lead\">Same builder, same yellow-box style. If our free templates work for you, XploreDairy will too.<\/p>\n<div class=\"grid free\">\n<a href=\"https:\/\/xplorexcel.com\/milk-fat-snf-rate-calculator-excel\/\"><strong style=\"display:block\">Milk Fat &amp; SNF Rate Calculator<\/strong><span>Free download \u2192<\/span><\/a>\n<a href=\"https:\/\/xplorexcel.com\/excel-templates\/\"><strong style=\"display:block\">All free Excel templates<\/strong><span>Browse \u2192<\/span><\/a>\n<\/div><\/div><\/section>\n<section class=\"sec\" style=\"padding-top:0\"><div class=\"wrap\"><div class=\"about\"><h2>Hi, I&#8217;m Amanpreet<\/h2><p style=\"margin-top:10px\">I run XplorExcel from Punjab. I build these files for the way Indian dairies and small businesses actually work. If something in the file doesn&#8217;t make sense, <a href=\"https:\/\/xplorexcel.com\/contact-us\/\">message me<\/a>.<\/p><\/div><\/div><\/section>\n<section class=\"sec\" style=\"padding-top:0\"><div class=\"wrap faq\"><h2 style=\"margin-bottom:22px\">Questions<\/h2><div>\n<details><summary>Can I use my dairy&#8217;s rate chart?<\/summary><p>Yes. Paste the chart into the Rate Chart sheet \u2014 cow fat 2.5\u20137.0 and buffalo fat 4.0\u201310.0 against SNF 7.0\u20139.5. Or pay by fat &amp; SNF per kg, fat only, or a fixed rate.<\/p><\/details>\n<details><summary>We don&#8217;t test SNF, only CLR. Will it work?<\/summary><p>Yes. Enter the CLR (lactometer reading) and SNF is worked out from fat and CLR. The constants can be changed to match your dairy&#8217;s formula.<\/p><\/details>\n<details><summary>Can bills be 10-day, 15-day or monthly?<\/summary><p>Yes. Bills can be made for 10-day, 15-day, weekly or monthly cycles.<\/p><\/details>\n<details><summary>How are cattle feed and advances recovered?<\/summary><p>Record feed sold and advances given in Payments. Recoveries come off the farmer&#8217;s bill and the advance outstanding is tracked for each farmer.<\/p><\/details>\n<details><summary>Will it work on my phone?<\/summary><p>Yes. The formula edition opens in the Excel app on Android and iPhone, and the macro edition includes a phone copy too. The fill-in forms and one-click PDFs work on a Windows computer.<\/p><\/details>\n<details><summary>Which Excel do I need?<\/summary><p>Excel 2016 or later on Windows or Mac for the formula edition. The macro edition&#8217;s forms need Excel on Windows.<\/p><\/details>\n<details><summary>Are the sample rates Verka&#8217;s or Amul&#8217;s?<\/summary><p>No. The sample rates are examples only. Enter the rates you actually pay.<\/p><\/details>\n<details><summary>How do I get the file?<\/summary><p>The download link appears as soon as payment goes through and is also sent to your email. You can download it again anytime \u2014 there is no expiry.<\/p><\/details>\n<\/div><\/div><\/section>\n<section class=\"final\"><div class=\"wrap\"><div style=\"flex:1 1 420px;min-width:0\"><h2>Make this cycle&#8217;s milk bills in minutes.<\/h2><p style=\"margin-top:8px\">Pay once \u00b7 Instant Download \u00b7 Lifetime Access<\/p><\/div><a class=\"btn btn-y\" href=\"#xb-plans\">See plans \u2014 from \u20b9599<\/a><\/div><\/section>\n<div class=\"mbar\"><span style=\"font-weight:600\">XploreDairy <span style=\"font-family:'IBM Plex Mono',monospace\">from \u20b9599<\/span><\/span><a class=\"btn btn-p\" href=\"#xb-plans\">See plans<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>For village milk collection centres, dodhis &amp; small dairies Milk entry, 10-day bills and farmer payments \u2014 in one Excel file. Set your rates once, then enter each farmer&#8217;s morning and evening milk. XploreDairy works out every rate, amount, 10-day bill, feed and advance deduction and balance \u2014 and shows your margin against what the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"footnotes":""},"class_list":["post-436","page","type-page","status-publish"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/pages\/436","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/comments?post=436"}],"version-history":[{"count":1,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/pages\/436\/revisions"}],"predecessor-version":[{"id":437,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/pages\/436\/revisions\/437"}],"wp:attachment":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/media?parent=436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}