tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 277829d1384443995-calculated-field-in-pivot-table-need-to-calculate-again-pivot-table
Sheet: Sheet3

Data
Branch | Account | Sales | Times 1000 |  |  |  |  |  | Values
Branch-1 | Account-1 | 123135.38 |  |  |  |  | Branch | Account | Sum of Sales | %OF Total | Sum of Times 1000 |  |  | Column-K*1000
Branch-1 | Account-2 | 71883.44 |  |  |  |  | Branch-1 | Account-1 | 123135.38 | 0.1032676428136941 | 103.2676428136941
Branch-1 | Account-3 | 65286.15 |  |  |  |  |  | Account-10 | 42063.61 | 0.03527669994549522 | 35.27669994549522
Branch-1 | Account-4 | 65250.36 |  |  |  |  |  | Account-11 | 36461.63 | 0.03057859230421894 | 30.57859230421894
Branch-1 | Account-5 | 55262.02 |  |  |  |  |  | Account-2 | 71883.44 | 0.06028513824491071 | 60.28513824491071
Branch-1 | Account-6 | 52525.05 |  |  |  |  |  | Account-3 | 65286.15 | 0.05475231260813308 | 54.75231260813307
Branch-1 | Account-7 | 51238.99 |  |  |  |  |  | Account-4 | 65250.36 | 0.0547222972791813 | 54.7222972791813
Branch-1 | Account-8 | 49003.63 |  |  |  |  |  | Account-5 | 55262.02 | 0.04634556325341442 | 46.34556325341442
Branch-1 | Account-9 | 43591.33 |  |  |  |  |  | Account-6 | 52525.05 | 0.04405019988707896 | 44.05019988707896
Branch-1 | Account-10 | 42063.61 |  |  |  |  |  | Account-7 | 51238.99 | 0.04297164403483747 | 42.97164403483747
Branch-1 | Account-11 | 36461.63 |  |  |  |  |  | Account-8 | 49003.63 | 0.04109695653202537 | 41.09695653202537
Branch-2 | Account-12 | 130307.39 |  |  |  |  |  | Account-9 | 43591.33 | 0.03655792426363463 | 36.55792426363463
Branch-2 | Account-13 | 42742.13 |  |  |  |  | Branch-1 Total |  | 655701.59 | 0.5499049711666242 | 549.9049711666243
Branch-3 | Account-14 | 111348.01 |  |  |  |  | Branch-2 | Account-12 | 130307.39 | 0.1092824581083417 | 109.2824581083417
Branch-3 | Account-15 | 53083.56 |  |  |  |  |  | Account-13 | 42742.13 | 0.03584574160518675 | 35.84574160518675
Branch-3 | [NAME] | 52896.26 |  |  |  |  | Branch-2 Total |  | 173049.52 | 0.1451281997135285 | 145.1281997135285
Branch-3 | Account-17 | 50306.96 |  |  |  |  | Branch-3 | Account-14 | 111348.01 | 0.09338214999373569 | 93.3821499937357
Branch-3 | Account-18 | 48163.37 |  |  |  |  |  | Account-15 | 53083.56 | 0.0445185950078629 | 44.5185950078629
Branch-4 | Account-19 | 47841.46 |  |  |  |  |  | [NAME] | 52896.26 | 0.04436151562499987 | 44.36151562499987
 |  |  |  |  |  |  |  | Account-17 | 50306.96 | 0.04218999589169902 | 42.18999589169902
 |  |  |  |  |  |  |  | Account-18 | 48163.37 | 0.04039227141593092 | 40.39227141593092
 |  |  |  |  |  |  | Branch-3 Total |  | 315798.16 | 0.2648445279342284 | 264.8445279342284
 |  |  |  |  |  |  | Branch-4 | Account-19 | 47841.46 | 0.04012230118561892 | 40.12230118561892
 |  |  |  |  |  |  | Branch-4 Total |  | 47841.46 | 0.04012230118561892 | 40.12230118561892
 |  |  |  |  |  |  | Grand Total |  | 1192390.73 | 1 | 1000
 |  | What I want?
 |  | Is it possible to do Pivot calclulation of Highlighted RED column-L? (I Just want to Multiply Column-K with 1000)
 |  | 1.I have done Outside of Pivot - But I want this in Pivot table.
 |  | 2.This is Just sample of Data
