tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 106205d1303389823-simultaneous-updating-worksheets-overdue-ageing-1-
Sheet: CENTRAL

NAME OF THE COMPANY |  |  | ABC & CO
 |  |  | CENTRAL ZONE
DETAILS OF AGE-WISE DEBTORS REPORT AS ON |  |  | 2011-04-15 00:00:00
Name of the Party | Party Status | Invoice Date | Invoice No. | Credit Period | Due Date | Delay (Days) | Invoice Amount | Outstanding Invoice Amount (Rs.) | < 0 | <0 - 30> | <31 - 60> | <61 - 90> | <91 - 120> | <121 - 150> | <151 - 180> | > 180 Days
TRINITY ASSOCIATES | Dealer | 2010-12-19 00:00:00 | 450 | 60 | 2011-02-17 00:00:00 | 57 | 1439282 | 48639 | 0 | 0 | 48639 | 0 | 0 | 0 | 0 | 0
GLASSWARE SHOPPING | Dealer | 2011-01-11 00:00:00 | 477 | 60 | 2011-03-12 00:00:00 | 34 | 125040 | 38 | 0 | 0 | 38 | 0 | 0 | 0 | 0 | 0
HYDRA PLATE AGENCY | Dealer | 2011-01-31 00:00:00 | 506 | 60 | 2011-04-01 00:00:00 | 14 | 2087462 | 2087462 | 0 | 2087462 | 0 | 0 | 0 | 0 | 0 | 0
ROCKY COATINGS | Dealer | 2011-02-22 00:00:00 | 570 | 60 | 2011-04-23 00:00:00 | -8 | 72000 | 180 | 180 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GOLANG FABRICAION | Dealer | 2011-03-20 00:00:00 | 620 | 60 | 2011-05-19 00:00:00 | -34 | 316800 | 316800 | 316800 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL OVERDUE AS ON DATE |  |  |  |  |  |  | 4040584 | 2453119 | 316980 | 2087462 | 48677 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 775955d1649411741-summary-of-appointments-in-date-and-time-order-pq-summary-list-sorted-aligw
Sheet: Desired OutputName

Appointments
Date | Time | Name | Column1 |  | 2022 Appt | Time | First Name | Surname
2022-04-19 00:00:00 | 12:30:00 | [NAME] | Jones |  | 2022-04-19 00:00:00 | 12:30:00 | [NAME] | Jones
2022-04-19 00:00:00 | 13:30:00 | [NAME] | [NAME] |  | 2022-04-19 00:00:00 | 13:30:00 | [NAME] | [NAME]
2022-04-19 00:00:00 | 14:30:00 | [NAME] | Smith |  | 2022-04-19 00:00:00 | 14:30:00 | [NAME] | Smith
2022-04-20 00:00:00 | 12:30:00 | Connor | Bloggs |  | 2022-04-20 00:00:00 | 12:30:00 | Connor | Bloggs
2022-04-20 00:00:00 | 13:30:00 | Kristy | Edwards |  | 2022-04-20 00:00:00 | 13:30:00 | Kristy | Edwards
2022-04-20 00:00:00 | 14:30:00 | [NAME] | [NAME] |  | 2022-04-20 00:00:00 | 14:30:00 | [NAME] | [NAME]
2022-04-21 00:00:00 | 12:30:00 | Martin | [NAME] |  | 2022-04-21 00:00:00 | 12:30:00 | Martin | [NAME]
2022-04-21 00:00:00 | 13:30:00 | [NAME] | Jones |  | 2022-04-21 00:00:00 | 13:30:00 | [NAME] | Jones
2022-04-21 00:00:00 | 14:30:00 | Lewis | Smith |  | 2022-04-21 00:00:00 | 14:30:00 | Lewis | Smith
2022-04-22 00:00:00 | 09:00:00 | [NAME] | [NAME] |  | 2022-04-22 00:00:00 | 09:00:00 | [NAME] | [NAME]
2022-04-22 00:00:00 | 10:00:00 | [NAME] | Fritz |  | 2022-04-22 00:00:00 | 10:00:00 | [NAME] | Fritz
Spreadsheet: 796825d1663584662-help-regarding-automatically-updating-data-in-source-sheet-sheet-1
Sheet: april

