tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 843913d1695736973-help-with-populating-data-in-correct-debit-and-credit-fields-jounral-upload-sage-intacct-jenish91-
Sheet: Sheet2

DONOTIMPORT | JOURNAL | DATE | REVERSEDATE | [NAME] | REFERENCE_NO | LINE_NO | ACCT_NO | LOCATION_ID | DEPT_ID | DOCUMENT | MEMO | DEBIT | CREDIT | SOURCEENTITY | ALLOCATION_ID | BILLABLE | TAXIMPLICATIONS | TAXSOLUTIONID | TAX_VENDORID | TAX_CUSTOMERID | TAX_CONTACTID | TAX_DETAILID | TAX_AMOUNT | SAGE50_REFERENCE | SAGE50_JOURNAL | GLENTRY_VENDORID | GLENTRY_EMPLOYEEID | GLENTRY_CLASSID | TAX_LINE_NO
 | GJ | 2023-08-31 00:00:00 |  | Aug'23 | 1 | 1 | 400000 | ACC |  |  |  |  |  |  |  |  |  | United Kingdom - VAT |  |  |  |  |  |  |  |  |  |  | 1
 | GJ | 2023-08-31 00:00:00 |  | Aug'23 | 1 | 2 | 202090 | ACC |  |  |  |  |  |  |  |  |  | United Kingdom - VAT |  |  |  |  |  |  |  |  |  |  | 1
 | GJ | 2023-08-31 00:00:00 |  | Aug'23 | 1 | 1 | 400000 | AMH |  |  |  |  |  |  |  |  |  | United Kingdom - VAT
 | GJ | 2023-08-31 00:00:00 |  | Aug'23 | 1 | 2 | 202090 | AMH |  |  |  |  |  |  |  |  |  | United Kingdom - VAT
 | GJ | 2023-08-31 00:00:00 |  | Aug'23 | 1 | 1 | 400000 | BCH |  |  |  |  |  |  |  |  |  | United Kingdom - VAT
 | GJ | 2023-08-31 00:00:00 |  | Aug'23 | 1 | 2 | 202090 | BCH |  |  |  |  |  |  |  |  |  | United Kingdom - VAT
 |  |  |  | example RESULT |  |  | 400000 | ACC |  |  |  |  | 137476.44
 |  |  |  | example RESULT |  |  | 202090 | ACC |  |  |  | 137476.44
 |  |  |  | example RESULT |  |  | 400000 | BCH |  |  |  | 65697.14
 |  |  |  | example RESULT |  |  | 202090 | BCH |  |  |  |  | 65697.14
 |  |  | NOTES: | The numbers can be pulled from either sheet 'data' or 'Pivot'
 |  |  |  | 400000 | This should represent the total of Location ID from either of the sheets in Debit column M if the sum is in positive & in Credit column N if the sum is in negative.
 |  |  |  | 202090 | Row 3, 5, 7 should replicate the same number in the field above from 400000. If 400000 has a value in credit, the value below should appear in debit in row 3 column M and vice versa.
 |  |  |  | I have shown what the results should be manually in row 9 to 13.
Spreadsheet: 761272d1640790916-training-past-due-sample-tempering-training-tracker
Sheet: Positions

