tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 785620d1656515623-auto-calculate-workdays-for-table-monthly-referral-tracking-sheet-adjusting
Sheet: October

2022-10-01 00:00:00 |  |  |  |  |  | Monthly Admission Goal: | 0
 |  |  |  |  |  | Month's Working Days:
 |  |  |  |  |  | Daily Referral Goal:
 |  |  |  |  |  | Referrals Still Needed to Meet Goal:
 | Mon | Tue | Wed | Thu | Fri | Actual Referrals/Week | Weekly Referral Goal
Week 1 | 0 | 0 | 0 | 0 | 0
Week 2 | 0 | 0 | 0 | 0 | 0
Week 3 | 0 | 0 | 0 | 0 | 0
Week 4 | 0 | 0 | 0 | 0 | 0
Week 5 | 0
 |  |  |  |  | TOTAL:
Spreadsheet: 85440d1285553744-format-is-there-a-short-cut-way-book2
Sheet: Sheet2

Cell A1 | cell B1 | cell C1
Cell A2 | cell B2 | cell C2
Cell A3 | cell B3 | cell [NAME]
Cell A4 | cell B4 | cell C4
Cell A5 | cell B5 | cell C5
Cell A6 | cell [NAME] | cell C6
Cell A7 | cell [NAME] | cell [NAME]
Cell A8 | cell B8 | cell C8
Cell A9 | cell B9 | cell C9
Cell A10 | cell B10 | cell C10
Cell A11 | cell B11 | cell C11
Cell A12 | cell B12 | cell C12
Cell A13 | cell B13 | cell C13
Cell A14 | cell B14 | cell C14
Cell A15 | cell B15 | cell C15
Cell A16 | cell B16 | cell C16
Cell A17 | cell B17 | cell C17
Cell A18 | cell B18 | cell C18
Cell A19 | cell B19 | cell C19
Cell A20 | cell [NAME] | cell C20
Cell A27 | cell B27 | cell C27
Cell A22 | cell B22 | cell C22
Cell A23 | cell B23 | cell C23
Cell A24 | cell B24 | cell C24
Cell A25 | cell B25 | cell C25
Cell A26 | cell B26 | cell C26
Cell A27 | cell B27 | cell C27
Cell A28 | cell B28 | cell C28
Cell A29 | cell B29 | cell C29
Cell A30 | cell B30 | cell C30
Cell A37 | cell B37 | cell C37
Cell A38 | cell B38 | cell C38
Cell A33 | cell B33 | cell C33
Cell A34 | cell B34 | cell C34
Spreadsheet: 114842d1310552559-finding-the-hidden-words-in-strings-of-letters-sumproduct
Sheet: Prova

