tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 65681d1266362401-downloaded-data-wants-to-format-itself-format-sample
Sheet: sample 1

this is my result when simply using Copy/Paste
COGIS - Facility Query Results
You requested facilities by: | 'WELL'
Operator name: | energen
Maximum records are limited to: | 10
For detail information: | Click on facility type.
Search Results - 10 record(s) returned.
Facility Type | Facility ID/ | Facility Name/ | Operator Name/ | Status | Field Name/ | Location | Related Facilities
 | API | Number | Number |  | Number
WELL | 05-007-06205 | DUNGAN 32-5 | ENERGEN RESOURCES CORPORATION | SI | IGNACIO BLANCO | ARCHULETA  007
 |  | 2010-05-02 00:00:00 | 27480 |  | 38300 | NENW  5  32N 5W  N
WELL | 05-007-06223 | DUNGAN 32-5 | ENERGEN RESOURCES CORPORATION | SI | IGNACIO BLANCO | ARCHULETA  007
 |  | 2010-05-03 00:00:00 | 27480 |  | 38300 | NENW  5  32N 5W  6
WELL | 05-007-06222 | DUNGAN 32-5 | ENERGEN RESOURCES CORPORATION | PR | IGNACIO BLANCO | ARCHULETA  007
 |  | 2010-05-04 00:00:00 | 27480 |  | 38300 | SESW  5  32N 5W  N
WELL | 05-007-06279 | CANDELARIA 32-5 | ENERGEN RESOURCES CORPORATION | WO | IGNACIO BLANCO | ARCHULETA  007
 |  | 2010-08-03 00:00:00 | 27480 |  | 38300 | SESW  5  32N 5W  N
WELL | 05-007-06196 | DUNGAN 32-5 | ENERGEN RESOURCES CORPORATION | PR | IGNACIO BLANCO | ARCHULETA  007
 |  | 2010-05-01 00:00:00 | 27480 |  | 38300 | SESW  5  32N 5W  N
WELL | 05-007-06204 | QUINTANA | ENERGEN RESOURCES CORPORATION | PR | IGNACIO BLANCO | ARCHULETA  007
 |  | 32-5 #6-2 | 27480 |  | 38300 | NWSE  6  32N 5W  N
WELL | 05-007-06243 | QUINTANA 32-5 | ENERGEN RESOURCES CORPORATION | PR | IGNACIO BLANCO | ARCHULETA  007
 |  | 2010-06-04 00:00:00 | 27480 |  | 38300 | SWSW  6  32N 5W  N
WELL | 05-007-06186 | QUINTANA 32-5 | ENERGEN RESOURCES CORPORATION | PR | IGNACIO BLANCO | ARCHULETA  007
 |  | 2010-06-01 00:00:00 | 27480 |  | 38300 | SWSW  6  32N 5W  N
WELL | 05-007-06273 | QUINTANA 32-5 | ENERGEN RESOURCES CORPORATION | XX | IGNACIO BLANCO | ARCHULETA  007
 |  | 2010-07-03 00:00:00 | 27480 |  | 38300 | NESW  7  32N 5W  N
WELL | 05-007-06200 | QUINTANA 32-5 | ENERGEN RESOURCES CORPORATION | PR | IGNACIO BLANCO | ARCHULETA  007
 |  | 2010-07-02 00:00:00 | 27480 |  | 38300 | NWSE  7  32N 5W  N
Spreadsheet: 64286d1265150560-multiple-workbook-vlookup-formula-master
Sheet: KAEMSUTS

