Good Day,
I am working on a spreadsheet that is tracking a large quantity of vehicles that are being built and inspected. I have formulas counting the total number vehicles, total number of vehicles remaining, Total number of vehicles built and total number of vehicles inspected. I have used the the =CountA formula to assist in tracking that information. I also have to track total percentage completed and total percentage remaining. This is were it gets tricky for me. When 1 vehicle has been built it is considered to be 90% complete and once it had been inspected it now 100% completed and ready to be sent to the customer. Can anyone help me with a formula that will take in account for the 90% complete (vehicle built) and 10% complete (vehicle inspected) and display it in the percentage complete and percentage remaining? I have a small example spreadsheet here below. I used 4 vin numbers to represent each vehicle. For simple math when 1 vehicle is built and inspected it should display 25% complete and 75% remaining. If only one vehicle is built but not inspected it should display 22.5% and once the vehicle gets an inspection date it should increased the percentages by 2..5% to give me the full 25%. The spreadsheet below is just a small example of my master spreadsheet that is going to contain about 130 vehicles. I hope this is not confusing for anyone. Please let me know if you have questions.
I am working on a spreadsheet that is tracking a large quantity of vehicles that are being built and inspected. I have formulas counting the total number vehicles, total number of vehicles remaining, Total number of vehicles built and total number of vehicles inspected. I have used the the =CountA formula to assist in tracking that information. I also have to track total percentage completed and total percentage remaining. This is were it gets tricky for me. When 1 vehicle has been built it is considered to be 90% complete and once it had been inspected it now 100% completed and ready to be sent to the customer. Can anyone help me with a formula that will take in account for the 90% complete (vehicle built) and 10% complete (vehicle inspected) and display it in the percentage complete and percentage remaining? I have a small example spreadsheet here below. I used 4 vin numbers to represent each vehicle. For simple math when 1 vehicle is built and inspected it should display 25% complete and 75% remaining. If only one vehicle is built but not inspected it should display 22.5% and once the vehicle gets an inspection date it should increased the percentages by 2..5% to give me the full 25%. The spreadsheet below is just a small example of my master spreadsheet that is going to contain about 130 vehicles. I hope this is not confusing for anyone. Please let me know if you have questions.
| Example1.xlsx | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | VIN | Build Date | Inspection Date | ||
| 2 | JH4DA9468LS807181 | 11/23/2023 | 11/24/2023 | ||
| 3 | SCBBA63Y5EC018884 | 11/23/2023 | |||
| 4 | 1FD0X5HT6GEA45833 | 11/23/2023 | 11/24/2023 | ||
| 5 | 1FTWX32P04EB35375 | 11/23/2023 | 11/24/2023 | ||
| 6 | |||||
| 7 | Total Number of Vehicles | Total Number Remaining | Percentage Complete | ||
| 8 | 4 | 0 | |||
| 9 | Total Number Built | Total Number Inspected | Percentage Remaining | ||
| 10 | 4 | 3 | |||
Sheet1 | |||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A8 | A8 | =COUNTA(A2:A5) |
| B8 | B8 | =A8-A10 |
| A10:B10 | A10 | =COUNTA(B2:B5) |
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| C8 | Other Type | DataBar | NO | |
