tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 726919d1617607355-how-to-copy-value-against-similar-description-test-2
Sheet: Sheet2

 |  | Values
Style Name / Number | Color | Sum of 6/12M | Sum of 12/18M | Sum of 18/24M | Sum of 2-3 Y | Sum of 3-4 Y | Sum of 5-6 Y | Sum of 7-8 Y | Sum of 8-9 Y | Sum of 9-10 Y | Sum of 11-12 Y | Sum of 13-14 Y
121-0777IB408-1 | MULTI | 140 | 280 | 280 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
121-0777TG481-1 | BLACK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 103 | 206 | 206 | 206
121-0777WIB28-1 | GREY MELANGE | 134 | 268 | 268 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
121-0777WIB37-1 | BLEACH MELANGE | 124 | 248 | 248 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
121-0777WIB40-1 | BLEACH MELANGE | 132 | 264 | 264 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
121-0777WIB41-1 | BLEACH MELANGE | 143 | 286 | 286 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
121-0777WIB42-1 | BLEACH MELANGE | 124 | 248 | 248 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
121-0777WIB43-1 | IVORY | 124 | 248 | 248 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
121-0777WKB45-1 | MULTI | 0 | 0 | 0 | 150 | 225 | 225 | 150 | 0 | 0 | 0 | 0
121-0777WKB52-1 | GREY MELANGE | 0 | 0 | 0 | 154 | 231 | 231 | 154 | 0 | 0 | 0 | 0
Grand Total |  | 921 | 1842 | 1842 | 304 | 456 | 456 | 304 | 103 | 206 | 206 | 206
Spreadsheet: 377800d1424174147-assign-values-from-one-collumn-to-another-example1
Sheet: Sheet2

Number | Value
1 | Value1 |  | <- Both colums filled automatically with data from Sheet1
2 | Value2 |  | <- Both colums filled automatically with data from Sheet1
3 | Value3 |  | <- Both colums filled automatically with data from Sheet1
4 | Value4 |  | <- Both colums filled automatically with data from Sheet1
5 | Value5 |  | <- Both colums filled automatically with data from Sheet1
6 | Value6 |  | <- Both colums filled automatically with data from Sheet1
7 | Value7 |  | <- Both colums filled automatically with data from Sheet1
8 | Value8 |  | <- Both colums filled automatically with data from Sheet1
Spreadsheet: 0f1f7833-0537-44d1-a158-126a5c6b18b8
Sheet: T60

