Position Analysis 0702

In the attachment contains 2 files: 1) [login to view URL] 2) [login to view URL] I want to fill the [login to view URL] using the data contained in [login to view URL] The data must be retrieved from [login to view URL] to [login to view URL] using ADO. Table 1: Pull out the data for a particular position, e.g. 3020 (see Column AE in [login to view URL]). The following sets of numbers should be computed depending on the number of records found for each item (listed from Q14 to Q41 in [login to view URL]): 1. If record count is less than 4, don’t show anything, 2. If record count is from 4 to 6, present the summarised results for median and average column (Column H and I in [login to view URL]), 3. If record count is from 7 to 10, present summarised results for median, average, 25 percentile and 75 percentile (Column H, I, G and J in [login to view URL]), 4. If record count is more than or equal to 11, then include median, average, 25 percentile, 75 percentile, 10 percentile and 90 percentile (Column H, I, G, J, F and K in [login to view URL]) Table 2 : The same criteria except that it is for position 3020 with the added criteria for Match (Column AH in [login to view URL]). The value is “H?? Table 3: The same criteria except that it is for position 3020 with the added criteria for Match (Column AH in [login to view URL]). The value is “E?? Table 4: The same criteria except that it is for position 3020 with the added criteria for Match (Column AH in [login to view URL]). The value is “L?? Please ask if you need further clarifications. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). * * *This broadcast message was sent to all bidders on Thursday Feb 22, 2007 11:51:38 AM: Hi All, I wish to clarify that the data contained in the median and mean column are just samples. The actual data should come from the [login to view URL] file. The real template should not contain any data except the header descriptions in row 10 & 11 and the column C, Q within the table. Column Q contains the matching field names. There are 3 fields which have not yet been identified and is marked with ???. Best regards. JK * * *This broadcast message was sent to all bidders on Friday Feb 23, 2007 10:28:23 AM: Hi all, I wish to highlight that the solution must be driven by Excel macro/VBA. The connection to the [login to view URL] must use ADO. Thanks and best regards. JK ## Platform Windows Office 200 and above