widgets

I need to calculate throughput by quarter for a project, based on units created. For example: There 432 total widgets needed; 22 widgets can be completed a week; how many widgets can be completed by quarter until all 432 widgets are done with a start date of 5/1/19. Can someone help and...

Hi, I am looking to do the following, but my excel-fu is weak.... I have twelve tabs, one for each month. Each Tab contains a list of people, and the data pertaining to them, like the following <tbody> Name Nuts Bolts Widgets Objects Bob 12 14 6 6 Ted 11 16 5 5 Amy 9 17 12 9 Jeff 8...

Hi All, Here is what I am trying to accomplish: I have a project in which I need a quantity of 123 'widgets.' These 'widgets' come in cases of 100. Need a formula that will return the value of 200, when comparing 123 and 100. Any and all help is greatly appreciated. /twg

Trying to find a formula to add two different types of widgets. The two widgets are in separate columns. When the two widgets are combined, they form a single part count as 1 item. I hope that this makes sense.

I know it is possible to use VBA to update SQL Server tables with data entered into Excel cells by the user. I have heard that there might be a built-in way to do this in Excel. Is it possible to insert a table/query into an Excel sheet and then have Excel send updates made by the user back to...

I was hoping to get assistance with a formula that will look at a numeric value in one cell, and then apply a formula that will take that number and apply itself to another cell with custom text and make increments of +1 on an entirely different number (starting at 1). For example: <tbody> 5...

Hi All, I'd be grateful if you could have a look at the scenario below and contribute any suggestions please: Scenario We have 5,000 widgets available to order We make widgets to order and can produce 50 a day It's important we can tell customers their expected wait time for their widget...