tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 199598d1355255302-which-function-to-add-to-existing-formula-excelforum-01-12-2012-formal-complaints-column
Sheet: Sheet1

 |  |  |  | Area |  |  |  |  |  | 30
 |  |  |  |  | Co | b | 21-30 | 31-40 | 41-50 | 51-99
 |  | mp |  | s |  |  | 3 | 0 | 0 | 1
 |  |  |  | cc |  |  | 0 | 0 | 0 | 0
 |  |  |  | ta |  |  | 1 | 1 | 0 | 0
 |  |  |  | cs |  |  | 0 | 0 | 0 | 0
 |  | lm |  | bm |  |  | 0 | 0 | 0 | 0
 |  | sm |  | hn |  |  | 2 | 3 | 1 | 0
 |  |  |  | o |  |  | 0 | 0 | 0 | 0
 |  | fm |  | ws |  |  | 5 | 1 | 1 | 0
 |  |  |  | m |  |  | 1 | 0 | 0 | 0
 |  |  |  | g |  |  | 0 | 0 | 0 | 0
 |  |  |  | ne |  |  | 0 | 0 | 0 | 0
 |  |  |  | n |  |  | 0 | 0 | 0 | 0
 |  |  |  | c |  |  | 0 | 0 | 0 | 0
 |  | tm |  | r |  |  | 0 | 0 | 0 | 0
 |  |  |  | cmh |  |  | 0 | 0 | 1 | 0
 |  |  |  | m |  |  | 1 | 0 | 0 | 0
 |  | cb |  | ec |  |  | 0 | 0 | 0 | 0
 |  |  |  | ech |  |  | 3 | 0 | 0 | 0
 |  | ds |  | mch |  |  | 0 | 0 | 0 | 0
 |  |  |  | p |  |  | 0 | 0 | 0 | 0
 |  | mb |  | wl |  |  | 0 | 0 | 0 | 0
 |  | ab |  | fac |  |  | 2 | 0 | 0 | 0
 |  |  |  | co |  |  | 0 | 2 | 0 | 1
 |  |  |  | fh |  |  | 0 | 0 | 0 | 0
 |  |  |  | hb |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 18 | 7 | 3 | 2
 | 21-30 | 31-40 |  | fc | e | c
 | 41-50 | 51-99 |  | 21 | 4 | 5 | 30
Name | Duration (days) | ID | Type | Area | Division
 | 21 |  | e | fac
 | 22 |  | fc | ech
 | 22 |  | fc | hn
 | 22 |  | fc | ws
 | 23 |  | c | ech
 | 23 |  | fc | s
 | 23 |  | fc | s
 | 23 |  | fc | ws
 | 24 |  | fc | ech
 | 24 |  | fc | ws
 | 24 |  | c | hn
 | 25 |  | c | fac
 | 26 |  | fc | ws
 | 27 |  | e | s
 | 28 |  | fc | ta
 | 29 |  | e | m
 | 30 |  | fc | ehp
 | 30 |  | fc | ws
 | 34 |  | e | co
 | 34 |  | fc | ta
 | 37 |  | fc | co
 | 37 |  | c | hn
 | 37 |  | fc | hn
 | 37 |  | fc | Hn
 | 37 |  | fc | ws
 | 43 |  | fc | cmh
 | 44 |  | fc | hn
 | 45 |  | fc | ws
 | 61 |  | fc | co
 | 61 |  | c | s
Spreadsheet: 692559d1598433203-formula-to-calculate-delays-book1-3-
Sheet: Sheet2

