{"<?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>

		{*** DOCUMENT MAIN PROPERTIES *************************************************************************}

		<Style ss:ID="documentTitle">
			<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
			<Font ss:Bold="1" ss:FontName="Arial" ss:Size="15" ss:Color="#000000" />
			<Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
		</Style>

		<Style ss:ID="documentOffice">
			<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
			<Font ss:Bold="1" ss:FontName="Arial" ss:Size="12" ss:Color="#000000" />
			<Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
		</Style>
		<Style ss:ID="documentDate">
			<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
			<Font ss:Bold="1" ss:FontName="Arial" ss:Size="12" ss:Color="#000000" />
			<Alignment ss:Horizontal="Right" ss:Vertical="Center"/>
		</Style>

		<Style ss:ID="footerDataLeft">
			<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
			<Font ss:FontName="Arial" ss:Size="11" ss:Color="#000000" />
			<Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
		</Style>
		<Style ss:ID="footerDataRight">
			<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
			<Font ss:FontName="Arial" ss:Size="11" ss:Color="#000000" />
			<Alignment ss:Horizontal="Right" ss:Vertical="Center"/>
		</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"/>

				{* calculate total cols *}
				{$currenciesCount=count($currencyArray)}
				{assign var=totalCols value=$currenciesCount+6}
				{if $showEquivDefCurr}{assign var=totalCols value=$totalCols+1}{/if}
				{if $showEquivWorkCurr}{assign var=totalCols value=$totalCols+1}{/if}
				{* break cells into two zones *}
				{assign var="docOfficeCells" value=$totalCols/2}

				{************************************************************************************}
				{*********** TITLE ******************************************************************}
				{************************************************************************************}
				<Row>
					<Cell ss:StyleID="documentOffice" ss:MergeAcross="3"><Data ss:Type="String">
						{$extraStuff.companyName} - {officeLabel ref=$idOffice hideLink=1}
					</Data></Cell>
					<Cell ss:StyleID="documentDate" ss:MergeAcross="1"><Data ss:Type="String">
						{$extraStuff.todayDate|dateTimeFormat}
					</Data></Cell>
				</Row>
				<Row>
					<Cell ss:StyleID="documentTitle" ss:MergeAcross="5"><Data ss:Type="String">
						Registru de casa
					</Data></Cell>
				</Row>

				<Row>

				</Row>

				{************************************************************************************}
				{************************************************************************************}
				{*********** 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.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 name=totalsForeach from=$cashBookTotalsArr key=date item=total}

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

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

					{if $allDocumentsList[$date]}

						{foreach from=$allDocumentsList[$date] key=key item=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">{$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="3" 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}



				{************************************************************************************}
				{*********** FOOTER DATA ************************************************************}
				{************************************************************************************}
				<Row>
				</Row>
				<Row>
					<Cell ss:StyleID="footerDataLeft" ss:MergeAcross="3"><Data ss:Type="String">
						Departament financiar-contabil
					</Data></Cell>
					<Cell ss:StyleID="footerDataRight"><Data ss:Type="String">
						Intocmit
					</Data></Cell>
				</Row>



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

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

		</WorksheetOptions>



	</Worksheet>

</Workbook>