tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 889018d1739684576-how-to-find-the-time-slot-when-all-hospitals-are-busy-aht61-emergency-room-spill-365-aligw-take2
Sheet: BusySlot

Hospital Unit | Busy StartTime | Busy StopTime | Duration (min)
A | 2024-05-13 09:05:00 | 2024-05-14 00:00:00 |  |  |  |  |  |  |  |  | 2024-05-13 09:50:00
C | 2024-05-13 09:05:00 | 2024-05-13 10:03:00 |  |  |  |  |  |  |  | 2025-01-25 20:34:59.995000 | 2025-01-25 22:19:59.995000
B | 2024-05-13 09:05:00 | 2024-05-14 12:35:00 |  |  |  |  |  |  |  | 2025-01-26 00:04:59.995000 | 2025-01-26 01:19:59.995000
C | 2024-05-23 14:50:00 | 2024-05-23 14:50:00 |  |  |  |  |  |  |  | 2025-02-09 01:04:59.995000 | 2025-02-09 02:19:59.995000
A | 2024-05-24 12:00:00 | 2024-05-24 12:15:00
A | 2025-02-09 00:57:01 | 2025-02-09 02:21:00
B | 2025-02-09 00:57:01 | 2025-02-09 06:21:00
C | 2025-02-09 00:57:01 | 2025-02-09 05:21:00
A | 2024-05-31 20:55:00 | 2024-06-01 06:30:00
C | 2024-05-31 11:54:00 | 2024-06-01 00:00:00
A | 2024-05-31 01:38:00 | 2024-05-31 05:04:00
A | 2024-06-03 17:39:00 | 2024-06-03 21:01:00
C | 2024-06-04 10:12:00 | 2024-06-05 00:00:00
A | 2024-06-05 23:16:00 | 2024-06-06 06:53:00
A | 2024-06-04 19:48:00 | 2024-06-04 20:56:00
C | 2024-06-04 16:41:00 | 2024-06-04 19:03:00
A | 2024-06-06 21:01:00 | 2024-06-07 04:34:00
B | 2024-06-05 08:16:00 | 2024-06-05 10:00:00
B | 2024-06-05 09:11:00 | 2024-06-05 21:21:00
A | 2025-01-25 05:21:00 | 2025-01-25 18:49:00
B | 2025-01-25 11:21:00 | 2025-01-25 19:44:00
C | 2025-01-25 20:00:00 | 2025-01-26 05:33:00
B | 2025-01-25 20:31:00 | 2025-01-26 01:33:00
A | 2025-01-25 22:23:00 | 2025-01-26 07:56:00
A | 2025-01-25 10:52:00 | 2025-01-25 23:50:00
Spreadsheet: 714082d1611082772-chart-tool-being-used-as-an-ongoing-timeline-but-unable-to-view-scroll-beyond-january-timeline-chart-tool-delivery-plotting-eb
Sheet: Project Timeline

 |  | Emilx [NAME] of…
 |  | Chart showing project activities with a scrollable timeline is in this cell.
 |  | ENTER START DATE: | 2021-01-04 00:00:00
 | Id | ACTIVITY | START | END | NOTES | Owner | Channel
 |  | Report Launch Phase | 2021-01-04 00:00:00 | 2021-01-19 00:00:00 | Launching the report for the Future of… campaign | All
 |  | [NAME] report launch | 2021-01-04 00:00:00 | 2021-01-11 00:00:00 | Report approved and ready to go live | [NAME]
 |  | Internal launch story | 2021-01-11 00:00:00 | 2021-01-13 00:00:00 | Monday headline news story | [NAME] Brookes | Intranet
 |  | JG Social launch | 2021-01-11 00:00:00 | 2021-01-11 00:00:00 | LinkedIn and Twitter posts from [NAME] - to camera video piece | [NAME] | Social Media
 |  | .co.uk landing page | 2021-01-11 00:00:00 | 2021-01-11 00:00:00 | .co.uk live with report at 15:00pm - Looking to the Future | [NAME] | .co.uk
 |  | PR report launch | 2021-01-04 00:00:00 | 2021-01-11 00:00:00 | Mail on Sunday - 4th / Ian King Live (Sky) interview 11th at 10:20am | Eden Black | PR
 |  | Future of Work | 2021-02-01 00:00:00 | 2021-03-31 00:00:00 | Dates to be confiemed | All
 |  | Future of Home | 2021-04-01 00:00:00 | 2021-05-29 00:00:00 | Dates to be confiemed | All
 |  | Future of Community | 2021-05-31 00:00:00 | 2021-07-31 00:00:00 | Dates to be confiemed | All
 |  | Future of Wellbeing | 2021-08-02 00:00:00 | 2021-10-31 00:00:00 | Dates to be confiemed | All
 |  | Project End | 2021-12-31 00:00:00 | 2021-12-31 00:00:00