Spreadsheet: 866996d1713901938-how-to-find-the-no-of-text-values-in-one-column-depending-on-criteria-in-another-column-untitled-spreadsheet
Sheet: Sheet1

 | PERCENTAGE | RESULT
 | 96.7 | Positive
 | 95 | Negative
 | 98.6 | Negative
 | 92.3 | Positive
 | 88.5 | Negative
 | 86.2 | Invalid
 | 72.3 | Negative
 | PERCENTAGE RANGES | TOTAL NO. SAMPLES | NO. OF VALID (POSITIVES AND NEGATIVES) | NO. OF INVALID
 | 70.1-80
 | 80.1-85
 | 85.1-90
 | 90.1-95
 | 95.1-100
Spreadsheet: 41150d1239662642-coppying-data-from-sheet1-to-sheet2-using-vlookup-nonarraymultiplelookup2
Sheet: Sheet1

Search Key | Product | Value | Col1 | Col2 | Col3 | Col4
1 | apple | 50 | 1 | Bin1 | Region10 | Area100
2 | apple | 60 | 0 | Bin2 | Region11 | Area101
 | orange | 40 | 1 | Bin3 | Region12 | Area102
 | lemon | 80 | 0 | Bin4 | Region13 | Area103
3 | apple | 44 | 1 | Bin5 | Region14 | Area104
4 | apple | 33 | 0 | Bin6 | Region15 | Area105
 | orange | 55 | 1 | Bin7 | Region16 | Area106
 | lemon | 70 | 0 | Bin8 | Region17 | Area107
Spreadsheet: 857034d1706121355-excel-yes-no-function-excel-calculator-_2
Sheet: Sheet1

CALCULATOR
Office | 1500
Remote | 500
[NAME] | 60 | (No need to breakdown per person)
Misc Fee | 500
Number of People
TOTAL
Participant Name (Full name) | Attending |  |  |  | Total per person
Person A | No
Person B | Yes
Person C | Yes
Person D | Yes
Person E | Yes
Person F | No
Person G | Yes
Person H | Yes
Person I | No
Person J | No
Person K | No
Person L | No
Person M | No
Person N | Yes
Person O | Yes
Person P | Yes
Person Q | Yes
Person R | No
Person S | No
Person T | No
Person U | No
Person V | No
Person W | No
Person X | No
Person Y | Yes
Person Z | Yes
Person AA | No
Person AB | Yes
Person AC | Yes
Person AD | No
Person AE | Yes
Person AF | Yes
Person AG | Yes
Person AH | No
Person AI | No
Person AJ | Yes
Spreadsheet: 80377d1280546928-of-other-question
Sheet: Data

