Purchased the previous version. Specialized web-services for searching contests

Zamovniki zobov'yazanі rozmіschuvat podomlennya, documentation, protocols — all tenders for the official website of the purchase of movies.

The official website of the holder of purchase orders for the address zakupki.gov.ru.

On the portal of placement of all tenders and purchase orders. The official website allows you to purchase orders according to 44 Federal Laws and 223 Federal Laws, to capture documentation. Previous version derzhzakupіvel website: old.zakupki.gov.ru Gov.ru - domain name of the Order of the Russian Federation (in the form of the first letters of the English word government- Order).

A good alternative to the Derzhzakupivel website is the Tenderplan search system. Try it FREE on 2 pieces

Official website Nákupki.gov.ru

1. Buyer's plans, schedules, information about their implementation
2. Information about purchases, about concluding contracts
3. Transfers of purchasers from subjects of small business
4. Register of contracts, provisions of deputies
5. Library of standard contracts
6. Register of bank guarantees
7. Register of checks (before FAS), scheduled and post-scheduled revisions
8. Results of monitoring, audit and control

On the official site, there is also a working forum.

The main portal of the purchaser according to 44-FZ was distributed according to 44 and 223-FZ, and other distributions were made for purchase plans, transfers and registers according to the federal law.Search extensions allow you to filter holdings of purchases. You can refer to the federal law, the registration number of the purchase, the method of conducting the purchase (tender type).

The postal purchase price can be selected in rubles and other currencies. Official website of the purchase of goods, the movement of pidtrimuє search for the ІPN of the deputy, the sub'єktu of the Russian Federation, as well as the delivery of goods, robots or services. Crimea key words maybe some blame from a joke. Check the box “for the improvement of all forms of words” in the result of all parts of the promotion request for an hour of asking.

Registration on the website of holders of purchases

The portal of the state purchaser zakupki.gov.ru distributed to the deputies and distributed to the post-employees, de-placement of the registry, clarification, information and advice.

Oskіlki zamovniki zobov'yazanі rozmіschuvat on the official site and derzhavkuvel anonymous information, they need to take the EDS for trading, go through registration and take access to special office. The order of registration for deputies was determined by the order of the Federal Treasury.

Zamovniki will arrange tenders through the EBC holding purchases. Official website as a public part of the unity information system in the area of ​​the buyer. The official website of the buyers of mov povyazuє deputies, participants of the buyers and electronic maidans.

Leather purchase order to take notice, documentation, as well as sending to the electronic maydanchik, de passing the appointment of the postmaster or electronic auction. In order to take part in the auction, the postal worker needs to pass accreditation without intermediary on the electronic maidan. leading trade maidanchik with Oschadbank, therefore accreditation for Oschadbank AST is the most popular.

New access to information on the official website of the purchase of movies and all tenders that are being held, for post-employees is available without registration - it simply does not exist.

Assistance and training of robots with the website of the purchaser

The official site for the purchase of movies under 44-FZ is being gradually upgraded. Kіlka razіv on tizhden until new, changes and updates are made, pardons are corrected. Under the hour of carrying out the regulatory work, the site of the purchaser does not work. Such periods can become up to two deb (weekend days).

Under the hour of regulatory work on the official website of the state purchaser, the information is not available and you can just use a stub.

If you find it difficult to work with the official website of the buyers, we are ready to help you. Pass

Website Purchases.- this is an official state-owned website from the usual purchases, which are carried out for state, budget pennies or regulation by a power, and even for the money of organizations. The administration buys new yalinkas, the Institutes - medical possessions, the likarni - licks, the ZhEKs - the services of vivening and sawing trees. Qi purchases are regulated by the federal law with the announcement of tenders before the signing of the contract and the sale of the goiter from the new one. Why can the manager of the tender office tell the robot, let's take a look at the procurement rules of 44 FZ.

How to know the required tender

Sob not to pay a lot of pennies to intermediary firms, as they will provide information about new tenders, purchases, what to call, you can search independently and without cost on this site. Suppose, our company is engaged in the supply of new gifts. We type the word "gift" from the search system - and we filter all purchases with the words "gifts", "gifts" and in other windows.

You can type the word "holy", but then, if you need it, tenders are filtered for all the holidays. And yet, the company takes an active part in tenders and spends the whole hour conducting new auctions - choosing them from the list is not so laborious.

