One for you EXCEL experts.
I have a case in which a defendant, call him Fred, is alleged to have stolen various amounts of cash on various dates from the shop where he worked & to have banked some of the cash in his personal bank account.
I have a list of dates & amounts of cash missing from the till (allegedly stolen by Fred) and dates & amounts of cash banked by Fred in his personal account.
The suggestion is that the bankings support the theft allegation.
The problem is that, to the naked eye, there does not appear (to me at least) to be any pattern to either the thefts or the bankings - nor any obvious linkage between thefts & bankings.
I want to put these lists into some sort of visual evidence which can be understood by a jury in the Crown Court.
The EXCEL spreadsheet comprises dates in column A, alleged amounts stolen from the till in column B, and amounts banked by Fred in his personal account in column C.
There are entries in column A (dates) only where there is an item in either column B (thefts) or column C (bankings), or both.
In total there are just under 100 lines in the spreadsheet covering a period of about 15 months.
My thinking is that perhaps I could calculate for each week in the 15 month period the amount stolen & banked in that week, and then calculate cumulative totals of stolen to date & banked to date, and then present a graph of those cumulative figures over the 15 months to see if they march in step.
I can do that in a rather pedestrian way in EXCEL but no doubt there is a quicker way than faffing about creating extra columns with numerous formulae & then graphing those columns.
Can anybody save me some time?