Position | Training Time (Days)
Artisan-Artisan Assisstant | 60
Artisan-DipTech | 30
Artisan-Master Artisan | 1825
Artisan-Sandblast | 30
Cell Lead | 10
[NAME] | 10
[NAME] | 10
CNC-Juniors | 10 |  | 1 week on T1 and 1 week on T2, to help learn carry and 1/2 thick glass
CNC-Schiatti | 10
CNC-Speed 13 | 10
CNC-Waterjet | 10 |  | Learning one of the tam ovens, doesn't mean you'll need to go through another 30 training on any other oven. A week refresher should be more than enough
Cutting-Breakout Asst. | 10
Cutting-Operator | 20
[NAME] | 20
Oven-Big Tam | 20
[NAME] EXP | 5 |  |  |  |  |  | 30 Day Complete
[NAME] | 20 |  |  |  |  |  | 60 Day Complete
[NAME] EXP | 5 |  |  |  |  |  | Complete
Oven-Small Tam | 20 |  |  |  |  |  | Terminated
Oven-Small Tam EXP | 5
Polish-Auto | 10
Polish-Manual | 10
Polish-Miters | 10
Shipping/Receiving | 10
Sort-Sorter | 5
Sort-Stock Doors | 10
Washer | 5
Wrap-Buff | 10
Wrap-Pusher | 5
Wrap-Trim | 5
Wrap-Wrapper | 5
Spreadsheet: 744389d1629213818-extract-fields-based-on-current-date-and-month-sample-workbook-with-expected-output-4-
Sheet: Details

 | Preparer | Backup | [NAME] | Activity Name | Frequency | Rotation Cycle Time Frame | Due Date
 | Smith | Arav | Keshav | AFBCDD | As Needed | 2021-07-01 00:00:00 | As Needed
 | Aiden | Jameson | [NAME] | KLMKJLJ | Monthly - Day 2 | 2021-07-01 00:00:00 | 2021-08-02 00:00:00
 | Cole | Dion | Shane | SDFADF | Monthly - Day 3 | 2021-07-01 00:00:00 | 2021-08-03 00:00:00
 | Shaw | Irwin | [NAME] | EPROIIR | Monthly - Day 20 | 2021-07-01 00:00:00 | 2021-08-20 00:00:00
 | Harold | [NAME] | [NAME] | ZMCNXX | Every Tuesday | 2021-07-01 00:00:00 | Every Tuesday
 | Alvin | Hayden | Hugo | ADFJDFV | Daily | 2021-07-01 00:00:00 | Daily
 | Lowell | Xavier | Misha | WOUREU | As Received | 2021-07-01 00:00:00 | As Received
 | Nicol | [NAME] | Sultan | GHKFDD | Monthly - Day 5 | 2021-07-01 00:00:00 | 2021-08-05 00:00:00
 | Aiden | Jameson | [NAME] | AFBCDD | As Needed | 2021-08-01 00:00:00 | As Needed
 | Shaw | Irwin | [NAME] | KLMKJLJ | Monthly - Day 2 | 2021-08-01 00:00:00 | 2021-09-02 00:00:00
 | Lowell | Xavier | Misha | SDFADF | Monthly - Day 3 | 2021-08-01 00:00:00 | 2021-09-03 00:00:00
 | Harold | [NAME] | [NAME] | EPROIIR | Monthly - Day 20 | 2021-08-01 00:00:00 | 2021-09-20 00:00:00
 | Alvin | Hayden | Hugo | ZMCNXX | Every Tuesday | 2021-08-01 00:00:00 | Every Tuesday
 | Cole | Dion | Shane | ADFJDFV | Daily | 2021-08-01 00:00:00 | Daily
 | Smith | Arav | Keshav | WOUREU | As Received | 2021-08-01 00:00:00 | As Received
 | Nicol | [NAME] | Sultan | GHKFDD | Monthly - Day 5 | 2021-08-01 00:00:00 | 2021-09-05 00:00:00
 | Lowell | Xavier | Misha | AFBCDD | As Needed | 2021-09-01 00:00:00 | As Needed
 | Shaw | Irwin | [NAME] | KLMKJLJ | Monthly - Day 2 | 2021-09-01 00:00:00 | 2021-10-02 00:00:00
 | Alvin | Hayden | Hugo | SDFADF | Monthly - Day 3 | 2021-09-01 00:00:00 | 2021-10-03 00:00:00
 | Cole | Dion | Shane | EPROIIR | Monthly - Day 20 | 2021-09-01 00:00:00 | 2021-10-20 00:00:00
 | Smith | Arav | Keshav | ZMCNXX | Every Tuesday | 2021-09-01 00:00:00 | Every Tuesday
 | Harold | [NAME] | [NAME] | ADFJDFV | Daily | 2021-09-01 00:00:00 | Daily
 | Aiden | Jameson | [NAME] | WOUREU | As Received | 2021-09-01 00:00:00 | As Received
 | Nicol | [NAME] | Sultan | GHKFDD | Monthly - Day 5 | 2021-09-01 00:00:00 | 2021-10-05 00:00:00
