tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 758454d1638884877-calculate-the-hourly-difference-between-the-first-time-two-status-have-been-triggered-test-data-example-etaf
Sheet: Sheet1

Application  ID | Status | Status Date/Time | time difference | SOLUTION |  |  |  |  |  |  |  | MIN BY ID
40647563 | Affordability Incomplete | 2021-05-04 13:11:00 |  |  |  | MIN(IF(rng1=criteria1,IF(rng2=criteria2,values)))
40647563 | Affordability Product Incomplete | 2021-05-04 13:32:00 |  |  |  | MIN(IF(C2:C8=C11,D2:D8))
40647563 | Affordability Referred | 2021-05-04 13:32:00
40647563 | Affordability Manual Assessment | 2021-05-04 13:33:00
40647563 | Affordability Accepted | 2021-05-04 13:34:00
40647563 | App incomplete | 2021-05-04 13:34:00
40647563 | App referred | 2021-05-04 22:14:00
40647563 | App Manual Assessment | 2021-05-05 10:24:00
40647563 | App accepted | 2021-05-05 10:25:00
40647563 | App Manual Assessment | 2021-05-05 10:25:00
40647563 | Awaiting documents | 2021-05-05 10:33:00
40647563 | Application awaiting QA | 2021-05-12 15:19:00
40647563 | App Manual Assessment | 2021-05-13 15:34:00
67434572 | Affordability Incomplete | 2021-06-11 12:28:00
67434572 | Affordability Product Incomplete | 2021-06-11 14:04:00
67434572 | Affordability Offered | 2021-06-11 14:09:00
67434572 | Affordability Referred | 2021-06-11 14:17:00
67434572 | Affordability Incomplete | 2021-06-11 14:36:00
67434572 | Affordability Product Incomplete | 2021-06-11 15:16:00
67434572 | Affordability Offered | 2021-06-11 15:16:00
67434572 | Affordability Incomplete | 2021-06-11 15:17:00
67434572 | Affordability Product Incomplete | 2021-06-11 15:17:00
67434572 | Affordability Offered | 2021-06-11 15:17:00
67434572 | Affordability Referred | 2021-06-11 15:23:00
67434572 | Affordability Manual Assessment | 2021-06-11 15:34:00
67434572 | Affordability Accepted | 2021-06-11 15:34:00
67434572 | Affordability Incomplete | 2021-06-11 15:40:00
67434572 | Affordability Product Incomplete | 2021-06-11 16:06:00
67434572 | Affordability Offered | 2021-06-11 16:06:00
67434572 | Affordability Referred | 2021-06-11 16:06:00
67434572 | Affordability Manual Assessment | 2021-06-11 16:13:00
67434572 | Affordability Accepted | 2021-06-11 16:13:00
67434572 | App incomplete | 2021-06-11 16:23:00
67434572 | App referred | 2021-06-11 16:48:00
67434572 | App Manual Assessment | 2021-06-11 16:57:00
67434572 | App accepted | 2021-06-14 09:50:00
67434572 | App Manual Assessment | 2021-06-14 09:50:00
67434572 | Awaiting documents | 2021-06-14 10:02:00
67434572 | App not proceeding | 2021-09-16 12:28:00
Spreadsheet: 114484d1310182665-conditional-formatting-with-list-and-special-character-tesst-11
Sheet: Sales Report & TLR

 |  |  |  |  |  |  |  | Legend: D- Discovery Q- Qualified RFI - Request for [NAME] for Proposal PS - Proposal Submitted A - Accepted R -  L - Lost
STATUS | SALES REP | OPPORTUNITY | # OF ENROLLMENT | EST. $ INCOME SIZE | STAGE OR SALES CYCLE | EST. DATE | COMMENTS | NEXT STEP
u | Rep Name here | Name of the company | 5509 | 6000 | A | 2011-07-08 00:00:00 | Comments relating to this lead here. | Short Description of Next Step
u |  |  |  |  | A |  |  |  |  | D
u |  |  |  |  | R |  |  |  |  | Q
u |  |  |  |  | PS |  |  |  |  | RFI
u |  |  |  |  | RFP |  |  |  |  | RFP | u
 |  |  |  |  | D |  |  |  |  | PS | u
 |  |  |  |  |  |  |  |  |  | A | u
 |  |  |  |  |  |  |  |  |  | R | u
 |  |  |  |  |  |  |  |  |  | L
