Forum Discussion
Custom Text and Multiple results in a cell
Good morning, I have two questions. For context, I have built a Gantt chart which shows preconstruction work and construction work for a project using different color highlights. I would like to...
Ok, So I am a little embarrassed cause this spread sheet is a mess and is very busy, but I have removed all of the PII that I could. The spread sheet is a giant calculator designed to estimate project duration to help PM plan preproduction and production activates while providing the program manger data for all ongoing project. It has two Gantt charts, a year long view and a zoomed in month long view. I am concerned with the month long view (4th tab). The Gantt part works, it highlights cells no problem. But I want to display more information in its cells. In the sixth tab I have a bar chart which uses SUMIFS to display how many of each type of worker are working at any given moment, the problem is that every worker type needs its own cell. I want my display to print all worker types and then list the number for each of them. I know it is a mess.
https://whstovall-my.sharepoint.com/:x:/p/kbaer/EWjmmop55d9AixHYXtvguK8BHjDgvUXEyfVgfzb9-sF6Bg?e=vCQHyi
https://whstovall-my.sharepoint.com/:x:/p/kbaer/EWjmmop55d9AixHYXtvguK8BHjDgvUXEyfVgfzb9-sF6Bg?e=vCQHyi
I have downloaded the workbook.
Could you provide a few examples of
- Which cell on which sheet you want to populate
- What the value should be based on the data in the sample workbook.
- Ok, on Tab "1 Month Production Schedule" I want cells F8:AG18 to display "Panel Fabricators: #", "Panel Field Teams: #", "Glass Fabricators:#", and "Glass Field Teams:#" with the number being determined by the "Duration Calculator" tab with the date range being determined by columns L, Z, AE, AF, AK, AQ, and AR; while manning numbers come from columns E, M, R, and S. Again, I want to apologies for this being a mess, this program has grown in scope and complexity a lot recently. At it's core it is a tool for estimating the duration of work, but if you know the duration you can determine other things like schedule and cost; which is why this thing continues to grow.
Since the one month only show a month and all of my sample data start past a month all of the returns that I am looking for are 0.- This looks like it works. Thank you sir. I appreciate your help.
