tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 152004d1335208267-unique-lists-sumproduct-weighted-average-excel-help
Sheet: Sheet5

Sample Data |  |  |  |  | Help Needed:
Account | Days | Revenue | Color |  | Formula 1 needed: | [NAME] needed: | Formula 3 needed:
 |  |  |  |  | weighted average per account (sumproduct) for columns B and C that copies down | unique list of colors for each account | = C3 / sum of all revenues within account a
a | 1 | 4998711.11 | red |  | blank | red | = C3 / sum of all revenues within account a
a | 23 | 4997180.56 | red |  | blank | blue | = C3 / sum of all revenues within account a
a | 41 | 4993402.79 | blue |  | blank | green | = C3 / sum of all revenues within account a
a | 2 | 1999602.78 | green |  | blank | yellow | = C3 / sum of all revenues within account a
a | 17 | 4999679.17 | yellow |  | blank | blank | = C3 / sum of all revenues within account a
a | 3 | 4999708.33 | green |  | blank | blank | = C3 / sum of all revenues within account a
b | 3 | 4998751.7 | red |  | new weighted average | red | = C3 / sum of all revenues within account B
b | 14 | 3000000 | red |  | blank | blank | = C3 / sum of all revenues within account B
b | 61 | 2000000 | red |  | blank | blank | = C3 / sum of all revenues within account B
c | 34 | 10000000 | yellow |  | new weighted average | yellow | = C3 / sum of all revenues within account C
c | 4 | 10000000 | green |  | blank | green | = C3 / sum of all revenues within account C
c | 4 | 5000000 | red |  | blank | red | = C3 / sum of all revenues within account C
c | 11 | 5000000 | blue |  | blank | blue | = C3 / sum of all revenues within account C
c | 5 | 12306723.33 | blue |  | blank | blank | = C3 / sum of all revenues within account C
c | 19 | 5000000 | blue |  | blank | blank | = C3 / sum of all revenues within account C
c | 87 | 2000000 | yellow |  | blank | blank | = C3 / sum of all revenues within account C
d | 33 | 4999679.17 | blue |  | new weighted average | blue | = C3 / sum of all revenues within account D
d | 2 | 4999708.33 | red |  | blank | red | = C3 / sum of all revenues within account D
d | 2 | 4998751.7 | blue |  | blank | blank | = C3 / sum of all revenues within account D
Spreadsheet: 106116d1303329421-drop-down-list-options-prototype-5
Sheet: Sheet1

Leader | [NAME] | Wargear option 1 | Wargear option 2 | Total
Captain | [NAME] armour | Power blade | Combi-flamer
As you can see I have 4 drop down menus with the drop down menu '[NAME]', 'Weapon
option 1' and 'Weapon option 2' beign dependant on what option I chose out of the drop
down box marked 'Leader', as well as each option associated numeric value.
I have labeld each range on Sheet 2 apart from the range for the terminator armour
weapon options.
The weapon options are the same for power armour and artificer armour, but differant for
terminator armour. What I would like to have is after I select the terminator armour option
a differant drop down box appears in Weapon option 1 and Weapon option 2 that is
dependant on the 'Leader' option and '[NAME] option.
I hope I have not confused you to much!!
Spreadsheet: 138556d1327710853-improving-if-statements-with-multiple-searches-in-the-same-line-book1
Sheet: Sheet1

Company (ENG) | GICS Sector name | GICS Industry name | Cash
A | Financials | Real Estate Management & Devel
B | Utilities | Electric Utilities | 4023
C | Utilities | Gas Utilities | 9696.3
D | Financials | Real Estate Management & Devel | 16900
E | Utilities | Electric Utilities | 5839
F | Financials | Capital Markets | 19.306
G | Telecommunication Services | Diversified Telecommunication | 8101
H | Consumer Discretionary | Media | 64.764
Spreadsheet: 814610d1674506761-calculating-number-of-personnel-by-status-and-hire-date-emp_counts
Sheet: EmpList

