You must be logged in to post Login


Lost Your Password?

Search Forums:


 






Minimum search word length is 4 characters – Maximum search word length is 84 characters
Wildcard Usage:
*  matches any number of characters    %  matches exactly one character

Embed an Excel or Google Spreadsheet into a Post WITH Editing option for Readers?

No Tags
UserPost

7:47 pm
October 28, 2010


Khaleef @ KNS Financial

Fat Guy, Skinny Wallet

Member

posts 3149

Is it possible to embed an Excel or Google Spreadsheet into a post WITH editing option for Readers? I just created a Google Spreadsheet and was able to embed it into my post. However, I want readers to have the option to enter in various data, so they can see how the numbers look for their particular situations, and it doesn't give that option.

You can only highlight items, but can't make any changes. On Google, the spreadsheet is set as "Public on the Web", "Anyone invited as a collaborator (no protection)" is set as the protection option, and the page has been published on the web.

It's not just in WordPress either, I sent the link to my wife and she can't edit it from her Google account!

I want this post to go live tomorrow morning, can someone help me in the next few minutes?

Khaleef "Fat Guy" Crumbley

My Battle to Lose 100lbs and Pay off $100k in Debt:

http://fatguyskinnywallet.com

http://twitter.com/FGSW

http://www.facebook.com/fatguy…..innywallet

Personal Finance From A Biblical Perspective:

http://knsfinancial.com

http://www.facebook.com/knsfinancial

http://twitter.com/knsfinancial

7:49 pm
October 28, 2010


Khaleef @ KNS Financial

Fat Guy, Skinny Wallet

Member

posts 3149

Let me add that I am using a plugin called: TGN Embed everything

I'll take a plugin or non-plugin solution at this point. Plus, I'm open to using Excel or Google Spreadsheets to do this!

Khaleef "Fat Guy" Crumbley

My Battle to Lose 100lbs and Pay off $100k in Debt:

http://fatguyskinnywallet.com

http://twitter.com/FGSW

http://www.facebook.com/fatguy…..innywallet

Personal Finance From A Biblical Perspective:

http://knsfinancial.com

http://www.facebook.com/knsfinancial

http://twitter.com/knsfinancial

8:38 pm
October 30, 2010


Khaleef @ KNS Financial

Fat Guy, Skinny Wallet

Member

posts 3149

Just a little bump. Hoping someone sees this and can point me in the right direction.

Khaleef "Fat Guy" Crumbley

My Battle to Lose 100lbs and Pay off $100k in Debt:

http://fatguyskinnywallet.com

http://twitter.com/FGSW

http://www.facebook.com/fatguy…..innywallet

Personal Finance From A Biblical Perspective:

http://knsfinancial.com

http://www.facebook.com/knsfinancial

http://twitter.com/knsfinancial

11:13 pm
October 30, 2010


Chris Johnson

Admin

posts 78

KNS,

If you want your readers to add data to the spreadsheet row by row, one row for each reader (for example), you should be using a Google Form that will submit data into a Google Spreadsheet, one column per answer, one row per submission.  If you want something outside of this possibility, perhaps mention exactly what you are trying to do, and I can be more helpful…or someone else in the forums.

Chris

Yakezie Webmaster.
If it's broke I will try to fix it.  If you need help, let me know and I will see what I can do.

8:38 pm
October 31, 2010


Khaleef @ KNS Financial

Fat Guy, Skinny Wallet

Member

posts 3149

Hey Chris, here is what I want to do. In this post http://knsfinancial.com/401k-a…..ree-money/ I give an example of what a typical paycheck might look like with and without a 401k contribution. I also look at how much money we lose if we do not contribute enough to get the employer match. In order to do the calculations, I made a little spreadsheet. I would like to embed this spreadsheet into the post so that readers are able to enter their specific information and see the results.

Is this possible?

Thanks for your help!

Khaleef "Fat Guy" Crumbley

My Battle to Lose 100lbs and Pay off $100k in Debt:

http://fatguyskinnywallet.com

http://twitter.com/FGSW

http://www.facebook.com/fatguy…..innywallet

Personal Finance From A Biblical Perspective:

http://knsfinancial.com

http://www.facebook.com/knsfinancial

