•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
What formula for timeplan milestone allocation?
Our take
Hello All, I'm building a tool to visualize milestone allocation on a timeline, but I'm encountering a challenge. I have a table of milestones, and I want to display them in the corresponding months on the timeline. While I can easily use VLOOKUP to retrieve percentages based on milestone names, I'm struggling with how to place the milestone names in the correct fields on the timeline. I would appreciate any suggestions, especially since I'm aiming to avoid using VBA or macros.
Hi All,
I am trying to build a tool but there is one function I am unable to wrap my head around. I was hoping for some help from your end.
Underneath you can find a simple reflection of what I am trying to do. We have a table with milestones in there.
Next we have a timeline which I want to show the milestones in the month reflected to the dates in the table. (the bottom section shows what I want)
obviously adding the percentages is an easy Vlookup based on the milestone names but how do I manage to get the milestone names in the right fields?
Any suggestions are welcome - I am trying to not use VBA or macro's
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- What formula is best for a sum of time tracked with drop down categories of where time is spent?https://preview.redd.it/mhqsrxla32qg1.png?width=1582&format=png&auto=webp&s=b582fe290370a96f50088ceac412215ebb8bd8a3 I am wanting to do a two week time management tracking for personal use in order to manage my time better. The table to the right is the table I am using in my data validation drop down under Categories. What I want it to show me is a sum of time tracked for each category but I can't seem to figure it out. The formula I have in the current Time Tracked Table to the right is shown in the formula bar. I think I am close to getting it to do what I want it to do, but can't find that missing step. submitted by /u/Double-Ad9259 [link] [comments]
- Time In Lieu SpreadsheetHey All, I have used Google Sheets forever but my new job uses Office and I am struggling with some of Excel's functions. I'm trying to create a spreadsheet that tracks my time off in lieu (TOIL) so I know where I'm at. I've created the bare bones of the spreadsheet ash shown in the image but I need help cleaning it up. Ideally I would like to have all of the time columns (B:H) only have hh:mm format and then all of the 0:00:00 values that haven't been used not to be shown. In cell L1 I would like it to show the most current level of TOIL, again in hh:mm format. Is this possible or am I asking too much of Excel? Thanks in advance. https://preview.redd.it/c8u5ha2cxszg1.png?width=1001&format=png&auto=webp&s=3985daa3d11541abed488f377c62e375f6ab1224 submitted by /u/Silky_45 [link] [comments]
- Monthly tracking workbook I use to track employee sales metrics; Trying to find a way to make the process less labour intensiveTruly having a hard to describing my issue effectively but hoping someone can help. First time posting here and I'm by no means an expert with excel, so please be kind! I have a monthly workbook where I track each employees revenue and other metrics. Every 2 weeks for payroll, I provide a print out of these numbers, and the payroll sheet pulls data from multiple sheets in the workbook. For example, every workbook has a separate sheet for each day of the month, titled "1" through "31". I have pay period sheets, so I'll use one titled "04.02.26 - 04.15.26". Then I'll have the data for each employee pulled from multiple sheets. For example, I use the formula =SUM('2:15'!E3) to pull the sales data from each day of that period for the specific employee. This works quite well. However, when I create a new month's spreadsheet, I have to manually alter this formula for each employee and for each data point (more than just revenue, at least 6 different data points for 7 employees). Is there a way to automate this? For example, a cell or two where I'm able to enter the date range and all of the formulas update to that date range for the corresponding pages? I'm sorry of this post is confusing. Truly it's confusing even typing it! submitted by /u/Ok_Smile9222 [link] [comments]
- Formula to ramp values over a variable rangeHi! I'm working on a budget/staffing spreadsheet. Right now, given a horizontal row of data representing day/weeks, I can easily assign a "phase" to each row, and then have a set number of hours/budget automatically distribute across those cells. See formula for cell E2 in snip below. The first two "sets" of data in rows 2,3 and 4,5 are working just fine, no big deal. Total values for Concepts always add up to 40, total values for Schematic Design always add up to 80. What I'd like to introduce is a "ramp factor" from 0-100% that will affect those values. See the desired outputs in red below (values are fake). When ramping factor is 0%, it's just straight division similar to examples up top. When the ramp factor is increased, the values "later" (right-most) in the resulting strings are weighted more heavily, and the "earlier" (left-most) values are weighted lighter. In effect the values are starting lower and "ramping up" to their conclusion, but the total per "phase" still matches up with the references values in columns B and C. Any ideas on how to efficiently implement this without introducing cheater cells or VBA? I'm not super concerning about the rounding - I can figure that out later. I realize it may result in the resulting sum not exactly matching the original values in columns B and C, but I can live with that. I just need to get in the ballpark. Thanks all. https://preview.redd.it/p4egj1rz8usg1.png?width=1607&format=png&auto=webp&s=f49a5bbe794032bcdb177a03bd01957906397d80 submitted by /u/bikesaremagic [link] [comments]