Spreadsheet: 117690d1312967476-parentheses-and-stars-not-recognized-in-excel-test-test
Sheet: Di

# of Stars | HOTEL (****) | 4
# of Stars | HOTEL(**) | 2
# of Stars | APARTHOTEL (***) | 3
# of Stars | HOTEL (***) | 3
# of Stars | HOTEL (*) | 1
# of Stars | APARTHOTEL (****) | 4
# of Stars | HOTEL (*****) | 5
# of Stars | HOTEL (***** GL) | 5
# of Stars | APARTAMENTO | 1
# of Stars | ESTABLECIMIENTO DE TURISMO RURAL
# of Stars | APARTAMENTO (??)
# of Stars | HOSTAL (*) | 1
# of Stars | HOSTAL (**) | 2
# of Stars | HOSTAL-RESIDENCIA
# of Stars | HOTEL
# of Stars | APARTAMENTO (???)
# of Stars | APARTAMENTO (?)
# of Stars | APARTHOTEL (**) | 2
# of Stars | COMPLEJO DE VACACIONES
# of Stars | APARTAMENTO (????) | 4
# of Stars | APARTHOTEL (*) | 1
# of Stars | APARTHOTEL
# of Stars | APARTHOTEL (*****) | 5
Spreadsheet: 525150d1498568433-lookup-a-referenced-value-for-the-last-available-non-zero-non-null-date-excel-query-1-ans
Sheet: Sheet1

 | Item | Date | Item 1 | Item 2 | Item 3 |  | Results | Item 1 2015 | Item 1 2016 | Item 2 2015 | Item 2 2016 | Item 3 2015 | Item 3 2016
 | Reference 1 | 2015-03-31 00:00:00 | 1250 | 4350 | 1270 |  | Reference 1
 | Reference 1 | 2015-06-30 00:00:00 | 1460 | 4400 |  |  | Reference 2
 | Reference 1 | 2015-09-30 00:00:00 | 1350 | 4260 | 1120
 | Reference 1 | 2015-12-31 00:00:00 | 0 | 4805 | 4805
 | Reference 1 | 2016-03-31 00:00:00 | 4140 | 4550 | 1225 |  | Reference 1 | 1350 | 4350 | 4805 | 3820 | 4805 | 1635
 | Reference 1 | 2016-06-06 00:00:00 | 3650 | 4560 | 1300 |  | Reference 2 | 6025 | 5786 | 4182 | 3267 | 7000 | 5650
 | Reference 1 | 2016-09-30 00:00:00 | 3625.2 | 3820 | 1240
 | Reference 1 | 2016-12-31 00:00:00 | 4350 |  | 1635
 | Reference 2 | 2015-03-31 00:00:00 | 6472.55 | 3952.55 | 4490
 | Reference 2 | 2015-06-30 00:00:00 | 5686.05 | 4185.89 | 7395
 | Reference 2 | 2015-09-30 00:00:00 | 5668.45 | 4182.04 | 7180
 | Reference 2 | 2015-12-31 00:00:00 | 6025.38 | 0 | 7000
 | Reference 2 | 2016-03-31 00:00:00 | 5837.84 | 4194.68 | 6315
 | Reference 2 | 2016-06-06 00:00:00 | 5576.18 | 4309.63 | 6030
 | Reference 2 | 2016-09-30 00:00:00 | 5785.96 | 3281.1 | 5620
 | Reference 2 | 2016-12-31 00:00:00 |  | 3267.37 | 5650
