tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 95452d1295038695-start-with-a-list-and-insert-a-new-row-every-so-often-samplesheeta
Sheet: RawSampleInfo

RAW INFORMATION - This data is pasted in by the user, and though all the column headers will be there, they will NOT be in the same order for any given user
A request id | Id numeric | A due date | A date avail | Job name | Sample name | A est conc | A process step |  |  |  |  |  |  |  |  |  |  |  |  | ID numeric
22217 | 100001 | 2010-05-27 00:00:00 | 2010-05-17 09:39:23.904000 | SM-044459 | RE114- D4-titer | 100 | OX
22217 | 100001 | 2010-05-27 00:00:00 | 2010-05-17 09:39:25.632000 | SM-044459 | RE115- D4-titer | 50 | OX
22217 | 100003 | 2010-05-27 00:00:00 | 2010-05-17 09:39:28.224000 | SM-044459 | RE116- D4-titer | 25 | OX
22217 | 100003 | 2010-05-27 00:00:00 | 2010-05-17 09:39:29.952000 | SM-044459 | RE213- D4-titer | 10 | OX
20966 | 100003 | 2010-03-11 00:00:00 | 1-MAR-2010 10:01:42.00 | SM-042452 | RE214- D4-titer | 5 | OX
20966 | 100006 | 2010-03-11 00:00:00 | 1-MAR-2010 10:01:44.00 | SM-042452 | RE216- D4-titer | 2 | OX
20902 | 100007 | 8-MAR-2010 08:01:12.00 | 2010-02-24 08:01:12.288000 | SM-042361 | RE114- D7-titer | Refer to MET-002325 result for accurate conc. | OX
20960 | 100008 | 2010-03-11 00:00:00 | 1-MAR-2010 10:00:54.00 | SM-042438 | RE115- D7-titer | 1.88 | OX
20960 | 100009 | 2010-03-11 00:00:00 | 1-MAR-2010 10:00:56.00 | SM-042438 | [NAME] | 1.88 | OX
22036 | 100010 | 2010-05-13 00:00:00 | 3-MAY-2010 09:47:01.00 | SM-044101 | RE213- [NAME]-titer | 1.88 | OX
22036 | 100011 | 2010-05-13 00:00:00 | 3-MAY-2010 09:47:03.00 | SM-044101 | RE214- D7-titer | 1.88 | OX
22036 | 100012 | 2010-05-13 00:00:00 | 3-MAY-2010 09:47:05.00 | SM-044101 | [NAME] | 1.88 | OX
21790 | 100013 | 2010-05-19 00:00:00 | 7-MAY-2010 08:14:51.00 | SM-043785 | RE114- [NAME]titer | 0.5 | OX
22958 | 100014 | 2010-08-13 00:00:00 | 3-AUG-2010 08:00:33.00 | SM-045546 | RE115- D9-titer | 0.6 | COLUMN_2
23135 | 100015 | 2010-08-12 00:00:00 | 2-AUG-2010 09:56:57.00 | SM-045775 | [NAME] | 1.88 | OX
23135 | 100016 | 2010-08-12 00:00:00 | 2-AUG-2010 09:56:59.00 | SM-045775 | RE213- [NAME] | 1.88 | OX
23135 | 100017 | 2010-08-12 00:00:00 | 2-AUG-2010 09:57:01.00 | SM-045775 | RE214- [NAME] | 1.88 | OX
23135 | 100018 | 2010-08-12 00:00:00 | 2-AUG-2010 09:57:04.00 | SM-045775 | RE216- D9-titer | 1.88 | OX
23135 | 100019 | 2010-08-12 00:00:00 | 2-AUG-2010 10:02:56.00 | SM-045776 | RE114- [NAME]-titer | 5.65874 | COLUMN_1
23135 | 100020 | 2010-08-12 00:00:00 | 2-AUG-2010 10:02:58.00 | SM-045776 | RE115- D11-titer | 5.55944 | COLUMN_1
23135 | 100021 | 2010-08-12 00:00:00 | 2-AUG-2010 10:03:00.00 | SM-045776 | RE116- D11-titer | 6.13063 | COLUMN_1
23135 | 100022 | 2010-08-12 00:00:00 | 2-AUG-2010 10:03:02.00 | SM-045776 | RE213- [NAME]-titer | 5.85564 | COLUMN_1
23135 | 100023 | 2010-08-12 00:00:00 | 2-AUG-2010 10:03:05.00 | SM-045776 | RE214- D11-titer | 5.87826 | COLUMN_1
Spreadsheet: 142290d1329765328-how-to-group-optimize-shipments-that-are-within-x-days-of-each-other-example_date_mod
Sheet: Sheet2

 | How to group (optimize) shipments that are within X days of each other
 | I've been trying to get my head around this for a few days now, even bought 4 books the thickness of telephone directories but I still have not been able
 | to crack this. I looked at solver which I think may be able to solve this, but I have not been able to figure out how to do it properly. Hope somebody might
 | have an idea or two of how to go about doing this.
 | Software:
 | Excel 2010
 | Problem:
 | I have a list of dates that are spread through out the month. I would like to group together dates that are within X number of days from each other,
 | with priority going to grouping with an earlier date rather then a later date if a date is within X days of two dates. For example, dates of 02/10/12, 02/15/12
 | and 02/19/12 with an X of 5. The middle date of 02/15/12 should be grouped with 02/10/12, and then 02/19/12 sent separately even though the middle date
 | is within 5 days of both dates. If there was a 4th date of 02/22/12, it could be sent with the 02/19/12 date since it is within 5 days. The dates above would all
 | be for one customer, another customer would have their own date range spread over a month that I would also try to consolidate with respect to their shipments.
 | What I am Trying to Do:
 | I would have a list of about 10 dates that would need to be grouped this way so I can minimize shipments. Rather then send each individual package separately,
 | grouping them with respect to X would help me save a lot of money on shipping, and as a new business every dollar saved helps me survive a day longer.
 | The X can change between different customers, so while some may have an X of 5, others may have an X of 3.
 | I would like for the results to be output on a separate part of the sheet so the employee just has to look at the dates and knows exactly what to package
 | together and ship, example, [NAME] and Item Name 2 on Date 02/10/15, Item 3 on Date 02/20/12. My ultimate goal is to export this result to .csv
 | file and upload to Google [NAME] so that it makes it even easier for the employee to know when to ship.
 | Is this even possible with Excel? It seems like anything can be done in Excel, I haven't been able to find an answer to this problem yet but I hope Excel can tackle it.
 | If my description is lacking please let me know and I will try to explain more. I have attached a workbook with additional example dates.
