tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 127623d1320430812-index-count-sequence-unique-dates-based-on-values-in-another-column-summarizesalesdata
Sheet: Sheet2

Product | Sell Date | Number Sold |  | Helper Column | Product | Sell Date | Campaign Week | Sales in [NAME] | Items Sold/Wk
Widget A | 2011-04-09 17:00:00 | 5 |  | Widget A40642 | Widget A | 2011-04-09 00:00:00 | Widget A - Wk 1 | 1 | 5
Widget A | 2011-04-16 17:00:00 | 5 |  | Widget A40649 | Widget A | 2011-04-16 00:00:00 | Widget A - Wk 2 | 2 | 10
Widget A | 2011-04-16 17:00:00 | 5 |  | Widget A40663 | Widget A | 2011-04-30 00:00:00 | Widget A - Wk 3 | 1 | 5
Widget A | 2011-04-30 00:00:00 | 5 |  | Widget A40670 | Widget A | 2011-05-07 00:00:00 | Widget A - Wk 4 | 1 | 5
Widget A | 2011-05-07 00:00:00 | 5 |  | Widget A40677 | Widget A | 2011-05-14 00:00:00 | Widget A - Wk 5 | 2 | 10
Widget A | 2011-05-14 00:00:00 | 5 |  | Widget B40649 | Widget B | 2011-04-16 00:00:00 | Widget B - Wk 1 | 3 | 15
Widget A | 2011-05-14 00:00:00 | 5 |  | Widget B40656 | Widget B | 2011-04-23 00:00:00 | Widget B - Wk 2 | 1 | 5
Widget B | 2011-04-16 17:00:00 | 5 |  | Widget B40663 | Widget B | 2011-04-30 00:00:00 | Widget B - Wk 3 | 1 | 5
Widget B | 2011-04-16 17:00:00 | 5 |  | Widget B40670 | Widget B | 2011-05-07 00:00:00 | Widget B - Wk 4 | 2 | 10
Widget B | 2011-04-16 17:00:00 | 5 |  | Widget B40677 | Widget B | 2011-05-14 00:00:00 | Widget B - Wk 5 | 1 | 5
Widget B | 2011-04-23 00:00:00 | 5 |  | Widget C40642 | Widget C | 2011-04-09 00:00:00 | Widget C - Wk 1 | 1 | 5
Widget B | 2011-04-30 00:00:00 | 5 |  | Widget C40656 | Widget C | 2011-04-23 00:00:00 | Widget C - Wk 2 | 1 | 5
Widget B | 2011-05-07 00:00:00 | 5 |  | Widget C40663 | Widget C | 2011-04-30 00:00:00 | Widget C - Wk 3 | 1 | 5
Widget B | 2011-05-07 00:00:00 | 5 |  | Widget C40670 | Widget C | 2011-05-07 00:00:00 | Widget C - Wk 4 | 1 | 5
Widget B | 2011-05-14 00:00:00 | 5
Widget C | 2011-04-09 17:00:00 | 5
Widget C | 2011-04-23 17:00:00 | 5
Widget C | 2011-04-30 17:00:00 | 5
Widget C | 2011-05-07 00:00:00 | 5
Spreadsheet: 489620d1479358493-find-one-cell-up-bowling-bvj-
Sheet: Sheet1

 |  |  |  |  | Series Totals
 | Last weeks average | This weeks average |  |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 |  |  | weekly scores counted | latest week
 |  |  | [NAME] |  | 597 | 554 | 588
 |  |  | [NAME] |  | 602
 |  |  | [NAME] |  | 625 | 588 | 615
 |  |  | [NAME] |  |  | 634 | 601
 |  |  | [NAME] |  | 578 | 596
 |  |  | [NAME] |  | 602 | 635 | 575
 |  |  | [NAME] |  | 600 | 600 | 600
 |  |  | Mark |  | 525 | 575 | 584
