tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1213cfc8-568e-47f9-b907-7cc1feeb7856
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Bransje:Bedriftsrådgivning
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Råd & Regnskap Akershus AS | Holmav. 20 | 1339 | Vøyenenga | 21 62 70 00 | 850 29 500
Tet | [NAME] g 10 | 3717 | Skien | 35 51 92 30 | 35 51 92 31
Beckman Lundevall Revisjon AS | [NAME]. 70 | 0680 | Oslo | 22 78 28 00 | 22 78 28 01
[NAME] | Kabelg. 2 | 0580 | Oslo | 22 86 50 00 | 22 20 18 01
Akselera Norway AS | Strandv. 37 | 1366 | Lysaker | 952 68 706
Akselera AS | Bredsgården 2 | 5003 | Bergen | 911 91 627
TeamWork OU | [NAME] v 12A | 0484 | Oslo | 22 36 56 10
[NAME] | Filipstad Brygge 1 | 0252 | Oslo | 23 11 42 00 | 23 11 42 01
Russel Reynolds Associates AS | Universitetsg. 7 | 0164 | Oslo | 22 03 80 10
Akselera AS | Strandv. 37 | 1366 | Lysaker | 952 68 706
Intersoft Management Systems AS | Lysaker torg 45 | 1366 | Lysaker | 22 22 63 00
Enova Business Services AS | Astrids v 1 | 1473 | Lørenskog | 67 98 04 20
BearingPoint Norway AS | Tjuvholmen allé 3 | 0252 | Oslo | 24 06 90 00 | 24 06 90 01
Akselera Norway AS | Bredsgården 2 | 5003 | Bergen | 911 91 627
McKinsey & Company Inc Norway | [NAME] g 5 | 0161 | Oslo | 22 86 25 00 | 22 86 26 00
Assessit AS | Kjøpmannsg. 40 | 7011 | Trondheim | 913 75 565
CBA Consultans AS | Klinestadmoen 9 | 3241 | Sandefjord | 454 14 600
ISCO Group AS | Oscars g 23 | 0352 | Oslo | 22 06 87 00 | 22 06 87 01
Astanel AS | Gamlev. 33 | 6065 | Ulsteinvik | 900 27 234
Elverum Regnskapsservice AS | Storg. 17 | 2408 | Elverum | 62 42 26 02 | 62 42 26 49
EH Consulting | Sykehusg. 30 | 8613 | Mo i Rana | 906 14 830
Tingvoll Næringsforum | Gunnars v 10 | 6630 | Tingvoll | 71 53 31 66
Strategica People and Processes AS | Bogstadv. 30 | 0355 | Oslo | 23 36 60 52
Headvisor AS | Grensen 16 | 0159 | Oslo | 22 47 65 50 | 22 41 30 00
Holte Consulting AS | Drammensv. 147A | 0277 | Oslo | 22 04 95 00
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 35054d1232536730-changing-sheet-name-reference-automatically-purchases-compilation
Sheet: SUMMARY

 | PERIOD |  |  |  |  | WEEK 1 |  |  |  | WEEK 2 |  |  |  | WEEK 3 |  |  |  | WEEK 4
 | SALES TARGET | GP TARGET | [NAME] | CLOSING GP% DECLARED | ACTUAL GP% | SALES | PURCHASES | REMAINING SPEND | GP% ACHIEVED | SALES | PURCHASES | REMAINING SPEND | GP% ACHIEVED | SALES | PURCHASES | REMAINING SPEND | GP% ACHIEVED | SALES | PURCHASES | REMAINING SPEND | GP% ACHIEVED
fma | 0 | 0 | 0 |  |  | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A
B&B | 0 | 0 | 0 |  |  | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A
ot | #N/A | 0 | 0 |  |  | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A
kw4 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A
 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A
 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A
 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A
 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A
 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A
 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A
 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A
