tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 376867d1423737189-conditional-formatting-based-on-value-in-some-cell-conditional-max-min-formatting
Sheet: 10 With Rating

Actual Time
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Average | Min | VA / NNVA / PNVA | Extra Jobs | Opportunities |  | [NAME] | Min | Diff | % Var | [NAME] | Diff Min
22.44 | 22.56 | 23.45 | 21.07 | 25.7 | 23.16 | 19.45 | 18.06 | 20.22 | 20.28
100.56 | 96.4 | 101.78 | 88.44 | 126.36 | 125.2 | 71.7 | 45.82 | 73.7 | 78.45
5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Spreadsheet: 153457d1335916487-auto-sort-values-drawn-from-a-vlookup-table-into-ascending-order-sorted-example
Sheet: VLookupTable

NJ | 0.4141129714107488 | 36
Hou | 0.5346784547152194 | -11
[NAME] | 0.5824151019675501 | 8
Chi | 0.5307337384377362 | -2
Cha | 0.4086588162660472 | 6
NJ | 0.4141129714107488 | 5
Ind | 0.5185801965749602 | -12
Phi | 0.5187353113032686 | -14
Mil | 0.4996112879733603 | 5
SA | 0.5645287340138865 | -22
[NAME] | 0.4623480392349345 | 6
NO | 0.4319737213932251 | 22
Tor | 0.4082945997171938 | 23
Orl | 0.5195090607139831 | 2
LAL | 0.5830781964115567 | -8
[NAME] | 0.4502741585543951 | 2
Por | 0.5264521796059863 | -20
Chi | 0.5307337384377362 | -11
NY | 0.4661486876370821 | -17
Spreadsheet: 674792d1588015603-comparing-two-sheets-and-displaying-differences-example2
Sheet: Desired Results

 |  |  |  |  | Notes
1 | [NAME] | Lemon | 4.99 |  | New Entry
4 |  | Kiwi |  |  | Changed Entry
5 | [NAME] | Apple | 3 |  | New Entry
 | Olivia | [NAME] | 0.99 |  | Entry Removed
Spreadsheet: 139904d1328539578-look-up-originating-post-code-0226
Sheet: Sheet1

CONSIGNMENT NO. | DATE REQUIRED | LEG | COLLECTED FROM | COLLECTION POSTCODE | ORIGINATING POSTCODE |  | END POSTCODE
2658309 | 2011-11-17 00:00:00 | 1 | Meir Park (Depot) | ST3 7TU | ST3 7TU | ST3 7TU | EN11 0ZN | EN11 0ZN
2658309 | 2011-11-17 00:00:00 | 2 | Hoddesdon | EN11 0ZN | ST3 7TU | ST3 7TU | EN11 0ZN | EN11 0ZN
2659458 | 2011-11-17 00:00:00 | 1 | Meir Park (Depot) | ST3 7TU | ST3 7TU | ST3 7TU | ST3 7TU | ST3 7TU
2659544 | 2011-11-17 00:00:00 | 1 | Arla Transport (Depot) | HX5 9DA | HX5 9DA | HX5 9DA | EN11 0ZN | EN11 0ZN
2659544 | 2011-11-17 00:00:00 | 2 | Elland Transport (Depot) | HX5 9DA | HX5 9DA | HX5 9DA | EN11 0ZN | EN11 0ZN
2659544 | 2011-11-17 00:00:00 | 3 | Avonmouth (Depot) | BS11 0YB | HX5 9DA | HX5 9DA | EN11 0ZN | EN11 0ZN
2659544 | 2011-11-17 00:00:00 | 4 | Meir Park (Depot) | ST3 7TU | HX5 9DA | HX5 9DA | EN11 0ZN | EN11 0ZN
2659544 | 2011-11-17 00:00:00 | 5 | Hoddesdon | EN11 0ZN | HX5 9DA | HX5 9DA | EN11 0ZN | EN11 0ZN
2659551 | 2011-11-17 00:00:00 | 1 | Philex | MK42 0NX | MK42 0NX | MK42 0NX | MK42 0NX | MK42 0NX
2659853 | 2011-11-17 00:00:00 | 1 | Avonmouth (Depot) | BS11 0YB | BS11 0YB | BS11 0YB | EN11 0ZN | EN11 0ZN
2659853 | 2011-11-17 00:00:00 | 2 | Meir Park (Depot) | ST3 7TU | BS11 0YB | BS11 0YB | EN11 0ZN | EN11 0ZN
2659853 | 2011-11-17 00:00:00 | 3 | Hoddesdon | EN11 0ZN | BS11 0YB | BS11 0YB | EN11 0ZN | EN11 0ZN
Spreadsheet: 769258d1645441296-auto-populate-auto-populate
Sheet: MAIN

