Recent content by gjl

Hi Narayan, About five percent of the lines are matched by the system (I excluded them from the sample). They are always matched on the same date. I manually matched amounts were debit = credit (1:1). Most of them match the same day. I have a few outliers which I think are accidental. I did...

Hi Narayan, First of all thanks for your help. I really appreciate it. I cannot be sure that there are any matches but from an accounting perspective it is highly unlikely that there are none. The only reason I can think of is that debit and credit are further apart in time and that the 300...

Sorry it took longer to upload the workbook, but here it is https://dl.dropbox.com/u/83088130/Chandoo%20VBA%20accounting%20problem.xls @Hui, I found those options when I googled, but I do not have enough VBA experience to adapt them to my specific situation. Thanks for the input.

NARAYANK991, thanks for your help. I'll post it tomorrow or the day after.

The process is a one time process. I have to repeat it for several GL accounts. They told me around 10 in total. After that the new system takes over. I also know for sure that not all entries will matches. Some are simply to recent. The list I am working with is a system dump and contains...

I have an accounting problem. I need to clean up a list of about 17000 lines. Incoming and outgoing payments have to be matched, meaning the sum of a group of invoices is exactly zero. The system has matched about 200 of them and I found about 300 more where debit and credit are exactly the...

I have this query (in Excel) on a Hyperion Database. One of the lines reads like this: <Link ((<LEV("Customers", "Lev0,Customers")) AND ( <IDESC("FRANCE"))) In this case FRANCE is a variable for a country. There are some 20 countries in all. I get the name of the variable from...

Hui, Once again thanks for answering my question. I did a few tests and it looks fine, so I am gonna break the links and send out the reports. Thank you for your help. Gert-Jan

I work in asset management and was wondering what everybody's ideas are to track the change in assets that we manage (overall). Broadly speaking there are two influences: - Investors' money flowing in and out of funds (inflow) - Value of investments that changes with the markets (market...

I have several reports where I copy sheets with lots of graphs and data points to a new workbook. I want to break the links to the graphs, but am a bit worried that I will get errors. I've tried it and for now it works fine. I've seen that Excel remembers the values. Is there a limit to the...

Exceluser is the site that really taught me the most when I started to develop my first dashboards http://www.exceluser.com The site itself looks flashy. Don't let this fool you. The example dashboards and graphs and stuff are clean, stripping out all the superfluous bits and pieces.

By far the most interesting site for me is the sparklines for Excel blogspot http://sparklines-excel.blogspot.com/ 100 per cent inspiration Discovered it through PHD a month ago and have been testing it ever since. it is brilliant. Gives me the chance to spend more time on analysis and...

Usually I find sites of interest when I am trying to solve a particular problem. http://www.codematic.net/ In this case i wanted to audit spreadsheets and I found the codematic website. They sell all kinds of Excel products, but also have a few very nice free tools It is the colourmapper...

Hui thanks for your suggestion. The Excel macro recorder doesn't recognize Essbase. I found another solution that I want to share When saving a query two files are generated an query file (*.eqd) and a report file (*.rep) You can drag the report file into Excel where it is displayed as...

For now i have solved it using a defined name for year In this formula it is the only thing that is different between Dutch and English. In Dutch jjjj, in English yyyy.