What do we know about the tender?

Let's say that we've got a tender, we go to the new one, and the first depositor has a bachimo important information for the procurement procedure, for example, the form of procurement - an auction or a quotation, as an auction - on which Maidan will be held, if the sum needs to be transferred to the Maidan as a security of participation, before which term it is necessary to apply for participation, if the auction is held.

І naturally robimo rozrahunok - chi mi passable for the price, chi vigidno us to take part in these auctions, to the extent that we can reduce the price, in different active auctions. Evaluate your ability - what is the goods in the warehouse, if not - what can we do to prepare and buy. Serious and kindly post-employee verazo oc_nyuє svoї mozhlivostі shchodo vykonannya termіnіv delivery and vіdpovіdnostі goods that are delivered, we assign technical characteristics. It is also necessary to deposit at the counter the necessary amount for securing the contract, as indicated in the documentation (often 5 - 10% of the postal sum of the contract).

From another contributor "Purchasing documents" I have attached the auction documentation. Nіy Zamovnik may have but reportly made a report on purchases: technical orders, a draft contract, an information card from the appointed minds of payment for the supply of goods to a vikonan robot, penalties and other important information.

If we didn’t understand the technical manager - we can write to the Zamovnik for clarification (updated through the form on the electronic Maidan) and check that you are correct and that you have made changes to the initial version of the documentation. Ale, in any case, as we are submitting an application for participation in the auction, it means that we will wait with the minds of the deputy, then it is not possible to change the appointed terms of payment, nor the terms of delivery, it is necessary to contemplate the contract. Yakscho, obviously, we don’t want to be put on the black list or pay a penalty.

When filling out an application for the participation of a copy of the technical manager, picking up all non-specific indications, robimo їx accurate, і with whom, scho vіdpovіdat dіysnostі, passport virob, that product, which we want to request for delivery ( mi w DOBROSVIDNI postal workers), we can indicate trademark, virobnika, we choose the words analogue, equivalent, more, less, guilty buti, otherwise, vіd i do. Proponovan you products can be under another trade mark, that kind of other breeder, smut, they won't be equal, or they overturned for technical characteristics.

Deyakі important nuances, like it is necessary to protect that brother to respect, choosing to take part in the auction:

The hour of the end of filing an application for participation is the hour of the auction on the website of the purchase. If it is appointed, that the auction at the deputy from Khabarovsk is recognized for rank 9, then the participant from Moscow may be ready to take the fate of the new one for 2 years. night.

As an auction of tsikaviy, ale Participant of the rose, if you won’t be able to put the goods at the lines - you respectfully respect the penalties (yakі inevitably) she pledges them minimum amount before participating in the auction. Tobto the estimated amount of potential penalties is laid down at the auction and the participant's sum does not decrease lower.

І zovsіm elementary porada - revise the prepared Application for the omission of the "barred" word, dial the keys - Ctri + F. And then it’s even more covered, if they don’t allow you to participate in a couple of zayvih letters, missed out of disrespect.

Part of the rest, lyrical:

Who are all these people, what do you all want

Applying for participation in the auction, having prepared a competent application for the right to become successful, winning the auction is not easy. At the same time, submit applications and great post-employees, and vipadkov people, dealers. Who stink, why can you go down for the price, lower in the case of co-branding, who stink for the goods at the time of your victory ... Tse rhetorically food.

For example, the first channel recently talked about those who won a participant in the auction for faces for seriously ill children, who reduced the price by 5 million rubles during the auction. For some kind of tribute, the faces can’t cheaply cover the flooring, blame the fight - for this contract to supply the right faces, or, for example, the cradle in capsules.

In any case, the Organizers of the purchaser want to take away the same goods, the very one that stinks "smear on the street", describing its characteristics. And the virobniks are the sellers, like commercial organizations I want to put yogo, and I want to earn a little money for this. I'm good, if everyone comes out!))

"Official site Russian Federation at the “Internet” measure for the placement of information about the placement of an order for the supply of goods, the provision of services, the provision of services ... appointments for the provision of free and free access to full and reliable information about the contract system in the field of procurement of goods, services, types of legal goods, services, work osib osib, as well as for molding, processing and saving such information. ”

