The Golden Crusade Shuffler

**hgoutyt** · 11-21-2012

I may just be dumb but im trying this out and for some reason it's telling me nothing is profitable and dosent tell me what the profit of anything is. i inserted the XML from undermine journal and all that and put in variables in the highlighted fields and it only ever tells me cost.

**hgoutyt** · 11-21-2012

it will tell me how much of what i will have in the end but not put values on them

**Xsinthis** · 11-21-2012

Originally Posted by hgoutyt

I may just be dumb but im trying this out and for some reason it's telling me nothing is profitable and dosent tell me what the profit of anything is. i inserted the XML from undermine journal and all that and put in variables in the highlighted fields and it only ever tells me cost.

So it tells you your cost but not the sale value? That means the spreadsheet isn't able to collect the prices needed. If you go to the prices tab is that populated properly or is it full of zeros?

**hgoutyt** · 11-21-2012

its nothing but zeros

**Xsinthis** · 11-22-2012

Originally Posted by hgoutyt

its nothing but zeros

That means it can't find the data, make sure you've put the right data in the right spot

**hgoutyt** · 11-22-2012

I messed with it a bit more working now thanks

**Rayz** · 11-22-2012

I'm on a mac and on your site you said that we should import the CSV file into E1. I did that but I'm not sure the numbers are right. They look very large. I don't really know how it is supposed to look to here's a screenshot.

If you have some time to let me know if that looks right compared to your data that would be great. +rep for all the work you've put into this project.

If the numbers are hard to see then you can zoom in after clicking this link https://i.imgur.com/nf1lY.png

**Xsinthis** · 11-22-2012

Originally Posted by Rayz

I'm on a mac and on your site you said that we should import the CSV file into E1. I did that but I'm not sure the numbers are right. They look very large. I don't really know how it is supposed to look to here's a screenshot.

If you have some time to let me know if that looks right compared to your data that would be great. +rep for all the work you've put into this project.

If the numbers are hard to see then you can zoom in after clicking this link https://i.imgur.com/nf1lY.png

Where did you read that? If it was in a comment that might have been before I added CSV support. No matter what data you're using always put it into A1 of the appropriate tab

Confirm you will be inserting CSV data into existing worksheet at cell A1 (might show up as $A$1)

Also the data measures prices in coppers, so if you're just looking at the data tab that may be why they seem large to you (the spreadsheet converts to gold in the Prices tab)

**Rayz** · 11-22-2012

The Golden Crusade Shuffler » The Golden Crusade

And yes it probably was. I will re-import into A1 and the copper thing makes sense then. I thought it was showing me prices in gold like it does in the prices tab so I was very confused. Thank you for the help.

Edit: Also how often do you personally update your XML file import?

**Xsinthis** · 11-22-2012

Originally Posted by Rayz

The Golden Crusade Shuffler » The Golden Crusade

And yes it probably was. I will re-import into A1 and the copper thing makes sense then. I thought it was showing me prices in gold like it does in the prices tab so I was very confused. Thank you for the help.

Edit: Also how often do you personally update your XML file import?

I'm using the IQY option and have set it to update every time the spreadsheet opens, haven't used it in a while though, I'm just assuming I'm still being profitable haha

**Xsinthis** · 11-30-2012

The Golden Crusade Shuffler has been updated to V0.3.3 to fix a typo preventing the market price being fetched for Enchant Chest - Glorious Stats and some errors with Primal Diamonds on the Google Docs version. This update is highly recommended.

**prayforsunshine** · 12-19-2012

So this is a guide on how to use the Golden Crusade Spreadsheets (Google Docs Method)

**crystal_tech** · 12-19-2012

meh, didn't really teach anything you didn't know if you read the page where you download it at. and its only for the spirits of harmony sheet not all of them.