weather

  1. D

    Sumproduct

    Been having hard time solving this question.I got it wrong and i believe the workings used is the cause of it. Question 1 The following file describes the situation faced by a landscaping company, 'Landscaping Solutions'. If there is great weather, the company takes the following hours to...
  2. W

    Read/import online weather data into an excel sheet.

    He Guys, I am trying to read/import(actuel) weather data into an excel sheet. So i surfed the web for quite some time, but i am hoping you can help me out. I have some experience with vba, but not with reading data into excel. So i will explain what my idea is, I want to read/import actuel...
  3. L

    Creating a line graph that shows the relationship between my business's takings and the weather

    Hi, I'm in need of some help in creating a spreadsheet and graph for my business. I haven't used Excel since I left school so I'm a little bit rusty, but I'm a fast learner. I work in a pub with a large beer garden. I want to create a spreadsheet and line graph that show the relationship...
  4. C

    Instring Search to Return whole Line

    Hi There, I have all text in a cell example Cell A1 Today is hot Last week was cold Today's weather is 18 Next week is 20 I need a VBA code that searches the cell via instring search for example searches "Today's weather" and will return the whole line "Today's weather is 18" which then i will...
  5. A

    Weather Information into Excel using Openweather API Filterxml Webservice

    hi Need help with the following; it is clearly beyond me ! I have an API for openweather.org I can Paste the API info into a Browser and get a response back that looks like this; Webinfo...
  6. R

    web image installed inside a cell

    I have an excel file I use to make my daily task sheet. I wanted to have it include the daily weather forecast with the weather icon, the high and the low. I have worked on some of how to make this work but I'm hitting a road block getting the image to download into the correct locations. I...
  7. R

    NOAA NWS data into PowerPivot

    Has anyone successfully brought in Noaa NWS XML data into powerpivot ? National Digital Forecast Database XML/SOAP Service - NOAA's National Weather Service NOAA's National Weather Service National Digital Forecast Database XML/SOAP Service - NOAA's National Weather Service i can get the SOAP...
  8. A

    Weather

    Hi, I am trying to incorporate a Weather forecast into an excel sheet. Is there any code that can do this? thanks
  9. L

    Complex Web Query Help

    Hello, Basically I have a list of zipcodes and I would like to create a webquery which will pull back the average temperature, rainfall, snowfall for a week (last week or other historical weeks). I found a website which has this info: http://www.wunderground.com/history/ and I can put in a...
  10. J

    Weather data

    Hi I used wolverineb’s formula http://www.mrexcel.com/forum/showthread.php?t=458054&highlight=wind+direction) in reverse to calculate the wind direction in degrees from wind direction in text. The lookup table is This works well after a little tweaking. The formula I am using is...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top