tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 690762d1597283927-dependent-drop-down-list-country-city-suburb
Sheet: Sheet5

Country |  |  |  |  |  |  | DROPDOWN LISTS HERE:
UK |  |  |  |  |  |  | Country | City | Suburb
Canada |  |  |  |  |  |  | UK | London
Australia
UK | Canada | Australia
Bristol | London | Canberra
London | Ottawa | Melbourne
[NAME] | Toronto | Newcastle
Newcastle | Vancouver | Sydney
Bristol | London | [NAME] | Newcastle
Cotham | Fulham | Spinningfields | Elswick
[NAME] | [NAME] | Moss Side | Gosforth
Ashton Gate | Croydon | Rusholme | Walker
 | Wembley | Ancoats
London | Ottawa | Toronto | Vancouver
Masonville | Kanata | York | Kerrisdale
White Oaks | Munster | Cliffside | Oakrdge
Nilestown | Nepean | Malvern | Killarney
 |  |  | Fairview
Canberra | Melbourne | Newcastle | Sydney
[NAME] | [NAME] | Adamstown | [NAME]
Gungahlin | Fitzroy | Carrington | Manly
[NAME] | Elwood | [NAME] | Chatswood
[NAME] | Southbank |  | Newtown
Spreadsheet: 763369d1642139039-how-to-create-unique-identifier-row-and-column-name-and-use-that-to-pull-amounts-example
Sheet: Example

Property | 21st Street
Manager | [NAME]
Lines | Mapping Name | Book Value | Tax Value | Audit Value
Line 1 | Income | 5000 | 10000 | 30000
Line 1 | Distribution | -1000 | -2000 | -6000
Line 1 | Contribution | 22000 | 44000 | 132000
Line 2 | Payment | 55000 | 110000 | 330000
Line 2 | Late Fee | -10000 | -20000 | -60000
Line 3 | Revenue | 17000 | 34000 | 102000
Line 3 | Profit | 90000 | 180000 | 540000
Line 4 | Utility Bill | -12000 | -24000 | -72000
Line 5 | Real Estate Income | 35000 | 70000 | 210000
Line 6 | Rental Income | 2500 | 5000 | 15000
example system unique values: | result:
{Line 1_Book Value}
{Line 1_Tax Value}
{Line 1_Audit Value}
{Income_Book Value}
{Income_Tax Value}
{Income_Audit Value}
Spreadsheet: 789945d1659452861-nesting-if-and-or-in-a-table-something-wrong-forquestion
Sheet: sample sheet

CONTAINS WORD "BANKCARD" Or DEPOSIT | Criteria Result | Column1
This contains "[NAME]" somewhere in the text
DEPOSIT
Random text that does not contain either word
Bankcard transaction
Bank holiday - no transactions
ABC Healthcare deposit
Spreadsheet: 801892d1666456071-expand-average-formula-with-another-sheet-expense-tracker_excel
Sheet: Expense Journal

 | Category | INR | RM | #[NAME]!
 | Total Fund | 40000
 | Total Expense
 | Daily Average
 | Balance
 | Date | Expense | Amount (INR) | Amount (RM)
 | 2022-10-29 00:00:00 | Accommodation | 250
 | 2022-10-30 00:00:00 | Biscuit | 150
Spreadsheet: 032d0c56-6cc0-4764-bb00-954b5f66c696
Sheet: Sheet1

2010 Orange County Total and Voter Age Population by 2010 Place and 2001 Supervisorial District | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
2010 Census
DISTRICT 1 |  |  |  | DISTRICT 4
PLACE | Total Population | 18+ Population |  | PLACE | Total Population | 18+ Population
Garden Grove* | 153957 | 114138 |  | Anaheim* | 265651 | 190085
Midway City CDP | 8485 | 6379 |  | [NAME] | 80530 | 60169
Santa Ana | 324528 | 224850 |  | [NAME] | 135161 | 103603
Westminster | 89701 | 68781 |  | [NAME] | 60239 | 44177
Unincorporated | 2480 | 1801 |  | Placentia | 50533 | 38088
District 1 Total | 579151 | 415949 |  | Unincorporated | 12125 | 8943
 |  |  |  | District 4 Total | 604239 | 445065
DISTRICT 2
 | Total | 18+
PLACE | Population | Population |  | DISTRICT 5
Costa Mesa | 109960 | 86278 |  |  | Total | 18+
Cypress | 47802 | 36459 |  | PLACE | Population | Population
Fountain Valley | 55313 | 43670 |  | Aliso [NAME] | 47823 | 35428
Garden Grove* | 16926 | 12982 |  | [NAME] | 14866 | 10321
Huntington Beach | 189992 | 150864 |  | [NAME] | 33351 | 27392
[NAME] | 15568 | 12145 |  | Ladera Ranch CDP | 22980 | 14168
Los Alamitos | 11449 | 8708 |  | Laguna Beach | 22723 | 19075
Newport Beach* | 74269 | 62241 |  | Laguna Hills | 30344 | 23582
Rossmoor CDP | 10244 | 7694 |  | [NAME] | 62979 | 48763
Seal Beach | 24168 | 21017 |  | [NAME] | 16192 | 16144
Stanton | 38186 | 27620 |  | Lake Forest | 77264 | 58149
Sunset Beach CDP | 971 | 865 |  | Las Flores CDP | 5971 | 3942
Unincorporated | 2479 | 1879 |  | Mission Viejo | 93305 | 72035
District 2 Total | 597327 | 472422 |  | Newport Beach* | 10917 | 8201
 |  |  |  | Rancho Santa Margarita | 47853 | 33974
DISTRICT 3 |  |  |  | [NAME] | 63522 | 48016
 | Total | 18+ |  | San Juan Capistrano | 34593 | 26075
PLACE | Population | Population |  | Unincorporated | 1491 | 1142
Anaheim* | 70614 | 54263 |  | District 5 Total | 586174 | 446407
Brea | 39282 | 30225
[NAME] | 212375 | 166700
North Tustin CDP | 24917 | 19060 |  |  | Total | 18+
Orange | 136416 | 104320 |  |  | Population | Population
[NAME] | 75540 | 55328 |  | Orange County Total | 3010232 | 2273573
Villa Park | 5812 | 4648
Yorba [NAME] | 64234 | 48442 |  | Target Population: | 602046.4
Unincorporated | 14151 | 10744
District 3 Total | 643341 | 493730
 |  |  |  | Difference with Target Populations:
 |  |  |  | District 1 | -22895.4 | -0.03802929475203244
 |  |  |  | District 2 | -4719.400000000023 | -0.007838930687070004
 |  |  |  | District 3 | 41294.6 | 0.06859039436163056
 |  |  |  | District 4 | 2192.599999999977 | 0.003641911985521343
*Split city |  |  |  | District 5 | -15872.4 | -0.02636408090804965
CDP- Census Designated Place in Unincorporated County
Source: 2010 Census Redistricting Data [P.L. 94-171] Summary File
Spreadsheet: 113838d1309729334-help-with-lookup-functions-please-data
Sheet: Data Dump

 | Chilled |  |  |  |  |  |  | Long Life |  |  |  |  |  |  | Fresh
 | July | August | September | October | November | December | Result | July | August | September | October | November | December | Result | July | August | September | October | November | December | Result
Shop F | 2 | 3 | 2 | 0 | 0 | 0 |  | 1 | 1 | 0 | 0 | 0 | 0 |  | 3 | 0 | 0 | 0 | 0 | 0
Shop P | 0 | 0 | 0 | 0 | 0 | 0 |  | 2 | 0 | 0 | 4 | 2 | 0 |  | 2 | 3 | 0 | 7 | 0 | 5
Shop A | 4 | 0 | 0 | 0 | 0 | 0 |  | 2 | 0 | 2 | 6 | 0 | 3 |  | 1 | 1 | 2 | 0 | 3 | 0
Shop E | 0 | 3 | 0 | 0 | 0 | 0 |  | 0 | 3 | 0 | 0 | 4 | 2 |  | 4 | 0 | 1 | 4 | 1 | 0
Shop L | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 1 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 60787d1261371783-adding-todays-date-to-template-automatically-djl
Sheet: ATM

ATM DAILY CHECKLIST
 | Not in use | In use | Connection Details? | [NAME]
 |  |  | Checked at 04:11 | ok
6am
7am
8am
9am
10am
11am
12pm
1pm
2pm
3pm
4pm
5pm
6pm
7pm
8pm
Spreadsheet: efba6542-03c4-46b4-8dcc-182ceda2b12e
Sheet: KODE

