tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 25dd81cc-e94d-4d6a-bb81-66961ea06263
Sheet: T46

الجدول 46: النسبة المئوية للأولاد (0-14) سنة، خلال سنوات التعداد
Table 46: Percentage of children (0-14) years, during the census years
Country | Round 2000           دورة 2000 |  |  |  | Round 2010           دورة 2010 |  |  |  | البلد
 | Census year سنة التعداد | % Male child نسبة الذكور الأطفال | % Female child  نسبة الإناث الأطفال | % Total child  نسبة المجموع الأطفال | Census year سنة التعداد | % Male child نسبة الذكور الأطفال | % Female child  نسبة الإناث الأطفال | % Total child  نسبة المجموع الأطفال
Bahrain | 2001 | 14.25383182396665 | 13.62318706924642 | 27.87701889321307 | 2010 | 10.26210724211082 | 9.793685417849602 | 20.05579265996042 | البحرين
Egypt | 1996 | 19.43506345020343 | 18.23886480259409 | 37.67392825279752 | 2006 | 19.44698650098362 | 18.23752747124733 | 37.68451397223095 | مصر
Iraq | 1997 | 22.81122807132136 | 22.06876146340392 | 44.87998953472528 | ... |  |  |  | العراق
Jordan | 2004 | 11.12384365404635 | 10.44626713280323 | 21.57011078684958 | ... |  |  |  | الاردن
Kuwait | 1995 | 15.36044471679275 | 14.64215786402565 | 30.0026025808184 | 2011 | 11.70964006719181 | 10.96475691896211 | 22.67439698615392 | الكويت
Lebanon | ... |  |  |  | ... |  |  |  | لبنان
Libya | ... |  |  |  | 2006 | 15.87398776026056 | 15.19029654113359 | 31.06428430139415 | ليبيا
Morocco | 2004 | 15.25134048257373 | 15.78418230563003 | 31.03552278820375 |  |  |  |  | [NAME]
Oman | 2003 | 17.26450154879208 | 16.5789559158387 | 33.84345746463079 | 2010 | 14.2186401988261 | 13.6105591569289 | 27.82919935575499 | عمان
Palestine | 1997 | 24.11468095595921 | 22.92476970514105 | 47.03945066110026 | 2007 | 22.41845645046897 | 21.60150411546083 | 44.01996056592981 | فلسطين
Qatar | 2004 | 11.44659683963932 | 11.08182611161662 | 22.52842295125593 | 2010 | 7.01056527610647 | 6.6753950577692 | 13.68596033387567 | قطر
Saudi Arabia | 2004 | 17.11816805009132 | 17.21534921856005 | 34.33351726865136 | ... |  |  |  | المملكة العربية السعودية
Sudan | ... |  |  |  | 2008 | 22.26813578723666 | 20.34205783295862 | 42.61019362019528 | السودان
Syrian Arab Republic | 2004 | 20.2844982078853 | 19.08042114695341 | 39.36491935483871 | ... |  |  |  | الجمهورية العربية السورية
Tunisia | 2004 | 13.74344255480244 | 12.97303607593762 | 26.71647863074006 | ... |  |  |  | تونس
United Arab Emirates | 1995 | 13.57983571116889 | 12.73400208057154 | 26.31383779174043 | 2005 | 10.1463725648138 | 9.365533656525932 | 19.51190622133973 | [NAME] المتحدة
Yemen | 2004 | 23.29064925226103 | 21.75339812497471 | 45.04404737723574 | ... |  |  |  | اليمن
Spreadsheet: 91757d1291408811-league-table-from-multiple-sheets-new-sheet
Sheet: Sheet1

 |  | Champions League |  |  |  |  | Week:
 |  | Standing | Team | GW | New | HD | [NAME] | RSG | sales
 |  | 1 | bryn |  | 12 | 0 | 0 | 0 | 12
 |  | 2 | dean |  | 11 | 0 | 0 | 0 | 11
 |  | 3 | [NAME] |  | 10 | 0 | 1 | 0 | 11
 |  | 4 | [NAME] |  | 9 | 0 | 1 | 0 | 10
 |  | 5 | [NAME] |  | 8 | 0 | 1 | 0 | 9
 |  | 6 | [NAME] c |  | 7 | 1 | 0 | 0 | 9
 |  | 7 | [NAME] |  | 8 | 0 | 0 | 0 | 8
 |  | 8 | [NAME] |  | 7 | 0 | 1 | 0 | 8
 |  | 9 | [NAME] |  | 6 | 1 | 0 | 0 | 8
 |  | 10 | [NAME] |  | 6 | 1 | 0 | 0 | 8
 |  | 11 | [NAME] |  | 5 | 1 | 0 | 0 | 7
 |  | 12 | paul h |  | 5 | 0 | 0 | 0 | 5
