tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 3498e49a-4be5-445a-8c90-7ade8d14248e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
Beispielprofil  Fußballfan
[NAME] telefoniert während seines Kurztripps zur EM nach [NAME] bzw. in die Ukraine zwei [NAME] für fünf Minuten ins deutsche Festnetz. Außerdem versendet er fünf [NAME] und [NAME] Datevolumen von 500 Kb für die [NAME] des mobilen Internet. [NAME] nutzt dafür die [NAME].
Stand: 29.05.2012
Quelle: www.verivox.de
[NAME] ohne Gewähr.
T-Mobile  "[NAME]" | Land
 | [NAME] | Ukraine
[NAME] (2 x 5 Min.) | 4.4 | 29.9
5 SMS | 0.65 | 1.95
Internetnutzung (500 Kb) | 1.7 | 7.9
[NAME] | 6.750000000000001 | 39.75
D2/Vodafone "World" | Land
 | [NAME] | Ukraine
[NAME] (2 x 5 Min.) | 4.1 | 23
5 SMS | 0.65 | 2.05
Internetnutzung (500 Kb) | 1.7 | 7.9
[NAME] | 6.45 | 32.95
O2 "Reise Option" | Land
 | [NAME] | Ukraine
[NAME] (2 x 5 Min.) | 4.5 | 29.9
5 SMS | 0.65 | 2.95
Internetnutzung (500 Kb) | 0.75 | 6
[NAME] | 5.9 | 38.85
E-Plus "Base Reisevorteil Plus" | Land
 | [NAME] | Ukraine
[NAME] (2 x 5 Min.) | 2.88 | 19.9
5 SMS | 0.45 | 2.45
Internetnutzung (500 Kb) | 0.2392578125 | 1.2158203125
[NAME] | 3.5692578125 | 23.5658203125
[NAME] | Land
 | [NAME] | Ukraine
[NAME] (2 x 5 Min.) | 4.1 | 22.9
5 SMS | 0.65 | 1.95
Internetnutzung (500 Kb) | 0.2392578125 | 2.1923828125
[NAME] | 4.9892578125 | 27.0423828125
[NAME] | Land
 | [NAME] | Ukraine
[NAME] (2 x 5 Min.) | 4.1 | 29.9
5 SMS | 0.65 | 1.95
Internetnutzung (500 Kb) | 1.7 | 17.88
[NAME] | 6.45 | 49.73
[NAME] | Land
 | [NAME] | Ukraine
[NAME] (2 x 5 Min.) | 4.1 | 22.9
5 SMS | 0.65 | 1.95
Internetnutzung (500 Kb) | 0.75 | 6
[NAME] | 5.5 | 30.85
Edeka Mobil | Land
 | [NAME] | Ukraine
[NAME] (2 x 5 Min.) | 4.1 | 30.7
5 SMS | 0.65 | 2.05
Internetnutzung (500 Kb) | nicht möglich
[NAME] | 4.75 | 32.75
Alle genannten [NAME] beziehen sich auf das zugrunde gelegte Profil, eine abweichende [NAME] führt zu abweichenden Kosten.  Taktung und eventuelle Freischaltungsgebühren wurden nicht berücksichtigt.
Spreadsheet: 88095d1288020676-format-not-staying-same-test-for-pricing
Sheet: Order of works

 | CLIENT
 | JOB
 |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Spreadsheet: 733437d1621581520-extract-data-from-sheets-and-copy-them-in-one-sheet-example1
Sheet: 551220

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sal1 | Average
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1382 | 1095.973333333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1383 | 1093.171666666667
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1384 | 1092.5675
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1385 | 1091.0675
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1386 | 1090.070833333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1387 | 1088.733636363636
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1388 | 1087.621666666667
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1389 | 1086.9875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1390 | 1086.191666666667
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1391 | 1085.263333333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1392 | 1084.068333333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1393 | 1083.481666666667
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1394 | 1082.171111111111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1395 | 1081.133
Spreadsheet: 080bec70-b34c-42b7-9ada-aa07906c7155
Sheet: Verlage

