tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 467670d1466805350-merge-two-lists-which-both-have-label-and-constituents-into-one-list-maintain-hierarchy-copy-of-excel-forum-1-with-formula
Sheet: Sample Output

 |  | Portfolio 1 (Enter Ticker, or in this case letter…i.e. "X" below) |  | [NAME] (Enter other ticker below)
 |  | X |  | Y | by entering X & Y, the output would then be all the holdings by Portfolio X & Portfolio Y in a list down the left side, maintaining sector groupings
 |  | Weight | Return | Weight | Return
For example, If we looked at Consumer Discretionary holdings for X & Y
Consumer Discretionary
These are all the holdings from X | AMC Networks Inc Class A | would pull in the weight that portfolio X has with this holding | would pull in the return portfolio X has with this holding
 | AutoZone Inc
 | Best Buy Co Inc |  | The holding list to the left would want to remove any duplicates, but be a complete list of all the holdings if we were to join X & Y into the same portfolio
 | CBS Corporation B
 | Charter Communications Inc
 | [NAME], Inc. Class A
 | D.R. Horton Inc
 | DISH Network Corp
 | Delphi Automotive PLC
 | Discovery Communications Inc Class A
 | Expedia Inc
 | Fossil Group Inc
 | GNC Holdings Inc
 | Gap, Inc.
 | Guess? Inc
 | Hasbro Inc
 | Kate Spade & Co
 | L Brands Inc
 | Lear Corp
 | Lennar Corp
 | Liberty Broadband Corp
 | Liberty Broadband Corp
 | Liberty Global, Inc. A
 | Liberty Interactive Corp Class A
 | Liberty Media Corporation A
 | Liberty Media Corporation C
 | MGM Resorts International
 | Macy's Inc
 | Mohawk Industries Inc
 | NVR Inc
 | Newell Rubbermaid Inc
 | PVH Corp
 | Ralph Lauren Corp Class A
 | Ross Stores, Inc.
 | Royal Caribbean Cruises Ltd
 | Sally Beauty Holdings Inc
 | Scripps Networks Interactive Inc
 | Staples Inc
 | Starwood Hotels & Resorts Worldwide Inc
 | Tempur-Pedic International, Inc.
 | Toll Brothers Inc
 | Urban Outfitters Inc
 | Vista Outdoor Inc
 | Whirlpool Corp
 | Williams-Sonoma, Inc.
 | Wyndham Worldwide Corporation
These are all the holdings from Y | [NAME]'s, Inc.
 | Bed Bath & Beyond Inc
 | Coach Inc
 | Gannett Co Inc
 | Gentex Corp
 | H&R Block Inc
 | Harley-Davidson Inc
 | Liberty Interactive Corp A
 | Liberty Interactive Corp Class A
 | Mattel Inc
 | Mohawk Industries, Inc.
 | Nordstrom Inc
 | Omnicom Group Inc
 | Tegna Inc
Once all holdings for Consumer Discretionary are accounted for above, we then move the next set of holdings by  Consumer Staples would follow
Consumer Staples
 | Campbell Soup Co |  | Again, pulling in only the holdings that would occur if X & Y were joined into one portfolio
 | Sysco Corporation
 | The Kroger Co
 | Bunge Ltd
 | Church & Dwight Company, Inc.
 | ConAgra Foods Inc
 | Constellation Brands Inc Class A
 | Edgewell Personal Care Co
 | Hain Celestial Group Inc
 | Hansen Natural Corporation
 | Ingredion Inc
 | JM Smucker Co
 | Kroger Co
 | Mead Johnson Nutrition Company
 | Molson Coors Brewing Co B
 | Tyson Foods Inc Class A
 | Whole Foods Market Inc
Spreadsheet: 220774d1363262939-sum-if-formula-financial-accounting-bank-of-america-checking-not-working
Sheet: Accounting