Spreadsheet: 479925d1473675406-find-name-that-carries-the-shift-on-that-day-modulo-prova-2-
Sheet: Ottobre (1)

 |  | [NAME]
01/10 | Data
 | Turno Mattina | Turno Pomeriggio | Turno Notturno
 | 07.00 - 13.00 | 13.00 - 19.00 | 19.00 - 07.00
 | [NAME] dovrebbe contenere il resoconto giornaliero
 | Data
 | Turno Mattina | Turno Pomeriggio | Turno Notturno
 | 07.00 - 13.00 | 13.00 - 19.00 | 19.00 - 07.00
F1---> | Valentina | Valentina | Valentina
Spreadsheet: 757778d1638455383-filter-formula-over-multiple-sheets-permit-register-gk
Sheet: OP

ABC Job Number | Address | Description | Client | Permit  Number | OCCUPANCY PERMIT | Inspection Status | Job Notes
 | Address 3 | Description 3 | Client 3 | 001/001/003 | OP | 15/1/21 - Final | Note 2
ABC-21006 | Address 6 | Description 6 | Client 6 | 001/001/006 | PARTIAL OP | 18/1/21 - Final | Note 5
ABC-21007 | Address 7 | Description 7 | Client 7 | 001/001/007 | OP | 15/1/21 - Final | Note 6
Spreadsheet: 812484d1673185855-help-retrieving-the-second-last-value-in-a-list-book1
Sheet: Sheet1

Q | 1 |  |  |  |  | 14
Q | 2 |  |  | W |  | 13
W | 3 |  |  | E |  | 12
E | 4 |  |  | R
W | 5
E | 6
W | 7
Q | 8
W | 9
E | 10
R | 11
E | 12
W | 13
Q | 14
Spreadsheet: 56435d1256637148-formula-to-sum-for-a-given-field-type-specified-in-another-column-excel-forum-sum-fruit
Sheet: Sheet1

Fruits | Types | Quantity | Cost | Use | Required
Lemons | A | 2 | 1 | Eat | Yes
 | B | 3 | 2 | [NAME] | No
 | C | 4 | 3 | [NAME] | Yes |  | Lemons | Eat | Yes
 | D | 5 | 4 | Eat | Yes |  | Apples | [NAME] | No
 | E | 9 | 6 | [NAME] | No |  | Pears
 | F | 7 | 7 | Eat | Yes
 | G | 2 | 1 | [NAME] | No
 | H | 5 | 2 | [NAME] | No
Apples | I | 6 | 3 | [NAME] | No
 | J | 1 | 4 | [NAME] | Yes
 | K | 8 | 7 | [NAME] | No
 | L | 7 | 8 | [NAME] | Yes
 | M | 6 | 9 | Eat | Yes |  | [NAME] to SUM for a Given Field Type Specified in another Column - Excel Help Forum
 | N | 3 | 6 | Eat | Yes
 | O | 4 | 4 | Eat | Yes
 | P | 5 | 2 | Eat | Yes
Pears | Q | 9 | 1 | [NAME] | Yes
 | R | 7 | 2 | Eat | Yes
 | S | 8 | 3 | [NAME] | Yes
 | T | 2 | 4 | Eat | No
 | U | 1 | 7 | [NAME] | No
 | V | 5 | 8 | Eat | Yes
 | W | 6 | 9 | Eat | No
 | X | 7 | 5 | [NAME] | No
