SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_name` IN ('Handheld Calculators','Business & Financial Calculators','Graphing & Scientific Calculators','Printing Calculators','Desktop Display Calculators')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%Calculators' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Calculators' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Calculators' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Calculators"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Calculators"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Calculators"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Calculators"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Calculators' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Calculators',`category_4` ='Calculators') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Calculators,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Calculators', `pinfo`.`desc_title`)) DESC
Up to 10 graphing functions defined, saved, graphed and analyzed at one time
Sequence graphing mode shows time series plot, cobweb/stair-step plot and phase plots
User-defined list names. Lists store up to 999 elements
17 interactive zoom features
Numeric evaluations given in table format for all graphing modes
Interactive analysis of function values, roots, maximums, minimums, integrals and derivatives
8 different graph styles for differentiating the look of each graph drawn
Horizontal and vertical split- screen options
View graph and table side-by-side
Stores up to 10 - 50x50 matrices
Matrix operations including inverse, determinant, transpose, augment, reduced row echelon form and elementary row operations. Convert matrices to lists and vice-versa
List-based one- and two-variable statistical analysis, including logistic, sinusoidal, median-median, linear, logarithmic, exponential, power, quadratic polynomial, cubic polynomial, and quartic polynomial regression models
3 statistical plot definitions for scatter plots, xy-line plots, histograms, regular and modified box-and-whisker plots, and normal probability plots
Advanced statistics features including 10 hypothesis testing functions, 7 confidence interval functions and one-way analysis of variance
15 probability distribution functions including Normal, Student-t, Chi-square, Binomial, and Poisson
Business functions including Time-Value-of-Money (TVM), cash flows, and amortization. Full screen interactive editor for solving TVM problems
Interactive equation solver editor allows solving numerically for different variables in an equation
11 Regression calculations
(1)
Time & Value
Cash flow
Amortization
Interest Rate Conversion
Business Equation
Rectangular Equation
Polar Equation
Parametric Equation
Binary
Hyperbolic
Trigonometry
Logarithm
Matrix
Simultaneous Equation
Boolean Logic
(1)
Square Root
Change Sign Key (+/-)
(1)
Change Sign
(1)
Tax Function
Percent
Square Root
Four-key Memory
Backspace
Change Sign
Grand Total
Automatic Constants
(1)
Pi (?)
Numeric Equation
Polynomial Equation
System of Linear Equation
Numeric Derivative
Integral
Matrices
Vector
Stacked Fraction
Fraction
Fraction/Decimal/Percent Conversion
Improper Fraction
Mixed Number
Simplification of Fraction
Random Integer Generator
Random Number
Permutation
Combination
Trigonometry
Hyperbolic
Logs
Antilogs
Angle Conversion (Deg, Rad, Grad)
Percentage (%)
Square (x²)
Inverse (1/x)
y?x
Factorial (x!)
20 x Physical Constant
18 x Metric/English Conversion
8 x Pending Operation
23 x Levels of Parentheses
Auto Power Off
Error Recovery
7 x Memory Variables (x,y,z,t,a,b,c)
Scientific and Engineering Notation
(1)
Fraction Simplification
Decimal conversion
percentage
Stacked
Integer division
Constant operators
Pi
Power
Roots
Reciprocals
Exact Radicals
(1)
Trigonometric functions in degrees and radians Fractions
Orders less than $75 will incur a $9.99 shipping charge.
For items that are unable to ship via UPS, such as furniture, shipping charges will be quoted on a per shipment basis. You will be contacted if these fees apply to your order.