Sarbian changed the topic of #kspmodding to: Welcome to #kspmodding - the channel for discussing, and learning about, modding Kerbal Space Program. Code of Conduct: https://git.io/vSQh6 | Always provide logs. | *** PSA: https://kerbalspaceprogram.com/api/index.htm | Someone is writting a Phd dissertation on KSP modding please fill out this survey https://goo.gl/forms/1vrkPYH4az8l32sb2 - I have met him and it s legit
BasharMilesTeg_ has joined #kspmodding
BasharMilesTeg has quit [Ping timeout: 200 seconds]
BasharMilesTeg_ has quit [Ping timeout: 383 seconds]
CragnatharTheDestroyer has quit [Read error: Connection reset by peer]
blowfish has joined #kspmodding
NathanKell|AWAY is now known as NathanKell
NathanKell is now known as NathanKell|Twitch
NathanKell|Twitch is now known as NathanKell
NathanKell is now known as NathanKell|NOMZ
<xShadowx>
anyone good at excel? i have a column with numbers, i basicly want the highest number in the column, which &MAX($G$2:$G$1003) works for most, but a couple cells need to hold multiple numbers, with some seperator, which this doesnt work for
<xShadowx>
i could just add more columns >.> but kinda dont want to if an easy answer
<blowfish>
there must be some split function
<xShadowx>
meh just gonna make another column, found a way to make it non ugly
Daz has quit [*.net *.split]
Starwaster has quit [*.net *.split]
Technicalfool_ has quit [*.net *.split]
Iskierka has quit [*.net *.split]
SirKeplan has quit [*.net *.split]
lamont has quit [*.net *.split]
taniwha has quit [*.net *.split]
stratochief has quit [*.net *.split]
Virindi has quit [*.net *.split]
JPLRepo has quit [*.net *.split]
Sigma88 has quit [*.net *.split]
ferram4 has quit [*.net *.split]
Pap has quit [*.net *.split]
ve2dmn has quit [*.net *.split]
TheKosmonaut has quit [*.net *.split]
blowfish has quit [*.net *.split]
BasharMilesTeg has quit [*.net *.split]
X has quit [*.net *.split]
NathanKell|NOMZ has quit [*.net *.split]
kmath has quit [*.net *.split]
DuoDex has quit [*.net *.split]
NBones has quit [*.net *.split]
Tivec has quit [*.net *.split]
acc has quit [*.net *.split]
HiddenKnowledge has quit [*.net *.split]
Olympic1 has quit [*.net *.split]
xShadowx has quit [*.net *.split]
HiddenKnowledge has joined #kspmodding
stratochief has joined #kspmodding
Tivec has joined #kspmodding
ferram4 has joined #kspmodding
lamont has joined #kspmodding
xShadowx has joined #kspmodding
NBones has joined #kspmodding
SirKeplan has joined #kspmodding
NathanKell|NOMZ has joined #kspmodding
Virindi has joined #kspmodding
Iskierka has joined #kspmodding
TheKosmonaut has joined #kspmodding
Technicalfool_ has joined #kspmodding
ve2dmn has joined #kspmodding
X has joined #kspmodding
Pap has joined #kspmodding
<Tivec>
xShadowx, if you want to do *anything* fancy, don't do it in excel :P but for what you are describing, you could either split the text in the formula and make the formula ugly and hard to maintain, or you can add another column
<Tivec>
i think the column solution is the best
<xShadowx>
Tivec: upside is i dont ned to maintain it ;p just a one time thing designing this chat
<xShadowx>
chart
<xShadowx>
but ya i just wnt for column, thought itd be uglier but found a no so ugly method to do it
<Tivec>
Mm, excel isn't pretty when you start working with formulas :D
<Tivec>
also, to get the max value for an entire column, you can do =MAX(G:G) iirc
NathanKell|NOMZ is now known as NathanKell
NathanKell is now known as NathanKell|AWAY
<Sigma88>
0/
ferram4 has quit [Ping timeout: 200 seconds]
BasharMilesTeg has joined #kspmodding
BasharMilesTeg_ has joined #kspmodding
BasharMilesTeg has quit [Ping timeout: 186 seconds]
BasharMilesTeg has joined #kspmodding
BasharMilesTeg_ has quit [Ping timeout: 186 seconds]
BasharMilesTeg_ has joined #kspmodding
BasharMilesTeg has quit [Ping timeout: 201 seconds]
BasharMilesTeg_ has quit [Ping timeout: 186 seconds]
BasharMilesTeg has joined #kspmodding
BasharMilesTeg_ has joined #kspmodding
BasharMilesTeg has quit [Ping timeout: 204 seconds]
Starwaster has joined #kspmodding
BasharMilesTeg has joined #kspmodding
BasharMilesTeg_ has quit [Ping timeout: 204 seconds]
BasharMilesTeg_ has joined #kspmodding
BasharMilesTeg has quit [Ping timeout: 201 seconds]
BasharMilesTeg has joined #kspmodding
BasharMilesTeg_ has quit [Ping timeout: 201 seconds]
BasharMilesTeg_ has joined #kspmodding
BasharMilesTeg has quit [Ping timeout: 204 seconds]
BasharMilesTeg has joined #kspmodding
BasharMilesTeg_ has quit [Ping timeout: 200 seconds]
BasharMilesTeg_ has joined #kspmodding
BasharMilesTeg has quit [Ping timeout: 201 seconds]
BasharMilesTeg has joined #kspmodding
BasharMilesTeg_ has quit [Ping timeout: 186 seconds]
BasharMilesTeg_ has joined #kspmodding
BasharMilesTeg has quit [Ping timeout: 186 seconds]
Starwaster has quit [Ping timeout: 201 seconds]
BasharMilesTeg_ has quit [Ping timeout: 186 seconds]
BasharMilesTeg has joined #kspmodding
ferram4 has joined #kspmodding
CragnatharTheDestroyer has joined #kspmodding
tfool has joined #kspmodding
Technicalfool_ has quit [Ping timeout: 186 seconds]
Starwaster has joined #kspmodding
SirKeplan is now known as SirKeplan|AFK
Ezriilc has joined #kspmodding
regex has joined #kspmodding
SirKeplan|AFK is now known as SirKeplan
Ezriilc has quit [Ping timeout: 186 seconds]
Ezriilc_ has joined #kspmodding
Ezriilc_ is now known as Ezriilc
<Starwaster>
Can anyone think of a way in a MM patch to sanitize numbers that should have been integers (think: string parse errors...) but were instead floats?
blowfish has joined #kspmodding
<xShadowx>
Starwaster: field ^= :^([0-9]*)\..*:$1: <- i think is the right regex syntax, truncates decimal and everything to the right of it
<xShadowx>
field ^= :^([0-9]+)\..*:$1: <- might do better, ensures 1+ digit left of decimal
<xShadowx>
:(?<=[0-9])\..*:: <- also truncates, the above was 'copy what i want and paste to new value', this is more 'chop off what i dont want', same result just another way to do it
blowfish has quit [Quit: This computer has gone to sleep]
SirKeplan is now known as SirKeplan|AFK
BasharMilesTeg_ has joined #kspmodding
<Sigma88>
Starwaster: I usually do this:
BasharMilesTeg__ has joined #kspmodding
<Sigma88>
I add a ".0" at the end
BasharMilesTeg has quit [Ping timeout: 204 seconds]
<Sigma88>
and then split the value as a floating point separated list
<Sigma88>
so you get the first element which is the integer value
<Sigma88>
but the regex thing might work better
BasharMilesTeg_ has quit [Ping timeout: 200 seconds]
BasharMilesTeg has joined #kspmodding
BasharMilesTeg__ has quit [Ping timeout: 204 seconds]
blowfish has joined #kspmodding
SirKeplan|AFK is now known as SirKeplan
blowfish has quit [Quit: Leaving]
regex has quit [Remote host closed the connection]