Job # | Tech Manager | IVR Clock In
1 | [NAME]
2 | [NAME] | 7/1/10 6:03am
3 | [NAME] | 7/1/10 6:29am
4 | [NAME]
5 | Chad | 7/1/10 2:29pm
6 | Chad | 7/1/10 3:34pm
7 | Chad | 7/1/10 4:57pm
9 | Chad
10 | [NAME]
11 | [NAME]
12 | [NAME]
13 | [NAME]
14 | [NAME] | 7/1/10 7:12am
15 | [NAME] | 7/3/10 8:07am
17 | [NAME]
18 | [NAME]
Spreadsheet: 857043d1706125017-filter-with-and-or-criterias-based-on-named-range-value-filter_sample
Sheet: Sheet1

 |  |  |  |  |  | DATE FROM | 2023-10-22 00:00:00 |  | EXCLUDE
 |  |  |  |  |  | DATE TO | 2023-11-21 00:00:00 |  | A
 |  |  |  |  |  |  |  |  | E
 | DATA_A | DATA_B | DATA_C | DATA_D
 | A | 2023-10-16 14:29:00 | 781 | 147000
 | B | 2023-10-23 12:36:00 | 786 | 309750
 | C | 2023-10-25 12:41:00 | 556 | 320000 |  | Filter [DATA_ALL] between DateFrom AND DateTo |  |  |  |  | Filter [DATA_ALL] between DateFrom AND DateTo NOT [DATA_A]=[EXCLUDE]
 | E | 2023-10-26 10:02:00 | 453 | 1585443
 | D | 2023-10-30 10:10:00 | 641 | 324000 |  | DATA_A | DATA_B | DATA_C | DATA_D |  | DATA_A | DATA_B | DATA_C | DATA_D
 | E | 2023-11-02 14:44:00 | 141 | 0 |  |  | 2023-10-23 12:36:00 | 786 | 309750
 | A | 2023-11-06 13:38:00 | 285 | 70675.7805 |  | C | 2023-10-25 12:41:00 | 556 | 320000
 | A | 2023-11-08 15:24:00 | 127 | 176000 |  | E | 2023-10-26 10:02:00 | 453 | 1585443
 | E | 2024-01-17 14:52:00 | 179 | 4211.46405 |  | D | 2023-10-30 10:10:00 | 641 | 324000
 | E | 2024-01-18 11:41:00 | 383 | 285563 |  | E | 2023-11-02 14:44:00 | 141 | 0
 | E | 2024-01-22 09:56:00 | 108 | 9920 |  | A | 2023-11-06 13:38:00 | 285 | 70675.7805
 | D | 2024-01-26 09:15:00 | 156 | 33424.9 |  | A | 2023-11-08 15:24:00 | 127 | 176000
 | A | 2024-01-31 07:46:00 | 285 | 454400
 | E | 2023-11-28 15:39:00 | 457 | 31250
 | E | 2024-08-25 23:00:00 | 160 | 308614
 | D | 2024-09-15 23:00:00 | 51 | 258664
 | E | 2024-09-18 18:16:00 | 499 | 161800
 | A | 2024-09-28 16:15:00 | 779 | 58161.6
 | A | 2024-09-30 07:38:00 | 96 | 0
 | E | 2024-09-30 08:38:00 | 367 | 135710.4
Spreadsheet: 860692d1708696726-how-to-add-minutes-and-seconds-together-add-mins-secs-together-2-
Sheet: Sheet1

 | Track : | Mins:Secs |  | Running Total Mins:Secs | Running Total Hrs: Mins:Secs |  |  | RAW
 | 1 | 05:17:00 |  | 00:05:17 | 00:05:17 |  | 1 | 05:17:00
 | 2 | 03:57:00 |  | 00:09:14 | 00:09:14 |  | 2 | 03:57:00
 | 3 | 03:38:00 |  | 00:12:52 | 00:12:52 |  | 3 | 03:38:00
 | 4 | 01:47:00 |  | 00:14:39 | 00:14:39 |  | 4 | 01:47:00
 | 5 | 03:29:00 |  | 00:18:08 | 00:18:08 |  | 5 | 03:29:00
 | 6 | 04:10:00 |  | 00:22:18 | 00:22:18 |  | 6 | 04:10:00
 | 7 | 03:59:00 |  | 00:26:17 | 00:26:17 |  | 7 | 03:59:00
 | 8 | 02:51:00 |  | 00:29:08 | 00:29:08 |  | 8 | 02:51:00
 | 9 | 06:35:00 |  | 00:35:43 | 00:35:43 |  | 9 | 06:35:00
 | 10 | 04:22:00 |  | 00:40:05 | 00:40:05 |  | 10 | 04:22:00
 | 11 | 05:16:00 |  | 00:45:21 | 00:45:21 |  | 11 | 05:16:00
 | 12 | 03:00:00 |  | 00:48:21 | 00:48:21 |  | 12 | 03:00:00
 | 13 | 03:20:00 |  | 00:51:41 | 00:51:41 |  | 13 | 03:20:00
 | 14 | 03:45:00 |  | 00:55:26 | 00:55:26 |  | 14 | 03:45:00
 | 15 | 04:20:00 |  | 00:59:46 | 00:59:46 |  | 15 | 04:20:00
 | 16 | 17:04:00 |  | 01:16:50 | 01:16:50 |  | 16 | 17:04:00
 | 17 | 08:37:00 |  | 01:25:27 | 01:25:27 |  | 17 | 08:37:00
 | 18 | 03:40:00 |  | 01:29:07 | 01:29:07 |  | 18 | 03:40:00
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
Spreadsheet: 1e5b4365-85b0-4f77-8d8a-1d39c36d8cb5
Sheet: 13-Po   