175 | 2022-04-21 00:00:00 | Cold fusion | Sector-68 | 12:10:00 | 12:50:00 | Indeerjeet | owner | 9888801265 | QSR | Existing | fun foods | 6 | no
176 | 2022-04-21 00:00:00 | Coffee full Day | Sector-34C | 01:00:00 | 02:00:00 | Shankar | Owner | 9417133209 | QSR | New | Veeba | 20 | No
177 | 2022-04-21 00:00:00 | Pizza house 34 | Sector-34C | 03:00:00 | 03:45:00 | kamal | Owner | 8699174282 | QSR | New | Veeba | 15 | No
178 | 2022-04-21 00:00:00 | Master [NAME] | Sector-34C | 04:00:00 | 04:45:00 | Ritesh | Owner | 7719675199 | QSR | New | Veeba | 15 | No
179 | 2022-04-21 00:00:00 | Hunger hackers | Sector37-D | 05:10:00 | 05:30:00 | Manish sharma | Owner | 7710500995 | QSR | New | veeba | 5 | NO
Spreadsheet: 0a57f8c7-ca10-4769-b9b3-89605e2528e2
Sheet: Sheet1

2003 - 47th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Starting Point: | Arc-et-Senans, France |  |  |  | 2003-09-14 00:00:00
Rank | Team Name | Pilot/Co-Pilot | Registration | Flight Time | Landing position | Distance (km) | Launch Time (UTC) | Landing Time (UTC)
1 | France 1 | Leys, [NAME], [NAME] | F-PPSE | 1900-01-02 05:42:00 | Tinhosa, Portugal | 1596.5
2 | United States 1 | [NAME], [NAME] | N96YD |  | Torroal, Portugal | 1519.9
 |  | [NAME], [NAME] |  | 1900-01-01 17:08:00
3 | Belgium 1 | De Cock, [NAME] | OO-BCX |  | [NAME], Spain | 1422.7
 |  | [NAME], [NAME] |  | 1900-01-01 17:51:00
4 | Germany 1 | Eimers, [NAME] | D-OOWE |  | [NAME], Spain | 1050.3
 |  | Landsmann, Bernd |  | 1900-01-01 06:42:00
5 | [NAME] | Wagner, [NAME] | [NAME] |  | Salazar de Amaya, Spain | 928.1
 |  | Scherzer, Sepp |  | 17:10:00
6 | Belgium 2 | [NAME], [NAME] | D-OBYN |  | Hourtin, France | 572.2
 |  | [NAME] |  | 10:41:00
7 | United States 3 | [NAME], [NAME] | D-OWNT |  | St. Helene, France | 559
 |  | [NAME], [NAME] |  | 10:41:00
8 | [NAME] | Stuerzlinger, [NAME] | D-ORZL |  | Rochefort, France | 528.6
 |  | Fuerstner, [NAME] |  | 14:33:00
9 | United Kingdom 1 | Folkes, [NAME] | HB-BJS |  | Guiard, France | 518.4
 |  | Butter, [NAME] |  | 10:13:00
10 | Switzerland 2 | Frieden, Kurt | HB-QHJ |  | [NAME], France | 517.5
 |  | Zeberli, [NAME] |  | 15:10:00
11 | Germany 2 | Schmöhl, Klaus | D-OWBA |  | La Rochelle, France | 510
 |  | Göhrmann, Bernd |  | 11:25:00
12 | France 2 | Villey-Desmeserets, [NAME] | F-GIRE |  | La Pierre Percee, France | 498.8
 |  | [NAME], [NAME] |  | 09:04:00
13 | United States 2 | Vitanza, Louis | N6395V |  | Fontenelle, France | 491
 |  | Padelt, [NAME] |  | 08:44:00
14 | Germany 3 | [NAME], Heinrich/ | D-OBCW |  | [NAME], France | 487,00
 |  | Huthmacher, [NAME] |  | 11:33:00
15 | Sweden 1 | Akerstedt, [NAME] | D-OWML |  | Cognac, France | 483.1
 |  | Balkedal, Jan |  | 14:05:00
 | Switzerland 1 | [NAME], [NAME] | D-OCFT |  |  | 0