Spreadsheet: 50354d1249744990-how-do-i-skip-a-cell-and-move-on-to-the-next-one-indexmatchkey-simple
Sheet: Items

 | Time | Start Time | End Time |  | Items | 5
1 | Office | 500 | 600
2 | Field | 600 | 700
3 | Office | 800 | 900
4 | Lunch | 900 | 1000
5 | Field | 1000 | 1100
6
7
8
9
10
Spreadsheet: 80383d1280566716-rank-and-show-on-bell-chart-statsonsats
Sheet: Sheet1

 | Student | Math | Science | English | Combined | Math Rank(1st, 2nd etc) | Science Rank | English Rank | Combined Rank | Average of Rank | Average Poistional Rank |  | Math | Science | English | Combined total
 | [NAME] | 92 | 56 | 77 |  |  |  |  |  |  |  | Range
 | Pam | 65 | 87 | 75 |  |  |  |  |  |  |  | Mean
 | [NAME] | 42 | 13 | 55 |  |  |  |  |  |  |  | Median
 | [NAME] | 84 | 55 | 42 |  |  |  |  |  |  |  | StevdP
 | [NAME] | 25 | 45 | 87
 | [NAME] | 66 | 92 | 49
 | [NAME] | 51 | 56 | 65
 | [NAME] | 58 | 74 | 42
 | Kel | 49 | 43 | 74
 | Bel | 74 | 51 | 29
 | Shell | 75 | 65 | 57
Spreadsheet: 799945d1665408053-count-if-across-multi-tabs-to-exclude-a-value-in-final-count-2022-10-11-oeldere-randomfluky
Sheet: Office all

Name | Work titles | Office
[NAME] | Outdoors | Office 1
[NAME] | Outdoors | Office 1
[NAME] | Indoors | Office 1
[NAME] | Outdoors | Office 1
[NAME] | Kitchen | Office 1
[NAME] | Outdoors | Office 1
Nicola | Warehouse | Office 1
[NAME] | Outdoors | Office 1
Titchy | Indoors | Office 2
Willow | Outdoors | Office 2
Tanya | Indoors | Office 2
[NAME] | Kitchen | Office 2
[NAME] | Kitchen | Office 2
Boots | Outdoors | Office 2
Ursula | Kitchen | Office 2
[NAME] | Outdoors | Office 2
Haze | Indoors | Office 3
Lynsey | Outdoors | Office 3
[NAME] | Indoors | Office 3
[NAME] | Indoors | Office 3
[NAME] | Kitchen | Office 3
Rosy | Outdoors | Office 3
Posy | Outdoors | Office 3
Pudding | Outdoors | Office 3
Spreadsheet: 600094d1543461222-enter-data-based-on-2-different-cells-2-columns-different-sheets-grading-excel-form
Sheet: T2 AD

