Entries tagged with game: deerington

Entry tags:

ACTIVITY TRACKER - DEERINGTON

Hi guys! This is Xy @

assemble I made myself a Google Sheets-native AC tracker to calculate AC points and print out a fully-formed comment. Since there was demand for one that worked outside of Excel, I thought I would share it. All that's really necessary to set it up is in the instructions section, but I've included a section explaining the formulas, a faq, and an optional set of instructions to get it accessible by phone. As a caveat, I won't be able to help troubleshoot any issues with the phone setup as Google Sheets is not well supported on mobile platforms. Please let me know if there are any bugs or if any information is unclear, as it has been tested, but not exhaustively.

INSTRUCTIONS

This should be all you need to get going, but please also read through the formula and faq sections!

Go here and select "File-->Make a Copy" and save it to your drive. You must make a copy as this is the template and you cannot directly edit the template.
Do not rename the tab "CurrentTracker". You may make new spreadsheets in the workbook but you must always have one named "CurrentTracker."
Fill out any fields that are not highlighted yellow. The yellow fields have formulas in them and will populate once you have filled out your spreadsheet.
At the top, select "Deerington Activity-->Print My Activity Comment". If this is your first time running it, google will ask you permission to run from your account. You need to give it permission! Afterwards, a panel should show up with a preview and a textbox with all that you need.

FORMULAS

In case you accidentally delete your formulas, here they are with explanation. The points are already populated for the first 100 rows, and the comments are optional. You must replace the 0 with the number of the column you are applying the formula to.

COMMENTS (optional)

➟ This is for automatically counting comments from a given link (cell A*) and your username (cell K4).
➟ Basically does a ctrl+f for your <user name="yourusername">
➟ Subtracts 1 if you have the entry selected as "Mine" since your username will be counted for the entry.
➟ This will only count on unlocked posts and posts that are not marked 18+, as google spreadsheets can only "visit" dreamwidth pages logged out, and is blocked by the "are you 18+?" page.
➟ Too many uses of this (20-25) will slow spreadsheets down.

=IF(A0="","",IF(C2="Mine",(COUNTIF(importxml(A0,"//span[@class='ljuser']"),$K$4)-1),IF(B0="Toplevel/Post","N/A",COUNTIF(importxml(A0,"//span[@class='ljuser']"),$K$4))))

POINTS

➟ Calculates how many points based on Post Type column and Comments column. 10 for a flat toplevel, 1 for each network, and 3 for action. You will need a new entry if your network thread becomes an action thread.

=IF(B0="Toplevel/Post",10,IF(B0="Network",G0,IF(B0="Action",G0*3,"")))

TOTAL EARNED

➟ If this is a check-in, it will add everything up in your points column.
➟ If this is not a check-in, it will subtract 30 points for your base AC.

=IF(J2="No", SUM(H:H)-30+COUNTA(I2:I)*2,SUM(H:H)+COUNTA(I2:I)*2)

PHONE ACCESS

Here are the steps to get a link in order to edit + print your activity comment from your phone. This is not highly recommended as sheets is not built to work very well on mobile, but it is an option for anyone really on the go.
➟ You will need the google sheets app in order to edit your sheet/entries. However, the script to print your AC will not run in the google sheets app as you can't access the menu to get to Deerington Activity.
➟ While you have sheets open on your computer, go to Tools-->Script Editor.
➟ A screen should pop up with a bunch of code on it that you can ignore, go to Publish-->Deploy as Web App and copy the Current Web App URL.
➟ Save this URL somewhere in a comment or somewhere else that is easily accessible to you on your phone.
➟ That's it! Visiting this link will operate the same way as Print My Activity Comment. You will again need to give it permission the first time to run on your phone the same way in the initial step.
➟ As a note, you will need to log into your gmail account on your phone to do this, and only the accounts that you have granted access to edit your spreadsheet will be able to run the script.

FAQ

Please read this first if you have any issues!