Spreadsheet: 868842d1715564596-custom-calendar-help-dynamic-calendar-3-
Sheet: JAN

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C | D
Spreadsheet: 0c1b57b7-468a-48cf-8258-4501dfebea8a
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
BANA | Test | BANA | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
BANA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BANA | Result | BANA | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6035-0
Spreadsheet: 555107d1515439415-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018
Sheet: Tournament 3

 |  |  |  |  |  | Tournament
 |  |  | Player | Score |  | Opponent | Score | Sub Total | Winner | Points | [NAME] Up | Points
 |  |  | [NAME] | 32 |  | Edna May | 41 |  |  | 2 |  | 1
 |  |  | [NAME] | 37 |  | [NAME] | 34 |  |  | 2 |  | 1
 |  |  | P, [NAME] | 42 |  | [NAME] | 59 |  |  | 2 |  | 1
 |  |  | [NAME] | 32 |  | [NAME] | 55 |  |  | 2 |  | 1
 |  |  | [NAME] | 31 |  | [NAME] | 26 |  |  | 2 |  | 1
 |  |  | [NAME] | 44 |  | Hazle Nutt | 47 |  |  | 2 |  | 1
 |  |  | Raynor Schein | 56 |  | [NAME] | 33 |  |  | 2 |  | 1
 |  |  | [NAME] | 40 |  | [NAME] | 29 |  |  | 2 |  | 1
 |  |  | [NAME] Still | 32 |  | Hugh Jass | 34 |  |  | 2 |  | 1
 |  |  | [NAME] | 59 |  | Hy Price | 32 |  |  | 2 |  | 1
 |  |  | [NAME] | 42 |  | [NAME] | 45 |  |  | 2 |  | 1
 |  |  | [NAME] | 37 |  | I.D. Clair | 30 |  |  | 2 |  | 1
 |  |  | [NAME] | 49 |  | [NAME] | 41 |  |  | 2 |  | 1
 |  |  | Anne Other | 34 |  | Ima Belle | 54 |  |  | 2 |  | 1
 |  |  | [NAME] | 32 |  | Ima Dunce | 50 |  |  | 2 |  | 1
 |  |  | [NAME] | 48 |  | [NAME] | 28 |  |  | 2 |  | 1
 |  |  | [NAME] | 41 |  | [NAME] | 34 |  |  | 2 |  | 1
 |  |  | Brandy D. Cantor | 27 |  | [NAME] | 54 |  |  | 2 |  | 1
 |  |  | Brighton Early | 51 |  | [NAME] | 32 |  |  | 2 |  | 1
 |  |  | [NAME] | 53 |  | [NAME] | 31 |  |  | 2 |  | 1
 |  |  | [NAME] | 29 |  | [NAME] | 33 |  |  | 2 |  | 1
 |  |  | [NAME] | 25 |  | [NAME] | 29 |  |  | 2 |  | 1
 |  |  | [NAME] | 59 |  | [NAME] | 32 |  |  | 2 |  | 1
 |  |  | [NAME] | 36 |  | [NAME] | 58 |  |  | 2 |  | 1
 |  |  | [NAME] | 59 |  | [NAME] | 38 |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  | x | x | x |  | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  |  | Round Score | Points (A) | Points (B) | Round Points
 |  |  | x | x | x | x | x | x | x | x | x | x
Spreadsheet: 687043d1594924642-countifs-for-unique-data-book1v2
Sheet: Sheet1

 |  |  |  |  | Example 1
 | Client | Date | Won/Lost |  |  |  | Total Distinct Clients | New Unique Clients |  |  | Comment
 | [NAME] | 2020-04-15 00:00:00 | Won |  | 2020-05-01 00:00:00 | To End of April |  |  |  |  | 3 clients, all unique
 | [NAME] | 2020-04-30 00:00:00 | Won |  |  | To End of May |  |  |  |  | 8 deals but [NAME] and [NAME] each had 2 deals so 6 DISTINCT. From April, [NAME] and [NAME] are new
 | [NAME] | 2020-04-30 00:00:00 | Won |  |  | To End of June |  |  |  |  | 7 discint clients, [NAME] was new
 | [NAME] | 2020-05-10 00:00:00 | Won
 | [NAME] | 2020-05-10 00:00:00 | Won
 | [NAME] | 2020-05-10 00:00:00 | Won
 | [NAME] | 2020-05-30 00:00:00 | Won
 | [NAME] | 2020-05-30 00:00:00 | Won
 | [NAME] | 2020-06-10 00:00:00 | Won |  |  |  | To the extend helpful, these were my formulas
 | [NAME] | 2020-06-15 00:00:00 | Won |  |  |  | Array for total distinct | Arrow for unique
 | [NAME] | 2020-06-30 00:00:00 | Won |  |  |  |  |  |  |  | 7 distinct, only unique clients are [NAME] and [NAME]
 | [NAME] | 2020-06-30 00:00:00 | Won
 | [NAME] | 2020-06-30 00:00:00 | Lost
 |  |  |  |  | Example 2
 |  |  |  |  | From Date | To Date | Total Distinct Clients (Won) | New Unique Clients (Won)
 |  |  |  |  | 2020-04-01 00:00:00 | 2020-05-01 00:00:00
 |  |  |  |  | 2020-04-01 00:00:00 | 2020-06-01 00:00:00
 |  |  |  |  | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 6 |  |  |  | Should be 6 distinct clients since we didn't win [NAME]
 |  |  | This is really final product |  | From Date | To Date | Total Distinct Clients (Won) | New Unique Clients (Won)
 |  |  |  |  | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 4 |  |  |  | Question I'm trying to answer is how many clients did we do business with in a given month and how many of them have we never done business with before? Here, it's 4 clients we've done business with ([NAME], [NAME], [NAME], [NAME]) but [NAME] is a repeat client
 |  |  |  |  | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 3 | 0 |  |  | same thing here, should only be 3 distinct clients because we lost the trade with [NAME]. No unique clients from start
