stephen_rockefeller Posted October 23, 2013 Share Posted October 23, 2013 oh man, now I know why my sets don't sell, seem overpriced based on what returned by the calculator nice tool! lol how do you not know what market prices are??? Quote Link to comment Share on other sites More sharing options...
matt1147 Posted October 23, 2013 Share Posted October 23, 2013 Well if you can give me an example of how this would work the best, then I can look into adding something like that. What is the proper way (equation) split up the sets? For sets purchased in lots, I would do it the way Eightbrick broke it out above if you were interested in adding that but for what it does currently, the calculator is great! Quote Link to comment Share on other sites More sharing options...
Grolim Posted October 23, 2013 Share Posted October 23, 2013 You could do it by MSRP or pieces I guess. Or by current value. ... You could also do that by MSRP or Used Value or Piece Count. I think this is what they were suggesting. This method would be perfect. It's how I enter values in my own inventory system. I would go with current market value as MSRP has the disadvantage of being based on the sets year of release so can look out of proportion if you have a mix or old and newer sets. Quote Link to comment Share on other sites More sharing options...
Jeff Mack Posted October 23, 2013 Author Share Posted October 23, 2013 You could do it by MSRP or pieces I guess. Or by current value. Then just add them together, percentile them and apply that percent to the value paid. For Example for current value, let's say you bought three new in box Batman (1) sets, 7884 Batman's Buggy, 7885 Robin's Scuba Jet, and 7888 The Tumbler. You paid 200 bucks total (what a steal!): Price You Paid: $200 Value of 7884: $117.73 (25.915%) Value of 7885: $138.67 (30.525%) Value of 7888: $197.89 (43.560%) Subtotal: 454.29 Apply to $200 Price Paid [(200)PercentValue]: 7884: $51.83 7885: $61.05 7888: $87.12 You could also do that by MSRP or Used Value or Piece Count. I think this is what they were suggesting. Ok, take a look at the feature again. You should see a spot to enter in your price paid and then you should see what each set would have cost you. Let me know if this is what you were all looking for. Quote Link to comment Share on other sites More sharing options...
DoNotInsertIntoMouth Posted October 23, 2013 Share Posted October 23, 2013 Well if you can give me an example of how this would work the best, then I can look into adding something like that. What is the proper way (equation) split up the sets? You have a ratio for each set. So Set x divided by total lot value = <ratio> Then you multiply the ratio by the total they paid. Example. Lot worth $100 in your calculator. Set X is worth 25$. Ratio = 25/100 = .25 He paid 50$. So Set X = 50$ * .25 = $12.50 Alternate way than just taking the value and dividing by total number of sets. If you do that, you might have a death star for $100 and a battlepack for $100. Lol Edit: Somehow I didn't see the next page of answers in the conversation. Ha. Quote Link to comment Share on other sites More sharing options...
Jeff Mack Posted October 24, 2013 Author Share Posted October 24, 2013 You have a ratio for each set. So Set x divided by total lot value = <ratio> Then you multiply the ratio by the total they paid. Example. Lot worth $100 in your calculator. Set X is worth 25$. Ratio = 25/100 = .25 He paid 50$. So Set X = 50$ * .25 = $12.50 Alternate way than just taking the value and dividing by total number of sets. If you do that, you might have a death star for $100 and a battlepack for $100. Lol Edit: Somehow I didn't see the next page of answers in the conversation. Ha. Ok, but my point is I added the ability to see the breakdown in the tool. I am asking if this is right and what people were looking for. Quote Link to comment Share on other sites More sharing options...
DoNotInsertIntoMouth Posted October 24, 2013 Share Posted October 24, 2013 Ok, but my point is I added the ability to see the breakdown in the tool. I am asking if this is right and what people were looking for. Yeah I was behind. Yes it is perfect. I put in a lot I got the other day - 5887, 5886, 5885, 5883, 5882 for $180.00. It spit out $265 and then gave me price for my sets. I love it. This is gonna save me insane amounts of time. I love giant Ebay lots. Only other part (and this is eventually, probably with the eventual brickfolio update) would be a way to import that straight into your brickfolio so you don't have to edit it by hand? Quote Link to comment Share on other sites More sharing options...
Guest eightbrick Posted October 24, 2013 Share Posted October 24, 2013 Works like a charm. Excellent as always Jeff, great job! Thanks! Quote Link to comment Share on other sites More sharing options...
matt1147 Posted October 24, 2013 Share Posted October 24, 2013 Nice job Jeff - that really took the tool to the next level! Quote Link to comment Share on other sites More sharing options...
seapotato Posted October 24, 2013 Share Posted October 24, 2013 Just tried this out - very cool!! I definitely will be using it for any future large lot purchases! Quote Link to comment Share on other sites More sharing options...
Fcbarcelona101 Posted October 24, 2013 Share Posted October 24, 2013 This is probably the greatest tool ever released lol Quote Link to comment Share on other sites More sharing options...
Jeff Mack Posted October 24, 2013 Author Share Posted October 24, 2013 Only other part (and this is eventually, probably with the eventual brickfolio update) would be a way to import that straight into your brickfolio so you don't have to edit it by hand? The tool will now tell you your profit or loss depending on what you paid for the lot/bundle. If you enter in a value of what you paid, you will now see a button that will insert the sets into your brickfolio It will enter in the price that was calculated by the system based on what you entered for cost of the lot. Quote Link to comment Share on other sites More sharing options...
DoNotInsertIntoMouth Posted October 24, 2013 Share Posted October 24, 2013 The tool will now tell you your profit or loss depending on what you paid for the lot/bundle. If you enter in a value of what you paid, you will now see a button that will insert the sets into your brickfolio It will enter in the price that was calculated by the system based on what you entered for cost of the lot. Now it is a masterpiece. Love it. Quote Link to comment Share on other sites More sharing options...
MartinP Posted October 24, 2013 Share Posted October 24, 2013 Now it is a masterpiece. Love it. Same here. Love it. I have been using a lot. Quote Link to comment Share on other sites More sharing options...
LEGO HULK Posted October 25, 2013 Share Posted October 25, 2013 My god. This thing is awesome. I love it. Its one of the coolest tools ever, seriously. I love how it removes the text. I tried some doozy listings and it handled it very well. I like entering numbers of what I paid to get an idea on how much profit I could make if the seller accepts the offer I may make. Great job! Quote Link to comment Share on other sites More sharing options...
willy431 Posted October 25, 2013 Share Posted October 25, 2013 Love it! Using it daily! Thanks! Quote Link to comment Share on other sites More sharing options...
Guest eightbrick Posted October 25, 2013 Share Posted October 25, 2013 Same here. Love it. I have been using a lot. Nice pun whether it was intended or not What, no one else caught the "lot"? Get it, it's a lot calculator? No? Just me? Okay.... Quote Link to comment Share on other sites More sharing options...
comicblast Posted October 25, 2013 Share Posted October 25, 2013 Nice pun whether it was intended or not What, no one else caught the "lot"? Get it, it's a lot calculator? No? Just me? Okay.... How about this... The new feature does a lot of calculations in a short amount of time. It saves a lot of time. Quote Link to comment Share on other sites More sharing options...
TheOrcKing Posted October 25, 2013 Share Posted October 25, 2013 Same here. Love it. I have been using a lot. Nice pun whether it was intended or not What, no one else caught the "lot"? Get it, it's a lot calculator? No? Just me? Okay.... How about this... The new feature does a lot of calculations in a short amount of time. It saves a lot of time.Umm....naw. The original was better; less forced and more of an unintentional mistake. I barely give this a 2 out of 5. :negative: Quote Link to comment Share on other sites More sharing options...
Guest eightbrick Posted October 25, 2013 Share Posted October 25, 2013 Umm....naw. The original was better; less forced and more of an unintentional mistake. I barely give this a 2 out of 5. Am I the only one who scanned this sentence like 50 times for the word lot? Lol I can't tell if you are joking or not. Quote Link to comment Share on other sites More sharing options...
TheOrcKing Posted October 25, 2013 Share Posted October 25, 2013 Am I the only one who scanned this sentence like 50 times for the word lot? Lol I can't tell if you are joking or not.I was poking fun at comicblast's attempt using the word "lot" in his post a lot as I lay across my cot building the Lego I bought which I had long sought since prior I had nought. Yes, that whole rhyming bit came straight out of nowhere. :) Quote Link to comment Share on other sites More sharing options...
CNH1974 Posted October 26, 2013 Share Posted October 26, 2013 Ok, I am behind the times as usual. So I will belatedly say this is great, no more typing sets into spreadsheets. Now, if we can only have a tool that forces sellers to put set names onto their descriptions. Quote Link to comment Share on other sites More sharing options...
graffiti600rr Posted November 8, 2013 Share Posted November 8, 2013 Awesome tool. Quote Link to comment Share on other sites More sharing options...
CNH1974 Posted November 20, 2013 Share Posted November 20, 2013 Hi Jeff, I have just used this for the first time in anger. Superb worked second time (the first not working due to user error ) But when I change it into GBP it is giving me the USD value in GBP terms not the actual GBP price from the database. For example 7633 http://www.brickpicker.com/bpms/set.cfm?set=7633-1 USD $112.13 = Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.