LOGIN | SURNAME | FIRST NAME | [NAME] | LAST LOG IN | Results
CVANESSAS | A | A | 14003388 | 2007-11-09-14.35.31.300709
CJORDANJRS | A | A | 14003388 | 2008-09-08-12.53.42.220804
CLLADOXRS | A | A | 14003388 | 2008-05-29-11.04.19.497778
GBWQIB | ABBAS | UME | 16026024 | 2010-02-01-09.40.44.549171
[NAME] | ACHURCH | SUSAN | 15279428 | 2010-02-01-10.17.27.624432
CACHURCHJ | ACHURCH | JEMMA | 15628854 | 2009-09-01-16.52.30.147407
CADAM | ADAM | ROSS | 16141096 | 2010-02-01-10.02.27.633307
GBWCFW | ADAMSON | IAN | 14975160 | 2010-02-01-10.19.25.615032
CADESINA | ADESINA | OLUSEYI | 15340911 | 2010-01-28-20.31.06.650718
GBWPRP | ADITYA | KAUL | 15730432 | 2010-02-01-13.03.14.609191
CAFZAL | AFZAL | RIZWAN | 15340768 | 2010-01-06-10.43.50.847279
CAHMADU | AHMAD | UZMA | 14779666 | 2010-02-01-10.06.09.228429
CAINLEY | AINLEY | STEVE | 15369194 | 2009-03-16-18.27.31.953119
CAITKENST | AITKEN | STEPHEN | 15270730 | 2010-02-01-10.00.50.992928
GBWPWE | AJIT | [NAME] | 15749217 | 2010-02-01-13.29.42.746364
CALI | ALI | JESMIN | 15314962 | 2009-10-15-17.06.15.496226
GBVT5R | ALI | JESMIN | 16326861 | 2010-01-30-11.23.31.036803
CALPHANSOI | ALPHANSO | INNOCENT | 15489210 | 2009-08-31-10.19.35.068330
CALTAMASHS | ALTAMASH | SYED | 15496917 | 2009-08-07-08.45.17.556537
Spreadsheet: 861693d1709563823-count-based-on-multiple-conditions-time-table-weekly
Sheet: Sheet1

 | Time In | 08:30:00 |  |  |  |  |  |  |  |  |  |  | count subjects against each class
 | Time Out | 00:45:00 | 00:45:00 | 00:45:00 | 00:45:00 | 00:45:00 | 00:45:00 | 00:45:00 | 00:45:00 |  |  | Class | Urdu | English | Math | Science | S.St | Drawing | General
 | Duration |  |  |  |  |  |  |  |  |  |  | One
 |  |  |  |  |  |  |  |  |  |  |  | Two
Class | Day | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  |  | Three
One | Monday | Urdu | English | Science | Math |  |  |  |  |  |  | Four
One | Tuesday | Urdu | English | Science | Math |  |  |  |  |  |  | Five
One | Wednesday | Urdu | English | Science | Math |  |  |  |  |  |  | Six
One | Thursday | Urdu | English | Science | Math |  |  |  |  |  |  | Seven
One | Friday | Urdu | S.St. | Science | Math |  |  |  |  |  |  | Eight
One | Saturday | Urdu | S.St. | Science | Math
Two | Monday | Urdu | English | Science | Math
Two | Tuesday | Urdu | English | Science | Math
Two | Wednesday | Urdu | S.St. | Science | Math
Two | Thursday | Urdu | S.St. | Science | Math
Two | Friday | Urdu | English | Science | Math
Two | Saturday | Urdu | S.St. | Science | Math
Spreadsheet: 48896d1248191648-formula-help-performing-triple-vlookup-formula-help
Sheet: Sheet1

Open Orders |  |  |  |  |  | Warehouse#
 | Delivery |  | Order |  |  | 1 | Delivery date
Item# | date | Warehouse# | qty |  |  | item# | 20090720 | 20090721 | 20090722 | 20090723
5100 | 20090720 | 3 | 500 |  |  | 5100 | 0
5100 | 20090721 | 1 | 300 |  |  | 5101
5101 | 20090721 | 3 | 250 |  |  | 5101
5102 | 20090722 | 1 | 125 |  |  | 5102
5103 | 20090720 | 1 | 700 |  |  | 5103
5105 | 20090721 | 1 | 500 |  |  | 5104
5105 | 20090722 | 1 | 300 |  |  | 5105
5105 | 20090720 | 3 | 250 |  |  | 5106
5107 | 20090721 | 3 | 500 |  |  | 5107
5110 | 20090722 | 3 | 300 |  |  | 5108
5110 | 20090720 | 1 | 250 |  |  | 5109
5100 | 20090723 | 1 | 500 |  |  | 5110
 |  | I'd like to populate the "Warehouse#1" table using the information in "Open Orders"
Spreadsheet: 119137d1314215888-excel-2008-almost-solved-vlookup-offset-match-and-countif-student-records-and-database
Sheet: Member & Leader Lists