Spreadsheet: 675616d1588368932-if-formula-pricing-model
Sheet: Draft

 | Setup |  |  |  |  |  | Recurring Revenue |  |  |  |  |  |  | Add-ons (per user/year)
Company | Users |  | Admins  included | OTS  Included | XRLP  Installation |  | Contract | Price |  | Yearly  Revenue |  | Contract  Revenue |  | Modules |  |  |  | XRLP |  | Support (OOH)
 | Min | [NAME] |  |  |  |  | Years | Per user/ Per month | Per user/ Per year | Month | Year |  |  | Bespoke | Level 1 | Level 2 | Level 3 | Prototyper | Extra  Admin | Month | Year
Multiple |  |  | 2 | 2 | 2 |  |  | 0.8 | 12 |  |  |  |  | 1 | 2 | 2 | 2 |  |  | 1.2 | 12
Small | 1 | 100 | 2 | 2 | 1000 |  | 1 | 5 |  |  |  |  |  | 4 |  |  |  | 3000 | 40
Medium | 101 | 500 |  |  |  |  | 1 |  |  |  |  |  |  | 3
Med/Large | 501 | 1000 |  |  |  |  | 1 | 2 |  |  |  |  |  | 2
Large | 1001 | 10000 |  |  |  |  | 1 | 1 |  |  |  |  |  | 1
Small | 1 | 100 | 2 | 2 | 1000 |  | 2 |  |  |  |  |  |  | 4 |  |  |  | 3000 | 40
Medium | 101 | 500 |  |  |  |  | 2 |  |  |  |  |  |  | 3
Med/Large | 501 | 1000 |  |  |  |  | 2 |  |  |  |  |  |  | 2
Large | 1001 | 10000 |  |  |  |  | 2 |  |  |  |  |  |  | 1
Small | 1 | 100 | 2 | 2 | 1000 |  | 3 |  |  |  |  |  |  | 4 |  |  |  | 3000 | 40
Medium | 101 | 500 |  |  |  |  | 3 |  |  |  |  |  |  | 3
Med/Large | 501 | 1000 |  |  |  |  | 3 |  |  |  |  |  |  | 2
Large | 1001 | 10000 |  |  |  |  | 3 |  |  |  |  |  |  | 1
NO COSTS
Support Levels
Prototyper
Support
Uploading
Apple/Android Mgmt
Training
Cost for uploading/accessing modules
XRLP
Levels of Hierarchy
Anon v Not
Deloitte inside network
Spreadsheet: bd7d6f4d-b871-4c5a-8aec-f39950da60ed
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5766 | 30746 | Ernst | Scheiber | AUT | 29 | 00:12:55 | [NAME] | 00:30:14 | 00:02:54 | 00:24:09 | 1 | 01:13:54
5766 | 40142 | Yan | Guanter | FRA | 31 | 00:11:48 | 00:02:54 | 00:33:35 | 00:02:23 | 00:24:27 | 2 | 01:15:05
5766 | 13651 | Martin | Falch | AUT | 28 | 00:14:25 | 00:03:07 | 00:34:49 | 00:02:47 | 00:24:10 | 3 | 01:19:16
5766 | 40956 | [NAME] | Flint | GBR | 32 | 00:13:58 | 00:03:08 | 00:34:17 | 00:02:16 | 00:25:58 | 4 | 01:19:36
5766 | 41160 | Adrian | Howden | GBR | 33 | 00:17:05 | 00:04:22 | 00:38:22 | 00:03:02 | 00:26:19 | 5 | 01:29:10
5766 | 39858 | Mikel | Garmendia | ESP | 30 | 00:13:06 | 00:05:34 | 00:37:44 | 00:04:52 | 00:32:04 | 6 | 01:33:19
Spreadsheet: 123932d1317930858-excel-2007-vlookup-enter-same-look-up-and-populate
Sheet: Sheet1

