Fort Marinus

James Webb Space Telescope (JWST)

Never before seen NIRCAM composite filter images, assembled from public data.

Added 2022 09 28

Physical Properties of the Triply-Lensed z = 11 Galaxy
MACS0647+7015

Added 2022 09 11

Radiative Feedback from Massive Stars as Traced by Multiband Imaging and Spectroscopic Mosaics
Orion Bar Region

Added 2022 09 01

JWST Medium-Deep Fields — Windhorst/Hammel GTO North Ecliptic Pole Fields
JWST North Ecliptic Pole (NEP) Time-Domain Field (TDF)
JWST Medium-Deep Fields — Windhorst/Hammel GTO North Ecliptic Pole Fields
JWST North Ecliptic Pole (NEP) Time-Domain Field (TDF) 

Added 2022 08 15

A JWST-HST-VLT/MUSE-ALMA Treasury of Star Formation in Nearby Galaxies
NGC 1365

Added 2022 08 13

NGC 6543 / Cat’s Eye Nebula / Caldwell 6

Targeting Extremely Magnified Panchromatic Lensed Arcs and Their Extended Star formation
SPT-S J041839-4751.8

Added 2022 08 08

The Cosmic Evolution Early Release Science (CEERS) Survey
CANDLES EGS J141955.2+525529.4

Added 2022 08 03

A Strongly Magnified Individual Star and Parsec-Scale Clusters Observed in the First Billion Years at z = 6
1RXS J013724.7-082744

Added 2022 07 31

A JWST Study of the Starburst-AGN Connection in Merging LIRGs
NGC 7469

Added 2022 07 31

A JWST Study of the Starburst-AGN Connection in Merging LIRGs
VV 114

Antique Latin Textbooks

Some time ago, I developed an interest in antique Latin language textbooks of the late 19th and early 20th centuries. Attached is a list of books with historical notes, images, and archival links, when available.