First name | Surname | ID number | Institution | Department | Email address | Attendance: Attendance | Assignment: Professionalism | Assignment: AD2 - ASSIGNMENT #1 - The Script Breakdown | Assignment: AD2 - ASSIGNMENT #2 - AD Paperwork Assignment (Part I) | Assignment: AD2 - ASSIGNMENT #3 - AD Paperwork Assignment (Pt II) | Assignment: AD2 - ASSIGNMENT #4 - T2 Projects AD Paperwork | Assignment: AD2 - ASSIGNMENT #5a/5b - T2 Film Projects Call Sheets | Course total
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | 10 | 14 | 14 | 14 | 14 | 15 | 15 | 96
Qiran ([NAME]) | [NAME] |  |  |  | [EMAIL] | 9.17 | 13 | 13 | 13 | 12 | 14 | 14 | 88.17
Muxin | [NAME] |  |  |  | [EMAIL] | 2.5 | 10 | 13 | 13 | 12 | 12 | 12 | 74.5
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | 9.17 | 14 | 14 | 14 | 14 | 14 | 14 | 93.17
Yiming ([NAME]) | [NAME] |  |  |  | [EMAIL] | 5.83 | 11 | 13 | 13 | 12 | 13 | 14 | 81.83
[NAME] ([NAME]) | Fang |  |  |  | [EMAIL] | 10 | 14 | 14 | 13 | 14 | 14 | 14 | 93
Qianyun (Fay) | Fang |  |  |  | [EMAIL] | 10 | 14 | 14 | 14 | 14 | 14 | 14 | 94
Yichao | Fu |  |  |  | [EMAIL] | 10 | 13 | 13 | 13 | 13 | 12 | 14 | 88
Junjie (Riol) | He |  |  |  | [EMAIL] | 10 | 14 | 14 | 14 | 14 | 14 | 14 | 94
Jiaqing (Agnes) | Kang |  |  |  | [EMAIL] | 7.5 | 12 | 14 | 14 | 14 | 14 | 14 | 89.5
Yuetong (Isabel) | [NAME] |  |  |  | [EMAIL] | 8.33 | 13 | 14 | 14 | 14 | 14 | 14 | 91.33
[NAME]) | [NAME] |  |  |  | [NAME] | 8.33 | 13 | 14 | 14 | 14 | 10 | 10 | 83.33
[NAME] (Klader) | [NAME] |  |  |  | [EMAIL] | 10 | 14 | 14 | 14 | 14 | 14 | 14 | 94
Ruimin (Vic) | [NAME] |  |  |  | [EMAIL] | 10 | 14 | 14 | 14 | 14 | 14 | 14 | 94
[NAME]) | [NAME] |  |  |  | [EMAIL] | 6.67 | 11 | 13 | 13 | 13 | 13 | 14 | 83.67
[NAME]Seven ） | Qi |  |  |  | [EMAIL] | 10 | 13 | 13 | 13 | 13 | 14 | 14 | 90
Junqi (Voang) | [NAME] |  |  |  | [EMAIL] | 10 | 14 | 14 | 14 | 14 | 14 | 14 | 94
[NAME]） | Xiao |  |  |  | [EMAIL] | 9.17 | 13 | 14 | 13 | 14 | 14 | 14 | 91.17
[NAME] (Leo) | [NAME] |  |  |  | [EMAIL] | 10 | 13 | 13 | 13 | 13 | 14 | 14 | 90
Chenyi (Freddie) | Zhang |  |  |  | [EMAIL] | 8.33 | 13 | 13 | 13 | 13 | 14 | 14 | 88.33
Linfeng (Wayne) | Zhang |  |  |  | [EMAIL] | 10 | 14 | 14 | 14 | 14 | 14 | 14 | 94
[NAME] (Vlad) | [NAME] |  |  |  | [EMAIL] | 10 | 14 | 14 | 14 | 14 | 14 | 14 | 94
Xinwei (Will) | [NAME] |  |  |  | [EMAIL] | 10 | 14 | 14 | 14 | 14 | 14 | 14 | 94
Hui ([NAME]) | Zhu |  |  |  | [EMAIL] | 9.17 | 13 | 13 | 13 | 14 | 14 | 14 | 90.17
Spreadsheet: 599475d1543099992-formula-for-extracting-data-according-the-criteria-excel
Sheet: Sheet

 |  | code | RHG
 |  | days | 1
 |  | value | 5
 |  | % | 7
 |  |  | Chooise 1 | Chooise 2 | Chooise 3 | Chooise 4 | Chooise 5
 |  | Code
 |  | days
 |  | value | 5 | 5 | 5
 |  | Direction | - | + | -
 |  | % | 20 | 15 | 8
Spreadsheet: 152847d1335548720-find-multiple-text-criteria-and-return-as-yes-in-matrix-passed-course-matrix
Sheet: Tabell1

