tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: d812f1e4-611d-4181-8e65-0f7866213bac
Sheet: Sheet1

ÑAÏI HOÏC QUOÁC GIA TPHCM | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | COÄNG HOØA XAÕ HOÄI CHUÛ NGHÓA VIEÄT NAM | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
ÑAÏI HOÏC KHOA HOÏC TÖÏ NHIEÂN |  |  |  |  | ÑOÄC LAÄP - TÖÏ DO - HAÏNH PHUÙC
DANH SAÙCH THÍ SINH ÑÖÔÏC TUYEÅN THAÚNG
HEÄ VÖØA LAØM VÖØA HOÏC NGAØNH COÂNG NGHEÄ THOÂNG TIN
KHOÙA 2010 (K14) -  NAÊM HOÏC 2010-2011
STT | MHS | NH | [NAME] | TEÂN | NGAØY SINH | NÔI SINH | VAÊN BAÈNG |  |  |  | Ghi Chuù
 |  |  |  |  |  |  | ÑH | CÑ | Tröôøng caáp | ngaønh
1 | 1 |  | Cao Vaên | Laâm | 1982-06-10 00:00:00 | TPHCM | x |  | ÑH An ninh ND | [NAME] tra toäi phaïm
2 | 2 |  | [NAME] | Linh | 1986-08-16 00:00:00 | TPHCM | x |  | ÑH Toân Ñöùc Thaéng | [NAME] döïng DD&CN
3 | 3 |  | [NAME] | Thieän | 1986-10-26 00:00:00 | TPHCM | x |  | ÑH KHTN | [NAME]
4 | 4 |  | [NAME] | Nam | 1985-06-27 00:00:00 | Long An | x |  | ÑH [NAME] | Luaät
5 | 5 |  | Huyønh Minh | Khoa | 1987-08-20 00:00:00 | TPHCM | x |  | ÑH [NAME] | Luaät
6 | 6 |  | [NAME] | Vuõ | 1979-12-03 00:00:00 | TPHCM | x |  | ÑH KT | [NAME]
7 | 7 |  | Thaùi Thuïy Thanh | Taâm | 1979-08-14 00:00:00 | TPHCM | x |  | ÑHKT | QTKD, T Chöùc
8 | 8 |  | [NAME] | Tuøng | 1982-08-20 00:00:00 | TPHCM | x |  | ÑHKT | Taøi chính NH, T Chöùc
9 | 9 |  | Ñaëng Thy | Hoøa | 1986-04-07 00:00:00 | TPHCM | x |  | ÑH KHTN | Ñòa Chaát
10 | 10 |  | [NAME] | Baûo | 1980-01-05 00:00:00 | TPHCM | x |  | ÑHKT | QTKD, T Chöùc
11 | 11 |  | Ñaøo Anh | Ban | 1987-10-15 00:00:00 | TPHCM | x |  | ÑHCNSG | QTKD, Lieân thoâng
12 | 12 |  | [NAME] | Sôn | 1985-02-17 00:00:00 | Long An | x |  | ÑH KHTN | [NAME]
Toång coäng : 12 thí sinh |  |  |  |  | TPHCM , ngaøy 28 thaùng 10 naêm 2010
 |  |  |  |  | CHỦ TỊCH HỘI ĐỒNG TUYỂN SINH
LÖU YÙ :
Tröôøng seõ gôûi [NAME] hoïc theo ñòa chæ baùo tin
Ngaøy noäp hoà sô nhaäp hoïc : 9/12/2010 taïi phoøng Ñaøo taïo
Spreadsheet: 153457d1335916487-auto-sort-values-drawn-from-a-vlookup-table-into-ascending-order-sorted-example
Sheet: Sort

 | X | Y | unique rank |  |  | X | Y
