SoftwareExcel-me-do

 

Press Ctrl+Enter to quickly submit your post
Quick Reply  
 
 
  
 From:  ANT_THOMAS   
 To:  CHYRON (DSMITHHFX)     
41876.3 In reply to 41876.2 
I want to remove those matching rows. I was able to filter out the 4 text filled rows, then copy the rest of the data into a new sheet. Or just delete them from the original data. Just unable to get rid of the blank row without removing all blank rows elsewhere.

Regex on the csv file is a good suggestion, rather than editing in Excel.
0/0
 Reply   Quote More 

 From:  Peter (BOUGHTONP)  
 To:  ANT_THOMAS      
41876.4 In reply to 41876.1 
> ... but I'll wait a while before I start making those demands.

Every time I've decided "I'll wait till I'm less new / more settled / etc" I've later regretted it.

0/0
 Reply   Quote More 

 From:  ANT_THOMAS   
 To:  Peter (BOUGHTONP)     
41876.5 In reply to 41876.4 
You make a good point. I have only been in the job for 2 weeks, and I should be having some formal training on the MRP package in question in a few weeks so I'll definitely bring it up then. In the meantime I'll look at a regex option.
0/0
 Reply   Quote More 

 From:  koswix  
 To:  ANT_THOMAS      
41876.6 In reply to 41876.5 
MRP :'D
0/0
 Reply   Quote More 

 From:  ANT_THOMAS   
 To:  ALL
41876.7 
Fixed. I made it so all the blank rows were no longer essential. Converted some other data that wasn't required to blank, played with the set in stone formula and after a filter, a few deletions, pasting a new formula, we now have a way to save plenty of time.

automation-win.png
+1/1
 Reply   Quote More 

 From:  ANT_THOMAS   
 To:  koswix     
41876.8 In reply to 41876.6 
We have 4 systems:
MRP
ERP
Warehouse/stock management
Invoice management

......!
0/0
 Reply   Quote More 

 From:  koswix  
 To:  ANT_THOMAS      
41876.9 In reply to 41876.8 
Had to do a course in 4th year on supply chain management. Essentially it was a course on "look at how these companies all fucked themselves by trying to implement erp systems :'D "
0/0
 Reply   Quote More 

 From:  koswix  
 To:  ANT_THOMAS      
41876.10 In reply to 41876.8 
Wait, why are they running all those systems? I thought the whole point of erp was to do all that shit in one place?

 ▪                    
             ┌────┐    ┌────┐                      
          │    │    │    │ ▪                    
          │    └────┘    │                      
          │   ──┐  ┌──   │ ▪                    
   ┌──────┤    ▪    ▪    │                      
  ┌┘      │              │ ▪                    
┌─┤       └──┐  │  │  ┌──┘                      
│ │          │ ││  ││ │   ┌─┐                   
│ │          └─┼┤  └┴─┴───┘ │                   
│ │           ─┘│           │                   
│ │   ┌──────┐  └┬──────────┘                   
  │   │      │   │                              
  │   │      │   │                              
  └───┘      └───┘                              
If Feds call you and say something bad on me, it may prove what I said are truth, they are afraid of it.

0/0
 Reply   Quote More 

 From:  ANT_THOMAS   
 To:  koswix     
41876.11 In reply to 41876.10 
Honestly no idea yet. I would have thought that there would be one system that can do the job that 3 of those currently do. Or even one of the systems we currently use that can do it. I know one of them is being upgraded in a few months. I don't even think the systems have talk to each other all that well either, so some data isn't always "live".

It seems to me to be pretty standard from a manufacturing point of view so there should be a way. I can only assume someone is keeping themselves in a job supporting the lot.

Oh, but there's no fax machines, which is a huge improvement!
0/0
 Reply   Quote More 

 From:  koswix  
 To:  ANT_THOMAS      
41876.12 In reply to 41876.11 
ERP is the big ass fix it all together solution to integrate pretty much all business functions into one system, shared databases, live data etc. Everything on your list of systems, and more, could be managed by an ERP system. In fact, one of the examples we were given in class for what it's meant to replace is people in different departments using their own spreadsheets :'D