Document Out
Date | Nos. | Remaining | Delays | Needed
2020-08-13 00:00:00 | 21 | 21 |  | 5
2020-08-16 00:00:00 | 5 |  |  | 2
2020-08-18 00:00:00 | -26 |  |  | 0
2020-08-24 00:00:00 | 39 |  |  | 1
2020-08-25 00:00:00 | -39 |  |  | 0
Spreadsheet: 9d8a5a71-51e5-4781-8de2-4a8e7f266842
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
VLTB | Test | VLTB | Volatile Screen, Blood | [NAME], B | Headspace Gas Chromatography-Flame Ionization Detector (HSGC-FID) Includes methanol, ethanol, isopropanol, and acetone. | Gray-Top Tube (Potassium Oxalate/Sodium Fluoride): GryPOSF |  |  | 1 | mL | Ethylene glycol requires a separate request. See ETGL / [NAME], Serum.  Container/Tube:  Preferred: Grey top (potassium oxalate/sodium fluoride) Acceptable: Any anticoagulant [NAME]: 1 mL Collection Instructions: Do not use alcohol to clean arm. Use alternative such as Betadine to cleanse arm before collecting any specimen for volatile testing. | 0.5 mL or amount to fill 1 tube | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | METHANOL Not detected (Positive results are quantitated.) Toxic concentration: > or =10 mg/dL   ETHANOL Not detected (Positive results are quantitated.) Toxic concentration: > or =400 mg/dL   ISOPROPANOL Not detected (Positive results are quantitated.) Toxic concentration: > or =10 mg/dL   ACETONE Not detected (Positive results are quantitated.) Toxic concentration: > or =10 mg/dL | Monday through Sunday; Varies | Same day/1 day | 1 day | 1 | 84600 |  |  |  |  | Rochester
VLTB | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 72 hours
VLTB | Result | 89190 | [NAME], B | [NAME], B | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41266-8 | Volatiles:Prid:Pt:[NAME]:Nom:
VLTB | Result | 30921 | Methanol, B | Methanol, B | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 9334-4 | Methanol:MCnc:Pt:[NAME]:Qn:
VLTB | Result | 30922 | Ethanol, B | Ethanol, B | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 5640-8 | Ethanol:MCnc:Pt:[NAME]:Qn:
VLTB | Result | 30923 | Acetone, B | Acetone, B | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 9425-0 | Acetone:MCnc:Pt:[NAME]:Qn:
VLTB | Result | 30924 | Isopropanol, B | Isopropanol, B | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 5667-1 | Isopropanol:MCnc:Pt:[NAME]:Qn:
VLTB | Result | 34377 | Chain of Custody | Chain of Custody | Numeric
Spreadsheet: 266859d1379788340-help-with-sumif-forumula-lakewestassessment
Sheet: Analysis By Major

Analysis by Major
ACCT | Correct Answers | 6
 | InCorrect Answers | 4
 | % Of Correct Answers
ECON | Correct Answers
 | InCorrect Answers
 | % Of Correct Answers
FIN | Correct Answers
 | InCorrect Answers
 | % Of Correct Answers
MIS | Correct Answers
 | InCorrect Answers
 | % Of Correct Answers
MNGT | Correct Answers
 | InCorrect Answers
 | % Of Correct Answers
MRKT | Correct Answers
 | InCorrect Answers
 | % Of Correct Answers
Spreadsheet: 269505d1381177292-dynamic-file-paths-help-collated-report-2262-vancouver-mall-dr-vancouver-wa-week-35-2013
Sheet: Gross Sales

Statement of Gross Sales (V2)
Week Ending Date: |  | 09/03/2013
Store Location: |  | 2262 - Vancouver Mall Dr, Vancouver, WA
Store # |  | 2262
General Manager [NAME]:
Day |  | No. Of Sales | (A) Total Dollar Sales | (B) Net Less Over rings | (C) Less Net Promo | (D) Net Less Employee Freebies | (E) Royalty Sales
Wednesday | 2013-08-28 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
Thursday | 2013-08-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
Friday | 2013-08-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
Saturday | 2013-08-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
Sunday | 2013-09-01 00:00:00 | 1 | 0 | 0 | 0 | 0 | 0
Monday | 2013-09-02 00:00:00 | 193 | 2081.49 | 0 | 351.1 | 50.15 | 1680.24
Tuesday | 2013-09-03 00:00:00 | 229 | 2006.72 | 0 | 210 | 21.65 | 1775.07
Total |  | 423 | 4088.21 | 0 | 561.1 | 71.8 | 3455.31
Fees and Payments |  |  |  | Amount
Royalty - at 6% of Royalty Sales |  |  | Payment | 207.3186
Advertising - at 1.5% of Royalty Sales |  |  | Payment | 51.82965
Media - at 3% of Royalty Sales |  |  | Payment | 103.6593
Total of the above Payments Deposited in EDT Account |  |  |  | 362.80755
Comments
Inventory Summary
 | Beginning Inventory $ | Purchases $ | Ending Inventory $ | [NAME] %