الجدول 60: نسبة الذكور الى الإناث لوفيات الرضع المسجلة، 2000-2012
Table 60: Sex ratio for registered infant deaths, 2000-2012
Country | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | البلد
Bahrain |  |  |  |  |  |  |  |  |  |  | … | … | … | البحرين
Egypt |  |  |  |  |  |  |  |  |  |  |  |  | … | مصر
Iraq | ... | ... |  |  |  |  |  |  |  |  |  | … | … | العراق
Jordan | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | … | … | الأردن
Kuwait |  |  |  |  |  |  |  |  |  |  |  |  | … | الكويت
Lebanon | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | … | … | لبنان
Libya | … | … | … | … | … | … | … | … | … | … | … | … | … | ليبيا
Morocco | … | … | … | … | … | … | … | … | … | … | … | … | … | [NAME]
Oman |  |  |  |  |  |  |  |  |  |  |  |  | … | عمان
Palestine* |  |  |  |  |  |  |  |  |  |  |  |  | … | فلسطين*
Qatar |  |  |  |  |  |  |  |  |  |  |  |  | … | قطر
Saudi Arabia |  |  |  |  |  |  |  |  |  |  | … | … | … | المملكة العربية السعودية
Sudan | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | … | … | السودان
Syrian Arab Republic | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | … | … | الجمهورية العربية السورية
Tunis | … | … | … | … | … | … | … | … | … | … |  | … | … | تونس
United Arab Emirates |  |  |  | … | … |  |  |  |  |  |  | … | … | الإمارات العربية المتحدة
Yemen | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | … | … | اليمن
* data for the years 2008-2009-2010 & 2011 include West Bank only and excludes Gaza Strip. |  |  |  |  |  |  |  |  |  |  |  |  |  | * بيانات السنوات 2008، 2009 - 2010 و2011 [NAME] فقط ولا تشمل قطاع غزة.
sex ratio = male / female *100
Spreadsheet: 859257d1707720806-conference-room-calendar-sample-241-aligw
Sheet: Sheet1

 |  |  |  | Scheduler
 |  |  |  | Room No. | Date | Time From | Time To | Requested By | Remarks ( FOR)
 |  |  |  | R1 | 2024-02-06 00:00:00 | 12:30:00 | 13:00:00 | CVSP | MEETING
 |  |  |  | R1 | 2024-02-06 00:00:00 | 09:00:00 | 14:00:00 | JCKL | MEETING
 |  |  |  | R2 | 2024-02-06 00:00:00 | 14:00:00 | 14:30:00 | RYR | MEETING
 |  |  |  | R1 | 2024-02-06 00:00:00 | 10:00:00 | 14:00:00 | JCKL | MEETING
 |  |  |  | R1 | 2024-02-06 00:00:00 | 08:00:00 | 12:00:00 | RSPM | MEETING
 |  |  |  | R1 | 2024-02-06 00:00:00 | 13:00:00 | 14:00:00 | RYR | MEETING
 |  |  |  | R1 | 2024-02-07 00:00:00 | 09:30:00 | 10:00:00 | RYR | MEETING
 |  |  |  | R1 | 2024-02-07 00:00:00 | 07:30:00 | 11:00:00 | CVSP | MEETING
 |  |  |  | R1 | 2024-02-07 00:00:00 | 08:00:00 | 12:00:00 | CVSP | MEETING
 |  |  |  | R1 | 2024-02-07 00:00:00 | 07:00:00 | 08:00:00 | CVSP | MEETING
 |  |  |  |  |  |  |  |  |  | Calendar
 |  |  |  |  |  |  |  |  |  | 2024-02-06 00:00:00 | 2024-02-07 00:00:00
 |  |  |  |  |  |  |  |  |  | • R1 09:00AM to 02:00PM - JCKL MEETING | • R1 07:30AM to 11:00AM - CVSP MEETING
 |  |  |  |  |  |  |  |  |  | • R1 10:00AM to 02:00PM - JCKL MEETING | • R1 08:00AM to 12:00PM - CVSP MEETING
 |  |  |  |  |  |  |  |  |  | • R1 12:30PM to 01:00PM - CVSP MEETING | • R1 09:30AM to 10:00AM - RYR MEETING
 |  |  |  |  |  |  |  |  |  | • R1 01:00PM to 02:00PM - RYR MEETING
 |  |  |  |  |  |  |  |  |  | • R2 02:00PM to 02:30PM - RYR MEETING
Spreadsheet: 868585d1715275511-need-help-creating-a-formula-to-calculate-unit-goals-novice-yearly-review-etaf
Sheet: Tech Efficiency

Technician Yearly Review | Employee Name: | Technician Level : Apprentice/C | Location: | Hire Date: 6.23.23 | Review Date:
Efficiency Summary:
Year 23/24 | Worked Hrs | [NAME] (Target 160) | [NAME] -/+ | Actual Billable Labor $ | [NAME] @ $125 hr based on 160 hour target
Jan (24) | 165 | 91 |  | 5500
Feb (24) | 165 | 128 |  | 7900
March (24) | 162 | 135 |  | 10650
April (24) | 169 | 130 |  | 10050
May
June
July | 122 | 60 |  | 2800
Aug | 184 | 123 |  | 9300
Sept (23) | 157 | 117 |  | 8500
Oct (23) | 163 | 131 |  | 9980
Nov (23) | 162 | 124 |  | 9227
Dec (23) | 154 | 134 |  | 10500
Comeback Summary:
Year 23/24 | MTD Comback Total | MTD Loss Total $
Jan (24)
Feb (24)
March (24)
April (24)
May
June
July
Aug
Sept (23)
Oct (23)
Nov (23)
Dec (23)
Attendence Summary:
Year 23/24 | Unexcused Absence | Tardy | No Call No Show
Jan (24)
Feb (24)
March (24)
April (24)
May
June
July
Aug
Sept (23)
Oct (23)
Nov (23)
Dec (23)
Spreadsheet: 716420d1612201031-do-sum-at-a-time-when-selecting-whole-column-name
Sheet: After

 | NAME | VALUE
 | FG | 45
 | BF | 12
 | VB | 89
 | RT | 23
 | FG | 89
 | RT | 54
 | [NAME] | 12
 | BN | 22
 | MK | 65
 | E | 89
 | RT | 54
 | YU | 12
 | VN | 45
