tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 163257d1340248534-arrange-complex-excel-data-from-different-worksheet-and-sort-into-one-database-book1
Sheet: Sheet3

Position /Competency Mapping
Proficiency Level Table  : Facility / Manufacturing Department
 |  | Core Competency |  |  |  |  | Managerial Competency |  |  |  |  | Functional Competency
 | Proficiency Level Guide | Quality Awareness | Customer Oriented | Continual Improvement | Safety Awareness | Innovation | Leadership | Problem Solving & Decision Making | Coaching and Developing Others | Accountability | Risk Management | AAAAAAAAAA | BBBBBBBBBBBBBB | CCCCCCCCCC | [NAME] | EEEEEEEEEEEEEEEEE
Competency Level: |  | CC 001 | CC 002 | CC 003 | CC 004 | CC 005 | MC 001 | MC 002 | MC 003 | MC 004 | MC 005 | FC001 | FC002 | FC003 | FC004 | FC005
Facility & Equipment Department
Facility & Equipment Manager | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |  | 4
Maintenance Manager | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 3 |  |  |  | 4
Facility  Manager | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  | 4
Equipment Manager | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  | 4
Maintenance supervisor | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  | 3
Maintenance leader | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 |  | 3 |  | 2
Maintenance technician | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  |  | 2
Spare part controller | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  |  | 2 |  | 2
IT Department
Senior IT Manager | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5
Application Section Manager | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |  |  |  | 5
Infrastructure Section Manger | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |  | 5 |  |  | 5
Senior.PC-LAN Analyst | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  | 4 |  |  | 5
IT Application Analyst & System Admin | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  | 4 |  |  | 4
Program and System Analyst | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  |  |  | 4
IT Application Support & System Support | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  | 3 |  |  | 3
Programmer | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  | 3
Spreadsheet: 726745d1617396744-replace-nested-ifs-with-vlookup-forum-if-test-
Sheet: JAN

 |  |  |  |  |  |  | DEP GMT | ARR GMT | DEP LT | ARR LT
 |  |  | GGG | KKK |  |  | 2021-10-26 10:01:00 | 2021-01-01 12:00:00
 |  |  | DDD | GGG |  |  | 2021-01-01 12:43:00 | 2021-01-01 14:30:00
Spreadsheet: 710013d1608662758-looking-to-extract-various-data-points-from-a-string-of-text-to-make-a-schedule-scheduler
Sheet: DATABASE

