Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 800
  • Last Modified:

xml error

I am trying to make database fed Excel sheet using an xml file created in php.

I get this error in the log file (in C:\Users\Me\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\):

xml-error in table
reason: erroneous value
file: C:\Users\Me\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\LA076CE4\File_2010-09-04[1].xls
group: Cell
HTML-code: Data
value: B1

xml-error in table
reason: erroneous value
file: C:\Users\Me\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\LA076CE4\File_2010-09-04[1].xls
group: Cell
HTML-code: Data
value: G 12

I don't have a clue what this means. Could anyone, please, explain it for me.
<?php
//error_reporting(E_ALL|E_STRICT); 
//ini_set('display_errors', '1');
date_default_timezone_set('Europe/Paris');
//echo "Upptagningsdag: $_POST[upptagningsdag]<br />Varv: $_POST[varv]";
list($ar,$man,$dag) = preg_split('/-/', $_POST['upptagningsdag']);
$datetime_1 = strtotime( "$man/$dag/$ar" );
$veckodag = date("l", $datetime_1);
//echo "<br />Veckodag: $veckodag<br />";  exit();
$upptagningsdag = $_POST['upptagningsdag'];
			if($veckodag == "Monday") { $veckodag = "M&aring;ndag";  }
			if($veckodag == "Tuesday") { $veckodag = "Tisdag";   }
			if($veckodag == "Wednesday") { $veckodag = "Onsdag";   }
			if($veckodag == "Thursday") { $veckodag = "Torsdag";  }
			if($veckodag == "Friday") { $veckodag = "Fredag";   }
			if($veckodag == "Saturday") { $veckodag = "L&ouml;rdag";   }
			if($veckodag == "Sunday") { $veckodag = "S&ouml;ndag";   }
			$varv = "$_POST[varv]";
	  include "../../dbconfig/dbconfig.php";
	  header("content-type: text/xml");
      header("Pragma: public");
      header("Expires: 0");
      header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
      header("Content-Type: application/force-download");
      header("Content-Type: application/octet-stream");
      header("Content-Type: application/download");;
      header("Content-Disposition: attachment;filename=Upptagning ".$_POST['upptagningsdag'].".xls ");
      header("Content-Transfer-Encoding: binary ");
      print "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n";
      print "<?mso-application progid=\"Excel.Sheet\"?>\n";
     
?>

<ss: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">
 <ss:DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Author>Ericson Productions</Author>
  <LastAuthor>Lennart</LastAuthor>
  <LastPrinted>2009-06-07T19:02:13Z</LastPrinted>
  <Created>2008-03-04T13:29:15Z</Created>
  <LastSaved>2010-03-22T19:48:44Z</LastSaved>
  <Company>Home</Company>
  <Version>12.00</Version>
 </ss:DocumentProperties>
 <ss:ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>2985</WindowHeight>
  <WindowWidth>3540</WindowWidth>
  <WindowTopX>14985</WindowTopX>
  <WindowTopY>2895</WindowTopY>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ss:ExcelWorkbook>
 <ss:Styles>
  <ss:Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="Arial"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </ss:Style>
  <ss:Style ss:ID="s49" ss:Name="Normal_Blad1">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Color="#000000"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </ss:Style>
  <ss:Style ss:ID="m51662112">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </ss:Style>
  <ss:Style ss:ID="m51662132">
   <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="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <NumberFormat ss:Format="Short Time"/>
  </ss:Style>
  <ss:Style ss:ID="m51662152">
   <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="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <NumberFormat ss:Format="Short Time"/>
  </ss:Style>
  
  
    <ss:Style ss:ID="m31465920">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="24" ss:Bold="1"/>
  </ss:Style>
  
  
  
  <ss:Style ss:ID="m51662172">
   <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="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <NumberFormat ss:Format="Short Time"/>
  </ss:Style>
  <ss:Style ss:ID="s63">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
  </ss:Style>
  <ss:Style ss:ID="s64">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <NumberFormat ss:Format="Short Time"/>
  </ss:Style>
  <ss:Style ss:ID="s65">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </ss:Style>
  <ss:Style ss:ID="s66">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </ss:Style>
  <ss:Style ss:ID="s67">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="8"/>
  </ss:Style>
  <ss:Style ss:ID="s68">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </ss:Style>
  <ss:Style ss:ID="s69">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </ss:Style>
  <ss:Style ss:ID="s70">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Bold="1"/>
   <NumberFormat ss:Format="Short Time"/>
  </ss:Style>
  <ss:Style ss:ID="s71">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="12"/>
  </ss:Style>
  <ss:Style ss:ID="s72">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="11"/>