KODE MATEMATIKA SMP
[NAME] | Mata Pelatihan | JP |  | NO | NAMA ASESOR | NIA
A1 | PRE TEST | 1 |  | 0 | Panitia
A2 | [NAME] PROFESIONALITAS GURU | 3 |  | 1 | Pimpinan Universitas
B1 | PENDALAMAN MATERI MATA PELAJARAN |  |  | 2 | [NAME], [NAME]. [NAME] | 7140180001
 | B1.1 PENDALAMAN MATERI MATA PELAJARAN(GEOMETRI) | 2 |  | 3 | Dwijanto, Dr, M.S | 7140180002
 | B1.2 PENDALAMAN MATERI MATA PELAJARAN(ALJABAR) | 2 |  | 4 | [NAME], Dra, M.Pd | 7140180003
 | B1.3 PENDALAMAN MATERI MATA PELAJARAN(ARITMETIKA) | 2 |  | 5 | Isnarto, S.Pd, M.Si | 7140180004
B2 | PENDALAMAN PEMBELAJARAN |  |  | 6 | [NAME], [NAME], M.S | 7140180005
 | B2.1 PENDALAMAN PEMBELAJARAN 1(PAIKEM) | 2 |  | 7 | [NAME], [NAME]. [NAME] | 7140180006
 | B2.2 PENDALAMAN PEMBELAJARAN 2(PEMENFAATAN MEDIA) | 2 |  | 8 | Nurkaromah D, Dra, M.Si | 7140180007
 | B2.3 PENDALAMAN PEMBELAJARAN 3(PENILAIAN) | 2 |  | 9 | [NAME], Dr, M.Si | 7140180008
B3 | PENDALAMAN PTK [NAME] | 2 |  | 10 | [NAME], Drs, [NAME] | 7140180009
C1 | WORKSHOP PTK | 6 |  | 11 | Sukestiyarno, [NAME] | 7140180010
C2 | WORKSHOP PENGEMBANGAN PERANGKAT PEMBELAJARAN | 32 |  | 12 | Wuryanto, Drs, M.Si | 7140180012
D | PEER TEACHING | 30 |  | 13 | [NAME],Prof, Dr, M.Pd | 7140180013
E | UJIAN TULIS | 4 |  | 14 | Wardono, Drs, M.Si | 7140180014
 | JUMLAH |  |  | 15 | Emi Pujiastuti, Dra., [NAME] | 7140180015
 |  |  |  | 16 | [NAME], [NAME]., M.S | 7140180016
 |  |  |  | 17 | [NAME], [NAME], M.Si | 7140180017
 |  |  |  | 18 | Arief Agustanto, Drs., M.Si | 7140180018
 |  |  |  | 19 | Mashuri, Drs., M.Si | 7140180019
 |  |  |  | 20 | Walid, S.Pd, M.Si | 7140180020
 |  |  |  | 21 | [NAME], Dr, M.Pd | 8140180021
 |  |  |  | 22 | Edy Soedjoko, Drs., [NAME] | 8140180022
 |  |  |  | 23 | [NAME], Dr, M.Si | 8140180023
 |  |  |  | 24 | Kusni, Dra, M.Pd | 8140180024
 |  |  |  | 25 | Isti Hidayah, Dr.,M.Pd | 8140180025
 |  |  |  | 26 | [NAME], Drs, SE, M.Si, [NAME] | 8140180026
 |  |  |  | 27 | [NAME], Dr, M.Si | 8140180027
 |  |  |  | 28 | Masrukan, Dr, M.Si | 9140180028
 |  |  |  | 29 | [NAME], S.Si, M.kom | 9140180029
 |  |  |  | 30 | Sugiarto, Drs. [NAME] | 11140180030
Spreadsheet: 840542d1692807574-match-cell-color-from-a-table-with-conditional-formatting-test1
Sheet: Sheet1

 | A1E1 | A1E2 | A1E3 |  | A1A1 | 225 |  | This is how the sheet would look to begin with.
 | A1D1 | A1D2 | A1D3 |  | A1A2 | 7205
 | A1C1 | A1C2 | A1C3 |  | A1A3 | 19614
 | A1B1 | A1B2 | A1B3 |  | A1B1 | 1257
 | A1A1 | A1A2 | A1A3 |  | A1B2 | 8192
 |  |  |  |  | A1B3 | 12672
 |  |  |  |  | A1C1 | 18304
 |  |  |  |  | A1C2 | 10664
 |  |  |  |  | A1C3 | 1159
 |  |  |  |  | A1D1 | 711
 |  |  |  |  | A1D2 | 10430
 |  |  |  |  | A1D3 | 13333
 |  |  |  |  | A1E1 | 5032
 |  |  |  |  | A1E2 | 896
 |  |  |  |  | A1E3 | 18940
 |  | Desired Result: Cells in B2:D6 copy the cell color of their corresponding values in the table on the right.
