tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 138464d1327675779-if-and-lookup-bid-sheet-to-po
Sheet: Sheet1

3.a.
Item | Description | Unit | Village Produce | City Produce | Country Produce | Best Bid $ | Best Company Quote | Last Price Paid
Avocados | 48 ct. | Case | 61.8 | 60.3 | 59.46 |  |  | 57.94
Cauliflower | 12 ct. | Case | 12.8 | 12.9 | 13.27 |  |  | 13.26
Cucumbers | Medium | Case | 11.1 | 11.52 | 10.91 |  |  | 11.34
Grapes | Red Seedless | [NAME] | 19.32 | 19.5 | 19.14 |  |  | 18.72
Lettuce | [NAME], 24 ct. | Case | 9.53 | 9.84 | 10.27 |  |  | 10.02
Lettuce | Romaine, 24 ct. | Case | 17.75 | 17.82 | 18.22 |  |  | 18.1
Pears | D'Anjou | Case | 20.82 | 20.58 | 20.64 |  |  | 20.62
Peppers | [NAME], Med. | Case | 8.3 | 8.38 | 9.28 |  |  | 9.02
Pineapples | 7 ct. | Case | 10.5 | 10.38 | 10.68 |  |  | 10.08
Potatoes | B Reds | 50# [NAME] | 15.06 | 14.82 | 14.88 |  |  | 14.98
Potatoes | Peeled, Large | 25# [NAME] | 17.52 | 17.22 | 17.28 |  |  | 17.18
Squash | Yellow #2 | 30# Case | 8.55 | 8.71 | 8.98 |  |  | 9.1
Strawberries | Driscoll | Flat | 18.29 | 18.06 | 17.1 |  |  | 18.3
3.b.
Item | Description | Unit | Par Value | On Hand | Special Order | Order Amount
Avocados | 48 ct. | Case | 6 | 2 | 3
Cauliflower | 12 ct. | Case | 5 | 1
Cucumbers | Medium | Case | 3 | 0
Grapes | Red Seedless | [NAME] | 4 | 1
Lettuce | [NAME], 24 ct. | Case | 5 | 2 | 4
Lettuce | Romaine, 24 ct. | Case | 3 | 0.5
Pears | D'Anjou | Case | 3 | 1
Peppers | [NAME], Med. | Case | 7 | 2 | 5
Pineapples | 7 ct. | Case | 4 | 0
Potatoes | B Reds | 50# [NAME] | 3 | 0.5
Potatoes | Peeled, Large | 25# [NAME] | 4 | 1 | 4
Squash | Yellow #2 | 30# Case | 5 | 2 | 2
Strawberries | Driscoll | Flat | 3 | 1.5
3.c.
 |  | [NAME]
