DA DICE Signature Campaign | [REPLACED by 2.0]

[tspacepilot]

Thanks LFC_Bitcoin.  And FWIW, I am happy, just was curious about how to interpret the numbers.  I hope I can remember this next time I forget it (or that they switch to +/- which is not-ambiguous, IMO).

Congratulations  . Ndnhc said to me that basically the reason for using number instead would be that using a (+/-) is not making the formula for the loyalty points to work and he cant figure it out whats wrong, so instead he stick with the number instead 

Google Spreadsheets doesn't recognize A+ as different from A.

That's interesting.  And it explains why you're using the numbers.  One follow up, do you need it to "recognize" the difference in order to do a sort?  I guess I'm wondering what you mean by "recognize".  Another solution might be "Aplus, A, Aminus", but since I don't know why you need the "recognition" I don't know if that helps

[LFC_Bitcoin]

When you get 100 loyalty points they get transferred to bitcoin, I've got 96 at the moment so I'll obviously reach 100 LP next Tuesday.
I have a question - what are 100 LP worth in bitcoin?
How does it work?

[ndnh]

Thanks LFC_Bitcoin.  And FWIW, I am happy, just was curious about how to interpret the numbers.  I hope I can remember this next time I forget it (or that they switch to +/- which is not-ambiguous, IMO).

Congratulations  . Ndnhc said to me that basically the reason for using number instead would be that using a (+/-) is not making the formula for the loyalty points to work and he cant figure it out whats wrong, so instead he stick with the number instead 

Google Spreadsheets doesn't recognize A+ as different from A.

That's interesting.  And it explains why you're using the numbers.  One follow up, do you need it to "recognize" the difference in order to do a sort?  I guess I'm wondering what you mean by "recognize".  Another solution might be "Aplus, A, Aminus", but since I don't know why you need the "recognition" I don't know if that helps

Sorry for not mentioning that. When you use vlookup function, I have 2 different values for A and A+, but it will give the same value for A and A+ which is the value assigned to A.
Vlookup in Google Spreadsheet (not in Excel. I learned in Excel, but Google Spreadsheet is more web and group friendly) recognizes A+ as just A.

The LP is auto entered once the post count and rating is entered. It shows wrong when I use A+. but with Aplus or A1 it works. Issue with symbols. probably identifies it as addition function? Dunno. But it doesn't work and that is the workaround I could find.
If you copy paste the same formmulae to Excel it will work as expected with +, plus or 1. Preferred 1,2,3 to plus,minus because it looked messy when I did that.

I am fine with that workaround. But can someone get a way to get hyperlink to an image?
You can use Insert -> Image to insert. Don't use that. Use =IMAGE("link here") to insert the image.
0.05BTC bounty on getting it done.

[ndnh]

When you get 100 loyalty points they get transferred to bitcoin, I've got 96 at the moment so I'll obviously reach 100 LP next Tuesday.
I have a question - what are 100 LP worth in bitcoin?
How does it work?

Add the current basic payment (i.e. excluding bonus) with previous 3 ones (in archives) * 0.2% * LP balance.

Suppose you have 0.1, 0.2, 0.1, 0.1. Total is 0.5. and you have 110 LP.

LP payout = 0.5 * 0.2% * 110 = 0.11BTC

One formula I used.
=0.002*G9*(E9+Archives!E74+Archives!E203+Archives!E356)

Hope it clears it up.

Cheers
ndnhc

P.S. Will check back tomorrow. Bye.

[LFC_Bitcoin]

When you get 100 loyalty points they get transferred to bitcoin, I've got 96 at the moment so I'll obviously reach 100 LP next Tuesday.
I have a question - what are 100 LP worth in bitcoin?
How does it work?

Add the current basic payment (i.e. excluding bonus) with previous 3 ones (in archives) * 0.2% * LP balance.

Suppose you have 0.1, 0.2, 0.1, 0.1. Total is 0.5. and you have 110 LP.

LP payout = 0.5 * 0.2% * 110 = 0.11BTC

One formula I used.
=0.002*G9*(E9+Archives!E74+Archives!E203+Archives!E356)

Hope it clears it up.

Cheers
ndnhc

P.S. Will check back tomorrow. Bye.

Yeah I understand but that formula would be beyond me 
You are a clever dude ndnhc, haha!
See you around tomorrow bro!

[tspacepilot]

I am fine with that workaround. But can someone get a way to get hyperlink to an image?
You can use Insert -> Image to insert. Don't use that. Use =IMAGE("link here") to insert the image.
0.05BTC bounty on getting it done.

I dunno, it seemed to work fine for me.  I typed

Code:

=IMAGE("https://bitcoin.org/img/icons/opengraph.png")

Into the cell A1 here:

https://docs.google.com/spreadsheets/d/1edVe4O7IYntcrPxbJWX9bYCFT5Mo8mYulqC_n5kH_3E/edit?usp=sharing

And I see the image in the cell.  Lol, I can't imagine that's worth a 0.05BTC bounty.  There must be something more ...  Maybe it's something about the particular image you're trying to include.

[panjul07]

Hi ndnhc...

Just wanna ask something, have the post count finished already?
I see there is a remark behind my name "5", does it mean that I'm deserving to get some bonus?
Because as I see, participants with remark number behind their name get some bonus. But when I see the payment tab, there is no bonus added to me?
Perhaps you did a typo.  

best regards,

Edit : PM'ed you already

[SebastianJu]

Thanks for payment... this time i got the second highest bonus for the first time. Nice...

[devthedev]

All held funds for the week of May 27th have been released from escrow.
TX ID: https://blockchain.info/tx/18a774e30db78e162b3968b639e64726e1b19691707cce0ae773a6fb4c002231

