•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Looking to calculate average leadtimes for repeated part numbers on a constantly updated excel sheet
Our take
Are you looking to streamline your lead time calculations for repeated part numbers in Excel? With your existing sheet tracking order dates and arrivals, you can enhance your analysis by creating a separate sheet to average lead times for each part number. Additionally, consider incorporating features that count the frequency of each part's appearance and sum total quantities. This project will not only help you gain insights into performance but also empower your data management process.
I have an excel sheet that my company inputs part numbers and the day we ordered it and the day we got it. I added a column to calculate how many workdays it took for that part number to arrive, but I want to make a separate sheet on this workbook that would be able to pull the leadtimes for each time the part number is on the list and average them out. I would also like to make it pull other data like how many times a part has appeared and maybe if it adds up the total quantities. Anyone got any pointers to get me started on such a project?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- New tables being created after filling previous onesHello, I am creating an Excel spreadsheet to calculate the cost of various parts. The exact number of parts is not known in advance and may vary; furthermore, these parts may be either purchased or manufactured. For this calculation, there are four specific tables—in addition to an initial table that names the part and specifies whether it was purchased or manufactured: Materials, Processes, Transport, and Fasteners. If a part is purchased, it utilizes only the Transport and Fasteners tables; if it is manufactured, it uses all four. Is there a way to have the entry rows for new parts be added automatically, and then—once the user selects whether the part was purchased or manufactured—have the necessary corresponding tables appear? I have looked online but I couldnt ffind anything. Many thanks for considering my request. submitted by /u/Traditional-Gas-1355 [link] [comments]
- Need a way to get avg times for different factors.I am at new company that doesn't have a lot of the resources i am used to using. We are limited to just excel at the moment. I am trying to get the average build complete times for different models with different trims, built by different people but i am not having a lot of luck. I would like to have the average build complete time by each person so i can make a few graphs for the dashboard. So if Meg and Chris both build model C with trim 5 what is that avg time together and to compare against each other. https://preview.redd.it/dv8aln16revg1.png?width=1101&format=png&auto=webp&s=eda3424120c28e48161bebce7a89aef13c661169 submitted by /u/Vegetable-Study-8814 [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#Excel compatibility#Excel alternatives#real-time data collaboration#rows.com#big data management in spreadsheets#conversational data analysis#intelligent data visualization#real-time collaboration#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#lead times#part numbers#excel sheet#workdays