Allyn and Bacon Latin Program (later, Jenney’s Latin)

    • First Year Latin
    • Latin Lessons by Minnie Louis Smith (1913); Allyn & Bacon
    • Predates the 4 volume Allyn & Bacon 4 volume set.
    • Elementary Latin by Minnie Louis Smith (1920); Allyn & Bacon
    • A revision of Latin Lessons by Minnie Louise Smith.
    • Predates the 4 volume Allyn & Bacon 4 volume set.
    • Smith’s First Year Latin revised by Harold G. Thompson (1933, 1936); Allyn & Bacon
    • Teacher’s Manual (1934)
    • Smith and Thompson’s First Year Latin revised by Charles Jenney Jr. (1953, 1958); Allyn & Bacon
    • Smith and Thompson’s First Year Latin revised by Charles Jenney Jr. (1962, 1966); Allyn & Bacon
    • First Year Latin by Charles Jenney Jr., Roger V. Scudder, Eric C. Baade (1979 978-0205061778); Allyn & Bacon
    • Jenney’s First Year Latin by Charles Jenney Jr.; Eric C. Baade; Thomas K. Burgess (1983 978-0205078592, 1987 978-0205087235, 1989 978-9990814194); Pearson Prentice Hall
    • 1983: Workbook 978-0205078615, Teacher’s Manual 978-0205078608, Answer Key 978-0205061815
    • Jenney’s First Year Latin by Charles Jenney Jr.; Eric C. Baade; Thomas K. Burgess (1990 978-0133193282); Pearson Prentice Hall
    • 1990: Workbook 978-0133193695, Teacher’s Manual 978-0133193367
    • Second Year Latin
    • Second Year Latin by Jared Waterbury Scudder (1927, 1934); Allyn & Bacon
    • Scudder’s Second Year Latin revised by Charles Jenney Jr. (1954, 1961); Allyn & Bacon
    • Scudder’s Second Year Latin revised by Charles Jenney Jr. (1962, 1966); Allyn & Bacon
    • Second Year Latin by Charles Jenney, Rogers V. Scudder, Eric C. Baade, Rita R. Riley (1979); Allyn & Bacon
    • Jenney’s Second Year Latin by Charles Jenney Jr.; Eric C. Baade; Thomas K. Burgess (1983, 1987 9780205087266, 1989); Pearson Prentice Hall
    • Jenney’s Second Year Latin by Charles Jenney Jr.; Eric C. Baade; Thomas K. Burgess (1990 9780205087266, 1998 9780133298895); Pearson Prentice Hall
    • Third Year Latin
    • Third Year Latin by Bruno Meinecke, Ph.D (1933); Allyn & Bacon
    • New Revision of Kelsey’s Cicero; With Added Selections from Cicero, Sallust, Livy and Pliny; Arranged and Edited with Explanatory Notes, A Companion, Essentials of Grammar and Syntax, and Vocabulary. This book is a revision of Select Orations and Letters of Cicero (1892) by Francis Willey Kelsey who intended to revise the book himself, but did not get around to it before he died.
    • Third Year Latin revised by Charles Jenney Jr. (1950s); Allyn & Bacon
    • Third Year Latin revised by Charles Jenney Jr. (1960s); Allyn & Bacon
    • Third Year Latin by Charles Jenney, Rogers V. Scudder, Eric C. Baade, Rita R. Riley (1979); Allyn & Bacon
    • Jenney’s Third Year Latin by Charles Jenney Jr.; Eric C. Baade; Thomas K. Burgess (1983, 1987, 1989); Pearson Prentice Hall
    • Jenney’s Third Year Latin by Charles Jenney Jr.; Eric C. Baade; Thomas K. Burgess (1990, 1998); Pearson Prentice Hall
    • Fourth Year Latin
    • Fourth Year Latin editors Lois Carlisle and Davida Richardson (1933); Allyn & Bacon
    • with Selections from Virgil, Ovid, Catullus, Martial, and Horace
    • Fourth Year Latin revised by Charles Jenney Jr. (1950s); Allyn & Bacon
    • Fourth Year Latin revised by Charles Jenney Jr. (1960s); Allyn & Bacon
    • Fourth Year Latin by Charles Jenney, Rogers V. Scudder, Eric C. Baade, Rita R. Riley (1979); Allyn & Bacon
    • Jenney’s Fourth Year Latin by Charles Jenney Jr.; Eric C. Baade; Thomas K. Burgess (1983, 1987, 1989); Pearson Prentice Hall
    • Jenney’s Fourth Year Latin by Charles Jenney Jr.; Eric C. Baade; Thomas K. Burgess (1990, 1998); Pearson Prentice Hall
  • Classical Myths
  • Myths and their Meaning by Max Herzberg (1928, 1931, 1949, 1964); Allyn & Bacon
  • English Language book covering myths of Greece and Rome, and Northern and Celtic myths.
  • Academy Classics for Junior High Schools Series.
  • Classical Myths by Max J. Herzberg (1935); Allyn & Bacon
  • Revision of Myths and their Meaning by Max Herzberg (1931)
  • Not included in later Jenney’s revisions

The Francois-Scudder Latin Course

  • Book One, First Latin with Collateral Reading by Victor E. François (1926); Allyn & Bacon
  • Book Two, Second Latin by Jared W. Scudder (1927); Allyn & Bacon

Christopher Sower Company

  • Junior Latin Book One by John Evans Forsythe, A. B. and Richard Mott Gummere, Ph. D. (1917); Christopher Sower Company

Silver, Burdett & Company

  • A Latin Grammar by Harry Edwin Burton (1911); Silver, Burdett & Company

The Climax Series

  • Latin First Year by Ralph Van Deman Magoffin and Margaret Young Henry (1928R, 1932); Silver, Burdett & Company
  • Latin Second Year by Lillian Gay Berry and Josephine L. Lee (1930, 1932, 1938, 1942); Silver, Burdett & Company
  • Latin Third Year by Louis Eleazer Lord and Loura Bayne Woodruff (1920, 1939); Silver, Burdett & Company
  • Latin Fourth Year by Harry Edwin Burton and Richard Mott Gummere (1920, 1931); Silver, Burdett & Company

