insert from | structure_id | source_id | 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 |
from 1.2 (org_enota_00_01) | 2000 | proces_01 | =s8+s10 | =t8+t10 | ||||||||||||||||
from 1.3 (org_enota_00_01) | 3000 | subproces_01_01 | =sum(q8:q10) | =sum(r8:r10) | ||||||||||||||||
from 2.4 (org_enota_01_01) | 3000 | oe_01_del_4 | oe_01_del_4 | aktivnost_04 | mat_id_4 | opis_mat_4 | kos | 14 | 2 | vrsta_dela_id_3 | opis_vrste_dela_3 | 43 | 5 | =k9 * l9 | =o9 * p9 | |||||
from 1.4 (org_enota_00_01) | 4000 | subproces_01_02 | =sum(q10:q14) | =sum(r10:r14) | ||||||||||||||||
from 2.6 (org_enota_01_01) | 4000 | oe_01_del_9 | oe_01_del_9 | aktivnost_09 | mat_id_9 | opis_mat_9 | kos | 19 | 3 | vrsta_dela_id_7 | opis_vrste_dela_7 | 47 | 6 | =k11 * l11 | =o11 * p11 | |||||
from 3.5 (org_enota_02_01) | 4000 | oe_02_del_11 | oe_02_del_11 | aktivnost_09 | mat_id_9 | opis_mat_9 | kos | 19 | 3 | vrsta_dela_id_7 | opis_vrste_dela_7 | 47 | 6 | =k12 * l12 | =o12 * p12 | |||||
from 4.5 (org_enota_03_01) | 4000 | oe_03_del_25 | oe_03_del_25 | aktivnost_20 | mat_id_20 | opis_mat_20 | m2 | 30 | 11 | vrsta_dela_id_11 | opis_vrste_dela_11 | 51 | 3 | =k13 * l13 | =o13 * p13 | |||||
from 1.5 (org_enota_00_01) | 5000 | proces_02 | =s15 | =t15 | ||||||||||||||||
from 1.6 (org_enota_00_01) | 6000 | subproces_02_01 | =sum(q15:q18) | =sum(r15:r18) | ||||||||||||||||
from 3.8 (org_enota_02_01) | 6000 | oe_02_del_12 | oe_02_del_12 | aktivnost_16 | mat_id_5 | opis_mat_5 | kos | 15 | 5 | vrsta_dela_id_9 | opis_vrste_dela_9 | 49 | 9 | =k16 * l16 | =o16 * p16 | |||||
from 4.8 (org_enota_03_01) | 6000 | oe_03_del_26 | oe_03_del_26 | aktivnost_21 | mat_id_21 | opis_mat_21 | m2 | 31 | 12 | vrsta_dela_id_12 | opis_vrste_dela_12 | 52 | 4 | =k17 * l17 | =o17 * p17 | |||||
from 1.7 (org_enota_00_01) | 7000 | proces_03 | =s19+s20 | =t19+t20 | ||||||||||||||||
from 1.8 (org_enota_00_01) | 8000 | subproces_03_01 | =sum(q19:q20) | =sum(r19:r20) | ||||||||||||||||
from 1.9 (org_enota_00_01) | 9000 | subproces_03_02 | =sum(q20:q22) | =sum(r20:r22) | ||||||||||||||||
from 4.12 (org_enota_03_01) | 9000 | oe_03_del_24 | oe_03_del_24 | aktivnost_22 | mat_id_22 | opis_mat_22 | m2 | 32 | 13 | vrsta_dela_id_13 | opis_vrste_dela_13 | 53 | 5 | =k21 * l21 | =o21 * p21 | |||||
from 1.10 (org_enota_00_01) | 10000 | proces_04 | =s23+s28+s29 | =t23+t28+t29 | ||||||||||||||||
from 1.11 (org_enota_00_01) | 11000 | subproces_04_01 | =sum(q23:q28) | =sum(r23:r28) | ||||||||||||||||
from 2.16 (org_enota_01_01) | 11000 | oe_01_del_10 | oe_01_del_10 | aktivnost_10 | mat_id_24 | opis_mat_24 | liter | 34 | 5 | vrsta_dela_id_10 | opis_vrste_dela_10 | 50 | 8 | =k24 * l24 | =o24 * p24 | |||||
from 2.15 (org_enota_01_01) | 11000 | oe_01_del_4 | oe_01_del_4 | aktivnost_04 | mat_id_5 | opis_mat_5 | kos | 15 | 4 | vrsta_dela_id_14 | opis_vrste_dela_14 | 54 | 7 | =k25 * l25 | =o25 * p25 | |||||
from 3.15 (org_enota_02_01) | 11000 | oe_02_del_20 | oe_02_del_20 | aktivnost_04 | mat_id_9 | opis_mat_9 | kos | 19 | vrsta_dela_id_7 | opis_vrste_dela_7 | 47 | 5 | =k26 * l26 | =o26 * p26 | ||||||
from 4.15 (org_enota_03_01) | 11000 | oe_03_del_24 | oe_03_del_24 | aktivnost_23 | mat_id_23 | opis_mat_23 | liter | 33 | 14 | =k27 * l27 | =o27 * p27 | |||||||||
from 1.12 (org_enota_00_01) | 12000 | subproces_04_02 | =sum(q28:q29) | =sum(r28:r29) | ||||||||||||||||
from 1.13 (org_enota_00_01) | 13000 | subproces_04_03 | =sum(q29:q33) | =sum(r29:r33) | ||||||||||||||||
from 3.19 (org_enota_02_01) | 13000 | oe_02_del_12 | oe_02_del_12 | aktivnost_12 | mat_id_22 | opis_mat_22 | m2 | 32 | 7 | vrsta_dela_id_12 | opis_vrste_dela_12 | 52 | 4 | =k30 * l30 | =o30 * p30 | |||||
from 3.18 (org_enota_02_01) | 13000 | oe_02_del_17 | oe_02_del_17 | aktivnost_11 | mat_id_21 | opis_mat_21 | m2 | 31 | 7 | vrsta_dela_id_11 | opis_vrste_dela_11 | 51 | 3 | =k31 * l31 | =o31 * p31 | |||||
from 4.18 (org_enota_03_01) | 13000 | oe_03_del_29 | oe_03_del_29 | aktivnost_24 | mat_id_24 | opis_mat_24 | liter | 34 | 15 | vrsta_dela_id_14 | opis_vrste_dela_14 | 54 | 6 | =k32 * l32 | =o32 * p32 | |||||
from 1.14 (org_enota_00_01) | 14000 | proces_05 | =s34+s37 | =t34+t37 | ||||||||||||||||
from 1.15 (org_enota_00_01) | 15000 | subproces_05_01 | =sum(q34:q37) | =sum(r34:r37) | ||||||||||||||||
from 2.21 (org_enota_01_01) | 15000 | oe_01_del_2 | oe_01_del_2 | aktivnost_02 | mat_id_20 | opis_mat_20 | m2 | 30 | 6 | vrsta_dela_id_10 | opis_vrste_dela_10 | 50 | 4 | =k35 * l35 | =o35 * p35 | |||||
from 3.22 (org_enota_02_01) | 15000 | oe_02_del_11 | oe_02_del_11 | aktivnost_02 | mat_id_20 | opis_mat_20 | m2 | 30 | 6 | vrsta_dela_id_10 | opis_vrste_dela_10 | 50 | 4 | =k36 * l36 | =o36 * p36 | |||||
from 1.16 (org_enota_00_01) | 16000 | subproces_05_02 | =sum(q37:q38) | =sum(r37:r38) | ||||||||||||||||
from 1.17 (org_enota_00_01) | 17000 | =s7+s14+s18+s22+s33 | =t7+t14+t18+t22+t33 | |||||||||||||||||
from 1.18 (org_enota_00_01) | 18000 | |||||||||||||||||||
from 1.19 (org_enota_00_01) | 19000 | |||||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe*";$r$7:$r$38) | sumif($d$7:$d$38;"oe*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_01*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_01*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_01_del*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_01_del*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_01_del_10*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_01_del_10*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_01_del_2*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_01_del_2*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_01_del_4*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_01_del_4*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_01_del_9*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_01_del_9*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_02*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_02*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_02_del*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_02_del*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_02_del_11*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_02_del_11*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_02_del_12*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_02_del_12*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_02_del_17*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_02_del_17*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_02_del_20*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_02_del_20*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_03*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_03*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_03_del*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_03_del*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_03_del_24*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_03_del_24*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_03_del_25*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_03_del_25*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_03_del_26*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_03_del_26*";$r$7:$r$38) | |||||||||||||||||
from 1.20 (org_enota_00_01) | 19000 | =sumif($d$7:$d$38;"oe_03_del_29*";$r$7:$r$38) | sumif($d$7:$d$38;"oe_03_del_29*";$r$7:$r$38) |