NJ | 0.4141129714107488 | 36 | 4 |  | Tor | 0.4082945997171938 | 23
Hou | 0.5346784547152194 | -11 | 16 |  | Cha | 0.4086588162660472 | 6
[NAME] | 0.5824151019675501 | 8 | 18 |  | NJ | 0.4141129714107488 | 36
Chi | 0.5307337384377362 | -2 | 15 |  | NJ | 0.4141129714107488 | 36
Cha | 0.4086588162660472 | 6 | 2 |  | NO | 0.4319737213932251 | 22
NJ | 0.4141129714107488 | 36 | 3 |  | [NAME] | 0.4502741585543951 | 2
Ind | 0.5185801965749602 | -12 | 10 |  | [NAME] | 0.4623480392349345 | 6
Phi | 0.5187353113032686 | -14 | 11 |  | NY | 0.4661486876370821 | -17
Mil | 0.4996112879733603 | 5 | 9 |  | Mil | 0.4996112879733603 | 5
SA | 0.5645287340138865 | -22 | 17 |  | Ind | 0.5185801965749602 | -12
[NAME] | 0.4623480392349345 | 6 | 7 |  | Phi | 0.5187353113032686 | -14
NO | 0.4319737213932251 | 22 | 5 |  | Orl | 0.5195090607139831 | 2
Tor | 0.4082945997171938 | 23 | 1 |  | Por | 0.5264521796059863 | -20
Orl | 0.5195090607139831 | 2 | 12 |  | Chi | 0.5307337384377362 | -2
LAL | 0.5830781964115567 | -8 | 19 |  | Chi | 0.5307337384377362 | -2
[NAME] | 0.4502741585543951 | 2 | 6 |  | Hou | 0.5346784547152194 | -11
Por | 0.5264521796059863 | -20 | 13 |  | SA | 0.5645287340138865 | -22
Chi | 0.5307337384377362 | -2 | 14 |  | [NAME] | 0.5824151019675501 | 8
NY | 0.4661486876370821 | -17 | 8 |  | LAL | 0.5830781964115567 | -8
Spreadsheet: 868237d1714985056-tier-incentive-will-be-automatically-calculated-based-on-tier-hani-calculation-
Sheet: Dr. Sultan Khalaf

Contract Terms (*)
 |  | Description | Commission
 |  | Consultation after deducting 5% Admin | 0.55
 |  | Procedure in Clinics after deducting consumables and 5% Admin | 0.55
 |  | OR in Clinics from Gross | 0.42
 |  | OR outside Clinics after hospital expenses and 5% Admin | 0.65
Doctor Calculation
 |  | Consultation Revenue | -350
 |  | [NAME] fee 5%
 |  | Net Revenue
 |  | Amount to be paid
 |  | Procedure in the Clinics Revenue | 0
 |  | Consumables
 |  | [NAME] fee 5%
 |  | Net Revenue
 |  | Amount to be paid
 |  | OR in the Clinics Revenue | 0
 |  | OR Fees (NOT DEDUCTABLE) | 0
 |  | Consumables (Implants) | 0
 |  | Net Revenue
 |  | Amount to be paid
 |  | OR outside the Clinics Revenue | 0
 |  | Hospital Fees | 0
 |  | [NAME] fee 5%
 |  | Net Revenue
 |  | Amount to be paid
 |  | Total Amount to be Paid
Prepared By …................. |  |  |  | Sr. Finance Manager |  | .......................
 |  |  |  |  |  |  | Operations Report on Feb - 2020
 |  |  |  |  |  |  | # | Day/Date | Time | Patient Name and file number |  | [NAME] | Surgeon | Anesthesia | Amount
 |  |  |  |  |  |  | 1 | Saturday 01-02-2020 | At 1:50 pm he tooks         2 hrs & 50 mins | Razan Alslamha 10056368 |  | Rhinoplasty | Dr Sultan | GA
Spreadsheet: kate_symes__18691__New Notification Report 0101
Sheet: Mar 2001

 |  |  |  | Notes: | All Dates Are in mm/dd/yy format
MARCH 2001 |  |  |  |  | N/C = No Change
 |  |  |  |  | See "Changes"  Worksheet for short list of new changes
 |  | Former Counterparty Data |  |  |  |  | Updated Counterparty Data |  |  |  |  | GCP Updated On |  |  |  | [NAME] Use Only
