tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 152712d1335479992-if-statement-returning-part-of-a-cell-between-special-characters-if_statement_results_between_chars
Sheet: Sheet1

data: |  |  | would like to see: |  |  | so far:
 | <Application>ABCHOST</Application>_x000D_ |  |  | ABCHOST
 | <StatusKind>Pass</StatusKind>_x000D_ |  |  | Pass
 | <MsgId>[PHONE]</MsgId>_x000D_ |  |  | [PHONE]
 | <StatusCode>0</StatusCode>_x000D_ |  |  | 0
 | <IssueTime>2012-04-19 10:05:00:000</IssueTime>_x000D_ |  |  | 2012-04-19 10:05:00:000
 | <Application>DEFGHOST</Application>_x000D_ |  |  | DEFGHOST
 | <StatusKind>Fail</StatusKind>_x000D_ |  |  | Fail
 | <MsgId>2468</MsgId>_x000D_ |  |  | 2468
 | <StatusCode>1950</StatusCode>_x000D_ |  |  | 1950
 | <IssueTime>2012-04-19 10:05:00:000</IssueTime>_x000D_ |  |  | 2012-04-19 10:05:00:000
Spreadsheet: 866672d1713558915-div-0-error-final-vacation-sick-payout-issue
Sheet: STRS

Are they a 9/12 person? | NO
Date of Hire: | 1990-01-01 00:00:00
Date of Retirement: | 2010-01-01 00:00:00
Total employment service |  | years
Salary: | 84454.64 |  | is the hourly rate. | 0.6 | <-FTE % For this position
Salary: | 42288.84 |  | is the hourly rate. | 0.4 | <-FTE % For this position
Sick hours: | 2886 |  | hours due
Vacation hours: | 500 |  | hours due
Final Sick and Vacation Pay:
Spreadsheet: 866836d1713764401-looking-up-criteria-and-returning-values-between-two-dates-book2-91-aligw
Sheet: Summary

 |  | 2024-04-01 00:00:00 |  | 2024-05-01 00:00:00 |  | 2024-06-01 00:00:00 |  | 2024-07-01 00:00:00 |  | 2024-08-01 00:00:00
STAFF |  | Date | Time | Date | Time | Date | Time | Date | Time | Date | Time
Brett |  |  | 12:30:00 | 2024-05-10 00:00:00 | 15:00:00 | 2024-06-06 00:00:00 | 12:30:00 | 2024-07-05 00:00:00 | 11:30:00 | 2024-08-06 00:00:00 | 11:00:00
Doug |  |  | 14:30:00 | 2024-05-07 00:00:00 | 12:30:00 | 2024-06-07 00:00:00 | 13:00:00 | 2024-07-08 00:00:00 | 15:30:00 | 2024-08-07 00:00:00 | 15:00:00
Amanda |  |  | 11:00:00 | 2024-05-08 00:00:00 | 14:30:00 | 2024-06-18 00:00:00 | 14:00:00 | 2024-07-10 00:00:00 | 09:30:00 | 2024-08-12 00:00:00 | 13:30:00
[NAME] |  |  | 15:00:00 | 2024-05-14 00:00:00 | 12:30:00 | 2024-06-10 00:00:00 | 12:30:00 | 2024-07-09 00:00:00 | 12:00:00 | 2024-08-09 00:00:00 | 14:30:00
Carol |  |  | 13:30:00 | 2024-05-15 00:00:00 | 13:00:00 | 2024-06-11 00:00:00 | 11:30:00 | 2024-07-11 00:00:00 | 13:00:00 | 2024-08-05 00:00:00 | 12:30:00
[NAME] |  |  | 16:00:00 | 2024-05-17 00:00:00 | 11:00:00 | 2024-06-12 00:00:00 | 15:30:00 | 2024-07-15 00:00:00 | 11:00:00 | 2024-08-13 00:00:00 | 13:00:00
[NAME] |  |  | 12:30:00 | 2024-05-16 00:00:00 | 12:30:00 | 2024-06-14 00:00:00 | 09:30:00 | 2024-07-12 00:00:00 | 12:30:00 | 2024-08-15 00:00:00 | 09:30:00
Kelly |  |  | 13:00:00 | 2024-05-20 00:00:00 | 11:30:00 | 2024-06-13 00:00:00 | 12:00:00 | 2024-07-16 00:00:00 | 11:30:00 | 2024-08-14 00:00:00 | 12:00:00
Justin |  |  | 11:30:00 | 2024-05-21 00:00:00 | 15:30:00 | 2024-06-17 00:00:00 | 08:00:00 | 2024-07-17 00:00:00 | 15:30:00 | 2024-08-16 00:00:00 | 08:00:00
Emily |  |  | 15:00:00 | 2024-05-23 00:00:00 | 09:30:00 | 2024-06-19 00:00:00 | 15:30:00 | 2024-07-19 00:00:00 | 09:30:00 | 2024-08-20 00:00:00 | 15:30:00
[NAME] |  |  | 13:00:00 | 2024-05-22 00:00:00 | 12:00:00 | 2024-06-20 00:00:00 | 16:00:00 | 2024-07-18 00:00:00 | 12:00:00 | 2024-08-21 00:00:00 | 16:00:00
[NAME] |  |  | 14:30:00 | 2024-05-24 00:00:00 | 08:00:00 | 2024-06-21 00:00:00 | 12:00:00 | 2024-07-22 00:00:00 | 09:00:00 | 2024-08-22 00:00:00 | 12:00:00
Spreadsheet: 92179d1291827707-count-on-condition-example2
Sheet: Sheet2