Name | ID | xxx | Status | yyy | Stat | Hire Date | Birthdate |  | Year | Stat | Count
[NAME] | 1 | a | L B | 15 | Mgr | 1999-10-04 00:00:00 | 1961-06-13 00:00:00 |  | 1999 | Mgr | 1
[NAME] | 2 | b | B | 20 | Emp1 | 1999-10-04 00:00:00 | 1962-09-06 00:00:00 |  | 1999 | Emp1 | 1
[NAME] | 3 | c | B | 30 | Emp2 | 1999-10-04 00:00:00 | 1963-03-24 00:00:00 |  | 1999 | Emp2 | 1
Julie | 4 | d | B | 40 | Xyz | 1999-10-04 00:00:00 | 1963-04-08 00:00:00 |  | 1999 | Xyz | 1
Spreadsheet: 706395d1606675410-time-lookup-time_example
Sheet: Sheet1

Start | End
07:00:00 | 12:30:00 | Example 1
06:00:00 | 12:30:00 | Example 2
Start | End | TOTAL TIME
06:00:00 | 06:30:00
12:00:00 | 12:30:00
14:00:00 | 14:30:00
Spreadsheet: 785693d1656554712-index-match-for-multiple-values-in-array-data
Sheet: Name (2)

EmplID | Name
12345 | [NAME]
11111 | [NAME]
98765 | [NAME]
10293 | [NAME]
98125 | [NAME]
74536 | [NAME]
29673 | [NAME]
84536 | [NAME]
46385 | Holly Flax
29781 | [NAME]
63792 | Toby Flenderson
56209 | [NAME]
28331 | [NAME]
76933 | [NAME]
78243 | [NAME]
94723 | [NAME]
Spreadsheet: 978398c5-9538-4eb2-ac5a-c2b0854bbc2d
Sheet: Test Requirements

Mellanox parameters for SDR Cables
 | Low limit | High limit | Pass
Excellent | 310 | 400 | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | dsf
Robust | 270 | 309 | Yes
Satisfactory | 235 | 269 | Yes
Marginal | 220 | 234 | Yes
Inadequate | 0 | 219 | No
Mellanox parameters for DDR Cables
 | Low limit | High limit | Pass
Excellent | 118 | 200 | Yes
Robust | 100 | 117 | Yes
Satisfactory | 87 | 99 | Yes
Marginal | 80 | 86 | Yes
Inadequate | 0 | 79 | No
Mellanox parameters for QDR Cables
 | Low limit | High limit | Pass
Good | 31 | 100 | Yes
Satisfactory | 26 | 30 | Yes
Inadequate | 0 | 25 | No
[NAME]'s parameters for FDR Cables
 | Low limit | High limit | Pass
Good | 20 | 40 | Yes
Satisfactory | 10 | 19 | Yes
Inadequate | 0 | 9 | No
Spreadsheet: mark_taylor__24697__OPENACLIST
Sheet: June 2000

