Guest User

transformer calculater as sql view

a guest
Apr 7th, 2022
171
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.94 KB | None | 0 0
  1. create view transformer_calculated as (
  2. with
  3. calc1 as (
  4. select
  5. transformer_parameter.id,
  6. center_leg_mm * stack_height_mm as crosssection_mm2,
  7. center_leg_mm / 2 * center_leg_mm / 2 * 3 as window_area_mm2,
  8. 2 * center_leg_mm + 2 * stack_height_mm + (center_leg_mm / 2) * pi() as avg_turn_length_mm,
  9. center_leg_mm * 3 * center_leg_mm * 2 * stack_height_mm / 1000000 * 7.7 as iron_weight_kg,
  10. ( ( 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
  11. from
  12. transformer_parameter
  13. ),
  14.  
  15. calc2 as (
  16. select
  17. transformer_parameter.id,
  18. calc1.window_area_mm2 * fill_factor as copper_area_mm2,
  19. flux_density_t ^ 2 * loss_wpkg1t50hz * calc1.iron_weight_kg * frequency_hz / 50 as iron_loss_w,
  20. 1 / (calc1.crosssection_mm2 / 1000000) / 4.44 / frequency_hz / flux_density_t as turns_per_volt
  21. from
  22. transformer_parameter
  23. join calc1 on transformer_parameter.id = calc1.id
  24. ),
  25.  
  26. calc3 as (
  27. select
  28. transformer_parameter.id,
  29. primary_v * calc2.turns_per_volt as primary_turns,
  30. secondery_noload_v * calc2.turns_per_volt as secondary_turns,
  31. calc2.copper_area_mm2 * calc1.avg_turn_length_mm / 1000000 * 8.93 as copper_weight_kg
  32. -- M14*I15/1000000*8.93
  33. -- M14 copper_area_mm2
  34. -- I15 avg_turn_length_mm
  35. from
  36. transformer_parameter
  37. join calc1 on transformer_parameter.id = calc1.id
  38. join calc2 on transformer_parameter.id = calc2.id
  39. ),
  40.  
  41. calc4 as (
  42. select
  43. transformer_parameter.id,
  44. calc2.copper_area_mm2 / 2 / calc3.primary_turns as primary_area_mm2,
  45. calc2.copper_area_mm2 / 2 / calc3.secondary_turns as secondary_area_mm2,
  46. calc3.primary_turns * calc1.avg_turn_length_mm / 1000 as primary_length_m
  47. -- calc1.iron_weight_kg * iron_dpkg + calc3.copper_weight_kg * copper_dpkg as cost_doller,
  48. from
  49. transformer_parameter
  50. join calc1 on transformer_parameter.id = calc1.id
  51. join calc2 on transformer_parameter.id = calc2.id
  52. join calc3 on transformer_parameter.id = calc3.id
  53. ),
  54.  
  55. calc5 as (
  56. select
  57. transformer_parameter.id,
  58. calc4.primary_area_mm2 / cross_section_mmpa as primary_ampere
  59. from
  60. transformer_parameter
  61. join calc4 on transformer_parameter.id = calc4.id
  62. ),
  63.  
  64. calc6 as (
  65. select
  66. transformer_parameter.id,
  67. primary_v * calc5.primary_ampere as input_power_va,
  68. calc5.primary_ampere * calc4.primary_length_m / calc4.primary_area_mm2 * 0.02 * 2 / primary_v as voltage_drop_ratio
  69. from
  70. transformer_parameter
  71. join calc4 on transformer_parameter.id = calc4.id
  72. join calc5 on transformer_parameter.id = calc5.id
  73. ),
  74.  
  75. calc7 as (
  76. select
  77. transformer_parameter.id,
  78. calc6.voltage_drop_ratio * calc6.input_power_va as copper_loss_w
  79. from
  80. transformer_parameter
  81. join calc5 on transformer_parameter.id = calc5.id
  82. join calc6 on transformer_parameter.id = calc6.id
  83. ),
  84.  
  85. calc8 as (
  86. select
  87. transformer_parameter.id,
  88. calc7.copper_loss_w + calc2.iron_loss_w as total_loss_w
  89. from
  90. transformer_parameter
  91. join calc2 on transformer_parameter.id = calc2.id
  92. join calc7 on transformer_parameter.id = calc7.id
  93. )
  94.  
  95.  
  96. select
  97. transformer_parameter.id,
  98. name,
  99. center_leg_mm,
  100. stack_height_mm,
  101. loss_wpkg1t50hz,
  102. primary_v,
  103. secondery_noload_v,
  104. frequency_hz,
  105. flux_density_t,
  106. cross_section_mmpa,
  107. fill_factor,
  108. temperature_rise_k,
  109. description,
  110. calc1.crosssection_mm2 as crosssection_mm2,
  111. calc1.window_area_mm2 as window_area_mm2,
  112. calc2.copper_area_mm2 as copper_area_mm2,
  113. calc2.turns_per_volt as turns_per_volt,
  114. calc1.avg_turn_length_mm as avg_turn_length_mm,
  115. primary_v * calc2.turns_per_volt as primary_turns,
  116. calc4.primary_length_m as primary_length_m,
  117. calc4.primary_area_mm2 as primary_area_mm2,
  118. calc5.primary_ampere as primary_ampere,
  119. calc3.secondary_turns as secondary_turns,
  120. calc3.secondary_turns * calc1.avg_turn_length_mm / 1000 as secondary_length_m,
  121. calc4.secondary_area_mm2 as secondary_area_mm2,
  122. calc4.secondary_area_mm2 / cross_section_mmpa as secondary_ampere,
  123. calc6.input_power_va as input_power_va,
  124. calc8.total_loss_w / calc6.input_power_va as power_loss_ratio,
  125. calc6.voltage_drop_ratio as voltage_drop_ratio,
  126. calc2.iron_loss_w as iron_loss_w,
  127. calc7.copper_loss_w as copper_loss_w,
  128. calc8.total_loss_w as total_loss_w,
  129. secondery_noload_v * (1 - calc6.voltage_drop_ratio) as loaded_out_v,
  130. calc1.surface_area_m2 as surface_area_m2,
  131. calc8.total_loss_w / calc1.surface_area_m2 / temperature_rise_k as required_thermal_transfer_coefficient_wpm2k,
  132. calc1.iron_weight_kg as iron_weight_kg,
  133. calc3.copper_weight_kg as copper_weight_kg
  134. -- calc3.cost_doller as cost_doller,
  135. -- calc3.cost_doller / calc6.input_power_va as doller_per_watt
  136.  
  137. from
  138. transformer_parameter
  139. join calc1 on transformer_parameter.id = calc1.id
  140. join calc2 on transformer_parameter.id = calc2.id
  141. join calc3 on transformer_parameter.id = calc3.id
  142. join calc4 on transformer_parameter.id = calc4.id
  143. join calc5 on transformer_parameter.id = calc5.id
  144. join calc6 on transformer_parameter.id = calc6.id
  145. join calc7 on transformer_parameter.id = calc7.id
  146. join calc8 on transformer_parameter.id = calc8.id
  147.  
  148. );
  149.  
Advertisement
Add Comment
Please, Sign In to add comment