Spreadsheet: lynn_blair__24484__NNGWKednotes_2001
Sheet: July 7 & 8, 2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-07-07 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | FRI |  |  | No difficulties with the process.
 | 8:00 AM Final Storage
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 11:30 A.M. Timely
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 6:00 P.M. Evening
 | Other Comments: |  |  |  | Trace Tool is inoperable  - [NAME]
 | On Call Reps. |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 8:00 AM Final Storage
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | MON |  |  | No difficulties with the process.
 | 11:30 A.M. Timely
 | Gas Day: | MON |  |  | No difficulties with the process.
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps: |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
Spreadsheet: 538424d1505599932-multi-page-order-sheet-with-summary-page-lbm-order-sheet-sample
Sheet: Hardi

Item # | [NAME] | Description
0285-0029 |  | [NAME] HZ5;PRIMED 5-1/4"x12 CRDML
0285-0030 |  | [NAME] EE HZ5;PRIMED 6-1/4x12 CRDML
0285-0031 |  | [NAME] EE HZ5;PRIMED 7-1/4"x12' CRDML
0285-0032 |  | [NAME] EE HZ5;PRIMED 8-1/4"x12' CRDML
0285-0038 |  | HARDI-PNL PRMD 4 x  8;CEDARMIL
0285-0039 |  | HARDI-PNL PRMD 4 x  8;SMOOTH
0285-0040 |  | HARDI-PNL PRMD 4 x  8;STUCCO
0285-0045 |  | HARDI-PNL PRMD 4 x 10;CEDARMIL
0285-0046 |  | HARDI-PNL PRMD 4 x 10;SMOOTH
0285-0047 |  | HARDI-PNL PRMD 4 x 10;STUCCO
0285-0085 |  | HARDI-PLK Z5  CDRMIL;12" x 12
0285-0165 |  | [NAME] EE HZ5;PRIMED 6-1/4"x12' SMOOTH
0285-0169 |  | [NAME] (4.2/5.5;/6.75/7.25/10) 1sq PRIME
0285-0171 |  | HARDI-SHINGLE PRIMED;15.25"x48 (1sq = 43pcs)
0285-0172 |  | [NAME] EE HZ5;COB STN 8-1/4"x12' CRDML
0285-0173 |  | [NAME] STN 8-1/4"x12' CRDML
0285-0174 |  | [NAME] EE HZ5;IRN GREY 8-1/4"x12 CRDML
0285-0175 |  | [NAME] BLUE 8-1/4"x12 CRDML
0285-0176 |  | [NAME] SAGE 8-1/4"x12 CRDML
0285-0177 |  | [NAME] EE HZ5;C/LANE 8-1/4"x12 CRDML
0285-0178 |  | [NAME] TAUP 8-1/4"x12 CDRML
0285-0179 |  | [NAME] WHT 8-1/4"x12' CRDML
0285-0180 |  | [NAME] EE;AUTM TAN 8-1/4"x12' CDML
0285-0181 |  | [NAME] EE;KHAK BRN 8-1/4"x12' CDML
0285-0182 |  | [NAME] EE;TMBRBARK 8-1/4"x12' CRDM
0285-0183 |  | [NAME] EE;WDSTBRN 8-1/4"x12' CRDML
0285-0184 |  | [NAME] 8-1/4"x12' CRDML
0285-0185 |  | [NAME] EE;HEATMOSS 8-1/4"x12' CRDM
0285-0186 |  | [NAME] EE;NAVABEIG 8-1/4"x12' CRDM
0285-0187 |  | [NAME] EE;KHAKBRN 7-1/4"x12' CRDML
0285-0188 |  | [NAME] EE;MONTAUP 7-1/4"x12' CRDML
0285-0189 |  | [NAME] 7-1/4"x12' CRDM
0285-0190 |  | [NAME] EE;HEATMOSS 7-1/4"x12' CDRM
0285-0191 |  | [NAME] EE MNT;SAGE 7-1/4"x12' CRDML
0285-0192 |  | [NAME] EE;WDSTBRN 7-1/4"x12' CRDML
0285-1270 |  | HARDI-TRIM XLD PRIMED;4/4 RU 3/4x3.5x12'
0285-1271 |  | HARDI-TRIM XLD PRIMED;4/4 RU 3/4x5.5x12'
0285-1272 |  | HARDI-TRIM XLD PRIMED;4/4 RU 3/4x7.25x12'
0285-1273 |  | HARDI-TRIM XLD PRIMED;4/4 RU 3/4x9.25x12'
0285-1274 |  | HARDI-TRIM XLD PRIMED;4/4 RU 3/4x11.25x12'
0285-1275 |  | HARDI-TRIM XLD PRIMED;5/4 RU 5/4x4x12'
0285-1276 |  | HARDI-TRIM XLD PRIMED;5/4 RU 5/4x6x12'
0285-1277 |  | HARDI-TRIM XLD PRIMED;5/4 RU 5/4x8x12'
0285-1278 |  | HARDI-TRIM XLD PRIMED;5/4 RU 5/4x10x12'
0285-1279 |  | HARDI-TRIM XLD PRIMED;5/4 RU 5/4x12x12'
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: KivO.B

