The other day, in the news, there was a story of a person at a government office struggling to prioritize the entry of waiting children.

In order to prioritize the waiting child, it is necessary to investigate a plurality (more than a dozen?) Conditions, and it has to be done with just a few people.

I don't know the work well, so I have to avoid giving a straight answer, however, I think the problem is a typical "combinational optimization problem".

In some cases(for example, numbers of parameter), this problem will not be completed even after 100 years.

If you ask the software company to create an application or something else, the estimate in units of 10 million yen will come out and they will deliver "hard to use" applications.

After all, they can not use the "hard to use" application, the result will be that our taxes are thrown away in the dob.

-----

However, the "combinatorial optimization problem" can be solved by using the computer (Macro) and Excel (*) program (macro)

(*)Google spreadsheet is also O.K.

A person at the office can write the Excel macro of "combinatorial optimization problem" on their own.

Anyway, they know the work well.

However, it is almost "wild view" which can be said to be almost "violence".

It might be violence like "translate Tamil language documents into Japanese, and submit it".

-----

For such small macro development, recently there is a method called ordering by "cloud funding" using the net.

I have seen the recruitment page once, but I felt that the scale of the amount of money is one digit off (cheaper).

Also, in preparation for troubles such as bugs after development, the maintenance fee also should be packed up.

Even with a slight function expansion, additional development costs will occur.

The cost of "cloud funding" does not seem to contain these maintenance and enhancement at all.

Even the offices think that they will hesitate to place an order.

(To be continued)