tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 112316d1308478040-2-data-validation-cells-with-vlookup-fpg-trial-2011-12
Sheet: TEAMS

 | PREMIER LEAGUE |  | CHAMPIONSHIP |  | LEAGUE ONE |  | LEAGUE TWO |  | PLAYERS
1 | Arsenal | 1 | Barnsley | 1 | AFC Bournemouth | 1 | Accrington Stanley | 1 | PLAYER 1 |  | V
2 | [NAME] | 2 | Birmingham City | 2 | Brentford | 2 | Aldershot Town | 2 | PLAYER 2 |  | -
3 | [NAME] | 3 | Blackpool | 3 | Bury | 3 | Barnet | 3 | PLAYER 3
4 | [NAME] | 4 | [NAME] and Hove Albion | 4 | Carlisle United | 4 | Bradford City | 4 | PLAYER 4
5 | Chelsea | 5 | Bristol City | 5 | [NAME] | 5 | Bristol Rovers | 5 | PLAYER 5
6 | Everton | 6 | Burnley | 6 | Chesterfield | 6 | [NAME] | 6 | PLAYER 6
7 | Fulham | 7 | Cardiff City | 7 | Colchester United | 7 | [NAME] | 7 | PLAYER 7
8 | Liverpool | 8 | Coventry City | 8 | Exeter City | 8 | [NAME] | 8 | PLAYER 8
9 | Manchester City | 9 | Crystal Palace | 9 | Hartlepool United | 9 | [NAME] and [NAME] | 9 | PLAYER 9
10 | [NAME] | 10 | Derby County | 10 | Huddersfield Town | 10 | [NAME] | 10 | PLAYER 10
11 | Newcastle United | 11 | Doncaster Rovers | 11 | Leyton Orient | 11 | Hereford United
12 | Norwich City | 12 | Hull City | 12 | [NAME] | 12 | AFC Wimbledon
13 | Queens Park Rangers | 13 | Ipswich Town | 13 | Notts County | 13 | [NAME]
14 | Stoke City | 14 | [NAME] | 14 | Oldham Athletic | 14 | Morecambe
15 | Sunderland | 15 | Leicester City | 15 | [NAME] | 15 | Northampton Town
16 | Swansea City | 16 | Middlesbrough | 16 | Rochdale | 16 | Oxford United
17 | [NAME] | 17 | Millwall | 17 | Scunthorpe United | 17 | Plymouth Argyle
18 | West Bromwich Albion | 18 | [NAME] | 18 | Sheffield United | 18 | Port Vale
19 | Wigan Athletic | 19 | Peterborough United | 19 | Sheffield Wednesday | 19 | [NAME]
20 | [NAME] | 20 | Portsmouth | 20 | Stevenage Borough | 20 | Shrewsbury Town
 |  | 21 | Reading | 21 | Tranmere Rovers | 21 | Southend United
 |  | 22 | Southampton | 22 | Walsall | 22 | Crawley Town
 |  | 23 | Watford | 23 | Wycombe Wanderers | 23 | Swindon Town
 |  | 24 | West Ham United | 24 | [NAME] | 24 | [NAME]
Spreadsheet: 173b3307-149a-4bde-81b9-2da2489ed350
Sheet: Denials 2012

