Register  |  Sign In
View unanswered posts | View active topics It is currently Thu Mar 28, 2024 11:07 am



Reply to topic  [ 63 posts ]  Go to page 1, 2, 3  Next
 Excel Spreadsheet to [Table] Tag Converter Tool 
Author Message
Post Excel Spreadsheet to [Table] Tag Converter Tool
As promised, I wrote a macro for excel to transform an Excel table to a BB Code table.

Here are the rough instructions:

1. Make sure that macros in Excel are enabled. To do that, start Excel, go to Tools->Macro->Security. If the Security level is on Medium, then you're good. If it's not, set it to Medium and exit Excel.
2. Download this file: http://www.worldofkj.com/downloads/Excel2BB.xls (Make sure to right click on it and select 'Save As...')
3. Open the file you just downloaded. You should now see a little toolbar with a button that says 'Excel2BB Converter'.
4. Open the Excel file that contains your table, select the entire table and click on the 'Excel2BB Converter' button. A message box should pop-up saying that the BBCode is in the clipboard. Hit OK.
5. Reply to this thread, hit Ctrl+V and hit preview. That should be your Excel table. Please post it in this thread so that I can see the program works.

Note: You set up backgrounds for all cells in Excel. Also, the macro will recognize text that's written in Bold and apply those settings here as well. The font color and size of your excel table are <strike>not yet supported, but will be soon.</strike> now supported as well!

If you have any problems, questions or suggestions, <strike>you can shove them (Eagle, enable the damn feature!)</strike> please reply in this thread.

Hope you all enjoy it.

EDIT: See this post for an example of a table converted from Excel to BBCode as well as a few issues that the program has right now.

Things to do:
  • <strike>Inheriting Excel formats for alignment, font and size.</strike>
  • <strike>Remove color numbers for default formatted cells.</strike>

EDIT2: If anyone wants to see the code for the program, PM me. You have to have a medium-level knowledge of VB and/or Excel Macros to understand what goes on there.


Last edited by Anonymous on Fri Jun 03, 2005 11:02 pm, edited 6 times in total.



Fri Jun 03, 2005 3:05 pm
Site Owner
User avatar

Joined: Wed Sep 15, 2004 1:09 pm
Posts: 14631
Location: Pittsburgh
Post 
Do they still have to wrap the code in the table tags or is that done automatically? If not, please include it in your faq.

_________________
Image


Fri Jun 03, 2005 3:16 pm
Profile WWW
Post 
Eagle wrote:
Do they still have to wrap the code in the table tags or is that done automatically? If not, please include it in your faq.

No, it's all automatic.


Fri Jun 03, 2005 3:19 pm
Teh Mexican
User avatar

Joined: Fri Oct 15, 2004 11:56 pm
Posts: 26066
Location: In good ol' Mexico
Post 
i dont get it!, what does this "macro" do?


Fri Jun 03, 2005 3:20 pm
Profile
Post 
Great work Krem, thanks a lot. Some small problems though.

It shows some more decimals than 2 what I had below in one example. Also, all the numbers were percentages. Plus, not sure why the first column is so wide...

Small things as I said, and thank you again for doing this.

EDIT: Sometimes I get runtime error '13', type mismatch, and not sure what prompted it.

[table][row color=#808080]Accuracy[col color=#808080]Overall[col color=#808080]Week 1[col color=#808080]Week 2[col color=#808080]Week 3[col color=#808080]Week 4[col color=#808080]Week 5[col color=#808080]Week 6[row color=#FFFFFF]Ragnarok[col color=#FFFFFF]0,868483333333333[col color=#FFFFFF]0,821[col color=#FFFFFF]0,8303[col color=#FFFFFF]0,907[col color=#FFFFFF]0,8828[col color=#FFFFFF]0,8851[col color=#FFFFFF]0,8847[row color=#FFFFFF]MikeQ.[col color=#FFFFFF]0,862466666666667[col color=#FFFFFF]0,8502[col color=#FFFFFF]0,8344[col color=#FFFFFF]0,8781[col color=#FFFFFF]0,864[col color=#FFFFFF]0,8761[col color=#FFFFFF]0,872[row color=#FFFFFF]Amos[col color=#FFFFFF]0,858666666666667[col color=#FFFFFF]0,7851[col color=#FFFFFF]0,8133[col color=#FFFFFF]0,8825[col color=#FFFFFF]0,8957[col color=#FFFFFF]0,8869[col color=#FFFFFF]0,8885[row color=#FFFFFF]xiayun[col color=#FFFFFF]0,855933333333333[col color=#FFFFFF]0,8302[col color=#FFFFFF]0,8456[col color=#FFFFFF]0,8419[col color=#FFFFFF]0,8489[col color=#FFFFFF]0,9205[col color=#FFFFFF]0,8485[row color=#FFFFFF]MG Casey[col color=#FFFFFF]0,85345[col color=#FFFFFF]0,8583[col color=#FFFFFF]0,814[col color=#FFFFFF]0,8222[col color=#FFFFFF]0,8894[col color=#FFFFFF]0,9016[col color=#FFFFFF]0,8352[row color=#FFFFFF]Andrew[col color=#FFFFFF]0,8527[col color=#FFFFFF]0,8484[col color=#FFFFFF]0,8376[col color=#FFFFFF]0,8135[col color=#FFFFFF]0,9064[col color=#FFFFFF]0,8724[col color=#FFFFFF]0,8379[row color=#FFFFFF]sako[col color=#FFFFFF]0,851016666666667[col color=#FFFFFF]0,8179[col color=#FFFFFF]0,8082[col color=#FFFFFF]0,8817[col color=#FFFFFF]0,8583[col color=#FFFFFF]0,8903[col color=#FFFFFF]0,8497[row color=#FFFFFF]Samweis Gamdschie[col color=#FFFFFF]0,850016666666667[col color=#FFFFFF]0,7229[col color=#FFFFFF]0,8212[col color=#FFFFFF]0,8921[col color=#FFFFFF]0,8929[col color=#FFFFFF]0,8925[col color=#FFFFFF]0,8785[row color=#FFFFFF]Dr. Lecter[col color=#FFFFFF]0,84215[col color=#FFFFFF]0,7399[col color=#FFFFFF]0,8194[col color=#FFFFFF]0,8473[col color=#FFFFFF]0,924[col color=#FFFFFF]0,8835[col color=#FFFFFF]0,8388[row color=#FFFFFF]MAD MAX[col color=#FFFFFF]0,84195[col color=#FFFFFF]0,7716[col color=#FFFFFF]0,8295[col color=#FFFFFF]0,8615[col color=#FFFFFF]0,8432[col color=#FFFFFF]0,8624[col color=#FFFFFF]0,8835[row color=#FFFFFF]matatonio[col color=#FFFFFF]0,84035[col color=#FFFFFF]0,755[col color=#FFFFFF]0,8329[col color=#FFFFFF]0,8405[col color=#FFFFFF]0,881[col color=#FFFFFF]0,8627[col color=#FFFFFF]0,87[row color=#FFFFFF]Emmy's wdw04[col color=#FFFFFF]0,837516666666667[col color=#FFFFFF]0,7025[col color=#FFFFFF]0,8248[col color=#FFFFFF]0,8693[col color=#FFFFFF]0,8814[col color=#FFFFFF]0,8958[col color=#FFFFFF]0,8513[row color=#FFFFFF]OSHO[col color=#FFFFFF]0,83675[col color=#FFFFFF]0,7309[col color=#FFFFFF]0,8291[col color=#FFFFFF]0,8547[col color=#FFFFFF]0,8462[col color=#FFFFFF]0,8914[col color=#FFFFFF]0,8682[row color=#FFFFFF]Korrgan[col color=#FFFFFF]0,836366666666667[col color=#FFFFFF]0,7343[col color=#FFFFFF]0,8241[col color=#FFFFFF]0,8306[col color=#FFFFFF]0,8936[col color=#FFFFFF]0,8868[col color=#FFFFFF]0,8488[row color=#FFFFFF]Levy[col color=#FFFFFF]0,835283333333333[col color=#FFFFFF]0,7232[col color=#FFFFFF]0,8366[col color=#FFFFFF]0,8538[col color=#FFFFFF]0,8522[col color=#FFFFFF]0,8723[col color=#FFFFFF]0,8736[row color=#FFFFFF]Zingaling[col color=#FFFFFF]0,834366666666667[col color=#FFFFFF]0,7779[col color=#FFFFFF]0,841[col color=#FFFFFF]0,8307[col color=#FFFFFF]0,8375[col color=#FFFFFF]0,8614[col color=#FFFFFF]0,8577[row color=#FFFFFF]Jeff 42[col color=#FFFFFF]0,8339[col color=#FFFFFF]0,7016[col color=#FFFFFF]0,8437[col color=#FFFFFF]0,8623[col color=#FFFFFF]0,8758[col color=#FFFFFF]0,8823[col color=#FFFFFF]0,8377[row color=#FFFFFF]dar[col color=#FFFFFF]0,8272[col color=#FFFFFF]0,794[col color=#FFFFFF]0,8157[col color=#FFFFFF]0,8237[col color=#FFFFFF]0,846[col color=#FFFFFF]0,8473[col color=#FFFFFF]0,8365[row color=#FFFFFF]ChipMunky[col color=#FFFFFF]0,827166666666667[col color=#FFFFFF]0,7574[col color=#FFFFFF]0,8485[col color=#FFFFFF]0,8441[col color=#FFFFFF]0,756[col color=#FFFFFF]0,9172[col color=#FFFFFF]0,8398[row color=#FFFFFF]Nebs[col color=#FFFFFF]0,824733333333333[col color=#FFFFFF]0,7094[col color=#FFFFFF]0,818[col color=#FFFFFF]0,8595[col color=#FFFFFF]0,8582[col color=#FFFFFF]0,8759[col color=#FFFFFF]0,8274[row color=#FFFFFF]DP07[col color=#FFFFFF]0,82455[col color=#FFFFFF]0,7658[col color=#FFFFFF]0,8264[col color=#FFFFFF]0,795[col color=#FFFFFF]0,8732[col color=#FFFFFF]0,8644[col color=#FFFFFF]0,8225[row color=#FFFFFF]torrino[col color=#FFFFFF]0,824466666666667[col color=#FFFFFF]0,7156[col color=#FFFFFF]0,8064[col color=#FFFFFF]0,8667[col color=#FFFFFF]0,848[col color=#FFFFFF]0,8802[col color=#FFFFFF]0,8299[row color=#FFFFFF]Jason Ng[col color=#FFFFFF]0,823366666666667[col color=#FFFFFF]0,7474[col color=#FFFFFF]0,8477[col color=#FFFFFF]0,8231[col color=#FFFFFF]0,7993[col color=#FFFFFF]0,9157[col color=#FFFFFF]0,807[row color=#FFFFFF]LiteraTor[col color=#FFFFFF]0,8197[col color=#FFFFFF]0,7532[col color=#FFFFFF]0,8201[col color=#FFFFFF]0,8274[col color=#FFFFFF]0,8564[col color=#FFFFFF]0,8705[col color=#FFFFFF]0,7906[row color=#FFFFFF]Ciber[col color=#FFFFFF]0,819[col color=#FFFFFF]0,7003[col color=#FFFFFF]0,8244[col color=#FFFFFF]0,8247[col color=#FFFFFF]0,8669[col color=#FFFFFF]0,8413[col color=#FFFFFF]0,8564[row color=#FFFFFF]revolutions[col color=#FFFFFF]0,80335[col color=#FFFFFF]0,7352[col color=#FFFFFF]0,8125[col color=#FFFFFF]0,8234[col color=#FFFFFF]0,7749[col color=#FFFFFF]0,8114[col color=#FFFFFF]0,8627[row color=#FFFFFF]Rogue Commander[col color=#FFFFFF]0,787566666666667[col color=#FFFFFF]0,644[col color=#FFFFFF]0,813[col color=#FFFFFF]0,7478[col color=#FFFFFF]0,7561[col color=#FFFFFF]0,9177[col color=#FFFFFF]0,8468[row color=#FFFFFF]hans[col color=#FFFFFF]0,776833333333333[col color=#FFFFFF]0,6784[col color=#FFFFFF]0,7989[col color=#FFFFFF]0,8235[col color=#FFFFFF]0,6294[col color=#FFFFFF]0,8883[col color=#FFFFFF]0,8425[row]Excel2BB Converter. Created by Krem for World of KJ[/table]


Last edited by Anonymous on Fri Jun 03, 2005 3:27 pm, edited 1 time in total.



Fri Jun 03, 2005 3:22 pm
Site Owner
User avatar

Joined: Wed Sep 15, 2004 1:09 pm
Posts: 14631
Location: Pittsburgh
Post 
I believe an example of the spreadsheet in the first post would help greatly.

_________________
Image


Fri Jun 03, 2005 3:22 pm
Profile WWW
Post 
Thanks, Nebs.

I'll fix the formatting once I get home tonight. And the first column is too wide because of the shameless plug I put on the bottom. :oops:
I'll fix that as well.

matatonio, the macro converts the tables in Excel into tables in BBCode; that makes it much easier to post tables on the messageboards.


Fri Jun 03, 2005 3:25 pm
Post 
Error 13.. hmmm

Nebs, I'll talk to you online tonight and maybe we can track it down.


Fri Jun 03, 2005 3:29 pm
Post 
Krem wrote:
And the first column is too wide because of the shameless plug I put on the bottom.


Oops, missed that. So obvious now. :oops:

Btw, a favour if it can be done?

I noticed that mrow command alligns data in the center of the cell, any way to implement that? Though, also gives us annoying (if it's row after row after row ;)) yellow background.

Another slight problem. Sometimes when cells have just a single number, the program when pasting to forum puts them all in single cell. Might be my sheet that isn't arranged well though. Here it is if you're in mood to check it. http://free-zg.t-com.hr/nebuka/domint/DomIntStats.xls

[table][row color=#808080]Games Won[col color=#808080]Overall[col color=#808080]GWpw[col color=#808080]Week 1[col color=#808080]Week 2[col color=#808080]Week 3[col color=#808080]Week 4[col color=#808080]Week 5[col color=#808080]Week 6[row color=#FFFFFF]Andrew[col color=#FFFFFF]5[col color=#FFFFFF]0,833333333333333[col color=#FFFFFF]11110[col color=#FFFFFF]1[row color=#FFFFFF]Emmy's wdw04[col color=#FFFFFF]5[col color=#FFFFFF]0,833333333333333[col color=#FFFFFF]0[col color=#FFFFFF]11111[row color=#FFFFFF]MAD MAX[col color=#FFFFFF]5[col color=#FFFFFF]0,833333333333333[col color=#FFFFFF]110[col color=#FFFFFF]111[row color=#FFFFFF]Samweis Gamdschie[col color=#FFFFFF]5[col color=#FFFFFF]0,833333333333333[col color=#FFFFFF]10[col color=#FFFFFF]1111[row color=#FFFFFF]Amos[col color=#FFFFFF]4[col color=#FFFFFF]0,666666666666667[col color=#FFFFFF]0[col color=#FFFFFF]1110[col color=#FFFFFF]1[row color=#FFFFFF]Dr. Lecter[col color=#FFFFFF]4[col color=#FFFFFF]0,666666666666667[col color=#FFFFFF]0[col color=#FFFFFF]1110[col color=#FFFFFF]1[row color=#FFFFFF]Korrgan[col color=#FFFFFF]4[col color=#FFFFFF]0,666666666666667[col color=#FFFFFF]1[col color=#FFFFFF]1[col color=#FFFFFF]1[col color=#FFFFFF]1[col color=#FFFFFF]00[row color=#FFFFFF]matatonio[col color=#FFFFFF]4[col color=#FFFFFF]0,666666666666667[col color=#FFFFFF]10[col color=#FFFFFF]110[col color=#FFFFFF]1[row color=#FFFFFF]MikeQ.[col color=#FFFFFF]4[col color=#FFFFFF]0,666666666666667[col color=#FFFFFF]10[col color=#FFFFFF]0[col color=#FFFFFF]111[row color=#FFFFFF]Ragnarok[col color=#FFFFFF]4[col color=#FFFFFF]0,666666666666667[col color=#FFFFFF]10[col color=#FFFFFF]110[col color=#FFFFFF]1[row color=#FFFFFF]sako[col color=#FFFFFF]4[col color=#FFFFFF]0,666666666666667[col color=#FFFFFF]10[col color=#FFFFFF]10[col color=#FFFFFF]11[row color=#FFFFFF]Zingaling[col color=#FFFFFF]4[col color=#FFFFFF]0,666666666666667[col color=#FFFFFF]110[col color=#FFFFFF]10[col color=#FFFFFF]1[row color=#FFFFFF]Jason Ng[col color=#FFFFFF]3[col color=#FFFFFF]0,5[col color=#FFFFFF]1[col color=#FFFFFF]1[col color=#FFFFFF]001[col color=#FFFFFF]0[row color=#FFFFFF]Levy[col color=#FFFFFF]3[col color=#FFFFFF]0,5[col color=#FFFFFF]0[col color=#FFFFFF]10[col color=#FFFFFF]10[col color=#FFFFFF]1[row color=#FFFFFF]MG Casey[col color=#FFFFFF]3[col color=#FFFFFF]0,5[col color=#FFFFFF]1[col color=#FFFFFF]001[col color=#FFFFFF]1[col color=#FFFFFF]0[row color=#FFFFFF]torrino[col color=#FFFFFF]3[col color=#FFFFFF]0,5[col color=#FFFFFF]01[col color=#FFFFFF]1[col color=#FFFFFF]01[col color=#FFFFFF]0[row color=#FFFFFF]xiayun[col color=#FFFFFF]3[col color=#FFFFFF]0,5[col color=#FFFFFF]01[col color=#FFFFFF]1[col color=#FFFFFF]01[col color=#FFFFFF]0[row color=#FFFFFF]ChipMunky[col color=#FFFFFF]2[col color=#FFFFFF]0,333333333333333[col color=#FFFFFF]01[col color=#FFFFFF]001[col color=#FFFFFF]0[row color=#FFFFFF]DP07[col color=#FFFFFF]2[col color=#FFFFFF]0,333333333333333[col color=#FFFFFF]01[col color=#FFFFFF]001[col color=#FFFFFF]0[row color=#FFFFFF]hans[col color=#FFFFFF]2[col color=#FFFFFF]0,333333333333333[col color=#FFFFFF]1[col color=#FFFFFF]01[col color=#FFFFFF]000[row color=#FFFFFF]Jeff 42[col color=#FFFFFF]2[col color=#FFFFFF]0,333333333333333[col color=#FFFFFF]01[col color=#FFFFFF]001[col color=#FFFFFF]0[row color=#FFFFFF]LiteraTor[col color=#FFFFFF]2[col color=#FFFFFF]0,333333333333333[col color=#FFFFFF]001[col color=#FFFFFF]1[col color=#FFFFFF]00[row color=#FFFFFF]OSHO[col color=#FFFFFF]2[col color=#FFFFFF]0,333333333333333[col color=#FFFFFF]001[col color=#FFFFFF]01[col color=#FFFFFF]0[row color=#FFFFFF]revolutions[col color=#FFFFFF]2[col color=#FFFFFF]0,333333333333333[col color=#FFFFFF]10[col color=#FFFFFF]0[col color=#FFFFFF]0[col color=#FFFFFF]0[col color=#FFFFFF]1[row color=#FFFFFF]Ciber[col color=#FFFFFF]10,166666666666667[col color=#FFFFFF]0[col color=#FFFFFF]0[col color=#FFFFFF]0[col color=#FFFFFF]0[col color=#FFFFFF]0[col color=#FFFFFF]1[row color=#FFFFFF]dar[col color=#FFFFFF]1[col color=#FFFFFF]0,166666666666667[col color=#FFFFFF]1[col color=#FFFFFF]00000[row color=#FFFFFF]Rogue Commander[col color=#FFFFFF]1[col color=#FFFFFF]0,166666666666667[col color=#FFFFFF]00001[col color=#FFFFFF]0[row color=#FFFFFF]Nebs[col color=#FFFFFF]00000000[row]Excel2BB Converter. Created by Krem for World of KJ[/table]


Fri Jun 03, 2005 3:40 pm
Post 
Think I figured where that error 13 comes from. When I include empty excel row with full ones above and bellow.


Fri Jun 03, 2005 3:42 pm
Post 
Nebs, sure thing, I was planning on inheriting Excel formatting anyways, just haven't gotten around to it completely.

As for the other thing, that's very interesting. I'll check it out once I get home tonight. Looks like a bug in the program but I can't pinpoint it yet.

EDIT: One more thing that I will change is that if the cell formatting is default (white background, black font, etc.) then the colors won't get parsed into the BBCode, and that will make the code for the tables smaller in size and easier to read.


Fri Jun 03, 2005 3:48 pm
---------
User avatar

Joined: Tue Oct 12, 2004 10:42 pm
Posts: 11808
Location: Kansas City, Kansas
Post 
*sigh* I only have Spreadsheet, not Excel. :mad:


Fri Jun 03, 2005 4:14 pm
Profile
Post 
What is Spreadsheet?

Nebs, I fixed the formatting issue and the issue with numbers being in one cell.


Last edited by Anonymous on Fri Jun 03, 2005 4:46 pm, edited 2 times in total.



Fri Jun 03, 2005 4:17 pm
Site Owner
User avatar

Joined: Wed Sep 15, 2004 1:09 pm
Posts: 14631
Location: Pittsburgh
Post 
done

_________________
Image


Fri Jun 03, 2005 4:20 pm
Profile WWW
---------
User avatar

Joined: Tue Oct 12, 2004 10:42 pm
Posts: 11808
Location: Kansas City, Kansas
Post 
Krem wrote:
What is Spreadsheet?

A very limited version of Excel. Not much capabilities. But it works.


Fri Jun 03, 2005 4:21 pm
Profile
Post 
Thank you, sir.


Fri Jun 03, 2005 4:21 pm
Post 
Omg!

Works beautifully. Patent and sell Krem! ;)

[table][row color=#FFFF00]Movie[col color=#FFFF00]Gross[col color=#FFFF00]From Thursday[col color=#FFFF00]From Last Thursday[col color=#FFFF00]PTA[col color=#FFFF00]Total[row color=#FFFFFF]Star Wars: Episode III - Revenge of the Sith[col color=#FFFFFF]$7.850.000[col color=#FFFFFF]101,11%[col color=#FFFFFF]-49,61%[col color=#FFFFFF]$2.151[col color=#FFFFFF]$290.654.625[row color=#FFFFFF]Madagascar[col color=#FFFFFF]$6.120.000[col color=#FFFFFF]67,95%[col color=#FFFFFF]-56,12%[col color=#FFFFFF]$1.478[col color=#FFFFFF]$78.387.556[row color=#FFFFFF]The Longest Yard[col color=#FFFFFF]$5.564.000[col color=#FFFFFF]61,34%[col color=#FFFFFF]-65,63%[col color=#FFFFFF]$1.531[col color=#FFFFFF]$75.268.254[row color=#C0C0C0]The Cinderella Man[col color=#C0C0C0]$5.485.000[col color=#C0C0C0]-[col color=#C0C0C0]-[col color=#C0C0C0]$1.951[col color=#C0C0C0]$5.485.000[row color=#C0C0C0]The Sisterhood of the Traveling Pants[col color=#C0C0C0]$2.850.000[col color=#C0C0C0]77,42%[col color=#C0C0C0]-[col color=#C0C0C0]$1.103[col color=#C0C0C0]$6.591.809[row color=#FFFFFF]Monster-In-Law[col color=#FFFFFF]$1.750.000[col color=#FFFFFF]102,08%[col color=#FFFFFF]-41,47%[col color=#FFFFFF]$579[col color=#FFFFFF]$66.835.972[row color=#C0C0C0]Lords of Dogtown[col color=#C0C0C0]$1.564.000[col color=#C0C0C0]-[col color=#C0C0C0]-[col color=#C0C0C0]$839[col color=#C0C0C0]$1.564.000[row color=#FFFFFF]Crash[col color=#FFFFFF]$831.000[col color=#FFFFFF]70,49%[col color=#FFFFFF]-34,85%[col color=#FFFFFF]$630[col color=#FFFFFF]$38.496.620[row color=#FFFFFF]Kicking & Screaming[col color=#FFFFFF]$820.000[col color=#FFFFFF]91,95%[col color=#FFFFFF]-42,40%[col color=#FFFFFF]$447[col color=#FFFFFF]$46.229.390[row color=#FFFFFF]The Interpreter[col color=#FFFFFF]$289.000[col color=#FFFFFF]134,47%[col color=#FFFFFF]-41,93%[col color=#FFFFFF]$420[col color=#FFFFFF]$69.895.605[row color=#FFFFFF]Unleashed[col color=#FFFFFF]$202.000[col color=#FFFFFF]0,00%[col color=#FFFFFF]-60,70%[col color=#FFFFFF]$351[col color=#FFFFFF]$22.916.006[/table]Excel2BB Converter. Created by Krem for World of KJ


If you implement font color recognition, and perhaps aligning to middle...to me it would be perfect. Now it's just frikkin brilliant. :razz:





Btw, those predictions for friday are as close to the truth as possible.


Last edited by Anonymous on Fri Jun 03, 2005 4:56 pm, edited 1 time in total.



Fri Jun 03, 2005 4:38 pm
College Boy Z

Joined: Mon Oct 11, 2004 8:40 pm
Posts: 36662
Post 
[table][row color=#969696]Movie (May 27th)[col color=#969696]Actuals[col color=#969696]Prediction[col color=#969696]Percentage[row color=#FFFFFF][col color=#FFFFFF][col color=#FFFFFF][col color=#FFFFFF][row color=#FFFFFF]Madagascar[col color=#FFFFFF]$61.00[col color=#FFFFFF]$66.60 [col color=#FFFFFF]90.82%[row color=#FFFFFF]The Longest Yard[col color=#FFFFFF]$60.00[col color=#FFFFFF]$50.40 [col color=#FFFFFF]84.00%[row color=#FFFFFF]Star Wars: Episode III[col color=#FFFFFF]$70.80[col color=#FFFFFF]$76.40 [col color=#FFFFFF]92.09%[row color=#FFFFFF]Monster-in-Law[col color=#FFFFFF]$11.80[col color=#FFFFFF]$12.70 [col color=#FFFFFF]92.37%[row color=#FFFFFF]Kicking and Screaming[col color=#FFFFFF]$6.60[col color=#FFFFFF]$8.30 [col color=#FFFFFF]74.24%[row color=#FFFFFF]Crash[col color=#FFFFFF]$6.00[col color=#FFFFFF]$5.10 [col color=#FFFFFF]85.00%[row color=#FFFFFF]Unleashed[col color=#FFFFFF]$2.30[col color=#FFFFFF]$2.60 [col color=#FFFFFF]86.96%[row color=#FFFFFF]Kingdom of Heaven[col color=#FFFFFF]$2.20[col color=#FFFFFF]$1.50 [col color=#FFFFFF]68.18%[row color=#FFFFFF]House of Wax[col color=#FFFFFF]$1.60[col color=#FFFFFF]$1.50 [col color=#FFFFFF]93.75%[row color=#FFFFFF]The Interpreter[col color=#FFFFFF]$2.60[col color=#FFFFFF]$2.00 [col color=#FFFFFF]76.92%[row color=#FFFFFF][col color=#FFFFFF][col color=#FFFFFF][col color=#FFFFFF][row color=#FFFFFF][col color=#FFFFFF][col color=#FFFFFF][col color=#FFFFFF]84.43%[/table][table][row][/table]


Last edited by zingy on Fri Jun 03, 2005 4:52 pm, edited 1 time in total.



Fri Jun 03, 2005 4:45 pm
Profile
College Boy Z

Joined: Mon Oct 11, 2004 8:40 pm
Posts: 36662
Post 
Krem, how come that bottom part with "Excel2BB Converter" and stuff is shifted to the side?


Fri Jun 03, 2005 4:49 pm
Profile
Site Owner
User avatar

Joined: Wed Sep 15, 2004 1:09 pm
Posts: 14631
Location: Pittsburgh
Post 
because it wasn't incorporated into a table tag

_________________
Image


Fri Jun 03, 2005 4:49 pm
Profile WWW
Post 
There was yet another problem wit the file (my shameless plug was trying to create a row outside of the table :oops:). That's been fixed now. The file is here until Eagle uploads it: http://www.worldofkj.com/tools/Excel2BB.xls

Zing and Nebs - please go back and edit your posts to get rid of that last line, so that it doesn't screw up this thread. Thanks!


Fri Jun 03, 2005 4:51 pm
Post 
Eagle wrote:
because it wasn't incorporated into a table tag

No, because I screwed up in the code. Fixed now!


Fri Jun 03, 2005 4:51 pm
College Boy Z

Joined: Mon Oct 11, 2004 8:40 pm
Posts: 36662
Post 
[table][row color=#FFFFFF]Movie[col color=#FFFFFF]Actuals[col color=#FFFFFF]Prediction[col color=#FFFFFF]Accuracy[row color=#FFFFFF][col color=#FFFFFF][col color=#FFFFFF][col color=#FFFFFF][row color=#FFFFFF]Cinderella Man[col color=#FFFFFF]$28,100,000[col color=#FFFFFF]$26,700,000 [col color=#FFFFFF]95.02%[row color=#FFFFFF]Revenge of the Sith[col color=#FFFFFF]$24,100,000[col color=#FFFFFF]$26,300,000 [col color=#FFFFFF]90.87%[row color=#FFFFFF]Madagascar[col color=#FFFFFF]$27,400,000[col color=#FFFFFF]$24,500,000 [col color=#FFFFFF]89.42%[row color=#FFFFFF]The Longest Yard[col color=#FFFFFF]$22,100,000[col color=#FFFFFF]$22,400,000 [col color=#FFFFFF]98.64%[row color=#FFFFFF]Sisterhood of the Traveling Pants[col color=#FFFFFF]$10,200,000[col color=#FFFFFF]$12,500,000 [col color=#FFFFFF]77.45%[row color=#FFFFFF]Lords of Dogtown[col color=#FFFFFF]$6,800,000[col color=#FFFFFF]$8,400,000 [col color=#FFFFFF]76.47%[row color=#FFFFFF]Monster-in-Law[col color=#FFFFFF]$5,500,000[col color=#FFFFFF]$6,100,000 [col color=#FFFFFF]89.09%[row color=#FFFFFF]Crash[col color=#FFFFFF]$3,100,000[col color=#FFFFFF]$2,800,000 [col color=#FFFFFF]90.32%[row color=#FFFFFF]Kicking and Screaming[col color=#FFFFFF]$2,100,000[col color=#FFFFFF]$2,400,000 [col color=#FFFFFF]85.71%[row color=#FFFFFF]The Interpreter[col color=#FFFFFF]$800,000[col color=#FFFFFF]$1,200,000 [col color=#FFFFFF]50.00%[row color=#FFFFFF]Overall Accuracy[col color=#FFFFFF]---[col color=#FFFFFF]---[col color=#FFFFFF]84.30%[/table]

This is the same table I posted in the other thread, but this went through Excel and it's without color, which is not a problem.

Love it. :)


Fri Jun 03, 2005 5:06 pm
Profile
Post 
Zingaling wrote:

This is the same table I posted in the other thread, but this went through Excel and it's without color, which is not a problem.

Love it. :)


I'll add the colors and all the other fancy stuff later tonight.


Fri Jun 03, 2005 5:08 pm
College Boy Z

Joined: Mon Oct 11, 2004 8:40 pm
Posts: 36662
Post 
Krem wrote:
Zingaling wrote:

This is the same table I posted in the other thread, but this went through Excel and it's without color, which is not a problem.

Love it. :)


I'll add the colors and all the other fancy stuff later tonight.


Hehe, lots of cool stuff today! :D

I like it. Thanks, Krem!


Fri Jun 03, 2005 5:09 pm
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 63 posts ]  Go to page 1, 2, 3  Next

Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.