Listed Progress Tracker?

[Casey Allan]

Hi, All

 

I'm trying to replicate an excel spreadsheet that members of my department use daily.  It doesnt do any calculations - it's purely for people to type data into cells so that everyone can the status/progress through the dept of each file/document.

 

Person A updates Columns A-D,

Person B updates the Columns E-G,

Person C updates only column H,

Person D updates Column I.

 

My issue is that they don't update a row on the same day...so I need to be able to save any data that's entered into the tiddler.

 

There may be up to 14 rows a day updated by Person A but Person B might not update for a week (and when they do, it may only be two rows).

 

How do I preserve the data that Person A has typed in...and then save again when Person B decides to do their thing? (As with Persons C and D)

 

 

Any ideas?

 

Thanks for any help and hints :)

-C

 

 

 

 

[Casey Allan]

Oops, meant to say I'm using Classic, not TW5. Cheers :)

[whatever]

Hey!
Do I understand correctly that you basically want to use TWC instead of Excel? Not just use an adapter or something to get the data from Excel? In this case, I would suggest having a person enter each update in a separate tiddler and then using a plugin or custom JS to list the tiddlers. That way you can sort and filter the data any way you want.

w

[Casey Allan]

To be honest, if I could get away with opening the excel file inside an iFrame or something, I would. The bossman would just prefer that everything go through the wiki. I'll have a try at separate tiddlers. Thanks!