MULTNOMAH COUNTY LOAN DENIAL RATES BY INCOME-RACE GROUPINGS : 2012
Home Purchase & Occupation
I.  Total Applications
Race/Ethnicity | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian | 2 | 5 | 4 | 5 | 15 | 32
Asian | 15 | 121 | 115 | 41 | 261 | 557
Black or African American | 3 | 18 | 17 | 13 | 43 | 95
Native Hawaiian or Pacific Islander | 1 | 3 | 9 | 4 | 16 | 34
White | 51 | 428 | 957 | 479 | 3021 | 4966
Hispanic | 3 | 27 | 60 | 16 | 107 | 214
Overall Total | 94 | 645 | 1242 | 607 | 3847 | 6484
II.  Total Denials
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian | 0 | 1 | 0 | 3 | 1 | 5
Asian | 3 | 19 | 12 | 10 | 20 | 65
Black or African American | 2 | 4 | 3 | 0 | 4 | 14
Native Hawaiian or Pacific Islander | 0 | 0 | 0 | 0 | 2 | 2
White | 11 | 56 | 91 | 31 | 144 | 343
Hispanic | 2 | 4 | 6 | 6 | 5 | 24
Overall Total | 22 | 86 | 115 | 52 | 189 | 479
III. Denial Rates (II/I) * 100
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian
Asian
Black or African American
Native Hawaiian or Pacific Islander
White
Hispanic
Overall Total
Source: HMDA (LAR)
Note: Data reported here is for Multnomah County. These are loans for the purpose of purchasing a home. The loans are for homes that are meant for a primary occupancy of the owner. These are all represented for conventional loans. For ethnic and racial breakout, these are loans originated by households where either the applicant or co-applicant are representative of that group.
Spreadsheet: 622880d1556967556-create-one-master-list-from-lists-on-multiple-worksheets-excel-forum-example-create-one-list-from-multiple-sheets
Sheet: List 1

Status | S/G | Item Description | Item No. | Serial No. | Type | Own Depot | Curr Depot
In Repair | 101336 | List 1 Description 1 | 72193 |  | Customer | SIN | SIN
In Repair | 100637 | List 1 Description 2 | 125823 |  | Customer | ABE | ABE
In Repair | 100636 | List 1 Description 3 | 125824 |  | Customer | ABE | ABE
In Repair | 100609 | List 1 Description 4 | 133099 |  | Customer | ABE | ABE
In Repair | 100634 | List 1 Description 5 | 243049 |  | Customer | ABE | ABE
In Repair | 100636 | List 1 Description 6 | 243050 |  | Customer | ABE | ABE
In Repair | 100637 | List 1 Description 7 | 243051 |  | Customer | ABE | ABE
In Repair | 100635 | List 1 Description 8 | 243052 |  | Customer | ABE | ABE
In Repair | 100635 | List 1 Description 9 | 243054 |  | Customer | ABE | ABE
In Repair | 100635 | List 1 Description 10 | 243055 |  | Customer | ABE | ABE
In Repair | 100558 | List 1 Description 11 | 8842298 |  | Customer | ABE | ABE
In Repair | 100609 | List 1 Description 12 | 8843293 |  | Customer | ABE | ABE
In Repair | 100605 | List 1 Description 13 | 8843666 |  | Customer | ABE | ABE
In Repair | 100605 | List 1 Description 14 | 8844083 |  | Customer | ABE | ABE
Spreadsheet: 858187d1706914956-need-help-with-query-and-pivot-table-example-opcode-report
Sheet: Sheet1

Op Code | Induction
Date Range | 2024-02-01 00:00:00
 |  | Part#1 | part#2 | part#3 | Part#4 | Part#5
Work Order #
111512 |  | A64071 | 125487
111513 |  | A64071 | 125487
111514 |  | A64071
111515 |  | A64071
111516 |  | A64071
111517 |  | 125487
111518 |  | 125487
111519 |  | 125487
111520 |  | A64071 | 125487
111521 |  | A64071 | 125487
Spreadsheet: scott_neal__38532__Neal Short Bonds Exe
Sheet: Summary