Gunnison and Harley Series

  • The First Year of Latin by Water B. Gunnison, Ph.D. and Walter S. Harley, A.M. (1902); Silver, Burdett & Company
  • Latin for the First Year by Water B. Gunnison, Ph.D. and Walter S. Harley, A.M. (1915, 1917); Silver, Burdett & Company
  • Cicero’s Orations by Water B. Gunnison, Ph.D. and Walter S. Harley, A.M. (1912); Silver, Burdett & Company
  • Caesar’s Gallic War by Water B. Gunnison, Ph.D. and Walter S. Harley, A.M. (1907, 1911); Silver, Burdett & Company

Gradatim and other books by H.R. Heatley

  • Gradatim
  • Gradatim, An Easy Latin Translation Book for Beginners (Second Edition) by H.R. Heatley, M.A. and H. N. Kingdon, M.A. (1882); Rivingtons London
  • Gradatim, An Easy Latin Translation Book for Beginners (New Edition) by H.R. Heatley, M.A. and H. N. Kingdon, M.A. (1892); Longmans, Green, and Co.
  • Gradatim, An Easy Latin Translation Book for Beginners revised by J. W. Scudder M.A. (1889, 1893, 1895, 1896); Allyn & Bacon
  • Gradatim, An Easy Latin Translation Book for Beginners revised for American Schools by W. C. Collar (1889, 1890, 1894); Ginn and Company, Publishers
  • Excercises on Gradatim by H.R. Heatley M.A., and the Rev. A. Sloman, M.A. (1898); Longmans, Green, and Co.
  • The New Gradatim prepared by WM. C. Collar (1889, 1895, 1897, 1899, 1900, 1903); Ginn & Company, Publishers
  • Excerpta Facilia, A Second Latin Translation Book by H. R. Heatley, M.A.and H. N. Kingdon, B.A. (1882); Rivingtons London

Language, Literature, and Life

  • Latin Book 1 by Harry Fletcher Scott, and Annabel Horn (1936); Scott, Foresman, and Co
  • Latin Book 2 by Harry Fletcher Scott, and Annabel Horn (1937); Scott, Foresman, and Co
  • Revision of A second-Year Latin Reader (1919,1929)
  • Latin Book 3 by Harry Fletcher Scott, and Annabel Horn (1939); Scott, Foresman, and Co
  • Latin progress tests for Latin one by Harry Fletcher Scott, and Annabel Horn (1936); Scott, Foresman, and Co

Using Latin

  • Using Latin Book 1 by Harry Fletcher Scott, Annabel Horn, and John Flagg Gummere (1948, 1963 (new cover)); Scott, Foresman, and Co
  • Revision of Latin Book One (1936)
  • Using Latin Book 2 by John Flagg Gummere and Annabel Horn (1950, 1955, 1963 (new cover)); Scott, Foresman, and Co
  • Revision of Latin Book Two (1937)
  • Using Latin Book 3 by John Flagg Gummere and Annabel Horn (1954, 1963 (new cover)); Scott, Foresman, and Co
  • Revision of Latin Book Three (1939)
  • Teacher’s guidebook for Using Latin: Book One by Harry Fletcher Scott, and Annabel Horn (); Scott, Foresman, and Co
  • College Latin by Norman Johnston De Witt, John Flagg Gummere and Annabel Horn (1954); Scott, Foresman, and Co

Ullman and Henry

  • Elementary Latin with Correlated Studies in English by B. L. Ullman, Ph.D and Norman E. Henry, M.A. (1923, 1925, 1928, 1930, 1936, 1939 (new cover)); The Macmillan Company
  • First Latin Book by B. L. Ullman, Ph.D and Norman E. Henry, M.A. (); The Macmillan Company
  • Second Latin Book by B. L. Ullman, Ph.D and Norman E. Henry, M.A. (1925 (third printing), 1927, 1943); The Macmillan Company
  • Third Latin Book by B. L. Ullman, Ph.D and Norman E. Henry, M.A. (); The Macmillan Company

