Applications :: Spreadsheet Thats Cross Platform W/ 5 Level Sort
Oct 30, 2009
I need a spreadsheet program that can:
1. Operate cross platform (my IT guy�s PC, I�m Mac)
2. Sort capabilities to five, ideally six, levels
3. Capable of using macros
4. Can convert spreadsheets for an html (online) environment
I founded a national grassroots movement thats gone viral. We list registered supporters on our site, using Google Apps forms, the copy the content into an Excel spreadsheet. A friend out of state (PC user) is able to work magic with macros that magically sorts, fixes, and converts the lists to appear in our online directory (you can see an example at http://www.the350project.net/states/states_a-d.html). I created the graphics; he somehow builds the page using those plus the spreadsheets.
This is something I really need to be able to do on my end, as the owner of the site, but MS took macros out of the Mac version of Office Excel....OpenOffice only sorts three levels, and he says we need at least five....
Since I have no intention of becoming a PC user, I need to find a software program that will work on a Mac and still be able to do all this. I realize many (most?) software programs are capable of opening and saving .xls files, but the multi-level sort, macros, and html are critical to any of this working, according to him.
View 11 Replies
ADVERTISEMENT
Jan 13, 2010
I would like to be able to have my email set up on a usb memory stick so that I can carry it around, plug it in to a mac and there's my email or plug it in to a pc and hey presto theres my email again.If that's not enough then I would like to be able to have multiple email accounts on the (living in a dreamworld) email client.Anyone got any ideas? I have tried a version of thunderbird that was sort of cross platform and mobile but it didn't work too well and writing a letter and posting it may well have been quicker at times.
View 2 Replies
View Related
Jan 25, 2006
I have sevral large DV files that I need to move to a PC at a different location. On hand I have a FAT formatted firewire drive, but obviously It can't store files larger than 2 gigs, so I'm looking for the fastest way of splitting these files into chunks, and then re-assembling them on a PC.The options I see so far are using a compression tool which will split at the same time (stuffit, rar, or even zip) (but I'd rather not waste time compressing when it's not nessesary) or using a raw file splitter like Split&Concat, but I don't know if these are cross-platform, or what to use on the PC end to rejoin the files.
View 9 Replies
View Related
Sep 2, 2010
I'm currently working out of iWork on my mac doing papers with a large amount of equations in them; however, when I travel to school they only use Windows and Microsoft Office...is there any program that can offer cross compatibility between them? (ie. if I make a document in Pages I can use either latexit or mathtype, but when I open up in Word 2007 or 2010 will the equations come up? Likewise, if I put equations into a Word document, when I open them up in Pages will they show?)
View 5 Replies
View Related
Sep 16, 2009
Not sure if this should be under "Running Windows on a Mac", but this isn't exactly Windows... so here it goes.
I am trying to run TF2 via CrossOver Games 8.0.0 on Snow Leopard using the specs described in my sig. I've placed a support ticket with them, but they haven't been answering quick enough to my liking; I have an itchy trigger finger, I guess. So, has anybody had any experience with Wine and/or CrossOver that could help me out? For the sake of brevity (plus I don't want to type it out ), here's the link to the support ticket describing my problem.
View 1 Replies
View Related
Aug 31, 2010
I've created a spreadsheet for budgeting purposes and to keep track of my money (student). I know that on certain days (like Payday) the amount I will be paid and obviously the date. I want to be able to put this in my table but not to be added to the formula until that date is passed or met.
For Instance, If I get paid on 01/09/10 and put this in my table, the formula will add this amount to the total income for the month of September. The funds have not actually been paid to me however, so they need to be excluded until they are paid i.e on the 01/09/10.
View 2 Replies
View Related
Oct 31, 2010
I spend my working life in Excel 2007 and I just can't bring myself to replace my home budget spreadsheet to a true numbers format.
View 5 Replies
View Related
Apr 8, 2009
Would anyone have one of these or be able to point me in the right direction for one? I don't mind having to pay for it.
View 3 Replies
View Related
Jun 8, 2010
Im currently using an Excel spreadsheet, but my business is expanding so I need to use something more functional. I have tried Sage and Quickbooks but didnt really like them, not to mention the price was ridiculous.
View 9 Replies
View Related
Apr 23, 2007
I initially made a slide show of 250 old family photos in iPhoto. It looks great and the cross dissolve function is very smooth.
However, I now need to take portions of music rather than entire songs and blend the songs into each other. This requires that do the slide show in iMovie so can use the timeline to edit the music to fit with certain portions of the slideshow.
The problem that I am running into is that the cross dissolve function in iMovie is jumpy and not smooth like it is in iPhoto. Also, some photos have "stuttering" and flashing between the transitions. I have tried adjusting the cross dissolve time and length of photo and can't seem to get it to look right. Can anyone tell me what I am doing wrong? For example, if I want each photo to be on the screen for 3 seconds, how long should I make the transition? If I remove the transitions, this problem is gone. But then the photos just go from 1 to the other after 3 seconds and the effect is a bit jarring. I'm stumped. In addition, the image quality does not seem as good as in iPhoto - but if I use iPhoto I cannot make a title page or time the music.
View 1 Replies
View Related
Jun 1, 2009
I am trying to have a song playing in the background of a movie I am creating. It needs to change volume part way through. Its my understanding this has been removed in imovie 09. How would I go about doing this? Is there any work arounds?
View 6 Replies
View Related
May 11, 2010
What application everyone use to edit their songs. i am looking for a application that i can use to make the db level of the songs higher/louder.
View 5 Replies
View Related
Jul 8, 2010
I was wanting to know how to sort a list of birthdays in excel by month and day only (Not including years); I also tried to add only the month and day data but it kept sticking 2010 on the end.
View 1 Replies
View Related
Apr 22, 2003
I would like to sort my bookmarks. I must be blind since I cannot find or see anything on how to it.
View 24 Replies
View Related
Jan 3, 2011
Every time I change the artist, iTunes changes the way my albums are sorted. It always reverts to sorting by album, alphabetically. How can I have it sort by year as to give the albums chronologically? I use grid view.
View 2 Replies
View Related
Jun 25, 2005
By default, the mailboxes in Apple Mail are sorted by Date Received, Oldest first. I tried sorting a few of my folders to be 'Newest First' instead, but I would have to do it for all of my folders, and I have about 150 folders.
What is the fastest way to sort all my folders to the way I want it?
And for all new folders?
View 6 Replies
View Related
Mar 8, 2009
I've recently decided its time to sort all my tv shows into iTunes so that I can access them easily in FrontRow. I've imported two seasons of a tv show and all the episodes are named correctly, numbered right, season info set up right etc. If I click the "TV Shows" section in iTunes I get two entries for my show, one for Season 1, one for Season 2. If I use Front Row, it simply gives me two entries for the tv show but I don't know what season it is until I click through. Surely there must be a way to have TV Shows -> Series -> Season? Otherwise this whole TV Shows thing will be useless to me since I'll end up having to scroll through loads of seasons for all my shows in one place on Front Row i.e. if I put all of my seasons of Enterprise and Stargate SG-1 then Front Row would show this under the TV Shows option:
Enterprise
Enterprise
Enterprise
Enterprise
Stargate SG-1
Stargate SG-1
Stargate SG-1
Stargate SG-1
Stargate SG-1
Stargate SG-1
Stargate SG-1
Stargate SG-1
Stargate SG-1
Stargate SG-1
Which would be unusable because I have at least 10 series on here and in total at least 50 seasons, probably a lot more.
View 5 Replies
View Related
May 2, 2009
For several days I have been unable to sign in to Microsoft Messenger. I have the leaked 8.0 version. I thought maybe it was a problem with the leaked beta but I can't sign in using aMSN either. I can sign in to web based substitutes like eBuddy, but it's still very annoying. Whenever I try to sign in on the actual application it just tries for awhile and then says the service is not available or you may not be connected to the Internet.
View 3 Replies
View Related
Aug 31, 2009
I need some help to convert .dv and .avi files to ipod touch compatible files using handbrake. When I try to choose either file type as the source file it just says 'no valid title found'.
The .dv file is a clip shot with my video camera and imported onto my mac using imovie, then saved as separate full quality file, in order to have a separate file that is not sitting in imovie.
The .avi file is a downloaded movie.
Both movies play fine in quicktime player and VLC player.
The Handbrake program does work as I have successfully converted a file ripped from a dvd using mactheripper.
I am surprised that I can't get it to work, as other threads on this forum recommends handbrake as the best software for video conversions for ipod.
View 6 Replies
View Related
Jan 23, 2010
I'm trying to import iPhoto Events into Aperture through Aperture's built-in function (File->Show iPhoto Browser). But the Events are sorted alphabetically instead of by date. I can't figure out how to fix this. On a couple of occasions I've opened the iPhoto Browser to find it sorted by date, so I know it's possible. Was it a fluke or is there a workaround?
View 4 Replies
View Related
Jan 21, 2010
How do I get Aperture's built-in iPhoto browser to sort iPhoto Events by date? Over the last year I've switched from iPhoto to Aperture. I prefer iPhoto Events as an organizational scheme, sorted by date, so I am re-creating a chronological scheme with Aperture -- as many do. I've been gradually and selectively importing hundreds of iPhoto Events into Aperture Projects by dragging them from Aperture's built-in 'iPhoto Browser'. Here's the problem: Aperture's iPhoto browser shows Events, but they are annoyingly sorted alphabetically, rather than by date. This makes it a real pain to transition chronologically.
I can't find any control to re-sort by date. Inexplicably, on a couple of occasions I have opened the Browser to find it sorted by date! Temporarily rejoicing, it soon reverts to alphabetical after one session. WTF? I have a hunch these couple times were flukes, possibly having to do with iPhoto being open at the same time, I dunno. Still, I now know it's possible; and if it involves some weird workaround to re-create it, I'll do it. I'm running Leopard 10.5.8, Aperture 2.1.4, iPhoto 7.1.5.
View 4 Replies
View Related
Apr 30, 2010
i would like to sort a list into alphabetical order automatically, i know Office 2007 does this. would seem lazy if Apple didn't put this in... and i have 70 References to sort.
View 4 Replies
View Related
Oct 21, 2010
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do!!
View 3 Replies
View Related
Oct 21, 2010
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do
View 1 Replies
View Related
Mar 9, 2009
I would like to Sort my Email in Apple Mail by Attachment Size. So I can delete my biggest attachments, so i can get more space. How do I sort by attachment size?
View 1 Replies
View Related
Nov 2, 2010
Subject says it all... I'm trying to strikethrough or cross out text.
View 2 Replies
View Related
Jul 26, 2009
How do you get the NEWEST version of Cross Hell for �Mac
View 2 Replies
View Related
Oct 5, 2010
I am using FCP 6.06, I imported video from two different video camcorders: Canon GL-2 mini-dv and a Sony Digital 8 TRV340. Importing from both of these cameras went pretty well, i had some dropped frames while importing, nonetheless it went pretty well. However, when i drop any of the footage into the timeline and I press play, it will play for a few seconds, hang up (spinning wheel) and then gives me a window that says: RT extreme has determined that these were caused by slow disks, please try: Increasing the speed of your disks, Decreasing the number of RT layers, Limiting your RT bandwith. AS of now i currently use a 1 TB Western Digital "My Book" for my scratch disk. I have tried everything I can think of and I am working on a Wedding video.
View 5 Replies
View Related
Oct 20, 2008
I've only recently added release years to all my albums and now I sort by album by year, which is great. However, I'd like to make some smart playlists based on decades, and this is a problem for anything on some sort of anthology or greatest hits collection. For example, the Barenaked Ladies greatest hits CD was released in 2001.
If I tag the whole album as 2001, it sorts correctly, but the individual tracks from the 90's won't show up in the 90's smart playlist. The other option I can think of is to tag each individual track with the correct year, but then the album stops appearing in the right place chronologically within the BNL albums, since iTunes no longer knows it was released in 2001.
So my question is this: is there some way to do a sort of "Sort Year" or "Album Year" similar to "Sort Artist" or "Album Year"?
And while I'm at it, I'm sure there's no way, but it seems like it'd be cool to somehow tie a track to two different albums. Previously, if I had a greatest hits and some original albums, I would erase any duplicates from the greatest hits and only keep them on the original album. However, since the release of iTunes 8 I use a more album-based approach to my music. I use grid view with shuffle off by default, and often just click "Play Album". But if I do that for a greatest hits comp, it of course won't play the tracks that I've deleted from it. So I have to keep two copies of the same recording for two different albums. It'd be cool if there was some way to tie one track to both albums to avoid dupes. But again, I'm pretty sure this'll never happen.
View 4 Replies
View Related
Oct 9, 2009
I know it's kind of silly, but is it possible to use Apple Mail's icon and sort of drag'n'drop it to use it on Entourage? I prefer Entourage as my email app, but find Apple Mail's ICON nicer, so would it be possible for my Entourage to use Apple Mail's icon in the dock?
View 2 Replies
View Related