Spreadsheet: 463427d1464535774-formula-to-bring-multilple-values-sample-29-5-16
Sheet: request report

16011740
16011741
 | Invoice Number | Invoice Date | Order Date | Order Number | Order Type | Sold To | Sold To Name | Item Number | Item Description | Branch/Plant | Location | Lot Number | Lot [NAME] | Trans. Quantity | Trans. UoM | Sec. Quantity | Sec. UoM | Unit Cost | Extended Cost | Unit Price | Net Sales | Gross Sales | Discount | Margin | Margin % | Salesman No. | Salesman Name | Commodity Class | Commodity Class Desc | Commodity Sub Class | Commodity Sub Class Desc | Storage Type | Storage Type Desc | Sales Catalog Section | Sales Catalog Section Desc | Sub Section | Sub Section Desc | Packing | Packing Desc | Brand | Brand Desc | Country Of Origin | Country Of Origin Desc | Parent Address Number | Parent Address Name | Ship To | Ship To Name | Reason Code | Reason Code Desc | Customer PO Number | Original Document Number | Original Order Number | Original Order Date | Original Invoice Date
Spreadsheet: ac7f0805-4875-4e26-8ac8-e1533865995a
Sheet: Sheet1

Bay Indies Homeowners Association, Inc. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Summary Analysis of Financial Records
For Periods of 2011 and 2012
 | 2011 | 2011 |  | 2012 Proposed | 2012 Proposed
 | Proposed Budget | Actuals |  | Operating Budget | Reserve Budget