Supplier |  |  |  | [NAME]
Company Name: | Village Produce |  |  | P.O. Number | 456
Street Address: | 123 Somewhere |  |  | Order Date: | 2000-01-01 00:00:00
City, State, Zip: | Village, CA 12345 |  |  | Delivery Date: | 2000-01-02 00:00:00
Phone Number: | 555-5555 |  |  | Phone Number: | 555-5557
Fax Number: | 555-5556 |  |  | Fax Number: | 555-5558
E-Mail: | [EMAIL] |  |  | E-Mail: | [EMAIL]
Contact: | Mr. [NAME] |  |  | Buyer: | Ms. [NAME]
Item | Description | Unit | Quantity | Unit Price $ | Extension
Total
Spreadsheet: 03c6474e-c8d6-4779-be34-6de058aa1aee
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 46. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (WA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413759F | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413760R | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413761T | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413762V | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413763W | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413764X | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413765A | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413766C | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413767F | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413768J | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 772528d1647345192-array-formula-in-place-of-vlookup-testsheet
Sheet: Sheet1

ID | Wk1 | Wk2 |  | ID | Week
1 |  | 0 |  | 1 | Wk1
2 |  | 0 |  | 2 | Wk1
3 |  | 0 |  | 3 | Wk1
4 |  | 0 |  | 4 | Wk1
5 |  | 0 |  | 5 | Wk1
 |  |  |  | 1 | Wk2
 |  |  |  | 2 | Wk2
 |  |  |  | 3 | Wk2
 |  |  |  | 4 | Wk2
 |  |  |  | 5 | Wk2
Spreadsheet: 215131d1361276401-formula-for-getting-count-and-value-with-a-condition-average
Sheet: Sheet1

Skill | A | B | C | D | E
% of employee > 3
No. of skilled emp. | 4
Employee
Any | 1 | 2 | 4 | 3 | 1
[NAME] | 3 | 3 |  |  | 2
Cathy |  | 3 | 3 | 5 | 3
Debu |  |  | 2 | 6 | 4
Emy | 4 |  | 1 |  | 0
Fiji | 4 | 3 | 2 | 3 | 3
Spreadsheet: 692662d1598488105-if-statement-with-multi-criteria-statement-inside-a-data-validation-list-stock-inventory-control-sample
Sheet: Sheet 4

 | LOCATIONS
 | VENDOR
 | DIVISION | [NAME] |  | Count
 | Division 1 | Location 1
 | Division 1 | Location 2
 | Division 1 | Location 3
 | Division 1 | Location 4
 | Division 1 | Location 5
 | Division 1 | Location 6
 | Division 2 | Location 1
 | Division 2 | Location 2
 | Division 2 | Location 3
 | Division 2 | Location 4
 | Division 2 | Location 5 |  | DIVISION | No: | Location
 | Division 2 | Location 6 |  | Division 1 | 1 | Location 1
 | Division 2 | Location 7 |  | Division 1 | 2 | Location 2
 |  |  |  | Division 1 | 3 | Location 3
 |  |  |  | Division 1 | 4 | Location 4
 |  |  |  | Division 1 | 5 | Location 5
 |  |  |  | Division 1 | 6 | Location 6
 |  |  |  | Division 2 | 7 | Location 1
 |  |  |  | Division 2 | 8 | Location 2
 |  |  |  | Division 2 | 9 | Location 3
 |  |  |  | Division 2 | 10 | Location 4
 |  |  |  | Division 2 | 11 | Location 5
 |  |  |  | Division 2 | 12 | Location 6
 |  |  |  | Division 2 | 13 | Location 7
Spreadsheet: rick_buy__32915__Power Prices
Sheet: Jun 20

June 20 Power Prices
Mid-Columbia
 | First Trade |  | Last Trade
 | Time | Price | Time | Price
Next-Day Pk | 08:01:28 | 87.5 | 08:33:18 | 87.5
Next-Day OffPk | 08:03:39 | 55 | 08:43:31 | 57
Balance of Month Pk | 09:35:16 | 82.5 | 12:43:44 | 80
Jul 01 Pk | 08:27:43 | 105 | 09:42:56 | 110
Aug 01 Pk | 09:59:57 | 129 | 12:16:46 | 124
NP15
 | First Trade |  | Last Trade
 | Time | Price | Time | Price
Next-Day Pk | 08:02:01 | 83 | 08:32:07 | 93
Next-Day OffPk | 08:02:45 | 52 | 08:37:41 | 59
Balance of Month Pk | 09:34:56 | 85 | 12:02:29 | 89
Balance of Month OffPk | 11:58:49 | 62 | 12:02:36 | 66
Jul 01 OffPk | 09:10:22 | 78 | 09:10:22 | 78
Aug 01 Pk | 08:40:36 | 126 | 08:50:58 | 122
Sep 01 Pk | 08:40:43 | 111 | 08:51:08 | 108
Sep 01OffPk | 12:03:16 | 77 | 14:30:19 | 79
COB
 | First Trade |  | Last Trade
 | Time | Price | Time | Price
Next-Day Pk | 08:04:00 | 87 | 08:27:51 | 90
Next-Day OffPk | 08:18:16 | 56 | 08:35:50 | 58
PALVE
 | First Trade |  | Last Trade
 | Time | Price | Time | Price
Next-Day Pk | 08:02:13 | 90 | 08:29:09 | 101
Next-Day OffPk | 08:04:31 | 30 | 08:25:36 | 37.5
Balance of Month Pk | 12:03:37 | 77.5 | 13:27:16 | 93
Balance of Month OffPk | 12:16:22 | 40 | 12:40:07 | 42
Jul 01 Pk | 08:02:10 | 110.75 | 12:26:50 | 121.25
Jul 01 OffPk | 08:47:46 | 62 | 15:17:55 | 61
Aug 01 Pk | 08:03:36 | 120.25 | 12:17:42 | 134.25
Aug 01 OffPk | 08:27:44 | 69 | 11:37:26 | 69
Sep 01 Pk | 08:45:53 | 105 | 08:45:53 | 105
Sep 01 OffPk | 11:37:28 | 63 | 13:49:44 | 67
Dec 01 OffPk | 09:36:16 | 42 | 09:36:16 | 42
SP15
 | First Trade |  | Last Trade
 | Time | Price | Time | Price
Next-Day Pk | 08:01:31 | 84.5 | 08:27:08 | 88.5
Next-Day OffPk | 08:08:02 | 36 | 08:38:35 | 43
Balance of Month Pk | 09:34:57 | 85 | 12:49:40 | 86
Jul 01 Pk | 08:34:24 | 110 | 10:15:51 | 112
Jul 01 OffPk | 15:05:30 | 64 | 15:05:30 | 64
Aug 01 OffPk | 13:19:18 | 72 | 13:19:18 | 72
Spreadsheet: 103861d1301526899-formula-to-pick-random-cell-that-is-within-desired-and-coresponding-charact-count-range-on-a-smaller-scale
Sheet: Sheet1

 |  | abcde |  | abc4
 |  | abcde
 |  | de1 | 0.5211350106489745
 |  | abcde
 |  | abcde
 |  | de2 | 0.2782665835785139
 |  | abcde
 |  | abc1 | 0.06744432458461636
 |  | abcde
 |  | abcde
 |  | de3 | 0.5820387455172251
 |  | abcde
 |  | abcde
 |  | abcde
 |  | abc2 | 0.4138467246679043
 |  | de4 | 0.6000099634879985
 |  | abcde
 |  | de5 | 0.9091784156333667
 |  | de6 | 0.2525469352939131
 |  | abc3 | 0.4747785215209872
 |  | abcde
 |  | abc4 | 0.01118685761535687
 |  | abcde
 |  | abcde
 |  | abcde
Spreadsheet: 166252d1341508177-minimum-distance-between-two-lat-long-points-book2
Sheet: Sheet2

SLC | 40.7883877778 | -111.9777730556
DEN | 39.8616666667 | -104.6731666667
ORD | 41.9816486111 | -87.9066714167
LAX | 33.9424955 | -118.4080683889
SFO | 37.6189722222 | -122.3748888889
MSP | 44.8819566667 | -93.2217655556
IAH | 29.9844336111 | -95.3414422222
PSP | 33.8296666667 | -116.5066944444
SBP | 35.2372659167 | -120.6425974167
ONT | 34.056 | -117.6011944444
SEA | 47.4498888889 | -122.3117777778
EUG | 44.1245833333 | -123.2119722222
RDM | 44.2540555556 | -121.1499722222
MKE | 42.9470795 | -87.8970625278
Spreadsheet: 766201d1643797404-count-across-multiple-columns-with-multiple-criteria-example
Sheet: Sheet1

jan |  |  |  | feb |  |  |  | march |  |  |  | april |  |  |  | april
Name | sale | percentage | membership | Name | sale | percentage | membership | Name | sale | percentage | membership | Name | sale | percentage | membership | Name | sale | percentage | membership
[NAME] | 5 | 5 | y | jasmine | 5 | 5 | y | mary | 5 | 5 | y | jasmine | 5 | 5 | y | jasmine | 5 | 5 | y
jasmine | 10 | 10 |  | [NAME] | 10 | 10 |  | mary | 10 | 10 |  | jasmine | 10 | 10 | y | jasmine | 10 | 10
jasmine | 15 | 15 |  | mary | 15 | 15 |  | mary | 15 | 15 |  | jasmine | 15 | 25 |  | mary | 15 | 15 | y
jasmine | 20 | 20 |  | mary | 20 | 20 |  | mary | 20 | 20 |  | jasmine | 20 | 20 |  | [NAME] | 20 | 20
jasmine | 25 | 25 |  | mary | 25 | 25 | y | mary | 25 | 25 |  | jasmine | 25 | 25 |  | [NAME] | 25 | 90
jasmine | 25 | 30 | y | mary | 25 | 30 | y | mary | 25 | 75 | y | mary | 25 | 30 | y | [NAME] | 25 | 95 | y
[NAME] | 25 | 35 |  | [NAME] | 25 | 35 |  | [NAME] | 25 | 35 |  | [NAME] | 25 | 35 |  | mary | 25 | 35
[NAME] | 15 | 45 |  | [NAME] | 15 | 45 |  | [NAME] | 15 | 45 | y | [NAME] | 15 | 45 |  | mary | 15 | 45
[NAME] | 20 | 50 |  | [NAME] | 20 | 50 |  | [NAME] | 20 | 50 |  | [NAME] | 20 | 50 |  | [NAME] | 20 | 50
[NAME] | 15 | 60 |  | mary | 15 | 60 |  | mary | 15 | 60 | y | mary | 15 | 60 | y | [NAME] | 15 | 60
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 15
 |  |  |  |  |  |  | 20
 |  |  |  |  |  |  | 25
 |  |  |  |  |  |  | 30
 |  |  |  |  |  |  | 35
 |  |  |  |  |  |  | 40
 |  |  |  |  |  |  | 45
 |  |  |  |  |  |  | 50
 |  |  |  |  |  |  | 55
 |  |  |  |  |  |  | 60
 |  |  |  |  |  |  | 65
 |  |  |  |  |  |  | 70
 |  |  |  |  |  |  | 75
 |  |  |  |  |  |  | 80
 |  |  |  |  |  |  | 85
 |  |  |  |  |  |  | 90
 |  |  |  |  |  |  | 95
 |  |  |  |  |  |  | 100
Spreadsheet: 115860d1311340981-vlookup-last-5-values-book1
Sheet: Sheet1

a | 99 |  |  | LookUp Value: | a
b | 27
b | 58 |  |  | Last 5 results:
b | 98 |  |  | 1 | 19
b | 13 |  |  | 2 | 49
b | 76 |  |  | 3 | 45
b | 39 |  |  | 4 | 99
b | 15 |  |  | 5
b | 44
b | 31
b | 68
b | 53
a | 45
a | 49
a | 19
Spreadsheet: 727157d1617730977-calculating-ot-for-payroll-ot-formula
Sheet: 2022 Admin Team labor estimate 

 |  | Formula = anytime total hours exceede 40 in a week to equal 40 hours @ regular rate and any amount in excess of 40 (i.e. 50 in example) calculate 1.5 times the rate
 |  |  |  |  | 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
 |  |  | total hours |  | Jan wk 1 | Jan wk 2 | Jan wk 3 | Jan wk 4 | Jan wk 5 | Feb wk 1 | Feb wk 2 | Feb wk 3 | Feb wk 4 | March wk 1 | March wk 2 | March wk 3 | March wk 4 | April wk 1 | April wk 2 | April wk 3 | April wk 4 | May wk 1 | May wk 2 | May wk 3 | May wk 4 | May wk 5 | June wk 1 | June wk 2 | June wk 3 | June wk 4
Administrative Support |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 45 | 40 | 40 | 45 | 40 | 40
Administrative Support
 | rate
 | 19.5
 | 19.5
 |  |  |  |  | 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
 |  |  |  |  | July wk 1 | July wk 2 | July wk 3 | July wk 4 | Aug wk 1 | Aug wk 2 2022 | Aug wk 3 | Aug wk 4 | Aug wk 5 | Sept wk 1 | Sept wk 2 | Sept wk 3 | Sept wk 4 | Oct wk 1 | Oct wk 2 | Oct wk 3 | Oct wk 4 | Oct wk 5 | Nov wk 1 | Nov wk 2 | Nov wk 3 | Nov wk 4 | Dec wk 1 | Dec wk 2 | Dec wk 3 | Dec wk 4 |  | Primary staffing total |  | General staffing total
 |  |  |  |  | 40 | 40 | 40 | 40 | 50 | 50 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 50 | 50 | 40 | 40 | 40 | 40 | 40 | 40 | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 50 | 50 | 40 | 40 | 40 | 40 | 0 | 0 | 0
 |  |  |  |  |  |  | Answer w long fomula
Spreadsheet: 883575d1732195807-having-issue-with-countifs-referencing-array-formula-in-a-let-formula-let_countifs-issue-forum
Sheet: Report

Name | Same Day? | Job Type | Date Cancelled | Appointment Date | Comment
 |  | Revenue | 2024-10-01 00:00:00 | 2024-10-01 00:00:00
 |  | Revenue | 2024-10-01 00:00:00 | 2024-10-01 00:00:00 | First is that one is the return and the lines that is front of the plenum are the refrigerant lines and I can put the yellow thing because no space. The other unit is piped and walled in in the basement so no access to the plenum or to remove the filter.
 |  | Revenue | 2024-10-01 00:00:00 | 2024-10-01 00:00:00 | Should not have been booked.
 |  | Revenue | 2024-10-01 00:00:00 | 2024-10-01 00:00:00
 |  | Revenue | 2024-10-01 00:00:00 | 2024-10-01 00:00:00 | No access to plenum. @Name1
 |  | Revenue | 2024-10-01 00:00:00 | 2024-10-01 00:00:00 | Need to get access to plenums. They didn't want to just go from the registers
 |  | Revenue | 2024-10-02 00:00:00 | 2024-10-02 00:00:00 | Don’t have access to return Customer only wanted dryer vent done if there was a bundle. @Name2
 |  | Revenue | 2024-10-02 00:00:00 | 2024-10-04 00:00:00 | kept cancelling not right time to get service done
 |  | Revenue | 2024-10-02 00:00:00 | 2024-10-12 00:00:00 | will call back to r/s
 |  | Revenue | 2024-10-02 00:00:00 | 2024-10-02 00:00:00 | Gooing to have a line removed or swapped and call us back to schedule.
 |  | Revenue | 2024-10-02 00:00:00 | 2024-10-02 00:00:00 | No access to the supply. @Name1
 |  | Revenue | 2024-10-03 00:00:00 | 2024-10-05 00:00:00 | Messaged Need to cancel
 |  | Revenue | 2024-10-03 00:00:00 | 2024-10-04 00:00:00 | [NAME] left a vm to cancel.
 |  | Revenue | 2024-10-03 00:00:00 | 2024-10-05 00:00:00
 |  | Revenue | 2024-10-03 00:00:00 | 2024-10-12 00:00:00
 |  | Revenue | 2024-10-03 00:00:00 | 2024-10-03 00:00:00 | Dryer vent is all flex, and in bad shape.  Wants to hold off on the ducts for now as well @Name3
 |  | Revenue | 2024-10-03 00:00:00 | 2024-10-04 00:00:00 | cust didn't want to have hole cut
 |  | Revenue | 2024-10-03 00:00:00 | 2024-10-03 00:00:00 | Lines were added on when additional room @Name4
 |  | Revenue | 2024-10-03 00:00:00 | 2024-10-04 00:00:00
 |  | Revenue | 2024-10-04 00:00:00 | 2024-10-04 00:00:00 | Growth in system.  Calling insurance company.  @Name5
 |  | Revenue | 2024-10-04 00:00:00 | 2024-10-11 00:00:00
 |  | Revenue | 2024-10-04 00:00:00 | 2024-10-04 00:00:00 | No access on plenums @Name1
 |  | Revenue | 2024-10-04 00:00:00 | 2024-11-04 00:00:00
 |  | Revenue | 2024-10-04 00:00:00 | 2024-10-04 00:00:00 | too high... about 30 ft.  Client didn't want it cleaned   @Name6
 |  | Revenue | 2024-10-04 00:00:00 | 2024-10-04 00:00:00 | Customer doesn't want door open for service, so cancelled.
 |  | Revenue | 2024-10-04 00:00:00 | 2024-10-04 00:00:00 | Waited 30 min
 |  | Revenue | 2024-10-04 00:00:00 | 2024-10-07 00:00:00 | threw her back out
 |  | Revenue | 2024-10-04 00:00:00 | 2024-10-05 00:00:00
Spreadsheet: 117492d1312826986-excel-chart-help-vi-need-help-in-making-chart-chart-should-take-the-last-12-value-data-modified
Sheet: Data_Monthly

Month | [NAME] (in GB)
2010-01-01 00:00:00 | 1
2010-02-01 00:00:00 | 2 |  |  |  | output
2010-03-01 00:00:00 | 3 |  |  |  | 10 | lowerlimit | =MAX(ROW(Data_Monthly!$A$1)+2,COUNTA(Data_Monthly!$A:$A)-12+2)
2010-04-01 00:00:00 | 3 |  |  |  | 20 | count | =MAX(ROW(Data_Monthly!$A$1)+1,COUNTA(Data_Monthly!$A:$A))
2010-05-01 00:00:00 | 4 |  |  |  | Error | Month | =INDEX(Data_Monthly!$A:$A,lowerlimit):INDEX(Data_Monthly!$A:$A,count)
2010-06-01 00:00:00 | 4 |  |  |  | Error | [NAME] (in GB) | =INDEX(Data_Monthly!$B:$B,lowerlimit):INDEX(Data_Monthly!$B:$B,count)
2010-07-01 00:00:00 | 4
2010-08-01 00:00:00 | 6
2010-09-01 00:00:00 | 7
2010-10-01 00:00:00 | 7
2010-11-01 00:00:00 | 5
2010-12-01 00:00:00 | 4
2011-01-01 00:00:00 | 7
2011-02-01 00:00:00 | 1
2011-03-01 00:00:00 | 6
2011-04-01 00:00:00 | 12
2011-05-01 00:00:00 | 4
2011-06-01 00:00:00 | 5
2011-07-01 00:00:00 | 7
Spreadsheet: 268865d1380868876-auto-transfer-some-information-from-stock-ledger-to-party-ledger-dg-accounts
Sheet: Party - A

 |  |  | PARTY: |  |  |  | A
 | INVOICE | DATE | [NAME] |  | QTY | RATE | AMOUNT | RECEIPT | C.B |  |  |  |  |  | Party Name
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select
 | 25 |  |  |  |  | 300 |  |  |  |  |  |  |  |  | A
 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  | B
 | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PURCHASE
Spreadsheet: 24367d1214578509-get-data-from-several-closed-xls-files-read_file-version-with-input
Sheet: User

 | Message : | -- HELLO --
 | Directory : | D:\Documents and Settings\801847231\My Documents\xl bits and bobs
 | This File : | Read_File version with input.xls
 | Working Sheet : | Circuit Details
 | RANGE TO EXTRACT
 | FROM | A22 |  | 1
 | TO | a24 |  | A22:a24
 |  |  |  | True
 |  | this will extract a range from multiple workbooks in the same folder
 |  | providing a)you want the same range from each and a) the tab is named the same  and c)only those workbooks  and this one are  in the same folder
 | 1 | put all files in one folder
 | 2 | change path to match folder (C3)
 | 3 | put exact name of sheet tab you wish to copy  in C7
 | 4 | input start and end of range to copy
 | 5 | click init
 | 6 | click treat file wait till finished
 | note | if it’s a single column it will transpose data from each sheet to a row
 |  | if it’s a single row or a range of rows it will put them one under the other
 |  | output is on sheet "data"
 |  | THIS IS NOT MY ORIGINAL IDEA
 |  | I MODIFIED IT FROM A COPY I THINK CAME FROM OZ GRID
