~mr__55860.twbr 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278
  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='mr_0104' inline='true' name='federated.1x98umr1jje5vr1bnte480mwzzo2' version='18.1'>
  24. <connection class='federated'>
  25. <named-connections>
  26. <named-connection caption='mr_0104' name='textscan.1rram1907ms0b41awvwvb149gd6t'>
  27. <connection class='textscan' directory='C:/Users/User/Desktop/ssd-work/homeiot/preproc' filename='mr_0104.csv' password='' server='' />
  28. </named-connection>
  29. </named-connections>
  30. <_.fcp.ObjectModelEncapsulateLegacy.false...relation connection='textscan.1rram1907ms0b41awvwvb149gd6t' name='mr_0104.csv' table='[mr_0104#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.1rram1907ms0b41awvwvb149gd6t' name='mr_0104.csv' table='[mr_0104#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>[mr_0104.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>[mr_0104.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. </metadata-record>
  81. <metadata-record class='column'>
  82. <remote-name>hum</remote-name>
  83. <remote-type>5</remote-type>
  84. <local-name>[hum]</local-name>
  85. <parent-name>[mr_0104.csv]</parent-name>
  86. <remote-alias>hum</remote-alias>
  87. <ordinal>1</ordinal>
  88. <local-type>real</local-type>
  89. <aggregation>Sum</aggregation>
  90. <contains-null>true</contains-null>
  91. </metadata-record>
  92. <metadata-record class='column'>
  93. <remote-name>temp</remote-name>
  94. <remote-type>5</remote-type>
  95. <local-name>[temp]</local-name>
  96. <parent-name>[mr_0104.csv]</parent-name>
  97. <remote-alias>temp</remote-alias>
  98. <ordinal>2</ordinal>
  99. <local-type>real</local-type>
  100. <aggregation>Sum</aggregation>
  101. <contains-null>true</contains-null>
  102. </metadata-record>
  103. <metadata-record class='column'>
  104. <remote-name>door</remote-name>
  105. <remote-type>5</remote-type>
  106. <local-name>[door]</local-name>
  107. <parent-name>[mr_0104.csv]</parent-name>
  108. <remote-alias>door</remote-alias>
  109. <ordinal>3</ordinal>
  110. <local-type>real</local-type>
  111. <aggregation>Sum</aggregation>
  112. <approx-count>1</approx-count>
  113. <contains-null>true</contains-null>
  114. </metadata-record>
  115. <metadata-record class='column'>
  116. <remote-name>motion</remote-name>
  117. <remote-type>5</remote-type>
  118. <local-name>[motion]</local-name>
  119. <parent-name>[mr_0104.csv]</parent-name>
  120. <remote-alias>motion</remote-alias>
  121. <ordinal>4</ordinal>
  122. <local-type>real</local-type>
  123. <aggregation>Sum</aggregation>
  124. <approx-count>1</approx-count>
  125. <contains-null>true</contains-null>
  126. </metadata-record>
  127. <metadata-record class='column'>
  128. <remote-name>illum</remote-name>
  129. <remote-type>5</remote-type>
  130. <local-name>[illum]</local-name>
  131. <parent-name>[mr_0104.csv]</parent-name>
  132. <remote-alias>illum</remote-alias>
  133. <ordinal>5</ordinal>
  134. <local-type>real</local-type>
  135. <aggregation>Sum</aggregation>
  136. <approx-count>1</approx-count>
  137. <contains-null>true</contains-null>
  138. </metadata-record>
  139. </metadata-records>
  140. </connection>
  141. <aliases enabled='yes' />
  142. <_.fcp.ObjectModelTableType.true...column caption='mr_0104.csv' datatype='table' name='[__tableau_internal_object_id__].[mr_0104.csv_DED8B6AA8EA34FF18F1FEDB79A546E0A]' role='measure' type='quantitative' />
  143. <column caption='Door' datatype='real' name='[door]' role='measure' type='quantitative' />
  144. <column caption='Hum' datatype='real' name='[hum]' role='measure' type='quantitative' />
  145. <column caption='Illum' datatype='real' name='[illum]' role='measure' type='quantitative' />
  146. <column caption='Motion' datatype='real' name='[motion]' role='measure' type='quantitative' />
  147. <column caption='Temp' datatype='real' name='[temp]' role='measure' type='quantitative' />
  148. <column caption='Timestamp' datatype='datetime' name='[timestamp]' role='dimension' type='ordinal' />
  149. <layout _.fcp.SchemaViewerObjectModel.false...dim-percentage='0.5' _.fcp.SchemaViewerObjectModel.false...measure-percentage='0.4' dim-ordering='alphabetic' measure-ordering='alphabetic' show-structure='true' />
  150. <semantic-values>
  151. <semantic-value key='[Country].[Name]' value='&quot;대한민국&quot;' />
  152. </semantic-values>
  153. <_.fcp.ObjectModelEncapsulateLegacy.true...object-graph>
  154. <objects>
  155. <object caption='mr_0104.csv' id='mr_0104.csv_DED8B6AA8EA34FF18F1FEDB79A546E0A'>
  156. <properties context=''>
  157. <relation connection='textscan.1rram1907ms0b41awvwvb149gd6t' name='mr_0104.csv' table='[mr_0104#csv]' type='table'>
  158. <columns character-set='UTF-8' header='yes' locale='ko_KR' separator=','>
  159. <column datatype='datetime' name='timestamp' ordinal='0' />
  160. <column datatype='real' name='hum' ordinal='1' />
  161. <column datatype='real' name='temp' ordinal='2' />
  162. <column datatype='real' name='door' ordinal='3' />
  163. <column datatype='real' name='motion' ordinal='4' />
  164. <column datatype='real' name='illum' ordinal='5' />
  165. </columns>
  166. </relation>
  167. </properties>
  168. </object>
  169. </objects>
  170. </_.fcp.ObjectModelEncapsulateLegacy.true...object-graph>
  171. </datasource>
  172. </datasources>
  173. <worksheets>
  174. <worksheet name='시트 1'>
  175. <table>
  176. <view>
  177. <datasources>
  178. <datasource caption='mr_0104' name='federated.1x98umr1jje5vr1bnte480mwzzo2' />
  179. </datasources>
  180. <datasource-dependencies datasource='federated.1x98umr1jje5vr1bnte480mwzzo2'>
  181. <column-instance column='[hum]' derivation='Avg' name='[avg:hum:qk]' pivot='key' type='quantitative' />
  182. <column-instance column='[illum]' derivation='Avg' name='[avg:illum:qk]' pivot='key' type='quantitative' />
  183. <column-instance column='[temp]' derivation='Avg' name='[avg:temp:qk]' pivot='key' type='quantitative' />
  184. <column caption='Door' datatype='real' name='[door]' role='measure' type='quantitative' />
  185. <column-instance column='[timestamp]' derivation='Day' name='[dy:timestamp:ok]' pivot='key' type='ordinal' />
  186. <column-instance column='[timestamp]' derivation='Hour' name='[hr:timestamp:ok]' pivot='key' type='ordinal' />
  187. <column caption='Hum' datatype='real' name='[hum]' role='measure' type='quantitative' />
  188. <column caption='Illum' datatype='real' name='[illum]' role='measure' type='quantitative' />
  189. <column-instance column='[timestamp]' derivation='Month' name='[mn:timestamp:ok]' pivot='key' type='ordinal' />
  190. <column caption='Motion' datatype='real' name='[motion]' role='measure' type='quantitative' />
  191. <column-instance column='[timestamp]' derivation='Quarter' name='[qr:timestamp:ok]' pivot='key' type='ordinal' />
  192. <column-instance column='[door]' derivation='Sum' name='[sum:door:qk]' pivot='key' type='quantitative' />
  193. <column-instance column='[motion]' derivation='Sum' name='[sum:motion:qk]' pivot='key' type='quantitative' />
  194. <column caption='Temp' datatype='real' name='[temp]' role='measure' type='quantitative' />
  195. <column caption='Timestamp' datatype='datetime' name='[timestamp]' role='dimension' type='ordinal' />
  196. <column-instance column='[timestamp]' derivation='Year' name='[yr:timestamp:ok]' pivot='key' type='ordinal' />
  197. </datasource-dependencies>
  198. <filter class='quantitative' column='[federated.1x98umr1jje5vr1bnte480mwzzo2].[sum:motion:qk]' included-values='non-null' />
  199. <slices>
  200. <column>[federated.1x98umr1jje5vr1bnte480mwzzo2].[sum:motion:qk]</column>
  201. </slices>
  202. <aggregation value='true' />
  203. </view>
  204. <style />
  205. <panes>
  206. <pane id='5' selection-relaxation-option='selection-relaxation-allow'>
  207. <view>
  208. <breakdown value='auto' />
  209. </view>
  210. <mark class='Automatic' />
  211. </pane>
  212. <pane id='6' selection-relaxation-option='selection-relaxation-allow' y-axis-name='[federated.1x98umr1jje5vr1bnte480mwzzo2].[avg:temp:qk]'>
  213. <view>
  214. <breakdown value='auto' />
  215. </view>
  216. <mark class='Automatic' />
  217. </pane>
  218. <pane id='7' selection-relaxation-option='selection-relaxation-allow' y-axis-name='[federated.1x98umr1jje5vr1bnte480mwzzo2].[sum:door:qk]'>
  219. <view>
  220. <breakdown value='auto' />
  221. </view>
  222. <mark class='Automatic' />
  223. </pane>
  224. <pane id='8' selection-relaxation-option='selection-relaxation-allow' y-axis-name='[federated.1x98umr1jje5vr1bnte480mwzzo2].[avg:hum:qk]'>
  225. <view>
  226. <breakdown value='auto' />
  227. </view>
  228. <mark class='Automatic' />
  229. </pane>
  230. <pane id='9' selection-relaxation-option='selection-relaxation-allow' y-axis-name='[federated.1x98umr1jje5vr1bnte480mwzzo2].[avg:illum:qk]'>
  231. <view>
  232. <breakdown value='auto' />
  233. </view>
  234. <mark class='Automatic' />
  235. </pane>
  236. <pane id='10' selection-relaxation-option='selection-relaxation-allow' y-axis-name='[federated.1x98umr1jje5vr1bnte480mwzzo2].[sum:motion:qk]'>
  237. <view>
  238. <breakdown value='auto' />
  239. </view>
  240. <mark class='Automatic' />
  241. </pane>
  242. </panes>
  243. <rows>([federated.1x98umr1jje5vr1bnte480mwzzo2].[avg:hum:qk] + ([federated.1x98umr1jje5vr1bnte480mwzzo2].[avg:temp:qk] + ([federated.1x98umr1jje5vr1bnte480mwzzo2].[avg:illum:qk] + ([federated.1x98umr1jje5vr1bnte480mwzzo2].[sum:door:qk] + [federated.1x98umr1jje5vr1bnte480mwzzo2].[sum:motion:qk]))))</rows>
  244. <cols>([federated.1x98umr1jje5vr1bnte480mwzzo2].[yr:timestamp:ok] / ([federated.1x98umr1jje5vr1bnte480mwzzo2].[qr:timestamp:ok] / ([federated.1x98umr1jje5vr1bnte480mwzzo2].[mn:timestamp:ok] / ([federated.1x98umr1jje5vr1bnte480mwzzo2].[dy:timestamp:ok] / [federated.1x98umr1jje5vr1bnte480mwzzo2].[hr:timestamp:ok]))))</cols>
  245. </table>
  246. <simple-id uuid='{8CDE6A9A-C9C7-4329-BF14-FC12000FAFB8}' />
  247. </worksheet>
  248. </worksheets>
  249. <windows source-height='30'>
  250. <window class='worksheet' maximized='true' name='시트 1'>
  251. <cards>
  252. <edge name='left'>
  253. <strip size='160'>
  254. <card type='pages' />
  255. <card type='filters' />
  256. <card type='marks' />
  257. </strip>
  258. </edge>
  259. <edge name='top'>
  260. <strip size='2147483647'>
  261. <card type='columns' />
  262. </strip>
  263. <strip size='2147483647'>
  264. <card type='rows' />
  265. </strip>
  266. <strip size='31'>
  267. <card type='title' />
  268. </strip>
  269. </edge>
  270. </cards>
  271. <viewpoint>
  272. <zoom type='entire-view' />
  273. </viewpoint>
  274. <simple-id uuid='{EDDD92D6-E154-4D7C-9FF8-6079B9220B8C}' />
  275. </window>
  276. </windows>
  277. </workbook>