LibreOffice Base for Sign Database
Budget: $225 – $450 USD
This is a program to keep data on signs. These sigs are made of layers of sheet metal. Make a LibreOffice Base to be fully operation to have 6 pages, tables, and a few form controls. This has 2 main functions. When I add to a list of signs, it will give me a cost estimate of those files. The other main function will be to grab the files in one folder, and separate those files into another. It will create 4 folders to send those .dxf; 1 for studded, 1 for white, 1 for black and 1 for all others. But first, it must save the previous .dxf files in a folder DDMMMYYYY-001
9 Tables:
1) mainTable: with fields Unique ID, Sign Check, Records Check, signSKU, plateSKU, signCheck, recordCheck, signName, signSize, colorTable, MSRP Dollars, Sign Linear Cut, Sign Surface Area, Sign Metal Area, Metal Utilization, Sign Image, Plate A, Plate B, Plate C, Plate D, Plate E, Plate F, Plate G, Plate H, Plate I, Plate J, Plate K, Plate L, Plate Linear Cut, Plate Surface Area, Plate Metal Area Plate Metal Utilization, Plate Studded
2) signSKU:
3) plateSKU: with record N/A
4) signName: with record N/A
5) signSize: with fields of XS, S, M, L, XL, C
6) colorTable: with fields of Company Color, RGB, Hex and CMYK
7) plateStudded: with fields of Yes, No and N/A
8) costEstimateValues: with 4 fields of Metal Cost ($/sq.in.), Laser Cost ($/min.), Paint Cost ($/sq.in.) AND Cut Speed (in./min.)
9) generalLedger: with 5 fields of Ledger Date, Account Description, Reference No., Debit, Credit
6 Navigation Pages:
1) Main Page
a) Sign Records ++
b) Sign Record EDIT/Lookup
c) Cost Estimate ++ with printout for American Standard paper
d) Cost Estimate Summary with a "SEND DXF" form control to send .dxf files to a folder
e) Cost Estimate Values
f) Sign Printout (Prints 2x4, 2x4 and 2x6) on American standard page.
9 Tables:
1) mainTable: with fields Unique ID, Sign Check, Records Check, signSKU, plateSKU, signCheck, recordCheck, signName, signSize, colorTable, MSRP Dollars, Sign Linear Cut, Sign Surface Area, Sign Metal Area, Metal Utilization, Sign Image, Plate A, Plate B, Plate C, Plate D, Plate E, Plate F, Plate G, Plate H, Plate I, Plate J, Plate K, Plate L, Plate Linear Cut, Plate Surface Area, Plate Metal Area Plate Metal Utilization, Plate Studded
2) signSKU:
3) plateSKU: with record N/A
4) signName: with record N/A
5) signSize: with fields of XS, S, M, L, XL, C
6) colorTable: with fields of Company Color, RGB, Hex and CMYK
7) plateStudded: with fields of Yes, No and N/A
8) costEstimateValues: with 4 fields of Metal Cost ($/sq.in.), Laser Cost ($/min.), Paint Cost ($/sq.in.) AND Cut Speed (in./min.)
9) generalLedger: with 5 fields of Ledger Date, Account Description, Reference No., Debit, Credit
6 Navigation Pages:
1) Main Page
a) Sign Records ++
b) Sign Record EDIT/Lookup
c) Cost Estimate ++ with printout for American Standard paper
d) Cost Estimate Summary with a "SEND DXF" form control to send .dxf files to a folder
e) Cost Estimate Values
f) Sign Printout (Prints 2x4, 2x4 and 2x6) on American standard page.