Spreadsheet: 857027d1706118432-number-crunching-for-stocks-excel-formula-question
Sheet: Sheet1

 | I'm trying to get a single formula that will count how many times the High Price is up 20 or more at the same time that the Close Price is up 15 but up less than 21. Answer in this case should be 6. My solution was to create columns 4 and 5 and then count whenever they were both "yes". I'm wondering if I can make a single formula to get the answer I need from the data in column 2 and column 3. The reason is because I have a ton more data sets to attach and I don't want to break it down every time.
 | Column 1 | Column 2 | Column 3 | Column 4 | Column 5
 | Start Price | High Price | Close Price
 | 100 | 121 | 118 |  |  |  | COUNTIFS(E14:E28,"=Yes",(F14:F28),"=Yes")
 | 100 | 111 | 101
 | 100 | 129 | 120
 | 100 | 135 | 119
 | 100 | 114 | 112
 | 100 | 130 | 122
 | 100 | 140 | 117
 | 100 | 123 | 122
 | 100 | 127 | 116
 | 100 | 118 | 112
 | 100 | 130 | 121
 | 100 | 119 | 105
 | 100 | 125 | 119
 | 100 | 166 | 144
 | 100 | 128 | 113
Spreadsheet: 35627d1233214598-returning-multiple-results-for-one-lookup-value-multivalue-return-vlookups
Sheet: Data

Counter | 19 | COO | Quantity | COLOR | CUTTING RATIO | 1ST COST
28711 | 2871 | USA | 352 | SILVERSTAR | XS-XL | 9.25
28791 | 2879 | USA | 350 | WHITE | XS-XL | 8.9
28961 | 2896 | USA | 502 | BLACK | XS-XL | 9.95
28561 | 2856 | USA | 600 | BLACK | XS-XL | 5.7
28641 | 2864 | USA | 300 | PINK | XS-XL | 6
28642 | 2864 | USA | 200 | GOLD | XS-XL | 6
28281 | 2828 | USA | 450 | YELLOW | XS-XL | 6.3
27841 | 2784 | USA | 300 | RED PEPPER | XS-XL | 5.5
27842 | 2784 | USA | 200 | AEGEAN SEA | XS-XL | 5.5
27501 | 2750 | USA | 250 | RED PEPPER | XS-XL | 5.71
27502 | 2750 | USA | 22 | CAVE | XS-XL | 5.6
Spreadsheet: darrell_schoolcraft__7807__imbalsumm0108
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-07-31 00:00:00 |  | 1162786.04
2001-08-20 00:00:00
60874 | 3348
78169
500235
500248
500251
500254
500255 |  |  |  | 4840.73
500262 |  |  |  | 67.24
500267
Duke Energy Trading and Marketing
Contract  24693
2001-07-31 00:00:00 |  | 275313.72
2001-08-20 00:00:00
9164
9167
Duke Energy Trading and Marketing
Contract  24361 |  |  |  | CBS Volume | 24268 | 24693 | 24361
 |  |  |  |  | 223026 | 117857 | 138810
2001-07-31 00:00:00 |  | 732710.21
2001-08-20 00:00:00 |  |  |  |  |  |  | 21665 | 36403
500241 |  |  |  |  |  |  | 22664 | 18932
500391 | 5161 |  |  |  |  |  | 20248 | 43064
500392 | 1105 |  |  |  |  |  | 25873 | -17
 |  |  |  |  |  |  | 26758 | -149
 |  |  |  |  |  |  | 26372 | 1467
 |  |  |  |  |  |  | 26700 | 1970
 |  |  |  |  |  |  | 26422 | 3940
 |  |  |  |  |  |  | 26661 | 28550
 |  |  |  |  |  |  | 27291 | -3361
