The data looks like this, representing customer counts & sales in 15 min incr. I need totals & percentages for each day, by section (cols 3,4,5/6,7,8, etc). 
12/17/2002,0700,001,0000,00000.00,000,0004,00022.15,...
12/17/2002,0715,001,0000,00000.00,000,0012,00036.38,...
12/17/2002,0730,001,0000,00000.00,000,0014,00048.18,...
12/17/2002,0745,001,0000,00000.00,000,0016,00142.67,...
12/17/2002,0800,001,0000,00000.00,000,0023,00008.28,...
12/17/2002,0815,001,0000,00000.00,000,0052,00419.79,...
12/17/2002,0830,001,0000,00000.00,000,0047,00026.52,...
12/17/2002,0845,001,0000,00000.00,000,0071,00028.81,...

[download]

Okay. But your still holding back on the details. And there are anomolies in what you are saying.

You say the figures represent "customer counts & sales", but then say a section consists of 3 columns? And when you originally posted, prior to wiping it out with your first update, you said 5 sets of 4 columns?

You say the figures are in 15 minute increments, but originally said each file contained 80 rows. The web site closes for 4 hours each night?

You say "I need totals & percentages for each day, by section". Totals down each column? Totals across each row? What percentages? How many percentages?

You also originally mentioned 366 files, and now mention year end rollover, but make no mention if you are trying to roll up the daily stats across the year?

Finally, you are "doing this for free", to help someone out--and then come here and ask for help. You offer no code. And give no clues as to what part you are having a problem with? Do you know how to open and read a file in Perl?

I'll let you think about what implications people might draw from that lot.

Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.
"Too many [] have been sedated by an oppressive environment of political correctness and risk aversion."

In reply to Re^3: Looking for some design guidance by BrowserUk
in thread Looking for some design guidance by Aim9b

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.