{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["1. Vejledning","2. Stamoplysninger","3. Budget","4. Regnskab","5. Redegørelse","6. Statusrapport","7.Delbudget (bilag)","Data","Logoer"],"not_rendered":{"charts":0,"images":36,"macros":1,"external_links":0,"defined_names":52,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"1. Vejledning","index":0,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["KORT VEJLEDNING I BRUG AF SKEMAET"]
[]
[null,"Introduktion"]
[]
[null,"2. Stamoplysninger"]
[]
[null,"3. Budget"]
[]
[null,"4. Regnskab"]
[]
[null,"5. Redegørelse"]
[]
[null,"6. Statusrapport"]
[]
[null,"7. Delbudget (bilag)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Version 1.01 gældende fra 08-04-2019"]

{"sheet":"2. Stamoplysninger","index":1,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null," "]
[null,"STAMOPLYSNINGER, FORUNDERSØGELSE"]
[]
[null,null,"Stedoplysninger",null,"(udfyld her)"]
[null,null,null,"Systemnnr. fra Fund og Fortidsminder "," "]
[]
[null,null,null,"Lokalitetsnavn"," "]
[null,null,null,"Sted- og lok. nr."," "]
[null,null,null,"Kommune"]
[null,null,null,"Museets journalnummer"," "]
[null,null,null,"Museum","Vælg","˅"]
[]
[null,null,null,"Styrelsens j. nr. oplyses ved afgørelsen"," "]
[]
[null,null,"Til beregning af udgifter"]
[null,null,null,"Areal der skal forundersøges",0,"m²","˅"]
[null,null,null,"Dækningsgrad, anbefalet 20 %",0.2]
[null,null,null,"Fremdrift, m² søgegrøfter pr. dag",1400,"m² pr. dag"]
[]
[null,null,"Landskab"]
[null,null,null,"Kulturarvsareal","Vælg","˅"]
[null,null,null,"Topografi","Vælg","˅"]
[]
[null,null,"Identifikation af bygherre"]
[null,null,null,"Bygherretype","Vælg","˅"]
[]
[null,null,null,"CVR-nummer"]
[null,null,null,"P-nummer"]
[null,null,null,"Navn virksomhed/Person"," "]
[]
[null,null,null,"Vejnavn og nr"," "]
[null,null,null,"Postnummer og by"," "]
[null,null,null,"Land"," "]
[null,null,null,"Telefon"]
[null,null,null,"e-mail"]
[]
[null,null,"Bygherres kontaktperson"]
[null,null,null,"CVR-nummer"]
[null,null,null,"P-nummer"]
[null,null,null,"Navn virksomhed/Person"," "]
[]
[null,null,null,"Vejnavn og nr."," "]
[null,null,null,"Postnummer og by"," "]
[null,null,null,"Land"," "]
[null,null,null,"Telefon"]
[null,null,null,"e-mail"]
[]
[]
[null,null,"Øvrige oplysninger"]
[null,null,null,"Årsag","Vælg","˅"]
[null,null,null,"Bygherres samlede projektareal"]
[null,null,null,"Bygherres samlede økonomiske ramme",null,"kr. inkl. moms"]
[]
[]
[null,null,"Besked til sagsbehandler vedr. budgettet"]

{"sheet":"3. Budget","index":2,"n_rows":99,"n_cols":9,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
["BUDGET FOR STØRRE ARKÆOLOGISK FORUNDERSØGELSE"]
[{"$f":"'2. Stamoplysninger'!E7","v":" "}]
[{"$f":"'2. Stamoplysninger'!E11","v":"Vælg"}]
["Museet j. nr. ",null,{"$f":"'2. Stamoplysninger'!E10","v":" "}]
["Sted- lok. nr.",null,{"$f":"'2. Stamoplysninger'!E8","v":" "}]
["SLKS j. nr.",null,{"$f":"'2. Stamoplysninger'!E13","v":" "}]
[null,null," "]
["Bygherre:",null,{"$f":"IF('2. Stamoplysninger'!E27>0,'2. Stamoplysninger'!E27,'2. Stamoplysninger'!E29)","v":" "}]
[null,null,{"$f":"'2. Stamoplysninger'!E31","v":" "}]
[null,null,{"$f":"'2. Stamoplysninger'!E32","v":" "}]
[]
["I.  Feltarbejde",null,null,null,"(udfyld her)","(udfyld her)"]
[null,"1.","Felttimer",null,"Antal","á kr."]
[null,null,"Ansvarlig udgravningsleder",null,{"$f":"ROUNDUP(IF(OR(SUM(E15:E19)>110,E15=0),SUM(E15:E19)*0.05,5),0)","v":0},510,"=",{"$f":"E14*F14","v":0},"kr."]
[null,null,"Daglig udgravningsleder",null,{"$f":"E53","v":0},430,"=",0,"kr."]
[null,null,"Akademisk medarbejder",null,{"$f":"E53","v":0},415,"=",0,"kr."]
[null,null,"Studentermedhjælper",null,0,270,"=",0,"kr."]
[null,null,"Museumstekniker",null,0,375,"=",0,"kr."]
[null,null,"Arbejdsmand",null,0,285,"=",0,"kr."]
[null,null,"Felttimesum i alt",null,null,null,null,{"$f":"SUM(H14:H19)","v":0},"kr."]
[]
[null,"2.","Eksterne specialister",null,"Antal","á kr."]
[null,null,"Specialist",null,0,0,"=",{"$f":"E23*F23","v":0},"kr."]
[null,null,"Landmåler",null,0,0,"=",{"$f":"E24*F24","v":0},"kr."]
[null,null,"Øvrigt feltarbejde i alt",null,null,null,null,{"$f":"SUM(H23:H24)","v":0},"kr."]
[]
["II. Dokumentation og tilgængeliggørelse"]
[null,"1.","Arkæologisk beretning og kulturhistorisk"]
[null,null," rapport samt indføring og magasinering"]
[null,null,null,null,null,0.2,"=",{"$f":"IF(OR(Felttimesum>F15*25,Felttimesum=0),H20*F30,F15*5)","v":0},"kr."]
[null,null,"Dokumentation i alt",null,null,null,null,{"$f":"SUM(H30)","v":0},"kr."]
[]
["III.  Personale- og transportudgifter"]
[null,"1.","Transport",null,"Km","á kr."]
[null,null,"Kørselsgodtgørelse",null,0,0,"=",{"$f":"E35*F35","v":0},"kr."]
[null,null,"Rejsegodtgørelse",null,0,0,"=",{"$f":"E36*F36","v":0},"kr."]
[null,null,"Transport i alt",null,null,null,null,{"$f":"SUM(H35:H36)","v":0},"kr."]
[]
[null,"2.","Kørsel",null,"Km pr. dag","á kr."]
[null,null,"Kørsel i museets/privatbil",null,0,3.56,"=",{"$f":"(ROUNDUP(E53/7.4,0)*F40)*E40","v":0},"kr."]
[null,null,"Lejet bil",null,0,0,"=",{"$f":"E41*F41","v":0},"kr."]
[null,null,"Transport til arbejdsplads (arbejdstid)",null,0,0,"=",{"$f":"E42*F42","v":0},"kr."]
[null,null,"Kørsel i alt",null,null,null,null,{"$f":"SUM(H40:H42)","v":0},"kr."]
[]
[null,"3.","Diæter og timepenge",null,"Antal dage","á kr."]
[null,null,"Dagdiæter",null,0,0,"=",{"$f":"E46*F46","v":0},"kr."]
[null,null,"Natdiæter",null,0,0,"=",{"$f":"E47*F47","v":0},"kr."]
[null,null,"Timepenge/felttillæg",null,{"$f":"ROUNDUP(E53/7.4,0)","v":0},0,"=",{"$f":"E48*F48","v":0},"kr."]
[null,null,"Diæter og timepenge i alt",null,null,null,null,{"$f":"SUM(H46:H48)","v":0},"kr."]
[]
["IV. Øvrige udgifter"]
[null,"1.","Maskinkraft",null,"Antal timer","á kr."]
[null,null,"Afrømning",null,{"$f":"ROUNDUP(('2. Stamoplysninger'!E16*'2. Stamoplysninger'!E17/'2. Stamoplysninger'!E18)*7.4,)","v":0},750,"=",{"$f":"E53*F53","v":0},"kr."]
[null,null,"Tildækning (f.eks. 50 % af afrømning)",null,{"$f":"SUM(E53*0.5)","v":0},750,"=",{"$f":"E54*F54","v":0},"kr."]
[null,null,"Transport",null,{"$f":"IF(E53>0,2,0)","v":0},2500,"=",{"$f":"E55*F55","v":0},"kr."]
[null,null,"Maskinkraft i alt",null,null,null,null,{"$f":"SUM(H53:H55)","v":0},"kr."]
[]
[null,"2.","Skurvogn og lign",null,"Antal","á kr."]
[null,null,"Leje inkl. Drift",null,{"$f":"ROUNDUP(E53/7.4,0)","v":0},600,"=",{"$f":"E59*F59","v":0},"kr."]
[null,null,"Transport",null,{"$f":"IF(E53>0,2,0)","v":0},500,"=",{"$f":"E60*F60","v":0},"kr."]
[null,null,"Skurvogn inkl. transport i alt ",null,null,null,null,{"$f":"H59+H60","v":0},"kr."]
[]
[null,"3.","Materialer og særligt udstyr",null,"Antal","á kr."]
[null,null,"Opmålingsudstyr",null,{"$f":"ROUNDUP(E53/7.4,0)","v":0},300,"=",{"$f":"E64*F64","v":0},"kr."]
[null,null,"Sold",null,0,0,"=",{"$f":"E65*F65","v":0},"kr."]
[null,null,"El, vand, brændstof, pumper eller lign.",null,0,0,"=",{"$f":"E66*F66","v":0},"kr."]
[null,null,"…",null,0,0,"=",{"$f":"E67*F67","v":0},"kr."]
[null,null,"…",null,0,0,"=",{"$f":"E68*F68","v":0},"kr."]
[null,null,"Materialer og særligt udstyr i alt",null,null,null,null,{"$f":"SUM(H64:H68)","v":0},"kr."]
[]
["V. Uforudsete udgifter"]
[null,"1.","Uforudsete udgifter"]
[null,null,null,null,null,0.1,"=",{"$f":"SUM(H20+H25+H31+H37+H49+H56+H61+H69+H43+H76)*F73","v":0},"kr."]
[null,null,"Uforudsete udgifter i alt",null,null,null,null,{"$f":"SUM(H73)","v":0},"kr."]
[]
[]
[]
["Udgifter i alt eksklusiv moms",null,null,null,null,null,"=",{"$f":"H20+H25+H31+H37+H49+H56+H61+H69+H43+H74","v":0},"kr."]
[]
[null,null,"moms",null,null,null,"=",{"$f":"H78*0.25","v":0},"kr."]
["Udgifter i alt inklusiv moms",null,null,null,null,null,"=",{"$f":"SUM(H78,H80)","v":0},"kr."]
[null,null,null,null,null,null,null,{"$f":"IFERROR(H81/'2. Stamoplysninger'!E16,\"0\")","v":"0"},"kr/m²"]
[]
["VI. Udgifter til vinterforanstaltninger"]
[]
[null,null,"Hvis arbejdet ønskes gennemført i perioden 1. november til 31. marts må påregnes udgifter til nedenstående vinterforanstaltninger."]
[null,"1.","Udgifter til vinterforanstaltninger",null,"Antal","á kr."]
[null,null,"…",null,0,0,"=",{"$f":"E88*F88","v":0},"kr."]
[null,null,"…",null,0,0,"=",{"$f":"E89*F89","v":0},"kr."]
[null,null,"…",null,0,0,"=",{"$f":"E90*F90","v":0},"kr."]
[null,null,"…",null,0,0,"=",{"$f":"E91*F91","v":0},"kr."]
[null,null,"…",null,0,0,"=",{"$f":"E92*F92","v":0},"kr."]
[null,null,"Udgifter til vinterforanstaltninger i alt",null,null,null,null,{"$f":"SUM(H88:H92)","v":0},"kr."]
[]
["Udgifter til vinterforanstaltninger eksklusiv moms",null,null,null,null,null,"=",{"$f":"H93","v":0},"kr."]
[]
[null,null,"moms",null,null,null,"=",{"$f":"H95*0.25","v":0},"kr."]
["Udgifter i alt inklusiv moms og vinterforanstaltninger",null,null,null,null,null,"=",{"$f":"SUM(H95,H97,H81)","v":0},"kr."]
[null,null,null,null,null,null,null,{"$f":"IFERROR(H98/'2. Stamoplysninger'!E16,\"0\")","v":"0"},"kr/m²"]

{"sheet":"4. Regnskab","index":3,"n_rows":140,"n_cols":9,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
["REGNSKAB FOR STØRRE ARKÆOLOGISK FORUNDERSØGELSE"]
[{"$f":"'2. Stamoplysninger'!E7","v":" "}]
[{"$f":"'2. Stamoplysninger'!E11","v":"Vælg"}]
["Museet j. nr. ",null,{"$f":"'2. Stamoplysninger'!E10","v":" "}]
["Sted- lok. nr.",null,{"$f":"'2. Stamoplysninger'!E8","v":" "},null,null,"Endeligt areal",null,0,{"$f":"IF('2. Stamoplysninger'!F16=\"m²\",\"m²\",\"m³\")","v":"m²"}]
["SLKS j. nr.",null,{"$f":"'2. Stamoplysninger'!E13","v":" "},null,null,"Areal af grøfter og udvidelser",null,0,{"$f":"IF('2. Stamoplysninger'!F16=\"m²\",\"m²\",\"m³\")","v":"m²"}]
[null,null,null,null,null,"Endelig dækningsgrad",null,{"$f":"IF(H5=0,0,H6/H5)","v":0}]
["Bygherre:",null,{"$f":"IF('2. Stamoplysninger'!E27>0,'2. Stamoplysninger'!E27,'2. Stamoplysninger'!E29)","v":" "}]
[null,null,{"$f":"'2. Stamoplysninger'!E31","v":" "},null,null,"Efterfølgende beretning",null,"Nej","˅"]
[null,null,{"$f":"'2. Stamoplysninger'!E32","v":" "}]
[null,null,null,null,"NB! Regnskabsaflæggelse ift. styrelsen, ikke faktura"]
["I.  Feltarbejde",null,null,null,"(udfyld her)","(udfyld her)"]
[null,"1.","Felttimer",null,"Antal","á kr."]
[null,null,{"$f":"'3. Budget'!C14","v":"Ansvarlig udgravningsleder"},null,0,0,"=",{"$f":"E14*F14","v":0},"kr."]
[null,null,{"$f":"'3. Budget'!C15","v":"Daglig udgravningsleder"},null,0,0,"=",0,"kr."]
[null,null,{"$f":"'3. Budget'!C16","v":"Akademisk medarbejder"},null,0,0,"=",0,"kr."]
[null,null,{"$f":"'3. Budget'!C17","v":"Studentermedhjælper"},null,0,0,"=",0,"kr."]
[null,null,{"$f":"'3. Budget'!C18","v":"Museumstekniker"},null,0,0,"=",0,"kr."]
[null,null,{"$f":"'3. Budget'!C19","v":"Arbejdsmand"},null,0,0,"=",0,"kr."]
[null,null,"…",null,0,0,"=",0,"kr."]
[null,null,"…",null,0,0,"=",0,"kr."]
[null,null,"…",null,0,0,"=",0,"kr."]
[null,null,"…",null,0,0,"=",0,"kr."]
[null,null,"Felttimesum i alt",null,null,null,null,{"$f":"SUM(H14:H23)","v":0},"kr."]
[]
[null,"2.","Eksterne specialister",null,"Antal","á kr."]
[null,null,"Specialist",null,0,0,"=",{"$f":"E27*F27","v":0},"kr."]
[null,null,"Landmåler",null,0,0,"=",{"$f":"E28*F28","v":0},"kr."]
[null,null,"Øvrigt feltarbejde i alt",null,null,null,null,{"$f":"SUM(H27:H28)","v":0},"kr."]
[]
["II. Dokumentation og tilgængeliggørelse"]
[null,"1.","Arkæologisk beretning og kulturhistorisk"]
[null,null," rapport samt indføring og magasinering",null,"Timer"]
[null,null,null,null,null,{"$f":"'3. Budget'!F30","v":0.2},"=",{"$f":"IF(AND(H9=\"Ja\",H24<Felttimesum),H24*'3. Budget'!F30,IF(AND(H9=\"Ja\",H24>Felttimesum),Rapport,0))","v":0},"kr."]
[null,null,"Dokumentation i alt",null,null,null,null,{"$f":"SUM(H34)","v":0},"kr."]
[]
["III.  Personale- og transportudgifter"]
[null,"1.","Transport",null,"Km","á kr."]
[null,null,"Kørselsgodtgørelse",null,0,0,"=",{"$f":"E39*F39","v":0},"kr."]
[null,null,"Rejsegodtgørelse",null,0,0,"=",{"$f":"E40*F40","v":0},"kr."]
[null,null,"Transport i alt",null,null,null,null,{"$f":"SUM(H39:H40)","v":0},"kr."]
[]
[null,"2.","Kørsel",null,"Km pr. dag","á kr."]
[null,null,"Kørsel i museets/privatbil",null,0,0,"=",{"$f":"E44*F44","v":0},"kr."]
[null,null,"Lejet bil",null,0,0,"=",{"$f":"E45*F45","v":0},"kr."]
[null,null,"Transport til arbejdsplads (arbejdstid)",null,0,0,"=",{"$f":"E46*F46","v":0},"kr."]
[null,null,"Kørsel i alt",null,null,null,null,{"$f":"SUM(H44:H46)","v":0},"kr."]
[]
[null,"3.","Diæter og timepenge",null,"Antal dage","á kr."]
[null,null,"Dagdiæter",null,0,0,"=",{"$f":"E50*F50","v":0},"kr."]
[null,null,"Natdiæter",null,0,0,"=",{"$f":"E51*F51","v":0},"kr."]
[null,null,"Timepenge/felttillæg",null,0,0,"=",{"$f":"E52*F52","v":0},"kr."]
[null,null,"Diæter og timepenge i alt",null,null,null,null,{"$f":"SUM(H50:H52)","v":0},"kr."]
[]
["IV. Øvrige udgifter"]
[null,"1.","Maskinkraft",null,"Antal timer","á kr."]
[null,null,"Afrømning",null,0,0,"=",{"$f":"E57*F57","v":0},"kr."]
[null,null,"Tildækning (f.eks. 50 % af afrømning)",null,0,0,"=",{"$f":"E58*F58","v":0},"kr."]
[null,null,"Transport",null,0,0,"=",{"$f":"E59*F59","v":0},"kr."]
[null,null,"Maskinkraft i alt",null,null,null,null,{"$f":"SUM(H57:H59)","v":0},"kr."]
[]
[null,"2.","Skurvogn og lign.",null,"Antal","á kr."]
[null,null,"Leje inkl. Drift",null,0,0,"=",{"$f":"E63*F63","v":0},"kr."]
[null,null,"Transport",null,0,0,"=",{"$f":"E64*F64","v":0},"kr."]
[null,null,"Skurvogn inkl. transport i alt ",null,null,null,null,{"$f":"H63+H64","v":0},"kr."]
[]
[null,"3.","Materialer og særligt udstyr",null,"Antal","á kr."]
[null,null,{"$f":"'3. Budget'!C64","v":"Opmålingsudstyr"},null,0,0,"=",{"$f":"E68*F68","v":0},"kr."]
[null,null,{"$f":"'3. Budget'!C65","v":"Sold"},null,0,0,"=",{"$f":"E69*F69","v":0},"kr."]
[null,null,{"$f":"'3. Budget'!C66","v":"El, vand, brændstof, pumper eller lign."},null,0,0,"=",{"$f":"E70*F70","v":0},"kr."]
[null,null,{"$f":"'3. Budget'!C67","v":"…"},null,0,0,"=",{"$f":"E71*F71","v":0},"kr."]
[null,null,{"$f":"'3. Budget'!C68","v":"…"},null,0,0,"=",{"$f":"E72*F72","v":0},"kr."]
[null,null,"Materialer og særligt udstyr i alt",null,null,null,null,{"$f":"SUM(H68:H72)","v":0},"kr."]
[]
["V. Uforudsete udgifter"]
[null,"1.","Uforudsete udgifter"]
[null,null,null,null,null,{"$f":"'3. Budget'!F73","v":0.1},"=",0,"kr."]
[null,null,"Uforudsete udgifter i alt",null,null,null,null,{"$f":"SUM(H77)","v":0},"kr."]
[]
["VI. Udgifter til vinterforanstaltninger"]
[]
[null,"1.","Udgifter til vinterforanstaltninger",null,"Antal","á kr."]
[null,null,{"$f":"'3. Budget'!C88","v":"…"},null,0,0,"=",{"$f":"E83*F83","v":0},"kr."]
[null,null,{"$f":"'3. Budget'!C89","v":"…"},null,0,0,"=",{"$f":"E84*F84","v":0},"kr."]
[null,null,{"$f":"'3. Budget'!C90","v":"…"},null,0,0,"=",{"$f":"E85*F85","v":0},"kr."]
[null,null,{"$f":"'3. Budget'!C91","v":"…"},null,0,0,"=",{"$f":"E86*F86","v":0},"kr."]
[null,null,{"$f":"'3. Budget'!C92","v":"…"},null,0,0,"=",{"$f":"E87*F87","v":0},"kr."]
[null,null,"Udgifter til vinterforanstaltninger i alt",null,null,null,null,{"$f":"SUM(H83:H87)","v":0},"kr."]
[]
[]
["Udgifter i alt eksklusiv moms",null,null,null,null,null,"=",{"$f":"H24+H29+H35+H41+H53+H60+H65+H73+H47+H78+H88","v":0},"kr."]
[]
[null,null,"moms",null,null,null,"=",{"$f":"H91*0.25","v":0},"kr."]
["Udgifter i alt inklusiv moms",null,null,null,null,null,"=",{"$f":"SUM(H91,H93)","v":0},"kr."]
[null,null,null,null,null,null,null,{"$f":"IFERROR(H105/H5,\"0\")","v":"0"},"kr/m²"]
[]
["VII. Værdi af faciliteter stillet til rådighed af bygherre"]
[]
[null,"1.","Bygherreudgifter",null,null,"á kr. inkl moms"]
[null,null,"…",null,0,0,"=",{"$f":"E100*F100","v":0},"kr."]
[null,null,"…",null,0,0,"=",{"$f":"E101*F101","v":0},"kr."]
[null,null,"…",null,0,0,"=",{"$f":"E102*F102","v":0},"kr."]
[null,null,"Bygherreudgifter i alt",null,null,null,null,{"$f":"SUM(H100:H102)","v":0},"kr."]
[]
["Samlede udgifter inkl. værdi af faciliteter stillet til rådighed",null,null,null,null,null,"=",{"$f":"SUM(H94,H88,H103)","v":0},"kr."]
[]
[]
["Opgørelse af delregnskaber"]
[null,null,null,null,"Dato","á kr. inkl moms"]
[null,null,"Delfaktura 1, acontobeløb opkrævet (dato)",null,null,0,"=",{"$f":"F110","v":0},"kr."]
[null,null,"Delfaktura 2, acontobeløb opkrævet (dato)",null,null,0,"=",{"$f":"F111","v":0},"kr."]
[null,null,"Delfaktura 3, acontobeløb opkrævet (dato)",null,null,0,"=",0,"kr."]
[null,null,"Delfaktura 4, acontobeløb opkrævet (dato)",null,null,0,"=",0,"kr."]
[null,null,"Delfaktura 5, acontobeløb opkrævet (dato)",null,null,0,"=",0,"kr."]
[null,null,"Delfaktura 6, acontobeløb opkrævet (dato)",null,null,0,"=",0,"kr."]
[null,null,"Delfaktura 7, acontobeløb opkrævet (dato)",null,null,0,"=",0,"kr."]
[null,null,"Delfaktura 8, acontobeløb opkrævet (dato)",null,null,0,"=",0,"kr."]
[null,null,"Delfaktura 9, acontobeløb opkrævet (dato)",null,null,0,"=",0,"kr."]
[null,null,"Delfaktura 10, acontobeløb opkrævet (dato)",null,null,0,"=",0,"kr."]
[null,null,"Delfaktura 11, acontobeløb opkrævet (dato)",null,null,0,"=",{"$f":"F120","v":0},"kr."]
[null,null,"Delfaktura 12, acontobeløb opkrævet (dato)",null,null,0,"=",{"$f":"F121","v":0},"kr."]
[null,null,"Delfaktura 13, acontobeløb opkrævet (dato)",null,null,0,"=",0,"kr."]
[null,null,"Delfaktura 14, acontobeløb opkrævet (dato)",null,null,0,"=",0,"kr."]
[null,null,"Delfaktura 15, acontobeløb opkrævet (dato)",null,null,0,"=",0,"kr."]
[null,null,"Delfaktura 16, acontobeløb opkrævet (dato)",null,null,0,"=",0,"kr."]
[null,null,"Delfaktura 17, acontobeløb opkrævet (dato)",null,null,0,"=",0,"kr."]
[null,null,"Delfaktura 18, acontobeløb opkrævet (dato)",null,null,0,"=",0,"kr."]
[null,null,"Delfaktura 19, acontobeløb opkrævet (dato)",null,null,0,"=",0,"kr."]
[null,null,"Delfaktura 20, acontobeløb opkrævet (dato)",null,null,0,"=",0,"kr."]
["Udgifter opkrævet til dato inkl. moms",null,null,null,null,null,"=",{"$f":"SUM(H110:H129)","v":0},"kr."]
[]
["Maksimal faktura til bygherre",null,null,null,null,null,null,{"$f":"IF(H105>F137,(F137-H103),(H94))","v":0},"kr."]
[]
["Anmodning om aktivering af bygherretilskud"]
[null,null,null,null,null,"á kr."]
[null,null,"Samlede udgifter inkl. moms",null,null,null,"=",{"$f":"H94","v":0},"kr."]
[null,null,"Godkendt maksimal bygherreudgift inkl. moms",null,null,0,"=",{"$f":"F137","v":0},"kr."]
[null,null,"Tilsagn om tilskud op til",null,null,0,"=",{"$f":"F138","v":0},"kr."]
[null,null,"Udbetales til museet",null,null,null,"=",{"$f":"MAX(IF(H105>SUM(F137:F138),(F138),(H105-F137)),0)","v":0},"kr."]
[null,null,"Museets egenandel",null,null,null,"=",{"$f":"MAX(H105-SUM(H137:H138),0)","v":0},"kr."]

{"sheet":"5. Redegørelse","index":4,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,"REGNSKABSREDEGØRELSE"]
[null,null,null,"Budget","Regnskab","Diskrepans"]
[null,"Areal:",null,{"$f":"'2. Stamoplysninger'!E16","v":0},{"$f":"'4. Regnskab'!H5","v":0},{"$f":"D4-E4","v":0},null,{"$f":"IF(OR(E4>D4*1.1,E4<D4*0.9),\"Vær opmærksom på, at arealet afviger mere end 10 %\",\"Ok\")","v":"Ok"}]
[]
[null,"Dækningsgrad",null,{"$f":"'2. Stamoplysninger'!E17","v":0.2},{"$f":"'4. Regnskab'!H7","v":0},{"$f":"D6-E6","v":0.2},null,{"$f":"IF(OR(E6>D6*1.1,E6<D6*0.9),\"Vær opmærksom på, at dækningsgraden afviger\",\"Ok\")","v":"Vær opmærksom på, at dækningsgraden afviger"}]
[]
[null,"I.  Feltarbejde",null,{"$f":"SUM(Felttimesum,Specialister)","v":0},{"$f":"SUM('4. Regnskab'!H24,'4. Regnskab'!H29)","v":0},{"$f":"D8-E8","v":0},null,{"$f":"IF(OR(SUM('4. Regnskab'!H24,'4. Regnskab'!H29)>SUM('3. Budget'!H20,'3. Budget'!H25)*1.2,SUM('4. Regnskab'!H24,'4. Regnskab'!H29)<SUM('3. Budget'!H20,'3. Budget'!H25)*0.8),\"Vær opmærksom på, at  afvigelsen overstiger 20%\",\"Ok\")","v":"Ok"}]
[]
[null,"II. Dokumentation og tilgængeliggørelse",null,{"$f":"Rapport","v":0},{"$f":"'4. Regnskab'!H35","v":0},{"$f":"D10-E10","v":0},null,{"$f":"IF(OR('4. Regnskab'!H35>Rapport*1.2,'4. Regnskab'!H35<Rapport*0.8),\"Vær opmærksom på, at  afvigelsen overstiger 20%\",\"Ok\")","v":"Ok"}]
[]
[null,"III.  Personale- og transportudgifter",null,{"$f":"SUM(Transport_PersonaleKm,Kørsel,DiætTimepege)","v":0},{"$f":"SUM('4. Regnskab'!H41+'4. Regnskab'!H47+'4. Regnskab'!H53)","v":0},{"$f":"D12-E12","v":0},null,{"$f":"IF(OR(SUM('4. Regnskab'!H41,'4. Regnskab'!H47,'4. Regnskab'!H53)>SUM('3. Budget'!H37,'3. Budget'!H44,'3. Budget'!H43,'3. Budget'!H44,'3. Budget'!H49)*1.2,SUM('4. Regnskab'!H41,'4. Regnskab'!H47,'4. Regnskab'!H53)<SUM('3. Budget'!H37,'3. Budget'!H43,'3. Budget'!H49)*0.8),\"Vær opmærksom på, at  afvigelsen overstiger 20%\",\"Ok\")","v":"Ok"}]
[]
[null,"IV. Øvrige udgifter",null,{"$f":"SUM(Maskinkraft,Skurvogn,'3. Budget'!H69)","v":0},{"$f":"SUM('4. Regnskab'!H60,'4. Regnskab'!H65,'4. Regnskab'!H73)","v":0},{"$f":"D14-E14","v":0},null,{"$f":"IF(OR(SUM('4. Regnskab'!H60,'4. Regnskab'!H65,'4. Regnskab'!H73)>SUM('3. Budget'!H56,'3. Budget'!H61,'3. Budget'!H69)*1.2,SUM('4. Regnskab'!H60,'4. Regnskab'!H65,'4. Regnskab'!H73)<SUM('3. Budget'!H56,'3. Budget'!H61,'3. Budget'!H69)*0.8),\"Vær opmærksom på, at  afvigelsen overstiger 20%\",\"Ok\")","v":"Ok"}]
[]
[null,"V. Uforudsete udgifter",null,{"$f":"Diverse","v":0},{"$f":"'4. Regnskab'!H78","v":0},{"$f":"D16-E16","v":0},null,{"$f":"IF('4. Regnskab'!H78>0,\"Er der godkendt forbrug af denne budgetpost?\",\"Ok\")","v":"Ok"}]
[]
[null,"VI. Udgifter til vinterforanstaltninger",null,{"$f":"'3. Budget'!H93","v":0},{"$f":"'4. Regnskab'!H88","v":0},{"$f":"D18-E18","v":0},null,{"$f":"IF(E18>0,\"Er der godkendt forbrug af denne budgetpost?\",\"Ok\")","v":"Ok"}]
[]
[null,"VI. Værdi af faciliteter stillet til rådighed af bygherre",null,0,{"$f":"'4. Regnskab'!H103","v":0},{"$f":"D20-E20","v":0},null,{"$f":"IF('4. Regnskab'!H103>SUM('3. Budget'!H56,'3. Budget'!H61,'3. Budget'!H69)-SUM('4. Regnskab'!H60,'4. Regnskab'!H65,'4. Regnskab'!H73),\"Beløb overstiger budgetpost IV. Øvrige udgifter\",\"Ok\")","v":"Ok"}]
[]
[null,"Sum ekskl. vinter, inkl. moms",null,{"$f":"'3. Budget'!H81","v":0},{"$f":"'4. Regnskab'!H105-('4. Regnskab'!H88*1.25)","v":0},{"$f":"D22-E22","v":0},null,{"$f":"IF(OR('4. Regnskab'!H105>'3. Budget'!H98,'4. Regnskab'!H105<'3. Budget'!H98*0.8),\"Afvigelse, udfyld skema!\",\"Ok\")","v":"Ok"}]
[]
[null,"Afvigelsesforklaring:",null,null,null,null,null,{"$f":"IF('4. Regnskab'!H9=\"Ja\",\"NB! Husk at vedhæfte dokumentation for aftale om endelig afregning med efterfølgende beretningsskrivning.\",\"\")","v":""}]

{"sheet":"6. Statusrapport","index":5,"n_rows":77,"n_cols":5,"rows_kept":77,"cut":false,"hidden":false,"merged":[[3,3,4,8]]}
[null,null,null,{"$f":"IF(D13=\"Museet har akut behov for styrelsens stillingtagen (Svar ønskes inden for 7 hverdage)\",\"HASTER!\",\"\")","v":""}]
["STATUSRAPPORT, FORUNDERSØGELSE"]
[{"$f":"'3. Budget'!A2","v":" "}]
[{"$f":"'2. Stamoplysninger'!E11","v":"Vælg"}]
["Museet j. nr. ",null,{"$f":"'2. Stamoplysninger'!E10","v":" "}]
["Sted- lok. nr.",null,{"$f":"'2. Stamoplysninger'!$E$8","v":" "}]
["SLKS j. nr.",null,{"$f":"'2. Stamoplysninger'!E13","v":" "}]
["System nr.",null,{"$f":"'2. Stamoplysninger'!E5","v":" "}]
[null,null," "]
["Bygherre:",null,{"$f":"IF('2. Stamoplysninger'!E27>0,'2. Stamoplysninger'!E27,'2. Stamoplysninger'!E29)","v":" "},"Årsag til fremsendelse (udfyld her)"]
[null,null,{"$f":"'2. Stamoplysninger'!E32","v":" "},"Vælg","˅"]
[null,null,{"$f":"'2. Stamoplysninger'!E33","v":" "}]
["Godkendt budget inkl. moms",null,null,"Vælg","˅"]
[null,null,{"$f":"'3. Budget'!H81","v":0}]
[]
[null,"Begrundelse ved hasteanmodning"]
[]
[]
[]
[]
[]
[null,"Fremdrift og frigivelser"]
[null,null,{"$f":"IF(#REF!=\"Museet har akut behov for styrelsens stillingtagen i denne sag (inden for 7 hverdag)\",\"HASTER!\",\"\")","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Undersøgelsens foreløbige resultater og videre prioritering"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NB! Kortbilag skal vedhæftes ved fremsendelse af mail."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NB! Kortbilag skal vedhæftes ved fremsendelse af mail."]

{"sheet":"7.Delbudget (bilag)","index":6,"n_rows":75,"n_cols":9,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["BILAG TIL UNDERSØGELSE - DELBUDGET",null,null,null,null,null,null,1]
[{"$f":"'2. Stamoplysninger'!E7","v":" "}]
[{"$f":"'2. Stamoplysninger'!E11","v":"Vælg"}]
["Museet j. nr. ",null,{"$f":"'2. Stamoplysninger'!E10","v":" "}]
["Sted- lok. nr.",null,{"$f":"'2. Stamoplysninger'!E8","v":" "}]
["SLKS j. nr.",null,{"$f":"'2. Stamoplysninger'!E13","v":" "}]
[null,null," "]
["Bygherre:",null,{"$f":"IF('2. Stamoplysninger'!E27>0,'2. Stamoplysninger'!E27,'2. Stamoplysninger'!E29)","v":" "}]
[null,null,{"$f":"'2. Stamoplysninger'!E31","v":" "}]
[null,null,{"$f":"'2. Stamoplysninger'!E32","v":" "},null,null,"Delbudget vedrører",null,0,"m²"]
[]
["I.  Feltarbejde",null,null,null,"(udfyld her)","(udfyld her)"]
[null,"1.","Felttimer",null,"Antal","á kr."]
[null,null,"Ansvarlig udgravningsleder",null,0,0,"=",{"$f":"E14*F14","v":0},"kr."]
[null,null,"Daglig udgravningsleder",null,0,0,"=",{"$f":"E15*F15","v":0},"kr."]
[null,null,"Akademisk medarbejder",null,0,0,"=",0,"kr."]
[null,null,"Studentermedhjælper",null,0,0,"=",0,"kr."]
[null,null,"Museumstekniker",null,0,0,"=",{"$f":"E18*F18","v":0},"kr."]
[null,null,"Arbejdsmand",null,0,0,"=",{"$f":"E19*F19","v":0},"kr."]
[null,null,"Felttimesum i alt",null,null,null,null,{"$f":"SUM(H14:H19)","v":0},"kr."]
[]
[null,"2.","Eksterne specialister",null,"Antal","á kr."]
[null,null,"Specialist",null,0,0,"=",{"$f":"E23*F23","v":0},"kr."]
[null,null,"Landmåler",null,0,0,"=",{"$f":"E24*F24","v":0},"kr."]
[null,null,"Øvrigt feltarbejde i alt",null,null,null,null,{"$f":"SUM(H23:H24)","v":0},"kr."]
[]
["II. Dokumentation og tilgængeliggørelse"]
[null,"1.","Arkæologisk beretning og kulturhistorisk rapport mv. anføres på hovedbudget."]
[]
["III.  Personale- og transportudgifter"]
[null,"1.","Transport",null,"Km","á kr."]
[null,null,"Kørselsgodtgørelse",null,0,0,"=",{"$f":"E32*F32","v":0},"kr."]
[null,null,"Rejsegodtgørelse",null,0,0,"=",{"$f":"E33*F33","v":0},"kr."]
[null,null,"Transport i alt",null,null,null,null,{"$f":"SUM(H32:H33)","v":0},"kr."]
[]
[null,"2.","kørsel",null,"Km","á kr."]
[null,null,"Kørsel i museets/privatbil",null,0,0,"=",{"$f":"E37*F37","v":0},"kr."]
[null,null,"Lejet bil",null,0,0,"=",{"$f":"E38*F38","v":0},"kr."]
[null,null,"Transport til arbejdsplads (arbejdstid)",null,0,0,"=",0,"kr."]
[null,null,"Kørsel i alt",null,null,null,null,{"$f":"SUM(H37:H39)","v":0},"kr."]
[]
[null,"3.","Diæter og timepenge",null,"Antal dage","á kr."]
[null,null,"Dagdiæter",null,0,0,"=",{"$f":"E43*F43","v":0},"kr."]
[null,null,"Natdiæter",null,0,0,"=",{"$f":"E44*F44","v":0},"kr."]
[null,null,"Timepenge/felttillæg",null,0,0,"=",0,"kr."]
[null,null,"Diæter og timepenge i alt",null,null,null,null,{"$f":"SUM(H43:H45)","v":0},"kr."]
[]
["IV. Øvrige udgifter"]
[null,"1.","Maskinkraft",null,"Antal timer","á kr."]
[null,null,"Afrømning",null,0,0,"=",{"$f":"E50*F50","v":0},"kr."]
[null,null,"Tildækning",null,0,0,"=",{"$f":"E51*F51","v":0},"kr."]
[null,null,"Transport",null,0,0,"=",0,"kr."]
[null,null,"Maskinkraft i alt",null,null,null,null,{"$f":"SUM(H50:H52)","v":0},"kr."]
[]
[null,"2.","Skurvogn og lign.",null,"Antal","á kr."]
[null,null,"Leje pr. dag",null,0,0,"=",{"$f":"E56*F56","v":0},"kr."]
[null,null,"Transport",null,0,0,"=",{"$f":"E57*F57","v":0},"kr."]
[null,null,"Skurvogn inkl. transport i alt ",null,null,null,null,{"$f":"SUM(H56:H57)","v":0},"kr."]
[]
[null,"3.","Materialer og særligt udstyr",null,"Antal","á kr."]
[null,null,"Opmålingsudstyr",null,0,0,"=",{"$f":"E61*F61","v":0},"kr."]
[null,null,"Sold",null,0,0,"=",{"$f":"E62*F62","v":0},"kr."]
[null,null,"El, vand, brændstof, pumper eller lign.",null,0,0,"=",0,"kr."]
[null,null,"…",null,0,0,"=",0,"kr."]
[null,null,"…",null,0,0,"=",0,"kr."]
[null,null,"…",null,0,0,"=",0,"kr."]
[null,null,"…",null,0,0,"=",0,"kr."]
[null,null,"Materialer og særligt udstyr i alt",null,null,null,null,{"$f":"SUM(H61:H67)","v":0},"kr."]
[]
["V. Uforudsete udgifter"]
[null,"1.","Uforudsete udgifter anføres på hovedbudget."]
[]
[]
["Udgifter i alt eksklusiv moms",null,null,null,null,null,"=",{"$f":"H68+H58+H53+H46+H40+H34+H25+H20","v":0},"kr."]
[null,null,null,null,null,null,null,{"$f":"IFERROR(H10/H74,\"0\")","v":"0"},{"$f":"IF(I10=\"m²\",\"kr/m²\",\"kr/m³\")","v":"kr/m²"}]

{"sheet":"Data","index":7,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Bygherretype","Anlægsarbejdets karakter","Landskab","Kulturarvsareal","Årsag til fremsendelse af statusskema","Ønske om dialog"]
["Vælg","Vælg","Vælg","Vælg","Vælg","Vælg"]
["Privat virksomhed f.eks. A/S, ApS, I/S, landbrug (med CVR nr.)","Andet, se faglig argumentation","Åbent land","Nej","Væsenligt ændret arkæologisk potentiale","Undersøgelsen forløber som planlagt (Se beskrivelse nedenfor)"]
["Privat person (uden CVR nr.)","Anlægsarbejde, andet","Bebygget areal","Regional betydning","Aktivering af vinterforanstaltninger","Museet anmoder om styrelsens vurdering (Svar ønskes)"]
["Offentlig, Stat","Anlægsarbejde, byggeri","Middelalderbykerne","National betydning","50 % fremdrift af feltarbejde (Budget på mellem  500.000 og 3.000.000 kr. inkl. moms)","Museet har akut behov for styrelsens stillingtagen (Svar ønskes inden for 7 hverdage)"]
["Offentlig, Region","Anlægsarbejde, byggemodning","Mose, vådområder el. lign","International betydning","25 % fremdrift af feltarbejde (Budget på mellem 3.000.000 og 10.000.000 kr. inkl. moms)"]
["Offentlig, Kommune","Anlægsarbejde, vej","Skov","Tidligere udpeget in situ areal","50 % fremdrift af feltarbejde (Budget på mellem 3.000.000 og 10.000.000 kr. inkl. moms)"]
["Offentlig, Kommunal virksomhed","Anlægsarbejde, tracé","Andet, se faglig argumentation",null,"75 % fremdrift af feltarbejde (Budget på mellem 3.000.000 og 10.000.000 kr. inkl. moms)"]
["Museet er selv bygherre","Dyrkning",null,null,"Sag med budgetbeløb på over 10.000.000 inkl. moms, afrapportering efter særaftale"]
[null,"Erosion",null,null,"Årlig statusrapport"]
[null,"Læhegn"]
[null,"Naturgenopretning"]
[null,"Råstofindvinding"]
[null,"Salg af jord"]
[null,"Skovrejsning"]
[null,"Skovrejsning, med tilskud"]

{"sheet":"Logoer","index":8,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["MuseumsLogo","Museum","Logo_ref"]
[null,"Vælg","Logoer!a2"]
[null,"ARKVEST, Arkæologi Vestjylland","Logoer!a3"]
[null,"Arkæologi Sydfyn, Langelands Museum","Logoer!a4",null,null,null,null,null,{"$f":"VLOOKUP('2. Stamoplysninger'!E11,$B$2:$C$34,2,FALSE)","v":"Logoer!a2"}]
[null,"Arkæologi Sydfyn, Svendborg Museum","Logoer!a5",null,null,null,null,null,{"$f":"VLOOKUP(H5,$B$2:$C$34,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Arkæologi Sydfyn, Øhavsmuseet Faaborg","Logoer!a6"]
[null,"Arkæologi Sydfyn, Østfyns Museer","Logoer!a7"]
[null,"Bornholms Museum","Logoer!a8"]
[null,"De Kulturhistoriske Museer i Holstebro","Logoer!a9"]
[null,"Horsens Museum","Logoer!a10"]
[null,"Kroppedal Museum","Logoer!a11"]
[null,"Københavns Museum","Logoer!a12"]
[null,"MOMU, Moesgaard Museum","Logoer!a13"]
[null,"Museet på Koldinghus","Logoer!a14"]
[null,"Museet på Sønderskov","Logoer!a15"]
[null,"Museum Lolland Falster","Logoer!a16"]
[null,"Museum Midtjylland","Logoer!a17"]
[null,"Museum Nordsjælland","Logoer!a18"]
[null,"Museum Salling","Logoer!a19"]
[null,"Museum Silkeborg","Logoer!a20"]
[null,"Museum Skanderborg","Logoer!a21"]
[null,"Museum Sydøstdanmark","Logoer!a22"]
[null,"Museum Sønderjylland","Logoer!a23"]
[null,"Museum Thy","Logoer!a24"]
[null,"Museum Vestsjælland","Logoer!a25"]
[null,"Museum Østjylland","Logoer!a26"]
[null,"Nordjyllands Historiske Museum","Logoer!a27"]
[null,"Odense Bys Museer","Logoer!a28"]
[null,"ROMU, Roskilde Museum","Logoer!a29"]
[null,"Sydvestjyske Museer","Logoer!a30"]
[null,"Vejle Museerne","Logoer!a31"]
[null,"Vendsyssel Historiske Museum","Logoer!a32"]
[null,"Vesthimmerlands Museum","Logoer!a33"]
[null,"Viborg Museum","Logoer!a34"]