What's new
By:
USCHO Fan Forum

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

  • The USCHO Fan Forum has migrated to a new plaform, xenForo. Most of the function of the forum should work in familiar ways. Please note that you can switch between light and dark modes by clicking on the gear icon in the upper right of the main menu bar. We are hoping that this new platform will prove to be faster and more reliable. Please feel free to explore its features.

computer issues: part infinity

TalonsUpPuckDown said:
Glad it worked out. I was reviewing this with the architect and pointed out that his solution matched very closely with stuff I'd coded in Excel to do the same thing. I am not SQL literate at all but due to being a coder two lifetimes ago (ala the 1980's pre-object oriented world of Turbo Pascal, COBOL, RPG and other dead, Latin-like, procedural-based languages and hierarchical databases) I'm quite good with Excel. After I pointed out the similarities between his syntax and Excel and he commented that it's all Microsoft so under the covers it'll all be basically the same. Duh. I pass this observation along on the off chance it may be useful in the future. Anyway, here it is in Excel assuming the message string is in cell A1:

=MID(A1,FIND(":20C:",A1)+5,FIND(":23G:",A1)-5)
Click to expand...

I like to think of myself as an advanced excel user. I've been on a project recently where I was asked to crunch the data from a year's worth of product runs at a plant we're rebuilding. They have something like 4,000 SKU. Each with about 6-10 ingredients, some of which are the SKUs they make. Made on around 15-20 machines.

they don't have a great database of recipes and I came to find out that one product might have not a single recipe but some runs use corrections to meet spec. Other runs are making the product but dumping it into a tote where they already have product, so you might have odd lot sizes or bad ratios. They also have not run variability analyses to work out inefficiencies and quality. (Ugh, I know)

The last two weeks I've been pushing excel to its absolute 32-bit limit. To the point that I've had to get used to saving every five minutes and creating a new file every 20-30 minutes just so I don't lose work. I can't tell you how many times it's crashed because it's hit memory issues. 80% of it is run through macros but it still takes about 10-15 minutes to run on the biggest product lines.

I know I should be running this stuff through a proper database with proper lookups, but I just know excel too well. Prior to this, the most complicated spreadsheet I had done was a massive KRACH and PWR spreadsheet using the old methodology for PWR. Still the most complicated single formula I've written. Super long even when pasted in word.
 
Last edited:
dxmnkd316 said:
I like to think of myself as an advanced excel user. I've been on a project recently where I was asked to crunch the data from a year's worth of product runs at a plant we're rebuilding. They have something like 4,000 SKU. Each with about 6-10 ingredients, some of which are the SKUs they make. Made on around 15-20 machines.

they don't have a great database of recipes and I came to find out that one product might have not a single recipe but some runs use corrections to meet spec. They also have not run variability analyses to work out inefficiencies and quality. (Ugh, I know)

The last two weeks I've been pushing excel to its absolute 32-bit limit. To the point that I've had to get used to saving every five minutes and creating a new file every 20-30 minutes just so I don't lose work. I can't tell you how many times it's crashed because it's hit memory issues. 80% of it is run through macros but it still takes about 10-15 minutes to run on the biggest product lines.

I know I should be running this stuff through a proper database with proper lookups, but I just know excel too well. Prior to this, the most complicated spreadsheet I had done was a massive KRACH and PWR spreadsheet using the old methodology for PWR. Still the most complicated single formula I've written. Super long even when pasted in word.
Click to expand...

Flashbacks....My father's last role before he retired was leading a group of ~60 people implementing SAP at 100% of his chemical company's worldwide locations, including all their sales offices - in the mid 90's, so pre-internet, practically speaking. At the time, his company had more than 100,000 products ("recipes," I guess?) for sale, not to mention all the raw materials and intermediate stages of materials to track. They studied the problem for a while and concluded that Excel was the best tool for translating the data from hundreds of different business and inventory systems into SAP. They had some spreadsheets that took days to compute - of course, now your cell phone could probably handle what they did in the blink of an eye!
 
