How to Calculate Aaya Using Excel Sheet. In Excel, using a formula makes it easier to calculate the Aaya in a single step, stopping the need for a calculator.
Table of Contents
1. Calculate Area
In the first column, specify the length of the building (e.g., if the building’s length is 23′). In the second column, mention the width of the building (e.g., if the width is 27′). In the third column, calculate the area by entering the formula =First_Row * Second_Row (e.g., 23′ × 27′ = 621).
2. Divide By Eight
In this step, The Next column needs to be mentioned as a heading Divide and Place 8
3. Calculate Reminder
In this step, calculate the remainder when the area is divided by 8. In the “Remainder” section, use the formula =MOD(Number, Divisor). Select MOD(Area, Divide) as the formula. For example, if the area is 621 and the divisor is 8, the remainder will be 5.
4. Find Aaya
In the next column need to mention the formula =IF(E3=1,”Dwajaya”,IF(E3=2,”Dromaya“,IF(E3=3,”Simhaya”,IF(E3=4,”Sunakaya”,IF(E3=5,”Vrushabaya”,IF(E3=6,”Karayashaya”,IF(E3=7,”Gajashaya”,IF(E3=8,”Vayasaya”,IF(E3=0,Kak)))))))))
If The remainder is 1 then it is Dwajaya, If The remainder is 2 then it is Dromaya, If The remainder is 3 then it is Simhaya, The remainder is 4 then it is Sunakaya, The remainder is 5 then it is Vrushabaya, If The remainder is 6 then it is Karayashaya, If The remainder is 7 then it is Gajashaya, If The remainder is 8 then it is Vayasaya,