Data comparison
£20-250 GBP
Paid on delivery
Attached are 4 files that relate to the charges made to us for wholesale supplies of water and associate waste.
P1 is a provisional file that looks at the premises registered to us for July 2013 it was downloaded from a central system on 5 June 2013 and we pay in advance for the predicted number of customers premises and volumes.
R1 is a reconciliation file that looks at the premises registered to us for July 2013 it was downloaded from the central system on 1 August 2013 and we pay or are credited with the difference between the P1 file and this R1 file. The changes are invariable that we signed new or lost customers or meter readings carried out changed the predicted uses.
R2 is a reconciliation file that looks at the premises registered to us for July 2013 it was downloaded from the central system on 24 September 2013 and we pay or are credited with the difference between the R1 file and this R2 file. The changes are invariable that we have completed meter readings and this has changed the predicted uses, or something has changed with the premises like the Rateable Value (RV) has be changed.
R3 is a reconciliation file that looks at the premises registered to us for July 2013 it was downloaded from the central system on 25 March 2014 and we pay or are credited with the difference between the R2 file and this R3 file. The changes are invariable that we have completed meter readings and this has changed the predicted uses, or something has changed with the premises like the Rateable Value (RV) has be changed.
Each premises has a maximum of 2 Supply point identifier (SPID's) which are 12 digits long one for water ending in 1XX and waste/drainage ending in 2XX. Therefore the first 9 digits are know as the Core Spid as they will be that same for water and waste.
A premises may have water only, waste only or water and waste and are classed as SPID categories in column J of the spreadsheets. Please note that a premises could have a number of meters attached to it but will still only have one water spid as the spid is for the premises.
What I want to achieve initially is an easy monthly comparison to see what new or lost spids came between each run, and the highest variances in financial terms (both positive and negative).
The 5th file shows all of the customer spids in our own system, this is downloaded each month to assist with data cleansing, but we also want to know which spids are in or missing from our system and the P1, R1,R2 and R3 files. This will allow us to check if we have are being charged for customers we are not aware of or any new customers we have found and requested a spid for but not been informed that the spid has been issued (hence the TBC (to be confirmed)). We can then match them up.
We need these outputs to be in an easy upload form so that it can be done by an administrator to generate a report for managers to act on efficiently.
Project ID: #5900094
About the project
Awarded to:
Hi, your 5-star excel & vba coding expert is ready to help your project. pls check my profile and feedbacks first to have some idea about the quality of my work... I had many similar excel/vba tasks, all achieved with More
14 freelancers are bidding on average £259 for this job
hi Aimera I can do this work for you will do this project Check my completed project reviews will wait for your reply Regards, Sultan
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou More
Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n More
Dear Sir, I am a former IBM manager and was leading a data analytics department within an EMEA centre and I would like to support the project. Generating reports for higher management was a daily job. The explana More
hello employer, I am checking the requirement and files that you have provided. huge data is there. i need some clarifications. Consider me and get it done perfectly as well as quickly. please come for the di More
Hi Aimera, Just to clarify my understanding: You have data (plus future extracts) from existing systems which need to be compared. You would like a report to show: - New and Lost SPIDs plus their financial value More
I am trying to get started on this site, so I don't have the credentials others may. Nonetheless, I can provide some references, if required. I can complete this project with extremely satisfactory results and shall if More
Hello! My name is Mia, I have knowledge in Excel and Data Processing. Feel free to check my freelancer profile and my performance here. If you have any question, feel free to ask. Thank you for your time and I am looki More
Hi I propose to write a VBA module for you where the sheets get treated like database objects. This will make it easier to compare the data. Input sheets are pasted in Excel, the macro/module run and output datasets More
