tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30156__SitheFRED
Sheet: FDetail

TAGG | Counterparty | Amount
N38268.Y | FT-CENTRAL | 707788.6815000001
NQ0188.1 | NG-PRICE | -71300
NQ9049.1 | NG-PRICE | -64325
NQ9129.1 | NG-PRICE | 59675
NQ9283.1 | NG-PRICE | -59675
NS9352.1 | FT-INTRA-ONT | -126533.94
NS9483.1 | FT-INT-CEN-MKT | 156850.08
NX8240.2 | FT-CENTRAL | -670562.7824
N38268.Y | FT-CENTRAL | -0.0185
NS2550.1 | FT-ONTARIO | -0.124
NS2581.1 | FT-INT-CEN-MKT | -49599.876
NS6767.1 | FT-ONTARIO | -0.155
NS9352.1 | FT-INTRA-ONT | -0.0649
NS9483.1 | FT-INT-CEN-MKT | -26141.6146
NU2631.1 | FT-INT-CEN-MID | -8768.3894
NU2631.2 | FT-INT-CEN-MID | -3249.9375
NU2631.3 | FT-INTRA-GULF2 | -11699.169
NX8240.2 | FT-CENTRAL | 0.0176
N38268.Y | FT-CENTRAL | 14822.7815
NS2550.1 | FT-ONTARIO | 27900
NS2581.1 | FT-INT-CEN-MKT | -27900
NS6767.1 | FT-ONTARIO | 11625
NS9352.1 | FT-INTRA-ONT | 51911.2951
NS9483.1 | FT-INT-CEN-MKT | -84960.39460000001
NX8240.2 | FT-CENTRAL | -14043.1824
Spreadsheet: 107846d1305002190-formula-for-conditional-formatting-ehls-master-list-template-final
Sheet: Locality 1

Master List - for consenting families            Site: |  |  |  |  |  |  |  | Locality:
The Master List form is to be completed for families who provide verbal consent to participate in the study.
Instructions: |  |  |  |  |  |  |  | Day and Time of Locality:
Record the details of families verbally consenting to be part of the study.
Forward to the PRC at [EMAIL] once you have a complete group list for a locality.
We will commence pre-group assessments 4 weeks before the start of term. For this reason, we would prefer to receive group lists by _________________ to give us time to book and complete assessments.
Less than ideal would be ____________. If you need more time please contact PRC to discuss.
Age Cutoffs (as at 1st day of term)
MCH | Min = 5 months, 14 days; [NAME] = 14 months, 0 days
SPG | Min = 11 months, 14 days; [NAME] = 38 months, 0 days
 | Please Specify platform here: |  | SPG | (NOTE: If child is out of the age range, the "Age" cell will change to red)
**Please note the Participant ID must always remain with the same participant for the duration of the study. If they withdraw or anything changes, please make a note in the comments and resubmit to EHLS
For Participants beginning Term/Year: |  |  | Term 3 |  | (please specify)
Family ID | Parent's First Name | Parent's Last Name | Date of verbal consent | Child's name | Child's DOB | Age (as at 18/7/11 in months) | Child's Gender | Address | Suburb | Postcode | Home Phone | [NAME] | Comments from Site | Site | Locality | Locality Condition
xxxxx000 | [NAME] | Smith | 2010-11-15 00:00:00 | [NAME] | 2008-05-02 00:00:00 |  | Male | 23 [NAME] | Bendigo | 3901 | 03 8683 1234 | 0456 123 456 | Eg. Phone was incorrect, now correct; or [NAME] out etc | Bendigo | Long Gully | smalltalk plus
 |  |  |  |  |  | 2011-07-18 00:00:00
Spreadsheet: 41725d1240259898-finding-the-last-value-in-a-week-from-daily-data-test2-1-
Sheet: Front Month

Date | Price | Last Number from the week
 |  |  |  | weekday | Price | Last price from week before
2009-04-20 00:00:00 | 5031 | 5137 |  |  | 5031 |  |  | <- did the following manually to show example
2009-04-17 00:00:00 | 5137 | 5245 |  |  | 5137
2009-04-16 00:00:00 | 5048 | 5245 |  |  | 5048
2009-04-15 00:00:00 | 5079 | 5245 |  |  | 5079
2009-04-14 00:00:00 | 5112 | 5245 |  |  | 5112
2009-04-13 00:00:00 | 5215 | 5245 |  |  | 5215
2009-04-09 00:00:00 | 5245 | 5390 |  |  | 5245 |  |  | <- notice this week only had 4 days due to holiday
2009-04-08 00:00:00 | 5130 | 5390 |  |  | 5130
2009-04-07 00:00:00 | 5182 | 5390 |  |  | 5182
2009-04-06 00:00:00 | 5360 | 5390 |  |  | 5360
2009-04-03 00:00:00 | 5390 | 5428 |  |  | 5390
2009-04-02 00:00:00 | 5287 | 5428 |  |  | 5287
2009-04-01 00:00:00 | 4896 | 5428 |  |  | 4896
2009-03-31 00:00:00 | 4994 | 5428 |  |  | 4994
2009-03-30 00:00:00 | 5225 | 5428 |  |  | 5225
2009-03-27 00:00:00 | 5428 | 5428 |  |  | 5428
2009-03-26 00:00:00 | 5466 |  |  |  | 5466
2009-03-25 00:00:00 | 5418 |  |  |  | 5418
2009-03-24 00:00:00 | 5406 |  |  |  | 5406
2009-03-23 00:00:00 | 5405 |  |  |  | 5405
2009-03-20 00:00:00 | 5272 |  |  |  | 5272
2009-03-19 00:00:00 | 5298 |  |  |  | 5298
2009-03-18 00:00:00 | 5060 |  |  |  | 5060
2009-03-17 00:00:00 | 5060 |  |  |  | 5060
2009-03-16 00:00:00 | 4829 |  |  |  | 4829
2009-03-13 00:00:00 | 4890 |  |  |  | 4890
2009-03-12 00:00:00 | 4818 |  |  |  | 4818
2009-03-11 00:00:00 | 4724 |  |  |  | 4724
Spreadsheet: 124562d1318463593-excel-2007-4-columns-need-to-match-2-cattle-samp
Sheet: Sheet1

Cow Tag | Birth Date | [NAME] | Weaning Wght
1 | 2011-03-06 00:00:00 | 1 | 600
2 | 2011-03-08 00:00:00
3 | 2011-03-09 00:00:00 | 3 | 540
4 | 2011-03-11 00:00:00 | 8 | 555
5 | 2011-03-07 00:00:00 | 10 | 550
6 | 2011-03-10 00:00:00 | 6 | 525
7 | 2011-03-14 00:00:00 | 4 | 515
8 | 2011-03-13 00:00:00 | 9 | 510
9 | 2011-03-12 00:00:00 | 5 | 530
10 | 2011-03-15 00:00:00
Spreadsheet: 865268d1712315493-ignoring-certain-cells-in-average-formule-forum-test
Sheet: Sheet1

Team member | Customers | Sales | %
Agent 1 | 15 | 5 | 0.3333
Agent 2 | 20 | 4 | 0.2
Agent 3 | 42 | 2 | 0.0476
Agent 4 | 32 | 0 | 0 |  | <---- Need to include this 0.00%  as Agent 4 is working
Agent 5 | 50 | 4 | 0.08
Agent 6 | 0 | 0 | 0 |  | <----Need to EXCLUDE this 0.00% as Agent 6 is not working
Total | 159 | 15 | 0.0943
Average | 0.1102
Spreadsheet: 87776d1287625897-count-a-number-in-one-column-only-for-specfic-input-in-adjacent-column-brichacek
Sheet: RP Analysis

Rhinoplasty | Number (n) | Average time (min) | Median time (min) | Minimum time (min) | Maximum time (min)
 | 5
 | Terrible (1) | [NAME] (2) | Bad (3) | Avearge (4) | Good (5) | Very Good (6) | Excellent (7)
Question #2 (n) | 0
Question #2 (%)
Question #2 (average)
Question #2 (median)
 | Terrible (1) | [NAME] (2) | Bad (3) | Avearge (4) | Good (5) | Very Good (6) | Excellent (7)
Question #3 (n)
Question #3 (%)
Question #3 (average)
Question #3 (median)
 | Terrible (1) | [NAME] (2) | Bad (3) | Avearge (4) | Good (5) | Very Good (6) | Excellent (7)
