Excel Drop Downs on iOS! FINALLY
If you are anything like me, you’ve been searching aimlessly for an app forI your iOS device that allows you to use drop down menus created with Excel. THE SEARCH IS OVER!!!!
CloudOn is a new app (currently only available in the US app store) that brings Microsoft Office (in its entirety) to the iPad. It uses Dropbox and allows you to open sync cloudon to your Dropbox and access files from there. The only thing I’ve checked out so far is excel, because it was my main goal with it, and guess what, it allows you to use drop down menus! I can’t tell you how great this is, not just for me, but for a lot of excel users put there!
This is fantastic news!
UPDATE: turns out they were only letting a small number of people sign up for testing, so if you didn’t get in, you’ll have to wait.. You can sign up for to be updated on space opening, on their website
Top 11 Posts of 2011
I’ve been away on vacation for the past 2 weeks, so I didn’t post this on December 31 like everyone else.. but incase you are interested, here are my top 11 posts of 2011.
Use Pandora Radio On Your iPhone in Canada
HotSpot Shield for iPhone DOES Work
Canadian’s Can Access Netflix USA
Get Spotify in Canada
iOS 4+ Compatible Slim Slider Theme
John Mark McMillan Signs with Integrity
My Modded iPod Touch
OnSong iPad App for Worship Leaders
Funny Christian Advertising
Mac ToDo/iPhone.. The Way it Should Be
My Favorite Pod Patches
This past year I’ve really been focusing on the tech posts (as you can see from my Top 11). This wasn’t my initial purpose with the blog. Originally I planned on posting a lot of ministry based stuff, and I did some of that, but looking at the stats, that wasn’t the stuff getting the hits this year. So my plan (do I dare call it a resolution) for 2012 is first of all to post more, but I’m going to continue to focus on Tech stuff, but I’m planning to specifically post more on Tech in ministry. So the coming months will hopefully provide you with some great tech tools and tips that will help your ministry, whether you are in youth ministry, worship, tech, whatever ministry you may be in. I will also continue to post random cool hacks I find like Pandora in Canada (it had over 10,000 hits in 2011).
Create Custom Templates in Pages for iPad
Apple didn’t create a simple button in Pages for iPad to turn a document into a template, like they did in the desktop version. So how do we create our own custom templates for Pages on our iPad? A lot of us use iPads because of their convince in business, but how convenient is it if you have to add your business header or footer every document? It’s not..
I have however found a way to create custom “templates” for Pages on the iPad.. And you can do it right from your iPad.
Step 1: Open pages and create the document that you want to be a template.
Step 2: save that document as you would normally on your iPad. Give it a name
Step 3: go to the screen that lists all your documents that are on your iPad, your newley create document should be there.
Step 4: tap the edit button this should cause all the documents to wiggle
Step 5: select your document that you want to be the template
Step 6: tap the + button in the top left corner. This will create a duplicate of the document, thus you will continue to have your original template document, and will then edit the duplicate.
Happy templating!
OnSong iPad App for Worship Leaders
Back in August, after much debate (about 1.5 years of debate) I finally decided it was time to take the plunge and purchase an iPad 2. I got the 16gb wifi version, as I didn’t feel I had any need for the 3G version” because I always have my iPhone with me, which I can use to tether to the iPad and access the Internet that way if necessary, I also went 16gb because I figured the thing that takes up the most space is music (for me anyway) and again, I have my iPhone which has around 2500 songs on it.
One of the main things that changed my mind and helped me to decide it was time to get an iPad was 1 app. Most of you know that I am a worship leader in my church, which means I have a lot of music in books and folders and… Well.. All over the house really. I’ve never been very good at keeping a proper music book.. I just don’t have the patience for keeping it in order, so I found I was printing my music sets every week, which in turn was a huge waste of paper, because I would end up with 10 copies of the same song.. Not very environmentally friendly.
Cue OnSong. OnSong is a app made for worship leaders (though it can be used by any kind of musician really).. Basically it is a digital song book… But you don’t have to scan all your current music and import them as PDF files,, you see, onsong has import features built right in that allow you to type the name of the song, and if you are connected to the Internet, it searches different music websites and finds the chords for you. The most recent update, which is the one I’m most excited about, it even has SongSelect built right into it, so if you have a CCLI subscription, which, if you are leading in a church, you really should have one, but it allows you to now, not just search from different websites, but also the ccli database of thousands maybe millions of songs, and import the right to your iPad.
OnSong also has a lot of really useful built in tools, such as transposing, though it only works on text based songs.. What it does is, if you find a copy of a song, but its in the key of D and you want it in G, you merely select the transpose, pick the key, and it automatically transposes the whole song for you, this has become a very handy feature, though now with SongSelect built in, you can just pick the key you want, and you’re good to go.
There are a lot of great tools built into OnSong that make things easier for your whole team as well. You can export a whole set list you’ve created as PDF files and email them to your team, so you know you all have the same keys and words, this is very handy as I’ve found different times we will have 3 different versions of a song, which all have slightly different words.
In the latest version they have created something called OnCue, which allows you to wirelessly share your set with your team LIVE.. What it does is, if you all have OnSong, be in on an iPad, iPhone or iPod Touch, you engage OnCue and whatever is on the leaders device, shows up on everyone’s device.. Which means you don’t all need to have copies of the music, as long as 1 person has it, you are set.. Then when the leader, who, for example, may have a wireless foot pedal connected to turn pages, turns a page, it automatically turns the page on everyone who is connected, no one gets lost, everyone is on the same part of the song. I’ve found this to be especially useful, as I often don’t do a song in service, the same way we may have practiced it.
There are a tonne of other great features, such as the ability to plug in an external monitor for sharing with the band, or plugging in a projector to display lyrics for your congregation, though I haven’t used this one yet, as we have a tech team who does all that, but the monitor is very useful if you have team members who don’t have a iOS device.
Enough reading, please take a few minutes to watch the following video, which describes and shows how I am using this great app in our worship environment.
With that, let’s get to the good part.. The developer of this wonderful app has sent me 10 copies to give away.. They are first come, first serve.. Just take one of the 10 codes below and plug it into the “redeem” section of the app store, and you will get a free copy of OnSong. If you do use a code, please take a minute to comment below to let me know which code you used, so I can update this post as they get taken, so people aren’t wasting their time punching in all the codes.
X3YEPKP679HM
KFL7YXMK3NFJ
97TE49XA7JNH
FY7WTEFKXRMP
AMJET6JRT6W7
LAXRL47L93MP
MFM67PT9F39W
RWJ3AR6YTKMA
MN4LA6L9YE6T
KNMHJNPYT7NT
If you miss out, the app is a fair price… $4.99 an you’ve got a full worship book in front on you.. You can get it here
Adobe Announces Carousel
I’ve only been an iPad owner for about a month, but I’ve been looking into the iPad for a very long time, weighing and out weighing the benefits of buying one.. finally coming to a place where I decided in August to buy an iPad 2.. more on the big reason for the decision in a later post..
One of things I’ve thought would be great is if someone put out a REAL photo editor for the iPad, that gives you more than just a couple filters, but instead some true editing functions.. this would allow me, as a photographer out in the field, to take photos, and do a full edit on a photo.. it would be useful for a number of reasons.. those quick shoots where you need the final product quick for 1.. for example a headshot shoot.
Just last week it seems my hope of a true photo editor has come to be. Adobe, who is mostly known for their feuds with Apple, has finally decided its time to stop being childish and utilize the amazing tool that is the iPad. With that, they introduced Adobe Carousel, which should be released later this year.
While I’m not crazy about the pricing, I do think it looks like a well worth product. Right now they are saying you utilize their cloud, upload your photos to it, and then can access them on your iPad, iPhone, Mac.. ETC… I’m hoping there is an option to use your own server if you have one, instead of forcing you to use theirs, because I already spend enough money each year on servers.. don’t want to have to buy another one.
The Adobe® Carousel app is the only photography solution that gives you access to your entire photo library from all your iPads, iPhones, and Macs — no storage issues, no manual syncing hassles. Enjoy your photos anywhere you are, and make them look terrific using the same powerful photo-processing technology as Adobe Photoshop® Lightroom® software.




