Half a croissant, on a plate, with a sign in front of it saying '50c'
h a l f b a k e r y
Left for Bread

idea: add, search, annotate, link, view, overview, recent, by name, random

meta: news, help, about, links, report a problem

account: browse anonymously, or get an account and write.

user:
pass:
register,


                       

Please log in.
Before you can vote, you need to register. Please log in or create an account.

Excel link and db

A client (pref web client) for linking excels and sharing them as database
  (-1)
(-1)
  [vote for,
against]

Not what google gives you in first 5 pages under excel db.

Make a smart user interface that can read and store header and data information, by chosing from an existing excel or several excels.

You have the ability to work on data-entry concurrently, (several people at same time) without locking each other out, with transactions, using access like data entry forms.

You get data-change history (who changed what cell when), version control and most important: you get "paging" where only some of the data is shown at a time.

The only difference between this and any real database, is that some of the information (probably the most important) is stored in viewable excel files, which are what probably started the process. You won't be allowed to insert excel rows, and if entered manually, mistakes will occur.

Probably best thing to integrate the UI within the excel UI.

pashute, Nov 21 2007

Excel Services http://blogs.msdn.c...5/11/09/490926.aspx
I think what you want is close to "What Excel Services is not", point 2. [jutta, Nov 21 2007]

Presence-AR Adapter for Excel http://www.shared-s...dvanced_realit.html
I don't think this actually exists anymore - the company doesn't - but it's closer to what you want, right? [jutta, Nov 21 2007]

Wikipedia: List of online spreadsheets http://en.wikipedia...online_spreadsheets
Their collaborative capabilities will vary, but most will have at least some. [jutta, Nov 21 2007]

The joys of collaborative software... http://web.okaygo.c...s/letters/flashcom/
[zen_tom, Nov 21 2007]

[link]






       When you write "excel", do you mean "spreadsheets"? This is an idea for a shared (multi-user, collaborative) spreadsheet editor?   

       Why would you care how the information is stored, as long as you can access it in the form you want?   

       The change history would be a nice touch. I don't think many current systems do this.
jutta, Nov 21 2007
  

       "Make a smart user interface..." some jokes are too good to go unnoticed.
4whom, Nov 21 2007
  

       This exists in the form of databases.   

       Hot editing isn't great though - it's ugly and slow, and can be horribly annoying, and prone to all manner of nasty errors.   

       If it doesn't exist in the form of databases, simply have a database, and point a whole bunch of spreadsheets at it (using a simple ODBC link) and have them all update every 5 seconds (try to block out your ears at this point, as the network admin starts to scream hairy blue-murder). Then, try to change something, and watch as someone else tries to change it back immediately - in fact, I have seen something only mildly less infuriating - I'll try to find a link...
zen_tom, Nov 21 2007
  

       The sad thing is, this has been done several times. Its a bad thing. (google excel site:www.thedailywtf.com)
Spacecoyote, Nov 21 2007
  

       //have a database, and point a whole bunch of spreadsheets at it (using a simple ODBC link)//   

       This approach would be less bad if the database in question were Oracle (or something else that gives you rollback segments? is there anything else?), since it would give you transactional integrity without massive lockup problems.   

       However, the users would need to understand the implications of transactional integrity, and the code around the ODBC link would need to be quite clever about when to trigger a rollback.   

       ...and, even if you didn't refresh every five seconds, you would still be doing quite a lot of refreshing. Maybe this could be minimized if code in database triggers pushed incremental refreshes out to the relevant client PCs.
pertinax, Nov 22 2007
  

       [AllCommenters], I'm not talking about collaboration. I'm talking about data entry and reports. You have all this information in excel sheets. Make an Access like program for linking tables etc. but not a PROGRAMMERS environment, rather a USERS environment, with the UNDERLYING DATABSE being the excel sheets.   

       It could actually be implemented *WITH AN ORACLE DATABASE* but thats completely transparent and not seen by the users. They just give the sources of data, taking sections of various (ok Jutta) workbooks in various spreadsheets. Yes Presence-AR '''sounds''' like what I wanna do...
pashute, May 20 2008
  

       So Google Sheets?   

       And please don't use a relational database as a backend for a spreadsheet.
notexactly, May 27 2018
  
      
[annotate]
  


 

back: main index

business  computer  culture  fashion  food  halfbakery  home  other  product  public  science  sport  vehicle