Bread 4311 | 704.1134000000001 | 0 | 574.8694 | 0.03161383588416447
Food 4312 | 3624.941699999999 | 0 | 3132.973399999999 | 0.1203383143233836
Sides 4313 | 533.47 | 0 | 475.2400000000001 | 0.01424339747713546
Paper 4314 | 546.7899 | 0 | 490.417 | 0.01378913999036252
Produce 4315 | 158.7631 | 126.41 | 239.841 | 0.0110884959432123
Beverage 4316 | 577.9419 | 0 | 576.5074999999999 | 0.0003508626024592905
Catering 4320 | 102.5 | 0 | 101.58 | 0.0002250373635405231
Sub Total COGS | 6248.52 | 126.41 | 5591.4283 | 0.1916490835842581
Discounted COGS |  |  |  | 0.1923829010740641
Sales Summary
Shift | Amount ($)
Shift - 1 Wed AM | 0
Shift - 2 Wed PM | 0
Shift - 3 Thu AM | 0
Shift - 4 Thu PM | 0
Shift - 5 Fri AM | 0
Shift - 6 Fri PM | 0
Shift - 7 Sat AM | 0
Shift - 8 Sat PM | 0
Shift - 9 Sun AM | 0
Shift - 10 Sun PM | 0
Shift - 11 Mon AM | 1013.4
Shift - 12 Mon PM | 666.84
Shift - 13 Tue AM | 888.37
Shift - 14 Tue PM | 886.7
Royalty Sales | 3455.31
Spreadsheet: 108177d1305232288-worksheet-text-consolidation-invitee-list-sample-day92
Sheet: Phil Daley

Last Name | First Name | Title (VP,SVP, DIR, MGR) | Functional Area | Location City | Location State
Branz | [NAME] | Senior Tax Manager | Tax | Houston | TX
Sicinski | Lauren | Tax Manager | Tax | Houston | TX
Dale | [NAME] | Tax Manager | Tax | Houston | TX
Enloe | [NAME] | Manager, Indirect Tax | Tax | Atlanta | GA
Spreadsheet: 114370d1310117732-help-with-automatic-data-display-after-choice-from-drop-down-menu-copy-of-training_request_test
Sheet: Sheet1

TRAINING REQUEST FORM
COURSE | LENGTH | PO# | COURSE COST | # OF COURSES | TOTAL COST
4
EXAMPLE:
4 | 1 | 5 | 400 | 3
Spreadsheet: 130426d1322287743-search-and-copy-function-example-revised
Sheet: Sheet1

Item | Cat_1 |  |  | [NAME] | Mast_2 | Mast_3
Collect Pram | Wood |  |  | Wood | Furniture | Table Chair
use Cradle | [NAME] |  |  | Wood | [NAME] | Bed Sidewalk
Dish or else | Chemicals |  |  | Vegetable | Chopped Sliced | Beans Carrots Peas
Top Gun |  |  |  | Chemicals | Soap | Soapdish, [NAME]
Carrot steam | Vegetable |  |  | [NAME] | [NAME] | Misc items
Spreadsheet: 0fb40c29-bdfc-43e9-9c4b-ad457a283098
Sheet: Sheet1

