Spreadsheet

Hello,

how do I put a table into a post on my forum?

I am trying to put a spreadsheet in a post, but it is not working to well.

Hope you can help.

To insert a table press this button


Then insert the number of rows And columns in the pop up box then press enter.



To get a table like this:


The code will look like this:



If you give me a copy of the spreadsheet i would be happy to create the code for you and post the code here for you to use.

Thanks for the help.

How do I upload the spreadsheet to you?

Upload it to a site like Media share and then post the link it gives you after the upload.

Here's the link for the speadsheet

http://www.mediafire.com/view/?itr79tz2bbx2i5b

Do you need it matching the same way and are the numbers all in seconds or what. it would help to know that to have it better organized

It's for building a deathstar in ogame. The numbers are the resources you need to build it.

ok so the format needs to be kept exactly, then wow thats a lot more data then i thought it was you can upload it to google Docs and provide a link there for your users to view.

Code:

<table colspan="8" rowspan="45" cellspacing="0" cellpadding="1" align="left" style="border: 1px black solid; text-decoration: none !important;"><tr><td><b>Required Energy</b></td><td></td><td>300000</td><td></td><td><td><td>Planets</td><td>3</td><td></td></tr><tr><td>Solar Plant Energy</td><td></td><td>0</td><td></td><td></td><td><b>Deathstar</b></td><td>1</td><td></td></tr><tr><!-- and so on, until you're done with all 45 rows --></tr></table>

I could continue if you want me to, but that'd take some time lol

Thanks for that, Ultron. I can't get it to work when I am posting it on the forum. Do I have to put how many rows and how many lines down?

I can 't find where to paste the code into.

Basically, you have to enable HTML for it, then you just paste that into your post box
You will need 45 rows, I counted them.
If you give me some time (I got exams coming up soon), I can do it maybe this Saturday.

Yeah, that would be great. I really appreciate that

So, I attempted to make it and decided not to continue at row 4, I haven't got the nerves to do it today...

But I found a good tool that does so here, and this is the result I got, using your Excel spreadsheet:

Code:

<style type="text/css">
   table.tableizer-table {
   border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif;
   font-size: 12px;
}
.tableizer-table td {
   padding: 4px;
   margin: 3px;
   border: 1px solid #ccc;
}
.tableizer-table th {
   background-color: #104E8B;
   color: #FFF;
   font-weight: bold;
}
</style><table class="tableizer-table">
<tr class="tableizer-firstrow"><th>Required Energy</th><th> </th><th>300000</th><th> </th><th> </th><th>Planets</th><th>3</th><th> </th></tr>
 <tr><td>Solar Plant Energy</td><td> </td><td>0</td><td> </td><td> </td><td>Deathstar</td><td>1</td><td> </td></tr>
 <tr><td>Solar Satellite Energy</td><td> </td><td>33</td><td> </td><td> </td><td>Metal</td><td>5000000</td><td> </td></tr>
 <tr><td> </td><td> </td><td> </td><td> </td><td> </td><td>Crystal</td><td>4000000</td><td> </td></tr>
 <tr><td>Number of Solar Satallites</td><td> </td><td>9091</td><td> </td><td> </td><td>Deuterium</td><td>1000000</td><td> </td></tr>
 <tr><td>Solar Satellite build time</td><td> </td><td>11</td><td>seconds</td><td> </td><td>Time</td><td>24</td><td> </td></tr>
 <tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
 <tr><td>Production Time</td><td> </td><td> </td><td> </td><td> </td><td>Metal Mine</td><td>69444.44444444445</td><td> </td></tr>
 <tr><td>Time in Days</td><td>1.125</td><td> </td><td> </td><td> </td><td>Crystal Mine</td><td>55555.55555555555</td><td> </td></tr>
 <tr><td>Hours</td><td>27</td><td> </td><td> </td><td> </td><td>Deuterium Mine</td><td>13888.88888888889</td><td> </td></tr>
 <tr><td>Minutes</td><td>47</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
 <tr><td>Cost of Solar Satellite</td><td> </td><td> </td><td> </td><td> </td><td>Metal Mine level 29</td><td> </td><td> </td></tr>
 <tr><td>Crystal</td><td> </td><td>2000</td><td> </td><td> </td><td>Crystal Mine level 30</td><td> </td><td> </td></tr>
 <tr><td>Deuterium</td><td> </td><td>500</td><td> </td><td> </td><td>Deuterium level 25</td><td> </td><td> </td></tr>
 <tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
 <tr><td>Total Cost of Solar Satellites for Graviton Technology</td><td> </td><td> </td><td> </td><td> </td><td>Energy needed:</td><td> </td><td>15254</td></tr>
 <tr><td>Total Cost in Crystal</td><td> </td><td>18181819.00</td><td> </td><td> </td><td>Metal Mine level 29</td><td> </td><td>4601</td></tr>
 <tr><td>Total Cost in Deuterium</td><td> </td><td>4545455</td><td> </td><td> </td><td>Crystal Mine level 30</td><td> </td><td>5235</td></tr>
 <tr><td> </td><td> </td><td> </td><td> </td><td> </td><td>Deuterium level 25</td><td> </td><td>5418</td></tr>
 <tr><td>Total Cost of Research Lab level 12</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
 <tr><td>Total Cost in Metal</td><td> </td><td> </td><td>819000</td><td> </td><td>Power Plant lvl 33 needed for production</td><td> </td><td> </td></tr>
 <tr><td>Total Cost in Crystal</td><td> </td><td> </td><td>1638000</td><td> </td><td> </td><td> </td><td> </td></tr>
 <tr><td>Total Cost in Deuterium</td><td> </td><td> </td><td>819000</td><td> </td><td> </td><td> </td><td> </td></tr>
 <tr><td> </td><td> </td><td> </td><td> </td><td> </td><td>Planet spaces needed</td><td> </td><td> </td></tr>
 <tr><td>Transporters Needed For Movement of the Resources</td><td> </td><td> </td><td> </td><td> </td><td>Metal Mine</td><td> </td><td>29</td></tr>
 <tr><td>910</td><td> </td><td> </td><td> </td><td> </td><td>Crystal Mine</td><td> </td><td>30</td></tr>
 <tr><td> </td><td> </td><td> </td><td> </td><td> </td><td>Deuterium Mine</td><td> </td><td>26</td></tr>
 <tr><td>Cost of Transporter</td><td> </td><td> </td><td> </td><td> </td><td>Solar Plant</td><td> </td><td>34</td></tr>
 <tr><td>Metal</td><td>6000</td><td> </td><td> </td><td> </td><td>Metal Storage</td><td> </td><td>12</td></tr>
 <tr><td>Crystal</td><td>6000</td><td> </td><td> </td><td> </td><td>Crystal Storage</td><td> </td><td>12</td></tr>
 <tr><td> </td><td> </td><td> </td><td> </td><td> </td><td>Deuterium Storage</td><td> </td><td>10</td></tr>
 <tr><td>Transporters in Shipyard</td><td> </td><td> </td><td> </td><td> </td><td>Robotics Factory</td><td> </td><td>10</td></tr>
 <tr><td>300</td><td> </td><td> </td><td> </td><td> </td><td>Shipyard</td><td> </td><td>12</td></tr>
 <tr><td>Total Cost of Transporters</td><td> </td><td> </td><td> </td><td> </td><td>Research Center</td><td> </td><td>12</td></tr>
 <tr><td>Metal</td><td>3660000</td><td> </td><td> </td><td> </td><td>Nanite Factory</td><td> </td><td>4</td></tr>
 <tr><td>Crystal</td><td>3660000</td><td> </td><td> </td><td> </td><td>Total</td><td> </td><td>191</td></tr>
 <tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
 <tr><td>Total Cost</td><td> </td><td> </td><td> </td><td>                  Number of Spaces on planet</td><td> </td><td> </td><td>221</td></tr>
 <tr><td>Metal</td><td>4479000</td><td> </td><td> </td><td> </td><td>Number of Spaces Left:</td><td> </td><td>30</td></tr>
 <tr><td>Crystal</td><td>23479819</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
 <tr><td>Deuterium</td><td>5364455</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
 <tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
 <tr><td>Written by CreamCheese</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
 <tr><td>Creamest cheese ! Mmmmhhhh</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
 <tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td></td></tr>
</table>