Question #4 (n)
Question #4 (%)
Question #4 (average)
Question #4 (median)
 | Terrible (1) | [NAME] (2) | Bad (3) | Avearge (4) | Good (5) | Very Good (6) | Excellent (7)
Question #5 (n)
Question #5 (%)
Question #5 (average)
Question #5 (median)
 | Not Helpful (1) | Minimally Helpful (2) | [NAME] (3) | Very Helpful (4) | Extremely Helpful (5)
Question #6 (n)
Question #6 (%)
Question #6 (average)
Question #6 (median)
 | Yes (y) | No (n) | Other (o)
Question #7 (n)
Question #7 (%)
Spreadsheet: 788733d1658674151-copy-2-different-tables-form-one-file-to-different-sheets-in-a-new-file-output-file
Sheet: Sheet1

 | 325 |  |  | P2 | 19 |  |  | BATCH NOS |  | 8
 |  |  |  | M | T | W | TR | F | ST | SN
 | 09:00:00 | 10:30:00 | 1
 | 10:45:00 | 12:15:00 | 2 | SBP 12 | 02M1 |  | 02M1 | 02M1
 | 12:30:00 | 14:00:00 | 3 | SBP 12 | 02M1 |  | MR03 | MR03 | MR06
 | 14:30:00 | 16:00:00 | 4
 | 16:15:00 | 17:45:00 | 5 | 02M7 | 02M7 |  | 02M7 | 02M5 | 02M5
 | 18:00:00 | 19:30:00 | 6 | 02M6 | 02M5 |  | 02M6 | 02M6 | 02M6
 |  |  |  | 4 | 4 | 0 | 4 | 4 | 3 | 0
Spreadsheet: 140600d1328814225-find-friday-on-which-maximum-number-of-widgits-occurred-maxdatemahju
Sheet: Sheet1

Friday | Widgits |  | Two named ranges:  Friday, and Widgits
2010-01-01 00:00:00 | 64 |  | I already have the formula for finding the largest number of widgets.
2010-01-08 00:00:00 | 200 |  | Need formula for getting the date when the largest number of widgets occurred.
2010-01-15 00:00:00 | 57
2010-01-22 00:00:00 | 88 |  | The largest number of widgits | 200 | {=MAX(IF(ISNA(Widgits),0,Widgits)))       (ARRAY FORMULA)
2010-01-29 00:00:00 | 79 |  | Occurred on | 2010-01-08 00:00:00
2010-02-05 00:00:00 | 92
2010-02-12 00:00:00 | 86
2010-02-19 00:00:00 | 50
2010-02-26 00:00:00 | 100
2010-03-05 00:00:00
2010-03-12 00:00:00 | #N/A
2010-03-19 00:00:00 | #N/A
2010-03-26 00:00:00 | #N/A
2010-04-02 00:00:00 | #N/A
2010-04-09 00:00:00 | #N/A
2010-04-16 00:00:00 | #N/A
2010-04-23 00:00:00 | #N/A
2010-04-30 00:00:00 | #N/A
2010-05-07 00:00:00 | #N/A
2010-05-14 00:00:00 | #N/A
2010-05-21 00:00:00 | #N/A
2010-05-28 00:00:00 | #N/A
2010-06-04 00:00:00 | #N/A
2010-06-11 00:00:00 | #N/A
2010-06-18 00:00:00 | #N/A
2010-06-25 00:00:00 | #N/A
Spreadsheet: 144725d1331118270-populate-various-worksheets-from-master-worksheet-testing
Sheet: GARRY CLIFTON

GARRY CLIFTON
Date | Item | Amount
#N/A | 5 appliances | 3500
#N/A | 5 appliances | 3500
#N/A | 2 bedrooms | 4300
#N/A | #N/A | #N/A
#N/A | 2 dinning rooms | 6100
#N/A | 2 dinning rooms | 6100
Spreadsheet: 219950d1363020105-how-to-use-an-array-to-get-the-complex-calculation-work-how-to-calculate-error-variance-using-an-array
Sheet: Sheet1

Intercept
Slope
Y | X | Const |  | Predicted value | Error | Error square
1 | 2 | 0.5
2 | 4 | 0.7
3 | 3 | 0.8
 | 5
4 | 8 | 0.4
5 |  | 0.7
6 | 11 | 0.9
7 | 17 | 0.1
8 | 20 | 0.4
9 | 8 | 0.8
 | 4 | 0.4
 |  |  |  |  |  |  |  | One single step:
Spreadsheet: 22970d1212213984-identify-missing-values-test
Sheet: Sheet1

# | ABC |  |  |  |  | A | B | C
1 | C
2 | B
3 | B
4 | C
5 | C
6 | B | 5
7 | C | 5
8 | A | 5
9 | C | 5
10 | C | 5
11 | A | 5
12 | A | 5
13 | A | 5
14 | B | 5
15 | A | 5
16 | A | 5
17 | C | 5
18 | C | 5
19 | B | 5
20 | C | 5
Spreadsheet: 844504d1696281194-take-and-filter-function-take-row-and-exlude-certain-columns-take-and-filter-function
Sheet: Sheet1

 | 0-30 | 031-60 | 061-90 | 091-120 | 121-150 | 151-180 | 181-270 | 271-365 | 366+ | Grand Total | Not this Cell | >90 | 151+
 |  | 031-60 | 061-90 | 091-120 | 121-150 | 151-180 | 181-270 | 271-365 | 366+ | Grand Total | Not this Cell | >90 | 151+
Spreadsheet: 70073d1270734682-combining-spreadsheet-data-book1
Sheet: Sheet2

ClientID_Value | Area | Last Visited | Street | Town | Post Code
12858 | Cardiff | 2010-03-30 00:00:00 | A Place | A Town | AC 12
12857 | Cardiff | 2010-03-19 00:00:00 | B Place | B Town | AB 23
12852 | Cardiff | 2010-03-30 00:00:00 | C Place | C Town | CB 34
12843 | Cardiff | 2010-03-29 00:00:00 | A Place | A Town | AC 13
12841 | Cardiff | 2010-03-29 00:00:00 | B Place | B Town | AB 24
12830 | Cardiff | 2010-03-28 00:00:00 | C Place | C Town | CB 35
12827 | Swansea | 2010-03-26 00:00:00 | A Place | A Town | AC 14
12827 | Swansea | 2010-03-26 00:00:00 | B Place | B Town | AB 25
12820 | Swansea | 2010-03-26 00:00:00 | C Place | C Town | CB 36
12815 | Cardiff | 2010-03-25 00:00:00 | A Place | A Town | AC 15
12810 | Cardiff | 2010-03-25 00:00:00 | B Place | B Town | AB 26
12809 | Cardiff | 2010-03-25 00:00:00 | C Place | C Town | CB 37
12808 | Swansea | 2010-03-24 00:00:00 | A Place | A Town | AC 16
12808 | Swansea | 2010-03-24 00:00:00 | B Place | B Town | AB 27
12800 | Swansea | 2010-03-24 00:00:00 | C Place | C Town | CB 38
12797 | Swansea | 2010-03-24 00:00:00 | A Place | A Town | AC 17
12796 | Swansea | 2010-03-24 00:00:00 | B Place | B Town | AB 28
12795 | Cardiff | 2010-03-24 00:00:00 | C Place | C Town | CB 39
12792 | Cardiff | 2010-03-24 00:00:00 | A Place | A Town | AC 18
12789 | Swansea | 2010-03-24 00:00:00 | B Place | B Town | AB 29
12789 | Swansea | 2010-03-24 00:00:00 | C Place | C Town | CB 40
12786 | Cardiff | 2010-03-23 00:00:00 | A Place | A Town | AC 19
12784 | Cardiff | 2010-03-23 00:00:00 | B Place | B Town | AB 30
Spreadsheet: 705628d1606234517-return-the-next-value-in-a-list-after-a-specific-value-is-found-help-find-the-next-value-in-a-list-after-sa_2
Sheet: Help Needed (2)

 | Goal:
 | I'm in need of a formula that can sum values within a defined region (while omitting any rows that have values in column "B" and column "D"). The formula should first find/identify the next value in column "B" where the values indicate the end of the summing region (while also indicating the start of the next summing region). For example letters are used are ("T", "h", "S", "SG", or "SA".)
 | Summing Category Logic
 | ITEM |  | LETTER USED | STOP SUMMING AT | Values Omitted Column "B" | Values Omitted Column "D"
 | Category Title |  | "T" | T | h, S, SG, SA | V or X
 | Section Header |  | "h" | T or h | S, SG, SA | V or X
 | Sub-Category |  | "S" | any value:  T, h, S, SG, SA | none | V or X
 | Grouped Sub-Category Header |  | "SG" | T or h or S or SG | SA | V or X
 | Grouped Sub-Category |  | "SA" | any value: T, h, S, SG, SA | none | V or X
 | Item to Note:
 | My formula in column "I" is incomplete. Currently I am unable to solve summing the "SG" category. I'm not sure how to identify which letter comes first after "SA" (which could be a variation of "T", "h", "S", or "SG"). Then based on which letter comes first, the formula would sum up to that letter.
 | To condense my formula, I added an extra row at the bottom of my sum list to include an "h". In my formual this solve any situation where a "h" is the last summing category before a "T".
 | [NAME] | Helper Row | Variables to omit | Titles and Line Items |  | Manually calculated results |  | My [NAME] (So far…) I plan to put it into the yellow cells in column J
 | T |  |  | Company Supplies -
 | h |  |  | Marketing Supplies:
 | s |  |  | Event Supplies:
 |  |  |  |  | Computers | 200
 |  |  | V |  | [NAME] | 100
 |  |  |  |  | Software | 200
 | SG |  |  | Event Supplies for Online Events: |  |  |  |  | << My [NAME] so far doesn't work with "SG". I need it to sum down to the next value after "SA". The next value can be either T, h, S, or SG (in no particular order).
 | SA |  |  | Online Event AAA:
 |  |  |  |  | Line item for Event AAA | 200
 |  |  |  |  | Line item for Event AAA | 200
 |  |  | X |  | Line item for Event AAA | 200
 | SA |  |  | Online Event BBB:
 |  |  |  |  | Line item for Event BBB | 200
 |  |  | X |  | Line item for Event BBB | 200
 |  |  |  |  | Line item for Event BBB | 200
 | h |  |  | Operation Supplies:
 | S |  |  | Office Supplies:
 |  |  |  |  | Tables | 100
 |  |  |  |  | Chairs | 100
 |  |  | V |  | Pens | 100
 | SG |  |  | USA Offices:
 | SA |  |  | NYC Office:
 |  |  |  |  | Line item for NYC Office | 200
 |  |  | V |  | Line item for NYC Office | 200
 |  |  |  |  | Line item for NYC Office | 200
 | SA |  |  | Boston Office:
 |  |  |  |  | Line item for Boston Office | 200
 |  |  | X |  | Line item for Boston Office | 200
 |  |  |  |  | Line item for Boston Office | 200
 | H |  |  | End of Sheet
 | T |  |  | End of Sheet