16 |  | Vollenweider, [NAME] |  | No Takeoff
 | Switzerland 3 | Stoll, Christian | HB-QHP |  |  | 0
16 |  | Najer, [NAME] |  | No Takeoff
Spreadsheet: c2ee2825-983e-4c3f-bf9d-d929f723314e
Sheet: 2014-2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Music
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 138049d1327500886-help-with-a-huge-if-formula-table
Sheet: Sheet1

Goal 90% | 94%-100% | 92%-93.99% | 90%-91.99% | 88%-89.99% | 86%-87.99% | <86%
PTS | 20 | 16 | 12 | 8 | 4 | 0
[NAME] 7% | <4% | 4%-5.99% | 6%-7.99% | 8%-9.99% | 10% - 10.99% | >11%
PTS | 15 | 12 | 9 | 6 | 3 | 0
Goal  ≥ 40% | 30%-100% | 25%-29.99% | 20%-24.99% | 15% - 19.99% | 10% - 14.99% | <10%
PTS | 25 | 20 | 15 | 10 | 5 | 0
Goal  ≥ 60% | 40%- 100% | 35% - 39.99% | 30% - 34.99% | 25%-29.99% | 20%-24.99% | <20%
PTS | 10 | 8 | 6 | 4 | 2 | 0
Goal 9.5 | 9.8-10.0 | 9.7-9.79 | 9.6-9.69 | 9.5-9.59 | 9.4-9.49 | <9.4
PTS | 30 | 25 | 20 | 15 | 10 | 0
Spreadsheet: 679007d1590153381-combining-countif-with-lookup-and-counting-averages-where-data-might-not-exist-golf-2020_draft_version2
Sheet: CourseData

Course | 9 hole par | 18 hole par |  | Par Hole 1 | Par Hole 2 | Par Hole 3 | Par Hole 4 | Par Hole 5 | Par Hole 6 | Par Hole 7 | Par Hole 8 | Par Hole 9 | Par Hole 10 | Par Hole 11 | Par Hole 12 | Par Hole 13 | Par Hole 14 | Par Hole 15 | Par Hole 16 | Par Hole 17 | Par Hole 18 |  | Index Hole 1 | Index Hole 2 | Index Hole 3 | Index [NAME] | Index Hole 5 | Index Hole 6 | Index Hole 7 | Index Hole 8 | Index Hole 9 | Index Hole 10 | Index Hole 11 | Index Hole 12 | Index Hole 13 | Index Hole 14 | Index Hole 15 | Index Hole 16 | Index Hole 17 | Index Hole 18
Bromma |  |  |  | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 4 |  | 11 | 5 | 7 | 13 | 15 | 9 | 3 | 17 | 1 | 12 | 6 | 8 | 14 | 16 | 10 | 4 | 18 | 2
Hässelby |  |  |  | 3 | 4 | 3 | 4 | 3 | 3 | 3 | 3 | 4 | 3 | 4 | 3 | 4 | 3 | 3 | 3 | 3 | 4 |  | 11 | 13 | 7 | 1 | 5 | 9 | 15 | 17 | 3 | 12 | 14 | 8 | 2 | 6 | 10 | 16 | 18 | 4
Nacka |  |  |  | 4 | 4 | 5 | 4 | 5 | 3 | 4 | 4 | 3 | 4 | 5 | 4 | 3 | 4 | 4 | 3 | 5 | 4 |  | 10 | 4 | 16 | 8 | 2 | 18 | 6 | 14 | 12 | 11 | 7 | 3 | 13 | 1 | 15 | 17 | 5 | 9
Spreadsheet: 135748d1326216575-auto-transfer-data-from-master-sheet-to-individual-worksheets-nbastatistics
Sheet: Atl

Atlanta |  |  |  |  | Atl
Away Games |  | 6 | Home Games |  | 4
Points Scored | Points Allowed |  | Points Scored | Points Allowed
106 | 70 |  | 101 | 93
84 | 95 |  | 105 | 98
100 | 92 |  | 109 | 116
74 | 76 |  | 109 | 94
102 | 96
106 | 101
Spreadsheet: 89917d1289663919-total-points-sumblanknotzero
Sheet: Scores

 | Name | Agent | [NAME] v Man Utd | Pts | Man City v Birmingham | Pts | Newcastle v Fulham | Pts | [NAME] | Pts | West Ham v Blackpool | Pts | [NAME] v West Brom | Pts | Wolves v Bolton | Pts | Stoke v Liverpool | Pts | Everton v Arsenal | Pts | Chelsea v Sunderland | Pts | Total