Projects for Consideration of UTF Funding | Unnamed: 1 | Unnamed: 2
- PJB | 2008-03-28 00:00:00
I. ANNUAL REVENUE | ([NAME].)
1. Currently @ $15 | 907
2. $16 | 967.4666666666667
3. $17 | 1027.933333333333
4. $18 | 1088.4
5. $19 | 1148.866666666667
6. $20 | 1209.333333333333
II. ANNUAL EXPENSES | ([NAME].) | Cum. ([NAME].)
1. SIS | 494 | 494
2. Classroom technology | 175 | 669
3. Library technology | 175 | 844
4. Networked classrooms | 75 | 919
III. IT PROJECTS FOR CONSIDERATION | (k$) | Cost Share?
1. Classrooms
a. Complete all classrooms HD, 30 @ $20k ea. | 600 | n
b. Upgrade 110 classrooms to HD @ $5k ea. | 550 | n
c. Upgrade document cameras to digital | 110 | n
d. Install lifts in remaining large classrooms | 30 | y
2. Kiosks, expand and install in new buildings | 120 | n
3. Wireless |  | n
a. Complete 802.11 in additional buildings | 125 | some*
b. Add additional "green areas" between buildings | 100 | some
c. Upgrade to 100 Mbps 802.11n, incrementally | 210 | some
4. Keyless access, main campus, 1 exterior door | 400 | some
5. Add security cameras in major buildings | 150 | n
6. [NAME] video files to streaming, on demand | 40 | some
7. Smart chips in ID cards | 150 | some
8. CSU RamPoint portal | 125 | y
9. New technologies | 50 | sometimes
10. Total | 2760
* Investing $100k in FY 08 in management platform
Spreadsheet: 599693d1543255187-copy-cell-if-cells-in-a-range-contain-specific-text-book1-11-
Sheet: Sheet1 (2)

DATE | CLIENT | HOURS | STAFF | TIME | EACH
2018-11-27 00:00:00 | STEVE | 2:00:00 | DM |  |  |  |  |  | DM |  |  |  | KJ |  |  |  | RL
2018-11-27 00:00:00 | STEVE | 2:00:00 | KJ |  |  |  |  |  | DAY | CLIENT | HOURS |  | DAY | CLIENT | HOURS |  | DAY | CLIENT | HOURS
2018-11-27 00:00:00 | JULIE | 6:00:00 | RL |  |  |  |  |  | TUES | STEVE | 1
2018-11-27 00:00:00 | JULIE | 6:00:00 | LH |  |  |  |  |  | TUES | SFA | 2.5
2018-11-27 00:00:00 | JO | 2:00:00 | RL |  |  |  |  |  | TUES | CCA | 2
2018-11-27 00:00:00 | JO | 2:00:00 | LH |  |  |  |  |  | WED | DAVE | 1.25
2018-11-27 00:00:00 | DANNY | 2:30:00 | SM |  |  |  |  |  | WED | LESLEY | 2
2018-11-27 00:00:00 | MARY | 2:00:00 | SM |  |  |  |  |  | WED | KIRSTY | 1.25
2018-11-27 00:00:00 | [NAME] | 3:00:00 | SM
2018-11-27 00:00:00 | [NAME] | 3:00:00 | LB
2018-11-27 00:00:00 | R&R'S | 2:30:00 | TB
2018-11-27 00:00:00 | SFA | 2:30:00 | DM
2018-11-27 00:00:00 | CCA | 2:00:00 | DM
2018-11-27 00:00:00 | SARAH | 3:00:00 | LB
2018-11-27 00:00:00 | LAURA | 3:00:00 | LB
2018-11-27 00:00:00 | [NAME] | 2:00:00 | LH
2018-11-27 00:00:00 | SYLVIA | 2:00:00 | RL
2018-11-27 00:00:00 | ALEX | 4:00:00 | TB
2018-11-27 00:00:00 | ALEX | 4:00:00 | LH
2018-11-27 00:00:00 | ALEX | 4:00:00 | SM
2018-11-27 00:00:00 | JUSTIN | 1:30:00 | RL
2018-11-28 00:00:00 | DAVE | 2:30:00 | KJ
2018-11-28 00:00:00 | DAVE | 2:30:00 | DM
2018-11-28 00:00:00 | [NAME] | 2:30:00 | RL
2018-11-28 00:00:00 | [NAME] | 2:30:00 | LH
2018-11-28 00:00:00 | SHIRLEY | 2:00:00 | RL
2018-11-28 00:00:00 | ALAN | 3:00:00 | SM
2018-11-28 00:00:00 | BOB | 3:00:00 | SM
2018-11-28 00:00:00 | REBECCA | 2:00:00 | LB
2018-11-28 00:00:00 | SARA | 2:00:00 | TB
2018-11-28 00:00:00 | LESLEY | 2:00:00 | DM
2018-11-28 00:00:00 | KIRSTY | 2:30:00 | DM
2018-11-28 00:00:00 | KIRSTY | 2:30:00 | LB
2018-11-28 00:00:00 | OWEN | 2:00:00 | LB
2018-11-28 00:00:00 | MADDIE | 3:00:00 | LB
2018-11-28 00:00:00 | DAWN | 2:00:00 | TK
2018-11-28 00:00:00 | EMMA | 6:00:00 | RL
2018-11-28 00:00:00 | DAN | 2:30:00 | TB
2018-11-28 00:00:00 | DAN | 2:30:00 | TB
2018-11-28 00:00:00 | [NAME] | 2:30:00 | RL
Spreadsheet: 750873d1633704889-how-to-calculate-a-date-when-its-involving-a-text-book1
Sheet: Sheet10