Membership Name | Title | First Name | Last Name | Membership No
 | Mr | [NAME] | [NAME] | 500
 | Mr | [NAME] | Ajob | 501
 | Miss | Charlotte | Henroit | 502
 | Mr | [NAME] | Richman | 503
 | Mr | [NAME] | Saying | 504
 | Mrs | [NAME] | Silverton | 505
 | Mrs | [NAME] | Witchman | 506
 | Mr | Eamon | Nolan | 507
 | Mr | Geoff | Percival | 508
 | Ms | Gillian | Atkins | 509
 | Mrs | Helen | Goldstein | 510
 | Miss | Jeanette | [NAME] | 511
 | Mrs | Julie | Edwards | 512
 | Miss | [NAME] | [NAME] | 513
 | Miss | [NAME] | Willis | 514
 |  | New | Member | 515
 | Mr | [NAME] | Ithard | 516
 | Mr | [NAME] | [NAME] | 517
 | Mr | [NAME] | Western | 518
 | Ms | Rebecca | National | 519
 | Mr | [NAME] | Constanine | 520
 | Mr | [NAME] | Nutbush | 521
 | Ms | Rose | Royce | 522
 | Mr | [NAME] | Carlton | 523
 | Ms | Tara | Scott | 524
 | Mrs | Thersa | Green | 525
 | Ms | [NAME] | Hanratty | 526
Leader No | Leader [NAME] | First Name | Last Name | Membership No.
No 0891-456 |  | [NAME] | [NAME] | 545
No 0891-457 |  | [NAME] | Richman | 54
No 0891-458 |  | [NAME] | Silverton | 264
No 0891-459 |  | [NAME] | Nutbush | 657
No 0891-460 |  | [NAME] | Carlton | 265
Spreadsheet: 104725d1302202946-checking-values-in-two-columns-example-spreadsheet
Sheet: Sheet1

Student | Year | Subject | Period
[NAME] | 7 | English | 3 |  |  | Year Group | # of Oncalls in English
[NAME] | 8 | French | 1 |  |  | 7 | [NAME] here
[NAME] | 9 | English | 2 |  |  | 8
[NAME] | 7 | Science | 5 |  |  | 9
Sid | 8 | Science | 4 |  |  | 10
Wess | 8 | Maths | 4 |  |  | 11
[NAME] | 7 | PE | 3
[NAME] | 7 | RE | 2
[NAME] | 7 | English | 1
[NAME] | 9 | Maths | 2
Biff | 11 | Music | 3
Wayne | 11 | German | 4
Billy | 10 | Art | 5
Terrence | 7 | Drama | 5
[NAME] | 8 | Humanities | 1
Cells to check against
7
8
9
10
11
English
Maths
Science
German
Art
Drama
Humanities
Spreadsheet: df97c929-c9d6-4bd9-bad6-22e2e70c7a67
Sheet: QTD Recon Q2FY10

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended September 30, 2009
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Lease Obligation (G&A) |  | Loss on Licensed Intellectual Property Commitment (COGS) |  | Loss on Strategic Investments |  | Restructuring and other |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 788 |  | 0 |  | 359 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1147
Cost of revenue | 593 |  | -3 |  | 0 |  | 0 |  | 2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 592
Gross profit | 195 |  | 3 |  | 359 |  | 0 |  | -2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 555
Operating expenses:
Marketing and sales | 187 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -5 |  | 0 |  | 182
General and administrative | 91 |  | 0 |  | 0 |  | -14 |  | 0 |  | 0 |  | 0 |  | -10 |  | 0 |  | 67
Research and development | 316 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -29 |  | 0 |  | 287
Amortization of intangibles | 12 |  | -12 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -6 |  | 0 |  | 0 |  | 0
Total operating expenses | 612 |  | -12 |  | 0 |  | -14 |  | 0 |  | 0 |  | -6 |  | -44 |  | 0 |  | 536
Operating income (loss) | -417 |  | 15 |  | 359 |  | 14 |  | -2 |  | 0 |  | 6 |  | 44 |  | 0 |  | 19
Loss on strategic investments | -8 |  | 0 |  | 0 |  | 0 |  | 0 |  | 8 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income, net | 7 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 7
Income (loss) before provision for (benefit from) income taxes | -418 |  | 15 |  | 359 |  | 14 |  | -2 |  | 8 |  | 6 |  | 44 |  | 0 |  | 26
Provision for (benefit from) income taxes | -27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 |  | 7
Net income (loss) | -391 |  | 15 |  | 359 |  | 14 |  | -2 |  | 8 |  | 6 |  | 44 |  | -34 |  | 19
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Basic and diluted | -1.21 |  |  |  |  |  |  |  |  |  |  |  |  |  | Basic | 0.09 |  |  | 0.06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluted | 0.09 |  |  | 0.06
Number of shares used in computation
Basic and diluted | 324 |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of shares used in computation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 324
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 325
Spreadsheet: 847734d1698601513-using-a-formula-to-copy-cells-from-one-sheet-to-another-both-the-data-and-formatting-agenda-temp
Sheet: FRIDAY