2012 Final xxxx Accounting-Joint Account
 |  | Bank Name: |  | Bank of America |  |  |  |  |  | Account: | xxxxxx
 |  | Accounts Reviewed: |  | xxxxxxxxxxxxxxxxxx |  |  |  |  | Account Holder: |  | xxxxxx
 |  | Account Timeperiod: |  | xxxxxxxxxxxxxxxxxx
 | 2011-12-10 00:00:00 | 2012-01-11 00:00:00 | 2012-02-09 00:00:00 | 2012-04-11 00:00:00 | 2012-05-11 00:00:00 | 2012-06-12 00:00:00 | 2012-07-12 00:00:00 | 2012-08-14 00:00:00 | 2012-09-11 00:00:00 | 2012-10-12 00:00:00 | 2012-11-09 00:00:00 | 2012-12-11 00:00:00 | 2013-01-11 00:00:00 |  | Totals
Starting Balance | 41.83
ADDITIONS
AV Deposits
AV Cash Deposits |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV Cash Deposits
AV ACH Teamsters Pension |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV ACH Qwest Pension Deposits
AV ACH Social Security |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV ACH Social Security Deposits
Total AV Deposits |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV Deposits
AP Deposits
AP Cash Deposits |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AP Cash Deposits
Total AP Deposits |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AP Deposits
SUBTRACTIONS
AV Expenses
AV ACH Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV ACHWithdrawals
AV Check Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV Check Withdrawals
AV Cash Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV Cash Withdrawals
AV Debit Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV Debit Withdrawals
Total AV Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV Withdrawals
AP Expenses
AP Cash Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AP Cash Withdrawals
AP Check Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AP ACH Withdrawals
Total AP Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AP Withdrawals
Account Fees
ATM Fees |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ATM Fees
Total Account Overdraft Fees |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Account Overdraft Fees
Account Balance
Spreadsheet: 477703d1472480745-excel-approval-tracker-logic-school-sub-contract-drawing-tracker
Sheet: SUMMARY

 | Rev A
 | SUMMARY OF SUB-CONTRACTORS DRAWINGS  MARCH 2016
 | Community School
 |  | Nr drawings | Response awaited | C | B | A
SUBCONTRACTOR
 | Steel
 | Precast
 | M&E
 | TOTAL |  |  | 0
Spreadsheet: 787365d1657743660-have-cell-display-item-that-match-three-different-criteria-hymn-planner
Sheet: Upcoming Planner

COPY SECTION ROW 92 DOWN |  |  |  | FOR VISUAL AIDE ONLY - DO NOT COPY
REALATIVE DATE FOR DUPLICATES
Date | Session | Period | TPH# | Title | HoF#
Date | Session | Period | TPH# | Title | HoF# |  | Simply fill in the TPH#
2023-01-01 00:00:00 | First | AM |  |  |  |  | When you copy the data you will copy A through D, do not take title and HoF# those are simply visual aides as you fill in the upcoming weeks
 | Second | AM |  |  |  |  | Copy The sections that you completed, Again A THROUGH D ONLY
 | First | PM |  |  |  |  | You will paste the copied data into the Hymns Log just below the last record
 | Second | PM |  |  |  |  | This will always be into COLUMN E as you will be aligning the date with the previous dates on paste.
 | First | AM |  |  |  |  | The TABLE should wrap around your data once you have pasted
 | Second | AM |  |  |  |  | Paste SPECIAL VALUE AND NUMBER FORMATS
 | First | PM |  |  |  |  |  | The value and number formats will lock in the dates on the LOG sheet while this sheet remains dynamic for FUTURE use "Scheduling"
 | Second | PM
 | First | AM |  |  |  |  | Update the sections on the left to reflect the [NAME] possible sessions/periods that you entertain.
 | Second | AM |  |  |  |  | Filter out on Column D to exclude blanks so that you do not copy over blank rows as that is just a waste of space…
 | First | PM |  |  |  |  | BUT if you do it will not hurt the file in fact it reserves a space for those slots should you need them
 | Second | PM
 | First | AM |  |  |  |  | Remember not to copy E and F from here as when you paste on the other tab it will be a special paste to values removing the formulas
 | Second | AM |  |  |  |  | The Hymns_Log has in it the Title and HoF# and will receive the data as long as it remains in the same 4 column structure.
 | First | PM
 | Second | PM |  |  |  |  | You will need to add special notes and title overrides on the Hymns_Log should they be needed
 | First | AM |  |  |  |  | If you override the date on [NAME] currently, simply update it with this
 | Second | AM |  |  |  |  | =TODAY()+(7-WEEKDAY(TODAY(),1)+1)
 | First | PM |  |  |  |  | This will always find "Next Sunday" all other sections visible should be referencing the previous block date + 7
 | Second | PM
 | First | AM
 | Second | AM
 | First | PM
 | Second | PM
 | First | AM
 | Second | AM
 | First | PM
 | Second | PM
 | First | AM
 | Second | AM
 | First | PM
 | Second | PM
 | First | AM
 | Second | AM
 | First | PM
 | Second | PM
