This site under reconstruction.
Before I left on a retreat, I was playing around with Access and data model. Pivot tables have something called data model and I was playing around with it to see how it works. What I found was that it allows you to combine two tables, kind of like Access’ joining of tables and/or queries….
This gets old – the company that is in or was just in bankruptcy keeps changing its books. Every month my boss does variance analysis against the budget that was created earlier in the year (and not forwarded to the sites that have to manage their money, go figure). I gather the data for her since…
This is a continuation of a prior post but this time, I will talk about a really interesting kind of macro that I have recently been learning. I knew that you could record macros, you could have a button for starting macros, you could use ctrl+key to start a macro, you could have a macro…
I’ve been working on a set of new projects – some of it pertains to gathering data and performing analysis and some of it requires a bit of automation. The analytical piece is not done and probably will be ongoing. The analysis is only at the beginning stage so there is not much to relay…
In the last post, I mentioned that there was a problem with the random technique that I was doing. There are two problems: I figured out one problem – more or less – but haven’t figured out the second problem. The first problem is the fact that every time you enter something, the spreadsheet will…
I’ve been working on a new idea which could be interesting. I generally don’t get a chance to do this so it’s been fun to try to figure this one out. I’m trying to do this for budgeting purposes but I may not finish in time due to the complexity. If it is not done,…
You must be logged in to post a comment.