Question
Z1 | Total Cost of All types of "Lemons" |  |  |  |  | 155
[NAME] | Total Cost of All types of "Apples" |  |  |  |  | 232
Z3 | Total Cost of All types of "Pears" |  |  |  |  | 191
Z4 | Total Cost of "Use = Eat" - "Lemons" |  |  |  |  | 71
[NAME] | Total Cost of "Use = Eat" - "Apples" |  |  |  |  | 98
Z6 | Total Cost of "Use = Eat" - "Pears" |  |  |  |  | 116
Z7 | Total Cost of "Required = Yes" - "Lemons" |  |  |  |  | 83
Z8 | Total Cost of "Required = Yes" - "Apples" |  |  |  |  | 158
Z9 | Total Cost of "Required = Yes" - "Pears" |  |  |  |  | 87
[NAME] | Overall Cost of "Required = Yes" - All Fruits |  |  |  |  | 328
Z11 | Overall Cost of "Use = Eat" - All Fruits |  |  |  |  | 285
Z12 | Overall Cost of "Use = [NAME]" - All Fruits |  |  |  |  | 293
Spreadsheet: 206641d1358244243-a-combination-of-sum-and-unknown-function-help-basic-version
Sheet: Sheet1

Company | Investment | Total Investments
A | 100
A | 140
A | 90 | ?
B | 100 | ?
C | 80
C | 150 | ?
D | 200
D | 240
D | 450 | ?
E | 100 | ?
Spreadsheet: 545908d1509720026-combine-does-not-contain-with-a-sumproduct-isnumber-search-formula-retailermatch-llnv5
Sheet: New Quotes

 |  |  | FALSE POSITIVES?
