Author Topic: Astrobasic script to generate excel with planetary days and hours?  (Read 644 times)

0 Members and 1 Guest are viewing this topic.

oneirich

  • Newbie
  • *
  • Posts: 5
    • View Profile
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?

Jean

  • Administrator
  • Full Member
  • *****
  • Posts: 145
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #1 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.
Greetings from Groningen Netherlands <)))><.`.><(((>

oneirich

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #2 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 !

ABer

  • Administrator
  • Jr. Member
  • *****
  • Posts: 89
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #3 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

oneirich

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #4 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...


ABer

  • Administrator
  • Jr. Member
  • *****
  • Posts: 89
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #5 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

oneirich

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #6 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

ABer

  • Administrator
  • Jr. Member
  • *****
  • Posts: 89
    • View Profile
Re: Astrobasic script to generate excel with planetary days and hours?
« Reply #7 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