Filer Name | Year | NUMBER of DIFFERENT NAME BY YEAR
DAVIES | 2004 | 0
MULLAN | 2004 | 0
MULLAN | 2004 | 2
CHAPMAN | 2005 | 0
MULLAN | 2005 | 2
CHAPMAN | 2007 | 0
CHAPMAN | 2007 | 0
DAVIES | 2007 | 0
MULLAN | 2007 | 3
MULLAN | 2009 | 1
BANKS | 2010 | 0
MULLAN | 2010 | 2
Spreadsheet: 127200d1320229570-excel-2007-inserting-an-image-behind-cell-__timetable
Sheet: Timetable

Date 2011/12 | Time | Rooms  Booked
Date 1 | 10am-1pm | Room 1
Date 2 | 10am-1pm | Room 2
Date 3 | 10am-1pm | Room 3
Date 4 | 10am-1pm | Room 4
Date 5 | 10am-1pm | Room 5
 |  |  |  | Automatically updating image of
Date 2011/12 | Time | Rooms  Booked
date 7# | 2pm-4pm | Room 1
Date 7 | 2pm-4pm | Room 2
Date 8 | 2pm-4pm | Room 3
Date 9 | 2pm-4pm | Room 4
Date 10 | 2pm-4pm | Room 5
Spreadsheet: a066f680-e173-48c9-8784-ac748411d7d2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-09-21 09:19:13.600000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.747 | 101.622 | 101.497 | 101.122
4.25 | 101.321 | 101.196 | 101.071 | 100.696 |  | Note: | Refer To Price [NAME]
4.125 | 100.352 | 100.227 | 100.102 | 99.727 |  |  | For all Price Adjs
4 | 99.948 | 99.823 | 99.698
3.875 | 99.371 | 99.246 | 99.121
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 101.875 | 101.75 | 101.625 | 101.25
3.625 | 101.618 | 101.493 | 101.368 | 100.993
3.5 | 101.319 | 101.194 | 101.069 | 100.694
3.375 | 100.923 | 100.798 | 100.673 | 100.298
3.25 | 100.393 | 100.268 | 100.143
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-10-05 09:19:13.600000
30 DAY | 2011-10-20 09:19:13.600000
45 DAY | 2011-11-04 09:19:13.600000
60 DAY | 2011-11-19 09:19:13.600000
90 DAY | 2011-12-19 09:19:13.600000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 540771d1506958860-data-validation-copy-of-equipments-calibration
Sheet: Sheet1

PRODUCTION EQUIPMENT CALIBRATION
NAME | New Cal | ID# | CALIBRATION DATE | REMARKS
TIMER/STOP WATCH | 2017-01-17 00:00:00 | SWT-002 | 2018-01-18 00:00:00 | Done
TIMER/STOP WATCH |  | [NAME] |  | Done
TIMER/STOP WATCH |  | SWT-006 |  | Done
TIMER/STOP WATCH |  | SWT-007 |  | Done
TIMER/STOP WATCH |  | SWT-008 | 2018-11-01 00:00:00
TIMER/STOP WATCH |  | SWT-009
TIMER/STOP WATCH |  | SWT-011
TIMER/STOP WATCH |  | SWT-010
Spreadsheet: 10e29798-0316-44e3-a72f-a3f317195b8a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-05-26 13:40:47.580000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.75 | 101.416 | 101.291 | 101.166 | 100.791
4.625 | 100.505 | 100.38 | 100.255 | 99.88 |  | Note: | Refer To Price [NAME]
4.5 | 100.034 | 99.909 | 99.784 | 99.409 |  |  | For all Price Adjs
4.375 | 99.425 | 99.3 | 99.175
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.25 | 101.875 | 101.75 | 101.625 | 101.25
4.125 | 101.476 | 101.351 | 101.226 | 100.851
4 | 101.151 | 101.026 | 100.901 | 100.526
3.875 | 100.721 | 100.596 | 100.471 | 100.096
3.75 | 100.177 | 100.052 | 99.927
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-06-09 13:40:47.580000
30 DAY | 2011-06-24 13:40:47.580000
45 DAY | 2011-07-09 13:40:47.580000
60 DAY | 2011-07-24 13:40:47.580000
90 DAY | 2011-08-23 13:40:47.580000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 691497d1597728456-countif-function-help-practicehelp
Sheet: Sheet1

