help required - excel or access.....

Here is enough space for all players to ask questions about the game.

Moderator: moderators

Post Reply
Guest

help required - excel or access.....

Post by Guest »

hi all

i'd like to make a database / spreadsheet with all the kapiland products in it.
however, my plan is to input the data in such a way that i can retrieve what i need to produce the various products.
e.g.
say i need 1500 sausages .....
i'd like to make it so that it would tell me that i need x seeds and x water to make the corn, x corn and x water to feed the pigs, x pigs and x power to make the pork, x pork and x power to make the sausages....

i am reasonably skilled with excel, but just can't see my way round this one...
may have something to do with the 1/2 bottle of wine i have had :lol:

any inspiration greatly appreciated :)

ta
Guest

Post by Guest »

Wow, I can create one. I already have a spreadsheet that is completed and contains all the products so you can easily hide columns for the products you aren't involved in, then unhide them if you are getting involved later, etc. The spreadsheet only calculates by building (not fully) and doesn't break down every material required.

I can modify my existing spreadsheet to break down all the materials down to power but by material my pose a threat. You are willing you reinsert all the materials you need, then my existing spreadsheet will work but otherwise I will have to change a few things (or 100+ cells) but I believe I can make it work. If you want my current spreadsheet, just send me an IGM.
Guest

Post by Guest »

in my excell sheet i do look these things up with :


"VERT.ZOEKEN" (yes its dutch :p)


i dont really know what the correct function is in english but i would translate it as : vertical search




i hope i could help you :D
Post Reply