View All Attachments for Bug 2865

Attachment #898
Test scenarios for adding orders	application/xml	2008-12-30 17:17:00 UTC	26.50 KB	no flags	Details

Attachment cannot be viewed because its MIME type is not text/*, image/*, or application/vnd.mozilla.*. Download the attachment instead.

Attachment #899
And again not as an excel spreadsheet	text/html	2008-12-30 17:31:00 UTC	71.19 KB	no flags	Details

<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<link rel=File-List href="adding%20orders%20test%20schedule_files/filelist.xml">
<style id="adding orders test schedule_20222_Styles">
<!--table
	{mso-displayed-decimal-separator:"\.";
	mso-displayed-thousand-separator:"\,";}
.xl1520222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl2220222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:700;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl2320222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl2420222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:700;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:center;
	vertical-align:bottom;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl2520222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:center;
	vertical-align:bottom;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl2620222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:0%;
	text-align:center;
	vertical-align:bottom;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl2720222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0";
	text-align:center;
	vertical-align:bottom;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl2820222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:700;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:center;
	vertical-align:bottom;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:normal;}
.xl2920222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:700;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:center;
	vertical-align:bottom;
	border-top:none;
	border-right:none;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl3020222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:700;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl3120222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:Standard;
	text-align:general;
	vertical-align:bottom;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl3220222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:700;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	mso-number-format:Standard;
	text-align:center;
	vertical-align:bottom;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl3320222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:700;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	mso-number-format:Standard;
	text-align:center;
	vertical-align:bottom;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl3420222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:none;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl3520222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:general;
	vertical-align:bottom;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl3620222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:Standard;
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl3720222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:none;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl3820222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl3920222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl4020222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:Standard;
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl4120222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:center;
	vertical-align:bottom;
	border-top:none;
	border-right:none;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl4220222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl4320222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:center;
	vertical-align:bottom;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl4420222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl4520222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:center;
	vertical-align:bottom;
	border-top:none;
	border-right:none;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	background:#FFCC99;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl4620222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:center;
	vertical-align:bottom;
	border-top:none;
	border-right:none;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	background:#CCFFCC;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl4720222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:none;
	background:#CCFFCC;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl4820222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:left;
	vertical-align:bottom;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl4920222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:none;
	background:#FFCC99;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl5020222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:center;
	vertical-align:bottom;
	border-top:none;
	border-right:none;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	background:yellow;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl5120222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:none;
	background:yellow;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl5220222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:Standard;
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:none;
	background:#CCFFCC;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl5320222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:none;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	background:#CCFFCC;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl5420222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	background:#CCFFCC;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl5520222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:center;
	vertical-align:bottom;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	background:yellow;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl5620222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	background:yellow;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl5720222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:left;
	vertical-align:bottom;
	background:#FFCC99;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl5820222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	background:#FFCC99;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl5920222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	background:#CCFFCC;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl6020222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:center;
	vertical-align:bottom;
	background:yellow;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl6120222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:16.0pt;
	font-weight:700;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl6220222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:general;
	vertical-align:bottom;
	background:#FFCC99;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl6320222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	background:#FFCC99;
	mso-pattern:auto none;
	white-space:nowrap;}
.xl6420222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:700;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:center;
	vertical-align:bottom;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl6520222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:700;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:center;
	vertical-align:bottom;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl6620222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:700;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:center;
	vertical-align:bottom;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl6720222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:16.0pt;
	font-weight:700;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:center;
	vertical-align:bottom;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
.xl6820222
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:center;
	vertical-align:bottom;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:nowrap;}
-->
</style>
</head>

<body>
<!--[if !excel]>&nbsp;&nbsp;<![endif]-->
<!--The following information was generated by Microsoft Office Excel's Publish
as Web Page wizard.-->
<!--If the same item is republished from Excel, all information between the DIV
tags will be replaced.-->
<!----------------------------->
<!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -->
<!----------------------------->

<div id="adding orders test schedule_20222" align=center x:publishsource="Excel">

<table x:str border=0 cellpadding=0 cellspacing=0 width=1850 style='border-collapse:
 collapse;table-layout:fixed;width:1388pt'>
 <col width=67 style='mso-width-source:userset;mso-width-alt:2450;width:50pt'>
 <col width=220 style='mso-width-source:userset;mso-width-alt:8045;width:165pt'>
 <col class=xl2520222 width=127 style='mso-width-source:userset;mso-width-alt:
 4644;width:95pt'>
 <col class=xl2520222 width=114 style='mso-width-source:userset;mso-width-alt:
 4169;width:86pt'>
 <col class=xl2520222 width=67 style='mso-width-source:userset;mso-width-alt:
 2450;width:50pt'>
 <col class=xl2520222 width=74 style='mso-width-source:userset;mso-width-alt:
 2706;width:56pt'>
 <col class=xl2520222 width=67 style='mso-width-source:userset;mso-width-alt:
 2450;width:50pt'>
 <col class=xl1520222 width=72 span=2 style='mso-width-source:userset;
 mso-width-alt:2633;width:54pt'>
 <col class=xl3120222 width=64 span=2 style='width:48pt'>
 <col class=xl2520222 width=74 style='mso-width-source:userset;mso-width-alt:
 2706;width:56pt'>
 <col class=xl1520222 width=64 style='width:48pt'>
 <col width=64 span=11 style='width:48pt'>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl5720222 colspan=2 width=287 style='height:12.75pt;
  width:215pt'>orange = added GST back on (bug 2865)</td>
  <td class=xl5920222 width=127 style='width:95pt'>green = correct</td>
  <td class=xl6020222 width=114 style='width:86pt'>yellow = wrong</td>
  <td class=xl2520222 width=67 style='width:50pt'></td>
  <td class=xl2520222 width=74 style='width:56pt'></td>
  <td class=xl2520222 width=67 style='width:50pt'></td>
  <td class=xl1520222 width=72 style='width:54pt'></td>
  <td class=xl1520222 width=72 style='width:54pt'></td>
  <td class=xl3120222 width=64 style='width:48pt'></td>
  <td class=xl3120222 width=64 style='width:48pt'></td>
  <td class=xl2520222 width=74 style='width:56pt'></td>
  <td class=xl1520222 width=64 style='width:48pt'></td>
  <td class=xl1520222 width=64 style='width:48pt'></td>
  <td class=xl1520222 width=64 style='width:48pt'></td>
  <td class=xl1520222 width=64 style='width:48pt'></td>
  <td class=xl1520222 width=64 style='width:48pt'></td>
  <td class=xl1520222 width=64 style='width:48pt'></td>
  <td class=xl1520222 width=64 style='width:48pt'></td>
  <td class=xl1520222 width=64 style='width:48pt'></td>
  <td class=xl1520222 width=64 style='width:48pt'></td>
  <td class=xl1520222 width=64 style='width:48pt'></td>
  <td class=xl1520222 width=64 style='width:48pt'></td>
  <td class=xl1520222 width=64 style='width:48pt'></td>
 </tr>
 <tr height=27 style='height:20.25pt'>
  <td height=27 class=xl4820222 style='height:20.25pt'></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td colspan=2 class=xl6720222>RESULTS</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=27 style='height:20.25pt'>
  <td height=27 class=xl6120222 colspan=2 style='height:20.25pt'>Test Scenarios</td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td colspan=3 class=xl6420222 style='border-right:.5pt solid black'>Expected
  Totals</td>
  <td class=xl2220222></td>
  <td colspan=2 class=xl6420222 style='border-right:.5pt solid black'>Total in
  3.0 test</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr class=xl2220222 height=53 style='mso-height-source:userset;height:39.75pt'>
  <td height=53 class=xl2220222 style='height:39.75pt'></td>
  <td class=xl2220222>Title ordered</td>
  <td class=xl2420222>Supplier</td>
  <td class=xl2820222 width=114 style='width:86pt'>Ordering price includes GST</td>
  <td class=xl2420222>discount</td>
  <td class=xl2820222 width=74 style='width:56pt'>$USD Conversion rate</td>
  <td class=xl2820222 width=67 style='width:50pt'>Unit list price</td>
  <td class=xl2920222>Budgeted</td>
  <td class=xl2820222 width=72 style='width:54pt'>known bug 2865</td>
  <td class=xl3320222>RRP</td>
  <td class=xl3220222></td>
  <td class=xl2920222>Budgeted</td>
  <td class=xl3020222>RRP</td>
  <td class=xl2220222></td>
  <td class=xl2220222></td>
  <td class=xl2220222></td>
  <td class=xl2220222></td>
  <td class=xl2220222></td>
  <td class=xl2220222></td>
  <td class=xl2220222></td>
  <td class=xl2220222></td>
  <td class=xl2220222></td>
  <td class=xl2220222></td>
  <td class=xl2220222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2220222 style='height:12.75pt'>1 copy</td>
  <td class=xl2320222>Electricity and magnetism</td>
  <td class=xl4820222>Technical Books</td>
  <td class=xl2520222>GST</td>
  <td class=xl2620222 x:num="0.15">15%</td>
  <td class=xl2520222></td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl5320222 align=right x:num="22.666666666666668"
  x:fmla="=SUM(G5/1.125)*0.85">$22.67</td>
  <td class=xl4520222 x:num="25.5" x:fmla="=H5*1.125">$25.50</td>
  <td class=xl4720222 align=right x:num="30" x:fmla="=SUM(G5)">$30.00</td>
  <td class=xl3120222></td>
  <td class=xl4520222 x:num="25.5">$25.50</td>
  <td class=xl4720222 align=right x:num="30">$30.00</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2220222 style='height:12.75pt'></td>
  <td class=xl2320222>Power to the people</td>
  <td class=xl4820222>Capital Books</td>
  <td class=xl2520222>GST</td>
  <td class=xl2620222>No</td>
  <td class=xl2520222></td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl5320222 align=right x:num="26.666666666666668"
  x:fmla="=SUM(G6/1.125)">$26.67</td>
  <td class=xl4520222 x:num="30" x:fmla="=H6*1.125">$30.00</td>
  <td class=xl5220222 align=right x:num x:fmla="=SUM(G6)">30.00</td>
  <td class=xl3120222></td>
  <td class=xl4520222 x:num="30">$30.00</td>
  <td class=xl4920222 align=right x:num="33.75">$33.75</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr class=xl1520222 height=17 style='height:12.75pt'>
  <td height=17 class=xl2220222 style='height:12.75pt'></td>
  <td class=xl2320222>Tokohia</td>
  <td class=xl4820222>South Pacific</td>
  <td class=xl2520222>No</td>
  <td class=xl2620222 x:num="0.35">35%</td>
  <td class=xl2520222></td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl4620222 x:num="19.5" x:fmla="=SUM(G7*0.65)">$19.50</td>
  <td class=xl6220222 align=right x:num="21.9375" x:fmla="=H7*1.125">$21.94</td>
  <td class=xl4720222 align=right x:num="33.75" x:fmla="=SUM(G7*1.125)">$33.75</td>
  <td class=xl3120222></td>
  <td class=xl4620222 x:num="19.5">$19.50</td>
  <td class=xl4720222 align=right x:num="33.75">$33.75</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr class=xl1520222 height=17 style='height:12.75pt'>
  <td height=17 class=xl2220222 style='height:12.75pt'></td>
  <td class=xl2320222>Your life online</td>
  <td class=xl4820222>Library Supply</td>
  <td class=xl2520222>No</td>
  <td class=xl2620222>No</td>
  <td class=xl2520222></td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl4620222 x:num="30" x:fmla="=G8">$30.00</td>
  <td class=xl6220222 align=right x:num="33.75" x:fmla="=H8*1.125">$33.75</td>
  <td class=xl4720222 align=right x:num="33.75" x:fmla="=SUM(G8*1.125)">$33.75</td>
  <td class=xl3120222></td>
  <td class=xl4620222 x:num="30">$30.00</td>
  <td class=xl4720222 align=right x:num="33.75">$33.75</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2220222 style='height:12.75pt'></td>
  <td class=xl2320222>Settlement by sail</td>
  <td class=xl4820222>Baker and Taylor</td>
  <td class=xl2520222>USD</td>
  <td class=xl2620222 x:num="0.35">35%</td>
  <td class=xl2520222 x:num="0.53249999999999997">0.5325</td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl5320222 align=right x:num="36.619718309859159"
  x:fmla="=SUM(G9/F9)*0.65">$36.62</td>
  <td class=xl6220222 align=right x:num="41.197183098591552" x:fmla="=H9*1.125">$41.20</td>
  <td class=xl5220222 align=right x:num="56.338028169014088"
  x:fmla="=SUM(G9/F9)">56.34</td>
  <td class=xl3120222></td>
  <td class=xl5020222 x:num="10.38">$10.38</td>
  <td class=xl5120222 align=right x:num="15.98">$15.98</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2220222 style='height:12.75pt'></td>
  <td class=xl2320222>Cushla and her books</td>
  <td class=xl4820222>Amazon</td>
  <td class=xl2520222>USD</td>
  <td class=xl2620222>No</td>
  <td class=xl2520222 x:num="0.53249999999999997">0.5325</td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl5320222 align=right x:num="56.338028169014088"
  x:fmla="=SUM(G10/F10)">$56.34</td>
  <td class=xl6220222 align=right x:num="63.380281690140848" x:fmla="=H10*1.125">$63.38</td>
  <td class=xl5220222 align=right x:num="56.338028169014088"
  x:fmla="=SUM(G10/F10)">56.34</td>
  <td class=xl3120222></td>
  <td class=xl5020222 x:num="15.98">$15.98</td>
  <td class=xl5120222 align=right x:num="15.98">$15.98</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=34 style='mso-height-source:userset;height:25.5pt'>
  <td height=34 class=xl2220222 style='height:25.5pt'></td>
  <td class=xl2320222></td>
  <td class=xl4820222></td>
  <td class=xl2520222></td>
  <td class=xl2620222></td>
  <td class=xl2520222></td>
  <td class=xl2720222></td>
  <td class=xl3720222>&nbsp;</td>
  <td class=xl1520222></td>
  <td class=xl3620222>&nbsp;</td>
  <td class=xl3120222></td>
  <td class=xl4120222>&nbsp;</td>
  <td class=xl4220222>&nbsp;</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2220222 style='height:12.75pt'>2 copies</td>
  <td class=xl2320222>Cloncurry story</td>
  <td class=xl4820222>Technical Books</td>
  <td class=xl2520222>GST</td>
  <td class=xl2620222 x:num="0.15">15%</td>
  <td class=xl2520222></td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl5320222 align=right x:num="45.333333333333336"
  x:fmla="=SUM(G12/1.125)*0.85*2">$45.33</td>
  <td class=xl4520222 x:num="51" x:fmla="=H12*1.125">$51.00</td>
  <td class=xl4720222 align=right x:num="30" x:fmla="=SUM(G12)">$30.00</td>
  <td class=xl3120222></td>
  <td class=xl4520222 x:num="51">$51.00</td>
  <td class=xl4720222 align=right x:num="30">$30.00</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2220222 style='height:12.75pt'></td>
  <td class=xl2320222>Alan Duff's maori heroes</td>
  <td class=xl4820222>Capital Books</td>
  <td class=xl2520222>GST</td>
  <td class=xl2620222>No</td>
  <td class=xl2520222></td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl5320222 align=right x:num="53.333333333333336"
  x:fmla="=SUM(G13/1.125)*2">$53.33</td>
  <td class=xl4520222 x:num="60" x:fmla="=H13*1.125">$60.00</td>
  <td class=xl4720222 align=right x:num="30" x:fmla="=SUM(G13)">$30.00</td>
  <td class=xl3120222></td>
  <td class=xl4520222 x:num="60">$60.00</td>
  <td class=xl4920222 align=right x:num="33.75">$33.75</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr class=xl1520222 height=17 style='height:12.75pt'>
  <td height=17 class=xl2220222 style='height:12.75pt'></td>
  <td class=xl2320222>Statistics</td>
  <td class=xl4820222>South Pacific</td>
  <td class=xl2520222>No</td>
  <td class=xl2620222 x:num="0.35">35%</td>
  <td class=xl2520222></td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl4620222 x:num="39" x:fmla="=SUM(G14*0.65)*2">$39.00</td>
  <td class=xl6220222 align=right x:num="43.875" x:fmla="=H14*1.125">$43.88</td>
  <td class=xl4720222 align=right x:num="33.75" x:fmla="=SUM(G14*1.125)">$33.75</td>
  <td class=xl3120222></td>
  <td class=xl4620222 x:num="39">$39.00</td>
  <td class=xl4720222 align=right x:num="33.75">$33.75</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr class=xl1520222 height=17 style='height:12.75pt'>
  <td height=17 class=xl2220222 style='height:12.75pt'></td>
  <td class=xl2320222>Guide Rangi</td>
  <td class=xl4820222>Library Supply</td>
  <td class=xl2520222>No</td>
  <td class=xl2620222>No</td>
  <td class=xl2520222></td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl4620222 x:num="60" x:fmla="=G15*2">$60.00</td>
  <td class=xl6220222 align=right x:num="67.5" x:fmla="=H15*1.125">$67.50</td>
  <td class=xl4720222 align=right x:num="33.75" x:fmla="=SUM(G15*1.125)">$33.75</td>
  <td class=xl3120222></td>
  <td class=xl4620222 x:num="60">$60.00</td>
  <td class=xl4720222 align=right x:num="33.75">$33.75</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2220222 style='height:12.75pt'></td>
  <td class=xl2320222>Volunteering and ethnic comnunities</td>
  <td class=xl4820222>Baker and Taylor</td>
  <td class=xl2520222>USD</td>
  <td class=xl2620222 x:num="0.35">35%</td>
  <td class=xl2520222 x:num="0.53249999999999997">0.5325</td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl5320222 align=right x:num="73.239436619718319"
  x:fmla="=SUM(G16/F16)*0.65*2">$73.24</td>
  <td class=xl6220222 align=right x:num="82.394366197183103" x:fmla="=H16*1.125">$82.39</td>
  <td class=xl4720222 align=right x:num="56.338028169014088"
  x:fmla="=SUM(G16/F16)">$56.34</td>
  <td class=xl3120222></td>
  <td class=xl5020222 x:num="20.76">$20.76</td>
  <td class=xl5120222 align=right x:num="15.98">$15.98</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2220222 style='height:12.75pt'></td>
  <td class=xl2320222>Babies need books</td>
  <td class=xl4820222>Amazon</td>
  <td class=xl2520222>USD</td>
  <td class=xl2620222>No</td>
  <td class=xl2520222 x:num="0.53249999999999997">0.5325</td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl5420222 align=right x:num="112.67605633802818"
  x:fmla="=SUM(G17/F17)*2">$112.68</td>
  <td class=xl6320222 align=right x:num="126.7605633802817" x:fmla="=H17*1.125">$126.76</td>
  <td class=xl4720222 align=right x:num="56.338028169014088"
  x:fmla="=SUM(G17/F17)">$56.34</td>
  <td class=xl3120222></td>
  <td class=xl5520222 x:num="31.96">$31.96</td>
  <td class=xl5620222 align=right x:num="15.98">$15.98</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2320222 style='height:12.75pt'></td>
  <td class=xl2320222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2320222 style='height:12.75pt'></td>
  <td class=xl2320222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=27 style='height:20.25pt'>
  <td height=27 class=xl6120222 colspan=2 style='height:20.25pt'>Findings</td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2220222 colspan=2 style='height:12.75pt'>Worked
  perfectly for both budget and RRP</td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2320222 style='height:12.75pt'>1 copy</td>
  <td class=xl2320222>Tokohia</td>
  <td class=xl4820222>South Pacific</td>
  <td class=xl2520222>No</td>
  <td class=xl2620222 x:num="0.35">35%</td>
  <td class=xl2520222></td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl4120222 x:num="19.5" x:fmla="=SUM(G22*0.65)">$19.50</td>
  <td class=xl3520222 align=right x:num="21.9375" x:fmla="=H22*1.125">$21.94</td>
  <td class=xl4220222 align=right x:num="33.75" x:fmla="=SUM(G22*1.125)">$33.75</td>
  <td class=xl3120222></td>
  <td class=xl4120222 x:num="19.5">$19.50</td>
  <td class=xl4220222 align=right x:num="33.75">$33.75</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2320222 style='height:12.75pt'>1 copy</td>
  <td class=xl2320222>Your life online</td>
  <td class=xl4820222>Library Supply</td>
  <td class=xl2520222>No</td>
  <td class=xl2620222>No</td>
  <td class=xl2520222></td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl4120222 x:num="30" x:fmla="=G23">$30.00</td>
  <td class=xl3520222 align=right x:num="33.75" x:fmla="=H23*1.125">$33.75</td>
  <td class=xl4220222 align=right x:num="33.75" x:fmla="=SUM(G23*1.125)">$33.75</td>
  <td class=xl3120222></td>
  <td class=xl4120222 x:num="30">$30.00</td>
  <td class=xl4220222 align=right x:num="33.75">$33.75</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2320222 style='height:12.75pt'>2 copies</td>
  <td class=xl2320222>Statistics</td>
  <td class=xl4820222>South Pacific</td>
  <td class=xl2520222>No</td>
  <td class=xl2620222 x:num="0.35">35%</td>
  <td class=xl2520222></td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl4120222 x:num="39" x:fmla="=SUM(G24*0.65)*2">$39.00</td>
  <td class=xl3520222 align=right x:num="43.875" x:fmla="=H24*1.125">$43.88</td>
  <td class=xl4220222 align=right x:num="33.75" x:fmla="=SUM(G24*1.125)">$33.75</td>
  <td class=xl3120222></td>
  <td class=xl4120222 x:num="39">$39.00</td>
  <td class=xl4220222 align=right x:num="33.75">$33.75</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2320222 style='height:12.75pt'>2 copies</td>
  <td class=xl2320222>Guide Rangi</td>
  <td class=xl4820222>Library Supply</td>
  <td class=xl2520222>No</td>
  <td class=xl2620222>No</td>
  <td class=xl2520222></td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl4120222 x:num="60" x:fmla="=G25*2">$60.00</td>
  <td class=xl3520222 align=right x:num="67.5" x:fmla="=H25*1.125">$67.50</td>
  <td class=xl4220222 align=right x:num="33.75" x:fmla="=SUM(G25*1.125)">$33.75</td>
  <td class=xl3120222></td>
  <td class=xl4120222 x:num="60">$60.00</td>
  <td class=xl4220222 align=right x:num="33.75">$33.75</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 style='height:12.75pt'></td>
  <td class=xl1520222></td>
  <td class=xl4820222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 style='height:12.75pt'></td>
  <td class=xl1520222></td>
  <td class=xl4820222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2220222 colspan=5 style='height:12.75pt'>Added GST back
  on to the budget price (bug 2865) but calculated the RRP perfectly</td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 style='height:12.75pt'>1 copy</td>
  <td class=xl2320222>Electricity and magnetism</td>
  <td class=xl4820222>Technical Books</td>
  <td class=xl2520222>GST</td>
  <td class=xl2620222 x:num="0.15">15%</td>
  <td class=xl2520222></td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl3420222 align=right x:num="22.666666666666668"
  x:fmla="=SUM(G29/1.125)*0.85">$22.67</td>
  <td class=xl4120222 x:num="25.5" x:fmla="=H29*1.125">$25.50</td>
  <td class=xl4220222 align=right x:num="30" x:fmla="=SUM(G29)">$30.00</td>
  <td class=xl3120222></td>
  <td class=xl4120222 x:num="25.5">$25.50</td>
  <td class=xl4220222 align=right x:num="30">$30.00</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 style='height:12.75pt'>2 copies</td>
  <td class=xl2320222>Cloncurry story</td>
  <td class=xl4820222>Technical Books</td>
  <td class=xl2520222>GST</td>
  <td class=xl2620222 x:num="0.15">15%</td>
  <td class=xl2520222></td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl3420222 align=right x:num="45.333333333333336"
  x:fmla="=SUM(G30/1.125)*0.85*2">$45.33</td>
  <td class=xl4120222 x:num="51" x:fmla="=H30*1.125">$51.00</td>
  <td class=xl4220222 align=right x:num="30" x:fmla="=SUM(G30)">$30.00</td>
  <td class=xl3120222></td>
  <td class=xl4120222 x:num="51">$51.00</td>
  <td class=xl4220222 align=right x:num="30">$30.00</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 style='height:12.75pt'></td>
  <td class=xl1520222></td>
  <td class=xl4820222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 style='height:12.75pt'></td>
  <td class=xl1520222></td>
  <td class=xl4820222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2220222 colspan=3 style='height:12.75pt'>Added GST onto
  both the budget price (bug 2865) and the RRP</td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 style='height:12.75pt'>1 copy</td>
  <td class=xl2320222>Power to the people</td>
  <td class=xl4820222>Capital Books</td>
  <td class=xl2520222>GST</td>
  <td class=xl2620222>No</td>
  <td class=xl2520222></td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl3420222 align=right x:num="26.666666666666668"
  x:fmla="=SUM(G34/1.125)">$26.67</td>
  <td class=xl4120222 x:num="30" x:fmla="=H34*1.125">$30.00</td>
  <td class=xl3620222 align=right x:num x:fmla="=SUM(G34)">30.00</td>
  <td class=xl3120222></td>
  <td class=xl4120222 x:num="30">$30.00</td>
  <td class=xl4220222 align=right x:num="33.75">$33.75</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 style='height:12.75pt'>2 copies</td>
  <td class=xl2320222>Alan Duff's maori heroes</td>
  <td class=xl4820222>Capital Books</td>
  <td class=xl2520222>GST</td>
  <td class=xl2620222>No</td>
  <td class=xl2520222></td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl3420222 align=right x:num="53.333333333333336"
  x:fmla="=SUM(G35/1.125)*2">$53.33</td>
  <td class=xl4120222 x:num="60" x:fmla="=H35*1.125">$60.00</td>
  <td class=xl3620222 align=right x:num x:fmla="=SUM(G35)">30.00</td>
  <td class=xl3120222></td>
  <td class=xl4120222 x:num="60">$60.00</td>
  <td class=xl4220222 align=right x:num="33.75">$33.75</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 style='height:12.75pt'></td>
  <td class=xl1520222></td>
  <td class=xl4820222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 style='height:12.75pt'></td>
  <td class=xl1520222></td>
  <td class=xl4820222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2220222 colspan=2 style='height:12.75pt'>Miscalculated
  the currency conversion</td>
  <td class=xl4820222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 style='height:12.75pt'>1 copy</td>
  <td class=xl2320222>Settlement by sail</td>
  <td class=xl4820222>Baker and Taylor</td>
  <td class=xl2520222>USD</td>
  <td class=xl2620222 x:num="0.35">35%</td>
  <td class=xl2520222 x:num="0.53249999999999997">0.5325</td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl3420222 align=right x:num="36.619718309859159"
  x:fmla="=SUM(G39/F39)*0.65">$36.62</td>
  <td class=xl3520222 align=right x:num="41.197183098591552" x:fmla="=H39*1.125">$41.20</td>
  <td class=xl3620222 align=right x:num="56.338028169014088"
  x:fmla="=SUM(G39/F39)">56.34</td>
  <td class=xl3120222></td>
  <td class=xl4120222 x:num="10.38">$10.38</td>
  <td class=xl4220222 align=right x:num="15.98">$15.98</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 style='height:12.75pt'>1 copy</td>
  <td class=xl2320222>Cushla and her books</td>
  <td class=xl4820222>Amazon</td>
  <td class=xl2520222>USD</td>
  <td class=xl2620222>No</td>
  <td class=xl2520222 x:num="0.53249999999999997">0.5325</td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl3420222 align=right x:num="56.338028169014088"
  x:fmla="=SUM(G40/F40)">$56.34</td>
  <td class=xl3520222 align=right x:num="63.380281690140848" x:fmla="=H40*1.125">$63.38</td>
  <td class=xl3620222 align=right x:num="56.338028169014088"
  x:fmla="=SUM(G40/F40)">56.34</td>
  <td class=xl3120222></td>
  <td class=xl4120222 x:num="15.98">$15.98</td>
  <td class=xl4220222 align=right x:num="15.98">$15.98</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 style='height:12.75pt'>2 copies</td>
  <td class=xl2320222>Volunteering and ethnic comnunities</td>
  <td class=xl4820222>Baker and Taylor</td>
  <td class=xl2520222>USD</td>
  <td class=xl2620222 x:num="0.35">35%</td>
  <td class=xl2520222 x:num="0.53249999999999997">0.5325</td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl3420222 align=right x:num="73.239436619718319"
  x:fmla="=SUM(G41/F41)*0.65*2">$73.24</td>
  <td class=xl3520222 align=right x:num="82.394366197183103" x:fmla="=H41*1.125">$82.39</td>
  <td class=xl3620222 align=right x:num="56.338028169014088"
  x:fmla="=SUM(G41/F41)">56.34</td>
  <td class=xl3120222></td>
  <td class=xl4120222 x:num="20.76">$20.76</td>
  <td class=xl4220222 align=right x:num="15.98">$15.98</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 style='height:12.75pt'>2 copies</td>
  <td class=xl2320222>Babies need books</td>
  <td class=xl4820222>Amazon</td>
  <td class=xl2520222>USD</td>
  <td class=xl2620222>No</td>
  <td class=xl2520222 x:num="0.53249999999999997">0.5325</td>
  <td class=xl2720222 x:num="30">$30</td>
  <td class=xl3820222 align=right x:num="112.67605633802818"
  x:fmla="=SUM(G42/F42)*2">$112.68</td>
  <td class=xl3920222 align=right x:num="126.7605633802817" x:fmla="=H42*1.125">$126.76</td>
  <td class=xl4020222 align=right x:num="56.338028169014088"
  x:fmla="=SUM(G42/F42)">56.34</td>
  <td class=xl3120222></td>
  <td class=xl4320222 x:num="31.96">$31.96</td>
  <td class=xl4420222 align=right x:num="15.98">$15.98</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 style='height:12.75pt'></td>
  <td class=xl1520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 style='height:12.75pt'></td>
  <td class=xl1520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=27 style='height:20.25pt'>
  <td height=27 class=xl6120222 colspan=2 style='height:20.25pt'>Conclusions</td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 align=right style='height:12.75pt' x:num>1</td>
  <td class=xl1520222 colspan=19>Where a Vendor profile has been set with list
  (ordering) price as not including GST the budgeted price and replacement
  costs are calculated perfectly, regardless of whether a discount applies or
  not, and regardless of whether 1 or multiles copies are ordered.</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 align=right style='height:12.75pt' x:num>2</td>
  <td class=xl1520222 colspan=23
  x:str="Where the Vendor profile has been set with list or ordering price as including GST, and a discount applies, then Koha is correctly removing the GST, correctly removing the discount and then INCORRECTLY adding GST back on again. Ordering 1 or multiple, and varoious discounts are handled fine.  ">Where
  the Vendor profile has been set with list or ordering price as including GST,
  and a discount applies, then Koha is correctly removing the GST, correctly
  removing the discount and then INCORRECTLY adding GST back on again. Ordering
  1 or multiple, and varoious discounts are handled fine.<span
  style='mso-spacerun:yes'>  </span></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 align=right style='height:12.75pt' x:num>3</td>
  <td class=xl1520222 colspan=15>Where the Vendor profile has been set with
  list or ordering price as including GST but NO discount, Koha is adding GST
  on top of the both the list and the RRP price. Ordering 1 or multiple copies
  makes no difference.</td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520222 align=right style='height:12.75pt' x:num>4</td>
  <td class=xl1520222 colspan=3>Foreign currency conversions a mess. Will bug
  this seperately.</td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl3120222></td>
  <td class=xl3120222></td>
  <td class=xl2520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
  <td class=xl1520222></td>
 </tr>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=67 style='width:50pt'></td>
  <td width=220 style='width:165pt'></td>
  <td width=127 style='width:95pt'></td>
  <td width=114 style='width:86pt'></td>
  <td width=67 style='width:50pt'></td>
  <td width=74 style='width:56pt'></td>
  <td width=67 style='width:50pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=74 style='width:56pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
 </tr>
 <![endif]>
</table>

</div>


<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>

</html>

Attachment #7911
Makes corrections to acq.js and parcel.pl regarding gst and discount calculations	patch	2012-02-27 23:55:48 UTC	2.11 KB	no flags	Details

Attachment #8375
parcel table : needs value of tax not tax rate	application/vnd.openxmlformats-officedocument.wordprocessingml.document	2012-03-20 17:03:49 UTC	169.15 KB	no flags	Details

Attachment cannot be viewed because its MIME type is not text/*, image/*, or application/vnd.mozilla.*. Download the attachment instead.

Attachment #8460
Corrected errors in previous patch	patch	2012-03-22 04:34:09 UTC	3.29 KB	no flags	Details

Attachment #9212
corrects errors in acquisitions calculations	patch	2012-04-15 23:18:10 UTC	7.13 KB	no flags	Details