Prepared for: | Date
Par Amount
Average Coupon
Projected Annual Income
Estimated Market Value
Accrued Interest
Total Market Value
Average Maturity ( Years )
Average Duration ( Modified )
Average Current Yield
Average Market Yield
Average Cost
Note:    Averages are weighted by market value
This proposal represents one potential scenario based on our understanding of your investment objectives and constraints. The actual portfolio that you choose may differ.  Bids/Offerings
are subject to change and/or availability and should not be considered as an offer to sell any issue.  PaineWebber Incorporated and/or Mitchell Hutchins Asset Management Inc. affiliated
companies and/or their officers, directors, employees or stockholders may at times have a position in the securities described herein. Please contact your tax advisor regarding suitability of
tax-exempt securities investments for your portfolio. Income from municipal bonds may be subject to state and  local taxes as well as the Alternative Minimum Tax. Municipal securities are
subject to gains/losses based on the level of interest rates, market conditions and credit quality of the issuer.  Zero coupon securities are more volatile than interest bearing securities.
Spreadsheet: 118387d1313650709-getting-additional-information-from-secondary-worksheet-stock-file-equations-needed
Sheet: Sheet1

 |  |  |  | this column needs to show the on hand cell for corresponding line | this column needs to show how many units have been sold in the last 3 months (combined)
 | Master Worksheet |  | Is stock present on worksheet? | Is item in stock?
 | 600768963733 | STOCK ITEM 1 |  | ? | ?
 | 600768962033 | STOCK ITEM 2
 | 600712448993 | STOCK ITEM 3
 | 600712452893 | STOCK ITEM 4
 | 600712450573 | STOCK ITEM 5
 | Worksheet 1/2/3/4/5
 |  |  | On Hand | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug
 | 600768920923 | STOCK ITEM 15 | 1 | 1 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
 | 600712459093 | STOCK ITEM 19 | 5 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 600712456493 | STOCK ITEM 20 | 6 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 600712443653 | STOCK ITEM 21 | 2 | 2 | 1 | 3 | 2 | 0 | 0 | 1 | 0 | 2 | 2 | 0 | 1
 | 600712444063 | STOCK ITEM 35 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0
 | 600712458493 | STOCK ITEM 50 | 2 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 600768963733 | STOCK ITEM 1 | 10 | 1 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
 | 509975173842 | STOCK ITEM 6 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 509975107642 | STOCK ITEM 7 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 600712459283 | STOCK ITEM 8 | 2 | 2 | 1 | 3 | 2 | 0 | 0 | 1 | 0 | 2 | 2 | 0 | 1
 | 509975107592 | STOCK ITEM 9 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0
 | 600712453723 | STOCK ITEM 10 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 531792d1501874712-index-match-by-worksheet-name-test
Sheet: JM

[NAME] |  | 2017-08-01 00:00:00 |  |  | 2017-08-02 00:00:00 |  |  | 2017-08-03 00:00:00 |  |  | 2017-08-04 00:00:00 |  |  | 2017-08-07 00:00:00 |  |  | 2017-08-08 00:00:00 |  |  | 2017-08-09 00:00:00 |  |  | 2017-08-10 00:00:00 |  |  | 2017-08-11 00:00:00 |  |  | 2017-08-14 00:00:00 |  |  | 2017-08-15 00:00:00 |  |  | 2017-08-16 00:00:00
 |  | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per
Task Group ID | Task Name
Off Premise Settlements- Volume | Emails to/ from Vendors | 1 | 5 |  | 1 | 5 |  | 1 | 5 |  | 1 | 5 |  | 1 | 5 |  | 1 | 5 |  | 1 | 1 |  | 1 | 5 |  | 1 | 5 |  | 1 | 5 |  | 1 | 5 |  | 1 | 5
Off Premise Settlements- Volume | Off Premise Incoming/ Outgoing Telephone Calls Under 0-5min | 2 | 5 |  | 2 | 5 |  | 2 | 5 |  | 2 | 5 |  | 2 | 5 |  | 2 | 5 |  | 2 | 2 |  | 2 | 5 |  | 2 | 5 |  | 2 | 5 |  | 2 | 5 |  | 2 | 5
Off Premise Settlements- Volume | ATM Replenishment Order Creation | 3 | 5 |  | 3 | 5 |  | 3 | 5 |  | 3 | 5 |  | 3 | 5 |  | 3 | 5 |  | 3 | 2 |  | 3 | 7 |  | 3 | 5 |  | 3 | 5 |  | 3 | 5 |  | 3 | 5
Off Premise Settlements- Volume | E-cash Ordering | 4 | 5 |  | 4 | 5 |  | 4 | 5 |  | 4 | 5 |  | 4 | 5 |  | 4 | 5 |  | 4 | 5 |  | 4 | 8 |  | 4 | 5 |  | 4 | 5 |  | 4 | 5 |  | 4 | 5
Off Premise Settlements- Volume | Vault Cash Ordering | 5 | 5 |  | 5 | 5 |  | 5 | 5 |  | 5 | 5 |  | 5 | 5 |  | 5 | 5 |  | 5 | 5 |  | 5 | 8 |  | 5 | 5 |  | 5 | 5 |  | 5 | 5 |  | 5 | 5
Off Premise Settlements- Volume | Number of settlement errors (monitoring) | 6 | 5 |  | 6 | 5 |  | 6 | 5 |  | 6 | 5 |  | 6 | 5 |  | 6 | 5 |  | 6 | 5 |  | 6 | 5 |  | 6 | 5 |  | 6 | 5 |  | 6 | 5 |  | 6 | 5
Off Premise Settlements- Volume | Replenishment Monitoring | 7 | 5 |  | 7 | 5 |  | 7 | 5 |  | 7 | 5 |  | 7 | 5 |  | 7 | 5 |  | 7 | 5 |  | 7 | 5 |  | 7 | 5 |  | 7 | 5 |  | 7 | 5 |  | 7 | 5
Spreadsheet: 268693d1380738047-need-threshold-alert-on-my-spreadsheet-threshold-alert
Sheet: Sheet1