UNIVERSITETI I PRISHTINËS
Nr. 120
Prishtinë , më 18 . 1 . 2012.
 | Komisioni për lirim nga pagesa e semestrit të studentëve të Universitetit të Prishtinës,në mbledhjen e mbajtur më 16.1. 2012, mori
 | V E N D I M
 | Mbi lirimin nga pagesa e semestrit për [NAME] 2010/2011
 | [NAME] 2010/2011 lirohen nga pagesa e semestrit këta studentë nga
 | Fakulteti i Shkencave Sportive
Nr. | Emri, emri i prindit dhe mbiemri | Komuna | Kategoria
1 | [NAME] Pllana | [NAME] | 3 e më shumë studentë
2 | [NAME] | Skënderaj | 3 e më shumë studentë
3 | [NAME] | Gllogoc | 3 e më shumë studentë
4 | [NAME] Thaçi | Malishevë | 3 e më shumë studentë
5 | Pajtim Bejzë Bytyqi | Gllogoc | 3 e më shumë studentë
6 | Agron Idriz Cacaj | Deçan | 3 e më shumë studentë
7 | Sali Ismet Maxhera | [NAME] | 3 e më shumë studentë
8 | Argjend [NAME] | Gllogoc | 3 e më shumë studentë
9 | [NAME] | Skënderaj | 3 e më shumë studentë
10 | Faton Destan [NAME] | [NAME] | 3 e më shumë studentë
11 | Mergim Maliq Morina | Gllogoc | 3 e më shumë studentë
12 | Blerta Sadri Abazi | Skënderaj | 3 e më shumë studentë
13 | [NAME] Ferati | Skënderaj | 3 e më shumë studentë
14 | [NAME] | Skënderaj | Asistencë sociale
15 | [NAME] Krasniqi | Prishtinë | Prindi i vrarë
16 | Dafina Faik Hajredini | Gjakovë | Prindi i vrarë
VËREJTJE:
Studentët e liruar në bazë të këtij [NAME] të paraqiten në shërbimin financiar të fakultetit gjegjës për të bërë kërkesë për [NAME] e mjeteve të paguara për semester.
 |  | K O M I S I O N I:
 |  | Prof.Dr.[NAME],kryetar              ________________
 |  | [NAME], anëtar                           ________________
 |  | [NAME], anëtar                         ________________
 |  | [NAME] Samadraxha(MASHT), anëtar ________________
 |  | Fehmi Ibrahimi(MPMS), anëtar          ________________
Spreadsheet: 71627d1272383487-dependent-validation-lists-exmaple
Sheet: Sheet1

 | Medical Expert | Paediatrics:
 | 1              Orthopaedics | a)         General Paediatrics
 | 2              Ear, Nose & Throat | b)         Oncology
 | 3              Paediatrics | c)         Anaesthetics & Pain Management
 |  | d)         [NAME]
 |  | e)         General [NAME]
 |  | f)           Neurology& Neuro-disability
 |  | g)         Psychiatrists & Psychologists
 |  | h)         [NAME] ([NAME]. Pain Management)
 |  | i)           Ear, Nose & Throat
 |  | j)           Cardio-Thoracic Surgeons
 |  | k)         Neuroradiology
 |  | l)           Gastroenterology
 |  | m)       Haematology
 |  | n)         Speech & Language Therapy
 |  | o)         Urology
 | Medical Experts | Subcategory
 | 3              Paediatrics
