Respected Sir/Madam Kindly write the following placidus formula into the excel sheet: Cyril Gupta wrote: > other houses with that ascendant in view. I need someone who can guide > me in calculating the placidus house systems with this fixed > ascendant, and using other data like latitude, etc. Excerpts from Michael P. Munkasey's ''An Astrological House Formulary''... CALCULATION CONVENTIONS The following standard abbreviations are used in the mathematics which follow: e represents the obliquity of the ecliptic f represents the terrestrial latitude ASC is the ascendant MC is the MC RAMC is the Right Ascension of the MC F, G, J, K, and L are working terms, unimportant astronomically +. -, x (or, *), ÷, = represent their normal arithmetic functions SIN, COS, TAN, COT, etc. represent the trigonometric functions For calculator purposes: COT = (1 ÷ TAN ) and vice-versa, etc. ARCSIN, ARCCOS, ARCTAN, etc. represent the trig inverses H11, etc. stands for the offset to compute the cusp of house eleven, etc. C11, etc. stands for the value of the cusp of house eleven, etc. Standard computer notation parenthesis nesting conventions are used throughout the formulations. That is, three left parenthesis must be balanced by three right parenthesis. Calculations are always performed within the inner parenthesis first, and then outward to the outer parenthesis. Persons attempting the mathematics herein should refer to reasonable reference books if they are unfamiliar with trigonometric procedures. Particularly, the process of adjusting house cusp calculations for the correct trigonometric quadrant can be somewhat tricky if not performed with care. House cusps which are over 360° or under 0° should be converted to lie between 0° and 360° . That is, if you compute a house cusp as being 372° then this should be changed to 12 Aries. Add 360° to any negative values or results. House cusps with values between 0° and 29.99° lie in Aries; between 30° and 59.99° in Taurus; between 60° and 89.99° degrees in Gemini, and so forth around the zodiac and through the signs. PRELIMINARY CALCULATIONS AND THE PERSONAL SENSITIVE POINTS 1. The RAMC (the right ascension of the midheaven) is computed from Local Sidereal Time (LST) by converting time units to degree units. An example of this calculation follows: Given an LST of 12H 15M 00S, then first convert this to a decimal form of time, or 12.25 hours. 12.25 x 15 = 183.75° which is the RAMC. Given an LST of 6H 27M 14S, then convert this to a decimal form of time, or 6.453889 hours. 6.453889 x 15 = 96.808333°. 2. MC = ARCTAN ( TAN (RAMC) ÷ COS e ) 3. ASC = ARCCOT (- ( (TAN f x SIN e) + (SIN RAMC x COS e) ) ÷ COS RAMC) 4. EQA = ARCCOT ( - ( TAN RAMC x COS e) ) 5. VTX = ARCCOT (- ( (COT f x SIN e) - (SIN RAMC x COS e) ) ÷ COS RAMC) 6. CAS = ARCCOT (- ( (COT f x SIN e) + (SIN RAMC x COS e) ) ÷ COS RAMC) 7. PAS = ARCCOT ( ( (TAN f x SIN e) - (SIN RAMC x COS e) ) ÷ COS RAMC) 8. ARI The Aries Point is always zero of Aries. 9. The declination of any point on the ecliptic can be calculated from: declination = ARCSIN ( SIN (zodiacal longitude of point ) x SIN e) 10. The obliquity of the ecliptic, for any date in modern times, is calculated by: e = 23o 27' 08.26'' - 46.845'' x T - .0059'' x T2 + .00181'' x T3 where T is in fractions of a century starting from Jan 1, 1900 [snip] THE PLACIDIAN HOUSE SYSTEM FORMULATION 1. Compute the RAMC, MC, and ASC in the normal manner. Use the MC as the cusp of the tenth house and the ASC as the cusp of the first house. This is a very fast converging algorithm adapted from a work by M. Vijayaraghavulu. 2. Determine the following house cusp intervals: H11 = RAMC + 30° H2 = RAMC + 120° H12 = RAMC + 60° H3 = RAMC + 150° 3. Set the Semi-arc ratios: F11 = 1 ÷ 3 F2 = 2 ÷ 3 F12 = 2 ÷ 3 F3 = 1 ÷ 3 4. Compute the cuspal declinations: D11 = ARCSIN ( SIN e x SIN H11 ) D2 = ARCSIN ( SIN e x SIN H2 ) D12 = ARCSIN ( SIN e x SIN H12 ) D3 = ARCSIN ( SIN e x SIN H3 ) 5. Compute the first intermediate values: A11 = F11 x ( ARCSIN ( TAN f x TAN D11 ) ) A12 = F12 x ( ARCSIN ( TAN f x TAN D12 ) ) A2 = F2 x ( ARCSIN ( TAN f x TAN D2 ) ) A3 = F3 x ( ARCSIN ( TAN f x TAN D3) ) 6. Compute the house cusp positions as follows: M11 = ARCTAN ( SIN A11 ÷ ( COS H11 x TAN D11) ) M12 = ARCTAN ( SIN A12 ÷ ( COS H12 x TAN D12) ) M2 = ARCTAN ( SIN A2 ÷ ( COS H2 x TAN D2) ) M3 = ARCTAN ( SIN A3 ÷ ( COS H3 x TAN D3) ) 7. Compute the intermediate house cusps: R11 = ARCTAN ( ( TAN H11 x COS M11 ) ÷ COS ( M11 + e) ) R12 = ARCTAN ( ( TAN H12 x COS M12 ) ÷ COS ( M12 + e) ) R2 = ARCTAN ( ( TAN H2 x COS M2 ) ÷ COS ( M2 + e) ) R3 = ARCTAN ( ( TAN H3 x COS M3 ) ÷ COS ( M3 + e) ) 8. Substitute: D11 = R11; D12 = R12; D2 = R2; and D3 = R3. Then repeat steps 5 thru 8 again. Substitute the R's for the D's a third time and repeat steps 5 thru 8. The answer for R on the third try is the cusp you desire. 9. Compute the individual house cusps as follows: C11 = R11 C5 = 180° + C11 C12 = R12 C6 = 180° + C12 C2 = R2 C8 = 180° + C2 C3 = R3 C9 = 180° + C3 End of excerpt... Hope that helps. :)
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
first start excel and click on formula tab -->Calculation options -->Manual
Now open file, if asks for update formulae, say no.
Now select entire sheet, select formulas tab--> Error Checking -->Trace Error.
It will locate all error containing cells, now rectify the error save it reopen in excel to see if problem is solved.
pen both the sheets in the same window as:-
1. View Tab-->New Window --> Arrange All --> tiled
2. Open first sheet in first window and second in second window
3. now create formula simply by clicking in corresponding sheets and selecting cells.
Alternatively you can use following format of addressing:-
1. SheetName!CellAddress (Same Workbook)
2. [WorkbookName]SheetName!CellAddress (Different Workbooks)
For more clarification please mail on [email protected] with screenshots.
1) right click on the cell with the formula
2) go to where you want to paste the value - minue the formula
3) right click and select paste special
4) click values (as seen in image below)
and that's it done.
If this helped you, then please help me and vote kindly.
type in "=" and then go to the cell in the 2nd sheet and click on the cell that contains the value you want carried to sheet 1. Then drag copy the forumula in sheet 1 to all the cells you want it to relate to. Now, if you place a value in e.g. A1 of sheet 2, then that same value will appear in A1 of sheet 1.
Good luck.
Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number. Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)
Drag this formula down column F till the end of your data Select the entire data and do an auto filter In column F filter the data by Duplicate and delete all these rows What remains should be unique data
×