Posts by Kate Williams

Greetings!
I recently heard a rumor that when dealing with a recommended delivery, there might be an alternative to having the mail carrier collect cash right at your doorstep; apparently, you can request that the postal service simply deposits the funds directly into your bank account instead.

Does anyone happen to know if opting for a direct deposit is more cost-effective than paying the carrier in person?
Furthermore, would I need to provide a specific type of checking account, or would a standard personal account suffice for this transaction?

Thank you so much!

Bryan Palmer9 said:Back on December 1st, I sent off a small registered package headed overseas to Asia.

According to the tracking number, the package is currently sitting in Washington, D.C., specifically here:

6.12.2017. 4:51:30 USA WASHINGTON, D.C. 10003 Insert item into bag (Otb)

And it hasn't budged since! Does anyone have any idea what on earth is going on with this?

Honestly, don't let those tracking numbers get you worked up; they aren't always the most reliable sources of truth!

I actually had two separate packages arrive in England where the status explicitly stated the customer hadn't even picked them up!
With the first one, my buyer reached out to tell me he had indeed collected it, despite what the system claimed. The second one gave me quite a scare—I spent an entire month in total suspense until the buyer finally contacted me to confirm receipt (and once again, I'll reiterate, the tracking still shows it as undelivered).

It really feels like either someone isn't scanning these barcodes properly, or they simply aren't doing their jobs correctly. That's my take on it.

Greetings!
Whenever I try to send a DVD in an envelope (somewhere in the 50-100g range) to another country, the postal service always charges me at least $12. It seems they automatically classify it as a "priority recommended shipment." This is quite frustrating because I specifically requested that it be sent as a standard LETTER with tracking, which really should have cost much less, perhaps around $4.75!
Is there truly no way to get a better rate than that $36.60?

Greetings! I am currently undergoing some career retraining through my school, and I’ve just been handed a list of thirteen required readings for my fourth year.

I was hoping you all might shed some light on the book titled Transformation; it is actually quite unique because it essentially functions as two novels bound together—the first part being Process and the second being transformation.

If my assignment specifically lists "Franz Kafka: Transformation" as the required reading, would I really need to dive into Process as well? Will my instructors be looking for knowledge from that section, or is the work generally treated as one single cohesive book? 😕

steelowl said:Is it actually possible for someone else—like my mother or father—to take my enrollment verification and renew my supplemental benefits for this year? I already have my proof of enrollment on hand, even though it’s about a month old now, so do you think they might still accept it? I am in quite a rush because my student status is about to expire, and I really don't want to deal with the absolute nightmare of trying to sort this out all the way from the far north if there is any way at all for someone else to handle it for me.

Greetings from Finland! 😬

Yes, absolutely! My mother handled the supplemental filing for me, for herself, and for my father. Since it worked for them, I imagine the process for students should be exactly the same...

lonefalcon41 As expressed by:
Well, if I were in your shoes, I would simply reach out to the doctor or the specialist who issued the referral and ask them exactly which facility you can visit using that authorization! Personally, I went to Quest Diagnostics to have my carotid Doppler performed using a referral, and it was quite straightforward once I asked. 🙂

Thanks Daisy, I just finished up my appointment at Quest Diagnostics!

I find myself wondering where else I might go to get an ENT consultation, besides the Trnje Health Center!
I find that the scheduling at both the Trnje Health Center and the clinic in Aurora just doesn't align with my availability at all! It’s such a hassle when you're trying to stay on top of things. Does anyone happen to know of any other locations where I could go that offer free services with a referral?

vividsailor7 said:Wait, an 8-month wait time???
If you happen to be living in Washington, D.C., you should find that your turn at St. Jude Children's Research Hospital comes around relatively quickly!

George, look at this here:

The order was placed on August 31, 2012, but the service wasn't performed until June 28, 2013! I mean, honestly, you just don't see that kind of delay anywhere else!

From what I can gather, the specific exam I'm looking for isn't even offered at St. Jude. 😕

lonefalcon41 said:Well, you really ought to reach out to the primary doctor or the specialist who issued the referral in the first place and simply ask them which facilities are accepting those insurance referrals! Personally, I was able to have my carotid Doppler scan done at the Mayo Clinic using my insurance coverage 🙂

Aha, so what on earth actually qualifies as free under the insurance referral then?

Does anyone happen to have any insight on this?

Greetings everyone,

I find myself in need of a carotid Doppler ultrasound and a TCD, but I am feeling quite lost regarding where to go.
I have noticed that people are quoting rather exorbitant prices for these procedures, ranging anywhere from $500 all the way up to $250...

Not too long ago, I underwent vestibular and audiometry testing based on a referral from my physician, and I didn't have to pay a single cent! Furthermore, I visited a neurologist who had a full price list posted right on his door, yet he somehow didn't charge me anything either... (I can't help but wonder why!)

Does anyone know if having supplemental health insurance and a formal doctor's referral makes a difference in these costs?
Where might I be able to find these screenings at no cost? From what I can gather, the waiting lists at major hospitals are currently stretching out to about eight months.

Greetings! I currently own a Samsung monitor—it’s a bit of an older model, to be honest—and while it isn't functioning at the moment, I am absolutely determined to get it back in working order because it holds such a special place in my heart.

I was wondering if anyone could offer some guidance: if I take it to a local shop that typically handles television repairs, would they be capable of fixing a computer monitor, or is it absolutely necessary to seek out a specialized computer repair center instead?

Kyle Johnson2 said:If you are looking to sum up all those values from cell B14 across several different Google Sheets, you can simply use one of the formulas listed below!
Code:

=January!B14+February!B14+March!B14+April!B14
=SUM(January!B14,February!B14,March!B14,April!B14)
=SUM(January:April!B14)

Thanks, 🙂

Greetings to everyone! I was wondering if anyone might be able to assist me with summing up values from multiple Sheets into one single, separate Sheet.
Basically, when I am working with just two Sheets, everything works perfectly fine, such as this formula:
=SUM(January:February!B14),

However, for some reason, it simply refuses to cooperate when I try to include three or more Sheets—do I need to group them somehow first?

My ultimate goal is to get a formula functioning like this: =SUM(January:April!B14), which would effectively sum up the value in cell B14 across all those months into one consolidated Sheet.

David Flores78 said:I am trying to figure out which software is actually the best choice for entering addresses—you know, residential ones, business addresses, or anything similar—to build up a solid database. My main priority is being able to import those addresses into Word 2007 so I can print them onto labels for mailing purposes. Is Excel a decent option here, or would you suggest something more robust? Ideally, I’d love to have one column for the physical address, one for the email, and a third for the phone number... and I need to be able to pull each of those columns into Word to print out my labels (may + spies 090217).. thanks for the help!

Well, first off, you didn't specify how you intend to input all this data into your table—are you looking to do this via a web interface (like an online form) or simply through the Microsoft Office suite? If you are planning on sticking strictly to Microsoft Office, then here is what I think:

You could certainly just create a custom table directly within Word if you prefer. Alternatively, you can set up a new document and utilize the mail merge feature to automatically pull all that data from your table into a new page, which you can then easily print out!

Gregory Rogers20 said:Thank you so much, I will certainly give that a shot.

Well, @Kyle Johnson2/">@@Kyle Johnson2, I truly gave this my absolute all, so please don't say I didn't put in the effort!
Naturally, as is often the case with these technical endeavors, I have run headlong into a few more hurdles.

1) Regarding the area highlighted in red in the image—only Group A is functioning quite right; however, for groups B, C, and D, it keeps spitting out "NN" under the "HDCP" column. It is clear something needs adjusting, though I am at a complete loss as to what specifically is causing the glitch.

2) Looking at the section marked in orange—it simply isn't working correctly when multiple players share the exact same HDCP in the database. Currently, the group list only displays one of them. What I really need is for the system to show every single player; for instance, if there are three different people in the database with an identical HDCP of (8,5), then all three should appear in that group, each with their own unique name, even if they share that same HDCP value. 🙂

