The source of mybook
Hi This the source of my book, all free and GPL: - text. - code. - images svg, png, pdf. https://sourceforge.net/projects/laws-in-physics/files/source/ Best regards
Re: Invoking spreadtab.sty [UPDATE]
On Sat, 23 Dec 2017, Andrew Parsloe wrote: Rich, some years ago I developed a module so that spreadtab could be used in LyX and if instant preview was on it allowed a kind of lightweight interactive spreadsheeting. I used it for keeping a timesheet when I was freelancing as an indexer. Andrew, When I'm engaged as a consulting/testifying expert by litigators I need to provide a monthly statement of withdrawals against the retainer (and replentishment of the retainer as needed). The spreadtab and longtable packages fill this need. There's a link to a dropbox folder, holding a zipped archive of the module and explanatory document, on the wiki: item 1.5 at http://wiki.lyx.org/Layouts/Modules. The module provides a command for turning a table built in LyX into a spreadtab table. There are a couple of other helper commands defined too. Got it. Should work with the 2.2.3 version here. Possibly the examples in the document would give you all the help you need. I'll read the doc and work with it over the weekend. Thanks very much, Rich
Re: Invoking spreadtab.sty [UPDATE]
On 23/12/2017 10:44 a.m., Rich Shepard wrote: On Fri, 22 Dec 2017, Rich Shepard wrote: Having put \usepackage{spreadtab} in the preamble, I assume that I put the ERT \begin{spreadtab} just above the table and the ERT \end{spreadtab} immediately following the table (similar to use of the \multicol package.) Is this correct? Apparently not; but I may well be wrong. Expanding my request for help with spreadtab, how do I enter formulae in a cell (e.g., c2*e2) or relative references (using backets to define the relative cell positions)? The spreadtab docs describe doing this in LaTeX and I'd appreciate pointers on using this package in LyX. TIA, Rich Rich, some years ago I developed a module so that spreadtab could be used in LyX and if instant preview was on it allowed a kind of lightweight interactive spreadsheeting. I used it for keeping a timesheet when I was freelancing as an indexer. There's a link to a dropbox folder, holding a zipped archive of the module and explanatory document, on the wiki: item 1.5 at http://wiki.lyx.org/Layouts/Modules. The module provides a command for turning a table built in LyX into a spreadtab table. There are a couple of other helper commands defined too. It is some time since I last looked at this -- the dropbox link is to a LyX 2.1 document -- so my knowledge is a bit rusty but I imagine it would come back. Possibly the examples in the document would give you all the help you need. Andrew --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
Re: Invoking spreadtab.sty [UPDATE]
On Fri, 22 Dec 2017, Rich Shepard wrote: Having put \usepackage{spreadtab} in the preamble, I assume that I put the ERT \begin{spreadtab} just above the table and the ERT \end{spreadtab} immediately following the table (similar to use of the \multicol package.) Is this correct? Apparently not; but I may well be wrong. Expanding my request for help with spreadtab, how do I enter formulae in a cell (e.g., c2*e2) or relative references (using backets to define the relative cell positions)? The spreadtab docs describe doing this in LaTeX and I'd appreciate pointers on using this package in LyX. TIA, Rich
Invoking spreadtab.sty
I read in Herb Voss' book ("Typesetting tables with LaTeX") that the spreadtab package replaces the tabular environment. Reading the Tables section of the Embedded Objects manual I see no reference to the spreadtab package. Having put \usepackage{spreadtab} in the preamble, I assume that I put the ERT \begin{spreadtab} just above the table and the ERT \end{spreadtab} immediately following the table (similar to use of the \multicol package.) Is this correct? Rich
Re: Creating a statement of account
On Fri, 22 Dec 2017, Dr Eberhard Lisse wrote: my view is that you are using the wrong tool, ie typesetting to do bookkeeping instead of letting the bookkeeping do the typesetting. It seems that no one read what I wrote. Yes, I used to use SQL-Ledger, too, until it died. Now I use GnuCash. I am using LyX with the longtable package to _write_ a statement of account. However, ... Rich
Re: Creating a statement of account
Well, my view is that you are using the wrong tool, ie typesetting to do bookkeeping instead of letting the bookkeeping do the typesetting. I use SQL-Ledger which is Open Source in Perl and uses LaTeX to prepare the invoices. I have developed a template with KOMA-Script to my liking and haven't looked at it for years, as it merrily emails the invoises el On 2017-12-21 00:32 , Rich Shepard wrote: > I'm trying to create an account statement for clients whom I invoice > by time and expense and I'm missing something in my efforts. The > statement is a running explanation of payments received and charges > against those payments. I'm trying to use the invoice2 package, so > far unsuccessfully. [...]
Re: Creating a statement of account [RESOVED]L
On Fri, Dec 22, 2017 at 10:47 PM, Rich Shepardwrote: > On Fri, 22 Dec 2017, Joel Kulesza wrote: > > I tend to agree with Steve's points. >> > > Joel, > > I fail to understand why you and Steve think LyX/LaTeX is not suitable > for > producing an invoice/statement while a word processor such as LibreOffice > is. In my very vague statement I made no such claim that LibreOffice / Microsoft office is suitable, but instead tried to suggest that LaTeX may not be the right tool. Rather, I would rely on purpose-built accounting software to manage finances. This software would be able to focus on the details and complexities of the finances, rather than the details of the output. Those financial details could then be captured and moulded into whatever output format, and with whatever output processor, you prefer (LaTeX, myriad Pandoc-compatible formats, etc.). While I wholly appreciate LaTeX's capabilities, as a general framework lots of folks have adapted it to uses that it, as a typesetting engine, isn't best suited. As one goes from typesetting toward programming, I start to ask myself whether it is the right tool to perform the processing or just to prepare the ultimate output. If one has invoices that are as simple as what I demonstrated, by all means use it. However, not knowing your business finances, I can't make that assessment and would prefer to err on the side of caution. As an example: I use TikZ heavily and it isn't so long ago that I was using it to perform a calculation within an illustration and was surprised to see that a rather basic trigonometric function wasn't available in the version of TeXLive I was using. Keeping everything "in LaTeX" is ideal, but sometimes there are weaknesses or simplifications made in available packages that make this more troublesome/risky (how much of the solution is rigorous versus being a functional hack?) than using an external application. When it comes to finances, I wish to avoid any hint of risk. > I can produce invoices with GnuCash, but they're more parts-focused, not > time-and-expense-focused. I used to use a spreadsheet to track retainer anc > charges but the output is not as professional as is the output from LaTeX. > Using a spreadsheet, GnuCash, or some other finance-based software and then directing its output to LaTeX for ultimate typesetting is how I would operate. This way you get the strength of a proper accounting program but the elegant output of LaTeX. The two key adages I follow in this regard are UNIX's "do one thing, and do it well" and someone else's "use the right tool for the right job." > However, do you have an example .lyx file that isn't working for you and >> an example of what you're trying to achieve (perhaps from a pre-LyX >> interface)? Do you have a MWE, maybe without the fancy invoice2 >> components? >> > > My question was how to correctly implement the invoice2 package and the > example you sent explains that very well. It also shows me that the > invoice2 > package is not suitable for a statement which is a history of the project > rather than a stand-alone invoice for a single month. Seeing this now > answers my question. Good. > And, LyX does produce a nicely typeset statement which > can run multiple pages when necessary. > Indeed. I have periodically used multipage tables (manually, not with a guiding framework like invoice2) and have been generally happy with the result. - Joel
Re: Creating a statement of account [RESOVED]L
On Fri, 22 Dec 2017, Joel Kulesza wrote: I tend to agree with Steve's points. Joel, I fail to understand why you and Steve think LyX/LaTeX is not suitable for producing an invoice/statement while a word processor such as LibreOffice is. I can produce invoices with GnuCash, but they're more parts-focused, not time-and-expense-focused. I used to use a spreadsheet to track retainer anc charges but the output is not as professional as is the output from LaTeX. However, do you have an example .lyx file that isn't working for you and an example of what you're trying to achieve (perhaps from a pre-LyX interface)? Do you have a MWE, maybe without the fancy invoice2 components? My question was how to correctly implement the invoice2 package and the example you sent explains that very well. It also shows me that the invoice2 package is not suitable for a statement which is a history of the project rather than a stand-alone invoice for a single month. Seeing this now answers my question. And, LyX does produce a nicely typeset statement which can run multiple pages when necessary. Thanks to both of you for responding, Rich
Re: Creating a statement of account
On Thu, Dec 21, 2017 at 7:32 AM, Rich Shepardwrote: > I'm trying to create an account statement for clients whom I invoice by > time and expense and I'm missing something in my efforts. The statement is > a > running explanation of payments received and charges against those > payments. > I'm trying to use the invoice2 package, so far unsuccessfully. > Rich, I tend to agree with Steve's points. However, do you have an example .lyx file that isn't working for you and an example of what you're trying to achieve (perhaps from a pre-LyX interface)? Do you have a MWE, maybe without the fancy invoice2 components? - Joel