Planetdance forum

Board index => Astrobasic => Topic started by: oneirich on August 20, 2020, 07:32:24 AM

Title: Astrobasic script to generate excel with planetary days and hours?
Post by: oneirich on August 20, 2020, 07:32:24 AM
Someone skilled with Planetdance's scripting language?

Would like to have something that can make an Excel with: date, time, planet of the day and planet time. If that's possible with the scripting language, at least, but I'm guessing so?
Title: Re: Astrobasic script to generate excel with planetary days and hours?
Post by: Jean on August 20, 2020, 07:47:44 AM
If you have programming knowledge take a look at c:\planetdance\ab\Excel.ab, it im/exports to/from .csv files.
Maybe you can start with Application - Edit, give your script a name, now you have an empty window, do in the editor application - templates and use 'horoscope', that will give you something to start with.
Title: Re: Astrobasic script to generate excel with planetary days and hours?
Post by: oneirich on August 20, 2020, 10:25:32 AM
Programming knowledge have, but it's time that is scarce, well it was worth the shot! Thx for your reply !
Title: Re: Astrobasic script to generate excel with planetary days and hours?
Post by: ABer on August 20, 2020, 06:15:34 PM
HI - I have developed Jean's script with additional features, can you describe what you want. All I ask is that if you use this and modify it you let me have your code so that we can continue to improve the features of PD. I don't release this generally as it is a very specialist script for research purposes. Ed
Title: Re: Astrobasic script to generate excel with planetary days and hours?
Post by: oneirich on August 21, 2020, 06:03:11 AM
The two options Planetary Day & Planetary Hour if I like at your screenshot. If the moon sign of that day can be added too that would be perfect...

Title: Re: Astrobasic script to generate excel with planetary days and hours?
Post by: ABer on August 21, 2020, 06:26:44 AM
Hi - you can get sign positions for each of the planets using checkbox Planet Signs (column two, list item two). This will output all the basic planetary listings by Sign (Sun-Pluto, Fortune, Lilith, Asc, MC, Node, Chiron etc). You would then be able to work with the spreadsheet to identify the Moon sign column in particular. The script is a beta really, and needs a bit of understanding to work, so this is why I don't publish it, but release it for researchers if they express an interest. It's not complicated, but needs some knowledge of research/data manipulation.

You can see the output below. The data you want is outputted as integers.

Aries = 1
Taurus = 2
Gemini = 3 etc

The hour and day rulers are:

Sun = 0
Moon =  1
Mercury = 2
Venus = 3
Mars = 4
Jupiter = 5
Saturn = 6

Ed

Ed
Title: Re: Astrobasic script to generate excel with planetary days and hours?
Post by: oneirich on August 24, 2020, 04:14:34 PM
Apologies for the late reply...

If you can share the script that would be more then welcome... If I make any changes I'll submit the endresult.

Thank you for your time
Title: Re: Astrobasic script to generate excel with planetary days and hours?
Post by: ABer on September 23, 2020, 07:30:13 AM
Hi there - could you PM me with your email address and I will send you this file. Thanks. Ed