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: Qdial 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 Sunriseset  EOT mm.ss and Sunriseset EOT decimal Reverse engineering an hdial 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 hdials (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 illustratingshadows.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 vdec 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 longtotime.xls a2.4 julian days.xls a2.6 timezones.xls a2.9 mag to true.xls a3.1 vh dials.xls a3.1 vh 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 walldeclination.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 hourcalendar.xls a2.11 daily declination.xls a2.12 equatorial calendar radius.xls a2.13 armillary calendar line distances.xls 
Android 
However, if you do that, and then enter a specific Julian day other than today, and then save it, you may later 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 

And there is an expanded Almanac and an expanded Astro Compass sheet also. 
FREE ~ DAY SPECIFIC SPREADSHEETS FOR DIALING ~ using MS Office Excel Consider WPS as a free alternative to Microsoft Excel 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 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 (1366) 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, there are many alternatives for free ~ WPS is a great alternative 
This spreadsheet covers almost all dialling functions you could ever possibly want 
The Android almanac spreadsheet runs on Excel, and eDroid free spreadsheet. This is one of the most popular spreadsheets. 