» List all forums
» » Forum: Tips & Tricks, Questions & Answers
» » » Thread: Community Shopkeeping Spreadsheets Preview and Feature Requests
» » » » Post: Re: Community Shopkeeping Spreadsheets Preview and Feature Requests
Print at Nov 21, 2019 11:42:53 PM
|Posted by Zenithar at Sep 19, 2018 6:39:49 PM|
Re: Community Shopkeeping Spreadsheets Preview and Feature Requests
Estimated cost of use includes sales tax for each item, but the override box doesn't - IE, if someone manually overrides the estimated costs with a specific one, it'll add the known sales tax and put it to the third column. Next draft will make the distinction clearer, tyty.
Right now, it's estimating the cost of use by taking the Highest offer on the specific island and the amount of quantity ordered within 10% of the highest buy offer to estimate roughly how much has to clear before a lower priced order would. If there's just one standout much higher priced then the rest of the island's orders, it ends up reduced - if pretty much all of the island is standardized on a price, that's what the estimate is.
I'll need to investigate more to see whether the estimated cost/island should incorporate the broader sales tax item valuation information or not.
I myself am aware of the economics interplay between islands but am trying to condense that down to a simple-to-understand estimate number for people who aren't.
The critique is helpful, it means I should think about this section some more.
(Part of the utility of the spreadsheet is meant to be able to quickly look at cost changes if one opens on different islands, so I have to incorporate local pricing somehow.)
@3: Thanks, that's a helpful resource of sorts. It's not going to be as easy to work with as querying SQL myself but after futzing about a lot with Google Sheets to import Yoweb (Those Yoweb TSVs would have retroactively saved me a ton of time but also a good chunk of learning) I think I'll be able to selectively import from the TSVs and do all my querying inside Google Sheets, strange as it may be. This is a really helpful piece of info, thanks kindly. The big key was that I needed something hosted somewhere to pull from.
I will probably incorporate that entire oceanwide market price sheet into this system as an additional referance point as well.
@4:It's worst for distilling. There's a drastic labor shortage on both low end and high end. I'm trying to mitigate the issue as a player somewhat with my mentioned-elsewhere 'Booched' alt program but that's just going to help a little bit.
Edit: Edited because I split the quotes up and it seemed to break the formatting, and edited 3 after looking over the info.
Powered by mvnForum
mvnForum copyright © 2002-2006 by MyVietnam.net