Project | Assembly | Component | Process | Date | Assigned | Hours
Project 1234 | Guard Assembly | Guard Bottom | [NAME] | 2020-01-02 00:00:00 | Fred | 2
Project 1234 | Guard Assembly | Guard Top Door 919 | [NAME] | 2020-01-02 00:00:00 | Fred | 2
Project 1234 | Guard Assembly | Guard Top Door 920 | [NAME] | 2020-01-02 00:00:00 | Fred | 2
Project 1234 | Guard Assembly | Reinforcement Channel | [NAME] | 2020-01-02 00:00:00 | Jake | 2
Project 1234 | Guard Assembly | Guard Bottom | Assm | 2020-01-02 00:00:00 | [NAME] | 1
Project 1234 | Guard Assembly | Guard Bottom | Assm | 2020-01-02 00:00:00 | [NAME] | 1
Project 1234 | Guard Assembly | Guard Top Door 919 | Assm | 2020-01-02 00:00:00 | [NAME] | 1
Project 1234 | Guard Assembly | Guard Top Door 919 | Assm | 2020-01-02 00:00:00 | [NAME] | 1
Project 1234 | Guard Assembly | Guard Top Door 920 | Assm | 2020-01-02 00:00:00 | Jake | 1
Project 1234 | Guard Assembly | Guard Top Door 920 | Assm | 2020-01-02 00:00:00 | [NAME] | 1
Project 1234 | Guard Assembly | Reinforcement Channel | Assm | 2020-01-02 00:00:00 | [NAME] | 1
Project 1234 | Guard Assembly | Reinforcement Channel | Assm | 2020-01-02 00:00:00 | [NAME] | 1
Project 1234 | Guard Assembly | Guard Bottom | Weld | 2020-01-02 00:00:00 | [NAME] | 1
Project 1234 | Guard Assembly | Guard Top Door 919 | Weld | 2020-01-02 00:00:00 | [NAME] | 1
Project 1234 | Guard Assembly | Guard Top Door 920 | Weld | 2020-01-02 00:00:00 | [NAME] | 1
Project 1234 | Guard Assembly | Reinforcement Channel | Weld | 2020-01-02 00:00:00 | [NAME] | 1
Project 1234 | Guard Assembly | Guard Bottom | Fit | 2020-01-02 00:00:00 | Jake | 2
Project 1234 | Guard Assembly | Guard Bottom | Fit | 2020-01-02 00:00:00 | [NAME] | 2
Project 1234 | Guard Assembly | Guard Top Door 919 | Fit | 2020-01-02 00:00:00 | Jake | 2
Project 1234 | Guard Assembly | Guard Top Door 919 | Fit | 2020-01-02 00:00:00 | [NAME] | 2
Project 1234 | Guard Assembly | Guard Top Door 920 | Fit | 2020-01-02 00:00:00 | Jake | 2
Project 1234 | Guard Assembly | Guard Top Door 920 | Fit | 2020-01-02 00:00:00 | [NAME] | 2
Project 1234 | Guard Assembly | Reinforcement Channel | Fit | 2020-01-02 00:00:00 | Jake | 2
Project 1234 | Guard Assembly | Reinforcement Channel | Fit | 2020-01-02 00:00:00 | [NAME] | 2
Project 1234 | Drive Mechanism |  | [NAME] | 2020-01-03 00:00:00 | Fred | 3
Project 1234 | Drive Mechanism |  | [NAME] | 2020-01-03 00:00:00 | Fred | 3
Project 1234 | Drive Mechanism |  | Assm | 2020-01-03 00:00:00 | Fred | 3
Project 1234 | Drive Mechanism |  | Assm | 2020-01-03 00:00:00 | Fred | 3
Project 1234 | Drive Mechanism |  | Fit | 2020-01-03 00:00:00 | [NAME] | 2
Project 1234 | Drive Mechanism |  | Fit | 2020-01-03 00:00:00 | Jake | 2
Project 1234 |  |  | Test | 2020-01-03 00:00:00 | [NAME] | 4
Project 1234 |  |  | Test | 2020-01-03 00:00:00 | Fred | 4
Project 1234 |  |  | Pack | 2020-01-03 00:00:00 | [NAME] | 2
Project 1234 |  |  | Pack | 2020-01-03 00:00:00 | [NAME] | 2
Project 1234 |  |  | Pack | 2020-01-03 00:00:00 | [NAME] | 2
Spreadsheet: 71262d1271949753-if-then-if-then-example
Sheet: Sheet1

 | Inspector |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Certification #: |  |  |  |  | L-17-9010
 |  |  |  |  | INSPECTORS |  |  |  |  |  |  |  |  |  |  |  |  |  | Certification #
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 21-10282
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | L-17-9010
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | K-450-0006
 | Inspector / Tester |  |  |  |  |  |  |  | Signed |  |  |  |  |  |  |  |  |  | AWWA Certification #
 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21-10282
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L-17-9010
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K-450-0006
Spreadsheet: 126719d1319832955-excel-2007-conditional-format-cells-today-conditional-format-v-today-
Sheet: Sheet1

I NEED A CONDITIONAL FORMAT FOR CELLS LESS THAN TODAY???
RESULT NEEDED IS SHOWN HIGHLIGHTED (BUT DONE MANUALLY)
 | Today
2011-10-15 00:00:00
IF POSSIBLE TO ADD TODAY AND GREATER EVEN BETTER.
Spreadsheet: 826442d1682011489-a-conditional-selection-of-a-value-from-an-adjacent-cell-searcher
Sheet: GLW List

