monash_2472.pdf (423.66 kB)
Fitting a Table to a Page Using Non-linear Optimisation
journal contribution
posted on 2017-06-06, 01:08 authored by Beaumont, NicholasIt is sometimes difficult to fit a large table comprising several rows and columns onto a page. The usual tactic is to manually adjust column widths, abbreviate some text and/or change some cells' font sizes until the table fits onto a page. We show that it is possible to express the problem of adjusting column widths so as to minimize the height of a table as an optimization problem with non-linear constraints. Five test problems were routinely solved using a free software package. We stress that the solutions are approximate because the model imperfectly simulates how many lines of a cell of a table will be required to contain a segment of text, but they appear to provide good approximations in difficult cases. The scant literature is summarized; the formulation and solution techniques outlined; examples are described; and differences between theoretical and actual answers explained. It would be possible to incorporate the calculations in word processing and typesetting packages such as Word and TeX.
History
Year of first publication
2003Series
Department of ManagementUsage metrics
Categories
No categories selectedLicence
Exports
RefWorks
BibTeX
Ref. manager
Endnote
DataCite
NLM
DC