Carpooling vs. Public Transport Expense Tracker

Step 1: Define Your Primary Commute & Costs

Global Settings

Used for optional time cost calculation.

Route Details

Carpooling Details

Public Transport Details

Enter 0 if using a pass primarily.

Step 2: Time & Other Considerations

Commute Time (One-Way in Minutes)

Qualitative Factors (For Personal Consideration & PDF Notes)

Rate the following for each mode (1=Very Poor, 5=Neutral, 10=Excellent). These are not used in cost calculation but can be noted in your PDF.

Carpooling

Public Transport

Step 3: Projected Cost Analysis

Enter details in Tab 1 & 2 and click "Calculate/Refresh Analysis" to see the analysis.

Step 4: Summary & Download

Complete the analysis on Tab 3 to view the summary.

Potential monthly savings by choosing the cheapest option: $${(maxCost - minCost).toFixed(2)}.

`; } } container.innerHTML = summaryHTML; } function downloadCommutePdf() { if (!commuteAnalysisData.results || commuteAnalysisData.results.filter(r => !r.error).length === 0) { alert("Please calculate a valid analysis first."); return; } if (typeof window.jspdf === 'undefined' || typeof window.jspdf.jsPDF === 'undefined') { alert('PDF generation library (jsPDF) is not loaded.'); return; } const jsPDFConstructor = window.jspdf.jsPDF; const doc = new jsPDFConstructor(); if (typeof doc.autoTable !== 'function') { alert('jsPDF AutoTable plugin not loaded.'); return; } const data = commuteAnalysisData; const inputs = data.inputs; const validResults = data.results.filter(r => !r.error); const primaryColor = '#007bff', textColor = '#212529', tableHeaderColor = '#e9ecef'; let yPos = 22; doc.setFontSize(18); doc.setTextColor(primaryColor); doc.text("Carpooling vs. Public Transport Analysis", 14, yPos); yPos += 8; doc.setFontSize(10); doc.setTextColor(textColor); doc.text(`Report Date: ${new Date().toLocaleDateString()}`, 14, yPos); yPos += 7; doc.text(`Route: ${inputs.routeName}`, 14, yPos); yPos += 5; doc.text(`One-Way Distance: ${inputs.oneWayDistance} ${inputs.distUnit}, Round Trips/Week: ${inputs.roundTripsPerWeek}`, 14, yPos); yPos += 5; doc.text(`Value of Time: $${inputs.valuePerHour.toFixed(2)}/hour`, 14, yPos); yPos += 10; // Carpool Inputs if(inputs.carpool.role && inputs.carpool.role !== "NotCarpooling") { doc.setFontSize(12); doc.setTextColor(primaryColor); doc.text("Carpooling Details", 14, yPos); yPos += 6; let carpoolBody = [['Role:', inputs.carpool.role]]; if(inputs.carpool.role === "Driver") { const fuelEffDisplayUnit = (inputs.distUnit === 'miles' && inputs.fuelVolUnit === 'gallon' ? 'MPG' : (inputs.distUnit === 'km' && inputs.fuelVolUnit === 'liter' ? 'L/100km' : `${inputs.distUnit}/${inputs.fuelVolUnit}` )); carpoolBody.push(['Vehicle Fuel Efficiency:', `${inputs.carpool.fuelEfficiency} ${fuelEffDisplayUnit}`]); carpoolBody.push(['Fuel Cost:', `$${inputs.carpool.fuelCostPerUnit.toFixed(2)} per ${inputs.fuelVolUnit}`]); carpoolBody.push(['Maintenance Cost:', `$${inputs.carpool.maintenancePerDist.toFixed(2)} per ${inputs.distUnit}`]); carpoolBody.push(['Monthly Parking Cost:', `$${inputs.carpool.parkingMonthly.toFixed(2)}`]); carpoolBody.push(['Tolls per Round Trip:', `$${inputs.carpool.tollsPerRound.toFixed(2)}`]); carpoolBody.push(['Carpool Size (incl. driver):', `${inputs.carpool.carpoolSize}`]); carpoolBody.push(['Contribution per Passenger/Month:', `$${inputs.carpool.contribPerPassengerMonthly.toFixed(2)}`]); } else { carpoolBody.push(['Monthly Cost Paid to Driver:', `$${inputs.carpool.costToDriverMonthly.toFixed(2)}`]); } doc.autoTable({startY: yPos, body: carpoolBody, theme:'plain', styles:{fontSize:9}, columnStyles:{0:{fontStyle:'bold'}}}); yPos = doc.lastAutoTable.finalY + 7; } if (yPos > 260 && inputs.publicTransport.usage === 'Yes') { doc.addPage(); yPos = 20; } if(inputs.publicTransport.usage === 'Yes') { doc.setFontSize(12); doc.setTextColor(primaryColor); doc.text("Public Transport Details", 14, yPos); yPos += 6; let ptBody = [ ['Cost per One-Way Trip:', `$${inputs.publicTransport.ptCostPerTrip.toFixed(2)}`], ['Pass Cost:', `$${inputs.publicTransport.ptPassCost.toFixed(2)}`], ['Pass Type:', inputs.publicTransport.ptPassType] ]; doc.autoTable({startY: yPos, body: ptBody, theme:'plain', styles:{fontSize:9}, columnStyles:{0:{fontStyle:'bold'}}}); yPos = doc.lastAutoTable.finalY + 10; } if (yPos > 260) { doc.addPage(); yPos = 20; } doc.setFontSize(12); doc.setTextColor(primaryColor); doc.text("Time & Qualitative Factors", 14, yPos); yPos +=6; let timeQualBody = [ ['Avg. One-Way Carpool Time:', `${inputs.timeQualitative.timeCarpoolMinutes} minutes`], ['Avg. One-Way Public Transport Time:', `${inputs.timeQualitative.timePublicTransportMinutes} minutes`], ['--- Carpooling Ratings (1-10) ---',''], ['Comfort:', `${inputs.timeQualitative.carpoolComfort}`], ['Convenience:', `${inputs.timeQualitative.carpoolConvenience}`], ['Reliability:', `${inputs.timeQualitative.carpoolReliability}`], ['--- Public Transport Ratings (1-10) ---',''], ['Comfort:', `${inputs.timeQualitative.ptComfort}`], ['Convenience:', `${inputs.timeQualitative.ptConvenience}`], ['Reliability:', `${inputs.timeQualitative.ptReliability}`], ]; if(inputs.timeQualitative.additionalNotes) { timeQualBody.push(['Additional Notes:', {content: inputs.timeQualitative.additionalNotes, styles: {cellWidth: 'wrap'}}]); } doc.autoTable({startY: yPos, body: timeQualBody, theme:'plain', styles:{fontSize:9}, columnStyles:{0:{fontStyle:'bold'}, 1:{cellWidth:100}} }); yPos = doc.lastAutoTable.finalY + 10; if (yPos > 240) { doc.addPage(); yPos = 20; } doc.setFontSize(12); doc.setTextColor(primaryColor); doc.text("Projected Cost Analysis", 14, yPos); yPos += 6; const head = [['Mode', 'Monthly Cost ($)', 'Cost/Trip ($)', `Cost/${inputs.distUnit} ($)`]]; if (inputs.valuePerHour > 0) { head[0].push('Monthly Time (hrs)', 'Monetized Time ($)', 'Grand Total ($)'); } const body = validResults.map(r => { const row = [r.mode, r.monthlyCost.toFixed(2), r.costPerTrip.toFixed(2), r.costPerDistance.toFixed(3)]; if (inputs.valuePerHour > 0) { row.push((r.monthlyTimeHours || 0).toFixed(1), (r.monetizedTimeCost || 0).toFixed(2), (r.grandTotalCost || 0).toFixed(2)); } return row; }); let minCostVal = Infinity; let minGrandTotalVal = Infinity; validResults.forEach(r => { if(r.monthlyCost < minCostVal) minCostVal = r.monthlyCost; if(r.grandTotalCost !== undefined && r.grandTotalCost < minGrandTotalVal) minGrandTotalVal = r.grandTotalCost; }); doc.autoTable({ startY: yPos, head: head, body: body, theme: 'grid', headStyles: { fillColor: tableHeaderColor, textColor: textColor, fontStyle: 'bold', fontSize: 8 }, styles: { fontSize: 7.5, cellPadding: 1.5 }, didDrawCell: function(dataHook) { if (dataHook.section === 'body') { const rowData = validResults[dataHook.row.index]; if(rowData) { let isMin = false; if (inputs.valuePerHour > 0 && rowData.grandTotalCost !== undefined) { isMin = Math.abs(rowData.grandTotalCost - minGrandTotalVal) < 0.01; } else { isMin = Math.abs(rowData.monthlyCost - minCostVal) < 0.01; } if (isMin) { doc.setFillColor(212, 237, 218); // Light green doc.setTextColor(21, 87, 36); // Dark green text doc.setFont(undefined, 'bold'); } } } }, willDrawCell: function(dataHook) { // Reset for next cell doc.setTextColor(textColor); doc.setFont(undefined, 'normal'); } }); yPos = doc.lastAutoTable.finalY + 10; doc.setFontSize(10); doc.setTextColor(textColor); const summaryContainer = document.createElement('div'); summaryContainer.innerHTML = document.getElementById('commuteOverallSummaryContainer').innerHTML; const summaryLines = Array.from(summaryContainer.querySelectorAll('p, li')).map(el => el.innerText); doc.text("Summary:", 14, yPos); yPos += 6; summaryLines.forEach(line => { if (yPos > 275) { doc.addPage(); yPos = 20;} // Replace multiple spaces with one for better PDF formatting, handle bold tags if any const cleanedLine = line.replace(/\s\s+/g, ' ').replace(/\*\*(.*?)\*\*/g, '$1'); doc.text(cleanedLine, 14, yPos, {maxWidth: 180}); yPos += (line.toLowerCase().includes("potential monthly savings") ? 7 : 5); }); doc.save("Commute_Cost_Comparison.pdf"); } // Initial calls updateCommuteNavButtons(); updateUnitLabels(); toggleCarpoolFields(); togglePublicTransportFields();
Scroll to Top