Duke Energy Trading and Marketing |  |  |  |  |  |  | 27137 | -8
21665 | oba | 73449.16 | POI 9109 Mobil Waha Plant |  |  |  | 27123 | -1347
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant
20248 | trans | 141061.91
25873 |  | -259
26758 |  | -596
26372 |  | 2997.09
26700 |  | 4077.9
26422 |  | 8155.8
26661 |  | 146862.35
27291 |  | -17965
27137 |  | -67.28
27123 |  | -6425.19
Spreadsheet: 215518d1361396205-num-error-sample
Sheet: Sheet1

 | IN | Out | In | Out
2013-03-04 00:00:00
2013-03-05 00:00:00
2013-03-06 00:00:00
2013-03-07 00:00:00
2013-03-08 00:00:00
2013-03-09 00:00:00 | UNSCHEDULED
2013-03-10 00:00:00 | UNSCHEDULED
2013-03-11 00:00:00
2013-03-12 00:00:00
2013-03-13 00:00:00
2013-03-14 00:00:00
2013-03-15 00:00:00
2013-03-16 00:00:00 | UNSCHEDULED
2013-03-17 00:00:00 | UNSCHEDULED
Spreadsheet: 832079d1686109085-identify-hostname-by-finding-from-a-string-of-ip-address-in-a-cell-findhostnamefromipadd
Sheet: Sheet1

Data
Hostname | IP address | Status
Hostname1 | Upstream 10.145.1888.0 Downstream 10.16.123.423 Backup 50.45.778.777 Management 11.18.142.785 | Decom
Hostname2 | 11.12.184.35 (U) 12.17.77.47 (B) 13.122.77.45 (M) | Active
Hostname3 | 11.14.22.56  12.15.99.56  13.16.177.36  14.17.188.36 | Pending Decom
Need a Solution to find hostname from below IP addreass
IP address Given | Need to find the hostname | Status
10.16.123.423
13.122.77.45
12.15.99.56
Spreadsheet: 25268d1216407265-last-date-used-example-excel-issue
Sheet: Item List

Last Date Purchased | Last Date Sold | Last Date Adjusted | Item No. | Description
 |  |  | 51660 | WIF WIX FILTERS
 |  |  | 51664 | WIX FILTER
 |  |  | 51669 | WIX OIL FILTER
 |  |  | 51673 | WIF WIX FILTER
 |  |  | 51674 | WIX FUEL FILTER
 |  |  | 51675 | WIF WIX FILTERS
 |  |  | 51678 | WIX FILTER
 |  |  | 51683 | WIF WIX FILTERS
 |  |  | 51694 | FILTER
 |  |  | 51720 | WIX HYDRAULIC FILTER
Spreadsheet: 680998d1591293109-count-unique-non-blank-cells-with-criteria-counting-cells-help
Sheet: Sheet1

 |  |  | COUNT
Organization Name | Transaction Type Name | Trans Reference | Meets Criteria? | Count Unique
[NAME] | Miscellaneous issue |  |  |  |  | [NAME]
[NAME] | Miscellaneous issue | RM02 - 0354056 |  |  |  | Miscellaneous Issue
[NAME] | Miscellaneous issue | RM02 - 0354056 |  |  |  | ???
WW1 WATERWORKS MARROWBONE LANE | Miscellaneous issue | RM02 - 0354056
[NAME] | Miscellaneous issue | RM02 - 0354056
[NAME] | Miscellaneous issue | RM02 - 0354056
[NAME] | Miscellaneous issue | RM02 - 0354056
[NAME] | Miscellaneous issue | RM02 - 0354056
[NAME] | Miscellaneous receipt | RM02 - 0354056
[NAME] | Miscellaneous receipt | RM02 - 0354056
[NAME] | Miscellaneous receipt | RM02 - 0354204
[NAME] | Miscellaneous receipt | RM02 - 0354204
WM1 WASTE MANAGEMENT | Miscellaneous issue | WM 13405 MARK LAWLOR
WM1 WASTE MANAGEMENT | Miscellaneous issue | WM 13405 MARK LAWLOR
WM1 WASTE MANAGEMENT | Miscellaneous issue | WM 13405 MARK LAWLOR
WW1 WATERWORKS MARROWBONE LANE | Miscellaneous issue
WW1 WATERWORKS MARROWBONE LANE | Miscellaneous issue
WW1 WATERWORKS MARROWBONE LANE | Miscellaneous issue
WW1 WATERWORKS MARROWBONE LANE | Miscellaneous issue
WW1 WATERWORKS MARROWBONE LANE | Miscellaneous issue | 36
WW1 WATERWORKS MARROWBONE LANE | Miscellaneous issue | 36
[NAME] | Miscellaneous issue | 36
HM1 HOUSING AND COMMUNITY | Miscellaneous issue | 23051
Spreadsheet: 675197d1588191344-average-of-last-3-shifts-matching-day-of-week-pt-showing-tips-by-dow
Sheet: Sheet1

