What is Mobos?

Petrol Pump Accounting In Excel Sheet Download ✯ [ Exclusive ]

// Get total sales sum function getTotalSales() return salesData.reduce((sum, item) => sum + item.amount, 0);

function salesChangeHandler(e) 0; let rate = parseFloat(document.querySelector(`.sales-rate[data-idx='$idx']`)?.value) petrol pump accounting in excel sheet download

<div class="excel-table" id="excelTableContainer"> <!-- dynamic table will be injected --> </div> <div class="footer"> * Double-click any cell to edit. Sales & expenses auto update profit. Stock closing = Opening + Received - Sold. </div> </div> // Get total sales sum function getTotalSales() return

function resetDemo() salesData = [ product: "Petrol (MS)", liters: 1250, rate: 102.50, amount: 128125 , product: "Diesel (HSD)", liters: 980, rate: 94.80, amount: 92904 , product: "Premium Petrol", liters: 320, rate: 115.00, amount: 36800 , product: "Engine Oil (Lube)", liters: 45, rate: 850, amount: 38250 ]; expensesData = [ date: "01-Apr-2026", category: "Electricity", amount: 5500 , date: "05-Apr-2026", category: "Staff Salary", amount: 28500 , date: "10-Apr-2026", category: "Maintenance", amount: 3200 , date: "15-Apr-2026", category: "Misc", amount: 1750 ]; stockData = [ product: "Petrol (MS)", opening: 5200, received: 8000, sold: 1250, closing: 11950, unitPrice: 102.50 , product: "Diesel (HSD)", opening: 4300, received: 7000, sold: 980, closing: 10320, unitPrice: 94.80 , product: "Premium Petrol", opening: 1100, received: 2000, sold: 320, closing: 2780, unitPrice: 115.00 , product: "Engine Oil (Lube)", opening: 180, received: 120, sold: 45, closing: 255, unitPrice: 850.00 ]; recomputeSales(); recomputeStock(); renderTables(); product: "Diesel (HSD)"

// Build HTML with three sections let html = `<style>td input border:1px solid #ddd; border-radius:6px; padding:6px; text-align:center; td vertical-align: middle; </style>`;

function attachInputEvents() // Sales liters & rate document.querySelectorAll('.sales-lit, .sales-rate').forEach(inp => inp.removeEventListener('input', salesChangeHandler); inp.addEventListener('input', salesChangeHandler); ); // Expenses amount document.querySelectorAll('.exp-amt').forEach(inp => inp.removeEventListener('input', expenseChangeHandler); inp.addEventListener('input', expenseChangeHandler); ); // Stock fields: opening, received, sold, price document.querySelectorAll('.stock-opening, .stock-received, .stock-sold, .stock-price').forEach(inp => inp.removeEventListener('input', stockChangeHandler); inp.addEventListener('input', stockChangeHandler); );