Site Tools


tabletest

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
tabletest [2022/11/13 21:55] Alan Sheatabletest [2022/11/13 21:56] (current) – removed Alan Shea
Line 1: Line 1:
-====Items to Order==== 
-^ ~~=label(items_1)~~ Item  ^ Part #         ^ Description                                  ^  Unit  ^  Quan  ^  Cost      Total                            ^ Comment/Notes  ^ 
-|  ~~=cell(0,row()-1)+1~~   | NT855-G6 LONG  | Cummins NT855-G6, CPL 1381 Reman Long Block  |  ea    |  1      15500.00 |  ~~=cell(4,row())*cell(5,row())~~ |                | 
- 
- 
-|  **//Total://** ^  $~~=round(sum(items_1.c5r1:c5r99),2)~~ ^ 
-| Total should be $15500.00|| 
- 
- 
-====Items to Order==== 
-^ ~~=label(items_2)~~ Item  ^ Part #         ^ Description                                  ^  Unit  ^  Quan  ^  Cost      Total                            ^ Comment/Notes  ^ 
-|  ~~=cell(0,row()-1)+1~~   | NT855-G6 LONG  | Cummins NT855-G6, CPL 1381 Reman Long Block  |  ea    |  1      15500.00 |  ~~=cell(4,row())*cell(5,row())~~ |                | 
-|  ~~=cell(0,row()-1)+1~~   | CORE           | Block Core charge                            |  ea    |  1       4000.00 |  ~~=cell(4,row())*cell(5,row())~~ |                | 
-|  ~~=cell(0,row()-1)+1~~   | LTL            | Freight                  ea    |  1       1420.00 |  ~~=cell(4,row())*cell(5,row())~~ |                | 
-|  ~~=cell(0,row()-1)+1~~   | TAX            | Sales Tax                                    |  ea    |  0             0 |  ~~=cell(4,row())*cell(5,row())~~ |                | 
- 
- 
- 
-|  **//Total://** ^  $~~=round(sum(items_2.c5r1:c5r99),2)~~ ^ 
-| Total should be $20920.00|| 
- 
-See https://forum.dokuwiki.org/d/20026-tablecalc-stops-sum-after-too-many-entries/ 
  
tabletest.1668376523.txt.gz · Last modified: 2022/11/13 21:55 by Alan Shea