They Think I'm a Genius
-
I wrote a wizard app for one of our co-workers that merges two Excel spreadsheets by matching selected columns based on one or more matching criteria (this column value == that column value), and combining the selected columns into a single file. I essentially reduced a 2-5 day process (depending on the size of the two datasets) to no more than an hour. The reason it takes an hour is because the half-assed Telerik spreadsheet control/document code doesn't understand formulas very well, and also doesn't support Date column types, so the user has to manually modify the merged data to suit their ultimate needs. I would write an article, but the code relies on the Telerik WPF library, which is not free.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013 -
Jeremy Falcon wrote:
Thinking you're better than someone for knowing more than someone in *your* field isn't advanced - it's arrogant.
Arrogance is kinda my superpower. That, and marksmanship.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013I thought your arsenal was your superpower. Arrogance is just part of your charm ;P :-D :laugh:
M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.
-
People that don't live in front of a computer aren't primitive. They simply have different interests and therefore know different things. Thinking you're better than someone for knowing more than someone in *your* field isn't advanced - it's arrogant.
Jeremy Falcon
Agree... my wife is very smart (Dr. med.) but coming to gadgets and computers... it hurts to see her using her laptop :rolleyes: :rolleyes: But hey... I am still very lucky, I don't get "My computer is not working" more than 1 or 2 times per year
M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.
-
I wrote a wizard app for one of our co-workers that merges two Excel spreadsheets by matching selected columns based on one or more matching criteria (this column value == that column value), and combining the selected columns into a single file. I essentially reduced a 2-5 day process (depending on the size of the two datasets) to no more than an hour. The reason it takes an hour is because the half-assed Telerik spreadsheet control/document code doesn't understand formulas very well, and also doesn't support Date column types, so the user has to manually modify the merged data to suit their ultimate needs. I would write an article, but the code relies on the Telerik WPF library, which is not free.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013Amen. I fleshed out over-the-top detection algorithms with 99.6% accuracy (wrt the 64% of previous one) and managed to squeeze its maximum 13 ms completion time in 4.5 ms. No one batted an eye. I made a bunch of 5-8 lines utility functions and "Woah! Amazing!".
DURA LEX, SED LEX GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver When I was six, there were no ones and zeroes - only zeroes. And not all of them worked. -- Ravi Bhavnani
-
I wrote a wizard app for one of our co-workers that merges two Excel spreadsheets by matching selected columns based on one or more matching criteria (this column value == that column value), and combining the selected columns into a single file. I essentially reduced a 2-5 day process (depending on the size of the two datasets) to no more than an hour. The reason it takes an hour is because the half-assed Telerik spreadsheet control/document code doesn't understand formulas very well, and also doesn't support Date column types, so the user has to manually modify the merged data to suit their ultimate needs. I would write an article, but the code relies on the Telerik WPF library, which is not free.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013In the first contract job I had, I noticed that every night, one of my colleagues started a VB program to go against the company database of 30M records. It only wanted about 3K records each time it was run. When I asked him why he started it just before going home, he said it took 20+ hours to extract the data. When I got back in the morning, I looked at the code. The code for extracting the data used dates in the VB format rather than the database format so it was passing all 30M records back. A couple of changes and it ran in less than 5 minutes. I stayed there 4 years and rewrote a number of progs written by the same programmer plus a lot more from scratch, of course.
-
I think Spreadsheet Gear (also not free) may have a WPF control, they has a Silverlight control and it was reasonably useful for a simplistic solution we needed it for.
Never underestimate the power of human stupidity RAH
I can't use a commercial product in an article.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013 -
Well, I looked around for an adequate excel-like wpf spreadsheet control, and found a product called "ReoGrid". I'll give it a shot to adapt my code to it for an article. Maybe it does formulas better...
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013 -
Agree... my wife is very smart (Dr. med.) but coming to gadgets and computers... it hurts to see her using her laptop :rolleyes: :rolleyes: But hey... I am still very lucky, I don't get "My computer is not working" more than 1 or 2 times per year
M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.
You are lucky. My wife managed to infect her PC twice in a month by clicking literally anything in Facebook. That's when I took away the admin rights from her.
"There are three kinds of lies: lies, damned lies and statistics." - Benjamin Disraeli
-
Amen. I fleshed out over-the-top detection algorithms with 99.6% accuracy (wrt the 64% of previous one) and managed to squeeze its maximum 13 ms completion time in 4.5 ms. No one batted an eye. I made a bunch of 5-8 lines utility functions and "Woah! Amazing!".
DURA LEX, SED LEX GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver When I was six, there were no ones and zeroes - only zeroes. And not all of them worked. -- Ravi Bhavnani
Beauty is in the eye of the beholder.
"There are three kinds of lies: lies, damned lies and statistics." - Benjamin Disraeli
-
I thought your arsenal was your superpower. Arrogance is just part of your charm ;P :-D :laugh:
M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.
Whena you can single-handedly face a fairly sized battallion it's hard not to get a bit arrogant :D ;P
DURA LEX, SED LEX GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver When I was six, there were no ones and zeroes - only zeroes. And not all of them worked. -- Ravi Bhavnani
-
Well, I just checked out "ReoGrid", and in a nutshell, it's crap. It was easy enough to get a spreadsheet control in a window, but after loading a file, the displayed data is, well, not displayed. A quick check with the debugger shows that the control is actually loaded with the intended file, and shows the correct number of columns and rows, but the display shows nothing, even if I highlight a range of cells. The search for a free spreadsheet control continues.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013 -
Well, I just checked out "ReoGrid", and in a nutshell, it's crap. It was easy enough to get a spreadsheet control in a window, but after loading a file, the displayed data is, well, not displayed. A quick check with the debugger shows that the control is actually loaded with the intended file, and shows the correct number of columns and rows, but the display shows nothing, even if I highlight a range of cells. The search for a free spreadsheet control continues.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013 -
SyncFusion has a free version of their stuff that doesn't appear to be time limited. I'll check that out.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013 -
Yeah - I blasted him about my problem already because that's the only way I could find to contact him.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013 -
I wrote a wizard app for one of our co-workers that merges two Excel spreadsheets by matching selected columns based on one or more matching criteria (this column value == that column value), and combining the selected columns into a single file. I essentially reduced a 2-5 day process (depending on the size of the two datasets) to no more than an hour. The reason it takes an hour is because the half-assed Telerik spreadsheet control/document code doesn't understand formulas very well, and also doesn't support Date column types, so the user has to manually modify the merged data to suit their ultimate needs. I would write an article, but the code relies on the Telerik WPF library, which is not free.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013Quote:
They Think I'm a Genius
Yeah I know this kind of feeling from my coworkers. It is great feeling. I am doing this kind of things, but I stick to VBA and all the tools are in an .xla file for the company.
Patrice “Everything should be made as simple as possible, but no simpler.” Albert Einstein
-
People that don't live in front of a computer aren't primitive. They simply have different interests and therefore know different things. Thinking you're better than someone for knowing more than someone in *your* field isn't advanced - it's arrogant.
Jeremy Falcon
In what category do I place people who miss literary allusions?
-
In what category do I place people who miss literary allusions?
In what category do I place people that use obscure euphemisms when attempting to debase the inherent coherency of others in regards to cognitive acuity simply because they complement another's accomplishments?
Jeremy Falcon
-
In what category do I place people that use obscure euphemisms when attempting to debase the inherent coherency of others in regards to cognitive acuity simply because they complement another's accomplishments?
Jeremy Falcon
It's also possible that your psychic powers are not quite as good as you imagined, and that you impugned me with malicious motives that were simply never present. I was merely making an on-topic literary allusion, but you went all white knight trying to defend people who were never attacked in the first place to make you feel better about yourself at my expense. I also object to your claim that Clarke's Three Laws are obscure: https://en.wikipedia.org/wiki/Clarke's\_three\_laws
-
It's also possible that your psychic powers are not quite as good as you imagined, and that you impugned me with malicious motives that were simply never present. I was merely making an on-topic literary allusion, but you went all white knight trying to defend people who were never attacked in the first place to make you feel better about yourself at my expense. I also object to your claim that Clarke's Three Laws are obscure: https://en.wikipedia.org/wiki/Clarke's\_three\_laws
I'm not interested in knowing you anymore. Toodles!
Jeremy Falcon
-
I'm not interested in knowing you anymore. Toodles!
Jeremy Falcon
Thank God for that!