Correct Scores |  |  | 2-2
1 | [NAME] | [NAME] | 1-2 | 0 | 1-0 | 0 | 2-1 | 0 | 2-0 | 0 | 1-1 | 0 | 0-0 | 0 | 1-0 | 0 | 0-2 | 0 | 1-2 | 0 | 3-0 | 0 | 0
2 | [NAME] | [NAME] | 1-3 | 0 | 2-0 | 0 | 4-2 | 0 | 2-0 | 0 | 2-0 | 0 | 1-2 | 0 | 2-0 | 0 | 1-3 | 0 | 2-3 | 0 | 4-2 | 0 | 0
3 | [NAME] | [NAME] | 1-2 | 0 | 3-0 | 0 | 1-2 | 0 | 3-1 | 0 | 2-2 | 0 | 0-2 | 0 | 1-1 | 0 | 0-2 | 0 | 0-1 | 0 | 3-0 | 0 | 0
4 | [NAME] | [NAME] | 1-2 | 0 | 3-1 | 0 | 2-1 | 0 | 2-0 | 0 | 1-0 | 0 | 2-1 | 0 | 1-0 | 0 | 0-1 | 0 | 1-2 | 0 | 3-0 | 0 | 0
5 | [NAME] | [NAME] | 2-2 | 5 | 3-1 | 0 | 2-0 | 0 | 2-1 | 0 | 1-1 | 0 | 1-1 | 0 | 1-0 | 0 | 1-1 | 0 | 2-2 | 0 | 4-1 | 0 | 5
6 | [NAME] | [NAME] | 1-2 | 0 | 2-0 | 0 | 2-1 | 0 | 2-0 | 0 | 1-1 | 0 | 1-2 | 0 | 2-1 | 0 | 1-2 | 0 | 1-2 | 0 | 3-0 | 0 | 0
7 | [NAME] | [NAME] | 1-1 | 2 | 2-1 | 0 | 1-0 | 0 | 2-0 | 0 | 1-2 | 0 | 1-2 | 0 | 2-1 | 0 | 1-0 | 0 | 1-1 | 0 | 3-1 | 0 | 2
8 | [NAME] | [NAME] | 1-2 | 0 | 2-0 | 0 | 2-1 | 0 | 3-0 | 0 | 0-0 | 0 | 1-1 | 0 | 1-2 | 0 | 1-2 | 0 | 2-0 | 0 | 3-0 | 0 | 0
9 | [NAME] | [NAME] | 1-3 | 0 | 2-1 | 0 | 2-1 | 0 | 2-1 | 0 | 0-1 | 0 | 1-1 | 0 | 1-2 | 0 | 1-2 | 0 | 1-2 | 0 | 3-0 | 0 | 0
10 | [NAME] | [NAME] | 1-2 | 0 | 2-0 | 0 | 1-0 | 0 | 2-0 | 0 | 0-1 | 0 | 1-1 | 0 | 0-1 | 0 | 0-2 | 0 | 1-1 | 0 | 2-0 | 0 | 0
11 | [NAME] | [NAME] | 0-2 | 0 | 1-0 | 0 | 1-1 | 0 | 1-2 | 0 | 2-1 | 0 | 1-2 | 0 | 1-1 | 0 | 0-3 | 0 | 1-2 | 0 | 4-0 | 0 | 0
12 | [NAME] | [NAME] | 0-2 | 0 | 2-0 | 0 | 1-0 | 0 | 1-0 | 0 | 1-0 | 0 | 0-0 | 0 | 0-1 | 0 | 1-2 | 0 | 0-1 | 0 | 3-0 | 0 | 0
13 | [NAME] | [NAME] | 1-2 | 0 | 1-0 | 0 | 2-1 | 0 | 3-2 | 0 | 0-0 | 0 | 2-0 | 0 | 1-0 | 0 | 0-1 | 0 | 0-2 | 0 | 3-0 | 0 | 0
14 | [NAME] | Stuart | 2-1 | 0 | 2-0 | 0 | 2-0 | 0 | 2-0 | 0 | 1-2 | 0 | 1-1 | 0 | 1-1 | 0 | 1-2 | 0 | 0-2 | 0 | 2-0 | 0 | 0
Spreadsheet: 840110d1692438161-hello-please-could-you-tell-me-how-much-i-should-spend-to-buy-balls-balls
Sheet: Foglio1