Product A is in all three categories (D-F).  If the inventory level (C) is above the Category thresholds (G,H,I), I want to flag it in the corresponding inventory alert column (J,K,L).
Product B is in category 2 (E) only.  If the inventory level (C)is above Category 2 threshold (H), I want to flag it in the corresponding inventory alert column (K).
Product C is in category 2 (D) only.  If the inventory level (C) is above Category 1 threshold (G), I want to flag it in the corresponding inventory alert column (J).
Product D is in two categories (E&F).  If the inventory level (C) is above the Category thresholds (H,I), I want to flag it in the corresponding inventory alert column (K,L).
I have marked in columns J -L what I am looking for a formula to do automatically.
 | Product | Inventory Level | Cat 1 | Cat 2 | Cat 3 | Cat 1 Threshold | Cat 2 Threshold | Cat 3 Threshold | Cat 1 inventory alert | Cat 2 inventory alert | Cat 3 inventory alert
 | A | 968 | x | x | x | 100 | 500 | 1000 | track | track | ok
 | B | 462 |  | x |  | 100 | 500 | 1000 |  | ok
 | C | 826 | x |  |  | 100 | 500 | 1000 | track
 | D | 45 |  | x | x | 100 | 500 | 1000 |  | ok | ok
Ok means that it is under the threshold
Track means that it is over the threshold
Spreadsheet: 848216d1698981860-transpose-data-using-formulas-test
Sheet: Topside Output

Sno | Cluster | [NAME] | Cost Category | Adjustment Type | Spend Month (MM/DD/YYYY) | Cost Local Currency | Note
1 | PDX | PDX1 | B | Manual | 2023-10-01 00:00:00 | 100
1 | PDX | PDX1 | B | Manual | 2023-11-01 00:00:00 | 100
2 | PDX | [NAME] | B | Manual | 2023-11-01 00:00:00 | 200
2 | PDX | [NAME] | B | Manual | 2023-12-01 00:00:00 | 200
3 | SFO | SFO1 | A | Manual | 2023-12-01 00:00:00 | 300
3 | SFO | SFO1 | A | Manual | 2024-01-01 00:00:00 | 300
4 | PDT | PDT1 | A | Manual | 2024-01-01 00:00:00 | 400
4 | PDT | PDT1 | A | Manual | 2024-02-01 00:00:00 | 400
4 | PDT | PDT1 | A | Manual | 2024-03-01 00:00:00 | 400
Spreadsheet: 887369d1737609155-scraping-data-from-multiple-similar-excel-sheets-lcs
Sheet: Week2

NAMES |  |  |  | JAE | SKP | YH | SG | MA | EM | JS | AM | HB | SB | AB | PSD | SH | MY | SAF | AAA | VD | AR | SAA | HAA | AA | SHS | PN | AM | SA | MAM | AAS | SAJ | IAN | MAM | Total
Attendance |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
No. | Procedure | Total  Visits | Total Staff
1 | 1.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 1 | 4
2 | 1.2 |  |  |  |  | 3 |  | 6 |  |  |  |  |  |  |  |  | 0 |  | 1 | 1
3 | 1.3 |  |  |  |  | 1 |  | 1 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 4 |  | 1 | 4
4 | 1.4 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 0 |  | 1 | 1
5 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
6 | 1.6 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1
7 | 1.7 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Total for the week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Calculated |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 737495d1624445599-goal-seek-cant-change-dos-over-30-days-goal-seek-cant-change-dos-over-30-days
Sheet: Sheet1

 |  |  | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | CODE SAP | SKU | jun | jul | aug | sep | oct | nov | dec
 | 2250068 | 4.5 p100 cy ltc | 2601
 |  | In Transit | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PO's | 0 | 0 | 972 | 0 | 0 | 0 | 0
 |  | Requirement | 3406 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Demand | 2472 | 3535 | 2207 | 2409 | 1498 | 4470 | 2502
 |  | Ending Inventory
 |  | Days of Stock