S | S | S | S |  | Row 1 Manual input and can be extended to col E F G etc
 | S |  |  |  |  |  | S |  |  |  |  |  | S |  | Row 2 Auto S in any cell
 | S | S | S | S |  |  | S | S | S | S |  |  | S | S | S | S |  | Row 3 Result, replicate Row 1 at Row 2 prompt
Spreadsheet: 119059d1314178818-excel-2007-copy-rows-to-new-tab-still-lost
Sheet: Between 5 and 10

name | amount | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
def | 6 | 212 | 234 | 256 | 278 | 222 | 212
ghi | 8 | 312 | 334 | 356 | 378 | 333 | 312
[NAME] | 9.5 | un | deux | trois | quatre | cinq | six
yza | 10 | horse | dog | cow | cat | fish | bird
Spreadsheet: 101646d1299733490-excel-2007-extracting-and-adding-numbers-ot-equalization-example
Sheet: Sheet1

 |  |  |  | Prior Week | Mon | [NAME] | Wed | Thur | Fri | Sat | Sun
Badge | Name | Title | Dept # | Ending Total | 2011-02-21 00:00:00 | 2011-02-22 00:00:00 | 2011-02-23 00:00:00 | 2011-02-24 00:00:00 | 2011-02-25 00:00:00 | 2011-02-26 00:00:00 | 2011-02-27 00:00:00 | Total worked
K01789 | em1 | A/C Rad-Inst Tec | SK172243 | 0 | w2 | r2 | w1r1 | r2 | w2 | r5 | r5 | 5
[NAME] | em2 | [NAME] A/C | SK172243 | 0 | w2 | r2 | w1r1 | r2 | w2 | r5 | r5 | 5
K02867 | em 3 | [NAME] A/C | SK172243 | 0 | w2 | r2 | w1r1 | r2 | w2 | r5 | r5 | 5
[NAME] | x | [NAME] A/C | SK172243 | 0 | w2 | r2 | w1r1 | r2 | w2 | r5 | r5 | 5
K02067 | y | [NAME] T07 | SK172243 | 0 | w2 | r2 | w1r1 | r2 | w2 | r5 | r5 | 5
K02296 | z | A/C Rad-Inst Tec | SK172243 | 0 | w2 | r2 | w1r1 | r2 | w2 | w5 | r5 | 10
[NAME] | a | [NAME] A/C | SK172243 | 0 | w2 | r2 | w1r1 | r2 | w2 | r5 | r5 | 5
K02482 | b | [NAME] T07 | SK172243 | 0 | w2 | r2 | w1r1 | r2 | w2 | r5 | r5 | 5
[NAME] | c | [NAME] A/C | SK172243 | 0 | w2 | r2 | w1r1 | r2 | w2 | r5 | r5 | 5
K02617 | d | A/C Rad-Inst Tec | SK172243 | 0 | w2 | r2 | w1r1 | r2 | w2 | r5 | r5 | 5
K02152 | e | A/C Rad-Inst Tec | SK172243 | 0 | w2 | r2 | w1r1 | r2 | w2 | w5 | w5 | 15
K02467 | f | [NAME] A/C | SK172243 | 0 | w2 | r2 | w1r1 | r2 | w2 | r5 | r5 | 5
K02999 | g | [NAME] A/C | SK172243 | 0 | w2 | r2 | w1r1 | r2 | w2 | r5 | r5 | 5
[NAME] | h | [NAME] A/C | SK172243 | 0 | w2 | r2 | w1r1 | r2 | w2 | r5 | r5 | 5
 | Approved Codes: A-Absent, L-Late Ask, N-Accepted, Did Not Work As Agreed, O-Out of Department, R-Refused, S-Sick Leave, U-Union Rep, W-Worked
