structure_id | source_id | must_be_blank | source_id | proces | subproces | opis_aktivnosti | šifra_materiala | opis_materiala | enota_mere | cena_materiala | količina_materiala | šifra_vrste_dela | opis_vrste_dela | urna_postavka | količina_dela | strošek_material | strošek_delo (17 kolona, začetek formul) | subtotal_material | subtotal_delo | komentar | |
insert to 1.2 | 2000 | proces_01 | =s3+s4 | =t3+t4 | |||||||||||||||||
insert to 1.3 | 3000 | subproces_01_01 | =sum(q3:q4) | =sum(r3:r4) | |||||||||||||||||
insert to 1.4 | 4000 | subproces_01_02 | =sum(q4:q5) | =sum(r4:r5) | |||||||||||||||||
insert to 1.5 | 5000 | proces_02 | =s6 | =t6 | |||||||||||||||||
insert to 1.6 | 6000 | subproces_02_01 | =sum(q6:q7) | =sum(r6:r7) | |||||||||||||||||
insert to 1.7 | 7000 | proces_03 | =s8+s9 | =t8+t9 | |||||||||||||||||
insert to 1.8 | 8000 | subproces_03_01 | =sum(q8:q9) | =sum(r8:r9) | |||||||||||||||||
insert to 1.9 | 9000 | subproces_03_02 | =sum(q9:q10) | =sum(r9:r10) | |||||||||||||||||
insert to 1.10 | 10000 | proces_04 | =s11+s12+s13 | =t11+t12+t13 | |||||||||||||||||
insert to 1.11 | 11000 | subproces_04_01 | =sum(q11:q12) | =sum(r11:r12) | |||||||||||||||||
insert to 1.12 | 12000 | subproces_04_02 | =sum(q12:q13) | =sum(r12:r13) | |||||||||||||||||
insert to 1.13 | 13000 | subproces_04_03 | =sum(q13:q14) | =sum(r13:r14) | |||||||||||||||||
insert to 1.14 | 14000 | proces_05 | =s15+s16 | =t15+t16 | |||||||||||||||||
insert to 1.15 | 15000 | subproces_05_01 | =sum(q15:q16) | =sum(r15:r16) | |||||||||||||||||
insert to 1.16 | 16000 | subproces_05_02 | =sum(q16:q17) | =sum(r16:r17) | |||||||||||||||||
insert to 1.17 | 17000 | =s2+s5+s7+s10+s14 | =t2+t5+t7+t10+t14 | ||||||||||||||||||
insert to 1.18 | 18000 | =tm_update_01(k? * l?) | |||||||||||||||||||
insert to 1.19 | 19000 | =tm_update_01(o? * p?) | |||||||||||||||||||
insert to 1.20 | =tm_sumif_02((d2:d17)(r2:r17)) |