tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1319cabf-c66c-4d59-b155-49c1300a96bb
Sheet: Sheet1

2014 DIVISION 1 CIF-SS/FORD SOFTBALL CHAMPIONSHIPS, presented by Farmers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
1ST ROUND |  | 2ND ROUND | QTR FINALS | SEMI-FINALS | FINALS
TUES., MAY 20 |  | THURS., MAY 22 | SAT., MAY 24 | TUES., MAY 27 | Fri/Sat
 |  |  |  |  | May 30 & 31
*Pacifica/GG | Empire #1 |  |  |  | [NAME]
 |  | [NAME]/GG |  |  | Stadium, [NAME]
Canyon/CC | Winner WC "A" | 6-0
*Rosary | Trinity #2 |  | *Pacifica/GG
 |  | *Etiwanda | 8-0
[NAME] | Baseline #2 | 5-2
*Camarillo | Pacific View #1 |  |  | *Pacifica/GG
 |  | *Camarillo |  | 6-0
Santiago/Corona | Big VIII #3 | 5-4
*El Modena | Century #2 | F | Camarillo
 |  | El Modena | 2-1
[NAME] | Southwestern #2 | 9-4
*Marina | Sunset #1 |  |  |  | [NAME]/GG
 |  | Marina |  | F | 2-0
Yorba [NAME] | Empire #3 | 5-2
*Saugus | Foothill #2 |  | *Canyon/Anaheim
 |  | *Canyon/Anaheim | 3-2
Canyon/Anaheim | Century #3 | 4-3
*Poly/Riverside | Inland Valley #1 |  |  | Canyon/A
 |  | Poly/Riverside | F | 2-1
[NAME] | Trinity #3 | 3-2
*Norco | Big VIII #1 | F | Poly/Riverside
 |  | *Norco | 6-4
Rancho Cucamonga | Winner WC "B" | 10-2
*Esperanza | Century #1 |  |  | Saturday, 6:30pm
 |  | *Vista Murrieta |  |  |  | PACIFICA/GG
Vista Murrieta | Winner WC "C" | 7-0 |  |  |  | 1-0 (12 Innings)
*Lutheran/Orange | Trinity #1 |  | Vista Murrieta
 |  | Lutheran/Orange | 10-7 (8 Innings)
Arlington | Winner WC "D" | 6-0
*West Ranch | Foothill #1 |  |  | Cypress
 |  | West Ranch | F | 7-1
Pacifica/Oxnard | Pacific View #3 | 20-0
*Huntington Beach | Sunset #2 |  | *Cypress
 |  | *Cypress | 5-1
Cypress | Empire #2 | 9-5
*Murrieta Valley | Southwestern #1 |  |  |  | *ML King
 |  | *Murrieta Valley |  |  | 1-0
Los Alamitos | Winner WC "E" | 2-1
*ML King | Big VIII #2 | F | [NAME]
 |  | [NAME] | 11-2
Valley View | Inland Valley #2 | 6-0
*Oxnard | Pacific View #2 |  |  | *ML King
 |  | *Oxnard |  | 3-1
[NAME] | Foothill #3 | 5-2
*Los Osos | Baseline #1 | F | *Los Osos
 |  | [NAME] | 5-0
Foothill | Winner WC "F" | 3-2
*Denotes Host Team
SOFTBALL -  DIVISION 1
Spreadsheet: 98539d1297394875-check-if-a-background-color-exists-yellow_test-1-
Sheet: Sheet1

Sheet1 |  | There are | 0 |  | Unanswered Questions |  |  |  | Return to Index
1 | + | 1 | = | 2 |  |  | 1 | + | 2 | = | 2
 |  | Fill In The Blank |  |  |  |  |  |  | Fill In The Blank
1 | + | 1 | = | 2 |  |  | 1 | + | 1 | = | 2
 |  | Fill In The Blank |  |  |  |  |  |  | Fill In The Blank
1 | + | 1 | = | 2 |  |  | 1 | + | 1 | = | 2
 |  | Fill In The Blank |  |  |  |  |  |  | Fill In The Blank
1 | + | 1 | = | 2 |  |  | 1 | + | 1 | = | 2
 |  | Fill In The Blank |  |  |  |  |  |  | Fill In The Blank
1 | + | 1 | = | 2 |  |  | 1 | + | 1 | = | 2
 |  | Fill In The Blank |  |  |  |  |  |  | Fill In The Blank
Spreadsheet: 40248d1238559300-change-sumproduct-to-if-with-exchange-rate-678002_ying
Sheet: CONSOLIDATE

TOTAL IN USD |  |  |  |  | Change Type: | FG
 | 2009-01-01 00:00:00
2009 | SEA |  |  | AIR
COUNTRY | FOB | FREIGHT | TOTAL | FOB | FREIGHT | TOTAL
CHN | 67.09034799999999 | 1.290199 | 68.38054699999999 | 0 | 0 | 0
GBR | 348.526525 | 36.2467586 | 384.7732836 | 146.3811405 | 20.9115915 | 167.292732
USA | 2498 | 33 | 2531 | 510 | 25 | 535
 |  |  |  |  |  |  |  |  |  | FG
 |  |  |  |  |  |  |  |  |  | RM
Spreadsheet: 672909d1587062868-parsing-property-address-and-property-city-state-zip-from-text-strings-addresses-formula
Sheet: Two Cols

Current Format of Data:
 |  |  |  |  |  |  |  |  |  | BLVD
Property Address | Property City State Zip |  |  |  |  |  |  |  |  | CT
6836 MORRISON BLVD STE 320 | CHARLOTTE NC 28211 |  |  |  |  |  |  |  |  | TR
22115 CLEARWOOD CT | CUPERTINO CA 95014 |  |  |  |  |  |  |  |  | TRL
6928 CHACO TRL | FORT WORTH TX 76137 |  |  |  |  |  |  |  |  | PKWY
6920 CHACO TR | FORT WORTH TX  76137-6359 |  |  |  |  |  |  |  |  | AVE
5048 TENNYSON PKWY # 250 | PLANO TX 75024 |  |  |  |  |  |  |  |  | RD
4350 VANTAGE AVE APT 105 | STUDIO CITY CA  91604-1791 |  |  |  |  |  |  |  |  | LN
PO BOX 79413 | [NAME] |  |  |  |  |  |  |  |  | ST
PSC 556 BOX 649 | APO AP  96386-0649
352 MT GILEAD RD | [NAME]
926 E EVELYN AVE | SUNNYVALE CA 94086
239 N HICKORY BRANCH LN | ORANGE CA  92869-4553
487 10th St NE | Little Rock  AR 45564
Needs to look like:
Street Address Line 1 | Street Address Line 2 | Street Name | City | State | Zip
6928 |  | [NAME] | Fort Worth | Tx | 76137-6359
6920 |  | [NAME] | Fort Worth | Tx | 76137
4350 | Apt 105 | Vantage Ave | Studio City | CA | 91604-1791
Spreadsheet: 724584d1616249103-i-need-some-help-on-sum-diferent-criterios-centro-de-custos-2021
Sheet: Vale - Barragem

 |  | CENTROS DE CUSTOS
 |  | VALE - BARRAGEM
 |  | Data | [NAME] | Req. / Fact nº | Valor - Mzn | Observação
 |  | 2020-10-17 00:00:00 | Combustivel | 54818 | 7720.8 | TLB 315 SL
 |  | 2020-11-04 00:00:00 | Combustivel | 54936 | 3860.4 | TLB 315 SL
 |  | 2020-11-23 00:00:00 | Combustivel | 55062 | 339.45 | [NAME]
 |  | 2020-11-23 00:00:00 | Combustivel | 55062 | 339.45 | [NAME]
 |  | 2020-11-23 00:00:00 | Combustivel | 55062 | 339.45 | Cilindro duplo Manual
 |  | 2020-11-23 00:00:00 | Combustivel | 55062 | 1018.35 | Gerador
 |  | 2020-12-02 00:00:00 | Combustivel | 55119 | 905.2 | Gerador
 |  | 2020-12-02 00:00:00 | Combustivel | 55119 | 339.45 | PowerFloot
 |  | 2020-12-02 00:00:00 | Combustivel | 55119 | 339.45 | Saltitao
 |  | 2020-12-03 00:00:00 | Combustivel | 55122 | 3200 | TLB 315 SL
 |  | 2020-12-08 00:00:00 | Combustivel | 55151 | 1365.76 | TLB 315 SL
 |  | 2021-01-05 00:00:00 | Combustivel | 55324 | 7540.8 | TLB 315 SL
 |  | 2021-01-06 00:00:00 | Combustivel | 55328 | 1018.35 | Gerador
 |  | 2021-01-06 00:00:00 | Combustivel | 55328 | 339.45 | [NAME]
 |  | 2021-01-06 00:00:00 | Combustivel | 55328 | 678.9 | Saltitao
 |  | 2021-01-19 00:00:00 | Combustivel | 55428 | 1018.35 | Gerador
 |  | 2021-01-19 00:00:00 | Combustivel | 55428 | 339.45 | [NAME]
 |  | 2021-01-19 00:00:00 | Combustivel | 55428 | 339.45 | Vibrador
 |  | 2021-01-19 00:00:00 | Combustivel | 55428 | 339.45 | [NAME]
 |  | 2021-02-16 00:00:00 | Combustivel | 55610 | 7540.8 | TLB 315 SL
Spreadsheet: 770151d1645830861-sums-of-dynamic-unique-values-with-multiple-criteria-sample-tests
Sheet: Calculation

 | Selected Information (Form Controls) |  |  |  |  |  |  |  |  |  |  | Calculation for scrolling table
 |  | Selected Type | 1
 |  | Selected Year | 1 |  |  |  |  |  |  |  |  |  | Bug
 |  | Selected Bug | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Type
 |  |  |  |  |  |  |  |  |  |  |  |  | Year
 | For Drop_down selections |  | 7 |  |  | Types data |  |  |  |  |  |  |  |  |  |  | difference from  previous year
 | Year | Type | Values |  |  |  | gram_positive |  |  |  |  | Nr. | Type | isolates_tested | isolates_susceptible | %susceptibility | Δ% susceptibility
 | 2018 | gram_negative | isolates_tested |  |  | Amikacin-Citrobacter freundii | Ampicillin-Enterococcus spp.
 | 2019 | gram_positive | isolates_susceptible |  |  | Amikacin-Klebsiella pneumoniae | Group A Strep-Penicillin
 | 2020 |  | %susceptibility |  |  | Amikacin-Proteus mirabilis | Group B Strep-Penicillin
 |  |  |  |  |  | [NAME] cloacae complex | Linezolid-MRSA
 |  |  |  |  |  | [NAME] morganii | Penicillin-Staphylococcus aureus
 |  |  |  |  |  | [NAME] coli | Linezolid-MSSA
 |  |  |  |  |  | Ertapenem-Acinetobacter baumannii | Penicillin-MRSA
 |  |  |  |  |  | Ertapenem-E. coli | Penicillin-MSSA
 |  |  |  |  |  | Tobramycin-Klebsiella aerogenes
 |  |  |  |  |  | Imipenem-Citrobacter freundii
 |  |  |  |  |  | Meripenem-Citrobacter freundii
 |  |  |  |  |  | Amikacin-E. coli
 |  |  |  |  |  |  |  |  |  |  |  |  | Calculations for headers
 |  |  |  |  |  |  |  |  |  |  |  |  | Hospital Numbers
 |  |  |  |  |  |  |  |  |  |  |  |  | isolate_hospital_n | `=sum of unique values  for each "type",  "year" and "bug" | *** one result from the data is that the isolates_hospital_n  sum for Citrobacter Freundii bug is 13 and not 39. and for MSSA is 66 and not 132.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | *** This should be 160. Different hospitals have exact  test numbers for the same bug and year. Check the blue cells in the data sheet.
Spreadsheet: 54382d1254359794-need-help-in-creating-a-lorenzo-curve-econhw2-1-
Sheet: Sheet1

 |  | Steffanie Sieber |  |  |  |  | Egypt
 |  |  | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008
 |  | Per Capita GNP ($US) | 1317 | 1423 | 1365 | 1205 | 1116 | 1041 | 1162 | 1367 | 1630 | 1997
 |  | Growth Rate | 4 | 3 | 2 | 0 | 1 | 2 | 3 | 5 | 5 | 5
 |  | GINI Index |  | 33 |  |  |  |  | 32
 |  | % of Population under Poverty Line | 1.81 |  |  |  |  | 1.99
 |  | Measure of Povity Gap % | 32.76 |  |  |  |  | 32.14
 |  |  |  | Lowest 20% | 2nd | 3rd | 4th | Richest 20%
 |  | Income Distribution in Quintiles % | 2000 | 9 | 12 | 16 | 21 | 42
 |  |  | 2005 | 9 | 13 | 16 | 21 | 41
 |  |  |  |  |  |  | Zambia
 |  |  | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008
 |  | Per Capita GNP ($US) | 307 | 309 | 339 | 339 | 390 | 473 | 610 | 888 | 927 | 1134
 |  | Growth Rate | -1 | 1 | 2 | 0 | 3 | 3 | 3 | 4 | 4 | 3
 |  | GINI Index |  |  |  | 42.08 |  | 50.74
 |  | % of Population under Poverty Line |  |  |  | 64.6 |  | 64.29
 |  | Measure of Poverty Gap % |  |  |  | 27.13 | 32.76
 |  |  |  | Lowest 20% | 2nd | 3rd | 4th | Richest 20% |  | Sources: | WDI
 |  | Income Distribution in Quintiles % | 2003 | 6 | 10 | 14 | 21 | 49 |  |  | PovcalNet
 |  |  | 2004 | 4 | 8 | 13 | 21 | 55
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 4 | 9
 |  |  |  |  |  |  |  | 20 | 12 | 22
 |  |  |  |  |  |  |  | 40 | 25 | 38
 |  |  |  |  |  |  |  | 60 | 45 | 59
 |  |  |  |  |  |  |  | 80 | 100 | 100
 |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0.2 | 4
 |  |  |  |  |  |  |  | 0.4 | 12
 |  |  |  |  |  |  |  | 0.6 | 25
 |  |  |  |  |  |  |  | 0.8 | 45
 |  |  |  |  |  |  |  | 1 | 100
Spreadsheet: 70725d1271425597-excel-2007-putting-cell-data-from-different-tabs-in-one-tab-on-the-right-line-vlookup-sample
Sheet: 2010

Client | Sales
A | 7101.67
S | 6577.08
D | 6677.15
C | 1338.9
F | 2270.34
V | 1051.32
T | 4843.45
G | 3153.02
B | 5202.21
H | 2482.14
U | 8849.53
J | 3538.63
I | 2178.3
Spreadsheet: 817467d1676257968-formula-for-generating-random-alphabet-letters-for-each-cell-in-a-26-cols-and-26-rows-table-formula-for-generating-random-alphabet-letters-for-each-cell-in-a-26-cols-and-26-rows-table
Sheet: A->Z (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] for generating random alphabet letters for each cell in a 26-cols & 26-rows table
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1399654-formula-for-generating-random-alphabet-letters-for-each-cell-in-a-26-cols-and-26-rows-table.html#post5790652
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1=CHAR(UNIQUE(RANDARRAY(1000,1,65,90,1)))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1=INDEX(A1#,IFERROR(1/(1/MOD(ROW(A1#)+7,26)),26))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CF formula: =SUM(COUNTIF(A1:C3,A1:C3))<>9, applies to =$A$1:$X$24, to check if neighbouring cells are of the same text
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B4 | C4 | D4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B5 | C5 | D5 | If [NAME]", adjacent cells (B4, [NAME], [NAME], C4, C6, D4, D5 & D6) must not be "I", "J" or "K"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B6 | C6 | D6
Spreadsheet: 866874d1713794956-drop-down-list-hides-used-items-drop-down-hides-used-items-aligw
Sheet: DDLists

Task 13 |  | Task 32
Task 14
Task 15
Task 16
Task 17
Task 18
Task 19
Task 21
Task 22
Task 23
Task 24
Task 25
Task 26
Task 27
Task 28
Task 29
Task 31
Task 33
Task 34
Task 35
Task 36
Task 37
Task 38
Task 39
Spreadsheet: 99493d1298107644-quick-vlookup-question-chargenhoe-copy
Sheet: Character Sheet Back

RANGED WEAPONS |  |  |  |  |  |  |  | MELEE WEAPONS
Weapon | Shots | RoF | Range | Damage |  |  |  | Weapon | Def | Damage
 |  |  |  |  |  |  |  | Big Club
Syker | <<Select Your Arcane Background         Arcane Abilities
Ability | Notes
Gear |  |  |  |  |  | Armor
Item | Qty | Cost | Total Cost |  |  | Type |  |  | AV | Protection
 |  |  |  |  |  | Gear Continued
 |  |  |  |  |  | Item |  |  | Qty. | Cost | Total
 | Section Total: |  |  |  |  |  |  |  | Gear Total:
Spreadsheet: 781938d1653653331-max-and-average-formulae-needed-if-conditions-met-in-other-cells-book1
Sheet: Sheet1

 | Status | Start date | ID | Name | Place | Details | Level | Required by | Given to | No of days | End date
 |  | 2022-05-01 00:00:00 |  |  |  |  | High
 |  | 2022-05-05 00:00:00 |  |  |  |  | Medium |  |  |  | 2022-05-25 00:00:00
 |  | 2022-05-06 00:00:00 |  |  |  |  | High
 |  | 2022-05-27 00:00:00 |  |  |  |  | High
Spreadsheet: e1bd90a3-97bf-48c3-95d3-bf5cc2ab4ac7
Sheet: 19

Uke: | 19 |  |  |  |  | Navn:
 |  | Mandag |  | Tirsdag |  | Onsdag |  | Torsdag |  | Fredag |  | Lørdag |  | Søndag |  | Sum
Kvalitet | Form | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | Trent | Diff. | Feedback
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
AKKUMULERT
Kvalitet | Form | Plan |  | Trent
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
Spreadsheet: vkaminski__40790__CASH_Elba_04112000wML
Sheet: Sensit041100

SENSITIVITIES TO ELBA ISLAND VALUE W/ MYSTIC LADY
April 11, 2000 10:15pm
 | STARTING CASE: |  |  |  | DIFFERENCE:
 | [NAME] | 9134.400743540366
 | O1: Yrs 6+ | 0 | 0.2
 | O2: Yrs 6+ | -21234.53031573904 | 0.2
 | O3: Yrs 6+ | 9841.118283936034 | 0.6
 | Probabilistic Outcome | 10792.16565075418
 | IF LOWER DISC RT BY 2%:
 | [NAME] | 9826.616290959093
 | O1: Yrs 6+ | 0 | 0.2
 | O2: Yrs 6+ | -26065.79199379226 | 0.2
 | O3: Yrs 6+ | 12128.40282649781 | 0.6
 | Probabilistic Outcome | 11890.49958809932
 | IF DECREASE BENEFIT PERCENTAGE TO LNG SUPPLIERS FROM 25% TO 12.5%:
 | [NAME] | 10747.17720465453
 | O1: Yrs 6+ | 0 | 0.2
 | O2: Yrs 6+ | -21234.53031573904 | 0.2
 | O3: Yrs 6+ | 11581.14806780574 | 0.6
 | Probabilistic Outcome | 13448.95998219017
 | IF INCREASE TERMINAL COST BY $1.5M FLAT & $1.5M ESC (APPRX $0.05/MMBTU) IF FULLY UTILIZED:
 | [NAME] | 3399.020599824456
 | O1: Yrs 6+ | 0 | 0.2
 | O2: Yrs 6+ | -26831.70065088656 | 0.2
 | O3: Yrs 6+ | 5617.467450808713 | 0.6
 | Probabilistic Outcome | 1403.160940132371
 | IF ELBA BASIS IS REALLY $0.02/MMBTU:
 | [NAME] | 9412.645973502826
 | O1: Yrs 6+ | 0 | 0.2
 | O2: Yrs 6+ | -21234.53031573904 | 0.2
 | O3: Yrs 6+ | 10066.66592989137 | 0.6
 | Probabilistic Outcome | 11205.73946828984
 | IF ELBA BASIS INCREASES TO $0.12/MMBTU FROM $0.02/MMBTU:
 | [NAME] | 16970.22074972286
 | O1: Yrs 6+ | 0 | 0.2
 | O2: Yrs 6+ | -21234.53031573904 | 0.2
 | O3: Yrs 6+ | 16192.89206551217 | 0.6
 | Probabilistic Outcome | 22439.04992588235
 | IF ARBITRAGE $0.10/MMBTU ON 91% CAPACITY:
 | [NAME] | 12769.07331764045
 | O1: Yrs 6+ | 0 | 0
 | O2: Yrs 6+ | -21234.53031573904 | 0
 | O3: Yrs 6+ | 8853.924925710051 | 1
 | Probabilistic Outcome | 21622.9982433505
 | IF ARBITRAGE $0.10/MMBTU ON 91% CAPACITY & REDUCE DISCOUNT RATE TO 12%:
 | [NAME] | 15688.24671597738
 | O1: Yrs 6+ | 0 | 0
 | O2: Yrs 6+ | -35909.84501329109 | 0
 | O3: Yrs 6+ | 14939.41292791092 | 1
 | Probabilistic Outcome | 30627.6596438883
 | IF ARBITRAGE $0.15/MMBTU ON 91% CAPACITY & REDUCE DISCOUNT RATE TO 12%:
 | [NAME] | 23778.02688559591
 | O1: Yrs 6+ | 0 | 0
 | O2: Yrs 6+ | -35909.84501329109 | 0
 | O3: Yrs 6+ | 22775.68711096562 | 1
 | Probabilistic Outcome | 46553.71399656154
Spreadsheet: 16999805-b912-41ed-b301-da6dbc40d3b0
Sheet: Sheet1

 | Ceiling Demo | [NAME]
North Perimeter Work | Start | Completion
Level 2 | 2011-11-07 00:00:00 | 2011-12-12 00:00:00
Level 9 | 2011-11-09 00:00:00 | 2011-12-19 00:00:00
Level 8 | 2028-11-21 00:00:00 | 2011-12-26 00:00:00
Level 7 | 2011-11-28 00:00:00 | 2012-01-02 00:00:00
Level 6 & part of 3 | 2011-12-06 00:00:00 | 2012-01-09 00:00:00
Elevator Work | Demo | Completion
Level 3 | Completed | 2011-12-07 00:00:00
Level 6 | Completed | 2011-12-15 00:00:00
Level 7 | Completed | TBD | It should be about 1 week following the other floors but it's not on my schedule.
Level 8 | Tonight | TBD
Level 9 | Completed | TBD
Spreadsheet: 109683d1306462962-how-to-insert-a-cell-reference-into-a-sumproduct-expression-copy-of-help-mockup
Sheet: REF Titles and Rates

 |  |  | This row seeks out the row # of the hours subtotal by task on "Detailed Estimate" sheet:
 | JOB TITLE
 |  | [NAME]
 |  |  |  | 01.01 | 01.02 | 01.03 | 01.04 | 01.05 | 02.01 | 02.02 | 02.03 | 02.04 | 02.05 | 03.01 | 03.02 | 03.03 | 03.04 | 03.05 | 04.01 | 04.02 | 04.03 | 04.04 | 04.05 | Totals
 | None Selected | 0
 | Title 1 | 90
 | Title 2 | 100
 | Title 3 | 110
 | Title 4 | 120
 | Title 5 | 130
 |  |  |  | Need help populating the blue fields via a sumproduct expression that incorporates the data in Row 3.
Spreadsheet: 151207d1334830416-can-i-sort-horizontally-some-how-when-i-have-merged-cells-horizontal-sort
Sheet: Sheet2

 | 1 | 2 | 3 | 4 | 9 | 10 | 11 | 12 | 5 | 6 | 7 | 8 | 13 | 14 | 15 | 16
Spreadsheet: 115473d1311083523-using-vlookup-and-choose-functions-together-copy-of-vlookup-and-choose
Sheet: Week 3

 | City | Mon | Tue | Wed | Thu | Fri
 | Cardiff | 0.06314278667911388 | 0.8421598427641461 | 0.9594370056860568 | 0.04111069239442888 | 0.2892607457175842
 | Dublin | 0.4475183722376253 | 0.7429219215326583 | 0.4091774355891999 | 0.4359228032212187 | 0.02262749168141953
 | Edinburgh | 0.6898738534767421 | 0.6417349095665896 | 0.7303156916718834 | 0.7055818133277336 | 0.6251394211193695
 | [NAME] | 0.08995295755860644 | 0.5766091666793156 | 0.1014525284763954 | 0.1510935877740023 | 0.7538885822816184
 | London | 0.579818087992158 | 0.9745818644830457 | 0.5198822171738604 | 0.004307968151631592 | 0.6393231830738368
 | [NAME] | 0.4969770186836047 | 0.4933597036980637 | 0.4572123035030748 | 0.5513945509931273 | 0.6535322337390279
 | [NAME] | 0.6941669700052051 | 0.9241913084176769 | 0.120223283200124 | 0.3034221460424804 | 0.3366349755774404
 | Swansea | 0.543584417226584 | 0.8437361019669307 | 0.9237992474393613 | 0.8541607241877038 | 0.4624419950844301
Spreadsheet: 80011d1280254651-use-indirect-pull-data-from-multiple-wbs-into-consolidating-ws-indirect-formula
Sheet:  List 

 |  |  |  | Dept | 3600 |  |  |  |  |  |  |  |  | F:\zDawn's Personal\Lessons for formulas\Indirect formula\[PU | Cover Sheet'!$E$10 | New Monitoring Value Datasheet'!$BL$30 | New Monitoring Value Datasheet'!$BH$30 | New Monitoring Units Datasheet'!$A$2
Client | Priority | Notes | Status | Project | BudRev | ActRev | NetBacklog | [NAME]'s Notes | Clinical | Medical | ECD PM | Addl comments |  |  | Name | Project Total | Project To Date | Errors |  | Project Value Check | July Revenue
h |  |  |  | 8216604 | 118303 | 113135 | 5168 | Complete | 135743 |  |  | done | 'F:\zDawn's Personal\Lessons for formulas\Indirect formula\[PU 8216604.xls]!' |  | 0 | 0 | 0 | 0 |  | 0 | 0
i |  |  |  | 7312129 | 105674 | 0 | 105674 | Complete |  |  |  |  | 'F:\zDawn's Personal\Lessons for formulas\Indirect formula\[PU 7312129.xls]!' |  | 0 | 0 | 0 | 0 |  | 0 | 0
Spreadsheet: 293833d1391102797-rent-utilites-and-loan-payments-book1
Sheet: Sheet1

Original Loan | 10000
Annual Interest Rate | 0.05
Original Loan Date | 2014-01-01 00:00:00
Date | Balance | Interest | Payments | Rent | Utilities | Balance
 |  |  | 300 | 400 | 150
 |  |  | 500 | 400 | 150
 |  |  | 600 | 400 | 125
 |  |  | 500 | 400 | 90
 |  |  | 1000 | 400 | 125
 |  |  | 300 | 400 | 65
 |  |  | 400 | 400 | 95
 |  |  | 700 | 400 | 60
Spreadsheet: a98b608d-7138-4085-8006-49cac0709522
Sheet: Detailed Revenue

The NASDAQ OMX Group, Inc.
Revenue Detail
(in millions)
(unaudited)
 |  |  |  | Three Months Ended
 |  |  |  | June 30, |  | March 31, |  | June 30,
 |  |  |  | 2012 |  | 2012 |  | 2011
MARKET SERVICES
 | Transaction Services
 | Cash Equity Trading Revenues:
 | U.S. cash equity trading |  |  | 373 |  | 340 |  | 387
 | Cost of revenues:
 | Transaction rebates |  |  | -246 |  | -235 |  | -258
 | Brokerage, clearance and exchange fees |  |  | -94 |  | -75 |  | -93
 | Total U.S. cash equity cost of revenues
 | Net U.S. cash equity trading revenues
 | European cash equity trading |  |  | 19 |  | 23 |  | 23
 | Total net cash equity trading revenues
 | Derivative Trading and Clearing Revenues:
 | U.S. derivative trading and clearing |  |  | 103 |  | 122 |  | 115
 | Cost of revenues:
 | Transaction rebates |  |  | -53 |  | -71 |  | -64
 | Brokerage, clearance and exchange fees |  |  | -6 |  | -9 |  | -7
 | Total U.S. derivative trading and clearing cost of revenues
 | Net U.S. derivative trading and clearing revenues
 | European derivative trading and clearing |  |  | 26 |  | 32 |  | 31
 | Total net derivative trading and clearing revenues
 | Access Services Revenues |  |  | 61 |  | 57 |  | 55
 | Total Transaction Services revenues less transaction
 | rebates, brokerage, clearance and exchange fees
 | Market Data Revenues:
 | Net U.S. tape plans |  |  | 31 |  | 31 |  | 30
 | U.S. market data products |  |  | 38 |  | 34 |  | 32
 | European market data products |  |  | 21 |  | 22 |  | 21
 | Total Market Data revenues
 | Broker Services Revenues |  |  | 5 |  | 5 |  | 4
 | Other Market Services Revenues |  |  | 11 |  | 0 |  | 1
 | Total Market Services revenues less transaction
 | rebates, brokerage, clearance and exchange fees
ISSUER SERVICES
Corporate Client Group: | Global Listing Services Revenues:
U.S. Operations: | Annual renewal |  |  | 28 |  | 28 |  | 29
 | Listing of additional shares |  |  | 10 |  | 10 |  | 10
 | Initial listing |  |  | 4 |  | 6 |  | 6
 | Total U.S. listing services
 | European listing fees |  |  | 12 |  | 12 |  | 15
 | Corporate Solutions |  |  | 22 |  | 20 |  | 19
 | Total Global Listing Services revenues
 | Global Index Group Revenues |  |  | 15 |  | 14 |  | 13
 | Total Issuer Services revenues
MARKET TECHNOLOGY
 | License, support and facility management |  |  | 26 |  | 29 |  | 30
 | Delivery project |  |  | 8 |  | 7 |  | 6
 | Change request, advisory and broker surveillance |  |  | 10 |  | 9 |  | 10
 | Total Market Technology revenues
Total revenues less transaction rebates, brokerage,
clearance and exchange fees