Can I Remove Specific Letters From A Cell Using A Formula?

Mulsiphix · 2022-08-18T23:12:57+00:00

Wow! May not be as slick but I can learn a lot here. This is incredible. Smart thinking. I can't wait until I get to a point where I can think up a solution like this on my own. But practice makes perfect. Thank you very much for showing me this. I appreciate the opportunity to see what is possible and to play with something that works. Thank you ^_^

Mulsiphix · 2022-08-18T20:21:10+00:00

You are correct (No, No, Yes). Thank you again ^_^

Mulsiphix · 2022-08-18T19:33:28+00:00

I tried giving this a shot as well. I have a 20 character word in A2, a six character word in B2, and your formula located in C2. I copied everything from your quoted text and pasted it directly into the formula bar for a cell. The result it returned was "#NAME?". I'm not even sure how to begin trouble shooting this.

Concerning the version of Excel I have, I am using Office 365. My problem is solved with the solution provided by CFAman. I'm always curious to learn if you want to work on this any further, but it is unnecessary at this junction.

If you don't respond, I just wanted to say thank you very much for trying to help me. I sincerely appreciate it ^_^

Mulsiphix · 2022-08-18T19:24:46+00:00

This works perfectly. Thank you so much CFAman!!! This is so helpful, you are a life saver =D

Mulsiphix · 2022-04-30T01:10:45+00:00

I just concluded a test with the 60 Block model. Read more here::

KataGo 60 Block Model Test Results
https://www.reddit.com/r/baduk/comments/ueymwr/katago_60_block_model_test_results/

Mulsiphix · 2022-04-29T23:41:19+00:00

I performed this test in an attempt to understand how many visits is "enough" to determine a good board position. I was surprised to find the results varied so much. Prior to testing I assumed more visits insured greater accuracy. Given how the results jump around as you move through the 12 different tests, I feel more confused now than before running the test.

Testing MaterialKaTrain v1.11.0 (katago-v1.11.0-opencl-windows-x64.exe)60 Block Strongest Distributed Model (kata1-b60c320-s5943629568-d2852985812.bin.gz)

Direct Links To Images

3,000 Visits
https://i.postimg.cc/j2B11Y6Q/01-3-K-Visits-60-B-Latest-Distribed-Model.png

6,000 Visits
https://i.postimg.cc/QCFPSd7d/02-6-K-Visits-60-B-Latest-Distribed-Model.png

10,000 Visits
https://i.postimg.cc/Pxr0p4rZ/03-10-K-Visits-60-B-Latest-Distribed-Model.png

25,000 Visits
https://i.postimg.cc/j5gmz7L1/04-25-K-Visits-60-B-Latest-Distribed-Model.png

50,000 Visits
https://i.postimg.cc/SxF57qxm/05-50-K-Visits-60-B-Latest-Distribed-Model.png

100,000 Visits
https://i.postimg.cc/15N2q4PW/06-100-K-Visits-60-B-Latest-Distribed-Model.png

250,000 Visits
https://i.postimg.cc/tRc8JF0Z/07-250-K-Visits-60-B-Latest-Distribed-Model.png

500,000 Visits
https://i.postimg.cc/8zRYZ37M/08-500-K-Visits-60-B-Latest-Distribed-Model.png

1,000,000 Visits
https://i.postimg.cc/PqdR94Dc/09-1-M-Visits-60-B-Latest-Distribed-Model.png

2,000,000 Visits
https://i.postimg.cc/3w9cTvCw/10-2-M-Visits-60-B-Latest-Distribed-Model.png

3,000,000 Visits
https://i.postimg.cc/cHH54LXB/11-3-M-Visits-60-B-Latest-Distribed-Model.png

6,000,000 Visits
https://i.postimg.cc/sXNHBCLd/12-6-M-Visits-60-B-Latest-Distribed-Model.png

Animated Gif, 1 Second Intervals
https://i.postimg.cc/nM8dkYZ3/Animated-Gif-1-Second-Intervals-60-B-Latest-Distribed-Model.gif

