tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 478116d1472645460-ranked-scoring-ranking-count
Sheet: Sheet1

[NAME] | Top 3 Common Causes |  |  | Question Failed On |  |  |  |  |  |  |  |  |  |  | Cleaned Data
 | 1st | 2nd | 3rd | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10 |  | 1st | 2nd | 3rd
Expert |  |  |  | 6 |  |  | 1 |  |  |  | 1 |  |  | 3
[NAME] |  |  |  | 1
A&R Precusuib |  |  |  |  |  |  |  | 1
Fielding |  |  |  |  |  |  |  |  | 1
CNC Solutions |  |  |  |  |  |  |  |  |  | 1
ACER |  |  |  | 4
Paton |  |  |  | 4 |  |  |  |  |  | 1
S&J |  |  |  |  |  |  | 1
Shaghai |  |  |  |  |  |  |  |  | 1
Apollo |  |  |  | 11 |  |  |  |  |  |  | 1
KM |  |  |  | 2 |  |  |  |  |  |  |  | 1
T&S |  |  |  | 3
RPS |  |  |  | 1
Gigmatic |  |  |  | 1
SKR |  |  |  | 1
MJW |  |  |  | 3 |  |  |  | 1
CPE |  |  |  | 4 | 2 | 1 | 1 |  | 2 | 1 | 2 | 2
Covington |  |  |  | 2
Slavia |  |  |  | 1
Gunes |  |  |  | 2
[NAME] |  |  |  | 5 |  |  |  |  |  | 1 | 1 | 1
Croft |  |  |  | 2
T&EE |  |  |  | 2
Walter |  |  |  | 1
SH jig borring |  |  |  | 1
K&M welding |  |  |  | 2
Monolution ltd |  |  |  | 1
[NAME] |  |  |  | 1
TEE |  |  |  | 3
Paton Precision |  |  |  | 1
Millfast |  |  |  | 3
Shanghai Karmac |  |  |  | 1
RPSE |  |  |  | 2
CWC |  |  |  | 1
BPE |  |  |  | 5
GRP |  |  |  | 1
DP2000 |  |  |  | 1
Allmake |  |  |  | 3
CAR |  |  |  | 1
[NAME] |  |  |  | 1
Croft Engineering |  |  |  | 1
Conquest |  |  |  | 1
Fabrication & Machining |  |  |  | 2
HUM |  |  |  | 1
Shawton |  |  |  | 1
Booths |  |  |  | 2
Willstec |  |  |  | 1
C.A.R Tooling |  |  |  | 1
Microstep |  |  |  | 2
Expert NE |  |  |  | 2
Vericam |  |  |  |  |  |  | 1 |  |  |  |  | 1 | 1
Spreadsheet: 42cd56c3-b650-40c9-9738-1f254cea38c0
Sheet: WebofScience

Web of Science
2008-2009
COUNTER-Compliant?: | Yes
 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | Total | 2008-2009 Price | Price per unit
BIOSIS Previews
Sessions | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 0 | 0 | 0 | 2 | 4
Queries | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 0 | 0 | 0 | 2 | 6
See also: WebSpirs, OVID.
 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | Total | 2008-2009 Price | Price per unit
Web of Knowledge
Sessions | 895 | 539 | 969 | 1241 | 1055 | 631 | 687 | 980 | 895 | 869 | 914 | 653 |  | N/A | N/A
 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | Total | 2008-2009 Price | Price per unit
Web of Science
Sessions | 413 | 293 | 707 | 860 | 766 | 493 | 293 | 318 | 632 | 639 | 406 | 467
Queries | 1860 | 1427 | 2916 | 3517 | 4285 | 2412 | 1807 | 1331 | 3190 | 3332 | 2168 | 2664 |  | 104394
 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | Total