Grade | Color | Index | Customer ID | Ordering Unit | Gauge | [NAME] | Length
3030 | Blue |  |  | IN | 0.001 | 48 | 96
3030 | Blue |  |  | MM | 0.025 | 1219 | 2439
3036 | Blue |  |  | IN | 0.003 | 48.03 | 96.06
3036 | Blue |  |  | MM | 0.075 | 1220 | 2440
3444 | Yellow |  |  | IN | 0.118 | 82.677 | 472.4
3444 | Green |  |  | MM | 3 | 2100 | 12000
3444 | Blue |  |  | IN | 0.093 | 49.21 | 170
3444 | Yellow |  |  | MM | 2.36 | 1250 | 4300
Spreadsheet: 847729d1698599056-summarize-data-on-multiple-sheets-to-one-sheet-sample
Sheet: Fruit Delivery

Date | Name | Qty | Price | Amount |  |  |  |  |  | Name | QTY | PRICE
2023-10-01 00:00:00
2023-10-02 00:00:00
2023-10-03 00:00:00
2023-10-04 00:00:00
2023-10-05 00:00:00 | Apple | 100 | 5
2023-10-06 00:00:00
2023-10-07 00:00:00
2023-10-08 00:00:00 | [NAME] | 500 | 2
2023-10-09 00:00:00
2023-10-10 00:00:00 | Pear | 50 | 3
2023-10-11 00:00:00
2023-10-12 00:00:00
2023-10-13 00:00:00
2023-10-14 00:00:00
2023-10-15 00:00:00
2023-10-16 00:00:00
2023-10-17 00:00:00 | Grapes | 200 | 2
2023-10-18 00:00:00
2023-10-19 00:00:00
2023-10-20 00:00:00
2023-10-21 00:00:00 | Watermelon | 60 | 4
2023-10-22 00:00:00
2023-10-23 00:00:00
2023-10-24 00:00:00
2023-10-25 00:00:00
2023-10-26 00:00:00
2023-10-27 00:00:00
2023-10-28 00:00:00
2023-10-29 00:00:00
2023-10-30 00:00:00
2023-10-31 00:00:00
Spreadsheet: 879619d1727195576-if-formula-for-copy-pasting-values-test-file-attached-if-copy-test-jojoman86-
Sheet: Sheet2

Expenses | Amount |  | Expenses | Amount
Apples |  |  | Apples | 100
Limes | 40 |  | Oranges | 20
Lemon | 20 |  | Bananas | 30
Oranges |  |  | Grapefruit | 60
Pineapples | 50 |  | Limes | 40
Kiwis | 50 |  | Lemon | 20
Bananas |  |  | Pineapples | 50
 |  |  | Kiwis | 50
Spreadsheet: 673351d1587322808-sum-if-issues-with-multiple-columns-of-criteria-sample-project-mandzrose-
Sheet: Activities

Location | Activity | Priority | Number of Days | Start Date | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Day 11 | Day 12 | Day 13 | Day 14 | Day 15 | Day 16 | Hours/Day | Number of Employees Needed/Shift | NAME | NAME2 | NAME3 | NAME4 | NAME5 | NAME6 | NAME7 | NAME8 | NAME9 | NAME10
Flow | Mail Delivery Program |  | 2 | 2020-04-20 00:00:00 | 2020-04-21 00:00:00 | False | False | False | False | False | False | False | False | False | False | False | False | False | False | 7 | 2 | A-Justin Smith | B-DJ P
Texas | Organizing |  | 4 | 2020-04-17 00:00:00 | 2020-04-12 00:00:00 | 2020-04-13 00:00:00 | 2020-04-14 00:00:00 | False | False | False | False | False | False | False | False | False | False | False | False | 2 | 3 | A-Tim B | A-Justin Smith | A-Doug D
Texas | Cleaning |  | 5 | 2020-04-15 00:00:00 | 2020-04-16 00:00:00 | 2020-04-17 00:00:00 | 2020-04-18 00:00:00 | 2020-04-19 00:00:00 | False | False | False | False | False | False | False | False | False | False | False | 5 | 2 | A-Tim B | A-Justin Smith
CanAm | Enhanced Technology |  | 8 | 2020-04-16 00:00:00 | 2020-04-22 00:00:00 | 2020-04-23 00:00:00 | 2020-04-24 00:00:00 | 2020-04-25 00:00:00 | 2020-04-26 00:00:00 | 2020-04-27 00:00:00 | 2020-04-28 00:00:00 | False | False | False | False | False | False | False | False | 6 | 1 | A-Doug D
CanAm | Training |  | 13 | 2020-04-15 00:00:00 | 2020-04-16 00:00:00 | 2020-04-17 00:00:00 | 2020-04-18 00:00:00 | 2020-04-19 00:00:00 | 2020-04-20 00:00:00 | 2020-04-21 00:00:00 | 2020-04-22 00:00:00 | 2020-04-23 00:00:00 | 2020-04-24 00:00:00 | 2020-04-25 00:00:00 | 2020-04-26 00:00:00 | 2020-04-27 00:00:00 | False | False | False | 9 | 1 | A-Tim B
CanAm | DT Codes |  | 2 | 2020-04-16 00:00:00 | 2020-04-17 00:00:00 | False | False | False | False | False | False | False | False | False | False | False | False | False | False | 4 | 2 | B-DJ P | A-Justin Smith
Date | Location | Activity | Names | Hours/Day
2020-04-12 00:00:00 | Texas | Organizing | A-Tim B | 2 |  | Sum of Hours/Day | Date
2020-04-12 00:00:00 | Texas | Organizing | A-Justin Smith | 2 |  | Names | 2020-04-12 00:00:00 | 2020-04-13 00:00:00 | 2020-04-27 00:00:00
2020-04-12 00:00:00 | Texas | Organizing | A-Doug D | 2 |  | A-Doug D | 2 | 2
2020-04-13 00:00:00 | Texas | Organizing | A-Tim B | 2 |  | A-Justin Smith | 2 | 2
2020-04-13 00:00:00 | Texas | Organizing | A-Justin Smith | 2 |  | A-Tim B | 2 | 2 | 9
2020-04-13 00:00:00 | Texas | Organizing | A-Doug D | 2
…
2020-04-27 00:00:00 | CanAm | Training | A-Tim B | 9
Spreadsheet: 63684d1264572103-number-of-days-sales-inventory-days_stock
Sheet: Sheet1

Sales the last 30 days | Stock On Hand | Stock On Order | No. Days Stock
4 | 0 | 1
1 | 0 | 1
1 | 0 | 1
8 | 0 | 5
26 | 3 | 5
115 | 6 | 30
21 | 4 | 10
45 | 4 | 15
32 | 3 | 20
21 | 11 | 0
44 | 24 | 0
30 | 16 | 0
26 | 14 | 0
15 | 16 | 0
Spreadsheet: 754445d1636201514-formula-to-extract-data-from-worksheets-test-cosmica-aligw
Sheet: Data Collation

Year | Name | Subject 1 | Subject 2 | Subject 3 | Subject 4
1 | Name 1
2 | Name 2
3 | Name 3
Spreadsheet: 223243d1364132724-remove-duplicates-not-working-20130324-excel002
Sheet: Sheet1