Ambient on/off
eRepublik – Online Strategy Game
Sep20 Day 1,400 of the New World
Home
My Land
Wars
Market
Marketplace
Job market
Monetary market
Companies for sale
Community
World Map
News
My Party
Elections
Military Unit
Country administration
Invite friends
Badges
Get Gold & Extras
[NAME]
[NAME]
27
60
Eat food
Gold2.24 Gold
BAM411 BAM
HRK1625 HRK
Missions
X
You don't have enough Gold to complete the task Get Gold
Completed!
2011-10-03 00:00:00
2011-10-03 00:00:00
2011-10-03 00:00:00
Reward
Ok
Congratulations, your rank is now
Rank Bonus on attack +5%
Energy bar
Ok
Strength
Experience points
Health
Rank points
Gold
Energy bar
[NAME]
Free Lands
Scope
Bazooka
Weapons
Weapons
Weapons
Food units
Food units
Food units
Grain Farms
0 0
Logout
Experience level: 27
Experience points: 10027
Next level at: 15000
• Working, training and fighting decreases health
[NAME], health boxes, food, hospitals restore health.
This action restores as much health as possible by eating Food from your Storage.
You can recover up to: 450 / 450 Health
100 more recoverable Health in: 00:59:59
Food limit reached
You have reached your food consumption limit.
You can recover 100 health every hour.
100 more recoverable Health in: [NAME]
Buy health kit Close
KivO.B
offlineKivO.B
Remove friend Send message Donate
Experience level 27
10,455 / 15,000
Location: PolandPoland, Great Poland Citizenship: CroatiaCroatia
eRepublik birthday
Apr 20, 2011
National rank: 1414
Party Member
[NAME] eHrvatskeSavez Komunista eHrvatske Far-left Wing
Member
HV 1.GB Tigrovi HV 1.GB Tigrovi
No media activity
Friends(792)
Zvoone26
[NAME]
[NAME]
[NAME]
[NAME]
Igorb31
Beks0401
Tome17
Cuky 25
view all
Land of KivO.B: 22 buildings
Visit
About me
Wiki page
*** I KRV SVOJU ZA BRIGADU MOJU ***
http://www.youtube.com/watch?v=4Y6b-coiqvk
Achievements
hard worker
5
Hard Worker
Worked 30 days in a row
congressman
Congress Member
Win the Congress elections
president
Country President
Win the Presidential elections
media mogul
Media Mogul
Reach 1000 subscribers to your newspaper
battle hero
Battle Hero
Reach the highest war influence in a battle
campaign hero
Campaign hero
Reach the highest war influence in a campaign
resistance hero
Resistance Hero
Start a resistance war and liberate that region
super soldier
7
Super Soldier
Advance 250 strength points
society builder
Society Builder
Invite 10 people to eRepublik and help them reach level 10
mercenary
Mercenary
Defeat 25 enemies for 50 different countries
Coming soon
Coming soon
Military Skills
Strength
1,821.00
Super soldier:1,821 / 2,000
Rank
Colonel *Colonel *
Rank points:
425,322 / 435,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 45735d1244553282-nesting-vlookup-in-if-vice-versa-and-pivot-table-copy-of-sample3
Sheet: Jan Summary

 | Amount-Cat1 | Amount-Cat2