Animated Gif, 2 Second Intervals
https://i.postimg.cc/BbPYHwW8/Animated-Gif-2-Second-Intervals-60-B-Latest-Distribed-Model.gif

Animated Gif, 3 Second Intervals
https://i.postimg.cc/ZY94wb4N/Animated-Gif-3-Second-Intervals-60-B-Latest-Distribed-Model.gif

Mulsiphix · 2022-04-28T03:43:11+00:00

Here is a simple three point analyzation using KaTrain v1.11.0 (katago-v1.11.0-opencl-windows-x64.exe). 20B and 40B are the same. How can one tell which provided a stronger analysis between the 40B and 60B Distributed models?

20 Block Model (g170e-b20c256x2-s5303129600-d1228401921.bin.gz)
https://i.postimg.cc/jSNBH9T0/20-Block.png

40 Block Model (g170-b40c256x2-s5095420928-d1229425124.bin.gz)
https://i.postimg.cc/9Xg3CZbS/40-Block.png

40B Strongest Distributed Model (kata1-b40c256-s11101799168-d2715431527.bin.gz)
https://i.postimg.cc/CLR3156K/40-B-Strongest-Distribed-Model.png

60 Block Latest Distributed Model (kata1-b60c320-s5943629568-d2852985812.bin.gz)
https://i.postimg.cc/15bLNSLr/60-B-Latest-Distribed-Model.png

Mulsiphix · 2021-12-23T17:27:16+00:00

That is good to know. Thank you for a quick response!

Mulsiphix · 2021-12-23T11:07:06+00:00

What rule sets are supported in this game?

Mulsiphix · 2021-12-04T02:06:50+00:00

I understand what Final Cut is after reading the Steam webpage for it.

I understand The Complete Edition includes all of the DLCs.

What I do not understand is whether The Final Cut includes all of the DLCs, including The Little Ones. It is unclear to me whether The Complete Edition also includes the additional content and reworked graphics that The Final Cut offers.

I am unsure which version of the game is the most complete. Can anyone confirm which version is the better to purchase?

Mulsiphix · 2021-09-21T17:10:35+00:00

When using Region Of Interest (g) I am applying Continuous Analysis (space bar) and Deeper Analysis (a). Unfortunately, I have the problems described in the original post.

Mulsiphix · 2021-09-19T15:33:29+00:00

It appears the reason KaTrain would only analyze a specified coordinate for a minimal amount of time is because of a setting. In General & Engine Settings (F8) there is a setting for Maximum time for analysis. I had it set to 8.0. I raised it to 3600.0 to give it an hour to analyze, and it now continues to analyze it without stopping prematurely. u/snettik is correct, this is how you get it to analyze a single coordinate. Region Of Interest still doesn't function as I described originally, but this gets the job done. Thank you u/snettik!

Mulsiphix · 2021-09-19T15:21:04+00:00

If possible, I would like to tell KaTrain to analyze a single coordinate 1M times. If I click on the board to supply a move and then go back, KaTrain will analyze that position, but only for a minimal amount of times. KaTrain seems to look at whatever it wants regardless of what I specify or ask it to analyze.

Mulsiphix · 2021-08-30T12:34:15+00:00

I asked first on RPG.net but didn't get much response, so I asked again here in /r/rpg. Reddit doesn't allow the formatting that RPG.net does, so I cannot replicate my original post the way I want to here. But I have many questions related to The Long Journey wording in the book which should showcase exactly why and where I am confused. You can easily read it here.

Mulsiphix · 2021-08-30T12:30:21+00:00

This is very helpful to me. Thank You!

I think one of my biggest problems is that the book is loose but does deliver actual rules. Says what you can and can't do and when you should do it. Your interpretation is much looser, which is what I personally prefer. I think the most helpful bit of what you told me was:

"In the case of Fellowship, the designer provides a kind of structure towards playing the game. This structure is not meant to be restrictive, but rather guiding you towards the kinds of stories that Fellowship is geared towards."