Spreadsheet: 102593d1300535158-excel-2007-combining-two-data-sets-to-make-a-report-sample
Sheet: Material List

Material | Material Type | Material Model | Import Allowed
AAA-001 | LCD | FY09 | No
AAA-002 | LCD | FY10 | Yes
AAA-003 | LCD | FY11 | Yes
AAB-001 | LCD-3D | FY11 | Yes
BAA-001 | LED | FY10 | Yes
CAA-001 | Analog | FY07 | No
CAA-002 | Analog | FY08 | No
CAA-003 | Analog | FY09 | No
Spreadsheet: 5c4a2499-f100-49c1-9ac0-2cf99e785fb5
Sheet: Sheet1

Finanční vyúčtování dotace | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
PŘÍJEMCE                                                               (jméno a příjmení/název/obchodní firma)
ADRESA                                                                  (trvalé bydliště/místo podnikání/sídlo)
IČ                                                                              (u fyzické osoby i datum narození a rodné číslo)
Název dotačního programu |  |  | [NAME] materiálně technické základny mimoškolních zájmových aktivit dětí a mládeže 2008
Název projektu/akce/činnosti
Celkové výdaje na projekt/akci/činnost                                   ( v Kč ):
Výše dotace z rozpočtu JMK                               ( v Kč ):
Z dotace vráceno                                                    ( v Kč ):
Prostředky vráceny na účet JMK dne
Osoba odpovědná za vyúčtování dotace ([NAME] a příjmení, funkce, adresa, telefon)
Soupis dokladů vztahujících se k realizaci projektu/akce/činnosti
číslo účetního dokladu v účetní evidenci | číslo prvotního účetního dokladu | název dokladu | datum vystavení dokladu | účel platby | datum platby | [NAME] (bez DPH)* | z toho částka hrazená z dotace JMK
V ………………………………………dne ……………………………
Název/obchodní firma a podpis osoby [NAME] (příp. též otisk razítka):
…………………………………………………………………………………………………..
*Není-li příjemce plátcem DPH, uvede celkové výdaje včetně DPH.
[NAME] příjemce plátcem DPH, ale nemůže v konkrétním případě uplatnit nárok na odpočet DPH na vstupu podle
zákona č. 235/2004 Sb., o dani z přidané hodnoty, ve znění pozdějších předpisů, uvede rovněž celkové výdaje
včetně DPH.
Pokud je příjemce plátcem DPH a má nárok v konkrétním případě uplatnit nárok na odpočet DPH na vstupu
[NAME] č. 235/2004 Sb, o dani z přidané hodnoty, ve znění pozdějších předpisů, bude částka uvedena bez DPH.
Spreadsheet: 862735d1710386177-complex-for-me-if-function-request-help-me-calculate-commissions
Sheet: Sheet1

 |  | Please help me with a function in the gray field below "Commission" to include all variables as described below and produce accurate results, also given below
 |  | All fields are open , and my correect answers have the basic calculation for visibility. Light blue fields are for entry of variables.
 |  | Commissions are owed upon a sale, but the conditions of the sale determine the commission:  1. If the sale was made by either Employee A or Employee B, the compensation is 1.25% of the loan amount, but for all others, it is 1.00% 2. However, if the company paid for the lead, the commission is reduced to only .50% no matter which employee made the sale 3. If the loan is exempt from compensation law, commission is 67% of revenue 4. If the company paid for the lead and the loan is exempt from compensation law, commission is 50% of revenue 5.  If the loan is an Employee Loan, there is no commission paid at all
 |  |  |  |  |  |  |  |  |  |  | Data Validation Reference Only
 |  |  |  |  |  |  |  |  |  |  | Employee A | Yes
 |  |  |  |  |  |  |  |  |  |  | Employee B
 |  |  |  |  |  |  |  |  |  |  | Employee C
 |  |  |  |  |  |  |  |  |  |  | Employee D
 |  |  |  |  |  |  |  |  |  |  | Employee E
 |  |  |  |  |  |  |  |  |  |  | Employee F
 | Employee | Loan Amount | Revenue | Company-paid? | Exempt? | Empoyee Loan? | Commission |  |  |  | Employee G
 | Employee A | 300000 |  |  |  |  |  |  |  |  | Employee H
 |  | Correct Commission amounts for 1-5 above are as follows:
 |  | No "Yes" indicators |  |  |  | 1 |  | for Employees A & B
 |  |  |  |  |  |  |  | for all other employees
 |  | Company-paid lead indicates "Yes" |  |  |  | 2
 |  | Exempt indicates "Yes" |  |  |  | 3
 |  | Company-paid lead indicates "Yes" and Exempt indicates "Yes" |  |  |  | 4
 |  | Employee Loan indicates "Yes" |  |  |  | 5