500 | -174.29 | 245.7489
750 | -2262.167420000004 | 3189.656062200006
AB | -661.97716 | 933.3877956
AD | -53.8898 | 75.984618
AL | -1523.33 | 2147.8953
BX | -4056.255 | 5719.31955
BZ | -3228.96 | 4552.8336
CA | -1841.355 | 2596.31055
CB | -402.3125 | 567.260625
DF |  | 1143.86391
DS |  | 910.56672
FA |  | 519.2621099999999
GL | -2868.781915198807 | 4044.982500430317
GM | -221.0269653693443 | 311.6480211707755
MF | -755.3130685052638 | 1064.991426592422
MR | -9278.193647035247 | 13082.2530423197
OA | -328.2282893398016 | 462.8018879691202
OB | -123.2664119982595 | 173.8056409175458
OR | -154.8486199890987 | 218.3365541846291
ZP | -271.5391654515289 | 382.8702232866557
Spreadsheet: 107424d1304599166-need-formula-for-a-macro-function-example
Sheet: 10

1097
Name | Amount
Name 2 | 192
Name 2 | 132
Name 3 | 148
Name 2 | 102
Name 3 | 141
Name 1 | 135
Name 3 | 140
Name 2 | 170
Name 1 | 149
Name 2 | 137
Name 2 | 115
Name 2 | 140
Name 3 | 168
Name 1 | 190
Name 2 | 125
Name 1 | 141
Name 3 | 154
Name 3 | 138
Name 2 | 175
Name 2 | 164
Name 1 | 164
Name 1 | 138
Name 2 | 116
Name 3 | 111
Name 1 | 180
Spreadsheet: 16c0646d-9f7b-4557-b1f0-b5748af1739e
Sheet: 37

شركت ساختماني گسترش و نوسازي صنايع ايرانیان مانا ([NAME])
يادداشتهاي [NAME] مالي
دوره مالي شش ماهه منتهي به 31 خرداد 1390
24-1- بهای تمام شده پِيمان در90/03/31 از اقلام زيرتشکيل [NAME]
کارگاهها | [NAME] |  |  |  |  |  |  | جمع                1390/03/31 |  | جمع1389/09/30
 | حقوق ودستمزد | [NAME] | [NAME] | هزینه استهلاک | هزینه های عمومی | هزینه های مالی | هزینه های مواد ولوازم مصرفی