<NumberFormat ss:Format="yyyy/mm/dd;@"/>
  </ss:Style>
  <ss:Style ss:ID="s73">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="12"/>
  </ss:Style>
  <ss:Style ss:ID="s74">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="12"/>
   <NumberFormat ss:Format="dd/mmm"/>
  </ss:Style>
  <ss:Style ss:ID="s75">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </ss:Style>
  <ss:Style ss:ID="s76">
   <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="1"/>
   </Borders>
  </ss:Style>
  <ss:Style ss:ID="s77">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </ss:Style>
  <ss:Style ss:ID="s78">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </ss:Style>
  <ss:Style ss:ID="s79">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </ss:Style>
  <ss:Style ss:ID="s80">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Bold="1"/>
   <NumberFormat ss:Format="#,##0"/>
  </ss:Style>
  <ss:Style ss:ID="s81">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </ss:Style>
  <ss:Style ss:ID="s82">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Bold="1"/>
  </ss:Style>
  <ss:Style ss:ID="s83">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </ss:Style>
  <ss:Style ss:ID="s84">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="8"/>
  </ss:Style>
  <ss:Style ss:ID="s85">
   <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="8" ss:Color="#000000"/>
   <Interior/>
  </ss:Style>
  <ss:Style ss:ID="s86">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Color="#000000"/>
  </ss:Style>
  <ss:Style ss:ID="s87">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Color="#000000"/>
   <Interior/>
  </ss:Style>
  <ss:Style ss:ID="s88">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Interior/>
  </ss:Style>
  <ss:Style ss:ID="s89">
   <Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="12"/>
  </ss:Style>
  <ss:Style ss:ID="s90">
   <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="12" ss:Color="#000000"/>
   <Interior/>
  </ss:Style>
  <ss:Style ss:ID="s91">
   <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="12" ss:Color="#000000"/>
   <Interior/>
  </ss:Style>
  <ss:Style ss:ID="s92">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="12"/>
  </ss:Style>
  <ss:Style ss:ID="s93">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="12"/>
  </ss:Style>
  <ss:Style ss:ID="s94">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="8" ss:Color="#000000"/>
   <Interior/>
  </ss:Style>
  <ss:Style ss:ID="s95">
   <Alignment ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="12"/>
  </ss:Style>
  <ss:Style ss:ID="s96">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="8" ss:Color="#000000"/>
  </ss:Style>
  <ss:Style ss:ID="s97">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="12" ss:Color="#000000"/>
   <Interior/>
  </ss:Style>
  <ss:Style ss:ID="s98">
   <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"
     ss:Color="#C0C0C0"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"
     ss:Color="#C0C0C0"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
     ss:Color="#C0C0C0"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="12" ss:Color="#000000"/>
   <Interior/>
  </ss:Style>
  <ss:Style ss:ID="s99">
   <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"
     ss:Color="#C0C0C0"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
     ss:Color="#C0C0C0"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
     ss:Color="#C0C0C0"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="12" ss:Color="#000000"/>
   <Interior/>
  </ss:Style>
  <ss:Style ss:ID="s100">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="8"/>
   <Interior ss:Color="#A5A5A5" ss:Pattern="Solid"/>
  </ss:Style>
  <ss:Style ss:ID="s101">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="8"/>
   <Interior ss:Color="#A5A5A5" ss:Pattern="Solid"/>
  </ss:Style>
  <ss:Style ss:ID="s102">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Interior ss:Color="#A5A5A5" ss:Pattern="Solid"/>
  </ss:Style>
  <ss:Style ss:ID="s103">
   <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="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Interior ss:Color="#A5A5A5" ss:Pattern="Solid"/>
  </ss:Style>
  <ss:Style ss:ID="s104">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Color="#000000"/>
   <Interior ss:Color="#A5A5A5" ss:Pattern="Solid"/>
  </ss:Style>
  <ss:Style ss:ID="s105">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss"/>
   <Interior ss:Color="#A5A5A5" ss:Pattern="Solid"/>
  </ss:Style>
  <ss:Style ss:ID="s106">
   <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="8" ss:Color="#000000"/>
   <Interior/>
  </ss:Style>
  <ss:Style ss:ID="s107">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
   <Interior/>
  </ss:Style>
  <ss:Style ss:ID="s108">
   <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
   <Interior/>
  </ss:Style>
  <ss:Style ss:ID="s109">
   <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
   <Interior/>
  </ss:Style>
  <ss:Style ss:ID="s110">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="8" ss:Color="#000000"/>
   <Interior/>
   <NumberFormat ss:Format="#,##0"/>
  </ss:Style>
  <ss:Style ss:ID="s111">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </ss:Style>
  <ss:Style ss:ID="s112">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss"/>
   <Interior/>
  </ss:Style>
  <ss:Style ss:ID="s113">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss"/>
  </ss:Style>
  <ss:Style ss:ID="s114">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="12" ss:Color="#000000"/>
  </ss:Style>
  <ss:Style ss:ID="s115" ss:Parent="s49">
   <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="12" ss:Color="#000000"/>
   <Interior/>
  </ss:Style>
  <ss:Style ss:ID="s116" ss:Parent="s49">
   <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="12" ss:Color="#000000"/>
   <Interior/>
  </ss:Style>
  <ss:Style ss:ID="s117">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="9"/>
   <NumberFormat ss:Format="#,##0"/>
  </ss:Style>
  <ss:Style ss:ID="s118">
   <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="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="9" ss:Color="#000000"/>
  </ss:Style>
 </ss:Styles>
 <ss:Worksheet ss:Name="Sjösättning">
  <ss:Names>
   <NamedRange ss:Name="Print_Area" ss:RefersTo="=Sjösättning!R1C1:R40C13"/>
  </ss:Names>
  <ss:Table ss:ExpandedRowCount="61" x:FullColumns="1"
   x:FullRows="1">
   <ss:Column ss:StyleID="s63" ss:AutoFitWidth="0" ss:Width="39.75"/>
   <ss:Column ss:StyleID="s63" ss:AutoFitWidth="0" ss:Width="37.5"/>
   <ss:Column ss:AutoFitWidth="0" ss:Width="64.5"/>
   <ss:Column ss:AutoFitWidth="0" ss:Width="66"/>
   <ss:Column ss:Hidden="1" ss:AutoFitWidth="0" ss:Width="64.5"/>
   <ss:Column ss:AutoFitWidth="0" ss:Width="58.5"/>
   <ss:Column ss:AutoFitWidth="0" ss:Width="60"/>
   <ss:Column ss:StyleID="s63" ss:Width="21"/>
   <ss:Column ss:StyleID="s63" ss:AutoFitWidth="0" ss:Width="29.25"/>
   <ss:Column ss:StyleID="s63" ss:AutoFitWidth="0" ss:Width="34.5"/>
   <ss:Column ss:StyleID="s63" ss:AutoFitWidth="0" ss:Width="27"/>
   <ss:Column ss:StyleID="s63" ss:AutoFitWidth="0" ss:Width="26.25"/>
   <ss:Column ss:StyleID="s63" ss:AutoFitWidth="0" ss:Width="28.5"/>
   <ss:Column ss:StyleID="s63" ss:AutoFitWidth="0"/>

<?php
@mysql_connect($host,$usr,$pwd)
or die("<p>Kan ej ansluta till databasservern.</p>");
@mysql_select_db($db)
or die("<p>Kan ej ansluta till databasen " . $db . ".</p>");
$SQL1 = " SELECT id FROM medlem WHERE (upptagningsdatum = '$_POST[upptagningsdag]'  OR  upptagningsdatum_bat_2 = '$_POST[upptagningsdag]') AND (upptagningsupplagsplats = '$_POST[varv]' OR upptagningsupplagsplats_bat_2 = '$_POST[varv]' ) ";
$ret1 = mysql_query($SQL1);
if (!$ret1) { echo( mysql_error()); }
else {
$numcols = mysql_num_fields($ret1);
$numrows = mysql_num_rows($ret1);
}
$numberofrows = ($numrows+3);
?>
   <ss:Row ss:AutoFitHeight="0" ss:Height="15">
    <ss:Cell ss:StyleID="s64"><Data ss:Type="String">DAG</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s65"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s66"><Data ss:Type="String"><? echo $veckodag; ?></Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:MergeAcross="10" ss:MergeDown="2" ss:StyleID="m31465920"><Data
      ss:Type="String"><?php echo $_POST['varv']; ?></Data><NamedCell ss:Name="Print_Area"/></ss:Cell>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Height="15">
    <ss:Cell ss:StyleID="s64"><Data ss:Type="String">DATUM</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s65"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <Cell ss:StyleID="s70"><Data ss:Type="DateTime"><? echo $upptagningsdag; ?></Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
   </ss:Row>
   <ss:Row ss:AutoFitHeight="0" ss:Height="6.75"/>
   <ss:Row>
    <ss:Cell ss:StyleID="s68"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s68"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s78"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s81"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s81"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s68"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s68"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s82"><Data ss:Type="String">Båt</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s67"><Data ss:Type="String">Traktor</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s78"><Data ss:Type="String">Förs-</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s68"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s68"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s68"><Data ss:Type="String">Betalt</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s68"/>
   </ss:Row>
   <ss:Row>
    <ss:Cell ss:StyleID="s69"><Data ss:Type="String">Tid</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s84"><Data ss:Type="String">Medlem</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:MergeAcross="1" ss:StyleID="m51662112"><Data ss:Type="String">Namn</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s75"><Data ss:Type="String">Adress</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s69"><Data ss:Type="String">Telefon</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s69"><Data ss:Type="String">Mobil</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s66"><Data ss:Type="String">SB</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s67"><Data ss:Type="String">Vagn</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s65"><Data ss:Type="String">bolag</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s84"><Data ss:Type="String">Skjul</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s84"><Data ss:Type="String">Varvpl</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s69"><Data ss:Type="String">Kvitto</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s88"><Data ss:Type="String">Båtplats</Data></ss:Cell>
   </ss:Row>
   <ss:Row ss:AutoFitHeight="0" ss:Height="15">
    <ss:Cell ss:StyleID="s79"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s79"><Data ss:Type="String">nr</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s76"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s77"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s75"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s69"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s69"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s68"><Data ss:Type="String">MB</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s68"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s65"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s79"><Data ss:Type="String">nr</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s79"><NamedCell ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s79"><Data ss:Type="String">Nr</Data><NamedCell
      ss:Name="Print_Area"/></ss:Cell>
    <ss:Cell ss:StyleID="s79"/>
   </ss:Row>
   
<?php
$SQL1 = " SELECT medlemsnr, fornamn, efternamn, telnr, mobilnr, upptagningsdatum, upptagnings_turnummer, batmodell, onskar_traktor, onskar_vagn, forsakringsbolag, skjulnummer, varvsplats, upptagningsdatum_bat_2, upptagnings_turnummer_bat_2, batmodell_bat_2, onskar_traktor_bat_2, onskar_vagn_bat_2, forsakringsbolag_bat_2, skjulnummer_bat_2, varvsplats_bat_2, upptagningsupplagsplats, upptagningsupplagsplats_bat_2, 
 CASE WHEN upptagningsdatum ='$_POST[upptagningsdag]' THEN upptagningsdatum ELSE upptagningsdatum_bat_2 END as `datum`,
 CASE WHEN upptagningsdatum ='$_POST[upptagningsdag]' THEN upptagnings_turnummer ELSE upptagnings_turnummer_bat_2 END as `turnummer`
 FROM medlem WHERE (upptagningsdatum = '$_POST[upptagningsdag]'  OR  upptagningsdatum_bat_2 = '$_POST[upptagningsdag]') AND (upptagningsupplagsplats = '$_POST[varv]' OR upptagningsupplagsplats_bat_2 = '$_POST[varv]' ) ORDER BY `turnummer` ";
