Table was created with program: tm_04_352.exe
We recommend using IE for code page change and for further use we recommend coding UTF-8.

More information on Web site: indexadd.com

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)