[NAME] | Staat | PLZ | Ort | Straße | [NAME] | [NAME].: | Fax.: | mail | Internet
Adler - Musikverlag | A | A 8990 | Bad Aussee |  |  | 0043(0)3622 54-588 | 0043(0)3622 55-266 | [EMAIL] | www.adler-musikverlag.com
[NAME] | D | 86159 | Augsburg | [NAME] |  | 0049(0)821-596276 | 0049 (0)[PHONE] | [EMAIL]
BLV Verlagsgesellschaft mbH | D | 80797 | München 40 | Lothstraße 29 | 40 03 20 | 0049 (0)89-12 7 05-0 | 0049 (0)89-12 7 05-545 | [EMAIL] | www.blv.de
[NAME] über NOTENBUCH.de | D | 94469 | Deggendorf | [NAME] |  | 0049 (0) 991-5404 | 0049 (0)991-33 7 29
di-arezzo | F | 75002 | Paris | [NAME] 160 |  | 0033 (0) 1 44 76 80 24 |  |  | www.di-arezzo.de
[NAME] | A | A   1010 | [NAME] | Dorotheagasse 10 |  | 0043 (0)1-515 03.0 | 0043 (0)1-515 93.51 | [EMAIL]
GEYER  Martin | D | 90478 | Nürnberg | Dutzendeichstr. 1 |  |  |  | [EMAIL]
HAYDEN Johann Eigenverlag | A | 2753 | Markt Piesting | Marktplatz 1 |  | 0043 (0)2633-42241 | 0043 (0)2633-42241 -22
[NAME] | D | 86633 | Neuburg | [NAME]. 1 |  | 0049 (0) 8431-45845
HUBERTUS - Produktion(Frau Stief) | D | 68526 | [NAME] | Mithrasweg 7 |  | 0049 (0)62 03-1 47 27
[NAME] | A | 3341 | Ybbsitz | [NAME] 6 |  | 0043(0)7443-86390 |  | [EMAIL] | www.jagdmusik.com
KLIMENT  Musikverlag | A | 1090 | [NAME] | Kolingasse 15 |  | 0043 (0)1-317 51 47 | 0043 (0)1-310b 08 27 | [EMAIL] | www.kliment.at
k.o.m. bühnen- und musikverlag | D | 80687 | München 40 | [NAME]. 21 |  | 0049(0)89-584194 |  | [EMAIL]
M&L - Verlag | D | 8851 | Genderkingen | [NAME] 19
[NAME] | CH | 9323 | Steinach | Rorschacherstr. 3 |  | 00 (0)71-4467152 |  | [EMAIL] | www.jagdhornblaeser.ch
Österr.[NAME]-und Fischerei-Verl. | A | 1080 | [NAME] | Wickenburggasse 3 |  | 0043 (0)1405 16 36 | 0043 (0)1405 36 36 | [EMAIL] | www.jagd.at
[NAME] | D | 68526 | [NAME] |  | 1136 | 0049 (0)89 903-9548 |  | [EMAIL]
[NAME] | A | 8101 | Gratkorn | [NAME] 3 |  | 0043 (0)3124 23 0 46 | 0043 (0)3124 23 0 46 | [EMAIL] | www.jagdmusik.online.cx
[NAME] | D | 88428 | Rot a.d.Rot |  |  | 0049 (0)8395-94260 |  | [EMAIL] | www.rundel.de
[NAME] | CH | 7707 | [NAME]
Schweizerischer Jagdverband | CH |  | siehe [NAME] |  |  |  |  |  | www.jagdhornblaeser.ch
Solothurnischer [NAME] | CH |  | siehe Schweizerischer Jagdverband
TATZER Musikverlag | A | 2263 | [NAME] | Florianistraße 13 |  | 0043 (0)2538-85 4 64 | 0043 (0)2538-85 5 95
[NAME] | A | 8342 | Gnas | Hauptplatz 27 |  | 0043 (0)3151-84 87 | 0043 (0)3151-85 87-4 | [EMAIL]
Dr. [NAME] | D | 85461 | Bockhorn | Kreuzstraße18
WWV (Wiener [NAME].) | A | 1080 | [NAME] |  | 134 |  | 0043 (0)2239-3705
WINDHAG siehe [NAME]
[NAME] | D | 60489 | Frankfurt/Main | Strubbergstraße 80 |  | 0049 (0)69 97 82 866 | 0049 (0)69 97 82 8689 |  | www.zimmermann-frankfurt.de
Spreadsheet: 826670d1682148231-hardcode-text-to-spilled-array-spilled-range-aligw
Sheet: autospill

 | id | date | type | qty | unit | unit price |  |  | total price
 | Al-100 | 2023-04-17 00:00:00 | quote | 0.03 | [NAME] | 1165
 | Al-100 | 2023-04-17 00:00:00 | quote | 1 | [NAME] | 922 |  |  |  |  | 922
 | [NAME] | 2023-04-17 00:00:00 | quote | 0.03 | [NAME] | 1100 |  |  |  |  | 33
 | [NAME] | 2023-04-17 00:00:00 | quote | 0.5 | [NAME] | 1100 |  |  |  |  | 550
 | [NAME] | 2023-04-17 00:00:00 | quote | 1 | [NAME] | 865 |  |  |  |  | 865
 | Al-102 | 2023-04-17 00:00:00 | quote | 0.03 | [NAME] | 1000 |  |  |  |  | 30
 | Al-102 | 2023-04-17 00:00:00 | quote | 1 | [NAME] | 830 |  |  |  |  | 830
 | Al-103 | 2023-04-17 00:00:00 | quote | 0.03 | [NAME] | 940 |  |  |  |  | 28.2
 | Al-103 | 2023-04-17 00:00:00 | quote | 1 | [NAME] | 780 |  |  |  |  | 780
 | Al-104 | 2023-04-17 00:00:00 | quote | 1 | [NAME] | 46 |  |  |  |  | 46
 | Al-105 | 2023-04-17 00:00:00 | quote | 25 | [NAME] | 33 |  |  |  |  | 825
 | [NAME] | 2023-04-17 00:00:00 | quote | 25 | [NAME] | 29 |  |  |  |  | 725
 |  |  |  |  |  | 0