A/C NAME | A/C NUMBER | CTI CODE
ANSAM METALS | 50010 | [NAME]
MG LTD-CUST OMNIBUS | 50020 | [NAME]
BICC CABLES CORP | 50030 | [NAME]
SOUTHWIRE | 50060 | [NAME]
SOUTHWIRE | 50061 | [NAME]
ALPERT & ALPERT | 50080 | [NAME]
MARCO INTERNATIONAL | 50090 | [NAME]
EDF MAN-CUST OMNIBUS | 50100 | [NAME]
ALTER TRADING | 50110 | [NAME]
ANGLOJAM INVESTMENTS | 50120 | [NAME]
WISE RECYCLING | 50130 | [NAME]
TRANS-WORLD ALUMINUM | 50135 | [NAME]
PECHINEY WORLD TRADE | 50145 | [NAME]
AMROD CORP | 50150 | [NAME]
[NAME] | 55000 | [NAME]
NORANDA METALLURGY | 55001 | [NAME]
FALCONBRIDGE LTD | 55002 | [NAME]
A.J. OSTER CO. | 55003 | [NAME]
CALBAG METALS | 55004 | [NAME]
METAL RECYCLING CORP | 55005 | [NAME]
NBM LLC | 55006 | [NAME]
KENNECOT UTAH COPPER | 55007 | [NAME]
HUNTER DOUGLAS METALS | 55008 | [NAME]
BARCLAY ENTERPRISE INC | 55009 | [NAME]
LENMORE INC | 55010 | [NAME]
ACI INDUSTRIES LTD | 55011 | [NAME]
INDUSTRIAL METALS RECYCLING | 55012 | [NAME]
PIRELLI CABLES & SYSTEMS | 55013 | [NAME]
METALLIC RECOVERY GROUP | 55014 | [NAME]
[NAME] | 55015 | [NAME]
R.W. LTD OMNIBUS A/C | 55016 | [NAME]
[NAME] OMNIBUS A/C | 55017 | [NAME]
EL-MET | 55018 | [NAME]
H&H METALS | 55019 | [NAME]
FIMEXPO METALS | 55020 | [NAME]
AMERICAN IRON&METAL INC | 55021 | [NAME]
AMERICAN IRON&METAL USA | 55022 | [NAME]
REPUBLIC WIRE INC | 55023 | [NAME]
COREMET TRADING INC | 55024 | [NAME]
DOMINION METALS & REFINING | 55025 | [NAME]
AMI INDUSTRIES | 55026 | [NAME]
PHELPS DODGE | 55027 | [NAME]
CYPRESS AMAX MINERALS | 55028 | [NAME]
REVERE | 55029 | [NAME]
MG LTD | 90010 | H-4
MG LTD | 90011 | H-4
MG LTD | 90012 | H-4
MG LTD | 90013 | H-4
MG LTD | 90014 | H-4
MG LTD BULLION | 90015 | H-4
MG LTD / R. WOLFF | 90016 | H-4
MG METAL&COMMODITY CO.LTD | 90020 | H-4
MG METAL&COMMODITY CO.LTD | 90021 | H-4
HENRY BATH&SON LTD | 90030 | H-4
MG METAL&COMMODITY CORP | 90040 | H-4
MG METAL&COMM CORP ALUM | 90045 | H-4
MG METAL&COMMODITY CORP COPPER SCRAP | 90046 | H-4
MG NATURAL GAS | 90050 | H-4
Spreadsheet: 46232d1245143723-duplicating-rows-samplebook
Sheet: BEFORE

 | Queue
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Queue 5
 | [NAME]
 | Queue 7
 | [NAME] 8
 | [NAME] 9
 | [NAME] 10
 | Queue 11
 | [NAME] 12
 | [NAME] 13
 | [NAME] 14
 | Queue 15
 | [NAME] 16
 | Queue 17
 | Queue 18
 | Queue 19
 | [NAME] 20
 | Queue 21
 | [NAME] 22
 | Queue 23
 | Queue 24
 | Queue 25
 | Queue 26
 | Queue 27
 | Queue 28
 | Queue 29
 | [NAME] 30
 | [NAME] 31
 | [NAME] 32
 | [NAME] 33
 | [NAME] 34
 | [NAME] 35
 | [NAME] 36
 | [NAME] 37
 | Queue 38
 | [NAME] 39
 | [NAME] 40
 | [NAME] 41
 | [NAME] 42
 | [NAME] 43
 | [NAME] 44
 | [NAME] 45
 | [NAME] 46
 | [NAME] 47
 | [NAME]
 | [NAME] 49
 | [NAME] 50
 | [NAME] 51
 | [NAME] 52
 | [NAME] 53
 | [NAME] 54
 | [NAME] 55
 | [NAME] 56
 | [NAME] 57
 | [NAME] 58
 | Queue 59
 | Queue 60
 | Queue 61
 | [NAME] 62
 | Queue 63
 | [NAME] 64
 | [NAME] 65
 | [NAME] 66
 | [NAME] 67
 | [NAME] 68
 | Queue 69
 | [NAME] 70
 | [NAME] 71
 | [NAME] 72
 | [NAME] 73
 | Queue 74
 | Queue 75
 | Queue 76
 | [NAME] 77
 | Queue 78
 | [NAME] 79
 | [NAME] 80
 | Queue 81
 | Queue 82
 | Queue 83
 | [NAME] 84
 | Queue 85
 | Queue 86
 | [NAME] 87
 | [NAME]
 | Queue 89
 | [NAME] 90
 | [NAME] 91
 | [NAME] 92
 | [NAME] 93
 | [NAME] 94
 | [NAME] 95
 | [NAME] 96
 | [NAME] 97
 | [NAME] 98
 | [NAME] 99
 | Queue 100
 | Queue 101
 | Queue 102
 | [NAME] 103
 | Queue 104
 | Queue 105
 | Queue 106
 | Queue 107
 | [NAME] 108
 | Queue 109
 | [NAME] 110
 | Queue 111
 | [NAME]
 | Queue 113
 | Queue 114
 | Queue 115
 | [NAME]
 | Queue 117
 | Queue 118
 | Queue 119
 | Queue 120
