04-15-2015, 07:00 PM | #11 |
Join Date: Dec 2006
|
Re: Google docs//spreadsheet//.csv export
Ok, finally had some time.
I am now the proud owner of a completely rebuilt vehicle, but my existing one had to go to the junkers. In any case, here is what GCA spits out for a normal character: Code:
Stein Drachen (316 points) Human ST 10 [0]; DX 10 [0]; IQ 13 [60]; HT 14 [40]. Damage 1d-2/1d; BL 20 lbs.; HP 10 [0]; Will 13 [0]; Per 13 [0]; FP 15 [3]. Basic Speed 6 [0]; Basic Move 6 [0]; Block 7 (DX); Dodge 10; Parry 15 (Innate Attack (Projectile)). Social Background TL: 8 [0]. CF: Languages: English (Native) [0]. Advantages Appearance (Attractive) [4]; Combat Alchemy 4 (Alchemy, Innate Attack, Scrounging, Thaumatology; Artist; Stable working) [28]; Crushing Attack 50 (Increased Range (1/2D Range only) (x10); Nuisance Effect: ability makes you obvious; Reduced Range (x1/10); Requires Innate Attack Roll) [175]; Enhanced Time Sense [45]; Gadgeteer (Quick) (Accessibility (Alchemy Only) (+5); Alternative Ability) [5]; Luck [15]; Weapon Master (Combat Alchemy) (one specific weapon) [20]. Perks: Attribute Substitution (Innate Attack based on IQ) [1]. Disadvantages Chummy [-5]; Curious (12 or less) [-5]; Fanaticism (Self) [-15]; Impulsiveness (12 or less) [-10]; Increased Consumption -2 [-20]; Lecherousness (12 or less) [-15]; Megalomania [-10]; Overconfidence (12 or less) [-5]; Vow (No Armour) (Great) [-15]; Vow (No Arms) (Great) [-15]. Quirks: Attentive; Expression (Haha!); Likes Showing Off; Proud; Responsive [-5]. Skills Alchemy/TL8-16 (IQ+3) [4]; Artist (Alchemy)-15 (IQ+2) [1]; Computer Operation/TL8-13 (IQ+0) [1]; Driving/TL8 (Automobile)-9 (DX-1) [1]; Fast-Talk-12 (IQ-1) [1]; Innate Attack (Projectile)-22 (IQ+9) [16]; Research/TL8-12 (IQ-1) [1]; Scrounging-19 (Per+6) [4]; Sex Appeal (Human)-14 (HT+0) [1]; Thaumatology-16 (IQ+3) [4]. Techniques: Concentrate+ 100m Ranged Enhancement (Innate Attack)-19 [3]; Concentrate+Wall (Innate Attack)-19 [3]. Code:
Name, Stein Drachen; Points, 316; Race, Human; Basic Stats; Stat,Value,Cost; ST,10,0; DX,10,0; IQ,13,60; HT,14,40; Derived stats HP,10,0; Will,13,0; Per,13,0; FP,15,3; Basic Speed,6,0; Basic Move,6,0; Block,7 (DX); Dodge,10; Parry,15(Innate Attack (Projectile)); Damage 1d-2/1d; BL 20 lbs.; Social Background; TL,8,0; Languages; English,Native,0; Advantages; Appearance,(Attractive),4; Combat Alchemy,4,28, (Alchemy. Innate Attack. Scrounging. Thaumatology. Artist: Stable working); Crushing Attack,50,175 (Increased Range (1/2D Range only) (x10). Nuisance Effect: ability makes you obvious. Reduced Range (x1/10). Requires Innate Attack Roll); Enhanced Time Sense,,45; Gadgeteer,2,5 (Alternative Ability)(Accessibility (Alchemy Only) ; Luck,1,15; Weapon Master, (Combat Alchemy),20,(one specific weapon); Perks: Attribute Substitution, (Innate Attack based on IQ),1. Disadvantages Chummy,,-5; Curious, (12 or less),-5; Fanaticism, (Self),-15; Impulsiveness,(12 or less),-10; Increased Consumption,-2,-20; Lecherousness,(12 or less),-15; Megalomania,,-10; Overconfidence,(12 or less),-5; Vow,(Great),-15, (No Armour); Vow,(Great),-15, (No Arms); Quirks: ; Attentive,,-1 Expression (Haha!),,-1 ; Likes Showing Off,,-1; Proud; Responsive,,-1; Skills:; Sill,level,cost,stat; Alchemy/TL8,16,4,(IQ+3),; Artist (Alchemy)-15,1,(IQ+2); Computer Operation/TL8-13 ,1,(IQ+0); Driving/TL8 (Automobile),9,1, (DX-1); Fast-Talk,12,1,(IQ-1); Innate Attack (Projectile),22,16 ,(IQ+9); Research/TL8,12,1, (IQ-1); Scrounging,19,4,(Per+6); Sex Appeal (Human),14,1, (HT+0) ; Thaumatology,16,4,(IQ+3); Techniques:; Technique,level,cost; Concentrate+ 100m Ranged Enhancement (Innate Attack),19,3; Concentrate+Wall (Innate Attack),19,3. |
04-16-2015, 06:36 PM | #12 |
GCA Prime
Join Date: Aug 2004
Location: Portland, OR
|
Re: Google docs//spreadsheet//.csv export
Seems straightforward enough. When I get some time, I'll see about creating an export sheet for it.
__________________
Armin D. Sykes | Visit my GCA5 blog for updates and previews. | Get GURPS Character Assistant 5 now at Warehouse 23. |
09-09-2015, 07:05 PM | #13 |
Join Date: Dec 2006
|
Re: Google docs//spreadsheet//.csv export
|
09-10-2015, 04:01 PM | #14 | |
GCA Prime
Join Date: Aug 2004
Location: Portland, OR
|
Re: Google docs//spreadsheet//.csv export
Quote:
It's downloadable from here: http://www.misersoft.com/gca/sheets/...0%7BCSV%7D.gce Right-click, Save Link As... to your computer, then put it into your /sheets/ folder where GCA can find it. Please let me know if you need something tweeked more. If it's not too complicated, I can probably adjust it pretty quickly.
__________________
Armin D. Sykes | Visit my GCA5 blog for updates and previews. | Get GURPS Character Assistant 5 now at Warehouse 23. |
|
11-08-2015, 07:07 PM | #15 | |
Join Date: Dec 2006
|
Re: Google docs//spreadsheet//.csv export
Quote:
Only thing it does not capture well is parent->child items; it seems to auto-sort alphabetically all items, ignoring when it 'belongs' to, which is really only an issue if your using the parent->child for alternate forms or the like (which I routinely do- but it is pretty moot). |
|
11-09-2015, 01:17 PM | #16 | ||
GCA Prime
Join Date: Aug 2004
Location: Portland, OR
|
Re: Google docs//spreadsheet//.csv export
Quote:
Quote:
__________________
Armin D. Sykes | Visit my GCA5 blog for updates and previews. | Get GURPS Character Assistant 5 now at Warehouse 23. |
||
05-15-2016, 08:42 AM | #17 |
Join Date: Jun 2006
Location: Twin Cities, Minnesota
|
Re: Google docs//spreadsheet//.csv export
I recently wrote a character sheet that serializes (er, encodes since this is vbscript) most of the character sheet elements and the uses ajax to push the xml character (and it's portrait image mime encoded) to a mediawiki website, the character sheet options are url/user/pass. Where then it is available for use in a dice roller app or mundane display.
Implementing oauth in vbscript is a no go for me, the vanilla controls are just so weak. Even the vanilla base64 mime encoding isn't compliant (spaces?). It could be done easily with a additional binary, but that's a distribution nightmare. Now a github gist upload, that I have done and its a HTTP simple call. You might do well with just exporting to dropbox/googledrive. In my character sheets I dont export, I just print preview the sheet (no prompting) and return some website "success" that is returned as the Paragraph to the GCA user.
__________________
"Look after the universe for me will you, I have put a lot of work into it." -- Doctor Who |
Tags |
csv, gca, google docs, spreadsheet |
|
|