مترو | 0 | 0 | 209112575 |  | 93979299 |  | 0 |  |  | 2
[NAME] |  |  |  |  |  |  |  |  |  | 473
ژنراتورسازی [NAME] |  |  |  |  |  |  |  |  |  | -1466
ساختمان مرکزی نیرو | 0 | 0 | 46562663 |  |  | 60923113 | 0 |  |  | 415
سد بید واز | 0 | 11043760 | 139688240 |  |  | 91159999 | 0 |  |  | 113
لوله بدون درز اسفراین | 3000857 | 2041500 | 4594500 |  | 3711000 | 0 | 4713625140 |  |  | 68
سیمان حما | 0 | 0 | 0 | 3563385 | 144477523 | 0 | 0 |  |  | 7
آلومینیوم اراک | 1095489896 | 63972131 | 185225669 | 25613734 | 63107000 | 149825644 | 1661592505
پتروشیمی ماهشهر | 0 | 48964361 | 268397530 | 2950878 | 25811000 | -4756164 | 0 |  |  | 94
[NAME] صادرات مشهد | 719938464 | 14964499 | 7208256731 | 124562140 | 8505000 | 396329773 | 10616395482 |  |  | 33515
شهرداری مشهد | 944335 | 0 | 308306722 | 18828801 | 0 | 0 | 0 |  |  | 2367
مجتمع ورزشی شیراز | 2507832384 | 138460876 | -347663827 | 123465581 | 21940575 | 86903275 | 680627345 |  |  | 15105
آندرادینگ اراک | 1503952516 | 148586700 | 1553349704 | 14845040 | 88537576 | 46773076 | 2602471214 |  |  | 9316
امید 2 | 1504868882 | 122046100 | 1257733637 | 161315387 | 10269072 | 454837469 | 2318563517 |  |  | 29460
فولاد زرند ایرانیان | 0 | 0 | 334968546 | 0 | 0 | 0 | 0 |  |  | 617
موننکو ایران اسکلت | 2399220 | 4451000 | 14416600 | 0 | 0 | 44569834 | 22000 |  |  | 6550
بلوار معلم | 4767175947 | 478478210 | 4195733252 | 132025547 | 88523600 | 93215192 | 3116502201 |  |  | 15821
احداث کارخانه کک سازی زرند | 7903177868 | 923628041 | 61127167656 | 322560045 | 587675576 | 1866163 | 25213208472 |  |  | 96199
حصارکشی کنسانتره سیرجان | 60164604 | 0 | 0 | 0 | 0 | 30000 | 0 |  |  | 216
سیویل کنسانتره جلال آباد | 3911006347 | 983602099 | 3651611550 | 224181783 | 2064000 | 3396250 | 16923004264 |  |  | 31298
نیاوران | 356628638 | 469000 | 1333586334 | 2935733 | 733000 | 65000 | 2072248884 |  |  | 7588
طرح و اجرای [NAME] ایران | 0 | 0 | 661000 | 0 | 0 | 39157714 | 0 |  |  | 10767
استادیوم 50 هزار نفری شیراز | 2275839186 | 180778604 | 1220974911 | 171645719 | 118250786 | 555715881 | 12564392087 |  |  | 14792
تصفیه آب شرب مشهد | 1613246253 | 86670550 | 4432885068 | 59113537 | 80809802 | 121929999 | 2953032596 |  |  | 458
[NAME] | 448057562 | 36580600 | 264579517 | 2296388 | 4723500 | 68482491 | 165584772 |  |  | 10098
[NAME] | 456376573 | 41949990 | 462918957 | 72119965 | 28415232 | 103861438 | 1142884992 |  |  | 3054
[NAME] شوئی پابدانا | 673620601 | 135064925 | 4388316190 | 12162916 | 0 | 1696692 | 3278535587 |  |  | 335
[NAME] | 722112039 | 108374450 | 37742328449 | 0 | 952160688 | 236014782 | 657526900
[NAME] |  |  |  |  |  |  |  |  |  | 292372
Spreadsheet: 5457c1a9-4118-409b-b8fd-ce10e4570ca3
Sheet: Sheet1

Unnamed: 0 | FORMULARIO DE REEMBOLSO PARA SUBSIDIOS DE RELACIONES PÚBLICAS DE ROTARY INTERNATIONAL | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Distrito___________________________ | AF RI 11-12
 | Nombre/correo [NAME]______________________  MONTO DEL SUBSIDIO ___________ | SE ADJUNTA FORMULARIO PARA LA EMISIÓN DEL PAGO A SE ADJUNTA INFORME A |  |  | SPA TO A/P ________________
 |  |  |  |  |  |  | CONSTANCIA DE ACTIVIDADES REALIZADAS
 | Sírvase consultar los gastos admisibles en la carta de aprobación. [NAME] con este formulario copia [NAME] proveedores, comprobantes de pago (recibos, cheques cancelados, etc.), [NAME] realizadas Y el Formulario para la emisión del pago. En el sitio web de Rotary International encontrará información sobre [NAME]. http://www.rotary.org/RIdocuments/es_pdf/rits_payment_guidelines_es.pdf
 |  |  |  |  | SE ADJUNTA RECIBO | SE ADJUNTA FACTURA
 |  |  | MONEDA | GASTO TOTAL
 | [NAME] Y DESCRIPCIÓN DEL GASTO | FECHA
 | Office Use Only. Notes: |  | Subtotal |  | Moneda local
 |  |  | Office Use Only |  | Currency exchange rate
 |  |  |  |  | Total US$
 |  |  |  |  | [NAME] amount  (local currency)
 |  |  | TOTAL |  | TOTAL  US$ AMOUNT PAID