Spreadsheet: 0165236f-cc5c-4fc9-8b20-9b4832d672fe
Sheet: Tribe spellings

Line number | Colonial | Hodge (1906)
1 | Mohocks | Mohawk
2 | [NAME] | Oneida
3 | Tuscaroras | [NAME]
4 | Onondagas | Onondaga
5 | Cayugas | Cayuga
6 | Senecas | Seneca
7 | Oswegachys | Oswegatchie
8 | Nanticokes | Nanticoke
9 | Conoys | Conoy
10 | Tuteeves | [NAME]
11 | Saponeys | Saponi
12 | Caghnawagas | Caughnawaga
13 | Canassadagas | Oka
14 | Arundacks | Adirondack
15 | Algonkins | [NAME]
16 | Abenaquis | Abnaki
17 | [NAME] | Nipissing
18 | Hurons | Huron
19 | Shawanese | Shawnee
20 | Delawares | Delaware
21 | Wiandots | Wyandot
22 | Powtewatamis | Potawatomi
23 | Ottawas | Ottawa
24 | Chipeweighs or Missisagais | [NAME] or [NAME]
25 | Meynomenys | Menominee
26 | Folsavoins | Menominee
27 | Puans | Winnebago
28 | Sakis | Sauk
29 | Foxes | Fox
30 | Twightwees | Miami
31 | Kickapous | Kickapoo
32 | Mascoutens | Mascoutens
33 | Piankashaws | Piankashaw
34 | [NAME] | Wea
35 | [NAME] | Kaskaskia
36 | Illinois | Illinois
37 | Sioux | Sioux
38 | Micmacs | Micmac
39 | Norwidgewalks | Norridgewock
40 | Arfsegunticooks | Arosaguntacook
41 | Penobscots | [NAME]
42 | St. Johns | Malecite
43 | Cherokees | Cherokee
44 | Creeks | Creek
45 | Chickasaws | Chickasaw
46 | Chactaws | Choctaw
47 | Catawbas | Catawba
48 | Beluxis | [NAME]
49 | [NAME] | [NAME]
50 | Attucapas | Attacapa
51 | [NAME] | Bayogoula
52 | Tunicas | [NAME]
53 | Peluches | [NAME]
54 | [NAME] | Ofogoula
55 | Querphas | Quapaw
Spreadsheet: 811344d1672419547-sumif-formula-lookup-3-dimensions-and-sum-total-between-two-dates-example-movers
Sheet: Sheet1

RAW DATA | Date of Sale | SKU | Colour | Product | Units Sold |  | OUTPUT NEEDED |  |  |  | Colour | Product | Units Sold
 | 2022-01-01 00:00:00 | SKU030 | Red | Dresses | 5 |  | 2022-01-03 00:00:00 | 2022-01-09 00:00:00 |  | SKU030 | Red | Dresses | 1
 | 2022-01-02 00:00:00 | SKU019 | White | Jumpsuits | 6 |  |  |  |  | SKU019 | White | Jumpsuits | 19
 | 2022-01-03 00:00:00 | SKU042 | Black | Tops | 9 |  |  |  |  | SKU042 | Black | Tops | 13
 | 2022-01-04 00:00:00 | SKU035 | Black | Jacket | 3 |  |  |  |  | SKU035 | Black | Jacket | 5
 | 2022-01-05 00:00:00 | SKU036 | Black | Blazer | 2 |  |  |  |  | SKU036 | Black | Blazer | 2
 | 2022-01-06 00:00:00 | SKU030 | Red | Dresses | 1
 | 2022-01-07 00:00:00 | SKU019 | White | Jumpsuits | 19
 | 2022-01-08 00:00:00 | SKU042 | Black | Tops | 4
 | 2022-01-09 00:00:00 | SKU035 | Black | Jacket | 2
 | 2022-01-10 00:00:00 | SKU036 | Black | Blazer | 0
 | 2022-01-11 00:00:00 | SKU030 | Red | Dresses | 2
 | 2022-01-12 00:00:00 | SKU019 | White | Jumpsuits | 1
 | 2022-01-13 00:00:00 | SKU042 | Black | Tops | 4
 | 2022-01-14 00:00:00 | SKU035 | Black | Jacket | 5
 | 2022-01-15 00:00:00 | SKU036 | Black | Blazer | 6
