• Skip to main content
  • Skip to footer
Revelwood Logo

Revelwood

Your SUPER-powered WP Engine Site

  • Who We Are
    • About Us
      • Our Company
      • Our Team
      • Partners
    • Careers
      • Join Our Team
  • What We Do
    • Solutions
      • Workday Adaptive Planning
      • IBM Planning Analytics
      • BlackLine
    • Services
      • Implementation Services
      • Customer Care
        • Help Desk
        • System Administration as a Service
      • Training
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

Planning & Forecasting

The Power of the Growth Mindset: How CFOs Drive Success in Finance

September 15, 2023 by Revelwood

FP&A Done Right: Finance’s Role in ESG Reporting

This is an excerpt from a blog post from our partner Workday Adaptive Planning. In It, A McKinsey & Company senior partner lays out five elements that help drive performance, and finance leaders from Adobe, e.l.f. Beauty, and TD Bank share their individual approaches to growth, in a Fortune virtual event.

For CFOs, a growth mindset means the ability to help their companies thrive by firing on multiple cylinders.

That’s according to Ishaan Seth, a senior partner and co-lead of global banking and securities practice at McKinsey & Company, who outlined a three-pronged approach that includes customer acquisition and retention, innovation, and building new businesses.

“The mindset that personifies the best growth leaders, be they CFOs or CEOs, are those who can help the company operate across all three of those areas at once,” Seth said in a Fortune webinar sponsored by Workday. “That’s the essence of the growth mindset.”

Developed by Stanford University psychology professor Carol Dweck, the concept of a “growth mindset” was based on research that found people enjoyed greater success when they believed their talents could be developed “through hard work, good strategies, and input from others.” The research also found effects for organizations: “When entire companies embrace a growth mindset, their employees report feeling far more empowered and committed; they also receive greater organizational support for collaboration and innovation,” Dweck wrote.

In practice, a growth mindset can be seen in the C-suite of successful organizations. Seth said McKinsey surveyed 2,500 public companies over the past two decades and found five variables that drive outperformance in relation to their peers.

  1. 1. Resource allocation. “How dynamically or fluidly are you reallocating resources to newer businesses and opportunities?” Seth said.
  2. 2. Mergers and acquisitions. “M&A and a constant portfolio pruning both on acquisition but equally on divestiture” is critical, Seth said. “Are you regenerating the base?”
  3. 3. Productivity and efficiency. Outpacing peers is important.
  4. 4. Technology and technology innovation. “It’s a space where the arms race to keep current has in many cases across industries outstripped the ability for companies to invest at the level to be on the leading edge,” Seth said.
  5. 5. Margin expansion. This is accomplished by refreshing the value proposition, he added.

When it comes to technology, finance leaders are uniquely positioned to drive innovation at scale by making the right investments and establishing the pace necessary to more quickly benefit from that technology—whether it’s artificial intelligence (AI), machine learning (ML), or generative AI.

Seth cited a McKinsey study that found generative AI could potentially add $2.6-$4.4 trillion per year to the global economy, noting that the United Kingdom’s entire GDP in 2021 was $3.1 trillion.

Finance leaders, then, must understand how to invest intelligently in technology and help set the pace at which to do so. 

“Is there a competitive advantage in getting to a higher-quality capability around whatever the technology may be 12 or 20 months sooner than your competitors?” Seth said. “The CFO can play an outsized role in driving speed as a source of competitive advantage.”

Seth added that calculating the return on investment (ROI) on technology spending might well require organizations to rethink their key performance indicators (KPIs), with CFOs driving the conversation around growth metrics.

The CFO, he said, owns the value creation story of a company. “We see the role of the CFO as being able to describe what it would take to double the market cap of the company in five years.”

Creating an Atmosphere of Innovation

To Mandy Fields, senior vice president and CFO at e.l.f. Beauty, leadership means promoting an organizational growth mindset by creating an environment that fosters innovation. 

“It’s not the manager’s job to prevent risks, but it’s the manager’s job to make sure it’s safe for others to take them,” she said, attributing that ideal to the company’s 17 consecutive quarters of net sales growth—with a fourth quarter that saw sales growth of nearly 80%. “A lot of that has been not being afraid to take risks.”

