Excel Tool - Prateek's Astrological Research Template Without Notes v5 with Nakshatras

Post Reply
Admin
Site Admin
Posts: 51
Joined: Sat May 23, 2020 4:02 am

Excel Tool - Prateek's Astrological Research Template Without Notes v5 with Nakshatras

Post by Admin »

Hello Everyone

PFA My excel template that I use to prepare notes in my Consolations with Client's sample data and sample predictions.

File Currently being upgrated and unavailable for download. Contact [email protected] to request its copy

Download the file

For Office Excel 2007-2013 (Macro has to enabled)
Prateek's Astrological Research Template Without Notes v4 with Nakshatras

For Office Excel 2016 only (Macro has to enabled) (Updated on March 5, 2020)
Prateek's Astrological Research Template Without Notes v5 with Nakshatras

Click the image to enlarge. To add image like below refer to https://lunarastro.armorforums.com/4561/2659
Image

The template works on dumping client's data from JHora software into excel and then playing with it.

Following are features & possibilities

1. Research on all clients in one sheet instead of opening client profiles or putting them in folder
2. We can research on Rashi's
3. We can consolidate our notes.
4. Nakshatra research
5. Client Profile save / export (Macro's have to be enabled for this feature to work)
6. We can standardize it further
7. We can duplicate sheets to create research material on each sign/planet.(My Focus)
8. We can formulate and customize it further
9. North Indian and South Indian Charts format
10. Whatsapp Integration (Premium Members only)
11. Bulk Mail / SMS feature (Premium Members only)
12. Realtime Chart/Panchang (Premium Members only)

ChangeLog
Version 5
(Updated on March 5, 2020)
Index
Bug Fixes
Formatting
Power Points by Jitendra Ji

Version 4
South Indian Chart
Nakshatra Pada

Version 3
Nakshatra
Saving Profile (Client Notes)
New file for Office 2007-2013
Formatting

Version 2
Awastha
Formatting
Dashboard
Exaltation & Debilitation Highlights

Version 1
Grahas
Rashi's
Signs

To dump data to excel file
There are two ways in JHORA to copy
1. Go to edit and click on "copy complete calculations"
2. Just click "Ctrl+C"
3. Now go to excel tab "Data" and past in row one i.e. A1 for chart 1 or B1 for chart 2 or C1 for Chart 3 ....
4. In "Submission" tab make sure to ID the chart or name the chart matching to name in row 1 of "Data" Tab.
i.e. when you will paste it will paste similar to "C:\Users\P\Desktop\Chart 1"
4A. Trim "C:\Users\P\Desktop\Chart 1" to "Chart 1"
4B. Now in Submission Tab, Column "A1"(Every chart name to be entered to Column A1) from row 27, 28 own-wards type or paste Chart 1 or Chart 2 or Chart 3.......

Feel free to provide feedback so I can develop it further and will upload new versions.
Request not to share it on internet beyond Lunar Astro.

Video User Guide


Post Reply