Spreadsheet: 472320d1469540985-need-duration-of-hours-508-elapsed-hours
Sheet: Sheet1

 | Created | Now | Hours Elapsed
1 | 2016-07-11 06:02:37.430000
 | 2016-07-18 11:56:02.047000
 | 2016-07-12 20:16:52.627000
 | 2016-07-03 21:20:45.827000
 | 2016-07-01 16:54:35.214000
 | 2016-07-10 07:14:22.484000
 | 2016-07-11 19:31:43.800000
 | 2016-06-30 08:36:51.266000
 | 2016-07-02 00:11:28.827000
 | 2016-07-22 00:25:36.245000
Spreadsheet: 113301d1309263437-calculate-the-discounted-cash-flow-and-net-present-value-business-case-omv-petrom-v1
Sheet: revenues

 |  |  |  | Revenues |  |  |  |  |  |  |  |  |  |  |  | Prog.Vers.: | V5.0
 |  |  |  | Project1 |  |  |  |  |  |  |  |  |  |  |  | Print Date: | 2011-06-28 00:00:00
 |  |  |  | 321 |  |  |  |  |  |  |  |  |  |  |  | Respons.: | [NAME]
 |  |  | 1
 |  | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030
 | BUDGETED CASH REVENUES (1.000) EUR
 | 08 - Cash revenues
 | Salary Savings | 1860.151435383246 | 1953.159007152408 | 2050.816957510028 | 2153.35780538553
 | IT Costs | 125.3352964130331 | 125.3352964130331 | 125.3352964130331 | 125.3352964130331
 | Office Costs | 207.7204067001199 | 207.7204067001199 | 207.7204067001199 | 207.7204067001199
 | Replacement Savings | 32.75544711200543 | 32.75544711200543 | 32.75544711200543 | 32.75544711200543
 | Purchasing | 300 | 300 | 300 | 300
 | Other Savings | 391.5486080217637 | 391.5486080217637 | 391.5486080217637 | 391.5486080217637
 | Savings through transferred personell | 880 | 880 | 880 | 880
 | Total cash in | 3797.511193630168 | 3890.51876539933 | 3988.176715756951 | 4090.717563632452 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | BUDGETED NON CASH BENEFITS (1.000) EUR
 | 09 - Non Cash Benefits
 | Total non cash benefits | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Rates for internal manpower in EUR*
 | per employee, per year AT | 83000
 | per employee, per month AT | 6916.666666666667
 | per employee, per day AT | 395.2380952380952
 | * for international projects you will find the internal manpower rates of each country in the sheet "Planning frame"
Spreadsheet: louise_kitchen__24091__NEWCO HEADCOUNT NAMES
Sheet: East Power Trading

East  Power Trading
Hourly | [NAME] | Analyst
ERCOT | [NAME] | Analyst
MIDWEST | [NAME] | Analyst
Hourly | [NAME] | Analyst
Hourly | [NAME] | Analyst
MIDWEST | [NAME] | Analyst | 6
Hourly | [NAME] | Associate
Hourly | [NAME] | Associate
Options | [NAME] | Associate
SOUTHEAST | [NAME] | Associate
Hourly | [NAME] Seely | Associate
ERCOT | [NAME] | Associate
NORTHEAST | [NAME] | Associate
Hourly | Punit Rawal | Associate
ERCOT | [NAME] | Associate
Hourly | [NAME] | Associate | 10
NORTHEAST | [NAME] | Clerk, Sr. | 1
ERCOT | [NAME] | Director
ERCOT | [NAME] | Director
SOUTHEAST | [NAME] | Director
NORTHEAST | [NAME] | Director | 4
Hourly | [NAME] | Manager
Genco | Eri Serio | Manager
NORTHEAST | [NAME] | Manager
Hourly | [NAME] | Manager
ERCOT | [NAME] | Manager
Genco | [NAME] | Manager
SOUTHEAST | [NAME] | Manager
SOUTHEAST | Narsihma Misra | Manager
NORTHEAST | [NAME] | Manager
Options | [NAME] | Manager
Options | [NAME] | Manager
Hourly | [NAME] | Manager | 12
MIDWEST | [NAME] | Sr. Spec
Hourly | [NAME] | Sr. Spec
Hourly | [NAME] | Sr. Spec
Hourly | [NAME] | Sr. Spec
Hourly | [NAME] | Sr. Spec
Hourly | [NAME] | Sr. Spec | 6
SOUTHEAST | [NAME] | Staff | 1
MIDWEST | [NAME] | Vice Pres
Options | [NAME] | Vice Pres
EAST POWER | [NAME] | Vice Pres
SOUTHEAST | [NAME] | Vice Pres | 4
 |  | TOTAL