Spreadsheet: acc5e715-dd0d-4d3b-a547-a0b7630e9411
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
JO1 | Test | JO1 | Jo 1 Antibodies, IgG, Serum | [NAME], IgG, S | [NAME] | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.35 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <1.0 U (negative) > or =1.0 U (positive) Reference values apply to all ages. | Monday through Saturday; 4 p.m., Sunday; 11a.m. | 1 day | 2 days | 1 | 86235 |  |  |  |  | Rochester
JO1 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
JO1 | Result | JO1 | [NAME], IgG, S | [NAME], IgG, S | Numeric |  |  |  |  | U |  |  |  |  |  |  |  |  |  | 33571-1 | Jo-1 extractable nuclear [NAME].IgG:ACnc:Pt:Ser:Qn:
Spreadsheet: 118412d1313670102-error-in-cell-entry-for-24-hour-clock-airframehours
Sheet: Sheet1

 |  |  |  |  |  |  | 50 Hr Check |  | TT Engine Hrs | TT A/F Hrs | Prop Hours
 | Brakes off | Take off | Landing | Brakes on | Flight time | Total time | 2 days, 2:00:00 | Alert | 4 days, 4:00:00 | 66 days, 16:00:00 | 104 days, 4:00:00
 | 9:55:00 | 10:00:00 | 11:00:00 | 11:05:00
 | 955 | 1000 | 1100 | 1105
 | 2350 | 100 | 210 | 215
 | 800 | 805 | 855 | 865
Spreadsheet: 879904d1727492302-filtering-data-using-mulitple-criteria-with-and-and-or-functions-test-dynamic-filtering
Sheet: Data

Tax ID | Address | Sqft | $/Sqft | Acres | Sale Price | Instrument Date | File Date | Grantor | Grantee | Building Type | City | Area | Zoning | A |  | Total Listings
23185 | 1658 Highway 45 | 45526 |  | 3.6 | 4800000 | 2020-01-08 00:00:00 | 2020-01-09 00:00:00 | N/A | N/A | Hospitality | Rapid City | NE Rapid | General Commercial District | Hotel Limited Service
46985 | 6584 HIGHWAY 87 | 4586 |  | 2.02 | 564000 | 2020-01-09 00:00:00 | 2020-01-10 00:00:00 | N/A | N/A | Hospitality | Custer | Southern Hills | Highway Service | Motel
12584 | 13652 [NAME] | 84965 |  | 2.59 | 984000 | 2020-01-10 00:00:00 | 2020-01-11 00:00:00 | N/A | N/A | Industrial | Rapid City | Black Gap | Light Industrial District
85425 | 65314 Elm Ave | 132 |  | 1.23 | 456100 | 2020-01-11 00:00:00 | 2020-01-12 00:00:00 | N/A | N/A | Land | [NAME] | [NAME] | No Code
54593 | 6458 Elm Ave | 8964 |  | 0.77 | 150000 | 2020-01-12 00:00:00 | 2020-01-13 00:00:00 | N/A | N/A | Land | [NAME] | [NAME] | No Code
25545 | 5631 Highway 45 | 802 |  | 0.6 | 289000 | 2020-01-13 00:00:00 | 2020-01-14 00:00:00 | N/A | N/A | Multifamily | Rapid City | City Center | Commercial most restrictive C1
55864 | 65894 Oak St | 489 |  | 1.08 | 775000 | 2020-01-14 00:00:00 | 2020-01-15 00:00:00 | N/A | N/A | Multifamily | Rapid City | City Center | Medium density residential district
32156 | 563 Main St | 6458 |  |  | 355000 | 2020-01-15 00:00:00 | 2020-01-16 00:00:00 | N/A | N/A | Office | Rapid City | City Center | Central business district
69841 | 58 Main St | 898 |  |  | 730000 | 2020-01-16 00:00:00 | 2020-01-17 00:00:00 | N/A | N/A | Office | Rapid City | City Center | High density residential district
48941 | [NAME] | 651 |  | 10.3 | 1020000 | 2020-01-17 00:00:00 | 2020-01-18 00:00:00 | N/A | N/A | Other | [NAME] | [NAME] | No Code | Trailer Park
89613 | 8174 Elm | 325 |  | 0.14 | 200000 | 2020-01-18 00:00:00 | 2020-01-19 00:00:00 | N/A | N/A | Other | Rapid City | City Center | Central business district | Church
45621 | 4585 Elm | 468 |  | 18.07 | 864360 | 2020-01-19 00:00:00 | 2020-01-20 00:00:00 | N/A | N/A | Other | Rapid City | [NAME] | Open Space | Restaurant
84896 | 8475 Main | 8469 |  | 0.9 | 1550000 | 2020-01-20 00:00:00 | 2020-01-21 00:00:00 | N/A | N/A | Retail | Rapid City | City Center | General commercial district | Automotive Center
65484 | 213 Main | 654 |  | 1.79 | 1700000 | 2020-01-21 00:00:00 | 2020-01-22 00:00:00 | N/A | N/A | Retail | Rapid City | SE Rapid | No Code | Fast Food Restaurant
15684 | 658 Oak St | 7050 |  | 0.99 | 1420000 | 2020-01-22 00:00:00 | 2020-01-23 00:00:00 | N/A | N/A | Retail | [NAME] | [NAME] | Commercial most restrictive  C1 | Dollar General
Spreadsheet: harry_arora__12151__Vidigo Financial projections March 1
Sheet: Income  Quarters (3 Yrs)