Spreadsheet: 058a3433-b96a-484a-9c79-82a0a34551b0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Travel and Training October 16, 2011  through January 15, 2012 | Unnamed: 4 | Unnamed: 5
 | Name | Month | Vendor | Amount | Description
City Manager | [NAME] | Oct 16 - Jan 15 |  |  | No activity for this period
Municipal Judge | [NAME] | Oct 16 - Jan 15 |  |  | No activity for this period
Governing Body |  | Oct 16 - Jan 15 |  |  | No activity for this period
Spreadsheet: 834831d1688112975-how-can-i-exclude-counting-calc-when-using-the-function-countif-questions-for-count-if-function
Sheet: Output

Total Access
Total Pending
 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120 | 121 | 122 | 123 | 124 | 125 | 126 | 127 | 128 | 129 | 130 | 131 | 132 | 133 | 134 | 135 | 136 | 137 | 138 | 139 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | 151 | 152 | 153 | 154 | 155 | 156 | 157 | 158 | 159 | 160 | 161 | 162 | 163 | 164 | 165 | 166 | 167 | 168 | 169 | 170 | 171 | 172 | 173 | 174 | 175 | 176 | 177 | 178 | 179 | 180 | 181 | 182 | 183 | 184 | 185 | 186 | 187 | 188 | 189 | 190 | 191 | 192 | 193 | 194 | 195 | 196 | 197 | 198 | 199 | 200 | 201 | 202 | 203 | 204 | 205 | 206 | 207 | 208 | 209 | 210 | 211 | 212 | 213 | 214 | 215 | 216 | 217 | 218 | 219 | 220 | 221 | 222 | 223 | 224 | 225 | 226 | 227 | 228 | 229 | 230 | 231 | 232 | 233 | 234 | 235 | 236 | 237 | 238 | 239 | 240 | 241
Access Status |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Access | 1
Access | 2
Access | 3
Access | 4
Access | 5
Access | 6
Access | 7
Access | 8
Access | 9
Access | 10
Access | 11
Access | 12
Access | 13
Access | 14
Access | 15
Access | 16
Access | 17
Access | 18
Access | 19
Access | 20
Access | 21
Access | 22
Access | 23
Access | 24
Access | 25
Access | 26
Access | 27
Access | 28
Access | 29
Access | 30
Access | 31
Access | 32
Access | 33
Access | 34
Access | 35
Access | 36
Access | 37
Access | 38
Access | 39
Access | 40
Access | 41
Access | 42
Access | 43
Access | 44
Access | 45
Access | 46
Access | 47
Access | 48
Access | 49
Access | 50
Access | 51
Access | 52
Access | 53
Access | 54
Access | 55
Access | 56
Access | 57
Access | 58
Access | 59
Access | 60
Access | 61
Access | 62
Access | 63
Access | 64
Access | 65
Access | 66
Access | 67
Access | 68
Access | 69
Access | 70
Pending | 1
Pending | 2
Pending | 3
Pending | 4
Pending | 5
Pending | 6
Pending | 7
Pending | 8
Pending | 9
Pending | 10
Pending | 11
Pending | 12
Pending | 13
Pending | 14
Pending | 15
Pending | 16
Pending | 17
Pending | 18
Pending | 19
Pending | 20
Pending | 21
Pending | 22
Pending | 23
Pending | 24
Pending | 25
Pending | 26
Pending | 27
Pending | 28
Pending | 29
Pending | 30
Pending | 31
Pending | 32
Pending | 33
Pending | 34
Pending | 35
Pending | 36
Pending | 37
Pending | 38
Pending | 39
Pending | 40
Pending | 41
Pending | 42
Pending | 43
Pending | 44
Pending | 45
Pending | 46
Pending | 47
Pending | 48
Pending | 49
Pending | 50
Spreadsheet: bbdf8311-6b49-4912-a6b6-e9944932c2e5
Sheet: Sheet1

