Check your numbers

Still Pulling Data

Check your numbersI’m still working on converting numbers from PDF files so I haven’t had a chance to write here or come up with decent accompanying pictures.

I couldn’t convert from PDF straight to Excel; I had to do a roundabout method via converting first to Word and then copying and pasting from Word to Excel. This method takes a lot longer than if I could have “automated” the conversion but that requires the converted file to have numbers laid out in a fairly consistent manner.

The Adobe conversion software also does not convert very well in another way. When Adobe converts to Word, the resulting image looks like is it an exact copy of the PDF. Unfortunately, when I tried to tie back my numbers to the summary page, I found that I was actually missing some entries. I had to go back to the PDF file to find those missing entries.

Moral of the story: double check your numbers!

Similar Posts

When Strange Results Pop Up
| |

When Strange Results Pop Up

It doesn’t happen often, but every once in a great while, I will see something strange in the numbers or graphs. Generally, I’m not so good at catching these weird results; I find other people are better at spotting the possible errors, which is why I rely on Excel or a program to do that…

Shock! A new country in the top 10
| |

Shock! A new country in the top 10

I wasn’t going to do a post tonight but last night, when pulling in the latest set of numbers, something shocking jumped out at me: China became part of the top 10 countries in the world with the most daily cases over the last 14 days. I never really seriously tracked China largely because I…

So, we’re in fall now – what is coronavirus doing?
| |

So, we’re in fall now – what is coronavirus doing?

And here’s China: I had wanted to post this over the weekend, but I got busy with other stuff. Been meaning to do this yesterday, too, but was distracted. So now, I’m catching up. It’s time for a follow up to see what the “condition on the ground” looks like, especially since we are deep…

New Year’s Day Surge!
| |

New Year’s Day Surge!

I was going to do a post purely on hoping for a better year and what not. Not sure what I would have written about, but it would have steered away from the coronavirus. However, with the surge and the terrible weather at the end of the year, I feel like I need to briefly…

Managing Your Data…or Not

Managing Your Data…or Not

[Note: this post is experimental. I’m playing with CSS to see how it works.] If you work with numbers or data for any length of time, I would expect that you would converge on some form of standardization or consistent methodology, but curiously, I often find that is not true. And I’m having a hard…

Working with Messy Data Again
|

Working with Messy Data Again

Ahhh, I’m working with another one of those downloads where the data do not lie in nice columns. I want to be able to compare data between two different downloads to make sure that the data is migrated correctly from one software to another. I would like to make Excel do most of the comparison…