{"<?xml version=\"1.0\" encoding=\"UTF-8\"?><?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>TINA by DCs Fast Link</Author>
		<LastAuthor>TINA by DCs Fast Link</LastAuthor>
		<Company>DCs Fast Link</Company>
		<Version>11.5606</Version>
	</DocumentProperties>

	<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"></ExcelWorkbook>

	<Styles>

		<Style ss:ID="Default" ss:Name="Normal">
			<Alignment ss:Vertical="Bottom"/>
			<Borders/>
			<Font x:CharSet="238"/>
			<Interior/>
			<NumberFormat/>
			<Protection/>
		</Style>

		{*** TABLE HEADER ************************************************************************************}

		<Style ss:ID="tableHeader">
			<Interior ss:Color="#000000" ss:Pattern="Solid"/>
			<Font ss:Bold="1" ss:FontName="Arial" ss:Size="10" ss:Color="#FFFFFF" />
			<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>
		</Style>

		{*** TABLE ROWS **************************************************************************************}

		<Style ss:ID="tableRow">
			<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
			<Font x:CharSet="238" ss:FontName="Arial" ss:Size="9" />
			<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="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#C0C0C0"/>
				<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#C0C0C0"/>
			</Borders>
		</Style>

		<Style ss:ID="tableRow_date">
			<Interior ss:Color="#DDDDDD" ss:Pattern="Solid"/>
			<Font x:CharSet="238" ss:FontName="Arial" ss:Size="9" />
			<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="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#C0C0C0"/>
				<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#C0C0C0"/>
			</Borders>
			<NumberFormat ss:Format="dd\/mm\/yyyy"/>
		</Style>

		<Style ss:ID="tableRow_price">
			<Interior ss:Color="#DDDDDD" ss:Pattern="Solid"/>
			<Font x:CharSet="238" ss:FontName="Arial" ss:Size="9" />
			<NumberFormat ss:Format="0.00" />
			<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="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#C0C0C0"/>
				<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#C0C0C0"/>
			</Borders>
		</Style>

		<Style ss:ID="tableRow_currencyExchange">
			<Interior ss:Color="#DDDDDD" ss:Pattern="Solid"/>
			<Font x:CharSet="238" ss:FontName="Arial" ss:Size="9" />
			<NumberFormat ss:Format="0.0000" />
			<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="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#C0C0C0"/>
				<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#C0C0C0"/>
			</Borders>
		</Style>

		{*** TABLE TOTALS ***********************************************************************************}

		<Style ss:ID="tableRow_total">
			<Interior ss:Color="#B2B2B2" ss:Pattern="Solid"/>
			<Font x:CharSet="238" ss:FontName="Arial" ss:Size="10" />
			<Borders>
				<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"  ss:Color="#303030"/>
				<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#303030"/>
				<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#303030"/>
				<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#303030"/>
			</Borders>
		</Style>

		<Style ss:ID="tableRow_total_date">
			<Interior ss:Color="#B2B2B2" ss:Pattern="Solid"/>
			<Font x:CharSet="238" ss:FontName="Arial" ss:Size="10" ss:Bold="1" />
			<Borders>
				<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"  ss:Color="#303030"/>
				<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#303030"/>
				<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#303030"/>
				<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#303030"/>
			</Borders>
			<NumberFormat ss:Format="dd\/mm\/yyyy"/>
		</Style>

		<Style ss:ID="tableRow_total_currency">
			<Interior ss:Color="#B2B2B2" ss:Pattern="Solid"/>
			<Font x:CharSet="238" ss:FontName="Arial" ss:Size="10" ss:Bold="1" ss:Italic="1" />
			<NumberFormat ss:Format="0.00" />
			<Borders>
				<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"  ss:Color="#303030"/>
				<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#303030"/>
				<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#303030"/>
				<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#303030"/>
			</Borders>
		</Style>

		<Style ss:ID="tableRow_total_currencyExchange">
			<Interior ss:Color="#B2B2B2" ss:Pattern="Solid"/>
			<Font x:CharSet="238" ss:FontName="Arial" ss:Size="10" ss:Bold="1" ss:Italic="1" />
			<Borders>
				<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"  ss:Color="#303030"/>
				<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#303030"/>
				<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#303030"/>
				<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#303030"/>
			</Borders>
		</Style>

		<Style ss:ID="tableRow_total_price">
			<Interior ss:Color="#B2B2B2" ss:Pattern="Solid"/>
			<Font x:CharSet="238" ss:FontName="Arial" ss:Size="10" ss:Bold="1" />
			<NumberFormat ss:Format="0.00" />
			<Borders>
				<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"  ss:Color="#303030"/>
				<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#303030"/>
				<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#303030"/>
				<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#303030"/>
			</Borders>

		</Style>

	</Styles>


	<Worksheet ss:Name="{$_LANG.cashBookView.exportCashBook.fileTitle}">

		{strip2}
			<Table>

				<Column ss:AutoFitWidth="1" ss:Width="100" ss:Span="100"/>

				{************************************************************************************}
				{************************************************************************************}
				{*********** TABLE HEAD *************************************************************}
				{************************************************************************************}
				{************************************************************************************}

				<Row>

						<Cell ss:StyleID="tableHeader"><Data ss:Type="String">{$_LANG.cashBookView.tableheader.date}</Data></Cell>
						<Cell ss:StyleID="tableHeader"><Data ss:Type="String">{$_LANG.cashBookView.tableheader.category}</Data></Cell>
						<Cell ss:StyleID="tableHeader"><Data ss:Type="String">{$_LANG.cashBookView.tableheader.type}</Data></Cell>
						<Cell ss:StyleID="tableHeader"><Data ss:Type="String">{$_LANG.cashBookView.tableheader.number}</Data></Cell>
						<Cell ss:StyleID="tableHeader"><Data ss:Type="String">{$_LANG.cashBookView.tableheader.partner}</Data></Cell>
						<Cell ss:StyleID="tableHeader"><Data ss:Type="String">{$_LANG.cashBookView.tableheader.explanations}</Data></Cell>
						{foreach from=$currencyArray item=thisCurrency}
							{if $currenciesSelected.$thisCurrency}
								<Cell  ss:StyleID="tableHeader"><Data ss:Type="String">{$thisCurrency}</Data></Cell>
							{/if}
						{/foreach}
						{if $showExchRate}
							<Cell ss:StyleID="tableHeader"><Data ss:Type="String">{$_LANG.cashBookView.tableheader.currencyExchange}</Data></Cell>
						{/if}
						{if $showEquivDefCurr}
							<Cell ss:StyleID="tableHeader"><Data ss:Type="String">{$_LANG.cashBookView.tableheader.equivalent|@sprintf:$defaultCurrency}</Data></Cell>
						{/if}
						{if $showEquivWorkCurr}
							<Cell ss:StyleID="tableHeader"><Data ss:Type="String">{$_LANG.cashBookView.tableheader.equivalent|@sprintf:$workCurrency}</Data></Cell>
						{/if}
				</Row>


				{************************************************************************************}
				{************************************************************************************}
				{*********** LIST CASH BOOK *********************************************************}
				{************************************************************************************}
				{************************************************************************************}

				{foreach $cashBookTotalsArr as $date=>$total}

					{* -- LIST DOCUMENTS FROM CURRENT DAY ---------------------------------------- *}

					{assign var="documentsCountThisDay" value="0"}

					{if $allDocumentsList[$date]}

						{foreach $allDocumentsList[$date] as $key=>$thisDocument}

							{if $thisDocument.currency|in_array:$currenciesSelected}

								{assign var="documentsCountThisDay" value=$documentsCountThisDay+1}

								<Row>
									<Cell ss:StyleID="tableRow_date"><Data ss:Type="DateTime">{$date|date_format:"%Y-%m-%dT00:00:00.000"}</Data></Cell>
									<Cell ss:StyleID="tableRow"><Data ss:Type="String">{$_LANG.cashBook.listing.documentCategories[$thisDocument.category]}</Data></Cell>
									<Cell ss:StyleID="tableRow"><Data ss:Type="String">{$_LANG.cashBook.documentTypes[$thisDocument.category][$thisDocument.type]}</Data></Cell>
									<Cell ss:StyleID="tableRow"><Data ss:Type="String">{if $thisDocument.number}{$thisDocument.number}{/if}</Data></Cell>
									<Cell ss:StyleID="tableRow"><Data ss:Type="String">{if $thisDocument.clientName}{$thisDocument.clientName}{elseif $thisDocument.supplierName}{$thisDocument.supplierName}{else}{$thisDocument.partner}{/if}</Data></Cell>
									<Cell ss:StyleID="tableRow"><Data ss:Type="String">{$thisDocument.explanations}</Data></Cell>
									{foreach from=$currencyArray item=thisCurrency}
										{if $currenciesSelected.$thisCurrency}
											<Cell ss:StyleID="tableRow_price"><Data ss:Type="Number">{if $thisCurrency==$thisDocument.currency}{$thisDocument.value}{else}0{/if}</Data></Cell>
										{/if}
									{/foreach}
									{if $showExchRate}
										{if $currencyExchangeValues.$date[$thisDocument.currency]}
											<Cell ss:StyleID="tableRow_currencyExchange"><Data ss:Type="Number">{$currencyExchangeValues.$date[$thisDocument.currency]}</Data></Cell>
										{else}
											<Cell ss:StyleID="tableRow"><Data ss:Type="String"></Data></Cell>
										{/if}
									{/if}
									{if $showEquivDefCurr}
										<Cell ss:StyleID="tableRow_price"><Data ss:Type="Number">{if $thisDocument.eqvValue}{$thisDocument.eqvValue}{else}0{/if}</Data></Cell>
									{/if}
									{if $showEquivWorkCurr}
										<Cell ss:StyleID="tableRow_price"><Data ss:Type="Number">{if $thisDocument.eqvWorkValue}{$thisDocument.eqvWorkValue}{else}0{/if}</Data></Cell>
									{/if}
								</Row>
							{/if}

						{/foreach}
					{/if}




					{* -- LIST EVERY DAY TOTALS ------------------------------------------------- *}

					<Row>
						<Cell ss:StyleID="tableRow_total_date"><Data ss:Type="DateTime">{$date|date_format:"%Y-%m-%dT00:00:00.000"}</Data></Cell>
						<Cell ss:MergeAcross="4" ss:StyleID="tableRow_total"><Data ss:Type="String">{$_LANG.cashBookView.tableContent.dayTotal} ({$date|dateTimeFormat:'date'}):</Data></Cell>
						{foreach from=$currencyArray item=thisCurrency}
							{if $currenciesSelected.$thisCurrency}
								<Cell ss:StyleID="tableRow_total_currency"><Data ss:Type="Number">{if $cashBookTotalsArr[$date][$thisCurrency]}{$cashBookTotalsArr[$date][$thisCurrency]}{else}0{/if}</Data></Cell>
							{/if}
						{/foreach}
						{if $showExchRate}
							<Cell ss:StyleID="tableRow_total_currencyExchange"><Data ss:Type="String"></Data></Cell>
						{/if}
						{if $showEquivDefCurr}
							<Cell ss:StyleID="tableRow_total_currency"><Data ss:Type="Number">{if $cashBookTotalsArrEqv[$date]}{$cashBookTotalsArrEqv[$date]}{else}0{/if}</Data></Cell>
						{/if}
						{if $showEquivWorkCurr}
							<Cell ss:StyleID="tableRow_total_currency"><Data ss:Type="Number">{if $cashBookTotalsArrEqvWork[$date]}{$cashBookTotalsArrEqvWork[$date]}{else}0{/if}</Data></Cell>
						{/if}
					</Row>

				{/foreach}

			</Table>
		{/strip2}
		<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

			<Selected/>
			<Zoom>90</Zoom>

			<FreezePanes/>
			<FrozenNoSplit/>
			<SplitHorizontal>1</SplitHorizontal>
			<TopRowBottomPane>1</TopRowBottomPane>
			<ActivePane>2</ActivePane>

		</WorksheetOptions>



	</Worksheet>

</Workbook>