Skip to Content

разбор по номиналам

  • warning: Creating default object from empty value in /usr/local/www/sites/main/modules/taxonomy/taxonomy.pages.inc on line 33.
  • strict warning: Only variables should be passed by reference in /usr/local/www/sites/main/sites/all/themes/zeropoint/template.php on line 340.
  • strict warning: Only variables should be passed by reference in /usr/local/www/sites/main/sites/all/themes/zeropoint/template.php on line 340.
  • strict warning: Only variables should be passed by reference in /usr/local/www/sites/main/sites/all/themes/zeropoint/template.php on line 340.
  • strict warning: Non-static method view::load() should not be called statically in /usr/local/www/sites/main/sites/all/modules/views/views.module on line 906.
  • strict warning: Declaration of views_handler_argument::init() should be compatible with views_handler::init(&$view, $options) in /usr/local/www/sites/main/sites/all/modules/views/includes/handlers.inc on line 76.
  • strict warning: Non-static method views_many_to_one_helper::option_definition() should not be called statically, assuming $this from incompatible context in /usr/local/www/sites/main/sites/all/modules/views/handlers/views_handler_argument_many_to_one.inc on line 35.
  • strict warning: Non-static method views_many_to_one_helper::option_definition() should not be called statically, assuming $this from incompatible context in /usr/local/www/sites/main/sites/all/modules/views/handlers/views_handler_argument_many_to_one.inc on line 35.
  • strict warning: Declaration of views_handler_filter::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /usr/local/www/sites/main/sites/all/modules/views/includes/handlers.inc on line 76.
  • strict warning: Declaration of views_handler_filter::options_submit() should be compatible with views_handler::options_submit($form, &$form_state) in /usr/local/www/sites/main/sites/all/modules/views/includes/handlers.inc on line 76.
  • strict warning: Declaration of views_handler_filter_boolean_operator::value_validate() should be compatible with views_handler_filter::value_validate($form, &$form_state) in /usr/local/www/sites/main/sites/all/modules/views/includes/handlers.inc on line 76.

Excel - разбор резисторов по номиналам

вот так это выглядит в excelПришла немаленькая кучка чип-резисторов.

Надо бы занести в табличку - что есть, сколько, какой корпус и т.д. Но вот опять заморочки с номиналами: некоторые поставщики пишут 1,2 kOhm, некоторые 1к2 (с РУССКИМ "к"!) etc. Бардак, короче.

А хочется ж однообразно, и сортировка, опять таки... Пол-года назад брался, но ничего не вышло - тупо не получалось заставить использовать Excel написаную функцию. Но - сегодня получилось. Рад, аж на стуле подпрыгиваю.

 

RSS-материал