Spreadsheet: 875089d1721658234-how-to-divide-an-amount-over-columns-of-month-w-different-starting-dates-bg528-sample-311-gantt-payments-aligw
Sheet: 1. Deliver (planning)

Name | Startmaand | Eindmaand | [NAME] waarde totaal | 01/01/2025 | 01/02/2025 | 01/03/2025 | [NAME] | 01/05/2025 | 01/06/2025 | 01/07/2025 | 01/08/2025 | 01/09/2025 | 01/10/2025 | 01/11/2025 | 01/12/2025
ABC | 2025-01-01 00:00:00 | 2025-09-01 00:00:00 | 10000
DEF | 2025-06-01 00:00:00 | 2025-10-01 00:00:00 | 50000
GHI | 2025-04-01 00:00:00 | 2025-11-01 00:00:00 | 14000
JKL | 2025-05-01 00:00:00 | 2025-10-01 00:00:00 | 80000
Total
Spreadsheet: 888767d1739349300-problem-with-embeded-table-help
Sheet: Sheet1

 |  | QUOTE NUMBER
 |  | SURNAME
 |  | TOTAL PRICE |  |  |  |  |  |  |  |  |  |  |  |  |  | EX VAT | EX VAT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INC VAT | INC VAT
 | PLEASE NOTE THE MINIMUM UNIT CHARGE IS 0.3m2, ALL UNITS BELOW THIS SIZE ARE CHARGED AT 0.3m2 |  |  |  |  |  |  |  | NOMINAL
 | ITEM | PRODUCT | COST | QTY | WIDTH | WIDTH | HEIGHT | HEIGHT | AREA | AREA |  | AREA | PRICE | COST | PRICE | WARNING |  |  |  | Product | Price
 | 1 | 4mm Clear |  | 1 |  | 1000 |  | 1000 |  |  |  |  |  |  |  |  |  |  |  | 4mm Clear | 50
 |  | 4mm Obscure |  | 4 |  | 1000 |  | 1000 |  |  |  |  |  |  |  |  |  |  |  | 4mm Obscure | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4mm Clear TUF | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4mm Obscure TUF | 80
Spreadsheet: 62335d1263308284-league-spreadsheet-2010league_rev1_jan8_2010-1-
Sheet: Results

Week | 2 | results |  |  |  |  |  |  | data entry |  | enter week number in B1
number of pairings |  | 6
team # | team name | rank | team members | previous average | Score | Spot | adj. Score | X's | points won | VS | team # | team name | rank | team members | previous average | Score | Spot | adjusted Score | x's | points won
 | 1
12 | Twisted_Up | 1 | [NAME] | 299 | 300 | #N/A | #N/A | 50 | #N/A |  | 1 | McNellys_Rangers | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | 2 | [NAME] | 294 | 299 | #N/A | #N/A | 50 | #N/A |  |  |  | 2 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | 3 | Palmer Addison | 274 | 284 | #N/A | #N/A | 50 | #N/A |  |  |  | 3 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 2
11 | Rut_Necks | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 2 | Spot_Smokers | 1 | [NAME] | 300 | 300 | #N/A | #N/A | 50 | #N/A
 |  | 2 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  | 2 | [NAME] | 300 | 300 | #N/A | #N/A | 50 | #N/A
 |  | 3 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  | 3 | [NAME] | 287 | 285 | #N/A | #N/A | 50 | #N/A
 | 3