Number of balls | Cost (€) |  | Numbers of balls to buy | 10
2 | 1
3 | 2 |  | Overall cost? | ???
4 | 3
4 | 4
1 | 5
1 | 6
9 | 7
6 | 8
7 | 9
8 | 10
2 | 11
2 | 12
5 | 13
7 | 14
1 | 15
5 | 16
2 | 17
5 | 18
2 | 19
5 | 20
2 | 21
4 | 22
1 | 23
8 | 24
5 | 25
10 | 26
9 | 27
4 | 28
8 | 29
5 | 30
7 | 31
8 | 32
4 | 33
10 | 34
4 | 35
4 | 36
1 | 37
8 | 38
2 | 39
7 | 40
3 | 41
9 | 42
4 | 43
9 | 44
7 | 45
5 | 46
8 | 47
8 | 48
2 | 49
7 | 50
4 | 51
10 | 52
4 | 53
9 | 54
7 | 55
5 | 56
3 | 57
6 | 58
1 | 59
5 | 60
1 | 61
6 | 62
7 | 63
3 | 64
3 | 65
2 | 66
8 | 67
10 | 68
8 | 69
6 | 70
9 | 71
2 | 72
10 | 73
9 | 74
10 | 75
9 | 76
9 | 77
7 | 78
9 | 79
1 | 80
7 | 81
3 | 82
8 | 83
4 | 84
7 | 85
2 | 86
1 | 87
9 | 88
8 | 89
5 | 90
4 | 91
8 | 92
2 | 93
5 | 94
7 | 95
9 | 96
5 | 97
8 | 98
9 | 99
2 | 100
Spreadsheet: 881098d1729007639-verschachtelte-formel-verschachtelte-formel
Sheet: Summary

Eingabe | 2024
 |  |  | Titel 1 |  |  |  |  |  | Titel 2
Name
 |  |  | Ist | Prognose | Ist |  |  |  | Ist | Ist | Ist | Prognose | Prognose
Name1
[NAME]
Name3
Name4
Name5
Name6
Name7
Name8
Name9
Name10
Name11
Name12
Name13
Name14
 | Die obige Tabelle soll mittels Formeln die Werte aus "Input" holen: basierend auf dem Namen (Spalte A) und der Jahreszahl (Zeile 5) und der Angabe "Ist" / "Prognose" (Zeile 6). [NAME] sollte bestenfalls für den gesamten [NAME]:N20 anwendbar sein.
 | e.g. in Zelle D7 soll der [NAME] "Input" [NAME] und in Zelle E7 der [NAME] "Input" Zelle I3 erscheinen
 | Die Jahreszahlen in Zeile 5 sind dynamisch und verändern sich je nach Eingabe in Zelle B2.
 | Das Sheet "Input" ist dynamisch, d.h. jedes [NAME] werden 2 neue Spalten hinzugefügt --> IST-Bereich ist nächstes [NAME] und der [NAME] reicht [NAME]
Spreadsheet: 851201d1701427208-formula-to-pull-the-number-from-one-table-to-another-if-the-headers-match-sample-index-match
Sheet: Sheet1

 |  |  |  | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00
 |  |  | A | 50000 | 80000 | 75000 | 62000
 |  |  | B | 60000 | 50000 | 62000 | 75000
 |  |  | C | 70000 | 60000 | 65000 | 32000
 |  |  | D | 25000 | 30000 | 35000 | 40000
 |  |  | A | 25000
 |  |  | B |  |  | 15000
 |  |  |  | 2023-11-01 00:00:00 |  | 2023-12-01 00:00:00 |  | 2023-01-01 00:00:00 |  | 2023-02-01 00:00:00
 |  |  |  | 75000 |  | 80000 |  | 75000 |  | 62000
 |  |  |  | 60000 |  | 50000 |  | 77000 |  | 75000