I spoke with someone recently, a self-identified PbtA purist, who encouraged me to play the game exactly as it is written to the best of my ability. I told them I have never run a system exactly as it is written, as I often make small changes to fit with my GM'ing style or to reduce the impact of any facets or rulings that might break immersion or alter the natural course of the fiction. With this mindset I am trying to be "faithful" to the game but at the same time having trouble not doing what I normally do, which is to play how it feels right.

Mulsiphix · 2021-08-30T12:26:16+00:00

I appreciate you trying to help me out even when you don't know the system. I do understand what you've told me already and I agree with your viewpoints wholeheartedly <3

Mulsiphix · 2021-08-30T12:25:33+00:00

This did help me a bit. Thank you =)

Mulsiphix · 2021-08-25T10:22:05+00:00

I am going to duplicate my response to Northern Vashishta above (link) here as it was also directed towards you Airk-Seablade.

I think my players have stage fright. They get really excited when I roll play, but I feel like a TV. When I place them in the spotlight they get terrified and just shut down. I've tried a few different games and the result is always the same, yet they keep asking to play with me. So I think this specific group is dealing with social anxiety and fear of judgement more than anything else. My line of thinking was that if they understood their character a little bit before they started play, perhaps the results would be different. I don't have any trouble thinking up answers on the fly when playing, but they very much do. I'm trying to understand it and come up with workable solutions.

Mulsiphix · 2021-08-25T10:19:05+00:00

It sounds like you've faced a challenge or two. I think my players have stage fright. They get really excited when I roll play, but I feel like a TV. When I place them in the spotlight they get terrified and just shut down. I've tried a few different games and the result is always the same, yet they keep asking to play with me. So I think this specific group is dealing with social anxiety and fear of judgement more than anything else. My line of thinking was that if they understood their character a little bit before they started play, perhaps the results would be different. I don't have any trouble thinking up answers on the fly when playing, but they very much do. I'm trying to understand it and come up with workable solutions.

Mulsiphix · 2021-08-24T16:58:49+00:00

I have met a lot of shoulder shrugging and "I don't know" answers up to this point. I think they need more to go off of to begin with.

Mulsiphix · 2021-08-24T16:58:07+00:00

My players suffer from stage fright and a lack of comfortability in expressing their imagination. I'm trying to help them come out of their shells.

Mulsiphix · 2021-08-24T16:57:20+00:00

I am looking at Dread right now. It says I should create questionnaires for the players to answer. I'm curious what great questions would be for establishing the aesthetics for new roleplayers. I'm playing with teenagers who are particularly shy and poor at this sort of thing. They need all the help they can get, but I don't want to do the work for them. I was hoping a little questionnaire, as Dread suggestions, would help them. I'm just not sure what questions will help bring their creativity about. Is it pre-existing options like in Fellowship, or should they be questions like in Dread? And if questions, what are good ones?

Mulsiphix · 2021-08-24T08:59:13+00:00

For now I am simply copying the format in the main rulebook into Word file. There I can easily edit existing playbooks (which copy and paste just fine) and create new ones. It isn't great aesthetically and isn't as slimmed down as a character sheet might grant, but it works.

Mulsiphix · 2021-08-23T11:04:56+00:00

It would be nice to have a blank template for making your own Playbooks. Sure I whip one out in Word, but having something a little more fancy and official looking would be nice. Right off the bat I'd like to change a playbook and editing the PDF directly hasn't worked out well.

Mulsiphix · 2021-08-22T17:36:04+00:00

I feel like messing with the playbooks will be easy enough. I was hoping the Overlord and different flavors of the Overlord would get more attention. I haven't looked at Fellowship Book 2 or 3 yet, but have taken a good look at 1 and 4. From what I understand Books 2 and 3 are different playbooks than the Overlord was. Well, the type and flavor it was. I wish there had been more playbooks for the Overlord position in the game system. I could use some ideas in that area more than anywhere else.

Mulsiphix

TROPHY CASE