<?xml version="1.0"?> <?mso-application progid="Excel.Sheet"?> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"> <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> <Author>Anne Karin Kringberg</Author> <% if user? %> <LastAuthor><%=user.first_name%> <%=user.last_name%></LastAuthor> <% end %> <LastPrinted>2005-11-14T13:31:53Z</LastPrinted> <Created>2005-02-24T11:55:19Z</Created> <LastSaved><%=Time.now.iso8601%></LastSaved> <Version>11.5606</Version> </DocumentProperties> <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> <WindowHeight>9075</WindowHeight> <WindowWidth>12390</WindowWidth> <WindowTopX>90</WindowTopX> <WindowTopY>45</WindowTopY> <ProtectStructure>False</ProtectStructure> <ProtectWindows>False</ProtectWindows> </ExcelWorkbook> <Styles> <Style ss:ID="Default" ss:Name="Normal"> <Alignment ss:Vertical="Bottom"/> <Borders/> <Font/> <Interior/> <NumberFormat/> <Protection/> </Style> <Style ss:ID="m151663000"> <Alignment ss:Vertical="Bottom"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="m151663010"> <Alignment ss:Vertical="Bottom"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/> </Borders> <Font x:Family="Swiss" ss:Bold="1"/> </Style> <Style ss:ID="m151663020"> <Alignment ss:Vertical="Bottom"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="m151663030"> <Alignment ss:Vertical="Bottom"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="m151663040"> <Alignment ss:Vertical="Bottom"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/> </Borders> </Style> <Style ss:ID="s23"> <Font x:Family="Swiss" ss:Size="14" ss:Bold="1"/> </Style> <Style ss:ID="s24"> <Alignment ss:Horizontal="Center"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="s25"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="s26"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="s27"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="s28"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/> </Borders> </Style> <Style ss:ID="s29"> <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/> </Borders> </Style> <Style ss:ID="s30"> <Borders/> </Style> <Style ss:ID="s31"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/> </Borders> <Font x:Family="Swiss" ss:Bold="1"/> </Style> <Style ss:ID="s32"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> </Borders> </Style> <Style ss:ID="s33"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> </Borders> </Style> <Style ss:ID="s34"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/> </Borders> </Style> <Style ss:ID="s35"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/> </Borders> <Font x:Family="Swiss" ss:Bold="1"/> </Style> <Style ss:ID="s36"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/> </Borders> <Font x:Family="Swiss" ss:Bold="1"/> </Style> <Style ss:ID="s37"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/> </Borders> <Font x:Family="Swiss" ss:Bold="1"/> </Style> <Style ss:ID="s38"> <Borders> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="s39"> <Borders> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="s40"> <Borders> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="s41"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/> </Borders> <Font x:Family="Swiss" ss:Size="12" ss:Bold="1"/> </Style> <Style ss:ID="s42"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/> </Borders> <Font x:Family="Swiss" ss:Size="12" ss:Bold="1"/> </Style> <Style ss:ID="s43"> <Font x:Family="Swiss" ss:Size="16" ss:Bold="1"/> </Style> <Style ss:ID="s44"> <Borders/> <Font x:Family="Swiss" ss:Size="14" ss:Bold="1"/> </Style> <Style ss:ID="s45"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/> </Borders> </Style> <Style ss:ID="s46"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/> </Borders> </Style> <Style ss:ID="s47"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/> </Borders> </Style> <Style ss:ID="s48"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/> </Borders> <Font x:Family="Swiss" ss:Bold="1"/> </Style> <Style ss:ID="s49"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/> </Borders> <Font x:Family="Swiss" ss:Bold="1"/> </Style> <Style ss:ID="s50"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/> </Borders> <Font x:Family="Swiss" ss:Bold="1"/> </Style> <Style ss:ID="s51"> <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="s52"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="s53"> <Borders> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/> </Borders> </Style> <Style ss:ID="s54"> <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="s55"> <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="s56"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/> </Borders> </Style> <Style ss:ID="s57"> <Borders> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/> </Borders> <Interior/> </Style> <Style ss:ID="s58"> <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> </Borders> </Style> <Style ss:ID="s59"> <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> <Borders> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="s68"> <Alignment ss:Vertical="Bottom"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/> </Borders> <Font x:Family="Swiss" ss:Bold="1"/> </Style> <Style ss:ID="s69"> <Alignment ss:Vertical="Bottom"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> </Borders> </Style> <Style ss:ID="s70"> <Alignment ss:Vertical="Bottom"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="s71"> <Alignment ss:Vertical="Bottom"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> </Styles> <Worksheet ss:Name="Timeliste prosjekt"> <Table ss:ExpandedColumnCount="256" ss:ExpandedRowCount="35" x:FullColumns="1" x:FullRows="1"> <Column ss:AutoFitWidth="0" ss:Width="38.25"/> <Column ss:AutoFitWidth="0" ss:Width="96"/> <Column ss:AutoFitWidth="0" ss:Width="23.25"/> <Column ss:AutoFitWidth="0" ss:Width="21" ss:Span="1"/> <Column ss:Index="6" ss:AutoFitWidth="0" ss:Width="24.75"/> <Column ss:AutoFitWidth="0" ss:Width="45.75" ss:Span="6"/> <Column ss:Index="14" ss:AutoFitWidth="0" ss:Width="157.5"/> <Column ss:AutoFitWidth="0" ss:Width="60" ss:Span="241"/> <Row ss:Index="2" ss:Height="18"> <Cell ss:StyleID="s23"><Data ss:Type="String">TIMELISTER PROSJEKT</Data></Cell> </Row> <Row ss:AutoFitHeight="0" ss:Height="6.5625"/> <Row ss:AutoFitHeight="0" ss:Height="19.125"> <Cell ss:StyleID="s31"><Data ss:Type="String">Uke :</Data></Cell> <Cell ss:StyleID="s29"><Data ss:Type="Number"><%=@week%></Data></Cell> <Cell ss:StyleID="s30"/> <Cell ss:Index="11" ss:StyleID="s28"><Data ss:Type="String">Sign. ansatt :</Data></Cell> <Cell ss:StyleID="s28"/> <Cell ss:StyleID="s28"/> <Cell ss:StyleID="s28"/> </Row> <Row ss:AutoFitHeight="0" ss:Height="21.5625"> <Cell ss:StyleID="s31"><Data ss:Type="String">Ansatt :</Data></Cell> <Cell ss:StyleID="s28"><% if user? %><Data ss:Type="String"><%=user.first_name%> <%=user.last_name%></Data><% end %></Cell> <Cell ss:StyleID="s28"/> <Cell ss:StyleID="s28"/> <Cell ss:StyleID="s28"/> <Cell ss:StyleID="s28"/> <Cell ss:StyleID="s28"/> <Cell ss:Index="11" ss:StyleID="s56"><Data ss:Type="String">Sign. avdelingsleder:</Data></Cell> <Cell ss:StyleID="s56"/> <Cell ss:StyleID="s56"/> <Cell ss:StyleID="s56"/> </Row> <Row ss:Height="14.25"/> <Row ss:AutoFitHeight="0" ss:Height="19.875"> <Cell ss:StyleID="s35"><Data ss:Type="String">Pnr.</Data><Comment ss:Author="Anne Karin Kringberg"><ss:Data xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma" html:Size="8" html:Color="#000000">Anne Karin Kringberg:</Font></B><Font html:Face="Tahoma" html:Size="8" html:Color="#000000"> Prosjektnr. </Font></ss:Data></Comment></Cell> <Cell ss:StyleID="s36"><Data ss:Type="String">Kunde</Data></Cell> <Cell ss:StyleID="s36"><Data ss:Type="String">Fakt.</Data><Comment ss:Author="Anne Karin Kringberg"><ss:Data xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma" html:Size="8" html:Color="#000000">Anne Karin Kringberg:</Font></B><Font html:Face="Tahoma" html:Size="8" html:Color="#000000"> Fakturerbart </Font></ss:Data></Comment></Cell> <Cell ss:StyleID="s36"><Data ss:Type="String">Int.</Data><Comment ss:Author="Anne Karin Kringberg"><ss:Data xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma" html:Size="8" html:Color="#000000">Anne Karin Kringberg:</Font></B><Font html:Face="Tahoma" html:Size="8" html:Color="#000000"> Internt </Font></ss:Data></Comment></Cell> <Cell ss:StyleID="s36"><Data ss:Type="String">Syk</Data></Cell> <Cell ss:StyleID="s36"><Data ss:Type="String">Ferie</Data></Cell> <Cell ss:StyleID="s36"><Data ss:Type="String">Mandag</Data></Cell> <Cell ss:StyleID="s36"><Data ss:Type="String">Tirsdag</Data></Cell> <Cell ss:StyleID="s36"><Data ss:Type="String">Onsdag</Data></Cell> <Cell ss:StyleID="s36"><Data ss:Type="String">Torsdag</Data></Cell> <Cell ss:StyleID="s36"><Data ss:Type="String">Fredag</Data></Cell> <Cell ss:StyleID="s36"><Data ss:Type="String">Lørdag</Data></Cell> <Cell ss:StyleID="s36"><Data ss:Type="String">Søndag</Data></Cell> <Cell ss:StyleID="s37"><Data ss:Type="String">Merknad</Data></Cell> </Row> <% for backlog_id in @work_totals_per_backlog.keys %> <% invoice_works_per_day = @work_totals_per_backlog[backlog_id][0]%> <% if invoice_works_per_day.find{|total| total > 0} %> <Row> <Cell ss:StyleID="s24"><Data ss:Type="String"><%=Backlog.find(backlog_id).invoice_code %></Data></Cell> <Cell ss:StyleID="s25"><Data ss:Type="String"><%=Backlog.find(backlog_id).name %></Data></Cell> <Cell ss:StyleID="s25"><Data ss:Type="String"> X</Data></Cell> <Cell ss:StyleID="s25"/> <Cell ss:StyleID="s25"/> <Cell ss:StyleID="s25"/> <% invoice_works_per_day.each do |total| %> <Cell ss:StyleID="s25"><%if total && total > 0%><Data ss:Type="Number"><%=total%></Data><%end%></Cell> <% end %> <Cell ss:StyleID="s26"/> </Row> <% end %> <% internal_works_per_day = @work_totals_per_backlog[backlog_id][1]%> <% if internal_works_per_day.find{|total| total > 0} %> <Row> <Cell ss:StyleID="s24"><Data ss:Type="String"><%=Backlog.find(backlog_id).invoice_code%></Data></Cell> <Cell ss:StyleID="s25"><Data ss:Type="String"><%=Backlog.find(backlog_id).name %></Data></Cell> <Cell ss:StyleID="s25"/> <Cell ss:StyleID="s25"/> <Cell ss:StyleID="s25"/> <Cell ss:StyleID="s25"/> <% internal_works_per_day.each do |total| %> <Cell ss:StyleID="s25"><%if total && total > 0%><Data ss:Type="Number"><%=total%></Data><%end%></Cell> <% end %> <Cell ss:StyleID="s26"/> </Row> <% end %> <% end %> <Row ss:Height="13.5"> <Cell ss:StyleID="s32"/> <Cell ss:StyleID="s33"/> <Cell ss:StyleID="s33"/> <Cell ss:StyleID="s33"/> <Cell ss:StyleID="s33"/> <Cell ss:StyleID="s33"/> <Cell ss:StyleID="s33"/> <Cell ss:StyleID="s33"/> <Cell ss:StyleID="s33"/> <Cell ss:StyleID="s33"/> <Cell ss:StyleID="s33"/> <Cell ss:StyleID="s33"/> <Cell ss:StyleID="s33"/> <Cell ss:StyleID="s34"/> </Row> <Row ss:Height="13.5"> <Cell ss:StyleID="s38"/> <Cell ss:StyleID="s39"/> <Cell ss:StyleID="s39"/> <Cell ss:StyleID="s39"/> <Cell ss:StyleID="s39"/> <Cell ss:StyleID="s39"/> <Cell ss:StyleID="s39"/> <Cell ss:StyleID="s39"/> <Cell ss:StyleID="s39"/> <Cell ss:StyleID="s39"/> <Cell ss:StyleID="s39"/> <Cell ss:StyleID="s39"/> <Cell ss:StyleID="s39"/> <Cell ss:StyleID="s40"/> </Row> <Row ss:Height="13.5"> <Cell ss:StyleID="s45"/> <Cell ss:StyleID="s48"><Data ss:Type="String">Sum timer</Data></Cell> <Cell ss:StyleID="s46"/> <Cell ss:StyleID="s46"/> <Cell ss:StyleID="s46"/> <Cell ss:StyleID="s46"/> <Cell ss:StyleID="s46" ss:Formula="=IF(SUM(R[-<%=@work_totals_per_backlog.size*2+2%>]C:R[-1]C),SUM(R[-<%=@work_totals_per_backlog.size*2+2%>]C:R[-1]C),"")"><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="s46" ss:Formula="=IF(SUM(R[-<%=@work_totals_per_backlog.size*2+2%>]C:R[-1]C),SUM(R[-<%=@work_totals_per_backlog.size*2+2%>]C:R[-1]C),"")"><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="s46" ss:Formula="=IF(SUM(R[-<%=@work_totals_per_backlog.size*2+2%>]C:R[-1]C),SUM(R[-<%=@work_totals_per_backlog.size*2+2%>]C:R[-1]C),"")"><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="s46" ss:Formula="=IF(SUM(R[-<%=@work_totals_per_backlog.size*2+2%>]C:R[-1]C),SUM(R[-<%=@work_totals_per_backlog.size*2+2%>]C:R[-1]C),"")"><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="s46" ss:Formula="=IF(SUM(R[-<%=@work_totals_per_backlog.size*2+2%>]C:R[-1]C),SUM(R[-<%=@work_totals_per_backlog.size*2+2%>]C:R[-1]C),"")"><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="s46" ss:Formula="=IF(SUM(R[-<%=@work_totals_per_backlog.size*2+2%>]C:R[-1]C),SUM(R[-<%=@work_totals_per_backlog.size*2+2%>]C:R[-1]C),"")"><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="s46" ss:Formula="=IF(SUM(R[-<%=@work_totals_per_backlog.size*2+2%>]C:R[-1]C),SUM(R[-<%=@work_totals_per_backlog.size*2+2%>]C:R[-1]C),"")"><Data ss:Type="String"></Data></Cell> <Cell ss:StyleID="s47"/> </Row> <Row> <Cell ss:StyleID="s30"/> <Cell ss:StyleID="s30"/> <Cell ss:StyleID="s30"/> <Cell ss:StyleID="s30"/> <Cell ss:StyleID="s30"/> <Cell ss:StyleID="s30"/> <Cell ss:StyleID="s30"/> <Cell ss:StyleID="s30"/> <Cell ss:StyleID="s30"/> <Cell ss:StyleID="s30"/> <Cell ss:StyleID="s30"/> <Cell ss:StyleID="s30"/> <Cell ss:StyleID="s30"/> <Cell ss:StyleID="s30"/> </Row> <Row ss:Height="18.75" ss:StyleID="s30"> <Cell ss:StyleID="s44"><Data ss:Type="String">Standard prosjekter</Data></Cell> </Row> <Row ss:Height="13.5"> <Cell ss:StyleID="s49"><Data ss:Type="String">P.nr.</Data></Cell> <Cell ss:MergeAcross="4" ss:StyleID="s68"><Data ss:Type="String">Prosjektnavn</Data></Cell> <Cell ss:StyleID="s50"><Data ss:Type="String">P.nr</Data></Cell> <Cell ss:MergeAcross="3" ss:StyleID="s68"><Data ss:Type="String">Prosjektnavn</Data></Cell> <Cell ss:StyleID="s50"><Data ss:Type="String">P.nr.</Data></Cell> <Cell ss:MergeAcross="1" ss:StyleID="m151663010"><Data ss:Type="String">Prosjektnavn</Data></Cell> </Row> <Row ss:Height="13.5"> <Cell ss:StyleID="s51"><Data ss:Type="Number">27</Data></Cell> <Cell ss:MergeAcross="4" ss:StyleID="s69"><Data ss:Type="String">Ikke fakturerbar feilretting for kunde</Data></Cell> <Cell ss:StyleID="s51"><Data ss:Type="Number">31</Data></Cell> <Cell ss:MergeAcross="3" ss:StyleID="s69"><Data ss:Type="String">Ikke fakturerbar videreutvikling, diverse</Data></Cell> <Cell ss:StyleID="s54"><Data ss:Type="Number">43</Data></Cell> <Cell ss:MergeAcross="1" ss:StyleID="m151663020"><Data ss:Type="String">Support modem</Data></Cell> </Row> <Row> <Cell ss:StyleID="s51"><Data ss:Type="Number">28</Data></Cell> <Cell ss:MergeAcross="4" ss:StyleID="s70"><Data ss:Type="String">Ikke fakturerbar support for kunde</Data></Cell> <Cell ss:StyleID="s51"><Data ss:Type="Number">32</Data></Cell> <Cell ss:MergeAcross="3" ss:StyleID="s70"><Data ss:Type="String">Interne oppgaver ikke spesifisert</Data></Cell> <Cell ss:StyleID="s54"><Data ss:Type="Number">46</Data></Cell> <Cell ss:MergeAcross="1" ss:StyleID="m151663030"><Data ss:Type="String">CPAS 5,0 SMS</Data></Cell> </Row> <Row> <Cell ss:StyleID="s51"><Data ss:Type="Number">29</Data></Cell> <Cell ss:MergeAcross="4" ss:StyleID="s70"><Data ss:Type="String">Ikke fakturerbar videreutvikling for kunde</Data></Cell> <Cell ss:StyleID="s51"><Data ss:Type="Number">34</Data></Cell> <Cell ss:MergeAcross="3" ss:StyleID="s70"><Data ss:Type="String">Interne oppgaver spesifisert</Data></Cell> <Cell ss:StyleID="s58"><Data ss:Type="Number">49</Data></Cell> <Cell ss:MergeAcross="1" ss:StyleID="m151663040"><Data ss:Type="String">CPAS 5,0 MMS</Data></Cell> </Row> <Row ss:Height="13.5"> <Cell ss:StyleID="s55"><Data ss:Type="Number">30</Data></Cell> <Cell ss:MergeAcross="4" ss:StyleID="s71"><Data ss:Type="String">Ikke fakturerbar videreutvikling SISS</Data></Cell> <Cell ss:StyleID="s55"><Data ss:Type="Number">35</Data></Cell> <Cell ss:MergeAcross="3" ss:StyleID="s71"><Data ss:Type="String">Fakturerbar support mindre WI kunder</Data></Cell> <Cell ss:StyleID="s55"><Data ss:Type="Number">64</Data></Cell> <Cell ss:MergeAcross="1" ss:StyleID="m151663000"><Data ss:Type="String">CTU</Data></Cell> </Row> <Row ss:Height="13.5"/> </Table> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <PageSetup> <Layout x:Orientation="Landscape"/> </PageSetup> <FitToPage/> <Print> <ValidPrinterInfo/> <PaperSizeIndex>9</PaperSizeIndex> <Scale>97</Scale> <HorizontalResolution>600</HorizontalResolution> <VerticalResolution>600</VerticalResolution> </Print> <Selected/> <Panes> <Pane> <Number>3</Number> <ActiveRow>3</ActiveRow> <ActiveCol>1</ActiveCol> </Pane> </Panes> <ProtectObjects>False</ProtectObjects> <ProtectScenarios>False</ProtectScenarios> </WorksheetOptions> </Worksheet> <Worksheet ss:Name="Prosjektliste"> <Table ss:ExpandedColumnCount="256" ss:ExpandedRowCount="53" x:FullColumns="1" x:FullRows="1"> <Column ss:AutoFitWidth="0" ss:Width="64.5"/> <Column ss:AutoFitWidth="0" ss:Width="328.5"/> <Column ss:AutoFitWidth="0" ss:Width="60" ss:Span="253"/> <Row ss:Index="2" ss:Height="20.25"> <Cell ss:StyleID="s43"><Data ss:Type="String">PROSJEKTLISTE</Data></Cell> </Row> <Row ss:Height="13.5"/> <Row ss:AutoFitHeight="0" ss:Height="23.4375"> <Cell ss:StyleID="s41"><Data ss:Type="String">Prosjektnr.</Data></Cell> <Cell ss:StyleID="s42"><Data ss:Type="String">Prosjektnavn</Data></Cell> </Row> <Row> <Cell ss:StyleID="s24"/> <Cell ss:StyleID="s26"/> <Cell ss:StyleID="s53"/> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">1</Data></Cell> <Cell ss:StyleID="s52"><Data ss:Type="String">Viderefakturering SCR</Data></Cell> <Cell ss:StyleID="s53"/> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">2</Data></Cell> <Cell ss:StyleID="s52"><Data ss:Type="String">NSB Godstrafikk vedlikehold</Data></Cell> <Cell ss:StyleID="s53"/> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">3</Data></Cell> <Cell ss:StyleID="s52"><Data ss:Type="String">NSB Persontrafikk vedlikehold</Data></Cell> <Cell ss:StyleID="s53"/> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">4</Data></Cell> <Cell ss:StyleID="s52"><Data ss:Type="String">NSB Godstrafikk løpende prosjekter</Data></Cell> <Cell ss:StyleID="s53"/> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">5</Data></Cell> <Cell ss:StyleID="s52"><Data ss:Type="String">NSB Persontrafikk løpende prosjekter</Data></Cell> <Cell ss:StyleID="s53"/> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">12</Data></Cell> <Cell ss:StyleID="s52"><Data ss:Type="String">Norsk Tipping</Data></Cell> <Cell ss:StyleID="s30"/> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">13</Data></Cell> <Cell ss:StyleID="s52"><Data ss:Type="String">Norsk Tipping initiell</Data></Cell> <Cell ss:StyleID="s30"/> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">14</Data></Cell> <Cell ss:StyleID="s52"><Data ss:Type="String">Norsk Tipping IBM</Data></Cell> <Cell ss:StyleID="s30"/> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">26</Data></Cell> <Cell ss:StyleID="s52"><Data ss:Type="String">Mobilnet</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">27</Data></Cell> <Cell ss:StyleID="s52"><Data ss:Type="String">Ikke fakturerbar feilretting for kunde</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">28</Data></Cell> <Cell ss:StyleID="s52"><Data ss:Type="String">Ikke fakturerbar support for kunde</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">29</Data></Cell> <Cell ss:StyleID="s52"><Data ss:Type="String">Ikke fakturerbar videreutvikling CPAS</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">30</Data></Cell> <Cell ss:StyleID="s52"><Data ss:Type="String">Ikke fakturerbar videreutvikling SISS</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">31</Data></Cell> <Cell ss:StyleID="s52"><Data ss:Type="String">Ikke fakturerbar videreutvikling diverse</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">34</Data></Cell> <Cell ss:StyleID="s52"><Data ss:Type="String">Interne oppgaver spesifisert</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">35</Data></Cell> <Cell ss:StyleID="s52"><Data ss:Type="String">Fakturerbar support mindre kunder</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">43</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">Support Modem</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">46</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">CPAS 5,0 SMS</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">49</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">CPAS 5,0 MMS</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">52</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">Lysstyring</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">54</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">GoPocket</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">55</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">Mobilnet WAP Plattform</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">56</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">De norske Bokklubbene</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">57</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">NSB SIT MK2</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">58</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">Cargonet Oppgr 2003</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">60</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">Porteringsprosjektet</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">61</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">M2M server</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">62</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">Mesta</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">63</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">GSM-R Pilot</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">64</Data></Cell> <Cell ss:StyleID="s57"><Data ss:Type="String">CTU</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">66</Data></Cell> <Cell ss:StyleID="s57"><Data ss:Type="String">Netcom utvidede takstklasser</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">67</Data></Cell> <Cell ss:StyleID="s57"><Data ss:Type="String">Gateway</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">68</Data></Cell> <Cell ss:StyleID="s57"><Data ss:Type="String">Diverse til lager</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">69</Data></Cell> <Cell ss:StyleID="s57"><Data ss:Type="String">Trådløs bedrift</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">70</Data></Cell> <Cell ss:StyleID="s57"><Data ss:Type="String">Abonnementshåndtering</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">71</Data></Cell> <Cell ss:StyleID="s57"><Data ss:Type="String">Utvikling applikasjoner</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">72</Data></Cell> <Cell ss:StyleID="s57"><Data ss:Type="String">NSB Materiell</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">73</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">JBV kameraovervåkning</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">74</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">Conax, Globacom</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">75</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">Pilot for enhetstracking</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">76</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">CPAS 5.0 WAP</Data></Cell> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">77</Data></Cell> <Cell ss:StyleID="s26"/> </Row> <Row> <Cell ss:StyleID="s54"><Data ss:Type="Number">78</Data></Cell> <Cell ss:StyleID="s26"><Data ss:Type="String">Support WAT</Data></Cell> </Row> <Row> <Cell ss:StyleID="s59"><Data ss:Type="Number">79</Data></Cell> <Cell ss:StyleID="s40"><Data ss:Type="String">M2M Fleet</Data></Cell> </Row> <Row> <Cell ss:StyleID="s59"><Data ss:Type="Number">80</Data></Cell> <Cell ss:StyleID="s40"><Data ss:Type="String">Transportsentralen Lillestrøm</Data></Cell> </Row> <Row> <Cell ss:StyleID="s59"><Data ss:Type="Number">81</Data></Cell> <Cell ss:StyleID="s40"><Data ss:Type="String">GFS</Data></Cell> </Row> <Row ss:Height="13.5"> <Cell ss:StyleID="s55"/> <Cell ss:StyleID="s27"/> </Row> <Row ss:Height="13.5"/> </Table> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <Print> <ValidPrinterInfo/> <PaperSizeIndex>9</PaperSizeIndex> <HorizontalResolution>600</HorizontalResolution> <VerticalResolution>600</VerticalResolution> </Print> <TopRowVisible>3</TopRowVisible> <Panes> <Pane> <Number>3</Number> <ActiveRow>50</ActiveRow> <ActiveCol>1</ActiveCol> </Pane> </Panes> <ProtectObjects>False</ProtectObjects> <ProtectScenarios>False</ProtectScenarios> </WorksheetOptions> </Worksheet> <Worksheet ss:Name="Ark3"> <Table ss:ExpandedColumnCount="256" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1"> <Column ss:AutoFitWidth="0" ss:Width="60" ss:Span="255"/> </Table> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <ProtectObjects>False</ProtectObjects> <ProtectScenarios>False</ProtectScenarios> </WorksheetOptions> </Worksheet> </Workbook>