tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 271459d1381944397-help-to-create-a-index-match-list-of-unique-values-help2
Sheet: Department Summary

ACC | 2016 | 2018 | 2020 | 2037 | 2042 | 2044 | 2052 | 2055 | 2062 | 2063 | 2064 | 2092 | 2097 | 2110 | 2113 | 2117 | 2120 | 2121 | 2124 | 2134 | 2141 | 2143
ADMIN
AQ
ARK
BD
COM
EP
EQUIP
EXE
FOREST
GIS
HNADM
HNEP
HNWL
HRS
IT
LOG
MHADM
MHEP
MHWET
MHWL
PC
REC
SAFE
SENG
SOCIO
SUB
VEG
VICADM
VICEP
VICGIS
VICSOC
VICWL
WET
WL
WP
Spreadsheet: 124968d1318775779-excel-2007-concatenate-function-seating-chart
Sheet: Names

Position | Leader [NAME] | First Name | Last Name
President | 1 | [NAME] | Smith
President [NAME] | 2 | Jessica | Smith
Vice President | 3 | [NAME] | Jones
Vice [NAME] | 4 | [NAME] | Jones
Spreadsheet: tori_kuykendall__39983__Quote VVMed 04-27-01
Sheet: 4-3-01

 |  |  |  |  |  |  |  |  |  | TABLE 1
Quote for | Verde Valley Medical Center
2001-04-27 00:00:00 |  |  |  |  |  |  |  |  |  | FINAL
Del Pt.: | Citizens City Gate
 |  | [NAME] | Citygate | San Juan | San Juan | Rounded | San Juan | Citygate | [NAME] | NYMEX |  | EPSJ | Fuel | Transport | Final Price | San Juan | City Gate
 | Days/ | [NAME] | [NAME] | [NAME] | Volume | Volume | [NAME] | [NAME] | [NAME] |  | Basis | Price | Adj Price | to Gate | City Gate | payments | payments
Month | Month | MMBtu/Mo | MMBtu/Mo | MMBtu/Mo | MMBtu/d | MMBtu/day | MMBtu/Mo | MMBtu/Mo | MMBtu/Mo | $/MMBtu | $/MMBtu | $/MMBtu | *
2001-05-01 00:00:00 | 31 | 2746 |  |  |  |  |  |  |  |  |  | 4.37 |  | 0.6
2001-06-01 00:00:00 | 30 | 2358 |  |  |  |  |  |  |  | 4.88 | -0.45 |  |  | 0.6
2001-07-01 00:00:00 | 31 | 2544 |  |  |  |  |  |  |  | 4.95 | -0.45 |  |  | 0.6
2001-08-01 00:00:00 | 31 | 2448 |  |  |  |  |  |  |  | 5.01 | -0.45 |  |  | 0.6
2001-09-01 00:00:00 | 30 | 2799 |  |  |  |  |  |  |  | 5.03 | -0.43 |  |  | 0.6
2001-10-01 00:00:00 | 31 | 3544 |  |  |  |  |  |  |  | 5.06 | -0.4 |  |  | 0.6
2001-11-01 00:00:00 | 30 | 4222 |  |  |  |  |  |  |  | 5.22 | -0.17 |  |  | 0.6
2001-12-01 00:00:00 | 31 | 3991 |  |  |  |  |  |  |  | 5.37 | -0.17 |  |  | 0.6
2001-01-01 00:00:00 | 31 | 3246 |  |  |  |  |  |  |  | 5.43 | -0.17 |  |  | 0.6
2001-02-01 00:00:00 | 28 | 3804 |  |  |  |  |  |  |  | 5.29 | -0.17 |  |  | 0.6
2001-03-01 00:00:00 | 31 | 4099 |  |  |  |  |  |  |  | 5.07 | -0.17 |  |  | 0.6
2001-04-01 00:00:00 | 30 | 3500 |  |  |  |  |  |  |  | 4.63 | -0.21 |  |  | 0.6
 |  |  |  |  |  |  |  |  |  |  |  | Average San Juan Price
 |  |  |  |  |  |  |  |  |  |  |  | Average City gate Price
 |  |  |  |  |  |  |  |  |  |  |  |  | * If pipeline tariff for fuel changes during term,
 |  |  |  |  |  |  |  |  |  |  |  |  | this value will also change.