Serial Number: | NL17187121
Spare Part No.: | Description: | Qty
45249 | BOX WHITE / KRAFT SBS | 1
52605 | LAKE DOOR ASSEMBLY | 1
52587 | LAKE FRONT HOUSING SUB-ASSEMBLY | 1
52609 | LAKE REAR HOUSING ASSEMBLY | 1
52666 | LABEL REGULATORY LAKE | 1
52667 | LABEL INFORMATION BACK LAKE | 1
54112 | User Manual, 1st | 1
56224 | User manual, 2nd | 1
16676-006 | Label Vinyl Wrap Around (3000/roll) | 1
54071 | SHIPPING BOX LAKE | 1
62815 | Label, Compat Ella Shipping Box | 1
52613 | SCREW M2.5-1.40 X 12 PLASTITE 45 | 4
52599 | SCREW M2.5-1.40 X 15.3 PLASTITE 45 | 2
52596 | SCREW M2.0-1.35 X 8.0 PLASTITE 45 SELF TAPPING | 11
54063-001 | LABEL SN NESTLE LAKE PUMP | 6
54063-002 | LABEL SIDE BOX NESTLE LAKE (small label) | 1
54063-003 | LABEL SHIPPER BOX NESTLE LAKE (Large label) | 1
Spreadsheet: 686777d1594811196-duplicate-value-formula-to-be-used-in-conditional-formatting-test-duplicate
Sheet: Sheet1

 |  | 1 | 2 | 3
 |  | Kit | X | Y | feaf | fdhhgj | khjkh
 |  | [NAME] | X | Y | feaf | fdhhgj | khjkh
 |  | Mark | X | Y | feaf | fdhhgj | khjkh
 |  | Kit | X | Y | feaf | fdhhgj | khjkh
 |  | Wain | X | Y | feaf | fdhhgj | khjkh
 |  | [NAME] | X | Y | feaf | fdhhgj | khjkh
 |  | Kit | X | X | feaf | fdhhgj | khjkh
Spreadsheet: 94497d1294300961-two-filter-items-how-to-combine-or-create-or-statement-double-filter
Sheet: With_Pivot

Client Name | Client Resource 1 | Client Resource 2 | Chosen | Date of Engagement |  |  |  | [NAME]
ABC inc | [NAME] | [NAME] |  | 2011-01-05 00:00:00
123 Company | [NAME] | [NAME] |  | 2011-01-05 00:00:00 |  |  | Chosen | [NAME]
Acme | [NAME] | [NAME] |  | 2011-01-08 00:00:00
[NAME] | [NAME] | [NAME] |  | 2011-01-01 00:00:00
 |  |  |  |  |  |  | Client Name | Date of Engagement
 |  |  |  |  |  |  | [NAME] | 2011-01-01 00:00:00
 |  |  |  |  |  |  | Grand Total
Spreadsheet: 879522d1727098455-conditional-formatting-formula-based-on-two-criteria-time-or-space-jay325-sample1c
Sheet: Map

 | Location
Time | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17
9:00 - 9:59
10:00 - 10:59
11:00 - 11:59
12:00 - 12:59
13:00 - 13:59
14:00 - 14:59
15:00 - 15:59
16:00 - 16:59
17:00 - 17:59
18:00 - 18:59
19:00 - 19:59
20:00 - 20:59
21:00 - 21:59
22:00 - 22:59
23:00 - 23:59
00:00 - 00:59
01:00 - 01:59
02:00 - 02:59
03:00 - 03:59
04:00 - 04:59
05:00 - 05:59
06:00 - 06:59
07:00 - 07:59
08:00- 08:59
Spreadsheet: larry_campbell__20973__TOPOCK LATERAL SAMPLING
Sheet: WIPE SAMPLES MS

DATE | TIME | FACILITY | SAMPLE ID | SAMPLE LOCATION | MATRIX | RESULT | UNITS | COMMENTS
1999-06-28 00:00:00 | 11:00:00 | PG&E MEAS. STA. | PGEMS-014W | METER RUN # 1 | WIPE | 140 | UG/WIPE | NOT 100 CM SQ. WIPE
1999-06-28 00:00:00 | 11:00:00 | PG&E MEAS. STA. | PGEMS-015W | METER RUN # 2 | WIPE | 110 | UG/WIPE | NOT 100 CM SQ. WIPE
1999-06-28 00:00:00 | 11:05:00 | PG&E MEAS. STA. | PGEMS-016W | METER RUN # 3 | WIPE | 17 | UG/WIPE | NOT 100 CM SQ. WIPE
1999-06-29 00:00:00 | 10:33:00 | PG&E MEAS. STA. | PGEMS-021W | # 1 REGULATOR | WIPE | 62 | UG/WIPE | NOT 100 CM SQ. WIPE
1999-06-29 00:00:00 | 10:35:00 | PG&E MEAS. STA. | PGEMS-022W | 24" PIPE FROM SEP. | WIPE | < 3.00 | UG/WIPE | 100 CM SQ. WIPE
1999-06-29 00:00:00 |  | PG&E MEAS. STA. | PGEMS-023W | INLET TO STATION 24" | WIPE | 1.2 | UG/WIPE | 100 CM SQ. WIPE
1999-06-29 00:00:00 |  | PG&E MEAS. STA. | PGEMS-024W | UPSTREAM HEADER 24" | WIPE | 2.7 | UG/WIPE | 100 CM SQ. WIPE
1999-06-29 00:00:00 |  | PG&E MEAS. STA. | PGEMS-025W | SOCAL INLET HEADER | WIPE | 1.5 | UG/WIPE | 100 CM SQ. WIPE
1999-06-29 00:00:00 |  | PG&E MEAS. STA. | PGEMS-027W | CHECK VALVE | WIPE | 57 | UG/WIPE | NOT 100 CM SQ. WIPE
1999-06-29 00:00:00 |  | PG&E MEAS. STA. | PGEMS-028W | OUTLET DOWN HEADER | WIPE | < 3.00 | UG/WIPE | NOT 100 CM SQ. WIPE
1999-06-29 00:00:00 |  | PG&E MEAS. STA. | PGEMS-029W | PGE-TW METER RUN | WIPE | 9.3 | UG/WIPE | NOT 100 CM SQ. WIPE
1999-06-29 00:00:00 |  | PG&E MEAS. STA. | PGEMS-030W | OUTLET HEADER REG. | WIPE | < 10.00 | UG/WIPE | NOT 100 CM SQ. WIPE
1999-06-29 00:00:00 |  | PG&E MEAS. STA. | PGEMS-034W | BLOWDOWN C/S YARD | WIPE | 5.3 | UG/WIPE | NOT 100 CM SQ. WIPE
1999-06-30 00:00:00 |  | PG&E MEAS. STA. | PGEMS-039W | PGE INLET HEADER | WIPE | 5.5 | UG/WIPE | NOT 100 CM SQ. WIPE
1999-06-30 00:00:00 |  | PG&E MEAS. STA. | PGEMS-040W | REGULATOR HEADER |  | <5.00 | UG/WIPE | NOT 100 CM SQ WIPE
1999-06-30 00:00:00 |  | PG&E MEAS. STA. | PGEMS-041W | PGE OUTLET HEADER | WIPE | <7.00 | UG/WIPE | NOT 100 CM SQ WIPE
Spreadsheet: 155175d1336695311-second-column-of-unique-drop-down-list-entires-not-recognizing-all-unique-entries-book1
Sheet: Functions

airlinelist | destinationlist
Spreadsheet: 775647d1649242888-sum-if-using-equals-greater-and-less-than-test-sheet-plants
Sheet: Pots

Week Commencing | Week Number | Demo Plants
 |  | Confirmed Plantings | Quantity to Harvest | Date Harvest Starts 12 Cm | Date Harvest Starts 17