Software | Vendor | Street | City | St | Zip | Phone | e-mail | Contact | Oct 31
Account | SchoolNet Inc. |  |  |  |  | (212) 645-0615 | [EMAIL]; | [NAME]
Administrator's Plus | Rediker Software | 2 Wilbraham Road | Hampden | MA | 01036 | 8002139860 | [EMAIL]; [EMAIL]; [EMAIL]; | [NAME] [NAME][NAME]
CIC | Computer Information Concepts Inc. | 2843 31st Avenue | [NAME] | CO | 80631 | 8004377457 | [EMAIL]; [EMAIL]; [EMAIL]; | [NAME][NAME]
eSchoolPlus | Sungard Pentamation Inc. | 3 West Broad Street | Bethlehem | PA | 18018 | 6106913616 | [EMAIL]; | [NAME] Feather
eSIS | Administrative Assistants Limited Solutions (AAL Solutions) | 101 Red Cedar #2 P O Box 7320 | [NAME] | NV | 89452 | (289) 313-1012 Direct                          (800) 668-8486 x1012 | [EMAIL]; | [NAME]
FastDirect | FastDirect Communications | 150 Prospect Avenue | Kirkwood | MO | 63122 | 3148223278 | [EMAIL]; | [NAME]
Synergy Student Information System | Edupoint |  |  |  |  | (800) 914-9815 | [EMAIL];                          [EMAIL];             tswietek@edupoint;   [EMAIL];                            [EMAIL]; | [NAME]            [NAME]
Infinite Campus Inc. | Infinite Campus |  |  |  |  | (651) 631-0000 (763) 795-4174 | [EMAIL]; [EMAIL]; tracy.jackson@infinite campus.com; | [NAME]Justin Elston               [NAME]
Web Student (Skyward) | Skyward | 5233 [NAME] | [NAME] | WI | 54481-0166 | 8002367274 | [EMAIL];                 [EMAIL]; | Kris Lepak                         [NAME]
PowerSchool | Pearson School Systems | 80 Iron Point Circle, #200 | Folsom | CA | 95630 | (480) 457-7435 | [EMAIL]; | Dawn Colon
Go.edustar | Harris School Solutions |  |  |  |  | (316) 494-6300 (800) 456-4685 | [EMAIL]; [EMAIL]; [EMAIL]; | [NAME]                  Kayla Nickel                      Mary Andyshak
Schoolmaster | Tyler Technologies Inc. - Schoolmaster Division | 7249 Capitol Blvd South | [NAME] | WA | 98501-5519 | (800) 733-0922   x-151109 For [NAME] or [NAME] For [NAME] | [EMAIL]; [EMAIL]; | [NAME]
EDR SIS | Educational Data Resources (EDR) | 3016 Dade Avenue | Orlando | FL | 32804 | (321) 282-7032 | [EMAIL]; | [NAME]
Silk SIS | Excelsior Software (Formerly [NAME]) | 3609 S Wadsworth Blvd, #310 | Lakewood | CO | 80235 | (800) 727-2728 | [EMAIL]; [EMAIL]; | [NAME]       [NAME]
STI-K12 | Software Technology Inc. | 4721 Morrison Drive #200 | Mobile | AL | 36609 | 8008440884 | [EMAIL];                     [EMAIL]; [EMAIL]; [EMAIL]; | [NAME]
Spreadsheet: 108524d1305580283-multi-layer-product-if-formula-multi-product-if-sample-book
Sheet: Sheet1

Group 1 | 0 | 0.28 | 0.5 | 0
Group 2 | 0 | 0.36 | 0.5 | 1
Group 3 | 1 | 0.36 | 0 | 0
Group 4 | 0 | 0 | 0 | 0
 | Dim 1 | [NAME] | [NAME] | [NAME] |  | Group 1 | Group 2 | Group 3 | Group 4
Item #
1 | 150 | 1500 | 150 | 275
2 | 150 | 1500 | 150 | 275
3 | 150 | 1500 | 150 | 275
4 | 150 | 1500 | 150 | 275
5 | 900 |  |  | 300
6 | 150 | 1100 | 200 | 275
7 | 150 | 300 | 36 | 275
8 | 150 | 300 | 51 | 275
9 | 150 | 450 | 39 | 275
10 | 150 | 500 | 150 | 275
Spreadsheet: 5566003d-db4d-491e-83ec-8e862a27176b
Sheet: Indtast brændsler og produktion

