I'm building a portfolio tracker on Google Sheets with a worksheet that lists all transactions that have ever occurred.
I would like to include a column that creates a Position ID for bundles of transactions such that all transactions between first purchase of a stock and final sale of of that stock (defined as the cumulative quantity netting out to zero) have the same Position ID.
I would like to include a column that creates a Position ID for all transactions that have occurred between First Purchase & Final Sale (cumulative quantity netting out to zero).
The goal is to be able to differentiate between positions such that I can subsequently measure performance by "bundle".
For example:

Order Date	Stock	Quantity	Cumulative Quantity	Type of Order	Desired Position ID
2022	MSFT	15	15	Buy	MSFT_1
2022	MSFT	10	25	Buy	MSFT_1
2022	MSFT	-20	5	Sell	MSFT_1
2022	MSFT	-5	0	Sell	MSFT_1
2024	MSFT	100	100	Buy	MSFT_2

I have not been able to think of a formula that solves this problem. Help would be appreciated.
I have tried: =IF(D2=0,$B2&"_"&COUNTIF($B$2:$B2,$B2),$B2&"_"&+1)
The problem with this is that it would increment the new Position ID by more than 1 (such that the last row in the table above would be MSFT_5 instead of MSFT_2). I can't seem to think about a way to increment based on the Position ID column because that seems circular.
Actual view of my spreadsheet below:
https://preview.redd.it/yl7a69keyoxc1.png?width=1322&format=png&auto=webp&s=ff9e4abca5c909e81677de4c5bfd144311849456

I had to hold a ruler and a protractor up to my computer to measure things while I was using an online textbook. So I thought, Is there a ruler or other tool on the screen that could help me with this? Does anyone know of any software or apps that can be used on a computer screen as a ruler or protractor? It might make things a lot easier for me while I learn.