Spreadsheet: 298308d1392755557-find-a-value-in-a-table-with-multiple-values-test-excel-data-search-sheet
Sheet: ON-4

Date | PO # | Buyer | Division Line | Model | Trailer Description | Serial # | Build Location | Line # | Est. Delivery Date | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2014-01-01 00:00:00
Spreadsheet: 88814d1288644190-charting-date-copy-of-copy-of-book1-2
Sheet: Sheet1

 |  | Data
Years | date | Sum of val1 | Sum of val2
2010 | Jan | 28 | 4
 | Feb | 18 | 6
 | Mar | 20 | 9
 | Apr | 23 | 16
 | May | 12 | 15
 | Jun | 22 | 24
 | Jul | 9 | 21
 | Aug | 10 | 24
 | Sep | 20 | 36
 | Oct | 13 | 30
 | Nov | 14 | 44
 | Dec | 19 | 36
2011 | Jan | 15 | 3
 | Feb | 16 | 8
 | Mar | 23 | 9
 | Apr | 18 | 12
 | May | 13 | 20
 | Jun | 10 | 18
 | Jul | 23 | 28
 | Aug | 12 | 24
 | Sep | 20 | 27
 | Oct | 16 | 40
 | Nov | 17 | 33
 | Dec | 22 | 48
2012 | Jan | 13 | 3
 | Feb | 15 | 6
 | Mar | 26 | 12
 | Apr | 11 | 12
 | May | 16 | 15
 | Jun | 22 | 24
 | Jul | 28 | 21
 | Aug | 30 | 32
 | Sep | 23 | 27
 | Oct | 25 | 30
 | Nov | 17 | 44
 | Dec | 22 | 36