As an example, Fields said e.l.f. Beauty in 2019 decided to invest in growing their presence on social media video platform TikTok, a move that resulted in “amazing” engagement. “As we went into the pandemic in 2020, when everybody was rushing in to figure out how to get on this platform, how to engage with the consumer, we were already there.”

Fields said the company holds annual off-site meetings to align its people to its priorities. “It helps us think about how we set an annual budget, but it really is an opportunity for inspiration, imagination, and possibility to converge,” she added. “That’s motivating for the team—not just for finance but for the entire company—to know that even though we’ve experienced this tremendous growth, there’s still so much more ahead of us.”

‘Be Constructively Unreasonable’

For enterprise software company Adobe, innovation is part of its DNA, according to Dan Durn, CFO and executive vice president, finance, technology services and operations. 

“We are consistently reinventing the company and engaging with customers in a way that’s very relevant for them,” he said. “Status quo is not a business strategy.”

Durn said understanding Adobe’s products “with granularity” helps the company innovate in order to serve customers better, making its growth and market position sustainable for the long run. He added that there’s “a velocity within the company” and clarity about innovation, as well as how to achieve growth via acquisitions. 

“We’re going to primarily be an organic, innovation-driven company,” Durn said. “But we will complement from time to time, and you can see that speed play out not only in our decision-making but the way we want to enable customers as well.”

The concept of a growth mindset—and continuous learning—is critical within a technology company, Durn said, offering a guiding leadership principle: “Be constructively unreasonable, which is that sweet spot of stretching people to more than they thought was possible and getting them to lean into problems and deliver more than they thought was possible.”

Growth on Personal and Organizational Levels

The variability in the macro environment, along with competition for customers in the retail banking space, keeps TD Bank CFO Xihao Hu focused on innovation on the customer-facing side as well as the back end. 

“We are working on enhancing our strategies to make sure we not only defend our turf but can continue to speed up our customer acquisitions, bring new customers in, and retain the loyal customer,” he said, adding that the bank had recently launched two new, unique credit card products and is looking at expanding its commercial banking into new geographies.

TD Bank’s growth mindset, Hu said, shows up on organizational and personal levels. “Once we had the strategy set, we embarked on a journey to tell the story across TD Bank in the U.S.,” he added, sharing in detail the bank’s plans with leaders who would then “take those stories back to their teams to cascade that sense of a mindset of growth.”

Hu also described a three-year blueprint for finance employees to improve their storytelling abilities to help TD Bank’s business partners grow. “We want to shift from a traditional role of overseers of past transactions into strategic partners to our finance employees,” he said.

Watch the full Fortune webcast “Emerging CFO: Maintaining a Growth Mindset in Turbulent Times.”

Read the full blog post on the Workday blog.

More from our FP&A Done Right Series:

Navigating the BPM Vendor Landscape: Key Insights from the 2023-2024 Report

Navigating Economic Volatility: Insights from CFOs

Workday Adaptive Planning Recognized with the 2023 Gartner Peer Insights Customers’ Choice for Financial Planning Software

Home » Planning & Forecasting » Page 3

Filed Under: FP&A Done Right Tagged With: Chief Financial Officer, Financial Performance Management, Planning & Forecasting, Workday, Workday Adaptive Planning

IBM Planning Analytics Tips & Tricks: Adding Images to Charts

September 12, 2023 by Ivan Cepero

Charts are an excellent way to use visuals to convey information. Did you know that you can increase the effect of charts in Excel by adding custom images?

Consider this plain pie chart.

Chart, pie chart

Description automatically generated

We can insert a corporate logo to give the chart a greater visual appeal and branding.

1 – Click on the chart to select it

2 – Right click and select “Format Chart Area”

3 – Select “Picture or texture fill”

A screenshot of a phone

Description automatically generated with medium confidence

4 – Select “Insert” to insert an image from your computer or “Clipboard” to insert a previously copied image

When clicking “Insert” you will see a pop up letting you pick various image sources.

Text

Description automatically generated

5 – You can further refine the options by having the image tile, offset or scale.

Here is the updated chart with the Revelwood logo applied, tiled and set with transparency level 80%:

Chart, pie chart

Description automatically generated

You can also apply custom images to a specific data point (e.g. a pie slice in this example) by initially selecting the data point instead of the entire chart, then following the steps outlined above.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Popular Video Tips, Part 3

IBM Planning Analytics Tips & Tricks: Counting Hidden Rows in Excel