Spreadsheet: michelle_cash__26544__Scorecard
Sheet: Commercial Scorecard

Employee Name | Mission Critical/Host Skills | Enron Business Knowledge | Adaptability | Transferable Skills | Leadership Potential | Connecting & Leveraging | Judgment | Dealmaking | Customer Relationships | Innovation/Challenging the Status Quo | Total Score  (Highest possible score - 50)
 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 1 = Best Score 5 = Worst Score
Spreadsheet: drew_fossum__8994__Fixed3_103100
Sheet: Sempra_1_Expired

[NAME]
FUEL HEDGING BOOK
Sempra_1
Prod. | Contract | Contract | Fixed |  | Fuel | Settled | Futures | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | El Paso SJ |  | (4) | (4) | (4)
Jun-1999 |  |  | 1.945 |  |  | 1.96
Jul-1999 |  |  | 1.945 |  |  | 2.05
Aug-1999 |  |  | 1.945 |  |  | 2.26
Sep-1999 |  |  | 1.945 |  |  | 2.63
Oct-1999 |  |  | 1.945 |  |  | 2.37
Nov-1999 |  |  | 1.945 |  |  | 2.84
Dec-1999 |  |  | 1.945 |  |  | 2.08
Jan-2000 |  |  | 1.945 |  |  | 2.18
Feb-2000 |  |  | 1.945 |  |  | 2.36
Mar-2000 |  |  | 1.945 |  |  | 2.37
Apr-2000 |  |  | 1.945 |  |  | 2.75
May-2000 |  |  | 1.945 |  |  | 2.78
 |  |  |  |  |  | TW Index
Jun-1999 |  | Engage | 1.945 |  |  | 2.07
Jul-1999 |  | Engage | 1.945 |  |  | 2.11
Aug-1999 |  | Engage | 1.945 |  |  | 2.51
Sep-1999 |  | Engage | 1.945 |  |  | 2.36
Oct-1999 |  | Engage | 1.945 |  |  | 2.62
Nov-1999 |  | Engage | 1.945 |  |  | 2.17
Dec-1999 |  | Engage | 1.945 |  |  | 2.24
Jan-2000 |  | Engage | 1.945 |  |  | 2.26
Feb-2000 |  | Engage | 1.945 |  |  | 2.43
Mar-2000 |  | Engage | 1.945 |  |  | 2.64
Apr-2000 |  | Engage | 1.945 |  |  | 2.79
May-2000 |  | Engage | 1.945 |  |  | 3.31
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
Spreadsheet: 170076d1343153779-need-help-to-create-sales-register-with-automatic-update-my-data-sample1
Sheet: Sheet2