Spreadsheet: 714801d1611376826-how-to-calculate-exeact-sum-and-using-formula-calculation-sum-and-
Sheet: Sheet1

 | % | Total | Count | Total Rent | Rent for CC | Sum() | Diff.
 | 0.2424242424242424 |  | 1
 | 0.2121212121212121 |  | 1
 | 0.1515151515151515 |  | 1
 | 0.0303030303030303 |  | 1
 | 0.0303030303030303 |  | 1
 | 0.1212121212121212 |  | 1
 | 0.1515151515151515 |  | 1
 | 0.06060606060606061 |  | 1
 |  |  | 1 Total | 125
 | 0.5 |  | 2
 | 0.5 |  | 2
 |  |  | 2 Total | 1001
 | 0.09523809523809523 |  | 3
 | 0.4761904761904762 |  | 3
 | 0.04761904761904762 |  | 3
 | 0.2380952380952381 |  | 3
 | 0.1428571428571428 |  | 3
 |  |  | 3 Total | 127
Spreadsheet: 879082d1726514617-matching-2-table-book99
Sheet: Sheet1

 |  |  |  | Table1 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 |  | Table2 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
 |  |  |  | A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | A
 |  |  |  | B | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |  | B
 |  |  |  | C | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | C
 |  |  |  | D | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 |  | D
 |  |  |  | E | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 |  | E
 |  |  |  | F | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 |  | F
 |  |  |  | G | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 |  | G
Spreadsheet: 820687d1678243022-select-from-drop-down-then-apply-certain-value-to-another-cell-sample-38-
Sheet: Sheet1

Name:
Address:
Phone:
[NAME]:
 | House | Select |  |  |  |  |  | House
#Bundles Starter |  |  | 50 |  |  | [NAME]
#Pieces Drip |  |  | 8 |  |  | Drip Edge
#Vented Drip |  |  | 30 |  |  | Vented Drip
#[NAME] |  |  | 90 |  |  | Rhino
#[NAME] |  |  | 130 |  |  | Peel & Seal
#Topshield Base |  |  | 130 |  |  | Peal & Seal Base
#Sq. EPDM |  |  | 500 |  |  | EPDM
# [NAME]?
#[NAME]
#Rolls IceGuard |  |  | 100 |  |  | [NAME]
#Step Flashing |  |  | 60 |  |  | Step Flashing
#Sheets OSB |  |  | 60 |  |  | 7/16 OSB
#Skylights |  |  | 500 |  |  | Skylights
#[NAME] |  |  | 150 |  |  | Flashing Kits
#[NAME] |  |  | 11 |  |  | Pipe Boots
#[NAME] |  |  | 18 |  |  | Box Vents
#[NAME] 30' w/nails |  |  | 90 |  |  | Ridge Vents
#Staples |  |  | 8 |  |  | Staples
#Boxes 1-3/4" |  |  | 77 |  |  | Nails for [NAME]
#Boxes 1-1/4" |  |  | 62 |  |  | Nails
#Boxes 2-3/8" |  |  | 50 |  |  | Framing Nails
#[NAME] |  |  | 8 |  |  | Solar Seal
#[NAME] |  |  | 40 |  |  | Bath Vents
 | House |  |  |  |  |  |  | House
LABOR |  |  |  |  | LABOR TOTAL |  | $
DUMPSTER | [NAME] |  | # OF | 1 | DUMPSTER |  | $
 |  |  | DUMPSTERS
Notes |  |  |  |  | MATERIAL |  | $
[NAME]? |  |  |  |  | TAX |  | $
 |  |  |  |  | ROOF ORDER |  | $