2022-03-21 00:00:00 | Week 12 | 3240 |  | 2022-07-20 00:00:00 | 2022-09-12 00:00:00
2022-04-18 00:00:00 | Week 16 | 3240 |  | 2022-08-17 00:00:00 | 2022-10-10 00:00:00
2022-05-16 00:00:00 | Week 20 | 1620 |  | 2022-09-14 00:00:00 | 2022-11-07 00:00:00
2022-06-13 00:00:00 | Week 24 | 3240 |  | 2022-10-12 00:00:00 | 2022-12-05 00:00:00
2022-07-11 00:00:00 | Week 28 | 3240 |  | 2022-11-09 00:00:00 | 2023-01-02 00:00:00
2022-08-08 00:00:00 | Week 32 | 1620 |  | 2022-12-07 00:00:00 | 2023-01-30 00:00:00
2022-09-05 00:00:00 | Week 36 | 3240 |  | 2023-01-04 00:00:00 | 2023-02-27 00:00:00
2022-10-03 00:00:00 | Week 40 | 3240 |  | 2023-02-01 00:00:00 | 2023-03-27 00:00:00
2022-10-31 00:00:00 | Week 44 | 1620 |  | 2023-03-01 00:00:00 | 2023-04-24 00:00:00
2022-11-28 00:00:00 | Week 48 | 3240 |  | 2023-03-29 00:00:00 | 2023-05-22 00:00:00
2022-12-26 00:00:00 | Week 52 | 3240 |  | 2023-04-26 00:00:00 | 2023-06-19 00:00:00
Totals
Spreadsheet: 146843d1332374437-drop-down-menus-and-associated-formulas-example-sheet
Sheet: Sheet1

Activity | Reference | Quantity | Length | [NAME] | SqFt | Height | Volume | Cost/Unit | Material | Cost/Unit | Labor | Quantity | Unit | Cost/Unit | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Activity | Reference | Quantity | Length | [NAME] | SqFt | Height | Volume | Cost/Unit | Material | Cost/Unit | Labor | Quantity | Unit | Cost/Unit | Total
Example | [NAME]
Activity | Reference | Quantity | Length | Pounds/LF | Total Pounds | N/A | Total Tons | Cost/Unit | Material | Cost/Unit | Labor | Quantity | Unit | Cost/Unit | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Example | Each
Activity | Reference | Quantity | N/A | N/A | N/A | N/A | N/A | Cost/Unit | Material | Cost/Unit | Labor | Quantity | Unit | Cost/Unit | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | Each
Example | Square Feet
Activity | Reference | Quantity | Length | [NAME] | SqFt | Height | Volume | Cost/Unit | Material | Cost/Unit | Labor | Quantity | Unit | Cost/Unit | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | Square Feet
Spreadsheet: dc4071a3-2316-41cc-9c3d-5581ec928735
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0005150 | Unnamed: 3 | Facility Name: | Unnamed: 5 | North End Elementary | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Person | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Estimate
Monthly Limit: |  |  | 5430
Daily Limit:
Sample Frequency: |  |  | Monthly
Spreadsheet: 766434d1643895197-match-the-position-of-two-equal-items-so-that-they-sit-in-the-same-row-matching_rows
Sheet: Sheet1

 |  |  |  |  | Desired outcome: | Matching ROW
 | List of Foods |  | List of Foods selected |  | List of Foods | List of Foods selected
 | anise |  | ginger |  | anise
 | basil |  |  |  | basil
 | caraway |  |  |  | caraway
 | coriander |  |  |  | coriander | coriander
 | chamomile |  |  |  | chamomile
 | daikon |  | coriander |  | daikon
 | dill |  |  |  | dill
 | fennel |  |  |  | fennel
 | lavender |  |  |  | lavender | lavender
 | marjoram |  |  |  | marjoram
 | oregano |  |  |  | oregano
 | parsley |  |  |  | parsley | parsley
 | rosemary |  |  |  | rosemary
 | thyme |  |  |  | thyme
 | jalapeño |  | lavender |  | jalapeño
 | habanero |  |  |  | habanero
 | paprika |  |  |  | paprika
 | tabasco pepper |  | parsley |  | tabasco pepper
 | cayenne pepper |  |  |  | cayenne pepper | cayenne pepper
 | ginger |  |  |  | ginger | ginger
 | parsnip |  | cayenne pepper |  | parsnip
 | rutabaga |  |  |  | rutabaga
Spreadsheet: 713209d1610597179-extract-values-in-column-c-into-column-j-extract-values_sample1
Sheet: Sheet1

