topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • November 16, 2018, 10:10 PM
  • Proudly celebrating 13 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - kalos [ switch to compact view ]

Pages: [1] 2 3 4 5 6 ... 68next
1
Living Room / Is there a way to easily carry earphones for my mobile?
« on: November 13, 2018, 02:56 PM »
Hello!

Is there a way to easily carry earphones for my mobile?

I have bought some in a case but I would be interested in the minimal volume possible.

Thanks!

2
Yes, MiniZinc.

Here is a tutorial for using it to solve a LP problem:
https://brilliant.or...lling-with-minizinc/

And two courses to dig deeper:
- Basic Modeling for Discrete Optimization
- Advanced Modeling for Discrete Optimization

Thanks that looks very interesting!
Does it work within excel or can I copy/paste my excel model? Or is there anything similar that will work within Excel? I tried Solver but it doesn't seem to work :(
If I have to build it from scratch using that language it will be a nightmare!

3
To understand which variable has the highest impact you can use regression analysis and ANOVA.

Assuming it is a linear process you can use linear programming for optimization. If not, you can look at other mathematical optimization models.

If I remember correctly, Excel has built-in solver for linear programming but it has to be activated.


Yes, I used Solver but it is very limited.
Is there a better tool?

4
Hello!


I have a complex model in excel. Among other parameters which I want to keep constant, I want to find the effect of each of four cells that contain variables (with some constrains) to a cell that is the result cell.

I want to find the optimum (minimum) four values to achieve the result I want and also find which of these four variables has the most significant effect on the result cell.

To give you some context, there are four teams that work in a very complex way and the four input cells are their employee number. The output cell has the end date of the project that is calculated with very complex way. How can I find which team is more worth to hire and how many?

Any idea? I am open to any freeware tool, etc.

Thanks!

5
Living Room / Re: My first excel macro
« on: October 09, 2018, 04:22 PM »
What I am asking is not a google search and I don't have the time now to read a whole tutorial

6
Living Room / My first excel macro
« on: October 09, 2018, 09:48 AM »
Hello!

I want to write a macro in Excel that will use the 'Goal Seek' analysis.

The code is something like that:

Range("Q27").GoalSeek Goal:=0, ChangingCell:=Range("B10")

As for input cell (ChangingCell), when the macro button is pressed, I want to consider the active cell. How can I do that?
As for the goal seek cell, I want to a formula to calculate it based on other cells values.

Any hint?

Thanks!

7
Living Room / Re: Problem for very strong brains
« on: October 06, 2018, 02:19 PM »
Interesting Iain, I will have a look thanks!

No, it's not homework, it's real life problems for which I would just like opinions.

I developed a model, but I was wondering if there is a specialised tool or methodology.

8
Living Room / Re: Problem for very strong brains
« on: October 05, 2018, 05:54 PM »
You can imagine it as if each file is a piece of string of specific length with five different regions (let's say coloured differently).

How can you determine the start and the end of each string in a timeline, placed one below the other, so that the thickness (total concurrent strings) are within the limits (people capacity) and the total length of the distribution of the strings is within specific length.

Hope I did not confuse you with that geometric analogue :)

9
Living Room / Problem for very strong brains
« on: October 05, 2018, 05:26 PM »
Hello!

I have a problem that seems so common yet so tricky to manage. I wonder if there are any process tools or other methodologies to approach it. I would also like to generally discuss it and brainstorm.


I have 1000 files. I have a waterfall process of five steps that each file needs to go through one after the other.
Each of the five stages has its own speed (eg 5h per file, 10h per file etc), based on the average time of processing per file and the number of people available to process files in that stage.
You have a number of files to be processed (through all the stages) by a specific deadline.

How can you allocate the resources (people) to complete the files in the shortest time?
The tricky bit is that a specific number of people can do stage 1 and 3 only, and the rest can do stages 2, 4, 5 only.

To add to the complexity, you have additional bunches for files with different deadlines, let's say 2000 files to be completed three months after the first deadline and 5000 five months after the first deadline.

Any opinions?
I have some ideas but would like some input first.

Thanks!