Spreadsheet: 108664d1305680428-formula-help-re-recurring-dates-sample-budge
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Recurring Bills
Date |  |  |  |  |  |  |  |  |  |  |  |  |  | Day | Payee | Amount
2011-05-05 00:00:00 |  | Pay | 1500 |  | Monthly Bill 1 | 10 |  |  |  |  |  |  |  | 5 | Monthly Bill 1 | 10
2011-05-06 00:00:00 |  |  |  |  | Monthly Bill 2 | 20 |  |  |  |  |  |  |  | 6 | Monthly Bill 2 | 20
2011-05-07 00:00:00 |  |  |  |  | Other Expense | 30 |  | Total In | Total Out | Surplus |  |  |  | 13 | Monthly Bill 3 | 30
2011-05-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | Monthly [NAME] | 40
2011-05-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | Hydro | 75
2011-05-10 00:00:00
2011-05-11 00:00:00
2011-05-12 00:00:00 |  | Pay | 1500
2011-05-13 00:00:00 |  |  |  |  | Monthly Bill 3 | 30
2011-05-14 00:00:00 |  |  |  |  |  |  |  | Total In | Total Out | Surplus
2011-05-15 00:00:00
2011-05-16 00:00:00
2011-05-17 00:00:00
2011-05-18 00:00:00
2011-05-19 00:00:00 |  | Pay | 1500
2011-05-20 00:00:00
2011-05-21 00:00:00 |  |  |  |  |  |  |  | Total In | Total Out | Surplus
2011-05-22 00:00:00 |  |  |  |  | Monthly [NAME] | 40
2011-05-23 00:00:00
2011-05-24 00:00:00
2011-05-25 00:00:00
2011-05-26 00:00:00 |  | Pay | 1500
2011-05-27 00:00:00
2011-05-28 00:00:00 |  |  |  |  |  |  |  | Total In | Total Out | Surplus
2011-05-29 00:00:00
2011-05-30 00:00:00
2011-05-31 00:00:00
2011-06-01 00:00:00
2011-06-02 00:00:00 |  | Pay | 1500
2011-06-03 00:00:00
2011-06-04 00:00:00
2011-06-05 00:00:00
2011-06-06 00:00:00
2011-06-07 00:00:00
2011-06-08 00:00:00
2011-06-09 00:00:00 |  | Pay | 1500
2011-06-10 00:00:00
2011-06-11 00:00:00
2011-06-12 00:00:00
2011-06-13 00:00:00
2011-06-14 00:00:00
2011-06-15 00:00:00
2011-06-16 00:00:00 |  | Pay | 1500
2011-06-17 00:00:00
2011-06-18 00:00:00
2011-06-19 00:00:00
2011-06-20 00:00:00
2011-06-21 00:00:00
2011-06-22 00:00:00
2011-06-23 00:00:00 |  | Pay | 1500
2011-06-24 00:00:00
2011-06-25 00:00:00
2011-06-26 00:00:00
2011-06-27 00:00:00
2011-06-28 00:00:00
2011-06-29 00:00:00
2011-06-30 00:00:00 |  | Pay | 1500
Spreadsheet: 855438d1704992313-timesheet-database-sample-timesheet
Sheet: 26-Feb-24

