tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 34947d1232399649-average-lookup-average-20lookup-1-
Sheet: Sheet2

 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00
Enter customer here | average days open for the above month
A | 0 | 5 | 0 | 4 | 0 | 0 | 2 | 0 | 0 | 2 | 6 | 0
B | 0 | 3 | 0 | 0 | 0 | 9 | 0 | 12 | 0 | 0 | 0 | 4
C | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 701936d1603992935-sumproduct-with-multiple-criteria-and-slicers-incident-tracker-test-
Sheet: Hours Worked

FY21
 | Wks in Pd | Total Headcount | Salaried Headcount | Salaried Hours | Regular Hours | Overtime Hours | Total Hours | ORIs
JUL | 4 | 99 | 57 |  | 5655.579999999998 | 274.16
AUG | 4 | 99 | 57 |  | 5662.78 | 23.71 |  | 1
SEP | 5 | 99 | 57 |  | 7280.17 | 54.84
OCT | 4 | 99 | 57 |  | 6103.49 | 55.27
NOV | 4
DEC | 5
JAN | 4
FEB | 4
MAR | 5
APR | 4
MAY | 4
JUN | 5
 | Ave. |  |  |  |  | Total Hours
 | Heacount
Spreadsheet: 778520d1651137275-formula-to-split-totals-depending-on-the-number-of-days-in-a-month-book1
Sheet: Sheet1

Date | Sales Target
2022-01-01 00:00:00 |  |  |  |  | January | 160
2022-01-02 00:00:00
2022-01-03 00:00:00
2022-01-04 00:00:00
2022-01-05 00:00:00 | 10
2022-01-06 00:00:00 | 10
2022-01-07 00:00:00 | 10
2022-01-08 00:00:00 | 10
2022-01-09 00:00:00 | 10
2022-01-10 00:00:00 | 10
2022-01-11 00:00:00 | 10
2022-01-12 00:00:00 | 10
2022-01-13 00:00:00 | 10
2022-01-14 00:00:00 | 10
2022-01-15 00:00:00 | 10
2022-01-16 00:00:00 | 10
2022-01-17 00:00:00 | 10
2022-01-18 00:00:00 | 10
2022-01-19 00:00:00 | 10
2022-01-20 00:00:00 | 10
Spreadsheet: 51879d1251468980-locking-cell-data-from-different-sheets-linking-test
Sheet: Sheet1

Date | Week |  |  | Overtime
2009-08-24 00:00:00 | 35 |  |  | 8
2009-08-31 00:00:00 | 36
2009-09-07 00:00:00 | 37
2009-09-14 00:00:00 | 38
2009-09-21 00:00:00 | 39
2009-09-28 00:00:00 | 40
2009-10-05 00:00:00 | 41
2009-10-12 00:00:00 | 42
Spreadsheet: 95352d1294945651-excel-2007-transposing-data-from-column-cells-into-row-cells-line-instr
Sheet: CUSTOMER RETURN INSTRUCTION

