Call (+1) 650-212-1212

December 2014

Hello Analytica Users,

Happy Holidays! This month we offer a new case study, give dating advice, and present an ecological over-logical (you'll see what I mean by this). As always, we'd like to know about your latest modeling challenges, questions, and triumphs. We hope your year is coming to a successful close.

Paul Sanford, Newsletter Editor


'Twas the Night Before the Climate Change Apocalypse

Another UN Climate Change conference came to a close last week, once again demonstrating the predictable result of pro-Santa politics. It seems that while you and I are subjected to increasingly restrictive CAFE fuel mileage standards and energy taxes, the Jolly Old Elf continues to enjoy a sweetheart deal on emissions. CTO Lonnie Chrisman has carefully assessed the enormous bootprint of St. Nick's annual soot-soaked carbon binge. No wonder your children lie awake on Christmas Eve! The shocking details are in the Lumina Blog.


TIPS & TRICKS: How To Make Your Date Feel Special

If your dating experience is limited to designated date functions, you've probably missed out on some opportunities. If you look closely, you can find dates at functions where you have only noticed ordinary figures before. The key is to understand a few hidden attributes. Here are some examples:

  • Ceil(Today(), dateUnit:'Y') will get your date to the next year's party.
  • Round(date_with_time, dateUnit: 'm') will get rid of secondary rivals.
  • Birthdays are important. Be sure to list all of them: 
    Sequence(DOB, DOD, dateUnit: 'Y')

Even the traditional old flames have new features to discover:
DatePart(xmas, 'MMMM') = "December". DatePart(xmas, 'ddd') = "25th".

And if you're too lazy to make your own dates there's always Parsedate('February 14 2015') to do the legwork for you.

Before you look for solutions on eHarmony or Table For Six, check out the detailed advice on this Analytica Wiki page. There could be a supermodel in your future.


Case Study: A Campus Microgrid with CHP

Microgrid with CHPUniversities, hospitals, factories, apartment blocks, office parks, and other large energy consumers can reduce energy costs and carbon emissions by creating and managing their own microgrids. Such microgrids may supplement electricity purchased from the utility with locally generated energy. The local resources may include solar photovoltaics, natural gas fired combined heat and power (CHP), efficient cooling systems, energy storage, and programs to reduce or time-shift demand. Energy and Environmental Economics (E3) Consulting used Analytica to create a dispatch optimization tool for the University of California’s San Diego’s (UCSD) microgrid. With support from the California Solar Initiative RD&D program, E3 explored how UCSD microgrid resources could be used to support utility grid operations and integrate higher penetrations of PV generationFor more


A Rosetta Stone for Excel Users

Rosetta StoneWe know you have snuggled up to a lot of spreadsheets. Excel has lots of useful functions and is the platform that most modelers start on. Have you wondered if there is a resource that can help you find your favorite Excel functional counterparts in Analytica? Yes there is! We have compiled an Analytica Wiki section specifically for this purpose. It includes functions related to database queries, engineering, finance, text and data, statistics, lookups, and more. If you don't find what you're looking for here, let us know.

In this Issue

'Twas the Night Before the Climate Change Apocalypse

How To Make Your Date Feel Special

Case Study: A Campus Microgrid with CHP

A Rosetta Stone for Excel Users


Build computer models that are fast, transparent, flexible, and powerful.

Free 101 includes influence diagrams, risk analysis, and Intelligent Arrays to let you build models with up to 101 variables and other user-defined objects.

Download Free 101

Zero cost. Never expires.


Wednesday Webinars

Analytica experts show how to build and analyze a model and answer your questions about our products or services. You can also ask your own questions about how Analytica could be used for your applications.

Sign up to schedule your demo


Explore the Analytica Product Line



Editions for Model Builders

Editions for Model End Users


Lumina is committed to continuing research and development to bring innovative decision technologies to individuals and organizations.

Lumina Decision Systems, Inc., was founded in 1991 by Max Henrion and Brian Arnold. In order to meet the needs of demanding projects, Lumina often assembles virtual organizations bringing in complementary expertise and resources from affiliated organizations, small and large. 

Its main office and R&D labs are located in Los Gatos in California's Silicon Valley.

Copyright (c) 2014 Lumina Decision Systems, Inc.