Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create view transformer_calculated as (
- with
- calc1 as (
- select
- transformer_parameter.id,
- center_leg_mm * stack_height_mm as crosssection_mm2,
- center_leg_mm / 2 * center_leg_mm / 2 * 3 as window_area_mm2,
- 2 * center_leg_mm + 2 * stack_height_mm + (center_leg_mm / 2) * pi() as avg_turn_length_mm,
- center_leg_mm * 3 * center_leg_mm * 2 * stack_height_mm / 1000000 * 7.7 as iron_weight_kg,
- ( ( center_leg_mm * 6 + center_leg_mm * 5 ) * stack_height_mm + 2 * center_leg_mm * 3 * center_leg_mm * 2.5 + center_leg_mm * 4) / 1000000 as surface_area_m2
- from
- transformer_parameter
- ),
- calc2 as (
- select
- transformer_parameter.id,
- calc1.window_area_mm2 * fill_factor as copper_area_mm2,
- flux_density_t ^ 2 * loss_wpkg1t50hz * calc1.iron_weight_kg * frequency_hz / 50 as iron_loss_w,
- 1 / (calc1.crosssection_mm2 / 1000000) / 4.44 / frequency_hz / flux_density_t as turns_per_volt
- from
- transformer_parameter
- join calc1 on transformer_parameter.id = calc1.id
- ),
- calc3 as (
- select
- transformer_parameter.id,
- primary_v * calc2.turns_per_volt as primary_turns,
- secondery_noload_v * calc2.turns_per_volt as secondary_turns,
- calc2.copper_area_mm2 * calc1.avg_turn_length_mm / 1000000 * 8.93 as copper_weight_kg
- -- M14*I15/1000000*8.93
- -- M14 copper_area_mm2
- -- I15 avg_turn_length_mm
- from
- transformer_parameter
- join calc1 on transformer_parameter.id = calc1.id
- join calc2 on transformer_parameter.id = calc2.id
- ),
- calc4 as (
- select
- transformer_parameter.id,
- calc2.copper_area_mm2 / 2 / calc3.primary_turns as primary_area_mm2,
- calc2.copper_area_mm2 / 2 / calc3.secondary_turns as secondary_area_mm2,
- calc3.primary_turns * calc1.avg_turn_length_mm / 1000 as primary_length_m
- -- calc1.iron_weight_kg * iron_dpkg + calc3.copper_weight_kg * copper_dpkg as cost_doller,
- from
- transformer_parameter
- join calc1 on transformer_parameter.id = calc1.id
- join calc2 on transformer_parameter.id = calc2.id
- join calc3 on transformer_parameter.id = calc3.id
- ),
- calc5 as (
- select
- transformer_parameter.id,
- calc4.primary_area_mm2 / cross_section_mmpa as primary_ampere
- from
- transformer_parameter
- join calc4 on transformer_parameter.id = calc4.id
- ),
- calc6 as (
- select
- transformer_parameter.id,
- primary_v * calc5.primary_ampere as input_power_va,
- calc5.primary_ampere * calc4.primary_length_m / calc4.primary_area_mm2 * 0.02 * 2 / primary_v as voltage_drop_ratio
- from
- transformer_parameter
- join calc4 on transformer_parameter.id = calc4.id
- join calc5 on transformer_parameter.id = calc5.id
- ),
- calc7 as (
- select
- transformer_parameter.id,
- calc6.voltage_drop_ratio * calc6.input_power_va as copper_loss_w
- from
- transformer_parameter
- join calc5 on transformer_parameter.id = calc5.id
- join calc6 on transformer_parameter.id = calc6.id
- ),
- calc8 as (
- select
- transformer_parameter.id,
- calc7.copper_loss_w + calc2.iron_loss_w as total_loss_w
- from
- transformer_parameter
- join calc2 on transformer_parameter.id = calc2.id
- join calc7 on transformer_parameter.id = calc7.id
- )
- select
- transformer_parameter.id,
- name,
- center_leg_mm,
- stack_height_mm,
- loss_wpkg1t50hz,
- primary_v,
- secondery_noload_v,
- frequency_hz,
- flux_density_t,
- cross_section_mmpa,
- fill_factor,
- temperature_rise_k,
- description,
- calc1.crosssection_mm2 as crosssection_mm2,
- calc1.window_area_mm2 as window_area_mm2,
- calc2.copper_area_mm2 as copper_area_mm2,
- calc2.turns_per_volt as turns_per_volt,
- calc1.avg_turn_length_mm as avg_turn_length_mm,
- primary_v * calc2.turns_per_volt as primary_turns,
- calc4.primary_length_m as primary_length_m,
- calc4.primary_area_mm2 as primary_area_mm2,
- calc5.primary_ampere as primary_ampere,
- calc3.secondary_turns as secondary_turns,
- calc3.secondary_turns * calc1.avg_turn_length_mm / 1000 as secondary_length_m,
- calc4.secondary_area_mm2 as secondary_area_mm2,
- calc4.secondary_area_mm2 / cross_section_mmpa as secondary_ampere,
- calc6.input_power_va as input_power_va,
- calc8.total_loss_w / calc6.input_power_va as power_loss_ratio,
- calc6.voltage_drop_ratio as voltage_drop_ratio,
- calc2.iron_loss_w as iron_loss_w,
- calc7.copper_loss_w as copper_loss_w,
- calc8.total_loss_w as total_loss_w,
- secondery_noload_v * (1 - calc6.voltage_drop_ratio) as loaded_out_v,
- calc1.surface_area_m2 as surface_area_m2,
- calc8.total_loss_w / calc1.surface_area_m2 / temperature_rise_k as required_thermal_transfer_coefficient_wpm2k,
- calc1.iron_weight_kg as iron_weight_kg,
- calc3.copper_weight_kg as copper_weight_kg
- -- calc3.cost_doller as cost_doller,
- -- calc3.cost_doller / calc6.input_power_va as doller_per_watt
- from
- transformer_parameter
- join calc1 on transformer_parameter.id = calc1.id
- join calc2 on transformer_parameter.id = calc2.id
- join calc3 on transformer_parameter.id = calc3.id
- join calc4 on transformer_parameter.id = calc4.id
- join calc5 on transformer_parameter.id = calc5.id
- join calc6 on transformer_parameter.id = calc6.id
- join calc7 on transformer_parameter.id = calc7.id
- join calc8 on transformer_parameter.id = calc8.id
- );
Advertisement
Add Comment
Please, Sign In to add comment