Return ID | Return Date | Customer | Name | Instruction Sequence | Instruction Line
40616 | 2011-01-12 00:00:00 | C905723 | ABC CORP. | 1 | QTY 24 OF ITEM 24005 - RETURNED
40616 | 2011-01-12 00:00:00 | C905723 | ABC CORP. | 2 | QTY 24 OF ITEM 24004 - RETURNED
40616 | 2011-01-12 00:00:00 | C905723 | ABC CORP. | 3 | QTY 3 OF ITEM 24435 - DAMAGED
40616 | 2011-01-12 00:00:00 | C905723 | ABC CORP. | 4 | QTY 1 OF ITEM 24411 - DAMAGED
40615 | 2011-01-12 00:00:00 | 269501 | DEF CORP. | 1 | QTY 1 OF ITEM 24604 - DAMAGED
40615 | 2011-01-12 00:00:00 | 269501 | DEF CORP. | 2 | QTY 1 OF ITEM 24411 - DAMAGED
40613 | 2011-01-12 00:00:00 | 269500 | GHI CORP. | 1 | QTY 1 OF ITEM 26008 - SHORT
40612 | 2011-01-12 00:00:00 | 103000 | JKL CORP. | 1 | QTY 1 OF ITEM 24604 - DAMAGED
40612 | 2011-01-12 00:00:00 | 103000 | JKL CORP. | 2 | QTY 1 OF ITEM 24411 - DAMAGED
40611 | 2011-01-12 00:00:00 | 105957 | MNO CORP. | 1 | QTY 1 OF ITEM 24411 - DAMAGED
40610 | 2011-01-12 00:00:00 | 487600 | PQR CORP. | 1 | QTY 24 OF ITEM 24004 - RETURNED
Return ID | Return Date | Customer | Name | Instruction Sequence | Instruction Line1 | Instruction Line2 | Instruction Line3 | Instruction Line4
40616 | 2011-01-12 00:00:00 | C905723 | ABC CORP. | 1 | QTY 24 OF ITEM 24005 - RETURNED | QTY 24 OF ITEM 24004 - RETURNED | QTY 3 OF ITEM 24435 - DAMAGED | QTY 1 OF ITEM 24411 - DAMAGED
40615 | 2011-01-12 00:00:00 | 269501 | DEF CORP. | 1 | QTY 1 OF ITEM 24604 - DAMAGED | QTY 1 OF ITEM 24411 - DAMAGED
40613 | 2011-01-12 00:00:00 | 269500 | GHI CORP. | 1 | QTY 1 OF ITEM 26008 - SHORT
40612 | 2011-01-12 00:00:00 | 105957 | MNO CORP. | 1 | QTY 1 OF ITEM 24604 - DAMAGED | QTY 1 OF ITEM 24411 - DAMAGED
40611 | 2011-01-12 00:00:00 | 487600 | PQR CORP. | 1 | QTY 1 OF ITEM 24411 - DAMAGED
40610 | 2011-01-12 00:00:00 | 487600 | PQR CORP. | 1 | QTY 24 OF ITEM 24004 - RETURNED
Spreadsheet: 846599d1697745191-multiple-search-criteria-excelent
Sheet: blad x

 |  | START DATE | WORK ORDER # | TURN | PACKING # | VARIETY | REQUESTED BY | ASSIGNED TO | % COMPLETE | QUANTITY | ACTUAL MADE | STATUS | Week
 |  | 2023-10-19 00:00:00 |  | 01 |  | Product 1 | [NAME] | [NAME] |  | 3000
 |  | 2023-10-18 00:00:00 |  | 02 |  | Product 2 | [NAME] | Fred |  | 1000
 |  | 2023-10-18 00:00:00 |  | 01 |  | Product 3 | [NAME] | [NAME] |  | 3000
 |  | 2023-10-17 00:00:00 |  | 02 |  | Product 4 | [NAME] | [NAME] |  | 2500
 |  | 2023-10-17 00:00:00 |  | 01 |  | Product 1 | [NAME] | [NAME] |  | 2000
 |  | 2023-10-16 00:00:00 |  | 03 |  | Product 3 | [NAME] | Fred |  | 1500
 |  | 2023-10-16 00:00:00 |  | 02 |  | Product 2 | [NAME] | [NAME] |  | 1500
 |  | 2023-10-16 00:00:00 |  | 01 |  | Product 3 | [NAME] | [NAME] |  | 1500
Spreadsheet: 300913d1393602164-insert-value-according-to-month-and-date-value-manpower
Sheet: Day

DAILY MANPOWER REPORT
Month | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
Days | SAPL | AJC | SAPL | AJC | SAPL | AJC | SAPL | AJC | SAPL | AJC | SAPL | AJC | SAPL | AJC | SAPL | AJC | SAPL | AJC | SAPL | AJC | SAPL | AJC | SAPL | AJC
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
31
Spreadsheet: 779093d1651585352-need-2-net-and-2-gross-golf-scores-added-together-without-using-same-user-for-both-golf-league-example
Sheet: Sheet1

Date: | 2022-04-27 00:00:00
Side: | Front
Par: | 36
 |  |  | Team
 |  |  |  | H | Gross | + / - Par | Net | + / - Par
 |  |  | Player 1 | 1 | 99
 |  |  | Player 2 | 1 | 42
 |  |  | Player 3 | 4 | 49
 |  |  | Player 4 | 5 | 48
 |  |  | Player 5 | 8 | 45
 |  |  | Player 6 | 8 | 46
 |  |  | Team score