Psalms/Hymns to use next period
 |  |  | 487
 |  |  | 538
 |  |  | 510
 |  |  | 514
 |  |  | 526
 |  |  | 556
 |  |  | 285
 |  |  | 239
 |  |  | 466
 |  |  | 283
 |  |  | 212
 |  |  | 520
 |  |  | 276
 |  |  | 338
 |  |  | 336
 |  |  | 438
 |  |  | 342
 |  |  | 343
Spreadsheet: 118371d1313630342-charting-specific-cell-values-from-multiple-sheets-server-data
Sheet: Jan 2011

Server | Drive | Format | Total | Used | Free | % Free | % Used
Server H | D | NTFS | 38.79 GB | 1.32 GB | 37.47 [NAME] | 96.6 | 3.4
Server C | G | NTFS | 17.25 [NAME] | 1.81 GB | 15.44 GB | 89.48 | 10.52
Server D | C | NTFS | 68.35 GB | 10.11 GB | 58.24 GB | 85.21 | 14.79
Server G | D | NTFS | 19.99 GB | 101.56 MB | 19.89 GB | 99.5 | 0.5
Server F | C | NTFS | 14.99 [NAME] | 11.13 GB | 3.86 GB | 25.74 | 74.26
Server C | D | NTFS | 136.71 GB | 117.62 GB | 19.09 [NAME] | 13.97 | 86.03
Server E | C | NTFS | 19.08 GB | 14.88 [NAME] | 4.20 GB | 22.01 | 77.99
Server B | C | NTFS | 19.77 [NAME] | 15.39 GB | 4.38 GB | 22.16 | 77.84
Server B | H | NTFS | 204.72 GB | 151.61 GB | 53.12 GB | 25.94 | 74.06
Server D | D | NTFS | 136.71 GB | 16.04 GB | 120.67 GB | 88.26 | 11.74
Server F | D | NTFS | 39.99 GB | 2.28 GB | 37.71 GB | 94.29 | 5.71
Server C | E | NTFS | 39.06 GB | 20.00 [NAME] | 19.06 GB | 48.79 | 51.21
Server A | L | NTFS | 99.99 GB | 25.52 [NAME] | 74.47 GB | 74.48 | 25.52
Server D | E | NTFS | 700.00 GB | 581.52 GB | 118.48 GB | 16.93 | 83.07
Server G | C | NTFS | 14.99 [NAME] | 6.32 GB | [NAME] | 57.87 | 42.13
Server A | C | NTFS | 12.00 GB | 6.44 GB | 5.56 [NAME] | 46.32 | 53.68
Server A | H | NTFS | 33.39 GB | 69.86 MB | 33.32 [NAME] | 99.8 | 0.2
Server C | C | NTFS | 12.00 GB | 7.15 GB | 4.85 GB | 40.41 | 59.59
Server A | J | NTFS | 272.45 GB | 74.58 GB | 197.87 GB | 72.63 | 27.37
Server E | M | NTFS | 117.53 GB | 76.65 [NAME] | 40.87 GB | 34.78 | 65.22
Server H | C | NTFS | 29.29 GB | 8.32 GB | 20.97 GB | 71.58 | 28.42
Server A | D | NTFS | 21.86 GB | 883.92 MB | 20.99 [NAME] | 96.05 | 3.95
Server B | G | NTFS | 48.43 GB | 9.95 GB | 38.48 [NAME] | 79.45 | 20.55
Spreadsheet: 675492d1588328047-calculate-which-person-has-2-or-more-x-in-a-row-2-or-more-x-in-row
Sheet: Blad1

 | 2020-04-02 00:00:00 | 2020-04-09 00:00:00 | 2020-04-16 00:00:00 | 2020-04-23 00:00:00 | 2020-04-30 00:00:00 | 2020-05-07 00:00:00 | 2020-05-14 00:00:00 | 2020-05-21 00:00:00 |  |  |  | People with 2 X's in a row | People with 3 X's in a row | People with 4 X's in a row