3 | Killer_Vs | 1 | [NAME] | 295 | 298 | #N/A | #N/A | 50 | #N/A |  | 10 | Fletched_Tite | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | 2 | [NAME] | 281 | 296 | #N/A | #N/A | 50 | #N/A |  |  |  | 2 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | 3 | [NAME] | 278 | 285 | #N/A | #N/A | 50 | #N/A |  |  |  | 3 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 4
9 | Spots_with_Speed | 1 | [NAME] | 289 | 285 | 8 | 293 | 50 | 0 |  | 4 | Passing_Time | 1 | [NAME] | 299 | 298 | 0 | 298 | 50 | 1
 |  | 2 | [NAME] | 280 | 254 | 15.2 | 269.2 | 50 | 0 |  |  |  | 2 | [NAME] | 299 | 300 | 0 | 300 | 50 | 1
 |  | 3 | [NAME] | 236 | 254 | 50.40000000000001 | 304.4 | 50 | 1 |  |  |  | 3 | [NAME] | 299 | 300 | 0 | 300 | 50 | 0
 | 5
5 | Lucky_Stables | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 8 | Out_of_Towners | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | 2 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  | 2 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | 3 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  | 3 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 6
7 | RDs_Whitetails | 1 | [NAME] | 299 | 300 | 0 | 300 | 50 | 1 |  | 6 | Wise_Guys | 1 | [NAME] | 287 | 284 | 9.600000000000001 | 293.6 | 50 | 0
 |  | 2 | [NAME] | 298 | 298 | 0 | 298 | 50 | 0 |  |  |  | 2 | [NAME] | 277 | 298 | 16.8 | 314.8 | 50 | 1
 |  | 3 | [NAME] | 267 | 265 | 4.800000000000001 | 269.8 | 50 | 0 |  |  |  | 3 | [NAME] | 273 | 274 | 0 | 274 | 50 | 1
 | This sheet compares the results entered on the Scores Sheet for the week selected above and calculates who gets points
 | The points then need to be entered manually for each player in the Scores sheet.
 | No data entry here! All scores and points are entered on the Scores sheet!!
Spreadsheet: 266478d1379623850-data-interpolation-and-formulas-data-20interpolation-20-20excel-20forum-jp-
Sheet: Sheet2

 | Cumulative | Daily Rainfall
 | Frequency % | Depth (mm)
 | 0 | 0
 | 0.7542776503792556 | 6.35
 | 0.8872817075321927 | 12.7
 | 0.9398482977597461 | 19.05
 | 0.9657787969659553 | 25.4
 | 0.9798906332686541 | 31.75
 | 0.9895925207267596 | 38.1
 | 0.9931204798024343 | 44.45
 | 0.9964720409243253 | 50.8
 | 0.997354030693244 | 57.15
 | 0.9989416122772976 | 63.5
 | 0.9991180102310814 | 69.85
 | 0.9994708061386488 | 76.2
 | 0.9998236020462162 | 82.55
 | 0.9998236020462162 | 88.9
 | 1 | 95.25
 | 1 | 101.6
 | 1 | 107.95
 | 1 | 114.3
 | 1 | 120.65
 | 1 | 127
 | 1 | 133.35
 | 1 | 139.7
 | 1 | 146.05
 | 1 | 152.4
 | 1 | 158.75
 | 1 | 165.1
 | 1 | 171.45
 | 1 | 177.8
 | 1 | 184.15
 | 1 | 190.5
 | 1 | 196.85
 | 1 | 203.2
 | 1 | 209.55
 |  | Totals
Spreadsheet: 09e6a2e2-2356-4f26-b5a7-d165817acf12
Sheet: WUHSAC