Ullman and Henry’s ‘new’ series

  • New Elementary Latin by B. L. Ullman, Ph.D and Norman E. Henry, M.A. (1930, 1935, 1941 (RE, new cover)); The Macmillan Company
  • New First Latin Book by B. L. Ullman, Ph.D and Norman E. Henry, M.A. (); The Macmillan Company
  • New Second Latin Book by B. L. Ullman, Ph.D and Norman E. Henry, M.A. (1945); The Macmillan Company
  • New Third Latin Book by B. L. Ullman, Ph.D and Norman E. Henry, M.A. (); The Macmillan Company

Latin for Americans

  • Latin For Americans, First Book by B. L. Ullman, Charles Henderson Jr., and Norman E. Henry (1941, 1950 (RE), 1956 (2RE), 1959 (3RE), 1962 (4RE)); The Macmillan Company
  • Based in part on Elementary Latin Macmillan Company 1923, 1929, and 1936
  • Latin For Americans, Second Book by B. L. Ullman, Charles Henderson Jr., and Norman E. Henry (1942, 1950 (RE), 1956 (2RE), 1959 (3RE), 1962 (4RE)); The Macmillan Company
  • Latin For Americans, Third Book by B. L. Ullman and Albert I. Suskin (1965); The Macmillan Company

The Lake Classical Series

  • The Private Life of the Romans by Harold Whetstone Johnson (1903, 1905, 1909); Scott, Foresman, and Company
  • Ad Alpes, A Tale of Roman Life by H. C. Nutting (1923, 1927, 2017 9781981365739); Scott, Foresman, and Company
  • Edited and Republished by Daniel Pettersson, Latinitium in 2017
  • The Anabasis of Xenophon by Augustus Taber Murray Ph. D. (1914); Scott, Foresman, and Company
  • Greek language
  • A New Second Latin Book by Charles H. Beeson and Harry Fletcher Scott (1902, 1916); Scott, Foresman, and Company
  • A revision of the Miller and Beeson Second Latin Book
  • A Third Latin Book by Frederick Warren Sanford , Harry Fletcher Scott, Charles Henry Beeson (1923, 1931 RE); Scott, Foresman, and Company
  • A Primer of medieval Latin by Charles H. Beeson (1925); Scott, Foresman, and Company
  • Bellum Helveticum : A Beginner’s Book In Latin by Arthur L. Janes (1913); Scott, Foresman, and Company
  • Elementary Latin: An Introductory Course by Harry Fletcher Scott, A.M. (1915); Scott, Foresman, and Company
  • First latin Lessons by Harry Fletcher Scott, A.M. and Annabel Horn (1922, 1928); Scott, Foresman, and Company
  • A First Latin Book for Junior High Schools by Harry Fletcher Scott, A.M. (1918); Scott, Foresman, and Company
  • A Junior Latin Reader by Frederick Warren Sanford , Harry Fletcher Scott (1919, 1922); Scott, Foresman, and Company
  • Dedicated to Harold W. Johnson

Other Uncategorized Works

  • Teacher’s Course in Latin Composition by H. C. Nutting (1922); Allyn and Bacon
  • A Supplementary Course in Latin Composition by H. C. Nutting (1901, 1905 RE, 1906 RE); Allyn and Bacon
  • A Latin Primer by H. C. Nutting (1911); American Book Company

A Rotation by One Turn is 1

In Michael Hartl’si Tau Manifestoiiiii, he addresses a criticism of the Tau formulation which points out that the \tau-form of Euler’s equation only relates 4 fundamental constants (e, i, circle constant, and 1), while the \pi-form relates 5 (despite needing to be re-arranged to do so). In response, he jokingly tacks on a trivial ‘+0’ to the \tau-form to put it on par with the \pi-form.

Re-arranged Pi form

e^{i\pi}+1 = 0

Trivially Modified Tau form

e^{i\tau} = 1 + 0

Full Pi form

e^{i\pi} = (-1 + 0i)

Full Tau form

e^{i\tau} = (1 + 0i)

 

However, all joking aside, e^{i\tau} is a complex number which evaluates to the complex number (1 + 0i). Thus, it is not trivial to represent the zero, in fact, it is thoroughly correct to do so. Conversely, the cleverly re-arranged \pi-form is even uglier than previously thought, as it breaks up its own complex number evaluation (-1 + 0i) and places half of it on either side of the equation.