Staff Name | Project | Project Number | Project Name | Mon | Tue | Wed | Thu | Fri
Employee 1 | 23001 - Project 1 |  |  |  |  |  |  | 7.5
Employee 1 | 23002 - Project 2
Employee 1 | 23003 - Project 3
Employee 1 | 23004 - Project 4 |  |  |  |  |  | 7.5
Employee 1 | 23005 - Project 5 |  |  | 7.5 | 7.5 | 7.5
Employee 1 | 23006 - Project 6
Employee 1 | 23007 - Project 7
Employee 1 | 23008 - Project 8
Employee 1 | 23009 - Project 9
Employee 1 | 23010 - Project 10
Spreadsheet: 216186d1361633243-how-to-copy-data-automatically-from-one-workbook-to-another-if-condition-met-workbk2
Sheet: Sheet1

Date | Customer Name | Invoice number | Amount Received | Amount Receivable
Spreadsheet: 762928d1641908319-need-to-add-own-month-from-to-end-date-sample-file
Sheet: Order List

# No | Order Date | Card | Months | Year | Month
 | 2021-01-14 00:00:00 | Card A
2 | 2021-01-14 00:00:00 | Card B
3 | 2022-02-10 00:00:00 | CARD C
4 | 2021-01-25 00:00:00 | Card A |  |  |  |  |  | Card A Bill Date | 15th everymonth | need to show the bill genrate month
5 | 2022-03-20 00:00:00 | Card A |  |  |  |  |  | Card B Billa date | 1th Every month | need to show last month
6 | 2021-01-22 00:00:00 |  |  |  |  |  |  | Card C | 30th every month | need to show same month
7 | 2021-01-26 00:00:00
8 | 2021-01-27 00:00:00
#N/A
#N/A
Spreadsheet: a6a6dbe8-0e83-4a4d-876d-87037694536e
Sheet: TTM Recon Q2FY10

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations  - Trailing Twelve Months (TTM)
(in millions, except per share data)
 | Trailing Twelve Months Ended September 30, 2009
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Lease Obligation (G&A) |  | Loss on licensed intellectual property commitment (COGS) |  | Loss on Strategic Investments |  | Restructuring Charges |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 3946 |  | 0 |  | 368 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 4314
Cost of goods sold | 2188 |  | -13 |  | 0 |  | 0 |  | -36 |  | 0 |  | 0 |  | -2 |  | 0 |  | 2137
Gross profit | 1758 |  | 13 |  | 368 |  | 0 |  | 36 |  | 0 |  | 0 |  | 2 |  | 0 |  | 2177
Operating expenses:
Marketing and sales | 717 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -18 |  | 0 |  | 699
General and administrative | 313 |  | 0 |  | 0 |  | -14 |  | 0 |  | 0 |  | 0 |  | -39 |  | 0 |  | 260
Research and development | 1259 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -118 |  | 0 |  | 1141
Acquired in-process technology | 1 |  | -1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 51 |  | -51 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Goodwill impairment | 368 |  | -368 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring charges | 77 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -77 |  | 0 |  | 0 |  | 0
Total operating expenses | 2786 |  | -420 |  | 0 |  | -14 |  | 0 |  | 0 |  | -77 |  | -175 |  | 0 |  | 2100
Operating income (loss) | -1028 |  | 433 |  | 368 |  | 14 |  | 36 |  | 0 |  | 77 |  | 177 |  | 0 |  | 77
Loss on strategic investments | -46 |  | 0 |  | 0 |  | 0 |  | 0 |  | 46 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income, net | 22 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 22
Income (loss) before provison for income taxes | -1052 |  | 433 |  | 368 |  | 14 |  | 36 |  | 46 |  | 77 |  | 177 |  | 0 |  | 99
Provision for income taxes | 256 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -229 |  | 27
Net income (loss) | -1308 |  | 433 |  | 368 |  | 14 |  | 36 |  | 46 |  | 77 |  | 177 |  | 229 |  | 72
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Diluted | -4.06 |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.23
Spreadsheet: 841582d1693750749-extract-data-from-table-depending-upon-entered-cells-to-work-for-every-row-sample-for-excel-forum-electrical-for-365-aligw
Sheet: Sheet1

 |  |  | Floor | Name | ``` | Room | , [NAME] | , Pendent Light | , 5 amp Wall light | , Door controlled light | , LED Strip  Light | , Wall up/Down | ,  1 Gang Switch | , 2 Gang Switch | , 3 Gang Switch | , 4 Gang Switch | , [NAME] | , [NAME] | , PIR | , Single Socket | , Double Socket | , 5A Wall Socket | , [NAME] power | , Velux power | , Shaver  Socket | , [NAME] | , Heated Mirror | , [NAME] | , Extractor | , [NAME] | , Appliances | , Isolator | , Mesh | , Door entry | , TV Point | , Router | , [NAME] | , [NAME] | , Pressureized Sys | , [NAME] | , Thermostat | , Ethernet point
 |  |  |  |  |  |  | 3 |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  | 6 | 6
 |  |  |  |  |  |  | 4 | 2 |  |  |  |  | 1 | 1 | 3 |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  | 1
 |  |  |  |  |  |  | 5 |  | 2 | 2 |  |  | 1 | 2 | 2 |  |  |  |  |  | 5 | 2
 |  |  |  |  |  |  | 5 |  | 2 | 2 |  |  |  |  |  |  |  |  |  |  | 5 | 2 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 1
Spreadsheet: 120896d1315609609-if-function-example
Sheet: Sheet 1 - Table 1

Customer Name | Products | No. of product
ABC | 1 | 89 | #N/A
DEF | 2 | 70 | #N/A
GHI | 1 | 140 | #N/A
JGK | 2 | 188 | #N/A
TTT | 1 | 300 | #N/A
ZZZ | 2 | 450 | #N/A
BBBB | 1 | 640 | #N/A
QQQQ | 2 | 700
Green | 1 | 1200
BBBZOO | 2 | 1011
Spreadsheet: 732390d1620922634-index-match-in-different-sheets-and-different-tables-match_index_example
Sheet: Sheet1

Program | Course | Course ID | C | Start date
Prgram One | Course 2 | 3344 | 9 | 2021-06-05 00:00:00
Prgram Two | Course 2 | 5566 | 10 | 2022-07-16 00:00:00
Prgram Three | Course 4 | 7788 | 15 | 2019-05-03 00:00:00
Prgram Four | Course 5 | 9988 | 6 | 2023-12-03 00:00:00
Spreadsheet: louise_kitchen__23029__Employees 110401
Sheet: Key Employees

Key Employees Needed for ENA Business:
 | Tier 1
Murphy | [NAME] | Spec SR Deal Compl |  | Power Physical/Financial Confirmations
Wallumrod | Ellen | Spec SR Deal Compl |  | Physical Gas Confirmations
[NAME] | [NAME] | Spec SR Deal Compl |  | Financial Confirmations
Fischer | [NAME] | Spec SR Deal Compl |  | Nymex Broker Checkout
Metoyer | [NAME] | Spec Deal Compl |  | Broker Checkout
Richardson | [NAME] | Spec Sr Global Mgmt |  | Global Contracts
Hilliard | [NAME] | Spec Sr Global Mgmt |  | Global Facilities
 | [NAME]
Indelicato | Kimberly | Spec Deal Compl |  | Power Physical/Financial Confirmations
Deming | [NAME] | Staff Deal Compl |  | Physical Confirmations
Mulvany | [NAME] | Staff Deal Compl |  | Financial Confirmations
[NAME] | [NAME] | Staff Deal Compl |  | Nymex Broker Checkout
Thompson | Kerri | Staff Deal Compl |  | Broker Checkout
Balfour-Flanagan | [NAME] | Spec Sr Global Mgmt |  | Global Contracts
Campos | [NAME] | Spec Sr Global Mgmt |  | Global Facilities