# | ID | Abbr | Names | Extrated Names | Extracted IDs |  | ta |  |  | [NAME]
1 | TA32785655 |  | Tbnor, Aadigan
2 | SA12442673 |  | Abo, [NAME]
3 | AA21259159 |  | Tbra, [NAME]
4 | CA84636028 |  | Abrahaim, Cadman
5 | OA61505754 |  | [NAME], Cadmus
6 | LB71531251 |  | Tbrahame, [NAME]
7 | TB19548089 |  | Abrahamo, [NAME]
8 | SB46327164 |  | [NAME], Cadorette
9 | PB67349700 |  | Abraheem, [NAME]
10 | EB32531079 |  | Tbrahem, [NAME]
11 | SC17296774 |  | Abrahim, Cadwallader
12 | FC70634829 |  | Abrahm, Cadwell
13 | AD17153037 |  | Abrahon, Cady
14 | CD14845828 |  | Abrahsa, Caesar
15 | JG66805710 |  | Abram, Caetano
16 | CH36848865 |  | Abramo, Cafarella
17 | CL41033165 |  | Absalon, Cafarelli
18 | LL21590248 |  | Abselon, Cafaro
19 | RK32756907 |  | Absolom, [NAME]
20 | EM26000697 |  | Absolum, [NAME]
21 | MM12168514 |  | Tbnor, Cadigan
22 | HO10339330 |  | Hub, Oest
23 | RS31728184 |  | Room, Say
24 | SS43010028 |  | Say, Saying
25 | TT33991592 |  | [NAME], [NAME]
26 | CV22833553 |  | Call, Vict
27 | [NAME] |  | [NAME], Wins
28 | JW15786388 |  | [NAME], Winsr
29 | BO44794874 |  | Boy, Crazyin
30 | TA53245548 |  | Tbnor, Aadigan
31 | JS13672576 |  | [NAME], IsLord
32 | TA13291311 |  | Tbnor, Aadigan
Spreadsheet: chris_germany__2068__Tenaska IV Est Imbalance0402
Sheet: Sheet1

Ponderosa Pine Energy Cleburne Plant
TXU Lone Star Pipeline
April, 2002
Estimated Usages*
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
RECEIVED | 34650 | 34650 | 34650 | 34650 | 34650 | 34650 | 34650 | 34650 | 38610 | 34650
DELIVERED | 35579.35799999999 | 36390 | 33951 | 33227 | 28455 | 37337 | 38120 | 32723 | 33539 | 31690
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
RECEIVED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DELIVERED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
RECEIVED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DELIVERED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
*These numbers are based on estimates and are subject to change
Spreadsheet: 230373d1366743587-return-multiple-values-from-multiple-sheets-example
Sheet: JAN

EQUIPMENT | DATE | TEMP | BEGIN PSIG | END PSIG | VALVE | ACTIVITY | MCF LOSS | BBLS H20
COMPRESSOR #1 | 2013-01-10 00:00:00 | 98 | 1005 | 0 | N/A | BLOWDOWN | 15.25 | 0
COMPRESSOR #2 | 2013-01-15 00:00:00 | 99 | 995 | 0 | N/A | BLOWDOWN | 15.25 | 0
COMPRESSOR #3 | 2013-01-04 00:00:00 | 96 | 998 | 0 | N/A | BLOWDOWN | 15 | 0
SLUG CATCHER | 2013-01-08 00:00:00 | 90 | 1002 | 0 | N/A | BLOWDOWN | 5.5 | 0
DEHY CONTACTOR | 2013-01-13 00:00:00 | 92 | 1002 | 0 | N/A | BLOWDOWN | 6.25 | 0
Spreadsheet: 806270d1669206434-finding-out-if-order-time-is-beyond-or-within-the-shift-using-excel-formula-sample-35-ans
Sheet: sample

 | Date Ordered | Start Shift | End Shift | Time Ordered | Remarks | FORMULA
 | 2022-11-03 00:00:00 | 05:48:07 | 16:07:38 | 06:26:00
 | 2022-11-03 00:00:00 | 05:48:07 | 16:07:38 | 12:08:00
 | 2022-11-04 00:00:00 | 05:40:35 | 16:02:02 | 09:56:00
 | 2022-11-04 00:00:00 | 05:40:35 | 16:02:02 | 14:10:00
 | 2022-11-11 00:00:00 | 20:00:39 | 6:37:15 am | 1:10:00 am
 | 2022-11-11 00:00:00 | 20:00:39 | 6:37:15 am | 03:31:00
 | 2022-11-12 00:00:00 | 20:01:16 | 06:33:10 | 23:07:00
 | 2022-11-13 00:00:00 | 19:55:40 | 06:21:48 | 23:19:00
 | 2022-11-13 00:00:00 | 19:55:40 | 06:21:48 | 03:30:00
 | 2022-11-14 00:00:00 | 13:46:31 | 22:11:19 | 17:28:00