Color of Drip | Select | Select |  |  | SUB TOTAL |  | $
# of Chimneys |  |  |  |  | TRANS FEE 3.0% |  | $
# of Squares |  |  |  |  | PERMIT FEE |  | $
$ per Square |  |  |  |  | TOTAL COST |  | $
# of Squares
$ per Square
#Sq of P&S
#Sq EPDM
Misc $ Amount
 | House
 |  |  |  |  | ESTIMATE |  | House
Job Site |  |  |  |  |  |  |  | Platinum
Address
 |  |  |  |  | TOTAL
Service Finance Options
Plan # | [NAME] |  |  | Interest Rate |  | Fee | Monthly Pmt
2006 | 6 Months SAC No Interest No Payments |  |  | 24.99 / 72 after |  |  | 72 Month Term
2012 | 12 Months SAC No Interest No Payments |  |  | 24.99 / 72 after |  |  | 72 Month Term
2018 | 18 Months SAC No Interest No Payments |  |  | 24.99 / 72 after |  |  | 72 Month Term
3036 | 36 Months No Interest 36 Equal Pmts |  |  | 0
3060 | 60 Months No Interest 60 Equal Pmts |  |  | 0 |  |  |  | All Financing
4398 | 3 Months NINP / 60 Months |  |  | 0.0699 |  |  |  | based on
4316 | 3 Months NINP / 120 Months |  |  | 0.0699
4012 | 84 Months Standard |  |  | 0.1299 |  | 0 |  | Credit Approval
4132 | 120 Months Standard |  |  | 0.0999 |  | 0
4632 | 6 Months NINP / 120 Months |  |  | 0.0999
4107 | 180 Months Standard |  |  | 0.0999
Spreadsheet: 880969d1728868610-can-a-pivot-table-be-tweaked-to-produce-user-defined-results-which-may-not-be-normal-pkg-data-maheshk5277-
Sheet: expected results

L1_SITE_NAME | L1_PRODUCT_NAME | [NAME] | L1_SKU NUMBER | L3_COMPONENT_SUB_TYPE | L3_PACKAGING MATERIAL DESCRIPTION
Site 1 | VAL | Valaciclovir | P-132327-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 1 | VAL | Valaciclovir | P-132328-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 1 | VAL | Valaciclovir | P-132333-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 2 | VAL | Valaciclovir | P-132352-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 2 | VAL | Valaciclovir | P-132353-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 2 | VAL | Valaciclovir | P-132369-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 3 | VAL | Valaciclovir | P-132463-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 4 | VAL | Valaciclovir | P-132327-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 4 | VAL | Valaciclovir | P-132328-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 4 | VAL | Valaciclovir | P-132333-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 4 | VAL | Valaciclovir | P-132352-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 4 | VAL | Valaciclovir | P-132353-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 5 | VAL | Valaciclovir | P-1 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
L1_SITE_NAME | L1_PRODUCT_NAME | [NAME] | L1_SKU NUMBER | L3_COMPONENT_SUB_TYPE | L3_PACKAGING MATERIAL DESCRIPTION
Site 1 | VAL | Valaciclovir | P-132327-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 1 | VAL | Valaciclovir | P-132327-01 | Film | PVC 300
Site 1 | VAL | Valaciclovir | P-132328-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 1 | VAL | Valaciclovir | P-132328-01 | Film | PVC 300
Site 1 | VAL | Valaciclovir | P-132333-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 1 | VAL | Valaciclovir | P-132333-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
…
…
Spreadsheet: 47493d1246520107-vlookup-logoff
Sheet: Sheet2