Team | Pos |  | Team | QB | RB | WR | TE
Team 1 | QB |  | Team 1
Team 2 | RB |  | Team 2
Team 3 | WR |  | Team 3
Team 4 | TE |  | Team 4
Team 5 | QB |  | Team 5
Team 1 | QB
Team 2 | RB
Team 3 | RB
Team 4 | WR
Team 5 | QB
Spreadsheet: 76131d1276695585-auto-sorting-a-table-auto-sorting
Sheet: Sheet1

 |  |  | helper column | least | most
 | PIERDA EL BALON |  | unique rank of col b
JAVI | 2 |  | 4 | XISCO | IVAN
JOEL | 3 |  | 5 | CIFO | [NAME]
[NAME] | 4 |  | 6 | [NAME] | PORTU
NACHO | 5 |  | 7 | JAVI | JAVI REY
JAVI REY | 6 |  | 8 | JOEL | NACHO
PORTU | 8 |  | 9 | [NAME] | [NAME]
[NAME] | 9 |  | 10 | NACHO | JOEL
XISCO | 0 |  | 1 | JAVI REY | JAVI
CIFO | 1 |  | 2 | PORTU | [NAME]
IVAN | 12 |  | 11 | [NAME] | CIFO
[NAME] | 2 |  | 3 | IVAN | XISCO
Spreadsheet: 76b53359-eed6-4571-acf6-305e289fe992
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 1202 | 1148 | 1003 | 855
20 - 65 | 4387 | 3901 | 3443 | 2990
65 und mehr | 1611 | 1759 | 1940 | 2108
Insgesamt | 7200 | 6808 | 6386 | 5953
%
unter 20 | 16.69444444444445 | 16.86251468860165 | 15.70623238333855 | 14.36250629934487
20 - 65 | 60.93055555555556 | 57.30023501762632 | 53.91481365487003 | 50.22677641525281
65 und mehr | 22.375 | 25.83725029377203 | 30.37895396179142 | 35.41071728540231
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 27.39913380442215 | 29.4283517046911 | 29.13157130409527 | 28.5953177257525
Altenquotient | 36.72213357647595 | 45.09100230710074 | 56.34620970084229 | 70.50167224080268
Gesamtquotient | 64.1212673808981 | 74.51935401179185 | 85.47778100493755 | 99.09698996655518
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 886951d1737045625-vlookup-match-over-multiple-tabs-in-worksheet-multi-tab-example
Sheet: MONACO SPORT

MONACO SPORT (Non-FIA Homologated) - Standard Width
Standard Range
MONACO SPORT (Non-FIA Homologated) - Narrow Width
Standard Range | Supplied with Anthracite Suede Tec Wear Patches as standard
Part No. | Description
MNLS-S-BK | [NAME] Black Spacer Fabric all over | 510
MNLS-S-BL | [NAME] all over | 525
MNLS-S-RD | [NAME] Spacer Fabric all over | 500
MNLS-S-GY | [NAME] all over | 515
MNLS-V-BK | [NAME] all over | 510
Spreadsheet: 80529d1280765191-grouping-results-using-multisheet-consolidation-testing2-1
Sheet: INTLSummary

 |  |  |  |  |  |  |  |  |  | Choose Month
 | Country | State | Probability | Value | Month
 |  |  |  |  |  |  |  |  |  | Choose probability
 | Europe
 | Hungary |  | 0.9 | 10 | June
 | Sweden |  | 0.1 | 15 | June
 | France |  | 0.2 | 100 | May
 | Germany |  | 0.3 | 25 | August
 | England |  | 0.6 | 55 | April
 | US
 | USA | New York | 0.9 | 10 | June
 | USA | Florida | 0.1 | 15 | June
 | USA | Missouri | 0.2 | 100 | May
 | USA | Texas | 0.3 | 25 | August
 | USA | California | 0.6 | 55 | April
 | ME
 | Abu Dhabi |  | 0.9 | 10 | June
 | Jordan |  | 0.1 | 15 | July
 | Oman |  | 0.2 | 100 | June
 | Dhubi |  | 0.3 | 25 | June
 | TOTAL VALUE |  |  | 560