Of course that's all big idea stuff, and mostly (according to the case studies we had to do, anyway) it doesn't work. Makes a load of money for SAP & Sage and the likes, though :D

This case study is well worth a read, if you're into economic car-crash type stories. One of the biggest pharma distributors went from multi-billion dollar company to bankruptcy because of a failed ERP implemenation :'D

http://www.uta.edu/faculty/weltman/OPMA5364TW/FoxMeyer.pdf

 ▪                    
             ┌────┐    ┌────┐                      
          │    │    │    │ ▪                    
          │    └────┘    │                      
          │   ──┐  ┌──   │ ▪                    
   ┌──────┤    ▪    ▪    │                      
  ┌┘      │              │ ▪                    
┌─┤       └──┐  │  │  ┌──┘                      
│ │          │ ││  ││ │   ┌─┐                   
│ │          └─┼┤  └┴─┴───┘ │                   
│ │           ─┘│           │                   
│ │   ┌──────┐  └┬──────────┘                   
  │   │      │   │                              
  │   │      │   │                              
  └───┘      └───┘                              
If Feds call you and say something bad on me, it may prove what I said are truth, they are afraid of it.
0/0
 Reply   Quote More 

 From:  ANT_THOMAS   
 To:  koswix     
41876.13 In reply to 41876.12 
>>In fact, one of the examples we were given in class for what it's meant to replace is people in different departments using their own spreadsheets

The data in question is actually generated from one system, and needs all the by-hand editing to prep it for import in another :'D (fail)
0/0
 Reply   Quote More 

 From:  koswix  
 To:  ANT_THOMAS      
41876.14 In reply to 41876.13 
Just fax it over to the dba :'D
0/0
 Reply   Quote More 

 From:  william (WILLIAMA)  
 To:  koswix     
41876.15 In reply to 41876.12 
Be serious. ERP is a process where 80% of the investment funding for a business goes to building a tiny system of entirely new work which is (1) unrelated to the day to day work of the business which continues to run on whatever under-funded IT it already had and (2) packed to the gills with very sexy acronyms and plain English words such as 'digital' and 'big'. This tiny system will 'provide new and unexpected opportunities' for the business as opposed to aiding the old and difficult problems that need to be addressed. The new and unexpected opportunities will have a dramatic impact on the career prospects of a small coterie of consultants and company staff around the senior VP running ERP. They will thrive at huge expense until the time comes to move on to a new project.
never trust a man in a blue trench coat, never drive a car when you're dead
0/0
 Reply   Quote More 

 From:  koswix  
 To:  william (WILLIAMA)     
41876.16 In reply to 41876.15 
That was pretty much my understanding of it after taking that course, and I think that must have been what they wanted us to take away from it, seeing as I got a ridiculously high score for my exam paper for saying as much.

That case study is interesting though, your post on mainframes reminded me about it the other day: old mainframe system running 420k transactions per night, shiny new erp system running on shiny new hp servers managed 10k transactions per night.

 ▪                    
             ┌────┐    ┌────┐                      
          │    │    │    │ ▪                    
          │    └────┘    │                      
          │   ──┐  ┌──   │ ▪                    
   ┌──────┤    ▪    ▪    │                      
  ┌┘      │              │ ▪                    
┌─┤       └──┐  │  │  ┌──┘                      
│ │          │ ││  ││ │   ┌─┐                   
│ │          └─┼┤  └┴─┴───┘ │                   
│ │           ─┘│           │                   
│ │   ┌──────┐  └┬──────────┘                   
  │   │      │   │                              
  │   │      │   │                              
  └───┘      └───┘                              
If Feds call you and say something bad on me, it may prove what I said are truth, they are afraid of it.

0/0
 Reply   Quote More 

 From:  ANT_THOMAS   
 To:  koswix     
41876.17 In reply to 41876.16 
An overnight job failed last night, meaning the software which forecasts demand is showing all the wrong data.
0/0
 Reply   Quote More 

Reply to All    
 

1–17

Rate my interest:

Adjust text size : Smaller 10 Larger

Beehive Forum 1.5.2 |  FAQ |  Docs |  Support |  Donate! ©2002 - 2024 Project Beehive Forum

Forum Stats