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
2000 proces_01 =S3+S4 =T3+T4
3000 subproces_01_01 =SUM(Q3:Q4) =SUM(R3:R4)
4000 subproces_01_02 =SUM(Q4:Q5) =SUM(R4:R5)
5000 proces_02 =S6 =T6
6000 subproces_02_01 =SUM(Q6:Q7) =SUM(R6:R7)
7000 proces_03 =S8+S9 =T8+T9
8000 subproces_03_01 =SUM(Q8:Q9) =SUM(R8:R9)
9000 subproces_03_02 =SUM(Q9:Q10) =SUM(R9:R10)
10000 proces_04 =S11+S12+S13 =T11+T12+T13
11000 subproces_04_01 =SUM(Q11:Q12) =SUM(R11:R12)
12000 subproces_04_02 =SUM(Q12:Q13) =SUM(R12:R13)
13000 subproces_04_03 =SUM(Q13:Q14) =SUM(R13:R14)
14000 proces_05 =S15+S16 =T15+T16
15000 subproces_05_01 =SUM(Q15:Q16) =SUM(R15:R16)
16000 subproces_05_02 =SUM(Q16:Q17) =SUM(R16:R17)
17000 =S2+S5+S7+S10+S14 =T2+T5+T7+T10+T14
18000 =tm_update_01(k? * l?)
19000 =tm_update_01(o? * p?)
=tm_sumif_02((D2:D17)(R2:R17))