Namn | Course | Result |  |  | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | Passed |  | [NAME] | Yes
[NAME] | Excel Medium | Passed |  | Excel Medium | Yes | Yes
[NAME] | Excel Advanced | Passed |  | Excel Advanced | Yes | Yes | Yes
[NAME] | Excel Medium | Passed
[NAME] | Excel Advanced | Passed
[NAME] | Excel Advanced | Passed
Requirement:
I want F4 to return text ”yes” if we can find data in column A, B and C which tells us that [NAME] has passed course ”Excel Easy”.
Appreciate all help, br Bertrand
Spreadsheet: 70465d1271202896-excel-2007-nested-if-statements-tracing-a-false-result-upload
Sheet: Sheet1

Column 1 | Column 2 | Column 3 | Column 4 | Recommendation
Exact | 1363.9 | 14 | 97.42
Not Exact | 204.47 | 2 | 101.18
Exact | 184.63 | 3 | 61.54
Not Exact | 153.9 | 2 | 76.95
Exact | 72.26 | 1 | 72.26
Spreadsheet: 735543d1623068816-using-formulas-is-it-possible-to-distribute-a-figure-between-specific-columns-monthly-revenue-pipeline-ans
Sheet: CMAP data

Current month | AUD | GBP | EUR | NZD | SGD | USD |  | Sector | Status | Probability | Company | Project | Start month | End month | Revenue remaining | Currency | Likelihood | GBP revenue remaining | Project duration | Months to end | 2021-06-01 00:00:00
 | 0.54 | 1 | 0.86 | 0.51 | 0.53 | 0.71 |  | Energy | Live | 100 | Example | Test | 2020-11-01 00:00:00 | 2021-10-01 00:00:00 | 10 | GBP
Exchange rates |  |  |  |  |  |  |  | Water | Potential | 50 | Example | Test 2 | 2022-02-01 00:00:00 | 2022-04-01 00:00:00 | 20 | USD
Spreadsheet: 34739d1232054542-look-up-formula-sample
Sheet: Sheet2

Carpet Range Avaliable | price per sqm
Sea Shell | 11
Elma | 12.95
Jewl Twist | 15.5
Delawere Twist | 16.5
Kingstown | 18.9
Lima | 24.95
[NAME] | 27.99
Spirit Twist | 31.25
Taranto Tile | 34.99
[NAME] | 39.99
Discount
0.05
0.1
0.15
0.2
Spreadsheet: 872575d1718947293-countifs-but-ignoring-duplicates-in-1-column-testdata-clientcount-by-week
Sheet: Data

Client | Team | Review Completed |  |  | Team | 2024.04.01 | 2024.04.08 | 2024.04.22 | 2024.04.29
1 | ICT | 2024-04-01 00:00:00 |  |  | BAU | 1 | 2 | 2 | 2
2 | ICT | 2024-04-02 00:00:00 |  |  | ICT | 3 | 2 | 1
3 | BAU | 2024-04-02 00:00:00 |  |  | Review | 3 | 1
4 | Review | 2024-04-04 00:00:00
5 | ICT | 2024-04-05 00:00:00
6 | Review | 2024-04-06 00:00:00
6 | Review | 2024-04-06 00:00:00
7 | Review | 2024-04-08 00:00:00
8 | BAU | 2024-04-09 00:00:00
9 | BAU | 2024-04-09 00:00:00
10 | ICT | 2024-04-10 00:00:00
10 | ICT | 2024-04-10 00:00:00
11 | ICT | 2024-04-22 00:00:00
12 | BAU | 2024-04-23 00:00:00
12 | BAU | 2024-04-23 00:00:00
13 | BAU | 2024-04-29 00:00:00
14 | BAU | 2024-04-30 00:00:00
Spreadsheet: 52173d1251882689-indexing-and-matching-multiple-criteria-solace-mk1
Sheet: Sheet1

Input
Building ID | 1 |  |  | 1 | CLEANING
Service | PORTERING |  |  | 2 | PORTERING
Output |  |  |  |  | M&E
 |  |  |  |  | WASTE