Date | Past Shifts | Helper |  | Average of 3 Previous Shifts on That Day
Wednesday | 80
Thursday | 85
Friday | 67 |  |  | Helper | (Multiple Items)
Saturday | 54
Sunday | 60 |  |  | Row Labels | Sum of Past Shifts | Average of Past Shifts2
Tuesday | 79 |  |  | Sunday | 97 | 97
Monday | 43 |  |  | Monday | 181 | 60.33333333333334
Wednesday | 58 |  |  | Tuesday | 69 | 69
Friday | 75 |  |  | Wednesday | 148 | 49.33333333333334
Saturday | 52 |  |  | Friday | 181 | 60.33333333333334
Monday | 96 |  |  | Saturday | 191 | 63.66666666666666
Tuesday | 74 |  |  | Grand Total | 867 | 61.92857142857143
Wednesday | 33
Monday | 40
Friday | 58
Saturday | 82
Sunday | 87
Wednesday | 53
Friday | 61
Saturday | 63
Monday | 71
Tuesday | 69
Wednesday | 62
Monday | 70
Friday | 62
Saturday | 46
Sunday | 97
Monday |  |  |  |  | = Average Of Last 3 Mondays
Wednesday
Thursday
Spreadsheet: john_zufferli__16702__2QYTD Orig2
Sheet: Top 10 By Power

June YTD 2001 Top 10 Power Originators by Value
Originator | Commodity | Team | Total
[NAME] | Power | West
[NAME] | Power | West | 36360000
Zufferli | Power | Canada
[NAME] | Power | West | 18123000
Calger | Power | Canada | 10784435
Kroll | Power | Southeast | 7261000
Ader | Power | Northeast | 5456000
[NAME] | Power | Northeast | 3000000
Miller/Zisman | Power | Asset Marketing | 3000000
Curry | Power | [NAME] | 2351866
Total
Spreadsheet: 5ebb39e6-7b02-4226-b82e-23eb7215cc6f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7670 | 46507 | [NAME] | Van Huysteen | RSA | 0 | 00:14:21 | 00:00:00 | 01:06:27 | 00:00:00 | 00:26:51 | 1 | 01:47:41
7670 | 57855 | [NAME] | Sloan | RSA | 0 | 00:16:38 | 00:00:00 | 01:08:02 | 00:00:00 | [NAME] | 2 | 01:53:16
7670 | 57856 | [NAME] | [NAME] | RSA | 0 | 00:14:22 | 00:00:00 | 01:10:32 | 00:00:00 | 00:29:49 | 3 | 01:54:44
Spreadsheet: 113419d1309339307-find-large-or-max-with-logical-values-book1
Sheet: Sheet1

9Ad Estimated Level 201011 Round 2 | 9Ad Estimated Level~2 201011 Round 3 | 9Ad Estimated Level~3 201011 Round 4 | 9Ad Estimated Level~4 201011 Round 5 | Highest
4b | 4b | 4a | 5c
5b | 5b | 5b | 6b
4b | 4b | 4b | 4a
4b | 4b | 4b | 4b
4b | 4b | 4b | 4b
4c | 4c | 4c | 4b
Spreadsheet: 42909d1241539355-concatenate-concatif-trades
Sheet: Sheet1

