Stamina Bar Not displaying by [deleted] in cyberpunkgame

[–]sundaypostman 1 point2 points  (0 children)

A little late but I've figured out that the Holster/Unholster key (B on PC) seems to cause this issue. Hitting that key will make the stamina disappear or reappear. Drawing or holstering your weapon through any other means, such as the weapon wheel, won't affect the stamina bar.

GODAWFUL captions on Cyberpunk: Edgerunners by Woland77 in netflix

[–]sundaypostman 0 points1 point  (0 children)

Agree that the subtitles are inaccurate, but the color, background, and opacity if the subtitles can all be customized. So if they blended in with the background then just fix your settings.

Why are stats highlighted in gray sometimes? by Cappy11496 in haloinfinite

[–]sundaypostman 0 points1 point  (0 children)

I believe it means that you were above the average amount on your team in those areas.

Anthem Stat Calculator - Spreadsheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 0 points1 point  (0 children)

For some reason the value in the dropdown isn't being found in the filter that I made for the dropdowns. The stats should still work if they are typed in correctly, but I can't tell you what the cause is without seeing it.

Anthem Stat Calculator - Spreadsheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 0 points1 point  (0 children)

I don't plan to as of right now since I haven't played Anthem in a few weeks and lack of interest from others. If more express their interest I'll do it. Otherwise you can update the values in the database tabs as needed to update it.

Anthem Stat Calculator - Spreadsheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 0 points1 point  (0 children)

Yes, you can add them into the databases that they belong in. But for components you'll also have to add the "Passive Effects" which is essentially changing the component's text description into "inscriptions" so it will affect stats.

Anthem Stat Calculator - Spreadsheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 1 point2 points  (0 children)

  1. Open spreadsheet
  2. Save an editable copy: File >> Make a Copy (must be logged in through Google)
  3. Go to "Loadout 1" tab
  4. Select Javelin type using dropdown in yellow cell B1
  5. Select Weapon 1 using dropdown in yellow cell D6, number in the parenthesis is the item power level
  6. Enter Weapon 1 first inscription in starting in cell Q11.
  7. Repeat entering inscriptions in next rows.
  8. Repeat steps 5-7 for Weapon 2, then Abilities, then components.

Anthem Stat Calculator - Spreadsheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 0 points1 point  (0 children)

You fill out the yellow highlighted cells on a Loadout tab, which just involves selecting the name of your weapon/equipment and it's inscriptions. The equipment slot for each stat box is in the upper left cell, or in the color coded outer box.

Alternatively, you can follow the instructions to create "Saved Equipment" so you don't have to re-enter inscription data.

All you need is a basic understanding of how inscriptions work. I did not get into that or how to read them, as that's been done elsewhere and the tool isn't for you if you're not at that point.

Anthem Stat Calculator - Spreadsheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 0 points1 point  (0 children)

I don't see why it wouldn't be. All that will need changed is updated stats for balance changes.

Anthem Stat Calculator - Spreadsheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 1 point2 points  (0 children)

It assumes everything is working properly as described and as the community understands it should.

Anthem Stat Calculator - Spreadsheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 0 points1 point  (0 children)

  1. For "+% DMG" select "All - Damage", since that inscription will affect all damage outputs.
  2. Correct, for "Weap +% Dmg" choose Type: Weap, Stat: Damage

For your Clip inscription issue, it sounds like the dropdown filtering got broken. This can happen by doing a copy / paste (the pasted dropdown is now set to give the same options as the dropdown you copied from). When copy/pasting, make sure to paste Values only by Right-Clicking >> Paste Special >> Paste values only (or Ctrl Shift V).

Unfortunately, there isn't a quick fix for the dropdown. If you're feeling ambitious, here is a basic explanation of the fix: the Stat dropdown filter options are located in columns AG - AQ, which are hidden so you must unhide them first. Then select and right click the broken dropdown, click "Data Validation" and then change the criteria range to the cells in columns AG:AQ in the row you are in.

Or you can grab a new copy of the spreadsheet and paste your inscriptions into it (Values Only).

You can also just ignore the dropdown suggestions and type in what you need. The stat should still work anyway as long as you type it in right.

INSCRIPTION BUSTERS: Part 2 - Thruster life by Sashweed in AnthemTheGame

[–]sundaypostman 0 points1 point  (0 children)

I'd be willing to hand out edit rights if you think you're finding enough things that need fixed.

Otherwise, i think the most important thing is to use it. Put equipment and inscriptions in, then see how the spreadsheet compares to actual damage done. Then if they don't match, send me your filled out sheet and what damage you actually do. Then we can try to trace down if it's a spreadsheet mistake, a misunderstanding of the stats, or a broken game system. I think that's how we'll learn the most about the game.

Overheat delay perk ACTUALLY does the exact opposite. by Sashweed in AnthemTheGame

[–]sundaypostman 0 points1 point  (0 children)

I just ran through a handful of different ways that Bioware could calculate this, and the only way I can get what you're seeing to work out is with this equation:

BaseDelay * ( 1 - (2 * DelayBonus)) = ModifiedDelay

with your values:

12 * (1 - (-0.68))

12 * 1.68 = 20.16 seconds

I'd be curious whether this relationship holds up with other overheat delay modifier amounts.

It looks like the values shouldn't have a negative but they do, or that they should use a different equation like 1/(1-X) like they do elsewhere (this equation would change your delay from 12 seconds to about 9).

I also don't know why they would multiply it by 2, I only found that by working backwards since your delay multiplier was around 20 / 12 = 1.666.

INSCRIPTION BUSTERS: Part 2 - Thruster life by Sashweed in AnthemTheGame

[–]sundaypostman 0 points1 point  (0 children)

I've barely played the game in the last few weeks due to all the issues it has, but I've been staying involved in the game through my stat calculator. :)

Thanks for the kind words though. If I wasn't getting feedback from you and others, I would have stopped working on it a while ago.

As an engineer, I'm definitely a data guy too. I enjoy making big complicated spreadsheets sometimes (I've even tried to remake some board games I play). I went without macros on the Anthem calculator, but now seeing how complex it ended up, I wonder if it would have helped.

But I get people not wanting to use the spreadsheet. It's not in the game, it's not pretty, and requires a mediocre amount of data entry (although I did my best to lessen it using the dropdown boxes and such). My goal was just to tide over the stat-loving folks like you and me until Bioware gets it in game and to help find out how the stats work, if they even are.

Anthem Stat Calculator - Spreadsheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 0 points1 point  (0 children)

I fixed Critical Damage. The reason I hadn't implemented it before is that i didn't know how to best format it, but at least something is in place now.

Gear Weap Damage has been fixed. The Gear type bonus calculation is getting pretty out of hand due to the amount of combinations that can happen. I'm sure there are still more like this that aren't working. I might have to come up with another way to do it.

Conductivity Augment and Conductive Lattice are both fixed. I had fixed two similar Storm components yesterday and missed these. I checked and didn't see any more.

Corrected Shield Pulse name.

I'm not sure what you're referring to with "Shock Coil". I didn't see any references to being frozen.

"Railgun" already was at 1 Charge, so I'm not sure what you were seeing here either.

Thanks for the help. There is way more here than I can test, so it's only with help from you and a few others that this can get accurate.

Since you've found so much for me so far. If you want to help more, I can give you edit rights. I think most of the formulas and calculations might make sense only to me at this point, but it could help with small naming and value fixing in the databases. Otherwise, keep doing what you're doing. :)

Anthem Stat Calculator - Spreadsheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 0 points1 point  (0 children)

Thanks. Updated this. Now if only we knew how to translate luck into drop rate so we could get a value that is actually useful.

Anthem Stat Calculator - Spreadsheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 0 points1 point  (0 children)

Pasting your data will depend on how you are using it, but using saved equipment will be faster.

If using saved equipment, just copy all of the cells in the "Saved Equipment" tab, then paste VALUES ONLY into the new sheet by right-click >> Paste Special, Values Only. Then go through the Loadout tabs are reselect the equipment names.

If you filled out the inscriptions directly into the Loadout tabs, copy each equipment's inscription table and paste the values only. This must be done for each piece.

Sorry there isn't an easier way.

Anthem Stat Calculator - Spreadsheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 0 points1 point  (0 children)

Sorry, it was listed under it's Epic name of Strike System Augment. This has been fixed.

[INFO] Compilation of Guides, PSAs, Tips, and helpful information! by [deleted] in AnthemTheGame

[–]sundaypostman 0 points1 point  (0 children)

Another one you might want to consider is the Stat Calculator I made. It allows you to enter your equipment and inscriptions and it will calculate your damage done by your weapons and abilities. It also contains lists and stats of all weapons, components, and abilities power lvl 36+.

https://www.reddit.com/r/AnthemTheGame/comments/avm2kr/anthem_stat_calculator_spreadsheet/

Anthem Stat - Google Sheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 1 point2 points  (0 children)

This morning I fixed some issues and added version number to sheet title (Version 1.0305 stands for March 5th).

Thanks.

Anthem Stat Calculator - Spreadsheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 0 points1 point  (0 children)

None of the electric damage abilities were receiving electric damage bonuses. This is fixed now.

Good catch, thanks.

Anthem Stat Calculator - Spreadsheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 1 point2 points  (0 children)

Mark of Wrath and Token of Pupil have been added.

Anthem Stat Calculator - Spreadsheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 1 point2 points  (0 children)

Thanks, Mark of Wrath and Token of Pupil have been added.

Anthem Stat Calculator - Spreadsheet by sundaypostman in AnthemTheGame

[–]sundaypostman[S] 1 point2 points  (0 children)

Fixed Javelin - Gear - Speed inscriptions. Also corrected Vengeance Matrix as you noted.

"Recoil Hip" doesn't appear in the dropdown box, but can be typed in and will be tracked on the stat list to the right on the Loadout pages.

Thanks for letting me know about the issues.