i have attached an excel work sheet. It is about a building TOWER having 6 wings ABCDEF having each 22 floors . they have expenses and collection you have prepare some sheets on same file indicating
1)LIST OUT FLATS POSSESSION NOT YET DONE MEANS NOT SOLD.
2) FIND OUT FLAT WISE EXPENSE .HOW MANY FLATS IN EACH WING
3)FILTER /FIND OUT WING WISE EXPENSES FOR wing ABCDE
4) WORK OUT TOTAL EXPENSES AND COLLECTION THEN DEFICIT =COLLECTION
MINUS EXPENSES FOR EACH FLAT AND TOTAL FOR SIX WING.
5) HOW MANY MEMBERS HAVE COMMON COLLECTION OF Rs.104652
6)how many flat owners given no collection
7)HOW MANY FLATS HAVE CARPER AREA MORE THAN 969
8)HOW MANY FLAT OWNERS HAVE SURPLUS AND ITS TOTAL VALUE.
1)LIST OUT FLATS POSSESSION NOT YET DONE MEANS NOT SOLD.
2) FIND OUT FLAT WISE EXPENSE .HOW MANY FLATS IN EACH WING
3)FILTER /FIND OUT WING WISE EXPENSES FOR wing ABCDE
4) WORK OUT TOTAL EXPENSES AND COLLECTION THEN DEFICIT =COLLECTION
MINUS EXPENSES FOR EACH FLAT AND TOTAL FOR SIX WING.
5) HOW MANY MEMBERS HAVE COMMON COLLECTION OF Rs.104652
6)how many flat owners given no collection
7)HOW MANY FLATS HAVE CARPER AREA MORE THAN 969
8)HOW MANY FLAT OWNERS HAVE SURPLUS AND ITS TOTAL VALUE.