Honestly, excel is the best because it's so malleable. Databases and front ends, especially SAP, treat data like R. Lee Ermey did grunts at basic. If it's not perfect, SAP is going to ruin your fucking day (if you're lucky)

Excel might choke on the quantity of data, but it at least lets you know.
 
I woke up this morning to find my computer will not turn on at all.

​With 2 weeks to go in the quarter for school, I'm hoping it's not fried.
 
No idea where else to put this.

My mom has had a couple of falls in the last year and while she's still very independent and able to take care of herself, I'd like to take out a bit of an insurance plan. After doing some research, I'm thinking the Apple Watch is what I'm looking for. The fall detection and emergency calls seems to be pretty well thought out. I'm less inclined to get one of the medic alert bracelets or necklaces since they're very expensive to subscribe to, not very feature rich (I'm thinking things like heart variation, etc. but she'd be interested in some of the other techy features), and I think the Apple Watch would be more likely something my mom would be willing to actually use because it doesn't carry a stigma.

She doesn't have an iPhone so we'd be looking going the Family Setup route. Does anyone have any experience with this? Wanted to get some info before we get too far down the rabbit hole.
 
The rare good thing. Something must have happened with my ISP because I was running Speakeasy and instead of the 350-375 I usually get for download it was at 490 down / 470 up.

Thank you, Verizon?
 
Has anyone switched to a decentralized VPN device and if so would you recommend? The up front cost isn't terrible, and if the claimed benefits are accurate not paying a monthly fee thereafter is appealing.
 
I’ve got a bizarre issue I could use help with, the Wi-Fi shut off on my laptop and I’m not able to turn it back on. I’ve tried running network diagnostics but it just spins and never does anything. I’ve googled but haven’t found anything useful. It’s around 10 years old so perhaps that is part of the issue. I probably should just take it to Apple and see what they can do but figured I would check here.
 
Slap Shot said:
Has anyone switched to a decentralized VPN device and if so would you recommend? The up front cost isn't terrible, and if the claimed benefits are accurate not paying a monthly fee thereafter is appealing.
Click to expand...

Is that for greater anonymity?
 
Kepler said:
Is that for greater anonymity?
Click to expand...

Reported pros and cons:

Advantages of Decentralized VPN Devices

Enhanced Privacy

The decentralized nature of these VPN devices offers a higher level of privacy and anonymity compared to traditional VPN services. Since there is no central authority controlling the network, it becomes more difficult for any entity, including governments or internet service providers (ISPs), to monitor or track users' online activities.

Resistance to Censorship

Decentralized VPN devices enable users to bypass censorship measures imposed by governments or institutions by routing traffic through nodes located in countries with more favorable internet regulations. This allows users to access restricted content and express their freedom of speech without fear of repercussions.

Reduced Vulnerability to Attacks

The distributed architecture of decentralized VPN devices makes them inherently more secure compared to centralized VPN services. As there is no central point of failure, it becomes more challenging for malicious actors to breach the entire system. Additionally, encryption protocols used by decentralized VPN devices provide an extra layer of security, making it harder for unauthorized individuals to intercept or manipulate the data.

Disadvantages of Decentralized VPN Devices

Limited Network Size and Speed

As decentralized VPN devices rely on the computing power and bandwidth of network participants, the speed and performance of the network can be impacted by the number of active nodes and their resources. In the early stages of adoption, when the network may still be growing, users may experience slower speeds and limited accessibility.

Technical Complexity

Setting up and maintaining a decentralized VPN device can be more complex compared to using traditional VPN services. Users might need to possess a certain level of technical expertise to configure and troubleshoot the decentralized network. This could create a barrier for less tech-savvy individuals who prefer a plug-and-play solution.

Availability and Reliability

Since decentralized VPN devices heavily rely on the participation of network nodes, the availability and reliability of the network can be influenced by factors such as the number of active nodes, their geographical distribution, and the stability of participants' internet connections. In some regions or during times with low network activity, the network may not provide consistent and stable service.
 
My iPad has no sound all of a sudden. I’ve turned the volume up and down, I’ve checked settings…not sure what I should do. I really don’t want to have to go to the Apple Store. Any thoughts?
 
Scarlet, disable the Bluetooth. You might’ve accidentally connected to some speaker - or perhaps a neighbor thought your iPad was their own when trying to pair to their own.
 
I've also seen it where some apps/sites only play sounds when the silent switch is off. Usually videos break through but not always.
 
If you have another iOS device, try "Find my iPad" and do the "Play Sound" from that second device. That feature will override any sound settings on your iPad and will at least tell help narrow down what sort of problem you may have.
 
Thanks all! I shut down and restarted and that seemed to work. But I love the Find my iPad suggestion! Will have to keep that in mind.
 
You must log in or register to reply here.
Back
Top