"Franco" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > "Dan Lewis" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > On Wednesday 16 August 2006 11:14 am, Franco wrote: > > > Hi, > > > Could someone please steer me in the direction for the following? > > > > > > Let's say I have sales records for lots of transactions > > > (represented by rows in a spreadsheet). Three of the fields are > > > geographic location, sales price, and size. If I want to calculate > > > the median price for just records in a certain geographic area and > > > a certain size, how would I write that function? > > > > > > Thanks! > > > > You should create a Base file (database) that connects to your > > spreadsheet. Then you should be able to do things like this within > > the database. You create a query to separate out all the sales for a > > given geographical location. Then it is a matter of doing the > > calculations on this information. > > > > Dan > > Thank you. I'll check the online documentation to see how this is done. > Does the actual implementation of this approach work pretty well?
Quick Update: I just "registered" the Calc spreadsheet in Base and it worked without a hitch! But for all practical purposes, I am unfamiliar with Base. I'll search the openoffice.org web site for more help, but if you or anyone else happens to know a source off hand for the following items you mentioned in your message, it would be greatly appreciated: "You create a query to separate out all the sales for a given geographical location." "Then it is a matter of doing the calculations on this information." Again, the desired end result is to somehow list the various geographic areas along with their respective median sales prices. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