Both forms properly include a zero, but the modified \pi-form breaks the symmetry of the solution, while the \tau-form maintains its symmetry without modification.

Now, as a disclaimer on the \pi-\tau debate, I believe that the debate is not about choosing a constant or a symbol that makes equations look prettier; this is utterly secondary and wholly counterproductive. The debate is about the proper definition of the fundamental circle constant. Which, is \tau, obviouslyiv.

References:
  1. https://www.michaelhartl.com/ []
  2. https://hexnet.org/files/documents/tau-manifesto.pdf []
  3. https://tauday.com/tau-manifesto []
  4. https://www.imdb.com/title/tt8228288/ []

The Sundering of Christendom


“I appeal to you, brothers, by the name of our Lord Jesus Christ, that all of you agree, and that there be no divisions among you […]” – 1 Corinthians 1:10.i

 

Today, there are about 2.2 billion Christians worldwide ii and over 350 Christian movements or denominationsiii. Much ink and blood has been spilled regarding these divisions.

Those who are slightly familiar with the history of Christianity may recall at least three major historical events:

  • 1st century: The Founding of the Church
  • 11th century: The Great Schism, separating Orthodox and Roman Catholics
  • 16th century: The Protestant Reformation, separating Protestants from Catholics

A cursory glance at history suggests that the Christian church was basically a homogeneous body until the Great Schism. To some extent, this is true after the 4th century, when Emperor Constantine legalized Christianity in the Roman Empireiv and Emperor Theodosius made it the official State Religionv.

However, upon further inspection, one will find that the situation is not so clear. The chart below illustrates historical origin of the various Christian groups or branches who claim to be descended from the State Religion of the Late Roman Empire. Technically, these churches claim to be (or be a part of) the ‘one, holy, catholic and apostolic Churchvi.

The scope of this illustration is restricted to the Roman Catholic Church, the Eastern Orthodox Churches, The Oriental Orthodox Church, the Church of the East, and certain other relevant historical communities. The chart notably excludes the Protestant groups, including the Church of England. It is also lacking a thorough examination of pre-Constantinian Christian communities. Liturgical families or rites are also highlighted.

The chart takes the form of a timeline, beginning from the first century to the present day (left to right).

References:
  1. Bible Gateway: 1 Corinthians 1:10 []
  2. Pew Research: Global Christianity Report []
  3. Rough count of the member list of the World Council of Churches []
  4. Wikipedia: The Edict of Milan, AD313 []
  5. Wikipedia: The Edict of Thessalonica, AD380 []
  6. Wikipedia: Four Marks of the Church []

How to handle Percent Change and CAGR for negative numbers

Sometimes finance deals with negative quantities that become less negative over time. For example, consider a profit/(loss) of ($50M) in year 1 that becomes a profit/(loss) of only ($1M) in year 4. If we apply the traditional formulas for Percent Change and Compound Annual Growth Rate (CAGR), we find that the results do not align with common-sense interpretation. Beginning with % Change, the usual formula is:

\%\triangle=\frac{F-I}{I}=\frac{F}{I}-1, plugging in our example values: \%\triangle=\frac{-1--50}{-50} = -98\%

Common-sense says our profit is increasing, therefore we expect +98%. Using an absolute value in the denominator adjusts the formula in such a way that is consistent with the common-sense interpretation.

\%\triangle_{ADJ} = \frac{F-I}{abs(I)}, plugging in our example values: \%\triangle_{ADJ} = \frac{-1--50}{abs(-50)}=+98\%

_______________________________________________________________________________________

Now, the usual formula for CAGR is:

CAGR=\left (\frac{F}{I} \right )^{\frac{1}{time}}-1, plugging in our example values: CAGR=\left (\frac{-1}{-50} \right )^{\frac{1}{3}}-1=-73\%

Again, the common sense interpretation expects a positive growth rate since profit is increasing. We can not, however, simply reverse the sign as with % change. Let us re-write CAGR to illustrate the solution. This form is identical to the usual formula. Re-arranging it in this way allows us to see that % Change is embedded in the formula:

CAGR=\left (\frac{F}{I}-1+1 \right )^{\frac{1}{time}}-1=\left (\%\triangle+1 \right )^{\frac{1}{time}}-1

If we replace % Change with Adjusted % Change, we will have an Adjusted CAGR that yields the growth rate consistent with the common-sense interpretation:

CAGR_{ADJ}=\left (\%\triangle_{ADJ}+1 \right )^{\frac{1}{t}}-1=\left (\frac{F-I}{abs(I)}+1\right )^{\frac{1}{t}} -1=\left (\frac{F-I+abs(I))}{abs(I)} \right )^{\frac{1}{t}}-1

Therefore,

CAGR_{ADJ}=\left (\frac{F-I+abs(I))}{abs(I)} \right )^{\frac{1}{time}}-1, plugging in our example values: CAGR_{ADJ}=\left (\frac{-1--50+abs(-50))}{abs(-50)} \right )^{\frac{1}{3}}-1=+26\%

_______________________________________________________________________________________

How to Measure Temperature with a Thermistor

An NTC (Negative Temperature Coefficient) Thermistor is a passive electrical component whose resistance varies inversely with temperature.i It is often used as a temperature sensor. The relationship between resistance and temperature can be described with the ‘beta’ formula.

In this experiment we will show how to use the National Instruments myDAQii in conjunction with LabVIEWiii to create a Virtual Instrument that automatically and continuously measures the temperature. It is noted, however, that myDAQ/LabVIEW are not needed for the simplest form of this exercise, which can be performed with just a multimeter and a thermistor.

_______________________________________________________________________________________

Parts List

  • 1x National Instruments myDAQ (using the DMM ohmmeter probes)
  • 1x LabVIEW software
  • 1x 10KΩ Thermistor (ex: Vishay NTCLE100E3 from Digikey BC2396CT-ND)iv
  • 2x pieces of wire (or probes)
  • 1x (optional) MyProtoboardv (or any breadboard)

Equations

The relationship between resistance and temperature is given by the ‘beta’ equationvi, a simplified approximation of the Steinhart-Hart equation.vii The Beta value (B), the Reference Temperature (T0), and the Reference Resistance (R0) are given in the thermistor’s datasheetviii. The component’s Resistance (R) is measured by an ohmmeter and then Temperature (T) can be solved for.

The ‘Beta’ Equation:

B = \frac{T_{0}\cdot T}{T-T_{0}}\cdot ln\left ( \frac{R_{0}}{R} \right )

Solving for T,

T = \frac{B}{ln \big( \frac{ R e^{ \frac{B}{T_{0}} } }{R_{0}} \big)}

‘Circuit’ Setup

Simply attach the myDAQ ohmmeter probes to the thermistor which can be placed optionally onto the breadboard. The resistance will be measured by the myDAQ and sent to LabVIEW for processing.

 
 

LabVIEW Front Panel

The Virtual Instrument Front Panel allows the user to input the Beta Value, the Reference temperature, and the Reference Resistance, again taken from the Datasheet. The resistance measured by the myDAQ is also displayed. The interface graphically outputs the calculated temperature in Kelvin, Celsius, and Fahrenheit.


 
 

LabVIEW Block Diagram

The block diagram is the programming language of LabVIEW and the back-end of the Front Panel. Each component on the Front Panel is graphically represented in the block diagram. The image shows how the variable inputs from the front panel and the myDAQ are passed through a graphical representation of the beta formula and then output as temperature values.

 
 

Excel Calculator

If myDAQ and LabVIEW are not available, Excel can be used to calculate the temperature.

 
 

Findings

In this experiment, we measured the temperature under the following scenarios: room temperature, surrounding the thermistor with a bag of ice, and grasping it while blowing hot breath on it. Indeed, the thermistor’s resistance is inversely related to temperature. This is a relatively easy experiment that can serve as a good introduction to circuit elements, data acquisition, and LabVIEW programming. Enjoy!

_______________________________________________________________________________________

Downloads