IBM Planning Analytics Tips & Tricks: Popular Video Tips, Part 2

Home » Planning & Forecasting » Page 3

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: IBM Cognos TM1, IBM Planning Analytics, IBM Planning Analytics Tips & Tricks, Planning & Forecasting, TM1

Accounting Automation Transforms Finance

September 7, 2023 by Revelwood

In today’s fast-paced business landscape, finance and accounting teams face increasing pressure to close the books faster, ensure data accuracy, and comply with ever-changing regulations. Manual accounting processes not only consume valuable time and resources but also pose significant risks of errors and inconsistencies. However, there’s a solution — accounting automation software.

Simplifying Account Reconciliation

One of the core features of accounting automation software is for account reconciliations. Traditional reconciliations involve manual data entry, cross-checking, and time-consuming reviews. Accounting automation software transforms this process by offering auto-certifications, matching technology, and real-time visibility into the status of reconciliations. Intelligent algorithms handle high volumes of accounts effortlessly, minimizing the risk of errors and ensuring compliance with accounting standards.

Empowering Transaction Matching

Another game-changing aspect of accounting automation software is transaction matching. Matching records from multiple data sources, such as bank statements and general ledger transactions, can be a tedious and error-prone task when done manually. Advanced matching logic can handle various types of matches, enabling efficient one-to-many and many-to-many reconciliations. This capability saves valuable time and ensures accurate results for even the most complex datasets.

The Benefits of Accounting Automation

Implementing accounting automation in your finance department offers a plethora of advantages. First, it significantly reduces the time and effort required for financial reconciliations, enabling teams to focus on value-added tasks. By automating workflows and standardizing processes, the software ensures consistency across different accounting practices, reducing the likelihood of errors and discrepancies.

Ensuring Data Security and Compliance

The best accounting automation solutions prioritize data security, confidentiality, and compliance. It should have robust encryption measures, access controls, and secure cloud storage so that sensitive financial information remains protected from unauthorized access. 

As finance and accounting professionals seek to streamline their processes and achieve greater efficiency, accounting automation software emerges as a transformative solution in the Office of Finance. By centralizing financial tasks, automating reconciliations, and providing real-time insights, the software can revolutionize the way financial operations are managed. Embrace the future of accounting automation and empower your finance team to drive business success like never before.

Read more about Accounting & Accounts Receivable:

Unplugging with Confidence: How Accountants Can Enjoy Vacations Stress-Free

The Power of AR Automation in Transforming Finance Operations

Maximizing Cash Flow: How Technology Optimizes Accounts Receivable Operations

Home » Planning & Forecasting » Page 3

Filed Under: Accounting and Accounts Receivable Tagged With: accounting, accounting automation, BlackLine, Financial Performance Management, Planning & Forecasting

Annual Planning Versus Continuous Planning

July 14, 2023 by Revelwood

This is a blog post from our partner Workday Adaptive Planning. Bob Hansen of Workday explains how the switch to continuous planning makes organizations more agile, proactive and successful.

A common measure of business success is growth. Because if you’re not growing, you’re not succeeding. Even in times of tumult, businesses are expected to push past obstacles and prosper by growing.

But when finance views growth by focusing on size and scale, it’s too easy to miss other aspects of how companies evolve. It’s not just about getting bigger; it’s about getting better.

For most organizations, one area that can get better—a lot better—is how they plan. And for an increasing number of businesses, there has never been a better time to transform the processes that help you prepare for what’s next.

Annual planning process vs. Continuous Planning

You can stick with a traditional annual planning process—an often spreadsheet-based, manual task that produces plans, budgets, and forecasts that are outdated the moment they’re finalized. When you spend weeks to months building a plan that can’t keep up with the dynamic changes your organization faces, your time and effort is invested in a model that can’t guide your business forward, or help you quickly course correct. Clinging to the status quo may seem cost-effective in terms of actual expenditures, but the costs in time and labor, mistakes, and missed opportunities make static planning something your business can’t afford. Especially these days.

The better option is continuous planning. Designed for how businesses must operate today, continuous planning harnesses all the business-run financial and operational data into a single source of truth that informs plans, budgets, and forecasts with fresh actuals.

Continuous planning empowers companies to adjust budgets and forecasts on a constant basis, so they can pivot and react in real-time with the latest information. Now more than ever, businesses are being forced to shorten their window for assessing, re-forecasting, and making adjustments to their overall plan. The closer they can get to real-time when it comes to planning, the more strategic their decisions and competitive their actions. 

