Excel hanging or stuck while calculating a heap of formulas

Anbuselvam

Board Regular
Joined
May 10, 2017
Messages
97
https://www.dropbox.com/s/gfp9tfe6k2kc61r/Model sheet.xlsm.xlsx?dl=0

Dear Excel Ninjas

The above link excel sheet with the formulation which I'm using to maintain our company details since 2015 to till date. (Pivot table and Pivot charts not included as it is a model sheet created with dummy entries)

In the attached file I have entered only 13 rows of data with all the formulations. Actually, it is having more than 8000 rows thus it is hanging while calculating.

Each column in details:

Column A to I is production details

Column J to R is Sales details

Column U to BH is the formulation of each product (Data has to pick from two different sheets such Temporary and permanent as attached)

Column S, T and BI to BQ is the calculation of the cost of Raw materials, transportation, margin etc..

Column BR to DB is production quantity * Each product raw materials used as per formulation Column U to BH (To calculate the raw materials consumption)

Column DC to DE is the helper column for the slicer in Pivot table

Column DH to DF is the helper column the sheet COA as attached here.

Column DI and DJ is the helper column to pick the formulations from Temporary and permanent sheet to Master data.

And the last column DK is to cross-check the production quantity and the consumption of raw materials by formulation.

I hope the details are enough to understand the output.

Here I request you to suggest alternate formulas or formats to get the same output in each column as well as reduce file size and reduce the hanging issue while calculating.

Thanks in Advance

Sincerely Yours
Anbuselvam K
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
the dropbox attachment appears scrambled - can you possibly simplify what you are doing - show us some raw data - pretend if necessary - and how you want to manipulate it..................
 
Upvote 0
the drop box link is also very slow - if I am to try and help you, please make a new spreadsheet with say 10 rows of raw data, at this stage no pivots etc
 