Client and Address Details
 |  | [NAME] | no service
 |  | [NAME] | #N/A
 |  | Contact Number
 |  | Contact Name
 |  | [NAME]
Spreadsheet: 147054d1332499964-vlookup-problem-dummy-workbook_120323
Sheet: Sheet1

WPS100 | 2
WPS100 | 2
WPS100 | 2
WPS101 | 4
WPS101 | 4
WPS101 | 4
WPS101 | 4
WPS102 | 2
WPS102 | 2
Spreadsheet: phillip_m_love__30630__9910WestFREDrevised
Sheet: FVar

Financial Liquidation Variances
Flash Perspective: Gas Acct to Review
TAGG | [NAME] | VLookupGL | [NAME] |  | Desk Adjustment | GL Adjustment/Reclass | Comments
EZ5870.1 | 272025 | -299925
N22143.2 | 132743.707 | -110544
N17849.4 | 100871.8535 | -87472
N21794.4 | 78371.85350000001 | -66472
N21794.2 | 76871.85350000003 | -65072
N21688.2 | 75371.8535 | -63672
N06428.4 | 55871.8535 | -45472
N31597.2 | 33750 | -19740
[NAME] | 22200 | -10992
N25554.1 | 82550 | 0
N18418.2 | -109871.8535 | 95872
N04528.1 | 90000 | 0 |  | Tsf done with Texas
Grand To | 4609987.668300001
Spreadsheet: john_griffith__15897__11_13_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 59 | 380 | 480 | 41.2 | 52.1 | 1.73 | 2001-11-13 10:25:00
 | HU F2 | 59 | 740 | 840 | 46 | 52.3 | 1.82 | 2001-11-13 10:25:00
 | HU G2 | 60 | 975 | 1075 | 45.1 | 49.7 | 1.79 | 2001-11-13 10:25:00
 | [NAME] | 61 | 1150 | 1250 | 44.9 | 48.8 | 1.8 | 2001-11-13 10:25:00
 | [NAME] | 67 | 1375 | 1475 | 43.5 | 46.7 | 1.9 | 2001-11-13 10:25:00
 | [NAME] | 67 | 1475 | 1575 | 42.2 | 45.1 | 1.84 | 2001-11-13 10:25:00
 | [NAME] | 67 | 1550 | 1700 | 40.6 | 44.6 | 1.79 | 2001-11-13 10:25:00
 | HU N2 | 67 | 1575 | 1725 | 38.7 | 42.5 | 1.71 | 2001-11-13 10:25:00
 | [NAME] |  |  |  | 36.7 | 41.4 | 1.64 | 2001-11-09 14:53:00
 | HU U2 |  |  |  | 36 | 39.4 | 1.59 | 2001-10-29 14:33:00
 | [NAME] |  |  |  | 32.2 | 36.6 | 1.43 | 2001-10-22 14:23:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU F3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | HU H3
Spreadsheet: 213429d1360512094-adding-a-scroll-bar-operatingscheduledraft2
Sheet: Calendar Year

 |  | month | PINS Date | enddate | Amount |  | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 |  | sum | control
 | Capital Depreciation - Hardware
 | Purchase 1 | 36 | 2013-01-01 00:00:00 |  | 10000
 | Purchase 2 | 36 | 2013-02-01 00:00:00 |  | 500
 | Purchase 3 | 36 | 2013-03-01 00:00:00 |  | 1000000
 | Purchase 4 | 36 | 2013-01-01 00:00:00 |  | 5000000
 | Purchase 5 | 36 | 2013-05-01 00:00:00 |  | 6000000
 | Capital Depreciation - Software
 | Purchase 1 | 60 | 2013-05-01 00:00:00 |  | 400
 | Purchase 2 | 60 | 2013-05-01 00:00:00 |  | 80000
 | Purchase 3 | 60 | 2013-05-03 00:00:00 |  | 9000
 | Purchase 4 | 60 | 2013-05-04 00:00:00 |  | 80000
 | Purchase 5 | 60 | 2013-05-05 00:00:00 |  | 900000
 | Maintenance
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] Expenses
 | Professional Services |  | 2013-05-01 00:00:00 |  | 10000
 | Licenses
 | Travel
