Database of prices:

[Creighton]

Okay, working on whiteboarding the database structure.
How about:

Barnfind, in the wild
Orginal Unmolested
Original minor attempt at restore
Restored Badly
Restored Well

Here it starts to get tricky, will need input on what folks want for the editing and how the rating/sorting index works.
Up for sugesstions, the way individual machines would be listed. My stab at it. Rating for this is 1-5.

Vendo 81 D:
Private sale: $1800
eBay Listing:
CL Listing:
Other:
Orginal Condition Rated: 4
Missing Parts: No
Cooling: Yes
Serial Number: xxxaaxx
Comments: Clean orginal with Spirit boy decal attached

Next and most important issues are if SMC can support an user input dynamic database and if pics can be linked.
Creighton

[jnapp18]

I recommend making using google docs, I know you can collaborate at on documents and they will all be stored online. You can change whether they are editable, readable, or viewable by others.

[Jim]

That may be a good alternative...
I'll try and research Google Docs...
As time permits...

[globalcompressors]

Creighton,

hahahaha..... sure, but don't ask some of the guys here, though. All of them will say,
anything over $400 is TOO MUCH! 

If you want "real" pricing, I'm afraid you'll need to to the research yourself, because
most of these guys, on this board, have no clue on what things cost or what they're worth!

Good luck... oh, here's my contribution ... Vendo 81D.... $400, Cavalier 72...$100,
VMC 81 RC Cola, $125, Westinghouse WD12... $20. Oh, and if it's over 30 miles away, factor
in the "it's too far" price, of an additional $1500, so you can whine about it and
say, "that's too much"!

Send me a signed copy of your book, when you're finished!!!! 

BLAHAHAHAHAHA!!!

[Creighton]

Okay, here is a quick Google Doc alpha.

Submit Form:
<iframe src="https://docs.google.com/spreadsheet/embeddedform?formkey=dEhPWjZOcm5MaFowbHUydHA4ckZWekE6MA" width="760" height="1245" frameborder="0" marginheight="0" marginwidth="0">Loading...</iframe>

Responses are here:
https://docs.google.com/spreadsheet/gform?key=0AjCiDCpAbO7GdEhPWjZOcm5MaFowbHUydHA4ckZWekE#chart

Don't know if anyone else can see the response. Someone check please.
Bit of a pain to set up and it is not clear what happens next. If someone cares to give it a try please do.
Put "TEST" in comments. This is nowhere near what is required for a final product.

Hey Eric, I know, should just sit on the tracks and wait for the train to show up:-)
Need to give you a holler, gonna be around Mon.?
Creighton

[globalcompressors]

you know me Man... always working, cranking out those "overpriced" compressor units!

I'll be there Bro... give a shout!  

Later

[Creighton]

Well I don't like the way it works. Only seems to graph on select drop down box entries.
Going to try to edit sell price part. Stand by :-)

Can't edit the entry form. Seems I missed a couple of invisible hoops in the Submit part (Save didn't cut it).
Typical of Google. Losing interest in this project fast.
Creighton

[MoonDawg]

         Great job Creighton, the most important information from each sale is retained.
 I can't open the link to see how the data is displayed but I sure wish I could.
The only input I have so far is to index products the same as SMC listings, by Make then Model then Type.
Vendo > 81 > D.........Stoner > 180 > candy.

         Again, thanks for your time on this.

[Creighton]

Glen,
Thanks for the kind words. Will continue marching forth on this with that.
I'll see if I can get screen captures of what the results show.
 
I see there is 100 + views already. Get your suggestions in.
For the peanut gallery of lurkers this will go to the soda jerks section upon completion. Sign up and contribute.

Creighton

[MaineT]

Creighton,

hahahaha..... sure, but don't ask some of the guys here, though. All of them will say,
anything over $400 is TOO MUCH! 

If you want "real" pricing, I'm afraid you'll need to to the research yourself, because
most of these guys, on this board, have no clue on what things cost or what they're worth!

Good luck... oh, here's my contribution ... Vendo 81D.... $400, Cavalier 72...$100,
VMC 81 RC Cola, $125, Westinghouse WD12... $20. Oh, and if it's over 30 miles away, factor
in the "it's too far" price, of an additional $1500, so you can whine about it and
say, "that's too much"!

Send me a signed copy of your book, when you're finished!!!! 