Spreadsheet: 07aadc29-61aa-4cb2-91bb-bca41fef8c5c
Sheet: Sheet1

Name of SAFE Mentor: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Name of SAFE Mentee:
Date | Time Began | Time Ended | Location | Activity (Practice. Tutoring, [NAME]) | Next Scheduled Meeting (Time/Place) | Total Time
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  |  |  |  |  | 00:00:00
 |  | Total Hours of Community Service: |  |  |  | 00:00:00
Spreadsheet: 440230d1452703184-vacation-tracking-from-an-anniversary-date-from-year-to-year-vacation-tracking-2015
Sheet: February

Employee Absence Schedule
February | Dates of Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015
Employee Name | 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 |  |  | Total Hours
A
B
C
D
E
F
G
H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8
I
J
K
L
M
N
O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.5
 |  |  |  |  |  | 8 |  |  |  | 6 |  |  |  | 4 |  |  |  | 2
Spreadsheet: 680978d1591283692-functions-to-link-data-over-multiple-sheets-excel-forum-example-kanga-azz-
Sheet: January

 |  |  |  |  |  |  |  |  |  |  | Item Used |  | Amount
 |  |  |  |  |  |  |  |  |  |  | Data 1 |  | 2 |  |  |  | Data 1
 |  |  |  |  |  |  |  |  |  |  | Data 2 |  | 6 |  |  |  | Data 2
 |  |  |  |  |  |  |  |  |  |  | Data 1 |  | 3 |  |  |  | Data 3
 |  |  |  |  |  |  |  |  |  |  | Data 3 |  | 1 |  |  |  | Data 4
 |  |  |  |  |  |  |  |  |  |  | Data 4 |  | 2 |  |  |  | Data 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data 10
Spreadsheet: 800114d1665494020-using-if-to-code-multipl-choice-question-responses-into-numbers-with-multiple-responses-sample-hd
Sheet: Sheet1

 | Have you experienced regular technology problems in online classes? |  |  |  |  | Your technology problems in online classes have been mostly caused by what? |  |  |  |  |  | I would like the output to be:
ID # | 15 | Code | OUTPUT |  |  | 16 | Code | OUTPUT |  |  |  |  |  |  | Formula 1 | Formula 2
1 | Yes |  | AVE (MEAN) |  |  | Internet Access; |  | AVE (MEAN)
2 | Yes |  | AVE (MODE) |  |  | Device Software;Device Hardware;Operator Error; |  | AVE (MODE) |  |  |  | 3,2,5
3 | No |  | MAX |  |  | Never had problems; |  | MAX
4 | No |  | MIN |  |  | Internet Access; |  | MIN
5 | No |  | ST ERROR |  |  | Never had problems; |  | ST ERROR
6 | No |  | 1.96 x ST E |  |  | Device Hardware; |  | 1.96 x ST E
7 | No |  | CONF |  |  | Device Hardware; |  | CONF
8 | No |  | 95%C MUP |  |  | Never had problems; |  | 95%C MUP
9 | No |  | 95%C MLW |  |  | Never had problems; |  | 95%C MLW
10 | No |  |  |  |  | Internet Access;
11 | Yes |  | [NAME]. |  |  | Internet Access; |  | [NAME].
12 | Yes |  |  |  |  | Internet Access;
13 | Yes |  | CATEGORY | OBSERVED | EXPECTED | Internet Access; |  | CATEGORY | OBSERVED | EXPECTED
14 | Yes |  | 1 |  |  | Internet Access;Operator Error;Incorrect Instructions; |  | 1 |  |  |  | 1,5,6,
15 | No |  | 2 |  |  | Other;Device Software;Internet Access;Operator Error;Incorrect Instructions;Device [NAME]; |  | 2 |  |  |  | 7,3,1,5,6,2
16 | Yes |  |  |  |  | Internet Access; |  | 3
17 | Yes |  |  |  |  | Internet Access; |  | 4
18 | Yes |  |  |  |  | Internet Access;Device Software;Other; |  | 5 |  |  |  | 1,3,7
19 | No |  |  |  |  | Other; |  | 6
20 | No |  |  |  |  | Incorrect Instructions; |  | 7
21 | No |  |  |  |  | Internet Access; |  | 8
22 | No |  |  |  |  | Never had problems;
23 | Yes |  |  |  |  | Internet Access;
24 | Yes |  |  |  |  | Internet Access;
25 | Yes |  | 1 (Yes) |  |  | Internet Access; |  | 1 (Internet Access)
26 | No |  | 2 (No) |  |  | Never had problems; |  | 2 (Device Hardware)
27 | No |  | 3 (N/A) |  |  | Never had problems; |  | 3 (Device Software)
28 | Yes |  | 4 (N/A) |  |  | Internet Access; |  | 4 (Power Blackouts)
29 | Yes |  | 5 (N/A) |  |  | Internet Access; |  | 5 (Operator Error)
30 | Yes |  | 6 (N/A) |  |  | Internet Access; |  | 6 (Incorrect Instructions)
31 | No |  | 7 (N/A) |  |  | Never had problems; |  | 7 (Other)
32 | Yes |  | 8 (N/A) |  |  | Internet Access; |  | 8 (Never had problems)
33 | No |  | 9 (N/A) |  |  | Internet Access; |  | 9 (N/A)
34 | Yes |  | TOTAL |  |  | Internet Access; |  | TOTAL
Spreadsheet: 817493d1676278319-pour-results-based-on-b1-pull-words-by-cell-b1
Sheet: Sheet1