Name | Column2 | Review Date | Column4 | # of notes 3 or more months behind | # of notes 2 months behind | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14
Spreadsheet: 766275d1643824594-formula-to-restart-vacation-days-on-anniversary-date-manager-vacation-tracker
Sheet: List of Employees

 | List of Employees
 | Employee Names | Start Date | Vacation Days (Paid) |  | Anniversary Reset | Vacation Days Remaining | Unpaid
 | [NAME] | 2000-07-03 00:00:00 | 10
 | [NAME] | 2007-03-22 00:00:00 | 10
 | [NAME] | 2007-08-01 00:00:00 | 14
 | [NAME] | 2009-03-09 00:00:00 | 14
 | [NAME] | 2009-06-07 00:00:00 | 14
 | [NAME] | 2010-06-07 00:00:00 | 10
 | [NAME] | 2011-03-28 00:00:00 | 10
 | Danial Gray | 2014-07-08 00:00:00 | 14
 | Deland Kolewe | 2015-06-09 00:00:00 | 14
 | [NAME] | 2016-07-10 00:00:00 | 14
 | [NAME] | 2015-11-22 00:00:00 | 10
 | [NAME] | 2019-01-01 00:00:00 | 10
 | [NAME] | 2019-09-18 00:00:00 | 14
 | [NAME] | 2019-12-12 00:00:00 | 14
 | Christian Rodriguez | 2020-06-30 00:00:00 | 7
 | [NAME] | 2020-07-01 00:00:00 | 14
 | [NAME] | 2020-12-15 00:00:00 | 7
 | Ikaika Hoke | 2021-02-08 00:00:00 | 14
 | [NAME] | 2021-01-11 00:00:00 | 14
 | [NAME] | 2019-11-20 00:00:00 | 14
 | [NAME] | 2020-09-07 00:00:00 | 14
 | [NAME] | 2021-06-17 00:00:00 | 14
 | [NAME] | 2021-07-21 00:00:00 | 7
 | [NAME] | 2021-05-10 00:00:00 | 7
 | [NAME] | 2021-03-17 00:00:00 | 7
 | [NAME] | 2021-06-30 00:00:00 | 7
 | [NAME] | 2021-06-30 00:00:00 | 14
 | [NAME] | 2021-04-12 00:00:00 | 14
 | [NAME] | 2021-08-08 00:00:00 | 14
 | [NAME] | 2021-08-30 00:00:00 | 14
 | [NAME] | 2021-10-25 00:00:00 | 14
 | [NAME] | 2021-10-28 00:00:00 | 14
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 274974d1383298394-list-client-appointments-outside-of-normal-induction-dates-client-bookings-register
Sheet: Calc Sheet

