Using graphs for financial and statistical analysis allows you to analyze and present data in a meaningful and functional way utilizing graphs that even Excel didn't know it could do. In this article by Andre Odnoha, author of Excel 2010 Financials Cookbook, you will learn to not only add reusable methods to automate graph production, but also how to create graphs and graphing sets that are not native to Excel.
In this article, you will learn the following recipes:
- Charting financial frequency trending with a histogram
- Creating a stem and leaf plot
- Creating a Box and Whisker Plot
- Using a graph overlay for profit and expenses
- Graphing the principal of a loan automatically
Building financial function into Excel, as shown in the previous article, will augment the Excel toolset with user defined functions broadening the abilities of Excel. In this article wee will focus on depreciation, and the value of a dollar.
In this article by Andre Odnoha, author of Excel 2010 Financials Cookbook, we will learn:
- Calculating the depreciation of assets
- Calculating the future versus current value of your money
- Identifying the profitability of an investment
- Calculating and planning for inventory requirements
Graphs are an important and essential method of demonstrating information visually for analysis and ease of understanding. Graphs in Excel, however, are static visual representations. You can filter the data or adjust the dataset to change the information that is displayed; however, the graph itself is still a static image. Adding animation visualization to a graph will add an element of professionalism to a presentation.
In this recipe by Andre Odnoha, author of Excel 2010 Financials Cookbook, you will learn how to add animation to Excel graphs.Read Excel 2010 Financials: Adding Animations to Excel Graphs in full
In the previous article, A look inside a MySQL Daemon plugin, we were introduced to the MySQL Plugin API. It talked about the most simple plugin type—Daemon plugins. It starts with the basic structure of a plugin—what a plugin declaration should look like, what plugin types are, and so on. Then it described features common to all plugin types—initialization and de-initialization callbacks, status variables, and configuration system variables.
This article, by Andrew Hutchings, co-author of MySQL 5.1 Plugin Development, describes and analyzes line by line four Daemon plugin examples—from a simple plugin that prints Hello World! when loaded, to a system monitoring plugin that periodically logs the number of connections, to a system usage status plugin that displays the memory and I/O usage of the MySQL server.
We will specifically cover:
- A Hello World! Daemon plugin
- A system and status variables demo plugin
- A simple monitoring plugin
- System Status Variables plugin
Soon after you install and run Plone for the first time, you will probably want to change the appearance. The effort needed to do so varies, and depends largely on your goals. If you are not picky, adding a new theme to Plone can be as simple as adding a package to your buildout.cfg file, running Buildout, and restarting Plone. However, if you want a high quality, unique, and a professional-looking theme for your site, it could take some time to achieve the desired result.
In this three part article series by Alex Clark, author of Plone 3.3 Site Administration, in addition to covering various aspects of through the web versus filesystem theming, you will learn:
- Installing themes with Buildout
- Examining themes with Omelette and Python
- Overview of theme package files
- Creating a theme package with ZopeSkel
- Examining themes in the ZMI
- Making changes through the Web
In this first article, we will learn installing themes with Buildout and examine themes with Omelette and Python.Read Examining themes with Omelette and Python in full
In this article by Steve Ries author of OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide, we will explore what Oracle has to offer. It covers the Oracle architecture and how it operates to provide data integrity and high performance in an Oracle system.
In this article we will:
Understand the distinction between a database and an instance
Explore the Oracle instance
Understand Oracle's process architecture
Examine the Oracle memory cache architecture
Explore the Oracle database
Investigate Oracle's datafile structure
In this article by Kiran R Karkera, the author of Building Probabilistic Graphical Models with Python, we shall employ over fully specified graphical models to various inference engines to obtain answers to the questions.
Before we start on the inference trail, we shall learn about the complexity of the inference problem. Using different types of inference is appropriate in certain contexts, and we will learn which type is applicable where, and then experiment with both approaches.Read Exact Inference Using Graphical Models in full
While we are able to create and improve a lot of different things in concrete5 without touching the actual core files in the concrete directory, we might have had to manually install several elements to get our functionality into a new site. By using a package, we can wrap all the previously created elements into a single directory, which can be installed by a single click on the dashboard.
Being able to customize and extend almost everything can make things a bit messy. Have a look at this article, by Remo Laubacher, author of concrete5 Beginner's Guide, to see how you can wrap things in a package for an easier handling.Read Everything in a Package with concrete5 in full
In this article by Ronald Rood, we will see how events that are generated by a job or a chain step can be intercepted to enable the monitoring of jobs. After that, we will see how we can use events to start a job that is waiting for an event.Read Events in Oracle 11g Database in full
In this article by Venkateshwaran Loganathan, the author of PySide GUI Application Development, we will look into some of the internal implementation working concepts of those functions. Being an event-driven toolkit, events and event delivery play an important role in the Qt architecture. We will start this article by discussing events and signals, their implementation, and will go on to discuss handling drag-and-drop events, and drawing functionalities.Read Events and Signals in full
In this article by Ken Finnigan author of JBoss Weld CDI for Java Platform,we are going to find out about events within CDI, such as how they are fired, how we listen for new events, what we can use as an event payload, and how we can narrow what events we can listen to and fire. All of these we will discover while staying within the boundaries of typesafe Java, making our runtime less error-prone.
Events may be produced and consumed by beans of our application, but there is absolutely no coupling between the bean producing an event and the one consuming it. This allows our beans to interact without any coupling or compile-time dependencies between them.Read Events in full
In a service-oriented world, a level of abstraction is needed for creation and use of events using business semantics, without the publisher or subscriber of the event ever having to worry about the mechanics of messaging. Oracle SOA Suite 11g addresses this with the introduction of a new feature in the form of the Event Delivery Network.
In this article by Heidi Buelow, Manas Deb, Jayaram Kasi, Demed L'Her and Prasen Palvankar, we will work with events using the unified services and events platform of Oracle SOA Suite 11g to provide an event-handling solution.Read Event Delivery Network with Oracle SOA Suite 11g R1 in full
In this article by Sarma Anantapantula and Joseph Sydney Gomez, we will learn all about ASO which is now also used to store data in the Essbase database. We will learn what ASO exactly is, how it works, and when to use ASO instead of BSO. We will explain the use of the special industry standard multidimensional data query language known as MDX that is employed by Essbase, and is particularly effective with ASO. Finally, we'll discuss the pros and cons of ASO and BSO.Read Essbase ASO (Aggregate Storage Option) in full
In this article by Martin Brampton author of PHP 5 CMS Framework Development, we will learn various aspects about error handling in PHP 5 Content Management System. Specifically we will cover:
- PHP error handling
- Database errors
- Application errors
- Exploring PHP—Error handling
- Framework solution
- Handling database errors
- 404 and 403 errors
This is the second part of two-part article by Vivek Thakur on N-Layer Architecture with ASP.NET 3.5. In the first part we saw the need for a 3-layered solution and examined ER-diagrams, domain models and UML. In this part we will we will explore a 1-tier 3-layer Architecture using a Domain Model and Object Data Source Controls.Read ER Diagrams, Domain Model, and N-Layer Architecture with ASP.NET 3.5 (part2) in full
In this two-part article by Vivek Thakur, we will learn about ER Diagrams, Domain Model, and N-Layer Architecture with ASP.NET 3.5. The 1-tier 1-layer architecture is the default style in ASP.NET and Visual Studio 2005/2008. To overcome the limitations of this style, we can further break the application code into n-layers, where the number "n" actually depends on the project requirements.
In this article we will:
- Learn the 2-layer style
- Understand ER diagrams
- Understand what a domain model is, and what UML relationships are
- Learn the 3-layer style
- Learn about object data source controls
In this article, by Sean James, author of 3D Graphics with XNA Game Studio 4.0, we will focus on building a full 3D environment. We will start by creating a class that builds a terrain from a 2D image called a heightmap. We will make a number of improvements to the basic version of this class, allowing multiple textures across its surface through multitexturing and extra detail at close distances to its surface through a "detail texture".Read Environmental Effects in 3D Graphics with XNA Game Studio 4.0 in full
Get a quick overview of the latest RAW books from Packt Enterprise.
Packt's RAW books are a true example of 21st century publishing - they allow you to download the eBook before it's published, and then read as it's written, with your eBook instantly updating as new chapters are completed.
What's more you also receive a 40% discount when purchasing RAW eBooks and the RAW pre-order bundle.
Enterprise JavaBeans are server-side components that encapsulate application business logic. Enterprise JavaBeans simplify application development by automatically taking care of transaction management and security.
In this article, author David Heffelfinger explains the two types of Enterprise JavaBeans – Session Beans, which perform business logic; and Message-Driven Beans, which act as a message listener.Read Enterprise JavaBeans in full
This article covers the benefits and features of Lotus Sametime, which is a built-in chat and presence awareness tool. There are many advantages that come with Sametime. First, it is relatively low cost; it is not like a cell phone call where one is charged by the minute. Another advantage is the ability to see who is available to chat, which is fantastic when we're communicating with people who are outside of their time zone or across the world, or even one floor down in their office building. Sametime is instant because we're online—people can start a chat with someone when they see them online and they can instantly respond.
In this article, by Karen Hooper, author of IBM Lotus Notes 8.5, we will learn:
- What is Sametime
- How to use Sametime
- Understanding availability status
- Adding Sametime contacts
- Chatting with contacts
- The chat window options
- Setting Sametime preferences
- Sametime help