Wolves Cartographer & Trading Services

[Gheritarish le Loki]

What part of the document is open for everyone dont you understand?

I'm understanding clearly the document, it's the title of the thread that i don't understand : "Services"

So it's open to eveyone to provide his services?

[Fluffy_Muffin]

Yes

[dodnet]

Lol... I should make a new thread "Free money services" 

[Xant]

Lol... I should make a new thread "Free money services" 

LOL

[Espu]

But.. All the locations are in client side code, why does this need to be hand-crafted?

(Feel free to proceed of course, just seems like a lot of unnecessary work)

[Elmokki]

It's possible to download list of fief positions and coordinates from crpg directly and then use simple trigonometrics to calculate distance in pixels. I have no clue how many meters a pixel is, but that's probably somewhere too.

Edit: Espu beat me by a minute by the looks of it.

[Bjarky]

But.. All the locations are in client side code, why does this need to be hand-crafted?

(Feel free to proceed of course, just seems like a lot of unnecessary work)

interesting, i guess this would be a better choice then.
are product prices also in this code?

[kinngrimm]

thanks Espu for pointing out that this data is partly already there, i included it into the spreadsheat.

Now thanks to Vovkas example i should be able to complete this without anyone collecting this data by hand through eyecandy.

For what you will use this then is upto you, i myself will post soon another spreadsheet where you then will be able
to get calculations on sell prices, best selling fief of a faction, best production place of a faction and
list of villages with max trade bonus depending on defined origin. This then all hopefully pretty dynamic, we will see.

[Vovka]

Works fine for me
https://docs.google.com/spreadsheet/ccc?key=0ArQFr5D9x-NpdGtqekVjWG4zaF9VaE1Qc1dPUVhMbHc
but be cool see it with Eyecandy 

[Bjarky]

Works fine for me
https://docs.google.com/spreadsheet/ccc?key=0ArQFr5D9x-NpdGtqekVjWG4zaF9VaE1Qc1dPUVhMbHc
but be cool see it with Eyecandy 

nice 

[dynamike]

Works fine for me
https://docs.google.com/spreadsheet/ccc?key=0ArQFr5D9x-NpdGtqekVjWG4zaF9VaE1Qc1dPUVhMbHc
but be cool see it with Eyecandy 

This is great, good job Vovka! 

Now if we could only find a way to dynamically publish goods prices of the fiefs in the spreadsheet...

[kinngrimm]

Vovka dunno i am running into problems with that match funtion, i do it with same syntax you use but it gives me back the overall marked cells out of the range  not the specific id which should match to the fiefs name ... any tip?

EDIT: i tried with Fiefs!A2:B181
also with a defined managed range
over only one column and over several columns
i always get back 180, independently what village i give as matching criteria

[Vovka]

can u send me a link to ur doc in pm 

[kinngrimm]

same link as in the first post, but it seems i get it to work now thanks anyways


you didn't define the Z axes, "+(E12-F12)^2"
this is for 3d hight and don't really need it atm?

[Vovka]

yep it for strat in full 3D