Spreadsheet: df7a72af-de6a-4d10-b213-4a423f693164
Sheet: Sheet1

Adults Ages 18 Year and Over With 6 or More Teeth Lost Due to [NAME] or Gum Disease,  by Selected Demographics, Maine 2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  | Unweighted Number |  | Weighted Number |  | % |  | LCL |  | UCL
Sex
 | Female | 1346 |  | 108683.5314552035 |  | 20.2626633022642 |  | 18.99252334985762 |  | 21.53280325467078
 | Male | 857 |  | 95297.40854766546 |  | 19.07354798298125 |  | 17.43147185932878 |  | 20.71562410663372
Age
 | 18-24 | NSD |  | NSD |  | NSD |  | NSD |  | NSD
 | 25-34 | 24 |  | 6884.878423267171 |  | 4.644656638977879 |  | 2.641164645490242 |  | 6.648148632465515
 | 35-44 | 63 |  | 10352.77417543175 |  | 5.948001234164532 |  | 4.332871255870272 |  | 7.563131212458791
 | 45-54 | 318 |  | 40833.40575477408 |  | 19.15033898930899 |  | 16.34414354956586 |  | 21.95653442905212
 | 55-64 | 577 |  | 51779.19711888512 |  | 28.77236020165843 |  | 26.51274229679931 |  | 31.03197810651755
 | 65+ | 1206 |  | 92782.00041551453 |  | 45.77917674391003 |  | 43.6259963311085 |  | 47.93235715671155
Education
 | Did not graduate High School | 350 |  | 31442.33988467506 |  | 48.4293124442722 |  | 42.19176173091618 |  | 54.66686315762822
 | Graduated High School | 1041 |  | 100505.1011408194 |  | 29.02685915766086 |  | 26.79261801311399 |  | 31.26110030220773
 | Attended College or Technical School | 486 |  | 42529.25993840808 |  | 15.8669935629891 |  | 14.20390620701512 |  | 17.53008091896308
 | Graduated from College or Technical School | 321 |  | 29228.2405262437 |  | 8.21497285318784 |  | 7.093658691897055 |  | 9.336287014478623
Income
 | Less than $15,000 | 503 |  | 39768.19541581283 |  | 42.31274355666423 |  | 37.00473772941988 |  | 47.62074938390858
 | $15,000 to less than $25,000 | 592 |  | 52615.45104605149 |  | 34.20730983518283 |  | 30.94055656687917 |  | 37.47406310348651
 | $25,000 to less than $35,000 | 277 |  | 27967.08207585195 |  | 27.7097934025235 |  | 24.10459902997028 |  | 31.31498777507672
 | $35,000 to less than $50,000 | 246 |  | 25236.41115552609 |  | 16.95492167950871 |  | 14.58904501028439 |  | 19.32079834873303
 | $50,000 or more | 285 |  | 31538.14893852447 |  | 7.668417416515886 |  | 6.68253624595719 |  | 8.654298587074582
Data Source: Behavioral Risk Factor Surveillance System Based on permanent teeth removed because of tooth decay or gum disease, not including teeth lost for other reasons, such as injury or orthodontics.  %= Weighted percentage of respondents LCL= Lower 95% confidence level of the weighted percentage UCL= Upper 95% confidence level of the weighted percentage
NSD:  non-sufficient data, data is suppressed to protect privacy
Spreadsheet: 2782a53a-7fc5-4704-94d4-11194a746082
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | College Name |  |  |  |  |  |  | Quarter Reporting Period
Module Information:
Class Hours |  |  |  |  |  |  |  |  |  | Unduplicated Count
Education: |  |  |  |  |  |  |  |  |  | Youth:
Employment: |  |  |  |  |  |  |  |  |  | Emancipated Youth:
Daily Living: |  |  |  | How many hours were experiential: |  |  |  |  |  | Adult:
Finanical Literacy: |  |  |  |  |  |  |  |  |  | Non Minor Dependent
Speaker Bureau: |  |  |  |  |  |  |  |  |  | Total Unduplicated Count | 0
Total Hours | 0
One-on-One Youth Information: |  |  |  |  |  |  | [NAME] in College Information
Total number of youth one-on-one hours: |  |  |  |  |  | Number of youth currently enrolled in college.
Total number of adult one-on-one hours: |  |  |  |  |  | Number of youth who have completed one or more college courses.
Number of participating youth: |  |  |  |  |  | Number of youth who have earned a vocational certificate, two year degree, or transferred to a four year institution.
Number of participating adults:
Total number of participating youth and adults:
Report Narrative:
 | Completed By |  |  |  |  |  |  |  | Date Completed
