MatthewPaul
New Member
- Joined
- Nov 5, 2023
- Messages
- 3
- Office Version
- 365
- Platform
- MacOS
Hi there, I'm looking at building a tender document that houses multiple vendor responses with drop down boxes.
I've been doing this for a while but what I would really like is to have a drop down box in a summary tab, where I can select either, the lowest price across all vendors or individual vendor pricing. I would also like one that removes the highest pricing as this may sometime skew out my results when running analytics on the tender.
As an example:
I might have 10 items I would like quoted and either a range of quantities or only one.
I will have 5 suppliers quoting the items.
In my summary tab, I would have:
1. Total minimum cost (mostly unit cost)
2. Average unit cost
3. Variance between lowest and average
4. Variance between lowest and average
What I would like is a drop down box where I can choose to exclude the highest value across the 10 items if I believe the costs are too high.
I hope I have explained myself and I am really looking forward to your response.
Thank you very much in advanced.
I've been doing this for a while but what I would really like is to have a drop down box in a summary tab, where I can select either, the lowest price across all vendors or individual vendor pricing. I would also like one that removes the highest pricing as this may sometime skew out my results when running analytics on the tender.
As an example:
I might have 10 items I would like quoted and either a range of quantities or only one.
I will have 5 suppliers quoting the items.
In my summary tab, I would have:
1. Total minimum cost (mostly unit cost)
2. Average unit cost
3. Variance between lowest and average
4. Variance between lowest and average
What I would like is a drop down box where I can choose to exclude the highest value across the 10 items if I believe the costs are too high.
I hope I have explained myself and I am really looking forward to your response.
Thank you very much in advanced.