Revenues:
Beginning Cash as of January 1st
Operating Fund Budget | 24983.26 | 24983.26 |  | 37734.32
Reserve Fund for Possible Acquisition of Park and/or Major Legal Expenditures | 100000 | 100000 |  |  | 101916.43
[NAME] for 2011 in 2011 | 24000 | 24775
[NAME] for 2012 in 2011 |  | 8440 |  | 8440
[NAME] to be Collected for 2012 in 2012 |  |  |  | 20000
Interest Earned in 2011 | 200 | 2073.7
Miscellaneous other deposits |  | 201.23
Projected Interest Earned in 2012 |  |  |  | 200 | 1700
Total Budgeted, Actuals and Projected Revenues | 149183.26 | 160473.19 |  | 66374.32 | 103616.43
Expenditures:
Insurance Expenses | 2700 | 4585.6 |  | 4600
Legal Fees | 25000 | 9003.94 |  | 25000
Professional Fees (Appraiser/Rental Survey/Lobbyist, etc. | 1000 | 2705 |  | 2700
Office Supples/Postage/Etc. | 4000 | 1063.45 |  | 1500
Computer Purchase/Computer Repairs | 1500 | 0 |  | 1500
Printing/ Signs, Etc. | 2500 | 2050.28 |  | 2500
Web Site Expenses | 750 | 250.35 |  | 300
Miscellaneous Expenses | 200 | 0 |  | 200
Association Memberships | 0 | 652 |  | 0
Government fees, taxes | 0 | 80 |  | 80
[NAME] adjustments (returned check) | 0 | 60 |  | 0
Meetings - travel | 0 | 371.82 |  | 500
Total Budgeted, Actuals and Projected Expenditures | 37650 | 20822.44 |  | 38880
Total End of Year Cash Balances | 111533.26 | 139650.75 |  | 27494.32000000001 | 103616.43
for 2011 calendar year
2012-01-13 00:00:00 | 2050
2012-01-13 00:00:00 | 550
2012-01-22 00:00:00 | 1500
2012-02-07 00:00:00 | 4595
2012-02-07 00:00:00 | 11700
2012-02-09 00:00:00 | 1470
2012-02-14 00:00:00 | 900
2012-02-25 00:00:00 | 100
2012-03-05 00:00:00 | 150
2012-03-15 00:00:00 | 200
2012-03-24 00:00:00 | 50
2012-04-04 00:00:00 | 750
2012-04-05 00:00:00 | 150
2012-04-14 00:00:00 | 250
2012-04-22 00:00:00 | 50
2012-04-29 00:00:00 | 100
2012-05-24 00:00:00 | 50
2012-06-16 00:00:00 | 50
2012-07-12 00:00:00 | 150
 | 24815 | ?Burch $ 50 - 10 | for | fiscal '11
2012-07-14 00:00:00 | 40
2012-11-04 00:00:00 | 40
2012-11-04 00:00:00 | 120
2012-11-07 00:00:00 | 1240
2012-11-17 00:00:00 | 480
2012-12-07 00:00:00 | 800
2012-12-14 00:00:00 | 1960
2012-12-16 00:00:00 | 1800
2012-12-22 00:00:00 | 1160
2012-12-29 00:00:00 | 800
 | 8440 |  | for | fiscal '12
Spreadsheet: 747136d1631256719-offset-need-help-need-help
Sheet: Sheet1

Date | Shift | Date ID |  |  | Date ID | Testing
2021-09-01 00:00:00 | C
2021-09-02 00:00:00 | A
2021-09-03 00:00:00 | C
2021-09-04 00:00:00 | A
2021-09-05 00:00:00 | B
2021-09-06 00:00:00 | D
2021-09-07 00:00:00 | B
2021-09-08 00:00:00 | D
2021-09-09 00:00:00 | A
Spreadsheet: 105509d1302824095-merging-data-test
Sheet: Sheet1

96991 | 1 | APB SPECIALIST GROUP MEDICAL VISITS
96991 | 2 | FEE PER PATIENT PER 1/2 HOUR: GREATER THAN TWENTY PATIENTS (PER PATIENT).
96991 | 3 | NOTES:
96991 | 4 | I)   A SEPARATE CLAIM MUST BE SUBMITTED FOR EACH PATIENT
96991 | 5 | II)  AN ACTIVE REFERRAL IS REQUIRED BY A MEDICAL PRACTITIONER OR A HEALTH CARE
96991 | 6 | PRACTITIONER FOR EACH PATIENT.
96991 | 7 | III) PAYABLE ONLY TO SPECIALIST PHYSICIANS WHO HAVE COMPLETED, OR ARE CURRENTLY
96991 | 8 | ENROLLED IN, THE SPECIALIST SERVICES COMMITTEE PRACTICE SUPPORT PROGRAM ON
96991 | 9 | ADVANCED ACCESS AND GROUP MEDICAL VISITS OR A RECOGNIZED EQUIVALENT.
96991 | 10 | IV)  CLAIM MUST STATE START AND END TIMES FOR THE SERVICE.
96991 | 11 | V)   SERVICE IS NOT PAYABLE WITH OTHER SERVICES, FOR THE SAME PATIENT, ON THE
96991 | 12 | SAME DAY.
Spreadsheet: 0c3bab1b-e6a7-4df2-aac3-a3997261a2bb
Sheet: Sheet1