[NAME]
Logins | 9 | 1 | 20 | 30 | 8 | 2 | 6 | 8 | 12 | 2 | 0 | 2
New Users | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0
New References | 0 | 0 | 40 | 160 | 0 | 0 | 20 | 4 | 0 | 0 | 0 | 0
Exports | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 4 | 0 | 1 | 2
Imports | 0 | 1 | 0 | 8 | 0 | 0 | 5 | 1 | 1 | 7 | 0 | 0
Searches | 3 | 0 | 4 | 2 | 15 | 1 | 3 | 3 | 1 | 0 | 0 | 1
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CWYW [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
CWYW Traveling Library | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Pages Served | 12 | 2 | 64 | 201 | 26 | 3 | 40 | 17 | 18 | 9 | 1 | 5
Spreadsheet: 136828d1326836791-performance-report-report1_pt_jpr73
Sheet: Data

Box  No | Binders  name | Operator  Name | NO OF  PGS | Start Time  (24 hr Format) | Finish Time  (24 hr Format) | Total  Time | Time in  Minutes | Average | QC'ER | NO OF  PGS2 | COMMENTS | A4  Colour | A3  B&W | A3  Colour | A2  B&W | A2  Colour | A1  B&W | A1  Colour | A0  B&W | A0  Colour | Rebind | OCR | OCR QC | DATE EXPORTED
1 | Binder 1 | [NAME] | 50 | 11:00:00 | 12:00:00
1 | [NAME] | [NAME] | 30 | 12:30:00 | 13:00:00
1 | Binder 3 | [NAME] | 20 | 12:00:00 | 12:45:00
1 | [NAME] | [NAME] | 85 | 11:00:00 | 12:20:00
1 | Binder 5 | [NAME] | 80 | 10:00:00 | 13:00:00
1 | Binder 6 | [NAME] | 20 | 13:20:00 | 14:00:00
1 | Binder 7 | [NAME] | 85 | 12:00:00 | 12:15:00
1 | Binder 8 | [NAME] | 20 | 13:00:00 | 14:00:00
1 | Binder 9 | [NAME] | 100 | 13:00:00 | 14:30:00
1 | Binder 10 | [NAME] | 10 | 15:00:00 | 15:30:00
Spreadsheet: 123127d1317364814-move-columns-with-macro-hidemarkedcols-1-1-
Sheet: HideColumns

 |  |  |  | X | X | X | X | X | X | X | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | X
 |  |  |  | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00
 |  |  |  | 33 | 22 | 55 | 85 | 7 | 72 | 74 | 80 | 42 | 54 | 33 | 3
 |  |  |  | 46 | 69 | 56 | 83 | 51 | 93 | 33 | 62 | 84 | 68 | 54 | 71
 |  |  |  | 95 | 95 | 50 | 49 | 1 | 43 | 98 | 95 | 29 | 68 | 38 | 3
 |  |  |  | 28 | 61 | 58 | 3 | 1 | 11 | 51 | 7 | 39 | 73 | 89 | 57
 |  |  |  | 64 | 53 | 41 | 11 | 44 | 25 | 50 | 8 | 36 | 88 | 19 | 13
 |  |  |  |  |  |  | 2011-01-08 00:00:00 | 8
 |  |  |  |  |  |  | 2011-01-11 00:00:00 | 11
 |  | In this workbook, you select two days. Pressing "Hide marked" button, you see days between those two days. Okay that works, but is there way to do next: Can i move those cells which are visible after hiding. Example: I select days which are in range J:O (6-Jan-11 to 11-Jan-11), after hiding i want those to move to the E:H where 1-Jan-11 is now.
Spreadsheet: 109765d1306526392-formula-requiring-three-actions-auto-data-pt-sample
Sheet: CSA Raw Data

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
Identifier | Zone | Make | Zone Rank | Dealer Name | April MTD | MTD Percent | [NAME] | YTD Percent
CSAAcura1 | CSA | Acura | 1 | [NAME] | 54 | 0.461538461538461 | 175 | 0.40137614678899
CSAAcura2 | CSA | Acura | 2 | Motorcars Acura Volvo | 39 | 0.333333333333333 | 169 | 0.387614678899082
CSAAcura3 | CSA | Acura | 3 | [NAME] | 21 | 0.179487179487179 | 79 | 0.181192660550458
CSAAcura4 | CSA | Acura | 4 | [NAME] | 0 | 0 | 5 | 0.0114678899082568
CSAAcura5 | CSA | Acura | 5 | Acura/Mitsubishi of Boardman | 0 | 0 | 3 | 0.00688073394495412
CSAAcura6 | CSA | Acura | 6 | [NAME] | 1 | 0.00854700854700854 | 1 | 0.00229357798165137
CSAAcura7 | CSA | Acura | 7 | [NAME] | 1 | 0.00854700854700854 | 1 | 0.00229357798165137
CSAAcura8 | CSA | Acura | 8 | [NAME] | 1 | 0.00854700854700854 | 1 | 0.00229357798165137
CSAAcura9 | CSA | Acura | 9 | Acura Columbus | 0 | 0 | 1 | 0.00229357798165137
CSAAcura10 | CSA | Acura | 10 | Mathews Acura | 0 | 0 | 1 | 0.00229357798165137
Spreadsheet: 0a9bd85d-ca33-4ffc-81b6-0fe9fcc107ec
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 20. Number of Dwelling Units Approved in New Residential Buildings, Original - Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Number of Dwelling Units ;  New ;  Total houses ; |  |  | Original | A418403T | 1956-01-01 00:00:00 | 2009-09-01 00:00:00 | 645 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Semi-detached, row or terrace house, townhouse with one storey and similar ; |  |  | Original | A415785F | 1991-07-01 00:00:00 | 2009-09-01 00:00:00 | 219 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Semi-detached, row or terrace house, townhouse with two or more storeys ; |  |  | Original | A422926F | 1991-07-01 00:00:00 | 2009-09-01 00:00:00 | 219 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Total semi-detached, row or terrace houses, townhouses and similar ; |  |  | Original | A416421K | 1991-07-01 00:00:00 | 2009-09-01 00:00:00 | 219 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Flat, unit or apartment in a building of one or two storeys ; |  |  | Original | A423529V | 1991-07-01 00:00:00 | 2009-09-01 00:00:00 | 219 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Flat, unit or apartment in a building of three storeys ; |  |  | Original | A424174L | 1991-07-01 00:00:00 | 2009-09-01 00:00:00 | 219 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Flat, unit or apartment in a building of four or more storeys ; |  |  | Original | A424726X | 1991-07-01 00:00:00 | 2009-09-01 00:00:00 | 219 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Total flats, units or apartments, excl. [NAME] flats and other/unknown ; |  |  | Original | A417063R | 1991-07-01 00:00:00 | 2009-09-01 00:00:00 | 219 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Total other residential building ; |  |  | Original | A419138J | 1970-07-01 00:00:00 | 2009-09-01 00:00:00 | 471 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Total residential building ; |  |  | Original | A419824J | 1956-01-01 00:00:00 | 2009-09-01 00:00:00 | 645 | Number | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 173889d1344843189-need-a-macro-that-finds-and-replace-text-in-multiple-sheet-xxy
Sheet: WorkSheet 7

MEASURES as values
The Americas | USA
 | CANADA
 | MEXICO
 | PUERTO RICO
 | CHILE
 | Origin
Germany | GERMANY
 | Origin
Europe + Africa | HUNGARY
 | ITALY
 | SWITZERLAND
 | FINLAND
 | NETHERLANDS
 | CZECH REPUBLIC
 | SPAIN AND CANARY ISLANDS
 | AUSTRIA
 | BELGIUM
 | SWEDEN
 | FRANCE
 | UNITED KINGDOM
 | ROMANIA
 | TURKEY
 | POLAND
 | KAZAKHSTAN
 | PORTUGAL
 | SLOVENIA
 | DENMARK
 | IRELAND
 | EGYPT ARAB REP
 | GERMANY
 | RUSSIAN FEDERATION
 | Origin
APAC | HONG KONG (SAR) CHINA
 | INDIA
 | PEOPLE'S REPUBLIC OF CHIN
 | KOREA REPUBLIC OF
 | JAPAN
 | MALAYSIA
 | SINGAPORE
 | THAILAND
 | UNITED ARAB EMIRATES
 | BANGLADESH
 | PAKISTAN
 | QATAR
 | INDONESIA
 | CHINESE TAIPEI
 | PHILIPPINES
 | KUWAIT
 | VIETNAM SOC REP OF
 | Origin
Sales Org Export
Spreadsheet: 719596d1613736602-time-weighted-number-of-shares-new-microsoft-excel-worksheet
Sheet: Sheet1

 | Date | Shares |  |  |  |  |  | Transactions | Date | Shares
 | 2020-02-01 00:00:00 | 0 |  |  |  |  |  |  | 2020-02-13 00:00:00 | 100
 | 2020-02-02 00:00:00 | 0 |  |  |  |  |  |  | 2020-02-23 00:00:00 | 100
 | 2020-02-03 00:00:00 | 0 |  |  |  |  |  |  | 2020-03-12 00:00:00 | 20
 | 2020-02-04 00:00:00 | 0 |  |  |  |  |  |  | 2020-04-04 00:00:00 | 300
 | 2020-02-05 00:00:00 | 0 |  |  |  |  |  |  | 2020-05-06 00:00:00 | -40
 | 2020-02-06 00:00:00 | 0
 | 2020-02-07 00:00:00 | 0
 | 2020-02-08 00:00:00 | 0 |  |  |  |  |  | Holdings | Date | Time weighted shares
 | 2020-02-09 00:00:00 | 0 |  |  |  |  |  |  | 2020-01-31 00:00:00
 | 2020-02-10 00:00:00 | 0 |  |  |  |  |  |  | 2020-02-29 00:00:00 | x
 | 2020-02-11 00:00:00 | 0 |  |  |  |  |  |  | 2020-03-31 00:00:00 | x
 | 2020-02-12 00:00:00 | 0 |  |  |  |  |  |  | 2020-04-30 00:00:00 | x
 | 2020-02-13 00:00:00 | 100 |  |  |  |  |  |  | 2020-05-31 00:00:00 | x
 | 2020-02-14 00:00:00 | 100
 | 2020-02-15 00:00:00 | 100
 | 2020-02-16 00:00:00 | 100
 | 2020-02-17 00:00:00 | 100
 | 2020-02-18 00:00:00 | 100 |  | Weight average number of shares
 | 2020-02-19 00:00:00 | 100
 | 2020-02-20 00:00:00 | 100
 | 2020-02-21 00:00:00 | 100
 | 2020-02-22 00:00:00 | 100
 | 2020-02-23 00:00:00 | 200
 | 2020-02-24 00:00:00 | 200
 | 2020-02-25 00:00:00 | 200
 | 2020-02-26 00:00:00 | 200
 | 2020-02-27 00:00:00 | 200
 | 2020-02-28 00:00:00 | 200
 | 2020-02-29 00:00:00 | 200
Spreadsheet: 858718d1707301040-to-map-old-code-to-new-code-base-on-date-sum-if-lookup-with-date-criteria-1-1-
Sheet: Sheet1

Code | Tag | WEF |  |  | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 |  |  | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00
300500 | 7000 | 2000-01-01 00:00:00 |  | 300500 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 |  | 7000 | 50000 | 50000 | 50000
300500 | 8000 | 2023-12-31 00:00:00 |  | 300501 | 12500 | 12500 | 12500 | 11000 | 11000 | 11000 |  | 8000 |  |  |  | 50000 | 50000 | 50000
300501 | 5000 | 2000-01-01 00:00:00 |  |  |  |  |  |  |  |  |  | 5000 | 12500 | 12500
300501 | 5500 | 2024-01-31 00:00:00 |  |  |  |  |  |  |  |  |  | 5500 |  |  | 12500 | 11000 | 11000 | 11000
300500 | 9000 | 2024-02-29 00:00:00 |  |  |  |  |  |  |  |  |  | 9000 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  | This is my Old Mapping |  |  |  |  |  |  |  | This is new Mapping
 |  |  |  |  |  |  |  |  |  |  |  | * How do I pas on A:C and do up M:S base on E:K?
 |  |  |  |  |  |  |  |  |  |  |  | Column A is Old Mapping
 |  |  |  |  |  |  |  |  |  |  |  | Column B is New Tagging
 |  |  |  |  |  |  |  |  |  |  |  | Column C is when the New Tagging take place
Spreadsheet: 42958d1241569761-excel-2007-loan-amortisation-schedule-loan-amort
Sheet: Sheet2

Pymt No | Pymt Date | Term (M) | Int Rate | Principal | Payment | Prin | Int | [NAME] | TEST | [NAME]
1 | 2003-08-01 00:00:00 | 3000 | 0.0755 | 12752
Spreadsheet: 538686d1505770429-calculations-going-wrong-sumif-from-another-sheet
Sheet: Sheet1

Division | Store | Store Name | Number of Audits Done | Total Sales from All Audits | Total Loss from All Audits | Duplicates from All Audits | Voids from All Audits | YTD Loss % | YTD  Duplicate % | YTD Void %
DO NOT RE-SORT THIS SHEET
CRC | 071 | 112-05 SUTPHIN
CRC | 112 | 105-16 FLATLANDS
CRC | 111 | 3720 [NAME]
Spreadsheet: 692814d1598584387-certain-cells-are-not-displaying-the-data-phonelist-ver-2-test
Sheet: Data

Category | DEPT | WORKCENTER | Office Symbols
Cat 01 | ADMIN | Carpenters | CARP
Cat 02 | ENGINEERING | Safety | SAFE
Cat 03 | FIRE EMERG SVS | Plumbers | PLUM
Cat 04 | HAZMAT/SAFETY | Streets | STRE
Cat 05 | MANAGEMENT | Roads | ROAD
Cat 06 | OPERATIONS | Structures | STRU
Cat 07 | SERVICES | Electricains | ELEC
Spreadsheet: 53938d1253864853-merging-into-single-column-sample-form
Sheet: Sheet1

HOUSE NO | ADDRESS RECORD | STREET | MUNICIPALITY |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CODE_COLUMN
ADUANA | ST. | INTRAMUROS | CODE-4008
ADUANA | ST.INTRAMUROS | CODE-4009
ADUANA | ST. | INTRAMUROS | CODE-4010
1535 | ADRIATICO | M | ST | (DAKOTA) | ERMITA | ERMITA | MANILA | 9999 | CODE-3848
1535 | ADRIATICO | M | ST | (DAKOTA) | MALATE | ERMITA | MANILA | 9999 | [NAME]
1547 | INT | ADRIATICO | M | ST | (DAKOTA) | ERMITA | ERMITA | MANILA | 9999 | CODE-3854
1555 | ADRIATICO | M | ST | (DAKOTA) | ERMITA | ERMITA | MANILA | 9999 | CODE-3856
1555 | ADRIATICO | M | ST | (DAKOTA) | ERMITA | ERMITA | MANILA | 9999 | CODE-3857
1555 | ADRIATICO | M | ST | (DAKOTA) | ERMITA | ERMITA | MANILA | 9999 | CODE-3858
706 | SAN | MARCELINO | ST. | ERMITA | MANILA | CODE-3975
710 | 710 | SAN | MARCELINO | ST. | ERMITA | MANILA | CODE-3982
7101 | SAN | MARCELINO | ST. | ERMITA | MANILA | CODE-3981
718 | E | SAN | MARCELINO | ST. | ERMITA | MANILA | CODE-3984
718 | H | INT | SAN | MARCELINO | ST. | ERMITA | MANILA | CODE-3985
718 | SAN | MARCELINO | ST. | MALATE | ERMITA | MANILA | [NAME]
1439 | DEL | PILAR | M | H | ST | ERMITA | ERMITA | MANILA | 9999 | CODE-3846
1242 | GUERRERO | ST | ERMITA | ERMITA | MANILA | 9999 | CODE-3844
1578 | MABINI | A | ST | ERMITA | ERMITA | MANILA | 9999 | CODE-3863
1578 | MABINI | A | ST | ERMITA | MANILA | 9999 | CODE-3864
1550 | MABINI | A | ST | ERMITA | ERMITA | MANILA | 9999 | CODE-3855
1564 | MABINI | A | ST | GEDISCO | CENTER | BLDG | ERMITA | ERMITA | MANILA | 9999 | CODE-3859
1542 | MABINI | A | ST | ERMITA | ERMITA | MANILA | 9999 | CODE-3852
1540 | MABINI | A | ST | ERMITA | ERMITA | MANILA | 9999 | CODE-3850
1540 | MABINI | A | ST | ERMITA | ERMITA | MANILA | 9999 | CODE-3851
1546 | MABINI | A | ST | ERMITA | ERMITA | MANILA | 9999 | CODE-3853
1564 | MABINI | A | ST | GEDISCO | CENTER | BLDG | ERMITA | ERMITA | MANILA | 9999 | CODE-3860
1564 | MABINI | A | ST | GEDISCO | CENTER | BLDG | ERMITA | ERMITA | MANILA | 9999 | CODE-3861
1564 | MABINI | A | ST | GEDISCO | CENTER | BLDG | ERMITA | ERMITA | MANILA | 9999 | CODE-3862
507 | UNITED | NATIONS | AVE | ERMITA | ERMITA | MANILA | CODE-3837
1036 | MABINI | A | ST | MALATE | ERMITA | MANILA | CODE-3836
709 | 709 | MERCEDES | ST. | ERMITA | MANILA | CODE-3979
Spreadsheet: 778198d1650910546-conditional-formatting-for-blank-cells-with-dependency-on-other-cell-eh_cf-formula
Sheet: Sheet1

Client list (formula) | BU
 | Fish
 | [NAME]
 | Alcohol
 | [NAME]
 | Fish
 | Alcohol
 | Health & Beauty
 | Health & Beauty
 | [NAME]
 | Fish
 | Packages
Spreadsheet: 02facd2d-2c06-4dec-bc6e-f0cd5b681a9f
Sheet: Sheet1

응   시   현   황(총괄) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
구분 | 직 렬 |  | 직류 | 계급 | [NAME] | 출원인원 | 응시인원 | 응시율(%)
[NAME] |  |  |  |  | 65 | 3272 | 2166 | 66.19804400977995
공개 경쟁 임용 | 행정직 | 일     반 | 일반행정 | 9급 | 27 | 1982 | 1383 | 69.77800201816348
 |  | 장 애 인 | 일반행정 | 9급 | 3 | 65 | 49 | 75.38461538461539
 |  | 저소득층 | 일반행정 | 9급 | 1 | 6 | 5 | 83.33333333333334
 | 세무직 |  | 지 방 세 | 9급 | 2 | 124 | 84 | 67.74193548387096
 | 사회복지직 |  | 사회복지 | 9급 | 4 | 109 | 63 | 57.79816513761467
 | 사서직 |  | 사    서 | 9급 | 1 | 24 | 12 | 50
 | [NAME] |  | 산림자원 | 9급 | 2 | 34 | 21 | 61.76470588235294
 | 보건직 |  | 보    건 | 9급 | 4 | 131 | 88 | 67.17557251908397
 | 간호직 |  | 간    호 | 8급 | 6 | 147 | 102 | 69.38775510204081
 | 환경직 |  | 일반환경 | 9급 | 1 | 24 | 16 | 66.66666666666666
 | 시설직 |  | [NAME] | 9급 | 1 | 47 | 21 | 44.68085106382978
 |  |  | 건    축 | 9급 | 1 | 42 | 21 | 50
 |  |  | 지    적 | 9급 | 1 | 15 | 11 | 73.33333333333333
 | 통신직 |  | 통신기술 | 9급 | 1 | 29 | 16 | 55.17241379310344
제한 경쟁 특별 임용 | 학   예 연구직 | 고고학 | 학예일반 | 연구사 | 1 | 28 | 19 | 67.85714285714286
 |  | 민속학 | 학예일반 | 연구사 | 1 | 40 | 24 | 60
 |  | 박물관학교육 | 학예일반 | 연구사 | 1 | 73 | 43 | 58.9041095890411
 | [NAME] |  | 임    업 | 연구사 | 1 | 48 | 27 | 56.25
 | 수의연구직 |  | 수    의 | 연구사 | 1 | 50 | 23 | 46
 | 보건연구직 |  | 공중보건 | 연구사 | 2 | 113 | 68 | 60.17699115044248
 | 환경연구직 |  | 환    경 | 연구사 | 2 | 136 | 66 | 48.52941176470588
 | 운전기능직 | 유공자 | 운    전 | 10급 | 1 | 5 | 4 | 80
Spreadsheet: 118360d1313620767-countif-or-a-better-solution-pivottable
Sheet: Sheet1

Time | Qty
09:00:00 | 1
09:23:00 | 1
11:25:00 | 1
12:05:00 | 1
13:06:00 | 1
14:12:00 | 1
14:14:00 | 1
15:26:00 | 1
15:40:00 | 1
16:02:00 | 1
17:26:00 | 1
18:30:00 | 1
18:58:00 | 1
19:33:00 | 1
19:59:00 | 1
20:39:00 | 1
Spreadsheet: 878619d1725792527-formula-to-sum-gross-amount-for-specific-invoice-number-and-date-copy123
Sheet: Sheet1

24
6025
6067
39
178
109
8828
142
6932
932
208
367
9634
6240
6109
6269
6268
6270
364
5558
9618
2570
188
598
263
246
632
637
6441
6442
1533
24
25
6647
767
6921
1218
6772
6771
8202
424
852
8825
6769
8834
835
6950
6951
6974
658
5687
931
6770
1242
952
25
427
6996
827
8914
2701
892
1578
482
666
980
67106
8363
299
7268
7270
7269
1670
868
6572
6112
1057
7485
7460
7507
7611
7612
7506
7461
1056
1207
836
1359
1279
7645
5561
7784
67782
4416
8356
7950
7930
7993
8040
841
1362
5568
1748
9377
675
8183
8202
8154
68182
8153
7688
6161
392
237
2694
326
1685
265
8333
8329
8492
8488
8332
8487
8501
8499
8498
2123
8485
855
8336
3938
8537
8599
9904
22351
2900
69
6686
1037
8335
2715
6302
1323
1336
8327
8486
8500
8328
9137
704
SGE 440
4599
8490
6945
9194
9704
111
297
9510
8334
8491
8496
8330
901
1772
9509
723
736
1373
815
9688
910
711
9732
9733
2260
104
47
79
424
8495
4051
34
739
968
8085
63
254
255
282
283
305
732
1841
1418
8331
8489
8502
8497
8494
8804
49
48
46
393
405
4264
3291
634
608
403
582
580
581
Spreadsheet: 06738bdc-0882-4ff8-bda2-adf98a2dc00d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6155 | 30438 | [NAME] | Steyn | RSA | 32 | 00:21:25 | 00:00:00 | 01:06:18 | 00:00:00 | 00:41:28 | 1 | 02:09:11
6155 | 5564 | Zita | Szabo | HUN | 31 | 00:20:36 | 00:00:00 | 01:11:03 | 00:00:00 | 00:42:40 | 2 | 02:14:20
6155 | 12805 | Tayla | Glover | RSA | 35 | 00:21:00 | 00:00:00 | 01:10:36 | 00:00:00 | 00:45:25 | 3 | 02:17:03
6155 | 10743 | [NAME] | [NAME] | RSA | 34 | 00:21:40 | 00:00:00 | 01:09:57 | 00:00:00 | 00:49:54 | 4 | 02:21:33
6155 | 6223 | Florence | [NAME] | USA | 33 | 00:21:56 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 682985d1592414482-array-formula-to-only-retrieve-dates-within-a-specific-year-range-retrieve-dates-within-specific-year
Sheet: Sheet1

Start | year start | End
2018-01-01 00:00:00 |  | 2018-01-15 00:00:00
2018-01-16 00:00:00 |  | 2018-01-31 00:00:00 |  | YEAR | 2019
 | 2018 |  |  | 2020-01-01 00:00:00
 |  |  |  | 2020-01-16 00:00:00
 |  |  |  | 2020-02-01 00:00:00
 |  |  |  | 2020-02-16 00:00:00
 |  |  |  | 2020-03-01 00:00:00
 |  |  |  | 2020-03-16 00:00:00
 |  |  |  | 2020-04-01 00:00:00
 |  |  |  | 2020-04-16 00:00:00
 |  |  |  | 2020-05-01 00:00:00
 |  |  |  | 2020-05-16 00:00:00
 |  |  |  | 2020-06-01 00:00:00
 | 2018 |  |  | 2020-06-16 00:00:00
 |  |  |  | 2020-07-01 00:00:00
 |  |  |  | 2020-07-16 00:00:00
 |  |  |  | 2020-08-01 00:00:00
 |  |  |  | 2020-08-16 00:00:00
 |  |  |  | 2020-09-01 00:00:00
 | 2018 |  |  | 2020-09-16 00:00:00
 |  |  |  | 2020-10-01 00:00:00
 |  |  |  | 2020-10-16 00:00:00
 |  |  |  | 2020-11-01 00:00:00
 |  |  |  | 2020-11-16 00:00:00
 |  |  |  | 2020-12-01 00:00:00
 |  |  |  | 2020-12-16 00:00:00
Spreadsheet: 133b92df-abf7-4ebf-a695-8a71b1d424e3
Sheet: Sheet1

Table 5.1: Maternal mortality rate (maternal deaths per 100,000 livebirths) by country and year | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Country | 1990 | 2000 | 2008
Bahrain | 25 | 23 | 19
Egypt | 220 | 110 | 82
Iraq | 93 | 84 | 75
Jordan | 110 | 79 | 59
Kuwait | 10 | 8 | 9
Lebanon | 52 | 36 | 26
Oman | 49 | 27 | 20
Qatar | 15 | 11 | 8
Saudi Arabia | 41 | 28 | 24
The Sudan | 830 | 770 | 750
Syrian Arab Republic | 120 | 58 | 46
United Arab Emirates | 28 | 15 | 10
Yemen | 540 | 340 | 210
Spreadsheet: 104935d1302394170-updating-budgets-without-skewing-previous-data-otter-repair-shop
Sheet: Summary

Summary | 2011 | Jan QTR 1 | Feb QTR 1 | Mar QTR 1
Otter Parts | Budget | 0.5 | 0.5 | 0.5
 | Expenditures | 0.6 | #N/A | #N/A
Otter Repair | Budget | 16.3 | 16.3 | 16.3
 | Expenditures | 18.5 | #N/A | #N/A
Summary | TOTAL Budgeted | 16.8 | 16.8 | 16.8
 | TOTAL Expenditures | 19.1 | #N/A | #N/A
 | Actual | -2.300000000000001 | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | Employee Code | (All)
 |  |  |  |  | Data |  |  |  |  |  |  |  | Data
 |  |  | Month | Part/Repair | Sum of FTE Budget | Sum of FTE Actual |  |  |  |  | Part/Repair | Month | Sum of FTE Budget | Sum of FTE Actual
 |  |  | Jan | Parts | 32.35 | 32 |  |  |  |  | Parts | Jan | 32.35 | 32
 |  |  |  | Repair | 47.8 | 52 |  |  |  |  |  | Feb | 32.35 | 35.03
 |  |  | Jan Total |  | 80.15 | 84 |  |  |  |  |  | Mar | 32.35 | 33.7
 |  |  | Feb | Parts | 32.35 | 35.03 |  |  |  |  | Parts Total |  | 97.05000000000001 | 100.73
 |  |  |  | Repair | 47.8 | 50.7 |  |  |  |  | Repair | Jan | 47.8 | 52
 |  |  | Feb Total |  | 80.15 | 85.73 |  |  |  |  |  | Feb | 47.8 | 50.7
 |  |  | Mar | Parts | 32.35 | 33.7 |  |  |  |  |  | Mar | 47.8 | 48.9
 |  |  |  | Repair | 47.8 | 48.9 |  |  |  |  | Repair Total |  | 143.4 | 151.6
 |  |  | [NAME] |  | 80.15 | 82.6 |  |  |  |  | Grand Total |  | 240.45 | 252.33
 |  |  | Grand Total |  | 240.45 | 252.33