New N/A Quote Names | [NAME]? |  | GVAMC | Mason | Wall
2017 - Q325% - Meijer - 6MO
2017 - Q305% - Home Depot - 6MO
2017 - Q355% - Steinmart- 6MO
2017 - Q325% - Wal-Mart- 6MO
2017 - Q355% - Carmax- 6MO
2017 - Q325% - AMC - 6MO
2017 - Q325% - GVAMC - 6MO
Wal-Mart - 2017 - Q325% - 6MO
Mart- 2017 - Q325% - 6MO
Advocate Illinois Masonic Medical Center OR Renova
Wall - 2017 - Q325% - 6MO
Schuh-Penske |  |  |  |  |  |  | Should be true
[NAME] (McDonald's HQ) |  |  |  |  |  |  | Should be true
 | Combine this formula with the ones in columns D-F
 | So what I've come up with is filter column B to TRUE and columns D-F to FALSE and that leaves me all the true retailers in column A.
Spreadsheet: 292297a4-88a8-41d4-9729-8de4e3b8c36f
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
35851792 | 2013-05-08 21:10:49 | ALLIES | 1 | 6 | 3 | 248392 | harleygator | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
Spreadsheet: 787839d1658082464-how-can-i-collect-and-join-data-corresponding-to-another-columns-data-book
Sheet: Sheet2

Year | Voucher Date | Sr. # | Debit Amount | Description (Single Line) Required | Credit Amount
2022 | 01/07/2021 | 192103 | Invoice No. NHPL/SIN/0621/000119 Dated :01-JUN-21 Of | Invoice No. NHPL/SIN/0621/000119 Dated :01-JUN-21 OfNISHAT HOTELS & PROPERTIES LIMITED (EMPORIUMMALL)  FMO JUN-2021 Eid Range ( EF )-2021 | 300000
 |  |  | NISHAT HOTELS & PROPERTIES LIMITED (EMPORIUM
 |  |  | MALL)  FMO JUN-2021 Eid Range ( EF )-2021
2022 | 01/07/2021 | 192118 | INV# [PHONE],[PHONE] COMMISSION ON TVC | INV# [PHONE],[PHONE] COMMISSION ON TVCMEDIA ADS LINEN SUMMER(S)-VOL.1-2021 | 17691
 |  |  | MEDIA ADS LINEN SUMMER(S)-VOL.1-2021
2022 | 01/07/2021 | 192118 | INV# |  | 589686
 |  |  | [PHONE],[PHONE],[PHONE],[PHONE],21052059
 |  |  | 27 TVC MEDIA ADS LINEN SUMMER(S)-VOL.1-2021
2022 | 14/07/2021 | 192104 | Invoice No. NHPL/SIN/0721/000001 Dated :01-JUL-21 Of |  | 300000
 |  |  | NISHAT HOTELS & PROPERTIES LIMITED (EMPORIUM
 |  |  | MALL)  FMO JUL-2021 Eid Range ( EA )-2021
2022 | 15/07/2021 | 192170 | Invoice No. Debit Note#NL/CR-N/P0020/06/2021 Date :30-
 |  |  | JUN-21 Of DIAL ZERO (PRIVATE) LIMITED  ADJ. FOR
 |  |  | FACEBOOK REFUND LINEN ONLINE FMO APR-21
2022 | 24/07/2021 | 8422010098 | Invoice No. 024 Dated :12-JUL-21 Of HN ASSOCIATES |  | 280000
 |  |  | DASKA HOARDING RENT Eid Range ( EA )-2021
Spreadsheet: michelle_lokay__26740__imball0203
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -48751
3531 | -90938 | -33990
60667 | -160744 | -304626
60749 |  | 40006
61206
61334 | -1
62960
INDEX
2002-02-28 00:00:00 |  |  | 33520
2002-03-03 00:00:00
CBS Volume
 |  |  | 15258
Spreadsheet: 877269d1724060587-sumifs-by-name-and-eomonth-array-formula-bydate-1-
Sheet: Sheet1

Date | Staff Name | Amount |  |  | Staff Name | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00 | 2025-04-30 00:00:00 | 2025-05-31 00:00:00 | 2025-06-30 00:00:00
2024-03-01 00:00:00 | [NAME] | 11 |  |  |  | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024-03-02 00:00:00 | [NAME] | 23 |  |  | [NAME] | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024-03-04 00:00:00 | [NAME] | 23 |  |  | [NAME] | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024-04-04 00:00:00 | [NAME] | 100 |  |  | [NAME] | 0 | 100 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024-04-16 00:00:00 | [NAME] | 123 |  |  | [NAME] | 0 | 123 | 122 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024-05-01 00:00:00 | [NAME] | 122
2024-05-01 00:00:00 | [NAME] | 20
2024-05-15 00:00:00 | [NAME] | 13 |  |  |  | *[NAME] should show 33
Spreadsheet: 752267d1634671320-challenging-conditional-formatting-matching-dates-tml2424-sample-book-1
Sheet: match 2 months

Want to conditonally format so that it highlights cells where the month and year of 2 match up
Name | Date 1 | Date 2 | 1/1/2021 | 2/1/2021 | 3/1/2021 | 4/1/2021 | 5/1/2021 | 6/1/2021 | 7/1/2021 | 8/1/2021 | 9/1/2021 | 10/1/2021 | 11/1/2021 | 12/1/2021 | 1/1/2022 | 2/1/2022 | 3/1/2022 | 4/1/2022 | 5/1/2022 | 6/1/2022 | 7/1/2022 | 8/1/2022 | 9/1/2022 | 10/1/2022 | 11/1/2022 | 12/1/2022
Name 1 | 2021-09-10 00:00:00 | 2022-05-06 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 0 | 0 | 0 | 0 | 0 | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Name 2 | 4/1/2022 | 2022-07-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Name 3 | 2021-10-05 00:00:00 | 2022-01-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 0 | 0 | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 136172d1326457240-excel-2008-split-cell-with-4-comma-separated-values-into-4-separate-cells-all-into-one-column
Sheet: Sheet1

original |  | split with text to columns |  |  |  |  | new column |  | new column as real number
7,8,9,10 |  | 7 | 8 | 9 | 10 |  | 7 |  | 7
1,2,3,4 |  | 1 | 2 | 3 | 4 |  | 8 |  | 8
3,9,8,7 |  | 3 | 9 | 8 | 7 |  | 9 |  | 9
111,333,5555,88 |  | 111 | 333 | 5555 | 88 |  | 10 |  | 10
9,8,7,6 |  | 9 | 8 | 7 | 6 |  | 1 |  | 1
 |  |  |  |  |  |  | 2 |  | 2
 |  |  |  |  |  |  | 3 |  | 3
 |  |  |  |  |  |  | 4 |  | 4
 |  |  |  |  |  |  | 3 |  | 3
 |  |  |  |  |  |  | 9 |  | 9
 |  |  |  |  |  |  | 8 |  | 8
 |  |  |  |  |  |  | 7 |  | 7
 |  |  |  |  |  |  | 111 |  | 111
 |  |  |  |  |  |  | 333 |  | 333
 |  |  |  |  |  |  | 5555 |  | 5555
 |  |  |  |  |  |  | 88 |  | 88
 |  |  |  |  |  |  | 9 |  | 9
 |  |  |  |  |  |  | 8 |  | 8
 |  |  |  |  |  |  | 7 |  | 7
 |  |  |  |  |  |  | 6 |  | 6
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
Spreadsheet: 55274d1255428280-automatically-creating-subtotals-based-on-non-sorted-categories-travel-expenses-template
Sheet: Expense report

 | Expense report
 | PURPOSE: | [NAME] |  |  | Projects |  |  |  |  | Trip Dates | 20/09/2009
 |  |  |  |  |  |  |  |  |  |  | 23/09/2009
 | EMPLOYEE INFORMATION: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense Cateogries
 | Name |  |  |  | Billable | Yes | Country |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public transport
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Car rental
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Internet
 | Date | Project | Value | Currency | Category | Comments | Conversion Rate | Total in Nis |  |  |  |  |  |  |  |  |  |  |  |  |  | Hotel
 | 20/09/2009 |  | 98 | EUR | Hotel | 1 night | 4 | 392 |  |  |  |  |  |  |  |  |  |  |  |  |  | Airfare
 | 21/09/2009 |  |  | EUR | Hotel | 1 night |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | Meals
 | 22/09/2009 |  |  | EUR | Hotel | 1 night |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
 | 21/09/2009 |  | 2.8 | EUR | Public transport |  |  | 0
 | 20/09/2009 |  | 830.2 | NIS | Airfare |  | 3.809998 | 3163.0603396
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 3555.0603396
 |  |  |  |  | NOTES:
Spreadsheet: 724887d1616431078-sum-of-a-sveral-rows-with-the-same-name-book1
Sheet: Sheet1

 |  |  |  |  |  |  | total
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Ealing
 |  | [NAME] | column2 |  |  |  | Fulham
 | [NAME] | 40 | 1 |  |  |  | Harlseden
 | Ealing | 74 | 4 |  |  |  | [NAME]
 | Fulham | 57 | 3 |  |  |  | [NAME]
 | Harlseden | 17 | 0 |  |  |  | Hounslow
 | [NAME] | 3 | 0 |  |  |  | Kingston
 | [NAME] | 43 | 5 |  |  |  | [NAME]
 | Hounslow | 45 | 14 |  |  |  | [NAME]
 | Kingston | 5 | 4 |  |  |  | Uxbridge
 | [NAME] | 35 | 10 |  |  |  | Wandsworth
 | [NAME] | 13 | 14 |  |  |  | Wembley
 | Uxbridge | 42 | 2
 | Wandsworth | 15 | 0
 | Wembley | 19 | 14
 | [NAME] | 10 | 4
 | Ealing | 78 | 8
 | Fulham | 38 | 0
 | Harlseden | 10 | 0
 | [NAME] | 2 | 1
 | [NAME] | 28 | 13
 | Hounslow | 67 | 18
 | Kingston | 4 | 5
 | [NAME] | 36 | 8
 | [NAME] | 6 | 7
 | Uxbridge | 31 | 17
 | Wandsworth | 15 | 0
 | Wembley | 30 | 16
 | [NAME] | 29 | 1
 | Ealing | 83 | 9
 | Fulham | 32 | 3
 | Harlseden | 8 | 8
 | [NAME] | 4 | 0
 | [NAME] | 25 | 19
 | Hounslow | 54 | 8
 | Kingston | 0 | 10
 | [NAME] | 9 | 8
 | [NAME] | 4 | 10
 | Uxbridge | 23 | 10
 | Wandsworth | 6 | 4
 | Wembley | 26 | 18
Spreadsheet: 160919d1339317151-copy-cell-value-between-two-worksheets-and-paste-in-column-of-another-worksheet-sum-across-sheets-for-excelint-oeldere-
Sheet: Statistics

 |  |  | Sum | Sheet3 | Sheet4 | Sheet5
[NAME] | 46.9 |  | 46.9 | 22.45 | 22.45 | 2
[NAME] | 75.24 |  | 75.24 | 36.12 | 36.12 | 3
[NAME] | 43.1 |  | 43.1 | 19.55 | 19.55 | 4
[NAME] | 42.32 |  | 42.32 | 18.66 | 18.66 | 5
[NAME] | 72.44 |  | 72.44 | 33.22 | 33.22 | 6
[NAME] | 315.44 |  | 315.44 | 154.22 | 154.22 | 7
[NAME] | 101.1 |  | 101.1 | 46.55 | 46.55 | 8
[NAME] | 165.26 |  | 165.26 | 78.13 | 78.13 | 9
[NAME] | 39.12 |  | 39.12 | 14.56 | 14.56 | 10
Spreadsheet: 836199d1689167085-get-the-correct-unit-price-per-price-breaks-needed-book1
Sheet: Sheet1

 | Min Buy Qty
Part | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 9 | 10 | 11 | 12 | 13 | 15 | 16 | 17 | 18 | 20 | 21 | 23 | 24 | 25 | 28 | 29 | 30 | 31 | 33 | 34 | 35 | 40 | 41 | 43 | 45 | 47 | 50 | 51 | 52 | 60 | 61 | 67 | 70 | 79 | 93 | 100 | 120 | 139 | 163 | 235 | 330 | 752 | Qty requested yearly | Unit Price | Min Buy
Part1 | 587.44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 587.84 | 1
Part2 | 1261.81 | 1124.72 |  |  |  | 1029.24 |  |  | 950.28 |  |  |  |  |  |  |  | 883.8 |  |  |  |  |  |  |  |  |  |  |  | 826.32 |  |  |  |  |  |  |  |  |  |  |  |  |  | 779.09 |  |  |  |  |  |  | 1 | 1261.21 | 1
Part3 | 204.23 | 182.05 |  |  |  | 166.59 |  |  | 153.82 |  |  |  |  |  |  |  | 143.05 |  |  |  |  |  |  |  |  |  |  |  | 133.74 |  |  |  |  |  |  |  |  |  |  |  |  |  | 126.08 |  |  |  |  |  |  | 0 | 204.23 | 1
Part4 | 58.88 | 52.48 |  |  |  | 48.03 |  |  | 44.35 |  |  |  |  |  |  |  | 41.26 |  |  |  |  |  |  |  |  |  |  |  | 38.57 |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.34 |  |  |  |  |  |  | 10 | 44.35 | 10
Part5 | 58.88 | 52.48 |  |  |  | 48.03 |  |  | 44.35 |  |  |  |  |  |  |  | 41.26 |  |  |  |  |  |  |  |  |  |  |  | 38.57 |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.34 |  |  |  |  |  |  | 2 | 52.48 | 2
Part6 | 279.89 | 249.45 |  |  |  | 228.3 |  |  | 210.78 |  |  |  |  |  |  |  | 196.03 |  |  |  |  |  |  |  |  |  |  |  | 183.3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 172.83 |  |  |  |  |  |  | 4 | 249.45 | 2
Part7 | 253.32 | 225.76 |  |  |  | 206.62 |  |  | 190.77 |  |  |  |  |  |  |  | 177.43 |  |  |  |  |  |  |  |  |  |  |  | 165.88 |  |  |  |  |  |  |  |  |  |  |  |  |  | 156.41 |  |  |  |  |  |  | 7 | 206.62 | 6
Part8 | 297.19 | 264.89 |  |  |  | 242.42 |  |  | 223.8 |  |  |  |  |  |  |  | 208.15 |  |  |  |  |  |  |  |  |  |  |  | 194.64 |  |  |  |  |  |  |  |  |  |  |  |  |  | 183.5 |  |  |  |  |  |  | 100 | 183.5 | 100
Part9 | 1579.45 | 1407.76 |  |  |  | 1288.34 |  |  | 1189.47 |  |  |  |  |  |  |  | 1106.19 |  |  |  |  |  |  |  |  |  |  |  | 1034.37 |  |  |  |  |  |  |  |  |  |  |  |  |  | 975.18 |  |  |  |  |  |  | 120 | 975.18 | 100
Spreadsheet: 59624d1260217146-excel-2007-checking-a-range-of-dates-with-if-or-select-case-example1
Sheet: TA2009-08

FLEXIBLE SCHEDULE CERTIFICATION FORM
NAME: |  |  |  |  |  |  |  |  |  |  |  | Established Hours:
 |  |  |  |  |  |  |  |  |  |  |  | M |  |  | M:
ORG: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  |  |  |  |  |  |  |  |  |  |  | W |  |  | W:
PP Ending: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  | PP | 09-08 |  |  |  |  |  |  |  |  | F: |  |  | F:
 |  | Working Hours |  | Time in Duty Status |  |  |  | *Telework Hours |  | Credit Hours |  |  | [NAME]
Date |  | Arrive | [NAME] | Regular | Overtime | Comp | Holiday | Worked | Code | Earned | Used | Balance | Annual | Sick | Comp | LWOP | Other | Remarks
Previous Balance
S
M
T
W
T
F
S
S
M
T
W
T
F
S
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL PAYABLE HRS.
Totals
 | Employee Signature: |  |  |  |  |  |  |  |  |  | Supervisor Signature:
 |  |  |  |  |  |  |  |  |  |  |  | *Telework Indicator Codes
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | "Fixed" Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | C | 3 or more days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | F | 2 or fewer days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | “As Needed” Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | I | Work performed at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | The Telework columns are to be left blank for those employees who did not work at an alternate worksite during the Pay Period.
MOST EMPLOYEES SHOULD HAVE NO BALANCE IN LWOP.
Spreadsheet: 250477d1373950685-delete-all-rows-in-workbook-with-same-title-ffcs-sample
Sheet: RBs

POS# | P-Rnk | Player | ADP | Team | Bye | RushYds | RushTDs | Fumbles | Tot Pts
RB 1 | 1
RB 2 | 2
RB 3 | 3
RB 4 | 4
RB 5 | 5
Spreadsheet: 0e75f748-2307-4903-a13d-388c548d9c2e
Sheet: Sheet1

MONTHLY TIME REPORT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
GRADUATE ASSISTANTS & GRADUATE STUDENT WORKERS
(REMINDER: ULM POLICY IS THAT GA'S CAN WORK A MAXIMUM OF 20 HOURS A WEEK)
NAME: |  |  |  |  |  |  |  |  |  | DEPT:
CWID: |  |  |  |  |  |  |  |  |  | PAY PERIOD: |  |  | OCT 12 - NOV 8, 2013
[NAME] REPORT:
 | Oct 12 | Oct 13 | Oct 14 | Oct 15 | Oct 16 | Oct 17 | Oct 18 | Oct 19 | Oct 20 | Oct 21 | Oct 22 | Oct 23 | Oct 24 | Oct 25
 | Oct 26 | Oct 27 | Oct 28 | Oct 29 | Oct 30 | Oct 31 | Nov 1 | Nov 2 | Nov 3 | Nov 4 | Nov 5 | Nov 6 | Nov 7 | Nov 8
I CERTIFY THAT I HAVE WORKED MY NORMAL EMPLOYMENT SCHEDULE EXCEPT AS REFLECTED ABOVE.
GRADUATE ASSISTANT:
APPROVED BY:
SUPERVISOR |  |  |  |  |  |  |  |  | GRADUATE COORDINATOR
SUPERVISOR (IF APPLICABLE)
INSTRUCTIONS FOR COMPLETING TIME REPORT
1 | Please enter name, CWID, department, and the pay period to which the report applies.
2 | Entries should be made to the dates only if the GA/GWS did not complete their normal work schedule
 | and a pay adjustment is required.
3 | Time reports are due in the Payroll Office by 12:00 p.m. on Monday, November 11, 2013.
 | The paydate is Friday, November 29, 2013.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rev. [NAME]
Spreadsheet: 96778d1296065866-bridge-scoring-problem-760102-bridge-score
Sheet: Win

 |  | Number of Players
 | Place | 4 | 8 | 12 | 16 | 20
 | 1 | 0.75 | 1.25 | 1.75 | 2.25 | 2.75
 | 2 |  | 0.5 | 0.75 | 1 | 1.25
 | 3 |  |  | 0.25 | 0.5 | 0.75
 | 4 | 0.25
 | 8 |  | 0.25
 | 12 |  |  | 0.25
 | 16 |  |  |  | 0.25
 | 20 |  |  |  |  | 0.25
Spreadsheet: 75170d1275681412-dynamic-charts-on-excel-sample
Sheet: Sheet1

Desc | Class | Cost
Food | A | 1
Food | B | 2
Food | C | 3
Food | D | 4
Food | E | 5
Beverage | AA | 11
Beverage | BB | 12
Beverage | CC | 13
Beverage | DD | 14
Beverage | EE | 15
Beverage | FF | 16
Travel | AAA | 21
Travel | BBB | 22
Travel | CCC | 23
Travel | DDD | 24
Travel | EEE | 25
Travel | FFF | 26
Travel | GGG | 27