Three Common Obstacles to Continuous Planning

Many organizations face common (and frustrating) barriers impeding the path to continuous planning and increased business agility. An oft-cited survey of global business leaders helps shed light on what separates top performers from organizations that are falling behind. Survey results show that fewer than 1 in 5 executives said their approach to strategy and execution enables them to react with agility and speed to market shifts. 

What’s keeping the rest from planning continuously and operating with agility? Three key obstacles.  

  • Outdated technology or infrastructure. Legacy technologies can keep data siloed between departments and business units, preventing business users from the data they need to monitor the health of the company and quickly make informed decisions. 
  • Skill set deficiency. As planning goes companywide, organizations can perceive a need for additional training and expertise to navigate and get the most out of these tools. That’s a challenge when all you have is a planning environment designed solely for finance use. 
  • Existing processes and procedures. Organizational challenges, including rigid hierarchies and inflexible workflows, can stand in the way of implementing continuous planning processes in finance and beyond.

Continuous planning empowers companies to adjust budgets and forecasts on a constant basis, so they can pivot and react in real-time with the latest information.

Evolving to a Continuous Planning Process

To address these obstacles, transforming from static, annual planning to a continuous planning process requires change in at least one of three areas: technology, people, or processes. (And most likely, it’s a little of all three.)

  • Technology. It would not be possible to implement a continuous planning process using the static planning environment imposed by outdated legacy technology. Modern, cloud-based planning solutions can automate data collection across silos and make that data visible across your organization. That way, all departments can share a single source of truth and insight for planning and decision-making. 

When evaluating planning technology, look for solutions that provide the elasticity to scale as your organization grows—and as more users require more insight more often. In addition, make sure your solutions are platform-agnostic so that you don’t get stuck using disjointed, disparate systems that prevent sharing and collaboration. A leading solution will provide the flexibility you need to model virtually any what-if scenario as many times as needed, and with virtually no dimensional limits. It will also integrate intelligent automation such as machine learning so you can produce more accurate forecasts faster while identifying potential issues sooner. 

  • People. All the technology in the world won’t matter if you don’t have the right people with the right skills leveraging it at the right time. Extended planning and analysis (xP&A), or companywide planning, incorporates FP&A best practices across the organization, so everyone can engage in a continuous planning process. By establishing a culture of continuous planning, you not only take pressure off the finance team, but you’ll help other departments and lines of business make the most out of their budgets, forecasts, and plans. 
  • Processes. Technology can automate manual tasks such as data entry and consolidation, while building companywide skills can help you maximize your ability to continuously plan. By incorporating continuous planning as part of your standard workflows, you can ensure you’re using the same best practices across the company so everyone works as one. Finance leaders should establish and orchestrate repeatable planning, budgeting, and forecasting processes. This is how you can equip your entire organization to quickly adapt to market changes. 

Beginning Your Continuous Planning Journey

So where should you start: technology, people, or processes? The answer is different for every organization. Some might focus on their most urgent need or where they are the furthest behind, while others may wish to get a quick, easy win they can build from. 

Given the importance data plays, it may make sense to first focus on technology. This lets you create a single source of truth that can provide the intelligent data foundation you’ll need to engage people and create a continuous planning process, not only for finance but eventually for other teams such as sales, operations, and human resources. 

Keep in mind that you don’t have to start big. By starting small with a test use case or participant, you can build out your framework at a pace that feels comfortable while creating champions who can help you promote continuous planning across the organization when you’re ready to roll it out. The most important thing? Don’t wait.

Read the full blog post on the Workday blog.

More from our FP&A Done Right Series:

Professional Services Firms Need Future-Ready Forecasting

Enterprise Planning Helps Professional Services Firms Adapt to Changes

FP&A Done Right: Trends in Accounting and Finance

Home » Planning & Forecasting » Page 3

Filed Under: FP&A Done Right Tagged With: Finance done right, Financial Performance Management, FP&A done right, Planning & Forecasting

Professional Services Firms Need Future-Ready Forecasting

June 29, 2023 by Revelwood

FP&A Done Right

This is an excerpt from a blog post from our partner Workday Adaptive Planning. It highlights some approaches for professional services firms to keep up with the breakneck pace of work.