Key 1 | Date | State | County | Con. | [NAME]
 | 2013-03-25 00:00:00 | RI | Providence | Holewi
 | 2013-03-25 00:00:00 | RI | Providence | Holewi
 | 2013-03-25 00:00:00 | RI | Providence | Holewi
 | 2013-03-25 00:00:00 | RI | Providence | Holewi
 | 2013-03-25 00:00:00 | RI | Providence | Holewi
 | 2013-03-25 00:00:00 | CA | Los Angeles | Ke
 | 2013-04-01 00:00:00 | IL | [NAME] | [NAME]
 | 2013-04-01 00:00:00 | IL | [NAME] | [NAME]
 | 2013-04-01 00:00:00 | IL | [NAME] | [NAME]
 | 2013-04-01 00:00:00 | IL | [NAME] | Lew
 | 2013-04-01 00:00:00 | IL | [NAME] | Lew
 | 2013-04-08 00:00:00 | PA | Philadelphia | Da
 | 2013-04-08 00:00:00 | IL | McLean | Feezor,
 | 2013-04-08 00:00:00 | PA | Philadelphia | Gutsch
 | 2013-04-08 00:00:00 | IL | [NAME] | Schoute
 | 2013-04-15 00:00:00 | NJ | Middlesex | An
 | 2013-04-15 00:00:00 | NJ | Middlesex | An
 | 2013-04-15 00:00:00 | NJ | Middlesex | Kni
 | 2013-04-15 00:00:00 | NJ | Middlesex | [NAME]
 | 2013-04-15 00:00:00 | NY | Erie | Mart
 | 2013-04-15 00:00:00 | MO | St. Louis | Stob
 | 2013-04-15 00:00:00 | MO | St. Louis | Stob
 | 2013-04-15 00:00:00 | NJ | Middlesex | Stoke
 | 2013-04-18 00:00:00 | IL | [NAME] | Novak
 | 2013-04-22 00:00:00 | NY | Schenectady | Tango
 | 2013-04-29 00:00:00 | CA | Los Angeles | Catill
 | 2013-04-29 00:00:00 | NJ | Middlesex | Davi
 | 2013-04-29 00:00:00 | NJ | Middlesex | Davi
 | 2013-04-29 00:00:00 | NJ | Middlesex | Davi
 | 2013-04-29 00:00:00 | MI | Monroe | Lepe
 | 2013-04-29 00:00:00 | MO | St. Louis | W
 | 2013-04-29 00:00:00 | MO | St. Louis | W
 | 2013-04-29 00:00:00 | MO | St. Louis | W
 | 2013-04-29 00:00:00 | MO | St. Louis | W
 | 2013-04-29 00:00:00 | MI | Monroe | Withe
 | 2013-04-30 00:00:00 | PA | Cambria | Misk
 | 2013-04-30 00:00:00 | PA | Cambria | Murph
 | 2013-04-30 00:00:00 | PA | Cambria | Semins
 | 2013-04-30 00:00:00 | PA | Cambria | Warne
 | 2013-05-01 00:00:00 | PA | Allegheny | Rzep
 | 2013-05-01 00:00:00 | PA | Allegheny | Rzep
 | 2013-05-01 00:00:00 | PA | Allegheny | Sc
 | 2013-05-05 00:00:00 | DE | New Castle | McRa
 | 2013-05-05 00:00:00 | DE | New Castle | McRa
 | 2013-05-06 00:00:00 | RI | Providence | Ca
 | 2013-05-06 00:00:00 | RI | Providence | Ca
 | 2013-05-06 00:00:00 | PA | Philadelphia | Yarna
 | 2013-05-06 00:00:00 | PA | Philadelphia | Yarna
 | 2013-05-06 00:00:00 | PA | Philadelphia | G
 | 2013-05-06 00:00:00 | PA | Philadelphia | G
 | 2013-05-06 00:00:00 | LA | Orleans Parish | Hebe
 | 2013-05-06 00:00:00 | PA | Philadelphia | Sorr
 | 2013-05-06 00:00:00 | IL | [NAME] | Tool
 | 2013-05-06 00:00:00 | IL | [NAME] | Tool
 | 2013-05-06 00:00:00 | IL | [NAME] | Wake
 | 2013-05-06 00:00:00 | IL | [NAME] | Wake
 | 2013-05-06 00:00:00 | PA | Philadelphia | Was
 | 2013-05-07 00:00:00 | CT | Bridgeport | Hamm
 | 2013-05-13 00:00:00 | RI | Providence | [NAME]
 | 2013-05-13 00:00:00 | RI | Providence | [NAME]
Spreadsheet: 814562d1674487645-waterfall-simplification-sample-43-ans
Sheet: New infra planner (2)

New |  |  | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
Month | Plan | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | YTD
APR | 30
MAY | 30
JUN | 30
JUL | 30
AUG | 30
SEP | 30
OCT | 30
NOV | 30
DEC | 30
JAN | 30
FEB | 30
MAR | 30
TOTAL
Spreadsheet: 50a7d6da-0994-45ef-83a9-f5a0645520f7
Sheet: Risks

