{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Invoice","Products List","Databse"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":20,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,0,12,0],[13,0,16,0],[17,0,18,0],[0,0,0,2],[1,1,1,2],[3,1,12,1],[13,1,16,1],[17,1,18,1]]}
["Instructions - Invoice-Generator"]
["Step","Description"]
["1) Introduction","The 'Invoice-Generator' tool consists of three main sheets:\n1. Invoice: Editable Dynamic Invoice Template\n2. Products List: Database of available products,\n3. Database: Record of generated invoices."]
["2) Description WorkSheet \"Invoice\"","This sheet allows you to customize and generate invoices. It is divided into the following sections:\n\nTop of the Invoice\n1. Legal information: Includes the company name, address, location, and contact methods.\n2. Logo space: Field reserved to insert the company logo.\n3. Issue date: Date when creating the invoice.\n4. Invoice number: Automatically calculated based on the records in the \"Database\" sheet.\n5. Customer information: Editable fields for name, address, phone number, etc. These fields can be renamed or deleted as needed.\n\n\n\nBottom of the Invoice\n1. Purchase table: Allows you to add, edit or delete products.\n2. Financial summary: Subtotal, taxes, discounts, comments and purchase total."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3) Buttons on the \"Invoice\" sheet","The worksheet includes 4 functional buttons:\n1. Add Product: Allows you to add a new product to the purchase table.\n2. Delete Product: Deletes the last product from the table.\n3. Generate Invoice: Creates a copy in PDF and Excel (.xlsx) format.\n4. Reset Form: Restores the template to its initial state, deleting the entered data.  \n"]
[]
[]
[]
["4) \"Product List\" Sheet","This worksheet works as an internal database of the products available for sale.\nRequired columns:\n1. Description: Name or detail of the product.\n2. Unit price: Cost of the product.\n\nImportant: Complete both columns, as these values ​​will be used to generate the invoice."]
[]
["5) \"Database\" Sheet","The \"Database\" worksheet automatically stores all generated invoices, providing easy management without the need for an external database.\n- Ideal for small businesses or startups.\n- Includes a basic invoice log with key information."]
["6) Additional Notes","- Make sure you enable macros in Excel for the tool to work properly.\n- In case of problems or questions, contact technical support."]

{"sheet":"Invoice","index":1,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,0,25,1],[24,2,24,3],[23,2,23,3],[21,0,21,1],[22,0,24,1],[19,0,19,1],[2,0,2,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[12,1,12,4],[13,1,13,4],[14,1,14,4],[18,0,18,1],[15,1,15,4]]}
[]
[]
["INVOICE"]
[]
["Smartcode Builders",null,null,"DATE",{"$f":"NOW()","v":"2025-02-04T16:10:07.210"}]
["Maracaibo, Venezuela"]
["Maracaibo, Venezuela",null,null,"INVOICE No.",{"$f":"TEXT(MAX(Databse!$A:$A) + 1,  \"000000000\")","v":"000000001"}]
["info@smartcodebuilders.com"]
[]
[]
[]
["Client Information"]
["Name"]
["Address"]
["Phone number"]
["Email"]
[]
[]
["DESCRIPTION",null,"QUANTITY","UNIT PRICE","TOTAL"]
[null,null,null,{"$f":"IFERROR(VLOOKUP(A20,'Products List'!A:B,2,FALSE),0)","v":0},{"$f":"C20*D20","v":0}]
[]
["Remarks / Payment Instructions",null,null,"SUBTOTAL",{"$f":"SUMIFS(E19:E21,E19:E21, \">-1E+300\")","v":0}]
[null,null,null,"DISCOUNT",0]
[null,null,"TAX RATE",null,0.12]
[null,null,"TOTAL TAX",null,{"$f":"((SubTotal-DiscountCell)*TaxCell)","v":0}]
[null,null,null,"TOTAL",{"$f":"SubTotal-DiscountCell+TotalTaxCell","v":0}]

{"sheet":"Products List","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Product","Unit Price"]
["Basic Phone",50]
["Simple Laptop",250.25]
["Headphones",35.25]
["Gaming Console",450]
["Power Bank",65.849999999999994]
["80\" TV OLED",1250]
["60\" TV OLED",865.95]

{"sheet":"Databse","index":3,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Invoice No.","Date","Client","Product","Total Shop"]