2013 | Jan | 18 | 3
Grand Total |  | 679 | 800
Spreadsheet: 036bff5f-8a8d-4c4c-b102-38f242678e49
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Personal Reimbursement
This payment form is designed to facilitate and expedite departmental requests for payment.
Complete the form, scan the original paperwork and e-mail to [EMAIL] for processing.
Keep a copy for department records.
Requestor's Banner Vendor
Number (V# if known):
Requestor's ID Number:
(FIN or SSN: for non-employees)
 |  |  | Check the appropriate box:
 |  |  | FIN – Federal Tax Identification Number, or         SSN – Social Security Number
Requestor's Name:
Requestor’s Address:
Requestor's Classification: |  |  | Employee |  | Student |  | Other
Business Purpose/Justification:
Total Amount: |  |  | QAR |  |  | USD
Banner Account Distribution: |  |  | Index |  | Account |  | Amount
 |  |  |  |  |  |  | QAR |  | USD
 |  |  |  |  |  |  | QAR |  | USD
 |  |  |  |  |  |  | QAR |  | USD
 |  |  |  |  |  |  | QAR |  | USD
 |  |  | *   I  HEREBY CERTIFY  THAT  EXPENSES  LISTED  ABOVE WERE INCURRED BY THE  REQUESTOR ON OFFICIAL
 |  |  | BUSINESS  OF  THE  COMMONWEALTH   OF  VIRGINIA   AND  INCLUDE  ONLY SUCH  EXPENSES  AS WERE
 |  |  | NECESSARY IN THE CONDUCT OF BUSINESS.
Requestor Signature:*
 |  |  | Signature                               Printed Name                               Date
 |  |  | **  I  HEREBY CERTIFY THAT  EXPENSES LISTED ABOVE WERE  INCURRED BY THE  REQUESTOR  ON  OFFICIAL
 |  |  | BUSINESS OF THE  COMMONWEALTH  OF VIRGINIA AND THAT THEY INCLUDE  ONLY  SUCH  EXPENSES AS
 |  |  | WERE NECESSARY IN THE CONDUCT OF  BUSINESS.  I  HAVE  EITHER VIEWED AND INSPECTED THE ITEMS
 |  |  | PURCHASED   OR  HAVE   RECEIVED  SUPPORTING  DOCUMENTATION  SUCH  AS  AN  E-MAIL   FROM  THE
 |  |  | EMPLOYEE  (OTHER THAN THE APPROVER)  VERIFYING  THAT  THE ITEMS  WERE  RECEIVED OR  USED  TO
 |  |  | CONDUCT STATE BUSINESS.
Approver Signature:**
 |  |  | Signature                               Printed Name                               Date
Department Contact:
 |  |  | Signature                                Printed Name                              Date
I have a bank account in Qatar for my deposit.
I do not have a bank account in Qatar. Please |  |  |  |  |  | AP USE ONLY
deposit to my U.S. account. |  |  |  |  | Document Number:
 |  |  |  |  | Signature:
 |  |  |  |  | Date:
Revised July 2012
Spreadsheet: 875945d1722566702-help-with-overtime-formula-overtime-example-2
Sheet: Mon-Tues. Thurs-Fri 8hr-day  

You must use the format HH:[NAME] (ie 09:00 or 17:00) when entering your time. It reformats the cell if you use any other way (ie 9 or 17 or 9.00 ect) this will change the calculations and the sheet won't be correct.
 |  | Enter start time: 24hr clock | Enter time work over lunch. ie 00:30 minuets worked | Enter finish time: 24hr clock | Hours in work | Overtime. | Enter time taken back as hours:minutes | Final running total of overtime
Date | Day | Start | Lunch | Finish | Hours | Overtime | Time taken back | Total
2024-09-16 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00
2024-09-17 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00
2024-09-18 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00 |  |  | [NAME]. Thurs-Fri 8hr-day  28 hours per Wk
2024-09-19 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00
2024-09-20 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00
2024-09-21 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00 |  |  | Use this universal formula where "0010011" represents day of week, from Monday to Sunday:
2024-09-22 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00
2024-09-23 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00 |  |  | "0" means working day and "1" means rest day.
2024-09-24 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00
2024-09-25 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00 |  |  |  | " | 0 | 0 | 1 | 0 | 0 | 1 | 1 | "
2024-09-26 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00 |  |  |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
2024-09-27 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00 |  |  | Workday |  | x | x |  | x | x
2024-09-28 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00 |  |  | Rest day |  |  |  | x |  |  | x | x
2024-09-29 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00
2024-09-30 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00 |  |  | What is the significant of 28 or 49 hours per week?
2024-10-01 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00
2024-10-02 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00
2024-10-03 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00
2024-10-04 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00
2024-10-05 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00
2024-10-06 00:00:00 |  | 9:00:00 | 0:30:00 | 20:00:00 |  |  | 0:00:00
Spreadsheet: 156777d1337449977-fill-color-automatically-changes-gap-analysis
Sheet: QM

Manual | Standard Code | Standard Requirement | Score (0 or 1 or 2 or NA) | Available Evidence | Missing Evidence | Status | Action Plan | Responsibility | Due Date
QM | 1 | There is a qualified and experienced Quality Management Director or leader who can apply quality concepts and principles and includes the following: | 2 |  |  |  |  |  | 2012-05-05 00:00:00
QM | 1.1 | The Quality Management Director has a degree in Healthcare Administration, Quality Management or Related healthcare field and/or certification in Quality Management and/or Risk Management. | 1 |  |  |  |  |  | 2012-05-23 00:00:00
QM | 1.2 | The Quality Management Director or leader has at least three years experience in Healthcare Quality Management or Improvement. | 0 |  |  |  |  |  | 2012-05-03 00:00:00
QM | 2 | The QM Director or leader reports to the Hospital Director.
QM | 3 | The QM department has the following resources (and others as needed) to carry out its scope of service.