Professional services firms don’t have the luxury of gradually adjusting to an evolving digital environment. For them, the digital future is pretty much here. More than one-third of professional services firms expect that at least 75% of their revenue will come from digital by 2025, according to a report by PwC and Workday.

As an additional sign of the changing times, a growing proportion of firms are investing more than $50 million in artificial intelligence (AI), machine learning (ML), and advanced analytics, according to the report. And with recent advances in generative AI, investments are likely to continue to grow. That’s further blurring the line between professional services and digital services—a distinction that will only get fuzzier in the future. 

“Digital first is our new reality. That isn’t going to change,” shared Joe Golden, vice president of services, IBM, at a Workday event.

Yet, despite how adroitly many professional services firms adapted to wide-scale changes brought on by the pandemic, some lack visibility around past behavior and likely future outcomes. “Professional services organizations can be surprisingly opaque when it comes to insight,” IDC reports.

To succeed, firms must solve their data, talent, and technology challenges. But many have yet to embrace this new reality. Among professional services leaders, 57% say there’s a growing gap between where their business is and where it needs to be to compete, according to a recent Workday study on digital transformation. And only 23% say their digital strategy allows them to keep pace with or exceed the demands of the business.

Firms will need to bolster their access to high-quality, always-available data, along with having staff with the necessary data literacy skills to make sense of it all. Of companies with fully-accessible data, 76% say they are well-equipped digitally to ensure business continuity in times of crisis, Workday finds. Small wonder, then, that advanced analytics and data visualization are the skills most sought after by IT leaders (35%) and finance leaders (34%).

“Access to data is the crux of most technology issues in any company,” says Jennifer LaClair, CFO, Ally Financial.

To better understand what the future might hold for professional services firms, industry thought leaders shared their predictions for three of the biggest trends the industry will face. The following excerpt focuses on how professional services firms can benefit from more sophisticated forecasting.

Data Silos Disappear as Organizations Race to Future-Ready Forecasting and Adaptability

To drive productivity and profit and to forecast accurately, future-forward professional services firms will need more integration and less separation of their people and systems. “Today’s professional services organizations simply cannot operate with functional silos as the lines between sales, delivery, and finance become blurred,” SPI asserts.

Unfortunately, these organizations’ data too often sits trapped within silos. “The reason most companies can’t forecast their revenue more accurately is because they have different systems and data across their lines of businesses and services,” Joseph says. “And all those different systems mean that you have data that’s going to be wildly inconsistent.”

Almost half (49%) of business leaders—and almost two-thirds (62%) of professional services leaders—say their inability to connect operational, people, and financial data to business outcomes impairs the organization’s agility, according to a Workday survey of senior business executives. 

But firms with accessible data tell a different story, the Workday survey reveals. A towering 85% of leaders whose companies enjoy fully accessible data say the organization can embrace change readily. All of which points to the urgent need to overcome siloed data sources.

For ERPA, a consulting and enterprise application managed services firm, adopting professional services automation slashed the time needed to calculate revenue from a full day to just 15 minutes. And the firm gained a stronger forecasting ability in the process. 

“From week to week, we’re able to get a really good sense of our forecasted revenue for projects in the next four to 12 weeks,” says Jon Milkovich, director of Workday financials at ERPA. “So it’s really provided a lot better real-time insight into what our forecasted revenue will be.”

That’s a need that best-in-class firms are meeting head-on. They’re 82% more likely than other firms to be able to share financial and operational data with the extended enterprise through a central repository, Aberdeen finds in its report: “Leverage Demand Planning and Forecasting for Best-in-Class Performance During Volatile Times.”

Learn more about how professional services firms can adapt and change in our recent webinar, Streamlining Professional Business Services with Workday Adaptive Planning.

Read the full blog post on the Workday blog.

More from our FP&A Done Right Series:

Enterprise Planning Helps Professional Services Firms Adapt to Changes

FP&A Done Right: Trends in Accounting and Finance

Leveraging IBM Planning Analytics for xP&A

Home » Planning & Forecasting » Page 3

Filed Under: FP&A Done Right Tagged With: Budgeting Planning & Forecasting, Financial Performance Management, Planning & Forecasting, Workday, Workday Adaptive Planning

Revelwood Expands Best-in-Class Solution Portfolio to Include Incorta

June 14, 2023 by Revelwood

News & Events