Spreadsheet: sara_shackleton__36501__ENE MTM 0630 revised 2
Sheet: UBS Forward

 |  |  | ENRON CORP. FORWARD CONTRACT
 |  |  | INITIAL PRICE [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | As of
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 1999-07-12 00:00:00 |  |  |  | Mkt Val |  |  |  | 40.5
 |  |  |  |  |  |  |  |  |  |  |  |  | Spread |  |  |  | 0.0065 |  |  |  | Net
 |  |  | TRADE |  |  |  | PURCHASED |  | COST PER |  | DIV |  | COST LESS |  | # OF |  |  |  | CARRYING |  | CUM |  | CUMULATIVE |  | UNADJ FWD
 |  |  | DATE |  | SHARES |  | SHARE COST |  | SHARE |  | REC |  | DIVIDENDS |  | DAYS |  | LIBOR |  | COST |  | SHARES |  | COST |  | PRICE
 | [NAME] |  | 1999-06-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0518125
 |  |  |  |  | 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 |  | 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
 |  |  |  |  | -2888249 |  | 0 |  | 44.546 |  | 0
 |  |  |  |  | 3815051 |  | 0 |  | 78 |  | 0 |  |  |  | 1
 | Sub Purch |  |  |  | 0
 | Commission |  |  |  |  |  | 0
 | Total Purch for Month
 | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTM
Spreadsheet: 866408d1713326578-combine-2-data-sheets-based-on-target-colum-basedcolum
Sheet: RESULT

NO | ID | NAMES | [NAME] | CLASS
Spreadsheet: 49960d1249387002-regarding-pivot-table-sorting-problem-pivot-sort
Sheet: data

[NAME] | Name | count | Person
variance1 | Rajput var1 | 140 | 6
variance1 | [NAME] var1 | 73 | 4
variance1 | Kayastha var1 | 58 | 7
variance1 | Namboodiri var1 | 36 | 4
variance1 | Leva patil var1 | 36 | 7
variance1 | Agarwal var1 | 28 | 4
variance1 | Madhwa var1 | 28 | 5
variance1 | Havyaka var1 | 22 | 4
variance1 | Bunt var1 | 12 | 6
variance1 | [NAME] | 12 | 6
variance2 | [NAME] var1s | 140 | 5
variance2 | [NAME] | 110 | 4
variance2 | Madhwa var1s | 91 | 8
variance2 | Garhwali var1s | 58 | 4
variance2 | Kayastha var1s | 58 | 4
variance2 | Rajput var1s | 58 | 6
variance2 | Kshatriya var1s | 36 | 4
variance2 | Leva patil var1s | 36 | 6
variance2 | Agarwal var1s | 36 | 7
variance2 | Havyaka var1s | 22 | 4
variance2 | Saraswat var1s | 22 | 6
variance2 | Roman Catholic var1s | 12 | 4
variance2 | Caste no bar var1s | 12 | 5
Spreadsheet: 784356d1655673296-amend-formula-to-take-other-conditions-into-account-test1
Sheet: Home

 | Column No
 |  | Night "Bed" |  |  |  | Morning "Breakfast"
 |  | Start | End |  |  | Start | End
 |  | 22:00:00 | 02:00:00 |  |  | 05:00:00 | 10:00:00
 |  | Rest & Lengthy Data |  |  |  | [NAME] in "GR4" then press:
 |  | Rest | Data | Dec
 |  | 4 | 03:00:00
Spreadsheet: 703723d1605135266-converting-data-into-a-monthly-calendar-format-visual-ef1416_calendar_daily_totals
Sheet: Calendar

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year ==> | 2020
 | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun