diff options
Diffstat (limited to 'multivoltage-uart/ap2107adj-resistors.gnumeric')
-rw-r--r-- | multivoltage-uart/ap2107adj-resistors.gnumeric | 289 |
1 files changed, 289 insertions, 0 deletions
diff --git a/multivoltage-uart/ap2107adj-resistors.gnumeric b/multivoltage-uart/ap2107adj-resistors.gnumeric new file mode 100644 index 0000000..840f815 --- /dev/null +++ b/multivoltage-uart/ap2107adj-resistors.gnumeric @@ -0,0 +1,289 @@ +<?xml version="1.0" encoding="UTF-8"?> +<gnm:Workbook xmlns:gnm="http://www.gnumeric.org/v10.dtd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.gnumeric.org/v9.xsd"> + <gnm:Version Epoch="1" Major="12" Minor="32" Full="1.12.32"/> + <gnm:Attributes> + <gnm:Attribute> + <gnm:name>WorkbookView::show_horizontal_scrollbar</gnm:name> + <gnm:value>TRUE</gnm:value> + </gnm:Attribute> + <gnm:Attribute> + <gnm:name>WorkbookView::show_vertical_scrollbar</gnm:name> + <gnm:value>TRUE</gnm:value> + </gnm:Attribute> + <gnm:Attribute> + <gnm:name>WorkbookView::show_notebook_tabs</gnm:name> + <gnm:value>TRUE</gnm:value> + </gnm:Attribute> + <gnm:Attribute> + <gnm:name>WorkbookView::do_auto_completion</gnm:name> + <gnm:value>TRUE</gnm:value> + </gnm:Attribute> + <gnm:Attribute> + <gnm:name>WorkbookView::is_protected</gnm:name> + <gnm:value>FALSE</gnm:value> + </gnm:Attribute> + </gnm:Attributes> + <office:document-meta xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:ooo="http://openoffice.org/2004/office" office:version="1.2"> + <office:meta> + <dc:date>2016-10-07T11:34:09Z</dc:date> + <meta:creation-date>2016-10-07T11:26:38Z</meta:creation-date> + </office:meta> + </office:document-meta> + <gnm:Calculation ManualRecalc="0" EnableIteration="1" MaxIterations="100" IterationTolerance="0.001" FloatRadix="2" FloatDigits="53"/> + <gnm:SheetNameIndex> + <gnm:SheetName gnm:Cols="256" gnm:Rows="65536">Sheet1</gnm:SheetName> + <gnm:SheetName gnm:Cols="256" gnm:Rows="65536">Sheet2</gnm:SheetName> + <gnm:SheetName gnm:Cols="256" gnm:Rows="65536">Sheet3</gnm:SheetName> + </gnm:SheetNameIndex> + <gnm:Geometry Width="939" Height="379"/> + <gnm:Sheets> + <gnm:Sheet DisplayFormulas="0" HideZero="0" HideGrid="0" HideColHeader="0" HideRowHeader="0" DisplayOutlines="1" OutlineSymbolsBelow="1" OutlineSymbolsRight="1" Visibility="GNM_SHEET_VISIBILITY_VISIBLE" GridColor="0:0:0"> + <gnm:Name>Sheet1</gnm:Name> + <gnm:MaxCol>3</gnm:MaxCol> + <gnm:MaxRow>11</gnm:MaxRow> + <gnm:Zoom>1</gnm:Zoom> + <gnm:Names> + <gnm:Name> + <gnm:name>Print_Area</gnm:name> + <gnm:value>#REF!</gnm:value> + <gnm:position>A1</gnm:position> + </gnm:Name> + <gnm:Name> + <gnm:name>Sheet_Title</gnm:name> + <gnm:value>"Sheet1"</gnm:value> + <gnm:position>A1</gnm:position> + </gnm:Name> + </gnm:Names> + <gnm:PrintInformation> + <gnm:Margins> + <gnm:top Points="120" PrefUnit="mm"/> + <gnm:bottom Points="120" PrefUnit="mm"/> + <gnm:left Points="72" PrefUnit="mm"/> + <gnm:right Points="72" PrefUnit="mm"/> + <gnm:header Points="72" PrefUnit="mm"/> + <gnm:footer Points="72" PrefUnit="mm"/> + </gnm:Margins> + <gnm:Scale type="size_fit" cols="1" rows="1"/> + <gnm:vcenter value="0"/> + <gnm:hcenter value="0"/> + <gnm:grid value="0"/> + <gnm:even_if_only_styles value="0"/> + <gnm:monochrome value="0"/> + <gnm:draft value="0"/> + <gnm:titles value="0"/> + <gnm:do_not_print value="0"/> + <gnm:print_range value="GNM_PRINT_ACTIVE_SHEET"/> + <gnm:order>d_then_r</gnm:order> + <gnm:orientation>portrait</gnm:orientation> + <gnm:Header Left="" Middle="" Right=""/> + <gnm:Footer Left="" Middle="" Right=""/> + <gnm:paper>iso_a4</gnm:paper> + <gnm:comments placement="GNM_PRINT_COMMENTS_IN_PLACE"/> + <gnm:errors PrintErrorsAs="GNM_PRINT_ERRORS_AS_DISPLAYED"/> + </gnm:PrintInformation> + <gnm:Styles> + <gnm:StyleRegion startCol="0" startRow="0" endCol="0" endRow="65535"> + <gnm:Style HAlign="GNM_HALIGN_GENERAL" VAlign="GNM_VALIGN_BOTTOM" WrapText="0" ShrinkToFit="0" Rotation="0" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> + <gnm:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0" Script="0">Sans</gnm:Font> + </gnm:Style> + </gnm:StyleRegion> + <gnm:StyleRegion startCol="1" startRow="0" endCol="1" endRow="65535"> + <gnm:Style HAlign="GNM_HALIGN_GENERAL" VAlign="GNM_VALIGN_BOTTOM" WrapText="0" ShrinkToFit="0" Rotation="0" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="##0.000ESI-00"> + <gnm:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0" Script="0">Sans</gnm:Font> + </gnm:Style> + </gnm:StyleRegion> + <gnm:StyleRegion startCol="2" startRow="0" endCol="255" endRow="5"> + <gnm:Style HAlign="GNM_HALIGN_GENERAL" VAlign="GNM_VALIGN_BOTTOM" WrapText="0" ShrinkToFit="0" Rotation="0" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> + <gnm:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0" Script="0">Sans</gnm:Font> + </gnm:Style> + </gnm:StyleRegion> + <gnm:StyleRegion startCol="2" startRow="6" endCol="2" endRow="11"> + <gnm:Style HAlign="GNM_HALIGN_GENERAL" VAlign="GNM_VALIGN_BOTTOM" WrapText="0" ShrinkToFit="0" Rotation="0" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> + <gnm:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0" Script="0">Sans</gnm:Font> + </gnm:Style> + </gnm:StyleRegion> + <gnm:StyleRegion startCol="2" startRow="12" endCol="255" endRow="65535"> + <gnm:Style HAlign="GNM_HALIGN_GENERAL" VAlign="GNM_VALIGN_BOTTOM" WrapText="0" ShrinkToFit="0" Rotation="0" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> + <gnm:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0" Script="0">Sans</gnm:Font> + </gnm:Style> + </gnm:StyleRegion> + <gnm:StyleRegion startCol="3" startRow="6" endCol="3" endRow="11"> + <gnm:Style HAlign="GNM_HALIGN_GENERAL" VAlign="GNM_VALIGN_BOTTOM" WrapText="0" ShrinkToFit="0" Rotation="0" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="##0.000ESI-00"> + <gnm:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0" Script="0">Sans</gnm:Font> + </gnm:Style> + </gnm:StyleRegion> + <gnm:StyleRegion startCol="4" startRow="6" endCol="255" endRow="11"> + <gnm:Style HAlign="GNM_HALIGN_GENERAL" VAlign="GNM_VALIGN_BOTTOM" WrapText="0" ShrinkToFit="0" Rotation="0" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> + <gnm:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0" Script="0">Sans</gnm:Font> + </gnm:Style> + </gnm:StyleRegion> + </gnm:Styles> + <gnm:Cols DefaultSizePts="48"> + <gnm:ColInfo No="1" Unit="59.25" HardSize="1"/> + <gnm:ColInfo No="3" Unit="55.5"/> + </gnm:Cols> + <gnm:Rows DefaultSizePts="12.75"/> + <gnm:Selections CursorCol="3" CursorRow="7"> + <gnm:Selection startCol="3" startRow="7" endCol="3" endRow="7"/> + </gnm:Selections> + <gnm:Cells> + <gnm:Cell Row="0" Col="1" ValueType="60">AP2127 Resistor calculation</gnm:Cell> + <gnm:Cell Row="2" Col="0" ValueType="60">Vref</gnm:Cell> + <gnm:Cell Row="2" Col="1" ValueType="40">0.80000000000000004</gnm:Cell> + <gnm:Cell Row="3" Col="0" ValueType="60">R2</gnm:Cell> + <gnm:Cell Row="3" Col="1" ValueType="40">18000</gnm:Cell> + <gnm:Cell Row="5" Col="0" ValueType="60">Vout</gnm:Cell> + <gnm:Cell Row="5" Col="1" ValueType="60">R1_comp</gnm:Cell> + <gnm:Cell Row="5" Col="2" ValueType="60">R1_act</gnm:Cell> + <gnm:Cell Row="5" Col="3" ValueType="60">Vout_act</gnm:Cell> + <gnm:Cell Row="6" Col="0" ValueType="40">1.8</gnm:Cell> + <gnm:Cell Row="6" Col="1">=B4*((A7/B3)-1)</gnm:Cell> + <gnm:Cell Row="6" Col="2" ValueType="40">22600</gnm:Cell> + <gnm:Cell Row="6" Col="3" ExprID="1">=B3*(1+(C7/B4))</gnm:Cell> + <gnm:Cell Row="7" Col="0" ValueType="40">2.2999999999999998</gnm:Cell> + <gnm:Cell Row="7" Col="1">=B4*((A8/B3)-1)</gnm:Cell> + <gnm:Cell Row="7" Col="2" ValueType="40">34000</gnm:Cell> + <gnm:Cell Row="7" Col="3" ExprID="2">=B3*(1+(C8/B4))</gnm:Cell> + <gnm:Cell Row="8" Col="0" ValueType="40">2.5</gnm:Cell> + <gnm:Cell Row="8" Col="1">=B4*((A9/B3)-1)</gnm:Cell> + <gnm:Cell Row="8" Col="2" ValueType="40">38300</gnm:Cell> + <gnm:Cell Row="8" Col="3" ExprID="3">=B3*(1+(C9/B4))</gnm:Cell> + <gnm:Cell Row="9" Col="0" ValueType="40">2.7999999999999998</gnm:Cell> + <gnm:Cell Row="9" Col="1">=B4*((A10/B3)-1)</gnm:Cell> + <gnm:Cell Row="9" Col="2" ValueType="40">45300</gnm:Cell> + <gnm:Cell Row="9" Col="3" ExprID="4">=B3*(1+(C10/B4))</gnm:Cell> + <gnm:Cell Row="10" Col="0" ValueType="40">3</gnm:Cell> + <gnm:Cell Row="10" Col="1">=B4*((A11/B3)-1)</gnm:Cell> + <gnm:Cell Row="10" Col="2" ValueType="40">49900</gnm:Cell> + <gnm:Cell Row="10" Col="3" ExprID="5">=B3*(1+(C11/B4))</gnm:Cell> + <gnm:Cell Row="11" Col="0" ValueType="40">3.2999999999999998</gnm:Cell> + <gnm:Cell Row="11" Col="1">=B4*((A12/B3)-1)</gnm:Cell> + <gnm:Cell Row="11" Col="2" ValueType="40">56200</gnm:Cell> + <gnm:Cell Row="11" Col="3" ExprID="6">=B3*(1+(C12/B4))</gnm:Cell> + </gnm:Cells> + <gnm:SheetLayout TopLeft="A1"/> + <gnm:Solver ModelType="0" ProblemType="0" MaxTime="60" MaxIter="1000" NonNeg="1" Discr="0" AutoScale="0" ProgramR="0" SensitivityR="0"/> + </gnm:Sheet> + <gnm:Sheet DisplayFormulas="0" HideZero="0" HideGrid="0" HideColHeader="0" HideRowHeader="0" DisplayOutlines="1" OutlineSymbolsBelow="1" OutlineSymbolsRight="1" Visibility="GNM_SHEET_VISIBILITY_VISIBLE" GridColor="0:0:0"> + <gnm:Name>Sheet2</gnm:Name> + <gnm:MaxCol>-1</gnm:MaxCol> + <gnm:MaxRow>-1</gnm:MaxRow> + <gnm:Zoom>1</gnm:Zoom> + <gnm:Names> + <gnm:Name> + <gnm:name>Print_Area</gnm:name> + <gnm:value>#REF!</gnm:value> + <gnm:position>A1</gnm:position> + </gnm:Name> + <gnm:Name> + <gnm:name>Sheet_Title</gnm:name> + <gnm:value>"Sheet2"</gnm:value> + <gnm:position>A1</gnm:position> + </gnm:Name> + </gnm:Names> + <gnm:PrintInformation> + <gnm:Margins> + <gnm:top Points="120" PrefUnit="mm"/> + <gnm:bottom Points="120" PrefUnit="mm"/> + <gnm:left Points="72" PrefUnit="mm"/> + <gnm:right Points="72" PrefUnit="mm"/> + <gnm:header Points="72" PrefUnit="mm"/> + <gnm:footer Points="72" PrefUnit="mm"/> + </gnm:Margins> + <gnm:Scale type="size_fit" cols="1" rows="1"/> + <gnm:vcenter value="0"/> + <gnm:hcenter value="0"/> + <gnm:grid value="0"/> + <gnm:even_if_only_styles value="0"/> + <gnm:monochrome value="0"/> + <gnm:draft value="0"/> + <gnm:titles value="0"/> + <gnm:do_not_print value="0"/> + <gnm:print_range value="GNM_PRINT_ACTIVE_SHEET"/> + <gnm:order>d_then_r</gnm:order> + <gnm:orientation>portrait</gnm:orientation> + <gnm:Header Left="" Middle="" Right=""/> + <gnm:Footer Left="" Middle="" Right=""/> + <gnm:paper>iso_a4</gnm:paper> + <gnm:comments placement="GNM_PRINT_COMMENTS_IN_PLACE"/> + <gnm:errors PrintErrorsAs="GNM_PRINT_ERRORS_AS_DISPLAYED"/> + </gnm:PrintInformation> + <gnm:Styles> + <gnm:StyleRegion startCol="0" startRow="0" endCol="255" endRow="65535"> + <gnm:Style HAlign="GNM_HALIGN_GENERAL" VAlign="GNM_VALIGN_BOTTOM" WrapText="0" ShrinkToFit="0" Rotation="0" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> + <gnm:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0" Script="0">Sans</gnm:Font> + </gnm:Style> + </gnm:StyleRegion> + </gnm:Styles> + <gnm:Cols DefaultSizePts="48"/> + <gnm:Rows DefaultSizePts="12.75"/> + <gnm:Selections CursorCol="0" CursorRow="0"> + <gnm:Selection startCol="0" startRow="0" endCol="0" endRow="0"/> + </gnm:Selections> + <gnm:Cells/> + <gnm:SheetLayout TopLeft="A1"/> + <gnm:Solver ModelType="0" ProblemType="0" MaxTime="60" MaxIter="1000" NonNeg="1" Discr="0" AutoScale="0" ProgramR="0" SensitivityR="0"/> + </gnm:Sheet> + <gnm:Sheet DisplayFormulas="0" HideZero="0" HideGrid="0" HideColHeader="0" HideRowHeader="0" DisplayOutlines="1" OutlineSymbolsBelow="1" OutlineSymbolsRight="1" Visibility="GNM_SHEET_VISIBILITY_VISIBLE" GridColor="0:0:0"> + <gnm:Name>Sheet3</gnm:Name> + <gnm:MaxCol>-1</gnm:MaxCol> + <gnm:MaxRow>-1</gnm:MaxRow> + <gnm:Zoom>1</gnm:Zoom> + <gnm:Names> + <gnm:Name> + <gnm:name>Print_Area</gnm:name> + <gnm:value>#REF!</gnm:value> + <gnm:position>A1</gnm:position> + </gnm:Name> + <gnm:Name> + <gnm:name>Sheet_Title</gnm:name> + <gnm:value>"Sheet3"</gnm:value> + <gnm:position>A1</gnm:position> + </gnm:Name> + </gnm:Names> + <gnm:PrintInformation> + <gnm:Margins> + <gnm:top Points="120" PrefUnit="mm"/> + <gnm:bottom Points="120" PrefUnit="mm"/> + <gnm:left Points="72" PrefUnit="mm"/> + <gnm:right Points="72" PrefUnit="mm"/> + <gnm:header Points="72" PrefUnit="mm"/> + <gnm:footer Points="72" PrefUnit="mm"/> + </gnm:Margins> + <gnm:Scale type="size_fit" cols="1" rows="1"/> + <gnm:vcenter value="0"/> + <gnm:hcenter value="0"/> + <gnm:grid value="0"/> + <gnm:even_if_only_styles value="0"/> + <gnm:monochrome value="0"/> + <gnm:draft value="0"/> + <gnm:titles value="0"/> + <gnm:do_not_print value="0"/> + <gnm:print_range value="GNM_PRINT_ACTIVE_SHEET"/> + <gnm:order>d_then_r</gnm:order> + <gnm:orientation>portrait</gnm:orientation> + <gnm:Header Left="" Middle="" Right=""/> + <gnm:Footer Left="" Middle="" Right=""/> + <gnm:paper>iso_a4</gnm:paper> + <gnm:comments placement="GNM_PRINT_COMMENTS_IN_PLACE"/> + <gnm:errors PrintErrorsAs="GNM_PRINT_ERRORS_AS_DISPLAYED"/> + </gnm:PrintInformation> + <gnm:Styles> + <gnm:StyleRegion startCol="0" startRow="0" endCol="255" endRow="65535"> + <gnm:Style HAlign="GNM_HALIGN_GENERAL" VAlign="GNM_VALIGN_BOTTOM" WrapText="0" ShrinkToFit="0" Rotation="0" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> + <gnm:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0" Script="0">Sans</gnm:Font> + </gnm:Style> + </gnm:StyleRegion> + </gnm:Styles> + <gnm:Cols DefaultSizePts="48"/> + <gnm:Rows DefaultSizePts="12.75"/> + <gnm:Selections CursorCol="0" CursorRow="0"> + <gnm:Selection startCol="0" startRow="0" endCol="0" endRow="0"/> + </gnm:Selections> + <gnm:Cells/> + <gnm:SheetLayout TopLeft="A1"/> + <gnm:Solver ModelType="0" ProblemType="0" MaxTime="60" MaxIter="1000" NonNeg="1" Discr="0" AutoScale="0" ProgramR="0" SensitivityR="0"/> + </gnm:Sheet> + </gnm:Sheets> + <gnm:UIData SelectedTab="0"/> +</gnm:Workbook> |