Spreadsheet: 852079d1702154708-basic-vba-or-match-and-index-formula-needed-for-unique-column-with-values-test-list-3
Sheet: 2024 CASH MOVMENT

 |  | Dec-23
 | No. | Date | Description | Amount
 | 1 | 45267 | TOTAL BALANCE OF THE MONTH
 | 2 | 45290 | TOTAL CLSOING BALANCE
 | Sr No. | DATE | BENEFICIARIES  - ENG | Pay | Hold | [NAME]
 |  | 2023-12-10 00:00:00
 |  | 2023-12-10 00:00:00 | Beneficiary 10
 |  | 2023-12-10 00:00:00 | Beneficiary 11
 |  | 2023-12-11 00:00:00 | Beneficiary 12
 |  | 2023-12-12 00:00:00 | Beneficiary 13
 |  | 2023-12-13 00:00:00 | Beneficiary 14
 |  | 2023-12-14 00:00:00 | Beneficiary 15
 |  | 2023-12-15 00:00:00 | Beneficiary 16
 |  | 2023-12-16 00:00:00 | Beneficiary 17
 |  | 2023-12-17 00:00:00 | Beneficiary 18
 |  | 2023-12-18 00:00:00 | Beneficiary 19
 |  | 2023-12-19 00:00:00 | [NAME]
 |  | 2023-12-05 00:00:00 | Beneficiary 20
 |  | 2023-12-05 00:00:00 | Beneficiary 3
 |  | 2023-12-14 00:00:00 | [NAME]
 |  | 2023-12-15 00:00:00 | Beneficiary 5
 |  | 2023-12-16 00:00:00 | Beneficiary 6
 |  | 2023-12-14 00:00:00 | Beneficiary 7
 |  | 2023-12-15 00:00:00 | Beneficiary 8
 |  | 2023-12-16 00:00:00 | Beneficiary 9
Spreadsheet: 110101d1306870762-vlookup-not-working-xls1
Sheet: F11

[NAME] | [NAME] | Wk | DC |  | Product | OM
139429 | 4 | 48 | A |  | #N/A
139429 | 8 | 48 | A |  | #N/A
139897 | 1 | 48 | A |  | #N/A
142851 | 2 | 48 | A |  | #N/A
142851 | 3 | 48 | A |  | #N/A
149490 | 8 | 48 | A |  | #N/A
149885 | 1 | 48 | A |  | #N/A
167835 | 1 | 48 | A |  | #N/A
284615 | 1 | 48 | A |  | #N/A
310444 | 1 | 48 | A |  | #N/A
324211 | 2 | 48 | A |  | #N/A
325979 | 1 | 48 | A |  | #N/A
381471 | 1 | 48 | A |  | #N/A
139429 | 4 | 48 | W |  | #N/A
139429 | 8 | 48 | W |  | #N/A
139897 | 1 | 48 | W |  | #N/A
142851 | 2 | 48 | W |  | #N/A
142851 | 3 | 48 | W |  | #N/A
149490 | 8 | 48 | W |  | #N/A
149885 | 1 | 48 | W |  | #N/A
167835 | 1 | 48 | W |  | #N/A
284615 | 1 | 48 | W |  | #N/A
310444 | 1 | 48 | W |  | #N/A
324211 | 2 | 48 | W |  | #N/A
325979 | 1 | 48 | W |  | #N/A
381471 | 1 | 48 | W |  | #N/A
139429 | 4 | 48 | C |  | #N/A
149885 | 1 | 48 | C |  | #N/A
167835 | 1 | 48 | C |  | #N/A
284615 | 1 | 48 | C |  | #N/A
310444 | 1 | 48 | C |  | #N/A
320011 | 2 | 48 | C |  | #N/A
324211 | 2 | 48 | C |  | #N/A
325979 | 1 | 48 | C |  | #N/A
381471 | 1 | 48 | C |  | #N/A
382120 | 1 | 48 | C |  | #N/A
Spreadsheet: 124269d1318279215-problem-using-conditional-formatting-to-flag-cells-by-color-and-count-them-example3
Sheet: Narula