YDHEIHGKCEWEC |  | SUN | 3
RIGJSTARSDSFDH |  | MOON | 2
JDSUNDHXSUNFL |  | STAR | 3
HFYEIDGSKQWK |  | ARIZONA | 1
STARCBVNZTMOONWRSUNH |  | PIPPO | 3
DASFRERPIPPOTYBJHX
[NAME]
LKJHMOONDFJHU
testSTARIZONAtest
DASFRERPIPPOTYBJHXPIPPO
Spreadsheet: 886036d1735996734-nearest-value-formula-need-nearest-value-formula-need
Sheet: Sheet1

 | 24019
 |  | 23900 |  |  |  |  |  | BAT:BATCH09JAN25C23900
 |  | 23950 |  |  |  |  |  | BAT:BATCH09JAN25C23950
 |  | 24000 |  |  |  |  |  | BAT:BATCH09JAN25C24000
 |  | 24050 |  |  |  |  |  | BAT:BATCH09JAN25C24050
 |  | 24100 |  |  |  |  |  | BAT:BATCH09JAN25C24100
 |  | 24150 |  |  |  |  |  | BAT:BATCH09JAN25C24150
 |  | 24200 |  |  |  |  |  | BAT:BATCH09JAN25C24200
 |  | 24250 |  |  |  |  |  | BAT:BATCH09JAN25C24250
 |  | 24300 |  |  |  |  |  | BAT:BATCH09JAN25C24300
 |  | 24350 |  |  |  |  |  | BAT:BATCH09JAN25C24350
 |  | 24400 |  |  |  |  |  | BAT:BATCH09JAN25C24400
 |  | 24450 |  |  |  |  |  | BAT:BATCH09JAN25C24450
 |  | 24500 |  |  |  |  |  | BAT:BATCH09JAN25C24500
 |  | 24550 |  |  |  |  |  | BAT:BATCH09JAN25C24550
 |  | 24600 |  |  |  |  |  | BAT:BATCH09JAN25C24600
 |  | 24650 |  |  |  |  |  | BAT:[NAME]
 |  | 24700 |  |  |  |  |  | BAT:BATCH09JAN25C24700
 |  | 24750 |  |  |  |  |  | BAT:BATCH09JAN25C24750
 |  | 24800 |  |  |  |  |  | BAT:BATCH09JAN25C24800
 |  | 24850 |  |  |  |  |  | BAT:BATCH09JAN25C24850
 |  | 24900 |  |  |  |  |  | BAT:BATCH09JAN25C24900
 |  | 24950 |  |  |  |  |  | BAT:BATCH09JAN25C24950
 |  |  | FORMULA |  |  |  |  | BAT:BATCH09JAN25C24000 | FORMULA REQUIRED
 |  |  | FORMULA |  |  |  |  | BAT:BATCH09JAN25C24050 | FORMULA REQUIRED
Spreadsheet: 794928d1662404683-random-number-with-condition-random
Sheet: Blad1

650000 |  | random | marge | delta | new random | Roundings
1999000
wanted value
17552000
Spreadsheet: 175388d1345508590-sort-data-into-specific-domain-range-brackets-ef165_demonstration
Sheet: Sheet1