Week Number | Week 1 | Week 2 | Week 3 | Week4 | Week 5 | Extra Bookings | Start Date | End Date | Start Date | End Date | Start Date | End Date | Start Date | End Date | Start Date | End Date | Start Date | End Date | Start Date | End Date
Date |  |  |  |  |  |  | 2013-11-01 00:00:00 | 2013-11-01 00:00:00 | 2013-11-05 00:00:00 | 2013-11-08 00:00:00 | 2013-11-12 00:00:00 | 2013-11-15 00:00:00 | 2013-11-19 00:00:00 | 2013-11-22 00:00:00 | 2013-11-26 00:00:00 | 2013-11-29 00:00:00
Bookings | 1 | 1 | 1 | 2 |  |  | 4 |  | 1 |  | 1
 |  |  |  |  |  |  | I need dates to auto fill (blue cells) with the days not covered by the Week 1,2,3,4,5 dates, so if an induction occurs on a Tuesday then I need the booking to show in the grey boxes above under the corresponding dates.
 | Month Select
 | Year Select
 |  |  |  |  |  |  |  | I have an array formula (in the name column of the bookings display sheet) that works great for the Monday dates but I need it altered to accommodate every other date and list the appointments.
 | Months | Year |  | Monday Only Dates For Induction Bookings
 | January | 2013 |  |  |  |  |  | "=IFERROR(INDEX(Appointments!E:E,SMALL(IF(Appointments!$G$5:$G$10000=$E$2,IF(Appointments!$B$5:$B$10000=1,ROW(Appointments!$B$5:$B$10000))),ROWS(G$38:G38))),"")"
 | February | 2014
 | March | 2015
 | April | 2016 |  |  |  |  |  | Each date is at the top of each sectiona and there are 6 appointment slots for each induction Monday, E is the Name Range, G looks for the date to match, B checks if the date is an initial appointment & the second set of G is the on sheet range lookup
 | May | 2017
 | June | 2018 |  | User Filled Example Appoinments Sheet
 | July | 2019 |  | Name | Date | Client No. | Requirement
 | August | 2020 |  | Mr A | 2013-11-04 00:00:00 | 1 | 100
 | September | 2021 |  | Mr B | 2013-11-11 00:00:00 | 2 | 200
 | October | 2022 |  | Mr C | 2013-11-18 00:00:00 | 3 | 150
 | November | 2023 |  | Mr D | 2013-11-25 00:00:00 | 4 | 230
 | December | 2024 |  | Mr E | 2013-11-01 00:00:00 | 5 | 650
 |  |  |  | Mr F | 2013-11-01 00:00:00 | 6 | 150
 |  |  |  | Mr G | 2013-11-01 00:00:00 | 7 | 450
 |  |  |  | Mr H | 2013-11-01 00:00:00 | 8 | 125
 |  |  |  | Mr I | 2013-11-06 00:00:00 | 9 | 175
 |  |  |  | Mr J | 2013-11-14 00:00:00 | 10 | 190
Spreadsheet: 788619d1658580195-sum-data-based-on-matching-name-but-ignoring-blanks-activities
Sheet: Sheet1

Task | Minutes | Pets |  | Task | TOTAL Minutes | TOTAL Minutes (with Pets)
Walking | 100 | Poppy |  | Walking
Running | 10 | Millicent |  | Running
Cycling | 1 | Rexar |  | Cycling
Walking | 200
Running | 20
Cycling | 2
Walking | 300 | Sir Vermillion
Running | 30 | [NAME]
Cycling | 3 | [NAME]
Spreadsheet: 796502d1663318700-how-to-get-the-column-d-correct-birthday-date-with-a-formula-forum09-16
Sheet: Sheet1

 | date of birth |  | correct date | Wrong formula
 | 2008-12-19 00:00:00 |  | 2022-12-19 00:00:00
 | 2011-01-14 00:00:00 |  | 2022-01-14 00:00:00
 | 2016-02-29 00:00:00 |  | 2022-02-28 00:00:00
 | 2007-04-04 00:00:00 |  | 2022-04-04 00:00:00
 | 1998-11-08 00:00:00 |  | 2022-11-08 00:00:00
 | 2016-02-28 00:00:00 |  | 2022-02-28 00:00:00
 | 2000-07-09 00:00:00 |  | 2022-07-09 00:00:00
 | 2000-02-29 00:00:00 |  | 2022-02-28 00:00:00
 | 1988-04-24 00:00:00 |  | 2022-04-24 00:00:00