PT. # | LAST NAME | FIRST NAME | REQUIRED | IN DATE | COM DATE | NOTES
76032 |  |  | D/C Sig | 2011-09-21 00:00:00 | 2011-09-22 00:00:00 |  | Total # Yellow: | #N/A
57373 |  |  | DO Sig | 2011-09-06 00:00:00 | 2011-09-20 00:00:00 |  | Total # Orange: | #N/A
81437 |  |  | DO Sig | 2011-09-06 00:00:00 | 2011-09-20 00:00:00 |  | Total # Red: | #N/A
49993 |  |  | D/C Sum Sig | 2011-09-07 00:00:00 |  | To Belgard First 7 sep 11 | Complient: | 10
80967 |  |  | HP Sig | 2011-09-09 00:00:00 | 2011-10-06 00:00:00 |  | All Total: | #N/A
55945 |  |  | DO Sig | 2011-09-09 00:00:00 | 2011-09-20 00:00:00 | ATT, D/C Sig for Alindada
66965 |  |  | HP Sig | 2011-09-09 00:00:00 | 2011-09-20 00:00:00 | DO, ATT
81494 |  |  | ATT | 2011-09-09 00:00:00 | 2011-09-22 00:00:00
967 |  |  | D/C  Dict | 2011-09-20 00:00:00 | 2011-10-07 00:00:00 | all else completed on 21 sep
50650 |  |  | ATT | 2011-09-21 00:00:00 | 2011-09-21 00:00:00 | [NAME], then [NAME], last Narula
39119 |  |  | PN Sig | 2011-09-15 00:00:00 | 2011-09-21 00:00:00 | then to Oad w/miranda
15117 |  |  | D/C Sig | 106/11 | 2011-10-06 00:00:00
62239 |  |  | ATT | 2011-09-15 00:00:00 | 2011-09-21 00:00:00
16672 |  |  | DO | 2011-09-16 00:00:00 | 2011-09-20 00:00:00
45007 |  |  | DO | 2011-09-17 00:00:00 | 2011-09-20 00:00:00 | D/C, PN, ATT
926 |  |  | D/C Sig | 2011-09-17 00:00:00 |  | D/C Dict (Vol II) | All else completed 20 sep, [NAME] done 3 oct 11
926 |  |  | D/C Sig | 2011-09-20 00:00:00 | 2011-09-20 00:00:00 | to FARHAT 1st (Vol I)
51535 |  |  | ATT | 2011-09-20 00:00:00
72586 |  |  | HP Sig | 2011-09-20 00:00:00 | 2011-09-21 00:00:00
80739 |  |  | D/C  Dict | 2011-09-20 00:00:00 | 2011-10-07 00:00:00
43454 |  |  | D/C Sig | 2011-09-20 00:00:00 | 2011-09-21 00:00:00 | To Saeed, need ATT | faxed D/C to Charlotte 21 sep
81602 |  |  | D/C Sig | 2011-09-20 00:00:00 |  | To Todd after | checked out to [NAME]
57156 |  |  | D/C Sig | 2011-09-20 00:00:00 | 2011-09-21 00:00:00 | W/ Saeed
10128 |  |  | D/C Sig | 2011-09-20 00:00:00 | 2011-09-21 00:00:00 | W/ Saeed
10466 |  |  | D/C Sig | 2011-09-20 00:00:00 | 2011-10-07 00:00:00 | PN, then to SAEED
33215 |  |  | ATT | 2011-09-21 00:00:00 |  | To Singson after | checked out to [NAME]
81543 |  |  | DO | 2011-10-05 00:00:00 | 2011-10-07 00:00:00
31913 |  |  | HP Sig | 2011-09-26 00:00:00 | 2011-10-04 00:00:00 | DO, [NAME] then to Oad
81630 |  |  | HP Sig | 2011-09-26 00:00:00 | 2011-10-04 00:00:00 | ATT, then to Oad
989 |  |  | D/C Sig | 2011-09-27 00:00:00 | 2011-10-04 00:00:00 |  | [NAME] has pt's chart, for this admission to be placed into
48222 |  |  | D/C Sig |  |  | DO, ATT ( print x 2)
42835 |  |  | D/C Sig | 2011-10-03 00:00:00 |  | PN,ATT
75712 |  |  | PN | 2011-10-04 00:00:00 |  | DO, ATT to Saeed next
23956 |  |  | HP Sig | 2011-10-03 00:00:00 |  | PN, DO
81738 |  |  | DO | 2011-10-07 00:00:00 |  | [NAME] (print x 2)
25796 |  |  | ATT | 2011-10-07 00:00:00
5997 |  |  | D/C Sig |  |  | HP,PN,[NAME] (print x 2)
58253 |  |  | D/C Sig | 2011-10-07 00:00:00 |  | ER Sig,PN,ATT
Spreadsheet: 43391d1242062632-if-statements-book1
Sheet: Medical

