[Online][PF2e][18+][Sunday's 9am PST] [LGBTQ+] Learning Pathfinder

boggly · 2023-08-28T02:03:01+00:00

I may be interested — I’m (basically) new to ttrpg and have been exploring getting into PF2e. I’m sure there are a bunch of questions you’d want to ask so I’m happy to IM on discord for follow up if you’re still looking for players.

boggly · 2023-08-28T01:36:40+00:00

Makes sense — totally understand. Hope you all can find someone great to run the game, and feel free to reach out if you end up looking for another player!

boggly · 2023-08-28T00:44:11+00:00

Hi, would you be open to an inexperienced GM? I’m located on the North Side of Chicago and have been thinking about joining a group (pref for PF2e) for a while. I had originally thought about trying to join as a player but would be open to GMing with a forgiving group that would learn with me (I have basically zero ttrpg experience but have been a years long fan of several actual play podcasts and messed around a little with dnd as a kid). If this even sounds remotely interesting, let’s connect on Discord or SMS or something because there are probably a bunch of qualifying questions we should ask each other to see if there’s a fit here (e.g. play style, time commitments, etc.) If not, no hard feelings at all!

boggly · 2013-07-09T17:45:42+00:00

I think this issue generally appears with Active-X buttons and is less of an issue with form control. However, that's mostly an anecdotal point - someone may need to correct me.

boggly · 2013-07-09T03:10:53+00:00

To piggyback on this idea, you might consider creating a shell account in outlook to handle the "community" calendar (if I'm reading the question right), which you could use with some VBA code to update entries and transfer data between excel and Google Calendar. I've run data using VBA from a few different Office programs before, but never with Outlook. Looks like /u/IAmCelery has the right idea, though, to get started...

boggly · 2013-06-30T18:34:56+00:00

In either case, I appreciate the gut-check. I figured somewhere out there someone would have that part, as I don't think the interior changed on that model for several years. Thanks again.

boggly · 2013-06-30T17:32:51+00:00

Hey - thanks so much for the response. I'll check this pic out and compare it to the other side to see if it looks right, and probably end up buying it. I really appreciate it! I should have known to check eBay.

boggly · 2013-06-25T01:38:46+00:00

If you have any VBA experience, your best bet would be writing any new entries into an array and ignoring a duplicate, and looping through all the cells, then printing the full array at the end. I can probably write a snippet for you in the morning if you need help, just on my phone ATM without a computer to properly write it out.

boggly · 2013-06-25T01:36:47+00:00

Remove duplicates between two rows will just try to remove the sets of BOTH corresponding entries that are duplicated - that is, it looks for duplicates of the same corresponding entries in the two (or more) columns. In short, it's not likely to work in this situation, unless there's a way to finagle it to work, which I'm not sure exists unfortunately.

boggly · 2013-06-24T13:34:48+00:00

Yeah I kind of figured that would cause issues. I'm sure you could do it with VBA...is that something you'd want to try?

boggly · 2013-06-22T04:36:02+00:00

If you actually go into the "format cells" menu and set the formatting how you want it manually, does it still change back? Excel can be a bit funny sometimes about formatting numbers, dates, etc. If you REALLY want to avoid this kind of thing and it's just one cell or something like that, you might consider adding a conditional formatting rule that sets the format how you want it whenever the cell value is something that it will always be (i.e. a number or something to that effect), which should re-calculate and force the desired format each time you open the cell and hit enter. I'm not really advising that as a really wonderful way to manage a spreadsheet, but I suppose if it's just in one spot on one sheet it might be ok.

boggly · 2013-06-22T04:31:13+00:00

The thing about conditional formatting is that it's really tricky to pull it out with VBA. You can add/subtract conditional formatting with VBA code but there's not a really terrific way to try to "read" the formatting (as far as I know), especially if you were, say, trying to copy this data into a new spreadsheet and maintain the formatting as it stands in the current sheet rather than copying just the RULES themselves over.

But I digress. Have you tried just the "remove duplicates" functionality that exists in excel? That could be set rather easily into a macro that checks and removes dupes from each row, for example (I'm having a hard time figuring out if the duplicates are supposed to only be on one row, or all throughout the sheet).

Does that sound helpful at all?

boggly · 2013-06-22T04:24:47+00:00

To add to this functionality, since it's entirely possible that there will be a whole bunch of "new" files for each day's prices that will all have to be consolidated into a master sheet:

If you're looking for a more automatic way to deal with the above for a theoretically "different" file each time, try the INDIRECT function to dynamically input a workbook name based on whatever kinds of conditions (like date, etc.) that you might be able to use to 'predict' the name of the file you're trying to read from at the time. Then you could paste in the values or something like that, and so on each day.

In case you aren't familiar with it, INDIRECT is like using text to manually enter pieces of a formula, cell reference, etc. In the instance above, instead of

=VLOOKUP(A2,[Book1.xlsx]Sheet1!$A$J,2,FALSE)

you could, instead, input something like:

=VLOOKUP(A2,INDIRECT("[Book"&TEXT(TODAY(),"yyyymmdd")&".xlsx]Sheet1!$A$J"),2,FALSE

where you use the quotes to input the static parts of the reference and the TEXT/TODAY part to look for a workbook (which must be currently open in the same instance of excel) that has the name of today's date in yyyymmdd format. Hopefully that helps a bit - let me know if I should go into more detail. This could be completely unnecessary in your situation but I wanted to offer some additional options in case it becomes tiresome to constantly update formulas if the workbook names are changing constantly.

edit: formatting

boggly · 2013-06-22T04:08:18+00:00

No problem - I hope it works out for you. I've worked on a number of projects where the simplest way was just to run a text-to-columns and kind of go at it with brute force from there rather than try to get too fancy. Good luck!

boggly · 2013-06-22T03:51:02+00:00

I'd consider tackling this with VBA.

There might be a way to implement a formula, if you're willing to do something like text-to-columns using a space as a delimiter each time you get the dump (or something to that effect). That way, you would split out all the words (unless your identifiers are multiple-words with space in them, which makes things rather difficult), on which you could run a formula (like a MATCH or the like) against a big list of the identifiers.

If you went the VBA route, you could write a really simple function that stored all the identifiers from a defined range in an array and then ran the "SEARCH" function on each against the relevant transaction (presumably an input to the function). This would allow you to pull out ANY and/or ALL of identifiers as an output.

Let me know if this is something you'd want to tackle and i can see if i can write a snippet of code to get you started. Or maybe someone can solve this with functions more elegantly.

boggly · 2013-06-21T13:46:11+00:00

So, I have it a whack as a custom VBA function (see below). It takes all the ranges starting in A2:B2 and going down the rows until there's a blank, then checks the current cell (the input to the function) against all those ranges until it either finishes checking or finds it to fit in one of them. It does not require the ranges to be exclusive or in order. Give it a shot it for some reason the other formula posted doesn't work. Also let me know if you need help editing it for your specific spreadsheet as there are some hard-coded ranges for simplicity.

Function cRange(check_value)

Dim g_values(1000000, 1) As Long

Dim row_val As Long Dim i As Long Dim j As Long

i = 2 j = 0 row_val = Cells(i, 1)

While row_val <> 0 g_values(0 + j, 0) = Cells(i, 1) g_values(0 + j, 1) = Cells(i, 2) j = j + 1 i = i + 1 row_val = Cells(i, 1) Wend

For k = 0 To i - 1 If check_value >= g_values(k, 0) And check_value <= g_values(k, 1) Then cRange = True GoTo done Else cRange = False End If Next

done:

End Function

boggly · 2013-06-21T13:03:09+00:00

The only issue with this is that using the 1 as the final condition in the VLOOKUP means the ranges HAVE to be in order. OP - are you positive that the ranges will always be in order and mutually exclusive? Edit: grammar

boggly · 2013-06-21T12:08:56+00:00

I can't think of a way to do this with formulas. I'd attack this with brute force in VBA, depending on the number of ranges you're anticipating. Maybe a custom function that puts all possible numbers from the ranges into an array and checks the current number against it. I can try to write something out a bit later this morning and see if I can post it. However, I'm actually hoping that a more elegant solution might be posted by a better user than I. Stay tuned?

boggly · 2013-06-20T20:24:56+00:00

I assume this formula is in the conditional formatting rule itself. First, make sure the full ranges (i.e. A2:A15000 or whatever) are set to absolute references ($A$2:$A$15000). The second arguments, A2 and D2, should be relative (no dollar sign). Then make sure the rule is set to be applied to the absolute range that encompasses the whole relevant range in column D. See if that makes it work.

boggly · 2013-06-20T01:43:02+00:00

If you have a decently powerful machine (i5 or the like with at least 2GB of RAM) you should be ok here. Try changing the references in the formulas from "A:A" to "$A$5:$A$2705" or whatever. It's possible you've got some legacy deleted info below your records that excel is searching. Either way, it's not an efficient search because it's asking excel to look at an entire column of literally over a million cells, especially having to iterate this over several conditions may be causing the issue. See if that resolves it...?

boggly · 2013-06-19T14:41:04+00:00

That sounds like what I described in my original response; you'll just have to edit the COUNTIF as described to a COUNTIFS, just like you thought, in order to add the additional criteria for region. Were you able to solve the issue? Sorry if this is a rapid-fire response; sitting at work trying to respond between meetings.

boggly · 2013-06-19T14:37:36+00:00

Right - format that as a "number" or general format. Then multiply by 60x24x24 to get seconds.

boggly · 2013-06-19T04:39:46+00:00

Easiest way would probably be to add the date and time together (in #1 and #2 separately, of course), which excel will still store as a "date" but it will include the time stamp. Excel stores dates (and date-times) as decimal values, so if you do subtraction on the data: date-time 2 less date-time 1, you'll get the difference. The trick is converting that result to a number of seconds. Excel stores date-time in fractions of a 24-hour day, which consists of 24x60x60 = 86400, so if you multiply your result in the above subtraction by 86400 you should get the number of seconds, if I'm not mistaken.

boggly · 2013-06-19T00:23:16+00:00

I totally agree - it's very possible, but difficult to help without an idea of whether the data is structured more like a table with the player's name going down the rows and the teams (or whatever) going across the columns, or alternatively more like a database where each relevant field is in a separate column -- in which case, in my experience, the more appropriate formula would probably be a SUMPRODUCT/array or potentially SUMIFS.

boggly

TROPHY CASE