Spreadsheet: 269697d1381250037-multiple-logic-functions-in-one-cell-wip-calculator
Sheet: Accounting GJE

If you are entering WIP adjustments into your accounting software:
Enter the Journal Entry ONLY.
Remember the Balance Sheet is the keeper of the WIP total on your report.
Period 1 | January |  | Jan 31 Journal Entry
 |  |  |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
 |  |  | Resulting Balance Sheet Account Total
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
Period 2 | February |  | Feb 28 Journal Entry
 |  |  |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
 |  |  | Resulting Balance Sheet Account Total
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
Period 3 | March |  | Mar 31 Journal Entry
 |  |  |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
 |  |  | Resulting Balance Sheet Account Total
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
Period 4 | April |  | Feb 28 Journal Entry
 |  |  |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
 |  |  | Resulting Balance Sheet Account Total
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
Period 5 | May |  | Feb 28 Journal Entry
 |  |  |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
 |  |  | Resulting Balance Sheet Account Total
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
Period 6 | June |  | Feb 28 Journal Entry
 |  |  |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
 |  |  | Balance Sheet Account Total
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
Period 7 | July |  | Feb 28 Journal Entry
 |  |  |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
 |  |  | Balance Sheet Account Total
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
Period 8 | August |  | Feb 28 Journal Entry
 |  |  |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
 |  |  | Balance Sheet Account Total
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
Period 9 | September |  | Feb 28 Journal Entry
 |  |  |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
 |  |  | Balance Sheet Account Total
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
Period 10 | October |  | Feb 28 Journal Entry
 |  |  |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
 |  |  | Balance Sheet Account Total
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
Period 11 | November |  | Feb 28 Journal Entry
 |  |  |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
 |  |  | Balance Sheet Account Total
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
Period 12 | December |  | Feb 28 Journal Entry
 |  |  |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
 |  |  | Balance Sheet Account Total
 |  |  | WIP Asset Acct
 |  |  | WIP Liability Acct
Spreadsheet: larry_campbell__20992__PCB Graphs
Sheet: 84.10A

Sample location |  |  | Date collected |  |  | PCB result (ppm) |  | Lab
PGE Mile pt. |  |  | 2000-03-22 00:00:00 |  |  | 21 |  | Sherwood
84.10 A Side |  |  | 2000-07-05 00:00:00 |  |  | 21 |  | Sherwood
 |  |  | 2000-08-09 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-08-23 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-09-06 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-10-04 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-10-18 00:00:00 |  |  | 14 |  | Sherwood
 |  |  | 2001-01-10 00:00:00 |  |  | 13 |  | Sherwood
0 data values = ND or  less than a detection limit of 1ppm
Spreadsheet: 124595d1318491904-excel-2007-dropdown-list-bankroll180mansnumber-2-1-
Sheet: Main

 | Game | Bankroll management
 | 180 man
 | Stake |  | Bankroll needed $250 - $500 |  | Games played |  | Invested |  | Win/loss |  | ROI
 | 2.5 |  | Turbo
 | 0.1 |  | of investment paid as wage |  | ----------------------->
 | Stake |  | Bankroll needed $450 - $900 |  | Games played |  | Invested |  | Win/loss |  | ROI
 | 4.5 |  | Normal speed
 | 0.1 |  | of investment paid as wage |  | ----------------------->
 | Stake |  | Bankroll needed $800 - $1600 |  | Games played |  | Invested |  | Win/loss |  | ROI
 | 8 |  | Turbo
 | 0.08 |  | of investment paid as wage |  | ----------------------->
 | Stake |  | Bankroll needed $1500 - $3000 |  | Games played |  | Invested |  | Win/loss |  | ROI
 | 15 |  | Turbo
 | 0.07 |  | of investment paid as wage |  | ----------------------->
 | Stake |  | Bankroll needed $3500 - $7000 |  | Games played |  | Invested |  | Win/loss |  | ROI
 | 35 |  | Turbo
 | 0.05 |  | of investment paid as wage |  | ----------------------->
 |  |  |  |  |  |  | Total invested |  | Total win/loss |  | Total ROI
 |  |  |  |  |  |  | Total net profit/loss - wage paid |  |  |  | Bankroll
 |  |  |  |  |  |  | Total Wage