Spreadsheet: 122843d1317201661-add-two-unique-values-from-two-separate-columns-help
Sheet: Sheet1

Sal | Date | help1 | help2
B | 2011-01-05 00:00:00 | B 2011 1 | 1 |  |  | A | 1
B | 2011-06-05 00:00:00 | B 2011 6 | 1 |  |  | B | 6
 |  |  |  |  |  | C | 1
A | 0
B | 2
C | 0
Row Labels | Sum of help2
B | 2
Grand Total | 2
Spreadsheet: eric_saibi__9810__092101R
Sheet: Donald Cook 01

Owner Name |  | AEP
Station Name |  | [NAME]
Unit Name |  | [NAME] 01
NERC Region |  | ECAR
State |  | MI
Fuel Type |  | Nuclear
Capacity |  | 1,152 MW
Start Date |  | 2001-08-27 00:00:00
End Date |  | 2001-09-28 00:00:00
Prv. Start Date |  | 2001-08-27 00:00:00
Prv. End Date |  | 2001-09-23 00:00:00
Comments |  | Water pump repairs.  Still in cold shutdown.  Will be down for another week.
SIC |  | 4911
Plant ID |  | 1000365
Unit ID |  | 1005087
Outage ID |  | 18167
Spreadsheet: 22665d1211761629-fixing-a-mistake-on-excel-sheet-ref-tier-structure-template-sample
Sheet: Overview

 |  |  | TIER 1 Site Concept Keyword Site Concept Keyword
TIER 2:
 | Selling Your Handmade Jewelry
 | Make Your Jewelry Sell |  |  | Choosing Jewelry Materials
TIER 3:
 | Craft Shows and Fairs |  |  | Choosing Your Materials
 | Sell in Galleries |  |  | The Basics about Metals
 | Trade Shows |  |  | Making Silver Jewelry
 | Jewelry Home Shows |  |  | Making Gold Jewelry
 | Sell Jewelry to Retailers |  |  | Making Jewelry with Semiprecious Metals
 | Sell Jewelry on eBay |  |  | Making Jewelry with Base Metals
 | Sell Jewelry Online
 |  |  |  | Wood, Bone, and Nut  Beads
 |  |  |  | Making Jewelry with PMC
 |  |  |  | Making Clay Jewelry
 |  |  |  | Buying Supplies
 |  |  |  | Stone Beads
 |  |  |  | [NAME]
 |  |  |  | Lapidary
 |  |  |  | Choosing Your  Materials
 |  |  |  | The [NAME] about metals
 |  |  |  | Found Object Jewelry
 |  |  |  | Pre-made Jewelry  Findings
