Bugzilla – Attachment 899 Details for
Bug 2865
Acquisitions: GST not calculating correctly.
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
And again not as an excel spreadsheet
adding orders test schedule.htm (text/html), 71.19 KB, created by
Chris Cormack
on 2008-12-30 17:31:00 UTC
(
hide
)
Description:
And again not as an excel spreadsheet
Filename:
MIME Type:
Creator:
Chris Cormack
Created:
2008-12-30 17:31:00 UTC
Size:
71.19 KB
patch
obsolete
><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]> <![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> </td> > <td class=xl1520222></td> > <td class=xl3620222> </td> > <td class=xl3120222></td> > <td class=xl4120222> </td> > <td class=xl4220222> </td> > <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>
<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]> <![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> </td> <td class=xl1520222></td> <td class=xl3620222> </td> <td class=xl3120222></td> <td class=xl4120222> </td> <td class=xl4220222> </td> <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>
View Attachment As Raw
Actions:
View
Attachments on
bug 2865
:
898
| 899 |
7911
|
8375
|
8460
|
9212