Change Type | Legal Eff. Date | Name | BA ID | CP ID | Short Name | Inactivation Date | Name | BA ID | CP ID | Short Name | Comments | Name | Shortname | Inactivation |  | Notification Date
Name Overlay | 2000-12-01 00:00:00 | ECR Energy, LLC | 74072 | 74172 | ECRENELLC | N/A | Northland Energy Trading, LLC | N/C | N/C | NORTHLANENETRA | Have recorded LLC Certificate of Amendment in hand. | 2001-02-22 00:00:00 | 2001-02-23 00:00:00 | N/A |  | 2001-02-22 00:00:00
Spreadsheet: joe_quenet__15082__PJM
Sheet: DJ PJM Electricity Index

 | DATE |  |  |  | Firm On Peak |  | MW |  | [NAME]
 | 2001-10-24 00:00:00 |  |  |  | 26.31 |  | 1950 |  | 31200
 | 2001-10-23 00:00:00 |  |  |  | 24.48 |  | 2150 |  | 34400
 | 2001-10-22 00:00:00 |  |  |  | 25.31 |  | 1350 |  | 21600
 | 2001-10-21 00:00:00
 | 2001-10-20 00:00:00
 | 2001-10-19 00:00:00 |  |  |  | 25.5 |  | 1250 |  | 20000
 | 2001-10-18 00:00:00 |  |  |  | 26.93 |  | 2600 |  | 41600
 | 2001-10-17 00:00:00 |  |  |  | 25.28 |  | 2750 |  | 44000
 | 2001-10-16 00:00:00 |  |  |  | 26.48 |  | 900 |  | 14400
 | 2001-10-15 00:00:00 |  |  |  | 26.31 |  | 1050 |  | 16800
 | 2001-10-14 00:00:00
 | 2001-10-13 00:00:00
 | 2001-10-12 00:00:00 |  |  |  | 23.51 |  | 2100 |  | 33600
 | 2001-10-11 00:00:00 |  |  |  | 23.98 |  | 1350 |  | 21600
 | 2001-10-10 00:00:00 |  |  |  | 25.31 |  | 1800 |  | 28800
 | 2001-10-09 00:00:00 |  |  |  | 28.25 |  | 1800 |  | 28800
 | 2001-10-08 00:00:00 |  |  |  | 29.17 |  | 3850 |  | 61600
 | 2001-10-07 00:00:00
 | 2001-10-06 00:00:00
 | 2001-10-05 00:00:00 |  |  |  | 28.6 |  | 1950 |  | 31200
 | 2001-10-04 00:00:00 |  |  |  | 28.93 |  | 1350 |  | 21600
 | 2001-10-03 00:00:00 |  |  |  | 27.5 |  | 900 |  | 14400
 | 2001-10-02 00:00:00 |  |  |  | 26.01 |  | 1000 |  | 16000
 | 2001-10-01 00:00:00 |  |  |  | 24.71 |  | 2050 |  | 32800
 | 2001-09-30 00:00:00
 | 2001-09-29 00:00:00
 | 2001-09-28 00:00:00 |  |  |  | 23.73 |  | 3450 |  | 55200
 | 2001-09-27 00:00:00 |  |  |  | 24.58 |  | 3200 |  | 51200
 | 2001-09-26 00:00:00 |  |  |  | 25.14 |  | 3600 |  | 57600
 | 2001-09-25 00:00:00 |  |  |  | 25.91 |  | 3650 |  | 58400
 | 2001-09-24 00:00:00 |  |  |  | 26.97 |  | 5450 |  | 87200
Spreadsheet: ad36508f-5c06-4f79-956f-5a2d7ab3665f
Sheet: Page 1

Permit No.: |  |  | WQ0015030 |  |  | Facility Name: |  | [NAME] |  |  |  |  |  | County: | Sampson |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | F1 |  | Field Name: |  | F2 |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 4.52 |  | Area (acres): |  | 11.99 |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.6 |  | [NAME] (in): |  | 0.6 |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 36.5 |  | Annual Rate (in): |  | 36.5 |  | Annual Rate (in): |  |  |  | Annual Rate (in):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 131417d1323043249-text-randbetween-problem-book1
Sheet: Sheet3

1 | Manuel | [NAME] | Trois-Rivières
2 | Vasile | Barki | Trois-Rivières
3 | Louis | Bartoli | Trois-Rivières
174 | [NAME] | Laboulais | Nicolet
175 | Emil | Lavenant | Nicolet
176 | Basile | Lelièvre | Nicolet
177 | Mathis | Pedir | Nicolet
178 | Even | Pietra | Nicolet
179 | Yveline | [NAME] | Nicolet
180 | Gisele | [NAME] | Nicolet
181 | [NAME] | Zemmouri | Nicolet
182 | Billy | Alexis | La Baie
Spreadsheet: 766685d1643996020-complex-nest-if-function-book1
Sheet: Sheet1

Name | PT ID | Payer |  | Outcome | Attempted formula
Some Name | 1234 | Private Pay |  | No note |  |  |  |  |  | Private Pay | No note
Some Name | 2345 | [NAME] |  | Note |  |  |  |  |  | Self Pay | No note
 |  |  |  | Blank (literally blank) |  |  |  |  |  | No insurance | No note
Some Name | 3456 | Self Pay |  | No note |  |  |  |  |  | OPT | No note
Some Name | 5678 | Aetna |  | Note |  |  |  |  |  | MCR-S | No note
Some Name | 7900 | No insurance |  | No note |  |  |  |  |  | MCR-M | No note
 |  | OPT |  | No note |  |  |  |  |  | Dependent | No note
 |  | MCR-S |  | No note
 |  | MCR-M |  | No note
 |  | Dependent |  | No note
Spreadsheet: 838085d1690703479-change-sheet-refernce-incrementally-in-adjacent-cells-2023-league-standings-sample-hd
Sheet: T9

Team # | Team Name | Permanent Bowler | Reserves | Lineup | Average | Handicap |  |  |  | Game 1 Scratch | Game 1 Handicap | Game 2 Scratch | Game 2 Handicap | Game 3 Scratch | Game 3 Handicap | Scratch Series | Handicap Series | Indiv Points
9 | [NAME] | Player26 |  |  |  |  |  |  | Week 1
 |  | Player27 |  |  |  |  |  |  | Week 2
 |  | Player28 |  |  |  |  |  |  | Week 3
 |  |  |  |  |  |  |  |  | Week 4
 |  |  |  |  |  |  |  |  | Week 5
 |  |  |  |  |  |  |  |  | Week 6
 |  |  |  |  |  |  |  |  | Week 7
 |  |  |  |  |  |  |  |  | Week 8
 |  |  |  |  |  |  |  |  | Week 9
 | [NAME] |  |  |  |  |  |  |  | Week 10
 |  | Player26 | 98 |  |  |  |  |  | Week 11
 |  | Player27 | 105 |  |  |  |  |  | Week 12
 |  | Player28 | 89 |  |  |  |  |  | Week 13
 |  |  |  |  |  |  |  |  | Week 14
 |  |  |  |  |  |  |  |  | Week 15
 |  |  |  |  |  |  |  |  | Week 16
 |  | Vacant |  |  |  |  |  |  | Week 17
 |  |  |  |  |  |  |  |  | Week 18
 |  |  |  |  |  |  |  |  | Week 19
 | Reserves Lookup |  | Average |  |  |  |  |  | Week 20
 |  |  |  |  |  |  |  |  | Week 21
 |  |  |  |  |  |  |  |  | Week 22
 |  |  |  |  |  |  |  |  | Week 23
 |  |  |  |  |  |  |  |  | Week 24
 |  |  |  |  |  |  |  |  | Week 25
 |  |  |  |  |  |  |  |  | Week 26
 |  |  |  |  |  |  |  |  | Week 27
 |  |  |  |  |  |  |  |  | Week 28
 |  |  |  |  |  |  |  |  | Week 29
 |  |  |  |  |  |  |  |  | Week 30
 |  |  |  |  |  |  |  |  | Week 31
 |  |  |  |  |  |  |  |  | Week 32
 |  |  |  |  |  |  |  |  | Week 33
 |  |  |  |  |  |  |  |  | Week 34
 |  |  |  |  |  |  |  |  | Week 35
 |  |  |  |  |  |  |  |  | Week 36
 | VLOOKUP(B11,C11:C18,1,FALSE) |  |  |  |  |  |  |  | Week 37
 |  |  |  |  |  |  |  |  | Week 38
 |  |  |  |  |  |  |  |  | Week 39
 |  |  |  |  |  |  |  |  | Week 40
 |  |  |  |  |  |  |  |  | Week 41
 |  |  |  |  |  |  |  |  | Week 42
 |  |  |  |  |  |  |  |  | Week 43
 |  |  |  |  |  |  |  |  | Week 44
 |  |  |  |  |  |  |  |  | Week 45
Spreadsheet: 93236d1292856798-copy-to-invoice-excel-invoices-2
Sheet: Decors

 | Description |  | Height | [NAME] | QUANTITY | PRICE | TOTAL
DECORS
18mm | DÉCOR PANELS MDF |  | 600 | 400 | 0.24 | 55.16 | 13.2384
4mmSS | STAINLESS STEEL |  | 900 | 300 | 0.27 | 80.35 | 21.6945
 |  |  |  | SUBTOTAL |  |  | 34.9329
 |  |  |  | VAT @ 15% |  |  | 5.239935
 |  |  |  | DISCOUNT
 |  |  |  | TOTAL |  |  | 40.17283500000001
Spreadsheet: 784850d1655976977-format-of-a-cell-dependant-on-other-cells-being-populated-test
Sheet: Sheet1

Name | Theory Test | Practical Test | Oral Test | Issue Certificate
[NAME] | 2020-02-03 00:00:00 |  | 2019-03-02 00:00:00
[NAME] |  | 2020-03-03 00:00:00
[NAME] | 2019-03-01 00:00:00 | 2019-07-05 00:00:00
[NAME] | 2020-03-19 00:00:00 | 2019-02-20 00:00:00 | 2020-07-20 00:00:00
[NAME] | 2019-11-11 00:00:00 |  | 2019-08-03 00:00:00
 |  |  |  |  |  |  |  |  | This cell to turn red to indicate all 3 tests have been completed and certificate needs to be issued.
 |  |  |  |  |  |  |  |  | Once certificate issue date has been entered, the red highlight should disappear.
 |  |  |  |  |  |  |  |  | You shouldn't be able to enter date in this cell until all 3 tests have been completed.
Spreadsheet: gerald_nemec__11422__exhibit b
Sheet: Jan

EXHIBIT B
JANUARY
Heat Rate | 12400
Avg. Load Factor | 0.85
Days in Month | 31
Monthly MMBtu @ 85%
Load Factor | Proposed Monthly Gas Nomination |  | Load Factor | Proposed Monthly Gas Nomination
0.01
Spreadsheet: 837457d1690193748-formula-help-for-currency-layouts-excel-example
Sheet: Sheet1

Country | Monthly Lease Cost excluding contractual maintenance (EUR) | [NAME]Contractual) | Total Monthly Lease Cost
Finland | 623.15 | 36.99 | 665.47 |  | Notes
Finland | 626.17 | 40.02 | 671.76 |  | Some show as a , for the value
Finland | 481.87 | 39.17 | 525.28 |  | Some show as a . For the value
Finland | 694.78 | 38.03 | 738.92
Finland | 591.68 | 31.12 | 627.88
Italy | 1.200,27 | 94,73 | 1.295,00
Italy | 677,71 | 48,37 | 726,08
Italy | 696,02 | 69,95 | 765,97
Netherlands | € 1.189,94 | € 184,00 | € 1.373,94
Netherlands | € 715,21 | € 188,10 | € 903,31
Netherlands | € 676,94 | € 485,93 | € 1.162,87
Netherlands | € 490,47 | € 171,00 | € 661,47
Netherlands | € 890,11 | € 374,53 | € 1.264,64
Netherlands | € 909,42 | € 398,29 | € 1.307,71
Netherlands | € 1.012,31 | € 259,43 | € 1.271,74
AUSTRIA | 426.76 | 175.01 | 1077.54
AUSTRIA | 396.81 | 175.32 | 1042.98
AUSTRIA | 626.09 | 214.64 | 1047.67
AUSTRIA | 261.58 | 43.8 | 507.85
AUSTRIA | 293.48 | 39.33 | 332.81
Spreadsheet: 141e9075-a062-42a4-8306-c995586d24cb
Sheet: BS~2011

 | CITRIX SYSTEMS, INC.
 | BALANCE SHEETS
 | (In thousands, except par value - unaudited)
 |  | December 31,
 | ASSETS | 2011
 | Current assets:
 | Cash and cash equivalents | 333296
 | Short-term investments | 406461
 | Accounts receivable net of allowances | 484431
 | Other current assets, net | 148842
 | Total current assets
 | Long-term investments | 737844
 | Property and equipment, net | 277429
 | Goodwill and other intangible assets, net | 1582492
 | Other long-term assets | 128746
 | LIABILITIES AND STOCKHOLDERS' EQUITY
 | Current liabilities:
 | Accounts payable and accrued expenses | 360488
 | Current portion of deferred revenues | 818642
 | Total current liabilities
 | Long-term portion of deferred revenues | 141241
 | Other liabilities | 48680
 | Total stockholders' equity | 2730490
 | Note:  This document should be read in conjunction with the Company's SEC Filings.