Approved: | Buyer:
 | [NAME]:
Spreadsheet: 019da1ba-54de-4bee-8dc1-a8f8ccfd6ab1
Sheet: Group Sites

Participating in CEP by Group(s):  Use the Group Sites form to list the group(s) sites.  The group(s) should be labeled "Group 1," "Group 2," and so on, with a blank row between each group.  When participating by group(s), there must be at least two school sites per group, and there is no maximum number of schools that can be a group.  However, each site can be in only one group.  Each group will have a claiming percentage that will be used for all sites in that group.  The identified student percentage would be calculated by taking the total of the identified students for that group of schools divided by the total student enrollment for that group of schools.
Group Number | Name of Group | List All Included Schools | Identified Students as of April 1, 2014 | Enrolled Students as of April 1, 2014 | Identified Student Percentage
Example:
Group 1 | North Area Schools | North Elementary | 100 | 200
 |  | North Middle School | 250 | 650
 |  | North High School | 300 | 580
 |  | Total
Group 2 | South Area Schools | South Elementary | 200 | 520
 |  | South Jr/Sr High | 250 | 480
 |  | Total
*Note that an individual school can have an identified student percentage less than 40% as long as the total for the group is 40% or greater.
Spreadsheet: 139930d1328549438-barcode-validation-ticket-database
Sheet: Sheet1

 |  |  | Y/N | BARCODE
BARCODE | SCANNED?
5
6
7
8
13
14
15
16
104
105
106
107
108
505
506
507
508
Spreadsheet: 0b2c4dd4-7afd-435f-8458-fa7b5b183f8c
Sheet: 9d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis* | 844237 | 1008167 | 755627 | 2175561 | 1477898 | 547127 | 221380 | 7029997
FRA | 14863724 | 8281317 | 4550249 | 4008770 | 62819 |  |  | 31766879
IRS- [NAME] | 6823962 | 5670135 | 5146421 | 21094055 | 33155730 | 26918343 | 13328562 | 112137208
OIS | 7886013 | 4281785 | 2423401 | 4588053 | 15193 |  |  | 19194445
VNS | 845 | <100 |  | <100 | 788 | 1096 | 1216 | 3945
Zero Coupon | 57038 | 24405 | 24777 | 42704 | 30934 | 6972 | 33225 | 220055
TOTAL | 30475819 | 19265809 | 12900475 | 31909143 | 34743362 | 27473539 | 13584383 | 170352530
Estimated gross notional amount outstanding, December 28 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 858440d1707138865-retain-values-if-no-interpolation-is-needed-cruise-perf-test-aligw-revise-
Sheet: Test (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Press Alt (ft) | STD Temp °C
 |  |  |  |  |  |  | Cruise Conditions
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 15
 |  |  |  |  |  |  | CRZ Alt: | 6000 | ft |  | Low Alt: | 4000 | ft |  |  |  |  |  |  |  |  |  |  |  | 1000 | 13
 |  |  |  |  |  |  | RPM: | 2300 |  |  | High Alt: | 6000 | ft |  |  |  |  |  |  |  |  |  |  |  | 2000 | 11
 |  |  |  |  |  |  | ISA: | -3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3000 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4000 | 7
 |  |  |  |  |  |  | Airspeed: |  | kt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000 | 5
 |  |  |  |  |  |  | Fuel: |  | GPH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6000 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7000 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8000 | -1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9000 | -3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000 | -5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11000 | -7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12000 | -9
 | Press Alt (ft) | RPM | 20°C Below Standard TEMP |  |  | STANDARD TEMP |  |  | 20°C Above Standard TEMP |  |  |  |  | Press Alt (ft) | 20°C Below Standard TEMP |  |  | STANDARD TEMP |  |  | 20°C Above Standard TEMP
 |  |  | % MCP | KTAS | GPH | % MCP | KTAS | GPH | % MCP | KTAS | GPH |  |  |  | % MCP | KTAS | GPH | % MCP | KTAS | GPH | % MCP | KTAS | GPH
 | 2000 | 2300 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 4000
 | 4000 | 2300 | 82 | 118 | 9.5 | 79 | 117 | 9.1 | 75 | 117 | 8.6 |  |  | 6000
 | 6000 | 2300 | 80 | 117 | 9.2 | 75 | 117 | 8.6 | 71 | 116 | 8.1
 | 8000 | 2300 | 76 | 117 | 8.7 | 71 | 116 | 8.2 | 68 | 115 | 7.8 |  | CRZ ALT |  | 80 | 117 | 9.2 | 75 | 117 | 8.6 | 71 | 116 | 8.1
 | 10000 | 2300 | 72 | 116 | 8.3 | 68 | 115 | 7.8 | 65 | 113 | 7.4
 | 12000 | 2300 | 69 | 115 | 7.9 | 65 | 113 | 7.5 | 62 | 111 | 7.1
 | 2000 | 2250 | 84 | 116 | 9.3 | 79 | 115 | 9 | 74 | 114 | 8.5
 | 4000 | 2250 | 80 | 115 | 9.2 | 75 | 114 | 8.6 | 70 | 114 | 8.1
 | 6000 | 2250 | 76 | 115 | 8.7 | 71 | 114 | 8.1 | 67 | 113 | 7.6
 | 8000 | 2250 | 72 | 114 | 8.3 | 68 | 113 | 7.8 | 64 | 111 | 7.4 |  | CRZ ALT
 | 10000 | 2250 | 68 | 113 | 7.8 | 65 | 112 | 7.4 | 61 | 109 | 7.1
 | 12000 | 2250 | 65 | 112 | 7.5 | 62 | 109 | 7.1 | 59 | 107 | 6.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CRUISE - KTAS |  |  |  | FUEL - GPH |  |  | RPM | KTAS | GPH
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2250 | 2300 |  |  | 2250 | 2300 |  | 2250
 |  |  |  |  |  |  |  |  |  |  |  |  | -20 |  |  |  | -20 |  |  |  | 2300
 |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  | 20
Spreadsheet: 777453d1650387057-sum-is-off-by-01-according-to-calculator-sheet-shared-1
Sheet: Pricing (3)

correct for net strip
 |  |  |  |  |  |  |  | ns | gs | [NAME] | grw
Net Strip | 3.65 | Waste Factor
Thickness | 2
[NAME] | 8 |  |  |  |  |  |  |  | Thickness * Width
Margin | 0.65 |  |  |  |  |  |  |  | Margin * Total Footage / Footage A mplus (calculator in mind)
Set up | 100
Run Charge | 0.55 | Other |  |  |  |  |  |  | Set up / Footage A
Knife Charge | 90 | K Width | 6.5 |  |  |  | [NAME] |  | Run charge
Freight Charge | 0.75 | Freight Cost |  |  |  |  |  |  | other run charge
[NAME] | Glue |  | 0.55 |  | list all items used to calculate this total |  |  |  | determining factor for run charge
Footage A | 800 |  |  |  |  |  |  |  | knife charge * kwidth +0.5 / footage A
Footage + | 30 |  |  |  |  |  |  |  | freight charge / .75 /  total footage
Total footage |  |  |  |  |  |  |  |  | freight charge
Sub total |  |  |  |  | 0 |  |  |  | determing cell for freight
Cells with boxes have drop downs all others are fillable |  |  |  |  | 0
Sell Price |  |  |  |  |  |  |  |  | SUM(G3*I5) |  | cost * (thickness* width)
 |  |  |  |  |  |  |  |  | SUM(I17/12) |  | cost * (thickness* width) /12
 |  |  |  |  |  |  |  |  | sum I18/margin |  | cost * (thickness * width) / 12 / margin
 |  |  |  |  |  |  |  |  | I19*total footage |  | cost * (thickness * width) / 12 / margin * total footage
selection from strip or gross * I5 = / 12 / I6 + I7 = +  I8 + I9 +I10 + C11 needs to be broken up |  |  | Not used |  |  |  | base cost |  | i20/footage a |  | cost * (thickness * width) / 12 / margin * total footage / footage a
+I8+I11+I12+I13+C11) |  |  | Not used |  |  |  |  |  |  |  |  | base cost not rounded
 |  |  | Not used |  |  |  |  |  | [NAME] (run charge determining factor)
 |  |  |  |  |  |  |  |  | I23 + knife charge*width…
