Build a Report Tool PROTOTYPE based on External Data Source

  • Status: Closed
  • Hadiah: $150
  • Penyertaan diterima: 5
  • Pemenang: avi2409

Ringkasan Peraduan

I need someone to build me a solution / application that can:

1. Allow users to select basic field parameters (form) such as start stop dates
2. Search an external (web-based) data source
3. Output results to a spreadsheet
4. Display results in a one-page PDF report

If you're serious, write "Howdy Neil..." at the start of your response and I'll know you actually are reading what I took time to write.

- Data Source: [login to view URL]
- User defined fields on a simple form: Department; Date Range (based on Date Signed); Congressional District)
- Tool should be web-based so it can be added to my site
- Output should be a CSV with all allowable data from the source
- PDF should show Department Name; Congressional District; Date Range (Start and Stop of Date Signed); Total Amount Obligated; Amount Obligated to Vendors in matching Congressional District; Number of Unique Vendors (based on DUNS); Top 10 Vendors (based on obligated funds); Top 10 NAICS (based on obligated funds).

This seems like a simple project and the data is publicly available. What else do you need to know about this project?

First one to build a working prototype application will win contest. I plan to use the prototype to seek additional funds for additional requirements.

Kemahiran Disyorkan

Maklum balas Majikan

“I've worked with Avinash in the past, and he continues to impress me with his professionalism, talent, ability to communicate with me to clarify requirements and dedication to deliver a working, tested product that meets my expectations. I will continue to work with him on future projects and highly recommend him to you for your project.”

Gambar Profil a365guy, United States.

Penyertaan teratas dari peraduan ini

Lihat Lagi Entri

Papan Penjelasan Umum

  • Buckner
    Buckner
    • 1 bulan yang lalu

    Howdy Neil. Should the user form parameter for Congressional District be for Place of Performance Congressional District, or for Vendor Congressional District Code?

    • 1 bulan yang lalu
    1. a365guy
      Penganjur Peraduan
      • 1 bulan yang lalu

      Good catch. Vendor Congressional District Code.

      • 1 bulan yang lalu
  • sakhawat2
    sakhawat2
    • 1 bulan yang lalu

    Howdy Neil. Could you please post an example of the data you're trying to retrieve from the data source (https://www.fpds.gov/)?

    You have pointed out:
    "- PDF should show Department Name; Congressional District; Date Range (Start and Stop of Date Signed); Total Amount Obligated; Amount Obligated to Vendors in matching Congressional District; Number of Unique Vendors (based on DUNS); Top 10 Vendors (based on obligated funds); Top 10 NAICS (based on obligated funds)."

    I understand that these are the keywords I should be retrieving (values of). But I and the other freelancers are having a little difficulty figuring out where the data mining should be done. If you could provide an example output, it would help us see the solution very clearly.

    • 1 bulan yang lalu
    1. a365guy
      Penganjur Peraduan
      • 1 bulan yang lalu

      Hi - see above and in description for new file added.

      • 1 bulan yang lalu
  • a365guy
    Penganjur Peraduan
    • 1 bulan yang lalu

    Some clarification based on requests:
    1. The sample, manual filter looks like this: navy CONTRACTING_AGENCY_NAME:"DEPT OF THE NAVY" SIGNED_DATE:[2017/10/01,2018/09/30] VENDOR_ADDRESS_STATE_CODE:"VA" VENDOR_CONGRESS_DISTRICT_CODE:"10"

    2. I've attached a sample export with this data from the website. On the sheet, I highlighted the columns in yellow that match what I'm asking for on the report.

    3. You can ignore the "Total Amount Obligated" since the "Amount Obligated to Vendors in matching Congressional District" gives me that needed data.

    • 1 bulan yang lalu
  • manganosuarezl
    manganosuarezl
    • 1 bulan yang lalu

    Howdy Neil... can you clarify where is the API to get the information? Thanks

    • 1 bulan yang lalu
    1. a365guy
      Penganjur Peraduan
      • 1 bulan yang lalu

      I'm not sure if there is an API. If there is, you can find it on their web site listed in the help section where they describe how the data can be used and how it is organized.

      • 1 bulan yang lalu
  • Fithage
    Fithage
    • 1 bulan yang lalu

    Howdy Neil... The pdf has much data and cannot fit in one page

    • 1 bulan yang lalu
    1. a365guy
      Penganjur Peraduan
      • 1 bulan yang lalu

      Fylin - the pdf should be a data summarization of all returned rows of data, so the PDF would actually be very limited in data. The work is around the data crunching to put into the PDF.

      • 1 bulan yang lalu
  • StrongDecs
    StrongDecs
    • 1 bulan yang lalu

    #increaseprize

    • 1 bulan yang lalu
  • Fithage
    Fithage
    • 1 bulan yang lalu

    Howdy Neil... I need more information on the pdf report.. Thanks

    • 1 bulan yang lalu

Tunjukkan lebih banyak komen

Bagaimana mula dengan peraduan

  • Paparkan peraduan anda

    Paparkan Peraduan Anda Cepat dan mudah

  • Dapatkan berjuta penyertaan

    Dapatkan Bertan-tan Penyertaan Dari serata dunia

  • Anugerahkan penyertaan terbaik

    Anugerahkan penyertaan terbaik Muat turun fail-fail - Mudah!

Paparkan Peraduan Sekarang atau Sertai kami Hari Ini!