We’re expanding our best-in-class solution portfolio to include Incorta’s open data delivery platform, giving our clients an analytics hub for the Office of Finance. Incorta’s technology simplifies the data ingestion and delivery approach, giving clients unrivaled data access to deliver fast, accurate insights.

“Savvy financial management can be hard to achieve,” said Tom McCrory, senior vice president, sales, Incorta. “It requires a rock-solid foundation of comprehensive data and ad-hoc, self-service analytics. Together, Revelwood and Incorta will help our join clients in the Office of Finance take the next step in providing strategic guidance to business operations.”

Incorta was recently included in the 2023 Gartner Magic Quadrant for Analytics and Business Intelligence (ABI) platforms. It was one of 20 vendors assessed in the report. Incorta directly maps to data sources, eliminating the need for data transformation, reshaping and aggregation required by other platforms.

“The Office of Finance has become a strategic asset for industry-leading organizations,” said Robert Gordy, CTO, Revelwood. “It’s no longer about managing the budget or performing basic accounting activities. Instead, the Office of Finance has evolved into managing all the disparate pieces of data to provide forward-thinking insights for the business. We’re partnering with Incorta to help CFOs and their teams move toward unlimited, active analysis.”

Additionally, Incorta has existing integrations with two of Revelwood’s technology partners – BlackLine and Workday Adaptive Planning.

Incorta and BlackLine

Incorta’s integration with BlackLine enables accounting teams to instantly drill-through to transaction details with a single click. It provides users the ability to access data from multiple ERPs and other source systems with easy, instant access to transaction-level details down to the subledger. By using BlackLine and Incorta together, clients benefit from:

  • A single source for all data
  • Transaction-level detail
  • Streamlined data flows

Incorta and Workday Adaptive Planning

Incorta’s integration with Workday Adaptive Planning accelerates and improves forecasting and planning with access to near real-time transaction-level data. The integration enables:

  • Automating operational analytics
  • Delivering transaction-level detail
  • Unifying enterprise data
  • Streamlining data flows


Learn more about our new partnership with Incorta!

Home » Planning & Forecasting » Page 3

Filed Under: News & Events Tagged With: BlackLine, Financial Performance Management, Incorta, Planning & Forecasting, Workday Adaptive Planning

IBM Planning Analytics Tips & Tricks: Excel Tips, Part 2

February 28, 2023 by Revelwood

Revelwood’s IBM Planning Analytics team has created numerous tips & tricks focused on helping people use Excel. Over the next few weeks we’ll be highlighting some of the most popular and interesting posts on Excel. You can read part 1 here.

IBM Planning Analytics Tips & Tricks: Excel’s NETWORKDAYS Function

Have you ever wanted to define the number of working days between two calendar dates? Do you define “working days” simply as non-weekend days or do you also include holidays? Did you know that you can calculate this information using Excel’s NETWORKDAYS function? 

The NETWORKDAYS function is used to determine the number of whole working days between start_date and end_date. This blog post explains how to use it. 

IBM Planning Analytics Tips & Tricks: Excel TYPE Function

Have you ever referenced a list in Excel and needed to know whether each value was a number or a string? This may be required when another function depends on the type of value in each cell.

Excel has a function called TYPE that will give you this information. The function contains a single parameter, which is simply the cell you want to check. Learn more about using the TYPE function in this blog post.

IBM Planning Analytics Tips & Tricks: Excel OFFSET Function

Have you ever wanted to reference a cell based on its placement compared to another cell? Maybe you want to create a formula where each cell looks at the value 2 columns to the right or maybe you want to compare a value to the cell above. This information can be determined using Excel’s OFFSET function.

The OFFSET function is used to reference a range that is a specified number of rows and columns from a cell. We detail the syntax of the OFFSET function in this blog post. 

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Excel Tips, Part 1

IBM Planning Analytics Tips & Tricks: Approaches in Planning Analytics’ New Set Editor

IBM Planning Analytics Tips & Tricks: Charts in Planning Analytics Workspace, Part 1

Home » Planning & Forecasting » Page 3

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, TM1

IBM Planning Analytics Tips & Tricks: Excel EOMONTH

February 21, 2023 by Lee Lazarow

Thirty days has September …

Do you sing that out loud every time you want to determine the number of days in a month? If so, do you have to pause and think about the end when defining the last day of February? More importantly, do you have to write complex logic into your spreadsheet to define this? If so, you may want to learn more about the EOMONTH function in Excel!

