Complex data processing and analysis with Excel and automation with visual basics
Budget: $30 – $250 AUD
I have generated raw results that needs to be converted to the new value and be analysed according to the instruction. Basically, we want to develop a Mastersheet excel that can automate data processing and analysis. The first draft of this mastersheet has been developed by me, but it need to be more sophisticated that can simplify my data processing works.
1)The raw data should be automatically copied and converted on the mastersheet. automate that process and open the files and apply the formula to all of your data
2) data processing and analysis should be performed based on the defined formula on the mastersheet. In this step baseline correction is super important
3)Graph should be generated for double-checking data analysis for the converted data
4) the Master sheet file should be applicable for different raw data file, so that I can use it as a master sheet
1)The raw data should be automatically copied and converted on the mastersheet. automate that process and open the files and apply the formula to all of your data
2) data processing and analysis should be performed based on the defined formula on the mastersheet. In this step baseline correction is super important
3)Graph should be generated for double-checking data analysis for the converted data
4) the Master sheet file should be applicable for different raw data file, so that I can use it as a master sheet