Solution of optimization in Excel

I have several ready-made samples of steam fireplaces, including a model that serves as a reference for quality, design, and functionality. The task is to develop a proprietary product under our own brand based on the analysis of existing solutions. Main tasks: complete technical analysis of existing samples; disassembly of the structure and components; determination of the operating principle of all units; preparation of technical documentation; creation of a bill of materials (BOM); selection of alternative suppliers for components; cost evaluation of production; development of the concept for our own product; preparation of a plan for transitioning from prototype to mass production.

Output data: Existing building: single-story office building; structural scheme — frame-less brick; external walls thickness 380–640 mm; internal load-bearing walls thickness 380–510 mm; ceilings — precast reinforced concrete hollow-core slabs; foundations — columnar with FBS blocks; approximate dimensions of the building — 40.34 × 28.84 m; building area — about 747 m². Planned: dismantling of the existing rafter system and roof; addition of a second floor with glued laminated timber structures; installation of a new wooden roof structure; reconstruction of the existing building with partial changes in loads on load-bearing structures.Required to perform: Analysis of the provided technical report on the building inspection. Verification calculation of existing foundations, walls, and ceilings for the perception of additional loads from the addition. Development of structural solutions regarding: installation of reinforced belts; strengthening of brick walls; strengthening of foundations (if necessary); ensuring spatial rigidity of the building; nodes for load transfer from glued laminated timber structures to the existing building. Calculation and justification of the adopted solutions. Issuance of a set of drawings for the stages of KB/CM/KZ (depending on the adopted solutions). Consulting support during the development of wooden structures and implementation of the project.Output documentation: Scientific and technical report on the building inspection. Measurement drawings. Architectural solutions for the addition. Preliminary concept of glued laminated timber structures.Requirements for the contractor: availability of a design engineer certificate in terms of ensuring mechanical resistance and stability; experience in the reconstruction of existing buildings; experience in designing the strengthening of brick or stone buildings; preferred experience working with additions of wooden structures or glued laminated timber.Message text for Freelancehunt Good day. We are looking for a designer to participate in the project of reconstructing an existing single-story brick office building with a subsequent addition of a second floor made of glued laminated timber. It is necessary to take on the development of structural solutions regarding: reinforced belts; strengthening of existing brick walls; if necessary — strengthening of foundations; ensuring spatial rigidity of the building; load transfer from new wooden structures to the existing building. A technical inspection of the building and measurement drawings have been completed, which will be provided to the contractor after preliminary discussion of the project. Preferred experience: reconstruction of existing buildings; development of solutions for strengthening stone or brick structures; work with additions or wooden structures. Please include in your response: a brief overview of your experience; examples of similar completed projects; available certificates; estimated budget and timelines for the work. We are ready for long-term cooperation on similar projects.

I'm looking for a practicing lawyer or attorney. I need a description of one real case from personal experience. What needs to be done: Provide a description of one case, as well as real documents related to the case with confidential information removed (names, addresses, case numbers, amounts replaced with conditional ones). The description should include: • what the task was (to prepare a response, an appeal, a motion, etc.) • what documents were involved in the work • how the search for similar court decisions was conducted in the registers (Unified State Register of Court Decisions and others), what keywords were used, what criteria were used to filter the results, what legal norms were relied upon during the search • what decisions were found, why they were relevant, and how their similarity to the current case was assessed • how the found case law influenced the formation of the action strategy and the preparation of the document The key focus: it is important for us to understand the logic of the search, how a lawyer moves from a specific case to similar judicial decisions in order to build a defense strategy or position.