Enter footage in cell B12 and enter the additional footage in B13. All cells require input that effect the formulas. There are dropdowns for each category that require you to select one or input their own info. Each blank field with a box outline needs to be filled or left blank
 |  |  |  |  |  |  |  |  | net strip cost sell based on brian numbers |  |  |  | I21  + I8 + I11 + I12 + I15 + D11
Spreadsheet: 684798d1593539340-auto-fill-function-that-references-another-sheet-autofill-from-list-example
Sheet: Workbook

List | Data1 | Data2 | Data3 | User Entry Field 1 | User Entry Field 2 | User Entry Field 3 | User Entry Field 4
Tesla |  |  |  | Green | Yellow | Low | High
Toyota |  |  |  | Red | Red | Medium | Low
Hond…? |  |  |  | Green | Yellow | High | Medium
Spreadsheet: 124042d1318016938-excel-2007-sum-if-but-only-if-not-already-calculated-cinema-sales
Sheet: Sheet1

Title | Category | Time | Total seats | Comps | Paying | Sales | Run total
Love Like Poison | Foregin | 17:15:00 | 2 | 0 |  | 9
Water For Elephants | Feature | 20:15:00 | 27 | 1 |  | 140.28
Rio | Family | 13:30:00 | 13 | 0 |  | 49.85
Water For Elephants | Feature | 17:15:00 | 24 | 0 |  | 103.75
Love Like Poison | Foregin | 20:15:00 | 6 | 0 |  | 31.5
Rio | Family | 13:30:00 | 20 | 0 |  | 77
Love Like Poison | Foregin | 17:15:00 | 1 | 0 |  | 3.3
Water For Elephants | Feature | 20:15:00 | 30 | 2 |  | 154
Rio | Family | 13:30:00 | 4 | 2 |  | 8
Spreadsheet: 159389d1338608383-2-specific-secondary-drop-down-lists-can-be-chosen-after-chosen-specific-option-in-primary-development_indirect-vlookup-_swing-ticket
Sheet: 69LSizeChart

 | SizeChart |  |  | ST/L2101OT |  |  |  |  |  | ST/M2102OT |  |  |  | ST/A2222OM