Team | [NAME] | Set | PPG | PPB | 15PG
[NAME] | WUHSAC | WUHSAC | 315 | 19 | n/a
Clayton A | WUHSAC | WUHSAC | 401.82 | 20.39 | n/a
Clayton B | WUHSAC | WUHSAC | 257.27 | 16.77 | n/a
Clayton C | WUHSAC | WUHSAC | 218 | 13.21 | n/a
Clayton D | WUHSAC | WUHSAC | 185.56 | 11.59 | n/a
[NAME] | WUHSAC | WUHSAC | 230 | 13.46 | n/a
Fairfield Community A | WUHSAC | WUHSAC | 192 | 11.83 | n/a
Fairfield Community B | WUHSAC | WUHSAC | 82.86 | 7.41 | n/a
Hancock | WUHSAC | WUHSAC | 71.25 | 7.41 | n/a
Helias A | WUHSAC | WUHSAC | 355.56 | 18.32 | n/a
Helias B | WUHSAC | WUHSAC | 250.91 | 14.15 | n/a
Helias C | WUHSAC | WUHSAC | 176.67 | 12.37 | n/a
Ladue A | WUHSAC | WUHSAC | 540.83 | 24.15 | n/a
Ladue B | WUHSAC | WUHSAC | 288.89 | 15.76 | n/a
Notre Dame | WUHSAC | WUHSAC | 295.56 | 15.22 | n/a
Oakville | WUHSAC | WUHSAC | 230 | 15.28 | n/a
Parkway Central A | WUHSAC | WUHSAC | 255 | 12.92 | n/a
Parkway Central B | WUHSAC | WUHSAC | 173.75 | 11.75 | n/a
Parkway North | WUHSAC | WUHSAC | 248.89 | 13 | n/a
Parkway South A | WUHSAC | WUHSAC | 191.11 | 11.74 | n/a
Parkway South B | WUHSAC | WUHSAC | 108 | 7.07 | n/a
Parkway West A | WUHSAC | WUHSAC | 384 | 18.89 | n/a
Parkway West B | WUHSAC | WUHSAC | 208.89 | 12.05 | n/a
Priory | WUHSAC | WUHSAC | 194 | 12.5 | n/a
Rock Bridge A | WUHSAC | WUHSAC | 387.27 | 21.37 | n/a
Rock Bridge B | WUHSAC | WUHSAC | 300 | 14.85 | n/a
Rock Bridge C | WUHSAC | WUHSAC | 193.64 | 11.63 | n/a
[NAME] | WUHSAC | WUHSAC | 40 | 5.26 | n/a
Savannah | WUHSAC | WUHSAC | 371 | 19.57 | n/a
SLUH A | WUHSAC | WUHSAC | 261 | 14.26 | n/a
Springfield | WUHSAC | WUHSAC | 330 | 15.88 | n/a
Troy | WUHSAC | WUHSAC | 78.33 | 6.25 | n/a
Valley Park | WUHSAC | WUHSAC | 206 | 11.05 | n/a
[NAME] | WUHSAC | WUHSAC | 216.67 | 14 | n/a
Spreadsheet: 685551d1594065315-permutations-and-outcomes-workbook-v1
Sheet: Manual 

Blister | Carton | Overlabel | IFU | Language | 2nd UPC |  |  | Blister | Carton | Overlabel | IFU | Language | 2nd UPC | WORKFLOW
 |  |  |  |  |  |  |  | y | n | n | n | n | n
 |  |  |  |  |  |  |  | y | y | n | n | n | n
 |  |  |  |  |  |  |  | y | y | y | n | n | n
 |  |  |  |  |  |  |  | y | y | y | y | n | n
 |  |  |  |  |  |  |  | y | y | y | y | y | n
 |  |  |  |  |  |  |  | y | y | y | y | y | y
 |  |  |  |  |  |  |  | n | n | n | n | n | n
 |  |  |  |  |  |  |  | n | y | n | n | n | n
 |  |  |  |  |  |  |  | n | y | y | n | n | n
 |  |  |  |  |  |  |  | n | y | y | y | n | n
 |  |  |  |  |  |  |  | n | y | y | y | y | n
 |  |  |  |  |  |  |  | n | y | y | y | y | y
 |  |  |  |  |  |  |  | n | n | y | n | n | n
 |  |  |  |  |  |  |  | n | n | y | y | n | n
 |  |  |  |  |  |  |  | n | n | y | y | y | n
 |  |  |  |  |  |  |  | n | n | y | y | y | y
 |  |  |  |  |  |  |  | n | n | n | y | n | n
 |  |  |  |  |  |  |  | n | n | n | y | y | n
 |  |  |  |  |  |  |  | n | n | n | y | y | y
 |  |  |  |  |  |  |  | n | n | n | n | y | n
 |  |  |  |  |  |  |  | n | n | n | n | y | y
 |  |  |  |  |  |  |  | n | n | n | n | n | y
Spreadsheet: 873974d1720551091-index-match-ignore-n-a-cells-ecorf-test_index_match_na
Sheet: PM

 | Use DATA!$B$3:$B$5000 as the range instead of DATA! Column C (DATA!$C$3:$C$5000 )to get data with #N/A
 |  |  |  | Blank instead
 | Rank | Concentration | Time | of #N/A | Solution
 | 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