Project Name |  |  |  |  |  |  | Sponsor
Project Manager |  |  |  |  |  |  | Date Updated
ID | Description | Date Opened | Date Opened | Status | Category | Probability | Impact | Risk  Score | Risk Response | Detailed Risk Response | Risk Trigger(s) | Timing | Risk Owner | Risk Owner | Close Date |  | Prob Score | Impact Score
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Probability | Impact
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High | Medium | Low
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low
6
7
8
9
10
11
12
13
14
15
 |  |  |  |  | List….
 |  |  |  |  | Architecture
 |  |  |  |  | Business
 |  |  |  |  | [NAME]
 |  |  |  |  | Cost
 |  |  |  |  | Cust. Satisfaction
 |  |  |  |  | End User
 |  |  |  |  | Enterprise
 |  |  |  |  | Political
 |  |  |  |  | Quality
 |  |  |  |  | Regulatory
 |  |  |  |  | Requirements
 |  |  |  |  | Res. Avail
 |  |  |  |  | Schedule
 |  |  |  |  | Staffing
 |  |  |  |  | Technical
 |  |  |  |  | Vendor
Spreadsheet: 757183d1638094295-number-of-different-dates-based-on-multiple-criteria-dates
Sheet: Sheet1

Name | Date
Adam | 2021-01-01 00:00:00
Adam | 2021-01-10 00:00:00
[NAME] | 2021-01-10 00:00:00
[NAME] | 2021-01-15 00:00:00
[NAME] | 2021-01-15 00:00:00
[NAME] | 2021-01-15 00:00:00
[NAME] | 2021-01-25 00:00:00
[NAME] | 2021-01-25 00:00:00
[NAME] | 2021-01-25 00:00:00
[NAME] | 2021-01-28 00:00:00
[NAME] | 2021-01-28 00:00:00
[NAME] | 2021-01-29 00:00:00
[NAME] | 2021-01-29 00:00:00
Adam | 2021-01-31 00:00:00
Adam | 2021-01-31 00:00:00
Spreadsheet: 110593d1307206936-consolidate-multiple-data-tables-appendsourcetomasterpt
Sheet: Source1

Date | Amount
2011-08-08 00:00:00 | 101
2011-06-29 00:00:00 | 110
2011-07-20 00:00:00 | 80
2011-08-04 00:00:00 | 63
2011-07-15 00:00:00 | 119
2011-08-09 00:00:00 | 70
2011-08-24 00:00:00 | 169
2011-07-17 00:00:00 | 54
2011-06-13 00:00:00 | 33
2011-06-26 00:00:00 | 16
2011-07-25 00:00:00 | 190
2011-07-03 00:00:00 | 33
2011-08-16 00:00:00 | 55
2011-08-23 00:00:00 | 109
2011-09-03 00:00:00 | 51
2011-09-01 00:00:00 | 133
2011-07-05 00:00:00 | 144
2011-08-13 00:00:00 | 89
2011-07-25 00:00:00 | 90
2011-08-22 00:00:00 | 65
2011-08-31 00:00:00 | 121
2011-07-15 00:00:00 | 81
2011-09-10 00:00:00 | 15
2011-08-02 00:00:00 | 161
2011-06-18 00:00:00 | 44
2011-09-08 00:00:00 | 40
2011-07-05 00:00:00 | 84
2011-08-15 00:00:00 | 135
2011-07-17 00:00:00 | 17
2011-08-10 00:00:00 | 200
2011-06-30 00:00:00 | 31
2011-08-05 00:00:00 | 136
2011-07-06 00:00:00 | 5
2011-07-25 00:00:00 | 196
2011-07-02 00:00:00 | 108
2011-08-17 00:00:00 | 55
2011-08-18 00:00:00 | 76
2011-08-18 00:00:00 | 156
2011-08-09 00:00:00 | 18
2011-07-10 00:00:00 | 63
2011-06-13 00:00:00 | 90
2011-09-11 00:00:00 | 82
2011-08-03 00:00:00 | 59
2011-06-25 00:00:00 | 60
2011-07-01 00:00:00 | 45
2011-08-13 00:00:00 | 68
2011-07-03 00:00:00 | 146
2011-06-19 00:00:00 | 5
2011-07-23 00:00:00 | 80
2011-06-10 00:00:00 | 9
2011-08-17 00:00:00 | 34
2011-07-26 00:00:00 | 80
2011-09-08 00:00:00 | 34
2011-09-06 00:00:00 | 124
2011-08-11 00:00:00 | 176
2011-06-20 00:00:00 | 171
2011-06-09 00:00:00 | 105
2011-08-12 00:00:00 | 158
2011-06-28 00:00:00 | 178
2011-08-08 00:00:00 | 99
2011-08-23 00:00:00 | 160
2011-07-18 00:00:00 | 107
2011-07-18 00:00:00 | 77
2011-07-30 00:00:00 | 74
2011-06-22 00:00:00 | 125
2011-06-25 00:00:00 | 96
2011-07-03 00:00:00 | 152
2011-06-21 00:00:00 | 49
2011-08-01 00:00:00 | 162
2011-08-13 00:00:00 | 129
2011-07-21 00:00:00 | 94
2011-09-02 00:00:00 | 72
2011-06-21 00:00:00 | 66
2011-08-09 00:00:00 | 144
2011-07-21 00:00:00 | 39
2011-08-05 00:00:00 | 26
2011-07-13 00:00:00 | 112
2011-08-10 00:00:00 | 25
2011-09-01 00:00:00 | 168
2011-09-03 00:00:00 | 8
2011-07-04 00:00:00 | 75
2011-07-10 00:00:00 | 146
Spreadsheet: 154961d1336630157-please-need-help-buy-and-sell
Sheet: Arrange