Firm | Deal number | Counterparty Name | Nature of Deal | Description | Date of payment | Amount | Currency
 | 12 | PNB | Investment / Increase | Investment / Increase | 2008-12-30 00:00:00 | -34000000 | GBP - | 12 GBP - GBP + GBP +
 | 12 | PNB | Nominal interest | Investment / Nominal Interest | 2008-12-31 00:00:00 | 1210.96 | GBP + | 12 GBP - GBP + GBP +
 | 12 | PNB | Final repayment | Investment / Final Repayment | 2008-12-31 00:00:00 | 34000000 | GBP + | 12 GBP - GBP + GBP +
 | 33 | PNB | Investment / Increase | Investment / Increase | 2007-01-30 00:00:00 | -53000000 | GBP - | 33 GBP - GBP + GBP +
 | 33 | PNB | Nominal interest | Investment / Nominal Interest | 2007-01-31 00:00:00 | 2032.88 | GBP + | 33 GBP - GBP + GBP +
 | 33 | PNB | Final repayment | Investment / Final Repayment | 2007-01-31 00:00:00 | 53000000 | GBP + | 33 GBP - GBP + GBP +
 | 36 | PNB | Sell foreign exchange | Sell Foreign Exchange | 2008-12-31 00:00:00 | -1100000 | EUR - | 36 EUR - GBP +
 | 36 | PNB | Buy foreign exchange | Buy Foreign Exchange | 2008-12-31 00:00:00 | 1065240 | GBP + | 36 EUR - GBP +
 | 89 | PNB | Borrowing / Increase | Borrowing / Increase | 2009-01-30 00:00:00 | 7000000 | GBP + | 89 GBP + GBP - GBP -
 | 89 | PNB | Final repayment | Borrowing / Final Repayment | 2009-02-02 00:00:00 | -7000000 | GBP - | 89 GBP + GBP - GBP -
 | 89 | PNB | Nominal interest | Borrowing / Nominal Interest | 2009-02-02 00:00:00 | -1726.03 | GBP - | 89 GBP + GBP - GBP -
 | 92 | OBC | Sell foreign exchange | Sell Foreign Exchange | 2009-02-27 00:00:00 | -30993.3 | GBP - | 92 GBP - USD +
 | 92 | OBC | Buy foreign exchange | Buy Foreign Exchange | 2009-02-27 00:00:00 | 58685.81 | USD + | 92 GBP - USD +
Spreadsheet: 104803d1302264285-help-with-define-name-and-auto-updating-graphs-names1
Sheet: 4A

Month | Count
2009-02-01 00:00:00
2009-03-01 00:00:00 | 1 |  | Sum | Mean
2009-04-01 00:00:00
2009-05-01 00:00:00 | 2
2009-06-01 00:00:00 | 1
2009-07-01 00:00:00
2009-08-01 00:00:00
2009-09-01 00:00:00 | 1
2009-10-01 00:00:00 | 1
2009-11-01 00:00:00 | 2
2009-12-01 00:00:00
2010-01-01 00:00:00
2010-02-01 00:00:00
2010-03-01 00:00:00
2010-04-01 00:00:00 | 1
2010-05-01 00:00:00 | 2
2010-06-01 00:00:00
2010-07-01 00:00:00
2010-08-01 00:00:00
2010-09-01 00:00:00 | 1
2010-10-01 00:00:00 | 1
2010-11-01 00:00:00 | 1
2010-12-01 00:00:00
2011-01-01 00:00:00 | 1
2011-02-01 00:00:00 | 1
2011-03-01 00:00:00 | 1
Spreadsheet: 73986d1274565417-how-to-hide-remove-eliminate-n-a-symbol-sample
Sheet: Sheet2

