Help with calculating percentages

[Abelardus]

Hello,

I have a spreadsheet with hundreds of vendors/suppliers. Each vendor delivers multiple parts, for which some are delivered "Early", some "Late," and some "On-Time."

Some vendors deliver the same type of part, so each vendor delivers it at different times, falling into either of the above delivery statuses independently.

The Delivery Status column/field shows the status, but it is actually a formula that is calculated using two other columns with dates.

THE QUESTION: I need to calculate the percentage of each delivery status ("Early", "Late," and "On-Time") for each vendor rather than the percentage of status as a whole.

E.g., Vendor A delivered "On-Time" x% out of the total of all the "On-Time" deliveries done by all vendors together (I'm debating whether I should get the percentage out of all the total deliveries regardless of the type of status as the denominator for the calculation rather than only of the total of each status. Please suggest the right denominator).

I need the percentages of each delivery status per vendor to be able to identify the "Top 10" vendors that delivered "Early", top 10 that were "Late", and top 10 "On-Time."

This is a perpetual spreadsheet that will be refreshed constantly. Below is how the data is structured in the spreadsheet.

Your help is very appreciated,

Abelardus

VENDOR	PART ID	DELIVERY STATUS
Vendor A	Part A	Late
	Part B	On-Time
	Part C	Late
	Part D	Early
Vendor B	Part A	On-Time
	Part E	Late
Vendor C	Part A	Late
	Part X	Early
	Part Y	Early
Vendor D	Part X	On-Time

 

[pecoflyer]

Hi please post a sample sheet with some data and an example of expected results. Images are impossible to work with. Thx

 

[p45cal]

Cross posted:

Help with calculating percentages

Hello, I have a spreadsheet with hundreds of vendors/suppliers. Each vendor delivers multiple parts, for which some are delivered "Early", some "Late," and some "On-Time." Some vendors deliver the same type of part, so each vendor delivers it at different times, falling into either of...

www.excelfox.com

Help with calculating percentages

Hello, I have a spreadsheet with hundreds of vendors/suppliers. Each vendor delivers multiple parts, for which some are delivered "Early", some "Late," and some "On-Time." Some vendors deliver the same type of part, so each vendor delivers it at different times, falling into either of...

www.excelforum.com

Help with calculating for multiple vendors their delivery performance

Hello, I have a spreadsheet with hundreds of vendors/suppliers. Each vendor delivers multiple parts for which some are delivered "Early", some "Late," and some "On-Time." Some vendors deliver the same type of part, so vendors share the same part with their own delivery status. I have...

www.mrexcel.com

Calculate Vendor Delivery Performance Percentages

I have a spreadsheet with hundreds of vendors/suppliers. Each vendor delivers multiple parts, for which some are delivered "Early", some "Late," and some "On-Time." Some

stackoverflow.com

Excel Help for Help Calculating Delivery Performance

Excel Help for Help calculating delivery performance in Managing Supply Chain and Inventory. Find Excel help and share Excel solutions relating to supply chain management and inventory control.

www.business-spreadsheets.com

 

[vletm]

Abelardus​

You have obviously not read some of the forum rules.
Please start reading this - these are for you too:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.