Spreadsheet: 753931d1635845350-google-sheets-is-it-possible-to-add-data-to-another-sheet-from-a-filtered-view-example-workbook
Sheet: Clients

 |  | Client: | Client B
Name | Date | Order # | Docs Link | Order details link | Manager
 |  |  | http://docs.gogole.com/ | http://sheets.google.com/
 |  |  | http://docs.gogole.com/ | http://sheets.google.com/
 |  |  | http://docs.gogole.com/ | http://sheets.google.com/
 |  |  | http://docs.gogole.com/ | http://sheets.google.com/
 |  |  | http://docs.gogole.com/ | http://sheets.google.com/
 |  |  | http://docs.gogole.com/ | http://sheets.google.com/
 |  |  |  |  |  | Is it possible to enter data in these rows and have them permanently be added to the 'Data' sheet?
 |  |  |  |  |  | So I add a new name and info for Client B on this sheet, then I can filter back and forth between the clients and get the new data each time
Spreadsheet: 694925d1599898557-how-to-add-the-maximum-number-of-different-products-in-merged-cells-sample0912
Sheet: Sheet3

DATE | product | Inbound quantity
 | rearview mirror | 154 |  |  | 1302 | The sum of the maximum number of products in a single storage
 |  | 276 |  |  |  | F2 =MAX(C2:C3)+MAX(C4:C6)+MAX(C7:C12)+MAX(C13)+MAX(C14:C16)+MAX(C17:C18)
 | Tires | 103
 |  | 120
 |  | 134
 | steering wheel | 168
 |  | 179
 |  | 212
 |  | 221
 |  | 270
 |  | 103
 | Seat | 92
 | RADIATOR | 176
 |  | 244
 |  | 262
 | GEAR BOX | 78
 |  | 268
Spreadsheet: tracy_geaccone__40232__enron corp infomation request
Sheet: EES IS

 |  | September
Gross Margin by Business Unit |  | Year-to-Date
Industrial Energy Services
Manufacturing Energy Services
Commercial Energy Services
Acquisition and [NAME]
Regional Market Services
Product Management
[NAME]
Construction Services
Facilities Services
Enron Direct USA |  | 0
EES Europe
EES Canada
Other
Total Gross Margin
Operating Expenses |  | 0
Depreciation and Amortization |  | 0
Taxes Other Than Income |  | 0
Other Income (Loss) |  | 0
 |  | 0
Income / (Loss) Before Interest & Taxes
(3)
Spreadsheet: 81288d1281530123-using-subtotal-with-letters-input-sheet
Sheet: Service input sheet

DOMESTIC INPUT SHEETS |  |  |  |  |  |  |  |  |  | Totals
Address | Post Code | Operative Assessed | Gas Safe Number | Type Of work | Id Card Shown To Customer | Dustsheets Used | Percentage Score
27 SMITH STREET | PH271ZH | J Smith | 1224 | Service | P | P
test | PH271ZH | J Smith | 1224 | Service | F | P |  |  |  |  |  |  |  |  |  |  | Score
test | PH271ZH | F Jones | 2342 | install | P | P |  |  |  |  |  |  |  |  |  |  | P
test | PH271ZH | F Jones | 2342 | install | P | F |  |  |  |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A
Spreadsheet: 787790d1658050992-how-to-search-target-data-with-multiple-data-sample-data-lookup-serial-number-with-do-number
Sheet: DO History

Delivery No | DO Date | Item No. | Quantity | Serial/Lot Number |  | Right formula | it should be
22-0151/1 | 2022-07-01 00:00:00 | S39224JS | 1
22-0153/1 | 2022-07-04 00:00:00 | DS II M | 1 |  | duplicate | ?? | 220325-031040
22-0153/1 | 2022-07-04 00:00:00 | PAX2C | 1
22-0153/1 | 2022-07-04 00:00:00 | DE-400E | 1 |  | duplicate | ?? | DE40EEHHJ003
22-0153/1 | 2022-07-04 00:00:00 | DE-400E | 1 |  | duplicate | ?? | DE40EEHGD001
22-0153/1 | 2022-07-04 00:00:00 | DT-300S | 1
22-0153/1 | 2022-07-04 00:00:00 | 2000 | 1
22-0153/1 | 2022-07-04 00:00:00 | DS II M | 1 |  | duplicate | ?? | 220325-031038
22-0153/1 | 2022-07-04 00:00:00 | [NAME] | 1 |  | duplicate | ?? | 220325-011545
22-0153/1 | 2022-07-04 00:00:00 | 5016000 | 1 |  | duplicate | ?? | SP22030191
22-0153/1 | 2022-07-04 00:00:00 | DS II M | 1 |  | duplicate | ?? | 220325-031041
22-0042 | 2022-07-05 00:00:00 | [NAME] | 1 |  | duplicate | ?? | 220325-011547
22-0042 | 2022-07-05 00:00:00 | [NAME] | 1 |  | duplicate | ?? | 220325-011549
22-0457 | 2022-07-06 00:00:00 | H48302BA | 1
22-0457 | 2022-07-06 00:00:00 | H40402LY | 1
22-0457 | 2022-07-06 00:00:00 | H4000SR | 1
22-0457 | 2022-07-06 00:00:00 | CT1082B | 1
22-0156/1 | 2022-07-13 00:00:00 | [NAME] | 1 |  | duplicate | ?? | 220325-011548
22-0156/1 | 2022-07-13 00:00:00 | DS II M | 1 |  | duplicate | ?? | 220325-031042
22-0282 | 2022-07-15 00:00:00 | 5016000 | 1 |  | duplicate | ?? | SP22030190
22-0282 | 2022-07-15 00:00:00 | 5030810 | 5 |  | duplicate | ??
22-0283 | 2022-07-15 00:00:00 | DS II M | 1 |  | duplicate | ?? | 220613-031053
22-0283 | 2022-07-15 00:00:00 | OF001 | 1
22-0283 | 2022-07-15 00:00:00 | [NAME] | 1 |  | duplicate | ?? | 220621-011590
Spreadsheet: 491672d1480594678-sort-array-formula-results-in-descending-order-sort-array-formula-results-in-descending-order
Sheet: PS_TRANSPORT PLAN

 | TRANSPORT PLAN
 |  |  |  |  |  |  |  |  |  |  | Date | 2017-02-22 00:00:00 |  | ←1) Enter Date
 |  |  |  |  |  |  |  |  |  |  | Vehicle | Vehicle 2 |  | ←2) [NAME]
I would like these rows to be ordered as ↓ | DELIVERY ORDER | DRIVER | T/PORT | P/CODE | ADDRESS | CLIENT/CUSTOMER | CONTACT NAME | PHONE NO. | [NAME] | QTY | DELIVERY TYPE | DELIVERY RESTRICTIONS | TIME
 | PLEASE RING CUSTOMER BEFORE DELIVERY / COLLECTION
1
1
2
2
3
4
5
Spreadsheet: 757795d1638460734-formula-to-know-if-my-outstanding-items-are-paid-payed-2-
Sheet: All transactions

Company: 1 - Exact
Date: 2 December 2021 by SupportBe Exact
Transactions|G/L Account
G/L Account | 400000 - Customers | Group by |  | After entry | v
Financial year | 2021 | Period | 12 - 12
No. | Per. | Date | Entry no. | Journal | Description | Account | Debit | Credit | Account |  | Paid??
Opening balance |  |  |  |  |  |  | 5140
1 | 12 | 2021-12-02 00:00:00 | 21700007 | 700 - Sales |  | 8 - Schoenenwinkel 1 | 100 |  | BH
2 | 12 | 2021-12-02 00:00:00 | 21700008 | 700 - Sales |  | 9 - Schoenenwinkel 2 | 1200 |  | MM
3 | 12 | 2021-12-02 00:00:00 | 21700009 | 700 - Sales |  | 10 - Schoenenwinkel 3 | 1500 |  | TT
4 | 12 | 2021-12-02 00:00:00 | 21700010 | 700 - Sales |  | 11 - Schoenenwinkel 4 | 300 |  | WW
Total |  |  |  |  |  |  | 8240
Closing balance |  |  |  |  |  |  | 8240
Spreadsheet: bbeb9896-93ae-4acd-92ac-0df4d108baf7
Sheet: Sheet1

Unnamed: 0 | BELKNAP COUNTY OFFICES - Republican | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
2004-09-14 00:00:00 | Sheriff |  | Attorney |  | Treasurer |  | Reg. ofDeeds
 | Collis, r | [NAME] | [NAME], r | [NAME] | Corbin, r | [NAME] | Normandin, r | [NAME]
Alton | 248 |  | 247 |  | 241 |  | 248
Barnstead | 145 | 2 | 152 | 1 | 153 |  | 158
Belmont | 230 | 4 | 223 |  | 222 |  | 234
Center Harbor | 108 |  | 109 |  | 106 |  | 108
Gilford | 395 |  | 390 | 2 | 372 |  | 397
Gilmanton | 142 |  | 139 | 3 | 134 |  | 140
[NAME] | 164 |  | 162 |  | 166 | 1 | 177 | 1
[NAME] | 129 | 1 | 124 | 3 | 133 | 1 | 135 | 1
[NAME] 3 | 109 |  | 105 | 1 | 109 |  | 114
[NAME] | 121 |  | 109 |  | 113 |  | 119
[NAME] | 73 | 2 | 67 |  | 65 |  | 69
[NAME] 6 | 140 |  | 133 | 1 | 141 |  | 141
Meredith | 435 |  | 421 | 1 | 423 |  | 431
New Hampton | 151 | 3 | 147 | 1 | 148 |  | 151
Sanbornton | 132 |  | 127 | 1 | 128 |  | 133
[NAME] | 160 |  | 157 | 1 | 158 |  | 164
TOTALS | 2882 | 12 | 2812 | 15 | 2812 | 2 | 2919 | 2
 |  |  |  | COUNTY COMMISSIONERS
 | Reg. Of Probate |  |  | Dist. 1 |  | District No. 2 |  | District No. 3
 | Brickner, r | [NAME] |  |  | [NAME], r | [NAME], d | [NAME] | Boothby, r | [NAME]
Alton | 240 |  |  | NO ELECTION |  |  |  | 241
Barnstead | 158 |  |  |  | 148 | 0 | 1
Belmont | 220 |  |  |  | 224 | 2
Center Harbor | 106 |  |  |  |  |  |  | 105
Gilford | 358 | 2 |  |  |  |  |  | 345 | 4
Gilmanton | 134 | 1 |  |  | 134
[NAME] | 157 | 1
[NAME] | 122 | 1
[NAME] 3 | 102
[NAME] | 108
[NAME] | 63
[NAME] 6 | 135
Meredith | 428 |  |  |  |  |  |  | 426 | 3
New Hampton | 149 |  |  |  |  |  |  | 142 | 1
Sanbornton | 130 |  |  |  | 125 | 1 | 1
[NAME] | 161 |  |  |  | 161
TOTALS | 2771 | 5 |  |  | 792 | 3 | 2 | 1259 | 8
Spreadsheet: 761272d1640790916-training-past-due-sample-tempering-training-tracker
Sheet: Training Status

HMI [NAME]
 |  | Complete
 |  | 5 | Days from being due
 |  | Past due
Trainee | Trainer | Training On | Start Training Date | Training Time | End Training Date | Supervisor Responsible | Demonstrative Performance Date | Status
[NAME] | [NAME] | CNC-Waterjet | 2021-12-13 00:00:00 |  |  | [NAME] | 2021-12-29 00:00:00
[NAME] | [NAME] | Polish-Manual | 2021-12-14 00:00:00 |  |  | [NAME]
[NAME] | [NAME] | Oven-Small Tam | 2021-09-27 00:00:00 |  |  | [NAME] | 2021-11-02 00:00:00
[NAME] | [NAME] | Cutting-Operator | 2021-12-22 00:00:00 |  |  | [NAME]
[NAME] | [NAME] | Polish-Manual | 2021-11-08 00:00:00 |  |  | [NAME] | 2021-11-23 00:00:00
[NAME] | [NAME] | Wrap-Trim | 2021-12-01 00:00:00 |  |  | [NAME]
[NAME] | [NAME] | CNC-Juniors | 2021-09-27 00:00:00 |  |  | [NAME] | 2021-11-09 00:00:00
[NAME] | [NAME] | Wrap-Trim | 2021-12-21 00:00:00 |  |  | [NAME]
[NAME] | [NAME] | Polish-Manual | 2021-11-04 00:00:00 |  |  | [NAME] | 2021-12-01 00:00:00
[NAME] | [NAME] | Polish-Manual | 2021-12-06 00:00:00 |  |  | [NAME]
[NAME] | [NAME] | Wrap-Trim | 2021-12-21 00:00:00 |  |  | [NAME]
[NAME] | [NAME] | Wrap-Wrapper | 2021-12-21 00:00:00 |  |  | [NAME]
[NAME] | [NAME] | Polish-Manual | 2021-12-13 00:00:00 |  |  | [NAME]
[NAME] | [NAME] | Polish-Manual | 2021-12-13 00:00:00 |  |  | [NAME]
[NAME] | [NAME] | [NAME] | 2021-11-01 00:00:00 |  |  | [NAME]
[NAME] | [NAME] | CNC-Speed 13 | 2021-11-01 00:00:00 |  |  | [NAME] | 2021-12-10 00:00:00
[NAME] | [NAME] | [NAME] | 2021-09-20 00:00:00 |  |  | [NAME] | 2021-11-15 00:00:00
[NAME] | [NAME] | Polish-Auto | 2021-11-03 00:00:00 |  |  | [NAME] | 2021-12-01 00:00:00
[NAME] | [NAME] | CNC-Waterjet | 2021-10-04 00:00:00 |  |  | [NAME] | 2021-10-18 00:00:00
[NAME] | [NAME] | CNC-Waterjet | 2021-09-07 00:00:00 |  |  | [NAME] | 2021-09-21 00:00:00
[NAME] | [NAME] | [NAME] | 2021-11-16 00:00:00 |  |  | [NAME]
[NAME] | [NAME] | CNC-Juniors | 2021-10-01 00:00:00 |  |  | [NAME] | 2021-11-02 00:00:00
[NAME] | [NAME] | [NAME] | 2021-11-15 00:00:00 |  |  | [NAME]
[NAME] | [NAME] | Wrap-Buff | 2021-12-13 00:00:00 |  |  | [NAME]