Hi, nice spreadsheet. to clean the result you could change F1 through F200+ to have a formula like =IF(E3="nie ma","",CONCATENATE(E3, ",")) and then for the result you could use =CONCATENATE(F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12,F13,F14,F15,F16,F17,F18,F19,F20,F21,F22,F23,F24,F25,F26,F27,F28,F29,F30,F31,F32,F33,F34,F35,F36,F37,F38,F39,F40,F41,F42,F43,F44,F45,F46,F47,F48,F49,F50,F51,F52,F53,F54,F55,F56,F57,F58,F59,F60,F61,F62,F63,F64,F65,F66,F67,F68,F69,F70,F71,F72,F73,F74,F75,F76,F77,F78,F79,F80,F81,F82,F83,F84,F85,F86,F87,F88,F89,F90,F91,F92,F93,F94,F95,F96,F97,F98,F99,F100)
I have uploaded a different spreadsheet version. Hopefully this one will work with Excel 2003 although i didn`t have any means to check if it works properly yet.
Published similar file on Google Docs as a workaround: https://docs.google.com/spreadsheet/ccc?key=0AskrZnQrC8N3dDN5eFBiSHhVenFQUDNCNVFfTnEzVnc
I will try to make the file in older Excel to ensure the compatibility with previous Excel versions/Mac (however my skills in Excel are limited to say the least ). BTW i didn`t see earlier that there are already applications posted on Nexus which look like more user friendly than this spreadsheet
Thanks for this -- going to put it on my mobile so I can look at it in-game.
BTW, I can only view the table listing ingredients followed by effect. The one that has effect followed by ingredient only shows one entry. Probably that's an error on my end, because I'm viewing it on a Mac, and the formats don't always translate properly. But, thought I should mention it, just in case.
11 comments
New file has been uploaded. Now you can search for plants via effects as well as search for effects via plants selection.
TBH for me the most useful is the file on the google docs as it allows opening on android
Published similar file on Google Docs as a workaround:
https://docs.google.com/spreadsheet/ccc?key=0AskrZnQrC8N3dDN5eFBiSHhVenFQUDNCNVFfTnEzVnc
Sized different but otherwise OK.
Still, the idea with the mobile sounds nice
Maybe make one with just a straight list instead of the drop down menu?
BTW, I can only view the table listing ingredients followed by effect. The one that has effect followed by ingredient only shows one entry. Probably that's an error on my end, because I'm viewing it on a Mac, and the formats don't always translate properly. But, thought I should mention it, just in case.