1 | ST/L2101OT | STL2101OTPriSize | STL2101OTSecSize | Primary [NAME] |  | Secondary [NAME] |  |  |  | Primary [NAME] |  | Secondary [NAME] |  | Primary [NAME] |  | Secondary [NAME]
2 | ST/M2102OT | STM2102OTPriSize | STM2102OTSecSize | Dress Size | Pantone Code | Lengths | Pantone Code |  |  | [NAME] | Pantone Code | Lengths | Pantone Code | [NAME] | Pantone Code | Lengths | Pantone Code
3 | ST/A2222OM | STA2222OMPriSize | STA2222OMSecSize | 2 | 203C | X SHORT | DNP | Secondary [NAME] |  | 33 | 203C | X SHORTa | DNP | 1 | 203C | X SHORTb | DNP
4 |  |  |  | 4 | 366C | SHORT | DNP | Secondary [NAME] |  | 34 | 366C | SHORTa | DNP | 2 | 366C | SHORTb | DNP
5 |  |  |  | 6 | 134C | SHORT FIT | DNP | Secondary [NAME] |  | 35 | 134C | SHORT FITa | DNP | 3 | 134C | SHORT FITb | DNP
6 |  |  |  | 8 | 2716C | SHORT FITTING | DNP | Secondary [NAME] |  | 36 | 2716C | SHORT FITTINGa | DNP | 4 | 2716C | SHORT FITTINGb | DNP
7 |  |  |  | 10 | 1485C | PETITE | DNP | Secondary [NAME] |  | 37 | 1485C | PETITEa | DNP | 5 | 1485C | PETITEb | DNP
8 |  |  |  | 12 | 367C | CROPPED | DNP | Secondary [NAME] |  | 38 | 367C | CROPPEDa | DNP | 6 | 367C | CROPPEDb | DNP
9 |  |  |  | 14 | 319C | MEDIUM | DNP | Secondary [NAME] |  | 39 | 319C | MEDIUMa | DNP | 7 | 319C | MEDIUMb | DNP
10 |  |  |  | 16 | 115C | MIDI | DNP | Secondary [NAME] |  | 40 | 115C | MIDIa | DNP | 8 | 115C | MIDIb | DNP
11 |  |  |  | 18 | 198C | MINI | DNP | Secondary [NAME] |  | 41 | 198C | MINIa | DNP | 9 | 198C | MINIb | DNP
12 |  |  |  | 20 | [NAME] | STANDARD | DNP | Secondary [NAME] |  | 42 | [NAME] | STANDARDa | DNP | 10 | [NAME] | STANDARDa | DNP
13 |  |  |  | 22 | 687C | STANDARD FIT | DNP | Secondary [NAME] |  | 43 | 687C | STANDARD FITa | DNP | 11 | 687C | STANDARD FITb | DNP
14 |  |  |  | 24 | 143C | LONG | DNP | Secondary [NAME] |  | 44 | 143C | LONGa | DNP | 12 | 143C | LONGb | DNP
15 |  |  |  | 26 | 337C | LONG FIT | DNP | Secondary [NAME] |  | 45 | 337C | LONG FITa | DNP | 13 | 337C | LONG FITb | DNP
16 |  |  |  | 28 | 292C | X LONG | DNP | Secondary [NAME] |  | 46 | 292C | X LONGa | DNP | 14 | 292C | X LONGb | DNP
17 |  |  |  | 30 | 702C | XX LONG | DNP | Secondary [NAME] |  | 47 | 702C | XX LONGa | DNP | 15 | 702C | XX LONGb | DNP
18 |  |  |  | 32 | 480C | SHORT/MEDIUM | DNP | Secondary [NAME] |  | 48 | 480C | SHORT/MEDIUMa | DNP | 16 | 480C | SHORT/MEDIUMb | DNP
19 |  |  |  |  |  | MEDIUM/LONG | DNP | Secondary [NAME] |  |  |  | MEDIUM/LONGa | DNP |  |  | MEDIUM/LONGb | DNP
20 |  |  |  |  |  | LONG/X LONG | DNP | Secondary [NAME] |  |  |  | LONG/X LONGa | DNP |  |  | LONG/X LONGb | DNP
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 749444d1632812258-count-of-values-where-corresponding-column-meets-criteria-example-count-if-
Sheet: Sheet1

 | Count example table
 | A | B | 0 | 1
 | B | C | 3 | 2
 | C | D | 4 | 1
 | D | A | 0 | 0
 | B | C | 5 | 2
 | E | A | 19 | 4
Spreadsheet: 840147d1692487558-need-to-calculate-average-over-a-date-range-using-several-variables-dummy-report
Sheet: Sheet1

Date From: | 2022-06-01 00:00:00
Date To: | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | 2022-10-01 00:00:00 | 2023-04-01 00:00:00
Employee | Target |  | Employee | Date 1 | Pos 1 | Date 2 | Pos 2 | Date 3 | Pos 3 |  | Position | Target 1 | Target 2 | Target 3 | Target 4
Richie |  |  | Richie | 2020-01-01 00:00:00 | Assistant Consultant | 2022-12-01 00:00:00 | Consultant |  |  |  | Director | 5 | 5.5 | 6
Palmer | 5.533333333333333 |  | Palmer | 2020-01-01 00:00:00 | Director |  |  |  |  |  | Associate Director | 4 | 4.5 | 5
[NAME] | 3.866666666666667 |  | [NAME] | 2020-01-01 00:00:00 | Senior Consultant | 2023-04-01 00:00:00 | Associate Director |  |  |  | Senior Consultant | 3 | 3.5 | 4
Milligan | 3.866666666666667 |  | Milligan | 2020-01-01 00:00:00 | Consultant | 2022-08-01 00:00:00 | Senior Consultant | 2023-02-01 00:00:00 | Associate Director |  | Consultant | 2 | 2.5 | 3
 |  |  |  |  |  |  |  |  |  |  | Assistant Consultant | 1 | 1.5 | 2