Spreadsheet: 889492d1740330017-excel-formula-to-calculate-balance-stock-and-opening-stock-for-an-item-in-a-filtered-cell-stock-register-final-
Sheet: STOCK REGISTER

STOCK REGISTER
Date of Procurement | Item Name | [NAME] | Opening Stock | Quantity Received | Quantity Issued/ Damaged | Balance Stock | Remarks
1999-05-10 00:00:00 | Steel Almirah | ABC | 0 | 5 | 0 | 5 |  | <<<< MUST be Opening Stock of 0
2020-07-15 00:00:00 | Steel Almirah | ABC | 5 | 1 | 0 | 6
2020-07-16 00:00:00 | [NAME] | BCD | 0 | 6 | 0 | 6
2021-10-20 00:00:00 | [NAME] | BCD | 6 | 1 | 0 | 7
2022-09-18 00:00:00 | Steel Almirah | ABC | 6 | 0 | 2 | 4
2023-05-17 00:00:00 | Table | [NAME] | 0 | 5 | 0 | 5
2023-05-17 00:00:00 | Table | [NAME] | 5 | 25 | 0 | 30
2023-08-14 00:00:00 | Chair | ABC | 0 | 50 | 0 | 50
2023-08-15 00:00:00 | Chair | ABC | 50 | 30 | 27 | 53
2023-11-25 00:00:00 | Bench | BCD | 0 | 30 | 0 | 30
2023-11-25 00:00:00 | Bench | BCD | 30 | 100 | 84 | 46
2024-01-01 00:00:00 | [NAME] | CAB | 7 | 5 | 0 | 12
2024-05-10 00:00:00 | Oven | [NAME] | 0 | 3 | 0 | 3
2024-12-12 00:00:00 | Steel Almirah | ABC | 4 | 0 | 5 | -1
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  |  | 261 | 118 | 0
Spreadsheet: 328142d1403795015-help-with-vlook-up-to-multiple-tabs-328137d1403793760-help-with-vlook-up-to-multiple-tabs-excel-help
Sheet: 213025

 |  | Current | Month |  |  |  |  |  | Year | to Date
 |  |  | Variance |  |  |  |  |  |  | Variance
 | Actual | Budget | Fav/(Unfav) | % |  |  |  | Actual | Budget | Fav/(Unfav) | %
 |  |  |  |  |  | REVENUE
 |  |  |  |  |  | Gross Patient Service Revenue:
%,R,FACCOUNT,THYP_ACCT_CURRENT08,XDYYNYN00,NINPROUTINE | 0 | 0 | 0 | 0 |  | Inpatient Routine Revenue |  | 0 | 0 | 0 | 0
%,V4210 | 7581.14 | 0 | 7581 | 0 | 4210 | [NAME] |  | 28241.84 | 0 | 28242 | 0
%,R,FACCOUNT,THYP_ACCT_CURRENT08,XDYYNYN00,NINPANCILLARY | 7581.14 | 0 | 7581 | 0 |  | Inpatient Ancillary Revenue |  | 28241.84 | 0 | 28242 | 0
%,V4310 | 16474.44 | 20978 | -4504 | -0.2147011154542854 | 4310 | OUTPATIENT ANCILLARY - PROFESS |  | 228373.57 | 219382 | 8992 | 0.04098786591425003
%,R,FACCOUNT,THYP_ACCT_CURRENT08,XDYYNYN00,NOUTPAT | 16474.44 | 20978 | -4504 | -0.2147011154542854 |  | Outpatient Gross Revenue |  | 228373.57 | 219382 | 8992 | 0.04098786591425003
%,V4427 | 0 | 0 | 0 | 0 | 4427 | CAP SETTLEMENTS |  | 85.15 | 0 | 85 | 0
%,R,FACCOUNT,THYP_ACCT_CURRENT08,XDYYNYN00,NCAPITATREV | 0 | 0 | 0 | 0 |  | Capitation Revenue |  | 85.15 | 0 | 85 | 0
%,R,FACCOUNT,THYP_ACCT_CURRENT08,NGROSS_PATNT_REV | 24055.58 | 20978 | 3078 | 0.1467251406235103 |  | Gross Patient Service Revenue |  | 256700.56 | 219382 | 37319 | 0.1701096717141789
Spreadsheet: 478827d1473088259-excel-formula-to-convert-data-range-to-columns-convert-data-to-columns
Sheet: Sheet1

 |  |  |  |  |  | Work Centre# |  |  | Work Centre# |  |  | Work Centre# |  |  | Work Centre#
 |  |  |  |  |  | 1 |  |  | 2 |  |  | 3 |  |  | 4
 |  |  |  |  |  | Employee | Bonus |  | Employee | Bonus |  | Employee | Bonus |  | Employee | Bonus
 | Table of Contents |  |  |  |  | [NAME] | 258 |  | [NAME] | 255 |  | [NAME] | 287 |  | [NAME] | 259
 |  |  |  |  |  | [NAME] | 253 |  | [NAME] | 122 |  | [NAME] | 277 |  | [NAME] | 244
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 261
Employee | Work Centre# | Bonus |  |  |  |  |  |  |  |  |  | [NAME] | 166
[NAME] | 1 | 253
[NAME] | 2 | 255
[NAME] | 3 | 277
[NAME] | 4 | 244
Duanne Busch | 6 | 256 |  |  |  |  | need Excel formula/s to create output in coloumns as above please
[NAME] | 6 | 277
Ingrid Jones | 5 | 288 |  |  |  |  | [NAME] does not work as the dominant factor is the work centre # followed by employee name with bonus in decending order.
[NAME] | 5 | 211
[NAME] | 7 | 166 |  |  |  |  | any help is welcome, thank you!
[NAME] | 3 | 287
[NAME] | 3 | 261
[NAME] | 4 | 259
[NAME] | 1 | 258
[NAME] | 6
[NAME]
Ingrid Jones | 7 | 299
[NAME]
[NAME] | 2 | 122
[NAME] | 3 | 166
Spreadsheet: 794014d1661853014-modelling-working-capital-monthly-model-working-capital
Sheet: Sheet 2

 |  | WORKING CAPITAL |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