Spreadsheet: 0543e28b-e6a3-435d-80c0-c69d2a1d9e95
Sheet: Base Rates

Owners Forms
USAA Group
Pennsylvania
Current and Proposed Company Base Rates
 | Current Base Rates
Company | Other Perils | Other Fire | Other Wind and Hail | Theft | Water | Lightning | Liability | Hurricane | Severe Thunderstorm | Winter Storm | Fire Following Earthquake | Earthquake Coverage
USAA | 878.9 | 374.29 | 110.71 | N/A | N/A | N/A | N/A | 20.46 | 63.75 | 48.62 | 2.79 | 146.39
USAA-CIC | 1063.48 | 484.78 | 150.34 | N/A | N/A | N/A | N/A | 20.46 | 63.75 | 48.62 | 2.79 | 146.39
USAA-GIC | 932.53 | 410.06 | 117.75 | N/A | N/A | N/A | N/A | 20.46 | 63.75 | 48.62 | 2.79 | 146.39
[NAME] | 1036.46 | 505.86 | 145.86 | N/A | N/A | N/A | N/A | 20.46 | 63.75 | 48.62 | 2.79 | 146.39
 | Proposed Base Rates
Company | Other Perils | Other Fire | Other Wind and Hail | Theft | Water | Lightning | Liability | Hurricane | Severe Thunderstorm | Winter Storm | Fire Following Earthquake | Earthquake Coverage
USAA | 207.71 | 399.84 | 164.59 | 58.02 | 539.39 | 25.82 | 100.43 | 22.85 | 67.52 | 52.04 | 3.01 | 167.11
USAA-CIC | 234.7 | 445.64 | 198.96 | 61.21 | 581.55 | 30.72 | 113.69 | 22.85 | 67.52 | 52.04 | 3.01 | 167.11
USAA-GIC | 211.7 | 468.57 | 162.75 | 57.14 | 607.88 | 31.79 | 94.9 | 22.85 | 67.52 | 52.04 | 3.01 | 167.11
[NAME] | 220.73 | 402.27 | 199.36 | 54.25 | 579.77 | 32.27 | 100.19 | 22.85 | 67.52 | 52.04 | 3.01 | 167.11
Spreadsheet: 101142d1299268553-count-dates-within-a-range-cy-2010-to-cy-2011
Sheet: 2010 Compared to 2011

Percent Inspections Completed By Week:  2010 - 2011
 |  |  | Total # Inspections Completed
 |  | Week | 2010 | 2011
 |  | 1 | 22 | 27
 |  | 2 | 29 | 14
 |  | 3 | 9 | 39
 |  | 4 | 14 | 41
 |  | 5 | 20 | 40
 |  | 6 | 15
 |  | 7 | 19
Spreadsheet: 200649d1355698280-sumifs-formula-that-includes-specific-text-testsumifsinctexts
Sheet: Sheet2

 | Countries | Sales
 | [NAME] | 12
 | BOLIVA | 34
 | COSTA RICA | 123
 | BRASIL | 9
 | BRASIL | 76
 | PERU | 45
 | [NAME] | 56
 | PERU | 98
 | PERU | 200
Spreadsheet: 799484d1665103398-is-this-possible-a1-b1-c-value-of-a1-example-8-
Sheet: daily

weeks |  | Day: | 2023-01-02 00:00:00
 |  |  | day 1
