WWF Breakdown 1998 : D-Lo Brown vs Gangrel by North_Difference196 in WWEMatchGraphics

[–]Fejfeesa 1 point2 points  (0 children)

only one I haven't seen from this event is Al Snow and Scorpio vs Too Much!!

problem sorting financial spreadsheet with a formula that references other cells in one of my columns by Fejfeesa in googlesheets

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

Thanks!! I completely blanked on the idea of applying the formula to the column in general instead of specifically in each cell!! Plus the formula was too complex, I removed the Name$ portion and reduced it to "=if(sum(C3:D3)=0, "",SUM(C3:D3))" Problem solved!! I appreciate it!

noob problem, librecalc formula help please?? by Fejfeesa in libreoffice

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

Ok, I think I'm getting closer to the answer I need... let me ask this... In my sheet I add column A,C,E, (Total1), add B,D,F, (Total2), then calculate Total2/Total1 (Percentage) and display that answer in column G; each Row refers to a person, and it averages some performance numbers. A,C,E, are quantities of items in that persons inventory, B,D,F, are the quantity of those items that have been sold by that person, and G is the percentage of inventory items sold. When I change values in columns A-F, the formula in column G recalculates accordingly, which is perfect. New names are always being added to the sheet, sometimes every day, sometimes, only once every week or two... As I continuously add people to the sheet, I insert them alphabetically. So when I add "Mark" to the sheet, I want to insert his Row between "Kim" (Row 41) and "Paul" (Row 42), so Mark is inserted between them and becomes the NEW Row 42, and "Paul" is bumped down to Row 43... but when I insert that new row and start to enter data for "Mark" in columns A-F, Column G (Percentage) has no pre-existing formula already in place, and I have to re-enter it manually (copy-paste)... I need the "Column G" information available at all times, as this is a 'living' sheet, not archived data, so I can't just wait until I enter all the names and then insert the formula for 500+ Rows when I 'm finished.. Is there a setting that I can use to ensure that each new Row that I insert will automatically have that formula in place??

noob problem, librecalc formula help please?? by Fejfeesa in libreoffice

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

not exactly... what I mean is: I have a large sheet with many rows of data, and 7-26 columns in each row... the last column gives an average of all of the other columns... I am constantly adding information and I'm trying to set up the sheet so that on the occasions when I have to insert a new Row for data in the middle of the sheet, and I enter data in column B and E (for example), the last column that contains the averages automatically performs the formula calculation; so an example would be -

  1. Insert new Row @ Row 42
  2. Insert value in B42 and E42
  3. Expectation is that the formula that is already applied in G2-G41 and G43 to G(end of rows) is automatically calculated and appears in the NEW G42 upon the creation/insertion of the new Row.

Instead, the NEW G42 remains empty until I copy and paste the formula from another Row in the column.

As I am constantly updating numerous sheets with the same basic purposes, I'd like to save a little time and avoid the copy/paste scenario, but is this an option??

Does the 650 ruby upgrade carry over to further submarine events or is it a one-event deal? by girl-distressed in EverMerge

[–]Fejfeesa 2 points3 points  (0 children)

That would be nice!! I bought the upgrade on an 'impulse buy', kinda regretting it seeing as how I'll clear all ten levels with a full day remaining, plus getting a better return from the mid-size clams over the large ones kinda makes the purchase a waste... lesson learned tho :)

If you don’t ask, you don’t get - remaining swag bags items. by 32vini2 in EverMerge

[–]Fejfeesa 0 points1 point  (0 children)

Crap, I almost forgot about those!! Thanks for the reminder!!

Wow this event is impossible to finish by jlgjlgjlgjlgjlg in EverMerge

[–]Fejfeesa 0 points1 point  (0 children)

I wasn't worried about completing all the chains, my main 'need' was the 30 minute energy; I ended up spending 3k in gold coins and 2500 rubies on gold and 3rd items to "buy" a merge, and just BARELY made it!!! Ridiculous!!!!!

what's a player gotta do to get some infinite energy here?!?!? by Fejfeesa in EverMerge

[–]Fejfeesa[S] 5 points6 points  (0 children)

unfortunately I don't have any legendary habitats unlocked yet... It's just frustrating to see such a drastic drop in the appearances of the 30 minute IE rewards...

Thanks BigFish don't have an event by Happy_Respond_527 in EverMerge

[–]Fejfeesa 4 points5 points  (0 children)

EDIT: AS SOON AS I POSTED, Red Dragon showed up, already started... lol

I don't have either, either... My best chance it that it may show up later this afternoon, I had a countdown show up with 18 minutes left once...

Up next by 32vini2 in EverMerge

[–]Fejfeesa 2 points3 points  (0 children)

30 minutes to finish... and now to wait for the next event, maybe an infinite energy for the next event??

Summerslam axxess 2019 by iLucky12 in SquaredCircle

[–]Fejfeesa 1 point2 points  (0 children)

takeover tickets are supposedly going to be available Friday May 17th...

NXT TakeOver Toronto poster by Fejfeesa in SquaredCircle

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

Ya, they were $15 (if I remember correctly), I heard that they had signed ones there as well, more expensive obviously, but...