Indtastning af brændsler- og produktionsdata for fjernvarmeværket
Kraftvarmeanlæg
Antal anlæg | Anlæg | Type* | [NAME] | Brændselsforbrug | Varmeproduktion | Elproduktion | Marginal % | Elvirkningsgrad
 |  |  | ** | pr. enhed | MWh | MWh | ***
1 | Naturgaskraftvarme | [NAME] |  | 10000 | 53 | 45 | 80
2
3
4
5
I alt
* Decentrale naturgasfyrede motoranlæg er altid modtryksanlæg. Dampturbiner er normalt udtagsanlæg, men nogle anlæg [NAME].
** Skal kun indtastes for udtagsanlæg
*** Indtast en vægtning af hvor stor en del af tiden anlægget er marginal over året. Sum af marginaler skal give 100. Indsæt ikke 2 helt ens tal.
Kedelanlæg
Antal anlæg | Anlæg |  |  | Brændselsforbrug | Varmeproduktion |  | Marginal %
 |  |  |  | pr. enhed | MWh |  | ***
1 | Naturgaskedel |  |  | 2000 | 20 |  | 20
2
3
4
5
I alt
Andre varmeproduktionsanlæg
Antal anlæg | Anlæg |  |  | Elforbrug [NAME] | Varmeproduktion |  | Marginal % | COP ****
 |  |  |  | pumpe **** MWh | MWh |  | *** | (elforb./varme)
1 |  |  |  | 326 | 815
2
3
4
**** Kun relevant for varmepumpeanlæg. Vær opmærksom på at varmeproduktion varmepumpe kan være indeholdt i ovenstående tabeller (kraftvarme/kedel)
[NAME] % |  | 0.25
Spreadsheet: 60934d1261512206-parsing-address-zipcode-zc-parse
Sheet: Sheet1

 | City | State | Zip | 1st 4 of Zip | Last 4 of Zip
BLOOMINGTON IN 47403-4738 | BLOOMINGTON | IN | 47403-4738 | 47403 | 4738
WESTPORT IN 47283-9414 | WESTPORT | IN | 47283-9414 | 47283 | 9414
INDIANAPOLIS IN 46234-5051 | INDIANAPOLIS | IN | 46234-5051 | 46234 | 5051
Spreadsheet: 474012d1470575256-need-a-overview-as-a-chart-or-easy-access-widget-0eldere-427328d1445985346-sum-only-the-rows-which-have-the-same-date-but-a-little-more-compli
Sheet: Blad1

Rijlabels | Som van ADDED
2015-10-16 00:00:00 | 3740
C-17 | 249
PM333 | 0
PM551 | 70
PM586 | 449
PM596 | 0
PM601 | 76
PM603 | 0
PM604 | 48
PM606 | 471
PM607 | 0
[NAME] | 35
PM641 | 162
PM669 | 306
R316 | 0
R401 | 222
R404 | 85
R405 | 0
R408 | 0
R435 | 323
R436 | 0
R496 | 64
R497 | 0
R520 | 98
R521 | 46
R524 | 228
R525 | 77
R526 | 0
R529 | 0
R530 | 32
R531 | 0
R533 | 0
R538 | 0
R540 | 168
R543 | 36
R544 | 2
R573 | 0
R576 | 24
R579 | 269
R633 | 200
R675 | 0
Eindtotaal | 3740
Spreadsheet: a2442367-ca0a-4df5-a74c-0483f6e7ac81
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: |  |  | 2014-06-11 09:17:53.430000
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.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.75 | 102.625 | 102.5 | 102.125
4.5 | 102.351 | 102.226 | 102.101 | 101.726 |  | Note: | Refer To Price [NAME]
4.375 | 101.615 | 101.49 | 101.365 | 100.99 |  |  | For all Price Adjs
4.25 | 101.022 | 100.897 | 100.772 | 100.147
4.125 | 100.185 | 100.06 | 99.935 | 99.31
4 | 99.185 | 99.06 | 98.935 | 98.31
3.875 | 98.14 | 98.015 | 97.89 | 97.265
3.75 | 97.265 | 97.14 | 97.015 | 96.39
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.567 | 102.442 | 102.317 | 101.942
3.625 | 102.178 | 102.053 | 101.928 | 101.553
3.5 | 101.629 | 101.504 | 101.379 | 101.004
3.375 | 100.912 | 100.787 | 100.662 | 100.287
3.25 | 100.163 | 100.038 | 99.913 | 99.288
3.125 | 99.6 | 99.475 | 99.35 | 98.725
3 | 98.85 | 98.725 | 98.6 | 97.975 |  | 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 | 2014-06-25 09:17:53.430000
30 DAY | 2014-07-10 09:17:53.430000
45 DAY | 2014-07-25 09:17:53.430000
60 DAY | 2014-08-09 09:17:53.430000
90 DAY | 2014-09-08 09:17:53.430000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: michelle_lokay__26568__sharris1200wk3
Sheet: Actuals V. Plan