1 |  | REVENUE
 |  | Total
 |  | Revenue 1 |  | 1000
 |  | Revenue 2 |  | 2000
 |  | Revenue 3 |  | 3000
 |  | Revenue 4 |  | 4000
 |  | Revenue 5 |  | 5000
 |  | % Payment per Period (Revenue 1) |  | 0.6 | 0.25 | 0.1 | 0.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | % Payment per Period (Revenue 2) |  | 0.7 | 0.2 | 0.05 | 0.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | % Payment per Period (Revenue 3) |  | 0.8 | 0.1 | 0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | % Payment per Period (Revenue 4) |  | 0.9 | 0.05 | 0.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | % Payment per Period (Revenue 5) |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 |  | CASH PAYMENTS
 |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 3 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 4 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 5 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 6 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 7 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 8 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 9 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 11 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 12 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 39960d1238187902-sumproduct-help-sumproduct_sample
Sheet: Sheet1

 |  |  |  |  | OFFER | WEEK | 16 | 2009-04-13 00:00:00 | COMM | Comm | ext
Tier | customer | PROD | Style | size | DATE | OFFER | ORDER QTY | Bal of Projected | DATE | $ | X
1 | Customer A | [NAME] | 2L |  |  |  |  | 0
1 | Customer A | [NAME] | 2L |  |  |  |  | 0
1 | Customer A | [NAME] | SLE |  |  |  |  | 0
1 | Customer A | [NAME] | SLE |  |  |  |  | 0
1 | Customer A | [NAME] | VF | 40/44+ |  | 1000 |  | 1000
1 | Customer A | [NAME] | VF |  |  |  |  | 0
1 | Customer A | [NAME] | VF |  |  |  |  | 0
3 | Customer B | [NAME] | 2L |  |  |  |  | 0
3 | Customer B | [NAME] | 2L |  |  |  |  | 0
3 | Customer B | [NAME] | SLE |  |  |  |  | 0
3 | Customer B | [NAME] | SLE | 48 |  | 3500 |  | 3500
3 | Customer B | [NAME] | VF |  |  |  |  | 0
3 | Customer B | [NAME] | VF |  |  |  |  | 0
3 | Customer C | [NAME] | 2L |  |  |  |  | 0
3 | Customer C | [NAME] | 2L |  |  |  |  | 0
3 | Customer C | [NAME] | SLE |  |  |  |  | 0
3 | Customer C | [NAME] | SLE |  |  |  |  | 0
3 | Customer C | [NAME] | VF |  |  |  |  | 0
3 | Customer C | [NAME] | VF |  |  |  |  | 0
2 | Customer D | [NAME] | 2L |  |  |  |  | 0
2 | Customer D | [NAME] | 2L |  |  |  |  | 0
2 | Customer D | [NAME] | SLE |  |  |  |  | 0
2 | Customer D | [NAME] | SLE |  |  |  |  | 0
2 | Customer D | [NAME] | VF |  |  |  |  | 0
2 | Customer D | [NAME] | VF |  |  |  |  | 0
2 | Customer E | [NAME] | 2L |  |  |  |  | 0
2 | Customer E | [NAME] | SLE |  |  |  |  | 0
2 | Customer E | [NAME] | SLE |  |  |  |  | 0
2 | Customer E | [NAME] | VF |  |  |  |  | 0
2 | Customer E | [NAME] | VF |  |  |  |  | 0
2 | Customer E | [NAME] | VF |  |  |  |  | 0
2 | Customer F | [NAME] | 2L |  |  |  |  | 0
2 | Customer F | [NAME] | 2L |  |  |  |  | 0
2 | Customer F | [NAME] | SLE | 42 |  | 25000 |  | 25000
2 | Customer F | [NAME] | SLE |  |  |  |  | 0
2 | Customer F | [NAME] | VF |  |  |  |  | 0
2 | Customer F | [NAME] | VF |  |  |  |  | 0
1 | Customer G | [NAME] | 2L |  |  |  |  | 0
1 | Customer G | [NAME] | 2L |  |  |  |  | 0
1 | Customer G | [NAME] | SLE |  |  |  |  | 0
1 | Customer G | [NAME] | SLE |  |  |  |  | 0
1 | Customer G | [NAME] | VF |  |  |  |  | 0
1 | Customer G | [NAME] | VF |  |  |  |  | 0
1 | Customer H | [NAME] | 2L |  |  |  |  | 0
1 | Customer H | [NAME] | 2L |  |  |  |  | 0
1 | Customer H | [NAME] | SLE |  |  |  |  | 0
1 | Customer H | [NAME] | SLE |  |  |  |  | 0
1 | Customer H | [NAME] | VF |  |  |  |  | 0
1 | Customer H | [NAME] | VF |  |  |  |  | 0
1 | Customer I | [NAME] | 2L |  |  |  |  | 0
1 | Customer I | [NAME] | 2L |  |  |  |  | 0
1 | Customer I | [NAME] | SLE |  |  |  |  | 0
1 | Customer I | [NAME] | SLE | 35/36 |  | 15000 |  | 15000
1 | Customer I | [NAME] | VF |  |  |  |  | 0
1 | Customer I | [NAME] | VF |  |  |  |  | 0
3 | Customer J | [NAME] | 2L |  |  |  |  | 0
3 | Customer J | [NAME] | 2L |  |  |  |  | 0
3 | Customer J | [NAME] | SLE |  |  |  |  | 0
3 | Customer J | [NAME] | SLE |  |  |  |  | 0
3 | Customer J | [NAME] | VF | 48/50 |  | 50000 |  | 50000
3 | Customer J | [NAME] | VF |  |  |  |  | 0
Spreadsheet: 708234d1607684825-non-consecutive-count-sample-workbook
Sheet: 30th NOV