Table 7--U.S. feed grain imports by selected sources (1,000 metric tons) 1/, 5/14/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Import and country/region |  | ---------- 2010/11 ---------- |  | ---------- 2011/12 ---------- |  | 2012/13
 |  | Mkt year | [NAME] | Mkt year | [NAME] | [NAME]
Oats | Canada | 1393.292808 | 1178.29094 | 1556.499397 | 1372.683052 | 1368.997472
 | Finland | 73.932572 | 73.932572 | 34.84057 | 34.84057
 | Jamaica | 0.159212 | 0.0109 | 0.285218 | 0.285218
 | All other countries | 0.264317 | 0.213225 | 29.802409 | 29.363469 | 1.477073
 | Total 2/ | 1467.648909 | 1252.447637 | 1621.427594 | 1437.172309 | 1370.474545
Malting barley | Canada | 174.724159 | 161.596156 | 263.660306 | 215.958021 | 293.633636
 | All other countries | 0.006579999999999999 | 0.006579999999999999 | 0.244638 | 0.244638 | 0.05703
 | Total 2/ | 174.730739 | 161.602736 | 263.904944 | 216.202659 | 293.690666
Other barley 3/ | Canada | 30.697571 | 19.163283 | 89.27383699999999 | 77.49037299999999 | 131.991172
 | All other countries | 1.288141 | 1.123152 | 0.7575110000000002 | 0.6632440000000001 | 2.941826
 | Total 2/ | 31.98571199999999 | 20.286435 | 90.03134800000001 | 78.153617 | 134.932998
1/ Grain only. Market year (June-May) and market year to date. 2/ Totals may not add due to rounding.
3/ Grain for purposes other than malting, such as feed and seed use. Source: U.S. Department of Commerce, Bureau of the Census, Foreign Trade Statistics.
Date run: 5/13/2013
Spreadsheet: 163177d1340212083-if-index-match-problem-audits
Sheet: Minden Minden Unit June 2012

 |  | Nabors Well Services Co. |  |  |  |  |  | Southeast District
 |  |  |  |  |  |  |  | Truck Safety Audit
Area: | Crane | Minden |  |  |  |  | Date: | 39240 | 2012-06-02 00:00:00
Driver: | [NAME] | [NAME] |  |  |  |  | Unit #: | 342 | Minden Unit
Supervisor: |  | Minden Supervisor |  |  |  |  | Trailer#: | 747 | [NAME]
Inspectors: |  | Minden Inspectors |  |  |  |  | Unit Type: | KT | [NAME]
Type of Job in Progress: |  |  | PSW
Truck Safety Audit Review |  |  |  |  | U/S | Comments
1. "Meet & Greet" conducted |  |  |  |  | N/A
2. [NAME] conducted / up to date |  |  |  |  | N/A
3.  All paperwork current and placed in 3-ring binder in Tractor |  |  |  |  | S
4. Vehicle and trailer inspection/registration current |  |  |  |  | N/A
5. Driver's CDL & Medical Card current |  |  |  |  | U | Minden 1
6. Log Book up to date / accurate (to last duty change) |  |  |  |  | S
7. DVIR up to date |  |  |  |  | S
8. MSDS Book and [NAME]. Resp. Manual available |  |  |  |  | U | Minden 2  Very Long Comment  a;lkdjf;alsdkj f;aldskjf;alkdjf;aldskj f;alsdkjf; [NAME] ;alsdkj f;alkdjf;askdjf;laskdj f;aldskjf;alkdjf;alkdsjf;ask jf;alksd jf;akjfa; ldskf;akds;fakdj;flaskj ;falkjdf;alkjf;akjfa;lk
9. Low Air Warning device functional |  |  |  |  | S
10. Windshield/mirrors free of damage and meets DOT standards |  |  |  |  | S
11. Horns functional |  |  |  |  | U
12. Seat belt condition and in use |  |  |  |  | S
13. Flash light available (explosion proof / UL label) |  |  |  |  | S
14. First Aid / BBP Kit / 32oz. Eye wash |  |  |  |  | S
15. Emergency Highway warning device (Triangles) |  |  |  |  | S
16. Vehicle Housekeeping adequate (Interior/Exterior) |  |  |  |  | S
17. Wheel chocks and cones available / in use |  |  |  |  | S
18. Warning Signs / Labels in place / legible (Placards) |  |  |  |  | S
19. Ladder, guardrails and walkway |  |  |  |  | S
20. Mechanical condition (i.e. leaks, wear, 5th wheel compensator/King pin) |  |  |  |  | S
21. Hand tool condition |  |  |  |  | S
22. Equipment and cargo secured (i.e. hoses, fittings, buckets, chocks, etc.) |  |  |  |  | S
23. PPE available and in use |  |  |  |  | N/A
24. Tire, wheel and mudflaps condition |  |  |  |  | N/A
25. Ground wire available/condition and in use |  |  |  |  | N/A
26. Fire Extinguishers (location, size and inspected) |  |  |  |  | N/A
27. Lights - condition / operational |  |  |  |  | N/A
28. Steel Bucket utilized - (No plastic buckets) |  |  |  |  | N/A
29. Overall condition of Unit / Trailer |  |  |  |  | N/A
30. Winch Cable free of damage |  |  |  |  | S
31. Observable Behaviors (Safe/Unsafe) |  |  |  |  | N/A
32. Trailer floor board condition (if applicable) |  |  |  |  | S
33. Pressure pop-off/vac relief installed? |  |  |  |  | S
U=Unsatisfactory    S=Satisfactory
Additional Comments:
 |  |  |  |  |  |  |  |  |  |  |  |  | Revised:  11/30/2011
Spreadsheet: 286150d1388093537-calendar-that-will-populate-by-user-and-date-practise-roster
Sheet: Calendar

 |  |  | FR 1 | FR 2 | Start Date | Finish Date | Customer
 |  |  | BM | ES | 2014-01-02 00:00:00 |  | ABC PTY LTD
 |  |  | FR |  | 2014-01-02 00:00:00 | 2014-01-05 00:00:00 | 123 Pty ltd
 |  |  | BM |  | 2014-01-21 00:00:00 |  | XYZ Pty Ltd
Key
AL | Annual Leave
 | Public Holiday
 |  | 2014-01-01 00:00:00
 |  | 2014-01-01 00:00:00 | 2014-01-02 00:00:00 | 2014-01-03 00:00:00 | 2014-01-06 00:00:00 | 2014-01-07 00:00:00 | 2014-01-08 00:00:00 | 2014-01-09 00:00:00 | 2014-01-10 00:00:00 | 2014-01-13 00:00:00 | 2014-01-14 00:00:00 | 2014-01-15 00:00:00 | 2014-01-16 00:00:00 | 2014-01-17 00:00:00 | 2014-01-20 00:00:00 | 2014-01-21 00:00:00 | 2014-01-22 00:00:00 | 2014-01-23 00:00:00 | 2014-01-24 00:00:00 | 2014-01-27 00:00:00 | 2014-01-28 00:00:00 | 2014-01-29 00:00:00 | 2014-01-30 00:00:00 | 2014-01-31 00:00:00
[NAME] | BM
Emmanuel | ES
[NAME] | FR
Jeremy | [NAME]
Mega | MS
[NAME] | SG
[NAME] | BMD
[NAME] | DH
[NAME] | KI
[NAME] | LL
Saville | SG
 |  | 2014-02-01 00:00:00
 |  | 2014-02-03 00:00:00 | 2014-02-04 00:00:00 | 2014-02-05 00:00:00 | 2014-02-06 00:00:00 | 2014-02-07 00:00:00 | 2014-02-10 00:00:00 | 2014-02-11 00:00:00 | 2014-02-12 00:00:00 | 2014-02-13 00:00:00 | 2014-02-14 00:00:00 | 2014-02-17 00:00:00 | 2014-02-18 00:00:00 | 2014-02-19 00:00:00 | 2014-02-20 00:00:00 | 2014-02-21 00:00:00 | 2014-02-24 00:00:00 | 2014-02-25 00:00:00 | 2014-02-26 00:00:00 | 2014-02-27 00:00:00 | 2014-02-28 00:00:00
[NAME]
Emmanuel
[NAME]
Jeremy
Mega
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Saville
 |  | 2014-03-01 00:00:00
 |  | 2014-03-03 00:00:00 | 2014-03-04 00:00:00 | 2014-03-05 00:00:00 | 2014-03-06 00:00:00 | 2014-03-07 00:00:00 | 2014-03-10 00:00:00 | 2014-03-11 00:00:00 | 2014-03-12 00:00:00 | 2014-03-13 00:00:00 | 2014-03-14 00:00:00 | 2014-03-17 00:00:00 | 2014-03-18 00:00:00 | 2014-03-19 00:00:00 | 2014-03-20 00:00:00 | 2014-03-21 00:00:00 | 2014-03-24 00:00:00 | 2014-03-25 00:00:00 | 2014-03-26 00:00:00 | 2014-03-27 00:00:00 | 2014-03-28 00:00:00 | 2014-03-31 00:00:00
[NAME]
Emmanuel
[NAME]
Jeremy
Mega
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Saville
Spreadsheet: 803059d1667233437-check-if-there-is-duplicated-records-in-date-range-duplicated-in-date-range-_-etaf
Sheet: Sheet1

 | Main |  |  |  |  |  | Second
 | # | Code | Date | Excepted result | [NAME] |  | # | Code | Date
 | 1 | 22 | 2022-10-25 00:00:00 | Yes |  |  | 1 | 22 | 2022-11-11 00:00:00
 | 2 | 33 | 2022-09-10 00:00:00 | Yes |  |  | 2 | 33 | 2022-11-11 00:00:00
 | 3 | 33 | 2022-09-11 00:00:00 | Yes |  |  | 3 | 33 | 2022-11-11 00:00:00
 | 4 | 11 | 2022-01-01 00:00:00 | Yes |  |  | 4 | 11 | 2022-01-02 00:00:00
 | 5 | 22 | 2022-10-27 00:00:00 | Yes |  |  | 5 | 22 | 2022-11-11 00:00:00
 | 6 | 77 | 2022-01-01 00:00:00 | No |  |  | 6 | 77 | 2022-11-11 00:00:00
 | 7 | 99 | 2022-01-01 00:00:00 | No |  |  | 7 | 99 | 2022-11-11 00:00:00
 | 8 | 66 | 2022-01-01 00:00:00 | No |  |  | 8 | 66 | 2022-11-11 00:00:00
 | 9 | 22 | 2022-10-20 00:00:00 | No |  |  | 9 | 22 | 2022-11-11 00:00:00
 | 10 | 88 | 2022-01-01 00:00:00 | No |  |  | 10 | 88 | 2022-11-11 00:00:00
Spreadsheet: 675245d1588210692-transposing-data-without-blanks-from-columns-to-rows-test-1-
Sheet: What I need

I need the Equipment Code (column C in Data tab) from column B (columns), per week (rows), only if value in column G of Data tab is different from "H" or "J" and if the column corresponding with the week has an "x"
See example in row 7, for week 3
Week | Code 1 | Code 2 | Code 3 | Code 4 | Code 5 | Code 6 | Code 7 | Code 8 | Code 9 | Code 10 | Code 11 | Code 12 | Code 13 | Code 14 | Code 15 | Code 16 | Code 17 | Code 18 | Code 19 | Code 20
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
Spreadsheet: 70334d1271116435-if-formula-config-sheet-budget-2011
Sheet: Config

 | Budget Configuration Page
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Weekly
 | Number of Payees | 2 |  | Year | 2010 |  |  |  |  | Income Categories |  | Expense Categories |  |  |  | 2 | Bi-Weekly
 |  |  |  |  |  |  |  |  |  | Payday |  | Utilities |  |  |  |  | Twice-a-Month
 |  |  |  |  |  |  |  |  |  | Disability |  | Loan |  |  |  |  | Monthly
 | Twice-a-Month | 1st | 15th |  | Bi-Weekly | 1st | 15th |  |  | Social Security |  | Entertainment
 |  | 2010-01-01 00:00:00 |  |  |  | 2010-04-16 00:00:00 |  |  |  | ETC |  | ETC
 |  |  |  |  |  |  |  |  |  | ETC |  | ETC
 |  |  |  |  |  |  |  |  |  | ETC |  | ETC
Spreadsheet: 820030d1677831236-extract-record-from-table-on-multiple-criteria-03032023-sample-file
Sheet: Sheet1

Result |  |  |  |  |  |  | Data Table
Limit | Prd | Scheme | Interest |  |  |  | Limit UPTO | interest | Prd | Scheme1 | Scheme2 | Scheme3 | Scheme4
400000 | 504 | NEW 20-05-17 SAL DED | 0.145 |  |  |  | 500000 | 0.145 | 504 | SAL DED LOAN | NEW 20-05-17 SAL DED
800000 | 504 | SAL DED LOAN | 0.15 |  |  |  | 5000000 | 0.15 | 504 | SAL DED LOAN | NEW 20-05-17 SAL DED
1600000 | 788 | NEW 20-05-17 VEH | 0.1125 |  |  |  | 100000000 | 0.16 | 504 | SAL DED LOAN | NEW 20-05-17 SAL DED
32000000 | 504 | NEW 20-05-17 SAL DED | 0.16 |  |  |  | 500000 | 0.145 | 715 | CLE SCHEME | CLE ABN SCHEME | NEW 20-05-17 CLE  SCHEME | NEW PERSON SCHEME
300000 | 715 | NEW 20-05-17 CLE  SCHEME | 0.145 |  |  |  | 5000000 | 0.1125 | 788 | DEC 2021 VEH COMERCIAL USE | NEW 20-05-17 VEH | DEC 2021 VEH PERSONAL USE | VEH
Spreadsheet: 672720d1586970693-filter-with-multiple-or-criteria-help
Sheet: Team B

Team B
Brand | Inititative | Priority | Status | Launch Timing | Exp. Team / Business Team
 | Test 123 | 1 | In Progress | Q2 | Ops Marketing  International   Domestic Team A   Team B Team C
All Teams
Brand | Inititative | Priority | Status | Launch Timing | Exp. Team / Business Team
 | Test 2121 | 1 | Next on Deck | Q3 | All Teams
AB | Test 4119 | 1 | Requires Discovery | TBD | All Teams
EF | Test 6783 | 3 | On Hold | Q2 | All Teams
Spreadsheet: 53263d1253176295-locking-values-example_md_code
Sheet: Calculation WORKBOOK

Emp No. | Employee/app.name | Hours | Category |  | Name | Work | Leave | Maintenance | Training
1000 | SMITH JOE | 8 | Work |  | SMITH JOE | 8 | 9 | 11 | 2
1000 | SMITH JOE | 9 | Leave |  | JONES BOB | 5 | 6 | 4 | 5
1000 | SMITH JOE | 11 | Maintenance |  | [NAME] | 1 | 2 | 8 | 9
1000 | SMITH JOE | 2 | Training |  | GREG HARRY | 9 | 8 | 5 | 4
90023974 | JONES BOB | 5 | Work |  | PHIL BRIAN | 3 | 6 | 4 | 15
90023974 | JONES BOB | 6 | Leave |  | BROWN SIMON | 18 | 2 | 3 | 6
90023974 | JONES BOB | 4 | Maintenance
90023974 | JONES BOB | 8 | Training
90023974 | [NAME] | 1 | Work
90023974 | [NAME] | 2 | Leave
90023974 | [NAME] | 8 | Maintenance
90023974 | [NAME] | 9 | Training
90023974 | GREG HARRY | 9 | Work
90023974 | GREG HARRY | 8 | Leave
90023974 | GREG HARRY | 5 | Maintenance
90023974 | GREG HARRY | 4 | Training
90023974 | PHIL BRIAN | 3 | Work
90023974 | PHIL BRIAN | 6 | Leave
90023974 | PHIL BRIAN | 4 | Maintenance
90023974 | PHIL BRIAN | 15 | Training
90023974 | BROWN SIMON | 18 | Work
90023974 | BROWN SIMON | 2 | Leave
90023974 | BROWN SIMON | 3 | Maintenance
90023974 | BROWN SIMON | 6 | Training