Spreadsheet: 274656d1383172721-compare-a-and-c-column-if-match-my-logic-display-result-in-b-column-blank
Sheet: Sheet1

NUMBER STATUS | ERRORS | need formula in this column
React for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME] | CUG NOT GIVEN | CUG NOT GIVEN  Susp for TV process [NAME] |  | THIS LOGIC IS….
React for TV process [NAME]
React for TV process [NAME] | CUG NOT GIVEN |  |  | A column, Susp for TV + B column Error message= A+B in D column
React for TV process [NAME] |  |  |  | A column, React for TV + B column Error message= blank in D column
Susp for TV process [NAME] | CUG NOT GIVEN | CUG NOT GIVEN  Susp for TV process [NAME] |  | if column B is blank then C column also should appear blank
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME] | PLAN CHANGED
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME] | PLAN CHANGED
Susp for TV process [NAME]
New Activation
React for TV process [NAME]
React for TV process [NAME] | PLAN CHANGED
React for TV process [NAME]
React for TV process [NAME]
MNP portablity activations
React for TV process [NAME]
React for TV process [NAME] | CUG NOT GIVEN
React for TV process [NAME]
Susp for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME] | CUG NOT GIVEN | CUG NOT GIVEN  Susp for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME] | CUG NOT GIVEN
Susp for TV process [NAME] | PLAN CHANGED | PLAN CHANGED    Susp for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME] | LOC+STD @Rs 25 | LOC+STD @Rs 25 Susp for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME] | CUG NOT GIVEN | CUG NOT GIVEN  Susp for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME] | CUG NOT GIVEN | CUG NOT GIVEN  Susp for TV process [NAME]
New Activation
Spreadsheet: 848772d1699404496-workforce-planning-formula-workforce-planning-template
Sheet: Reference

Departments | Segment | Month
Corporate | ID | 2024-01-01 00:00:00
Finance | OH | 2024-02-01 00:00:00
Fleet |  | 2024-03-01 00:00:00
HR |  | 2024-04-01 00:00:00
Operations |  | 2024-05-01 00:00:00
Safety |  | 2024-06-01 00:00:00
Sales |  | 2024-07-01 00:00:00
 |  | 2024-08-01 00:00:00
 |  | 2024-09-01 00:00:00
 |  | 2024-10-01 00:00:00
 |  | 2024-11-01 00:00:00
 |  | 2024-12-01 00:00:00
Spreadsheet: 221214d1363419648-nearest-value-yyy
Sheet: version 2

235 | 140 | 700 | 150 | North | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Coords |  | Latitude |  | Logitude
 | 140 | 700 | 300 | Central |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 142630307
 | 140 | 700 | 450 | South
 |  |  |  |  | 140 | 550 | 300 | West
 |  |  |  |  | 140 | 850 | 300 | East |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 141599 | 236
236 | 141 | 300 | 150 | North |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 142199 | 237
 | 141 | 300 | 300 | Central |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 142200 | 238
 | 141 | 300 | 450 | South
 |  |  |  |  | 141 | 150 | 300 | West
 |  |  |  |  | 141 | 450 | 300 | East
237 | 141 | 900 | 150 | North |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 141600600 | 141600000
 | 141 | 900 | 300 | Central |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 142200600 | 142200000
 | 141 | 900 | 450 | South
 |  |  |  |  | 141 | 750 | 300 | West
 |  |  |  |  | 142 | 050 | 300 | East
238 | 142 | 500 | 150 | North
 | 142 | 500 | 300 | Central
 | 142 | 500 | 450 | South
 |  |  |  |  | 142 | 350 | 300 | West
 |  |  |  |  | 142 | 650 | 300 | East
239 | 143 | 100 | 150 | North
 | 143 | 100 | 300 | Central
 | 143 | 100 | 450 | South
 |  |  |  |  | 142 | 950 | 300 | West
 |  |  |  |  | 143 | 250 | 300 | East
Spreadsheet: mark_guzman__24542__Deal Correction Oct-00
Sheet: Prior Day

