Fun with Excel

Comments

• ShadowDancer When I say, "Why aye, gadgie," in my heart I say, "Och aye, laddie." London, UK

  January 2007

  were you bored? and dare i ask what it does? i could open excel and figure it out, but im too lazy:D
• Freejack Jake the Not-so-Wise

  January 2007

  If calculates the a metric called Days Sales Open by customer, using Sales and Accounts Receivable data from two different worksheets in the same workbook.
  
  Jake
• Mr_Bester Earthforce Officer St Louis MO

  January 2007

  I'm glad you can do that, the thought of doing anything excel makes me wet myself. I'd much rather work in a graphics app. At least those make sense to me. If I wanted to type a bunch of words that eventually did what I wanted them to(if I didn't have typos), I'd have become a programmer....
  
  Freejack,
  By the way, based on your color, are you a designer?
  
  Dug
• Freejack Jake the Not-so-Wise

  January 2007

  Unfortunately no....485C was one of the primary colors of the RIDGID brand woodworking tools when I was a product manager that company.
  
  Jake
• Biggles <font color=#AAFFAA>The Man Without a Face</font>

  January 2007

  Purely for maintenance reasons, you might want to consider rewriting that as a VB macro. :D
• Random Chaos Actually Carefully-selected Order in disguise

  January 2007

  Uh, might I suggest you just invest in a database?
  
  That's a sure way to:
  
  A. Kill a future programmer. You could be accused of "negligent forced suicide."
  
  B. Explode the universe.
  
  C. Break every MS product in existance.
  
  D. Become a maintenance nightmare for you.
• Freejack Jake the Not-so-Wise

  January 2007

  Eh, its for a report that will get run only once an month and covers only 250 customers. I'm pretty much done with the report, I just have two simple reports that are pulled down from JDE then dropped into the spreadsheet, and it does it's magic.
  
  And, if I had the chance, I would indeed break every MS product in existence...
  
  Jake