Spreadsheet: 55062d1255135495-formula-to-count-occurrences-of-multiple-elements-within-a-string-sample-data
Sheet: Sheet1

 | Ref | Condition | T / F |  |  |  |  |  |  | Record |  |  |  |  |  | AND
 | 1 | a |  |  |  |  |  |  | 1 | 1,4 |  |  |  |  |  | OR
 | 2 | b |  |  |  |  |  |  | 2 | 2,6
 | 3 | c |  | 1 |  |  |  |  | 3 | 1,3,5
 | 4 | d |  |  |  |  |  |  | 4 | 3,8
 | 5 | e |  |  |  |  |  |  | 5 | 6,7
 | 6 | f |  |  |  |  |  |  | 6 | 2,5
 | 7 | g |  |  |  |  |  |  | 7 | 1,2,6
 | 8 | h |  | 1 |  |  |  |  | 8 | 1,3
 | 9 | i |  |  |  |  |  |  | 9 | 2,4
 | 10 | j |  |  |  |  |  |  | 10 | 3,4
 |  |  |  |  |  |  |  |  | 11 | 3,6
 |  | Type | AND |  |  |  |  |  | 12 | 2,8
 |  |  |  |  |  |  |  |  | 13 | 4,6
 | The check boxes above are ticked and the drop down selected for AND/OR. |  |  |  |  |  |  |  | 14 | 8,9
 | The problem is finding a formula to match the refereeence number to the string |  |  |  |  |  |  |  | 15 | 4,10
 | in thec record list to the right. |  |  |  |  |  |  |  | 16 | 3,9
 |  |  |  |  |  |  |  |  | 17 | 2,4
 |  |  |  |  |  |  |  |  | 18 | 1,5,7
 |  |  |  |  |  |  |  |  | 19 | 1,9
 |  |  |  |  |  |  |  |  | 20 | 2,8
Spreadsheet: 867282d1714127056-looking-for-shortcut-to-put-all-tab-names-on-one-tab-plus-data-template-empty
Sheet: Company Name 9

 |  |  |  |  |  | Company Name 9
 |  | Month ending
 |  | Enter month
 | Date | Invoice number | Total | Materials | Labour | Tax | [NAME] | Payable
 |  | Totals
[NAME]
Company No. 06977736
Spreadsheet: 141460d1329285768-nested-if-statement-sample-reva
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Sales length |  |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00
Pilot Length | 90
Expansion
 |  | PHLY
 |  |  | 1
 |  |  | 20
 |  |  | 20
 |  |  | 30
 |  |  | 30
 |  |  | 30
 |  |  | 40
 |  |  | 40
Spreadsheet: 1a279e6e-25cd-41c7-b0dd-967f4f1ff7a7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261339 | 66272 | [NAME] | Takeuchi | JPN | 23 | 00:24:48 | 00:03:14 | 00:48:56 | 00:04:19 | 01:02:16 | 1 | 02:23:33
Spreadsheet: 35132d1232644530-copying-hyperlinks-december-2008-excel-forum
Sheet: 2(a)

[NAME] по счетам группы компаний "Вагриус" |  |  |  |  |  |  | 2(a)
на начало дня 2 Декабря 2008 года
[NAME] компании | Без Нал. | Нал. | Сумма
[NAME] | 10000 | 0 | 10000 |  |  | [NAME] | A5 | B16 | C16 | F16
Вагриус книги | 20000 | 0 | 20000 |  |  | Вагриус книги | A20 | B32 | C32 | F32
Вагриус правда | 30000 | 0 | 30000 |  |  | Вагриус правда | A36 | B48 | C48 | F48
Вагриус минус | 40000 | 0 | 40000 |  |  | Вагриус минус | A52 | B64 | C64 | F64
Плюс-минус | 50000 | 0 | 50000 |  |  | Плюс-минус | A68 | B80 | C80 | F80
Издательство Вагриус | 60000 | 0 | 60000 |  |  | Издательство Вагриус | A84 | [NAME] | C96 | F96
Вагриус плюс-минус | 70000 | 0 | 70000 |  |  | Вагриус плюс-минус | A100 | B112 | C112 | F112
Общий Итог: | 280000 | 0 | 280000 |  |  |  |  | B115 | C115 | F115
 |  |  |  |  |  | [NAME] | A122 | B134 | C134 | F134
Фактические РАСХОДЫ по счетам группы компаний "Вагриус" |  |  |  |  |  | Вагриус книги | A138 | B150 | C150 | F150
на конец дня 2 Декабря 2008 года |  |  |  |  |  | Вагриус правда | A154 | B166 | C166 | F166
[NAME] компании | Без Нал. | Нал. | Сумма |  |  | Вагриус минус | A170 | B182 | C182 | F182
[NAME] | 0 | 0 | 0 |  |  | Плюс-минус | A186 | B198 | C198 | F198
Вагриус книги | 0 | 0 | 0 |  |  | Издательство Вагриус | A202 | B214 | C214 | F214
Вагриус правда | 0 | 0 | 0 |  |  | Вагриус плюс-минус | A218 | B230 | C230 | F230
Вагриус минус | 0 | 0 | 0 |  |  |  |  | B233 | C233 | F233
Плюс-минус | 0 | 0 | 0
Издательство Вагриус | 0 | 0 | 0
Вагриус плюс-минус | 0 | 0 | 0
Общий Итог: | 0 | 0 | 0
Spreadsheet: 810857d1672132530-formula-for-sum-is-not-working-when-there-is-any-blank-cell-in-its-series-sample-copy
Sheet: Y13

 |  |  |  |  |  |  |  |  |  |  |  |  | Sum of Numerators | Sum of Denominators
 | 13/20 | 4/10 | 3/5 |  | 7/12 | 8/10 | 21/30 | 2/10 | 10/20 | 34/50 | 65/80
 | 14/20 | 6/10 | 4/5 | 13/20 | 12/12 | 9/10 |  | 4/10 | 12/20 | 45/50 | 66/80
Spreadsheet: 812453d1673165886-list-of-upcoming-birthday-this-month-and-next-month-book1-9
Sheet: Upcoming Birthday

 |  | DATE
 |  |  |  |  |  |  |  |  |  |  | UPCOMING BIRTHDAY THIS MONTH AND NEXT MONTH
 |  | NAME | BIRHTDATE | DAY | MONTH | BIRTHDAY2 | AGE |  |  | NAME | BIRHTDATE | DAY | MONTH | BIRTHDAY2 | AGE
Spreadsheet: 36551d1234430184-copying-hyperlinks-yearly-and-quarterly-excel-forum
Sheet: Quarter 1(a)

[NAME] по счетам группы компаний "Вагриус" |  |  |  |  |  |  | Quarter 1(a)
за период января - марта 2009 года
[NAME] компании | Без Нал. | Нал. | Сумма
[NAME] | 629000 | 0 | 629000 |  |  | [NAME] | A6 | C9 | D9 | E9
Вагриус книги | 0 | 0 | 0 |  |  | Вагриус книги | A20 | C23 | D23 | E23
Вагриус правда | 1378072.66 | 0 | 1378072.66 |  |  | Вагриус правда | A34 | C37 | D37 | E37
Вагриус минус | 0 | 0 | 0 |  |  | Вагриус минус | A48 | C51 | D51 | E51
Плюс-минус | 0 | 0 | 0 |  |  | Плюс-минус | A62 | C65 | D65 | E65
Издательство Вагриус | 766000 | 0 | 766000 |  |  | Издательство Вагриус | A76 | C79 | D79 | E79
Вагриус плюс-минус | 0 | 0 | 0 |  |  | Вагриус плюс-минус | A90 | C93 | D93 | E93
Общий Итог: | 2773072.66 | 0 | 2773072.66 |  |  |  |  | C95 | D95 | E95
 |  |  |  |  |  | [NAME] | A110 | C113 | D113 | E113
 |  |  |  |  |  | Вагриус книги | A124 | C127 | D127 | E127
 |  |  |  |  |  | Вагриус правда | A138 | C141 | D141 | E141
Фактические РАСХОДЫ по счетам группы компаний "Вагриус" |  |  |  |  |  | Вагриус минус | A152 | C155 | D155 | E155
за период января - марта 2009 года |  |  |  |  |  | Плюс-минус | A166 | C169 | D169 | E169
[NAME] компании | Без Нал. | Нал. | Сумма |  |  | Издательство Вагриус | A180 | C183 | D183 | E183
[NAME] | 576369.4099999999 | 0 | 576369.4099999999 |  |  | Вагриус плюс-минус | A194 | C197 | D197 | E197
Вагриус книги | 600 | 0 | 600 |  |  |  |  | C199 | D199 | E199
Вагриус правда | 1476234.96 | 0 | 1476234.96
Вагриус минус | 600 | 0 | 600
Плюс-минус | 0 | 0 | 0
Издательство Вагриус | 766780 | 0 | 766780
Вагриус плюс-минус | 0 | 0 | 0
Общий Итог: | 2820584.37 | 0 | 2820584.37
Spreadsheet: 123022d1317296198-sort-columns-not-redundant-sorting
Sheet: Sheet1

 | Unsorted |  |  |  |  |  | Sorted
 | Column 1 | Column 2 | Col 1 Index | Index | Rank |  | # | Column 1 | Column 2
 | A | 1 |  |  |  |  | 1 |  |  |  |  |  | A | 1 |-> A | 1
 | A | 2 |  |  |  |  | 2 |  |  |  |  |  | A | 2 |-> B | 4
 | A | 3 |  |  |  |  | 3 |  |  |  |  |  | A | 3 |-> C | 7
 | B | 4 |  |  |  |  | 4 |  |  |  |  |  | B | 4 |-> D | 8
 | B | 5 |  |  |  |  | 5 |  |  |  |  |  | B | 5 |-> A | 2
 | B | 6 |  |  |  |  | 6 |  |  |  |  |  | B | 6 |-> B | 5
 | C | 7 |  |  |  |  | 7 |  |  |  |  |  | C | 7 |-> D | 9
 | D | 8 |  |  |  |  | 8 |  |  |  |  |  | D | 8 |-> A | 3
 | D | 9 |  |  |  |  | 9 |  |  |  |  |  | D | 9 |-> B | 6
Spreadsheet: 525276d1498654439-hlookups-to-manipulate-spreadsheet-data-transformationv2
Sheet: Mapping Table 1

Row # | Attributes |  |  |  |  |  | Mappings
1 | Attribute 1 | Attribute 2 | Attribute 3 | Attribute 4 | Attribute 5 | Attribute 6 | 1
2 | Attribute 1a | Attribute 2a | Attribute 3a | Attribute 4a | Attribute 5a | Attribute 6a | 2
3 | Attribute 1b | Attribute 2b | Attribute 3b | Attribute 4b | Attribute 5b | Attribute 6b | 3
 | Mappings
 | 1 | Mapped Value 1
 | 1 | Mapped Value 17
 | 1 | Mapped Value 7
 | 1 | Mapped Value 2
 | 1 | Mapped Value 5
 | 1 | Mapped Value 13