Spreadsheet: 866974d1713881819-how-to-move-data-from-one-cell-to-a-variety-of-other-cells-indirect-addressing-sample-rf1
Sheet: Sheet1

 | Air Velocity |  | CFM |  | Reflux | 21 | in^4
 |  |  |  |  | Density | 1.2
 | Case | 6 |  |  | Elevation | 300 | FT
 |  |  |  |  | X | 1.4 | in
 |  |  |  |  | y | 0.01 | in
 | Case 1 |  | CFM |  | Air Velocity |  | CFM
 | Case 2 |  | CFM
 | Case 3 |  | CFM
 | Case 4 |  | CFM
 | Case 5 |  | CFM
 | Case 6 |  | CFM
 | Case 7 |  | CFM
 | Case 8 |  | CFM
 | Case 9 |  | CFM
 | Case 10 |  | CFM
Spreadsheet: 682731d1592305686-count-if-value-is-fail-and-there-are-over-10-recorded-values-within-30-days-range-countifexample
Sheet: Sheet1

Date | Outcome | Expected Count Result |  | If there is more than 10 fails in the last 30 days of the specific date then count this as 1, if there is less than count this is a 0
2020-03-01 00:00:00 | Fail | 0
 | Fail | 0
 | Pass | 0
 | Fail | 0
 | Fail | 0
 | Fail | 0
 | Fail | 0
 | Fail | 0
 | Fail | 0
 | Fail | 0
 | Fail | 0
 | Pass | 0
 | Fail | 1
 | Fail | 1
 | Fail | 1
 | Fail | 1
2020-10-17 00:00:00 | Pass | 0
 | Fail | 0
 | Fail | 0
 | Fail | 0
 | Fail | 0
 | Pass | 0
 | Fail | 0
 | Fail | 0
 | Fail | 0
 | Fail | 0
 | Fail | 0
 | Fail | 1
 | Fail | 1
 | Fail | 1
 | Fail | 1
 | Fail | 1
 | Pass | 0
 | Fail | 1
 | Fail | 1
 | Fail | 1
 | Fail | 1
 | Fail | 1
 | Fail | 1
 | Fail | 1
Spreadsheet: 47851d1247019885-excel-2007-need-help-with-wages-form-timesheet-icelandic
Sheet: Holidays