Adjustment date | Date of applied calc | Deal Date | Desk | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
2000-10-02 00:00:00 | 2000-10-02 00:00:00 | 2000-08-22 00:00:00 | LTWMGM | [NAME] | PORTLAND | NONE | TERM: OCT-00 [NAME] | Blck Frwd | 397777 | SP-15 | 2000-09-01 00:00:00 | P | 25 | PX SP-15 | CALPX=BF
2000-10-02 00:00:00 | 2000-10-02 00:00:00 | 2000-08-22 00:00:00 | LTWMGM | [NAME] | PORTLAND | NONE | Price: 85.00 to 164 | swap | 397778 | financial sp-15 | 2000-09-01 00:00:00 | p | 25 | 164 | calpxtrading
2000-10-02 00:00:00 | 2000-10-03 00:00:00 | 2000-10-02 00:00:00 | LTNW | M.S. | HOUSTON | NAT | MISSING DEAL: INPUT |  | 425875 | MID-C | 2000-12-01 00:00:00 | OP | -25 | 88 | SCEM
2000-10-02 00:00:00 | 2000-10-02 00:00:00 | 2000-10-02 00:00:00 | STNW | S.C. | HOUSTON | PREBON | FROM PEAK TO AN OFF-PEAK DEAL | SPREAD | 425360 & 361 | MID-C | 2000-10-03 00:00:00 | op | 25/-25 | 90/85 | sempra
2000-10-02 00:00:00 | 2000-10-02 00:00:00 | 2000-08-30 00:00:00 | LTCALI | ENPOWER | PORTLAND | NONE | MASK: ALL DAYS TO M-S |  | 403599 | NP-15 | Q4-00 | P | -25 | PXNP15 | CALPX
2000-10-02 00:00:00 | 2000-10-02 00:00:00 | 2000-08-30 00:00:00 | LTCALI | ENPOWER | PORTLAND | NONE | MASK: ALL DAYS TO M-S |  | 403603 | NP-15 | V-00 | P | -25 | PXNP15 | CALPX
2000-10-02 00:00:00 | 2000-10-03 00:00:00 | 2000-10-02 00:00:00 | LTNW | M.S. | HOUSTON | NAT | MISSING DEAL: INPUT |  | 425875 | MID-C | 2000-12-01 00:00:00 | OP | -25 | 88 | SCEM
2000-10-03 00:00:00 | 2000-10-03 00:00:00 | 2000-09-29 00:00:00 | STCA | [NAME] | HOUSTON | AMEREX | MISSING DEAL: INPUT ON 9/30 |  | 424983 | SP-15 | 2000-10-01 00:00:00 | P | 50 | 95 | WESCO
2000-10-03 00:00:00 | 2000-10-03 00:00:00 | 2000-10-02 00:00:00 | STSW | B.B. | HOUSTON | T.F.S. | CHANGED PEAK TO OFF-PEAK |  | 425718 | NP-15 | X-Z-00 | OP | 25 | 67 | CONST
2000-10-03 00:00:00 | 2000-10-04 00:00:00 | 2000-10-03 00:00:00 | LTSW | [NAME] | HOUSTON | BLOOMBRG | MISSING DEAL: INPUT |  | 426927 | MID-C | Z-00 | P | -25 | 76 | MORGAN
2000-10-04 00:00:00 | n/a | 2000-10-04 00:00:00 | STCA | C.M. | HOUSTON | BLOOMBERG | BROKER: APB TO BLOOMBERG |  | 427259
2000-10-04 00:00:00 | N/A | 2000-10-04 00:00:00 | STCA | C.M. | HOUSTON | APB | BROKER: PREBON TO APB |  | 427579
2000-10-04 00:00:00 | N/A | 2000-10-04 00:00:00 | STCA | C.M. | HOUSTON | PREBON | CNTRPRTY: EL PASO GAS TO EPEM |  | 427809
 |  |  | [NAME]
2000-10-04 00:00:00 | N/A | 2000-10-04 00:00:00 | LTNW | [NAME] | HOUSTON |  | Purchase: BUY TO A SALE |  | 427858
 |  |  | [NAME]
 |  |  | Grand Count