🚀 go-pugleaf

In article <1992Aug26.170745.29793@cbnewsj.cb.att.com> dbw@cbnewsj.cb.att.com (david.b.wood) writes:

>I have a small database of expenses listed by date, and I want to
>generate a data table of per-month totals (actually, from the 15th of
>one month to the 14th of the next, although I can't make it work even
>for calendar months).  When I set up the data table, the criterion
>range doesn't seem to take its date input as variable:  I get the same
>sum for every month.  (123 version 2.01)

>How do I set up such a table?  (I want to use data table to compute the
>table only as necessary, since it takes forever.)

>Thanks,
>Dave Wood dbw@germany.att.com


In response to your question:

          A           B        C      D     E     F     G
1     Date           Cash
2     --------------------
3     25-May-92    608.65
4     29-May-92    627.17
5     01-Jun-92    935.74
6     03-Jun-92    150.94
7     08-Jun-92    230.04
8     22-Jun-92    603.97
9     22-Jun-92    888.00
10    28-Jun-92    984.42
11    08-Jul-92    576.67
12    11-Jul-92    341.09
13    12-Jul-92    107.34
14    15-Jul-92    216.70
15    18-Jul-92    985.83
16    25-Jul-92    676.99
17    02-Aug-92     46.07
18    05-Aug-92    728.39
19    08-Aug-92    402.64
20    20-Aug-92    291.04
21    22-Aug-92    873.09
22    24-Aug-92    937.98
23    26-Aug-92    584.15
24    27-Aug-92    147.53
25    --------------------
26    Total     11,944.44
27    ====================
28
29
30                                  Date  Date  Date  Date
31    May-Jun    2,552.54              0     0     0     0
32    Jun-Jul    3,501.49
33    Jul-Aug    3,056.62
34    Aug-Sep    2,833.79
35    --------------------
36    Total     11,944.44
37    ====================
          A           B        C      D     E     F     G


The working formulae follow:

D30:  'Date
E30:  'Date
F30:  'Date
G30:  'Date
A31:  'May-Jun
B31:  @DSUM(A1..B25,1,D30..D31)
D31:  +A2>=@DATE(92,5,15)#AND#A2<@DATE(92,6,15)
E31:  +A2>=@DATE(92,6,15)#AND#A2<@DATE(92,7,15)
F31:  +A2>=@DATE(92,7,15)#AND#$A2<@DATE(92,8,15)
G31:  +A2>=@DATE(92,8,15)#AND#A2<@DATE(92,9,15)
A32:  'Jun-Jul
B32:  @DSUM(A1..B25,1,E30..E31)
A33:  'Jul-Aug
B33:  @DSUM(A1..B25,1,F30..F31)
A34:  'Aug-Sep
B34:  @DSUM(A1..B25,1,G30..G31)



Richard Glew
Lakehead University