Mánuður | Holidays
2009-01-01 00:00:00 | 2009-01-01 00:00:00 | New Years
2009-02-01 00:00:00 | 2009-04-05 00:00:00 | Palm Sunday
2009-03-01 00:00:00 | 2009-04-10 00:00:00 | Good Friday
2009-04-01 00:00:00 | 2009-04-12 00:00:00 | Easter Sunday
2009-05-01 00:00:00 | 2009-12-24 00:00:00 | Christmas Eve
2009-06-01 00:00:00 | 2009-12-25 00:00:00 | Christmas Day
2009-07-01 00:00:00 | 2009-12-31 00:00:00 | New Years Eve
2009-08-01 00:00:00
2009-09-01 00:00:00
2009-10-01 00:00:00
2009-11-01 00:00:00
2009-12-01 00:00:00
Spreadsheet: 688266d1595675489-not-counting-cells-when-empty-eg
Sheet: January_2020

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total on pathway in month
 | Trust: |  |  |  |  |  |  |  |  | Enter number of women booked here: |  |  |  |  | Key |  |  |  |  | Total transferred off pathway
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total tx after booking (incl >=29.0wk
 | Team Name: |  |  | Willow |  |  |  |  |  | Total Women Booked in Month |  |  |  |  | COC | Continuity of Care |  |  |  | Total exclusions >29.0w
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AN | Antenatal |  |  |  | Total placed on at booking
 | Team Members/Buddy Midwife: |  |  |  |  |  |  |  |  |  |  |  |  |  | LD | Labour and [NAME] |  |  |  | Total tx after booking <29.1w
 |  |  |  |  |  |  |  |  |  | Point Prevalence |  |  |  |  | PN | Postnatal |  |  |  | Sum of Gestation - CoC offered at booking
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Sum of Gestation - Tranferred in after booking
 | Data Collection Period: |  |  | January_2020 |  |  |  |  |  |  |  |  |  |  |  | Calculated by formula |  |  |  | Average Gestation - CoC Offered at booking
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average Gestation - Transferred in after booking
Please do not enter anything into the GREY cells
Booking Details |  |  |  |  |  |  | Number of Contacts |  |  |  | Labour and Delivery Details |  |  |  |  |  |  |  |  | Number of Postnatal Contacts
 | Hospital No/Local ID ** NOT NHS NUMBER ** |  |  |  |  |  | Enter number |  |  | Total % of AN Contact Provided by COC Team | Clickon the cell then click on the Arrow to open the [NAME] down list: |  |  |  |  |  |  |  | Labour or Delivery by COC Team | Enter number
Case |  | Lead Midwife | EDD | COC Offered Gestation Weeks.days | At Booking  Gestation Weeks.days | COC on Booking | Total Provided/ Expected | With Lead Midwife | With Buddy/ Team MW |  | Labour care provided by | Pain Relief (highest) | Birth attended by | Type of Birth | Place of birth | Gestation (Weeks)  At Birth | [NAME] | Perineal Outcome |  | Total Provided/ Expected | With Lead Midwife | With Buddy/ Team MW | % of PN Contact  by COC Team
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
Spreadsheet: 273af17d-ba22-4ae1-a66f-fbab29ec9914
Sheet: Sheet1

Older Students Who Ate Fruits and Vegetables Five or More Times Per Day, by Selected Demographics, Maine, 2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  | High School |  |  |  | Middle School
 |  | weighted number |  | % | 95% CI | weighted number |  | % | 95% CI
Total |  | 8796 |  | 16.5 | 15.8 - 17.2 | 4915 |  | 19.5 | 18.4 - 20.5
Gender
 | Male | 4430 |  | 16.7 | 15.9 - 17.5 | 2487 |  | 19.7 | 18.6 - 20.7
 | Female | 4254 |  | 16.3 | 15.5 - 17.1 | 2370 |  | 19.2 | 17.9 - 20.6
Race **
 | American Indian or [NAME] | 103 |  | 18.7 | 16.0 - 21.5 | 88 |  | 22 | 18.7- 25.3
 | Asian | 116 |  | 19.2 | 15.9 - 22.6 | 44 |  | 26.6 | 21.8 - 31.3
 | Black or African American | 107 |  | 17.7 | 15.3 - 20.0 | 48 |  | 24.3 | 19.6 - 28.9
 | Hispanic | 225 |  | 21.2 | 18.7 - 23.6 | 94 |  | 23.3 | 19.9 - 26.7
 | Native Hawaiian or Other Pacific Islander | 23 |  | 19.4 | 13.6 - 25.3 | 7 |  | 21.4 | 12.1 - 30.7
 | White | 7588 |  | 16.2 | 15.5 - 16.9 | 4061 |  | 19.1 | 18.0 - 20.2
 | Multiple races | 115 |  | 17 | 14.4 - 19.6 | 89 |  | 21.1 | 18.1 - 24.0
Sexual Orientation
 | Heterosexual | 7883 |  | 16.4 | 15.7 - 17.1
 | Gay/Lesbian | 128 |  | 15.8 | 12.2 - 19.3
 | Bisexual | 336 |  | 15.2 | 13.5 - 16.9
 | Not Sure | 286 |  | 19 | 16.4 - 21.7
Data Source:  Maine Integrated Youth Health Survey. Middle school includes 7th and 8th grades. Based on respondents' report of the past seven days, includes 100% fruit juice. All percentages are weighted to be more representative of the population of Maine students and to adjust for non-response. 95% CI = 95% Confidence Interval. NA = not available.  Sexual Orientation question was not asked on the middle school survey. ** All racial categories are non-hispanic except for "Hispanic."
Spreadsheet: 31233d1227036096-sumproduct-to-find-text-xlforum-662656-sumproduct-to-find-text
Sheet: Sheet2

Sales Rep | Application Value | [NAME] | MPPI | HC
[NAME] | 250 |  | BA | BA
[NAME] | 100 | 2008-09-01 00:00:00 | TA | TA
[NAME] | 600 | 2008-09-05 00:00:00 |  | JA
[NAME] | 520 | 2008-09-06 00:00:00
[NAME] | 120 |  | MA | MA
[NAME] A | 328 | 2008-09-09 00:00:00 | SA
[NAME] | 300 | 2008-09-08 00:00:00 |  | BA
[NAME] | 278 | cancelled
[NAME] | 956 | cancelled | JA
[NAME] | 756 | cancelled |  | MA
[NAME] | 300 | 2008-09-01 00:00:00 | TA
[NAME] | 520 | 2008-09-24 00:00:00 |  | TA
[NAME] | 100 | 2008-09-23 00:00:00 | BA
[NAME] | 500 | 2008-09-25 00:00:00 | BA
[NAME] | 63 | cancelled | TA | TA
 |  |  |  |  |  | Advisor | [NAME] | [NAME] received with dates | Apps outstanding | Value of apps | MPPI | HC | [NAME]
 |  |  |  |  |  | [NAME] | 4 | 3 | 1 | 1150 | 2 | 1 | 0
 |  |  |  |  |  | [NAME] | 3 | 1 | 0 | 1834 | 2 | 1 | 2
 |  |  |  |  |  | [NAME] | 2 | 0 | 1 | 876 | 2 | 1 | 1
 |  |  |  |  |  | [NAME] A | 1 | 1 | 0 | 328 | 2 | 1 | 0
 |  |  |  |  |  | [NAME] | 5 | 4 | 0 | 1503 | 2 | 1 | 1
Spreadsheet: 67582d1268159900-adding-value-of-cells-but-cell-determined-by-dropdown-list-test-1
Sheet: Stats

Start Date: | February
End Date: | April
Total Orders | Name
 | Book 1
 | Book 2
 | Book 3
 | Book 4
 | Book 5
 | Book 6
 | Book 7
 | Book 8
 | Book 9
 | Book 10
 | Book 11
 | Book 12
 | Book 13
 | Book 14
 | Book 15
 | Book 16
 | Book 17
 | Book 18
 | Book 19
 | Book 20
Spreadsheet: 582580d1531945785-how-do-i-create-a-sheet-that-looks-at-2017-and-compares-with-2018-excel-problem
Sheet: Data Before

2017 Company | 2017 Spend | 2018 Company | 2018 Spend
Company 1 | 50 | Company 1 | 40
Company 2 | 0 | Company 21 | 20
Company 3 | 10 | Company 3 | 10
Company 3 | 10 | Company 3 | 10
Company 3 | 10 | Company 41 | 60
Company 4 | 20 | Company 5 | 10
Spreadsheet: 197895d1354600613-remove-to-a-new-sheet-duplicate-rows-spuros
Sheet: Master

date | demo | [NAME] | contract | comments | [NAME] | demo4 | demo5 | demo6 | demo7 | demo8 | demo9 | demo10
2012-12-01 00:00:00 | [NAME] | [NAME] | 121 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-02 00:00:00 | [NAME] | [NAME] | 122 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-03 00:00:00 | [NAME] | [NAME] | 125 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-04 00:00:00 | [NAME] | [NAME] | 128 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-05 00:00:00 | [NAME] | [NAME] | 122 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-06 00:00:00 | [NAME] | [NAME] | 130 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-07 00:00:00 | [NAME] | [NAME] | 135 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-08 00:00:00 | [NAME] | [NAME] | 139 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-09 00:00:00 | [NAME] | [NAME] | 147 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-10 00:00:00 | [NAME] | [NAME] | 135 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-11 00:00:00 | [NAME] | [NAME] | 220 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-12 00:00:00 | [NAME] | [NAME] | 225 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-13 00:00:00 | [NAME] | [NAME] | 226 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-14 00:00:00 | [NAME] | [NAME] | 289 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-15 00:00:00 | [NAME] | [NAME] | 299 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]