~m3__23832.twbr 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295
  1. <?xml version='1.0' encoding='utf-8' ?>
  2. <!-- build 20212.21.1214.2055 -->
  3. <workbook source-build='2021.2.6 (20212.21.1214.2055)' source-platform='win' version='18.1' xmlns:user='http://www.tableausoftware.com/xml/user'>
  4. <document-format-change-manifest>
  5. <_.fcp.AnimationOnByDefault.true...AnimationOnByDefault />
  6. <_.fcp.MarkAnimation.true...MarkAnimation />
  7. <_.fcp.ObjectModelEncapsulateLegacy.true...ObjectModelEncapsulateLegacy />
  8. <_.fcp.ObjectModelTableType.true...ObjectModelTableType />
  9. <_.fcp.SchemaViewerObjectModel.true...SchemaViewerObjectModel />
  10. <SheetIdentifierTracking />
  11. <WindowsPersistSimpleIdentifiers />
  12. </document-format-change-manifest>
  13. <preferences>
  14. <preference name='ui.encoding.shelf.height' value='24' />
  15. <preference name='ui.shelf.height' value='26' />
  16. </preferences>
  17. <_.fcp.AnimationOnByDefault.false...style>
  18. <_.fcp.AnimationOnByDefault.false..._.fcp.MarkAnimation.true...style-rule element='animation'>
  19. <_.fcp.AnimationOnByDefault.false...format attr='animation-on' value='ao-on' />
  20. </_.fcp.AnimationOnByDefault.false..._.fcp.MarkAnimation.true...style-rule>
  21. </_.fcp.AnimationOnByDefault.false...style>
  22. <datasources>
  23. <datasource caption='m3_0103' inline='true' name='federated.1en4l9j0z5yqpt1fw8raf1kz99ys' version='18.1'>
  24. <connection class='federated'>
  25. <named-connections>
  26. <named-connection caption='m3_0103' name='textscan.0erpzzc0a7kcbg12etxg11nmdoos'>
  27. <connection class='textscan' directory='C:/Users/User/Desktop/ssd-work/homeiot/preproc' filename='m3_0103.csv' password='' server='' />
  28. </named-connection>
  29. </named-connections>
  30. <_.fcp.ObjectModelEncapsulateLegacy.false...relation connection='textscan.0erpzzc0a7kcbg12etxg11nmdoos' name='m3_0103.csv' table='[m3_0103#csv]' type='table'>
  31. <columns character-set='UTF-8' header='yes' locale='ko_KR' separator=','>
  32. <column datatype='datetime' name='timestamp' ordinal='0' />
  33. <column datatype='real' name='hum' ordinal='1' />
  34. <column datatype='real' name='temp' ordinal='2' />
  35. <column datatype='real' name='door' ordinal='3' />
  36. <column datatype='real' name='motion' ordinal='4' />
  37. <column datatype='real' name='illum' ordinal='5' />
  38. </columns>
  39. </_.fcp.ObjectModelEncapsulateLegacy.false...relation>
  40. <_.fcp.ObjectModelEncapsulateLegacy.true...relation connection='textscan.0erpzzc0a7kcbg12etxg11nmdoos' name='m3_0103.csv' table='[m3_0103#csv]' type='table'>
  41. <columns character-set='UTF-8' header='yes' locale='ko_KR' separator=','>
  42. <column datatype='datetime' name='timestamp' ordinal='0' />
  43. <column datatype='real' name='hum' ordinal='1' />
  44. <column datatype='real' name='temp' ordinal='2' />
  45. <column datatype='real' name='door' ordinal='3' />
  46. <column datatype='real' name='motion' ordinal='4' />
  47. <column datatype='real' name='illum' ordinal='5' />
  48. </columns>
  49. </_.fcp.ObjectModelEncapsulateLegacy.true...relation>
  50. <metadata-records>
  51. <metadata-record class='capability'>
  52. <remote-name />
  53. <remote-type>0</remote-type>
  54. <parent-name>[m3_0103.csv]</parent-name>
  55. <remote-alias />
  56. <aggregation>Count</aggregation>
  57. <contains-null>true</contains-null>
  58. <attributes>
  59. <attribute datatype='string' name='character-set'>&quot;UTF-8&quot;</attribute>
  60. <attribute datatype='string' name='collation'>&quot;ko&quot;</attribute>
  61. <attribute datatype='string' name='currency'>&quot;₩&quot;</attribute>
  62. <attribute datatype='string' name='debit-close-char'>&quot;&quot;</attribute>
  63. <attribute datatype='string' name='debit-open-char'>&quot;&quot;</attribute>
  64. <attribute datatype='string' name='field-delimiter'>&quot;,&quot;</attribute>
  65. <attribute datatype='string' name='header-row'>&quot;true&quot;</attribute>
  66. <attribute datatype='string' name='locale'>&quot;ko_KR&quot;</attribute>
  67. <attribute datatype='string' name='single-char'>&quot;&quot;</attribute>
  68. </attributes>
  69. </metadata-record>
  70. <metadata-record class='column'>
  71. <remote-name>timestamp</remote-name>
  72. <remote-type>135</remote-type>
  73. <local-name>[timestamp]</local-name>
  74. <parent-name>[m3_0103.csv]</parent-name>
  75. <remote-alias>timestamp</remote-alias>
  76. <ordinal>0</ordinal>
  77. <local-type>datetime</local-type>
  78. <aggregation>Year</aggregation>
  79. <contains-null>true</contains-null>
  80. <_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[m3_0103.csv_DFECFB17718A4819B318F673AF8CFAEC]</_.fcp.ObjectModelEncapsulateLegacy.true...object-id>
  81. </metadata-record>
  82. <metadata-record class='column'>
  83. <remote-name>hum</remote-name>
  84. <remote-type>5</remote-type>
  85. <local-name>[hum]</local-name>
  86. <parent-name>[m3_0103.csv]</parent-name>
  87. <remote-alias>hum</remote-alias>
  88. <ordinal>1</ordinal>
  89. <local-type>real</local-type>
  90. <aggregation>Sum</aggregation>
  91. <contains-null>true</contains-null>
  92. <_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[m3_0103.csv_DFECFB17718A4819B318F673AF8CFAEC]</_.fcp.ObjectModelEncapsulateLegacy.true...object-id>
  93. </metadata-record>
  94. <metadata-record class='column'>
  95. <remote-name>temp</remote-name>
  96. <remote-type>5</remote-type>
  97. <local-name>[temp]</local-name>
  98. <parent-name>[m3_0103.csv]</parent-name>
  99. <remote-alias>temp</remote-alias>
  100. <ordinal>2</ordinal>
  101. <local-type>real</local-type>
  102. <aggregation>Sum</aggregation>
  103. <contains-null>true</contains-null>
  104. <_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[m3_0103.csv_DFECFB17718A4819B318F673AF8CFAEC]</_.fcp.ObjectModelEncapsulateLegacy.true...object-id>
  105. </metadata-record>
  106. <metadata-record class='column'>
  107. <remote-name>door</remote-name>
  108. <remote-type>5</remote-type>
  109. <local-name>[door]</local-name>
  110. <parent-name>[m3_0103.csv]</parent-name>
  111. <remote-alias>door</remote-alias>
  112. <ordinal>3</ordinal>
  113. <local-type>real</local-type>
  114. <aggregation>Sum</aggregation>
  115. <contains-null>true</contains-null>
  116. <_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[m3_0103.csv_DFECFB17718A4819B318F673AF8CFAEC]</_.fcp.ObjectModelEncapsulateLegacy.true...object-id>
  117. </metadata-record>
  118. <metadata-record class='column'>
  119. <remote-name>motion</remote-name>
  120. <remote-type>5</remote-type>
  121. <local-name>[motion]</local-name>
  122. <parent-name>[m3_0103.csv]</parent-name>
  123. <remote-alias>motion</remote-alias>
  124. <ordinal>4</ordinal>
  125. <local-type>real</local-type>
  126. <aggregation>Sum</aggregation>
  127. <contains-null>true</contains-null>
  128. <_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[m3_0103.csv_DFECFB17718A4819B318F673AF8CFAEC]</_.fcp.ObjectModelEncapsulateLegacy.true...object-id>
  129. </metadata-record>
  130. <metadata-record class='column'>
  131. <remote-name>illum</remote-name>
  132. <remote-type>5</remote-type>
  133. <local-name>[illum]</local-name>
  134. <parent-name>[m3_0103.csv]</parent-name>
  135. <remote-alias>illum</remote-alias>
  136. <ordinal>5</ordinal>
  137. <local-type>real</local-type>
  138. <aggregation>Sum</aggregation>
  139. <contains-null>true</contains-null>
  140. <_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[m3_0103.csv_DFECFB17718A4819B318F673AF8CFAEC]</_.fcp.ObjectModelEncapsulateLegacy.true...object-id>
  141. </metadata-record>
  142. </metadata-records>
  143. </connection>
  144. <aliases enabled='yes' />
  145. <_.fcp.ObjectModelTableType.true...column caption='m3_0103.csv' datatype='table' name='[__tableau_internal_object_id__].[m3_0103.csv_DFECFB17718A4819B318F673AF8CFAEC]' role='measure' type='quantitative' />
  146. <column caption='Door' datatype='real' name='[door]' role='measure' type='quantitative' />
  147. <column caption='Hum' datatype='real' name='[hum]' role='measure' type='quantitative' />
  148. <column caption='Illum' datatype='real' name='[illum]' role='measure' type='quantitative' />
  149. <column caption='Motion' datatype='real' name='[motion]' role='measure' type='quantitative' />
  150. <column caption='Temp' datatype='real' name='[temp]' role='measure' type='quantitative' />
  151. <column caption='Timestamp' datatype='datetime' name='[timestamp]' role='dimension' type='ordinal' />
  152. <column-instance column='[timestamp]' derivation='Day' name='[dy:timestamp:ok]' pivot='key' type='ordinal' />
  153. <column-instance column='[timestamp]' derivation='Hour' name='[hr:timestamp:ok]' pivot='key' type='ordinal' />
  154. <column-instance column='[timestamp]' derivation='Month' name='[mn:timestamp:ok]' pivot='key' type='ordinal' />
  155. <column-instance column='[timestamp]' derivation='Quarter' name='[qr:timestamp:ok]' pivot='key' type='ordinal' />
  156. <column-instance column='[timestamp]' derivation='Year' name='[yr:timestamp:ok]' pivot='key' type='ordinal' />
  157. <group hidden='true' name='[포함(년(Timestamp),분기(Timestamp),시간(Timestamp),월(Timestamp),일(Timestamp))]' name-style='unqualified' user:auto-column='include'>
  158. <groupfilter function='crossjoin'>
  159. <groupfilter function='level-members' level='[yr:timestamp:ok]' />
  160. <groupfilter function='level-members' level='[qr:timestamp:ok]' />
  161. <groupfilter function='level-members' level='[hr:timestamp:ok]' />
  162. <groupfilter function='level-members' level='[mn:timestamp:ok]' />
  163. <groupfilter function='level-members' level='[dy:timestamp:ok]' />
  164. </groupfilter>
  165. </group>
  166. <layout _.fcp.SchemaViewerObjectModel.false...dim-percentage='0.5' _.fcp.SchemaViewerObjectModel.false...measure-percentage='0.4' dim-ordering='alphabetic' measure-ordering='alphabetic' show-structure='true' />
  167. <semantic-values>
  168. <semantic-value key='[Country].[Name]' value='&quot;대한민국&quot;' />
  169. </semantic-values>
  170. <_.fcp.ObjectModelEncapsulateLegacy.true...object-graph>
  171. <objects>
  172. <object caption='m3_0103.csv' id='m3_0103.csv_DFECFB17718A4819B318F673AF8CFAEC'>
  173. <properties context=''>
  174. <relation connection='textscan.0erpzzc0a7kcbg12etxg11nmdoos' name='m3_0103.csv' table='[m3_0103#csv]' type='table'>
  175. <columns character-set='UTF-8' header='yes' locale='ko_KR' separator=','>
  176. <column datatype='datetime' name='timestamp' ordinal='0' />
  177. <column datatype='real' name='hum' ordinal='1' />
  178. <column datatype='real' name='temp' ordinal='2' />
  179. <column datatype='real' name='door' ordinal='3' />
  180. <column datatype='real' name='motion' ordinal='4' />
  181. <column datatype='real' name='illum' ordinal='5' />
  182. </columns>
  183. </relation>
  184. </properties>
  185. </object>
  186. </objects>
  187. </_.fcp.ObjectModelEncapsulateLegacy.true...object-graph>
  188. </datasource>
  189. </datasources>
  190. <worksheets>
  191. <worksheet name='시트 1'>
  192. <table>
  193. <view>
  194. <datasources>
  195. <datasource caption='m3_0103' name='federated.1en4l9j0z5yqpt1fw8raf1kz99ys' />
  196. </datasources>
  197. <datasource-dependencies datasource='federated.1en4l9j0z5yqpt1fw8raf1kz99ys'>
  198. <column-instance column='[hum]' derivation='Avg' name='[avg:hum:qk]' pivot='key' type='quantitative' />
  199. <column-instance column='[illum]' derivation='Avg' name='[avg:illum:qk]' pivot='key' type='quantitative' />
  200. <column-instance column='[temp]' derivation='Avg' name='[avg:temp:qk]' pivot='key' type='quantitative' />
  201. <column caption='Door' datatype='real' name='[door]' role='measure' type='quantitative' />
  202. <column-instance column='[timestamp]' derivation='Day' name='[dy:timestamp:ok]' pivot='key' type='ordinal' />
  203. <column-instance column='[timestamp]' derivation='Hour' name='[hr:timestamp:ok]' pivot='key' type='ordinal' />
  204. <column caption='Hum' datatype='real' name='[hum]' role='measure' type='quantitative' />
  205. <column caption='Illum' datatype='real' name='[illum]' role='measure' type='quantitative' />
  206. <column-instance column='[timestamp]' derivation='Month' name='[mn:timestamp:ok]' pivot='key' type='ordinal' />
  207. <column caption='Motion' datatype='real' name='[motion]' role='measure' type='quantitative' />
  208. <column-instance column='[timestamp]' derivation='Quarter' name='[qr:timestamp:ok]' pivot='key' type='ordinal' />
  209. <column-instance column='[door]' derivation='Sum' name='[sum:door:qk]' pivot='key' type='quantitative' />
  210. <column-instance column='[motion]' derivation='Sum' name='[sum:motion:qk]' pivot='key' type='quantitative' />
  211. <column caption='Temp' datatype='real' name='[temp]' role='measure' type='quantitative' />
  212. <column caption='Timestamp' datatype='datetime' name='[timestamp]' role='dimension' type='ordinal' />
  213. <column-instance column='[timestamp]' derivation='Year' name='[yr:timestamp:ok]' pivot='key' type='ordinal' />
  214. </datasource-dependencies>
  215. <filter class='quantitative' column='[federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[sum:motion:qk]' included-values='non-null' />
  216. <slices>
  217. <column>[federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[sum:motion:qk]</column>
  218. </slices>
  219. <aggregation value='true' />
  220. </view>
  221. <style />
  222. <panes>
  223. <pane selection-relaxation-option='selection-relaxation-allow'>
  224. <view>
  225. <breakdown value='auto' />
  226. </view>
  227. <mark class='Automatic' />
  228. </pane>
  229. <pane id='2' selection-relaxation-option='selection-relaxation-allow' y-axis-name='[federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[avg:hum:qk]'>
  230. <view>
  231. <breakdown value='auto' />
  232. </view>
  233. <mark class='Automatic' />
  234. </pane>
  235. <pane id='3' selection-relaxation-option='selection-relaxation-allow' y-axis-name='[federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[avg:illum:qk]'>
  236. <view>
  237. <breakdown value='auto' />
  238. </view>
  239. <mark class='Automatic' />
  240. </pane>
  241. <pane id='5' selection-relaxation-option='selection-relaxation-allow' y-axis-name='[federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[avg:temp:qk]'>
  242. <view>
  243. <breakdown value='auto' />
  244. </view>
  245. <mark class='Automatic' />
  246. </pane>
  247. <pane id='6' selection-relaxation-option='selection-relaxation-allow' y-axis-name='[federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[sum:motion:qk]'>
  248. <view>
  249. <breakdown value='auto' />
  250. </view>
  251. <mark class='Automatic' />
  252. </pane>
  253. <pane id='7' selection-relaxation-option='selection-relaxation-allow' y-axis-name='[federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[sum:door:qk]'>
  254. <view>
  255. <breakdown value='auto' />
  256. </view>
  257. <mark class='Automatic' />
  258. </pane>
  259. </panes>
  260. <rows>([federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[avg:hum:qk] + ([federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[avg:temp:qk] + ([federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[avg:illum:qk] + ([federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[sum:motion:qk] + [federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[sum:door:qk]))))</rows>
  261. <cols>([federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[yr:timestamp:ok] / ([federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[qr:timestamp:ok] / ([federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[mn:timestamp:ok] / ([federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[dy:timestamp:ok] / [federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[hr:timestamp:ok]))))</cols>
  262. </table>
  263. <simple-id uuid='{4A90872E-4A88-4F75-9E6E-8E5EE1648389}' />
  264. </worksheet>
  265. </worksheets>
  266. <windows source-height='30'>
  267. <window class='worksheet' maximized='true' name='시트 1'>
  268. <cards>
  269. <edge name='left'>
  270. <strip size='160'>
  271. <card type='pages' />
  272. <card type='filters' />
  273. <card type='marks' />
  274. </strip>
  275. </edge>
  276. <edge name='top'>
  277. <strip size='2147483647'>
  278. <card type='columns' />
  279. </strip>
  280. <strip size='2147483647'>
  281. <card type='rows' />
  282. </strip>
  283. <strip size='31'>
  284. <card type='title' />
  285. </strip>
  286. </edge>
  287. </cards>
  288. <viewpoint>
  289. <zoom type='entire-view' />
  290. </viewpoint>
  291. <simple-id uuid='{BA70B236-50BE-4AAE-950A-8FDD2344AD27}' />
  292. </window>
  293. </windows>
  294. </workbook>