UC Spark

Associate Professor John Frederick Raffensperger

Management

Fields of Research

  • Market approaches for solving environmental problems
  • Inventory control & management
  • Math modelling, linear and integer programming
  • Nutrition and diet planning
  • Scheduling of production and work force
  • Smart markets
  • Spreadsheets and spreadsheet auditing
  • Using computers & math models to solve business problems
  • Water allocation and management

Researcher Summary

Research interests include the environment, especially management and allocation of fresh water and market models for sustainable fresh water. Operations research applications to public policy, including problems of nutrition and education. Methods of teaching operations research. Spreadsheets, spreadsheet layout and readability, data visualisation as it relates to optimisation. Any interesting problems in integer programming and combinatorial optimisation.

Subject Area: Disciplines

Research Groups

Key Methodologies

  • Smart markets
  • Math modelling, linear and integer programming

Affiliations

Publications


  • Pinto, A.A., Raffensperger, J.F., Cochrane, T.A. and Read, E.G. (2013) A proposed smart market design for sediment discharge. Journal of Water Resources Planning and Management 139(1): 96-108. http://dx.doi.org/10.1061/(ASCE)WR.1943-5452.0000228. (Journal Article)
  • Prabodanie, R.A.R., Raffensperger, J.F., Read, E.G. and Milke, M.W. (2013) LP models for pricing diffuse nitrate discharge permits. Annals of Operations Research (early access online) http://dx.doi.org/10.1007/s10479-011-0941-0. (Journal Article)
  • Dye, S., Jackson, P.R., James, R., Mahakalanda, I., Pinto, A., Raffensperger, J.F., Read, E.G., Read, R.A. and Starkey, S.R. (2012) Integrated Modelling of Electricity and Water Markets: A Progress Report From Canterbury. Auckland, New Zealand: EPOC Winter Workshop, 6 Jul 2012. http://www.epoc.org.nz/ww2012.html. (Conference Contribution - Oral presentation)
  • Mahakalanda, I., Dye, S., James, R., Raffensperger, J.F. and Read, E.G. (2012) Using Constructive Dual DP to Clear Water Markets in a Multi-Use Catchment: An Illustrative Example. Auckland, New Zealand: EPOC Winter Workshop, 6 Jul 2012. http://www.epoc.org.nz/ww2012.html. (Conference Contribution - Full conference paper)
  • Raffensperger, J.F. (2011) A Tutorial on Smart Markets. ORbit September Newsletter. (Other)
  • Starkey, S.R., Dye, S., Read, E.G., Raffensperger, J.F. and Ring, B.J. (2011) Enhancing Urban Water Allocation: An Evolving Framework for Trading Stochastically. Melbourne, Australia: Conference for the International Federation of Operational Research Societies (IFORS 2011), 10-15 Jul 2011. (Conference Contribution - Full conference paper)
  • Raffensperger, J.F. (2011) The value of dietary supplements. In R.R. Watson, J.K. Gerald and V.R. Preedy (Ed.), Nutrients, Dietary Supplements, and Nutriceuticals: Cost Analysis Versus Clinical Benefits: 41-53. Tucson: Humana Press, Springer. http://dx.doi.org/10.1007/978-1-60761-308-4. (Chapter in Book)
  • Prabodanie, R.A.R., Raffensperger, J.F., Milke, M.W. and Read, G. (2010) A pollution offset system for trading non-point source water pollution permits. Environmental and Resource Economics 45(4): 499-515. http://dx.doi.org/10.1007/s10640-009-9325-1. (Journal Article)
  • Teasley, R., Raffensperger, J. and Milke, M. (2010) A Smart Market for Ground and Surface Water with Hydropower Generation. Providence, RI, USA: 2010 World Environmental & Water Resources Congress, 16-20 May 2010. In Challenges of Change: Proceedings of the World Environmental and Water Resources Congress 2010 1021-1029. http://dx.doi.org/10.1061/41114(371)112. (Conference Contribution - Paper in published proceedings)
  • Teasley, R., Milke, M., Raffensperger, J.F. and Zargar, M. (2010) Common Pool Water Markets and Their Role in Facilitating Land Use Change in Drying Climates. San Francisco, CA, USA: American Geophysical Union Fall Meeting, 13-17 Dec 2010. (Conference Contribution - Poster presentation)
  • Raffensperger, J.F. (2010) Outline of a market for ecological connectivity. Auckland, New Zealand: Operations Research Society of New Zealand (ORSNZ), 29-30 Nov 2010. (Conference Contribution - Full conference paper)
  • Zargar, M., Teasley, R.L., Milke, M. and Raffensperger J.F. (2010) Varying water user demand curves in a groundwater smart market. University of Otago, Dunedin, New Zealand: New Zealand Hydrological Society Annual Conference, 6-10 Dec 2010. 154-155. (Conference Contribution - Abstract)
  • Raffensperger, J.F., Milke, M.W. and Read, E.G. (2009) A Deterministic Smart Market Model for Ground Water. Operations Research 57(6): 1333-1346. http://dx.doi.org/10.1287/opre.1090.0730. (Journal Article)
  • Raffensperger, J.F. (2009) A fast column generation algorithm for the regionalization problem. Chicago, IL, USA: 20th International Symposium on Math Programming, 23-28 Aug 2009. (Conference Contribution - Abstract)
  • Pinto, A., Raffensperger, J.F., Cochrane, T. and Dye, S. (2009) A Proposed Smart Market for Impervious Cover Runoff under Rainfall Uncertainty. University of Canterbury, Christchurch, New Zealand: 44th Annual Operations Research Society of New Zealand Annual Conference (ORSNZ2009), 3-4 Dec 2009. In Proceedings 190-199. (Conference Contribution - Paper in published proceedings)
  • Ranga Prabodanie, R.A. and Raffensperger, J.F. (2009) Can Markets in Agricultural Discharge Permits be Competitive? Christchurch, New Zealand: 44th Annual ORSNZ Conference, 3-4 Dec 2009. (Conference Contribution - Full conference paper)
  • Raffensperger, J. (2009) Introducing PLOVER 2k: Planning openings and values for Lake Ellesmere's resilience. Lincoln University, Lincoln, New Zealand: Living Lakes Symposium 2, 4 Nov 2009. (Conference Contribution - Full conference paper)
  • Raffensperger, J. (2009) Matching Users' Rights to Available Ground Water with a Smart Market. Alexandroupolis, Greece: 2nd International Conference on Water Economics, Statistics and Finance, 3-5 Jul 2009. (Conference Contribution - Full conference paper)
  • Raffensperger, J.F. and Hughey, K. (2009) Modelling Values of Lake Ellesmere. Christchurch, New Zealand: 44th Annual ORSNZ Conference, 3-4 Dec 2009. (Conference Contribution - Full conference paper)
  • Prabodanie, R.A.R., Raffensperger, J.F. and Milke, M.W. (2009) Simulation-optimization approach for trading point and non-point source nutrient permits. Cairns, Australia: 18th World IMACS Congress and MODSIM09 International Congress on Modelling and Simulation, 13-17 Jul 2009. In Proceedings of the 18th IMACS World Congress and MODSIM09 International Congress on Modelling and Simulation 233-239. http://www.mssanz.org.au/modsim09/A3/prabodanie.pdf. (Conference Contribution - Paper in published proceedings)
  • William, G., Milke, M.W. and Raffensperger, J.F. (2009) Survey of New Zealand Hydrologists on Information Needs. Journal of Hydrology (New Zealand) 48(1): 1-12. (Journal Article)
  • Gabzdylova, B., Raffensperger, J. and Castka, P. (2009) Sustainability in the New Zealand wine industry: drivers, stakeholders and practices. Journal of Cleaner Production 17(11): 992-998. (Journal Article)
  • Raffensperger, J.F. (2008) A New Algorithm for the Collection Area Problem. Wellington, New Zealand: 43rd Annual Conference of the Operational Research Society of New Zealand (ORSNZ), 24-25 Nov 2008. (Conference Contribution - Full conference paper)
  • Pinto, A., Cochrane, T.A. and Raffensperger, J.F. (2008) A Proposed Smart Market for Sediment Discharge. Victoria University of Wellington, Wellington, New Zealand: 43rd Annual Conference of the Operational Research Society of New Zealand (ORSNZ), 24-25 Nov 2008. In Proceedings of the 43rd Annual Conference of the Operational Research Society of New Zealand (ORSNZ) 140-149. (Conference Contribution - Paper in published proceedings)
  • Raffensperger, J.F. and Pascal, R. (2008) Constructive complexity: a metric for spreadsheet design. International Journal of Information and Operations Management Education 2(4): 388-406. http://dx.doi.org/10.1504/IJIOME.2008.023441. (Journal Article)
  • Raffensperger, J.F. (2008) Min Spanning Tree in a Spreadsheet? The Limits of Spreadsheet Modeling. Washington, DC, USA: The Institute for Operational Research and the Management Sciences Annual Meeting 2008, 12-15 Oct 2008. (Conference Contribution - Oral presentation)
  • Raffensperger, J.F. and Milke, M. (2008) Nutrient trading in Lake Taupo: getting it right. National Business Review(14 Mar 2008): 49. (Other)
  • Raffensperger, J.F. and Schrage, L.E. (2008) Scheduling training for a tank battalion: How to measure readiness. Computers & Operations Research 35(6): 1844-1864. http://dx.doi.org/10.1016/j.cor.2006.09.014. (Journal Article)
  • Pinto, A., Cochrane, T.A. and Raffensperger, J.F. (2008) Smart Markets and Improved Management of Sediment Discharge. Auckland Regional Council. 42. (Report for External Body)
  • Raffensperger, J.F. (2008) Smart Markets for Water Resources. Washington, DC, USA: The Institute for Operations Research and the Management Sciences (INFORMS) Annual Meeting 2008, 12-15 Oct 2008. (Conference Contribution - Oral presentation)
  • Hasan, M.B. and Raffensperger, J.F. (2008) Two pricing methods for solving an integrated commercial fishery planning model. Orion 24(2): 115-130. (Journal Article)
  • Hasan, M.B. and Raffensperger, J.F. (2007) A Decomposition-Based Pricing Method for Solving a Large-Scale MILP Model for an Integrated Fishery. Journal of Applied Math and Decision Sciences 2007: Article ID 56404. http://dx.doi.org/10.1155/2007/56404. (Journal Article)
  • Plagmann, M. and Raffensperger, J.F. (2007) A Smart Market for Ground Water using the Eigenmodel Approach. Christchurch, New Zealand: MODSIM 2007 International Congress on Modelling and Simulation, 10-13 Dec 2007. In MODSIM 2007 International Congress on Modelling and Simulation Proceedings 2097-2103. (Conference Contribution - Paper in published proceedings)
  • John F. Raffensperger. (2007) An operations research framework for water ethics (invited presentation). Beijing, China: PKU-UNESCO International Symposium on Ethics of Water Resource Management, 6 Nov 2007. (Conference Contribution - Abstract)
  • Prabodanie, R.A.R. and Raffensperger, J.F. (2007) Cleaning the Water: a Smart Market for Nitrates. Christchurch, New Zealand: MODSIM 2007 International Congress on Modelling and Simulation, 10-13 Dec 2007. In MODSIM 2007 International Congress on Modelling and Simulation Proceedings 2333-2339. (Conference Contribution - Paper in published proceedings)
  • Gabzdylova, B., Raffensperger, J. and Castka, P. (2007) Corporate Social Responsibility: environmental concern in New Zealand's wine industry. Dunedin, New Zealand: Australian and New Zealand Marketing Academy (ANZMAC) Conference 2007, 3-5 Dec 2007. In ANZMAC 2007 Conference Proceedings 2350-2357. (Conference Contribution - Paper in published proceedings)
  • John F. Raffensperger. (2007) Smart Markets - the Answer to Australia's Water Crisis. Melbourne, Australia: 19th National Conference of the Australian Society for Operations Research, 3-5 Dec 2007. (Conference Contribution - Abstract)
  • Hasan, M.B. and Raffensperger, J.F. (2006) A mixed integer linear program for an integrated fishery. Orion 22(1): 19-34. (Journal Article)
  • Raffensperger, J.F. (2006) A tutorial on hydrogeological optimisation. Christchurch: The ORSNZ Conference 2006, 30 Nov-1 Dec 2006. (Conference Contribution - Full conference paper)
  • Dean, H.T., Tu, Y. and Raffensperger, J. (2006) An improved method for calculating the no-fit polygon. Computers & Operations Research 33(6): 1521-1539. http://dx.doi.org/10.1016/j.cor.2004.11.005. (Journal Article)
  • Raffensperger, J.F. and Milke, M.W. (2006) How to Solve Our Water Crisis: a Demo Spot Market for Ground Water. Golden, CO, USA: MODFLOW and More 2006: Managing Ground Water Systems, 22-24 May 2006. In Proceedings 414-418. http://hdl.handle.net/10092/96. (Conference Contribution - Full conference paper)
  • Hassan, M.B. and Raffensperger, J.F. (2006) Relaxation and Decomposition Methods for Solving MILP for an Integrated Fishery. Townsville, Australia: Computational and Technology Application Conference, 2-5 Jul 2006. (Conference Contribution - Other)
  • Milke, M. and Raffensperger, J. (2006) The Use of Spot Markets for Water Allocation. Auckland, New Zealand: Water2006, 2-4 Aug 2006. In Proceedings 12pp. http://hdl.handle.net/10092/453. (Conference Contribution - Paper in published proceedings)
  • Raffensperger, J.F. and Milke, M. (2005) A Design for a Fresh Water Spot Market. Rethymno, Crete, Greece: International Water Association Conference on Economics, Statistics, and Finance, Jul 2005. http://www.iwaponline.com/ws/00506/ws005060217.htm. (Conference Contribution - Full conference paper)
  • Raffensperger, J.F. and Milke, M. (2005) National Workshop on Consent Trading: New Options for New Zealand. Auckland, NZ: National Workshop on Consent Trading: New Options for New Zealand, 28 Nov 2005. http://www.hydrologynz.org.nz/ak1cir.html. (Conference Contribution - Other)
  • Raffensperger, J.F. and Milke, M. (2005) Trading of consented groundwater allocations via auctions. Auckland, New Zealand: NZHS-IAH-NZSSS Auckland 2005 Conference, 28 Nov-2 Dec 2005. http://www.hydrologynz.org.nz/ak1cir.html. (Conference Contribution - Full conference paper)
  • Chang, H., Raffensperger, J.F. and Churcher, N. (2004) Displaying Linear Programs and Their Solutions With XML and SVG. Christchurch, New Zealand: Australasian Symposium on Information Visualisation (InVis.au), 23-24 Jan 2004. In Proceedings of InVis.au 2004 CRPIT 35 141-150. http://www.informatik.uni-trier.de/~ley/db/conf/apvis/apvis2004.html. (Conference Contribution - Paper in published proceedings)
  • Raffensperger, J.F. and Schrage, L. (2003) Scheduling Prowler Training. Naval Research Logistics 50(4): 289-305. (Journal Article)
  • Raffensperger, J. (2002) Just-in-time or JIT, Kanban [invited contribution]. In HG Daellenbach & RL Flood (Ed.), 'The Informed Student Guide to Management Sciences': 159. Cornwall, GB: Thomson Press. (Chapter in Book)
  • Raffensperger, J.F. (2002) Slow Snow Sliders - the Newsboy hits the New Zealand ski slopes. Management Case Quarterly 5(4): 47. (Journal Article)
  • Raffensperger, J. (2002) 'Spreadsheets' invited contribution. In H.G. Daellenbach & R.L. Flood (Ed.), 'The Informed Student Guide to Management Sciences': 253. Cornwall, GB: Thomson Press. (Chapter in Book)
  • Raffensperger, J.F. (2001) New guidelines for spreadsheet style. Amsterdam, Netherlands: European Symposium on Spreadsheet Risks, Jul 2001. In Proceedings 61-76. (Conference Contribution - Paper in published proceedings)
  • Raffensperger, J.F. and Schrage, L. (1997) A new paradigm for measuring military readiness. Military Operations Research 3(5): 21-34. (Journal Article)