BLAHAHAHAHAHA!!!

Wow, now that is honesty!!! I'm 100% with ya!!!

[MaineT]

        Great job Creighton, the most important information from each sale is retained.
 I can't open the link to see how the data is displayed but I sure wish I could.
The only input I have so far is to index products the same as SMC listings, by Make then Model then Type.
Vendo > 81 > D.........Stoner > 180 > candy.

         Again, thanks for your time on this.

I second that. I just put in a couple of sales from this past summer. The multivend vendo could be a 110 or 81D, so the data will be way skewed.

[MoonDawg]

        Ok, my 2 cents again, I think the amount paid question may be a little private, and does not help our data on sales and nobody will dislcose it anyways.

         The destination country may sound irrelevant to some but I have only sold 3 machines recently on ebay,
a 39, 44 and 81........and high bidders on all of them were foreign, 2 Australia and 1 Germany.

         The media advertising section may help us in more than one way.
         For this price guide to work we can't rely on the sellers to contribute, SMC members will do most of the input but we need to work together.  For example, there is a nice Pepsi 81 on Ebay right now and several members have been watching it. When it sells we certainly want someone to record the sale, but only once.
          So if we select         E-bay > date of sale    will the report help us prevent double entries?

[MoonDawg]

Well I don't like the way it works. Only seems to graph on select drop down box entries.
Going to try to edit sell price part. Stand by :-)

Can't edit the entry form. Seems I missed a couple of invisible hoops in the Submit part (Save didn't cut it).
Typical of Google. Losing interest in this project fast.
Creighton

        Hey I didn't see your edit earlier, don't push it Buddy.
 At least you got the idea got further off the ground than any of us in our previous discussions.

[Creighton]

Thanks all for giving it a try!
Broke down and did the dreaded RTFM thing. See how to get it working now.
Please do not add any more records as they will be lost.

Let everyone know when it is ready for another test.
Creighton 

[Creighton]

01_B should be up here now:
<iframe src="https://docs.google.com/spreadsheet/embeddedform?formkey=dEhPWjZOcm5MaFowbHUydHA4ckZWekE6MA" width="760" height="1181" frameborder="0" marginheight="0" marginwidth="0">Loading...</iframe>

Anyone with time please poke some new data in. Anything will do.
Put the web browser you are using and any issues in the comments section. May not play well with MS IE.

Overall spreadsheet should be available Here: Usable graphs and charts are down the road.
https://docs.google.com/spreadsheet/pub?key=0AjCiDCpAbO7GdEhPWjZOcm5MaFowbHUydHA4ckZWekE&output=html

Thanks,
Creighton
  

[Creighton]

Seems to work here. Anyone having issues let me know.
Creighton

[MoonDawg]

       Works for me

[Jim]

Seems to work here. Anyone having issues let me know.
Creighton

How do you get to review all the data/information...?

[Creighton]

Here is the spreadsheet generated from the form:
https://docs.google.com/spreadsheet/pub?key=0AjCiDCpAbO7GdEhPWjZOcm5MaFowbHUydHA4ckZWekE&output=html

Jim, If you want Admin permission just holler.
Creighton

[Creighton]

Hey All,
Would like to move this project to working but needs improvement on my calender.
A better population of drop the boxes is needed.
Please let me know what else is required or whatever.
Can put in a few more hours and hope it will be done for awhile.
Thanks!
Creighton

[Blind1968]

Well done Creighton.

[tkaz]

Thanks for the work!  Would a 'date bought' and 'date sold' column work?  I'd be happy to list a few of my historical buy's/sell's, but I think that context would help. 

[Creighton]

Thanks and great idea. Adding it now.
Creighton

[Creighton]

Minor issues with your request. Google pretty much sucks.
Creighton

[66GTO]

Working great!  Thanks for doing this.  Once we have a bunch of data input, it will be a great resource.  Watch out though, Dick Dale may pirate the info for his next book edition!  

[BrianS]

This is a really nice tool - shows a lot of promise.  Do you still want entries added?   Glen indicated that some may not want to put in buying prices, but I would be willing to enter mine and would like to see it remain as a field.  I can see where the guys here that buy and sell as a business may not want to enter that data so why not  allow a "null" value to be input.  I would like to contribute any info that I can, but I have only bought machines, never actually sold one.  I think quite a few of us may fall into that catagory.  Just have to get my post count up to Jerk status so I can continue to see it once complete.  Great job so far and thanks for the effort in pulling it together.