[NAME] | √ | X | X | X | X
[NAME] | X | √ | X | X | √
Mark | √ | X | X | X | X
Nathalie | X | √ | X | X | X
Spreadsheet: 888407d1738884301-create-summary-by-month-for-data-on-multiple-monthly-sheets-mobsync-cust-info
Sheet: Dec2024

Cust_# | Name | Qty | Total | Maj
9097 | Central | 8 | 340 | YO
9097 | Central | 8 | 380 | YO
9097 | Central | 8 | 457.88 | HK
9097 | Central | 8 | 232.92 | AB
709 | 49 CENTER | 8 | 973.76 | YO
709 | 49 CENTER | 1 | 111.56 | YO
709 | 49 CENTER | 1 | 105.98 | AB
709 | 49 CENTER | 2 | 198 | HK
709 | 49 CENTER | 9 | 581 | HK
Spreadsheet: 874045d1720610468-list-with-people-available-at-specific-date-with-specific-shift-nihilimus-excelforum-21-aligw
Sheet: Blad1

 |  |  |  | [NAME] | Jessica | [NAME] | Hank
2024-12-30 00:00:00 |  |  |  | l | l | l | v
2024-12-31 00:00:00 |  |  |  | l | l | l | v
2025-01-01 00:00:00 |  |  |  | l | l | l | v
2025-01-02 00:00:00 |  |  |  | l | vac | l | v
2025-01-03 00:00:00 |  |  |  | l | vac | l | v
 |  |  |  |  | This is what i want:
date: | 2025-01-02 00:00:00
 | v |  |  | l |  |  | vac
 | [NAME] |  |  | Hank |  |  | Jessica
 | [NAME]
 |  | v | vac
 | [NAME] | Hank | Jessica
 | [NAME]
Spreadsheet: 189689d1351281862-need-to-look-up-a-name-in-one-column-and-return-a-maximum-value-from-the-next-column-formula-question
Sheet: Sheet1

 | Person | Spend |  |  | Person | [NAME]
 | [NAME] | 100 |  |  | [NAME]
 | [NAME] | 30
 | [NAME] | 10 |  |  | [NAME]
 | [NAME] | 5000
 | [NAME] | 50
 | [NAME] | 160
 | [NAME] | 200
 | [NAME] | 175
 | [NAME] | 500
 | [NAME] | 750
 | please help me with a formula that identifies spend by [NAME] from Column C [which contains spend from others] and gives his maximum spend [which is 5000]
Spreadsheet: 865560d1712633055-complicated-sum-function-test-file
Sheet: Sheet1

 |  | Total of | AR
 |  | best six | current
 |  | AR points | RANK | APC |  | State 1 |  | State 2 |  | State 3 |  | State 4 |  | State 5 |  | State 6 |  | June |  | July |  | June |  | June |  | Sept |  | Sept |  | April |  | May
 | Weighting                  No of players/teams |  |  | 1 |  | 0.5 | 6 | 0.5 |  | 0.5 | 7 | 0.5 |  | 0.5 |  | 0.5 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25
Last Name | Full Name |  |  | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts
 |  |  |  |  |  | SmallEvent |  | NO EVENT |  | SmallEvent
