Kaziprst Milan Jovanovic Bankar Kos. Mitrovica
Član broj: 89218 Poruke: 146 *.201.214.82.in-addr.arpa.
|
mes. prezime neto bruto pio zdravstvo nezaposl. porez
01 Miroslav Radovanovi} 17,000.00 24,566.47 2,530.35 1,461.71 135.12 3,439.31
02 Miroslav Radovanovi} 17,000.00 24,566.47 2,530.35 1,461.71 135.12 3,439.31
03 Miroslav Radovanovi} 17,000.00 24,566.47 2,530.35 1,461.71 135.12 3,439.31
04 Miroslav Radovanovi} 8,500.00 12,283.24 1,265.17 730.85 67.56 1,719.65
05 Miroslav Radovanovi} 25,500.00 36,849.71 3,795.52 2,192.56 202.67 5,158.96
06 Miroslav Radovanovi} 12,325.00 18,098.38 1,990.82 1,113.05 55.74 3,568.96
07 Miroslav Radovanovi} 7,650.00 11,233.48 1,235.68 690.86 84.25 1,572.69
08 Miroslav Radovanovi} 16,150.00 23,715.12 2,608.66 1,458.48 177.86 3,320.12
09 Miroslav Radovanovi} 16,150.00 23,715.12 2,608.66 1,458.48 177.86 3,320.12
10 Miroslav Radovanovi} 16,150.00 23,715.12 2,608.66 1,458.48 177.86 3,320.12
11 Miroslav Radovanovi} 6,160.00 9,045.52 995.01 556.30 67.84 1,266.37
12 Miroslav Radovanovi} 6,160.00 9,045.52 995.01 556.30 67.84 1,266.37
01 Petar Petrovi} 16,000.00 23,121.39 2,381.50 1,375.72 127.17 3,236.99
02 Petar Petrovi} 16,000.00 23,121.39 2,381.50 1,375.72 127.17 3,236.99
03 Petar Petrovi} 16,000.00 23,121.39 2,381.50 1,375.72 127.17 3,236.99
01 Petar Petrovi} 16,000.00 23,121.39 2,381.50 1,375.72 127.17 3,236.99
02 Petar Petrovi} 16,000.00 23,121.39 2,381.50 1,375.72 127.17 3,236.99
03 Petar Petrovi} 16,000.00 23,121.39 2,381.50 1,375.72 127.17 3,236.99
04 Petar Petrovi} 16,000.00 23,121.39 2,381.50 1,375.72 127.17 3,236.99
05 Petar Petrovi} 25,000.00 36,127.17 3,721.10 2,149.57 198.70 5,057.80
06 Petar Petrovi} 25,000.00 36,710.72 4,038.18 2,257.71 275.33 5,139.50
07 Petar Petrovi} 17,500.00 25,697.50 2,826.73 1,580.40 192.73 3,597.65
08 Petar Petrovi} 25,000.00 36,710.72 4,038.18 2,257.71 275.33 5,139.50
09 Petar Petrovi} 25,000.00 36,710.72 4,038.18 2,257.71 275.33 5,139.50
10 Petar Petrovi} 23,750.00 34,875.18 3,836.27 2,144.82 261.56 4,882.53
11 Petar Petrovi} 6,160.00 9,045.52 995.01 556.30 67.84 1,266.37
12 Petar Petrovi} 6,160.00 9,045.52 995.01 556.30 67.84 1,266.37
Evo ovako sam ti poslao posto ne znam kako da atachujem za poruku a radi se o excel fajlu. Znaci iznos za Bruto =neto/0.692 do 5-og meseca, a od 6-og meseca Bruto=neto/0.681. Znaci mene zanima el postoji funkcija neka u excelu da mi npr od 1-5 meseca automatski izracuna (Bruto =neto/0.692) a od 6-12 Bruto=neto/0.681. Znaci da se tokom cele godine nije menala osnovica za neto pio... ja bih lako samo povucem onaj krstic do kraja a ovako moram za svakog radnika pojedinacno da vucem od 1-5 i od 6-12. Jel si me razumeo sad Apos-tole?????
|