Wanting to build a check total sheet that references a dynamic calendar
Our take
I am going to try and Make this as clear as possible but it might be a bit confusing.
I am creating a Dynamic Calendar (which it is created and works it seems) to track my work schedule. I work a two week on two week off schedule and I change out on Thursdays. I got it formatted to shade my schedule where I’m at work(not important) and shaded to add extra weeks.
I want to create a second sheet that tracks the weeks of work (actually pay periods but both.)
Listed as Back, Full and Front
Back- is the first week I’m at work
Full- well that’s a full week
Front- last week or the front half
I want column A to be the work week but started on a Monday and the pay period would be the following Friday in column B. Column C would list the type of week and D would be the amount associated with the type of week.
My calendar is a grid 3x4 months. from empty first Jan square is B5 and all the way to X37 there is columns and rows spacing each month out
In AA4 is the year
AA5 is rotation start date
AA6&AA7 is days on and off.
I have tried using AI I have tried getting it to reference and when I get close the column for Week type does not fill correctly or won’t add an extra week when adding to that boxes or it adds every week possible in the year.
I hope that was clear I been messing with it like a day before asking AI. And nothing I do gets it.
Either it fills all weeks at full or no full weeks.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Calendar formatting. Creating a multiple year with automatic fill in based off inputed informationI want to create a calendar for my office, where I can make it once and everyone else can use it. And they understand how to work it I need a calendar where people can request leave time off and by inputting it in one tab it will automatically populate to the correct spot on calendar. I also need to create a weekly calendar that pulls the info from the monthly calendar. If you have any clue how to assist thanks ahead of time submitted by /u/Tx75110 [link] [comments]
- Creating an auto-populating visual calendar for multiple departments to view?I coordinate student schedules across multiple hospital units. I log the shifts in an hours log spreadsheet (date, start time, end time, unit, student name, etc.). Every month, I need to send each unit a schedule showing who is coming in and when so they can review and plan coverage. Right now, this part is very manual, and does not lend to tracking any data like how many students on each units, hours, etc., which we need as a department. We have over 100 students each month, so as much automizing as possible would be helpful as its a big process. Ideally, I’d like something that: Pulls directly from the hours log (no retyping or copy/paste) Is easy to read at a glance for unit managers Can handle many units, many months, and many students Lets me filter by unit + month I'm not really an excel genius, and I've been using copilot to help me with some of this and formulations, but It's not providing me with accurate formulas for the actual calendar conversion. If there are any resources on what formulas to use, what platforms that I could maybe look into for how to do this, or just honestly any advice at all. We've gotten the data tracking mostly drafted up and it's able to pull from pivot tables and show the analytics, but the calendar is my biggest hurdle at the moment. submitted by /u/JuggernautFlashy6489 [link] [comments]
- Spreadsheet for in vestmentsI am trying to organize and make things easier for me to digest. I was looking for a template or budget sheet or someone to make it for me - I am not tech savvy. I want something that allows me to have the year up top, and all my things I am investing in ie roth, 401k, brokerage, wife’s Roth, wife’s brokerage, kids UTMA x2 accts, extra principal on mortgage. My idea/intent is to set a value of dollars I’ll contribute that calendar year - and try to reach that goal. Then under that I’ll have the table. Left side column would be those accts and top of each row would be the months of the year. I’ll simply plug in the amount contributed that month and that will subtract from the yearly goal. Once goal is met, green? Color coded would be nice lol. Then the other would be an investment growth excel. Regarding my brokerage, Roth and 401k then my wife’s brokerage and Roth. I just want to be able to see the charts all in one place. Not necessarily a graph that goes up and down. But the numbers month by month. Let me know if this is dumb, conceivable, or a waste of time. Help me figure this out but I really think this will help me - especially the first one. submitted by /u/Dak_The_Gripper [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]