Marinus’ National Instruments LabVIEW Thermistor Calculator Virtual Instrument (v1.0) 2014 01 31
Marinus’ Thermistor Temperature Calculator in Excel (v1.0) 2014 01 31

_______________________________________________________________________________________

 
 

References:
  1. Wikipedia “Thermistor” []
  2. National Instruments “myDAQ Portable Measurement and Instrumentation Device” []
  3. National Instruments “LabVIEW System Design Software” []
  4. NTC Thermistor “Digi-Key BC2396TR-ND” []
  5. MyProtoboard “Protoboard Kit by Elenco for myDAQ via National Instruments” []
  6. NTC Thermistors “Engineering Notes from Spectrum Sensors and Controls Inc. via Digikey Corp.” []
  7. Wikipedia “Steinhart–Hart equation” []
  8. Vishay BCcomponents “NTCLE100E3
    NTC Thermistors, Radial Leaded, Standard Precision” []

Waterfall Charts

Are you looking for an easy to use, versatile Waterfall Chart template for Microsoft Excel?

The Waterfall Chart, also known as a Bridge, a Walk, flying bricks, or a Mario Charti, is a most useful visualization for a variety of applications. It can be used to ‘walk’ from a beginning value to an ending value, show the parts of a whole, show changes over time, and more. While Microsoft Excel does not provide a built-in solution for creating this type of chart, Fort Marinus presents a free template.

Please enjoy and comment or email suggestions.

_______________________________________________________________________________________

Marinus’ Waterfall Chart Template for Excel (v4.122) 2014 06 26 NEW!

  • No Add-ins, just a good old Excel Worksheet
  • Ability to show positive and negative changes above AND below zero! (axis crossovers)
  • Automatic labeling of bar elements
  • Ability to specify multiple ‘Subtotal’ (or ‘Anchor’ or ‘Middle’) columns
  • Ability to toggle ‘connector lines’ between bar elements
  • Convenient formatting shortcuts
  • Plus, all the usual Excel formatting customizations

_______________________________________________________________________________________

Examples Gallery

_______________________________________________________________________________________

Acknowledgements

  • Thanks to Liam Bastick at SumProduct for creating an excellent walkthrough on waterfall chartsii
  • Thanks to Aaron Henckler at Chandoo.org for creating an excellent tutorial on waterfall chartsiii
  • Thanks to Rob Bovey at AppsPro for creating a very useful add-in for labeling chartsiv

_______________________________________________________________________________________

References:
  1. Waterfall Chart http://en.wikipedia.org/wiki/Waterfall_chart []
  2. Waterfall Charts http://www.sumproduct.com/thought/waterfall-charts []
  3. Excel Waterfall Charts http://chandoo.org/wp/2009/08/10/excel-waterfall-charts/ []
  4. The XY Chart Labeler http://www.appspro.com/Utilities/ChartLabeler.htm []

Annotated Ainulindalë

 

“And he spoke to them, propounding to them themes of music; and they sang before him, and he was glad.” Ainulindalë 1:2

 

The Silmarillion is a collection of stories from Tolkien’s legendarium. The first part, called Ainulindalë, is a Creation myth. The story is written in prose and reads a bit like Scripture. I thought it would be interesting to simply format the work to look more like a real book of scripture. I added chapter headings, verse line numbers, and annotations/references as one might find in a Bible. I think it makes the work fun to read. And, it also allows one to use Chapter and Verse to quote a specific line.

Galaxy Empire

Galaxy Empire 

A resource for calculators, simulators, charts, formulas, and secrets.

Conquer the Galaxy, One Planet at a Time. In the near distant future, space exploration has evolved into a much more sophisticated nature as planets are colonized by humans in a fierce battle for resources and influence. Immerse yourself in intergalactic diplomacy as you manage your bases and natural resources while waging war against enemies.
Download: iOS Android

Note: This post was made for Galaxy Empire version 1.6. The information here is out of date. I do not plan on updating it. Thanks for your interest.

_______________________________________________________________________________________