Before |  |  |  | After
Raw Data |  |  |  | Separated Data
Qx | Qy
1 | 10 |  |  | [NAME] (1:5):(1:5) |  |  | [NAME] (6:10):(1:5)
1 | 9 |  |  | Qx | Qy |  | Qx | Qy
1 | 8 |  |  | 1 | 1 |  | 6 | 1
1 | 7 |  |  | 1 | 2 |  | 6 | 2
1 | 6 |  |  | 1 | 3 |  | 6 | 3
1 | 5 |  |  | 1 | 4 |  | 6 | 4
1 | 4 |  |  | 1 | 5 |  | 6 | 5
1 | 3 |  |  | 2 | 1 |  | 7 | 1
1 | 2 |  |  | 2 | 2 |  | 7 | 2
1 | 1 |  |  | 2 | 3 |  | 7 | 3
2 | 10 |  |  | 2 | 4 |  | 7 | 4
2 | 9 |  |  | 2 | 5 |  | 7 | 5
2 | 8 |  |  | 3 | 1 |  | 8 | 1
2 | 7 |  |  | 3 | 2 |  | 8 | 2
2 | 6 |  |  | 3 | 3 |  | 8 | 3
2 | 5 |  |  | 3 | 4 |  | 8 | 4
2 | 4 |  |  | 3 | 5 |  | 8 | 5
2 | 3 |  |  | 4 | 1 |  | 9 | 1
2 | 2 |  |  | 4 | 2 |  | 9 | 2
2 | 1 |  |  | 4 | 3 |  | 9 | 3
3 | 10 |  |  | 4 | 4 |  | 9 | 4
3 | 9 |  |  | 4 | 5 |  | 9 | 5
3 | 8 |  |  | 5 | 1 |  | 10 | 1
3 | 7 |  |  | 5 | 2 |  | 10 | 2
3 | 6 |  |  | 5 | 3 |  | 10 | 3
3 | 5 |  |  | 5 | 4 |  | 10 | 4
3 | 4 |  |  | 5 | 5 |  | 10 | 5
3 | 3
3 | 2
3 | 1
4 | 10
4 | 9
4 | 8
4 | 7
4 | 6
4 | 5
4 | 4
4 | 3
4 | 2
4 | 1
5 | 10
5 | 9
5 | 8
5 | 7
5 | 6
5 | 5
5 | 4
5 | 3
5 | 2
5 | 1
6 | 10
6 | 9
6 | 8
6 | 7
6 | 6
6 | 5
6 | 4
6 | 3
6 | 2
6 | 1
7 | 10
7 | 9
7 | 8
7 | 7
7 | 6
7 | 5
7 | 4
7 | 3
7 | 2
7 | 1
8 | 10
8 | 9
8 | 8
8 | 7
8 | 6
8 | 5
8 | 4
8 | 3
8 | 2
8 | 1
9 | 10
9 | 9
9 | 8
9 | 7
9 | 6
9 | 5
9 | 4
9 | 3
9 | 2
9 | 1
10 | 10
10 | 9
10 | 8
10 | 7
10 | 6
10 | 5
10 | 4
10 | 3
10 | 2
10 | 1
Spreadsheet: 73500d1274174521-choose-a-value-in-the-dropdown-and-make-formula-lookup-in-the-relevant-table-kpi-trial
Sheet: MAIN

 | U2 Packaging Key Performance Indicator
 | Shift | DS2 |  |  | Efficiency |  |  |  |  |  |  |  | Staffing |  |  |  |  |  |  | When I select a shift in C5, I want formula to count number of the names in the stafflist minus those within this table and plus those in that table
 | Date | 2010-05-04 00:00:00 |  |  | No. of Staff | Man hours used | Sets packed | Process credits | [NAME] to target |  |  |  | H | S | UNPD
 | Sets to pack | 142 |  |  |  |  |  |  |  |  |  |  | Staff 4x4
 | Room leader | [NAME] |  |  |  |  | 100 | 177 | 0.704225352112676 |  |  |  | Holidays | Sick | Unpaid leave
 |  |  |  |  | Efficiency indicator |  |  |  |  |  |  |  | DayShift2 name 6 | DayShift2 name 9 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | DayShift2 name 15 | DayShift2 name 12 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | DayShift2 name 18 | DayShift2 name 20 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A
 | Products | Tasks |  |  |  |  |  |  |  | Process credits |  |  | #N/A | #N/A | #N/A
 |  | COLOUR | CARAMEL | TOPPING | CUTTING | BOATING | PACKING | REWRAPING | MISC |  |  |  | #N/A | #N/A | #N/A
 | WTWBNL | Black |  |  | 77 |  | 100 |  |  | 177 |  |  | #N/A | #N/A | #N/A |  |  |  |  |  |  | All these blank cells contain errors that are hidden by Conditional formating. [NAME]( doesn`t work. How to get rid of them?
 | WETGR |  |  |  | 88 |  |  |  |  | 0 |  |  | Staff 8 Hrs Earlies
 | WTFNFJ |  |  |  |  |  |  |  |  | 0 |  |  | Holidays | Sick | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | Earlies name1
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | Earlies [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | Staff 8 Hrs Lates
 |  |  |  |  |  |  |  |  |  |  |  |  | Holidays | Sick | Unpaid leave |  | DS1 | DS2
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | Lates name1 |  | DS2 | DS1
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | Lates name2 |  | NS1 | NS2
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A |  | NS2 | NS1
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | Overtime | Hours transferred
 |  |  |  |  |  |  |  |  |  |  |  |  |  | IN | OUT
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | DayShift1 name9 | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  | DayShift1 name15 | Where to? | Where to?
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | TOTAL | 177
Spreadsheet: 62885d1263887876-weekend-shift-patterns-book2
Sheet: Sheet1

 |  |  |  | WEEK |  |  | [NAME]
 | DATUM | IN | OUT | 2400 - 0700 | 0700 - 1800 | 1800 - 2400 | 0000 - 2400
 | 2009-12-14 00:00:00 | 22:00:00 | 06:00:00 | 06:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 06:00:00
 | 2009-12-15 00:00:00 | 07:53:00 | 08:55:00 | 1900-01-01 00:00:00 | 01:02:00 | 1900-01-01 00:00:00 | 01:02:00
 | 2009-12-15 00:00:00 | 19:24:00 | 22:23:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 02:59:00 | 02:59:00
 | 2009-12-16 00:00:00 | 15:31:00 | 22:58:00 | 1900-01-01 00:00:00 | 02:29:00 | 04:58:00 | 07:27:00
 | 2009-12-17 00:00:00 | 13:27:00 | 19:28:00 | 1900-01-01 00:00:00 | 04:33:00 | 01:28:00 | 06:01:00
 | 2009-12-18 00:00:00 | 07:20:00 | 15:50:00 | 1900-01-01 00:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 08:30:00
 | 2009-12-19 00:00:00 | 15:50:00 | 23:14:00 | 1900-01-01 00:00:00 | 02:10:00 | 05:14:00 | 07:24:00
 | 2009-12-20 00:00:00 | 22:00:00 | 05:00:00 | 05:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 05:00:00
 | 2009-12-15 00:00:00 | 20:15:00 | 22:23:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 02:08:00 | 02:08:00
Spreadsheet: 164666d1340834329-how-to-get-specific-information-from-data-trial-oeldere-
Sheet: Blad1

 | Waarden
Rijlabels | count Employee | [NAME] Column1
Analytical Instrumentation | 160 | 25
ABB | 56 | 6
Drager | 8 | 3
Durag | 16 | 2
ICCS | 8 | 2
K-Patent | 8 | 0
Metso | 8 | 1
MSA | 8 | 4
Process Sensor | 8 | 1
Quadbeam | 8 | 0
Rexa | 8 | 0
SMA | 8 | 6
SOFRASER | 8 | 0
Stonel | 8 | 0
Controllers | 64 | 6
ABB | 16 | 0
ABB  - Paper | 8 | 0
[NAME] | 8 | 2
[NAME] | 16 | 0
Precision Digital | 8 | 3
Protronics | 8 | 1
Debitmetre | 102 | 38
ABB | 40 | 28
[NAME] | 6 | 0
Burkert | 8 | 0
[NAME] | 8 | 1
COX | 8 | 0
IDFlow | 8 | 8
Kayden | 8 | 0
Khrone | 8 | 0
[NAME] | 8 | 1
[NAME] | 64 | 38
ABB | 8 | 12
Enraf | 8 | 3
Vega | 48 | 23
Transmitters | 72 | 54
ABB | 16 | 29
Fieldbus | 8 | 0
Hart | 8 | 5
Intempco | 8 | 3
NoShok | 8 | 8
Proifbus | 8 | 1
Vega | 8 | 0
Wika | 8 | 8
(leeg) | 2 | 0
[NAME] | 2 | 0
Eindtotaal | 464 | 161
Spreadsheet: 866946d1713861528-radar-chart-help-i-tried-test
Sheet: Radar

 | P3M3 Maturity Score Result
 | P3M3 Maturity Categories | Score |  | P3M3 Maturity Scoring Options | Score |  |  |  |  |  | Stakeholder Management & Comms | Risk & Issues Management | Management Control | Benefits Management | Cost Management | Governance & Reporting | Resource Management
 | Stakeholder Management & Comms | 1 |  | Level 1 Initital Awareness | 1 |  |  |  |  |  | 1 | 2 | 1 | 1 | 1 | 1 | 1
 | Risk & Issues Management | 2 |  | Level 2 Repeatable | 2 |  |  |  |  |  | 2 | 2 | 3 | 2 | 1 | 1 | 2
 | Management Control | 1 |  | Level 3 Defined | 3
 | Benefits Management | 1 |  | Level 4 Managed | 4
 | Cost Management | 1 |  | Level 5 Optimised | 5
 | Governance & Reporting | 1
 | Resource Management | 1
Spreadsheet: 105281d1302693833-how-to-get-data-from-different-years-2011-to-start-the-same-year-year1-example3000
Sheet: Sheet1

 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016
region 1 | 1 | 2 | 3 | 45
region 2 |  | 1 | 6 | 9
region 3 |  |  | 2 | 47
 | y 1 | y 2 | y 3 | y 4 | y 5 | y 6
region 1 | 1 | 2 | 3 | 45
region 2 | 1 | 6 | 9
region 3 | 2 | 47
Spreadsheet: mary_fischer__25633__31P
Sheet: E5.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031P
COMPANY NAME    Limbach Holdings, Inc.
ANALYSIS OF GOODWILL
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-5
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  |  |  |  |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | AMORTIZATION |  | BALANCE |  |  |  |  |  | OTHER |  |  |  | BALANCE
 |  | PERIOD (Yrs.) |  | DR. (CR.) |  | ADDITIONS |  | AMORTIZATION** |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Goodwill* |  |  |  |  |  |  |  |  | ** |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0344 | Same signs as Hyperion
**MUST TIE TO HYPERION ACCOUNT 1418 | Reverse signs from Hyperion
Spreadsheet: 751118d1633892720-formula-to-calculate-employer-soc-security-tax-up-to-salary-limit-sample-file
Sheet: Sheet1

 | Start Date | End Date | Annual $ | Sept YTD | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | Total 2021 | 2022-01-01 00:00:00 | 2022-02-02 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | Total 2022 | 2023-01-01 00:00:00 | 2023-04-01 00:00:00 | 2023-07-01 00:00:00 | 2023-10-01 00:00:00 | Total 2023 | Q1 2024 | Q2 2024 | Q3 2024 | Q4 2024 | Total 2024
Empl A | 2021-01-01 00:00:00 | 2030-12-31 00:00:00 | 340000 | 28333.33333333333
empl B | 2021-01-01 00:00:00 | 2030-12-31 00:00:00 | 150000 | 12500
Empl C | 2022-01-01 00:00:00 | 2030-12-31 00:00:00 | 125000 | 0
Empl D | 2023-01-01 00:00:00 | 2030-12-31 00:00:00 | 175000 | 0
Empl E | 2023-07-01 00:00:00 | 2030-12-31 00:00:00 | 175000 | 0
Empl F | 2023-07-01 00:00:00 | 2030-12-31 00:00:00 | 250000 | 0
[NAME] used to determine Soc Security tax up to annual salary limit of $142,800
Empl A | 2021-01-01 00:00:00 | 2030-12-31 00:00:00 | 340000
empl B | 2021-01-01 00:00:00 | 2030-12-31 00:00:00 | 150000
Empl C | 2022-01-01 00:00:00 | 2030-12-31 00:00:00 | 125000
Empl D | 2023-01-01 00:00:00 | 2030-12-31 00:00:00 | 175000
Empl E | 2023-07-01 00:00:00 | 2030-12-31 00:00:00 | 175000
Empl F | 2023-07-01 00:00:00 | 2030-12-31 00:00:00 | 250000
 |  | Row 10 | Soc Sec |  | should be
 |  |  | Medicare |  | should be
 | Fica formula per excel forum |  |  |  | [NAME]
 | (this forumula includes ER medicare)
 |  |  |  |  |  |  |  | 2021
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Social Security | 0.0765 | 142800
 |  |  |  |  |  | Medicare | 0.0145 | n/a
Spreadsheet: 141798d1329458502-sumproduct-related-formula-price-products
Sheet: Sheet1

 |  |  |  | BAHARAMPUR
SL. | PRODUCT | PACK | RATE | MAA TARA MEDICAL AGENCY |  | [NAME] |  | NATIONAL MED. AGENCY |  | RAJ MEDICAL HALL
 |  |  |  | SEC | CL | SEC | CL | SEC | CL | SEC | CL
GROUP A
1 | BRETHMOL PLUS | 100ml. | 29 | 303 | 122 | 400 | 902 | 209 | 92 | 186 | 14
2 | COSYDRYL SYP.100ML | 100ml. | 47.77 | 0 | 300 | 3 | 145 | 12 | 41
3 | COSYDRYL TAB. | 10's | 20.7705
4 | LIVERGEN  LIQ. | 100ml. | 32.98 |  |  |  |  | 0 | 45 | 0 | 11
5 | LIVERGEN  LIQ. | 200ml. | 54.73 | 0 | 30 | 0 | 30 |  |  | 0 | 10
6 | LIVERGEN  SYP | 100ml. | 32.96 | 0 | 62 | 0 | 30 | 17 | 11 | 0 | 20
7 | LIVERGEN SYP. | 200ml. | 54.7 | 0 | 30 | 0 | 30 |  |  | 0 | 9
8 | LIVERGEN TAB CONT. | 60's | 60
9 | LIVERGEN TAB | 10'S | 10.52 | 30 | 52 | 0 | 36 | 0 | 60 | 10 | 0
10 | STANMYCIN A 250 | 1 x 6 | 54.7 |  |  | 0 | 26 |  |  | 0 | 2
11 | STANMYCIN A 500 | 1 x 3 | 54.7 | 0 | 6 | 0 | 51 |  |  | 0 | 4
12 | STANPEN CV DRY SYP. | 30ml. | 30 |  |  |  |  | 0 | 103 | 0 | 8
13 | STANPEN CV TAB. | 6's | 87 |  |  |  |  | 0 | 40 | 0 | 20
14 | Stanrab20 | 10's | 33.23 | 0 | 10 |  |  | 0 | 30 | 0 | 10
15 | StanrabDSR | 10's | 45.03 | 0 | 10 |  |  | 0 | 26 | 0 | 20
16 | [NAME] | 15ml. | 21.57 | 0 | 62 |  |  |  |  | 124 | 13
17 | VINKOLA LIQ. | 200ml. | 44.8 |  |  | 0 | 40 | 35 | 22 | 2 | 48
18 | [NAME] | 10's | 19.67 | 0 | 15 |  |  | 40 | 67 | 0 | 6
GROUP A  TOTAL
GROUP B
1 | ALLOUT SUSP | 10ml. | 13.33 | 240 | 294 | 0 | 54 | 294 | 550 | 104 | 1254
2 | ALLOUT TAB | 1's | 10.17 | 1840 | 3046 | 0 | 1820 | 73 | 1641 | 1854 | 217
3 | ELECTRON | 21 gms. | 9.69 | 0 | 1300 | 0 | 1800 | 15 | 91
4 | BRETHMOL PLUS M | 100ML. | 13.12
5 | STANPEN - 800 | 4's | 4.67 | 210 | 1530 | 465 | 4396 | 106 | 387 | 50 | 124
6 | STANPEN - 500 | 6's | 4.67 | 1065 | 5111 | 2250 | 11756 | 460 | 641 | 790 | 351
7 | STANPEN - 200 | 6's | 2.46 | 15 | 435 | 0 | 900 | 45 | 807 | 0 | 136
8 | STANMYCIN SYP. | 60ml. | 17.23 |  |  | 0 | 60
9 | B-ASCORVIT CAP | 10's | 7.56 |  |  |  |  |  |  | 0 | 10
10 | DOLONIP-500 TAB | 20 X 50 | 14.0264 |  |  |  |  | 165 | 2220
11 | DOLONIP SYP | 60 ml | 15.43 |  |  |  |  | 69 | 130
12 | Quino-OZ Susp | 30ml. | 31.16
13 | Quino-OZ Tab | 10's | 47.08
14 | Quino-C | 20 X 10 | 47.604
15 | Quino-CT Tab | 10 X 10 | 54.43000000000001
16 | QUADRAN-500 TAB | 25 X 4 | 2.6028 | 0 | 560 | 0 | 500 | 60 | 255 | 110 | 0
17 | COT.DS | 10 X 10 | 8.697 | 0 | 230
18 | S.Q.BAEL | 60gms. | 28.05
19 | KABZNASH | 100GM. | 31.56
20 | ERYTHROMYCIN-25 | 10'S
21 | STANCEE | 10's | 8.78 | 30 | 20 | 116 | 1 | 25 | 38 | 0 | 5
22 | STANFLAM TAB | 10 X 10 | 5.896
23 | XOMA 500 | 10'S | 63.11900000000001
24 | STANKOFF | 100ml. | 35.07 | 0 | 90 | 0 | 84 |  |  | 0 | 25
25 | STANMYCIN 250 | 10's | 14.562 |  |  | 0 | 40 | 0 | 288 | 10 | 70
26 | STANMYCIN 500 | 10's | 28.036 |  |  | 0 | 10
27 | STANTAC 150 | 10's | 3.9 | 0 | 320
GROUP B  TOTAL
A+B TOTAL
Spreadsheet: 59751d1260312797-excel-2007-how-to-sort-data-validation-menu-while-typing-characters-in-the-cell-for-the-menu-master_requirement_gathering_template_-final-
Sheet: Batch Update

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Case Management (Undercare)
Activity Name | [NAME]
Activity Description / Purpose | Update daily transactions through a Batch Process
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Review transaction document
Determine if action is needed
Sign transaction document
File hard copy
Spreadsheet: 59805d1260362432-getting-averages-from-seperate-worksheets-2010
Sheet: July

 |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  | 2010-07-01 00:00:00 |  | 2010-07-02 00:00:00 |  | 2010-07-03 00:00:00 |  | 2010-07-05 00:00:00 |  | 2010-07-06 00:00:00 |  | 2010-07-07 00:00:00 |  | 2010-07-08 00:00:00 |  | 2010-07-09 00:00:00 |  | 2010-07-10 00:00:00 |  | 2010-07-12 00:00:00 |  | 2010-07-13 00:00:00 |  | 2010-07-14 00:00:00 |  | 2010-07-15 00:00:00 |  | 2010-07-16 00:00:00 |  | 2010-07-17 00:00:00 |  | 2010-07-19 00:00:00 |  | 2010-07-20 00:00:00 |  | 2010-07-21 00:00:00 |  | 2010-07-22 00:00:00 |  | 2010-07-23 00:00:00 |  | 2010-07-24 00:00:00 |  | 2010-07-26 00:00:00 |  | 2010-07-27 00:00:00 |  | 2010-07-28 00:00:00 |  | 2010-07-29 00:00:00 |  | 2010-07-30 00:00:00 |  | 2010-07-31 00:00:00
Consultant Name | Team Leader | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved
Mpho | [NAME]
[NAME] | [NAME]
Glodean ([NAME]) | [NAME]
[NAME] | [NAME]
Lehlohonolo | [NAME]
Matshidiso | [NAME]
Rachel | [NAME]
Naledi G | [NAME]
Innocentia | [NAME]
Glyndine | [NAME]
Total |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Consultant | Total Sales | Monthly Target | [NAME] | Total Approved | QA Monthly Score | QA Rating
Mpho | 0 |  | 0 | 0 |  | -
[NAME] | 0 |  | 0 | 0 |  | -
Glodean ([NAME]) | 0 |  | 0 | 0 |  | -
[NAME] | 0 |  | 0 | 0 |  | -
Lehlohonolo | 0 |  | 0 | 0 |  | -
Matshidiso | 0 |  | 0 | 0 |  | -
Rachel | 0 |  | 0 | 0 |  | -
Naledi G | 0 |  | 0 | 0 |  | -
Innocentia | 0 |  | 0 | 0 |  | -
Glyndine | 0 |  | 0 | 0 |  | -
Total | 0 | 0 | 0 | 0 | #N/A | #N/A
 |  | 0 | 0.8499 | D
 |  | 0.85 | 0.9 | C
 |  | 0.91 | 0.9499 | B
 |  | 0.95 | 1 | A
Spreadsheet: 774671d1648606293-formula-to-return-data-from-furthest-row-right-with-in-column-that-has-specific-text-excel-index-help
Sheet: Sheet1

Supplier A PN | Supplier B PN | Supplier B PN Rev |  | Supplier A PN | Supplier B PN | Supplier B PN Rev |  | Supplier A PN | Supplier B PN | Supplier B PN Rev |  | Supplier A PN | Supplier B PN | Supplier B PN Rev |  | Supplier A PN | Supplier B PN | Supplier B PN Rev
 |  |  |  | 1234 | 4321 | AA |  | 1234 | 4321 | AA |  | 9876 | 6789 | AB
 |  |  |  | 12345 | 43210 | AA |  | 12345 | 4321 | AA |  | 12345 | 6789 | AB
 |  |  |  | 1234 | 4321 | AA |  | 1234 | 4321 | AA |  | 9876 | 6789 | AB
 |  |  |  | 12345 | 43210 | AA |  | 12345 | 4321 | AA |  |  | 6789 | AB
 |  |  |  |  |  |  |  |  |  |  |  | Pull information from furthest column right |  |  |  | Supplier columns will continue on but not always be populated
Spreadsheet: 759496d1639577333-aggregate-function-not-working-with-array-constants-aggregate_question-ans
Sheet: Sheet1

 |  | 1 |  |  |  |  | [NAME] of 3 ranges |  | Sum of 4 ranges
 | 1 | 2
 | 2 | 3
 | 3 | 4
 | #[NAME]! | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
Spreadsheet: 76115d1276688470-combining-charts-bok1
Sheet: Blad1

 | 2009-12-01 00:00:00 |  | January 2010 |  | February 2010
 | Number of cars | Procent of number of cars | Number of cars | Procent of number of cars | Number of cars | Procent of number of cars
USA | 243 |  | 204 |  | 250
CANADA | 286 |  | 286 |  | 300
ITALY | 367 |  | 357 |  | 380
FRANCE | 320 |  | 353 |  | 288
GERMAN | 298 |  | 301 |  | 290
Spain | 265 |  | 379 |  | 365
Spreadsheet: 748735d1632319356-work-out-daily-amount-to-target-31-day-figures
Sheet: 26th

 |  |  |  | TURNOVER |  |  |  |  | REVENUE
 | AREA 3 |  |  | Target | Needed Daily | Actual | [NAME] |  | Target | Needed Daily | Actual | [NAME] |  | [NAME]'s | ATV |  | [NAME] | SALT £ |  | TMC |  | BB+ |  | Errors
 | Asda - Aintree
 | Asda - Huyton
 | Asda - Hunts Cross
 | Asda - Horwich
 | Asda - Leigh
 | Asda - Burnley
 | Asda - Westbrook
 | Asda - Widnes
 | Asda - Bromborough
 | Asda - Accrington
 | Asda - Colne
 | Asda - Clayton Green
 | Asda - Runcorn
 | Asda - Blackburn
 | Asda - Walton
 | Asda - Blackpool
 | Asda - Wigan
 | Asda - Preston
Spreadsheet: 146845d1332375967-need-help-with-minverse-and-indirect-book4
Sheet: Summary

Target
0
20000
 | AA-NFX |  | BAC-BK
 | AA | NFX | BAC | BK
Beta | 1.48 | 1.35 | 1.77 | 1.47
2012-01-03 00:00:00 | TRANSPOSE(MMULT(MINVERSE(CHOOSE({1;2},B$7:C$7,INDEX(,MATCH(),MATCH()):INDEX(,MATCH(),MATCH())),Target))
2012-01-04 00:00:00
2012-01-05 00:00:00
2012-01-06 00:00:00
2012-01-09 00:00:00
2012-01-10 00:00:00
2012-01-11 00:00:00
2012-01-12 00:00:00
2012-01-13 00:00:00
2012-01-17 00:00:00
2012-01-18 00:00:00
2012-01-19 00:00:00
2012-01-20 00:00:00
2012-01-23 00:00:00
2012-01-24 00:00:00
2012-01-25 00:00:00
2012-01-26 00:00:00
2012-01-27 00:00:00
2012-01-30 00:00:00
2012-01-31 00:00:00