Vidigo Corporation
SUMMARY - PROJECTED REVENUE AND EXPENSES
REVENUE | Q1 | Q2 | Q3 | Q4 | FY1 | Q1 | Q2 | Q3 | Q4 | FY2 | Q1 | Q2 | Q3 | Q4 | FY3
Compression | 40000 | 160000 | 240000 | 460000 |  | 475000 | 490000 | 505000 | 520000 |  | 580000 | 640000 | 700000 | 760000
Streaming Services | 27000 | 105745 | 270000 | 765000 |  | 945000 | 1147500 | 1350000 | 1620000 |  | 2025000 | 2700000 | 3375000 | 4050000
iCommercial
Production Services | 40000 | 80000 | 160000 | 275000 |  | 285000 | 290000 | 295000 | 300000 |  | 310000 | 325000 | 340000 | 350000
Revenue
Cost-of-Sales Streaming)
Streaming Services Division @ 50%
iCommercial
Total Production
Total Revenue
EXPENSES
ADMINISTRATION
Toronto (see [NAME])
Total Administration Expenses
MARKETING
E-commerce/Streaming Marketing (see [NAME])
Total Marketing Division Expenses
SALES
E-commerce (see [NAME])
Total Sales Division Expenses
TECHNOLOGY
Compression
Development
Systems Administration
 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Total Technology Expenses
Total Expenses
Net Income (loss)
NOTES:
Technology incorporates Production, Development, Quality Assurance, internal Network Operations, and Support.
Spreadsheet: 1411d2be-aedf-40e4-84f1-c3c0d1e652d6
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-07-19 14:00:52.320000
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.467 | 101.342 | 101.217 | 100.842
4.625 | 100.596 | 100.471 | 100.346 | 99.971 |  | Note: | Refer To Price [NAME]
4.5 | 100.119 | 99.994 | 99.869 | 99.494 |  |  | For all Price Adjs
4.375 | 99.496 | 99.371 | 99.246
 |  |  |  |  |  | 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.125 | 101.779 | 101.654 | 101.529 | 101.154
4 | 101.459 | 101.334 | 101.209 | 100.834
3.875 | 101.058 | 100.933 | 100.808 | 100.433
3.75 | 100.46 | 100.335 | 100.21 | 99.835
3.625 | 99.472 | 99.347 | 99.222
 |  |  |  |  |  | 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-08-02 14:00:52.320000
30 DAY | 2011-08-17 14:00:52.320000
45 DAY | 2011-09-01 14:00:52.320000
60 DAY | 2011-09-16 14:00:52.320000
90 DAY | 2011-10-16 14:00:52.320000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.