Sales register cusomer wise
Sr. No | Customer name | total sales
1 | AAAAAAAAAAA | 1726 |  |  |  | need to update custmer names & total sales made to particular customer
2 | WWWWWWWWWWWW | 9366
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Spreadsheet: 41380d1239838072-conditional-averaging-excel-help
Sheet: Sheet3

 |  |  |  |  | Day |  | Start | End
 |  |  |  |  | 1 |  | 0.0187 | -0.0093
 |  |  |  |  | 2 |  | 0 | 0.2299
 |  |  |  |  | 3 |  | 0 | 0
 |  |  |  |  | 4 |  | 0.0241 | 0.0482
 |  |  |  |  | 5 |  | 0.0122 | 0.0122
 |  |  |  |  | 6 |  | 0.023 | -0.0575
 |  |  |  |  | 7 |  | 0.0366 | 0.061
 |  |  |  |  | 8 |  | -0.023 | -0.0575
 |  |  |  |  | 9 |  | 0.0353 | 0.0235
 |  |  |  |  | 10 |  | 0.0241 | 0.0241
 |  |  |  |  | 11 |  | 0.0659 | -0.0879
 |  |  |  |  | 12 |  | -0.0309 | -0.0619
 |  |  |  |  | 13 |  | 0 | 0.0543
 |  |  |  |  | 14 |  | 0.0465 | 0.0698
 |  |  |  |  | 15 |  | 0.0488 | 0.0488
 |  |  |  |  | 16 |  | 0 | -0.0353
 |  |  |  |  | 17 |  | 0.1154 | 0.0897
 |  |  |  |  | 18 |  | 0.0833 | -0.0714
 |  |  |  |  | 19 |  | -0.0889 | -0.0667
 |  |  |  |  | 20 |  | 0.0548 | 0.2329
 |  |  |  |  | 21 |  | -0.0143 | 0.0429
 |  |  |  |  | 22 |  | 0.0704 | -0.0141
 |  |  |  |  | 23 |  | 0.1719 | 0.1094
 |  |  |  |  | 24 |  | 0.1042 | 0.3333
 |  |  |  |  |  |  | Average | Average
Spreadsheet: jeff_dasovich__14097__Sempra Data
Sheet: GCIM & PBR

Summary of SoCalGas & SDG&E
Core Procurement Incentive Mechanisms
Year | Mechanism | Period | Award | Quantity | Margin | [NAME] | Term
 |  |  | $[NAME] | Bcf | $/MMBtu
1995 | GCIM | Apr/94 - Mar/95 | 0 | 291.372 |  | 2% above and 0.5%
1996 | GCIM | Apr/95 - Mar/96 | 3.2 | 255.434 |  | Below Index.  50/50
1997 | GCIM | Apr/96 - Mar/97 | 10.59292 | 255.297 |  | sharing above and
1998 | GCIM | Apr/97 - Mar/98 | 2.0399 | 253.54 |  | below Index. | Indefinite
1999 | GCIM | Apr/98 - Mar/99 | 7.733 | 289.779 |  | Includes transport. | Indefinite
2000 | GCIM | Apr/99 - Mar/00 | 9.759744 | 405 |  | Includes transport. | Indefinite
Year | Mechanism | Period | Award | Quantity | Margin | [NAME] | Term
 |  |  | $[NAME] | Bcf | $/MMBtu