Last Name | Full Name |  |  |  | 100 | 1 | 250 |  | 300 |  |  | 200 |  |  | 100 |  | 150 |  | 100 |  | 250 |  | 150 |  | 100 |  | 150
Last Name | Full Name |  |  |  |  |  |  |  |  | 1 | 250
Last Name | Full Name |  |  |  |  | 2 | 200
Last Name | Full Name |  |  |  |  |  |  |  |  | 2 | 200
Last Name | Full Name |  |  |  |  |  |  |  |  | 3 | 150
Last Name | Full Name |  |  |  |  | 3 | 150
Last Name | Full Name |  |  |  |  | 4 | 100
Last Name | Full Name |  |  |  |  |  |  |  |  | 4 | 100
Last Name | Full Name |  |  |  |  |  |  |  |  | 5 | 50
Last Name | Full Name |  |  |  |  | 6 | 50
Last Name | Full Name |  |  |  |  |  |  |  |  | 6 | 50
Last Name | Full Name |  |  |  |  | 5 | 50
Last Name | Full Name |  |  |  |  |  |  |  |  | 7 | 50
Spreadsheet: 832765d1686578422-multiple-column-matches-book-1-rev-1
Sheet: Sheet1

 |  | Duration |  | C1 | C2 | [NAME] |  |  |  |  |  | Duration totals when C1=C4, C2=C5, [NAME]C6 |  | C4 | C5 | C6
 |  | 3 |  | 1 | 2 | 1 |  | If E2 & F2 & G2 match any row O2:Q6 then return K2 |  |  |  |  |  | 1 | 2 | 1 |  | 100
 |  | 6 |  | 2 | 2 | 2 |  | If E3 & F3 & G3 match any row O2:Q6 then return K3 |  |  |  |  |  | 2 | 3 | 1 |  | 150
 |  | 4 |  | 2 | 2 | 5 |  |  |  |  |  |  |  | 2 | 2 | 5 |  | 200
 |  | 5 |  | 3 | 3 | 5 |  |  |  |  |  |  |  | 3 | 3 | 6 |  | 200
 |  | 3 |  | 4 | 2 | 4 |  |  |  |  |  |  |  | 5 | 5 | 2 |  | 100
 |  | 4 |  | 4 | 1 | 4
 |  | 4 |  | 1 | 2 | 1
 |  | 8 |  | 5 | 5 | 2
 |  | 5 |  | 3 | 3 | 1
 |  | 6 |  | 2 | 3 | 1
 |  | 5 |  | 1 | 2 | 1
Spreadsheet: 854884d1704636775-formula-to-solve-if-with-or-condition-and-duplicate-simulasi
Sheet: Sheet2

Given table |  | column helper |  |  |  |  |  | View | yes |  | expected pivot
Name | Facilty | Duplicate Name | View |  | Facilty | View
A | MOTOR A |  |  |  | MOTOR A | NO |  | Row Labels |  |  | view | yes
A | MOBIL A |  |  |  | MOBIL C | NO |  | B
B | MOBIL B |  |  |  | MOBIL A | YES |  | E |  |  | nama
C | MOTOR A |  |  |  | MOBIL B | YES |  | Grand Total |  |  | B
D | MOBIL B |  |  |  | MOTOR B | YES |  |  |  |  | E
D | MOTOR A |  |  |  |  |  |  |  |  |  | H
E | MOTOR B
F | MOTOR A
G | MOBIL C
G | MOTOR B
H | MOTOR B
H | MOBIL A
*1 Name can get several facilities
*Create a pivot, if you have motorbike A, car C then the name does not appear
*For example, if 1 name has motorbike facility A or car C, then it has motorbike facility B, then it will not appear
*If 1 name has several facilities other than motorbike a/car c, it will still be displayed
*1 Nama bisa [NAME] fasilitas
*Buat pivot, jika memiliki motor A, mobil c maka [NAME]
*Contoh jika 1 nama memiliki fasilitas motor a atau mobil c, lalu memiliki fasilitas motor b maka tidak tampil
*Jika 1 nama memiliki beberapa fasilitas diluar motor a/mobil c, tetap ditampilkan
Spreadsheet: 196817d1354116553-webimport-daily-updated-table-with-variable-number-of-objects-sample2
Sheet: OVERVIEW28-11