Name | PID | PTL | OTS
Renomeron, [NAME] | 1981 | [NAME] | [NAME]
FACTORA, MARIA LUISA | 2775 | [NAME] | [NAME]
UY, ROZANNE MICHELL | 3150 | [NAME] | [NAME]
BISNAR, [NAME] | 3246 | [NAME] | [NAME]
DIMACALI, [NAME] | 3277 | [NAME] | [NAME]
ANSUS, EARL EDWARD | 3297 | [NAME] | [NAME]
IGONIA, MANUELITO | 3365 | [NAME] | [NAME]
BARBACENA, ARNEL | 3498 | [NAME] | [NAME]
CABALLES, ARLENE | 3639 | [NAME] | [NAME]
CAABAY, [NAME] | 3640 | [NAME] | [NAME]
OLANDRES, MARIA | 3652 | [NAME] | [NAME]
ANG, PAMELA MARIE | 3728 | [NAME] | [NAME]
DE GUZMAN, EVA CAMILLE | 3738 | [NAME] | [NAME]
SAN PEDRO, CHARLSON | 3753 | [NAME] | [NAME]
DABU, DEMIAR DOMINIC | 3703 | [NAME] | [NAME]
CAPOTE, SENIELYN | 1834 | [NAME] | [NAME]
BLANCO, KATHERINE | 1823 | Gracie | [NAME]
[NAME], SHERYL ROYALEEN | 1839 | Gio | [NAME]
Spreadsheet: 802014d1666592000-transpose-multiple-values-for-each-name-excel-forum-24-october
Sheet: Sheet1

Names | Given values |  | display values for every name and include duplicates
souad | 2 |  | 2 | 3
jinan | 3 |  | 3
hasan | 1 |  | 1 | 2 | 1
walid | 3 |  | 3 | 2
kenan | 3 |  | 3
hanan | 5 |  | 5
hasan | 2 |  | 1 | 2 | 1
walid | 2 |  | 3 | 2
katia | 5 |  | 5
[NAME] | 2 |  | 2
souad | 3 |  | 2 | 3
jamal | 4 |  | 4
hasan | 1 |  | 1 | 2 | 1
Spreadsheet: 23628d1213198651-formatting-permanent-closing-report-sample
Sheet: JAN

 |  |  |  |  |  | Permanent Closing Report
 |  |  |  |  |  | 2008-01-01 00:00:00
Community | Lot | Buyer | Contract Date | Contingent Contract | Scheduled Closing Date | Scheduled Closing Time | Closing Attorney | Actual Closing Date | Closed | Recording Date | Contract Price | Contract Closing Date | General Comments
ABL | 1 | Smith | 2008-01-21 00:00:00
ABL | 2 | Henderson
 |  |  |  |  |  | 2000-01-01 00:00:00
 |  |  |  |  |  | 2090-01-01 00:00:00
Spreadsheet: 751440d1634117494-formula-to-automatically-update-for-every-nth-column-urc-tracker
Sheet: Dashboard

 | Week 1 |  | Week2 |  | Week3 |  | Week4 |  | Week5 |  | Week6 |  | Week7 |  | Week8 |  | Week9 |  | Week10 |  | Week11 |  | [NAME] |  | Week13 |  | Week14 |  | Week15 |  | Week16 |  | Week17 |  | Week18 |  | Week19 |  | Week20 |  | Week21 |  | Week22
[NAME]
Wooden Spoon
Worst Drop | N /A
Best Climb | N/A
Best TDM
Worst TDM
Most Bonus points
GSP Points | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 3 |  | 4
Most Margin Points
Count Best
Count Second
Total Bonus Points
Players with [NAME] | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1 |  | 2
Highest points in round
Record points this season
Leader for Most Bonus Points Prize
Leader for Best TDM Prize
Leader for GSP Prize
Leader fo GSP tie Breaker
Most Yellow Caps
Most Wooden Spoons
Record Margin Points
Lowest Score in round
Record Lowest score
Spreadsheet: 2c64c6ae-3651-41c1-a6ac-a530f053b102
Sheet: Časová osa

Row Labels | Sum of Marže
Ales Ruzicka | 599125.6000000002
Alois Geza | 274948.8000000002
[NAME] | 150136.0000000002
[NAME] | 768373.1000000001
[NAME] | 439451.5000000001
[NAME] | 486705.4000000001
[NAME] | 416560.1000000002
[NAME] | 256879.8
Karel Vymetal | 432685.1999999995
[NAME] | -83798.40000000014
Marek Novorad | 287760.0000000005
[NAME] | 128829.6000000001
Petr Dorazil | 772979.4500000003
[NAME] | 717404.5
Grand Total | 5648040.650000002
Spreadsheet: 79261d1279552087-date-and-time-display-in-pivot-table-dummy_pvt
Sheet: Sheet1

