{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Ark1","Ark2","Ark3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Ark1","index":0,"n_rows":85,"n_cols":6,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["NUGF Viborg - regnskab 2016"]
[]
["Resultatopgørelse for perioden 1. januar til 31. december"]
[]
[null,2016,2015,2014,2013,2012]
["Indtægter:"]
["Kontingenter",{"$f":"394498+11880-24291","v":382087},313231,516281.87,273352,385427]
["Tab kontingenter",0,-39173,0,0,-836]
["Medlemstilskud/lokaletilskud",{"$f":"3126.14+6205+61920","v":71251.14},{"$f":"58425+29518.97","v":87943.97},{"$f":"44840+31744.31","v":76584.31},{"$f":"45180+20199.99","v":65379.990000000005},{"$f":"38325+16288.68","v":54613.68}]
["Sponsorater",5000,6800,17497.75,24930,14100]
["Bandereklamer",0,null,1875,27262.5,7418.75]
["Indtægter klubhus",-7671.47,-9204.7000000000007,-10113.469999999999,-10247.4,-7242.41]
["Indtægte sommerfest",-2551.25,-8202.9,-2318.88,6221.11,9204]
["Renteindtægter",0,null,0,391.91,418.52]
["Øvrige indtægter",14100,{"$f":"70000+3000.14","v":73000.14},1986,1554,12558]
["Indtægter i alt",{"$f":"SUM(B7:B15)","v":462215.42000000004},424394.50999999995,601792.57999999996,388844.10999999993,475661.54000000004]
[]
["Udgifter:"]
["Fodbold:"]
[]
["Turneringsudgifter",{"$f":"(-18086.02+61920)","v":43833.979999999996},79528.7,99440.26,99582.59,82487.789999999994]
["Trænerudgifter",55800,50778.5,37300,34960,41579]
["Bolde, materialer og tøj",24637.5,24989.75,96356.3,150330.54999999999,124858.38]
["Dommerudgifter",41392.39,48014.66]
["Kursus",2613.0300000000002,6240,14600,0,3000]
["Halleje",42521.5,14783,37823.75,35296,28871.5]
["Bøder",4925,8175,0,0,0]
[]
["Administration:"]
["Møder/arrangementer",51656.93,24808.68,20016.98,16347.03,18294.689999999999]
["Bogføringsassistance",1692.5,5800]
["Porto og gebyrer",1142.81,1000,1443.01,3345,10467.32]
["Annoncer og reklamer",null,null,1026.1500000000001,0,0]
["Gaver",7133.75,5132,192.95,1100,285]
["Tlf og licenser",3533.5,2825.54,7633,9401.36,7097.74]
["Kontorhold",0,null,34,0,1094.7]
["Kontingenter ",7586.5,5200]
["Dataløn, Viborg Idrætsråd",8908.9599999999991,8321.6200000000008,9488.2000000000007,4298,3496.64]
[]
["Klubhus:"]
["Forbrugsudgifter",16259.66,32380.75,15413.71,12304.21,{"$f":"16842.58+6720.25","v":23562.83}]
["Anskaffelser ",2577.1,8961.75,{"$f":"9189.8+1622.2","v":10812},{"$f":"4435.37+1119.3","v":5554.67},{"$f":"16979.76+1840.99","v":18820.75}]
["Lønninger",39999.410000000003,34807.56,42100.68,36468.53,38624.83]
["Klubhus renovering",22000,224960.88]
["Vedligeholdelse inde/ude",1248.8499999999999,7974.11,{"$f":"12728.75+974.1","v":13702.85},1929.38,{"$f":"1492.5+1844.4","v":3336.9}]
["Forsikringer",7205.68,7105.58,6995.71,6838.75,2460.9699999999998]
["Diverse Indtægter/udgifter",{"$f":"-1200+47.93","v":-1152.07},4997.28]
["Omkostninger i alt",{"$f":"SUM(B21:B47)","v":385516.98},{"$f":"SUM(C21:C47)","v":606785.36},{"$f":"SUM(D21:D47)","v":414379.55000000005},417756.07000000007,408339.04000000004]
[]
["Årets resultat",{"$f":"B16-B48","v":76698.440000000061},-182390.85000000003,187413.02999999991,-28911.960000000137,67322.5]
[]
["Balance pr. 31.12"]
[]
["Kassebeholdning",0,0,0,369.25,369.25]
["Jyske Bank konto (inkl. Swipp&Mobilepay)",{"$f":"47706.8+6009+153592.25+9395.39+250000+18287.49","v":484990.93},{"$f":"244037.85+1843+23057.5+15032.39","v":283970.74},383044.83,205880.55,230519.51]
["Kontant beholdning, kiosk",500,500,2000,2000,2000]
["Varelager",0,0,3000,3000,3000]
["Tilgodehavende kontingenter",{"$f":"57384-24291","v":33093},11279,46850,36232,40505]
["Tilgodehavende Sponsorater",14722,0,0,0,0]
["Tilgodehavende, øvrige",979.62,979.62,0,0,0]
[]
["Aktiver i alt",{"$f":"SUM(B54:B61)","v":534285.54999999993},{"$f":"SUM(C54:C61)","v":296729.36},{"$f":"SUM(D54:D61)","v":434894.83},{"$f":"SUM(E54:E61)","v":247481.8},{"$f":"SUM(F54:F61)","v":276393.76}]
[]
["Egenkapital 01.01.",252503.84,434894.69,247481.66,276393.62,{"$f":"G66","v":0}]
["Årets resultat",76698.44,-182390.85,{"$f":"D50","v":187413.02999999991},{"$f":"E50","v":-28911.960000000137},{"$f":"F50","v":67322.5}]
["Egenkapital 31.12.",{"$f":"SUM(B64:B65)","v":329202.28000000003},{"$f":"SUM(C64:C65)","v":252503.84},{"$f":"SUM(D64:D65)","v":434894.68999999994},{"$f":"SUM(E64:E65)","v":247481.65999999986},{"$f":"SUM(F64:F65)","v":67322.5}]
[]
["Hensættelser, omklædningsrum",{"$f":"201914.5+2520.39","v":204434.89},38089.89]
["Skyldige omkostninger",648.38,6135.63,0,0,0]
["Skyldige moms",null,0,0.14000000000000001,0.14000000000000001]
["Gæld i alt",{"$f":"SUM(B68:B70)","v":205083.27000000002},{"$f":"SUM(C68:C70)","v":44225.52},{"$f":"SUM(D69:D70)","v":0.14000000000000001},{"$f":"SUM(E69:E70)","v":0.14000000000000001},{"$f":"SUM(F69:F70)","v":0}]
[]
["Passiver i alt",{"$f":"B66+B71","v":534285.55000000005},{"$f":"C66+C71","v":296729.36},{"$f":"D66+D71","v":434894.82999999996},{"$f":"E66+E71","v":247481.79999999987},{"$f":"F66+F71","v":67322.5}]
[]
[]
["Foranstående regnskab er gennemgået og fundet i orden. Der er foretaget stikprøver af bilag,"]
["og disse er fundet i overensstemmelse med bogholderiet. Kasse og bank er afstemt."]
[]
["Viborg, d. 18. februar 2017"]
[]
[]
["Evan B. Pedersen, revisor","Anders Hauge, Økonomiansvarlig"]
[]
[]
[" "]

{"sheet":"Ark2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Ark3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}