Spreadsheet: 167476d1342010180-convert-multiple-column-to-excel-sheet-attached-book1
Sheet: Sheet4

[NAME], [NAME]
111 Pine St.
San Diego, CA
(555) 128-549
Jones, [NAME]
222 Oak Ln.
New York, NY
(555) 238-1845
[NAME], [NAME]
333 [NAME].
Chicago, IL
(555) 581-4914
Spreadsheet: 471145d1468887929-collect-rows-with-specific-values-and-then-comiple-example-2-ndm
Sheet: After

ID | Name | State |  | Kept | ID | Name | State
1 | item 1 | Kept |  | Moved
2 | item 2 | Transferred
3 | item 3 | Kept
4 | item 4 | Kept
5 | item 5 | Transferred
6 | item 6 | Transferred
7 | item 7 | Moved
8 | item 8 | Kept
9 | item 9 | Kept
Spreadsheet: jeff_dasovich__14105__Response to 10-12 Workshop Questions
Sheet: Q5-6

QUESTION 5
Q. What were the the path specific and total system actual load factors for 1999?
A. Using daily transport volumes taken from Table 2 of the Gas Accord II Data Book and
annual firm capacities taken from the Gas Accord Settlement Agreement, page 17,
1999 actual load factors are as follows:
1999 Average Daily Transport Volumes and Load Factors
(MDth/day)
 |  | Baja | Redwood | Silverado | Total
Daily Transport |  | 661.9424471070148 | 1730.223113882489 | 147.182207936508
Firm Design Capacity |  | 1174 | 1830.195 | 200
Average Load Factor |  | 0.5638351338219888 | 0.9453763745843962 | 0.7359110396825398
Notes: - Scheduled daily transport volumes include on-system and off-system firm,
as-available and market center activity
- SMUD volumes and capacity included
QUESTION 6
Q. What would backbone transmission rates be if calculated using the 1999
actual load factors?
A. Using the actual load factor calculated above and the 2003 Cost of Service data,
the various rate scenarios are as follows:
Rates Using Actual Load Factor
($/Dth)
 |  | Redwood |  |  | Baja | Silverado
 |  | Core | Noncore | Off-system
A.  2003 Status Quo
87.5 percent Load Factor |  | 0.147 | 0.297 | 0.306 | 0.21 | 0.159
B.  2003 - Actual Load Factor
79 percent average |  | 0.159 | 0.322 | 0.306 | 0.227 | 0.169
Difference from A
C.  2003 - Actual Load Factor |  | 95 % LF |  |  | 56% LF | 74% LF
Path Specific |  | 0.133 | 0.27 | 0.306 | 0.318 | 0.182
Difference from A
Spreadsheet: 189310d1351155359-use-the-table-to-calculate-differetn-quantities-libro11
Sheet: Flexstrip&Acc.

LED FLEX STRIPS |  |  |  |  |  |  |  |  |  | RGB IR Controller with Remote
Number | Product | Ounces | Inside Bag(oz.) |  | Diameter and Millimeter size |  |  |  |  | Number | Product |  | Ounces | Inside Box(oz.) |  | Diameter and Millimeter size
1 | DF12-5050RGB-60 | 3.52 | 3.72 |  | 1000 x 12 x 5 |  |  |  |  | 1 | 12345 | 12V 6A | 1.72 | 2.5 |  | 49.84 x 35.30 x 22
2 | DT12-3528B-60 | 1.23 | 1.43 |  | 1000 x 15 x 5
 |  |  |  |  |  |  |  |  |  | POWER SUPPLY CORD
 |  |  |  |  |  |  |  |  |  | Number | Product |  | Ounces | Inside Box(oz.) |  | Diameter and Millimeter size
 |  |  |  |  |  |  |  |  |  | 1 | PWR123 | 12v 5A | 11.41 | TBD |  | 125.78 x 56.88 x 31.42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 ft. [NAME]