AGENDA - FRIDAY 02/16
 |  | SESSION 1 |  |  |  |  | SESSION 2
START | END | SESSION 1 Speaker | SESSION 1 TYPE | Topic 1 | Location 1 | Moderator 1 | SESSION 2 Speaker | SESSION 2 TYPE | Topic 2 | Location 2 | Moderator 2 | ACTIVITY
15:00:00 | 17:00:00 |  | CHECK_IN/HOSPITALTY |  | Hartford North
17:00:00 | 17:15:00 |  | BREAK |  | State Ballroom South
17:00:00 | 18:45:00 |  | DINNER |  | Crowne Ballroom
18:45:00 | 19:00:00 | SMITH [NAME] MD | WELCOME ADDRESS |  | [NAME]
19:00:00 | 20:00:00 | Jones [NAME] | Single Session- Ethics |  | [NAME]
20:05:00 | 20:25:00 |  | BREAK |  | State Ballroom South
20:30:00 | 21:30:00 | White [NAME] | CONCURRENT SESSION - Medical |  | Hartford North |  | [NAME] | Concurrent Session - Ethics |  | International East & Central
21:35:00 | 22:35:00 | [NAME] | CONCURRENT SESSION - Medical |  | Hartford North |  | [NAME] | Concurrent Session - Ethics |  | [NAME]
22:30:00 | 00:00:00 |  | Networking Event/Hot Buffet |  | Crowne Ballroom
Spreadsheet: 828744d1683721363-nested-xlookup-formula-returns-value-error-copyplantmeasurements2023
Sheet: Planting Plan

Owner | Customer | Variety | Pot Size | Per Pot | Drop Down List | Qty Pots | Weeks to Flower | Weeks of Light | Weeks to pinch | Plant Week | [NAME] | [NAME] | Sell Week | Min Finish Ht | [NAME] Ht | Actual Lighting Week | Acutal Blackout Week | Actual Sell Week
Company1 | Cust1 | Red | 6.5 | 1 |  | 1000 | 8.5 | 1.5 | 3 |  |  |  | 46 | 15 | 17
Company1 | Cust2 | Red | 6.5 | 1 |  | 500 | 8.5 | 1.5 | 3 |  |  |  | 47 | 15 | 17
Company1 | Cust3 | Red | 10 | 3 |  | 1000 | 8.5 | 3 | 3.5 |  |  |  | 48 | 24 | 26
Company1 | Cust1 | Pink | 6.5 | 1 |  | 1000 | 8.5 | 2.5 | 3 |  |  |  | 48 | 15 | 17
Spreadsheet: cooper_richey__4041__EOL_Enpower_deals
Sheet: Sheet2

