Manipulating data to get a Days in AR Calculation

[petermb72]

Here is the basics of what I have and what I need:

I have a table with Fiscal Period Number(1=Oct), Fiscal Year, Monthly Balances for Multiple AR accounts, Monthly Balances for Multiple Revenue Accounts.  Also there is a Fiscal Period 0 which represents previous year AR Balance. I have a date table.

What I would like:

I need a calculation that is Monthly AR Total divided by Monthly Total for Revenue accounts divided by number of days in the month. AR Total/(Rev Total/#of days in month). This gives me my days in AR

I then need to graph that for Number of days in AR per month, and Number of days in AR YTD. 

Hear is what the data looks like in excel:

Month	Day in AR MTH	Day in AR YTD	Target Day in AR		# of Days	AR Balance Mth	Resident Revenue Mth	Resident Revenue Ytd
Sep-19	30.70	31.40			30	1,134,992.91	1,109,293.95	13,192,841.34
Aug-19	36.78	37.64			31	1,357,630.26	1,144,421.81	12,083,547.39
Jul-19	28.40	28.91			31	1,040,300.32	1,135,412.82	10,939,125.58
Jun-19	28.57	29.23			30	1,049,699.34	1,102,262.41	9,803,712.76
May-19	36.47	36.13			31	1,293,904.83	1,099,724.37	8,701,450.35
Apr-19	28.42	27.72			30	993,801.77	1,048,982.88	7,601,725.98
Mar-19	29.87	31.15			31	1,121,686.15	1,164,071.70	6,552,743.10
Feb-19	26.42	25.50			28	910,072.66	964,316.92	5,388,671.40
Jan-19	27.02	27.75			31	998,037.52	1,145,187.03	4,424,354.48
Dec-18	24.57	24.16			31	861,260.63	1,086,799.25	3,279,167.45
Nov-18	24.73	24.69			30	887,451.16	1,076,769.19	2,192,368.20
Oct-18	22.88	22.88			31	823,237.94	1,115,599.01	1,115,599.01

There is a difference between what is in excel and what I can get out of the data.  For period 1(Oct-18) I have a smaller number until I add in the Period 0 (Previous Balance).  Then The totals match up.  I hope this makes sence.  I have beat my head aginst the wall for a week now and Have not gotten what I need.  Any help would graciously apreciated.  

Thanks,

Peter

[Anonymous]

HI @petermb72 ,

I add three calculate columns to extract date and calculate month total AR and YTD total AR:

Date = 
VAR _path =
    SUBSTITUTE ( [Month], "-", "|" )
RETURN
    DATEVALUE ( PATHITEM ( _path, 1 ) & "/1/" & PATHITEM ( _path, 2 ) )

Daily AR of Month = 
[AR Balance Mth]/([Resident Revenue Mth]/[# of Days])

Daily AR of Year =
VAR filtered =
    FILTER ( T3, T3[Date] <= EARLIER ( T3[Date] ) )
RETURN
    CALCULATE ( SUM ( T3[AR Balance Mth] ), filtered )
        / DIVIDE (
            T3[Resident Revenue Ytd],
            CALCULATE ( SUM ( T3[# of Days] ), filtered )
        )
        - CALCULATE (
            SUM ( T3[Daily AR of Month] ),
            FILTER ( T3, T3[Date] < EARLIER ( T3[Date] ) )
        )

You can use them to create a line chart to show the graph:

Since I get different results from the snapshot, can you please explain more about YTD AR calculate? 

Regards,

Xiaoxin Sheng

[petermb72]

the formula for the AR YTD =  AR Balance for the month / (Revenue YTD / # of days YTD)

Does this make a difference in your formulas?

I am very thankful for your help!  It is people like you that make the beginners like me believe in humanity again!  I hope I can help someone else someday.  If I have any more questions about this, may I contact you?

Peter

[petermb72]

Also here are my column headings that I am dealing with in the raw data:

Year, Period ID, Account Type, Balance.  In that same order I have data that looks like:   2019, 0, Accounts Recievable, $3,000.00

I have multiple accounts receivable accounts as well as multiple revenue accounts (ie, Nursing Revenue and Other Revenue, and multiples of each of them).

Period 0 only have totals for AR accounts.  Revenue accounts have periods 1-12.  I am just trying to give you all the info that I can.  There is other fields but I am giving you just the pertinate ones.

Thanks, Peter

[Anonymous]

Hi @petermb72 ,

So you mean most of the AR fields not really existed in your raw table? Can you please share some sample data for test?

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[petermb72]

Part 1 of Sample Data

Fiscal Year	Fiscal Period
2019	0
2019	1
2019	10
2019	11
2019	12
2019	2
2019	3
2019	4
2019	5
2019	6
2019	7
2019	8
2019	9
2019	0
2019	1
2019	10
2019	11
2019	12
2019	2
2019	3
2019	4
2019	5
2019	6
2019	7
2019	8
2019	9
2019	0
2019	1
2019	10
2019	11
2019	12
2019	2
2019	3
2019	4
2019	5
2019	6
2019	7
2019	8
2019	9
2019	0
2019	1
2019	10
2019	11
2019	12
2019	2
2019	3
2019	4
2019	5
2019	6
2019	7
2019	8
2019	9
2019	1
2019	12
2019	8
2019	9
2019	0
2019	1
2019	10
2019	12
2019	3
2019	4
2019	6
2019	7
2019	9
2019	1
2019	10
2019	11
2019	12
2019	2
2019	3
2019	4
2019	5
2019	6
2019	7
2019	8
2019	9
2019	1
2019	10
2019	11
2019	12
2019	2
2019	3
2019	4
2019	5
2019	6
2019	7
2019	8
2019	9
2019	1
2019	10
2019	11
2019	12
2019	2
2019	3
2019	4
2019	5
2019	6
2019	7
2019	8
2019	9
2019	1
2019	10
2019	11
2019	12
2019	2
2019	3
2019	4
2019	5
2019	6
2019	7
2019	8
2019	9
2019	1
2019	10
2019	11
2019	12
2019	2
2019	3
2019	4
2019	5
2019	6
2019	7
2019	8
2019	9
2019	10
2019	12
2019	3
2019	4
2019	7
2019	8
2019	1
2019	10
2019	12
2019	3
2019	4
2019	5
2019	8
2019	9
2019	2
2019	7
2019	8
2019	9
2019	1
2019	10
2019	11
2019	12
2019	2
2019	3
2019	4
2019	5
2019	6
2019	7
2019	8
2019	9
2019	1
2019	10
2019	11
2019	12
2019	2
2019	3
2019	4
2019	5
2019	6
2019	7
2019	8
2019	9
2019	3
2019	4
2019	8
2019	9
2019	1
2019	10
2019	11
2019	12
2019	2
2019	3
2019	4
2019	5
2019	6
2019	7
2019	8
2019	9
2019	1
2019	2
2019	3
2019	1
2019	10
2019	11
2019	12
2019	2
2019	3
2019	4
2019	5
2019	6
2019	7
2019	8
2019	9

[petermb72]

Part 3 (column 5,6)

NetIncome	DayinMonth
$195,875.35
($29,015.77)	31
$79,591.90	31
$109,911.51	31
$23,909.11	30
$32,241.32	30
$5,689.19	31
$4,862.84	31
($59,207.21)	28
$58,015.48	31
($38,389.66)	30
$56,768.57	31
($60,949.78)	30
$498,346.14
($19,568.66)	31
$21,806.06	31
$127,595.98	31
($120,389.68)	30
$6,747.94	30
($13,212.39)	31
$53,316.12	31
$1,373.45	28
$54,096.14	31
($72,667.74)	30
($7,334.84)	31
($21,456.97)	30
$169,272.74
$49,416.13	31
($117,840.21)	31
$78,008.71	31
($94,166.49)	30
$18,991.64	30
($32,355.18)	31
$74,581.37	31
($24,626.04)	28
$94,786.64	31
($28,339.78)	30
$41,499.22	31
$25,024.71	30
$13,542.28
($4,714.16)	31
$7,043.23	31
$1,813.74	31
($222.51)	30
$6,232.32	30
$3,908.06	31
($168.37)	31
($5,505.06)	28
($714.99)	31
($894.77)	30
$3,870.11	31
$362.95	30
$0	31
$18,232.22	30
$205,300	31
($205,300)	30
($50,000)
$83.89	31
$0	31
($50,000)	30
$9,779.79	31
$4,184.93	31
$5,430.22	31
$12,407.57	30
$18,113.60	30
$451,743.10	31
$446,472.82	31
$449,207.70	31
$426,577.38	30
$439,561.16	30
$444,726.42	31
$475,007.63	31
$479,865.90	28
$473,135.25	31
$466,857.69	30
$467,182.83	31
$485,501.24	30
$408,726.35	31
$418,473.82	31
$390,924.98	31
$435,414.22	30
$360,362.77	30
$393,408.61	31
$348,812.85	31
$248,305.25	28
$329,061.22	31
$296,304.21	30
$308,628.88	31
$303,260.07	30
$46,008.59	31
$48,714.70	31
$64,345.41	31
$82,583.48	30
$48,649.95	30
$44,201.15	31
$49,829.90	31
$22,043	28
$24,344.23	31
$31,338.73	30
$28,642.29	31
$21,305.86	30
$178,651.71	31
$191,425.50	31
$210,457.87	31
$139,584.94	30
$190,908.19	30
$186,114.78	31
$196,865.12	31
$199,853.54	28
$298,920.55	31
$236,549.02	30
$266,060.72	31
$268,032.60	30
($72,471.50)	31
($123,082.96)	31
($94,149.83)	31
($54,776.83)	30
($87,151.88)	30
($97,433.14)	31
($59,303.67)	31
($126,094.36)	28
($141,115.13)	31
($122,563.98)	30
($149,118.57)	31
($120,440.31)	30
($89.84)	31
$59.04	30
($10)	31
($15)	31
($30)	30
$0.82	31
($20.34)	31
$14.48	31
$969.73	30
($143.66)	31
$79.58	31
($128.52)	28
$916.73	31
$1,603.70	30
($73.54)	30
($1,980.62)	30
$108.71	31
($1,221.25)	30
$79,072.75	31
$85,928.47	31
$82,536.94	31
$56,899.34	30
$88,931.05	30
$74,401.05	31
$100,425.77	31
$93,913.78	28
$125,191.82	31
$98,548.14	30
$123,980.03	31
$103,513.89	30
$7,563.19	31
$23,692.95	31
$17,139.63	31
$16,162.21	30
$14,032.81	30
$16,266.61	31
$19,906.82	31
$9,697.05	28
$9,309.45	31
$8,475.31	30
$13,256.91	31
$12,893.52	30
$147	31
($147)	31
$2,004.44	31
($112.41)	30
$14,191.46	31
$47,445.91	31
$26,417.12	31
$8,502.31	30
$24,262.34	30
$26,940.99	31
$17,357.19	31
$38,695.67	28
$46,552.81	31
$36,891.34	30
$39,795.38	31
$30,169.97	30
$3,386.43	31
($364.32)	30
$52.41	31
($1,252.73)	31
($3,583.03)	31
($2,458.01)	31
($2,681.87)	30
($2,349.34)	30
($1,872.97)	31
($3,632.16)	31
($1,834.39)	28
($1,328.50)	31
($1,406.96)	30
($1,734.80)	31
($2,244.47)	30

[petermb72]

Part 2 sample data (column 3 and 4)

Acct#	AccountCat
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1145	AR
1145	AR
1145	AR
1145	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4110	Ancil. Rev
4110	Ancil. Rev
4110	Ancil. Rev
4110	Ancil. Rev
4110	Ancil. Rev
4110	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4124	Ancil. Rev
4124	Ancil. Rev
4124	Ancil. Rev
4124	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4220	Ancil. Rev
4220	Ancil. Rev
4220	Ancil. Rev
4220	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4240	Ancil. Rev
4240	Ancil. Rev
4240	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev

[petermb72]

Part 2 of Sample Data

Acct #	AccountCat
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1145	AR
1145	AR
1145	AR
1145	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4110	Ancil. Rev
4110	Ancil. Rev
4110	Ancil. Rev
4110	Ancil. Rev
4110	Ancil. Rev
4110	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4124	Ancil. Rev
4124	Ancil. Rev
4124	Ancil. Rev
4124	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4220	Ancil. Rev
4220	Ancil. Rev
4220	Ancil. Rev
4220	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4240	Ancil. Rev
4240	Ancil. Rev
4240	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev

[petermb72]

Can you let me know how I can attach or get you the sample data?

Thanks!

[Anonymous · Accepted solution]

Hi @petermb72 ,

Please check below sample file if it is suitable for your requirement.

Formulas:

AR Balance Mth =
CALCULATE (
    SUM ( Sheet1[NetIncome] ),
    FILTER (
        Sheet1,
        [Fiscal Year] = EARLIER ( Sheet1[Fiscal Year] )
            && [Fiscal Period] = EARLIER ( Sheet1[Fiscal Period] )
            && [CalMonth] = EARLIER ( Sheet1[CalMonth] )
    )
)

Resident Revenue Mth =
CALCULATE (
    SUM ( Sheet1[NetIncome] ),
    FILTER (
        Sheet1,
        [AccountCat] <> "AR"
            && [Fiscal Year] = EARLIER ( Sheet1[Fiscal Year] )
            && [Fiscal Period] = EARLIER ( Sheet1[Fiscal Period] )
            && [CalMonth] = EARLIER ( Sheet1[CalMonth] )
    )
)

Resident Revenue YTD =
CALCULATE (
    SUM ( Sheet1[NetIncome] ),
    FILTER (
        Sheet1,
        [AccountCat] <> "AR"
            && [Fiscal Year] = EARLIER ( Sheet1[Fiscal Year] )
            && [Fiscal Period] <= EARLIER ( Sheet1[Fiscal Period] )
    )
)

Daily AR of Month = 
[AR Balance Mth]/([Resident Revenue Mth]/[DayinMonth])

Daily AR of Year = 
[AR Balance Mth]
    / (
        [Resident Revenue YTD]
            / SUMX (
                SUMMARIZE (
                    FILTER (
                        Sheet1,
                        [Fiscal Year] = EARLIER ( Sheet1[Fiscal Year] )
                            && [Fiscal Period] <= EARLIER ( [Fiscal Period] )
                    ),
                    [Fiscal Year],
                    [Fiscal Period],
                    [CalMonth],
                    [DayinMonth]
                ),
                [DayinMonth]
            )
    )

Date = 
   IF([CalMonth]<>BLANK(), DATEVALUE ( [Fiscal Period] & "/1/" & [Fiscal Year] ))

Regards,

Xiaoxin Sheng

[petermb72]

Part 2 (column 3,4)

Acct	AccountCat
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1145	AR
1145	AR
1145	AR
1145	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4110	Ancil. Rev
4110	Ancil. Rev
4110	Ancil. Rev
4110	Ancil. Rev
4110	Ancil. Rev
4110	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4124	Ancil. Rev
4124	Ancil. Rev
4124	Ancil. Rev
4124	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4220	Ancil. Rev
4220	Ancil. Rev
4220	Ancil. Rev
4220	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4240	Ancil. Rev
4240	Ancil. Rev
4240	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev

[petermb72]

Part 4 (column  7)

CalMonth
10
7
8
9
11
12
1
2
3
4
5
6
10
7
8
9
11
12
1
2
3
4
5
6
10
7
8
9
11
12
1
2
3
4
5
6
10
7
8
9
11
12
1
2
3
4
5
6
10
9
5
6
10
7
9
12
1
3
4
6
10
7
8
9
11
12
1
2
3
4
5
6
10
7
8
9
11
12
1
2
3
4
5
6
10
7
8
9
11
12
1
2
3
4
5
6
10
7
8
9
11
12
1
2
3
4
5
6
10
7
8
9
11
12
1
2
3
4
5
6
7
9
12
1
4
5
10
7
9
12
1
2
5
6
11
4
5
6
10
7
8
9
11
12
1
2
3
4
5
6
10
7
8
9
11
12
1
2
3
4
5
6
12
1
5
6
10
7
8
9
11
12
1
2
3
4
5
6
10
11
12
10
7
8
9
11
12
1
2
3
4
5
6

[petermb72]

Part 2 (column 3 and 4)

acct	AccountCat
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1110	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1115	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1120	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1125	AR
1145	AR
1145	AR
1145	AR
1145	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
1170	AR
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4010	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4020	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4028	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4030	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4090	Nursing
4110	Ancil. Rev
4110	Ancil. Rev
4110	Ancil. Rev
4110	Ancil. Rev
4110	Ancil. Rev
4110	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4120	Ancil. Rev
4124	Ancil. Rev
4124	Ancil. Rev
4124	Ancil. Rev
4124	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4130	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4140	Ancil. Rev
4220	Ancil. Rev
4220	Ancil. Rev
4220	Ancil. Rev
4220	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4230	Ancil. Rev
4240	Ancil. Rev
4240	Ancil. Rev
4240	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev
4290	Ancil. Rev