Virgin Poker

Go Back   Stake A Shark - Poker Staking Forum > Stakeashark > StakeaShark Rules and Helpful Posts

Notices

Reply
 
Thread Tools Display Modes
Old 03-10-2009, 12:11 AM   #1
sax
Senior Member
 
sax's Avatar
 
Join Date: Jan 2008

Pokerstars: saxevest
Full_Tilt: Sax2007
RPM_Poker: SaSshark

Staker_Points: 1210.25
Player_Points: 1020.02

Posts: 14,901
Default BaP Spreadsheet - Walkthrough

This is a step-by-step guide on how to create a BaP Spreadsheet

Step 1)
Go to Google docs and create a FREE Account

Step 2)
Click this link to take you to the ready made Blank Spreadsheet


Step 3)
When creating a BaP you should go to Google docs and upload the Spreadsheet.

Step 4)
Click on File and Make a Copy, then rename the form.

Step 5)
Once uploaded you must select the Share option in the top right and select "Get the link to". Check the box that says "Allow anyone with the link to view (no sign-in required)"

Please Note: After Google Docs Upgrade the share option is now on the left hand side (Immediately to the right of your Spreadsheet Title) See Image below
Name:  image 1.JPG
Views: 420
Size:  29.4 KB

In the new pop up window select Change in the top right corner and you will see the following Image

Name:  image 2.JPG
Views: 423
Size:  30.2 KB

Check the Box that says "Public on the Web" and save (see below)
Name:  image 3.JPG
Views: 426
Size:  36.6 KB

Step 6)
Copy the link into your web browser and go to your online Spreadsheet.
Fill in the details for your BaP as follows:
Original Sale Amount = Total BR needed for your BaP
Original # of Shares = The number of shares you wish to make available to backers
Initial share Price = How much each share will cost (make sure this matches your BR needed and amount of shares available).
Backer's Cut = What percentage of profits you're willing to give your investors.
Make Up Cut = Enter the percentage of profits you're going to offer investors that want make-up (optional)

Step 7)
Open a new Thread in The BaP section (Shipping Fees as per SaS Rules)

Step 8)
All players will be asked to embed there google Spreadsheets onto there BaP post using the New B Button (Next to the YouTube Button)

Simply copy the URL from googledocs to Word and remove the KEY (For ease I have highlighted a KEY below as an example)

http://spreadsheets.google.com/ccc?key=0AtN1iHpL-TRCdEE3Rll3NXo3UGRpYjNYUW1RMnFlaHc&hl=en

Paste the red part into the bottom of your BaP thread, Highlight it and click on the B Button


Step 9)
As investors post to reserve or buy shares, edit the Spreadsheet as follows
Column C - Backer = the name of the investor
Column D - Shares = The number of shares reserved/Bought
Column E - Backers Cut % = Enter relevant cut % for investors if they do/don't want make-up
Column I - Status = Whether shares are Reserved/Paid

Step 10)
Once your BaP is sold and your Rail thread is running you should update boxes B11 / B12 as follows:
B11 - $ Stakes played = Amount you have used in Buy-ins to each game
B12 - $ Won to date = Amounts you have won from all games.

Once the BaP is finished and these numbers have been updated you can ship funds according to Column H.

Warning
DO NOT EDIT ANYTHING OTHER THAN LIGHT BLUE BOXES or your BaP spreadsheet will not work properly

Don't worry if your email is showing on the top right of the spreadsheet, only you can see it

Last edited by addick; 26-02-2011 at 07:51 AM.
sax is offline   Reply With Quote
Sponsored Links
Extra 20 bonus immediately
Old 23-02-2010, 08:40 PM   #2
sax
Senior Member
 
sax's Avatar
 
Join Date: Jan 2008

Pokerstars: saxevest
Full_Tilt: Sax2007
RPM_Poker: SaSshark

Staker_Points: 1210.25
Player_Points: 1020.02

Posts: 14,901
Default How to Guide - Updating your BaP

As of February 23rd, members posting BaPs now have the added responsibility of managing two extra features within each BaP posted.

Feature one:

When posting your BaP, you can now chose a prefix, that will best describe the Format of your BaP. Simply click on the box to the left of the Title bar and scroll down to the best prefix that describes your BaP.. This function is only available in advanced mode when editing a post.



Feature Two:

All players will be asked to embed there google Spreadsheets onto there BaP post using the New B Button (Next to the YouTube Button)

Simply copy the URL from googledocs to Word and remove they KEY (For ease I have highlighted a KEY below as an example)

http://spreadsheets.google.com/ccc?key=0AtN1iHpL-TRCdEE3Rll3NXo3UGRpYjNYUW1RMnFlaHc&hl=en

Paste the red part into the bottom of your BaP thread, Highlight it and click on the B Button



Feature Three:
It is now every members responsibility to keep Investors up-to-date on the current status of all BaPs posted. This can be done by using the Status Bar underneath the Prefix bar used when creating your BaP. Simply click the Status Bar and choose the status that best describes the current status of your BaP.This function is only available in advanced mode when editing your post.



For Sale - This will show potential backers you still have shares available.

Sold out Please send Funds - It is still advisable to PM investors to let them know you have sold all your shares, but this will also alert investors.

Running - This will show investors that all funds have been received and that the BaP is in progress.

Closed and Shipped - This must be selected immediately after you have finished your BaP and distributed funds to your backers as per agreed terms.

Last edited by addick; 24-02-2010 at 08:41 AM.
sax is offline   Reply With Quote
Old 26-02-2011, 08:00 AM   #3
addick
Admin
 
addick's Avatar
 
Join Date: Oct 2007
Location: Kent

Pokerstars: Addick1
Full_Tilt: addix
RPM_Poker: addix1

Staker_Points: 3478.91
Player_Points: 49.68

Posts: 4,213
Default

I have updated the OP and relevant links to include the Make Up option that some members have requested.

It should be self-explanatory for people that have used the spreadsheets before - if you don't want to offer a Make-Up cut then just leave cell B8 empty and everyone's Backers Cut % in column E will be the same (as cell B7).
If you are offering a Make-Up cut as well as a Backer's Cut then B7 and B8 will have your relevant cut % and column E will reflect these figures dependent on what investors want.

If you do this correctly then column G will work out for you what every investor should be paid at the end of the BAP relevant to which cut they have opted for.
__________________
FT: addix (B)
PokerStars: Addick1 (United Kingdom)....that's Addick1 (United Kingdom), not addick, addadick, oddick or any other dick - just Addick1

jl_ryan: addick your horrible player




addick is offline   Reply With Quote
Reply

Bookmarks
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT. The time now is 02:30 AM.


Play online poker at Virgin Poker
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.