2001-09-05 00:00:00 | 715
2001-09-06 00:00:00 | 935
2001-09-07 00:00:00 | 709
2001-09-18 00:00:00 | 693
2001-09-19 00:00:00 | 602
2001-09-20 00:00:00 | 589
2001-09-25 00:00:00 | 712
2001-09-26 00:00:00 | 613
2001-09-27 00:00:00 | 799
2001-09-28 00:00:00 | 724
2001-10-03 00:00:00 | 791
2001-10-04 00:00:00 | 634 | 536
2001-10-05 00:00:00 | 493 | 521 | 28
2001-10-08 00:00:00 | 273 | 343
2001-10-09 00:00:00 | 487 | 490 | 3
2001-10-12 00:00:00 | 368 | 313 | -55
2001-10-15 00:00:00 | 388 | 331 | -57
2001-10-16 00:00:00 | 670 | 572 | -98
2001-10-17 00:00:00 | 597 | 588 | -9
2001-10-18 00:00:00 | 527 | 633 | 106
2001-10-19 00:00:00 | 584 | 613 | 29
2001-10-22 00:00:00 | 833 | 666 | -167
2001-10-24 00:00:00 | 663 | 460 | -203
2001-10-25 00:00:00 | 669 | 830 | 161
2001-10-26 00:00:00 | 554 | 569 | 15
2001-10-30 00:00:00 | 491 | 517 | 26
2001-10-31 00:00:00 | 712 | 725 | 13
2001-11-01 00:00:00 | 696 | 599 | -97
2001-11-02 00:00:00 |  |  |  | 852
2001-11-05 00:00:00 | 547 | 550 | 3
2001-11-06 00:00:00 | 695 | 593 | -102
2001-11-12 00:00:00 | 414 | 382 | -32
2001-11-15 00:00:00 | 420 | 405 | -15
2001-11-16 00:00:00 | 376 | 359 | -17
2001-11-17 00:00:00 | 267 | 270 | 3
Spreadsheet: 848903d1699513608-formulation-to-get-summary-sample-h
Sheet: Sheet1

 | Weight |  |  |  |  |  | Summary |  |  |  |  | Price |  |  |  |  |  | Quantity
 | a | b | c | d | e | f | D | E | F | G |  |  | D | E | F | G |  | D | E | F | G
 | 0.15 | 0.34 | 0.65 | 0.234 | 0.78 | 0.23 |  |  |  |  |  | a | 3 | 6 | 7 | 7 |  | 120 | 140 | 180 | 111
 | 0.54 | 0.78 | 0.575 | 0.969 | 0.876 | 0.787 |  |  |  |  |  | b | 5 | 6 | 6 | 6 |  | 435 | 235 | 23 | 123
 | 0.786 | 0.098 | 0.546 | 0.273 | 0.433 | 0.12 |  |  |  |  |  | c | 1 | 3 | 4 | 4 |  | 67 | 457 | 36 | 36
 | 0.453 | 0.986 | 0.222 | 0.246 | 0.278 | 0.274 |  |  |  |  |  | d | 1 | 10 | 9 | 9 |  | 235 | 45 | 34 | 436
 |  |  |  |  |  |  |  |  |  |  |  | e | 1 | 4 | 7 | 7
 |  |  |  |  |  |  |  | 1545.6 | 2468.88 | 1522.476 |  | f | 6 | 3 | 2 | 2
 | Result Required in Blue Cells with following combination
 | a(Weight)*a(Price)*Quanity |  |  |  |  | As per D,E,F & G column.
 | For instance:
 | Cell H5 | ((B5*N5)+(C5*N6)+(D5*N7)+(E5*N8)+(F5*N9)+(G5*N10))*S5 |  |  |  |  |  | =
 | Same way in H6, Heading E and so on
Spreadsheet: 115538d1311106786-conditional-formatting-quirk-with-number-formatting-quirky
Sheet: Sheet1

 |  | 3 |  | 0.2796186711084545
 |  |  |  | 0.3393513600664413
 |  |  |  | 0.695953091215999
 |  |  |  | 0.09732931177830917
 |  |  |  | 0.9059304208922032
 |  |  |  | 0.8909963573427062
 |  |  |  | 0.4397528446721273
 |  |  |  | 0.8499386288134545
 |  |  |  | 0.7716913743271958
 |  |  |  | 0.2046118341082732
 |  |  |  | 0.6146390321186108
 |  |  |  | 0.8110970804023849
 |  |  |  | 0.801088671621863
 |  |  |  | 0.8566760193906677
 |  |  |  | 0.3776317074118722
 |  |  |  | 0.7129661731983878
 |  |  |  | 0.1682569480884855
 |  |  |  | 0.08544081282645566
 |  |  |  | 0.3837612042221084
 |  |  |  | 0.6911656878523029
Spreadsheet: 768044d1644806418-how-can-i-create-rows-automatically-when-new-data-emerge-automatic-row-creation
Sheet: Sheet2

 | bew |  | 100 | 10
 |  | bew | 100 | 40
 |  | bew | 400 | 900
 |  | bew | 100 | 700
 |  | bew | 100 | 200
 | edmundson |  | 100 | 50
 |  | edmundson | 200 | 60
 |  | edmundson | 300 | 800
 |  | edmundson | 200 | 100
 | cef |  | 300 | 50
 |  | cef | 100 | 900
 |  | cef | 300 | 400