Marinus’ Galaxy Empire Output Formulas and Calculator (v2.0) 2013 01 13
Fort Marinus has discovered the secret Galaxy Empire Output formulas for the Metal Mine, Crystal Mine, Gas Mine, Solar Plant, Solar Satellites, and the Fusion Reactor. With these formulas and associated tables, one can know the units of Gas, Metal, Crystal, and Energy produced per hour.

_______________________________________________________________________________________

Marinus’ Galaxy Empire Resource Calculator (v2.0) 2013 01 05
This tool allows you to calculate the amount of time it will take to gather a certain amount of resources. It will also show how many resources you will have gathered after a certain amount of time.

_______________________________________________________________________________________

Marinus’ Galaxy Empire Battle Calculator (BETA v0.1) 2012 10 26
This tool allows you to simulate the combat of Galaxy Empires. Input the number of each type of ship for each combatant and see who wins. Note: This calculator is in beta form, the formulas are not exactly correct, but they are close.

_______________________________________________________________________________________

Marinus’ Galaxy Empire Upgrade Cost Charts (v1.0) 2013 01 01
This Excel spreadsheet shows the costs for buildings and upgrades up to Level 30. It also explains the cost formula below in more detail.

Use this formula and schedule to calculate the cost of any building/technology upgrade.

Galaxy Empire Buiding and Technology Upgrade Formula

_______________________________________________________________________________________

Fuel Conversion Rate (v4.0) 2013 01 01
Whenever attacking an NPC planet, fuel (gas) is spent and loot is gained. The ‘Units of Loot gained per Unit of Fuel (gas) spent*’ is called the Fuel ‘Conversion’ Rate.  Apparently, sending 20 ships or less results in a gain of 1.5 Metal plus 1.5 Crystal for every 1 unit of Fuel (Gas) spent. After 20 ships, the amount of loot gained decreases exponentially (?) along a ‘minimum loot curve’, however there seems to be a ‘chance’ to gain the maximum loot. *also the number of Ships sent

Takeaways:
– It is most efficient to send as few ships as possible.
– Sending more than 300-400 ships results in a net Loss of resources.

Still unknowns:
– What is the formula for the minimum loot curve?
– What is the ‘chance’ formula to gain minimum or maximum loot, or somewhere in-between?

Galaxy Empires Fuel Conversion Chart

 

Notes:
These data were collected by attacking the Level 2 or Level 3 ‘The Purged’ planet with varying numbers of Light Fighters. No ships were lost in the attacks. Initial observations of repeating this experiment with Destroyers attacking the Level 11 ‘Pollution Origins’ planet show that sending 50 or less ships is highly likely to yield a maximum loot gain of 1.21 units of Metal plus 1.21 units of Crystal for every unit of Fuel (gas) spent. Sending more than ~250 ships results in a net Loss of resources.

_______________________________________________________________________________________

 

Naked Eye and the Sky

 

“मधु नक्तमुतोषसो मधुमत पार्थिवं रजः | मधु दयौरस्तु नः पिता || ” – Rig Veda I.90.7.

“Sweet be the night and sweet the dawns, sweet the terrestrial atmosphere; Sweet be our Father Heaven to us.”

 

Father Heaven in the quote above is ‘Dyauṣ Pitā’ in Sanskrit. The same deity called ‘Zeus Pater’ by the Greeks and ‘Iuppiter’ by the Romans.i When the ancients looked into the skies, they were so impressed by the planets that they associated the celestial bodies with their own gods.

Tonight, the gods have blessed us with clear skies and a celestial treat: The Moon, Jupiter, and Venus are clearly visible to the naked eye. The planets are particularly striking in an urban environment where light pollution obscures all but the brightest luminaries.

Unfortunately, these photos were taken without the benefit of a telescope.

 

I would like to think I caught an orbiting moon or two around Jupiter, but the peripheral dots are probably just artifacts from the camera, the digital zoom, and the shaking of the wind.

References:
  1. Dyauṣ Pitā and Jupiter are associated with the same Indo-European diety, but in Hindu astrology, the Planet Jupiter is identified with Bṛhaspati, Lord of Prayer. The planet is also associated with Marduk in Babylonian astrology. []

© Fort Marinus . Powered by WordPress and Manifest