Re: [SL] Trend analysis

[J.M. \Jersey\ M. <je...@ib...>]

"little" scripts are "biiig" for some people :). Would you share it?

Best regards
"Jersey"

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of C.
Duncan Hudson
Sent: 04 June 2008 04:29 AM
To: sql...@li...
Subject: Re: [SL] Trend analysis

What kind of trends are you looking for?  For sales analysis I wrote a 
little Perl script that is cron'd to run on the 5th day of each month 
(gives me a couple of days to fix any month end issues).  The script 
summarizes each sales person's sales and receivables for the month.  It 
also provides a delta of the month over the previous month and the month 
over the same month one year ago.  Finally, it builds a nice little 
(electric company bill style) 13 month bar graph.  The script then 
emails the personalized report to the salesperson and their manager.

For inventory analysis I have a Perl script that  is cron'd hourly.  My 
reorder points (minimum), and EOQ are recalculated each time the script 
runs.  When ever any of the stocked items falls below their minimum an 
email is fired off to the person who does the parts ordering.  The 
script also does Pareto Analysis (ABC) and labels each item as such 
along with its percentage of both sales and revenue.

Dunc

Munroe Sollog wrote:
> I am wondering how people perform trend analysis?
>
> I am looking to graph my AR and AP and different journals  etc...  It
> looks like sql-ledger has some very standard reports built-in but is
> there another tool that people use other than a spreadsheet?
>
>   


-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users


-- 
No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 269.24.6/1481 - Release Date: 6/3/2008
7:31 PM