(Excel prototype) Couldn't be worse to start the week
-
Couldn't hav got a worse task to start the week on. My client wants a prototype in excel. How useful are these protoypes in excel anyway? Does anyone got any tips.. anybody knows of anytools that could help... :(
^John wrote:
How useful are these protoypes in excel anyway?
Amazingly so, actually. I've seen people put together useful "apps" with Excel. It's actually scary what you can do.
^John wrote:
Does anyone got any tips
The worst thing you will hear when developing a non-excel version of something prototyped in Excel is a manager saying "but it doesn't work the same as it does in Excel." :sigh: Marc Pensieve Some people believe what the bible says. Literally. At least [with Wikipedia] you have the chance to correct the wiki -- Jörgen Sigvardsson
-
Eh. You think you got a bad start. I spent all day trying to work out why a sonar system wasn't working. It was working last time I touched it. Now it just doesn't respond to any commands :doh: This system is meant to be demo'd in NZ next week. Nothing like a tight schedule :sigh:
Ryan
"Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late" John Nichol "Point Of Impact"
It was working last time I touched it.. Did you try pinging it? I'm truely very sorry for that pun, but it is Moday and i haven't had enough coffee '--8<------------------------ Ex Datis: Duncan Jones Merrion Computing Ltd
-
^John wrote:
How useful are these protoypes in excel anyway?
Amazingly so, actually. I've seen people put together useful "apps" with Excel. It's actually scary what you can do.
^John wrote:
Does anyone got any tips
The worst thing you will hear when developing a non-excel version of something prototyped in Excel is a manager saying "but it doesn't work the same as it does in Excel." :sigh: Marc Pensieve Some people believe what the bible says. Literally. At least [with Wikipedia] you have the chance to correct the wiki -- Jörgen Sigvardsson
-
Couldn't hav got a worse task to start the week on. My client wants a prototype in excel. How useful are these protoypes in excel anyway? Does anyone got any tips.. anybody knows of anytools that could help... :(
Many of the worlds more fluid and exciting financial systems (hedge funds, credit default swaps etc.) are run in excel sheets in production The best tip would be to give your worksheets and cells meaningful names - to do this select the cell in question and overtype the cell reference in with your alias. That way yo end up with equations that look like: GrossMargin = SaleValue - CostOfItem * (1 / VatRate) instead of G13 = G8 - G7 * (1 / Sheet1!A2) '--8<------------------------ Ex Datis: Duncan Jones Merrion Computing Ltd
-
^John wrote:
How useful are these protoypes in excel anyway?
Amazingly so, actually. I've seen people put together useful "apps" with Excel. It's actually scary what you can do.
^John wrote:
Does anyone got any tips
The worst thing you will hear when developing a non-excel version of something prototyped in Excel is a manager saying "but it doesn't work the same as it does in Excel." :sigh: Marc Pensieve Some people believe what the bible says. Literally. At least [with Wikipedia] you have the chance to correct the wiki -- Jörgen Sigvardsson
Marc Clifton wrote:
Amazingly so, actually. I've seen people put together useful "apps" with Excel. It's actually scary what you can do.
As long as you don't need blazing performance. I got ~3 orders of magnitude speedup by porting an 'optimized' vba/excel app to C#. The 'optimization' consisted of using temp vars instead of cells during calculations and disabling screen refreshes which were combined for about 1 magnitude of speedup.
-
Many of the worlds more fluid and exciting financial systems (hedge funds, credit default swaps etc.) are run in excel sheets in production The best tip would be to give your worksheets and cells meaningful names - to do this select the cell in question and overtype the cell reference in with your alias. That way yo end up with equations that look like: GrossMargin = SaleValue - CostOfItem * (1 / VatRate) instead of G13 = G8 - G7 * (1 / Sheet1!A2) '--8<------------------------ Ex Datis: Duncan Jones Merrion Computing Ltd
Duncan Edwards Jones wrote:
Many of the worlds more fluid and exciting financial systems (hedge funds, credit default swaps etc.) are run in excel sheets in production
So that explains why so many funds are tanking right now! :) Chris Meech I am Canadian. [heard in a local bar] When no one was looking, every single American woman between the ages of 18 and 32 went out and got a tatoo just above their rumpus. [link[^]]
-
It was working last time I touched it.. Did you try pinging it? I'm truely very sorry for that pun, but it is Moday and i haven't had enough coffee '--8<------------------------ Ex Datis: Duncan Jones Merrion Computing Ltd
I just projectile-regurgitated my Monday morning coffee into the adjacent cubicle. :rolleyes: That pun is so foul I'm going to have to send it to my step-dad (a punster of ancient and ill-repute in his own right).
Software Zen:
delete this; -
Duncan Edwards Jones wrote:
Many of the worlds more fluid and exciting financial systems (hedge funds, credit default swaps etc.) are run in excel sheets in production
So that explains why so many funds are tanking right now! :) Chris Meech I am Canadian. [heard in a local bar] When no one was looking, every single American woman between the ages of 18 and 32 went out and got a tatoo just above their rumpus. [link[^]]
They are just experiencing the "blue screen of reduced liquidity" :-D '--8<------------------------ Ex Datis: Duncan Jones Merrion Computing Ltd
-
^John wrote:
How useful are these protoypes in excel anyway?
Amazingly so, actually. I've seen people put together useful "apps" with Excel. It's actually scary what you can do.
^John wrote:
Does anyone got any tips
The worst thing you will hear when developing a non-excel version of something prototyped in Excel is a manager saying "but it doesn't work the same as it does in Excel." :sigh: Marc Pensieve Some people believe what the bible says. Literally. At least [with Wikipedia] you have the chance to correct the wiki -- Jörgen Sigvardsson
Marc Clifton wrote:
Amazingly so, actually. I've seen people put together useful "apps" with Excel. It's actually scary what you can do.
We have a trader here at work that has one of the most amazing excel sheets I have ever seen. He wrote an entire mortgage bond pricing application in excel. It is really pretty amazing. Just resently a team in our group rolled out an actual application that was based off of his spreadsheet.
-
They are just experiencing the "blue screen of reduced liquidity" :-D '--8<------------------------ Ex Datis: Duncan Jones Merrion Computing Ltd
-
It was working last time I touched it.. Did you try pinging it? I'm truely very sorry for that pun, but it is Moday and i haven't had enough coffee '--8<------------------------ Ex Datis: Duncan Jones Merrion Computing Ltd
"Give me a ping Vasily, one ping only." ¡El diablo está en mis pantalones! ¡Mire, mire! Real Mentats use only 100% pure, unfooled around with Sapho Juice(tm)! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF!
-
"Give me a ping Vasily, one ping only." ¡El diablo está en mis pantalones! ¡Mire, mire! Real Mentats use only 100% pure, unfooled around with Sapho Juice(tm)! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF!
:cool: movie; one of my favorites. Another of my favorite lines: "I'm a politician, which means ah'm a cheat and a liar. When I'm not kissin' babies, I'm stealin' their lollipops."
Software Zen:
delete this; -
It was working last time I touched it.. Did you try pinging it? I'm truely very sorry for that pun, but it is Moday and i haven't had enough coffee '--8<------------------------ Ex Datis: Duncan Jones Merrion Computing Ltd
Duncan Edwards Jones wrote:
Did you try pinging it?
:rolleyes: It's the part that does the pinging that doesn't work!
Ryan
"Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late" John Nichol "Point Of Impact"
-
Ryan Binns wrote:
why a sonar system wasn't working.
Tried it under water ? ~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
Rage wrote:
Tried it under water ?
;-P Sonar works in air as well. Besides, it's RS232 connected, and the computer doesn't even recognise that it's there.
Ryan
"Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late" John Nichol "Point Of Impact"