BUY | Stock Name | column G | column H |  | sell | Stock Name | column J | column H
1 | ADANIPOWER | 55.2 | 55.5 |  | 1 | ANANTRAJ | 53.3 | 53
2 | APIL | 361.8 | 365.2 |  | 2
3 | BAJAJHLDNG | 802.6 | 805.1 |  | 3
4 | BEML | 524.7 | 528.2 |  | 4
5 |  |  |  |  | 5
6 |  |  |  |  | 6
7 |  |  |  |  | 7
8 |  |  |  |  | 8
9 |  |  |  |  | 9
10 |  |  |  |  | 10
11 |  |  |  |  | 11
12 |  |  |  |  | 12
13 |  |  |  |  | 13
14 |  |  |  |  | 14
Spreadsheet: 716430d1612206083-personal-budget-tracker-help-needed-sumif-budget-tracker-2021-sumproduct
Sheet: PERSONAL BUDGET

Create a Simple Personal Budget in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started.
Title of this worksheet is in cell at right. Enter year in cell Q2. Next instruction is in cell A4. | PERSONAL BUDGET
[NAME] are in cells C4 through P4. |  | REVENUE | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YEAR
Enter details in Income table starting in cell C5. Next instruction is in cell A11. |  | INCOME | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline
 |  | Wages | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500
 |  | Interest/Dividends | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Miscellaneous | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total
 |  | Total Expenses
 |  | [NAME]
[NAME] are in cells C11 through P11. |  | EXPENSES | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YEAR
Enter Home expenses in table starting in cell C12. Next instruction is in cell A20. |  | HOME | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline
 |  | Electric
 |  | Internet
 |  | Cable
 |  | Water
 |  | Planet Fitness
 |  | Car Payment
 |  | Car Insurance
 |  | Groceries
 |  | Optavia
 |  | Dining out
Enter Daily expenses in table starting in cell C20. Next instruction is in cell A29. |  | Total
 |  | DEBT | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline
 |  | WGU - Tuition
 |  | 401K Loan
 |  | Student Loans
Enter Transportation expenses in table starting in cell C29. Next instruction is in cell A38. |  | Total
 |  | WEDDING | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline
 |  | Flights
 |  | VRBO
 |  | Cake
 |  | Flowers
 |  | Suit
 |  | Dress
Enter Entertainment expenses in table starting in cell C38. Next instruction is in cell A45. |  | Reception Dinner
 |  | Photographer
 |  | Transporation to airport
 |  | Car rental
 |  | Officiant
 |  | Hair/Makeup
 |  | Nails
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total
Enter Health expenses in table starting in cell C45. Next instruction is in cell A55.
 |  | TOTALS | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YEAR | SPARKLINE
 |  | Total expenses
 |  | Cash short/extra