Hi everyone,
​
I have been requested by u/Intrepid_Ice1247 to summarise in my own words what the Initial Alexander Technique (IAT) is about and it's approach to dealing with posture.
Originally posted on Posture but re-posted here for bigger reach (hope that's ok).
​
It's a vast topic, so I'll try my best to take on this challenge. I would really appreciate if I could get a feedback as to how well all of you understood the following explanation (or not). Happy to clarify in comments. When commenting, please include a note whether you have heard of IAT for the first time, or whether you have any previous knowledge.
​
Originally developed by Frederick Mathias Alexander and later further explained into detail by Jeando Masoero.
​
IAT is what we call "constructive conscious guidance and control of the individual".
​
"constructive conscious" means that any changes to ones posture are first consciously reasoned out in a way that is constructive. In other words, it's our ability to construct concepts in our mind that when reasoned out can be to our benefit
​
"guidance" is the part of the process when we use the reasoned constructs to direct, or instruct our parts of the mechanism to move in a more desirable way
​
"control" is the part of the process where we visually check whether we managed to achieve to move the parts of the mechanism the way we intended
​
According to IAT, the resulting posture of an individual depends on relative movements of the parts of the mechanism.
​
By mechanism, we mean the entire human body (for simplicity, think the musculoskeletal system - toe to head).
​
By parts, we mean the individual bones articulated with each other [main breakdown would be: lower limbs, torso, which is further divided into lower (pelvis), upper torso (ribcage), mid torso (spine and abdominal cavity inbetween the pelvis and ribcage), upper limbs, neck and head].
​
Under normal circumstances, people don't really consciously think about these movements. They just consider their posture to be the way it is. If we don't use our conscious reasoning as to which part should be in which relative position to the other parts, we are left with what's called unconscious movements of the parts. The parts are still being "instructed" by our minds only not consciously. Another way we refer to it is habitual movements. These habitual movements stem from our feelings (sensory appreciation). Normally, we just move the way we FEEL is best for us.
​
The main discovery of F.M.Alexander is the fact that these habitual movements are wrong. In the sense that if feelings are all we rely on in order to guide our movements, we generally end up with a mechanism that isn't working satisfactorily. We end up with poor posture and mechanism that isn't working as it should.
​
To solve this problem, we can learn to substitute the habitual movements with the reasoned ones. We can literally engineer what should be the desired posture (and therefore how should each part move in relation to the rest of the parts). We can disregard our sensory appreciation and guide ourselves with movements leading to a better functioning mechanism.
​
How does IAT know what is a "desired posture"?
Originally, it was through study of Greek statues (with an extremely astute representation of human mechanism) and later on it has been supported by today's knowledge of anatomy, physics and mechanics. Credit goes to Jeando Masoero.
​
How does the IAT represent posture?
We use bones to identify the position of each part in relation to each other and in relation to an external reference (plumb line / wall typically). Reason being that bones do not change shape when they move around (as opposed to muscles or other soft tissues).
​
How does IAT measure posture?
We don't rely on feelings. Instead we depend on visual feedback, nowadays we use cameras. A simple recording / snapshot of a entire human being (toe to head) on a camera allows us to use measuring tapes, rulers, plumb lines and protractors to exactly identify a position of each part in space. This approach is also absolutely objective. Once a person is photographed, there is no denial of which part is at which position.
​
My "short" introduction into IAT is already pretty long, so I will stop here. However, for those interested, I encourage you to ask questions, which I will happily address. Based on those questions, I may edit the original post to include questions / answers in the post itself.
​
Thanks for your input.

Hi everyone,
I have been requested by u/Intrepid_Ice1247 to summarise in my own words what the Initial Alexander Technique (IAT) is about and it's approach to dealing with posture.
It's a vast topic, so I'll try my best to take on this challenge. I would really appreciate if I could get a feedback as to how well all of you understood the following explanation (or not). Happy to clarify in comments. When commenting, please include a note whether you have heard of IAT for the first time, or whether you have any previous knowledge.
Originally developed by Frederick Mathias Alexander and later further explained into detail by Jeando Masoero.
IAT is what we call "constructive conscious guidance and control of the individual".

• "constructive conscious" means that any changes to ones posture are first consciously reasoned out in a way that is constructive. In other words, it's our ability to construct concepts in our mind that when reasoned out can be to our benefit
• "guidance" is the part of the process when we use the reasoned constructs to direct, or instruct our parts of the mechanism to move in a more desirable way
• "control" is the part of the process where we visually check whether we managed to achieve to move the parts of the mechanism the way we intended

According to IAT, the resulting posture of an individual depends on relative movements of the parts of the mechanism.
By mechanism, we mean the entire human body (for simplicity, think the musculoskeletal system - toe to head).
By parts, we mean the individual bones articulated with each other [main breakdown would be: lower limbs, torso, which is further divided into lower (pelvis), upper torso (ribcage), mid torso (spine and abdominal cavity inbetween the pelvis and ribcage), upper limbs, neck and head].
Under normal circumstances, people don't really consciously think about these movements. They just consider their posture to be the way it is. If we don't use our conscious reasoning as to which part should be in which relative position to the other parts, we are left with what's called unconscious movements of the parts. The parts are still being "instructed" by our minds only not consciously. Another way we refer to it is habitual movements. These habitual movements stem from our feelings (sensory appreciation). Normally, we just move the way we FEEL is best for us.
The main discovery of F.M.Alexander is the fact that these habitual movements are wrong. In the sense that if feelings are all we rely on in order to guide our movements, we generally end up with a mechanism that isn't working satisfactorily. We end up with poor posture and mechanism that isn't working as it should.
To solve this problem, we can learn to substitute the habitual movements with the reasoned ones. We can literally engineer what should be the desired posture (and therefore how should each part move in relation to the rest of the parts). We can disregard our sensory appreciation and guide ourselves with movements leading to a better functioning mechanism.
How does IAT know what is a "desired posture"? Originally, it was through study of Greek statues (with an extremely astute representation of human mechanism) and later on it has been supported by today's knowledge of anatomy, physics and mechanics. Credit goes to Jeando Masoero.
How does the IAT represent posture? We use bones to identify the position of each part in relation to each other and in relation to an external reference (plumb line / wall typically). Reason being that bones do not change shape when they move around (as opposed to muscles or other soft tissues).
How does IAT measure posture? We don't rely on feelings. Instead we depend on visual feedback, nowadays we use cameras. A simple recording / snapshot of a entire human being (toe to head) on a camera allows us to use measuring tapes, rulers, plumb lines and protractors to exactly identify a position of each part in space. This approach is also absolutely objective. Once a person is photographed, there is no denial of which part is at which position.
My "short" introduction into IAT is already pretty long, so I will stop here. However, for those interested, I encourage you to ask questions, which I will happily address. Based on those questions, I may edit the original post to include questions / answers in the post itself.
Thanks for your input.
​

Introduction
If you've delved into the realms of both headphones and speakers, you may have discovered that speakers offer a more immersive and, some argue, superior audio experience. Even Sean Olive, a renowned figure in the Harman headphone field, has said he generally prefers to listen to his speakers. There are many different “virtualization”-software that tries to emulate speaker sounds for headphones but if you’ve tried any of these, you’ll likely have found the result to sound quite horrible.
Fortunately, there's Impulcifer, a program made by u/jaakkopasanen, the guy behind AutoEQ. Impulcifer stands as a free alternative to the expensive solution Smyth Realizer A16, which carries a hefty price tag of $4,695 USD or 5,490 EUR. While it lacks certain features like headtracking and support for Dolby Atmos formats beyond 5.1.2, Impulcifer is still very impressive and more flexible than the A16.
I've assembled this guide for my own future reference and decided to share it here in case others are willing to embark on this journey. Beware though that it will cost you blood, sweat and tears (well not quite but it’ll cost you money, time, and a whole lot of patience). Yet, the rewards are substantial. In the end, you'll get audio quality surpassing even great speaker setups.
Here's why Impulcifer surpasses traditional speakers:

1. Elimination of Room Modes: Unlike speakers, headphones aren't affected by room acoustics, allowing for correction of nulls that speakers can't address.
2. Subbass without expensive sub: It is far easier to get headphones playing sounds down to 20 Hz than it is for a subwoofer. Subwoofer generally needs to be big and / or expensive to get down to 20 Hz at higher volumes.
3. Virtual Room Treatment: Impulcifer can digitally reduce reverb time, eliminating the need for physical room treatment.
4. Neighbor-Friendly Volume: Headphones enable louder listening without disturbing neighbors or other people in the household, unlike traditional speakers.

Following this guide, you can recreate a "true" 2.0, 5.1.2 (Dolby Atmos), or 7.1 setup within your headphones, free from the limitations associated with conventional speakers. By customizing to your own Head-Related Transfer Function (HRTF), the result is an audio experience indistinguishable from a high-end speaker setup, setting it apart from other virtual surround solutions for headphones.

Recommended Equipment

• Headphones: Preferably comfortable open-back ones. Closed backs and uncomfortable headphones will work but may not provide the same illusion of a true speaker setup. I use the HD600, HD800, and Focal Clears.
• Speaker: A single decent speaker is sufficient. Recommended: Swissonic speakers from Thomann.de, particularly the A3- and V-series. These models offer excellent quality for their price. (Refer to measurements by ErinsAudioCorner for A305 and A306.)
• 7.1 Surround DAC (DAC): Can be either an internal PC soundcard or an external device. A stereo DAC suffices for emulating a stereo speaker setup, but this guide will assume you have a 7.1 capable DAC. I use the onboard Realtek audio on my motherboard.
• Headphone Amplifier (HP Amp): Can be integrated into the DAC. Note that Impulcifer requires a stronger Amp than traditional headphone usage if you wish to avoid clipping in all circumstances. I use the FiiO K7 which is “just enough” on the unbalanced output.
• Windows PC: Impulcifer works on Mac and Linux, but this guide requires EqualizerAPO, which is only available on Windows.
• In-ear Binaural Microphones (IEBM): Small IEBMs are essential to fit inside ear canals for personalized HRTF capture. It’s important that they truly are inside the ear canal for the best results. I use a Soundman OKM I with the Soundman D1 interface. OKM Mics, however, needs to be modified to work. I cut off the spikes and sandpapered them down until I could fit them inside my ear canals.
• Room Measurement Microphone (RMM): The go-to option here is the Umik-1 from MiniDSP.
• Microphone Stand: A simple, inexpensive stand suffices. Fasten RMM using tape and zip ties if necessary.
• Marker for Ear Position: Creativity is key. Example: Use sewing thread across the room to mark the exact ear position at the MLP. There is also a webcam alternative over at the Impulcifer guide.
• Bass Shakers: Optional for enhanced enjoyment and subwoofer emulation. I use the Bass Pump III 4 ohm shakers.
• Subwoofer Amplifier: Optional. Recommended power: 50W or higher. (Example: Fosi Audio M04 100W Amplifier)
• AVR: Necessary for decoding Dolby Atmos and DTS:X signals and height channels. Full set of pre-outs required. eARC is necessary if you wish to use your TV as a source. I use the Denon X4400H.
• Audio Interface: Necessary to transfer decoded signals from AVR back to PC. Requires 8+ inputs. (Example: Behringer UMC 1820, which also works as 2x decently strong headphone amplifiers). It would theoretically work with multiple Audio Interfaces that has fewer inputs, but I haven’t tried this personally. Don’t worry about the Analog-to-Digital conversion as this shouldn’t have any noticeable effect on sound quality so long as the Audio Interface is of decent quality.

Cables:

• RCA/Aux cables – For connecting the DAC to speakers and amplifiers, and the Audio Interface to the AVR.
• Speaker cables – For connecting the Bass shakers to the Subwoofer amplifier.
• USB-C cable – For connecting the RMM to the PC.
• HDMI cable – For connecting the PC or TV to the AVR.

Software:

• Equalizer APO
• HeSuvi
• Unlimited VST-plugin
• VB-audio Matrix

Cost Estimate: The cost will depend on what you already have. Provided that you already have a headphone setup and a PC, all you need is a 7.1 Surround DAC, a pair of IEBM and a Microphone stand (approximate cost 150-200 euros). Unless you already have a sufficient AVR the cost to get Atmos will be expensive, however. The cheapest option for that will be buying used and getting the most inexpensive eARC Atmos AVR with pre-outs you can find.

Step 0 – Preparation

1. Ensure all necessary equipment and programs are properly installed and functioning. Confirm that you have everything required to complete the process without interruption.
2. Familiarize yourself with the REW program if you haven't already. Explore all panels and settings to orient yourself.
3. Familiarize yourself with the EqualizerAPO program and the Configuration Editor if needed. Review all options and settings, ensuring correct installation and functionality. Consider removing PeaceGUI if installed, as this guide does not incorporate it and potential interference may occur.
4. Review the Impulcifer guide (https://github.com/jaakkopasanen/Impulcifer) and the HeadFi Thread (https://www.head-fi.org/threads/recording-impulse-responses-for-speaker-virtualization.890719).
5. Position your speakers where you'll primarily listen to the headphones. Ideally, place them at ear height in the room's center for symmetry. Set up a stool or chair at the MLP (Main Listening Position) for easy observation in all directions with your head and body aligned. To properly capture your HRTF you need to turn your whole body and not just your head when looking at different directions.

Now you're prepared to begin the guide.

Step 1 – In-ear Microphone Calibration
For accurate measurements, calibrate your in-ear microphones using the following steps:

1. Obtain your calibrated RMM file from the manufacturer's website.
2. Input your RMM calibration file into REW.
3. Position your in-ear microphones next to your RMM using zip ties or tape for stability.
4. Play a sine sweep on your speaker and measure the response with the RMM.
5. Repeat the process with the left in-ear microphone.
6. Utilize “Trace Arithmetic” to subtract the first measurement from the second to obtain calibration values for the IEBM.
7. Export the calibration values as a .txt or .csv file and input this calibration file for your left in-ear microphone in REW.
8. Repeat steps 5-7 for the right in-ear microphone.

Now you have a pair of calibrated in-ear microphones ready for use in REW. Do note that IEBM aren’t necessarily accurate above 7 kHz and especially above 10 kHz.

Step 2 – Speaker Calibration
While not strictly necessary, calibrating your speaker will enhance accuracy and make later steps easier:

1. Create an RTA measurement around the MLP in REW by playing full-range pink noise. Recommended RTA settings: Mode: RTA 1/48 octave, Smoothing: 1/12 smoothing, FFT Length: 64k, Averages: Forever, Window: Rectangular, Max Overlap: 50%
2. Appearance: Check "Use bars on RTA," "Adjust RTA levels," and "Show peak SPL for tone bursts."
3. Determine your preferred house curve, such as Harman's speaker curves or a traditional -1 dB per octave tilt (resulting in a -10dB tilt from 20 Hz to 20 kHz). Import this curve into REW.
4. Create EQ filters in REW to match the response to your chosen house curve.
5. Export the filter settings as text and use them to calibrate your speaker in EqualizerAPO.

Now you have a calibrated speaker ready for further measurements.

Step 3 – Finding your Personal HRTF
This step isn’t necessary if you're using Impulcifer for headphone correction. However, if you plan to use different headphones with Impulcifer or desire a traditional EQ profile tailored to your HRTF, then follow these steps:

1. Position yourself at the MLP (Main Listening Position), insert your IEBM, and measure your speaker response with your left and right ears individually. Average these measurements.
2. Mark the exact spatial location of each ear. Consider using a mic stand or any creative method.
3. Place your IEBM at the marked positions and measure the left IEBM at the location of your left ear, then repeat for the right IEBM and right ear. Average these measurements.
4. Divide ("A / B") the first averaged measurement by the second averaged measurement, apply 1/12 smoothing.
5. Export the resulting measurement as "HRTF.txt" or "HRTF.csv".

Congratulations! You now have your personalized HRTF (for sounds directly in front of you).

Step 4 – Creating a Personal Headphone Target Curve
Assuming you have generated a HRTF.txt or .csv file and identified a preferred house curve, follow these steps to create a headphone target curve tailored to your HRTF:

1. Import your HRTF.txt file as a frequency response.
2. Import your preferred house curve as a frequency response.
3. Combine ("A * B") the two measurements.
4. Export the resulting measurement as "Headphone Target Curve.txt".

You now possess a personalized headphone target curve suitable for use with any over-ear headphones.

Step 5 – EQ’ing your Headphones
With your personal headphone target curve established, you can now adjust your headphones' EQ to match your speakers' tone closely:

1. Measure each headphone earcup individually with your IEBM.
2. If channel imbalances are negligible, average the two measurements; otherwise, perform separate EQ adjustments for each channel.
3. Under the EQ tab, import your personal headphone target curve as a house curve. Create PEQ filters to align your headphones with your house curve.
4. Export the resulting filters as .txt and import them into APO using the Configuration Editor.

Voila! You now have a personalized EQ profile for your headphones, applicable even with Poweramp Equalizer for Android.

Step 6 – Impulcifer Measurements
Now onto the exciting part that generates the HRIR file, which accurately emulates your speakers. I recommend thoroughly reviewing the Impulcifer guide (https://github.com/jaakkopasanen/Impulcifer) until you feel comfortable with all the instructions.

1. Follow the installation steps outlined in the Impulcifer guide to set up everything you need: Git, Python 3.8 (note that newer versions may not work), and Microsoft Visual C++.
2. The Impulcifer guide allows for either a 7.1 speaker setup, a stereo setup, or a mono speaker setup for measurements. I personally suggest using the single-speaker setup to ensure maximum symmetry between the different channels.
3. Decide on the type of speaker setup you want to emulate. If you're aiming for a 7.1 setup, you can use the angles provided in the Impulcifer guide. For a 5.1.2 or 5.1 setup, I recommend following the Dolby guidelines available here instead (https://www.dolby.com/about/support/guide/speaker-setup-guides/5.1.2-overhead-speaker-setup-guide/). Note that I use a 20–25-degree angle for the front speakers instead of the traditional 30 degrees, as I've found the latter to create a too wide front stage when used with Impulcifer. Similarly, I prefer a narrower setup for height channels compared to Dolby's recommendations, but this is a matter of personal preference.
4. Using a protractor, mark the locations where you'll be positioned when taking measurements. Below is an example assuming a 5.1.2 setup, but the same principle applies to a 7.1 setup as well:

• 25° to the right of the speaker
• 0° facing the speaker
• 25° to the left of the speaker
• 110° to the left of the speaker
• 25° to the right of the speaker, just in front of the Main Listening Position (MLP) on the floor
• 25° to the left of the speaker, just in front of the MLP on the floor
• 110° to the right of the speaker

1. Open CMD and start Python using the following commands:
   cd Impulcifer venv\Scripts\activate
   
2. Insert your IEBM and position yourself at the MLP. Now, proceed to take measurements with Python:
   

o FL (Front Left) – Look 25° to the right of the speaker

python recorder.py --play="data/sweep-seg-FL-stereo-6.15s-48000Hz-32bit-2.93Hz-24000Hz.wav" --record="data/my_hriFL.wav" 

o C (Center) – Look directly at the speaker

python recorder.py --play="data/sweep-seg-FL-stereo-6.15s-48000Hz-32bit-2.93Hz-24000Hz.wav" --record="data/my_hriFC.wav" 

o FR (Front Right) – Look 25° to the left of the speaker

python recorder.py --play="data/sweep-seg-FL-stereo-6.15s-48000Hz-32bit-2.93Hz-24000Hz.wav" --record="data/my_hriFR.wav" 

o SR (Surround Right) – Look 110° to the left of the speaker

python recorder.py --play="data/sweep-seg-FL-stereo-6.15s-48000Hz-32bit-2.93Hz-24000Hz.wav" --record="data/my_hriSR.wav" 

o TMR (Top Middle Right) – Look 25° to the left of the speaker, just in front of the MLP on the floor

python recorder.py --play="data/sweep-seg-FL-stereo-6.15s-48000Hz-32bit-2.93Hz-24000Hz.wav" --record="data/my_hriTMR.wav" 

o TML (Top Middle Left) – Look 25° to the right of the speaker, just in front of the MLP on the floor

python recorder.py --play="data/sweep-seg-FL-stereo-6.15s-48000Hz-32bit-2.93Hz-24000Hz.wav" --record="data/my_hriTML.wav" 

o SL (Surround Left) – Look 110° to the right of the speaker

python recorder.py --play="data/sweep-seg-FL-stereo-6.15s-48000Hz-32bit-2.93Hz-24000Hz.wav" 

Step 7 – HRIR-file Generation with Impulcifer
To generate the HRIR-file, follow these steps within the Impulcifer tool:
1: Navigate to the "my_hrir" folder within Impulcifer and locate the "TMR.wav" and "TML.wav" files.
2: Rename "TMR.wav" to "BR.wav" and "TML.wav" to "BL.wav" to align with Impulcifer's processing of channels as rear surround channels.
3: Next, execute the following command to commence processing:

python impulcifer.py --test_signal="data/sweep-6.15s-48000Hz-32bit-2.93Hz-24000Hz.pkl" --dir_path="data/my_hrir" --target_level=-12 --no_room_correction --no_headphone_compensation --fs=48000 --decay=200 --plot 

Here's what each parameter does:

• target_level: Sets a target gain for the HRIR-file to avoid clipping. -12 will avoid clipping for most circumstances. It doesn’t really matter though as a preamp can be used in APO later regardless.
• no_room_correction: Skip room correction as it was previously applied in step 2 and will be further adjusted in REW in step 8.
• no_headphone_compensation: No headphone compensation applied to create a general profile. Since this guide aims to create a general profile that can be used with different headphones, no headphone correction is desired. You also have the EQ profile from step 5 that can be used in tandem with the HRIR-file for the same results.
• fs: Sets the sample rate of the HRIR-file. Unless you have a very specific reason to change it the default of 48000 should be fine. There aren’t any audible differences between sample rates.
• decay: Adjusts reverberation time to personal preference. This parameter lets you cut down on reverberation time. I can’t tell you what decay-value is best because it is dependent on preference and how your particular speaker measurements. I’ve personally found a value of 200 to work well because it cuts down on bass ringing without reducing the reverb too much.
• plot: Generates plots for measurement visualization. They aren’t strictly necessary but very useful if you want to troubleshoot or are simply curious about your measurements.
• Additional commands and information are available in the Impulcifer guide.

4: Rename the newly generated “hesuvi.wav” file to something appropriate: for example, “5.1.2 Decay 200.wav”
5: In APO, activate HeSuVi by adding the "hesuvi.txt" file (located here: C:\Program files\EqualizerAPO\config\HeSuVi) to APO's Configuration Editor before your headphone EQ-filters.
6: Copy the renamed "5.1.2 Decay 200.wav" file to "C:\Program Files\EqualizerAPO\config\HeSuVi\hrir".
7: Open the HeSuVi GUI and select “5.1.2 Decay 200”.
Now, you'll experience speaker-like sound from your headphones, creating an immersive listening experience.

Step 8 – Fine-tuning with REW
While optional, fine-tuning in REW can enhance your headphone sound further. Potential room modes captured by Impulcifer can be mitigated. A lack of sub-bass can also be fixed.

1. In REW, with both headphone EQ and HeSuVi enabled in APO, measure FL and FR speakers with each IEBM separately.
2. You now have 4 measurements. Sum ("A + B") the measurements of FL and FR speakers respectively. Then average these two summated measurements.
3. Match the combined speaker response to your Personal Headphone Target Curve in the EQ tab, addressing any room modes and sub-bass deficiencies.
4. Export the PEQ-filters as .txt.
5. Import the PEQ-filters into APO, ensuring they're placed after HeSuVi in APO's Configuration Editor

Now, enjoy an enhanced audio experience surpassing traditional speakers when using headphones.

Step 9 – Setting up Atmos Routing
This step is exclusively for those opting for the Atmos route.
1: Connect your source (PC or TV) to your AVR using HDMI. Ensure Dolby Atmos is installed from the Windows store if using a PC. Set the AVR as the default audio device in Windows to transmit Dolby Atmos properly.
2: Ensure all settings in the AVR are neutral: no EQ, compression, or level differences between channels. Set speakers to Large without any crossovers, maintaining equal distances between speakers. Configure your AVR to match your surround setup, e.g., 5.1.2 with a pair of Top Mid Speakers.
3: Connect the pre-outs on your AVR to the inputs on your Audio Interface. For UMC 1820, follow these suggested routings:

• FL > 1
• FR > 2
• FC > 3
• LFE > 4
• Height L > 5
• Height R > 6
• SL > 7
• SR > 8

4: Open VB-Audio Matrix, select your Audio Interface under ASIO Devices, and your Surround DAC under Windows devices. Choose WDM if ASIO isn’t available; MME works but with higher latency and processing costs.
5: Press the Matrix button and route channels accordingly:

• 1 > FL
• 2 > FR
• 3 > FC
• 4 > LFE
• 5 > BL (Height L)
• 6 > BR (Height R)
• 7 > SL
• 8 > SR

6: Select the lowest buffering values for your devices without audio dropouts. The lowest possible values has been working for me, i.e. 8 samples (with safe mode) for ASIO UMC 1820 and 128 samples for WDM for the 7.1 Surround DAC.
With these steps completed, you’ll enjoy “true” Dolby Atmos just like a proper 5.1.2 setup.

Step 10 – Setting up Bass Shakers
Bass shakers are optional but recommended for an enhanced immersion.

1. Connect your shaker(s) to the Subwoofer Amp, then connect the Subwoofer Amp to the LFE channel output on your Surround DAC.
2. In APO Configuration Editor, after HeSuVi, route all channels to LFE using the Copy-function.
3. Set up a Low-pass filter using either PEQ Filters or a variable Graphic EQ. I suggest having the shaker play up to 50 Hz, but your mileage may vary depending on preferences, the shaker’s instalment, and the shaker’s quality.
4. Use the Channel-function in APO, selecting all channels except LFE, and place a decay function under the channel function.
5. Adjust the decay function in APO until shakers feel synchronized with headphone bass. You can play a song with a steady bass line to make it easier, for example the beginning of Sam Smiths “In the City”. When the shakers are poorly matched, they will feel “slower” and more “rumbly”. If they are well matched the shakers will feel more “tight” and “punchy”. In my experience, the shakers will likely be quite late compared to the headphones. I personally use a decay of 102 ms on all channels but the shakers

Done! You will now have an improved bass sound that feels punchy like at the club and in the movie theatres.

Extra 1 – Nearfield Impulcifer Measurements
With your APO setup effectively emulating speaker sound in headphones at the Main Listening Position (MLP), it's important to note the nuances of psychoacoustics. The HeSuVi-profile might not perfectly replicate the sound when sitting very close to the supposed source, like a computer or phone screen. In such cases, creating an additional HeSuVi-profile with Impulcifer can be beneficial. Another scenario is when you need a dry sound, especially for competitive FPS games like Valorant, where hearing subtle details is crucial.
In addition to my regular profile, I've developed a nearfield profile by conducting measurements at less than 0.4 meters. This yields a dry "headphone sound" that maintains a sense of space while enhancing localization, akin to a surround setup. For this profile, emulating a 7.1 speaker setup suffices.
To create this nearfield HeSuVi-profile, replicate Step 2 and Steps 6-8, ensuring the speaker is positioned very close to you. It's advisable to use smaller bookshelf speakers, as larger tower speakers may pose challenges in providing a single point source. Ideally, consider using coaxial speakers such as KEF speakers although smaller bookshelf speakers also work well.

Extra 2 – Different Speaker Setups
Consider creating a 7.1 profile alongside a 5.1.2 profile, allowing you to switch between them based on content type. For example, you can use the 5.1.2 profile for movies and series and the 7.1 profile for games that don't support Atmos. Take additional measurements under Step 6, organizing them into distinct folders for rear channels and height channels to avoid confusion in the processing stage.
Moreover, you can craft a 2.0 profile for platforms like JamesDSP on Android by retaining only the "FL.wav" and "FR.wav" files within the "my_hrir" folder and executing the processing command.

Extra 3 – Multiple People
The downside of having headphones instead of speakers is that it’s a lonesome experience. Personally, while consuming content with someone else the main attraction isn’t really having the best surround sound, so a regular stereo speaker setup is plenty for that. It is, however, possible to use multiple Impulcifer setups simultaneously. For this you will need another surround DAC (and potentially headphone amplifier). To do this you repeat step 3-8 for the other person. Thereafter, you will need to use VB-Audio Matrix to copy the audio from the first surround DAC to the second one. Note that this can introduce some latency for the second surround DAC. To fix this, you can use APOs decay-function to delay the first surround DAC to match the second one.

Extra 4 – Fixing channel imbalances in REW
Ideally, you’d retake the Impulcifer measurements until you get a set of measurements that works just perfectly. This can be difficult though and may take many tries. Some guys over at HeadFi have done upwards of 50+ sets of measurements. Personally, I did around 5-10 sets of measurements before I found out what works best for me. You can try to vary the speaker angle, distance to speaker, different speakers, different speaker placements, etc.
If you want to “fix” (to some extent) an imperfect set of measurement you can use REW to measure individual channels to then match them together. For example, you can measure SL and SR and then EQ the SR to match SL (or vice versa). Note that having a perfectly matched set of opposing channels isn’t necessarily ideal as our ears aren’t necessarily symmetrical.
If you want to measure a particular channel you can use APOs “Copy-function” to route sounds from FL and FR to SL and SR, for example. You should also measure but the left IEBM and right IEBM and then sum (“A + B”) these channels together to get the correct speaker response for that channel.
It’s also possible to fix the timing differences in REW and APO. If you did your measurements with one speaker from the same MLP then this shouldn’t be necessary as all speakers should take the same time to reach your ears. Regardless, you can use the “Use Acoustic Timing Difference” function in REW to measure the delay of different speakers compared to a reference point (the FL speaker for example). You can then fix these delay differences in APO using the “Decay-function”.

Extra 5 – More volume without clipping
Firstly, you should adjust the preamp in APO to avoid any red in the analysis panel to ensure no clipping will occur. For stereo content a positive gain of +12 dB won’t produce any clipping as it shows the summation of all channels. If all surround channels (including LFE) play at full blast simultaneously then clipping could occur but this scenario is highly unlikely.
If you want to be safe though you can use negative preamp values to get the peak gain below 0 dB. After that, you can use the VST-Plugin called Unlimited to drive the volume up while avoiding clipping. I use the following settings:
o Thres: -15 dB
o Out: 0 dB
o CenteLFE/Surround: 0 dB
o Character: 0.0
o Response: 1.0
o Monitor: All
Unlimited needs to be placed after HeSuVi inside the APO Configuration Editor. Also, it will show up as +15 dB gain in the analysis panel but don’t worry, Unlimited will compress when necessary to avoid clipping.

Extra 6 – Graphic EQ instead of PEQ Filters
If you want to use Graphic EQ instead of PEQ-filters it is possible to do so in REW. Instead of using the EQ panel you will import your target curve as a frequency response measurement. Then you subtract (“A / B”) the response you wish to equalize with the target curve. You now get the calibration file (i.e. Graphic EQ values) that can be exported as a .csv file and then imported to APO or Wavelet for example.

As the title suggests. My boss has tasked me to be creative with the current sales meeting process.
Every Monday, we meet and go over the workbook where every member has a dedicated sheet with the exact same format as everyone else with various categories such as 'client meetings, new sales', etc. Each member sets their own monthly target at the start of each month and then every week, we measure how each member is standing up against their own targets.
Issue - Not everyone updates their sheet because it's a bit chaotic and difficult to follow. There are 6 categories and then 52 columns for each week, so it's just a huge mess
There is a dashboard sheet that combined everyone's input but it's just the same format as the other sheets and chaotic.
What I want to do is somehow use microsoft sharepoint/lists to send out weekly reminders to fill in their weekly information, and then maybe use power pivot on the dashboard sheet or maybe send the sheets to Power BI for dashboarding.
I'm open to literally anything. Even sending out a weekly microsoft form and each employee fills in their required info then automate their input into their worksheets.
Your help is appreciated!

Hello everyone, I am a graduate student applying for a medical assistant job to gain experience at PA school. Please give me some advice so I can have a chance to shoot for an MA job. Any advice would be really appreciate. Thank be really appreciated
https://preview.redd.it/9npvjk8pasuc1.png?width=1269&format=png&auto=webp&s=e51c867fea32c8b0054b6f9ddfaf62623e126269

dont get me wrong, i like tiktok and i watch a lot of it, and maybe im just a super negative person but hearing:
legging legs, nose for nose, looksmaxxing, run don't walk, deer pretty, rabbit pretty, toad pretty, tara yummy, mob wife aesthetic, clean girl aesthetic, blueberry nails, hunter eyes, canthal tilt, upper eyelid exposure, sleepmaxx, mogwarts, strawberry makeup, coquette, etc.
makes me wanna run not walk off of a bridge
I do spend a lot of time on tiktok, so maybe i shouldn't complain, and it is a funny app thats very entertaining, and i am guilty of using the bunny/fox/cat/deer pretty filter, and the canthal tilt filter so its not like im any better than everyone else, but its kinda annoyed to always be bombarded with tikoks of ppl hating how they look or how other ppl look, or hating how their ethnicity looks.
Also its just dumb. No one in real life, off of tiktok, actually cares abt if you have hunter eyes or prey eyes. Its not like ur gonna go on a date and the girls gonna pull out a protractor to measure ur canthal tilt. Or if its a guy, its not like hes gonna pull out a picture of a girl with latina makeup and ask you why you look clean girl blueberry nail hailey bieber aesthetic.
anyway maybe im just a hater
its not like I only interact with that stuff it’s just hard not to bump into it, a lot of my fyp is just funny stuff, nature, edits, writing, makeup and classical literature.