Freelancer : girofreelancer
Partager :
Signaler la proposition

Forecasting Sample

As your request this is a sample of my project. I send you also the capture of the other bid for sending mail with SMTP. Best regards.


                                                                                                                        Proposition n°                                            27
                                         du concours                                             Forecast hourly energy consumption for a certain period of time
Proposition n°27

Tableau de clarification publique

  • scringhelteamsrl
    Titulaire du concours
    • il y a 7 ans

    can you provide a forecast for 01 - 03.2014, in a excel file in the same format as the provided consumption history, so we can compare with the actual consumption?

    • il y a 7 ans
  • scringhelteamsrl
    Titulaire du concours
    • il y a 7 ans

    can you tell me what is your average error for your forecast?

    • il y a 7 ans
  • scringhelteamsrl
    Titulaire du concours
    • il y a 7 ans

    Can't your solution be translated into database CLR? It is not difficult to do that and you can do it from vb/C# or other .net language. My idea is that your solution be a CLR written in VB and in the database, based on your CLR, procedures can be built to pass parameters. Based on this we can create interfaces from Desktop and Web with no problem

    • il y a 7 ans
  • scringhelteamsrl
    Titulaire du concours
    • il y a 7 ans

    The problem is not the connection string. The problem will be the large amount of data travelling from server to client and to server again. It is about data traffic and time optimisations. If your solution is desktop based (not database based) it will be very slow. That is my concern.

    • il y a 7 ans
  • girofreelancer
    girofreelancer
    • il y a 7 ans

    I tried to integrate UI into dll but only on desktop application and does not always work. On web based application I think is too difficult to integrate them with other Language (html, razor, Bootstrap, jQuery, javascript, ecc.).

    • il y a 7 ans
  • girofreelancer
    girofreelancer
    • il y a 7 ans

    If your database is accessible via TCP/IP (Lan or Internet) the only thing to do is change the connection string in the configuration file. Now I am using OleDb because I need to access to your Excel file, but is simple to change it. The core of software is on a dll library, so you can easily import on web project or desktop application. The UI is developed with VB, but if you prefer I can try to translate in C# (is not my preferred Language but i know it).

    • il y a 7 ans
  • scringhelteamsrl
    Titulaire du concours
    • il y a 7 ans

    Maybe by using CLR => code in C#/Vb and import as CLR in database.

    • il y a 7 ans
  • scringhelteamsrl
    Titulaire du concours
    • il y a 7 ans

    Another question: How will you implement your solution? Will it be on database side or will it be on client machine side? I am asking this because I have 2 projects where I would want it implemented (one is web based with MS SQL Database and the other one it Desktop application with MS SQL database), so it will be a great advantage if it would be implemented on database side because only few adjustments will need to be made to implement it in the web based application. The Databases are very similar in structure.

    • il y a 7 ans
  • scringhelteamsrl
    Titulaire du concours
    • il y a 7 ans

    Ref 1. => what do you have in mind? how do you think it can influence the forecast?. Ref. 2 => what are you refferring to when you say "legal hour". Ref. 3=> the list o national holidays is stored in a table in the database as Date. Ref. 5 => we can provide a sort of mechanism which tells the application that a certain consumption point is similar to another one for example.

    • il y a 7 ans
  • scringhelteamsrl
    Titulaire du concours
    • il y a 7 ans

    I am interested in integrating your solution into our software, not having separate software. Regarding your list:

    • il y a 7 ans
  • scringhelteamsrl
    Titulaire du concours
    • il y a 7 ans

    hi. This is a good result for forecast, but It is the forecast for a single hour. It might be dumb luck. Can you test forecast for a whole month and see what is the average error? Regarding the mail project I will write to you in there

    • il y a 7 ans

Montrer plus de commentaires Traitement en cours...