| Author |
Topic |
|
kimberlieh1
Starting Member
5 Posts |
 Posted - 2008-04-30 : 02:04:00
|
| I have four columns in my worksheet that I need help resolving. Is it possible to for excel to accomplish the following:first Column, "I" (in x in = SQ FT)In cell I:206 I have the equation exactly as; 030'' x 048'' Can excel calculate and put the answer 10 in J:206? Second Column, "M" (mm x mm = M2)In cell M:205 I have the equation exactly as; 0406 x 0889 Can excel calculate and put the answer .36 in J:206?Third Column, "Q" (in x in x Ft = FBM)In cell Q:18 I have the equation exactly as; 06'' x 08'' x 16' Can excel calculate and put the answer 5.3 in R:18? Fourth Column, "U" (mm x mm x m =M3)In cell U:28 I have the equation exactly as; 191 x 191 x 4.9 Can excel calculate and put the answer .04 in V:28? Or, is de-concatenate necessary first to arrive at the calculations? Thank you in advance for your help.Kimberlie |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-04-30 : 03:11:31
|
| Excel can do this, but you have asked this question in a T-SQL forum, do you want a SQl query or do you want to do this in Excel? |
 |
|
|
kimberlieh1
Starting Member
5 Posts |
Posted - 2008-04-30 : 11:05:49
|
| Rick,Thank you for your response. For several years I've been learning Excel "hands on", creating spreadsheets to meet the needs of my growing company, keeping work organized and efficient. Recently, with my projects, including the question I posted, exceeding my knowledge, I enrolled in an Excel programming class at the college and am beginning to learn about micros. I am not familiar with the terminology "SQL" or what it can do for me so I checked out Wikipedia and my class manual. Is SQL the same as “structured programming” covered in my manual recommending it is "easier to read, understand, and modify"? If they are one in the same, would SQL be the most efficient programming, in this instance, getting the results into the adjoining cells? That said, my data is currently in an Excel spreadsheet and the spreadsheet is part of a collection of sheets in a workbook that I hope to evolve, step by step, into a working program. The cells in these columns are currently “lookup” for cells in other sheets in the workbook. What would you recommend?Kimberlie |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-04-30 : 12:16:08
|
| so how does your problem fall under Transact-SQL forum?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-04-30 : 12:29:28
|
| I would recommend that you learn how to design databases, scrap your spreadsheets, and avoid the "Excel Hell" you are heading into.e4 d5 xd5 Nf6 |
|
|
|
kimberlieh1
Starting Member
5 Posts |
Posted - 2008-04-30 : 13:13:32
|
| Blindman,Because I am familiar with Excel, it seems the logical place to start. I know nothing about databases yet so hopefully what I learn from my class writing macros will get me by in my business endeavors as I go through the learning process of programming!Kimberlie |
|
|
|
kimberlieh1
Starting Member
5 Posts |
Posted - 2008-04-30 : 13:25:51
|
| spirit1,I think "Transact-SQL forum" is related to data bases? Even though my spreadsheet is not in a database, SQL sounds pretty interesting and I didn't know if it could be incorporated into my project. However, because I am unfamiliar with SQL, to avoid confusion, it makes better sense to stick with Excel for now, especially since Excel can solve the equation. Can a macro solve the equations in my spreadsheet?KimberlieKimberlie |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-30 : 13:30:56
|
| You should post your question in an Excel forum then. This site is for Microsoft SQL Server. Check if there is an Excel forum over at msdn.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
kimberlieh1
Starting Member
5 Posts |
Posted - 2008-04-30 : 13:59:47
|
| Will do, Thank you.Kimberlie |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-04-30 : 15:21:59
|
quote:
Originally posted by kimberlieh1
Because I am familiar with Excel, it seems the logical place to start.
Unfortunately, that is where it is likely to end as well.But if you insist on cobbling together applications out of spreadsheets, here is an Excel forum: http://www.dbforums.com/forumdisplay.php?f=243e4 d5 xd5 Nf6 |
|
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-04-30 : 16:01:06
|
| My partner makes a very good living writing applications in Excel. As a matter of fact she makes considerably more money than I do. Not only that but she's one of the smartest people I've ever met and one of the best programmers.Excel can certainly be a nightmare but in the right hands it can be quite elegant. The same can be said of SQL server solutions as well as many other platforms/languages. Consider the gongAn infinite universe is the ultimate cartesian product. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-04-30 : 16:20:43
|
| I make a very good living fixing the applications your partner builds. I'm sure I owe her a drink, should I ever meet her.e4 d5 xd5 Nf6 |
|
|
|
|
de-concatenation