Do we have spreadsheet experts here?

[MrX]

I guess not. All the cells in column D say #NAME? which I assume is not the intention.

No, it is not!

Thanks, DJ, for the workaround.

 

[Mudcat]

So I'm curious, ISODD() is not in Excel 2003? Because I looked it up and it's supposed to be.

I don't even understand the question well enough to have an intelligent response. As you may or may not have heard, I am one big technical problem.

 

[MrX]

I don't even understand the question well enough to have an intelligent response. As you may or may not have heard, I am one big technical problem.

If you type =ISODD(2) in a cell, what do you get?

 

[MrX]

Ah, here's the answer, I think. You need to install the Analysis ToolPak Add-In to get ISODD() and other goodies.

http://tipsforspreadsheets.com/microsoft_excel_2003_function_0003.html

 

[Mudcat]

I still do all my stuff manually. I do it in Excel but imput data manually. I've heard I can import data from outside sources/websites and have it automatically uploaded into Excel but I don't have a clue.

I kind of would like to know how but at the same time I still kind of like old schooling it. If it became too automated I would feel like it wasn't really my own work.

I don't find any romance in manual data entry. Not with the HUGE amount that I need to do. Last year from right around now through the end of November I spent every spare moment manually transcribing data. It was vast and mind-numbing and there is a lot of chance for errors.

I am embarking on a parallel project now and expect to be done the whole thing in a couple weeks - maybe even faster if I keep having breakthroughs with the tech people I'm working with. Compare that to the end of November. That is a lot of time freed up for creative analysis and actual day-to-day money making.

I'm more than just a little bit happy.

 

[Mudcat]

Ah, here's the answer, I think. You need to install the Analysis ToolPak Add-In to get ISODD() and other goodies.

http://tipsforspreadsheets.com/microsoft_excel_2003_function_0003.html

Oooh. I'll try it.

 

[MrX]

I am embarking on a parallel project now and expect to be done the whole thing in a couple weeks - maybe even faster if I keep having breakthroughs with the tech people I'm working with. Compare that to the end of November. That is a lot of time freed up for creative analysis and actual day-to-day money making.

I'm more than just a little bit happy.

Can you imagine how happy you're going to be when you teach yourself how to write data scrapers?

 

[djiddish98]

Wal - look into excel's web import functionality. It's very rudimentary and your data needs to be in a basic table layout (which is disappearing quickly on the web these days with more sites getting all fancy pants), but it's a nice place to start .

 

[Mudcat]

Ah, here's the answer, I think. You need to install the Analysis ToolPak Add-In to get ISODD() and other goodies.

http://tipsforspreadsheets.com/microsoft_excel_2003_function_0003.html

I didn't quite make it. It lost me when it said I need to enter "an alternate path to a folder containing the installation package for PRO11.MSI"

I googled it and found a bunch of people who had run into the same roadblock but no solution.

 

[MrX]

I didn't quite make it. It lost me when it said I need to enter "an alternate path to a folder containing the installation package for PRO11.MSI"

I googled it and found a bunch of people who had run into the same roadblock but no solution.

You know what? You are one big technical problem.

 

[Mudcat]

How dare you call me that?

No but seriously man, I appreciate the assistance.

 

[roguejuror]

You know what? You are one big technical problem.