Weekly Planner
Budget: $50 – $70 AUD
A CSharp Windows Application with MS- Access database.
I want to upload two excel files one history data and the other current data. I also will need to append data each week history data table with a column called date added.
History data table consist of data for current year 2022 and previous year 2021;
I want to loop through the history data table and find the actual carton sold where the week number, item number, price in current data table is the same as the week number, item number, price in the history data table and show this in a cloumn call "Actual Cartons Sold"
I also want a column in the current data table called "Matching" to show the results “match found” or “no match found”.
On the Windows Form I want a textbox | label to show the number of records for the actual cartons found. To start of with this should show as 100 percent as there's no match, but as we find matching result this count reduces from 100 to 70 percent as matching results are found.
To start, we first want to loop through the History data table and return the all the results for 2022.
Once all result for 2022 has been found we now want to find matching result for 2021. So, if match not found in week number 20, check week 21 or check week 19 or check week 22 or 18 or check week 23 or 17 etc. Here we check week + 1, week -1 untill as many result have been returned.
Once both 2022 & 2021 cycle has completed and there are still 0 appearing in "Actual Cartons Sold" I want the to be updateActual Cartons Sold to 1 carton and in the column "Matching" I want this to say "no result found"
I then want to export the actual cartons sold to an Excel file where the item number and the section has been concatenated
I want to upload two excel files one history data and the other current data. I also will need to append data each week history data table with a column called date added.
History data table consist of data for current year 2022 and previous year 2021;
I want to loop through the history data table and find the actual carton sold where the week number, item number, price in current data table is the same as the week number, item number, price in the history data table and show this in a cloumn call "Actual Cartons Sold"
I also want a column in the current data table called "Matching" to show the results “match found” or “no match found”.
On the Windows Form I want a textbox | label to show the number of records for the actual cartons found. To start of with this should show as 100 percent as there's no match, but as we find matching result this count reduces from 100 to 70 percent as matching results are found.
To start, we first want to loop through the History data table and return the all the results for 2022.
Once all result for 2022 has been found we now want to find matching result for 2021. So, if match not found in week number 20, check week 21 or check week 19 or check week 22 or 18 or check week 23 or 17 etc. Here we check week + 1, week -1 untill as many result have been returned.
Once both 2022 & 2021 cycle has completed and there are still 0 appearing in "Actual Cartons Sold" I want the to be updateActual Cartons Sold to 1 carton and in the column "Matching" I want this to say "no result found"
I then want to export the actual cartons sold to an Excel file where the item number and the section has been concatenated