Astro compass degree method (versus time method) adjustment   
Almanac page with lots of data, and noon transit table for each day, you add (west) or subtract (east) long
 diff from legal time meridian.
EQUATORIAL: Q-dial with calendar circle radii and sunrise/set horizontal line distances.
HORIZONTAL: H dial [plus altitude and azimuth],
VERTICAL:       V dial, ...non decliner
Ceiling or reflecting dials        
V decliner (the standard formula, and also a new derived formula)(with charts)   
V meridian (east facing or west)
Polar dial
Analemmatic
Sunrise-set
- EOT mm.ss   and   Sunrise-set EOT decimal
Reverse engineering an h-dial
Legal standard time (not summer time) to sun's hour angle, optionally corrected for longitude and EOT,
 useful for astro compasses    
Wall declination (simple and easy to use)     
Middleton scales
EOT combined with a longitude shift, useful for generic dials moved from the legal meridian
Declining recliners
Declination line design
aid  ~ ~ See Illustrating Time's Shadow which has an in depth discussion,
 for descriptions of this feature. DeltaCAD macros cover this as well as my other free CAD stuff, and Visual Basic
Analemma curve ~ ~ any latitude and longitude, for any time whatsoever for h-dials (horizontal) at latitude 0 this is a
 polar dial, and reversing signs and hours, this works for a vertical dial, and by messing with the time while using
 SD and SH and D.LONG this works for decliners also. There are very few times and latitudes where this doesn't
 work well, and the spreadsheet makes it easy for you to "tweak" it. Actual formal design latitudes are +0 to +60,
 times are 08.00 to 16.00
Planispheric astrolabe (matches the DeltaCAD macro, or, see this page here for geometry of the astrolabe)   
Sundial Sun Dial Sundials Sun Dials Design Book Books articlesspreadsheets Gnomics Gnomonics Horology Dialling Dialing Clocks EOT
Equation of time Middleton Sciathics Lunar Moon construction hobby gnomon cutout popup building astro compass astrocompass shepherd
ogee azimuth altitude hour angle
*** NOTE ***
these spreadsheets deliberately use several different EOT formulae, and they do
not all agree. This is so people can play with different formulae. Just be aware
that they differ sometimes by up to a minute.
The illustrating-shadows.xls spreadsheets have been reworked for PDAs,originally for the
PalmPilot, but now for the Android. The vertical decliner spreadsheet is shown to the left on a
Palm T3. A new vertical decliner sheet and ceiling dials added.    

Display output has been reworked, hyperlinks removed and the sheets adapted for their
removal, changes in formulae not supported by Documents To Go, size changes, and so on.

The h, v, and v-dec dials are supported, three EOT sheets provided, analemmatic, armillary
and equatorial dial calendar and hour data supported, calendar curves, and so on.
a2.2 suns LHA.xls
a2.3 long-to-time.xls
a2.4 julian days.xls
a2.6 time-zones.xls
a2.9 mag to true.xls
a3.1 v-h dials.xls
a3.1 v-h dials with graphs.xls  
a3.2 ceiling data.xls         
a4.1 suns altitude.xls
a4.2 suns azimuth.xls
a4.3 analemmatic dial.xls
a4.4 calendar curves.xls
a5.1 vertical decliner.xls
a5.1 vdec sws formula.xls   
  
a6.3 sunrise set EOT~Lat.xls
a6.4 sunset and italian lines.xls
a9.9 graph hour lines.xls
a0.0 almanac.xls  
a0.0 analemma figure of eight.xls     
a0.0 astro compass.xls
a0.0 inclined decliner.xls
a0.0 planispheric astrolabe.xls
a0.0 unknown dial.xls
a0.0 wall-declination.xls
a1.1 trig.xls
a2.1 EOT astro mini.xls
a2.1 EOT astro.xls
a2.1 EOT other.xls
a2.10 meridian polar hour-calendar.xls
a2.11 daily declination.xls
a2.12 equatorial calendar radius.xls
a2.13 armillary calendar line distances.xls
Excel    

NOTE:  When you start the spreadsheet, no menu of links to all the other sheets appears UNTIL you enter a Julian day. This is to
allow you to enter any Julian day, and only when you have selected a Julian day will the rest of the menu appear. If you want change
cell from...

0
to....
=g6
FREE ~ TABULAR SPREADSHEETS FOR DIALING ~
(These produce annual tables rather than details for one day)

Whereas the two spreadsheets for Illustrating Shadows are all in Excel format (the main sheet and the astronomically accurate EOT
sheet) produce full screen detailed information, usually for a specific day or limited range of days, these spreadsheets for tables
produce the tables used in the appendices for the Illustrating Shadows series of books.

The names are similar to the names and functions of the PDA specific spreadsheets. The
ZIP file is here.    
Please read these notes here that discuss Microsoft
Office, and Open Office
Android  
However, if you do that, and then enter a specific Julian day other than today, and then
save it, you may forget you did that and thus misread results.
The most complex spreadsheet is illustratingShadows.xls pictured below...
If you download the spreadsheet, do a SAVE first and then a RUN, if you do RUN directly then the
hyperlinks will not work.
Android spreadsheets are here
VERY SIMPLE
A BIT MORE
INFORMATION
SIMPLE TO
INTERMEDIATE
ADVANCED
microShadows.zip
simpleShadows.zip
cubicShadows.zip
illustratingShadows.zip
or
illustratingShadows.xls
And there is an
expanded Almanac
and an expanded
Astro Compass sheet
also.
Longitudes are positive + for west of
Greenwich

Longitudes are negative - for east of
Greenwich
FREE ~ DAY SPECIFIC SPREADSHEETS FOR DIALING ~ using MS Office Excel   
(try the Docs To Go versions also even in Excel,
here)

NOTE:  Most dial plates in these spreadsheets also show the dial plate graphically, and have a pictorial tool to
correct the aspect ratio, they do NOT use macros.

The spreadsheet for Illustrating Shadows is in Excel format, works in Open Office and Kingsoft also.

This    
general dial spreadsheet      (illustratingShadows.xls)   has been enhanced based on demand. It has many many features. It
begins with an index page followed by an almanac page, then a set of detailed pages.  New stuff includes the astrocompass degree
method correction (as opposed to the time method).   Other spreadsheets exist for special one off calculator usage.

TABLE  OF  CONTENTS
Your latitude:                          eg    32.75
Your longitude:                      eg    108.20
Legal meridian longitude:   eg    105
Julian day (1-366)                 eg    253
S P R E A D S H E E T S
FREE Excel SPREADSHEETS
also work in Open Office and in Kingsoft, both of which are free

*** Try cubicShadows.zip Excel spreadsheet, small, easy, does most dialling stuff  ***

If you do not have Excel, download
Open Office which runs these spreadsheets,
and consider Kingsoft also.

UPDATED February 2, 2016
This spreadsheet covers almost all dialling functions you could ever possibly want
The Android almanac
spreadsheet runs on Excel,
Open Office, and eDroid free
spreadsheet. This is one of
the most popular
spreadsheets.