{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Web form","Options"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Web form","index":0,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["GEODE-JSP Rugged System option selector and part number configurator",null,"v5.3","2024-08-01",null,"Hide","Hide","Hide","Hide"]
["Click yellow cell. Then click arrow that appears to the right to choose an option.",null,null,null,null,"for","for","for","for"]
["Options with * are considered \"default\" options.",null,null,null,null,"Customer","Customer","Customer","Customer"]
["Part number and part description text will automatically fill in based on your selections.",null,null,null,null,"Use","Use","Use","Use"]
["All options must be selected to generate a valid configuration and part number."]
["Then submit this configuration worksheet to the email address below for a quote or further discussion with our technical sales team."]
["sales@diamondsystems.com"]
[null,null,null,"Part number builder text","Part description builder text","Cost","Margin","Price"]
["Base model (no selection required)",null,null,"GEO-JSP","Geode-JSP Rugged System, ",1035,0.6,{"$f":"ROUND(F9/(1-G9),0)","v":2588}]
[]
["Jasper carrier board","Choose One:",null,{"$f":"VLOOKUP(B11,Options!A:C,2,FALSE)","v":""},{"$f":"VLOOKUP(B11,Options!A:C,3,FALSE)","v":""},{"$f":"VLOOKUP(B11,Options!A:F,4,FALSE)","v":0},{"$f":"VLOOKUP(B11,Options!A:F,5,FALSE)","v":0},{"$f":"VLOOKUP(B11,Options!A:F,6,FALSE)","v":0}]
[]
["Processor and RAM","Choose One:",null,{"$f":"VLOOKUP(B13,Options!G:I,2,FALSE)","v":""},{"$f":"VLOOKUP(B13,Options!G:I,3,FALSE)","v":""},{"$f":"VLOOKUP(B13,Options!G:L,4,FALSE)","v":0},{"$f":"VLOOKUP(B13,Options!G:L,5,FALSE)","v":0},{"$f":"VLOOKUP(B13,Options!G:L,6,FALSE)","v":0}]
[]
["I/O connector layout","Choose One:",null,{"$f":"VLOOKUP(B15,Options!M:O,2,FALSE)","v":""},{"$f":"VLOOKUP(B15,Options!M:R,3,FALSE)","v":""},{"$f":"VLOOKUP(B15,Options!M:R,4,FALSE)","v":0},{"$f":"VLOOKUP(B15,Options!M:R,5,FALSE)","v":0},{"$f":"VLOOKUP(B15,Options!M:R,6,FALSE)","v":0}]
[]
["Power supply","Choose One:",null,{"$f":"VLOOKUP(B17,Options!S:X,2,FALSE)","v":""},{"$f":"VLOOKUP($B17,Options!$S:$X,3,FALSE)","v":""},{"$f":"VLOOKUP($B17,Options!$S:$X,4,FALSE)","v":0},{"$f":"VLOOKUP($B17,Options!$S:$X,5,FALSE)","v":0},{"$f":"VLOOKUP($B17,Options!$S:$X,6,FALSE)","v":0}]
[]
["Integrated mass storage","Choose One:",null,{"$f":"VLOOKUP(B19,Options!Y:AD,2,FALSE)","v":""},{"$f":"VLOOKUP(B19,Options!Y:AD,3,FALSE)","v":""},{"$f":"VLOOKUP(B19,Options!Y:AD,4,FALSE)","v":0},{"$f":"VLOOKUP(B19,Options!Y:AD,5,FALSE)","v":0},{"$f":"VLOOKUP(B19,Options!Y:AD,6,FALSE)","v":0}]
[]
["Operating system","Choose One:",null,{"$f":"VLOOKUP(B21,Options!AE:AJ,2,FALSE)","v":""},{"$f":"VLOOKUP(B21,Options!AE:AJ,3,FALSE)","v":""},{"$f":"VLOOKUP(B21,Options!AE:AJ,4,FALSE)","v":0},{"$f":"VLOOKUP(B21,Options!AE:AJ,5,FALSE)","v":0},{"$f":"VLOOKUP(B21,Options!AE:AJ,6,FALSE)","v":0}]
[]
["Expansion I/O","Choose One:",null,{"$f":"VLOOKUP(B23,Options!AK:AM,2,FALSE)","v":""},{"$f":"VLOOKUP(B23,Options!AK:AM,3,FALSE)","v":""},null,null,null,"Enter data"]
[null,null,null,null,null,null,null,null,"for custom"]
[null,"<Enter additional I/O details here. Cell will expand as needed.>",null,null,null,null,null,null,"I/O requirement"]
[null,null,null,null,null,null,null,null,"to get cost & price"]
["Your system part number:",{"$f":"_xlfn.CONCAT(D9:D23)","v":"GEO-JSP"}]
["Your system description:",{"$f":"_xlfn.CONCAT(E9:E23)","v":"Geode-JSP Rugged System, "},null,null,null,{"$f":"SUM(F9:F27)","v":1035},null,{"$f":"SUM(H9:H27)","v":2588},"Calculated price"]
[null,null,null,null,null,"BOM cost",null,1500,"Bonus"]
[null,null,null,null,null,null,null,{"$f":"H29+H28","v":4088},"Qty 1 price"]
[null,null,null,null,null,null,null,{"$f":"H30-F28","v":3053},"Margin $"]
[null,null,null,null,null,null,null,{"$f":"H31/H30","v":0.74681996086105673},"Margin %"]

{"sheet":"Options","index":1,"n_rows":7,"n_cols":39,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Carrier","Carrier","Carrier","Carrier","Carrier","Carrier","COM","COM","COM","COM","COM","COM","Panel","Panel","Panel","Panel","Panel","Panel","Power","Power","Power","Power","Power","Power","SSD","SSD","SSD","SSD","SSD","SSD","OS","OS","OS","OS","OS","OS","Expansion","Expansion","Expansion"]
["Choose one:","","",null,null,null,"Choose one:","","",null,null,null,"Choose one:","","",null,null,null,"Choose one:","","",null,null,null,"Choose one:","","",null,null,null,"Choose one:","","",null,null,null,"Choose one:","",""]
["*With DIO (baseboard JSP-BB02D)","02D","",400,0.55000000000000004,{"$f":"ROUND(D3/(1-E3),0)","v":889},"*i7-1185GRE 32G","-1185-32","1185GRE CPU, 32GB RAM, ",1391,0.4,{"$f":"ROUND(J3/(1-K3),0)","v":2318},"*Expandable","-E","Expandable I/O, ",1527,0.5,{"$f":"ROUND(P3/(1-Q3),0)","v":3054},"*MIL with isolation","J","MIL Iso Power 24V Out, ",964,0.5,{"$f":"ROUND(V3/(1-W3),0)","v":1928},"*1TB","1","1TB SSD, ",135,0.45,{"$f":"ROUND(AB3/(1-AC3),0)","v":245},"*Linux 64-bit","-LNX","Linux",75,0.45,{"$f":"ROUND(AH3/(1-AI3),0)","v":136},"*My system has no additional I/O requirements","-01",""]
["With DAQ (baseboard JSP-BB03A)","03A","DAQ, ",550,0.55000000000000004,{"$f":"ROUND(D4/(1-E4),0)","v":1222},"i7-1365URE 32G","-1365-32","1365 CPU, 32GB RAM, ",1388,0.45,2524,"Fixed","-F","Fixed I/O, ",1138,0.5,2276,"MIL without isolation","N","MIL Power 24V Out, ",648,0.5,{"$f":"ROUND(V4/(1-W4),0)","v":1296},"2TB","2","2TB SSD, ",237,0.45,{"$f":"ROUND(AB4/(1-AC4),0)","v":431},"Windows 10 64-bit","-W10","Windows 10",{"$f":"139+AH3","v":214},0.45,{"$f":"ROUND(AH4/(1-AI4),0)","v":389},"My system requires additional I/O (list below)","-XX (requires factory review)"," (requires factory review)"]
[null,null,null,null,null,null,"i7-1365URE 64G","-1365-64","1365 CPU, 64GB RAM, ",1508,0.45,2742,null,null,null,null,null,null,"None","X","",0,0.5,{"$f":"ROUND(V5/(1-W5),0)","v":0},"512GB","5","512GB SSD, ",76,0.45,138]
[null,null,null,null,null,null,"i7-11865MRE 32E","-11865-32E","11865MRE CPU, 32GB ECC RAM, ",1501,0.45,2729,null,null,null,null,null,null,null,null,null,null,null,null,"128GB","8","128GB SD, ",30,0.45,55]
[null,null,null,null,null,null,"i7-1185G7E-64","-1185G7E-64","1185G7E CPU, 64GB RAM, ",1043,0.45,1896]