3) As I mentioned previously, the database shouldn't be "fixed" or static because we are talking about athlete registration—think of it like someone signing up online via a website. Because people register whenever they want, the entries become a bit of a jumble; they aren't sorted by any specific number or name, but rather just added chronologically as they come in. That is why I emphasized that I want the formula to scan the entire database instead of treating it as a series of segmented groups...
In other words, why is the formula only searching positions 1-13 for Group A, or 14-26 for Group B, when the formula really ought to be scouring the entire database, spanning from positions 1 through 52.

4) Furthermore, the group ranges (the HDCP values, where the MIN and MAX are listed) are also fixed and unchanging. This creates a real headache; for example, if I have a Group A ranging from 1.5 to 12.4, but nobody in the database actually holds a 1.5 or a 12.4 HDCP, or if Group B tries to look for an HDCP that actually falls within Group A's range, the formula just wipes everything out and leaves everyone with empty fields. It’s quite illogical! The computer has no way of knowing which athlete will sign up next, what their specific HDCP might be, or which group they will ultimately land in.

Please, please don't be annoyed with me, but I have truly built this as far as my current abilities allow.
I am sharing my work here, and I sincerely hope that someone might be able to help resolve at least some of these issues.
Here is the file for you to look over.
http://www.mediafire.com/file/3hiv33db6v5z39r/baza.zip

