Excel programming: Gather informations via API & read / write files

  • Статус: Closed
  • Награды: $80
  • Полученные заявки: 10
  • Победитель: mrbrave

Краткое описание конкурса

Have a look at the zip file. It contains the files to read in and an Excel sheet with an explanation.

Рекомендуемые навыки

Лучшие заявки этого конкурса

Показать больше конкурсных работ

Панель общих вопросов

  • AlbertoBarberoIt
    AlbertoBarberoIt
    • 3 недель назад

    I sent my proposal with two screenshots, but I see only one. Can you confirm to me that you see the second one? In the second one there are the results, so it's fondamental that you see it to judge my work. Thanks in advance for your kind reply. In case, contact me to tell me how to send the second one.

    • 3 недель назад
  • melitacapulco30
    melitacapulco30
    • 3 недель назад

    Hello. I have read the instructions you wrote in the excel. I only need further clarification with the instructions given. Do you need the 24hour weather data? If so, that would mean if I start gathering data from DarkSky API on November 15 1am, I must take the hourly data up to November 16,1am?

    • 3 недель назад
    1. Tobiaszu
      Организатор конкурса
      • 3 недель назад

      Yes, you're right. Thank you.

      • 3 недель назад
    2. melitacapulco30
      melitacapulco30
      • 3 недель назад

      May I ask if you have a target date to get this project done? I would like to negotiate if you don't mind. Please inbox me. Thank you

      • 3 недель назад
  • mrbrave
    mrbrave
    • 3 недель назад

    I have posted my entry with couple of screenshots and a video recording.Also left you message about sending full file for testing.

    • 3 недель назад
  • boscojfelix
    boscojfelix
    • 3 недель назад

    As per my understanding. Macro should create file Weatherdata.xlsx. And create 1 sheet for each zipcode*.csv file like sheet1 Name = at, sheet 2 name = de ... So there will be total 4 sheets in Weatherdata.xlsx workbook. Now I collect temperature and other weather data and update weatherdata.xlsx which will add more rows. Now calculate mean temperature and total percip. Now sheet at will have 100 columns, of which 1 column is row headers so total 99 columns. Now macro will create 99 csv files with names like eg. at7000_2019-11-13.csv. Again for next sheet i.e. ch contains 110 columns so 110 csv files. But we got a problem here sir. There are columns which has same zipcode. If we save those files separately we cannot. Please check the screen shot. https://pasteboard.co/IGus4DK.png

    • 3 недель назад
    1. boscojfelix
      boscojfelix
      • 3 недель назад

      Output of my half done work Sir. https://workupload.com/file/bXGzjw7d

      • 3 недель назад
    2. boscojfelix
      boscojfelix
      • 3 недель назад

      I'll try registering in darksky.net and obtain a key Sir. If you say I'm going in wright direction Sir.

      • 3 недель назад
  • mrbrave
    mrbrave
    • 3 недель назад

    I will develop program and send you screen shots and if possible video of working tool.You can see and if interested, award and I will send you full working file for further testing and make any required changes..... Free quota is 1000 calls per day. Will that be fine for you or you have paid subscription?

    • 3 недель назад
    1. mrbrave
      mrbrave
      • 3 недель назад

      Problem with the contest is they only allow to post images as a entry.If I post full project in description..that will be open to all people.

      • 3 недель назад
    2. mrbrave
      mrbrave
      • 3 недель назад

      lets complete first and send entry...then see how it can be sent to you

      • 3 недель назад
  • boscojfelix
    boscojfelix
    • 3 недель назад

    Dear Sir Can I get your Dark Sky secret key?

    • 3 недель назад
    1. Tobiaszu
      Организатор конкурса
      • 3 недель назад

      Can you pleasse obtain a key for your development and use a cell in the sheet to put in a key?

      • 3 недель назад
  • rifatahmedph
    rifatahmedph
    • 3 недель назад

    Thank You , Im Microsoft Office World work Chose .

    • 3 недель назад
  • amwazeindia
    amwazeindia
    • 3 недель назад

    One question. Do you want this program to run for only this data set or for others too ? If we are to go by your instructions, you need a program that reads the *.csv files in a particular folder and then consolidate data into a sheet based on the zipcodes. But if the formatting of each csv file is different, the program won't run. For eg: the first csv file (_at.csv) seems to be a cleaned up one with properly formatted as an excel sheet but with a csv extension. Whereas the others are raw csv files , which needs clean up or perhaps not . So these kinds of mix ups will render the program useless. Coming back to the original question, if you want the program to run only for this data set, then i can create a code that reads the csv file ( _at.csv) separately and copy it into the master sheet and then loop reads all the other ones . Hope i was able to convey the issue. Thank you

    • 3 недель назад
  • mtdevil369
    mtdevil369
    • 3 недель назад

    can you award me?,,i will start your work.thank you

    • 3 недель назад
    1. Tobiaszu
      Организатор конкурса
      • 3 недель назад

      I could award you to work for a project. This not a project but a contest and when I award you, you'll get the money immediately. Look at the faq page to see how a contest works: https://www.freelancer.com/faq/view.php. Please write the program. I'll check it and I'll award you as the contest winner, you'll get the prize.

      • 3 недель назад
  • markelof
    markelof
    • 3 недель назад

    Hello, I think that I can create windows software for this. It will have a user-friendly GUI. You will be able to use it as many times as you want. I will also offer you free support in case if something stops to work in the future. If that's ok with you I will submit my entry tomorrow, the explanatory video will be included.

    • 3 недель назад
    1. Tobiaszu
      Организатор конкурса
      • 3 недель назад

      Thank you. I want an excel software in VBA.

      • 3 недель назад
  • Tobiaszu
    Организатор конкурса
    • 3 недель назад

    I'm out of the office now and I'll be back in about seven hours.

    • 3 недель назад
  • mtdevil369
    mtdevil369
    • 3 недель назад

    i am waiting for award now

    • 3 недель назад
    1. Tobiaszu
      Организатор конкурса
      • 3 недель назад

      Great. I look forward to getting your input. Please upload it to a sharing platform like workupload.com. I want to test it before awarding you. Thank you.

      • 3 недель назад
  • writingapp
    writingapp
    • 3 недель назад

    hi. This project is simple. You just need API results are writen to excel or programming code needs to be in excel too (VBA)?

    • 3 недель назад
    1. Tobiaszu
      Организатор конкурса
      • 3 недель назад

      Yes. Make the API calls from Excel (VBA) and also the file read / write.

      • 3 недель назад
  • melitacapulco30
    melitacapulco30
    • 3 недель назад

    #increaseprize

    • 3 недель назад
  • mtdevil369
    mtdevil369
    • 3 недель назад

    when do you award me??

    • 3 недель назад
  • mtdevil369
    mtdevil369
    • 3 недель назад

    okay...i understood

    • 3 недель назад

Показать больше комментариев

С чего начать в организации конкурсов

  • Опубликуйте свой конкурс

    Опубликовать Ваш конкурс Быстро и легко

  • Получайте тонны заявок

    Получайте тонны заявок Со всего мира

  • Присудите приз лучшей заявке

    Присудите приз лучшей заявке Загрузите файлы - это легко!

Опубликуйте конкурс или присоединяйтесь к нам уже сегодня!