10
Living Room / Any maths genius?
« on: October 01, 2018, 02:00 PM »
Hello!

I have 1000 files. Each day, 250 files are processed. Out of the processed files, 20% get completed. Out of the processed files, 80% files need reprocessing and they restart from the beginning, but after second processing, they get completed.

How can I model this in excel to show the decline of files to be processed per day? In a function, that I can drag to generate the sequence?

thanks!

11
General Software Discussion / Trickiest EXCEL formula problem ever!
« on: September 28, 2018, 10:53 AM »
Hello!

I have a row with dates that are start of weeks ongoing. Below that, I have one row with numbers. Below that, I have a row that I want to fill in with a formula.

In an independent cell, I input a date. Then the formula I want to fill in, checks if the date is future/past of the date at the top row in the same column. If future, it fills the cell with zero.
The problem is what I want it to do if the date is past.

I want to display the ratio of the number above in the middle row and the same column, with respect to the sum of the middle row numbers. The tricky bit is what exact sum I want it to consider.
I want the sum of the first cell in the column that the bottom line cell is not zero, up to the end of the row.

I need somehow to reference and store in a variable that. Or somehow calculate that ratio, considering the right sum, which is fixed once defined, but it is defined by the first cell that gets a non zero value.

I don't want to do this with a macro as I don't know anything about macros. Any help?

Thanks!

12
Hello!

My data has several client names. It is very often that there are several names of the group of one client.

For example, Batavia Insurance, Batavia Fund, etc probably belong to the Batavia group.

It would mostly work if I match the first word, so how could I write an Excel function to group/count entries that their cell has the same first word?

But it is not 100% safe, eg when you have PT Batavia Company and a prefix kills your algo.

I know it will never be 100% accurate, but do you have any idea how to approach this?

Thanks!

13
Living Room / Re: How to model this?
« on: September 26, 2018, 03:15 AM »
Oh damn, I forgot I am talking about EXCEL lol

14
Living Room / How to model this?
« on: September 24, 2018, 04:56 PM »
Hello,

I want to model the processing of some cases, so I know the process time of each case and the number of employees, so I can find the end date.

However, depending on the deadline, the cases may need to be reprocessed every a fixed number of months, so that the total number of cases may increase depending on the end date.

How can I model this? I find difficulty because the number of cases to be reprocessed affects the end date, but also the end date affects the number of cases to be reprocessed!

Any idea?

Thanks

15
What's the difference?

You either have 3 lines that say:

3  Product1
1  Product2
1  Product3

Or three files that contain lines that say:

File "Product1.txt"
Product1
Product1
Product1

File "Product2.txt"
Product2

File "Product3.txt"
Product3

Either way all you're getting is a count of how many times a match appears.

No it's not the same, because the regex will be different! And I want to store the whole regex match in the file, which will be huge multiline text!

16
gci FILEPATH\out.txt|group|select Count,Name >FILEPATH\out-counted.txt

No you misunderstood. I don't want to count matches. I want to group them and output them in a separate file.

For example, I will search for my regex:
<html:producttype>(.+?)</html:producttype>
The possible matches will be:
<html:producttype>Product1</html:producttype>
<html:producttype>Product1</html:producttype>
<html:producttype>Product2</html:producttype>
<html:producttype>Product1</html:producttype>
<html:producttype>Product3</html:producttype>
etc

I want the script to create one file with the matches where the (.+?) is the same, so:
1 file that contains:
<html:producttype>Product1</html:producttype>
<html:producttype>Product1</html:producttype>
<html:producttype>Product1</html:producttype>
1 file that contains:
<html:producttype>Product2</html:producttype>
and 1 file that contains:
<html:producttype>Product3</html:producttype>

Thanks!

17
Guys, after I search for regex matches in a text, how can I group the matches to separate files, by same reference inside the regex match?

For example, for every regex match <html:producttype>(.+?)</html:producttype>, I want to output to a separate file all the matches where the (.+?) is the same.

Any idea? Also, please explain the strategy/pseudocode to see how that would work.

18
General Software Discussion / Re: Big Data tools
« on: September 14, 2018, 12:36 PM »
Is there a 'free for commercial use' software that opens and processes with regex large text files of 20GB?

