tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 804042d1667853658-ref-error-ref-error-example
Sheet: Part 3

Part 3 | Usage
December | 1
January | 1
February | 1
March | 1
April | 0
May | 0
June | 1
July | 1
August | 1
September | 1
October | 1
November | 1
Spreadsheet: 846625d1697766547-how-to-insert-blank-rows-but-by-using-formulas-rows
Sheet: Sheet1

Table 1 |  |  |  |  | Table 1
Order ID | Customer name | Product | Total price |  | Order ID | Customer name | Product | Total price |  | Helper
20191111 | [NAME] | [NAME] burger | 60 |  |  |  |  |  |  |  | 1
20191102 | [NAME] | Steak sandwich | 60 |  |  |  |  |  |  |  | 2
20191107 | [NAME] | Steak sandwich | 36 |  |  |  |  |  |  |  | 1
20191113 | [NAME] | Steak sandwich | 12 |  |  |  |  |  |  |  | 2
20191117 | [NAME] | Steak sandwich | 48 |  |  |  |  |  |  |  | 1
20191101 | [NAME] | Sausage sandwich | 108 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: john_lavorato__16475__alberta40117
Sheet: Tregion

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly Volatilities |  |  |  |  |  |  |  | Intra-Month Volatilties
 |  | PEAK |  |  |  | OFF-PEAK |  |  |  |  | Saturday |  |  |  | Sunday |  |  |  | Capacity |  |  |  | Peak |  |  |  | OffPeak |  |  |  | Peak |  |  |  | OffPeak |  |  | Group | Prudent |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Correlation
 | Bid | Mid | Offer |  | Bid | Mid | Offer |  |  | Bid | Mid | Offer |  | Bid | Mid | Offer |  | Bid | Mid | Offer |  | Bid | Mid | Offer |  | Bid | Mid | Offer |  | Bid | Mid | Offer |  | Bid | Mid | Offer |  | Code | Factor |  |  | Start | End |  |  |  |  |  |  |  |  |  |  |  |  |  | Gas-Power
 | (CAD$/MWH) | (CAD$/MWH) | (CAD$/MWH) |  | (CAD$/MWH) | (CAD$/MWH) | (CAD$/MWH) |  |  | (CAD$/MWH) | (CAD$/MWH) | (CAD$/MWH) |  | (CAD$/MWH) | (CAD$/MWH) | (CAD$/MWH) |  | (CAD$/KWM) | (CAD$/KWM) | (CAD$/KWM) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Peak
Month |  |  |  |  |  |  |  |  | Month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Daily Price Profile |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HR |  |  |  |  |  |  |  |  |  |  |  |  | P/OP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Volatility Smile |  |  | Price Sensitivies
Spreadsheet: phillip_m_love__30643__HS FT Ont Central
Sheet: Price Curves

Curve Code
CHIPPAWA | NG
CONSUMRS_CDA/FP | NGGJ
DAWN
NG
NGGJUS
NGGJ
NIAGARA
NIAGARA-GDM/FP
NGI-CTYGATE/FP
PARKWAY
GDM-DAWN/FP
GDM-NIAGARA/FP
GDM-WADD/FP
WADD-GDM/FP
SPUR
IROQUOIS/FP
UNION_CDA/FP
WADDINGTON
Spreadsheet: 716404d1612196803-keeping-track-of-a-trading-system-trades
Sheet: Trades

Count | Trade Price | Open/Close | Position | Not Closed | Closed
1 | 310.762 | O | 1
2 | 310.433 | C | 0
3 | 310.862 | O | 1
4 | 310.712 | C | 0
5 | 310.932 | O | 1
6 | 310.822 | C | 0
7 | 310.953 | O | 1
8 | 311.392 | O | 2
9 | 311.262 | C | 1
10 | 311.572 | O | 2
11 | 311.812 | O | 3
12 | 310.912 | C | 2
13 | 315.062 | O | 3
14 | 314.892 | C | 2
15 | 315.192 | O | 3
16 | 315.402 | O | 4
17 | 314.733 | C | 3
18 | 314.853 | C | 2
19 | 314.312 | O | 3
20 | 313.8 | C | 2
21 | 314.25 | O | 3
22 | 314.7 | O | 4
23 | 313.7 | C | 3
24 | 313.2 | C | 2
25 | 312.7 | C | 1
26 | 312.1 | C | 0
Spreadsheet: 162803d1340080225-excel-2007-how-to-fix-if-index-match-mjc-registro-interactivo
Sheet: TNSR

TOTAL DE  NOTAS DE LOS ESTUDIANTES SEGUNDO R
[NAME] |  |  |  |  | 1ER SEMESTRE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2DO SEMESTRE
 |  |  |  |  | PROYECTOS O EXAMENES |  |  |  | PUNTOS [NAME] SUMATIVAS |  |  |  |  |  |  |  |  |  |  |  |  | PROYECTOS O EXAMENES |  |  |  | PUNTOS [NAME] SUMATIVAS
NOMBRE DEL ALUMNO |  |  |  | [NAME] | 20 | 30 | 45 | 50 |  |  |  |  |  |  |  |  |  | RESUMEN 1ER SEM |  |  |  | 20 | 30 | 40 | 50 |  |  |  |  |  |  |  |  |  | RESUMEN 2DO SEM |  |  |  | TOTAL
 |  |  |  |  | A
Apellido 1ro |  | Apellido 2do | Nombre |  | N1 | N2 | N3 | N4 | SUMATIVA1 | SUMATIVA2 | SUMATIVA3 | [NAME] | SUMATIVA5 | SUMATIVA6 | SUMATIVA7 | SUMATIVA8 | SUMATIVA9 | [NAME] | [NAME] | [NAME] | NOTA | N5 | [NAME] | N7 | N8 | SUMATIVA10 | [NAME] | SUMATIVA12 | SUMATIVA13 | [NAME] | SUMATIVA15 | SUMATIVA16 | SUMATIVA17 | SUMATIVA18 | [NAME] | [NAME] | [NAME] | NOTA | [NAME] | [NAME] | [NAME] | NOTA |  |  | SEXO
 |  |  |  |  | 8 | 9 | 10 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 1 | 2 | 3
 |  |  |  | 1 | 15 | 25 | 44 | 49 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 10 | 5 | 14
 |  |  |  | 2 | 12 | 28 | 44 | 49
 |  |  |  | 3 | 13 | 30 | 29 | 30
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10
 |  |  |  | 11
 |  |  |  | 12
 |  |  |  | 13
 |  |  |  | 14
 |  |  |  | 15
 |  |  |  | 16
 |  |  |  | 17
 |  |  |  | 18
 |  |  |  | 19
 |  |  |  | 20
 |  |  |  | 21
 |  |  |  | 22
 |  |  |  | 23
 |  |  |  | 24
 |  |  |  | 25
 |  |  |  | 26
 |  |  |  | 27
 |  |  |  | 28
 |  |  |  | 29
 |  |  |  | 30
 |  |  |  | 31
 |  |  |  | 32
 |  |  |  | 33
 |  |  |  | 34
 |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a1 |  |  | d1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a2 |  |  | d2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | b1 |  |  | f1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | b2 |  |  | f2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c2
Spreadsheet: 67928d1268422724-method-for-posting-and-tracking-staffing-changes-kinikisu-staff
Sheet: Sheet2

Count of Date | Column Labels
 | Addison |  | Addison Total | Grand Total
Row Labels | 2010-01-01 00:00:00 | 2010-03-04 00:00:00
[NAME] | 1 |  | 1 | 1
[NAME] |  | 1 | 1 | 1
Grand Total | 1 | 1 | 2 | 2
Spreadsheet: 61399d1262213430-dependent-dropdowns-dependant-dropdown-problems-jogier505-sdg11
Sheet: Lookup

 | Division
 | Conference
 | Team
 |  |  |  |  | After you make your selections from the three drop down lists,
 |  |  |  |  | you could reset the three dependant lists with a VBA macro.
 |  |  |  |  | Otherwise, you have to reset the lists beginning
 |  |  |  |  | in the Team list (pick the blank entry at the top)
 |  |  |  |  | then in the Conference list (pick the blank entry at the top) |  |  |  |  |  |  |  |  |  | Today, 03:52 PM
 |  |  |  |  | then in the Division list (pick the blank entry at the top). |  |  |  |  |  |  |  |  |  | [NAME] |  | Dependant dropdown problems - Jogier505 - SDG11.xls
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Registered User   Join Date: 09 Sep 2009
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location: Columbus. Ohio
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MS Office Version:Excel 2000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Posts: 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dependant dropdown problems
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/712300-dependant-dropdown-problems.html
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I am trying to wrap my brain around dependant dropdowns and have hit a brick wall.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Using the [NAME] web site [url="http://www.contextures.com/xlDataVal02.html#TwoWord"]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I can get part of the problem to work but when I try to add a third dropdown i get lost.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Attached is a sample of the workbook.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thanks, [NAME]
Spreadsheet: 64132d1265016992-copy-formula-sheet-reference-invoice-template-monthly-copy
Sheet: 003

Arranged |  |  |  | Received |  | Job Number
Time
Customer |  |  | Site Address |  |  | Customer Order No
 |  |  |  |  |  | Customer Contact
 |  |  |  |  |  | Site Contact
 |  |  |  |  |  | Site Contact Number
 |  |  |  |  |  | Job Complete
Job Description (Detailed For Invoice)
Works Carried Out On Site (PLEASE DETAIL)
Labour
Date |  | Operative Initials |  | Hours |  | Mileage |  | Expenses
Qty | Material Descritpion |  |  |  |  | Supplier | Stock | Cost each | Total
 | mark N/A if material has not been used |  |  |  |  |  |  | £ | £
Any additional materials please mark PTO and detail on the reverse of this sheet
Invoice No -
Terms |  | Days |  | Your Ref
 |  |  |  | Customer Contact
Date |  |  |  | Job Complete
Site
Description
QTY |  | COST BREAKDOWN |  |  |  |  |  | UNIT COST | TOTAL COST
 |  | A statement will not be issued, please pay on invoice
VAT NUMBER - 886 3072 95 |  |  |  | VAT |  |  |  | SUB TOTAL
Please note : Unless stated otherwise on this invoice, payment needs to reach us within the specified terms as detailed above. All goods shall remain the property of Pulse Electrical (Dundee) Ltd, until all payment has been received in full. |  |  |  |  |  |  |  | VAT
 |  |  |  |  |  |  |  | TOTAL
To Pay By [NAME] |  | Bank Account Number |  |  |  | Sort Code
Please use our invoice number above as the payment reference
Labour Costs
[NAME] |  |  |  |  |  |  | Job Number
Week No | Hours | Journeyman | Mileage | Expenses | Rate | Total
Total
Apprentice Hours
Week No | Hours | Apprentice | Mileage | Expenses | Rate | Total
Total
Plant |  |  |  |  |  |  | Job No
Wholesaler | Qty | Pink copy no | Description |  |  | cost excl vat |  | [NAME] % | Total
Total Plant Cost Transferred
Material Costs
Stock materials to be detailed stock in wholesaler column
Wholesaler | Qty | Pink copy no | Description |  |  | cost excl vat |  | [NAME] % | Total
Total Material Cost Transferred
Spreadsheet: 801857d1666437487-how-do-i-apply-rows-of-many-formulas-to-a-list-of-many-words-phrases-and-cities_jt-1-
Sheet: Sheet1

 |  |  | london
 |  |  | berlin |  | restaurant in london
 |  |  | tokyo |  | fine dining london
 |  |  | munich |  | london cuisine
 | Bistro in city |  | madrid |  | Bistro in london
 | [NAME] in city |  | lisbon |  | [NAME] in london
 |  |  | jakarta |  | berlin  restaurant
 |  |  | barcelona |  | restaurant in berlin
 |  |  | New York |  | fine dining berlin
 |  |  | Sitges |  | berlin cuisine
 |  |  |  |  | Bistro in berlin
 |  |  |  |  | [NAME] in berlin
 |  |  |  |  | tokyo  restaurant
 |  |  |  |  | restaurant in tokyo
 |  |  |  |  | fine dining tokyo
 |  |  |  |  | tokyo cuisine
 |  |  |  |  | Bistro in tokyo
 |  |  |  |  | [NAME] in tokyo
 |  |  |  |  | [NAME]
 |  |  |  |  | restaurant in munich
 |  |  |  |  | fine dining munich
 |  |  |  |  | [NAME]
 |  |  |  |  | Bistro in munich
 |  |  |  |  | [NAME] in munich
 |  |  |  |  | madrid  restaurant
 |  |  |  |  | restaurant in madrid
 |  |  |  |  | fine dining madrid
 |  |  |  |  | madrid cuisine
 |  |  |  |  | Bistro in madrid
 |  |  |  |  | [NAME] in madrid
 |  |  |  |  | [NAME]
 |  |  |  |  | restaurant in lisbon
 |  |  |  |  | fine dining lisbon
 |  |  |  |  | [NAME]
 |  |  |  |  | Bistro in lisbon
 |  |  |  |  | [NAME] in lisbon
 |  |  |  |  | jakarta  restaurant
 |  |  |  |  | restaurant in jakarta
 |  |  |  |  | fine dining jakarta
 |  |  |  |  | jakarta cuisine
 |  |  |  |  | Bistro in jakarta
 |  |  |  |  | [NAME] in jakarta
 |  |  |  |  | barcelona  restaurant
 |  |  |  |  | restaurant in barcelona
 |  |  |  |  | fine dining barcelona
 |  |  |  |  | [NAME]
 |  |  |  |  | Bistro in barcelona
 |  |  |  |  | [NAME] in barcelona
 |  |  |  |  | New York  restaurant
 |  |  |  |  | restaurant in New York
 |  |  |  |  | fine dining New York
 |  |  |  |  | New York cuisine
 |  |  |  |  | Bistro in New York
 |  |  |  |  | Eguski Izarra in New York
 |  |  |  |  | Sitges  restaurant
 |  |  |  |  | restaurant in Sitges
 |  |  |  |  | fine dining Sitges
 |  |  |  |  | Sitges cuisine
 |  |  |  |  | Bistro in Sitges
 |  |  |  |  | [NAME] in Sitges
Spreadsheet: 39759d1238038485-how-to-look-up-value-in-pivot-table-using-row-and-columns-josh-budget
Sheet: Pivot

Categorized Expenditures | Year and Month
 | 2009
Category | 3 | 4 | 5
Fun | 22 | 30
Groceries | 95 | 45
Insurance | 75
Restaurant | 30 | 50
Rent |  |  | 1000
Grand Total | 222 | 125 | 1000
Spreadsheet: 68030d1268593035-generate-list-of-possible-combinations-721700-combinations
Sheet: Sheet1

Cum: | 36 | 4 | [NAME] columns to left as needed
Count: | 9 | 4
 | Voltage | [NAME]
 | 0 | 0 | Add items as needed, no interspersed blanks
 | 0.125 | 0.3333333333333333
 | 0.25 | 0.6666666666666666
 | 0.375 | 1
 | 0.5
 | 0.625
 | 0.75
 | 0.875
 | 1
# | Permutations |  | [NAME] rows above as needed
1 | 0 | 0 | 0
2 | 0 | 0.3333333333333333 | 0.3333333333333333
3 | 0 | 0.6666666666666666 | 0.6666666666666666
4 | 0 | 1 | 1
5 | 0.125 | 0 | 0.125
6 | 0.125 | 0.3333333333333333 | 0.4583333333333333
7 | 0.125 | 0.6666666666666666 | 0.7916666666666666
8 | 0.125 | 1 | 1.125
9 | 0.25 | 0 | 0.25
10 | 0.25 | 0.3333333333333333 | 0.5833333333333333
11 | 0.25 | 0.6666666666666666 | 0.9166666666666666
12 | 0.25 | 1 | 1.25
13 | 0.375 | 0 | 0.375
14 | 0.375 | 0.3333333333333333 | 0.7083333333333333
15 | 0.375 | 0.6666666666666666 | 1.041666666666667
16 | 0.375 | 1 | 1.375
17 | 0.5 | 0 | 0.5
18 | 0.5 | 0.3333333333333333 | 0.8333333333333333
19 | 0.5 | 0.6666666666666666 | 1.166666666666667
20 | 0.5 | 1 | 1.5
21 | 0.625 | 0 | 0.625
22 | 0.625 | 0.3333333333333333 | 0.9583333333333333
23 | 0.625 | 0.6666666666666666 | 1.291666666666667
24 | 0.625 | 1 | 1.625
25 | 0.75 | 0 | 0.75
Spreadsheet: 0d71e578-1722-406e-837b-72b411de5507
Sheet: 50bracket

ISA WINTER NATIONAL
[NAME]
50M & 50AAA BRACKETS
ALL GAMES AT DIAMOND PLEX
50 MAJOR BRACKET
S1
SATURDAY
4PM  B | (1
[NAME] |  | SUNDAY
 |  | 9AM  B | (3
S2
SATURDAY
4PM  C | (2
S3 |  |  |  | 1:30PM  B | (6
LOSER'S BRACKET |  |  |  |  |  | 3PM  B
 |  | L3 |  |  |  | IF GAME
 |  | SUNDAY |  |  |  |  | (7
L1 |  | NOON  B | (5
SUNDAY
10:30AM  B | (4
L2
 |  |  |  |  |  | L6
 |  |  |  |  |  | LOSER OF 6
 |  |  |  |  |  | IF 1ST LOSS
50 AAA - BEST 2 OUT OF 3
ALL GAMES ON SUNDAY ON DIAMOND E
9AM - GAME #1 - FREEDOM RANCH_______ V  CROSS CUT_________
10:30AM - GAME #2 - FREEDOM RANCH_________  V  CROSS CUT___________
NOON - IF GAME -  FREEDOM RANCH_________  V  CROSS CUT____________
Spreadsheet: 719412d1613658654-help-automatically-adding-value-based-on-previous-column-for-a-form-form_test1
Sheet: DataSelections

Item Description | Cost
ItemA | 10
ItemB | 20
ItemC | 1
ItemD | 3
ItemE | 5
ItemF | 9
ItemG | 2
ItemH | 3.4
ItemI | 2.25
ItemJ | 2.9
ItemK | 5.6
ItemL | 1.25
ItemM | 5.64
ItemN | 5.74
ItemO | 5.62
ItemP | 2
Spreadsheet: 762421d1641552591-formula-for-dashes-between-the-text-example
Sheet: Total Paid Amount

CPR No
IT2021061701011379530
IT2020031300551196951
IT2020031300551196951
IT2020031300551196951
IT2020061610561212126
IT2020100801011129701
IT2020100801011129703
IT2020111201011184670
IT2020111201011184670
IT2020111201011184670
IT2021031601011481393
IT2021031601011481393
IT2021031601011481393
IT2021041701011325038
IT2021052001011215010
IT2021052001011216958
IT2021061001011206037
IT2021063001011663713
IT2021080401011059222
IT2021090901011166932
IT2021090901011166910 | IT-[PHONE]-1166910
Spreadsheet: mary_fischer__25610__32D-2001
Sheet: E11.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032D
COMPANY NAME  Enron Building Services, Inc.
ANALYSIS OF OTHER CURRENT LIABILITIES
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-11
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Advanced billings |  | 10407261
Accrued payroll clearing |  | -48470 |  | 48470 |  |  |  | 0
Total Other Current Liabilities
(must tie to Hyperion account 655) | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Income Accts:  DR/(CR)
Reverse signs from Hyperion
Spreadsheet: 152915d1335593459-how-to-merge-to-columns-into-one-putting-them-into-every-other-cell-book1_ntnu-trykk-2-
Sheet: Sheet1

Username | Password |  | User/Password | *now blank*
ABC1 | 123 |  | ABC1
[NAME] | 124 |  | 123
ABC3 | 125 |  | [NAME]
[NAME] | 126 |  | 124
ABC5 | 127 |  | ABC3
ABC6 | 128 |  | 125
ABC7 | 129 |  | [NAME]
ABC8 | 130 |  | 126
ABC9 | 131 |  | ABC5
ABC10 | 132 |  | 127
ABC11 | 133 |  | ABC6
ABC12 | 134 |  | 128
ABC13 | 135 |  | ABC7
ABC14 | 136 |  | 129
ABC15 | 137 |  | ABC8
ABC16 | 138 |  | 130
ABC17 | 139 |  | ABC9
ABC18 | 140 |  | 131
ABC19 | 141 |  | ABC10
ABC20 | 142 |  | 132
 |  |  | ABC11
 |  |  | 133
 |  |  | ABC12
 |  |  | 134
 |  |  | ABC13
 |  |  | 135
 |  |  | ABC14
 |  |  | 136
 |  |  | ABC15
 |  |  | 137
 |  |  | ABC16
 |  |  | 138
 |  |  | ABC17
 |  |  | 139
 |  |  | ABC18
 |  |  | 140
 |  |  | ABC19
 |  |  | 141
 |  |  | ABC20
 |  |  | 142
Spreadsheet: 114950d1310610297-using-a-formula-in-data-validation-sample1211
Sheet: Sheet2

GENRE | TITLE | AUTHOR |  |  |  |  |  |  |  | Fiction
Fiction | 11111 | [NAME] |  |  |  |  |  |  |  | Childrens
Fiction | 22222 | bob b |  |  |  |  |  |  |  | Romance
Fiction | 33333 | [NAME]
Fiction | 44444 | [NAME]
Fiction | 55555 | [NAME]
Fiction | 66666 | glenn l
Fiction | 77777 | fred
Childrens | ssss | alice
Childrens | [NAME] | jean
Childrens | eeee | siliva
Childrens | [NAME] | [NAME]
Childrens | [NAME] | [NAME]
Childrens | rrrrrr | derik
Childrens | uuuuuu | [NAME]
Childrens | qqqqqq | blue
Childrens | wqwqwq | [NAME]
Childrens | ergeegeg | [NAME]
Romance | 121qqq | carman
Romance | 122www | sergio
Romance | 123eee | goliath
Romance | 124rrr | [NAME]
Romance | 125ttt | maria
Romance | 126yyy | teresa
Romance | 127uuu | [NAME]
Romance | 128iii | chritina
Spreadsheet: 37684d1235713509-statement-of-account-calculating-interest-interest-on-overdue
Sheet: Sheet1

Interest Calculation As on |  | 2009-02-27 00:00:00
Unpaid Invoice Amount | Date of Issue | Due Date considering 30 days period | Delay | Interest Rate per annum | Interest
15000 | 2008-12-15 00:00:00 | 2009-01-14 00:00:00 | 44 | 0.12 | 217
25000 | 2009-01-15 00:00:00 | 2009-02-14 00:00:00 | 13 | 0.12 | 107
35000 | 2009-02-15 00:00:00 | 2009-03-17 00:00:00 | 0 | 0.12 | 0
85000 | 2009-01-28 00:00:00 | 2009-02-27 00:00:00 | 0 | 0.12 | 0
Spreadsheet: 185071d1349466871-scroll-down-automatically-in-shared-workbook-shared-2
Sheet: Pilot Profile

Pilot | Will be leaving @ | Load Team | Type | Reg | Wing (H/L) | Passenger Load | Team #
[NAME] | 0 |  | C 177 | N30033 | Low | 400 | Alpha
[NAME] | 0 | LL+2 | C-172 | N3904F | High | 400 | Bravo
Daly | 0 | 0 | C-172 | N4318R | High | 400 | [NAME]
Talman | 0 | 0 | P28 | N9106Y | Low | 400 | Delta
Elson | 0 | LL | C 177 | 1597H | High | 400 | Echo
Berry | 0 | 0 | C172 | N80847 | High | 400 | Foxtrot
Blackbourn | 0 | 0 | C172 S | N1152Z | High | 400 | Gulf
Lindley | 0 | 0 | C182 | N52907 | High | 450 | Hotel
GORMLEY | 0 | LL+2 | C 182 | N182GF | High | 450 | India
Polvka | 0 |  | C182 | N2608R | High | 460 | [NAME]
Pratzman | 0 | 0 | C182 | N182VM | High | 460 | Kilo
Spoor | 0 | 0 | Maule | N9234N | High | 550 | Lima
[NAME] | 0 | 0 | SR 20 | N878EA | Low | 700 | [NAME]
Newman | 0 | 0 | SR20 | N937CD | Low | 716 | November
Desmon | 0 | LL | L17 | N4591K | Low | 720 | [NAME]
MARKS | 0 | 0 | C T210L | N2122S | High | 800 | Papa
Gyuro | 0 | LL | C 205 | N1835Z | High | 800 | Quebec
0 | 0 | 0 | 0 | 0 | 0 | 0 | Romeo
 |  |  |  |  |  |  | Sierra
 |  |  |  |  |  |  | Tango
 |  |  |  |  |  |  | Uniform
 |  |  |  |  |  |  | Victor
 |  |  |  |  |  |  | Whiskey
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Yankee
 |  |  |  |  |  |  | Zulu
 |  |  |  |  |  |  | AA
 |  |  |  |  |  |  | AB
 |  |  |  |  |  |  | AC
 |  |  |  |  |  |  | AD
 |  |  |  |  |  |  | AE
 |  |  |  |  |  |  | AF
Spreadsheet: 795430d1662671838-how-to-lookup-with-wildcards-in-the-lookup_value-not-_array-example-of-wildcard-with-lookup
Sheet: Sheet1

[NAME] | Assigned Modifications | formula | correct output
QHLPLIK[585.3087]M[15.9949]KPVPDLVPGN[0.9840]FK | 18N(0.9840), 7K(585.3087), 8M(15.9949) |  | hFIBA_Q240
Q[-17.0265]HLPLIK[585.3087]M[15.9949]KPVPDLVPGNFK | 1Q(-17.0265), 7K(585.3087), 8M(15.9949) | above wildcard vlookup - fail | hFIBA_Q240
Q[-17.0265]HLPLIKM[15.9949]KPVPDLVPGNFK | 1Q(-17.0265), 8M(15.9949)
Q[0.9840]H[15.9949]LPLIK[585.3087]MKPVPDLVPGNFK | 1Q(0.9840), 2H(15.9949), 7K(585.3087) |  | hFIBA_Q240
Q[0.9840]HLPLIK[585.3087]MKPVPDLVPGNFK | 1Q(0.9840), 7K(585.3087) | above wildcard [NAME] | hFIBA_Q240
QH[15.9949]LPLIK[1044.4731]M[15.9949]KPVPDLVPGNFK | 2H(15.9949), 7K(1044.4731), 8M(15.9949) |  | hFIBA_Q256
QH[15.9949]LPLIK[585.3087]M[15.9949]KPVPDLVPGNFK | 2H(15.9949), 7K(585.3087), 8M(15.9949) |  | hFIBA_Q240
QHLPLIK[585.3087]MK | 7K(585.3087) |  | hFIBA_Q240
QHLPLIK[585.3087]MKPVPDLVPGNFK | 7K(585.3087) |  | hFIBA_Q240
QHLPLIK[585.3087]M[15.9949]K | 7K(585.3087), 8M(15.9949) |  | hFIBA_Q240
QHLPLIK[585.3087]M[15.9949]KPVPDLVPGNFK | 7K(585.3087), 8M(15.9949) |  | hFIBA_Q240
[NAME] | 8M(15.9949)
QHLPLIKM[15.9949]K[585.3087]PVPDLVPGNFK | 8M(15.9949), 9K(585.3087) |  | hFIBA_Q240
MKPVPDLVPGN[0.9840]FK | 11N(0.9840)
MKPVPDLVPGN[0.9840]FKSQLQK | 11N(0.9840)
M[15.9949]KPVPDLVPGN[0.9840]FKSQ[0.9840]LQK | 11N(0.9840), 15Q(0.9840), 1M(15.9949)
[NAME] | 11N(0.9840), 1M(15.9949)
M[15.9949]KPVPDLVPGN[0.9840]FKSQLQK | 11N(0.9840), 1M(15.9949)
M[15.9949]KPVPDLVPGNFK[1044.4731]SQLQK | 13K(1044.4731), 1M(15.9949) |  | hFIBA_Q256
M[15.9949]KPVPDLVPGNFK[585.3087] | 13K(585.3087), 1M(15.9949) |  | hFIBA_Q240
M[15.9949]KPVPDLVPGNFK[585.3087]SQLQK | 13K(585.3087), 1M(15.9949) |  | hFIBA_Q240
M[15.9949]KPVPDLVPGNFKSQ[0.9840]LQK | 15Q(0.9840), 1M(15.9949)
lookup table
585.3087 | hFIBA_Q240 | Q221 |  |  |  |  |  | 585.3087
1044.473237 | hFIBA_Q256 | Q237 |  |  |  |  |  | 1044.473237
Spreadsheet: 888653d1739222042-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 9

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sat 1 Jul Glucose mmol/L
 |  |  |  |  | 7.1
Sun 2 Jul Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Mon 3 Jul Glucose mmol/L
 |  |  |  |  |  | 6.2
Tue 4 Jul Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Wed 5 Jul Glucose mmol/L
 |  |  |  |  |  | 6.2
Thu 6 Jul Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Fri 7 Jul Glucose mmol/L
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Sat 8 Jul Glucose mmol/L