Summary
Dates: 05/01/2010 to 05/01/2010
Agent Group: Accel Team
Agent | ID | Calls Handled
Totals: |  | 4392
Name, First1 | 001 | 118
Name, First10 | 034 | 114
Name, First11 | 035 | 88
Name, [NAME] | 012 | 16
Name, First13 | 013 | 89
Name, First14 | 014 | 105
Name, First15 | 015 | 85
Name, First16 | 016 | 145
Name, First17 | 017 | 103
Name, First18 | 018 | 109
Name, First19 | 019 | 37
Name, First2 | 026 | 127
Name, First20 | 020 | 122
Name, First21 | 021 | 14
Name, First22 | 022 | 112
Name, First23 | 023 | 56
Name, First24 | 024 | 133
Name, First25 | 025 | 103
Name, First26 | 002 | 96
Name, [NAME] | 003 | 141
Name, First28 | 004 | 112
Name, First29 | 005 | 0
Name, First3 | 027 | 108
Name, First30 | 006 | 34
Name, First31 | 007 | 159
Name, First32 | 008 | 116
Name, First33 | 009 | 112
Name, First34 | 010 | 127
Name, First35 | 011 | 125
Name, First36 | 036 | 136
Name, First37 | 037 | 166
Name, First38 | 038 | 4
Name, First39 | 039 | 114
Name, First4 | 028 | 100
Name, First40 | 040 | 15
Name, First41 | 041 | 96
Name, First42 | 042 | 0
Name, [NAME] | 043 | 115
Name, First44 | 044 | 159
Name, First45 | 045 | 148
Name, First5 | 029 | 136
Name, First6 | 030 | 146
Name, First7 | 031 | 22
Name, First8 | 032 | 139
Name, First9 | 033 | 90
Spreadsheet: 10881c33-a5e6-4a8e-8382-b42ee79474b5
Sheet: Sheet1

CERTIFICATION TEST PASS RATES*  ([NAME] and Updated 11/7/11)
 | COMPLETION YEAR 2005 |  |  |  |  |  | COMPLETION YEAR 2006 |  |  |  |  |  | COMPLETION YEAR 2007 |  |  |  |  |  | COMPLETION YEAR 2008 |  |  |  |  |  | COMPLETION YEAR 2009 |  |  |  |  |  | COMPLETION YEAR 2010 |  |  | COMPLETION YEAR 2011
 | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | FINAL |  |  | FINAL
Name of Test | Tests Taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate
English (8-12) | 1 | 1 |  | 1 | 1 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
English Language Arts and Reading 8-12 | 6 | 6 |  | 6 | 6 |  | 4 | 4 |  | 4 | 4 |  | 9 | 9 |  | 9 | 9 |  | 7 | 7 |  | 8 | 8 | 1 | 9 | 9 | 1 | 9 | 9 | 1 | 8 | 8 | 1 | 10 | 10 | 1
*Data obtained from Texas Education Agency's Accountability System for Educator Preparation (ASEP) report on pass rates sorted by Test.
*2010 Texas Education Agency starting using one yearly pass rate.
Spreadsheet: 822074d1679076006-validation-rules-and-forms-validation-form
Sheet: Sheet 1

Surveryor Name | Date | Section | Route | [NAME] | End [NAME] | Comments
[NAME] | 2023-02-22 00:00:00 | 1 | 1a | 5 | 5.1 | hello
[NAME] | 2023-02-22 00:00:00 | 5 | 2a | 6 | 6.1 | hello
 |  | 5 | 3a | 4 | 4.1 | hello
Spreadsheet: 631829d1562854812-distance-between-coordinates-shown-in-a-sorted-list-distance_between_locations_dummy_v5
Sheet: Data