[MoonDawg]

Minor issues with your request. Google pretty much sucks.
Creighton

         Dates are not showing up. Should we continue putting them in anyways?

         Great job Creighton!

[Eric]

What if you just buy.. and dont' sell... would you want the found in the wild price...

[MaineT]

What if you just buy.. and dont' sell... would you want the found in the wild price...

Only if your paying full retail, not the steals, deals, beatdowns and "took advantage of this elderly lady and I'm so proud of myself" price. It's not about what it's bought for to a patient collector ready to snap, it's about what they are actually selling for.

[Eric]

What about auctions.. I bought a clean Pepsi 33 for $750.. That's what the market set that day?

[Creighton]

Have thought about the bought it at $$ but not selling it at this time (keeper) scenario. It would need to be another column or two.
It's the same data as what an individual machine has just sold for. So to add this level of detail just adds extra database fields that really matter not.
Trying to get this as painless as possible for entry and display. Won't get used otherwise.

Let me know of any other suggestions.
It is a bit of pain to update or add content so would like to do everything at once.
Thanks!
Creighton

[MaineT]

What about auctions.. I bought a clean Pepsi 33 for $750.. That's what the market set that day?

That being a public sale at auction it would make sence, add the tax and commission and you have a fair market value. Just don't forget to add all of the ones that you don't win that go higher then you are willing to pay so the numbers don't get skewed toward the SMC member price point side.

[SIGNGUY]

That being a public sale at auction it would make sence, add the tax and commission and you have a fair market value. Just don't forget to add all of the ones that you don't win that go higher then you are willing to pay so the numbers don't get skewed toward the SMC member price point side.

I dont think however you can use one auction as "market price" as we all know two bidders can drive up prices crazy high if they really want an item... I'd agree if you go to alot of auctions you could average out a few items but just one would not set market value in my opionion.

remember guys this is not an exact science.. I just think putting info on this database is just a tool for an uniformed person to make there own averages... if they see 10 Vendo 81's that have been purchased on and listed on there and the prices range from 1500-2000 one each sale,, that person "SHOULD" be able to figure out what the average price for that model are, pending all factors involved.

[MoonDawg]

        Yes, this whole tool is to gather an AVERAGE price, that's why it is important for everybody to input any past machines bought and sold.

[MaineT]

I dont think however you can use one auction as "market price" as we all know two bidders can drive up prices crazy high if they really want an item... I'd agree if you go to alot of auctions you could average out a few items but just one would not set market value in my opionion.

remember guys this is not an exact science.. I just think putting info on this database is just a tool for an uniformed person to make there own averages... if they see 10 Vendo 81's that have been purchased on and listed on there and the prices range from 1500-2000 one each sale,, that person "SHOULD" be able to figure out what the average price for that model are, pending all factors involved.

I have to disagree. We are not talking about a rare painting, these are mostly common soda machines that you can find out what you can get for an item if you have to sell it today. Auctions records will prove the fair market value not the retail asking price. If there are 25 auction sales in the past 2 years for a particular machine and 20 get between 1800-2300 you can be pretty confident that you will get between 1800-2300.

Bidding war... Let get realistic, an auction is by definition is a bidding war. Just because they pay more then the tightwad collector doesn't mean they aren't setting the market value. Yes, there are ways to buy things cheaper, but that doesn't discount an auction value if they paid retail prices.

What you have to do is get into statistics and sampling, not just averages which means you toss out the fliers like the $17000 vendo 44 and the $175 vendo 81

[Creighton]

>>What you have to do is get into statistics and sampling.,

So true. That is the double edged sword of a database of this type.
Nobody contributes, nothing to build any kind of pricing info on.
Fixing to set down and clean it up some.

Keep forgetting to mention. If you have database software, OpenOffice is free you can save the output database and sort however you want.

I've tried to bring the web HTML output database directly into Excel and OpenOffice.
Formating is all f*cked up. Any help there would be nice.
Google Docs has an interesting piss poor way of relating content between Form/Output.

Thanks,
Creighton

[vintage-air]

You need to make more space for "Model" on the spreadsheet. My VMC-RC 81 I listed doesnt show up all the way. Its cut off after the "RC".