Time |  |  | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
name1
name 2
name3
name4
name5
name6
name7
name8
name9
name10
name11
name12
name13
name14
[NAME]
[NAME]
name17
name18
name19
name20
[NAME]
name22
name23
name24
name25
[NAME]
name27
name28
 | N/A = dont work that day |  |  |  |  | I have set d4 to correct value and as i drag that down i want the last output to be the same number as in one of the ones before them.
 |  |  |  |  |  | =LOOKUP(B4;C4;'time sheet'!E8)' |  |  |  | but i want it to be '=LOOKUP(B4;C4;'time sheet'!E(The number standing in b4)'
 |  |  |  |  |  |  | the next in line should print |  |  | =LOOKUP(B5;C5;'time sheet'!E9)' |  |  |  | but i want it to be '=LOOKUP(B5;C5;'time sheet'!E3)'
Spreadsheet: 750661d1633573537-cell-contains-a-date-then-returns-a-certain-text-permit-register-example-7-10-2021
Sheet: Quotes

ABC Job Number | Address | Description | Client
 | Address 27 | Description 27 | Client 27
ABC-21028 | Address 28 | Description 28 | Client 28
ABC-21029 | Address 29 | Description 29 | Client 29
ABC-21030 | Address 30 | Description 30 | Client 30
Spreadsheet: 676689d1588936894-linking-two-cells-to-return-values-in-columns-2312-daily-production-report
Sheet: Daily Report

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weeknum | Date | Month | Year
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 |  |  |  |  |  |  |  |  |  |  | Daily Production Report |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  |  |  |  |  |  |  |  |  |  | Week | Date | Shift
 |  |  |  |  |  |  |  |  |  |  |  |  | 2020-04-25 00:00:00 | 1st Shift
 |  |  |  |  |  |  |  |  |  |  | Department | Machine | Issue | Action | Downtime | Date
Spreadsheet: 794608d1662138282-how-to-use-vloop-up-formula-to-retrieve-the-values-from-different-work-sheet-test
Sheet: Commissions

Sr. # | DATE | DAY | Associates | Commission
1 | 2022-09-01 00:00:00 | 1 | ABHISHEK | 1000
 | 2022-09-01 00:00:00 | 1 | SANDEEP YADAV | 700
 | 2022-09-01 00:00:00 | 1 | AIEN | 500
 | 2022-09-01 00:00:00 | 1 | SENTI | 2200
 | 2022-09-01 00:00:00 | 1 | AMY | 400
 |  |  | Total
Spreadsheet: darron_c_giron__7961__Ftoc0500
Sheet: Input

FT-ONT-Central |  |  |  |  | The number below should tie to the broker fee report received on the 1st day of the month
Current Month Broker Fees
2000-05-31 00:00:00 | G1P | G1I | G3M | TOTAL
 |  | 800149
Swaps
Options |  | 0 | 0
Currency | 0 | 0 | 0
Total
 |  |  |  |  |  | Legend:
Change in Prior Day | 0 | 0 | 0 | 0
[NAME] |  |  |  |  |  |  | Input data from top pages
Curve Shift - Basis |  | 0 | 0 |  |  |  | Input data from Fx Model
[NAME] |  | 0 | 0
New Deals
Change in Existing Deals
Gamma
Vega
Theta
Rho
Drift
Foreign Currency - FX Book | 0 | 0 | 0
FX Rho | 0 | 0 | 0
FX Drift | 0 | 0 | 0
Origination | 0
Liquidations
2nd Order
Balance | -1 | -1 | 0
Broker Fees |  | 0 | 0
TOTAL
Longs | 70596 | 45727 | 1159
Shorts | -71959 | -41734 | -1049
Options |  | 0 | 0
Futures | 0 | 0 | 0
Net PV MMBTUs
Change in Prudency
Total Prudency | 0 | 0 | 0
PRUDENCY CHECK
Adjusted Prior Day
Total
Prior Day - Input Sheet
Swaps | -2902366.3885 | 484638.5755 | 1118891.7306 | -1298836.0824
Options | 1451140.3422 | 0 | 0 | 1451140.3422
Currency | 0 | 0 | 0 | 0
Total |  |  |  | -28369
Prior Day Prudency | 0 | 0 | 0
Prior Day - Download
Swaps
Options |  | 0 | 0
Currency | 0 | 0 | 0
Total
Spreadsheet: 171811d1343869112-need-column-with-subtotal-of-multiple-criteria-groups-sumif-example-day92
Sheet: Sheet1

a | 1 | p | 19
a | 2 | p | 21
a | 2 | p | 12
a | 4 | p | 42
b | 4 | p | 12
b | 4 | p | 32
c | 7 | p | 68
c | 7 | a | 72
c | 8 | p | 52
c | 8 | p | 12