tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 686459d1594644723-dependent-drop-down-list-dependent-drop-down-list_example-1-
Sheet: Tables

 | _Country | Vietnam | England | China | Australia | Brazil |  | Country / Segment | Vietnam_Plant | Vietnam_HQ | Vietnam_DC | England_Plant | England_DC | China_Plant | Australia_Plant | Australia_DL | Brazil_DC | Can Tho | [NAME] | Da Nang
 | Vietnam | Plant | Plant | Plant | Plant | DC |  | Vietnam_Plant | Can Tho | Hanoi | [NAME] | Bradford | Bristol | Bozhou | Brisbane | Melbourne | [NAME] | Cating | Moulding | Forming
 | England | HQ | DC |  | DC |  |  | Vietnam_HQ | [NAME] |  | [NAME] | Brighton | Canterbury | Fuyang | Perth | Sidney | Salvador | Labeling |  | Machining
 | China | DC |  |  |  |  |  | Vietnam_DC | Da Nang |  | [NAME] | Cambridge |  | Chuzhou | Adelaide |  | Manaus
 | Australia |  |  |  |  |  |  | England_Plant
 | Brazil |  |  |  |  |  |  | England_DC
 |  |  |  |  |  |  |  | China_Plant
 |  |  |  |  |  |  |  | Australia_Plant
 |  |  |  |  |  |  |  | Australia_DL
 |  |  |  |  |  |  |  | Brazil_DC
 | _Country |  |  |  |  |  |  | _Country_Segment
 | =INDEX(TblVal1[Country],1,1):INDEX(TblVal1[Country],COUNTA(TblVal1[Country])) |  |  |  |  |  |  | =INDEX(TblVal2[Country_Segment],1,1):INDEX(TblVal2[Country_Segment],COUNTA(TblVal2[Country_Segment]))
 | _MainList1 |  |  |  |  |  |  | _MainList2
 | =INDEX(TblVal1,0,MATCH(INDEX(TblData1[@],COLUMN()-COLUMN(TblData1)),TblVal1[#Headers],0)) |  |  |  |  |  |  | =INDEX(TblVal2,0,MATCH(INDEX(TblData2[@],COLUMN()-COLUMN(TblData2)),TblVal2[#Headers],0))
 | _UseList1 |  |  |  |  |  |  | _UseList2
 | = INDEX(_MainList1,1,1):INDEX(_MainList1,COUNTA(_MainList1)) |  |  |  |  |  |  | = INDEX(_MainList2,1,1):INDEX(_MainList2,COUNTA(_MainList2))
Spreadsheet: 140978d1328997123-need-a-count-with-multiple-variables-example
Sheet: Sheet1

EMP | NS DAYS | BDS | PSM | SBS | IES
[NAME] | SAT SUN | X |  | X |  |  | X = employee is trained on this equipment.
MIKE | SUN MON |  | X | X | X
SUSAN | MON TUE |  |  | X
TOM | TUE WED | X | X
BILL | WED THU |  | X
[NAME] | THU FRI |  |  | X | X
JOE | FRI SAT | X
 | SAT | SUN | MON | TUE | WED | THU | FRI
BDS
PSM
SBS
IES
BDS PSM SBS IES ARE TYPES OF EQUIP. | SBS ISE are types of | re types of equipment
EMP =Technicians that work on equipment
NS Days = Non- Scheduled to work days.
Need a way to count the number of employees trained on each equip on every day of the week. |  |  |  |  |  |  |  | week input into second table.
Spreadsheet: 96732d1296049119-stuck-lookup-help-tcc-new-final-left
Sheet: wk4

Tuesday
06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Name | Night
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points |  | 1
1 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 4
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
5 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 8
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
9 |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  | 12
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
13 |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  | 16
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
17 |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  | 20
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
21 |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  | 24
Wednesday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
25 |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  | 28
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
29 |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  | 32
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
33 |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  | 36
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
37 |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  | 40
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
41 |  |  |  |  |  |  | 42
43 |  |  |  |  |  |  | 44
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
45 |  |  |  |  |  |  | 46
47 |  |  |  |  |  |  | 48
Thursday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
49 |  |  |  |  |  |  | 50
51 |  |  |  |  |  |  | 52
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
53 |  |  |  |  |  |  | 54
55 |  |  |  |  |  |  | 56
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
57 |  |  |  |  |  |  | 58
59 |  |  |  |  |  |  | 60
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
61 |  |  |  |  |  |  | 62
63 |  |  |  |  |  |  | 64
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
65 |  |  |  |  |  |  | 66
67 |  |  |  |  |  |  | 68
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
69 |  |  |  |  |  |  | 70
71 |  |  |  |  |  |  | 72
Spreadsheet: 99902d1298436403-dropdown-used-to-fill-in-remainder-of-form-help-turbinedoc_testreport-1-
Sheet: Sheet1

Work Order #: |  |  |  |  | Results
Customer: |  |  |  |  | Accept
Serial Number: |  |  |  |  | Reject Low power
Model: | C47M |  |  |  | Reject Smoke
Run Number: |  |  |  |  | Reject Vibes
 |  |  |  |  | Reject Air Leaks
[NAME] |  |  |  |  | Reject Oil Leaks
As Received |  |  |  |  | Reject Rub
Repair |  |  |  |  | Reject Other
[NAME]
C47M Performance
Setting |  | Cruise C | Cruise B | Cruise A | [NAME] | Takeoff | 2.5 Min
SPEC GPTOT |  | CM47
PRED SHP @ SPEC MGT
[NAME] SHAFT PWR
% DELTA FROM SPEC PWR
Predicted SFC
[NAME] SFC
% DELTA FROM SPEC SFC |  |  |  |  |  |  | test
Spreadsheet: 2448baa7-9ac3-4fae-8484-0da89c38d8b7
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
SHIG | Test | SHIG | Serologic Agglut Method Ident | Serologic Agglut Method 3 Ident |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87147 |  |  |  |  | Rochester
SHIG | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 778243d1650951338-assemble-a-list-to-extract-the-record-of-duplicates-crystal15
Sheet: Sheet1

 | Before |  |  |  |  |  | After
 | Customer | Amt | Helper |  |  |  | Customer | Amt
 | A | 20 |  |  |  | 1
 | A | -20
 | A | 10
 | B | 10
 | C | 10
 | D | 30
 | D | 20
Spreadsheet: 150638d1334643226-subset-a-range-for-array-multiplication-sample
Sheet: Simple_Sorted

Dataset1 |  |  |  | Dataset2
City | Response | Value1 |  | City | Response | Value2
Boston | Maybe | 10 |  | Detroit | No | 7
Detroit | No | 85 |  | New York | Yes | 65
New York | Yes | 40 |  | Toronto | Yes | 46
Orlando | Maybe | 79 |  | Vancouver | Yes | 24
Toronto | Yes | 30
Vancouver | Yes | 15
Filter Criteria: | Yes
Spreadsheet: 7c36130f-2067-4e72-b1b6-ff82f87fcf6e
Sheet: Sheet1

Table S3.  Number of genes included within CNV and PAV segments | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | All segments |  |  |  |  |  |  | Stringent segments1
 | >20% coverage |  | >50% coverage |  | >80% coverage |  |  | >20% coverage |  | >50% coverage |  | >80% coverage
Class | Genes2 | % no [NAME] | Genes2 | % no [NAME] | Genes2 | % no [NAME] |  | Genes2 | % no [NAME] | Genes2 | % no [NAME] | Genes2 | % no [NAME]
B73>Mo17_PAV | 473 | 0.3689655172413793 | 325 | 0.3324538258575198 | 246 | 0.2830882352941176 |  | 298 | 0.3489010989010989 | 232 | 0.3429602888086642 | 180 | 0.2857142857142857
B73>Mo17_Int. | 797 | 0.3700396825396826 | 604 | 0.3460490463215259 | 502 | 0.3327759197324415 |  | 528 | 0.3527696793002916 | 437 | 0.3520871143375681 | 360 | 0.3252747252747253
B73>Mo17_CNV | 115 | 0.3986486486486486 | 77 | 0.2738095238095238 | 59 | 0.1864406779661017 |  | 69 | 0.382716049382716 | 55 | 0.2678571428571428 | 41 | 0.2195121951219512
B73≈Mo17_SNP | 11492 | 0.4199077125906394 | 11184 | 0.4198928740931588 | 10783 | 0.4196661266464746 |  | 11161 | 0.4210455037919827 | 10901 | 0.4208480810604484 | 10491 | 0.4197930142302717
B73≈Mo17_Int. | 6457 | 0.4297897196261682 | 6249 | 0.4288993596713785 | 5968 | 0.4266514517560543 |  | 6217 | 0.4316755190729116 | 6042 | 0.4315553897799329 | 5748 | 0.428943258719417
B73≈Mo17 | 8618 | 0.4275201702278571 | 8401 | 0.4269202766654532 | 8134 | 0.4255519909416871 |  | 8308 | 0.4303147077713552 | 8127 | 0.4301670733996621 | 7831 | 0.4288761757005721
Mo17>B73_CNV | 227 | 0.301418439716312 | 184 | 0.3211009174311927 | 140 | 0.3081761006289308 |  | 17 | 0.4210526315789473 | 13 | 0.5 | 9 | 0.4545454545454545
Unclassified | 1607 | 0.3698428290766208 | 1538 | 0.3711767755313634 | 1467 | 0.3669574700109051 |  | 1492 | 0.3729615991583377 | 1436 | 0.374585635359116 | 1364 | 0.3706051873198847
Sum B73>Mo17 classes | 1385 | 0.3792179494765702 | 1006 | 0.3174374653295232 | 807 | 0.2674349443308869 |  | 895 | 0.3614622758613688 | 724 | 0.320968182001125 | 581 | 0.2768337353703207
[NAME] all B73≈Mo17 classes | 26567 | 0.4257392008148882 | 25834 | 0.4252375034766636 | 24885 | 0.4239565231147387 |  | 25686 | 0.4276785768787498 | 25070 | 0.4275235147466811 | 24070 | 0.4258708162167535
1The stringent segments only include segments with at least 2000bp, 10 probes and a 2 fold change for B73>Mo17 or Mo17>B73 classes.
2The number of genes refers to the number of filtered gene set genes that are 20%, 50% or 80% included within the segment sequence.
3The percent of genes with no paralog indicates the percent of the genes that do not have another gene within the full working set of genes that has a BLASTP value of <1e-15.
Spreadsheet: 3ab76478-1695-412a-85db-a6d736e79ad0
Sheet: Sheet1

Unnamed: 0 | Tri-nucleotides (M2) | Unnamed: 2 | Unnamed: 3
Category | Skew | Median Z scores | pvalue Mann-Whitney
All lambdoids | + | 1.83 | <0.00001
Rec– | + | 3.00 | <0.00001
Rec+ Inh+ | – | –1.03 | <0.00001
Rec+ Inh– | + | 2.20 | <0.00001
Spreadsheet: 490077d1479645445-add-values-from-duplicate-rows-and-delete-duplicate-solu-o-decio
Sheet: Planilha1

 | Apple | 260
 | Orange | 3
 | [NAME] | 246
 | Apple | 43
 | Mango | 93
 | [NAME] | 4
 | Melon | 260
 | Grape | 209
Spreadsheet: 140735d1328877356-fill-series-if-adjacent-cell-value-is-greater-than-zero-example
Sheet: Sheet1

Name 1 | Name 2 | Value 1 | Value 2
a |  | 0 | 0
b | 1 | 0 | 1
c | 2 | 2 | 0
d |  | 0 | 0
e |  | 0 | 0
f | 3 | 1 | 1
g | 4 | 2 | 1
h |  | 1 | 1
i |  | 0 | 0
j |  | 0 | 5
k |  | 2 | 0
l |  | 6 | 0
Spreadsheet: 218836d1362591690-excel-magic-regression-with-intercept-specified-excel-regression-non-zero-intercept-data-shifted
Sheet: Sheet6

 |  | [NAME] Points |  |  |  |  |  |  |  |  |  |  |  |  |  | Data Shifted Downward by 0.2 for Forced Intercept of 0.2
 |  | y = 0.1 + 0.4x - 0.05x^2 |  |  |  |  |  |  |  |  |  |  |  |  |  | y = -0.1 + 0.4x - 0.05x^2
 |  | x | y |  | x^0 | x^1 | x^2 | x^3 | x^4 | y*x | y*x^2 |  |  |  |  | x | y |  | y*x | y*x^2
 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | sums |  |  |  |  |  |  |  |  | sums
 |  |  | Augmented matrix for quadratic |  |  |  |  | Augmented matrix through origin |  |  |  |  |  |  |  | Augmented matrix Forced Intercept
 |  |  | x^0 | x^1 | x^2 | y |  |  | x^1 | x^2 | y |  |  |  |  |  | x^1 | x^2 | y
 |  | x^0 | 3 | 6 | 14 | 2 |  | x^1 | 14 | 36 | 4.4 |  |  |  |  | x^1 | 14 | 36 | 3.2
 |  | x^1 | 6 | 14 | 36 | 4.4 |  | x^2 | 36 | 98 | 10.9 |  |  |  |  | x^2 | 36 | 98 | 8.1
 |  | x^2 | 14 | 36 | 98 | 10.9
 | r1 / 3 | x^0
 | r2 / 6 | x^1 |  |  |  |  |  | x^1 |  |  |  |  |  |  |  | x^1
 | r3 / 14 | x^2 |  |  |  |  |  | x^2 |  |  |  |  |  |  |  | x^2
 |  | x^0 | 1 | 2 | 4.666666666666667 | 0.6666666666666666
 | [NAME] | x^1 |  |  |  |  |  | x^1 | 1 | 2.571428571428572 | 0.3142857142857143 |  |  |  |  | x^1 | 1 | 2.571428571428572 | 0.3142857142857143
 | r3 - r1 | x^2 |  |  |  |  |  | x^2 |  |  |  |  |  |  |  | x^2
 |  | x^0 | 1 | 2 | 4.666666666666667 | 0.6666666666666666
 | r2 / leading | x^1 | 0 |  |  |  |  | x^1 | 1 | 2.571428571428572 | 0.3142857142857143 |  |  |  |  | x^1 | 1 | 2.571428571428572 | 0.3142857142857143
 | r3 / leading | x^2 | 0 |  |  |  |  | x^2 | 0 |  |  |  |  |  |  | x^2 | 0
 |  | x^0 | 1 | 2 | 4.666666666666667 | 0.6666666666666666
 |  | x^1 | 0 | 1 | 3.999999999999997 | 0.2000000000000002 |  | x^1 |  |  |  | Coefficient x^1 |  |  |  | x^1 |  |  |  | Coefficient x^1
 | r3 - r2 | x^2 | 0 |  |  |  |  | x^2 | 0 | 1 | -0.07631578947368435 | Coefficient x^2 |  |  |  | x^2 | 0 | 1 | -0.07631578947368435 | Coefficient x^2
 |  | x^0 | 1 | 2 | 4.666666666666667 | 0.6666666666666666
 |  | x^1 | 0 | 1 | 3.999999999999997 | 0.2000000000000002
 | r3 / leading | x^2 | 0 | 0
 | r1 - x^2 * r3 | x^0
 | [NAME] | x^1
 |  | x^2 | 0 | 0 | 1 | -0.0500000000000018
 | r1 - x^1 * r2 | x^0 |  |  |  |  | Coefficient x^0
 |  | x^1 | 0 | 1 | 0 | 0.4000000000000072 | Coefficient x^1
 |  | x^2 | 0 | 0 | 1 | -0.0500000000000018 | Coefficient x^2
Spreadsheet: 64895d1265726318-generating-a-2nd-list-based-off-a-1st-list-help
Sheet: Sheet1

 | Values
Row Labels | Sum of P-Score | Sum of Q-Score | Sum of Occurrence
Dbt All Other | 3130.0865 | 2688.23529411764 | 6
Doe, [NAME] 3 | 1919.469 | 1494.117647058819 | 0
Doe, [NAME] 6 | 643.424 | 570.5882352941164 | 2
Doe, [NAME] 8 | 567.1935 | 623.5294117647054 | 4
Dept 1 Function 1 | 10236.8066 | 10499.99999999997 | 9
Doe, Jane 1 | 1686.89 | 1505.882352941171 | 0
Doe, [NAME] 10 | 813.2595000000001 | 870.5882352941153 | 2
Doe, [NAME] 11 | 1334.5365 | 1441.176470588231 | 0
Doe, Jane 2 | 1315.2309 | 1499.999999999995 | 2
Doe, [NAME] | 1394.9801 | 1411.764705882349 | 0
Doe, Jane 5 | 699.178 | 647.0588235294094 | 0
Doe, [NAME] 6 | 689.5891 | 776.4705882352915 | 2
Doe, Jane 7 | 1529.661 | 1517.647058823524 | 0
Doe, [NAME] 8 | 604.4739999999999 | 605.8823529411751 | 0
Doe, [NAME] 9 | 169.0075 | 223.529411764705 | 3
Dept 2 | 525.8771 | 570.5882352941163 | 3
Doe, Jane 5 | 257.0771 | 252.9411764705878 | 2
Doe, [NAME] 9 | 268.8 | 317.6470588235285 | 1
(blank)
(blank)
Grand Total | 13892.7702 | 13758.82352941172 | 18
Spreadsheet: 842343d1694450832-moving-static-data-relatively-static-relative-test2
Sheet: Required Courses By Company

Object Name | Operation1 | Operation2 | Operation3 | Operation4 | Operation5 | Operation6 | Operation7
Course2
Course3
Course4
Course5
Course6
Course7
Course8
Course9 |  | x |  |  |  |  | x
Course10
Course11 | x
Course12
Course13
Course14 |  |  |  |  |  | x
Course15 |  |  |  |  | x
Course16 |  |  | x
Course17 | x | x |  |  |  |  | x
Course18
Course19
Course20 |  |  | x
Course21
Course22
Course23
Course24
Course25
Course26
Course27
Course28
Course29
Course30
Course31
Course32
Course33
Course34
Course35
Course36
Course37
Course38
Course39
Course40
Course41
Course42
Course43
Course44
Course45
Course46
Course47
Course48
Course49 |  |  | x
Course50
Course51
Course52
Course53
Course54 |  |  |  |  |  | x
Course55
Course56
Course57
Course58
Course59
Course60
Course61
Course62
Course63
Course64
Course65 |  |  |  |  | x
Course66 |  |  |  |  | x
Course67 |  |  |  |  | x
Course68 |  |  |  |  | x
Course69
Course70
Course71
Course72
Course73 | x
Course74
Course75
Course76
Course77
Course78
Course79
Course80 | x |  | x |  | x | x
Course81
Course82
Course83
Course84 | x
Course85 | x
Course86 |  |  | x
Course87 |  |  | x
Course88 |  | x
Course89 |  |  |  |  |  | x
Course90 | x
Course91 | x
Course92
Course93
Course94
Course95
Course96
Course97
Course98
Course99
Course100
Course101 | x |  |  |  | x | x
Course102
Course103 |  | x
Course104
Course105
Course106
Course107 |  |  | x
Course108
Course109
Course110
Course111
Course112
Course113
Course114
Course115
Course116
Course117
Course118
Course119
Course120
Course121
Course122
Course123
Course124
Course125
Course126
Course127
Course128
Course129
Course130
Course131
Course132
Course133
Course134
Course135
Course136
Course137
Course138
Course139
Course140
Course141
Course142
Course143
Course144
Course145
Course146
Course147
Course148
Course149
Course150
Course151
Course152
Course153
Spreadsheet: 797115d1663713200-find-the-coverage-and-return-the-corresponding-value-example-15-
Sheet: Sheet1

 | Coverage1 | Coverage2 | Coverage3 | Coverage4 | Coverage5 | Coverage6 | Coverage7
Start Date
End Date
Return value | A | B | C | D | E | F | G
Test Date | 2021-11-01 00:00:00 | 2022-06-15 00:00:00 | 2023-01-27 00:00:00 | 2023-09-10 00:00:00 | 2024-04-23 00:00:00 | 2024-12-05 00:00:00 | 2025-07-19 00:00:00 | 2026-03-02 00:00:00 | 2026-10-14 00:00:00 | 2027-05-28 00:00:00 | 2028-01-09 00:00:00 | 2028-08-22 00:00:00
Test Result |  |  | A | B | B | C | D | D | E | E | F | G
HD
Spreadsheet: e0c1d3f1-0377-4b66-b053-b748429de02c
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
PROTR | Test | PROTR | Protriptyline (Vivactyl) | Protriptyline (Vivactyl) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 2 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable.  Spin down and send 2 mL sodium heparin plasma refrigerated in a plastic vial.    Serum Draw blood in a plain red-top tube(s), serum gel tube is not acceptable. Spin down and send 2 mL of serum refrigerated in a plastic vial. | 0.4 mL | Hemolysis	NA Thawing 	Cold OK, Warm OK Lipemia	NA Icterus	NA Other	NA | [NAME]: 50 - 170 ng/mL    Test Performed By:	Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN 55112 | Monday through Sunday | 3 days | 4 - 6 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc.
PROTR | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
PROTR | Result | Z1053 | Protriptyline (Vivactyl) | Protriptyline (Vivactyl) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 329772d1404402211-re-arranging-a-spreadsheet-arranging-using-index
Sheet: Sheet1

 |  | depthA | depthB | depthC |  |  |  |  | Solution
 | [NAME] | 1 | 3 | 6 |  |  |  |  | [NAME] | depthC
 | loc2 | 2 | 4 | 7 |  |  |  |  | [NAME] | depthB
 | loc3 | 3 | 5 | 8 |  |  |  |  | [NAME] | depthA
 |  |  |  |  |  |  |  |  | loc2 | depthC
 |  |  |  |  |  |  |  |  | loc2 | depthB
 |  |  |  |  |  |  |  |  | loc2 | depthA
 |  |  |  |  |  |  |  |  | loc3 | depthC
 |  |  |  |  |  |  |  |  | loc3 | depthB
 |  |  |  |  |  |  |  |  | loc3 | depthA
Spreadsheet: 58056d1258372120-locked-cell-wont-protect-lockcell
Sheet: User Input Sheet

Enter values in green cells:
Physical Servers |  |  | Virtual Servers: Telstra Utility
Service | Quantity |  | Service | Quantity |  |  |  |  | Single Wintel Engineer - 9x5
Windows Web Server | 0 |  | 2 x quad-core CPU 16GB [NAME] | 0 |  |  |  |  | Two Wintel Engineers - 9x5
Windows SQL Server | 0 |  | Windows Web Server | 0 |  |  |  |  | Two Wintel Engineers with 24/7 calls
[NAME] | 0 |  | Windows SQL Server | 0 |  |  |  |  | Single Network etc Engineer - 9x5
[NAME] | 0 |  | [NAME] | 0 |  |  |  |  | Two Network etc Engineers - 9x5
[NAME] | 0 |  | Windows Domain Controller | 0 |  |  |  |  | Two Network etc Engineers with 24/7 calls
Linux Custom Application Server | 0 |  | [NAME] | 0
Total | 0 |  | Linux Custom Application Server | 0
 |  |  | Total VMs | 0
Security
Service | Quantity |  | SLA
Standard Mid Sized Firewall | 0 |  | Description | SLA
 |  |  | Single Wintel Engineer - 9x5 | 0.7597222222222222
Additional Storage
Service | Quantity
1 TB FC SAN | 0
Total | 0
Telstra managed solution saving
TCO | CAPEX | Annual OPEX
Customer's in-house cost | 0 | 0
Telstra price | 0 | 0
Savings | 0 | 0
Spreadsheet: 738226d1624907305-monthly-rental-revenue-calculation-with-rcd-and-red-date-and-different-escalation-rates-monthly-rent-calculation-template
Sheet: Sheet1

 |  |  | 2020-01-01 00:00:00
 |  |  |  | Annual Rent psf
Unit | Area | RCD | RED | 2020 | 2021 | 2022 | 2023 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00
1 | 5000 | 2021-04-11 00:00:00 |  | 100 | 105 | 110 | 115
 | Required Output
Spreadsheet: sara_shackleton__36846__ENE - Forward Roll
Sheet: ENE

Forward 1 |  |  | Forward 2 |  |  | Forward 3
Shares | 1000000 |  | Shares | 850000 |  | Shares | 1388100
Trade Date | 2001-03-30 00:00:00 |  | Trade Date | 2001-03-30 00:00:00 |  | Trade Date | 2001-03-30 00:00:00
Settle Date | 2001-04-04 00:00:00 |  | Settle Date | 2001-04-04 00:00:00 |  | Settle Date | 2001-04-04 00:00:00
Expiration Date | 2001-06-29 00:00:00 |  | Expiration Date | 2001-06-29 00:00:00 |  | Expiration Date | 2001-06-29 00:00:00
Maturity Date | 2001-07-05 00:00:00 |  | Maturity Date | 2001-07-05 00:00:00 |  | Maturity Date | 2001-07-05 00:00:00
Days |  |  | Days |  |  | Days
Ticker | ENE UN Equity |  | Ticker | ENE UN Equity |  | Ticker | ENE UN Equity
Stock price | 74.17567061543113 |  | Stock price | 71.3033245818419 |  | Stock price | 82.5646
Discount to spot | 0 |  | Discount to spot | 0 |  | Discount to spot | 0
Spot |  |  | Spot |  |  | Spot
Base Rate | 0.0484 |  | Base Rate | 0.0484 |  | Base Rate | 0.0484
Spread | 0.009 |  | Spread | 0.009 |  | Spread | 0.009
Fwd Price |  |  | Fwd Price |  |  | Fwd Price
[NAME] | 3000000 |  | [NAME] | 2550000 |  | [NAME] | 4858350
Implied Put Strike |  |  | Implied Put Strike |  |  | Implied Put Strike
Put Options |  |  | Put Options |  |  | Put Options
Put Expiration | 2001-06-28 00:00:00 |  | Put Expiration | 2001-06-28 00:00:00 |  | Put Expiration | 2001-06-28 00:00:00
Spreadsheet: 88131d1288046988-setting-max-value-but-continuing-with-proportionate-calculation-series-help
Sheet: Sheet1

 |  | Years | 1 | 2 | 3 | 4 | 5
Percentage Increase |  | Series A | 75
0.35 |  | Series B | 50
 |  | Total
IDEALLY This Should be the Table
 |  | Years | 1 | 2 | 3 | 4 | 5
Percentage Increase |  | Series A | 75 |  |  | 152 | 152
0.35 |  | Series B | 50 |  |  | 98 | 98
 |  | Total |  |  |  | 250 | 250
 |  |  |  |  |  | **Notice how G9 and G10 will continue to calculate until the sum of them both =250 and remain at that maximum
 |  |  |  |  |  | So, how do I get G2 and G3 to do the same thing?