Kyle Johnson2 said:Goodness, you certainly are fired up! It feels as though if you were any more intense, you might actually combust right here on the forum. If I may be so bold as to offer a gentle critique, it seems to me that perhaps you didn't quite pull out all the stops on this one; there was a certain lack of meticulous effort in your approach that I simply couldn't help but notice. Personally, I found the entire process to be incredibly smooth, and I managed to get everything running perfectly using the exact formulas provided by Benjamin Wilson7 and Nicholas King. In fact, I must say, I found that method to be significantly more straightforward and far less cumbersome than wrestling with VBA code!
You actually provided an entirely blank file that you built using the template I sent over! It’s quite a curious thing, really, because you haven't included a single formula to back up your rather bold claim that this simply cannot be achieved through formulas.

Take a look at what Gregory Rogers20 is up to!
I truly believe there is nothing more rewarding than lending a helping hand when someone hits a roadblock, but one must also learn to exercise a bit of independent critical thinking. In my honest opinion, it felt as though you hadn't quite put in the necessary effort to explore the solution on your own first.
Please understand that this forum isn't a place to drop off your homework or demand that someone hands you a finished product on a silver platter! Our community exists to provide a helping hand when you hit a metaphorical brick wall or find yourself stuck on a tricky step. If your goal is simply to obtain a completed project without doing the legwork, then you aren't looking for a forum; you should instead seek out a professional freelancer, explain exactly what you need, and pay them for a turnkey solution. We are here to learn together, not to do the work for one another!

To truly demonstrate my point, I am providing you with this comprehensive tutorial, complete with every single illustrative step and all the necessary macro commands, just to prove that achieving something of this caliber requires genuine effort and dedicated labor! You have been handed every possible guideline and link available, yet it seems you haven't quite put in the work yourself. At this stage, the ball is entirely in your court; it is up to you to take these instructions, copy them accurately, and apply them directly to your own file.

- Is there anyone else out there who finds themselves constantly wrestling with massive datasets, trying to isolate just the most extreme values? I was working on a project the other day—much like one of those intense quarterly audits you might see at a firm like Deloitte—where I found myself staring at a spreadsheet that felt more like an endless labyrinth than a useful tool! I desperately needed a way to automatically grab everything sitting between my minimum and maximum values without manually clicking through thousands of rows. It’s one of those tasks that feels simple in theory but becomes a total headache when you're actually in the thick of it. I would love to hear how you all handle this! Does anyone have a preferred method for automating a sort and copy routine that targets that specific range between a MIN and MAX value? Whether you're using some clever formulas or a bit of automation, I am all ears!

