2

I have a friend that is working on a company without any real IT people, and they've gone the classical corporate route of stringing things together with Excel macros whenever they need something. I was trying to figure out what alternatives are available for someone that isn't a programmer by trade.

What is an easy alternative to Excel when you want to distribute data offline together with forms for manipulating it, that doesn't have a steep learning curve? I was going to suggest he learn Python and SQL-lite, but I'm hoping StackOverflow can come up with a wiser answer.

Rubén
  • 34,714
  • 9
  • 70
  • 166
Kit Sunde
  • 35,972
  • 25
  • 125
  • 179

2 Answers2

3

Honestly, for non developers (and if you do not have a dev staff in-house) there really isn't anything wrong with Excel.

That being said, Lightswitch is a new and fairly interesting option for basic forms over data work (although it's still a bit green).

IMO once you go down the route of languages like Python, etc. you're really looking at someone who is going to have to be a programmer (and they may be shooting themselves in the foot on a regular basis).

Bob Palmer
  • 4,714
  • 2
  • 27
  • 31
  • I agree. Excel is a powerful functional/dataflow language, *and* is easy to use for non-programmers. Why not use it? – Jörg W Mittag Nov 29 '10 at 03:50
  • 2
    Interestingly, the fact that so many non-programmers can use Excel perfectly fine, also proves that the common argument that "functional programming is hard to learn" is essentially BS. – Jörg W Mittag Nov 29 '10 at 03:52
  • I do agree with you, it just pains me to see him tear away at Excel and doing GUI things with it and was trying to think of reasonable alternatives. He has sort of ad-hoc learned programming to deal with managers requests. I do think that they should staff a programmer (for various reasons), rather than let the marketing guy waste away man hours figuring things out on his own. I'll have a look at Lightswitch though. Thank you! :) – Kit Sunde Dec 01 '10 at 06:56
0

In that type of environment users end up with Excel or Access to manipulate data. Excel is convenient where cells in row are calculated the same way, but with exceptional cases. Access is better for calculating over multiple rows easily, data management forms (yes Excel can do it too, but Access is easier) and formatted reports.

The best situation I've arrived at in this type of environment is standing up read only "data warehouse" that Excel and Access users can link or download data from to manipulate on their own. For this situation SQL Server is probably the right choice and I use quotes around "data warehouse" because I don't mean it in the technical sense, but rather just a convenient repository. That way you have one definitive system of record. Then any report generated in either tool repeatedly becomes a candidate for incorporation into that warehouse.

orangepips
  • 9,891
  • 6
  • 33
  • 57