Post your project for free and start receiving proposals from freelancers within minutes after publication!
Writing in Excel (or Google Sheets) macros on site bets
Details and amount will be discussed specifically when the front of work and details will be understood.
The task:
There is a mass of the ratings (their coefficients are 4 types), the data are: the coefficient, time, date, the color of the coefficient.
According to this data, you need to write macros to calculate the data range for the period of time, the average value per hour/day/month/year, search for series in a row, search for time in interval and similar formulas (I will tell you more in a personal discussion).
But in addition, you need to write a macro or something similar under the exel, where the corridor will be counted on a bet in a few steps (we'll discuss in detail in the face) for a certain time.
Examples of the Excel file with macros will come with dop notes that you need to work (by a similar task).
If there is the possibility to make under Google tables will be better.
The task:
There is a mass of the ratings (their coefficients are 4 types), the data are: the coefficient, time, date, the color of the coefficient.
According to this data, you need to write macros to calculate the data range for the period of time, the average value per hour/day/month/year, search for series in a row, search for time in interval and similar formulas (I will tell you more in a personal discussion).
But in addition, you need to write a macro or something similar under the exel, where the corridor will be counted on a bet in a few steps (we'll discuss in detail in the face) for a certain time.
Examples of the Excel file with macros will come with dop notes that you need to work (by a similar task).
If there is the possibility to make under Google tables will be better.