Greetings to everyone! I hope you are all having a truly wonderful day.

I truly appreciate the suggestion, and I will certainly give that a try!

EDIT:

Kyle Johnson2 said:👎
My apologies! I only provided you with the basics, but the formulas are right there for you to work with decimals. If you take some time to study them, you'll be able to customize everything exactly the way you want it.
Best regards,

For the hundredth time now: relying on a formula is just silly because it won't clear out those rows and will just leave "NN" sitting there everywhere.

Does anyone know if we can handle decimals within Visual Basic?

Kyle Johnson2 said:@Gregory Rogers20/">@@Gregory Rogers20, hey there!
I was honestly hoping you might put in a little bit of elbow grease and try to build something yourself first! If that wasn't possible, perhaps you could have shared a sample spreadsheet of what you're working on—using some dummy data, of course—to show us exactly where you're hitting a wall.

But no worries at all, I've gone ahead and whipped up an example based on how I interpreted your request!

On the "database" Sheet, you'll find a full roster of players, which includes a serial number, their handicap (as a number), and their names.
Once you've finished entering everyone—especially after inputting those handicap numbers—the rows will automatically sort themselves, bringing the corresponding names along with them. Every time you update a handicap and hit enter, that automatic sorting kicks back in immediately.

Then, on the "groups" Sheet, you simply input the MIN and MAX values for each group, and the data filters itself according to those criteria.
Since I'm certainly not a mind reader and can't know exactly how you envisioned your layout, please feel free to tailor this to fit your specific needs! 🙂

You can download the file via this link: Automatic Sorting with MIN and MAX

The password to unpack the file is:
Code:

www-ic-ims-us

Oh my goodness, Kyle, you're going to be the death of me!
You did a lovely job organizing that, but I went ahead and color-coded the database; basically, the main database is where the entire player list lives, and from there, they are partitioned off into other tables representing different groups.
I've also updated the group numbers to reflect actual values now.

For instance, if a group is set from 0-12.4, we run into that pesky "NN" issue again. From what I gather, if a player doesn't have a handicap of exactly '0', the table just displays "NN".
Additionally, the table only prints the numbers alongside the names; this means if a player lacks a handicap, the table skips the row entirely and just writes "NN".
Take a look at this:


See, Name12 and Name13 really ought to be in Group B, but it seems the formula is just looking at the first number in the row rather than pulling from the master table, so the number stays stuck up top while Group B just shows "NN" below.

Actually, I preferred the first example more because I could strip out those "NN" entries, though it lacked decimals. I'm not quite sure why you can't manage to include decimals there? I could definitely refine that table further myself.

Anyway, I am sending over two files; I've cleaned things up a bit and clarified the logic.
http://www.mediafire.com/file/hl2y5uauwarl7ia/hdcp.zip
By the way, if you decide to work on file2 (the one using VBA), you can absolutely pull the group table from file1.

Benjamin Wilson7 said:Go to Home -> Editing -> Sort & Filter -> once you apply the filters, head over to Number filter -> then choose Between (this allows you to show rows where the value falls within a specific range, just enter the range of numbers you need, including decimals...), which is truly one of the fundamental Excel tools.

I am currently using Office 2003, and I don't even see a "Home" tab! On my version, I have to go to Data -> filter.. but I suspect that isn't quite right because there isn't a "between" option available there at all.

Kyle Johnson2 said:Don't wait on me! Just hit up Google or whatever—get moving on something! 🙂

Does anyone happen to know how to adjust this so it handles decimals correctly?

And while I have you, I have a second question. Is there any way within this VBA environment in Microsoft Excel to export a form so others can actually use it without having to open Microsoft Excel itself? From what I can tell, it seems like everything just ends up as a .frm file.