SARS RD | ADP | MARKET ROAD | OPM | SHELL ESTATE | PIPE LINE | AIRPORT | IGWURITA | IGWURUTA ROAD | ELIMGBU | MBAK | IDORO ROAD | AKA ROAD | IBB AVENUE | INDONGESIT NKANGA | SIR UDO UDOMA
NS | NS | NS | NS | NS | NS | 0.5 | 0 | BF | BF | NS | NS | SS | SS | SS | SS
NS | NS | NS | NS | NS | NS | 0.4 | 0 | BF | BF | NS | NS | SS | SS | SS | SS
NS | NS | NS | NS | NS | NS | 0.4 | 0 | BF | BF | NS | NS | SS | SS | SS | SS
NS | NS | NS | NS | NS | NS | 0.4 | 0 | BF | BF | NS | NS | SS | SS | SS | SS
NS | NS | NS | NS | NS | NS | 0.5 | 0 | BF | BF | NS | NS | SS | SS | SS | SS
NS | NS | NS | NS | NS | NS | 0.5 | 0 | BF | BF | NS | NS | SS | SS | SS | SS
LS | 4.2 | LS | LS | 0.5 | 2.6 | 0.7 | 0 | BF | BF | NS | NS | LS | LS | LS | 2.9
NS | NS | NS | NS | NS | NS | 0.7 | 0 | BF | BF | NS | NS | LS | 3.7 | 0.3 | 2.6
SS | SS | SS | LS | 0.5 | LS | 1.7 | 0 | BF | BF | NS | NS | LS | 3.6 | 0.3 | 2.6
SS | SS | SS | LS | LS | 2.6 | 1.5 | 0 | BF | BF | NS | NS | LS | 3.5 | 0.3 | LS
SS | SS | SS | LS | LS | 2.6 | NS | 0 | BF | BF | NS | NS | 5 | LS | 0.2 | LS
SS | SS | SS | LS | LS | 2 | 0.6 | 0 | BF | BF | NS | NS | LS | LS | 0.2 | LS
SS | SS | SS | LS | LS | 1.9 | 0.6 | 0 | BF | BF | NS | NS | NS | NS | NS | NS
SS | SS | SS | LS | LS | 1.9 | 0.7 | 0 | BF | BF | NS | NS | NS | NS | NS | NS
SS | SS | SS | LS | LS | 2 | 0.7 | 0 | BF | BF | NS | NS | NS | NS | NS | NS
NS | NS | NS | NS | NS | NS | NS | 0 | BF | BF | NS | NS | NS | NS | NS | NS
NS | NS | NS | NS | NS | NS | NS | 0 | BF | BF | NS | NS | NS | NS | NS | NS
SS | SS | SS | SS | SS | SS | NS | 0 | BF | BF | NS | NS | NS | NS | NS | NS
LS | LS | 4.9 | 4.6 | 0.7 | LS | 0.8 | 0 | NS | NS | NS | NS | NS | NS | NS | NS
LS | LS | 4.8 | 4.1 | 0.7 | 3.4 | 0.8 | 0 | NS | NS | NS | NS | NS | NS | NS | NS
4.5 | LS | LS | 3.6 | 0.7 | 3.2 | 0.7 | 0 | NS | NS | NS | NS | LS | LS | 0.3 | LS
3.6 | LS | LS | 3.3 | 0.6 | 3 | 0.7 | 0 | NS | NS | NS | NS | LS | LS | 0.3 | LS
3.3 | LS | LS | 2.9 | 0.6 | 2.6 | 0.6 | 0 | SS | SS | NS | NS | SS | SS | SS | SS
SS | SS | SS | 2.6 | 0.5 | 2.3 | 0.5 | 0 | SS | SS | NS | NS | SS | SS | SS | SS
Spreadsheet: 218411d1362447575-look-up-specific-text-and-return-a-list-of-the-satisfied-text-example
Sheet: Sheet3

