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!!
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
Is there an affordable app that will move an Excel spreadsheet into an html document without losing the format? Or a method of doing it? I've done it before but can't remember how I did it.
I have spent the last few hours trying every solution that is supposedly available for converting VCF files to an xls file. WHY can't this be an option in the Contacts program? I need to upload some contacts to Constant Contact. Come on! Really! There must be an answer that doesn't require me to convert two - three times before I can use the files.
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.
How can I resize my spreadsheet so that it fits in the office for Mac excel spreadsheet when opening an existing windows file? Last column goes to another page.
My father owns one of the original G5s, so its power pc not intel. Today while browsing an excel spreadsheet he says part of the screen turned black, then the monitor shut off, then the monitor came back on but not video. Mean while the fans started spinning out of control. Now when he tries to turn it on, he gets power, but all that happens is the fans spinning faster and faster and faster until he turns it off. No video or anything. Just speeding fans. He fears the CPUs died since they control the fans. Any suggestions? He also says the fans were spinning unusually fast these last few days.
I have 2 Imacs, both running OS 10.9.3. The run on a simple office ethernet wired network. We have had no problems until yesterday when suddenly one of the Imacs (Imac A) disappeared from the network. Imac A could see Imac B but not the other way round. Imac A connected to Imac B but was denied access to all the folders under the user directory on Imac B. The folders all have the no entry icon on them and if I try to open them I get the message "can't be opened because you don't have permission to see its contents" . I have checked that the sharing set up on both machines allows access read and write on items and we have been successfully sharing files for months.
I have hooked up an old Mac Pro running 10.8.6. to the network. It can see both the Imacs but when I transferred files from that machine to Imac B I got the message "can't be opened because you don't have permission to see its contents". I've checked and the permissions on this folder are set for all to read and write.
So far I have checked and repaired privileges using disk first aid.
The Imacs are both 3.1ghz Quad core i5 running 10.9.3.
I have transferred all my old computer through its back up to a new macbook pro. Everything seems in order except for the emails which are not being received - in fact not able to get on to the page for emails at all .
I created a partition on my new iMac for 200gb and cloned my old MBP with an external HD. I tried to open it from the connected external HD and it wouldn't let me. I tried transferring the files from the external hard drive to the partitioned HD on the imac and it said this operation could not be done........
Also I tried booting from the external cloned HD and can not do any functions with my iMac as the keyboard and mouse are bluetooth and it does nothing when I type...
I have successfully transferred all my music from windows to my new iMac, but I am unable to drag and drop them into iTunes. I was told before purchasing that this would be no problem. I can play all the tracks individually but it uses Quicktime to play them. Am I missing something? How can I get them across to iTunes?
Transferred data from PC to iMac. Emails going back to 2008 that I want to remove from Gmail 'All Mail'. Have tried merely delete, establishing a folder for 'old emails' then removing them to trash and emptying trash, and creating a filter to clear old messages from Gmail Inbox. Nothing works - they keep coming back. Help, I do not need them on my computer.
I'm using a Mac, Mavericks 10.9.4, a few days ago I deleted my outlook account (of my previous job), and now I can not find any folder that may contain the files. now iCloud sync was done...
Other threads suggested the following paths such as " ~/Library/Containers/com.apple.Notes/Data/Library/Notes" but none of them seemed to work (the library folder is not to be found!) ...
I transferred about 400 gigs of data from my MacBook Pro to my new iMac using Migration Assistant, but can't find any of my data on Finder. I'm thinking that the data got transferred but not cataloged. Finder shows about 400 gigs of my hard drive being used, but the files it shows don't come anywhere close to 400 gigs. How can I find out what is really on the hard drive and how can I access my MacBook files I transferred?
Sometimes as I send an email I won't find it in sent folder. It happens especially when I save a message in drafts before sending it or when I put addresses in cc or can.
This Macbook Pro has been running Mavericks from the beginning and has gone through at least one other upgrade. After upgrading to 10.9.4 today, this popup keeps coming, sometimes with an application/account name sometimes not. Of course "login" is fine in keychain and many applications/Web sites using "login" keychain continue to work, including those implicated in popups. I tried "Verify/Repair" in Keychain First Aid. No error found. I tried to repair file system in Disk Utility. Nothing changes.
So, we have a bunch of computers that we need to install Mavericks on. After the second or third download, we decided to try to be smart and copy the installer to an external hard drive before installing. Now, when trying to install it on some of the remaining computers, it doesn't get very far and then comes up with an error that says something about required system files not being found. I will get the exact wording later when I go back to the lab. The installer already deleted itself from the other computer.
You must understand, downloading a >5GB file on a 25KBPS internet connection is agonizing, and these remaining computers need to get Mavericks on them soon.
I recently purchased a MacBook Pro with Microsoft Office 2011 included. Everything works well until a put numbers into Excel. No matter what I change, numbers will have separators as per the Indian system. That is, in stead of 1,234,000, it will automatically put 12,34,000. I've tried everything I know to change the setting, but it always defaults to this.
I have 5000 contacts stored in Excel sheet and I am using Office 2010. It’s such a cumbersome task to copy each contact in Gmail for bulk emailing. Is there any online tool available through which I can convert all these contacts into single VCF file?
I might be going mad but I have bought a new portable hard drive today & I erased it using disk utility as it was a Windows one and then added it as a new disk in Time Machine.
I expected to find a check box to encrypt the data but its not there.
I encrypted the other portable HDD's I have but can't see from the description now if they are or not. I am certain that they are however.
The new disk is 1.55 TB free of 2 Tb's, the previous one is 1.43 free of 2 Tb and my oldest is only 253Gb free of 1Tb. I guess that the difference is the amount of old data and backups I have done with Time Machine already or hasn't it backed up properly?
One last thing, on the Time machine prefs there is an option button & when I click it it says "excludes these items from backups" and it lists the new portable HDD and the size of the backup which is 447.09Gb. It estimates the size of the full backup as 492.65 Gb. What this means & whether its set up correctly?
I am using Mavericks 10.9.4 & an iMac 2.7 GHz Intel Core i5 machine
Info: iMac, OS X Mavericks (10.9.4), 2.7 GHz Intel Core i5