Spreadsheet: 49f03d6d-d40e-4b0c-bd6b-fc08ccf9a309
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 | name | sequence
 | pdcA_RT_fw | TCACTTTGCAGGAGATCAGCACCA
 | pdcA_RT_rev | TCATTGTAGCTCGCATCCCATCCA
 | pdcB_RT_fw | TGGCCCAAGCCTTTAATTCCACTG
 | pdcB_RT_rev | ATTCAATTAGGGTTGGTCCGCTGC
 | pdcC_RT_fw | ATTGCGCGAAACGAGTACCACAAC
 | pdcC_RT_rev | TGACGTCGAGTTTGTGGTGGATGA
 | alcA_RT_fw | TGATTTCTTCGCTCGCGGACTGAT
 | alcA_RT_rev | TCATTCGGGCATCTCAAGGACGTA
 | alcB_RT_fw | TCCGGGAATTATGGTCGCTAAGCA
 | alcB_RT_rev | ATTTCTCAGTGCGGAAGTGAGCCT
 | alcC_RT_fw | AGCAAGCTACGGATTATGTCCGCT
 | alcC_RT_refv | TGGTGATCATCTTGACGACGGTGT
 | beta-tubulin_RT_fw (housekeeping gene) | ATAATGTTCAGACCGCCCTCTGCT
 | beta-tubulin_RT_rev (housekeeping gene) | GACGGATGTGGAATTGCCCACAAA
 | tefA_RT_fw (house keeping gene) | GTGACTCCAAGAACGATCCC
 | tefA_RT_rev (house keeping gene) | AGAACTTGCAAGCAATGTGG
 | gpdA_RT_fw (housekeeping gene) | TCGTACTGCTGCCCAGAACATCAT
 | gpdA_RT_rev (housekeeping gene) | TGCCGTTGAGAGAAGGAATGACCT
 | pdcA_KO_left flank_fw | CTGCGGCCGCGGACCCATCGACATCTCTTCTT
 | pdcA_KO_left flank_rev | GTGGATCCATCTCCCTGGGTTACAGTGTTC
 | pdcA_KO_right flank_fw | CCGAATTCGCAATATGTCTCCAATCACCCG
 | pdcA_KO_right flank_rev | AACTCGAGCGGAAGGTAGATGACAAGGGAA
 | pdcA_KO_check_left_fw | TACACAGCATCATCTATCGGGC
 | pdcA_KO_check_left_rev | TAGGGTACCTGTCCGCGCGGGG
 | [NAME] | TGGCGACCACACCCGTCCTGTG
 | pdcA_KO_check_right_rev | TTTCCTCGATAGCAGGTAGAGC
 | pdcA_recon_fw | CTGGTACCATGAGTACAAAGCCGTGTCGGT
 | pdcA_recon_rev | TACTCGAGTTTGTTTCTCCGTCGCGCAT
 | pdcA_recon_check_fw | AGTGCGGCGTAACTGATTCAAAGC
 | pdcA_recon_check_rev | TGGGCTGCGTGAAGATACTTGAGA
 | alcC_KO_left flank_fw | GCTCTAGATGATGGTGGTGCTGGATGATGT
 | alcC_KO_left flank_rev | GCACTAGTATTTCCAGCGTGGAGACTGCTT
 | alcC_KO_right flank_fw | GCGAATTCTGGTGATTGACGTGCCGAATGT
 | alcC_KO_right flank_rev | TAGTCGACATGGCGCAGGTAAGCTTGTTGT
 | alcC_KO_check_left_fw | TCAAGGCCACGGCCATAACTTCTA
 | alcC_KO_check_left_rev | TAGGGTACCTGTCCGCGCGGGG
 | alcC_KO_check_right_fw | TGGCGACCACACCCGTCCTGTG
 | alcC_KO_check_right_rev | AGCAGCTGTGATGGATACCAACCT
 | alcC_recon_fw | CTACTAGTAGCAGCTGTGATGGATACCAACCT
 | alcC_recon_rev | TTGCGGCCGCACGACGGAGATTGCATCGTCAGAT
 | alcC_recon_check_fw | AATCCCATCGCTTTGGCGTATTGC
 | alcC_recon_check_rev | ACCCGGTCCTGATGACATTCTTGT
 | recon_construct_amplification_fw | ATCCTTGAAGCTGTCCCTGATGGT
 | recon_construct_amplification_rev | TCCGGCTCGTATGTTGTGTGGAAT