Location ID | Coordinate X | Coordinate Y |  | Location 2 ID | Coordinate X | Coordinate Y
PG343 | 646860 | 248249 |  | AABF | 646900 | 248300
PL122 | 646860 | 248249 |  | AG_7513A | 646892 | 248306
[NAME] | 647150 | 249980 |  | AASI | 647120 | 249890
KO420 | 665069 | 259111 |  | BABS | 665160 | 259100
OL942 | 656550 | 256150 |  | ZH955-1 | 656550 | 256080
PY492 | 643443 | 237911 |  | [NAME] | 643446 | 237913
PT940 | 643443 | 237911 |  | BORA | 643443 | 237911
HY675 | 655820 | 257720 |  | BRWI | 655855 | 257640
[NAME] | 656260 | 249240 |  | LELI | 656260 | 249245
KH387 | 648322 | 246675 |  | AG_0501B | 648321 | 246674
UB482 | 655642 | 247923 |  | LEST | 655550 | 247900
HF029 | 653510 | 246900 |  | SCHH | 653505 | 246900
RH392 | 653510 | 246900 |  | AG_0627A | 653506 | 246892
LN392 | 671310 | 243990 |  | AG_4190C | 671310 | 243990
ES492 | 650560 | 236088 |  | SCRU | 650560 | 236088
NJ111 | 656622 | 232628 |  | MEKE | 656695 | 232660
LK392 | 656622 | 232628 |  | AG_0034A | 656690 | 232656
KL329 | 635070 | 236500 |  | VORD | 635040 | 236405
GF329 | 635070 | 236500 |  | AG_0712A | 635039 | 236404
DF392 | 633251 | 239845 |  | ROIN | 633190 | 239830
DR029 | 638611 | 263271 |  | SUPF | 638611 | 263271
SD932 | 637023 | 261981 |  | HEKO | 637023 | 261966
WE942 | 637023 | 261981 |  | AG_4616A | 637022 | 261980
DE902 | 668849 | 245006 |  | AG212-1 | 668855 | 245017
[NAME] | 665580 | 258800 |  | BADE | 665550 | 258890
RH992 | 665580 | 258800 |  | ZH246-1 | 665590 | 258845
LR012 | 645850 | 249150 |  | AG_7519A | 645878 | 249108
[NAME] | 665470 | 258450 |  | AG959-1 | 665400 | 258399
OR654 | 668855 | 245017 |  | AG082-2 | 668849 | 245006
Spreadsheet: 772912d1647524259-vlookup-on-data-table-based-on-month-year-to-date-test
Sheet: V1

 | 1 |  |  |  |  |  | Year-To-Date
 | Account Descriptions | Actual | Budget | [NAME] | Var % |  | Actual | Budget | [NAME] | Var %
 | Revenue
OD.R1 | Revenue | 1000000 |  |  |  |  | 2000000 | 1850000
 | Total Revenue
Spreadsheet: 85781d1285812214-counting-weeknumber-weeknum
Sheet: Sheet1