Spreadsheet: 120076d1314965751-copy-row-to-another-sheet-on-condition-sample
Sheet: Jan

 |  | For the month of:
 | No | First Name | Surname | Date1 | Date1 | Date2 | Date3
 | 1 | xyz | [NAME] | 2011-06-15 00:00:00 | 2011-08-11 00:00:00 | 8.142857142857142
 | 2 | xyz | zzz | 2011-06-06 00:00:00 | 2011-08-11 00:00:00 | 9.428571428571429
 | 3 | yzx | xxx | 2011-06-06 00:00:00 |  |  | 12.64974174933845
 | 4 | yzx | xxx | 2011-06-07 00:00:00 |  |  | 12.50688460648131
Spreadsheet: 795006d1662461716-right-forumla-in-vlookup-error-urmarire-porci-2022
Sheet: DECEMBRIE

 |  | NR. CRT | DATA TAIERE | NR. CAPETE | GREUTATE VIU | [NAME] | LOT | Greutate [NAME] | Greutate [NAME] | GREUTATE CARCASA CU CAP | GREUTATE ORGANE | RANDAMENT | Column1
 |  | 1 | 2021-12-01 00:00:00 | 10 | 1090 |  | 231 |  | 870 |  | 36
 |  | 2 | 2021-12-02 00:00:00 | 10 | 1087 |  | 232 | 867 |  |  | 36
 |  | 3 | 2021-12-03 00:00:00 | 10 | 1060 |  | 233 |  | 838 |  | 32
 |  | 4 | 2021-12-04 00:00:00 | 10 | 1091 |  | 234 | 435 | 435 |  | 34
 |  | 5 | 2021-12-05 00:00:00 | 10 | 1089 |  | 235 |  | 870 |  | 34
 |  | 6 | 2021-12-06 00:00:00 | 5 | 548 |  | 236 |  | 439 |  | 18
 |  | 7 | 2021-12-07 00:00:00 | 10 | 1078 |  | 237 |  |  |  | 36
 |  | 8 | 2021-12-08 00:00:00 | 10 | 1050 |  | 238 |  |  |  | 35
 |  | 9 | 2021-12-10 00:00:00 | 10 | 1072 |  | 239 |  |  |  | 37
 |  | 10 | 2021-12-12 00:00:00 | 10 | 1090 |  | 230 |  |  |  | 34
 |  | 11 | 2021-12-13 00:00:00 | 10 | 1087 |  | 231 |  |  |  | 34
 |  | 12 | 2021-12-14 00:00:00 | 10 | 1090 |  | 232 |  |  |  | 34
 |  | 13 | 2021-12-15 00:00:00 | 9 | 972 |  | 232 |  |  |  | 30
 |  | 14 | 2021-12-17 00:00:00 | 9 | 980 |  | 233 |  |  |  | 30
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | Total
Spreadsheet: 762fc51b-79a6-43b8-b360-825ebe0723cc
Sheet: E-STAX

[NAME] 2014
 | Online Book Views | Books Downloaded | Total Book Use
August | 3 | 11
September | 7 | 26
October | 6 | 9
November
December
Total
Notes:
Live to Public on August 1, 2014.
Books can either be viewed online or downloaded.
Spreadsheet: 715767d1611856008-averageifs-gives-me-two-different-results-in-two-tables-that-have-same-values-average-issue
Sheet: Sheet1