1994 | PBRM | Aug/93 - Jul/94 | 2.802861 | 94.455887 |  | 25/75 Sharing of Costs
1995 | PBRM | Aug/94 - Jul/95 | 1.042684 | 92.749883 |  | Exceeding 102% of
1996 | PBRM | Aug/95 - Jul/96 | 0 | 89.387783 |  | Tolerance.  50/50
1997 | PBRM | Aug/96 - Jul/97 | 4.607966 | 103.609054 |  | sharing of savings
1998 | PBRM | Aug/97 - Jul/98 | 2.028556 | 100.008362 |  | below Tolerance band. | 2003-07-31 00:00:00
1999 | PBRM | Aug/98 - Jul/99 | 0.41861 | 97.602377
2000 | PBRM | Aug/99 - Jul/00
COMBINED
Year | Mechanism | Period | Award | Quantity | Margin | Comment | Term
 |  |  | $[NAME] | Bcf | $/MMBtu
1994 | PBRM |  |  | 94.455887 |  | SDG&E Only
1995 | Combined
1996 | Combined
1997 | Combined
1998 | Combined
1999 | Combined
2000 | Combined
Spreadsheet: 1f0371b6-4974-4ae0-9451-08a7becd23c2
Sheet: Sheet1

Supplemental Table 1: Tandem repeat analysis | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | Repeat bases | Total bases | Ratio | Enrichment in Islands
All tandem repeats
 | Genome | 54952425 | 2866216770 | 0.01917
 | Islands | 4427950 | 176539420 | 0.02508 | 1.308
1-mers
 | Genome | 2154662 | 2866216770 | 0.0007517
 | Islands | 147777 | 176539420 | 0.000837 | 1.113
2-mers
 | Genome | 6604619 | 2866216770 | 0.002304
 | Islands | 363489 | 176539420 | 0.002058 | 0.893
3-mers
 | Genome | 1072909 | 2866216770 | 0.0003743
 | Islands | 84120 | 176539420 | 0.0004764 | 1.272
4-mers
 | Genome | 5376878 | 2866216770 | 0.001875
 | Islands | 449055 | 176539420 | 0.002543 | 1.356
5-mers
 | Genome | 2152234 | 2866216770 | 0.0007508
 | Islands | 167280 | 176539420 | 0.0009475 | 1.262
6-mers
 | Genome | 1164340 | 2866216770 | 0.0004062
 | Islands | 92823 | 176539420 | 0.0005257 | 1.294
>6-mers
 | Genome | 41261014 | 2866216770 | 0.01439563623793884
 | Islands | 3495901 | 176539420 | 0.01980238181364819 | 1.375582258841759
Spreadsheet: 50671d1250152062-stock-levels-dependant-on-product-and-in-out-ewrg-rotherham-stock-levels
Sheet: Sheet1

EWRG - Rotherham stock transfers
Stock levels at Rotherham
Battery bin | Collapsible | Green steel | Non linear | Pipes | [NAME]
?? | ?? | ?? | ?? | ?? | ??
 | Vehicle | Driver |  |  | In/Out
 | BV58 UGR | A Childs |  |  | In
 | DX08 EVP | A [NAME] |  |  | Out
 | DX08 EVT | C Goto
 | EU06 EZE | [NAME]
 | EU06 EZF | C Karolia
 | EU06 EZG | C Postill
 | EU06 EZH | D Burgess
 | EU06 EZJ | D Harrigan
 | EU08 VWN | D Hector
 | EU08 VWO | G Kotze
 | EU08 VWR | I Crowther
 | EU08 VWS | [NAME]
 | KP08 RXL | J [NAME]
 | NA05 DZJ | J [NAME]
 | NK55 EKF | M Storer
 | NK55 EKG | P Little
 | NK55 EKH | R Youel
 | NK55 EKJ | S Richardson
 | T760 YBL
Stock Movements
Date | Vehicle | Driver | Product | Quantity | In/Out
2009-08-07 00:00:00 | EU06 EZE | C Karolia | [NAME] | 81 | In
2009-08-10 00:00:00 | EU06 EZF | C Postill | [NAME] | 30 | Out
Spreadsheet: 762680d1641732339-date-2-years-formula-permit-register-example-9-1-22
Sheet: Quotes

ABC Job Number | Address | Description | Client
 | Address 27 | Description 27 | Client 27
