block_transform

unter

Daten | Formeln für Batch mit Transformationen

eine Textdatei mit den gesammelten Transformationsbefehlen erstellen, die immer wieder laufen kann (Teil-Automatisierung)

Beispielcode mit Lösungsansätzen für die Aufgaben:

u_state101 = iif(state101 > 0 and state101 < 5; 5 - state101;"") 
u_state102 = iif(state102 > 0 and state102 < 5; 5 - state102;"")
u_state103 = iif(state103 > 0 and state103 < 5; state103;"")
u_state104 = iif(state104 > 0 and state104 < 5; state104;"")
u_state105 = iif(state105 > 0 and state105 < 5; 5 - state105;"")
u_state106 = iif(state106 > 0 and state106 < 5; state106;"")
u_state107 = iif(state107 > 0 and state107 < 5; state107;"")
u_state108 = iif(state108 > 0 and state108 < 5; 5 - state108;"")
u_state109 = iif(state109 > 0 and state109 < 5; state109;"")
u_state110 = iif(state110 > 0 and state110 < 5; 5 - state110;"")
u_state111 = iif(state111 > 0 and state111 < 5; 5 - state111;"")
u_state112 = iif(state112 > 0 and state112 < 5; state112;"")
u_state113 = iif(state113 > 0 and state113 < 5; state113;"")
u_state114 = iif(state114 > 0 and state114 < 5; state114;"")
u_state115 = iif(state115 > 0 and state115 < 5; 5 - state115;"")
u_state116 = iif(state116 > 0 and state116 < 5; 5 - state116;"")
u_state117 = iif(state117 > 0 and state117 < 5; state117;"")
u_state118 = iif(state118 > 0 and state118 < 5; state118;"")
u_state119 = iif(state119 > 0 and state119 < 5; 5 - state119;"")
u_state120 = iif(state120 > 0 and state120 < 5; 5 - state120;"")


u_state201 = iif(state201 > 0 and state201 < 5; 5 - state201;"") 
u_state202 = iif(state202 > 0 and state202 < 5; 5 - state202;"")
u_state203 = iif(state203 > 0 and state203 < 5; state203;"")
u_state204 = iif(state204 > 0 and state204 < 5; state204;"")
u_state205 = iif(state205 > 0 and state205 < 5; 5 - state205;"")
u_state206 = iif(state206 > 0 and state206 < 5; state206;"")
u_state207 = iif(state207 > 0 and state207 < 5; state207;"")
u_state208 = iif(state208 > 0 and state208 < 5; 5 - state208;"")
u_state209 = iif(state209 > 0 and state209 < 5; state209;"")
u_state210 = iif(state210 > 0 and state210 < 5; 5 - state210;"")
u_state211 = iif(state211 > 0 and state211 < 5; 5 - state211;"")
u_state212 = iif(state212 > 0 and state212 < 5; state212;"")
u_state213 = iif(state213 > 0 and state213 < 5; state213;"")
u_state214 = iif(state214 > 0 and state214 < 5; state214;"")
u_state215 = iif(state215 > 0 and state215 < 5; 5 - state215;"")
u_state216 = iif(state216 > 0 and state216 < 5; 5 - state216;"")
u_state217 = iif(state217 > 0 and state217 < 5; state217;"")
u_state218 = iif(state218 > 0 and state218 < 5; state218;"")
u_state219 = iif(state219 > 0 and state219 < 5; 5 - state219;"")
u_state220 = iif(state220 > 0 and state220 < 5; 5 - state220;"")