Spreadsheet: 90767d1290519395-sorting-dates-that-are-referenced-from-other-sheets-forum-reference-example
Sheet: Booker C&C

Customer | BOOKER CASH & CARRY LTD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page Count YTD
Bid Number | 2709D501
Version | 3
Status | EMEA approved
Validation date | 26/03/2010
Start date | [NAME]
End date | 02/04/2011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentage Increase: | 0
[NAME]
Description | Quantity | Bid price | Part number | 2009 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | Total Units | Total Revenue | Bid £ | BDP | % Discount | New Price? | New Discount? | New Price £ Estimate | Current £ Year Estimate
Spreadsheet: 729549d1619161325-formula-to-count-days-worked-that-are-on-weekends-schedule-help-needed
Sheet: Employee List

Name | Number
Employee - 1 | (123) 456-7890
Employee - 2 | (123) 456-7891
Employee - 3 | (123) 456-7892
Employee - 4 | (123) 456-7893
Employee - 5 | (123) 456-7894
Employee - 6 | (123) 456-7895
Employee - 7 | (123) 456-7896
Employee - 8 | (123) 456-7897
Employee - 9 | (123) 456-7898
Employee - 10 | (123) 456-7899
Employee - 11 | (123) 456-7900
Employee - 12 | (123) 456-7901
Employee - 13 | (123) 456-7902
Employee - 14 | (123) 456-7903
Employee - 15 | (123) 456-7904
Employee - 16 | (123) 456-7905
Employee - 17 | (123) 456-7906
Employee - 18 | (123) 456-7907
Employee - 19 | (123) 456-7908
Employee - 20 | (123) 456-7909
Spreadsheet: 757778d1638455383-filter-formula-over-multiple-sheets-permit-register-gk
Sheet: Job Register 2021

ABC Job Number | Address | Job Description | Client | Job Received | Quote Sent | Date of Confirmation  to Proceed | Permit Number | BUILDING PERMIT | OCCUPANCY PERMIT | Inspection Status | Job Notes | BP INVOICE | [NAME]
ABC-21001 | Address 1 | Description 1 | Client 1 | 2021-04-01 00:00:00 | 2021-04-03 00:00:00 | 2021-04-05 00:00:00 | 001/001/001 | 2021-05-01 00:00:00 | 2021-05-01 00:00:00
ABC-21002 | Address 2 | Description 2 | Client 2 | 2021-04-02 00:00:00 | 2021-04-04 00:00:00 | 2021-04-06 00:00:00 | 001/001/002 | BP | READY |  | Note 1
ABC-21003 | Address 3 | Description 3 | Client 3 | 2021-04-03 00:00:00 | 2021-04-05 00:00:00 | 2021-04-07 00:00:00 | 001/001/003 | 2021-05-03 00:00:00 | OP |  | Note 2
ABC-21004 | Address 4 | Description 4 | Client 4 | 2021-04-04 00:00:00 | 2021-04-06 00:00:00 | 2021-04-08 00:00:00 | 001/001/004 | 2021-05-04 00:00:00 | APPROVE |  | Note 3
ABC-21005 | Address 5 | Description 5 | Client 5 | 2021-04-05 00:00:00 | 2021-04-07 00:00:00 | 2021-04-09 00:00:00 | 001/001/005 | BP |  |  | Note 4
ABC-21006 | Address 6 | Description 6 | Client 6 | 2021-04-06 00:00:00 | 2021-04-08 00:00:00 | 2021-04-10 00:00:00 | 001/001/006 | 2021-05-05 00:00:00 | PARTIAL OP |  | Note 5
ABC-21007 | Address 7 | Description 7 | Client 7 | 2021-04-07 00:00:00 | 2021-04-09 00:00:00 | 2021-04-11 00:00:00 | 001/001/007 | BP | OP |  | Note 6
ABC-21008 | Address 8 | Description 8 | Client 8 | 2021-04-08 00:00:00 | 2021-04-10 00:00:00 | 2021-04-12 00:00:00 | 001/001/008 | N/A | READY |  | Note 7
ABC-21009 | Address 9 | Description 9 | Client 9 | 2021-04-09 00:00:00 | 2021-04-11 00:00:00 | 2021-04-13 00:00:00 | 001/001/009 | - | 2021-10-19 00:00:00 |  | Note 8
Spreadsheet: 782291d1653955642-trying-to-create-spreadsheet-that-uses-3-different-criteria-to-return-a-value-sample-2-
Sheet: Sheet1