CF | CS | SS | PO | D |  | CF | CS | SS | PO | D
 |  |  |  |  |  | Name 1 | Name 3 | Name 6 | Name 8 | Name 26
 |  |  |  |  |  | Name 13 | Name 20 | Name 24 | Name 44 | Name 37
 |  |  |  |  |  | Name 17 | Name 33 | Name 63 | Name 77 | Name 56
 |  |  |  |  |  | Name 29 | Name 50 | Name 85 | Name 137 | Name 73
 |  |  |  |  |  | Name 40 | Name 61 | Name 107 | Name 164 | Name 87
 |  |  |  |  |  | Name 54 | Name 70 | Name 134 | Name 178 | Name 100
 |  |  |  |  |  | Name 66 | Name 95 | Name 152 | Name 190 | Name 117
 |  |  |  |  |  | Name 75 | Name 111 | Name 182 |  | Name 140
 |  |  |  |  |  | Name 89 | Name 122 | Name 200 |  | Name 145
 |  |  |  |  |  | Name 103 | Name 127 |  |  | Name 166
 |  |  |  |  |  | Name 114 | Name 142 |  |  | Name 176
 |  |  |  |  |  | Name 131 | Name 159 |  |  | Name 186
 |  |  |  |  |  | Name 147 | Name 174 |  |  | Name 196
 |  |  |  |  |  | Name 155 | Name 198
 |  |  |  |  |  | Name 162
 |  |  |  |  |  | Name 169
 |  |  |  |  |  | Name 180
 |  |  |  |  |  | Name 194
Spreadsheet: 758553d1638945211-lookup-multiple-rows-and-match-excel-forum-help-8-12-21
Sheet: Sheet4

