Salesforce Visualforce Matrix Table & Ranked-Based Search Coding

The project is a to write 2 codes (and both Visualforce page and Class) - The 2 tasks are not related. First Task -------------- we have 2 custom objects : Unit__c - every unit(record in this object) is a specific hotel room with its features. the object is "static". Preferences_Waiting_lists__c - every record contain all room preferences for a specific account (has a Master-Detail to account). there's around 2000 unit__c records (2000 rooms), and around 1500 Preferences_Waiting_lists__c. Both of the objects contain the same 5 Fields: Hotel__c (list of hotels - text) Floor__c (1-20 - Decimal) Room_Type__c (Double,Triple,Quad - text) Bed_Type__c ( Queen, King - text) View__c ( Pool View, Sea view - text) The deference are that the fields Hotel__c and Floor__c are Picklist (Multi-Select) in Preferences_Waiting_lists__c and one choice Picklist in Unit__c . the account can choose couple of hotel option yet the feature of a room is set. The Goal - When that we are meeting the customer (account) personally we want to have a table in Visualforce page Containig the first 100 most match-able rooms (Units__c) for his specific Preferences_Waiting_lists__c record (the spcific account would be the controller and simple soql [select id from Preferences_Waiting_lists__c where Account__c := [login to view URL]()] would get ypu the correct record. (for now there's only one Preferences_Waiting_lists__c per Account). matching means to see how many of the room features include in the account room preferences. but the matching should be by different weight to each feature (Hotel, view, room type, bed type, floor) when the account filled the Preferences_Waiting_lists__c form , he was asked, beside of filling his preferences, to rank each of the fields by importance,for ex - hotel match is very important to him so he ranked it higher, and View not that much so he rank it with alow rank. The personal ranks are in 5 formula fields(in Preferences_Waiting_lists__c ): Weight_Bed_Type__c Weight_Floor__c Weight_Hotel__c Weight_Room_Type__c Weight_View__c each field as a value that represent his Weight in the match (they all together accumulate to 100,we auto normalized them) so the target is to search all rooms , and for each room check if the field is equald (or is in multi-choice) to the related field in the accounts Preferences_Waiting_lists__c. and if it is match , add the weight of this preference to the total room rank, and so on for all 5 preferences , in every room. in the end , there will be a list of room with there total rank. and this task goal will be to show the 100 highest ranked Unit__c (rooms) with there deatels (name,iD, 5 features , total rank..) its not a batch work, for each Account/ Preferences_Waiting_lists__c we will run this table separately and manually (in front of them). ----------------------- Task 2 - Create a Dynamic Matrix table in visualforce page. for the Unit__c object we would like to create a dynamic table, using 2 fields: Hotel__c (X axes) Room_Type__c (Y axes) ISAvailable (a check box in Unit__C) The goal is to count how many Unit__C ISAvailable by Room_Type__c and by Hotel__c (and the crossing between them) and show that in one table. it should looks like that: Holidayinn Backpackers hotel SunsetBeach Hotel ..... Total Double 200 50 300 550 Triple 150 10 255 415 Quad 10 0 30 40 Total 360 60 585 1005 Test Classes would be appreciate for both of the tasks.