tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 5d78cfff-20c1-4087-b34a-a1204c4f01c9
Sheet: Sheet1

Health Insurance Coverage* by Year, Maine, 2008-2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Year | Does Not Currently Have Health Insurance Coverage
 | Single Year Estimated n | % | 90% Margin of Error
2008 | 135326 | 10.4145150292674
2009 | 137,004 | 10.5 | ±0.5
2010 | 133,065 | 10.1 | ±0.5
NA = Not Available.
* Among the civilian noninstitutionalized population.
All %s are weighted to be more representative of the population of Maine and to adjust for non-response.
Data before 2008 are not presented due to differences in U.S. Census Bureau data editing procedures.
Data Source:  U.S. Census Bureau, American Community Survey.  Re-run 2008 1-Year American Fact Finder Data Products:  ACS Health Insurance Coverage (http://www.census.gov/hhes/www/hlthins/data/acs/2008/rerun-tables/ns-B27001-08.xls, accessed 4/12/12) and data query from the American FactFinder:  Table S2701 (http://factfinder2.census.gov/faces/nav/jsf/pages/wc_acs.xhtml, accessed 4/11/12).
Spreadsheet: 77790d1278277788-which-lookup-tool-to-return-multiple-pieces-of-info-from-multiple-cells-help-needed
Sheet: Data

 | Tutor | Student Name | Course | Date Started | Current Status |  | tutors
 | Tutor 1 | Student 1 | Maths | 2010-01-01 00:00:00 | Still On Course | 1 | Tutor 1
 | Tutor 1 | Student 2 | English | 2010-01-01 00:00:00 | WITHDRAWN | 2 | Tutor 2
 | Tutor 1 | Student 3 | Science | 2010-01-01 00:00:00 | OVERDUE | 3 | Tutor 3
 | Tutor 1 | Student 4 | Maths | 2010-01-01 00:00:00 | Still On Course | 4 | Tutor 4
 | Tutor 1 | Student 5 | English | 2010-01-01 00:00:00 | WITHDRAWN | 5 | Tutor 5
 | Tutor 1 | Student 6 | Science | 2010-01-01 00:00:00 | OVERDUE | 6 | Tutor 6
 | Tutor 1 | Student 7 | Maths | 2010-01-01 00:00:00 | Still On Course | 7 | Tutor 7
 | Tutor 1 | Student 8 | English | Did Not Start | Did Not Start | 8 | Tutor 8
 | Tutor 2 | Student 9 | Science | 2010-01-02 00:00:00 | OVERDUE | 9 | Tutor 9
 | Tutor 2 | Student 10 | Maths | 2010-01-02 00:00:00 | Still On Course | 10 | Tutor 10
 | Tutor 2 | Student 11 | English | 2010-01-02 00:00:00 | WITHDRAWN | 11 | Tutor 11
 | Tutor 3 | Student 12 | Science | 2010-01-02 00:00:00 | OVERDUE | 12 | Tutor 12
 | Tutor 4 | Student 13 | Maths | 2010-01-02 00:00:00 | Still On Course | 13 | Tutor 13
 | Tutor 4 | Student 14 | English | 2010-01-02 00:00:00 | WITHDRAWN | 14
 | Tutor 4 | Student 15 | Science | 2010-01-02 00:00:00 | OVERDUE | 15
 | Tutor 4 | Student 16 | Maths | 2010-01-02 00:00:00 | Still On Course | 16
 | Tutor 4 | Student 17 | English | Did Not Start | Did Not Start | 17
 | Tutor 5 | Student 18 | Science | 2010-01-02 00:00:00 | OVERDUE | 18
 | Tutor 5 | Student 19 | Maths | 2010-01-02 00:00:00 | Still On Course | 19
 |  |  |  |  |  | 20
Spreadsheet: 844392d1696158329-problem-with-numbers-844388d1696154345-prolem-with-numbers-and-92
Sheet: ΦΑΙΔΡΑ

ΦΑΙΔΡΑ
 |  |  |  |  |  |  |  |  |  |  |  | KEAO |  |  | KEAO
 |  | [NAME] | ΠΕΔΙΟ 1 | ΠΕΔΙΟ 2 | ΠΕΔΙΟ 3 | ΠΟΣΟ | ΠΑΡΑΤΗΡΗΣΕΙΣ
Α.Φ.Μ. 081991914 |  | ΚΕΑΟ |  |  |  | 634.45 |  | ΗΜΕΡΟΜΗΝΙΕΣ [NAME] | 2023-08-25 00:00:00 | 634.45 |  | ΗΜΕΡΟΜΗΝΙΑ | ΠΟΣΟ |  | ΗΜΕΡΟΜΗΝΙΑ | ΠΟΣΟ
 |  | ΚΕΑΟ | Κ  12009415666142822027 |  |  | 57.21 |  |  |  |  |  | 2023-08-25 00:00:00 | 634.45 |  | 2023-09-29 00:00:00 | 57,21€  + 60,07 € + 160,29 €
Spreadsheet: 494485d1482417756-past-2-months-values-calculation-sample-data
Sheet: Sheet1

 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 5
 |  | Products | Current Month (Sales Quantity-Month to date) |  | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | YTD Total (Till Last Month) | YTD Average (Till Last Month) |  | Average Sales  2015-16 | Average Sales  2016-17
 |  | A | 755 |  | 9815 | 49075 | 151 | 3020 | 4907.5 |  |  |  |  |  |  |  |  |  |  | 16643.7
 |  | B | 510 |  | 6630 | 33150 | 102 | 2040 | 3315 |  |  |  |  |  |  |  |  |  |  | 12297.4
 |  | C | 654 |  | 8502 | 42510 | 130.8 | 2616 | 4251 |  |  |  |  |  |  |  |  |  |  | 14851.96
 |  | D | 123 |  | 1599 | 7995 | 24.6 | 492 | 799.5 |  |  |  |  |  |  |  |  |  |  | 3432.02
 |  | E | 51 |  | 663 | 3315 | 10.2 | 204 | 331.5 |  |  |  |  |  |  |  |  |  |  | 1054.74
 |  | F | 516 |  | 6708 | 33540 | 103.2 | 2064 | 3354 |  |  |  |  |  |  |  |  |  |  | 10403.84
 |  | G | 3232 |  | 42016 | 210080 | 646.4 | 12928 | 21008 |  |  |  |  |  |  |  |  |  |  | 60585.68000000001
 |  | H | 1223 |  | 15899 | 79495 | 244.6 | 4892 | 7949.5 |  |  |  |  |  |  |  |  |  |  | 24946.02
 |  | I | 2323 |  | 30199 | 150995 | 464.6 | 9292 | 15099.5 |  |  |  |  |  |  |  |  |  |  | 44460.02
 |  | J | 13330 |  | 4797 | 23985 | 73.80000000000001 | 1476 | 2398.5 |  |  |  |  |  |  |  |  |  |  | 9796.06
 |  | Total
 |  | Notes
 | 1 | Column D Values are updated on daily basis from another sheet which extracts data from Company's ERP
 | 2 | At the end of each month by manually inserting the number in Cell R4, total and Average of YTD sales are calculated in Columns R and S for each Product.
 | 3 | In Col U average sales for each products are entered manually for FY 2015-16
 |  | Desired Output
 | 1 | At the end of Dec'16 values of Col K are placed at same place as values and current formula which is linked with Col D is copied to Col L (Jan-17)
 | 2 | Cell R4 Value is automatically turns to 6 to calculate Total and Average for 6 months i.e Jul-Dec 2016 like wise for next months at the end of each month
 | 3 | At the end of Jun2017, Cell value [NAME] to 12 to calculate total and average for 12 months i.e. Jul'16-Jun'17 and yearly average calculated in Col S copies in Col V as values.
 | 4 | This will continue for subsequent years.
Spreadsheet: 849860d1700232597-how-can-i-make-it-more-impressive-stoke-bay_yard-status
Sheet: Dashboard

 | FENCE
 | 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
 | BAYS
 | 25 |  |  | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 |  |  |  |  |  |  |  |  | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Empty Trailers |  |  |  | Equipment Trailers |  |  |  | Westbridge Trailers |  |  |  |  | Outbound Loads to Collect
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Empty Double Deckers |  |  |  | Equipment Deckers |  |  |  | V.O.R. Trailers |  |  |  |  | Double Drop to Collect
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Empty Containers |  |  |  | Inbound Containers |  |  |  | Trailers Not For Stoke |  |  |  |  | Other
Spreadsheet: 137407-excel-2007-completing-a-form-automatically-based-on-several-inputs-and-conditions-rma-testing-form
Sheet: Sheet3

TL-WR941ND |  | TL-WR941ND |  | 845973054038 |  | TL-WR740N
TL-WR940N |  | TL-WR940N |  | 845973054038 |  | TL-WR740N
TL-WR842ND |  | TL-WR842ND |  | 845973054038 |  | TL-WR740N
TL-WR2543ND |  | TL-WR2543ND |  | 845973054038 |  | TL-WR740N
TL-WR1043ND |  | TL-WR1043ND |  | 845973054038 |  | TL-WR740N
TL-WA901ND |  | TL-WA901ND |  | 114CE102371 |  | TL-WR740N
TL-WA801ND |  | TL-WA801ND |  | IIN02801GAH0 |  | TL-WR740N
TL-WA5210G |  | TL-WA5210G |  |  |  | TL-WR740N
TD-W8960N |  | TD-W8960N |  |  |  | TL-WR740N
TD-W8950ND |  | TD-W8950ND |  |  |  | TL-WR740N
TL-SM321B |  | TL-SM321B |  |  |  | TL-WR740N
 |  |  |  |  |  | TL-WR740N
Spreadsheet: 92107d1291766886-accessible-pivot-or-summary-table-desired-format
Sheet: Desired accessible result

Section name | Section | Hours | Dollars | Quantity
E East
Boston | 1 | 1 | 180
Boston | 1 |  | 27 | 3
Boston | 1 | 1 | 207 | 3
Philadelphia | 2 | 3 | 720
Philadelphia | 2 |  | 14 | 2
Philadelphia | 2 | 3 | 734 | 2
E East total |  | 4 | 941 | 5
W West
San Francisco | 3 | 8 | 2000
San Francisco | 3 |  | 23 | 1
San Francisco | 3 | 8 | 2023 | 1
Los Angeles | 4 | 4 | 1500
Los Angeles | 4 |  | 86 | 4
Los Angeles | 4 | 4 | 1586 | 4
Seattle | 5 | 2 | 378
Seattle | 5 |  | 19 | 1
Seattle | 5 | 2 | 397 | 1
W West total |  | 14 | 4006 | 6
Total |  | 18 | 4947 | 11
Spreadsheet: 129299d1321541176-index-match-question-dont-understand-this-result-index_question1
Sheet: Sheet1

H1 | H2 | H3 | H4 | H5 | H6 |  | [NAME] |  |  |  | Range | Sheet1!$A$1:$F$8
B1 | B2 | B3 | 1 | B5 | B6 |  | 3
C1 | C2 | [NAME] | 2 | C5 | C6
D1 | D2 | D3 | 3 | D5 | D6
E1 | E2 | E3 | 4 | E5 | E6
F1 | F2 | F3 | 5 | F5 | F6 |  |  | combine 1st part and 2nd part……….gives error…….dont know why?
[NAME] | G2 | G3 | 6 | G5 | G6 |  |  | First part of countifs….produces result
H1 | H2 | H3 | 7 | H5 | H6 |  |  | Second part of the countifs….produces result
Spreadsheet: 75848d1276457762-convert-a-number-to-days-in-the-future-adams-test
Sheet: Sheet1

Tool\Unit | 1 | 2 | 3 | 4 | 5 | 6
A | 0.232 | 0.752 | 0.04057142857142857 | 0.1624 | 0.477175 | 0.2757
B | 0.526 | 0.8156 | 0 | 0.764 | 0.7083 | 0.3913
C | 0.2616 | 0.0572 | 0.3462857142857143 | 0.2368 | 0.60815 | 0.45465
D | 0.048 | 0.7032 | 0.8731428571428571 | 0.1408 | 0.9043 | 0.164725
E | 0.646 | 0.7404 | 0.7108571428571429 | 0.0496 | 0.475575 | 0.375475
F | 0.6028 | 0.1428 | 0.7571428571428571 | 0.6737142857142857 | 0.3733 | 0.120125
G | 0.6652 | 0.7664 | 0.8428571428571429 | 0.7208 | 0.433475 | 0.240925
Tool\Unit | 1 | 2 | 3 | 4 | 5 | 6
A
B
C
D
E
F
G
Spreadsheet: 176706d1346078057-indexing-with-duplicates-issue-copy-of-department-position-status-working-file-2
Sheet: QandC

QandC
 | Filled Positions |  |  |  |  |  |  |  |  |  |  |  | Open Positions
 | Title | Location | Category | Hiring Manager | Number of Openings | Number Filled | Date Activated | Date Filled | Start Date | Business Days to Offer | Comments |  |  | Title | Location | Category | Hiring Manager | Created Date | Age | Comments
Spreadsheet: c5909885-1f84-40ec-83ed-87f20cdcb5af
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7893 | 55762 | Oxana | Grot | KAZ | 126 | 00:19:40 | 00:01:16 | 00:37:49 | 00:01:13 | [NAME] | 1 | 01:10:58
7893 | 52729 | Winona | Howe | SIN | 121 | [NAME] | 00:00:45 | 00:38:52 | 00:01:11 | 00:10:33 | 2 | 01:12:52
7893 | 45957 | [NAME] | Kavyani | IRI | 122 | 00:21:28 | 00:00:50 | 00:39:05 | 00:01:15 | 00:10:41 | 3 | 01:13:22
7893 | 66872 | Pauline | Fornea | PHI | 125 | [NAME] | 00:00:38 | 00:38:22 | 00:01:09 | 00:11:11 | 4 | 01:13:57
7893 | 66796 | [NAME] | Bt Noor Azlan | MAS | 123 | 00:25:31 | 00:00:52 | 00:40:36 | 00:01:24 | 00:12:04 | DQ | 00:00:00
7893 | 66873 | Claudine | Ibañez | PHI | 124 | [NAME] | 00:00:41 | 00:44:08 | 00:01:19 | [NAME] | DQ | 00:00:00
Spreadsheet: 43189d1241771898-help-to-make-moving-cell-formatting-research
Sheet: Sheet3

Resource | Req/Avl | jan | feb | mrz | apr | mai | juni
X | Req | 9 | 8 | 5 | 2 | 6 | 5
 | [NAME] | 5 | 5 | 5 | 5 | 5 | 4
Y | Req | 4 | 6 | 17 | 1 | 5 | 4
 | [NAME] | 5 | 7 | 5 | 5 | 5 | 6
Z | Req | 3 | 10 | 7 | 5 | 3 | 7
 | [NAME] | 5 | 5 | 5 | 5 | 5 | 3
Spreadsheet: 762fc51b-79a6-43b8-b360-825ebe0723cc
Sheet: TumbleBooks

TumbleBooks 2014
 | My Cloud Registrations
 | New this Month | Total | Materials Viewed
January | 20 | 76 | 31377
February |  | 85 | 29722
March | 2 | 87 | 26664
April | 6 | 93 | 34272
May | 5 | 98 | 25509
June | 2 | 100 | 7277
July | 3 | 103 | 2804
August | 8 | 111 | 12952
September | 6 | 117 | 36137
October |  | 122 | 38728
November
December
Year to date
Notes
My Cloud is an optional registration to save favorites and does not indicate actual number of patrons.
Spreadsheet: 67996d1268510908-pivot-table-calculate-a-new-column-average
Sheet: PT with Average

 | Values
Row Labels | Count of Model2 | Sum of Revenues | Average of Earning by Car
A | 3 | 400 | 83.33333333333333
B | 2 | 500 | 235
C | 4 | 1000 | 210
D | 1 | 300 | 270
E | 4 | 700 | 145
Grand Total | 14 | 2900 | 172.1428571428571
Spreadsheet: 085a491f-87b4-49e2-acce-2f82a0ae1d43
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
MS 35 +
RANKING ORDER | FAMILY NAME | GIVEN NAME | BWF NUMBER | DATE OF BIRTH (dd/mm/yy) | BEST RESULTS IN 2012/2013
1
2
3
4
WS 35+
RANKING ORDER | FAMILY NAME | GIVEN NAME | BWF NUMBER | DATE OF BIRTH (dd/mm/yy) | BEST RESULTS IN 2012/2013
1
2
3
4
MD 35+
RANKING ORDER | FAMILY NAME | GIVEN NAME | BWF NUMBER | DATE OF BIRTH (dd/mm/yy) | BEST RESULTS IN 2012/2013
1
2
3
4
WD 35+
RANKING ORDER | FAMILY NAME | GIVEN NAME | BWF NUMBER | DATE OF BIRTH (dd/mm/yy) | BEST RESULTS IN 2012/2013
1
2
3
4
XD 35+
RANKING ORDER | FAMILY NAME | GIVEN NAME | BWF NUMBER | DATE OF BIRTH (dd/mm/yy) | BEST RESULTS IN 2012/2013
1
2
3
4
COUNTRY / MEMBER ASSOCIATION:
TEAM MANAGER:
DATE:
Spreadsheet: 682741d1592308417-engineer-project-allocation-app-sanitised-tracker
Sheet: Staff

 | Days in Month
 | Person | Mgr | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21
 | Engineer 1 | M1
 | Engineer 2 | M2
 | Vmware Engineer 3 | M2
 | Vmware Engineer 4 | M2
 | Vmware Engineer 5 | M2
 | Vmware Engineer 6 | M2
 | Network Engineer 7 | M1
 | Network Engineer 8 | M1
 | Network Engineer 9 | M1
 | Network Engineer 10 | M1
 | Network Engineer 11 | M1
 | Network Engineer 12 | M1
 | Storage Engineer 13 | M1
 | Storage Engineer 14 | M1
 | Storage Engineer 15 | M1
 | Automation Engineer 16 | M2
 | Automation Engineer 17 | M2
 | Automation Engineer 18 | M2
 | Automation Engineer 19 | M2
 | Backup Engineer 20 | M1
 | Skill | Column1 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
Spreadsheet: 863746d1711130374-combination-frequency-correlations-of-toppings-toppings-combinations-1-aligw
Sheet: Output

Anchovies | Basil | Black Olives | Buffalo Cheese | Capers | Cheddar | [NAME] | Chicken | [NAME] | [NAME] | Chillies | Crispy Onions | Double Mozzarella | [NAME] | [NAME] | Green Olives | Hot Honey | Jalapenos | Meat-Free Pepperoni | Meatballs | Mozzarella | Mushrooms | No Cheese On  The Pizza | Oregano | Parmesan | Pepperoni | Peppers | Pineapple | Red Onion | Rocket | Sausages | Spinach | Sundried Tomato | Sweetcorn | Tandoori chicken | [NAME] | Turkey Ham | Vegan Cheese
Basil
Black Olives
Buffalo Cheese
Capers
Cheddar
[NAME]
Chicken
[NAME]
[NAME]
Chillies
Crispy Onions
Double Mozzarella
[NAME]
[NAME]
Green Olives
Hot Honey
Jalapenos
Meat-Free Pepperoni
Meatballs
Mozzarella
Mushrooms
No Cheese On  The Pizza
Oregano
Parmesan
Pepperoni
Peppers
Pineapple
Red Onion
Rocket
Sausages
Spinach
Sundried Tomato
Sweetcorn
Tandoori chicken
[NAME]
Turkey Ham
Vegan Cheese
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Turkey Ham
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sausages | Spinach | Sundried Tomato | Tandoori chicken | [NAME] | Turkey Ham
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Turkey Ham
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spinach | Sundried Tomato | Tandoori chicken | [NAME] | Turkey Ham
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spinach | Sundried Tomato | Sweetcorn | Tandoori chicken | [NAME] | Turkey Ham
Spreadsheet: 710232d1608794997-need-a-change-in-if-formula-to-get-the-exact-result-in-house-production-tracking-with-completion-
Sheet: Copy of DATE TRACK

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-12-23 00:00:00
CHOOSE P.O. NO. | 4191 |  |  |  |  |  |  |  |  |  |  |  |  | DAILY PRODUCTION REPORT |  |  |  |  |  |  |  |  | DECEMBER |  |  |  |  |  |  |  |  |  | TO
 |  |  | TOTAL METER | ORG. ORDER | STOCK | FINAL ORDER | ORDER DATE | ORDER START DATE | PENDING ORDER | ORDER END DATE | EXTENDED DATE | EXTENDED DAYS | AVG PROD.
QUALITY | P.O. NO. | WIDTH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORDER | ORDER DATE | LEAD TIME | TOTAL | DIFFERENCE | DAILY EXPECTED | END DATE | AVG PROD. | EXTENDED DATE | EXTENDED DAYS | TOTAL | ORDER START DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 193 | 135.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99 | 106 |  | 494 | 391 | 510 | 183.5 | 166 | 94 | 190.5 |  |  | 41 |  | 154 | 144 | 486 |  | 233
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100.5 | 140 |  | 208 | 63 | 166 | 99 | 97 | 9.5 |  |  |  | 48 | 98 | 134 | 148 | 297.5 |  | 127 | 16
Spreadsheet: 198239d1354716270-sorting-data-2012-11-24-rt
Sheet: Sheet1

Row Labels | Sum of QI_P55_N@PV | Sum of QQ_P55_N@PV
Nov
1 PM | 0 | 0
2 PM | 0 | 0
3 PM | 0 | 0
4 PM | 3625.98 | 729.4069999999999
5 PM | 75535.54599999999 | 47202.10100000007
6 PM | 23178.73500000001 | 91677.45700000001
7 PM | 16804.852 | 111842.308
8 PM | 16069.05899999999 | 128413.074
9 PM | 16462.574 | 144870.493
10 PM | 19205.01100000001 | 161906.2009999999
11 PM | 16522.12699999999 | 180195.3130000002
Grand Total | 187403.884 | 866836.3540000002
Spreadsheet: 864934d1712066958-sumifs-indirect-name-error-excel_issue
Sheet: Data

 | target |  |  |  |  |  | No. of Parts Delivered | No. of Parts Delivered | % OTD | Head Count | New Starters | Leavers | Leavers within Probation | 2023 Rolling Staff Turnover | Hours Lost Through Sickness | Sickness Absence % | Sick Days | Monday's Taken as Sickness
0.6 |  | 2023-01-01 00:00:00
0.625
Spreadsheet: 771921d1646919341-count-data-only-from-filtered-cells-blaz_slo
Sheet: List1

 |  |  | Count old:
 |  |  | Count new: |  |  | I would like to get counts only for filtered datas
 |  |  | Count all:
 |  |  |  |  |  | (If I now filter D collumn, formula still count me all datas)
 |  | Name: | In use | New / old
 |  | A | x | New
 |  | B | x | Old
 |  | C |  | Old
 |  | D | x | Old
 |  | E |  | New
 |  | F | x | Old
 |  | G | x | New
 |  |  | I would like to filter cells in D collumn
Spreadsheet: 178473d1346799790-how-to-filter-a-time-series-by-a-column-of-dates-example
Sheet: Sheet1

Date | Value | Date 2 | Value 2 |  | INDEX & MATCH |  | VLOOKUP
2001-01-01 00:00:00 | 35 | 2001-01-03 00:00:00 | 22
2001-01-02 00:00:00 | 40 | 2001-01-14 00:00:00 | 45
2001-01-03 00:00:00 | 22 | 2001-01-24 00:00:00 | 20
2001-01-04 00:00:00 | 56 | 2001-01-31 00:00:00 | 71
2001-01-05 00:00:00 | 43
2001-01-06 00:00:00 | 12
2001-01-07 00:00:00 | 54
2001-01-08 00:00:00 | 56
2001-01-09 00:00:00 | 42
2001-01-10 00:00:00 | 10 | 2001-01-27 00:00:00
2001-01-11 00:00:00 | 12
2001-01-12 00:00:00 | 64
2001-01-13 00:00:00 | 82
2001-01-14 00:00:00 | 45
2001-01-15 00:00:00 | 28
2001-01-16 00:00:00 | 37
2001-01-17 00:00:00 | 19
2001-01-18 00:00:00 | 35
2001-01-19 00:00:00 | 54 | 2001-01-19 00:00:00
2001-01-20 00:00:00 | 26
2001-01-21 00:00:00 | 24
2001-01-22 00:00:00 | 37
2001-01-23 00:00:00 | 30
2001-01-24 00:00:00 | 20
2001-01-25 00:00:00 | 21
2001-01-26 00:00:00 | 32
2001-01-27 00:00:00 | 31
2001-01-28 00:00:00 | 62
2001-01-29 00:00:00 | 42
2001-01-30 00:00:00 | 51
2001-01-31 00:00:00 | 71
Spreadsheet: 205462d1357820503-tables-feeding-data-into-a-further-table-book177
Sheet: Ferminy

DETAILS |  |  |  |  | TIME FRAME |  | BENEFIT MEASURE |  |  | FINANCIAL
Project Ref. | Production Unit | Description | Project Driver                                       (CCL, CRC, CF, 14001, Sun) | Project Lead | Start Date | End Date | KwH | CO2 | £/€ | Cost | Return Period
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCL | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CRC | Merlin
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sun | Taco
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unterland
Spreadsheet: 73071d1273730920-counting-the-digit-2-accross-mulitple-sheets-copy-of-absence-log-2010
Sheet: Total

Employee | Absent | Late | Approved Day Off
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 57329d1257437577-compare-cells-with-other-other-worksheets-compare-cells-example
Sheet: Sheet6

Color | [NAME] | [NAME] | [NAME]
Yellow
Orange
White
Pink
Red
Green
Blue
Spreadsheet: 216241d1361655419-counting-data-within-a-date-range-ethnicity
Sheet: Sheet1

Date | Ethnicity |  |  | Number of White British
2013-01-05 00:00:00 | White British |  | 2012-12-17 00:00:00
2013-01-04 00:00:00 | White British |  | 2012-11-21 00:00:00
2013-01-04 00:00:00 | White British
2013-01-04 00:00:00 | White British
2013-01-04 00:00:00 | White British
2012-12-17 00:00:00 | White British
2012-12-17 00:00:00 | White British
2012-12-17 00:00:00 | White British
2012-12-17 00:00:00 | White British
2012-12-12 00:00:00 | White British
2012-12-12 00:00:00 | White British
2012-12-11 00:00:00 | Information Not Yet Obtained
2012-12-10 00:00:00 | White British
2012-12-07 00:00:00 | Indian
2012-12-07 00:00:00 | White British
2012-12-05 00:00:00 | White British
2012-12-05 00:00:00 | White British
2012-12-05 00:00:00 | White British
2012-12-05 00:00:00 | White British
2012-12-05 00:00:00 | Pakistani
2012-12-05 00:00:00 | White British
2012-12-05 00:00:00 | White British
2012-12-05 00:00:00 | White British
2012-12-05 00:00:00 | White British
2012-12-04 00:00:00 | White British
2012-12-04 00:00:00 | White British
2012-11-30 00:00:00 | White British
2012-11-30 00:00:00 | White British
2012-11-29 00:00:00 | White British
2012-11-28 00:00:00 | White British
2012-11-28 00:00:00 | White British
2012-11-28 00:00:00 | White British
2012-11-28 00:00:00 | White British
2012-11-27 00:00:00 | White British
2012-11-24 00:00:00 | White British
2012-11-23 00:00:00 | White British
2012-11-23 00:00:00 | White British
2012-11-22 00:00:00 | White British
Spreadsheet: 792795d1661172131-spill-error-imbedded-if-statements-unknown-origin-cwsp-financial-report-final-draft
Sheet: Financial Report

FY23 CWSP Formula Grant Report |  |  |  |  |  |  |  | AWARD INFO |  | STATE REMAINING GRANT $ |  | EXPEDITURES
Quarter ending: [date] |  |  |  |  |  |  |  | Total Award Amount: | 1000000 | Amount Available at Grant Start |  | Total Disbursed
[CWSP Name] |  |  |  |  |  |  |  | Administrative Costs (AC): 15% | 150000 | Total Requested |  | Total Spent
[Grant ID] |  |  |  |  |  |  |  | Project Completion Costs (PCC): 85% | 850000 | Total Remaining |  | Remaining Cash on Hand
 | .
 |  | Ex: Draw only | Ex: Draw+ Adv | Ex: Draw+ Reimb
 |  | Quarter 1 | Quarter2 | Quarter 3 | Quarter 4 | Quarter 5 | Quarter 6 | Quarter 7 | Quarter 8 | Cumulative Totals | % Remaining
Administrative Costs (AC) | Total Expenditures this Quarter- AC | 30000 | 37000 | 32000 | 13500 | 30000 | 7500 | 0 | 0 |  |  | admin pacing
 | Quarter to Date Cash Reimbursements- AC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | New Advance Request | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Cash Balance at Quarter Start- AC |  |  |  |  |  |  |  |  |  |  | HIDE | 0
 | Quarter End Remaining Cash Balance- AC |  |  |  |  |  |  |  |  |  |  | HIDE
 | Quarter End Draw Request
 | Total Amount AC Currently Requested
Project Completion Costs (PCC) | Total Expenditures this Quarter- PCC | 50000 | 120000 | 200000 | 212000 | 100000 |  |  |  |  |  | pcc pacing
 | Quarter to Date Cash Reimbursements- PCC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | New Advance Request | 0 | 0 | 0 | 30000 | 0 | 0 | 0 | 0
 | Cash Balance at Quarter Start- PCC |  |  |  |  |  |  |  |  |  |  | HIDE
 | Quarter End Remaining Cash Balance- PCC |  |  |  |  |  |  |  |  |  |  | HIDE
 | Quarter End Draw Request
 | Total PCC Currently Requested
 | Total Draw Requested
 | Total Advance Requested
 | Quarter Total Requested |  |  |  |  |  |  |  |  |  |  | remaining state funds
 | PCC Non- Match Eligible | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PCC- Match Eligible
 | Interest Earned | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | goes the other way- talks to TPM tab