Average of Result | Column Labels
Row Labels | Closure Review | Late Reporting | TAT
France | 0.85 | 0.075 | 35.5
Germany | 0.935 | 0.07 | 46.5
Italy | 0.8799999999999999 | 0.08 | 36.5
Portugal | 0.85 | 0.06 | 44.5
Spain | 0.845 | 0.07 | 40.5
Grand Total | 0.8719999999999999 | 0.071 | 40.7
Spreadsheet: phillip_allen__29456__Phillip Allen Muni Bond Proposal
Sheet: Volatility

 |  |  |  |  |  |  |  |  |  |  |  | Projected Return on 12 Month Horizon
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calculation of Duration |  |  |  | Calculation of 12 Mo. Horizon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calculation of Weighted Averages
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO CHANGE |  |  |  | -0.01 |  |  |  | -0.005 |  |  |  | 0.005 |  |  |  | 0.01
($000's) |  |  |  |  |  |  | Mod. | -100 | -50 | NO | +50 | +100 |  |  |  |  |  |  |  | 1 year |  | Market Price |  |  | 1 year | Market Price |  |  | 1 year | Market Price |  |  | 1 year | Market Price |  |  | 1 year | Market Price |  |  | 1 year
Par | Rating | Description | Coupon | Maturity | Yield | Price | Dur. | Basis Pts | Basis Pts | Change | Basis Pts | Basis Pts |  |  |  |  |  | Mduration |  | Interest |  | Premium | Par | Maturity | Return | [NAME] | Par | Maturity | Return | [NAME] | Par | Maturity | Return | [NAME] | Par | Maturity | Return | [NAME] | Par | Maturity | Return |  |  | Market Value | PAR*COUPON | MATURITY | YIELD | CURRENT YIELD | DURATION | No Chage | -100 | -50 | +50 | 100 |  | DTD | Settlement
TOTAL |  |  | Average | Average | Average |  | Average | Average | Average | Average | Average | Average
*  Does not assume any reinvestment of coupon payments
Spreadsheet: 21674d1209462363-if-function-help-selfsumaudform
Sheet: Sheet2

Audit Date:
2009-04-29 00:00:00 | High Volume |  |  | Lab |  |  | Feeder |  |  | BWO/GAL/BoB |  |  | Lean Cells
 | # yes | # no | Score | # yes | # no | Score | # yes | # no | Score | # yes | # no | Score | # yes | # no | Score
BoM Visible | 1 |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  |  | #N/A
comments
Print Visible |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
comments
Assembly Meets Print |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
comments
Surface Finish |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
comments
Functional Test |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
comments
Finished Goods |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
comments
[NAME] |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
comments
Dunnage |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
comments
 | 1 | 0 | 1 | 0 | 0 | #N/A | 0 | 0 | #N/A | 0 | 0 | #N/A | 0 | 0 | #N/A
Issues of Importance
Spreadsheet: 779458d1651789759-sumproduct-with-named-ranges-indirect-and-multiple-criteria-sales-2022-phone-stats-to-get-formula
Sheet: April

2022 | Inbound Sales
Date | Handled ACD Calls | [NAME] | Total Calls Rcd | [NAME] | [NAME] (sec) | [NAME] (sec) | Max Wait Time (sec) | Avg Wrap Time | Avg Call Time (sec) | Five 9 OB Calls | Outbound Calls
2022-03-27 00:00:00
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  | 23 |  |  | 108 | 164 | 1027 | 121 | 645 | 567 | 318
Week TTL
 |  | 28 |  |  | 178 | 209 | 864 | 91 | 516 | 611 | 272
 |  | 7 |  |  | 125 | 181 | 644 | 93 | 568 | 264 | 262
 |  | 62 |  |  | 280 | 309 | 1081 | 129 | 530 | 131 | 273
 |  | 34 |  |  | 142 | 188 | 979 | 121 | 609 | 304 | 357
 |  | 72 |  |  | 264 | 456 | 1292 | 180 | 575 | 422 | 193
Week TTL
 |  | 70 |  |  | 364 | 483 | 1690 | 107 | 492 | 551 | 287
 |  | 28 |  |  | 166 | 144 | 700 | 175 | 618 |  | 352
 |  | 59 |  |  | 258 | 379 | 1174 | 181 | 660 | 405 | 314
 |  | 43 |  |  | 230 | 295 | 1181 | 149 | 556 | 727 | 507
 |  | 22 |  |  | 147 | 150 | 678 | 91 | 613 | 565 | 616
Week TTL
 |  | 35 |  |  | 137 | 217 | 697 | 174 | 633 | 353 | 373
 |  | 16 |  |  | 84 | 104 | 605 | 144 | 535 | 620 | 628
 | 291 | 40 |  |  | 161 | 247 | 869 | 153 | 562 | 587 | 373
 | 271 | 27 |  |  | 134 | 152 | 564 | 154 | 539 | 434 | 361
 | 266 | 10 |  |  | 166 | 169 | 734 | 208 | 579 | 311 | 308
Week TTL
 | 297 | 38 |  |  | 171 | 207 | 916 | 140 | 616 | 187
 | 284 | 28 |  |  | 119 | 158 | 786 | 171 | 578 | 280 | 356
 | 292 | 39 |  |  | 196 | 210 | 779 | 172 | 574 | 453 | 361
 | 244 | 28 |  |  | 160 | 181 | 919 | 224 | 569 | 351 | 384
 | 248 | 30 |  |  | 187 | 243 | 896 | 173 | 599 | 474 | 273
Week TTL
Month TTL
 |  |  |  |  |  |  |  |  |  |  | For Outbound Calls
 |  |  |  |  |  |  |  |  |  |  | Sales Agent Only Reason Code Summary with outbound Call Count