From 0bc5ee2715578626ccd5c28e0246394917d55aea Mon Sep 17 00:00:00 2001 From: Randy Morgan Date: Tue, 3 Jul 2012 20:41:56 +0900 Subject: more work on snake case standardization --- lib/axlsx/drawing/bar_3D_chart.rb | 82 +- lib/axlsx/drawing/chart.rb | 10 +- lib/axlsx/drawing/pie_3D_chart.rb | 14 +- lib/axlsx/drawing/view_3D.rb | 72 +- unzip_excel/[Content_Types].xml | 2 + unzip_excel/_rels/.rels | 2 + unzip_excel/docProps/app.xml | 2 + unzip_excel/docProps/core.xml | 2 + unzip_excel/docProps/core0.xml | 1 + unzip_excel/xl/_rels/workbook.xml.rels | 2 + unzip_excel/xl/calcChain.xml | 2 + unzip_excel/xl/charts/chart1.xml | 1189 +++++++++++++++++++++++ unzip_excel/xl/charts/chart2.xml | 2 + unzip_excel/xl/drawings/_rels/drawing1.xml.rels | 2 + unzip_excel/xl/drawings/_rels/drawing2.xml.rels | 2 + unzip_excel/xl/drawings/drawing1.xml | 33 + unzip_excel/xl/drawings/drawing2.xml | 33 + unzip_excel/xl/sharedStrings.xml | 2 + unzip_excel/xl/styles.xml | 2 + unzip_excel/xl/theme/theme1.xml | 2 + unzip_excel/xl/workbook.xml | 2 + unzip_excel/xl/worksheets/_rels/sheet2.xml.rels | 2 + unzip_excel/xl/worksheets/_rels/sheet3.xml.rels | 2 + unzip_excel/xl/worksheets/sheet1.xml | 2 + unzip_excel/xl/worksheets/sheet2.xml | 2 + unzip_excel/xl/worksheets/sheet3.xml | 2 + unzip_excel/xl/worksheets/sheet4.xml | 2 + 27 files changed, 1393 insertions(+), 79 deletions(-) create mode 100644 unzip_excel/[Content_Types].xml create mode 100644 unzip_excel/_rels/.rels create mode 100644 unzip_excel/docProps/app.xml create mode 100644 unzip_excel/docProps/core.xml create mode 100644 unzip_excel/docProps/core0.xml create mode 100644 unzip_excel/xl/_rels/workbook.xml.rels create mode 100644 unzip_excel/xl/calcChain.xml create mode 100644 unzip_excel/xl/charts/chart1.xml create mode 100644 unzip_excel/xl/charts/chart2.xml create mode 100644 unzip_excel/xl/drawings/_rels/drawing1.xml.rels create mode 100644 unzip_excel/xl/drawings/_rels/drawing2.xml.rels create mode 100644 unzip_excel/xl/drawings/drawing1.xml create mode 100644 unzip_excel/xl/drawings/drawing2.xml create mode 100644 unzip_excel/xl/sharedStrings.xml create mode 100644 unzip_excel/xl/styles.xml create mode 100644 unzip_excel/xl/theme/theme1.xml create mode 100644 unzip_excel/xl/workbook.xml create mode 100644 unzip_excel/xl/worksheets/_rels/sheet2.xml.rels create mode 100644 unzip_excel/xl/worksheets/_rels/sheet3.xml.rels create mode 100644 unzip_excel/xl/worksheets/sheet1.xml create mode 100644 unzip_excel/xl/worksheets/sheet2.xml create mode 100644 unzip_excel/xl/worksheets/sheet3.xml create mode 100644 unzip_excel/xl/worksheets/sheet4.xml diff --git a/lib/axlsx/drawing/bar_3D_chart.rb b/lib/axlsx/drawing/bar_3D_chart.rb index abed702b..7f9165da 100644 --- a/lib/axlsx/drawing/bar_3D_chart.rb +++ b/lib/axlsx/drawing/bar_3D_chart.rb @@ -10,24 +10,29 @@ module Axlsx # the category axis # @return [CatAxis] - attr_reader :catAxis + attr_reader :cat_axis + alias :catAxis :cat_axis - # the valueaxis + # the value axis # @return [ValAxis] - attr_reader :valAxis + attr_reader :val_axis + alias :valAxis :val_axis # The direction of the bars in the chart # must be one of [:bar, :col] # @return [Symbol] - attr_reader :barDir + attr_reader :bar_dir + alias :barDir :bar_dir # space between bar or column clusters, as a percentage of the bar or column width. # @return [String] - attr_reader :gapDepth + attr_reader :gap_depth + alias :gapDepth :gap_depth # space between bar or column clusters, as a percentage of the bar or column width. # @return [String] - attr_reader :gapWidth + attr_reader :gap_width + alias :gapWidth :gap_width #grouping for a column, line, or area chart. # must be one of [:percentStacked, :clustered, :standard, :stacked] @@ -46,38 +51,39 @@ module Axlsx # @param [GraphicFrame] frame The workbook that owns this chart. # @option options [Cell, String] title # @option options [Boolean] show_legend - # @option options [Symbol] barDir + # @option options [Symbol] bar_dir # @option options [Symbol] grouping - # @option options [String] gapWidth - # @option options [String] gapDepth + # @option options [String] gap_width + # @option options [String] gap_depth # @option options [Symbol] shape - # @option options [Integer] rotX - # @option options [String] hPercent - # @option options [Integer] rotY - # @option options [String] depthPercent - # @option options [Boolean] rAngAx + # @option options [Integer] rot_x + # @option options [String] h_percent + # @option options [Integer] rot_y + # @option options [String] depth_percent + # @option options [Boolean] r_ang_ax # @option options [Integer] perspective # @see Chart # @see View3D def initialize(frame, options={}) - @barDir = :bar + @bar_dir = :bar @grouping = :clustered - @gapWidth, @gapDepth, @shape = nil, nil, nil - @catAxId = rand(8 ** 8) - @valAxId = rand(8 ** 8) - @catAxis = CatAxis.new(@catAxId, @valAxId) - @valAxis = ValAxis.new(@valAxId, @catAxId, :tickLblPos => :low) + @gap_width, @gap_depth, @shape = nil, nil, nil + @cat_ax_id = rand(8 ** 8) + @val_ax_id = rand(8 ** 8) + @cat_axis = CatAxis.new(@cat_ax_id, @val_ax_id) + @val_axis = ValAxis.new(@val_ax_id, @cat_ax_id, :tick_lbl_pos => :low) super(frame, options) @series_type = BarSeries - @view3D = View3D.new({:rAngAx=>1}.merge(options)) + @view_3D = View3D.new({:r_ang_ax=>1}.merge(options)) end # The direction of the bars in the chart # must be one of [:bar, :col] - def barDir=(v) - RestrictionValidator.validate "Bar3DChart.barDir", [:bar, :col], v - @barDir = v + def bar_dir=(v) + RestrictionValidator.validate "Bar3DChart.bar_dir", [:bar, :col], v + @bar_dir = v end + alias :barDir= :bar_dir= #grouping for a column, line, or area chart. # must be one of [:percentStacked, :clustered, :standard, :stacked] @@ -87,16 +93,18 @@ module Axlsx end # space between bar or column clusters, as a percentage of the bar or column width. - def gapWidth=(v) - RegexValidator.validate "Bar3DChart.gapWidth", GAP_AMOUNT_PERCENT, v - @gapWidth=(v) + def gap_width=(v) + RegexValidator.validate "Bar3DChart.gap_width", GAP_AMOUNT_PERCENT, v + @gap_width=(v) end + alias :gapWidth= :gap_width= # space between bar or column clusters, as a percentage of the bar or column width. - def gapDepth=(v) - RegexValidator.validate "Bar3DChart.gapWidth", GAP_AMOUNT_PERCENT, v - @gapDepth=(v) + def gap_depth=(v) + RegexValidator.validate "Bar3DChart.gap_didth", GAP_AMOUNT_PERCENT, v + @gap_depth=(v) end + alias :gapDepth= :gap_depth= # The shabe of the bars or columns # must be one of [:cone, :coneToMax, :box, :cylinder, :pyramid, :pyramidToMax] @@ -111,7 +119,7 @@ module Axlsx def to_xml_string(str = '') super(str) do |str_inner| str_inner << '' - str_inner << '' + str_inner << '' str_inner << '' str_inner << '' @series.each { |ser| ser.to_xml_string(str_inner) } @@ -123,15 +131,15 @@ module Axlsx str_inner << '' str_inner << '' str_inner << '' - str_inner << '' unless @gapWidth.nil? - str_inner << '' unless @gapDepth.nil? + str_inner << '' unless @gap_width.nil? + str_inner << '' unless @gap_depth.nil? str_inner << '' unless @shape.nil? - str_inner << '' - str_inner << '' + str_inner << '' + str_inner << '' str_inner << '' str_inner << '' - @catAxis.to_xml_string str_inner - @valAxis.to_xml_string str_inner + @cat_axis.to_xml_string str_inner + @val_axis.to_xml_string str_inner end end end diff --git a/lib/axlsx/drawing/chart.rb b/lib/axlsx/drawing/chart.rb index f0f0185b..1be4cf11 100644 --- a/lib/axlsx/drawing/chart.rb +++ b/lib/axlsx/drawing/chart.rb @@ -7,7 +7,8 @@ module Axlsx # The 3D view properties for the chart - attr_reader :view3D + attr_reader :view_3D + alias :view3D :view_3D # A reference to the graphic frame that owns this chart # @return [GraphicFrame] @@ -45,7 +46,7 @@ module Axlsx # @option options [Array|String|Cell] end_at The X, Y coordinates defining the bottom right corner of the chart. def initialize(frame, options={}) @style = 18 - @view3D = nil + @view_3D = nil @graphic_frame=frame @graphic_frame.anchor.drawing.worksheet.workbook.charts << self @series = SimpleTypedList.new Series @@ -127,7 +128,7 @@ module Axlsx @title.to_xml_string str # do these need the c: namespace as well??? str << '' - @view3D.to_xml_string(str) if @view3D + @view_3D.to_xml_string(str) if @view_3D str << '' str << '' str << '' @@ -188,7 +189,8 @@ module Axlsx [x, y] end - def view3D=(v) DataTypeValidator.validate "#{self.class}.view3D", View3D, v; @view3D = v; end + def view_3D=(v) DataTypeValidator.validate "#{self.class}.view_3D", View3D, v; @view_3D = v; end + alias :view3D= :view_3D= end end diff --git a/lib/axlsx/drawing/pie_3D_chart.rb b/lib/axlsx/drawing/pie_3D_chart.rb index fea89d0e..d6928e6f 100644 --- a/lib/axlsx/drawing/pie_3D_chart.rb +++ b/lib/axlsx/drawing/pie_3D_chart.rb @@ -13,19 +13,19 @@ module Axlsx # @option options [Cell, String] title # @option options [Boolean] show_legend # @option options [Symbol] grouping - # @option options [String] gapDepth - # @option options [Integer] rotX - # @option options [String] hPercent - # @option options [Integer] rotY - # @option options [String] depthPercent - # @option options [Boolean] rAngAx + # @option options [String] gap_depth + # @option options [Integer] rot_x + # @option options [String] h_percent + # @option options [Integer] rot_y + # @option options [String] depth_percent + # @option options [Boolean] r_ang_ax # @option options [Integer] perspective # @see Chart # @see View3D def initialize(frame, options={}) super(frame, options) @series_type = PieSeries - @view3D = View3D.new({:rotX=>30, :perspective=>30}.merge(options)) + @view_3D = View3D.new({:rotX =>30, :perspective=>30}.merge(options)) end # Serializes the object diff --git a/lib/axlsx/drawing/view_3D.rb b/lib/axlsx/drawing/view_3D.rb index 07586b5f..241fcd3b 100644 --- a/lib/axlsx/drawing/view_3D.rb +++ b/lib/axlsx/drawing/view_3D.rb @@ -12,63 +12,73 @@ module Axlsx # x rotation for the chart # must be between -90 and 90 # @return [Integer] - attr_reader :rotX - + attr_reader :rot_x + alias :rotX :rot_x + # height of chart as % of chart # must be between 5% and 500% # @return [String] - attr_reader :hPercent + attr_reader :h_percent + alias :hPercent :h_percent # y rotation for the chart # must be between 0 and 360 # @return [Integer] - attr_reader :rotY - + attr_reader :rot_y + alias :rotY :rot_y + # depth or chart as % of chart width # must be between 20% and 2000% # @return [String] - attr_reader :depthPercent + attr_reader :depth_percent + alias :depthPercent :depth_percent # Chart axis are at right angles # @return [Boolean] - attr_reader :rAngAx + attr_reader :r_ang_ax + alias :rAngAx :r_ang_ax # field of view angle # @return [Integer] attr_reader :perspective # Creates a new View3D for charts - # @option options [Integer] rotX - # @option options [String] hPercent - # @option options [Integer] rotY - # @option options [String] depthPercent - # @option options [Boolean] rAngAx + # @option options [Integer] rot_x + # @option options [String] h_percent + # @option options [Integer] rot_y + # @option options [String] depth_percent + # @option options [Boolean] r_ang_ax # @option options [Integer] perspective def initialize(options={}) - @rotX, @hPercent, @rotY, @depthPercent, @rAngAx, @perspective = nil, nil, nil, nil, nil, nil + @rot_x, @h_percent, @rot_y, @depth_percent, @r_ang_ax, @perspective = nil, nil, nil, nil, nil, nil options.each do |o| self.send("#{o[0]}=", o[1]) if self.respond_to? "#{o[0]}=" end end - # @see rotX - def rotX=(v) DataTypeValidator.validate "#{self.class}.rotX", [Integer, Fixnum], v, lambda {|arg| arg >= -90 && arg <= 90 }; @rotX = v; end + # @see rot_x + def rot_x=(v) DataTypeValidator.validate "#{self.class}.rot_x", [Integer, Fixnum], v, lambda {|arg| arg >= -90 && arg <= 90 }; @rot_x = v; end + alias :rotX= :rot_x= - # @see hPercent - def hPercent=(v) - RegexValidator.validate "#{self.class}.hPercent", H_PERCENT_REGEX, v - @hPercent = v + # @see h_percent + def h_percent=(v) + RegexValidator.validate "#{self.class}.h_percent", H_PERCENT_REGEX, v + @h_percent = v end + alias :hPercent= :h_percent= - # @see rotY - def rotY=(v) DataTypeValidator.validate "#{self.class}.rotY", [Integer, Fixnum], v, lambda {|arg| arg >= 0 && arg <= 360 }; @rotY = v; end - - # @see depthPercent - def depthPercent=(v) RegexValidator.validate "#{self.class}.depthPercent", DEPTH_PERCENT_REGEX, v; @depthPercent = v; end + # @see rot_y + def rot_y=(v) DataTypeValidator.validate "#{self.class}.rot_y", [Integer, Fixnum], v, lambda {|arg| arg >= 0 && arg <= 360 }; @rot_y = v; end + alias :rotY= :rot_y= - # @see rAngAx - def rAngAx=(v) Axlsx::validate_boolean(v); @rAngAx = v; end + # @see depth_percent + def depth_percent=(v) RegexValidator.validate "#{self.class}.depth_percent", DEPTH_PERCENT_REGEX, v; @depth_percent = v; end + alias :depthPercent= :depth_percent= + # @see r_ang_ax + def r_ang_ax=(v) Axlsx::validate_boolean(v); @r_ang_ax = v; end + alias :rAngAx= :r_ang_ax= + # @see perspective def perspective=(v) DataTypeValidator.validate "#{self.class}.perspective", [Integer, Fixnum], v, lambda {|arg| arg >= 0 && arg <= 240 }; @perspective = v; end @@ -78,11 +88,11 @@ module Axlsx # @return [String] def to_xml_string(str = '') str << '' - str << '' unless @rotX.nil? - str << '' unless @hPercent.nil? - str << '' unless @rotY.nil? - str << '' unless @depthPercent.nil? - str << '' unless @rAngAx.nil? + str << '' unless @rot_x.nil? + str << '' unless @h_percent.nil? + str << '' unless @rot_y.nil? + str << '' unless @depth_percent.nil? + str << '' unless @r_ang_ax.nil? str << '' unless @perspective.nil? str << '' end diff --git a/unzip_excel/[Content_Types].xml b/unzip_excel/[Content_Types].xml new file mode 100644 index 00000000..dddf69b0 --- /dev/null +++ b/unzip_excel/[Content_Types].xml @@ -0,0 +1,2 @@ + + \ No newline at end of file diff --git a/unzip_excel/_rels/.rels b/unzip_excel/_rels/.rels new file mode 100644 index 00000000..0eb5a3ed --- /dev/null +++ b/unzip_excel/_rels/.rels @@ -0,0 +1,2 @@ + + \ No newline at end of file diff --git a/unzip_excel/docProps/app.xml b/unzip_excel/docProps/app.xml new file mode 100644 index 00000000..660058a0 --- /dev/null +++ b/unzip_excel/docProps/app.xml @@ -0,0 +1,2 @@ + +Microsoft Macintosh Excel0falseArbeitsblätter4DeckblattMeeting-Minuten gesamtMeeting-Minuten pro AccountBestandszahlen pro Accountfalsefalsefalse14.0300 \ No newline at end of file diff --git a/unzip_excel/docProps/core.xml b/unzip_excel/docProps/core.xml new file mode 100644 index 00000000..b062326c --- /dev/null +++ b/unzip_excel/docProps/core.xml @@ -0,0 +1,2 @@ + +Frank Wöckener2012-07-03T04:03:26Z \ No newline at end of file diff --git a/unzip_excel/docProps/core0.xml b/unzip_excel/docProps/core0.xml new file mode 100644 index 00000000..4e0e1a65 --- /dev/null +++ b/unzip_excel/docProps/core0.xml @@ -0,0 +1 @@ +axlsx2012-07-02T16:15:520 diff --git a/unzip_excel/xl/_rels/workbook.xml.rels b/unzip_excel/xl/_rels/workbook.xml.rels new file mode 100644 index 00000000..56a547ee --- /dev/null +++ b/unzip_excel/xl/_rels/workbook.xml.rels @@ -0,0 +1,2 @@ + + \ No newline at end of file diff --git a/unzip_excel/xl/calcChain.xml b/unzip_excel/xl/calcChain.xml new file mode 100644 index 00000000..c1e8aa1e --- /dev/null +++ b/unzip_excel/xl/calcChain.xml @@ -0,0 +1,2 @@ + + \ No newline at end of file diff --git a/unzip_excel/xl/charts/chart1.xml b/unzip_excel/xl/charts/chart1.xml new file mode 100644 index 00000000..52410f96 --- /dev/null +++ b/unzip_excel/xl/charts/chart1.xml @@ -0,0 +1,1189 @@ + + + + + + + + + + + + + + + + Geplante und aktive Meeting-Minuten (gesamt) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + geplant + + + + + 'Meeting-Minuten gesamt'!$B$4:$B$86 + + + + Mon 00 + + + 02 + + + 04 + + + 06 + + + 08 + + + 10 + + + 12 + + + 14 + + + 16 + + + 18 + + + 20 + + + 22 + + + Tue 00 + + + 02 + + + 04 + + + 06 + + + 08 + + + 10 + + + 12 + + + 14 + + + 16 + + + 18 + + + 20 + + + 22 + + + Wed 00 + + + 02 + + + 04 + + + 06 + + + 08 + + + 10 + + + 12 + + + 14 + + + 16 + + + 18 + + + 20 + + + 22 + + + Thu 00 + + + 02 + + + 04 + + + 06 + + + 08 + + + 10 + + + 12 + + + 14 + + + 16 + + + 18 + + + 20 + + + 22 + + + Fri 00 + + + 02 + + + 04 + + + 06 + + + 08 + + + 10 + + + 12 + + + 14 + + + 16 + + + 18 + + + 20 + + + 22 + + + Sat 00 + + + 02 + + + 04 + + + 06 + + + 08 + + + 10 + + + 12 + + + 14 + + + 16 + + + 18 + + + 20 + + + 22 + + + Sun 00 + + + 02 + + + 04 + + + 06 + + + 08 + + + 10 + + + 12 + + + 14 + + + 16 + + + 18 + + + 20 + + + + + + + 'Meeting-Minuten gesamt'!$C$4:$C$86 + + General + + + 0.0 + + + 0.0 + + + 60.0 + + + 0.0 + + + 240.0 + + + 300.0 + + + 90.0 + + + 0.0 + + + 270.0 + + + 60.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 60.0 + + + 0.0 + + + 0.0 + + + 615.0 + + + 630.0 + + + 360.0 + + + 0.0 + + + 0.0 + + + 60.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 15.0 + + + 60.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 300.0 + + + 120.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 120.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 30.0 + + + 0.0 + + + 120.0 + + + 60.0 + + + 150.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 120.0 + + + 120.0 + + + 60.0 + + + 240.0 + + + 30.0 + + + 120.0 + + + 240.0 + + + 30.0 + + + + + + + + + + aktiv + + + + + 'Meeting-Minuten gesamt'!$B$4:$B$86 + + + + Mon 00 + + + 02 + + + 04 + + + 06 + + + 08 + + + 10 + + + 12 + + + 14 + + + 16 + + + 18 + + + 20 + + + 22 + + + Tue 00 + + + 02 + + + 04 + + + 06 + + + 08 + + + 10 + + + 12 + + + 14 + + + 16 + + + 18 + + + 20 + + + 22 + + + Wed 00 + + + 02 + + + 04 + + + 06 + + + 08 + + + 10 + + + 12 + + + 14 + + + 16 + + + 18 + + + 20 + + + 22 + + + Thu 00 + + + 02 + + + 04 + + + 06 + + + 08 + + + 10 + + + 12 + + + 14 + + + 16 + + + 18 + + + 20 + + + 22 + + + Fri 00 + + + 02 + + + 04 + + + 06 + + + 08 + + + 10 + + + 12 + + + 14 + + + 16 + + + 18 + + + 20 + + + 22 + + + Sat 00 + + + 02 + + + 04 + + + 06 + + + 08 + + + 10 + + + 12 + + + 14 + + + 16 + + + 18 + + + 20 + + + 22 + + + Sun 00 + + + 02 + + + 04 + + + 06 + + + 08 + + + 10 + + + 12 + + + 14 + + + 16 + + + 18 + + + 20 + + + + + + + 'Meeting-Minuten gesamt'!$D$4:$D$86 + + General + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 222.0 + + + 38.0 + + + 20.0 + + + 0.0 + + + 114.0 + + + 3.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 76.0 + + + 0.0 + + + 8.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 1.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 20.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 6.0 + + + 0.0 + + + 2.0 + + + 0.0 + + + 50.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 0.0 + + + 3.0 + + + 0.0 + + + 0.0 + + + 224.0 + + + 0.0 + + + 34.0 + + + 0.0 + + + 0.0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/unzip_excel/xl/charts/chart2.xml b/unzip_excel/xl/charts/chart2.xml new file mode 100644 index 00000000..604904b3 --- /dev/null +++ b/unzip_excel/xl/charts/chart2.xml @@ -0,0 +1,2 @@ + +Geplante und aktive Meeting-Minuten (pro Account)geplant'Meeting-Minuten pro Account'!$A$3:$A$10ACME CorpMobiSaveLiveSeinUdo SchorkIT and Media 2012Nolte Home StudioLandesvorstand WJ NRWMichael Gauder'Meeting-Minuten pro Account'!$B$3:$B$10General1230.01500.0930.0450.060.060.060.0510.0aktiv'Meeting-Minuten pro Account'!$A$3:$A$10ACME CorpMobiSaveLiveSeinUdo SchorkIT and Media 2012Nolte Home StudioLandesvorstand WJ NRWMichael Gauder'Meeting-Minuten pro Account'!$C$3:$C$10General77.075.0251.0152.00.00.00.0267.0 \ No newline at end of file diff --git a/unzip_excel/xl/drawings/_rels/drawing1.xml.rels b/unzip_excel/xl/drawings/_rels/drawing1.xml.rels new file mode 100644 index 00000000..abab7803 --- /dev/null +++ b/unzip_excel/xl/drawings/_rels/drawing1.xml.rels @@ -0,0 +1,2 @@ + + \ No newline at end of file diff --git a/unzip_excel/xl/drawings/_rels/drawing2.xml.rels b/unzip_excel/xl/drawings/_rels/drawing2.xml.rels new file mode 100644 index 00000000..a3fb1398 --- /dev/null +++ b/unzip_excel/xl/drawings/_rels/drawing2.xml.rels @@ -0,0 +1,2 @@ + + \ No newline at end of file diff --git a/unzip_excel/xl/drawings/drawing1.xml b/unzip_excel/xl/drawings/drawing1.xml new file mode 100644 index 00000000..c244d65d --- /dev/null +++ b/unzip_excel/xl/drawings/drawing1.xml @@ -0,0 +1,33 @@ + + + + + 5 + 0 + 3 + 0 + + + 30 + 0 + 50 + 0 + + + + + + + + + + + + + + + + + + + diff --git a/unzip_excel/xl/drawings/drawing2.xml b/unzip_excel/xl/drawings/drawing2.xml new file mode 100644 index 00000000..35577167 --- /dev/null +++ b/unzip_excel/xl/drawings/drawing2.xml @@ -0,0 +1,33 @@ + + + + + 4 + 0 + 2 + 0 + + + 30 + 0 + 50 + 0 + + + + + + + + + + + + + + + + + + + diff --git a/unzip_excel/xl/sharedStrings.xml b/unzip_excel/xl/sharedStrings.xml new file mode 100644 index 00000000..6abbbe92 --- /dev/null +++ b/unzip_excel/xl/sharedStrings.xml @@ -0,0 +1,2 @@ + +LiveSein Nutzungsstatistiken2012-06-25 00:00:00 UTC bis2012-07-01 23:59:59 UTC1) geplante und aktive Meeting-Minuten (gesamt)2) geplante und aktive Meeting-Minuten (pro Account)3) Teamraum- und Dokumentenbestand (pro Account)Zeitpunktgeplante Minutenaktive MinutenSummeMon 000204060810121416182022Tue 00Wed 00Thu 00Fri 00Sat 00Sun 00AccountACME CorpMobiSaveLiveSeinUdo SchorkIT and Media 2012Nolte Home StudioLandesvorstand WJ NRWMichael GauderAccount-IdAccount-NameErstellungOwner NameOwner E-MailTeamraum-VerbrauchDokumenten-Verbrauch4e0d7f62ad2bfd22ac000248Frank Wöckenerfwoeck@googlemail.com4e0da31cad2bfd22ac0002ffWebseminar Juni 2011Thomasplotti@gmx.net4e165a33ad2bfd0cde00000bdefactoHans Lübkenhans@luebken.de4e16bb54ad2bfd0cd00003a9DreimannzeltMatthias Orglermatthias@dreimannzelt.de4e1ee5e5ad2bfd48f4000047DialogicThomas Rockthomas.rock@dialogic.com4e30015020e3df476100005cxenophobiasBenjaminbenjamin.gries@tribax.com4e30282220e3df4761000180TestAndy Kcavessa@gmail.com4e3169aa20e3df0b7600001fmiripiaDeals RNdealsrn@gmail.com4e3bf8bc20e3df0b260007e2test666frankfrank_c@hotmail.co.uk4e3ebb1320e3df3bb700008cLibS BayernLukas Pollmannpollmann.lukas@gmail.com4e4385f220e3df1b13000073openinstituteNiels Bensonnielsbenson@openinstitute.de4e534d8f20e3df5feb000007LinkheldenAlexander Holstalexander.holst@gmail.com4e5c934b20e3df049800001304 KinderintensivThomas Tausendthomas.tausend@klinikum-darmstadt.de4e68ae8f20e3df5c9500002cJuggernautmatthias@orgler.de4e734fc020e3df4b3d0000bfRegionaldirektion Heiko VoglerHeiko Voglerheiko.vogler@dvag.de4e898a0d20e3df758a00009aTest für Schüler als BosseMarkusspam.markus@web.de4e8d629620e3df794e0000b0sebiSebastian Lasseinput@sebastianlasse.de4e941a9a20e3df5c54000058SoGewolltUwe Kitzmannuwe.kitzmann@gmail.com4eae5f1820e3df0a2d000372Admin1Pitymagnum16@mail.ru4ebbe44420e3df340400003aCommunardoChristoph Kirstendothy@arcor.de4ecfa57a20e3df55be000026INFASabina Memedisabina.memedi@fhsmail.ch4edec44620e3df736a000044radiodonsilverdonsilver007@gmail.com4ee0f56920e3df6a2c000013Learn Music Onlinematthias.orgler@livesein.de4f01b81d20e3df41f200031etest1234plottiplotti2k1@gmail.com4f10321e20e3df6baa00014einfo@livesein.de4f2159ab20e3df75e40003aeSo LonelyMr. DontKnowAnyoneinfo@orgler.de4f2762f920e3df4ccb0003ecSamuel Ngsamuel.ng@dialogic.com4f3092fd20e3df5b340002a7ESI Hong KongKeith Fongkeith.fong@esi-asia.com4f31094620e3df7f75000001Das MailArchivTobias Müllerwj@tobias-m.de4f310a8120e3df0e81000001c.l.u.Michael Grundmannm.grundmann@think2innovate.de4f32580d20e3df3a41000001WJ-KasselHanno Rogallh.rogall@online-berater.org4f39afd920e3df2367000001University of MannheimStephan Kopfkopf@informatik.uni-mannheim.de4f45bb2920e3df2757000339grayfoxgrayfox61722@gmail.com4f45d16720e3df274c000433JMONTEROHNJAVIER MONTEROjmonterohn@yahoo.com4f4b694f20e3df4e6d000004CTModuleBruno Schwäglib_si@gmx.ch4f56192720e3df3e9d000004MorseCodeMaximilian Wichmwich@mail.uni-mannheim.de4f56493020e3df234c00007atesttdwkingtjwizkid@yahoo.com4f5775c520e3df389d000001Gaming-Community-Germanymichael.gauder@livesein.de4e70458a20e3df3c17000002Flashphonerpavelpavel.ismailov@gmail.com4f585bdb20e3df221b000001VerkaufshilfeThomas Frickthomas.frick@verkaufshilfe.net4e0da436ad2bfd22ac00040b4f5cc9f320e3df6e12000001seacioMarcioseacio@bol.com.br4e7c3c0520e3df4bf0000020Brain AGJutta Bergjtb@brain-biotech.de4f6b176c20e3df0dee000006isshoArved Stillerasr@issho.de4f71ba6e20e3df53bf000001ProfilwerkstattRalf Ansorger.ansorge@profilwerkstatt.de4f72aae520e3df218a0000014e8aed1620e3df198b000031Die eLearning AGBernd Wiestb.wiest@bw-consulting.de4f7a974220e3df2dce000003BlueMarsTobias Kirchhofertobias.kirchhofer@bluemars.net4f8570af20e3df1b2500017ddaschugMatthias Lüdersmatthias.lueders@daschug.de4f8d36d320e3df739400001dquirin bankMandy Wulsteinmandy.wulstein@quirinbank.de4f97e9d220e3df19f4000028Jens Pathenschneiderj.pathenschneider@g-c-g.de4f73280b20e3df140c0000d8d.kratz.rheinmediaDavid Kratzd.kratz@rheinmedia.de4f9da22820e3df42bc000003gonzoFred Opokuf.opoku@lancaster.ac.uk4fa7e78e20e3df2f8f000029alperionGmbHalperion GmbHa.kubias@alperion.de4faad9c920e3df6976000035reizRobert Reizrobert.reiz.81@gmail.com4ee8b9f720e3df1e7f00000cudo.schork@googlemail.com4fb391f920e3df5cab000013OrganisedMindsDiarmuid Daltúndiarmuid@organisedminds.com4fbcb05420e3df3202000001oncoteMarktest@oncote.com4fc4a76120e3df386a00004dChairiYassin Chairiyassin.chairi@verytalk.de4fc5cbc520e3df417e000001Thomas Plotkowiakthomas.plotkowiak@livesein.de4fc5e85620e3df418a00008fD&B INTERACTIVECarsten Prüsercp@d-b-interactive.com4fc7354f20e3df416c000145music-benchmarkThomas Gueffroytg@g3s.de4e7305ad20e3df4b3d000018Muster-Firma GmbHAnnette Schellannette.schell@dialogic.de4e94425020e3df5c77000291WJ-Darmstadtm.gauder@wj-darmstadt.de4fcdda8420e3df5a12000032AgnesJohannes Schönj.schoen@schoen-touristik.de4fce018020e3df5a0f00004aMeinStartupBastian Kennelbastian.kennel@gmail.com4fce018a20e3df5a21000076sasadsadsad4fce090320e3df5a2100007btest1Christian Kohoutchristian.kohout@gmail.com4fce388420e3df5a240000c9DemannTim Demanntim.demann@capalogic.de4fcf3c4120e3df57dc0001dcsanogasJürgen Greulichj.greulich@sanogas.de4fcf418920e3df57c1000058acura beteiligungenjuergen.greulich@acura-net.de4fd0928620e3df637d000003david.negrodavid.negro@amphos21.com4fd4b8fe20e3df5613000006takiiDominic Grabnerdominic.grabner3@chello.at4fd512d920e3df562b000022Testaccount AHDr. Andreas Hossandihoss@googlemail.com4fd7293d20e3df498300000bbyonAlexander Nohlesalexander.nohles@byon.net4fd7431220e3df498000002aSTAUDTEVENTSArne Schlendera.schlender@staudt-events.de4fd839f720e3df1f95000001Jörg Barthjoerg.barth@mobisave.de4fd9dffc20e3df61b9000004viewsandvisionKees Wieberingworkshops@views-and-vision.org4fd9fa2620e3df61b0000029Karsten Gerigkpost@gk-lab.de4fe1d12320e3df0d0e00001eEresourcevaibhavvaibhav@eresourceinfotech.com4fe30b0620e3df3f8b00009challwardBas Hallwardhallward@gmail.com4feaae8020e3df3e51000005Lisa Arnoldlisa.arnold@nolte.de \ No newline at end of file diff --git a/unzip_excel/xl/styles.xml b/unzip_excel/xl/styles.xml new file mode 100644 index 00000000..3d2677c1 --- /dev/null +++ b/unzip_excel/xl/styles.xml @@ -0,0 +1,2 @@ + + \ No newline at end of file diff --git a/unzip_excel/xl/theme/theme1.xml b/unzip_excel/xl/theme/theme1.xml new file mode 100644 index 00000000..a7d01483 --- /dev/null +++ b/unzip_excel/xl/theme/theme1.xml @@ -0,0 +1,2 @@ + + \ No newline at end of file diff --git a/unzip_excel/xl/workbook.xml b/unzip_excel/xl/workbook.xml new file mode 100644 index 00000000..64ee6154 --- /dev/null +++ b/unzip_excel/xl/workbook.xml @@ -0,0 +1,2 @@ + + \ No newline at end of file diff --git a/unzip_excel/xl/worksheets/_rels/sheet2.xml.rels b/unzip_excel/xl/worksheets/_rels/sheet2.xml.rels new file mode 100644 index 00000000..4babdeca --- /dev/null +++ b/unzip_excel/xl/worksheets/_rels/sheet2.xml.rels @@ -0,0 +1,2 @@ + + \ No newline at end of file diff --git a/unzip_excel/xl/worksheets/_rels/sheet3.xml.rels b/unzip_excel/xl/worksheets/_rels/sheet3.xml.rels new file mode 100644 index 00000000..27e1d83c --- /dev/null +++ b/unzip_excel/xl/worksheets/_rels/sheet3.xml.rels @@ -0,0 +1,2 @@ + + \ No newline at end of file diff --git a/unzip_excel/xl/worksheets/sheet1.xml b/unzip_excel/xl/worksheets/sheet1.xml new file mode 100644 index 00000000..f858e19c --- /dev/null +++ b/unzip_excel/xl/worksheets/sheet1.xml @@ -0,0 +1,2 @@ + +012345637383 \ No newline at end of file diff --git a/unzip_excel/xl/worksheets/sheet2.xml b/unzip_excel/xl/worksheets/sheet2.xml new file mode 100644 index 00000000..5b0c9823 --- /dev/null +++ b/unzip_excel/xl/worksheets/sheet2.xml @@ -0,0 +1,2 @@ + +9101112139SUM(C4:C86)4680SUM(D4:D86)8219999914009150091660091700918240222919300389209020921009222701149236039240092500926009156009160091700918615769196300920360892100922009236009240092500927009150091615091760091800919009200092130019221200923009240092500928009150091600917009180091900920009210092212020923009240092500929009150091630691700918120291960092015050921009220092300924009250093000915009160091700918009190092000921009220092300924009250093100915009160091712039181200919600920240224921300922120349232400924300 \ No newline at end of file diff --git a/unzip_excel/xl/worksheets/sheet3.xml b/unzip_excel/xl/worksheets/sheet3.xml new file mode 100644 index 00000000..f6f7d7d0 --- /dev/null +++ b/unzip_excel/xl/worksheets/sheet3.xml @@ -0,0 +1,2 @@ + +3211129993312307734150075359302513645015237600386003960040510267 \ No newline at end of file diff --git a/unzip_excel/xl/worksheets/sheet4.xml b/unzip_excel/xl/worksheets/sheet4.xml new file mode 100644 index 00000000..e709ada6 --- /dev/null +++ b/unzip_excel/xl/worksheets/sheet4.xml @@ -0,0 +1,2 @@ + +414243444546479999999483340725.3359490740774950223515240725.441805555558535411555640732.052442129629575812596040732.340231481481616232636440738.534502314818656611676840751.510555555556697014717240751.625578703701737411757640752.578263888892777811798040760.587361111109818200838440762.680219907408858600878840766.315393518518899010919240778.284618055557939411959640785.317905092599798109910040794.500914351855611011010210340802.56370370370110410581710610740819.4238541666641081091311011140822.3409953703741121131011411540827.4373379629611161171011811940847.3617592592561201211112212340857.6170833333311241251012612740872.6014120370381281291013013140884.0704398148151321331013413540885.733067129629611362113713840910.582557870373139140101413940921.5633101851854014251514314440934.5753124999971451461014714840939.1539930555591481491115015140946.1229282407441521531015415540946.4734027777811561572715815940946.4770486111081601611516216340947.465335648151641653616616740953.03511346064616816912717017140962.1708521180551711721017317440962.2367481134211751761017717840966.4794410995381791801018118240974.5856452893571831841018518640974.7279702662051871881118919040975.618583796298401910019219340800.2578935185161941951019619740976.30031958333198199002003540725.44506944444640191139720120240979.6605958449072032041020520640809.3319097222192072083520921040990.5094092939832112121121321440995.543503981484215216122174040996.255987916666401911412921821940820.4758101851842202211022222341002.2659526851862242251022622741010.495360046292282291023023141016.3920751736152322331023423541024.5076254166632352361223723840996.6267985185192392401524124241028.846399039352432440024524641036.637208240742472480024925041038.871958796291251252112533640891.6250810185163625442325525641045.4858493981522572581125926041052.4024627314792612621026326441058.444093842598265266102673741059.31043540509626826961427027141059.3950779629672722731127427541060.3816571759312762771027827940802.34422453703928028174528228340827.5554028472928528641065.4222728935132872881028929041065.5377831597222912921029329441065.5378976041612912920029529641065.5600373379642972981029930041065.70079253013021130330441066.4703890277743053061330730841066.4860306713023053091031031141067.4845138888923123121031331441070.6325694444463153160031731841070.898807870373193201032132241072.4821874999983233241232532641072.55872685185327328133293441073.2902662037013303311333233341074.54069444444833433511333633741074.6182175925933373380033934041080.5648495370413413421034334441081.494884259257345346103473841087.28888888889234834912 \ No newline at end of file -- cgit v1.2.3