CARD | CURRENT | DIFFERENCE | 2012-11-27 00:00:00 | 2012-11-26 00:00:00 | 2012-11-25 00:00:00
[NAME] | 2.25 |  | 2.25
Army of the Damned | 2.4 |  | 2.35
[NAME] | 1.45 |  | 1.45
Champion of the Parish | 1.1 |  | 1.15
Clifftop Retreat | 2.55 |  | 2.45
Essence of the Wild | 1.1 |  | 1.1
[NAME] | 19.2 |  | 18.5
Gavony Township | 1.1 |  | 1.05
Geist of Saint Traft | 24.75 |  | 25.5
Grimgrin Corpse-Born | 1.45 |  | 1.4
Grimoire of the Dead | 1.4 |  | 1.35
Hinterland Harbor | 3.1 |  | 3.05
Isolated Chapel | 3.3 |  | 3.35
[NAME] of the Veil | 22.5 |  | 22.25
Mikaeus the Lunarch | 3.6 |  | 4
Mirror-Mad Phantasm | 1 |  | 0.96
[NAME] | 11 |  | 11.1
Past in Flames | 5.5 |  | 5.7
Reaper from the [NAME] | 1.3 |  | 1.25
Runechanter's Pike | 0.78 |  | 0.7
Sever the Bloodline | 0.62 |  | 0.58
Skaab Ruinator | 1.15 |  | 1.2
[NAME] | 6.95 |  | 7.05
Stromkirk Noble | 1.5 |  | 1.65
[NAME] | 3.1 |  | 3.1
Tree of Redemption | 2.15 |  | 2.1
Woodland Cemetery | 2.85 |  | 3.2
Spreadsheet: 797605d1663992506-formula-to-recalculate-lap-times-when-actual-times-vary-from-goal-times-lap-calculator
Sheet: Sheet1

 | Goal laps in 10 hrs | 600
 | 30
 | Lap target required | Actual lap time | New lap target
1 |  | 00:15:00
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Spreadsheet: 115736d1311258792-count-of-rows-that-meet-a-criteria-copy-of-book1-1
Sheet: Sheet1

Store Name | Product 1 | Product 2 | Product 3 | Product 4 | Product 5
Alpha | X |  |  |  | -3
Bravo |  |  | X
[NAME] |  |  | 5 | 5
Delta | 3 | X | X
Echo | 0 | 2
Foxtrot |  |  | -3
Golf |  | 1 |  | 4
Spreadsheet: 3b2bff4e-c737-4fa7-a83d-a98e1aa46870
Sheet: Sheet1

Early and Adequate Prenatal Care by County and Public Health District, Maine, 2008-2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | Live Births for which Mother Received Early and Adequate Prenatal Care*
 |  | Average Annual  Number | %† | 95% CI
Maine Total |  | 11299 | 85.4 | 84.5 - 86.3
County
 | Androscoggin | 1223 | 89.1 | 86.2 - 92.0
 | Aroostook | 585 | 84.8 | 80.9 - 88.9
 | Cumberland | 2300 | 81.5 | 79.6 - 83.5
 | Franklin | 223 | 81.1 | 75.0 - 87.5
 | Hancock | 415 | 87.7 | 82.9 - 92.7
 | Kennebec | 1020 | 84.6 | 81.7 - 87.7
 | Knox | 348 | 90.9 | 85.5 - 96.6
 | Lincoln | 267 | 89.7 | 83.6 - 96.1
 | Oxford | 460 | 87 | 82.5 - 91.7
 | [NAME] | 1357 | 88 | 85.3 - 90.8
 | Piscataquis | 130 | 84 | 75.9 - 92.8
 | Sagadahoc | 332 | 89 | 83.6 - 94.7
 | Somerset | 387 | 78.5 | 74.1 - 83.2
 | [NAME] | 333 | 84.9 | 79.7 - 90.4
 | Washington | 253 | 83.1 | 77.3 - 89.2
 | York | 1664 | 86.7 | 84.3 - 89.1
Public Health District
 | Aroostook | 585 | 84.8 | 80.9 - 88.9
 | Central | 1407 | 82.9 | 80.4 - 85.4
 | Cumberland | 2300 | 81.5 | 79.6 - 83.5
 | Downeast | 668 | 85.9 | 82.2 - 89.7
 | [NAME] | 1280 | 88.6 | 85.8 - 91.4
 | Penquis | 1487 | 87.7 | 85.1 - 90.3
 | Western | 1906 | 87.6 | 85.3 - 89.9
 | York | 1664 | 86.7 | 84.3 - 89.1