Transwestern Pipeline Company
($[NAME])
 |  |  |  |  |  | 2000-12-21 16:01:31.260000
 |  | December, 2000
 |  | Plan | Estmate | [NAME] |  | Comments
 |  | .
West Demand Revenues |  | 9.847299999999999 | 10.50537734 | 0.6580773400000002 |  | Prices in excess of $0.12/mmbtu on 63/day; Higher Rates due to LFT to California ($310K)
West Commodity Revenues |  | 0.7731999999999999 | 0.8344216406999996 | 0.06122164069999969
East Demand Revenues |  | 1.1255 | 1.1739921278 | 0.0484921277999999 |  | Burlington 24216--($53k); offset by new firm contracts
East Commodity Revenues |  | 0.171 | 0.1756174837 | 0.00461748369999998
[NAME] |  | 0.6644000000000001 | 0.67280075 | 0.008400749999999846
[NAME] Revenues |  | 0.0585 | 0.1193343613000001 | 0.06083436130000006 |  | Higher IT volumes than in plan
 |  | ------------- | ------------- | -------------
Revenue Variance |  | 12.6389 | 13.4815437035 | 0.8426437035000003
[NAME] due to Price |  |  |  | 1.989357629163279 |  | Adjusted Current index price of $7.60
[NAME] due to net fuel retention. |  |  |  | -0.2671413213778493 |  | Lower Net retainage volumes (lower east volumes & higher usage)
Hedging Adjustment |  |  |  | 0.61845 |  | First of the month Index Price $6.27
Unaccounted for Variance |  |  |  | -0.177
[NAME] |  |  |  | -0.8977040000000001 |  | Difference between Month-to-date Index Price and Sales Price
 |  |  |  | -------------
Fuel Variance |  |  |  | 1.26596230778543 |  | Higher than [NAME]. Forecast; due to higher index price and west vols.
 |  |  |  | -------------
TOTAL MONTH-TO-DATE VARIANCE |  |  |  | 2.10860601128543
 |  |  |  | ========
Resolution of El Paso Measurement Dispute |  |  |  | 0
 |  |  |  | -------------
Adjusted Month-to-Date Variance |  |  |  | 2.10860601128543
 |  |  |  | ========
[NAME]
 |  | Year-to-Date | Year-to-Date | Year-to-Date
 |  | Margin | Fuel & UAF | Total
Plan (including December) |  | 147.1637 | 20.9822 | 168.1459
Actuals through November w/ Dec. Wkly. |  | 150.2083437035 | 29.37045069783899 | 179.578794401339
 |  | ------------- | ------------- | -------------
Variance from Plan |  | 3.044643703500014 | 8.388250697838988 | 11.432894401339
 |  | ------------- | ------------- | -------------
Resolution of El Paso Measurement Dispute |  |  |  | 3
 |  |  |  | -------------
Adjusted Variance from Plan |  |  |  | 14.432894401339
 |  |  |  | ========
Spreadsheet: 191486d1352133478-help-with-creating-form-in-excel-that-pulls-data-from-table-oor-survey-template-draft-5-nov-2012
Sheet: Template

 | Door Survey Sheet
Page       of |  | CSC |  | Date   10-30-12 | Completed By         Salesman's Name
Customer |  |  |  |  | General Comments
Customer#
Address
City, State, Zip
Store # (if applicable)
Contact Names
Phone
Fax
e-mail
Location# | Location Name | Door / Installation | Door Description | Manufacturer | Single Swing | Dual Swing | Single Slide | Bi-Parting Slider | Single Fold | Bi-Fold | Revolver | Total Operators | Comments