Vendor # / Name | Data | Total
1501      HERITAGE BAG CO | Count of Variance | 1
 | Average of Num Var | 2.806249999994179 |  |  | I want to display this in the same format as in data
2182      R3/BUNZL DISTRIBUTION | Count of Variance | 1
 | Average of Num Var | 1.286111111112405 |  |  | (# hour(s) # min(s) Late/Early/On-Time)
22179      NEW WINCUP HOLDINGS | Count of Variance | 1
 | Average of Num Var | 0.09583333333284827
24024      RALCORP FRZ BAKERY/BAKERY CHEF | Count of Variance | 1
 | Average of Num Var | 1.288194444445253
2841      CLUB CHEF INC | Count of Variance | 1
 | Average of Num Var | 0.9722222222262644
38112      DOT FOODS/SPECIAL ORDER DRY | Count of Variance | 1
 | Average of Num Var | -0.03333333333284827
3812      BAY STATE MILLING CO. | Count of Variance | 1
 | Average of Num Var | 0.006249999998544808
53856      GRANT COUNTY FOODS | Count of Variance | 1
 | Average of Num Var | 0.9715277777795563
5787      CASTELLINI COMPANY | Count of Variance | 1
 | Average of Num Var | 0.9722222222262644
59196      HAUSBECK PICKLES/SUBWAY | Count of Variance | 1
 | Average of Num Var | 1.286805555559113
66688      JOHN KEELER & CO INC | Count of Variance | 1
 | Average of Num Var | 0.01041666666424135
6820      R3/BUNZL-SPEC ORDER | Count of Variance | 1
 | Average of Num Var | 1.286111111112405
91334      MILLARD FROZEN SUBWAY | Count of Variance | 1
 | Average of Num Var | 0.00972222222480923
Total Count of Variance |  | 13
Total Average of Num Var |  | 0.8429487179494642
Spreadsheet: 155091d1336666886-excel-2007-subtract-a-date-range-on-around-or-within-another-date-range-working-copy
Sheet: Sheet1

 |  |  |  | Q1 |  |  |  | Q2 |  |  |  | Q3 |  |  |  | Q4 |  |  |  | Leaves |  |  |  | Days Absent
FM/SM |  | Program | Name | Training Level | Start Date | End Date | Days | Training Level | Start Date | End Date | Days | Training Level | Start Date | End Date | Days | Training Level | Start Date | End Date | Days | Leave | Type | Start Date | End Date | Q1 | Q2 | Q3 | Q4 | Q1 TOTAL | Q2 TOTAL | Q3 TOTAL | Q4 TOTAL
 |  |  | [NAME] |  | 2012-04-01 00:00:00 | 2012-06-30 00:00:00 |  |  | 2012-07-01 00:00:00 | 2012-09-30 00:00:00 |  |  | 2012-10-01 00:00:00 | 2012-12-31 00:00:00 |  |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 |  |  | Sick | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 31 | 0 | 0 | 0
 |  |  | [NAME] |  | 2012-04-01 00:00:00 | 2012-06-30 00:00:00 |  |  | 2012-07-01 00:00:00 | 2012-09-30 00:00:00 |  |  | 2012-10-01 00:00:00 | 2012-12-31 00:00:00 |  |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 |  |  | Personal | 2012-06-01 00:00:00 | 2012-08-01 00:00:00 | 30 | 62 | 0 | 0
 |  |  | Kelly |  | 2012-04-01 00:00:00 | 2012-06-30 00:00:00 |  |  | 2012-07-01 00:00:00 | 2012-09-30 00:00:00 |  |  | 2012-10-01 00:00:00 | 2012-12-31 00:00:00 |  |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 |  |  | Maternity | 2012-11-01 00:00:00 | 2013-02-01 00:00:00 | 0 | 0 | 61 | 32
 |  |  | Cathy |  | 2012-04-01 00:00:00 | 2012-06-30 00:00:00 |  |  | 2012-07-01 00:00:00 | 2012-09-30 00:00:00 |  |  | 2012-10-01 00:00:00 | 2012-12-31 00:00:00 |  |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 |  |  | Vacation | 2012-12-01 00:00:00 | 2013-05-01 00:00:00 | 0 | 0 | 31 | 90
Spreadsheet: lisa_gang__22301__ENA_PGE_MAY 17-18_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 5/17-18/2002
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  |  | Total In To PGE Trans
0100 |  |  |  |  | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0 | 0
0700 | 25 | 25 | 25 | 25 | 25 | 25
0800 | 25 | 25 | 25 | 25 | 25 | 25
0900 | 25 | 25 | 25 | 25 | 25 | 25
1000 | 25 | 25 | 25 | 25 | 25 | 25
1100 | 25 | 25 | 25 | 25 | 25 | 25
1200 | 25 | 25 | 25 | 25 | 25 | 25
1300 | 25 | 25 | 25 | 25 | 25 | 25
1400 | 25 | 25 | 25 | 25 | 25 | 25
1500 | 25 | 25 | 25 | 25 | 25 | 25
1600 | 25 | 25 | 25 | 25 | 25 | 25
1700 | 25 | 25 | 25 | 25 | 25 | 25
1800 | 25 | 25 | 25 | 25 | 25 | 25
1900 | 25 | 25 | 25 | 25 | 25 | 25
2000 | 25 | 25 | 25 | 25 | 25 | 25
2100 | 25 | 25 | 25 | 25 | 25 | 25
2200 | 25 | 25 | 25 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24711 | BPA(G)24718 | BPA(G)24727 | BPA(G)24771 | BPA(G)24547 | BPA(G)24547
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AEP | AEP | AEP | AEP | AEP | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP | AEP | AEP
 | CDWR | CDWR | TID | MORGAN | PUGET | MORGAN
 | ISO(T)MALIN/NP15 | ISO(T)MALIN/NP15 | TID(T)CPJK/TRACEY/WESLEY | SNCL | EPME | PUGET
 | CDWR(L,FS)NP15 (CA) | CDWR(L,FS)NP15 (CA) | TID | ISO(T)MALIN/NP15 | ISO(T)MALIN/NP15 | SNCL
 |  |  | TID(L)WESLEY | SNCL(L)NP15 | EPME(L)NP15 | ISO(T)MALIN/NP15
 |  |  |  |  |  | SNCL(L)NP15
Spreadsheet: 761920d1641301040-linking-excel-sheets-time-sheet-ceredigion-master
Sheet: FRONT

 |  |  |  |  |  | Welsh Ambulance Services NHS Trust - Ceredigion EMS Staff Time Sheet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Authorised by [NAME] 22/06/2021 Timesheet 0/6
 |  |  |  |  |  | PIN No |  |  |  |  | NAME |  |  |  | Pay No: |  |  |  |  |  | Contract  Hours:
 |  |  |  |  |  |  | 3
 |  |  |  |  |  | Station: |  |  |  |  |  |  |  | Month |  | 2021-12-01 00:00:00 |  |  |  |  |  | Rota No.
 |  |  |  |  |  |  |  |  | Hours of Normal Duty or Non-Attendance |  |  |  |  | USH Mon-Sat | USH  Sun / BH | Meal Breaks |  | Overtime (OT) / Time Off in Lieu (TOIL) |  |  |  |  |  |  |  |  | On Call |  | Acting up hrs / Remarks / Promis Ref. No.
 |  |  |  |  |  | Day | Date | B/H | Shift Code | Shift Times | [NAME]. | Abs. Code | Abs. Hours | Lower | Higher | Avail | Dist | Stn Code | From | To | [NAME]. | T x 1 | T x 1.5 | B-Hol T x 2 | Over-runs | Pay Toil  B/HOL | Stdby/ Oncall | Resp All | Hrs | Remarks / Promis Ref. No.
 |  |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  | Totals
 |  |  |  |  |  |  |  |  |  | A/L Hrs Taken: |  |  |  | Mon-Sat USH Lower | Sun/BH USH Higher | Meal breaks |  |  |  |  |  | Total Toil Hrs Accumulated |  |  |  |  | On Call | Resp | Acting Up Hours
 |  |  |  |  |  | Sickness Hours: |  |  |  | [NAME]: |  |  |  |  |  | Avail | Dist
 |  |  |  |  |  | Industrial Injury: |  |  |  | Other: |  |  |  |  |  |  |  | Overtime hours to be paid