Date Sent | Dentist | Medicine | Doctor | 42% Balance | Credit | Balance | .05% Interest | Total Due
2008-02-01 00:00:00 |  | 43.84 |  |  | 250
2008-02-27 00:00:00 | 1850
2008-03-05 00:00:00 |  |  | 37.6
2008-03-08 00:00:00 |  | 45.2
2008-03-28 00:00:00 | 125
2008-04-19 00:00:00 |  | 45.2
2008-04-28 00:00:00 | 125
2008-05-24 00:00:00 |  | 45.2
2008-05-28 00:00:00 | 125
2008-06-27 00:00:00 |  | 45.2
2008-06-28 00:00:00 | 125
2008-07-27 00:00:00 |  | 45.2
2008-07-28 00:00:00 | 125
2008-08-17 00:00:00 |  | 45.2
2008-08-28 00:00:00 | 125
2008-09-04 00:00:00 |  | 47.39
2008-09-28 00:00:00 | 125
2008-10-04 00:00:00 |  | 47.39
2008-10-28 00:00:00 | 125
2008-11-01 00:00:00 |  | 47.39
2008-11-28 00:00:00 | 125
2008-12-13 00:00:00 |  | 47.39
2008-12-28 00:00:00 | 125
2009-01-13 00:00:00 |  | 47.39
2009-01-28 00:00:00 | 125
2009-02-07 00:00:00 |  | 47.39
2008-02-28 00:00:00 | 125
2009-03-02 00:00:00 |  | 47.39
2009-03-28 00:00:00 | 125
2009-04-02 00:00:00 |  | 49.68
2009-04-28 00:00:00 | 125
Spreadsheet: 673197d1587242743-separating-regular-and-ot-hours-time-sheet-etaf-
Sheet: Sheet1

 | PROCESS CHAIN | CODE | RECEIPT | GENERATOR | Fri  Mid Shift | Sat | Sun | Mon | Tue | Wed | Thu | Fri  Mid Shift | Hours
 |  |  |  |  | 12 | 12 | 12 | 12 | 12 | 4
 | Total Hours for Week
 |  |  |  | Stright Time Hours Worked |  |  |  | 4 | - | -
 |  |  |  | SPV
 |  |  |  | HOLIDAY
 |  |  |  | FLOATING HOLIDAY
 |  |  |  | JURY
 |  |  |  | [NAME]
 |  |  |  | Combined Total Hours for Week
 |  |  |  | Daily Over Time Hours Worked |  |  |  | 8 | 12 | 4
 | Total Hours for Week
Spreadsheet: 146206d1331976414-when-full-shortage-quantity-is-getting-received-when-is-receipts
Sheet: Receipts Details

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Receiptsd
Product 1 | 100 |  | 500 |  | 400 |  | 600 | 5700 | 900 | 3000 | 1000 | 1000 | 1100
Product 2 | 5000 | 100 | 7000 |  | 300 |  | 700 |  | 10 | 45400 | 40 | 8750 | 100
Product 3 |  |  |  | 300 |  | 1000 |  | 5000 | 7000 | 13500 | 19000 | 875 | 900
Product 4 | 3000 |  | 1500 |  | 2800 | 5000 | 3200 | 4300 | 10000 | 2500 | 8300 | 700 | 1600
Product 5 |  | 4500 |  | 3200 |  | 5400 |  |  | 3100 |  | 65100 | 2800
Product 6 | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 14000 | 365 | 995
Product 7 |  | 1100 | 1000 | 900 |  | 800 | 700 | 600 | 500 | 35600 | 300 | 200 | 6820
Product 8 | 10 |  | 600 |  | 1000 |  |  |  |  | 10000 | 9000 | 3000 | 490
Product 9 | 500 |  | 600 |  | 80001 |  | 5000 | 3200 | 15000 | 71599 |  | 7000
Product 10 |  | 4000 |  | 30000 | 2000 | 25000 | 5000 | 5000 | 3200 | 600 | 150 | 7600 | 50