TL;DR; Yes.

Suggestions:
  • Any Linux distro with a non-commercial license (most will fit)
  • Linux-tools for Windows (if it's supposed to run on Windows, you didn't say it should)
In any of these environments use tools like grep, sed, awk, perl, python etc. for text processing.

  • 'Plain' Windows (7 and newer)[/i]
Use powershell, like shown & explained in your other thread.


Thanks but I want to also be able to view the content, like EmEditor

19
Living Room / Re: Looking for smartphone
« on: September 14, 2018, 12:35 PM »
What are the top 3-5 cheapest mobiles with NFC and >5000mah?
Any idea?

Any suggestion for the best phone with longest battery and NFC?

20
General Software Discussion / Big Data tools
« on: September 14, 2018, 09:47 AM »
Hello!
Is there a 'free for commercial use' software that opens and processes with regex large text files of 20GB?
Thanks!

21
What could be the problem?
You haven't shared the file, so we'll never know, unless...

I made it work like that:
gci FILEPATH | sls -AllMatches '<html:productType>(.+?)<\/html:productType>' | % { $_.Matches } | % { $_.Groups[1].Value } >> FILEPATH\out.txt

But I don't know how I made it work lol, can you spot the error? Also, I know I asked before, but can you point me to somewhere that explains % { $_.Matches } | % { $_.Groups[1].Value } ?
I think % means 'for every' and $_.Matches is the object variable of the matches, while $_.Groups[1].Value is the content value of the matches objects, right? But what is [1]?

UPDATE: it seems both work, but which would be better?
Thanks!

22
Any hint?
We've been here before: http://www.donationc....msg422274#msg422274

Ah great thanks!

I tested it and there is an issue. I searched in the file and there is only one instance of <html:productType>(.+?)</html:productType>
However, the output file mentioned the above value (.+?) twice. What could be the problem?

Thanks!

gci C:\XML.xml | % { sls $_.Name -Pattern '<html:productType>(.+?)<\/html:productType>' -a | % { $_.Matches } | % { $_.Groups[1].Value } >> C:\out.txt }

23
Guys, can anyone tell me the command that will find all the regex matches, isolate a specific part of each regex match and output all of them in a file?

I have the regex, but I don't know how to indicate a part in it.
The regex is this: "<html:productType>(.+?)</html:productType>"
I used the parentheses to isolate the part of the regex that I want to be output in the file.

How the whole command should be?

I found online and wrote this:
[regex]::match($s,"<html:productType>(.+?)</html:productType>").Groups[1].Value
But I don't know where you specify the source text or if it is correct. Any hint?

Thanks!

PS: It is really a nightmare to do some simple stuff in Powershell. There is very poor and incomplete documentation. Do you think there could be any other solution? Python maybe or anything else? I need it to work with big data though and if it has GUI it would be nice. Also, it needs to be free for commercial and any use.


Anyone please?

24
Guys, can anyone tell me the command that will find all the regex matches, isolate a specific part of each regex match and output all of them in a file?

I have the regex, but I don't know how to indicate a part in it.
The regex is this: "<html:productType>(.+?)</html:productType>"
I used the parentheses to isolate the part of the regex that I want to be output in the file.

How the whole command should be?

I found online and wrote this:
[regex]::match($s,"<html:productType>(.+?)</html:productType>").Groups[1].Value
But I don't know where you specify the source text or if it is correct. Any hint?

Thanks!

PS: It is really a nightmare to do some simple stuff in Powershell. There is very poor and incomplete documentation. Do you think there could be any other solution? Python maybe or anything else? I need it to work with big data though and if it has GUI it would be nice. Also, it needs to be free for commercial and any use.

25
Living Room / Label printer
« on: September 05, 2018, 04:37 PM »
Hi!

I want a very cheap and very compact solution to print return labels when I am returning goods bought online.

Is there anything like that?

A normal printer can be cheap but it is too big. Some portable printers are more compact but very expensive for the use I want.

It doesn't have to be A4, it can much smaller!

Any idea?

Thanks!

Pages: [1] 2 3 4 5 6 ... 68next