u_trait121 = iif(trait121 > 0 and trait121 < 5; 5 - trait121;"") 
u_trait122 = iif(trait122 > 0 and trait122 < 5; trait122;"")
u_trait123 = iif(trait123 > 0 and trait123 < 5; trait123;"")
u_trait124 = iif(trait124 > 0 and trait124 < 5; trait124;"")
u_trait125 = iif(trait125 > 0 and trait125 < 5; trait125;"")
u_trait126 = iif(trait126 > 0 and trait126 < 5; 5 - trait126;"")
u_trait127 = iif(trait127 > 0 and trait127 < 5; 5 - trait127;"")
u_trait128 = iif(trait128 > 0 and trait128 < 5; trait128;"")
u_trait129 = iif(trait129 > 0 and trait129 < 5; trait129;"")
u_trait130 = iif(trait130 > 0 and trait130 < 5; 5 - trait130;"")
u_trait131 = iif(trait131 > 0 and trait131 < 5; trait131;"")
u_trait132 = iif(trait132 > 0 and trait132 < 5; trait132;"")
u_trait133 = iif(trait133 > 0 and trait133 < 5; 5 - trait133;"")
u_trait134 = iif(trait134 > 0 and trait134 < 5; trait134;"")
u_trait135 = iif(trait135 > 0 and trait135 < 5; trait135;"")
u_trait136 = iif(trait136 > 0 and trait136 < 5; 5 - trait136;"")
u_trait137 = iif(trait137 > 0 and trait137 < 5; trait137;"")
u_trait138 = iif(trait138 > 0 and trait138 < 5; trait138;"")
u_trait139 = iif(trait139 > 0 and trait139 < 5; 5 - trait139;"")
u_trait140 = iif(trait140 > 0 and trait140 < 5; trait140;"")


u_trait221 = iif(trait221 > 0 and trait221 < 5; 5 - trait221;"") 
u_trait222 = iif(trait222 > 0 and trait222 < 5; trait222;"")
u_trait223 = iif(trait223 > 0 and trait223 < 5; trait223;"")
u_trait224 = iif(trait224 > 0 and trait224 < 5; trait224;"")
u_trait225 = iif(trait225 > 0 and trait225 < 5; trait225;"")
u_trait226 = iif(trait226 > 0 and trait226 < 5; 5 - trait226;"")
u_trait227 = iif(trait227 > 0 and trait227 < 5; 5 - trait227;"")
u_trait228 = iif(trait228 > 0 and trait228 < 5; trait228;"")
u_trait229 = iif(trait229 > 0 and trait229 < 5; trait229;"")
u_trait230 = iif(trait230 > 0 and trait230 < 5; 5 - trait230;"")
u_trait231 = iif(trait231 > 0 and trait231 < 5; trait231;"")
u_trait232 = iif(trait232 > 0 and trait232 < 5; trait232;"")
u_trait233 = iif(trait233 > 0 and trait233 < 5; 5 - trait233;"")
u_trait234 = iif(trait234 > 0 and trait234 < 5; trait234;"")
u_trait235 = iif(trait235 > 0 and trait235 < 5; trait235;"")
u_trait236 = iif(trait236 > 0 and trait236 < 5; 5 - trait236;"")
u_trait237 = iif(trait237 > 0 and trait237 < 5; trait237;"")
u_trait238 = iif(trait238 > 0 and trait238 < 5; trait238;"")
u_trait239 = iif(trait239 > 0 and trait239 < 5; 5 - trait239;"")
u_trait240 = iif(trait240 > 0 and trait240 < 5; trait240;"")



n_valid_state1 = validn(u_state101:u_state120)
state1_m = iif(n_valid_state1 > 18; mean(u_state101:u_state120); "")
state1_s = state1_m * 20

n_valid_state2 = validn(u_state201:u_state220)
state2_m = iif(n_valid_state2 > 18; mean(u_state201:u_state220); "")
state2_s = state2_m * 20

n_valid_trait1 = validn(u_trait121:u_trait140)
trait1_m = iif(n_valid_trait1 > 18; mean(u_trait121:u_trait140); "")
trait1_s = trait1_m * 20

n_valid_trait2 = validn(u_trait221:u_trait240)
trait2_m = iif(n_valid_trait2 > 18; mean(u_trait221:u_trait240); "")
trait2_s = trait2_m * 20