|
Yes,your ideas were very good and could change the Q&A section's efficiency(i think so),especially i like the freezing question idea.I also proposed a related term in suggestions and bugs to filter a question before answering it.Probably, CP will admit these things one day,
Shuvro
|
|
|
|
|
Couldn't find the Office/Excel page in CP, so I'm posting my question here.
I seem to recall a way to eavluate equations in Excel. I'm currently using Excel 2010, and I can't seem to figure out how to evaluate strings of equations in one cell into another cell.
Example:
A1 = "2+3" (string)
B1 = "=EVALUATE(A1)" (which evaluates to 5)
There used to be an Evaulate function, but it seems to be missing. INDIRECT and VALUE don't seem to work for some reason.
Anyone knows how to do this in Excel 2010?
Thanks!
|
|
|
|
|
|
I did Google it and I did try that. It refuses to do just that in (my version of) Excel 2010. Excel won't even see the macro even though I enabled all macros and disabled all security. I was curious if maybe it was taken out finally.
|
|
|
|
|
Did you put it on a macro page? Or a spreadsheet page?
Not a wise crack... I've made that mistake before.
|
|
|
|
|
Impossible to put in a worksheet page. It would not allow me. Problem solved.
|
|
|
|
|
|
If you can't find a page in future, post it in QA : http://www.codeproject.com/Questions/ask.aspx[^]
That way you don't post programming questions in a forum which clears says "don't post programming questions here"...
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre.
Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
|
|
|
|
|
In all fairness, it wasn't a programming question. Turns out it had a programming answer though.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Anything which starts "Couldn't find the Office/Excel page in CP, so I'm posting my question here." is a question in my book!
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre.
Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
|
|
|
|
|
|
Not every question is a programming question though. Every answer could be a programming answer if you tell them to write a program to get the answer.
|
|
|
|
|
I seems that it does not pay to be successful!
See here[^]
I like the quote:
To determine the fair value of a startup company, multiply the number of engineers by $250,000, add $250,000 for each engineer from IIT, and then subtract $500,000 for each MBA
|
|
|
|
|
On a coffee break so I haven't had time to read it properly, but saw one quote that made me shake my head "think outside the box", the box is there for a very good reason, what's in the box tends to work/cost less money. You only venture out of the box when whats in the box doesn't work! in my view anyway!
|
|
|
|
|
I disagree completely.
Companies that innovate get ahead.
Companies that keep doing the same thing stagnate.
I have worked for a number of companies that have been at the top of their field. Because they are at the top there is nothing to challenge what they are doing so they keep doing what they are doing.
Meanwhile competitors change what they are doing and catch up or overtake.
As soon as you limit your thinking you are limiting what you can achieve.
“I believe that there is an equality to all humanity. We all suck.” Bill Hicks
|
|
|
|
|
Well good point, in hardware design you tend to get the "clever" people who just change things for the sake and two years down the line when you get handed the smoking remains of the project, you look through it and go why on earth didn't they use a standard SPI bus but no, they "thought outside the box" and came up with a method that was so special.... bitter no!
|
|
|
|
|
The thinking is always good, the doing not necessarily.
Recognising when it is best to stop after the thinking is the hard part.
“I believe that there is an equality to all humanity. We all suck.” Bill Hicks
|
|
|
|
|
For every person innovating, there are a dozen people supporting them in a box. Having a box does not mean the end of innovation for the company. It just allows companies to track things better. The companies who refuse to redefine the box are the ones that have a hard time catching up, but everyone is in a box more or less. Some are just spacier than others.
|
|
|
|
|
I've just been reading an article by an English football coach who went into coaching in his teens and is now working abroad.
As you may or may not know, it doesn't really matter, English football is in a right state at the moment, the national team hasn't won anything for well over 50 years, and haven't come close for a great many years, the Under 21a and other junior teams have all failed miserably recently. It is a national disgrace that the papers are all over and the FA (those in charge of the game) keep doing reviews to work out what is going wrong. Everyone says the problem is too many foreigners in the English game. They are wrong.
This English coach got it spot on, in England lots of the coaches and managers get were given top jobs as soon as the finished playing, they did not study to become coaches, consequentially when they retire from playing in their 30s and start coaching they instantly start coaching using ideas and techniques that they themselves were taught 20 odd years ago. There is an obsession with the name and with the playing career so those young English coaches who have been studying all their careers have to leave England to find work.
English football is at least 20 years behind the rest of Europe at the moment because the coaching has stood still whilst everyone else has moved on.
“I believe that there is an equality to all humanity. We all suck.” Bill Hicks
|
|
|
|
|
I agree with that assessment. Maradonna was a great player in his time who didn't know how to coach his team well in the last World Cup. Beware of the Germans!
|
|
|
|
|
ChrisElston wrote: Companies that innovate get ahead. Companies that keep doing the
same thing stagnate.
Nope. Companies that sell get ahead. Companies that don't fold, regardless of how much "innovation" they throw at it.
|
|
|
|
|
As an aficionado of Doctor Who I would say that it pays to think INSIDE the box.
But then, it is a VERY BIG BOX.
(On the inside anyway).
---------------------------------
Obscurum per obscurius.
Ad astra per alas porci.
Quidquid latine dictum sit, altum videtur.
|
|
|
|
|
Off topic, but I got the very first Doctor Who on DVD two questions to a whovian as yourself what happened to his daughter/nice and when did he move from the scrap yard!
|
|
|
|
|
It makes a point which I think gets to what is wrong with education in the UK and what is wrong with what recent governments have tried to do, are looking to do, to improve it.
In the UK education is focused on passing exams, on getting qualified, on learning and regurgitating in small chunks / short time spans.
Most of which is bugger all use after school, the only real benefit is that it is easy to quantify.
Schools do not have time or freedom to teach children useful things like teamwork, problem solving, lateral thinking, confidence, relationships, networking, leadership. And worst of all teachers no longer have the freedom to attempt to inspire children, to engage children.
Stick to the curriculum, get it learnt, get the qualifications, move on.
“I believe that there is an equality to all humanity. We all suck.” Bill Hicks
|
|
|
|
|
Too true a friend of mine is an ICT teacher, they have to learn Word, Excel, Powerpoint(?),a little bit of Access, if I had to that I would not sitting where I am, he was asked to do two weeks of fun stuff before the holidays from what he said "<<face palm="">>out came the Raspberry PI's and I found what the kids had learned <>"
|
|
|
|