Spreadsheet: 585905d1534069631-return-value-for-first-consective-blank-cell-ignore-proceeding-blank-cells-dates-list
Sheet: Sheet1

 | Original list |  | Helper Column with dates  between first and last dates left blank |  | Expected Output |  | Ideal |  |  | My solution
 |  |  |  |  |  |  |  |  |  | Helper | Start | End
 | 2018-06-30 00:00:00 |  | 2018-06-30 00:00:00 |  | 2018-06-30 00:00:00 |  | Start | End
 | 2018-07-01 00:00:00 |  | 2018-07-01 00:00:00 |  | 2018-07-01 00:00:00 |  | 2018-06-30 00:00:00 | 2018-07-01 00:00:00
 | 2018-07-06 00:00:00 |  | 2018-07-06 00:00:00 |  | 2018-07-06 00:00:00 |  | 2018-07-06 00:00:00 | 2018-07-15 00:00:00
 | 2018-07-07 00:00:00 |  |  |  | to |  | 2018-07-20 00:00:00 | 2018-07-20 00:00:00
 | 2018-07-08 00:00:00 |  |  |  | 2018-07-15 00:00:00 |  | 2018-08-17 00:00:00 | 2018-08-19 00:00:00
 | 2018-07-09 00:00:00 |  |  |  | 2018-07-20 00:00:00
 | 2018-07-10 00:00:00 |  |  |  | 2018-08-17 00:00:00
 | 2018-07-11 00:00:00 |  |  |  | to
 | 2018-07-12 00:00:00 |  |  |  | 2018-08-19 00:00:00
 | 2018-07-13 00:00:00
 | 2018-07-14 00:00:00
 | 2018-07-15 00:00:00 |  | 2018-07-15 00:00:00
 | 2018-07-20 00:00:00 |  | 2018-07-20 00:00:00
 | 2018-08-17 00:00:00 |  | 2018-08-17 00:00:00
 | 2018-08-18 00:00:00
 | 2018-08-19 00:00:00 |  | 2018-08-19 00:00:00
Spreadsheet: 751570d1634189379-nested-if-with-multiple-criteria-if_to_check_due_how_many_days
Sheet: Sheet1

 |  | Date | Actual Date | Target (7 days) | Due? | Due how many days?
 |  | 2021-01-01 00:00:00 |  |  |  |  |  |  |  | =IF(D4>E4,"Due",IF(E4<TODAY(),"Overdue",""))
 |  | 2021-02-01 00:00:00
 |  | 2021-03-01 00:00:00
Spreadsheet: ace80df9-de0d-4f34-a233-492b8ff328d4
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
[NAME] | Test | [NAME] | Ehrlichia/Anaplasma, Molecular Detection, PCR, Blood | Ehrlichia/Anaplasma PCR, B | Real-Time Polymerase Chain Reaction (PCR)/DNA [NAME] (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA |  |  | 1 | mL | Container/Tube: Lavender top (EDTA) [NAME]: 1 mL Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	Anticoagulants other than EDTA | Negative | Monday through Saturday; Varies | Same day/1 day | 4 days | 1 | 87798 |  |  |  |  | Rochester
[NAME] | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 7 days
[NAME] | Result | 84319 | Anaplasma phagocytophilum | Anaplasma phagocytophilum | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30039-2
[NAME] | Result | 23663 | Ehrlichia chaffeensis | Ehrlichia chaffeensis | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27994-3
[NAME] | Result | 23664 | Ehrlichia ewingii/canis | Ehrlichia ewingii/canis | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48866-8
[NAME] | Result | 32010 | Ehrlichia muris-like | Ehrlichia muris-like | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process