$ret1 = mysql_query($SQL1);
if (!$ret1) { echo( mysql_error()); }
else {
while ($row = mysql_fetch_assoc($ret1))  {
$medlemsnr = $row['medlemsnr'];
$fornamn = $row['fornamn'];
$efternamn = $row['efternamn'];
$telnr = $row['telnr'];
$mobilnr = $row['mobilnr'];
$upptagningsdatum = $row['upptagningsdatum'];
//$upptagnings_turnummer = $row['upptagnings_turnummer'];
$batmodell = $row['batmodell'];
$onskar_traktor = $row['onskar_traktor'];
$onskar_vagn = $row['onskar_vagn'];
$forsakringsbolag = $row['forsakringsbolag'];
$skjulnummer = $row['skjulnummer'];
$varvsplats = $row['varvsplats_upptagning'];
$upptagningsdatum_bat_2 = $row['upptagningsdatum_bat_2'];
//$upptagnings_turnummer_bat_2 = $row['upptagnings_turnummer_bat_2'];
$batmodell_bat_2 = $row['batmodell_bat_2'];
$onskar_traktor_bat_2 = $row['onskar_traktor_bat_2'];
$onskar_vagn_bat_2 = $row['onskar_vagn_bat_2'];
$forsakringsbolag_bat_2 = $row['forsakringsbolag_bat_2'];
$skjulnummer_bat_2 = $row['skjulnummer_bat_2'];
$varvsplats_bat_2 = $row['varvsplats_upptagning_bat_2'];
$upptagningsupplagsplats = $row['upptagningsupplagsplats'];
$upptagningsupplagsplats_bat_2 = $row['upptagningsupplagsplats_bat_2'];
$datum = $row['datum'];
$turnummer = $row['turnummer'];
$batmodell = trim($batmodell," ");
$batmodell_bat_2 = trim($batmodell_bat_2," ");
if($batmodell == "segelbåt")  { $batmodellen = "SB";  }
if($batmodell == "motorbåt")  { $batmodellen = "MB";  }
if($batmodell_bat_2 == "segelbåt")  { $batmodellen = "SB";  }
if($batmodell_bat_2 == "motorbåt")  { $batmodellen = "MB";  }
if($onskar_traktor == "ja" || $onskar_traktor == "nej"  && $onskar_vagn == null)  
//echo "Medlemsnr: $medlemsnr, Varvsplats: $varvsplats, Upplagsplats: $upptagningsupplagsplats<br>";
{
	if($onskar_traktor == "ja")   { $traktor = "T";  }
	if($onskar_traktor == "nej")   { $traktor = "&nbsp;";  }
}

if($onskar_traktor == "ja" || $onskar_traktor == "nej"  && $onskar_vagn !== null ) 
{
	if($onskar_vagn == null && $onskar_traktor == "ja")   { $traktor = "T";  }
	if($onskar_vagn == "ja" && $onskar_traktor == "nej")   { $traktor = "V";  }
	if($onskar_vagn == "ja" && $onskar_traktor == "ja")   { $traktor = "V";  }
	if($onskar_vagn == null && $onskar_traktor == "nej")   { $traktor = "&nbsp;";  }
}

if($onskar_traktor_bat_2 == "ja" || $onskar_traktor_bat_2 == "nej"  && $onskar_vagn_bat_2 == null)  
{
	if($onskar_traktor_bat_2 == "ja")   { $traktor_bat_2 = "T";  }
	if($onskar_traktor_bat_2 == "nej")   { $traktor_bat_2 = "&nbsp;";  }
}

if($onskar_traktor_bat_2 == "ja" || $onskar_traktor_bat_2 == "nej"  && $onskar_vagn_bat_2 !== null) 
{
	if($onskar_vagn_bat_2 == null && $onskar_traktor_bat_2 == "ja")   { $traktor = "T";  }
	if($onskar_vagn_bat_2 == "ja" && $onskar_traktor_bat_2 == "nej")   { $traktor = "V";  }
	if($onskar_vagn_bat_2 == "ja" && $onskar_traktor_bat_2 == "ja")   { $traktor = "V";  }
	if($onskar_vagn_bat_2 == null && $onskar_traktor_bat_2 == "nej")   { $traktor = "&nbsp;";  }
}

$SQL11 ="SELECT perioder FROM launch_up WHERE dag = '$_POST[upptagningsdag]' AND varv='$_POST[varv]' ";
$ret11 = mysql_query($SQL11);
if (!$ret11) { echo( mysql_error()); }
else {
while ($row = mysql_fetch_array($ret11)) {
$perioder = $row["perioder"];
}}
if($upptagningsupplagsplats == "$varv_3_namn" || $upptagningsupplagsplats_bat_2 == "$varv_3_namn")  {
//Om Perioder == 1:
if($perioder > 0 && $perioder < 5)	{
if($turnummer == 1) {   $tiden = "8:00";   }
if($turnummer == 2) {   $tiden = "8:15";   }
if($turnummer == 3) {   $tiden = "8:30";   }
if($turnummer == 4) {   $tiden = "8:45";   }
if($turnummer == 5) {   $tiden = "9:00";   }
if($turnummer == 6) {   $tiden = "9:15";   }
if($turnummer == 7) {   $tiden = "9:30";   }

}
//Om Perioder == 1-2:
if($perioder > 1 && $perioder < 5) {
if($turnummer == 8) {   $tiden = "10:00";   }
if($turnummer == 9) {   $tiden = "10:15";   }
if($turnummer == 10) {   $tiden = "10:30";   }
if($turnummer == 11) {   $tiden = "10:45";   }
if($turnummer == 12) {   $tiden = "11:00";   }
if($turnummer == 13) {   $tiden = "11:15";   }
if($turnummer == 14) {   $tiden = "11:30";   }
if($turnummer == 15) {   $tiden = "11:45";   }

}
//Om Perioder == 1-3:
if($perioder > 2 && $perioder < 5) {
if($turnummer == 16) {   $tiden = "13:00";   }
if($turnummer == 17) {   $tiden = "13:15";   }
if($turnummer == 18) {   $tiden = "13:30";   }
if($turnummer == 19) {   $tiden = "13:45";   }
if($turnummer == 20) {   $tiden = "14:00";   }
if($turnummer == 21) {   $tiden = "14:15";   }
if($turnummer == 22) {   $tiden = "14:30";   }

}
//Om Perioder == 1-4:
if($perioder > 3  && $perioder < 5) {
if($turnummer == 23) {   $tiden = "15:00";   }
if($turnummer == 24) {   $tiden = "15:15";   }
if($turnummer == 25) {   $tiden = "15:30";   }
if($turnummer == 26) {   $tiden = "15:45";   }
if($turnummer == 27) {   $tiden = "16:00";   }
if($turnummer == 28) {   $tiden = "16:15";   }
if($turnummer == 29) {   $tiden = "16:30";   }
if($turnummer == 30) {   $tiden = "16:45";   }

}
//Turnummer börjar på 1 vid början av period 5.
//Om Perioder == 5:
if($perioder > 4  && $perioder < 7) {
if($turnummer == 1) {   $tiden = "17:00";   }
if($turnummer == 2) {   $tiden = "17:15";   }
if($turnummer == 3) {   $tiden = "17:30";   }
if($turnummer == 4) {   $tiden = "17:45";   }
if($turnummer == 5) {   $tiden = "18:00";   }
if($turnummer == 6) {   $tiden = "18:15";   }
if($turnummer == 7) {   $tiden = "18:30";   }
if($turnummer == 8) {   $tiden = "18:45";   }

}
//Om Perioder == 5-6:
if($perioder > 4  && $perioder < 7) {
if($turnummer == 9) {   $tiden = "19:30";   }
if($turnummer == 10) {   $tiden = "19:45";   }
if($turnummer == 11) {   $tiden = "20:00";   }
if($turnummer == 12) {   $tiden = "20:15";   }
if($turnummer == 13) {   $tiden = "20:30";   }
if($turnummer == 14) {   $tiden = "20:45";   }
if($turnummer == 15) {   $tiden = "21:00";   }
if($turnummer == 16) {   $tiden = "21:15";   }
}}
if($upptagningsupplagsplats == "$varv_4_namn")  {
if($perioder > 0 && $perioder < 7)	{
if($turnummer == 1) {   $tiden = "9:00";   }
if($turnummer == 2) {   $tiden = "10:00";   }
if($turnummer == 3) {   $tiden = "11:00";   }
if($turnummer == 4) {   $tiden = "13:00";   }
if($turnummer == 5) {   $tiden = "14:00";   }
if($turnummer == 6) {   $tiden = "15:00";   }
}}
if($perioder > 0 && $perioder < 5) { 
if($turnummer > 0 && $turnummer < 7 && $upptagningsupplagsplats == "$varv_3_namn")  {

		echo "
<ss:Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <ss:Cell ss:StyleID=\"s80\"><ss:Data  ss:Type=\"String\">$tiden</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s97\"><ss:Data  ss:Type=\"Number\">$medlemsnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s90\"><ss:Data  ss:Type=\"String\">$efternamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s91\"><ss:Data  ss:Type=\"String\">$fornamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s85\"><ss:Data  ss:Type=\"String\"> </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$telnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$mobilnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$batmodellen</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$traktor</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$forsakringsbolag</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"Number\">$skjulnummer</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"><ss:Data  ss:Type=\"String\">$varvsplats</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\"></ss:Data></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"/>
   </ss:Row>";
}}
		
if($perioder > 1 && $perioder < 5) { 
if($turnummer > 7 && $turnummer < 15 && $upptagningsupplagsplats == "$varv_3_namn")  {
			echo "
<ss:Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <ss:Cell ss:StyleID=\"s80\"><ss:Data  ss:Type=\"String\">$tiden</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s97\"><ss:Data  ss:Type=\"Number\">$medlemsnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s90\"><ss:Data  ss:Type=\"String\">$efternamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s91\"><ss:Data  ss:Type=\"String\">$fornamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s85\"><ss:Data  ss:Type=\"String\"> </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$telnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$mobilnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$batmodellen</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$traktor</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$forsakringsbolag</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"Number\">$skjulnummer</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"><ss:Data  ss:Type=\"String\">$varvsplats</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\"></ss:Data></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"/>
   </ss:Row>";
}}	

if($perioder > 2 && $perioder < 5) { 
if($turnummer > 15 && $turnummer < 22 && $upptagningsupplagsplats == "$varv_3_namn")  {
			echo "
<ss:Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <ss:Cell ss:StyleID=\"s80\"><ss:Data  ss:Type=\"String\">$tiden</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s97\"><ss:Data  ss:Type=\"Number\">$medlemsnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s90\"><ss:Data  ss:Type=\"String\">$efternamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s91\"><ss:Data  ss:Type=\"String\">$fornamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s85\"><ss:Data  ss:Type=\"String\"> </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$telnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$mobilnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$batmodellen</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$traktor</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$forsakringsbolag</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"Number\">$skjulnummer</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"><ss:Data  ss:Type=\"String\">$varvsplats</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\"></ss:Data></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"/>
   </ss:Row>";
}}

if($perioder > 3 && $perioder < 5) { 
if($turnummer > 22 && $turnummer < 31 && $upptagningsupplagsplats == "$varv_3_namn")  {
				echo "
<ss:Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <ss:Cell ss:StyleID=\"s80\"><ss:Data  ss:Type=\"String\">$tiden</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s97\"><ss:Data  ss:Type=\"Number\">$medlemsnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s90\"><ss:Data  ss:Type=\"String\">$efternamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s91\"><ss:Data  ss:Type=\"String\">$fornamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s85\"><ss:Data  ss:Type=\"String\"> </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$telnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$mobilnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$batmodellen</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$traktor</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$forsakringsbolag</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"Number\">$skjulnummer</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"><ss:Data  ss:Type=\"String\">$varvsplats</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\"></ss:Data></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"/>
   </ss:Row>";
}}

if($perioder > 4  && $perioder < 7 ) { 
if($turnummer > 0 && $turnummer < 8 && $upptagningsupplagsplats == "$varv_3_namn")  {
				echo "
<ss:Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <ss:Cell ss:StyleID=\"s80\"><ss:Data  ss:Type=\"String\">$tiden</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s97\"><ss:Data  ss:Type=\"Number\">$medlemsnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s90\"><ss:Data  ss:Type=\"String\">$efternamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s91\"><ss:Data  ss:Type=\"String\">$fornamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s85\"><ss:Data  ss:Type=\"String\"> </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$telnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$mobilnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$batmodellen</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$traktor</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$forsakringsbolag</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"Number\">$skjulnummer</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"><ss:Data  ss:Type=\"String\">$varvsplats</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\"></ss:Data></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"/>
   </ss:Row>";
}}

if($perioder > 5  && $perioder < 7 ) { 
if($turnummer > 8 && $turnummer < 17 && $upptagningsupplagsplats == "$varv_3_namn")  {
				echo "
<ss:Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <ss:Cell ss:StyleID=\"s80\"><ss:Data  ss:Type=\"String\">$tiden</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s97\"><ss:Data  ss:Type=\"Number\">$medlemsnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s90\"><ss:Data  ss:Type=\"String\">$efternamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s91\"><ss:Data  ss:Type=\"String\">$fornamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s85\"><ss:Data  ss:Type=\"String\"> </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$telnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$mobilnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$batmodellen</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$traktor</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$forsakringsbolag</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"Number\">$skjulnummer</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"><ss:Data  ss:Type=\"String\">$varvsplats</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\"></ss:Data></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"/>
   </ss:Row>";
}}

if($perioder > 0 && $perioder < 5 && $turnummer == 7 && $upptagningsupplagsplats == "$varv_3_namn")  {
echo "
   <ss:Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <ss:Cell ss:StyleID=\"s80\"><ss:Data  ss:Type=\"String\">$tiden</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s97\"><ss:Data  ss:Type=\"Number\">$medlemsnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s90\"><ss:Data  ss:Type=\"String\">$efternamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s91\"><ss:Data  ss:Type=\"String\">$fornamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s85\"><ss:Data  ss:Type=\"String\"> </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$telnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$mobilnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$batmodellen</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$traktor</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$forsakringsbolag </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"Number\">$skjulnummer</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"><ss:Data  ss:Type=\"String\">$varvsplats</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\"></ss:Data></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"/>
   </ss:Row>
      <Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <Cell ss:MergeAcross=\"13\" ss:StyleID=\"s97\"><Data ss:Type=\"String\">KAFFERAST kl 9:45 -10:00</Data><NamedCell
      ss:Name=\"Print_Area\"/></Cell>
   </Row>";   }
   
if($perioder > 1 && $perioder < 5 && $turnummer == 15 && $upptagningsupplagsplats == "$varv_3_namn")  {
echo "
   <ss:Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <ss:Cell ss:StyleID=\"s80\"><ss:Data  ss:Type=\"String\">$tiden</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s97\"><ss:Data  ss:Type=\"Number\">$medlemsnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s90\"><ss:Data  ss:Type=\"String\">$efternamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s91\"><ss:Data  ss:Type=\"String\">$fornamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s85\"><ss:Data  ss:Type=\"String\"> </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$telnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$mobilnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$batmodellen</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$traktor</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$forsakringsbolag </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"Number\">$skjulnummer</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"><ss:Data  ss:Type=\"String\">$varvsplats</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\"></ss:Data></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"/>
   </ss:Row>
      <Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <Cell ss:MergeAcross=\"13\" ss:StyleID=\"s97\"><Data ss:Type=\"String\">LUNCHRAST kl 12:00 -13:00</Data><NamedCell
      ss:Name=\"Print_Area\"/></Cell>
   </Row>";   }
  
if($perioder > 2 && $perioder < 5 && $turnummer == 22 && $upptagningsupplagsplats == "$varv_3_namn")  {
echo "
   <ss:Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <ss:Cell ss:StyleID=\"s80\"><ss:Data  ss:Type=\"String\">$tiden</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s97\"><ss:Data  ss:Type=\"Number\">$medlemsnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s90\"><ss:Data  ss:Type=\"String\">$efternamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s91\"><ss:Data  ss:Type=\"String\">$fornamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s85\"><ss:Data  ss:Type=\"String\"> </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$telnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$mobilnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$batmodellen</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$traktor</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$forsakringsbolag </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"Number\">$skjulnummer</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"><ss:Data  ss:Type=\"String\">$varvsplats</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\"></ss:Data></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"/>
   </ss:Row>
      <Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <Cell ss:MergeAcross=\"13\" ss:StyleID=\"s97\"><Data ss:Type=\"String\">KAFFERAST kl 14:45 -15:00</Data><NamedCell
      ss:Name=\"Print_Area\"/></Cell>
   </Row>";   }

if($perioder > 4  && $perioder < 7 && $turnummer == 7 && $upptagningsupplagsplats == "$varv_3_namn")  {
echo "
   <ss:Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <ss:Cell ss:StyleID=\"s80\"><ss:Data  ss:Type=\"String\">$tiden</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s97\"><ss:Data  ss:Type=\"Number\">$medlemsnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s90\"><ss:Data  ss:Type=\"String\">$efternamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s91\"><ss:Data  ss:Type=\"String\">$fornamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s85\"><ss:Data  ss:Type=\"String\"> </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$telnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$mobilnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$batmodellen</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$traktor</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$forsakringsbolag </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"Number\">$skjulnummer</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"><ss:Data  ss:Type=\"String\">$varvsplats</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\"></ss:Data></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"/>
   </ss:Row>
      <Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <Cell ss:MergeAcross=\"13\" ss:StyleID=\"s97\"><Data ss:Type=\"String\">KAFFERAST kl 17:45 -18:00</Data><NamedCell
      ss:Name=\"Print_Area\"/></Cell>
   </Row>";   }


//----  varv_4_namn:


if($perioder > 0 && $perioder < 3) { 
if($turnummer == 1 && $upptagningsupplagsplats == "$varv_4_namn")  {

		echo "
<ss:Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <ss:Cell ss:StyleID=\"s80\"><ss:Data  ss:Type=\"String\">$tiden</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s97\"><ss:Data  ss:Type=\"Number\">$medlemsnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s90\"><ss:Data  ss:Type=\"String\">$efternamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s91\"><ss:Data  ss:Type=\"String\">$fornamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s85\"><ss:Data  ss:Type=\"String\"> </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$telnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$mobilnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$batmodellen</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$traktor</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$forsakringsbolag</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"Number\">$skjulnummer</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"><ss:Data  ss:Type=\"String\">$varvsplats</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\"></ss:Data></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"/>
   </ss:Row>
   <Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <Cell ss:MergeAcross=\"13\" ss:StyleID=\"s97\"><Data ss:Type=\"String\">KAFFERAST kl 09:45 -10:00</Data><NamedCell
      ss:Name=\"Print_Area\"/></Cell>
   </Row>";
}}

if($perioder > 0 && $perioder < 3) { 
if($turnummer == 2 && $upptagningsupplagsplats == "$varv_4_namn")  {

		echo "
<ss:Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <ss:Cell ss:StyleID=\"s80\"><ss:Data  ss:Type=\"String\">$tiden</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s97\"><ss:Data  ss:Type=\"Number\">$medlemsnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s90\"><ss:Data  ss:Type=\"String\">$efternamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s91\"><ss:Data  ss:Type=\"String\">$fornamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s85\"><ss:Data  ss:Type=\"String\"> </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$telnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$mobilnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$batmodellen</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$traktor</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$forsakringsbolag</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"Number\">$skjulnummer</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"><ss:Data  ss:Type=\"String\">$varvsplats</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\"></ss:Data></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"/>
   </ss:Row>
";
}}

if($perioder > 0 && $perioder < 3) { 
if($turnummer == 3 && $upptagningsupplagsplats == "$varv_4_namn")  {

		echo "
<ss:Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <ss:Cell ss:StyleID=\"s80\"><ss:Data  ss:Type=\"String\">$tiden</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s97\"><ss:Data  ss:Type=\"Number\">$medlemsnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s90\"><ss:Data  ss:Type=\"String\">$efternamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s91\"><ss:Data  ss:Type=\"String\">$fornamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s85\"><ss:Data  ss:Type=\"String\"> </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$telnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$mobilnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$batmodellen</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$traktor</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$forsakringsbolag</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"Number\">$skjulnummer</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"><ss:Data  ss:Type=\"String\">$varvsplats</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\"></ss:Data></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"/>
   </ss:Row>
         <Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <Cell ss:MergeAcross=\"13\" ss:StyleID=\"s97\"><Data ss:Type=\"String\">LUNCHRAST kl 12:00 -13:00</Data><NamedCell
      ss:Name=\"Print_Area\"/></Cell>
   </Row>";   
}}

if($perioder > 0 && $perioder < 3) { 
if($turnummer == 4 && $upptagningsupplagsplats == "$varv_4_namn")  {

		echo "
<ss:Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <ss:Cell ss:StyleID=\"s80\"><ss:Data  ss:Type=\"String\">$tiden</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s97\"><ss:Data  ss:Type=\"Number\">$medlemsnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s90\"><ss:Data  ss:Type=\"String\">$efternamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s91\"><ss:Data  ss:Type=\"String\">$fornamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s85\"><ss:Data  ss:Type=\"String\"> </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$telnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$mobilnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$batmodellen</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$traktor</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$forsakringsbolag</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"Number\">$skjulnummer</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"><ss:Data  ss:Type=\"String\">$varvsplats</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\"></ss:Data></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"/>
   </ss:Row>
";
}}

if($perioder > 0 && $perioder < 3) { 
if($turnummer == 5 && $upptagningsupplagsplats == "$varv_4_namn")  {

		echo "
<ss:Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <ss:Cell ss:StyleID=\"s80\"><ss:Data  ss:Type=\"String\">$tiden</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s97\"><ss:Data  ss:Type=\"Number\">$medlemsnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s90\"><ss:Data  ss:Type=\"String\">$efternamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s91\"><ss:Data  ss:Type=\"String\">$fornamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s85\"><ss:Data  ss:Type=\"String\"> </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$telnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$mobilnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$batmodellen</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$traktor</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$forsakringsbolag</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"Number\">$skjulnummer</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"><ss:Data  ss:Type=\"String\">$varvsplats</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\"></ss:Data></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"/>
   </ss:Row>
      <Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <Cell ss:MergeAcross=\"13\" ss:StyleID=\"s97\"><Data ss:Type=\"String\">KAFFERAST kl 14:45 -15:00</Data><NamedCell
      ss:Name=\"Print_Area\"/></Cell>
   </Row>";
}}

if($perioder > 0 && $perioder < 3) { 
if($turnummer == 6 && $upptagningsupplagsplats == "$varv_4_namn")  {

echo "
<ss:Row ss:AutoFitHeight=\"0\" ss:Height=\"15\">
    <ss:Cell ss:StyleID=\"s80\"><ss:Data  ss:Type=\"String\">$tiden</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s97\"><ss:Data  ss:Type=\"Number\">$medlemsnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s90\"><ss:Data  ss:Type=\"String\">$efternamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s91\"><ss:Data  ss:Type=\"String\">$fornamn</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s85\"><ss:Data  ss:Type=\"String\"> </ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$telnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s94\"><ss:Data  ss:Type=\"String\">$mobilnr</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$batmodellen</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$traktor</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\">$forsakringsbolag</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"Number\">$skjulnummer</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"><ss:Data  ss:Type=\"String\">$varvsplats</ss:Data><NamedCell
      ss:Name=\"Print_Area\"/></ss:Cell>      
    <ss:Cell ss:StyleID=\"s87\"><ss:Data  ss:Type=\"String\"></ss:Data></ss:Cell>
    <ss:Cell ss:StyleID=\"s86\"/>
   </ss:Row>";
   
   
   
}}}}
?>

</ss:Table>
<ss:WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <ss:PageSetup>
    <Header x:Data="&amp;C&amp;&quot;Arial,Fet&quot;&amp;18UPPTAGNINGSTIDER  för KRAN <? echo $ar; ?>"/>
   </ss:PageSetup>
   <FitToPage/>
   <ss:Print>
    <FitHeight>0</FitHeight>
    <ValidPrinterInfo/>
    <ss:PaperSizeIndex>9</ss:PaperSizeIndex>
    <Scale>85</Scale>
    <HorizontalResolution>1200</HorizontalResolution>
    <VerticalResolution>0</VerticalResolution>
   </ss:Print>
   <Selected/>
   <ss:Panes>
    <ss:Pane>
     <Number>3</Number>
     <ActiveRow>23</ActiveRow>
     <ActiveCol>6</ActiveCol>
    </ss:Pane>
   </ss:Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </ss:WorksheetOptions>
 </ss:Worksheet>
 <ss:DocumentProperties>
   <o:Author>Ericson Productions</o:Author>
   <o:LastAuthor>Lennart</o:LastAuthor>
   <o:LastPrinted>2009-06-07T19:02:13Z</o:LastPrinted>
   <o:Created>2010-03-23T13:29:15Z</o:Created>
   <o:LastSaved>2010-03-23T13:48:44Z</o:LastSaved>
   <o:Company>Enköpings Segelsällskap</o:Company>
   <o:Version>12.00</o:Version>
  </ss:DocumentProperties>
 <ss:ExcelWorkbook>
   <x:WindowHeight>2985</x:WindowHeight>
   <x:WindowWidth>3540</x:WindowWidth>
   <x:WindowTopX>14985</x:WindowTopX>
   <x:WindowTopY>2895</x:WindowTopY>
   <x:ProtectStructure>False</x:ProtectStructure>
   <x:ProtectWindows>False</x:ProtectWindows>
  </ss:ExcelWorkbook>
</ss:Workbook>

Open in new window

0
Lennart Ericson
Asked:
Lennart Ericson
  • 3
  • 2
1 Solution
 
HainKurtSr. System AnalystCommented:
can you please post the xml file created...
0
 
thepanchCommented:
i guess the problem is that you are getting wrong values on cells B1 and G12, but watching your code, you dont need to do the template of the file, you just need to set the info.

the new way office 2007+ do the file, is just using xml, i suggest you to make a file on excel with the correct template you want, then unzip it (yes with winzip, right click and use winzip to open this file) and youll notice that the file is splited on several folders (the info, the template, the charts, etc etc), so the only thing you gotta do is find the source file (the only with data), and replace that file, with the correct xml you want, then you'll have a complete compatible office file.

i hope it works
0
 
Lennart EricsonAmateurAuthor Commented:
Sorry, I don't know how to get the xml file out of the system. When I execute the script it comes automatically out as an Excel file. Please advice.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Lennart EricsonAmateurAuthor Commented:
thepanch:
Like your idea. Could you describe more in detail how to procede from when I have produced a new source file. I don't know how to tie it all together.

Say I have got all the data and populated the xml file. What should I do to produce a new xlsx file?
0
 
thepanchCommented:
ok my friend,

this is a xlsx file created with Excel,
it has information from CEll A to cell C
and from row 1 to 27 if my memory doesnt fail me
 once you unzipp it, you'll notice several things.

one:there are 3 folders (_rels, xl,) and one content_types
the _rels, and docProps folders i really dont know what they are doing, but the xli do :P

once again we have _rels, charts,drawings, printerSettings, theme, worksheets and 4 xml on the root.
well as you can see all the info is splited correctly, so the only thing you gotta do is to replace the worksheets/sheet(number) that you are working on, in my case i only used the first one.

Open that file and the xml is really fast to understand.

 <dimension ref="A2:C27" />  <-- the cells where you got info

- <sheetView tabSelected="1" workbookViewId="0"> <--the tab is gonna be selected by default
  <selection activeCell="K26" sqref="K26" />  <-- i really dont know
  </sheetView>
- <sheetData>
- <row r="2" spans="1:3">  <-- new row, on row 2 (the first one)

- <c r="A2" s="1" t="s">        <---- new collum (a2) size(1) type (string)
  <v>0</v>          <--- new value (0)
  </c>                 <--- end of row

Example of a formula value
- <c r="B3">
  <f>A3*2</f>   <--- cell a3 * 2
  <v>2</v>  <-- displayed value=2
  </c>

and so you can keep diging on the file and you'll find some nice stuff.



BTW thats why i said you create the right template on excel, so you keep the same style, but you only move the data ;)


I hope this help you.


test.xlsx
0
 
Lennart EricsonAmateurAuthor Commented:
Thanks for the explanation
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now