ABC-21028 | Address 28 | Description 28 | Client 28
ABC-21029 | Address 29 | Description 29 | Client 29
ABC-21030 | Address 30 | Description 30 | Client 30
Spreadsheet: 860932d1708952535-adding-a-numerical-value-to-a-drop-down-text-lists-in-various-columns-sample-speaking-assessment-1
Sheet: 2A 

NAME | GRAMMAR AND VOCABULARY | DISCOURSE MANAGEMENT | PRONUNCIATION | INTERACTIVE COMMUNICATION | TOTAL | COMMENT
[NAME] | 1. Shows sufficient control of simple grammatical forms. Uses a limited range of appropriate vocabulary to talk about familiar topics | 1. Produces responses which are characterised by short phrases and frequent hesitation. Repeats information or digresses from the topic. | 3. Is mostly intelligible, and has some control of phonological features at both utterance and word levels. | 0. Performance below Band 1. has difficulty maintaining simple exchanges. Requires a lot of prompting and support.
[NAME]
[NAME]
[NAME]
Helena Contreras
Anabella Cotugno
Alejandro Escobar
[NAME]
[NAME]
[NAME]
María Gata
[NAME]
[NAME]
[NAME]
Aitor López
[NAME]
[NAME]
Seong Hyeon Park
[NAME]
Izan Pedregosa
[NAME]
[NAME]
Blessin [NAME]
[NAME]
Aarón Tena
[NAME]
[NAME]
Spreadsheet: 747887d1631760105-help-index-match-if-min-formula-across-multiple-sheets-with-changeable-data-in-cells-inventory-control-master-do-not-modify-copy-for-your-month-
Sheet: Screen

[NAME] | Item Description | Supplier | Object Type | Base Stock Level | Earliest [NAME]: | Stock On Hand | Reorder Amount
Spreadsheet: 2d8c560f-81df-442b-b8bd-9d2b226792d5
Sheet: GPA Computation

Course Title | Credit Hours | Letter Grade |  | Status |  |  | Special Issues
 | 2 | A |  |  |  |  | All transferred courses are marked as a grade of "T."
 | 3 | B
 | 1 | C
 | 5 | D
 | 2 | WF
 | 3 | I |  |  |  |  | Any course that is repeated must list the most recently received grade.  If the most recent grade is transferred to VMI, use the grade of "T."
 | 4 | WF
 | 1 | P
 | 6 | CR
 | 2 | WP
 | 2 | F |  |  |  |  | The following grades are automatically excluded - Grades of F or WF recived during a VMI Summer Session of Grades of D, F or Wf received during VMI STP Program.
 | 3 | T
 |  |  |  |  |  |  | Any cadet receiving a grade of D during a VMI Summer Session, may have the grade deleted by petitioning the Registrar's Office by the end of Drop/Add of the immediately following fall semester.
Cumulative GPA
Spreadsheet: 6ebd2b1e-1666-415d-aa89-cc3799aa427a
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43615294 | 2014-10-17 06:54:38 | ALLIES | 0 | 2 | 6 | 384175 | ssegrubnad | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
43615411 | 2014-10-17 07:07:18 | AXIS | 1 | 6 | 2 | 384175 | ssegrubnad | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
43626997 | 2014-10-18 03:57:22 | AXIS | 0 | 1 | 7 | 1611589 | *player1611589 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43627186 | 2014-10-18 04:17:42 | ALLIES | 0 | 2 | 7 | 1611589 | *player1611589 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43656001 | 2014-10-20 02:13:28 | AXIS | 0 | 0 | 6 | 1657989 | rafael-r.94 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43656131 | 2014-10-20 02:30:02 | ALLIES | 1 | 6 | 3 | 1657989 | rafael-r.94 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43657415 | 2014-10-20 04:41:53 | ALLIES | 0 | 3 | 4 | 465599 | Timor | 7269 | mediterranean | 1940-11-06 | 1940-11-06 | Gallabat & Metemma | Gallabat & Metemma
43657602 | 2014-10-20 04:57:37 | AXIS | 0 | 0 | 4 | 465599 | Timor | 7269 | mediterranean | 1940-11-06 | 1940-11-06 | Gallabat & Metemma | Gallabat & Metemma
43657774 | 2014-10-20 05:13:53 | ALLIES | 1 | 6 | 3 | 465599 | Timor | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43657910 | 2014-10-20 05:36:00 | AXIS | 0 | 5 | 6 | 465599 | Timor | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
Spreadsheet: 786251d1657069316-help-to-get-a-formula-to-return-the-date-of-the-last-monthly-rental-in-a-cash-flow-return-last-rental
Sheet: Sheet1

Payout Number | Monthly Rental | 2022-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] to return the data of the last monthly rental (column B) | Expected result
500000 | 25000 |  |  |  |  |  |  |  | 500000 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-01 00:00:00
12500 | 5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-07-01 00:00:00
168694 | 58712 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-01 00:00:00
0 | 14000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 2023-07-01 00:00:00
Spreadsheet: 72312d1273002567-gps-coordinates-book24
Sheet: Sheet1

Address | latitude | longitude
1 BENVENUTO UNIT | 43.6818436 | -79.4003071
2 FERNDALE AVENUE | 43.1556978 | -79.2123856
25 MAITLAND AVENUE | 43.6639513 | -79.3836226
325 BESSERER AVENUE | 45.4290256 | -75.6831327
95 BRONSON ST. | 45.4065848 | -75.702918
191 PARKDALE STREET | 45.4066979 | -75.7326767
45 SPENCER | 45.4025717 | -75.7302728
53A FOXFIELD DRIVE | 45.2859593 | -75.7496506
79 ST. CLAIR AVENUE EAST | 43.6888799 | -79.3901769
43.6639513 | 43.6639513 | -79.3836226
45.4065848 | 45.4065848 | -75.702918
45.4025717 | 45.4025717 | -75.7302728
191 PARKDA | 45.4281797 | -75.6616372
325 BESSER | 45.4290256 | -75.6831327
95 BRONSON | 45.4483107 | -75.6278121
45 SPENCER | 45.4483107 | -75.6278121
53A FOXFIE | 45.4254441 | -75.6408334
2020 CLIFF | 43.5761103 | -79.5919225
170 SENTIN | 45.4446217 | -75.6423716
26 GULLIVE | 43.698932 | -79.4776691
1825 RUSSE | 45.4024608 | -75.6301203
50 SELKIRK | 45.43189 | -75.6671488
1455 MORIS | 45.4306602 | -75.6851772
1555 WALKL | 45.3807986 | -75.6374064
1570 HERON | 45.3795327 | -75.6529163
Spreadsheet: 705769d1606303152-average-last-n-rows-based-on-conditions-sample-2-ans2
Sheet: Sheet1

Player | Desc | Total | Workings | Divisor | Result |  | FORMULA
Player A |  | 61
Player A |  | 31
Player A |  | 6
Player A | NB | 74
Player A |  | 2 | 2+74+6+31+61 | Divide by 4
Player A |  | 5 | 5+2+74+6+31 | Divide by 4
Player A | NB | 45 | 45+5+2+74+6 | Divide by 3
Player A |  | 87 | 87+45+5+2+74 | Divide by 3
Player B |  | 6
Player B |  | 44
Player B |  | 9
Player B | DNQ | 0
Player B |  | 17 | 17+9+44+6 | Divide by 5
Player B |  | 3 | 3+17+9+44+6 | Divide by 5
Player B | DNQ | 0 | 3+17+9+44+6 | Divide by 5
Player B | DNQ | 0 | 3+17+9+44+6 | Divide by 5
Player B | NB | 1 | 1+3+17+9+44 | Divide by 4
Player B |  | 2 | 2+1+3+17+9 | Divide by 4