* Defined as an adequate or adequate-plus rating on the Kotelchuck Adequacy of Prenatal Care Utilization Index.
† Percents are based on live births with known prenatal care initiation and adequacy.
CI: Confidence Interval.
Note: Group totals might not equal overall total because some births were missing group information. For example, births with missing maternal age were excluded from the maternal age analysis.
County and District numbers are based on the residense of the mother.
Data Source: Birth certificate datasets obtained from the Office of Data, Research and Vital Statistics, Maine Center for Disease Control and Prevention.
Spreadsheet: 203701d1357227366-link-data-in-worksheets-add-deduct-formulas-as-criteria-are-arent-met-attendance-template-excel
Sheet: June

Employee Absence Schedule
June | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | CI | T | NCNS | Total Points
Employee 1
Employee 2
Employee 3
Employee 4
Employee 5
Spreadsheet: 155209d1336724416-combining-two-functions-weekly-backlog-report-20120424-test-
Sheet: Raw Data

TRACKING_ID | CREATED_DATE | SHORT_DESCRIPTION | ASSIGNED_TO | EXPECTED_RESOLUTION_DATE | ACTUAL_DATE | SEVERITY | TYPE | RESOLUTION_DATE | STATUS | SUB_STATUS | SUBTYPE | SUBQUEUE | DIFF | ACTUAL RES DATE | MONTH CREATED | TEAM | [NAME] | MONTH CLOSED | EXP_RES_DATE | Calc | Met SLA | Sev3 (-2) | PH Singapore | PH Malaysia | PH Taiwan | PH China | PH Israel | PH Germany | PH USA
 | 01-MAR-12 | [NAME] | DummyApp | 01-MAR-12 | 04-MAR-12 | Severity 1 | Helpdesk | 04-MAR-12 | Resolved | Closed | Duplicate |  |  |  |  |  | Singapore
 | 01-MAR-12 | [NAME] | DummyGov | 01-MAR-12 | 04-MAR-12 | Severity 1 | Helpdesk | 04-MAR-12 | Resolved | Closed | Duplicate |  |  |  |  |  |  |  |  |  |  | 0
 | 01-APR-12 | [NAME] | DummyApp | 01-APR-12 | 04-APR-12 | Severity 1 | Helpdesk | 04-APR-12 | Resolved | Closed | Duplicate |  |  |  |  |  |  |  |  |  |  | 0
WO# 10021 | 01-JUL-11 | Test 1-July - Process not starting | [NAME] , Anand | 05-JUL-11 | 03-OCT-11 | Severity 3 | Helpdesk | 01-JUL-11 | Resolved | Closed | Information
WO# 12088 | 02-JUL-11 | oracle  password locked | [NAME] , Thiruchelvam a/l | 07-JUL-11 | 02-JUL-11 | Severity 3 | [NAME] | 02-JUL-11 | Resolved | Closed | Oracle |  |  |  |  |  | Malaysia
WO# 12091 | 02-JUL-11 | Your Oracle Account | Vyveganathan , [NAME] a/l | 07-JUL-11 | 02-JUL-11 | Severity 3 | [NAME] | 02-JUL-11 | Resolved | Closed | Oracle |  |  |  |  |  | Malaysia
WO# 12137 | 02-JUL-11 | BB0 - URGENT for Mth-end Closing | Arumugam , [NAME] | 07-JUL-11 | 12-JUL-11 | Severity 3 | Oracle | 12-JUL-11 | Resolved | Closed | [NAME] (Costing)
WO# 12305 | 03-JUL-11 | Cannot Log on via VPN nor to owa.kns.com | Ng , [NAME] | 08-JUL-11 | 03-JUL-11 | Severity 3 | [NAME] | 03-JUL-11 | Resolved | Closed | Network/Cognos/Portal/TWIKI |  |  |  |  |  | Malaysia
WO# 12309 | 03-JUL-11 | HRIS report - 02 July 2011 | Ng , Yohan | 08-JUL-11 | 12-JUL-11 | Severity 3 | Helpdesk | 12-JUL-11 | Resolved | Closed | HRIS |  |  |  |  |  | Malaysia