How to Smoothly Distribute Monthly Data Values Across Daily Intervals?

  • Thread starter Thread starter josse34
  • Start date Start date
  • Tags Tags
    Data Year
Click For Summary
SUMMARY

This discussion focuses on distributing monthly data values across daily intervals while ensuring that the total for each month matches specified values. The monthly totals provided are: January = 60, February = 80, March = 130, April = 150, May = 180, June = 200, July = 210, August = 170, September = 140, October = 90, November = 60, and December = 50. The user seeks a method that can be easily integrated into PHP code, expressing a preference for simplicity over complex numerical methods like Simpson's rule.

PREREQUISITES
  • Understanding of basic numerical methods for data distribution
  • Familiarity with PHP programming for implementation
  • Knowledge of Excel for data manipulation and visualization
  • Concept of spline interpolation for smoothing data
NEXT STEPS
  • Research methods for daily data interpolation, such as linear interpolation
  • Learn about spline interpolation techniques for smoother data representation
  • Explore PHP libraries for data manipulation and visualization, such as PHPExcel
  • Investigate numerical integration methods suitable for data distribution
USEFUL FOR

Data analysts, PHP developers, and anyone involved in time series data visualization and distribution will benefit from this discussion.

josse34
Messages
2
Reaction score
0
Hi!
I have a problem to resolve this question :

I have a total value each month :
January = 60
Fébruary = 80
March = 130
April = 150
May = 180
June = 200
July = 210
August = 170
September = 140
October = 90
November = 60
December = 50

I want to calculate the value each day of year, but the total of this values each month must be exactly like value previously describing.
Also, the graphic render must be with smoothing line, like spline or simpson rule.

See attached a excel base http://cjoint.com/?CKilaalz7z2

How to make this ?!

Thank you so much and have a nice day!

Bye
 
Physics news on Phys.org
Simpson's rule is for numerical integration, so you don't want that.
 
Any method is ok for me, the simply is the best because i must integrate this into PHP code after!
Do you any idea?
Thanks
 

Similar threads

Undergrad Filling in Missing Values in a string of data
  • · Replies 7 ·
Replies
7
Views
1K
How to Use REGEXMATCH for Highlighting the Current Month?
  • · Replies 2 ·
Replies
2
Views
1K
Is Pink Floyd's Dark Side of the Moon Still Relevant After 50 Years?
  • · Replies 44 ·
2
Replies
44
Views
6K
Need Help with Fortran compiler errors
  • · Replies 12 ·
Replies
12
Views
4K
MHB Solve Logarithms Problems: Find Profit & Interest Rate
  • · Replies 3 ·
Replies
3
Views
2K
Limiting Future Dates on Android Studio Date Picker
  • · Replies 4 ·
Replies
4
Views
2K
Are Home Termite Warranties Worth It?
  • · Replies 29 ·
Replies
29
Views
5K
Undergrad Progress In Calculating The HLbL Contribution To Muon g-2
  • · Replies 0 ·
Replies
0
Views
3K
C/C++ How Can I Generate a Calendar in C++ Using User Input for First Day and Month?
  • · Replies 2 ·
Replies
2
Views
12K
Merge sort with array of structs
  • · Replies 6 ·
Replies
6
Views
8K