May 2013

Authored by Michael Guerin, TeamCain

We host a lot of webinars on Spreadsheet Server, the spreadsheet automation solution from Global Software, Inc and so we thought it would be a good idea to share the latest news.

For those not familiar with Spreadsheet Server, it basically allows end users to use Excel features and functions to create dynamic reports and dashboard views of your ERP data. It acts like a bridge between your ERP (JD Edwards, PeopleSoft, SAP) and Excel. The data can be accessed, automated and has full...

Authored by Sarah Mack, TeamCain

You may have noticed that we’ve been posting videos to our blog from our friends at Global Software. We’ve already spotlighted Spreadsheet Server for PeopleSoft as well as Spreadsheet Server for JD Edwards. Today’s video is a little different because Distribution Manager, a feature of Spreadsheet Server that uses Excel automation to distribute and...

Authored by Sarah Mack, TeamCain

"Our estimate was it averaged $2 - $5K per report to have them developed by our IT staff using ERW – and we had 500 reports to create. The payback was immense, and the time savings were dramatic."

Check out this video below from our partners at Global Software to see how you can quickly and easily build a report from scratch in Excel and have it automatically update with live and dynamic JD Edwards data!


Authored by Alana Smith, TeamCain

Lately, I have been staying up at night to watch “old school” Batman on the retro channel and I keep wondering... what happens when Batman is off sick, Robin gets kidnapped by The Joker and Alfred is not able to cover for either of them? What happens to Gotham then?! This is why, as the title of this blog states; Gotham City needs a disaster recovery plan.

In Gotham, if disaster strikes, Batman is called to the scene. But if he’s unavailable, then tragedy follows. The same can be...

Authored by Sarah Mack, TeamCain

What do real customers have to say about Spreadsheet Server?

  • "With Spreadsheet Server and Distribution Manager, instead of using precious human capital resources and system resources, we just let the technology do the work. IT loves it that we don’t bother them anymore!"
  • "With Spreadsheet Server, we have had no resistances whatsoever from users."
  • "If you have JD Edwards, you have to have Spreadsheet Server...

Authored by Alana Smith, TeamCain

If you missed Part One or Part Two, you can read them here and here.

So we’ve looked at why we should purge and archive...

Authored by Sarah Mack, TeamCain

What have people been saying after seeing Spreadsheet Server for PeopleSoft in action on our webinars?  

  • “Ease of use, direct link to data without having to run a report from within PeopleSoft.”
  • “Ease of access and change of variables. OMG I WANT!!! Now I have to sell to management!”
  • “It is a potential reporting solution for our organization.”
  • “A decent amount of rekeying going on around the finance departments- a tool...

Authored by Alana Smith, TeamCain

If you missed Part One, you can read it here.

In the first part of this blog series, we looked at why you should purge and archive. Now that you’ve had time to think about your own situation and contemplate your system performance (is it up to snuff?), let’s look at WHEN is the best time to purge and archive.

The question “When to purge and archive and how...

Authored By Alana Smith, TeamCain

As the seasons change, it’s important to keep in mind just how much of an impact the weather can have on your business. I came across this old entry that I wrote during a power outage at headquarters that just goes to show that disaster recovery plans aren’t just for the IT department:

As I type this, I am in the dark. We had a very big wintery ice storm blow through TeamCain HQ today – trees are falling all over and landing on power lines; you can see...

Authored by Alana Smith, TeamCain

It’s that time of year again... Spring Cleaning! It’s time to blow away the winter cobwebs and let the sun shine through. In honour of Spring Cleaning, we’re bringing you another 3 Part Blog Series (last time it was all about Business Intelligence) but this time we are focussing on data purging and archiving best practices. We’re going to look at the “Why”, “When” and “What” when it...