• Federal law dated 21.07.2005 N 94-FZ (as amended dated 02.07.2013) "On the placement of a loan for the supply of goods, the recruitment of workers, the provision of services for state and municipal needs"
• Federal law dated 18.07.2011 N 223-FZ (as amended on 12.03.2014, amended on 29.12.2014) "On the procurement of goods, work, services and other types of legal services" from 01.01.2015)
• Federal law dated 05.04.2013 N 44-FZ (as amended on 03/08/2015) "On the contract system in the sphere of procurement of goods, work, services for the provision of state and municipal needs"

Options for retrieving statements about government purchases

Let's change the options for the implementation of the task.

1. CBO website (derzhzakupivel)

Noodles:

• Search works insufficiently correctly, there are no other competitions. I am a certificate of a long-time slave to myself through the official site, confirmed by me;
• The site often does not work on holy nights;
• Feeing at a number of results. If you look for more than 500 rows, the search for data about contests (in the form of a table in .csv format) is impossible for the site.

In two words, the plug-in has formed the address at the look of approximately the following row:

"http://zakupki.gov.ru/epz/order/extendedsearch/search.html?" + "placeOfSearch=FZ_44" + "&orderPriceFrom=" + priceArray[i] + "&orderPriceTo=" + (priceArray-1) + "&orderPriceCurrencyId=-1" + "&orderPublishDateFrom=" + OrderDate + "&orderPublish &headAgencyWithSubElements=true&matchingWordPlace44=NOTIFICATIONS" + "&law44.okpd.withSubElements=true" + "&law44.okpd.ids=31301%2C37097%2C50876%2C5&ad=" I&law44.advantages=I" + "&morphology=false&strictEqual=false";
Naturally, for 94 and 223 the law of the parameters of the supply інші. As you can see, OKPD, the range of prices is too thin. to be “sewn up” in the request, because otherwise the number of known competitions will be too great and the results of the search can be more often than not.

2. Specialized web-services for searching contests

Dekіlka of such systems:

• Multitender.ru: “no cost specialty Poshukov system, which allows you to hold state purchases and commercial tenders”;
• TenderCAT: “TenderCAT catalog of appointments for facilitating the search for state-owned and commercial tenders and auctions from the great mass of publicly published on the portal of state purchasers (http://zakupki.gov.ru) in all regions and direct activities”;
• Іst Budget: "The website of the government purchaser and tender best poshukі analytics vіd Іst Budget”;

Metoyu tsієї statti not є porivnyannya or analysis of significant resources, to that neither їx perevaga, nor nedolіki here not be directed.

3. Independent technology for winning competitions.

Trapplyayutsya butts zamovlennya descriptions of the work of freelancers. For example, on SQL.ru, on Weblancer. Zreshtoy, you can come up with a ready solution from the “overwhelmed by the hour” vikonavtsiv. Prote the main part of the section of the article describes the procedure for independent vikonnannya zavdannya.

Data acquisition about competitions from http://zakupki.gov.ru using Excel VBA

Weekly data

Addresses of ftp servers distributed according to federal laws, which can be used for placing tenders:
Federal Law No. 223: ftp://ftp.zakupki.gov.ru/out/

Login and password:

Login and password:

1. 94fz catalogue, which should cover data of public appearances up to 94FZ (other catalogs - 44FZ),
2. fcs_regions catalogue, scho to avenge the data of the total regional vivantage published on the OOS information in accordance with 94FZ.

Other catalogs should contain regulatory and regulatory information, information about bank guarantees, compliance with the rules and, within the framework of the order, do not become of interest.

According to the regional context, include all documents of the following types published on the OOS:
publication of notices;
publication of change notices;
published protocols;
published bulletins about contracts;
publication of changes in contracts;
Published information about vikonannya/attached to contracts.

Vivantage is saved in XML files that are archived.
In one file, there can be documents of more than one type in a quantity that does not exceed 3000 records. As a number of documents, which revitalize, revisit 3000 records, the system forms a large number of files and stores a large number of archives.
All generated and archived XML-files are browsed to the FTP-server… files are located in the assigned distribution for directories that correspond to the region. The skin catalog region has 3 more directories: notifications, protocols and contracts. For skin catalogs notifications, protocols and contracts, additionally, the daily catalog.
Published documents are uploaded to the FTP server in the following order:
· The next calendar day (day) displays the list of documents published for the previous calendar day. At the same time ... promotional support for the region<Наименование региона>/notifications/daily;
· Leather calendar month (shomisyatsya) view the list of documents published for the previous calendar month. At the same time ... promotional support for the region<Наименование региона>/notifications;
For a student and a six-month-old vivantage, all types of documents published in a few calendar days or a calendar month are always vivantage.
If there was no published document of this type at the time of the formation of the document, then the XML file with this type of document is considered empty.
After the completion of the six month vivantage, the catalogs with the last vivantage for the last month are cleared.
The names of the files in the regional view may have the following structure:
<вид-документа_регион_начало-периода_конец-периода_номер.xml.zip>,
de:
document-type – the value of notification, protocol or contract for information, protocols and statements about contracts is specified;
region - naming the region of expansion;
cob-period – date to the cob of the period for selection of documents by the date-hour of publication of vivantage documents in the format yyyyddmm_hhmmss, de yyyy – time, mm – month (number), dd – day, hh – year, mm – time, ss – seconds;
end-period - date of the end of the period for selecting documents by the date-hour of publication of the selected documents in the format yyyyddmm_hhmmss, de yyyy - date, mm - month (number), dd - day, hh - year, mm - date, ss - seconds;
number – sequence number of the generated file;

Description of the program for automatic capture of competitive information (VBA MS Excel, Windows).

Preparation

• Scripting Microsoft Scripting Runtime is included. For FSO functionality ( \Windows\System32\scrrun.dll)
• Enable Microsoft XML scripting, v.6

On the butt there is a range from 26 February to 4 February. Selected dates are read from the authorities of the Form:

MonthView.SelStart and MonthView.SelEnd
The axis of such a filter allows you to select files (the structure of names that we see) for a given range of dates:

Fltr = "*_" & Format(targetDate, "yyyymmdd") & "*" & Format(targetDate + 1, "yyyymmdd") & "*.zip;" & "*_" & Format(targetDate, "yyyymmdd") & "*" & Format(targetDate, "yyyymmdd") & "*.zip"
We have great respect for those who have a point with whom to distribute alternative options, to which the filter is suitable for files that are formed according to all three laws.

I'm saving the files in the given directory, so I clean up the old archives in advance by stopping the FSO methods:

Dim FSO As FileSystemObject Set FSO = New FileSystemObject
We select the target folder bFld = FSO.GetFolder(...) and delete the subdirectory:

For Each SubFolder In bFld.SubFolders SubFolder.Delete Next
Let's not talk about it, but let's go farther away with a "candy wrapper" until the program showed up the Application.Speech.Speak channel

Application.Speech.Speak "Downloading purchase notices", True
The other option is asynchronous wiping.

File upload

You can select all directories like this:

FtpItems.Filter 32, "*".
Select subdirectory and files ( 96=32+64 ) and put a filter on the sign of what kind of prompts on the beginning of the paragraph for the selection of files for the date - like this:

FtpItems.Filter 96, fltr.
You are asked to specify a target (local) folder for retrieval in a similar way:

Set tFolder = myShell.Namespace(tgtFolder)
І launch "copy" (it's "download") in an offensive rank:

TFolder.CopyHere ftpItems, 20
This command starts the current process (Windows has a standard progress bar for copying files), and vba is not controlled without intermediary. However, we need to check the end of the wiki, for which we use the next method in the cycle to check the presence of the rest of the files that are being copied:

While Len(Dir$(tgtFolder & "\" & ftpItems.Item(ftpItems.Count - 1).Name)) = 0 Sleep 1: DoEvents Wend
So vlashtovane "ochіkuvannya" trivaє exactly stіlki, sіlki copy files.

Unpacking (rozarchivation) of archived files

Application.Speech.Speak "Unzipping archives", True.
For whom I am again koristuєmosya method namespace .
Loop through all the archives in the folder For Each fl In tFolderItems
And thank you for remembering that these archives in Windows are remembered as subdirectories! Obviously, the entire archive is available as follows:

Set flItems = myShell.Namespace(CVar(tgtFolder & "\" & fl.Name)).Items
(I am starting to give respect to those who can Variant , Through which it is necessary to change the type of charge).

I call the same team CopyHere allows you to "copy" (really extract) from the archive all files to a target folder: myShell.Namespace(tgtFolder).CopyHere flItems, 20
and the asynchronous vikonannnya zmushuє us at the cycle checks the end of the vikonannya tsієї command the same rank, which is described more.

There was a lot of confusion in the middle of the archived files. For example, in some regions there were no annual buyers on the first day, the OOS generates an empty file for the same date. That's the first, lower xml parsing, I will see the download. Vikoristovuyuchi FSO, sorting through the files.

Set fold = FSO.GetFolder(tgtFolder) For Each fl In fold.Files
"Vidsiv" is easy to expand by file size (fl.Size<= 198) ta filtering yogo name Not (LCase(fl.Name) Like "*noti*")) .

Viewing the file is even easier: fl.Delete

Decryption of XML from data about contests

Application.Speech.Speak "Decoding files", True.
For this part of the FSO crimson for working with files, we need XML:

Dim xml As MSXML2.DOMDocument60 Set xml = New DOMDocument60: xml.async = False: xml.validateOnParse = True
I, obviously, whole leaf ( ActiveSheet) at the Excel book, where we will write down the information.
For some reason, we can draw Excel for an hour, so that it “didn’t blink”:

Application.ScreenUpdating = False
An important point is those that

XPath handles an empty prefix as null names. In addition, it seems that XPath queries can be tagged with less prefixes, inscribed with the expanses of names. This means that it is necessary to prompt up to the space of names in the XML document, then it is necessary to assign a prefix for it.

Xml.setProperty "SelectionNamespaces", " xmlns:q="http://zakupki.gov.ru/oos/export/1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:oos="http://zakupki.gov.ru/oos/types/1""
So looking at the scope of names for the analysis of xml, formed according to 94 FZ. For 44 won there will be three extra:

Xml.setProperty "SelectionNamespaces", "xmlns:q="http://zakupki.gov.ru/oos/types/1" xmlns:ns2="http://zakupki.gov.ru/oos/export/1" xmlns:ns3="http://zakupki.gov.ru/oos/printform/1""
All data is taken from the heading of the xml-file, however, for the sake of space, the names are given for locking q.

Further fields are specified (more precisely, xpath , what is pointed out to them), so it is necessary to take advantage. At the moment, for 94 Federal Laws, the stench looks something like this: ".//oos:notificationNumber", ".//oos:lot", ".//oos:orderName", ".//oos:maxPrice". For 44 FZ - another structure (for any OS programmers): ".//q:purchaseNumber", ".//q:lot", ".//q:purchaseObjectInfo", ".//q:maxPrice|.// q:price|.//q:totalSum".

Bachimo, there is no unambiguity, nalashtovuvati parsing is carried out as a spiral on the publication of the scheme, and the authorities have a practical way of deciphering the data.

Verify that the xml-file can be read by a smart mind:

If Not xml.Load(tgtFolder & "\" & fl.Name) then…If (xml.parseError.ErrorCode<>0) then…
Even though the file was read (dosi I had no problems with the OOS files), you can sort it out. We recommend that you read the field that describes the storage warehouse ( Notice).

PurchaseType = LCase(xml.DocumentElement.ChildNodes(0).BaseName) documentType = LCase(xml.DocumentElement.BaseName)
І perevirity, scho file - tse same voiced about the competition, and not skasuvanya yogo, podomlennya about the publication of the protocol just. something like this:

If Not (purchaseType Like "*cancel*" or purchaseType Like "*protocol*" Or documentType Like "*cancel*") Then
Oskіlki in xml, formed according to 223 FZ, calling the type of document "captured", you can add:

If (purchaseType Like "*notification*" or documentType Like "*notice*") Then
Let's go ahead and write data from xml in the middle of the arc:

Range("A" & i) = xml.DocumentElement.SelectSingleNode(RowXPathcorrespondingFields).Text
І etc.
In addition, XPath can give a few options (instruction, for example, in the name of the lot) and we want to save everything, in addition to such a construction:

For Each it In lot.SelectNodes(XPath row of correspondingFields) Range("E" & i) = Range("E" & i) & it.Text & "; " Next
The active fields in the document can be daily, but they can be skipped mentally:

If Not xml.DocumentElement.SelectSingleNode(RowXPathRespectFields) Is Nothing Then

Visnovok

After downloading, automatic ranking (selection) and formatting the list of contests, my chosen selection of contests (according to the Federal Law) looks something like this:

More descriptions allow you to capture data about competitions, contracts, plans, buyers, etc. s OOS, even if all information is published on open ftp. I don’t direct the whole program code and I can’t direct, shards of wine are intellectual power. However, it is possible to support the program by pointing the key points to the code vba and, what is more important, be patient.

You need to be patient, first of all, when sorting out files and subdirectories on ftp: you don’t need to take a loan and don’t waste your money. І in a different way, when parsing xml. However, there is already a nourishment for the task set: like the field itself, like a sequence, like formatting if you want a bachiti deputy.

Usim good luck and won: - at competitions - that special!

If you work in a budgetary setting, or serve such organizations as well as it-security, you may need to carry out the procedure for setting up and connecting work stations for robots with sovereign resources. Tse services of state procurement. At once we will analyze the process of krokiv.

zakupki.gov.ru - wins for placing information about state purchases and jobs in the trading system.

bus.gov.ru - distribution of official information about the budgetary regulations.

Your organization may need access to these resources for work purposes or as a mandate. If you like, you need to know how the process of registration and connection to systems works.

Now let's wonder how to register on the site of holders of purchases.

Register on zakupki.gov.ru

The whole process can be mentally divided into two stages:

Official registration and withdrawal of valid documents and permits
- technical part, installation and adjustment

For work, you need an EDS (electronic digital signature) and an electronic certificate. Everything you need to see after registration with the federal treasury. Instructions and necessary documents published on the site:

Roskazna.ru

As a rule, the EDC and certificates for robots from the procurement site.gov.ru are issued on floppy disks or flash drives. If the stench appears on your hands, you can go on to fixing the computer, which is planned to be done by the robot.

Technical part

Here you need to install special programs and correct your operating system in the correct order. Let's go through the process, step by step, from the assigned list of what you need from the robot.

Operating system

For the work with the site, the government purchased Windows XP or 7. The operating systems themselves are the most wide-ranging, and, sing-songly, they won over from that organization, so you happen to carry out the upgrade.

Browser

For correct work it is necessary to tweak Internet Explorer 8 version. You can find the process of installing and updating the browser at the material -.

NetFramework platform

The NetFramework platform must be installed on the computer, but not lower than version 2.0. It is also necessary to install the SP1 update package.

http://www.microsoft.com/en-us/download/details.aspx?id=16614

Set to normal mode.

Component for shaping Sign

For the correct operation of the EDS, the presence of special software is required. You can take advantage of yoga for the help:

After the program is installed, you can immediately install a personal certificate, deducted from the Treasury. To run CryptoPro, specify the place to save the certificate (diskette or flash drive) and install it.

Library Capicom

Change it and set it to the default mode:

Root certificates

It is necessary to install the treasury certificate on the computer:

After you have installed all the necessary software security and removed the documents and digital media, you can proceed to the browser setup.

Improved Internet Explorer

For the correct operation of the procurement.gov.ru site, we can add it to the list of trusted nodes in our browser.

Now we select the item "Nadіyni sites", and click the button "Sites". Here we type the address of the site of the purchaser, and add it to the list of trustees. I recommend that you add the site with http and https protocols. In the sub-bag of the list, you can have the following:

http://zakupki.gov.ru https://zakupki.gov.ru

After that, go to the "Dodatkovo" tab, and then tick off the SSL 2.0 and SSL 3.0 checkboxes.

Save the next one.

After all the steps have been completed, you can go to the site zakupki.gov.ru and log in to the special office.

Bus.gov.ru

Vіdpovіdno for access to the site, you have to be able to register and withdraw data for access to the site of state buyers.

Just try the signature file, turn it over, and the Sign signature forming component is installed.

If you feel like it, if you blame other problems or food, you can always put them online for us. For whom, hurry up with the service.

Visnovok

Hurry up with the service of purchasers, for the distribution of information on goods or services. You can also take part in the auction, in order to take away the charm.

How to find information on other sites, how is everything selected?

• at the registration process