Good evening/ Good Morning Everyone,
Maybe I am missing a step or just lack the analytical/ excel creating experience.
So, the big picture of what I am trying to accomplish with this Excel set up for a tool and if possible using the tool to generate a Pivot Table for tracking remaining funding at a given month.
Basically, I am trying to create an “up to date” or current snapshot of how much funds I have left for a Project. The challenge is this project lasts for 5 years and the project receives funding annually. But this project starts in November then ends in October (QY Term). Following year, the project renews again in November then ends in October then repeats, however. My organization functions on a July – June funding cycle (OY Term). I would like to know say in April how much funding I have used from the November – October (QY Term) funding bucket vs July – June (OY Term) funding bucket. Is it possible to create a table on Excel that shows me the difference and how much I have used for a specific month ie April 2012 or March 2013 on the QY and the OY funding cycle? I have attached my work with some numbers. I just couldn’t put it together. Thanks in advance for any guidance or assistance in helping me finishing this spreadsheet.
I am trying to attach the Excel file I am using but I can only attach an image file instead. Sorry…