My spreadsheet keeps saying "Loading..." or has -1/0 everywhere on the comment count formula, what's up with that?
➟ Google spreadsheets is notorious for considerable lag. This is generally a problem with >20, 25 threads. You can simply wait for it to load, or manually input the comment number. Manually inputting a number will erase the formula and therefore stop trying to load the dreamwidth entry to count your comments. If a thread is done, I recommend copying over the formula with the number, just so it has one less thread to load.
I've waited forever and it still says -1/0 on some entries, but everything else has loaded.
➟ If the post is locked or marked 18+, google will not be able to get to the page because it can only access dreamwidth logged out. I've tried to get around this but unfortunately it's currently not supported.
The comment count formula on this thread is off by 1. What's going on?
➟ The comment count is a little dumb and basically does a ctrl+f for your username on the entry and counts up all the instances. So if it's your inbox, select "Mine" under entry, which will subtract where your username is on your inbox entry. If your username is mentioned in a toplevel, simply link from the next comment instead.
Will the comment count formula still work if I have a common one-word username?
➟ Yes! The comment count function will only look for the specific dreamwidth tag for <user name="YOURNAME">.
I don't see a menu item for "Deerington Activity", where is it?
➟ Just give it a minute, it takes awhile to load. If it still hasn't loaded: did you copy the contents from the template instead of copying it by "File-->Make a Copy"? Spreadsheets won't copy the necessary script unless you copy the sheet from the file menu.
I was resetting my spreadsheet and deleted the formulas by accident! How do I get them back?
➟ I've pre-populated the first 100 rows with the formulas for point formula. Scroll down until you find one and drag the square on the bottom right corner up to cover the empty rows. If you somehow deleted all 100 rows, you can simply copy the original formula from the formula section above.
You said you made edits, but they're not showing up in my spreadsheet. How do I get them?
➟ You'll have to follow the original instructions and make a new copy to get any edits. However if you've already started filling out for this month, you can salvage anything you already have by copying the information onto the new spreadsheet.
I'm having another issue/still having troubles. Can you help?
➟ Feel free to comment to this post for assistance! I work full-time so I can't promise I'll get to your comment right away, so make sure to please not wait until the last minute to do your AC if you are going to use the spreadsheet.

As always, enjoy!

NOTE FOR MAY 2019: We all get a bonus of 100 points this month, which is not covered by the spreadsheet since it is unique to this month, so your end comment will have to be edited manually to account for this.

UPDATE FOR MAY 26TH, 2019: Looks like I missed counting up crosscanons in the total. For total earned, please replace your formula with =IF(J2="No", SUM(H:H)-30+COUNTA(I2:I)*2,SUM(H:H)+COUNTA(I2:I)*2). You do not need a fresh spreadsheet for this!

NOTE FOR MAY 2020: We all get a bonus 200 points this month (I think??), which is not covered by the spreadsheet since it is unique to this month, so your end comment will have to be edited manually to account for this.

Entry tags:

inbox | deerington

Steve Rogers

Hi, you've reached the inbox of Steve Rogers. Please leave a message after the beep.

voice. text. video. action.

Entry tags:

cr chart | deerington

( even if the whole world is telling you to move, it is your duty to plant yourself like a tree, look them in the eye, and say 'no, you move'. )

Entry tags:

app

IN CHARACTER

Character Name: Steve Rogers, AKA Captain America
Canon: MCU
Canon Point: After the events of Captain America: Civil War

In-Game Tattoo Placement: Right here!
Current Health/Status: Peak physical condition
Age: 31 lived/97 actual
Species: Human (enhanced)

History: Up until Civil War

CRAU History and Impact:
Personality:
Steve Rogers is first and foremost, a good man. He chose to receive enhancements that amplify a person's physicality depending on what kind of person they are inside. He gains super strength, endurance, peak physical condition, and about a foot in height and a hundred pounds of muscle. The reason he chose to undergo the procedure was because he was a sickly, small man who was rejected from being able to serve in World War II. He is a protector, he detests bullies, and he has an incredibly strong moral compass.

Because of this, Steve can be extremely stubborn. He doesn't back away from a fight because he's outnumbered or because he's weaker; he doesn't show signs of regret or weakness when he's losing. One of his most famous lines is "I could do this all day," which he utters after standing back up following getting knocked down. He carries orders but he's not afraid to bend the rules either, even fighting the law, his friends, and becoming a fugitive for several years as a result.

Steve can also be blunt, both in terseness of speech and in actual content; he has a situationally contentious relationship with authority and isn't afraid to voice his opinion or his disagreement.

A trained military tactician, Steve is calm and collected and able to make calls under pressure. He can take a glance at a map and remember all the points of interest and he can think quick on his feet. He is a quick study, he's resourceful, and people generally look to him to come up with orders. One of his nicknames, and the name of a song written about him, is "The Star-Spangled Man With a Plan." He is generally well-prepared as well as decisive. Along with this, he has a talent for rallying speeches and inspiring others to action. Having spent part of his tour as a morale booster, he's also utilized in modern-day PSAs. And even though he is extremely famous in his world, he doesn't lean into it as if it were a perk. Rather, he tends to filter out the over-enthusiasm in fans when they speak to him, and treats it as a necessary part of his role.