Upvote 0
[TABLE="width: 11772"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="9"><col><col><col span="3"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col span="3"><col><col><col><col><col span="2"><col><col><col><col span="2"><col><col><col span="9"><col><col><col span="3"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col span="3"><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Sl.No.[/TD]
[TD]Date[/TD]
[TD]Product Name[/TD]
[TD]Batch No[/TD]
[TD]KMT / Chemanol[/TD]
[TD]Prod. Qty. in Ltr.[/TD]
[TD]Qty. in KG[/TD]
[TD]Date[/TD]
[TD]Invoice number[/TD]
[TD]Customer Name[/TD]
[TD]Location[/TD]
[TD]Selling Price / Ltrs. [/TD]
[TD]Desp. Qty. in Ltr.[/TD]
[TD]Cost[/TD]
[TD]Sales Value[/TD]
[TD]RM1[/TD]
[TD]RM2[/TD]
[TD]RM3[/TD]
[TD]RM4[/TD]
[TD]RM5[/TD]
[TD]RM6[/TD]
[TD]RM7[/TD]
[TD]RM8[/TD]
[TD]RM9[/TD]
[TD]RM10[/TD]
[TD]RM11[/TD]
[TD]RM12[/TD]
[TD]RM13[/TD]
[TD]RM14[/TD]
[TD]RM15[/TD]
[TD]RM16[/TD]
[TD]RM17[/TD]
[TD]RM18[/TD]
[TD]RM19[/TD]
[TD]RM20[/TD]
[TD]RM21[/TD]
[TD]RM22[/TD]
[TD]RM23[/TD]
[TD]RM24[/TD]
[TD]RM25[/TD]
[TD]RM26[/TD]
[TD]RM27[/TD]
[TD]RM28[/TD]
[TD]RM29[/TD]
[TD]RM30[/TD]
[TD]RM31[/TD]
[TD]RM32[/TD]
[TD]RM33[/TD]
[TD]RM34[/TD]
[TD]RM35[/TD]
[TD]RM36[/TD]
[TD]RM37[/TD]
[TD]Maufacturing cost[/TD]
[TD]Transport[/TD]
[TD]SP gravity range[/TD]
[TD]RM Cost / kg[/TD]
[TD]Total RM Cost[/TD]
[TD]Total Sales Cost W/O MC & Tra[/TD]
[TD]Total Sales Cost[/TD]
[TD]Total Manufacturing cost[/TD]
[TD]Total Transportation Cost[/TD]
[TD]Margin[/TD]
[TD]Total Production Cost W/O MC & Tra[/TD]
[TD]Total Production Cost[/TD]
[TD]RM1[/TD]
[TD]RM2[/TD]
[TD]RM3[/TD]
[TD]RM4[/TD]
[TD]RM5[/TD]
[TD]RM6[/TD]
[TD]RM7[/TD]
[TD]RM8[/TD]
[TD]RM9[/TD]
[TD]RM10[/TD]
[TD]RM11[/TD]
[TD]RM12[/TD]
[TD]RM13[/TD]
[TD]RM14[/TD]
[TD]RM15[/TD]
[TD]RM16[/TD]
[TD]RM17[/TD]
[TD]RM18[/TD]
[TD]RM19[/TD]
[TD]RM20[/TD]
[TD]RM21[/TD]
[TD]RM22[/TD]
[TD]RM23[/TD]
[TD]RM24[/TD]
[TD]RM25[/TD]
[TD]RM26[/TD]
[TD]RM27[/TD]
[TD]RM28[/TD]
[TD]RM29[/TD]
[TD]RM30[/TD]
[TD]RM31[/TD]
[TD]RM32[/TD]
[TD]RM33[/TD]
[TD]RM34[/TD]
[TD]RM35[/TD]
[TD]RM36[/TD]
[TD]RM37[/TD]
[TD]Production Date[/TD]
[TD]Month Sales[/TD]
[TD]Sales Day[/TD]
[TD]Helper Column Quantity[/TD]
[TD]Helper Column Batch Number[/TD]
[TD]Helper Column Date[/TD]
[TD]Permanent[/TD]
[TD]Temporary[/TD]
[TD]Cross Check[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]19-Mar-15[/TD]
[TD="align: left"]
clip_image001.png
clip_image001.png
clip_image001.png
clip_image001.png
clip_image001.png
Product 1

<tbody>
</tbody>
[/TD]
[TD]1234[/TD]
[TD]Type 1[/TD]
[TD]1000[/TD]
[TD]1055[/TD]
[TD]7-May-15[/TD]
[TD]10002[/TD]
[TD]A[/TD]
[TD]UAE[/TD]
[TD]1.500[/TD]
[TD]1000.00[/TD]
[TD]0.321[/TD]
[TD]1500.00[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]1.055[/TD]
[TD="align: right"]0.020[/TD]
[TD="align: right"]20.89[/TD]
[TD="align: right"]20.89[/TD]
[TD="align: right"]320.89[/TD]
[TD="align: right"]200.00[/TD]
[TD="align: right"]100.00[/TD]
[TD="align: right"]1179.11[/TD]
[TD="align: right"]20.89[/TD]
[TD="align: right"]320.889[/TD]
[TD="align: right"]791.25[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]126.60[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]137.15[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD]2015-03[/TD]
[TD]2015-05[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1055.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]7-May-15[/TD]
[TD]Product 1[/TD]
[TD]1235[/TD]
[TD]Type 1[/TD]
[TD]1000[/TD]
[TD]1055[/TD]
[TD]7-May-15[/TD]
[TD]10003[/TD]
[TD]B[/TD]
[TD]UAE[/TD]
[TD]1.500[/TD]
[TD]1000.00[/TD]
[TD]2.853[/TD]
[TD]1500.00[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]1.055[/TD]
[TD="align: right"]2.420[/TD]
[TD="align: right"]2552.89[/TD]
[TD="align: right"]2552.89[/TD]
[TD="align: right"]2852.89[/TD]
[TD="align: right"]200.00[/TD]
[TD="align: right"]100.00[/TD]
[TD="align: right"]-1352.89[/TD]
[TD="align: right"]2552.89[/TD]
[TD="align: right"]2852.889[/TD]
[TD="align: right"]791.25[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]126.60[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]137.15[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD]2015-05[/TD]
[TD]2015-05[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1055.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4-Apr-15[/TD]
[TD]Product 1[/TD]
[TD]1236[/TD]
[TD]Type 1[/TD]
[TD]1000[/TD]
[TD]1055[/TD]
[TD]7-May-15[/TD]
[TD]10004[/TD]
[TD]A[/TD]
[TD]UAE[/TD]
[TD]1.500[/TD]
[TD]1000.00[/TD]
[TD]0.321[/TD]
[TD]1500.00[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]1.055[/TD]
[TD="align: right"]0.020[/TD]
[TD="align: right"]20.89[/TD]
[TD="align: right"]20.89[/TD]
[TD="align: right"]320.89[/TD]
[TD="align: right"]200.00[/TD]
[TD="align: right"]100.00[/TD]
[TD="align: right"]1179.11[/TD]
[TD="align: right"]20.89[/TD]
[TD="align: right"]320.889[/TD]
[TD="align: right"]791.25[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]126.60[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]137.15[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD]2015-04[/TD]
[TD]2015-05[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1055.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]7-May-17[/TD]
[TD]Product 2[/TD]
[TD]1237[/TD]
[TD]Type 1[/TD]
[TD]1000[/TD]
[TD]1080[/TD]
[TD]1-Jan-00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.789[/TD]
[TD]0.00[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]1.08[/TD]
[TD="align: right"]0.453[/TD]
[TD="align: right"]488.94[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]200.00[/TD]
[TD="align: right"]100.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]488.94[/TD]
[TD="align: right"]788.940[/TD]
[TD="align: right"]680.40[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]129.60[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]129.60[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]140.40[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD]2017-05[/TD]
[TD]3000-01[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1080.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]15-May-17[/TD]
[TD]Product 2[/TD]
[TD]1238[/TD]
[TD]Type 1[/TD]
[TD]1000[/TD]
[TD]1080[/TD]
[TD]1-Jan-00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.789[/TD]
[TD]0.00[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]1.08[/TD]
[TD="align: right"]0.453[/TD]
[TD="align: right"]488.94[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]200.00[/TD]
[TD="align: right"]100.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]488.94[/TD]
[TD="align: right"]788.940[/TD]
[TD="align: right"]680.40[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]129.60[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]129.60[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]140.40[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD]2017-05[/TD]
[TD]3000-01[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1080.00[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]15-Jun-17[/TD]
[TD]Product 2[/TD]
[TD]1239[/TD]
[TD]Type 1[/TD]
[TD]1000[/TD]
[TD]1080[/TD]
[TD]1-Jan-00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.789[/TD]
[TD]0.00[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]1.08[/TD]
[TD="align: right"]0.453[/TD]
[TD="align: right"]488.94[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]200.00[/TD]
[TD="align: right"]100.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]488.94[/TD]
[TD="align: right"]788.940[/TD]
[TD="align: right"]680.40[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]129.60[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]129.60[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]140.40[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD]2017-06[/TD]
[TD]3000-01[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1080.00[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]31-Mar-16[/TD]
[TD]Product 3[/TD]
[TD]1240[/TD]
[TD]Type 1[/TD]
[TD]1000[/TD]
[TD]1200[/TD]
[TD]7-May-16[/TD]
[TD]10008&10020[/TD]
[TD]A[/TD]
[TD]UAE[/TD]
[TD]1.500[/TD]
[TD]1000.00[/TD]
[TD]0.823[/TD]
[TD]1500.00[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]1.2[/TD]
[TD="align: right"]0.436[/TD]
[TD="align: right"]522.66[/TD]
[TD="align: right"]522.66[/TD]
[TD="align: right"]822.66[/TD]
[TD="align: right"]200.00[/TD]
[TD="align: right"]100.00[/TD]
[TD="align: right"]677.34[/TD]
[TD="align: right"]522.66[/TD]
[TD="align: right"]822.661[/TD]
[TD="align: right"]504.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]396.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]144.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]156.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD]2016-03[/TD]
[TD]2016-05[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1200.00[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]4-Apr-16[/TD]
[TD]Product 3[/TD]
[TD]1241[/TD]
[TD]Type 1[/TD]
[TD]1000[/TD]
[TD]1200[/TD]
[TD]7-May-16[/TD]
[TD]10009[/TD]
[TD]B[/TD]
[TD]UAE[/TD]
[TD]1.500[/TD]
[TD]1000.00[/TD]
[TD]0.823[/TD]
[TD]1500.00[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]1.2[/TD]
[TD="align: right"]0.436[/TD]
[TD="align: right"]522.66[/TD]
[TD="align: right"]522.66[/TD]
[TD="align: right"]822.66[/TD]
[TD="align: right"]200.00[/TD]
[TD="align: right"]100.00[/TD]
[TD="align: right"]677.34[/TD]
[TD="align: right"]522.66[/TD]
[TD="align: right"]822.661[/TD]
[TD="align: right"]504.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]396.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]144.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]156.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD]2016-04[/TD]
[TD]2016-05[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1200.00[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]4-May-16[/TD]
[TD]Product 3[/TD]
[TD]1242[/TD]
[TD]Type 1[/TD]
[TD]1000[/TD]
[TD]1200[/TD]
[TD]7-May-17[/TD]
[TD]10010[/TD]
[TD]A[/TD]
[TD]UAE[/TD]
[TD]1.500[/TD]
[TD]1000.00[/TD]
[TD]0.823[/TD]
[TD]1500.00[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]1.2[/TD]
[TD="align: right"]0.436[/TD]
[TD="align: right"]522.66[/TD]
[TD="align: right"]522.66[/TD]
[TD="align: right"]822.66[/TD]
[TD="align: right"]200.00[/TD]
[TD="align: right"]100.00[/TD]
[TD="align: right"]677.34[/TD]
[TD="align: right"]522.66[/TD]
[TD="align: right"]822.661[/TD]
[TD="align: right"]504.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]396.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]144.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]156.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD]2016-05[/TD]
[TD]2017-05[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1200.00[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]29-Apr-17[/TD]
[TD]Product 4[/TD]
[TD]1243[/TD]
[TD]Type 1[/TD]
[TD]1000[/TD]
[TD]1230[/TD]
[TD]7-May-17[/TD]
[TD]10011[/TD]
[TD]B[/TD]
[TD]UAE[/TD]
[TD]1.500[/TD]
[TD]1000.00[/TD]
[TD]0.871[/TD]
[TD]1500.00[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]1.23[/TD]
[TD="align: right"]0.464[/TD]
[TD="align: right"]570.97[/TD]
[TD="align: right"]570.97[/TD]
[TD="align: right"]870.97[/TD]
[TD="align: right"]200.00[/TD]
[TD="align: right"]100.00[/TD]
[TD="align: right"]629.03[/TD]
[TD="align: right"]570.97[/TD]
[TD="align: right"]870.973[/TD]
[TD="align: right"]713.40[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]209.10[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]147.60[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]159.90[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD]2017-04[/TD]
[TD]2017-05[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1230.00[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]1-May-17[/TD]
[TD]Product 4[/TD]
[TD]1244[/TD]
[TD]Type 1[/TD]
[TD]1000[/TD]
[TD]1230[/TD]
[TD]7-May-18[/TD]
[TD]10012[/TD]
[TD]A[/TD]
[TD]UAE[/TD]
[TD]1.500[/TD]
[TD]1000.00[/TD]
[TD]0.871[/TD]
[TD]1500.00[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]1.23[/TD]
[TD="align: right"]0.464[/TD]
[TD="align: right"]570.97[/TD]
[TD="align: right"]570.97[/TD]
[TD="align: right"]870.97[/TD]
[TD="align: right"]200.00[/TD]
[TD="align: right"]100.00[/TD]
[TD="align: right"]629.03[/TD]
[TD="align: right"]570.97[/TD]
[TD="align: right"]870.973[/TD]
[TD="align: right"]713.40[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]209.10[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]147.60[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]159.90[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD]2017-05[/TD]
[TD]2018-05[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1230.00[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]5-May-17[/TD]
[TD]Product 4[/TD]
[TD]1245[/TD]
[TD]Type 1[/TD]
[TD]1000[/TD]
[TD]1230[/TD]
[TD]7-May-18[/TD]
[TD]10013[/TD]
[TD]B[/TD]
[TD]UAE[/TD]
[TD]1.500[/TD]
[TD]1000.00[/TD]
[TD]0.871[/TD]
[TD]1500.00[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]1.23[/TD]
[TD="align: right"]0.464[/TD]
[TD="align: right"]570.97[/TD]
[TD="align: right"]570.97[/TD]
[TD="align: right"]870.97[/TD]
[TD="align: right"]200.00[/TD]
[TD="align: right"]100.00[/TD]
[TD="align: right"]629.03[/TD]
[TD="align: right"]570.97[/TD]
[TD="align: right"]870.973[/TD]
[TD="align: right"]713.40[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]209.10[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]147.60[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]159.90[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD]2017-05[/TD]
[TD]2018-05[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1230.00[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]7-May-18[/TD]
[TD]Product 4[/TD]
[TD]1246[/TD]
[TD]Type 1[/TD]
[TD]1000[/TD]
[TD]1230[/TD]
[TD]7-May-18[/TD]
[TD]10014[/TD]
[TD]A[/TD]
[TD]UAE[/TD]
[TD]1.500[/TD]
[TD]1000.00[/TD]
[TD]1.466[/TD]
[TD]1500.00[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]1.23[/TD]
[TD="align: right"]0.948[/TD]
[TD="align: right"]1165.83[/TD]
[TD="align: right"]1165.83[/TD]
[TD="align: right"]1465.83[/TD]
[TD="align: right"]200.00[/TD]
[TD="align: right"]100.00[/TD]
[TD="align: right"]34.17[/TD]
[TD="align: right"]1165.83[/TD]
[TD="align: right"]1465.826[/TD]
[TD="align: right"]713.40[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]209.10[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]147.60[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]159.90[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD]2018-05[/TD]
[TD]2018-05[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1230.00[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,242
Members
452,623
Latest member
russelllowellpercy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top