Compare three supplier quotes in an editable Excel workbook by James FrostCompare three supplier quotes in an editable Excel workbook by James Frost
Compare three supplier quotes in an editable Excel workbookJames Frost
Cover image for Compare three supplier quotes in an editable Excel workbook
Send one Excel or CSV item list with up to 100 lines and three suppliers' unit prices in the same currency and unit of measure. I'll return an editable workbook showing the quantity, each supplier's unit price and line total, and the lowest quoted price for each item. You can update a price or quantity and see the totals recalculate.
Missing prices stay blank. A coverage count shows how many lines each supplier quoted. A like-for-like subtotal includes only lines priced by every supplier, so a missing quote cannot make a supplier appear cheaper. I'll test the calculations and give you a short guide to updating the sheet.
Please send column headings and five invented or redacted rows so we can agree the layout. Prices should already be matched to items and use the same tax basis. Freight, currency conversion, supplier contact and purchasing decisions are outside this package. I use AI-assisted automation to build and test the workbook. Delivery within five calendar days of receiving the agreed input. If the delivery needs correcting, I offer at least two rounds of revisions against the agreed rules.
Starting at$59
Duration5 days
Tags
Microsoft Excel
Data Analyst
Service provided by
James Frost Cambridge, UK
Compare three supplier quotes in an editable Excel workbookJames Frost
Starting at$59
Duration5 days
Tags
Microsoft Excel
Data Analyst
Cover image for Compare three supplier quotes in an editable Excel workbook
Send one Excel or CSV item list with up to 100 lines and three suppliers' unit prices in the same currency and unit of measure. I'll return an editable workbook showing the quantity, each supplier's unit price and line total, and the lowest quoted price for each item. You can update a price or quantity and see the totals recalculate.
Missing prices stay blank. A coverage count shows how many lines each supplier quoted. A like-for-like subtotal includes only lines priced by every supplier, so a missing quote cannot make a supplier appear cheaper. I'll test the calculations and give you a short guide to updating the sheet.
Please send column headings and five invented or redacted rows so we can agree the layout. Prices should already be matched to items and use the same tax basis. Freight, currency conversion, supplier contact and purchasing decisions are outside this package. I use AI-assisted automation to build and test the workbook. Delivery within five calendar days of receiving the agreed input. If the delivery needs correcting, I offer at least two rounds of revisions against the agreed rules.
$59