ARAARAS | K |  | KAIKAIS
ATAATAS |  |  | KOEKOEA
ALFALFA
LABLABS
CANCANS
AKEAKES
TARTARE
TAUTAUG
KAIKAIS
ATLATLS
MAOMAOS
PAWPAWS
SARSARS
TARTARS
TUATUAS
KOEKOEA
PURPURA
BEEBEES
Spreadsheet: benjamin_rogers__1013__Pro Forma2
Sheet: 144A DEBT

DELMARVA, VA
Debt Service Phase II
0
Year
Contract year
Months /year
Tranche 1:
Lender | Long Term |  | Check
Principal: |  | M
Interest Rate: |  | Annual
Term |  | Semiannual Periods
Amortization Method
Grace Period |  | Years
144A
Payment Principal
Debt
Principal
Interest
Payment
Ending Balance
Payment Principal |  | 0
Debt
Principal
Interest |  | 0
Payment
Ending Balance
Summary
Interest
Principal
Total Payment
DSRF Maintenance
Beginning Balance
(Addition)/release
LC Charge for DSRF
Term Outstanding |  | 0.5 | 1.5 | 2.5 | 3.5 | 4.5 | 5.5 | 6.5 | 7.5 | 8.5 | 9.5 | 10.5 | 11.5 | 12.5 | 13.5 | 14.5 | 15.5 | 16.5 | 17.5 | 18.5 | 19.5 | 20.5
Bond-Years
Term Outstanding |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
Bond-Years
Average Life
Spreadsheet: c7d1cfca-be7e-4423-bfd5-9803ecb66710
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.
Global Studies
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: benjamin_rogers__1067__NewCo-1-19-00
Sheet: FPLE_Wind Summary

 | FPLE Wind Valuation Summary
 | ('000 $) |  |  |  |  |  |  |  | Interest
 |  |  | DCF Value |  |  | Unlevered | Levered |  | Tax Shield | % by | Debt | Valuation is run
 |  | Net MW | Equity | Debt (a) | Total | IRR | Plant Value | $/KW | Allocation | Cash Flow | Allocation | proof
 | Consolidated Wind Assets
 | [NAME] | 42 |  | 0
 | Southwest Mesa | 75 |  | 0
 | Vansycle | 24.9 |  | 0
 | Non-Consolidated Wind Assets
 | [NAME] | 28 |  | 0
(b) | Pacific Crest | 14 |  | 0
 | Sky River | 38.5 |  | 0
 | [NAME] | 15 |  | 0
 | Green Ridge | 82.5 |  | 0
(c) | Mojave 16/17/18 | 42.5 |  | 0
 | Morwind | 14.5 |  | 0
 | Victory Garden | 11 |  | 0
 | Non-Core Wind Assets
 | WPP 92 | 15 |  | 0
 | WPP 91-2 | 15.5 |  | 0
(d) | Mojave 3/5 | 22.1 | 0 | 0 | 0 |  |  | 0
 | WPP 89 | 13.8 |  | 0
 | WPP 91 | 12 |  | 0
 | WPP 90 | 7.5 |  | 0
(d) | Altamont Power | 8.8 | 0 | 0 | 0
 | Wind Portfolio
 | (a)  FPLE debt.
 | (b)  Assumes refinancing of FPLE debt
 | (c)  DCF valuation doe not include the value of non-repowered turbines
 | (d)  Non-core assets included at book value