Spreadsheet: 284e4056-6a44-439c-9439-dbbddbf52787
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-06-16 09:54:15.690000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.75 | 101.291 | 101.166 | 101.041 | 100.666
4.625 | 100.562 | 100.437 | 100.312 | 99.937 |  | Note: | Refer To Price [NAME]
4.5 | 100.047 | 99.922 | 99.797 | 99.422 |  |  | For all Price Adjs
4.375 | 99.438 | 99.313 | 99.188
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.435 | 101.31 | 101.185 | 100.81
4 | 101.083 | 100.958 | 100.833 | 100.458
3.875 | 100.68 | 100.555 | 100.43 | 100.055
3.75 | 100.114 | 99.989 | 99.864 | 99.489
3.625 | 99.156 | 99.031 | 98.906
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-06-30 09:54:15.690000
30 DAY | 2011-07-15 09:54:15.690000
45 DAY | 2011-07-30 09:54:15.690000
60 DAY | 2011-08-14 09:54:15.690000
90 DAY | 2011-09-13 09:54:15.690000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 781120d1652992054-getting-an-hourly-breakdown-of-labour-from-start-and-end-times-hourlylabour-3-
Sheet: Timecard with Payroll Report (6

First Name | In time | Out time | Hours |  |  | 1900-04-09 05:00:00
[NAME] | 2022-04-24 09:00:00 | 2022-04-24 16:30:00 | 7.5 |  |  | 1900-04-09 06:00:00
[NAME] | 2022-04-24 10:00:00 | 2022-04-24 16:30:00 | 6.5 |  |  | 1900-04-09 07:00:00
Zac | 2022-04-24 11:00:00 | 2022-04-24 21:30:00 | 10.5 |  |  | 1900-04-09 08:00:00
Crystal | 2022-04-24 13:00:00 | 2022-04-24 20:30:00 | 7.5 |  |  | 1900-04-09 09:00:00 |  |  | 1
[NAME] | 2022-04-24 13:45:00 | 2022-04-24 22:00:00 | 8.25 |  |  | 1900-04-09 10:00:00 |  |  | 2
[NAME] | 2022-04-24 15:00:00 | 2022-04-24 21:30:00 | 6.5 |  |  | 1900-04-09 11:00:00 |  |  | 3
[NAME] | 2022-04-24 16:45:00 | 2022-04-24 23:00:00 | 6.25 |  |  | 1900-04-09 12:00:00 |  |  | 3
[NAME] | 2022-04-24 17:00:00 | 2022-04-24 21:30:00 | 4.5 |  |  | 1900-04-09 13:00:00 |  |  | 4.25
Sara | 2022-04-24 18:00:00 | 2022-04-25 01:30:00 | 7.5 |  |  | 1900-04-09 14:00:00 |  |  | 5
 |  |  |  |  |  | 1900-04-09 15:00:00 |  |  | 6
 |  |  |  |  |  | 1900-04-09 16:00:00 |  |  | 5.25
 |  |  |  |  |  | 1900-04-09 17:00:00 |  |  | 6
 |  |  |  |  |  | 1900-04-09 18:00:00 |  |  | 7
 |  |  |  |  |  | 1900-04-09 19:00:00 |  |  | 7
 |  |  |  |  |  | 1900-04-09 20:00:00 |  |  | 6.5
 |  |  |  |  |  | 1900-04-09 21:00:00 |  |  | 4.5
 |  |  |  |  |  | 1900-04-09 22:00:00 |  |  | 2
 |  |  |  |  |  | 1900-04-09 23:00:00 |  |  | 1
 |  |  |  |  |  | 1900-04-10 00:00:00 |  |  | 1
 |  |  |  |  |  | 1900-04-09 01:00:00 |  |  | 0.5
 |  |  |  |  |  | 1900-04-09 02:00:00
 |  |  |  |  |  | 1900-04-09 03:00:00
 |  |  |  |  |  | 1900-04-09 04:00:00