Let me know if anyone has any questions or comments.
It's a pleasure working with each of you.

[ndnh]

I am fine with that workaround. But can someone get a way to get hyperlink to an image?
You can use Insert -> Image to insert. Don't use that. Use =IMAGE("link here") to insert the image.
0.05BTC bounty on getting it done.

I dunno, it seemed to work fine for me.  I typed

Code:

=IMAGE("https://bitcoin.org/img/icons/opengraph.png")

Into the cell A1 here:

https://docs.google.com/spreadsheets/d/1edVe4O7IYntcrPxbJWX9bYCFT5Mo8mYulqC_n5kH_3E/edit?usp=sharing

And I see the image in the cell.  Lol, I can't imagine that's worth a 0.05BTC bounty.  There must be something more ...  Maybe it's something about the particular image you're trying to include.

No, lol. Add a link to the image, and I will give you the bounty.

[ndnh]

Welcome to Da Dice campaign 2.O

https://bitcointalk.org/index.php?topic=1078943.0

What's new?
+ New signature sets
+ Better spreadsheet
+ Monthly fixed rate campaign
+ More fun.

Just let me finish things up.


This thread will self destruct in a week.

[SyGambler]

Welcome to Da Dice campaign 2.O

https://bitcointalk.org/index.php?topic=1078943.0

What's new?
+ New signature sets
+ Better spreadsheet
+ Monthly fixed rate campaign
+ More fun.

Just let me finish things up.


This thread will self destruct in a week.

thanks for the payment
I'm waiting the good news mate 

[SebastianJu]

I think the new hero/legendary signature is broken since the ? are posted as smilies...

[TheGr33k]

I think the new hero/legendary signature is broken since the ? are posted as smilies...

I see tspacepilot's signature all fine. Will you mind adding signature once again?

[SebastianJu]

I think the new hero/legendary signature is broken since the ? are posted as smilies...

I see tspacepilot's signature all fine. Will you mind adding signature once again?

Oh, it seems copying these special signs into notepad2 changed them to "?". I wonder why that is. I would think it is suing UTF8 too. 

[tspacepilot]

I am fine with that workaround. But can someone get a way to get hyperlink to an image?
You can use Insert -> Image to insert. Don't use that. Use =IMAGE("link here") to insert the image.
0.05BTC bounty on getting it done.

I dunno, it seemed to work fine for me.  I typed

Code:

=IMAGE("https://bitcoin.org/img/icons/opengraph.png")

Into the cell A1 here:

https://docs.google.com/spreadsheets/d/1edVe4O7IYntcrPxbJWX9bYCFT5Mo8mYulqC_n5kH_3E/edit?usp=sharing

And I see the image in the cell.  Lol, I can't imagine that's worth a 0.05BTC bounty.  There must be something more ...  Maybe it's something about the particular image you're trying to include.

No, lol. Add a link to the image, and I will give you the bounty.

Don't you see it in cell A1? 

https://docs.google.com/spreadsheets/d/1edVe4O7IYntcrPxbJWX9bYCFT5Mo8mYulqC_n5kH_3E/edit?usp=sharing

I have this code in that cell:

Code:

=IMAGE("https://bitcoin.org/img/icons/opengraph.png")

Which is a link to this image:

https://bitcoin.org/img/icons/opengraph.png

You can add some additional params there as a second argument to scale the image.

[melody82]

Name: melody82
Position: Sr, member
Bitcoin Address: 1KA29PrGo8LXQYQnng5JSFYLgbpgNzL87H
Link to Recent posts: https://bitcointalk.org/index.php?action=profile;u=260314;sa=showPosts

and 339 posts.

Just posting this here for covienience and to check that my sig is set up correctly.

[xingming]

Name: xingming
Position: Sr.member
Bitcoin Address: 1JDzW2KCVQP9UPK6UFcDAApK84bkz7oBqT
Link to Recent posts: https://bitcointalk.org/index.php?topic=254871.msg11522026#msg11522026

- Xing Ming

[ndnh]

I am fine with that workaround. But can someone get a way to get hyperlink to an image?
You can use Insert -> Image to insert. Don't use that. Use =IMAGE("link here") to insert the image.
0.05BTC bounty on getting it done.

I dunno, it seemed to work fine for me.  I typed

Code:

=IMAGE("https://bitcoin.org/img/icons/opengraph.png")

Into the cell A1 here:

https://docs.google.com/spreadsheets/d/1edVe4O7IYntcrPxbJWX9bYCFT5Mo8mYulqC_n5kH_3E/edit?usp=sharing

And I see the image in the cell.  Lol, I can't imagine that's worth a 0.05BTC bounty.  There must be something more ...  Maybe it's something about the particular image you're trying to include.

No, lol. Add a link to the image, and I will give you the bounty.

Don't you see it in cell A1? 

https://docs.google.com/spreadsheets/d/1edVe4O7IYntcrPxbJWX9bYCFT5Mo8mYulqC_n5kH_3E/edit?usp=sharing

I have this code in that cell:

Code:

=IMAGE("https://bitcoin.org/img/icons/opengraph.png")

Which is a link to this image:

https://bitcoin.org/img/icons/opengraph.png

You can add some additional params there as a second argument to scale the image.

Bud, the question is, how to add hyperlink to an image.

Can you make it so that, when I click on the image I go to a, say Google?

Like this:


Now click on it and you will go to Google. I want that function.

It should have worked with HYPERLINK and IMAGE functions, but it didn't,

[ndnh]

Sorry, locking this thread. Post here to apply: https://bitcointalk.org/index.php?topic=1078943.0

Thanks