What do you want to do ?

Generate the natal chart for a new person

• Go to the worksheet "DataEntry" and fill in the cells marked in yellow

• Fill in the name of the person or if privacy is desired, any identifier. The name has no further relevence
  
• Fill in the city of birth. This is optional and has no relevence except for completeness of data
• Fill in the Longitude and Latitude of city of birth. This should be filled in accurately after consulting an atlas or the web
• Fill in the date of birth
• Fill in the time of birth
• Fill in the time difference between location of birth and GMT. India is to the East, USA is to the West of GMT
• The specific date is to be filled in ONLY if a chart for the a specific date is required, not otherwise
• Fill in the four character Astrologer ID as this will be used to generate an anonymous identification for the chart
  

• Go to Cell K4 and from the dropdown choose the kind of chart that is required

• A natal chart needs to be generated first
• Choose "natal" in cell K4
  
• Once the natal chart has been generated, a chart for a specific date can be generated subsequently

• Press the "Generate" button to create the natal chart.
• Pressing the button will invoke the Swiss Ephemeris program that should be located in the same directory as the SmartChart Excel workbook. Press the OK button when the Swiss Ephemeris program credits are shown. The natal chart will be generated in the worksheet "PAC" in three styles, the East Indian, South Indian and North Indian styles. Below the charts a lot of information about POSITIONS, ASPECTS and CONJUNCTIONS will be generated. Explanations for this will be made available later.
• Note the ChartID that is automatically generated using Astrologer Code + Date and Time of Birth. Since this is the primary index for all subsequent operations, all personal identification is removed for sake of privacy

Generate the generic chart for a person

• The process is nearly identical to that of generating a natal chart given in the section above except for :
• The Date entered in the "Specific Date" field is used
• Cell K4 needs to be set to "Specific"
• At least one natal chart has be generated before a specific chart can be created
• The results will displayed in worksheet "GenPAC"
  

Store the chart in the database

• The charts can be stored in any genuine relational database management system and the SmartChart sheet generates the SQL statements necessary to create the tables as well as to insert the data.
• The SQL statements are generated by invoking the macro P21_20InsertPAC that is available from the Tools menu
• On being invoked the user is asked to specify the worksheet that should be used as input and the only appropriate answer at the moment is PAC.
  
• The SQL statements are stored in TXT file that needs to be shipped over to the Database Adminstrator for insertion into the RDBMS hosted at the website
  
• The database adminstrator will use the Batch Data Uploader available inside the Parashar21 TechZone to upload and execute the file containing the SQL insert commands
• All bulk data uploads are protected with a database adminstrator userid and password
• Data can be loaded into either the Test database or the Production database
  
• However if a local installation of MySQL is available, the user may create the appropriate tables and load the data without assistance from the central DBA

Create a query based on Position-Aspects-Conjuncts

• A query can consist of upto 12 conditions and each condition needs to be built separately
• To build one condition
• Go to Row 3, Column F and use the dropdown to choose the first part of the condition
  
• Go to Row 3, Column J and use the dropdown to choose the second part of the condition
• Go to Row 3, Column M and use the dropdown to choose the third part of the condition
• Now press the "Add Condition" button and the condition will be added to the stack of conditions that have been generated so far. These are visible in Rows 9 through 20
• If a condition has been added erroneously, simply delete it from the stack and then move all the subsequent conditions upward
  

Execute the PAC Query and see the charts that are retrieved

• When you are done with the steps given in the previous section, and you want to query the database for charts that meet these conditions then press the orange "Send Query" button
• This will ...
• Assemble the query from all the conditions that you have listed
• Send the query to the MySQL database located on the website
• The website will send the retrieved charts in the form of an Excel spreadsheet
• Your browser may suspect that this is some kind of malicious data  pretending to be an Excel spreadsheet, but do not worry, go ahead and open the file in your native Excel software
• The Excel file that you see, contains data that may not make sense to you. We will decode it soon, but first save it on your local machine and remember the name !
• Close the file that you have received from the website
  
• Now go back to the original SmartChart and press the green "View Results" button
• You will be asked to specify the name of the Excel sheet that contains the data -- point to the file that you have saved in the previous step
• The macro will read the output file and created a series of PAC-like worksheets for EACH chart that has been retrieved. 
• These additional sheets will be stored in the output file
  
• The name of each sheet will be the same as the chartID of the chart that is being displayed.

Define and Store Events in a Persons Life

1. Type A events that are binary, not associated with any data or date, say doctor by profession etc
   
2. Type B events are associated with ONE piece of data, say number of children
3. Type 3 events are associated with TWO pieces of data, say X jobs in Y years
4. Type 4 events are associated with a date -- and hence automatically with dashas/ age

• Make sure that Natal Chart has been built
  
• Go to sheet LifeEvents
• For each event that is applicable, change the value in H from N to Y
• Depending on the the kind of event, certain fields will change colour, fill in the appropriate data, for example X, X and Y, or date
• On insertion of date, Dasha and Age information for that date will be generated automatically
  
• When complete, execute macro P21_41InsertEvents to generate file for data upload
  

Create an SQL query based on Events

• Go to sheet EventsQuery
• Choose the events that  you wish to query on by changing the value of column H from N to Y
• Do make sure that you do not choose too many events
• Press the "Send Query" button to execute the query against the database
• For multiple events, the query can be very restrictive where each event must occur or the query can be less restrictive where any one of the events may occur. Indicate your choice by entering 0 or 1 in the message box
• Results will be available in a spreadsheet
• Save the spreadsheet
• See the data by pressing the "View Results" button