tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 103827d1301509312-two-unrelated-listboxes-on-same-worksheet-mastercombo
Sheet: General

*** GENERAL TRACKING LOG CHECKLIST ***
PROJECT/BASE ITEM #: |  |  | TECH LEAD NAME: |  |  |  |  | PAGES:
TRACKING LOG TYPE: |  |  | RECORD TYPE: |  |  |  | RECORD #:
TRACKING LOG TYPE: |  |  | RECORD TYPE: |  |  |  | RECORD #:
TRACKING LOG TYPE: |  |  | RECORD TYPE: |  |  |  | RECORD #:
TRACKING LOG TYPE: |  |  | RECORD TYPE: |  |  |  | RECORD #:
SYSTEMS IMPACTED: |  |  |  |  | PLANNED IMPLEMENATION DATE:
[NAME]:
SOURCE CODE MNGMT:
WALKTHROUGHS |  | CHECKED | ATTACHED
Design
Code
Test Cases
Impl Records
IMPORTANT:  **** ALL SIGNATURES/INITIALS/CHECK BOXES CARRY ACCOUNTABILITY ****
ASSIGNED TO: |  | [NAME] BY: |  |  |  | Manager’s Signature:
 |  |  |  |  |  | ATTACHED
SIGN OFFS |  | CHECKED | DATE | SIGN OFF BY: |  |  | REASON, IF NOT REQUIRED
Unit Test Verified
DIT Test
SIT Tested
UAT Test
Other Test Cycles
Implementation Plan
RECORD APPROVAL DATE:
APPROVED BY:
ADDITIONAL APPROVAL REQUIRED:
 |  | RECORD RESET
DATE:
MANAGER’S APPROVAL:
REASON:
FOR LIBRARIAN USE ONLY:
MIGRATION REQUEST FILED:
LAA move elements to TEST stage, Signed over to [NAME]  and  Implementation locked.
Date tracking log received:
Click here to return to the top, to make additional request form selections
Spreadsheet: 866063d1713000196-need-formula-that-extracts-every-third-value-in-col-b-based-on-value-1-2-3-in-col-a-transcript-365-aligw
Sheet: Step2

1 | 0:0:0.0 --> 0:0:1.470
2 | [NAME]
3 | Umm I have about one minute.
 | 0:0:2.990 --> 0:0:3.640
 | [NAME]
 | We can start the meeting.
 | 0:0:4.210 --> 0:0:4.750
 | [NAME]
 | Sounds good.
 | 0:0:5.630 --> 0:0:6.220
 | [NAME]
 | Thanks, [NAME].
 | 0:0:6.230 --> 0:0:11.900
 | [NAME]
 | So I still see we don't have anyone from Organization X.
 | 0:0:14.0 --> 0:0:21.870
 | [NAME]
 | We can expect other participants as well.
 | 0:0:22.400 --> 0:0:24.230
 | [NAME]
 | So let's give it a minute.
 | 0:0:31.740 --> 0:0:32.440
 | [NAME]
 | We certainly do.
 | 0:0:32.450 --> 0:0:36.770
 | [NAME]
 | Do you know whether someone from Organization Y will join?
 | 0:0:36.780 --> 0:0:41.530
 | [NAME]
 | Anybody else from your team will be joining this meeting.
 | 0:0:42.170 --> 0:0:44.250
 | [NAME]
 | IT Help Desk should join.
 | 0:0:44.260 --> 0:0:51.120
 | [NAME]
 | I believe [NAME] is on a telephone call, so I'm not sure if he'll be able to make it in, but I think we're good.
Spreadsheet: 824960d1680979821-how-to-add-sum-formula-for-various-sheets-expenses
Sheet: 2021

Personal Expenses
Month | Date | Category | Sub-Category | Description | Credit | Debit | Balance
 | 2021-06-21 00:00:00 | Donation | Zakath |  |  | 5000
 | 2021-06-23 00:00:00 | Donation | Sadqa |  |  | 500
 | 2021-06-28 00:00:00 | Donation | Zakath |  |  | 1500
 | 2021-07-11 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-07-12 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-07-14 00:00:00 | Donation | Sadqa |  |  | 500
 | 2021-07-17 00:00:00 | Donation | Sadqa |  |  | 20
 | 2021-07-17 00:00:00 | Donation | Sadqa |  |  | 10
 | 2021-07-19 00:00:00 | Donation | Sadqa |  |  | 1500
 | 2021-07-20 00:00:00 | Donation | Sadqa |  |  | 500
 | 2021-07-21 00:00:00 | Donation | Sadqa |  |  | 500
 | 2021-07-21 00:00:00 | Donation | Sadqa |  |  | 500
 | 2021-07-25 00:00:00 | Donation | Sadqa |  |  | 10
 | 2021-07-29 00:00:00 | Donation | Zakath |  |  | 2000
 | 2021-07-30 00:00:00 | Donation | Sadqa |  |  | 10
 | 2021-07-31 00:00:00 | Donation | Sadqa |  |  | 10
 | 2021-08-06 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-08-08 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-08-11 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-08-14 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-08-14 00:00:00 | Donation | Sadqa |  |  | 500
 | 2021-08-24 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-09-10 00:00:00 | Donation | Sadqa |  |  | 500
 | 2021-09-12 00:00:00 | Donation | Sadqa |  |  | 1000
 | 2021-10-08 00:00:00 | Donation | Zakath |  |  | 5000
 | 2021-10-09 00:00:00 | Donation | Sadqa |  |  | 2000
 | 2021-10-15 00:00:00 | Donation | Zakath |  |  | 100
 | 2021-10-19 00:00:00 | Donation | Zakath |  |  | 2000
 | 2021-11-07 00:00:00 | Donation | Sadqa |  |  | 20
 | 2021-11-07 00:00:00 | Donation | Sadqa |  |  | 20
 | 2021-11-07 00:00:00 | Donation | Sadqa |  |  | 2000
 | 2021-11-08 00:00:00 | Donation | Sadqa |  |  | 20
 | 2021-11-09 00:00:00 | Donation | Sadqa |  |  | 10
 | 2021-11-18 00:00:00 | Donation | Sadqa |  |  | 20
 | 2021-11-27 00:00:00 | Donation | Sadqa |  |  | 20
 | 2021-11-27 00:00:00 | Donation | Sadqa |  |  | 10
 | 2021-12-01 00:00:00 | Donation | Sadqa |  |  | 50
 | 2021-12-04 00:00:00 | Donation | Sadqa |  |  | 10
 | 2021-12-30 00:00:00 | Donation | Sadqa |  |  | 500
 | 2021-12-30 00:00:00 | Donation | Sadqa |  |  | 100
 | 2021-12-30 00:00:00 | Donation | Sadqa |  |  | 150
 | 2021-12-30 00:00:00 | Donation | Sadqa |  |  | 100
 | 2022-02-09 00:00:00 | Income |  |  | 75000
Total
Spreadsheet: 216884d1361912560-time-log-for-various-employees-on-various-projects-on-various-days-labor-expense-reclass-to-afe-pcb-2
Sheet: Detailed Employee Summary

AFE | AFE Description | Employee Name | Date | Rate | Reg Hours | OT Hours | Total | Reg $ | OT $ | Total$ | Year-Month
1870 | Line # 2 Upgrade | Bubba | 2013-02-20 00:00:00 | 11 | 10 |  | 10 | 110 | 0 | 110 | 2013-02
1870 | Line # 2 Upgrade | [NAME] | 2013-02-20 00:00:00 | 12 | 3 |  | 3 | 36 | 0 | 36 | 2013-02
1870 | Line # 2 Upgrade | Cletus | 2013-02-21 00:00:00 | 13 | 3 |  | 3 | 39 | 0 | 39 | 2013-02
1870 | Line # 2 Upgrade | [NAME] | 2013-02-21 00:00:00 | 14 | 1 |  | 1 | 14 | 0 | 14 | 2013-02
1873 | Line # 3 Upgrade | [NAME] | 2013-02-14 00:00:00 | 11 |  | 8.5 | 8.5 | 0 | 140.25 | 140.25 | 2013-02
1873 | Line # 3 Upgrade | [NAME] | 2013-02-14 00:00:00 | 22 |  | 1 | 1 | 0 | 33 | 33 | 2013-02
1933 | 72 Inch Die | [NAME] | 2013-02-14 00:00:00 | 22 |  | 1 | 1 | 0 | 33 | 33 | 2013-02
1933 | 72 Inch Die | [NAME] | 2013-02-18 00:00:00 | 33 |  | 3 | 3 | 0 | 148.5 | 148.5 | 2013-02
Spreadsheet: 772752d1647453785-gantt-chart-drop-down-box-help-needed-fake-data
Sheet: Raw Hours

SCHEDULED HOURS | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
[NAME] | 09:00:00 | 15:00:00 | 10:00:00 | 14:00:00 | 13:30:00 | 16:00:00 | 10:00:00 | 14:00:00 | 11:00:00 | 1900-01-01 00:00:00
[NAME] | 10:00:00 | 14:00:00 | 11:00:00 | 15:00:00 | 12:00:00 | 16:00:00 |  |  | 09:00:00 | 17:30:00 | 09:00:00 | 13:30:00
Chrissy | 09:30:00 | 15:00:00 |  |  | 09:00:00 | 12:00:00 | 10:00:00 | 14:00:00 |  |  | 10:00:00 | 14:00:00
BREAK TIMES | Monday |  |  |  |  |  | Tuesday |  |  |  |  |  | Wednesday
 | Break 1 |  | Lunch |  | Break 2 |  | Break 1 |  | Lunch |  | Break 2 |  | Break 1 |  | Lunch |  | Break 2
[NAME] | 10:30:00 | 10:40:00 | 12:00:00 | 12:30:00 | 14:00:00 | 14:10:00 | 11:00:00 | 11:15:00 |  |  |  |  | 14:30:00 | 14:45:00
[NAME] | 12:00:00 | 12:15:00 |  |  |  |  | 14:00:00 | 14:10:00 |  |  |  |  | 14:00:00 | 14:10:00
Chrissy | 10:00:00 | 10:10:00 | 12:00:00 | 12:30:00 | 14:00:00 | 14:10:00 |  |  |  |  |  |  | 10:30:00 | 10:40:00
Spreadsheet: 4f0e57d8-c8ce-4ed7-af8f-48709c6e39de
Sheet: TIG Cohort 2 Yr 3

Grant: |  | Tiered Intervention Grant Cohort 2
CFDA # |  | 84.377
GRANT NUMBER: |  | 7377
FISCAL YEAR: |  | 2013-14
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]-866-6724  or [EMAIL]
Questions regarding grant: |  | [NAME]6389 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - September 15, 2014
Code | School Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JULY  2013 | AUGUST  2013 | SEPTEMBER  2013 | OCTOBER  2013 | NOVEMBER  2013 | DECEMBER  2013 | JANUARY  2014 | FEBRUARY  2014 | [NAME]  2014 | APRIL  2014 | MAY  2014 | JUNE  2014 | JULY  2014 | AUGUST  2014 | SEPTEMBER  2014
0502-S | Meadow Community School | 237959 |  |  |  |  |  |  |  | 58921 | 20907 | 20451 | 18175
2876-S | Fairview Elementary School | 138126 |  |  |  |  |  |  |  |  | 9933 | 4683 | 13434
3144-S | FM Day Elementary School | 280966 |  |  |  |  |  | 18794 | 6439 |  |  |  | 13592
5834-S | Mesa Elementary School | 433770 |  |  |  |  |  | 25911 | 6240 |  |  |  | 104529
7860-S | Sherrelwood Elementary School | 84714 |  |  |  |  |  | 538 | 452 |  |  | 15205 | 17064
8909-S | Trevista ECE-8 at Horace Mann | 245744
9462-S | Westminster Elementary School | 77533 |  |  |  |  |  | 4648 | 2552 | 2324 | 5525 | 5940 | 10461
Spreadsheet: a6f78318-944f-41bc-b010-a0ca7ebfedc0
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 6 | 32120 | 32512 | 31337 | 27628
6 - 15 | 34898 | 39329 | 43288 | 43272
15 - 25 | 60901 | 42513 | 47947 | 51728
25 - 40 | 123361 | 130397 | 113897 | 99676
40 - 65 | 163501 | 163742 | 166215 | 170461
65 und mehr | 115000 | 119299 | 126100 | 130519
Insgesamt | 529781 | 527792 | 528784 | 523284
%
unter 6 | 6.062882587333256 | 6.160002425197805 | 5.926238312808255 | 5.279733376139916
6 - 15 | 6.587250203385928 | 7.451609725043198 | 8.18632938969409 | 8.269314559589057
15 - 25 | 11.49550474630083 | 8.0548776790857 | 9.067407485854337 | 9.885263069384886
25 - 40 | 23.28528203163194 | 24.70613423469852 | 21.53941874186814 | 19.04816504995375
40 - 65 | 30.86199769338651 | 31.02396398581259 | 31.43343974099065 | 32.57523639171081
65 und mehr | 21.70708273796154 | 22.60341195016219 | 23.84716632878453 | 24.94228755322158
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 31. [NAME] 2008
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 726953d1617620222-data-filter-advanced-criteria-date-not-working-test-date
Sheet: TEST_DATE

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Symbol | ISIN | Entry Date | Exit Date | Quantity | Buy Value | Sell Value | Profit
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >14-05-2018
 | Symbol | ISIN | Entry Date | Exit Date | Quantity | Buy Value | Sell Value | Profit | Period of Holding | Fair Market Value | Taxable Profit | Turnover
 | NESTLEIND | INE239A01016 | 2018-02-21 00:00:00 | 2018-05-22 | 2 | 15453.9 | 19199.6 | 3745.7 | 83 | 0 | 3745.7 | 0
 | NESTLEIND | INE239A01016 | 2018-02-28 | 2018-05-22 | 1 | 7726.95 | 9599.8 | 1872.85 | 83 | 0 | 1872.85 | 0 |  | D8 | When I edit the date,FORMAT CHANGES AND  it becomes like this.
 | NESTLEIND | INE239A01016 | 2018-02-28 | 2018-05-22 | 1 | 7726.95 | 9599.8 | 1872.85 | 83 | 0 | 1872.85 | 0
 | NESTLEIND | INE239A01016 | 2018-02-28 | 2018-05-22 | 1 | 7726.95 | 9599.8 | 1872.85 | 83 | 0 | 1872.85 | 0
 | NESTLEIND | INE239A01016 | 2018-02-28 | 2018-05-22 | 1 | 7726.95 | 9599.8 | 1872.85 | 83 | 0 | 1872.85 | 0
 | NESTLEIND | INE239A01016 | 2018-02-28 | 2018-05-22 | 1 | 7726.95 | 9599.8 | 1872.85 | 83 | 0 | 1872.85 | 0 |  | data-filter-advanced- criteria in S1:S2  why it not working.
 | NESTLEIND | INE239A01016 | 2018-02-28 | 2018-05-22 | 3 | 23180.85 | 28799.4 | 5618.55 | 83 | 0 | 5618.55 | 0 |  | DESTINATION-P15.
 | HINDUNILVR | INE030A01027 | 2018-02-23 | 2018-05-24 | 15 | 19860 | 23380.5 | 3520.5 | 90 | 0 | 3520.5 | 0
 | HINDUNILVR | INE030A01027 | 2018-02-23 | 2018-05-24 | 5 | 6620 | 7793.5 | 1173.5 | 90 | 0 | 1173.5 | 0
 | BRITANNIA | INE216A01030 | 2018-02-14 | 2018-05-24 | 3 | 14304.3 | 17103 | 2798.7 | 99 | 0 | 2798.7 | 0
 | BRITANNIA | INE216A01030 | 2018-02-14 | 2018-05-24 | 2 | 9536.2 | 11402 | 1865.8 | 99 | 0 | 1865.8 | 0
 | BRITANNIA | INE216A01030 | 2018-02-14 | 2018-05-24 | 5 | 23840.5 | 28505 | 4664.5 | 99 | 0 | 4664.5 | 0
 | PIDILITIND | INE318A01026 | 2018-02-15 | 2018-05-24 | 10 | 8870 | 10830.5 | 1960.5 | 98 | 0 | 1960.5 | 0
 | DHFL | INE202B01012 | 2018-02-14 | 2018-06-20 | 5 | 2750 | 3132.25 | 382.25 | 126 | 0 | 382.25 | 0
 | DABUR | INE016A01026 | 2018-02-27 | 2018-06-20 | 10 | 3300 | 3799.5 | 499.5 | 113 | 0 | 499.5 | 0
 | VIPIND | INE054A01027 | 2018-03-12 | 2018-06-20 | 10 | 3210 | 4316 | 1106 | 100 | 0 | 1106 | 0
 | BATAINDIA | INE176A01028 | 2018-03-01 | 2018-06-20 | 20 | 14480 | 16832 | 2352 | 111 | 0 | 2352 | 0
 | BATAINDIA | INE176A01028 | 2018-03-16 | 2018-06-20 | 6 | 4257.9 | 5049.6 | 791.7 | 96 | 0 | 791.7 | 0
 | BATAINDIA | INE176A01028 | 2018-03-16 | 2018-06-20 | 14 | 9935.1 | 11782.4 | 1847.3 | 96 | 0 | 1847.3 | 0
 | ASIANPAINT | INE021A01026 | 2018-02-14 | 2018-07-03 | 10 | 11307 | 13000 | 1693 | 139 | 0 | 1693 | 0
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Mar3-Mar9p

Pavilion
 | 2013-03-03 00:00:00 |  |  | Thru | 2013-03-09 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-03-03 00:00:00 | 2013-03-04 00:00:00 | 2013-03-05 00:00:00 | 2013-03-06 00:00:00 | 2013-03-07 00:00:00 | 2013-03-08 00:00:00 | 2013-03-09 00:00:00 |  |  |  | Blocks | Team | Hours
7:15AM |  |  |  |  |  |  |  | 7:15AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
8:15AM |  |  |  |  |  |  |  | 8:15AM |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
9:15AM |  |  |  |  |  |  |  | 9:15AM |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:15AM |  |  |  |  |  |  |  | 10:15AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:15AM |  |  |  |  |  |  |  | 11:15AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:15PM |  |  |  |  |  |  |  | 12:15PM
1:15PM |  |  |  |  |  |  |  | 1:15PM
2:15PM |  |  |  |  |  |  |  | 2:15PM
3:15PM |  |  |  |  |  |  |  | 3:15PM
4:15PM |  |  |  |  |  |  |  | 4:15PM
5:15PM |  |  |  |  |  |  |  | 5:15PM
[NAME] |  |  |  |  |  |  |  | [NAME]
7:15PM |  |  |  |  |  |  |  | 7:15PM
8:15PM |  |  |  |  |  |  |  | 8:15PM
9:15PM |  |  |  |  |  |  |  | 9:15PM
10:15PM |  |  |  |  |  |  |  | 10:15PM
11:15PM |  |  |  |  |  |  |  | 11:15PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 889654d1740562435-calculating-pick-errors-with-yes-no-test-pick-data
Sheet: JAN

Pick Code | Required Date | [NAME] | Customer Reference | Customer Name | Pick Type | [NAME] | Pick Lines | Pick Units | Pick Cases | [NAME] By | YES/NO | ERROR Units | SKU
PICK003840 | 2024-09-24 00:00:00 | 98891395 |  | PulseSync Labs | Full Pallet | 2024-09-23 13:02:00 | 1 | 3456 | 956 | [NAME] | NO
PICK003448 | 2024-09-03 00:00:00 | 98894253 |  | Nexora Technologies | Case/Unit | 2024-09-02 15:09:00 | 54 | 34320 | 2860 | [NAME] | NO
PICK003472 | 2024-09-05 00:00:00 | 98894254 |  | Evercore Innovations | Case/Unit | 2024-09-04 11:47:00 | 32 | 7488 | 1248 | [NAME] | NO
PICK003473 | 2024-09-05 00:00:00 | 98894255 |  | Vertex Dynamics | Full Pallet | 2024-09-04 10:41:00 | 1 | 7488 | 1248 | [NAME] | NO
PICK003474 | 2024-09-05 00:00:00 | 98894256 |  | BlueHorizon Enterprises | Full Pallet | 2024-09-04 13:51:00 | 1 | 4160 | 1040 | Ava Sinclair | NO
PICK003452 | 2024-09-04 00:00:00 | 98894799 |  | Luminex Solutions | Case/Unit | 2024-09-01 13:10:00 | 2 | 522 | 84 | [NAME] | NO
PICK003453 | 2024-09-04 00:00:00 | 98894800 |  | Skyline Ventures | Full Pallet | 2024-09-02 15:09:00 | 1 | 4160 | 1040 | [NAME] | NO
PICK003454 | 2024-09-04 00:00:00 | 98894801 |  | PulseSync Labs | Case/Unit | 2024-09-18 13:12:00 | 17 | 57 | 9 | [NAME] | YES | 4 | 542441
PICK003455 | 2024-09-04 00:00:00 | 98894802 |  | NovaFusion Industries | Full Pallet | 2024-09-02 14:24:00 | 1 | 7488 | 1248 | [NAME] | NO
PICK003840 | 2024-09-24 00:00:00 | 98894803 |  | PulseSync Labs | Full Pallet | 2024-09-23 13:02:00 | 1 | 3456 | 956 | [NAME] | YES | 4 | 542441
PICK003448 | 2024-09-03 00:00:00 | 98894804 |  | Nexora Technologies | Case/Unit | 2024-09-02 15:09:00 | 54 | 34320 | 2860 | [NAME] | NO
PICK003472 | 2024-09-05 00:00:00 | 98894805 |  | Evercore Innovations | Case/Unit | 2024-09-04 11:47:00 | 32 | 7488 | 1248 | [NAME] | YES | 120 | 478477
PICK003473 | 2024-09-05 00:00:00 | 98894806 |  | Vertex Dynamics | Full Pallet | 2024-09-04 10:41:00 | 1 | 7488 | 1248 | [NAME] | NO
PICK003474 | 2024-09-05 00:00:00 | 98894807 |  | BlueHorizon Enterprises | Full Pallet | 2024-09-04 13:51:00 | 1 | 4160 | 1040 | Ava Sinclair | NO
PICK003452 | 2024-09-04 00:00:00 | 98894808 |  | Luminex Solutions | Case/Unit | 2024-09-01 13:10:00 | 2 | 522 | 84 | [NAME] | NO
PICK003453 | 2024-09-04 00:00:00 | 98894809 |  | Skyline Ventures | Full Pallet | 2024-09-02 15:09:00 | 1 | 4160 | 1040 | [NAME] | YES | 10 | 558745
PICK003454 | 2024-09-04 00:00:00 | 98894810 |  | PulseSync Labs | Case/Unit | 2024-09-18 13:12:00 | 17 | 57 | 9 | [NAME] | NO
PICK003455 | 2024-09-04 00:00:00 | 98894811 |  | NovaFusion Industries | Full Pallet | 2024-09-02 14:24:00 | 1 | 7488 | 1248 | [NAME] | NO
Spreadsheet: 866800d1713719349-trying-to-return-a-value-using-xlookup-and-match-from-a-price-table-mtm-customer-order-form-with-prices-ef
Sheet: Sheet1

made to measure order form
Account No. |  |  |  |  |  |  |  |  | Date of order
Account Name
Account Address |  |  |  |  |  |  |  |  | Customer order ref
Contact Name
Contact Number
Contact Email
Product | [NAME] | Height | Frame colour | Mesh type | Reinforced pull bar | Magnetic closure | Brackets | Fixing holes | Guides | Quantity | Price
Window Screen | 800 | 1200 | White | Standard | Yes | Yes | Face fix | Face Fix | 40mm | 1
 |  |  |  |  |  |  |  | Total number of screens on this order
Spreadsheet: 0541a298-fd4d-4eec-a551-f7cb7c3c7c7f
Sheet: Sheet1

AUTOMATED CACFP MONTHLY LEDGER | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
FOR THE MONTH/YEAR OF: |  |  |  |  | 2008-05-01 00:00:00
All expenses listed in the ledger below should relate directly to the Food Program.
 | CACFP ADMINISTRATIVE AND OPERATIONAL LABOR COSTS |  |  |  |  |  | TOTAL
CACFP Administrative hours this month = |  |  | 20 |  | X  Wage per Hour | 10 | 200
COOK WAGES: Total hours this month = |  |  | 60 |  | X  Wage per Hour | 6.5 | 390
# Teachers performing CACFP tasks 1 hr. per day= |  | 5 | X WAGES | 5.5 | X # working days in mo | 22 | 605
 |  | # GALLONS OF MILK PURCHASED |  | CACFP FOOD PROGRAM ITEMS |  | NON-FOOD PROGRAM ITEMS | Instructions: Enter the month/year in the corresponding area. Enter average hours and wage per hour for CACFP Administrative hours, cooks wages and teachers.The table will automatically calculate the administrative and operational labor costs for the month; once done, they should be pretty standard for each month. Number of working days in the month- this number will need to be entered each month. For each CACFP purchase made, enter the date of the purchase, the purchase place, the number of gallons of milk purchased, if any, and the amount of food and non-food program items purchased in the appropriate columns. Table will automatically calculate the totals for the month and enter them in the proper row. Reimbursement for the month- manually enter total from the monthly reimbursement  claim. See optional Milk Calculation Form to assist in calculating milk needed for meals served.
DATE | PURCHASE PLACE
2008-05-02 00:00:00 | Costco | 20 |  | 80.99
2005-05-12 00:00:00 | Costco | 16 |  | 368.29 |  | 22
2005-05-19 00:00:00 | Smith's | 16 |  | 250.68 |  | 15.68
2008-05-21 00:00:00 | Albertson's | 13 |  | 189.56
2008-05-25 00:00:00 | [NAME]'s | 13 |  | 75.08 |  | 10.07
 | TOTALS                                                               $ | 78 |  |  | 964.6 | 47.75 | 1195
(See optional milk calculation form) |  |  |  |  | (a) | (b) | ( c)
 |  |  |  | Total food divided by reimbursement = |  |  | 0.5391839016210174
TOTAL FOOD & NON FOOD PROGRAM EXPENSES |  |  |  | 1012.35 | (a) + (b)
TOTAL LABOR EXPENSES |  |  |  | 1195 | ( c)
TOTAL FOOD PROGRAM EXPENSES |  |  |  | 2207.35 | (a) + (b) + ( c)
*REIMBURSEMENT FOR THE MONTH |  |  |  | 1789 | (From monthly claim)
*REIMBURSEMENT SHOULD ONLY BE SPENT FOR FOOD PROGRAM EXPENSES |  |  |  |  |  |  | revised/aprvd  4/28/08
Spreadsheet: 153226d1335808828-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: dec 5

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2011-12-05 00:00:00 | 2011-12-06 00:00:00 | 2011-12-07 00:00:00 | 2011-12-08 00:00:00 | 2011-12-09 00:00:00 | 2011-12-10 00:00:00
[NAME] | off | 9:30-5:30 | 8:00-5:00 | 8:00-5:00 | 8:30-5:30 | 9:15-5:15
 |  | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00
[NAME] | 8:30-5:30 | 8:30-5:30 | 9:30-5:30 | 8:30-5:30 | 9:30-5:30 | off
 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-4:00 | 7:00-4:00 | 8:00-4:00 | off
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00
Mark | 8:00-5:00 | 9:00-4:00 | 8:30-5:30 | 8:30-5:30 | off | 9:00-5:00
 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 |  | 1:00-2:00
[NAME] | 8:30-5:30 | off | 8:30-5:30 | 7:00-4:00-HOMER | 8:00-5:00 | 9:15-5:15-ctr
ctr 12-2 | 11:00-12:00 | off | 11:00-12:00 | 1ub | 11:00-12:00 | 11:00-12:00
Kat |  |  | 8:00-5:00 |  |  | 9:15-5:15
 |  |  | 12:00-1:00 |  |  | 12:00-1:00
 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours
Spreadsheet: 39667d1237943684-macro-to-group-rows-needed-sample
Sheet: Sheet1

AFTER |  |  |  |  |  | BEFORE
COUSTOMER NAME | ACCT NUMBER |  |  |  |  | COUSTOMER NAME | ACCT NUMBER
ALRENO SEBASTIAN | 1234 |  |  |  |  | ALRENO SEBASTIAN | 1234
ALRENO SEBASTIAN | 1235 |  |  |  |  | ALRENO SEBASTIAN | 1235
ALRENO SEBASTIAN | 1236 |  |  |  |  | ALRENO SEBASTIAN | 1236
CHARLENE BERGLEY | 1237 |  |  |  |  | CHARLENE BERGLEY | 1237
CHARLENE BERGLEY | 1238 |  |  |  |  | CHARLENE BERGLEY | 1238
CHARLENE BERGLEY | 1239 |  |  |  |  | CHARLENE BERGLEY | 1239
JILL WALKER | 1240 |  |  |  |  | JILL WALKER | 1240
JILL WALKER | 1241 |  |  |  |  | JILL WALKER | 1241
JILL WALKER | 1242 |  |  |  |  | JILL WALKER | 1242
[NAME] | 1243 |  |  |  |  | [NAME] | 1243
[NAME] | 1244 |  |  |  |  | [NAME] | 1244
[NAME] | 1245 |  |  |  |  | [NAME] | 1245
[NAME] | 1246 |  |  |  |  | [NAME] | 1246
[NAME] | 1247 |  |  |  |  | [NAME] | 1247
[NAME] | 1248 |  |  |  |  | [NAME] | 1248
[NAME] | 1249 |  |  |  |  | [NAME] | 1249
[NAME] | 1250 |  |  |  |  | [NAME] | 1250
[NAME] | 1251 |  |  |  |  | [NAME] | 1251
[NAME] | 1252 |  |  |  |  | [NAME] | 1252
KRISTI CRAVENS | 1253 |  |  |  |  | KRISTI CRAVENS | 1253
KRISTI CRAVENS | 1254 |  |  |  |  | KRISTI CRAVENS | 1254
KRISTI CRAVENS | 1255 |  |  |  |  | KRISTI CRAVENS | 1255
[NAME] | 1256 |  |  |  |  | [NAME] | 1256
[NAME] | 1257 |  |  |  |  | [NAME] | 1257
[NAME] | 1258 |  |  |  |  | [NAME] | 1258
NICK SMITH | 1259 |  |  |  |  | NICK SMITH | 1259
NICK SMITH | 1260 |  |  |  |  | NICK SMITH | 1260
NICK SMITH | 1261 |  |  |  |  | NICK SMITH | 1261
PEDRO MARTINEZ | 1262 |  |  |  |  | PEDRO MARTINEZ | 1262
PEDRO MARTINEZ | 1263 |  |  |  |  | PEDRO MARTINEZ | 1263
PEDRO MARTINEZ | 1264 |  |  |  |  | PEDRO MARTINEZ | 1264
PEDRO MARTINEZ | 1265 |  |  |  |  | PEDRO MARTINEZ | 1265
PRINCESS LEWIS | 1266 |  |  |  |  | PRINCESS LEWIS | 1266
PRINCESS LEWIS | 1267 |  |  |  |  | PRINCESS LEWIS | 1267
PRINCESS LEWIS | 1268 |  |  |  |  | PRINCESS LEWIS | 1268
SHERRY MERRIETTE | 1269 |  |  |  |  | SHERRY MERRIETTE | 1269
SHERRY MERRIETTE | 1270 |  |  |  |  | SHERRY MERRIETTE | 1270
SHERRY MERRIETTE | 1271 |  |  |  |  | SHERRY MERRIETTE | 1271
Spreadsheet: 767232d1644345903-splitting-commission-and-revenue-between-two-sales-reps-revenue-example
Sheet: Summary

Inside Reps | ABCPass Product | ABCPass Plus Product | Tolls Only Product | [NAME] | Revenue |  |  |  |  |  | Rate of Commission
[NAME] |  |  |  |  |  |  |  |  |  | ABCPass Product | 17.65
Christina Applewood |  |  |  |  |  |  |  |  |  | ABCPass Plus Product | 23.15
ABC Doe |  |  |  |  |  |  |  |  |  | Tolls Only Product | 8.5
[NAME]
[NAME]
Outside Reps | ABCPass Product | ABCPass Plus Product | Tolls Only Product | [NAME] | Revenue
[NAME]
[NAME]
Ox Gray
Bla bla bla