Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <p>
- <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}-->
- </style>
- </p>
- <table border="1" cellpadding="0" cellspacing="0" dir="ltr" style="table-layout: fixed; font-family: arial, sans, sans-serif; border-collapse: collapse; border: 1px solid rgb(204, 204, 204);">
- <colgroup>
- <col width="163" />
- <col width="360" />
- </colgroup>
- <tbody>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-value="{"1":2,"2":"Specification Overview"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; background-color: rgb(252, 229, 205); border-color: rgb(0, 0, 0); font-size: 180%; font-weight: bold;">Specification Overview</td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);"> </td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-value="{"1":2,"2":"Cosmetic Condition & Functionality"}" rowspan="1" style="padding: 2px 3px; background-color: rgb(252, 229, 205); border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-size: 100%; font-weight: bold; vertical-align: bottom;">Cosmetic Condition & Functionality</td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-value="{"1":2,"2":"Used\nGood cosmetic condition, average signs of use."}" rowspan="1" style="padding: 2px 3px; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-size: 100%; word-wrap: break-word; vertical-align: bottom;">Used<br />
- Good cosmetic condition, average signs of use.</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Condition"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); color: rgb(0, 0, 0);">Condition</td>
- <td data-sheets-value="{"1":2,"2":"Pre-owned"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">Pre-owned</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Brand"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Brand</td>
- <td data-sheets-formula="=VLOOKUP(R[0]C[1],'Paste Report Here'!C[1]:C[2],2,0)" data-sheets-value="{"1":2,"2":"Dell Inc."}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">Dell Inc.</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Series / Model"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Series / Model</td>
- <td data-sheets-formula="=VLOOKUP(R[0]C[1],'Paste Report Here'!C[1]:C[2],2,0)" data-sheets-value="{"1":2,"2":"OptiPlex 9020"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">OptiPlex 9020</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Operation System"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Operation System</td>
- <td data-sheets-formula="=VLOOKUP(R[0]C[1],'Paste Report Here'!C[1]:C[2],2,0)" data-sheets-value="{"1":2,"2":"Microsoft Windows 10 Home (64-bit)"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">Microsoft Windows 10 Home (64-bit)</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"CPU"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">CPU</td>
- <td data-sheets-formula="=VLOOKUP("*"&R[0]C3&"*",'Paste Report Here'!C[0]:C[0],1,0)" data-sheets-value="{"1":2,"2":"Intel(R) Core(TM) i5-4570 CPU @ 3.20GHz (CPU:0)"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); font-size: 100%;">Intel(R) Core(TM) i5-4570 CPU @ 3.20GHz (CPU:0)</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Hard Drive"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Hard Drive</td>
- <td data-sheets-formula="=VLOOKUP(R[0]C[1],'Paste Report Here'!C[1]:C[2],2,0)" data-sheets-value="{"1":2,"2":"500 GB"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">500 GB</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Memory"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Memory</td>
- <td data-sheets-formula="=VLOOKUP(R[0]C[1],'Paste Report Here'!C[1]:C[2],2,0)" data-sheets-value="{"1":2,"2":"8.00 GB"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">8.00 GB</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Warranty"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Warranty</td>
- <td data-sheets-value="{"1":2,"2":"90 Days"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">90 Days</td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-value="{"1":2,"2":"What's Included"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; background-color: rgb(252, 229, 205); border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-size: 180%; font-weight: bold; color: rgb(0, 0, 0);">What's Included</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Keyboard & Mouse"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Keyboard & Mouse</td>
- <td data-sheets-value="{"1":2,"2":"No"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">No</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Screen"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Screen</td>
- <td data-sheets-value="{"1":2,"2":"No"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">No</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Power Cord"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Power Cord</td>
- <td data-sheets-value="{"1":2,"2":"Yes"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">Yes</td>
- </tr>
- <tr style="height:21px;">
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-value="{"1":2,"2":"Detailed\u00a0Specifications"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; background-color: rgb(252, 229, 205); border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-size: 180%; font-weight: bold; color: rgb(0, 0, 0);">Detailed Specifications</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Brand"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Brand</td>
- <td data-sheets-formula="=R[-15]C[0]" data-sheets-value="{"1":2,"2":"Dell Inc."}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">Dell Inc.</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Series & Model"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Series & Model</td>
- <td data-sheets-formula="=R[-15]C[0]" data-sheets-value="{"1":2,"2":"OptiPlex 9020"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">OptiPlex 9020</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Serial Number"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Serial Number</td>
- <td data-sheets-formula="=VLOOKUP(R[0]C[1],'Paste Report Here'!C[1]:C[2],2,0)" data-sheets-value="{"1":2,"2":"1R6RK02"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">1R6RK02</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Original Retail Box"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Original Retail Box</td>
- <td data-sheets-value="{"1":2,"2":"No"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">No</td>
- </tr>
- <tr style="height:21px;">
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-value="{"1":2,"2":"WebCam"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; background-color: rgb(252, 229, 205); border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-weight: bold;">WebCam</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Built In WebCam"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Built In WebCam</td>
- <td data-sheets-value="{"1":2,"2":"No"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">No</td>
- </tr>
- <tr style="height:21px;">
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-value="{"1":2,"2":"Software"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; background-color: rgb(252, 229, 205); border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-weight: bold;">Software</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Operating System"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Operating System</td>
- <td data-sheets-formula="=R[-20]C[0]" data-sheets-value="{"1":2,"2":"Microsoft Windows 10 Home (64-bit)"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">Microsoft Windows 10 Home (64-bit)</td>
- </tr>
- <tr style="height:21px;">
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-value="{"1":2,"2":"CPU\u00a0"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; background-color: rgb(252, 229, 205); border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-size: 100%; font-weight: bold;">CPU </td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"CPU Type"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">CPU Type</td>
- <td data-sheets-formula="=VLOOKUP("*"&R[0]C3&"*",'Paste Report Here'!C[0]:C[0],1,0)" data-sheets-value="{"1":2,"2":"Intel(R) Core(TM) i5-4570 CPU @ 3.20GHz (CPU:0)"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); font-size: 100%;">Intel(R) Core(TM) i5-4570 CPU @ 3.20GHz (CPU:0)</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"CPU Speed"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">CPU Speed</td>
- <td data-sheets-formula="=VLOOKUP(R[0]C[1],'Paste Report Here'!C[1]:C[2],2,0)" data-sheets-value="{"1":2,"2":"3.20 GHz"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">3.20 GHz</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Number Of Cores"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Number Of Cores</td>
- <td data-sheets-formula="=VLOOKUP(R[0]C[1],'Paste Report Here'!C[1]:C[2],2,0)" data-sheets-value="{"1":3,"3":4}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">4</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Bus Speed"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Bus Speed</td>
- <td data-sheets-formula="=VLOOKUP(R[0]C[1],'Paste Report Here'!C[1]:C[2],2,0)" data-sheets-value="{"1":2,"2":"99.77 MHz"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">99.77 MHz</td>
- </tr>
- <tr style="height:21px;">
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-value="{"1":2,"2":"Storage"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; background-color: rgb(252, 229, 205); border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-weight: bold;">Storage</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Hard Drive Type"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Hard Drive Type</td>
- <td data-sheets-value="{"1":2,"2":"HDD"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">HDD</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Hard Drive Model"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Hard Drive Model</td>
- <td data-sheets-formula="=VLOOKUP(R[0]C[1],'Paste Report Here'!C[1]:C[2],2,0)" data-sheets-value="{"1":2,"2":"ST500DM002-1BD142"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">ST500DM002-1BD142</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Hard Drive Size"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Hard Drive Size</td>
- <td data-sheets-formula="=R[-29]C[0]" data-sheets-value="{"1":2,"2":"500 GB"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">500 GB</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Hard Drive RPM"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Hard Drive RPM</td>
- <td data-sheets-formula="=VLOOKUP(R[0]C[1],'Paste Report Here'!C[1]:C[2],2,0)" data-sheets-numberformat="{"1":8,"2":"0.00E+00","3":1}" data-sheets-value="{"1":2,"2":"7200 RPM"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">7200 RPM</td>
- </tr>
- <tr style="height:21px;">
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-value="{"1":2,"2":"Memory"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; background-color: rgb(252, 229, 205); border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-weight: bold;">Memory</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Memory Size"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Memory Size</td>
- <td data-sheets-formula="=R[-32]C[0]" data-sheets-value="{"1":2,"2":"8.00 GB"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">8.00 GB</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"# Of Memory Chips"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);"># Of Memory Chips</td>
- <td data-sheets-formula="=VLOOKUP(R[0]C[1],'Paste Report Here'!C[1]:C[2],2,0)" data-sheets-value="{"1":3,"3":2}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">2</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Memory Type"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Memory Type</td>
- <td data-sheets-formula="=VLOOKUP(R[0]C[1],'Paste Report Here'!C[1]:C[2],2,0)" data-sheets-value="{"1":2,"2":"DDR3 (1600 MHz)"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">DDR3 (1600 MHz)</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Max Memory Supported"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Max Memory Supported</td>
- <td data-sheets-formula="=VLOOKUP(R[0]C[1],'Paste Report Here'!C[1]:C[2],2,0)" data-sheets-value="{"1":2,"2":"32.00 GB"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">32.00 GB</td>
- </tr>
- <tr style="height:21px;">
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-value="{"1":2,"2":"Graphics"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; background-color: rgb(252, 229, 205); border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-weight: bold;">Graphics</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Graphics Card Type"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Graphics Card Type</td>
- <td data-sheets-value="{"1":2,"2":"Integrated"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">Integrated</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Video Card"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Video Card</td>
- <td data-sheets-formula="=VLOOKUP(R[0]C[1],'Paste Report Here'!C[1]:C[2],2,0)" data-sheets-value="{"1":2,"2":"AMD Radeon Graphics Processor (0x6771)"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">AMD Radeon Graphics Processor (0x6771)</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Video Memory"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Video Memory</td>
- <td data-sheets-value="{"1":2,"2":"1024MB"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">1024MB</td>
- </tr>
- <tr style="height:21px;">
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-value="{"1":2,"2":"Wireless/Networking"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; background-color: rgb(252, 229, 205); border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-weight: bold; color: rgb(0, 0, 0);">Wireless/Networking</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Wireless"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Wireless</td>
- <td data-sheets-value="{"1":2,"2":"No"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); font-size: 110%;">No</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Ethernet LAN"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Ethernet LAN</td>
- <td data-sheets-formula="=IFERROR(VLOOKUP("*"&R[0]C3&"*",'Paste Report Here'!C[0]:C[0],1,0), VLOOKUP("*"&R[0]C4&"*",'Paste Report Here'!C[0]:C[0],1,0))" data-sheets-value="{"1":2,"2":"Intel(R) Ethernet Connection I217-LM"}" style="padding: 2px 3px; vertical-align: bottom; font-size: 110%; border-bottom-color: rgb(0, 0, 0);">Intel(R) Ethernet Connection I217-LM</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Bluetooth"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Bluetooth</td>
- <td data-sheets-value="{"1":2,"2":"No"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); font-size: 110%;">No</td>
- </tr>
- <tr style="height:21px;">
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-value="{"1":2,"2":"Optical Drive"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; background-color: rgb(252, 229, 205); border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-weight: bold; color: rgb(0, 0, 0);">Optical Drive</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Drive Type:"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Drive Type:</td>
- <td data-sheets-formula="=IFERROR(VLOOKUP("*"&R[0]C3&"*",'Paste Report Here'!C[0]:C[0],1,0), VLOOKUP("*"&R[0]C4&"*",'Paste Report Here'!C[0]:C[0],1,0))" data-sheets-value="{"1":2,"2":"HL-DT-ST DVD+-RW GTA0N"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">HL-DT-ST DVD+-RW GTA0N</td>
- </tr>
- <tr style="height:21px;">
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-value="{"1":2,"2":"Ports"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; background-color: rgb(252, 229, 205); border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-weight: bold; color: rgb(0, 0, 0);">Ports</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Number of USB"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Number of USB</td>
- <td data-sheets-value="{"1":3,"3":10}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">10</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"USB 3.0"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">USB 3.0</td>
- <td data-sheets-value="{"1":2,"2":"Yes"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">Yes</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"HDMI"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">HDMI</td>
- <td data-sheets-value="{"1":2,"2":"No"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">No</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"eSata"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">eSata</td>
- <td data-sheets-value="{"1":2,"2":"No"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">No</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Firewire"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">Firewire</td>
- <td data-sheets-value="{"1":2,"2":"No"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">No</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"SD Card Reader"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">SD Card Reader</td>
- <td data-sheets-value="{"1":2,"2":"No"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">No</td>
- </tr>
- <tr style="height:21px;">
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Warranty"}" style="padding: 2px 3px; vertical-align: bottom; background-color: rgb(252, 229, 205); border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-weight: bold;">Warranty</td>
- <td data-sheets-formula="=R[-63]C[0]" data-sheets-value="{"1":2,"2":"90 Days"}" style="padding: 2px 3px; vertical-align: bottom; background-color: rgb(252, 229, 205); border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0);">90 Days</td>
- </tr>
- <tr style="height:21px;">
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- <td style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0);"> </td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Inventory #"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-size: 80%;">Inventory #</td>
- <td data-sheets-value="{"1":3,"3":101146}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); font-size: 100%;">101146</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"TI#\u00a0"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-size: 80%;">TI# </td>
- <td data-sheets-value="{"1":3,"3":175}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); font-size: 100%;">175</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Tech:"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-size: 80%;">Tech:</td>
- <td data-sheets-value="{"1":2,"2":"Raymond"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); font-size: 100%;">Raymond</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Date:"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-size: 80%;">Date:</td>
- <td data-sheets-numberformat="[null,1]" data-sheets-value="{"1":2,"2":"12/1/16"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); font-size: 100%;">12/1/16</td>
- </tr>
- <tr style="height:21px;">
- <td data-sheets-value="{"1":2,"2":"Buyer"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-size: 80%;">Buyer</td>
- <td data-sheets-value="{"1":2,"2":"Erik"}" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); font-size: 100%;">Erik</td>
- </tr>
- <tr style="height:21px;">
- <td style="padding:2px 3px 2px 3px;vertical-align:bottom;"> </td>
- <td style="padding:2px 3px 2px 3px;vertical-align:bottom;"> </td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-value="{"1":2,"2":"*Serial \u00a0 \u00a0 *Store# \u00a0 \u00a0*Tech \u00a0 *Cost \u00a0 \u00a0*Buyer \u00a0 *Date\u00a0"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom;">*Serial *Store# *Tech *Cost *Buyer *Date </td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-formula="="e13 pc*"&R[-80]C[1]&" "&R[-79]C[1]&" "&R[-55]C[1]&" "&R[-74]C[1]&" "&R[-73]C[1]&"*123456789*"&R[-63]C[1]&"*"&R[-7]C[1]&"*"&R[-5]C[1]&"*"&R[-6]C[1]&"*"&R[-3]C[1]&"*"&R[-4]C[1]&"*"&R[-72]C[1]&"*"" data-sheets-value="{"1":2,"2":"e13 pc*Dell Inc. OptiPlex 9020 500 GB 8.00 GB*123456789*1R6RK02*101146*Raymond*175*Erik*12/1/16*90 Days*"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; font-size: 110%; color: rgb(0, 128, 0); word-wrap: break-word;">e13 pc*Dell Inc. OptiPlex 9020 500 GB 8.00 GB*123456789*1R6RK02*101146*Raymond*175*Erik*12/1/16*90 Days*</td>
- </tr>
- <tr style="height:21px;">
- <td style="padding:2px 3px 2px 3px;vertical-align:bottom;"> </td>
- <td style="padding:2px 3px 2px 3px;vertical-align:bottom;"> </td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-value="{"1":2,"2":"Description:"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; border-bottom-color: rgb(0, 0, 0); font-weight: bold;">Description:</td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-formula="=R[-80]C[1]&" "&R[-83]C[1]&" "&R[-82]C[1]&" "" data-sheets-value="{"1":2,"2":" Dell Inc. OptiPlex 9020 "}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; font-family: Arial; font-size: 100%; border-bottom-color: rgb(0, 0, 0);">Dell Inc. OptiPlex 9020</td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-formula="=R[-79]C[1]" data-sheets-value="{"1":2,"2":"Intel(R) Core(TM) i5-4570 CPU @ 3.20GHz (CPU:0)"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); font-size: 100%;">Intel(R) Core(TM) i5-4570 CPU @ 3.20GHz (CPU:0)</td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-formula="=R[-81]C[1]" data-sheets-value="{"1":2,"2":"Microsoft Windows 10 Home (64-bit)"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; font-family: Arial; font-size: 100%;">Microsoft Windows 10 Home (64-bit)</td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-formula="=R[-80]C[1]&" HD, " &R[-79]C[1] &" Memory"" data-sheets-value="{"1":2,"2":"500 GB HD, 8.00 GB Memory"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; font-family: Arial; font-size: 100%; border-bottom-color: rgb(0, 0, 0);">500 GB HD, 8.00 GB Memory</td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-formula="=R[-35]C[1]" data-sheets-value="{"1":2,"2":"AMD Radeon Graphics Processor (0x6771)"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom; border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0);">AMD Radeon Graphics Processor (0x6771)</td>
- </tr>
- <tr style="height:21px;">
- <td colspan="2" data-sheets-formula="=R[-80]C[1]" data-sheets-value="{"1":2,"2":"90 Days"}" rowspan="1" style="padding: 2px 3px; vertical-align: bottom;">90 Days</td>
- </tr>
- </tbody>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment