Weight Weenies
* FAQ    * Search    * Trending Topics
* Login   * Register
HOME Listings Blog NEW Galleries NEW FAQ Contact About
It is currently Sat May 28, 2016 5:42 pm
Recently the board software has been updated and there are some known bugs/failures:
- Avatars are currently not being displayed ✔ FIXED
- Tapatalk connection is currently broken ✔ FIXED

If you find more errors please post it here: http://weightweenies.starbike.com/forum/viewtopic.php?f=7&t=139062


All times are UTC+01:00





Post new topic  Reply to topic  [ 11 posts ] 
Author Message
 Post subject: Posting Build Lists
PostPosted: Mon Feb 15, 2016 10:37 pm 
Offline
User avatar

Joined: Sun Nov 07, 2010 9:14 pm
Posts: 2944
Hi, I've got a build list in Excel I'd like to post. Could any of you advise on the best and most efficient way to do this? I'm familiar with using the BB codes to get images from Flickr into a thread, but less (completely) certain about how to just post the formatted contents (minus forumulas etc) of an Excel spreadsheet into the post. Any help out there, versus typing everything in separately like I've kinda done in the past?
Thanks, Cal

_________________
C59 Five Years Later
My Special Colnago EPQ
Trek Emonda SL


Top
   
 Post subject: Re: Posting Build Lists
PostPosted: Mon Feb 15, 2016 10:44 pm 
Offline

Joined: Tue Aug 12, 2014 3:50 pm
Posts: 700
Location: FIN
If you use mac just make "grab" screenshot, then convert it to png/jpg at any image processing app . I'm sure for Win PC exist adequate software to do that... .

_________________
Go to Heaven for the climate, Hell for the company.
Mark Twain


I can be wrong, and have plenty of examples for that ;)


Top
   
 Post subject: Re: Posting Build Lists
PostPosted: Mon Feb 15, 2016 10:50 pm 
Offline

Joined: Tue Dec 15, 2015 10:45 pm
Posts: 47
stormur wrote:
If you use mac just make "grab" screenshot, then convert it to png/jpg at any image processing app . I'm sure for Win PC exist adequate software to do that... .


Exacto. With PC, you would press the "Print Screen" button (usually on right of the F1-F12 button range) then open Microsoft Paint (or equivalent) and paste. Select the portion of the Excel image that you wish to show and save as jpg. Alternatively you could download some very useful cutting software, for example:

http://www.softpedia.com/get/Multimedia ... tter.shtml


Top
   
 Post subject: Re: Posting Build Lists
PostPosted: Mon Feb 15, 2016 11:08 pm 
Offline
User avatar

Joined: Wed Oct 31, 2007 10:32 pm
Posts: 8187
Location: Los Angeles / Glendale, California
Code:
try entering        using the code tag
and it will        come out
like this        so long as your spacing     
is                  consistent

:lol:

Here's a better example using the [ code ] method:

Code:
Rear Derailleur          SRAM RED            98g
Front Derailleur          Tiso            55g

_________________
Exp001 || Other projects in the works.


Top
   
 Post subject: Re: Posting Build Lists
PostPosted: Mon Feb 15, 2016 11:11 pm 
Offline
User avatar

Joined: Sun Nov 07, 2010 9:14 pm
Posts: 2944
Yeah, that's the approach I was taking. But it didn't work. I'd use "Snip-it" to cut the relevant excel portion and try to paste it into Paint, then I was going to sac as a jpg and upload to Flickr. Hasn't been working. Numbers not coming through. Strange. I'll try again next time I'm at the computer.

_________________
C59 Five Years Later
My Special Colnago EPQ
Trek Emonda SL


Top
   
 Post subject: Re: Posting Build Lists
PostPosted: Mon Feb 15, 2016 11:14 pm 
Offline
User avatar

Joined: Sun Nov 07, 2010 9:14 pm
Posts: 2944
Ha, exactly... When I used the bbcodes the spacing is all wonky and a lot of editing is involved afterwards. Plus, if you're looking at it in Tapatalk or something then it's really unwieldy. Was hoping to just get a picture type format that you just "Open in Gallery" like a pic if you're in tapatalk.

_________________
C59 Five Years Later
My Special Colnago EPQ
Trek Emonda SL


Top
   
 Post subject: Re: Posting Build Lists
PostPosted: Tue Feb 16, 2016 2:59 am 
Offline

Joined: Fri Aug 15, 2014 4:17 am
Posts: 63
Location: Melbourne
Does this mean you're building a new bike? Hot damn! I love your builds, even though your bikes are so large I can't even fantasize about riding them 168cms and short-legged). And your build threads are always great reading; very articulate and informative.

_________________
Basso Diamante
viewtopic.php?f=10&t=131932
BMC SLR01
viewtopic.php?f=10&t=135171


Top
   
 Post subject: Re: Posting Build Lists
PostPosted: Tue Feb 16, 2016 6:20 am 
Offline

Joined: Tue Jan 17, 2012 4:01 pm
Posts: 639
Location: Downtown Los Angeles, CA
As Prend mentioned, the code option works, and IMO is preferred since it's indexable by Google and the search feature. From Excel, you can save it as a Fixed Width file (.prn) or if you're using LibreOffice Calc, save as a csv and choose fixed width. It'll put spaces in there to pad everything correctly. Open with a text editor, copy and then paste between the code tags, to get a result like this:

Code:
Deda Elementi                                   25
FSA Headset Bearings w/ cover                   55
THM M3 SRM                                     459
Chainring Bolts                                 10
Fibre-Lyte Compact Chainrings                   75
SRAM Red FD                                     75
Reynolds RZR 46T                               970
R5ca THM Fork w/ expander                      257
KCNC Ti Skewers                                 41
Extralite Top Cap                                3
R5ca 51cm Frame w/ BB Bearings                 727
Veloflex Carbon 23                             534
Vittoria Mastik                                 27
EeBrakes 2015 Models                           170
Enve Brake Pads                                 21
3T Doric Team Seatpost (Tuned)                 162
3T Bars                                        202
3T Arx Stem                                    129
Cervelo Seat Clamp                              12
Berk Saddle                                     94
SRAM Red 11-23 Cassete                         135
Speedplay Ti Zero                              172
SRAM Chain                                     229
SRAM Red Rear Derailleur                       149
SRAM Red 10sp Shifters                         282
Alligator I-Links                               97
Arundel Bottle Cages                            56
Bottle Cage Bolts                              2.8
K-Edge Garmin Mount                             36
Misc Unknown                                    20

_________________
Litespeed Siena: 6.21kg (retired)

Litespeed Xicon: 5.76kg (retired)

Cervelo R5ca: 5.09kg


Top
   
 Post subject: Posting Build Lists
PostPosted: Tue Feb 16, 2016 6:28 am 
Offline
User avatar

Joined: Sun Nov 07, 2010 9:14 pm
Posts: 2944
That result is awful, at least on my iPhone in Tapatalk. But no worries and thanks for responding to those who did. The jpg file works best I think. I figured it out. Not searchable of course but doesn't matter. At least with the "picture" of it you just open it up and scroll around. I just like it when it's easy to read instead of all jumbled up due to different line lengths on different devices (full screen computer vs teensy iphone screen etc).

@Tbrix: thanks for the kudos on my build threads. Hopefully in next day or two I'll post something. Nothing too shocking just a complete makeover on my C59. Nothing's the same except the frame.

_________________
C59 Five Years Later
My Special Colnago EPQ
Trek Emonda SL


Top
   
 Post subject: Re: Posting Build Lists
PostPosted: Tue Feb 16, 2016 6:48 am 
Offline

Joined: Tue Jan 17, 2012 4:01 pm
Posts: 639
Location: Downtown Los Angeles, CA
Ya, I just checked it on Tapatalk and I guess they completely disregard the code tag. It looks really nice on a computer screen though.

_________________
Litespeed Siena: 6.21kg (retired)

Litespeed Xicon: 5.76kg (retired)

Cervelo R5ca: 5.09kg


Top
   
 Post subject: Re: Posting Build Lists
PostPosted: Tue Feb 16, 2016 6:56 pm 
Offline

Joined: Sun Mar 02, 2014 6:36 pm
Posts: 323
Location: NY USA
How does my list look in Tapatalk?
viewtopic.php?f=10&t=137612

Mine is from Excel, then I just added the periods between weights and item to format it here on WW. I've only looked at it in the browser, and used the default font.

RyanH wrote:
.... is preferred since it's indexable by Google and the search feature......

I think this is very important, for Google and forum searches.

_________________
Trek Madone 7.9 58cm 14.9lbs


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 11 posts ] 

   Similar Topics   Author   Replies   Views   Last post 
There are no new unread posts for this topic. Velobuild r-077 new build

[ Go to page: 1 2 ]

in Introduce Yourself / Gallery - Please use metric weights.

sirmilesdavis

15

3500

Fri May 27, 2016 2:08 am

Vee View the latest post

There are no new unread posts for this topic. Which wheels for EVO build?

in Everything wheels

Lugnegard

3

376

Fri Feb 26, 2016 5:45 pm

kgt View the latest post

There are no new unread posts for this topic. Nostalgia WW Build

in MTB

drider85

6

1065

Tue Nov 24, 2015 2:09 pm

drider85 View the latest post

There are no new unread posts for this topic. Frankenbike Build

in Road

LiteAgilis

3

824

Wed Sep 09, 2015 7:03 am

FreaK View the latest post

There are no new unread posts for this topic. Advice on build please

in Road

lone wheeler

3

267

Mon Feb 01, 2016 10:20 pm

wheelsONfire View the latest post


All times are UTC+01:00


Who is online

Users browsing this forum: MSNbot Media and 7 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:  
Powered by phpBB® Forum Software © phpBB Limited