The EOMONTH function is designed to tell you the last day of a month – either the current month, a future month, or a historical month. The function has two parameters:

=EOMONTH(start_date, months)

  • The start_date parameter defines the initial date of your calculation
    • Microsoft recommends using the DATE function for this value
  • The months parameter defines the number of months from the start date
    • A zero value results in the current month
    • A positive value results in a future month
    • A negative value results in a previous month

Graphical user interface, application, table, Excel

Description automatically generated

This approach will help you in various planning models such as …

  • Workforce planning – when to start calculating benefits 
  • Asset planning – when to begin the depreciation calculations

This can also be used to define start dates by simply adding 1 to the result and determining the first day of the next month. Now we just need a formula to help us when someone obnoxiously tells us to “just perform the task on each day that ends in Y.”

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips &Tricks: Rounded Buttons in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: MDX Syntax Explained

IBM Planning Analytics Tips & Tricks: Working with Two Time Zones in Google Calendar

Home » Planning & Forecasting » Page 3

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting Planning & Forecasting, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, TM1

Apex Entertainment Performs Enterprise Planning with Workday Adaptive Planning

February 9, 2023 by Revelwood

Success Stories

How do you move away from spreadsheet-based budgeting, forecasting and reporting for more insight into the operations of the business? With Workday Adaptive Planning.  

Apex Entertainment, headquartered in Marlborough, MA, operates four family entertainment centers in the northeast U.S., including Virginia Beach, Syracuse, Albany and Marlborough. Apex offers attractions that are fun for all ages, with activities such as Indoor Go Karts, Bowling, Laser Tag, Escape Rooms, Ropes Courses, Arcade and Redemption, Sports Simulators, Axe Throwing, Mini Gold, Bumper Cars, Virtual Reality and state-of-the-art event meeting space. Each location offers a full-service dining experience in The Pit Stop Tavern, with a menu that includes 80 gluten-free options as well as vegetarian options. 

“Relying on Microsoft Excel to manage our financial processes handicapped us more than helped us,” said Marcus Kemblowski, COO, Apex Entertainment. “We needed a solution that gave us insight into how to fix problems and would enable us to manage our business in real-time.” 

Apex Entertainment selected Workday Adaptive Planning and Revelwood. The goal of the implementation was to easily see how the business is doing, down to the location and the attraction. Now, with Workday Adaptive Planning, Apex Entertainment has the information available to make strategic decisions. The team can analyze and assess potential expenses regarding forecasted revenue by activity. 

“From the get-go, Revelwood clearly understood our business. They immediately knew what we were discussing and hot to get us to where we needed to go,” added Kemblowski.

Apex Entertainment is not done with its plans for Workday Adaptive Planning. “Workday Adaptive Planning can help us to get where we want to go,” commented Kemblowski. “We now can easily perform top-line to bottom-line budgeting and forecasting. The insights generated by the application are invaluable to the company’s growth.  

Interested in learning the full story? Read the success story to learn how Apex Entertainment benefits from Workday Adaptive Planning.

Read more blog posts on Workday Adaptive Planning:

FP&A Done Right: ESG – An Imperative for Growth

FP&A Done Right: Forecasting Revenue for Services-Based Businesses: A Growth Factor

Home » Planning & Forecasting » Page 3

Filed Under: Success Stories Tagged With: Adaptive Planning, Planning & Forecasting, Workday, Workday Adaptive Planning

  • « Go to Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4
  • Page 5
  • Interim pages omitted …
  • Page 17
  • Go to Next Page »

Footer

Revelwood Overview

Revelwood helps finance organizations close, consolidate, plan, monitor and analyze business performance. As experts in solutions for the Office of Finance, we partner with best-in-breed software companies by applying best practices guidance and our pre-configured applications to help businesses achieve their full potential.

EXPERTISE

  • Workday Adaptive Planning
  • IBM Planning Analytics
  • BlackLine

ABOUT

  • Who We Are
  • What We Do
  • How We Help
  • How We Think
  • Privacy

CONNECT

World Headquarters

Florham Park, NJ | 201 984 3030

European Headquarters

London & Edinburgh | +44 (0)131 240 3866

Latin America Office

Miami, FL | 201 987 4198

Email
info@revelwood.com

Copyright © 2025 · Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.