He is open-minded and tolerant, which comes particularly easily to him for a man from his era. His chosen elite team of Howling Commandoes was a mixed-race team in a time when that wouldn't be normalized, he respects Peggy when her other colleagues do not, and he's friends with a self-proclaimed God despite being Christian himself. He isn't perfect about his tolerance, but he is self-aware of such. When Natasha suggests a prospective love interest for him, he describes the woman in question as having a lip-ring and states that he's "not ready for that," suggesting he understands the problem comes from his feelings, not her choice.

Having spent some time in the modern era, he's no longer quite as old-fashioned or as proper as he once was. That being said, he had many first-time life experiences during his service and many more after waking up in 2011, so part of that life experience is a loss of both naivety and innocence. He mentions it himself when he states that he thinks someone else "came out of the ice;" there is a definite maturity that he's been forced to develop after a few years serving as an Avenger.

He is very responsible and, when stealing a car, requests Natasha get her feet off the dashboard. Even in Age of Ultron, the other characters make fun of him as he warns another one against swearing; a couple movies later, he's much less discerning. People might say that he's a little uptight, but he's self-aware and he attempts to improve his attitude. He still prefers records over digital music and handwritten letters over e-mail; some of him will always remain rooted in the past.

Steve cares about others, has a hero complex, and is quite pacifistic. His chosen weapon is a shield and he takes little pleasure in excessive violence. In one case, he enters a room full of enemies and asks them if anyone would like to exit before he beats them all to a pulp. He is also selfless and attempts to martyr himself on several occasions, succeeding on one. In that regard, he is quite fearless. But he can also be overprotective: upon finding out that Tony's parents were murdered, he allows Tony to continue believing they died in a car accident in order to spare him more grief (this backfires spectacularly, of course).

He has a serious personality and is well-suited for practical fighting as an action hero. He has a better sense of humor in his private life, mostly in trading banter, and particularly with Bucky or Sam. He pokes fun at his own self-righteousness, as well as his age.

Steve's also incredibly loyal, hard-working and steadfast. He stands by Bucky and tries to rescue him and defend him from his captors, his brainwashing, and the fall-out from said brainwashing. He can be reliably called upon by his friends for aid; people expect the best out of him and he tries his hardest to make sure that's what they get. He de-facto assumes the role of the leader when one doesn't present itself or when someone else thrusts it upon him.

He has a healthy self-esteem, self-assuredness, and relatively little self-doubt, though more since he's woken up from the ice. He tries to stay optimistic, so much so that sometimes it annoys his teammates. He is also forgiving in nature, and unlikely to attack a foe who he no longer considers a threat. Even though he is a positive individual, he also understands that the world is not in black and white and compromises are needed for the greater good, and he acts accordingly.

As for interpersonal relationships, Steve has made several close friends and allies over the years. Of the ones he has lost, he mourns them all deeply. He tries his best to move forward from the past, but his melancholy over lost loved ones is particularly strong; his judgment can become impaired when it pertains to Bucky and Peggy in particular. He is a consummate professional in his line of work, he is friendly, and he is polite to all his acquaintances.

Steve values honesty and forthrightness. He likes being in control of a situation, and he doesn't tolerate liars and dislikes when his team has secret agendas. He likes to be able to trust people.

Abilities/Powers/Weaknesses & Warping: His Super Soldier Serum allows him peak physical/super- human condition, which allows him extreme strength, endurance, speed and health. His metabolism is also so fast such that he can't experience drunkenness from most alcohols. He also has the ability to use his shield as a boomerang. He is surprisingly light on his feet, allowing him to sneak up behind others, and he also speaks French.
Inventory:

One shield made of vibranium, painted in the color of the American flag.
One set of armor, equally Star-Spangled.
One Harley Davidson motorcycle, model Street 750.
One locket, containing a portrait of Peggy Carter.
One sketchbook, partially filled.
One service uniform, WWII, US Army, with attached badges.

Writing Samples: 1 & 2, neither of which contain Endgame spoilers.

OUT OF CHARACTER

Player Name: Xy
Player Age: 28
Player Contact:

first_quadrant

Other Characters In Game: N/A
In-Game Tag If Accepted: Steve Rogers: Xy
Permissions for Character: here
Are you comfortable with prominent elements of fourth-walling?: Yes, very.
What themes of horror/psychological thrillers do you enjoy the most?: Twists, turns, characters having to form alliances to solve problems, feelings.
Is there anything in particular you absolutely need specific content warnings for?: N
Additional Information: N/A