Greetings -
I am 43F, 5'9" 157 lbs, caucastion, large-ish bone structure. Current meds (taken the same ones for a number of years): adderall, bupropion, vestura. My problem pre-dates these medicines.
I have had slow GI movement since childhood. It bothers me because I often feel uncomfortable and bloated. Sometimes it's hard to pass anything. Hoping for some direction on speeding up GI movement, possibly for recommendations on books on the topic. I do not want prescription meds.
The issues with slow GI movement compounded when I gained quite a bit of weight as I crept towards my 40s. I decided to do something about my weight and size, so I embarked on a relatively rigid diet, vitamin/supplement, and exercise program. I lost over 90 pounds (yay). Even though I made great strides in decreasing my size and improving my general health, I still have slow GI movement! I am at a loss. If I want things to "move" I have to take exceptionally large amounts of magnesium. I'm talking between 1250-2000 mg in a day. Even in amounts that high I do not get diarrhea. I have never taken laxatives or stool softeners on a regular basis.
Yes, I have seen doctors about this. The doctors I see give me confused looks and don't have many answers for me because I eat right, exercise, drink lots of water, my weight and BMI are good, and my labs are excellent.
I just want to poop like a normal person and not feel bloated. :(
Here is a summary of my lifestyle:

• I started to use a food tracker app so I can stay within calorie/macro goals. I can tell you everything I have eaten/drank every single day of last 16 months.
• Weight loss was a journey - I played with my macros for months until I found a ratio that worked for me. My maintenance-weight macros are in the neighborhood of 40% fat, 35% protein, 25% carbs.
• I initially restricted calories to support weight loss but am now maintaining current weight with approximately 1500 calories per day.
• I take in about 3 liters of water per day.
• I do not eat gluten/bread - I don't have celiac's disease or gluten sensitivity. I did this because I found that eliminating gluten encouraged me to eat less carbs/less snacks.
• I rarely eat processed foods/things that come in a box or a package. I also tend not to eat at restaurants because it gets expensive.
• I do consume dairy products, including milk and cheese, but not in large quantities. I tried to eliminate dairy at times over the last few years and saw no difference with GI problems.
• I do moderate intensity cardio 5x per week and light weightlifting 2-3 times a week.
• I work a desk job, so getting steps AND a workout in is sometimes a challenge, but I try to get at least 5 thousand a day in addition to my workout.

Here are the supplements I can confirm I have taken for approximately the last three years, their amounts per day, and their purpose:
astaxanthin12 mgheart and skin health resveratrol180 mgcholesterol quercetin1000 mg antioxidant / inflammation turmeric curcumin500 mginflammation evening primrose1000 mginflammation niacin1000 mgcholesterol vitamin D310000 iubone health, immune function super Kvariousblood/bone health nmn1000 mgcellular repair women's probiotic 40 million digestion
The only thing I know I'm allergic to is Ashwagandha, an herb in many women's multivitamin supplements. Found that one out the hard way.
My labs are excellent - every measure is within range.
I welcome your thoughts.

Function
Integrated circuits (ICs) specifically designed for memory function store data in binary format. This data can include programs, data, settings, and more. Memory ICs can be classified into two main types:

• Random Access Memory (RAM): RAM stores data that can be read, written, and erased. Data in RAM is lost when the power is turned off. RAM is used to store data that is currently being used by the computer, such as running programs and data that is being edited.
• Read-Only Memory (ROM): ROM stores data that can only be read, not written or erased. Data in ROM is written into the chip during manufacturing and cannot be changed afterward. ROM is used to store the computer's boot program, BIOS, and other data necessary for system operation.

Components
Memory Cell
The memory cell is the basic unit of memory in integrated circuits, responsible for storing information in the form of bits (0 or 1). Each memory cell is composed of the following main components:

• Transistor: Transistors are semiconductor components that play a key role in storing and reading data. Two common types of transistors used in memory cells are MOSFETs and bipolar junction transistors (BJTs).
• Storage Structure: The storage structure is where the bit value (0 or 1) is stored. The most common storage structure is the bistable structure, which uses two stable states of the transistor to represent the two bit values.
• Access Circuit: The access circuit provides the ability to read and write data to the memory cell. The access circuit includes transistors and logic circuits to decode addresses, select the memory cell, and control data read/write operations.

Operation of Memory Cells
The operation of a memory cell depends on the type of storage structure used. Here is a description of how a bistable memory cell using MOSFETs operates:
Storing Data:

• To store a 1 bit, a voltage is applied to the gate of the first MOSFET transistor, causing it to conduct and create a current flow through the transistor. This current changes the voltage on the capacitor, creating a stable state that stores the 1 bit.
• To store a 0 bit, no voltage is applied to the gate of the first MOSFET transistor, causing it not to conduct and no current to flow through the transistor. The voltage on the capacitor maintains the current state, storing the 0 bit.

Reading Data:

• To read data, a voltage is applied to the gate of the second MOSFET transistor. This transistor conducts and allows current to flow, depending on the voltage on the capacitor.
  • If the capacitor is charged (storing a 1 bit), the current will flow through the second MOSFET transistor, generating a voltage at the output that represents a 1 bit.
  • If the capacitor is not charged (storing a 0 bit), no current flows through the second MOSFET transistor, and the voltage at the output represents a 0 bit.

Writing Data:

• To write data, a voltage is applied to both gates of the MOSFET transistors. This voltage changes the voltage on the capacitor, overwriting the new bit value into the memory cell.

Significance and Purpose of Memory Cells
Memory cells play a crucial role in integrated circuits, enabling the storage of information essential for circuit operation. Common types of memory that utilize memory cells include:

• Random Access Memory (RAM): RAM stores temporary data that can be read and written multiple times. RAM is used to store data that is currently being processed by the CPU or other parts of the computer.
• Read-Only Memory (ROM): ROM stores fixed data that can only be read. ROM is used to store the computer's boot program, BIOS, and other data that does not need to be changed.
• Flash Memory: Flash memory is a non-volatile type of memory that can be read, written, and erased multiple times. Flash memory is used in flash drives, memory cards, and other portable storage devices.

In addition, memory cells are also used in applications such as:

• Digital Signal Processors (DSPs): DSPs use memory cells to store data and filters required for signal processing.
• Microcontrollers: Microcontrollers use memory cells to store programs and data necessary for controlling peripheral devices.

In summary, memory cells are essential components of integrated circuits, playing a vital role in storing information and supporting the operation of various electronic devices.
Address Decoder Circuit
Function
An address decoder circuit is a crucial component in integrated circuits (ICs) responsible for converting binary code into control signals to activate the corresponding functional blocks within the IC. With the help of an address decoder circuit, ICs can perform complex functions such as accessing memory, performing calculations, communicating with peripheral devices, and much more.
Components and Operation of Each Component

1. Comparator Array:

• Consists of logic comparators that compare each bit of the input binary code with the address values stored pre-programmed inside the IC.
• Each comparator has two inputs:
  • Data input: Receives the corresponding bit from the input binary code.
  • Address input: Receives the corresponding address value stored pre-programmed in the IC.
• The comparator output is high if the two input values match and low if they do not match.

1. Logic Circuit:

• Combines the comparison results from the comparators to generate control signals for the functional blocks.
• Utilizes logic gates like AND, OR, NOT to process the comparison results and generate the appropriate control signals.
  • For example, if the input binary code indicates a specific memory location, the logic circuit generates a control signal to activate the transistors that access that memory location.

1. Buffer:

• Amplifies and stabilizes the control signals before sending them to the functional blocks.
• Ensures that the functional blocks receive clear and accurate signals for precise operation.
• Minimizes noise and ensures system reliability.

Overall Operation

1. The address decoder circuit receives an input binary code.
2. Each bit of the input binary code is compared to the corresponding address value in the comparator array.
3. The comparison results from the comparators are fed into the logic circuit for processing.
4. The logic circuit combines the comparison results and generates the appropriate control signals for the functional blocks.
5. The buffer amplifies and stabilizes the control signals before sending them to the functional blocks.
6. The functional blocks receive the control signals and perform their corresponding functions.

Significance and Purpose
Address decoder circuits play a critical role in controlling the operation of integrated circuits. Because of them, ICs can perform numerous complex functions accurately and efficiently. Some specific applications of address decoder circuits include:

• Memory: Selecting a specific memory location for access.
• Processor: Selecting the instruction code to execute.
• Peripheral Controller: Selecting the peripheral device to communicate with.
• Decoder Circuit: Converting binary code into analog signals.

How it works:
An address decoder circuit works by receiving an input binary code and converting it into control signals for the corresponding functional blocks within the IC. The input binary code can represent a memory address, a register location, or any other information needed to identify the functional block that needs to be activated.
Significance and Purpose:
Address decoder circuits play a vital role in controlling the operation of integrated circuits. With the help of address decoder circuits, ICs can perform complex functions like memory access, calculations, peripheral device communication, and much more.
Buffers in Integrated Circuits (ICs)
Concept
A buffer is an electronic circuit that amplifies an input signal without altering its waveform or amplitude. In other words, a buffer strengthens a weak signal so that it can be used by other circuits, while also isolating the signal from noise and loads.
Structure
Buffers are typically constructed using transistors arranged in a voltage or current amplification configuration. These transistors are connected together in a specific structure to create the function of amplifying the input signal.
Operation
Buffers operate based on the principle of amplifying the input signal. The input signal is applied to a first transistor, and then amplified through subsequent transistors until it reaches the desired voltage or current level. This amplification process occurs without changing the waveform or amplitude of the input signal.
Classification
Based on their primary function, buffers are classified into two types:

• Voltage Buffer: Amplifies the voltage of the input signal.
• Current Buffer: Amplifies the current of the input signal.

Applications
Buffers are widely used in electronic circuits, especially in integrated circuits (ICs). Some common applications include:

• Signal Isolation: Helps protect signals from noise and loads.
• Signal Strengthening: Enables weak signals to be used by other circuits.
• Impedance Conversion: Matches the impedance of the signal to the impedance of the other circuit.
• Interconnecting Different Circuits: Connects circuits with different voltage or current levels.

Examples

• Operational Amplifier (Op-amp): A common type of buffer, amplifies voltage signals, inverts signals, compares voltages, and performs basic mathematical operations.
• Bus Buffer: Amplifies signals on the data bus, ensuring accurate, undistorted signal transmission.
• Output Buffer: Amplifies the output signal of an IC, providing enough current to drive the load.

Advantages

• Increases signal strength.
• Isolates signals from noise and loads.
• Converts impedance.
• Connects different circuits.
• Protects signals.

Disadvantages

• Introduces signal delay.
• Increases power consumption.
• May alter signal distortion.

Read/Write Control Circuit in Integrated Circuits (ICs)
Detailed Structure

1. Address Decoder:

• Decoder Type:
  • Combined Address Decoder (CCD): Utilizes logic gates to decode the binary address into control signals for rows and columns in memory or registers. Advantages: simple, saves chip area. Disadvantages: slower decoding speed.
  • Hierarchical Address Decoder: Employs multiple small decoders arranged in a hierarchical manner to decode the binary address. Advantages: faster decoding speed. Disadvantages: more complex, consumes more chip area.
• Decoder Size: Depends on the memory capacity or the number of registers to be accessed. For instance, a 256-byte memory requires an 8-bit address decoder, while a 64KB memory needs a 16-bit address decoder.

1. Chip Select:

• Logic Gates: Uses AND and OR gates to combine control signals from the CPU, DMA, interrupts, and other sources.
• Control Signals:
  • Chip Select (CS): Enables or disables internal IC circuits upon receiving a high signal.
  • Read Enable (RDEN): Allows data reading from the IC.
  • Write Enable (WREN): Allows data writing to the IC.

1. Read/Write Controller:

• Logic Circuit: Employs flip-flops, logic gates, and a finite state machine to generate read (RD) and write (WR) control signals.
• Access Mode:
  • Synchronous: Data is transferred into or out of the IC along with the clock pulse.
  • Asynchronous: Data is transferred into or out of the IC without a clock pulse.
  • Single Cycle: Data access completes within one clock cycle.
  • Multi-Cycle: Data access requires multiple clock cycles to finish.

1. Data Buffer:

• Type:
  • Register: Stores data as voltage signals on transistors.
  • Flip-Flop: Stores data as the state of a latch.
• Capacity: Depends on the data bus size and the number of bytes to be temporarily stored.

Detailed Operation

1. Access Request:

• The CPU or external device sends an access address and control signals to the system bus.
• The access address identifies the specific location in memory or a register to be accessed.
• The control signals indicate the access type (read or write) and access timing.

1. Address Decoding:

• The address decoder receives the access address and decodes it into row and column signals to determine the specific location in memory or a register.

1. Chip Select:

• The chip select checks the control signals to determine if the access request is intended for the IC or an external device.
• If the request is valid, the "chip select" signal is asserted to activate the internal IC circuits.

1. Access Validation:

• Other control signals (like RDEN and WREN) are checked to ensure access is allowed.

1. Read/Write Control:

• The read/write controller generates RD and WR signals to control data read or write operations.
• It determines the timing and method of data access based on the memory or register access protocol.

1. Data Access:

• Data is read from or written to the memory or register at the location identified by the address decoder.

1. Data Buffer:

• The data buffer temporarily stores data during access to reduce noise and ensure data integrity.

1. Data Transfer:

• Data is transferred from the data buffer to the system data bus for the CPU or external device to read or write.

Advanced Example of Read/Write Control Circuit Operation in an IC

1. Reading Data from Memory:

• The CPU sends memory address 0x1234 and a read signal (RD) to the system bus.
• The address decoder of the memory IC decodes address 0x1234 into row select 4 and column select 12.
• The chip select checks the "chip select" signal and other control signals to ensure valid access.
• The read/write controller generates an RD signal to activate the read operation.
• Data from the memory cell identified by address 0x1234 is read and stored in the data buffer.
• Data is transferred from the data buffer to the system data bus.
• The CPU receives the data from the data bus.

2. Writing Data to a Register:
· The microcontroller sends register address 0xABC and a write signal (WR) along with data 0x5F to the system bus.
· The address decoder of the microcontroller IC decodes address 0xABC into the specific register select signal.
· The chip select checks the "chip select" signal and other control signals to ensure valid access.
· The read/write controller generates a WR signal and transmits data 0x5F to the selected register.
Many Sources

Me and my buddy tried to do some kind of a multi superstar mode, we cooked a new show, and i would only fight matches that involved my chosen superstar(A custom CAW) and my buddy took Bobby Lashley as his guy
So far the story:
(At this point automatic rivalries are on)
First week we are jobless, none of us get booked,
Second week Bobby gets matched with Akira tozawa(ARIGATOOOOOOOOO), Wins, i get booked against another CAW i created, my guy is a lightweight technician and the other guy is a massive highflyer, he superplexes me off the top rope and the ring breaks, we pop as we thought this was only possible by two massive guys
Third week Bobby gets matched with Tozawa again, wins again i am jobless again.
Fourth week im tag matched with the same guy, the Ringbreaker, that broke the ring with my feather spine, against Andrew Tate(Dont ask) and Demon Finn Balor, we win
at this point a ple is coming ahead, and we still have no champs, so we set up a match with Bobby going for NWO championship and me going after IC championship, Bobby wins (At this point we are playing by 'if we have a 1v1 match we both play but the guy controls his character and i control the other guy, but if its a tag team we team up) The IC championship is going up, and im put against the Ringbreaker, I have move thief payback and i didnt see that he has brass knuckles payback, i get DQ, noone gets the belt
Week after PLE, Bobby is again matched with Tozawa. We finally turn off auto rivalries, i am injured(i guess i hit those knuckles too hard) (AUTO RIVALRIES ARE OFF)
I set up a rivalry between Bobby and another CAW which ill name 'Gosha', and they start duking it out, first week after the rivalry is set up its instantly a championship match,and i tried to be Montez ford as the manager, however the legend ai just sweeps the floor with Bobby and takes the belt
(ON THE SIDESTORIES) Umaga and CM Punk(CAW) is going against Kane and trick williams, Kane has the goddamn Undertaker and Paul Bearer as his managers(Neither taker not Paul are in the show) Money in the bank is won by AI Lebron James(yes) Somewhy he has his mitb target set as the undisputed belt(My exhibition mode mitb target) even though we dont have the belt on the show, so i set it his target as the NWO championship (keep in mind this is the same night when the mitb ladder was happening, and we still have a main event that is Lashley against Gosha for the belt as a rivalry match(literally same match from last week), so we set it up and the main event changes to some sort of announce cash in match but Lebron James only comes up in the middle of the match.
Bobby and Gosha duke it out, it comes to the back and forth minigame, and before we could end it and the spamming punches minigame begins, Bobby Lashleys music hits(??) with the announcers shouting 'Could this be???'
A minute we finish the minigame Lebron(AI) finally shows up, and whoever created this Lebron thought its a good idea to give him a bunch of flip moves, the guy is like 2.5meters, jesus christ. Bobby somehow pulls trough and claims the belt (He pinned Gosha and Lebron just went out of the ring, breaking news, Lebron forgot about cancelling the pin)
Next week its Bobby against Gosha again for the belt, same rivalry actions, and i notice The Ringbreaker having a 1v1 against Umaga, apparently it was supposed to be a 2v2 match but rivalry actions changed it up and i didnt even understand i wasnt going to be there. At this point, the rivalry actions are reallly messing it all up, Bobby has a match with managers, you put on a rivalry action, the managers are gone, you put in the managers manually, the rivalry actions are gone, Bobby retains, i dont get a fight this week, we manually end the rivalry since it didnt end after PLE (We also manually set up a tag team championship on a random 6 man tornado tag, since no other championships are being fought on)
So far the the brand looks like this
Bobby Lashley: NWO heavyweight champion, ~1 week Andrew tate and Demon Finn Balor - WWE tag team champions(The new fancy ones from community) ~<1 week UpUpDownDown championship - vacant IC championship - vacant
so far the rivalry actions are quite clunky, but we had a great time aside from Bobby having to fight Tozawa for 3 weeks in a row and Undashing Cody Rhodes somewhy having 3 matches in one day(man the guy is really working) Any tips on how we could make this campaign better?

I have been working on an SPA with Angular 16, TypeScript and The Movie Database (TMDB).
I am attempting to make an "infinite scroll" feature on one of the components with Angular Virtual Scroll.
For this purpose, I have imported the ScrollingModule and added it to the imports array in app\app.module.ts.
In app\services\movie-service.service.ts I have:

import { environment } from '../../environments/environment'; import { Injectable } from '@angulacore'; import { Observable } from 'rxjs'; import { HttpClient } from '@angulacommon/http'; import { MovieResponse, Movie } from '../models/Movie'; import { GenreResponse } from '../models/Genre'; @Injectable({ providedIn: 'root' }) export class MovieService { constructor(private http: HttpClient) { } public getAllMovieGenres(): Observable { return this.http.get(`${environment.apiUrl}/genre/movie/list?api_key=${environment.apiKey}`); } public getMoviesByGenre(id: Number): Observable { return this.http.get(`${environment.apiUrl}/discovemovie?api_key=${environment.apiKey}&with_genres=${id}`); } } 

In the MoviesByGenre component I have:

export class MoviesByGenre { constructor( private activatedRoute: ActivatedRoute, private movieService: MovieService ) { } public genreName: string undefined = ''; public movieResponse!: MovieResponse; public movies: Movie[] undefined = []; public genreResponse!: GenreResponse; public genres: Genre[] undefined = []; public getMoviesByGenre(): void { // Get genre id (from URL parameter) const genre_id = Number(this.activatedRoute.snapshot.paramMap.get('id')); // Get genre name from genres array this.movieService.getAllMovieGenres().subscribe((response) => { this.genreResponse = response; this.genres = this.genreResponse.genres; if (this.genres && this.genres.length) { let currentGenre = this.genres.find(genre => genre.id === genre_id); if (currentGenre) { this.genreName = currentGenre.name ''; this.movieService.defaultTitle = this.genreName; } } }); // Get movies by genre id this.movieService.getMoviesByGenre(genre_id).subscribe((response) => { this.movieResponse = response; this.movies = this.movieResponse.results; }) } ngOnInit() { this.activatedRoute.params.subscribe((params: Params) => { const id = params?.['id']; this.getMoviesByGenre(); }); } ngOnDestroy() { this.movieService.defaultTitle = ''; } } 

In the component's template:

As can be seen above, I do not have all the items in the movies arary available from the start.
Further more, the initial 20 movies that would be displayed in the absence of are not displayed at all.
Stackblitz

What am I doing wrong?

I’m creating this post to assist newcomers in setting up HDR support on Linux using Plasma 6. I’ve encountered partial and use-case answers, and the wiki isn’t exactly coherent. Hopefully, this guide will help someone (or preferably many people) get HDR working without spending hours on Google, Bing, and Copilot searches. Also, I used Copilot to make this more legible after typing it out. So, if bits of it sound like AI, it’s just rephrasing something I said.
IMPORTANT:

• The commands provided assume you are using Manjaro or at least Arch. These distributions are known to be excellent for gaming until SteamOS 3 is generally released.
• If you’re using a different distribution (e.g., Ubuntu), adapt the commands accordingly. For instance, replace pacman -Syu with sudo apt update && sudo apt upgrade -y.
• Be proactive but ask for help if you can't find your distros equivalent.
• Give the wiki a read anyway, the more you read the more you’ll learn. Even if it doesn’t make much sense https://wiki.archlinux.org/title/Gamescope

Instructions:

1. Check Display Settings:
   • Go to Settings > Display & Monitor and look for an HDR option. If it’s there, skip to step 5.
   • If no HDR option appears, proceed to the following fixes.
2. Ensure You’re Using Wayland:
   • Wayland supports HDR, while Xorg (X11) does not.
   • Check your current graphics platform under Settings > About This System > Graphics Platform.
   • To switch to Wayland:
     • Go to Settings > Colors and Themes > Login Screen (SDDM) > Behavior (top right).
     • Set Auto Login to use Wayland.
     • Restart your system. (There might be alternative methods; feel free to comment if you know one!)
3. Driver Caution:
   • Switching to Wayland may break your drivers.
   • If so, run the following commands and restart: sudo mhwd --remove pci video-nvidia && sudo mhwd -i pci video-nvidia
4. Enable HDR:
   • Now that you’re using Wayland with fresh drivers, the HDR option should appear. Refer to step 1.
   • Change settings one at a time or it may not apply correctly (e.g., 1080p > apply > 120Hz > apply > HDR on > apply). KDE can be quirky like that.
5. Install Gamescope:
   • To get Steam games running in HDR, you’ll need Gamescope.
   • Install Gamescope with the following command: sudo pacman -Syu && sudo pacman -S gamescope
   • Enable Steam integration: gamescope -e -- steam
6. Steam Launch Options:
   • Add launch options for the game you want HDR in.
   • For 1080p@120Hz, the launch option might look like: gamescope -W 1920 -H 1080 -r 120 --hdr-enabled -- %command%
     • gamescope specifies the use of Gamescope.
     • The custom resolution and refresh rate are necessary (there’s a reason, but I forgot!).
     • Ensure HDR is enabled in the launch options; otherwise, it won’t work.
7. Testing HDR:
   • After completing the steps above, HDR should work in your game.
   • Keep in mind that the Steam UI will probably be very glitchy at this point. Patience and deep breaths are essential.
   • I tested it with Horizon Forbidden West, and it worked phenomenally once I was in the game.
8. Returning to X11 for Compatibility and Comfort:
   • Repeat Step 2, choosing X11 instead of Wayland.
   • Remove launch options.
   • Voilà, we’re back to square one!

Caveats:

• Using Wayland affects Steam significantly:
  • The store page becomes unusable.
  • The big picture menu (home, settings, etc.) is almost completely broken.
  • You can still navigate with some guesswork.
• Wayland resets display settings on every power-on:
  • Re-enable HDR.
  • Set resolution (if you have a 4K screen, playing in 1080p might result in a tiny box if the desktop resolution is set to 4K).
  • Often restart Steam before launching anything.

TL; DR: Dude it's an instruction set, go back and read 💀

Spots@$Price: 160@$1
Total Price: $160
Make and Model: Spyderco S90V Manix LW
Timestamp and Pics: https://imgur.com/a/vUezs1W
Price Justification: these are getting hard to find. Only comps we can find are 300 days to 1 year+ old on swap. Range is anywhere from 150-185. This one had been sharpened, but comes with deep carry clip.
Escrow: for u/jay3011
Description: Spyderco Manix LW - Cutlery Shoppe exclusive with satin S90V blade, pinned orange FRCP handles, and black deep carry clip (stock clip included). Centered, solid lock up, and drop shut action. This one has been sharpened and seen light use, but is still in excellent condition (as always see pic/vid). Comes with box, doc, etc.
International shipping: N
RULES/NOTES:
SEND PAYMENTS VIA F&F AND DO NOT PUT ANYTHING IN THE NOTES OR KEEP THEM TO THE BARE MINIMUM i.e. ".", "thanks", ETC. ANY OTHER NOTES CAN/WILL RESULT IN AN IMMEDIATE SUB BAN
BE CLEAR AND CONCISE WITH YOUR CALLS. IF YOUR CALLED SPOT IS ALREADY TAKEN IT WILL BE REPLACED WITH A RANDOM UNLESS YOU SPECIFY OTHERWISE. AMBIGUOUS SPOT CALLS WILL BE ASSIGNED USING MY BEST/WORST JUDGEMENT. SPOT CALLS CAN BE DENIED/MODIFIED AT MY DISCRETION
SEND PAYMENT FOR YOUR SPOTS IMMEDIATELY UPON ASSIGNMENT UNLESS OTHERWISE STIPULATED. SPOTS WILL BE REMOVED DUE TO LACK OF PAYMENT AT MY DISCRETION

PayPal Info: https://www.paypal.me/codymurtha1?locale.x=en_US
​
Tip BlobAndHisBoy
Number of vacant slots: 72
Number of unpaid users: 2
Number of unpaid slots: 13
This slot list is created and updated by The EDC Raffle Tool by BlobAndHisBoy.
1
2 s14mcdonald PAID
3 s14mcdonald PAID
4 s14mcdonald PAID
5
6 s14mcdonald PAID
7 s14mcdonald PAID
8 s14mcdonald PAID
9
10
11 Right_Check_6353 PAID
12
13 Safetyman613
14 s14mcdonald PAID
15 Right_Check_6353 PAID
16
17 Right_Check_6353 PAID
18
19 Safetyman613
20 Right_Check_6353 PAID
21
22
23
24 s14mcdonald PAID
25 s14mcdonald PAID
26 Gboogie3 PAID
27 Right_Check_6353 PAID
28
29 s14mcdonald PAID
30 Right_Check_6353 PAID
31 justinL66 PAID
32 justinL66 PAID
33
34 Gboogie3 PAID
35 s14mcdonald PAID
36
37 LimpCroissant PAID
38 s14mcdonald PAID
39
40 s14mcdonald PAID
41 Right_Check_6353 PAID
42 justinL66 PAID
43 s14mcdonald PAID
44 LimpCroissant PAID
45
46
47 Right_Check_6353 PAID
48
49
50
51
52
53
54 s14mcdonald PAID
55
56
57
58
59
60
61
62 s14mcdonald PAID
63
64
65 s14mcdonald PAID
66
67 Safetyman613
68
69 s14mcdonald PAID
70
71 Safetyman613
72 justinL66 PAID
73 s14mcdonald PAID
74
75 Right_Check_6353 PAID
76
77 Right_Check_6353 PAID
78
79 Right_Check_6353 PAID
80 justinL66 PAID
81 Safetyman613
82
83
84 Right_Check_6353 PAID
85 s14mcdonald PAID
86 s14mcdonald PAID
87 Gboogie3 PAID
88
89
90 Safetyman613
91 s14mcdonald PAID
92
93
94
95 Right_Check_6353 PAID
96
97
98 Safetyman613
99 LimpCroissant PAID
100 justinL66 PAID
101 Gboogie3 PAID
102 LimpCroissant PAID
103
104
105
106
107
108 s14mcdonald PAID
109 Right_Check_6353 PAID
110 s14mcdonald PAID
111
112 Safetyman613
113
114
115 s14mcdonald PAID
116 Safetyman613
117
118 Safetyman613
119 justinL66 PAID
120 Right_Check_6353 PAID
121 Right_Check_6353 PAID
122 Safetyman613
123 justinL66 PAID
124 Right_Check_6353 PAID
125 justinL66 PAID
126
127 s14mcdonald PAID
128
129 s14mcdonald PAID
130
131 Right_Check_6353 PAID
132 LimpCroissant PAID
133 Right_Check_6353 PAID
134
135
136 Right_Check_6353 PAID
137
138
139
140 ScottieJ81
141
142 justinL66 PAID
143
144
145
146 s14mcdonald PAID
147 s14mcdonald PAID
148 Right_Check_6353 PAID
149
150
151
152
153 Safetyman613
154 Right_Check_6353 PAID
155 s14mcdonald PAID
156
157 Right_Check_6353 PAID
158 Gboogie3 PAID
159 Right_Check_6353 PAID
160 Right_Check_6353 PAID

I have recently migrated an Excel database to MySQL and am having some issues when using a formula like VLOOKUP when my lookup value is ONLY a number but works when the lookup value contains both numbers and letters (which occurs often).
For context, this is (part of) my SQL file, which is then loaded into Excel via OCDB and imported into a table with PowerQuery.

CREATE DATABASE IF NOT EXISTS ML; USE ML; CREATE TABLE IF NOT EXISTS MasterList ( `FINISHED_PN` TEXT, `DESCRIPTION` TEXT ); LOAD DATA INFILE 'MasterList.csv' INTO TABLE MasterList FIELDS TERMINATED BY ',' ENCLOSED BY '\'' LINES TERMINATED BY '\r\n' IGNORE 1 LINES; 

TEXT datatypes in the .csv are enclosed by single quotes (apostrophe), with each line separated by a comma.
And then in a separate sheet, I use VLOOKUP to get the corresponding description of a part number:

DESCRIPTION	PART NUMBER
=IFERROR(VLOOKUP(C25,masterlist,3,FALSE), "")	12345
=IFERROR(VLOOKUP(C26,masterlist,3,FALSE), "")	A12345

The first VLOOKUP corresponding to C25 returns #N/A, while the next VLOOKUP corresponding to C26 returns the correct description. Through some testing, I've found it only occurs for part numbers that contain ONLY numbers.
The workarounds I've tried do work but on the Excel side, meaning I'll have to modify the data or formulas in Excel, rather than maybe importing the data from MySQL in a different manner.

1. =VLOOKUP(TRIM(C25),TRIM(masterlist),3,FALSE) was one solution that worked, but it would mean that I'd have to modify the VLOOKUP formula on every sheet.
2. "Modify" the 'masterlist' table in Excel by clicking on the textbox of a FINISHED_PN and then just hitting enter without making any changes. Then, the formula I use works but is reset when refreshing the connection.
3. Adding a data validation list of the FINISHED_PN column to the cells in other sheets (my current solution)

Is there a better solution to making this external database work how I want with Excel? ie. no additional changes other than import the table and go. I have full access to both the MySQL database and Excel, so I'm open to anything.
I'd appreciate any help!

For context, I’ve seen about every wamilitary movie under the sun. This is not a joke post.
I watched Starship Troopers last night for the first time in at least 15 years, and part of its success in holding up as a really really good satire is its depiction of the brutality of war.
Paul Verhoeven’s direction is excellent in building this fascist-propagandist world up to the point where by the time the soldiers are sent to Klendathu to kill some bugs, we the viewers are fully expecting them to kick some ass. But what Verhoeven does especially well in this sequence is showcase the FEAR and horror of the reality these soldiers have not yet been faced with. Everyone, from the starfleet to the ground soldiers have been misled to believe this will be an easy fight, but the bugs are far bigger in numbers and intelligence than anyone ever expected - leading to an absolutely horrifying bloodblath.
The sequence in question begins with a grandiose “Ride-of-the-Valkyrie’s” type action where these soldiers we’ve gotten to know since bootcamp are finally being sent off to war, and the viewer can absolutely feel this nervousness and sense of anxiety as the ships make their way down to the planet. Once on the planet, suddenly characters we know and were expecting to be larger parts of the story are being picked off in brutal fashion. That’s war. No one is a main character. Everything leading up to this moment makes this sudden carnage so shocking and almost heartbreaking, as we see the fear of these young soldiers as they realize they’re dead-meat.
This whole sequence is very effective to me, and even if this is a pseudo-comedy satire about giant bugs, I find it to be one of the most effective battle sequences I’ve ever seen.
What are ya’lls thoughts on this sequence, or in Starship Troopers in general? I find it to be an excellent film

(The information on the three gold companies in this report is not definitive. Instead, this information will drive you to do more due diligence and make an investment decision.)
A different way to invest in gold is to look for great properties. If you bundle the three companies/properties in this piece, you could own three great properties collectively for under CDN2.00 a share.
https://preview.redd.it/r3ojx4rynl0d1.jpg?width=1500&format=pjpg&auto=webp&s=f188257532dc4ca3a50611b50bbde4ffa44ea47c
GOLDEN RAPTURE MINING (GLDR: CSE) is a collection of premier Ontario mining properties in the Rainy River region that have done enough work to unveil potential, below but left a significant amount of gold with great g/t numbers. As of this morning, some numbers will indeed up its profile. Considering the stock has been listed for about two weeks, these results are excellent. Forgive the length of the table, but given the quality of the results, investors must get the whole picture.
https://preview.redd.it/fzy13fb0ol0d1.png?width=833&format=png&auto=webp&s=a844bbabf8febd58fa858fe4f4d1b62f89c5f1c6
First, the newest, being listed in the last month, is Golden Rapture Gold. The Company intends to reactivate past mines in the Rainy River area of Ontario. The property is so new that management has only walked about 5% of it, but the numbers are already impressive over its two projects. The Company holds a 100% interest in the high-grade Phillips Township Gold Property, Rainy River District, NW Ontario. The land package totals 225 claim cells for approximately ten thousand acres located close to 4 mineral deposits. These assets include the New Gold Rainy River Mine (+8 million Oz.), the Cameron Lake Deposit (1.8 million Oz.), the Agnico Eagle-Hammond Reef deposit (3.3 million Oz.), the Tartisan Nickel, Copper, and Cobalt Deposit, and many others. Mature local infrastructure, workforce, heavy-duty equipment, hospitals, major highway systems, and local services are nearby.
https://preview.redd.it/jqg05eo1ol0d1.png?width=1135&format=png&auto=webp&s=a02df752577dbd62bddcd872fc131fe7794fce59
Mr. Richard Rivet, CEO of Golden Rapture, commented: “I am incredibly pleased that we have just made some essential and rapid steps toward identifying additional high-grade drill-ready targets. We were pleasantly surprised to discover many high-grade quartz veins on the surface, with the majority of them carrying gold. Unlike many exploration companies, we are not just chasing the typical geophysical anomaly but also many vast high-grade gold structures identified on the surface that can be drilled at any time.
https://preview.redd.it/303n77s7ol0d1.png?width=843&format=png&auto=webp&s=96df5f7ae205367b1a51d30b482d9940c91d0d22
The Company holds a 100% interest in the high-grade Phillips Township Gold Property, Rainy River District, NW Ontario. The land package totals 225 claim cells for approximately ten thousand acres located close to 4 mineral deposits.
These assets include the New Gold Rainy River Mine (+8 million Oz.), the Cameron Lake Deposit (1.8 million Oz.), the Agnico Eagle-Hammond Reef deposit (3.3 million Oz.), the Tartisan Nickel, Copper, and Cobalt Deposit, and many others. Mature local infrastructure, workforce, heavy-duty equipment, hospitals, major highway systems, and local services are nearby.
Ryan Yanch CIM, a director of GLDR, states***, ‘One extremely important fact is that GLDR’s drilling cost is an industry-leading CDN140 a meter. It is not unusual for other gold comp[anbies to spend CDN200-400 or more a meter. One major contributor to this is that one significant cost is the location of the drilling company. 17 km away from the properties significantly lowers the capital cost and allows a more robust drilling program”.***
Given the uniqueness and exceptional quality of GLDR’s properties, there could be excellent investor support. Gold is rallying, and the prospect of further rises may portend in the shadow of interest rate cuts.
Previous work on the properties quickly removes the ubiquitous ‘drill’ on the property or other tropes. These are serious businessmen and women with decades of mining and entrepreneurial experience.
In the world of junior mining IPOs, there is a feeling that the stars must align to profit. Au contraire***. The keys to investing success are the right properties, management, and, in this case, a rallying gold price.***
Numero Deux
https://preview.redd.it/p6h56dz9ol0d1.png?width=479&format=png&auto=webp&s=67770cada4ffa1e689c4611a19309ea0d9eadbfc
Element79 Gold Corp (the “Company”) (CSE: ELEM) (OTC: ELMGF) is a fascinating gold company and the second in our gold triumvirate located primarily in Peru through its flagship Lucero, Peru, property.
(Full Disclosure: James Tworek, CEO of Element79, is an adviser to the GLDR Board. Your humble scribe owns a small position in each Company.)
The past-producing Lucero Mine (“Lucero”) is one of the highest-grade underground mines in Peru’s history, with grades averaging 19.0g/t Au Equivalent (“Au Eq”) (14.0 g/t gold and 373 g/t silver).
https://preview.redd.it/of62jjsbol0d1.png?width=557&format=png&auto=webp&s=63799ac26087364b8afa847435d1ba86de0701d3
In its past 5 years of production, ending in 2005, it produced an average of 40,000oz+/yr.
Assays from March 2023 yielded 21-ore-grade and high-yield up to 11.7 ounces per ton of gold and 247 ounces per ton of silver from underground workings, further validating the potential for a significant high-grade future operation.
Consolidating its focus in this region and its impressive geology, ELEM acquired the Roxana Vein and surrounding 1200ha property, Lucero del Sur 28, via auction held on May 17, 2023. The property is located strategically just east of the high-grade Lucero gold-silver project.
Instead of going into much history, let’s look at the Press release ELEM put out on April 23. New assays were released, and CEO James Tworek stated, “The data obtained is not just promising; it’s the cornerstone upon which our future endeavours will be built,” said James Tworek, CEO of Element 79. “These recent results, coupled with historical data, represent the bedrock upon which we are advancing our Lucero project.”
Corporate Presentation.
https://preview.redd.it/q0peilsdol0d1.jpg?width=800&format=pjpg&auto=webp&s=70ca19204d296b5505017134f9a3238b6d713256
From the PR: A total of 97 samples were sent for assays, 56 of which returned greater than 0.1 g/t gold (up to 8.55 g/t gold and 523 g/t silver. Several samples also were rich in base metals (up to 23.7% lead and 9.9% zinc), all of which underscores the richness of our project, further supporting the Company’s belief a robust resource base can be delineated. (Actual assay numbers are shown in the PR)
James C Tworek further states, “Element79 Gold has transformed from an asset amalgamator and seller to a near-term production story, responding to Peru’s government push for formalizing artisanal mining operations. We at Element79 Gold are thrilled to share our unwavering dedication to bringing our Lucero gold project in Peru into production. This past-producing, high-grade gold and silver mine holds immense potential to revitalize our Company and foster economic growth and prosperity in the region. “
The other ELEM property brings us back to North America. Nevada, to be precise. Reason to pay attention?
https://preview.redd.it/ahbl9b9gol0d1.png?width=504&format=png&auto=webp&s=de8c1fe7b99e4fee542ebd7b57e12b0fb60ddf28
Maverick Springs is adjacent to the Carlin Trend. For the uninitiated, the area contains several of the largest gold mines on Earth. The area includes a number of the largest gold mines on Earth. Maverick Springs is a blind deposit comprising a 30-120 metre thick, flat-lying zone centred on an anticlinal structure with oxidation pervasive to 120 metres and intermittent to 270 metres. (5)
West Whistler property is in the same area as Maverick, closer to the Battle Mountain Trend, alongside Carlin: Near several gold deposits, including the Cortez Mine, North America’s third largest gold mine with 2021 gold production of 828,000 ounces.
Finally, the Clover Property, 16 km west of the massive Hecla Mine in the Northern Nevada Rift. The property sits at the top and centre of the Carlin and Battle Mountain Trends.
Nevada Gold’s active Turquoise Ridge Mine, the third largest gold mine in the United States with 537,000 ounces of gold production reported in 2020, as well as the Twin Creeks open pit mines and the dormant Pinson and Getchell mines.
Element 79 has drilling programs announced for the 2023/24 years and a more vigorous program for 2024/25.
https://preview.redd.it/jm0ixwjhol0d1.png?width=943&format=png&auto=webp&s=e54f1368dac6eb4b173daed8f101989cd1ff26de
As (GoldSilver.com) an aside, the gold price—and silver—have softened after particularly gold had a decent run. The first two in our group have slid a bit but seem to be holding in nicely.
If one follows gold forecasts, the pundits call for USD 2500-3000 over the next few years. The strategy is simple: A move to USD 3,000 represents a 50% appreciation. However, that also comes with physical and liquidity issues should you want to sell.
And the Gold price?
On December 30, 2022, gold closed the year at $1,819.70 per ounce. Flash forward to one year later, and gold closed 2023 at $2,062.40. That’s a gain of 13.3% in a single year.
With gold pushing to new record highs, it’s a fascinating time for gold investors.
Predicting the future of gold prices is never easy, but to offer some insights into what 2024 might hold, we’ve (compiled an array of gold price forecasts, outlooks, and predictions from renowned banks, industry experts, and financial analysts.
Let’s take a look.
https://preview.redd.it/hvtfmvojol0d1.png?width=1270&format=png&auto=webp&s=e010811fe9a82a92ebcfbce86a0b8ef1a3ca60f8
Numero Three
https://preview.redd.it/c3piq1qlol0d1.png?width=368&format=png&auto=webp&s=5e03a374e70713d3d9c1d284149582b1bef3797d
Off we go to South America. This time, Columbia with SOMA Gold. (TSXV: SOMA) (WKN: A2P4DU) (OTC: SMAGF) (the “Company” or “Soma“) recently announced that gold production for Q1 2024 was 7,335 AuEq ounces, an increase of 8% over the same period in 2023.
Let’s not get ahead of ourselves.
https://preview.redd.it/zs05p1jnol0d1.png?width=625&format=png&auto=webp&s=2495c1d6df13c2ef31100c031528f8e970d8940d
The Company owns two adjacent mining properties in Antioquia, Colombia, with a combined milling capacity of 675 tpd. (Permitted for 1,400 tpd). The El Bagre Mill is currently operating and producing. Internally generated funds are being used to finance a regional exploration program.
https://preview.redd.it/3oy5cbapol0d1.png?width=872&format=png&auto=webp&s=f777cb52c01985d3c554fabc0cd2eb42ca45cd89
Soma is further ahead than our previous companies, which doesn’t make it better; it is just a different stage of development.
Corporate Presentation, 2023 results, Tech Report.
https://preview.redd.it/39o70anqol0d1.png?width=729&format=png&auto=webp&s=d3542994b4fcfb9fdc0ee7150497a8df2bd2d448
Properties
Cardero Mine

• The 84 thousand tonnes (kt) production rate in 2022 will ramp up to a peak mining production rate of 248 kt (680 tpd) in 2024. Achieving the planned peak production rate of 248 kt per annum would allow the Company to restart its previously operating El Limon Mill, with feed from Cordero in late 2023.
• El Bagre Gold Mining Complex is located approximately 167 km northeast of Medellín in the Department of Antioquia, Colombia. Soma produced 23,115 ounces of gold at its El Bagre Mill in 2022, an increase of 30% from the previous year. Soma’s production forecast for 2023 is for a further 50% increase to 35,500 ounces of gold produced.
• In addition to its operating El Bagre Mill, Soma owns the 225 tpd Limon Mill, which is located 47 km south of the El Bagre Mill. The Limon Mill has been on care and maintenance since 2020 but will be restarted when production from the Cordero Mine exceeds the capacity of the El Bagre Mill.
• The Limon Mill operates similarly to the El Bagre Mill with two-stage crushing, ball milling, gravity concentration, flotation, cyanidation, Merrill Crowe precipitation, and smelting to produce doré. The mill was upgraded in 2017 to a capacity of 225 tpd and is permitted for up to 400 tpd.

As mentioned, these three companies are similar in that they have what appear to be skookum properties. They are also all great gold proxies, and they all trade for under CDN1.00. Cheekily, I may have said that investors can own all three companies for under CDN 2.00 a share.
While I like the companies, I would buy them for their land positions. All have land that isn’t some dust pit but has either historical or proven assays. And most are near large producers. Element79; Nevada.Carlin Trend? Seriously?

I'm trying to automate the creation of some lists based on data entered in a separate table. Looking at the attached image, we have a table with some cue numbers, instruments, and a number corresponding to how many parts the instrument has on the cue (in this case, either 0, 1, or 2, but the values could be higher).
Underneath this table is a summarized list of which instrument has a part on which cue. The extra kicker though is that if something has more than one part, I'd like that listed as well. Is this possible? I essentially want to know if there's a way to automatically and dynamically create the list shown on the bottom (B29:E43) using the table on top (A1:E25).
Edit: here's a link to the spreadsheet itself https://www.dropbox.com/scl/fi/aanfpcuvzyd5lgke1p29p/Auto-List-Sample.xlsx?rlkey=1xocbnaw0ky8m86emo6s2fszf&dl=0
https://preview.redd.it/gtos2bhlnl0d1.png?width=972&format=png&auto=webp&s=ec5fad0165af29afa32885e48b7fdbcc1bcc260e

My girlfriend recently bought a refurbished iPhone off a reputable online phone selling shop called backmarket. Upon receiving the phone she found it did not work as intended and had major problems with camera. She sent it back and eventually they sent a 2nd phone free of charge. Upon receiving the 2nd phone the phone completely broke and was unable to make any calls or use data, along with this the battery on the device deteriorated incredibly quickly. This time she said she wanted a refund. She spoke through email to someone who appeared to be a middleman between her and the seller. The middleman said she could ask for ANOTHER phone or send the iPhone back to the seller where it would be up to him if she got a refund or not (What?). She decided she just wanted a complete refund. We sent the phone back and today we received this email.
“I hope this message finds you in excellent health and high spirits. I regret to inform you that the seller has received your device, but they have informed us that it does not match the device they originally sent you. The product they dispatched to you after replacement, had IMEl *********** , whereas the product they received from you is identified as a DEMO unit and only contains a serial number. Please see the attached photo for reference. Could you kindly verify if there has been any confusion on your end and ensure that the correct device is sent to the seller?”
It appears that they’re trying to scam her. She spent a lot of money on this phone and I was wondering if there is anything I can do or say to try and help get her her money back

After seeing the new exotic previews, I felt that bungie might need a set of ideas for actually designing exotic armors, or even just to buff a bunch of the older ones.
You'll never guess which class I main.
First up is Titans
Mask of the Quiet One - Dreaded Visage: Being critically wounded creates an improved Overshield(50 hp in PvP/150 hp in PvE). Defeating combatants feeds into your Overshield and regenerates it. While Bastion is equipped, defeating enemies with Void damage refunds your Class ability(10% per kill).
Khepri's Horn - Solar Rampart: Grants two Melee Charges. Ignition kills grant additional Super energy(5% more), and kills with your Consecration refund full melee energy.
Helm of Saint-14 - Starless Night: You and your allies can shoot through your Ward of Dawn.
Cadmus Ridge Lancecap - Lancer's Vigil: While using a Stasis subclass and behind your rally barricade, rapid precision hits and combatant final blows with a Stasis weapon creates a Diamond Lance near you. Diamond Lance does significantly increased damage against majors and bosses(200% damage increase).
No Backup Plans - Force Multiplier: Shotguns deal increased damage(5% PvP/20% PvE) while this exotic is equipped. Kills with shotguns grant stacking damage resistance(10%/20% per kill in PvE), stacking up to 3 times for 15 seconds. While at max stacks, combatants will be less accurate when targeting you(similar to the Always on Time Sparrow). Finishers while you have Armor Charge grant ammo to your Shotgun(5% reserves per charge).
Actium War Rig Auto-Loading Sink: Steadily reloads a portion of your equipped Auto Rifle's or Machine Gun's magazine from reserves. Rapid combatant kills(3) refund Machine Gun ammunition(10% of magazine) and grant Auto Rifles increased damage(20%) for 10 seconds. Auto Rifles and Machine Guns stun Overload Champions.
Mk. 44 Stand Asides Seriously, Watch Out: Increases Sprint Speed. Sprinting regenerates health(equivalent to the speed of 70 Recovery). Sprinting while Amplified rapidly regenerates health(equivalent to Restoration 2x) and creates an aura of Arc static around you(around 10 meters). Enemies within this static are Blinded for 8 seconds.
Next is Hunters
Wormhusk Crown Burning Souls: Dodging grants Restoration 1x for 5 seconds. Kills against Scorched, Jolted or Blinded, Weakened, Slowed or Frozen, or Unraveled targets grant significantly increased Class Ability regeneration(200% PvP / 400% PvE) for 3 seconds.
Blight Ranger Voltaic Flow: Amplified grants damage resistance(10% PvP / 20% PvE). Speedbooster lingers for the remaining duration of Amplified. Additionally while Amplified, periodically restores a small amount of health and shields.
Sealed Ahamkara's Grasps Nightmare Fuel: Your Melee becomes a release of raw energy which inflicts a debuff according to your equipped subclass(Scorch/Blind/Weaken/Unravel/Slow) and overpenetrates targets. Gain a second melee charge. Kills with this melee ability refund melee energy. (Think of this like the Hunter's version of Flechette Storm)
Khepri's Sting Touch of Venom: Gain increased sprint speed and jump height while Invisible. Additionally while invisible, enemies become finishable for you at 50% health. Finisher final blows spawn a smoke bomb at your feet, which grants Invisibility to you and nearby allies.
Gwisin Vest Roving Assassin: Finisher Final blows decrease the cooldown of your Super(grants 10% Super energy per finisher). Spectral Blades Light Attack damage against Champions, Bosses, Mini-Bosses, and Tormentors increased drastically(500% increase), kills with Spectral Blades extends the duration of Spectral Blades, and entering Stealth does not consume additional Super Energy.
Raiju's Harness Mobius Conduit: Hold your Super button to activate a Super Amplified. While Amplified in this way you deal significantly increased Arc Damage(75% increase damage from all sources) and gain increased damage resistance(75%), for the duration instead of using your Arc Staff.
Bombardiers Parting Gift: Activating your Dodge ability grants a specific effect depending on your equipped subclass. Arc spawns a Web Mine(see the Arach-No modifier) which blinds enemies after it detonates. Solar spawns an improved Swarm Grenade(spawns ~30 seekers). Void spawns an improved Smoke Bomb(spreads Suppression cloud across 10 meters). Stasis spawns an improved Duskfield(think Renewal Grasps radius). Strand spawns 4 Threadlings, which unravel targets.
Last but certainly not least is Warlocks
Skull of Dire Ahamkara Actual Granduer: Void Grenade kills decrease the cooldown of your Super(2.5%-5% on kill). Nova Bomb kills grant Super energy(10% per kill up to 50%). Vortex Nova Bomb has increased duration(+7 seconds) and deals increased damage against Bosses(25%). Cataclysmic Nova Bomb spawns additional seekers on detonation, and deals increased damage to Champions, Mini-Bosses and Tormentors(40%).
Apotheosis Veil Insatiable: Casting your Super grants nearby allies 500% Melee and Grenade ability energy for 10 seconds. When nearby allies cast their Supers, you gain this benefit. Casting your super automatically generates 3 large Orbs of Light at your feet.
Getaway Artist Dynamic Duo: Convert your Arc Grenade into a Sentient Arc Soul and become Amplified. Your Arc Soul duration is tied to Amplified. Additionally, while Amplified the number of Arc Souls you can have active increases to 3. Additionally, your Arc Souls Blind combatants.
Nothing Manacles Scatter Charge: Gain an additional Scatter Grenade charge. Your Scatter Grenades deal significantly increased damage to Champions, Bosses, Mini-Bosses, and Tormentors(400%), and have more seekers.
Vesper of Radius Planetary Torrent: Your rift blinds enemies in a large radius surrounding it(14 meters PvE / 7 meters in PvP). While standing in your rift, successive arc damage Jolts targets. While your Super is full, Rifts you create last for 1 minute.
Sanguine Alchemy Blood Magic: Hold to drain some of your own health over time in order to overcharge your grenade, melee, rift or super(Drains 20% health per 1 seconds). The damage or duration of the ability increases depending on how much health of yours is drained(20% health drain = 25% more damage, up to 100% increased damage - or double damage). Kills with overcharged abilities restores you to full health.
Geomag Stabilizers Close Enough: Converts your Chaos Reach into a single, shortened blast which deals its maximum damage over 2 seconds. Deal drastically increased Arc damage to enemies within 10 meters of you(80%).

Hi,
I have read a bunch of threads and peoples opinions about why they do not tend to understand the London mindset. London is an extremely diverse place with people from all over the world, with football being football, you will see people that support Liverpool and Man United etc in London, even though they have never been to Liverpool or Manchester but support the team for whatever reason. This could be due to a number of reasons such as a family member supported them so they copied them; they were the best team at the time they started watching football; Their favourite player played for them when they were younger etc.
The real difference between these fans and all other fans is that they will have rivalries with other London clubs rather than their traditional rivals for example a Manchester United fan will not care about Man City winning the league for the 4th time (even though it would break United's record of winning three titles in a row) as long as Arsenal do not win the title. They would see Man City winning the title as a lesser of two evils. This might be jarring to fans that are from the area of their clubs but this is the way it is.

This is the companion topic to my topic "Names Frequency for Males in Chabad Engagement Records" https://www.reddit.com/Judaism/comments/1crv1ta/names_frequency_for_males_in_chabad_engagement/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button
I've compiled these top 100 female first names from the marriage engagement announcements for 2,663 couples in the Chabad community, covering a period from the year 2014 to the present day (May 15, 2024). Names are listed in order of frequency, from highest to lowest. Where more than one name shared the same frequency number, I have arranged those alphabetically.
As with my topic for the male first names, the methodology is the same. I have not combined nicknames and diminutives, such as Goldie with Golda or Chanale with Chana, or spelling variations such as Shaina/Shayna/Sheina. Instead, I have recorded the names of individuals exactly as they appeared in the public engagement announcements with the understanding that these are the designated names that these individuals regularly use for self-identification. These names are presented here in descending order of frequency.
Numbers in parentheses that follow each name represent the total number of times the name appeared within the engagement announcements. Additionally, the first five names on the list below also include the percentage of the name represented in the total names compiled.
For some first names on the list, I have additionally shown their appearance as combination names. For reasons of privacy, I have not shown combination names with less than a total of three occurrences.
I present this list with a quote from the first verse and first chapter of Shemot (Exodus):
"And these are the names..." ואלה שמות

1. Chaya (213 / 7.99%): This includes 60 occurrences of Chaya Mushka, and 3 occurrences of Chaya Sara.
2. Chana (120 / 4.50%): This includes 4 occurrences of Chana Leah.
3. Mushky (83 / 3.11%)
4. Devorah (69 / 2.59%): This includes 47 occurrences of Devorah Leah
5. Leah (57 / 2.14%)
6. Rochel (56): This includes 5 occurrences of Rochel Leah.
7. Mushka (55)
8. Sara (55): This includes 3 occurrences of Sara Leah.
9. Chani (51)
10. Rivka (50)
11. Esther (48)
12. Shaina (48)
13. Sarah (47)
14. Nechama (41): This includes 4 occurrences of Nechama Dina.
15. Miriam (40)
16. Rivky (40)
17. Chanie (34)
18. Mushkie (34)
19. Menucha (27): This includes 4 occurrences of Menucha Rochel.
20. Sheina (24)
21. Rivkah (19): This includes 3 occurrences of Rivkah Leah.
22. Mussie (18)
23. Shterna (18): This includes 6 occurrences of Shterna Sara.
24. Gitty (17)
25. Goldie (17)
26. Hindy (17)
27. Rachel (17)
28. Bassie (16)
29. Miri (16)
30. Shira (16)
31. Chanale (15)
32. Chayale (14)
33. Malky (14)
34. Shternie (14)
35. Bracha (13): This includes 3 occurrences of Bracha Leah.
36. Chava (13)
37. Devora (13): This includes 4 occurrences of Devora Lea and 3 occurrences of Devora Leah.
38. Dina (13)
39. Shoshana (13)
40. Adina (12)
41. Esti (12)
42. Yehudis (12)
43. Faigy (11)
44. Fruma (11)
45. Naomi (11)
46. Shayna (11)
47. Batya (10)
48. Malka (10)
49. Mussi (10)
50. Tova (10)
51. Baila (9)
52. Elisheva (9)
53. Estee (9)
54. Esty (9)
55. Moussia (9)
56. Mushki (9)
57. Mussia (9)
58. Shifra (9)
59. Shterny (9)
60. Tzippy (9)
61. Etty (7)
62. Mimi (7)
63. Raizel (7)
64. Raizy (7)
65. Sarale (7)
66. Sterna (7)
67. Yael (7)
68. Yocheved (7)
69. Aliza (6)
70. Brocha (6)
71. Chavi (6)
72. Ita (6)
73. Mirel (6)
74. Perel (6)
75. Rochi (6)
76. Shaindy (6)
77. Tamar (6)
78. Aviva (5)
79. Batsheva (5)
80. Chany (5)
81. Chavie (5)
82. Dassi (5)
83. Devorie (5)
84. Fraida (5)
85. Liba (5)
86. Libby (5)
87. Malkie (5)
88. Michal (5)
89. Mina (5)
90. Racheli (5)
91. Rivkie (5)
92. Rochie (5)
93. Shevi (5)
94. Shevy (5)
95. Simi (5)
96. Tzivia (5)
97. Zelda (5)
98. Ariella (4)
99. Bassy (4)
100. Bayla (4)

A note on the combination names:
The overwhelming popularity of the combination name Chaya Mushka (in addition to all the various forms of the names Chaya and Mushka to be found within the Chabad community) merits special mention due to this having been the name of the Rebbetzin (the wife of Rebbe Menachem Mendel Schneerson). Throughout her lifetime, Chaya Mushka Schneerson was a much-beloved model of kindness to others. When she died in 1988, people in the Chabad community started naming their daughters after her, and thus began the rise of her name to become the most popularly given name to newborn daughters in the community. An excellent article written by Sara Esther Crispe and titled "Chaya'le, Mushka, Mussie... The Impact of Rebbetzin Chaya Mushka" can be found on the Chabad website at this link: https://www.chabad.org/theJewishWoman/article_cdo/aid/472780/jewish/Chayale-Mushka-Mussie.htm
The combination name Chaya Mushka is so popular in the Chabad community that, if I were to include combination names as well as just first names in my listing, the combination name of Chaya Mushka would come in as #4 on the names list. The only other combination name that comes close to Chaya Mushka in number of occurrences is Devorah Leah with 47 occurrences. Separating all the Devorah Leahs from just the single name Devorah leaves Devorah on its own with only 22 occurrences, which would drop Devorah from the top 5.

1. Chaya (156 / 5.85%)
2. Chana (116 / 4.35%)
3. Mushky (83 / 3.11%)
4. Chaya Mushka (60 / 2.25%)
5. Leah (57 / 2.14%)

Note that those top names above, in addition to Chaya Mushka (with 60 occurrences), include Chaya (213) and Mushky (83) separately. Further down on the list in frequency of usage are the names Mushkie (34), Mussie (18), Chayale (14), Mussi (10), Moussia (9), Mushki (9), and Mussia (9).
I've limited my list here to just the top 100 first names, but there are still many more variations of the Rebbetzin's name to be found in the engagement announcements, such as: Chaia, Chaiki, Chaikie, Chaiky, Chayala, Chayaleh, Chayie, Chaykee, Haya, Mouchki, Moussi, Moussie, Muka, Muki, Mushkee, Musia, Musia, Mussy, Musy, and Musya. This is because the name Chaya Mushka is so prevalent in the Chabad community that many girls who were named after the Rebbetzin tended to use diminutives, nicknames, and variant spellings of the name in order to individualize themselves from all the other Chaya Mushkas in their schoolroom.
Other popular name combinations appearing in my listing above also come from the names of notable, honored women in Chabad, such as Nechama Dina (Chaya Mushka's mother), Shterna Sara (Chaya Mushka's grandmother and the mother of Yosef Yitzchak Schneersohn, the sixth spiritual leader in the Chabad-Lubavitch Hasidic movement), Devorah Leah or Devora Lea/Leah (daughter of Shneur Zalman of Liadi, the founder of Chabad).
And, finally, an explanation for the vast popularity of the name Chana (appearing directly after Chaya in the top 100 listing) is most likely due to the fact that Chana was the name of the Rebbe's beloved mother.
(Sending a shout-out to u/hsm3, u/Ok_Ambassador9091, u/joyoftechs, u/sunlitleaf, u/chabadgirl770, u/elizabeth-cooper, u/offthegridyid, u/Blue_foot, u/yodatsracist, u/bezalelle, u/shinytwistybouncy, and u/Delicious_Slide_6883 on account of their interest expressed on my previous postings on names.)

I don't really know whether I should be turning to reddit for advice or not but here I am.
My (25F) partner, Jamie (24F), have been together for just over a year now. She's recently reconnected with an old friend, Don (35M).
I don't consider myself a very jealous person. I can feel jealous on occasion, and I think that's natural. Up until recently I've never really felt off or jealous of any if my partners friendships. I like her friends and will invite them out, etc, if my partner is coming out with me and my friends. Usually, she does the same.
Don is different. I am not "allowed" to hang out with Don or even talk to Don unless Jamie is around. Don had my number due to a medical emergency, and when he text me due to something unrelated I was told under no uncertain terms that I was not allowed to reply. That he had my number for one reason and one reason only. It was then I fount out that Don is apparently the reason Jamie's last long term relationship fell apart.
Which, in my mind was fair enough and made enough sense to me. I wouldn't make things worse or go behind her back to contact him or anything. I was just happy for her because she seemed happy about reconnecting with an old friend.
However, all I feel now is upset and frustrated at the situation. It's now at the point where, despite the fact we've recently moved in together, I see her far less than I did when we lived separately. If she is home, Don's usually there.
Don is always there. If she's not working, she's hanging out with Don. If she's not with Don, they're texting and calling right up until like 3am. If she's ever doing anything now, it's almost always with him.
When she needs help with things, I offer to help yet the response is almost always 'Don's already agreed to it'. This has been getting to me the most, she's asking Don before she even mentions these things to me.
The one that hurt the most was when she was telling me about an incident that had really upset her, and she told me she had called Don about it first.
I'm her partner, why is she going to him first?
Now she's been getting upset because we never seem to spend time together, which bothers me because I'm actually working less at the moment and have been asking her to do things but whenever it gets to the day to go out, or spend time together suddenly Don's asked her to do something. I get home from work and she's out, she doesn't get back until after midnight.
She's adamant that he's just a friend and she would never "see him like that". Yet, something just isn't sitting right with me. I don't see her often enough to know whether she sees him like that or not.
It's been three days in a row now that she's said we'll spend the evening after I finish work together and watch a film and have a nice dinner.
I've only seen her when she's woken me up coming back in at 1am, and seen her asleep as I leave for work.
I just don't know what to do about the situation.
I really love Jamie. I don't know whether I'm just suddenly being jealous and looking too far into this, or whether it is a realissue.
Am I right to feel this way? Or is my unease unwarranted?
TLDR; my partner reconnected with an old friend, who she's admitted was the reason her last long term relationship ended, and now I never see her and feel more like a room mate than her partner.

LESSON EIGHT
You've become increasingly familiar with aspects of Masonese grammar, including verbs and numbers, times and dates. Now, let's begin to engage with day-to-day Masonese that you would need, beginning with a trip to the café. We'll introduce some vocab, go over how to ask questions, and watch Nyo order something from the coffee shop.
U buaem malaesh valothi veg hiepsi sul legina demasiebaski, ktheragra navi og tond, msao og kalishet. Thua, alo kain naba veg masiebaski devestra ath u ve nin, kaiagra veg voye or ejulyet. O sas syrin esos vaiva, prajo hūa nepaish tsema, og vat Nyo sa paishe sitra po emagar sul juli.
Vocab:

• Coffee = juli
• Black coffee = juli denan
• White coffee = juli deblanth
• Latte = juli devaksara
• Tea = khai
• Green tea = khai devera
• Milk = vaksa
• Sugar = her
• Cup = daor
• Take-away = guatage
• Sit-in = psuatsure
• Pastry = elhani
• Hot = khua
• Warm = ansa
• Cool = edha
• Cold = thu
• Iced = enta/veg entos

(Comment below if you'd like any more vocab!)
So, how do we ask questions in Masonese?
Tsoy, ts'o paish tsema hūa da masiebaski?
To ask a question in Masonese, we do not change the structure of a sentence at all. All we do is add the participle tsem, regularly shortened to ts', to the start of the sentence:

• You are going to the shop = u nejo ro emagar
• Are you going to the shop? = ts'u nejo ro emagar?
• I can get you what ~
• What can I get you = ts'a per akun u dūa?

Simply put, create a normally sentence and then add the participle, that is all. Here's some question words to help you out, of course they normally go right at the end of the sentence:

• What = dūa
• Where = lūa
• Why = psūa
• When = ksūa
• Which = kthūa
• Who = thūa (often at the start, replacing a subject pronoun)
• Whose = msūa
• How = hūa
• How many/much = mesk

Let's see Nyo order from the café:

Meritus	Nyo
Tsem thūa ag pthare?
	Katam
Katam, ts'a per akun u dūa?
	Le poposo, ts'a per akun juli denan-ansa?
Bovo, prae ts'sev vaksa
	Pa sev vaksa, me veg her aidē
Nag saki. Ts'u sun tsitra lej?
	Pa, ts'a per akun epanem veg evryas por jath?
Mnos mon, io ts'u ve shof mesk?
	Mon ia, aidē
Dithi. Ia ājan maesos pien
	Prae

Server	Nyo
Who is next?
	Hello
Hello, what can I get you?
	If possible, can I get a warm black coffee?
Of course, definitely without milk?
	Yes without milk, but with sugar please
Not a moment. Do you want anything else?
	Yes, can I get the bread with the cherries on top?
Just one, or how many would you like?
	One of them, please
Excellent. That costs 5m
	Sure

Aidē
Vetım Vö Adonavë Valah Mbaq

This isn't perfect, but I wanted to share some of my thoughts on what a core Press the Attack build on MF will look like in most games. This is a flexible build, so you can still choose any item if certain prerequisites are met.

Core Build

Name	Role	Notes	Build Order
The Bloodthirster	Defensive, Offensive(Trading), Utility, Movement Speed(strut), MF ❤️'s the Damage Profile	The shield helps maintain your "W" strut passive. Core item. Great with enchanter supports.	1-2
The Collector	Core, MF ❤️'s the Damage Profile	AD++, Lethality++, Crit+. Excellent all-around choice.	1-2
Infinity Edge	Core, Damage Stick, MF ❤️'s the Damage Profile	AD+++, Crit+, Crit Damage++. Typically the 2nd or 3rd choice after The Collector.	2-3, 5
Lord Dominik's Regards / Mortal Reminder	Core, Damage, Anti-ArmoAnti-Heal	AD++, Pen+++, Crit%. Opt for Mortal Reminder against heal-heavy champions (Vlad, Lillia, or Darius...).	3-4
Yun Tal Wildarrows	Surprise Bleed, Core	AD++, AD passive++, CRIT++. Stacking bleed passive amplifies damage significantly after acquiring substantial AD.	4-5, or never
Berzerker -> sell for Yoomus / upgrade for Zephyr	Core (End Game), Attack Speed	Transition to Zephyr at end game, if ur rich just sell boots and get and get Yoummus	2-3 -> 6

Alternative Items (Situational)

Name	Role	Notes	Build Order
Edge of Night	Anti-Squishy, Defensive	HP + Spell Shield. Acts like a permanent Morgana spell shield.	3-5 or never
Yommu's Ghostblade / Opportunity	Anti-Squishy, Lane Dominance, Defensive	More damage with Opportunity; better utility with Ghostblade.	1 or never
Serpent's Fang	Anti-Shield	Essential against champs like Riven or teams with multiple shields.	-
BORK	Anti-Tank, On-Hit	Crucial against teams with 2-3 tanks; synergizes with other on-hit items.	-
Essence Reaver	Damage, Sustain, Crit	Used to give CDR, now helps with mana. Fun for builds, but not the top recommendation.	-
GA	Defensive, Endgame Purchase, Good Against Assassins	Can be sold and repurchased as needed based on passive cooldown.	4-5 or never
Kraken Slayer	AD, AS, Damage Passive, ant-tank	Low Health Damage Passive. Losing the crit isn't ideal, but shines in specific game scenarios. on-hit passive can be good vs tanks that you can auto attack while staying safe	1,2 or never
Immortal Shieldbow	AD, Crit, Defensive	Shield Passive, Anti-Assassins. More AD and crit, less lifesteal. Alternative to Yun Tal Wild Arrows/Essence ReaveKraken Slayer.	3-4 or never

Other Mentions

Name	Role	Notes	Build Order
Manamune / Muramana	Offensive, Sustain	AD++, great with Comet for early-game E poke strategy. Best when synergizing with a poke support against non-healing/shield opponents. Still great, but not as important anymore due to Blue Buff being a free passive after 20 minutes.	1, 2, 3
Mercurial Scimitar	Defensive	High AD, excellent against pesky mages like Kassadin.	3, 4, 5

Thanks and hope this chart is helpful.
Best.