DATE | DAY | WEEK NUMBER
2010-09-26 00:00:00 | Sun | 39
2010-09-27 00:00:00 | Mon | 39
2010-09-28 00:00:00 | Tue | 39
2010-09-29 00:00:00 | Wed | 39
2010-09-30 00:00:00 | Thu | 39
2010-10-01 00:00:00 | Fri | 39
2010-10-02 00:00:00 | Sat | 39
2010-10-03 00:00:00 | Sun | 40
2010-10-04 00:00:00 | Mon | 40
2010-10-05 00:00:00 | Tue | 40
2010-10-06 00:00:00 | Wed | 40
2010-10-07 00:00:00 | Thu | 40
2010-10-08 00:00:00 | Fri | 40
2010-10-09 00:00:00 | Sat | 40
2010-10-10 00:00:00 | Sun | 41
2010-10-11 00:00:00 | Mon | 41
2010-10-12 00:00:00 | Tue | 41
2010-10-13 00:00:00 | Wed | 41
2010-10-14 00:00:00 | Thu | 41
2010-10-15 00:00:00 | Fri | 41
2010-10-16 00:00:00 | Sat | 41
2010-10-17 00:00:00 | Sun | 42
2010-10-18 00:00:00 | Mon | 42
2010-10-19 00:00:00 | Tue | 42
2010-10-20 00:00:00 | Wed | 42
2010-10-21 00:00:00 | Thu | 42
2010-10-22 00:00:00 | Fri | 42
2010-10-23 00:00:00 | Sat | 42
2010-10-24 00:00:00 | Sun | 43
Spreadsheet: 824679d1680768830-substitute-formula-against-filter-function-in-older-version-of-excel-s666-pq-matching-and-extracting_v2g
Sheet: Main Data

 |  |  |  |  | Required Result
 | ID | Movies /Free Movies | Ticket In Price |  | Shows | Ticket In Price | Difference |  | Shows | Ticket In Price | Subtraction
 | 125 | Tomorrow Never Dies | 99 |  |  |  |  |  | Night Show | 144 | 21
 | 145 | Avatar | 109 |  |  |  |  |  | Night Show | 109 | 21
 | 115 | Bahubali | 144 |  |  |  |  |  | Night Show | 44
 | 196 | Rambo | 44 |  |  |  |  |  | Night Show | 25
 | 188 | Rambo | 25 |  |  |  |  |  | Morning Show | 84
 | 101 | Brahmastra | 84
 | 151 | Bhola | 211
 | 199 | A AA 2 | 65
 | 121 | Oh Baby | 120
Spreadsheet: 742515d1627831293-category-subcategory-expense-type-on-transactions-sheet-category-test-1-
Sheet: Category

 | Add custom categories and subcategories below, then assign them to your transactions in the transactions sheet. You can only edit or delete the categories and subcategories you've added.
 | Categories |  |  | Subcategories
 | Category name | Category type |  | Category name | Subcategory name
 | Bills/Utilities | Expense |  | Bills/Utilities | Cell Phones
 | Fees/Charges | Expense |  | Bills/Utilities | Electric
 | Food | Expense |  | Bills/Utilities | Internet
 | Housing | Expense |  | Bills/Utilities | Propane
 | Income | Income |  | Food | Beer | Wine
 | Insurance | Expense |  | Food | Cat Food
 | Payment | Expense |  | Food | Chicken Food
 | Recreation & Entertainment | Expense |  | Food | Dining Out
 | Refund | Expense |  | Food | Groceries
 | Shopping | Expense |  | Housing | Home Maintenance
 | Transfer | Expense |  | Housing | Home Repairs
 | Transportation | Expense |  | Housing | Household Goods
 | Travel | Expense |  | Housing | Lawn | Garden | Pool
 | Uncategorized | Expense |  | Housing | Mortgage
 |  |  |  | Housing | Rent
 |  |  |  | Income | Century
 |  |  |  | Income | Concentra
 |  |  |  | Income | Income | Other
 |  |  |  | Insurance | Auto Insurance
 |  |  |  | Insurance | Health Insurance
 |  |  |  | Insurance | Home Insurance
 |  |  |  | Recreation & Entertainment | Amazon Prime
 |  |  |  | Recreation & Entertainment | Movies
 |  |  |  | Recreation & Entertainment | Music
 |  |  |  | Recreation & Entertainment | Netflix
 |  |  |  | Recreation & Entertainment | Peacock
 |  |  |  | Recreation & Entertainment | Sporting Events
 |  |  |  | Recreation & Entertainment | Spotify
 |  |  |  | Transportation | Auto Maintenance
 |  |  |  | Transportation | Auto Payments
 |  |  |  | Transportation | Auto Repairs
 |  |  |  | Transportation | Fuel | Car Wash
 |  |  |  | Transportation | Parking Fees
 |  |  |  | Transportation | Registration | DMV Fees