http://twitter.com/knsfinancial

8:55 pm
October 31, 2010


Chris Johnson

Admin

posts 78

This is not something that you are going to be able to do with an embeded Google Spreadsheet.  If you want to give your users the ability to do mathematical calculations like this, you are probably going to have to resort to creating something with Javascript or (not as ideally) PHP.  If you are not able to do either of those things, perhaps you can give your users the spreadsheet as a Zip file that they can download and use on their local computer, opening it up in MS Excel.  Sorry that I cannot be more helpful.

Yakezie Webmaster.
If it's broke I will try to fix it.  If you need help, let me know and I will see what I can do.

5:57 am
November 1, 2010


Khaleef @ KNS Financial

Fat Guy, Skinny Wallet

Member

posts 3149

Chris Johnson said:

This is not something that you are going to be able to do with an embeded Google Spreadsheet.  If you want to give your users the ability to do mathematical calculations like this, you are probably going to have to resort to creating something with Javascript or (not as ideally) PHP.  If you are not able to do either of those things, perhaps you can give your users the spreadsheet as a Zip file that they can download and use on their local computer, opening it up in MS Excel.  Sorry that I cannot be more helpful.


Yeah, I was afraid of that. I guess I can attach the spreadsheet to the post. I may do that!

Thanks, Chris!

Khaleef "Fat Guy" Crumbley

My Battle to Lose 100lbs and Pay off $100k in Debt:

http://fatguyskinnywallet.com

http://twitter.com/FGSW

http://www.facebook.com/fatguy…..innywallet

Personal Finance From A Biblical Perspective:

http://knsfinancial.com

http://www.facebook.com/knsfinancial

http://twitter.com/knsfinancial

5:30 am
November 27, 2010


The Financial Blogger

Member

posts 429

I actually use a wordpress plugin for this.

 

this is what it looks like (but the readers can't download it):

http://www.thefinancialblogger…..nd-stocks/

 

name of the pluging:

WP-Table Reloaded

1:07 pm
December 1, 2010


Khaleef @ KNS Financial

Fat Guy, Skinny Wallet

Member

posts 3149

The Financial Blogger said:

I actually use a wordpress plugin for this.

 

this is what it looks like (but the readers can't download it):

http://www.thefinancialblogger…..nd-stocks/

 

name of the pluging:

WP-Table Reloaded


Thanks for the suggestion Mike! I just used it in my November stats/roundup post: http://knsfinancial.com/novemb…..-11-22-10/

 

It doesn't give the reader a chance to perform calculations, but it does present a nice table that they can play with a little.

Khaleef "Fat Guy" Crumbley

My Battle to Lose 100lbs and Pay off $100k in Debt:

http://fatguyskinnywallet.com

http://twitter.com/FGSW

http://www.facebook.com/fatguy…..innywallet

Personal Finance From A Biblical Perspective:

http://knsfinancial.com

http://www.facebook.com/knsfinancial

http://twitter.com/knsfinancial

No Tags

About the Yakezie.com Forum

Forum Timezone: America/Los_Angeles

Forum Stats:

Groups: 2
Forums: 9
Topics: 6383
Posts: 84794

Membership:

There are 13651 Members
There have been 20 Guests

There are 9 Admins
There are 8 Moderators

Top Posters:

My Personal Finance Journey – 3159
Khaleef @ KNS Financial – 3149
Budgeting in the Fun Stuff – 3048
Sustainable PF – 2759
Miss T @ Prairie Eco-Thrifter – 2213
Eric – PersonalProfitability.com – 2120

Administrators: The College Investor (1935 Posts), Financial Samurai (1803 Posts), LaTisha @YoungFinances (1715 Posts), Forest Parks (1337 Posts), 20s Finances (1147 Posts), Money Reasons (697 Posts), Chris Johnson (78 Posts), Sydney at Untemplater (0 Posts), Suba (0 Posts)

Moderators: Suba @ Wealth Informatics (1876 Posts), sooverthis (1041 Posts), PK @ DQYDJ (361 Posts), jmichelsen (208 Posts), Ramona (13 Posts), JeremyNJohnson (4 Posts), Moderator (0 Posts), rackgeek (0 Posts)