Receipt by Items |  |  |  | Receipt Total
Receipt ID | Product | Reference |  |  | 1 only | 2 only | Mix
39091970 | [NAME] | 2 |  | 39091970
39091970 | Avocado 1/4 | 1 |  | 39092481
39091970 | Beetroot 35g | 2 |  | 39092506
39092481 | [NAME] | 1 |  | 39092516
39092481 | Chicken & Bacon | 1 |  | 39092545
39092481 | [NAME] | 1 |  | 39092550
39092506 | American Moby | 2 |  | 39092661
39092506 | Food Panda 20% (Tax: 7%) | 2 |  | 39093466
39092506 | Food Panda 20% (Tax: 0%) | 2 |  | 39093664
39092516 | Cappuccino Large | 2 |  | 39093747
39092516 | Ham & Cheese Toastie | 2 |  | 39094533
39092545 | American Breakfast Toastie | 2 |  | 39095302
39092550 | Hot Tea | 2 |  | 39095304
39092550 | REOPENING PROMO 50% (Tax: 7%) | 2 |  | 39095419
39092550 | REOPENING PROMO 50% (Tax: 0%) | 2 |  | 39095424
39092661 | Ham & Cheese Toastie | 2 |  | 39095528
39092661 | Chicken & Bacon | 2 |  | 39095555
39092661 | Falafel Salad | 2
39093466 | [NAME] | 2
39093664 | Coke Zero | 2
39093664 | [NAME] | 2
39093664 | [NAME] | 2
39093664 | [NAME] | 2
39093747 | [NAME] | 2
39094533 | [NAME] | 2
39094533 | Falafel Salad | 2
39094533 | [NAME] | 2
39094533 | [NAME] | 2
39094533 | Premium Member 13% (Tax: 7%) | 2
39094533 | Premium Member 13% (Tax: 0%) | 2
39095302 | The Black Pearl | 2
39095302 | Gloria Food 20% (Tax: 7%) | 2
39095302 | Gloria Food 20% (Tax: 0%) | 2
39095304 | Water | 2
39095304 | Water | 2
39095419 | [NAME] | 2
39095419 | Gloria Food 20% (Tax: 7%) | 2
39095419 | Gloria Food 20% (Tax: 0%) | 2
39095424 | [NAME] | 2
39095528 | Ham & Cheese Toastie | 2
39095528 | [NAME] | 2
39095528 | Passion Fruit Soda | 2
39095528 | Singha Beer | 2
39095555 | The Black Pearl | 2
39095555 | Gloria Food 20% (Tax: 7%) | 2
39095555 | Gloria Food 20% (Tax: 0%) | 2
Spreadsheet: 857313d1706326983-creating-an-invoice-from-a-list-of-time-entries-where-one-customer-has-multiple-entries-invoice-template-test
Sheet: Manually Created Invoice

ABC Corporation
January 2024 Invoice
Date | Narrative | Hours
2024-01-02 00:00:00 | Phone call | 0.75
2024-01-03 00:00:00 | Emails | 6.75
2024-01-04 00:00:00 | Research | 1.25
2024-01-05 00:00:00 | Phone call | 4.75
2024-01-08 00:00:00 | Meeting | 4
2024-01-09 00:00:00 | Draft Opinion | 1.25
Total
Spreadsheet: 845867d1697193546-filter-formula-help-help2forum
Sheet: Sheet1

[NAME] by Profile & Channel
REF FIELD FOM RAWDATA | COL
Agency |  | applies to all tables
[NAME] |  | applies to all tables
[NAME]
REF FIELD FOM RAWDATA | COL
Type_of_product_bought |  |  | Product 2 | Product 3 | Product 4 | Product 5 | Product 6
[NAME] (don't touch)
 | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Errors | TOTAL | IDs with issues
Company 3 | 2 | 0 | 0 | 1 | 0 | 1 | 4
Spreadsheet: 3a6cc43e-f496-4647-8b28-a616b78e4588
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-05-20 09:33:07.210000
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.644 | 102.519 | 102.394 | 102.019
4.5 | 102.357 | 102.232 | 102.107 | 101.732 |  | Note: | Refer To Price [NAME]
4.375 | 101.79 | 101.665 | 101.54 | 101.165 |  |  | For all Price Adjs
4.25 | 101.182 | 101.057 | 100.932 | 100.307
4.125 | 100.328 | 100.203 | 100.078 | 99.453
4 | 99.315 | 99.19 | 99.065 | 98.44
3.875 | 98.262 | 98.137 | 98.012 | 97.387
3.75 | 97.387 | 97.262 | 97.137 | 96.512
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.875 | 102.75 | 102.625 | 102.25
3.75 | 102.661 | 102.536 | 102.411 | 102.036
3.625 | 102.262 | 102.137 | 102.012 | 101.637
3.5 | 101.705 | 101.58 | 101.455 | 101.08
3.375 | 100.979 | 100.854 | 100.729 | 100.104
3.25 | 100.227 | 100.102 | 99.977 | 99.352
3.125 | 99.695 | 99.57 | 99.445 | 98.82 |  | 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-03 09:33:07.210000
30 DAY | 2014-06-18 09:33:07.210000
45 DAY | 2014-07-03 09:33:07.210000
60 DAY | 2014-07-18 09:33:07.210000
90 DAY | 2014-08-17 09:33:07.210000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.