Spreadsheet: 060b50ea-489b-45c3-949c-71507d1aa7da
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
 | APPENDIX A MENU OF DEFAULT POSSIBILITIES
 | Risky debt has two components = Riskfree component + Risky component
 | Risk-free component = face value of debt (F)
 | Risky component = Default possibility of the leveraged firm, which is analagous to a form of put option.
 | Thus, bondholder's payoff:
 | F, or F - Max(F - AT, 0) if default occurrs |  |  |  |  | AT = asset value at maturity
 | Menu of default possibilities:
 | Technical Insolvency |  |  |  | Default, if asset value falls below face value of debt at any time prior to maturity.
 |  |  |  |  | Down-and-in put option with barrier and exerciseset at face value of debt.
 |  |  |  |  | Down-and-in put payoff = |  | (If At > Ad, then 0, MAX(F-AT, 0)) |  |  |  | At = asset value at any time prior to maturity
 |  |  |  |  |  |  |  |  |  |  | AT = asset value at maturity
 |  |  |  |  |  |  |  |  |  |  | Ad = barrier level
 |  |  |  |  | Bondholder payoffs = F or F - MAX(F-AT, 0) if default occurrs |  |  |  |  |  | F = face value of debt = barrier level = exercise price
 |  |  |  |  | Thus, bondholder's payoffs can be rewritten as:
 |  |  |  |  | If At > Ad, F, otherwise F - MAX(F-AT, 0)
 | Breach of financial covenants
 | Debt Ratio= |  | Total Debt/Total Asset |  |  | e.g., Default, if [NAME] 0.50
 |  |  |  |  |  | Possibility for Debt Ratio to go beyond 0.50
 |  |  |  |  |  | 1) Total Assets decreases
 |  |  |  |  |  | Example:
 |  |  |  |  |  | Current ratio = 1/3 or 0.333 |  |  | Total Debt = 100
 |  |  |  |  |  |  |  |  | Total Assets = 300
 |  |  |  |  |  | Firm defaults if:
 |  |  |  |  |  | 1) Assets decreases to less than 200
 |  |  |  |  |  | Down-and-in put option with barrier set at Asset value of 200 and exercise set at face value of debt.
 | Special case of Technical Insolvency
 |  |  |  |  | Default, if asset value falls below face value of debt by a "certain degree" at any time prior to maturity.
 |  |  |  |  | This case accounts for the "lag" usually associated with the time between default and when bondholders become aware of the situation
 |  |  |  |  | Down-and-in put option with barrier set at a multiple of debt, where the multiple is less than 1 and the exercise is still face value of debt.
 |  |  |  |  |  | e.g.,
 |  |  |  |  |  | Face value of debt = 100mm
 |  |  |  |  |  | Ad = 90
 |  |  |  |  |  | A0 = 200
 |  |  |  |  |  | Thus, default if asset value drops below 90.
Spreadsheet: 0db4af14-af13-420f-b917-a3f67fa89751
Sheet: Status&Condition ref

EQ_STATUS | [NAME] | [NAME] | [NAME] | EQ_CRITICALITY | COMMENTS
ACTIVE | ACTIVE AND OPERATIONAL | 1-VERYGOOD | NEW (<2YRS OLD), RELIABLE IN PERFECT CONDITION | 1 | CRITICAL
INACTIVE/STANDBY | INACTIVE (OFFLINE/BACKUP/STANDBY) WITH INTENT TO MAKE ACTIVE AGAIN | 2-GOOD | FUNCTIONING NORMAL MAINTENANCE | 2 | ESSENTIAL
RETIRED/REMOVED | INACTIVE AND RETIRED - WILL NO LONGER BE UTILIZED | 3-FAIR | FUNCTIONING IN NEED OF REPAIR | 3 | NON-CRITICAL
 |  | 4-POOR | RELIABILITY ISSUES RISK OF FAILURE
Spreadsheet: 760041d1639934290-to-highlight-the-numbers-according-to-value-121212sample
Sheet: Sheet1

 |  |  | OK |  | P-1 | P-2 | P-3 | P-4 | P-5 | P-6
 | abc | 5 | 3 | ===> | 1 |  | 2 | 1 | 1
 | def | 15 | 12 | ===> | 3 | 5 | 2 | 1 | 4
 | ghi | 35 | 29 | ===> | 15 |  | 9 | 2 | 5 | 4
 |  |  |  |  | to highlight according to number of OK.
Spreadsheet: 115825d1311320437-parsing-a-data-table-pivot
Sheet: Sheet2

Row Labels | Sum of count
[NAME]
red
2011-07-06 00:00:00 | 650
2011-07-08 00:00:00 | 360
2011-07-15 00:00:00 | 160
white
2011-07-06 00:00:00 | 340
2011-07-08 00:00:00 | 34
2011-07-15 00:00:00 | 6754
2011-07-23 00:00:00 | 54
Shepards Fork
red
2011-07-06 00:00:00 | 580
2011-07-08 00:00:00 | 10020
2011-07-15 00:00:00 | 13602
2011-07-23 00:00:00 | 61
[NAME]
red
2011-07-15 00:00:00 | 200
white
2011-07-06 00:00:00 | 14211
2011-07-08 00:00:00 | 8880
2011-07-15 00:00:00 | 10082
2011-07-23 00:00:00 | 432
Grand Total | 66420