in excel, what is the best way to deal with "3D Data" - i.e., say my datastructure was (year, city, traffic)
113868
Explore pivot tables.
151606
if all the lines are equal in every way (duplicate) then you can put a measurment (dimension) from the existing line to a datum or border whichever you choose and then put a callout like 3@12.00' (3 lines at 12.00 feet)in the dimensionwith a arrow pointing at the line.\n\njeff
544272
File.. Get External Data.. Link Tables .. browse to the xls file    would set up a permanent link to the excel data and give the spreadsheet a kind of table name. Then it can be queried. You want to use several columns over time and you can use an 'Append query' to append data to a table; but experiment with a crosstab query. In that way, your Access table would always have 2 fields plus maybe a ColumnNumber field where you could have a default value of 1 the first week, 2 the next week, etc.. A crosstab query would present that data as several several columns (one for each ColumnNumber value). When your Access skills increase, you might be very glad that you used a small number of fields because it makes the querying of the data simpler to maintain, in my opinion.\nAs for VLOOKUP, you can research "query table joins" and see how a query in design view lets you choose the field which 2 tables have in common. One table is really the excel spreadsheet presented as if it is a table; the other table is the real access table.
186438
Check http://www-class.unl.edu/psycrs/handcomp/hc1t.PDF\n\n\nAlso, Follow this procedure:\nEnter the values of X into the designated cells, beginning in the top-most cell. After each entry, depressing the 'tab' key will take you down to the next cell in the column. After completion and verification of data entry, click the button labeled «Calculate». If you wish to perform another analysis with a different set of data: click the «Reset» button if the value of N for the new set of data is undefined or smaller; click the «Reload» button if the value of N is larger than undefined.\n\nImporting data from a spreadsheet. Within the spreadsheet application, select and copy the column of data. Then return to this page, click the cursor into the data-entry field and perform the 'Paste' operation. It is important to make sure that the final line in the data-entry field entry is not followed by a carriage return. (An extra carriage return at the end of the list will be interpreted as an extra data entry whose value is zero. Importing data via the copy and paste procedure will almost always produce an extra carriage return at the end of a column.) After the bivariate list has been pasted into the data-entry field, click the cursor immediately to the right of the final entry in the list, then press the down-arrow key. If an extra line is present, the cursor will move downward. Extra lines can be removed by pressing the down arrow key until the cursor no longer moves, and then pressing the 'Backspace' key (on a Mac platform, 'delete') until the cursor stands immediately to the right of the final entry.\n(see http://faculty.vassar.edu/lowry/t_single.html)
967667
http://en.wikipedia.org/wiki/Data_model
985699
There are two ways of doing quantitative estimates to problems like "how many bricks in the Great Wall" or "how many tennis balls in the United States?".  In this case, let's use cars in a particular city. \n\n1. Top-down.  Take the population of the city.  Countries and/or states often have car ownership records, whoever is the registration authority.  In the US, you would use the State DMV, but the US Dept. of Transportation also has that.  You would then apply a ratio to the population of the city.  You would then adjust the resulting number by demographics.  Compare the cities demographics compared to the "average city" in the city/state.  For example, cities tend to have younger, richer population.  There may be other factors like the antiquated road infrastructure (e.g. Rome), extremely high cost of living/car ownership (e.g. New York City) or car taxes (e.g. Singapore).  \n\n2. Bottoms-up.  Sometimes you can collect the data manually.  Usually, this type of estimate works only were data integrity is good and available.  Also, you usually have to do a reality check against a top-down guesstimate anyways.
895771
Place data in a specific place on the hard disc or in the work memory temporally\n\nTh
775038
Nope, sorry.  What you're describing is a query.  Only Access can do that.  It's a pretty simple one, and exporting back and forth between Access and Excel is pretty easy.  If you want some help in how to do it, send me a message.
833762
Excel is a spread sheet and can be used to show relations of between data. Usually what you but in to excel is raw data and excel acts as a sophisticated calculate. Excel can analyze data, and display graphs to show patterns.\n\nAccess is a database. It is place to store a lot of data - for the record. Calculations are not made in access. But you can make a lot of fun intersections between data.
96164
I suggest you use a DTS package, making a DTS (Data Transfermation Package), a function of the SQL Server, will\ngreatly simplify the task of getting data from Excel to SQL server. they can be saved and setup to run on a schedule or just used once. Great feature :)
252390
I'm going to e-mail you an Excel spreadsheet that will do it.   Don't change anything except the dates and the yellow cells and everything else will automatically calculate.
957828
Just open it with Excel.  It will automatically populate the columns.\n-MM
18740
There is an application that integrates with Excel called Crystal Xcelsius.  Its really cool.  I'm not sure if this is quite what you are looking for, but the graphs that come out of it are excellent and they are adjustable.  They have a couple of examples on their website.\n\nhttp://www.xcelsius.com/Products/XL_products.html
380849
Bascally your data to day database (operational) is in 3NF\nyour data warehouse dose not nned to be in 3nf as you want speed and it uses a differnt query engine, whihc is tuned to the arehouse task.\n\nyou want all the avalible data to speed trhough, based upon your queries dimentions.\n\none thing i was taught was when u do data warehouseing throw out everything you learnt aboubt a normal releation database, forget normaliastion etc
1187479
The first item listed at the search\n\nhttp://www.google.com/search?q=example+data+flow+design\n\nwas\n\nhttp://www.cems.uwe.ac.uk/~tdrewry/dfds.htm\n\nseemed like a decent starting point.
1005550
Use excel, somewhat easy and really organized
726290
You should be able to click on the chart, and this will show you what your data series by outlining the cells.  You then should be able to click on the lower right-hand corner of the cells and extend them to the appropriate place.  Another trick is to insert the added rows/columns before the last row/column so that the data series automatically updates.