Payroll | Rank | Station | Shift | Assign To | Position Status | Choice | Seniority  Date | Class Rank |  | Stations that are open to be picked
12 | FIREFIGHTER | 38 | A | Apparatus | P | 1 | 2018-03-13 00:00:00 | 6 |  | 38 | A | P | Apparatus
12 | FIREFIGHTER | 38 | C | Apparatus | P | 2 | 2018-03-13 00:00:00 | 6 |  | 38 | C | P | Apparatus
12 | FIREFIGHTER | 62 | C | Apparatus | P | 3 | 2018-03-13 00:00:00 | 6 |  | 38 | C | P | Apparatus
12 | FIREFIGHTER | 38 | D | Apparatus | P | 4 | 2018-03-13 00:00:00 | 6 |  | 38 | D | P | Apparatus
13 | FIREFIGHTER | 38 | A | Apparatus | P | 1 | 2018-03-13 00:00:00 | 44 |  | 62 | C | P | Apparatus
13 | FIREFIGHTER | 38 | C | Apparatus | P | 2 | 2018-03-13 00:00:00 | 44
13 | FIREFIGHTER | 62 | C | Apparatus | P | 3 | 2018-03-13 00:00:00 | 44
13 | FIREFIGHTER | 38 | D | Apparatus | P | 4 | 2018-03-13 00:00:00 | 44 |  | Results
14 | FIREFIGHTER | 38 | A | Apparatus | P | 1 | 2018-03-13 00:00:00 | 48 |  | 12 | 38 | A | Apparatus
14 | FIREFIGHTER | 38 | C | Apparatus | P | 2 | 2018-03-13 00:00:00 | 48 |  | 13 | 38 | C | Apparatus
14 | FIREFIGHTER | 62 | C | Apparatus | P | 3 | 2018-03-13 00:00:00 | 48 |  | 14 | 38 | C | Apparatus
14 | FIREFIGHTER | 38 | D | Apparatus | P | 4 | 2018-03-13 00:00:00 | 48 |  | 15 | 62 | C | Apparatus
15 | FIREFIGHTER | 38 | A | Apparatus | P | 1 | 2018-03-13 00:00:00 | 50
15 | FIREFIGHTER | 38 | C | Apparatus | P | 2 | 2018-03-13 00:00:00 | 50
15 | FIREFIGHTER | 62 | C | Apparatus | P | 3 | 2018-03-13 00:00:00 | 50
15 | FIREFIGHTER | 38 | D | Apparatus | P | 4 | 2018-03-13 00:00:00 | 50
Spreadsheet: 854562d1704386791-need-formula-to-show-1st-day-of-january-july-dual-ans
Sheet: Sheet1

2023-04-05 00:00:00
2023-08-01 00:00:00
 | [NAME] HD | my expected results |  | [NAME] | [NAME] kvsrini
2023-04-05 00:00:00 |  | 2023-07-01 00:00:00
2023-09-05 00:00:00 |  | 2024-01-01 00:00:00
2023-07-01 00:00:00 |  | 2023-07-01 00:00:00
2024-01-01 00:00:00 |  | 2024-01-01 00:00:00
2024-01-02 00:00:00
Spreadsheet: 75691d1276238314-pivot-tables-from-consolidated-data-ranges-consolidated-range-pivot-table2
Sheet: Sheet3

 | Page1 | (All)
 | Count of Value | Column
 | Row | Order | Price | Qty | Type | Grand Total
 | 1 | 2 | 2 | 2 | 2 | 8
 | 2 | 2 | 2 | 2 | 2 | 8
 | 3 | 2 | 2 | 2 | 2 | 8
 | 4 | 2 | 2 | 2 | 2 | 8
 | 5 | 2 | 2 | 2 | 2 | 8
 | 6 | 2 | 2 | 2 | 2 | 8
 | 7 | 1 | 1 | 1 | 1 | 4
 | 8 | 1 | 1 | 1 | 1 | 4
 | Grand Total | 14 | 14 | 14 | 14 | 56
Spreadsheet: 86662d1286606057-typing-time-into-a-cell-containing-a-list-dropdown-list
Sheet: Staff

Name | Department | Status | Position | Wage
[NAME] | Gas Station | FT |  | 15
[NAME] | Gas Station | FT |  | 15
[NAME] | Gas Station | PT |  | 15
[NAME] | Gas Station | PT |  | 14